{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SIGNING"],"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":"SIGNING","index":0,"n_rows":84,"n_cols":33,"rows_kept":84,"cut":false,"hidden":false,"merged":[[23,5,23,6],[43,5,43,6],[27,5,27,6],[26,5,26,6],[25,5,25,6],[24,5,24,6],[38,5,38,6],[7,3,7,10],[8,3,8,10],[6,3,6,29],[83,3,83,10],[36,5,36,6],[35,5,35,6],[34,5,34,6],[33,5,33,6],[32,5,32,6],[31,5,31,6],[30,5,30,6],[29,5,29,6],[28,5,28,6],[45,5,45,6],[44,5,44,6],[60,5,60,6],[59,5,59,6],[37,5,37,6],[54,5,54,6],[53,5,53,6],[52,5,52,6],[51,5,51,6],[50,5,50,6],[49,5,49,6],[48,5,48,6],[47,5,47,6],[46,5,46,6],[42,5,42,6],[41,5,41,6],[40,5,40,6],[39,5,39,6],[10,25,21,25],[10,24,21,24],[10,18,21,18],[10,19,21,19],[81,5,81,6],[80,5,80,6],[79,5,79,6],[78,5,78,6],[77,5,77,6],[58,5,58,6],[57,5,57,6],[56,5,56,6],[55,5,55,6],[72,5,72,6],[71,5,71,6],[70,5,70,6],[9,5,22,6],[10,21,21,21],[10,22,21,22],[76,5,76,6],[75,5,75,6],[74,5,74,6],[73,5,73,6],[69,5,69,6],[68,5,68,6],[67,5,67,6],[66,5,66,6],[65,5,65,6],[64,5,64,6],[63,5,63,6],[62,5,62,6],[61,5,61,6],[10,17,21,17],[9,10,22,10],[9,9,22,9],[9,8,22,8],[9,7,22,7],[82,5,82,6],[9,1,22,1],[10,29,21,29],[10,11,21,11],[10,12,21,12],[9,4,22,4],[10,13,21,13],[10,20,21,20],[10,26,21,26],[10,27,21,27],[10,28,21,28],[10,23,21,23],[9,3,22,3],[10,14,21,14],[10,15,21,15],[10,16,21,16]]}
[1,"04 Admin Configuration\\CADD Standards Dev\\Worksets\\000000_JD_Misc\\Projects\\GenSum\\GENSUM.xlsm",null,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,{"$f":"GetLocalDir(B1)","v":"c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\GenSum.xlsm"},null,null,null,null,"INSTRUCTIONS:","2)","DO NOT ENTER ANY DATA INTO THE ITEM NUMBER, ITEM DESCRIPTION & ITEM UNITS"]
[null,{"$f":"formatLocalPathForNamedRange(B2,\"QryItem\")","v":"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'"},null,null,null,null,null,"3)","ENTER ITEM CODE (FOR EXAMPLE: 201E11000) AND ADDITIONAL DESCRIPTION INTO THE BLUE CELLS"]
[null,"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'",null,null,null,null,null,"4)","ENTER ALL DATA REQUIRED, PAGE # AND SPLIT # MUST BE FILLED OUT."]
[null,null,null,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,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,"Page #",null,{"$f":"\"SUBSUMMARY SHEET \" & B8","v":"SUBSUMMARY SHEET "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"<--- ENTER STARTING SHEET NUMBER"]
[null,null,null,"ITEM_CODE"]
[null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,"Split #",null,"REF\nNO.","SHEET\nNO.","LOCATION",null,"STATION","SIDE","CODE","SIZE\n(INCHES)",{"$f":"IF(OR(TRIM(L8)=0,TRIM(L8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L8),ITEM,0),11)),\"\")))","v":""},"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(L8)=0,TRIM(L8)=\"\"),IF(L9=\"\",\"\",L9),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L8),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L8),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L8),ITEM,0),3)),\"123456789012\"))-9))&L9,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L8),ITEM,0),3))&L9,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(L8)=0,TRIM(L8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L8),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L8),ITEM,0),2)),\"\")))","v":""},"","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTALS CARRIED TO GENERAL SUMMARY  ",null,null,null,null,null,null,null,{"$f":"IF(L8=\"\",\"\",IF(OR(L23=\"\", L23=\"LS\", L23=\"LUMP\"),IF(SUM(COUNTIF(L24:L83,\"LS\")+COUNTIF(L24:L83,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(L24:L83)>0,ROUNDUP(SUM(L24:L83),0),\"\")))","v":""},{"$f":"IF(M8=\"\",\"\",IF(OR(M23=\"\", M23=\"LS\", M23=\"LUMP\"),IF(SUM(COUNTIF(M24:M83,\"LS\")+COUNTIF(M24:M83,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(M24:M83)>0,ROUNDUP(SUM(M24:M83),0),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]