{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Paired Unknown Variance-Project","Unpaired Unknown-Project","Dia_Height_Stopping Rules_US","Dropdown Selections"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Paired Unknown Variance-Project","index":0,"n_rows":114,"n_cols":13,"rows_kept":114,"cut":false,"hidden":false,"merged":[[12,1,12,2],[0,0,6,2],[14,12,17,14],[2,17,2,18],[12,4,12,5],[0,3,0,11],[8,4,9,4],[34,12,39,14],[18,12,21,14],[22,12,25,14],[26,12,29,14],[13,12,13,14],[30,12,33,14]]}
["Step 1:  Ensure Data to be Verified will be a Paired  Comparison.\nThis worksheet is designed for cases in which verifiers can compare their measurements directly to project data. Plots must be relocated for this comparison.  Refer to the verification guidelines for details in selecting plots for measurement.  If plots cannot be relocated, verifiers must use the Unpaired Unknown-Project worksheet.  The worksheet must be used for each carbon pool independently, or combined where allowed, according guidance in the verification section.",null,null,"Sequential Sampling Worksheet for Verification Inventory where Project Plots are Monumented"]
[null,null,null,"Allowance:",0.1,null,null,null,null,null,null,"D0:",{"$f":"E5","v":0}]
[null,null,null,"Alpha:",0.05,null,null,null,null,null,null,"D1:",{"$f":"E2*E5+M2","v":0}]
[null,null,null,"Beta:",0.2]
[null,null,null,"Project/Stratum Mean:",null,null,null,null,null,null,null,"Mean_Diff0:",{"$f":"M2-E5","v":0}]
[null,null,null,"Number of Strata Verified:",3,null,null,null,null,null,null,"Mean_Diff1:",{"$f":"M3-M2","v":0}]
[null,null,null,"Project Acreage:",">10,000"]
[null,null,null,"Minimum Number of Passing Plots Needed in Sequence:",6]
[null,null,null,null,"*or 1st passing plot after 12 measured plots"]
[null,null,null,null,null,null,null,null,null,null,null,"Zalpha:",1.645]
[null,null,null,null,null,null,null,null,null,null,null,"Zbeta:",0.84160000000000001]
[null,null,null,null,null,null,null,null,null,null,null,"K:",{"$f":"ABS(($M$10*$M$6+$M$11*$M$5)/($M$10+$M$11))","v":0}]
[null,"Plot Data"]
["Plot Pair (n)","Project","Verification","Running Examination/Plot Success","Number of Passing Plots in Sequence","Status of Verification","Y(n)","-K","K","Running Mean","Running SD","n_ Threshold","Guidance for Additional Steps"]
[1,null,null,{"$f":"IF(G15<>\"\",IF(ABS((B15-C15))<=(E2*C15),\"Pass(H0)\",\"Fail(H1)\"),\"\")","v":""},{"$f":"IF(G15<>\"\",IF(D15=\"Pass(H0)\",1,0),\"\")","v":""},{"$f":"IF(G15<>\"\",IF(E15>=$E$8,\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":""},{"$f":"IF(B15<>\"\",IF(C15<>\"\",B15-C15,\"\"),\"\")","v":""},{"$f":"-$M$12","v":0},{"$f":"$M$12","v":0},{"$f":"M16","v":0},null,null,"Step 2- Allowance (E2).  Adjusting the allowance below 10% will result in an uncertainty deduction being applied to the project estimates.  The allowance can never be more than 20%.  The Forest Owner has the discretion to request adjustments to the allowance value."]
[2,null,null,{"$f":"IF(G16<>\"\",IF(A16>L16,IF(J16>$M$12,\"Fail(H1)\",IF(J16<-$M$12,\"Fail(H1)\", \"Pass(H0)\")),\"Inconclusive\"),\"\")","v":""},{"$f":"IF(G16<>\"\",IF(D16=\"Pass(H0)\",1+E15,0),\"\")","v":""},"","",0,0,{"$f":"IF(G16<>\"\",AVERAGE($G$15:G16),\"\")","v":""},{"$f":"IF(G16<>\"\",STDEV($G$15:G16),\"\")","v":""},{"$f":"IF(G16<>\"\",(($M$10+$M$11)^2*K16^2)/($E$2*$E$5)^2,\"\")","v":""}]
[3,null,null,"","","","",0,0,{"$f":"IF(G17<>\"\",AVERAGE($G$15:G17),\"\")","v":""},{"$f":"IF(G17<>\"\",STDEV($G$15:G17),\"\")","v":""},""]
[4,null,null,"","","","",0,0,{"$f":"IF(G18<>\"\",AVERAGE($G$15:G18),\"\")","v":""},{"$f":"IF(G18<>\"\",STDEV($G$15:G18),\"\")","v":""},""]
[5,null,null,"","","","",0,0,{"$f":"IF(G19<>\"\",AVERAGE($G$15:G19),\"\")","v":""},{"$f":"IF(G19<>\"\",STDEV($G$15:G19),\"\")","v":""},"","Step 3-Project/Stratum Mean (E5):  Enter the mean estimate of CO2e for the project, if the project has not been stratified for sampling, or for the stratum selected by the verifier.  The verifier will need to use a separate worksheet for each stratum verified."]
[6,null,null,"","","","",0,0,{"$f":"IF(G20<>\"\",AVERAGE($G$15:G20),\"\")","v":""},{"$f":"IF(G20<>\"\",STDEV($G$15:G20),\"\")","v":""},""]
[7,null,null,"","","","",0,0,{"$f":"IF(G21<>\"\",AVERAGE($G$15:G21),\"\")","v":""},{"$f":"IF(G21<>\"\",STDEV($G$15:G21),\"\")","v":""},""]
[8,null,null,"","","","",0,0,{"$f":"IF(G22<>\"\",AVERAGE($G$15:G22),\"\")","v":""},{"$f":"IF(G22<>\"\",STDEV($G$15:G22),\"\")","v":""},""]
[9,null,null,"","","","",0,0,{"$f":"IF(G23<>\"\",AVERAGE($G$15:G23),\"\")","v":""},{"$f":"IF(G23<>\"\",STDEV($G$15:G23),\"\")","v":""},"","Step 4 - Number of Strata Verified (E6):  Using the pull-down menu, select the number of different strata that will be verified by the verifier.  If the project is not stratified, the number will be '1'. "]
[10,null,null,"","","","",0,0,{"$f":"IF(G24<>\"\",AVERAGE($G$15:G24),\"\")","v":""},{"$f":"IF(G24<>\"\",STDEV($G$15:G24),\"\")","v":""},""]
[11,null,null,"","","","",0,0,{"$f":"IF(G25<>\"\",AVERAGE($G$15:G25),\"\")","v":""},{"$f":"IF(G25<>\"\",STDEV($G$15:G25),\"\")","v":""},""]
[12,null,null,"","","","",0,0,{"$f":"IF(G26<>\"\",AVERAGE($G$15:G26),\"\")","v":""},{"$f":"IF(G26<>\"\",STDEV($G$15:G26),\"\")","v":""},""]
[13,null,null,"","",{"$f":"IF(G27<>\"\",IF(D27=\"Pass(H0)\",\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":""},"",0,0,{"$f":"IF(G27<>\"\",AVERAGE($G$15:G27),\"\")","v":""},{"$f":"IF(G27<>\"\",STDEV($G$15:G27),\"\")","v":""},"","Step 5-Project Acreage (E7): Using the pull-down menu, select the project size class. The combination of 'Number of Strata' and 'Project Acres' will automatically determine the minimum number of passing plots in a sequence according to the verification guidance in the protocol."]
[14,null,null,"","",{"$f":"IF(G28<>\"\",IF(D28=\"Pass(H0)\",\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":""},"",0,0,{"$f":"IF(G28<>\"\",AVERAGE($G$15:G28),\"\")","v":""},{"$f":"IF(G28<>\"\",STDEV($G$15:G28),\"\")","v":""},""]
[15,null,null,"","","","",0,0,{"$f":"IF(G29<>\"\",AVERAGE($G$15:G29),\"\")","v":""},{"$f":"IF(G29<>\"\",STDEV($G$15:G29),\"\")","v":""},""]
[16,null,null,"","","","",0,0,{"$f":"IF(G30<>\"\",AVERAGE($G$15:G30),\"\")","v":""},{"$f":"IF(G30<>\"\",STDEV($G$15:G30),\"\")","v":""},""]
[17,null,null,"","","","",0,0,{"$f":"IF(G31<>\"\",AVERAGE($G$15:G31),\"\")","v":""},{"$f":"IF(G31<>\"\",STDEV($G$15:G31),\"\")","v":""},"","Step 6 - Plot Data (B15:C114): Verifiers enter the project estimates for e as CO2-e for each of the plots in the order they were randomly selected for the stratum or project this worksheet represents. Verifiers also enter the results of their paired measurements and computations."]
[18,null,null,"","","","",0,0,{"$f":"IF(G32<>\"\",AVERAGE($G$15:G32),\"\")","v":""},{"$f":"IF(G32<>\"\",STDEV($G$15:G32),\"\")","v":""},""]
[19,null,null,"","","","",0,0,{"$f":"IF(G33<>\"\",AVERAGE($G$15:G33),\"\")","v":""},{"$f":"IF(G33<>\"\",STDEV($G$15:G33),\"\")","v":""},""]
[20,null,null,"","","","",0,0,{"$f":"IF(G34<>\"\",AVERAGE($G$15:G34),\"\")","v":""},{"$f":"IF(G34<>\"\",STDEV($G$15:G34),\"\")","v":""},""]
[21,null,null,"","","","",0,0,{"$f":"IF(G35<>\"\",AVERAGE($G$15:G35),\"\")","v":""},{"$f":"IF(G35<>\"\",STDEV($G$15:G35),\"\")","v":""},"","With each plot, the worksheet will identify that the verification is trending toward passing, trending toward failing, or not discernable with the number of plots.  The 'Status of Verification' column will indicate whether the verification yields satisfactory results when the correct number of plots pass in sequence."]
[22,null,null,"","","","",0,0,{"$f":"IF(G36<>\"\",AVERAGE($G$15:G36),\"\")","v":""},{"$f":"IF(G36<>\"\",STDEV($G$15:G36),\"\")","v":""},""]
[23,null,null,"","","","",0,0,{"$f":"IF(G37<>\"\",AVERAGE($G$15:G37),\"\")","v":""},{"$f":"IF(G37<>\"\",STDEV($G$15:G37),\"\")","v":""},""]
[24,null,null,"","","","",0,0,{"$f":"IF(G38<>\"\",AVERAGE($G$15:G38),\"\")","v":""},{"$f":"IF(G38<>\"\",STDEV($G$15:G38),\"\")","v":""},""]
[25,null,null,"","","","",0,0,{"$f":"IF(G39<>\"\",AVERAGE($G$15:G39),\"\")","v":""},{"$f":"IF(G39<>\"\",STDEV($G$15:G39),\"\")","v":""},""]
[26,null,null,"","","","",0,0,{"$f":"IF(G40<>\"\",AVERAGE($G$15:G40),\"\")","v":""},{"$f":"IF(G40<>\"\",STDEV($G$15:G40),\"\")","v":""},""]
[27,null,null,"","","","",0,0,{"$f":"IF(G41<>\"\",AVERAGE($G$15:G41),\"\")","v":""},{"$f":"IF(G41<>\"\",STDEV($G$15:G41),\"\")","v":""},""]
[28,null,null,"","","","",0,0,{"$f":"IF(G42<>\"\",AVERAGE($G$15:G42),\"\")","v":""},{"$f":"IF(G42<>\"\",STDEV($G$15:G42),\"\")","v":""},""]
[29,null,null,"","","","",0,0,{"$f":"IF(G43<>\"\",AVERAGE($G$15:G43),\"\")","v":""},{"$f":"IF(G43<>\"\",STDEV($G$15:G43),\"\")","v":""},""]
[30,null,null,"","","","",0,0,{"$f":"IF(G44<>\"\",AVERAGE($G$15:G44),\"\")","v":""},{"$f":"IF(G44<>\"\",STDEV($G$15:G44),\"\")","v":""},""]
[31,null,null,"","","","",0,0,{"$f":"IF(G45<>\"\",AVERAGE($G$15:G45),\"\")","v":""},{"$f":"IF(G45<>\"\",STDEV($G$15:G45),\"\")","v":""},""]
[32,null,null,"","","","",0,0,{"$f":"IF(G46<>\"\",AVERAGE($G$15:G46),\"\")","v":""},{"$f":"IF(G46<>\"\",STDEV($G$15:G46),\"\")","v":""},""]
[33,null,null,"","","",{"$f":"IF(B47<>\"\",IF(C47<>\"\",B47-C47,\"\"),\"\")","v":""},{"$f":"-$M$12","v":0},{"$f":"$M$12","v":0},{"$f":"IF(G47<>\"\",AVERAGE($G$15:G47),\"\")","v":""},{"$f":"IF(G47<>\"\",STDEV($G$15:G47),\"\")","v":""},""]
[34,null,null,"","","","",0,0,{"$f":"IF(G48<>\"\",AVERAGE($G$15:G48),\"\")","v":""},{"$f":"IF(G48<>\"\",STDEV($G$15:G48),\"\")","v":""},{"$f":"IF(G48<>\"\",(($M$10+$M$11)^2*K48^2)/($E$2*$E$5)^2,\"\")","v":""}]
[35,null,null,"","","","",0,0,{"$f":"IF(G49<>\"\",AVERAGE($G$15:G49),\"\")","v":""},{"$f":"IF(G49<>\"\",STDEV($G$15:G49),\"\")","v":""},""]
[36,null,null,"","","","",0,0,{"$f":"IF(G50<>\"\",AVERAGE($G$15:G50),\"\")","v":""},{"$f":"IF(G50<>\"\",STDEV($G$15:G50),\"\")","v":""},""]
[37,null,null,"","","","",0,0,{"$f":"IF(G51<>\"\",AVERAGE($G$15:G51),\"\")","v":""},{"$f":"IF(G51<>\"\",STDEV($G$15:G51),\"\")","v":""},""]
[38,null,null,"","","","",0,0,{"$f":"IF(G52<>\"\",AVERAGE($G$15:G52),\"\")","v":""},{"$f":"IF(G52<>\"\",STDEV($G$15:G52),\"\")","v":""},""]
[39,null,null,"","","","",0,0,{"$f":"IF(G53<>\"\",AVERAGE($G$15:G53),\"\")","v":""},{"$f":"IF(G53<>\"\",STDEV($G$15:G53),\"\")","v":""},""]
[40,null,null,"","","","",0,0,{"$f":"IF(G54<>\"\",AVERAGE($G$15:G54),\"\")","v":""},{"$f":"IF(G54<>\"\",STDEV($G$15:G54),\"\")","v":""},""]
[41,null,null,"","","","",0,0,{"$f":"IF(G55<>\"\",AVERAGE($G$15:G55),\"\")","v":""},{"$f":"IF(G55<>\"\",STDEV($G$15:G55),\"\")","v":""},""]
[42,null,null,"","","","",0,0,{"$f":"IF(G56<>\"\",AVERAGE($G$15:G56),\"\")","v":""},{"$f":"IF(G56<>\"\",STDEV($G$15:G56),\"\")","v":""},""]
[43,null,null,"","","","",0,0,{"$f":"IF(G57<>\"\",AVERAGE($G$15:G57),\"\")","v":""},{"$f":"IF(G57<>\"\",STDEV($G$15:G57),\"\")","v":""},""]
[44,null,null,"","","","",0,0,{"$f":"IF(G58<>\"\",AVERAGE($G$15:G58),\"\")","v":""},{"$f":"IF(G58<>\"\",STDEV($G$15:G58),\"\")","v":""},""]
[45,null,null,"","","","",0,0,{"$f":"IF(G59<>\"\",AVERAGE($G$15:G59),\"\")","v":""},{"$f":"IF(G59<>\"\",STDEV($G$15:G59),\"\")","v":""},""]
[46,null,null,"","","","",0,0,{"$f":"IF(G60<>\"\",AVERAGE($G$15:G60),\"\")","v":""},{"$f":"IF(G60<>\"\",STDEV($G$15:G60),\"\")","v":""},""]
[47,null,null,"","","","",0,0,{"$f":"IF(G61<>\"\",AVERAGE($G$15:G61),\"\")","v":""},{"$f":"IF(G61<>\"\",STDEV($G$15:G61),\"\")","v":""},""]
[48,null,null,"","","","",0,0,{"$f":"IF(G62<>\"\",AVERAGE($G$15:G62),\"\")","v":""},{"$f":"IF(G62<>\"\",STDEV($G$15:G62),\"\")","v":""},""]
[49,null,null,"",{"$f":"IF(G63<>\"\",IF(D63=\"Pass(H0)\",1+E62,0),\"\")","v":""},"","",0,0,{"$f":"IF(G63<>\"\",AVERAGE($G$15:G63),\"\")","v":""},{"$f":"IF(G63<>\"\",STDEV($G$15:G63),\"\")","v":""},""]
[50,null,null,"","","","",0,0,{"$f":"IF(G64<>\"\",AVERAGE($G$15:G64),\"\")","v":""},{"$f":"IF(G64<>\"\",STDEV($G$15:G64),\"\")","v":""},""]
[51,null,null,"","","","",0,0,{"$f":"IF(G65<>\"\",AVERAGE($G$15:G65),\"\")","v":""},{"$f":"IF(G65<>\"\",STDEV($G$15:G65),\"\")","v":""},""]
[52,null,null,"","","","",0,0,{"$f":"IF(G66<>\"\",AVERAGE($G$15:G66),\"\")","v":""},{"$f":"IF(G66<>\"\",STDEV($G$15:G66),\"\")","v":""},""]
[53,null,null,"","","","",0,0,{"$f":"IF(G67<>\"\",AVERAGE($G$15:G67),\"\")","v":""},{"$f":"IF(G67<>\"\",STDEV($G$15:G67),\"\")","v":""},""]
[54,null,null,"","","","",0,0,{"$f":"IF(G68<>\"\",AVERAGE($G$15:G68),\"\")","v":""},{"$f":"IF(G68<>\"\",STDEV($G$15:G68),\"\")","v":""},""]
[55,null,null,"","","","",0,0,{"$f":"IF(G69<>\"\",AVERAGE($G$15:G69),\"\")","v":""},{"$f":"IF(G69<>\"\",STDEV($G$15:G69),\"\")","v":""},""]
[56,null,null,"","","","",0,0,{"$f":"IF(G70<>\"\",AVERAGE($G$15:G70),\"\")","v":""},{"$f":"IF(G70<>\"\",STDEV($G$15:G70),\"\")","v":""},""]
[57,null,null,"","","","",0,0,{"$f":"IF(G71<>\"\",AVERAGE($G$15:G71),\"\")","v":""},{"$f":"IF(G71<>\"\",STDEV($G$15:G71),\"\")","v":""},""]
[58,null,null,"","","","",0,0,{"$f":"IF(G72<>\"\",AVERAGE($G$15:G72),\"\")","v":""},{"$f":"IF(G72<>\"\",STDEV($G$15:G72),\"\")","v":""},""]
[59,null,null,"","","","",0,0,{"$f":"IF(G73<>\"\",AVERAGE($G$15:G73),\"\")","v":""},{"$f":"IF(G73<>\"\",STDEV($G$15:G73),\"\")","v":""},""]
[60,null,null,"","","","",0,0,{"$f":"IF(G74<>\"\",AVERAGE($G$15:G74),\"\")","v":""},{"$f":"IF(G74<>\"\",STDEV($G$15:G74),\"\")","v":""},""]
[61,null,null,"","","","",0,0,{"$f":"IF(G75<>\"\",AVERAGE($G$15:G75),\"\")","v":""},{"$f":"IF(G75<>\"\",STDEV($G$15:G75),\"\")","v":""},""]
[62,null,null,"","","","",0,0,{"$f":"IF(G76<>\"\",AVERAGE($G$15:G76),\"\")","v":""},{"$f":"IF(G76<>\"\",STDEV($G$15:G76),\"\")","v":""},""]
[63,null,null,"","","","",0,0,{"$f":"IF(G77<>\"\",AVERAGE($G$15:G77),\"\")","v":""},{"$f":"IF(G77<>\"\",STDEV($G$15:G77),\"\")","v":""},""]
[64,null,null,"","","","",0,0,{"$f":"IF(G78<>\"\",AVERAGE($G$15:G78),\"\")","v":""},{"$f":"IF(G78<>\"\",STDEV($G$15:G78),\"\")","v":""},""]
[65,null,null,"","","",{"$f":"IF(B79<>\"\",IF(C79<>\"\",B79-C79,\"\"),\"\")","v":""},{"$f":"-$M$12","v":0},{"$f":"$M$12","v":0},{"$f":"IF(G79<>\"\",AVERAGE($G$15:G79),\"\")","v":""},{"$f":"IF(G79<>\"\",STDEV($G$15:G79),\"\")","v":""},""]
[66,null,null,{"$f":"IF(G80<>\"\",IF(A80>L80,IF(J80>$M$12,\"Fail(H1)\",IF(J80<-$M$12,\"Fail(H1)\", \"Pass(H0)\")),\"Inconclusive\"),\"\")","v":""},"","","",0,0,{"$f":"IF(G80<>\"\",AVERAGE($G$15:G80),\"\")","v":""},{"$f":"IF(G80<>\"\",STDEV($G$15:G80),\"\")","v":""},{"$f":"IF(G80<>\"\",(($M$10+$M$11)^2*K80^2)/($E$2*$E$5)^2,\"\")","v":""}]
[67,null,null,"","","","",0,0,{"$f":"IF(G81<>\"\",AVERAGE($G$15:G81),\"\")","v":""},{"$f":"IF(G81<>\"\",STDEV($G$15:G81),\"\")","v":""},""]
[68,null,null,"","","","",0,0,{"$f":"IF(G82<>\"\",AVERAGE($G$15:G82),\"\")","v":""},{"$f":"IF(G82<>\"\",STDEV($G$15:G82),\"\")","v":""},""]
[69,null,null,"","","","",0,0,{"$f":"IF(G83<>\"\",AVERAGE($G$15:G83),\"\")","v":""},{"$f":"IF(G83<>\"\",STDEV($G$15:G83),\"\")","v":""},""]
[70,null,null,"","","","",0,0,{"$f":"IF(G84<>\"\",AVERAGE($G$15:G84),\"\")","v":""},{"$f":"IF(G84<>\"\",STDEV($G$15:G84),\"\")","v":""},""]
[71,null,null,"","","","",0,0,{"$f":"IF(G85<>\"\",AVERAGE($G$15:G85),\"\")","v":""},{"$f":"IF(G85<>\"\",STDEV($G$15:G85),\"\")","v":""},""]
[72,null,null,"","","","",0,0,{"$f":"IF(G86<>\"\",AVERAGE($G$15:G86),\"\")","v":""},{"$f":"IF(G86<>\"\",STDEV($G$15:G86),\"\")","v":""},""]
[73,null,null,"","","","",0,0,{"$f":"IF(G87<>\"\",AVERAGE($G$15:G87),\"\")","v":""},{"$f":"IF(G87<>\"\",STDEV($G$15:G87),\"\")","v":""},""]
[74,null,null,"","","","",0,0,{"$f":"IF(G88<>\"\",AVERAGE($G$15:G88),\"\")","v":""},{"$f":"IF(G88<>\"\",STDEV($G$15:G88),\"\")","v":""},""]
[75,null,null,"","","","",0,0,{"$f":"IF(G89<>\"\",AVERAGE($G$15:G89),\"\")","v":""},{"$f":"IF(G89<>\"\",STDEV($G$15:G89),\"\")","v":""},""]
[76,null,null,"","","","",0,0,{"$f":"IF(G90<>\"\",AVERAGE($G$15:G90),\"\")","v":""},{"$f":"IF(G90<>\"\",STDEV($G$15:G90),\"\")","v":""},""]
[77,null,null,"","","","",0,0,{"$f":"IF(G91<>\"\",AVERAGE($G$15:G91),\"\")","v":""},{"$f":"IF(G91<>\"\",STDEV($G$15:G91),\"\")","v":""},""]
[78,null,null,"","",{"$f":"IF(G92<>\"\",IF(D92=\"Pass(H0)\",\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":""},"",0,0,{"$f":"IF(G92<>\"\",AVERAGE($G$15:G92),\"\")","v":""},{"$f":"IF(G92<>\"\",STDEV($G$15:G92),\"\")","v":""},""]
[79,null,null,"","","","",0,0,{"$f":"IF(G93<>\"\",AVERAGE($G$15:G93),\"\")","v":""},{"$f":"IF(G93<>\"\",STDEV($G$15:G93),\"\")","v":""},""]
[80,null,null,"","","","",0,0,{"$f":"IF(G94<>\"\",AVERAGE($G$15:G94),\"\")","v":""},{"$f":"IF(G94<>\"\",STDEV($G$15:G94),\"\")","v":""},""]
[81,null,null,"","","","",0,0,{"$f":"IF(G95<>\"\",AVERAGE($G$15:G95),\"\")","v":""},{"$f":"IF(G95<>\"\",STDEV($G$15:G95),\"\")","v":""},""]
[82,null,null,"","","","",0,0,{"$f":"IF(G96<>\"\",AVERAGE($G$15:G96),\"\")","v":""},{"$f":"IF(G96<>\"\",STDEV($G$15:G96),\"\")","v":""},""]
[83,null,null,"","","","",0,0,{"$f":"IF(G97<>\"\",AVERAGE($G$15:G97),\"\")","v":""},{"$f":"IF(G97<>\"\",STDEV($G$15:G97),\"\")","v":""},""]
[84,null,null,"","","","",0,0,{"$f":"IF(G98<>\"\",AVERAGE($G$15:G98),\"\")","v":""},{"$f":"IF(G98<>\"\",STDEV($G$15:G98),\"\")","v":""},""]
[85,null,null,"","","","",0,0,{"$f":"IF(G99<>\"\",AVERAGE($G$15:G99),\"\")","v":""},{"$f":"IF(G99<>\"\",STDEV($G$15:G99),\"\")","v":""},""]
[86,null,null,"","","","",0,0,{"$f":"IF(G100<>\"\",AVERAGE($G$15:G100),\"\")","v":""},{"$f":"IF(G100<>\"\",STDEV($G$15:G100),\"\")","v":""},""]
[87,null,null,"","","","",0,0,{"$f":"IF(G101<>\"\",AVERAGE($G$15:G101),\"\")","v":""},{"$f":"IF(G101<>\"\",STDEV($G$15:G101),\"\")","v":""},""]
[88,null,null,"","","","",0,0,{"$f":"IF(G102<>\"\",AVERAGE($G$15:G102),\"\")","v":""},{"$f":"IF(G102<>\"\",STDEV($G$15:G102),\"\")","v":""},""]
[89,null,null,"","","","",0,0,{"$f":"IF(G103<>\"\",AVERAGE($G$15:G103),\"\")","v":""},{"$f":"IF(G103<>\"\",STDEV($G$15:G103),\"\")","v":""},""]
[90,null,null,"","","","",0,0,{"$f":"IF(G104<>\"\",AVERAGE($G$15:G104),\"\")","v":""},{"$f":"IF(G104<>\"\",STDEV($G$15:G104),\"\")","v":""},""]
[91,null,null,"","","","",0,0,{"$f":"IF(G105<>\"\",AVERAGE($G$15:G105),\"\")","v":""},{"$f":"IF(G105<>\"\",STDEV($G$15:G105),\"\")","v":""},""]
[92,null,null,"","","","",0,0,{"$f":"IF(G106<>\"\",AVERAGE($G$15:G106),\"\")","v":""},{"$f":"IF(G106<>\"\",STDEV($G$15:G106),\"\")","v":""},""]
[93,null,null,"","","","",0,0,{"$f":"IF(G107<>\"\",AVERAGE($G$15:G107),\"\")","v":""},{"$f":"IF(G107<>\"\",STDEV($G$15:G107),\"\")","v":""},""]
[94,null,null,"","","","",0,0,{"$f":"IF(G108<>\"\",AVERAGE($G$15:G108),\"\")","v":""},{"$f":"IF(G108<>\"\",STDEV($G$15:G108),\"\")","v":""},""]
[95,null,null,"","","","",0,0,{"$f":"IF(G109<>\"\",AVERAGE($G$15:G109),\"\")","v":""},{"$f":"IF(G109<>\"\",STDEV($G$15:G109),\"\")","v":""},""]
[96,null,null,"","","","",0,0,{"$f":"IF(G110<>\"\",AVERAGE($G$15:G110),\"\")","v":""},{"$f":"IF(G110<>\"\",STDEV($G$15:G110),\"\")","v":""},""]
[97,null,null,"","","","",0,0,{"$f":"IF(G111<>\"\",AVERAGE($G$15:G111),\"\")","v":""},{"$f":"IF(G111<>\"\",STDEV($G$15:G111),\"\")","v":""},""]
[98,null,null,"","","","",0,0,{"$f":"IF(G112<>\"\",AVERAGE($G$15:G112),\"\")","v":""},{"$f":"IF(G112<>\"\",STDEV($G$15:G112),\"\")","v":""},{"$f":"IF(G112<>\"\",(($M$10+$M$11)^2*K112^2)/($E$2*$E$5)^2,\"\")","v":""}]
[99,null,null,"","","","",0,0,{"$f":"IF(G113<>\"\",AVERAGE($G$15:G113),\"\")","v":""},{"$f":"IF(G113<>\"\",STDEV($G$15:G113),\"\")","v":""},""]
[100,null,null,"","","","",0,0,{"$f":"IF(G114<>\"\",AVERAGE($G$15:G114),\"\")","v":""},{"$f":"IF(G114<>\"\",STDEV($G$15:G114),\"\")","v":""},""]

