{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Proportion Tool","Combined Gradation","Volume Calculator"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Proportion Tool","index":0,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[11,7,11,8],[5,3,6,3],[5,4,6,4],[4,3,4,4],[2,0,3,6],[5,7,6,7],[5,8,6,8],[4,7,4,8],[22,11,25,11],[22,12,25,12],[21,11,21,12],[5,12,6,12],[4,11,4,12],[5,11,6,11],[12,7,14,7],[12,8,14,8],[21,3,21,4],[22,3,25,3],[22,4,25,4],[22,7,22,8]]}
[]
[]
["SCC Paste vs. Aggregate Volumetric Proportioning Tool"]
[]
[null,null,null,"Paste",null,null,null,"Reference Mix",null,null,null,"Paste"]
[null,null,null,"Volume [cf]","Percent Paste Volume [%]",null,null,"Volume [cf]","Percent Total Volume [cf]",null,null,"Volume [cf]","Percent Paste Volume [%]"]
[]
[null,null,"Air",1.19,{"$f":"D8/$D$20*100","v":10.313388338071135},{"$f":"D8/D35*100","v":4.4705917711057017},"Paste",{"$f":"D20","v":11.538399999999999},{"$f":"H8/$H$10*100","v":43.3474589006101},null,"Air",{"$f":"D8","v":1.19},{"$f":"L8/L20*100","v":9.6348960584174606},null,{"$f":"100-F8","v":95.529408228894297},{"$f":"100-F8","v":95.529408228894297}]
[null,null,"Water",5.74,49.746931983637246,null,"Aggregate",{"$f":"D33","v":15.079999999999998},{"$f":"H9/$H$10*100","v":56.6525410993899},null,"Water",{"$f":"M9/100*$L$20","v":6.1906943898573674},{"$f":"N9*$M$19","v":50.123274769499027},{"$f":"E9/$E$19","v":0.55467511885895404},{"$f":"I16/100*O8","v":44.325645418206953},{"$f":"I8/100*P8","v":41.409570970015999}]
[null,null,"Cement",3.5,30.333495111973935,null,"Total Volume (Yield)",{"$f":"SUM(D20,D33)","v":26.618399999999998},null,null,"Cement",{"$f":"M10/100*$L$20","v":3.7748136523520537},{"$f":"N10*$M$19","v":30.562972420426238},{"$f":"E10/$E$19","v":0.33821653588960615},{"$f":"I17/100*O8","v":51.203762810687344},{"$f":"I9/100*P8","v":54.119837258878299}]
[null,null,"SCM 1",1.05,9.1000485335921795,null,null,null,null,null,"SCM 1",1.1324440957056161,9.1688917261278711,0.10146496076688184,{"$f":"100-SUM(O9:O10)","v":4.4705917711057026}]
[null,null,"SCM 2",0,0,null,null,"New Mix",null,null,"SCM 2",0,0,0]
[null,null,"SCM 3",0,0,null,null,"Volume [cf]","Percent Total Volume",null,"SCM 3",0,0,0]
[null,null,"Admixture 1",6.1999999999999998E-3,5.3733619912639544E-2,null,null,null,null,null,"Admixture 1",6.6868127555950669E-3,5.4140122573326482E-2,5.9912643500444518E-4]
[null,null,"Admixture 2",5.2200000000000003E-2,0.45240241281286836,null,null,null,null,null,"Admixture 2",5.629864932936491E-2,0.45582490295607131,5.0442580495535542E-3]
[null,null,"Admixture 3",0,0,null,"Paste",{"$f":"(I16/100)*H18","v":12.350937599999998},{"$f":"$I$24/10","v":46.4},null,"Admixture 3",0,0,0]
[null,null,"Admixture 4",0,0,null,"Aggregate",{"$f":"(I17/100)*H18","v":14.267462399999999},{"$f":"100-$I$25","v":53.6},null,"Admixture 4",0,0,0]
[null,null,"Admixture 5",0,0,null,"Total Volume (Yield)",{"$f":"H10","v":26.618399999999998},null,null,"Admixture 5",0,0,0]
[null,null,null,null,{"$f":"100-E8","v":89.686611661928865},null,null,null,null,null,null,null,{"$f":"100-M8","v":90.365103941582532}]
[null,null,"Total Paste",{"$f":"SUM(D8:D18)","v":11.538399999999999},{"$f":"SUM(E8:E17)","v":100.00000000000001},null,null,null,null,null,"Total Paste",{"$f":"H16","v":12.350937599999998},{"$f":"SUM(M8:M18)","v":99.999999999999986}]
[]
[null,null,null,"Aggregate",null,null,null,null,null,null,null,"Aggregate"]
[null,null,null,"Volume [cf]","Percent Aggregate Volume [%]",null,null,{"$f":"IF(I16>I8,\"Faster V-Funnel Time\",IF(I16<I8,\"Slower V-Funne Time\",\"\"))","v":"Faster V-Funnel Time"},null,null,null,"Volume [cf]","Percent Aggregate Volume [%]"]
[null,null,null,null,null,null,null,"Scroll Value",464]
[null,null,null,null,null,null,null,"Scroll Paste Percentage",{"$f":"$I$24/10","v":46.4}]
[null,null,null,null,null,null,null,"Scroll Aggregate Percentage",{"$f":"100-$I$25","v":53.6}]
[null,null,"Aggregate 1",8.61,{"$f":"D27/$D$33*100","v":57.095490716180372},null,null,null,null,null,"Aggregate 1",{"$f":"(M27/100)*$L$33","v":8.1460776700265249},{"$f":"E27","v":57.095490716180372}]
[null,null,"Aggregate 2",0,{"$f":"D28/$D$33*100","v":0},null,null,null,null,null,"Aggregate 2",{"$f":"(M28/100)*$L$33","v":0},{"$f":"E28","v":0}]
[null,null,"Aggregate 3",0,{"$f":"D29/$D$33*100","v":0},null,null,null,null,null,"Aggregate 3",{"$f":"(M29/100)*$L$33","v":0},{"$f":"E29","v":0}]
[null,null,"Aggregate 4",0,{"$f":"D30/$D$33*100","v":0},null,null,null,null,null,"Aggregate 4",{"$f":"(M30/100)*$L$33","v":0},{"$f":"E30","v":0}]
[null,null,"Aggregate 5",6.47,{"$f":"D31/$D$33*100","v":42.904509283819628},null,null,null,null,null,"Aggregate 5",{"$f":"(M31/100)*$L$33","v":6.1213847299734745},{"$f":"E31","v":42.904509283819628}]
[]
[null,null,"Total Aggregate",{"$f":"SUM(D27:D31)","v":15.079999999999998},{"$f":"SUM(E27:E31)","v":100},null,null,null,null,null,"Total Aggregate",{"$f":"H17","v":14.267462399999999},100]
[]
[null,null,"Total Volume (Yield)",{"$f":"SUM(D20,D33)","v":26.618399999999998},null,null,null,null,null,null,"Total Volume (Yield)",{"$f":"SUM(L20,L33)","v":26.618399999999998}]

