{"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":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":"TSP Dynamic","index":0,"n_rows":57,"n_cols":30,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Исходные данные",null,"кол-во",{"$f":"COUNT(A3:A26)","v":18},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,0,0,0,0,0,0]
[1,"Склад",42.913035000000001,71.322474999999997,null,{"$f":"A3","v":1},{"$f":"IF(OR($F3=G$2,$F3=0,G$2=0),,6371*ACOS(SIN(RADIANS(INDEX($C$3:$C$22,$F3)))*SIN(RADIANS(INDEX($C$3:$C$22,G$2)))+COS(RADIANS(INDEX($C$3:$C$22,$F3)))*COS(RADIANS(INDEX($C$3:$C$22,G$2)))*COS((RADIANS(INDEX($D$3:$D$22,$F3)-INDEX($D$3:$D$22,G$2))))))","v":0},10.40510519992924,2.9041041148444204,1.8906687503304755,2.7700991914747295,5.7521176980739401,2.8403837883795902,4.2564700936101474,5.0256389994629656,4.8761968918890624,{"$f":"IF(OR($F3=Q$2,$F3=0,Q$2=0),,6371*ACOS(SIN(RADIANS(INDEX($C$3:$C$22,$F3)))*SIN(RADIANS(INDEX($C$3:$C$22,Q$2)))+COS(RADIANS(INDEX($C$3:$C$22,$F3)))*COS(RADIANS(INDEX($C$3:$C$22,Q$2)))*COS((RADIANS(INDEX($D$3:$D$22,$F3)-INDEX($D$3:$D$22,Q$2))))))","v":6.3302432732336573},4.5477164813687807,1.5031475832844114,2.5298676075961684,3.0840992689539872,1.587446431577517,3.4307910073560772,3.0248678774918698,0,0,0,0,0,0]
[2,"Казахстан, Тараз",42.891936000000001,71.446931000000006,null,2,0,0,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,0,0,0,0,0,0]
[3,"Казахстан, Тараз, микрорайон Акбулак, 25",42.893540999999999,71.346203000000003,null,3,2.9041041148444204,8.2077109289361676,0,1.3482600945776131,0.17256108931013592,2.8491945011161146,0.61244811433105362,1.9585093190281699,3.2245843780608086,2.3021250931410311,4.5351099763802205,1.737612857204025,1.8375909701953228,1.09336862040708,1.4462206512709579,1.689053604098681,1.2199097446934235,0.23283682618460921,0,0,0,0,0,0]
[4,"Казахстан, Тараз, микрорайон Жансая, 14",42.897041999999999,71.330357000000006,null,4,1.8906687503304755,9.5133466094002941,1.3482600945776131,0,1.1769577383417473,4.0396103791823981,1.0274052350719964,2.3667721934801182,3.2390858479372611,2.9920159530789161,5.7066029338839792,2.7384701686011992,0.50817753019846612,1.74972313510171,2.3517697721802202,0.36376515591869407,2.3868175707083141,1.3593743870679049,0,0,0,0,0,0]
[5,"Казахстан, Тараз, микрорайон Каратау, 29",42.893819000000001,71.344119000000006,null,5,2.7700991914747295,8.378140559258334,0.17256108931013592,1.1769577383417473,0,2.9829096165416575,0.49291794521928045,1.944941192386775,3.175783316964778,2.340378050926871,4.6892798233962214,1.8253872589493241,1.668822426563854,1.1286583576618019,1.5422936157610179,1.520213244567634,1.3618330036666586,0.2681010465877236,0,0,0,0,0,0]
[6,"Казахстан, Тараз, улица Акмолда батыр басы, 52",42.873736000000001,71.368391000000003,null,6,5.7521176980739401,6.7116381016207605,2.8491945011161146,4.0396103791823981,2.9829096165416575,0,3.0135088848544891,2.4151946012330496,3.3938135734096067,1.794752338748979,4.3338740635954833,1.3885761483994554,4.5462220003552183,3.5631599036786916,3.3962665854334246,4.4033750862098113,2.8400846576851277,2.7343186792787719,0,0,0,0,0,0]
[7,"Казахстан, Тараз, микрорайон Карасу, 17",42.890813000000001,71.339671999999993,null,7,2.8403837883795902,8.7389013609422133,0.61244811433105362,1.0274052350719964,0.49291794521928045,3.0135088848544891,0,1.5669291179159661,2.7251960292851081,2.0725635503115032,5.1340734640301964,1.7196608855998112,1.5328496815454011,1.5989291753363344,2.0352000848117173,1.3908967778707193,1.831762742442103,0.46381350796289067,0,0,0,0,0,0]
[8,"Казахстан, Тараз, микрорайон Алатау, 24",42.876728999999997,71.339034999999996,null,8,4.2564700936101474,8.952056927783369,1.9585093190281699,2.3667721934801182,1.944941192386775,2.4151946012330496,1.5669291179159661,0,1.3526586100550591,0.73992308784734329,5.8643450766625813,1.1368248848964235,2.7871733075803973,3.0518629498712264,3.3320005503511698,2.6797464395605317,2.939361223166217,1.7257804752817616,0,0,0,0,0,0]
[9,"Казахстан, Тараз, массив Арай",42.867987999999997,71.327490999999995,null,9,5.0256389994629656,10.089885724320013,3.2245843780608086,3.2390858479372611,3.175783316964778,3.3938135734096067,2.7251960292851081,1.3526586100550591,0,1.6326931574200914,7.1886274217088797,2.3750796637496627,3.5277004130105496,4.304263252974363,4.6446205341053846,3.4638054915524394,4.279734918264392,2.9949984292107796,0,0,0,0,0,0]
[10,"Казахстан, Тараз, Караванная улица, 30",42.872838000000002,71.346401,null,10,4.8761968918890624,8.4618202615019129,2.3021250931410311,2.9920159530789161,2.340378050926871,1.794752338748979,2.0725635503115032,0.73992308784734329,1.6326931574200914,0,5.6376011864307438,0.82833114866706614,3.4454113090392973,3.3584990504164711,3.515469372246161,3.3269474549746842,3.0441523612564829,2.0839303075329223,0,0,0,0,0,0]
[11,"Казахстан, Тараз, улица Кулжабаева, 51",42.905357000000002,71.399490999999998,null,11,{"$f":"IF(OR($F13=G$2,$F13=0,G$2=0),,6371*ACOS(SIN(RADIANS(INDEX($C$3:$C$22,$F13)))*SIN(RADIANS(INDEX($C$3:$C$22,G$2)))+COS(RADIANS(INDEX($C$3:$C$22,$F13)))*COS(RADIANS(INDEX($C$3:$C$22,G$2)))*COS((RADIANS(INDEX($D$3:$D$22,$F13)-INDEX($D$3:$D$22,G$2))))))","v":6.3302432732336573},4.142464363906738,4.5351099763802205,5.7066029338839792,4.6892798233962214,4.3338740635954833,5.1340734640301964,5.8643450766625813,7.1886274217088797,5.6376011864307438,{"$f":"IF(OR($F13=Q$2,$F13=0,Q$2=0),,6371*ACOS(SIN(RADIANS(INDEX($C$3:$C$22,$F13)))*SIN(RADIANS(INDEX($C$3:$C$22,Q$2)))+COS(RADIANS(INDEX($C$3:$C$22,$F13)))*COS(RADIANS(INDEX($C$3:$C$22,Q$2)))*COS((RADIANS(INDEX($D$3:$D$22,$F13)-INDEX($D$3:$D$22,Q$2))))))","v":0},4.8288982621732846,6.0796968900570212,4.0166507533403246,3.392405544113223,5.9509118658918565,3.3391296886564055,4.675279698308219,0,0,0,0,0,0]
[12,"Казахстан, Тараз, улица Лермонтова, 36",42.878664999999998,71.352733999999998,null,12,4.5477164813687807,7.815232048057478,1.737612857204025,2.7384701686011992,1.8253872589493241,1.3885761483994554,1.7196608855998112,1.1368248848964235,2.3750796637496627,0.82833114866706614,4.8288982621732846,0,3.2354141561252421,2.7029307528996327,2.7721924404068421,3.098743845793035,2.2699991862319164,1.5574950715042017,0,0,0,0,0,0]
[13,"Казахстан, Тараз, улица Тауке хана, 15Б",42.899670999999998,71.325254000000001,null,13,1.5031475832844114,9.9491270757453592,1.8375909701953228,0.50817753019846612,1.668822426563854,4.5462220003552183,1.5328496815454011,2.7871733075803973,3.5277004130105496,3.4454113090392973,6.0796968900570212,3.2354141561252421,0,2.070768330770389,2.6924298739588925,0.1486197459698233,2.8005780939809171,1.8634967375395493,0,0,0,0,0,0]
[14,"Казахстан, Тараз, улица Толе би, 98",42.902906999999999,71.350290000000001,null,14,2.5298676075961684,7.9661882360499785,1.09336862040708,1.74972313510171,1.1286583576618019,3.5631599036786916,1.5989291753363344,3.0518629498712264,4.304263252974363,3.3584990504164711,4.0166507533403246,2.7029307528996327,2.070768330770389,0,0.62424746891358862,1.9487318902347994,0.90551878102804939,1.3261587607554044,0,0,0,0,0,0]
[15,"Казахстан, Тараз, переулок Достоевского, 5",42.903303000000001,71.357934999999998,null,15,3.0840992689539872,7.3588145854971003,1.4462206512709579,2.3517697721802202,1.5422936157610179,3.3962665854334246,2.0352000848117173,3.3320005503511698,4.6446205341053846,3.515469372246161,3.392405544113223,2.7721924404068421,2.6924298739588925,0.62424746891358862,0,2.5679382029103239,0.55620330685744457,1.6639006637796272,0,0,0,0,0,0]
[16,"Казахстан, Тараз, улица Тауке хана, 15",42.899135999999999,71.326926,null,16,1.587446431577517,9.8084493473610337,1.689053604098681,0.36376515591869407,1.520213244567634,4.4033750862098113,1.3908967778707193,2.6797464395605317,3.4638054915524394,3.3269474549746842,5.9509118658918565,3.098743845793035,0.1486197459698233,1.9487318902347994,2.5679382029103239,0,2.6621970647009112,1.7155778183219508,0,0,0,0,0,0]
[17,"Казахстан, Тараз, проспект Жамбыла, 178",42.898451000000001,71.359594999999999,null,17,3.4307910073560772,7.1513004633775399,1.2199097446934235,2.3868175707083141,1.3618330036666586,2.8400846576851277,1.831762742442103,2.939361223166217,4.279734918264392,3.0441523612564829,3.3391296886564055,2.2699991862319164,2.8005780939809171,0.90551878102804939,0.55620330685744457,2.6621970647009112,0,1.3957557683818453,0,0,0,0,0,0]
[18,"Казахстан, Тараз, микрорайон Каратау, 45",42.891561000000003,71.345273000000006,null,18,3.0248678774918698,8.2817704218960237,0.23283682618460921,1.3593743870679049,0.2681010465877236,2.7343186792787719,0.46381350796289067,1.7257804752817616,2.9949984292107796,2.0839303075329223,4.675279698308219,1.5574950715042017,1.8634967375395493,1.3261587607554044,1.6639006637796272,1.7155778183219508,1.3957557683818453,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,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,"Откуда:"]
[1,null,null,null,null,null,null,null,null,null,null,null,"Время расчета:",0.203125,{"$f":"IF(N29,\"сек.\",\"\")","v":"сек."}]
[]
["Путь коммивояжера"]
["№","Наименование","X","Y","Путь"]
[1,{"$f":"IF($A33<>\"\",INDEX(B$3:B$26,$A33),\"\")","v":"Склад"},{"$f":"IF($A33<>\"\",INDEX(C$3:C$26,$A33),NA())","v":42.913035000000001},71.322474999999997,{"$f":"IF(AND(A33>0,A34>0),INDEX($G$3:$AD$26,A33,A34),)","v":1.5031475832844114}]
[13,"Казахстан, Тараз, улица Тауке хана, 15Б",42.899670999999998,71.325254000000001,0.1486197459698233]
[16,"Казахстан, Тараз, улица Тауке хана, 15",42.899135999999999,71.326926,0.36376515591869407]
[4,"Казахстан, Тараз, микрорайон Жансая, 14",42.897041999999999,71.330357000000006,1.74972313510171]
[14,"Казахстан, Тараз, улица Толе би, 98",42.902906999999999,71.350290000000001,0.62424746891358862]
[15,"Казахстан, Тараз, переулок Достоевского, 5",42.903303000000001,71.357934999999998,0.55620330685744457]
[17,"Казахстан, Тараз, проспект Жамбыла, 178",42.898451000000001,71.359594999999999,1.2199097446934235]
[3,"Казахстан, Тараз, микрорайон Акбулак, 25",42.893540999999999,71.346203000000003,0.17256108931013592]
[5,"Казахстан, Тараз, микрорайон Каратау, 29",42.893819000000001,71.344119000000006,0.2681010465877236]
[18,"Казахстан, Тараз, микрорайон Каратау, 45",42.891561000000003,71.345273000000006,0.46381350796289067]
[7,"Казахстан, Тараз, микрорайон Карасу, 17",42.890813000000001,71.339671999999993,1.5669291179159661]
[8,"Казахстан, Тараз, микрорайон Алатау, 24",42.876728999999997,71.339034999999996,1.3526586100550591]
[9,"Казахстан, Тараз, массив Арай",42.867987999999997,71.327490999999995,1.6326931574200914]
[10,"Казахстан, Тараз, Караванная улица, 30",42.872838000000002,71.346401,0.82833114866706614]
[12,"Казахстан, Тараз, улица Лермонтова, 36",42.878664999999998,71.352733999999998,1.3885761483994554]
[6,"Казахстан, Тараз, улица Акмолда батыр басы, 52",42.873736000000001,71.368391000000003,4.3338740635954833]
[11,"Казахстан, Тараз, улица Кулжабаева, 51",42.905357000000002,71.399490999999998,4.142464363906738]
[2,"Казахстан, Тараз",42.891936000000001,71.446931000000006,0]
[1]
[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"},0]
[null,"",{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(E33:E56)","v":22.315618394559706}]