{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Граф1","Граф2","EXCEL2.RU","EXCEL2.RU (2)"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":90,"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":"Граф1","index":0,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Файл скачан с сайта 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,null,null,"Подписи для ребер"]
["Вершины","X","У",null,"№","Ребра","Начало","Конец","Xнач","Xкон","Унач","Укон","X","Y"]
[1,10,90,null,1,{"$f":"CHAR(65+ROW()-ROW($F$8))","v":"A"},1,3,{"$f":"VLOOKUP(G8,$A$8:$C$23,2,0)","v":10},{"$f":"VLOOKUP(H8,$A$8:$C$23,2,0)","v":20},{"$f":"VLOOKUP(G8,$A$8:$C$23,3,0)","v":90},{"$f":"VLOOKUP(H8,$A$8:$C$23,3,0)","v":90},{"$f":"(I8+J8)/2","v":15},{"$f":"(K8+L8)/2","v":90}]
[2,20,150,null,2,"B",2,6,{"$f":"VLOOKUP(G9,$A$8:$C$23,2,0)","v":20},30,{"$f":"VLOOKUP(G9,$A$8:$C$23,3,0)","v":150},120,{"$f":"(I9+J9)/2","v":25},{"$f":"(K9+L9)/2","v":135}]
[3,20,90,null,3,"C",1,2,10,20,90,150,15,120]
[4,20,30,null,4,"D",2,5,20,30,150,150,25,150]
[5,30,150,null,5,"E",1,4,10,20,90,30,15,60]
[6,30,120,null,6,"F",3,7,20,40,90,80,30,85]
[7,40,80,null,7,"G",5,9,30,40,150,120,35,135]
[8,40,30,null,8,"H",6,9,30,40,120,120,35,120]
[9,40,120,null,9,"I",7,14,40,70,80,60,55,70]
[10,50,150,null,10,"J",9,10,40,50,120,150,45,135]
[11,55,120,null,11,"K",9,11,40,55,120,120,47.5,120]
[12,50,90,null,12,"L",9,12,40,50,120,90,45,105]
[13,60,150,null,13,"M",4,8,20,40,30,30,30,30]
[14,70,60,null,14,"N",10,13,50,60,150,150,55,150]
[15,80,30,null,15,"O",11,13,55,60,120,150,57.5,135]
[16,90,60,null,16,"P",12,14,50,70,90,60,60,75]
[null,null,null,null,17,"Q",8,14,40,70,30,60,55,45]
[null,null,null,null,18,"R",13,14,60,70,150,60,65,105]
[null,null,null,null,19,"S",14,15,70,80,60,30,75,45]
[null,null,null,null,20,"T",15,16,80,90,30,60,85,45]
[null,null,null,null,21,"U",14,16,70,90,60,60,80,60]

