beautypg.com

Displaying data files on your pc, The .prn file, The .csv file – Delta Electronics SS1-UM-1.05 User Manual

Page 38

background image

38

••••

More Psion and file handling notes

Document code: SS1-UM-1.05

Displaying data files on your PC

As soon as you have transferred data files from the Workabout to your PC (or have
created them on a portable PC) you will want to analyse and print them for your
records.

The .PRN file

The .PRN file format contains ASCII characters which can be read by a wide range
of text reading programs, and by some spreadsheets. An example printout is shown
below.

The .CSV file

The Comma Separated Value format is a common format where ASCII characters
are separated into fields by commas, and text is identified by being enclosed in "...".
This greatly simplifies importing the files into spreadsheets for further analysis and
printout. The example below was created in Microsoft Excel 5.0

Created by SunData for Workabout v0.11

Title

:Demonstration

Location

:Burwell, Cambridge

Latitude

:52.2N

Longitude :0.4W

1996-05-19

Local time is GMT+1 Hrs

SunScan probe

emulator

Ext sensor:BFS

Leaf Angle Distn Parameter: 1.5

Leaf Absorption : 0.85

Group

1 :Presentation

Time

Plot

Sample Trans- Spread

Incid-

Beam Zenith

LAI Notes

mitted

ent

frac Angle

15:51:12

1

1

270.9

0.13

2000.0

0.65

46.5

2.7 Notes appear here.

15:51:59

1

2

189.6

0.14

2000.0

0.65

46.6

3.2

15:52:08

1

3

1047.5

0.15

2000.0

0.65

46.6

0.8

15:52:16

1

4

63.4

0.14

2000.0

0.65

46.6

4.7

15:52:24

1

5

1225.3

0.15

2000.0

0.65

46.6

0.6

Average of

5 readings:

Incident light: 2000.0

Transmitted fraction:0.28

LAI:

2.4

Created by SunData for Workabout v0.11

Title :

Demonstration2

Location :

Burwell, Cambridge

Latitude :

52.0N

Longitude :0.1W

19/05/96

Local time is GMT+1 Hrs

SunScan probe emulator

Ext sensor: None

Leaf Angle Distn Parameter:

2.5 Leaf Absorption :

0.9

Group 1 : Presentation2

Time

Plot

Sample

Trans-

Spread

Incid-

Beam

Zenith

LAI

Notes

mitted

ent

frac

Angle

15:56:54

1662.4

0.37

Beam Fraction measm't

15:57:54

1

1

754.2

0.15

47.5

0.9

15:58:00

1

2

142.9

0.15

47.5

2.9

15:58:05

1

3

203.4

0.15

47.5

2.5

15:58:09

1

4

255.4

0.17

47.5

2.2

15:58:15

1

5

701.4

0.13

47.5

1

Average of

5 readings:

Incident light:

1662.4 Transmitted fraction

0.25 LAI

1.9