{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Header","Project Items","Details","Dist_Dispute_Resolution_RawData","Dist_Dispute_Resolution_Summary","Calculations","Workbook Edits","discipline","Template XXXXXXXXX","Drop_Downs_and_Tables","t_smpl","t_cont_smpl","t_rmks_dtl","t_smpl_tst","t_smpl_tstr","t_tst_rslt_hdr","t_tst_rslt_dtl"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":4,"defined_names":71,"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":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[[15,3,15,20],[5,11,5,12],[6,11,6,12],[12,3,12,5],[11,11,11,13],[12,11,12,13],[4,19,4,20],[3,19,3,20],[11,3,11,5],[9,3,9,5],[6,3,6,5],[7,3,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,null,null,null,null,"Discipline","STRIPING"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version","v1.1"]
["Striping Material",null,null,null,null,null,null,null,null,null,"Material Code  ","33000"]
["Producer/Supplier Code",null,null,"Ennis",null,null,null,null,null,null,"Sample Date  "]
["Material Unit"]
[]
["Contract",null,null,"102910"]
[]
["Sample ID",null,null,null,null,null,null,null,null,null,"KYTC Authorizer (SM User ID)  "]
["District",null,null,{"$f":"LEFT(D12,2)","v":""},null,null,null,null,null,null,"Replacement Spreadsheet Name  "]
[]
[]
["Remarks"]
[]
[]
[]
[null,null,null,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,null,null,null,"KYTC Entries"]
[null,null,null,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_smpl2","t_cont_smpl3","N/A"]
["prj_nbr","ln_itm_nbr","repr_qty","Not Stored on the SM database"]

{"sheet":"Details","index":2,"n_rows":116,"n_cols":19,"rows_kept":116,"cut":false,"hidden":false,"merged":[[43,13,43,15],[44,13,45,15],[43,7,43,9],[13,7,13,9],[14,7,14,9],[11,7,11,9],[12,7,12,9],[16,10,16,12],[13,10,13,12],[44,7,45,9],[16,13,16,15],[11,10,11,12],[11,13,11,15],[12,13,12,15],[13,13,13,15],[12,10,12,12],[14,13,14,15],[14,10,14,12],[15,7,15,9],[16,7,16,9],[15,10,15,12],[15,13,15,15],[43,10,43,12],[44,10,45,12],[15,1,15,3],[16,1,16,3],[6,4,6,6],[7,4,7,6],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[11,1,11,3],[12,1,12,3],[14,4,14,6],[15,4,15,6],[16,4,16,6],[9,7,9,9],[10,7,10,9],[12,4,12,6],[13,4,13,6],[5,16,5,17],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[6,10,6,12],[7,10,7,12],[8,10,8,12],[9,10,9,12],[10,10,10,12],[10,13,10,15],[6,13,6,15],[7,13,7,15],[8,13,8,15],[9,13,9,15],[46,13,46,15],[0,0,0,18],[4,1,4,3],[4,4,4,6],[4,7,4,9],[4,10,4,12],[43,1,43,3],[43,4,43,6],[4,13,4,15],[4,16,4,17],[43,16,43,18],[22,16,22,17],[29,16,29,17],[46,16,46,18],[1,0,1,18],[44,1,45,3],[44,4,45,6],[44,16,45,18],[46,4,46,6],[13,1,13,3],[14,1,14,3],[6,7,6,9],[7,7,7,9],[8,7,8,9],[88,1,88,3],[88,4,88,6],[94,4,94,6],[94,7,94,9],[94,10,94,12],[91,1,91,3],[46,7,46,9],[46,10,46,12],[47,1,47,3],[47,4,47,6],[46,1,46,3],[47,7,47,9],[47,10,47,12],[47,13,47,15],[91,7,91,9],[91,10,91,12],[88,7,88,9],[88,10,88,12],[104,16,104,18],[94,13,94,15],[57,16,57,18],[103,16,103,18],[63,16,63,18],[56,16,56,18],[88,13,88,15],[77,16,77,18],[47,16,47,18],[58,16,60,18],[99,1,100,3],[99,4,100,6],[99,7,100,9],[99,10,100,12],[99,13,100,15],[91,4,91,6],[97,1,97,3],[97,4,97,6],[97,7,97,9],[97,10,97,12],[97,13,97,15],[91,13,91,15],[94,1,94,3]]}
["STRIPING REFLECTIVITY TEST"]
[{"$f":"VLOOKUP(Header!L6,Drop_Downs_and_Tables!A13:B18,2,FALSE)","v":"YELLOW PAINT"}]
[null,null,null,null,"DATE PAINTED:",null,null,null,"FIRST DATE TO TEST:",{"$f":"IF(F3=\"\",\"\",IF(OR(Header!L6=\"33100\",Header!L6=\"33110\"),F3+150,F3+30))","v":""},null,null,"LAST DATE TO TEST:",{"$f":"IF(F3=\"\",\"\",IF(OR(Header!L6=\"33100\",Header!L6=\"33110\"),F3+210,F3+60))","v":""}]
[]
["TEST SITE:","SEGMENT #1",null,null,"SEGMENT #2",null,null,"SEGMENT #3",null,null,"SEGMENT #4",null,null,"SEGMENT #5",null,null,"REFLECTIVITY",null,"QA "]
["ZONE:","#1","#2","#3","#1","#2","#3","#1","#2","#3","#1","#2","#3","#1","#2","#3","REQUIREMENTS",null," TEST"]
["Paint Mnf.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINIMUM:",{"$f":"IF(OR(Header!L6=\"33010\",Header!L6=\"33040\",Header!L6=\"33110\"),300,225)","v":225},"20% OF"]
["Paint Lot #"]
["Bead Mnf.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAY"]
["Bead Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QA MEAN:",{"$f":"IF(S24=\"\",\"\",SUM(S24:S43)/S49)","v":""}]
["Bead Lot #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QA Technician:"]
["CREW/TRUCK ID:"]
["QC Technician ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHK STRT DT:"]
["CHK STRT DT:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calibration Date:"]
["Calibration Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verification Date:"]
["Verification Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEGMENT #:"]
["QA Witness",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZONE #:"]
["COUNTY:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY:",{"$f":"IF(AND(S16=1,S17=1),B18,IF(AND(S16=2,S17=1),E18,IF(AND(S16=3,S17=1),H18,IF(AND(S16=4,S17=1),K18,IF(AND(S16=5,S17=1),N18,\"\")))))","v":""}]
["ROUTE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROUTE:",{"$f":"IF(AND(S16=1,S17=1),B19,IF(AND(S16=2,S17=1),E19,IF(AND(S16=3,S17=1),H19,IF(AND(S16=4,S17=1),K19,IF(AND(S16=5,S17=1),N19,\"\")))))","v":""}]
["SEGMENT MP:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEGMENT MP:",{"$f":"IF(AND(S16=1,S17=1),B20,IF(AND(S16=2,S17=1),E20,IF(AND(S16=3,S17=1),H20,IF(AND(S16=4,S17=1),K20,IF(AND(S16=5,S17=1),N20,\"\")))))","v":""}]
["ZONE MP:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZONE MP:",{"$f":"IF(AND(S16=1,S17=1),B21,IF(AND(S16=2,S17=1),E21,IF(AND(S16=3,S17=1),H21,IF(AND(S16=4,S17=1),K21,IF(AND(S16=5,S17=1),N21,\"\")))))","v":""}]
["LOCATION:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCATION:",{"$f":"IF(AND(S16=1,S17=1),B22,IF(AND(S16=2,S17=1),E22,IF(AND(S16=3,S17=1),H22,IF(AND(S16=4,S17=1),K22,IF(AND(S16=5,S17=1),N22,\"\")))))","v":""}]
["READING NO:","READING","READING","READING","READING","READING","READING","READING","READING","READING","READING","READING","READING","READING","READING","READING","LOCATION KEY:",null,"READING"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EL=EDGELINE"]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CL=CENTERLINE"]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WBL=WESTBND LANE"]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EBL=EASTBND LANE"]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SBL=SOUTHBND LANE"]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NBL=NORHTBND LANE"]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROAD MILES STRIPED"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROUTE","MILES"]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[null,"Remarks - Segment #1:",null,null,"Remarks - Segment #2:",null,null,"Remarks - Segment #3:",null,null,"Remarks - Segment #4:",null,null,"Remarks - Segment #5:",null,null,"Remarks - QA:"]
[]
[]
[null,"Sample Status - Segment #1:",null,null,"Sample Status - Segment #2:",null,null,"Sample Status - Segment #3:",null,null,"Sample Status - Segment #4:",null,null,"Sample Status - Segment #5:",null,null,"Sample Status - QA:"]
[]
[null,{"$f":"IF(B24=\"\",\"\",COUNTIF(B24:B43,\">0\"))","v":""},{"$f":"IF(B24=\"\",\"\",COUNTIF(B24:B43,CONCATENATE(\">=\",$R$7)))","v":""},{"$f":"IF(B24=\"\",\"\",C49/B49)","v":""},{"$f":"IF(E24=\"\",\"\",COUNTIF(E24:E43,\">0\"))","v":""},{"$f":"IF(E24=\"\",\"\",COUNTIF(E24:E43,CONCATENATE(\">=\",$R$7)))","v":""},{"$f":"IF(E24=\"\",\"\",F49/E49)","v":""},{"$f":"IF(H24=\"\",\"\",COUNTIF(H24:H43,\">0\"))","v":""},{"$f":"IF(H24=\"\",\"\",COUNTIF(H24:H43,CONCATENATE(\">=\",$R$7)))","v":""},{"$f":"IF(H24=\"\",\"\",I49/H49)","v":""},{"$f":"IF(K24=\"\",\"\",COUNTIF(K24:K43,\">0\"))","v":""},{"$f":"IF(K24=\"\",\"\",COUNTIF(K24:K43,CONCATENATE(\">=\",$R$7)))","v":""},{"$f":"IF(K24=\"\",\"\",L49/K49)","v":""},{"$f":"IF(N24=\"\",\"\",COUNTIF(N24:N43,\">0\"))","v":""},{"$f":"IF(N24=\"\",\"\",COUNTIF(N24:N43,CONCATENATE(\">=\",$R$7)))","v":""},{"$f":"IF(N24=\"\",\"\",O49/N49)","v":""},null,null,{"$f":"COUNTIF(S24:S43,\">0\")","v":0}]
[null,null,null,{"$f":"IF(AND(B52=$N$66,D49>=70%),0,IF(AND(B52=$N$66,D49<70%),1,IF(AND(B49=20,D49<70%),1,0)))","v":0},null,null,{"$f":"IF(AND(E52=$N$67,G49>=70%),0,IF(AND(E52=$N$67,G49<70%),1,IF(AND(E49=20,G49<70%),1,0)))","v":0},null,null,{"$f":"IF(AND(H52=$N$68,J49>=70%),0,IF(AND(H52=$N$68,J49<70%),1,IF(AND(H49=20,J49<70%),1,0)))","v":0},null,null,{"$f":"IF(AND(K52=$N$69,M49>=70%),0,IF(AND(K52=$N$69,M49<70%),1,IF(AND(K49=20,M49<70%),1,0)))","v":0},null,null,{"$f":"IF(AND(N52=$N$70,P49>=70%),0,IF(AND(N52=$N$70,P49<70%),1,IF(AND(N49=20,P49<70%),1,0)))","v":0},null,null,{"$f":"(SUM(B49,E49,H49,K49,N49)*0.2)","v":0}]
[null,{"$f":"IF(B24=\"\",\"\",COUNTIF(B24:D43,\">0\"))","v":""},{"$f":"IF(B24=\"\",\"\",COUNTIF(B24:D43,CONCATENATE(\">=\",R7)))","v":""},{"$f":"IF(B24=\"\",\"\",C51/B51)","v":""},{"$f":"IF(E24=\"\",\"\",COUNTIF(E24:G43,\">0\"))","v":""},{"$f":"IF(E24=\"\",\"\",COUNTIF(E24:G43,CONCATENATE(\">=\",R7)))","v":""},{"$f":"IF(E24=\"\",\"\",F51/E51)","v":""},{"$f":"IF(H24=\"\",\"\",COUNTIF(H24:J43,\">0\"))","v":""},{"$f":"IF(H24=\"\",\"\",COUNTIF(H24:J43,CONCATENATE(\">=\",R7)))","v":""},{"$f":"IF(H24=\"\",\"\",I51/H51)","v":""},{"$f":"IF(K24=\"\",\"\",COUNTIF(K24:M43,\">0\"))","v":""},{"$f":"IF(K24=\"\",\"\",COUNTIF(K24:M43,CONCATENATE(\">=\",R7)))","v":""},{"$f":"IF(K24=\"\",\"\",L51/K51)","v":""},{"$f":"IF(N24=\"\",\"\",COUNTIF(N24:P43,\">0\"))","v":""},{"$f":"IF(N24=\"\",\"\",COUNTIF(N24:P43,CONCATENATE(\">=\",R7)))","v":""},{"$f":"IF(N24=\"\",\"\",O51/N51)","v":""}]
[null,{"$f":"IF(B24=\"\",\"\",IF(D73=1,\"SEGMENT FAILS\",IF($B$78>=1,N66,IF(M66=1,\"Additional QC Readings Required\",IF(AND(E81>=1,B24=\"\"),\"Additional QC Readings Required\",IF(AND(E81>=1,B24>0,B51<20),\"Additional QC Readings Required\",N66))))))","v":""},null,null,{"$f":"IF(D74=1,\"SEGMENT FAILS\",IF($B$78>=1,N67,IF(M67=1,\"Additional QC Readings Required\",IF(AND(E81>=3,E24=\"\"),\"Additional QC Readings Required\",IF(AND(E81>=3,E51<20),\"Additional QC Readings Required\",N67)))))","v":"Additional QC Readings Required"},null,null,{"$f":"IF(D75=1,\"SEGMENT FAILS\",IF($B$78>=1,N68,IF(M68=1,\"Additional QC Readings Required\",IF(AND(E81>=3,H24=\"\"),\"Additional QC Readings Required\",IF(AND(E81>=3,H51<20),\"Additional QC Readings Required\",N68)))))","v":"Additional QC Readings Required"},null,null,{"$f":"IF(D76=1,\"SEGMENT FAILS\",IF($B$78>=1,N69,IF(M69=1,\"Additional QC Readings Required\",IF(AND(E81=5,K24=\"\"),\"Additional QC Readings Required\",IF(AND(E81=5,K51<20),\"Additional QC Readings Required\",N69)))))","v":""},null,null,{"$f":"IF(D77=1,\"SEGMENT FAILS\",IF($B$78>=1,N70,IF(M70=1,\"Additional QC Readings Required\",IF(AND(E81=5,N24=\"\"),\"Additional QC Readings Required\",IF(AND(E81=5,N51<20),\"Additional QC Readings Required\",IF(AND(N24>0,N51<20),\"Additional QC Readings Required\",N70))))))","v":""},null,null,{"$f":"IF(B49=\"\",\"\",IF(S49>=S50,\"\",\"Additional QA Readings Required\"))","v":""}]
[]
[null,null,"SEGMENT LENGTH:",{"$f":"SUM($R32:$R43)/IF(SUM($R32:$R43)<10,1,IF(AND(SUM($R32:$R43)>=10,SUM($R32:$R43)<30),3,5))","v":3.3333333333333335},null,null,"TOTAL READINGS:",{"$f":"IF(B24=\"\",\"\",COUNTIF(B24:P43,\">0\"))","v":""},null,"PASS:",{"$f":"IF(B24=\"\",\"\",COUNTIF(B24:P43,CONCATENATE(\">=\",R7)))","v":""},null,null,null,null,null,"Segments Tested",null,{"$f":"K80","v":0}]
[null,null,"RANDOM INSPECTION #:",1.1340626844541284,null,null,"PERCENT PASSING:",{"$f":"IF(B24=\"\",\"\",K54/H54)","v":""},null,"FAIL:",{"$f":"IF(B24=\"\",\"\",COUNTIF(B24:P43,CONCATENATE(\"<\",R7)))","v":""},null,null,null,null,null,"Segments Failed",null,{"$f":"SUM(M65:M70)","v":0}]
[null,null,null,null,null,null,"TOTAL PAY:",{"$f":"IF(H55>69%,100%,Q63)","v":1},null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(B65=5, S55>=3),AND(B65<5, S55=1)),\"SECTION FAILS\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC/QA DISPUTE RESOLUTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q79=\"NO\",\"\",IF(COUNTIF(B100:P101,\"Dispute Resolution Recommended\")<>0,\"RECOMMENDED\",IF(COUNTIF(B100:P101,\"No Dispute -- QC-QA Must Resolve >10% Discrepancy\")>0,\"NO DISPUTE - RESOLVE >10% DISCREPANCY BETWEEN QC & QA RESULTS\",\"UNNECESSARY\")))","v":""}]
[]
[]
[{"$f":"SUM(A63:B63)","v":0},{"$f":"ISBLANK(B24)","v":true},{"$f":"IF(B62,0,1)","v":0},{"$f":"SUM(D63:E63)","v":0},{"$f":"ISBLANK(E24)","v":true},{"$f":"IF(E62,0,1)","v":0},{"$f":"SUM(G63:H63)","v":0},{"$f":"ISBLANK(H24)","v":true},{"$f":"IF(H62,0,1)","v":0},{"$f":"SUM(J63:K63)","v":0},{"$f":"ISBLANK(K24)","v":true},{"$f":"IF(K62,0,1)","v":0},{"$f":"SUM(M63:N63)","v":0},{"$f":"ISBLANK(N24)","v":true},{"$f":"IF(N62,0,1)","v":0}]
[{"$f":"IF(B51=60,1,0)","v":0},{"$f":"IF(D51<80%,1,0)","v":0},{"$f":"IF(A62=2,1,0)","v":0},{"$f":"IF(E51=60,1,0)","v":0},{"$f":"IF(G51<80%,1,0)","v":0},{"$f":"IF(D62=2,1,0)","v":0},{"$f":"IF(H51=60,1,0)","v":0},{"$f":"IF(J51<80%,1,0)","v":0},{"$f":"IF(G62=2,1,0)","v":0},{"$f":"IF(K51=60,1,0)","v":0},{"$f":"IF(M51<80%,1,0)","v":0},{"$f":"IF(J62=2,1,0)","v":0},{"$f":"IF(N51=60,1,0)","v":0},{"$f":"IF(P51<80%,1,0)","v":0},{"$f":"IF(M62=2,1,0)","v":0}]
[]
["Segments",{"$f":"SUM(C62+F62+I62+L62+O62)","v":0},null,"Error ?","% Read Pass","N(D)","Sum(E+F)","# Readings","Sum(G+H)","60 Read <80%","N(J)","Z1<80 & <60R","N(L)","K=1 Seg Fail","Add R/Seg Pass"]
["Failed",{"$f":"SUM(M66:M70)","v":0},"Seg1",{"$f":"ISERROR(C63)","v":false},{"$f":"IF(D66,0,D51)","v":""},{"$f":"N(D66)","v":0},{"$f":"SUM(E66:F66)","v":0},{"$f":"B51","v":""},{"$f":"SUM(G66:H66)","v":0},{"$f":"AND(I66>=60,I66<60.8)","v":false},{"$f":"N(J66)","v":0},{"$f":"OR(C$90<$R$7,D$49<0.8)","v":false},{"$f":"N(L66)","v":0},{"$f":"IF(M66=1,\"SEGMENT FAILS\",\"\")","v":""},{"$f":"IF(B52=\"Additional QC Readings Required\",\"Need More Readings\",\"SEGMENT PASSES\")","v":"SEGMENT PASSES"},null,{"$f":"IF(B51=\"\",0,IF(M66=1,1,IF(AND(B51>0,B51<20),1,IF(AND(B51=60,D49<0.8),0,IF(AND(B51=20,D51>=0.8),0,1)))))","v":0},{"$f":"N(Q66)","v":0},{"$f":"IF(R66=1,\"Need More Readings\",\"SECTION PASSES\")","v":"SECTION PASSES"}]
[null,null,"Seg2",{"$f":"ISERROR(F63)","v":false},{"$f":"IF(D67,0,G51)","v":""},{"$f":"N(D67)","v":0},{"$f":"SUM(E67:F67)","v":0},{"$f":"E51","v":""},{"$f":"SUM(G67:H67)","v":0},{"$f":"AND(I67>=60,I67<60.8)","v":false},{"$f":"N(J67)","v":0},{"$f":"OR(F$90<$R$7,G$49<0.8)","v":false},{"$f":"N(L67)","v":0},{"$f":"IF(M67=1,\"SEGMENT FAILS\",\"\")","v":""},{"$f":"IF(E52=\"Additional QC Readings Required\",\"Need More Readings\",\"SEGMENT PASSES\")","v":"Need More Readings"},null,{"$f":"IF(E51=\"\",0,IF(M67=1,1,IF(AND(E51>0,E51<20),1,IF(AND(E51=60,G49<0.8),0,IF(AND(E51=20,G51>=0.8),0,1)))))","v":0},{"$f":"N(Q67)","v":0},{"$f":"IF(R67=1,\"Need More Readings\",\"SECTION PASSES\")","v":"SECTION PASSES"}]
[null,{"$f":"IF(B63,1,0)","v":0},"Seg3",{"$f":"ISERROR(I63)","v":false},{"$f":"IF(D68,0,J51)","v":""},{"$f":"N(D68)","v":0},{"$f":"SUM(E68:F68)","v":0},{"$f":"H51","v":""},{"$f":"SUM(G68:H68)","v":0},{"$f":"AND(I68>=60,I68<60.8)","v":false},{"$f":"N(J68)","v":0},{"$f":"OR(I$90<$R$7,J$49<0.8)","v":false},{"$f":"N(L68)","v":0},{"$f":"IF(M68=1,\"SEGMENT FAILS\",\"\")","v":""},{"$f":"IF(H52=\"Additional QC Readings Required\",\"Need More Readings\",\"SEGMENT PASSES\")","v":"Need More Readings"},null,{"$f":"IF(H51=\"\",0,IF(M68=1,1,IF(AND(H51>0,H51<20),1,IF(AND(H51=60,J49<0.8),0,IF(AND(H51=20,J51>=0.8),0,1)))))","v":0},{"$f":"N(Q68)","v":0},{"$f":"IF(R68=1,\"Need More Readings\",\"SECTION PASSES\")","v":"SECTION PASSES"}]
[null,null,"Seg4",{"$f":"ISERROR(L63)","v":false},{"$f":"IF(D69,0,M51)","v":""},{"$f":"N(D69)","v":0},{"$f":"SUM(E69:F69)","v":0},{"$f":"K51","v":""},{"$f":"SUM(G69:H69)","v":0},{"$f":"AND(I69>=60,I69<60.8)","v":false},{"$f":"N(J69)","v":0},{"$f":"OR(L$90<$R$7,M$49<0.8)","v":false},{"$f":"N(L69)","v":0},{"$f":"IF(M69=1,\"SEGMENT FAILS\",\"\")","v":""},{"$f":"IF(K52=\"Additional QC Readings Required\",\"Need More Readings\",\"SEGMENT PASSES\")","v":"SEGMENT PASSES"},null,{"$f":"IF(K51=\"\",0,IF(M69=1,1,IF(AND(K51>0,K51<20),1,IF(AND(K51=60,M49<0.8),0,IF(AND(K51=20,M51>=0.8),0,1)))))","v":0},{"$f":"N(Q69)","v":0},{"$f":"IF(R69=1,\"Need More Readings\",\"SECTION PASSES\")","v":"SECTION PASSES"}]
[null,null,"Seg5",{"$f":"ISERROR(O63)","v":false},{"$f":"IF(D70,0,P51)","v":""},{"$f":"N(D70)","v":0},{"$f":"SUM(E70:F70)","v":0},{"$f":"N51","v":""},{"$f":"SUM(G70:H70)","v":0},{"$f":"AND(I70>=60,I70<60.8)","v":false},{"$f":"N(J70)","v":0},{"$f":"OR(O$90<$R$7,P$49<0.8)","v":false},{"$f":"N(L70)","v":0},{"$f":"IF(M70=1,\"SEGMENT FAILS\",\"\")","v":""},{"$f":"IF(N52=\"Additional QC Readings Required\",\"Need More Readings\",\"SEGMENT PASSES\")","v":"SEGMENT PASSES"},null,{"$f":"IF(N51=\"\",0,IF(M70=1,1,IF(AND(N51>0,N51<20),1,IF(AND(N51=60,P49<0.8),0,IF(AND(N51=20,P51>=0.8),0,1)))))","v":0},{"$f":"N(Q70)","v":0},{"$f":"IF(R70=1,\"More Readings Needed\",\"SECTION PASSES\")","v":"SECTION PASSES"}]
[]
[null,null,"FAILING QC VALUES",null,"QC SEGMENT MEAN STATUS = FAIL/PASS/BONUS",null,null,null,"QA SEGMENT",null,"QA STATUS",null,"QC/QA","DISPUTE RESOLUTION",null,null,null,{"$f":"SUM(R66:R70)","v":0},{"$f":"IF(R72>=1,\"ADDITIONAL READINGS REQUIRED\",\"SECTION PASSES\")","v":"SECTION PASSES"}]
[{"$f":"AND(B65=1,B66=1)","v":false},{"$f":"N(A73)","v":0},{"$f":"IF(B$24=\"\",0,COUNTIF(B$24:B$43,CONCATENATE(\"<\",$R$7)))","v":0},{"$f":"IF(C73>=14,1,0)","v":0},"SEG 1",{"$f":"IF($C$90=\"\",\"\",IF($C$90<$R$7,\"FAIL\",\"PASS\"))","v":""},{"$f":"IF(F73=\"PASS\",1,IF(F73=\"BONUS\",2,0))","v":0},null,{"$f":"IF(C93=\"\",0,1)","v":0},null,{"$f":"IF(Q79=\"NO\",\"\",IF($S$10>=$R$9,\"BONUS\",IF(AND($S$10<$R$9,$S$10>=$R$7),\"PASS\",\"FAIL\")))","v":""},{"$f":"IF(K73=\"BONUS\",3,IF(K73=\"PASS\",2,IF(K73=\"FAIL\",1,0)))","v":0},{"$f":"IF(R106=\"NO\",1,0)","v":0},{"$f":"IF(I73=1,SUM(G73,$L$73,$M$73),0)","v":0},{"$f":"IF($M$73=0,\"NOT REQUIRED\",IF(AND($M$73=1,N73=1),\"RECOMMENDED\",IF(AND($M$73=1,N73=2),\"REQUIRED\",IF(AND($M$73=1,N73=3,G73=1,I73=1),\"RECOMMENDED\",IF(AND($M$73=1,N73=3),\"REQUIRED\",IF(AND($M$73=1,N73=4),\"REQUIRED\",IF(AND($M$73=1,N73=5),\"RECOMMENDED\",0)))))))","v":"NOT REQUIRED"},{"$f":"IF(O73=0,0,1)","v":1}]
[{"$f":"AND(B65=3,B66>=1)","v":false},{"$f":"N(A74)","v":0},{"$f":"IF(E$24=\"\",0,COUNTIF(E$24:E$43,CONCATENATE(\"<\",$R$7)))","v":0},{"$f":"IF(C74>=14,1,0)","v":0},"SEG 2",{"$f":"IF($F$90=\"\",\"\",IF($F$90<$R$7,\"FAIL\",\"PASS\"))","v":""},{"$f":"IF(F74=\"PASS\",1,IF(F74=\"BONUS\",2,0))","v":0},null,{"$f":"IF(F93=\"\",0,1)","v":0},null,"# Seg Tested",null,null,{"$f":"IF(I74=1,SUM(G74,$L$73,$M$73),0)","v":0},{"$f":"IF($M$73=0,\"NOT REQUIRED\",IF(AND($M$73=1,N74=1),\"SUGGESTED\",IF(AND($M$73=1,N74=2),\"REQUIRED\",IF(AND($M$73=1,N74=3),\"REQUIRED\",IF(AND($M$73=1,N74=4),\"REQUIRED\",IF(AND($M$73=1,N74=5),\"SUGGESTED\",0))))))","v":"NOT REQUIRED"},{"$f":"IF(O74=0,0,1)","v":1},{"$f":"(R106=\"NO\")","v":false},{"$f":"N(Q74)","v":0}]
[{"$f":"AND(B65=5,B66>=3)","v":false},{"$f":"N(A75)","v":0},{"$f":"IF(H$24=\"\",0,COUNTIF(H$24:H$43,CONCATENATE(\"<\",$R$7)))","v":0},{"$f":"IF(C75>=14,1,0)","v":0},"SEG 3",{"$f":"IF($I$90=\"\",\"\",IF($I$90<$R$7,\"FAIL\",\"PASS\"))","v":""},{"$f":"IF(F75=\"PASS\",1,IF(F75=\"BONUS\",2,0))","v":0},null,{"$f":"IF(I93=\"\",0,1)","v":0},null,{"$f":"IF(AND(B52=\"\",B51=20),1,IF(B51=60,1,0))","v":0},null,null,{"$f":"IF(I75=1,SUM(G75,$L$73,$M$73),0)","v":0},{"$f":"IF($M$73=0,\"NOT REQUIRED\",IF(AND($M$73=1,N75=1),\"SUGGESTED\",IF(AND($M$73=1,N75=2),\"REQUIRED\",IF(AND($M$73=1,N75=3),\"REQUIRED\",IF(AND($M$73=1,N75=4),\"REQUIRED\",IF(AND($M$73=1,N75=5),\"SUGGESTED\",0))))))","v":"NOT REQUIRED"},{"$f":"IF(O75=0,0,1)","v":1},{"$f":"(K73=\"FAIL\")","v":false},{"$f":"N(Q75)","v":0}]
[{"$f":"AND(R74=1,R75=1)","v":false},{"$f":"N(A76)","v":0},{"$f":"IF(K$24=\"\",0,COUNTIF(K$24:K$43,CONCATENATE(\"<\",$R$7)))","v":0},{"$f":"IF(C76>=14,1,0)","v":0},"SEG 4",{"$f":"IF($L$90=\"\",\"\",IF($L$90<$R$7,\"FAIL\",\"PASS\"))","v":""},{"$f":"IF(F76=\"PASS\",1,IF(F76=\"BONUS\",2,0))","v":0},null,{"$f":"IF(L93=\"\",0,1)","v":0},null,{"$f":"IF(AND(E52=\"\",E51=20),1,IF(E51=60,1,0))","v":0},null,null,{"$f":"IF(I76=1,SUM(G76,$L$73,$M$73),0)","v":0},{"$f":"IF($M$73=0,\"NOT REQUIRED\",IF(AND($M$73=1,N76=1),\"SUGGESTED\",IF(AND($M$73=1,N76=2),\"REQUIRED\",IF(AND($M$73=1,N76=3),\"REQUIRED\",IF(AND($M$73=1,N76=4),\"REQUIRED\",IF(AND($M$73=1,N76=5),\"SUGGESTED\",0))))))","v":"NOT REQUIRED"},{"$f":"IF(O76=0,0,1)","v":1}]
[{"$f":"D78>=1","v":false},{"$f":"N(A77)","v":0},{"$f":"IF(N$24=\"\",0,COUNTIF(N$24:N$43,CONCATENATE(\"<\",$R$7)))","v":0},{"$f":"IF(C77>=14,1,0)","v":0},"SEG 5",{"$f":"IF($O$90=\"\",\"\",IF($O$90<$R$7,\"FAIL\",\"PASS\"))","v":""},{"$f":"IF(F77=\"PASS\",1,IF(F77=\"BONUS\",2,0))","v":0},null,{"$f":"IF(O93=\"\",0,1)","v":0},null,{"$f":"IF(AND(H52=\"\",H51=20),1,IF(H51=60,1,0))","v":0},null,null,{"$f":"IF(I77=1,SUM(G77,$L$73,$M$73),0)","v":0},{"$f":"IF($M$73=0,\"NOT REQUIRED\",IF(AND($M$73=1,N77=1),\"SUGGESTED\",IF(AND($M$73=1,N77=2),\"REQUIRED\",IF(AND($M$73=1,N77=3),\"REQUIRED\",IF(AND($M$73=1,N77=4),\"REQUIRED\",IF(AND($M$73=1,N77=5),\"SUGGESTED\",0))))))","v":"NOT REQUIRED"},{"$f":"IF(O77=0,0,1)","v":1}]
[null,{"$f":"SUM(B73:B77)","v":0},null,{"$f":"SUM(D73:D77)","v":0},null,null,null,null,null,null,{"$f":"IF(AND(K52=\"\",K51=20),1,IF(K51=60,1,0))","v":0},null,null,null,null,null,"Minimum QA Readings Obtained"]
[null,null,null,null,"QC SECTION MEAN",null,{"$f":"IF(B24=\"\",0,AVERAGE(B24:P43))","v":0},null,null,null,{"$f":"IF(AND(N52=\"\",N51=20),1,IF(N51=60,1,0))","v":0},null,null,null,"DR Req",null,{"$f":"IF(S49=0, \"NO\",IF(S49>=S50,\"YES\",\"NO\"))","v":"NO"}]
[null,"Miles Striped",{"$f":"SUM(R32:R43)","v":10},null,"QC STATUS",null,{"$f":"IF(G79=0,\"\",IF(Q56=\"ADDITIONAL READINGS REQUIRED\",\"\",IF($G$79<$R$7,\"FAILS\",IF(AND($G$79>=$R$7,$G$79<$R$9),\"PASSES\",IF($G$79>=$R$9,\"MEETS BONUS\",\"\")))))","v":""},null,null,null,{"$f":"SUM(K75:K79)","v":0},null,null,null,{"$f":"+IF(#REF!=\"REQUIRED\",1,0)","v":{"$error":"#REF!"}}]
[null,"Segment Length",{"$f":"IF(C80>=30,C80/5,IF(AND(C80<30,C80>=10),C80/3,IF(C80<10,C80,\"\")))","v":3.3333333333333335},"Rqd # Seg",{"$f":"IF(AND(C80>0,C80<10),1,IF(AND(C80>=10,C80<30),3,IF(C80>=30,5,0)))","v":3}]
[]
[]
[]
[]
[]
[]
[]
[null,"QC MEAN SEGMENT 1",null,null,"QC MEAN SEGMENT 2",null,null,"QC MEAN SEGMENT 3",null,null,"QC MEAN SEGMENT 4",null,null,"QC MEAN SEGMENT 5",null,null,null,null,"Contractor"]
[null,null,{"$f":"IF(B24=\"\",\"\",SUM(B24:D43)/COUNTIF(B24:D43,\">0\"))","v":""},{"$f":"IF(C90=\"\",\"\",IF(AND(C90>=$R$7,(COUNTIF(B24:B43,CONCATENATE(\">=\",$R$7))/COUNT(B24:B43))>=0.8),\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(E24=\"\",\"\",SUM(E24:G43)/COUNTIF(E24:G43,\">0\"))","v":""},{"$f":"IF(F90=\"\",\"\",IF(AND(F90>=$R$7,(COUNTIF(E24:E43,CONCATENATE(\">=\",$R$7))/COUNT(E24:E43))>=0.8),\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(H24=\"\",\"\",SUM(H24:J43)/COUNTIF(H24:J43,\">0\"))","v":""},{"$f":"IF(I90=\"\",\"\",IF(AND(I90>=$R$7,(COUNTIF(H24:H43,CONCATENATE(\">=\",$R$7))/COUNT(H24:H43))>=0.8),\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(K24=\"\",\"\",SUM(K24:M43)/COUNTIF(K24:M43,\">0\"))","v":""},{"$f":"IF(L90=\"\",\"\",IF(AND(L90>=$R$7,(COUNTIF(K24:K43,CONCATENATE(\">=\",$R$7))/COUNT(K24:K43))>=0.8),\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(N24=\"\",\"\",SUM(N24:P43)/COUNTIF(N24:P43,\">0\"))","v":""},{"$f":"IF(O90=\"\",\"\",IF(AND(O90>=$R$7,(COUNTIF(N24:N43,CONCATENATE(\">=\",$R$7))/COUNT(N24:N43))>=0.8),\"PASS\",\"FAIL\"))","v":""},null,null,"KYTC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read-Only"]
[null,"QA MEAN SEGMENT 1",null,null,"QA MEAN SEGMENT 2",null,null,"QA MEAN SEGMENT 3",null,null,"QA MEAN SEGMENT 4",null,null,"QA MEAN SEGMENT 5"]
[null,null,{"$f":"IF($S$16=1,$S$10,\"\")","v":""},{"$f":"IF(C93=\"\",\"\",IF(AND((COUNTIF($S$24:$S$43,CONCATENATE(\">=\",$R$7))/COUNT($S$24:$S$43))>=0.8,(C93>=$R$7)),\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF($S$16=2,$S$10,\"\")","v":""},{"$f":"IF(F93=\"\",\"\",IF(AND((COUNTIF($S$24:$S$43,CONCATENATE(\">=\",$R$7))/COUNT($S$24:$S$43))>=0.8,(F93>=$R$7)),\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF($S$16=3,$S$10,\"\")","v":""},{"$f":"IF(I93=\"\",\"\",IF(AND((COUNTIF($S$24:$S$43,CONCATENATE(\">=\",$R$7))/COUNT($S$24:$S$43))>=0.8,(I93>=$R$7)),\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF($S$16=4,$S$10,\"\")","v":""},{"$f":"IF(L93=\"\",\"\",IF(AND((COUNTIF($S$24:$S$43,CONCATENATE(\">=\",$R$7))/COUNT($S$24:$S$43))>=0.8,(L93>=$R$7)),\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF($S$16=5,$S$10,\"\")","v":""},{"$f":"IF(O93=\"\",\"\",IF(AND((COUNTIF($S$24:$S$43,CONCATENATE(\">=\",$R$7))/COUNT($S$24:$S$43))>=0.8,(O93>=$R$7)),\"PASS\",\"FAIL\"))","v":""}]
[]
[null,"QC QA DIFFERENCE",null,null,"QC QA DIFFERENCE",null,null,"QC QA DIFFERENCE",null,null,"QC QA DIFFERENCE",null,null,"QC QA DIFFERENCE"]
[null,null,{"$f":"IF(C93=\"\",\"\",ABS(SUM(C93-C90))/C93)","v":""},null,null,{"$f":"IF(F93=\"\",\"\",ABS(SUM(F93-F90))/F93)","v":""},null,null,{"$f":"IF(I93=\"\",\"\",ABS(SUM(I93-I90))/I93)","v":""},null,null,{"$f":"IF(L93=\"\",\"\",ABS(SUM(L93-L90))/L93)","v":""},null,null,{"$f":"IF(O93=\"\",\"\",ABS(SUM(O93-O90))/O93)","v":""}]
[]
[null,"SEGMENT 1 RESULTS",null,null,"SEGMENT 2 RESULTS",null,null,"SEGMENT 3 RESULTS",null,null,"SEGMENT 4 RESULTS",null,null,"SEGMENT 5 RESULTS"]
[null,null,{"$f":"IF(D90=\"\",\"\",IF(AND(D90=\"PASS\",OR(D93=\"PASS\",D93=\"\")),\"SEGMENT PASSES\",\"SEGMENT FAILS\"))","v":""},null,null,{"$f":"IF(G90=\"\",\"\",IF(AND(G90=\"PASS\",OR(G93=\"PASS\",G93=\"\")),\"SEGMENT PASSES\",\"SEGMENT FAILS\"))","v":""},null,null,{"$f":"IF(J90=\"\",\"\",IF(AND(J90=\"PASS\",OR(J93=\"PASS\",J93=\"\")),\"SEGMENT PASSES\",\"SEGMENT FAILS\"))","v":""},null,null,{"$f":"IF(M90=\"\",\"\",IF(AND(M90=\"PASS\",OR(M93=\"PASS\",M93=\"\")),\"SEGMENT PASSES\",\"SEGMENT FAILS\"))","v":""},null,null,{"$f":"IF(P90=\"\",\"\",IF(AND(P90=\"PASS\",OR(P93=\"PASS\",P93=\"\")),\"SEGMENT PASSES\",\"SEGMENT FAILS\"))","v":""}]
[null,{"$f":"IF(OR(C99=\"\",C96=\"\"),\"\",IF(C96>0.1,IF(D90=D93,\"No Dispute -- QC-QA Must Resolve >10% Discrepancy\",\"Dispute Resolution Recommended\"),\"No Dispute Exists\"))","v":""},null,null,{"$f":"IF(OR(F99=\"\",F96=\"\"),\"\",IF(F96>0.1,IF(G90=G93,\"No Dispute -- QC-QA Must Resolve >10% Discrepancy\",\"Dispute Resolution Recommended\"),\"No Dispute Exists\"))","v":""},null,null,{"$f":"IF(OR(I99=\"\",I96=\"\"),\"\",IF(I96>0.1,IF(J90=J93,\"No Dispute -- QC-QA Must Resolve >10% Discrepancy\",\"Dispute Resolution Recommended\"),\"No Dispute Exists\"))","v":""},null,null,{"$f":"IF(OR(L99=\"\",L96=\"\"),\"\",IF(L96>0.1,IF(M90=M93,\"No Dispute -- QC-QA Must Resolve >10% Discrepancy\",\"Dispute Resolution Recommended\"),\"No Dispute Exists\"))","v":""},null,null,{"$f":"IF(OR(O99=\"\",O96=\"\"),\"\",IF(O96>0.1,IF(P90=P93,\"No Dispute -- QC-QA Must Resolve >10% Discrepancy\",\"Dispute Resolution Recommended\"),\"No Dispute Exists\"))","v":""}]
[]
[]
[]
[null,null,{"$f":"D90=D93","v":true},{"$f":"N(C104)","v":1},null,{"$f":"G90=G93","v":true},{"$f":"N(F104)","v":1},null,{"$f":"J90=J93","v":true},{"$f":"N(I104)","v":1},null,{"$f":"M90=M93","v":true},{"$f":"N(L104)","v":1},null,{"$f":"P90=P93","v":true},{"$f":"N(O104)","v":1},"QC SEGMENT MEAN WITHIN"]
[null,null,{"$f":"B96<=10%","v":true},{"$f":"N(C105)","v":1},null,{"$f":"E96<=10%","v":true},{"$f":"N(F105)","v":1},null,{"$f":"H96<=10%","v":true},{"$f":"N(I105)","v":1},null,{"$f":"K96<=10%","v":true},{"$f":"N(L105)","v":1},null,{"$f":"N96<=10%","v":true},{"$f":"N(O105)","v":1},"10% OF QA MEAN"]
[null,null,{"$f":"B96=\"\"","v":true},{"$f":"N(C106)","v":1},null,{"$f":"E96=\"\"","v":true},{"$f":"N(F106)","v":1},null,{"$f":"H96=\"\"","v":true},{"$f":"N(I106)","v":1},null,{"$f":"K96=\"\"","v":true},{"$f":"N(L106)","v":1},null,{"$f":"N96=\"\"","v":true},{"$f":"N(O106)","v":1},null,{"$f":"IF(S10=\"\",\"\",IF(B96<=10%,\"YES\",IF(E96<=10%,\"YES\",IF(H96<=10%,\"YES\",IF(K96<=10%,\"YES\",IF(N96<=10%,\"YES\",\"NO\"))))))","v":""}]
[null,null,{"$f":"D93=\"FAIL\"","v":false},{"$f":"N(C107)","v":0},null,{"$f":"G93=\"FAIL\"","v":false},{"$f":"N(F107)","v":0},null,{"$f":"J93=\"FAIL\"","v":false},{"$f":"N(I107)","v":0},null,{"$f":"M93=\"FAIL\"","v":false},{"$f":"N(L107)","v":0},null,{"$f":"P93=\"FAIL\"","v":false},{"$f":"N(O107)","v":0}]
[null,null,{"$f":"IF(B96=\"\",\"\",IF(AND(D104=1,D105=1),\"NOT REQUIRED\",IF(OR(D107=1,D105=0),\"RECOMMENDED\",IF(AND(D104=0,D105=1),\"NOT REQUIRED\",IF(AND(D104=0,D105=0),\"REQUIRED\",\"\")))))","v":""},null,null,{"$f":"IF(E96=\"\",\"\",IF(AND(G104=1,G105=1),\"NOT REQUIRED\",IF(OR(G107=1,G105=0),\"RECOMMENDED\",IF(AND(G104=0,G105=1),\"NOT REQUIRED\",IF(AND(G104=0,G105=0),\"REQUIRED\",\"\")))))","v":""},null,null,{"$f":"IF(H96=\"\",\"\",IF(AND(J104=1,J105=1),\"NOT REQUIRED\",IF(OR(J107=1,J105=0),\"RECOMMENDED\",IF(AND(J104=0,J105=1),\"NOT REQUIRED\",IF(AND(J104=0,J105=0),\"REQUIRED\",\"\")))))","v":""},null,null,{"$f":"IF(K96=\"\",\"\",IF(AND(M104=1,M105=1),\"NOT REQUIRED\",IF(OR(M107=1,M105=0),\"RECOMMENDED\",IF(AND(M104=0,M105=1),\"NOT REQUIRED\",IF(AND(M104=0,M105=0),\"REQUIRED\",\"\")))))","v":""},null,null,{"$f":"IF(N96=\"\",\"\",IF(AND(P104=1,P105=1),\"NOT REQUIRED\",IF(OR(P107=1,P105=0),\"RECOMMENDED\",IF(AND(P104=0,P105=1),\"NOT REQUIRED\",IF(AND(P104=0,P105=0),\"REQUIRED\",\"\")))))","v":""}]
[]
[]
[null,"EL"]
[null,"CL"]
[null,"WBL"]
[null,"EBL"]
[null,"SBL"]
[null,"NBL"]

