Revision history [back]

I've successfully run several analyses using the spreadsheet. However, I have not been able to include specific outputs other than the ones from the template.xlsx file. The documentation lacks a detailed description for setting up this sheet so I was hoping to fill in some blanks. Here's what I've done so far:

1. Modified the open_studio_results reporting measure to include a runner.registerValue statement for total energy cost.

   query = "SELECT Value FROM TabularDataWithStrings WHERE ReportName = 'Economics Results Summary Report' AND ReportForString = 'Entire Facility' AND TableName = 'Annual Cost' AND RowName = 'Cost' AND ColumnName = 'Total'" value = sqlFile.execAndReturnFirstDouble(query).get return runner.registerValue("annual_cost_total", value)

2. Included it in the measures folder

3. Included open_studio_results.annual_cost_total in the Measure/Variable Unique Name column of the Outputs sheet.

I've successfully run several analyses using the spreadsheet. However, I have not been able to include specific outputs other than the ones from the template.xlsx file. The documentation lacks a detailed description for setting up this sheet so I was hoping to fill in some blanks. Here's what I've done so far:

I've successfully run several analyses using the spreadsheet. However, I have not been able to include specific outputs other than the ones from the template.xlsx file. The documentation lacks a detailed description for setting up this sheet so I was hoping to fill in some blanks. Here's what I've done so far:

Modified the open_studio_results reporting measure to include a runner.registerValue statement for total energy cost.

query = "SELECT Value FROM TabularDataWithStrings WHERE ReportName = 'Economics Results Summary Report' AND ReportForString = 'Entire Facility' AND TableName = 'Annual Cost' AND RowName = 'Cost' AND ColumnName = 'Total'"
value = sqlFile.execAndReturnFirstDouble(query).get
return runner.registerValue("annual_cost_total", value)

Included it in the measures folderfolder.

Included open_studio_results.annual_cost_total in the Measure/Variable Unique Name column of the Outputs sheet.

I've successfully run several analyses using the spreadsheet. However, I have not been able to include specific outputs other than the ones from the template.xlsx file. The documentation lacks a detailed description for setting up this sheet so I was hoping to fill in some blanks. Here's what I've done so far:

Modified the open_studio_results reporting measure to include a runner.registerValue statement for total energy cost.in the run method.

query = "SELECT Value FROM TabularDataWithStrings WHERE ReportName = 'Economics Results Summary Report' AND ReportForString = 'Entire Facility' AND TableName = 'Annual Cost' AND RowName = 'Cost' AND ColumnName = 'Total'"
value = sqlFile.execAndReturnFirstDouble(query).get
return runner.registerValue("annual_cost_total", value)

Included it in the measures folder.

Included open_studio_results.annual_cost_total in the Measure/Variable Unique Name column of the Outputs sheet.

I've successfully run several analyses using the spreadsheet. However, I have not been able to include specific outputs other than the ones from the template.xlsx file. The documentation lacks a detailed description for setting up this sheet so I was hoping to fill in some blanks. Here's what I've done so far:

1) Modified the open_studio_results reporting measure to include a runner.registerValue statement in the run method.method. The SQL query has been tested and returns the correct value.

query = "SELECT Value FROM TabularDataWithStrings WHERE ReportName = 'Economics Results Summary Report' AND ReportForString = 'Entire Facility' AND TableName = 'Annual Cost' AND RowName = 'Cost' AND ColumnName = 'Total'"
value = sqlFile.execAndReturnFirstDouble(query).get
runner.registerValue("annual_cost_total", value)

2) Included it in the measures folder.

3) Included open_studio_results.annual_cost_total in the Measure/Variable Unique Name column of the Outputs sheet.

I've successfully run several analyses using the spreadsheet. However, I have not been able to include specific outputs other than the ones from the template.xlsx file. The documentation lacks a detailed description for setting up this sheet so I was hoping to fill in some blanks. Here's what I've done so far:

1) Modified the open_studio_results reporting measure to include a runner.registerValue statement in the run method. The SQL query has been tested and returns the correct value.

query = "SELECT Value FROM TabularDataWithStrings WHERE ReportName = 'Economics Results Summary Report' AND ReportForString = 'Entire Facility' AND TableName = 'Annual Cost' AND RowName = 'Cost' AND ColumnName = 'Total'"
value = sqlFile.execAndReturnFirstDouble(query).get
runner.registerValue("annual_cost_total", value)

2) Included it in the measures folder.

3) Included open_studio_results.annual_cost_totalOn the Outputs sheet I've included the following in the Measure/Variable Unique Name column of the Outputs sheet.(D).

open_studio_results.annual_cost_total

I've successfully run several analyses using the spreadsheet. However, I have not been able to include specific outputs other than the ones from the template.xlsx file. The documentation lacks a detailed description for setting up this sheet so I was hoping to fill in some blanks. Here's what I've done so far:

1) Modified the open_studio_results reporting measure to include a runner.registerValue statement in the run method. The SQL query has been tested and returns the correct value.

query = "SELECT Value FROM TabularDataWithStrings WHERE ReportName = 'Economics Results Summary Report' AND ReportForString = 'Entire Facility' AND TableName = 'Annual Cost' AND RowName = 'Cost' AND ColumnName = 'Total'"
value = sqlFile.execAndReturnFirstDouble(query).get
runner.registerValue("annual_cost_total", value)

2) Included it in the measures folder.

3) On the Outputs sheet I've included the following in the Measure/Variable Unique Name column (D).

open_studio_results.annual_cost_total