Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

table:lookup external file name

asked 2023-12-21 04:56:51 -0500

updated 2023-12-22 09:23:18 -0500

I am trying to use the Table:Lookup object with a link to external csv file. The InputOutput reference and Engineering reference does not show an example for this. How do I name the file and where do I put it? No matter what value I put in the field !- External File Name OpenStudio seems to delete it.

 {9eed7d77-62eb-495e-9bea-ea44b3858990}, !- Handle
 Table M Variable Lookup P72TNU_YNU,     !- Name
 {b141d15d-7390-419d-9adc-ed54aa376acf}, !- Independent Variable List Name
 DivisorOnly,                            !- Normalization Method
 1,                                      !- Normalization Divisor
 0.38,                                   !- Minimum Output {BasedOnField A5}
 1.243,                                  !- Maximum Output {BasedOnField A5}
 Dimensionless,                          !- Output Unit Type
 ,                                       !- External File Name
 3,                                      !- External File Column Number
 1;                                      !- External File Starting Row Number
edit retag flag offensive close merge delete


@Ski90Moo are you defining this lookup table via an OpenStudio measure? If so, it would help to share the measure.rb file so that others can check it's contents.

Not writing the external file name correctly might be a bug in the OpenStudio SDK, meaning that this should be done with an EnergyPlus measure instead. If that's the case, you can use the EnergyPlus example file that @Keigo mentioned in their answer.

Aaron Boranian's avatar Aaron Boranian  ( 2023-12-21 09:12:59 -0500 )edit

I am directly editing the .osm file. I am not using any measures.

Ski90Moo's avatar Ski90Moo  ( 2023-12-22 01:27:33 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2023-12-21 07:41:04 -0500

Keigo's avatar

You tagged energyplus, so idf files should also be helpful as examples.

One ExampleFile in your PC is LookupTables.idf with LookupTable.csv.

edit flag offensive delete link more


Thank you @Keigo. This is how I am inputting the information, but it seems that OpenStudio is deleting it. As @Aaron Boranian noted, it must be a bug with the SDK.

Ski90Moo's avatar Ski90Moo  ( 2023-12-22 01:39:48 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops


Question Tools

1 follower


Asked: 2023-12-21 04:56:51 -0500

Seen: 26 times

Last updated: Dec 21 '23