{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Daily Report Page 1","Daily Report Page 2","Concrete Report","2018 Scope and Sub-Scope","Field Density Report","Sand Cone Report","One-Point Proctor Report","Moisture-Density Chart"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":9,"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":"Daily Report Page 1","index":0,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[51,3,51,9],[49,0,50,0],[45,3,45,4],[46,3,46,4],[47,3,47,4],[49,3,49,4],[50,3,50,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[15,0,30,9],[39,7,39,9],[39,3,39,6],[38,0,38,9],[48,0,48,9],[39,0,39,2],[36,0,36,9],[37,0,37,6],[31,0,31,1],[34,0,34,1],[37,7,37,8],[31,2,31,9],[32,0,32,9],[33,0,33,9],[34,2,34,9],[35,0,35,9],[60,0,60,9],[52,0,52,1],[52,2,52,9],[53,0,53,9],[54,6,54,9],[59,0,59,9],[55,3,55,9],[55,1,55,2],[56,1,56,2],[54,1,54,2],[56,6,56,9],[58,0,58,1],[58,3,58,4],[54,3,54,4],[56,3,56,4],[57,0,57,4],[10,6,10,7],[13,0,13,5],[12,8,12,9],[13,8,13,9],[12,6,12,7],[13,6,13,7],[12,1,12,5],[14,0,14,9],[0,0,0,9],[8,0,8,9],[10,8,10,9],[11,6,11,7],[10,1,10,5],[11,1,11,5],[11,8,11,9],[4,0,4,9],[9,0,9,9],[5,0,5,9],[6,0,6,9],[7,0,7,9],[1,0,1,9],[2,0,2,9],[3,0,3,9]]}
[]
[]
[]
[]
["CITY OF PHOENIX"]
["STREET TRANSPORTATION DEPARTMENT"]
["PROGRAMMING & PROJECT DELIVERY DIVISION"]
["MATERIALS LAB"]
["DAILY REPORT"]
[]
["Project Number:",null,null,null,null,null,"Private Lab Name:"]
["Project Name:",null,null,null,null,null,"Private Lab Project #:"]
["Contractor:",null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,"Inspector:"]
["Observations and Work Performed (Brief Detail):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Stand by Time (Reason):"]
[]
[]
["Deficiency (Reason):"]
[]
[]
[null,null,null,null,null,null,null,"Inspector Notified:"]
[]
["Concrete",null,null,"Nuke",null,null,null,"Sand Cone"]
["Concrete:",null,null,"Native:",null,null,null,"Native:"]
[null,"Sets","Hours",null,null,"# of test","Hours",null,"# of test","Hours"]
["Grout:",null,null,"ABC:",null,null,null,"ABC:"]
[null,"Sets","Hours",null,null,"# of test","Hours",null,"# of test","Hours"]
["Slurry:",null,null,"Asphalt:",null,null,null,"Millings:"]
[null,"Sets","Hours",null,null,"# of test","Hours",null,"# of test","Hours"]
["Mortar:",null,null,"Millings:",null,null,null,"Other:"]
[null,"Sets","Hours",null,null,"# of test","Hours",null,"# of test","Hours"]
[]
["Pick Ups:","Concrete:",null,"Slurry:",null,null,"Native:",null,"Asphalt:"]
[null,"Grout:",null,"Mortar:",null,null,"ABC:",null,"Cores:"]
[null,"Other:"]
["Other (describe):"]
[]
["Arrived: ",null,null,null,null,"Technician (Print):"]
["Departed:"]
["Total Time: ",null,null,null,null,"Signature:"]
["              Reviewed By (initial):"]
[{"$f":"I11","v":0},null,null,"City of Phoenix"]

{"sheet":"Daily Report Page 2","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,0,5,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[6,0,6,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,1,10,4],[10,5,10,6],[10,7,10,8],[16,0,16,8],[11,1,11,4],[11,5,11,6],[11,7,11,8],[12,1,12,4],[12,5,12,6],[12,7,12,8],[13,0,13,4],[13,5,13,6],[13,7,13,8],[14,0,14,8],[15,0,15,8],[60,0,60,8],[17,0,54,8],[55,0,56,8],[57,1,57,3],[57,4,57,5],[57,6,57,8],[58,0,59,8]]}
[]
[]
[]
[]
["CITY OF PHOENIX"]
["STREET TRANSPORTATION DEPARTMENT"]
["PROGRAMMING & PROJECT DELIVERY DIVISION"]
["MATERIALS LAB"]
["DAILY REPORT"]
[]
["Project Number:",{"$f":"'Daily Report Page 1'!B11:F11","v":0},null,null,null,"Private Lab Name:",null,{"$f":"'Daily Report Page 1'!$I$11","v":0}]
["Project Name:",{"$f":"'Daily Report Page 1'!B12:F12","v":0},null,null,null,"Private Lab Project #:",null,{"$f":"'Daily Report Page 1'!$I$12","v":0}]
["Contractor:",{"$f":"'Daily Report Page 1'!B13:F13","v":0},null,null,null,"Date:",null,{"$f":"'Daily Report Page 1'!$I$13","v":"00:00:00"}]
[null,null,null,null,null,"Inspector:",null,{"$f":"'Daily Report Page 1'!$I$14","v":0}]
["DAILY REPORT CONTINUED:"]
[]
["Observations and Work Performed (Brief Detail):"]

{"sheet":"Concrete Report","index":2,"n_rows":57,"n_cols":23,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,18],[0,19,0,20],[0,21,0,23],[1,0,1,23],[2,0,2,23],[3,0,3,23],[10,0,10,23],[11,0,11,23],[12,0,12,2],[12,3,12,7],[12,8,12,10],[12,11,12,23],[4,0,4,23],[5,0,5,23],[6,0,6,23],[8,0,8,23],[9,0,9,23],[7,0,7,23],[13,0,13,2],[13,3,13,23],[14,0,14,1],[14,2,14,3],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,12,14,13],[14,14,14,23],[16,15,16,23],[17,0,17,1],[17,2,17,3],[17,5,17,11],[17,12,17,14],[17,15,17,23],[15,0,15,2],[15,6,15,8],[15,9,15,10],[15,12,15,15],[15,16,15,23],[16,0,16,1],[16,2,16,3],[16,6,16,7],[16,8,16,10],[16,12,16,14],[23,12,23,13],[23,14,23,18],[23,19,23,23],[21,0,21,10],[21,12,21,13],[21,14,21,18],[21,19,22,23],[22,0,22,1],[18,0,18,1],[18,2,18,3],[18,4,18,5],[18,6,18,11],[18,12,18,14],[18,15,18,23],[19,19,19,23],[20,0,20,1],[20,2,20,10],[20,12,20,14],[20,15,20,18],[20,19,20,23],[19,0,19,1],[19,2,19,3],[19,4,19,5],[19,6,19,10],[19,12,19,14],[19,15,19,18],[22,2,22,10],[22,12,22,13],[22,14,22,18],[28,0,28,23],[29,0,29,3],[29,5,29,6],[29,7,29,8],[29,10,29,11],[29,12,29,13],[29,15,29,23],[25,0,25,23],[26,0,26,23],[27,0,27,3],[27,5,27,6],[27,7,27,8],[27,10,27,11],[27,12,27,13],[27,15,27,16],[27,17,27,19],[27,21,27,23],[24,0,24,1],[24,2,24,10],[23,0,23,1],[23,2,23,10],[36,18,36,19],[36,20,36,21],[36,22,36,23],[30,0,30,23],[31,0,31,23],[32,0,33,1],[32,2,33,3],[32,4,33,5],[32,6,33,7],[32,8,33,9],[32,10,33,11],[32,12,33,13],[32,14,33,15],[32,16,33,17],[32,18,32,23],[33,18,33,19],[33,20,33,21],[33,22,33,23],[34,22,34,23],[35,6,35,7],[35,8,35,9],[35,10,35,11],[35,18,35,19],[35,20,35,21],[35,22,35,23],[34,10,34,11],[34,12,34,13],[34,14,34,15],[34,16,34,17],[34,18,34,19],[34,20,34,21],[36,6,36,7],[36,8,36,9],[36,10,36,11],[36,12,36,13],[36,14,36,15],[36,16,36,17],[34,0,42,1],[34,2,42,3],[34,4,42,5],[34,6,34,7],[34,8,34,9],[39,6,39,7],[39,8,39,9],[39,10,39,11],[39,12,39,13],[39,14,39,15],[39,16,39,17],[35,16,35,17],[35,12,35,13],[35,14,35,15],[37,20,37,21],[37,22,37,23],[38,6,38,7],[38,8,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,15],[38,16,38,17],[38,18,38,19],[38,20,38,21],[38,22,38,23],[37,6,37,7],[37,8,37,9],[37,10,37,11],[37,12,37,13],[37,14,37,15],[37,16,37,17],[37,18,37,19],[39,18,39,19],[39,20,39,21],[39,22,39,23],[40,18,40,19],[40,20,40,21],[40,22,40,23],[41,6,41,7],[41,8,41,9],[41,10,41,11],[41,12,41,13],[41,14,41,15],[41,16,41,17],[41,18,41,19],[40,6,40,7],[40,8,40,9],[40,10,40,11],[40,12,40,13],[40,14,40,15],[40,16,40,17],[42,22,42,23],[43,0,43,23],[44,0,44,1],[44,2,44,23],[45,0,45,23],[46,0,46,23],[41,20,41,21],[41,22,41,23],[42,6,42,7],[42,8,42,9],[42,10,42,11],[42,12,42,13],[42,14,42,15],[42,16,42,17],[42,18,42,19],[42,20,42,21],[57,0,57,23],[51,0,51,23],[52,0,52,23],[53,0,53,23],[54,0,54,23],[55,0,55,23],[56,0,56,13],[56,14,56,23],[47,0,47,23],[48,0,48,6],[48,7,49,12],[48,13,48,23],[49,0,50,6],[49,13,49,23],[50,7,50,23]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SET #"]
[]
[]
[]
[]
["City of Phoenix"]
["STREET TRANSPORTATION DEPARTMENT"]
["PROGRAMMING & PROJECT DELIVERY DIVISION"]
["MATERIALS LAB"]
[]
["REPORT ON CONCRETE TESTS"]
[]
["Project Number:",null,null,{"$f":"'Daily Report Page 1'!$B$11","v":0},null,null,null,null,"Project Name:",null,null,{"$f":"'Daily Report Page 1'!$B$12","v":0}]
["Sample Location:"]
["Air Temp:",null,null,null,"°F","Temp of Mix:",null,null,null,"°F",null,null,"Contractor:",null,{"$f":"'Daily Report Page 1'!$B$13","v":0}]
["Max. Size of Agg.:",null,null,null,"Inch.","Slump:",null,null,null,"Inches",null,null,"Supplier Name / Plant #:"]
["Air Content:",null,null,null,"%","Method:",null,null,"(V) / (P) *",null,null,null,"Truck Number:"]
["Unit Weight.:",null,null,null,"PCF",null,null,null,null,null,null,null,"Ticket Number:"]
["Batch Size:",null,null,null,"Cu. Yd. ",null,null,null,null,null,null,null,"Mix Design Code:"]
["Cylinder Size:",null,null,null,"Inches",null,null,null,null,null,null,"**","Mix Design Strength:",null,null,null,null,null,null,"PSI"]
["Admixture:",null,null,null,null,null,null,null,null,null,null,"***","Required Strength:",null,null,null,null,null,null,"PSI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Batch Time:",null,null,null,null,null,null,"(24 hour Time)"]
["Inspector:",null,{"$f":"'Daily Report Page 1'!$I$14","v":0},null,null,null,null,null,null,null,null,null,"Sample Time:"]
["Sampled By:",null,{"$f":"'Daily Report Page 1'!$G$55","v":0},null,null,null,null,null,null,null,null,null,"Time in Mixer:",null,{"$f":"O23-O22","v":"00:00:00"},null,null,null,null,"Minutes (Auto Calc.)"]
["Delivered By:"]
["TYPE OF CONCRETE:"]
[]
["POURED CONCRETE",null,null,null,null,null,null,"GROUT",null,null,null,null,"MORTAR",null,null,null,null,"SLURRY"]
[]
["SHOTCRETE",null,null,null,null,null,null,"BEAM",null,null,null,null,"CORE"]
[]
[]
["LAB NUMBER",null,"DATE RECEIVED",null,"DATE MOLDED",null,"CYL\nDIA.",null,"TYPE BREAK",null,"X-SECT AREA",null,"TYPE CAP N/S",null,"VERT Y/N",null,"DATE TESTED",null,"STRENGTH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAYS",null,"LOAD",null,"PSI "]
[null,null,null,null,{"$f":"'Daily Report Page 1'!$I$13","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Remarks:"]
[]
[]
[]
["ASTM Test Methods used in this report are:",null,null,null,null,null,null,null,null,null,null,null,null,"AASHTO Test Methods used in this report are:"]
["C31, C39, C138, C143, C172, C173, C231, C511, C617, C1064, C1231",null,null,null,null,null,null,null,null,null,null,null,null,"T22, T23, T119, T121, T152, T196, T231, T309"]
[]
[]
["*V-Volumetric / P-Pressure"]
["**Design Strength: This is the Mix Design Strength."]
["***Required Strength: This is the Specified Strength Required for the Structure Being Placed."]
[]
["Tested By (Concrete Lab Technician):"]

{"sheet":"2018 Scope and Sub-Scope","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,0,17,3],[17,4,17,11],[19,0,19,11],[14,0,14,3],[14,4,14,11],[15,0,15,3],[15,4,15,11],[16,0,16,3],[16,4,16,11],[11,0,11,3],[11,4,11,11],[12,0,12,3],[12,4,12,11],[13,0,13,3],[13,4,13,11],[6,0,6,11],[7,0,7,11],[9,0,9,3],[9,4,9,11],[10,0,10,3],[10,4,10,11],[5,0,5,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11],[4,0,4,11]]}
[]
[]
[]
["CITY OF PHOENIX"]
["STREET TRANSPORTATION DEPARTMENT"]
["PROGRAMMING & PROJECT DELIVERY DIVISION"]
["MATERIALS LAB"]
["SCOPE AND SUB-SCOPE"]
[]
["Scope",null,null,null,"Sub-Scope"]
["Roadway",null,null,null,"Subgrade, ABC, Asphalt, PCCP, Roadway Fill, Driveway, Sidewalk, Curb & Gutter, Embankment, Median, Median Curb, ADA Ramp, Bus Bay, Apron, Valley Gutter, Adjustments"]
["Water",null,null,null,"Mainline, Lateral, Service, Fire Hydrant, Valve, Structure, Irrigation"]
["Sewer",null,null,null,"Mainline, Manhole, Lateral, Service"]
["Storm Drain",null,null,null,"Mainline, Manhole, Lateral, Service, Structure, Drainage Channel, Box Culvert, RCP Culvert, Crossing, Pipe Collars, Catch Basin, Spillway"]
["Dry Utility",null,null,null,"Conduit, Mainline, Crossing, P.U.E., Service, Structure"]
["Bridges",null,null,null,"Abutment, Approach Slab, Anchor Slab, Deck, Girders, Beams, Columns"]
["Foundation",null,null,null,"Footings, Caisson, Slab on Grade, Stem Wall"]
["Walls",null,null,null,"Footing, Gabion, Jersey, Retaining, Screen/Site Wall, Cut-Off Wall"]
[]
["*This table is for reference purposes only and Is not Intended to capture all scenarios."]

{"sheet":"Field Density Report","index":4,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,19],[1,0,1,19],[2,0,2,19],[3,0,3,19],[4,0,4,19],[5,0,5,19],[9,0,9,1],[9,2,9,5],[9,6,9,7],[9,8,9,12],[9,13,9,14],[6,0,6,19],[7,0,7,19],[8,0,8,1],[8,2,8,5],[8,6,8,7],[8,8,8,12],[8,13,8,14],[8,15,8,19],[9,15,9,16],[9,18,9,19],[11,0,11,1],[11,2,11,5],[11,6,11,19],[12,0,12,2],[12,3,12,5],[12,6,12,8],[12,9,12,12],[12,13,12,15],[10,0,10,1],[10,2,10,5],[10,6,10,7],[10,8,10,12],[10,13,10,14],[10,15,10,19],[15,12,16,12],[15,13,16,13],[15,16,16,16],[15,17,16,17],[15,18,16,18],[15,19,16,19],[13,0,13,19],[14,2,14,5],[15,0,16,0],[15,1,16,1],[15,2,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[15,10,16,10],[19,16,20,16],[19,17,20,17],[19,18,20,18],[17,17,18,17],[17,16,18,16],[19,19,20,19],[17,18,18,18],[17,19,18,19],[17,12,18,12],[17,13,18,13],[19,13,20,13],[23,19,24,19],[21,18,22,18],[21,19,22,19],[23,0,24,0],[23,1,24,1],[23,2,24,5],[21,13,22,13],[21,16,22,16],[21,17,22,17],[21,0,22,0],[21,1,22,1],[21,2,22,5],[21,6,22,6],[21,7,22,7],[21,8,22,8],[21,9,22,9],[23,16,24,16],[23,17,24,17],[23,18,24,18],[23,7,24,7],[21,10,22,10],[23,12,24,12],[23,13,24,13],[23,8,24,8],[23,9,24,9],[23,10,24,10],[23,6,24,6],[21,12,22,12],[17,0,18,0],[17,1,18,1],[19,0,20,0],[19,1,20,1],[19,2,20,5],[19,6,20,6],[19,7,20,7],[19,8,20,8],[19,10,20,10],[17,9,18,9],[17,10,18,10],[19,9,20,9],[19,12,20,12],[17,2,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[27,12,28,12],[27,13,28,13],[27,16,28,16],[27,17,28,17],[27,18,28,18],[25,17,26,17],[27,19,28,19],[25,18,26,18],[25,19,26,19],[25,12,26,12],[25,13,26,13],[25,16,26,16],[27,0,28,0],[27,1,28,1],[27,2,28,5],[27,6,28,6],[27,7,28,7],[27,8,28,8],[27,9,28,9],[27,10,28,10],[25,9,26,9],[25,10,26,10],[25,0,26,0],[25,1,26,1],[25,2,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[35,0,35,19],[36,0,36,19],[32,0,32,2],[32,3,32,19],[33,0,33,19],[34,0,34,11],[34,12,34,13],[34,14,34,19],[29,0,29,19],[30,0,30,19],[31,0,31,2],[31,3,31,9],[31,10,31,12],[31,13,31,14],[31,15,31,16],[31,17,31,19]]}
[]
[]
[]
["CITY OF PHOENIX"]
["STREET TRANSPORTATION DEPARTMENT"]
["PROGRAMMING & PROJECT DELIVERY DIVISION"]
["MATERIALS LAB"]
["FIELD DENSITY TEST - NUCLEAR GAUGE"]
["Project Number:",null,{"$f":"'Daily Report Page 1'!$B$11","v":0},null,null,null,"Project Name:",null,{"$f":"'Daily Report Page 1'!$B$12","v":0},null,null,null,null,"Inspector:",null,{"$f":"'Daily Report Page 1'!$I$14","v":0}]
["Mix/Material Type:",null,null,null,null,null,"Plant Name:",null,null,null,null,null,null,"Lab Name:",null,{"$f":"'Daily Report Page 1'!$I$11","v":0},null,"Tech:",{"$f":"'Daily Report Page 1'!$G$55","v":0}]
["Scope:",null,null,null,null,null,"Contractor:",null,{"$f":"'Daily Report Page 1'!$B$13","v":0},null,null,null,null,"Date:",null,{"$f":"'Daily Report Page 1'!$I$13","v":"00:00:00"}]
["Gauge Serial #:"]
["Density Standard Count:",null,null,null,null,null,"Moisture Standard Count:",null,null,null,null,null,null,"Moisture Spec. (%):",null,null,"Plus:",2,"Minus:",2]
[]
["Test Type","Sub-Scope","Test Location",null,null,null,"Lift Elev","Probe Depth","Lab #","Max Density (Lab)","Opt Moist (Lab)","SPG     &      %Rock","Max Density (Corr)","Opt Moist (Corr)","Wet Density/ Counts","Field Moist/ Counts","Dry Density","%     Comp","Req Comp","Pass/ Fail"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A16=\"A\",\"\",IF(J16=\"\",\"\",IF(L17<10,J16,ROUND((((100-L17)*J16)+((56.2*L17*L16)))/100,1))))","v":""},{"$f":"IF(K16=\"\",\"\",IF(L17<10,K16,ROUND((K16*(100-L17)+L17)/100,1)))","v":""},null,null,{"$f":"IF(P16=\"\",\"\",ROUND(O16/(1+(P16/100)),1))","v":""},{"$f":"IF(O16=\"\",\"\",IF(A16=\"A\",O16/J16*100,IF(Q16=\"\",\"\",ROUND(Q16/M16*100,1))))","v":""},null,{"$f":"IF(R16=\"\",\"\",IF(S16=\"\",\"\",IF(A16=\"A\",IF(R16=S16,\"PASS\",IF(R16>S16,\"PASS\",\"FAIL\")),IF($T$13=\"\",\"\",IF($R$13=\"\",\"\",IF(P16>(N16+$R$13),\"FAIL\",(IF(P16<(N16-$T$13),\"FAIL\",IF(R16=S16,\"PASS\",IF(R16>S16,\"PASS\",\"FAIL\"))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A18=\"A\",\"\",IF(J18=\"\",\"\",IF(L19<10,J18,ROUND((((100-L19)*J18)+((56.2*L19*L18)))/100,1))))","v":""},{"$f":"IF(K18=\"\",\"\",IF(L19<10,K18,ROUND((K18*(100-L19)+L19)/100,1)))","v":""},null,null,{"$f":"IF(P18=\"\",\"\",ROUND(O18/(1+(P18/100)),1))","v":""},{"$f":"IF(O18=\"\",\"\",IF(A18=\"A\",O18/J18*100,IF(Q18=\"\",\"\",ROUND(Q18/M18*100,1))))","v":""},null,{"$f":"IF(R18=\"\",\"\",IF(S18=\"\",\"\",IF(A18=\"A\",IF(R18=S18,\"PASS\",IF(R18>S18,\"PASS\",\"FAIL\")),IF($T$13=\"\",\"\",IF($R$13=\"\",\"\",IF(P18>(N18+$R$13),\"FAIL\",(IF(P18<(N18-$T$13),\"FAIL\",IF(R18=S18,\"PASS\",IF(R18>S18,\"PASS\",\"FAIL\"))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A20=\"A\",\"\",IF(J20=\"\",\"\",IF(L21<10,J20,ROUND((((100-L21)*J20)+((56.2*L21*L20)))/100,1))))","v":""},{"$f":"IF(K20=\"\",\"\",IF(L21<10,K20,ROUND((K20*(100-L21)+L21)/100,1)))","v":""},null,null,{"$f":"IF(P20=\"\",\"\",ROUND(O20/(1+(P20/100)),1))","v":""},{"$f":"IF(O20=\"\",\"\",IF(A20=\"A\",O20/J20*100,IF(Q20=\"\",\"\",ROUND(Q20/M20*100,1))))","v":""},null,{"$f":"IF(R20=\"\",\"\",IF(S20=\"\",\"\",IF(A20=\"A\",IF(R20=S20,\"PASS\",IF(R20>S20,\"PASS\",\"FAIL\")),IF($T$13=\"\",\"\",IF($R$13=\"\",\"\",IF(P20>(N20+$R$13),\"FAIL\",(IF(P20<(N20-$T$13),\"FAIL\",IF(R20=S20,\"PASS\",IF(R20>S20,\"PASS\",\"FAIL\"))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A22=\"A\",\"\",IF(J22=\"\",\"\",IF(L23<10,J22,ROUND((((100-L23)*J22)+((56.2*L23*L22)))/100,1))))","v":""},{"$f":"IF(K22=\"\",\"\",IF(L23<10,K22,ROUND((K22*(100-L23)+L23)/100,1)))","v":""},null,null,{"$f":"IF(P22=\"\",\"\",ROUND(O22/(1+(P22/100)),1))","v":""},{"$f":"IF(O22=\"\",\"\",IF(A22=\"A\",O22/J22*100,IF(Q22=\"\",\"\",ROUND(Q22/M22*100,1))))","v":""},null,{"$f":"IF(R22=\"\",\"\",IF(S22=\"\",\"\",IF(A22=\"A\",IF(R22=S22,\"PASS\",IF(R22>S22,\"PASS\",\"FAIL\")),IF($T$13=\"\",\"\",IF($R$13=\"\",\"\",IF(P22>(N22+$R$13),\"FAIL\",(IF(P22<(N22-$T$13),\"FAIL\",IF(R22=S22,\"PASS\",IF(R22>S22,\"PASS\",\"FAIL\"))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A24=\"A\",\"\",IF(J24=\"\",\"\",IF(L25<10,J24,ROUND((((100-L25)*J24)+((56.2*L25*L24)))/100,1))))","v":""},{"$f":"IF(K24=\"\",\"\",IF(L25<10,K24,ROUND((K24*(100-L25)+L25)/100,1)))","v":""},null,null,{"$f":"IF(P24=\"\",\"\",ROUND(O24/(1+(P24/100)),1))","v":""},{"$f":"IF(O24=\"\",\"\",IF(A24=\"A\",O24/J24*100,IF(Q24=\"\",\"\",ROUND(Q24/M24*100,1))))","v":""},null,{"$f":"IF(R24=\"\",\"\",IF(S24=\"\",\"\",IF(A24=\"A\",IF(R24=S24,\"PASS\",IF(R24>S24,\"PASS\",\"FAIL\")),IF($T$13=\"\",\"\",IF($R$13=\"\",\"\",IF(P24>(N24+$R$13),\"FAIL\",(IF(P24<(N24-$T$13),\"FAIL\",IF(R24=S24,\"PASS\",IF(R24>S24,\"PASS\",\"FAIL\"))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A26=\"A\",\"\",IF(J26=\"\",\"\",IF(L27<10,J26,ROUND((((100-L27)*J26)+((56.2*L27*L26)))/100,1))))","v":""},{"$f":"IF(K26=\"\",\"\",IF(L27<10,K26,ROUND((K26*(100-L27)+L27)/100,1)))","v":""},null,null,{"$f":"IF(P26=\"\",\"\",ROUND(O26/(1+(P26/100)),1))","v":""},{"$f":"IF(O26=\"\",\"\",IF(A26=\"A\",O26/J26*100,IF(Q26=\"\",\"\",ROUND(Q26/M26*100,1))))","v":""},null,{"$f":"IF(R26=\"\",\"\",IF(S26=\"\",\"\",IF(A26=\"A\",IF(R26=S26,\"PASS\",IF(R26>S26,\"PASS\",\"FAIL\")),IF($T$13=\"\",\"\",IF($R$13=\"\",\"\",IF(P26>(N26+$R$13),\"FAIL\",(IF(P26<(N26-$T$13),\"FAIL\",IF(R26=S26,\"PASS\",IF(R26>S26,\"PASS\",\"FAIL\"))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A28=\"A\",\"\",IF(J28=\"\",\"\",IF(L29<10,J28,ROUND((((100-L29)*J28)+((56.2*L29*L28)))/100,1))))","v":""},{"$f":"IF(K28=\"\",\"\",IF(L29<10,K28,ROUND((K28*(100-L29)+L29)/100,1)))","v":""},null,null,{"$f":"IF(P28=\"\",\"\",ROUND(O28/(1+(P28/100)),1))","v":""},{"$f":"IF(O28=\"\",\"\",IF(A28=\"A\",O28/J28*100,IF(Q28=\"\",\"\",ROUND(Q28/M28*100,1))))","v":""},null,{"$f":"IF(R28=\"\",\"\",IF(S28=\"\",\"\",IF(A28=\"A\",IF(R28=S28,\"PASS\",IF(R28>S28,\"PASS\",\"FAIL\")),IF($T$13=\"\",\"\",IF($R$13=\"\",\"\",IF(P28>(N28+$R$13),\"FAIL\",(IF(P28<(N28-$T$13),\"FAIL\",IF(R28=S28,\"PASS\",IF(R28>S28,\"PASS\",\"FAIL\"))))))))))","v":""}]
[]
["Test Type:    N-Nuclear Gauge    S-Sand Cone   SC-Sand Cone Correlation  A-Asphalt Density    RN-Retest Nuclear Gauge    RS-Retest Sand Cone"]
["Test Methods:    ASTM    D-6938    D-1556    D-2950    AASHTO    T-310    T-191"]
["Deficiency Report:",null,null,null,null,null,null,null,null,null,"Inspector Notified (Y/N):",null,null,null,null,"Date Notified:"]
["Corrective Action:"]

{"sheet":"Sand Cone Report","index":5,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,0,49,1],[49,2,49,12],[50,0,50,12],[51,1,51,6],[51,7,51,12],[47,0,47,3],[47,4,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[48,0,48,4],[48,6,48,7],[48,9,48,10],[48,11,48,12],[45,0,45,3],[45,4,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[46,0,46,3],[46,4,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[43,0,43,3],[43,4,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[44,0,44,3],[44,4,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[41,0,41,3],[41,4,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[42,0,42,3],[42,4,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[39,0,39,3],[39,4,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[40,0,40,3],[40,4,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[37,0,37,3],[37,4,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[38,0,38,3],[38,4,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[35,0,35,3],[35,4,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[36,0,36,3],[36,4,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[33,0,33,3],[33,4,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,3],[34,4,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12],[31,0,31,3],[31,4,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[32,0,32,3],[32,4,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[29,0,29,3],[29,4,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[30,0,30,3],[30,4,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[27,0,27,3],[27,4,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[28,0,28,3],[28,4,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[25,0,25,3],[25,4,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[26,0,26,3],[26,4,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[23,0,23,3],[23,4,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[24,0,24,3],[24,4,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[21,0,21,3],[21,4,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[22,0,22,3],[22,4,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[19,0,19,3],[19,4,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[20,0,20,3],[20,4,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[17,4,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[18,4,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[15,0,15,3],[15,4,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[16,0,17,3],[16,4,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[13,0,13,1],[13,7,13,12],[14,0,14,3],[14,4,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[11,0,11,1],[11,7,11,8],[11,9,11,12],[12,0,12,1],[12,2,12,6],[12,7,12,8],[12,9,12,12],[11,2,11,3],[11,5,11,6],[13,4,13,5],[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,0,4,12],[5,0,5,12],[10,0,10,1],[10,2,10,6],[10,7,10,8],[10,9,10,12],[6,0,6,12],[7,0,7,12],[8,0,8,1],[8,2,8,6],[8,7,8,8],[8,9,8,12],[9,0,9,1],[9,2,9,6],[9,7,9,8],[9,9,9,12]]}
[]
[]
[]
["CITY OF PHOENIX"]
["STREET TRANSPORTATION DEPARTMENT"]
["PROGRAMMING & PROJECT DELIVERY DIVISION"]
["MATERIALS LAB"]
["FIELD DENSITY TEST - SAND CONE"]
["Project Number:",null,{"$f":"'Daily Report Page 1'!$B$11","v":0},null,null,null,null,"Project Name:",null,{"$f":"'Daily Report Page 1'!$B$12","v":0}]
["Material Type:",null,null,null,null,null,null,"Plant/Source:"]
["Inspector:",null,{"$f":"'Daily Report Page 1'!$I$14","v":0},null,null,null,null,"Contractor:",null,{"$f":"'Daily Report Page 1'!$B$13","v":0}]
["Lab Name:",null,{"$f":"'Daily Report Page 1'!$I$11","v":0},null,"Tech:",{"$f":"'Daily Report Page 1'!$G$55","v":0},null,"Date:",null,{"$f":"'Daily Report Page 1'!$I$13","v":"00:00:00"}]
["Sand Cone Kit #:",null,null,null,null,null,null,"Date Verified:"]
["Moisture Spec. (%):",null,"Plus:",2,"Minus:",null,2]
["Scope:"]
["Sub Scope:"]
["Location:"]
[]
["ABC:",null,"Soil:"]
["Lift / Elevation:"]
["Depth of Test Hole:"]
["(A) Sand Density (Lb/ft3)"]
["(B) Weight of Sample and Bucket (Lbs)"]
["(C) Tare Weight of Bucket (Lbs)"]
["(D) Weight of Sample (B - C) (Lbs)",null,null,null,{"$f":"IF(E23=\"\",\"\",E23-E24)","v":""},null,null,{"$f":"IF(H23=\"\",\"\",H23-H24)","v":""},null,{"$f":"IF(J23=\"\",\"\",J23-J24)","v":""},null,{"$f":"IF(L23=\"\",\"\",L23-L24)","v":""}]
["(E) Initial Weight of Sand (Lbs)"]
["(F) Weight of Sand in Cone (Lbs)"]
["(G) Total Weight of Sand (E - F) (Lbs)",null,null,null,{"$f":"IF(E26=\"\",\"\",E26-E27)","v":""},null,null,{"$f":"IF(H26=\"\",\"\",H26-H27)","v":""},null,{"$f":"IF(J26=\"\",\"\",J26-J27)","v":""},null,{"$f":"IF(L26=\"\",\"\",L26-L27)","v":""}]
["(H) Sand Remaining (Lbs)"]
["(I) Weight of Sand Used (G - H) (Lbs)",null,null,null,{"$f":"IF(E28=\"\",\"\",E28-E29)","v":""},null,null,{"$f":"IF(H28=\"\",\"\",H28-H29)","v":""},null,{"$f":"IF(J28=\"\",\"\",J28-J29)","v":""},null,{"$f":"IF(L28=\"\",\"\",L28-L29)","v":""}]
["Volume of Test Area (I ÷ A) (ft³)",null,null,null,{"$f":"IF(E30=\"\",\"\",ROUND(E30/E22,4))","v":""},null,null,{"$f":"IF(H30=\"\",\"\",ROUND(H30/H22,4))","v":""},null,{"$f":"IF(J30=\"\",\"\",ROUND(J30/J22,4))","v":""},null,{"$f":"IF(L30=\"\",\"\",ROUND(L30/L22,4))","v":""}]
["(J) Wet Density  (A × D ÷ I) (Lbs/ft³)",null,null,null,{"$f":"IF(E30=\"\",\"\",ROUND(E22*E25/E30,1))","v":""},null,null,{"$f":"IF(H30=\"\",\"\",ROUND(H22*H25/H30,1))","v":""},null,{"$f":"IF(J30=\"\",\"\",ROUND(J22*J25/J30,1))","v":""},null,{"$f":"IF(L30=\"\",\"\",ROUND(L22*L25/L30,1))","v":""}]
["(K) - #4 Moisture (Speedy) (%)"]
["(L) Moisture (Rock Corrected) (%) (K(100-Q) + Q)/100",null,null,null,{"$f":"IF(E33=\"\",\"\",ROUND((E33*(100-E39)+E39)/100,1))","v":""},null,null,{"$f":"IF(H33=\"\",\"\",ROUND((H33*(100-H39)+H39)/100,1))","v":""},null,{"$f":"IF(J33=\"\",\"\",ROUND((J33*(100-J39)+J39)/100,1))","v":""},null,{"$f":"IF(L33=\"\",\"\",ROUND((L33*(100-L39)+L39)/100,1))","v":""}]
["(M) Dry Density (J/(1+(l/100))) (Lb/ft3)",null,null,null,{"$f":"IF(E32=\"\",\"\",ROUND(E32/(1+(E34/100)),1))","v":""},null,null,{"$f":"IF(H32=\"\",\"\",ROUND(H32/(1+(H34/100)),1))","v":""},null,{"$f":"IF(J32=\"\",\"\",ROUND(J32/(1+(J34/100)),1))","v":""},null,{"$f":"IF(L32=\"\",\"\",ROUND(L32/(1+(L34/100)),1))","v":""}]
["(N) Weight of Rock and Bucket (Lbs)"]
["(O) Tare Weight of Bucket (Lbs)"]
["(P) Weight of Rock (N - O) (Lbs)",null,null,null,{"$f":"IF(E36=\"\",\"\",E36-E37)","v":""},null,null,{"$f":"IF(H36=\"\",\"\",H36-H37)","v":""},null,{"$f":"IF(J36=\"\",\"\",J36-J37)","v":""},null,{"$f":"IF(L36=\"\",\"\",L36-L37)","v":""}]
["(Q) Rock (P ÷ D x 100) (%)",null,null,null,{"$f":"IF(E38=\"\",\"\",ROUND(E38/E25*100,0))","v":""},null,null,{"$f":"IF(H38=\"\",\"\",ROUND(H38/H25*100,0))","v":""},null,{"$f":"IF(J38=\"\",\"\",ROUND(J38/J25*100,0))","v":""},null,{"$f":"IF(L38=\"\",\"\",ROUND(L38/L25*100,0))","v":""}]
["(R) Specific Gravity of Rock"]
["Proctor Identification (Lab #)"]
["(S) Optimum Moisture (Lab) (%)"]
["(T) Maximum Density (Lab) (Lbs/ft³)"]
["Optimum Moisture (Corrected) (%) (S*(100-Q) +Q)/100",null,null,null,{"$f":"IF(E39=\"\",\"\",IF(E39<10,E42,ROUND((E42*(100-E39)+E39)/100,1)))","v":""},null,null,{"$f":"IF(H39=\"\",\"\",IF(H39<10,H42,ROUND((H42*(100-H39)+H39)/100,1)))","v":""},null,{"$f":"IF(J39=\"\",\"\",IF(J39<10,J42,ROUND((J42*(100-J39)+J39)/100,1)))","v":""},null,{"$f":"IF(L39=\"\",\"\",IF(L39<10,L42,ROUND((L42*(100-L39)+L39)/100,1)))","v":""}]
["(U) Maximum Density (Corrected) (Lbs/ft³) [(100-Q)*(T)] + [(56.2)*(Q)*(R)]/100",null,null,null,{"$f":"IF(E40=\"\",\"\",IF(E39<10,E43,ROUND((((100-E39)*E43)+(56.2*E39*E40))/100,1)))","v":""},null,null,{"$f":"IF(H40=\"\",\"\",IF(H39<10,H43,ROUND((((100-H39)*H43)+(56.2*H39*H40))/100,1)))","v":""},null,{"$f":"IF(J40=\"\",\"\",IF(J39<10,J43,ROUND((((100-J39)*J43)+(56.2*J39*J40))/100,1)))","v":""},null,{"$f":"IF(L40=\"\",\"\",IF(L39<10,L43,ROUND((((100-L39)*L43)+(56.2*L39*L40))/100,1)))","v":""}]
["Compaction (M ÷ U x 100) (%)",null,null,null,{"$f":"IF(E45=\"\",\"\",ROUND(E35/E45*100,1))","v":""},null,null,{"$f":"IF(H45=\"\",\"\",ROUND(H35/H45*100,1))","v":""},null,{"$f":"IF(J45=\"\",\"\",ROUND(J35/J45*100,1))","v":""},null,{"$f":"IF(L45=\"\",\"\",ROUND(L35/L45*100,1))","v":""}]
["Required Compaction (%)"]
["Pass / Fail",null,null,null,{"$f":"IF(E47=\"\",\"\",IF($G$14=\"\",\"\",IF($D$14=\"\",\"\",IF(E34>(E44+$D$14),\"Fail\",IF(E34<(E44-$G$14),\"Fail\",IF(E46=E47,\"Pass\",IF(E46>E47,\"Pass\",\"Fail\")))))))","v":""},null,null,{"$f":"IF(H47=\"\",\"\",IF($G$14=\"\",\"\",IF($D$14=\"\",\"\",IF(H34>(H44+$D$14),\"Fail\",IF(H34<(H44-$G$14),\"Fail\",IF(H46=H47,\"Pass\",IF(H46>H47,\"Pass\",\"Fail\")))))))","v":""},null,{"$f":"IF(J47=\"\",\"\",IF($G$14=\"\",\"\",IF($D$14=\"\",\"\",IF(J34>(J44+$D$14),\"Fail\",IF(J34<(J44-$G$14),\"Fail\",IF(J46=J47,\"Pass\",IF(J46>J47,\"Pass\",\"Fail\")))))))","v":""},null,{"$f":"IF(L47=\"\",\"\",IF($G$14=\"\",\"\",IF($D$14=\"\",\"\",IF(L34>(L44+$D$14),\"Fail\",IF(L34<(L44-$G$14),\"Fail\",IF(L46=L47,\"Pass\",IF(L46>L47,\"Pass\",\"Fail\")))))))","v":""}]
["Test Methods: ASTM D-1556, AASHTO T-191",null,null,null,null,null,"Inspector Notified (Y/N):",null,null,"Date Notified:"]
["Corrective Action:"]

{"sheet":"One-Point Proctor Report","index":6,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,0,5,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13],[6,0,6,13],[7,0,7,13],[8,0,8,1],[8,2,8,8],[8,9,8,10],[8,11,8,13],[9,0,9,1],[9,2,9,8],[9,9,9,10],[9,11,9,13],[10,0,10,1],[10,2,10,8],[10,9,10,10],[10,11,10,13],[11,0,11,1],[11,9,11,10],[11,11,11,13],[39,0,39,13],[11,2,11,4],[11,6,11,8],[41,0,41,3],[41,4,41,6],[41,9,41,11],[40,0,40,7],[40,9,40,13],[42,0,42,3],[42,4,42,6],[42,9,42,11],[46,11,46,13],[47,0,47,3],[47,11,47,13],[43,0,43,3],[43,4,43,6],[43,9,43,11],[44,0,44,3],[44,4,44,6],[44,9,44,11],[45,0,45,3],[45,4,45,6],[46,0,46,3],[46,4,46,6],[46,8,47,10],[51,0,51,3],[51,4,51,6],[51,8,51,9],[51,10,51,13],[48,0,48,3],[48,4,48,6],[48,8,49,10],[48,11,48,13],[49,0,49,3],[49,4,49,6],[49,11,49,13],[50,0,50,3],[50,4,50,6]]}
[]
[]
[]
["CITY OF PHOENIX"]
["STREET TRANSPORTATION DEPARTMENT"]
["PROGRAMMING & PROJECT DELIVERY DIVISION"]
["MATERIALS LAB"]
["FIELD ONE-POINT PROCTOR"]
["Project Name:",null,{"$f":"'Daily Report Page 1'!$B$12","v":0},null,null,null,null,null,null,"Project Number:",null,{"$f":"'Daily Report Page 1'!$B$11","v":0}]
["Plant/Source:",null,null,null,null,null,null,null,null,"Material Type:"]
["Contractor:",null,{"$f":"'Daily Report Page 1'!$B$13","v":0},null,null,null,null,null,null,"Inspector:",null,{"$f":"'Daily Report Page 1'!$I$14","v":0}]
["Lab Name:",null,{"$f":"'Daily Report Page 1'!$I$11","v":0},null,null,"Tech:",{"$f":"'Daily Report Page 1'!$G$55","v":0},null,null,"Date:",null,{"$f":"'Daily Report Page 1'!$I$13","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["WET DENSITY DETERMINATION",null,null,null,null,null,null,null,null,"ROCK CORRECTION"]
["A) Weight of Mold and Soil:",null,null,null,null,null,null,"Lbs",null,"L)  Total Weight of Sample:",null,null,null,"LBS"]
["B) Weight of Mold:",null,null,null,null,null,null,"Lbs",null,"M) Total Weight of Rock:",null,null,null,"LBS"]
["C)  Weight of Compacted Soil (A-B):",null,null,null,{"$f":"IF(E43=\"\",\"\",E42-E43)","v":""},null,null,"Lbs",null,"N) Percent Rock (M ÷ L*100):",null,null,{"$f":"IF(M43=\"\",\"\",ROUND(M43/M42*100,0))","v":""},"%"]
["D) Volume of Mold:",null,null,null,null,null,null,"Ft³",null,"O) Specific Gravity"]
["E) Wet Density (C ÷ D):",null,null,null,{"$f":"IF(E45=\"\",\"\",ROUND(E44/E45,1))","v":""},null,null,"Lbs"]
["F) Speedy Moisture Content:",null,null,null,null,null,null,"%","Corrected Optimum Moisture = ",null,null,"[H x (100 - N)] + N"]
["G) Moisture-Density Chart Letters:",null,null,null,null,null,null,"%",null,null,null,100]
["H) Optimum Moisture:",null,null,null,null,null,null,"%","Corrected Maximum Density = ",null,null,"[(100 - N) x I] + [56.2 x N x O]"]
["I) Maximum Dry Density:",null,null,null,null,null,null,"Lbs/Ft³",null,null,null,100]
["J) Optimum Moisture (Corrected):",null,null,null,{"$f":"IF(E49=\"\",\"\",IF(M44<10,E49,ROUND(((E49*(100-M44))+M44)/100,1)))","v":""},null,null,"%"]
["K) Maximum Dry Density (Corrected):",null,null,null,{"$f":"IF(E50=\"\",\"\",IF(M44<10,E50,ROUND((((100-M44)*E50)+(56.2*M44*M45))/100,1)))","v":""},null,null,"Lbs/Ft³"]

{"sheet":"Moisture-Density Chart","index":7,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,2,0,12]]}
[null,null,"TYPICAL MOISTURE-DENSITY TABLE"]
[]
["Curve Letter","Lb. Cu. Ft.","% Moist.","Curve Letter","Lb. Cu. Ft.","% Moist.","Curve Letter","Lb. Cu. Ft.","% Moist.","Curve Letter","Lb. Cu. Ft.","% Moist.","Curve Letter","Lb. Cu. Ft.","% Moist."]
["A",141.80000000000001,6.6,"F",129.30000000000001,9.6999999999999993,"K",117,13.5,"P",104.7,19.2,"U",92.1,25.8]
[0.1,141.5,6.7,0.1,129,9.8000000000000007,0.1,116.8,13.6,0.1,104.58,19.3,0.1,91.9,26]
[0.2,141.30000000000001,6.7,0.2,128.80000000000001,9.9,0.2,116.5,13.7,0.2,104.2,19.399999999999999,0.2,91.7,26.1]
[0.3,141,6.8,0.3,128.5,9.9,0.3,116.3,13.8,0.3,104,19.5,0.3,91.4,26.3]
[0.4,140.69999999999999,6.8,0.4,128.19999999999999,10,0.4,116,13.9,0.4,103.8,19.600000000000001,0.4,91.2,26.4]
[0.5,140.5,6.9,0.5,128,10.1,0.5,115.8,14.1,0.5,103.6,19.8,0.5,91,26.6]
[0.6,140.19999999999999,7,0.6,127.7,10.199999999999999,0.6,115.6,14.2,0.6,103.3,19.899999999999999,0.6,90.8,26.8]
[0.7,139.9,7,0.7,127.4,10.3,0.7,115.3,14.3,0.7,103.1,20,0.7,90.6,26.9]
[0.8,139.6,7.1,0.8,127.1,10.3,0.8,115.1,14.4,0.8,102.9,20.100000000000001,0.8,90.3,27.1]
[0.9,139.4,7.1,0.9,126.9,10.4,0.9,114.8,14.5,0.9,102.6,20.2,0.9,90.1,27.2]
["B",139.1,7.2,"G",126.6,10.5,"L",114.6,14.6,"Q",102.4,20.3,"V",89.9,27.4]
[0.1,138.80000000000001,7.3,0.1,126.4,10.6,0.1,114.3,14.7,0.1,102.2,20.399999999999999,0.1,89.7,27.6]
[0.2,138.5,7.3,0.2,126.1,10.6,0.2,114.1,14.8,0.2,101.9,20.5,0.2,89.4,27.8]
[0.3,138.30000000000001,7.4,0.3,125.9,10.7,0.3,113.8,15,0.3,101.7,20.7,0.3,89.2,28]
[0.4,138,7.5,0.4,125.6,10.8,0.4,113.6,15.1,0.4,101.4,20.8,0.4,88.9,28.2]
[0.5,137.69999999999999,7.6,0.5,125.4,10.9,0.5,113.3,15.2,0.5,101.2,20.9,0.5,88.7,28.5]
[0.6,137.30000000000001,7.6,0.6,125.2,10.9,0.6,113,15.3,0.6,100.9,21,0.6,88.5,28.7]
[0.7,137.1,7.7,0.7,124.9,11,0.7,112.8,15.4,0.7,100.7,21.1,0.7,88.2,28.9]
[0.8,136.9,7.8,0.8,124.7,11.1,0.8,112.5,15.6,0.8,100.4,21.3,0.8,88,29.1]
[0.9,136.6,7.8,0.9,124.4,11.1,0.9,112.3,15.7,0.9,100.2,21.4,0.9,87.7,29.3]
["C",136.30000000000001,7.9,"H",124.2,11.2,"M",112,15.8,"R",99.9,21.5,"W",87.5,29.5]
[0.1,136.1,8,0.1,124,11.3,0.1,111.8,15.9,0.1,99.7,21.6,0.1,87.3,29.6]
[0.2,135.9,8,0.2,123.7,11.3,0.2,111.5,16,0.2,99.4,21.7,0.2,87,29.7]
[0.3,135.6,8.1,0.3,123.5,11.4,0.3,111.3,16.100000000000001,0.3,99.2,21.9,0.3,86.8,29.8]
[0.4,135.4,8.1,0.4,123.2,11.5,0.4,111,16.2,0.4,98.9,22,0.4,86.5,29.9]
[0.5,135.19999999999999,8.1999999999999993,0.5,123,11.6,0.5,110.8,16.399999999999999,0.5,98.7,22.1,0.5,86.3,30]
[0.6,135,8.3000000000000007,0.6,122.7,11.6,0.6,110.6,16.5,0.6,98.4,22.2,0.6,86,30.1]
[0.7,134.80000000000001,8.3000000000000007,0.7,122.5,11.7,0.7,110.3,16.600000000000001,0.7,98.2,22.3,0.7,85.8,30.2]
[0.8,134.5,8.4,0.8,122.2,11.8,0.8,110.1,16.7,0.8,97.9,22.5,0.8,85.5,30.3]
[0.9,134.30000000000001,8.4,0.9,122,11.8,0.9,109.8,16.8,0.9,97.7,22.6,0.9,85.3,30.4]
["D",134.1,8.5,"I",121.7,11.9,"N",109.6,16.899999999999999,"S",97.4,22.7,"X",85,30.5]
[0.1,133.9,8.6,0.1,121.5,12,0.1,109.4,17,0.1,97.1,22.9,0.1,84.8,30.6]
[0.2,133.69999999999999,8.6,0.2,121.2,12.1,0.2,109.1,17.100000000000001,0.2,96.8,23,0.2,84.6,30.7]
[0.3,133.5,8.6999999999999993,0.3,121,12.1,0.3,108.9,17.3,0.3,96.6,23.2,0.3,84.4,30.8]
[0.4,133.30000000000001,8.6999999999999993,0.4,120.7,12.2,0.4,108.6,17.399999999999999,0.4,96.3,23.1,0.4,84.2,30.9]
[0.5,133.1,8.8000000000000007,0.5,120.5,12.3,0.5,108.4,17.5,0.5,96,23.6,0.5,84,31]
[0.6,132.80000000000001,8.8000000000000007,0.6,120.3,12.4,0.6,108.1,17.600000000000001,0.6,95.7,23.7,0.6,83.8,31.1]
[0.7,132.6,8.9,0.7,120,12.5,0.7,107.9,17.7,0.7,95.4,23.9,0.7,83.6,31.2]
[0.8,132.4,8.9,0.8,119.8,12.5,0.8,107.6,17.899999999999999,0.8,95.2,24.1,0.8,83.4,31.3]
[0.9,132.19999999999999,9,0.9,119.5,12.6,0.9,107.4,18,0.9,94.9,24.2,0.9,83.2,31.4]
["E",132,9,"J",119.3,12.7,"O",107.1,18.100000000000001,"T",94.6,24.4,"Y",83,31.5]
[0.1,131.69999999999999,9.1,0.1,119.1,12.8,0.1,106.9,18.2,0.1,94.4,24.5,0.1,82.8,31.6]
[0.2,131.5,9.1,0.2,118.8,12.9,0.2,106.6,18.3,0.2,94.1,24.7,0.2,82.6,31.7]
[0.3,131.19999999999999,9.1999999999999993,0.3,118.6,12.9,0.3,106.4,18.399999999999999,0.3,93.9,24.8,0.3,82.4,31.8]
[0.4,130.9,9.3000000000000007,0.4,118.4,13,0.4,106.1,18.5,0.4,93.6,25,0.4,82.2,31.9]
[0.5,130.69999999999999,9.4,0.5,118.2,13.1,0.5,105.9,18.7,0.5,93.4,25.1,0.5,82.1,32]
[0.6,130.4,9.4,0.6,117.9,13.2,0.6,105.7,18.8,0.6,93.1,25.2,0.6,81.900000000000006,32.1]
[0.7,130.1,9.5,0.7,117.7,13.3,0.7,105.4,18.899999999999999,0.7,92.9,25.4,0.7,81.7,32.200000000000003]
[0.8,129.80000000000001,9.6,0.8,117.5,13.3,0.8,105.2,19,0.8,92.6,25.5,0.8,81.5,32.299999999999997]
[0.9,129.6,9.6,0.9,117.2,13.4,0.9,104.9,19.100000000000001,0.9,92.4,25.7,0.9,81.3,32.4]
["F",129.30000000000001,9.6999999999999993,"K",117,13.5,"P",104.7,19.2,"U",92.1,25.8,"Z",81.099999999999994,32.5]