Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

Generate JSON for utility Bills

asked 2018-06-03 18:57:45 -0600

Vishak's avatar

updated 2018-06-04 07:49:28 -0600

Dear All, I am following a NREL monthly calibration model that I sourced from Github. It requires a JSON file of utility bill values to import into Parametric Analysis tool and I am trying to replicate the process using measures that I need.

To do that, I am trying to generate a JSON file of utility bill values.The values were input in the OpenStudio model manually. I tried creating an output variable using the name of the utility bill for electric and gas, but a JSON file has not been exported. Am I missing something? is there a measure to specifically output a JSON file containing utility bill values or is there some other process to accomplish that?


edit retag flag offensive close merge delete


Thanks @MatthewSteen for your answer. Tagging @BrianLBall and @David Goldwasser here again. Is there a messaging service here to reach out to them?

Vishak's avatar Vishak  ( 2018-06-04 11:33:21 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2018-06-03 21:16:40 -0600

updated 2018-06-04 09:44:57 -0600

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

edit flag offensive delete link more


@Vishak, I'll send you an email to follow up.

David Goldwasser's avatar David Goldwasser  ( 2018-06-04 11:18:23 -0600 )edit

@Vishak looks like there's a public NREL repo with an AddMonthlyJSONUtilityData measure you can try.

MatthewSteen's avatar MatthewSteen  ( 2018-06-05 16:59:38 -0600 )edit

Thanks Matthew. I actually found the measure in one if the sample PAT projects. I just copied that to 'my measures' directory and have continued using from there.

Vishak's avatar Vishak  ( 2018-06-05 17:57:24 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer


Question Tools

1 follower


Asked: 2018-06-03 18:57:45 -0600

Seen: 303 times

Last updated: Jun 04 '18