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

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 OutputsIncluded open_studio_results.annual_cost_total sheet I've included the following in the Measure/Variable Unique Name column (D).of the Outputs sheet.

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.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
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:

Modified the open_studio_results reporting measure to include a runner.registerValue statement in the run method.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 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:

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 folder.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: