{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Факт","План","Прибыль"],"not_rendered":{"charts":0,"images":5,"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":"Факт","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
["Месяц","Доходы","Расходы",null,"План на 2015",null,null,"Планируемая прибыль на 2015"]
["2014-01-01",265987,72313]
["2014-02-01",268848,108977]
["2014-03-01",272418,50521]
["2014-04-01",279360,55664]
["2014-05-01",414616,90731]
["2014-06-01",423060,98872]
["2014-07-01",484097,62171]
["2014-08-01",519379,77725]
["2014-09-01",544594,108353]
["2014-10-01",611830,86971]
["2014-11-01",619521,99048]
["2014-12-01",656550,111920]
["2015-01-01",680751,79764]
["2015-02-01",463293,67172]
["2015-03-01",628110,62373]
["2015-04-01",649445,73736]
["2015-05-01",548145,92135]
["2015-06-01",637617,87145]
["2015-07-01",624081,93898]
["2015-08-01",747520,55153]
["2015-09-01",359450,54436]
["2015-10-01",561449,64346]
["2015-11-01",423172,48612]
["2015-12-01",655057,54960]
["Итог:",{"$f":"SUM(B2:B25)","v":12338350},{"$f":"SUM(C2:C25)","v":1856996}]

{"sheet":"План","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Месяц","Доходы","Расходы"]
["2015-01-01",{"$f":"FORECAST(ROW(A1),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":369258.64666666673},{"$f":"FORECAST(ROW(A1),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":87934.863333333327}]
["2015-02-01",{"$f":"FORECAST(ROW(A2),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":381853.36579710152},{"$f":"FORECAST(ROW(A2),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":87016.599855072447}]
["2015-03-01",{"$f":"FORECAST(ROW(A3),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":394448.08492753631},{"$f":"FORECAST(ROW(A3),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":86098.336376811581}]
["2015-04-01",{"$f":"FORECAST(ROW(A4),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":407042.80405797105},{"$f":"FORECAST(ROW(A4),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":85180.072898550716}]
["2015-05-01",{"$f":"FORECAST(ROW(A5),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":419637.52318840584},{"$f":"FORECAST(ROW(A5),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":84261.80942028985}]
["2015-06-01",{"$f":"FORECAST(ROW(A6),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":432232.24231884064},{"$f":"FORECAST(ROW(A6),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":83343.54594202897}]
["2015-07-01",{"$f":"FORECAST(ROW(A7),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":444826.96144927543},{"$f":"FORECAST(ROW(A7),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":82425.282463768104}]
["2015-08-01",{"$f":"FORECAST(ROW(A8),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":457421.68057971017},{"$f":"FORECAST(ROW(A8),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":81507.018985507239}]
["2015-09-01",{"$f":"FORECAST(ROW(A9),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":470016.39971014496},{"$f":"FORECAST(ROW(A9),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":80588.755507246373}]
["2015-10-01",{"$f":"FORECAST(ROW(A10),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":482611.11884057976},{"$f":"FORECAST(ROW(A10),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":79670.492028985493}]
["2015-11-01",{"$f":"FORECAST(ROW(A11),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":495205.83797101455},{"$f":"FORECAST(ROW(A11),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":78752.228550724627}]
["2015-12-01",{"$f":"FORECAST(ROW(A12),Факт!$B$2:$B$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":507800.55710144935},{"$f":"FORECAST(ROW(A12),Факт!$C$2:$C$25,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24})","v":77833.965072463761}]

{"sheet":"Прибыль","index":2,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Месяц","Прибыль"]
["2015-01-01",{"$f":"((План!B2-План!B2*0.18)-План!C2)","v":214857.22693333338}]
["2015-02-01",{"$f":"((План!B3-План!B3*0.18)-План!C3)","v":226103.16009855078}]
["2015-03-01",{"$f":"((План!B4-План!B4*0.18)-План!C4)","v":237349.09326376821}]
["2015-04-01",{"$f":"((План!B5-План!B5*0.18)-План!C5)","v":248595.02642898558}]
["2015-05-01",{"$f":"((План!B6-План!B6*0.18)-План!C6)","v":259840.95959420296}]
["2015-06-01",{"$f":"((План!B7-План!B7*0.18)-План!C7)","v":271086.89275942033}]
["2015-07-01",{"$f":"((План!B8-План!B8*0.18)-План!C8)","v":282332.82592463779}]
["2015-08-01",{"$f":"((План!B9-План!B9*0.18)-План!C9)","v":293578.75908985507}]
["2015-09-01",{"$f":"((План!B10-План!B10*0.18)-План!C10)","v":304824.69225507253}]
["2015-10-01",{"$f":"((План!B11-План!B11*0.18)-План!C11)","v":316070.62542028993}]
["2015-11-01",{"$f":"((План!B12-План!B12*0.18)-План!C12)","v":327316.55858550733}]
["2015-12-01",{"$f":"((План!B13-План!B13*0.18)-План!C13)","v":338562.49175072473}]