{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Header","Project Items","Mix Components","Design","Calculations","Workbook Edits","Template COMIXDSGN","discipline","t_smpl","t_cont_smpl","t_rmks_dtl","t_smpl_tst","t_smpl_tstr","t_tst_rslt_hdr","t_tst_rslt_dtl","t_pcc","Drop_Downs_and_Tables"],"not_rendered":{"charts":0,"images":40,"macros":1,"external_links":5,"defined_names":102,"comments":10,"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":"Header","index":0,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[14,10,14,12],[8,10,8,12],[16,2,16,18],[13,2,13,4],[12,10,12,12],[13,10,13,12],[14,2,14,4],[6,2,6,4],[3,17,3,18],[12,2,12,4],[7,10,7,12],[8,2,8,4],[4,17,4,18],[10,2,10,5],[7,2,7,5]]}
["KENTUCKY TRANSPORTATION CABINET"]
["Department of Highways"]
["Division of Materials",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,"Discipline","CONCMIX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",3.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(New XML Schema)"]
["Date Submitted"]
["Concrete Class",null,null,null,null,null,null,"Producer/Supplier Code",null,null,"",null,null,null,"Name and Loc.:  ",{"$f":"IFERROR(VLOOKUP(K8,Drop_Downs_and_Tables!W2:X301,2,FALSE),\"\")","v":""}]
["Material Code",null,{"$f":"IF(ISERROR(VLOOKUP(C8,Drop_Downs_and_Tables!A4:C30,3,FALSE)),\"\",VLOOKUP(C8,Drop_Downs_and_Tables!A4:C30,3,FALSE))","v":""},null,null,null,null,"Mix Designer (SM User ID)"]
[]
["Contract"]
[]
["Sample ID",null,null,null,null,null,null,"KYTC Authorizer (SM User ID)"]
["District",null,{"$f":"LEFT(C13,2)","v":""},null,null,null,null,"Date Received"]
["Mix ID",null,{"$f":"IF(C13=\"\",\"\",C13)","v":""},null,null,null,null,"Lab ID (KYTC)",null,null,""]
[]
["Remarks"]
[]
[]
["Overwrite Capable",null,null,"Y"]
["Contract Spec Year",null,null,2004]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contractor Entries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KYTC Entries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invisible"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read-Only"]

{"sheet":"Project Items","index":1,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Project","Line Item","Represented","Item",null,null,"Read-Only"]
[null,"Number","Quantity","Code",null,null,"Contractor Entries"]
[null,null,"(in item code unit)","Unit",null,null,"   (Add as many rows as required)"]
["t_cont_smpl","t_cont_smpl","t_cont_smpl","N/A"]
["prj_nbr","ln_itm_nbr","repr_qty","Not Stored on the SM database"]

{"sheet":"Mix Components","index":2,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[59,4,59,8],[60,0,61,2],[61,4,61,8],[13,1,13,4],[13,5,13,7],[13,8,13,11],[46,4,46,8],[48,4,48,8],[52,4,52,8],[54,4,54,8],[34,1,34,2],[36,5,36,11],[32,5,32,11],[33,1,33,4],[32,0,32,4],[0,0,0,4],[6,7,11,11],[26,1,26,2],[26,7,26,8],[25,1,25,4],[1,1,1,4],[5,0,5,6],[0,5,0,11],[5,7,5,11],[3,1,3,4],[22,0,22,11],[25,7,25,11],[6,4,6,5],[12,0,12,11]]}
["Cement",null,null,null,null,"Design Slump and Strength"]
["Source",null,null,null,null,{"$f":"CONCATENATE(\"Slump for Class \" & Calculations!C34 & \":  \" & Calculations!H34 & \" - \" & Calculations!I34 & \" inches\")","v":"Slump for Class :   -  inches"}]
["Producer Code",null,null,null,null,"Design Slump (inches):"]
["Type",null,null,null,null,"Strength (PSI)",null,null,"at"]
["Add'l Cement",null,"lbs","Sp. Grav."]
["Liquid Admixtures",null,null,null,null,null,null,"Note:"]
["Type",null,"Name",null,"Producer Code",null,"oz/100wt",{"$f":"IF(Calculations!C34=\"AA\",Calculations!J38,IF(Calculations!C34=\"P\",Calculations!J39,IF(OR(Calculations!C34=\"AAA\",Calculations!C34=\"M1\",Calculations!C34=\"M2\"),Calculations!J40,IF(Calculations!C34=\"Custom\",Calculations!J41,\"\"))))","v":""}]
[]
[]
[]
[]
[]
["Mineral Admixtures"]
[]
["Source"]
["Producer Code"]
["Specific Gravity"]
["Grade"]
["% Replacement"]
["Max. % Replacment",""]
["Replacement Ratio",null,"    :1",null,null,null,null,"% Reduction of Cement By Weight"]
["Class",null,null,null,null,null,null,"Minimum Cement Factor (lb/cuyd)"]
["Coarse Aggregate"]
[]
[null,"Source # 1",null,null,null,null,null,"Source # 2"]
["Source",null,null,null,null,"Source"]
["Producer Code",null,null,null,null,"Producer Code"]
["Bench/Ledge",null,null,null,null,"Bench/Ledge"]
["Bulk Sp. Gr. (SSD)",null,null,null,null,"Bulk Sp. Gr. (SSD)"]
["Absorption %",null,null,null,null,"Absorption %"]
["Total Moisture Content",null,null,null,null,"Total Moisture Content"]
["Size"]
["Fine Aggregate",null,null,null,null,"Final Blend"]
["Source",null,null,null,null,"% Weight of Source # 1 in Blend"]
["Producer Code",null,null,null,null,"% Weight of Source # 2 in Blend"]
["Bulk Sp. Gr. (SSD)",null,null,null,null,"Final Blend for Corase Aggregate"]
["Absorption %",null,null,null,null,"Water and Air"]
["Total Moisture Content",null,null,null,null,"Design % Air",null,null,null,{"$f":"CONCATENATE(\"Total Water in Mix:  (Max=\",Calculations!J45,\")\")","v":"Total Water in Mix:  (Max=0)"},null,"lbs"]
["% Fine to Total Agg.",null,null,null,null,null,null,null,null,"Maximum Water/Cement Ratio"]

{"sheet":"Design","index":3,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[19,9,19,11],[26,9,26,10],[26,6,26,8],[29,9,29,10],[21,0,21,1],[22,0,22,1],[22,5,22,8],[21,5,21,8],[26,0,26,4],[23,0,23,1],[21,3,21,4],[25,9,25,10],[24,5,24,12],[27,9,27,10],[25,6,25,8],[23,5,23,8],[28,5,28,8],[19,0,19,1],[20,0,20,1],[19,2,19,4],[20,2,20,4],[27,0,27,1],[27,2,27,4],[28,0,28,1],[51,1,53,12],[18,5,18,12],[17,11,17,12],[6,5,6,6],[7,5,7,6],[17,7,17,8],[8,5,8,6],[9,5,9,6],[31,11,31,12],[32,11,32,12],[33,5,33,8],[31,0,31,1],[30,11,30,12],[12,11,12,12],[13,11,13,12],[14,11,14,12],[27,11,27,12],[25,11,25,12],[26,11,26,12],[31,9,31,10],[30,5,30,8],[15,11,15,12],[16,11,16,12],[29,11,29,12],[48,5,48,8],[37,0,37,1],[40,0,40,1],[35,0,35,1],[35,2,35,4],[36,0,36,1],[30,0,30,1],[34,0,34,1],[34,2,34,4],[28,2,28,4],[29,0,29,1],[29,5,29,8],[19,5,19,8],[20,5,20,8],[20,9,20,11],[49,5,49,8],[45,0,45,1],[41,0,41,1],[45,6,45,8],[46,0,46,4],[47,3,47,4],[49,3,49,4],[48,0,48,2],[49,0,49,2],[48,3,48,4],[47,0,47,2],[44,6,44,8],[43,0,43,1],[44,0,44,1],[42,0,42,1],[34,5,34,12],[32,9,32,10],[32,5,32,8],[33,9,33,12],[33,0,33,4],[24,0,24,1],[31,5,31,8],[30,9,30,10],[0,0,0,12],[1,0,1,12],[2,0,2,12],[5,7,5,11],[9,8,9,9],[15,9,15,10],[12,7,12,8],[12,9,12,10],[13,7,13,8],[4,0,4,4],[4,5,4,12],[6,2,6,3],[6,0,6,1],[7,2,7,4],[3,2,3,9],[5,0,5,1],[5,5,5,6],[5,2,5,3],[11,0,11,4],[12,0,12,1],[13,9,13,10],[14,9,14,10],[9,0,9,1],[8,0,8,1],[18,0,18,4],[10,0,10,1],[9,2,9,3],[16,7,16,8],[16,9,16,10],[11,5,11,12],[15,7,15,8],[8,2,8,3],[10,2,10,3],[14,7,14,8],[13,0,13,1],[13,2,13,4],[14,0,14,1],[16,0,16,1],[15,0,15,1],[14,3,14,4],[17,9,17,10],[12,2,12,4]]}
["Kentucky Transportation Cabinet"]
["Division of Materials"]
["Concrete Mix Design"]
[null,null,{"$f":"IF(Header!K8=\"\",\"\",CONCATENATE(Header!K8,\" - \",Header!P8))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"Header!R5","v":3.5}]
["CONTRACT INFORMATION",null,null,null,null,"CONCRETE SPECIFICATIONS"]
["Contract ID:",null,null,null,null,"Class:",null,{"$f":"IF(Header!C8=\"\",\"\",VLOOKUP(Header!C8,Drop_Downs_and_Tables!A5:B30,2,FALSE))","v":""}]
["Line Item Number:",null,null,null,null,"Max. w/c:"]
[null,null,null,null,null,"Dsgn Slump:",null,null,"in"]
["Conc. Producer Code:",null,null,null,null,"Dsgn Air:",null,null,"%"]
["Concrete Mix ID:",null,null,null,null,"Dsgn Strength:",null,null,"psi       at"]
[]
["CEMENT DATA",null,null,null,null,"LIQUID ADMIXTURE DATA"]
["Source:",null,null,null,null,"Matl Code","Type","Name",null,"Producer Code",null,"oz/100wt"]
["Producer Code:",null,null,null,null,{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,Calculations!$F$47:$G$54,2,FALSE))","v":""}]
["Type / Material Code:",null,null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,Calculations!D39:E51,2,FALSE))","v":""},null,{"$f":"IF(G15=\"\",\"\",VLOOKUP(G15,Calculations!$F$47:$G$54,2,FALSE))","v":""}]
["Minimum:",null,null,"lb/cuyd",null,{"$f":"IF(G16=\"\",\"\",VLOOKUP(G16,Calculations!$F$47:$G$54,2,FALSE))","v":""}]
["Cement Increase:",null,null,"lb/cuyd",null,{"$f":"IF(G17=\"\",\"\",VLOOKUP(G17,Calculations!$F$47:$G$54,2,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(G18=\"\",\"\",VLOOKUP(G18,Calculations!$F$47:$G$54,2,FALSE))","v":""}]
["FLY ASH DATA",null,null,null,null,"FINE AGGREGATE DATA"]
["Source:",null,null,null,null,"Source:"]
["Producer Code:",null,null,null,null,"Producer Code:"]
["Class / Material Code:",null,null,{"$f":"IF(C22=\"\",\"\",IF(C22=\"F\",40165,IF(C22=\"C\",40200,\"\")))","v":""},null,"Bulk Sp. Gr. (SSD):"]
["% Replacement:",null,null,null,null,"Absorption %:"]
["Replacement Ratio:  1:",null,null,null,null,"Total Mositure Content %:"]
["Sp. Gr.:",null,null,null,null,"COARSE AGGREGATE DATA"]
[null,null,null,null,null,"Source 1:",null,null,null,"Producer Code:"]
["GGBFS DATA",null,null,null,null,"Source 2:",null,null,null,"Producer Code:"]
["Source:",null,null,null,null,null,null,null,null,"Source 1",null,"Source 2"]
["Producer Code:",null,null,null,null,"Bench / Ledge:"]
["% Replacement:",null,null,null,null,"Bulk Sp. Gr. (SSD):"]
["Grade:",null,null,null,null,"Absorption %:"]
["Sp. Gr.:",null,null,null,null,"Total Moisture Content %:"]
[null,null,null,null,null,"% Coarse Aggregate:"]
["MICROSILICA DATA",null,null,null,null,"Final Blend Size:"]
["Source:",null,null,null,null,"MIX DESIGN DATA"]
["Producer Code:",null,null,null,null,null,null,null,null,"wt","vol"]
["% Replacement:",null,null,null,null,null,null,null,null,"lb","cuft"]
["Sp. Gr.:",null,null,null,null,null,null,null,"Cement:",0,0]
[null,null,null,null,null,null,null,null,"Fly Ash:",0,0]
[null,null,null,null,null,null,null,null,"Microsilica:",0,0]
["Water Added at Mixer:",null,0,"lb",{"$f":"C41/8.34","v":0},"gal",null,null,"GGBFS:",0,0]
["Free Moisture:",null,0,"lb",{"$f":"C42/8.34","v":0},"gal",null,null,"Water:",null,0]
["Water Underrun:",null,0,"lb",{"$f":"C43/8.34","v":0},"gal",null,null,"Air:","--------",0]
["Cementitious Weight:",null,{"$f":"SUM(J38:J41)","v":0},"lb"]
["Unit Weight:",null,{"$f":"IF(ISERROR(J47/K47),0,J47/K47)","v":0},"lb/cuft",null,null,"Fine Agg. SSD:",null,null,0,0]
["Batch w/c Ratio:",null,{"$f":"IF(ISERROR(J42/C44),0,J42/C44)","v":0},null,null,null,"Coarse Agg. SSD:",null,null,0,0]
["APPROVAL",null,null,null,null,null,null,null,"Total:",{"$f":"SUM(J38:J46)","v":0},{"$f":"SUM(K38:K46)","v":0}]
["Design Submitted By (UserID):",null,null,{"$f":"IF(Header!K9=\"\",\"\",Header!K9)","v":""}]
["Date:",null,null,{"$f":"IF(Header!C7=\"\",\"\",Header!C7)","v":""},null,"Adjusted Fine Agg. wt.:",null,null,null,0]
["Design Approved By (UserID):",null,null,{"$f":"IF(Header!K13=\"\",\"\",Header!K13)","v":""},null,"Adjusted Coarse Agg. wt.:",null,null,null,0]
[]
["Remarks:",{"$f":"IF(Header!C17=\"\",\"\",Header!C17)","v":""}]

