{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Intro","Basic Info","Mix Design","Amount Required","Batch Weights"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Intro","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,13]]}
[]
[null,"In this spreadsheet, the cells are not locked, but the file is set as Read Only. (To change this, right click on the file in File Explorer and click on Properties). When you make changes and save the file, you would save it with a new name. That way, your master file remains unchanged. In the Basic Info sheet, enter your costs in the green cells. The Mix Design sheet will keep the volume at 1 cf. This is why you do not enter the sand value on the mix design sheet, this is a calculated value to hold the total at 1 cf. Play with the number in green on the Mix Design sheet and watch the sand value change. Keep about a 50-50 sand cementitious ratio. Once you have a mix design for a specific project you will only use the Amount Required and the Batch Weights sheets for batching. In the Batch Sheet, adjust the cubic feet to give an even number of batches. Print a batch sheet of  the batch weights page and you're ready to go! Please feel free to contact me with any questions about Trinic's products, we're very proud of what we've developed. Good casting."]
[null,"Revised by Gadsby Concrete Designs",null,null,null,"info@gadsbyconcrete.com"]
[]
[null,"Original by "]
[]
[null,"Mark Celebuski"]
[null,"mark@trinic.us"]
[null,"www.trinic.us"]
[null,"Office: 800-475-1975"]
[null,"Cell: 717-823-7408"]
[]
[null,"Like us on Facebook and visit our YouTube page for continuing education."]
[null,"http://www.facebook.com/pages/Trinic-LLC/317203778314580"]
[null,"https://www.youtube.com/user/TrinicLLC/featured"]

{"sheet":"Basic Info","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,2,3],[28,0,30,1]]}
["Trinic GFRC Mix Designs"]
[]
[null,null,null,null,null,"Rev. Date","2018-07-04"]
["Enter data in green cells in the spreadsheet"]
["Enter basic data below - other sheets will use this data"]
["Material","Specific Gravity","Cost/bag/pail","Cost/lb"]
["Portland Cement",3.15,29,{"$f":"C7/80","v":0.36249999999999999}]
["CSA Cement",3,45,{"$f":"C8/50","v":0.9}]
["Silica Fume",2.62,95,{"$f":"C9/50","v":1.9}]
["Sand",2.65,8,{"$f":"C10/50","v":0.16}]
[]
["Trinic Admixtures","Cost / lb"]
["Trinic GFRC / Tec10 Admix",{"$f":"306/25","v":12.24}]
["Trinic Plastisicer",{"$f":"306/25","v":12.24}]
["Glass Fiber 3/4\" or 1/2\"",{"$f":"93/20","v":4.6500000000000004}]
["HD 3mm",{"$f":"132/40","v":3.3}]
["Trinic Hydration Stablizer",{"$f":"129/25","v":5.16}]
["Trinic Stage II Accelerator",3.8]
["CS Additive ",8.5]
[]
["Intergral Colors ↓","Cost / lb "]
["White"]
["Black"]
["Cinder"]
["Brown"]
["Gray"]
["Cobalt Blue"]
[]
["Different Color? Simply Change the name and the price and the spreadsheet will do the rest "]

{"sheet":"Mix Design","index":2,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[4,4,4,6],[4,7,4,9],[1,0,2,1],[1,3,2,7],[5,5,5,6]]}
[]
["Mix Name",null,null,"BackerCoat "]
[]
[null,null,null,null,null,null,null,{"$f":"'Basic Info'!$C$3","v":0}]
["Last Revision"]
[{"$f":"'Basic Info'!$G$3","v":"2018-07-04"},"SSD wt","Percentage","S.G.","Abs vol","Batch Weight (lbs.)",null,"SSD Cost","Mix Name:",null,{"$f":"D2","v":"BackerCoat "}]
[{"$f":"'Basic Info'!A7","v":"Portland Cement"},55.56,null,{"$f":"'Basic Info'!B7","v":3.15},{"$f":"B7/62.4/D7","v":0.28266178266178271},{"$f":"B7","v":55.56},null,{"$f":"F7*'Basic Info'!$D$7","v":20.140499999999999}]
[{"$f":"'Basic Info'!A8","v":"CSA Cement"},{"$f":"K9*B7","v":0},null,{"$f":"'Basic Info'!B8","v":3},{"$f":"B8/62.4/D8","v":0},{"$f":"B8","v":0},null,{"$f":"F8*'Basic Info'!$D$8","v":0},null,"DesiredYield",1,"ft^3"]
[{"$f":"'Basic Info'!A9","v":"Silica Fume"},{"$f":"K11*B7","v":5.5560000000000009},null,{"$f":"'Basic Info'!B9","v":2.62},{"$f":"B9/62.4/D9","v":3.3984145625367002E-2},{"$f":"B9","v":5.5560000000000009},null,{"$f":"F9*'Basic Info'!$D$9","v":10.556400000000002},null,"CSA % of Port",0]
["Total Cementious ",{"$f":"SUM(B7:B9)","v":61.116},{"$f":"B10/(B10+B11)","v":0.50004496240714336}]
[{"$f":"'Basic Info'!A10","v":"Sand"},{"$f":"E11*(D11*62.4)","v":61.105009298436912},{"$f":"B11/(B11+B10)","v":0.4999550375928567},{"$f":"'Basic Info'!B10","v":2.65},{"$f":"K8-E7-E8-E9-E12-E14","v":0.36952714863592717},{"$f":"B11","v":61.105009298436912},null,{"$f":"F11*'Basic Info'!$D$10","v":9.7768014877499052},null,"S F % of Port",0.1]
["Water ",{"$f":"K13*(B9+B8+B7)","v":18.334799999999998},null,1,{"$f":"B12/62.4","v":0.29382692307692304},{"$f":"B12","v":18.334799999999998},null,null,null,"Tot. Weight",{"$f":"B7+B8+B9+B11+B12+F16+F17+F18+F20+F21+F24+F25+F26+F27+F28+F29","v":146.05591957739003},"lbs"]
[null,null,null,null,null,null,null,null,null,"Wat/Cem",0.3]
["Air %",2,null,null,{"$f":"(B14/100)*K8","v":0.02},null,null,null,null,"Unit Wt",{"$f":"K12/K8","v":146.05591957739003},"pcf"]
[]
[{"$f":"'Basic Info'!A13","v":"Trinic GFRC / Tec10 Admix"},null,"% of Cementitious",3,"lbs. / cf",{"$f":"((D16*(F7+F8+F9))/100)","v":1.8334800000000002},{"$f":"F16*'Basic Info'!$B$13","v":22.441795200000001}]
[{"$f":"'Basic Info'!A14","v":"Trinic Plastisicer"},null,"% of Cementitious",null,"lbs. / cf",{"$f":"((D17*(F7+F8+F9))/100)","v":0},{"$f":"F17*'Basic Info'!$B$14","v":0},null,"Cost / cf",{"$f":"SUM(H7:H14,G16:G29)","v":79.965327484881854}]
[{"$f":"'Basic Info'!A15","v":"Glass Fiber 3/4\" or 1/2\""},null,"% of Total Batch lbs. ",3,"lbs. / cf",{"$f":"((D18*(F7+F8+F9+F11))/100)","v":3.6666302789531073},{"$f":"F18*'Basic Info'!$B$15","v":17.04983079713195},null,"sq. ft. 3/4\"",{"$f":"J17/16","v":4.9978329678051159}]
[{"$f":"'Basic Info'!A16","v":"HD 3mm"},null,"% of Total Batch lbs. ",0,"lbs. / cf",{"$f":"((D19*(F7+F8+F9+F11))/100)","v":0},{"$f":"F19*'Basic Info'!B16","v":0}]
[{"$f":"'Basic Info'!A17","v":"Trinic Hydration Stablizer"},null,"% of Cementitious",null,"lbs. / cf",{"$f":"((D20*(F7+F8+F9))/100)","v":0},{"$f":"F20*'Basic Info'!B17","v":0}]
[{"$f":"'Basic Info'!A18","v":"Trinic Stage II Accelerator"},null,"% of Cementitious",null,"lbs. / cf",{"$f":"((D21*(F7+F8+F9))/100)","v":0},{"$f":"(F21)*'Basic Info'!$B$18","v":0}]
["CS Additive ",null,"% Replacement of Water",0,"lbs. / cf",{"$f":"D22*B12","v":0},{"$f":"F22*'Basic Info'!B19","v":0}]
["Intergral Color ↓"]
[{"$f":"'Basic Info'!A22","v":"White"},null,"% of Cementitious",null,"lbs. / cf",{"$f":"((D24*(F7+F8+F9))/100)","v":0},{"$f":"F24*'Basic Info'!B22","v":0}]
[{"$f":"'Basic Info'!A23","v":"Black"},null,"% of Cementitious",null,"lbs. / cf",{"$f":"((D25*(F7+F8+F9))/100)","v":0},{"$f":"F25*'Basic Info'!B23","v":0}]
[{"$f":"'Basic Info'!A24","v":"Cinder"},null,"% of Cementitious",null,"lbs. / cf",{"$f":"((D26*(F7+F8+F9))/100)","v":0},{"$f":"F26*'Basic Info'!B24","v":0}]
[{"$f":"'Basic Info'!A25","v":"Brown"},null,"% of Cementitious",null,"lbs. / cf",{"$f":"((D27*(F7+F8+F9))/100)","v":0},{"$f":"F27*'Basic Info'!B25","v":0}]
[{"$f":"'Basic Info'!A26","v":"Gray"},null,"% of Cementitious",null,"lbs. / cf",{"$f":"((D28*(F7+F8+F9))/100)","v":0},{"$f":"F28*'Basic Info'!B26","v":0}]
[{"$f":"'Basic Info'!A27","v":"Cobalt Blue"},null,"% of Cementitious",null,"lbs. / cf",{"$f":"((D29*(F7+F8+F9)/100))","v":0},{"$f":"F29*'Basic Info'!B27","v":0}]
[]
[]
[null,null,null,null,0]

{"sheet":"Amount Required","index":3,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,2,5]]}
["Fill in Green Cells"]
[]
[]
[]
[]
["Amout Required"]
["Depth",0.75,"inches"]
["Piece #","Length(in)","Width(in)","# of Pieces","CF Required","Weight"]
[1,12,12,1,{"$f":"((B9/12)*(C9/12))*(B7/12)*D9","v":6.25E-2},{"$f":"E9*'Mix Design'!K14","v":9.1284949735868768}]
[2,null,null,null,{"$f":"((B10/12)*(C10/12))*(B7/12)*D10","v":0},{"$f":"E10*'Mix Design'!K14","v":0}]
[3,null,null,null,{"$f":"((B11/12)*(C11/12))*(B7/12)*D11","v":0},{"$f":"E11*'Mix Design'!K14","v":0}]
[4,null,null,null,{"$f":"((B12/12)*(C12/12))*(B7/12)*D12","v":0},{"$f":"E12*'Mix Design'!K14","v":0}]
[5,null,null,null,{"$f":"((B13/12)*(C13/12))*(B7/12)*D13","v":0},{"$f":"E13*'Mix Design'!K14","v":0}]
[6,null,null,null,{"$f":"((B14/12)*(C14/12))*(B7/12)*D14","v":0},{"$f":"E14*'Mix Design'!K14","v":0}]
[7,null,null,null,{"$f":"((B15/12)*(C15/12))*(B7/12)*D15","v":0},{"$f":"E15*'Mix Design'!K14","v":0}]
[8,null,null,null,{"$f":"((B16/12)*(C16/12))*(B7/12)*D16","v":0},{"$f":"E16*'Mix Design'!K14","v":0}]
[9,null,null,null,{"$f":"((B17/12)*(C17/12))*(B7/12)*D17","v":0},{"$f":"E17*'Mix Design'!K14","v":0}]
["Opening",null,null,null,{"$f":"(((B18/12)*(C18/12))*(B7/12))*-1*D18","v":0},{"$f":"E18*'Mix Design'!K14","v":0}]
["Opening",null,null,null,{"$f":"(((B19/12)*(C19/12))*(B7/12))*-1*D19","v":0},{"$f":"E19*'Mix Design'!K14","v":0}]
[null,null,"Concrete Sink",null,null,{"$f":"E20*'Mix Design'!K14","v":0}]
[null,null,"Concrete Sink",null,null,{"$f":"E21*'Mix Design'!K14","v":0}]
[null,null,"Total cf",null,{"$f":"SUM(E9:E20)","v":6.25E-2},{"$f":"SUM(F9:F21)","v":9.1284949735868768}]
[null,null,"Total cf + 5%",null,{"$f":"E22*1.05","v":6.5625000000000003E-2}]
[null,null,"Cost $ - ",{"$f":"E23*'Mix Design'!J17","v":5.2477246161953719}]

