HB-Energy Primer
Ladybug Tools for Grasshopper Documentation
  • HB-Energy Primer
  • Components
    • 0 :: Basic Properties
      • Building Vintages
      • Climate Zones
      • Face Energy Attributes
      • Room Energy Attributes
      • Blend ProgramTypes
      • Building Programs
      • ProgramType
      • Search Programs
      • ConstructionSet
      • Construction Set by Climate
      • Construction Types
      • Search Construction Sets
      • Exterior Construction Subset
      • Ground Construction Subset
      • Interior Construction Subset
      • Subface Subset
      • Adiabatic by Type
      • Plenum
      • Ground
      • Internal Mass
      • Other Side Temperature
      • Patch Missing Adjacency
    • 1 :: Constructions
      • Search Constructions
      • Search Materials
      • Deconstruct Construction
      • Deconstruct ConstructionSet
      • Deconstruct ConstructionSet Interior
      • Deconstruct Material
      • Apply ConstructionSet
      • Apply Opaque Construction
      • Apply Shade Construction
      • Apply Window Construction
      • Opaque Construction
      • Shade Construction
      • Window Construction
      • Window Construction Shade
      • Opaque Material
      • Opaque Material No Mass
      • Glass Material
      • Shade Material
      • Window Frame
      • Window Material
      • Blind Material
      • Custom Window Gap Material
      • Vegetation Material
      • Window Construction Dynamic
      • Window Gap Material
    • 2 :: Schedules
      • Gene Pool to Day Schedule
      • Search Schedules
      • Deconstruct Schedule
      • Schedule to Data
      • Apply Room Schedules
      • Apply Shade Schedule
      • Constant Schedule
      • Fixed Interval Schedule
      • Seasonal Schedule
      • Weekly Schedule
      • Type Limit
    • 3 :: Loads
      • Apply ProgramType
      • Deconstruct ProgramType
      • Apply Absolute Load Values
      • Apply Daylight Control
      • Apply Load Values
      • Apply Setpoint Values
      • Equipment
      • Infiltration
      • Lighting
      • People
      • Process Load
      • Service Hot Water
      • Setpoint
      • Ventilation
      • Airflow Newtwork
      • Fan Ventilation
      • Ventilation Control
      • Window Opening
      • Blower Pressure Converter
      • Deconstruct Equipment
      • Deconstruct Hot Water
      • Deconstruct Infiltration
      • Deconstruct Lighting
      • Deconstruct People
      • Deconstruct Setpoint
      • Deconstruct Ventilation
    • 4 :: HVAC
      • IdealAir
      • Set Conditioned
      • All-Air HVAC
      • All-Air HVAC Templates
      • DOAS HVAC
      • DOAS HVAC Templates
      • HeatCool HVAC
      • HeatCool HVAC Templates
      • SHW System
      • SHW Templates
      • Electric Load Center
      • Photovoltaic Properties
      • Detailed HVAC
      • Radiant HVAC Properties
    • 5 :: Simulate
      • Model to OSM
      • Annual Loads
      • Generation Loads
      • Load Shade Benefit
      • Peak Loads
      • Custom Simulation Output
      • Shadow Calculation
      • Simulation Control
      • Simulation Output
      • Simulation Parameter
      • Sizing Parameter
      • Load Measure
      • Run OSW
      • Run IDF
      • Run OSM
      • Create OSM Measure
    • 6 :: Result
      • End Use Intensity
      • Read Custom Result
      • Read Face Result
      • Read HVAC Sizing
      • Read Room Comfort Result
      • Read Room Energy Result
      • Color Faces
      • Color Rooms
      • Read Tabular Data
      • Thermal Load Balance
      • Balance Temperature
      • Carbon Emission Intensity
      • Face Result by Type
      • Normalize by Floor Area
      • Read Generation Result
      • Read Result Dictionary
      • Read Zone Sizing
    • 7 :: Thermal Map
      • Adaptive Comfort Map
      • PMV Comfort Map
      • UTCI Comfort Map
      • Read Thermal Matrix
      • Visualize Thermal Map
      • Read Environment Matrix
Powered by GitBook
On this page
  • Inputs
  • Outputs
Export as PDF
  1. Components
  2. 6 :: Result

Read Tabular Data

PreviousColor RoomsNextThermal Load Balance

Last updated 3 years ago

-

Get all the data within a table of a Summary Report using the table name.

All of the avaialable tables can be browsed by opening the .html output from the simulation in a web browser.

Inputs

  • sql [Required]

    The file path of the SQL result file that has been generated from an energy simulation.

  • table_name [Required]

    Text string for the name of a table of a Summary Report. Examples include: General, Utility Use Per Conditioned Floor Area, and many more options that can be browsed in the .html file.

Outputs

  • values

    A data tree represening the table matrix, with each branch (sub-list) of the tree representing a row of the table and each index of each branch corresponding to a value in a column. The order of outputs should reflect how the table appears in the HTML output. Note that any energy values in MJ or GJ in the .html output will automatically be converted to kWh on import.

  • col_names

    A list of text for the names of each of the columns in the table. These order of this list corresponds directly to the order of items each of the values sub-list

  • row_names

    A list of text for the names of each of the rows of the table. Each name in this list corresponds to a branch in the output values data tree.

[source code]