{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Сетевая диаграмма","Сетевая диаграмма (на листе)","EXCEL2.RU"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":1,"defined_names":5,"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":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
["Файл скачан с сайта excel2.ru >>>"]
["Перейти к статье >>>"]
["Автоматическая сетевая диаграмма проекта с критическим путем в MS EXCEL"]
[]
["Дата начала проекта",null,"2016-01-01"]
["Дата завершения проекта",null,{"$f":"WORKDAY(C5,C7)-1","v":"2016-03-31"},"последняя дата проекта"]
["Длительность проекта",null,{"$f":"S34","v":65},"рабочих дней",null,null,null,true]
["Число крит. путей",null,{"$f":"BA77","v":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,null,null,null,null,null,null,null,null,null,null,null,null,"Не на крит.пути",null,null,{"$f":"C5","v":"2016-01-01"},null,null,null,"последний день, когда выполняется работа"]
[null,null,null,1,2,3,4,5,null,null,null,null,null,null,null,"Для Start РН=0",null,null,"Для Finish ПО=РО","Если Запас=0, то работа на крит. пути",null,null,null,null,null,null,null,1,2,3,4,5,null,null,null,null,null,null,null,null,"Для построения диаграммы Ганта (рабочие дни)",null,null,null,null,"Для построения диаграммы Ганта (на календаре)",null,null,null,null,null,"Для сетевой диаграммы",null,null,"Работы на критическом пути"]
["Код работы","Название работы","Длительность работы","Предшествующие работы (максимум 5)",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,null,"Раннее начало","Крит.путь","Длительность","Запас",null,"Раннее начало","Крит.путь","Длительность","Запас","Дата окончания ",null,"Работы","Х","Y","Х","Y"]
[1,"Старт",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF($A12=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":2},{"$f":"IFERROR(SMALL(IF($A12=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":4},{"$f":"IFERROR(SMALL(IF($A12=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":6},{"$f":"IFERROR(SMALL(IF($A12=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A12=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},{"$f":"COUNT(AB12:AF12)","v":3},null,{"$f":"IF(AB12=\"\",\"\",INDEX($R$12:$R$34,MATCH(AB12,$A$12:$A$34,0)))","v":5},{"$f":"IF(AC12=\"\",\"\",INDEX($R$12:$R$34,MATCH(AC12,$A$12:$A$34,0)))","v":0},{"$f":"IF(AD12=\"\",\"\",INDEX($R$12:$R$34,MATCH(AD12,$A$12:$A$34,0)))","v":8},{"$f":"IF(AE12=\"\",\"\",INDEX($R$12:$R$34,MATCH(AE12,$A$12:$A$34,0)))","v":""},{"$f":"IF(AF12=\"\",\"\",INDEX($R$12:$R$34,MATCH(AF12,$A$12:$A$34,0)))","v":""},null,{"$f":"IF(C12=0,NA(),P12)","v":{"$error":"#N/A"}},{"$f":"IF(C12=0,NA(),IF(T12,NA(),C12))","v":{"$error":"#N/A"}},{"$f":"IF(C12=0,NA(),IF(T12,C12,NA()))","v":{"$error":"#N/A"}},{"$f":"IF($R$36,IF(C12=0,NA(),T12),NA())","v":{"$error":"#N/A"}},null,{"$f":"WORKDAY($AT$9,AO12)","v":{"$error":"#N/A"}},{"$f":"IF(C12=0,NA(),IF(T12,NA(),WORKDAY(AT12,C12)))-AT12","v":{"$error":"#N/A"}},{"$f":"IF(C12=0,NA(),IF(T12,WORKDAY(AT12,C12),NA()))-AT12","v":{"$error":"#N/A"}},{"$f":"IF($R$36,IF(C12=0,NA(),WORKDAY(AX12,T12)),NA())-AX12","v":{"$error":"#N/A"}},{"$f":"AT12+IF(ISNA(AU12),AV12,AU12)-1","v":{"$error":"#N/A"}},null,{"$f":"B12","v":"Старт"},10,3,{"$f":"IF($T12,NA(),BA12)","v":10},{"$f":"IF($T12,NA(),BB12)","v":3}]
[2,{"$f":"CHAR(65+ROW()-ROW($A$13))","v":"A"},12,"Старт",null,null,null,null,null,{"$f":"IFERROR(INDEX($A$12:$A$34,MATCH(D13,$B$12:$B$34,0)),\"\")","v":1},{"$f":"IFERROR(INDEX($A$12:$A$34,MATCH(E13,$B$12:$B$34,0)),\"\")","v":""},"","","",null,{"$f":"MAX(V13:Z13)","v":0},{"$f":"P13+C13","v":12},{"$f":"S13-C13","v":5},{"$f":"MIN(AI13:AM13)","v":17},{"$f":"S13-Q13","v":5},null,{"$f":"IF(J13=\"\",0,INDEX($Q$12:$Q$34,MATCH(J13,$A$12:$A$34,0)))","v":0},0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A13=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":7},{"$f":"IFERROR(SMALL(IF($A13=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A13=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A13=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A13=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},{"$f":"COUNT(AB13:AF13)","v":1},null,17,"","","","",null,{"$f":"IF(C13=0,NA(),P13)","v":0},{"$f":"IF(C13=0,NA(),IF(T13,NA(),C13))","v":{"$error":"#N/A"}},{"$f":"IF(C13=0,NA(),IF(T13,C13,NA()))","v":12},{"$f":"IF($R$36,IF(C13=0,NA(),T13),NA())","v":5},null,{"$f":"WORKDAY($AT$9,AO13)","v":"2016-01-01"},{"$f":"IF(C13=0,NA(),IF(T13,NA(),WORKDAY(AT13,C13)))-AT13","v":{"$error":"#N/A"}},{"$f":"IF(C13=0,NA(),IF(T13,WORKDAY(AT13,C13),NA()))-AT13","v":18},{"$f":"IF($R$36,IF(C13=0,NA(),WORKDAY(AX13,T13)),NA())-AX13","v":7},{"$f":"AT13+IF(ISNA(AU13),AV13,AU13)-1","v":"2016-01-18"},null,"A",20,3,{"$f":"IF($T13,NA(),BA13)","v":{"$error":"#N/A"}},{"$f":"IF($T13,NA(),BB13)","v":{"$error":"#N/A"}}]
[3,{"$f":"CHAR(65+ROW()-ROW($A$13))","v":"B"},10,"C",null,null,null,null,null,{"$f":"IFERROR(INDEX($A$12:$A$34,MATCH(D14,$B$12:$B$34,0)),\"\")","v":4},"","","","",null,9,19,10,20,1,null,9,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A14=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":9},{"$f":"IFERROR(SMALL(IF($A14=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A14=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A14=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A14=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,20,"","","","",null,9,{"$error":"#N/A"},10,{"$f":"IF($R$36,IF(C14=0,NA(),T14),NA())","v":1},null,"2016-01-14",{"$error":"#N/A"},14,{"$f":"IF($R$36,IF(C14=0,NA(),WORKDAY(AX14,T14)),NA())-AX14","v":1},{"$f":"AT14+IF(ISNA(AU14),AV14,AU14)-1","v":"2016-01-27"},null,"B",30,4,{"$error":"#N/A"},{"$error":"#N/A"}]
[4,"C",9,"Старт",null,null,null,null,null,1,"","","","",null,0,9,0,9,0,null,0,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A15=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":3},{"$f":"IFERROR(SMALL(IF($A15=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":5},{"$f":"IFERROR(SMALL(IF($A15=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A15=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A15=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},2,null,10,9,"","","",null,0,9,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C15=0,NA(),T15),NA())","v":0},null,"2016-01-01",13,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C15=0,NA(),WORKDAY(AX15,T15)),NA())-AX15","v":0},"2016-01-13",null,"C",20,5,20,5]
[5,"D",10,"C",null,null,null,null,null,4,"","","","",null,9,19,9,19,0,null,9,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A16=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":8},{"$f":"IFERROR(SMALL(IF($A16=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A16=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A16=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A16=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,19,"","","","",null,9,10,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C16=0,NA(),T16),NA())","v":0},null,"2016-01-14",14,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C16=0,NA(),WORKDAY(AX16,T16)),NA())-AX16","v":0},"2016-01-27",null,"D",30,6,30,6]
[6,"E",11,"Старт",null,null,null,null,null,1,"","","","",null,0,11,8,19,8,null,0,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A17=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":14},{"$f":"IFERROR(SMALL(IF($A17=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A17=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A17=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A17=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,19,"","","","",null,0,{"$error":"#N/A"},11,{"$f":"IF($R$36,IF(C17=0,NA(),T17),NA())","v":8},null,"2016-01-01",{"$error":"#N/A"},17,{"$f":"IF($R$36,IF(C17=0,NA(),WORKDAY(AX17,T17)),NA())-AX17","v":10},"2016-01-17",null,"E",30,1,{"$error":"#N/A"},{"$error":"#N/A"}]
[7,"F",14,"A",null,null,null,null,null,2,"","","","",null,12,26,17,31,5,null,12,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A18=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":10},{"$f":"IFERROR(SMALL(IF($A18=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A18=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A18=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A18=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,31,"","","","",null,12,{"$error":"#N/A"},14,{"$f":"IF($R$36,IF(C18=0,NA(),T18),NA())","v":5},null,"2016-01-19",{"$error":"#N/A"},20,{"$f":"IF($R$36,IF(C18=0,NA(),WORKDAY(AX18,T18)),NA())-AX18","v":5},"2016-02-07",null,"F",30,3,{"$error":"#N/A"},{"$error":"#N/A"}]
[8,"G",8,"D",null,null,null,null,null,5,"","","","",null,19,27,19,27,0,null,19,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A19=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":11},{"$f":"IFERROR(SMALL(IF($A19=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":12},{"$f":"IFERROR(SMALL(IF($A19=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A19=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A19=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},2,null,27,28,"","","",null,19,8,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C19=0,NA(),T19),NA())","v":0},null,"2016-01-28",12,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C19=0,NA(),WORKDAY(AX19,T19)),NA())-AX19","v":0},"2016-02-08",null,"G",40,6,40,6]
[9,"H",8,"B",null,null,null,null,null,3,"","","","",null,19,27,20,28,1,null,19,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A20=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":12},{"$f":"IFERROR(SMALL(IF($A20=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":13},{"$f":"IFERROR(SMALL(IF($A20=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A20=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A20=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},2,null,28,30,"","","",null,19,{"$error":"#N/A"},8,{"$f":"IF($R$36,IF(C20=0,NA(),T20),NA())","v":1},null,"2016-01-28",{"$error":"#N/A"},12,{"$f":"IF($R$36,IF(C20=0,NA(),WORKDAY(AX20,T20)),NA())-AX20","v":1},"2016-02-08",null,"H",40,4,{"$error":"#N/A"},{"$error":"#N/A"}]
[10,"I",15,"F",null,null,null,null,null,7,"","","","",null,26,41,31,46,5,null,26,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A21=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":20},{"$f":"IFERROR(SMALL(IF($A21=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A21=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A21=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A21=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,46,"","","","",null,26,{"$error":"#N/A"},15,{"$f":"IF($R$36,IF(C21=0,NA(),T21),NA())","v":5},null,"2016-02-08",{"$error":"#N/A"},21,{"$f":"IF($R$36,IF(C21=0,NA(),WORKDAY(AX21,T21)),NA())-AX21","v":5},"2016-02-28",null,"I",40,2,{"$error":"#N/A"},{"$error":"#N/A"}]
[11,"J",10,"G",null,null,null,null,null,8,"","","","",null,27,37,27,37,0,null,27,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A22=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":15},{"$f":"IFERROR(SMALL(IF($A22=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A22=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A22=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A22=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,37,"","","","",null,27,10,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C22=0,NA(),T22),NA())","v":0},null,"2016-02-09",14,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C22=0,NA(),WORKDAY(AX22,T22)),NA())-AX22","v":0},"2016-02-22",null,"J",50,6,50,6]
[12,"K",13,"G","H",null,null,null,null,8,9,"","","",null,27,40,28,41,1,null,27,27,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A23=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":16},{"$f":"IFERROR(SMALL(IF($A23=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A23=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A23=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A23=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,41,"","","","",null,27,{"$error":"#N/A"},13,{"$f":"IF($R$36,IF(C23=0,NA(),T23),NA())","v":1},null,"2016-02-09",{"$error":"#N/A"},17,{"$f":"IF($R$36,IF(C23=0,NA(),WORKDAY(AX23,T23)),NA())-AX23","v":1},"2016-02-25",null,"K",50,5,{"$error":"#N/A"},{"$error":"#N/A"}]
[13,"L",6,"H",null,null,null,null,null,9,"","","","",null,27,33,30,36,3,null,27,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A24=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":17},{"$f":"IFERROR(SMALL(IF($A24=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A24=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A24=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A24=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,36,"","","","",null,27,{"$error":"#N/A"},6,{"$f":"IF($R$36,IF(C24=0,NA(),T24),NA())","v":3},null,"2016-02-09",{"$error":"#N/A"},8,{"$f":"IF($R$36,IF(C24=0,NA(),WORKDAY(AX24,T24)),NA())-AX24","v":3},"2016-02-16",null,"L",50,3,{"$error":"#N/A"},{"$error":"#N/A"}]
[14,"M",11,"E",null,null,null,null,null,6,"","","","",null,11,22,19,30,8,null,11,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A25=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":18},{"$f":"IFERROR(SMALL(IF($A25=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A25=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A25=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A25=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,30,"","","","",null,11,{"$error":"#N/A"},11,{"$f":"IF($R$36,IF(C25=0,NA(),T25),NA())","v":8},null,"2016-01-18",{"$error":"#N/A"},15,{"$f":"IF($R$36,IF(C25=0,NA(),WORKDAY(AX25,T25)),NA())-AX25","v":10},"2016-02-01",null,"M",50,1,{"$error":"#N/A"},{"$error":"#N/A"}]
[15,"N",11,"J",null,null,null,null,null,11,"","","","",null,37,48,37,48,0,null,37,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A26=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":19},{"$f":"IFERROR(SMALL(IF($A26=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A26=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A26=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A26=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,48,"","","","",null,37,11,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C26=0,NA(),T26),NA())","v":0},null,"2016-02-23",15,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C26=0,NA(),WORKDAY(AX26,T26)),NA())-AX26","v":0},"2016-03-08",null,"N",60,6,60,6]
[16,"O",7,"K",null,null,null,null,null,12,"","","","",null,40,47,41,48,1,null,40,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A27=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":19},{"$f":"IFERROR(SMALL(IF($A27=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A27=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A27=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A27=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,48,"","","","",null,40,{"$error":"#N/A"},7,{"$f":"IF($R$36,IF(C27=0,NA(),T27),NA())","v":1},null,"2016-02-26",{"$error":"#N/A"},11,{"$f":"IF($R$36,IF(C27=0,NA(),WORKDAY(AX27,T27)),NA())-AX27","v":1},"2016-03-07",null,"O",60,5,{"$error":"#N/A"},{"$error":"#N/A"}]
[17,"P",10,"L",null,null,null,null,null,13,"","","","",null,33,43,36,46,3,null,33,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A28=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":20},{"$f":"IFERROR(SMALL(IF($A28=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":22},{"$f":"IFERROR(SMALL(IF($A28=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A28=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A28=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},2,null,46,59,"","","",null,33,{"$error":"#N/A"},10,{"$f":"IF($R$36,IF(C28=0,NA(),T28),NA())","v":3},null,"2016-02-17",{"$error":"#N/A"},14,{"$f":"IF($R$36,IF(C28=0,NA(),WORKDAY(AX28,T28)),NA())-AX28","v":3},"2016-03-01",null,"P",60,3,{"$error":"#N/A"},{"$error":"#N/A"}]
[18,"Q",16,"M",null,null,null,null,null,14,"","","","",null,22,38,30,46,8,null,22,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A29=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":20},{"$f":"IFERROR(SMALL(IF($A29=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A29=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A29=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A29=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,46,"","","","",null,22,{"$error":"#N/A"},16,{"$f":"IF($R$36,IF(C29=0,NA(),T29),NA())","v":8},null,"2016-02-02",{"$error":"#N/A"},22,{"$f":"IF($R$36,IF(C29=0,NA(),WORKDAY(AX29,T29)),NA())-AX29","v":10},"2016-02-23",null,"Q",60,1,{"$error":"#N/A"},{"$error":"#N/A"}]
[19,"R",11,"O","N",null,null,null,null,16,15,"","","",null,48,59,48,59,0,null,47,48,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A30=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":22},{"$f":"IFERROR(SMALL(IF($A30=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A30=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A30=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A30=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,59,"","","","",null,48,11,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C30=0,NA(),T30),NA())","v":0},null,"2016-03-09",15,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C30=0,NA(),WORKDAY(AX30,T30)),NA())-AX30","v":0},"2016-03-23",null,"R",70,5,70,5]
[20,"S",8,"P","I","Q",null,null,null,17,10,18,"","",null,43,51,46,54,3,null,43,41,38,0,0,null,{"$f":"IFERROR(SMALL(IF($A31=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":21},{"$f":"IFERROR(SMALL(IF($A31=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A31=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A31=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A31=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,54,"","","","",null,43,{"$error":"#N/A"},8,{"$f":"IF($R$36,IF(C31=0,NA(),T31),NA())","v":3},null,"2016-03-02",{"$error":"#N/A"},12,{"$f":"IF($R$36,IF(C31=0,NA(),WORKDAY(AX31,T31)),NA())-AX31","v":3},"2016-03-13",null,"S",70,2,{"$error":"#N/A"},{"$error":"#N/A"}]
[21,"T",11,"S",null,null,null,null,null,20,"","","","",null,51,62,54,65,3,null,51,0,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A32=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":23},{"$f":"IFERROR(SMALL(IF($A32=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A32=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A32=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A32=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,65,"","","","",null,51,{"$error":"#N/A"},11,{"$f":"IF($R$36,IF(C32=0,NA(),T32),NA())","v":3},null,"2016-03-14",{"$error":"#N/A"},15,{"$f":"IF($R$36,IF(C32=0,NA(),WORKDAY(AX32,T32)),NA())-AX32","v":3},"2016-03-28",null,"T",80,2,{"$error":"#N/A"},{"$error":"#N/A"}]
[22,"U",6,"P","R",null,null,null,null,17,19,"","","",null,59,65,59,65,0,null,43,59,0,0,0,null,{"$f":"IFERROR(SMALL(IF($A33=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AB$10),\"\")","v":23},{"$f":"IFERROR(SMALL(IF($A33=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AC$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A33=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AD$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A33=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AE$10),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A33=$J$13:$N$34,ROW($J$13:$J$34)-ROW($J$11),\"\"),AF$10),\"\")","v":""},1,null,65,"","","","",null,59,6,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C33=0,NA(),T33),NA())","v":0},null,"2016-03-24",8,{"$error":"#N/A"},{"$f":"IF($R$36,IF(C33=0,NA(),WORKDAY(AX33,T33)),NA())-AX33","v":0},"2016-03-31",null,"U",80,4,80,4]
[23,"Окончание",0,"T","U",null,null,null,null,21,22,"","","",null,65,65,65,{"$f":"Q34","v":65},0,null,62,65,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF($R$36,IF(C34=0,NA(),T34),NA())","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF($R$36,IF(C34=0,NA(),WORKDAY(AX34,T34)),NA())-AX34","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"Окончание",90,3,90,3]
[{"$f":"IF(ROW($B$34)-ROW($B$11)>25,\"Limited to 25 Tasks\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,"Координата Х",null,null,"Для сетевой диаграммы (работы-точки)",null,null,null,null,null,null,null,null,null,"Длительность путей"]
["Работ и вех",{"$f":"COUNT(A12:A34)","v":23},null,"№ пути",1,2,3,4,5,6,7,8,9,10,"Длина пути",null,"№ пути",{"$f":"E61","v":1},{"$f":"F61","v":2},3,4,5,6,7,8,9,{"$f":"N61","v":10},null,"Показать?","№ пути",{"$f":"R61","v":1},{"$f":"S61","v":2},3,4,5,6,7,8,9,{"$f":"AA61","v":10},null,"№ пути",{"$f":"AE61","v":1},2,3,4,5,6,7,8,9,10,"Длит, раб. Дней"]
["Путей",{"$f":"INDEX($S$96:$S$200,B67)","v":7},null,{"$f":"IF(B81>$B$62,\"\",B81)","v":1},{"$f":"IF(OR($D62>$B$62,E$61>($B$63+2)),\"\",OFFSET(C$81,$B$67+$D62+$B$69-2,))","v":1},{"$f":"IF(OR($D62>$B$62,F$61>($B$63+2)),\"\",OFFSET(D$81,$B$67+$D62+$B$69-2,))","v":2},7,10,20,21,23,23,23,"",{"$f":"IFERROR(MATCH($B$61,E62:N62,0),\"\")","v":7},null,{"$f":"D62","v":1},{"$f":"IFERROR(IF(R$61>$O62,\"\",VLOOKUP(E62,$A$12:$B$34,2,0)),\"\")","v":"Старт"},{"$f":"IFERROR(IF(S$61>$O62,\"\",VLOOKUP(F62,$A$12:$B$34,2,0)),\"\")","v":"A"},"F","I","S","T","Окончание","","","",null,1,{"$f":"\"Путь_\"&B81","v":"Путь_1"},{"$f":"IF($AC62,VLOOKUP(R62,$AZ$12:$BB$34,2,0),NA())","v":10},{"$f":"IF($AC62,VLOOKUP(S62,$AZ$12:$BB$34,2,0),NA())","v":20},30,40,70,80,90,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"D62","v":1},{"$f":"IFERROR(VLOOKUP(R62,$B$12:$C$34,2,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(S62,$B$12:$C$34,2,0),\"\")","v":12},{"$f":"IFERROR(VLOOKUP(T62,$B$12:$C$34,2,0),\"\")","v":14},{"$f":"IFERROR(VLOOKUP(U62,$B$12:$C$34,2,0),\"\")","v":15},{"$f":"IFERROR(VLOOKUP(V62,$B$12:$C$34,2,0),\"\")","v":8},{"$f":"IFERROR(VLOOKUP(W62,$B$12:$C$34,2,0),\"\")","v":11},{"$f":"IFERROR(VLOOKUP(X62,$B$12:$C$34,2,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(Y62,$B$12:$C$34,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Z62,$B$12:$C$34,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AA62,$B$12:$C$34,2,0),\"\")","v":""},{"$f":"IFERROR(SUM(OFFSET(AQ62,,,,$O62)),\"\")","v":60}]
["Шагов",{"$f":"INDEX($A$96:$A$200,B67)","v":7},null,{"$f":"IF(B82>$B$62,\"\",B82)","v":2},{"$f":"IF(OR($D63>$B$62,E$61>($B$63+2)),\"\",OFFSET(C$81,$B$67+$D63+$B$69-2,))","v":1},{"$f":"IF(OR($D63>$B$62,F$61>($B$63+2)),\"\",OFFSET(D$81,$B$67+$D63+$B$69-2,))","v":4},{"$f":"IF(OR($D63>$B$62,G$61>($B$63+2)),\"\",OFFSET(E$81,$B$67+$D63+$B$69-2,))","v":3},{"$f":"IF(OR($D63>$B$62,H$61>($B$63+2)),\"\",OFFSET(F$81,$B$67+$D63+$B$69-2,))","v":9},{"$f":"IF(OR($D63>$B$62,I$61>($B$63+2)),\"\",OFFSET(G$81,$B$67+$D63+$B$69-2,))","v":12},{"$f":"IF(OR($D63>$B$62,J$61>($B$63+2)),\"\",OFFSET(H$81,$B$67+$D63+$B$69-2,))","v":16},{"$f":"IF(OR($D63>$B$62,K$61>($B$63+2)),\"\",OFFSET(I$81,$B$67+$D63+$B$69-2,))","v":19},{"$f":"IF(OR($D63>$B$62,L$61>($B$63+2)),\"\",OFFSET(J$81,$B$67+$D63+$B$69-2,))","v":22},{"$f":"IF(OR($D63>$B$62,M$61>($B$63+2)),\"\",OFFSET(K$81,$B$67+$D63+$B$69-2,))","v":23},{"$f":"IF(OR($D63>$B$62,N$61>($B$63+2)),\"\",OFFSET(L$81,$B$67+$D63+$B$69-2,))","v":""},{"$f":"IFERROR(MATCH($B$61,E63:N63,0),\"\")","v":9},null,{"$f":"D63","v":2},{"$f":"IFERROR(IF(R$61>$O63,\"\",VLOOKUP(E63,$A$12:$B$34,2,0)),\"\")","v":"Старт"},"C","B","H","K","O","R","U","Окончание","",null,1,{"$f":"\"Путь_\"&B82","v":"Путь_2"},{"$f":"IF($AC63,VLOOKUP(R63,$AZ$12:$BB$34,2,0),NA())","v":10},{"$f":"IF($AC63,VLOOKUP(S63,$AZ$12:$BB$34,2,0),NA())","v":20},{"$f":"IF($AC63,VLOOKUP(T63,$AZ$12:$BB$34,2,0),NA())","v":30},{"$f":"IF($AC63,VLOOKUP(U63,$AZ$12:$BB$34,2,0),NA())","v":40},{"$f":"IF($AC63,VLOOKUP(V63,$AZ$12:$BB$34,2,0),NA())","v":50},{"$f":"IF($AC63,VLOOKUP(W63,$AZ$12:$BB$34,2,0),NA())","v":60},{"$f":"IF($AC63,VLOOKUP(X63,$AZ$12:$BB$34,2,0),NA())","v":70},{"$f":"IF($AC63,VLOOKUP(Y63,$AZ$12:$BB$34,2,0),NA())","v":80},{"$f":"IF($AC63,VLOOKUP(Z63,$AZ$12:$BB$34,2,0),NA())","v":90},{"$f":"IF($AC63,VLOOKUP(AA63,$AZ$12:$BB$34,2,0),NA())","v":{"$error":"#N/A"}},null,{"$f":"D63","v":2},0,9,10,8,13,7,11,6,0,"",64]
["Макс длина пути",{"$f":"B63+2","v":9},null,3,1,4,3,9,13,17,20,21,23,"",9,null,3,"Старт","C","B","H","L","P","S","T","Окончание","",null,1,"Путь_3",10,20,30,40,50,60,70,80,90,{"$error":"#N/A"},null,3,0,9,10,8,6,10,8,11,0,"",62]
[null,null,null,4,1,4,3,9,13,17,22,23,23,"",8,null,4,"Старт","C","B","H","L","P","U","Окончание","","",null,1,"Путь_4",10,20,30,40,50,60,80,90,{"$error":"#N/A"},{"$error":"#N/A"},null,4,0,9,10,8,6,10,6,0,"","",49]
[null,"Смещение",null,5,1,4,5,8,11,15,19,22,23,"",9,null,5,"Старт","C","D","G","J","N","R","U","Окончание","",null,1,"Путь_5",10,20,30,40,50,60,70,80,90,{"$error":"#N/A"},null,5,0,9,10,8,10,11,11,6,0,"",65]
[null,{"$f":"MATCH(TRUE,T96:T200,0)","v":91},null,6,1,4,5,8,12,16,19,22,23,"",9,null,6,"Старт","C","D","G","K","O","R","U","Окончание","",null,1,"Путь_6",10,20,30,40,50,60,70,80,90,{"$error":"#N/A"},null,6,0,9,10,8,13,7,11,6,0,"",64]
[null,null,null,7,1,6,14,18,20,21,23,23,23,"",7,null,7,"Старт","E","M","Q","S","T","Окончание","","","",null,1,"Путь_7",10,30,50,60,70,80,90,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,7,0,11,11,16,8,11,0,"","","",57]
["Макс путей",15,null,"","","","","","","","","","","","",null,"","","","","","","","","","","",null,1,"Путь_8",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"","","","","","","","","","","",""]
[null,null,null,"","","","","","","","","","","","",null,"","","","","","","","","","","",null,1,"Путь_9",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"","","","","","","","","","","",""]
[null,null,null,"","","","","","","","","","","","",null,"","","","","","","","","","","",null,1,"Путь_10",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B91>$B$62,\"\",B91)","v":""},"","","","","","","","","","","",null,"","","","","","","","","","","",null,1,"Путь_11",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"","","","","","","","","","","",""]
[null,null,null,"","","","","","","","","","","","",null,"","","","","","","","","","","",null,1,"Путь_12",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"","","","","","","","","","","",""]
[null,null,null,"","","","","","","","","","","","",null,"","","","","","","","","","","",null,1,"Путь_13",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"","","","","","","","","","","",""]
[null,null,null,"","","","","","","","","","","","",null,"","","","","","","","","","","",null,1,"Путь_14",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"","","","","","","","","","","",""]
[null,null,null,"","","","","","","","","","","","",null,"","","","","","","","","","","",null,1,"Путь_15",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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,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,null,null,"Число крит. путей (д.б. менее 4, чтобы отобразить все)",{"$f":"SUMPRODUCT(--(BA62:BA76=$C$7))","v":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,null,null,null,"Координата Y",null,null,null,null,null,null,null,null,null,null,null,null,"Критические пути (максимум будет выведено 3 пути, но их может быть и больше) - координата X"]
[null,null,0,1,2,3,4,5,6,7,8,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"№ пути",{"$f":"AE61","v":1},{"$f":"AF61","v":2},3,4,5,6,7,8,9,10,null,"№ пути",{"$f":"AQ61","v":1},{"$f":"AR61","v":2},3,4,5,6,7,8,9,10,"Название"]
["№ шага","№ пути",{"$f":"C79&\" с повт.\"","v":"0 с повт."},{"$f":"D79&\" с повт.\"","v":"1 с повт."},"2 с повт.","3 с повт.","4 с повт.","5 с повт.","6 с повт.","7 с повт.","8 с повт.",null,null,null,"свертка","№ повтора","Смещение","кол-во повторов","Число путей","Завершено?",null,null,null,null,null,null,null,null,null,{"$f":"\"Путь_\"&Q62&\"(Y)\"","v":"Путь_1(Y)"},{"$f":"VLOOKUP(R62,$AZ$12:$BB$34,3,0)","v":3},{"$f":"VLOOKUP(S62,$AZ$12:$BB$34,3,0)","v":3},3,2,2,2,3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"LARGE((BA62:BA76=$C$7)*(ROW(BA62:BA76)-ROW(BA61)),ROW(INDIRECT(\"a1:a\"&$BA$77)))","v":5},{"$f":"INDEX(AE$62:AE$76,$AP80)","v":10},{"$f":"INDEX(AF$62:AF$76,$AP80)","v":20},{"$f":"INDEX(AG$62:AG$76,$AP80)","v":30},40,50,60,70,80,90,{"$error":"#N/A"},"Крит1"]
[{"$f":"INT((ROW()-ROW($A$96))/$B$69)+1","v":0},{"$f":"MOD((ROW()-ROW($A$96)),$B$69)+1","v":1},{"$f":"IF(B81<=$AG$12,$A$12,NA())","v":1},{"$f":"IF(ISNA(C81),NA(),OFFSET($AB$12,,B81-1))","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($AG$13:$AG$33,MATCH(OFFSET($D$81,B81-1+$B$69*A81,A81),$A$13:$A$33,0)),1)","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Путь_\"&Q63&\"(Y)\"","v":"Путь_2(Y)"},{"$f":"VLOOKUP(R63,$AZ$12:$BB$34,3,0)","v":3},5,4,4,5,5,5,4,3,{"$error":"#N/A"},null,5,{"$f":"INDEX(AE$62:AE$76,$AP81)","v":10},{"$f":"INDEX(AF$62:AF$76,$AP81)","v":20},{"$f":"INDEX(AG$62:AG$76,$AP81)","v":30},{"$f":"INDEX(AH$62:AH$76,$AP81)","v":40},{"$f":"INDEX(AI$62:AI$76,$AP81)","v":50},{"$f":"INDEX(AJ$62:AJ$76,$AP81)","v":60},{"$f":"INDEX(AK$62:AK$76,$AP81)","v":70},{"$f":"INDEX(AL$62:AL$76,$AP81)","v":80},{"$f":"INDEX(AM$62:AM$76,$AP81)","v":90},{"$f":"INDEX(AN$62:AN$76,$AP81)","v":{"$error":"#N/A"}},"Крит2"]
[0,2,{"$f":"IF(B82<=$AG$12,$A$12,NA())","v":1},{"$f":"IF(ISNA(C82),NA(),OFFSET($AB$12,,B82-1))","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($AG$13:$AG$33,MATCH(OFFSET($D$81,B82-1+$B$69*A82,A82),$A$13:$A$33,0)),1)","v":2},null,null,null,null,null,null,null,null,null,null,null,"Путь_3(Y)",3,5,4,4,3,3,2,2,3,{"$error":"#N/A"},null,5,10,20,30,40,50,60,70,80,90,{"$error":"#N/A"},"Крит3"]
[0,3,1,6,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($AG$13:$AG$33,MATCH(OFFSET($D$81,B83-1+$B$69*A83,A83),$A$13:$A$33,0)),1)","v":1},null,null,null,null,null,null,null,null,null,null,null,"Путь_4(Y)",3,5,4,4,3,3,4,3,{"$error":"#N/A"},{"$error":"#N/A"}]
[0,4,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($AG$13:$AG$33,MATCH(OFFSET($D$81,B84-1+$B$69*A84,A84),$A$13:$A$33,0)),1)","v":1},null,null,null,null,null,null,null,null,null,null,null,"Путь_5(Y)",3,5,6,6,6,6,5,4,3,{"$error":"#N/A"},null,"Координата Y"]
[0,5,{"$error":"#N/A"},{"$error":"#N/A"},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,"Путь_6(Y)",3,5,6,6,5,5,5,4,3,{"$error":"#N/A"},null,"№ пути",{"$f":"AQ79","v":1},2,3,4,5,6,7,8,9,10]
[0,6,{"$error":"#N/A"},{"$error":"#N/A"},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,"Путь_7(Y)",3,1,1,1,2,2,3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"AP80","v":5},{"$f":"INDEX(AE$80:AE$94,$AP80)","v":3},{"$f":"INDEX(AF$80:AF$94,$AP80)","v":5},6,6,6,6,5,4,3,{"$error":"#N/A"}]
[0,7,{"$error":"#N/A"},{"$error":"#N/A"},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,"Путь_(Y)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"AP81","v":5},{"$f":"INDEX(AE$80:AE$94,$AP81)","v":3},{"$f":"INDEX(AF$80:AF$94,$AP81)","v":5},{"$f":"INDEX(AG$80:AG$94,$AP81)","v":6},{"$f":"INDEX(AH$80:AH$94,$AP81)","v":6},{"$f":"INDEX(AI$80:AI$94,$AP81)","v":6},{"$f":"INDEX(AJ$80:AJ$94,$AP81)","v":6},{"$f":"INDEX(AK$80:AK$94,$AP81)","v":5},{"$f":"INDEX(AL$80:AL$94,$AP81)","v":4},{"$f":"INDEX(AM$80:AM$94,$AP81)","v":3},{"$f":"INDEX(AN$80:AN$94,$AP81)","v":{"$error":"#N/A"}}]
[0,8,{"$error":"#N/A"},{"$error":"#N/A"},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,"Путь_(Y)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"AP82","v":5},3,5,6,6,6,6,5,4,3,{"$error":"#N/A"}]
[0,9,{"$error":"#N/A"},{"$error":"#N/A"},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,"Путь_(Y)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[0,10,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($AG$13:$AG$33,MATCH(OFFSET($D$81,B90-1+$B$69*A90,A90),$A$13:$A$33,0)),1)","v":1},null,null,null,null,null,null,null,null,null,null,null,"Путь_(Y)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[0,11,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,"Путь_(Y)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[0,12,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,"Путь_(Y)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[0,13,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,"Путь_(Y)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[0,14,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Путь_\"&Q76&\"(Y)\"","v":"Путь_(Y)"},{"$f":"VLOOKUP(R76,$AZ$12:$BB$34,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(S76,$AZ$12:$BB$34,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[0,15,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[1,1,{"$f":"IF(($A96+1)<C$79,\"\",IF($A96<C$79,IF(B96=$B$61,B96,OFFSET($AB$11,B96,$P96-1)),OFFSET(C$81,$Q96+$B$69*$A81,)))","v":1},{"$f":"IF(($A96+1)<D$79,\"\",IF($A96<D$79,IF(C96=$B$61,C96,OFFSET($AB$11,C96,$P96-1)),OFFSET(D$81,$Q96+$B$69*$A81,)))","v":2},7,"","","","","","","",null,null,{"$f":"SUMPRODUCT(OFFSET($D$96,$B$69*A81+B81-1,,,A96),$B$61^(OFFSET($D$79,,,,A96)-1))","v":2},{"$f":"COUNTIF(OFFSET($O$96,$B$69*(A96-1),,B96),O96)","v":1},{"$f":"IF(B96=1,0,IF(P95=INDEX(OFFSET($R$81,$B$69*A81,,$B$69),MATCH(OFFSET(D95,,A96-1),OFFSET($D$81,$B$69*A81,A96-1,$B$69),0)),Q95+1,Q95))","v":0},1,{"$f":"IF(B96=1,COUNT(OFFSET(C96,,,$B$69)),\"\")","v":4},{"$f":"IF(B96=1,IF(SUMPRODUCT(--(OFFSET(C96,,A96+1,S96)=$B$61))=S96,TRUE),\"\")","v":false}]
[1,2,{"$f":"IF(($A97+1)<C$79,\"\",IF($A97<C$79,IF(B97=$B$61,B97,OFFSET($AB$11,B97,$P97-1)),OFFSET(C$81,$Q97+$B$69*$A82,)))","v":1},4,3,"","","","","","","",null,null,4,1,1,1,"",{"$f":"IF(B97=1,IF(SUMPRODUCT(--(OFFSET(C97,,A97+1,S97)=$B$61))=S97,TRUE),\"\")","v":""}]
[1,3,{"$f":"IF(($A98+1)<C$79,\"\",IF($A98<C$79,IF(B98=$B$61,B98,OFFSET($AB$11,B98,$P98-1)),OFFSET(C$81,$Q98+$B$69*$A83,)))","v":1},4,5,"","","","","","","",null,null,4,2,1,1,"",""]
[1,4,{"$f":"IF(($A99+1)<C$79,\"\",IF($A99<C$79,IF(B99=$B$61,B99,OFFSET($AB$11,B99,$P99-1)),OFFSET(C$81,$Q99+$B$69*$A84,)))","v":1},6,14,"","","","","","","",null,null,6,1,2,1,"",""]
[1,5,{"$f":"IF(($A100+1)<C$79,\"\",IF($A100<C$79,IF(B100=$B$61,B100,OFFSET($AB$11,B100,$P100-1)),OFFSET(C$81,$Q100+$B$69*$A85,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},1,3,1,"",""]
[1,6,{"$f":"IF(($A101+1)<C$79,\"\",IF($A101<C$79,IF(B101=$B$61,B101,OFFSET($AB$11,B101,$P101-1)),OFFSET(C$81,$Q101+$B$69*$A86,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},2,{"$error":"#N/A"},1,"",""]
[1,7,{"$f":"IF(($A102+1)<C$79,\"\",IF($A102<C$79,IF(B102=$B$61,B102,OFFSET($AB$11,B102,$P102-1)),OFFSET(C$81,$Q102+$B$69*$A87,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},3,{"$error":"#N/A"},1,"",""]
[1,8,{"$f":"IF(($A103+1)<C$79,\"\",IF($A103<C$79,IF(B103=$B$61,B103,OFFSET($AB$11,B103,$P103-1)),OFFSET(C$81,$Q103+$B$69*$A88,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},1,"",""]
[1,9,{"$f":"IF(($A104+1)<C$79,\"\",IF($A104<C$79,IF(B104=$B$61,B104,OFFSET($AB$11,B104,$P104-1)),OFFSET(C$81,$Q104+$B$69*$A89,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},5,{"$error":"#N/A"},1,"",""]
[1,10,{"$f":"IF(($A105+1)<C$79,\"\",IF($A105<C$79,IF(B105=$B$61,B105,OFFSET($AB$11,B105,$P105-1)),OFFSET(C$81,$Q105+$B$69*$A90,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},6,{"$error":"#N/A"},1,"",""]
[1,11,{"$f":"IF(($A106+1)<C$79,\"\",IF($A106<C$79,IF(B106=$B$61,B106,OFFSET($AB$11,B106,$P106-1)),OFFSET(C$81,$Q106+$B$69*$A91,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},7,{"$error":"#N/A"},1,"",""]
[1,12,{"$f":"IF(($A107+1)<C$79,\"\",IF($A107<C$79,IF(B107=$B$61,B107,OFFSET($AB$11,B107,$P107-1)),OFFSET(C$81,$Q107+$B$69*$A92,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},1,"",""]
[1,13,{"$f":"IF(($A108+1)<C$79,\"\",IF($A108<C$79,IF(B108=$B$61,B108,OFFSET($AB$11,B108,$P108-1)),OFFSET(C$81,$Q108+$B$69*$A93,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},9,{"$error":"#N/A"},1,"",""]
[1,14,{"$f":"IF(($A109+1)<C$79,\"\",IF($A109<C$79,IF(B109=$B$61,B109,OFFSET($AB$11,B109,$P109-1)),OFFSET(C$81,$Q109+$B$69*$A94,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},10,{"$error":"#N/A"},1,"",""]
[1,15,{"$f":"IF(($A110+1)<C$79,\"\",IF($A110<C$79,IF(B110=$B$61,B110,OFFSET($AB$11,B110,$P110-1)),OFFSET(C$81,$Q110+$B$69*$A95,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","","",null,null,{"$error":"#N/A"},11,{"$error":"#N/A"},1,"",""]
[2,1,{"$f":"IF(($A111+1)<C$79,\"\",IF($A111<C$79,IF(B111=$B$61,B111,OFFSET($AB$11,B111,$P111-1)),OFFSET(C$81,$Q111+$B$69*$A96,)))","v":1},2,7,10,"","","","","","",null,null,163,1,0,1,4,false]
[2,2,{"$f":"IF(($A112+1)<C$79,\"\",IF($A112<C$79,IF(B112=$B$61,B112,OFFSET($AB$11,B112,$P112-1)),OFFSET(C$81,$Q112+$B$69*$A97,)))","v":1},{"$f":"IF(($A112+1)<D$79,\"\",IF($A112<D$79,IF(C112=$B$61,C112,OFFSET($AB$11,C112,$P112-1)),OFFSET(D$81,$Q112+$B$69*$A97,)))","v":4},3,9,"","","","","","",null,null,73,1,1,2,"",""]
[{"$f":"INT((ROW()-ROW($A$96))/$B$69)+1","v":2},{"$f":"MOD((ROW()-ROW($A$96)),$B$69)+1","v":3},{"$f":"IF(($A113+1)<C$79,\"\",IF($A113<C$79,IF(B113=$B$61,B113,OFFSET($AB$11,B113,$P113-1)),OFFSET(C$81,$Q113+$B$69*$A98,)))","v":1},4,5,8,"","","","","","",null,null,119,1,2,2,"",""]
[2,4,{"$f":"IF(($A114+1)<C$79,\"\",IF($A114<C$79,IF(B114=$B$61,B114,OFFSET($AB$11,B114,$P114-1)),OFFSET(C$81,$Q114+$B$69*$A99,)))","v":1},6,14,18,"","","","","","",null,null,328,1,3,1,"",""]
[2,5,{"$f":"IF(($A115+1)<C$79,\"\",IF($A115<C$79,IF(B115=$B$61,B115,OFFSET($AB$11,B115,$P115-1)),OFFSET(C$81,$Q115+$B$69*$A100,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},1,4,1,"",""]
[2,6,{"$f":"IF(($A116+1)<C$79,\"\",IF($A116<C$79,IF(B116=$B$61,B116,OFFSET($AB$11,B116,$P116-1)),OFFSET(C$81,$Q116+$B$69*$A101,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},2,{"$error":"#N/A"},1,"",""]
[2,7,{"$f":"IF(($A117+1)<C$79,\"\",IF($A117<C$79,IF(B117=$B$61,B117,OFFSET($AB$11,B117,$P117-1)),OFFSET(C$81,$Q117+$B$69*$A102,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},3,{"$error":"#N/A"},1,"",""]
[2,8,{"$f":"IF(($A118+1)<C$79,\"\",IF($A118<C$79,IF(B118=$B$61,B118,OFFSET($AB$11,B118,$P118-1)),OFFSET(C$81,$Q118+$B$69*$A103,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},1,"",""]
[2,9,{"$f":"IF(($A119+1)<C$79,\"\",IF($A119<C$79,IF(B119=$B$61,B119,OFFSET($AB$11,B119,$P119-1)),OFFSET(C$81,$Q119+$B$69*$A104,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},5,{"$error":"#N/A"},1,"",""]
[2,10,{"$f":"IF(($A120+1)<C$79,\"\",IF($A120<C$79,IF(B120=$B$61,B120,OFFSET($AB$11,B120,$P120-1)),OFFSET(C$81,$Q120+$B$69*$A105,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},6,{"$error":"#N/A"},1,"",""]
[2,11,{"$f":"IF(($A121+1)<C$79,\"\",IF($A121<C$79,IF(B121=$B$61,B121,OFFSET($AB$11,B121,$P121-1)),OFFSET(C$81,$Q121+$B$69*$A106,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},7,{"$error":"#N/A"},1,"",""]
[2,12,{"$f":"IF(($A122+1)<C$79,\"\",IF($A122<C$79,IF(B122=$B$61,B122,OFFSET($AB$11,B122,$P122-1)),OFFSET(C$81,$Q122+$B$69*$A107,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},{"$f":"IFERROR(INDEX($AG$13:$AG$33,MATCH(OFFSET($D$81,B122-1+$B$69*A122,A122),$A$13:$A$33,0)),1)","v":1},"",""]
[2,13,{"$f":"IF(($A123+1)<C$79,\"\",IF($A123<C$79,IF(B123=$B$61,B123,OFFSET($AB$11,B123,$P123-1)),OFFSET(C$81,$Q123+$B$69*$A108,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},9,{"$error":"#N/A"},1,"",""]
[2,14,{"$f":"IF(($A124+1)<C$79,\"\",IF($A124<C$79,IF(B124=$B$61,B124,OFFSET($AB$11,B124,$P124-1)),OFFSET(C$81,$Q124+$B$69*$A109,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},10,{"$error":"#N/A"},1,"",""]
[2,15,{"$f":"IF(($A125+1)<C$79,\"\",IF($A125<C$79,IF(B125=$B$61,B125,OFFSET($AB$11,B125,$P125-1)),OFFSET(C$81,$Q125+$B$69*$A110,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","","",null,null,{"$error":"#N/A"},11,{"$error":"#N/A"},1,"",""]
[3,1,{"$f":"IF(($A126+1)<C$79,\"\",IF($A126<C$79,IF(B126=$B$61,B126,OFFSET($AB$11,B126,$P126-1)),OFFSET(C$81,$Q126+$B$69*$A111,)))","v":1},2,7,10,20,"","","","","",null,null,5453,1,0,1,6,false]
[3,2,{"$f":"IF(($A127+1)<C$79,\"\",IF($A127<C$79,IF(B127=$B$61,B127,OFFSET($AB$11,B127,$P127-1)),OFFSET(C$81,$Q127+$B$69*$A112,)))","v":1},{"$f":"IF(($A127+1)<D$79,\"\",IF($A127<D$79,IF(C127=$B$61,C127,OFFSET($AB$11,C127,$P127-1)),OFFSET(D$81,$Q127+$B$69*$A112,)))","v":4},3,9,12,"","","","","",null,null,4834,1,1,1,"",""]
[3,3,{"$f":"IF(($A128+1)<C$79,\"\",IF($A128<C$79,IF(B128=$B$61,B128,OFFSET($AB$11,B128,$P128-1)),OFFSET(C$81,$Q128+$B$69*$A113,)))","v":1},4,3,9,13,"","","","","",null,null,{"$f":"SUMPRODUCT(OFFSET($D$96,$B$69*A113+B113-1,,,A128),$B$61^(OFFSET($D$79,,,,A128)-1))","v":4834},{"$f":"COUNTIF(OFFSET($O$96,$B$69*(A128-1),,B128),O128)","v":2},{"$f":"IF(B128=1,0,IF(P127=INDEX(OFFSET($R$81,$B$69*A113,,$B$69),MATCH(OFFSET(D127,,A128-1),OFFSET($D$81,$B$69*A113,A128-1,$B$69),0)),Q127+1,Q127))","v":1},1,{"$f":"IF(B128=1,COUNT(OFFSET(C128,,,$B$69)),\"\")","v":""},""]
[3,4,{"$f":"IF(($A129+1)<C$79,\"\",IF($A129<C$79,IF(B129=$B$61,B129,OFFSET($AB$11,B129,$P129-1)),OFFSET(C$81,$Q129+$B$69*$A114,)))","v":1},4,5,8,11,"","","","","",null,null,4351,1,2,1,"",""]
[3,5,{"$f":"IF(($A130+1)<C$79,\"\",IF($A130<C$79,IF(B130=$B$61,B130,OFFSET($AB$11,B130,$P130-1)),OFFSET(C$81,$Q130+$B$69*$A115,)))","v":1},4,5,8,12,"","","","","",null,null,4351,2,2,1,"",""]
[3,6,{"$f":"IF(($A131+1)<C$79,\"\",IF($A131<C$79,IF(B131=$B$61,B131,OFFSET($AB$11,B131,$P131-1)),OFFSET(C$81,$Q131+$B$69*$A116,)))","v":1},6,14,18,20,"","","","","",null,null,9850,1,3,1,"",""]
[3,7,{"$f":"IF(($A132+1)<C$79,\"\",IF($A132<C$79,IF(B132=$B$61,B132,OFFSET($AB$11,B132,$P132-1)),OFFSET(C$81,$Q132+$B$69*$A117,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","",null,null,{"$error":"#N/A"},1,4,1,"",""]
[3,8,{"$f":"IF(($A133+1)<C$79,\"\",IF($A133<C$79,IF(B133=$B$61,B133,OFFSET($AB$11,B133,$P133-1)),OFFSET(C$81,$Q133+$B$69*$A118,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","",null,null,{"$error":"#N/A"},2,{"$error":"#N/A"},1,"",""]
[3,9,{"$f":"IF(($A134+1)<C$79,\"\",IF($A134<C$79,IF(B134=$B$61,B134,OFFSET($AB$11,B134,$P134-1)),OFFSET(C$81,$Q134+$B$69*$A119,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","",null,null,{"$error":"#N/A"},3,{"$error":"#N/A"},1,"",""]
[3,10,{"$f":"IF(($A135+1)<C$79,\"\",IF($A135<C$79,IF(B135=$B$61,B135,OFFSET($AB$11,B135,$P135-1)),OFFSET(C$81,$Q135+$B$69*$A120,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","",null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},1,"",""]
[3,11,{"$f":"IF(($A136+1)<C$79,\"\",IF($A136<C$79,IF(B136=$B$61,B136,OFFSET($AB$11,B136,$P136-1)),OFFSET(C$81,$Q136+$B$69*$A121,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","",null,null,{"$error":"#N/A"},5,{"$error":"#N/A"},1,"",""]
[3,12,{"$f":"IF(($A137+1)<C$79,\"\",IF($A137<C$79,IF(B137=$B$61,B137,OFFSET($AB$11,B137,$P137-1)),OFFSET(C$81,$Q137+$B$69*$A122,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","",null,null,{"$error":"#N/A"},6,{"$error":"#N/A"},1,"",""]
[3,13,{"$f":"IF(($A138+1)<C$79,\"\",IF($A138<C$79,IF(B138=$B$61,B138,OFFSET($AB$11,B138,$P138-1)),OFFSET(C$81,$Q138+$B$69*$A123,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","",null,null,{"$error":"#N/A"},7,{"$error":"#N/A"},1,"",""]
[3,14,{"$f":"IF(($A139+1)<C$79,\"\",IF($A139<C$79,IF(B139=$B$61,B139,OFFSET($AB$11,B139,$P139-1)),OFFSET(C$81,$Q139+$B$69*$A124,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","",null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},1,"",""]
[3,15,{"$f":"IF(($A140+1)<C$79,\"\",IF($A140<C$79,IF(B140=$B$61,B140,OFFSET($AB$11,B140,$P140-1)),OFFSET(C$81,$Q140+$B$69*$A125,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","","",null,null,{"$error":"#N/A"},9,{"$error":"#N/A"},1,"",""]
[4,1,{"$f":"IF(($A141+1)<C$79,\"\",IF($A141<C$79,IF(B141=$B$61,B141,OFFSET($AB$11,B141,$P141-1)),OFFSET(C$81,$Q141+$B$69*$A126,)))","v":1},2,7,10,20,21,"","","","",null,null,248793,1,0,1,6,false]
[4,2,{"$f":"IF(($A142+1)<C$79,\"\",IF($A142<C$79,IF(B142=$B$61,B142,OFFSET($AB$11,B142,$P142-1)),OFFSET(C$81,$Q142+$B$69*$A127,)))","v":1},{"$f":"IF(($A142+1)<D$79,\"\",IF($A142<D$79,IF(C142=$B$61,C142,OFFSET($AB$11,C142,$P142-1)),OFFSET(D$81,$Q142+$B$69*$A127,)))","v":4},3,9,12,16,"","","","",null,null,150838,1,1,1,"",""]
[4,3,{"$f":"IF(($A143+1)<C$79,\"\",IF($A143<C$79,IF(B143=$B$61,B143,OFFSET($AB$11,B143,$P143-1)),OFFSET(C$81,$Q143+$B$69*$A128,)))","v":1},4,3,9,13,17,"","","","",null,null,163005,1,2,2,"",""]
[4,4,{"$f":"IF(($A144+1)<C$79,\"\",IF($A144<C$79,IF(B144=$B$61,B144,OFFSET($AB$11,B144,$P144-1)),OFFSET(C$81,$Q144+$B$69*$A129,)))","v":1},4,5,8,11,15,"","","","",null,null,138188,1,3,1,"",""]
[{"$f":"INT((ROW()-ROW($A$96))/$B$69)+1","v":4},{"$f":"MOD((ROW()-ROW($A$96)),$B$69)+1","v":5},{"$f":"IF(($A145+1)<C$79,\"\",IF($A145<C$79,IF(B145=$B$61,B145,OFFSET($AB$11,B145,$P145-1)),OFFSET(C$81,$Q145+$B$69*$A130,)))","v":1},4,5,8,12,16,"","","","",null,null,150355,1,4,1,"",""]
[4,6,{"$f":"IF(($A146+1)<C$79,\"\",IF($A146<C$79,IF(B146=$B$61,B146,OFFSET($AB$11,B146,$P146-1)),OFFSET(C$81,$Q146+$B$69*$A131,)))","v":1},6,14,18,20,21,"","","","",null,null,253190,1,5,1,"",""]
[4,7,{"$f":"IF(($A147+1)<C$79,\"\",IF($A147<C$79,IF(B147=$B$61,B147,OFFSET($AB$11,B147,$P147-1)),OFFSET(C$81,$Q147+$B$69*$A132,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","",null,null,{"$error":"#N/A"},1,6,1,"",""]
[4,8,{"$f":"IF(($A148+1)<C$79,\"\",IF($A148<C$79,IF(B148=$B$61,B148,OFFSET($AB$11,B148,$P148-1)),OFFSET(C$81,$Q148+$B$69*$A133,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","",null,null,{"$error":"#N/A"},2,{"$error":"#N/A"},1,"",""]
[4,9,{"$f":"IF(($A149+1)<C$79,\"\",IF($A149<C$79,IF(B149=$B$61,B149,OFFSET($AB$11,B149,$P149-1)),OFFSET(C$81,$Q149+$B$69*$A134,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","",null,null,{"$error":"#N/A"},3,{"$error":"#N/A"},1,"",""]
[4,10,{"$f":"IF(($A150+1)<C$79,\"\",IF($A150<C$79,IF(B150=$B$61,B150,OFFSET($AB$11,B150,$P150-1)),OFFSET(C$81,$Q150+$B$69*$A135,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","",null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},1,"",""]
[4,11,{"$f":"IF(($A151+1)<C$79,\"\",IF($A151<C$79,IF(B151=$B$61,B151,OFFSET($AB$11,B151,$P151-1)),OFFSET(C$81,$Q151+$B$69*$A136,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","",null,null,{"$error":"#N/A"},5,{"$error":"#N/A"},1,"",""]
[4,12,{"$f":"IF(($A152+1)<C$79,\"\",IF($A152<C$79,IF(B152=$B$61,B152,OFFSET($AB$11,B152,$P152-1)),OFFSET(C$81,$Q152+$B$69*$A137,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","",null,null,{"$error":"#N/A"},6,{"$error":"#N/A"},1,"",""]
[4,13,{"$f":"IF(($A153+1)<C$79,\"\",IF($A153<C$79,IF(B153=$B$61,B153,OFFSET($AB$11,B153,$P153-1)),OFFSET(C$81,$Q153+$B$69*$A138,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","",null,null,{"$error":"#N/A"},7,{"$error":"#N/A"},1,"",""]
[4,14,{"$f":"IF(($A154+1)<C$79,\"\",IF($A154<C$79,IF(B154=$B$61,B154,OFFSET($AB$11,B154,$P154-1)),OFFSET(C$81,$Q154+$B$69*$A139,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","",null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},{"$f":"IFERROR(INDEX($AG$13:$AG$33,MATCH(OFFSET($D$81,B154-1+$B$69*A154,A154),$A$13:$A$33,0)),1)","v":1},"",""]
[4,15,{"$f":"IF(($A155+1)<C$79,\"\",IF($A155<C$79,IF(B155=$B$61,B155,OFFSET($AB$11,B155,$P155-1)),OFFSET(C$81,$Q155+$B$69*$A140,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","","",null,null,{"$error":"#N/A"},9,{"$error":"#N/A"},1,"",""]
[5,1,{"$f":"IF(($A156+1)<C$79,\"\",IF($A156<C$79,IF(B156=$B$61,B156,OFFSET($AB$11,B156,$P156-1)),OFFSET(C$81,$Q156+$B$69*$A141,)))","v":1},2,7,10,20,21,23,"","","",null,null,6125454,1,0,1,7,false]
[5,2,{"$f":"IF(($A157+1)<C$79,\"\",IF($A157<C$79,IF(B157=$B$61,B157,OFFSET($AB$11,B157,$P157-1)),OFFSET(C$81,$Q157+$B$69*$A142,)))","v":1},4,3,9,12,16,19,"","","",null,null,4628294,1,1,1,"",""]
[5,3,{"$f":"IF(($A158+1)<C$79,\"\",IF($A158<C$79,IF(B158=$B$61,B158,OFFSET($AB$11,B158,$P158-1)),OFFSET(C$81,$Q158+$B$69*$A143,)))","v":1},4,3,9,13,17,20,"","","",null,null,4920302,1,2,1,"",""]
[5,4,{"$f":"IF(($A159+1)<C$79,\"\",IF($A159<C$79,IF(B159=$B$61,B159,OFFSET($AB$11,B159,$P159-1)),OFFSET(C$81,$Q159+$B$69*$A144,)))","v":1},4,3,9,13,17,22,"","","",null,null,4920302,2,2,1,"",""]
[5,5,{"$f":"IF(($A160+1)<C$79,\"\",IF($A160<C$79,IF(B160=$B$61,B160,OFFSET($AB$11,B160,$P160-1)),OFFSET(C$81,$Q160+$B$69*$A145,)))","v":1},4,5,8,11,15,19,"","","",null,null,{"$f":"SUMPRODUCT(OFFSET($D$96,$B$69*A145+B145-1,,,A160),$B$61^(OFFSET($D$79,,,,A160)-1))","v":4335803},{"$f":"COUNTIF(OFFSET($O$96,$B$69*(A160-1),,B160),O160)","v":1},{"$f":"IF(B160=1,0,IF(P159=INDEX(OFFSET($R$81,$B$69*A145,,$B$69),MATCH(OFFSET(D159,,A160-1),OFFSET($D$81,$B$69*A145,A160-1,$B$69),0)),Q159+1,Q159))","v":3},1,{"$f":"IF(B160=1,COUNT(OFFSET(C160,,,$B$69)),\"\")","v":""},""]
[5,6,{"$f":"IF(($A161+1)<C$79,\"\",IF($A161<C$79,IF(B161=$B$61,B161,OFFSET($AB$11,B161,$P161-1)),OFFSET(C$81,$Q161+$B$69*$A146,)))","v":1},4,5,8,12,16,19,"","","",null,null,4627811,1,4,1,"",{"$f":"IF(B161=1,IF(SUMPRODUCT(--(OFFSET(C161,,A161+1,S161)=$B$61))=S161,TRUE),\"\")","v":""}]
[5,7,{"$f":"IF(($A162+1)<C$79,\"\",IF($A162<C$79,IF(B162=$B$61,B162,OFFSET($AB$11,B162,$P162-1)),OFFSET(C$81,$Q162+$B$69*$A147,)))","v":1},6,14,18,20,21,23,"","","",null,null,6129851,1,5,1,"",""]
[5,8,{"$f":"IF(($A163+1)<C$79,\"\",IF($A163<C$79,IF(B163=$B$61,B163,OFFSET($AB$11,B163,$P163-1)),OFFSET(C$81,$Q163+$B$69*$A148,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","",null,null,{"$error":"#N/A"},1,6,1,"",""]
[5,9,{"$f":"IF(($A164+1)<C$79,\"\",IF($A164<C$79,IF(B164=$B$61,B164,OFFSET($AB$11,B164,$P164-1)),OFFSET(C$81,$Q164+$B$69*$A149,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","",null,null,{"$error":"#N/A"},2,{"$error":"#N/A"},1,"",""]
[5,10,{"$f":"IF(($A165+1)<C$79,\"\",IF($A165<C$79,IF(B165=$B$61,B165,OFFSET($AB$11,B165,$P165-1)),OFFSET(C$81,$Q165+$B$69*$A150,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","",null,null,{"$error":"#N/A"},3,{"$error":"#N/A"},1,"",""]
[5,11,{"$f":"IF(($A166+1)<C$79,\"\",IF($A166<C$79,IF(B166=$B$61,B166,OFFSET($AB$11,B166,$P166-1)),OFFSET(C$81,$Q166+$B$69*$A151,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","",null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},1,"",""]
[5,12,{"$f":"IF(($A167+1)<C$79,\"\",IF($A167<C$79,IF(B167=$B$61,B167,OFFSET($AB$11,B167,$P167-1)),OFFSET(C$81,$Q167+$B$69*$A152,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","",null,null,{"$error":"#N/A"},5,{"$error":"#N/A"},1,"",""]
[5,13,{"$f":"IF(($A168+1)<C$79,\"\",IF($A168<C$79,IF(B168=$B$61,B168,OFFSET($AB$11,B168,$P168-1)),OFFSET(C$81,$Q168+$B$69*$A153,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","",null,null,{"$error":"#N/A"},6,{"$error":"#N/A"},1,"",""]
[5,14,{"$f":"IF(($A169+1)<C$79,\"\",IF($A169<C$79,IF(B169=$B$61,B169,OFFSET($AB$11,B169,$P169-1)),OFFSET(C$81,$Q169+$B$69*$A154,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","",null,null,{"$error":"#N/A"},7,{"$error":"#N/A"},1,"",""]
[5,15,{"$f":"IF(($A170+1)<C$79,\"\",IF($A170<C$79,IF(B170=$B$61,B170,OFFSET($AB$11,B170,$P170-1)),OFFSET(C$81,$Q170+$B$69*$A155,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","","",null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},1,"",""]
[6,1,{"$f":"IF(($A171+1)<C$79,\"\",IF($A171<C$79,IF(B171=$B$61,B171,OFFSET($AB$11,B171,$P171-1)),OFFSET(C$81,$Q171+$B$69*$A156,)))","v":1},2,7,10,20,21,23,23,"","",null,null,154161343,1,0,1,7,false]
[6,2,{"$f":"IF(($A172+1)<C$79,\"\",IF($A172<C$79,IF(B172=$B$61,B172,OFFSET($AB$11,B172,$P172-1)),OFFSET(C$81,$Q172+$B$69*$A157,)))","v":1},4,3,9,12,16,19,22,"","",null,null,126918811,1,1,1,"",""]
[6,3,{"$f":"IF(($A173+1)<C$79,\"\",IF($A173<C$79,IF(B173=$B$61,B173,OFFSET($AB$11,B173,$P173-1)),OFFSET(C$81,$Q173+$B$69*$A158,)))","v":1},4,3,9,13,17,20,21,"","",null,null,133647162,1,2,1,"",""]
[6,4,{"$f":"IF(($A174+1)<C$79,\"\",IF($A174<C$79,IF(B174=$B$61,B174,OFFSET($AB$11,B174,$P174-1)),OFFSET(C$81,$Q174+$B$69*$A159,)))","v":1},4,3,9,13,17,22,23,"","",null,null,146519848,1,3,1,"",""]
[6,5,{"$f":"IF(($A175+1)<C$79,\"\",IF($A175<C$79,IF(B175=$B$61,B175,OFFSET($AB$11,B175,$P175-1)),OFFSET(C$81,$Q175+$B$69*$A160,)))","v":1},4,5,8,11,15,19,22,"","",null,null,126626320,1,4,1,"",""]
[6,6,{"$f":"IF(($A176+1)<C$79,\"\",IF($A176<C$79,IF(B176=$B$61,B176,OFFSET($AB$11,B176,$P176-1)),OFFSET(C$81,$Q176+$B$69*$A161,)))","v":1},4,5,8,12,16,19,22,"","",null,null,126918328,1,5,1,"",{"$f":"IF(B176=1,IF(SUMPRODUCT(--(OFFSET(C176,,A176+1,S176)=$B$61))=S176,TRUE),\"\")","v":""}]
[{"$f":"INT((ROW()-ROW($A$96))/$B$69)+1","v":6},{"$f":"MOD((ROW()-ROW($A$96)),$B$69)+1","v":7},{"$f":"IF(($A177+1)<C$79,\"\",IF($A177<C$79,IF(B177=$B$61,B177,OFFSET($AB$11,B177,$P177-1)),OFFSET(C$81,$Q177+$B$69*$A162,)))","v":1},6,14,18,20,21,23,23,"","",null,null,154165740,1,6,1,"",""]
[6,8,{"$f":"IF(($A178+1)<C$79,\"\",IF($A178<C$79,IF(B178=$B$61,B178,OFFSET($AB$11,B178,$P178-1)),OFFSET(C$81,$Q178+$B$69*$A163,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,null,{"$error":"#N/A"},1,7,1,"",""]
[6,9,{"$f":"IF(($A179+1)<C$79,\"\",IF($A179<C$79,IF(B179=$B$61,B179,OFFSET($AB$11,B179,$P179-1)),OFFSET(C$81,$Q179+$B$69*$A164,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,null,{"$error":"#N/A"},2,{"$error":"#N/A"},1,"",""]
[6,10,{"$f":"IF(($A180+1)<C$79,\"\",IF($A180<C$79,IF(B180=$B$61,B180,OFFSET($AB$11,B180,$P180-1)),OFFSET(C$81,$Q180+$B$69*$A165,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,null,{"$error":"#N/A"},3,{"$error":"#N/A"},1,"",""]
[6,11,{"$f":"IF(($A181+1)<C$79,\"\",IF($A181<C$79,IF(B181=$B$61,B181,OFFSET($AB$11,B181,$P181-1)),OFFSET(C$81,$Q181+$B$69*$A166,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},1,"",""]
[6,12,{"$f":"IF(($A182+1)<C$79,\"\",IF($A182<C$79,IF(B182=$B$61,B182,OFFSET($AB$11,B182,$P182-1)),OFFSET(C$81,$Q182+$B$69*$A167,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,null,{"$error":"#N/A"},5,{"$error":"#N/A"},1,"",""]
[6,13,{"$f":"IF(($A183+1)<C$79,\"\",IF($A183<C$79,IF(B183=$B$61,B183,OFFSET($AB$11,B183,$P183-1)),OFFSET(C$81,$Q183+$B$69*$A168,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,null,{"$error":"#N/A"},6,{"$error":"#N/A"},1,"",""]
[6,14,{"$f":"IF(($A184+1)<C$79,\"\",IF($A184<C$79,IF(B184=$B$61,B184,OFFSET($AB$11,B184,$P184-1)),OFFSET(C$81,$Q184+$B$69*$A169,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,null,{"$error":"#N/A"},7,{"$error":"#N/A"},1,"",""]
[6,15,{"$f":"IF(($A185+1)<C$79,\"\",IF($A185<C$79,IF(B185=$B$61,B185,OFFSET($AB$11,B185,$P185-1)),OFFSET(C$81,$Q185+$B$69*$A170,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},1,"",""]
[7,1,{"$f":"IF(($A186+1)<C$79,\"\",IF($A186<C$79,IF(B186=$B$61,B186,OFFSET($AB$11,B186,$P186-1)),OFFSET(C$81,$Q186+$B$69*$A171,)))","v":1},2,7,10,20,21,23,23,23,"",null,null,3558986790,1,0,{"$f":"IFERROR(INDEX($AG$13:$AG$33,MATCH(OFFSET($D$81,B186-1+$B$69*A186,A186),$A$13:$A$33,0)),1)","v":1},7,{"$f":"IF(B186=1,IF(SUMPRODUCT(--(OFFSET(C186,,A186+1,S186)=$B$61))=S186,TRUE),\"\")","v":true}]
[7,2,{"$f":"IF(($A187+1)<C$79,\"\",IF($A187<C$79,IF(B187=$B$61,B187,OFFSET($AB$11,B187,$P187-1)),OFFSET(C$81,$Q187+$B$69*$A172,)))","v":1},4,3,9,12,16,19,22,23,"",null,null,3383708369,1,1,1,"",""]
[7,3,{"$f":"IF(($A188+1)<C$79,\"\",IF($A188<C$79,IF(B188=$B$61,B188,OFFSET($AB$11,B188,$P188-1)),OFFSET(C$81,$Q188+$B$69*$A173,)))","v":1},4,3,9,13,17,20,21,23,"",null,null,3242400831,1,2,1,"",""]
[7,4,{"$f":"IF(($A189+1)<C$79,\"\",IF($A189<C$79,IF(B189=$B$61,B189,OFFSET($AB$11,B189,$P189-1)),OFFSET(C$81,$Q189+$B$69*$A174,)))","v":1},4,3,9,13,17,22,23,23,"",null,null,3551345295,1,3,1,"",""]
[7,5,{"$f":"IF(($A190+1)<C$79,\"\",IF($A190<C$79,IF(B190=$B$61,B190,OFFSET($AB$11,B190,$P190-1)),OFFSET(C$81,$Q190+$B$69*$A175,)))","v":1},4,5,8,11,15,19,22,23,"",null,null,3383415878,1,4,1,"",""]
[7,6,{"$f":"IF(($A191+1)<C$79,\"\",IF($A191<C$79,IF(B191=$B$61,B191,OFFSET($AB$11,B191,$P191-1)),OFFSET(C$81,$Q191+$B$69*$A176,)))","v":1},4,5,8,12,16,19,22,23,"",null,null,3383707886,1,5,1,"",""]
[7,7,{"$f":"IF(($A192+1)<C$79,\"\",IF($A192<C$79,IF(B192=$B$61,B192,OFFSET($AB$11,B192,$P192-1)),OFFSET(C$81,$Q192+$B$69*$A177,)))","v":1},6,14,18,20,21,23,23,23,"",null,null,{"$f":"SUMPRODUCT(OFFSET($D$96,$B$69*A177+B177-1,,,A192),$B$61^(OFFSET($D$79,,,,A192)-1))","v":3558991187},{"$f":"COUNTIF(OFFSET($O$96,$B$69*(A192-1),,B192),O192)","v":1},{"$f":"IF(B192=1,0,IF(P191=INDEX(OFFSET($R$81,$B$69*A177,,$B$69),MATCH(OFFSET(D191,,A192-1),OFFSET($D$81,$B$69*A177,A192-1,$B$69),0)),Q191+1,Q191))","v":6},1,{"$f":"IF(B192=1,COUNT(OFFSET(C192,,,$B$69)),\"\")","v":""},""]
[7,8,{"$f":"IF(($A193+1)<C$79,\"\",IF($A193<C$79,IF(B193=$B$61,B193,OFFSET($AB$11,B193,$P193-1)),OFFSET(C$81,$Q193+$B$69*$A178,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",null,null,{"$error":"#N/A"},1,7,1,"",""]
[7,9,{"$f":"IF(($A194+1)<C$79,\"\",IF($A194<C$79,IF(B194=$B$61,B194,OFFSET($AB$11,B194,$P194-1)),OFFSET(C$81,$Q194+$B$69*$A179,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",null,null,{"$error":"#N/A"},2,{"$error":"#N/A"},1,"",""]
[7,10,{"$f":"IF(($A195+1)<C$79,\"\",IF($A195<C$79,IF(B195=$B$61,B195,OFFSET($AB$11,B195,$P195-1)),OFFSET(C$81,$Q195+$B$69*$A180,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",null,null,{"$error":"#N/A"},3,{"$error":"#N/A"},1,"",""]
[7,11,{"$f":"IF(($A196+1)<C$79,\"\",IF($A196<C$79,IF(B196=$B$61,B196,OFFSET($AB$11,B196,$P196-1)),OFFSET(C$81,$Q196+$B$69*$A181,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},1,"",""]
[7,12,{"$f":"IF(($A197+1)<C$79,\"\",IF($A197<C$79,IF(B197=$B$61,B197,OFFSET($AB$11,B197,$P197-1)),OFFSET(C$81,$Q197+$B$69*$A182,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",null,null,{"$error":"#N/A"},5,{"$error":"#N/A"},1,"",""]
[7,13,{"$f":"IF(($A198+1)<C$79,\"\",IF($A198<C$79,IF(B198=$B$61,B198,OFFSET($AB$11,B198,$P198-1)),OFFSET(C$81,$Q198+$B$69*$A183,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",null,null,{"$error":"#N/A"},6,{"$error":"#N/A"},1,"",""]
[7,14,{"$f":"IF(($A199+1)<C$79,\"\",IF($A199<C$79,IF(B199=$B$61,B199,OFFSET($AB$11,B199,$P199-1)),OFFSET(C$81,$Q199+$B$69*$A184,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",null,null,{"$error":"#N/A"},7,{"$error":"#N/A"},1,"",""]
[7,15,{"$f":"IF(($A200+1)<C$79,\"\",IF($A200<C$79,IF(B200=$B$61,B200,OFFSET($AB$11,B200,$P200-1)),OFFSET(C$81,$Q200+$B$69*$A185,)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},1,"",""]

{"sheet":"Сетевая диаграмма (на листе)","index":1,"n_rows":22,"n_cols":32,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,27,12,29],[16,27,16,29],[16,23,16,25],[4,19,4,21],[6,23,6,25],[8,19,8,21],[12,19,12,21],[6,11,6,13],[10,11,10,13],[16,11,16,13],[20,11,20,13],[4,15,4,17],[8,15,8,17],[12,15,12,17],[1,3,1,5],[8,3,8,5],[16,3,16,5],[20,3,20,5],[6,7,6,9],[10,7,10,9],[16,7,16,9],[20,7,20,9]]}
[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":"N6","v":27},{"$f":"VLOOKUP(P5,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":10},{"$f":"P4+Q4","v":37},null,{"$f":"R4","v":37},{"$f":"VLOOKUP(T5,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":11},{"$f":"T4+U4","v":48}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Сетевая диаграмма'!B22","v":"J"},null,null,null,{"$f":"'Сетевая диаграмма'!B26","v":"N"}]
[null,null,null,null,null,null,null,{"$f":"F8","v":9},{"$f":"VLOOKUP(H7,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":10},{"$f":"H6+I6","v":19},null,{"$f":"J6","v":19},{"$f":"VLOOKUP(L7,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":8},{"$f":"L6+M6","v":27},null,{"$f":"R6-Q4","v":27},{"$f":"R6-R4","v":0},{"$f":"T6","v":37},null,{"$f":"V6-U4","v":37},{"$f":"V6-V4","v":0},{"$f":"X8","v":48},null,{"$f":"MAX(V4,V8)","v":48},{"$f":"VLOOKUP(X7,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":11},{"$f":"X6+Y6","v":59}]
[null,null,null,null,null,null,null,{"$f":"'Сетевая диаграмма'!B16","v":"D"},null,null,null,{"$f":"'Сетевая диаграмма'!B19","v":"G"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Сетевая диаграмма'!B30","v":"R"}]
[null,null,null,{"$f":"$B$18","v":0},{"$f":"VLOOKUP(D9,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":9},{"$f":"D8+E8","v":9},null,{"$f":"J8-I6","v":9},{"$f":"J8-J6","v":0},{"$f":"L8","v":19},null,{"$f":"N8-M6","v":19},{"$f":"N8-N6","v":0},{"$f":"MIN(P6,P10)","v":27},null,{"$f":"MAX(N6,N10)","v":27},{"$f":"VLOOKUP(P9,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":13},{"$f":"P8+Q8","v":40},null,{"$f":"R8","v":40},{"$f":"VLOOKUP(T9,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":7},{"$f":"T8+U8","v":47},null,{"$f":"Z8-Y6","v":48},{"$f":"Z8-Z6","v":0},{"$f":"AB14","v":59}]
[null,null,null,{"$f":"'Сетевая диаграмма'!B15","v":"C"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Сетевая диаграмма'!B23","v":"K"},null,null,null,{"$f":"'Сетевая диаграмма'!B27","v":"O"}]
[null,null,null,{"$f":"F10-E8","v":0},{"$f":"F10-F8","v":0},{"$f":"MIN(H8,H12)","v":9},null,{"$f":"F8","v":9},{"$f":"VLOOKUP(H11,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":10},{"$f":"H10+I10","v":19},null,{"$f":"J10","v":19},{"$f":"VLOOKUP(L11,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":8},{"$f":"L10+M10","v":27},null,{"$f":"R10-Q8","v":28},{"$f":"R10-R8","v":1},{"$f":"T10","v":41},null,{"$f":"V10-U8","v":41},{"$f":"V10-V8","v":1},{"$f":"X8","v":48}]
[null,null,null,null,null,null,null,{"$f":"'Сетевая диаграмма'!B14","v":"B"},null,null,null,{"$f":"'Сетевая диаграмма'!B20","v":"H"}]
[null,null,null,null,null,null,null,{"$f":"J12-I10","v":10},{"$f":"J12-J10","v":1},{"$f":"L12","v":20},null,{"$f":"N12-M10","v":20},{"$f":"N12-N10","v":1},{"$f":"MIN(P10,P14)","v":28},null,{"$f":"N10","v":27},{"$f":"VLOOKUP(P13,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":6},{"$f":"P12+Q12","v":33},null,{"$f":"R12","v":33},{"$f":"VLOOKUP(T13,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":10},{"$f":"T12+U12","v":43},null,null,null,null,null,{"$f":"MAX(Z6,V12)","v":59},{"$f":"VLOOKUP(AB13,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":6},{"$f":"AB12+AC12","v":65}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Сетевая диаграмма'!B24","v":"L"},null,null,null,{"$f":"'Сетевая диаграмма'!B28","v":"P"},null,null,null,null,null,null,null,{"$f":"'Сетевая диаграмма'!B33","v":"U"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R14-Q12","v":30},{"$f":"R14-R12","v":3},{"$f":"T14","v":36},null,{"$f":"V14-U12","v":36},{"$f":"V14-V12","v":3},{"$f":"MIN(AB14,X18)","v":46},null,null,null,null,null,{"$f":"AD14-AC12","v":59},{"$f":"AD14-AD12","v":0},{"$f":"AF16","v":65}]
[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,null,null,null,null,null,null,"Окончание"]
[null,null,null,{"$f":"$B$18","v":0},{"$f":"VLOOKUP(D17,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":12},{"$f":"D16+E16","v":12},null,{"$f":"F16","v":12},{"$f":"VLOOKUP(H17,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":14},{"$f":"H16+I16","v":26},null,{"$f":"J16","v":26},{"$f":"VLOOKUP(L17,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":15},{"$f":"L16+M16","v":41},null,null,null,null,null,null,null,null,null,{"$f":"MAX(V12,N16,N20)","v":43},{"$f":"VLOOKUP(X17,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":8},{"$f":"X16+Y16","v":51},null,{"$f":"Z16","v":51},{"$f":"VLOOKUP(AB17,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":11},{"$f":"AB16+AC16","v":62},null,{"$f":"MAX(AD12,AD16)","v":65}]
[null,{"$f":"'Сетевая диаграмма'!A12","v":1},null,{"$f":"'Сетевая диаграмма'!B13","v":"A"},null,null,null,{"$f":"'Сетевая диаграмма'!B18","v":"F"},null,null,null,{"$f":"'Сетевая диаграмма'!B21","v":"I"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Сетевая диаграмма'!B31","v":"S"},null,null,null,{"$f":"'Сетевая диаграмма'!B32","v":"T"}]
[null,0,null,{"$f":"F18-E16","v":5},{"$f":"F18-F16","v":5},{"$f":"H18","v":17},null,{"$f":"J18-I16","v":17},{"$f":"J18-J16","v":5},{"$f":"L18","v":31},null,{"$f":"N18-M16","v":31},{"$f":"N18-N16","v":5},{"$f":"X18","v":46},null,null,null,null,null,null,null,null,null,{"$f":"Z18-Y16","v":46},{"$f":"Z18-Z16","v":3},{"$f":"AB18","v":54},null,{"$f":"AD18-AC16","v":54},{"$f":"AD18-AD16","v":3},{"$f":"AF16","v":65}]
[]
[null,null,null,{"$f":"$B$18","v":0},{"$f":"VLOOKUP(D21,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":11},{"$f":"D20+E20","v":11},null,{"$f":"F20","v":11},{"$f":"VLOOKUP(H21,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":11},{"$f":"H20+I20","v":22},null,{"$f":"J20","v":22},{"$f":"VLOOKUP(L21,'Сетевая диаграмма'!$B$13:$C$33,2,0)","v":16},{"$f":"L20+M20","v":38}]
[null,null,null,{"$f":"'Сетевая диаграмма'!B17","v":"E"},null,null,null,{"$f":"'Сетевая диаграмма'!B25","v":"M"},null,null,null,{"$f":"'Сетевая диаграмма'!B29","v":"Q"}]
[null,null,null,{"$f":"F22-E20","v":8},{"$f":"F22-F20","v":8},{"$f":"H22","v":19},null,{"$f":"J22-I20","v":19},{"$f":"J22-J20","v":8},{"$f":"L22","v":30},null,{"$f":"N22-M20","v":30},{"$f":"N22-N20","v":8},{"$f":"X18","v":46}]

{"sheet":"EXCEL2.RU","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["EXCEL2.RU - профессиональные приемы для всех >>>"]
["Хорошая новость! Большинство задач, которые Вы хотите решить с помощью MS EXCEL – уже давно решены! \nНа нашем сайте Вы найдете решения множества из наиболее часто встречающихся задач. Сайт содержит более 500 качественно оформленных статей с файлами примеров."]
["Миссия нашего сайта - превратить Вашу работу в MS EXCEL в приятное времяпрепровождение и ускорить решение Ваших задач. Мы постоянно работаем над содержанием и оформлением нашего сайта и благодарим активных пользователей за поддержку и неоценимую помощь в нашей работе."]