[Equest-users] Modifying Weather Files (.FMT format)

[Taylor Sharpe]

---------- Forwarded message ----------
From: Jordan Goldsmith <jordang at ncat.org>
Date: Tue, Mar 16, 2010 at 1:01 PM
Subject: RE: Modifying Weather Files
To: Taylor Sharpe <newspectrum at gmail.com>


 That would be fine, I had to use an Access Data Base because excel could
not handle the size of the data.  Also please note that the first 3 – 4
lines are part of the weather station I.D.  and are not part of the hourly
data (which starts at MM 1, DD 1, HR 1.)



*From:* Taylor Sharpe [mailto:newspectrum at gmail.com]
*Sent:* Tuesday, March 16, 2010 1:36 PM
*To:* Jordan Goldsmith
*Subject:* Re: Modifying Weather Files



I'm afraid I don't have Access, but this looks like a very helpful
post--it's exactly the sort of thing I spent hours trying to make with Excel
without fudging the output....



If it's fine with you to share the template, I'll post this to the group.



Thanks!

-Taylor Sharpe



On Tue, Mar 16, 2010 at 10:07 AM, Jordan Goldsmith <jordang at ncat.org> wrote:

Taylor,  I have used Microsoft Access to import the text file in to a
readable spreadsheet.  This might be of some help for you understand/read
the data then edit the .fmt text file and then convert back to .bin (not
exactly a “speed up” process….)



In Access get to the import data section.



-Import text file

-Select the text file

- OK

-Go to the Advanced… option

-Under Field Information enter:



Field Name

Data Type

Start

Width

Indexed

Skip



MM

Text

1

2

no

no

DD

Text

3

2

no

no

HR

Text

5

2

no

no

Twb

Text

7

5

no

no

Tdb

Text

12

5

no

no

Patmos

Text

17

6

no

no

CLDAMT

Text

23

5

no

no

ISNOW

Text

28

3

no

no

IRAIN

Text

31

3

no

no

WindDir

Text

34

4

no

no

HumidityRatio

Text

38

7

no

no

Desnity

Text

45

6

no

no

Enthalpy

Text

51

6

no

no

SolarRadiation

Text

57

7

no

no

DirectSolarRadiation

Text

64

7

no

no

CloudType

Text

71

3

no

no

WindSpeed

Text

74

5

no

no



- You can save these specs for future imports

- Click through and finish



Hope this helps, if so, possible post to users list.







Jordan Goldsmith, E.I.T.  – Energy Specialist

National Center for Appropriate Technology

3040 Continental Drive, Butte MT 59702

Ph. 406-494-8651

Fax 406-494-2905

Jordang at ncat.org

http://www.ncat.org/energy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20100316/c46d3344/attachment.htm>