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

Generate JSON for utility Bills

asked 6 years ago

Vishak's avatar

updated 6 years ago

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?

Thanks

Preview: (hide)

Comments

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  ( 6 years ago )

1 Answer

Sort by » oldest newest most voted
4

answered 6 years ago

updated 6 years ago

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

Preview: (hide)
link

Comments

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

David Goldwasser's avatar David Goldwasser  ( 6 years ago )

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

MatthewSteen's avatar MatthewSteen  ( 6 years ago )

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  ( 6 years ago )

Your Answer

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

Add Answer

Training Workshops

Careers

Question Tools

1 follower

Stats

Asked: 6 years ago

Seen: 416 times

Last updated: Jun 04 '18