{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Calculations","Mix Designs"],"not_rendered":{"macros":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Calculations","index":0,"n_rows":35,"n_cols":11,"rows_kept":35,"merged":[[0,0,0,10],[1,0,1,1],[1,2,1,5],[2,0,2,1],[2,2,2,5],[3,0,3,1],[3,2,3,10],[7,0,7,6],[8,2,8,6]],"flags":["formulas_cached_only"]}
["2011 Concrete Unit Weight Calculations"]
["Project Name:",{"$nulls":6},"Project Number:"]
["Date of Test:",{"$nulls":6},"Time of Test:"]
["Purpose of Concrete:"]
[]
["Select the Concrete Supplier & Mix Designation",{"$nulls":5},19]
[]
["Fordyce-Century Mix - KCMMB4KS7"]
["Property","Design","Air Entrainment Percentages"]
["Air (%)",6.5,5,6,6.5,7,8]
["Unit Wt (lbs/CF)",143.3,144.14,142.62,141.86,141.1,139.59]
[]
["What is the Design Strength?",{"$nulls":6},4000,"psi"]
["What is the Weight of the Test Bucket Plus Concrete?",{"$nulls":7},"lbs"]
["What is the Weight of the Empty Test Bucket?",{"$nulls":7},"lbs"]
["The Net Unit Weight of the Concrete =",{"$nulls":6},0,"lbs"]
["What is the Tare Factor?"]
["The Calculated Unit Weight of the Field Sample =",{"$nulls":6},0,"lbs/CF"]
["Enter the Percent Air from the Field Test (Round to the Nearest 0.1%)",{"$nulls":7},"%"]
["Interpolate the Unit Weight Between",{"$nulls":6},"AIR IS TOO LOW","%     and","AIR IS TOO LOW","%   Air"]
["Associated Range of Unit Weights = ",{"$nulls":6},"NA","lbs/CF","NA","lbs/CF"]
["Interpolated Minimum Unit Weight =",{"$nulls":6},"NA","lbs/CF"]
["Is Concrete Acceptable Based on Air and Unit Weight?",{"$nulls":6},"REJECT"]
{"$rows_empty":11}
["Password: Calculations"]

