{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Information","Worksheet","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":3,"comments":1,"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":"Instructions","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[11,2,11,4]]}
[]
[null,"General Information and Instructions:"]
[]
[null,"All information needed by the DOT will be input on this spreadsheet."]
[null,"The entire file should be emailed and saved in the following format: "]
[null,"IAP-month-year_certification number (IAP-04-2024_123456)."]
[null,"Save this file once as a blank template and then enter in the appropriate data"]
[null,"for a given month, then save the file to the appropriate name using the"]
[null,"'Save File' button in the top right corner of the 'Information' sheet.  This button will"]
[null,"save the file in the right format automatically in the same folder this blank file is saved."]
[null,null,"Please send results to:"]
[null,null,"mark.shelton@iowadot.us"]
[null,"The Sample Number is located on the outside of the box the material came in."]
[null,"On the Information sheet only the top half needs to be entered, the remaining"]
[null,"fields will be automatically input from the Worksheet.  On the Worksheet"]
[null,"only the bright yellow cells need to be input unless 203mm (8in.) sieves are"]
[null,"being used for gradation, in that case the light blue cells need to be used."]
[null,"Enter a zero for any sieve that does not retain any material."]
[null,"A checklist on the side of the Worksheet will indicate if all the needed fields are "]
[null,"filled in for a particular section."]

