{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Bridge Sheet","Bridge Data","OtherLists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Bridge Sheet","index":0,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[4,1,4,4],[5,1,5,4]]}
["Pay Item File:","C:\\Workspace\\Workspace-CDOT_V8i\\Standards-Global\\Trnsport_Itemlist.csv"]
[]
[]
[]
[null,"Summary of Quantities"]
[null,"????"]
["Pay Item Code","ITEM NO.","DESCRIPTION","UNIT","HIDE!!","TOTAL",null,"Checker's Totals","% Difference"]
["Keep Hidden - do not delete!",{"$f":"A8","v":"Keep Hidden - do not delete!"},{"$f":"IF($B8=\"\",\"\",VLOOKUP($A8,'Bridge Data'!$A:$C,2,3))","v":{"$error":"#N/A"}},{"$f":"IF($B8=\"\",\"\",VLOOKUP($A8,'Bridge Data'!$A:$C,3,3))","v":{"$error":"#N/A"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"IFERROR((H8-F8)/AVERAGE(F8,H8),\"\")","v":""}]

{"sheet":"Bridge Data","index":1,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Pay Item No.","Description","Unit","Num Items","Location List (Do Not Modify)","Num Locations","Additional Pay Item","Description","Unit"]
[null,null,null,{"$f":"COUNTA(A:A)-1","v":0},null,{"$f":"COUNTA(E:E)-1","v":0},"777-32165","New Pay Item again","F A"]
[null,null,null,null,null,null,"888-12345","To test the sorting","DOL"]
[null,null,null,null,null,null,"999-35623","Another item for custom list","DAY"]
[null,null,null,null,null,null,"999-88909","Leslie Made Up Item","ACRE"]

{"sheet":"OtherLists","index":2,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"UNIT"]
["Pre-Defined Components",null,null,null,null,null,"Alpha",null,null,""]
["ABUT",null,null,null,null,null,"A",null,null,"ACRE"]
["PIER",null,null,null,null,null,"B",null,null,"CF"]
["APP SLAB",null,null,null,null,null,"C",null,null,"CY"]
["SUPER STR",null,null,null,null,null,"D",null,null,"DAY"]
["WALL",null,null,null,null,null,"E",null,null,"DOL"]
[null,null,null,null,null,null,"F",null,null,"EACH"]
[null,null,null,null,null,null,"G",null,null,"F A"]
[null,null,null,null,null,null,"H",null,null,"GAL"]
[null,null,null,null,null,null,"I",null,null,"HOUR"]
[null,null,null,null,null,null,"J",null,null,"L S"]
[null,null,null,null,null,null,"K",null,null,"LB"]
[null,null,null,null,null,null,"L",null,null,"LF"]
[null,null,null,null,null,null,"M",null,null,"LM"]
[null,null,null,null,null,null,"N",null,null,"MFBM"]
[null,null,null,null,null,null,"O",null,null,"MGAL"]
[null,null,null,null,null,null,"P",null,null,"MILE"]
[null,null,null,null,null,null,"Q",null,null,"MKFT"]
[null,null,null,null,null,null,"R",null,null,"MON"]
[null,null,null,null,null,null,"S",null,null,"OZ"]
[null,null,null,null,null,null,"T",null,null,"SF"]
[null,null,null,null,null,null,"U",null,null,"SHML"]
[null,null,null,null,null,null,"V",null,null,"SY"]
[null,null,null,null,null,null,"W",null,null,"T"]
[null,null,null,null,null,null,"X",null,null,"TM"]
[null,null,null,null,null,null,"Y",null,null,"TON"]
[null,null,null,null,null,null,"Z",null,null,"WD"]
[null,null,null,null,null,null,null,null,null,"WK"]
[null,null,null,null,null,null,null,null,null,"YM"]