{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["BruteForce12 (2)"],"not_rendered":{"charts":0,"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":"BruteForce12 (2)","index":0,"n_rows":65,"n_cols":26,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Исходные данные",null,"кол-во",{"$f":"COUNT(A3:A14)","v":10},"0,61 сек",null,"Откуда:",{"$f":"SUM(H6:H100)","v":8041.6468256466032},10000,null,null,null,null,"Матрица смежности"]
["№","Наименование","Широта","Долгота",null,1,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[1,"Москва",55.75,37.616666666666667,null,null,null,null,null,null,null,null,null,1,{"$f":"IF($N3=O$2,,6371*ACOS(SIN(RADIANS(INDEX($C$3:$C$14,$N3)))*SIN(RADIANS(INDEX($C$3:$C$14,O$2)))+COS(RADIANS(INDEX($C$3:$C$14,$N3)))*COS(RADIANS(INDEX($C$3:$C$14,O$2)))*COS((RADIANS(INDEX($D$3:$D$14,$N3)-INDEX($D$3:$D$14,O$2))))))","v":0},634.15416620975066,2812.3228332805106,1416.4958552212122,856.04183644980242,2235.6696387509896,721.67480299425063,1169.4950788804872,1495.9864125077538,957.81550586502954,1154.5809784625576,401.39262870595621]
[2,"Санкт-Петербург",59.93333333333333,30.316666666666666,null,"Путь коммивояжера",null,null,null,null,null,null,null,2,634.15416620975066,0,3106.305872464673,1781.2967622051133,1417.4236384706562,2584.0534139550623,1201.5507772841722,1632.525345896604,1911.5530443389794,1538.5343763276026,1491.2654875190285,896.21244561511173]
[3,"Новосибирск",55.016666666666666,82.933333333333337,null,"№","Наименование","Путь",null,null,null,null,null,3,2812.3228332805106,3106.305872464673,0,1399.4828468414653,2124.5795065016332,609.68571479793559,2112.5999955937273,1706.6284161239128,1363.0560503819211,3083.8699005091376,1659.9625026484489,2413.2614035085503]
[4,"Екатеринбург",56.85,60.6,null,1,{"$f":"IF($F6<>\"\",INDEX(B$3:B$1400,$F6),\"\")","v":"Москва"},{"$f":"IF(AND(F6>0,F7>0),INDEX($O$3:$CZ$1400,F6,F7),)","v":634.15416620975066},null,null,null,null,null,4,1416.4958552212122,1781.2967622051133,1399.4828468414653,0,775.71462675890564,820.81620637892536,714.111037588101,362.17430557332449,196.00063460531712,1773.2053415288096,290.94805105057992,1015.7674400471722]
[5,"Самара",53.233333333333334,50.166666666666664,null,2,{"$f":"IF($F7<>\"\",INDEX(B$3:B$1400,$F7),\"\")","v":"Санкт-Петербург"},{"$f":"IF(AND(F7>0,F8>0),INDEX($O$3:$CZ$1400,F7,F8),)","v":1201.5507772841722},null,null,null,null,null,5,856.04183644980242,1417.4236384706562,2124.5795065016332,775.71462675890564,0,1517.6949509249791,290.79522315650001,423.51974416408837,762.36766427467865,997.86343216048999,652.18490228116855,523.07321525721341]
[6,"Омск",54.983333333333334,73.36666666666666,null,7,"Казань",714.111037588101,null,null,null,null,null,6,2235.6696387509896,2584.0534139550623,609.68571479793559,820.81620637892536,1517.6949509249791,0,1523.4451496240836,1103.4556150081119,759.12863711176635,2474.4965711804653,1100.4362811995518,1834.3672487685506]
[7,"Казань",55.783333333333331,49.166666666666664,null,4,"Екатеринбург",1399.4828468414653,null,null,null,null,null,7,721.67480299425063,1201.5507772841722,2112.5999955937273,714.111037588101,290.79522315650001,1523.4451496240836,0,449.59882264252917,775.39940687802152,1152.3574973748007,494.59688129772132,326.19705043256124]
[8,"Уфа",54.81666666666667,56.06666666666667,null,3,"Новосибирск",609.68571479793559,null,null,null,null,null,8,1169.4950788804872,1632.525345896604,1706.6284161239128,362.17430557332449,423.51974416408837,1103.4556150081119,449.59882264252917,0,344.33496362380305,1416.0694761713542,354.11869375910686,775.71862190082095]
[9,"Челябинск",55.15,61.43333333333333,null,6,"Омск",759.12863711176635,null,null,null,null,null,9,1495.9864125077538,1911.5530443389794,1363.0560503819211,196.00063460531712,762.36766427467865,759.12863711176635,775.39940687802152,344.33496362380305,0,1741.1171080499528,449.06766684349333,1096.1436476182951]
[10,"Ростов-на-Дону",47.233333333333334,39.700000000000003,null,9,"Челябинск",344.33496362380305,null,null,null,null,null,10,957.81550586502954,1538.5343763276026,3083.8699005091376,1773.2053415288096,997.86343216048999,2474.4965711804653,1152.3574973748007,1416.0694761713542,1741.1171080499528,0,1628.2458025317817,1051.9367845570625]
[null,"Пермь",58,56.233333333333334,null,8,"Уфа",423.51974416408837,null,null,null,null,null,11,1154.5809784625576,1491.2654875190285,1659.9625026484489,290.94805105057992,652.18490228116855,1100.4362811995518,494.59688129772132,354.11869375910686,449.06766684349333,1628.2458025317817,0,759.91410695931461]
[null,"Нижний Новгород",56.31666666666667,44,null,5,"Самара",997.86343216048999,null,null,null,null,null,12,401.39262870595621,896.21244561511173,2413.2614035085503,1015.7674400471722,523.07321525721341,1834.3672487685506,326.19705043256124,775.71862190082095,1096.1436476182951,1051.9367845570625,759.91410695931461,0]
[null,null,null,null,null,10,"Ростов-на-Дону",957.81550586502954]
[null,null,null,null,null,1,"Москва",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]
[null,null,null,null,null,null,"",0]