{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SUBSUMMARY"],"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":"SUBSUMMARY","index":0,"n_rows":173,"n_cols":34,"rows_kept":173,"cut":false,"hidden":false,"merged":[[172,3,172,9],[136,21,147,21],[136,22,147,22],[136,23,147,23],[136,24,147,24],[136,25,147,25],[130,3,130,9],[132,3,132,30],[133,3,133,9],[134,3,134,9],[135,3,148,3],[135,4,148,4],[135,5,148,9],[136,10,147,10],[136,11,147,11],[136,12,147,12],[136,26,147,26],[136,13,147,13],[136,14,147,14],[136,15,147,15],[136,16,147,16],[136,17,147,17],[136,18,147,18],[136,27,147,27],[90,3,90,30],[91,3,91,9],[92,3,92,9],[93,3,106,3],[93,4,106,4],[93,5,106,9],[94,10,105,10],[94,11,105,11],[94,12,105,12],[94,13,105,13],[94,14,105,14],[94,15,105,15],[94,16,105,16],[94,17,105,17],[94,18,105,18],[94,19,105,19],[94,20,105,20],[94,21,105,21],[94,22,105,22],[94,23,105,23],[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],[50,3,50,9],[10,22,21,22],[10,23,21,23],[10,19,21,19],[10,20,21,20],[46,3,46,9],[10,10,21,10],[10,11,21,11],[10,12,21,12],[10,15,21,15],[10,16,21,16],[10,17,21,17],[10,18,21,18],[48,3,48,30],[49,3,49,9],[10,30,21,30],[7,3,7,9],[8,3,8,9],[52,14,63,14],[52,15,63,15],[52,22,63,22],[52,23,63,23],[52,16,63,16],[52,17,63,17],[52,18,63,18],[52,19,63,19],[10,14,21,14],[10,21,21,21],[51,3,64,3],[10,13,21,13],[9,4,22,4],[9,5,22,9],[51,4,64,4],[51,5,64,9],[52,10,63,10],[52,11,63,11],[52,12,63,12],[52,13,63,13],[52,20,63,20],[52,21,63,21],[9,1,22,1],[51,1,64,1],[93,1,106,1],[135,1,148,1],[136,19,147,19],[136,20,147,20],[52,28,63,28],[52,29,63,29],[52,30,63,30],[52,24,63,24],[52,25,63,25],[52,26,63,26],[52,27,63,27],[94,27,105,27],[94,28,105,28],[94,29,105,29],[94,30,105,30],[94,24,105,24],[94,25,105,25],[94,26,105,26],[136,28,147,28],[136,29,147,29],[136,30,147,30],[88,3,88,9]]}
[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"]
[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,null,1,"<--- ENTER STARTING SHEET NUMBER"]
[null,null,null,"ITEM_CODE"]
[null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,"Split #",null,"REF\nNO.","SHEET\nNO.","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(QryItemNamed(ITEM,MATCH(TRIM(K8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(L8)=0,TRIM(L8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(L8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(M8)=0,TRIM(M8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(M8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(N8)=0,TRIM(N8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(N8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(O8)=0,TRIM(O8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(O8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(O8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(P8)=0,TRIM(P8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(P8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(P8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Q8)=0,TRIM(Q8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Q8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Q8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(R8)=0,TRIM(R8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(R8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(R8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(S8)=0,TRIM(S8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(S8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(S8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(T8)=0,TRIM(T8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(T8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(T8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(U8)=0,TRIM(U8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(U8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(U8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(V8)=0,TRIM(V8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(V8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(V8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(W8)=0,TRIM(W8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(W8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(W8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(X8)=0,TRIM(X8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(X8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(X8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Y8)=0,TRIM(Y8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Y8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Y8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Z8)=0,TRIM(Z8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Z8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Z8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AA8)=0,TRIM(AA8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AA8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AA8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AB8)=0,TRIM(AB8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AB8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AB8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AC8)=0,TRIM(AC8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AC8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AC8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AD8)=0,TRIM(AD8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AD8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AD8),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AE8)=0,TRIM(AE8)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AE8),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AE8),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(OR(K23=\"\", K23=\"LS\", K23=\"LUMP\"),IF(SUM(COUNTIF(K24:K46,\"LS\")+COUNTIF(K24:K46,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(K24:K46)>0,ROUNDUP(SUM(K24:K46),0),\"\")))","v":""},{"$f":"IF(L8=\"\",\"\",IF(OR(L23=\"\", L23=\"LS\", L23=\"LUMP\"),IF(SUM(COUNTIF(L24:L46,\"LS\")+COUNTIF(L24:L46,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(L24:L46)>0,ROUNDUP(SUM(L24:L46),0),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"\"SUBSUMMARY SHEET \" & B50","v":"SUBSUMMARY SHEET "}]
[null,null,null,"ITEM_CODE"]
[null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,"Split #",null,"REF\nNO.","SHEET\nNO.","STATION TO STATION",null,null,null,null,{"$f":"IF(OR(TRIM(K50)=0,TRIM(K50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(K50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(L50)=0,TRIM(L50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(L50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(M50)=0,TRIM(M50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(M50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(N50)=0,TRIM(N50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(N50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(O50)=0,TRIM(O50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(O50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(O50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(P50)=0,TRIM(P50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(P50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(P50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Q50)=0,TRIM(Q50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Q50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Q50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(R50)=0,TRIM(R50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(R50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(R50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(S50)=0,TRIM(S50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(S50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(S50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(T50)=0,TRIM(T50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(T50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(T50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(U50)=0,TRIM(U50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(U50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(U50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(V50)=0,TRIM(V50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(V50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(V50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(W50)=0,TRIM(W50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(W50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(W50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(X50)=0,TRIM(X50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(X50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(X50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Y50)=0,TRIM(Y50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Y50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Y50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Z50)=0,TRIM(Z50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Z50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Z50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AA50)=0,TRIM(AA50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AA50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AA50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AB50)=0,TRIM(AB50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AB50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AB50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AC50)=0,TRIM(AC50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AC50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AC50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AD50)=0,TRIM(AD50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AD50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AD50),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AE50)=0,TRIM(AE50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AE50),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AE50),ITEM,0),11)),\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K50)=0,TRIM(K50)=\"\"),IF(K51=\"\",\"\",K51),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K50),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K50),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K50),ITEM,0),3)),\"123456789012\"))-9))&K51,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K50),ITEM,0),3))&K51,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K50)=0,TRIM(K50)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K50),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K50),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(K50=\"\",\"\",IF(OR(K65=\"\", K65=\"LS\", K65=\"LUMP\"),IF(SUM(COUNTIF(K66:K88,\"LS\")+COUNTIF(K66:K88,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(K66:K88)>0,ROUNDUP(SUM(K66:K88),0),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"\"SUBSUMMARY SHEET \" & B92","v":"SUBSUMMARY SHEET "}]
[null,null,null,"ITEM_CODE"]
[null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,"Split #",null,"REF\nNO.","SHEET\nNO.","STATION TO STATION",null,null,null,null,{"$f":"IF(OR(TRIM(K92)=0,TRIM(K92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(K92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(L92)=0,TRIM(L92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(L92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(M92)=0,TRIM(M92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(M92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(N92)=0,TRIM(N92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(N92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(O92)=0,TRIM(O92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(O92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(O92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(P92)=0,TRIM(P92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(P92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(P92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Q92)=0,TRIM(Q92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Q92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Q92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(R92)=0,TRIM(R92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(R92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(R92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(S92)=0,TRIM(S92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(S92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(S92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(T92)=0,TRIM(T92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(T92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(T92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(U92)=0,TRIM(U92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(U92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(U92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(V92)=0,TRIM(V92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(V92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(V92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(W92)=0,TRIM(W92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(W92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(W92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(X92)=0,TRIM(X92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(X92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(X92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Y92)=0,TRIM(Y92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Y92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Y92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Z92)=0,TRIM(Z92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Z92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Z92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AA92)=0,TRIM(AA92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AA92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AA92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AB92)=0,TRIM(AB92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AB92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AB92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AC92)=0,TRIM(AC92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AC92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AC92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AD92)=0,TRIM(AD92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AD92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AD92),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AE92)=0,TRIM(AE92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AE92),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AE92),ITEM,0),11)),\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K92)=0,TRIM(K92)=\"\"),IF(K93=\"\",\"\",K93),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K92),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K92),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K92),ITEM,0),3)),\"123456789012\"))-9))&K93,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K92),ITEM,0),3))&K93,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K92)=0,TRIM(K92)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K92),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K92),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(K92=\"\",\"\",IF(OR(K107=\"\", K107=\"LS\", K107=\"LUMP\"),IF(SUM(COUNTIF(K108:K130,\"LS\")+COUNTIF(K108:K130,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(K108:K130)>0,ROUNDUP(SUM(K108:K130),0),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"\"SUBSUMMARY SHEET \" & B134","v":"SUBSUMMARY SHEET "}]
[null,null,null,"ITEM_CODE"]
[null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,"Split #",null,"REF\nNO.","SHEET\nNO.","STATION TO STATION",null,null,null,null,{"$f":"IF(OR(TRIM(K134)=0,TRIM(K134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(K134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(L134)=0,TRIM(L134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(L134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(L134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(M134)=0,TRIM(M134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(M134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(N134)=0,TRIM(N134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(N134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(O134)=0,TRIM(O134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(O134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(O134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(P134)=0,TRIM(P134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(P134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(P134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Q134)=0,TRIM(Q134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Q134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Q134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(R134)=0,TRIM(R134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(R134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(R134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(S134)=0,TRIM(S134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(S134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(S134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(T134)=0,TRIM(T134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(T134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(T134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(U134)=0,TRIM(U134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(U134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(U134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(V134)=0,TRIM(V134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(V134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(V134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(W134)=0,TRIM(W134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(W134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(W134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(X134)=0,TRIM(X134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(X134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(X134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Y134)=0,TRIM(Y134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Y134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Y134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(Z134)=0,TRIM(Z134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(Z134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(Z134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AA134)=0,TRIM(AA134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AA134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AA134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AB134)=0,TRIM(AB134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AB134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AB134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AC134)=0,TRIM(AC134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AC134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AC134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AD134)=0,TRIM(AD134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AD134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AD134),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(AE134)=0,TRIM(AE134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(AE134),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(QryItemNamed(ITEM,MATCH(TRIM(AE134),ITEM,0),11)),\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K134)=0,TRIM(K134)=\"\"),IF(K135=\"\",\"\",K135),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K134),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K134),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K134),ITEM,0),3)),\"123456789012\"))-9))&K135,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K134),ITEM,0),3))&K135,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(K134)=0,TRIM(K134)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K134),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(K134),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(K134=\"\",\"\",IF(OR(K149=\"\", K149=\"LS\", K149=\"LUMP\"),IF(SUM(COUNTIF(K150:K172,\"LS\")+COUNTIF(K150:K172,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(K150:K172)>0,ROUNDUP(SUM(K150:K172),0),\"\")))","v":""},"","","","","","","","","","","","","","","","","","","",""]