Delta Electronics SS1-UM-1.05 user manual Displaying data files on your PC, PRN file, CSV file

Page 38

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.

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

 

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

:

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

38 More Psion and file handling notes

Document code: SS1-UM-1.05

Image 38
Contents SunScan SS1-UM-1.05Trademarks CopyrightAcknowledgements CE conformityContents LAI theory Menus and Screens More Psion and file handling notesMeasurement options Technical Reference sectionAppendices IndexSunScan Canopy Analysis System How to use the manualsIntroduction Organisation of this manualBeam Fraction sensor Field accessoriesSunScan probe Data Collection TerminalWorkabout and SunScan probe Getting StartedPreliminary checks Checking the Workabout hardware SunData s/w Diskette Installing the SunData s/w in your PCInstalling the s/w What the s/w doesSetting up your PCs COM port Running SunDataWorkabout to PC Communication checksSunScan probe to PC Running SunData in Windows Working with the Workabout SunScan TutorialAbout this tutorial What to do if you get lost Starting SunData in the WorkaboutUsing a PC instead of the Workabout Starting the PC softwareThis page is intentionally blank Setting up a measurement session Working through the menu optionsFile Saving Hot KeysUsing the Emulator mode Taking readingsConnecting the SunScan probe Without a Beam Fraction SensorConnecting the Beam Fraction Sensor Measuring Leaf Area Index without a Beam Fraction Sensor Reviewing your data file AveragesTo the PC Transferring the data file to your PCFrom the Workabout Initiating the file transfer from the Workabout Meanwhile, on the PC RS232 communication problems Conclusion of the TutorialSunData Screens on the Workabout File SettingsMenus and Screens Contd UtilsQuit Workabout User Guide More Psion and file handling notesNavigating Psion directories and screens Navigating the Psion directories and screensPsion subdirectory usage in file select dialogs Flashcards reformatting Re-installing the SunData application icon Deleting unwanted Workabout files Data memory management Configuration and data file handlingSunData Configuration files Restoring a configuration Default .cfgCreating a configuration file Data files.CSV file Displaying data files on your PC.PRN file Data file layouts and data groups Page Above-canopy reference requirements Measurement optionsExperiment design Canopy type and LAI estimates Canopy Sampling volumeCanopy type and BFS practicalities Preferred light and weather conditions Planning for the sun’s positionAbsorption Advice on Absorption and Eladp valuesSetting Eladp Relationship between Mean Leaf Angle and Eladp Estimating Eladp in the fieldLAI, PAR and All displays Workabout setupSunScan System Measurement modes Autolog function Probe GO button Measurement procedures in the fieldProbe handling in the field Levelling the probeUse of the tripod Using the tripodBFS handling in the field WorkaboutExtension cables, and the location of the BFS Finding North, and setting the shade ringLevelling the BFS Checking the probe/BFS matching PAR calibrationsFactory light calibration Recalibrate optionEffect of the shade ring on the BFS Routine maintenance and cleaningRestoring the factory calibration Comparing the calibration with other PAR sensorsEnvironmental and moisture protection SunScan probe and Beam Fraction SensorLAI theory Ingredients of the LAI computation methodTheory versus reality Derivation of Wood’s SunScan canopy analysis equationsMajor assumptions Transmission of Diffuse Light Beers law for canopy absorptionCampbells Ellipsoidal LAD equations Transmission fraction τ Is given by I/I0 Modelling the canopy transmission Diffuse light transmission cosine corrected sensorDetail Diffuse light cosine response sensor Functions used to model canopy transmissionAccuracy of LAI calculations Diffuse light hemispherical response sensorModelling incomplete PAR absorption and scattering Exp 0.1 . x . atan 0.9 Atan L Q SpherSummary Scientific referencesCalculating zenith angles Jones, Hamlyn G Plants and Microclimate second edition. CUP Checking the batteries Maintenance and repairTechnical Reference section SunScan probe batteriesChecking the desiccant Factory calibration method Re-setting the factory calibrationChecking the PAR calibration Psion Workabout TroubleshootingProblems running the SunData application While running SunDataInsufficient power to write data reported Technical Support Beam Fraction Sensor type BF1 SpecificationsSunScan Probe Type SS1 Data Collection Terminal type DCT1 Psion WorkaboutSpares Kit type SPS1 Carrying Case type SCC1Telescopic Tripod type BFT1 Logging CablesPAR Performance Spectral responseCosine responses of probe and BFS SunScan system cosine responseAppendices Logging the probe as a Linear Quantum SensorLogging the Beam Fraction sensor Workabout SunData s/w Upgrading the SunScan systemSunData PC s/w Revision HistoryPsiWin File transfer between Workabout and PCChoice of different programs Workabout Remote LinkExample using Slink Slink and RcomDrives on the PC are referred to as REMA, Remc REM = remote Example using Rcom Documentation of Rcom and SlinkSending a file to a Communication program Using the Workabout Comms applicationAlternative file transfer mechanisms Sending a file to a serial printerGlossary Page Index AccuracyIndex Field use 39, 46, 48, 50, 51, 58