{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blank"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"Blank","index":0,"n_rows":321,"n_cols":34,"rows_kept":321,"cut":false,"hidden":false,"merged":[[164,3,164,30],[165,3,165,9],[166,3,166,9],[167,3,180,3],[167,4,180,4],[167,5,180,9],[168,10,179,10],[168,11,179,11],[168,12,179,12],[168,13,179,13],[168,20,179,20],[168,21,179,21],[168,14,179,14],[168,15,179,15],[168,16,179,16],[168,17,179,17],[168,18,179,18],[168,19,179,19],[162,3,162,9],[89,24,100,24],[89,25,100,25],[89,26,100,26],[89,27,100,27],[89,20,100,20],[89,21,100,21],[89,10,100,10],[89,11,100,11],[89,12,100,12],[89,13,100,13],[89,14,100,14],[89,15,100,15],[89,22,100,22],[89,23,100,23],[89,16,100,16],[89,17,100,17],[89,18,100,18],[89,19,100,19],[6,3,6,30],[10,26,21,26],[10,25,21,25],[10,27,21,27],[10,28,21,28],[10,29,21,29],[10,24,21,24],[9,3,22,3],[7,3,7,9],[8,3,8,9],[10,15,21,15],[10,16,21,16],[10,17,21,17],[10,18,21,18],[85,3,85,30],[86,3,86,9],[87,3,87,9],[88,3,101,3],[10,22,21,22],[10,23,21,23],[10,19,21,19],[10,20,21,20],[83,3,83,9],[10,30,21,30],[10,10,21,10],[10,11,21,11],[10,12,21,12],[10,13,21,13],[9,4,22,4],[9,5,22,9],[10,14,21,14],[10,21,21,21],[88,4,101,4],[88,5,101,9],[89,28,100,28],[89,29,100,29],[89,30,100,30],[247,13,258,13],[245,3,245,9],[246,3,259,3],[246,4,259,4],[246,5,259,9],[168,30,179,30],[241,3,241,9],[243,3,243,30],[244,3,244,9],[168,26,179,26],[168,27,179,27],[168,28,179,28],[168,29,179,29],[168,22,179,22],[168,23,179,23],[168,24,179,24],[168,25,179,25],[247,30,258,30],[9,1,22,1],[88,1,101,1],[167,1,180,1],[246,1,259,1],[320,3,320,9],[247,26,258,26],[247,27,258,27],[247,28,258,28],[247,29,258,29],[247,22,258,22],[247,23,258,23],[247,24,258,24],[247,25,258,25],[247,18,258,18],[247,19,258,19],[247,20,258,20],[247,21,258,21],[247,14,258,14],[247,15,258,15],[247,16,258,16],[247,17,258,17],[247,10,258,10],[247,11,258,11],[247,12,258,12]]}
[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)","ENTER ITEM CODE (FOR EXAMPLE: 201E11000) AND ADDITIONAL DESCRIPTION INTO THE BLUE CELLS"]
[null,{"$f":"formatLocalPathForNamedRange(B2,\"QryItem\")","v":"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'"},null,null,null,null,null,"3)","ENTER ALL DATA REQUIRED, PAGE # AND SPLIT # MUST BE FILLED OUT."]
[null,"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'",null,null,null,null,null,"4)","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,"5)","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":"AG7","v":1},null,null,null,null,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       NO.","SHEET NO.","STATION TO STATION",null,null,null,null,{"$f":"IF(OR(TRIM(K8)=0,TRIM(K8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K8),ITEM,0),11)),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K8)=0,TRIM(K8)=\"\"),IF(K9=\"\",\"\",K9),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K8),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K8),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K8),ITEM,0),3)),\"123456789012\"))-9))&K9,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K8),ITEM,0),3))&K9,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K8)=0,TRIM(K8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K8),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K8),ITEM,0),2)),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,"TO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTALS CARRIED TO GENERAL SUMMARY  ",null,null,null,null,null,null,{"$f":"IF(K8=\"\",\"\",IF(K23=\"\",IF(SUM(COUNTIF(K24:K83,\"LS\")+COUNTIF(K24:K83,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(K24:K83)>0,ROUNDUP(SUM(K24:K83),0),\"\")))","v":""},{"$f":"IF(L8=\"\",\"\",IF(L23=\"\",IF(SUM(COUNTIF(L24:L83,\"LS\")+COUNTIF(L24:L83,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(L24:L83)>0,ROUNDUP(SUM(L24:L83),0),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"D7+1","v":2}]
[null,null,null,"ITEM_CODE"]
[null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,"Split #",null,"REF       NO.","SHEET NO.","STATION TO STATION",null,null,null,null,{"$f":"IF(OR(TRIM(K87)=0,TRIM(K87)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K87),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K87),ITEM,0),11)),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K87)=0,TRIM(K87)=\"\"),IF(K88=\"\",\"\",K88),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K87),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K87),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K87),ITEM,0),3)),\"123456789012\"))-9))&K88,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K87),ITEM,0),3))&K88,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K87)=0,TRIM(K87)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K87),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K87),ITEM,0),2)),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,"TO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTALS CARRIED TO GENERAL SUMMARY  ",null,null,null,null,null,null,{"$f":"IF(K87=\"\",\"\",IF(K102=\"\",IF(SUM(COUNTIF(K103:K162,\"LS\")+COUNTIF(K103:K162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(K103:K162)>0,ROUNDUP(SUM(K103:K162),0),\"\")))","v":""},{"$f":"IF(L87=\"\",\"\",IF(L102=\"\",IF(SUM(COUNTIF(L103:L162,\"LS\")+COUNTIF(L103:L162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(L103:L162)>0,ROUNDUP(SUM(L103:L162),0),\"\")))","v":""},{"$f":"IF(M87=\"\",\"\",IF(M102=\"\",IF(SUM(COUNTIF(M103:M162,\"LS\")+COUNTIF(M103:M162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(M103:M162)>0,ROUNDUP(SUM(M103:M162),0),\"\")))","v":""},{"$f":"IF(N87=\"\",\"\",IF(N102=\"\",IF(SUM(COUNTIF(N103:N162,\"LS\")+COUNTIF(N103:N162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(N103:N162)>0,ROUNDUP(SUM(N103:N162),0),\"\")))","v":""},{"$f":"IF(O87=\"\",\"\",IF(O102=\"\",IF(SUM(COUNTIF(O103:O162,\"LS\")+COUNTIF(O103:O162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(O103:O162)>0,ROUNDUP(SUM(O103:O162),0),\"\")))","v":""},{"$f":"IF(P87=\"\",\"\",IF(P102=\"\",IF(SUM(COUNTIF(P103:P162,\"LS\")+COUNTIF(P103:P162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(P103:P162)>0,ROUNDUP(SUM(P103:P162),0),\"\")))","v":""},{"$f":"IF(Q87=\"\",\"\",IF(Q102=\"\",IF(SUM(COUNTIF(Q103:Q162,\"LS\")+COUNTIF(Q103:Q162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(Q103:Q162)>0,ROUNDUP(SUM(Q103:Q162),0),\"\")))","v":""},{"$f":"IF(R87=\"\",\"\",IF(R102=\"\",IF(SUM(COUNTIF(R103:R162,\"LS\")+COUNTIF(R103:R162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(R103:R162)>0,ROUNDUP(SUM(R103:R162),0),\"\")))","v":""},{"$f":"IF(S87=\"\",\"\",IF(S102=\"\",IF(SUM(COUNTIF(S103:S162,\"LS\")+COUNTIF(S103:S162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(S103:S162)>0,ROUNDUP(SUM(S103:S162),0),\"\")))","v":""},{"$f":"IF(T87=\"\",\"\",IF(T102=\"\",IF(SUM(COUNTIF(T103:T162,\"LS\")+COUNTIF(T103:T162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(T103:T162)>0,ROUNDUP(SUM(T103:T162),0),\"\")))","v":""},{"$f":"IF(U87=\"\",\"\",IF(U102=\"\",IF(SUM(COUNTIF(U103:U162,\"LS\")+COUNTIF(U103:U162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(U103:U162)>0,ROUNDUP(SUM(U103:U162),0),\"\")))","v":""},{"$f":"IF(V87=\"\",\"\",IF(V102=\"\",IF(SUM(COUNTIF(V103:V162,\"LS\")+COUNTIF(V103:V162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(V103:V162)>0,ROUNDUP(SUM(V103:V162),0),\"\")))","v":""},{"$f":"IF(W87=\"\",\"\",IF(W102=\"\",IF(SUM(COUNTIF(W103:W162,\"LS\")+COUNTIF(W103:W162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(W103:W162)>0,ROUNDUP(SUM(W103:W162),0),\"\")))","v":""},{"$f":"IF(X87=\"\",\"\",IF(X102=\"\",IF(SUM(COUNTIF(X103:X162,\"LS\")+COUNTIF(X103:X162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(X103:X162)>0,ROUNDUP(SUM(X103:X162),0),\"\")))","v":""},{"$f":"IF(Y87=\"\",\"\",IF(Y102=\"\",IF(SUM(COUNTIF(Y103:Y162,\"LS\")+COUNTIF(Y103:Y162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(Y103:Y162)>0,ROUNDUP(SUM(Y103:Y162),0),\"\")))","v":""},{"$f":"IF(Z87=\"\",\"\",IF(Z102=\"\",IF(SUM(COUNTIF(Z103:Z162,\"LS\")+COUNTIF(Z103:Z162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(Z103:Z162)>0,ROUNDUP(SUM(Z103:Z162),0),\"\")))","v":""},{"$f":"IF(AA87=\"\",\"\",IF(AA102=\"\",IF(SUM(COUNTIF(AA103:AA162,\"LS\")+COUNTIF(AA103:AA162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AA103:AA162)>0,ROUNDUP(SUM(AA103:AA162),0),\"\")))","v":""},{"$f":"IF(AB87=\"\",\"\",IF(AB102=\"\",IF(SUM(COUNTIF(AB103:AB162,\"LS\")+COUNTIF(AB103:AB162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AB103:AB162)>0,ROUNDUP(SUM(AB103:AB162),0),\"\")))","v":""},{"$f":"IF(AC87=\"\",\"\",IF(AC102=\"\",IF(SUM(COUNTIF(AC103:AC162,\"LS\")+COUNTIF(AC103:AC162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AC103:AC162)>0,ROUNDUP(SUM(AC103:AC162),0),\"\")))","v":""},{"$f":"IF(AD87=\"\",\"\",IF(AD102=\"\",IF(SUM(COUNTIF(AD103:AD162,\"LS\")+COUNTIF(AD103:AD162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AD103:AD162)>0,ROUNDUP(SUM(AD103:AD162),0),\"\")))","v":""},{"$f":"IF(AE87=\"\",\"\",IF(AE102=\"\",IF(SUM(COUNTIF(AE103:AE162,\"LS\")+COUNTIF(AE103:AE162,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AE103:AE162)>0,ROUNDUP(SUM(AE103:AE162),0),\"\")))","v":""}]
[]
[null,"Page #",null,{"$f":"D86+1","v":3}]
[null,null,null,"ITEM_CODE"]
[null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,"Split #",null,"REF       NO.","SHEET NO.","STATION TO STATION",null,null,null,null,{"$f":"IF(OR(TRIM(K166)=0,TRIM(K166)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K166),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K166),ITEM,0),11)),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K166)=0,TRIM(K166)=\"\"),IF(K167=\"\",\"\",K167),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K166),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K166),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K166),ITEM,0),3)),\"123456789012\"))-9))&K167,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K166),ITEM,0),3))&K167,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K166)=0,TRIM(K166)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K166),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K166),ITEM,0),2)),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,"TO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTALS CARRIED TO GENERAL SUMMARY  ",null,null,null,null,null,null,{"$f":"IF(K166=\"\",\"\",IF(K181=\"\",IF(SUM(COUNTIF(K182:K241,\"LS\")+COUNTIF(K182:K241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(K182:K241)>0,ROUNDUP(SUM(K182:K241),0),\"\")))","v":""},{"$f":"IF(L166=\"\",\"\",IF(L181=\"\",IF(SUM(COUNTIF(L182:L241,\"LS\")+COUNTIF(L182:L241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(L182:L241)>0,ROUNDUP(SUM(L182:L241),0),\"\")))","v":""},{"$f":"IF(M166=\"\",\"\",IF(M181=\"\",IF(SUM(COUNTIF(M182:M241,\"LS\")+COUNTIF(M182:M241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(M182:M241)>0,ROUNDUP(SUM(M182:M241),0),\"\")))","v":""},{"$f":"IF(N166=\"\",\"\",IF(N181=\"\",IF(SUM(COUNTIF(N182:N241,\"LS\")+COUNTIF(N182:N241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(N182:N241)>0,ROUNDUP(SUM(N182:N241),0),\"\")))","v":""},{"$f":"IF(O166=\"\",\"\",IF(O181=\"\",IF(SUM(COUNTIF(O182:O241,\"LS\")+COUNTIF(O182:O241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(O182:O241)>0,ROUNDUP(SUM(O182:O241),0),\"\")))","v":""},{"$f":"IF(P166=\"\",\"\",IF(P181=\"\",IF(SUM(COUNTIF(P182:P241,\"LS\")+COUNTIF(P182:P241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(P182:P241)>0,ROUNDUP(SUM(P182:P241),0),\"\")))","v":""},{"$f":"IF(Q166=\"\",\"\",IF(Q181=\"\",IF(SUM(COUNTIF(Q182:Q241,\"LS\")+COUNTIF(Q182:Q241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(Q182:Q241)>0,ROUNDUP(SUM(Q182:Q241),0),\"\")))","v":""},{"$f":"IF(R166=\"\",\"\",IF(R181=\"\",IF(SUM(COUNTIF(R182:R241,\"LS\")+COUNTIF(R182:R241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(R182:R241)>0,ROUNDUP(SUM(R182:R241),0),\"\")))","v":""},{"$f":"IF(S166=\"\",\"\",IF(S181=\"\",IF(SUM(COUNTIF(S182:S241,\"LS\")+COUNTIF(S182:S241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(S182:S241)>0,ROUNDUP(SUM(S182:S241),0),\"\")))","v":""},{"$f":"IF(T166=\"\",\"\",IF(T181=\"\",IF(SUM(COUNTIF(T182:T241,\"LS\")+COUNTIF(T182:T241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(T182:T241)>0,ROUNDUP(SUM(T182:T241),0),\"\")))","v":""},{"$f":"IF(U166=\"\",\"\",IF(U181=\"\",IF(SUM(COUNTIF(U182:U241,\"LS\")+COUNTIF(U182:U241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(U182:U241)>0,ROUNDUP(SUM(U182:U241),0),\"\")))","v":""},{"$f":"IF(V166=\"\",\"\",IF(V181=\"\",IF(SUM(COUNTIF(V182:V241,\"LS\")+COUNTIF(V182:V241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(V182:V241)>0,ROUNDUP(SUM(V182:V241),0),\"\")))","v":""},{"$f":"IF(W166=\"\",\"\",IF(W181=\"\",IF(SUM(COUNTIF(W182:W241,\"LS\")+COUNTIF(W182:W241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(W182:W241)>0,ROUNDUP(SUM(W182:W241),0),\"\")))","v":""},{"$f":"IF(X166=\"\",\"\",IF(X181=\"\",IF(SUM(COUNTIF(X182:X241,\"LS\")+COUNTIF(X182:X241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(X182:X241)>0,ROUNDUP(SUM(X182:X241),0),\"\")))","v":""},{"$f":"IF(Y166=\"\",\"\",IF(Y181=\"\",IF(SUM(COUNTIF(Y182:Y241,\"LS\")+COUNTIF(Y182:Y241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(Y182:Y241)>0,ROUNDUP(SUM(Y182:Y241),0),\"\")))","v":""},{"$f":"IF(Z166=\"\",\"\",IF(Z181=\"\",IF(SUM(COUNTIF(Z182:Z241,\"LS\")+COUNTIF(Z182:Z241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(Z182:Z241)>0,ROUNDUP(SUM(Z182:Z241),0),\"\")))","v":""},{"$f":"IF(AA166=\"\",\"\",IF(AA181=\"\",IF(SUM(COUNTIF(AA182:AA241,\"LS\")+COUNTIF(AA182:AA241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AA182:AA241)>0,ROUNDUP(SUM(AA182:AA241),0),\"\")))","v":""},{"$f":"IF(AB166=\"\",\"\",IF(AB181=\"\",IF(SUM(COUNTIF(AB182:AB241,\"LS\")+COUNTIF(AB182:AB241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AB182:AB241)>0,ROUNDUP(SUM(AB182:AB241),0),\"\")))","v":""},{"$f":"IF(AC166=\"\",\"\",IF(AC181=\"\",IF(SUM(COUNTIF(AC182:AC241,\"LS\")+COUNTIF(AC182:AC241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AC182:AC241)>0,ROUNDUP(SUM(AC182:AC241),0),\"\")))","v":""},{"$f":"IF(AD166=\"\",\"\",IF(AD181=\"\",IF(SUM(COUNTIF(AD182:AD241,\"LS\")+COUNTIF(AD182:AD241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AD182:AD241)>0,ROUNDUP(SUM(AD182:AD241),0),\"\")))","v":""},{"$f":"IF(AE166=\"\",\"\",IF(AE181=\"\",IF(SUM(COUNTIF(AE182:AE241,\"LS\")+COUNTIF(AE182:AE241,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AE182:AE241)>0,ROUNDUP(SUM(AE182:AE241),0),\"\")))","v":""}]
[]
[null,"Page #",null,{"$f":"D165+1","v":4}]
[null,null,null,"ITEM_CODE"]
[null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,"Split #",null,"REF       NO.","SHEET NO.","STATION TO STATION",null,null,null,null,{"$f":"IF(OR(TRIM(K245)=0,TRIM(K245)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K245),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K245),ITEM,0),11)),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K245)=0,TRIM(K245)=\"\"),IF(K246=\"\",\"\",K246),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K245),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K245),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K245),ITEM,0),3)),\"123456789012\"))-9))&K246,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K245),ITEM,0),3))&K246,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K245)=0,TRIM(K245)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K245),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K245),ITEM,0),2)),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,"TO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,"TOTALS CARRIED TO GENERAL SUMMARY  ",null,null,null,null,null,null,{"$f":"IF(K245=\"\",\"\",IF(K260=\"\",IF(SUM(COUNTIF(K261:K320,\"LS\")+COUNTIF(K261:K320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(K261:K320)>0,ROUNDUP(SUM(K261:K320),0),\"\")))","v":""},{"$f":"IF(L245=\"\",\"\",IF(L260=\"\",IF(SUM(COUNTIF(L261:L320,\"LS\")+COUNTIF(L261:L320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(L261:L320)>0,ROUNDUP(SUM(L261:L320),0),\"\")))","v":""},{"$f":"IF(M245=\"\",\"\",IF(M260=\"\",IF(SUM(COUNTIF(M261:M320,\"LS\")+COUNTIF(M261:M320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(M261:M320)>0,ROUNDUP(SUM(M261:M320),0),\"\")))","v":""},{"$f":"IF(N245=\"\",\"\",IF(N260=\"\",IF(SUM(COUNTIF(N261:N320,\"LS\")+COUNTIF(N261:N320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(N261:N320)>0,ROUNDUP(SUM(N261:N320),0),\"\")))","v":""},{"$f":"IF(O245=\"\",\"\",IF(O260=\"\",IF(SUM(COUNTIF(O261:O320,\"LS\")+COUNTIF(O261:O320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(O261:O320)>0,ROUNDUP(SUM(O261:O320),0),\"\")))","v":""},{"$f":"IF(P245=\"\",\"\",IF(P260=\"\",IF(SUM(COUNTIF(P261:P320,\"LS\")+COUNTIF(P261:P320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(P261:P320)>0,ROUNDUP(SUM(P261:P320),0),\"\")))","v":""},{"$f":"IF(Q245=\"\",\"\",IF(Q260=\"\",IF(SUM(COUNTIF(Q261:Q320,\"LS\")+COUNTIF(Q261:Q320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(Q261:Q320)>0,ROUNDUP(SUM(Q261:Q320),0),\"\")))","v":""},{"$f":"IF(R245=\"\",\"\",IF(R260=\"\",IF(SUM(COUNTIF(R261:R320,\"LS\")+COUNTIF(R261:R320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(R261:R320)>0,ROUNDUP(SUM(R261:R320),0),\"\")))","v":""},{"$f":"IF(S245=\"\",\"\",IF(S260=\"\",IF(SUM(COUNTIF(S261:S320,\"LS\")+COUNTIF(S261:S320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(S261:S320)>0,ROUNDUP(SUM(S261:S320),0),\"\")))","v":""},{"$f":"IF(T245=\"\",\"\",IF(T260=\"\",IF(SUM(COUNTIF(T261:T320,\"LS\")+COUNTIF(T261:T320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(T261:T320)>0,ROUNDUP(SUM(T261:T320),0),\"\")))","v":""},{"$f":"IF(U245=\"\",\"\",IF(U260=\"\",IF(SUM(COUNTIF(U261:U320,\"LS\")+COUNTIF(U261:U320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(U261:U320)>0,ROUNDUP(SUM(U261:U320),0),\"\")))","v":""},{"$f":"IF(V245=\"\",\"\",IF(V260=\"\",IF(SUM(COUNTIF(V261:V320,\"LS\")+COUNTIF(V261:V320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(V261:V320)>0,ROUNDUP(SUM(V261:V320),0),\"\")))","v":""},{"$f":"IF(W245=\"\",\"\",IF(W260=\"\",IF(SUM(COUNTIF(W261:W320,\"LS\")+COUNTIF(W261:W320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(W261:W320)>0,ROUNDUP(SUM(W261:W320),0),\"\")))","v":""},{"$f":"IF(X245=\"\",\"\",IF(X260=\"\",IF(SUM(COUNTIF(X261:X320,\"LS\")+COUNTIF(X261:X320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(X261:X320)>0,ROUNDUP(SUM(X261:X320),0),\"\")))","v":""},{"$f":"IF(Y245=\"\",\"\",IF(Y260=\"\",IF(SUM(COUNTIF(Y261:Y320,\"LS\")+COUNTIF(Y261:Y320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(Y261:Y320)>0,ROUNDUP(SUM(Y261:Y320),0),\"\")))","v":""},{"$f":"IF(Z245=\"\",\"\",IF(Z260=\"\",IF(SUM(COUNTIF(Z261:Z320,\"LS\")+COUNTIF(Z261:Z320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(Z261:Z320)>0,ROUNDUP(SUM(Z261:Z320),0),\"\")))","v":""},{"$f":"IF(AA245=\"\",\"\",IF(AA260=\"\",IF(SUM(COUNTIF(AA261:AA320,\"LS\")+COUNTIF(AA261:AA320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AA261:AA320)>0,ROUNDUP(SUM(AA261:AA320),0),\"\")))","v":""},{"$f":"IF(AB245=\"\",\"\",IF(AB260=\"\",IF(SUM(COUNTIF(AB261:AB320,\"LS\")+COUNTIF(AB261:AB320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AB261:AB320)>0,ROUNDUP(SUM(AB261:AB320),0),\"\")))","v":""},{"$f":"IF(AC245=\"\",\"\",IF(AC260=\"\",IF(SUM(COUNTIF(AC261:AC320,\"LS\")+COUNTIF(AC261:AC320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AC261:AC320)>0,ROUNDUP(SUM(AC261:AC320),0),\"\")))","v":""},{"$f":"IF(AD245=\"\",\"\",IF(AD260=\"\",IF(SUM(COUNTIF(AD261:AD320,\"LS\")+COUNTIF(AD261:AD320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AD261:AD320)>0,ROUNDUP(SUM(AD261:AD320),0),\"\")))","v":""},{"$f":"IF(AE245=\"\",\"\",IF(AE260=\"\",IF(SUM(COUNTIF(AE261:AE320,\"LS\")+COUNTIF(AE261:AE320,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(AE261:AE320)>0,ROUNDUP(SUM(AE261:AE320),0),\"\")))","v":""}]