{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["IAS","Contract_Query","IAS_Samples_Query","IAS_Results_Query","PACP_Results_Query","Lot_Query","Field_Names_Query","-200_Query","Lookup","Report","Sample_Tester"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":10,"comments":0,"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":"IAS","index":0,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,12],[14,2,15,11]]}
["Division of Materials IAS Report - Version 1.2 (02/09/2018)"]
[null,"1.  Type Contract ID and Press ENTER:",null,null,null,"2.  Select IAS Sample ID:",null,null,null,"3.  Enter IAS Sample Number:"]
[]
[null,null,null,null,null,"Acceptance Sample ID:"]
[]
[]
[]
[null,"4.  Sampling and Testing of these Independent Assurance Samples have been:"]
[]
[]
[]
[]
[null,null,"Testing Observed By:"]
[]
[null,"5.  Notes:"]
[]
[]
[null,null,null,null,null,"6.  Run IAS Sample Report:"]

{"sheet":"Contract_Query","index":1,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["CONT_ID","VEND_SHRT_NM","CD_DESC","CONT_CNTY_T"]
[null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(Table_Default__T_CONT_ITM[CONT_CNTY_T],Lookup!A1:B123,2,FALSE)),\"\",VLOOKUP(Table_Default__T_CONT_ITM[CONT_CNTY_T],Lookup!A1:B123,2,FALSE))","v":""}]

{"sheet":"IAS_Samples_Query","index":2,"n_rows":11,"n_cols":21,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["CONT_ID","SMPL_ID","PRJ_NBR","LN_ITM_NBR","ITM_MSTR_SHRT_DESC","MATL_CD","MATL_FULL_NM","TST_METH","SMPL_T","AUTH_DT","STAT_T","REL_SMPL_ID","PRODR_SUPP_CD","PRODR_SUPP_NM","SMPL_DT","SMPLD_FR_TXT","STA","OFFST",null,null,"Sample Row:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Item:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Material:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Producer:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Sampled:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sampled From:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Station:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Offset:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Material Code:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Method:"]

{"sheet":"IAS_Results_Query","index":3,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["SMPL_ID","MATL_CD","TST_METH","SMPL_TST_NBR","TST_ID","TST_FLD_SN","TST_STRG_FLD_VAL","TST_NUMRC_FLD_VAL","ACTL_CMPL_DT","TST_FLD_LBL","TST_FLD_DATA_T","TST_FLD_LEN"]

{"sheet":"PACP_Results_Query","index":4,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["SMPL_ID","MATL_CD","TST_METH","SMPL_TST_NBR","TST_ID","TST_FLD_SN","TST_STRG_FLD_VAL","TST_NUMRC_FLD_VAL","ACTL_CMPL_DT","TST_FLD_LBL","TST_FLD_DATA_T","TST_FLD_LEN"]

{"sheet":"Lot_Query","index":5,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["CNTRL_NBR","SEAL_NBR"]

{"sheet":"Field_Names_Query","index":6,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["TST_FLD_SN","TST_FLD_LBL"]

{"sheet":"-200_Query","index":7,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["TST_METH","TST_FLD_SN","TST_NUMRC_FLD_VAL",null,"TST_METH","TST_FLD_SN","TST_NUMRC_FLD_VAL"]

{"sheet":"Lookup","index":8,"n_rows":123,"n_cols":2,"rows_kept":123,"cut":false,"hidden":true,"merged":[]}
["001","ADAIR"]
["002","ALLEN"]
["003","ANDERSON"]
["004","BALLARD"]
["005","BARREN"]
["006","BATH"]
["007","BELL"]
["008","BOONE"]
["009","BOURBON"]
["010","BOYD"]
["011","BOYLE"]
["012","BRACKEN"]
["013","BREATHITT"]
["014","BRECKINRIDGE"]
["015","BULLITT"]
["016","BUTLER"]
["017","CALDWELL"]
["018","CALLOWAY"]
["019","CAMPBELL"]
["020","CARLISLE"]
["021","CARROLL"]
["022","CARTER"]
["023","CASEY"]
["024","CHRISTIAN"]
["025","CLARK"]
["026","CLAY"]
["027","CLINTON"]
["028","CRITTENDEN"]
["029","CUMBERLAND"]
["030","DAVIESS"]
["031","EDMONSON"]
["032","ELLIOTT"]
["033","ESTILL"]
["034","FAYETTE"]
["035","FLEMING"]
["036","FLOYD"]
["037","FRANKLIN"]
["038","FULTON"]
["039","GALLATIN"]
["040","GARRARD"]
["041","GRANT"]
["042","GRAVES"]
["043","GRAYSON"]
["044","GREEN"]
["045","GREENUP"]
["046","HANCOCK"]
["047","HARDIN"]
["048","HARLAN"]
["049","HARRISON"]
["050","HART"]
["051","HENDERSON"]
["052","HENRY"]
["053","HICKMAN"]
["054","HOPKINS"]
["055","JACKSON"]
["056","JEFFERSON"]
["057","JESSAMINE"]
["058","JOHNSON"]
["059","KENTON"]
["060","KNOTT"]
["061","KNOX"]
["062","LARUE"]
["063","LAUREL"]
["064","LAWRENCE"]
["065","LEE"]
["066","LESLIE"]
["067","LETCHER"]
["068","LEWIS"]
["069","LINCOLN"]
["070","LIVINGSTON"]
["071","LOGAN"]
["072","LYON"]
["073","MCCRACKEN"]
["074","MCCREARY"]
["075","MCLEAN"]
["076","MADISON"]
["077","MAGOFFIN"]
["078","MARION"]
["079","MARSHALL"]
["080","MARTIN"]
["081","MASON"]
["082","MEADE"]
["083","MENIFEE"]
["084","MERCER"]
["085","METCALFE"]
["086","MONROE"]
["087","MONTGOMERY"]
["088","MORGAN"]
["089","MUHLENBERG"]
["090","NELSON"]
["091","NICHOLAS"]
["092","OHIO"]
["093","OLDHAM"]
["094","OWEN"]
["095","OWSLEY"]
["096","PENDLETON"]
["097","PERRY"]
["098","PIKE"]
["099","POWELL"]
["100","PULASKI"]
["101","ROBERTSON"]
["102","ROCKCASTLE"]
["103","ROWAN"]
["104","RUSSELL"]
["105","SCOTT"]
["106","SHELBY"]
["107","SIMPSON"]
["108","SPENCER"]
["109","TAYLOR"]
["110","TODD"]
["111","TRIGG"]
["112","TRIMBLE"]
["113","UNION"]
["114","WARREN"]
["115","WASHINGTON"]
["116","WAYNE"]
["117","WEBSTER"]
["118","WHITLEY"]
["119","WOLFE"]
["120","WOODFORD"]
["121","VARIOUS"]
["122","OTHER STATE - PICKETT COUNTY, TN"]
["123","OTHER STATE - CLARK COUNTY, IN"]

{"sheet":"Report","index":9,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[18,6,18,8],[46,3,46,6],[29,6,29,8],[30,6,30,8],[31,6,31,8],[32,6,32,8],[45,3,45,6],[32,3,32,5],[45,8,45,9],[46,8,46,9],[33,0,36,9],[37,0,41,9],[42,0,43,9],[44,0,44,9],[19,6,19,8],[20,6,20,8],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[25,6,25,8],[26,6,26,8],[27,6,27,8],[28,6,28,8],[27,3,27,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[31,3,31,5],[30,0,30,2],[31,0,31,2],[32,0,32,2],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[23,3,23,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[12,0,12,9],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[13,0,13,2],[13,3,13,5],[13,6,13,8],[14,6,14,8],[15,6,15,8],[16,6,16,8],[17,6,17,8],[23,0,23,2],[11,0,11,1],[11,2,11,3],[10,2,10,9],[7,2,7,9],[9,2,9,9],[24,0,24,2],[0,0,0,9],[1,0,1,9],[2,0,2,9],[6,2,6,9],[4,7,4,9],[5,2,5,6],[5,8,5,9],[4,3,4,4],[3,0,3,9],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[8,2,8,9]]}
["KENTUCKY TRANSPORTATION CABINET"]
["DIVISION OF MATERIALS"]
["INDEPDENDENT ASSURANCE SAMPLE REPORT"]
[]
["IAS Sample Number:",null,null,"Contract ID:",null,null,"Project:  "]
["Line Item Descr.:",null,null,null,null,null,null,"County:  ",""]
["Type of Work:"]
["Prime Contractor:"]
["Material Descr.:"]
["Producer Name:"]
["Sampled From:"]
["Date Sampled:",null,null,null,"Station:  ",null,"Offset:  ",null,"Lot #:  "]
[""]
["Property",null,null,"IAS Sample",null,null,"Project Acceptance Sample",null,null,"IN/OUT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sampling and Testing of these Independent Assurance Samples have been:  Indepdendently performed by authorized materials personnel who are not responsible for acceptance testing relative to this work."]
[]
[]
[]
["A comparison of the Independent Assurance and the Project Acceptance results from the same material indicates that the results are within the acceptable ranges as specified by Kentucky Method 64-112 Numerical Limits for Comparing Test Results-Independent Assurance Sampling and Testing Program.  Any exceptions to this certification and subsequent follow-up research and corrective actions are noted below."]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"Notes:  \" &IAS!C15)","v":"Notes:  "}]
[]
[]
["CC:  Central Office Materials",null,null,null,null,null,null,null,"2013-05-10T09:09:01"]
["         Section Engineer",null,null,"District Materials Section Supervisor",null,null,null,null,"Date"]

{"sheet":"Sample_Tester","index":10,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["TST_ID","TST_METH","SMPL_ID","SMPL_TST_NBR"]