Revision history [back]

I have data points for power for a piece of equipment in terms of Outdoor Air Temperature Drybulb and Outdoor Air Temperature Wetbulb that is a bit sparse. I'm trying to use the Table:TwoIndependentVariables to modify the schedule of an ElectricEquipment using EMS to include the energy usage in the simulation. I have been able to get the IDF file to simulate, but I have been able to output at all correct results. (Usually the same value for the entire simulation.) The documentation needs some updating in the IO Reference, but otherwise the Table:TwoIndependentVariables is fairly straightforward to use. This makes me think that I'm trying to use the object past its capabilities. For instance, my data points are sparse so the interpolation will often be in the middle of a square with the corners having known x,y input and z output.

Can the Table:TwoIndependentVariables do what I need? If yes, I'll try to make a minimal working example of the behavior. If not, could you please recommend another method? I'll provide more detail about what I'm trying to do in that case.

I have data points for power for a piece of equipment in terms of Outdoor Air Temperature Drybulb and Outdoor Air Temperature Wetbulb that is a bit sparse. I'm trying to use the Table:TwoIndependentVariables to modify the schedule of an ElectricEquipment using EMS to include the energy usage in the simulation. I have been able to get the IDF file to simulate, but I have been able to output at all correct results. (Usually the same value for the entire simulation.) The documentation needs some updating in the IO Reference, but otherwise the Table:TwoIndependentVariables is fairly straightforward to use. This makes me think that I'm trying to use the object past its capabilities. For instance, my data points are sparse so the interpolation will often be in the middle of a square with the corners having known x,y input and z output.

Can the Table:TwoIndependentVariables do what I need? If yes, I'll try to make a minimal working example of the behavior. If not, could you please recommend another method? I'll provide more detail about what I'm trying to do in that case.

I have data points for power for a piece of equipment in terms of Outdoor Air Temperature Drybulb and Outdoor Air Temperature Wetbulb that is a bit sparse. I'm trying to use the Table:TwoIndependentVariables to modify the schedule of an ElectricEquipment using EMS to include the energy usage in the simulation. I have been able to get the IDF file to simulate, but I have been able to output at all correct results. (Usually the same value for the entire simulation.) The documentation needs some updating in the IO Reference, but otherwise the Table:TwoIndependentVariables is fairly straightforward to use. This makes me think that I'm trying to use the object past its capabilities. For instance, my data points are sparse so the interpolation will often be in the middle of a square with the corners having known x,y input and z output.

Can the Table:TwoIndependentVariables do what I need? If yes, I'll try to make a minimal working example of the behavior. If not, could you please recommend another method? I'll provide more detail about what I'm trying to do in that case.

Here is a link to a google drive zip file, which has a fairly minimal working example. A couple small details I should point out: the datacenter.csv file has a comma after the last value instead of a semicolon as in the documentation, and I have dummy variables going into the EMS @CurveValue inputs which might not be necessary. There is an output variable for the modified schedule and ElectricEquipment Watts. The schedule is set to 0 (zero) for the simulation, so the EMS is changing the schedule value, but the value is 1 (one) for the whole simulation.

I have data points for power for a piece of equipment in terms of Outdoor Air Temperature Drybulb and Outdoor Air Temperature Wetbulb that is a bit sparse. I'm trying to use the Table:TwoIndependentVariables to modify the schedule of an ElectricEquipment using EMS to include the energy usage in the simulation. I have been able to get the IDF file to simulate, but I have been able to output at all correct results. (Usually the same value for the entire simulation.) The documentation needs some updating in the IO Reference, but otherwise the Table:TwoIndependentVariables is fairly straightforward to use. This makes me think that I'm trying to use the object past its capabilities. For instance, my data points are sparse so the interpolation will often be in the middle of a square with the corners having known x,y input and z output.

Can the Table:TwoIndependentVariables do what I need? If yes, I'll try to make a minimal working example of the behavior. If not, could you please recommend another method? I'll provide more detail about what I'm trying to do in that case.

Here is a link to a google drive zip file, which has a fairly minimal working example. A couple small details I should point out: the datacenter.csv file has a comma after the last value instead of a semicolon as in the documentation, and I have dummy variables going into the EMS @CurveValue inputs which might not be necessary. There is an output variable for the modified schedule and ElectricEquipment Watts. The schedule is set to 0 (zero) for the simulation, so the EMS is changing the schedule value, but the value is 1 (one) for the whole simulation.

POST SCRIPT
Make sure to use a "complete data set" and read the Interpolation Method field very carefully in the IO Reference. The documentation for this object does need to be cleaned up as of August 2019, as well as generating an error or warning for data sets that are not a complete, equally spaced XY grid.