{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Список","График","Проект","Шаблон"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Наименование проекта","Дата начала","Цена проекта, р","Срок выполнения,дней","Показатель","Коэффициент","Вывод","Дата окончания",null,{"$f":"ADDRESS(ROW(Шаблон!A1),COLUMN(Шаблон!A1))","v":"$A$1"},{"$f":"ADDRESS(ROW(Шаблон!J1),COLUMN(Шаблон!J1))","v":"$J$1"},{"$f":"ADDRESS(ROW(Шаблон!J9),COLUMN(Шаблон!J9))","v":"$J$9"},{"$f":"ADDRESS(ROW(Шаблон!J17),COLUMN(Шаблон!J17))","v":"$J$17"},{"$f":"ADDRESS(ROW(Проект!D3),COLUMN(Проект!D3))","v":"$D$3"},{"$f":"ADDRESS(ROW(Проект!F3),COLUMN(Проект!F3))","v":"$F$3"},{"$f":"ADDRESS(ROW(Шаблон!J22:J250),COLUMN(Шаблон!J22:J250))","v":"$J$22"},{"$f":"ADDRESS(ROW(Шаблон!J18),COLUMN(Шаблон!J18))","v":"$J$18"}]
["Абра кадабра","2012-05-02",250000,19,{"$f":"INDIRECT(\"'\" &LEFT(A2,31)&\"'!J16\")","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(\"'\" &LEFT(A2,31)&\"'!K16\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\" &LEFT(A2,31)&\"'!J18\")","v":{"$error":"#REF!"}}]
["sssfbfgdnb","2012-04-19",12000,5,{"$f":"INDIRECT(\"'\" &LEFT(A3,31)&\"'!J16\")","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(\"'\" &LEFT(A3,31)&\"'!K16\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\" &LEFT(A3,31)&\"'!J18\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"График","index":1,"n_rows":65,"n_cols":17,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"2012-05-01","2012-05-02",0,null,null,null,null,null,null,"Праздники"]
[null,null,null,null,null,null,null,"2012-05-06","2012-05-03",0,null,null,null,null,null,null,"2012-01-01"]
[null,null,null,null,null,null,null,"2012-05-07","2012-05-04",0,null,null,null,null,null,null,"2012-01-02"]
[null,null,null,null,null,null,null,"2012-05-08","2012-05-05",0,null,null,null,null,null,null,"2012-01-03"]
[null,null,null,null,null,null,null,"2012-05-09","2012-05-10",0,null,null,null,null,null,null,"2012-01-04"]
[null,null,null,null,null,null,null,"2012-05-13","2012-05-11",0,null,null,null,null,null,null,"2012-01-05"]
[null,null,null,null,null,null,null,"2012-05-19","2012-05-12",0,null,null,null,null,null,null,"2012-01-06"]
[null,null,null,null,null,null,null,"2012-05-20","2012-05-14",0,null,null,null,null,null,null,"2012-01-07"]
[null,null,null,null,null,null,null,"2012-05-26","2012-05-15",0,null,null,null,null,null,null,"2012-02-23"]
[null,null,null,null,null,null,null,"2012-05-27","2012-05-16",0,null,null,null,null,null,null,"2012-03-08"]
[null,null,null,null,null,null,null,"2012-06-02","2012-05-17",0,null,null,null,null,null,null,"2012-05-01"]
[null,null,null,null,null,null,null,"2012-06-03","2012-05-18",0,null,null,null,null,null,null,"2012-05-07"]
[null,null,null,null,null,null,null,"2012-06-10","2012-05-21",0,null,null,null,null,null,null,"2012-05-08"]
[null,null,null,null,null,null,null,"2012-06-11","2012-05-22",0,null,null,null,null,null,null,"2012-05-09"]
[null,null,null,null,null,null,null,"2012-06-12","2012-05-23",0,null,null,null,null,null,null,"2012-06-11"]
[null,null,null,null,null,null,null,"2012-06-16","2012-05-24",0,null,null,null,null,null,null,"2012-06-12"]
[null,null,null,null,null,null,null,"2012-06-17","2012-05-25",0,null,null,null,null,null,null,"2012-11-05"]
[null,null,null,null,null,null,null,"2012-06-23","2012-05-28",0,null,null,null,null,null,null,"2012-12-31"]
[null,null,null,null,null,null,null,"2012-06-24","2012-05-29",0]
[null,null,null,null,null,null,null,"2012-07-01","2012-05-30",0]
[null,null,null,null,null,null,null,"2012-07-07","2012-05-31",0]
[null,null,null,null,null,null,null,"2012-07-08","2012-06-01",0]
[null,null,null,null,null,null,null,"2012-07-14","2012-06-04",0]
[null,null,null,null,null,null,null,"2012-07-15","2012-06-05",0]
[null,null,null,null,null,null,null,"2012-07-21","2012-06-06",0]
[null,null,null,null,null,null,null,"2012-07-22","2012-06-07",0]
[null,null,null,null,null,null,null,"2012-07-28","2012-06-08",0]
[null,null,null,null,null,null,null,"2012-07-29","2012-06-09",0]
[null,null,null,null,null,null,null,"2012-08-04","2012-06-13",0]
[null,null,null,null,null,null,null,"2012-08-05","2012-06-14",0]
[null,null,null,null,null,null,null,"2012-08-11","2012-06-15",0]
[null,null,null,null,null,null,null,"2012-08-12","2012-06-18",0]
[null,null,null,null,null,null,null,"2012-08-18","2012-06-19",0]
[null,null,null,null,null,null,null,"2012-08-19","2012-06-20",0]
[null,null,null,null,null,null,null,"2012-08-25","2012-06-21",0]
[null,null,null,null,null,null,null,"2012-08-26","2012-06-22",0]
[null,null,null,null,null,null,null,"2012-09-01","2012-06-25",0]
[null,null,null,null,null,null,null,"2012-09-02","2012-06-26",0]
[null,null,null,null,null,null,null,"2012-09-08","2012-06-27",0]
[null,null,null,null,null,null,null,"2012-09-09","2012-06-28",0]
[null,null,null,null,null,null,null,"2012-09-15","2012-06-29",0]
[null,null,null,null,null,null,null,"2012-09-16","2012-06-30",0]
[null,null,null,null,null,null,null,"2012-09-22","2012-08-01",0]
[null,null,null,null,null,null,null,"2012-09-23","2012-08-02",0]
[null,null,null,null,null,null,null,"2012-09-29","2012-08-03",0]
[null,null,null,null,null,null,null,"2012-09-30","2012-08-06",0]
[null,null,null,null,null,null,null,"2012-10-06","2012-08-07",0]
[null,null,null,null,null,null,null,"2012-10-07","2012-08-08",0]
[null,null,null,null,null,null,null,"2012-10-13","2012-08-09",0]
[null,null,null,null,null,null,null,"2012-10-14","2012-08-10",0]
[null,null,null,null,null,null,null,"2012-10-20","2012-08-13",0]
[null,null,null,null,null,null,null,"2012-10-21","2012-08-14",0]
[null,null,null,null,null,null,null,"2012-10-27","2012-08-15",0]
[null,null,null,null,null,null,null,"2012-10-28","2012-08-16",0]
[null,null,null,null,null,null,null,"2012-11-03","2012-08-17",0]
[null,null,null,null,null,null,null,"2012-11-04","2012-08-20",0]
[null,null,null,null,null,null,null,"2012-11-05","2012-08-21",0]
[null,null,null,null,null,null,null,"2012-11-10","2012-08-22",0]
[null,null,null,null,null,null,null,"2012-11-11","2012-08-23",0]
[null,null,null,null,null,null,null,"2012-11-17","2012-08-24",0]
[null,null,null,null,null,null,null,"2012-11-18","2012-08-27",0]
[null,null,null,null,null,null,null,"2012-11-24","2012-08-28",0]
[null,null,null,null,null,null,null,"2012-11-25","2012-08-29",0]
[null,null,null,null,null,null,null,"2012-12-01","2012-08-30",0]
[null,null,null,null,null,null,null,"2012-12-02","2012-08-31",0]

{"sheet":"Проект","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Шаблон","index":3,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,0,8],[0,9,0,10],[1,6,2,8],[1,9,2,10],[15,6,15,8],[4,9,4,10],[5,9,5,10],[6,9,6,10],[10,6,10,8],[11,6,11,8],[6,6,6,8],[4,6,4,8],[5,6,5,8]]}
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Σ/Δ","показатель, р",null,null,null,{"$f":"J1-F37-F43-F54-F56-F4-F21","v":0}]
[null,null,null,null,"Δ=",{"$f":"SUM(D4:D19)-SUM(C4:C19)","v":0}]
[null,null,null,null,"Σ=",{"$f":"SUM(C4:C19)","v":0},null,null,null,{"$f":"J5+J6+J7","v":165520}]
[null,null,null,null,null,null,null,null,null,15000]
[null,null,null,null,null,null,null,null,null,150000]
[null,null,null,null,null,null,null,null,null,520]
[null,null,null,null,null,null,"Срок выполнения, мес",null,null,{"$f":"J9/22","v":0}]
[null,null,null,null,null,null,"Срок выполнения, дней",null,null,0]
[null,null,null,null,null,null,"Показатели:"]
[null,null,null,null,null,null,"Рентабельность, %",null,null,{"$f":"J2/J1","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Налоги, р",null,null,{"$f":"J1/118*18","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(J2-J12)*0.2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"F37*0.13","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(F4+F21+F43)/118*(18)","v":0}]
[null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"J2-(J4*J8)-J12-J13-J14+J15","v":0},{"$f":"IF(J16>=0, \"Проект прибыльный\",\"Проект убыточный\")","v":"Проект прибыльный"}]
[null,null,null,null,null,null,"Дата начала проекта:"]
[null,null,null,null,null,null,"Дата окончания проекта:",null,null,{"$f":"WORKDAY.INTL(J17,J9,11,График!H1:H73)-1","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,"Δ=",{"$f":"SUM(D21:D36)-SUM(C21:C36)","v":0}]
[null,null,null,null,"Σ=",{"$f":"SUM(C21:C36)","v":0}]
[null,null,null,null,null,null,"Интервал выполнения проекта",null,null,{"$f":"J17","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Σ=",{"$f":"SUM(C38:C42)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,"Σ=",{"$f":"SUM(C44:C46)","v":0}]
[]
[]
[]
[null,null,null,null,"Σ=",{"$f":"SUM(C48:C53)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Σ=",{"$f":"SUM(C55)","v":0}]
[]
[null,null,null,null,"Σ=",{"$f":"SUM(C57:C58)","v":0}]