{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Model","SCENARIOS","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Model","index":0,"n_rows":47,"n_cols":54,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($W1:W1)+1","v":1},{"$f":"MAX($W1:X1)+1","v":2},{"$f":"MAX($W1:Y1)+1","v":3},{"$f":"MAX($W1:Z1)+1","v":4},{"$f":"MAX($W1:AA1)+1","v":5},{"$f":"MAX($W1:AB1)+1","v":6},{"$f":"MAX($W1:AC1)+1","v":7},{"$f":"MAX($W1:AD1)+1","v":8},{"$f":"MAX($W1:AE1)+1","v":9},{"$f":"MAX($W1:AF1)+1","v":10},{"$f":"MAX($W1:AG1)+1","v":11},{"$f":"MAX($W1:AH1)+1","v":12},{"$f":"MAX($W1:AI1)+1","v":13},{"$f":"MAX($W1:AJ1)+1","v":14},{"$f":"MAX($W1:AK1)+1","v":15},{"$f":"MAX($W1:AL1)+1","v":16},{"$f":"MAX($W1:AM1)+1","v":17},{"$f":"MAX($W1:AN1)+1","v":18},{"$f":"MAX($W1:AO1)+1","v":19},{"$f":"MAX($W1:AP1)+1","v":20},{"$f":"MAX($W1:AQ1)+1","v":21},{"$f":"MAX($W1:AR1)+1","v":22},{"$f":"MAX($W1:AS1)+1","v":23},{"$f":"MAX($W1:AT1)+1","v":24},{"$f":"MAX($W1:AU1)+1","v":25},{"$f":"MAX($W1:AV1)+1","v":26},{"$f":"MAX($W1:AW1)+1","v":27},{"$f":"MAX($W1:AX1)+1","v":28},{"$f":"MAX($W1:AY1)+1","v":29},{"$f":"MAX($W1:AZ1)+1","v":30},{"$f":"MAX($W1:BA1)+1","v":31}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40},{"$f":"COLUMN()","v":41},{"$f":"COLUMN()","v":42},{"$f":"COLUMN()","v":43},{"$f":"COLUMN()","v":44},{"$f":"COLUMN()","v":45},{"$f":"COLUMN()","v":46},{"$f":"COLUMN()","v":47},{"$f":"COLUMN()","v":48},{"$f":"COLUMN()","v":49},{"$f":"COLUMN()","v":50},{"$f":"COLUMN()","v":51},{"$f":"COLUMN()","v":52},{"$f":"COLUMN()","v":53},{"$f":"COLUMN()","v":54}]
[]
[null,null,null,null,null,null,null,{"$f":"Lists!$S$6","v":"показатель"},null,null,null,null,{"$f":"Lists!$S$7","v":"ед.изм."},null,null,{"$f":"Lists!$S$8","v":"значение"},null,null,null,null,{"$f":"Lists!$S$9","v":"итого"},null,null,{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(X$8=\"\",\"\",\nIF($P$6=Lists!$I$6,X6,\nIF($P$6=Lists!$I$7,INT(MONTH(X7)/3)&\"кв\"&(YEAR(X7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,X8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(X7)&\"г.\",\"\"))))))","v":"2021-12-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(Y$8=\"\",\"\",\nIF($P$6=Lists!$I$6,Y6,\nIF($P$6=Lists!$I$7,INT(MONTH(Y7)/3)&\"кв\"&(YEAR(Y7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,Y8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(Y7)&\"г.\",\"\"))))))","v":"2022-01-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(Z$8=\"\",\"\",\nIF($P$6=Lists!$I$6,Z6,\nIF($P$6=Lists!$I$7,INT(MONTH(Z7)/3)&\"кв\"&(YEAR(Z7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,Z8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(Z7)&\"г.\",\"\"))))))","v":"2022-02-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AA$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AA6,\nIF($P$6=Lists!$I$7,INT(MONTH(AA7)/3)&\"кв\"&(YEAR(AA7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AA8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AA7)&\"г.\",\"\"))))))","v":"2022-03-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AB$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AB6,\nIF($P$6=Lists!$I$7,INT(MONTH(AB7)/3)&\"кв\"&(YEAR(AB7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AB8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AB7)&\"г.\",\"\"))))))","v":"2022-04-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AC$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AC6,\nIF($P$6=Lists!$I$7,INT(MONTH(AC7)/3)&\"кв\"&(YEAR(AC7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AC8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AC7)&\"г.\",\"\"))))))","v":"2022-05-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AD$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AD6,\nIF($P$6=Lists!$I$7,INT(MONTH(AD7)/3)&\"кв\"&(YEAR(AD7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AD8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AD7)&\"г.\",\"\"))))))","v":"2022-06-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AE$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AE6,\nIF($P$6=Lists!$I$7,INT(MONTH(AE7)/3)&\"кв\"&(YEAR(AE7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AE8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AE7)&\"г.\",\"\"))))))","v":"2022-07-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AF$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AF6,\nIF($P$6=Lists!$I$7,INT(MONTH(AF7)/3)&\"кв\"&(YEAR(AF7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AF8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AF7)&\"г.\",\"\"))))))","v":"2022-08-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AG$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AG6,\nIF($P$6=Lists!$I$7,INT(MONTH(AG7)/3)&\"кв\"&(YEAR(AG7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AG8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AG7)&\"г.\",\"\"))))))","v":"2022-09-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AH$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AH6,\nIF($P$6=Lists!$I$7,INT(MONTH(AH7)/3)&\"кв\"&(YEAR(AH7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AH8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AH7)&\"г.\",\"\"))))))","v":"2022-10-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AI$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AI6,\nIF($P$6=Lists!$I$7,INT(MONTH(AI7)/3)&\"кв\"&(YEAR(AI7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AI8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AI7)&\"г.\",\"\"))))))","v":"2022-11-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AJ$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AJ6,\nIF($P$6=Lists!$I$7,INT(MONTH(AJ7)/3)&\"кв\"&(YEAR(AJ7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AJ8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AJ7)&\"г.\",\"\"))))))","v":"2022-12-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AK$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AK6,\nIF($P$6=Lists!$I$7,INT(MONTH(AK7)/3)&\"кв\"&(YEAR(AK7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AK8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AK7)&\"г.\",\"\"))))))","v":"2023-01-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AL$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AL6,\nIF($P$6=Lists!$I$7,INT(MONTH(AL7)/3)&\"кв\"&(YEAR(AL7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AL8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AL7)&\"г.\",\"\"))))))","v":"2023-02-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AM$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AM6,\nIF($P$6=Lists!$I$7,INT(MONTH(AM7)/3)&\"кв\"&(YEAR(AM7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AM8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AM7)&\"г.\",\"\"))))))","v":"2023-03-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AN$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AN6,\nIF($P$6=Lists!$I$7,INT(MONTH(AN7)/3)&\"кв\"&(YEAR(AN7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AN8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AN7)&\"г.\",\"\"))))))","v":"2023-04-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AO$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AO6,\nIF($P$6=Lists!$I$7,INT(MONTH(AO7)/3)&\"кв\"&(YEAR(AO7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AO8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AO7)&\"г.\",\"\"))))))","v":"2023-05-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AP$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AP6,\nIF($P$6=Lists!$I$7,INT(MONTH(AP7)/3)&\"кв\"&(YEAR(AP7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AP8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AP7)&\"г.\",\"\"))))))","v":"2023-06-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AQ$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AQ6,\nIF($P$6=Lists!$I$7,INT(MONTH(AQ7)/3)&\"кв\"&(YEAR(AQ7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AQ8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AQ7)&\"г.\",\"\"))))))","v":"2023-07-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AR$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AR6,\nIF($P$6=Lists!$I$7,INT(MONTH(AR7)/3)&\"кв\"&(YEAR(AR7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AR8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AR7)&\"г.\",\"\"))))))","v":"2023-08-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AS$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AS6,\nIF($P$6=Lists!$I$7,INT(MONTH(AS7)/3)&\"кв\"&(YEAR(AS7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AS8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AS7)&\"г.\",\"\"))))))","v":"2023-09-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AT$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AT6,\nIF($P$6=Lists!$I$7,INT(MONTH(AT7)/3)&\"кв\"&(YEAR(AT7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AT8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AT7)&\"г.\",\"\"))))))","v":"2023-10-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AU$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AU6,\nIF($P$6=Lists!$I$7,INT(MONTH(AU7)/3)&\"кв\"&(YEAR(AU7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AU8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AU7)&\"г.\",\"\"))))))","v":"2023-11-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AV$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AV6,\nIF($P$6=Lists!$I$7,INT(MONTH(AV7)/3)&\"кв\"&(YEAR(AV7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AV8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AV7)&\"г.\",\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AW$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AW6,\nIF($P$6=Lists!$I$7,INT(MONTH(AW7)/3)&\"кв\"&(YEAR(AW7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AW8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AW7)&\"г.\",\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AX$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AX6,\nIF($P$6=Lists!$I$7,INT(MONTH(AX7)/3)&\"кв\"&(YEAR(AX7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AX8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AX7)&\"г.\",\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AY$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AY6,\nIF($P$6=Lists!$I$7,INT(MONTH(AY7)/3)&\"кв\"&(YEAR(AY7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AY8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AY7)&\"г.\",\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AZ$8=\"\",\"\",\nIF($P$6=Lists!$I$6,AZ6,\nIF($P$6=Lists!$I$7,INT(MONTH(AZ7)/3)&\"кв\"&(YEAR(AZ7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,AZ8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(AZ7)&\"г.\",\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(BA$8=\"\",\"\",\nIF($P$6=Lists!$I$6,BA6,\nIF($P$6=Lists!$I$7,INT(MONTH(BA7)/3)&\"кв\"&(YEAR(BA7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,BA8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(BA7)&\"г.\",\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(BB$8=\"\",\"\",\nIF($P$6=Lists!$I$6,BB6,\nIF($P$6=Lists!$I$7,INT(MONTH(BB7)/3)&\"кв\"&(YEAR(BB7)-2000)&\"г\",\nIF($P$6=Lists!$I$8,BB8&\" год\",\nIF($P$6=Lists!$I$9,YEAR(BB7)&\"г.\",\"\"))))))","v":""}]
[]
[null,{"$f":"ROW()","v":6},null,null,{"$f":"IF(E4=1,\"ENG\",\"РУС\")","v":"РУС"},null,null,{"$f":"I6","v":"минимальный период расчетов"},{"$f":"Lists!$I$4","v":"минимальный период расчетов"},null,null,null,"тип периода",null,"*","месяц","^",null,null,null,{"$f":"X6","v":"2021-12-01"},null,null,{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(X$8=\"\",\"\",\nIF(X$8=1,EOMONTH($P$7,-1)+1,W7+1)))","v":"2021-12-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(Y$8=\"\",\"\",\nIF(Y$8=1,EOMONTH($P$7,-1)+1,X7+1)))","v":"2022-01-01"},"2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01",{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AE$8=\"\",\"\",\nIF(AE$8=1,EOMONTH($P$7,-1)+1,AD7+1)))","v":"2022-07-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AF$8=\"\",\"\",\nIF(AF$8=1,EOMONTH($P$7,-1)+1,AE7+1)))","v":"2022-08-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AG$8=\"\",\"\",\nIF(AG$8=1,EOMONTH($P$7,-1)+1,AF7+1)))","v":"2022-09-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AH$8=\"\",\"\",\nIF(AH$8=1,EOMONTH($P$7,-1)+1,AG7+1)))","v":"2022-10-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AI$8=\"\",\"\",\nIF(AI$8=1,EOMONTH($P$7,-1)+1,AH7+1)))","v":"2022-11-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AJ$8=\"\",\"\",\nIF(AJ$8=1,EOMONTH($P$7,-1)+1,AI7+1)))","v":"2022-12-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AK$8=\"\",\"\",\nIF(AK$8=1,EOMONTH($P$7,-1)+1,AJ7+1)))","v":"2023-01-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AL$8=\"\",\"\",\nIF(AL$8=1,EOMONTH($P$7,-1)+1,AK7+1)))","v":"2023-02-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AM$8=\"\",\"\",\nIF(AM$8=1,EOMONTH($P$7,-1)+1,AL7+1)))","v":"2023-03-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AN$8=\"\",\"\",\nIF(AN$8=1,EOMONTH($P$7,-1)+1,AM7+1)))","v":"2023-04-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AO$8=\"\",\"\",\nIF(AO$8=1,EOMONTH($P$7,-1)+1,AN7+1)))","v":"2023-05-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AP$8=\"\",\"\",\nIF(AP$8=1,EOMONTH($P$7,-1)+1,AO7+1)))","v":"2023-06-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AQ$8=\"\",\"\",\nIF(AQ$8=1,EOMONTH($P$7,-1)+1,AP7+1)))","v":"2023-07-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AR$8=\"\",\"\",\nIF(AR$8=1,EOMONTH($P$7,-1)+1,AQ7+1)))","v":"2023-08-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AS$8=\"\",\"\",\nIF(AS$8=1,EOMONTH($P$7,-1)+1,AR7+1)))","v":"2023-09-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AT$8=\"\",\"\",\nIF(AT$8=1,EOMONTH($P$7,-1)+1,AS7+1)))","v":"2023-10-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AU$8=\"\",\"\",\nIF(AU$8=1,EOMONTH($P$7,-1)+1,AT7+1)))","v":"2023-11-01"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AV$8=\"\",\"\",\nIF(AV$8=1,EOMONTH($P$7,-1)+1,AU7+1)))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AW$8=\"\",\"\",\nIF(AW$8=1,EOMONTH($P$7,-1)+1,AV7+1)))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AX$8=\"\",\"\",\nIF(AX$8=1,EOMONTH($P$7,-1)+1,AW7+1)))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AY$8=\"\",\"\",\nIF(AY$8=1,EOMONTH($P$7,-1)+1,AX7+1)))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AZ$8=\"\",\"\",\nIF(AZ$8=1,EOMONTH($P$7,-1)+1,AY7+1)))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(BA$8=\"\",\"\",\nIF(BA$8=1,EOMONTH($P$7,-1)+1,AZ7+1)))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(BB$8=\"\",\"\",\nIF(BB$8=1,EOMONTH($P$7,-1)+1,BA7+1)))","v":""}]
[null,{"$f":"ROW()","v":7},null,null,null,null,null,{"$f":"I7","v":"старт моделирования"},{"$f":"Lists!$N$4","v":"старт моделирования"},null,null,null,"месяц",null,"*","2021-12-01","^",null,null,null,{"$f":"MAX(INDIRECT(ADDRESS($B7,X$2)&\":\"&ADDRESS($B7,MAX($2:$2))))","v":"2023-11-30"},null,null,{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(X$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(X6,0),\nIF($P$6=Lists!$I$7,EOMONTH(X6,2-(MONTH(X6)-1-3*INT((MONTH(X6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(X6,11),\nIF($P$6=Lists!$I$9,EOMONTH(X6,12-MONTH(X6)),\"\"))))))","v":"2021-12-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(Y$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(Y6,0),\nIF($P$6=Lists!$I$7,EOMONTH(Y6,2-(MONTH(Y6)-1-3*INT((MONTH(Y6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(Y6,11),\nIF($P$6=Lists!$I$9,EOMONTH(Y6,12-MONTH(Y6)),\"\"))))))","v":"2022-01-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(Z$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(Z6,0),\nIF($P$6=Lists!$I$7,EOMONTH(Z6,2-(MONTH(Z6)-1-3*INT((MONTH(Z6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(Z6,11),\nIF($P$6=Lists!$I$9,EOMONTH(Z6,12-MONTH(Z6)),\"\"))))))","v":"2022-02-28"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AA$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AA6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AA6,2-(MONTH(AA6)-1-3*INT((MONTH(AA6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AA6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AA6,12-MONTH(AA6)),\"\"))))))","v":"2022-03-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AB$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AB6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AB6,2-(MONTH(AB6)-1-3*INT((MONTH(AB6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AB6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AB6,12-MONTH(AB6)),\"\"))))))","v":"2022-04-30"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AC$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AC6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AC6,2-(MONTH(AC6)-1-3*INT((MONTH(AC6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AC6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AC6,12-MONTH(AC6)),\"\"))))))","v":"2022-05-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AD$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AD6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AD6,2-(MONTH(AD6)-1-3*INT((MONTH(AD6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AD6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AD6,12-MONTH(AD6)),\"\"))))))","v":"2022-06-30"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AE$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AE6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AE6,2-(MONTH(AE6)-1-3*INT((MONTH(AE6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AE6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AE6,12-MONTH(AE6)),\"\"))))))","v":"2022-07-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AF$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AF6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AF6,2-(MONTH(AF6)-1-3*INT((MONTH(AF6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AF6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AF6,12-MONTH(AF6)),\"\"))))))","v":"2022-08-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AG$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AG6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AG6,2-(MONTH(AG6)-1-3*INT((MONTH(AG6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AG6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AG6,12-MONTH(AG6)),\"\"))))))","v":"2022-09-30"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AH$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AH6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AH6,2-(MONTH(AH6)-1-3*INT((MONTH(AH6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AH6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AH6,12-MONTH(AH6)),\"\"))))))","v":"2022-10-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AI$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AI6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AI6,2-(MONTH(AI6)-1-3*INT((MONTH(AI6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AI6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AI6,12-MONTH(AI6)),\"\"))))))","v":"2022-11-30"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AJ$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AJ6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AJ6,2-(MONTH(AJ6)-1-3*INT((MONTH(AJ6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AJ6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AJ6,12-MONTH(AJ6)),\"\"))))))","v":"2022-12-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AK$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AK6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AK6,2-(MONTH(AK6)-1-3*INT((MONTH(AK6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AK6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AK6,12-MONTH(AK6)),\"\"))))))","v":"2023-01-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AL$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AL6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AL6,2-(MONTH(AL6)-1-3*INT((MONTH(AL6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AL6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AL6,12-MONTH(AL6)),\"\"))))))","v":"2023-02-28"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AM$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AM6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AM6,2-(MONTH(AM6)-1-3*INT((MONTH(AM6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AM6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AM6,12-MONTH(AM6)),\"\"))))))","v":"2023-03-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AN$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AN6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AN6,2-(MONTH(AN6)-1-3*INT((MONTH(AN6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AN6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AN6,12-MONTH(AN6)),\"\"))))))","v":"2023-04-30"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AO$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AO6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AO6,2-(MONTH(AO6)-1-3*INT((MONTH(AO6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AO6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AO6,12-MONTH(AO6)),\"\"))))))","v":"2023-05-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AP$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AP6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AP6,2-(MONTH(AP6)-1-3*INT((MONTH(AP6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AP6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AP6,12-MONTH(AP6)),\"\"))))))","v":"2023-06-30"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AQ$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AQ6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AQ6,2-(MONTH(AQ6)-1-3*INT((MONTH(AQ6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AQ6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AQ6,12-MONTH(AQ6)),\"\"))))))","v":"2023-07-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AR$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AR6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AR6,2-(MONTH(AR6)-1-3*INT((MONTH(AR6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AR6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AR6,12-MONTH(AR6)),\"\"))))))","v":"2023-08-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AS$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AS6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AS6,2-(MONTH(AS6)-1-3*INT((MONTH(AS6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AS6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AS6,12-MONTH(AS6)),\"\"))))))","v":"2023-09-30"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AT$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AT6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AT6,2-(MONTH(AT6)-1-3*INT((MONTH(AT6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AT6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AT6,12-MONTH(AT6)),\"\"))))))","v":"2023-10-31"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AU$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AU6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AU6,2-(MONTH(AU6)-1-3*INT((MONTH(AU6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AU6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AU6,12-MONTH(AU6)),\"\"))))))","v":"2023-11-30"},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AV$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AV6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AV6,2-(MONTH(AV6)-1-3*INT((MONTH(AV6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AV6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AV6,12-MONTH(AV6)),\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AW$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AW6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AW6,2-(MONTH(AW6)-1-3*INT((MONTH(AW6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AW6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AW6,12-MONTH(AW6)),\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AX$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AX6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AX6,2-(MONTH(AX6)-1-3*INT((MONTH(AX6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AX6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AX6,12-MONTH(AX6)),\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AY$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AY6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AY6,2-(MONTH(AY6)-1-3*INT((MONTH(AY6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AY6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AY6,12-MONTH(AY6)),\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(AZ$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(AZ6,0),\nIF($P$6=Lists!$I$7,EOMONTH(AZ6,2-(MONTH(AZ6)-1-3*INT((MONTH(AZ6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(AZ6,11),\nIF($P$6=Lists!$I$9,EOMONTH(AZ6,12-MONTH(AZ6)),\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(BA$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(BA6,0),\nIF($P$6=Lists!$I$7,EOMONTH(BA6,2-(MONTH(BA6)-1-3*INT((MONTH(BA6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(BA6,11),\nIF($P$6=Lists!$I$9,EOMONTH(BA6,12-MONTH(BA6)),\"\"))))))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(BB$8=\"\",\"\",\nIF($P$6=Lists!$I$6,EOMONTH(BB6,0),\nIF($P$6=Lists!$I$7,EOMONTH(BB6,2-(MONTH(BB6)-1-3*INT((MONTH(BB6)-1)/3))),\nIF($P$6=Lists!$I$8,EOMONTH(BB6,11),\nIF($P$6=Lists!$I$9,EOMONTH(BB6,12-MONTH(BB6)),\"\"))))))","v":""}]
[null,{"$f":"ROW()","v":8},null,null,null,null,null,"горизонт моделирования","горизонт моделирования",null,null,null,"кол-во пер.",null,"*",24,null,null,null,null,{"$f":"MAX(INDIRECT(ADDRESS($B8,X$2)&\":\"&ADDRESS($B8,MAX($2:$2))))","v":24},null,null,{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:W8)+1>$P$8,\"\",MAX($W8:W8)+1))","v":1},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:X8)+1>$P$8,\"\",MAX($W8:X8)+1))","v":2},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:Y8)+1>$P$8,\"\",MAX($W8:Y8)+1))","v":3},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:Z8)+1>$P$8,\"\",MAX($W8:Z8)+1))","v":4},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AA8)+1>$P$8,\"\",MAX($W8:AA8)+1))","v":5},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AB8)+1>$P$8,\"\",MAX($W8:AB8)+1))","v":6},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AC8)+1>$P$8,\"\",MAX($W8:AC8)+1))","v":7},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AD8)+1>$P$8,\"\",MAX($W8:AD8)+1))","v":8},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AE8)+1>$P$8,\"\",MAX($W8:AE8)+1))","v":9},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AF8)+1>$P$8,\"\",MAX($W8:AF8)+1))","v":10},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AG8)+1>$P$8,\"\",MAX($W8:AG8)+1))","v":11},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AH8)+1>$P$8,\"\",MAX($W8:AH8)+1))","v":12},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AI8)+1>$P$8,\"\",MAX($W8:AI8)+1))","v":13},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AJ8)+1>$P$8,\"\",MAX($W8:AJ8)+1))","v":14},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AK8)+1>$P$8,\"\",MAX($W8:AK8)+1))","v":15},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AL8)+1>$P$8,\"\",MAX($W8:AL8)+1))","v":16},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AM8)+1>$P$8,\"\",MAX($W8:AM8)+1))","v":17},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AN8)+1>$P$8,\"\",MAX($W8:AN8)+1))","v":18},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AO8)+1>$P$8,\"\",MAX($W8:AO8)+1))","v":19},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AP8)+1>$P$8,\"\",MAX($W8:AP8)+1))","v":20},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AQ8)+1>$P$8,\"\",MAX($W8:AQ8)+1))","v":21},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AR8)+1>$P$8,\"\",MAX($W8:AR8)+1))","v":22},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AS8)+1>$P$8,\"\",MAX($W8:AS8)+1))","v":23},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AT8)+1>$P$8,\"\",MAX($W8:AT8)+1))","v":24},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AU8)+1>$P$8,\"\",MAX($W8:AU8)+1))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AV8)+1>$P$8,\"\",MAX($W8:AV8)+1))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AW8)+1>$P$8,\"\",MAX($W8:AW8)+1))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AX8)+1>$P$8,\"\",MAX($W8:AX8)+1))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AY8)+1>$P$8,\"\",MAX($W8:AY8)+1))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:AZ8)+1>$P$8,\"\",MAX($W8:AZ8)+1))","v":""},{"$f":"IF(OR($P$6=\"\",$P$6=0,$P$7=\"\",$P$7=0,$P$8=\"\",$P$7<1),\"\",\nIF(MAX($W8:BA8)+1>$P$8,\"\",MAX($W8:BA8)+1))","v":""}]
[null,{"$f":"ROW()","v":9}]
[null,{"$f":"ROW()","v":10},null,null,null,null,null,null,null,null,null,null,null,null,"название сохраняемого сценария:"]
[null,{"$f":"ROW()","v":11},null,null,null,null,null,{"$f":"Lists!$S$10","v":"доход"},null,null,null,null,{"$f":"Lists!$S$25","v":"руб."},null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(ADDRESS($B11,X$2)&\":\"&ADDRESS($B11,MAX($2:$2))))","v":16200000},null,null,{"$f":"IF(X$4=\"\",0,IF(X$8=1,$P12,W11+$P13))","v":100000},{"$f":"IF(Y$4=\"\",0,IF(Y$8=1,$P12,X11+$P13))","v":150000},200000,250000,300000,350000,400000,{"$f":"IF(AE$4=\"\",0,IF(AE$8=1,$P12,AD11+$P13))","v":450000},{"$f":"IF(AF$4=\"\",0,IF(AF$8=1,$P12,AE11+$P13))","v":500000},{"$f":"IF(AG$4=\"\",0,IF(AG$8=1,$P12,AF11+$P13))","v":550000},{"$f":"IF(AH$4=\"\",0,IF(AH$8=1,$P12,AG11+$P13))","v":600000},{"$f":"IF(AI$4=\"\",0,IF(AI$8=1,$P12,AH11+$P13))","v":650000},{"$f":"IF(AJ$4=\"\",0,IF(AJ$8=1,$P12,AI11+$P13))","v":700000},{"$f":"IF(AK$4=\"\",0,IF(AK$8=1,$P12,AJ11+$P13))","v":750000},{"$f":"IF(AL$4=\"\",0,IF(AL$8=1,$P12,AK11+$P13))","v":800000},{"$f":"IF(AM$4=\"\",0,IF(AM$8=1,$P12,AL11+$P13))","v":850000},{"$f":"IF(AN$4=\"\",0,IF(AN$8=1,$P12,AM11+$P13))","v":900000},{"$f":"IF(AO$4=\"\",0,IF(AO$8=1,$P12,AN11+$P13))","v":950000},{"$f":"IF(AP$4=\"\",0,IF(AP$8=1,$P12,AO11+$P13))","v":1000000},{"$f":"IF(AQ$4=\"\",0,IF(AQ$8=1,$P12,AP11+$P13))","v":1050000},{"$f":"IF(AR$4=\"\",0,IF(AR$8=1,$P12,AQ11+$P13))","v":1100000},{"$f":"IF(AS$4=\"\",0,IF(AS$8=1,$P12,AR11+$P13))","v":1150000},{"$f":"IF(AT$4=\"\",0,IF(AT$8=1,$P12,AS11+$P13))","v":1200000},{"$f":"IF(AU$4=\"\",0,IF(AU$8=1,$P12,AT11+$P13))","v":1250000},{"$f":"IF(AV$4=\"\",0,IF(AV$8=1,$P12,AU11+$P13))","v":0},{"$f":"IF(AW$4=\"\",0,IF(AW$8=1,$P12,AV11+$P13))","v":0},{"$f":"IF(AX$4=\"\",0,IF(AX$8=1,$P12,AW11+$P13))","v":0},{"$f":"IF(AY$4=\"\",0,IF(AY$8=1,$P12,AX11+$P13))","v":0},{"$f":"IF(AZ$4=\"\",0,IF(AZ$8=1,$P12,AY11+$P13))","v":0},{"$f":"IF(BA$4=\"\",0,IF(BA$8=1,$P12,AZ11+$P13))","v":0},{"$f":"IF(BB$4=\"\",0,IF(BB$8=1,$P12,BA11+$P13))","v":0}]
[null,{"$f":"ROW()","v":12},null,null,null,null,null,{"$f":"H11","v":"доход"},{"$f":"Lists!$S$11","v":"размер дохода в начальный период"},null,null,null,{"$f":"Lists!$S$25","v":"руб."},null,"*",100000]
[null,{"$f":"ROW()","v":13},null,null,null,null,null,{"$f":"H11","v":"доход"},{"$f":"Lists!$S$12","v":"прирост дохода период-к-периоду"},null,null,null,{"$f":"Lists!$S$25","v":"руб."},null,"*",50000]
[null,{"$f":"ROW()","v":14}]
[null,{"$f":"ROW()","v":15},null,null,null,null,null,{"$f":"Lists!$S$13","v":"себестоимость"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(ADDRESS($B15,X$2)&\":\"&ADDRESS($B15,MAX($2:$2))))","v":10530000},null,null,{"$f":"IF(X$4=\"\",0,X$11*(1-$P16))","v":65000},{"$f":"IF(Y$4=\"\",0,Y$11*(1-$P16))","v":97500},130000,162500,195000,227500,260000,{"$f":"IF(AE$4=\"\",0,AE$11*(1-$P16))","v":292500},{"$f":"IF(AF$4=\"\",0,AF$11*(1-$P16))","v":325000},{"$f":"IF(AG$4=\"\",0,AG$11*(1-$P16))","v":357500},{"$f":"IF(AH$4=\"\",0,AH$11*(1-$P16))","v":390000},{"$f":"IF(AI$4=\"\",0,AI$11*(1-$P16))","v":422500},{"$f":"IF(AJ$4=\"\",0,AJ$11*(1-$P16))","v":455000},{"$f":"IF(AK$4=\"\",0,AK$11*(1-$P16))","v":487500},{"$f":"IF(AL$4=\"\",0,AL$11*(1-$P16))","v":520000},{"$f":"IF(AM$4=\"\",0,AM$11*(1-$P16))","v":552500},{"$f":"IF(AN$4=\"\",0,AN$11*(1-$P16))","v":585000},{"$f":"IF(AO$4=\"\",0,AO$11*(1-$P16))","v":617500},{"$f":"IF(AP$4=\"\",0,AP$11*(1-$P16))","v":650000},{"$f":"IF(AQ$4=\"\",0,AQ$11*(1-$P16))","v":682500},{"$f":"IF(AR$4=\"\",0,AR$11*(1-$P16))","v":715000},{"$f":"IF(AS$4=\"\",0,AS$11*(1-$P16))","v":747500},{"$f":"IF(AT$4=\"\",0,AT$11*(1-$P16))","v":780000},{"$f":"IF(AU$4=\"\",0,AU$11*(1-$P16))","v":812500},{"$f":"IF(AV$4=\"\",0,AV$11*(1-$P16))","v":0},{"$f":"IF(AW$4=\"\",0,AW$11*(1-$P16))","v":0},{"$f":"IF(AX$4=\"\",0,AX$11*(1-$P16))","v":0},{"$f":"IF(AY$4=\"\",0,AY$11*(1-$P16))","v":0},{"$f":"IF(AZ$4=\"\",0,AZ$11*(1-$P16))","v":0},{"$f":"IF(BA$4=\"\",0,BA$11*(1-$P16))","v":0},{"$f":"IF(BB$4=\"\",0,BB$11*(1-$P16))","v":0}]
[null,{"$f":"ROW()","v":16},null,null,null,null,null,{"$f":"H15","v":"себестоимость"},{"$f":"Lists!$S$14","v":"рентабельность продаж"},null,null,null,"%",null,"*",0.35]
[null,{"$f":"ROW()","v":17}]
[null,{"$f":"ROW()","v":18},null,null,null,null,null,{"$f":"Lists!$S$15","v":"чистый доход"},null,null,null,null,{"$f":"Lists!$S$25","v":"руб."},null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(ADDRESS($B18,X$2)&\":\"&ADDRESS($B18,MAX($2:$2))))","v":5670000},null,null,{"$f":"IF(X$4=\"\",0,X11-X15)","v":35000},{"$f":"IF(Y$4=\"\",0,Y11-Y15)","v":52500},70000,87500,105000,122500,140000,{"$f":"IF(AE$4=\"\",0,AE11-AE15)","v":157500},175000,192500,210000,227500,245000,262500,280000,297500,315000,332500,350000,367500,385000,402500,420000,437500,0,0,0,0,0,0,0]
[null,{"$f":"ROW()","v":19}]
[null,{"$f":"ROW()","v":20},null,null,null,null,null,{"$f":"Lists!$S$17","v":"переменные расходы"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(ADDRESS($B20,X$2)&\":\"&ADDRESS($B20,MAX($2:$2))))","v":1620000},null,null,{"$f":"IF(X$4=\"\",0,X$11*$P21)","v":10000},{"$f":"IF(Y$4=\"\",0,Y$11*$P21)","v":15000},20000,25000,30000,35000,40000,{"$f":"IF(AE$4=\"\",0,AE$11*$P21)","v":45000},{"$f":"IF(AF$4=\"\",0,AF$11*$P21)","v":50000},{"$f":"IF(AG$4=\"\",0,AG$11*$P21)","v":55000},{"$f":"IF(AH$4=\"\",0,AH$11*$P21)","v":60000},{"$f":"IF(AI$4=\"\",0,AI$11*$P21)","v":65000},{"$f":"IF(AJ$4=\"\",0,AJ$11*$P21)","v":70000},{"$f":"IF(AK$4=\"\",0,AK$11*$P21)","v":75000},{"$f":"IF(AL$4=\"\",0,AL$11*$P21)","v":80000},{"$f":"IF(AM$4=\"\",0,AM$11*$P21)","v":85000},{"$f":"IF(AN$4=\"\",0,AN$11*$P21)","v":90000},{"$f":"IF(AO$4=\"\",0,AO$11*$P21)","v":95000},{"$f":"IF(AP$4=\"\",0,AP$11*$P21)","v":100000},{"$f":"IF(AQ$4=\"\",0,AQ$11*$P21)","v":105000},{"$f":"IF(AR$4=\"\",0,AR$11*$P21)","v":110000},{"$f":"IF(AS$4=\"\",0,AS$11*$P21)","v":115000},{"$f":"IF(AT$4=\"\",0,AT$11*$P21)","v":120000},{"$f":"IF(AU$4=\"\",0,AU$11*$P21)","v":125000},{"$f":"IF(AV$4=\"\",0,AV$11*$P21)","v":0},{"$f":"IF(AW$4=\"\",0,AW$11*$P21)","v":0},{"$f":"IF(AX$4=\"\",0,AX$11*$P21)","v":0},{"$f":"IF(AY$4=\"\",0,AY$11*$P21)","v":0},{"$f":"IF(AZ$4=\"\",0,AZ$11*$P21)","v":0},{"$f":"IF(BA$4=\"\",0,BA$11*$P21)","v":0},{"$f":"IF(BB$4=\"\",0,BB$11*$P21)","v":0}]
[null,{"$f":"ROW()","v":21},null,null,null,null,null,{"$f":"H20","v":"переменные расходы"},{"$f":"Lists!$W$16","v":"% от дохода"},null,null,null,"%",null,"*",0.1]
[null,{"$f":"ROW()","v":22}]
[null,{"$f":"ROW()","v":23},null,null,null,null,null,{"$f":"Lists!$S$19","v":"маржинальная прибыль"},null,null,null,null,{"$f":"Lists!$S$25","v":"руб."},null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(ADDRESS($B23,X$2)&\":\"&ADDRESS($B23,MAX($2:$2))))","v":4050000},null,null,{"$f":"IF(X$4=\"\",0,X18-X20)","v":25000},{"$f":"IF(Y$4=\"\",0,Y18-Y20)","v":37500},50000,62500,75000,87500,100000,{"$f":"IF(AE$4=\"\",0,AE18-AE20)","v":112500},125000,137500,150000,162500,175000,187500,200000,212500,225000,237500,250000,262500,275000,287500,300000,312500,0,0,0,0,0,0,0]
[null,{"$f":"ROW()","v":24}]
[null,{"$f":"ROW()","v":25},null,null,null,null,null,{"$f":"Lists!$S$21","v":"постоянные расходы"},null,null,null,null,{"$f":"Lists!$S$25","v":"руб."},null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(ADDRESS($B25,X$2)&\":\"&ADDRESS($B25,MAX($2:$2))))","v":2400000},null,null,{"$f":"IF(X$4=\"\",0,$P26*((12*(YEAR(X$7)-1)+MONTH(X$7))-(12*(YEAR(X$6)-1)+MONTH(X$6))+1))","v":100000},{"$f":"IF(Y$4=\"\",0,$P26*((12*(YEAR(Y$7)-1)+MONTH(Y$7))-(12*(YEAR(Y$6)-1)+MONTH(Y$6))+1))","v":100000},100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,0,0,0,0,0,0,0]
[null,{"$f":"ROW()","v":26},null,null,null,null,null,{"$f":"H25","v":"постоянные расходы"},{"$f":"Lists!$S$18","v":"размер расхода в месяц"},null,null,null,{"$f":"Lists!$S$25","v":"руб."},null,"*",100000]
[null,{"$f":"ROW()","v":27}]
[null,{"$f":"ROW()","v":28},null,null,null,null,null,{"$f":"Lists!$S$23","v":"EBITDA"},null,null,null,null,{"$f":"Lists!$S$25","v":"руб."},null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(ADDRESS($B28,X$2)&\":\"&ADDRESS($B28,MAX($2:$2))))","v":1650000},null,null,{"$f":"IF(X$4=\"\",0,X23-X25)","v":-75000},{"$f":"IF(Y$4=\"\",0,Y23-Y25)","v":-62500},-50000,-37500,-25000,-12500,0,{"$f":"IF(AE$4=\"\",0,AE23-AE25)","v":12500},25000,37500,50000,62500,75000,87500,100000,112500,125000,137500,150000,162500,175000,187500,200000,212500,0,0,0,0,0,0,0]
[null,{"$f":"ROW()","v":29}]
[null,{"$f":"ROW()","v":30}]
[null,{"$f":"ROW()","v":31}]
[null,{"$f":"ROW()","v":32}]
[null,{"$f":"ROW()","v":33}]
[null,{"$f":"ROW()","v":34}]
[null,{"$f":"ROW()","v":35}]
[null,{"$f":"ROW()","v":36}]
[null,{"$f":"ROW()","v":37}]
[null,{"$f":"ROW()","v":38}]
[null,{"$f":"ROW()","v":39}]
[null,{"$f":"ROW()","v":40}]
[null,{"$f":"ROW()","v":41}]
[null,{"$f":"ROW()","v":42}]
[null,{"$f":"ROW()","v":43}]
[null,{"$f":"ROW()","v":44}]
[null,{"$f":"ROW()","v":45}]
[null,{"$f":"ROW()","v":46}]
[null,{"$f":"ROW()","v":47}]

{"sheet":"SCENARIOS","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"№","параметр (вводные данные)",null,"сценарии:","текущий сценарий"]
[null,1,{"$f":"Model!I12","v":"размер дохода в начальный период"},null,null,{"$f":"Model!$P$12","v":100000}]
[null,2,{"$f":"Model!I13","v":"прирост дохода период-к-периоду"},null,null,{"$f":"Model!$P$13","v":50000}]
[null,3,{"$f":"Model!I16","v":"рентабельность продаж"},null,null,{"$f":"Model!$P$16","v":0.35}]
[null,4,{"$f":"Model!I21","v":"% от дохода"},null,null,{"$f":"Model!$P$21","v":0.1}]
[null,5,{"$f":"Model!I26","v":"размер расхода в месяц"},null,null,{"$f":"Model!$P$26","v":100000}]
[]
[null,null,"результаты"]
[null,null,{"$f":"Model!H11","v":"доход"},null,null,{"$f":"Model!$U$11","v":16200000}]
[null,null,{"$f":"Model!H28","v":"EBITDA"},null,null,{"$f":"Model!$U$28","v":1650000}]

{"sheet":"Lists","index":2,"n_rows":47,"n_cols":29,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,{"$f":"COLUMN()","v":9},null,null,null,null,{"$f":"COLUMN()","v":14},null,null,null,null,{"$f":"COLUMN()","v":19},null,null,null,{"$f":"COLUMN()","v":23},null,null,null,{"$f":"COLUMN()","v":27}]
[null,null,null,null,null,null,null,null,{"$f":"LEFT(ADDRESS(1,I1,4),(LEN(ADDRESS(1,I1,4))-1))","v":"I"},null,null,null,null,{"$f":"LEFT(ADDRESS(1,N1,4),(LEN(ADDRESS(1,N1,4))-1))","v":"N"},null,null,null,null,{"$f":"LEFT(ADDRESS(1,S1,4),(LEN(ADDRESS(1,S1,4))-1))","v":"S"},null,null,null,{"$f":"LEFT(ADDRESS(1,W1,4),(LEN(ADDRESS(1,W1,4))-1))","v":"W"},null,null,null,{"$f":"LEFT(ADDRESS(1,AA1,4),(LEN(ADDRESS(1,AA1,4))-1))","v":"AA"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"$S$26","v":"минимальный период расчетов"},null,null,null,null,{"$f":"$S$27","v":"старт моделирования"},null,null,null,null,"названия",null,null,null,"названия на русском",null,null,null,"названия на английском"]
[{"$f":"ROW()","v":5},null,null,null,null,null,null,null,{"$f":"\"Lists!\"&I$2&$A6&\":\"&I$2&($A5+MAX(J:J))","v":"Lists!I6:I9"},null,null,null,null,{"$f":"\"Lists!\"&N$2&$A6&\":\"&N$2&($A5+MAX(O:O))","v":"Lists!N6:N29"},null,null,null,null,{"$f":"\"Lists!\"&S$2&$A6&\":\"&S$2&($A5+MAX(T:T))","v":"Lists!S6:S27"},null,null,null,{"$f":"\"Lists!\"&W$2&$A6&\":\"&W$2&($A5+MAX(X:X))","v":"Lists!W6:W27"},null,null,null,{"$f":"\"Lists!\"&AA$2&$A6&\":\"&AA$2&($A5+MAX(AB:AB))","v":"Lists!AA6:AA27"}]
[{"$f":"ROW()","v":6},null,null,null,null,null,null,"*","месяц",{"$f":"MAX(J$5:J5)+1","v":1},{"$f":"IF(AND(I6=\"\",J6<>0),1,IF(COUNTIF(I:I,I6)<>1,1,0))","v":0},null,"*",{"$f":"EOMONTH(TODAY(),0)+1","v":"2022-01-01"},{"$f":"MAX(O$5:O5)+1","v":1},{"$f":"IF(AND(N6=\"\",O6<>0),1,IF(COUNTIF(N:N,N6)<>1,1,0))","v":0},null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA6,Lists!$W6)","v":"показатель"},{"$f":"MAX(T$5:T5)+1","v":1},{"$f":"IF(AND(S6=\"\",T6<>0),1,IF(COUNTIF(S:S,S6)<>1,1,0))","v":0},"*","показатель",{"$f":"MAX(X$5:X5)+1","v":1},{"$f":"IF(AND(W6=\"\",X6<>0),1,IF(COUNTIF(W:W,W6)<>1,1,0))","v":0},"*","indicator",{"$f":"MAX(AB$5:AB5)+1","v":1},{"$f":"IF(AND(AA6=\"\",AB6<>0),1,IF(COUNTIF(AA:AA,AA6)<>1,1,0))","v":0}]
[{"$f":"ROW()","v":7},null,null,null,null,null,null,"*","квартал",{"$f":"MAX(J$5:J6)+1","v":2},{"$f":"IF(AND(I7=\"\",J7<>0),1,IF(COUNTIF(I:I,I7)<>1,1,0))","v":0},null,null,{"$f":"EOMONTH(N6,0)+1","v":"2022-02-01"},{"$f":"MAX(O$5:O6)+1","v":2},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA7,Lists!$W7)","v":"ед.изм."},{"$f":"MAX(T$5:T6)+1","v":2},{"$f":"IF(AND(S7=\"\",T7<>0),1,IF(COUNTIF(S:S,S7)<>1,1,0))","v":0},"*","ед.изм.",{"$f":"MAX(X$5:X6)+1","v":2},{"$f":"IF(AND(W7=\"\",X7<>0),1,IF(COUNTIF(W:W,W7)<>1,1,0))","v":0},"*","unit change",{"$f":"MAX(AB$5:AB6)+1","v":2},{"$f":"IF(AND(AA7=\"\",AB7<>0),1,IF(COUNTIF(AA:AA,AA7)<>1,1,0))","v":0}]
[{"$f":"ROW()","v":8},null,null,null,null,null,null,"*","год текущий",{"$f":"MAX(J$5:J7)+1","v":3},{"$f":"IF(AND(I8=\"\",J8<>0),1,IF(COUNTIF(I:I,I8)<>1,1,0))","v":0},null,null,{"$f":"EOMONTH(N7,0)+1","v":"2022-03-01"},{"$f":"MAX(O$5:O7)+1","v":3},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA8,Lists!$W8)","v":"значение"},{"$f":"MAX(T$5:T7)+1","v":3},{"$f":"IF(AND(S8=\"\",T8<>0),1,IF(COUNTIF(S:S,S8)<>1,1,0))","v":0},"*","значение",{"$f":"MAX(X$5:X7)+1","v":3},{"$f":"IF(AND(W8=\"\",X8<>0),1,IF(COUNTIF(W:W,W8)<>1,1,0))","v":0},"*","value",{"$f":"MAX(AB$5:AB7)+1","v":3},{"$f":"IF(AND(AA8=\"\",AB8<>0),1,IF(COUNTIF(AA:AA,AA8)<>1,1,0))","v":0}]
[{"$f":"ROW()","v":9},null,null,null,null,null,null,"*","год календарный",{"$f":"MAX(J$5:J8)+1","v":4},{"$f":"IF(AND(I9=\"\",J9<>0),1,IF(COUNTIF(I:I,I9)<>1,1,0))","v":0},null,null,"2022-04-01",{"$f":"MAX(O$5:O8)+1","v":4},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA9,Lists!$W9)","v":"итого"},{"$f":"MAX(T$5:T8)+1","v":4},{"$f":"IF(AND(S9=\"\",T9<>0),1,IF(COUNTIF(S:S,S9)<>1,1,0))","v":0},"*","итого",{"$f":"MAX(X$5:X8)+1","v":4},{"$f":"IF(AND(W9=\"\",X9<>0),1,IF(COUNTIF(W:W,W9)<>1,1,0))","v":0},"*","total",{"$f":"MAX(AB$5:AB8)+1","v":4},{"$f":"IF(AND(AA9=\"\",AB9<>0),1,IF(COUNTIF(AA:AA,AA9)<>1,1,0))","v":0}]
[{"$f":"ROW()","v":10},null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",{"$f":"MAX(O$5:O9)+1","v":5},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA10,Lists!$W10)","v":"доход"},{"$f":"MAX(T$5:T9)+1","v":5},{"$f":"IF(AND(S10=\"\",T10<>0),1,IF(COUNTIF(S:S,S10)<>1,1,0))","v":0},"*","доход",{"$f":"MAX(X$5:X9)+1","v":5},{"$f":"IF(AND(W10=\"\",X10<>0),1,IF(COUNTIF(W:W,W10)<>1,1,0))","v":0},"*","income",{"$f":"MAX(AB$5:AB9)+1","v":5},{"$f":"IF(AND(AA10=\"\",AB10<>0),1,IF(COUNTIF(AA:AA,AA10)<>1,1,0))","v":0}]
[{"$f":"ROW()","v":11},null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01",{"$f":"MAX(O$5:O10)+1","v":6},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA11,Lists!$W11)","v":"размер дохода в начальный период"},{"$f":"MAX(T$5:T10)+1","v":6},0,"*","размер дохода в начальный период",{"$f":"MAX(X$5:X10)+1","v":6},0,"*","amount of income in the initial period income",{"$f":"MAX(AB$5:AB10)+1","v":6},0]
[{"$f":"ROW()","v":12},null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",{"$f":"MAX(O$5:O11)+1","v":7},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA12,Lists!$W12)","v":"прирост дохода период-к-периоду"},{"$f":"MAX(T$5:T11)+1","v":7},0,"*","прирост дохода период-к-периоду",{"$f":"MAX(X$5:X11)+1","v":7},0,"*","growth period-to-period",{"$f":"MAX(AB$5:AB11)+1","v":7},0]
[{"$f":"ROW()","v":13},null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-01",{"$f":"MAX(O$5:O12)+1","v":8},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA13,Lists!$W13)","v":"себестоимость"},{"$f":"MAX(T$5:T12)+1","v":8},0,"*","себестоимость",{"$f":"MAX(X$5:X12)+1","v":8},0,"*","cost of sales",{"$f":"MAX(AB$5:AB12)+1","v":8},0]
[{"$f":"ROW()","v":14},null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",{"$f":"MAX(O$5:O13)+1","v":9},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA14,Lists!$W14)","v":"рентабельность продаж"},{"$f":"MAX(T$5:T13)+1","v":9},0,"*","рентабельность продаж",{"$f":"MAX(X$5:X13)+1","v":9},0,"*","return on sales",{"$f":"MAX(AB$5:AB13)+1","v":9},0]
[{"$f":"ROW()","v":15},null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",{"$f":"MAX(O$5:O14)+1","v":10},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA15,Lists!$W15)","v":"чистый доход"},{"$f":"MAX(T$5:T14)+1","v":10},0,"*","чистый доход",{"$f":"MAX(X$5:X14)+1","v":10},0,"*","net income",{"$f":"MAX(AB$5:AB14)+1","v":10},0]
[{"$f":"ROW()","v":16},null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",{"$f":"MAX(O$5:O15)+1","v":11},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA16,Lists!$W16)","v":"% от дохода"},{"$f":"MAX(T$5:T15)+1","v":11},0,"*","% от дохода",{"$f":"MAX(X$5:X15)+1","v":11},0,"*","% of income",{"$f":"MAX(AB$5:AB15)+1","v":11},0]
[{"$f":"ROW()","v":17},null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",{"$f":"MAX(O$5:O16)+1","v":12},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA17,Lists!$W17)","v":"переменные расходы"},{"$f":"MAX(T$5:T16)+1","v":12},0,"*","переменные расходы",{"$f":"MAX(X$5:X16)+1","v":12},0,"*","variable expenses",{"$f":"MAX(AB$5:AB16)+1","v":12},0]
[{"$f":"ROW()","v":18},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(N17,0)+1","v":"2023-01-01"},{"$f":"MAX(O$5:O17)+1","v":13},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA18,Lists!$W18)","v":"размер расхода в месяц"},{"$f":"MAX(T$5:T17)+1","v":13},0,"*","размер расхода в месяц",{"$f":"MAX(X$5:X17)+1","v":13},0,"*","monthly expense amount",{"$f":"MAX(AB$5:AB17)+1","v":13},0]
[{"$f":"ROW()","v":19},null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",{"$f":"MAX(O$5:O18)+1","v":14},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA19,Lists!$W19)","v":"маржинальная прибыль"},{"$f":"MAX(T$5:T18)+1","v":14},0,"*","маржинальная прибыль",{"$f":"MAX(X$5:X18)+1","v":14},0,"*","marginal profit",{"$f":"MAX(AB$5:AB18)+1","v":14},0]
[{"$f":"ROW()","v":20},null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",{"$f":"MAX(O$5:O19)+1","v":15},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA20,Lists!$W20)","v":"тип периода"},{"$f":"MAX(T$5:T19)+1","v":15},0,"*","тип периода",{"$f":"MAX(X$5:X19)+1","v":15},0,"*"," period type",{"$f":"MAX(AB$5:AB19)+1","v":15},0]
[{"$f":"ROW()","v":21},null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",{"$f":"MAX(O$5:O20)+1","v":16},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA21,Lists!$W21)","v":"постоянные расходы"},{"$f":"MAX(T$5:T20)+1","v":16},0,"*","постоянные расходы",{"$f":"MAX(X$5:X20)+1","v":16},0,"*","fixed expenses",{"$f":"MAX(AB$5:AB20)+1","v":16},0]
[{"$f":"ROW()","v":22},null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",{"$f":"MAX(O$5:O21)+1","v":17},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA22,Lists!$W22)","v":"месяц"},{"$f":"MAX(T$5:T21)+1","v":17},0,"*","месяц",{"$f":"MAX(X$5:X21)+1","v":17},0,"*","month",{"$f":"MAX(AB$5:AB21)+1","v":17},0]
[{"$f":"ROW()","v":23},null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",{"$f":"MAX(O$5:O22)+1","v":18},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA23,Lists!$W23)","v":"EBITDA"},{"$f":"MAX(T$5:T22)+1","v":18},0,"*","EBITDA",{"$f":"MAX(X$5:X22)+1","v":18},0,"*","EBITDA",{"$f":"MAX(AB$5:AB22)+1","v":18},0]
[{"$f":"ROW()","v":24},null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01",{"$f":"MAX(O$5:O23)+1","v":19},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA24,Lists!$W24)","v":"кол-во пер."},{"$f":"MAX(T$5:T23)+1","v":19},0,"*","кол-во пер.",{"$f":"MAX(X$5:X23)+1","v":19},0,"*","number of gears.",{"$f":"MAX(AB$5:AB23)+1","v":19},0]
[{"$f":"ROW()","v":25},null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-01",{"$f":"MAX(O$5:O24)+1","v":20},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA25,Lists!$W25)","v":"руб."},{"$f":"MAX(T$5:T24)+1","v":20},0,"*","руб.",{"$f":"MAX(X$5:X24)+1","v":20},0,"*","RUR",{"$f":"MAX(AB$5:AB24)+1","v":20},0]
[{"$f":"ROW()","v":26},null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-01",{"$f":"MAX(O$5:O25)+1","v":21},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA26,Lists!$W26)","v":"минимальный период расчетов"},{"$f":"MAX(T$5:T25)+1","v":21},{"$f":"IF(AND(S26=\"\",T26<>0),1,IF(COUNTIF(S:S,S26)<>1,1,0))","v":0},"*","минимальный период расчетов",{"$f":"MAX(X$5:X25)+1","v":21},{"$f":"IF(AND(W26=\"\",X26<>0),1,IF(COUNTIF(W:W,W26)<>1,1,0))","v":0},"*","minimum calculation period",{"$f":"MAX(AB$5:AB25)+1","v":21},{"$f":"IF(AND(AA26=\"\",AB26<>0),1,IF(COUNTIF(AA:AA,AA26)<>1,1,0))","v":0}]
[{"$f":"ROW()","v":27},null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-01",{"$f":"MAX(O$5:O26)+1","v":22},0,null,null,{"$f":"IF(Model!$E$4=1,Lists!$AA27,Lists!$W27)","v":"старт моделирования"},{"$f":"MAX(T$5:T26)+1","v":22},0,"*","старт моделирования",{"$f":"MAX(X$5:X26)+1","v":22},0,"*","start of simulation",{"$f":"MAX(AB$5:AB26)+1","v":22},0]
[{"$f":"ROW()","v":28},null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-01",{"$f":"MAX(O$5:O27)+1","v":23},0]
[{"$f":"ROW()","v":29},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(N28,0)+1","v":"2023-12-01"},{"$f":"MAX(O$5:O28)+1","v":24},0]
[{"$f":"ROW()","v":30}]
[{"$f":"ROW()","v":31}]
[{"$f":"ROW()","v":32}]
[{"$f":"ROW()","v":33}]
[{"$f":"ROW()","v":34}]
[{"$f":"ROW()","v":35}]
[{"$f":"ROW()","v":36}]
[{"$f":"ROW()","v":37}]
[{"$f":"ROW()","v":38}]
[{"$f":"ROW()","v":39}]
[{"$f":"ROW()","v":40}]
[{"$f":"ROW()","v":41}]
[{"$f":"ROW()","v":42}]
[{"$f":"ROW()","v":43}]
[{"$f":"ROW()","v":44}]
[{"$f":"ROW()","v":45}]
[{"$f":"ROW()","v":46}]
[{"$f":"ROW()","v":47}]