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