1

how to edit idf files using the excel software?

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.

Philip Caesar Ebit's avatar
181
Philip Caesar Ebit
asked 2018-11-14 04:10:48 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

3 Answers

1

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

JasonGlazer's avatar
6.8k
JasonGlazer
answered 2018-11-14 09:04:58 -0500
edit flag offensive 0 remove flag delete link

Comments

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

Philip Caesar Ebit's avatar Philip Caesar Ebit (2018-11-14 18:32:32 -0500) edit
add a comment see more comments
1

You can find plenty of ideas here and here.

adambgnr's avatar
749
adambgnr
answered 2018-11-14 04:51:22 -0500, updated 2018-11-14 04:52:23 -0500
edit flag offensive 0 remove flag 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's avatar Philip Caesar Ebit (2018-11-14 18:31:08 -0500) 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's avatar adambgnr (2018-11-15 02:49:21 -0500) edit
add a comment see more comments
0

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

PeterSchild's avatar
21
PeterSchild
answered 2019-09-24 16:28:34 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments