{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data Entry","Calculation","Print Sheet","Concrete Report"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Data Entry","index":0,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[46,1,46,7],[33,9,35,17],[1,2,1,3],[2,2,2,3],[3,2,3,3],[1,5,1,6],[2,5,2,6],[3,5,3,6],[1,8,1,10],[2,9,2,10],[3,9,3,10],[4,9,4,10],[5,9,5,10],[12,1,12,7],[5,1,5,6],[6,1,10,6],[7,8,7,9],[14,9,14,10],[15,9,15,10],[16,9,16,10],[8,9,9,13],[10,9,11,13],[17,9,17,10],[18,9,18,10],[17,19,17,27],[18,19,18,27],[55,1,55,7],[44,1,44,7],[19,1,19,7],[36,9,56,17],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[24,11,24,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12]]}
[]
[null,"Project Number:",null,null,"Date:",null,null,null,"Distribution List"]
[null,"PCN:",null,null,"Material:",null,null,null,"District:"]
[null,"Sample Number",null,null,"Sampled By:",null,null,null,"Engineer:"]
[null,null,null,null,null,null,null,null,"Contractor:"]
[null,"Remarks:",null,null,null,null,null,null,"Other:"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Optimized Gradation Worksheet"]
[]
[null,null,null,null,null,null,null,null,null,"Version 1.00.25"]
[]
[null,"Aggregate Properties"]
[null,null,"Coarse Agg. #1","Coarse Agg. #2","Intermediate Agg. #1","Intermediate Agg. #2","Fine Agg. #1","Fine Agg. #2"]
[null,"Material Type:",null,null,null,null,null,null,null,"Test Performed:",null,"Tested By:"]
[null,"Sampled From:",null,null,null,null,null,null,null,"ND T-27"]
[null,"Pit COA:",null,null,null,null,null,null,null,"ND T-11"]
[null,"Pit Owner:",null,null,null,null,null,null,null,"NDDOT 3, ND T-113"]
[null,"Blend %",null,null,null,null,null,null,null,"AASHTO T-104"]
[null,"Aggregate Weights Retention Entries",null,null,null,null,null,null,null,"AASHTO T-21"]
[null,"Sieve Size",null,null,null,null,null,null,null,"ND T-85"]
[null,"2\"",null,null,null,null,null,null,null,"AASHTO T-96"]
[null,"1 1/2\"",null,null,null,null,null,null,null,"AASHTO T-19"]
[null,"1 1/4\"",null,null,null,null,null,null,null,"ND T-255"]
[null,"1\""]
[null,"3/4\""]
[null,"5/8\""]
[null,"1/2\""]
[null,"3/8\""]
[null,"No. 4"]
[null,"No. 8"]
[null,"No. 10"]
[null,"No. 16"]
[null,"No. 30",null,null,null,null,null,null,null,"Worksheet Notes"]
[null,"No. 40"]
[null,"No. 50"]
[null,"No. 100",null,null,null,null,null,null,null,"1. Fill out a data entry worksheet matching each aggregate type to the corresponding aggregate column.\n2. Each aggregate type will match with either coarse, intermediate, or fine and will be tested according to each measurement.\n3. The recorded aggregate weights retained in each sieve will be entered into the appropriate cell to the nearest tenth except for the No. 200 and Minus No. 200 sieve will be recorded to the nearest hundredth.\n4. If any errors occur on the print sheet, check your values for the inputs on the data entry sheet and see if any have input errors or were incorrectly inputted within the document.\n5. Any aggregate sieves calculated as 0.0 should be entered in as 0.0 and not left blank.\n6. When entering your tech name by the test performed, please enter your initials followed by your tech ID (Example: JD ####).\n7. Once the data entry is complete, proceed to the print sheet and select the print button.\n8. If there are any other questions or concerns after working on the document that are not resolved, please contact the NDDOT M&R office for help."]
[null,"No. 200"]
[null,"Minus No. 8"]
[null,"Minus No. 200"]
[null,"Original Wt."]
[null,"Wt. After Wash"]
[null,"Wash Loss",null,null,{"$f":"IF(E41&E42=\"\",\"\",E41-E42)","v":""},"","",{"$f":"IF(H41&H42=\"\",\"\",H41-H42)","v":""}]
[null,"Wt. Check",{"$f":"IF(C22&C23&C24&C25&C26&C27&C28&C29&C30&C31&C39=\"\",\"\",SUM(C22:C31,C39))","v":""},{"$f":"IF(D22&D23&D24&D25&D26&D27&D28&D29&D30&D31&D39=\"\",\"\",SUM(D22:D31,D39))","v":""},{"$f":"IF(E28&E29&E30&E31&E32&E33&E34&E35&E36&E37&E38&E40=\"\",\"\",SUM(E40,E28:E38,E43))","v":""},{"$f":"IF(F28&F29&F30&F31&F32&F33&F34&F35&F36&F37&F38&F40=\"\",\"\",SUM(F40,F28:F38,F43))","v":""},{"$f":"IF(G29&G30&G31&G32&G33&G34&G35&G36&G37&G38&G40=\"\",\"\",SUM(G40,G29:G38,G43))","v":""},{"$f":"IF(H29&H30&H31&H32&H33&H34&H35&H36&H37&H38&H40=\"\",\"\",SUM(H40,H29:H38,H43))","v":""}]
[null,"Fine Physical Properties"]
[null,"Lightweight Pieces In Agg."]
[null,"Coarse Physical Properties"]
[null,"Dry Wt. Before Wash",null,null,{"$f":"IF(E41=\"\",\"\",E41)","v":""},{"$f":"IF(F41=\"\",\"\",F41)","v":""}]
[null,"Dry Wt. After Wash",null,null,{"$f":"IF(E42=\"\",\"\",E42)","v":""},{"$f":"IF(F42=\"\",\"\",F42)","v":""}]
[null,"Plus #4 Fraction",null,null,{"$f":"IF(E28&E29&E30=\"\",\"\",SUM(E28:E30))","v":""},{"$f":"IF(F28&F29&F30=\"\",\"\",SUM(F28:F30))","v":""}]
[null,"Shale \"4"]
[null,"Iron"]
[null,"Lignite/Coal"]
[null,"Soft"]
[null,"Thin/Elong"]
[null,"Lab Testing Verification"]
[null,"Soundness % Loss"]
[null,"Specific Gravity"]
[null,"L.A. Abrasion (Grad.) %Loss"]
[null,"% Absorption"]
[null,"Color"]
[null,"Wt Rodded lb./c.f. (kg/m^3)"]
[null,"Wt Loose lb./c.f. (kg/m^3)"]
[null,"% Moisture"]

{"sheet":"Calculation","index":1,"n_rows":175,"n_cols":52,"rows_kept":175,"cut":false,"hidden":true,"merged":[[78,9,78,10],[51,24,51,25],[55,24,55,25],[55,26,55,27],[50,9,50,10],[50,11,50,12],[51,9,51,10],[51,11,51,12],[77,11,77,12],[75,9,75,10],[70,9,70,10],[71,9,71,10],[72,9,72,10],[67,9,67,10],[68,11,68,12],[55,22,55,23],[55,20,55,21],[76,11,76,12],[51,28,51,29],[68,9,68,10],[69,9,69,10],[11,35,12,35],[168,6,169,12],[91,6,92,12],[123,6,124,12],[145,6,146,12],[161,11,161,12],[162,11,162,12],[163,11,163,12],[164,11,164,12],[156,11,156,12],[157,11,157,12],[158,11,158,12],[159,11,159,12],[160,11,160,12],[100,9,100,10],[15,30,15,31],[16,30,16,31],[27,30,27,31],[52,30,52,31],[76,9,76,10],[77,9,77,10],[51,30,51,31],[73,9,73,10],[74,9,74,10],[44,30,44,31],[39,30,39,31],[40,30,40,31],[28,30,28,31],[29,30,29,31],[30,30,30,31],[31,30,31,31],[32,30,32,31],[33,30,33,31],[34,30,34,31],[35,30,35,31],[37,30,37,31],[36,18,36,35],[30,28,30,29],[34,28,34,29],[30,24,30,25],[31,24,31,25],[28,26,28,27],[29,26,29,27],[55,28,55,29],[55,30,55,31],[30,26,30,27],[29,28,29,29],[31,26,31,27],[28,18,28,19],[29,18,29,19],[47,28,47,29],[52,26,52,27],[52,28,52,29],[49,20,49,21],[51,20,51,21],[52,20,52,21],[48,22,48,23],[48,24,48,25],[31,28,31,29],[32,24,32,25],[33,24,33,25],[32,26,32,27],[33,26,33,27],[32,28,32,29],[33,28,33,29],[45,26,45,27],[28,24,28,25],[29,20,29,21],[29,22,29,23],[79,11,79,12],[51,26,51,27],[49,26,49,27],[50,20,50,21],[50,22,50,23],[52,24,52,25],[51,22,51,23],[78,11,78,12],[67,11,67,12],[52,22,52,23],[50,24,50,25],[40,28,40,29],[41,28,41,29],[42,28,42,29],[49,28,49,29],[48,11,48,12],[42,26,42,27],[35,28,35,29],[41,11,41,12],[40,24,40,25],[43,28,43,29],[44,28,44,29],[45,28,45,29],[46,28,46,29],[48,28,48,29],[40,26,40,27],[39,22,39,23],[40,22,40,23],[45,22,45,23],[46,22,46,23],[37,20,37,21],[37,22,37,23],[37,24,37,25],[49,24,49,25],[47,20,47,21],[29,24,29,25],[14,22,14,23],[41,26,41,27],[39,24,39,25],[41,20,41,21],[23,22,23,23],[39,20,39,21],[40,20,40,21],[41,24,41,25],[25,26,25,27],[26,26,26,27],[21,24,21,25],[22,24,22,25],[23,24,23,25],[24,24,24,25],[25,24,25,25],[26,24,26,25],[23,26,23,27],[14,26,14,27],[24,26,24,27],[28,20,28,21],[28,22,28,23],[38,26,38,27],[39,26,39,27],[12,30,12,31],[13,30,13,31],[14,30,14,31],[12,28,12,29],[21,30,21,31],[22,30,22,31],[23,30,23,31],[103,11,103,12],[69,11,69,12],[70,11,70,12],[71,11,71,12],[72,11,72,12],[73,11,73,12],[74,11,74,12],[75,11,75,12],[100,11,100,12],[101,11,101,12],[99,11,99,12],[27,26,27,27],[30,20,30,21],[30,22,30,23],[46,26,46,27],[27,20,27,21],[26,20,26,21],[13,1,13,2],[13,3,13,4],[13,6,14,6],[41,6,42,6],[57,1,57,12],[0,6,0,7],[1,1,1,2],[1,3,1,4],[1,6,1,7],[2,1,2,2],[2,3,2,4],[2,6,2,7],[31,1,31,3],[32,1,32,3],[13,7,14,7],[14,1,14,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[3,1,3,7],[4,1,8,7],[11,11,11,12],[12,11,12,12],[13,11,13,12],[15,26,15,27],[21,20,21,21],[22,20,22,21],[14,20,14,21],[4,18,4,19],[5,18,5,19],[6,18,6,19],[12,26,12,27],[22,22,22,23],[16,26,16,27],[16,22,16,23],[16,24,16,25],[21,26,21,27],[22,26,22,27],[12,20,12,21],[12,18,12,19],[13,22,13,23],[13,26,13,27],[13,24,13,25],[15,20,15,21],[15,22,15,23],[13,20,13,21],[14,9,14,10],[15,9,15,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[16,9,16,10],[16,11,16,12],[16,20,16,21],[14,18,14,19],[16,18,16,19],[20,11,20,12],[14,11,14,12],[15,11,15,12],[17,11,17,12],[21,28,21,29],[22,28,22,29],[23,28,23,29],[24,28,24,29],[25,28,25,29],[26,28,26,29],[1,9,1,10],[1,11,1,12],[2,9,2,10],[6,9,6,10],[7,9,7,10],[8,11,8,12],[12,22,12,23],[21,22,21,23],[15,18,15,19],[7,11,7,12],[2,11,2,12],[3,9,3,10],[3,11,3,12],[12,24,12,25],[13,18,13,19],[10,14,10,16],[15,24,15,25],[10,1,10,12],[34,26,34,27],[35,26,35,27],[0,1,0,2],[0,3,0,4],[35,24,35,25],[6,11,6,12],[0,9,0,12],[12,6,12,8],[14,24,14,25],[4,9,4,10],[4,11,4,12],[9,14,9,16],[8,9,8,10],[13,5,14,5],[17,9,17,10],[18,9,18,10],[22,9,22,10],[23,9,23,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[24,22,24,23],[25,22,25,23],[27,22,27,23],[38,22,38,23],[38,24,38,25],[42,24,42,25],[43,22,43,23],[44,22,44,23],[42,20,42,21],[43,20,43,21],[44,20,44,21],[41,22,41,23],[42,22,42,23],[39,11,39,12],[43,11,43,12],[18,11,18,12],[19,11,19,12],[40,11,40,12],[23,11,23,12],[24,20,24,21],[25,20,25,21],[23,20,23,21],[29,1,29,12],[33,18,33,19],[34,18,34,19],[35,18,35,19],[41,1,41,2],[42,9,42,10],[42,1,42,2],[38,20,38,21],[22,11,22,12],[26,22,26,23],[30,18,30,19],[31,18,31,19],[32,18,32,19],[41,3,41,4],[173,1,173,12],[153,1,153,12],[41,5,42,5],[69,5,70,5],[101,5,102,5],[133,5,134,5],[156,5,157,5],[133,6,134,6],[133,7,134,7],[156,6,157,6],[156,7,157,7],[59,6,60,12],[125,1,125,3],[107,9,107,10],[66,1,66,12],[89,1,89,12],[87,1,87,12],[98,1,98,12],[121,1,121,12],[88,1,88,2],[91,1,91,3],[104,11,104,12],[42,11,42,12],[19,18,19,19],[20,18,20,19],[21,18,21,19],[22,18,22,19],[23,18,23,19],[24,18,24,19],[25,18,25,19],[26,18,26,19],[27,18,27,19],[45,11,45,12],[46,11,46,12],[38,1,38,12],[31,6,32,12],[41,9,41,10],[41,7,42,7],[33,1,33,3],[34,1,34,3],[39,9,39,10],[40,9,40,10],[21,11,21,12],[92,1,92,3],[108,9,108,10],[114,1,114,2],[109,9,109,10],[101,6,102,6],[49,9,49,10],[69,6,70,6],[69,7,70,7],[70,1,70,2],[82,1,82,2],[84,1,84,2],[85,1,85,2],[61,1,61,3],[59,1,59,3],[60,1,60,3],[83,1,83,2],[62,1,62,3],[69,1,69,2],[69,3,69,4],[111,9,111,10],[53,1,53,2],[54,1,54,2],[55,1,55,2],[79,9,79,10],[163,9,163,10],[164,9,164,10],[136,9,136,10],[137,9,137,10],[162,9,162,10],[138,9,138,10],[139,9,139,10],[140,9,140,10],[141,9,141,10],[159,9,159,10],[160,9,160,10],[161,9,161,10],[155,11,155,12],[138,11,138,12],[139,11,139,12],[140,11,140,12],[107,11,107,12],[108,11,108,12],[102,11,102,12],[126,1,126,3],[133,11,133,12],[134,11,134,12],[123,1,123,3],[136,11,136,12],[150,1,150,12],[130,1,130,12],[135,11,135,12],[124,1,124,3],[154,11,154,12],[111,11,111,12],[119,1,119,12],[131,11,131,12],[141,11,141,12],[137,11,137,12],[132,11,132,12],[109,11,109,12],[93,1,93,3],[94,1,94,3],[101,1,101,2],[101,3,101,4],[120,1,120,2],[105,9,105,10],[99,9,99,10],[105,11,105,12],[106,11,106,12],[116,1,116,2],[106,9,106,10],[102,1,102,2],[101,7,102,7],[101,9,101,10],[102,9,102,10],[104,9,104,10],[103,9,103,10],[117,1,117,2],[110,9,110,10],[110,11,110,12],[43,26,43,27],[44,26,44,27],[50,26,50,27],[45,24,45,25],[46,24,46,25],[44,9,44,10],[46,9,46,10],[44,11,44,12],[48,20,48,21],[48,9,48,10],[47,9,47,10],[47,11,47,12],[47,22,47,23],[47,24,47,25],[47,26,47,27],[46,20,46,21],[45,20,45,21],[43,9,43,10],[45,9,45,10],[49,11,49,12],[49,22,49,23],[48,26,48,27],[50,28,50,29],[50,30,50,31],[44,24,44,25],[43,24,43,25],[24,30,24,31],[25,30,25,31],[26,30,26,31],[27,28,27,29],[28,28,28,29],[37,28,37,29],[38,28,38,29],[27,24,27,25],[45,30,45,31],[46,30,46,31],[48,30,48,31],[41,30,41,31],[38,30,38,31],[47,30,47,31],[49,30,49,31],[42,30,42,31],[43,30,43,31],[39,28,39,29],[34,24,34,25],[37,26,37,27]]}
[null,"Project Number:",null,{"$f":"IF('Data Entry'!C2=\"\",\"\",'Data Entry'!C2)","v":""},null,"Date:",{"$f":"IF('Data Entry'!F2=\"\",\"\",'Data Entry'!F2)","v":""},null,null,"Distribution:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"PCN:",null,{"$f":"IF('Data Entry'!C3=\"\",\"\",'Data Entry'!C3)","v":""},null,"Material:",{"$f":"IF('Data Entry'!F3=\"\",\"\",'Data Entry'!F3)","v":""},null,null,"District:",null,{"$f":"IF('Data Entry'!J3=\"\",\"\",'Data Entry'!J3)","v":""},null,null,null,null,null,null,"Optimized Concrete Aggregate Gradation Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,5]
[null,"Sample Number:",null,{"$f":"IF('Data Entry'!C4=\"\",\"\",'Data Entry'!C4)","v":""},null,"Sampled By:",{"$f":"IF('Data Entry'!F4=\"\",\"\",'Data Entry'!F4)","v":""},null,null,"Engineer:",null,{"$f":"IF('Data Entry'!J4=\"\",\"\",'Data Entry'!J4)","v":""},null,null,null,null,null,null,"NDDOT Field Testing Laboratory"]
[null,"Remarks:",null,null,null,null,null,null,null,"Contractor:",null,{"$f":"IF('Data Entry'!J5=\"\",\"\",'Data Entry'!J5)","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,0,16]
[null,{"$f":"IF('Data Entry'!B7=\"\",\"\",'Data Entry'!B7)","v":""},null,null,null,null,null,null,null,"Other:",null,{"$f":"IF('Data Entry'!J6=\"\",\"\",'Data Entry'!J6)","v":""},null,null,null,null,null,null,"Project Number:",null,{"$f":"IF(D1=\"\",\"\",D1)","v":""},null,null,null,null,"Date:",null,{"$f":"IF(G1=\"\",\"\",G1)","v":""},null,null,null,null,null,null,null,null,null,null,0,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCN:",null,{"$f":"IF(D2=\"\",\"\",D2)","v":""},null,null,null,null,"Material:",null,{"$f":"IF(G2=\"\",\"\",G2)","v":""}]
[null,null,null,null,null,null,null,null,null,"ND T 27 Tech Name:",null,null,null,null,null,null,null,null,"Sample Number:",null,{"$f":"IF(D3=\"\",\"\",D3)","v":""},null,null,null,null,"Sampled By:",null,{"$f":"IF(G3=\"\",\"\",G3)","v":""},null,null,null,null,null,null,null,null,null,null,4,20]
[null,null,null,null,null,null,null,null,null,"ND T-11 Tech Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,20]
[null,null,null,null,null,null,null,null,null,"NDDOT 3, ND T 113 Tech Name:",null,null,null,null,null,null,null,null,"Aggregate Gradations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Submittal Tech Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12]
[null,"Course Agg. #1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data Entry'!I9=\"\",\"\",'Data Entry'!I9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,35]
[null,"Material Type:",{"$f":"IF('Data Entry'!C15=\"\",\"\",'Data Entry'!C15)","v":""},"Pit COA:",{"$f":"IF('Data Entry'!C17=\"\",\"\",'Data Entry'!C17)","v":""},null,"% Blend:",{"$f":"IF('Data Entry'!C19=\"\",\"\",'Data Entry'!C19)","v":""},null,"Soundness % Loss",null,{"$f":"IF('Data Entry'!C$57=\"\",\"\",'Data Entry'!C$57)","v":""},null,null,null,null,null,null,null,null,"Course Agg. #1",null,"Course Agg. #2",null,"Intermediate Agg. #1",null,"Intermediate Agg. #2",null,"Fine Agg. #1",null,"Fine Agg. #2",null,"Combined",null,null,"ND Spec.",null,null,4,20]
[null,"Sampled From:",{"$f":"IF('Data Entry'!C16=\"\",\"\",'Data Entry'!C16)","v":""},"Pit Owner",{"$f":"IF('Data Entry'!C18=\"\",\"\",'Data Entry'!C18)","v":""},null,"If this is only material, make blend 100",null,null,"AASHTO T-104 Tested By:",null,null,null,null,null,null,null,null,"% Blend",null,{"$f":"IF(H12=\"\",\"\",H12)","v":""},null,{"$f":"IF($H40=\"\",\"\",$H40)","v":""},null,{"$f":"IF($H68=\"\",\"\",$H68)","v":""},null,{"$f":"IF($H100=\"\",\"\",$H100)","v":""},null,{"$f":"IF($H132=\"\",\"\",$H132)","v":""},null,{"$f":"IF($H155=\"\",\"\",$H155)","v":""},null,{"$f":"IF(U13&W13&Y13&AA13&AC13&AE13=\"\",\"\",SUM(U13,W13,Y13,AC13,AA13,AE13))","v":""},null,null,null,null,null,4,20,10]
[null,"Sieve Size",null,"Wt. Ret.",null,"% Ret. Non-Cum.","% Ret. Cum.","% Pass",null,"Specific Gravity",null,{"$f":"IF('Data Entry'!C$58=\"\",\"\",'Data Entry'!C$58)","v":""},null,null,null,null,null,null,"Material :",null,{"$f":"IF(C12=\"\",\"\",C12)","v":""},null,{"$f":"IF($C40=\"\",\"\",$C40)","v":""},null,{"$f":"IF($C68=\"\",\"\",$C68)","v":""},null,{"$f":"IF($C100=\"\",\"\",$C100)","v":""},null,{"$f":"IF($C132=\"\",\"\",$C132)","v":""},null,{"$f":"IF($C155=\"\",\"\",$C155)","v":""},null,null,null,null,null,null,null,0,10]
[null,null,null,"Non-Cum.","Cum.",null,null,null,null,"ND T-85 Tested By:",null,null,null,null,null,null,null,null,"Sampled From:",null,{"$f":"IF(C13=\"\",\"\",C13)","v":""},null,{"$f":"IF($C41=\"\",\"\",$C41)","v":""},null,{"$f":"IF($C69=\"\",\"\",$C69)","v":""},null,{"$f":"IF($C101=\"\",\"\",$C101)","v":""},null,{"$f":"IF($C133=\"\",\"\",$C133)","v":""},null,{"$f":"IF($C156=\"\",\"\",$C156)","v":""},null,null,null,null,null,null,null,0,2]
[null,"50 mm","2\"",{"$f":"IF('Data Entry'!C22=\"\",\"\",'Data Entry'!C22)","v":""},{"$f":"IF(D16=\"\",\"\",D16)","v":""},{"$f":"IF(D16=\"\",\"\",IF((D16/$D$28)*100*10-INT((D16/$D$28)*100*10)<0.5,ROUNDDOWN((D16/$D$28)*100,1),IF((D16/$D$28)*100*10-INT((D16/$D$28)*100*10)>0.5,ROUNDUP((D16/$D$28)*100,1),IF((D16/$D$28)*100*10-INT((D16/$D$28)*100*10)=0.5,IF(MOD(INT((D16/$D$28)*100*10),2)=0,ROUNDDOWN((D16/$D$28)*100,1),ROUNDUP((D16/$D$28)*100,1))))))","v":""},{"$f":"IF(E16=\"\",\"\",IF((E16/$D$28)*100*10-INT((E16/$D$28)*100*10)<0.5,ROUNDDOWN((E16/$D$28)*100,1),IF((E16/$D$28)*100*10-INT((E16/$D$28)*100*10)>0.5,ROUNDUP((E16/$D$28)*100,1),IF((E16/$D$28)*100*10-INT((E16/$D$28)*100*10)=0.5,IF(MOD(INT((E16/$D$28)*100*10),2)=0,ROUNDDOWN((E16/$D$28)*100,1),ROUNDUP((E16/$D$28)*100,1))))))","v":""},{"$f":"IF(D16=\"\",\"\",100-G16)","v":""},null,"% Absorption",null,{"$f":"IF('Data Entry'!C$60=\"\",\"\",'Data Entry'!C$60)","v":""},null,null,null,null,null,null,"Pit Location:",null,{"$f":"IF(E12=\"\",\"\",E12)","v":""},null,{"$f":"IF($E40=\"\",\"\",$E40)","v":""},null,{"$f":"IF($E68=\"\",\"\",$E68)","v":""},null,{"$f":"IF($E100=\"\",\"\",$E100)","v":""},null,{"$f":"IF($E132=\"\",\"\",$E132)","v":""},null,{"$f":"IF($E155=\"\",\"\",$E155)","v":""}]
[null,"37.5 mm","1 1/2\"",{"$f":"IF('Data Entry'!C23=\"\",\"\",'Data Entry'!C23)","v":""},{"$f":"IF(D17=\"\",\"\",SUM(D16:D17))","v":""},{"$f":"IF(D17=\"\",\"\",IF((D17/$D$28)*100*10-INT((D17/$D$28)*100*10)<0.5,ROUNDDOWN((D17/$D$28)*100,1),IF((D17/$D$28)*100*10-INT((D17/$D$28)*100*10)>0.5,ROUNDUP((D17/$D$28)*100,1),IF((D17/$D$28)*100*10-INT((D17/$D$28)*100*10)=0.5,IF(MOD(INT((D17/$D$28)*100*10),2)=0,ROUNDDOWN((D17/$D$28)*100,1),ROUNDUP((D17/$D$28)*100,1))))))","v":""},{"$f":"IF(E17=\"\",\"\",IF((E17/$D$28)*100*10-INT((E17/$D$28)*100*10)<0.5,ROUNDDOWN((E17/$D$28)*100,1),IF((E17/$D$28)*100*10-INT((E17/$D$28)*100*10)>0.5,ROUNDUP((E17/$D$28)*100,1),IF((E17/$D$28)*100*10-INT((E17/$D$28)*100*10)=0.5,IF(MOD(INT((E17/$D$28)*100*10),2)=0,ROUNDDOWN((E17/$D$28)*100,1),ROUNDUP((E17/$D$28)*100,1))))))","v":""},"",null,"Color",null,{"$f":"IF('Data Entry'!C$61=\"\",\"\",'Data Entry'!C$61)","v":""},null,null,null,null,null,null,"Pit Owner:",null,{"$f":"IF(E13=\"\",\"\",E13)","v":""},null,{"$f":"IF($E41=\"\",\"\",$E41)","v":""},null,{"$f":"IF($E69=\"\",\"\",$E69)","v":""},null,{"$f":"IF($E101=\"\",\"\",$E101)","v":""},null,{"$f":"IF($E133=\"\",\"\",$E133)","v":""},null,{"$f":"IF($E156=\"\",\"\",$E156)","v":""},null,null,null,null,null,null,null,null,0,3]
[null,"31.75 mm","1 1/4\"",{"$f":"IF('Data Entry'!C24=\"\",\"\",'Data Entry'!C24)","v":""},{"$f":"IF(D18=\"\",\"\",SUM(D16:D18))","v":""},"","","",null,"AAASHTO T-21 Tested By:"]
[null,"25.0 mm","1\"",{"$f":"IF('Data Entry'!C25=\"\",\"\",'Data Entry'!C25)","v":""},{"$f":"IF(D19=\"\",\"\",SUM(D16:D19))","v":""},"","","",null,"Wt Rodded lb./c.f. (kg/m^3)",null,{"$f":"IF('Data Entry'!C$62=\"\",\"\",'Data Entry'!C$62)","v":""}]
[null,"19.0 mm","3/4\"",{"$f":"IF('Data Entry'!C26=\"\",\"\",'Data Entry'!C26)","v":""},{"$f":"IF(D20=\"\",\"\",SUM(D16:D20))","v":""},"","","",null,"AASHTO T-19 Tested By:",null,null,null,null,null,null,null,null,"Sieve \nSize",null,"% Passing",null,"% Passing",null,"% Passing",null,"% Passing",null,"% Passing",null,"% Passing",null,"% Passing","% Retained","Pass or Fail","% Retained"]
[null,"16.0 mm","5/8\"",{"$f":"IF('Data Entry'!C27=\"\",\"\",'Data Entry'!C27)","v":""},{"$f":"IF(D21=\"\",\"\",SUM(D16:D21))","v":""},"","","",null,"% Moisture",null,{"$f":"IF('Data Entry'!C$64=\"\",\"\",'Data Entry'!C$64)","v":""}]
[null,"12.5 mm","½\"",{"$f":"IF('Data Entry'!C28=\"\",\"\",'Data Entry'!C28)","v":""},{"$f":"IF(D22=\"\",\"\",SUM(D16:D22))","v":""},"","","",null,"ND T-255 Tested By:",null,null,null,null,null,null,null,null,"2\"",null,{"$f":"IF($D16=\"\",\"\",$H16)","v":""},null,{"$f":"IF($D44=\"\",\"\",$H44)","v":""},null,{"$f":"IF($Y$13=\"\",\"\",$Y$13)","v":""},null,{"$f":"IF($AA$13=\"\",\"\",$AA$13)","v":""},null,{"$f":"IF($AC$13=\"\",\"\",$AC$13)","v":""},null,{"$f":"IF($AE$13=\"\",\"\",$AE$13)","v":""},null,{"$f":"IF(U22&W22&Y22&AA22&AC22&AE22=\"\",\"\",SUM(AO22:AT22))","v":""},{"$f":"IF(U22&W22&Y22&AA22&AC22&AE22=\"\",\"\",SUM(AU22:AZ22))","v":""},{"$f":"IF(U22&W22&Y22&AA22&AC22&AE22=\"\",\"\",IF(AM1<=AH22,IF(AH22<=AN1,\"Pass\",\"Fail\"),\"Fail\"))","v":""},0,null,null,null,"2\"",{"$f":"IF(U22=\"\",\"\",IF($H$12=\"\",100*(U22/100),($H$12/100)*U22))","v":""},{"$f":"IF(W22=\"\",\"\",IF($H$40=\"\",100*(W22/100),($H$40/100)*W22))","v":""},{"$f":"IF(Y22=\"\",\"\",Y22)","v":""},{"$f":"IF(AA22=\"\",\"\",AA22)","v":""},{"$f":"IF(AC22=\"\",\"\",AC22)","v":""},{"$f":"IF(AE22=\"\",\"\",AE22)","v":""},{"$f":"IF(F16=\"\",\"\",IF($H$12=\"\",100*(F16/100),($H$12/100)*F16))","v":""},{"$f":"IF(D44=\"\",\"\",IF($H$40=\"\",100*(F44/100),($H$40/100)*F44))","v":""}]
[null,"9.5 mm","3/8\"",{"$f":"IF('Data Entry'!C29=\"\",\"\",'Data Entry'!C29)","v":""},{"$f":"IF(D23=\"\",\"\",SUM(D16:D23))","v":""},"","","",null,"L.A. Abration (Grad.) %Loss",null,{"$f":"IF('Data Entry'!C$59=\"\",\"\",'Data Entry'!C$59)","v":""},null,null,null,null,null,null,"1 1/2\"",null,"",null,"",null,{"$f":"IF($Y$13=\"\",\"\",$Y$13)","v":""},null,{"$f":"IF($AA$13=\"\",\"\",$AA$13)","v":""},null,{"$f":"IF($AC$13=\"\",\"\",$AC$13)","v":""},null,{"$f":"IF($AE$13=\"\",\"\",$AE$13)","v":""},null,{"$f":"IF(U23&W23&Y23&AA23&AC23&AE23=\"\",\"\",SUM(AO23:AT23))","v":""},{"$f":"IF(U23&W23&Y23&AA23&AC23&AE23=\"\",\"\",SUM(AU23:AZ23))","v":""},{"$f":"IF(U23&W23&Y23&AA23&AC23&AE23=\"\",\"\",IF(AM2<=AH23,IF(AH23<=AN2,\"Pass\",\"Fail\"),\"Fail\"))","v":""},"≤5",null,null,null,"1 1/2\"",{"$f":"IF(U23=\"\",\"\",IF($H$12=\"\",100*(U23/100),($H$12/100)*U23))","v":""},{"$f":"IF(W23=\"\",\"\",IF($H$40=\"\",100*(W23/100),($H$40/100)*W23))","v":""},{"$f":"IF(Y23=\"\",\"\",Y23)","v":""},{"$f":"IF(AA23=\"\",\"\",AA23)","v":""},{"$f":"IF(AC23=\"\",\"\",AC23)","v":""},{"$f":"IF(AE23=\"\",\"\",AE23)","v":""},{"$f":"IF(F17=\"\",\"\",IF($H$12=\"\",100*(F17/100),($H$12/100)*F17))","v":""},{"$f":"IF(D45=\"\",\"\",IF($H$40=\"\",100*(F45/100),($H$40/100)*F45))","v":""}]
[null,"4.75 mm","No. 4",{"$f":"IF('Data Entry'!C30=\"\",\"\",'Data Entry'!C30)","v":""},{"$f":"IF(D24=\"\",\"\",SUM(D16:D24))","v":""},"","","",null,"AASHTO T-96",null,null,null,null,null,null,null,null,"1 1/4\"",null,"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF(U24&W24&Y24&AA24&AC24&AE24=\"\",\"\",SUM(AO24:AT24))","v":""},"",null,null,null,null,null,"1 1/4\"","","","","","","","",""]
[null,"2.36 mm","No. 8",{"$f":"IF('Data Entry'!C31=\"\",\"\",'Data Entry'!C31)","v":""},{"$f":"IF(D25=\"\",\"\",SUM(D16:D25))","v":""},"","","",null,null,null,null,null,null,null,null,null,null,"1\"",null,"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF(U25&W25&Y25&AA25&AC25&AE25=\"\",\"\",SUM(AO25:AT25))","v":""},"","","≤16",null,null,null,"1\"","","","","","","","",""]
[null,"Minus No. 8",null,{"$f":"IF('Data Entry'!C39=\"\",\"\",'Data Entry'!C39)","v":""},{"$f":"IF(D26=\"\",\"\",SUM(D16:D26))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"3/4\"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","≤20",null,null,null,"3/4\"","","","","","","","",""]
[null,"Wt. Check",null,{"$f":"IF(D28=\"\",\"\",SUM(D16:D26))","v":""},{"$f":" IF(D28=\"\",\"\",((D28-D27)/D28)*100)","v":""},{"$f":"IF(D28=\"\",\"\",100-E27)","v":""},"%Error",null,null,null,null,null,null,null,null,null,null,null,"5/8\"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF($AE$13=\"\",\"\",$AE$13)","v":""},null,{"$f":"IF(U27&W27&Y27&AA27&AC27&AE27=\"\",\"\",SUM(AO27:AT27))","v":""},{"$f":"IF(U27&W27&Y27&AA27&AC27&AE27=\"\",\"\",SUM(AU27:AZ27))","v":""},null,null,null,null,null,"5/8\"","","","","","","",{"$f":"IF(F21=\"\",\"\",IF($H$12=\"\",100*(F21/100),($H$12/100)*F21))","v":""},""]
[null,"Original Wt.",null,{"$f":"IF('Data Entry'!C41=\"\",\"\",'Data Entry'!C41)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2\"",null,"",null,"",null,{"$f":"IF($D72=\"\",\"\",$H72)","v":""},null,{"$f":"IF($D104=\"\",\"\",$H104)","v":""},null,"",null,"",null,"","","","4-20",null,null,null,"1/2\"","","",{"$f":"IF(Y28=\"\",\"\",IF($H$68=\"\",100*(Y28/100),($H$68/100)*Y28))","v":""},{"$f":"IF(AA28=\"\",\"\",IF($H$68=\"\",100*(AA28/100),($H$68/100)*AA28))","v":""},"","",{"$f":"IF(F22=\"\",\"\",IF($H$12=\"\",100*(F22/100),($H$12/100)*F22))","v":""},"",{"$f":"IF(D72=\"\",\"\",IF($H$68=\"\",100*(F72/100),($H$68/100)*F72))","v":""},{"$f":"IF(D104=\"\",\"\",IF($H$100=\"\",100*(F104/100),($H$100/100)*F104))","v":""}]
[null,"ND T 27","Tested By: Initials",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/8\"",null,"",null,"",null,{"$f":"IF($D73=\"\",\"\",$H73)","v":""},null,{"$f":"IF($D105=\"\",\"\",$H105)","v":""},null,{"$f":"IF($D136=\"\",\"\",$H136)","v":""},null,{"$f":"IF($D159=\"\",\"\",$H159)","v":""},null,"","","","4-20",null,null,null,"3/8\"","","","","",{"$f":"IF(AC29=\"\",\"\",IF($H$132=\"\",100*(AC29/100),($H$132/100)*AC29))","v":""},{"$f":"IF(AE29=\"\",\"\",IF($H$155=\"\",100*(AE29/100),($H$155/100)*AE29))","v":""},"","",{"$f":"IF(D73=\"\",\"\",IF($H$68=\"\",100*(F73/100),($H$68/100)*F73))","v":""},{"$f":"IF(D105=\"\",\"\",IF($H$100=\"\",100*(F105/100),($H$100/100)*F105))","v":""},{"$f":"IF(D136=\"\",\"\",IF($H$132=\"\",100*(F136/100),($H$132/100)*F136))","v":""},{"$f":"IF(D159=\"\",\"\",IF($H$155=\"\",100*(F159/100),($H$155/100)*F159))","v":""}]
[null,"Coarse Aggregate Properties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#4",null,"",null,"",null,{"$f":"IF($D74=\"\",\"\",$H74)","v":""},null,{"$f":"IF($D106=\"\",\"\",$H106)","v":""},null,{"$f":"IF($D137=\"\",\"\",$H137)","v":""},null,{"$f":"IF($D160=\"\",\"\",$H160)","v":""},null,"","","","4-20",null,null,null,"#4","","","","",{"$f":"IF(AC30=\"\",\"\",IF($H$132=\"\",100*(AC30/100),($H$132/100)*AC30))","v":""},"","","","","",{"$f":"IF(D137=\"\",\"\",IF($H$132=\"\",100*(F137/100),($H$132/100)*F137))","v":""},{"$f":"IF(D160=\"\",\"\",IF($H$155=\"\",100*(F160/100),($H$155/100)*F160))","v":""}]
[null,"Coarse wash ND T-11:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#8",null,"",null,"",null,{"$f":"IF($D75=\"\",\"\",$H75)","v":""},null,{"$f":"IF($D107=\"\",\"\",$H107)","v":""},null,{"$f":"IF($D138=\"\",\"\",$H138)","v":""},null,{"$f":"IF($D161=\"\",\"\",$H161)","v":""},null,"","","","≤12",null,null,null,"#8","","","","","","","","",{"$f":"IF(D75=\"\",\"\",IF($H$68=\"\",100*(F75/100),($H$68/100)*F75))","v":""},"","",""]
[null,"Dry weight before washing-",null,null,{"$f":"IF('Data Entry'!C48=\"\",\"\",'Data Entry'!C48)","v":""},null,"Note: If any test was not performed. Leave cell blank.",null,null,null,null,null,null,null,null,null,null,null,"#16",null,null,null,null,null,{"$f":"IF($D77=\"\",\"\",$H77)","v":""},null,{"$f":"IF($D109=\"\",\"\",$H109)","v":""},null,{"$f":"IF($D140=\"\",\"\",$H140)","v":""},null,{"$f":"IF($D163=\"\",\"\",$H163)","v":""},null,"","","","≤12",null,null,null,"#16",null,null,"","","","",null,null,{"$f":"IF(D77=\"\",\"\",IF($H$68=\"\",100*(F77/100),($H$68/100)*F77))","v":""},{"$f":"IF(D109=\"\",\"\",IF($H$100=\"\",100*(F109/100),($H$100/100)*F109))","v":""},{"$f":"IF(D140=\"\",\"\",IF($H$132=\"\",100*(F140/100),($H$132/100)*F140))","v":""},""]
[null,"Dry weight after washing-",null,null,{"$f":"IF('Data Entry'!C49=\"\",\"\",'Data Entry'!C49)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"#30",null,null,null,null,null,{"$f":"IF($D78=\"\",\"\",$H78)","v":""},null,{"$f":"IF($D110=\"\",\"\",$H110)","v":""},null,{"$f":"IF($D141=\"\",\"\",$H141)","v":""},null,{"$f":"IF($D164=\"\",\"\",$H164)","v":""},null,"","","","4-20",null,null,null,"#30",null,null,"","","","",null,null,{"$f":"IF(D78=\"\",\"\",IF($H$68=\"\",100*(F78/100),($H$68/100)*F78))","v":""},{"$f":"IF(D110=\"\",\"\",IF($H$100=\"\",100*(F110/100),($H$100/100)*F110))","v":""},{"$f":"IF(D141=\"\",\"\",IF($H$132=\"\",100*(F141/100),($H$132/100)*F141))","v":""},""]
[null,"Material passing No. 200 Sieve%",null,null,{"$f":"IF(E32=\"\",\"\",((E32-E33)/E32)*100)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"#50",null,null,null,null,null,{"$f":"IF($D80=\"\",\"\",$H80)","v":""},null,{"$f":"IF($D112=\"\",\"\",$H112)","v":""},null,{"$f":"IF($D143=\"\",\"\",$H143)","v":""},null,{"$f":"IF($D166=\"\",\"\",$H166)","v":""},null,"","","","4-20",null,null,null,"#50",null,null,"","","","",null,null,{"$f":"IF(D80=\"\",\"\",IF($H$68=\"\",100*(F80/100),($H$68/100)*F80))","v":""},{"$f":"IF(D112=\"\",\"\",IF($H$100=\"\",100*(F112/100),($H$100/100)*F112))","v":""},{"$f":"IF(D143=\"\",\"\",IF($H$132=\"\",100*(F143/100),($H$132/100)*F143))","v":""},""]
[null,"Plus #4 Fraction of coarse wash:",null,null,{"$f":"IF('Data Entry'!C50=\"\",\"\",'Data Entry'!C50)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"#100",null,null,null,null,null,{"$f":"IF($D81=\"\",\"\",$H81)","v":""},null,{"$f":"IF($D113=\"\",\"\",$H113)","v":""},null,{"$f":"IF($D144=\"\",\"\",$H144)","v":""},null,{"$f":"IF($D167=\"\",\"\",$H167)","v":""},null,"","","","≤10",null,null,null,"#100",null,null,"","","","",null,null,{"$f":"IF(D81=\"\",\"\",IF($H$68=\"\",100*(F81/100),($H$68/100)*F81))","v":""},{"$f":"IF(D113=\"\",\"\",IF($H$100=\"\",100*(F113/100),($H$100/100)*F113))","v":""},{"$f":"IF(D144=\"\",\"\",IF($H$132=\"\",100*(F144/100),($H$132/100)*F144))","v":""},""]
[null,"Shale +#4:",{"$f":"IF('Data Entry'!C51=\"\",\"\",'Data Entry'!C51)","v":""},"Soft:",{"$f":"IF('Data Entry'!C54=\"\",\"\",'Data Entry'!C54)","v":""},null,"Lignite/Coal:",{"$f":"IF('Data Entry'!C53=\"\",\"\",'Data Entry'!C53)","v":""},null,null,null,null,null,null,null,null,null,null,"#200",null,null,null,null,null,{"$f":"IF($D82=\"\",\"\",$H82)","v":""},null,{"$f":"IF($D114=\"\",\"\",$H114)","v":""},null,{"$f":"IF($D145=\"\",\"\",$H145)","v":""},null,{"$f":"IF($D168=\"\",\"\",$H168)","v":""},null,"","","","≤2",null,null,null,"#200",null,null,"","","","",null,null,"",{"$f":"IF(D114=\"\",\"\",IF($H$100=\"\",100*(F114/100),($H$100/100)*F114))","v":""},"",""]
[null,"Iron:",{"$f":"IF('Data Entry'!C52=\"\",\"\",'Data Entry'!C52)","v":""},"Thin/Elong:",{"$f":"IF('Data Entry'!C55=\"\",\"\",'Data Entry'!C55)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Physical Aggregate Properties"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shale +#4:",null,{"$f":"IF($C36=\"\",\"\",($C36/$E35))","v":""},null,{"$f":"IF($C64=\"\",\"\",($C64/$E63))","v":""},null,{"$f":"IF($C96=\"\",\"\",($C96/$E95))","v":""},null,{"$f":"IF(C128=\"\",\"\",(C128/E127))","v":""},null,null,null,null,null,{"$f":"IF(U38&W38&Y38&AA38=\"\",\"\",(SUM(U38*SUM($U$13)/100)+(SUM(W38)*SUM($W$13)/100)+(SUM(Y38)*SUM($Y$13)/100)+(SUM(AA38)*SUM($AA$13)/100)))","v":""},null,null,"≤0.7%"]
[null,"Course Agg. #2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lightweight pieces:",null,null,null,null,null,null,null,null,null,{"$f":"IF($D152=\"\",\"\",($D152/D$149))","v":""},null,{"$f":"IF($D175=\"\",\"\",($D175/D$172))","v":""},null,{"$f":"IF(AC39&AE39=\"\",\"\",(SUM(AC39*SUM($AC$13)/100)+(SUM(AE39)*SUM($AE$13)/100)))","v":""},null,null,"≤2.0%"]
[null,"Material Type:",{"$f":"IF('Data Entry'!D15=\"\",\"\",'Data Entry'!D15)","v":""},"Pit Location:",{"$f":"IF('Data Entry'!D17=\"\",\"\",'Data Entry'!D17)","v":""},null,"% Blend:",{"$f":"IF('Data Entry'!D19=\"\",\"\",'Data Entry'!D19)","v":""},null,"Soundness % Loss",null,{"$f":"IF('Data Entry'!D$57=\"\",\"\",'Data Entry'!D$57)","v":""},null,null,null,null,null,null,"Iron oxide particles:",null,{"$f":"IF($C37=\"\",\"\",($C37/$E35))","v":""},null,{"$f":"IF($C65=\"\",\"\",($C65/$E63))","v":""},null,{"$f":"IF($C97=\"\",\"\",($C97/$E95))","v":""},null,{"$f":"IF($C128=\"\",\"\",($C128/$E127))","v":""},null,null,null,null,null,{"$f":"IF(U40&W40&Y40&AA40=\"\",\"\",(SUM(U40*SUM($U$13)/100)+(SUM(W40)*SUM($W$13)/100)+(SUM(Y40)*SUM($Y$13)/100)+(SUM(AA40)*SUM($AA$13)/100)))","v":""},null,null,"≤4.0%"]
[null,"Sampled From:",{"$f":"IF('Data Entry'!D16=\"\",\"\",'Data Entry'!D16)","v":""},"Pit Owner",{"$f":"IF('Data Entry'!D18=\"\",\"\",'Data Entry'!D18)","v":""},null,"If this is only material, make blend 100",null,null,"AASHTO T-104 Tested By:",null,null,null,null,null,null,null,null,"Lignite and other coal:",null,{"$f":"IF($H36=\"\",\"\",($H36/$E35))","v":""},null,{"$f":"IF($H64=\"\",\"\",($H64/$E63))","v":""},null,{"$f":"IF($G96=\"\",\"\",($G96/$E95))","v":""},null,{"$f":"IF(G128=\"\",\"\",(G128/E127))","v":""},null,null,null,null,null,"",null,null,"≤0.5%"]
[null,"Sieve Size",null,"Wt. Ret.",null,"% Ret. Non-Cum.","% Ret. Cum.","% Pass",null,"Specific Gravity",null,{"$f":"IF('Data Entry'!D$58=\"\",\"\",'Data Entry'!D$58)","v":""},null,null,null,null,null,null,"Soft particles exclusive of items a, b, c:",null,{"$f":"IF($E36=\"\",\"\",($E36/$E35))","v":""},null,{"$f":"IF($E64=\"\",\"\",($E64/$E63))","v":""},null,{"$f":"IF($E96=\"\",\"\",($E96/$E95))","v":""},null,{"$f":"IF($E128=\"\",\"\",($E128/$E127))","v":""},null,null,null,null,null,"",null,null,"≤2.5%"]
[null,null,null,"Non-Cum.","Cum.",null,null,null,null,"ND T-85 Tested By:"]
[null,"50 mm","2\"",{"$f":"IF('Data Entry'!D22=\"\",\"\",'Data Entry'!D22)","v":""},{"$f":"IF(D44=\"\",\"\",D44)","v":""},{"$f":"IF(D44=\"\",\"\",IF((D44/$D$56)*100*10-INT((D44/$D$56)*100*10)<0.5,ROUNDDOWN((D44/$D$56)*100,1),IF((D44/$D$56)*100*10-INT((D44/$D$56)*100*10)>0.5,ROUNDUP((D44/$D$56)*100,1),IF((D44/$D$56)*100*10-INT((D44/$D$56)*100*10)=0.5,IF(MOD(INT((D44/$D$56)*100*10),2)=0,ROUNDDOWN((D44/$D$56)*100,1),ROUNDUP((D44/$D$56)*100,1))))))","v":""},{"$f":"IF(E44=\"\",\"\",IF((E44/$D$56)*100*10-INT((E44/$D$56)*100*10)<0.5,ROUNDDOWN((E44/$D$56)*100,1),IF((E44/$D$56)*100*10-INT((E44/$D$56)*100*10)>0.5,ROUNDUP((E44/$D$56)*100,1),IF((E44/$D$56)*100*10-INT((E44/$D$56)*100*10)=0.5,IF(MOD(INT((E44/$D$56)*100*10),2)=0,ROUNDDOWN((E44/$D$56)*100,1),ROUNDUP((E44/$D$56)*100,1))))))","v":""},{"$f":"IF(D44=\"\",\"\",100-G44)","v":""},null,"% Absorption",null,{"$f":"IF('Data Entry'!D$60=\"\",\"\",'Data Entry'!D$60)","v":""},null,null,null,null,null,null,"Thin or elongated pieces (4:1 thin, 3:1 elongated):",null,{"$f":"IF($E37=\"\",\"\",($E37/$E35))","v":""},null,{"$f":"IF($E65=\"\",\"\",($E65/$E63))","v":""},null,{"$f":"IF($E97=\"\",\"\",($E97/$E95))","v":""},null,{"$f":"IF($E129=\"\",\"\",($E129/$E127))","v":""},null,null,null,null,null,"",null,null,"≤15.0%"]
[null,"37.5 mm","1 1/2\"",{"$f":"IF('Data Entry'!D23=\"\",\"\",'Data Entry'!D23)","v":""},{"$f":"IF(D45=\"\",\"\",SUM(D44:D45))","v":""},{"$f":"IF(D45=\"\",\"\",IF((D45/$D$56)*100*10-INT((D45/$D$56)*100*10)<0.5,ROUNDDOWN((D45/$D$56)*100,1),IF((D45/$D$56)*100*10-INT((D45/$D$56)*100*10)>0.5,ROUNDUP((D45/$D$56)*100,1),IF((D45/$D$56)*100*10-INT((D45/$D$56)*100*10)=0.5,IF(MOD(INT((D45/$D$56)*100*10),2)=0,ROUNDDOWN((D45/$D$56)*100,1),ROUNDUP((D45/$D$56)*100,1))))))","v":""},{"$f":"IF(E45=\"\",\"\",IF((E45/$D$56)*100*10-INT((E45/$D$56)*100*10)<0.5,ROUNDDOWN((E45/$D$56)*100,1),IF((E45/$D$56)*100*10-INT((E45/$D$56)*100*10)>0.5,ROUNDUP((E45/$D$56)*100,1),IF((E45/$D$56)*100*10-INT((E45/$D$56)*100*10)=0.5,IF(MOD(INT((E45/$D$56)*100*10),2)=0,ROUNDDOWN((E45/$D$56)*100,1),ROUNDUP((E45/$D$56)*100,1))))))","v":""},"",null,"Color",null,{"$f":"IF('Data Entry'!D$61=\"\",\"\",'Data Entry'!D$61)","v":""}]
[null,"31.75 mm","1 1/4\"",{"$f":"IF('Data Entry'!D24=\"\",\"\",'Data Entry'!D24)","v":""},{"$f":"IF(D46=\"\",\"\",SUM(D44:D46))","v":""},"","","",null,"AAASHTO T-21 Tested By:",null,null,null,null,null,null,null,null,"Soundness % Loss",null,{"$f":"IF($L12=\"\",\"\",$L12)","v":""},null,{"$f":"IF($L40=\"\",\"\",$L40)","v":""},null,{"$f":"IF($L68=\"\",\"\",$L68)","v":""},null,{"$f":"IF($L100=\"\",\"\",$L100)","v":""},null,{"$f":"IF($L132=\"\",\"\",$L132)","v":""},null,{"$f":"IF($L155=\"\",\"\",$L155)","v":""},null,{"$f":"IF(U46&W46&Y46&AA46&AC46&AE46=\"\",\"\",((SUM(U46)*SUM($U$13))+(SUM(W46)*SUM($W$13))+(SUM(Y46)*SUM($Y$13))+(SUM(AA46)*SUM($AA$13))+(SUM(AC46)*SUM($AC$13))+(SUM(AE46)*SUM($AE$13)))/100)","v":""}]
[null,"25.0 mm","1\"",{"$f":"IF('Data Entry'!D25=\"\",\"\",'Data Entry'!D25)","v":""},{"$f":"IF(D47=\"\",\"\",SUM(D44:D47))","v":""},"","","",null,"Wt Rodded lb./c.f. (kg/m^3)",null,{"$f":"IF('Data Entry'!D$62=\"\",\"\",'Data Entry'!D$62)","v":""},null,null,null,null,null,null,"Specific Gravity",null,{"$f":"IF($L14=\"\",\"\",$L14)","v":""},null,{"$f":"IF($L42=\"\",\"\",$L42)","v":""},null,{"$f":"IF($L70=\"\",\"\",$L70)","v":""},null,{"$f":"IF($L102=\"\",\"\",$L102)","v":""},null,{"$f":"IF($L134=\"\",\"\",$L134)","v":""},null,{"$f":"IF($L157=\"\",\"\",$L157)","v":""},null,{"$f":"IF(U47&W47&Y47&AA47&AC47&AE47=\"\",\"\",((SUM(U47)*SUM($U$13))+(SUM(W47)*SUM($W$13))+(SUM(Y47)*SUM($Y$13))+(SUM(AA47)*SUM($AA$13))+(SUM(AC47)*SUM($AC$13))+(SUM(AE47)*SUM($AE$13)))/100)","v":""}]
[null,"19.0 mm","3/4\"",{"$f":"IF('Data Entry'!D26=\"\",\"\",'Data Entry'!D26)","v":""},{"$f":"IF(D48=\"\",\"\",SUM(D44:D48))","v":""},"","","",null,"AASHTO T-19 Tested By:",null,null,null,null,null,null,null,null,"L.A. Abrasion % Loss",null,{"$f":"IF($L23=\"\",\"\",$L23)","v":""},null,{"$f":"IF($L51=\"\",\"\",$L51)","v":""},null,{"$f":"IF($L79=\"\",\"\",$L79)","v":""},null,{"$f":"IF($L111=\"\",\"\",$L111)","v":""},null,{"$f":"IF('Data Entry'!G59=\"\",\"\",'Data Entry'!G59)","v":""},null,{"$f":"IF('Data Entry'!H59=\"\",\"\",'Data Entry'!H59)","v":""},null,""]
[null,"16.0 mm","5/8\"",{"$f":"IF('Data Entry'!D27=\"\",\"\",'Data Entry'!D27)","v":""},{"$f":"IF(D49=\"\",\"\",SUM(D44:D49))","v":""},"","","",null,"% Moisture",null,{"$f":"IF('Data Entry'!D$64=\"\",\"\",'Data Entry'!D$64)","v":""},null,null,null,null,null,null,"% Absorption",null,{"$f":"IF($L16=\"\",\"\",$L16)","v":""},null,{"$f":"IF($L44=\"\",\"\",$L44)","v":""},null,{"$f":"IF($L72=\"\",\"\",$L72)","v":""},null,{"$f":"IF($L104=\"\",\"\",$L104)","v":""},null,{"$f":"IF($L136=\"\",\"\",$L136)","v":""},null,{"$f":"IF($L159=\"\",\"\",$L159)","v":""},null,""]
[null,"12.5 mm","½\"",{"$f":"IF('Data Entry'!D28=\"\",\"\",'Data Entry'!D28)","v":""},{"$f":"IF(D50=\"\",\"\",SUM(D44:D50))","v":""},"","","",null,"ND T-255 Tested By:",null,null,null,null,null,null,null,null,"Color",null,{"$f":"IF($L17=\"\",\"\",$L17)","v":""},null,{"$f":"IF($L45=\"\",\"\",$L45)","v":""},null,{"$f":"IF($L73=\"\",\"\",$L73)","v":""},null,{"$f":"IF($L105=\"\",\"\",$L105)","v":""},null,{"$f":"IF($L137=\"\",\"\",$L137)","v":""},null,{"$f":"IF($L160=\"\",\"\",$L160)","v":""}]
[null,"9.5 mm","3/8\"",{"$f":"IF('Data Entry'!D29=\"\",\"\",'Data Entry'!D29)","v":""},{"$f":"IF(D51=\"\",\"\",SUM(D44:D51))","v":""},"","","",null,"L.A. Abration (Grad.) %Loss",null,{"$f":"IF('Data Entry'!D$59=\"\",\"\",'Data Entry'!D$59)","v":""},null,null,null,null,null,null,"Wt Rodded lb/cf (kg/m^3)",null,{"$f":"IF('Data Entry'!C62=\"\",\"\",'Data Entry'!C62)","v":""},null,{"$f":"IF('Data Entry'!D62=\"\",\"\",'Data Entry'!D62)","v":""},null,{"$f":"IF('Data Entry'!E62=\"\",\"\",'Data Entry'!E62)","v":""},null,{"$f":"IF('Data Entry'!F62=\"\",\"\",'Data Entry'!F62)","v":""},null,{"$f":"IF('Data Entry'!G62=\"\",\"\",'Data Entry'!G62)","v":""},null,{"$f":"IF('Data Entry'!H62=\"\",\"\",'Data Entry'!H62)","v":""},null,""]
[null,"4.75 mm","No. 4",{"$f":"IF('Data Entry'!D30=\"\",\"\",'Data Entry'!D30)","v":""},{"$f":"IF(D52=\"\",\"\",SUM(D44:D52))","v":""},"","","",null,"AASHTO T-96",null,null,null,null,null,null,null,null,"Wt Loose lb/cf (kg/m^3):",null,{"$f":"IF('Data Entry'!C63=\"\",\"\",'Data Entry'!C63)","v":""},null,{"$f":"IF('Data Entry'!D63=\"\",\"\",'Data Entry'!D63)","v":""},null,{"$f":"IF('Data Entry'!E63=\"\",\"\",'Data Entry'!E63)","v":""},null,{"$f":"IF('Data Entry'!F63=\"\",\"\",'Data Entry'!F63)","v":""},null,{"$f":"IF('Data Entry'!G63=\"\",\"\",'Data Entry'!G63)","v":""},null,{"$f":"IF('Data Entry'!H63=\"\",\"\",'Data Entry'!H63)","v":""},null,""]
[null,"2.36 mm","No. 8",{"$f":"IF('Data Entry'!D31=\"\",\"\",'Data Entry'!D31)","v":""},{"$f":"IF(D53=\"\",\"\",SUM(D44:D53))","v":""},"","","",null,null,null,null,null,null,null,null,null,null,"% Moisture",null,{"$f":"IF($L21=\"\",\"\",$L21)","v":""},null,{"$f":"IF($L49=\"\",\"\",$L49)","v":""},null,{"$f":"IF($L77=\"\",\"\",$L77)","v":""},null,{"$f":"IF($L109=\"\",\"\",$L109)","v":""},null,{"$f":"IF($L141=\"\",\"\",$L141)","v":""},null,{"$f":"IF($L164=\"\",\"\",$L164)","v":""},null,""]
[null,"Minus No. 8",null,{"$f":"IF('Data Entry'!D39=\"\",\"\",'Data Entry'!D39)","v":""},{"$f":"IF(D54=\"\",\"\",SUM(D44:D54))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Course Sand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH31&AH32&AH33=\"\",\"\",SUM(AH31:AH33))","v":""},{"$f":"IF(AH54=\"\",\"\",IF(0<=AH54,IF(AH54>=15,\"Pass\",\"Fail\"),\"Fail\"))","v":""},"≥15.0"]
[null,"Wt. Check",null,{"$f":"IF(D56=\"\",\"\",SUM(D44:D54))","v":""},{"$f":" IF(D56=\"\",\"\",((D56-D55)/D56)*100)","v":""},{"$f":"IF(D56=\"\",\"\",100-E55)","v":""},"%Error",null,null,null,null,null,null,null,null,null,null,null,"Fine Sand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG33&AG34&AG35&AG36=\"\",\"\",SUM(AG33:AG36))","v":""},{"$f":"IF(AH55=\"\",\"\",IF(AH55>=24,IF(AH55<=34,\"Pass\",\"Fail\"),\"Fail\"))","v":""},"24-34"]
[null,"Original Wt.",null,{"$f":"IF('Data Entry'!D41=\"\",\"\",'Data Entry'!D41)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wt. Check %",null,{"$f":"IF($E27=\"\",\"\",100-$E27)","v":""},null,{"$f":"IF($E55=\"\",\"\",100-$E55)","v":""},null,{"$f":"IF($E85=\"\",\"\",100-$E85)","v":""},null,{"$f":"IF($E117=\"\",\"\",100-$E117)","v":""},null,{"$f":"IF($E148=\"\",\"\",100-$E148)","v":""},null,{"$f":"IF($E171=\"\",\"\",100-$E171)","v":""}]
[null,"ND T 27","Tested By: Initials"]
[null,"Coarse Aggregate Properties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remarks:"]
[null,"Coarse wash ND T-11:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B5=\"\",\"\",B5)","v":""}]
[null,"Dry weight before washing-",null,null,{"$f":"IF('Data Entry'!D48=\"\",\"\",'Data Entry'!D48)","v":""},null,"Note: If any test was not performed. Leave cell blank."]
[null,"Dry weight after washing-",null,null,{"$f":"IF('Data Entry'!D49=\"\",\"\",'Data Entry'!D49)","v":""}]
[null,"Material passing No. 200 Sieve%",null,null,{"$f":"IF(E60=\"\",\"\",((E60-E61)/E60)*100)","v":""}]
[null,"Plus #4 Fraction of coarse wash:",null,null,{"$f":"IF('Data Entry'!D50=\"\",\"\",'Data Entry'!D50)","v":""}]
[null,"Shale +#4:",{"$f":"IF('Data Entry'!D51=\"\",\"\",'Data Entry'!D51)","v":""},"Soft:",{"$f":"IF('Data Entry'!D54=\"\",\"\",'Data Entry'!D54)","v":""},null,"Lignite/Coal:",{"$f":"IF('Data Entry'!D53=\"\",\"\",'Data Entry'!D53)","v":""},null,null,null,null,null,null,null,null,null,null,"Distribution:",null,null,null,null,"Test:",null,"Tech. Name",null,null,null,null,null,null,"Test:",null,"Tech. Name"]
[null,"Iron:",{"$f":"IF('Data Entry'!D52=\"\",\"\",'Data Entry'!D52)","v":""},"Thin/Elong:",{"$f":"IF('Data Entry'!D55=\"\",\"\",'Data Entry'!D55)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"District:",{"$f":"IF(L2=\"\",\"\",L2)","v":""},null,null,null,"ND T-27",null,{"$f":"IF(U22&W22&Y28&AA28&AC29&AE29=\"\",\"\",'Data Entry'!L$16)","v":""},null,null,null,null,null,null,"ND T-85",null,{"$f":"IF(U47&U49&W49&W47&Y47&AA47&AC47&AE47&Y49&AA49&AC49&AE49=\"\",\"\",'Data Entry'!L21)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"IF(L3=\"\",\"\",L3)","v":""},null,null,null,"ND T-11",null,{"$f":"IF(U38&U40&U42&U41&U44&W44&Y44&AA44&W42&W41&W40&W38&Y38&AA38&Y40&AA40&Y42&AA42=\"\",\"\",'Data Entry'!L17)","v":""},null,null,null,null,null,null,"AASHTO T-96",null,{"$f":"IF(U48&W48&Y48&AA48&AC48&AE48=\"\",\"\",'Data Entry'!$L22)","v":""}]
[null,"Intermediate Agg. #1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contractor:",{"$f":"IF(L4=\"\",\"\",L4)","v":""},null,null,null,"NDDOT 3, ND T-113",null,{"$f":"IF(U39&W39&Y39&AA39&AC39&AE39=\"\",\"\",'Data Entry'!L18)","v":""},null,null,null,null,null,null,"AASHTO T-19",null,{"$f":"IF(U51&W51&Y52&AA52&AC52&AE52=\"\",\"\",'Data Entry'!L23)","v":""}]
[null,"Material Type:",{"$f":"IF('Data Entry'!E15=\"\",\"\",'Data Entry'!E15)","v":""},"Pit Location:",{"$f":"IF('Data Entry'!E17=\"\",\"\",'Data Entry'!E17)","v":""},null,"% Blend:",{"$f":"IF('Data Entry'!E19=\"\",\"\",'Data Entry'!E19)","v":""},null,"Soundness % Loss",null,{"$f":"IF('Data Entry'!E$57=\"\",\"\",'Data Entry'!E$57)","v":""},null,null,null,null,null,null," Other:",{"$f":"IF(L5=\"\",\"\",L5)","v":""},null,null,null,"AASHTO T-104",null,{"$f":"IF(U46&W46&Y46&AA46&AC46&AE46=\"\",\"\",'Data Entry'!L19)","v":""},null,null,null,null,null,null,"ND T-255",null,{"$f":"IF(U53&W53&Y53&AA53&AC53&AE53=\"\",\"\",'Data Entry'!L24)","v":""}]
[null,"Sampled From:",{"$f":"IF('Data Entry'!E16=\"\",\"\",'Data Entry'!E16)","v":""},"Pit Owner",{"$f":"IF('Data Entry'!E18=\"\",\"\",'Data Entry'!E18)","v":""},null,"If this is only material, make blend 100",null,null,"AASHTO T-104 Tested By:",null,null,null,null,null,null,null,null,null,null,null,null,null,"AASHTO T-21",null,{"$f":"IF(U50&W50&Y50&AA50&AC50&AE50=\"\",\"\",'Data Entry'!L20)","v":""}]
[null,"Sieve Size",null,"Wt. Ret.",null,"% Ret. Non-Cum.","% Ret. Cum.","% Pass",null,"Specific Gravity",null,{"$f":"IF('Data Entry'!E$58=\"\",\"\",'Data Entry'!E$58)","v":""}]
[null,null,null,"Non-Cum.","Cum.",null,null,null,null,"ND T-85 Tested By:"]
[null,"12.5 mm","½\"",{"$f":"IF('Data Entry'!E28=\"\",\"\",'Data Entry'!E28)","v":""},{"$f":"IF(D72=\"\",\"\",SUM(D72:D72))","v":""},{"$f":"IF(D72=\"\",\"\",IF((D72/$D$86)*100*10-INT((D72/$D$86)*100*10)<0.5,ROUNDDOWN((D72/$D$86)*100,1),IF((D72/$D$86)*100*10-INT((D72/$D$86)*100*10)>0.5,ROUNDUP((D72/$D$86)*100,1),IF((D72/$D$86)*100*10-INT((D72/$D$86)*100*10)=0.5,IF(MOD(INT((D72/$D$86)*100*10),2)=0,ROUNDDOWN((D72/$D$86)*100,1),ROUNDUP((D72/$D$86)*100,1))))))","v":""},{"$f":"IF(E72=\"\",\"\",IF((E72/$D$86)*100*10-INT((E72/$D$86)*100*10)<0.5,ROUNDDOWN((E72/$D$86)*100,1),IF((E72/$D$86)*100*10-INT((E72/$D$86)*100*10)>0.5,ROUNDUP((E72/$D$86)*100,1),IF((E72/$D$86)*100*10-INT((E72/$D$86)*100*10)=0.5,IF(MOD(INT((E72/$D$86)*100*10),2)=0,ROUNDDOWN((E72/$D$86)*100,1),ROUNDUP((E72/$D$86)*100,1))))))","v":""},{"$f":"IF(D72=\"\",\"\",100-G72)","v":""},null,"% Absorbtion",null,{"$f":"IF('Data Entry'!E$60=\"\",\"\",'Data Entry'!E$60)","v":""}]
[null,"9.5 mm","3/8\"",{"$f":"IF('Data Entry'!E29=\"\",\"\",'Data Entry'!E29)","v":""},{"$f":"IF(D73=\"\",\"\",SUM(D72:D73))","v":""},{"$f":"IF(D73=\"\",\"\",IF((D73/$D$86)*100*10-INT((D73/$D$86)*100*10)<0.5,ROUNDDOWN((D73/$D$86)*100,1),IF((D73/$D$86)*100*10-INT((D73/$D$86)*100*10)>0.5,ROUNDUP((D73/$D$86)*100,1),IF((D73/$D$86)*100*10-INT((D73/$D$86)*100*10)=0.5,IF(MOD(INT((D73/$D$86)*100*10),2)=0,ROUNDDOWN((D73/$D$86)*100,1),ROUNDUP((D73/$D$86)*100,1))))))","v":""},{"$f":"IF(E73=\"\",\"\",IF((E73/$D$86)*100*10-INT((E73/$D$86)*100*10)<0.5,ROUNDDOWN((E73/$D$86)*100,1),IF((E73/$D$86)*100*10-INT((E73/$D$86)*100*10)>0.5,ROUNDUP((E73/$D$86)*100,1),IF((E73/$D$86)*100*10-INT((E73/$D$86)*100*10)=0.5,IF(MOD(INT((E73/$D$86)*100*10),2)=0,ROUNDDOWN((E73/$D$86)*100,1),ROUNDUP((E73/$D$86)*100,1))))))","v":""},"",null,"Color",null,{"$f":"IF('Data Entry'!E$61=\"\",\"\",'Data Entry'!E$61)","v":""}]
[null,"4.75 mm","No. 4",{"$f":"IF('Data Entry'!E30=\"\",\"\",'Data Entry'!E30)","v":""},{"$f":"IF(D74=\"\",\"\",SUM(D72:D74))","v":""},"","","",null,"AAASHTO T-21 Tested By:"]
[null,"2.36 mm","No. 8",{"$f":"IF('Data Entry'!E31=\"\",\"\",'Data Entry'!E31)","v":""},{"$f":"IF(D75=\"\",\"\",SUM(D72:D75))","v":""},"","","",null,"Wt Loose lb./c.f. (kg/m^3)",null,{"$f":"IF('Data Entry'!E$63=\"\",\"\",'Data Entry'!E$63)","v":""}]
[null,"2.00 mm","No. 10",{"$f":"IF('Data Entry'!E32=\"\",\"\",'Data Entry'!E32)","v":""},{"$f":"IF(D76=\"\",\"\",SUM(D72:D76))","v":""},"","","",null,"AASHTO T-19 Tested By:"]
[null,"1.18 mm","No. 16",{"$f":"IF('Data Entry'!E33=\"\",\"\",'Data Entry'!E33)","v":""},{"$f":"IF(D77=\"\",\"\",SUM(D72:D77))","v":""},"","","",null,"% Moisture",null,{"$f":"IF('Data Entry'!E$64=\"\",\"\",'Data Entry'!E$64)","v":""}]
[null,"600 um","No. 30",{"$f":"IF('Data Entry'!E34=\"\",\"\",'Data Entry'!E34)","v":""},{"$f":"IF(D78=\"\",\"\",SUM(D72:D78))","v":""},"","","",null,"ND T-255 Tested By:"]
[null,"425 um","No. 40",{"$f":"IF('Data Entry'!E35=\"\",\"\",'Data Entry'!E35)","v":""},{"$f":"IF(D79=\"\",\"\",SUM(D72:D79))","v":""},"","","",null,"L.A. Abration (Grad.) %Loss",null,{"$f":"IF('Data Entry'!E$59=\"\",\"\",'Data Entry'!E$59)","v":""}]
[null,"300 um","No. 50",{"$f":"IF('Data Entry'!E36=\"\",\"\",'Data Entry'!E36)","v":""},{"$f":"IF(D80=\"\",\"\",SUM(D72:D80))","v":""},"","","",null,"AASHTO T-96"]
[null,"150 um","No. 100",{"$f":"IF('Data Entry'!E37=\"\",\"\",'Data Entry'!E37)","v":""},{"$f":"IF(D81=\"\",\"\",SUM(D72:D81))","v":""},"","",""]
[null,"75 um","No. 200",{"$f":"IF('Data Entry'!E38=\"\",\"\",'Data Entry'!E38)","v":""},{"$f":"IF(D82=\"\",\"\",SUM(D72:D82))","v":""},"","",""]
[null,"Minus No. 200 (75 um)",null,{"$f":"IF('Data Entry'!E40=\"\",\"\",'Data Entry'!E40)","v":""},{"$f":"IF(D83=\"\",\"\",SUM(D72:D83))","v":""}]
[null,"Wt. After Wash",null,{"$f":"IF('Data Entry'!E42=\"\",\"\",'Data Entry'!E42)","v":""}]
[null,"Wt. Check",null,{"$f":"IF(D86=\"\",\"\",SUM(D72:D83))","v":""},{"$f":" IF(D86=\"\",\"\",((D84-D85)/D84)*100)","v":""},{"$f":"IF(D86=\"\",\"\",100-E85)","v":""},"%Error"]
[null,"Original Wt.",null,{"$f":"IF('Data Entry'!E41=\"\",\"\",'Data Entry'!E41)","v":""}]
[null,"ND T 27","Tested By: Initials"]
[null,"Fine Aggregate Properties"]
[null,"Lightweight pieces ND T-113:",null,{"$f":"IF('Data Entry'!E46=\"\",\"\",'Data Entry'!E46)","v":""}]
[null,"Coarse Aggregate Properties"]
[null,"Coarse wash ND T-11:"]
[null,"Dry weight before washing-",null,null,{"$f":"IF('Data Entry'!E48=\"\",\"\",'Data Entry'!E48)","v":""},null,"Note: If any test was not performed. Leave cell blank."]
[null,"Dry weight after washing-",null,null,{"$f":"IF('Data Entry'!E49=\"\",\"\",'Data Entry'!E49)","v":""}]
[null,"Material passing No. 200 Sieve%",null,null,{"$f":"IF(E92=\"\",\"\",((E92-E93)/E92)*100)","v":""}]
[null,"Plus #4 Fraction of coarse wash:",null,null,{"$f":"IF('Data Entry'!E50=\"\",\"\",'Data Entry'!E50)","v":""}]
[null,"Shale +#4:",{"$f":"IF('Data Entry'!E51=\"\",\"\",'Data Entry'!E51)","v":""},"Soft:",{"$f":"IF('Data Entry'!E54=\"\",\"\",'Data Entry'!E54)","v":""},"Lignite/Coal:",{"$f":"IF('Data Entry'!E53=\"\",\"\",'Data Entry'!E53)","v":""}]
[null,"Iron:",{"$f":"IF('Data Entry'!E52=\"\",\"\",'Data Entry'!E52)","v":""},"Thin/Elong:",{"$f":"IF('Data Entry'!E55=\"\",\"\",'Data Entry'!E55)","v":""}]
[]
[null,"Intermediate Agg. #2"]
[null,"Material Type:",{"$f":"IF('Data Entry'!F15=\"\",\"\",'Data Entry'!F15)","v":""},"Pit Location:",{"$f":"IF('Data Entry'!F17=\"\",\"\",'Data Entry'!F17)","v":""},null,"% Blend:",{"$f":"IF('Data Entry'!F19=\"\",\"\",'Data Entry'!F19)","v":""},null,"Soundness % Loss",null,{"$f":"IF('Data Entry'!F$57=\"\",\"\",'Data Entry'!F$57)","v":""}]
[null,"Sampled From:",{"$f":"IF('Data Entry'!F16=\"\",\"\",'Data Entry'!F16)","v":""},"Pit Owner",{"$f":"IF('Data Entry'!F18=\"\",\"\",'Data Entry'!F18)","v":""},null,"If this is only material, make blend 100",null,null,"AASHTO T-104 Tested By:"]
[null,"Sieve Size",null,"Wt. Ret.",null,"% Ret. Non-Cum.","% Ret. Cum.","% Pass",null,"Specific Gravity",null,{"$f":"IF('Data Entry'!F$58=\"\",\"\",'Data Entry'!F$58)","v":""}]
[null,null,null,"Non-Cum.","Cum.",null,null,null,null,"ND T-85 Tested By:"]
[null,"12.5 mm","½\"",{"$f":"IF('Data Entry'!F28=\"\",\"\",'Data Entry'!F28)","v":""},{"$f":"IF(D104=\"\",\"\",SUM(D104:D104))","v":""},{"$f":"IF(D104=\"\",\"\",IF((D104/$D$118)*100*10-INT((D104/$D$118)*100*10)<0.5,ROUNDDOWN((D104/$D$118)*100,1),IF((D104/$D$118)*100*10-INT((D104/$D$118)*100*10)>0.5,ROUNDUP((D104/$D$118)*100,1),IF((D104/$D$118)*100*10-INT((D104/$D$118)*100*10)=0.5,IF(MOD(INT((D104/$D$118)*100*10),2)=0,ROUNDDOWN((D104/$D$118)*100,1),ROUNDUP((D104/$D$118)*100,1))))))","v":""},{"$f":"IF(E104=\"\",\"\",IF((E104/$D$118)*100*10-INT((E104/$D$118)*100*10)<0.5,ROUNDDOWN((E104/$D$118)*100,1),IF((E104/$D$118)*100*10-INT((E104/$D$118)*100*10)>0.5,ROUNDUP((E104/$D$118)*100,1),IF((E104/$D$118)*100*10-INT((E104/$D$118)*100*10)=0.5,IF(MOD(INT((E104/$D$118)*100*10),2)=0,ROUNDDOWN((E104/$D$118)*100,1),ROUNDUP((E104/$D$118)*100,1))))))","v":""},{"$f":"IF(D104=\"\",\"\",100-G104)","v":""},null,"% Absorbtion",null,{"$f":"IF('Data Entry'!F$60=\"\",\"\",'Data Entry'!F$60)","v":""}]
[null,"9.5 mm","3/8\"",{"$f":"IF('Data Entry'!F29=\"\",\"\",'Data Entry'!F29)","v":""},{"$f":"IF(D105=\"\",\"\",SUM(D104:D105))","v":""},{"$f":"IF(D105=\"\",\"\",IF((D105/$D$118)*100*10-INT((D105/$D$118)*100*10)<0.5,ROUNDDOWN((D105/$D$118)*100,1),IF((D105/$D$118)*100*10-INT((D105/$D$118)*100*10)>0.5,ROUNDUP((D105/$D$118)*100,1),IF((D105/$D$118)*100*10-INT((D105/$D$118)*100*10)=0.5,IF(MOD(INT((D105/$D$118)*100*10),2)=0,ROUNDDOWN((D105/$D$118)*100,1),ROUNDUP((D105/$D$118)*100,1))))))","v":""},{"$f":"IF(E105=\"\",\"\",IF((E105/$D$118)*100*10-INT((E105/$D$118)*100*10)<0.5,ROUNDDOWN((E105/$D$118)*100,1),IF((E105/$D$118)*100*10-INT((E105/$D$118)*100*10)>0.5,ROUNDUP((E105/$D$118)*100,1),IF((E105/$D$118)*100*10-INT((E105/$D$118)*100*10)=0.5,IF(MOD(INT((E105/$D$118)*100*10),2)=0,ROUNDDOWN((E105/$D$118)*100,1),ROUNDUP((E105/$D$118)*100,1))))))","v":""},"",null,"Color",null,{"$f":"IF('Data Entry'!F$61=\"\",\"\",'Data Entry'!F$61)","v":""}]
[null,"4.75 mm","No. 4",{"$f":"IF('Data Entry'!F30=\"\",\"\",'Data Entry'!F30)","v":""},{"$f":"IF(D106=\"\",\"\",SUM(D104:D106))","v":""},"","","",null,"AAASHTO T-21 Tested By:"]
[null,"2.36 mm","No. 8",{"$f":"IF('Data Entry'!F31=\"\",\"\",'Data Entry'!F31)","v":""},{"$f":"IF(D107=\"\",\"\",SUM(D104:D107))","v":""},"","","",null,"Wt Loose lb./c.f. (kg/m^3)",null,{"$f":"IF('Data Entry'!F$63=\"\",\"\",'Data Entry'!F$63)","v":""}]
[null,"2.00 mm","No. 10",{"$f":"IF('Data Entry'!F32=\"\",\"\",'Data Entry'!F32)","v":""},{"$f":"IF(D108=\"\",\"\",SUM(D104:D108))","v":""},"","","",null,"AASHTO T-19 Tested By:"]
[null,"1.18 mm","No. 16",{"$f":"IF('Data Entry'!F33=\"\",\"\",'Data Entry'!F33)","v":""},{"$f":"IF(D109=\"\",\"\",SUM(D104:D109))","v":""},"","","",null,"% Moisture",null,{"$f":"IF('Data Entry'!F$64=\"\",\"\",'Data Entry'!F$64)","v":""}]
[null,"600 um","No. 30",{"$f":"IF('Data Entry'!F34=\"\",\"\",'Data Entry'!F34)","v":""},{"$f":"IF(D110=\"\",\"\",SUM(D104:D110))","v":""},"","","",null,"ND T-255 Tested By:"]
[null,"425 um","No. 40",{"$f":"IF('Data Entry'!F35=\"\",\"\",'Data Entry'!F35)","v":""},{"$f":"IF(D111=\"\",\"\",SUM(D104:D111))","v":""},"","","",null,"L.A. Abration (Grad.) %Loss",null,{"$f":"IF('Data Entry'!F$59=\"\",\"\",'Data Entry'!F$59)","v":""}]
[null,"300 um","No. 50",{"$f":"IF('Data Entry'!F36=\"\",\"\",'Data Entry'!F36)","v":""},{"$f":"IF(D112=\"\",\"\",SUM(D104:D112))","v":""},"","","",null,"AASHTO T-96"]
[null,"150 um","No. 100",{"$f":"IF('Data Entry'!F37=\"\",\"\",'Data Entry'!F37)","v":""},{"$f":"IF(D113=\"\",\"\",SUM(D104:D113))","v":""},"","",""]
[null,"75 um","No. 200",{"$f":"IF('Data Entry'!F38=\"\",\"\",'Data Entry'!F38)","v":""},{"$f":"IF(D114=\"\",\"\",SUM(D104:D114))","v":""},"","",""]
[null,"Minus No. 200 (75 um)",null,{"$f":"IF('Data Entry'!F40=\"\",\"\",'Data Entry'!F40)","v":""},{"$f":"IF(D115=\"\",\"\",SUM(D104:D115))","v":""}]
[null,"Wt. After Wash",null,{"$f":"IF('Data Entry'!F42=\"\",\"\",'Data Entry'!F42)","v":""}]
[null,"Wt. Check",null,{"$f":"IF(D118=\"\",\"\",SUM(D104:D115))","v":""},{"$f":" IF(D116=\"\",\"\",((D116-D117)/D116)*100)","v":""},{"$f":"IF(D118=\"\",\"\",100-E117)","v":""},"%Error"]
[null,"Original Wt.",null,{"$f":"IF('Data Entry'!F41=\"\",\"\",'Data Entry'!F41)","v":""}]
[null,"ND T 27","Tested By: Initials"]
[null,"Fine Aggregate Properties"]
[null,"Lightweight pieces ND T-113:",null,{"$f":"IF('Data Entry'!F46=\"\",\"\",'Data Entry'!F46)","v":""}]
[null,"Coarse Aggregate Properties"]
[null,"Coarse wash ND T-11:"]
[null,"Dry weight before washing-",null,null,{"$f":"IF('Data Entry'!F48=\"\",\"\",'Data Entry'!F48)","v":""},null,"Note: If any test was not performed. Leave cell blank."]
[null,"Dry weight after washing-",null,null,{"$f":"IF('Data Entry'!F49=\"\",\"\",'Data Entry'!F49)","v":""}]
[null,"Material passing No. 200 Sieve%",null,null,{"$f":"IF(E124=\"\",\"\",((E124-E125)/E124)*100)","v":""}]
[null,"Plus #4 Fraction of coarse wash:",null,null,{"$f":"IF('Data Entry'!F50=\"\",\"\",'Data Entry'!F50)","v":""}]
[null,"Shale +#4:",{"$f":"IF('Data Entry'!F51=\"\",\"\",'Data Entry'!F51)","v":""},"Soft:",{"$f":"IF('Data Entry'!F54=\"\",\"\",'Data Entry'!F54)","v":""},"Lignite/Coal:",{"$f":"IF('Data Entry'!F53=\"\",\"\",'Data Entry'!F53)","v":""}]
[null,"Iron:",{"$f":"IF('Data Entry'!F52=\"\",\"\",'Data Entry'!F52)","v":""},"Thin/Elong:",{"$f":"IF('Data Entry'!F55=\"\",\"\",'Data Entry'!F55)","v":""}]
[]
[null,"Fine Agg. #1"]
[null,"Material Type:",{"$f":"IF('Data Entry'!G15=\"\",\"\",'Data Entry'!G15)","v":""},"Pit Location:",{"$f":"IF('Data Entry'!G17=\"\",\"\",'Data Entry'!G17)","v":""},null,"% Blend:",{"$f":"IF('Data Entry'!G19=\"\",\"\",'Data Entry'!G19)","v":""},null,"Soundness % Loss",null,{"$f":"IF('Data Entry'!G$57=\"\",\"\",'Data Entry'!G$57)","v":""}]
[null,"Sampled From:",{"$f":"IF('Data Entry'!G16=\"\",\"\",'Data Entry'!G16)","v":""},"Pit Owner",{"$f":"IF('Data Entry'!G18=\"\",\"\",'Data Entry'!G18)","v":""},null,"If this is only material, make blend 100",null,null,"AASHTO T-104 Tested By:"]
[null,"Sieve Size",null,"Wt. Ret.",null,"% Ret. Non-Cum.","% Ret. Cum.","% Pass",null,"Specific Gravity",null,{"$f":"IF('Data Entry'!G$58=\"\",\"\",'Data Entry'!G$58)","v":""}]
[null,null,null,"Non-Cum.","Cum.",null,null,null,null,"ND T-85 Tested By:"]
[null,"9.5 mm","3/8\"",{"$f":"IF('Data Entry'!G29=\"\",\"\",'Data Entry'!G29)","v":""},{"$f":"IF(D136=\"\",\"\",SUM(D136:D136))","v":""},{"$f":"IF(D136=\"\",\"\",IF((D136/$D$149)*100*10-INT((D136/$D$149)*100*10)<0.5,ROUNDDOWN((D136/$D$149)*100,1),IF((D136/$D$149)*100*10-INT((D136/$D$149)*100*10)>0.5,ROUNDUP((D136/$D$149)*100,1),IF((D136/$D$149)*100*10-INT((D136/$D$149)*100*10)=0.5,IF(MOD(INT((D136/$D$149)*100*10),2)=0,ROUNDDOWN((D136/$D$149)*100,1),ROUNDUP((D136/$D$149)*100,1))))))","v":""},{"$f":"IF(E136=\"\",\"\",IF((E136/$D$149)*100*10-INT((E136/$D$149)*100*10)<0.5,ROUNDDOWN((E136/$D$149)*100,1),IF((E136/$D$149)*100*10-INT((E136/$D$149)*100*10)>0.5,ROUNDUP((E136/$D$149)*100,1),IF((E136/$D$149)*100*10-INT((E136/$D$149)*100*10)=0.5,IF(MOD(INT((E136/$D$149)*100*10),2)=0,ROUNDDOWN((E136/$D$149)*100,1),ROUNDUP((E136/$D$149)*100,1))))))","v":""},{"$f":"IF(D136=\"\",\"\",100-G136)","v":""},null,"% Absorbtion",null,{"$f":"IF('Data Entry'!G$60=\"\",\"\",'Data Entry'!G$60)","v":""}]
[null,"4.75 mm","No. 4",{"$f":"IF('Data Entry'!G30=\"\",\"\",'Data Entry'!G30)","v":""},{"$f":"IF(D137=\"\",\"\",SUM(D136:D137))","v":""},{"$f":"IF(D137=\"\",\"\",IF((D137/$D$149)*100*10-INT((D137/$D$149)*100*10)<0.5,ROUNDDOWN((D137/$D$149)*100,1),IF((D137/$D$149)*100*10-INT((D137/$D$149)*100*10)>0.5,ROUNDUP((D137/$D$149)*100,1),IF((D137/$D$149)*100*10-INT((D137/$D$149)*100*10)=0.5,IF(MOD(INT((D137/$D$149)*100*10),2)=0,ROUNDDOWN((D137/$D$149)*100,1),ROUNDUP((D137/$D$149)*100,1))))))","v":""},"","",null,"Color",null,{"$f":"IF('Data Entry'!G$61=\"\",\"\",'Data Entry'!G$61)","v":""}]
[null,"2.36 mm","No. 8",{"$f":"IF('Data Entry'!G31=\"\",\"\",'Data Entry'!G31)","v":""},{"$f":"IF(D138=\"\",\"\",SUM(D136:D138))","v":""},"","","",null,"AAASHTO T-21 Tested By:"]
[null,"2.00 mm","No. 10",{"$f":"IF('Data Entry'!G32=\"\",\"\",'Data Entry'!G32)","v":""},{"$f":"IF(D139=\"\",\"\",SUM(D136:D139))","v":""},"","","",null,"Wt Loose lb./c.f. (kg/m^3)",null,{"$f":"IF('Data Entry'!G$63=\"\",\"\",'Data Entry'!G$63)","v":""}]
[null,"1.18 mm","No. 16",{"$f":"IF('Data Entry'!G33=\"\",\"\",'Data Entry'!G33)","v":""},{"$f":"IF(D140=\"\",\"\",SUM(D136:D140))","v":""},"","","",null,"AASHTO T-19 Tested By:"]
[null,"600 um","No. 30",{"$f":"IF('Data Entry'!G34=\"\",\"\",'Data Entry'!G34)","v":""},{"$f":"IF(D141=\"\",\"\",SUM(D136:D141))","v":""},"","","",null,"% Moisture",null,{"$f":"IF('Data Entry'!G$64=\"\",\"\",'Data Entry'!G$64)","v":""}]
[null,"425 um","No. 40",{"$f":"IF('Data Entry'!G35=\"\",\"\",'Data Entry'!G35)","v":""},{"$f":"IF(D142=\"\",\"\",SUM(D136:D142))","v":""},"","","",null,"ND T-255 Tested By:"]
[null,"300 um","No. 50",{"$f":"IF('Data Entry'!G36=\"\",\"\",'Data Entry'!G36)","v":""},{"$f":"IF(D143=\"\",\"\",SUM(D136:D143))","v":""},"","",""]
[null,"150 um","No. 100",{"$f":"IF('Data Entry'!G37=\"\",\"\",'Data Entry'!G37)","v":""},{"$f":"IF(D144=\"\",\"\",SUM(D136:D144))","v":""},"","",""]
[null,"75 um","No. 200",{"$f":"IF('Data Entry'!G38=\"\",\"\",'Data Entry'!G38)","v":""},{"$f":"IF(D145=\"\",\"\",SUM(D136:D145))","v":""},"","",""]
[null,"Minus No. 200 (75 um)",null,{"$f":"IF('Data Entry'!G40=\"\",\"\",'Data Entry'!G40)","v":""},{"$f":"IF(D146=\"\",\"\",SUM(D136:D146))","v":""},null,"Note: If any test was not performed. Leave cell blank."]
[null,"Wt. After Wash",null,{"$f":"IF('Data Entry'!G42=\"\",\"\",'Data Entry'!G42)","v":""}]
[null,"Wt. Check",null,{"$f":"IF(D149=\"\",\"\",SUM(D136:D146))","v":""},{"$f":" IF(D147=\"\",\"\",((D147-D148)/D147)*100)","v":""},{"$f":"IF(D149=\"\",\"\",100-E148)","v":""},"%Error"]
[null,"Original Wt.",null,{"$f":"IF('Data Entry'!G41=\"\",\"\",'Data Entry'!G41)","v":""}]
[null,"ND T 27","Tested By: Initials"]
[null,"Fine Aggregate Properties"]
[null,"Lightweight pieces ND T-113:",null,{"$f":"IF('Data Entry'!G46=\"\",\"\",'Data Entry'!G46)","v":""}]
[]
[null,"Fine Agg. #2"]
[null,"Material Type:",{"$f":"IF('Data Entry'!H15=\"\",\"\",'Data Entry'!H15)","v":""},"Pit Location:",{"$f":"IF('Data Entry'!H17=\"\",\"\",'Data Entry'!H17)","v":""},null,"% Blend:",{"$f":"IF('Data Entry'!H19=\"\",\"\",'Data Entry'!H19)","v":""},null,"Soundness % Loss",null,{"$f":"IF('Data Entry'!H$57=\"\",\"\",'Data Entry'!H$57)","v":""}]
[null,"Sampled From:",{"$f":"IF('Data Entry'!H16=\"\",\"\",'Data Entry'!H16)","v":""},"Pit Owner",{"$f":"IF('Data Entry'!H18=\"\",\"\",'Data Entry'!H18)","v":""},null,"If this is only material, make blend 100",null,null,"AASHTO T-104 Tested By:"]
[null,"Sieve Size",null,"Wt. Ret.",null,"% Ret. Non-Cum.","% Ret. Cum.","% Pass",null,"Specific Gravity",null,{"$f":"IF('Data Entry'!H$58=\"\",\"\",'Data Entry'!H$58)","v":""}]
[null,null,null,"Non-Cum.","Cum.",null,null,null,null,"ND T-85 Tested By:"]
[null,"9.5 mm","3/8\"",{"$f":"IF('Data Entry'!H29=\"\",\"\",'Data Entry'!H29)","v":""},{"$f":"IF(D159=\"\",\"\",SUM(D159:D159))","v":""},{"$f":"IF(D159=\"\",\"\",IF((D159/$D$172)*100*10-INT((D159/$D$172)*100*10)<0.5,ROUNDDOWN((D159/$D$172)*100,1),IF((D159/$D$172)*100*10-INT((D159/$D$172)*100*10)>0.5,ROUNDUP((D159/$D$172)*100,1),IF((D159/$D$172)*100*10-INT((D159/$D$172)*100*10)=0.5,IF(MOD(INT((D159/$D$172)*100*10),2)=0,ROUNDDOWN((D159/$D$172)*100,1),ROUNDUP((D159/$D$172)*100,1))))))","v":""},{"$f":"IF(E159=\"\",\"\",IF((E159/$D$172)*100*10-INT((E159/$D$172)*100*10)<0.5,ROUNDDOWN((E159/$D$172)*100,1),IF((E159/$D$172)*100*10-INT((E159/$D$172)*100*10)>0.5,ROUNDUP((E159/$D$172)*100,1),IF((E159/$D$172)*100*10-INT((E159/$D$172)*100*10)=0.5,IF(MOD(INT((E159/$D$172)*100*10),2)=0,ROUNDDOWN((E159/$D$172)*100,1),ROUNDUP((E159/$D$172)*100,1))))))","v":""},{"$f":"IF(D159=\"\",\"\",100-G159)","v":""},null,"% Absorbtion",null,{"$f":"IF('Data Entry'!H$60=\"\",\"\",'Data Entry'!H$60)","v":""}]
[null,"4.75 mm","No. 4",{"$f":"IF('Data Entry'!H30=\"\",\"\",'Data Entry'!H30)","v":""},{"$f":"IF(D160=\"\",\"\",SUM(D159:D160))","v":""},{"$f":"IF(D160=\"\",\"\",IF((D160/$D$172)*100*10-INT((D160/$D$172)*100*10)<0.5,ROUNDDOWN((D160/$D$172)*100,1),IF((D160/$D$172)*100*10-INT((D160/$D$172)*100*10)>0.5,ROUNDUP((D160/$D$172)*100,1),IF((D160/$D$172)*100*10-INT((D160/$D$172)*100*10)=0.5,IF(MOD(INT((D160/$D$172)*100*10),2)=0,ROUNDDOWN((D160/$D$172)*100,1),ROUNDUP((D160/$D$172)*100,1))))))","v":""},"",{"$f":"IF(D160=\"\",\"\",100-G160)","v":""},null,"Color",null,{"$f":"IF('Data Entry'!H$61=\"\",\"\",'Data Entry'!H$61)","v":""}]
[null,"2.36 mm","No. 8",{"$f":"IF('Data Entry'!H31=\"\",\"\",'Data Entry'!H31)","v":""},{"$f":"IF(D161=\"\",\"\",SUM(D159:D161))","v":""},"","","",null,"AAASHTO T-21 Tested By:"]
[null,"2.00 mm","No. 10",{"$f":"IF('Data Entry'!H32=\"\",\"\",'Data Entry'!H32)","v":""},{"$f":"IF(D162=\"\",\"\",SUM(D159:D162))","v":""},"","","",null,"Wt Loose lb./c.f. (kg/m^3)",null,{"$f":"IF('Data Entry'!H$63=\"\",\"\",'Data Entry'!H$63)","v":""}]
[null,"1.18 mm","No. 16",{"$f":"IF('Data Entry'!H33=\"\",\"\",'Data Entry'!H33)","v":""},{"$f":"IF(D163=\"\",\"\",SUM(D159:D163))","v":""},"","","",null,"AASHTO T-19 Tested By:"]
[null,"600 um","No. 30",{"$f":"IF('Data Entry'!H34=\"\",\"\",'Data Entry'!H34)","v":""},{"$f":"IF(D164=\"\",\"\",SUM(D159:D164))","v":""},"","","",null,"% Moisture",null,{"$f":"IF('Data Entry'!H$64=\"\",\"\",'Data Entry'!H$64)","v":""}]
[null,"425 um","No. 40",{"$f":"IF('Data Entry'!H35=\"\",\"\",'Data Entry'!H35)","v":""},{"$f":"IF(D165=\"\",\"\",SUM(D159:D165))","v":""},"","","",null,"ND T-255 Tested By:"]
[null,"300 um","No. 50",{"$f":"IF('Data Entry'!H36=\"\",\"\",'Data Entry'!H36)","v":""},{"$f":"IF(D166=\"\",\"\",SUM(D159:D166))","v":""},"","",""]
[null,"150 um","No. 100",{"$f":"IF('Data Entry'!H37=\"\",\"\",'Data Entry'!H37)","v":""},{"$f":"IF(D167=\"\",\"\",SUM(D159:D167))","v":""},"","",""]
[null,"75 um","No. 200",{"$f":"IF('Data Entry'!H38=\"\",\"\",'Data Entry'!H38)","v":""},{"$f":"IF(D168=\"\",\"\",SUM(D159:D168))","v":""},"","",""]
[null,"Minus No. 200 (75 um)",null,{"$f":"IF('Data Entry'!H40=\"\",\"\",'Data Entry'!H40)","v":""},{"$f":"IF(D169=\"\",\"\",SUM(D159:D169))","v":""},null,"Note: If any test was not performed. Leave cell blank."]
[null,"Wt. After Wash",null,{"$f":"IF('Data Entry'!H42=\"\",\"\",'Data Entry'!H42)","v":""}]
[null,"Wt. Check",null,{"$f":"IF(D172=\"\",\"\",SUM(D159:D169))","v":""},{"$f":" IF(D170=\"\",\"\",((D170-D171)/D170)*100)","v":""},{"$f":"IF(D172=\"\",\"\",100-E171)","v":""},"%Error"]
[null,"Original Wt.",null,{"$f":"IF('Data Entry'!H41=\"\",\"\",'Data Entry'!H41)","v":""}]
[null,"ND T 27","Tested By: Initials"]
[null,"Fine Aggregate Properties"]
[null,"Lightweight pieces ND T-113:",null,{"$f":"IF('Data Entry'!H46=\"\",\"\",'Data Entry'!H46)","v":""}]

{"sheet":"Print Sheet","index":2,"n_rows":69,"n_cols":19,"rows_kept":69,"cut":false,"hidden":false,"merged":[[16,1,17,2],[16,5,17,6],[16,7,17,8],[16,9,17,10],[16,11,17,12],[16,13,17,14],[68,6,68,9],[68,10,68,12],[41,7,42,8],[41,9,42,10],[45,13,45,14],[46,13,46,14],[48,13,48,14],[49,13,49,14],[50,13,50,14],[52,11,52,12],[53,11,53,12],[54,11,54,12],[49,11,49,12],[50,11,50,12],[51,11,51,12],[50,9,50,10],[51,9,51,10],[43,1,44,2],[68,15,68,16],[68,17,68,18],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[66,10,66,12],[66,17,66,18],[58,1,62,18],[63,10,63,12],[64,10,64,12],[65,10,65,12],[67,10,67,12],[63,6,63,9],[64,6,64,9],[63,17,63,18],[64,17,64,18],[65,17,65,18],[67,17,67,18],[63,15,63,16],[64,15,64,16],[65,15,65,16],[37,13,37,14],[38,13,38,14],[39,13,39,14],[40,13,40,14],[41,13,41,14],[42,13,42,14],[41,18,42,18],[43,18,44,18],[43,3,44,4],[43,5,44,6],[43,7,44,8],[43,9,44,10],[43,11,44,12],[43,13,44,14],[41,3,42,4],[41,5,42,6],[67,15,67,16],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[65,6,65,9],[67,6,67,9],[51,13,51,14],[52,13,52,14],[53,13,53,14],[54,13,54,14],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[55,1,55,2],[45,11,45,12],[46,11,46,12],[48,11,48,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[54,5,54,6],[54,7,54,8],[45,9,45,10],[46,9,46,10],[48,9,48,10],[49,9,49,10],[50,7,50,8],[51,7,51,8],[52,7,52,8],[53,7,53,8],[51,5,51,6],[52,5,52,6],[53,5,53,6],[45,7,45,8],[46,7,46,8],[48,7,48,8],[49,7,49,8],[50,5,50,6],[52,9,52,10],[53,9,53,10],[54,9,54,10],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[45,5,45,6],[46,5,46,6],[48,5,48,6],[49,5,49,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[45,3,45,4],[46,3,46,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[52,1,52,2],[53,1,53,2],[54,1,54,2],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[45,1,45,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[39,1,39,2],[40,1,40,2],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[41,1,42,2],[34,13,34,14],[35,13,35,14],[36,1,36,18],[19,17,20,17],[37,1,37,2],[38,1,38,2],[37,11,37,12],[38,11,38,12],[28,13,28,14],[29,13,29,14],[30,13,30,14],[31,13,31,14],[32,13,32,14],[33,13,33,14],[33,11,33,12],[34,11,34,12],[35,11,35,12],[21,13,21,14],[22,13,22,14],[23,13,23,14],[24,13,24,14],[25,13,25,14],[26,13,26,14],[27,13,27,14],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[35,7,35,8],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[27,7,27,8],[28,7,28,8],[27,5,27,6],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[34,5,34,6],[35,5,35,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[19,16,20,16],[19,18,20,18],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[19,11,20,12],[19,13,20,14],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[19,7,20,8],[19,9,20,10],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[1,1,1,18],[2,1,2,18],[3,1,3,18],[4,1,4,2],[5,1,5,2],[11,13,11,14],[12,13,12,14],[11,11,11,12],[12,11,12,12],[12,1,12,2],[4,8,4,9],[5,8,5,9],[6,1,6,2],[11,7,11,8],[12,7,12,8],[8,1,8,18],[11,3,11,4],[12,3,12,4],[4,10,4,11],[14,11,14,12],[6,8,6,9],[13,7,13,8],[14,7,14,8],[15,7,15,8],[13,3,13,4],[14,3,14,4],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[19,1,20,1],[19,3,20,4],[19,5,20,6],[43,15,44,15],[41,15,42,15],[13,1,13,2],[14,1,14,2],[15,1,15,2],[15,13,15,14],[15,11,15,12],[19,15,20,15],[16,3,17,4],[15,3,15,4],[15,9,15,10],[15,5,15,6],[26,3,26,4],[26,7,26,8],[33,3,33,4],[34,3,34,4],[35,3,35,4],[26,5,26,6],[13,13,13,14],[14,13,14,14],[13,11,13,12]]}
[]
[null,{"$f":"IF(Calculation!S2=\"\",\"\",Calculation!S2)","v":"Optimized Concrete Aggregate Gradation Report"}]
[null,{"$f":"IF(Calculation!S3=\"\",\"\",Calculation!S3)","v":"NDDOT Field Testing Laboratory"}]
[null,{"$f":"IF(Calculation!S4=\"\",\"\",Calculation!S4)","v":""}]
[null,{"$f":"IF(Calculation!S5=\"\",\"\",Calculation!S5)","v":"Project Number:"},null,{"$f":"IF(Calculation!U5=\"\",\"\",Calculation!U5)","v":""},null,null,null,null,{"$f":"IF(Calculation!Z5=\"\",\"\",Calculation!Z5)","v":"Date:"},null,{"$f":"IF(Calculation!AB5=\"\",\"\",Calculation!AB5)","v":""}]
[null,{"$f":"IF(Calculation!S6=\"\",\"\",Calculation!S6)","v":"PCN:"},null,{"$f":"IF(Calculation!U6=\"\",\"\",Calculation!U6)","v":""},null,null,null,null,{"$f":"IF(Calculation!Z6=\"\",\"\",Calculation!Z6)","v":"Material:"},null,{"$f":"IF(Calculation!AB6=\"\",\"\",Calculation!AB6)","v":""}]
[null,{"$f":"IF(Calculation!S7=\"\",\"\",Calculation!S7)","v":"Sample Number:"},null,{"$f":"IF(Calculation!U7=\"\",\"\",Calculation!U7)","v":""},null,null,null,null,{"$f":"IF(Calculation!Z7=\"\",\"\",Calculation!Z7)","v":"Sampled By:"},null,{"$f":"IF(Calculation!AB7=\"\",\"\",Calculation!AB7)","v":""}]
[null,{"$f":"IF(Calculation!S8=\"\",\"\",Calculation!S8)","v":""},null,{"$f":"IF(Calculation!U8=\"\",\"\",Calculation!U8)","v":""},null,null,null,null,{"$f":"IF(Calculation!Z8=\"\",\"\",Calculation!Z8)","v":""},null,{"$f":"IF(Calculation!AB8=\"\",\"\",Calculation!AB8)","v":""}]
[null,{"$f":"IF(Calculation!S9=\"\",\"\",Calculation!S9)","v":"Aggregate Gradations"}]
[null,{"$f":"IF(Calculation!S10=\"\",\"\",Calculation!S10)","v":""},null,{"$f":"IF(Calculation!U10=\"\",\"\",Calculation!U10)","v":""},null,{"$f":"IF(Calculation!W10=\"\",\"\",Calculation!W10)","v":""},{"$f":"IF(Calculation!X10=\"\",\"\",Calculation!X10)","v":""},{"$f":"IF(Calculation!Y10=\"\",\"\",Calculation!Y10)","v":""},{"$f":"IF(Calculation!Z10=\"\",\"\",Calculation!Z10)","v":""},{"$f":"IF(Calculation!AA10=\"\",\"\",Calculation!AA10)","v":""},{"$f":"IF(Calculation!AB10=\"\",\"\",Calculation!AB10)","v":""}]
[null,{"$f":"IF(Calculation!S11=\"\",\"\",Calculation!S11)","v":""},null,{"$f":"IF(Calculation!U11=\"\",\"\",Calculation!U11)","v":""},null,{"$f":"IF(Calculation!W11=\"\",\"\",Calculation!W11)","v":""},{"$f":"IF(Calculation!X11=\"\",\"\",Calculation!X11)","v":""},{"$f":"IF(Calculation!Y11=\"\",\"\",Calculation!Y11)","v":""},{"$f":"IF(Calculation!Z11=\"\",\"\",Calculation!Z11)","v":""},{"$f":"IF(Calculation!AA11=\"\",\"\",Calculation!AA11)","v":""},{"$f":"IF(Calculation!AB11=\"\",\"\",Calculation!AB11)","v":""},{"$f":"IF(Calculation!AC11=\"\",\"\",Calculation!AC11)","v":""},{"$f":"IF(Calculation!AD11=\"\",\"\",Calculation!AD11)","v":""},{"$f":"IF(Calculation!AE11=\"\",\"\",Calculation!AE11)","v":""},{"$f":"IF(Calculation!AF11=\"\",\"\",Calculation!AF11)","v":""},{"$f":"IF(Calculation!AG11=\"\",\"\",Calculation!AG11)","v":""},{"$f":"IF(Calculation!AH11=\"\",\"\",Calculation!AH11)","v":""},{"$f":"IF(Calculation!AI11=\"\",\"\",Calculation!AI11)","v":""},{"$f":"IF(Calculation!AJ11=\"\",\"\",Calculation!AJ11)","v":""}]
[null,{"$f":"IF(Calculation!S12=\"\",\"\",Calculation!S12)","v":""},null,{"$f":"IF(Calculation!U12=\"\",\"\",Calculation!U12)","v":"Course Agg. #1"},null,{"$f":"IF(Calculation!W12=\"\",\"\",Calculation!W12)","v":"Course Agg. #2"},null,{"$f":"IF(Calculation!Y12=\"\",\"\",Calculation!Y12)","v":"Intermediate Agg. #1"},null,{"$f":"IF(Calculation!AA12=\"\",\"\",Calculation!AA12)","v":"Intermediate Agg. #2"},null,{"$f":"IF(Calculation!AC12=\"\",\"\",Calculation!AC12)","v":"Fine Agg. #1"},null,{"$f":"IF(Calculation!AE12=\"\",\"\",Calculation!AE12)","v":"Fine Agg. #2"},null,{"$f":"IF(Calculation!AG12=\"\",\"\",Calculation!AG12)","v":"Combined"},{"$f":"IF(Calculation!AH12=\"\",\"\",Calculation!AH12)","v":""},{"$f":"IF(Calculation!AI12=\"\",\"\",Calculation!AI12)","v":""},{"$f":"IF(Calculation!AJ12=\"\",\"\",Calculation!AJ12)","v":"ND Spec."}]
[null,{"$f":"IF(Calculation!S13=\"\",\"\",Calculation!S13)","v":"% Blend"},null,{"$f":"IF(Calculation!U13=\"\",\"\",Calculation!U13)","v":""},null,{"$f":"IF(Calculation!W13=\"\",\"\",Calculation!W13)","v":""},null,{"$f":"IF(Calculation!Y13=\"\",\"\",Calculation!Y13)","v":""},null,{"$f":"IF(Calculation!AA13=\"\",\"\",Calculation!AA13)","v":""},null,{"$f":"IF(Calculation!AC13=\"\",\"\",Calculation!AC13)","v":""},null,{"$f":"IF(Calculation!AE13=\"\",\"\",Calculation!AE13)","v":""},null,{"$f":"IF(Calculation!AG13=\"\",\"\",Calculation!AG13)","v":""},{"$f":"IF(Calculation!AH13=\"\",\"\",Calculation!AH13)","v":""},{"$f":"IF(Calculation!AI13=\"\",\"\",Calculation!AI13)","v":""}]
[null,{"$f":"IF(Calculation!S14=\"\",\"\",Calculation!S14)","v":"Material :"},null,{"$f":"IF(Calculation!U14=\"\",\"\",Calculation!U14)","v":""},null,{"$f":"IF(Calculation!W14=\"\",\"\",Calculation!W14)","v":""},null,{"$f":"IF(Calculation!Y14=\"\",\"\",Calculation!Y14)","v":""},null,{"$f":"IF(Calculation!AA14=\"\",\"\",Calculation!AA14)","v":""},null,{"$f":"IF(Calculation!AC14=\"\",\"\",Calculation!AC14)","v":""},null,{"$f":"IF(Calculation!AE14=\"\",\"\",Calculation!AE14)","v":""},null,{"$f":"IF(Calculation!AG14=\"\",\"\",Calculation!AG14)","v":""},{"$f":"IF(Calculation!AH14=\"\",\"\",Calculation!AH14)","v":""},{"$f":"IF(Calculation!AI14=\"\",\"\",Calculation!AI14)","v":""},{"$f":"IF(Calculation!AJ14=\"\",\"\",Calculation!AJ14)","v":""}]
[null,{"$f":"IF(Calculation!S15=\"\",\"\",Calculation!S15)","v":"Sampled From:"},null,{"$f":"IF(Calculation!U15=\"\",\"\",Calculation!U15)","v":""},null,{"$f":"IF(Calculation!W15=\"\",\"\",Calculation!W15)","v":""},null,{"$f":"IF(Calculation!Y15=\"\",\"\",Calculation!Y15)","v":""},null,{"$f":"IF(Calculation!AA15=\"\",\"\",Calculation!AA15)","v":""},null,{"$f":"IF(Calculation!AC15=\"\",\"\",Calculation!AC15)","v":""},null,{"$f":"IF(Calculation!AE15=\"\",\"\",Calculation!AE15)","v":""},null,{"$f":"IF(Calculation!AG15=\"\",\"\",Calculation!AG15)","v":""},{"$f":"IF(Calculation!AH15=\"\",\"\",Calculation!AH15)","v":""},{"$f":"IF(Calculation!AI15=\"\",\"\",Calculation!AI15)","v":""},{"$f":"IF(Calculation!AJ15=\"\",\"\",Calculation!AJ15)","v":""}]
[null,{"$f":"IF(Calculation!S16=\"\",\"\",Calculation!S16)","v":"Pit Location:"},null,{"$f":"IF(Calculation!U16=\"\",\"\",Calculation!U16)","v":""},null,{"$f":"IF(Calculation!W16=\"\",\"\",Calculation!W16)","v":""},null,{"$f":"IF(Calculation!Y16=\"\",\"\",Calculation!Y16)","v":""},null,{"$f":"IF(Calculation!AA16=\"\",\"\",Calculation!AA16)","v":""},null,{"$f":"IF(Calculation!AC16=\"\",\"\",Calculation!AC16)","v":""},null,{"$f":"IF(Calculation!AE16=\"\",\"\",Calculation!AE16)","v":""},null,{"$f":"IF(Calculation!AG16=\"\",\"\",Calculation!AG16)","v":""},{"$f":"IF(Calculation!AH16=\"\",\"\",Calculation!AH16)","v":""},{"$f":"IF(Calculation!AI16=\"\",\"\",Calculation!AI16)","v":""},{"$f":"IF(Calculation!AJ16=\"\",\"\",Calculation!AJ16)","v":""}]
[null,{"$f":"IF(Calculation!S17=\"\",\"\",Calculation!S17)","v":"Pit Owner:"},null,{"$f":"IF(Calculation!U17=\"\",\"\",Calculation!U17)","v":""},null,{"$f":"IF(Calculation!W17=\"\",\"\",Calculation!W17)","v":""},null,{"$f":"IF(Calculation!Y17=\"\",\"\",Calculation!Y17)","v":""},null,{"$f":"IF(Calculation!AA17=\"\",\"\",Calculation!AA17)","v":""},null,{"$f":"IF(Calculation!AC17=\"\",\"\",Calculation!AC17)","v":""},null,{"$f":"IF(Calculation!AE17=\"\",\"\",Calculation!AE17)","v":""},null,{"$f":"IF(Calculation!AG17=\"\",\"\",Calculation!AG17)","v":""},{"$f":"IF(Calculation!AH17=\"\",\"\",Calculation!AH17)","v":""},{"$f":"IF(Calculation!AI17=\"\",\"\",Calculation!AI17)","v":""},{"$f":"IF(Calculation!AJ17=\"\",\"\",Calculation!AJ17)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Calculation!AG18=\"\",\"\",Calculation!AG18)","v":""},{"$f":"IF(Calculation!AH18=\"\",\"\",Calculation!AH18)","v":""},{"$f":"IF(Calculation!AI18=\"\",\"\",Calculation!AI18)","v":""},{"$f":"IF(Calculation!AJ18=\"\",\"\",Calculation!AJ18)","v":""}]
[null,{"$f":"IF(Calculation!S19=\"\",\"\",Calculation!S19)","v":""},null,{"$f":"IF(Calculation!U19=\"\",\"\",Calculation!U19)","v":""},null,{"$f":"IF(Calculation!W19=\"\",\"\",Calculation!W19)","v":""},{"$f":"IF(Calculation!X19=\"\",\"\",Calculation!X19)","v":""},{"$f":"IF(Calculation!Y19=\"\",\"\",Calculation!Y19)","v":""},{"$f":"IF(Calculation!Z19=\"\",\"\",Calculation!Z19)","v":""},{"$f":"IF(Calculation!AA19=\"\",\"\",Calculation!AA19)","v":""},{"$f":"IF(Calculation!AB19=\"\",\"\",Calculation!AB19)","v":""},{"$f":"IF(Calculation!AC19=\"\",\"\",Calculation!AC19)","v":""},{"$f":"IF(Calculation!AD19=\"\",\"\",Calculation!AD19)","v":""},{"$f":"IF(Calculation!AE19=\"\",\"\",Calculation!AE19)","v":""},{"$f":"IF(Calculation!AF19=\"\",\"\",Calculation!AF19)","v":""},{"$f":"IF(Calculation!AG19=\"\",\"\",Calculation!AG19)","v":""},{"$f":"IF(Calculation!AH19=\"\",\"\",Calculation!AH19)","v":""},{"$f":"IF(Calculation!AI19=\"\",\"\",Calculation!AI19)","v":""},{"$f":"IF(Calculation!AJ19=\"\",\"\",Calculation!AJ19)","v":""}]
[null,{"$f":"IF(Calculation!S20=\"\",\"\",Calculation!S20)","v":"Sieve \nSize"},null,{"$f":"IF(Calculation!U20=\"\",\"\",Calculation!U20)","v":"% Passing"},null,{"$f":"IF(Calculation!W20=\"\",\"\",Calculation!W20)","v":"% Passing"},null,{"$f":"IF(Calculation!Y20=\"\",\"\",Calculation!Y20)","v":"% Passing"},null,{"$f":"IF(Calculation!AA20=\"\",\"\",Calculation!AA20)","v":"% Passing"},null,{"$f":"IF(Calculation!AC20=\"\",\"\",Calculation!AC20)","v":"% Passing"},null,{"$f":"IF(Calculation!AE20=\"\",\"\",Calculation!AE20)","v":"% Passing"},null,{"$f":"IF(Calculation!AG20=\"\",\"\",Calculation!AG20)","v":"% Passing"},{"$f":"IF(Calculation!AH20=\"\",\"\",Calculation!AH20)","v":"% Retained"},{"$f":"IF(Calculation!AI20=\"\",\"\",Calculation!AI20)","v":"Pass or Fail"},{"$f":"IF(Calculation!AJ20=\"\",\"\",Calculation!AJ20)","v":"% Retained"}]
[]
[null,{"$f":"IF(Calculation!S22=\"\",\"\",Calculation!S22)","v":"2\""},null,{"$f":"IF(Calculation!U22=\"\",\"\",Calculation!U22)","v":""},null,{"$f":"IF(Calculation!W22=\"\",\"\",Calculation!W22)","v":""},null,{"$f":"IF(Calculation!Y22=\"\",\"\",Calculation!Y22)","v":""},null,{"$f":"IF(Calculation!AA22=\"\",\"\",Calculation!AA22)","v":""},null,{"$f":"IF(Calculation!AC22=\"\",\"\",Calculation!AC22)","v":""},null,{"$f":"IF(Calculation!AE22=\"\",\"\",Calculation!AE22)","v":""},null,{"$f":"IF(Calculation!AG22=\"\",\"\",Calculation!AG22)","v":""},{"$f":"IF(Calculation!AH22=\"\",\"\",Calculation!AH22)","v":""},{"$f":"IF(Calculation!AI22=\"\",\"\",Calculation!AI22)","v":""},{"$f":"IF(Calculation!AJ22=\"\",\"\",Calculation!AJ22)","v":0}]
[null,{"$f":"IF(Calculation!S23=\"\",\"\",Calculation!S23)","v":"1 1/2\""},null,{"$f":"IF(Calculation!U23=\"\",\"\",Calculation!U23)","v":""},null,{"$f":"IF(Calculation!W23=\"\",\"\",Calculation!W23)","v":""},null,{"$f":"IF(Calculation!Y23=\"\",\"\",Calculation!Y23)","v":""},null,{"$f":"IF(Calculation!AA23=\"\",\"\",Calculation!AA23)","v":""},null,{"$f":"IF(Calculation!AC23=\"\",\"\",Calculation!AC23)","v":""},null,{"$f":"IF(Calculation!AE23=\"\",\"\",Calculation!AE23)","v":""},null,{"$f":"IF(Calculation!AG23=\"\",\"\",Calculation!AG23)","v":""},{"$f":"IF(Calculation!AH23=\"\",\"\",Calculation!AH23)","v":""},{"$f":"IF(Calculation!AI23=\"\",\"\",Calculation!AI23)","v":""},{"$f":"IF(Calculation!AJ23=\"\",\"\",Calculation!AJ23)","v":"≤5"}]
[null,{"$f":"IF(Calculation!S24=\"\",\"\",Calculation!S24)","v":"1 1/4\""},null,{"$f":"IF(Calculation!U24=\"\",\"\",Calculation!U24)","v":""},null,{"$f":"IF(Calculation!W24=\"\",\"\",Calculation!W24)","v":""},null,{"$f":"IF(Calculation!Y24=\"\",\"\",Calculation!Y24)","v":""},null,{"$f":"IF(Calculation!AA24=\"\",\"\",Calculation!AA24)","v":""},null,{"$f":"IF(Calculation!AC24=\"\",\"\",Calculation!AC24)","v":""},null,{"$f":"IF(Calculation!AE24=\"\",\"\",Calculation!AE24)","v":""},null,{"$f":"IF(Calculation!AG24=\"\",\"\",Calculation!AG24)","v":""},{"$f":"IF(Calculation!AH24=\"\",\"\",Calculation!AH24)","v":""},{"$f":"IF(Calculation!AI24=\"\",\"\",Calculation!AI24)","v":""},{"$f":"IF(Calculation!AJ24=\"\",\"\",Calculation!AJ24)","v":""}]
[null,{"$f":"IF(Calculation!S25=\"\",\"\",Calculation!S25)","v":"1\""},null,{"$f":"IF(Calculation!U25=\"\",\"\",Calculation!U25)","v":""},null,{"$f":"IF(Calculation!W25=\"\",\"\",Calculation!W25)","v":""},null,{"$f":"IF(Calculation!Y25=\"\",\"\",Calculation!Y25)","v":""},null,{"$f":"IF(Calculation!AA25=\"\",\"\",Calculation!AA25)","v":""},null,{"$f":"IF(Calculation!AC25=\"\",\"\",Calculation!AC25)","v":""},null,{"$f":"IF(Calculation!AE25=\"\",\"\",Calculation!AE25)","v":""},null,{"$f":"IF(Calculation!AG25=\"\",\"\",Calculation!AG25)","v":""},{"$f":"IF(Calculation!AH25=\"\",\"\",Calculation!AH25)","v":""},{"$f":"IF(Calculation!AI25=\"\",\"\",Calculation!AI25)","v":""},{"$f":"IF(Calculation!AJ25=\"\",\"\",Calculation!AJ25)","v":"≤16"}]
[null,{"$f":"IF(Calculation!S26=\"\",\"\",Calculation!S26)","v":"3/4\""},null,{"$f":"IF(Calculation!U26=\"\",\"\",Calculation!U26)","v":""},null,{"$f":"IF(Calculation!W26=\"\",\"\",Calculation!W26)","v":""},null,{"$f":"IF(Calculation!Y26=\"\",\"\",Calculation!Y26)","v":""},null,{"$f":"IF(Calculation!AA26=\"\",\"\",Calculation!AA26)","v":""},null,{"$f":"IF(Calculation!AC26=\"\",\"\",Calculation!AC26)","v":""},null,{"$f":"IF(Calculation!AE26=\"\",\"\",Calculation!AE26)","v":""},null,{"$f":"IF(Calculation!AG26=\"\",\"\",Calculation!AG26)","v":""},{"$f":"IF(Calculation!AH26=\"\",\"\",Calculation!AH26)","v":""},{"$f":"IF(Calculation!AI26=\"\",\"\",Calculation!AI26)","v":""},{"$f":"IF(Calculation!AJ26=\"\",\"\",Calculation!AJ26)","v":"≤20"}]
[null,{"$f":"IF(Calculation!S27=\"\",\"\",Calculation!S27)","v":"5/8\""},null,{"$f":"IF(Calculation!U27=\"\",\"\",Calculation!U27)","v":""},null,{"$f":"IF(Calculation!W27=\"\",\"\",Calculation!W27)","v":""},null,{"$f":"IF(Calculation!Y27=\"\",\"\",Calculation!Y27)","v":""},null,{"$f":"IF(Calculation!AA27=\"\",\"\",Calculation!AA27)","v":""},null,{"$f":"IF(Calculation!AC27=\"\",\"\",Calculation!AC27)","v":""},null,{"$f":"IF(Calculation!AE27=\"\",\"\",Calculation!AE27)","v":""},null,{"$f":"IF(Calculation!AG27=\"\",\"\",Calculation!AG27)","v":""},{"$f":"IF(Calculation!AH27=\"\",\"\",Calculation!AH27)","v":""},{"$f":"IF(Calculation!AI27=\"\",\"\",Calculation!AI27)","v":""},{"$f":"IF(Calculation!AJ27=\"\",\"\",Calculation!AJ27)","v":""}]
[null,{"$f":"IF(Calculation!S28=\"\",\"\",Calculation!S28)","v":"1/2\""},null,{"$f":"IF(Calculation!U28=\"\",\"\",Calculation!U28)","v":""},null,{"$f":"IF(Calculation!W28=\"\",\"\",Calculation!W28)","v":""},null,{"$f":"IF(Calculation!Y28=\"\",\"\",Calculation!Y28)","v":""},null,{"$f":"IF(Calculation!AA28=\"\",\"\",Calculation!AA28)","v":""},null,{"$f":"IF(Calculation!AC28=\"\",\"\",Calculation!AC28)","v":""},null,{"$f":"IF(Calculation!AE28=\"\",\"\",Calculation!AE28)","v":""},null,{"$f":"IF(Calculation!AG28=\"\",\"\",Calculation!AG28)","v":""},{"$f":"IF(Calculation!AH28=\"\",\"\",Calculation!AH28)","v":""},{"$f":"IF(Calculation!AI28=\"\",\"\",Calculation!AI28)","v":""},{"$f":"IF(Calculation!AJ28=\"\",\"\",Calculation!AJ28)","v":"4-20"}]
[null,{"$f":"IF(Calculation!S29=\"\",\"\",Calculation!S29)","v":"3/8\""},null,{"$f":"IF(Calculation!U29=\"\",\"\",Calculation!U29)","v":""},null,{"$f":"IF(Calculation!W29=\"\",\"\",Calculation!W29)","v":""},null,{"$f":"IF(Calculation!Y29=\"\",\"\",Calculation!Y29)","v":""},null,{"$f":"IF(Calculation!AA29=\"\",\"\",Calculation!AA29)","v":""},null,{"$f":"IF(Calculation!AC29=\"\",\"\",Calculation!AC29)","v":""},null,{"$f":"IF(Calculation!AE29=\"\",\"\",Calculation!AE29)","v":""},null,{"$f":"IF(Calculation!AG29=\"\",\"\",Calculation!AG29)","v":""},{"$f":"IF(Calculation!AH29=\"\",\"\",Calculation!AH29)","v":""},{"$f":"IF(Calculation!AI29=\"\",\"\",Calculation!AI29)","v":""},{"$f":"IF(Calculation!AJ29=\"\",\"\",Calculation!AJ29)","v":"4-20"}]
[null,{"$f":"IF(Calculation!S30=\"\",\"\",Calculation!S30)","v":"#4"},null,{"$f":"IF(Calculation!U30=\"\",\"\",Calculation!U30)","v":""},null,{"$f":"IF(Calculation!W30=\"\",\"\",Calculation!W30)","v":""},null,{"$f":"IF(Calculation!Y30=\"\",\"\",Calculation!Y30)","v":""},null,{"$f":"IF(Calculation!AA30=\"\",\"\",Calculation!AA30)","v":""},null,{"$f":"IF(Calculation!AC30=\"\",\"\",Calculation!AC30)","v":""},null,{"$f":"IF(Calculation!AE30=\"\",\"\",Calculation!AE30)","v":""},null,{"$f":"IF(Calculation!AG30=\"\",\"\",Calculation!AG30)","v":""},{"$f":"IF(Calculation!AH30=\"\",\"\",Calculation!AH30)","v":""},{"$f":"IF(Calculation!AI30=\"\",\"\",Calculation!AI30)","v":""},{"$f":"IF(Calculation!AJ30=\"\",\"\",Calculation!AJ30)","v":"4-20"}]
[null,{"$f":"IF(Calculation!S31=\"\",\"\",Calculation!S31)","v":"#8"},null,{"$f":"IF(Calculation!U31=\"\",\"\",Calculation!U31)","v":""},null,{"$f":"IF(Calculation!W31=\"\",\"\",Calculation!W31)","v":""},null,{"$f":"IF(Calculation!Y31=\"\",\"\",Calculation!Y31)","v":""},null,{"$f":"IF(Calculation!AA31=\"\",\"\",Calculation!AA31)","v":""},null,{"$f":"IF(Calculation!AC31=\"\",\"\",Calculation!AC31)","v":""},null,{"$f":"IF(Calculation!AE31=\"\",\"\",Calculation!AE31)","v":""},null,{"$f":"IF(Calculation!AG31=\"\",\"\",Calculation!AG31)","v":""},{"$f":"IF(Calculation!AH31=\"\",\"\",Calculation!AH31)","v":""},{"$f":"IF(Calculation!AI31=\"\",\"\",Calculation!AI31)","v":""},{"$f":"IF(Calculation!AJ31=\"\",\"\",Calculation!AJ31)","v":"≤12"}]
[null,{"$f":"IF(Calculation!S32=\"\",\"\",Calculation!S32)","v":"#16"},null,{"$f":"IF(Calculation!U32=\"\",\"\",Calculation!U32)","v":""},null,{"$f":"IF(Calculation!W32=\"\",\"\",Calculation!W32)","v":""},null,{"$f":"IF(Calculation!Y32=\"\",\"\",Calculation!Y32)","v":""},null,{"$f":"IF(Calculation!AA32=\"\",\"\",Calculation!AA32)","v":""},null,{"$f":"IF(Calculation!AC32=\"\",\"\",Calculation!AC32)","v":""},null,{"$f":"IF(Calculation!AE32=\"\",\"\",Calculation!AE32)","v":""},null,{"$f":"IF(Calculation!AG32=\"\",\"\",Calculation!AG32)","v":""},{"$f":"IF(Calculation!AH32=\"\",\"\",Calculation!AH32)","v":""},{"$f":"IF(Calculation!AI32=\"\",\"\",Calculation!AI32)","v":""},{"$f":"IF(Calculation!AJ32=\"\",\"\",Calculation!AJ32)","v":"≤12"}]
[null,{"$f":"IF(Calculation!S33=\"\",\"\",Calculation!S33)","v":"#30"},null,{"$f":"IF(Calculation!U33=\"\",\"\",Calculation!U33)","v":""},null,{"$f":"IF(Calculation!W33=\"\",\"\",Calculation!W33)","v":""},null,{"$f":"IF(Calculation!Y33=\"\",\"\",Calculation!Y33)","v":""},null,{"$f":"IF(Calculation!AA33=\"\",\"\",Calculation!AA33)","v":""},null,{"$f":"IF(Calculation!AC33=\"\",\"\",Calculation!AC33)","v":""},null,{"$f":"IF(Calculation!AE33=\"\",\"\",Calculation!AE33)","v":""},null,{"$f":"IF(Calculation!AG33=\"\",\"\",Calculation!AG33)","v":""},{"$f":"IF(Calculation!AH33=\"\",\"\",Calculation!AH33)","v":""},{"$f":"IF(Calculation!AI33=\"\",\"\",Calculation!AI33)","v":""},{"$f":"IF(Calculation!AJ33=\"\",\"\",Calculation!AJ33)","v":"4-20"}]
[null,{"$f":"IF(Calculation!S34=\"\",\"\",Calculation!S34)","v":"#50"},null,{"$f":"IF(Calculation!U34=\"\",\"\",Calculation!U34)","v":""},null,{"$f":"IF(Calculation!W34=\"\",\"\",Calculation!W34)","v":""},null,{"$f":"IF(Calculation!Y34=\"\",\"\",Calculation!Y34)","v":""},null,{"$f":"IF(Calculation!AA34=\"\",\"\",Calculation!AA34)","v":""},null,{"$f":"IF(Calculation!AC34=\"\",\"\",Calculation!AC34)","v":""},null,{"$f":"IF(Calculation!AE34=\"\",\"\",Calculation!AE34)","v":""},null,{"$f":"IF(Calculation!AG34=\"\",\"\",Calculation!AG34)","v":""},{"$f":"IF(Calculation!AH34=\"\",\"\",Calculation!AH34)","v":""},{"$f":"IF(Calculation!AI34=\"\",\"\",Calculation!AI34)","v":""},{"$f":"IF(Calculation!AJ34=\"\",\"\",Calculation!AJ34)","v":"4-20"}]
[null,{"$f":"IF(Calculation!S35=\"\",\"\",Calculation!S35)","v":"#100"},null,{"$f":"IF(Calculation!U35=\"\",\"\",Calculation!U35)","v":""},null,{"$f":"IF(Calculation!W35=\"\",\"\",Calculation!W35)","v":""},null,{"$f":"IF(Calculation!Y35=\"\",\"\",Calculation!Y35)","v":""},null,{"$f":"IF(Calculation!AA35=\"\",\"\",Calculation!AA35)","v":""},null,{"$f":"IF(Calculation!AC35=\"\",\"\",Calculation!AC35)","v":""},null,{"$f":"IF(Calculation!AE35=\"\",\"\",Calculation!AE35)","v":""},null,{"$f":"IF(Calculation!AG35=\"\",\"\",Calculation!AG35)","v":""},{"$f":"IF(Calculation!AH35=\"\",\"\",Calculation!AH35)","v":""},{"$f":"IF(Calculation!AI35=\"\",\"\",Calculation!AI35)","v":""},{"$f":"IF(Calculation!AJ35=\"\",\"\",Calculation!AJ35)","v":"≤10"}]
[null,{"$f":"IF(Calculation!S36=\"\",\"\",Calculation!S36)","v":"#200"},null,{"$f":"IF(Calculation!U36=\"\",\"\",Calculation!U36)","v":""},null,{"$f":"IF(Calculation!W36=\"\",\"\",Calculation!W36)","v":""},null,{"$f":"IF(Calculation!Y36=\"\",\"\",Calculation!Y36)","v":""},null,{"$f":"IF(Calculation!AA36=\"\",\"\",Calculation!AA36)","v":""},null,{"$f":"IF(Calculation!AC36=\"\",\"\",Calculation!AC36)","v":""},null,{"$f":"IF(Calculation!AE36=\"\",\"\",Calculation!AE36)","v":""},null,{"$f":"IF(Calculation!AG36=\"\",\"\",Calculation!AG36)","v":""},{"$f":"IF(Calculation!AH36=\"\",\"\",Calculation!AH36)","v":""},{"$f":"IF(Calculation!AI36=\"\",\"\",Calculation!AI36)","v":""},{"$f":"IF(Calculation!AJ36=\"\",\"\",Calculation!AJ36)","v":"≤2"}]
[null,{"$f":"IF(Calculation!S37=\"\",\"\",Calculation!S37)","v":"Physical Aggregate Properties"}]
[null,{"$f":"IF(Calculation!S38=\"\",\"\",Calculation!S38)","v":"Shale +#4:"},null,{"$f":"IF(Calculation!U38=\"\",\"\",Calculation!U38)","v":""},null,{"$f":"IF(Calculation!W38=\"\",\"\",Calculation!W38)","v":""},null,{"$f":"IF(Calculation!Y38=\"\",\"\",Calculation!Y38)","v":""},null,{"$f":"IF(Calculation!AA38=\"\",\"\",Calculation!AA38)","v":""},null,{"$f":"IF(Calculation!AC38=\"\",\"\",Calculation!AC38)","v":""},null,{"$f":"IF(Calculation!AE38=\"\",\"\",Calculation!AE38)","v":""},null,{"$f":"IF(Calculation!AG38=\"\",\"\",Calculation!AG38)","v":""},{"$f":"IF(Calculation!AH38=\"\",\"\",Calculation!AH38)","v":""},{"$f":"IF(Calculation!AI38=\"\",\"\",Calculation!AI38)","v":""},{"$f":"IF(Calculation!AJ38=\"\",\"\",Calculation!AJ38)","v":"≤0.7%"}]
[null,{"$f":"IF(Calculation!S39=\"\",\"\",Calculation!S39)","v":"Lightweight pieces:"},null,{"$f":"IF(Calculation!U39=\"\",\"\",Calculation!U39)","v":""},null,{"$f":"IF(Calculation!W39=\"\",\"\",Calculation!W39)","v":""},null,{"$f":"IF(Calculation!Y39=\"\",\"\",Calculation!Y39)","v":""},null,{"$f":"IF(Calculation!AA39=\"\",\"\",Calculation!AA39)","v":""},null,{"$f":"IF(Calculation!AC39=\"\",\"\",Calculation!AC39)","v":""},null,{"$f":"IF(Calculation!AE39=\"\",\"\",Calculation!AE39)","v":""},null,{"$f":"IF(Calculation!AG39=\"\",\"\",Calculation!AG39)","v":""},{"$f":"IF(Calculation!AH39=\"\",\"\",Calculation!AH39)","v":""},{"$f":"IF(Calculation!AI39=\"\",\"\",Calculation!AI39)","v":""},{"$f":"IF(Calculation!AJ39=\"\",\"\",Calculation!AJ39)","v":"≤2.0%"}]
[null,{"$f":"IF(Calculation!S40=\"\",\"\",Calculation!S40)","v":"Iron oxide particles:"},null,{"$f":"IF(Calculation!U40=\"\",\"\",Calculation!U40)","v":""},null,{"$f":"IF(Calculation!W40=\"\",\"\",Calculation!W40)","v":""},null,{"$f":"IF(Calculation!Y40=\"\",\"\",Calculation!Y40)","v":""},null,{"$f":"IF(Calculation!AA40=\"\",\"\",Calculation!AA40)","v":""},null,{"$f":"IF(Calculation!AC40=\"\",\"\",Calculation!AC40)","v":""},null,{"$f":"IF(Calculation!AE40=\"\",\"\",Calculation!AE40)","v":""},null,{"$f":"IF(Calculation!AG40=\"\",\"\",Calculation!AG40)","v":""},{"$f":"IF(Calculation!AH40=\"\",\"\",Calculation!AH40)","v":""},{"$f":"IF(Calculation!AI40=\"\",\"\",Calculation!AI40)","v":""},{"$f":"IF(Calculation!AJ40=\"\",\"\",Calculation!AJ40)","v":"≤4.0%"}]
[null,{"$f":"IF(Calculation!S41=\"\",\"\",Calculation!S41)","v":"Lignite and other coal:"},null,{"$f":"IF(Calculation!U41=\"\",\"\",Calculation!U41)","v":""},null,{"$f":"IF(Calculation!W41=\"\",\"\",Calculation!W41)","v":""},null,{"$f":"IF(Calculation!Y41=\"\",\"\",Calculation!Y41)","v":""},null,{"$f":"IF(Calculation!AA41=\"\",\"\",Calculation!AA41)","v":""},null,{"$f":"IF(Calculation!AC41=\"\",\"\",Calculation!AC41)","v":""},null,{"$f":"IF(Calculation!AE41=\"\",\"\",Calculation!AE41)","v":""},null,{"$f":"IF(Calculation!AG41=\"\",\"\",Calculation!AG41)","v":""},{"$f":"IF(Calculation!AH41=\"\",\"\",Calculation!AH41)","v":""},{"$f":"IF(Calculation!AI41=\"\",\"\",Calculation!AI41)","v":""},{"$f":"IF(Calculation!AJ41=\"\",\"\",Calculation!AJ41)","v":"≤0.5%"}]
[null,{"$f":"IF(Calculation!S42=\"\",\"\",Calculation!S42)","v":"Soft particles exclusive of items a, b, c:"},null,{"$f":"IF(Calculation!U42=\"\",\"\",Calculation!U42)","v":""},null,{"$f":"IF(Calculation!W42=\"\",\"\",Calculation!W42)","v":""},null,{"$f":"IF(Calculation!Y42=\"\",\"\",Calculation!Y42)","v":""},null,{"$f":"IF(Calculation!AA42=\"\",\"\",Calculation!AA42)","v":""},null,{"$f":"IF(Calculation!AC42=\"\",\"\",Calculation!AC42)","v":""},null,{"$f":"IF(Calculation!AE42=\"\",\"\",Calculation!AE42)","v":""},null,{"$f":"IF(Calculation!AG42=\"\",\"\",Calculation!AG42)","v":""},{"$f":"IF(Calculation!AH42=\"\",\"\",Calculation!AH42)","v":""},{"$f":"IF(Calculation!AI42=\"\",\"\",Calculation!AI42)","v":""},{"$f":"IF(Calculation!AJ42=\"\",\"\",Calculation!AJ42)","v":"≤2.5%"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Calculation!AC43=\"\",\"\",Calculation!AC43)","v":""},null,{"$f":"IF(Calculation!AE43=\"\",\"\",Calculation!AE43)","v":""},null,null,{"$f":"IF(Calculation!AH43=\"\",\"\",Calculation!AH43)","v":""},{"$f":"IF(Calculation!AI43=\"\",\"\",Calculation!AI43)","v":""}]
[null,{"$f":"IF(Calculation!S44=\"\",\"\",Calculation!S44)","v":"Thin or elongated pieces (4:1 thin, 3:1 elongated):"},null,{"$f":"IF(Calculation!U44=\"\",\"\",Calculation!U44)","v":""},null,{"$f":"IF(Calculation!W44=\"\",\"\",Calculation!W44)","v":""},null,{"$f":"IF(Calculation!Y44=\"\",\"\",Calculation!Y44)","v":""},null,{"$f":"IF(Calculation!AA44=\"\",\"\",Calculation!AA44)","v":""},null,{"$f":"IF(Calculation!AC44=\"\",\"\",Calculation!AC44)","v":""},null,{"$f":"IF(Calculation!AE44=\"\",\"\",Calculation!AE44)","v":""},null,{"$f":"IF(Calculation!AG44=\"\",\"\",Calculation!AG44)","v":""},{"$f":"IF(Calculation!AH44=\"\",\"\",Calculation!AH44)","v":""},{"$f":"IF(Calculation!AI44=\"\",\"\",Calculation!AI44)","v":""},{"$f":"IF(Calculation!AJ44=\"\",\"\",Calculation!AJ44)","v":"≤15.0%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Calculation!AH45=\"\",\"\",Calculation!AH45)","v":""},{"$f":"IF(Calculation!AI45=\"\",\"\",Calculation!AI45)","v":""}]
[null,{"$f":"IF(Calculation!S46=\"\",\"\",Calculation!S46)","v":"Soundness % Loss"},null,{"$f":"IF(Calculation!U46=\"\",\"\",Calculation!U46)","v":""},null,{"$f":"IF(Calculation!W46=\"\",\"\",Calculation!W46)","v":""},null,{"$f":"IF(Calculation!Y46=\"\",\"\",Calculation!Y46)","v":""},null,{"$f":"IF(Calculation!AA46=\"\",\"\",Calculation!AA46)","v":""},null,{"$f":"IF(Calculation!AC46=\"\",\"\",Calculation!AC46)","v":""},null,{"$f":"IF(Calculation!AE46=\"\",\"\",Calculation!AE46)","v":""},null,{"$f":"IF(Calculation!AG46=\"\",\"\",Calculation!AG46)","v":""},{"$f":"IF(Calculation!AH46=\"\",\"\",Calculation!AH46)","v":""},{"$f":"IF(Calculation!AI46=\"\",\"\",Calculation!AI46)","v":""},{"$f":"IF(Calculation!AJ46=\"\",\"\",Calculation!AJ46)","v":""}]
[null,{"$f":"IF(Calculation!S47=\"\",\"\",Calculation!S47)","v":"Specific Gravity"},null,{"$f":"IF(Calculation!U47=\"\",\"\",Calculation!U47)","v":""},null,{"$f":"IF(Calculation!W47=\"\",\"\",Calculation!W47)","v":""},null,{"$f":"IF(Calculation!Y47=\"\",\"\",Calculation!Y47)","v":""},null,{"$f":"IF(Calculation!AA47=\"\",\"\",Calculation!AA47)","v":""},null,{"$f":"IF(Calculation!AC47=\"\",\"\",Calculation!AC47)","v":""},null,{"$f":"IF(Calculation!AE47=\"\",\"\",Calculation!AE47)","v":""},null,{"$f":"IF(Calculation!AG47=\"\",\"\",Calculation!AG47)","v":""},{"$f":"IF(Calculation!AH47=\"\",\"\",Calculation!AH47)","v":""},{"$f":"IF(Calculation!AI47=\"\",\"\",Calculation!AI47)","v":""},{"$f":"IF(Calculation!AJ47=\"\",\"\",Calculation!AJ47)","v":""}]
[null,{"$f":"IF(Calculation!S48=\"\",\"\",Calculation!S48)","v":"L.A. Abrasion % Loss"},null,{"$f":"IF(Calculation!U48=\"\",\"\",Calculation!U48)","v":""},null,{"$f":"IF(Calculation!W48=\"\",\"\",Calculation!W48)","v":""},null,{"$f":"IF(Calculation!Y48=\"\",\"\",Calculation!Y48)","v":""},null,{"$f":"IF(Calculation!AA48=\"\",\"\",Calculation!AA48)","v":""},null,{"$f":"IF(Calculation!AC48=\"\",\"\",Calculation!AC48)","v":""},null,{"$f":"IF(Calculation!AE48=\"\",\"\",Calculation!AE48)","v":""},null,{"$f":"IF(Calculation!AG48=\"\",\"\",Calculation!AG48)","v":""},{"$f":"IF(Calculation!AH48=\"\",\"\",Calculation!AH48)","v":""},{"$f":"IF(Calculation!AI48=\"\",\"\",Calculation!AI48)","v":""},{"$f":"IF(Calculation!AJ48=\"\",\"\",Calculation!AJ48)","v":""}]
[null,{"$f":"IF(Calculation!S49=\"\",\"\",Calculation!S49)","v":"% Absorption"},null,{"$f":"IF(Calculation!U49=\"\",\"\",Calculation!U49)","v":""},null,{"$f":"IF(Calculation!W49=\"\",\"\",Calculation!W49)","v":""},null,{"$f":"IF(Calculation!Y49=\"\",\"\",Calculation!Y49)","v":""},null,{"$f":"IF(Calculation!AA49=\"\",\"\",Calculation!AA49)","v":""},null,{"$f":"IF(Calculation!AC49=\"\",\"\",Calculation!AC49)","v":""},null,{"$f":"IF(Calculation!AE49=\"\",\"\",Calculation!AE49)","v":""},null,{"$f":"IF(Calculation!AG49=\"\",\"\",Calculation!AG49)","v":""},{"$f":"IF(Calculation!AH49=\"\",\"\",Calculation!AH49)","v":""},{"$f":"IF(Calculation!AI49=\"\",\"\",Calculation!AI49)","v":""},{"$f":"IF(Calculation!AJ49=\"\",\"\",Calculation!AJ49)","v":""}]
[null,{"$f":"IF(Calculation!S50=\"\",\"\",Calculation!S50)","v":"Color"},null,{"$f":"IF(Calculation!U50=\"\",\"\",Calculation!U50)","v":""},null,{"$f":"IF(Calculation!W50=\"\",\"\",Calculation!W50)","v":""},null,{"$f":"IF(Calculation!Y50=\"\",\"\",Calculation!Y50)","v":""},null,{"$f":"IF(Calculation!AA50=\"\",\"\",Calculation!AA50)","v":""},null,{"$f":"IF(Calculation!AC50=\"\",\"\",Calculation!AC50)","v":""},null,{"$f":"IF(Calculation!AE50=\"\",\"\",Calculation!AE50)","v":""},null,{"$f":"IF(Calculation!AG50=\"\",\"\",Calculation!AG50)","v":""},{"$f":"IF(Calculation!AH50=\"\",\"\",Calculation!AH50)","v":""},{"$f":"IF(Calculation!AI50=\"\",\"\",Calculation!AI50)","v":""},{"$f":"IF(Calculation!AJ50=\"\",\"\",Calculation!AJ50)","v":""}]
[null,{"$f":"IF(Calculation!S51=\"\",\"\",Calculation!S51)","v":"Wt Rodded lb/cf (kg/m^3)"},null,{"$f":"IF(Calculation!U51=\"\",\"\",Calculation!U51)","v":""},null,{"$f":"IF(Calculation!W51=\"\",\"\",Calculation!W51)","v":""},null,{"$f":"IF(Calculation!Y51=\"\",\"\",Calculation!Y51)","v":""},null,{"$f":"IF(Calculation!AA51=\"\",\"\",Calculation!AA51)","v":""},null,{"$f":"IF(Calculation!AC51=\"\",\"\",Calculation!AC51)","v":""},null,{"$f":"IF(Calculation!AE51=\"\",\"\",Calculation!AE51)","v":""},null,{"$f":"IF(Calculation!AG51=\"\",\"\",Calculation!AG51)","v":""},{"$f":"IF(Calculation!AH51=\"\",\"\",Calculation!AH51)","v":""},{"$f":"IF(Calculation!AI51=\"\",\"\",Calculation!AI51)","v":""},{"$f":"IF(Calculation!AJ51=\"\",\"\",Calculation!AJ51)","v":""}]
[null,{"$f":"IF(Calculation!S52=\"\",\"\",Calculation!S52)","v":"Wt Loose lb/cf (kg/m^3):"},null,{"$f":"IF(Calculation!U52=\"\",\"\",Calculation!U52)","v":""},null,{"$f":"IF(Calculation!W52=\"\",\"\",Calculation!W52)","v":""},null,{"$f":"IF(Calculation!Y52=\"\",\"\",Calculation!Y52)","v":""},null,{"$f":"IF(Calculation!AA52=\"\",\"\",Calculation!AA52)","v":""},null,{"$f":"IF(Calculation!AC52=\"\",\"\",Calculation!AC52)","v":""},null,{"$f":"IF(Calculation!AE52=\"\",\"\",Calculation!AE52)","v":""},null,{"$f":"IF(Calculation!AG52=\"\",\"\",Calculation!AG52)","v":""},{"$f":"IF(Calculation!AH52=\"\",\"\",Calculation!AH52)","v":""},{"$f":"IF(Calculation!AI52=\"\",\"\",Calculation!AI52)","v":""},{"$f":"IF(Calculation!AJ52=\"\",\"\",Calculation!AJ52)","v":""}]
[null,{"$f":"IF(Calculation!S53=\"\",\"\",Calculation!S53)","v":"% Moisture"},null,{"$f":"IF(Calculation!U53=\"\",\"\",Calculation!U53)","v":""},null,{"$f":"IF(Calculation!W53=\"\",\"\",Calculation!W53)","v":""},null,{"$f":"IF(Calculation!Y53=\"\",\"\",Calculation!Y53)","v":""},null,{"$f":"IF(Calculation!AA53=\"\",\"\",Calculation!AA53)","v":""},null,{"$f":"IF(Calculation!AC53=\"\",\"\",Calculation!AC53)","v":""},null,{"$f":"IF(Calculation!AE53=\"\",\"\",Calculation!AE53)","v":""},null,{"$f":"IF(Calculation!AG53=\"\",\"\",Calculation!AG53)","v":""},{"$f":"IF(Calculation!AH53=\"\",\"\",Calculation!AH53)","v":""},{"$f":"IF(Calculation!AI53=\"\",\"\",Calculation!AI53)","v":""},{"$f":"IF(Calculation!AJ53=\"\",\"\",Calculation!AJ53)","v":""}]
[null,{"$f":"IF(Calculation!S54=\"\",\"\",Calculation!S54)","v":"Course Sand"},null,{"$f":"IF(Calculation!U54=\"\",\"\",Calculation!U54)","v":""},null,{"$f":"IF(Calculation!W54=\"\",\"\",Calculation!W54)","v":""},null,{"$f":"IF(Calculation!Y54=\"\",\"\",Calculation!Y54)","v":""},null,{"$f":"IF(Calculation!AA54=\"\",\"\",Calculation!AA54)","v":""},null,{"$f":"IF(Calculation!AC54=\"\",\"\",Calculation!AC54)","v":""},null,{"$f":"IF(Calculation!AE54=\"\",\"\",Calculation!AE54)","v":""},null,{"$f":"IF(Calculation!AG54=\"\",\"\",Calculation!AG54)","v":""},{"$f":"IF(Calculation!AH54=\"\",\"\",Calculation!AH54)","v":""},{"$f":"IF(Calculation!AI54=\"\",\"\",Calculation!AI54)","v":""},{"$f":"IF(Calculation!AJ54=\"\",\"\",Calculation!AJ54)","v":"≥15.0"}]
[null,{"$f":"IF(Calculation!S55=\"\",\"\",Calculation!S55)","v":"Fine Sand"},null,{"$f":"IF(Calculation!U55=\"\",\"\",Calculation!U55)","v":""},null,{"$f":"IF(Calculation!W55=\"\",\"\",Calculation!W55)","v":""},null,{"$f":"IF(Calculation!Y55=\"\",\"\",Calculation!Y55)","v":""},null,{"$f":"IF(Calculation!AA55=\"\",\"\",Calculation!AA55)","v":""},null,{"$f":"IF(Calculation!AC55=\"\",\"\",Calculation!AC55)","v":""},null,{"$f":"IF(Calculation!AE55=\"\",\"\",Calculation!AE55)","v":""},null,{"$f":"IF(Calculation!AG55=\"\",\"\",Calculation!AG55)","v":""},{"$f":"IF(Calculation!AH55=\"\",\"\",Calculation!AH55)","v":""},{"$f":"IF(Calculation!AI55=\"\",\"\",Calculation!AI55)","v":""},{"$f":"IF(Calculation!AJ55=\"\",\"\",Calculation!AJ55)","v":"24-34"}]
[null,{"$f":"IF(Calculation!S56=\"\",\"\",Calculation!S56)","v":"Wt. Check %"},null,{"$f":"IF(Calculation!U56=\"\",\"\",Calculation!U56)","v":""},null,{"$f":"IF(Calculation!W56=\"\",\"\",Calculation!W56)","v":""},null,{"$f":"IF(Calculation!Y56=\"\",\"\",Calculation!Y56)","v":""},null,{"$f":"IF(Calculation!AA56=\"\",\"\",Calculation!AA56)","v":""},null,{"$f":"IF(Calculation!AC56=\"\",\"\",Calculation!AC56)","v":""},null,{"$f":"IF(Calculation!AE56=\"\",\"\",Calculation!AE56)","v":""},null,{"$f":"IF(Calculation!AG56=\"\",\"\",Calculation!AG56)","v":""},{"$f":"IF(Calculation!AH56=\"\",\"\",Calculation!AH56)","v":""},{"$f":"IF(Calculation!AI56=\"\",\"\",Calculation!AI56)","v":""},{"$f":"IF(Calculation!AJ56=\"\",\"\",Calculation!AJ56)","v":""}]
[null,{"$f":"IF(Calculation!S57=\"\",\"\",Calculation!S57)","v":""},null,{"$f":"IF(Calculation!U57=\"\",\"\",Calculation!U57)","v":""},null,{"$f":"IF(Calculation!W57=\"\",\"\",Calculation!W57)","v":""},{"$f":"IF(Calculation!X57=\"\",\"\",Calculation!X57)","v":""},{"$f":"IF(Calculation!Y57=\"\",\"\",Calculation!Y57)","v":""},{"$f":"IF(Calculation!Z57=\"\",\"\",Calculation!Z57)","v":""},{"$f":"IF(Calculation!AA57=\"\",\"\",Calculation!AA57)","v":""},{"$f":"IF(Calculation!AB57=\"\",\"\",Calculation!AB57)","v":""},{"$f":"IF(Calculation!AC57=\"\",\"\",Calculation!AC57)","v":""},{"$f":"IF(Calculation!AD57=\"\",\"\",Calculation!AD57)","v":""},{"$f":"IF(Calculation!AE57=\"\",\"\",Calculation!AE57)","v":""},{"$f":"IF(Calculation!AF57=\"\",\"\",Calculation!AF57)","v":""},{"$f":"IF(Calculation!AG57=\"\",\"\",Calculation!AG57)","v":""},{"$f":"IF(Calculation!AH57=\"\",\"\",Calculation!AH57)","v":""},{"$f":"IF(Calculation!AI57=\"\",\"\",Calculation!AI57)","v":""},{"$f":"IF(Calculation!AJ57=\"\",\"\",Calculation!AJ57)","v":""}]
[null,{"$f":"IF(Calculation!S58=\"\",\"\",Calculation!S58)","v":"Remarks:"},null,{"$f":"IF(Calculation!U58=\"\",\"\",Calculation!U58)","v":""},{"$f":"IF(Calculation!V58=\"\",\"\",Calculation!V58)","v":""},{"$f":"IF(Calculation!W58=\"\",\"\",Calculation!W58)","v":""},{"$f":"IF(Calculation!X58=\"\",\"\",Calculation!X58)","v":""},{"$f":"IF(Calculation!Y58=\"\",\"\",Calculation!Y58)","v":""},{"$f":"IF(Calculation!Z58=\"\",\"\",Calculation!Z58)","v":""},{"$f":"IF(Calculation!AA58=\"\",\"\",Calculation!AA58)","v":""},{"$f":"IF(Calculation!AB58=\"\",\"\",Calculation!AB58)","v":""},{"$f":"IF(Calculation!AC58=\"\",\"\",Calculation!AC58)","v":""},{"$f":"IF(Calculation!AD58=\"\",\"\",Calculation!AD58)","v":""},{"$f":"IF(Calculation!AE58=\"\",\"\",Calculation!AE58)","v":""},{"$f":"IF(Calculation!AF58=\"\",\"\",Calculation!AF58)","v":""},{"$f":"IF(Calculation!AG58=\"\",\"\",Calculation!AG58)","v":""},{"$f":"IF(Calculation!AH58=\"\",\"\",Calculation!AH58)","v":""},{"$f":"IF(Calculation!AI58=\"\",\"\",Calculation!AI58)","v":""},{"$f":"IF(Calculation!AJ58=\"\",\"\",Calculation!AJ58)","v":""}]
[null,{"$f":"IF(Calculation!S59=\"\",\"\",Calculation!S59)","v":""}]
[]
[]
[]
[]
[null,{"$f":"IF(Calculation!S64=\"\",\"\",Calculation!S64)","v":"Distribution:"},{"$f":"IF(Calculation!T64=\"\",\"\",Calculation!T64)","v":""},null,{"$f":"IF(Calculation!V64=\"\",\"\",Calculation!V64)","v":""},{"$f":"IF(Calculation!W64=\"\",\"\",Calculation!W64)","v":""},{"$f":"IF(Calculation!X64=\"\",\"\",Calculation!X64)","v":"Test:"},null,null,null,{"$f":"IF(Calculation!Z64=\"\",\"\",Calculation!Z64)","v":"Tech. Name"},null,null,{"$f":"IF(Calculation!AE64=\"\",\"\",Calculation!AE64)","v":""},{"$f":"IF(Calculation!AF64=\"\",\"\",Calculation!AF64)","v":""},{"$f":"IF(Calculation!AG64=\"\",\"\",Calculation!AG64)","v":"Test:"},null,{"$f":"IF(Calculation!AI64=\"\",\"\",Calculation!AI64)","v":"Tech. Name"}]
[null,{"$f":"IF(Calculation!S65=\"\",\"\",Calculation!S65)","v":"District:"},{"$f":"IF(Calculation!T65=\"\",\"\",Calculation!T65)","v":""},null,{"$f":"IF(Calculation!V65=\"\",\"\",Calculation!V65)","v":""},{"$f":"IF(Calculation!W65=\"\",\"\",Calculation!W65)","v":""},{"$f":"IF(Calculation!X65=\"\",\"\",Calculation!X65)","v":"ND T-27"},null,null,null,{"$f":"IF(Calculation!Z65=\"\",\"\",Calculation!Z65)","v":""},null,null,{"$f":"IF(Calculation!AE65=\"\",\"\",Calculation!AE65)","v":""},{"$f":"IF(Calculation!AF65=\"\",\"\",Calculation!AF65)","v":""},{"$f":"IF(Calculation!AG65=\"\",\"\",Calculation!AG65)","v":"ND T-85"},null,{"$f":"IF(Calculation!AI65=\"\",\"\",Calculation!AI65)","v":""}]
[null,{"$f":"IF(Calculation!S66=\"\",\"\",Calculation!S66)","v":"Engineer:"},{"$f":"IF(Calculation!T66=\"\",\"\",Calculation!T66)","v":""},null,{"$f":"IF(Calculation!V66=\"\",\"\",Calculation!V66)","v":""},{"$f":"IF(Calculation!W66=\"\",\"\",Calculation!W66)","v":""},{"$f":"IF(Calculation!X66=\"\",\"\",Calculation!X66)","v":"ND T-11"},null,null,null,{"$f":"IF(Calculation!Z66=\"\",\"\",Calculation!Z66)","v":""},null,null,{"$f":"IF(Calculation!AE66=\"\",\"\",Calculation!AE66)","v":""},{"$f":"IF(Calculation!AF66=\"\",\"\",Calculation!AF66)","v":""},{"$f":"IF(Calculation!AG66=\"\",\"\",Calculation!AG66)","v":"AASHTO T-96"},null,{"$f":"IF(Calculation!AI66=\"\",\"\",Calculation!AI66)","v":""}]
[null,{"$f":"IF(Calculation!S67=\"\",\"\",Calculation!S67)","v":"Contractor:"},{"$f":"IF(Calculation!T67=\"\",\"\",Calculation!T67)","v":""},null,{"$f":"IF(Calculation!V67=\"\",\"\",Calculation!V67)","v":""},{"$f":"IF(Calculation!W67=\"\",\"\",Calculation!W67)","v":""},{"$f":"IF(Calculation!X67=\"\",\"\",Calculation!X67)","v":"NDDOT 3, ND T-113"},null,null,null,{"$f":"IF(Calculation!Z67=\"\",\"\",Calculation!Z67)","v":""},null,null,{"$f":"IF(Calculation!AE67=\"\",\"\",Calculation!AE67)","v":""},{"$f":"IF(Calculation!AF67=\"\",\"\",Calculation!AF67)","v":""},{"$f":"IF(Calculation!AG67=\"\",\"\",Calculation!AG67)","v":"AASHTO T-19"},null,{"$f":"IF(Calculation!AI67=\"\",\"\",Calculation!AI67)","v":""}]
[null,{"$f":"IF(Calculation!S68=\"\",\"\",Calculation!S68)","v":" Other:"},{"$f":"IF(Calculation!T68=\"\",\"\",Calculation!T68)","v":""},null,{"$f":"IF(Calculation!V68=\"\",\"\",Calculation!V68)","v":""},{"$f":"IF(Calculation!W68=\"\",\"\",Calculation!W68)","v":""},{"$f":"IF(Calculation!X68=\"\",\"\",Calculation!X68)","v":"AASHTO T-104"},null,null,null,{"$f":"IF(Calculation!Z68=\"\",\"\",Calculation!Z68)","v":""},null,null,{"$f":"IF(Calculation!AE68=\"\",\"\",Calculation!AE68)","v":""},{"$f":"IF(Calculation!AF68=\"\",\"\",Calculation!AF68)","v":""},{"$f":"IF(Calculation!AG68=\"\",\"\",Calculation!AG68)","v":"ND T-255"},null,{"$f":"IF(Calculation!AI68=\"\",\"\",Calculation!AI68)","v":""}]
[null,{"$f":"IF(Calculation!S69=\"\",\"\",Calculation!S69)","v":""},{"$f":"IF(Calculation!T69=\"\",\"\",Calculation!T69)","v":""},null,{"$f":"IF(Calculation!V69=\"\",\"\",Calculation!V69)","v":""},{"$f":"IF(Calculation!W69=\"\",\"\",Calculation!W69)","v":""},{"$f":"IF(Calculation!X69=\"\",\"\",Calculation!X69)","v":"AASHTO T-21"},null,null,null,{"$f":"IF(Calculation!Z69=\"\",\"\",Calculation!Z69)","v":""},null,null,{"$f":"IF(Calculation!AE69=\"\",\"\",Calculation!AE69)","v":""},{"$f":"IF(Calculation!AF69=\"\",\"\",Calculation!AF69)","v":""},{"$f":"IF(Calculation!AG69=\"\",\"\",Calculation!AG69)","v":""},null,{"$f":"IF(Calculation!AI69=\"\",\"\",Calculation!AI69)","v":""}]

{"sheet":"Concrete Report","index":3,"n_rows":61,"n_cols":26,"rows_kept":61,"cut":false,"hidden":false,"merged":[[61,1,61,10],[58,3,58,6],[59,1,59,2],[59,3,59,6],[59,8,60,10],[60,1,60,2],[60,3,60,6],[53,1,53,10],[54,1,54,7],[54,8,54,10],[55,1,55,7],[55,8,55,10],[56,1,56,6],[56,7,60,7],[56,8,58,10],[57,3,57,6],[58,1,58,2],[47,1,47,10],[48,1,48,6],[48,7,52,7],[48,8,48,9],[49,2,49,6],[49,8,49,9],[50,2,50,6],[50,8,52,10],[51,2,51,6],[52,2,52,6],[41,1,41,5],[41,6,41,7],[41,9,41,10],[42,1,42,10],[43,1,43,10],[44,1,44,4],[44,6,44,10],[45,1,45,10],[46,1,46,4],[46,6,46,10],[38,1,38,5],[38,6,38,7],[38,9,38,10],[39,1,39,5],[39,6,39,7],[39,9,39,10],[40,1,40,5],[40,6,40,7],[40,9,40,10],[32,1,32,3],[32,5,33,6],[32,8,33,8],[33,1,33,3],[34,1,34,4],[34,5,34,7],[34,8,34,10],[35,1,37,4],[35,5,35,7],[35,8,35,10],[36,5,36,7],[36,8,36,10],[37,6,37,7],[37,9,37,10],[22,1,22,10],[23,1,24,3],[23,4,24,4],[23,5,24,5],[23,7,24,7],[23,8,30,8],[23,9,24,9],[23,10,24,10],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[15,7,15,10],[16,1,16,3],[16,4,16,6],[16,7,16,10],[17,1,17,10],[18,1,18,10],[19,1,19,10],[20,1,20,10],[21,1,21,3],[21,4,21,5],[0,0,61,0],[0,1,0,10],[0,11,61,11],[1,1,1,10],[2,1,2,10],[3,1,3,10],[4,1,4,10],[5,1,5,6],[5,7,5,10],[6,1,6,6],[6,7,6,10],[7,1,7,10],[8,1,8,10],[9,1,9,10],[10,1,10,2],[10,3,10,5],[10,8,10,9],[11,1,11,6],[11,7,11,10],[12,1,12,6],[12,7,12,10],[13,1,14,10],[15,1,15,3],[15,4,15,6]]}
[]
[null,"Tests on Air, Slump and",null,null,null,null,null,null,null,null,null,null,null,null,null,"North Dakota Department of Transportation"]
[null,"Weight per Cubic Foot of Concrete Report",null,null,null,null,null,null,null,null,null,null,"Bismarck","Brad Kerzman",296,"North Dakota Department of Transportation, Bismarck District","218 Airport Road Bismarck, ND 58504-6003"]
[null,{"$f":"IF(D58=M3,P3,IF(D58=M4,P4,IF(D58=M5,P5,IF(D58=M6,P6,IF(D58=M7,P7,IF(D58=M8,P8,IF(D58=M9,P9,IF(D58=M10,P10,P2))))))))","v":"North Dakota Department of Transportation"},null,null,null,null,null,null,null,null,null,null,"Devils Lake","Brian Bennes",193,"North Dakota Department of Transportation, Devils Lake District","316 Sixth Street SE. Devils Lake, ND 58301-3628"]
[null,{"$f":"IF(D58=M3,Q3,IF(D58=M4,Q4,IF(D58=M5,Q5,IF(D58=M6,Q6,IF(D58=M7,Q7,IF(D58=M8,Q8,IF(D58=M9,Q9,IF(D58=M10,Q10,\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,"Dickinson","Belinda Balweber-Urlacher",601,"North Dakota Department of Transportation, Dickinson District","1700 Third Avenue West, Suite 101 Dickinson, ND 58601-3009"]
[null,"Project",null,null,null,null,null,"PCN",null,null,null,null,"Fargo","Mark Riley",481,"North Dakota Department of Transportation, Fargo District","503 38th Street S. Fargo, ND 58103-1198"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Grand Forks","Curt Dunn",262,"North Dakota Department of Transportation, Grand Forks District","1951 N Washington St Grand Forks, ND 58203-1420"]
[null,"Type of Work",null,null,null,null,null,null,null,null,null,null,"Minot","Joshua Ide",428,"North Dakota Department of Transportation, Minot District","1305 Highway 2 Bypass East Minot, ND 58701-7922"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Valley City","Kevin Hanson",74,"North Dakota Department of Transportation, Valley City District","1524 Eighth Avenue SW. Valley City, ND 58072-4200"]
[null,"Weather",null,null,null,null,null,null,null,null,null,null,"Williston","Hicham Ajbar",542,"North Dakota Department of Transportation, Williston District","605 Dakota Parkway West Williston, ND 58801-4282"]
[null,"SKY:",null,null,null,null,"WIND:",null,"TEMPERATURE:"]
[null,"Supplier",null,null,null,null,null,"Ticket No."]
[]
[null,"Results"]
[]
[null,"Date Tested",null,null,"Time Tested",null,null,"Class of  Concrete"]
[]
[null,"Concrete from (Paving Sta. Or Part of Structure)"]
[]
[]
[null,"Mix Used - Lbs./Sack Cement"]
[null,null,null,null,"Yrds Delivered",null,null,null,"Sacks/Yd",{"$f":"IF(H30=\"\",\"\",SUM(H30+H31)/94)","v":""}]
[]
[null,"Material",null,null,"Wt. In Lbs.","Blend","Coarse","Lbs./Yd",null,null,"Lbs./Sack"]
[null,null,null,null,null,null,"Blend",null,null,null,null,null,null,null,null,null,null,null,"Is Coarse?","Duplicate","Part of Duplicate","Part of Triplicate","Order","Coarse Wt.","# of Materials"]
[null,{"$f":"IF(J26=\"\",\"\",IF(W26=\"\",J26,J26&\" \"&W26))","v":""},null,null,null,{"$f":"IF(E26=\"\",\"\",ROUND(((E26/($E$26+$E$27+$E$28+$E$29))),4)-(MOD(ROUND(((E26/($E$26+$E$27+$E$28+$E$29)))*100000,4),20)=5)/10000)","v":""},{"$f":"IF(AND(S26=\"YES\",NOT(E26=\"\")),X26/($X$26+$X$27+$X$28+$X$29),\"\")","v":""},{"$f":"IF(G22=\"\",\"\",SUM(E26/G22))","v":""},null,null,{"$f":"IF(H26=\"\",\"\",SUM(H26/$J$22))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J26=$Z$26,\"YES\",IF(J26=$Z$27,\"YES\",\"NO\"))","v":"NO"},{"$f":"IF(OR(J26=J27,J26=J28,J26=J29,J27=J28,J27=J29,J28=J29),\"YES\",\"NO\")","v":"YES"},{"$f":"IF(AND(NOT(J26=\"\"),OR(J26=J27,J26=J28,J26=J29)),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(OR(AND(T28=\"YES\",U26=\"YES\",U27=\"YES\",U28=\"YES\"),AND(T28=\"YES\",U26=\"YES\",U27=\"YES\",U29=\"YES\"),AND(T28=\"YES\",U26=\"YES\",U28=\"YES\",U29=\"YES\")),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(AND(T28=\"YES\",V26=\"YES\"),1,IF(AND(T26=\"YES\",U26=\"YES\"),1,\"\"))","v":""},{"$f":"IF(S26=\"YES\",E26,\"0\")","v":"0"},{"$f":"IF(J26=\"\",\"\",1)","v":""},"Rock"]
[null,{"$f":"IF(J27=\"\",\"\",IF(W27=\"\",J27,J27&\" \"&W27))","v":""},null,null,null,{"$f":"IF(E27=\"\",\"\",ROUND(((E27/($E$26+$E$27+$E$28+$E$29))),4)-(MOD(ROUND(((E27/($E$26+$E$27+$E$28+$E$29)))*100000,4),20)=5)/10000)","v":""},{"$f":"IF(AND(S27=\"YES\",NOT(E27=\"\")),X27/($X$26+$X$27+$X$28+$X$29),\"\")","v":""},{"$f":"IF(G22=\"\",\"\",SUM(E27/G22))","v":""},null,null,"",null,null,null,null,null,null,null,{"$f":"IF(J27=$Z$26,\"YES\",IF(J27=$Z$27,\"YES\",\"NO\"))","v":"NO"},"Triplicate",{"$f":"IF(AND(NOT(J27=\"\"),OR(J27=J26,J27=J28,J27=J29)),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(OR(AND(T28=\"YES\",U26=\"YES\",U27=\"YES\",U28=\"YES\"),AND(T28=\"YES\",U26=\"YES\",U27=\"YES\",U29=\"YES\"),AND(T28=\"YES\",U27=\"YES\",U28=\"YES\",U29=\"YES\")),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(AND(T28=\"YES\",V26=\"NO\",V27=\"YES\"),1,IF(AND(T28=\"YES\",V26=\"YES\",V27=\"YES\"),2,IF(AND(T26=\"YES\",U26=\"NO\",U27=\"YES\"),1,IF(AND(T26=\"YES\",U26=\"YES\",U27=\"YES\"),2,\"\"))))","v":""},{"$f":"IF(S27=\"YES\",E27,\"0\")","v":"0"},{"$f":"IF(J27=\"\",\"\",1)","v":""},"Pea Rock"]
[null,{"$f":"IF(J28=\"\",\"\",IF(W28=\"\",J28,J28&\" \"&W28))","v":""},null,null,null,{"$f":"IF(E28=\"\",\"\",ROUND(((E28/($E$26+$E$27+$E$28+$E$29))),4)-(MOD(ROUND(((E28/($E$26+$E$27+$E$28+$E$29)))*100000,4),20)=5)/10000)","v":""},{"$f":"IF(AND(S28=\"YES\",NOT(E28=\"\")),X28/($X$26+$X$27+$X$28+$X$29),\"\")","v":""},{"$f":"IF(G22=\"\",\"\",SUM(E28/G22))","v":""},null,null,"",null,null,null,null,null,null,null,{"$f":"IF(J28=$Z$26,\"YES\",IF(J28=$Z$27,\"YES\",\"NO\"))","v":"NO"},{"$f":"IF(OR(AND(J26=J27,J26=J28),AND(J26=J27,J26=J29),AND(J26=J28,J26=J29),AND(J27=J28,J27=J29)),\"YES\",\"NO\")","v":"YES"},{"$f":"IF(AND(NOT(J28=\"\"),OR(J28=J26,J28=J27,J28=J29)),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(OR(AND(T28=\"YES\",U26=\"YES\",U27=\"YES\",U28=\"YES\"),AND(T28=\"YES\",U28=\"YES\",U27=\"YES\",U29=\"YES\"),AND(T28=\"YES\",U26=\"YES\",U28=\"YES\",U29=\"YES\")),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(AND(T28=\"YES\",V26=\"YES\",V27=\"YES\",V28=\"YES\"),3,IF(AND(T28=\"YES\",OR(V26=\"YES\",V27=\"YES\"),V28=\"YES\"),2,IF(AND(T26=\"YES\",OR(U26=\"YES\",U27=\"YES\"),U28=\"YES\"),2,IF(AND(T26=\"YES\",U26=\"NO\",U27=\"NO\"),1,\"\"))))","v":1},{"$f":"IF(S28=\"YES\",E28,\"0\")","v":"0"},{"$f":"IF(J28=\"\",\"\",1)","v":""},"Sand"]
[null,{"$f":"IF(J29=\"\",\"\",IF(W29=\"\",J29,J29&\" \"&W29))","v":""},null,null,null,{"$f":"IF(E29=\"\",\"\",ROUND(((E29/($E$26+$E$27+$E$28+$E$29))),4)-(MOD(ROUND(((E29/($E$26+$E$27+$E$28+$E$29)))*100000,4),20)=5)/10000)","v":""},{"$f":"IF(AND(S29=\"YES\",NOT(E29=\"\")),X29/($X$26+$X$27+$X$28+$X$29),\"\")","v":""},{"$f":"IF(G22=\"\",\"\",SUM(E29/G22))","v":""},null,null,"",null,null,null,null,null,null,null,{"$f":"IF(J29=$Z$26,\"YES\",IF(J29=$Z$27,\"YES\",\"NO\"))","v":"NO"},{"$f":"SUM(Y26:Y29)","v":0},{"$f":"IF(AND(NOT(J29=\"\"),OR(J29=J26,J29=J27,J29=J28)),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(OR(AND(T28=\"YES\",U29=\"YES\",U27=\"YES\",U28=\"YES\"),AND(T28=\"YES\",U26=\"YES\",U27=\"YES\",U29=\"YES\"),AND(T28=\"YES\",U26=\"YES\",U28=\"YES\",U29=\"YES\")),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(AND(T28=\"YES\",V29=\"YES\"),3,IF(AND(T26=\"YES\",U29=\"YES\"),2,\"\"))","v":""},{"$f":"IF(S29=\"YES\",E29,\"0\")","v":"0"},{"$f":"IF(J29=\"\",\"\",1)","v":""}]
[null,"Cement",null,null,null,null,null,{"$f":"IF(G22=\"\",\"\",SUM(E30/G22))","v":""},null,"Cement",""]
[null,"Fly Ash",null,null,null,null,null,{"$f":"IF(G22=\"\",\"\",SUM(E31/G22))","v":""},null,"Fly Ash",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock","Pearock"]
[null,"Total Water",null,null,null,null,null,null,null,null,"Gallons/Sack",null,null,null,null,null,null,null,{"$f":"IF(J26=\"Rock\",1,0)","v":0},{"$f":"IF(J26=\"Pea Rock\",1,0)","v":0}]
[null,"Water Added on Site",null,null,null,null,null,{"$f":"IF(G22=\"\",\"\",SUM(E34+E33)/G22)","v":""},null,"Water",{"$f":"IF(H34=\"\",\"\",SUM(H34/J22))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J27=\"Rock\",1,0)","v":0},{"$f":"IF(J27=\"Pea Rock\",1,0)","v":0}]
[null,"Item",null,null,null,"Performed Results of",null,null,"Observed Results of",null,null,null,null,null,null,null,null,null,{"$f":"IF(J28=\"Rock\",1,0)","v":0},{"$f":"IF(J28=\"Pea Rock\",1,0)","v":0}]
[null,"Item",null,null,null,"Tests By Record Personnel",null,null,"Tests By Field Personnel",null,null,null,null,null,null,null,null,null,{"$f":"IF(J29=\"Rock\",1,0)","v":0},{"$f":"IF(J29=\"Pea Rock\",1,0)","v":0}]
[]
[null,null,null,null,null,null,"District Lab",null,"Tolerance","NDDOT Field",null,null,null,null,null,null,null,null,{"$f":"SUM(S33:S36)","v":0},{"$f":"SUM(T33:T36)","v":0}]
[null,"Air Percentage",null,null,null,null,null,null,0.01]
[null,"Slump-Inches",null,null,null,null,null,null,1]
[null,"Weight-Lbs. Per Cubic Foot",null,null,null,null,null,null,2.5]
[null,"Concrete Temperature"]
[]
[null,"Cylinders Made From This Batch:"]
[null,"Progress Cylinder Numbers:"]
[]
[null,"Project Cylinders Number:"]
[]
[null,"Remarks:",null,null,null,null,null,null,"District Personnel"]
[null,{"$f":"IF(C50=\"\",\"\",\"X -\")","v":""},null,null,null,null,null,null,"Tech I.D. #"]
[null,{"$f":"IF(C51=\"\",\"\",\"X -\")","v":""}]
[null,{"$f":"IF(C52=\"\",\"\",\"X -\")","v":""}]
[null,{"$f":"IF(C53=\"\",\"\",\"X -\")","v":""}]
[]
[null,"**Approved / Not Approved only reflects the correlation between tests",null,null,null,null,null,null,"(     )     ** Approved"]
[null,"and does not apply to the passing or failing of any test conducted**",null,null,null,null,null,null,"(     )     ** Not Approved"]
[null,"Distribution:"]
[null,"District",null,{"$f":"IF('Data Entry'!J3=\"\",\"\",'Data Entry'!J3)","v":""}]
[null,"Engineer",null,{"$f":"IF('Data Entry'!J4=\"\",\"\",'Data Entry'!J4)","v":""}]
[null,"Contractor",null,{"$f":"IF('Data Entry'!J5=\"\",\"\",'Data Entry'!J5)","v":""},null,null,null,null,"District Materials Coordinator"]
[null,"Other",null,{"$f":"IF('Data Entry'!J6=\"\",\"\",'Data Entry'!J6)","v":""}]