{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["План-Факт"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":17,"n_cols":35,"rows_kept":17,"cut":false,"hidden":false,"merged":[[9,3,9,10],[10,3,14,10],[0,0,0,4],[4,3,8,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Филиал"," План"," на 01.02.18"," на 02-04.02.18"," на 05.02.18"," на 06.02.18"," на 07.02.18"," на 08.02.18"," на 09.02.18"," на 12.02.18"," на 13.02.18"," на 14.02.18"," на 15.02.18"," на 16-18.02.18"," на 19.02.17"," на 20.02.18"," на 21.02.18"," за 22.02.18"," за 23-25.02.18"," за 26.02.18"," за 27.02.18"," за 28.02.18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Свердловская область",315421.39525029005,5642,34678,34857,43138,50360,64600,91381,91381,100394,109689,116395,146030,146030,146030,0,0,0,0,0,0]
["Сводная таблица:",null,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",21193.250734643058,1159,3573,3752,4003,5029,5448,8590,8590,10371,11111,11737,16395,16395,16395,0,0,0,0,0,0]
["Филиал"," Прогноз",null,"В чем ошибка макроса ?:",null,null,null,null,null,null,null,null,null,"Курганская область",22939.612188347608,484,4781,4781,5442,6836,8651,12275,12275,13932,16254,18295,22231,22231,22231,0,0,0,0,0,0]
["Курганская область",1330213.9199999997,null,"1. Вычислемое поле с помощью макроса с помощью вспомагательных ячеек A11:A13",null,null,null,null,null,null,null,null,null,"Курганская область",7437.0004524801561,506,2294,2707,3353,4045,4903,5898,5898,6537,7958,11328,14554,14554,14554,0,0,0,0,0,0]
["Свердловская область",157976,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",6605.5376953729774,130,909,1143,1683,1889,2780,3173,3212,3365,4648,4918,6412,6434,6434,0,0,0,0,0,0]
["Общий итог",1488189.9199999997,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",30374.596050205,1735,4956,5395,8730,11435,13832,18650,19042,21267,22558,24362,29808,29808,29808,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",1610748.8844595675,38822.639999999992,178684.64000000004,180654.13999999998,225347.13999999996,287835.05999999994,439430.51,593195.1100000001,593195.1100000001,692467.97,757684.63000000024,802939.28,1018414.05,1018414.0500000003,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",361035.56558690802,385,28126,30021,48783,65665,84246,112116,112116,128590,148900,157689,187691,187691,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",190140.55554299941,1185,15646,16155,17995,23016,32577.4,43795.4,43795.4,47083.199999999997,52859.199999999997,56747.199999999997,68706.2,68706.2,0,0,0,0,0,0,0]
[{"$f":"P1","v":" на 01.02.18"},null,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",14423.858972093867,0,1451,1451,1559,1617,2510,3818.96,3818.96,3842.96,4636.96,5445.96,11393.96,11393.96,0,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",58491.020422765512,308,1396,1624,2112,3222,5310,12971,12971,24989,42263,57023,104994.4,104994.4,0,0,0,0,0,0,0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",53941.24330189827,2793,17399,17399,18468,22329,27671,46458,46458,59237,67212,78602,101100,101100,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",62864.771188113031,0,4721,5033,6731,7967,10355,16403,16403,16542,18595,18895,21275,21275,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Курганская область",168517.51239945967,0,3861,3861,8259,16855,37365,63452,63452,67771,73303,90624,136738,136738,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Число",null,1,4,5,6,7,8,9,12,13,14,15,18,19,20,21,22,25,26,27,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Сумма",null,{"$f":"SUM(P2:P15)","v":53149.639999999992},{"$f":"SUM(Q2:Q15)","v":302475.64},308833.14,395603.13999999996,508100.05999999994,739678.91,1032176.4700000001,1032607.4700000001,1196389.1299999999,1337671.7900000003,1455000.44,1885742.6099999999,1885764.61,235452,0,0,0,0,0,0]