{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Пример","EXCEL2.RU"],"not_rendered":{"charts":1,"images":0,"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":90,"n_cols":27,"rows_kept":90,"cut":false,"hidden":false,"merged":[[20,9,21,9]]}
["Файл скачан с сайта excel2.ru >>>"]
["Перейти к статье >>>"]
["Автоматическая сетевая диаграмма проекта в MS EXCEL"]
["Автоматическое определение всех путей проекта"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Ограничения модели:"]
[null,null,null,null,null,null,null,null,null,null,null,1,"Число путей - 10"]
[null,null,null,null,null,null,null,null,null,null,null,2,"Число последователей у каждой работы - не более 3"]
[null,null,null,null,null,null,null,null,null,null,null,3,"Число предшественников у каждой работы - не более 3"]
[null,null,null,null,null,null,null,null,null,null,null,4,"Максимальная длина пути от вехи Start до вехи Finish - 5 (включая эти вехи). Под длиной пути понимается последовательность работ, например: Start - a - d - g - Finish"]
[null,null,null,null,null,null,null,null,null,null,null,5,"Взаимосвязь работ только Финиш-Старт, т.е. начало следующей после окончания предыдущей"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,1,2,3,null,null,null,null,"Для диаграммы"]
["#","Работы","Последователи",null,null,"Последователи (коды)",null,null,"Кол-во последователей","Кол-во предшественников",null,"Предшественники (коды)",null,null,"Предшественники",null,null,null,{"$f":"B21","v":"Работы"},"Х","Y"]
[1,"Start","A","B","C",{"$f":"IFERROR(INDEX($A$22:$A$30,MATCH(C22,$B$22:$B$30,0)),\"\")","v":2},{"$f":"IFERROR(INDEX($A$22:$A$30,MATCH(D22,$B$22:$B$30,0)),\"\")","v":3},4,{"$f":"COUNT(F22:H22)","v":3},null,null,null,null,null,null,null,null,null,"Start",10,2]
[2,"A","D",null,null,{"$f":"IFERROR(INDEX($A$22:$A$30,MATCH(C23,$B$22:$B$30,0)),\"\")","v":5},"","",{"$f":"COUNT(F23:H23)","v":1},{"$f":"COUNTIF($C$22:$E$29,B23)","v":1},null,{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A23=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),L$20)),\"\")","v":1},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A23=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),M$20)),\"\")","v":""},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A23=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),N$20)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$22:$B$30,MATCH(L23,$A$22:$A$30,0)),\"\")","v":"Start"},"","",null,"A",20,3]
[3,"B","E",null,null,6,"","",1,{"$f":"COUNTIF($C$22:$E$29,B24)","v":1},null,{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A24=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),L$20)),\"\")","v":1},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A24=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),M$20)),\"\")","v":""},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A24=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),N$20)),\"\")","v":""},"Start","","",null,"B",20,2]
[4,"C","F",null,null,7,"","",1,1,null,{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A25=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),L$20)),\"\")","v":1},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A25=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),M$20)),\"\")","v":""},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A25=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),N$20)),\"\")","v":""},"Start","","",null,"C",20,1]
[5,"D","Finish",null,null,9,"","",1,1,null,{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A26=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),L$20)),\"\")","v":2},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A26=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),M$20)),\"\")","v":""},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A26=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),N$20)),\"\")","v":""},"A","","",null,"D",30,3]
[6,"E","G",null,null,8,"","",1,1,null,{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A27=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),L$20)),\"\")","v":3},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A27=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),M$20)),\"\")","v":""},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A27=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),N$20)),\"\")","v":""},"B","","",null,"E",30,2]
[7,"F","Finish",null,null,9,"","",1,1,null,{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A28=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),L$20)),\"\")","v":4},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A28=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),M$20)),\"\")","v":""},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A28=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),N$20)),\"\")","v":""},"C","","",null,"F",30,1]
[8,"G","Finish",null,null,9,"","",1,1,null,{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A29=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),L$20)),\"\")","v":6},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A29=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),M$20)),\"\")","v":""},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A29=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),N$20)),\"\")","v":""},"E","","",null,"G",40,2]
[9,"Finish",null,null,null,null,null,null,null,3,null,{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A30=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),L$20)),\"\")","v":8},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A30=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),M$20)),\"\")","v":7},{"$f":"IFERROR(INDEX($A$22:$A$29,LARGE(IF($A30=$F$22:$H$29,ROW($F$22:$F$29)-ROW($F$21),\"\"),N$20)),\"\")","v":5},"G","F","D",null,"Finish",50,2]
[]
["Работ",{"$f":"COUNT(A22:A30)","v":9},null,"Смещение"]
["Путей",{"$f":"INDEX($M$53:$M$81,D33)","v":3},null,{"$f":"MATCH(TRUE,N53:N81,0)","v":29}]
["Шагов",{"$f":"INDEX($B$50:$B$78,D33)","v":3}]
["Макс длина пути",{"$f":"B34+2","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Для диаграммы"]
["Шаг",0,"Определяем последователей начальной вехи",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Координата Х"]
["№ пути","ур. 0 с повторами","уровень 1","кол-во повторов",null,"№ пути",0,1,2,3,4,"Длина пути",null,"№ пути",0,1,2,3,4,null,"Показать?","№ пути",0,1,2,3,4]
[1,{"$f":"IF(A39<=$I$22,$A$22,NA())","v":1},{"$f":"IF(ISNA(B39),NA(),OFFSET($F$22,,A39-1))","v":2},{"$f":"IFERROR(INDEX($I$23:$I$29,MATCH(C39,$A$23:$A$29,0)),1)","v":1},null,{"$f":"IF($A39>$B$33,\"\",A39)","v":1},{"$f":"IF(OR($A39>$B$33,G$38>($B$34+1)),\"\",OFFSET($B$52,$D$33+$F39-1,G$38+IF(G$38>$B$34,-G$38+8,0)))","v":1},2,{"$f":"IF(OR($A39>$B$33,I$38>($B$34+1)),\"\",OFFSET($B$52,$D$33+$F39-1,I$38+IF(I$38>$B$34,-I$38+8,0)))","v":5},{"$f":"IF(OR($A39>$B$33,J$38>($B$34+1)),\"\",OFFSET($B$52,$D$33+$F39-1,J$38+IF(J$38>$B$34,-J$38+8,0)))","v":9},{"$f":"IF(OR($A39>$B$33,K$38>($B$34+1)),\"\",OFFSET($B$52,$D$33+$F39-1,K$38+IF(K$38>$B$34,-K$38+8,0)))","v":9},{"$f":"IFERROR(MATCH($B$32,G39:K39,0),\"\")","v":4},null,{"$f":"F39","v":1},{"$f":"IFERROR(IF((O$38+1)>$L39,\"\",VLOOKUP(G39,$A$22:$B$30,2,0)),\"\")","v":"Start"},{"$f":"IFERROR(IF((P$38+1)>$L39,\"\",VLOOKUP(H39,$A$22:$B$30,2,0)),\"\")","v":"A"},{"$f":"IFERROR(IF((Q$38+1)>$L39,\"\",VLOOKUP(I39,$A$22:$B$30,2,0)),\"\")","v":"D"},{"$f":"IFERROR(IF((R$38+1)>$L39,\"\",VLOOKUP(J39,$A$22:$B$30,2,0)),\"\")","v":"Finish"},{"$f":"IFERROR(IF((S$38+1)>$L39,\"\",VLOOKUP(K39,$A$22:$B$30,2,0)),\"\")","v":""},null,1,{"$f":"\"Путь_\"&N39&\"(Х)\"","v":"Путь_1(Х)"},{"$f":"IF($U39,VLOOKUP(O39,$S$22:$U$30,2,0),NA())","v":10},{"$f":"IF($U39,VLOOKUP(P39,$S$22:$U$30,2,0),NA())","v":20},{"$f":"IF($U39,VLOOKUP(Q39,$S$22:$U$30,2,0),NA())","v":30},{"$f":"IF($U39,VLOOKUP(R39,$S$22:$U$30,2,0),NA())","v":50},{"$f":"IF($U39,VLOOKUP(S39,$S$22:$U$30,2,0),NA())","v":{"$error":"#N/A"}}]
[2,{"$f":"IF(A40<=$I$22,$A$22,NA())","v":1},3,{"$f":"IFERROR(INDEX($I$23:$I$29,MATCH(C40,$A$23:$A$29,0)),1)","v":1},null,2,1,3,6,8,9,5,null,2,"Start","B","E","G","Finish",null,1,"Путь_2(Х)",10,20,30,40,50]
[3,1,4,1,null,3,1,4,7,9,9,4,null,3,"Start","C","F","Finish","",null,1,"Путь_3(Х)",10,20,30,50,{"$error":"#N/A"}]
[4,{"$error":"#N/A"},{"$error":"#N/A"},1,null,"","","","","","","",null,"","","","","","",null,1,"Путь_(Х)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,{"$error":"#N/A"},{"$error":"#N/A"},1,null,"","","","","","","",null,"","","","","","",null,1,"Путь_(Х)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,{"$error":"#N/A"},{"$error":"#N/A"},1,null,"","","","","","","",null,"","","","","","",null,1,"Путь_(Х)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,{"$error":"#N/A"},{"$error":"#N/A"},1,null,"","","","","","","",null,"","","","","","",null,1,"Путь_(Х)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,{"$error":"#N/A"},{"$error":"#N/A"},1,null,"","","","","","","",null,"","","","","","",null,1,"Путь_(Х)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,{"$error":"#N/A"},{"$error":"#N/A"},1,null,"","","","","","","",null,"","","","","","",null,1,"Путь_(Х)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,{"$error":"#N/A"},{"$error":"#N/A"},1,null,"","","","","","","",null,"","","","","","",null,1,"Путь_(Х)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Шаг",1,"Определяем последователей работ уровня 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Координата Y"]
[null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"№ пути",0,1,2,3,4]
["№ пути","0 с повторами","1 с повторами",null,null,null,"№ повтора","Смещение",null,"уровень 2","кол-во повторов",null,"Число путей","Завершено?",null,null,null,null,null,null,null,{"$f":"\"Путь_\"&N39&\"(Y)\"","v":"Путь_1(Y)"},{"$f":"VLOOKUP(O39,$S$22:$U$30,3,0)","v":2},{"$f":"VLOOKUP(P39,$S$22:$U$30,3,0)","v":3},{"$f":"VLOOKUP(Q39,$S$22:$U$30,3,0)","v":3},{"$f":"VLOOKUP(R39,$S$22:$U$30,3,0)","v":2},{"$f":"VLOOKUP(S39,$S$22:$U$30,3,0)","v":{"$error":"#N/A"}}]
[1,{"$f":"OFFSET($B$39,H53,)","v":1},{"$f":"OFFSET($C$39,H53,)","v":2},null,null,null,{"$f":"COUNTIF($C$53:C53,C53)","v":1},{"$f":"IF($A53=1,0,IF(G52=INDEX($D$39:$D$48,MATCH(C52,$C$39:$C$48,0)),H52+1,H52))","v":0},null,{"$f":"IF(C53=$B$32,C53,OFFSET($F$21,C53,G53-1))","v":5},{"$f":"IFERROR(INDEX($I$23:$I$29,MATCH(J53,$A$23:$A$29,0)),1)","v":1},null,{"$f":"COUNT(J53:J62)","v":3},{"$f":"IF(SUMPRODUCT(--(OFFSET(J53,,,M53)=$B$32))=M53,TRUE)","v":false},null,null,null,null,null,null,null,"Путь_2(Y)",2,2,2,2,2]
[2,1,3,null,null,null,{"$f":"COUNTIF($C$53:C54,C54)","v":1},1,null,{"$f":"IF(C54=$B$32,C54,OFFSET($F$21,C54,G54-1))","v":6},{"$f":"IFERROR(INDEX($I$23:$I$29,MATCH(J54,$A$23:$A$29,0)),1)","v":1},null,null,null,null,null,null,null,null,null,null,"Путь_3(Y)",2,1,1,2,{"$error":"#N/A"}]
[3,1,4,null,null,null,{"$f":"COUNTIF($C$53:C55,C55)","v":1},2,null,7,1,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"}]
[4,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"COUNTIF($C$53:C56,C56)","v":1},3,null,{"$error":"#N/A"},1,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"}]
[5,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"COUNTIF($C$53:C57,C57)","v":2},{"$error":"#N/A"},null,{"$error":"#N/A"},1,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"}]
[6,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"COUNTIF($C$53:C58,C58)","v":3},{"$error":"#N/A"},null,{"$error":"#N/A"},1,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"}]
[7,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"COUNTIF($C$53:C59,C59)","v":4},{"$error":"#N/A"},null,{"$error":"#N/A"},1,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"}]
[8,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"COUNTIF($C$53:C60,C60)","v":5},{"$error":"#N/A"},null,{"$error":"#N/A"},1,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"}]
[9,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"COUNTIF($C$53:C61,C61)","v":6},{"$error":"#N/A"},null,{"$error":"#N/A"},1,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"}]
[10,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"COUNTIF($C$53:C62,C62)","v":7},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[]
["Шаг",2,"Определяем последователей работ уровня 2"]
[null,0,1,2]
["№ пути","0 с повторами","1 с повторами","2 с повторами",null,"1+2","№ повтора","Смещение",null,"уровень 3","кол-во повторов",null,"Число путей","Завершено?"]
[1,{"$f":"OFFSET($B$53,H67,)","v":1},{"$f":"OFFSET($C$53,H67,)","v":2},{"$f":"OFFSET($J$53,H67,)","v":5},null,{"$f":"SUMPRODUCT(C67:D67,$B$32^(C$65:D$65-1))","v":47},{"$f":"COUNTIF($F$67:F67,F67)","v":1},{"$f":"IF($A67=1,0,IF(G66=INDEX($K$53:$K$62,MATCH(D66,$J$53:$J$62,0)),H66+1,H66))","v":0},null,{"$f":"IF(D67=$B$32,D67,OFFSET($F$21,D67,G67-1))","v":9},{"$f":"IFERROR(INDEX($I$23:$I$29,MATCH(J67,$A$23:$A$29,0)),1)","v":1},null,{"$f":"COUNT(J67:J76)","v":3},{"$f":"IF(SUMPRODUCT(--(OFFSET(J67,,,M67)=$B$32))=M67,TRUE)","v":false}]
[2,1,3,6,null,57,{"$f":"COUNTIF($F$67:F68,F68)","v":1},{"$f":"IF($A68=1,0,IF(G67=INDEX($K$53:$K$62,MATCH(D67,$J$53:$J$62,0)),H67+1,H67))","v":1},null,{"$f":"IF(D68=$B$32,D68,OFFSET($F$21,D68,G68-1))","v":8},{"$f":"IFERROR(INDEX($I$23:$I$29,MATCH(J68,$A$23:$A$29,0)),1)","v":1}]
[3,1,4,7,null,67,{"$f":"COUNTIF($F$67:F69,F69)","v":1},2,null,9,1]
[4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"COUNTIF($F$67:F70,F70)","v":1},3,null,{"$error":"#N/A"},1]
[5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"COUNTIF($F$67:F71,F71)","v":2},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[6,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"COUNTIF($F$67:F72,F72)","v":3},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[7,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"COUNTIF($F$67:F73,F73)","v":4},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[8,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"COUNTIF($F$67:F74,F74)","v":5},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[9,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"COUNTIF($F$67:F75,F75)","v":6},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[10,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"COUNTIF($F$67:F76,F76)","v":7},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[]
["Шаг",3,"Определяем последователей работ уровня 3"]
[null,0,1,2,3]
["№ пути","0 с повторами","1 с повторами","2 с повторами","3 с повторами","1+2+3","№ повтора","Смещение",null,"уровень 4","кол-во повторов",null,"Число путей","Завершено?"]
[1,{"$f":"OFFSET($B$67,H81,)","v":1},{"$f":"OFFSET($C$67,H81,)","v":2},{"$f":"OFFSET($D$67,H81,)","v":5},{"$f":"OFFSET($J$67,H81,)","v":9},{"$f":"SUMPRODUCT(C81:E81,$B$32^(C$79:E$79-1))","v":776},{"$f":"COUNTIF($F$81:F81,F81)","v":1},{"$f":"IF($A81=1,0,IF(G80=INDEX($K$67:$K$76,MATCH(E80,$J$67:$J$76,0)),H80+1,H80))","v":0},null,{"$f":"IF(E81=$B$32,E81,OFFSET($F$21,E81,G81-1))","v":9},{"$f":"IFERROR(INDEX($I$23:$I$29,MATCH(J81,$A$23:$A$29,0)),1)","v":1},null,{"$f":"COUNT(J81:J90)","v":3},{"$f":"IF(SUMPRODUCT(--(OFFSET(J81,,,M81)=$B$32))=M81,TRUE)","v":true}]
[2,1,3,6,8,705,{"$f":"COUNTIF($F$81:F82,F82)","v":1},{"$f":"IF($A82=1,0,IF(G81=INDEX($K$67:$K$76,MATCH(E81,$J$67:$J$76,0)),H81+1,H81))","v":1},null,9,{"$f":"IFERROR(INDEX($I$23:$I$29,MATCH(J82,$A$23:$A$29,0)),1)","v":1}]
[3,1,4,7,9,796,{"$f":"COUNTIF($F$81:F83,F83)","v":1},2,null,9,1]
[4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"COUNTIF($F$81:F84,F84)","v":1},3,null,{"$error":"#N/A"},1]
[5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"COUNTIF($F$81:F85,F85)","v":2},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[6,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"COUNTIF($F$81:F86,F86)","v":3},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[7,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"COUNTIF($F$81:F87,F87)","v":4},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[8,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"COUNTIF($F$81:F88,F88)","v":5},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[9,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"COUNTIF($F$81:F89,F89)","v":6},{"$error":"#N/A"},null,{"$error":"#N/A"},1]
[10,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"COUNTIF($F$81:F90,F90)","v":7},{"$error":"#N/A"},null,{"$error":"#N/A"},1]

{"sheet":"EXCEL2.RU","index":1,"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 в приятное времяпрепровождение и ускорить решение Ваших задач. Мы постоянно работаем над содержанием и оформлением нашего сайта и благодарим активных пользователей за поддержку и неоценимую помощь в нашей работе."]