{"sheet":"Unpaired Unknown-Project","index":1,"n_rows":113,"n_cols":35,"rows_kept":113,"cut":false,"hidden":false,"merged":[[11,4,11,5],[11,8,11,9],[0,0,6,2],[0,3,0,11],[3,6,4,6],[3,5,4,5],[5,6,6,6],[37,12,40,14],[41,12,46,14],[17,12,20,14],[25,12,28,14],[12,12,12,14],[13,12,16,14],[21,12,24,14],[29,12,32,14],[33,12,36,14]]}
["Step 1.  Ensure Data to be Verified will be an Unpaired Comparison.  This worksheet is designed for cases where no monumented plots can be remeasured by verifiers.  Verifers must install their own plots and use the sequential sampling worksheet to compare (sub)population estimates between verifier and project.   Refer to verification guidelines for more details.  The worksheet must be used for each carbon pool independently, or combined where allowed, according guidance in the verification section.",null,null,"Sequential Sampling Worksheet for Verification Inventory where Project Plots are not Monumented"]
[null,null,null,"Allowance:",0.1,"Number of Strata in Verification Sample:",3]
[null,null,null,"Alpha:",0.05,"Project Acreage:",">10,000"]
[null,null,null,"Project/Stratum  n:",null,"Minimum Number of Passing Plots in Sequence:",6]
[null,null,null,"Project/Stratum Mean:"]
[null,null,null,"Project/Stratum SD:",null,null,"*or 1st passing plot after 12 measured plots"]
[]
[null,null,null,"a:",{"$f":"NORMINV($E$3/2,0,1)","v":-1.9599639845400538}]
[null,null,null,"d:",{"$f":"E5*E2","v":0}]
[]
[]
[null,"Carbon Estimates",null,null,null,null,null,null,"Confidence Interval"]
["Verifier Plot  (n)","Verification","Running Examination/Plot Success","Number of Passing Plots in Sequence","Status of Verification","All Plots (Verifier + Project) n","Upper","Lower","Running Mean","Running SD","n_Threshold","Tn","Guidance for Additional Steps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculations",null,"N","n"]
[1,null,{"$f":"IF(B14<>\"\",IF(ABS(B14-E5)<(E2*E5),\"Pass(H0)\",\"Fail(H1)\"),\"\")","v":""},{"$f":"IF(I14<>\"\",IF(C14=\"Pass(H0)\",1,0),\"\")","v":0},{"$f":"IF(I14<>\"\",IF(D14>=$G$4,\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":"Verification not Satisfied"},{"$f":"$E$4+A14","v":1},null,null,{"$f":"B14","v":0},null,null,null,"Step 2- Allowance (E2).  Adjusting the allowance below 10% will result in an uncertainty deduction being applied to the project estimates.  The allowance can never be more than 20%.  The Forest Owner has the discretion to request adjustments to the allowance value.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C14<>\"Again\",1,0)","v":1},{"$f":"A14","v":1},{"$f":"VLOOKUP(1,$AF$14:$AG$113,2,FALSE)","v":1},{"$f":"MIN(VLOOKUP(1,$AF$14:$AG$113,2,TRUE),AH14)","v":1}]
[2,null,{"$f":"IF(B15<>\"\",IF(F15>=K15,IF(G15<=0,IF(H15>=0,\"Pass(H0)\",\"Fail(H1)\"),\"Fail(H1)\"),\"Inconclusive\"),\"\")","v":""},{"$f":"IF(I15<>\"\",IF(C15=\"Pass(H0)\",1+D14,0),\"\")","v":""},{"$f":"IF(I15<>\"\",IF(D15>=$G$4,\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":""},2,{"$f":"IF(B15<>\"\",L15-$E$9,\"\")","v":""},{"$f":"IF(B15<>\"\",L15+$E$9,\"\")","v":""},{"$f":"IF(B15<>\"\",AVERAGE(B$14:$B15),\"\")","v":""},{"$f":"IF(B15<>\"\",STDEV(B$14:$B15),\"\")","v":""},{"$f":"IF(B15<>\"\",($E$8^2/$E$9^2)*($E$6^2+J15^2),\"\")","v":""},{"$f":"IF(B15<>\"\",$E$5-I15,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,{"$f":"ADDRESS(11+AH14-1,4)","v":"$D$11"},{"$f":"ADDRESS(11+AI14,4)","v":"$D$12"}]
[3,null,{"$f":"IF(B16<>\"\",IF(F16>=K16,IF(G16<=0,IF(H16>=0,\"Pass(H0)\",\"Fail(H1)\"),\"Fail(H1)\"),\"Inconclusive\"),\"\")","v":""},{"$f":"IF(I16<>\"\",IF(C16=\"Pass(H0)\",1+D15,0),\"\")","v":""},{"$f":"IF(I16<>\"\",IF(D16>=$G$4,\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":""},3,"","",{"$f":"IF(B16<>\"\",AVERAGE(B$14:$B16),\"\")","v":""},{"$f":"IF(B16<>\"\",STDEV(B$14:$B16),\"\")","v":""},"",{"$f":"IF(B16<>\"\",$E$5-I16,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,3]
[4,null,"","","",4,"","",{"$f":"IF(B17<>\"\",AVERAGE(B$14:$B17),\"\")","v":""},{"$f":"IF(B17<>\"\",STDEV(B$14:$B17),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4]
[5,null,"","","",5,"","",{"$f":"IF(B18<>\"\",AVERAGE(B$14:$B18),\"\")","v":""},{"$f":"IF(B18<>\"\",STDEV(B$14:$B18),\"\")","v":""},"","","Step 3- Project/Stratum n (E4):  Enter the number of plots installed by the forest owner in the stratum in which verification is being conducted.  If the inventory is not stratified, enter the total number of sample plots used to develop the carbon pool inventory.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,5]
[6,null,"","","",6,"","",{"$f":"IF(B19<>\"\",AVERAGE(B$14:$B19),\"\")","v":""},{"$f":"IF(B19<>\"\",STDEV(B$14:$B19),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,6]
[7,null,"","","",7,"","",{"$f":"IF(B20<>\"\",AVERAGE(B$14:$B20),\"\")","v":""},{"$f":"IF(B20<>\"\",STDEV(B$14:$B20),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7]
[8,null,"","","",8,"","",{"$f":"IF(B21<>\"\",AVERAGE(B$14:$B21),\"\")","v":""},{"$f":"IF(B21<>\"\",STDEV(B$14:$B21),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,8]
[9,null,"","","",9,"","",{"$f":"IF(B22<>\"\",AVERAGE(B$14:$B22),\"\")","v":""},{"$f":"IF(B22<>\"\",STDEV(B$14:$B22),\"\")","v":""},"","","Step 4-Project/Stratum Mean (E5):  Enter the mean estimate of CO2e for the stratum or project, if the project has not been stratified for sampling, or for the stratum selected by the verifier.  The verifier will need to use a separate worksheet for each stratum verified.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,9]
[10,null,"","","",10,"","",{"$f":"IF(B23<>\"\",AVERAGE(B$14:$B23),\"\")","v":""},{"$f":"IF(B23<>\"\",STDEV(B$14:$B23),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,10]
[11,null,"","","",11,"","",{"$f":"IF(B24<>\"\",AVERAGE(B$14:$B24),\"\")","v":""},{"$f":"IF(B24<>\"\",STDEV(B$14:$B24),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,11]
[12,null,"","","",12,"","",{"$f":"IF(B25<>\"\",AVERAGE(B$14:$B25),\"\")","v":""},{"$f":"IF(B25<>\"\",STDEV(B$14:$B25),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,12]
[13,null,"","",{"$f":"IF(I26<>\"\",IF(C26=\"Pass(H0)\",\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":""},13,"","",{"$f":"IF(B26<>\"\",AVERAGE(B$14:$B26),\"\")","v":""},{"$f":"IF(B26<>\"\",STDEV(B$14:$B26),\"\")","v":""},"","","Step 5-Project/Stratum Standard Deviation (E6):  Enter the standard deviation for the mean estimate of CO2e for the stratum or project, if the project has not been stratified for sampling, or for the stratum selected by the verifier.  The verifier will need to use a separate worksheet for each stratum verified.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,13]
[14,null,"","",{"$f":"IF(I27<>\"\",IF(C27=\"Pass(H0)\",\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":""},14,"","",{"$f":"IF(B27<>\"\",AVERAGE(B$14:$B27),\"\")","v":""},{"$f":"IF(B27<>\"\",STDEV(B$14:$B27),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,14]
[15,null,"","","",15,"","",{"$f":"IF(B28<>\"\",AVERAGE(B$14:$B28),\"\")","v":""},{"$f":"IF(B28<>\"\",STDEV(B$14:$B28),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,15]
[16,null,"","","",16,"","",{"$f":"IF(B29<>\"\",AVERAGE(B$14:$B29),\"\")","v":""},{"$f":"IF(B29<>\"\",STDEV(B$14:$B29),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,16]
[17,null,"","","",17,"","",{"$f":"IF(B30<>\"\",AVERAGE(B$14:$B30),\"\")","v":""},{"$f":"IF(B30<>\"\",STDEV(B$14:$B30),\"\")","v":""},"","","Step 6 - Number of Strata Verified (G2):  Using the pull-down menu, select the number of different strata that will be verified by the verifier.  If the project is not stratified, the number will be '1'. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,17]
[18,null,"","","",18,"","",{"$f":"IF(B31<>\"\",AVERAGE(B$14:$B31),\"\")","v":""},{"$f":"IF(B31<>\"\",STDEV(B$14:$B31),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,18]
[19,null,"","","",19,"","",{"$f":"IF(B32<>\"\",AVERAGE(B$14:$B32),\"\")","v":""},{"$f":"IF(B32<>\"\",STDEV(B$14:$B32),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,19]
[20,null,"","","",20,"","",{"$f":"IF(B33<>\"\",AVERAGE(B$14:$B33),\"\")","v":""},{"$f":"IF(B33<>\"\",STDEV(B$14:$B33),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,20]
[21,null,"","","",21,"","",{"$f":"IF(B34<>\"\",AVERAGE(B$14:$B34),\"\")","v":""},{"$f":"IF(B34<>\"\",STDEV(B$14:$B34),\"\")","v":""},"","","Step 7-Project Acreage (G3): Using the pull-down menu, select the project size class. The combination of 'Number of Strata' and 'Project Acres' will automatically determine the minimum number of passing plots in a sequence according to the verification guidance in the protocol.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,21]
[22,null,"","","",22,"","",{"$f":"IF(B35<>\"\",AVERAGE(B$14:$B35),\"\")","v":""},{"$f":"IF(B35<>\"\",STDEV(B$14:$B35),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,22]
[23,null,"","","",23,"","",{"$f":"IF(B36<>\"\",AVERAGE(B$14:$B36),\"\")","v":""},{"$f":"IF(B36<>\"\",STDEV(B$14:$B36),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,23]
[24,null,"","","",24,"","",{"$f":"IF(B37<>\"\",AVERAGE(B$14:$B37),\"\")","v":""},{"$f":"IF(B37<>\"\",STDEV(B$14:$B37),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,24]
[25,null,"","","",25,"","",{"$f":"IF(B38<>\"\",AVERAGE(B$14:$B38),\"\")","v":""},{"$f":"IF(B38<>\"\",STDEV(B$14:$B38),\"\")","v":""},"","","Step 6 - Plot Data (B14:B113): Verifiers enter their estimates for each plot as CO2-e.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,25]
[26,null,"","","",26,"","",{"$f":"IF(B39<>\"\",AVERAGE(B$14:$B39),\"\")","v":""},{"$f":"IF(B39<>\"\",STDEV(B$14:$B39),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,26]
[27,null,"","","",27,"","",{"$f":"IF(B40<>\"\",AVERAGE(B$14:$B40),\"\")","v":""},{"$f":"IF(B40<>\"\",STDEV(B$14:$B40),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,27]
[28,null,"","","",28,"","",{"$f":"IF(B41<>\"\",AVERAGE(B$14:$B41),\"\")","v":""},{"$f":"IF(B41<>\"\",STDEV(B$14:$B41),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,28]
[29,null,"","","",29,"","",{"$f":"IF(B42<>\"\",AVERAGE(B$14:$B42),\"\")","v":""},{"$f":"IF(B42<>\"\",STDEV(B$14:$B42),\"\")","v":""},"","","With each plot, the worksheet will identify that the verification is trending toward passing, trending toward failing, or not discernable with the number of plots.  The 'Status of Verification' column will indicate whether the verification yields satisfactory results when the correct number of plots pass in sequence.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,29]
[30,null,"","","",30,"","",{"$f":"IF(B43<>\"\",AVERAGE(B$14:$B43),\"\")","v":""},{"$f":"IF(B43<>\"\",STDEV(B$14:$B43),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,30]
[31,null,"","","",31,"","",{"$f":"IF(B44<>\"\",AVERAGE(B$14:$B44),\"\")","v":""},{"$f":"IF(B44<>\"\",STDEV(B$14:$B44),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,31]
[32,null,"","","",32,"","",{"$f":"IF(B45<>\"\",AVERAGE(B$14:$B45),\"\")","v":""},{"$f":"IF(B45<>\"\",STDEV(B$14:$B45),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,32]
[33,null,"","","",{"$f":"$E$4+A46","v":33},"","",{"$f":"IF(B46<>\"\",AVERAGE(B$14:$B46),\"\")","v":""},{"$f":"IF(B46<>\"\",STDEV(B$14:$B46),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C46<>\"Again\",1,0)","v":1},{"$f":"A46","v":33}]
[34,null,"","","",34,{"$f":"IF(B47<>\"\",L47-$E$9,\"\")","v":""},{"$f":"IF(B47<>\"\",L47+$E$9,\"\")","v":""},{"$f":"IF(B47<>\"\",AVERAGE(B$14:$B47),\"\")","v":""},{"$f":"IF(B47<>\"\",STDEV(B$14:$B47),\"\")","v":""},{"$f":"IF(B47<>\"\",($E$8^2/$E$9^2)*($E$6^2+J47^2),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,34]
[35,null,"","","",35,"","",{"$f":"IF(B48<>\"\",AVERAGE(B$14:$B48),\"\")","v":""},{"$f":"IF(B48<>\"\",STDEV(B$14:$B48),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,35]
[36,null,"","","",36,"","",{"$f":"IF(B49<>\"\",AVERAGE(B$14:$B49),\"\")","v":""},{"$f":"IF(B49<>\"\",STDEV(B$14:$B49),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,36]
[37,null,"","","",37,"","",{"$f":"IF(B50<>\"\",AVERAGE(B$14:$B50),\"\")","v":""},{"$f":"IF(B50<>\"\",STDEV(B$14:$B50),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,37]
[38,null,"","","",38,"","",{"$f":"IF(B51<>\"\",AVERAGE(B$14:$B51),\"\")","v":""},{"$f":"IF(B51<>\"\",STDEV(B$14:$B51),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,38]
[39,null,"","","",39,"","",{"$f":"IF(B52<>\"\",AVERAGE(B$14:$B52),\"\")","v":""},{"$f":"IF(B52<>\"\",STDEV(B$14:$B52),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,39]
[40,null,"","","",40,"","",{"$f":"IF(B53<>\"\",AVERAGE(B$14:$B53),\"\")","v":""},{"$f":"IF(B53<>\"\",STDEV(B$14:$B53),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,40]
[41,null,"","","",41,"","",{"$f":"IF(B54<>\"\",AVERAGE(B$14:$B54),\"\")","v":""},{"$f":"IF(B54<>\"\",STDEV(B$14:$B54),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,41]
[42,null,"","","",42,"","",{"$f":"IF(B55<>\"\",AVERAGE(B$14:$B55),\"\")","v":""},{"$f":"IF(B55<>\"\",STDEV(B$14:$B55),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,42]
[43,null,"","","",43,"","",{"$f":"IF(B56<>\"\",AVERAGE(B$14:$B56),\"\")","v":""},{"$f":"IF(B56<>\"\",STDEV(B$14:$B56),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,43]
[44,null,"","","",44,"","",{"$f":"IF(B57<>\"\",AVERAGE(B$14:$B57),\"\")","v":""},{"$f":"IF(B57<>\"\",STDEV(B$14:$B57),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[45,null,"","","",45,"","",{"$f":"IF(B58<>\"\",AVERAGE(B$14:$B58),\"\")","v":""},{"$f":"IF(B58<>\"\",STDEV(B$14:$B58),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,45]
[46,null,"","","",46,"","",{"$f":"IF(B59<>\"\",AVERAGE(B$14:$B59),\"\")","v":""},{"$f":"IF(B59<>\"\",STDEV(B$14:$B59),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,46]
[47,null,"","","",47,"","",{"$f":"IF(B60<>\"\",AVERAGE(B$14:$B60),\"\")","v":""},{"$f":"IF(B60<>\"\",STDEV(B$14:$B60),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,47]
[48,null,"","","",48,"","",{"$f":"IF(B61<>\"\",AVERAGE(B$14:$B61),\"\")","v":""},{"$f":"IF(B61<>\"\",STDEV(B$14:$B61),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,48]
[49,null,"","","",49,"","",{"$f":"IF(B62<>\"\",AVERAGE(B$14:$B62),\"\")","v":""},{"$f":"IF(B62<>\"\",STDEV(B$14:$B62),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,49]
[50,null,"","","",50,"","",{"$f":"IF(B63<>\"\",AVERAGE(B$14:$B63),\"\")","v":""},{"$f":"IF(B63<>\"\",STDEV(B$14:$B63),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,50]
[51,null,"","","",51,"","",{"$f":"IF(B64<>\"\",AVERAGE(B$14:$B64),\"\")","v":""},{"$f":"IF(B64<>\"\",STDEV(B$14:$B64),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,51]
[52,null,"","","",52,"","",{"$f":"IF(B65<>\"\",AVERAGE(B$14:$B65),\"\")","v":""},{"$f":"IF(B65<>\"\",STDEV(B$14:$B65),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,52]
[53,null,"","","",53,"","",{"$f":"IF(B66<>\"\",AVERAGE(B$14:$B66),\"\")","v":""},{"$f":"IF(B66<>\"\",STDEV(B$14:$B66),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,53]
[54,null,"","","",54,"","",{"$f":"IF(B67<>\"\",AVERAGE(B$14:$B67),\"\")","v":""},{"$f":"IF(B67<>\"\",STDEV(B$14:$B67),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,54]
[55,null,"","","",55,"","",{"$f":"IF(B68<>\"\",AVERAGE(B$14:$B68),\"\")","v":""},{"$f":"IF(B68<>\"\",STDEV(B$14:$B68),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,55]
[56,null,"","","",56,"","",{"$f":"IF(B69<>\"\",AVERAGE(B$14:$B69),\"\")","v":""},{"$f":"IF(B69<>\"\",STDEV(B$14:$B69),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,56]
[57,null,"","","",57,"","",{"$f":"IF(B70<>\"\",AVERAGE(B$14:$B70),\"\")","v":""},{"$f":"IF(B70<>\"\",STDEV(B$14:$B70),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,57]
[58,null,"","","",58,"","",{"$f":"IF(B71<>\"\",AVERAGE(B$14:$B71),\"\")","v":""},{"$f":"IF(B71<>\"\",STDEV(B$14:$B71),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,58]
[59,null,"","","",59,"","",{"$f":"IF(B72<>\"\",AVERAGE(B$14:$B72),\"\")","v":""},{"$f":"IF(B72<>\"\",STDEV(B$14:$B72),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,59]
[60,null,"","","",60,"","",{"$f":"IF(B73<>\"\",AVERAGE(B$14:$B73),\"\")","v":""},{"$f":"IF(B73<>\"\",STDEV(B$14:$B73),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,60]
[61,null,"","","",61,"","",{"$f":"IF(B74<>\"\",AVERAGE(B$14:$B74),\"\")","v":""},{"$f":"IF(B74<>\"\",STDEV(B$14:$B74),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,61]
[62,null,"","","",62,"","",{"$f":"IF(B75<>\"\",AVERAGE(B$14:$B75),\"\")","v":""},{"$f":"IF(B75<>\"\",STDEV(B$14:$B75),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,62]
[63,null,"","","",63,"","",{"$f":"IF(B76<>\"\",AVERAGE(B$14:$B76),\"\")","v":""},{"$f":"IF(B76<>\"\",STDEV(B$14:$B76),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,63]
[64,null,"","","",64,"","",{"$f":"IF(B77<>\"\",AVERAGE(B$14:$B77),\"\")","v":""},{"$f":"IF(B77<>\"\",STDEV(B$14:$B77),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,64]
[65,null,"","","",{"$f":"$E$4+A78","v":65},"","",{"$f":"IF(B78<>\"\",AVERAGE(B$14:$B78),\"\")","v":""},{"$f":"IF(B78<>\"\",STDEV(B$14:$B78),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C78<>\"Again\",1,0)","v":1},{"$f":"A78","v":65}]
[66,null,"","","",66,{"$f":"IF(B79<>\"\",L79-$E$9,\"\")","v":""},{"$f":"IF(B79<>\"\",L79+$E$9,\"\")","v":""},{"$f":"IF(B79<>\"\",AVERAGE(B$14:$B79),\"\")","v":""},{"$f":"IF(B79<>\"\",STDEV(B$14:$B79),\"\")","v":""},{"$f":"IF(B79<>\"\",($E$8^2/$E$9^2)*($E$6^2+J79^2),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,66]
[67,null,{"$f":"IF(B80<>\"\",IF(F80>=K80,IF(G80<=0,IF(H80>=0,\"Pass(H0)\",\"Fail(H1)\"),\"Fail(H1)\"),\"Inconclusive\"),\"\")","v":""},{"$f":"IF(I80<>\"\",IF(C80=\"Pass(H0)\",1+D79,0),\"\")","v":""},"",67,"","",{"$f":"IF(B80<>\"\",AVERAGE(B$14:$B80),\"\")","v":""},{"$f":"IF(B80<>\"\",STDEV(B$14:$B80),\"\")","v":""},"",{"$f":"IF(B80<>\"\",$E$5-I80,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,67]
[68,null,"","","",68,"","",{"$f":"IF(B81<>\"\",AVERAGE(B$14:$B81),\"\")","v":""},{"$f":"IF(B81<>\"\",STDEV(B$14:$B81),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,68]
[69,null,"","","",69,"","",{"$f":"IF(B82<>\"\",AVERAGE(B$14:$B82),\"\")","v":""},{"$f":"IF(B82<>\"\",STDEV(B$14:$B82),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,69]
[70,null,"","","",70,"","",{"$f":"IF(B83<>\"\",AVERAGE(B$14:$B83),\"\")","v":""},{"$f":"IF(B83<>\"\",STDEV(B$14:$B83),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,70]
[71,null,"","","",71,"","",{"$f":"IF(B84<>\"\",AVERAGE(B$14:$B84),\"\")","v":""},{"$f":"IF(B84<>\"\",STDEV(B$14:$B84),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,71]
[72,null,"","","",72,"","",{"$f":"IF(B85<>\"\",AVERAGE(B$14:$B85),\"\")","v":""},{"$f":"IF(B85<>\"\",STDEV(B$14:$B85),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,72]
[73,null,"","","",73,"","",{"$f":"IF(B86<>\"\",AVERAGE(B$14:$B86),\"\")","v":""},{"$f":"IF(B86<>\"\",STDEV(B$14:$B86),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,73]
[74,null,"","","",74,"","",{"$f":"IF(B87<>\"\",AVERAGE(B$14:$B87),\"\")","v":""},{"$f":"IF(B87<>\"\",STDEV(B$14:$B87),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,74]
[75,null,"","","",75,"","",{"$f":"IF(B88<>\"\",AVERAGE(B$14:$B88),\"\")","v":""},{"$f":"IF(B88<>\"\",STDEV(B$14:$B88),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,75]
[76,null,"","","",76,"","",{"$f":"IF(B89<>\"\",AVERAGE(B$14:$B89),\"\")","v":""},{"$f":"IF(B89<>\"\",STDEV(B$14:$B89),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,76]
[77,null,"","","",77,"","",{"$f":"IF(B90<>\"\",AVERAGE(B$14:$B90),\"\")","v":""},{"$f":"IF(B90<>\"\",STDEV(B$14:$B90),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,77]
[78,null,"","",{"$f":"IF(I91<>\"\",IF(C91=\"Pass(H0)\",\"Verification Successful\", \"Verification not Satisfied\"),\"\")","v":""},78,"","",{"$f":"IF(B91<>\"\",AVERAGE(B$14:$B91),\"\")","v":""},{"$f":"IF(B91<>\"\",STDEV(B$14:$B91),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,78]
[79,null,"","","",79,"","",{"$f":"IF(B92<>\"\",AVERAGE(B$14:$B92),\"\")","v":""},{"$f":"IF(B92<>\"\",STDEV(B$14:$B92),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,79]
[80,null,"","","",80,"","",{"$f":"IF(B93<>\"\",AVERAGE(B$14:$B93),\"\")","v":""},{"$f":"IF(B93<>\"\",STDEV(B$14:$B93),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,80]
[81,null,"","","",81,"","",{"$f":"IF(B94<>\"\",AVERAGE(B$14:$B94),\"\")","v":""},{"$f":"IF(B94<>\"\",STDEV(B$14:$B94),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,81]
[82,null,"","","",82,"","",{"$f":"IF(B95<>\"\",AVERAGE(B$14:$B95),\"\")","v":""},{"$f":"IF(B95<>\"\",STDEV(B$14:$B95),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,82]
[83,null,"","","",83,"","",{"$f":"IF(B96<>\"\",AVERAGE(B$14:$B96),\"\")","v":""},{"$f":"IF(B96<>\"\",STDEV(B$14:$B96),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,83]
[84,null,"","","",84,"","",{"$f":"IF(B97<>\"\",AVERAGE(B$14:$B97),\"\")","v":""},{"$f":"IF(B97<>\"\",STDEV(B$14:$B97),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,84]
[85,null,"","","",85,"","",{"$f":"IF(B98<>\"\",AVERAGE(B$14:$B98),\"\")","v":""},{"$f":"IF(B98<>\"\",STDEV(B$14:$B98),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,85]
[86,null,"","","",86,"","",{"$f":"IF(B99<>\"\",AVERAGE(B$14:$B99),\"\")","v":""},{"$f":"IF(B99<>\"\",STDEV(B$14:$B99),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,86]
[87,null,"","","",87,"","",{"$f":"IF(B100<>\"\",AVERAGE(B$14:$B100),\"\")","v":""},{"$f":"IF(B100<>\"\",STDEV(B$14:$B100),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,87]
[88,null,"","","",88,"","",{"$f":"IF(B101<>\"\",AVERAGE(B$14:$B101),\"\")","v":""},{"$f":"IF(B101<>\"\",STDEV(B$14:$B101),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,88]
[89,null,"","","",89,"","",{"$f":"IF(B102<>\"\",AVERAGE(B$14:$B102),\"\")","v":""},{"$f":"IF(B102<>\"\",STDEV(B$14:$B102),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,89]
[90,null,"","","",90,"","",{"$f":"IF(B103<>\"\",AVERAGE(B$14:$B103),\"\")","v":""},{"$f":"IF(B103<>\"\",STDEV(B$14:$B103),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,90]
[91,null,"","","",91,"","",{"$f":"IF(B104<>\"\",AVERAGE(B$14:$B104),\"\")","v":""},{"$f":"IF(B104<>\"\",STDEV(B$14:$B104),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,91]
[92,null,"","","",92,"","",{"$f":"IF(B105<>\"\",AVERAGE(B$14:$B105),\"\")","v":""},{"$f":"IF(B105<>\"\",STDEV(B$14:$B105),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,92]
[93,null,"","","",93,"","",{"$f":"IF(B106<>\"\",AVERAGE(B$14:$B106),\"\")","v":""},{"$f":"IF(B106<>\"\",STDEV(B$14:$B106),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,93]
[94,null,"","","",94,"","",{"$f":"IF(B107<>\"\",AVERAGE(B$14:$B107),\"\")","v":""},{"$f":"IF(B107<>\"\",STDEV(B$14:$B107),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,94]
[95,null,"","","",95,"","",{"$f":"IF(B108<>\"\",AVERAGE(B$14:$B108),\"\")","v":""},{"$f":"IF(B108<>\"\",STDEV(B$14:$B108),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,95]
[96,null,"","","",96,"","",{"$f":"IF(B109<>\"\",AVERAGE(B$14:$B109),\"\")","v":""},{"$f":"IF(B109<>\"\",STDEV(B$14:$B109),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,96]
[97,null,"","","",97,"","",{"$f":"IF(B110<>\"\",AVERAGE(B$14:$B110),\"\")","v":""},{"$f":"IF(B110<>\"\",STDEV(B$14:$B110),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,97]
[98,null,"","","",98,"","",{"$f":"IF(B111<>\"\",AVERAGE(B$14:$B111),\"\")","v":""},{"$f":"IF(B111<>\"\",STDEV(B$14:$B111),\"\")","v":""},{"$f":"IF(B111<>\"\",($E$8^2/$E$9^2)*($E$6^2+J111^2),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,98]
[99,null,"","","",99,"","",{"$f":"IF(B112<>\"\",AVERAGE(B$14:$B112),\"\")","v":""},{"$f":"IF(B112<>\"\",STDEV(B$14:$B112),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,99]
[100,null,"","","",100,"","",{"$f":"IF(B113<>\"\",AVERAGE(B$14:$B113),\"\")","v":""},{"$f":"IF(B113<>\"\",STDEV(B$14:$B113),\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,100]

{"sheet":"Dia_Height_Stopping Rules_US","index":2,"n_rows":113,"n_cols":18,"rows_kept":113,"cut":false,"hidden":false,"merged":[[11,0,11,8],[11,9,11,17],[13,7,51,8],[13,16,51,17],[0,0,1,17],[3,0,3,2],[3,9,3,11],[4,0,5,1],[4,9,5,10],[6,0,6,2],[6,9,6,11]]}
["Sequential Sampling for Diameter and Height - Paired and Unpaired"]
[]
[]
["Tolerance Thresholds",null,null,"Inches",null,null,null,null,null,"Tolerance Thresholds",null,null,"Feet"]
["Mean Average of Differences",null,"Lower Threshold",-0.25,null,null,null,null,null,"Mean Average of Differences",null,"Lower Threshold",-1]
[null,null,"Upper Threshold",0.25,null,null,null,null,null,null,null,"Upper Threshold",1]
["Standard Deviation of Difference Limit",null,null,1,null,null,null,null,null,"Standard Deviation of Difference Limit",null,null,6]
[]
[]
[]
[]
["Diameter (inches)",null,null,null,null,null,null,null,null,"Height (feet)"]
["Number","Plot Number","Tree Number","PD Number","VB Number","Difference","Mean of Difference","Standard Deviation of Difference","Stop?","Number","Plot Number","Tree Number","PD Number","VB Number","Difference","Mean of Difference","Standard Deviation of Difference","Stop?"]
[1,null,null,null,null,{"$f":"(D14-E14)","v":0},{"$f":"AVERAGE($F$14:F14)","v":0},"Pre-testing",null,1,null,null,null,null,{"$f":"(M14-N14)","v":0},{"$f":"AVERAGE($O$14:O14)","v":0},"Pre-testing"]
[2,null,null,null,null,{"$f":"IF(D15>0,(D15-E15),\"\")","v":""},{"$f":"IF(D15>0,AVERAGE($F$14:F15),\"\")","v":""},null,null,2,null,null,null,null,{"$f":"IF(M15>0,(M15-N15),\"\")","v":""},{"$f":"AVERAGE($O$14:O15)","v":0}]
[3,null,null,null,null,{"$f":"IF(D16>0,(D16-E16),\"\")","v":""},{"$f":"IF(D16>0,AVERAGE($F$14:F16),\"\")","v":""},null,null,3,null,null,null,null,{"$f":"IF(M16>0,(M16-N16),\"\")","v":""},{"$f":"AVERAGE($O$14:O16)","v":0}]
[4,null,null,null,null,"",{"$f":"IF(D17>0,AVERAGE($F$14:F17),\"\")","v":""},null,null,4,null,null,null,null,"",{"$f":"AVERAGE($O$14:O17)","v":0}]
[5,null,null,null,null,"",{"$f":"IF(D18>0,AVERAGE($F$14:F18),\"\")","v":""},null,null,5,null,null,null,null,"",{"$f":"AVERAGE($O$14:O18)","v":0}]
[6,null,null,null,null,"",{"$f":"IF(D19>0,AVERAGE($F$14:F19),\"\")","v":""},null,null,6,null,null,null,null,"",{"$f":"AVERAGE($O$14:O19)","v":0}]
[7,null,null,null,null,"",{"$f":"IF(D20>0,AVERAGE($F$14:F20),\"\")","v":""},null,null,7,null,null,null,null,"",{"$f":"AVERAGE($O$14:O20)","v":0}]
[8,null,null,null,null,"",{"$f":"IF(D21>0,AVERAGE($F$14:F21),\"\")","v":""},null,null,8,null,null,null,null,"",{"$f":"AVERAGE($O$14:O21)","v":0}]
[9,null,null,null,null,"",{"$f":"IF(D22>0,AVERAGE($F$14:F22),\"\")","v":""},null,null,9,null,null,null,null,"",{"$f":"AVERAGE($O$14:O22)","v":0}]
[10,null,null,null,null,"",{"$f":"IF(D23>0,AVERAGE($F$14:F23),\"\")","v":""},null,null,10,null,null,null,null,"",{"$f":"AVERAGE($O$14:O23)","v":0}]
[11,null,null,null,null,"",{"$f":"IF(D24>0,AVERAGE($F$14:F24),\"\")","v":""},null,null,11,null,null,null,null,"",{"$f":"AVERAGE($O$14:O24)","v":0}]
[12,null,null,null,null,"",{"$f":"IF(D25>0,AVERAGE($F$14:F25),\"\")","v":""},null,null,12,null,null,null,null,"",{"$f":"AVERAGE($O$14:O25)","v":0}]
[13,null,null,null,null,"",{"$f":"IF(D26>0,AVERAGE($F$14:F26),\"\")","v":""},null,null,13,null,null,null,null,"",{"$f":"AVERAGE($O$14:O26)","v":0}]
[14,null,null,null,null,"",{"$f":"IF(D27>0,AVERAGE($F$14:F27),\"\")","v":""},null,null,14,null,null,null,null,"",{"$f":"AVERAGE($O$14:O27)","v":0}]
[15,null,null,null,null,"",{"$f":"IF(D28>0,AVERAGE($F$14:F28),\"\")","v":""},null,null,15,null,null,null,null,"",{"$f":"AVERAGE($O$14:O28)","v":0}]
[16,null,null,null,null,"",{"$f":"IF(D29>0,AVERAGE($F$14:F29),\"\")","v":""},null,null,16,null,null,null,null,"",{"$f":"AVERAGE($O$14:O29)","v":0}]
[17,null,null,null,null,"",{"$f":"IF(D30>0,AVERAGE($F$14:F30),\"\")","v":""},null,null,17,null,null,null,null,"",{"$f":"AVERAGE($O$14:O30)","v":0}]
[18,null,null,null,null,"",{"$f":"IF(D31>0,AVERAGE($F$14:F31),\"\")","v":""},null,null,18,null,null,null,null,"",{"$f":"AVERAGE($O$14:O31)","v":0}]
[19,null,null,null,null,"",{"$f":"IF(D32>0,AVERAGE($F$14:F32),\"\")","v":""},null,null,19,null,null,null,null,"",{"$f":"AVERAGE($O$14:O32)","v":0}]
[20,null,null,null,null,"",{"$f":"IF(D33>0,AVERAGE($F$14:F33),\"\")","v":""},null,null,20,null,null,null,null,"",{"$f":"AVERAGE($O$14:O33)","v":0}]
[21,null,null,null,null,"",{"$f":"IF(D34>0,AVERAGE($F$14:F34),\"\")","v":""},null,null,21,null,null,null,null,"",{"$f":"AVERAGE($O$14:O34)","v":0}]
[22,null,null,null,null,"",{"$f":"IF(D35>0,AVERAGE($F$14:F35),\"\")","v":""},null,null,22,null,null,null,null,"",{"$f":"AVERAGE($O$14:O35)","v":0}]
[23,null,null,null,null,"",{"$f":"IF(D36>0,AVERAGE($F$14:F36),\"\")","v":""},null,null,23,null,null,null,null,"",{"$f":"AVERAGE($O$14:O36)","v":0}]
[24,null,null,null,null,"",{"$f":"IF(D37>0,AVERAGE($F$14:F37),\"\")","v":""},null,null,24,null,null,null,null,"",{"$f":"AVERAGE($O$14:O37)","v":0}]
[25,null,null,null,null,"",{"$f":"IF(D38>0,AVERAGE($F$14:F38),\"\")","v":""},null,null,25,null,null,null,null,"",{"$f":"AVERAGE($O$14:O38)","v":0}]
[26,null,null,null,null,"",{"$f":"IF(D39>0,AVERAGE($F$14:F39),\"\")","v":""},null,null,26,null,null,null,null,"",{"$f":"AVERAGE($O$14:O39)","v":0}]
[27,null,null,null,null,"",{"$f":"IF(D40>0,AVERAGE($F$14:F40),\"\")","v":""},null,null,27,null,null,null,null,"",{"$f":"AVERAGE($O$14:O40)","v":0}]
[28,null,null,null,null,"",{"$f":"IF(D41>0,AVERAGE($F$14:F41),\"\")","v":""},null,null,28,null,null,null,null,"",{"$f":"AVERAGE($O$14:O41)","v":0}]
[29,null,null,null,null,"",{"$f":"IF(D42>0,AVERAGE($F$14:F42),\"\")","v":""},null,null,29,null,null,null,null,"",{"$f":"AVERAGE($O$14:O42)","v":0}]
[30,null,null,null,null,"",{"$f":"IF(D43>0,AVERAGE($F$14:F43),\"\")","v":""},null,null,30,null,null,null,null,"",{"$f":"AVERAGE($O$14:O43)","v":0}]
[31,null,null,null,null,"",{"$f":"IF(D44>0,AVERAGE($F$14:F44),\"\")","v":""},null,null,31,null,null,null,null,"",{"$f":"AVERAGE($O$14:O44)","v":0}]
[32,null,null,null,null,"",{"$f":"IF(D45>0,AVERAGE($F$14:F45),\"\")","v":""},null,null,32,null,null,null,null,"",{"$f":"AVERAGE($O$14:O45)","v":0}]
[33,null,null,null,null,"",{"$f":"IF(D46>0,AVERAGE($F$14:F46),\"\")","v":""},null,null,33,null,null,null,null,"",{"$f":"AVERAGE($O$14:O46)","v":0}]
[34,null,null,null,null,"",{"$f":"IF(D47>0,AVERAGE($F$14:F47),\"\")","v":""},null,null,34,null,null,null,null,"",{"$f":"AVERAGE($O$14:O47)","v":0}]
[35,null,null,null,null,"",{"$f":"IF(D48>0,AVERAGE($F$14:F48),\"\")","v":""},null,null,35,null,null,null,null,"",{"$f":"AVERAGE($O$14:O48)","v":0}]
[36,null,null,null,null,"",{"$f":"IF(D49>0,AVERAGE($F$14:F49),\"\")","v":""},null,null,36,null,null,null,null,"",{"$f":"AVERAGE($O$14:O49)","v":0}]
[37,null,null,null,null,"",{"$f":"IF(D50>0,AVERAGE($F$14:F50),\"\")","v":""},null,null,37,null,null,null,null,"",{"$f":"AVERAGE($O$14:O50)","v":0}]
[38,null,null,null,null,"",{"$f":"IF(D51>0,AVERAGE($F$14:F51),\"\")","v":""},null,null,38,null,null,null,null,"",{"$f":"AVERAGE($O$14:O51)","v":0}]
[39,null,null,null,null,"",{"$f":"IF(D52>0,AVERAGE($F$14:F52),\"\")","v":""},null,null,39,null,null,null,null,"",{"$f":"AVERAGE($O$14:O52)","v":0}]
[40,null,null,null,null,"",{"$f":"IF(D53>0,AVERAGE($F$14:F53),\"\")","v":""},{"$f":"IF(D53>0,STDEVA($F$14:F53),\"\")","v":""},{"$f":"IF(D53>0,IF(AND(G53>$D$5,G53<$D$6,H53<$D$7),\"Stop\",\"Continue\"),\"\")","v":""},40,null,null,null,null,"",{"$f":"AVERAGE($O$14:O53)","v":0},{"$f":"IF(M53>0,STDEVA($O$14:O53),\"\")","v":""},{"$f":"IF(M53>0,IF(AND(P53>$M$5,P53<$M$6,Q53<$M$7),\"Stop\",\"Continue\"),\"\")","v":""}]
[41,null,null,null,null,"",{"$f":"IF(D54>0,AVERAGE($F$14:F54),\"\")","v":""},{"$f":"IF(D54>0,STDEVA($F$14:F54),\"\")","v":""},{"$f":"IF(D54>0,IF(AND(G54>$D$5,G54<$D$6,H54<$D$7),\"Stop\",\"Continue\"),\"\")","v":""},41,null,null,null,null,"",{"$f":"AVERAGE($O$14:O54)","v":0},{"$f":"IF(M54>0,STDEVA($O$14:O54),\"\")","v":""},{"$f":"IF(M54>0,IF(AND(P54>$M$5,P54<$M$6,Q54<$M$7),\"Stop\",\"Continue\"),\"\")","v":""}]
[42,null,null,null,null,"",{"$f":"IF(D55>0,AVERAGE($F$14:F55),\"\")","v":""},{"$f":"IF(D55>0,STDEVA($F$14:F55),\"\")","v":""},"",42,null,null,null,null,"",{"$f":"AVERAGE($O$14:O55)","v":0},{"$f":"IF(M55>0,STDEVA($O$14:O55),\"\")","v":""},""]
[43,null,null,null,null,"",{"$f":"IF(D56>0,AVERAGE($F$14:F56),\"\")","v":""},{"$f":"IF(D56>0,STDEVA($F$14:F56),\"\")","v":""},"",43,null,null,null,null,"",{"$f":"AVERAGE($O$14:O56)","v":0},{"$f":"IF(M56>0,STDEVA($O$14:O56),\"\")","v":""},""]
[44,null,null,null,null,"",{"$f":"IF(D57>0,AVERAGE($F$14:F57),\"\")","v":""},{"$f":"IF(D57>0,STDEVA($F$14:F57),\"\")","v":""},"",44,null,null,null,null,"",{"$f":"AVERAGE($O$14:O57)","v":0},{"$f":"IF(M57>0,STDEVA($O$14:O57),\"\")","v":""},""]
[45,null,null,null,null,"",{"$f":"IF(D58>0,AVERAGE($F$14:F58),\"\")","v":""},{"$f":"IF(D58>0,STDEVA($F$14:F58),\"\")","v":""},"",45,null,null,null,null,"",{"$f":"AVERAGE($O$14:O58)","v":0},{"$f":"IF(M58>0,STDEVA($O$14:O58),\"\")","v":""},""]
[46,null,null,null,null,"",{"$f":"IF(D59>0,AVERAGE($F$14:F59),\"\")","v":""},{"$f":"IF(D59>0,STDEVA($F$14:F59),\"\")","v":""},"",46,null,null,null,null,"",{"$f":"AVERAGE($O$14:O59)","v":0},{"$f":"IF(M59>0,STDEVA($O$14:O59),\"\")","v":""},""]
[47,null,null,null,null,"",{"$f":"IF(D60>0,AVERAGE($F$14:F60),\"\")","v":""},{"$f":"IF(D60>0,STDEVA($F$14:F60),\"\")","v":""},"",47,null,null,null,null,"",{"$f":"AVERAGE($O$14:O60)","v":0},{"$f":"IF(M60>0,STDEVA($O$14:O60),\"\")","v":""},""]
[48,null,null,null,null,"",{"$f":"IF(D61>0,AVERAGE($F$14:F61),\"\")","v":""},{"$f":"IF(D61>0,STDEVA($F$14:F61),\"\")","v":""},"",48,null,null,null,null,"",{"$f":"AVERAGE($O$14:O61)","v":0},{"$f":"IF(M61>0,STDEVA($O$14:O61),\"\")","v":""},""]
[49,null,null,null,null,"",{"$f":"IF(D62>0,AVERAGE($F$14:F62),\"\")","v":""},{"$f":"IF(D62>0,STDEVA($F$14:F62),\"\")","v":""},"",49,null,null,null,null,"",{"$f":"AVERAGE($O$14:O62)","v":0},{"$f":"IF(M62>0,STDEVA($O$14:O62),\"\")","v":""},""]
[50,null,null,null,null,"",{"$f":"IF(D63>0,AVERAGE($F$14:F63),\"\")","v":""},{"$f":"IF(D63>0,STDEVA($F$14:F63),\"\")","v":""},"",50,null,null,null,null,"",{"$f":"AVERAGE($O$14:O63)","v":0},{"$f":"IF(M63>0,STDEVA($O$14:O63),\"\")","v":""},""]
[51,null,null,null,null,"",{"$f":"IF(D64>0,AVERAGE($F$14:F64),\"\")","v":""},{"$f":"IF(D64>0,STDEVA($F$14:F64),\"\")","v":""},"",51,null,null,null,null,"",{"$f":"AVERAGE($O$14:O64)","v":0},{"$f":"IF(M64>0,STDEVA($O$14:O64),\"\")","v":""},""]
[52,null,null,null,null,"",{"$f":"IF(D65>0,AVERAGE($F$14:F65),\"\")","v":""},{"$f":"IF(D65>0,STDEVA($F$14:F65),\"\")","v":""},"",52,null,null,null,null,"",{"$f":"AVERAGE($O$14:O65)","v":0},{"$f":"IF(M65>0,STDEVA($O$14:O65),\"\")","v":""},""]
[53,null,null,null,null,"",{"$f":"IF(D66>0,AVERAGE($F$14:F66),\"\")","v":""},{"$f":"IF(D66>0,STDEVA($F$14:F66),\"\")","v":""},"",53,null,null,null,null,"",{"$f":"AVERAGE($O$14:O66)","v":0},{"$f":"IF(M66>0,STDEVA($O$14:O66),\"\")","v":""},""]
[54,null,null,null,null,"",{"$f":"IF(D67>0,AVERAGE($F$14:F67),\"\")","v":""},{"$f":"IF(D67>0,STDEVA($F$14:F67),\"\")","v":""},"",54,null,null,null,null,"",{"$f":"AVERAGE($O$14:O67)","v":0},{"$f":"IF(M67>0,STDEVA($O$14:O67),\"\")","v":""},""]
[55,null,null,null,null,"",{"$f":"IF(D68>0,AVERAGE($F$14:F68),\"\")","v":""},{"$f":"IF(D68>0,STDEVA($F$14:F68),\"\")","v":""},"",55,null,null,null,null,"",{"$f":"AVERAGE($O$14:O68)","v":0},{"$f":"IF(M68>0,STDEVA($O$14:O68),\"\")","v":""},""]
[56,null,null,null,null,"",{"$f":"IF(D69>0,AVERAGE($F$14:F69),\"\")","v":""},{"$f":"IF(D69>0,STDEVA($F$14:F69),\"\")","v":""},"",56,null,null,null,null,"",{"$f":"AVERAGE($O$14:O69)","v":0},{"$f":"IF(M69>0,STDEVA($O$14:O69),\"\")","v":""},""]
[57,null,null,null,null,"",{"$f":"IF(D70>0,AVERAGE($F$14:F70),\"\")","v":""},{"$f":"IF(D70>0,STDEVA($F$14:F70),\"\")","v":""},"",57,null,null,null,null,"",{"$f":"AVERAGE($O$14:O70)","v":0},{"$f":"IF(M70>0,STDEVA($O$14:O70),\"\")","v":""},""]
[58,null,null,null,null,"",{"$f":"IF(D71>0,AVERAGE($F$14:F71),\"\")","v":""},{"$f":"IF(D71>0,STDEVA($F$14:F71),\"\")","v":""},"",58,null,null,null,null,"",{"$f":"AVERAGE($O$14:O71)","v":0},{"$f":"IF(M71>0,STDEVA($O$14:O71),\"\")","v":""},""]
[59,null,null,null,null,"",{"$f":"IF(D72>0,AVERAGE($F$14:F72),\"\")","v":""},{"$f":"IF(D72>0,STDEVA($F$14:F72),\"\")","v":""},"",59,null,null,null,null,"",{"$f":"AVERAGE($O$14:O72)","v":0},{"$f":"IF(M72>0,STDEVA($O$14:O72),\"\")","v":""},""]
[60,null,null,null,null,"",{"$f":"IF(D73>0,AVERAGE($F$14:F73),\"\")","v":""},{"$f":"IF(D73>0,STDEVA($F$14:F73),\"\")","v":""},"",60,null,null,null,null,"",{"$f":"AVERAGE($O$14:O73)","v":0},{"$f":"IF(M73>0,STDEVA($O$14:O73),\"\")","v":""},""]
[61,null,null,null,null,"",{"$f":"IF(D74>0,AVERAGE($F$14:F74),\"\")","v":""},{"$f":"IF(D74>0,STDEVA($F$14:F74),\"\")","v":""},"",61,null,null,null,null,"",{"$f":"AVERAGE($O$14:O74)","v":0},{"$f":"IF(M74>0,STDEVA($O$14:O74),\"\")","v":""},""]
[62,null,null,null,null,"",{"$f":"IF(D75>0,AVERAGE($F$14:F75),\"\")","v":""},{"$f":"IF(D75>0,STDEVA($F$14:F75),\"\")","v":""},"",62,null,null,null,null,"",{"$f":"AVERAGE($O$14:O75)","v":0},{"$f":"IF(M75>0,STDEVA($O$14:O75),\"\")","v":""},""]
[63,null,null,null,null,"",{"$f":"IF(D76>0,AVERAGE($F$14:F76),\"\")","v":""},{"$f":"IF(D76>0,STDEVA($F$14:F76),\"\")","v":""},"",63,null,null,null,null,"",{"$f":"AVERAGE($O$14:O76)","v":0},{"$f":"IF(M76>0,STDEVA($O$14:O76),\"\")","v":""},""]
[64,null,null,null,null,"",{"$f":"IF(D77>0,AVERAGE($F$14:F77),\"\")","v":""},{"$f":"IF(D77>0,STDEVA($F$14:F77),\"\")","v":""},"",64,null,null,null,null,"",{"$f":"AVERAGE($O$14:O77)","v":0},{"$f":"IF(M77>0,STDEVA($O$14:O77),\"\")","v":""},""]
[65,null,null,null,null,"",{"$f":"IF(D78>0,AVERAGE($F$14:F78),\"\")","v":""},{"$f":"IF(D78>0,STDEVA($F$14:F78),\"\")","v":""},"",65,null,null,null,null,"",{"$f":"AVERAGE($O$14:O78)","v":0},{"$f":"IF(M78>0,STDEVA($O$14:O78),\"\")","v":""},""]
[66,null,null,null,null,"",{"$f":"IF(D79>0,AVERAGE($F$14:F79),\"\")","v":""},{"$f":"IF(D79>0,STDEVA($F$14:F79),\"\")","v":""},"",66,null,null,null,null,"",{"$f":"AVERAGE($O$14:O79)","v":0},{"$f":"IF(M79>0,STDEVA($O$14:O79),\"\")","v":""},""]
[67,null,null,null,null,{"$f":"IF(D80>0,(D80-E80),\"\")","v":""},{"$f":"IF(D80>0,AVERAGE($F$14:F80),\"\")","v":""},{"$f":"IF(D80>0,STDEVA($F$14:F80),\"\")","v":""},"",67,null,null,null,null,{"$f":"IF(M80>0,(M80-N80),\"\")","v":""},{"$f":"AVERAGE($O$14:O80)","v":0},{"$f":"IF(M80>0,STDEVA($O$14:O80),\"\")","v":""},""]
[68,null,null,null,null,"",{"$f":"IF(D81>0,AVERAGE($F$14:F81),\"\")","v":""},{"$f":"IF(D81>0,STDEVA($F$14:F81),\"\")","v":""},"",68,null,null,null,null,"",{"$f":"AVERAGE($O$14:O81)","v":0},{"$f":"IF(M81>0,STDEVA($O$14:O81),\"\")","v":""},""]
[69,null,null,null,null,"",{"$f":"IF(D82>0,AVERAGE($F$14:F82),\"\")","v":""},{"$f":"IF(D82>0,STDEVA($F$14:F82),\"\")","v":""},"",69,null,null,null,null,"",{"$f":"AVERAGE($O$14:O82)","v":0},{"$f":"IF(M82>0,STDEVA($O$14:O82),\"\")","v":""},""]
[70,null,null,null,null,"",{"$f":"IF(D83>0,AVERAGE($F$14:F83),\"\")","v":""},{"$f":"IF(D83>0,STDEVA($F$14:F83),\"\")","v":""},"",70,null,null,null,null,"",{"$f":"AVERAGE($O$14:O83)","v":0},{"$f":"IF(M83>0,STDEVA($O$14:O83),\"\")","v":""},""]
[71,null,null,null,null,"",{"$f":"IF(D84>0,AVERAGE($F$14:F84),\"\")","v":""},{"$f":"IF(D84>0,STDEVA($F$14:F84),\"\")","v":""},"",71,null,null,null,null,"",{"$f":"AVERAGE($O$14:O84)","v":0},{"$f":"IF(M84>0,STDEVA($O$14:O84),\"\")","v":""},""]
[72,null,null,null,null,"",{"$f":"IF(D85>0,AVERAGE($F$14:F85),\"\")","v":""},{"$f":"IF(D85>0,STDEVA($F$14:F85),\"\")","v":""},"",72,null,null,null,null,"",{"$f":"AVERAGE($O$14:O85)","v":0},{"$f":"IF(M85>0,STDEVA($O$14:O85),\"\")","v":""},""]
[73,null,null,null,null,"",{"$f":"IF(D86>0,AVERAGE($F$14:F86),\"\")","v":""},{"$f":"IF(D86>0,STDEVA($F$14:F86),\"\")","v":""},"",73,null,null,null,null,"",{"$f":"AVERAGE($O$14:O86)","v":0},{"$f":"IF(M86>0,STDEVA($O$14:O86),\"\")","v":""},""]
[74,null,null,null,null,"",{"$f":"IF(D87>0,AVERAGE($F$14:F87),\"\")","v":""},{"$f":"IF(D87>0,STDEVA($F$14:F87),\"\")","v":""},"",74,null,null,null,null,"",{"$f":"AVERAGE($O$14:O87)","v":0},{"$f":"IF(M87>0,STDEVA($O$14:O87),\"\")","v":""},""]
[75,null,null,null,null,"",{"$f":"IF(D88>0,AVERAGE($F$14:F88),\"\")","v":""},{"$f":"IF(D88>0,STDEVA($F$14:F88),\"\")","v":""},"",75,null,null,null,null,"",{"$f":"AVERAGE($O$14:O88)","v":0},{"$f":"IF(M88>0,STDEVA($O$14:O88),\"\")","v":""},""]
[76,null,null,null,null,"",{"$f":"IF(D89>0,AVERAGE($F$14:F89),\"\")","v":""},{"$f":"IF(D89>0,STDEVA($F$14:F89),\"\")","v":""},"",76,null,null,null,null,"",{"$f":"AVERAGE($O$14:O89)","v":0},{"$f":"IF(M89>0,STDEVA($O$14:O89),\"\")","v":""},""]
[77,null,null,null,null,"",{"$f":"IF(D90>0,AVERAGE($F$14:F90),\"\")","v":""},{"$f":"IF(D90>0,STDEVA($F$14:F90),\"\")","v":""},"",77,null,null,null,null,"",{"$f":"AVERAGE($O$14:O90)","v":0},{"$f":"IF(M90>0,STDEVA($O$14:O90),\"\")","v":""},""]
[78,null,null,null,null,"",{"$f":"IF(D91>0,AVERAGE($F$14:F91),\"\")","v":""},{"$f":"IF(D91>0,STDEVA($F$14:F91),\"\")","v":""},"",78,null,null,null,null,"",{"$f":"AVERAGE($O$14:O91)","v":0},{"$f":"IF(M91>0,STDEVA($O$14:O91),\"\")","v":""},""]
[79,null,null,null,null,"",{"$f":"IF(D92>0,AVERAGE($F$14:F92),\"\")","v":""},{"$f":"IF(D92>0,STDEVA($F$14:F92),\"\")","v":""},"",79,null,null,null,null,"",{"$f":"AVERAGE($O$14:O92)","v":0},{"$f":"IF(M92>0,STDEVA($O$14:O92),\"\")","v":""},""]
[80,null,null,null,null,"",{"$f":"IF(D93>0,AVERAGE($F$14:F93),\"\")","v":""},{"$f":"IF(D93>0,STDEVA($F$14:F93),\"\")","v":""},"",80,null,null,null,null,"",{"$f":"AVERAGE($O$14:O93)","v":0},{"$f":"IF(M93>0,STDEVA($O$14:O93),\"\")","v":""},""]
[81,null,null,null,null,"",{"$f":"IF(D94>0,AVERAGE($F$14:F94),\"\")","v":""},{"$f":"IF(D94>0,STDEVA($F$14:F94),\"\")","v":""},"",81,null,null,null,null,"",{"$f":"AVERAGE($O$14:O94)","v":0},{"$f":"IF(M94>0,STDEVA($O$14:O94),\"\")","v":""},""]
[82,null,null,null,null,"",{"$f":"IF(D95>0,AVERAGE($F$14:F95),\"\")","v":""},{"$f":"IF(D95>0,STDEVA($F$14:F95),\"\")","v":""},"",82,null,null,null,null,"",{"$f":"AVERAGE($O$14:O95)","v":0},{"$f":"IF(M95>0,STDEVA($O$14:O95),\"\")","v":""},""]
[83,null,null,null,null,"",{"$f":"IF(D96>0,AVERAGE($F$14:F96),\"\")","v":""},{"$f":"IF(D96>0,STDEVA($F$14:F96),\"\")","v":""},"",83,null,null,null,null,"",{"$f":"AVERAGE($O$14:O96)","v":0},{"$f":"IF(M96>0,STDEVA($O$14:O96),\"\")","v":""},""]
[84,null,null,null,null,"",{"$f":"IF(D97>0,AVERAGE($F$14:F97),\"\")","v":""},{"$f":"IF(D97>0,STDEVA($F$14:F97),\"\")","v":""},"",84,null,null,null,null,"",{"$f":"AVERAGE($O$14:O97)","v":0},{"$f":"IF(M97>0,STDEVA($O$14:O97),\"\")","v":""},""]
[85,null,null,null,null,"",{"$f":"IF(D98>0,AVERAGE($F$14:F98),\"\")","v":""},{"$f":"IF(D98>0,STDEVA($F$14:F98),\"\")","v":""},"",85,null,null,null,null,"",{"$f":"AVERAGE($O$14:O98)","v":0},{"$f":"IF(M98>0,STDEVA($O$14:O98),\"\")","v":""},""]
[86,null,null,null,null,"",{"$f":"IF(D99>0,AVERAGE($F$14:F99),\"\")","v":""},{"$f":"IF(D99>0,STDEVA($F$14:F99),\"\")","v":""},"",86,null,null,null,null,"",{"$f":"AVERAGE($O$14:O99)","v":0},{"$f":"IF(M99>0,STDEVA($O$14:O99),\"\")","v":""},""]
[87,null,null,null,null,"",{"$f":"IF(D100>0,AVERAGE($F$14:F100),\"\")","v":""},{"$f":"IF(D100>0,STDEVA($F$14:F100),\"\")","v":""},"",87,null,null,null,null,"",{"$f":"AVERAGE($O$14:O100)","v":0},{"$f":"IF(M100>0,STDEVA($O$14:O100),\"\")","v":""},""]
[88,null,null,null,null,"",{"$f":"IF(D101>0,AVERAGE($F$14:F101),\"\")","v":""},{"$f":"IF(D101>0,STDEVA($F$14:F101),\"\")","v":""},"",88,null,null,null,null,"",{"$f":"AVERAGE($O$14:O101)","v":0},{"$f":"IF(M101>0,STDEVA($O$14:O101),\"\")","v":""},""]
[89,null,null,null,null,"",{"$f":"IF(D102>0,AVERAGE($F$14:F102),\"\")","v":""},{"$f":"IF(D102>0,STDEVA($F$14:F102),\"\")","v":""},"",89,null,null,null,null,"",{"$f":"AVERAGE($O$14:O102)","v":0},{"$f":"IF(M102>0,STDEVA($O$14:O102),\"\")","v":""},""]
[90,null,null,null,null,"",{"$f":"IF(D103>0,AVERAGE($F$14:F103),\"\")","v":""},{"$f":"IF(D103>0,STDEVA($F$14:F103),\"\")","v":""},"",90,null,null,null,null,"",{"$f":"AVERAGE($O$14:O103)","v":0},{"$f":"IF(M103>0,STDEVA($O$14:O103),\"\")","v":""},""]
[91,null,null,null,null,"",{"$f":"IF(D104>0,AVERAGE($F$14:F104),\"\")","v":""},{"$f":"IF(D104>0,STDEVA($F$14:F104),\"\")","v":""},"",91,null,null,null,null,"",{"$f":"AVERAGE($O$14:O104)","v":0},{"$f":"IF(M104>0,STDEVA($O$14:O104),\"\")","v":""},""]
[92,null,null,null,null,"",{"$f":"IF(D105>0,AVERAGE($F$14:F105),\"\")","v":""},{"$f":"IF(D105>0,STDEVA($F$14:F105),\"\")","v":""},"",92,null,null,null,null,"",{"$f":"AVERAGE($O$14:O105)","v":0},{"$f":"IF(M105>0,STDEVA($O$14:O105),\"\")","v":""},""]
[93,null,null,null,null,"",{"$f":"IF(D106>0,AVERAGE($F$14:F106),\"\")","v":""},{"$f":"IF(D106>0,STDEVA($F$14:F106),\"\")","v":""},"",93,null,null,null,null,"",{"$f":"AVERAGE($O$14:O106)","v":0},{"$f":"IF(M106>0,STDEVA($O$14:O106),\"\")","v":""},""]
[94,null,null,null,null,"",{"$f":"IF(D107>0,AVERAGE($F$14:F107),\"\")","v":""},{"$f":"IF(D107>0,STDEVA($F$14:F107),\"\")","v":""},"",94,null,null,null,null,"",{"$f":"AVERAGE($O$14:O107)","v":0},{"$f":"IF(M107>0,STDEVA($O$14:O107),\"\")","v":""},""]
[95,null,null,null,null,"",{"$f":"IF(D108>0,AVERAGE($F$14:F108),\"\")","v":""},{"$f":"IF(D108>0,STDEVA($F$14:F108),\"\")","v":""},"",95,null,null,null,null,"",{"$f":"AVERAGE($O$14:O108)","v":0},{"$f":"IF(M108>0,STDEVA($O$14:O108),\"\")","v":""},""]
[96,null,null,null,null,"",{"$f":"IF(D109>0,AVERAGE($F$14:F109),\"\")","v":""},{"$f":"IF(D109>0,STDEVA($F$14:F109),\"\")","v":""},"",96,null,null,null,null,"",{"$f":"AVERAGE($O$14:O109)","v":0},{"$f":"IF(M109>0,STDEVA($O$14:O109),\"\")","v":""},""]
[97,null,null,null,null,"",{"$f":"IF(D110>0,AVERAGE($F$14:F110),\"\")","v":""},{"$f":"IF(D110>0,STDEVA($F$14:F110),\"\")","v":""},"",97,null,null,null,null,"",{"$f":"AVERAGE($O$14:O110)","v":0},{"$f":"IF(M110>0,STDEVA($O$14:O110),\"\")","v":""},""]
[98,null,null,null,null,"",{"$f":"IF(D111>0,AVERAGE($F$14:F111),\"\")","v":""},{"$f":"IF(D111>0,STDEVA($F$14:F111),\"\")","v":""},"",98,null,null,null,null,"",{"$f":"AVERAGE($O$14:O111)","v":0},{"$f":"IF(M111>0,STDEVA($O$14:O111),\"\")","v":""},""]
[99,null,null,null,null,"",{"$f":"IF(D112>0,AVERAGE($F$14:F112),\"\")","v":""},{"$f":"IF(D112>0,STDEVA($F$14:F112),\"\")","v":""},"",99,null,null,null,null,"",{"$f":"AVERAGE($O$14:O112)","v":0},{"$f":"IF(M112>0,STDEVA($O$14:O112),\"\")","v":""},""]
[100,null,null,null,null,"",{"$f":"IF(D113>0,AVERAGE($F$14:F113),\"\")","v":""},{"$f":"IF(D113>0,STDEVA($F$14:F113),\"\")","v":""},"",100,null,null,null,null,"",{"$f":"AVERAGE($O$14:O113)","v":0},{"$f":"IF(M113>0,STDEVA($O$14:O113),\"\")","v":""},""]

{"sheet":"Dropdown Selections","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["strata","acreage"]
[1,"<100"]
[2,"100-500"]
[3,"501-5,000"]
[null,"5,001-10,000"]
[null,">10,000"]