{"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"]}
["Concrete Unit Weight Calculations"]
["Project Name:",null,"119th Street (US-69 to Riley)",{"$nulls":4},"Project Number:","TH-0734"]
["Date of Test:",null,"2008-05-05",{"$nulls":4},"Time of Test:","12:30 P.M."]
["Purpose of Concrete:",null,"Traffic signal mast arm foundation in NE corner of 119th St & Antioch Rd"]
[]
["Select the Concrete Supplier & Mix Designation",{"$nulls":5},74]
[]
["Penny's Concrete - AS6525G44",{"$nulls":6},"Approval Date"]
["Property","Design","Air Entrainment Percentages",{"$nulls":4},"NA"]
["Air (%)","NA",5,6,6.5,7,8]
["Unit Wt (lbs/CF)","NA","NA","NA","NA","NA","NA"]
[]
["What is the Design Strength?",{"$nulls":6},"NA","psi"]
["What is the Weight of the Test Bucket Plus Concrete?",{"$nulls":6},43.62,"lbs"]
["What is the Weight of the Empty Test Bucket?",{"$nulls":6},7.75,"lbs"]
["The Net Unit Weight of the Concrete =",{"$nulls":6},35.87,"lbs"]
["What is the Tare Factor?",{"$nulls":6},4.018]
["The Calculated Unit Weight of the Field Sample =",{"$nulls":6},144.13,"lbs/CF"]
["Enter the Percent Air from the Field Test (Round to the Nearest 0.1%)",{"$nulls":6},6.8,"%"]
["Interpolate the Unit Weight Between",{"$nulls":6},6.5,"%     and",7,"%   Air"]
["Associated Range of Unit Weights = ",{"$nulls":6},"NA","lbs/CF","NA","lbs/CF"]
["Interpolated Minimum Unit Weight =",{"$nulls":6},{"$error":"#VALUE!"},"lbs/CF"]
["Is Concrete Acceptable Based on Air and Unit Weight?",{"$nulls":6},{"$error":"#VALUE!"}]
{"$rows_empty":11}
["Password: Calculations"]

