{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sub_Sum"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"Sub_Sum","index":0,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[68,11,68,14],[69,11,69,14],[70,11,70,14],[71,11,71,14],[62,11,62,14],[63,11,63,14],[64,11,64,14],[65,11,65,14],[66,11,66,14],[67,11,67,14],[61,11,61,14],[50,11,50,14],[51,11,51,14],[52,11,52,14],[53,11,53,14],[54,11,54,14],[55,11,55,14],[56,11,56,14],[57,11,57,14],[58,11,58,14],[59,11,59,14],[60,11,60,14],[49,11,49,14],[38,11,38,14],[39,11,39,14],[40,11,40,14],[41,11,41,14],[42,11,42,14],[43,11,43,14],[44,11,44,14],[45,11,45,14],[46,11,46,14],[47,11,47,14],[48,11,48,14],[21,11,22,14],[21,15,22,15],[20,17,22,18],[37,11,37,14],[26,11,26,14],[27,11,27,14],[28,11,28,14],[29,11,29,14],[30,11,30,14],[31,11,31,14],[32,11,32,14],[33,11,33,14],[34,11,34,14],[35,11,35,14],[36,11,36,14],[15,1,15,4],[15,6,15,14],[21,5,22,5],[25,11,25,14],[19,3,19,4],[20,3,20,4],[23,11,23,14],[24,11,24,14],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,7,22,7],[21,8,22,8],[19,11,20,15],[21,9,22,9],[21,10,22,10]]}
[4,"04 Admin Configuration\\CADD Standards Dev\\Worksets\\000000_JD_Misc\\Projects\\GenSum\\GENSUM.xlsm"]
[null,{"$f":"GetLocalDir(B1)","v":"c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\GenSum.xlsm"}]
[null,{"$f":"formatLocalPathForNamedRange(B2,\"QryItem\")","v":"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'"}]
[null,"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'"]
[]
[]
[]
[]
[null,null,null,"SPREADSHEET","1)","SAVE THIS FILE TO THE PROPER FOLDER FOR YOUR PROJECT AS THE SAME NAME AS YOUR DGN (I.E. #####GS001.XLSX)"]
[null,null,null,"INSTRUCTIONS:","2)","DO NOT ENTER ANY DATA INTO THE ITEM NUMBER, ITEM DESCRIPTION & ITEM UNITS"]
[null,null,null,null,"3)","ENTER ITEM CODE (FOR EXAMPLE: 201E11000) AND ADDITIONAL DESCRIPTION INTO THE BLUE CELLS"]
[null,null,null,null,"4)","ENTER ALL DATA REQUIRED"]
[null,null,null,null,"5)","DO NOT REMOVE THE PROTECTION FROM THIS SPREADSHEET, LEAVE THE PROTECTION ON SO THAT YOU DO NOT DELETE NEEDED FORMULAS OR RESIZE SHEET"]
[null,null,null,null,"6)","DO NOT EDIT Cells A1, B2, B3, or B4. Cell B1 should list the file the item master data being pulled from."]
[]
[null,"ENTER DATA IN THESE COLUMNS ONLY",null,null,null,null,"DO NOT ENTER DATA IN THESE COLUMNS"]
[]
[]
[]
[null,null,null,null,null,null,null,"CALC:",null,"DATE:",null,"SUBSUMMARY"]
[null,"Page #",null,null,null,null,null,"CHECKED:",null,"DATE:",null,null,null,null,null,null,null,"SUPPLEMENTAL INFO"]
[null,null,"ITEM_CODE","ADDITIONAL_DESCRIPTION","Qty","See Sheet",null,"ITEM","EXTENSION","TOTAL","UNIT","DESCRIPTION",null,null,null,"SEE SHEET"]
[null,"Split #"]
[null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(C24)=0,TRIM(C24)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(C24)=0,TRIM(C24)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),8)),\"\")=\"True\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),11)),\"\")&IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),13)),\"\"),IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),13)),\"\")))","v":""},{"$f":"IF(OR(TRIM(C24)=0,TRIM(C24)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),3)),\"\")=\"LS\",\"LS\",IF((E24)=0,\"\",E24)))","v":""},{"$f":"IF(OR(TRIM(C24)=0,TRIM(C24)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),2)),\"\")))","v":""},{"$f":"IF(OR(TRIM(C24)=0,TRIM(C24)=\"\"),IF(D24=\"\",\"\",D24),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),3)),\"123456789012\"))-9))&D24,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),3))&D24,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},null,null,null,{"$f":"IF(F24=\"\",\"\",F24)","v":""},null,{"$f":"IF(OR(TRIM(C24)=0,TRIM(C24)=\"\"),\"\",IFERROR(IF(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),5)=\"True\",\"(Required) \",IF(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),6)=\"True\",\"(Optional) \",\"\"))&TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),4)),\"\"))","v":""},null,{"$f":"IF(OR(TRIM(C24)=0,TRIM(C24)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),5)),\"\"))","v":""},{"$f":"IF(OR(TRIM(C24)=0,TRIM(C24)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),6)),\"\"))","v":""},{"$f":"IF(OR(TRIM(C24)=0,TRIM(C24)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C24),ITEM,0),7)),\"\"))","v":""}]
[null,null,null,null,null,null,null,"","","","","",null,null,null,{"$f":"IF(F25=\"\",\"\",F25)","v":""},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,"","",""]
[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,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,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,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,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,"",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,"","",""]
[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,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,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,{"$f":"IF(OR(TRIM(C56)=0,TRIM(C56)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(C56)=0,TRIM(C56)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),8)),\"\")=\"True\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),11)),\"\")&IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),13)),\"\"),IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),13)),\"\")))","v":""},{"$f":"IF(OR(TRIM(C56)=0,TRIM(C56)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),3)),\"\")=\"LS\",\"LS\",IF((E56)=0,\"\",E56)))","v":""},{"$f":"IF(OR(TRIM(C56)=0,TRIM(C56)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),2)),\"\")))","v":""},{"$f":"IF(OR(TRIM(C56)=0,TRIM(C56)=\"\"),IF(D56=\"\",\"\",D56),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),3)),\"123456789012\"))-9))&D56,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),3))&D56,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},null,null,null,"",null,{"$f":"IF(OR(TRIM(C56)=0,TRIM(C56)=\"\"),\"\",IFERROR(IF(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),5)=\"True\",\"(Required) \",IF(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),6)=\"True\",\"(Optional) \",\"\"))&TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),4)),\"\"))","v":""},null,{"$f":"IF(OR(TRIM(C56)=0,TRIM(C56)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),5)),\"\"))","v":""},{"$f":"IF(OR(TRIM(C56)=0,TRIM(C56)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),6)),\"\"))","v":""},{"$f":"IF(OR(TRIM(C56)=0,TRIM(C56)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(C56),ITEM,0),7)),\"\"))","v":""}]
[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,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,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,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,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,"",null,"",null,"","",""]