{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Header","Details","Workbook Edits","GTNUCDENS","discipline","Project Items","DropDownsEtc","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":1,"macros":1,"external_links":3,"defined_names":44,"comments":9,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Header","index":0,"n_rows":26,"n_cols":22,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,19,4,20],[10,3,10,5],[3,19,3,20],[15,3,15,5],[7,3,7,5],[7,12,7,14],[6,3,6,5],[10,8,10,11],[6,12,6,14],[8,12,8,14],[10,15,10,16],[19,3,19,20],[12,3,12,5],[16,3,16,5],[13,3,13,5],[17,3,17,5],[17,12,17,17],[15,12,15,14],[15,15,15,17]]}
["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 ","DENSITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version ","2.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(New XML Schema)"]
["Material Type",null,null,"S",null,null,null,null,null,"Material Code"]
["Sample Date",null,null,null,null,null,null,null,null,"Producer/Supplier Code"]
[null,null,null,null,null,null,null,null,null,"Sample Unit"]
[]
["Contract",null,null,null,null,null,null,"Project   ",null,null,null,null,null,null,"Line Item Number   ",null,null,null,null,"Represented Quantity  "]
[]
["QC Tester (SM User ID)"]
["QA Tester (SM User ID)"]
[]
["Sample ID",null,"",null,null,null,null,null,null,"Intended Use"]
["District",null,null,{"$f":"LEFT(D16,2)","v":""}]
["Crew",null,null,{"$f":"MID(D16,3,3)","v":""}]
[]
["Remarks"]
[]
[]
[]
[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,"KYTC Entries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read-Only"]

