{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Audit","QueryResults","Remarks","Cert_Query","ItemsWithoutS&TR_Query","Concrete","Agg_DrySieve","Agg_K200&T27","Agg_T11&T27","Agg_T11","Agg_KY-200","Asphalt_MixPack","Certifications","Geotech_Density","ItemsWithoutS&TR","Admins"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":16,"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":"Audit","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,11]]}
[null,"Division of Materials Audit Program - Version 2.9 (04/20/2022)"]
[null,"1.  Type Contract ID and Press ENTER:",null,null,null,"2.  Select Audit(s) to Perform:",null,null,null,"3.  Show Sample Status(es):"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"4.  Run Audit Program:"]

{"sheet":"QueryResults","index":1,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["CONT_ID","SMPL_ID","AUTH_DT","STAT_T","MATL_CD","TST_METH","SMPL_TST_NBR","TST_FLD_SN","TST_STRG_FLD_VAL","TST_NUMRC_FLD_VAL","RMRKS_ID","ESALS_NBR","ACTL_DT","Column1"]

{"sheet":"Remarks","index":2,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["RMRKS_ID","RMRKS_T","RMRKS_SN","RMRKS_TXT_FLD"]

{"sheet":"Cert_Query","index":3,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["CONT_ID","PRJ_NBR","LN_ITM_NBR","ITM_CD","LAST_CHNG_YR","BID_QTY","NET_C_O_QTY","QTY_INSTL_TO_DT","ITM_MSTR_SHRT_DESC","MATL_CD","MATL_FULL_NM","CONV_FACT","CONT_STREQ_ACPTMTH","SMPL_FRQ_RTE","SMPL_FRQ","UNT_T"]

{"sheet":"ItemsWithoutS&TR_Query","index":4,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["CONT_ID","PRJ_NBR","LN_ITM_NBR","ITM_CD","LAST_CHNG_YR","ITM_MSTR_SHRT_DESC","QTY_PD_TO_DT","QTY_INSTL_TO_DT","UNT_T","MATL_CD","MATL_FULL_NM","CONV_FACT","TST_METH","SMPL_FRQ_RTE","CONT_STREQ_SMPL_T","CONT_STREQ_ACPTMTH"]

{"sheet":"Concrete","index":5,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Sample ID","Material","Auth. Date","Sample Status","Test No.","Strength Status","Cylinder Age","Cylinder Strength","Plastic Status","Slump","Air","Temp.","OK?","Remarks"]

{"sheet":"Agg_DrySieve","index":6,"n_rows":2,"n_cols":22,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Sample ID","Material","Auth. Date","Sample Status","Test No.","Template Status","2-1/2\"","2\"","1-1/2\"","1\"","3/4\"","1/2\"","3/8\"","#4","#8","#16","#50","#100","Beg. Mass","Grad. Loss","OK?","Remarks"]

{"sheet":"Agg_K200&T27","index":7,"n_rows":2,"n_cols":19,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Sample ID","Material","Auth. Date","Sample Status","Test No.","Template Status","% Out","Dry Beg Mass","2-1/2\"","1-1/2\"","1\"","3/4\"","3/8\"","#4","#30","#200","Dry Grad Loss","OK?","Remarks"]

{"sheet":"Agg_T11&T27","index":8,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Sample ID","Material","Auth. Date","Sample Status","Test No.","Template Status","Dry Mass","2-1/2\"","1-1/2\"","1\"","3/4\"","3/8\"","#4","#30","#200","OK?","Remarks"]

{"sheet":"Agg_T11","index":9,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Sample ID","Material","Auth. Date","Sample Status","Test No.","Template Status","Dry Mass","Finer Than\n#200","OK?","Remarks"]

{"sheet":"Agg_KY-200","index":10,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Sample ID","Material","Auth. Date","Sample Status","Test No.","Template Status","Finer Than\n#200","OK?","Remarks"]

{"sheet":"Asphalt_MixPack","index":11,"n_rows":2,"n_cols":35,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Sample ID","Material","Auth. Date","Sample Status","Test No.","Template Status","2\"","1-1/2\"","1\"","3/4\"","1/2\"","3/8\"","#4","#8","#200","FAA","F&E","SE","%VFA","%VMA","D/A","%Gmm @ Nini","%Gmm @ Nmax","%AV","UW","%AC","MSG","%TSR w/o Add.","%TSR w/ Add.","1-Pt. Req'd","1-Pt. UW","1-Pt. %AV","1-Pt. MSG","1-Pt. VMA","Remarks"]

{"sheet":"Certifications","index":12,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Project Number","Line Item","Item Code","Item Description","Bid + CO Quantity","Installed Quantity","Unit","Material Code","Material Description","Frequency","# CERT's Required","CERT Location",""]

{"sheet":"Geotech_Density","index":13,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Sample ID","Material","Auth. Date","Sample Status","Test No.","Template Status","Sublot Number","Wet Density","% Moisture","Optimum Moisture","% Compaction","Remarks"]

{"sheet":"ItemsWithoutS&TR","index":14,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract ID:",{"$f":"Audit!C3","v":0}]
["Project Number","Line Item","Item Code","Item Description","Paid Quantity","Installed Quantity","Item Unit","Problem"]

{"sheet":"Admins","index":15,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["mark.higdon",{"$f":"COUNTA(A:A)","v":3}]
["adam.franklin"]
["david.rice"]