{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","RX","testers","Revisions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":121,"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":"Summary","index":0,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":false,"merged":[[60,7,60,12],[61,7,61,12],[62,1,62,3],[10,7,10,9],[14,7,14,9],[28,1,28,9],[11,7,11,9],[18,5,18,6],[67,1,67,3],[66,4,66,5],[67,4,67,5],[46,1,46,3],[46,5,46,7],[34,1,34,9],[62,5,62,6],[62,7,62,9],[63,1,63,3],[63,5,63,6],[63,7,63,9],[57,1,58,9],[46,8,46,9],[61,2,61,5],[60,2,60,5],[50,1,50,2],[35,1,35,9],[7,7,7,9],[52,1,52,4],[45,1,45,3],[40,8,40,9],[41,8,41,9],[49,8,49,9],[50,8,50,9],[47,1,47,3],[51,8,51,9],[49,1,49,2],[14,5,14,6],[33,1,33,2],[36,1,36,9],[31,1,31,2],[29,1,29,9],[32,1,32,2],[31,3,31,9],[30,1,30,9],[45,8,45,9],[45,5,45,7],[37,1,37,9],[39,1,39,5],[38,1,38,5],[3,1,3,9],[9,5,9,6],[9,7,9,9],[26,1,26,4],[25,5,25,9],[26,5,26,9],[21,5,21,6],[18,7,18,9],[14,2,14,4],[19,2,19,4],[21,2,21,4],[19,7,19,9],[23,1,23,9],[22,2,22,4],[5,5,5,6],[5,7,5,9],[6,2,6,4],[10,2,10,4],[10,5,10,6],[6,5,6,6],[6,7,6,9],[5,2,5,4],[7,2,7,4],[11,2,11,4],[38,6,38,9],[39,6,39,9],[51,1,51,2],[50,4,50,7],[49,4,49,7],[51,4,51,7],[43,1,43,9],[44,1,44,9],[40,1,40,4],[41,1,41,4],[8,2,8,4],[8,5,8,6],[8,7,8,9],[7,5,7,6],[9,2,9,4],[20,7,20,9],[17,1,17,9],[12,2,12,9],[13,2,13,9],[18,2,18,4],[11,5,11,6],[16,8,16,9],[19,5,19,6],[20,5,20,6],[27,1,27,9],[25,1,25,4],[22,5,22,9],[24,1,24,9],[20,2,20,4],[21,7,21,9],[32,4,32,5],[33,4,33,5],[32,6,32,9],[33,6,33,9]]}
[null,"TxDOT Manuals >"]
[null,"                                                TEXAS DEPARTMENT OF TRANSPORTATION"]
[]
[null,"RIDE QUALITY ANALYSIS",null,null,null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,null,null,{"$f":"\"RIDE QUALITY ANALYSIS :: File Version: \" & TEXT(MID(sn,SEARCH(\"::\",sn,1)+2,20),\"mm/dd/yy hh:mm:ss\")","v":"RIDE QUALITY ANALYSIS :: File Version: 08/22/18 11:56:37"},null,1]
[null,"SAMPLE ID:",null,null,null,"SAMPLED DATE:",null,null,null,null,null,"tx1001.xlsm::43334.49765"]
[null,"LOT NUMBER:",null,null,null,"LETTING DATE:"]
[null,"SAMPLE STATUS:",null,null,null,"CONTROLLING CSJ:"]
[null,"COUNTY:",null,null,null,"SPEC YEAR:"]
[null,"SAMPLED BY:",null,null,null,"SPEC ITEM:"]
[null,"SAMPLE LOCATION:",null,null,null,"SPECIAL PROVISION:"]
[null,"MATERIAL CODE:",null,null,null,"MIX TYPE:"]
[null,"MATERIAL NAME:"]
[null,"PRODUCER:"]
[null,"AREA ENGINEER:",null,null,null,"PROJECT MANAGER:"]
[]
[null,null,"COURSE\\LIFT:",null,"STATION:",null,null,"DIST. FROM CL:"]
[]
[null,"DISTRICT:",null,null,null,"HIGHWAY:"]
[null,"AREA OFFICE:",null,null,null,"BEGINNING RM:"]
[null,"TESTED BY:",null,null,null,"BEGINNING STATION:"]
[null,"BUSINESS NAME:",null,null,null,"LANE DESIGNATION:"]
[null,"PAY SCHEDULE:"]
[]
[]
[null,"AVERAGE PRE-CONSTRUCTION IRI (IF AVAILABLE):"]
[null,"PROJECT DESCRIPTION:"]
[]
[]
[null,"DATA FILE INFORMATION"]
[]
[null,"RQ SOFTWARE RELEASE:"]
[null,"REPORT RUN ON:"]
[null,"INPUT DATA FILE COLLECTED:"]
[]
[]
[null,"PROCESSING PARAMETERS"]
[]
[null,"LOCALIZED ROUGHNESS PENALTY PER OCCURRENCE:"]
[null,"LOCALIZED ROUGHNESS TAGGED IF GREATER OF EQUAL TO:"]
[null,"BONUS PAID FOR AVERAGE IRI",null,null,null,"FROM:",null,"TO"]
[null,"PENALTY ASSESSED FOR AVERAGE IRI",null,null,null,"FROM:",null,"TO"]
[]
[null,"SUMMARY"]
[]
[null,"TOTAL LENGTH MILES:",null,null,null,"LENGTH (STATION UNITS):"]
[null,"LOCALIZED ROUGHNESS DETECTED:",null,null,null,"LOCALIZED ROUGHNESS PENALTY:"]
[null,"LOCALIZED ROUGHNESS PER LANEMILE:"]
[]
[null,"AVERAGE LEFT IRI:",null,null,"TOTAL IRI ADJUSTMENTS:"]
[null,"AVERAGE RIGHT IRI:",null,null,"TOTAL LOC. ROUGHNESS ADJUSTMENTS:"]
[null,"AVERAGE IRI:",null,null,"TOTAL ADJUSTMENTS:"]
[null,"IRI PERCENT DIFFERENCE FROM PRE-CONSTRUCTION",null,null,null,{"$f":"IF(F26=\"\",\"\",(F26-D52)/F26*100)","v":""}]
[]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2018-08-22T11:56:37.730"}]
[]
[]
[]
[null,"Test Method:","Tested By:",null,null,null,"Tested Date:","Tested By and Profiler Type:"]
[null,"TX1001"]
[null,"Test Stamp Code:",null,null,"Omit Test:","Completed Date:",null,"Reviewed By:"]
[]
[null,"Locked By:","TxDOT:","District:","Area:"]
[]
[null,"Authorized By:",null,null,"Authorized Date:"]

