{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["WS3010","Example"],"not_rendered":{"charts":0,"images":11,"macros":0,"external_links":0,"defined_names":2,"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":"1904"}

{"sheet":"WS3010","index":0,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[5,0,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[7,0,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,8],[9,0,9,4],[9,5,9,8],[11,0,11,4],[11,5,11,6],[11,7,11,8]]}
["Worksheet for Calculating : "]
["Aggregate Moisture Content, Combined % Passing #200 Sieve,\nand Water/Cementitious Ratio"]
[]
["PROJECT DESCRIPTION",null,null,null,null,"GENERAL INFORMATION"]
["Project",null,null,"Contract",null,"Date",null,"Time"]
[]
["Highway",null,null,"County",null,"Air Temp.",null,"Computed By:"]
[]
["Description",null,null,null,null,"Weather"]
[]
["Contractor",null,null,null,null,"Batch No.",null,"Batch Size"]
[]
[]
["Aggregate Laboratory Information",null,null,null,"Sampled Aggregate Information"]
[null,null,null,null,null,null,null,"Washed"]
[null,null,null,null,"Wet","Dry","Moisture","Dry","Passing"]
["Aggregate","Source","Laboratory","Absorption","Aggregate","Aggregate","Content","Aggregate","#200 Sieve"]
[null,null,"Test","%","g","g","%","g","%"]
[null,null,"Number","(A)","(B)","(C)","(D)","(E)","(F)"]
[]
[]
["Fine",null,null,null,null,null,{"$f":"IF(OR(E22=\"\",F22=\"\"),\"\",(E22-F22)/F22*100)","v":""},null,{"$f":"IF(OR(F22=\"\",H22=\"\"),\"\",(F22-H22)/F22*100)","v":""}]
["Coarse 1",null,null,null,null,null,{"$f":"IF(OR(E23=\"\",F23=\"\"),\"\",(E23-F23)/F23*100)","v":""},null,{"$f":"IF(OR(F23=\"\",H23=\"\"),\"\",(F23-H23)/F23*100)","v":""}]
["Coarse 2",null,null,null,null,null,{"$f":"IF(OR(E24=\"\",F24=\"\"),\"\",(E24-F24)/F24*100)","v":""},null,{"$f":"IF(OR(F24=\"\",H24=\"\"),\"\",(F24-H24)/F24*100)","v":""}]
["Coarse 3",null,null,null,null,null,{"$f":"IF(OR(E25=\"\",F25=\"\"),\"\",(E25-F25)/F25*100)","v":""},null,{"$f":"IF(OR(F25=\"\",H25=\"\"),\"\",(F25-H25)/F25*100)","v":""}]
[]
["Field Batch Information"]
[]
["Water",null,null,null,"Aggregates"]
[null,"Batch",null,null,null,"Batch","Dry","% of Total","Net"]
[null,"Quantity",null,null,"Material","Quantity","Weight","Agg. Passing","Water"]
[null,"lb",null,null,null,"lb","lb","#200 Sieve","lb"]
["Mix Water *",null,null,null,null,"(G)","(H)","(J)","(L)"]
[]
["Cementitious Material"]
[null,"Batch",null,null,"Fine",null,{"$f":"IF(OR(G22=\"\",F36=\"\"),\"\",100*F36/(100+G22))","v":""},{"$f":"IF(OR(G36=\"\",G$40=\"\",I22=\"\"),\"\",I22*G36/G$40)","v":""},{"$f":"IF(OR(F36=\"\",D22=\"\"),\"\",F36*(G22-D22)/(100+G22))","v":""}]
["Material","Quantity",null,null,"Coarse 1",null,{"$f":"IF(OR(G23=\"\",F37=\"\"),\"\",100*F37/(100+G23))","v":""},{"$f":"IF(OR(G37=\"\",G$40=\"\",I23=\"\"),\"\",I23*G37/G$40)","v":""},{"$f":"IF(OR(F37=\"\",D23=\"\"),\"\",F37*(G23-D23)/(100+G23))","v":""}]
[null,"lb",null,null,"Coarse 2",null,{"$f":"IF(OR(G24=\"\",F38=\"\"),\"\",100*F38/(100+G24))","v":""},{"$f":"IF(OR(G38=\"\",G$40=\"\",I24=\"\"),\"\",I24*G38/G$40)","v":""},{"$f":"IF(OR(F38=\"\",D24=\"\"),\"\",F38*(G24-D24)/(100+G24))","v":""}]
["Cement",null,null,null,"Coarse 3",null,{"$f":"IF(OR(G25=\"\",F39=\"\"),\"\",100*F39/(100+G25))","v":""},{"$f":"IF(OR(G39=\"\",G$40=\"\",I25=\"\"),\"\",I25*G39/G$40)","v":""},{"$f":"IF(OR(F39=\"\",D25=\"\"),\"\",F39*(G25-D25)/(100+G25))","v":""}]
["Fly Ash",null,null,null,"Total",{"$f":"IF(AND(F36=\"\",F37=\"\",F38=\"\",F39=\"\"),\"\",SUM(F36:F39))","v":""},{"$f":"IF(AND(G36=\"\",G37=\"\",G38=\"\",G39=\"\"),\"\",SUM(G36:G39))","v":""},{"$f":"IF(AND(H36=\"\",H37=\"\",H38=\"\",H39=\"\"),\"\",SUM(H36:H39))","v":""},{"$f":"IF(AND(I36=\"\",I37=\"\",I38=\"\",I39=\"\"),\"\",SUM(I36:I39))","v":""}]
["Slag",null,null,null,null,null,null,"Mix Water *",{"$f":"IF(B33=\"\",\"\",B33)","v":""}]
["Total",{"$f":"IF(AND(B39=\"\",B40=\"\",B41=\"\"),\"\",SUM(B39:B41))","v":""},null,null,null,null,null,"Total",{"$f":"IF(AND(I36=\"\",I37=\"\",I38=\"\",I39=\"\",I41=\"\"),\"\",SUM(I40:I41))","v":""}]
[]
["Admixtures"]
[null,null,"Dosage",null,null,null,null,"Combined % Passing #200    =",{"$f":"H40","v":""}]
["Type","Brand","Rate"]
[null,null,"oz/CY"]
["Air"]
["Entrainer",null,null,null,null,null,null,"Water/Cementitious Ratio (W/Cm)    =",{"$f":"IF(OR(I42=\"\",B42=\"\"),\"\",I42/B42)","v":""}]
["Water"]
["Reducer"]
[]
[null,"*","Mix Water = Total water added to mix at the batch plant"]

{"sheet":"Example","index":1,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[5,0,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[7,0,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,8],[9,0,9,4],[9,5,9,8],[11,0,11,4],[11,5,11,6],[11,7,11,8]]}
["WS3010  Worksheet for Calculating : "]
["Aggregate Moisture Content, Combined % Passing #200 Sieve, \nand Water/Cementitious Ratio"]
[]
["PROJECT DESCRIPTION",null,null,null,null,"GENERAL INFORMATION"]
["Project",null,null,"Contract",null,"Date",null,"Time"]
["1530-08-72",null,null,9702219901,null,"1997-05-21",null,"09:00:00"]
["Highway",null,null,"County",null,"Air Temp.",null,"Computed By:"]
["STH 15",null,null,"Dane",null,"64 F"]
["Description",null,null,null,null,"Weather"]
["CTH A - CTH B",null,null,null,null,"Sunny & Windy"]
["Contractor",null,null,null,null,"Batch No.",null,"Batch Size"]
["XYZ Construction",null,null,null,null,227,null,"9 Cubic Yards"]
[]
["Aggregate Laboratory Information",null,null,null,"Sampled Aggregate Information"]
[null,null,null,null,null,null,null,"Washed"]
[null,null,null,null,"Wet","Dry","Moisture","Dry","Passing"]
["Aggregate","Source","Laboratory","Absorption","Aggregate","Aggregate","Content","Aggregate","#200 Sieve"]
[null,null,"Test","%","g","g","%","g","%"]
[null,null,"Number","(A)","(B)","(C)","(D)","(E)","(F)"]
[]
[]
["Fine","Sample 1","456-87",1.42,527,517,{"$f":"IF(OR(E22=\"\",F22=\"\"),\"\",(E22-F22)/F22*100)","v":1.9342359767891684},505,{"$f":"IF(OR(F22=\"\",H22=\"\"),\"\",(F22-H22)/F22*100)","v":2.3210831721470022}]
["Coarse 1","Sample 2","456-87",1.1599999999999999,2582,2551,{"$f":"IF(OR(E23=\"\",F23=\"\"),\"\",(E23-F23)/F23*100)","v":1.2152097216777733},2508,{"$f":"IF(OR(F23=\"\",H23=\"\"),\"\",(F23-H23)/F23*100)","v":1.6856134849078792}]
["Coarse 2","Sample 3","456-87",1.0900000000000001,5163,5117,{"$f":"IF(OR(E24=\"\",F24=\"\"),\"\",(E24-F24)/F24*100)","v":0.89896423685753379},5050,{"$f":"IF(OR(F24=\"\",H24=\"\"),\"\",(F24-H24)/F24*100)","v":1.3093609536837991}]
["Coarse 3",null,null,null,null,null,{"$f":"IF(OR(E25=\"\",F25=\"\"),\"\",(E25-F25)/F25*100)","v":""},null,{"$f":"IF(OR(F25=\"\",H25=\"\"),\"\",(F25-H25)/F25*100)","v":""}]
[]
["Field Batch Information"]
[]
["Water",null,null,null,"Aggregates"]
[null,"Batch",null,null,null,"Batch","Dry","% of Total","Net"]
[null,"Quantity",null,null,"Material","Quantity","Weight","Agg. Passing","Water"]
[null,"lb",null,null,null,"lb","lb","#200 Sieve","lb"]
["Mix Water *",2114,null,null,null,"(G)","(H)","(J)","(L)"]
[]
["Cementitious Material"]
[null,"Batch",null,null,"Fine",11204,{"$f":"IF(OR(G22=\"\",F36=\"\"),\"\",100*F36/(100+G22))","v":10991.400379506642},{"$f":"IF(OR(G36=\"\",G$40=\"\",I22=\"\"),\"\",I22*G36/G$40)","v":0.92242623606573004},{"$f":"IF(OR(F36=\"\",D22=\"\"),\"\",F36*(G22-D22)/(100+G22))","v":56.521735104364346}]
["Material","Quantity",null,null,"Coarse 1",10924,{"$f":"IF(OR(G23=\"\",F37=\"\"),\"\",100*F37/(100+G23))","v":10792.844306738962},{"$f":"IF(OR(G37=\"\",G$40=\"\",I23=\"\"),\"\",I23*G37/G$40)","v":0.65778175769095815},{"$f":"IF(OR(F37=\"\",D23=\"\"),\"\",F37*(G23-D23)/(100+G23))","v":5.9586993028659903}]
[null,"lb",null,null,"Coarse 2",5926,{"$f":"IF(OR(G24=\"\",F38=\"\"),\"\",100*F38/(100+G24))","v":5873.2020143327518},{"$f":"IF(OR(G38=\"\",G$40=\"\",I24=\"\"),\"\",I24*G38/G$40)","v":0.27804957825349547},{"$f":"IF(OR(F38=\"\",D24=\"\"),\"\",F38*(G24-D24)/(100+G24))","v":-11.219916288979276}]
["Cement",4400,null,null,"Coarse 3",null,{"$f":"IF(OR(G25=\"\",F39=\"\"),\"\",100*F39/(100+G25))","v":""},{"$f":"IF(OR(G39=\"\",G$40=\"\",I25=\"\"),\"\",I25*G39/G$40)","v":""},{"$f":"IF(OR(F39=\"\",D25=\"\"),\"\",F39*(G25-D25)/(100+G25))","v":""}]
["Fly Ash",1000,null,null,"Total",{"$f":"IF(AND(F36=\"\",F37=\"\",F38=\"\",F39=\"\"),\"\",SUM(F36:F39))","v":28054},{"$f":"IF(AND(G36=\"\",G37=\"\",G38=\"\",G39=\"\"),\"\",SUM(G36:G39))","v":27657.446700578359},{"$f":"IF(AND(H36=\"\",H37=\"\",H38=\"\",H39=\"\"),\"\",SUM(H36:H39))","v":1.8582575720101837},{"$f":"IF(AND(I36=\"\",I37=\"\",I38=\"\",I39=\"\"),\"\",SUM(I36:I39))","v":51.260518118251056}]
["Slag",null,null,null,null,null,null,"Mix Water *",{"$f":"IF(B33=\"\",\"\",B33)","v":2114}]
["Total",{"$f":"IF(AND(B39=\"\",B40=\"\",B41=\"\"),\"\",SUM(B39:B41))","v":5400},null,null,null,null,null,"Total",{"$f":"IF(AND(I36=\"\",I37=\"\",I38=\"\",I39=\"\",I41=\"\"),\"\",SUM(I40:I41))","v":2165.2605181182512}]
[]
["Admixtures"]
[null,null,"Dosage",null,null,null,null,"Combined % Passing #200    =",{"$f":"H40","v":1.8582575720101837}]
["Type","Brand","Rate"]
[null,null,"oz/CY"]
["Air"]
["Entrainer","Brand X",5,null,null,null,null,"Water/Cementitious Ratio (W/Cm)    =",{"$f":"IF(OR(I42=\"\",B42=\"\"),\"\",I42/B42)","v":0.40097417002189839}]
["Water"]
["Reducer","Brand Y",49]
[]
[null,"*","Mix Water = Total water added to mix at the batch plant"]