{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Summary Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary Data","index":0,"n_rows":100,"n_cols":17,"rows_kept":100,"cut":false,"hidden":false,"merged":[[5,12,5,16],[5,0,5,11],[0,0,0,16],[1,0,1,4],[2,2,2,4],[3,2,3,4],[2,0,2,1],[3,0,3,1],[2,6,3,6]]}
["This spreadsheets calculates the Zenith, Tau, and LAI from LP-80 summary data.  The calculated values may differ from the values computed internally in the LP-80.  The LP-80 computes Tau from the ratio of below canopy to above canopy radiation of each segment, and then reports the average of these values.  This calculation is the ratio of the average above to below values (you can find the formulae for the computations in the \"PAR and LAI Theory\" chapter in the LP-80 Manual).  To use this spreadsheet, copy the summary values from the downloaded LP-80 excel file and paste them into the \"Data from LP-80\" section (columns A through L).  The calculated Zenith and Fb columns use macros so macros must be enabled for this spreadsheet to do the computations correctly.  In order for the zenith angle to be calculated correctly using raw data, you must insert the UTC Offset value stored on the LP-80 into the box on below."]
["Calculation Preferences",null,null,null,null,null,"UTC Offset"]
["Zenith Angle (Z):",null,"Calculate from raw data",null,null,"Calculate from raw data",-8]
["Beam Fraction (Fb):",null,"Calculate from raw data",null,null,"Use LP-80's internal calculation"]
[]
["Data from LP-80",null,null,null,null,null,null,null,null,null,null,null,"Calculated"]
["Record Type","Date and Time","Annotation","Average Above PAR","Average Below PAR","Tau [Т]","Leaf Area Index [LAI]","Leaf Distribution [χ]","Beam Fraction [Fb]","Zenith Angle","Latitiude","Longitude","Zenith","Fb","K","Tau","LAI"]
["SUM","2010-03-15T17:00:05","ROSE BUSH",667.4,3.8,6.0000000000000001E-3,2.2799999999999998,1,0.91,82,47,-117,{"$f":"IF(COUNTA(A8:L8),IF(LEFT(C$3,1)=\"C\",ZenithAngle(K8,L8, B8, $G$3),J8),\"---\")","v":82.130241394042969},{"$f":"IF(M8=\"---\",\"---\",IF(LEFT(C$4,1)=\"C\",beamfraction(M8,D8),I8))","v":0.90536707639694214},{"$f":"IF(M8=\"---\",\"---\",SQRT(H8^2+(TAN(RADIANS(M8)))^2)/(H8+1.744*(H8+1.182)^(-0.733)))","v":3.6804525806547921},{"$f":"IF(M8=\"---\",\"---\",E8/D8)","v":5.6937368894216358E-3},{"$f":"IF(M8=\"---\",\"---\",((1-1/(2*O8))*N8-1)*LN(P8)/(0.86*(1-0.47*N8)))","v":2.2766785498051862}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(A9:L9),IF(LEFT(C$3,1)=\"C\",ZenithAngle(K9,L9, B9, $G$3),J9),\"---\")","v":"---"},{"$f":"IF(M9=\"---\",\"---\",IF(LEFT(C$4,1)=\"C\",beamfraction(M9,D9),I9))","v":"---"},{"$f":"IF(M9=\"---\",\"---\",SQRT(H9^2+(TAN(RADIANS(M9)))^2)/(H9+1.744*(H9+1.182)^(-0.733)))","v":"---"},{"$f":"IF(M9=\"---\",\"---\",E9/D9)","v":"---"},{"$f":"IF(M9=\"---\",\"---\",((1-1/(2*O9))*N9-1)*LN(P9)/(0.86*(1-0.47*N9)))","v":"---"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(A73:L73),IF(LEFT(C$3,1)=\"C\",ZenithAngle(K73,L73, B73, $G$3),J73),\"---\")","v":"---"},{"$f":"IF(M73=\"---\",\"---\",IF(LEFT(C$4,1)=\"C\",beamfraction(M73,D73),I73))","v":"---"},{"$f":"IF(M73=\"---\",\"---\",SQRT(H73^2+(TAN(RADIANS(M73)))^2)/(H73+1.744*(H73+1.182)^(-0.733)))","v":"---"},{"$f":"IF(M73=\"---\",\"---\",E73/D73)","v":"---"},{"$f":"IF(M73=\"---\",\"---\",((1-1/(2*O73))*N73-1)*LN(P73)/(0.86*(1-0.47*N73)))","v":"---"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]
[null,null,null,null,null,null,null,null,null,null,null,null,"---","---","---","---","---"]