{"sheet":"Mix Designs","index":1,"n_rows":84,"n_cols":10,"rows_kept":84,"merged":[[0,5,0,9]],"flags":["formulas_cached_only"]}
[null,null,"Design","Design","Design","Air Entrainment Percentages"]
[null,"Concrete Supplier","Strength","Air","Unit Wt",5,6,6.5,7,8]
[1,"APAC","NA","NA","NA","NA","NA","NA","NA","NA"]
[2,"Barbour Concrete Company - BCC-GR-KC4K",4000,6.5,142.93,143.77,142.25,{"v":141.5,"d":"141.50"},140.74,139.23]
[3,"Builders Ready-Mix","NA","NA","NA","NA","NA","NA","NA","NA"]
[4,"Concrete Materials - QKB4K1141",4000,6.5,142.06,142.89,141.39,140.64,139.89,138.38]
[5,"Concrete Materials - QKB4K1142",4000,6.5,141.69,142.53,141.03,140.28,139.53,138.03]
[6,"Concrete Materials - QKB4K1143",4000,6.5,141.33,142.16,140.67,139.92,139.17,137.68]
[7,"Concrete Materials - QKB4K1144",4000,6.5,140.97,{"v":141.8,"d":"141.80"},{"v":140.3,"d":"140.30"},139.56,138.81,137.32]
[8,"Concrete Materials - QKB5K1140",5000,6.5,{"v":142,"d":"142.00"},142.84,141.33,140.58,139.83,138.32]
[9,"Concrete Materials - QKB5K1142",5000,6.5,141.23,142.06,140.56,139.81,139.07,137.57]
[10,"Cretex Concrete Products Midwest - CMW BS 5K DC-S",5000,6.5,145.26,146.11,144.58,143.81,143.04,{"v":141.5,"d":"141.50"}]
[11,"Cretex Concrete Products Midwest - CMW BS 5K WC-S",5000,6.5,143.74,144.59,143.06,{"v":142.3,"d":"142.30"},141.54,140.02]
[12,"Cretex Concrete Products Midwest - CMW LAW 5K WC-FA",5000,6.5,141.59,142.43,140.93,140.18,139.43,137.93]
[13,"E&M Precast and Ready-Mix","NA","NA","NA","NA","NA","NA","NA","NA"]
[14,"Fordyce-Century Mix - KCMMB4KF2",4000,6.5,143.17,144.01,{"v":142.5,"d":"142.50"},141.74,140.98,139.46]
[15,"Fordyce-Century Mix - KCMMB4KF4",4000,6.5,142.78,143.62,142.11,141.35,140.59,139.08]
[16,"Fordyce-Century Mix - KCMMB4KF7",4000,6.5,142.78,143.62,142.11,141.35,140.59,139.08]
[17,"Fordyce-Century Mix - KCMMB4KS2",4000,6.5,143.99,144.83,143.31,142.55,141.78,140.26]
[18,"Fordyce-Century Mix - KCMMB4KS4",4000,6.5,{"v":143.3,"d":"143.30"},144.14,142.62,141.86,{"v":141.1,"d":"141.10"},139.59]
[19,"Fordyce-Century Mix - KCMMB4KS7",4000,6.5,{"v":143.3,"d":"143.30"},144.14,142.62,141.86,{"v":141.1,"d":"141.10"},139.59]
[20,"Fordyce-Century Mix - KCMMB5KF4",5000,6.5,142.81,143.65,142.14,141.38,140.62,139.11]
[21,"Fordyce-Century Mix - KCMMB5KF7",5000,6.5,142.81,143.65,142.14,141.38,140.62,139.11]
[22,"Fordyce-Century Mix - KCMMB5KHE5",5000,6.5,142.56,143.39,141.88,141.13,140.38,138.87]
[23,"Fordyce-Century Mix - KCMMB5KS4",5000,6.5,143.72,144.57,143.05,142.29,141.52,{"v":140,"d":"140.00"}]
[24,"Fordyce-Century Mix - KCMMB5KS7",5000,6.5,143.72,144.57,143.05,142.29,141.52,{"v":140,"d":"140.00"}]
[25,"Geiger Ready-Mix - KC4KHK10",4000,6.5,141.44,142.28,140.78,140.03,139.28,137.78]
[26,"Geiger Ready-Mix - KC4KHK25",4000,6.5,140.67,141.49,{"v":140,"d":"140.00"},139.26,138.52,137.03]
[27,"Geiger Ready-Mix - KC4KHK40",4000,6.5,140.04,140.86,139.38,138.64,{"v":137.9,"d":"137.90"},136.41]
[28,"Geiger Ready-Mix - KC4KHM10",4000,6.5,141.44,142.28,140.78,140.03,139.28,137.78]
[29,"Geiger Ready-Mix - KC4KHM25",4000,6.5,140.67,141.49,{"v":140,"d":"140.00"},139.26,138.52,137.03]
[30,"Geiger Ready-Mix - KC4KHM40",4000,6.5,140.04,140.86,139.38,138.64,{"v":137.9,"d":"137.90"},136.41]
[31,"Geiger Ready-Mix - KC5KHK10",5000,6.5,{"v":141.7,"d":"141.70"},142.54,141.04,140.29,139.54,138.04]
[32,"Geiger Ready-Mix - KC5KHK25",5000,6.5,140.89,141.72,140.23,139.48,138.73,137.24]
[33,"Geiger Ready-Mix - KC5KHK40",5000,6.5,140.04,140.86,139.38,138.64,{"v":137.9,"d":"137.90"},136.41]
[34,"Geiger Ready-Mix - KC5KHM10",5000,6.5,{"v":141.7,"d":"141.70"},142.54,141.04,140.29,139.54,138.04]
[35,"Geiger Ready-Mix - KC5KHM25",5000,6.5,140.89,141.72,140.23,139.48,138.73,137.24]
[36,"Geiger Ready-Mix - KC5KHM40",5000,6.5,140.04,140.86,139.38,138.64,{"v":137.9,"d":"137.90"},136.41]
[37,"Kincaid Ready-Mix - 860022_4K",4000,6.5,142.44,143.28,141.77,141.02,140.27,138.76]
[38,"Kincaid Ready-Mix - 860022GM",4000,6.5,141.74,142.57,141.07,140.32,139.57,138.07]
[39,"Kincaid Ready-Mix - 860022HM",4000,6.5,144.11,144.96,143.43,142.67,141.91,140.38]
[40,"Kincaid Ready-Mix - 860024_4K",4000,6.5,140.96,141.79,{"v":140.3,"d":"140.30"},139.55,138.81,137.31]
[41,"Kincaid Ready-Mix - 860024GM",4000,6.5,140.22,141.05,139.56,138.82,138.08,136.59]
[42,"Kincaid Ready-Mix - 860024HM",4000,6.5,142.89,143.73,142.22,141.46,{"v":140.7,"d":"140.70"},139.19]
[43,"Kincaid Ready-Mix - 865822_5K",5000,6.5,141.33,142.16,140.67,139.92,139.17,137.68]
[44,"Kincaid Ready-Mix - 865822GM",5000,6.5,140.67,141.49,{"v":140,"d":"140.00"},139.26,138.52,137.03]
[45,"Kincaid Ready-Mix - 865822HM",5000,6.5,142.93,143.77,142.25,{"v":141.5,"d":"141.50"},140.74,139.23]
[46,"Kincaid Ready-Mix - 865824_5K",5000,6.5,{"v":140,"d":"140.00"},140.82,139.34,{"v":138.6,"d":"138.60"},137.86,136.38]
[47,"Kincaid Ready-Mix - 865824GM",5000,6.5,139.81,140.64,139.16,138.42,137.68,{"v":136.2,"d":"136.20"}]
[48,"Kincaid Ready-Mix - 865824HM",5000,6.5,141.63,142.46,140.96,140.21,139.46,137.96]
[49,"Kincaid Ready-Mix - 8844GMHE","HE",6.5,142.22,142.16,140.67,139.92,139.17,137.68]
[50,"Kincaid Ready-Mix - 8844HE","HE",6.5,142.22,143.06,141.55,{"v":140.8,"d":"140.80"},140.05,138.54]
[51,"Kincaid Ready-Mix - 8844HMHE","HE",6.5,143.56,{"v":144.4,"d":"144.40"},142.88,142.12,141.36,139.84]
[52,"LaFarge / QuickSilver - KB40HD12",4000,6.5,142.67,143.51,{"v":142,"d":"142.00"},141.24,140.48,138.97]
[53,"LaFarge / QuickSilver - KB40HD22",4000,6.5,141.63,142.46,140.96,140.21,139.46,137.96]
[54,"LaFarge / QuickSilver - KB40HD32",4000,6.5,141.63,142.46,140.96,140.21,139.46,137.96]
[55,"LaFarge / QuickSilver - KB50HD12",5000,6.5,{"v":141.7,"d":"141.70"},142.54,141.04,140.29,139.54,138.04]
[56,"LaFarge / QuickSilver - KB50HD22",5000,6.5,140.44,141.27,139.78,139.04,{"v":138.3,"d":"138.30"},136.81]
[57,"LaFarge / QuickSilver - KB50HD32",5000,6.5,140.44,141.27,139.78,139.04,{"v":138.3,"d":"138.30"},136.81]
[58,"Parshall Concrete Products - KCMMB 5K",5000,6.5,141.63,142.46,140.96,140.21,139.46,137.96]
[59,"Penny's Concrete - AS4525G40",5000,6.5,{"v":140.7,"d":"140.70"},141.58,140.09,139.35,{"v":138.6,"d":"138.60"},137.11]
[60,"Penny's Concrete - AS6425G42",4000,6.5,140.78,141.61,140.12,139.37,138.62,137.13]
[61,"Penny's Concrete - AS6425G44",4000,6.5,140.41,141.23,139.75,{"v":139,"d":"139.00"},138.26,136.77]
[62,"Penny's Concrete - AS6525G40",5000,6.5,140.76,141.58,140.09,139.35,{"v":138.6,"d":"138.60"},137.11]
[63,"Precast Eng. & Manufacturing (Precast)","NA","NA","NA","NA","NA","NA","NA","NA"]
[64,"Pretech (Percast) - KCMMB 4K",4000,6.5,142.72,143.56,142.05,{"v":141.3,"d":"141.30"},140.54,139.03]
[65,"Pretech (Percast) - KCMMB 5K",5000,6.5,141.83,142.66,141.16,140.41,139.66,138.16]
[66,"RAMS Ready-Mix ","NA","NA","NA","NA","NA","NA","NA","NA"]
[67,"Reliable Concrete KCMMB 4K",4000,6.5,144.37,145.22,143.69,142.93,142.16,140.63]
[68,"Show Me Readymix","NA","NA","NA","NA","NA","NA","NA","NA"]
[69,"St. Joe Concrete Products","NA","NA","NA","NA","NA","NA","NA","NA"]
[70,"Vanguard Products (Precast)","NA","NA","NA","NA","NA","NA","NA","NA"]
[71,"Whistle Redi-Mix","NA","NA","NA","NA","NA","NA","NA","NA"]
{"$rows_empty":10}
[null,"Password:Mixdesigns"]