{"sheet":"Dist_Dispute_Resolution_RawData","index":3,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":true,"merged":[[1,0,3,0],[25,0,27,0],[49,0,51,0],[26,11,26,12],[49,1,49,6],[50,1,50,2],[50,3,50,4],[50,5,50,6],[2,9,2,10],[1,7,1,12],[2,11,2,12],[25,1,25,6],[25,7,25,12],[26,1,26,2],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[1,1,1,6],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8]]}
[]
["Measurement #","Segment 1",null,null,null,null,null,"Segment 2"]
[null,"Zone  1",null,"Zone 2",null,"Zone 3",null,"Zone  1",null,"Zone 2",null,"Zone 3"]
[null,"QC","QA","QC","QA","QC","QA","QC","QA","QC","QA","QC","QA"]
[1]
[2]
[3]
[4]
[{"$f":"A8+1","v":5}]
[{"$f":"A9+1","v":6}]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[]
["Measurement #","Segment 3",null,null,null,null,null,"Segment 4"]
[null,"Zone  1",null,"Zone 2",null,"Zone 3",null,"Zone  1",null,"Zone 2",null,"Zone 3"]
[null,"QC","QA","QC","QA","QC","QA","QC","QA","QC","QA","QC","QA"]
[1]
[2]
[3]
[4]
[{"$f":"A32+1","v":5}]
[{"$f":"A33+1","v":6}]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[]
["Measurement #","Segment 5"]
[null,"Zone  1",null,"Zone 2",null,"Zone 3"]
[null,"QC","QA","QC","QA","QC","QA"]
[1]
[2]
[3]
[4]
[{"$f":"A56+1","v":5}]
[{"$f":"A57+1","v":6}]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Dist_Dispute_Resolution_Summary","index":4,"n_rows":62,"n_cols":19,"rows_kept":62,"cut":false,"hidden":true,"merged":[[4,1,4,3],[4,4,4,6],[4,7,4,9],[0,0,0,15],[1,0,1,15],[2,10,2,11],[2,4,2,5],[4,10,4,12],[30,10,30,12],[32,10,32,12],[4,13,4,15],[30,4,30,6],[31,4,31,6],[30,7,30,9],[31,7,31,9],[31,10,31,12],[30,13,30,15],[31,13,31,15],[32,1,32,3],[32,4,32,6],[32,13,32,15],[30,1,30,3],[31,1,31,3],[40,3,40,6],[32,7,32,9],[47,0,47,1],[34,0,34,1],[35,0,35,1],[39,0,39,1],[38,3,38,5],[39,3,39,6]]}
["DISTRICT-LEVEL DISPUTE RESOLUTION REFLECTIVITY"]
[{"$f":"VLOOKUP(Header!L6,Drop_Downs_and_Tables!A13:B18,2,FALSE)","v":"YELLOW PAINT"}]
[null,null,null,"DATE PAINTED:",{"$f":"Details!F3","v":"00:00:00"},null,null,null,null,"FIRST DATE TO TEST:",{"$f":"IF(E3=\"\",\"\",IF(OR(Header!L6=\"33100\",Header!L6=\"33110\"),E3+210,E3+60))","v":60}]
[]
["TEST SITE:","SEGMENT #1",null,null,"SEGMENT #2",null,null,"SEGMENT #3",null,null,"SEGMENT #4",null,null,"SEGMENT #5"]
["ZONE:","#1","#2","#3","#1","#2","#3","#1","#2","#3","#1","#2","#3","#1","#2","#3"]
["Paint Mnf."]
["Paint Lot #"]
["Bead Mnf."]
["Bead Type"]
["Bead Lot #"]
["CREW/TRUCK ID:"]
["QC Technician "]
["CHK STRT DT:"]
["Calibration Date"]
["Verification Date"]
["QA Witness"]
["COUNTY:"]
["ROUTE:"]
["SEGMENT MP:"]
["ZONE MP:"]
["LOCATION:"]
["Average Reflectivity Readings"]
["Contractor",{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!B5:B24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!B5:B24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!D5:D24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!D5:D24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!F5:F24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!F5:F24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!H5:H24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!H5:H24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!J5:J24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!J5:J24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!L5:L24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!L5:L24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!B29:B48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!C29:C48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!D29:D48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!D29:D48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!F29:F48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!G29:G48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!H29:H48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!H29:H48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!J29:J48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!J29:J48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!L29:L48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!L29:L48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!B53:B72)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!B53:B72))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!D53:D72)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!D53:D72))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!F53:F72)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!F53:F72))","v":""}]
["District",{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!C5:C24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!C5:C24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!E5:E24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!E5:E24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!G5:G24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!G5:G24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!I5:I24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!I5:I24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!K5:K24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!K5:K24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!M5:M24)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!M5:M24))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!C29:C48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!D29:D48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!E29:E48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!F29:F48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!G29:G48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!G29:G48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!I29:I48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!I29:I48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!K29:K48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!K29:K48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!M29:M48)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!M29:M48))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!C53:C72)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!C53:C72))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!E53:E72)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!E53:E72))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!G53:G72)=0,\"\",AVERAGE(Dist_Dispute_Resolution_RawData!G53:G72))","v":""}]
["Percent Difference",{"$f":"IF(OR(B24=\"\",B25=\"\"),\"\",(B25-B24)/B25)","v":""},{"$f":"IF(OR(C24=\"\",C25=\"\"),\"\",(C25-C24)/C25)","v":""},"","","","","","","","","","","","",""]
["# Readings Under Specification"]
["Contractor",{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!B5:B24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!B5:B24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!D5:D24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!D5:D24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!F5:F24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!F5:F24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!H5:H24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!H5:H24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!J5:J24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!J5:J24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!L5:L24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!L5:L24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!B29:B48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!B29:B48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!D29:D48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!D29:D48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!F29:F48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!F29:F48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!H29:H48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!H29:H48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!J29:J48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!J29:J48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!L29:L48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!L29:L48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!B53:B72)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!B53:B72,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!D53:D72)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!D53:D72,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!F53:F72)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!F53:F72,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!I53:I72)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!I53:I72,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!K53:K72)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!K53:K72,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!M53:M72)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!M53:M72,CONCATENATE(\">=\",$B$37)))","v":""}]
["District",{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!C5:C24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!C5:C24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!E5:E24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!E5:E24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!G5:G24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!G5:G24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!I5:I24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!I5:I24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!K5:K24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!K5:K24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!M5:M24)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!M5:M24,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!C29:C48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!C29:C48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!E29:E48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!E29:E48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!G29:G48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!G29:G48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!I29:I48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!I29:I48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!K29:K48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!K29:K48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!N29:N48)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!M29:M48,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!C53:C72)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!C53:C72,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!E53:E72)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!E53:E72,CONCATENATE(\">=\",$B$37)))","v":""},{"$f":"IF(SUM(Dist_Dispute_Resolution_RawData!G53:G72)=0,\"\",COUNTIF(Dist_Dispute_Resolution_RawData!G53:G72,CONCATENATE(\">=\",$B$37)))","v":""}]
["District's Readings Prevail          (% Difference > 10%)",{"$f":"IF(B26=\"\",\"\",IF(ABS(B26)>0.1,\"Yes\",\"No\"))","v":""},"","","","","","","","","","","","","",""]
["Contractor's Segment Grade",{"$f":"IF(COUNTIF(B24:D25,\"\")>1,\"\",IF(AND(SUM(B24:D24)>2*$B$37,SUM(B28:D28)<48),\"PASS\",\"FAIL\"))","v":""},null,null,{"$f":"IF(COUNTIF(E24:G25,\"\")>1,\"\",IF(AND(SUM(E24:G24)>2*$B$37,SUM(E28:G28)<48),\"PASS\",\"FAIL\"))","v":""},null,null,{"$f":"IF(COUNTIF(H24:J25,\"\")>1,\"\",IF(AND(SUM(H24:J24)>2*$B$37,SUM(H28:J28)<48),\"PASS\",\"FAIL\"))","v":""},null,null,{"$f":"IF(COUNTIF(K24:M25,\"\")>1,\"\",IF(AND(SUM(K24:M24)>2*$B$37,SUM(K28:M28)<48),\"PASS\",\"FAIL\"))","v":""},null,null,{"$f":"IF(COUNTIF(N24:P25,\"\")>1,\"\",IF(AND(SUM(N24:P24)>2*$B$37,SUM(N28:P28)<48),\"PASS\",\"FAIL\"))","v":""}]
["District's Segment Grade",{"$f":"IF(COUNTIF(B25:D26,\"\")>1,\"\",IF(AND(SUM(B25:D25)>2*$B$37,SUM(B29:D29)<48),\"PASS\",\"FAIL\"))","v":""},null,null,{"$f":"IF(COUNTIF(E25:G26,\"\")>1,\"\",IF(AND(SUM(E25:G25)>2*$B$37,SUM(E29:G29)<48),\"PASS\",\"FAIL\"))","v":""},null,null,{"$f":"IF(COUNTIF(H25:J26,\"\")>1,\"\",IF(AND(SUM(H25:J25)>2*$B$37,SUM(H29:J29)<48),\"PASS\",\"FAIL\"))","v":""},null,null,{"$f":"IF(COUNTIF(K25:M26,\"\")>1,\"\",IF(AND(SUM(K25:M25)>2*$B$37,SUM(K29:M29)<48),\"PASS\",\"FAIL\"))","v":""},null,null,{"$f":"IF(COUNTIF(N25:P26,\"\")>1,\"\",IF(AND(SUM(N25:P25)>2*$B$37,SUM(N29:P29)<48),\"PASS\",\"FAIL\"))","v":""}]
["Segment Finished",{"$f":"IF(AND(B31<>\"\",B32<>\"\"),\"YES\",\"NO\")","v":"NO"},null,null,{"$f":"IF(SUM($B$50:$B$61)<=10,\"\",IF(AND(E31<>\"\",E32<>\"\"),\"YES\",\"NO\"))","v":""},null,null,{"$f":"IF(SUM($B$50:$B$61)<=10,\"\",IF(AND(H31<>\"\",H32<>\"\"),\"YES\",\"NO\"))","v":""},null,null,{"$f":"IF(SUM($B$50:$B$61)<30,\"\",IF(AND(K31<>\"\",K32<>\"\"),\"YES\",\"NO\"))","v":""},null,null,{"$f":"IF(SUM($B$50:$B$61)<30,\"\",IF(AND(N31<>\"\",N32<>\"\"),\"YES\",\"NO\"))","v":""}]
[]
["REFLECTIVITY",null,null,"Segments Tested",null,null,{"$f":"COUNTIF((B33:N33),\"YES\")","v":0}]
["REQUIREMENTS",null,null,"QC Segments Failed",null,null,{"$f":"IF(G35=\"\",\"\",COUNTIF(B31:P31,\"FAIL\"))","v":0},null,null,null,null,"SEGMENT LENGTH:",{"$f":"IF(B62<=10,B62,IF(AND(B62>10,B62<30),B62/3,B62/5))","v":10}]
["MINIMUM:",{"$f":"IF(OR(Header!L6=\"33010\",Header!L6=\"33040\",Header!L6=\"33110\"),300,225)","v":225},null,"QA Segments Failed",null,null,{"$f":"IF(G36=\"\",\"\",COUNTIF(B32:P32,\"FAIL\"))","v":0},null,null,null,null,"RANDOM INSPECTION #:",7.4123268959890112,null,null,"Contractor"]
[null,null,null,{"$f":"IF(OR(AND(G37>1,G35=3),AND(G37>2,G35=5),AND(G37>0,G35=1)),\"SECTION FAILS\",\"SECTION PASSES\")","v":"SECTION PASSES"},null,null,null,null,null,null,null,null,null,null,null,"KYTC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read-Only"]
["LOCATION KEY:",null,null,"QC/QA DISPUTE RESOLUTION"]
["GCL=GENERIC LINE",null,null,{"$f":"IF(G37>G36,\"REQUIRED\",\"NOT NECESSARY\")","v":"NOT NECESSARY"}]
["EL=EDGELINE"]
["CL=CENTERLINE"]
["WBL=WESTBND LANE"]
["EBL=EASTBND LANE"]
["SBL=SOUTHBND LANE"]
["NBL=NORHTBND LANE"]
["ROAD MILES STRIPED"]
["ROUTE","MILES"]
[{"$f":"Details!Q32","v":0},{"$f":"Details!R32","v":10}]
[{"$f":"Details!Q33","v":0},{"$f":"Details!R33","v":0}]
[{"$f":"Details!Q34","v":0},{"$f":"Details!R34","v":0}]
[{"$f":"Details!Q35","v":0},{"$f":"Details!R35","v":0}]
[{"$f":"Details!Q36","v":0},{"$f":"Details!R36","v":0}]
[{"$f":"Details!Q37","v":0},{"$f":"Details!R37","v":0}]
[{"$f":"Details!Q38","v":0},{"$f":"Details!R38","v":0}]
[{"$f":"Details!Q39","v":0},{"$f":"Details!R39","v":0}]
[{"$f":"Details!Q40","v":0},{"$f":"Details!R40","v":0}]
[{"$f":"Details!Q41","v":0},{"$f":"Details!R41","v":0}]
[{"$f":"Details!Q42","v":0},{"$f":"Details!R42","v":0}]
[{"$f":"Details!Q43","v":0},{"$f":"Details!R43","v":0}]
["Total Section Miles",{"$f":"SUM(B50:B61)","v":10}]

