1

table:lookup external file name

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.

OS:Table:Lookup,
 {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
Ski90Moo's avatar
869
Ski90Moo
asked 2023-12-21 04:56:51 -0500
Aaron Boranian's avatar
14.1k
Aaron Boranian
updated 2023-12-22 09:23:18 -0500
edit flag offensive 0 remove flag close merge delete

Comments

@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
add a comment see more comments

1 Answer

0

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

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

Keigo's avatar
4k
Keigo
answered 2023-12-21 07:41:04 -0500
edit flag offensive 0 remove flag delete link

Comments

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
add a comment see more comments