{"sheet":"Batch Weights","index":4,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,5],[1,4,2,4],[1,5,2,5]]}
[]
[null,"Mix Name",{"$f":"'Mix Design'!K6","v":"BackerCoat "},null,"Number of Batches Needed",{"$f":"C5/F5","v":0.1640625}]
[]
[null,"Total Project Requirements (lbs.)",null,null,"Batch Weights (lbs.)"]
[null,"Total CF",{"$f":"'Amount Required'!E23","v":6.5625000000000003E-2},null,"Batch Size (CF)",0.4]
[null,{"$f":"'Mix Design'!A7","v":"Portland Cement"},{"$f":"'Mix Design'!F7*C5","v":3.6461250000000005},null,{"$f":"B6","v":"Portland Cement"},{"$f":"F5*'Mix Design'!F7","v":22.224000000000004}]
[null,{"$f":"'Mix Design'!A8","v":"CSA Cement"},{"$f":"'Mix Design'!F8*C5","v":0},null,"CSA Cement",{"$f":"F5*'Mix Design'!F8","v":0}]
[null,{"$f":"'Mix Design'!A9","v":"Silica Fume"},{"$f":"'Mix Design'!F9*C5","v":0.36461250000000006},null,"Silica Fume",{"$f":"F5*'Mix Design'!F9","v":2.2224000000000004}]
[null,{"$f":"'Mix Design'!A11","v":"Sand"},{"$f":"'Mix Design'!F11*C5","v":4.0100162352099229},null,"Sand",{"$f":"F5*'Mix Design'!F11","v":24.442003719374767}]
[null,{"$f":"'Mix Design'!A12","v":"Water "},{"$f":"('Mix Design'!F12*C5) - C17","v":1.2032212499999999},null,"Water ",{"$f":"(F5*'Mix Design'!F12)-F17","v":7.3339199999999991}]
[null,{"$f":"'Mix Design'!A16","v":"Trinic GFRC / Tec10 Admix"},{"$f":"'Mix Design'!F16*C5","v":0.12032212500000002},null,"Trinic GFRC / Tec10 Admix",{"$f":"F5*'Mix Design'!F16","v":0.73339200000000015}]
[null,{"$f":"'Mix Design'!A17","v":"Trinic Plastisicer"},{"$f":"'Mix Design'!F17*C5","v":0},null,"Trinic Plastisicer",{"$f":"F5*'Mix Design'!F17","v":0}]
[null,{"$f":"'Mix Design'!A18","v":"Glass Fiber 3/4\" or 1/2\""},{"$f":"'Mix Design'!F18*C5","v":0.24062261205629767},null,"Glass Fiber 3/4\" or 1/2\"",{"$f":"F5*'Mix Design'!F18","v":1.466652111581243}]
[null,{"$f":"'Mix Design'!A19","v":"HD 3mm"},{"$f":"C5*'Mix Design'!F19","v":0},null,{"$f":"'Mix Design'!A19","v":"HD 3mm"},{"$f":"F5*'Mix Design'!F19","v":0}]
[null,{"$f":"'Mix Design'!A20","v":"Trinic Hydration Stablizer"},{"$f":"C5*'Mix Design'!F20","v":0},null,"Trinic Hydration Stablizer",{"$f":"F5*'Mix Design'!F20","v":0}]
[null,{"$f":"'Mix Design'!A21","v":"Trinic Stage II Accelerator"},{"$f":"C5*'Mix Design'!F21:F21","v":0},null,"Trinic Stage II Accelerator",{"$f":"F5*'Mix Design'!F21","v":0}]
[null,{"$f":"'Mix Design'!A22","v":"CS Additive "},{"$f":"C5*'Mix Design'!F22","v":0},null,{"$f":"'Mix Design'!A22","v":"CS Additive "},{"$f":"F5*'Mix Design'!F22","v":0}]
[null,"Intergral Colors ↓ ",null,null,"Intergral Colors ↓ "]
[null,{"$f":"'Basic Info'!A22","v":"White"},{"$f":"C5*'Mix Design'!F24","v":0},null,{"$f":"B19","v":"White"},{"$f":"F5*'Mix Design'!F24","v":0}]
[null,{"$f":"'Basic Info'!A23","v":"Black"},{"$f":"C5*'Mix Design'!F25","v":0},null,"Black",{"$f":"F5*'Mix Design'!F25","v":0}]
[null,{"$f":"'Basic Info'!A24","v":"Cinder"},{"$f":"C5*'Mix Design'!F26","v":0},null,"Cinder",{"$f":"F5*'Mix Design'!F26","v":0}]
[null,{"$f":"'Basic Info'!A25","v":"Brown"},{"$f":"C5*'Mix Design'!F27","v":0},null,"Brown",{"$f":"F5*'Mix Design'!F27","v":0}]
[null,{"$f":"'Basic Info'!A26","v":"Gray"},{"$f":"C5*'Mix Design'!F28","v":0},null,"Gray",{"$f":"F5*'Mix Design'!F28","v":0}]
[null,{"$f":"'Basic Info'!A27","v":"Cobalt Blue"},{"$f":"C5*'Mix Design'!F29","v":0},null,"Cobalt Blue",{"$f":"F5*'Mix Design'!D29","v":0}]
[null,"Total Weight (lbs.)",{"$f":"SUM(C6:C24)","v":9.5849197222662195},null,"Total Weight (lbs.)",{"$f":"SUM(F6:F24)","v":58.422367830956013}]