{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Затраты","Expenses","Справочники"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Затраты","index":0,"n_rows":20,"n_cols":35,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[]
[null,null,null,"Год",2015,"Месяц",null,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,{"$f":"SUM(rngExpIndicators)","v":0}]
[null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,"ID","Магазин",{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(D$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 1"},{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(E$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 2"},{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(F$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 3"},{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(G$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 4"},{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(H$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 5"},{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(I$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 6"},{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(J$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 7"},{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(K$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 8"},{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(L$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 9"},{"$f":"IFERROR(INDEX(ExpTypes[[Товар]:[Товар]],MATCH(M$4,ExpTypes[[ID]:[ID]],0)),\"\")","v":"Вид затрат 10"},null,{"$f":"D4","v":1},{"$f":"E4","v":2},3,4,5,6,7,8,9,10,null,{"$f":"D4","v":1},{"$f":"E4","v":2},3,4,5,6,7,8,9,10]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(1:1)),\"\")","v":1},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B6,SalesPoints[ID],0)),\"\")","v":"Центральный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B6,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,{"$f":"--(D6<>O6)","v":0},{"$f":"--(E6<>P6)","v":0},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(2:2)),\"\")","v":2},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B7,SalesPoints[ID],0)),\"\")","v":"Восточный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B7,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,{"$f":"--(D7<>O7)","v":0},{"$f":"--(E7<>P7)","v":0},{"$f":"--(F7<>Q7)","v":0},{"$f":"--(G7<>R7)","v":0},{"$f":"--(H7<>S7)","v":0},{"$f":"--(I7<>T7)","v":0},{"$f":"--(J7<>U7)","v":0},{"$f":"--(K7<>V7)","v":0},{"$f":"--(L7<>W7)","v":0},{"$f":"--(M7<>X7)","v":0}]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(3:3)),\"\")","v":3},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B8,SalesPoints[ID],0)),\"\")","v":"Западный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B8,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(4:4)),\"\")","v":4},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B9,SalesPoints[ID],0)),\"\")","v":"Северный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B9,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(5:5)),\"\")","v":5},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B10,SalesPoints[ID],0)),\"\")","v":"Южный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B10,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(6:6)),\"\")","v":6},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B11,SalesPoints[ID],0)),\"\")","v":"Северо-западный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B11,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(7:7)),\"\")","v":7},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B12,SalesPoints[ID],0)),\"\")","v":"Юго-восточный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B12,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(8:8)),\"\")","v":8},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B13,SalesPoints[ID],0)),\"\")","v":"Северо-восточный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B13,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(9:9)),\"\")","v":9},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B14,SalesPoints[ID],0)),\"\")","v":"Юго-западный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B14,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(10:10)),\"\")","v":10},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B15,SalesPoints[ID],0)),\"\")","v":"Резервный РКЦ"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B15,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(11:11)),\"\")","v":11},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B16,SalesPoints[ID],0)),\"\")","v":"Международный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B16,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(12:12)),\"\")","v":12},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B17,SalesPoints[ID],0)),\"\")","v":"Специальный"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B17,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(13:13)),\"\")","v":13},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B18,SalesPoints[ID],0)),\"\")","v":"Дальний"},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B18,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(14:14)),\"\")","v":""},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B19,SalesPoints[ID],0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B19,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(SalesPoints[ID],ROW(15:15)),\"\")","v":""},{"$f":"IFERROR(INDEX(SalesPoints[Магазин],MATCH($B20,SalesPoints[ID],0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],D$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],E$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],F$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],G$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],H$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],I$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],J$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],K$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],L$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},{"$f":"SUMIFS(Smart[[AMOUNT]:[AMOUNT]],Smart[[POINT_ID]:[POINT_ID]],$B20,Smart[[EXP_ID]:[EXP_ID]],M$4,Smart[[YEAR]:[YEAR]],rngExpYear,Smart[[MONTH]:[MONTH]],rngExpMonth)","v":0},null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Expenses","index":1,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["POINT_ID","EXP_ID","YEAR","MONTH","AMOUNT"]

{"sheet":"Справочники","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ID","Магазин",null,"ID","Товар"]
[null,1,"Центральный",null,1,"Вид затрат 1"]
[null,2,"Восточный",null,2,"Вид затрат 2"]
[null,3,"Западный",null,3,"Вид затрат 3"]
[null,4,"Северный",null,4,"Вид затрат 4"]
[null,5,"Южный",null,5,"Вид затрат 5"]
[null,6,"Северо-западный",null,6,"Вид затрат 6"]
[null,7,"Юго-восточный",null,7,"Вид затрат 7"]
[null,8,"Северо-восточный",null,8,"Вид затрат 8"]
[null,9,"Юго-западный",null,9,"Вид затрат 9"]
[null,10,"Резервный РКЦ",null,10,"Вид затрат 10"]
[null,11,"Международный"]
[null,12,"Специальный"]
[null,13,"Дальний"]