{"sheet":"Details","index":1,"n_rows":47,"n_cols":31,"rows_kept":47,"cut":false,"hidden":false,"merged":[[10,24,10,27],[10,30,10,33],[10,1,10,7],[10,8,10,11],[10,12,10,15],[10,16,10,19],[29,8,29,11],[29,12,29,15],[3,12,3,15],[4,12,4,19],[15,16,15,19],[13,20,13,23],[11,20,11,23],[11,16,11,19],[9,20,9,23],[10,20,10,23],[15,20,15,23],[45,1,45,7],[24,8,24,11],[24,12,24,15],[32,12,32,15],[32,1,32,7],[31,1,31,7],[29,16,29,19],[28,12,28,15],[31,8,31,11],[28,8,28,11],[31,12,31,15],[30,8,30,11],[30,16,30,19],[38,1,38,7],[37,1,37,7],[37,8,37,11],[37,12,37,15],[36,1,36,7],[26,12,26,15],[28,1,28,7],[29,1,29,7],[30,1,30,7],[30,12,30,15],[36,12,36,15],[32,8,32,11],[30,30,30,33],[32,16,32,19],[32,20,32,23],[31,30,31,33],[30,24,30,27],[31,24,31,27],[32,24,32,27],[36,8,36,11],[36,30,36,33],[36,16,36,19],[29,30,29,33],[33,30,33,33],[31,16,31,19],[31,20,31,23],[28,16,28,19],[28,20,28,23],[29,20,29,23],[30,20,30,23],[37,16,37,19],[32,30,32,33],[37,20,37,23],[37,30,37,33],[27,1,27,7],[27,8,27,11],[27,12,27,15],[27,16,27,19],[27,20,27,23],[27,30,27,33],[26,1,26,7],[26,8,26,11],[28,30,28,33],[26,16,26,19],[25,1,25,7],[25,8,25,11],[25,12,25,15],[25,16,25,19],[25,20,25,23],[25,30,25,33],[24,1,24,7],[24,16,24,19],[26,20,26,23],[26,30,26,33],[23,1,23,7],[23,8,23,11],[23,12,23,15],[23,16,23,19],[23,20,23,23],[23,30,23,33],[22,1,22,7],[22,16,22,19],[24,20,24,23],[24,30,24,33],[22,8,22,11],[22,12,22,15],[21,20,21,23],[21,30,21,33],[21,24,21,27],[21,1,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[20,1,20,7],[22,20,22,23],[22,30,22,33],[20,8,20,11],[19,1,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[20,12,20,15],[20,16,20,19],[19,20,19,23],[19,30,19,33],[15,1,15,7],[15,8,15,11],[17,30,17,33],[18,30,18,33],[17,1,17,7],[18,16,18,19],[18,8,18,11],[17,8,17,11],[20,20,20,23],[20,30,20,33],[17,20,17,23],[18,12,18,15],[15,30,15,33],[14,24,14,27],[15,24,15,27],[18,20,18,23],[18,1,18,7],[17,12,17,15],[17,16,17,19],[15,12,15,15],[16,1,16,7],[36,20,36,23],[3,9,3,11],[4,9,4,11],[2,12,2,33],[9,24,9,27],[16,16,16,19],[38,30,38,33],[25,24,25,27],[17,24,17,27],[18,24,18,27],[19,24,19,27],[9,8,9,11],[9,12,9,15],[9,16,9,19],[9,30,9,33],[2,9,2,11],[11,30,11,33],[12,8,12,11],[12,12,12,15],[12,16,12,19],[12,20,12,23],[12,30,12,33],[11,8,11,11],[11,12,11,15],[24,24,24,27],[14,1,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[16,8,16,11],[16,12,16,15],[38,24,38,27],[26,24,26,27],[27,24,27,27],[28,24,28,27],[29,24,29,27],[33,24,33,27],[36,24,36,27],[37,24,37,27],[33,1,33,7],[38,8,38,11],[38,12,38,15],[38,16,38,19],[38,20,38,23],[33,8,33,11],[33,12,33,15],[33,16,33,19],[33,20,33,23],[0,1,0,33],[16,20,16,23],[16,24,16,27],[16,30,16,33],[11,24,11,27],[12,24,12,27],[20,24,20,27],[22,24,22,27],[23,24,23,27],[9,1,9,7],[2,1,2,4],[3,1,3,4],[2,5,2,7],[3,5,3,7],[12,1,12,7],[11,1,11,7],[13,1,13,7],[13,8,13,11],[13,12,13,15],[13,16,13,19],[13,30,13,33],[14,20,14,23],[14,30,14,33],[13,24,13,27]]}
[null,"Moisture-Density Test Report"]
[]
[null,"METER #",null,null,null,null,null,null,null,"ROAD NAME"]
[null,"MODEL #",null,null,null,null,null,null,null,"ROUTE #"]
[null,null,null,null,null,null,null,null,null,"COUNTY"]
[]
[null,"Note:  For DGA & CSB, test section",null,null,null,null,null,null,"2500 SY (2100 SM)",null,null,null,null,null,"5 equal sections of 500 SY (420 SM) @ random locations"]
[]
[]
[null,"SiteManager Sample ID",null,null,null,null,null,null,{"$f":"IF(I30=\"\",\"\",CONCATENATE(Header!D16,\"QC01\"))","v":""},null,null,null,{"$f":"IF(M30=\"\",\"\",CONCATENATE(Header!D16,\"QC02\"))","v":""},null,null,null,{"$f":"IF(Q30=\"\",\"\",CONCATENATE(Header!D16,\"QC03\"))","v":""},null,null,null,{"$f":"IF(U30=\"\",\"\",CONCATENATE(Header!D16,\"QC04\"))","v":""},null,null,null,{"$f":"IF(Y30=\"\",\"\",IF(Y17=\"Not Used\",\"\",CONCATENATE(Header!D16,\"QC05\")))","v":""},null,null,null,null,null,{"$f":"IF(AE30=\"\",\"\",CONCATENATE(Header!D16,\"QA01\"))","v":""}]
[null,"Roll/Sublot #",null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,{"$f":"IF(Y17=\"Not Used\",\"\",5)","v":5}]
[null,"Station #"]
[null,"CL Offset Distance"]
[null,"Latitude"]
[null,"Longitude"]
[null,"Elevation"]
[null,"DGA or CSB or SOIL",null,null,null,null,null,null,"CSB",null,null,null,{"$f":"IF($I$17=\"\",\"\",$I$17)","v":"CSB"},null,null,null,{"$f":"IF($I$17=\"\",\"\",$I$17)","v":"CSB"},null,null,null,{"$f":"IF($I$17=\"\",\"\",$I$17)","v":"CSB"},null,null,null,{"$f":"IF($I$17=\"\",\"\",$I$17)","v":"CSB"},null,null,null,null,null,{"$f":"IF($I$17=\"\",\"\",$I$17)","v":"CSB"}]
[null,"Standard Density Count"]
[null,"Standard Moisture Count"]
[null,"QC or QA",null,null,null,null,null,null,"QC",null,null,null,"QC",null,null,null,"QC",null,null,null,"QC",null,null,null,"QC",null,null,null,null,null,"QA"]
[null,"Test Depth"]
["DC","Density Count"]
["WD","Wet Density (lb/cf)"]
["MC","Moisture Count"]
["M","Moisture (lb)"]
["DD","Dry Density (lb/cf)"]
["%M","% Moisture"]
["Proctor","Target Density (lb/cf)*"]
[null,"Optimum Moisture (%)",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,"Avg. 5 test"]
["%DD","% Compaction**",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,{"$f":"IF(COUNT(I30:AB30)>0,AVERAGE(I30:AB30),\"\")","v":""}]
[null,"Required % Compaction",null,null,null,null,null,null,95,null,null,null,95,null,null,null,95,null,null,null,95,null,null,null,95,null,null,null,98,null,95]
[null,"Moisture Correction (%)"]
[null,"Pass or Fail",null,null,null,null,null,null,{"$f":"IF(I30=\"\",\" \",IF(I30>=I31,\"PASS\",\"FAIL\"))","v":" "},null,null,null,{"$f":"IF(M30=\"\",\" \",IF(M30>=M31,\"PASS\",\"FAIL\"))","v":" "},null,null,null,{"$f":"IF(Q30=\"\",\" \",IF(Q30>=Q31,\"PASS\",\"FAIL\"))","v":" "},null,null,null,{"$f":"IF(U30=\"\",\" \",IF(U30>=U31,\"PASS\",\"FAIL\"))","v":" "},null,null,null,{"$f":"IF(Y30=\"\",\" \",IF(Y30>=Y31,\"PASS\",\"FAIL\"))","v":" "},null,null,null,null,null,{"$f":"IF(AE30=\"\",\" \",IF(AE30>=AE31,\"PASS\",\"FAIL\"))","v":" "}]
[null,"QA validation of QC tests (P or F)***",null,null,null,null,null,null,{"$f":"IF(I30=\"\",\" \",IF(OR(AE11=\"\",AE11=I11),IF(ABS(I23-AE23)<=5,\"PASS\",\"FAIL\")))","v":" "},null,null,null,{"$f":"IF(M30=\"\",\" \",IF(OR(AE11=\"\",AE11=M11),IF(ABS(M23-AE23)<=5,\"PASS\",\"FAIL\")))","v":" "},null,null,null,{"$f":"IF(Q30=\"\",\" \",IF(OR(AE11=\"\",AE11=Q11),IF(ABS(Q23-AE23)<=5,\"PASS\",\"FAIL\")))","v":" "},null,null,null,{"$f":"IF(U30=\"\",\" \",IF(OR(AE11=\"\",AE11=U11),IF(ABS(U23-AE23)<=5,\"PASS\",\"FAIL\")))","v":" "},null,null,null,{"$f":"IF(Y30=\"\",\" \",IF(OR(AE11=\"\",AE11=Y11),IF(ABS(Y23-AE23)<=5,\"PASS\",\"FAIL\")))","v":" "},null,null,null,null,null," "]
[]
[null,"Plus 4 Material correction from KM 64-512"]
[null,"Proctor Value from Plans"]
[null,"Corrected Proctor Density\n    from KM 64-512"]
[null,"QC Tests Witnessed by KYTC"]
[]
[null,"*Proctor from Project Plans or Corrected Proctor"]
[null,"** 95% minimum individual test, average of 5 test 98%"]
[null,"*** The QA test results must be within +- 5 lb/cu ft of the Wet Density and +- 1% of the Moisture Content for all QC tests associated with it."]
[]
[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,"Contractor Entries"]
[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,"KYTC Entries"]
[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,"Read-Only"]

{"sheet":"Workbook Edits","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Tracks Pre-Production Workbook Changes"]
["Date","Initials","Description"]
["2006-11-07","BGP","Mapping complete (2nd time, but now need to convert to new format)."]
["2007-01-04","BGP","Added changes to use sheet for DGA & CSB as well as SOIL."]
["2007-01-10","BGP","Finalized version 1 (after final feedback from Billy & Adam)."]
["2007-01-19","BGP","Corrected the edit on t_smpl.witnes_by_cms_uid to be consistent with all other disciplines (make sure SM Login User ID)."]
["2007-02-01","BGP","Changed the labels on t_smpl_tst.strt_dt to be “Received Date” and the label on the t_smpl_tst.est_cmpl_dt to be “Actual Start Date” so that edits would be clear."]
["2007-02-07","BGP","Assigned new \"Template Status\" code table value in t_tst_rslt_dtl.F2 based on the value in t_smpl.smpl_stat (Global Template Change)."]
["2007-02-12","BGP","Fixed assignment of District on discipline tab."]
["2007-04-12","BGP","Fixed Witnessed By on t_smpl tab and populated data; also corrected Remarks ID on t_rmks_dtl tab; added Witnessed By to Template (now in both places)."]
["2007-04-13","BGP","Removed \"ALL\" selection from Material Type on Header tab; replaced edit on Witnessed By on t_tst_rslt_dtl tab."]

{"sheet":"GTNUCDENS","index":3,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Test Method","GTNUCDENS",null,null,null,"Cell","type","label","ranges","length","unit",null,"SM Template Mapping"]
["Description","MOISTURE-NUCLEAR DENSITY"]
[]
["Road Name","B4",null,null,null,"B4","Alphanumeric","Road Name",null,60,"None",null,"F8"]
["County","B5",null,null,null,"B5","Alphanumeric","County",null,20,"None",null,"F9"]
["Route #","B6",null,null,null,"B6","Alphanumeric","Route #",null,10,"None",null,"F10"]
["Density Meter #","B7",null,null,null,"B7","Alphanumeric","Density Meter #",null,9,"None",null,"F11"]
["Model #","B8",null,null,null,"B8","Alphanumeric","Model #",null,9,"None",null,"F12"]
[null,null,null,null,null,"B10","Alphanumeric","Latitude",null,10,"None",null,"F13"]
["Latitude","B10",null,null,null,"B11","Alphanumeric","Longitude",null,10,"None",null,"F14"]
["Longitude","B11",null,null,null,"B12","Numeric","Elevation",null,5.2,"FT",null,"F15"]
["Elevation","B12",null,null,null,"B13","Numeric","Standard Density Count","0-9999999",7,"None",null,"F16"]
["Standard Density Count","B13",null,null,null,"B14","Numeric","Standard Moisture Count","0-9999999",7,"None",null,"F17"]
["Standard Moisture Count","B14",null,null,null,"B16","Numeric","Test Depth","0-18",2.1,"Inch",null,"F18"]
[null,null,null,null,null,"B17","Numeric","Density Count","0-9999999",7,"None",null,"F19"]
["Test Depth","B16",null,null,null,"B18","Numeric","Wet Density","60-160",3.2,"LB/cf",null,"F20"]
["Density Count","B17",null,null,null,"B19","Numeric","Moisture Count","0-9999999",7,"None",null,"F21"]
["Wet Density","B18",null,null,null,"B20","Numeric","Moisture","0-125",3.2,"lb ",null,"F22"]
["Moisture Count","B19",null,null,null,"B21","Numeric","Dry Density","60-160",3.2,"LB/cf",null,"F23"]
["Moisture","B20",null,null,null,"B22","Numeric","% Moisture","0-100",3.2,"%",null,"F24"]
["Dry Density","B21",null,null,null,"B23","Numeric","Target Density","60-160",3.2,"LB/cf",null,"F25"]
["% Moisture","B22",null,null,null,"B24","Numeric","Optimum Moisture","0-100",3.2,"%",null,"F26"]
["Target Density","B23",null,null,null,"B25","Numeric","% Compaction","0-100",3.2,"%",null,"F27"]
["Optimum Moisture","B24",null,null,null,"B26","Numeric","Required % Compaction","0-100",3.2,"%",null,"F28"]
["% Compaction","B25",null,null,null,"B27","Numeric","Moisture Correction","0-100",3.2,"%",null,"F29"]
["Required % Compaction","B26",null,null,null,"B28","Alphanumeric","Pass or Fail",null,4,"None",null,"F30"]
["Moisture Correction","B27",null,null,null,"B29","Alphanumeric","QA validation of QC tests (P or F)",null,4,"None",null,"F31"]
["Pass or Fail","B28",null,null,null,"B30","Label","If +4 correction",null,"n/a","None",null,"F32"]
["QA validation of QC tests (P or F)","B29",null,null,null,"B32","Numeric","Proctor Value from Plans","60-160",3.2,"LB/cf",null,"F33"]
[null,null,null,null,null,"B33","Numeric","Corrected Proctor Density from KM 64-512","60-160",3.2,"LB/cf",null,"F34"]
["If +4 correction",null,null,null,null,"B34","Alphanumeric","QC Tests Witnessed by KYTC",null,8,"None",null,"F35"]
["   Proctor Value from Plans","B32"]
["   Corrected Proctor Density\n      from KM 64-512","B33"]
["   QC Tests Witnessed by KYTC","B34"]

{"sheet":"discipline","index":4,"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":"DENSITY"},"v1.0","Y",{"$f":"Header!D17","v":""},{"$f":"Header!D16","v":0}]

{"sheet":"Project Items","index":5,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Project","Line Item","Represented",null,null,"Read-Only"]
[null,"Number","Quantity",null,null,"Contractor Entries"]
[null,null,null,null,null,"   (Add as many rows as required)"]
["t_cont_smpl","t_cont_smpl","t_cont_smpl"]
["prj_nbr","ln_itm_nbr","repr_qty"]
[{"$f":"Header!I11","v":0},{"$f":"Header!P11","v":0},{"$f":"Header!U11","v":0}]

{"sheet":"DropDownsEtc","index":6,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["YES","no longer used"]
["NO","no longer used"]
[]
[]
["CSB",10450]
["DGA",10455]
["SOIL",51100]
["STABLIZED SUBGD",51000]
["ALL","ZZZZZ"]
[]
[]
[]
["CUYD"]
["CU M"]
["SQYD"]
["TON "]
[]
[1]
[2]
[3]
[4]
[5]

{"sheet":"t_smpl","index":7,"n_rows":13,"n_cols":55,"rows_kept":13,"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,"c",null,"c",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 \nAND t_matl_user.sm_user_ind='Y'",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","Use the Sample ID Prefix to uniquely tie this set of samples together.",null,"Derived from first two characters of Sample ID",null,"Current system date",null,"Current system date",null,null,"Not Used\nInitialized to \" \" (i.e., space)",null,"Not Used\nInitialized to \" \" (i.e., space)","Comes from t_rmks_dtl tab\n(Remark on Header tab is duplicated for all samples)","Not Used\nInitialized to \" \" (i.e., space)",null,"Not Used\nInitialized to \" \" (i.e., space)","Embed code table in spreadsheet","Sampler ID",null,null,"Not used for QA Samples","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)","This will be the total Represented Quantity recorded on the Project Item Tab corresponding to each specific Sublot, except for the QA sample which will be the entire amount on the Project Item tab..\n\nNOTE: the Repr Qty for each Sublot is computed as follows:\n\nIF the Cumulative Repr Qty (from the Project Items tab) > (500 * Sublot Number) THEN\n      Repr Qty for this Sublot = 500\nELSE\n      Repr Qty for this Sublot = \n      Cumulative Repr Qty - \n     (Total for Sublot's before this one)\n","Not Used\nInitialized to \" \" (i.e., space)",null,"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"]
["QC01",{"$f":"Details!I10","v":""},"TR",{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$D$14","v":0},{"$f":"Header!$D$16","v":0},"LNBR",{"$f":"Header!$D$17","v":""},{"$f":"Header!$M$16","v":0},null,{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$M$7","v":0},{"$f":"Details!I13","v":0}," ",{"$f":"Header!$M$8","v":0}," ",{"$f":"t_rmks_dtl!B8","v":" "}," ",{"$f":"Header!$D$8","v":"00:00:00"}," ",{"$f":"Details!I20","v":"QC"},{"$f":"Header!$D$13","v":0},{"$f":"Details!I12","v":0},"COMP",{"$f":"IF(Details!I39=\"\",\"\",Details!I39)","v":""}," "," "," "," "," ",{"$f":"Header!$M$9","v":0}," "," "," "," ",{"$f":"IF(B8=\"\",0,IF(SUM('Project Items'!C6:C100)>500*AN8,500,SUM('Project Items'!C6:C100)-500*(AN8-1)))","v":0}," ",{"$f":"Details!I11","v":1}," "," ",{"$f":"IF(W8=\"QC\",\"Y\",\"N\")","v":"Y"}," "," "," "," "," "," "," ",null," "," "," "," "]
[null,{"$f":"Details!M10","v":""},"TR",{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$D$14","v":0},{"$f":"Header!$D$16","v":0},"LNBR",{"$f":"Header!$D$17","v":""},{"$f":"Header!$M$16","v":0},null,{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$M$7","v":0},{"$f":"Details!M13","v":0}," ",{"$f":"Header!$M$8","v":0}," ",{"$f":"t_rmks_dtl!B9","v":" "}," ",{"$f":"Header!$D$8","v":"00:00:00"}," ",{"$f":"Details!M20","v":"QC"},{"$f":"Header!$D$13","v":0},{"$f":"Details!M12","v":0},"COMP",{"$f":"IF(Details!M39=\"\",\"\",Details!M39)","v":""}," "," "," "," "," ",{"$f":"Header!$M$9","v":0}," "," "," "," ",{"$f":"IF(B9=\"\",0,IF(SUM('Project Items'!C6:C100)>500*AN9,500,SUM('Project Items'!C6:C100)-AL8))","v":0}," ",{"$f":"Details!M11","v":2}," "," ","Y"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,{"$f":"Details!Q10","v":""},"TR",{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$D$14","v":0},{"$f":"Header!$D$16","v":0},"LNBR",{"$f":"Header!$D$17","v":""},{"$f":"Header!$M$16","v":0},null,{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$M$7","v":0},{"$f":"Details!Q13","v":0}," ",{"$f":"Header!$M$8","v":0}," ",{"$f":"t_rmks_dtl!B10","v":" "}," ",{"$f":"Header!$D$8","v":"00:00:00"}," ",{"$f":"Details!Q20","v":"QC"},{"$f":"Header!$D$13","v":0},{"$f":"Details!Q12","v":0},"COMP",{"$f":"IF(Details!Q39=\"\",\"\",Details!Q39)","v":""}," "," "," "," "," ",{"$f":"Header!$M$9","v":0}," "," "," "," ",{"$f":"IF(B10=\"\",0,IF(SUM('Project Items'!C6:C100)>500*AN10,500,SUM('Project Items'!C6:C100)-AL9-AL8))","v":0}," ",{"$f":"Details!Q11","v":3}," "," ","Y"," "," "," "," "," "," "," ",null," "," "," "," "]
[null,{"$f":"Details!U10","v":""},"TR",{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$D$14","v":0},{"$f":"Header!$D$16","v":0},"LNBR",{"$f":"Header!$D$17","v":""},{"$f":"Header!$M$16","v":0},null,{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$M$7","v":0},{"$f":"Details!U13","v":0}," ",{"$f":"Header!$M$8","v":0}," ",{"$f":"t_rmks_dtl!B11","v":" "}," ",{"$f":"Header!$D$8","v":"00:00:00"}," ",{"$f":"Details!U20","v":"QC"},{"$f":"Header!$D$13","v":0},{"$f":"Details!U12","v":0},"COMP",{"$f":"IF(Details!U39=\"\",\"\",Details!U39)","v":""}," "," "," "," "," ",{"$f":"Header!$M$9","v":0}," "," "," "," ",{"$f":"IF(B11=\"\",0,IF(SUM('Project Items'!C6:C100)>500*AN11,500,SUM('Project Items'!C6:C100)-AL10-AL9-AL8))","v":0}," ",{"$f":"Details!U11","v":4}," "," ","Y"," "," "," "," "," "," "," ",null," "," "," "," "]
["QC05",{"$f":"Details!Y10","v":""},"TR",{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$D$14","v":0},{"$f":"Header!$D$16","v":0},"LNBR",{"$f":"Header!$D$17","v":""},{"$f":"Header!$M$16","v":0},null,{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$M$7","v":0},{"$f":"Details!Y13","v":0}," ",{"$f":"Header!$M$8","v":0}," ",{"$f":"t_rmks_dtl!B12","v":" "}," ",{"$f":"Header!$D$8","v":"00:00:00"}," ",{"$f":"Details!Y20","v":"QC"},{"$f":"Header!$D$13","v":0},{"$f":"Details!Y12","v":0},"COMP",{"$f":"IF(Details!Y39=\"\",\"\",Details!Y39)","v":""}," "," "," "," "," ",{"$f":"Header!$M$9","v":0}," "," "," "," ",{"$f":"IF(B12=\"\",0,IF(SUM('Project Items'!C6:C100)>500*AN11,SUM('Project Items'!C6:C100)-2000,SUM('Project Items'!C6:C100)-AL11-AL10-AL9-AL8))","v":0}," ",{"$f":"Details!Y11","v":5}," "," ","Y"," "," "," "," "," "," "," ",null," "," "," "," "]
["QA01",{"$f":"Details!AE10","v":""},"TR",{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$D$14","v":0},{"$f":"Header!$D$16","v":0},"LNBR",{"$f":"Header!$D$17","v":""},{"$f":"Header!$M$16","v":0},null,{"$f":"Header!$D$14","v":0},null,{"$f":"Header!$M$7","v":0},{"$f":"Details!AE13","v":0}," ",{"$f":"Header!$M$8","v":0}," ",{"$f":"t_rmks_dtl!B13","v":" "}," ",{"$f":"Header!$D$8","v":"00:00:00"}," ",{"$f":"Details!AE20","v":"QA"},{"$f":"Header!$D$14","v":0},{"$f":"Details!AE12","v":0},"COMP"," "," "," "," "," "," ",{"$f":"Header!$M$9","v":0}," "," "," "," ",{"$f":"IF(B13=\"\",0,SUM('Project Items'!C6:C100))","v":0}," ",{"$f":"Details!AE11","v":0}," "," ","N"," "," "," "," "," "," "," ",null," "," "," "," "]

{"sheet":"t_cont_smpl","index":8,"n_rows":13,"n_cols":11,"rows_kept":13,"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":"5-COUNTBLANK(t_smpl!B8:B12)","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"]
["QC01",{"$f":"t_smpl!B8","v":""},{"$f":"Header!$D$11","v":0},"N/A","N/A","N/A",{"$f":"Header!D14","v":0}]
[null,{"$f":"t_smpl!B9","v":""},{"$f":"Header!$D$11","v":0},"N/A","N/A","N/A",{"$f":"G8","v":0}]
[null,{"$f":"t_smpl!B10","v":""},{"$f":"Header!$D$11","v":0},"N/A","N/A","N/A",{"$f":"G9","v":0}]
[null,{"$f":"t_smpl!B11","v":""},{"$f":"Header!$D$11","v":0},"N/A","N/A","N/A",{"$f":"G10","v":0}]
["QC05",{"$f":"t_smpl!B12","v":""},{"$f":"Header!$D$11","v":0},"N/A","N/A","N/A",{"$f":"G11","v":0}]
["QA01",{"$f":"t_smpl!B13","v":""},{"$f":"Header!$D$11","v":0},"N/A","N/A","N/A",{"$f":"G12","v":0}]

{"sheet":"t_rmks_dtl","index":9,"n_rows":13,"n_cols":7,"rows_kept":13,"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"]
["QC01",{"$f":"IF(t_smpl!B8=\"\",\" \",IF(E8=0,\"\",CONCATENATE(Header!$D$14,TEXT(NOW(),\"yyyymmddhhmmss\"),RIGHT(t_smpl!$B$8,4))))","v":" "},"GEN",1,{"$f":"Header!$D$20","v":0},{"$f":"Header!D14","v":0}]
[null,{"$f":"IF(t_smpl!B9=\"\",\" \",IF(E9=0,\"\",CONCATENATE(Header!$D$14,TEXT(NOW(),\"yyyymmddhhmmss\"),RIGHT(t_smpl!$B$9,4))))","v":" "},"GEN",1,{"$f":"Header!$D$20","v":0},{"$f":"F8","v":0}]
[null,{"$f":"IF(t_smpl!B10=\"\",\" \",IF(E10=0,\"\",CONCATENATE(Header!$D$14,TEXT(NOW(),\"yyyymmddhhmmss\"),RIGHT(t_smpl!$B$10,4))))","v":" "},"GEN",1,{"$f":"Header!$D$20","v":0},{"$f":"F9","v":0}]
[null,{"$f":"IF(t_smpl!B11=\"\",\" \",IF(E11=0,\"\",CONCATENATE(Header!$D$14,TEXT(NOW(),\"yyyymmddhhmmss\"),RIGHT(t_smpl!$B$11,4))))","v":" "},"GEN",1,{"$f":"Header!$D$20","v":0},{"$f":"F10","v":0}]
["QC05",{"$f":"IF(t_smpl!B12=\"\",\" \",IF(E12=0,\"\",CONCATENATE(Header!$D$14,TEXT(NOW(),\"yyyymmddhhmmss\"),RIGHT(t_smpl!$B$12,4))))","v":" "},"GEN",1,{"$f":"Header!$D$20","v":0},{"$f":"F11","v":0}]
["QA01",{"$f":"IF(t_smpl!B13=\"\",\" \",IF(E13=0,\"\",CONCATENATE(Header!$D$14,TEXT(NOW(),\"yyyymmddhhmmss\"),RIGHT(t_smpl!$B$13,4))))","v":" "},"GEN",1,{"$f":"Header!$D$20","v":0},{"$f":"F12","v":0}]

{"sheet":"t_smpl_tst","index":10,"n_rows":13,"n_cols":11,"rows_kept":13,"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",null,null,null,null,"Must be >= Received Date (for the same row)","Must be >= Received Date AND Actual Start Date (for the same row)"]
["Comment","IF No Sample ID, Ignore Row.",null,null,"Not Used\nInitialized to \" \" (i.e., space)","Not Used\nInitialized to 0","Use Sample Date as Test Date","Use Sample Date as Test Date","Use Sample Date as Test Date",null,"Current system date"]
["Long Description","SiteManager \nSample ID ","Test Method","Test Number","SM Laboratory ID","Charge Amount","Received Date","Actual Start Date","Actual Completion Date","Last Modified User ID","Last Modified Date"]
["User Entry                                     XML Schema \nSheet Map                                   Column Name","smpl_id","tst_meth","smpl_tst_nbr","lab_id","chrg_amt","strt_dt","est_cmpl_dt","actl_cmpl_dt","last_modfd_uid","last_modfd_dt"]
["QC01",{"$f":"t_smpl!B8","v":""},"GTNUCDENS",1,{"$f":"\"LU\" & Header!$D$17&Header!$D$18","v":"LU"},0,{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$14","v":0}]
[null,{"$f":"t_smpl!B9","v":""},"GTNUCDENS",1,{"$f":"\"LU\" & Header!$D$17&Header!$D$18","v":"LU"},0,{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$14","v":0}]
[null,{"$f":"t_smpl!B10","v":""},"GTNUCDENS",1,{"$f":"\"LU\" & Header!$D$17&Header!$D$18","v":"LU"},0,{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$14","v":0}]
[null,{"$f":"t_smpl!B11","v":""},"GTNUCDENS",1,{"$f":"\"LU\" & Header!$D$17&Header!$D$18","v":"LU"},0,{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$14","v":0}]
["QC05",{"$f":"t_smpl!B12","v":""},"GTNUCDENS",1,{"$f":"\"LU\" & Header!$D$17&Header!$D$18","v":"LU"},0,{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$14","v":0}]
["QA01",{"$f":"t_smpl!B13","v":""},"GTNUCDENS",1,{"$f":"\"LU\" & Header!$D$17&Header!$D$18","v":"LU"},0,{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$8","v":"00:00:00"},{"$f":"Header!$D$14","v":0}]

{"sheet":"t_smpl_tstr","index":11,"n_rows":13,"n_cols":7,"rows_kept":13,"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"]
["QC01",{"$f":"t_smpl!B8","v":""},"GTNUCDENS",1,{"$f":"Header!$D$13","v":0},{"$f":"Header!$D$14","v":0}]
[null,{"$f":"t_smpl!B9","v":""},"GTNUCDENS",1,{"$f":"Header!$D$13","v":0},{"$f":"F8","v":0}]
[null,{"$f":"t_smpl!B10","v":""},"GTNUCDENS",1,{"$f":"Header!$D$13","v":0},{"$f":"F9","v":0}]
[null,{"$f":"t_smpl!B11","v":""},"GTNUCDENS",1,{"$f":"Header!$D$13","v":0},{"$f":"F10","v":0}]
["QC05",{"$f":"t_smpl!B12","v":""},"GTNUCDENS",1,{"$f":"Header!$D$13","v":0},{"$f":"F11","v":0}]
["QA01",{"$f":"t_smpl!B13","v":""},"GTNUCDENS",1,{"$f":"Header!$D$14","v":0},{"$f":"F12","v":0}]

{"sheet":"t_tst_rslt_hdr","index":12,"n_rows":13,"n_cols":8,"rows_kept":13,"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","Existing on t_tst_fee_schd"]
["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"]
["QC01",{"$f":"t_smpl!B8","v":""},"GTNUCDENS",1," ",null,null,{"$f":"Header!$D$14","v":0}]
[null,{"$f":"t_smpl!B9","v":""},"GTNUCDENS",1," ",null,null,{"$f":"H8","v":0}]
[null,{"$f":"t_smpl!B10","v":""},"GTNUCDENS",1," ",null,null,{"$f":"H9","v":0}]
[null,{"$f":"t_smpl!B11","v":""},"GTNUCDENS",1," ",null,null,{"$f":"H10","v":0}]
["QC05",{"$f":"t_smpl!B12","v":""},"GTNUCDENS",1," ",null,null,{"$f":"H11","v":0}]
["QA01",{"$f":"t_smpl!B13","v":""},"GTNUCDENS",1," ",null,null,{"$f":"H12","v":0}]

{"sheet":"t_tst_rslt_dtl","index":13,"n_rows":217,"n_cols":9,"rows_kept":217,"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","Existing on t_tst_fee_schd",null,null,"Type & Size   AND\nCHOOSE CASE tst_fld_sn\n      CASE 2   [Code Table check]\n            Existing on t_cd_tbl_dtl (cd_id)\n            AND t_cd_tbl_dtl.tbl_id='TEMPSTAT'\n\n      CASE 35   [Witness check]\n            Existing on t_matl_user \n            AND t_matl_user.sm_user_ind='Y'\nENDCASE","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"]
["QC01 - Comment  (NOT CURRENTLY USED)",{"$f":"t_smpl!B8","v":""},"GTNUCDENS",1,1," ",0,{"$f":"Header!D14","v":0}]
[null,{"$f":"t_smpl!B9","v":""},"GTNUCDENS",1,1," ",0,{"$f":"H8","v":0}]
[null,{"$f":"t_smpl!B10","v":""},"GTNUCDENS",1,1," ",0,{"$f":"H9","v":0}]
[null,{"$f":"t_smpl!B11","v":""},"GTNUCDENS",1,1," ",0,0]
[null,{"$f":"t_smpl!B12","v":""},"GTNUCDENS",1,1," ",0,0]
["QA01 - Comment  (NOT CURRENTLY USED)",{"$f":"t_smpl!B13","v":""},"GTNUCDENS",1,1," ",0,0]
["QC01 - Template Status (TEMPSTAT)",{"$f":"B8","v":""},"GTNUCDENS",1,2,{"$f":"IF(B14=\"\",\" \",IF(t_smpl!Z8=\"COMP\",\"ISPC\",\"OSPC\"))","v":" "},0,0]
[null,"","GTNUCDENS",1,2,{"$f":"IF(B15=\"\",\" \",IF(t_smpl!Z9=\"COMP\",\"ISPC\",\"OSPC\"))","v":" "},0,0]
[null,"","GTNUCDENS",1,2,{"$f":"IF(B16=\"\",\" \",IF(t_smpl!Z10=\"COMP\",\"ISPC\",\"OSPC\"))","v":" "},0,0]
[null,"","GTNUCDENS",1,2,{"$f":"IF(B17=\"\",\" \",IF(t_smpl!Z11=\"COMP\",\"ISPC\",\"OSPC\"))","v":" "},0,0]
[null,"","GTNUCDENS",1,2,{"$f":"IF(B18=\"\",\" \",IF(t_smpl!Z12=\"COMP\",\"ISPC\",\"OSPC\"))","v":" "},0,0]
["QA01 - Template Status (TEMPSTAT)","","GTNUCDENS",1,2,{"$f":"IF(B19=\"\",\" \",IF(t_smpl!Z13=\"COMP\",\"ISPC\",\"OSPC\"))","v":" "},0,0]
["QC01 - GenericString2  (NOT CURRENTLY USED)","","GTNUCDENS",1,3," ",0,0]
[null,"","GTNUCDENS",1,3," ",0,0]
[null,"","GTNUCDENS",1,3," ",0,0]
[null,"","GTNUCDENS",1,3," ",0,0]
[null,"","GTNUCDENS",1,3," ",0,0]
["QA01 - GenericString2  (NOT CURRENTLY USED)","","GTNUCDENS",1,3," ",0,0]
["QC01 - GenericNum1  (NOT CURRENTLY USED)","","GTNUCDENS",1,4," ",0,0]
[null,"","GTNUCDENS",1,4," ",0,0]
[null,"","GTNUCDENS",1,4," ",0,0]
[null,"","GTNUCDENS",1,4," ",0,0]
[null,"","GTNUCDENS",1,4," ",0,0]
["QA01 - GenericNum1  (NOT CURRENTLY USED)","","GTNUCDENS",1,4," ",0,0]
["QC01 - GenericNum2  (NOT CURRENTLY USED)","","GTNUCDENS",1,5," ",0,0]
[null,"","GTNUCDENS",1,5," ",0,0]
[null,"","GTNUCDENS",1,5," ",0,0]
[null,"","GTNUCDENS",1,5," ",0,0]
[null,"","GTNUCDENS",1,5," ",0,0]
["QA01 - GenericNum2  (NOT CURRENTLY USED)","","GTNUCDENS",1,5," ",0,0]
["QC01 - GenericNum3  (NOT CURRENTLY USED)","","GTNUCDENS",1,6," ",0,0]
[null,"","GTNUCDENS",1,6," ",0,0]
[null,"","GTNUCDENS",1,6," ",0,0]
[null,"","GTNUCDENS",1,6," ",0,0]
[null,"","GTNUCDENS",1,6," ",0,0]
["QA01 - GenericNum3  (NOT CURRENTLY USED)","","GTNUCDENS",1,6," ",0,0]
["QC01 - GenericNum4  (NOT CURRENTLY USED)","","GTNUCDENS",1,7," ",0,0]
[null,"","GTNUCDENS",1,7," ",0,0]
[null,"","GTNUCDENS",1,7," ",0,0]
[null,"","GTNUCDENS",1,7," ",0,0]
[null,"","GTNUCDENS",1,7," ",0,0]
["QA01 - GenericNum4  (NOT CURRENTLY USED)","","GTNUCDENS",1,7," ",0,0]
["QC01 - Road Name","","GTNUCDENS",1,8,{"$f":"Details!$M$3","v":0},0,0]
[null,"","GTNUCDENS",1,8,{"$f":"Details!$M$3","v":0},0,0]
[null,"","GTNUCDENS",1,8,{"$f":"Details!$M$3","v":0},0,0]
[null,"","GTNUCDENS",1,8,{"$f":"Details!$M$3","v":0},0,0]
[null,"","GTNUCDENS",1,8,{"$f":"Details!$M$3","v":0},0,0]
["QA01 - Road Name","","GTNUCDENS",1,8,{"$f":"Details!$M$3","v":0},0,0]
["QC01 - County",{"$f":"B50","v":""},"GTNUCDENS",1,9,{"$f":"Details!$M$5","v":0},0,0]
[null,"","GTNUCDENS",1,9,{"$f":"Details!$M$5","v":0},0,0]
[null,"","GTNUCDENS",1,9,{"$f":"Details!$M$5","v":0},0,0]
[null,"","GTNUCDENS",1,9,{"$f":"Details!$M$5","v":0},0,0]
[null,"","GTNUCDENS",1,9,{"$f":"Details!$M$5","v":0},0,0]
["QA01 - County","","GTNUCDENS",1,9,{"$f":"Details!$M$5","v":0},0,0]
["QC01 - Route #","","GTNUCDENS",1,10,{"$f":"Details!$M$4","v":0},0,0]
[null,"","GTNUCDENS",1,10,{"$f":"Details!$M$4","v":0},0,0]
[null,"","GTNUCDENS",1,10,{"$f":"Details!$M$4","v":0},0,0]
[null,"","GTNUCDENS",1,10,{"$f":"Details!$M$4","v":0},0,0]
[null,"","GTNUCDENS",1,10,{"$f":"Details!$M$4","v":0},0,0]
["QA01 - Route #","","GTNUCDENS",1,10,{"$f":"Details!$M$4","v":0},0,0]
["QC01 - Density Meter #","","GTNUCDENS",1,11,{"$f":"Details!$F$3","v":0},0,0]
[null,"","GTNUCDENS",1,11,{"$f":"Details!$F$3","v":0},0,0]
[null,"","GTNUCDENS",1,11,{"$f":"Details!$F$3","v":0},0,0]
[null,"","GTNUCDENS",1,11,{"$f":"Details!$F$3","v":0},0,0]
[null,"","GTNUCDENS",1,11,{"$f":"Details!$F$3","v":0},0,0]
["QA01 - Density Meter #","","GTNUCDENS",1,11,{"$f":"Details!$F$3","v":0},0,0]
["QC01 - Model #","","GTNUCDENS",1,12,{"$f":"Details!$F$4","v":0},0,{"$f":"H73","v":0}]
[null,"","GTNUCDENS",1,12,{"$f":"Details!$F$4","v":0},0,0]
[null,"","GTNUCDENS",1,12,{"$f":"Details!$F$4","v":0},0,0]
[null,"","GTNUCDENS",1,12,{"$f":"Details!$F$4","v":0},0,0]
[null,"","GTNUCDENS",1,12,{"$f":"Details!$F$4","v":0},0,0]
["QA01 - Model #","","GTNUCDENS",1,12,{"$f":"Details!$F$4","v":0},0,0]
["QC01 - Latitude","","GTNUCDENS",1,13,{"$f":"Details!$I$14","v":0},0,0]
[null,"","GTNUCDENS",1,13,{"$f":"Details!$M$14","v":0},0,0]
[null,"","GTNUCDENS",1,13,{"$f":"Details!$Q$14","v":0},0,0]
[null,"","GTNUCDENS",1,13,{"$f":"Details!$U$14","v":0},0,0]
[null,"","GTNUCDENS",1,13,{"$f":"Details!$Y$14","v":0},0,0]
["QA01 - Latitude","","GTNUCDENS",1,13,{"$f":"Details!$AE$14","v":0},0,0]
["QC01 - Longitude","","GTNUCDENS",1,14,{"$f":"Details!$I$15","v":0},0,0]
[null,"","GTNUCDENS",1,14,{"$f":"Details!$M$15","v":0},0,0]
[null,"","GTNUCDENS",1,14,{"$f":"Details!$Q$15","v":0},0,0]
[null,"","GTNUCDENS",1,14,{"$f":"Details!$U$15","v":0},0,0]
[null,"","GTNUCDENS",1,14,{"$f":"Details!$Y$15","v":0},0,0]
["QA01 - Longitude","","GTNUCDENS",1,14,{"$f":"Details!$AE$15","v":0},0,0]
["QC01 - Elevation","","GTNUCDENS",1,15," ",{"$f":"ROUND(Details!$I$16,2)","v":0},0]
[null,"","GTNUCDENS",1,15," ",{"$f":"ROUND(Details!$M$16,2)","v":0},0]
[null,"","GTNUCDENS",1,15," ",{"$f":"ROUND(Details!$Q$16,2)","v":0},0]
[null,"","GTNUCDENS",1,15," ",{"$f":"ROUND(Details!$U$16,2)","v":0},0]
[null,"","GTNUCDENS",1,15," ",{"$f":"ROUND(Details!$Y$16,2)","v":0},0]
["QA01 - Elevation","","GTNUCDENS",1,15," ",{"$f":"ROUND(Details!$AE$16,2)","v":0},0]
["QC01 - Standard Density Count","","GTNUCDENS",1,16," ",{"$f":"ROUND(Details!$I$18,0)","v":0},0]
[null,"","GTNUCDENS",1,16," ",{"$f":"ROUND(Details!$M$18,0)","v":0},0]
[null,"","GTNUCDENS",1,16," ",{"$f":"ROUND(Details!$Q$18,0)","v":0},0]
[null,"","GTNUCDENS",1,16," ",{"$f":"ROUND(Details!$U$18,0)","v":0},0]
[null,"","GTNUCDENS",1,16," ",{"$f":"ROUND(Details!$Y$18,0)","v":0},0]
["QA01 - Standard Density Count","","GTNUCDENS",1,16," ",{"$f":"ROUND(Details!$AE$18,0)","v":0},0]
["QC01 - Standard Moisture Count","","GTNUCDENS",1,17," ",{"$f":"ROUND(Details!$I$19,0)","v":0},0]
[null,"","GTNUCDENS",1,17," ",{"$f":"ROUND(Details!$M$19,0)","v":0},0]
[null,"","GTNUCDENS",1,17," ",{"$f":"ROUND(Details!$Q$19,0)","v":0},0]
[null,"","GTNUCDENS",1,17," ",{"$f":"ROUND(Details!$U$19,0)","v":0},0]
[null,"","GTNUCDENS",1,17," ",{"$f":"ROUND(Details!$Y$19,0)","v":0},0]
["QA01 - Standard Moisture Count","","GTNUCDENS",1,17," ",{"$f":"ROUND(Details!$AE$19,0)","v":0},0]
["QC01 - Test Depth","","GTNUCDENS",1,18," ",{"$f":"ROUND(Details!$I$21,1)","v":0},0]
[null,"","GTNUCDENS",1,18," ",{"$f":"ROUND(Details!$M$21,1)","v":0},0]
[null,"","GTNUCDENS",1,18," ",{"$f":"ROUND(Details!$Q$21,1)","v":0},0]
[null,"","GTNUCDENS",1,18," ",{"$f":"ROUND(Details!$U$21,1)","v":0},0]
[null,"","GTNUCDENS",1,18," ",{"$f":"ROUND(Details!$Y$21,1)","v":0},0]
["QA01 - Test Depth","","GTNUCDENS",1,18," ",{"$f":"ROUND(Details!$AE$21,1)","v":0},0]
["QC01 - Density Count","","GTNUCDENS",1,19," ",{"$f":"ROUND(Details!$I$22,0)","v":0},0]
[null,"","GTNUCDENS",1,19," ",{"$f":"ROUND(Details!$M$22,0)","v":0},0]
[null,"","GTNUCDENS",1,19," ",{"$f":"ROUND(Details!$Q$22,0)","v":0},0]
[null,"","GTNUCDENS",1,19," ",{"$f":"ROUND(Details!$U$22,0)","v":0},0]
[null,{"$f":"B114","v":""},"GTNUCDENS",1,19," ",{"$f":"ROUND(Details!$Y$22,0)","v":0},0]
["QA01 - Density Count","","GTNUCDENS",1,19," ",{"$f":"ROUND(Details!$AE$22,0)","v":0},0]
["QC01 - Wet Density","","GTNUCDENS",1,20," ",{"$f":"ROUND(Details!$I$23,2)","v":0},0]
[null,"","GTNUCDENS",1,20," ",{"$f":"ROUND(Details!$M$23,2)","v":0},0]
[null,"","GTNUCDENS",1,20," ",{"$f":"ROUND(Details!$Q$23,2)","v":0},0]
[null,"","GTNUCDENS",1,20," ",{"$f":"ROUND(Details!$U$23,2)","v":0},0]
[null,"","GTNUCDENS",1,20," ",{"$f":"ROUND(Details!$Y$23,2)","v":0},0]
["QA01 - Wet Density","","GTNUCDENS",1,20," ",{"$f":"ROUND(Details!$AE$23,2)","v":0},0]
["QC01 - Moisture Count","","GTNUCDENS",1,21," ",{"$f":"ROUND(Details!$I$24,0)","v":0},0]
[null,"","GTNUCDENS",1,21," ",{"$f":"ROUND(Details!$M$24,0)","v":0},0]
[null,"","GTNUCDENS",1,21," ",{"$f":"ROUND(Details!$Q$24,0)","v":0},0]
[null,"","GTNUCDENS",1,21," ",{"$f":"ROUND(Details!$U$24,0)","v":0},0]
[null,"","GTNUCDENS",1,21," ",{"$f":"ROUND(Details!$Y$24,0)","v":0},0]
["QA01 - Moisture Count","","GTNUCDENS",1,21," ",{"$f":"ROUND(Details!$AE$24,0)","v":0},0]
["QC01 - Moisture","","GTNUCDENS",1,22," ",{"$f":"ROUND(Details!$I$25,2)","v":0},0]
[null,"","GTNUCDENS",1,22," ",{"$f":"ROUND(Details!$M$25,2)","v":0},0]
[null,"","GTNUCDENS",1,22," ",{"$f":"ROUND(Details!$Q$25,2)","v":0},0]
[null,"","GTNUCDENS",1,22," ",{"$f":"ROUND(Details!$U$25,2)","v":0},0]
[null,"","GTNUCDENS",1,22," ",{"$f":"ROUND(Details!$Y$25,2)","v":0},{"$f":"H137","v":0}]
["QA01 - Moisture","","GTNUCDENS",1,22," ",{"$f":"ROUND(Details!$AE$25,2)","v":0},0]
["QC01 - Dry Density","","GTNUCDENS",1,23," ",{"$f":"ROUND(Details!$I$26,2)","v":0},0]
[null,"","GTNUCDENS",1,23," ",{"$f":"ROUND(Details!$M$26,2)","v":0},0]
[null,"","GTNUCDENS",1,23," ",{"$f":"ROUND(Details!$Q$26,2)","v":0},0]
[null,"","GTNUCDENS",1,23," ",{"$f":"ROUND(Details!$U$26,2)","v":0},0]
[null,"","GTNUCDENS",1,23," ",{"$f":"ROUND(Details!$Y$26,2)","v":0},0]
["QA01 - Dry Density","","GTNUCDENS",1,23," ",{"$f":"ROUND(Details!$AE$26,2)","v":0},0]
["QC01 - % Moisture","","GTNUCDENS",1,24," ",{"$f":"ROUND(Details!$I$27,2)","v":0},0]
[null,"","GTNUCDENS",1,24," ",{"$f":"ROUND(Details!$M$27,2)","v":0},0]
[null,"","GTNUCDENS",1,24," ",{"$f":"ROUND(Details!$Q$27,2)","v":0},0]
[null,"","GTNUCDENS",1,24," ",{"$f":"ROUND(Details!$U$27,2)","v":0},0]
[null,"","GTNUCDENS",1,24," ",{"$f":"ROUND(Details!$Y$27,2)","v":0},0]
["QA01 - % Moisture","","GTNUCDENS",1,24," ",{"$f":"ROUND(Details!$AE$27,2)","v":0},0]
["QC01 - Target Density","","GTNUCDENS",1,25," ",{"$f":"ROUND(Details!$I$28,2)","v":0},0]
[null,"","GTNUCDENS",1,25," ",{"$f":"ROUND(Details!$M$28,2)","v":0},0]
[null,"","GTNUCDENS",1,25," ",{"$f":"ROUND(Details!$Q$28,2)","v":0},0]
[null,"","GTNUCDENS",1,25," ",{"$f":"ROUND(Details!$U$28,2)","v":0},0]
[null,"","GTNUCDENS",1,25," ",{"$f":"ROUND(Details!$Y$28,2)","v":0},0]
["QA01 - Target Density","","GTNUCDENS",1,25," ",{"$f":"ROUND(Details!$AE$28,2)","v":0},0]
["QC01 - Optimum Moisture","","GTNUCDENS",1,26," ",{"$f":"ROUND(Details!$I$29,2)","v":0},0]
[null,"","GTNUCDENS",1,26," ",{"$f":"ROUND(Details!$M$29,2)","v":0},0]
[null,"","GTNUCDENS",1,26," ",{"$f":"ROUND(Details!$Q$29,2)","v":0},0]
[null,"","GTNUCDENS",1,26," ",{"$f":"ROUND(Details!$U$29,2)","v":0},0]
[null,"","GTNUCDENS",1,26," ",{"$f":"ROUND(Details!$Y$29,2)","v":0},0]
["QA01 - Optimum Moisture","","GTNUCDENS",1,26," ",{"$f":"ROUND(Details!$AE$29,2)","v":0},0]
["QC01 - % Compaction","","GTNUCDENS",1,27," ",{"$f":"ROUND(Details!$I$30,2)","v":0},0]
[null,"","GTNUCDENS",1,27," ",{"$f":"ROUND(Details!$M$30,2)","v":0},0]
[null,"","GTNUCDENS",1,27," ",{"$f":"ROUND(Details!$Q$30,2)","v":0},0]
[null,"","GTNUCDENS",1,27," ",{"$f":"ROUND(Details!$U$30,2)","v":0},0]
[null,"","GTNUCDENS",1,27," ",{"$f":"ROUND(Details!$Y$30,2)","v":0},0]
["QA01 - % Compaction","","GTNUCDENS",1,27," ",{"$f":"ROUND(Details!$AE$30,2)","v":0},0]
["QC01 - Required % Compaction","","GTNUCDENS",1,28," ",{"$f":"ROUND(Details!$I$31,2)","v":95},0]
[null,"","GTNUCDENS",1,28," ",{"$f":"ROUND(Details!$M$31,2)","v":95},0]
[null,"","GTNUCDENS",1,28," ",{"$f":"ROUND(Details!$Q$31,2)","v":95},0]
[null,"","GTNUCDENS",1,28," ",{"$f":"ROUND(Details!$U$31,2)","v":95},0]
[null,"","GTNUCDENS",1,28," ",{"$f":"ROUND(Details!$Y$31,2)","v":95},0]
["QA01 - Required % Compaction","","GTNUCDENS",1,28," ",{"$f":"ROUND(Details!$AE$31,2)","v":95},0]
["QC01 - Moisture Correction","","GTNUCDENS",1,29," ",{"$f":"ROUND(Details!$I$32,2)","v":0},0]
[null,"","GTNUCDENS",1,29," ",{"$f":"ROUND(Details!$M$32,2)","v":0},0]
[null,"","GTNUCDENS",1,29," ",{"$f":"ROUND(Details!$Q$32,2)","v":0},0]
[null,"","GTNUCDENS",1,29," ",{"$f":"ROUND(Details!$U$32,2)","v":0},0]
[null,"","GTNUCDENS",1,29," ",{"$f":"ROUND(Details!$Y$32,2)","v":0},0]
["QA01 - Moisture Correction","","GTNUCDENS",1,29," ",{"$f":"ROUND(Details!$AE$32,2)","v":0},0]
["QC01 - Pass or Fail","","GTNUCDENS",1,30,{"$f":"Details!$I$33","v":" "},0,0]
[null,"","GTNUCDENS",1,30,{"$f":"Details!$M$33","v":" "},0,0]
[null,{"$f":"B178","v":""},"GTNUCDENS",1,30,{"$f":"Details!$Q$33","v":" "},0,0]
[null,"","GTNUCDENS",1,30,{"$f":"Details!$U$33","v":" "},0,0]
[null,"","GTNUCDENS",1,30,{"$f":"Details!$Y$33","v":" "},0,0]
["QA01 - Pass or Fail","","GTNUCDENS",1,30,{"$f":"Details!$AE$33","v":" "},0,0]
["QC01 - QA validation of QC tests (P or F)","","GTNUCDENS",1,31,{"$f":"Details!$I$34","v":" "},0,0]
[null,"","GTNUCDENS",1,31,{"$f":"Details!$M$34","v":" "},0,0]
[null,"","GTNUCDENS",1,31,{"$f":"Details!$Q$34","v":" "},0,0]
[null,"","GTNUCDENS",1,31,{"$f":"Details!$U$34","v":" "},0,0]
[null,"","GTNUCDENS",1,31,{"$f":"Details!$Y$34","v":" "},0,0]
["QA01 - QA validation of QC tests (P or F)","","GTNUCDENS",1,31,{"$f":"Details!$AE$34","v":" "},0,0]
["QC01 - LABEL: If +4 correction","","GTNUCDENS",1,32," ",0,0]
[null,"","GTNUCDENS",1,32," ",0,0]
[null,"","GTNUCDENS",1,32," ",0,0]
[null,"","GTNUCDENS",1,32," ",0,0]
[null,"","GTNUCDENS",1,32," ",0,0]
["QA01 -  LABEL: If +4 correction","","GTNUCDENS",1,32," ",0,0]
["QC01 - Proctor Value from Plans","","GTNUCDENS",1,33," ",{"$f":"ROUND(Details!$I$37,2)","v":0},0]
[null,"","GTNUCDENS",1,33," ",{"$f":"ROUND(Details!$M$37,2)","v":0},0]
[null,"","GTNUCDENS",1,33," ",{"$f":"ROUND(Details!$Q$37,2)","v":0},{"$f":"H201","v":0}]
[null,"","GTNUCDENS",1,33," ",{"$f":"ROUND(Details!$U$37,2)","v":0},0]
[null,"","GTNUCDENS",1,33," ",{"$f":"ROUND(Details!$Y$37,2)","v":0},0]
["QA01 - Proctor Value from Plans","","GTNUCDENS",1,33," ",{"$f":"ROUND(Details!$AE$37,2)","v":0},0]
["QC01 - Corrected Proctor Density from KM 64-512","","GTNUCDENS",1,34," ",{"$f":"ROUND(Details!$I$38,2)","v":0},0]
[null,"","GTNUCDENS",1,34," ",{"$f":"ROUND(Details!$M$38,2)","v":0},0]
[null,"","GTNUCDENS",1,34," ",{"$f":"ROUND(Details!$Q$38,2)","v":0},0]
[null,"","GTNUCDENS",1,34," ",{"$f":"ROUND(Details!$U$38,2)","v":0},0]
[null,"","GTNUCDENS",1,34," ",{"$f":"ROUND(Details!$Y$38,2)","v":0},0]
["QA01 - Corrected Proctor Density from KM 64-512","","GTNUCDENS",1,34," ",{"$f":"ROUND(Details!$AE$38,2)","v":0},0]
[null,"","GTNUCDENS",1,"35",{"$f":"IF(Details!$I$39=\"\",\"\",Details!$I$39)","v":""},0,0]
[null,"","GTNUCDENS",1,"35",{"$f":"IF(Details!$M$39=\"\",\"\",Details!$M$39)","v":""},0,0]
[null,"","GTNUCDENS",1,"35",{"$f":"IF(Details!$Q$39=\"\",\"\",Details!$Q$39)","v":""},0,0]
[null,"","GTNUCDENS",1,"35",{"$f":"IF(Details!$U$39=\"\",\"\",Details!$U$39)","v":""},0,0]
[null,"","GTNUCDENS",1,"35",{"$f":"IF(Details!$Y$39=\"\",\"\",Details!$Y$39)","v":""},0,0]
[null,"","GTNUCDENS",1,"35",{"$f":"IF(Details!$Y$39=\"\",\"\",Details!$Y$39)","v":""},0,0]