{"sheet":"Calculations","index":4,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":true,"merged":[[5,1,6,1]]}
[null,null,"Class","Low Air","High Air","Min. Cement","Max. Water/Cement","Low Slump","High Slump","Additive","C Fly Ash","F Fly Ash","Microsilica","GGBF"]
[null,null,"A",4,8,564,0.49,2,5,"O","O","O","O","O",{"$f":"F2*G2","v":276.36}]
[null,null,"AFT",4,8,564,0.49,2,5,"O","O","O","O","O",{"$f":"F3*G3","v":276.36}]
[null,null,"AMOD",4,8,658,0.47,4,7,"O","O","O","O","O",{"$f":"F4*G4","v":309.26}]
[null,null,"AMAS",4,8,564,0.49,2,5,"O","O","O","O","O",{"$f":"F5*G5","v":276.36}]
[null,"Cells in Yellow contain formulas","AA",{"$f":"IF($J$48=\"Y\",5,4)","v":4},{"$f":"IF($J$48=\"Y\",9,8)","v":8},620,0.42,2,5,"O","O","O","O","O",{"$f":"F6*G6","v":260.39999999999998}]
[null,null,"AAFT",4,8,620,0.42,2,5,"O","O","O","O","O",{"$f":"F7*G7","v":260.39999999999998}]
[null,null,"AAHP",4,8,620,0.42,2,4,"O","O","O","O","O",260.39999999999998]
[null,null,"AAHF",4,8,620,0.42,2,4,"O","O","O","O","O",260.39999999999998]
[null,null,"AASP",4,8,620,0.4,2,6,"O","O","O","O","O",248]
[null,null,"AAMS",{"$f":"IF($J$48=\"Y\",5,4)","v":4},{"$f":"IF($J$48=\"Y\",9,8)","v":8},620,0.42,2,6,"O","O","O","O","O",260.39999999999998]
[null,null,"AAAF",{"$f":"IF($J$48=\"Y\",5,4)","v":4},{"$f":"IF($J$48=\"Y\",9,8)","v":8},686,0.4,3,7,"O","O","O","O","O",274.40000000000003]
[null,null,"B",4,8,451,0.66,3,5,"O","O","O","O","O",297.66000000000003]
[null,null,"D",4,8,639,0.44,3,5,"O","O","O","O","O",281.16000000000003]
[null,null,"DMOD",4,8,733,0.42,3,5,"O","O","O","O","O",307.86]
[null,null,"M1",4,8,800,0.33,0,7,"O","O","O","O","O",264]
[null,null,"M1FT",4,8,800,0.33,0,7,"O","O","O","O","O",264]
[null,null,"M2",4,8,705,0.38,0,7,"O","O","O","O","O",267.89999999999998]
[null,null,"M2FT",4,8,705,0.38,0,7,"O","O","O","O","O",267.89999999999998]
[null,null,"PFT",{"$f":"IF($J$48=\"Y\",5,4)","v":4},{"$f":"IF($J$48=\"Y\",9,8)","v":8},{"$f":"IF(J48=\"Y\",611,564)","v":564},0.49,1.5,2,"O","O","O","O","O",276.36]
[null,null,"J24",{"$f":"IF($J$48=\"Y\",5,4)","v":4},{"$f":"IF($J$48=\"Y\",9,8)","v":8},799,0.33,1.5,2,"O","O","O","O","O",263.67]
[null,null,"J48",4,8,729,0.34,1.5,2,"O","O","O","O","O",247.86]
[null,null,"J72",4,8,658,0.35,1.5,2,"O","O","O","O","O",230.29999999999998]
[null,null,"J24T",4,8,705,0.33,1.5,2,"O","O","O","O","O",232.65]
[null,null,"J48T",4,8,635,0.34,1.5,2,"O","O","O","O","O",215.9]
[null,null,"J72T",4,8,564,0.35,1.5,2,"O","O","O","O","O",197.39999999999998]
[null,null,"SEAL",0,5,564,0.47,4,8,"O","O","O","O","O",265.08]
[null,null,"LOSO",4,7,799,0.37,0.5,1,"O","O","O","O","O",295.63]
[null,null,"SCOO",null,null,null,null,null,null,"O","O","O","O","O",0]
[null,null,"HPCO",null,null,null,null,null,null,"O","O","O","O","O",0]
[null,null,"CUS",0,100,1,0.999,0,99,"O","O","O","O","O",0.999]
[null,null,"CUSF",0,100,1,0.999,0,99,"O","O","O","O","O",0.999]
[]
[null,null,{"$f":"IF(Header!C8=\"\",\"\",Header!C8)","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,2,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,3,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,4,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,5,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,6,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,7,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,8,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,9,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,10,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,11,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP($C$34,$C$2:$N$32,12,FALSE))","v":""}]
[]
["Ash Class",true,{"$f":"IF(B36,\"C\",\"F\")","v":"C"}]
["Ash Replacement Ratio",null,null,0,{"$f":"1+D37/100","v":1}]
["GGBF Slag Grade",null,"Target % Air","Type of Cement",null,null,"Gravel",false,"AAFT","If an increased slump range is utilized, a Type F or G Admixture must be used."]
[100,null,6,"I",40100,null,"Limestone",false,"P","Slump.  2 inches maximum with a nominal slump of 1.5 inches.  The Department will allow a maximum of 3 inches when hand finishing or truck mixing."]
[120,null,7,"IA",40105,null,"Both",false,"AAA,M1,M2","Use a high range water reducer (Type F or G)."]
[null,null,null,"IL",40163,null,null,null,"Custom","Custom class will allow absurd mixtures.  The Department may choose not to accept custom designs."]
[null,null,null,"II",40110]
[null,null,null,"III",40115]
[null,null,null,"IP",40120]
[null,null,null,"IIA",40125,null,null,"Total Water in Mix (Max)",null,0]
[null,null,null,"K",40130,"Admix Type","Mat. Code","Use Two Sources",null,"N"]
[null,null,null,"RAPID SET",40150,"AIR",42000,"Coarse Agg Size"]
["Code Tables",null,null,"IS",40155,"A",42010,"Alter Air Content Range",null,{"$f":"IF(OR(J47=\"8\",J47=\"78\",J47=\"9-M\"),\"Y\",\"N\")","v":"N"}]
[null,null,null,"I(SM)",40160,"C",42020]
["INCH","INCHES",null,null,null,"D",42005]
[null,null,null,null,null,"E",42015]
[null,null,null,null,null,"F",42025]
[null,null,null,null,null,"G",42030]
[null,null,null,null,null,"S",42040]

{"sheet":"Workbook Edits","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Tracks Pre-Production Workbook Changes"]
["Date","Initials","Description"]
["2006-05-16","BGP","New."]
["2006-07-21","BGP","Mapping all complete.  All that is left is to map the Concrete Class & Mix Component Tabs to the Design Tab.\n\nMARK: please note the additional \"Material Code\" fields on the Design Tab, cells D15, D22, and \nF14 - F18."]
["2006-09-26","BGP","Revised the following edits as discussed with Troy on 8/30/06:\n- \"Sampler\", \"Tester\", \"Authorizer\" edits to be more complete;\n- t_smpl_tst.tst_meth to check t_tst_fee_sched\n- Add district to discipline tab\n- Re-validate authorizer (& witnessed by)  [NOTE: no changes in any discipline]\n- Add code table check for t_smpl.unt_t where missing\n- Review Repr_Qty on all spreadsheet   [NOTE: no changes in any discipline]\nRevised the following due to Committee decisions:\n- Revise Test Start, Est. Compl., and Actual Compl. Dates (as specified in updated procedures)"]
["2006-10-10","BGP","Revised the following: \n- Re-applied all changes from 9/26/06 as these where lost in a version with data that Mark had (including the automatic assignment of Mix ID as the Sample ID);\n- Added macro's for unhiding/unprotecting sheets (and the reverse) for KYTC updates - password is \"map\".\n- Added activation of the \"Design\" Worksheet so all template field assignments will be made by the VB code before the Applet transfer begins (and then return focus to the original sheet when workbook opened).  This causes a brief flicker when the sheet is opened, but we need to make sure this happen before transfer begins."]
["2006-11-02","MH & RM","Corrected codes for JPCP's on Drop_Downs_and_Tables tab."]
["2006-11-06","BGP","Corrected Template definitions for Concrete Class (4-char Code Table Value) and Design Strength Time Field (Numeric 2.1).  Also removed \"Product Name\" from valid Liquid Admixtures edits so this can be checked procedurally (as the decision was that this can easily be mistyped); Added edits in t_pcc tab for Concrete Class (4-char PCCCLASS Code Table Value) and where sample date used (\"since only 1 sample\")."]
["2006-12-08","MDH","Replaced Lab, Sampler, and Tester data with valid KQTL data."]
["2006-12-11","BGP","Performance tuning (started using ScreenUpdating Property in background macros to help speed up processing); Added \"Filename\" (SampleIDRoot) to the discipline tab."]
["2006-12-13","TDS","Attached new map which includes the root sample id (filename).  The new map also ensures all dates from excel are in the same formate (serial date).  Conversion to normal date and format is handled in the applet.  All dates are tested for validity and that they don't exceed the current system date."]
["2007-01-03","MDH","Prefixed Lab ID with 'C' or 'T' to designate Contractor or KYTC lab."]
["2007-02-13","BGP","Assigned t_smpl.repr_qty to total of all quantities on the Project Line Items tab; Assigned new \"Template Status\" code table value in t_tst_rslt_dtl.F2 based on the value in t_smpl.smpl_stat (Global Template Change)."]
["2007-03-28","BGP","Updated all the fields on t_tst_rslt_dtl so that if the source data is null, the data in the t_tst_rslt_dtl tab will also be null (as it was previously storing a zero on the t_tst_rslt_dtl fields)."]

{"sheet":"Template COMIXDSGN","index":6,"n_rows":125,"n_cols":22,"rows_kept":125,"cut":false,"hidden":true,"merged":[[4,5,4,13],[18,5,18,13],[16,6,16,7],[15,10,15,12],[16,10,16,12],[6,2,6,3],[8,5,8,6],[9,5,9,6],[13,6,13,7],[14,6,14,7],[11,5,11,13],[17,10,17,12],[17,6,17,7],[16,8,16,9],[18,0,18,4],[14,0,14,1],[16,0,16,1],[15,0,15,1],[9,8,9,9],[15,6,15,7],[12,6,12,7],[7,2,7,3],[8,2,8,3],[9,2,9,3],[19,9,19,11],[20,9,20,11],[26,6,26,8],[28,5,28,8],[27,11,27,12],[25,11,25,12],[34,5,34,13],[24,5,24,13],[12,10,12,12],[13,10,13,12],[14,10,14,12],[31,9,31,10],[30,9,30,10],[33,9,33,12],[20,5,20,8],[27,9,27,10],[25,6,25,8],[23,5,23,8],[22,5,22,8],[21,5,21,8],[19,5,19,8],[30,11,30,12],[31,11,31,12],[32,11,32,12],[10,2,10,3],[9,0,9,1],[8,0,8,1],[10,0,10,1],[27,0,27,1],[27,2,27,4],[26,0,26,4],[23,0,23,1],[24,0,24,1],[21,0,21,1],[22,0,22,1],[19,0,19,1],[20,0,20,1],[19,2,19,4],[20,2,20,4],[21,3,21,4],[49,5,49,8],[45,0,45,1],[41,0,41,1],[45,6,45,8],[46,0,46,4],[47,3,47,4],[49,3,49,4],[49,0,49,2],[48,3,48,4],[44,6,44,8],[48,0,48,2],[43,0,43,1],[44,0,44,1],[40,0,40,1],[42,0,42,1],[36,0,36,1],[37,0,37,1],[47,0,47,2],[48,5,48,8],[28,0,28,1],[28,2,28,4],[29,0,29,1],[29,5,29,8],[30,5,30,8],[32,5,32,8],[33,0,33,4],[33,5,33,8],[31,0,31,1],[31,5,31,8],[35,0,35,1],[35,2,35,4],[30,0,30,1],[34,0,34,1],[34,2,34,4],[25,9,25,10],[26,11,26,12],[26,9,26,10],[29,11,29,12],[29,9,29,10],[32,9,32,10],[4,0,4,4],[17,8,17,9],[6,5,6,6],[7,5,7,6],[6,0,6,1],[5,0,5,1],[5,5,5,6],[5,2,5,3],[11,0,11,4],[12,0,12,1],[12,2,12,4],[12,8,12,9],[13,8,13,9],[14,8,14,9],[14,3,14,4],[15,8,15,9],[13,0,13,1],[13,2,13,4]]}
["TEST METHOD:",null,null,"COMIXDSGN",null,null,null,null,null,null,null,null,null,null,null,"SM sn","Cell","type","label","length","English Unit","Comment"]
["DESCRIPTION:",null,null,"Concrete Mix Design",null,null,null,null,null,null,null,null,null,null,null,"F8","F5","Label","CONCRETE SPECIFICATIONS","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F9","H6","Alphanumeric","Class",4,"n/a","Concrete Class Code"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F10","H7","Numeric","Max. w/c",1.2,"n/a"]
[null,null,null,null,null,"CONCRETE SPECIFICATIONS",null,null,null,null,null,null,null,null,null,"F11","H8","Numeric","Dsgn Slump",2.1,"inch"]
[null,null,null,null,null,"Class:",null,"H6",null,null,null,null,null,null,null,"F12","H9","Numeric","Dsgn Air",1.1000000000000001,"%"]
[null,null,null,null,null,"Max. w/c:",null,"H7",null,null,null,null,null,null,null,"F13","H10","Numeric","Dsgn Strength",5,"psi"]
[null,null,null,null,null,"Dsgn Slump:",null,"H8","in",null,null,null,null,null,null,"F14","K10","Numeric","at",2.1,"n/a","Passing this in; needs a separate field."]
[null,null,null,null,null,"Dsgn Air:",null,"H9","%",null,null,null,null,null,null,"F15","L10","Alphanumeric","Strength Unit",4,"n/a","Unit Code"]
[null,null,null,null,null,"Dsgn Strength:",null,"H10","psi       at",null,"K10","L10",null,null,null,"F16","A12","Label","CEMENT DATA","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F17","C13","Alphanumeric","Source",20,"n/a","This is the P/S \"Desc\" corresponding to the code."]
["CEMENT DATA",null,null,null,null,"LIQUID ADMIXTURE DATA",null,null,null,null,null,null,null,null,null,"F18","C14","Alphanumeric","Producer Code",15,"n/a","15-character on SM"]
["Source:",null,"C13",null,null,"Type","Producer Code",null,"oz/100wt",null,"Material Code",null,null,"Product Name",null,"F19","C15","Alphanumeric","Type / Material Code",5,"n/a","Not used on SM"]
["Producer Code:",null,"C14",null,null,"F14","G14",null,"I14",null,"K14",null,null,"N14",null,"F20","D15","Alphanumeric","Cement Material Code",15,"n/a","Material Code needed for edit"]
["Type / Material Code:",null,"C15","D15",null,"F15","G15",null,"I15",null,"K15",null,null,"N15",null,"F21","C16","Numeric","Minimum",3,"pounds"]
["Minimum",null,"C16","lb/cuyd",null,"F16","G16",null,"I16",null,"K16",null,null,"N16",null,"F22","C17","Numeric","Cement Increase",3,"pounds"]
["Cement Increase:",null,"C17","lb/cuyd",null,"F17","G17",null,"I17",null,"K17",null,null,"N17",null,"F23","F12","Label","LIQUID ADMIXTURE DATA","n/a","n/a"]
[null,null,null,null,null,"F18","G18",null,"I18",null,"K18",null,null,"N18",null,"F24","F13","Label","Type","n/a","n/a"]
["FLY ASH DATA",null,null,null,null,"FINE AGGREGATE DATA",null,null,null,null,null,null,null,null,null,"F25","G13","Label","Producer Code","n/a","n/a"]
["Source:",null,"C20",null,null,"Source:",null,null,null,"J20",null,null,null,null,null,"F26","I13","Label","oz/100wt","n/a","n/a"]
["Producer Code:",null,"C21",null,null,"Producer Code:",null,null,null,"J21",null,null,null,null,null,"F27","K13","Label","Material Code","n/a","n/a"]
["Class / Material Code:",null,"C22","D22",null,"Bulk Sp. Gr. (SSD):",null,null,null,"J22",null,null,null,null,null,"F28","N13","Label","Product Name","n/a","n/a"]
["% Replacement:",null,"C23",null,null,"Absorption %:",null,null,null,"J23",null,null,null,null,null,"F29","F14","Alphanumeric","LAD1 Type",3,"n/a","Not used on SM"]
["Replacement Ratio:  1:",null,"C24",null,null,"Free Mositure Content %:",null,null,null,"J24",null,null,null,null,null,"F30","G14","Alphanumeric","LAD1 PS",15,"n/a","15-character on SM"]
["Sp. Gr.:",null,"C25",null,null,"COARSE AGGREGATE DATA",null,null,null,null,null,null,null,null,null,"F31","I14","Numeric","LAD1 Qty",3.1,"oz/100wt","Edit will not be done at this time.  This info is stored in Remarks on SM, not actual numeric data columns."]
[null,null,null,null,null,"Source 1:","G26",null,null,"Producer Code:",null,"L26",null,null,null,"F32","K14","Alphanumeric","LAD1 Material Code",15,"n/a","Material Code needed for edit"]
["GGBFS DATA",null,null,null,null,"Source 2:","G27",null,null,"Producer Code:",null,"L27",null,null,null,"F33","N14","Alphanumeric","LAD1 Product Name",40,"n/a"]
["Source:",null,"C28",null,null,null,null,null,null,"Source 1",null,"Source 2",null,null,null,"F34","F15","Alphanumeric","LAD2 Type",3,"n/a","Not used on SM"]
["Producer Code:",null,"C29",null,null,"Bench / Ledge",null,null,null,"J29","K29","L29","M29",null,null,"F35","G15","Alphanumeric","LAD2 PS",15,"n/a","15-character on SM"]
["% Replacement:",null,"C30",null,null,"Bulk Sp. Gr. (SSD):",null,null,null,"J30",null,"L30",null,null,null,"F36","I15","Numeric","LAD2 Qty",3.1,"oz/100wt","Edit will not be done at this time.  This info is stored in Remarks on SM, not actual numeric data columns."]
["Grade:",null,"C31",null,null,"Absorption %:",null,null,null,"J31",null,"L31",null,null,null,"F37","K15","Alphanumeric","LAD2 Material Code",15,"n/a","Material Code needed for edit"]
["Sp. Gr.:",null,"C32",null,null,"Free Moisture Content %:",null,null,null,"J32",null,"L32",null,null,null,"F38","N15","Alphanumeric","LAD2 Product Name",40,"n/a"]
[null,null,null,null,null,"% Coarse Aggregate:",null,null,null,"J33",null,"L33",null,null,null,"F39","F16","Alphanumeric","LAD3 Type",3,"n/a","Not used on SM"]
["MICROSILICA DATA",null,null,null,null,"Final Blend Size:",null,null,null,"J34",null,null,null,null,null,"F40","G16","Alphanumeric","LAD3 PS",15,"n/a","15-character on SM"]
["Source:",null,"C35",null,null,"MIX DESIGN DATA",null,null,null,null,null,null,null,null,null,"F41","I16","Numeric","LAD3 Qty",3.1,"oz/100wt","Edit will not be done at this time.  This info is stored in Remarks on SM, not actual numeric data columns."]
["Producer Code:",null,"C36",null,null,null,null,null,null,"wt","vol",null,null,null,null,"F42","K16","Alphanumeric","LAD3 Material Code",15,"n/a","Material Code needed for edit"]
["% Replacement:",null,"C37",null,null,null,null,null,null,"lb","cuft",null,null,null,null,"F43","N16","Alphanumeric","LAD3 Product Name",40,"n/a"]
["Sp. Gr.:",null,"C38",null,null,null,null,null,"Cement:","J38","K38",null,null,null,null,"F44","F17","Alphanumeric","LAD4 Type",3,"n/a","Not used on SM"]
[null,null,null,null,null,null,null,null,"Fly Ash:","J39","K39",null,null,null,null,"F45","G17","Alphanumeric","LAD4 PS",15,"n/a","15-character on SM"]
[null,null,null,null,null,null,null,null,"Microsilica:","J40","K40",null,null,null,null,"F46","I17","Numeric","LAD4 Qty",3.1,"oz/100wt","Edit will not be done at this time.  This info is stored in Remarks on SM, not actual numeric data columns."]
["Water Added at Mixer:",null,"C41","lb","E41","gal",null,null,"GGBFS:","J41","K41",null,null,null,null,"F47","K17","Alphanumeric","LAD4 Material Code",15,"n/a","Material Code needed for edit"]
["Free Moisture:",null,"C42","lb","E42","gal",null,null,"Water:","J42","K42",null,null,null,null,"F48","N17","Alphanumeric","LAD4 Product Name",40,"n/a"]
["Water Underrun:",null,"C43","lb","E43","gal",null,null,"Air:","--------","K43",null,null,null,null,"F49","F18","Alphanumeric","LAD5 Type",3,"n/a","Not used on SM"]
["Cementitious Weight:",null,"C44","lb",null,null,null,null,null,null,null,null,null,null,null,"F50","G18","Alphanumeric","LAD5 PS",15,"n/a","15-character on SM"]
["Unit Weight:",null,"C45","lb/cuft",null,null,"Fine Agg. SSD:",null,null,"J45","K45",null,null,null,null,"F51","I18","Numeric","LAD5 Qty",3.1,"oz/100wt","Edit will not be done at this time.  This info is stored in Remarks on SM, not actual numeric data columns."]
["Batch w/c Ratio:",null,"C46",null,null,null,"Coarse Agg. SSD:",null,null,"J46","K46",null,null,null,null,"F52","K18","Alphanumeric","LAD5 Material Code",15,"n/a","Material Code needed for edit"]
[null,null,null,null,null,null,null,null,"Total:","J47","K47",null,null,null,null,"F53","N18","Alphanumeric","LAD5 Product Name",40,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F54","A19","Label","FLY ASH DATA","n/a","n/a"]
[null,null,null,null,null,"Adjusted Fine Agg. wt.:",null,null,null,"J49",null,null,null,null,null,"F55","C20","Alphanumeric","Source",20,"n/a"]
[null,null,null,null,null,"Adjusted Coarse Agg. wt.:",null,null,null,"J50",null,null,null,null,null,"F56","C21","Alphanumeric","Producer Code",15,"n/a","15-character on SM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F57","C22","Alphanumeric","Class / Material Code",1,"n/a","Not used on SM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F58","D22","Alphanumeric","Fly Ash Material Code",15,"n/a","Material Code needed for edit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F59","C23","Numeric","% Replacement",2.1,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F60","C24","Numeric","Replacement Ratio:  1",1.2,"n/a","(Move the entire label to the right until the 2nd \":\" is immediately next to the data entry field - line up the 1st \":\" with the others above it)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F61","C25","Numeric","Sp. Gr.",1.2,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F62","F19","Label","FINE AGGREGATE DATA","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F63","J20","Alphanumeric","Source",20,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F64","J21","Alphanumeric","Producer Code",15,"n/a","15-character on SM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F65","J22","Numeric","Bulk Sp. Gr. (SSD)",1.2,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F66","J23","Numeric","Absorption %",2.2000000000000002,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F67","J24","Numeric","Free Moisture Content %",2.2000000000000002,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F68","A27","Label","GGBFS DATA","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F69","C28","Alphanumeric","Source",20,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F70","C29","Alphanumeric","Producer Code",15,"n/a","15-character on SM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F71","C30","Numeric","% Replacement",2.1,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F72","C31","Numeric","Grade",3,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F73","C32","Numeric","Sp. Gr.",1.2,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F74","F25","Label","COARSE AGGREGATE DATA","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F75","G26","Alphanumeric","Source 1",20,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F76","L26","Alphanumeric","Producer Code",15,"n/a","15-character on SM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F77","G27","Alphanumeric","Source 2",20,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F78","L27","Alphanumeric","Producer Code",15,"n/a","15-character on SM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F79","J28","Label","Source 1","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F80","J29","Alphanumeric","Bench",4,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F81","K29","Alphanumeric","Ledge",4,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F82","J30","Numeric","Bulk Sp. Gr. (SSD)",1.2,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F83","J31","Numeric","Absorption %",2.2000000000000002,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F84","J32","Numeric","Free Moisture Content %",2.2000000000000002,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F85","J33","Numeric","% Coarse Aggregate",2.1,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F86","L28","Label","Source 2","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F87","L29","Alphanumeric","Bench",4,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F88","M29","Alphanumeric","Ledge",4,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F89","L30","Numeric","Bulk Sp. Gr. (SSD)",1.2,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F90","L31","Numeric","Absorption %",2.2000000000000002,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F91","L32","Numeric","Free Moisture Content %",2.2000000000000002,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F92","L33","Numeric","% Coarse Aggregate",2.1,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F93","J34","Numeric","Final Blend Size",3,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F94","A34","Label","MICROSILICA DATA","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F95","C35","Alphanumeric","Source",20,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F96","C36","Alphanumeric","Producer Code",15,"n/a","15-character on SM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F97","C37","Numeric","% Replacement",2.1,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F98","C38","Numeric","Sp. Gr.",1.2,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F99","F35","Label","MIX DESIGN DATA","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F100","J36","Label","wt","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F101","J37","Label","lb","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F102","J36","Label","vol","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F103","J37","Label","cuft","n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F104","J38","Numeric","Cement",3,"pounds","(Field needs to be repositioned - overlapping \"Fly ash)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F105","K38","Numeric","Cement",2.2000000000000002,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F106","J39","Numeric","Fly ash",3,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F107","K39","Numeric","Fly Ash",2.2000000000000002,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F108","J40","Numeric","Microsilica",3,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F109","K40","Numeric","Microsilica",2.2000000000000002,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F110","J41","Numeric","GGBFS",3,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F111","K41","Numeric","GGBFS",2.2000000000000002,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F112","J42","Numeric","Water",3,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F113","K42","Numeric","Water",2.2000000000000002,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F114","K43","Numeric","Air",2.2000000000000002,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F115","J45","Numeric","Fine Agg. SSD",4,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F116","K45","Numeric","Fine Agg. SSD",2.2000000000000002,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F117","J46","Numeric","Coarse Agg. SSD",4,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F118","K46","Numeric","Coarse Agg. SSD",2.2000000000000002,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F119","J47","Numeric","Total",4,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F120","K47","Numeric","Total",2.2000000000000002,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F121","J49","Numeric","Adjusted Fine Agg. wt.",4,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F122","J50","Numeric","Adjusted Coarse Agg. wt.",4,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F123","C41","Numeric","Water Added at Mixer",3,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F124","E41","Numeric","n/a",3.1,"gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F125","C42","Numeric","Free Moisture  ",3.1,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F126","E42","Numeric","n/a",3.1,"gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F127","C43","Numeric","Water Underrun",3.1,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F128","E43","Numeric","n/a",3.1,"gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F129","C44","Numeric","Cementitious Weight:",3,"pounds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F130","C45","Numeric","Unit Weight:",3.2,"pounds per cubic foot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F131","C46","Numeric","Batch w/c Ratio:",1.2,"n/a"]

{"sheet":"discipline","index":7,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["discipline_id","discipline_version","replace_allowed_indicator","district","Filename"]
[{"$f":"Header!R4","v":"CONCMIX"},"v1.0","Y",{"$f":"Header!C14","v":""},{"$f":"Header!C13","v":0}]

{"sheet":"t_smpl","index":8,"n_rows":8,"n_cols":55,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Special Processing",null,null,null,"d",null,"c","c",null,"c","d",null,"d",null,"c","c",null,"c",null,null,null,null,null,null,"c",null,"c","c","c","c","c","c","c","c","c","c","c",null,"c","c","c","c","c","c","c","c","c","c","c","c","c","c","c","c","c"]
["SM Table","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl","t_smpl"]
["SM Column","smpl_id","acpt_meth_t","auth_by_cms_uid","auth_dt","cms_uid","cntrl_nbr","cntrl_t","geog_area_t","intd_use_txt","last_modfd_dt","last_modfd_uid","log_dt","matl_cd","offst","plant_id","prodr_supp_cd","rel_smpl_id","rmrks_id","smpl_dsn_t","smpl_dt","smpl_mix_id","smpl_t","smpld_by","sta","stat_t","witnes_by_cms_uid","prod_nm","plant_t","revise_smpl_id","smpl_origin","smpld_fr_txt","unt_t","mnfctr_cd","twn","buy_usa_ind","buy_usa_rqrdmt_t","repr_qty","ref","seal_nbr","smpl_sz","reqst_by_nm","std_rmrks_ind","smpl_lock_ind","dstnc_fnsh_grd","dstnc_fnsh_grd_unt","ref_doc","sz_unt_t","lock_type","locked_by","lock_dt","lev1_office_ind","lev2_office_nbr","lev3_office_nbr","lev4_office_nbr"]
["Logical Validation","No duplicates of key (highlighted in yellow);\n\nIF Sample ID \"blank\", THEN skip to next record","Existing on t_cd_tbl_dtl (cd_id)\nAND t_cd_tbl_dtl.tbl_id='ACPTMETH'","Existing on t_matl_user \nAND  t_matl_user.smplr_ind='Y\"\nAND  active sampler qualification of \"KRMCA Level II\" \n        (  I.e., At least one row returned from:\n         SELECT * FROM t_insp_qualfn\n         WHERE smpld_by = smpld_by\n         AND      insp_qualfn_t = \"CMXD\"\n         AND      qualfn_lev_t = \"KRT2\"\n         AND      exp_dt >= t_smpl.smpl_dt (same keys as current row)\n         AND      effdt     <= t_smpl.smpl_dt (same keys as current row)   )\n         ",null,"Existing on t_matl_user \nAND t_matl_user.sm_user_ind='Y'",null,null,"Existing on t_cd_tbl_dtl (cd_id)\nAND t_cd_tbl_dtl.tbl_id='GEOGAREA'",null,null,null,null,"Existing on t_matl\nAND t.matl_actvty_stat_t = \"A\"",null,null,"Existing on t_prodr_supp\nAND t_prodr_supp.actvty_stat_t = \"A\"\nAND smpl_dt (below) is between \n            t_prodr_supp_matl.effdt & exp_dt\n            (for the matl_cd above)",null,null,"Existing on t_cd_tbl_dtl (cd_id)\nAND t_cd_tbl_dtl.tbl_id='SMPLDSN'",null,null,"Existing on t_cd_tbl_dtl (cd_id)\nAND t_cd_tbl_dtl.tbl_id='SMPLTYPE'","Existing on t_matl_user \nAND  t_matl_user.smplr_ind='Y\"\nAND  active sampler qualification of \"KRMCA Level II\" \n        (  I.e., At least one row returned from:\n         SELECT * FROM t_insp_qualfn\n         WHERE smpld_by = smpld_by\n         AND      insp_qualfn_t = \"CMXD\"\n         AND      qualfn_lev_t = \"KRT2\"\n         AND      exp_dt >= t_smpl.smpl_dt (same keys as current row)\n         AND      effdt     <= t_smpl.smpl_dt (same keys as current row)   )\n         ",null,"Existing on t_cd_tbl_dtl (cd_id)\nAND t_cd_tbl_dtl.tbl_id='SMPLSTAT'"]
["Comment",null,"Embed code table in spreadsheet","SM User ID from Header","Current system date","SM User ID from Header","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Derived from first two characters of Sample ID","Not Used\nInitialized to \" \" (i.e., space)","Current system date",null,"Current system date",null,"Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)",null,"Not Used\nInitialized to \" \" (i.e., space)","Comes from t_rmks_dtl tab\n(Only QC & QA have active remarks - not active for INFO Samples)",null,"This will be the date when the Contractor submitted the spreadsheet.",null,null,"Sampler ID","Not Used\nInitialized to \" \" (i.e., space)",null,"Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Sum of all the Project Line Item Quantities","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \"\" (i.e., NULL)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)"]
["Long Description","SiteManager \nSample ID ","Acceptance Method","Authorizer SM User ID","Authorization Date","Sample \"Creator\" \nSM User ID","Control Number","Control Type","Geographic Area","Intended Use (of material sampled)","Last Modified Date","Last Modified User ID","Sample Logged Date","Material Code","Offset","Plant ID","Producer / Supplier","Related Sample ID","Remarks ID","Mix Design Type","Sample Date","Mix ID","Sample Type","Sampling Technician (SM User ID)","Station","Sample Status","Sampling KYTC Witness SM User ID ","Product Name","Plant Type","Revised Sample ID","Sample Origin","Sample From","Repr Material Quantity Units","Manufacturer","Town (where sampled)","Buy USA Indicator","Buy USA Requirement Type","Represented Material Quantity","Reference","Sublot Sample","Sample Size","Name of Sample Requester","Standard Remarks Included Indicator","Sample Locked Indicator","Distance From Finished Grade","Distance From Finished Grade Unit","Reference Document","Sample Size Unit","Sample Lock Type","Sample Locked By (SM User ID)","Sample Lock Date","Sample Lock Level 1 Office","Sample Lock Level 2 Office","Sample Lock Level 3 Office","Sample Lock Level 4 Office"]
["User Entry                                     XML Schema \nSheet Map                                   Column Name","smpl_id","acpt_meth_t","auth_by_cms_uid","auth_dt","cms_uid","cntrl_nbr","cntrl_t","geog_area_t","intd_use_txt","last_modfd_dt","last_modfd_uid","log_dt","matl_cd","offst","plant_id","prodr_supp_cd","rel_smpl_id","rmrks_id","smpl_dsn_t","smpl_dt","smpl_mix_id","smpl_t","smpld_by","sta","stat_t","witnes_by_cms_uid","prod_nm","plant_t","revise_smpl_id","smpl_origin","smpld_fr_txt","unt_t","mnfctr_cd","twn","buy_usa_ind","buy_usa_rqrdmt_t","repr_qty","ref","seal_nbr","smpl_sz","reqst_by_nm","std_rmrks_ind","smpl_lock_ind","dstnc_fnsh_grd","dstnc_fnsh_grd_unt","ref_doc","sz_unt_t","lock_type","locked_by","lock_dt","lev1_office_ind","lev2_office_nbr","lev3_office_nbr","lev4_office_nbr"]
[null,{"$f":"Header!C13","v":0},"MDA",{"$f":"Header!K13","v":0},null,{"$f":"Header!K13","v":0}," "," ",{"$f":"Header!C14","v":""}," ",null,{"$f":"Header!K13","v":0},null,{"$f":"Header!C9","v":""}," "," ",{"$f":"IF(Header!K8=\"\",\"\",Header!K8)","v":""}," ",{"$f":"t_rmks_dtl!B8","v":""},"PCC",{"$f":"Header!C7","v":"00:00:00"},{"$f":"Header!C15","v":""},"MDA",{"$f":"Header!K9","v":0}," ","COMP"," "," "," "," "," "," "," "," "," "," "," ",{"$f":"SUM('Project Items'!C6:C105)","v":0}," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," "," "]

{"sheet":"t_cont_smpl","index":9,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":true,"merged":[[3,2,3,4],[3,10,3,12]]}
["Special Processing","x",null,null,null,null,null,"d"]
["SM Table","t_cont_smpl","t_cont_smpl","t_cont_smpl","t_cont_smpl","t_cont_smpl","t_cont_smpl","t_cont_smpl"]
["SM Column","smpl_id","cont_id","prj_nbr","ln_itm_nbr","repr_qty","last_modfd_uid","last_modfd_dt"]
["Logical Validation","No duplicates of key (highlighted in yellow);\n\nIF Sample ID \"blank\", THEN skip to next record","These three keys (and matl_cd from Header tab) must exist on t_cont_streq_matl.",null,null,"IF t_smpl.smpl_t = \"QC\" THEN\n   t_cont_smpl.repr_qty = \n            User Entered \"Represent Quantity\" / J4\nELSE\n   just use User Entered \"Represented Quantity\"\nENDIF\n     ",null,null,null,1,"THERE ARE ACTUALLY 0 QC SAMPLES;\nTHIS IS ACTUALLY AN MDA SAMPLE - DO NOT PERFROM ANY SPECIAL CALC ON repr_qty"]
["Comment",null,null,"THESE THREE FIELDS COME FROM THE FIRST THREE COLUMNS ON THE \"Project Item\" TAB \n(AND EACH ROW ON THAT TAB REPEATS FOR EVERY ROW ON THIS TAB HAVING A \"Sample ID\")",null,null,null,"Current system date"]
["Long Description","SiteManager \nSample ID ","Contract ID","Project Number","Line Item Number","Represented Quantity","Last Modified User ID","Last Modified Date"]
["User Entry                                     XML Schema \nSheet Map                                   Column Name","smpl_id","cont_id","prj_nbr","ln_itm_nbr","repr_qty","last_modfd_uid","last_modfd_dt"]
[null,{"$f":"Header!C13","v":0},{"$f":"Header!C11","v":0},"N/A","N/A","N/A",{"$f":"Header!K13","v":0}]

{"sheet":"t_rmks_dtl","index":10,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Special Processing",null,null,null,null,null,"d"]
["SM Table","t_rmrks_dtl","t_rmrks_dtl","t_rmrks_dtl","t_rmrks_dtl","t_rmrks_dtl","t_rmrks_dtl"]
["SM Column","rmrks_id","rmrks_t","rmrks_sn","rmrks_txt_fld","last_modfd_uid","last_modfd_dt"]
["Logical Validation","No duplicates of key (highlighted in yellow);\n\nIF Sample ID \"blank\", THEN skip to next record"]
["Comment",null,null,null,"Up to 254 char Sample Remark  \n(NOTE: COULD HAVE REMARK FOR EACH TEST.)",null,"Current system date"]
["Long Description","Remark ID","Remark Type","Remark Sequence Number","Remarks","Last Modified User ID","Last Modified Date"]
["User Entry                                     XML Schema \nSheet Map                                   Column Name","rmrks_id","rmrks_t","rmrks_sn","rmrks_txt_fld","last_modfd_uid","last_modfd_dt"]
[null,{"$f":"IF(E8=0,\"\",CONCATENATE(Header!K13,TEXT(NOW(),\"yyyymmddhhmmss\"),RIGHT(Header!C13,2)))","v":""},"GEN",1,{"$f":"Header!C17","v":0},{"$f":"Header!K13","v":0}]

{"sheet":"t_smpl_tst","index":11,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Special Processing",null,null,null,null,"c",null,"c","d",null,"d"]
["SM Table","t_smpl_tst","t_smpl_tst","t_smpl_tst","t_smpl_tst","t_smpl_tst","t_smpl_tst","t_smpl_tst","t_smpl_tst","t_smpl_tst","t_smpl_tst"]
["SM Column","smpl_id","tst_meth","smpl_tst_nbr","lab_id","chrg_amt","strt_dt","est_cmpl_dt","actl_cmpl_dt","last_modfd_uid","last_modfd_dt"]
["Logical Validation","No duplicates of key (highlighted in yellow);\n\nIF Sample ID \"blank\", THEN skip to next record","Existing on t_tst_fee_schd",null,"Existing on t_qualf_lab"]
["Comment",null,null,null,"Lab ID","Not Used\nInitialized to 0","Received Date","Not Used\nInitialized to 0","Current system date",null,"Current system date"]
["Long Description","SiteManager \nSample ID ","Test Method","Test Number","SM Laboratory ID","Charge Amount","Received Date","Actual Start Date","Actual Completion Date","Last Modified User ID","Last Modified Date"]
["User Entry                                     XML Schema \nSheet Map                                   Column Name","smpl_id","tst_meth","smpl_tst_nbr","lab_id","chrg_amt","strt_dt","est_cmpl_dt","actl_cmpl_dt","last_modfd_uid","last_modfd_dt"]
[null,{"$f":"Header!C13","v":0},"COMIXDSGN",1,{"$f":"Header!K15","v":""},0,{"$f":"Header!K14","v":"00:00:00"},"00:00:00",null,{"$f":"Header!K13","v":0}]

{"sheet":"t_smpl_tstr","index":12,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Special Processing",null,null,null,null,null,"d"]
["SM Table","t_smpl_tstr","t_smpl_tstr","t_smpl_tstr","t_smpl_tstr","t_smpl_tstr","t_smpl_tstr"]
["SM Column","smpl_id","tst_meth","smpl_tst_nbr","tst_id","last_modfd_uid","last_modfd_dt"]
["Logical Validation","No duplicates of key (highlighted in yellow);\n",null,null,"Existing on t_matl_user \nAND  t_matl_user.tstr_ind='Y\"\nAND  active test qualification of \"KRMCA Level II\" \n        (  I.e., At least one row returned from:\n         SELECT * FROM t_tst_prsnl_qualfn\n         WHERE tst_id = tst_id\n         AND      tst_prsnlqualfn_t = \"CMXD\"\n         AND      qualfn_lev_t = \"KRT2\"\n         AND      exp_dt >= t_smpl_tst.strt_dt (same keys as current row)\n         AND      effdt     <= t_smpl_tst.strt_dt (same keys as current row)\n\n         For any row above, return at least one row:\n         SELECT * FROM t_tst_prsnqualftst\n         WHERE tst_id = tst_id\n         AND      tst_prsnlqualfn_t = t_tst_prsnl_qualfn.tst_prsnlqualfn_t\n         AND      qualfn_lev_t = t_tst_prsnl_qualfn.qualfn_lev_t\n         AND      effdt = t_tst_prsnl_qualfn.effdt\n         AND      tst_meth = t_smpl_tst.tst_meth   )"]
["Comment",null,null,null,"Slump Tester",null,"Current system date"]
["Long Description","SiteManager \nSample ID","Test Method","Test Number","Tester ID","Last Modified User ID","Last Modified Date"]
["User Entry                                     XML Schema \nSheet Map                                   Column Name","smpl_id","tst_meth","smpl_tst_nbr","tst_id","last_modfd_uid","last_modfd_dt"]
[null,{"$f":"Header!C13","v":0},"COMIXDSGN",1,{"$f":"Header!K13","v":0},{"$f":"Header!K13","v":0}]

{"sheet":"t_tst_rslt_hdr","index":13,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Special Processing",null,null,null,"c","c","d"]
["SM Table","t_tst_rslt_hdr","t_tst_rslt_hdr","t_tst_rslt_hdr","t_tst_rslt_hdr","t_tst_rslt_hdr","t_tst_rslt_hdr","t_tst_rslt_hdr"]
["SM Column","smpl_id","tst_meth","smpl_tst_nbr","rmrks_id","effdt","last_modfd_dt","last_modfd_uid"]
["Logical Validation","No duplicates of key (highlighted in yellow);\n\nIF Sample ID \"blank\", THEN skip to next record"]
["Comment",null,null,null,"Not Used\nInitialized to \" \" (i.e., space)","Test Specification Date (Not used in this discipline)\nInitialized to 0","Current system date"]
["Long Description","Sample ID","Test Method","Test Number","Remarks ID","Effective Date","Last Modified Date","Last Modified User ID"]
["User Entry                                     XML Schema \nSheet Map                                   Column Name","smpl_id","tst_meth","smpl_tst_nbr","rmrks_id","effdt","last_modfd_dt","last_modfd_uid"]
[null,{"$f":"Header!C13","v":0},"COMIXDSGN",1," ",0,null,{"$f":"Header!K13","v":0}]

{"sheet":"t_tst_rslt_dtl","index":14,"n_rows":138,"n_cols":9,"rows_kept":138,"cut":false,"hidden":true,"merged":[]}
["Special Processing",null,null,null,null,null,null,null,"d"]
["SM Table","t_tst_rslt_dtl","t_tst_rslt_dtl","t_tst_rslt_dtl","t_tst_rslt_dtl","t_tst_rslt_dtl","t_tst_rslt_dtl","t_tst_rslt_dtl","t_tst_rslt_dtl"]
["SM Column","smpl_id","tst_meth","smpl_tst_nbr","tst_fld_sn","tst_strg_fld_val","tst_numrc_fld_val","last_modfd_uid","last_modfd_dt"]
["Logical Validation","No duplicates of key (highlighted in yellow);\n\nIF Sample ID \"blank\", THEN skip to next record",null,null,null,"Type & Size (ALL ...fld_val FIELDS)  AND\n\nCHOOSE CASE tst_fld_sn  \n      CASE 18, 30, 35, 40, 45, 50, 56, 64, 70, 76, 78, 96   [Active P/S]\n            Existing on t_prodr_supp\n            AND t_prodr_supp.actvty_stat_t = \"A\"\n      CASE 2   [Code Table check]\n            Existing on t_cd_tbl_dtl (cd_id)\n            AND t_cd_tbl_dtl.tbl_id='TEMPSTAT'\nENDCASE                                                                    MUCH MUCH MORE BELOW.....\n\nCHOOSE CASE tst_fld_sn (First), tst_fld_sn (Second) [Active P/S Material]\n      CASE 20, 18; CASE 58, 56; CASE 32, 30; CASE 37, 35; CASE 42, 40; CASE 47, 45; CASE 52, 50\n            Existing on t_prodr_supp_matl \n                    [where matl_cd = First value (tst_strg_fld_val)\n                     AND   prodr_supp_cd = Second value (tst_strg_fld_val)\n                     AND smpl_dt (Header!C7) >= t_prodr_supp_matl.effdt\n                             smpl_dt (Header!C7) <= t_prodr_supp_matl.exp_dt (except where exp_dt = 0)\n                    [for this same row] \nENDCASE\n\nCHOOSE CASE tst_fld_sn (First), tst_fld_sn (Second), tst_fld_sn (Third) [Active Product]\n      CASE 32, 33, 30; CASE 37, 38, 35; CASE 42, 43, 40; CASE 47, 48, 45; CASE 52, 53, 50\n            Existing on t_apprd_matl \n                    [where matl_cd = First value (tst_strg_fld_val)\n                     AND   prod_nm = Second value (tst_strg_fld_val)\n                     AND   mnfctr_cd = Third value (tst_strg_fld_val)\n                     AND smpl_dt (Header!C7) >= t_apprd_matl.effdt\n                             smpl_dt (Header!C7) <= t_apprd_matl.exp_dt\n                    [for this same row] \nENDCASE","Type & Size"]
["Comment",null,null,null,null,"IF Not Used,\nInitialize to \" \" \n(i.e., space)","IF Not Used\nInitialize to 0",null,"Current system date"]
["Long Description","Sample ID","Test Method","Test Number","Test Field Sequence Number","Test Field String Value","Test Field Numeric Value","Last Modified User ID","Last Modified Date"]
["User Entry                                     XML Schema \nSheet Map                                   Column Name","smpl_id","tst_meth","smpl_tst_nbr","tst_fld_sn","tst_strg_fld_val","tst_numrc_fld_val","last_modfd_uid","last_modfd_dt"]
["Comment  (NOT CURRENTLY USED)",{"$f":"Header!C13","v":0},"COMIXDSGN",1,1," ",0,{"$f":"Header!K13","v":0}]
["Template Status (TEMPSTAT)",{"$f":"B8","v":0},"COMIXDSGN",1,2,{"$f":"IF(t_smpl!Z8=\"COMP\",\"ISPC\",\"OSPC\")","v":"ISPC"},0,{"$f":"H8","v":0}]
["GenericString2  (NOT CURRENTLY USED)",{"$f":"B9","v":0},"COMIXDSGN",1,3," ",0,{"$f":"H9","v":0}]
["GenericNum1  (NOT CURRENTLY USED)",0,"COMIXDSGN",1,4," ",0,0]
["GenericNum2  (NOT CURRENTLY USED)",0,"COMIXDSGN",1,5," ",0,0]
["GenericNum3  (NOT CURRENTLY USED)",0,"COMIXDSGN",1,6," ",0,0]
["GenericNum4  (NOT CURRENTLY USED)",0,"COMIXDSGN",1,7," ",0,0]
["LABEL: CONCRETE SPECIFICATIONS",0,"COMIXDSGN",1,8," ",0,0]
["Class",0,"COMIXDSGN",1,9,{"$f":"IF(Design!H6=\"\",\"\",Design!H6)","v":""},0,0]
["Max. w/c",0,"COMIXDSGN",1,10," ",{"$f":"Design!H7","v":0},0]
["Dsgn Slump",0,"COMIXDSGN",1,11," ",{"$f":"Design!H8","v":0},0]
["Dsgn Air",0,"COMIXDSGN",1,12," ",{"$f":"Design!H9","v":0},0]
["Dsgn Strength",0,"COMIXDSGN",1,13," ",{"$f":"Design!H10","v":0},0]
["at",0,"COMIXDSGN",1,14," ",{"$f":"Design!K10","v":0},0]
["Strength Unit",0,"COMIXDSGN",1,15,{"$f":"IF(Design!L10=\"\",\"\",Design!L10)","v":""},0,0]
["LABEL: CEMENT DATA",0,"COMIXDSGN",1,16," ",0,0]
["Source",0,"COMIXDSGN",1,17,{"$f":"IF(Design!C13=\"\",\"\",Design!C13)","v":""},0,0]
["Producer Code",0,"COMIXDSGN",1,18,{"$f":"IF(Design!C14=\"\",\"\",Design!C14)","v":""},0,0]
["Type / Material Code",0,"COMIXDSGN",1,19,{"$f":"IF(Design!C15=\"\",\"\",Design!C15)","v":""},0,0]
["Cement Material Code",0,"COMIXDSGN",1,20,{"$f":"IF(Design!D15=\"\",\"\",Design!D15)","v":""},0,0]
["Minimum",0,"COMIXDSGN",1,21," ",{"$f":"Design!C16","v":0},0]
["Cement Increase",0,"COMIXDSGN",1,22," ",{"$f":"Design!C17","v":0},0]
["LABEL: LIQUID ADMIXTURE DATA",0,"COMIXDSGN",1,23," ",0,0]
["LABEL: Type",0,"COMIXDSGN",1,24," ",0,0]
["LABEL: Producer Code",0,"COMIXDSGN",1,25," ",0,0]
["LABEL: oz/100wt",0,"COMIXDSGN",1,26," ",0,0]
["LABEL: Material Code",0,"COMIXDSGN",1,27," ",0,0]
["LABEL: Product Name",0,"COMIXDSGN",1,28," ",0,0]
["LAD1 Type",0,"COMIXDSGN",1,29,{"$f":"IF(Design!G14=\"\",\"\",Design!G14)","v":""},0,0]
["LAD1 PS",0,"COMIXDSGN",1,30,{"$f":"IF(Design!J14=\"\",\"\",Design!J14)","v":""},0,0]
["LAD1 Qty",0,"COMIXDSGN",1,31," ",{"$f":"Design!L14","v":0},0]
["LAD1 Material Code",0,"COMIXDSGN",1,32,{"$f":"IF(Design!F14=\"\",\"\",Design!F14)","v":""},0,0]
["LAD1 Product Name",0,"COMIXDSGN",1,33,{"$f":"IF(Design!H14=\"\",\"\",Design!H14)","v":""},0,0]
["LAD2 Type",0,"COMIXDSGN",1,34,{"$f":"IF(Design!G15=\"\",\"\",Design!G15)","v":""},0,0]
["LAD2 PS",0,"COMIXDSGN",1,35,{"$f":"IF(Design!J15=\"\",\"\",Design!J15)","v":""},0,0]
["LAD2 Qty",0,"COMIXDSGN",1,36," ",{"$f":"Design!L15","v":0},0]
["LAD2 Material Code",0,"COMIXDSGN",1,37,{"$f":"IF(Design!F15=\"\",\"\",Design!F15)","v":""},0,0]
["LAD2 Product Name",0,"COMIXDSGN",1,38,{"$f":"IF(Design!H15=\"\",\"\",Design!H15)","v":""},0,0]
["LAD3 Type",0,"COMIXDSGN",1,39,{"$f":"IF(Design!G16=\"\",\"\",Design!G16)","v":""},0,0]
["LAD3 PS",0,"COMIXDSGN",1,40,{"$f":"IF(Design!J16=\"\",\"\",Design!J16)","v":""},0,0]
["LAD3 Qty",0,"COMIXDSGN",1,41," ",{"$f":"Design!L16","v":0},0]
["LAD3 Material Code",0,"COMIXDSGN",1,42,{"$f":"IF(Design!F16=\"\",\"\",Design!F16)","v":""},0,0]
["LAD3 Product Name",0,"COMIXDSGN",1,43,{"$f":"IF(Design!H16=\"\",\"\",Design!H16)","v":""},0,0]
["LAD4 Type",0,"COMIXDSGN",1,44,{"$f":"IF(Design!G17=\"\",\"\",Design!G17)","v":""},0,0]
["LAD4 PS",0,"COMIXDSGN",1,45,{"$f":"IF(Design!J17=\"\",\"\",Design!J17)","v":""},0,0]
["LAD4 Qty",0,"COMIXDSGN",1,46," ",{"$f":"Design!L17","v":0},0]
["LAD4 Material Code",0,"COMIXDSGN",1,47,{"$f":"IF(Design!F17=\"\",\"\",Design!F17)","v":""},0,0]
["LAD4 Product Name",0,"COMIXDSGN",1,48,{"$f":"IF(Design!H17=\"\",\"\",Design!H17)","v":""},0,0]
["LAD5 Type",0,"COMIXDSGN",1,49,{"$f":"IF(Design!G18=\"\",\"\",Design!G18)","v":""},0,0]
["LAD5 PS",0,"COMIXDSGN",1,50,{"$f":"IF(Design!J18=\"\",\"\",Design!J18)","v":""},0,0]
["LAD5 Qty",0,"COMIXDSGN",1,51," ",{"$f":"Design!L18","v":0},0]
["LAD5 Material Code",0,"COMIXDSGN",1,52,{"$f":"IF(Design!F18=\"\",\"\",Design!F18)","v":""},0,0]
["LAD5 Product Name",0,"COMIXDSGN",1,53,{"$f":"IF(Design!H18=\"\",\"\",Design!H18)","v":""},0,0]
["LABEL: FLY ASH DATA",0,"COMIXDSGN",1,54," ",0,0]
["Source",0,"COMIXDSGN",1,55,{"$f":"IF(Design!C20=\"\",\"\",Design!C20)","v":""},0,0]
["Producer Code",0,"COMIXDSGN",1,56,{"$f":"IF(Design!C21=\"\",\"\",Design!C21)","v":""},0,0]
["Class / Material Code",0,"COMIXDSGN",1,57,{"$f":"IF(Design!C22=\"\",\"\",Design!C22)","v":""},0,0]
["Fly Ash Material Code",0,"COMIXDSGN",1,58,{"$f":"IF(Design!D22=\"\",\"\",Design!D22)","v":""},0,0]
["% Replacement",0,"COMIXDSGN",1,59," ",{"$f":"Design!C23","v":0},0]
["Replacement Ratio:  1",0,"COMIXDSGN",1,60," ",{"$f":"Design!C24","v":0},0]
["Sp. Gr.",0,"COMIXDSGN",1,61," ",{"$f":"Design!C25","v":0},0]
["LABEL: FINE AGGREGATE DATA",0,"COMIXDSGN",1,62," ",0,0]
["Source",0,"COMIXDSGN",1,63,{"$f":"IF(Design!J20=\"\",\"\",Design!J20)","v":""},0,0]
["Producer Code",0,"COMIXDSGN",1,64,{"$f":"IF(Design!J21=\"\",\"\",Design!J21)","v":""},0,0]
["Bulk Sp. Gr. (SSD)",0,"COMIXDSGN",1,65," ",{"$f":"Design!J22","v":0},0]
["Absorption %",0,"COMIXDSGN",1,66," ",{"$f":"Design!J23","v":0},0]
["Free Moisture Content %",{"$f":"B73","v":0},"COMIXDSGN",1,67," ",{"$f":"Design!J24","v":0},{"$f":"H73","v":0}]
["LABEL: GGBFS DATA",0,"COMIXDSGN",1,68," ",0,0]
["Source",0,"COMIXDSGN",1,69,{"$f":"IF(Design!C28=\"\",\"\",Design!C28)","v":""},0,0]
["Producer Code",0,"COMIXDSGN",1,70,{"$f":"IF(Design!C29=\"\",\"\",Design!C29)","v":""},0,0]
["% Replacement",0,"COMIXDSGN",1,71," ",{"$f":"Design!C30","v":0},0]
["Grade",0,"COMIXDSGN",1,72," ",{"$f":"Design!C31","v":0},0]
["Sp. Gr.",0,"COMIXDSGN",1,73," ",{"$f":"Design!C32","v":0},0]
["LABEL: COARSE AGGREGATE DATA",0,"COMIXDSGN",1,74," ",0,0]
["Source 1",0,"COMIXDSGN",1,75,{"$f":"IF(Design!G26=\"\",\"\",Design!G26)","v":""},0,0]
["Producer Code",0,"COMIXDSGN",1,76,{"$f":"IF(Design!L26=\"\",\"\",Design!L26)","v":""},0,0]
["Source 2",0,"COMIXDSGN",1,77,{"$f":"IF(Design!G27=\"\",\"\",Design!G27)","v":""},0,0]
["Producer Code",0,"COMIXDSGN",1,78,{"$f":"IF(Design!L27=\"\",\"\",Design!L27)","v":""},0,0]
["LABEL: Source 1",0,"COMIXDSGN",1,79," ",0,0]
["Bench",0,"COMIXDSGN",1,80,{"$f":"IF(Design!J29=\"\",\"\",Design!J29)","v":""},0,0]
["Ledge",0,"COMIXDSGN",1,81,{"$f":"IF(Design!K29=\"\",\"\",Design!K29)","v":""},0,0]
["Bulk Sp. Gr. (SSD)",0,"COMIXDSGN",1,82," ",{"$f":"Design!J30","v":0},0]
["Absorption %",0,"COMIXDSGN",1,83," ",{"$f":"Design!J31","v":0},0]
["Free Moisture Content %",0,"COMIXDSGN",1,84," ",{"$f":"Design!J32","v":0},0]
["% Coarse Aggregate",0,"COMIXDSGN",1,85," ",{"$f":"Design!J33","v":0},0]
["LABEL: Source 2",0,"COMIXDSGN",1,86," ",0,0]
["Bench",0,"COMIXDSGN",1,87,{"$f":"IF(Design!L29=\"\",\"\",Design!L29)","v":""},0,0]
["Ledge",0,"COMIXDSGN",1,88,{"$f":"IF(Design!M29=\"\",\"\",Design!M29)","v":""},0,0]
["Bulk Sp. Gr. (SSD)",0,"COMIXDSGN",1,89," ",{"$f":"Design!L30","v":0},0]
["Absorption %",0,"COMIXDSGN",1,90," ",{"$f":"Design!L31","v":0},0]
["Free Moisture Content %",0,"COMIXDSGN",1,91," ",{"$f":"Design!L32","v":0},0]
["% Coarse Aggregate",0,"COMIXDSGN",1,92," ",{"$f":"Design!L33","v":0},0]
["Final Blend Size",0,"COMIXDSGN",1,93," ",{"$f":"IF(Design!J34=\"9-M\",9,Design!J34)","v":0},0]
["LABEL: MICROSILICA DATA",0,"COMIXDSGN",1,94," ",0,0]
["Source",0,"COMIXDSGN",1,95,{"$f":"IF(Design!C35=\"\",\"\",Design!C35)","v":""},0,0]
["Producer Code",0,"COMIXDSGN",1,96,{"$f":"IF(Design!C36=\"\",\"\",Design!C36)","v":""},0,0]
["% Replacement",0,"COMIXDSGN",1,97," ",{"$f":"Design!C37","v":0},0]
["Sp. Gr.",0,"COMIXDSGN",1,98," ",{"$f":"Design!C38","v":0},0]
["LABEL: MIX DESIGN DATA",0,"COMIXDSGN",1,99," ",0,0]
["LABEL: wt",0,"COMIXDSGN",1,100," ",0,0]
["LABEL: lb",0,"COMIXDSGN",1,101," ",0,0]
["LABEL: vol",0,"COMIXDSGN",1,102," ",0,0]
["LABEL: cuft",0,"COMIXDSGN",1,103," ",0,0]
["Cement",0,"COMIXDSGN",1,104," ",{"$f":"Design!J38","v":0},0]
["Cement",0,"COMIXDSGN",1,105," ",{"$f":"Design!K38","v":0},0]
["Fly ash",0,"COMIXDSGN",1,106," ",{"$f":"Design!J39","v":0},0]
["Fly Ash",0,"COMIXDSGN",1,107," ",{"$f":"Design!K39","v":0},0]
["Microsilica",0,"COMIXDSGN",1,108," ",{"$f":"Design!J40","v":0},0]
["Microsilica",0,"COMIXDSGN",1,109," ",{"$f":"Design!K40","v":0},0]
["GGBFS",0,"COMIXDSGN",1,110," ",{"$f":"Design!J41","v":0},0]
["GGBFS",0,"COMIXDSGN",1,111," ",{"$f":"Design!K41","v":0},0]
["Water",0,"COMIXDSGN",1,112," ",{"$f":"Design!J42","v":0},0]
["Water",0,"COMIXDSGN",1,113," ",{"$f":"Design!K42","v":0},0]
["Air",0,"COMIXDSGN",1,114," ",{"$f":"Design!K43","v":0},0]
["Fine Agg. SSD",0,"COMIXDSGN",1,115," ",{"$f":"Design!J45","v":0},0]
["Fine Agg. SSD",0,"COMIXDSGN",1,116," ",{"$f":"Design!K45","v":0},0]
["Coarse Agg. SSD",0,"COMIXDSGN",1,117," ",{"$f":"Design!J46","v":0},0]
["Coarse Agg. SSD",0,"COMIXDSGN",1,118," ",{"$f":"Design!K46","v":0},0]
["Total",0,"COMIXDSGN",1,119," ",{"$f":"Design!J47","v":0},0]
["Total",0,"COMIXDSGN",1,120," ",{"$f":"Design!K47","v":0},0]
["Adjusted Fine Agg. wt.",0,"COMIXDSGN",1,121," ",{"$f":"Design!J49","v":0},0]
["Adjusted Coarse Agg. wt.",0,"COMIXDSGN",1,122," ",{"$f":"Design!J50","v":0},0]
["Water Added at Mixer",0,"COMIXDSGN",1,123," ",{"$f":"Design!C41","v":0},0]
["n/a",0,"COMIXDSGN",1,124," ",{"$f":"Design!E41","v":0},0]
["Free Moisture  ",0,"COMIXDSGN",1,125," ",{"$f":"Design!C42","v":0},0]
["n/a",0,"COMIXDSGN",1,126," ",{"$f":"Design!E42","v":0},0]
["Water Underrun",0,"COMIXDSGN",1,127," ",{"$f":"Design!C43","v":0},0]
["n/a",0,"COMIXDSGN",1,128," ",{"$f":"Design!E43","v":0},0]
["Cementitious Weight:",0,"COMIXDSGN",1,129," ",{"$f":"Design!C44","v":0},0]
["Unit Weight:",0,"COMIXDSGN",1,130," ",{"$f":"Design!C45","v":0},0]
["Batch w/c Ratio:",{"$f":"B137","v":0},"COMIXDSGN",1,131," ",{"$f":"Design!C46","v":0},{"$f":"H137","v":0}]

{"sheet":"t_pcc","index":15,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Special Processing",null,null,null,null,null,null,"d",null,"d",null,"c","c","c","c","c","c","c","c","c","c","c",null,"d"]
["SM Table","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc","t_pcc"]
["SM Column","mix_id","matl_cd","dsn_t","prodr_supp_cd","dsnr_nm","conc_clas_t","effdt","term_dt","apprd_dt","apprd_by_uid","min_avg_strgh_rqrd","dsn_strgh_spc","theo_unt_wt","theo_unt_wt_unt","h2o_cem_ratio","unt_wt_m","unt_wt_meas_unt","air_cntnt_m","slmp_m","slmp_meas_unt","rmrks_id","last_modfd_uid","last_modfd_dt"]
["Logical Validation","No duplicates of key (highlighted in yellow);\n",null,null,"Existing on t_prodr_supp\nAND t_prodr_supp.actvty_stat_t = \"A\"\nAND smpl_dt (since only 1 sample) is between \n            t_prodr_supp_matl.effdt & exp_dt\n            (for the matl_cd above)","Existing on t_matl_user \nAND  t_matl_user.smplr_ind='Y\"\nAND  active sampler qualification of \"KRMCA Level II\" \n        (  I.e., At least one row returned from:\n         SELECT * FROM t_insp_qualfn\n         WHERE smpld_by = smpld_by\n         AND      insp_qualfn_t = \"CMXD\"\n         AND      qualfn_lev_t = \"KRT2\"\n         AND      exp_dt >= t_smpl.smpl_dt (since only 1 sample)\n         AND      effdt     <= t_smpl.smpl_dt (since only 1 sample)\n         ","Existing on t_cd_tbl_dtl (cd_id)\nAND t_cd_tbl_dtl.tbl_id='PCCCLASS'"]
["Comment",null,null,null,null,null,null,"Current system date","Initialize with no termination date, i.e., zero (\"0\").","Current system date",null,"Not Used\nInitialized to 0",null,null,"Not Used\nInitialized to \" \" (i.e., space)",null,null,null,null,null,null,"DO WE WANT TO COPY THE REMARK FROM THE HEADER HERE (as well as on the sample????)",null,"Current system date"]
["Long Description","Mix ID","Material Code","Design Type","Producer Supplier Code","Designer Name","Concrete Class Type","Effective Date","Termination Date","Approved Date","Approved By User ID","Min Average Strength Required","Design Strength Specified","Theoretical Unit Wt","Theoretical Unit Wt Unit Type","Water Cement Ratio","Unit Weight Measured","Unit Weight Measured Unit Type","Air Content Measured","Slump Measured","Slump Measured Unit Type","Remarks","Last Modified User ID","Last Modified Date"]
["User Entry                                     XML Schema \nSheet Map                                   Column Name","mix_id","matl_cd","dsn_t","prodr_supp_cd","dsnr_nm","conc_clas_t","effdt","term_dt","apprd_dt","apprd_by_uid","min_avg_strgh_rqrd","dsn_strgh_spc","theo_unt_wt","theo_unt_wt_unt","h2o_cem_ratio","unt_wt_m","unt_wt_meas_unt","air_cntnt_m","slmp_m","slmp_meas_unt","rmrks_id","last_modfd_uid","last_modfd_dt"]
[null,{"$f":"Header!C15","v":""},{"$f":"Header!C9","v":""},"PCC",{"$f":"Header!K8","v":""},{"$f":"Header!K9","v":0},{"$f":"Header!C8","v":0},null,null,null,{"$f":"Header!K13","v":0},0,0,0," ",0,0," ",0,0," "," ",{"$f":"Header!K13","v":0}]

{"sheet":"Drop_Downs_and_Tables","index":16,"n_rows":271,"n_cols":24,"rows_kept":271,"cut":false,"hidden":true,"merged":[[97,4,97,9],[97,14,97,15],[93,4,93,9],[94,4,94,9],[95,4,95,9],[96,4,96,9],[96,14,96,15],[88,4,88,9],[89,4,89,9],[90,4,90,9],[91,4,91,9],[92,4,92,9]]}
["HOUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Producer Number","Name"]
["DAY",null,null,null,null,null,null,null,null,null,null,null,null,"Removed from list 10/26/11 as per Michael Black"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AAHP","AA HPC",40990,7,1,1,null,null,null,"COP000000      ","SRM CONCRETE @ CALVERT CITY"]
[null,null,null,null,"AGG","CEM",null,"Coarse Aggregate Sizes",null,null,null,null,null,"AAHF","AA HPC Freeze-Thaw",40995,8,1,1,null,null,null,"COP000001      ","SRM CONCRETE @ CADIZ"]
["A","A",40900,1,1,1,"Selected Material:",{"$f":"VLOOKUP(Header!C8,Drop_Downs_and_Tables!A5:D30,4,FALSE)","v":{"$error":"#N/A"}},1,2,3,4,null,null,null,null,null,null,null,null,null,null,"COP000002      ","IMI @ HOPKINSVILLE"]
["AFT","A Freeze-Thaw",41435,2,1,1,"CA Size Group:",{"$f":"VLOOKUP(Header!C8,Drop_Downs_and_Tables!A5:E30,5,FALSE)","v":{"$error":"#N/A"}},57,67,57,"9-M",null,null,null,null,null,null,null,null,null,null,"COP000003      ","IMI @ OAKGROVE II"]
["AMOD","A Mod",40960,3,2,1,"cbCASize:","",67,68,67,null,null,null,null,null,null,null,null,null,null,null,"COP000004      ","IMI (CASKEY LANE) @ HOPKINSVILLE"]
["AMAS","A Mass",41075,4,1,2,null,null,68,78,68,null,null,null,null,null,null,null,null,null,null,null,"COP000005      ","MEUTH CONCRETE @ MADISONVILLE"]
["AA","AA",40980,5,1,1,null,null,78,8,78,null,null,null,null,null,null,null,null,null,null,null,"COP000006      ","MEUTH CONCRETE @ MORGANFIELD"]
["AAFT","AA Freeze-Thaw",40985,6,1,1,null,null,8,"9-M",8,null,null,null,null,null,null,null,null,null,null,null,"COP000007      ","IMI @ HENDERSON"]
["AAMS","AA Mass",41085,9,1,2,null,null,"9-M",null,"9-M",null,null,null,null,null,null,null,null,null,null,null,"COP000008      ","MEUTH CONCRETE @ HENDERSON"]
["AAAF","AAA Freeze-Thaw",41040,10,2,1,null,null,null,null,357,null,null,null,null,null,null,null,null,null,null,null,"COP000009      ","MEUTH CONCRETE @ OWENSBORO"]
["B","B",41095,11,3,1,null,null,null,null,467,null,null,null,null,null,null,null,null,null,null,null,"COP000010      ","MEUTH CONCRETE @ SEBREE"]
["D","D",41215,12,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000011      ","HANCOCK COUNTY READY MIX #1 @ HAWESVILLE"]
["DMOD","D Mod",41235,13,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000012      ","IMI @ MORGANFIELD"]
["M1","M1",41255,14,1,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000013      ","IMI @ CENTRAL CITY"]
["M1FT","M1 Freeze-Thaw",41440,15,1,3,null,null,null,null,null,null,null,"Old Data in Version 2.1.  Took out IP, IS and I(SM)",null,null,null,null,null,null,null,null,"COP000014      ","IMI @ MADISONVILLE"]
["M2","M2",41255,16,1,4,"Cement:",{"$f":"IF(ISERROR(VLOOKUP(Header!C8,Drop_Downs_and_Tables!A5:EF34,6,FALSE)),0,VLOOKUP(Header!C8,Drop_Downs_and_Tables!A5:EF34,6,FALSE))","v":0},1,2,3,4,null,1,2,3,4,null,null,null,null,null,"COP000015      ","OWENSBORO CONCRETE PLANT #1 @ OWENSBORO"]
["M2FT","M2 Freeze-Thaw",41440,17,1,4,null,null,"I","I","I","III",null,"I","I","I","III",null,null,null,null,null,"COP000016      ","OHIO COUNTY CONCRETE (PREV HB STANLEY)"]
["PFT","P Freeze-Thaw",41290,18,1,1,null,null,"IL","IL","IL","RAPID SET",null,"IA","IA","IA","RAPID SET",null,null,null,null,null,"COP000017      ","IMI @ GLASGOW"]
["J24","JPCP 24 Freeze-Thaw",41310,19,1,2,null,null,"II","II",null,null,null,"II","II","IP",null,null,null,null,null,null,"COP000018      ","IMI @ RUSSELLVILLE"]
["J48","JPCP 48 Freeze-Thaw",41320,20,1,2,null,null,"III","IIA",null,null,null,"III","IP","IS",null,null,null,null,null,null,"COP000019      ","TRAVIS READY MIX @ TOMPKINSVILLE"]
["J72","JPCP 72 Freeze-Thaw",41330,21,1,2,null,null,"IIA",null,null,null,null,"IP","IIA","I(SM)",null,null,null,null,null,null,"COP000020      ","KENWAY CONCRETE @ BOWLING GREEN"]
["J24T","JPCP 24 (Type III) Freeze-Thaw",41310,22,1,4,null,null,"K",null,null,null,null,"IIA","IS",null,null,null,null,null,null,null,"COP000021      ","KENWAY CONCRETE @ GLASGOW"]
["J48T","JPCP 48 (Type III) Freeze-Thaw",41320,23,1,4,null,null,"RAPID SET",null,null,null,null,"K","I(SM)",null,null,null,null,null,null,null,"COP000022      ","BRECKINRIDGE READY MIX @ HARDINSBURG"]
["J72T","JPCP 72 (Type III) Freeze-Thaw",41330,24,1,4,null,null,null,null,null,null,null,"RAPID SET",null,null,null,null,null,null,null,null,"COP000023      ","GRAYSON COUNTY READY MIX @ LEITCHFIELD"]
["SEAL","Seal",41280,25,1,1,null,null,null,null,null,null,null,"IS",null,null,null,null,null,null,null,null,"COP000024      ","IMI @ LEITCHFIELD"]
["LOSO","Low Slump Overlay Freeze-Thaw",41350,26,4,1,null,null,"Indicates placement of IP, IS, or I(SM)",null,null,null,null,"I(SM)",null,null,null,null,null,null,null,null,"COP000025      ","IMI @ ELIZABETHTOWN"]
["CUS","Custom",41980,27,3,1,null,null,"in special cases.",null,null,null,null,"Also change ranges accordingly in:",null,null,null,null,null,null,null,null,"COP000026      ","IMI @ RADCLIFF"]
["CUSF","Custom Freeze-Thaw",41990,28,1,1,null,null,null,null,null,null,null,"Private Sub cbCementType_DropButtonClick()",null,null,null,null,null,null,null,null,"COP000027      ","IMI @ HORSE CAVE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000028      ","KENTUCKY CONCRETE @ HODGENVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000029      ","IMI @ LEBANON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000030      ","IMI @ BARDSTOWN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000031      ","IMI @ MT WASHINGTON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000032      ","IMI @ CAMPBELLSVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000033      ","IMI @ SPRINGFIELD"]
["CUYD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000034      ","SMYRNA READY MIX @ RADCLIFF"]
["CU M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000035      ","SPURLINO MATERIALS @ CLEVES, OH"]
[null,null,null,"Dist","Lab ID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000036      ","ERNST CONCRETE @ PENDLETON"]
["YES","no longer used",null,"D-1","LU01210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000037      ","ERNST CONCRETE DT@ LOUISVILLE "]
["NO","no longer used",null,"D-2","LU02210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000038      ","HARROD CONCRETE @ FRANKFORT"]
[null,null,null,"D-3","LU03210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000039      ","IMI @ MIDDLETOWN"]
[0.2,null,null,"D-4","LU04210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000040      ","IMI @ SHELBYVILLE"]
[0.4,null,null,"D-5","LU05210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000041      ","IMI @ TAYLORSVILLE"]
[null,null,null,"D-6","LU06210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000042      ","IMI @ CARROLLTON"]
["TYP1",null,null,"D-7","LU07210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000043      ","IMI @ OWENTON"]
["TYP2",null,null,"D-8","LU08210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000044      ","GRANT COUNTY CONCRETE #1 @ DRY RIDGE"]
["TYP3",null,null,"D-9","LU09210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000045      ","REIS CONCRETE @ ALEXANDRIA"]
["TYP4",null,null,"D-10","LU10210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000046      ","REIS CONCRETE @ FALMOUTH"]
["TYP5",null,null,"D-11","LU11210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000047      ","IMI @ WALTON"]
["TYP6",null,null,"D-12","LU12210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000048      ","IMI @ DRY RIDGE"]
[null,null,null,"CO","LU00644",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000049      ","SMYRNA READY MIX @ SPARTA"]
["in","no longer used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000050      ","IMI @ LAWRENCEBURG"]
["mm","no longer used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000051      ","IMI @ PARIS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000052      ","CONCRETE MATERIALS (500) @ RICHMOND"]
["F","no longer used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000053      ","CONCRETE MATERIALS @ DANVILLE"]
["C","no longer used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000054      ","IMI @ WINCHESTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000055      ","IMI @ SHEPARDSVILLE"]
["lbs","no longer used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000056      ","CENTRAL READY MIX @ WINCHESTER"]
["N","no longer used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000057      "," IMI  (TRUCK MIX) @ LEXINGTON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000058      ","HARROD CONCRETE (BLUE SKY) @ LEXINGTON"]
["psi","no longer used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000059      ","IMI @ NICHOLASVILLE"]
["Mpa","no longer used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000060      ","CONCRETE MATERIALS (100) @ RICHMOND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000061      ","IMI @ HARRODSBURG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000062      ","WELLS GROUP @ MT STERLING"]
["COMP","COMPLETE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000063      ","IMI (SELINDA#1) @ LOUISVILLE"]
["FAIL","FAILED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000064      ","ALBANY READY MIX @ ALBANY"]
["FRFP","FAILED AND REMOVED FROM PROJECT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000065      ","READY MIX CONCRETE AND BLOCK @ BRONSTON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000066      ","TRIPLE CROWN CONCRETE @ SOMERSET"]
["57, 67, 68",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000067      ","BUILDERS CONCRETE AND BLOCK @ RICHMOND"]
["8, 78, 9m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000068      ","TRIPLE CROWN CONCRETE @ RUSSELL SPRINGS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000069      ","MAYSVILLE READY MIX @ ABERDEEN, OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000070      ","WELLS GROUP @ FLEMINGSBURG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000071      ","WELLS GROUP @ CAMPTON"]
["CONCPVMT","Concrete Payment Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000072      ","GENERAL READY MIX  @ ASHLAND"]
["STRCONC","Structural Concrete Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000073      ","PORTSMOUTH READY MIX @ WHEELERSBURG, OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000074      ","WELLS GROUP @ JACKSON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000075      ","HOME LUMBER COMPANY @ HAZARD"]
["SQYD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000076      ","WELLS GROUP @ WEST LIBERTY"]
["SQ M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000077      ","WELLS GROUP @ ULYSSES"]
["CUYD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000078      ","WELLS GROUP @ SALYERSVILLE"]
["CU M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000079      ","CONCRETE MATERIALS @ RAVENNA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000080      ","WELLS GROUP @ BEATTYVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000081      ","WELLS GROUP @ CLAY CITY"]
["4x8","4x8 Cylinders",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000082      ","TRIPLE CROWN CONCRETE @ LONDON"]
["6x12","6x12 Cylinders",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000083      ","TRI-COUNTY READY MIX @ BARBOURVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000084      ","WELLS GROUP @ PRESTONSBURG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000085      ","WELLS GROUP @ SHELBIANA"]
["Sample Status",null,null,null,"various (Sample Pass/Fail on Details)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000086      ","RIGHT BEAVER CONCRETE @ LACKEY"]
["Sample Type",null,null,null,"various (see below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000087      ","CENTRAL KENTUCKY MIXED CONCRETE @ BEREA"]
["Acceptance Method",null,null,null,{"$f":"E108","v":"TR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000088      ","MORAINE MATERIALS @ FLORENCE"]
["Test Method",null,null,null,"various (see below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000089      ","IMI @ SCOTTSVILLE"]
["Overwrite Capable",null,null,null,"Y",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000090      ","IMI @ ELKTON"]
["Contract Spec Year",null,null,null,2004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000091      ","CORBIN MATERIALS @ CORBIN"]
["Sample Design Type",null,null,null,"PCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000092      ","SRM CONCRETES @ MAYFIELD"]
["Control Type",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000093      ","HAZARD CONCRETE @ HAZARD"]
["Control Number",null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Seal Number",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,"COP000094      ","BOWLING GREEN CONCRETE #1 @ BOWLING GREEN"]
["Remark ID",null,null,null,{"$f":"CONCATENATE(#REF!,TEXT(NOW(),\"yyyymmddhhmmss\"))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Remark Type","GEN",null,null,null,null,"Remark SN",1,null,"COP000095      ","MEUTH CONCRETE @ EDDYVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000096      ","LINCOLN COUNTY READY MIX @ STANFORD"]
["SMPLTYPE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000097      ","LINCOLN COUNTY READY MIX @ DANVILLE"]
["QA",null,null,null,"QA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000098      ","IMI @ EDMONTON"]
["QC",null,null,null,"QC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000099      ","MOUNTAIN CONSTRUCTION CONCRETE @ GRAYS KNOB"]
["INFORMATIONAL",null,null,null,"INFO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000100      ","MOUNTAIN CONSTRUCTION CONCRETE @ LOYALL"]
["PROJECT ACCEPTANCE",null,null,null,"PACP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000101      ","SOUTHEAST KENTUCKY MIXED CONCRETE @ LILY KY"]
["MIX DESIGN APPROVAL",null,null,null,"MDA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000102      ","SOUTHERN CONCRETE @ PARIS, TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000103      ","SOUTHERN CONCRETE @ UNION CITY, TN"]
["ACPTMETH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000104      ","WELLS GROUP @ LOUISA"]
["TEST RESULTS",null,null,null,"TR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000105      ","COUNTY CONCRETE @ FLEMINGSBURG"]
["MIX DESIGN APPROVAL",null,null,null,"MDA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000106      ","PICKETT CONCRETE @ MOREHEAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000107      ","IMI @ OAKGROVE GATE 7 II"]
["SM Field \"Defaults\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000109      ","ERNST CONCRETE @ WALTON"]
["BLANK",null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000110      ","WELLS GROUP @ ASHLAND"]
["ZERO",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000111      ","IMI @ WARSAW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000112      ","IMI @ BRANDENBURG"]
["MATLCATG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000113      ","CONCRETE AND MASONRY PRODUCTS @ HARLAN"]
["CONCRETE MIX DESIGN",null,null,null,"CMXD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000114      ","WELLS GROUP @ VANCEBURG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000115      ","WELLS GROUP @ SOUTH WILLIAMSON"]
["SMPLSTAT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000116      ","WELLS GROUP @ JENKINS"]
["COMPLETE",null,null,null,"COMP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000117      ","TUCKER READY MIX @ LONDON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000118      ","MCGOVNEY READY MIX @ PORTSMOUTH, OH"]
["TST_METH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000119      ","SMYRNA READY MIX @ ELIZABETHTOWN"]
["Conc Plastic Tests",null,null,null,"COCONCPLAS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000120      ","PIKEVILLE READY MIX @ BLACKBERRY"]
["Conc Comp Strength",null,null,null,"COCONCCOMP ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000121      ","IMI @ MORGANTOWN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000122      ","IRVING CONCRETE @ IRVING"]
["CNTRLTYP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000123      ","READY MIX CONCRETE @ LEXINGTON/ PREV CROUSE"]
["LOT NUMBER",null,null,null,"LNBR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000124      ","CUMBERLAND CONCRETE @ CUMBERLAND"]
["BATCH NUMBER",null,null,null,"BNBR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000125      ","TRIPLE CROWN CONCRETE @ MT VERNON"]
["HEAT NUMBER",null,null,null,"HNBR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000126      ","IMI @ FRANKLIN"]
["CYLINDER NUMBER",null,null,null,"CNBR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000127      ","CONCRETE PRODUCTS @ MIDDLESBORO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000128      ","BARREN COUNTY READY MIX @ GLASGOW"]
["QUALEV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000129      ","IMI @ BOWLING GREEN (SOUTH)"]
["ACI LEVEL I",null,null,null,"ACI1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000130      ","IMI @ BOWLING GREEN (NORTH)"]
["KRMCA TECHNICIAN LEVEL II",null,null,null,"KRT2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000131      ","IMI @ CYNTHIANA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000132      ","MEUTH CONCRETE @ CENTRAL CITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000133      ","ROCKPORT CONCRETE @ ROCKPORT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000134      ","S&S CONCRETE @ GRAYSON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000135      ","S&S CONCRETE @ BROWNSVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000136      ","HOME LUMBER COMPANY @ WHITESBURG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000137      ","SMYRNA READY MIX (DANA) @ ELIZABETHTOWN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000138      ","TRIPLE CROWN CONCRETE @ CORBIN \"BYPASS 3041\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000139      ","TRI COUNTY CONCRETE @ PAINTSVILLE KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000140      ","MRC MATERIALS @ PIKEVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000141      ","SMYRNA READY MIX @ WILDER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000142      ","ALLSTATE READY MIX @ LAGRANGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000143      ","WELLS GROUP @ LOVELY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000144      ","CENTRAL KENTUCKY MIXED CONCRETE @ RICHMOND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000145      ","ADVANCE READY MIX #1-WATER ST @ LOUISVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000146      ","ADVANCE READY MIX #3-ELEMENT AVE @ LOUISVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000147      ","SRM CONCRETE @ PRINCETON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000148      ","IMI @ COLUMBIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000149      ","IMI @ RUSSELL SPRINGS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000150      ","IMI @ SOMERSET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000151      ","SRM CONCRETE @ MURRAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000152      ","SMYRNA READY MIX @ BARDSTOWN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000153      ","SMYRNA READY MIX @ SHELBYVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000154      ","ADVANCE READY MIX @ BUCKNER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000155      ","ADVANCE READY MIX # 5 @ LOUISVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000156      ","ADVANCE READY MIX # 6 @ JEFFERSONVILLE, IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000157      ","ADVANCE READY MIX @ CAMPBELLSBURG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000158      ","IMI @ GEORGETOWN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000159      ","TRIPLE CROWN CONCRETE @ LEXINGTON/BLUESKY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000160      ","TRIPLE CROWN CONCRETE @ RICHMOND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000161      ","TRIPLE CROWN CONCRETE @ MONTICELLO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000162      ","WELLS GROUP @ MOREHEAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000163      ","WELLS GROUP @ WURTLAND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000164      ","KOTTER READY MIX @ PADUCAH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000165      ","AMERICAN CONCRETE @ HOPKINSVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000166      ","OWENSBORO CONRETE PLANT #2 @ OWENSBORO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000167      ","WELLS GROUP @ FRENCHBURG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000168      ","TRIPLE CROWN CONCRETE @ WINCHESTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000169      ","CJ READY MIX @ EAST BERNSTADT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000170      ","HARLAN COUNTY CONCRETE @ HARLAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000171      ","IMI \"FORMERLY TRANSIT\" @ OWENSBORO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000172      ","MEUTH CONCRETE @ MARION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000173      ","FORD CONCRETE @ BARDWELL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000174      ","MUETH CONCRETE SERVICES @ EVANSVILLE IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000175      ","BOWLING GREEN CONCRETE @ ROCKFIELD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000176      ","HAZ-CON CORP @ HAZARD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000177      ","TOW PATH READY MIX @ LUCASVILLE OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000179      ","SOUTHEAST KENTUCKY MIXED CONCRETE @ GRAY HAWK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000180      ","SOUTHEAST KENTUCKY MIXED CONCRETE @ MANCHESTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000181      ","TRI COUNTY READY MIX @ CORBIN (MOVED- DO NOT USE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000182      ","TUCKER READY MIX @ SOMERSET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000183      ","IMI @ GHENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000184      ","SUPERIOR READY MIX @ SOMERSET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000185      ","IMI (500) @ HARRODSBURG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000186      ","SPURLINO @ VERONA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000187      ","COLUMBIA READY MIX @ COLUMBIA KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000188      ","HARPER COMPANY @ SPEARS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000189      ","SPURLINO @ KELLOGG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000190      ","SPURLINO @ HARRISON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000191      ","IMI @ LIBERTY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000192      ","QUALITY READY MIX @ SHEPHERDSVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000193      ","IMI @ FRANKFORT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000194      ","IMI @ MADISON, IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000195      ","CENTRAL READY MIX @ NICHOLASVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000196      ","CENTRAL READY MIX @ GEORGETOWN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000197      ","SMYRNA READY MIX @ DRY RIDGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000198      ","SMITH CONCRETE @ BELPRE, OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000199      ","BOONE READY MIX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000200      ","SMYRNA READY MIX @ JEFFERSONVILLE IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000201      ","SMYRNA READY MIX @ BROOKS "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000202      ","HARROD CONCRETE (FORBES RD.) @ LEXINGTON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000203      ","AMERICAN MEUTH CONCRETE @ HOPKINSVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000204      ","TAYLOR READY MIX @ ASHLAND KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000206      ","WRIGHTWAY READY MIX @ PIKEVILLE KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000207      ","IMI @ LONDON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000208      ","IMI @ NEW ALBANY, IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000209      ","SRM CONCRETE @ BARDWELL "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000211      ","KOTTER READY MIX @ CALVERT CITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000212      ","BOOTH READY MIX @ GLASGOW  KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000213      ","BOOTH READY MIX @ MUNFORDVILLE KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000214      ","KENWAY CONCRETE @ FRANKLIN KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000215      ","ERNST CONCRETE @ SELLERSBURG IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000216      ","CENTRAL READY MIX @ CAMP DENNISON OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000217      ","IMI @ ROCKPORT IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000218      ","AMERICAN READY MIX @ LOUISVILLE KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000219      ","ADVANCE READY MIX @ CARROLLTON KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000220      ","IMI @ ST BETHLEHEM TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000221      ","READYMIX USA @ NEW TAZEWELL TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000222      ","MOUNTAIN CONSTRUCTION CONC @ MIDDLESBORO "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000223      ","HALL CONTRACTING @ SHEPERDSVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000224      ","MEUTH CONCRETE @ CADIZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000225      ","IMI @ LEXINGTON 1 PLANT 868"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000226      ","IMI @ LEXINGTON 2 PLANT 869"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000227      ","SMYRNA READY MIX @ TAYLORSVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000228      ","TWIN K CONCETE @ ONEIDA, TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000229      ","HILLTOP BASIC RESOURCES @ MINEOLA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000230      ","HOMETOWN CONCRETE @ FLORENCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000231      ","IMI @ HEBRON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000232      ","SOUTHERN CONCRETE @ MURRAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000233      ","LITTLE MIAMI MATERIALS @ CINCINNATI, OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000234      ","SOUTHERN CONCRETE @ PADUCAH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000235      ","SOUTHERN CONCRETE @ GRAND RIVERS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP000237","YOUNG CONCRETE @ MADISONVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010000      ","SRM CONCRETE @ PADUCAH *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010001      ","IMI @ OWENSBORO *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010002      ","FAULKNER CONCRETE \"PORTABLE\" *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010003      ","ALLIED READY MIX #4 @ LOUISVILLE *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010004      ","ALLIED READY MIX #6 @ LOUISVILLE *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010005      ","ALLIED READY MIX #7 @ CRESTWOOD *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010006      ","ALLIED READY MIX #8 @ SHEPHERDSVILLE *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010007      ","ERNST CONCRETE @ HEBRON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010008      ","ERNST CONCRETE #2 HAUNZ LN @ CRESTWOOD *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010009      ","IMI # 1 @ CLARKSVILLE, IN "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010010      ","IMI SELINDA @ LOUISVILLE "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010011      ","ERNST CONCRETE @ CIN, OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010012      ","MORAINE MATERIALS @ DEVON *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010013      ","MORAINE MATERIALS * "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010014      ","HILLTOP BASIC RESOURCES @ CINCINNATI *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010015      ","SMYRNA READY MIX @ FLORENCE *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010016      ","IMI OUTER LOOP LOUISVILLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010017      ","GOHMANN CONCRETE #2 @ ELIZABETHTOWN *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010018      ","ADVANCE READY MIX #2-CLAY ST @ LOUISVILLE *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010020      ","HINKLE CONTRACTING @ ALEXANDRIA *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010021      ","HARPER COMPANY (BA-18) @ PETERSBURG KY *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010022      ","HARPER COMPANY (BA-07) @ PETERSBURG KY *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010023      ","HARPER COMPANY (BA-02) @ SHELBYVILLE KY *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010024      ","IMI @ SPRINGFIELD \"PORTABLE\" *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010025      ","HARPER COMPANY(BA-17) @ HIGHLAND HEIGHTS KY* "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010026      ","HARPER COMPANY(BA-03) @ HENDERSON KY*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010027      ","SRM CONCRETE\"PORTABLE\"@PADUCHA KY*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010028      ","HARPER COMPANY(BA-03) @ FRANKFORT KY*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010030      ","IMI OLDHAM COUNTY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010031      ","SRM CONCRETE @ GRAND RIVERS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010032      ","HARPER CO @ CVG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010033      ","HALL CO @ CROFTON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010034      ","IMI @ E'TOWN TEMP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010035      ","E & B PAVING @ LEBANON JUNCTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP010036","HARPER CO (BR-04) @ CVG LOOMIS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP?????","Contractor And Location Not In Drop-Down List"]