{"sheet":"Calculations","index":5,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Details Random Number"]
[{"$f":"RAND()*Details!D54","v":2.2773291476513111}]
[]
["District_Dispute_Resolution Random Number"]
[{"$f":"RAND()*Dist_Dispute_Resolution_Summary!M36","v":4.8964517790626383}]

{"sheet":"Workbook Edits","index":6,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Tracks Pre-Production Workbook Changes"]
["Date","Initials","Description"]
["2007-01-15","BGP","Working on initial version of spreadsheet."]
["2010-02-12","NJS","Updating everything per Derrick and Brandi's needs."]
["2010-03-01","NJS","New District-level dispute resolution functionality has been added."]
["2010-03-02","NJS"]

{"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!T4","v":"STRIPING"},{"$f":"Header!T5","v":"v1.1"},"Y",{"$f":"Header!D13","v":""},{"$f":"Header!D12","v":0}]

{"sheet":"Template XXXXXXXXX","index":8,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Template:","????????",null,null,"Cell","type","label","length","English Unit",null,"SM Template Mapping"]
[null,null,null,null,"A9","Label","READING NO:","n/a","None"]
["TEST SITE:","SEGMENT #1",null,null,"B3","Alphanumeric","TEST SITE:",10,"None"]
["ZONE:","#1",null,null,"B4","Alphanumeric","ZONE:",2,"None"]
["DATE CHKD:","2005-05-23",null,null,"B5","Numeric","DATE CHKD:",8,"None"]
["COUNTY:","Warren",null,null,"B6","Alphanumeric","COUNTY:",20,"in"]
["ROUTE:",234,null,null,"B7","Alphanumeric","ROUTE:",15,"None"]
["SEGMENT MP:",8.1999999999999993,null,null,"B8","Numeric","SEGMENT MP:",3.1,"None"]
["ZONE MP:",0.4,null,null,"B9","Numeric","ZONE MP:",2.1,"%"]
["LOCATION:","NBEL",null,null,"B10","Alphanumeric","LOCATION:",3,"%"]
["READING NO:","READING",null,null,"B11","Label","READING","n/a","None"]
[1,450,null,null,"B12","Numeric",1,3,"None"]
[2,449,null,null,"B13","Numeric",2,3,"None"]
[3,461,null,null,"B14","Numeric",3,3,"None"]
[4,467,null,null,"B15","Numeric",4,3,"None"]
[5,470,null,null,"B16","Numeric",5,3,"None"]
[6,457,null,null,"B17","Numeric",6,3,"None"]
[7,452,null,null,"B18","Numeric",7,3,"None"]
[8,448,null,null,"B19","Numeric",8,3,"None"]
[9,439,null,null,"B20","Numeric",9,3,"None"]
[10,435,null,null,"B21","Numeric",10,3,"None"]
[11,439,null,null,"B22","Numeric",11,3,"None"]
[12,437,null,null,"B23","Numeric",12,3,"None"]
[13,442,null,null,"B24","Numeric",13,3,"None"]
[14,465,null,null,"B25","Numeric",14,3,"None"]
[15,439,null,null,"B26","Numeric",15,3,"None"]
[16,442,null,null,"B27","Numeric",16,3,"None"]
[17,446,null,null,"B28","Numeric",17,3,"None"]
[18,427,null,null,"B29","Numeric",18,3,"None"]
[19,401,null,null,"B30","Numeric",19,3,"None"]
[20,440,null,null,"B31","Numeric",20,3,"None"]
["Paint Mnf."]
["Paint Lot #"]
["Bead Mnf."]
["Bead Type"]
["Bead Lot #"]

{"sheet":"Drop_Downs_and_Tables","index":9,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
["COMP","COMPLETE"]
["FAIL","FAILED"]
["FRFP","FAILED AND REMOVED FROM PROJECT"]
[]
[]
[]
["33010","WHITE PAINT",300]
["33040","WHITE DURABLE WATERBORNE PAINT",300]
["33000","YELLOW PAINT",225]
["33030","YELLOW DURABLE WATERBORNE PAINT",225]
["33110","WHITE THERMOPLASTIC",300]
["33100","YELLOW THERMOPLASTIC",225]

{"sheet":"t_smpl","index":10,"n_rows":50,"n_cols":55,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["Special Processing",null,null,null,"d",null,null,null,null,null,"d",null,"d",null,null,"c",null,"c",null,null,null,null,null,null,null,null,null,"c","c","c","c","c",null,"c","c","c","c",null,"c",null,"c","c",null,"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.sm_user_ind='Y'\n\nQUESTION: SHOULD WE CHECK GROUP SECURITY FOR \"AUTHORIZATION\"?",null,"Existing on t_matl_user \nAND t_matl_user.sm_user_ind='Y'",null,"Existing on t_cd_tbl_dtl (cd_id)\nAND t_cd_tbl_dtl.tbl_id='CNTRLTYP'","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,null,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'",null,"Existing on t_cd_tbl_dtl (cd_id)\nAND t_cd_tbl_dtl.tbl_id='SMPLSTAT'","Existing on t_matl_user \n",null,null,null,null,null,"Existing on t_cd_tbl_dtl (cd_id)\nAND t_cd_tbl_dtl.tbl_id='UNITS'"]
["Comment","IF No Sample ID, Ignore Row.","Embed code table in spreadsheet","SM User ID from Header","Current system date","SM User ID from Header",null,null,"Derived from first two characters of Sample ID",null,"Current system date",null,"Current system date",null,"Only used for QC/QA Samples.  Otherwise, initialized 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 currently)",null,null,null,"Embed code table in spreadsheet","Sampler ID","Only used for QC/QA Samples.  Otherwise, initialized to \" \" (i.e., space)",null,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)",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)",null,"Not Used\nInitialized to \" \" (i.e., space)","Not Used for Start Up\nInitialized to \" \" (i.e., space)\nUsed for remaining.","Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to \" \" (i.e., space)","Set Only for QC Samples\nInitialized to \"N\" otherwise","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"]
["SU1",null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ",{"$f":"IF(W8=\"QC\",\"Y\",\"N\")","v":"N"}," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
["SU26",null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," "," "," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
["EB1",null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
["EB8",null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null," "," ",null," ",null,"PCC",null,null,null,null," ",null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
["QA1",null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null,null," ",null," ",null,"PCC",null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null,null," ",null," ",null,"PCC",null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null,null," ",null," ",null,"PCC",null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null,null," ",null," ",null,"PCC",null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null,null," ",null," ",null,"PCC",null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null,null," ",null," ",null,"PCC",null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null,null," ",null," ",null,"PCC",null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null,null," ",null," ",null,"PCC",null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]
["QA9",null,"TR",null,null,null,null,"LNBR",null,null,null,null,null,null,null," ",null," ",null,"PCC",null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null," ",null," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]

{"sheet":"t_cont_smpl","index":11,"n_rows":50,"n_cols":11,"rows_kept":50,"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,{"$f":"43-COUNTBLANK(t_smpl!B8:B50)","v":0},"NUMBER OF QC SAMPLES"]
["Comment","IF No Sample ID, Ignore Row.",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"]
["SU1",null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
["SU26",null,null,"N/A","N/A","N/A"]
["EB1",null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
["EB8",null,null,"N/A","N/A","N/A"]
["QA1",null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
[null,null,null,"N/A","N/A","N/A"]
["QA9",null,null,"N/A","N/A","N/A"]

{"sheet":"t_rmks_dtl","index":12,"n_rows":50,"n_cols":7,"rows_kept":50,"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","IF No Sample ID, Ignore Row.",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"]
["SU1",null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
["SU26",null,"GEN",1]
["EB1",null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
["EB8",null,"GEN",1]
["QA1",null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
[null,null,"GEN",1]
["QA9",null,"GEN",1]

{"sheet":"t_smpl_tst","index":13,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Special Processing",null,null,null,"c","c",null,null,null,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"]
["Comment","IF No Sample ID, Ignore Row.",null,null,"Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to 0",null,null,null,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"]
["SU1",null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
["SU26",null,"COCONCPLAS",1," ",0]
["EB1",null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
["EB8",null,"COCONCCOMP",1," ",0]
["QA1  PL",null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
[null,null,"COCONCPLAS",1," ",0]
["QA9  PL",null,"COCONCPLAS",1," ",0]
["QA1  CCS",null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
[null,null,"COCONCCOMP",1," ",0]
["QA9  CCS",null,"COCONCCOMP",1," ",0]

{"sheet":"t_smpl_tstr","index":14,"n_rows":164,"n_cols":7,"rows_kept":164,"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","A DUPLICATE OF KEY (highlighted in yellow) IS NOT AN ERROR IN THIS CASE. (Just removed duplicates prior to writing to DB)\n\nIF \"blank\", THEN skip to next record\n\n","Existing on t_tst_fee_schd",null,"Existing on t_matl_user \nAND  t_matl_user.tstr_ind='Y\"\nAND  active test qualification of \"GRADING TECHNICIAN LEVEL I\" \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 = \"GDNS\"\n         AND      qualfn_lev_t = \"GRT1\"\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","IF No Sample ID, Ignore Row.",null,null,"The Tester must have active “GRADING TECHNICIAN LEVEL I” Tester qualification for a Material Category of “GEOTECH DENSITY”.",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"]
["SU1 Slump",null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
["SU26 Slump",null,"COCONCPLAS",1]
["SU1 Air Content",{"$f":"B8","v":0},"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
["SU26 Air Content",0,"COCONCPLAS",1]
["SU1 Air Temp",0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,{"$f":"B40","v":0},"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
["SU26 Air Temp",0,"COCONCPLAS",1]
["SU1 Conc Temp",0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,{"$f":"B72","v":0},"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
["SU26 Conc Temp",0,"COCONCPLAS",1]
["QA1 Slump",null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
[null,null,"COCONCPLAS",1]
["QA9 Slump",null,"COCONCPLAS",1]
["QA1 Air Content",{"$f":"B112","v":0},"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
["QA9 Air Content",0,"COCONCPLAS",1]
["QA1 Air Temp",0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
["QA9 Air Temp",0,"COCONCPLAS",1]
["QA1 Conc Temp",0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
[null,0,"COCONCPLAS",1]
["QA9 Conc Temp",0,"COCONCPLAS",1]
["EB1",null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
["EB8",null,"COCONCCOMP",1]
["QA1",null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
[null,null,"COCONCCOMP",1]
["QA9",null,"COCONCCOMP",1]

{"sheet":"t_tst_rslt_hdr","index":15,"n_rows":59,"n_cols":8,"rows_kept":59,"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","IF No Sample ID, Ignore Row.",null,null,"Not Used\nInitialized to \" \" (i.e., space)","Test Specification Date (Not used in this discipline)\nInitialized to null (0 on SM DB)","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"]
["SU1",null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
["SU26",null,"COCONCPLAS",1," "]
["EB1",null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
["EB8",null,"COCONCCOMP",1," "]
["QA1 Plastic",null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
[null,null,"COCONCPLAS",1," "]
["QA9 Plastic",null,"COCONCPLAS",1," "]
["QA1 CCS",null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
[null,null,"COCONCCOMP",1," "]
["QA9 CCS",null,"COCONCCOMP",1," "]

{"sheet":"t_tst_rslt_dtl","index":16,"n_rows":1289,"n_cols":9,"rows_kept":1289,"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   AND\nCHOOSE CASE tst_fld_sn\n      CASE \"SequenceNumber\"\n            <Edit Goes Here>\n      ENDCASE","Type & Size   AND\nCHOOSE CASE tst_fld_sn\n      CASE \"SequenceNumber\"\n            <Edit Goes Here>\n      ENDCASE"]
["Comment","IF No Sample ID, Ignore Row.",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"]
["SU1 - Comment  (NOT CURRENTLY USED)",null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
["SU26 - Comment  (NOT CURRENTLY USED)",null,"COCONCPLAS",1,1,null,0]
["SU1 - GenericString1  (NOT CURRENTLY USED)",{"$f":"B8","v":0},"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
["SU26 - GenericString1  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,2,null,0]
["SU1 - GenericString2  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
["SU26 - GenericString2  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,3,null,0]
["SU1 - GenericNum1  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,{"$f":"B72","v":0},"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
["SU26 - GenericNum1  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,4," "]
["SU1 - GenericNum2  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
["SU26 - GenericNum2  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,5," "]
["SU1 - GenericNum3  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,{"$f":"B136","v":0},"COCONCPLAS",1,6," "]
["SU26 - GenericNum3  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,6," "]
["SU1 - GenericNum4  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
["SU26 - GenericNum4  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,7," "]
["SU1 - Taken At Quantity ",0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
["SU26 - Taken At Quantity ",0,"COCONCPLAS",1,10," "]
["SU1 - Taken At Quantity Units",0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,{"$f":"B200","v":0},"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
["SU26 - Taken At Quantity Units",0,"COCONCPLAS",1,27,null,0]
["SU1 - LABEL: Slump",0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
["SU26 - LABEL: Slump",0,"COCONCPLAS",1,11," ",0]
["SU1 - Slump (in)",0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,{"$f":"B264","v":0},"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
["SU26 - Slump (in)",0,"COCONCPLAS",1,12," "]
["SU1 - Slump Technician ",0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
["SU26 - Slump Technician ",0,"COCONCPLAS",1,13,null,0]
["SU1 - LABEL: Air Content (Pressure Method)",0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
["SU26 - LABEL: Air Content (Pressure Method)",0,"COCONCPLAS",1,14," ",0]
["SU1 - Air Content as Measured (%)",0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,{"$f":"B328","v":0},"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
["SU26 - Air Content as Measured (%)",0,"COCONCPLAS",1,15," "]
["SU1 - Coarse Aggregate Correction Factor",0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
["SU26 - Coarse Aggregate Correction Factor",0,"COCONCPLAS",1,16," "]
["SU1 - Actual Air Content (%)",0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,{"$f":"B392","v":0},"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
["SU26 - Actual Air Content (%)",0,"COCONCPLAS",1,17," "]
["SU1 - Air Content Technician ",0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
["SU26 - Air Content Technician ",0,"COCONCPLAS",1,18,null,0]
["SU1 - LABEL: Air Temperature",0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
["SU26 - LABEL: Air Temperature",0,"COCONCPLAS",1,19," ",0]
["SU1 - Air Temp (F)",0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,{"$f":"B456","v":0},"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
["SU26 - Air Temp (F)",0,"COCONCPLAS",1,20," "]
["SU1 - Air Temp Technician ",0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
["SU26 - Air Temp Technician ",0,"COCONCPLAS",1,21,null,0]
["SU1 - LABEL: Concrete Temperature",0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,{"$f":"B520","v":0},"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
["SU26 - LABEL: Concrete Temperature",0,"COCONCPLAS",1,22," ",0]
["SU1 - 'Concrete Temp (F)",0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
["SU26 - 'Concrete Temp (F)",0,"COCONCPLAS",1,23," "]
["SU1 - Concrete Temp Technician ",0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
["SU26 - Concrete Temp Technician ",0,"COCONCPLAS",1,24,null,0]
["SU1 - Plastic Test KYTC Witness",0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,{"$f":"B584","v":0},"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
["SU26 - Plastic Test KYTC Witness",0,"COCONCPLAS",1,25,null,0]
["EB1 - Comment  (NOT CURRENTLY USED)",null,"COCONCCOMP",1,1,null,0]
[null,null,"COCONCCOMP",1,1,null,0]
[null,null,"COCONCCOMP",1,1,null,0]
[null,null,"COCONCCOMP",1,1,null,0]
[null,null,"COCONCCOMP",1,1,null,0]
[null,null,"COCONCCOMP",1,1,null,0]
[null,null,"COCONCCOMP",1,1,null,0]
["EB8 - Comment  (NOT CURRENTLY USED)",null,"COCONCCOMP",1,1,null,0]
["EB1 - GenericString1  (NOT CURRENTLY USED)",{"$f":"B632","v":0},"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
["EB8 - GenericString1  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,2,null,0]
["EB1 - GenericString2  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
["EB8 - GenericString2  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,3,null,0]
["EB1 - GenericNum1  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
["EB8 - GenericNum1  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,4," "]
["EB1 - GenericNum2  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
["EB8 - GenericNum2  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,5," "]
["EB1 - GenericNum3  (NOT CURRENTLY USED)",{"$f":"B664","v":0},"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
["EB8 - GenericNum3  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,6," "]
["EB1 - GenericNum4  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
["EB8 - GenericNum4  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,7," "]
["EB1 - Taken At Quantity",0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
["EB8 - Taken At Quantity",0,"COCONCCOMP",1,10," "]
["EB1 - Taken At Quantity Units",0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
["EB8 - Taken At Quantity Units",0,"COCONCCOMP",1,11,null,0]
["EB1 - LABEL: Concrete Cylinder Strength",{"$f":"B696","v":0},"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
["EB8- LABEL: Concrete Cylinder Strength",0,"COCONCCOMP",1,12," ",0]
["EB1 - Breaking Technician",0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
["EB8 - Breaking Technician",0,"COCONCCOMP",1,13,null,0]
["EB1 - Cylinder Size",0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
["EB8 - Cylinder Size",0,"COCONCCOMP",1,14,null,0]
["EB1 - Cylinder Set ID",0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
["EB8 - Cylinder Set ID",0,"COCONCCOMP",1,15,null,0]
["EB1 - Age",{"$f":"B728","v":0},"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
["EB8 - Age",0,"COCONCCOMP",1,16," "]
["EB1 - Age Unit",0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
["EB4 - Age Unit",0,"COCONCCOMP",1,17,null,0]
["EB1 - Gross Load Cylinder 1 (lbs)",0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
["EB8 - Gross Load Cylinder 1 (lbs)",0,"COCONCCOMP",1,21," "]
["EB1 - Cylinder 1 Fracture Type",0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
["EB8 - Cylinder 1 Fracture Type",0,"COCONCCOMP",1,28,null,0]
["EB1 - Cylinder 1 Compressive Strength (psi)",{"$f":"B760","v":0},"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
["EB8 - Cylinder 1 Compressive Strength (psi)",0,"COCONCCOMP",1,24," "]
["EB1 - Gross Load Cylinder 2 (lbs)",0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
["EB8 - Gross Load Cylinder 2 (lbs)",0,"COCONCCOMP",1,22," "]
["EB1 - Cylinder 2 Fracture Type",0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
["EB8 - Cylinder 2 Fracture Type",0,"COCONCCOMP",1,29,null,0]
["EB1 - Cylinder 2 Compressive Strength (psi)",0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
["EB8 - Cylinder 2 Compressive Strength (psi)",0,"COCONCCOMP",1,25," "]
["EB1 - Gross Load Cylinder 3 (lbs)",{"$f":"B792","v":0},"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
["EB8 - Gross Load Cylinder 3 (lbs)",0,"COCONCCOMP",1,23," "]
["EB1 - Cylinder 3 Fracture Type",0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
["EB8 - Cylinder 3 Fracture Type",0,"COCONCCOMP",1,30,null,0]
["EB1 - Cylinder 3 Compressive Strength (psi)",0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
["EB8 - Cylinder 3 Compressive Strength (psi)",0,"COCONCCOMP",1,26," "]
["EB1 -Average Compressive Strength (psi)",0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
["EB8 - Average Compressive Strength (psi)",0,"COCONCCOMP",1,27," "]
["EB1 - Compressive Test KYTC Witness",{"$f":"B824","v":0},"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
["EB8 - Compressive Test KYTC Witness",0,"COCONCCOMP",1,31,null,0]
["QA1 - Comment  (NOT CURRENTLY USED)",null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
[null,null,"COCONCPLAS",1,1,null,0]
["QA9 - Comment  (NOT CURRENTLY USED)",null,"COCONCPLAS",1,1,null,0]
["QA1 - GenericString1  (NOT CURRENTLY USED)",{"$f":"B840","v":0},"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
[null,0,"COCONCPLAS",1,2,null,0]
["QA9 - GenericString1  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,2,null,0]
["QA1 - GenericString2  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
[null,0,"COCONCPLAS",1,3,null,0]
["QA9 - GenericString2  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,3,null,0]
["QA1 - GenericNum1  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
[null,0,"COCONCPLAS",1,4," "]
["QA5 - GenericNum1  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,4," "]
["QA1 - GenericNum2  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
[null,0,"COCONCPLAS",1,5," "]
["QA9 - GenericNum2  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,5," "]
["QA1 - GenericNum3  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
[null,0,"COCONCPLAS",1,6," "]
["QA9 - GenericNum3  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,6," "]
["QA1 - GenericNum4  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
[null,0,"COCONCPLAS",1,7," "]
["QA5 - GenericNum4  (NOT CURRENTLY USED)",0,"COCONCPLAS",1,7," "]
["QA1 - Taken At Quantity ",0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
[null,0,"COCONCPLAS",1,10," "]
["QA9 - Taken At Quantity ",0,"COCONCPLAS",1,10," "]
["QA1 - Taken At Quantity Units",0,"COCONCPLAS",1,27,null,0]
[null,{"$f":"B904","v":0},"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
[null,0,"COCONCPLAS",1,27,null,0]
["QA9 - Taken At Quantity Units",0,"COCONCPLAS",1,27,null,0]
["QA1 - LABEL: Slump",0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
[null,0,"COCONCPLAS",1,11," ",0]
["QA9 - LABEL: Slump",0,"COCONCPLAS",1,11," ",0]
["QA1 - Slump (in)",0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
[null,0,"COCONCPLAS",1,12," "]
["QA9 - Slump (in)",0,"COCONCPLAS",1,12," "]
["QA1 - Slump Technician ",0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
[null,0,"COCONCPLAS",1,13,null,0]
["QA9 - Slump Technician ",0,"COCONCPLAS",1,13,null,0]
["QA1 - LABEL: Air Content (Pressure Method)",0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
[null,0,"COCONCPLAS",1,14," ",0]
["QA9 - LABEL: Air Content (Pressure Method)",0,"COCONCPLAS",1,14," ",0]
["QA1 - Air Content as MeaQAred (%)",0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
[null,0,"COCONCPLAS",1,15," "]
["QA9 - Air Content as MeaQAred (%)",0,"COCONCPLAS",1,15," "]
["QA1 - Coarse Aggregate Correction Factor",0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
[null,0,"COCONCPLAS",1,16," "]
["QA9 - Coarse Aggregate Correction Factor",0,"COCONCPLAS",1,16," "]
["QA1 - Actual Air Content (%)",0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,{"$f":"B968","v":0},"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
[null,0,"COCONCPLAS",1,17," "]
["QA9 - Actual Air Content (%)",0,"COCONCPLAS",1,17," "]
["QA1 - Air Content Technician ",0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
[null,0,"COCONCPLAS",1,18,null,0]
["QA9 - Air Content Technician ",0,"COCONCPLAS",1,18,null,0]
["QA1 - LABEL: Air Temperature",0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
[null,0,"COCONCPLAS",1,19," ",0]
["QA9 - LABEL: Air Temperature",0,"COCONCPLAS",1,19," ",0]
["QA1 - Air Temp (F)",0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
[null,0,"COCONCPLAS",1,20," "]
["QA9 - Air Temp (F)",0,"COCONCPLAS",1,20," "]
["QA1 - Air Temp Technician ",0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
[null,0,"COCONCPLAS",1,21,null,0]
["QA9 - Air Temp Technician ",0,"COCONCPLAS",1,21,null,0]
["QA1 - LABEL: Concrete Temperature",0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
[null,0,"COCONCPLAS",1,22," ",0]
["QA9 - LABEL: Concrete Temperature",0,"COCONCPLAS",1,22," ",0]
["QA1 - 'Concrete Temp (F)",0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
[null,0,"COCONCPLAS",1,23," "]
["QA9 - 'Concrete Temp (F)",0,"COCONCPLAS",1,23," "]
["QA1 - Concrete Temp Technician ",0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,{"$f":"B1032","v":0},"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
[null,0,"COCONCPLAS",1,24,null,0]
["QA9 - Concrete Temp Technician ",0,"COCONCPLAS",1,24,null,0]
["QA1 - Plastic Test KYTC Witness",0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
[null,0,"COCONCPLAS",1,25,null,0]
["QA9 - Plastic Test KYTC Witness",0,"COCONCPLAS",1,25,null,0]
["QA1 - Comment  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,1,null,0]
[null,0,"COCONCCOMP",1,1,null,0]
[null,0,"COCONCCOMP",1,1,null,0]
[null,0,"COCONCCOMP",1,1,null,0]
[null,0,"COCONCCOMP",1,1,null,0]
[null,0,"COCONCCOMP",1,1,null,0]
[null,0,"COCONCCOMP",1,1,null,0]
[null,0,"COCONCCOMP",1,1,null,0]
["QA9 - Comment  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,1,null,0]
["QA1 - GenericString1  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
[null,0,"COCONCCOMP",1,2,null,0]
["QA9 - GenericString1  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,2,null,0]
["QA1 - GenericString2  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
[null,0,"COCONCCOMP",1,3,null,0]
["QA9 - GenericString2  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,3,null,0]
["QA1 - GenericNum1  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
[null,0,"COCONCCOMP",1,4," "]
["QA9 - GenericNum1  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,4," "]
["QA1 - GenericNum2  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
[null,0,"COCONCCOMP",1,5," "]
["QA9 - GenericNum2  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,5," "]
["QA1 - GenericNum3  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,{"$f":"B1096","v":0},"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
[null,0,"COCONCCOMP",1,6," "]
["QA9 - GenericNum3  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,6," "]
["QA1 - GenericNum4  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
[null,0,"COCONCCOMP",1,7," "]
["QA9 - GenericNum4  (NOT CURRENTLY USED)",0,"COCONCCOMP",1,7," "]
["QA1 - Taken At Quantity",0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
[null,0,"COCONCCOMP",1,10," "]
["QA9 - Taken At Quantity",0,"COCONCCOMP",1,10," "]
["QA1 - Taken At Quantity Units",0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
[null,0,"COCONCCOMP",1,11,null,0]
["QA9 - Taken At Quantity Units",0,"COCONCCOMP",1,11,null,0]
["QA1 - LABEL: Concrete Cylinder Strength",0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
[null,0,"COCONCCOMP",1,12," ",0]
["QA9- LABEL: Concrete Cylinder Strength",0,"COCONCCOMP",1,12," ",0]
["QA1 - Breaking Technician",0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
[null,0,"COCONCCOMP",1,13,null,0]
["QA9 - Breaking Technician",0,"COCONCCOMP",1,13,null,0]
["QA1 - Cylinder Size",0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
[null,0,"COCONCCOMP",1,14,null,0]
["QA9 - Cylinder Size",0,"COCONCCOMP",1,14,null,0]
["QA1 - Cylinder Set ID",0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,{"$f":"B1160","v":0},"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
[null,0,"COCONCCOMP",1,15,null,0]
["QA9 - Cylinder Set ID",0,"COCONCCOMP",1,15,null,0]
["QA1 - Age",0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
[null,0,"COCONCCOMP",1,16," "]
["QA9 - Age",0,"COCONCCOMP",1,16," "]
["QA1 - Age Unit",0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
[null,0,"COCONCCOMP",1,17,null,0]
["QA9 - Age Unit",0,"COCONCCOMP",1,17,null,0]
["QA1 - Gross Load Cylinder 1 (lbs)",0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
[null,0,"COCONCCOMP",1,21," "]
["QA9 - Gross Load Cylinder 1 (lbs)",0,"COCONCCOMP",1,21," "]
["QA1 - Cylinder 1 Fracture Type",0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
[null,0,"COCONCCOMP",1,28,null,0]
["QA9 - Cylinder 1 Fracture Type",0,"COCONCCOMP",1,28,null,0]
["QA1 - Cylinder 1 Compressive Strength (psi)",0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
[null,0,"COCONCCOMP",1,24," "]
["QA9 - Cylinder 1 Compressive Strength (psi)",0,"COCONCCOMP",1,24," "]
["QA1 - Gross Load Cylinder 2 (lbs)",0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
[null,0,"COCONCCOMP",1,22," "]
["QA9 - Gross Load Cylinder 2 (lbs)",0,"COCONCCOMP",1,22," "]
["QA1 - Cylinder 2 Fracture Type",0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
[null,{"$f":"B1224","v":0},"COCONCCOMP",1,29,null,0]
[null,0,"COCONCCOMP",1,29,null,0]
["QA9 - Cylinder 2 Fracture Type",0,"COCONCCOMP",1,29,null,0]
["QA1 - Cylinder 2 Compressive Strength (psi)",0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
[null,0,"COCONCCOMP",1,25," "]
["QA9 - Cylinder 2 Compressive Strength (psi)",0,"COCONCCOMP",1,25," "]
["QA1 - Gross Load Cylinder 3 (lbs)",0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
[null,0,"COCONCCOMP",1,23," "]
["QA9 - Gross Load Cylinder 3 (lbs)",0,"COCONCCOMP",1,23," "]
["QA1 - Cylinder 3 Fracture Type",0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
[null,0,"COCONCCOMP",1,30,null,0]
["QA9 - Cylinder 3 Fracture Type",0,"COCONCCOMP",1,30,null,0]
["QA1 - Cylinder 3 Compressive Strength (psi)",0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
[null,0,"COCONCCOMP",1,26," "]
["QA9 - Cylinder 3 Compressive Strength (psi)",0,"COCONCCOMP",1,26," "]
["QA1 -Average Compressive Strength (psi)",0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
[null,0,"COCONCCOMP",1,27," "]
["QA9 - Average Compressive Strength (psi)",0,"COCONCCOMP",1,27," "]
["QA1 - Compressive Test KYTC Witness",0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
[null,0,"COCONCCOMP",1,31,null,0]
["QA9 - Compressive Test KYTC Witness",0,"COCONCCOMP",1,31,null,0]