Dear Luca,
In simplest form, you can:
1. Use an .RVI file to make sure your variables are created in the same order for each simulation
2. Create a spreadsheet with proper formatting that corresponds to the expected RVI sequence and numerical values
3. Open the .CSV file in Excel, then copy “values only” into your formatted spreadsheet
A macro can make this somewhat more convenient by asking for the CSV file name and importing it directly.
James V Dirkes II, PE, BEMP, LEED AP
www.buildingperformanceteam.com
Energy Analysis, Commissioning & Training Services
1631 Acacia Drive, Grand Rapids, MI 49504 USA
616 450 8653
From: EnergyPlus_Support@xxxxxxxxxxxxxxx [mailto:EnergyPlus_Support@xxxxxxxxxxxxxxx] On Behalf Of josep.sole@xxxxxxxxxxx
Sent: Tuesday, January 28, 2014 10:07 AM
To: EnergyPlus_Support@xxxxxxxxxxxxxxx
Subject: RE: [EnergyPlus_Support] A banal question.
Try to use macros in Excel in order to perform repetitive actions in your data files.
Josep Solé
URSA Insulation S.A-
Sustainibility & Technical Manager
Móvil +34 606 42 32 14
P URALITA / URSA se compromete con el ahorro de energía. Antes de imprimir este mensaje asegúrese de que es necesario.
De: EnergyPlus_Support@xxxxxxxxxxxxxxx [mailto:EnergyPlus_Support@xxxxxxxxxxxxxxx] En nombre de Artem Zhukov
Enviado el: martes, 28 de enero de 2014 15:59
Para: EnergyPlus_Support@xxxxxxxxxxxxxxx
CC: EnergyPlus_Support@xxxxxxxxxxxxxxx
Asunto: Re: [EnergyPlus_Support] A banal question.
It is always good to connect csv file to excel spreadsheet via external connection. It will let you possibility do not apply formatting and etc. ech time after the simulation is done.
BR,
Artem Zhukov
On 28 Jan 2014, at 15:49, "Luca Rizzian" <lrizzian@xxxxxxxxx> wrote:
Thanks, I have just found. But we have to do those steps every times in Excel? Or does exist a mode for to do those steps always?
Good work.
Luca.
On Tuesday, January 28, 2014 3:29 PM, "josep.sole@xxxxxxxxxxx" <josep.sole@xxxxxxxxxxx> wrote:
Have a look in Excel documentation how to transform text files into Excel files.
Josep Solé
URSA Insulation S.A-Sustainibility & Technical Manager
Móvil +34 606 42 32 14
<image001.png>
P URALITA / URSA se compromete con el ahorro de energía. Antes de imprimir este mensaje asegúrese de que es necesario.
De: EnergyPlus_Support@xxxxxxxxxxxxxxx [mailto:EnergyPlus_Support@xxxxxxxxxxxxxxx] En nombre de Luca Rizzian
Enviado el: martes, 28 de enero de 2014 12:10
Para: EnergyPlus_Support@xxxxxxxxxxxxxxx
Asunto: [EnergyPlus_Support] A banal question.
Hi to all, I’m Luca and I'm a new user.
I’m starting to work on Energy Plus, and I have a problem with the view of the spreadsheet.
In Excel I see the results in a text format, the values aren’t in separately cells.
Could someones indicate what is my error?
Excuse me for the banal question.
Thanks, good work to all.
__._,_.___
Primary EnergyPlus support is found at:
http://energyplus.helpserve.com or send a message to energyplus-support@xxxxxxxx
The primary EnergyPlus web site is found at:
http://www.energyplus.gov
The group web site is:
http://groups.yahoo.com/group/EnergyPlus_Support/
Attachments are currently allowed but be mindful that not everyone has a high speed connection. Limit attachments to small files.
EnergyPlus Documentation is searchable. Open EPlusMainMenu.pdf under the Documentation link and press the "search" button.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___