{"sheet":"Information","index":1,"n_rows":62,"n_cols":67,"rows_kept":62,"cut":false,"hidden":false,"merged":[[15,6,16,12],[17,6,18,12],[34,4,34,9],[25,6,26,12],[19,22,20,25],[48,1,49,2],[30,2,31,3],[30,13,31,15],[33,13,34,15],[47,24,47,25],[47,7,47,8],[47,15,47,17],[47,22,47,23],[48,24,49,25],[36,14,36,15],[38,14,38,15],[31,17,31,22],[48,18,49,19],[36,17,36,22],[47,20,47,21],[38,17,38,22],[43,4,43,9],[47,11,47,12],[19,6,20,12],[23,6,24,12],[31,4,31,9],[47,3,47,4],[36,12,36,13],[38,12,38,13],[33,2,34,3],[47,1,47,2],[21,6,22,12],[19,13,20,21],[47,13,47,14],[40,12,40,13],[58,1,58,25],[55,4,55,25],[57,1,57,25],[56,1,56,25],[55,1,55,3],[48,11,49,12],[48,15,49,17],[48,3,49,4],[52,9,52,10],[47,5,47,6],[48,9,49,10],[47,9,47,10],[48,5,49,6],[48,7,49,8],[48,13,49,14],[48,22,49,23],[47,18,47,19],[7,53,12,53],[7,52,12,52],[7,51,12,51],[7,44,12,44],[7,43,12,43],[7,48,12,48],[7,47,12,47],[7,39,12,39],[15,18,16,25],[17,18,18,25],[21,22,22,25],[48,20,49,21],[1,43,6,43],[7,49,12,49],[7,50,12,50],[7,41,12,41],[7,40,12,40],[10,6,10,12],[13,18,14,25],[12,18,12,25],[13,6,14,12],[7,42,12,42],[11,6,12,12],[7,66,12,66],[7,65,12,65],[7,64,12,64],[7,63,12,63],[7,62,12,62],[7,61,12,61],[7,60,12,60],[7,59,12,59],[7,58,12,58],[7,57,12,57],[7,56,12,56],[7,55,12,55],[7,54,12,54],[7,46,12,46],[7,45,12,45]]}
[null,{"$f":"IF(AJ1=\"\",\"\",TEXT(MONTH(AJ1),\"00\"))","v":""},{"$f":"IF(AJ1=\"\",\"\",TEXT(YEAR(AJ1),\"0000\"))","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,{"$f":"IF(E32<>\"\",E32,IF(E35<>\"\",E35,IF(E44<>\"\",E44,\"\")))","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,"Gyratory Info"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"^ ^  Saves File "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"in appropriate"]
[{"$f":"IF(AJ1=\"\",\"HMA Independent Assurance Program\",TEXT(AJ1,\"mmmm yyyy\")&\" HMA Independent Assurance Program\")","v":"HMA Independent Assurance Program"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"format as"]
["Data Report Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"new file in the",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gmm",null,"Gmb",null,null,null,null,null,null,"Gradation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"same folder that",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gyrations",null,null,"Test Values",null,null,null,null,"% Passing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"this file is saved in.",null,null,null,null,null,null,null,null,null,null,null,"Sample Number","Cert Number","Employer","Lab Location","Manufacturer","Model","Test Date","Test Value","Test Date","Ninitial","Ndes","Nmax","Ninitial","Ndes","Nmax","Test Date","37.5mm","25.0mm","19.0mm","12.5mm","9.50mm","4.75mm","2.36mm","1.18mm",{"$f":"\"600\"&CHAR(181)&\"m\"","v":"600µm"},{"$f":"\"300\"&CHAR(181)&\"m\"","v":"300µm"},{"$f":"\"150\"&CHAR(181)&\"m\"","v":"150µm"},{"$f":"Y48","v":"#200"}]
[]
[]
[null,null,null,null,null,"Certification Number:",null,null,null,null,null,null,null,null,"Gyratory Information:"]
[]
[null,null,null,null,null,"Sample Number:",null,null,null,null,null,null,null,null,null,null,null,"Manufacturer:"]
[]
[null,null,null,null,null,"Employer:",null,null,null,null,null,null,null,null,null,null,null,"Model:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G12","v":0},{"$f":"G11","v":0},{"$f":"G14","v":0},{"$f":"G16","v":0},{"$f":"S13","v":0},{"$f":"S14","v":0},{"$f":"E32","v":""},{"$f":"R32","v":""},{"$f":"E35","v":""},{"$f":"O37","v":""},{"$f":"O39","v":""},{"$f":"O41","v":0},{"$f":"R37","v":""},{"$f":"R39","v":""},{"$f":"R41","v":""},{"$f":"E44","v":""},{"$f":"B49","v":""},{"$f":"D49","v":""},{"$f":"F49","v":""},{"$f":"H49","v":""},{"$f":"J49","v":""},{"$f":"L49","v":""},{"$f":"N49","v":""},{"$f":"P49","v":""},{"$f":"S49","v":""},{"$f":"U49","v":""},{"$f":"W49","v":""},{"$f":"Y49","v":""}]
[]
[null,null,null,null,null,"Lab Location:",null,null,null,null,null,null,null,null,null,null,null,"Serial Number:"]
[]
[null,null,null,null,null,"Technician:",null,null,null,null,null,null,null,null,null,null,null,"Years in Service:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of last Full Calibration1:"]
[null,null,null,null,null,"Home Address:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Method of Angle Verification:"]
[]
[null,null,null,null,null,"Phone:"]
[]
[null,null,null,null,null,"Date Received:"]
[]
[null,"Test Results:"]
[null,null,null,"Date of Testing:",null,null,null,null,null,null,null,null,null,"Measured Value:"]
[null,null,"Gmm:",null,null,null,null,null,null,null,null,null,null,"Gmm:"]
[null,null,null,null,{"$f":"IF(Worksheet!D5=\"\",\"\",Worksheet!D5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Worksheet!D15","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,"Internal"]
[null,null,"Gmb:",null,null,null,null,null,null,null,null,null,null,"Gmb2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"External"]
[null,null,null,null,{"$f":"IF(Worksheet!D6=\"\",\"\",Worksheet!D6)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"@ Nini =",null,{"$f":"IF(Worksheet!E20=\"\",\"\",Worksheet!E20)","v":""},null,":",{"$f":"Worksheet!H25","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"@ Ndes =",null,{"$f":"IF(Worksheet!F20=\"\",\"\",Worksheet!F20)","v":""},null,":",{"$f":"Worksheet!I25","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Worksheet!I16","v":""}]
[]
[]
[null,null,null,"Gradation:",{"$f":"IF(Worksheet!D7=\"\",\"\",Worksheet!D7)","v":""}]
[]
[null,"Gradation (% Passing)"]
[]
[null,"1 1/2 in.",null,"1 in.",null,"3/4 in.",null,"1/2 in.",null,"3/8 in.",null,"#4",null,"#8",null,"#16",null,null,"#30",null,"#50",null,"#100",null,"#200"]
[null,{"$f":"Worksheet!H39","v":""},null,{"$f":"Worksheet!H40","v":""},null,{"$f":"Worksheet!H41","v":""},null,{"$f":"Worksheet!H42","v":""},null,{"$f":"Worksheet!H43","v":""},null,{"$f":"Worksheet!H44","v":""},null,{"$f":"Worksheet!H45","v":""},null,{"$f":"Worksheet!H46","v":""},null,null,{"$f":"Worksheet!H47","v":""},null,{"$f":"Worksheet!H48","v":""},null,{"$f":"Worksheet!H49","v":""},null,{"$f":"Worksheet!H50","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Comments:"]
[]
[]
[]
[]
[null,null,"1Full calibration includes height, angle, and pressure."]
[null,null,"2Mean of results."]

{"sheet":"Worksheet","index":2,"n_rows":75,"n_cols":31,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,1,1,2],[10,6,10,7],[8,6,8,9],[3,1,3,2],[4,1,4,2],[15,8,15,9],[1,3,1,4],[2,3,2,4],[4,3,4,4],[3,3,3,4],[8,11,8,12],[53,1,53,2],[8,1,8,4],[10,1,10,3],[11,1,11,3],[9,1,9,3],[12,1,12,3],[13,1,13,3],[52,1,52,2],[51,1,51,2],[18,6,20,6],[18,7,20,7],[18,8,20,8],[11,6,11,7],[12,6,12,7],[13,6,13,7],[50,1,50,2],[36,1,36,2],[6,3,6,4],[5,3,5,4],[14,1,14,2],[37,1,37,2],[14,3,14,4],[6,1,6,2],[5,1,5,2]]}
[null,"A Copy of this Worksheet should be retained by the technician for their records.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,1.0008999999999999]
[null,"Sample No.",null,{"$f":"IF(Information!G12=\"\",\"\",Information!G12)","v":""}]
[null,"Certification No.",null,{"$f":"IF(Information!G11=\"\",\"\",Information!G11)","v":""}]
[null,"Tech. Name:",null,{"$f":"IF(Information!G18=\"\",\"\",Information!G18)","v":""},null,null,null," Only yellow cells need to be filled in."]
[null,"Gmm Test Date"]
[null,"Gmb Test Date"]
[null,"Grad. Test Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70.5,1.00085]
[null,"RICE (Gmm)",null,null,null,null,"Bulk Density (Gmb)",null,null,null,null,"Checklist",null,null,null,null,null,null,null,null,null,null,71,1.0007999999999999]
[null,"Pycnometer #",null,null,null,null,null,null,"Specimen # 1","Specimen # 2",null,"Information",{"$f":"IF(NOT(AND(Information!G11=\"\",Information!G12=\"\",Information!G14=\"\",Information!G24=\"\",Information!G26=\"\",Information!S13=\"\",Information!S14=\"\",Information!W20=\"\",Information!E32=\"\",Information!E35=\"\",Information!E44=\"\")),\"P\",\"\")","v":""},null,null,null,null,null,null,null,null,null,71.5,1.00075]
[null,{"$f":"\"Water Temp. (\"&CHAR(176)&\"F)\"","v":"Water Temp. (°F)"},null,null,null,null,"Water Temp. (°F)",null,null,null,null,"Gmm",{"$f":"IF(NOT(D15=\"\"),\"P\",\"\")","v":""},null,null,null,null,null,null,null,null,null,72,1.0006999999999999]
[null,"Sample Wt. (g)",null,null,null,null,"Dry Weight (g)",null,null,null,null,"Gmb",{"$f":"IF(NOT(AND(I16=\"\",H25=\"\",I25=\"\")),\"P\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(OR(E11<70,E11>104)=TRUE,77,E11)","v":77},null,null,72.5,1.0005999999999999]
[null,"Wt. pyc & H2O (g)",null,null,null,null,"Weight under water (g)",null,null,null,null,"Gradation",{"$f":"IF(AND(COUNT(E39:E51)=13,COUNT(E32:E33)=2),\"P\",\"\")","v":""},null,null,null,null,null,null,{"$f":"VLOOKUP(T12,W1:X75,2)","v":1},null,null,73,1.0004999999999999]
[null,"Wt. pyc & H2O & Sample (g)",null,null,null,null,"SSD Weight (g)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73.5,1.0004500000000001]
[null,"Gmm:",null,{"$f":"IF(OR(E12=\"\",E13=\"\",E14=\"\",E11=\"\")=TRUE,\"\",ROUND((E12*T13)/(E12+E13-E14),3))","v":""},null,null,null,"Gmb @ Ndes:",{"$f":"IF(OR(I12=\"\",I13=\"\",I14=\"\")=TRUE,\"\",(I12/(I14-I13)))","v":""},{"$f":"IF(OR(J12=\"\",J13=\"\",J14=\"\")=TRUE,\"\",(J12/(J14-J13)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,74,1.0004,null,null,null,null,null,null,"% RAP"]
[null,null,null,null,null,null,null,"Average:",{"$f":"IF(OR(I15=\"\",J15=\"\")=TRUE,\"\",ROUND(AVERAGE(I15:J15),3))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,74.5,1.00034,null,null,null,null,null,null,"Psg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,1.0003,null,null,null,null,null,null,0]
[null,null,null,"Gyratory",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75.5,1.0002,null,null,null,null,null,null,0]
[null,null,null,null,"Ninital","Ndesign","Sample Weight (g)",{"$f":"IF(E20=\"\",\"Gmb @ Ninitial\",\"Gmb @  \"&E20&\" gyrations\")","v":"Gmb @ Ninitial"},{"$f":"IF(F20=\"\",\"Gmb @ Ndesign\",\"Gmb @  \"&F20&\" gyrations\")","v":"Gmb @ Ndesign"},null,null,null,null,null,null,null,null,null,null,null,null,null,76,1.0001,null,null,null,null,null,null,0]
[null,null,null,"Gyrations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76.5,1.0000500000000001]
[null,null,null,null,"Specimen # 1",null,null,null,null,null,null,null,null,null,null,"Final",null,null,null,null,null,null,77,1,null,null,null,null,null,null,0]
[null,null,null,{"$f":"\"Height (mm)\"&CHAR(187)&CHAR(187)","v":"Height (mm)»»"},null,null,null,{"$f":"IF(OR(COUNT($E22:$F22)<>2,I15=\"\")=TRUE,\"\",(I$15*($F22/E22)))","v":""},{"$f":"IF(OR(COUNT($E22:$F22)<>2,I15=\"\")=TRUE,\"\",(I$15))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,77.5,0.99965000000000004,null,null,null,null,null,null,0]
[null,null,null,null,"Specimen # 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,0.99990000000000001]
[null,null,null,{"$f":"\"Height (mm)\"&CHAR(187)&CHAR(187)","v":"Height (mm)»»"},null,null,null,{"$f":"IF(OR(COUNT($E24:$F24)<>2,J15=\"\")=TRUE,\"\",(J$15*($F24/E24)))","v":""},{"$f":"IF(OR(COUNT($E24:$F24)<>2,J15=\"\")=TRUE,\"\",(J$15))","v":""},null,null,null,null,null,null,{"$f":"IF(P$52=100,(P40),IF(Q$52=100,(Q40),IF(R$52=100,(R40),IF(S$52=100,(S40),IF(T$52=100,(T40),IF(U$52=100,(U40),IF(V52=100,(V40),(V40))))))))","v":{"$error":"#VALUE!"}},"IM 305",null,null,null,null,null,78.5,0.99980000000000002,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Average:",{"$f":"IF(OR(H22=\"\",H24=\"\")=TRUE,\"\",ROUND(AVERAGE(H22,H24),3))","v":""},{"$f":"IF(OR(I22=\"\",I24=\"\")=TRUE,\"\",ROUND(AVERAGE(I22,I24),3))","v":""},null,null,null,null,null,null,{"$f":"IF(P$52=100,(P41),IF(Q$52=100,(Q41),IF(R$52=100,(R41),IF(S$52=100,(S41),IF(T$52=100,(T41),IF(U$52=100,(U41),IF(V52=100,(V41),(V41))))))))","v":{"$error":"#VALUE!"}},"Sort",null,null,null,null,null,79,0.99970000000000003,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P42),IF(Q$52=100,(Q42),IF(R$52=100,(R42),IF(S$52=100,(S42),IF(T$52=100,(T42),IF(U$52=100,(U42),IF(V52=100,(V42),(V42))))))))","v":{"$error":"#VALUE!"}},{"$f":"LARGE(P$39:P$51,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(P52<100,(Q26+0.1),IF(P52>100,(Q26-0.1),Q26))","v":{"$error":"#VALUE!"}},null,null,null,null,79.5,0.99965000000000004,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P43),IF(Q$52=100,(Q43),IF(R$52=100,(R43),IF(S$52=100,(S43),IF(T$52=100,(T43),IF(U$52=100,(U43),IF(V52=100,(V43),(V43))))))))","v":{"$error":"#VALUE!"}},{"$f":"LARGE(P$39:P$51,2)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q52<100,(Q27+0.1),IF(Q52>100,(Q27-0.1),Q27))","v":{"$error":"#VALUE!"}},null,null,null,null,80,0.99960000000000004,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P44),IF(Q$52=100,(Q44),IF(R$52=100,(R44),IF(S$52=100,(S44),IF(T$52=100,(T44),IF(U$52=100,(U44),IF(V52=100,(V44),(V44))))))))","v":{"$error":"#VALUE!"}},{"$f":"LARGE(P$39:P$51,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(R52<100,(Q28+0.1),IF(R52>100,(Q28-0.1),Q28))","v":{"$error":"#VALUE!"}},null,null,null,null,80.5,0.99950000000000006,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P45),IF(Q$52=100,(Q45),IF(R$52=100,(R45),IF(S$52=100,(S45),IF(T$52=100,(T45),IF(U$52=100,(U45),IF(V52=100,(V45),(V45))))))))","v":{"$error":"#VALUE!"}},{"$f":"LARGE(P$39:P$51,4)","v":{"$error":"#VALUE!"}},{"$f":"IF(S52<100,(Q29+0.1),IF(S52>100,(Q29-0.1),Q29))","v":{"$error":"#VALUE!"}},null,null,null,null,81,0.99939999999999996,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P46),IF(Q$52=100,(Q46),IF(R$52=100,(R46),IF(S$52=100,(S46),IF(T$52=100,(T46),IF(U$52=100,(U46),IF(V52=100,(V46),(V46))))))))","v":{"$error":"#VALUE!"}},{"$f":"LARGE(P$39:P$51,5)","v":{"$error":"#VALUE!"}},{"$f":"IF(T52<100,(Q30+0.1),IF(T52>100,(Q30-0.1),Q30))","v":{"$error":"#VALUE!"}},null,null,null,null,81.5,0.99929999999999997,null,null,null,null,null,null,0]
[null,"Gradation",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P47),IF(Q$52=100,(Q47),IF(R$52=100,(R47),IF(S$52=100,(S47),IF(T$52=100,(T47),IF(U$52=100,(U47),IF(V52=100,(V47),(V47))))))))","v":{"$error":"#VALUE!"}},{"$f":"LARGE(P$39:P$51,6)","v":{"$error":"#VALUE!"}},{"$f":"IF(U52<100,(Q31+0.1),IF(U52>100,(Q31-0.1),Q31))","v":{"$error":"#VALUE!"}},null,null,null,null,82,0.99919999999999998]
[null,null,null,"Orig.  Dry  Mass: ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P48),IF(Q$52=100,(Q48),IF(R$52=100,(R48),IF(S$52=100,(S48),IF(T$52=100,(T48),IF(U$52=100,(U48),IF(V52=100,(V48),(V48))))))))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,82.5,0.99914999999999998]
[null,null,null,"Dry  Mass  Washed: ",null,null,null," Only use light blue colored cells when",null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P49),IF(Q$52=100,(Q49),IF(R$52=100,(R49),IF(S$52=100,(S49),IF(T$52=100,(T49),IF(U$52=100,(U49),IF(V52=100,(V49),(V49))))))))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,83,0.99909999999999999]
[null,null,null,"Total Minus 4.75mm (W1):",null,null,null," using Box & 203mm (8in.) Sieves.",null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P50),IF(Q$52=100,(Q50),IF(R$52=100,(R50),IF(S$52=100,(S50),IF(T$52=100,(T50),IF(U$52=100,(U50),IF(V52=100,(V50),(V50))))))))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,83.5,0.999]
[null,null,null,"Reduced Minus 4.75mm (W2):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P$52=100,(P51),IF(Q$52=100,(Q51),IF(R$52=100,(R51),IF(S$52=100,(S51),IF(T$52=100,(T51),IF(U$52=100,(U51),IF(V52=100,(V51),(V51))))))))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,84,0.99890000000000001]
[null,null,"Conversion Factor: ",null,{"$f":"IF(E35=\"\",\"\",ROUND(SUM(E34/E35),4))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P22:P35)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,84.5,0.99885000000000002]
[null,null,null,"Reduced","Total or Calc","%","%","Reported",null,null,null,null,null,null,null,"%",null,null,null,null,null,null,85,0.99880000000000002]
[null,"Sieve Size",null,"Minus 4.75","Mass Retd.","Retd.","Passing","Final",null,null,null,null,null,null,null,"Retd.",null,null,null,null,null,null,85.5,0.99870000000000003]
[null,"1 1/2\"","37.5mm",null,null,{"$f":"IF(E39=\"\",\"\",(P39))","v":""},{"$f":"IF(F53=\"\",\"\",100)","v":""},{"$f":"IF(G39=\"\",\"\",IF(G39>=10,ROUND(G39,0),ROUND(G39,1)))","v":""},null,null,null,null,null,null,null,{"$f":"ROUND(IF(E39=\"\",\"\",SUM(E39/$E$32)*100),1)","v":{"$error":"#VALUE!"}},"1",2,"3","4","5",6,86,0.99860000000000004]
[null,"1.0\"","25.0mm",null,null,{"$f":"IF(E40=\"\",\"\",(P24))","v":""},{"$f":"IF(G39=\"\",\"\",SUM(G39-F40))","v":""},{"$f":"IF(G40=\"\",\"\",IF(G40>=10,ROUND(G40,0),ROUND(G40,1)))","v":""},null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$f":"ROUND(IF(P40=Q$26,R$26,P40),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(Q40=Q$27,R$27,Q40),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(R40=Q$28,R$28,R40),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(S40=Q$29,R$29,S40),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(T40=Q$30,R$30,T40),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(U40=Q$31,R$31,U40),1)","v":{"$error":"#VALUE!"}},86.5,0.99850000000000005]
[null,"3/4\"","19.0mm",null,null,{"$f":"IF(E41=\"\",\"\",(P25))","v":""},{"$f":"IF(G40=\"\",\"\",SUM(G40-F41))","v":""},"",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},87,0.99839999999999995]
[null,"1/2\"","12.5mm",null,null,{"$f":"IF(E42=\"\",\"\",(P26))","v":""},"","",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},87.5,0.99834999999999996]
[null,"3/8\"","9.50mm",null,null,{"$f":"IF(E43=\"\",\"\",(P27))","v":""},"","",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},88,0.99829999999999997]
[null,"# 4","4.75mm",null,null,{"$f":"IF(E44=\"\",\"\",(P28))","v":""},"","",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},88.5,0.99819999999999998]
[null,"# 8","2.36mm",null,{"$f":"IF(D45=\"\",\"\",ROUND(SUM(D45*E$36),1))","v":""},{"$f":"IF(E45=\"\",\"\",(P29))","v":""},"","",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},89,0.99809999999999999]
[null,"# 16","1.18mm",null,{"$f":"IF(D46=\"\",\"\",ROUND(SUM(D46*E$36),1))","v":""},"","","",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},89.5,0.998]
[null,"# 30",{"$f":"\"600 \"&CHAR(181)&\"m\"","v":"600 µm"},null,"","","","",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},90,0.99790000000000001]
[null,"# 50",{"$f":"\"300 \"&CHAR(181)&\"m\"","v":"300 µm"},null,"","",{"$f":"IF(G47=\"\",\"\",SUM(G47-F48))","v":""},"",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},90.5,0.99780000000000002]
[null,"# 100",{"$f":"\"150 \"&CHAR(181)&\"m\"","v":"150 µm"},null,"","",{"$f":"IF(G48=\"\",\"\",SUM(G48-F49))","v":""},"",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},91,0.99770000000000003]
[null,"# 200",{"$f":"\"75 \"&CHAR(181)&\"m\"","v":"75 µm"},null,"","",{"$f":"IF(G49=\"\",\"\",SUM(G49-F50))","v":""},"",null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},91.5,0.99760000000000004]
[null,"Pan",null,null,"","",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(E51=\"\",\"\",SUM((E51+E52)/$E$32)*100),1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND(IF(R51=Q$28,R$28,R51),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(S51=Q$29,R$29,S51),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(T51=Q$30,R$30,T51),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(U51=Q$31,R$31,U51),1)","v":{"$error":"#VALUE!"}},92,0.99750000000000005]
[null,"Wash",null,null,{"$f":"IF(E33=\"\",\"\",SUM(E32-E33))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(P39:P51),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(Q51=\"\",\"\",SUM(Q40:Q51)),1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},92.5,0.99744999999999995]
[null,"Totals",null,{"$f":"IF(D51=\"\",\"\",SUM(D45:D51))","v":""},{"$f":"IF(E51=\"\",\"\",SUM(E39:E52))","v":""},{"$f":"IF(F51=\"\",\"\",SUM(F39:F51))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,0.99739999999999995]
[null,"Tolerances",null,{"$f":"IF(D53=\"\",\"\",ROUND((SUM(D53/E35)*100),1))","v":""},{"$f":"IF(E53=\"\",\"\",ROUND((SUM(E53/E32)*100),1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93.5,0.99729999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,0.99719999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94.5,0.99709999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,0.997]
[null,"A Copy of this Worksheet should be retained by the technician for their records.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95.5,0.99690000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,0.99680000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96.5,0.99670000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,0.99660000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97.5,0.99650000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,0.99639999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98.5,0.99629999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,0.99619999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99.5,0.99609999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,0.996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100.5,0.99590000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101,0.99580000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101.5,0.99570000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,0.99560000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102.5,0.99550000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,0.99539999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103.5,0.99529999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,0.99519999999999997]

{"sheet":"Sheet1","index":3,"n_rows":5,"n_cols":28,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,4,1,5],[0,6,1,7],[0,8,1,8],[0,15,1,16]]}
[null,null,null,null,"Gyratory Info",null,"Gmm",null,"Gmb",null,null,null,null,null,null,"Gradation"]
[]
[{"$f":"COUNT(A6:A603)","v":0},null,null,null,null,null,null,null,null,"Gyrations",null,null,"Test Values",null,null,null,"Percent Passing"]
["Sample Number","Cert Number","Employer","Lab","Manufacturer","Model","Test Date","Test Value","Test Date","N-initial","N-design","N-max","N-initial","N-design","N-max","Test Date","37.5mm","25.0mm","19.0mm","12.5mm","9.50mm","4.75mm","2.36mm","1.18mm","600µm","300µm","150µm","75µm"]
[{"$f":"Information!G12","v":0},{"$f":"Information!G11","v":0},{"$f":"Information!G14","v":0},{"$f":"Information!G16","v":0},{"$f":"Information!S13","v":0},{"$f":"Information!S14","v":0},{"$f":"Information!E32","v":""},{"$f":"Information!R32","v":""},{"$f":"Information!E35","v":""},{"$f":"Information!O37","v":""},{"$f":"Information!O39","v":""},null,{"$f":"Information!R37","v":""},{"$f":"Information!R39","v":""},null,{"$f":"Information!E44","v":""},{"$f":"Information!B49","v":""},{"$f":"Information!D49","v":""},{"$f":"Information!F49","v":""},{"$f":"Information!H49","v":""},{"$f":"Information!J49","v":""},{"$f":"Information!L49","v":""},{"$f":"Information!N49","v":""},{"$f":"Information!P49","v":""},{"$f":"Information!S49","v":""},{"$f":"Information!U49","v":""},{"$f":"Information!W49","v":""},{"$f":"Information!Y49","v":""}]