Dear Jaime,
Hereâ??s the short version of a long story:
· I create E+ objects in Excel with an assortment of custom formulae to:
o aid in IP / SI conversion
o create node names consistently and avoid duplication
o reference other cells directly instead of re-typing
o create report variables
· I maintain a library of typical systems in the master spreadsheet which allow convenient copying and editing
· The objects I concern myself with are only schedules, HVAC and zone equipment. Geometry and materials are created using DesignBuilder.
· Several macros are used for exporting the information to an IDF and also to import report variables and meter data.
I hope that is helpful.
The Building Performance Team
James V. Dirkes II, P.E., LEED AP
1631 Acacia Drive NW
Grand Rapids, MI 49504
616 450 8653
From: EnergyPlus_Support@xxxxxxxxxxxxxxx [mailto:EnergyPlus_Support@xxxxxxxxxxxxxxx] On Behalf Of Jaime Zuluaga Machado
Sent: Friday, April 08, 2011 1:12 PM
To: EnergyPlus_Support@xxxxxxxxxxxxxxx
Subject: Re: [EnergyPlus_Support] importing/exporting I/O files
Hi James!
Would you mind to send me some example of how you do the input files in excel?
Thanks
Jaime Zuluaga M
From: "James V Dirkes II, PE" <jim@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
To: EnergyPlus_Support@xxxxxxxxxxxxxxx
Sent: Friday, 8 April 2011, 11:02
Subject: RE: [EnergyPlus_Support] importing/exporting I/O files
Dear Fakeha,
All E+ input files are text, so you can prepare them in any program which can export text. (I use Excel, for example, and export as .csv)
Similarly, output is also text, and can be analyzed by any software which can import text.
The Building Performance Team
James V. Dirkes II, P.E., LEED AP
1631 Acacia Drive NW
Grand Rapids, MI 49504
616 450 8653
From: EnergyPlus_Support@xxxxxxxxxxxxxxx [mailto:EnergyPlus_Support@xxxxxxxxxxxxxxx] On Behalf Of Fakeha Sehar
Sent: Friday, April 08, 2011 11:49 AM
To: EnergyPlus_Support@xxxxxxxxxxxxxxx
Subject: [EnergyPlus_Support] importing/exporting I/O files
Can the input files for EnergyPlus be created using some other GUI and sent over to EnergyPlus for simulation and the output files generated by EnergyPlus be sent over to other software tool for analyzing the results.
Thanks
Fakeha