{"sheet":"Граф2","index":1,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Файл скачан с сайта excel2.ru >>>"]
["Перейти к статье >>>"]
[{"$f":"Граф1!A3","v":"Ориентированный граф в MS EXCEL"}]
["Ребра построены через пути"]
["Координаты вершин (задаются произвольно, из соображений наглядности построения графа)",null,null,null,null,null,null,"Координаты ребер",null,null,"Для вычисления координат для подписей ребер",null,null,null,null,null,null,"Ориентированный граф"]
[null,null,null,null,null,null,null,2,3,null,null,null,"Вершины",null,"Подписи для ребер"]
["Вершины","X","У",null,"№ Пути","Последовательность вершин","Последовательность ребер","X","Y",null,"№","Ребра","Начало","Конец","X","Y"]
[1,10,90,null,1,1,null,{"$f":"VLOOKUP($F8,$A$8:$C$23,H$6,0)","v":10},{"$f":"VLOOKUP($F8,$A$8:$C$23,I$6,0)","v":90},null,1,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G8)))","v":"C"},{"$f":"INDEX($F$8:$F$33,MATCH(L8,$G$8:$G$33,0)-1)","v":1},{"$f":"INDEX($F$8:$F$33,MATCH(L8,$G$8:$G$33,0))","v":2},{"$f":"(VLOOKUP($M8,$A$8:$C$23,H$6,0)+VLOOKUP($N8,$A$8:$C$23,H$6,0))/2","v":15},{"$f":"(VLOOKUP($M8,$A$8:$C$23,I$6,0)+VLOOKUP($N8,$A$8:$C$23,I$6,0))/2","v":120}]
[2,20,150,null,1,2,"C",{"$f":"VLOOKUP($F9,$A$8:$C$23,H$6,0)","v":20},150,null,2,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G9)))","v":"D"},{"$f":"INDEX($F$8:$F$33,MATCH(L9,$G$8:$G$33,0)-1)","v":2},{"$f":"INDEX($F$8:$F$33,MATCH(L9,$G$8:$G$33,0))","v":5},{"$f":"(VLOOKUP($M9,$A$8:$C$23,H$6,0)+VLOOKUP($N9,$A$8:$C$23,H$6,0))/2","v":25},{"$f":"(VLOOKUP($M9,$A$8:$C$23,I$6,0)+VLOOKUP($N9,$A$8:$C$23,I$6,0))/2","v":150}]
[3,20,90,null,1,5,"D",30,150,null,3,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G10)))","v":"G"},{"$f":"INDEX($F$8:$F$33,MATCH(L10,$G$8:$G$33,0)-1)","v":5},9,{"$f":"(VLOOKUP($M10,$A$8:$C$23,H$6,0)+VLOOKUP($N10,$A$8:$C$23,H$6,0))/2","v":35},{"$f":"(VLOOKUP($M10,$A$8:$C$23,I$6,0)+VLOOKUP($N10,$A$8:$C$23,I$6,0))/2","v":135}]
[4,20,30,null,1,9,"G",40,120,null,4,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G11)))","v":"J"},{"$f":"INDEX($F$8:$F$33,MATCH(L11,$G$8:$G$33,0)-1)","v":9},10,45,135]
[5,30,150,null,1,10,"J",50,150,null,5,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G12)))","v":"N"},10,13,55,150]
[6,30,120,null,1,13,"N",60,150,null,6,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G13)))","v":"R"},13,14,65,105]
[7,40,80,null,1,14,"R",70,60,null,7,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G14)))","v":"S"},14,15,75,45]
[8,40,30,null,1,15,"S",80,30,null,8,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G15)))","v":"T"},15,16,85,45]
[9,40,120,null,1,16,"T",{"$f":"VLOOKUP($F16,$A$8:$C$23,H$6,0)","v":90},60,null,9,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G16)))","v":"B"},2,6,25,135]
[10,50,150,null,2,2,null,{"$f":"VLOOKUP($F17,$A$8:$C$23,H$6,0)","v":20},150,null,10,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G17)))","v":"H"},6,9,35,120]
[11,55,120,null,2,6,"B",30,120,null,11,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G18)))","v":"K"},9,11,47.5,120]
[12,50,90,null,2,9,"H",40,120,null,12,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G19)))","v":"O"},11,13,57.5,135]
[13,60,150,null,2,11,"K",55,120,null,13,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G20)))","v":"A"},1,3,15,90]
[14,70,60,null,2,13,"O",60,150,null,14,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G21)))","v":"F"},3,7,30,85]
[15,80,30,null,3,1,null,10,90,null,15,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G22)))","v":"I"},7,14,55,70]
[16,90,60,null,3,3,"A",20,90,null,16,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G23)))","v":"U"},14,16,80,60]
[null,null,null,null,3,7,"F",40,80,null,17,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G24)))","v":"E"},1,4,15,60]
[null,null,null,null,3,14,"I",70,60,null,18,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G25)))","v":"M"},4,8,30,30]
[null,null,null,null,3,16,"U",90,60,null,19,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G26)))","v":"Q"},8,14,55,45]
[null,null,null,null,4,1,null,10,90,null,20,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G27)))","v":"L"},9,12,45,105]
[null,null,null,null,4,4,"E",20,30,null,21,{"$f":"INDEX($G$9:$G$33,SMALL(IF(ISBLANK($G$9:$G$33),999999,ROW($G$9:$G$33)-ROW($G$8)),ROWS($G$8:G28)))","v":"P"},12,14,{"$f":"(VLOOKUP($M28,$A$8:$C$23,H$6,0)+VLOOKUP($N28,$A$8:$C$23,H$6,0))/2","v":60},{"$f":"(VLOOKUP($M28,$A$8:$C$23,I$6,0)+VLOOKUP($N28,$A$8:$C$23,I$6,0))/2","v":75}]
[null,null,null,null,4,8,"M",40,30]
[null,null,null,null,4,14,"Q",70,60]
[null,null,null,null,5,9,null,40,120]
[null,null,null,null,5,12,"L",50,90]
[null,null,null,null,5,14,"P",70,60]

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

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