{"sheet":"RX","index":1,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[41]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF(Summary!$B$58=\"\",\"\",Summary!$B$58)","v":""},{"$f":"Summary!$B$57","v":"Remarks:"}]
[2,{"$f":"IF(Summary!$D$17=\"\",\"\",Summary!$D$17)","v":""},{"$f":"IF(Summary!$C$17=\"\",\"\",Summary!$C$17)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF(Summary!$C$62=\"\",\"\",Summary!$C$62)","v":""},"Tested By ",{"$f":"IF(Summary!$B$62=\"\",\"\",Summary!$B$62)","v":"TX1001"}]
[4,{"$f":"IF(Summary!$G$62=\"\",\"\",Summary!$G$62)","v":""},"Tested Date ",{"$f":"IF(Summary!$B$62=\"\",\"\",Summary!$B$62)","v":"TX1001"}]
[5,{"$f":"IF(Summary!$C$19=\"\",\"\",Summary!$C$19)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$19=\"\",\"\",Summary!$B$19)","v":"DISTRICT:"}]
[6,{"$f":"IF(Summary!$C$20=\"\",\"\",Summary!$C$20)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$20=\"\",\"\",Summary!$B$20)","v":"AREA OFFICE:"}]
[7,{"$f":"IF(Summary!$C$21=\"\",\"\",Summary!$C$21)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$21=\"\",\"\",Summary!$B$21)","v":"TESTED BY:"}]
[8,{"$f":"IF(Summary!$C$22=\"\",\"\",Summary!$C$22)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$22=\"\",\"\",Summary!$B$22)","v":"BUSINESS NAME:"}]
[9,{"$f":"IF(Summary!$C$23=\"\",\"\",Summary!$C$23)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$23=\"\",\"\",Summary!$B$23)","v":"PAY SCHEDULE:"}]
[10,{"$f":"IF(Summary!$H$19=\"\",\"\",Summary!$H$19)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$F$19=\"\",\"\",Summary!$F$19)","v":"HIGHWAY:"}]
[11,{"$f":"IF(Summary!$H$20=\"\",\"\",Summary!$H$20)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$F$20=\"\",\"\",Summary!$F$20)","v":"BEGINNING RM:"}]
[12,{"$f":"IF(Summary!$H$21=\"\",\"\",Summary!$H$21)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$F$21=\"\",\"\",Summary!$F$21)","v":"BEGINNING STATION:"}]
[13,{"$f":"IF(Summary!$H$22=\"\",\"\",Summary!$H$22)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$F$22=\"\",\"\",Summary!$F$22)","v":"LANE DESIGNATION:"}]
[14,{"$f":"IF(Summary!$F$26=\"\",\"\",Summary!$F$26)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$26=\"\",\"\",Summary!$B$26)","v":"AVERAGE PRE-CONSTRUCTION IRI (IF AVAILABLE):"}]
[15,{"$f":"IF(Summary!$F$27=\"\",\"\",Summary!$F$27)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$27=\"\",\"\",Summary!$B$27)","v":"PROJECT DESCRIPTION:"}]
[16,{"$f":"IF(Summary!$D$32=\"\",\"\",Summary!$D$32)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$30=\"\",\"\", Summary!$B$30)","v":"DATA FILE INFORMATION"},{"$f":"IF(Summary!$B$32=\"\",\"\",Summary!$B$32)","v":"RQ SOFTWARE RELEASE:"}]
[17,{"$f":"IF(Summary!$D$33=\"\",\"\",Summary!$D$33)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$30=\"\",\"\", Summary!$B$30)","v":"DATA FILE INFORMATION"},{"$f":"IF(Summary!$B$33=\"\",\"\",Summary!$B$33)","v":"REPORT RUN ON:"}]
[18,{"$f":"IF(Summary!$E$33=\"\",\"\",Summary!$E$33)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$30=\"\",\"\", Summary!$B$30)","v":"DATA FILE INFORMATION"},{"$f":"IF(Summary!$B$27=\"\",\"\",Summary!$B$27)","v":"PROJECT DESCRIPTION:"}]
[19,{"$f":"IF(Summary!$G$33=\"\",\"\",Summary!$G$33)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$30=\"\",\"\", Summary!$B$30)","v":"DATA FILE INFORMATION"},{"$f":"IF(Summary!$F$22=\"\",\"\",Summary!$F$22)","v":"LANE DESIGNATION:"}]
[20,{"$f":"IF(Summary!$D$34=\"\",\"\",Summary!$D$34)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$30=\"\",\"\", Summary!$B$30)","v":"DATA FILE INFORMATION"},{"$f":"IF(Summary!$B$34=\"\",\"\",Summary!$B$34)","v":"INPUT DATA FILE COLLECTED:"}]
[21,{"$f":"IF(Summary!$E$34=\"\",\"\",Summary!$E$34)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$30=\"\",\"\", Summary!$B$30)","v":"DATA FILE INFORMATION"},{"$f":"IF(Summary!$B$27=\"\",\"\",Summary!$B$27)","v":"PROJECT DESCRIPTION:"}]
[22,{"$f":"IF(Summary!$G$34=\"\",\"\",Summary!$G$34)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$30=\"\",\"\", Summary!$B$30)","v":"DATA FILE INFORMATION"},{"$f":"IF(Summary!$F$22=\"\",\"\",Summary!$F$22)","v":"LANE DESIGNATION:"}]
[23,{"$f":"IF(Summary!$G$39=\"\",\"\",Summary!$G$39)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$37=\"\",\"\", Summary!$B$37)","v":"PROCESSING PARAMETERS"},{"$f":"IF(Summary!$B$39=\"\",\"\",Summary!$B$39)","v":"LOCALIZED ROUGHNESS PENALTY PER OCCURRENCE:"}]
[24,{"$f":"IF(Summary!$G$40=\"\",\"\",Summary!$G$40)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$37=\"\",\"\", Summary!$B$37)","v":"PROCESSING PARAMETERS"},{"$f":"IF(Summary!$B$40=\"\",\"\",Summary!$B$40)","v":"LOCALIZED ROUGHNESS TAGGED IF GREATER OF EQUAL TO:"}]
[25,{"$f":"IF(Summary!$G$41=\"\",\"\",Summary!$G$41)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$41=\"\",\"\",Summary!$B$41)","v":"BONUS PAID FOR AVERAGE IRI"},{"$f":"IF(Summary!$F$41=\"\",\"\",Summary!$F$41)","v":"FROM:"}]
[26,{"$f":"IF(Summary!$I$41=\"\",\"\",Summary!$I$41)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$41=\"\",\"\",Summary!$B$41)","v":"BONUS PAID FOR AVERAGE IRI"},{"$f":"IF(Summary!$H$41=\"\",\"\",Summary!$H$41)","v":"TO"}]
[27,{"$f":"IF(Summary!$G$42=\"\",\"\",Summary!$G$42)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$42=\"\",\"\",Summary!$B$42)","v":"PENALTY ASSESSED FOR AVERAGE IRI"},{"$f":"IF(Summary!$F$42=\"\",\"\",Summary!$F$42)","v":"FROM:"}]
[28,{"$f":"IF(Summary!$I$42=\"\",\"\",Summary!$I$42)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF(Summary!$B$42=\"\",\"\",Summary!$B$42)","v":"PENALTY ASSESSED FOR AVERAGE IRI"},{"$f":"IF(Summary!$H$42=\"\",\"\",Summary!$H$42)","v":"TO"}]
[29,{"$f":"IF(Summary!$E$46=\"\",\"\",Summary!$E$46)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$B$46=\"\",\"\",Summary!$B$46)","v":"TOTAL LENGTH MILES:"}]
[30,{"$f":"IF(Summary!$E$47=\"\",\"\",Summary!$E$47)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$B$47=\"\",\"\",Summary!$B$47)","v":"LOCALIZED ROUGHNESS DETECTED:"}]
[31,{"$f":"IF(Summary!$E$48=\"\",\"\",Summary!$E$48)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$B$48=\"\",\"\",Summary!$B$48)","v":"LOCALIZED ROUGHNESS PER LANEMILE:"}]
[32,{"$f":"IF(Summary!$I$46=\"\",\"\",Summary!$I$46)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$F$46=\"\",\"\",Summary!$F$46)","v":"LENGTH (STATION UNITS):"}]
[33,{"$f":"IF(Summary!$I$47=\"\",\"\",Summary!$I$47)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$F$47=\"\",\"\",Summary!$F$47)","v":"LOCALIZED ROUGHNESS PENALTY:"}]
[34,{"$f":"IF(Summary!$D$50=\"\",\"\",Summary!$D$50)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$B$50=\"\",\"\",Summary!$B$50)","v":"AVERAGE LEFT IRI:"}]
[35,{"$f":"IF(Summary!$D$51=\"\",\"\",Summary!$D$51)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$B$51=\"\",\"\",Summary!$B$51)","v":"AVERAGE RIGHT IRI:"}]
[36,{"$f":"IF(Summary!$D$52=\"\",\"\",Summary!$D$52)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$B$52=\"\",\"\",Summary!$B$52)","v":"AVERAGE IRI:"}]
[37,{"$f":"IF(Summary!$I$50=\"\",\"\",Summary!$I$50)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$E$50=\"\",\"\",Summary!$E$50)","v":"TOTAL IRI ADJUSTMENTS:"}]
[38,{"$f":"IF(Summary!$I$51=\"\",\"\",Summary!$I$51)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$E$51=\"\",\"\",Summary!$E$51)","v":"TOTAL LOC. ROUGHNESS ADJUSTMENTS:"}]
[39,{"$f":"IF(Summary!$I$52=\"\",\"\",Summary!$I$52)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$E$52=\"\",\"\",Summary!$E$52)","v":"TOTAL ADJUSTMENTS:"}]
[40,{"$f":"IF(Summary!$F$53=\"\",\"\",Summary!$F$53)","v":""},{"$f":"IF(Summary!$B$4=\"\",\"\",Summary!$B$4)","v":"RIDE QUALITY ANALYSIS"},{"$f":"IF( Summary!$B$44=\"\",\"\", Summary!$B$44)","v":"SUMMARY"},{"$f":"IF(Summary!$B$53=\"\",\"\",Summary!$B$53)","v":"IRI PERCENT DIFFERENCE FROM PRE-CONSTRUCTION"}]
[41,{"$f":"IF(Summary!$H$62=\"\",\"\",Summary!$H$62)","v":""},"Tested By and Profiler",{"$f":"IF($B$62=\"\",\"\",$B$62)","v":""}]

{"sheet":"testers","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,"TX1001","TEST STAMP CODES"]
[null,null,"SC01:Meets Specification"]
[null,null,"SC02:Meets Specification Except as Noted"]
[null,null,"SC05:Does Not Meet Specification"]
[null,null,"SC08:For Information Only"]

{"sheet":"Revisions","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[null,"2009-12-10","VB - changed the GetOpenFIleName method to include the CSV description.","Stewart"]
[null,"2018-08-20","Change VB because of import file change","SD"]