Re: [TRNSYS-users] Using Excel as Load Profile

[David BRADLEY <d.bradley@tess-inc.com>]

Pei,
 You'll want to save your Excel file in *.csv (comma separated value) form and read it with type9. Type9 can read as many rows of data as you have. Parameter 2 is asking you for how many columns of data you have per row. I would recommend that you start with the Type9 example:

..\Trnsys17\Examples\Reading Data Files\DataReader.tpf.

It is often simpler to modify existing examples than it is to start from nothing.
Kind regards,
 david


On 9/30/2011 01:31, Pei Ru Chao wrote:

Hi all,

As a newbie I am wondering how to use Excel for load profile input. Can anyone point me in the right direction as to how to use a Data Reader to do this? For example, can the Data Reader read 10920 rows of data? In 9a for example, Parameter 2 asks how many values of input to read and the maximum is only 98?

Thanks

Pei

_______________________________________________
TRNSYS-users mailing list
TRNSYS-users@cae.wisc.edu
https://mailman.cae.wisc.edu/listinfo/trnsys-users

-- 
***************************
David BRADLEY
Principal
Thermal Energy Systems Specialists, LLC
22 North Carroll Street - suite 370
Madison, WI  53703 USA

P:+1.608.274.2577
F:+1.608.278.1475
d.bradley@tess-inc.com

http://www.tess-inc.com
http://www.trnsys.com