{"sheet":"Combined Gradation","index":1,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,5,8,5],[7,0,8,0],[2,0,3,5],[5,1,5,5],[5,6,5,7],[9,0,10,0],[6,6,10,6],[6,7,10,7],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5]]}
[]
[]
["Aggregate Volumetric Proportioning Tool"]
[]
[]
[null,"Individual Aggregate Percent Passing",null,null,null,null,"Combined Gradation"]
[null,"Aggregate 1","Aggregate 2","Aggregate 3","Aggregate 4","Aggregate 5","Percent Passing","Percent Retained"]
["Material Name","No. 67","No. 89",null,null,"Sand"]
[]
[{"$f":"\"Volumetric Percentage (\"&ROUND(SUM(B10:F11),2)&\"%)\"","v":"Volumetric Percentage (100%)"},58,0,0,0,42]
[null,null,null,null,null,null,null,null,"upper","lower"]
["1.5\"",100,100,100,100,100,{"$f":"((B12/100)*(B$10/100)+(C12/100)*(C$10/100)+(D12/100)*(D$10/100)+(E12/100)*(E$10/100)+(F12/100)*(F$10/100))*100","v":100},{"$f":"IF(SUM(B10,C10,D10,E10,F10)<>100,0,100-G12)","v":0},0,-1]
["1.0\"",100,100,100,100,100,{"$f":"((B13/100)*(B$10/100)+(C13/100)*(C$10/100)+(D13/100)*(D$10/100)+(E13/100)*(E$10/100)+(F13/100)*(F$10/100))*100","v":100},{"$f":"G12-G13","v":0},1,-1]
["3/4\"",98.8,100,100,100,100,99.303999999999988,{"$f":"G13-G14","v":0.69600000000001216},2,-1]
["1/2\"",63.5,100,100,100,100,78.83,20.47399999999999,17.5,10]
["3/8\"",35.9,86.04,100,100,100,62.822000000000003,16.007999999999996,17.5,10]
["#4",4.9000000000000004,62.36,98,95.31,99.9,44.800000000000004,18.021999999999998,30,23]
["#8",2.2000000000000002,15.99,89,77.84,98.4,42.604000000000006,2.195999999999998,20,12.5]
["#16",0,7.26,79,61.94,87.5,36.75,5.8540000000000063,14,6]
["#30",0,2,59,42.12,60.1,25.241999999999997,11.508000000000003,13,5]
["#50",0,2,18,12.73,26.6,11.172000000000001,14.069999999999997,13,5]
["#100",0,1.58,4,1.39,4,1.68,9.4920000000000009,7,3]
["#200",0.8,0.1,1.6,0.5,0.25,0.56899999999999995,1.111,4,0]
[null,{"$f":"SUM(B10:F11)","v":100}]

