{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["S1","S2","S5","S6","S3","S4","Sheet5"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"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":"S1","index":0,"n_rows":65,"n_cols":41,"rows_kept":65,"cut":false,"hidden":false,"merged":[[34,0,35,5],[18,13,18,15],[16,5,16,6],[19,7,19,12],[21,3,21,4],[19,3,19,4],[17,3,17,4],[18,3,18,4],[17,13,17,15],[17,7,17,12],[23,3,24,4],[23,5,24,6],[23,7,24,12],[23,13,24,15],[25,3,26,4],[25,5,26,6],[25,7,26,12],[25,13,26,15],[15,0,15,2],[19,0,19,2],[20,3,20,4],[20,0,20,2],[18,0,18,2],[16,0,16,2],[16,13,16,15],[13,3,13,4],[14,3,14,4],[13,7,13,12],[13,13,13,15],[15,13,15,15],[11,3,11,4],[12,3,12,4],[15,3,15,4],[16,3,16,4],[14,5,14,6],[16,7,16,12],[15,7,15,12],[15,5,15,6],[13,5,13,6],[14,7,14,12],[0,0,4,3],[5,0,5,1],[5,2,5,5],[6,0,6,3],[7,0,7,2],[7,3,7,6],[18,5,18,6],[19,5,19,6],[9,0,10,2],[9,3,10,4],[17,0,17,2],[14,0,14,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[0,4,2,14],[3,4,3,14],[9,5,10,6],[6,4,6,10],[5,9,5,11],[4,13,4,14],[14,13,14,15],[0,15,0,17],[2,15,2,17],[9,17,10,17],[11,7,11,12],[1,15,1,17],[7,11,7,14],[4,15,4,17],[6,13,6,21],[6,11,6,12],[7,7,7,10],[12,5,12,6],[3,15,3,17],[3,18,3,21],[7,16,7,21],[5,6,5,8],[9,7,10,12],[11,13,11,15],[11,5,11,6],[12,7,12,12],[38,14,38,15],[22,0,22,2],[23,0,24,2],[25,0,26,2],[20,13,20,15],[38,11,38,12],[38,0,38,4],[31,0,31,2],[32,0,32,2],[22,3,22,4],[22,13,22,15],[21,13,21,15],[32,5,32,12],[31,5,31,13],[32,3,32,4],[31,3,31,4],[36,3,36,4],[36,8,36,9],[21,0,21,2],[22,7,22,12],[37,2,37,9],[34,6,34,18],[25,18,26,18],[33,0,33,5],[43,5,43,6],[43,0,43,4],[48,8,48,9],[50,8,50,9],[49,11,49,12],[42,0,42,4],[49,0,49,4],[39,5,39,6],[44,8,44,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[44,5,44,6],[42,8,42,9],[42,5,42,6],[41,0,41,4],[39,0,39,4],[41,8,41,9],[46,0,46,4],[47,0,47,4],[44,11,44,12],[46,14,46,15],[48,11,48,12],[53,0,53,4],[45,5,45,6],[50,0,50,4],[48,5,48,6],[47,5,47,6],[46,5,46,6],[50,11,50,12],[50,5,50,6],[52,5,52,6],[49,5,49,6],[48,0,48,4],[51,0,51,4],[51,17,51,18],[62,0,62,5],[55,8,55,9],[51,8,51,9],[56,14,56,15],[47,14,47,15],[50,14,50,15],[58,0,58,5],[52,11,52,12],[53,11,53,12],[55,0,55,4],[55,5,55,6],[54,11,54,12],[47,11,47,12],[51,11,51,12],[53,8,53,9],[49,8,49,9],[51,14,51,15],[52,0,52,4],[54,5,54,6],[53,5,53,6],[51,5,51,6],[54,0,54,4],[64,19,64,21],[62,19,62,21],[60,19,60,21],[58,19,58,21],[52,14,52,15],[53,14,53,15],[56,17,56,18],[54,17,54,18],[54,14,54,15],[53,17,53,18],[55,14,55,15],[58,6,58,17],[55,17,55,18],[55,11,55,12],[56,11,56,12],[56,8,56,9],[62,6,62,17],[54,8,54,9],[60,6,60,17],[52,8,52,9],[64,0,64,5],[64,6,64,17],[52,17,52,18],[50,17,50,18],[47,17,47,18],[44,17,44,18],[45,17,45,18],[40,17,40,18],[60,0,60,5],[56,5,56,6],[56,0,56,4],[40,8,40,9],[40,5,40,6],[41,5,41,6],[40,0,40,4],[48,17,48,18],[46,11,46,12],[49,14,49,15],[49,17,49,18],[48,14,48,15],[40,11,40,12],[45,14,45,15],[43,14,43,15],[46,17,46,18],[39,17,39,18],[29,9,29,15],[35,6,35,18],[27,10,27,15],[27,0,30,8],[45,0,45,4],[43,8,43,9],[41,17,41,18],[42,17,42,18],[43,17,43,18],[44,0,44,4],[38,8,38,9],[39,8,39,9],[38,5,38,6],[39,14,39,15],[39,11,39,12],[44,14,44,15],[45,11,45,12],[41,14,41,15],[42,14,42,15],[40,14,40,15],[41,11,41,12],[42,11,42,12],[43,11,43,12],[18,16,18,19],[22,16,22,17],[21,16,21,17],[23,19,39,21],[38,17,38,18],[30,16,30,17],[29,16,29,17],[17,5,17,6],[22,5,22,6],[21,7,21,12],[21,5,21,6],[20,5,20,6],[23,18,24,18],[20,16,20,17],[36,16,36,17],[30,10,30,15],[20,7,20,12],[33,8,33,11],[31,14,31,17],[27,16,27,17],[28,16,28,17],[28,10,28,15],[33,12,33,13],[33,6,33,7],[0,40,0,41],[1,40,1,41],[1,18,1,21],[11,19,11,21],[9,18,10,18],[0,18,0,21],[2,18,2,21],[19,16,19,17],[12,19,12,21],[16,19,16,21],[4,18,4,21],[5,14,5,21],[13,19,13,21],[9,19,10,21],[14,19,14,21],[15,19,15,21],[9,16,10,16],[12,13,12,15],[9,13,10,15],[5,12,5,13],[17,19,17,21],[19,13,19,15],[18,7,18,12],[18,20,18,21]]}
["TR-4221A       1a-14",null,null,null,"Concrete Mix Design Form",null,null,null,null,null,null,null,null,null,null,"Material Class",null,null,"AAA",null,null,null,null,null,null,{"$f":"IF(S1=\"Grout\",1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mix Identifier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,"JMF No.",null,null,null,null,null,null,null,null,null,null,"District"]
[null,null,null,null,null,null,null,null,"-",null,null,null,null,{"$f":"IF(ISBLANK(H15),\" \",\"W/Fibers\")","v":" "},null,"ECMS No."]
["SR/WO",null,null,null,null,null,"Sec/Segment",null,null,null,null,null,"Contractor"]
["Concrete Producer",null,null,null,"NESL",null,null,null,null,null,null,"Location"]
["Supplier Code",null,null,null,null,null,null,"Supplier Internal Code",null,null,null,null,null,null,null,"FA #"]
[]
["Material",null,null,"Material Class",null,"Product Name",null,"Producer Name",null,null,null,null,null,"Supplier Code",null,null,"Sp. Gr.","Abs","ASR","Lab No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AAAP"]
["Cement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AAAHPC"]
["Pozzolan 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AAA"]
["Pozzolan 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA Slip Form Paving"]
["Fiber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA"]
["Coarse Agg #1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA 7 Hr. Accl."]
["Coarse Agg #2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"]
["Fine Agg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A Tremie"]
["Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oz/yd (As Req.",null,null,null,"Mfg Dose/cwt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
["Admixture",null,null,"AEA",null,null,null,null,null,null,null,null,null,null,null,null,"Oz/cwt",null,null,{"$f":"($F$44/100)*S20","v":0},"Min","Max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HES"]
["Admixture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oz/cwt",null,null,{"$f":"($F$44/100)*S21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow Fill A"]
["Admixture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oz/cwt",null,null,{"$f":"($F$44/100)*S22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow Fill B"]
["Admixture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oz/cwt",null,null,{"$f":"($F$44/100)*S23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow Fill C"]
["Admixture                  > 127 oz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Sol",null,null,"When using a WR admixture, it must be used at manufacturer's minimum dosage rate to use the maximum 6 1/2\" slump spec per 704.1(d)4.a. When using HRWR admixture, it must be used at the manufacturer's minimum dosage rate to use the maximum 8\" slump per 704.1(d)a. Any additional admixures utilized to enhance the concrete performance may be below the manufacturer's minimun recommended dosage rate.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grout"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wt/gal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shotcrete"]
["Admixture                  > 127 oz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Sol"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wt/gal"]
["When RE admixture is used in concrete > 80 F  or in hot weather, the manufacturer's minimum recommended dosage rate for RE admixture must be used to get 90 minutes of mixing time.",null,null,null,null,null,null,null,null,null,"Total admix water per cubic yd =",null,null,null,null,null,{"$f":"(((1-R24/100)*R25)*(S24/128))+(((1-R26/100)*R27)*(S26/128))","v":0},null,"lbs/yd"]
[null,null,null,null,null,null,null,null,null,null,"Total admix solids per cubic yd =",null,null,null,null,null,{"$f":"((R24/100)*R25)*(S24/128)+((R26/100)*(S26/128))","v":0},null,"lbs/yd"]
[null,null,null,null,null,null,null,null,null,"28/7 ratio from worksheet dated",null,null,null,null,null,null,{"$f":"IF(Z1=1,\"\",'S2'!G26)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,"*28/7 day strength ratio",null,null,null,null,null,{"$f":"IF(ISTEXT(P37),\" \",P37/H37)","v":" "}]
["RCP      Coulombs",null,null,null,null,{"$f":"IF(S1=\"AAAP\",IF(D32>1999,\"Needs to be <2000 unless approved by the DME\",\"\"),IF(S1=\"AAAHPC\",IF(D32>1199,\"Needs to be < 1200 unless approved by the DME\",\"\")))","v":false},null,null,null,null,null,null,null,null,"* (AAAP Only)"]
["Microstrain",null,null,null,null,{"$f":"IF(D33>500,\"Must be < 500 microstrain\",\" \")","v":" "}]
["Strength Data Based on Max W/C",null,null,null,null,null,{"$f":"'S2'!AU1","v":0.4},null,"From trial mix dated",null,null,null,{"$f":"'S2'!G26","v":"00:00:00"}]
["F'c (compressive strength) psi",null,null,null,null,null,{"$f":"Sheet5!N9","v":""}]
[null,null,null,null,null,null,{"$f":"Sheet5!N10","v":""}]
[{"$f":"'S2'!H63","v":7},"Hrs.",{"$f":"IF(Z1=1,\"\",'S2'!N63)","v":""},"Avg psi",null,{"$f":"'S2'!A65","v":7},"Days",{"$f":"IF(Z1=1,\"\",'S2'!F65)","v":""},"Avg psi",null,{"$f":"'S2'!H65","v":14},"Days",{"$f":"IF(Z1=1,\"\",'S2'!M65)","v":""},{"$f":"'S2'!O65","v":28},"Days",{"$f":"IF(Z1=1,\"\",'S2'!T65)","v":""},"Avg psi"]
[null,null,{"$f":"Sheet5!N6","v":""}]
["Mix Number",null,null,null,null,"Trial Mix"]
["W/C Ratio by wt.",null,null,null,null,0.4,null,null,0.39,null,null,0.38]
["Cement (lbs)",null,null,null,null,{"$f":"'S2'!T33","v":600},null,null,{"$f":"IF(Z1=2,'S3'!S10,'S5'!S10)","v":600},null,null,{"$f":"IF(Z1=2,'S3'!S38,'S5'!S38)","v":600},null,null,{"$f":"IF(Z1=2,'S4'!S10,'S6'!S10)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S38,'S6'!S38)","v":0}]
["Pozzolan 1 (lbs)",null,null,null,null,{"$f":"'S2'!T35","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S12,'S5'!S12)","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S40,'S5'!S40)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S12,'S6'!S12)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S40,'S6'!S40)","v":0}]
["Pozzolan 2 (lbs)",null,null,null,null,{"$f":"'S2'!T37","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S14,'S5'!S14)","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S42,'S5'!S42)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S14,'S6'!S14)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S42,'S6'!S42)","v":0}]
["Total Cementitious (lbs)",null,null,null,null,{"$f":"SUM(F41:F43)","v":600},null,null,{"$f":"IF(ISBLANK(I40),\" \",SUM(I41:I43))","v":600},null,null,{"$f":"IF(ISBLANK(L40),\" \",SUM(L41:L43))","v":600},null,null,{"$f":"IF(ISBLANK(O40),\" \",SUM(O41:O43))","v":" "},null,null,{"$f":"IF(ISBLANK(R40),\" \",SUM(R41:R43))","v":" "}]
["Coarse Agg. 1 (lbs)",null,null,null,null,{"$f":"'S2'!T39","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S17,'S5'!S17)","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S45,'S5'!S45)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S17,'S6'!S17)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S45,'S6'!S45)","v":0}]
["Coarse Agg. 2 (lbs)",null,null,null,null,{"$f":"'S2'!T41","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S19,'S5'!S19)","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S47,'S5'!S47)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S19,'S6'!S19)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S47,'S6'!S47)","v":0}]
["Total Coarse Agg. (lbs)",null,null,null,null,{"$f":"SUM(F45:F46)","v":0},null,null,{"$f":"IF(ISBLANK(I40),\" \",SUM(I45:I46))","v":0},null,null,{"$f":"IF(ISBLANK(L40),\" \",SUM(L45:L46))","v":0},null,null,{"$f":"IF(ISBLANK(O40),\" \",SUM(O45:O46))","v":" "},null,null,{"$f":"IF(ISBLANK(R40),\" \",SUM(R45:R46))","v":" "}]
["Fine Agg (lbs)",null,null,null,null,{"$f":"'S2'!T53","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S29,'S5'!S29)","v":0},null,null,{"$f":"IF(Z1=2,'S3'!S57,'S5'!S57)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S29,'S6'!S29)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S57,'S6'!S57)","v":0}]
["Total water (lbs)",null,null,null,null,{"$f":"'S2'!T47","v":240},null,null,{"$f":"IF(Z1=2,'S3'!S23,'S5'!S23)","v":234},null,null,{"$f":"IF(Z1=2,'S3'!S51,'S5'!S51)","v":228},null,null,{"$f":"IF(Z1=2,'S4'!S23,'S6'!S23)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S51,'S6'!S51)","v":0}]
["Admixture water (lbs)",null,null,null,null,{"$f":"IF(SUM($S$24:$S$27)<128,\" \",$Q$28)","v":" "},null,null,{"$f":"IF(ISBLANK(I40),\" \",IF(SUM($S$24:$S$27)<128,\" \",$Q$28))","v":" "},null,null,{"$f":"IF(ISBLANK(L40),\" \",IF(SUM($S$24:$S$27)<128,\" \",$Q$28))","v":" "},null,null,{"$f":"IF(ISBLANK(O40),\" \",IF(SUM($S$24:$S$27)<128,\" \",$Q$28))","v":" "},null,null,{"$f":"IF(ISBLANK(R40),\" \",IF(SUM($S$24:$S$27)<128,\" \",$Q$28))","v":" "}]
["Mix water (lbs)",null,null,null,null,{"$f":"IF(F50=\" \",F49,F49-F50)","v":240},null,null,{"$f":"IF(ISBLANK(I40),\" \",IF(I50=\" \",I49,I49-I50))","v":234},null,null,{"$f":"IF(ISBLANK(L40),\" \",IF(L50=\" \",L49,L49-L50))","v":228},null,null,{"$f":"IF(ISBLANK(O40),\" \",IF(O50=\" \",O49,O49-O50))","v":" "},null,null,{"$f":"IF(ISBLANK(R40),\" \",IF(R50=\" \",R49,R49-R50))","v":" "}]
["Admixture solids/yd (lbs)",null,null,null,null,{"$f":"$Q$29","v":0},null,null,{"$f":"IF(ISBLANK(I40),\" \",$Q$29)","v":0},null,null,{"$f":"IF(ISBLANK(L40),\" \",$Q$29)","v":0},null,null,{"$f":"IF(ISBLANK(O40),\" \",$Q$29)","v":" "},null,null,{"$f":"IF(ISBLANK(R40),\" \",$Q$29)","v":" "}]
["Total (lbs)",null,null,null,null,{"$f":"IF(F41=0,0,F41+F42+F43+F45+F46+F48+F49+F52)","v":840},null,null,{"$f":"IF(Z1=2,'S3'!S31,'S5'!S31)","v":834},null,null,{"$f":"IF(Z1=2,'S3'!S59,'S5'!S59)","v":828},null,null,{"$f":"IF(Z1=2,'S4'!S31,'S6'!S31)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!S59,'S6'!S59)","v":0}]
["Unit weight (lbs/cu. ft.)",null,null,null,null,{"$f":"ROUND(F53/27,1)","v":31.1},null,null,{"$f":"IF(ISBLANK(I40),\" \",ROUND(I53/27,1))","v":30.9},null,null,{"$f":"IF(ISBLANK(L40),\" \",ROUND(L53/27,1))","v":30.7},null,null,{"$f":"IF(ISBLANK(O40),\" \",ROUND(O53/27,1))","v":" "},null,null,{"$f":"IF(ISBLANK(R40),\" \",ROUND(R53/27,1))","v":" "}]
["Coarse Agg vol. (cu. ft.)",null,null,null,null,{"$f":"'S2'!J43","v":0},null,null,{"$f":"IF(Z1=2,'S3'!J17+'S3'!J19,'S5'!J17+'S5'!J19)","v":0},null,null,{"$f":"IF(Z1=2,'S3'!J45+'S3'!J47,'S5'!J45+'S5'!J47)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!J17+'S4'!J19,'S6'!J17+'S6'!J19)","v":0},null,null,{"$f":"IF(Z1=2,'S4'!J45+'S4'!J47,'S6'!J45+'S6'!J47)","v":0}]
["Total water (gal.)",null,null,null,null,{"$f":"ROUND(F49/8.33,1)","v":28.8},null,null,{"$f":"IF(ISBLANK(I40),\" \",ROUND(I49/8.33,1))","v":28.1},null,null,{"$f":"IF(ISBLANK(L40),\" \",ROUND(L49/8.33,1))","v":27.4},null,null,{"$f":"IF(ISBLANK(O40),\" \",ROUND(O49/8.33,1))","v":" "},null,null,{"$f":"(IF(ISBLANK(R40),\" \",ROUND(R49/8.33,1)))","v":" "}]
["Mix water (gal)",null,null,null,null,{"$f":"ROUND(F51/8.33,1)","v":28.8},null,null,{"$f":"IF(ISBLANK(I40),\" \",ROUND(I51/8.33,1))","v":28.1},null,null,{"$f":"IF(ISBLANK(L40),\" \",ROUND(L51/8.33,1))","v":27.4},null,null,{"$f":"IF(ISBLANK(O40),\" \",ROUND(O51/8.33,1))","v":" "},null,null,{"$f":"IF(ISBLANK(R40),\" \",ROUND(R51/8.33,1))","v":" "}]
[]
["Designed by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["Approved and Submitted by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["Reviewed by Contractor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["Reviewed by Materials Engr/Mgr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"S2","index":1,"n_rows":65,"n_cols":47,"rows_kept":65,"cut":false,"hidden":false,"merged":[[60,7,60,14],[60,15,60,21],[0,43,0,44],[23,0,23,12],[23,13,23,14],[23,15,23,18],[29,2,29,3],[38,0,38,1],[40,0,40,1],[42,19,42,20],[40,19,40,20],[40,14,40,16],[42,14,42,16],[46,19,46,20],[27,11,27,12],[27,13,27,16],[25,8,25,13],[27,5,27,6],[24,0,24,21],[29,8,29,9],[29,10,29,11],[29,14,29,20],[21,0,21,3],[26,0,26,21],[19,16,19,17],[19,7,19,11],[19,0,19,3],[21,18,21,21],[19,14,19,15],[21,14,21,15],[21,16,21,17],[19,18,19,21],[19,4,19,5],[21,4,21,5],[25,6,25,7],[25,0,25,5],[27,1,27,4],[7,0,7,4],[8,0,8,2],[17,16,17,17],[0,0,3,3],[0,4,1,14],[0,15,0,17],[3,4,3,14],[2,15,2,17],[5,0,5,3],[5,4,5,11],[5,12,5,14],[5,15,5,21],[0,18,0,21],[1,15,1,17],[2,18,2,21],[3,15,3,17],[3,18,3,21],[1,18,1,21],[27,7,27,10],[27,17,27,18],[19,12,19,13],[36,19,36,20],[34,19,34,20],[32,19,32,20],[34,14,34,16],[32,14,32,16],[31,0,31,21],[33,5,33,7],[34,5,36,7],[36,14,36,16],[36,0,36,2],[32,3,32,4],[34,3,34,4],[36,3,36,4],[32,0,32,1],[34,0,34,2],[30,0,30,21],[48,2,48,3],[36,9,36,10],[34,9,34,10],[37,0,37,21],[32,9,32,10],[49,19,49,20],[49,13,49,17],[48,4,48,6],[38,19,38,20],[42,9,42,10],[40,9,40,10],[38,9,38,10],[38,14,38,16],[38,3,38,4],[46,2,46,3],[40,3,40,4],[46,14,46,16],[46,9,46,10],[45,0,45,21],[48,9,48,10],[41,0,41,8],[42,0,42,8],[43,0,43,21],[44,0,44,21],[52,0,52,1],[64,19,64,20],[55,0,55,21],[61,11,61,12],[56,11,56,12],[57,20,57,21],[58,9,58,10],[56,16,56,17],[57,16,57,17],[56,20,56,21],[63,19,63,20],[63,1,63,2],[64,1,64,2],[64,3,64,4],[64,5,64,6],[64,8,64,9],[57,9,57,10],[57,6,57,7],[64,12,64,13],[64,15,64,16],[64,10,64,11],[62,11,62,12],[62,13,62,14],[50,6,50,7],[54,7,54,8],[54,19,54,20],[54,17,54,18],[57,11,57,12],[50,9,50,10],[56,18,56,19],[57,18,57,19],[52,9,52,10],[52,19,52,20],[52,14,52,16],[52,2,52,3],[52,4,52,7],[54,9,54,10],[56,6,56,7],[57,4,57,5],[59,0,59,21],[58,17,58,18],[58,11,58,12],[58,4,58,5],[56,4,56,5],[58,6,58,7],[56,9,56,10],[63,3,63,4],[63,5,63,6],[61,7,61,8],[61,0,62,6],[62,7,62,8],[63,15,63,16],[63,17,63,18],[64,17,64,18],[63,12,63,13],[63,10,63,11],[61,13,61,14],[62,9,62,10],[61,9,61,10],[63,8,63,9],[61,15,62,21]]}
[{"$f":"'S1'!A1:D5","v":"TR-4221A       1a-14"},null,null,null,"Concrete Mix Design Form",null,null,null,null,null,null,null,null,null,null,"Material Class",null,null,{"$f":"'S1'!S1","v":"AAA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28:7 day ratio",null,{"$f":"ROUND($T$65/$F$65,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(C30,2)","v":0.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,{"$f":"'S1'!S3","v":"00:00:00"}]
[null,null,null,null,null,null,{"$f":"'S1'!G5","v":0},{"$f":"'S1'!H5","v":0},"-",{"$f":"'S1'!J5","v":0},{"$f":"'S1'!K5","v":0},{"$f":"'S1'!L5","v":0},{"$f":"'S1'!M5","v":0},null,null,"District",null,null,{"$f":"'S1'!S4","v":0}]
[null,null,null,null,"Mix Design Worksheet",null,null,null,null,null,null,null,null,null,null,"ECMS No.",null,null,{"$f":"'S1'!S5","v":0}]
[]
["Concrete Producer",null,null,null,{"$f":"'S1'!E7","v":"NESL"},null,null,null,null,null,null,null,"Plant or Project",null,null,{"$f":"'S1'!N7","v":0}]
[]
["Sieve Analysis, % Passing"]
["Sieve Sizes"]
[null,1.5,null,"1\"",null,0.75,null,0.5,null,0.375,null,"#4",null,"#8",null,"#16",null,"#30",null,"#50",null,"#100"]
[]
["A57"]
[]
["A8"]
[]
["A"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FM "]
[]
["Maximun Density",null,null,null,null,null,null,"% Hardened Air Results",null,null,null,null,null,null,"% Solids",null,null,null,"Bulletin 5 method"]
[]
["Dry Rodded Unit wt",null,null,null,null,null,null,null,null,null,null,null,null,null,"CA volume",null,null,null,"Bulletin 5 method"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T33+T35+T37","v":600},"Cement Factor"]
["Volume of dry rodded coarse aggregate(s) per unit volume of concrete",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ACI 211 Method)"]
["````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
["Date trial mix design was done",null,null,null,null,null,null,null,"Wt. / Volume Calculations"]
[{"$f":"'S1'!F39","v":"Trial Mix"}]
[null,"Specific Gravity C Agg 1",null,null,null,null,null,"Specific Gravity C Agg 2",null,null,null,null,null,"Specific Gravity  F Agg"]
[]
["W/C Ratio",null,{"$f":"ROUND('S1'!F40,2)","v":0.4},null,null,null,null,null,"Mix #",null,{"$f":"'S1'!F39","v":"Trial Mix"},null,null,null,"(show adjustments on aditional pages)"]
[{"$f":"Sheet5!N8","v":""}]
[{"$f":"IF(ISBLANK(T33),\"\",Sheet5!N7)","v":"Cement factor does not meet min. for a 'AAA' mix"}]
["Cement",null,null,{"$f":"'S1'!D12","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK(T33),0,ROUND(T33/62.4/3.15,2))","v":3.05},null,"Cu. Ft.",null,null,"x S.G. x 62.4",null,null,null,"=",600,null,"lbs"]
[null,null,null,null,null,"% Pozzolan"]
["Pozzolan 1",null,null,{"$f":"'S1'!D13","v":0},null,{"$f":"(T35+T37)/(T33+T35+T37)","v":0},null,null,"=",{"$f":"IF(ISBLANK('S1'!Q13),0,ROUND(T35/62.4/'S1'!Q13,2))","v":0},null,"Cu. Ft.",null,null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
["Pozzolan 2",null,null,{"$f":"'S1'!D14","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!Q14),0,ROUND(T37/62.4/'S1'!Q14,2))","v":0},null,"Cu. Ft.",null,null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
["C Agg #1",null,null,{"$f":"'S1'!D16","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK(F28),0,ROUND(T39/62.4/F28,2))","v":0},null,"Cu. Ft.",null,null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J39+J41","v":0},"Vol of C Agg"]
["C Agg #2",null,null,{"$f":"'S1'!D17","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK(L28),0,ROUND(T41/62.4/L28,2))","v":0},null,"Cu. Ft.",null,null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISTEXT(J39),0,J39+J41)","v":0},null,"Cu. Ft.",null,null,"x S.G. x 62.4",null,null,null,"=",{"$f":"T39+T41","v":0},null,"lbs"]
[{"$f":"IF(COUNTA(T39:T41)=0,\" \",Sheet5!N11)","v":" "}]
[{"$f":"Sheet5!N12","v":""}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
["Water",null,{"$f":"ROUND(T47/8.33,1)","v":28.8},null,"(Gals)",null,"x .113",null,"=",{"$f":"ROUND(T47/62.4,2)","v":3.85},null,"Cu. Ft.",null,null," x 62.4",null,null,null,"=",{"$f":"ROUND((T33+T35+T37)*AU1,0)","v":240},null,"lbs"]
[]
["% Air",null,6,null,"% / 100x27.0",null,null,null,"=",{"$f":"ROUND(C49/100*27,2)","v":1.62},null,"Cu. Ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Admix solids if nec. ",null,null,null,null,"=",{"$f":"'S1'!Q29","v":0},null,"lbs"]
[null,null,null,null,null,null,"Subtotal",null,"=",{"$f":"IF(ISTEXT(J33),0,J33+J35+J37+J39+J41+J47+J49)","v":8.52},null,"Cu. Ft."]
[]
["F Agg.",null,{"$f":"'S1'!D18","v":0},null,"27.0 - subtotal",null,null,null,"=",{"$f":"IF(ISTEXT(J51),0,27-J51)","v":18.48},null,"Cu. Ft.",null,null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISTEXT(J53),\"\",ROUND(J53*R28*62.4,0))","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,null,"Totals =",null,{"$f":"IF(ISTEXT(J51),0,J51+J53)","v":27},null,"Cu. Ft.",null,null,null,null,null,"Totals =",null,{"$f":"IF(ISBLANK(T33),\"\",T33+T35+T37+T43+T47+T50+T53)","v":840},null,"lbs"]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
["Temperature:",null,null,null,"Concrete",null,null,null,"F","Air ",null,null,null,"F","Unit Wt",null,{"$f":"IF(ISTEXT(T55),\" \",ROUND(T55/27,2))","v":31.11},null,"lbs/cu. ft",null,"Calculated"]
["Initial testing:",null,null,null,"Slump",null,null,null,"in.","Air content",null,null,null,"%","Unit Wt",null,null,null,"lbs/cu. ft",null,"Actual"]
["At pt. of placement:",null,null,null,"Slump",null,null,null,"in.","Air content",null,null,null,"%","Mortar Content",null,null,{"$f":"IF(ISTEXT(J43),\"\",27-J43)","v":27}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,null,null,null,null,null,null,"F'c (Compressive) psi",null,null,null,null,null,null,null,{"$f":"IF(S1<>\"AAAP\",\"\",IF(ISERROR(AT1),\"\",IF(AND(S1=\"AAAP\",AT1<1.33),\"28 to 7 day ratio is less than 1.33\",\"\")))","v":""}]
[{"$f":"Sheet5!N9","v":""},null,null,null,null,null,null,"Hours",null,1,null,2,null,"Avg psi",null,{"$f":"Sheet5!N10","v":""}]
[null,null,null,null,null,null,null,7,null,null,null,null,null,{"$f":"IF(ISBLANK(L63),\"\",ROUND(AVERAGE(J63:M63),0))","v":""}]
["Days",1,null,2,null,"Avg psi",null,"Days",1,null,2,null,"Avg psi",null,"Days",1,null,2,null,"Avg psi"]
[{"$f":"IF(S1=\"HES\",3,7)","v":7},null,null,null,null,{"$f":"IF(ISBLANK(D65),\"\",ROUND(AVERAGE(B65:E65),0))","v":""},null,14,null,null,null,null,{"$f":"IF(ISBLANK(K65),\"\",ROUND(AVERAGE(I65:L65),0))","v":""},null,28,null,null,null,null,{"$f":"IF(ISBLANK(R65),\"\",ROUND(AVERAGE(P65:S65),0))","v":""}]

{"sheet":"S5","index":2,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":true,"merged":[[59,0,59,21],[56,3,56,4],[56,5,56,8],[56,9,56,10],[56,13,56,15],[56,18,56,19],[58,7,58,8],[58,9,58,10],[58,18,58,19],[52,1,52,2],[52,3,52,4],[52,5,52,7],[52,9,52,10],[52,18,52,19],[54,6,54,8],[54,9,54,10],[48,0,48,21],[49,0,49,21],[50,1,50,2],[50,3,50,4],[50,9,50,10],[50,13,50,15],[50,18,50,19],[46,1,46,2],[46,3,46,4],[46,9,46,10],[46,13,46,15],[46,18,46,19],[47,0,47,21],[43,0,43,21],[44,1,44,2],[44,3,44,4],[44,9,44,10],[44,13,44,15],[44,18,44,19],[40,5,41,7],[41,1,41,2],[41,3,41,4],[41,9,41,10],[41,13,41,15],[41,18,41,19],[37,13,37,15],[37,18,37,19],[38,5,38,7],[39,1,39,2],[39,3,39,4],[39,9,39,10],[39,13,39,15],[39,18,39,19],[35,3,35,4],[35,8,35,9],[35,10,35,11],[37,1,37,2],[37,3,37,4],[37,9,37,10],[28,18,28,19],[30,7,30,8],[30,9,30,10],[30,18,30,19],[31,0,31,21],[33,0,33,21],[26,6,26,8],[26,9,26,10],[28,3,28,4],[28,5,28,8],[28,9,28,10],[28,13,28,15],[24,1,24,2],[24,3,24,4],[24,5,24,7],[24,9,24,10],[24,18,24,19],[24,26,25,26],[19,0,19,21],[20,0,20,21],[21,0,21,21],[21,26,22,26],[22,1,22,2],[22,3,22,4],[22,9,22,10],[22,13,22,15],[22,18,22,19],[17,26,18,26],[18,1,18,2],[18,3,18,4],[18,9,18,10],[18,13,18,15],[18,18,18,19],[13,13,13,15],[13,18,13,19],[14,26,15,26],[15,0,15,21],[16,1,16,2],[16,3,16,4],[16,9,16,10],[16,13,16,15],[16,18,16,19],[11,1,11,2],[11,3,11,4],[11,9,11,10],[11,13,11,15],[11,18,11,19],[11,26,12,26],[12,5,13,7],[13,1,13,2],[13,3,13,4],[13,9,13,10],[10,5,10,7],[3,4,3,14],[3,15,3,17],[3,18,3,21],[5,0,5,21],[7,3,7,4],[7,8,7,9],[7,10,7,11],[0,0,3,3],[0,4,1,14],[0,15,0,17],[0,18,0,21],[0,26,0,27],[1,15,1,17],[1,18,1,21],[1,26,1,27],[2,15,2,17],[2,18,2,21],[9,1,9,2],[9,3,9,4],[9,9,9,10],[9,13,9,15],[9,18,9,19]]}
[{"$f":"'S1'!A1:D5","v":"TR-4221A       1a-14"},null,null,null,"Concrete Mix Design Form",null,null,null,null,null,null,null,null,null,null,"Material Class",null,null,{"$f":"'S1'!S1","v":"AAA"},null,null,null,null,null,null,null,"Round W/C mix1",null,{"$f":"ROUND('S1'!I40,2)","v":0.39}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,{"$f":"'S1'!S3","v":"00:00:00"},null,null,null,null,null,null,null,"Round W/C mix2",null,{"$f":"ROUND('S1'!L40,2)","v":0.38}]
[null,null,null,null,null,null,{"$f":"'S1'!G5","v":0},{"$f":"'S1'!H5","v":0},"-",{"$f":"'S1'!J5","v":0},{"$f":"'S1'!K5","v":0},{"$f":"'S1'!L5","v":0},{"$f":"'S1'!M5","v":0},null,null,"District",null,null,{"$f":"'S1'!S4","v":0}]
[null,null,null,null,"Mix Design Worksheet",null,null,null,null,null,null,null,null,null,null,"ECMS No.",null,null,{"$f":"'S1'!S5","v":0}]
[]
["Wt. / Volume Calculations"]
[]
[null,"W/C Ratio",null,{"$f":"ROUND('S1'!I40,2)","v":0.39},null,null,null,null,"Mix #",null,{"$f":"'S1'!I39","v":0}]
[]
[null,"Cement",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D12)","v":0},null,null,null,null,"=",{"$f":"IF(ISTEXT(S10),0,ROUND(S10/62.4/3.15,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,"% Pozzolan"]
[null,"Plozzolan 1",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D13)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$13),0,IF(ISTEXT(S12),0,ROUND(S12/62.4/'S1'!$Q$13,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,{"$f":"IF(ISBLANK('S1'!I40),\" \",(S12+S14)/(S10+S12+S14))","v":{"$error":"#DIV/0!"}}]
[null,"Plozzolan 2",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D14)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$14),0,IF(ISTEXT(S14),0,ROUND(S14/62.4/'S1'!$Q$14,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
["``````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"C Agg 1",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D16)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$16),0,ROUND(S17/62.4/'S1'!$Q$16,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
[null,"C Agg 2",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D17)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$17),0,ROUND(S19/62.4/'S1'!$Q$17,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[{"$f":"IF(COUNTA(S17:S19)=0,\"\",Sheet5!N13)","v":""}]
[{"$f":"Sheet5!N14","v":""}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"Water",null,{"$f":"IF(ISTEXT(S23),\" \",ROUND(S23/8.33,1))","v":0},null,null,null,null,"=",{"$f":"IF(ISTEXT(S23),0,ROUND(S23/62.4,2))","v":0},null,"Cu Ft",null," x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!I40),0,ROUND((S10+S12+S14)*AC1,0))","v":0},null,"lbs"]
[]
[null,"% Air",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S2'!$C$49)","v":6},null,"% / 100 x 27.0",null,null,"=",{"$f":"IF(ISTEXT(D25),0,ROUND(D25/100*27,2))","v":1.62},null,"Cu Ft",null,"Admix (solids if nec)",null,null,null,"=",{"$f":"'S1'!$Q$29","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,"Subtotal =",null,null,{"$f":"J10+J12+J14+J17+J19+J23+J25","v":1.62},null,"Cu Ft"]
[]
[null,"F Agg",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D18)","v":0},null,"27.0 - subtotal   =",null,null,null,{"$f":"IF(J27=0,0,27-J27)","v":25.38},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"J29*'S1'!$Q$18*62.4","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"IF(ISTEXT(J27),\"\",J29+J27)","v":27},null,null,null,null,null,null,null,null,{"$f":"S10+S12+S14+S17+S19+S23+S25+S29","v":0},null,"lbs"]
[]
[]
["Wt. / Volume Calculations"]
[]
[null,"W/C Ratio",null,{"$f":"ROUND('S1'!L40,2)","v":0.38},null,null,null,null,"Mix #",null,{"$f":"'S1'!L39","v":0}]
[]
[null,"Cement",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D12)","v":0},null,null,null,null,"=",{"$f":"IF(ISTEXT(S38),0,ROUND(S38/62.4/3.15,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,"% Pozzolan"]
[null,"Plozzolan 1",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D13)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$13),0,IF(ISTEXT(S40),0,ROUND(S40/62.4/'S1'!$Q$13,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,{"$f":"IF(ISBLANK('S1'!I40),\" \",(S40+S42)/(S38+S40+S42))","v":{"$error":"#DIV/0!"}}]
[null,"Plozzolan 2",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D14)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$14),0,IF(ISTEXT(S42),0,ROUND(S42/62.4/'S1'!$Q$14,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"C Agg 1",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D16)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$16),0,ROUND(S45/62.4/'S1'!$Q$16,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
[null,"C Agg 2",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D17)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$17),0,ROUND(S47/62.4/'S1'!$Q$17,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[{"$f":"IF(COUNTA(S45:S47)=0,\"\",Sheet5!N15)","v":""}]
[{"$f":"Sheet5!N16","v":""}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"Water",null,{"$f":"IF(ISTEXT(S51),\" \",ROUND(S51/8.33,1))","v":0},null,null,null,null,"=",{"$f":"IF(ISTEXT(S51),0,ROUND(S51/62.4,2))","v":0},null,"Cu Ft",null," x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!L40),0,IF(ISTEXT(AC2),\" \",ROUND((S38+S40+S42)*AC2,0)))","v":0},null,"lbs"]
[]
[null,"% Air",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S2'!$C$49)","v":6},null,"% / 100 x 27.0",null,null,"=",{"$f":"IF(ISTEXT(D53),0,ROUND(D53/100*27,2))","v":1.62},null,"Cu Ft",null,"Admix (solids if nec)",null,null,null,"=",{"$f":"'S1'!$Q$29","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,"Subtotal =",null,null,{"$f":"J38+J40+J42+J45+J47+J51+J53","v":1.62}]
[]
[null,"F Agg",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D18)","v":0},null,"27.0 - subtotal  =",null,null,null,{"$f":"IF(J55=0,0,27-J55)","v":25.38},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"J57*'S1'!$Q$18*62.4","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"IF(ISTEXT(J55),\"\",J57+J55)","v":27},null,"Cu Ft",null,null,null,null,null,null,{"$f":"S38+S40+S42+S45+S47+S51+S53+S57","v":0},null,"lbs"]

{"sheet":"S6","index":3,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":true,"merged":[[56,3,56,4],[56,5,56,8],[56,9,56,10],[56,13,56,15],[56,18,56,19],[58,7,58,8],[58,9,58,10],[58,18,58,19],[52,1,52,2],[52,3,52,4],[52,5,52,7],[52,9,52,10],[52,18,52,19],[54,6,54,8],[54,9,54,10],[48,0,48,21],[49,0,49,21],[50,1,50,2],[50,3,50,4],[50,9,50,10],[50,13,50,15],[50,18,50,19],[46,1,46,2],[46,3,46,4],[46,9,46,10],[46,13,46,15],[46,18,46,19],[47,0,47,21],[43,0,43,21],[44,1,44,2],[44,3,44,4],[44,9,44,10],[44,13,44,15],[44,18,44,19],[40,5,41,7],[41,1,41,2],[41,3,41,4],[41,9,41,10],[41,13,41,15],[41,18,41,19],[38,5,38,7],[39,1,39,2],[39,3,39,4],[39,9,39,10],[39,13,39,15],[39,18,39,19],[33,0,33,21],[35,3,35,4],[35,8,35,9],[35,10,35,11],[37,1,37,2],[37,3,37,4],[37,9,37,10],[37,13,37,15],[37,18,37,19],[28,3,28,4],[28,5,28,8],[28,9,28,10],[28,13,28,15],[28,18,28,19],[30,7,30,8],[30,9,30,10],[30,18,30,19],[24,1,24,2],[24,3,24,4],[24,5,24,7],[24,9,24,10],[24,18,24,19],[26,6,26,8],[26,9,26,10],[20,0,20,21],[21,0,21,21],[22,1,22,2],[22,3,22,4],[22,9,22,10],[22,13,22,15],[22,18,22,19],[18,1,18,2],[18,3,18,4],[18,9,18,10],[18,13,18,15],[18,18,18,19],[19,0,19,21],[13,18,13,19],[15,0,15,21],[16,1,16,2],[16,3,16,4],[16,9,16,10],[16,13,16,15],[16,18,16,19],[11,1,11,2],[11,3,11,4],[11,9,11,10],[11,13,11,15],[11,18,11,19],[12,5,13,7],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[10,5,10,7],[3,4,3,14],[3,15,3,17],[3,18,3,21],[5,0,5,21],[7,3,7,4],[7,8,7,9],[7,10,7,11],[0,0,3,3],[0,4,1,14],[0,15,0,17],[0,18,0,21],[0,26,0,27],[1,15,1,17],[1,18,1,21],[1,26,1,27],[2,15,2,17],[2,18,2,21],[9,1,9,2],[9,3,9,4],[9,9,9,10],[9,13,9,15],[9,18,9,19]]}
[{"$f":"'S1'!A1:D5","v":"TR-4221A       1a-14"},null,null,null,"Concrete Mix Design Form",null,null,null,null,null,null,null,null,null,null,"Material Class",null,null,{"$f":"'S1'!S1","v":"AAA"},null,null,null,null,null,null,null,"Rounded W/C Mix 3",null,{"$f":"ROUND(D8,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,{"$f":"'S1'!S3","v":"00:00:00"},null,null,null,null,null,null,null,"Rounded W/C Mix 4",null,{"$f":"ROUND(D36,2)","v":0}]
[null,null,null,null,null,null,{"$f":"'S1'!G5","v":0},{"$f":"'S1'!H5","v":0},"-",{"$f":"'S1'!J5","v":0},{"$f":"'S1'!K5","v":0},{"$f":"'S1'!L5","v":0},{"$f":"'S1'!M5","v":0},null,null,"District",null,null,{"$f":"'S1'!S4","v":0}]
[null,null,null,null,"Mix Design Worksheet",null,null,null,null,null,null,null,null,null,null,"ECMS No.",null,null,{"$f":"'S1'!S5","v":0}]
[]
["Wt. / Volume Calculations"]
[]
[null,"W/C Ratio",null,{"$f":"ROUND('S1'!O40,2)","v":0},null,null,null,null,"Mix #",null,{"$f":"'S1'!O39","v":0}]
[]
[null,"Cement",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D12)","v":" "},null,null,null,null,"=",{"$f":"IF(ISTEXT(S10),0,ROUND(S10/62.4/3.15,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,"% Pozzolan"]
[null,"Plozzolan 1",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D13)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$13),0,IF(ISTEXT(S12),0,ROUND(S12/62.4/'S1'!$Q$13,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,{"$f":"IF(ISBLANK('S1'!O40),\" \",(S12+S14)/(S10+S12+S14))","v":" "}]
[null,"Plozzolan 2",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D14)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$14),0,IF(ISTEXT(S14),0,ROUND(S14/62.4/'S1'!$Q$14,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J17+J19","v":0}]
["``````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"C Agg 1",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D16)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$16),0,ROUND(S17/62.4/'S1'!$Q$16,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
[null,"C Agg 2",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D17)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$17),0,ROUND(S19/62.4/'S1'!$Q$17,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[{"$f":"IF(COUNTA(S17:S19)=0,\"\",Sheet5!N17)","v":""}]
[{"$f":"Sheet5!N18","v":""}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"Water",null,{"$f":"IF(ISTEXT(S23),\" \",ROUND(S23/8.33,1))","v":0},null,null,null,null,"=",{"$f":"IF(ISTEXT(S23),0,ROUND(S23/62.4,2))","v":0},null,"Cu Ft",null," x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!O40),0,IF(ISTEXT(AC1),\" \",ROUND((S10+S12+S14)*AC1,0)))","v":0},null,"lbs"]
[]
[null,"% Air",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S2'!$C$49)","v":" "},null,"% / 100 x 27.0",null,null,"=",{"$f":"IF(ISTEXT(D25),0,ROUND(D25/100*27,2))","v":0},null,"Cu Ft",null,"Admix (solids if nec)",null,null,null,"=",{"$f":"'S1'!$Q$29","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,"Subtotal =",null,null,{"$f":"J10+J12+J14+J17+J19+J23+J25","v":0},null,"Cu Ft"]
[]
[null,"F Agg",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D18)","v":" "},null,"27.0 - subtotal   =",null,null,null,{"$f":"IF(J27=0,0,27-J27)","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"J29*'S1'!$Q$18*62.4","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"J29+J27","v":0},null,null,null,null,null,null,null,null,{"$f":"S10+S12+S14+S17+S19+S23+S25+S29","v":0},null,"lbs"]
[]
[]
["Wt. / Volume Calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z33","v":0}]
[null,"W/C Ratio",null,{"$f":"ROUND('S1'!R40,2)","v":0},null,null,null,null,"Mix #",null,{"$f":"'S1'!R39","v":0}]
[]
[null,"Cement",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D12)","v":" "},null,null,null,null,"=",{"$f":"IF(ISTEXT(S38),0,ROUND(S38/62.4/3.15,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,"% Pozzolan"]
[null,"Plozzolan 1",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D13)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$13),0,IF(ISTEXT(S40),0,ROUND(S40/62.4/'S1'!$Q$13,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,{"$f":"IF(ISBLANK('S1'!R40),\" \",(S40+S42)/(S38+S40+S42))","v":" "}]
[null,"Plozzolan 2",null,{"$f":"'S1'!D14","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$14),0,IF(ISTEXT(S42),0,ROUND(S42/62.4/'S1'!$Q$14,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J45+J47","v":0}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"C Agg 1",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D16)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$16),0,ROUND(S45/62.4/'S1'!$Q$16,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
[null,"C Agg 2",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D17)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$17),0,ROUND(S47/62.4/'S1'!$Q$17,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[{"$f":"IF(COUNTA(S45:S47)=0,\"\",Sheet5!N19)","v":""}]
[{"$f":"Sheet5!N20","v":""}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"Water",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",ROUND(S51/8.33,1))","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!R40),0,ROUND(S51/62.4,2))","v":0},null,"Cu Ft",null," x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!R40),0,IF(ISTEXT(AC2),\"\",ROUND((S38+S40+S42)*AC2,0)))","v":0},null,"lbs"]
[]
[null,"% Air",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S2'!$C$49)","v":" "},null,"% / 100 x 27.0",null,null,"=",{"$f":"IF(ISTEXT(D53),0,ROUND(D53/100*27,2))","v":0},null,"Cu Ft",null,"Admix (solids if nec)",null,null,null,"=",{"$f":"'S1'!$Q$29","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,"Subtotal =",null,null,{"$f":"J38+J40+J42+J45+J47+J51+J53","v":0}]
[]
[null,"F Agg",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D18)","v":" "},null,"27.0 - subtotal  =",null,null,null,{"$f":"IF(J55=0,0,27-J55)","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"J57*'S1'!$Q$18*62.4","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"J57+J55","v":0},null,"Cu Ft",null,null,null,null,null,null,{"$f":"S38+S40+S42+S45+S47+S51+S53+S57","v":0},null,"lbs"]

{"sheet":"S3","index":4,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,18,1,21],[52,18,52,19],[11,9,11,10],[10,5,10,7],[19,0,19,21],[47,0,47,21],[11,13,11,15],[13,13,13,15],[9,18,9,19],[2,18,2,21],[3,15,3,17],[3,18,3,21],[5,0,5,21],[7,3,7,4],[0,0,3,3],[9,3,9,4],[11,3,11,4],[7,8,7,9],[7,10,7,11],[0,4,1,14],[0,15,0,17],[2,15,2,17],[3,4,3,14],[0,18,0,21],[1,15,1,17],[50,1,50,2],[9,13,9,15],[9,1,9,2],[11,1,11,2],[9,9,9,10],[59,0,59,21],[56,18,56,19],[58,7,58,8],[58,9,58,10],[58,18,58,19],[56,3,56,4],[56,5,56,8],[56,9,56,10],[56,13,56,15],[52,3,52,4],[52,9,52,10],[46,9,46,10],[46,13,46,15],[52,5,52,7],[48,0,48,21],[54,6,54,8],[54,9,54,10],[50,18,50,19],[50,13,50,15],[40,5,41,7],[39,1,39,2],[44,18,44,19],[49,0,49,21],[41,18,41,19],[41,3,41,4],[41,9,41,10],[41,13,41,15],[50,3,50,4],[22,13,22,15],[37,3,37,4],[37,9,37,10],[41,1,41,2],[39,3,39,4],[39,9,39,10],[39,13,39,15],[14,26,15,26],[17,26,18,26],[28,5,28,8],[21,0,21,21],[24,1,24,2],[18,1,18,2],[24,18,24,19],[22,1,22,2],[22,18,22,19],[18,9,18,10],[16,13,16,15],[18,18,18,19],[16,18,16,19],[22,9,22,10],[28,18,28,19],[24,26,25,26],[21,26,22,26],[35,10,35,11],[11,18,11,19],[26,6,26,8],[11,26,12,26],[13,3,13,4],[13,1,13,2],[28,13,28,15],[44,9,44,10],[44,1,44,2],[44,3,44,4],[44,13,44,15],[15,0,15,21],[37,1,37,2],[16,3,16,4],[16,1,16,2],[18,3,18,4],[37,13,37,15],[30,9,30,10],[30,7,30,8],[26,9,26,10],[28,3,28,4],[24,5,24,7],[20,0,20,21],[37,18,37,19],[0,26,0,27],[1,26,1,27],[52,1,52,2],[30,18,30,19],[28,9,28,10],[43,0,43,21],[12,5,13,7],[38,5,38,7],[22,3,22,4],[24,3,24,4],[24,9,24,10],[39,18,39,19],[16,9,16,10],[18,13,18,15],[13,18,13,19],[13,9,13,10],[46,1,46,2],[46,3,46,4],[46,18,46,19],[50,9,50,10],[33,0,33,21],[35,3,35,4],[35,8,35,9],[31,0,31,21]]}
[{"$f":"'S1'!A1:D5","v":"TR-4221A       1a-14"},null,null,null,"Concrete Mix Design Form",null,null,null,null,null,null,null,null,null,null,"Material Class",null,null,{"$f":"'S1'!S1","v":"AAA"},null,null,null,null,null,null,null,"Rounded W/C Mix 1",null,{"$f":"ROUND(D8,2)","v":0.39}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,{"$f":"'S1'!S3","v":"00:00:00"},null,null,null,null,null,null,null,"Rounded W/C Mix 2",null,{"$f":"ROUND(D36,2)","v":0.38}]
[null,null,null,null,null,null,{"$f":"'S1'!G5","v":0},{"$f":"'S1'!H5","v":0},"-",{"$f":"'S1'!J5","v":0},{"$f":"'S1'!K5","v":0},{"$f":"'S1'!L5","v":0},{"$f":"'S1'!M5","v":0},null,null,"District",null,null,{"$f":"'S1'!S4","v":0}]
[null,null,null,null,"Mix Design Worksheet",null,null,null,null,null,null,null,null,null,null,"ECMS No.",null,null,{"$f":"'S1'!S5","v":0}]
[]
["Wt. / Volume Calculations"]
[]
[null,"W/C Ratio",null,{"$f":"ROUND('S1'!I40,2)","v":0.39},null,null,null,null,"Mix #",null,{"$f":"'S1'!I39","v":0}]
[]
[null,"Cement",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D12)","v":0},null,null,null,null,"=",{"$f":"IF(ISTEXT(S10),0,ROUND(S10/62.4/3.15,2))","v":3.05},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!I40),0,'S2'!$T$33)","v":600},null,"lbs"]
[null,null,null,null,null,"% Pozzolan"]
[null,"Plozzolan 1",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D13)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$13),0,IF(ISTEXT(S12),0,ROUND(S12/62.4/'S1'!$Q$13,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!I40),0,'S2'!$T$35)","v":0},null,"lbs"]
[null,null,null,null,null,{"$f":"IF(ISBLANK('S1'!I40),\" \",(S12+S14)/(S10+S12+S14))","v":0}]
[null,"Plozzolan 2",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D14)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$14),0,IF(ISTEXT(S14),0,ROUND(S14/62.4/'S1'!$Q$14,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!I40),0,'S2'!$T$37)","v":0},null,"lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J17+J19","v":0},"Vol C Agg"]
["``````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"C Agg 1",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D16)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$16),0,ROUND(S17/62.4/'S1'!$Q$16,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
[null,"C Agg 2",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D17)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$17),0,ROUND(S19/62.4/'S1'!$Q$17,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[{"$f":"IF(COUNTA(S17:S19)=0,\"\",Sheet5!N13)","v":""}]
[{"$f":"Sheet5!N14","v":""}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"Water",null,{"$f":"IF(ISTEXT(S23),\" \",ROUND(S23/8.33,1))","v":28.1},null,null,null,null,"=",{"$f":"IF(ISTEXT(S23),0,ROUND(S23/62.4,2))","v":3.75},null,"Cu Ft",null," x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!I40),0,IF(ISTEXT(AC1),\" \",ROUND((S10+S12+S14)*AC1,0)))","v":234},null,"lbs"]
[]
[null,"% Air",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S2'!$C$49)","v":6},null,"% / 100 x 27.0",null,null,"=",{"$f":"IF(ISTEXT(D25),0,ROUND(D25/100*27,2))","v":1.62},null,"Cu Ft",null,"Admix (solids if nec)",null,null,null,"=",{"$f":"'S1'!$Q$29","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,"Subtotal =",null,null,{"$f":"J10+J12+J14+J17+J19+J23+J25","v":8.42},null,"Cu Ft"]
[]
[null,"F Agg",null,{"$f":"IF(ISBLANK('S1'!I40),\" \",'S1'!D18)","v":0},null,"27.0 - subtotal   =",null,null,null,{"$f":"IF(J27=0,0,27-J27)","v":18.579999999999998},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"J29*'S1'!$Q$18*62.4","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"IF(ISTEXT(J27),\"\",J29+J27)","v":27},null,null,null,null,null,null,null,null,{"$f":"S10+S12+S14+S17+S19+S23+S25+S29","v":834},null,"lbs"]
[]
[]
["Wt. / Volume Calculations"]
[]
[null,"W/C Ratio",null,{"$f":"ROUND('S1'!L40,2)","v":0.38},null,null,null,null,"Mix #",null,{"$f":"'S1'!L39","v":0}]
[]
[null,"Cement",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D12)","v":0},null,null,null,null,"=",{"$f":"IF(ISTEXT(S38),0,ROUND(S38/62.4/3.15,2))","v":3.05},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!L40),0,'S2'!$T$33)","v":600},null,"lbs"]
[null,null,null,null,null,"% Pozzolan"]
[null,"Plozzolan 1",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D13)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$13),0,IF(ISTEXT(S40),0,ROUND(S40/62.4/'S1'!$Q$13,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!L40),0,'S2'!$T$35)","v":0},null,"lbs"]
[null,null,null,null,null,{"$f":"IF(ISBLANK('S1'!I40),\" \",(S40+S42)/(S38+S40+S42))","v":0}]
[null,"Plozzolan 2",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D14)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$14),0,IF(ISTEXT(S42),0,ROUND(S42/62.4/'S1'!$Q$14,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!L40),0,'S2'!$T$37)","v":0},null,"lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J45+J47","v":0},"Vol C Agg"]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"C Agg 1",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D16)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$16),0,ROUND(S45/62.4/'S1'!$Q$16,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
[null,"C Agg 2",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D17)","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$17),0,ROUND(S47/62.4/'S1'!$Q$17,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[{"$f":"IF(COUNTA(S45:S47)=0,\"\",Sheet5!N15)","v":""}]
[{"$f":"Sheet5!N16","v":""}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"Water",null,{"$f":"IF(ISTEXT(S51),\" \",ROUND(S51/8.33,1))","v":27.4},null,null,null,null,"=",{"$f":"IF(ISTEXT(S51),0,ROUND(S51/62.4,2))","v":3.65},null,"Cu Ft",null," x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!L40),0,IF(ISTEXT(AC2),\" \",ROUND((S38+S40+S42)*AC2,0)))","v":228},null,"lbs"]
[]
[null,"% Air",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S2'!$C$49)","v":6},null,"% / 100 x 27.0",null,null,"=",{"$f":"IF(ISTEXT(D53),0,ROUND(D53/100*27,2))","v":1.62},null,"Cu Ft",null,"Admix (solids if nec)",null,null,null,"=",{"$f":"'S1'!$Q$29","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,"Subtotal =",null,null,{"$f":"J38+J40+J42+J45+J47+J51+J53","v":8.32}]
[]
[null,"F Agg",null,{"$f":"IF(ISBLANK('S1'!L40),\" \",'S1'!D18)","v":0},null,"27.0 - subtotal  =",null,null,null,{"$f":"IF(J55=0,0,27-J55)","v":18.68},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"J57*'S1'!$Q$18*62.4","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"IF(ISTEXT(J55),\"\",J57+J55)","v":27},null,"Cu Ft",null,null,null,null,null,null,{"$f":"S38+S40+S42+S45+S47+S51+S53+S57","v":828},null,"lbs"]

{"sheet":"S4","index":5,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":false,"merged":[[44,1,44,2],[22,13,22,15],[43,0,43,21],[13,1,13,2],[26,6,26,8],[26,9,26,10],[39,1,39,2],[13,3,13,4],[10,5,10,7],[13,13,13,15],[44,18,44,19],[16,18,16,19],[44,13,44,15],[39,3,39,4],[39,9,39,10],[18,3,18,4],[41,1,41,2],[41,18,41,19],[22,18,22,19],[37,18,37,19],[30,7,30,8],[39,18,39,19],[39,13,39,15],[44,3,44,4],[44,9,44,10],[7,8,7,9],[24,3,24,4],[24,5,24,7],[24,9,24,10],[38,5,38,7],[41,3,41,4],[41,9,41,10],[2,18,2,21],[3,4,3,14],[3,18,3,21],[3,15,3,17],[28,18,28,19],[41,13,41,15],[40,5,41,7],[5,0,5,21],[24,18,24,19],[9,1,9,2],[7,3,7,4],[9,9,9,10],[9,18,9,19],[11,9,11,10],[11,13,11,15],[12,5,13,7],[37,1,37,2],[37,3,37,4],[37,9,37,10],[35,8,35,9],[35,10,35,11],[33,0,33,21],[0,0,3,3],[0,4,1,14],[0,15,0,17],[2,15,2,17],[37,13,37,15],[11,1,11,2],[20,0,20,21],[15,0,15,21],[22,3,22,4],[11,3,11,4],[0,18,0,21],[1,18,1,21],[13,9,13,10],[13,18,13,19],[7,10,7,11],[9,13,9,15],[1,15,1,17],[58,18,58,19],[56,18,56,19],[58,7,58,8],[58,9,58,10],[54,9,54,10],[52,18,52,19],[52,5,52,7],[50,9,50,10],[50,13,50,15],[50,18,50,19],[52,9,52,10],[56,3,56,4],[56,5,56,8],[54,6,54,8],[56,9,56,10],[56,13,56,15],[52,3,52,4],[46,13,46,15],[46,9,46,10],[48,0,48,21],[50,1,50,2],[46,18,46,19],[52,1,52,2],[50,3,50,4],[46,1,46,2],[46,3,46,4],[49,0,49,21],[47,0,47,21],[0,26,0,27],[1,26,1,27],[35,3,35,4],[30,9,30,10],[28,3,28,4],[28,5,28,8],[28,9,28,10],[28,13,28,15],[18,9,18,10],[11,18,11,19],[21,0,21,21],[18,13,18,15],[18,18,18,19],[16,3,16,4],[18,1,18,2],[16,1,16,2],[19,0,19,21],[30,18,30,19],[24,1,24,2],[22,1,22,2],[16,9,16,10],[16,13,16,15],[22,9,22,10],[9,3,9,4]]}
[{"$f":"'S1'!A1:D5","v":"TR-4221A       1a-14"},null,null,null,"Concrete Mix Design Form",null,null,null,null,null,null,null,null,null,null,"Material Class",null,null,{"$f":"'S1'!S1","v":"AAA"},null,null,null,null,null,null,null,"Rounded W/C Mix 3",null,{"$f":"ROUND(D8,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,{"$f":"'S1'!S3","v":"00:00:00"},null,null,null,null,null,null,null,"Rounded W/C Mix 4",null,{"$f":"ROUND(D36,2)","v":0}]
[null,null,null,null,null,null,{"$f":"'S1'!G5","v":0},{"$f":"'S1'!H5","v":0},"-",{"$f":"'S1'!J5","v":0},{"$f":"'S1'!K5","v":0},{"$f":"'S1'!L5","v":0},{"$f":"'S1'!M5","v":0},null,null,"District",null,null,{"$f":"'S1'!S4","v":0}]
[null,null,null,null,"Mix Design Worksheet",null,null,null,null,null,null,null,null,null,null,"ECMS No.",null,null,{"$f":"'S1'!S5","v":0}]
[]
["Wt. / Volume Calculations"]
[]
[null,"W/C Ratio",null,{"$f":"ROUND('S1'!O40,2)","v":0},null,null,null,null,"Mix #",null,{"$f":"'S1'!O39","v":0}]
[]
[null,"Cement",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D12)","v":" "},null,null,null,null,"=",{"$f":"IF(ISTEXT(S10),0,ROUND(S10/62.4/3.15,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!O40),0,'S2'!$T$33)","v":0},null,"lbs"]
[null,null,null,null,null,"% Pozzolan"]
[null,"Plozzolan 1",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D13)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$13),0,IF(ISTEXT(S12),0,ROUND(S12/62.4/'S1'!$Q$13,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!O40),0,'S2'!$T$35)","v":0},null,"lbs"]
[null,null,null,null,null,{"$f":"IF(ISBLANK('S1'!O40),\" \",(S12+S14)/(S10+S12+S14))","v":" "}]
[null,"Plozzolan 2",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D14)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$14),0,IF(ISTEXT(S14),0,ROUND(S14/62.4/'S1'!$Q$14,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!O40),0,'S2'!$T$37)","v":0},null,"lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J17+J19","v":0},"Vol C Agg"]
["``````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"C Agg 1",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D16)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$16),0,ROUND(S17/62.4/'S1'!$Q$16,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
[null,"C Agg 2",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D17)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$17),0,ROUND(S19/62.4/'S1'!$Q$17,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[{"$f":"IF(COUNTA(S17:S19)=0,\"\",Sheet5!N17)","v":""}]
[{"$f":"Sheet5!N18","v":""}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"Water",null,{"$f":"IF(ISTEXT(S23),\" \",ROUND(S23/8.33,1))","v":0},null,null,null,null,"=",{"$f":"IF(ISTEXT(S23),0,ROUND(S23/62.4,2))","v":0},null,"Cu Ft",null," x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!O40),0,IF(ISTEXT(AC1),\" \",ROUND((S10+S12+S14)*AC1,0)))","v":0},null,"lbs"]
[]
[null,"% Air",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S2'!$C$49)","v":" "},null,"% / 100 x 27.0",null,null,"=",{"$f":"IF(ISTEXT(D25),0,ROUND(D25/100*27,2))","v":0},null,"Cu Ft",null,"Admix (solids if nec)",null,null,null,"=",{"$f":"'S1'!$Q$29","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,"Subtotal =",null,null,{"$f":"J10+J12+J14+J17+J19+J23+J25","v":0},null,"Cu Ft"]
[]
[null,"F Agg",null,{"$f":"IF(ISBLANK('S1'!O40),\" \",'S1'!D18)","v":" "},null,"27.0 - subtotal   =",null,null,null,{"$f":"IF(J27=0,0,27-J27)","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"J29*'S1'!$Q$18*62.4","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"J29+J27","v":0},null,null,null,null,null,null,null,null,{"$f":"S10+S12+S14+S17+S19+S23+S25+S29","v":0},null,"lbs"]
[]
[]
["Wt. / Volume Calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z33","v":0}]
[null,"W/C Ratio",null,{"$f":"ROUND('S1'!R40,2)","v":0},null,null,null,null,"Mix #",null,{"$f":"'S1'!R39","v":0}]
[]
[null,"Cement",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D12)","v":" "},null,null,null,null,"=",{"$f":"IF(ISTEXT(S38),0,ROUND(S38/62.4/3.15,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!R40),0,'S2'!$T$33)","v":0},null,"lbs"]
[null,null,null,null,null,"% Pozzolan"]
[null,"Plozzolan 1",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D13)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$13),0,IF(ISTEXT(S40),0,ROUND(S40/62.4/'S1'!$Q$13,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!R40),0,'S2'!$T$35)","v":0},null,"lbs"]
[null,null,null,null,null,{"$f":"IF(ISBLANK('S1'!R40),\" \",(S40+S42)/(S38+S40+S42))","v":" "}]
[null,"Plozzolan 2",null,{"$f":"'S1'!D14","v":0},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$14),0,IF(ISTEXT(S42),0,ROUND(S42/62.4/'S1'!$Q$14,2)))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"'S2'!$T$37","v":0},null,"lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J45+J47","v":0},"Vol c Agg"]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"C Agg 1",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D16)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$16),0,ROUND(S45/62.4/'S1'!$Q$16,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[]
[null,"C Agg 2",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D17)","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!$Q$17),0,ROUND(S47/62.4/'S1'!$Q$17,2))","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",null,null,"lbs"]
[{"$f":"IF(COUNTA(S45:S47)=0,\"\",Sheet5!N19)","v":""}]
[{"$f":"Sheet5!N20","v":""}]
["`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````"]
[null,"Water",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",ROUND(S51/8.33,1))","v":" "},null,null,null,null,"=",{"$f":"IF(ISBLANK('S1'!R40),0,ROUND(S51/62.4,2))","v":0},null,"Cu Ft",null," x 62.4",null,null,null,"=",{"$f":"IF(ISBLANK('S1'!R40),0,IF(ISTEXT(AC2),\"\",ROUND((S38+S40+S42)*AC2,0)))","v":0},null,"lbs"]
[]
[null,"% Air",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S2'!$C$49)","v":" "},null,"% / 100 x 27.0",null,null,"=",{"$f":"IF(ISTEXT(D53),0,ROUND(D53/100*27,2))","v":0},null,"Cu Ft",null,"Admix (solids if nec)",null,null,null,"=",{"$f":"'S1'!$Q$29","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,"Subtotal =",null,null,{"$f":"J38+J40+J42+J45+J47+J51+J53","v":0}]
[]
[null,"F Agg",null,{"$f":"IF(ISBLANK('S1'!R40),\" \",'S1'!D18)","v":" "},null,"27.0 - subtotal  =",null,null,null,{"$f":"IF(J55=0,0,27-J55)","v":0},null,"Cu Ft",null,"x S.G. x 62.4",null,null,null,"=",{"$f":"J57*'S1'!$Q$18*62.4","v":0},null,"lbs"]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"J57+J55","v":0},null,"Cu Ft",null,null,null,null,null,null,{"$f":"S38+S40+S42+S45+S47+S51+S53+S57","v":0},null,"lbs"]

{"sheet":"Sheet5","index":6,"n_rows":153,"n_cols":22,"rows_kept":153,"cut":false,"hidden":true,"merged":[[152,0,152,7],[141,0,141,1],[141,3,141,5],[141,6,141,7],[145,0,145,7],[147,0,147,7],[148,0,148,1],[148,3,148,5],[148,6,148,7],[140,0,140,7],[126,0,126,7],[127,0,127,1],[127,3,127,5],[127,6,127,7],[131,0,131,7],[121,0,121,7],[122,0,122,7],[123,0,123,7],[124,0,124,7],[133,0,133,7],[134,0,134,1],[134,3,134,5],[134,6,134,7],[138,0,138,7],[118,0,118,7],[119,0,119,7],[120,0,120,7],[94,0,94,7],[95,0,95,7],[96,0,96,7],[97,0,97,7],[98,0,98,7],[113,0,113,7],[107,0,107,7],[108,0,108,7],[109,0,109,7],[110,0,110,7],[100,0,100,7],[101,0,101,1],[101,3,101,5],[101,6,101,7],[105,0,105,7],[106,0,106,7],[111,0,111,7],[114,0,114,1],[114,3,114,5],[114,6,114,7],[87,0,87,7],[88,0,88,1],[88,3,88,5],[88,6,88,7],[92,0,92,7],[93,0,93,7],[80,0,80,7],[81,0,81,7],[82,0,82,7],[83,0,83,7],[84,0,84,7],[85,0,85,7],[72,0,72,7],[74,0,74,7],[75,0,75,1],[75,3,75,5],[75,6,75,7],[79,0,79,7],[66,0,66,7],[67,0,67,7],[68,0,68,7],[69,0,69,7],[70,0,70,7],[71,0,71,7],[59,0,59,7],[61,0,61,7],[62,0,62,1],[62,3,62,5],[62,6,62,7],[49,0,49,1],[49,3,49,5],[49,6,49,7],[53,0,53,7],[54,0,54,7],[55,0,55,7],[29,0,29,7],[32,0,32,7],[33,0,33,7],[18,0,18,7],[17,0,17,7],[30,0,30,7],[56,0,56,7],[57,0,57,7],[58,0,58,7],[31,0,31,7],[42,0,42,7],[43,0,43,7],[44,0,44,7],[45,0,45,7],[46,0,46,7],[48,0,48,7],[35,0,35,7],[36,0,36,1],[36,3,36,5],[36,6,36,7],[40,0,40,7],[41,0,41,7],[16,0,16,7],[19,0,19,7],[20,0,20,7],[21,0,21,7],[22,0,22,7],[24,0,24,7],[25,0,25,1],[25,3,25,5],[25,6,25,7],[0,0,0,7],[5,0,5,7],[11,0,11,7],[7,0,7,7],[6,0,6,7],[8,0,8,7],[9,0,9,7],[12,0,12,1],[12,3,12,5],[12,6,12,7],[1,0,1,1],[1,3,1,5],[1,6,1,7],[0,20,1,20],[0,21,1,21],[8,13,8,24],[7,13,7,24],[6,13,6,24],[5,13,5,24],[19,9,19,12],[18,13,18,24],[19,13,19,24],[7,10,7,12],[0,15,1,15],[8,10,8,12],[0,16,1,16],[9,10,9,12],[0,17,1,17],[0,18,1,18],[0,19,1,19],[5,10,5,12],[6,10,6,12],[0,13,1,13],[0,14,1,14],[14,9,14,12],[15,9,15,12],[14,13,14,24],[15,13,15,24],[16,9,16,12],[17,9,17,12],[16,13,16,24],[17,13,17,24],[18,9,18,12],[10,13,10,24],[11,13,11,24],[9,13,9,24],[12,9,12,12],[10,9,10,12],[11,9,11,12],[13,9,13,12],[12,13,12,24],[13,13,13,24]]}
["AAAP",null,null,null,null,null,null,null,1,null,{"$f":"'S1'!S1","v":"AAA"},{"$f":"IF(K1=\"AAAP\",1,IF(K1=\"AAAHPC\",2,IF(K1=\"AAA\",3,IF(K1=\"AA Slip Form Paving\",4,IF(K1=\"AA\",5,IF(K1=\"AA 7 Hr. Accl.\",6,IF(K1=\"A\",7,IF(K1=\"A Tremie\",8,IF(K1=\"C\",9,IF(K1=\"HES\",10,IF(K1=\"Flow Fill A\",11,IF(K1=\"Flow Fill B\",12,IF(K1=\"Flow Fill C\",13,IF(K1=\"Grout\",14))))))))))))))","v":3},null,"W/C","Total Cem.","First Break","28 day Break","Volume Trial","Volume Adj. 1","Volume Adj. 2","Volume Adj. 3","Volume Adj. 4"]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max",null,null,null,null,null,{"$f":"'S1'!F40","v":0.4},{"$f":"'S2'!AA23","v":600},{"$f":"IF(L1=6,'S2'!N63,'S2'!F65)","v":""},{"$f":"'S2'!T65","v":""},{"$f":"'S2'!AA40","v":0},{"$f":"'S3'!Y15","v":0},{"$f":"'S3'!Y43","v":0},{"$f":"'S4'!Y15","v":0},{"$f":"'S4'!Y43","v":0}]
[560,752,0.45490000000000003,null,3000,4500]
["Notes"]
["Exceeds max W/C ratio for a 'AAAP' mix",null,null,null,null,null,null,null,null,null,"W/C Comment",null,null,{"$f":"IF(AND($L$1=1,$N$3>$C$4),$A6,IF(AND($L$1=2,$N$3>$C$15),$A17,IF(AND($L$1=3,$N$3>$C$28),$A30,IF(AND($L$1=4,$N$3>$C$39),$A41,IF(AND($L$1=5,$N$3>$C$52),$A54,IF(AND($L$1=6,$N$3>$C$65),$A67,IF(AND($L$1=7,$N$3>$C$78),$A80,IF(AND($L$1=8,$N$3>$C$91),$A93,IF(AND($L$1=9,$N$3>$C$104),$A106,IF(AND($L$1=10,$N$3>$C$117),$A119,\"\"))))))))))","v":""}]
["Cement factor does not meet min. for a 'AAAP' mix",null,null,null,null,null,null,null,null,null,"Min. Cement Comment",null,null,{"$f":"IF(AND($L$1=1,$O$3<$A$4),$A7,IF(AND($L$1=2,$O$3<$A$15),$A18,IF(AND($L$1=3,$O$3<$A$28),$A31,IF(AND($L$1=4,$O$3<$A$39),$A42,IF(AND($L$1=5,$O$3<$A$52),$A55,IF(AND($L$1=6,$O$3<$A$65),$A68,IF(AND($L$1=7,$O$3<$A$78),$A81,IF(AND($L$1=8,$O$3<$A$91),$A94,IF(AND($L$1=9,$O$3<$A$104),$A107,IF(AND($L$1=10,$O$3<$A$117),$A120,\"\"))))))))))","v":"Cement factor does not meet min. for a 'AAA' mix"}]
["Cement factor exceeds the max. for a 'AAAP' mix",null,null,null,null,null,null,null,null,null,"Max. Cement Comment",null,null,{"$f":"IF(AND($L$1=1,$O$3>$B$4),$A8,IF(AND($L$1=2,$O$3>$B$15),$A19,IF(AND($L$1=3,$O$3>$B$28),$A32,IF(AND($L$1=4,$O$3>$B$39),$A43,IF(AND($L$1=5,$O$3>$B$52),$B56,IF(AND($L$1=6,$O$3>$B$65),$A69,IF(AND($L$1=7,$O$3>$B$78),$A82,IF(AND($L$1=8,$O$3>$B$91),$A95,IF(AND($L$1=9,$O$3>$B$104),$A108,IF(AND($L$1=10,$O$3>$B$117),$A121,\"\"))))))))))","v":""}]
["Does not meet 7 day stength requirements of 3000 psi",null,null,null,null,null,null,null,null,null,"First Break Comment",null,null,{"$f":"IF(AND($L$1=1,$P$3<$E$4),$A9,IF(AND($L$1=2,$P$3<$E$15),$A20,IF(AND($L$1=3,$P$3<$E$28),$A33,IF(AND($L$1=4,$P$3<$E$39),$A44,IF(AND($L$1=5,$P$3<$E$52),$A57,IF(AND($L$1=6,$P$3<$E$65),$A70,IF(AND($L$1=7,$P$3<$E$78),$A83,IF(AND($L$1=8,$P$3<$E$91),$A96,IF(AND($L$1=9,$P$3<$E$104),$A109,IF(AND($L$1=10,$P$3<$E$117),$A122,\"\"))))))))))","v":""}]
["Does not meet 28 day overdesign strength requirements of 4500 psi",null,null,null,null,null,null,null,null,null,"28 Day Break Comment",null,null,{"$f":"IF(AND($L$1=1,$Q$3<$F$4),$A10,IF(AND($L$1=2,$Q$3<$F$15),$A21,IF(AND($L$1=3,$Q$3<$F$28),$A34,IF(AND($L$1=4,$Q$3<$F$39),$A45,IF(AND($L$1=5,$Q$3<$F$52),$A58,IF(AND($L$1=6,$Q$3<$F$65),$A71,IF(AND($L$1=7,$Q$3<$F$78),$A84,IF(AND($L$1=8,$Q$3<$F$91),$A97,IF(AND($L$1=9,$Q$3<$F$104),$A110,IF(AND($L$1=10,$Q$3<$F$117),$A123,IF(AND($L$1=11,$Q$3>$F$130),$A132,IF(AND($L$1=12,$Q$3>$F$137),$A139,IF(AND($L$1=13,$Q$3<$F$144),$A146,IF(AND($L$1=14,$Q$3<$F$151),$A153,\"\"))))))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,"Min. Volume Trial Mix Comment",null,null,null,{"$f":"IF(AND($L$1=4,$R$3<$G$39),$A$46,IF(AND($L$1=5,$R$3<$G$52),$A$59,IF(AND($L$1=6,$R$3<$G$65),$A$72,IF(AND($L$1=7,$R$3<$G$78),$A$85,IF(AND($L$1=8,$R$3<$G$91),$A$98,IF(AND($L$1=9,$R$3<$G$104),$A$111,IF(AND($L$1=10,$R$3<$G$117),$A$124,\"\")))))))","v":""}]
["AAAHPC",null,null,null,null,null,null,null,2,"Max. Volume Trial Mix Comment",null,null,null,{"$f":"IF(AND($L$1=4,$R$3>$H$39),$A$47,IF(AND($L$1=5,$R$3>$H$52),$A$60,IF(AND($L$1=6,$R$3>$H$65),$A$73,IF(AND($L$1=7,$R$3>$H$78),$A$86,IF(AND($L$1=8,$R$3>$H$91),$A$99,IF(AND($L$1=9,$R$3>$H$104),$A$112,IF(AND($L$1=10,$R$3>$H$117),$A$125,\"\")))))))","v":""}]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume",null,null,"Min.Volume Adjusted Mix 1 Comment",null,null,null,{"$f":"IF(AND($L$1=4,$S$3<$G$39),$A$46,IF(AND($L$1=5,$S$3<$G$52),$A$59,IF(AND($L$1=6,$S$3<$G$65),$A$72,IF(AND($L$1=7,$S$3<$G$78),$A$85,IF(AND($L$1=8,$S$3<$G$91),$A$98,IF(AND($L$1=9,$S$3<$G$104),$A$111,IF(AND($L$1=10,$S$3<$G$117),$A$124,\"\")))))))","v":""}]
["Min","Max","Max","3 day","7 day","28 day","Min","Max",null,"Max.Volume Adjusted Mix 1 Comment",null,null,null,{"$f":"IF(AND($L$1=4,$S$3>$H$39),$A$47,IF(AND($L$1=5,$S$3>$H$52),$A$60,IF(AND($L$1=6,$S$3>$H$65),$A$73,IF(AND($L$1=7,$S$3>$H$78),$A$86,IF(AND($L$1=8,$S$3>$H$91),$A$99,IF(AND($L$1=9,$S$3>$H$104),$A$112,IF(AND($L$1=10,$S$3>$H$117),$A$125,\"\")))))))","v":""}]
[564,752,0.43490000000000001,null,3600,5000,null,null,null,"Min.Volume Adjusted Mix 2 Comment",null,null,null,{"$f":"IF(AND($L$1=4,$T$3<$G$39),$A$46,IF(AND($L$1=5,$T$3<$G$52),$A$59,IF(AND($L$1=6,$T$3<$G$65),$A$72,IF(AND($L$1=7,$T$3<$G$78),$A$85,IF(AND($L$1=8,$T$3<$G$91),$A$98,IF(AND($L$1=9,$T$3<$G$104),$A$111,IF(AND($L$1=10,$T$3<$G$117),$A$124,\"\")))))))","v":""}]
["Notes",null,null,null,null,null,null,null,null,"Max.Volume Adjusted Mix 2 Comment",null,null,null,{"$f":"IF(AND($L$1=4,$T$3>$H$39),$A$47,IF(AND($L$1=5,$T$3>$H$52),$A$60,IF(AND($L$1=6,$T$3>$H$65),$A$73,IF(AND($L$1=7,$T$3>$H$78),$A$86,IF(AND($L$1=8,$T$3>$H$91),$A$99,IF(AND($L$1=9,$T$3>$H$104),$A$112,IF(AND($L$1=10,$T$3>$H$117),$A$125,\"\")))))))","v":""}]
["Exceeds max W/C ratio for a 'AAAHPC' mix",null,null,null,null,null,null,null,null,"Min.Volume Adjusted Mix 3 Comment",null,null,null,{"$f":"IF(AND($L$1=4,$U$3<$G$39),$A$46,IF(AND($L$1=5,$U$3<$G$52),$A$59,IF(AND($L$1=6,$U$3<$G$65),$A$72,IF(AND($L$1=7,$U$3<$G$78),$A$85,IF(AND($L$1=8,$U$3<$G$91),$A$98,IF(AND($L$1=9,$U$3<$G$104),$A$111,IF(AND($L$1=10,$U$3<$G$117),$A$124,\"\")))))))","v":""}]
["Cement factor does not meet min. for a 'AAAHPC' mix",null,null,null,null,null,null,null,null,"Max.Volume Adjusted Mix 3 Comment",null,null,null,{"$f":"IF(AND($L$1=4,$U$3>$H$39),$A$47,IF(AND($L$1=5,$U$3>$H$52),$A$60,IF(AND($L$1=6,$U$3>$H$65),$A$73,IF(AND($L$1=7,$U$3>$H$78),$A$86,IF(AND($L$1=8,$U$3>$H$91),$A$99,IF(AND($L$1=9,$U$3>$H$104),$A$112,IF(AND($L$1=10,$U$3>$H$117),$A$125,\"\")))))))","v":""}]
["Cement factor exceeds the max. for a 'AAAHPC' mix",null,null,null,null,null,null,null,null,"Min.Volume Adjusted Mix 4 Comment",null,null,null,{"$f":"IF(AND($L$1=4,$V$3<$G$39),$A$46,IF(AND($L$1=5,$V$3<$G$52),$A$59,IF(AND($L$1=6,$V$3<$G$65),$A$72,IF(AND($L$1=7,$V$3<$G$78),$A$85,IF(AND($L$1=8,$V$3<$G$91),$A$98,IF(AND($L$1=9,$V$3<$G$104),$A$111,IF(AND($L$1=10,$V$3<$G$117),$A$124,\"\")))))))","v":""}]
["Does not meet 7 day stength requirements of 3600 psi",null,null,null,null,null,null,null,null,"Max.Volume Adjusted Mix 4 Comment",null,null,null,{"$f":"IF(AND($L$1=4,$V$3>$H$39),$A$47,IF(AND($L$1=5,$V$3>$H$52),$A$60,IF(AND($L$1=6,$V$3>$H$65),$A$73,IF(AND($L$1=7,$V$3>$H$78),$A$86,IF(AND($L$1=8,$V$3>$H$91),$A$99,IF(AND($L$1=9,$V$3>$H$104),$A$112,IF(AND($L$1=10,$V$3>$H$117),$A$125,\"\")))))))","v":""}]
["Does not meet 28 day overdesign strength requirements of 5000 psi"]
["Must be < 1200 unless approve by the DME"]
["Must be < 500 microstrain"]
[]
["AAA",null,null,null,null,null,null,null,3]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[634.5,752,0.43490000000000001,null,3600,5500]
["Notes"]
["Exceeds max W/C ratio for a 'AAA' mix"]
["Cement factor does not meet min. for a 'AAA' mix"]
["Cement factor exceeds the max. for a 'AAA' mix"]
["Does not meet 7 day stength requirements of 3600 psi"]
["Does not meet 28 day overdesign strength requirements of 5500 psi"]
[]
["AA Slip Form Paving",null,null,null,null,null,null,null,4]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[587.5,752,0.47489999999999999,null,3000,4750,11,13.1]
["Notes"]
["Exceeds max W/C ratio for a 'AA' Slip Form Paving mix"]
["Cement factor does not meet min. for a 'AA' mix"]
["Cement factor exceeds the max. for a 'AA' mix"]
["Does not meet 7 day stength requirements of 3000 psi"]
["Does not meet 28 day overdesign strength requirements of 4750 psi"]
["Does not meet min. volume requirements for a 'AA' Slip Form Paving mix"]
["Exceeds the max. volume requirements for a 'AA' Slip Form Paving mix"]
[]
["AA",null,null,null,null,null,null,null,5]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[587.5,752,0.47489999999999999,null,3000,4750,9.93,13.1]
["Notes"]
["Exceeds max W/C ratio for a 'AA' mix"]
["Cement factor does not meet min. for a 'AA' mix"]
["Cement factor exceeds the max. for a 'AA' mix"]
["Does not meet 7 day stength requirements of 3000 psi"]
["Does not meet 28 day overdesign strength requirements of 4750 psi"]
["Does not meet min. volume requirements for a 'AA' mix but can be approved according to ACI by the DME for a 'pump mix'"]
["Exceeds the max. volume requirements for a 'AA' mix"]
[]
["AA Accel. Patching",null,null,null,null,null,null,null,6]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max",null,"7 hrs.","28 day","Min","Max"]
[587.5,800,0.47489999999999999,null,1500,4750,9.93,13.1]
["Notes"]
["Exceeds max W/C ratio for a 'AA' Accel. mix"]
["Cement factor does not meet min. for a 'AA' Accel. mix"]
["Cement factor exceeds the max. for a 'AA' Accel. mix but can be approved by the DME"]
["Does not meet 7 hour stength requirements of 1500 psi"]
["Does not meet 28 day overdesign strength requirements of 4750 psi"]
["Does not meet min. volume requirements for a 'AA' Accel. mix"]
["Exceeds the max. volume requirements for a 'AA' Accel. mix"]
[]
["A",null,null,null,null,null,null,null,7]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[564,752,0.50490000000000002,null,2750,4300,10.18,13.43]
["Notes"]
["Exceeds max W/C ratio for a 'A' mix"]
["Cement factor does not meet min. for a 'A' mix"]
["Cement factor exceeds the max. for a 'A' mix"]
["Does not meet 7 day stength requirements of 2750 psi"]
["Does not meet 28 day overdesign strength requirements of 4300 psi"]
["Does not meet min. volume requirements for a 'A' mix but can be approved according to ACI by the DME for a 'pump mix'"]
["Exceeds the max. volume requirements for a 'A' mix"]
[]
["A Tremie",null,null,null,null,null,null,null,8]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[658,752,0.50490000000000002,null,2000,4300,10.18,13.43]
["Notes"]
["Exceeds max W/C ratio for a 'A' Tremie mix"]
["Cement factor does not meet min. for a 'A' Tremie mix"]
["Cement factor exceeds the max. for a 'A' Tremie mix"]
["Does not meet 7 day stength requirements of 2000 psi"]
["Does not meet 28 day overdesign strength requirements of 4300 psi"]
["Does not meet min. volume requirements for a 'A' Tremie mix"]
["Exceeds the max. volume requirements for a 'A' Tremie mix"]
[]
["C",null,null,null,null,null,null,null,9]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[394.8,658,0.66490000000000005,null,1500,2900,11.45,15.1]
["Notes"]
["Exceeds max W/C ratio for a 'C' mix"]
["Cement factor does not meet min. for a 'C' mix"]
["Cement factor exceeds the max. for a 'C' mix"]
["Does not meet 7 day stength requirements of 1500 psi"]
["Does not meet 28 day overdesign strength requirements of 2900 psi"]
["Does not meet min. volume requirements for a 'C' mix"]
["Exceeds the max. volume requirements for a 'C' mix"]
[]
["HES",null,null,null,null,null,null,null,10]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max",null,"3 day","28 day","Min","Max"]
[752,846,0.40489999999999998,null,3000,4750,9.1,12]
["Notes"]
["Exceeds max W/C ratio for a 'HES' mix"]
["Cement factor does not meet min. for a 'HES' mix"]
["Cement factor exceeds the max. for a 'HES' mix"]
["Does not meet 3 day stength requirements of 3000 psi"]
["Does not meet 28 day overdesign strength requirements of 4750 psi"]
["Does not meet min. volume requirements for a 'HES' mix"]
["Exceeds the max. volume requirements for a 'HES' mix"]
[]
["Flow Fill A",null,null,null,null,null,null,null,11]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[null,null,null,null,null,125]
["Notes"]
["Exceeds 28 day strength requirements of 125 psi."]
[]
["Flow Fill B",null,null,null,null,null,null,null,12]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[null,null,null,null,null,125]
["Notes"]
["Exceeds 28 day strength requirements of 125 psi."]
[]
["Flow Fill C",null,null,null,null,null,null,null,13]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[null,null,null,null,null,800]
["Notes"]
["Does not meet 28 day overdesign strength requirements of 800 psi"]
[]
["Grout",null,null,null,null,null,null,null,14]
["Cement Factor",null,"W/C ratio","PSI overdesign",null,null,"Volume"]
["Min","Max","Max","3 day","7 day","28 day","Min","Max"]
[null,null,null,null,null,2500]
["Notes"]
["Does not meet 28 day strength requirements of 2500 psi"]