[TRNSYS-users] Using Excel as Load Profile

Ratnalee Patil Ratnalee at innovativedesign.net
Fri Sep 30 08:15:41 PDT 2011


Pei,

 

You can copy the data from excel file into Notepad/WordPad & use that
.txt file as the external file for Type 9 data reader. 

The maximum of 98 is not for no. of rows. The parameter in Type 9 for
'no. of values to read' is for no. of columns, i.e. no. of values in
each row. 

 

One small tip - when you copy data from Excel to text file, make sure
that your data has no commas (e.g. it should be 134897 & not 134, 897).
I had run into errors due to this.

 

Hope this helps...

 

Regards,

Ratnalee Patil

B.Arch., M.A.Sc. Engineering

Sustainable Design Analyst

Innovative Design

850 West Morgan St.

Raleigh, NC 27603

Ph: (919) 832-6303

Fax: (919) 832-3339

www.innovativedesign.net <http://www.innovativedesign.net/> 

 

From: Pei Ru Chao [mailto:simplica1 at hotmail.com] 
Sent: Friday, September 30, 2011 2:32 AM
To: TRNSYS
Subject: [TRNSYS-users] Using Excel as Load Profile

 

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

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20110930/da7cbbdc/attachment-0005.htm>


More information about the TRNSYS-users mailing list