how to edit idf files using the excel software?

asked 2018-11-14 04:10:48 -0600

Hi all, I am doing building energy modeling using energyplus. The data that I gathered is many because of the big building that I modeled. Now, I found difficulty in editing and making schedules in the idf editor because of the many data. Is there a way I can edit values or input values using the MS Excel software? I would like to ask for help. Thank You and God Bless.

edit retag flag offensive close merge delete

add a comment

3 Answers

Sort by » oldest newest most voted

answered 2018-11-14 09:04:58 -0600

JasonGlazer

6905 ●26 ●12 http://www.gard.com/

You might want to use Schedule:File object instead. See here

edit flag offensive delete link

Comments

thank you for your advised Sir Jason, I will try working that way.

Philip Caesar Ebit ( 2018-11-14 18:32:32 -0600 )edit

add a comment

answered 2018-11-14 04:51:22 -0600

adambgnr

759 ●1 ●2 ●7 http://www.linkedin.co...

updated 2018-11-14 04:52:23 -0600

You can find plenty of ideas here and here.

edit flag offensive delete link

Comments

thank you Adam for you answer. I downloaded the macro file and installed it in my excel software, but when I used it there is an error in copying to clipboard. Is there any way how to fix this? And one thing also, I see in the program that it need this References: Microsoft Forms Object 2.0, needed for using the Clipboard, what will I do to have this?

Philip Caesar Ebit ( 2018-11-14 18:31:08 -0600 )edit

If all you need to edit in the IDF is the schedules, go with Jason's suggestion. That is a more straightforward way to do it.

adambgnr ( 2018-11-15 02:49:21 -0600 )edit

add a comment

answered 2019-09-24 16:28:34 -0600

PeterSchild
21 ●1

Try EpXL (EnergyPlus-Excel). It's an Excel-based alternative to both IDF Editor and EP Launch. It can handle large models. EpXL's homepage is https://github.com/SchildCode/EpXL