{"sheet":"Volume Calculator","index":2,"n_rows":71,"n_cols":8,"rows_kept":71,"cut":false,"hidden":false,"merged":[[2,0,3,6],[11,0,11,5],[12,0,12,5]]}
[]
[]
["Mix Design Volume Calculator"]
[]
[]
[null,null,null,null,null,"Entrained / Entrapped Air",4.5,"% Total Volume"]
[null,null,null,null,null,"Entrained / Entrapped Air Volume =",{"$f":"G9-SUM(G13,G17,G21,G25,G29,G35,G39,G43,G47,G51,G55,G59,G63,G67,G71)","v":1.2145198095250684}]
[]
[null,null,null,null,null,{"$f":"\"Total Volume =\"","v":"Total Volume ="},{"$f":"SUM(G13,G17,G21,G25,G29,G35,G39,G43,G47,G51,G55,G59,G63,G67,G71)/(1-(G6/100))","v":26.989329100557068},"cf"]
[]
[null,null,null,null,null,"Water Volume",43,"gal"]
[{"$f":"\"Water Mass = \"&ROUND(G11,2)&\"* 8.33 =\"","v":"Water Mass = 43* 8.33 ="},null,null,null,null,null,{"$f":"G11*8.33","v":358.19},"lb"]
[{"$f":"\"Water Volume =\"&ROUND(G12,2)&\"/(1.0*62.43) =\"","v":"Water Volume =358.19/(1.0*62.43) ="},null,null,null,null,null,{"$f":"G12/(62.43)","v":5.7374659618773025},"cf"]
[]
[null,null,null,null,null,"Cement Mass",688,"lb"]
[null,null,null,null,null,"Cement SG",3.15]
[null,null,null,null,null,{"$f":"\"Cement Volume = \"&ROUND(G15,2)&\"/(\"&G16&\"*62.43) =\"","v":"Cement Volume = 688/(3.15*62.43) ="},{"$f":"G15/(G16*62.43)","v":3.4985215187041234},"cf"]
[]
[null,null,null,null,null,"SCM1 Mass",206,"lb"]
[null,null,null,null,null,"SCM1 SG",2.27]
[null,null,null,null,null,{"$f":"\"SCM1 Volume = \"&ROUND(G19,2)&\"/(\"&G20&\"*62.43) =\"","v":"SCM1 Volume = 206/(2.27*62.43) ="},{"$f":"G19/(G20*62.43)","v":1.4536104225278565},"cf"]
[]
[null,null,null,null,null,"SCM2 Mass",0,"lb"]
[null,null,null,null,null,"SCM2 SG",3.15]
[null,null,null,null,null,{"$f":"\"SCM2 Volume = \"&ROUND(G23,2)&\"/(\"&G24&\"*62.43) =\"","v":"SCM2 Volume = 0/(3.15*62.43) ="},{"$f":"G23/(G24*62.43)","v":0},"cf"]
[]
[null,null,null,null,null,"SCM3 Mass",{"$f":"-G270","v":0},"lb"]
[null,null,null,null,null,"SCM3 SG",3.15]
[null,null,null,null,null,{"$f":"\"SCM3 Volume = \"&ROUND(G27,2)&\"/(\"&G28&\"*62.43) =\"","v":"SCM3 Volume = 0/(3.15*62.43) ="},{"$f":"G27/(G28*62.43)","v":0},"cf"]
[]
[null,null,null,null,null,{"$f":"\"cwt = \"&\"\"","v":"cwt = "},{"$f":"SUM(G15,G19,G23,G27)/100","v":8.94}]
[]
[null,null,null,null,null,"Admixture 1 Dose =",0,"fl oz/cwt"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&ROUND(G33,2)&\" * \"&$G$31&\" =\"","v":"Admixture 1 Volume = 0 * 8.94 ="},{"$f":"G33*$G$31","v":0},"fl oz"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&G34&\" [fl oz] * 0.00104438 [cf / fl oz] =\"","v":"Admixture 1 Volume = 0 [fl oz] * 0.00104438 [cf / fl oz] ="},{"$f":"G34*0.00104438","v":0},"cf"]
[]
[null,null,null,null,null,"Admixture 1 Dose =",0,"fl oz/cwt"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&ROUND(G37,2)&\" * \"&$G$31&\" =\"","v":"Admixture 1 Volume = 0 * 8.94 ="},{"$f":"G37*$G$31","v":0},"fl oz"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&G38&\" [fl oz] * 0.00104438 [cf / fl oz] =\"","v":"Admixture 1 Volume = 0 [fl oz] * 0.00104438 [cf / fl oz] ="},{"$f":"G38*0.00104438","v":0},"cf"]
[]
[null,null,null,null,null,"Admixture 1 Dose =",0,"fl oz/cwt"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&ROUND(G41,2)&\" * \"&$G$31&\" =\"","v":"Admixture 1 Volume = 0 * 8.94 ="},{"$f":"G41*$G$31","v":0},"fl oz"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&G42&\" [fl oz] * 0.00104438 [cf / fl oz] =\"","v":"Admixture 1 Volume = 0 [fl oz] * 0.00104438 [cf / fl oz] ="},{"$f":"G42*0.00104438","v":0},"cf"]
[]
[null,null,null,null,null,"Admixture 1 Dose =",0,"fl oz/cwt"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&ROUND(G45,2)&\" * \"&$G$31&\" =\"","v":"Admixture 1 Volume = 0 * 8.94 ="},{"$f":"G45*$G$31","v":0},"fl oz"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&G46&\" [fl oz] * 0.00104438 [cf / fl oz] =\"","v":"Admixture 1 Volume = 0 [fl oz] * 0.00104438 [cf / fl oz] ="},{"$f":"G46*0.00104438","v":0},"cf"]
[]
[null,null,null,null,null,"Admixture 1 Dose =",0,"fl oz/cwt"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&ROUND(G49,2)&\" * \"&$G$31&\" =\"","v":"Admixture 1 Volume = 0 * 8.94 ="},{"$f":"G49*$G$31","v":0},"fl oz"]
[null,null,null,null,null,{"$f":"\"Admixture 1 Volume = \"&G50&\" [fl oz] * 0.00104438 [cf / fl oz] =\"","v":"Admixture 1 Volume = 0 [fl oz] * 0.00104438 [cf / fl oz] ="},{"$f":"G50*0.00104438","v":0},"cf"]
[]
[null,null,null,null,null,"Aggregate 1 Mass",1500,"lb"]
[null,null,null,null,null,"Aggregate 1 SG",2.79]
[null,null,null,null,null,{"$f":"\"Aggregate 1 Volume = \"&ROUND(G53,2)&\"/(\"&G54&\"*62.43) =\"","v":"Aggregate 1 Volume = 1500/(2.79*62.43) ="},{"$f":"G53/(G54*62.43)","v":8.6117957488731474},"cf"]
[]
[null,null,null,null,null,"Aggregate 2 Mass",0,"lb"]
[null,null,null,null,null,"Aggregate 2 SG",2.71]
[null,null,null,null,null,{"$f":"\"Aggregate 2 Volume = \"&ROUND(G57,2)&\"/(\"&G58&\"*62.43) =\"","v":"Aggregate 2 Volume = 0/(2.71*62.43) ="},{"$f":"G57/(G58*62.43)","v":0},"cf"]
[]
[null,null,null,null,null,"Aggregate 3 Mass",0,"lb"]
[null,null,null,null,null,"Aggregate 3 SG",2.64]
[null,null,null,null,null,{"$f":"\"Aggregate 3 Volume = \"&ROUND(G61,2)&\"/(\"&G62&\"*62.43) =\"","v":"Aggregate 3 Volume = 0/(2.64*62.43) ="},{"$f":"G61/(G62*62.43)","v":0},"cf"]
[]
[null,null,null,null,null,"Aggregate 4 Mass",0,"lb"]
[null,null,null,null,null,"Aggregate 4 SG",2.61]
[null,null,null,null,null,{"$f":"\"Aggregate 4 Volume = \"&ROUND(G65,2)&\"/(\"&G66&\"*62.43) =\"","v":"Aggregate 4 Volume = 0/(2.61*62.43) ="},{"$f":"G65/(G66*62.43)","v":0},"cf"]
[]
[null,null,null,null,null,"Aggregate 5 Mass",1075,"lb"]
[null,null,null,null,null,"Aggregate 5 SG",2.66]
[null,null,null,null,null,{"$f":"\"Aggregate 5 Volume = \"&ROUND(G69,2)&\"/(\"&G70&\"*62.43) =\"","v":"Aggregate 5 Volume = 1075/(2.66*62.43) ="},{"$f":"G69/(G70*62.43)","v":6.4734156390495698},"cf"]