{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TSP Dynamic"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"TSP Dynamic","index":0,"n_rows":57,"n_cols":30,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Исходные данные",null,"кол-во",{"$f":"COUNT(A3:A26)","v":19},null,"Матрица смежности"]
["№","Наименование","X","Y",null,null,{"$f":"TRANSPOSE(F3:F26)","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,0,0,0,0,0]
[1,"Точка 1",40,47,null,{"$f":"A3","v":1},{"$f":"IF(OR($F3=G$2,$F3=0,G$2=0),,SQRT((INDEX($C$3:$C$26,$F3)-INDEX($C$3:$C$26,G$2))^2+(INDEX($D$3:$D$26,$F3)-INDEX($D$3:$D$26,G$2))^2))","v":0},51.894122981316485,59.464274989274024,47.095647357266465,29.832867780352597,29.546573405388315,35.383612025908263,21.931712199461309,32.449961479175904,47.853944456021594,{"$f":"IF(OR($F3=Q$2,$F3=0,Q$2=0),,SQRT((INDEX($C$3:$C$26,$F3)-INDEX($C$3:$C$26,Q$2))^2+(INDEX($D$3:$D$26,$F3)-INDEX($D$3:$D$26,Q$2))^2))","v":49.203658400570177},14.212670403551895,9.4339811320566032,42.579337712087536,44.045431091090478,48.795491595023407,48.104053883222775,5.0990195135927845,14.035668847618199,0,0,0,0,0]
[2,"Точка 2",18,0,null,2,51.894122981316485,0,18.248287590894659,25,23.430749027719962,22.360679774997898,23.345235059857504,29.966648127543394,29.427877939124322,4.1231056256176606,11.313708498984761,38.275318418009277,42.544094772365298,15.811388300841896,14.317821063276353,16.970562748477139,5.3851648071345037,49.040799340956916,46.690470119715009,0,0,0,0,0]
[3,"Точка 3",0,3,null,3,59.464274989274024,18.248287590894659,0,43.104524124504614,36.249137920783717,32.756678708318397,24.413111231467404,39.204591567825318,29.068883707497267,19.026297590440446,11.180339887498949,45.276925690687087,50.209560842532767,33.060550509633082,15.620499351813308,10.816653826391969,23.021728866442675,55.443665102516448,50.24937810560445,0,0,0,0,0]
[4,"Точка 4",43,0,null,4,47.095647357266465,25,43.104524124504614,0,20.591260281974002,25,37.013511046643494,29.546573405388315,41.725292090050132,24.331050121192877,33.955853692699293,37.947331922020552,39.812058474788763,11.180339887498949,33.61547262794322,38.897300677553446,20.09975124224178,46.690470119715009,49.040799340956916,0,0,0,0,0]
[5,"Точка 5",33,18,null,5,29.832867780352597,23.430749027719962,36.249137920783717,20.591260281974002,0,5.3851648071345037,19.646882704388499,9.2195444572928871,22.825424421026653,19.798989873223331,25.079872407968907,18.110770276274835,21.095023109728988,13,21.587033144922902,27.658633371878661,18.867962264113206,28.071337695236398,28.861739379323623,0,0,0,0,0]
[6,"Точка 6",28,20,null,6,29.546573405388315,22.360679774997898,32.756678708318397,25,5.3851648071345037,0,14.317821063276353,7.6157731058639087,17.4928556845359,18.357559750685819,21.633307652783937,16.278820596099706,20.248456731316587,15.811388300841896,17.464249196572979,23.409399821439251,18.681541692269406,26.92582403567252,26.076809620810597,0,0,0,0,0]
[7,"Точка 7",14,23,null,7,35.383612025908263,23.345235059857504,24.413111231467404,37.013511046643494,19.646882704388499,14.317821063276353,0,17.464249196572979,6.0827625302982193,19.646882704388499,15.524174696260024,21.400934559032695,26.40075756488817,26.172504656604801,10.198039027185569,13.601470508735444,22.847319317591726,31.144823004794873,25.942243542145693,0,0,0,0,0]
[8,"Точка 8",31,27,null,8,21.931712199461309,29.966648127543394,39.204591567825318,29.546573405388315,9.2195444572928871,7.6157731058639087,17.464249196572979,0,18.110770276274835,25.942243542145693,28.319604517012593,9,12.649110640673518,22.090722034374522,23.600847442411894,29.154759474226502,26.248809496813376,19.416487838947599,19.646882704388499,0,0,0,0,0]
[9,"Точка 9",13,29,null,9,32.449961479175904,29.427877939124322,29.068883707497267,41.725292090050132,22.825424421026653,17.4928556845359,6.0827625302982193,18.110770276274835,0,25.709920264364882,21.213203435596427,19.313207915827967,24.166091947189145,31.240998703626616,16.031219541881399,18.384776310850235,28.792360097775937,27.802877548915689,21.400934559032695,0,0,0,0,0]
[10,"Точка 10",19,4,null,10,47.853944456021594,4.1231056256176606,19.026297590440446,24.331050121192877,19.798989873223331,18.357559750685819,19.646882704388499,25.942243542145693,25.709920264364882,0,9.8488578017961039,34.176014981270121,38.483762809787713,14.035668847618199,11.401754250991379,15.264337522473747,4.4721359549995796,44.944410108488462,42.579337712087536,0,0,0,0,0]
[11,"Точка 11",10,8,null,11,{"$f":"IF(OR($F13=G$2,$F13=0,G$2=0),,SQRT((INDEX($C$3:$C$26,$F13)-INDEX($C$3:$C$26,G$2))^2+(INDEX($D$3:$D$26,$F13)-INDEX($D$3:$D$26,G$2))^2))","v":49.203658400570177},11.313708498984761,11.180339887498949,33.955853692699293,25.079872407968907,21.633307652783937,15.524174696260024,28.319604517012593,21.213203435596427,9.8488578017961039,{"$f":"IF(OR($F13=Q$2,$F13=0,Q$2=0),,SQRT((INDEX($C$3:$C$26,$F13)-INDEX($C$3:$C$26,Q$2))^2+(INDEX($D$3:$D$26,$F13)-INDEX($D$3:$D$26,Q$2))^2))","v":0},35,39.824615503479755,23.194827009486403,5.3851648071345037,5.6568542494923806,14.317821063276353,45.486261662176638,41.231056256176608,0,0,0,0,0]
[12,"Точка 12",31,36,null,12,14.212670403551895,38.275318418009277,45.276925690687087,37.947331922020552,18.110770276274835,16.278820596099706,21.400934559032695,9,19.313207915827967,34.176014981270121,35,0,5,31.064449134018133,29.832867780352597,34.655446902326915,34.928498393145958,10.770329614269007,11.180339887498949,0,0,0,0,0]
[13,"Точка 13",35,39,null,13,9.4339811320566032,42.544094772365298,50.209560842532767,39.812058474788763,21.095023109728988,20.248456731316587,26.40075756488817,12.649110640673518,24.166091947189145,38.483762809787713,39.824615503479755,5,0,34.058772731852805,34.713109915419565,39.623225512317902,38.897300677553446,7,11.401754250991379,0,0,0,0,0]
[14,"Точка 14",33,5,null,14,42.579337712087536,15.811388300841896,33.060550509633082,11.180339887498949,13,15.811388300841896,26.172504656604801,22.090722034374522,31.240998703626616,14.035668847618199,23.194827009486403,31.064449134018133,34.058772731852805,0,22.472205054244231,27.892651361962706,10.440306508910551,41.048751503547585,41.593268686170845,0,0,0,0,0]
[15,"Точка 15",12,13,null,15,44.045431091090478,14.317821063276353,15.620499351813308,33.61547262794322,21.587033144922902,17.464249196572979,10.198039027185569,23.600847442411894,16.031219541881399,11.401754250991379,5.3851648071345037,29.832867780352597,34.713109915419565,22.472205054244231,0,6.0827625302982193,15.556349186104045,40.224370722237531,35.846896657869841,0,0,0,0,0]
[16,"Точка 16",6,12,null,16,48.795491595023407,16.970562748477139,10.816653826391969,38.897300677553446,27.658633371878661,23.409399821439251,13.601470508735444,29.154759474226502,18.384776310850235,15.264337522473747,5.6568542494923806,34.655446902326915,39.623225512317902,27.892651361962706,6.0827625302982193,0,19.723082923316021,44.687805943008662,39.446165846632042,0,0,0,0,0]
[17,"Точка 17",23,2,null,17,48.104053883222775,5.3851648071345037,23.021728866442675,20.09975124224178,18.867962264113206,18.681541692269406,22.847319317591726,26.248809496813376,28.792360097775937,4.4721359549995796,14.317821063276353,34.928498393145958,38.897300677553446,10.440306508910551,15.556349186104045,19.723082923316021,0,45.607017003965517,44.10215414239989,0,0,0,0,0]
[18,"Точка 18",35,46,null,18,5.0990195135927845,49.040799340956916,55.443665102516448,46.690470119715009,28.071337695236398,26.92582403567252,31.144823004794873,19.416487838947599,27.802877548915689,44.944410108488462,45.486261662176638,10.770329614269007,7,41.048751503547585,40.224370722237531,44.687805943008662,45.607017003965517,0,9,0,0,0,0,0]
[19,"Точка 19",26,46,null,19,14.035668847618199,46.690470119715009,50.24937810560445,49.040799340956916,28.861739379323623,26.076809620810597,25.942243542145693,19.646882704388499,21.400934559032695,42.579337712087536,41.231056256176608,11.180339887498949,11.401754250991379,41.593268686170845,35.846896657869841,39.446165846632042,44.10215414239989,9,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Откуда:",null,null,null,null,null,null,null,null,null,null,1.40625]
[1,null,null,"Точек",19]
[]
["Путь коммивояжера"]
["№","Наименование","X","Y","Путь"]
[1,{"$f":"IF($A33<>\"\",INDEX(B$3:B$26,$A33),\"\")","v":"Точка 1"},{"$f":"IF($A33<>\"\",INDEX(C$3:C$26,$A33),NA())","v":40},47,{"$f":"IF(AND(A33>0,A34>0),INDEX($G$3:$AD$26,A33,A34),)","v":9.4339811320566032}]
[13,"Точка 13",35,39,5]
[12,"Точка 12",31,36,9]
[8,"Точка 8",31,27,7.6157731058639087]
[6,"Точка 6",28,20,5.3851648071345037]
[5,"Точка 5",33,18,20.591260281974002]
[4,"Точка 4",43,0,11.180339887498949]
[14,"Точка 14",33,5,10.440306508910551]
[17,"Точка 17",23,2,5.3851648071345037]
[2,"Точка 2",18,0,4.1231056256176606]
[10,"Точка 10",19,4,9.8488578017961039]
[11,"Точка 11",10,8,11.180339887498949]
[3,"Точка 3",0,3,10.816653826391969]
[16,"Точка 16",6,12,6.0827625302982193]
[15,"Точка 15",12,13,10.198039027185569]
[7,"Точка 7",14,23,6.0827625302982193]
[9,"Точка 9",13,29,21.400934559032695]
[19,"Точка 19",26,46,9]
[18,"Точка 18",35,46,5.0990195135927845]
[1,"Точка 1",40,47,0]
[null,"",{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,"",{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,"",{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,"",{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,"",{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(E33:E56)","v":177.86446583228519}]