Revision history [back]

I've used the following for calibration in OpenStudio.

1. @julien marrec's Useful-Excel-Macros-for-Energy-Modeling, which I used to export a JSON file for electricity and gas from an Excel table.

   • The link is to my json_validation fork where I made some changes so that the exported files produced valid JSON files.
   • If you can get the utility data in the right format in Excel, it can be exported to a JSON file that the following measure will use to import into OpenStudio.

2. NREL's AddMonthlyUtilityData measure, which is currently hosted in a private repository. Contact the developers if you'd like a copy (I think @brianlball or @davidgoldwasser wrote it).

I've used the following for calibration in OpenStudio.

1. @julien marrec's Useful-Excel-Macros-for-Energy-Modeling, which I used to export a JSON file for electricity and gas from an Excel table.

   • The link is to my json_validation fork where I made some changes so that the exported files it produced valid JSON files.
   • If you can get the utility data in the right format in Excel, it can be exported to a JSON file that the following measure will use to import into OpenStudio.

2. NREL's AddMonthlyUtilityData measure, which is currently hosted in a private repository. Contact the developers if you'd like a copy (I think @brianlball or @davidgoldwasser wrote it).

I've used the following for calibration in OpenStudio.

1. @julien marrec's Useful-Excel-Macros-for-Energy-Modeling, which I used to export a JSON file for electricity and gas from an Excel table.

   • The link is to my json_validation fork branch where I made some changes so that it produced valid JSON files.
   • If you can get the utility data in the right format in Excel, it can be exported to a JSON file that the following measure will use to import into OpenStudio.

2. NREL's AddMonthlyUtilityData measure, which is currently hosted in a private repository. Contact the developers if you'd like a copy (I think @brianlball or @davidgoldwasser wrote it).

I've used the following for calibration in OpenStudio.

1. @julien marrec's Useful-Excel-Macros-for-Energy-Modeling, which I used to export a JSON file for electricity and gas from an Excel table.

   • The link is to my json_validation branch where I made some changes so that it produced valid JSON files.
   • If you can get the utility data in the right format in Excel, it can be exported to a JSON file that the following measure will use to import into OpenStudio.

2. NREL's AddMonthlyUtilityData measure, which is currently hosted in a private repository. Contact the developers if you'd like a copy (I think @brianlball or @davidgoldwasser @david goldwasser wrote it).

I've used the following for calibration in OpenStudio.

1. @julien marrec's Useful-Excel-Macros-for-Energy-Modeling, which I used to export a JSON file for electricity and gas from an Excel table.

   • The link is to my json_validation branch where I made some changes so that it produced produces valid JSON files.
   • If you can get the utility data in the right format in Excel, it can be exported to a JSON file that the following measure will use to import into OpenStudio.

2. NREL's AddMonthlyUtilityData measure, which is currently hosted in a private repository. Contact the developers if you'd like a copy (I think @brianlball or @david goldwasser wrote it).