{"sheet":"Mix Designs","index":1,"n_rows":95,"n_cols":11,"rows_kept":95,"merged":[[0,5,0,9]],"flags":["formulas_cached_only"]}
[null,null,"Design","Design","Design","Air Entrainment Percentages",{"$nulls":4},"Approval"]
[null,"Concrete Supplier","Strength","Air","Unit Wt",5,6,6.5,7,8,"Date"]
[1,"APAC","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[2,"Barbour Concrete Company - BCC-GR-KC4K",4000,6.5,{"v":142.7,"d":"142.70"},143.54,142.03,141.28,140.52,139.01,"2010-03-01"]
[3,"Builders Ready-Mix","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[4,"Century Concrete - 6684K",4000,6.5,141.22,142.05,140.56,139.81,139.06,137.57,"2010-03-02"]
[5,"Century Concrete - 670-MR4K",4000,6.5,140.52,141.35,139.86,139.11,138.37,136.88,"2010-03-01"]
[6,"Century Concrete - 670-SP4K",4000,6.5,140.52,141.35,139.86,139.11,138.37,136.88,"2010-03-01"]
[7,"Century Concrete - 6844K",4000,6.5,{"v":141.7,"d":"141.70"},142.54,141.04,140.29,139.54,138.04,"2010-03-02"]
[8,"Century Concrete - 685-MR4K",4000,6.5,140.96,141.79,{"v":140.3,"d":"140.30"},139.55,138.81,137.31,"2010-03-01"]
[9,"Century Concrete - 685-SP4K",4000,6.5,140.96,141.79,{"v":140.3,"d":"140.30"},139.55,138.81,137.31,"2010-03-01"]
[10,"Century Concrete - 686-MR5K",5000,6.5,141.22,142.05,140.56,139.81,139.06,137.57,"2010-03-01"]
[11,"Century Concrete - 686-SP5K",5000,6.5,141.22,142.05,140.56,139.81,139.06,137.57,"2010-03-01"]
[12,"Century Concrete - 687-HE5K","High Early",6.5,{"v":140.7,"d":"140.70"},141.53,140.04,{"v":139.3,"d":"139.30"},138.55,137.06,"2010-03-01"]
[13,"Century Concrete - 718-MR5K",5000,6.5,141.44,142.28,140.78,140.03,139.28,137.78,"2010-03-01"]
[14,"Century Concrete - 718-SP5K",5000,6.5,141.44,142.28,140.78,140.03,139.28,137.78,"2010-03-01"]
[15,"Concrete Materials - QKB4K1041",4000,6.5,141.85,142.69,141.18,140.43,139.68,138.18,"2010-03-01"]
[16,"Concrete Materials - QKB4K1042",4000,6.5,141.52,142.35,140.85,{"v":140.1,"d":"140.10"},139.35,137.86,"2010-03-01"]
[17,"Concrete Materials - QKB4K1043",4000,6.5,141.15,141.98,140.48,139.74,138.99,137.49,"2010-03-01"]
[18,"Concrete Materials - QKB4K1044",4000,6.5,140.78,141.61,140.12,139.37,138.62,137.13,"2010-03-01"]
[19,"Cretex Concrete Products Midwest - CMW BS 5K DC-FA-Q","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[20,"Cretex Concrete Products Midwest - CMW BS 5K WC-FA-Q","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[21,"Cretex Concrete Products Midwest - CMW LAW 5K WC-FA-Q","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[22,"E&M Precast and Ready-Mix","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[23,"Fordyce Concrete - 6684K",4000,6.5,141.22,142.05,140.56,139.81,139.06,137.57,"2010-03-02"]
[24,"Fordyce Concrete - 670-MR4K",4000,6.5,140.52,141.35,139.86,139.11,138.37,136.88,"2010-03-01"]
[25,"Fordyce Concrete - 670-SP4K",4000,6.5,140.52,141.35,139.86,139.11,138.37,136.88,"2010-03-01"]
[26,"Fordyce Concrete - 6844K",4000,6.5,{"v":141.7,"d":"141.70"},142.54,141.04,140.29,139.54,138.04,"2010-03-02"]
[27,"Fordyce Concrete - 685-MR4K",4000,6.5,140.96,141.79,{"v":140.3,"d":"140.30"},139.55,138.81,137.31,"2010-03-01"]
[28,"Fordyce Concrete - 685-SP4K",4000,6.5,140.96,141.79,{"v":140.3,"d":"140.30"},139.55,138.81,137.31,"2010-03-01"]
[29,"Fordyce Concrete - 686-MR5K",5000,6.5,141.22,142.05,140.56,139.81,139.06,137.57,"2010-03-01"]
[30,"Fordyce Concrete - 686-SP5K",5000,6.5,141.22,142.05,140.56,139.81,139.06,137.57,"2010-03-01"]
[31,"Fordyce Concrete - 687-HE5K","High Early",6.5,{"v":140.7,"d":"140.70"},141.53,140.04,{"v":139.3,"d":"139.30"},138.55,137.06,"2010-03-01"]
[32,"Fordyce Concrete - 718-MR5K",5000,6.5,141.44,142.28,140.78,140.03,139.28,137.78,"2010-03-01"]
[33,"Fordyce Concrete - 718-SP5K",5000,6.5,141.44,142.28,140.78,140.03,139.28,137.78,"2010-03-01"]
[34,"Geiger Ready-Mix - KC4KBK10",4000,6.5,141.93,142.76,141.26,140.51,139.76,138.25,"2010-03-01"]
[35,"Geiger Ready-Mix - KC4KBK25",4000,6.5,141.48,142.31,140.82,140.07,139.32,137.82,"2010-03-01"]
[36,"Geiger Ready-Mix - KC4KBK40",4000,6.5,140.74,141.57,140.08,139.33,138.59,{"v":137.1,"d":"137.10"},"2010-03-01"]
[37,"Geiger Ready-Mix - KC4KBM10",4000,6.5,141.74,142.57,141.07,140.32,139.57,138.07,"2010-03-01"]
[38,"Geiger Ready-Mix - KC4KBM25",4000,6.5,{"v":141.3,"d":"141.30"},142.13,140.63,139.88,139.14,137.64,"2010-03-01"]
[39,"Geiger Ready-Mix - KC4KBM40",4000,6.5,140.56,141.38,139.89,139.15,138.41,136.92,"2010-03-01"]
[40,"Geiger Ready-Mix - KC4KHK10",4000,6.5,141.78,142.61,141.11,140.36,139.61,138.11,"2010-03-01"]
[41,"Geiger Ready-Mix - KC4KHK25",4000,6.5,141.37,{"v":142.2,"d":"142.20"},140.71,139.96,139.21,137.71,"2010-03-01"]
[42,"Geiger Ready-Mix - KC4KHK40",4000,6.5,140.59,141.42,139.93,139.19,138.44,136.95,"2010-03-01"]
[43,"Geiger Ready-Mix - KC4KHM10",4000,6.5,141.63,142.46,140.96,140.21,136.46,137.96,"2010-03-01"]
[44,"Geiger Ready-Mix - KC4KHM25",4000,6.5,141.19,142.02,140.52,139.77,139.03,137.53,"2010-03-01"]
[45,"Geiger Ready-Mix - KC4KHM40",4000,6.5,140.41,141.23,139.75,{"v":139,"d":"139.00"},138.26,136.77,"2010-03-01"]
[46,"Geiger Ready-Mix - KC5KBK10",5000,6.5,142.48,143.32,141.81,141.06,{"v":140.3,"d":"140.30"},138.79,"2010-03-01"]
[47,"Geiger Ready-Mix - KC5KBK25",5000,6.5,141.85,142.69,141.18,140.43,139.68,138.18,"2010-03-01"]
[48,"Geiger Ready-Mix - KC5KBK40",5000,6.5,141.22,142.05,140.56,139.81,139.06,137.57,"2010-03-01"]
[49,"Geiger Ready-Mix - KC5KBM10",5000,6.5,{"v":142.3,"d":"142.30"},143.13,141.63,140.87,140.12,138.61,"2010-03-01"]
[50,"Geiger Ready-Mix - KC5KBM25",5000,6.5,141.67,{"v":142.5,"d":"142.50"},{"v":141,"d":"141.00"},140.25,{"v":139.5,"d":"139.50"},{"v":138,"d":"138.00"},"2010-03-01"]
[51,"Geiger Ready-Mix - KC5KBM40",5000,6.5,141.07,{"v":141.9,"d":"141.90"},140.41,139.66,138.92,137.42,"2010-03-01"]
[52,"Geiger Ready-Mix - KC5KHK10",5000,6.5,142.33,143.17,141.66,140.91,140.16,138.65,"2010-03-01"]
[53,"Geiger Ready-Mix - KC5KHK25",5000,6.5,141.78,142.61,141.11,140.36,139.61,138.11,"2010-03-01"]
[54,"Geiger Ready-Mix - KC5KHK40",5000,6.5,141.15,141.98,140.48,139.74,138.99,137.49,"2010-03-01"]
[55,"Geiger Ready-Mix - KC5KHM10",5000,6.5,142.15,142.98,141.48,140.73,139.97,138.47,"2010-03-01"]
[56,"Geiger Ready-Mix - KC5KHM25",5000,6.5,141.48,142.31,140.82,140.07,139.32,137.82,"2010-03-01"]
[57,"Geiger Ready-Mix - KC5KHM40",5000,6.5,140.96,141.79,{"v":140.3,"d":"140.30"},139.55,138.81,137.31,"2010-03-01"]
[58,"Kincaid Ready-Mix - 860022_4K",4000,6.5,142.72,143.56,142.05,141.29,140.54,139.03,"2010-03-01"]
[59,"Kincaid Ready-Mix - 860024_4K",4000,6.5,141.29,142.12,140.62,139.87,139.13,137.64,"2010-03-01"]
[60,"Kincaid Ready-Mix - 865822_5K",5000,6.5,141.62,142.45,140.95,{"v":140.2,"d":"140.20"},139.45,137.95,"2010-03-01"]
[61,"Kincaid Ready-Mix - 865824_5K",5000,6.5,140.07,{"v":140.9,"d":"140.90"},139.41,138.67,137.93,136.45,"2010-03-01"]
[62,"Kincaid Ready-Mix - 8844HE_5K","High Early",6.5,142.22,143.06,141.55,{"v":140.8,"d":"140.80"},140.05,138.54,"2010-03-01"]
[63,"LaFarge / QuickSilver - KB40HD12",4000,6.5,141.63,142.46,140.96,140.21,139.46,137.96,"2010-03-01"]
[64,"LaFarge / QuickSilver - KB40HD22",4000,6.5,140.96,141.79,{"v":140.3,"d":"140.30"},139.55,138.81,137.31,"2010-03-01"]
[65,"LaFarge / QuickSilver - KB40HD32",4000,6.5,140.96,141.79,{"v":140.3,"d":"140.30"},139.55,138.81,137.31,"2010-03-01"]
[66,"LaFarge / QuickSilver - KB50HD12",5000,6.5,140.37,{"v":141.2,"d":"141.20"},139.71,138.97,138.22,136.74,"2010-03-01"]
[67,"LaFarge / QuickSilver - KB50HD22",5000,6.5,139.52,140.34,138.86,138.12,137.38,135.91,"2010-03-01"]
[68,"LaFarge / QuickSilver - KB50HD32",5000,6.5,138.81,139.63,138.16,137.43,136.69,135.22,"2020-03-01"]
[69,"Parshall Concrete Products - KCMMB 5K",5000,6.5,141.59,142.43,140.93,140.18,139.43,137.93,"2010-03-01"]
[70,"Penny's Concrete - AS6425G42",4000,6.5,141.37,{"v":142.2,"d":"142.20"},140.71,139.96,139.21,137.71,"2010-03-01"]
[71,"Penny's Concrete - AS6425G44",4000,6.5,140.67,141.49,{"v":140,"d":"140.00"},139.26,138.52,137.03,"2010-03-01"]
[72,"Penny's Concrete - AS6525G40",5000,6.5,140.96,141.79,{"v":140.3,"d":"140.30"},139.55,138.81,137.31,"2010-03-01"]
[73,"Penny's Concrete - AS6525G42","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[74,"Penny's Concrete - AS6525G44","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[75,"Precast Eng. & Manufacturing (Precast)","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[76,"Pretech (Percast) - 4K KCMMB",4000,6.5,143.21,144.05,142.53,141.77,141.02,{"v":139.5,"d":"139.50"},"2010-03-02"]
[77,"Pretech (Percast) - 5K KCMMB",5000,6.5,142.35,143.19,141.68,140.93,140.17,138.67,"2010-03-02"]
[78,"RAMS Ready-Mix ","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[79,"Reliable Concrete KCMMB 4K",4000,6.5,144.41,145.26,143.73,142.96,142.2,140.67,"2010-03-01"]
[80,"St. Joe Concrete Products","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[81,"Vanguard Products (Precast)","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[82,"Whistle Redi-Mix","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
{"$rows_empty":10}
[null,"Password:Mixdesigns"]