The first line of the GSS 1.0 file should be the 'version data' and the 'info data'. Example: gss1.0 112 After the first line, all other lines should be lines of data. The GSS 1.0 spreadsheet format consists of lines of data of 6 fields, separated by a space. The first field of a data line is the data type lead field. ssp lead field The spreadsheet book properties are controlled by the ssp lead field. The next 5 fields will contain general properties of the book. Field #2, after the ssp field, is the decimal point field. This is how many places to show after the decimal point. valid numbers are 0 to 6. Field #3 is if the default width of the cell. Valid numbers are 7 to 11. Field #4 is if formula cells are highlighted or not. 0 is off and 1 is off. Field #5 is the general properties field. Field #6, the last field, for the ssp lead field is the name of the spreadsheet. Example: ssp 2 10 1 0 Accounting des lead field Data lines with formulas and strings will use the des lead field. Field #2 is column number Field #3 is row number Field #4 is general properties field. Field #5 is the text color. Field #6 is the value. Examples: des 5 7 0 0 =avg(a1:c3) des 6 7 0 0 Average Valid formulas: =avg( ) average value of 2 or more number values =cou( ) count - counts the number of numbers in a range. =flr( ) floor - rounds down number to whole value =max( ) max value of 2 or more values =min( ) min value of 2 or more values =sum( ) sum of 2 or more values Fomulas will only process cells marked as numbers stored as numbers like with den den lead field Data lines with numbers use the den lead field. Examples: den 1 2 0 0 999.25 den 2 1 0 0 123 stp lead field End of file should end with the stp lead field. Example: stp 0 0 0 0 0