{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["tsp225","Лист1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"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":"tsp225","index":0,"n_rows":228,"n_cols":17,"rows_kept":228,"cut":false,"hidden":false,"merged":[]}
["Исходные данные",null,"кол-во",{"$f":"COUNT(D3:D286)","v":82},null,null,"Путь коммивояжера"]
["№","Наименование","X","Y",null,null,"№","Наименование","X","Y",null,"Длина"]
[1,"Точка 1",427,3835,null,null,1,{"$f":"IF($G3<>\"\",INDEX(B$3:B$227,$G3),NA())","v":"Точка 1"},{"$f":"IF($G3<>\"\",INDEX(C$3:C$227,$G3),NA())","v":427},{"$f":"IF($G3<>\"\",INDEX(D$3:D$227,$G3),NA())","v":3835},null,{"$f":"IF(AND(ISNUMBER(I3:J4)),ROUND(SQRT((I3-I4)^2+(J3-J4)^2),),\"\")","v":61}]
[2,"Точка 2",550,5025,null,null,24,"Точка 24",366,3833,null,{"$f":"IF(AND(ISNUMBER(I4:J5)),ROUND(SQRT((I4-I5)^2+(J4-J5)^2),),\"\")","v":72}]
[3,"Точка 3",297,3624,null,null,28,"Точка 28",352,3762,null,{"$f":"IF(AND(ISNUMBER(I5:J6)),ROUND(SQRT((I5-I6)^2+(J5-J6)^2),),\"\")","v":92}]
[4,"Точка 4",540,4199,null,null,38,"Точка 38",439,3733,null,{"$f":"IF(AND(ISNUMBER(I6:J7)),ROUND(SQRT((I6-I7)^2+(J6-J7)^2),),\"\")","v":83}]
[5,"Точка 5",802,10148,null,null,67,"Точка 67",408,3656,null,{"$f":"IF(AND(ISNUMBER(I7:J8)),ROUND(SQRT((I7-I8)^2+(J7-J8)^2),),\"\")","v":116}]
[6,"Точка 6",825,10271,null,null,3,"Точка 3",297,3624,null,{"$f":"IF(AND(ISNUMBER(I8:J9)),ROUND(SQRT((I8-I9)^2+(J8-J9)^2),),\"\")","v":335},null,4,"m"]
[7,"Точка 7",107,8191,null,null,21,"Точка 21",166,3316,null,{"$f":"IF(AND(ISNUMBER(I9:J10)),ROUND(SQRT((I9-I10)^2+(J9-J10)^2),),\"\")","v":3317},null,20,"q"]
[8,"Точка 8",752,8645,null,null,68,"Точка 68",72,0,null,{"$f":"IF(AND(ISNUMBER(I10:J11)),ROUND(SQRT((I10-I11)^2+(J10-J11)^2),),\"\")","v":3110},null,true]
[9,"Точка 9",852,7917,null,null,33,"Точка 33",64,3110,null,{"$f":"IF(AND(ISNUMBER(I11:J12)),ROUND(SQRT((I11-I12)^2+(J11-J12)^2),),\"\")","v":110},null,"Длина:",{"$f":"L228","v":22777}]
[10,"Точка 10",852,8034,null,null,32,"Точка 32",80,3219,null,{"$f":"IF(AND(ISNUMBER(I12:J13)),ROUND(SQRT((I12-I13)^2+(J12-J13)^2),),\"\")","v":0},null,"Время:",3.5859375]
[11,"Точка 11",26,3327,null,null,55,"Точка 55",80,3219,null,{"$f":"IF(AND(ISNUMBER(I13:J14)),ROUND(SQRT((I13-I14)^2+(J13-J14)^2),),\"\")","v":121}]
[12,"Точка 12",598,3954,null,null,11,"Точка 11",26,3327,null,{"$f":"IF(AND(ISNUMBER(I14:J15)),ROUND(SQRT((I14-I15)^2+(J14-J15)^2),),\"\")","v":0},null,"Оптим.",3916]
[13,"Точка 13",560,7030,null,null,40,"Точка 40",26,3327,null,{"$f":"IF(AND(ISNUMBER(I15:J16)),ROUND(SQRT((I15-I16)^2+(J15-J16)^2),),\"\")","v":162},null,"Превыш.",{"$f":"O11/O14-1","v":4.816394279877426}]
[14,"Точка 14",562,7085,null,null,77,"Точка 77",3,3487,null,{"$f":"IF(AND(ISNUMBER(I16:J17)),ROUND(SQRT((I16-I17)^2+(J16-J17)^2),),\"\")","v":168}]
[15,"Точка 15",583,4881,null,null,69,"Точка 69",31,3653,null,{"$f":"IF(AND(ISNUMBER(I17:J18)),ROUND(SQRT((I17-I18)^2+(J17-J18)^2),),\"\")","v":177}]
[16,"Точка 16",417,4323,null,null,48,"Точка 48",166,3768,null,{"$f":"IF(AND(ISNUMBER(I18:J19)),ROUND(SQRT((I18-I19)^2+(J18-J19)^2),),\"\")","v":437}]
[17,"Точка 17",311,3951,null,null,78,"Точка 78",11,4177,null,{"$f":"IF(AND(ISNUMBER(I19:J20)),ROUND(SQRT((I19-I20)^2+(J19-J20)^2),),\"\")","v":149}]
[18,"Точка 18",358,3905,null,null,54,"Точка 54",150,4230,null,{"$f":"IF(AND(ISNUMBER(I20:J21)),ROUND(SQRT((I20-I21)^2+(J20-J21)^2),),\"\")","v":63}]
[19,"Точка 19",865,10532,null,null,20,"Точка 20",200,4191,null,{"$f":"IF(AND(ISNUMBER(I21:J22)),ROUND(SQRT((I21-I22)^2+(J21-J22)^2),),\"\")","v":175}]
[20,"Точка 20",200,4191,null,null,22,"Точка 22",374,4173,null,{"$f":"IF(AND(ISNUMBER(I22:J23)),ROUND(SQRT((I22-I23)^2+(J22-J23)^2),),\"\")","v":156}]
[21,"Точка 21",166,3316,null,null,16,"Точка 16",417,4323,null,{"$f":"IF(AND(ISNUMBER(I23:J24)),ROUND(SQRT((I23-I24)^2+(J23-J24)^2),),\"\")","v":140}]
[22,"Точка 22",374,4173,null,null,65,"Точка 65",332,4434,null,{"$f":"IF(AND(ISNUMBER(I24:J25)),ROUND(SQRT((I24-I25)^2+(J24-J25)^2),),\"\")","v":64}]
[23,"Точка 23",416,3983,null,null,45,"Точка 45",300,4490,null,{"$f":"IF(AND(ISNUMBER(I25:J26)),ROUND(SQRT((I25-I26)^2+(J25-J26)^2),),\"\")","v":202},null,null,null,null,"m - метод оптимизации"]
[24,"Точка 24",366,3833,null,null,51,"Точка 51",271,4690,null,{"$f":"IF(AND(ISNUMBER(I26:J27)),ROUND(SQRT((I26-I27)^2+(J26-J27)^2),),\"\")","v":117},null,null,null,null,"m = 0, построение маршрута \"жадным\" алгоритмом и использование 2-opt оптимизации"]
[25,"Точка 25",771,9179,null,null,71,"Точка 71",225,4798,null,{"$f":"IF(AND(ISNUMBER(I27:J28)),ROUND(SQRT((I27-I28)^2+(J27-J28)^2),),\"\")","v":1016},null,null,null,null,"m = 1, дополнительно \"выпрямление\" маршрута близко лежащих точек на коротких участках"]
[26,"Точка 26",29,8084,null,null,50,"Точка 50",297,5811,null,{"$f":"IF(AND(ISNUMBER(I28:J29)),ROUND(SQRT((I28-I29)^2+(J28-J29)^2),),\"\")","v":188},null,null,null,null,"m = 2, дополнительно производится \"выпрямление\" близко лежащих точек на длинных участках"]
[27,"Точка 27",45,8202,null,null,35,"Точка 35",307,5999,null,{"$f":"IF(AND(ISNUMBER(I29:J30)),ROUND(SQRT((I29-I30)^2+(J29-J30)^2),),\"\")","v":575},null,null,null,null,"m = 3, 2-opt и 3-opt оптимизация"]
[28,"Точка 28",352,3762,null,null,74,"Точка 74",363,6571,null,{"$f":"IF(AND(ISNUMBER(I30:J31)),ROUND(SQRT((I30-I31)^2+(J30-J31)^2),),\"\")","v":334},null,null,null,null,"m = 4, совокупность всех методов оптимизации"]
[29,"Точка 29",430,6341,null,null,56,"Точка 56",336,6904,null,{"$f":"IF(AND(ISNUMBER(I31:J32)),ROUND(SQRT((I31-I32)^2+(J31-J32)^2),),\"\")","v":609}]
[30,"Точка 30",549,4308,null,null,81,"Точка 81",71,7452,null,{"$f":"IF(AND(ISNUMBER(I32:J33)),ROUND(SQRT((I32-I33)^2+(J32-J33)^2),),\"\")","v":204},null,null,null,null,"q - изменение количества разных маршрутов, с выбором наилучшего решения"]
[31,"Точка 31",539,4310,null,null,70,"Точка 70",54,7655,null,{"$f":"IF(AND(ISNUMBER(I33:J34)),ROUND(SQRT((I33-I34)^2+(J33-J34)^2),),\"\")","v":178},null,null,null,null,"при q = 0 - только один маршрут"]
[32,"Точка 32",80,3219,null,null,44,"Точка 44",0,7825,null,{"$f":"IF(AND(ISNUMBER(I34:J35)),ROUND(SQRT((I34-I35)^2+(J34-J35)^2),),\"\")","v":261},null,null,null,null,"при q > 0 количество маршрутов равно n / q"]
[33,"Точка 33",64,3110,null,null,26,"Точка 26",29,8084,null,{"$f":"IF(AND(ISNUMBER(I35:J36)),ROUND(SQRT((I35-I36)^2+(J35-J36)^2),),\"\")","v":81}]
[34,"Точка 34",599,4422,null,null,61,"Точка 61",50,8162,null,{"$f":"IF(AND(ISNUMBER(I36:J37)),ROUND(SQRT((I36-I37)^2+(J36-J37)^2),),\"\")","v":40}]
[35,"Точка 35",307,5999,null,null,27,"Точка 27",45,8202,null,{"$f":"IF(AND(ISNUMBER(I37:J38)),ROUND(SQRT((I37-I38)^2+(J37-J38)^2),),\"\")","v":63}]
[36,"Точка 36",824,10203,null,null,7,"Точка 7",107,8191,null,{"$f":"IF(AND(ISNUMBER(I38:J39)),ROUND(SQRT((I38-I39)^2+(J38-J39)^2),),\"\")","v":0}]
[37,"Точка 37",821,9428,null,null,62,"Точка 62",107,8191,null,{"$f":"IF(AND(ISNUMBER(I39:J40)),ROUND(SQRT((I39-I40)^2+(J39-J40)^2),),\"\")","v":1488}]
[38,"Точка 38",439,3733,null,null,79,"Точка 79",771,9523,null,{"$f":"IF(AND(ISNUMBER(I40:J41)),ROUND(SQRT((I40-I41)^2+(J40-J41)^2),),\"\")","v":380}]
[39,"Точка 39",430,5858,null,null,60,"Точка 60",803,9902,null,{"$f":"IF(AND(ISNUMBER(I41:J42)),ROUND(SQRT((I41-I42)^2+(J41-J42)^2),),\"\")","v":246}]
[40,"Точка 40",26,3327,null,null,5,"Точка 5",802,10148,null,{"$f":"IF(AND(ISNUMBER(I42:J43)),ROUND(SQRT((I42-I43)^2+(J42-J43)^2),),\"\")","v":0}]
[41,"Точка 41",466,6890,null,null,59,"Точка 59",802,10148,null,{"$f":"IF(AND(ISNUMBER(I43:J44)),ROUND(SQRT((I43-I44)^2+(J43-J44)^2),),\"\")","v":59}]
[42,"Точка 42",874,10020,null,null,36,"Точка 36",824,10203,null,{"$f":"IF(AND(ISNUMBER(I44:J45)),ROUND(SQRT((I44-I45)^2+(J44-J45)^2),),\"\")","v":68}]
[43,"Точка 43",745,8789,null,null,6,"Точка 6",825,10271,null,{"$f":"IF(AND(ISNUMBER(I45:J46)),ROUND(SQRT((I45-I46)^2+(J45-J46)^2),),\"\")","v":264}]
[44,"Точка 44",0,7825,null,null,19,"Точка 19",865,10532,null,{"$f":"IF(AND(ISNUMBER(I46:J47)),ROUND(SQRT((I46-I47)^2+(J46-J47)^2),),\"\")","v":512}]
[45,"Точка 45",300,4490,null,null,42,"Точка 42",874,10020,null,{"$f":"IF(AND(ISNUMBER(I47:J48)),ROUND(SQRT((I47-I48)^2+(J47-J48)^2),),\"\")","v":235}]
[46,"Точка 46",358,3905,null,null,63,"Точка 63",847,9787,null,{"$f":"IF(AND(ISNUMBER(I48:J49)),ROUND(SQRT((I48-I49)^2+(J48-J49)^2),),\"\")","v":360}]
[47,"Точка 47",460,5378,null,null,37,"Точка 37",821,9428,null,{"$f":"IF(AND(ISNUMBER(I49:J50)),ROUND(SQRT((I49-I50)^2+(J49-J50)^2),),\"\")","v":254}]
[48,"Точка 48",166,3768,null,null,25,"Точка 25",771,9179,null,{"$f":"IF(AND(ISNUMBER(I50:J51)),ROUND(SQRT((I50-I51)^2+(J50-J51)^2),),\"\")","v":158}]
[49,"Точка 49",397,3918,null,null,80,"Точка 80",722,9029,null,{"$f":"IF(AND(ISNUMBER(I51:J52)),ROUND(SQRT((I51-I52)^2+(J51-J52)^2),),\"\")","v":241}]
[50,"Точка 50",297,5811,null,null,43,"Точка 43",745,8789,null,{"$f":"IF(AND(ISNUMBER(I52:J53)),ROUND(SQRT((I52-I53)^2+(J52-J53)^2),),\"\")","v":109}]
[51,"Точка 51",271,4690,null,null,73,"Точка 73",807,8699,null,{"$f":"IF(AND(ISNUMBER(I53:J54)),ROUND(SQRT((I53-I54)^2+(J53-J54)^2),),\"\")","v":77}]
[52,"Точка 52",810,8393,null,null,64,"Точка 64",752,8645,null,{"$f":"IF(AND(ISNUMBER(I54:J55)),ROUND(SQRT((I54-I55)^2+(J54-J55)^2),),\"\")","v":0}]
[53,"Точка 53",786,8163,null,null,8,"Точка 8",752,8645,null,{"$f":"IF(AND(ISNUMBER(I55:J56)),ROUND(SQRT((I55-I56)^2+(J55-J56)^2),),\"\")","v":100}]
[54,"Точка 54",150,4230,null,null,82,"Точка 82",788,8552,null,{"$f":"IF(AND(ISNUMBER(I56:J57)),ROUND(SQRT((I56-I57)^2+(J56-J57)^2),),\"\")","v":161}]
[55,"Точка 55",80,3219,null,null,52,"Точка 52",810,8393,null,{"$f":"IF(AND(ISNUMBER(I57:J58)),ROUND(SQRT((I57-I58)^2+(J57-J58)^2),),\"\")","v":231}]
[56,"Точка 56",336,6904,null,null,53,"Точка 53",786,8163,null,{"$f":"IF(AND(ISNUMBER(I58:J59)),ROUND(SQRT((I58-I59)^2+(J58-J59)^2),),\"\")","v":145}]
[57,"Точка 57",599,4422,null,null,10,"Точка 10",852,8034,null,{"$f":"IF(AND(ISNUMBER(I59:J60)),ROUND(SQRT((I59-I60)^2+(J59-J60)^2),),\"\")","v":0}]
[58,"Точка 58",479,5409,null,null,66,"Точка 66",852,8034,null,{"$f":"IF(AND(ISNUMBER(I60:J61)),ROUND(SQRT((I60-I61)^2+(J60-J61)^2),),\"\")","v":117}]
[59,"Точка 59",802,10148,null,null,9,"Точка 9",852,7917,null,{"$f":"IF(AND(ISNUMBER(I61:J62)),ROUND(SQRT((I61-I62)^2+(J61-J62)^2),),\"\")","v":881}]
[60,"Точка 60",803,9902,null,null,14,"Точка 14",562,7085,null,{"$f":"IF(AND(ISNUMBER(I62:J63)),ROUND(SQRT((I62-I63)^2+(J62-J63)^2),),\"\")","v":55}]
[61,"Точка 61",50,8162,null,null,13,"Точка 13",560,7030,null,{"$f":"IF(AND(ISNUMBER(I63:J64)),ROUND(SQRT((I63-I64)^2+(J63-J64)^2),),\"\")","v":169}]
[62,"Точка 62",107,8191,null,null,41,"Точка 41",466,6890,null,{"$f":"IF(AND(ISNUMBER(I64:J65)),ROUND(SQRT((I64-I65)^2+(J64-J65)^2),),\"\")","v":550}]
[63,"Точка 63",847,9787,null,null,29,"Точка 29",430,6341,null,{"$f":"IF(AND(ISNUMBER(I65:J66)),ROUND(SQRT((I65-I66)^2+(J65-J66)^2),),\"\")","v":483}]
[64,"Точка 64",752,8645,null,null,39,"Точка 39",430,5858,null,{"$f":"IF(AND(ISNUMBER(I66:J67)),ROUND(SQRT((I66-I67)^2+(J66-J67)^2),),\"\")","v":197}]
[65,"Точка 65",332,4434,null,null,75,{"$f":"IF($G67<>\"\",INDEX(B$3:B$227,$G67),NA())","v":"Точка 75"},{"$f":"IF($G67<>\"\",INDEX(C$3:C$227,$G67),NA())","v":449},{"$f":"IF($G67<>\"\",INDEX(D$3:D$227,$G67),NA())","v":5662},null,{"$f":"IF(AND(ISNUMBER(I67:J68)),ROUND(SQRT((I67-I68)^2+(J67-J68)^2),),\"\")","v":255}]
[66,"Точка 66",852,8034,null,null,58,"Точка 58",479,5409,null,{"$f":"IF(AND(ISNUMBER(I68:J69)),ROUND(SQRT((I68-I69)^2+(J68-J69)^2),),\"\")","v":36}]
[67,"Точка 67",408,3656,null,null,47,"Точка 47",460,5378,null,{"$f":"IF(AND(ISNUMBER(I69:J70)),ROUND(SQRT((I69-I70)^2+(J69-J70)^2),),\"\")","v":267}]
[68,"Точка 68",72,0,null,null,76,"Точка 76",482,5112,null,{"$f":"IF(AND(ISNUMBER(I70:J71)),ROUND(SQRT((I70-I71)^2+(J70-J71)^2),),\"\")","v":110}]
[69,"Точка 69",31,3653,null,null,2,"Точка 2",550,5025,null,{"$f":"IF(AND(ISNUMBER(I71:J72)),ROUND(SQRT((I71-I72)^2+(J71-J72)^2),),\"\")","v":148}]
[70,"Точка 70",54,7655,null,null,15,"Точка 15",583,4881,null,{"$f":"IF(AND(ISNUMBER(I72:J73)),ROUND(SQRT((I72-I73)^2+(J72-J73)^2),),\"\")","v":459}]
[71,"Точка 71",225,4798,null,null,34,"Точка 34",599,4422,null,{"$f":"IF(AND(ISNUMBER(I73:J74)),ROUND(SQRT((I73-I74)^2+(J73-J74)^2),),\"\")","v":0}]
[72,"Точка 72",598,3954,null,null,57,"Точка 57",599,4422,null,{"$f":"IF(AND(ISNUMBER(I74:J75)),ROUND(SQRT((I74-I75)^2+(J74-J75)^2),),\"\")","v":124}]
[73,"Точка 73",807,8699,null,null,30,"Точка 30",549,4308,null,{"$f":"IF(AND(ISNUMBER(I75:J76)),ROUND(SQRT((I75-I76)^2+(J75-J76)^2),),\"\")","v":10}]
[74,"Точка 74",363,6571,null,null,31,"Точка 31",539,4310,null,{"$f":"IF(AND(ISNUMBER(I76:J77)),ROUND(SQRT((I76-I77)^2+(J76-J77)^2),),\"\")","v":111}]
[75,"Точка 75",449,5662,null,null,4,"Точка 4",540,4199,null,{"$f":"IF(AND(ISNUMBER(I77:J78)),ROUND(SQRT((I77-I78)^2+(J77-J78)^2),),\"\")","v":252}]
[76,"Точка 76",482,5112,null,null,72,"Точка 72",598,3954,null,{"$f":"IF(AND(ISNUMBER(I78:J79)),ROUND(SQRT((I78-I79)^2+(J78-J79)^2),),\"\")","v":0}]
[77,"Точка 77",3,3487,null,null,12,"Точка 12",598,3954,null,{"$f":"IF(AND(ISNUMBER(I79:J80)),ROUND(SQRT((I79-I80)^2+(J79-J80)^2),),\"\")","v":184}]
[78,"Точка 78",11,4177,null,null,23,"Точка 23",416,3983,null,{"$f":"IF(AND(ISNUMBER(I80:J81)),ROUND(SQRT((I80-I81)^2+(J80-J81)^2),),\"\")","v":110}]
[79,"Точка 79",771,9523,null,null,17,"Точка 17",311,3951,null,{"$f":"IF(AND(ISNUMBER(I81:J82)),ROUND(SQRT((I81-I82)^2+(J81-J82)^2),),\"\")","v":66}]
[80,"Точка 80",722,9029,null,null,46,"Точка 46",358,3905,null,{"$f":"IF(AND(ISNUMBER(I82:J83)),ROUND(SQRT((I82-I83)^2+(J82-J83)^2),),\"\")","v":0}]
[81,"Точка 81",71,7452,null,null,18,"Точка 18",358,3905,null,{"$f":"IF(AND(ISNUMBER(I83:J84)),ROUND(SQRT((I83-I84)^2+(J83-J84)^2),),\"\")","v":41}]
[82,"Точка 82",788,8552,null,null,49,"Точка 49",397,3918,null,{"$f":"IF(AND(ISNUMBER(I84:J85)),ROUND(SQRT((I84-I85)^2+(J84-J85)^2),),\"\")","v":88}]
[83,null,null,null,null,null,1,"Точка 1",427,3835,null,{"$f":"IF(AND(ISNUMBER(I85:J86)),ROUND(SQRT((I85-I86)^2+(J85-J86)^2),),\"\")","v":""}]
[84,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I86:J87)),ROUND(SQRT((I86-I87)^2+(J86-J87)^2),),\"\")","v":""}]
[85,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I87:J88)),ROUND(SQRT((I87-I88)^2+(J87-J88)^2),),\"\")","v":""}]
[86,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I88:J89)),ROUND(SQRT((I88-I89)^2+(J88-J89)^2),),\"\")","v":""}]
[87,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I89:J90)),ROUND(SQRT((I89-I90)^2+(J89-J90)^2),),\"\")","v":""}]
[88,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I90:J91)),ROUND(SQRT((I90-I91)^2+(J90-J91)^2),),\"\")","v":""}]
[89,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I91:J92)),ROUND(SQRT((I91-I92)^2+(J91-J92)^2),),\"\")","v":""}]
[90,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I92:J93)),ROUND(SQRT((I92-I93)^2+(J92-J93)^2),),\"\")","v":""}]
[91,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I93:J94)),ROUND(SQRT((I93-I94)^2+(J93-J94)^2),),\"\")","v":""}]
[92,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I94:J95)),ROUND(SQRT((I94-I95)^2+(J94-J95)^2),),\"\")","v":""}]
[93,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I95:J96)),ROUND(SQRT((I95-I96)^2+(J95-J96)^2),),\"\")","v":""}]
[94,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I96:J97)),ROUND(SQRT((I96-I97)^2+(J96-J97)^2),),\"\")","v":""}]
[95,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I97:J98)),ROUND(SQRT((I97-I98)^2+(J97-J98)^2),),\"\")","v":""}]
[96,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I98:J99)),ROUND(SQRT((I98-I99)^2+(J98-J99)^2),),\"\")","v":""}]
[97,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I99:J100)),ROUND(SQRT((I99-I100)^2+(J99-J100)^2),),\"\")","v":""}]
[98,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I100:J101)),ROUND(SQRT((I100-I101)^2+(J100-J101)^2),),\"\")","v":""}]
[99,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I101:J102)),ROUND(SQRT((I101-I102)^2+(J101-J102)^2),),\"\")","v":""}]
[100,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I102:J103)),ROUND(SQRT((I102-I103)^2+(J102-J103)^2),),\"\")","v":""}]
[101,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I103:J104)),ROUND(SQRT((I103-I104)^2+(J103-J104)^2),),\"\")","v":""}]
[102,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I104:J105)),ROUND(SQRT((I104-I105)^2+(J104-J105)^2),),\"\")","v":""}]
[103,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I105:J106)),ROUND(SQRT((I105-I106)^2+(J105-J106)^2),),\"\")","v":""}]
[104,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I106:J107)),ROUND(SQRT((I106-I107)^2+(J106-J107)^2),),\"\")","v":""}]
[105,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I107:J108)),ROUND(SQRT((I107-I108)^2+(J107-J108)^2),),\"\")","v":""}]
[106,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I108:J109)),ROUND(SQRT((I108-I109)^2+(J108-J109)^2),),\"\")","v":""}]
[107,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I109:J110)),ROUND(SQRT((I109-I110)^2+(J109-J110)^2),),\"\")","v":""}]
[108,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I110:J111)),ROUND(SQRT((I110-I111)^2+(J110-J111)^2),),\"\")","v":""}]
[109,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I111:J112)),ROUND(SQRT((I111-I112)^2+(J111-J112)^2),),\"\")","v":""}]
[110,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I112:J113)),ROUND(SQRT((I112-I113)^2+(J112-J113)^2),),\"\")","v":""}]
[111,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I113:J114)),ROUND(SQRT((I113-I114)^2+(J113-J114)^2),),\"\")","v":""}]
[112,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I114:J115)),ROUND(SQRT((I114-I115)^2+(J114-J115)^2),),\"\")","v":""}]
[113,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I115:J116)),ROUND(SQRT((I115-I116)^2+(J115-J116)^2),),\"\")","v":""}]
[114,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I116:J117)),ROUND(SQRT((I116-I117)^2+(J116-J117)^2),),\"\")","v":""}]
[115,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I117:J118)),ROUND(SQRT((I117-I118)^2+(J117-J118)^2),),\"\")","v":""}]
[116,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I118:J119)),ROUND(SQRT((I118-I119)^2+(J118-J119)^2),),\"\")","v":""}]
[117,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I119:J120)),ROUND(SQRT((I119-I120)^2+(J119-J120)^2),),\"\")","v":""}]
[118,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I120:J121)),ROUND(SQRT((I120-I121)^2+(J120-J121)^2),),\"\")","v":""}]
[119,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I121:J122)),ROUND(SQRT((I121-I122)^2+(J121-J122)^2),),\"\")","v":""}]
[120,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I122:J123)),ROUND(SQRT((I122-I123)^2+(J122-J123)^2),),\"\")","v":""}]
[121,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I123:J124)),ROUND(SQRT((I123-I124)^2+(J123-J124)^2),),\"\")","v":""}]
[122,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I124:J125)),ROUND(SQRT((I124-I125)^2+(J124-J125)^2),),\"\")","v":""}]
[123,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I125:J126)),ROUND(SQRT((I125-I126)^2+(J125-J126)^2),),\"\")","v":""}]
[124,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I126:J127)),ROUND(SQRT((I126-I127)^2+(J126-J127)^2),),\"\")","v":""}]
[125,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I127:J128)),ROUND(SQRT((I127-I128)^2+(J127-J128)^2),),\"\")","v":""}]
[126,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I128:J129)),ROUND(SQRT((I128-I129)^2+(J128-J129)^2),),\"\")","v":""}]
[127,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I129:J130)),ROUND(SQRT((I129-I130)^2+(J129-J130)^2),),\"\")","v":""}]
[128,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I130:J131)),ROUND(SQRT((I130-I131)^2+(J130-J131)^2),),\"\")","v":""}]
[129,null,null,null,null,null,null,{"$f":"IF($G131<>\"\",INDEX(B$3:B$227,$G131),NA())","v":{"$error":"#N/A"}},{"$f":"IF($G131<>\"\",INDEX(C$3:C$227,$G131),NA())","v":{"$error":"#N/A"}},{"$f":"IF($G131<>\"\",INDEX(D$3:D$227,$G131),NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(ISNUMBER(I131:J132)),ROUND(SQRT((I131-I132)^2+(J131-J132)^2),),\"\")","v":""}]
[130,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I132:J133)),ROUND(SQRT((I132-I133)^2+(J132-J133)^2),),\"\")","v":""}]
[131,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I133:J134)),ROUND(SQRT((I133-I134)^2+(J133-J134)^2),),\"\")","v":""}]
[132,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I134:J135)),ROUND(SQRT((I134-I135)^2+(J134-J135)^2),),\"\")","v":""}]
[133,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I135:J136)),ROUND(SQRT((I135-I136)^2+(J135-J136)^2),),\"\")","v":""}]
[134,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I136:J137)),ROUND(SQRT((I136-I137)^2+(J136-J137)^2),),\"\")","v":""}]
[135,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I137:J138)),ROUND(SQRT((I137-I138)^2+(J137-J138)^2),),\"\")","v":""}]
[136,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I138:J139)),ROUND(SQRT((I138-I139)^2+(J138-J139)^2),),\"\")","v":""}]
[137,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I139:J140)),ROUND(SQRT((I139-I140)^2+(J139-J140)^2),),\"\")","v":""}]
[138,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I140:J141)),ROUND(SQRT((I140-I141)^2+(J140-J141)^2),),\"\")","v":""}]
[139,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I141:J142)),ROUND(SQRT((I141-I142)^2+(J141-J142)^2),),\"\")","v":""}]
[140,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I142:J143)),ROUND(SQRT((I142-I143)^2+(J142-J143)^2),),\"\")","v":""}]
[141,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I143:J144)),ROUND(SQRT((I143-I144)^2+(J143-J144)^2),),\"\")","v":""}]
[142,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I144:J145)),ROUND(SQRT((I144-I145)^2+(J144-J145)^2),),\"\")","v":""}]
[143,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I145:J146)),ROUND(SQRT((I145-I146)^2+(J145-J146)^2),),\"\")","v":""}]
[144,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I146:J147)),ROUND(SQRT((I146-I147)^2+(J146-J147)^2),),\"\")","v":""}]
[145,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I147:J148)),ROUND(SQRT((I147-I148)^2+(J147-J148)^2),),\"\")","v":""}]
[146,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I148:J149)),ROUND(SQRT((I148-I149)^2+(J148-J149)^2),),\"\")","v":""}]
[147,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I149:J150)),ROUND(SQRT((I149-I150)^2+(J149-J150)^2),),\"\")","v":""}]
[148,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I150:J151)),ROUND(SQRT((I150-I151)^2+(J150-J151)^2),),\"\")","v":""}]
[149,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I151:J152)),ROUND(SQRT((I151-I152)^2+(J151-J152)^2),),\"\")","v":""}]
[150,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I152:J153)),ROUND(SQRT((I152-I153)^2+(J152-J153)^2),),\"\")","v":""}]
[151,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I153:J154)),ROUND(SQRT((I153-I154)^2+(J153-J154)^2),),\"\")","v":""}]
[152,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I154:J155)),ROUND(SQRT((I154-I155)^2+(J154-J155)^2),),\"\")","v":""}]
[153,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I155:J156)),ROUND(SQRT((I155-I156)^2+(J155-J156)^2),),\"\")","v":""}]
[154,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I156:J157)),ROUND(SQRT((I156-I157)^2+(J156-J157)^2),),\"\")","v":""}]
[155,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I157:J158)),ROUND(SQRT((I157-I158)^2+(J157-J158)^2),),\"\")","v":""}]
[156,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I158:J159)),ROUND(SQRT((I158-I159)^2+(J158-J159)^2),),\"\")","v":""}]
[157,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I159:J160)),ROUND(SQRT((I159-I160)^2+(J159-J160)^2),),\"\")","v":""}]
[158,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I160:J161)),ROUND(SQRT((I160-I161)^2+(J160-J161)^2),),\"\")","v":""}]
[159,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I161:J162)),ROUND(SQRT((I161-I162)^2+(J161-J162)^2),),\"\")","v":""}]
[160,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I162:J163)),ROUND(SQRT((I162-I163)^2+(J162-J163)^2),),\"\")","v":""}]
[161,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I163:J164)),ROUND(SQRT((I163-I164)^2+(J163-J164)^2),),\"\")","v":""}]
[162,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I164:J165)),ROUND(SQRT((I164-I165)^2+(J164-J165)^2),),\"\")","v":""}]
[163,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I165:J166)),ROUND(SQRT((I165-I166)^2+(J165-J166)^2),),\"\")","v":""}]
[164,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I166:J167)),ROUND(SQRT((I166-I167)^2+(J166-J167)^2),),\"\")","v":""}]
[165,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I167:J168)),ROUND(SQRT((I167-I168)^2+(J167-J168)^2),),\"\")","v":""}]
[166,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I168:J169)),ROUND(SQRT((I168-I169)^2+(J168-J169)^2),),\"\")","v":""}]
[167,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I169:J170)),ROUND(SQRT((I169-I170)^2+(J169-J170)^2),),\"\")","v":""}]
[168,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I170:J171)),ROUND(SQRT((I170-I171)^2+(J170-J171)^2),),\"\")","v":""}]
[169,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I171:J172)),ROUND(SQRT((I171-I172)^2+(J171-J172)^2),),\"\")","v":""}]
[170,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I172:J173)),ROUND(SQRT((I172-I173)^2+(J172-J173)^2),),\"\")","v":""}]
[171,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I173:J174)),ROUND(SQRT((I173-I174)^2+(J173-J174)^2),),\"\")","v":""}]
[172,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I174:J175)),ROUND(SQRT((I174-I175)^2+(J174-J175)^2),),\"\")","v":""}]
[173,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I175:J176)),ROUND(SQRT((I175-I176)^2+(J175-J176)^2),),\"\")","v":""}]
[174,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I176:J177)),ROUND(SQRT((I176-I177)^2+(J176-J177)^2),),\"\")","v":""}]
[175,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I177:J178)),ROUND(SQRT((I177-I178)^2+(J177-J178)^2),),\"\")","v":""}]
[176,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I178:J179)),ROUND(SQRT((I178-I179)^2+(J178-J179)^2),),\"\")","v":""}]
[177,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I179:J180)),ROUND(SQRT((I179-I180)^2+(J179-J180)^2),),\"\")","v":""}]
[178,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I180:J181)),ROUND(SQRT((I180-I181)^2+(J180-J181)^2),),\"\")","v":""}]
[179,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I181:J182)),ROUND(SQRT((I181-I182)^2+(J181-J182)^2),),\"\")","v":""}]
[180,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I182:J183)),ROUND(SQRT((I182-I183)^2+(J182-J183)^2),),\"\")","v":""}]
[181,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I183:J184)),ROUND(SQRT((I183-I184)^2+(J183-J184)^2),),\"\")","v":""}]
[182,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I184:J185)),ROUND(SQRT((I184-I185)^2+(J184-J185)^2),),\"\")","v":""}]
[183,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I185:J186)),ROUND(SQRT((I185-I186)^2+(J185-J186)^2),),\"\")","v":""}]
[184,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I186:J187)),ROUND(SQRT((I186-I187)^2+(J186-J187)^2),),\"\")","v":""}]
[185,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I187:J188)),ROUND(SQRT((I187-I188)^2+(J187-J188)^2),),\"\")","v":""}]
[186,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I188:J189)),ROUND(SQRT((I188-I189)^2+(J188-J189)^2),),\"\")","v":""}]
[187,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I189:J190)),ROUND(SQRT((I189-I190)^2+(J189-J190)^2),),\"\")","v":""}]
[188,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I190:J191)),ROUND(SQRT((I190-I191)^2+(J190-J191)^2),),\"\")","v":""}]
[189,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I191:J192)),ROUND(SQRT((I191-I192)^2+(J191-J192)^2),),\"\")","v":""}]
[190,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I192:J193)),ROUND(SQRT((I192-I193)^2+(J192-J193)^2),),\"\")","v":""}]
[191,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I193:J194)),ROUND(SQRT((I193-I194)^2+(J193-J194)^2),),\"\")","v":""}]
[192,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I194:J195)),ROUND(SQRT((I194-I195)^2+(J194-J195)^2),),\"\")","v":""}]
[193,null,null,null,null,null,null,{"$f":"IF($G195<>\"\",INDEX(B$3:B$227,$G195),NA())","v":{"$error":"#N/A"}},{"$f":"IF($G195<>\"\",INDEX(C$3:C$227,$G195),NA())","v":{"$error":"#N/A"}},{"$f":"IF($G195<>\"\",INDEX(D$3:D$227,$G195),NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(ISNUMBER(I195:J196)),ROUND(SQRT((I195-I196)^2+(J195-J196)^2),),\"\")","v":""}]
[194,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I196:J197)),ROUND(SQRT((I196-I197)^2+(J196-J197)^2),),\"\")","v":""}]
[195,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I197:J198)),ROUND(SQRT((I197-I198)^2+(J197-J198)^2),),\"\")","v":""}]
[196,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I198:J199)),ROUND(SQRT((I198-I199)^2+(J198-J199)^2),),\"\")","v":""}]
[197,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I199:J200)),ROUND(SQRT((I199-I200)^2+(J199-J200)^2),),\"\")","v":""}]
[198,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I200:J201)),ROUND(SQRT((I200-I201)^2+(J200-J201)^2),),\"\")","v":""}]
[199,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I201:J202)),ROUND(SQRT((I201-I202)^2+(J201-J202)^2),),\"\")","v":""}]
[200,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I202:J203)),ROUND(SQRT((I202-I203)^2+(J202-J203)^2),),\"\")","v":""}]
[201,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I203:J204)),ROUND(SQRT((I203-I204)^2+(J203-J204)^2),),\"\")","v":""}]
[202,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I204:J205)),ROUND(SQRT((I204-I205)^2+(J204-J205)^2),),\"\")","v":""}]
[203,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I205:J206)),ROUND(SQRT((I205-I206)^2+(J205-J206)^2),),\"\")","v":""}]
[204,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I206:J207)),ROUND(SQRT((I206-I207)^2+(J206-J207)^2),),\"\")","v":""}]
[205,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I207:J208)),ROUND(SQRT((I207-I208)^2+(J207-J208)^2),),\"\")","v":""}]
[206,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I208:J209)),ROUND(SQRT((I208-I209)^2+(J208-J209)^2),),\"\")","v":""}]
[207,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I209:J210)),ROUND(SQRT((I209-I210)^2+(J209-J210)^2),),\"\")","v":""}]
[208,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I210:J211)),ROUND(SQRT((I210-I211)^2+(J210-J211)^2),),\"\")","v":""}]
[209,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I211:J212)),ROUND(SQRT((I211-I212)^2+(J211-J212)^2),),\"\")","v":""}]
[210,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I212:J213)),ROUND(SQRT((I212-I213)^2+(J212-J213)^2),),\"\")","v":""}]
[211,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I213:J214)),ROUND(SQRT((I213-I214)^2+(J213-J214)^2),),\"\")","v":""}]
[212,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I214:J215)),ROUND(SQRT((I214-I215)^2+(J214-J215)^2),),\"\")","v":""}]
[213,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I215:J216)),ROUND(SQRT((I215-I216)^2+(J215-J216)^2),),\"\")","v":""}]
[214,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I216:J217)),ROUND(SQRT((I216-I217)^2+(J216-J217)^2),),\"\")","v":""}]
[215,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I217:J218)),ROUND(SQRT((I217-I218)^2+(J217-J218)^2),),\"\")","v":""}]
[216,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I218:J219)),ROUND(SQRT((I218-I219)^2+(J218-J219)^2),),\"\")","v":""}]
[217,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I219:J220)),ROUND(SQRT((I219-I220)^2+(J219-J220)^2),),\"\")","v":""}]
[218,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I220:J221)),ROUND(SQRT((I220-I221)^2+(J220-J221)^2),),\"\")","v":""}]
[219,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I221:J222)),ROUND(SQRT((I221-I222)^2+(J221-J222)^2),),\"\")","v":""}]
[220,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I222:J223)),ROUND(SQRT((I222-I223)^2+(J222-J223)^2),),\"\")","v":""}]
[221,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I223:J224)),ROUND(SQRT((I223-I224)^2+(J223-J224)^2),),\"\")","v":""}]
[222,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I224:J225)),ROUND(SQRT((I224-I225)^2+(J224-J225)^2),),\"\")","v":""}]
[223,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I225:J226)),ROUND(SQRT((I225-I226)^2+(J225-J226)^2),),\"\")","v":""}]
[224,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I226:J227)),ROUND(SQRT((I226-I227)^2+(J226-J227)^2),),\"\")","v":""}]
[225,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(AND(ISNUMBER(I227:J228)),ROUND(SQRT((I227-I228)^2+(J227-J228)^2),),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"SUM(L$3:L227)","v":22777}]

{"sheet":"Лист1","index":1,"n_rows":83,"n_cols":9,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["адрес","долгота","широта",null,null,800,200,{"$f":"MIN(F2:F200)","v":-427},{"$f":"MIN(G2:G200)","v":-3835}]
[null,"56.13818","40.3581549",{"$f":"SUBSTITUTE(B2,\".\",\",\")*10000000","v":561381800},{"$f":"SUBSTITUTE(C2,\".\",\",\")*10000000","v":403581549},0,0,{"$f":"F2-H$1","v":427},{"$f":"G2-I$1","v":3835}]
[null,"56.148099","40.381955",{"$f":"SUBSTITUTE(B3,\".\",\",\")*10000000","v":561480990},403819550,{"$f":"INT((D3-D$2+F$2)/F$1)","v":123},{"$f":"INT((E3-E$2+G$2)/G$1)","v":1190},{"$f":"F3-H$1","v":550},5025]
[null,"56.127811","40.353952",561278110,403539520,{"$f":"INT((D4-D$2+F$2)/F$1)","v":-130},-211,297,3624]
[null,"56.147224","40.365452",561472240,403654520,113,364,540,4199]
[null,"56.1682538","40.484426",561682538,404844260,375,6313,802,10148]
[null,"56.170081","40.486888",561700810,404868880,398,6436,825,10271]
[null,"56.11261","40.445277",561126100,404452770,-320,4356,107,8191]
[null,"56.164242","40.4543729",561642420,404543729,325,4810,752,8645]
[null,"56.172186","40.43981",{"$f":"SUBSTITUTE(B10,\".\",\",\")*10000000","v":561721860},{"$f":"SUBSTITUTE(C10,\".\",\",\")*10000000","v":404398100},{"$f":"INT((D10-D$2+F$2)/F$1)","v":425},{"$f":"INT((E10-E$2+G$2)/G$1)","v":4082},{"$f":"F10-H$1","v":852},{"$f":"G10-I$1","v":7917}]
[null,"56.172252","40.442146",561722520,404421460,425,4199,852,8034]
[null,"56.106157","40.348014",561061570,403480140,-401,-508,26,3327]
[null,"56.15187","40.360544",561518700,403605440,171,119,598,3954]
[null,"56.148879","40.422071",561488790,404220710,133,3195,560,7030]
[null,"56.14898","40.423172",561489800,404231720,135,3250,562,7085]
[null,"56.150734","40.379083",561507340,403790830,156,1046,583,4881]
[null,"56.137398","40.36792",561373980,403679200,-10,488,417,4323]
[null,"56.128906","40.360483",561289060,403604830,-116,116,311,3951]
[null,"56.132665","40.359569",561326650,403595690,-69,70,358,3905]
[null,"56.1732425","40.4921148",561732425,404921148.00000006,438,6697,865,10532]
[null,"56.120099","40.365291",561200990,403652910,-227,356,200,4191]
[null,"56.117359","40.347793",561173590,403477930,-261,-519,166,3316]
[null,"56.1339586","40.364918",561339586,403649180,-53,338,374,4173]
[null,"56.137325","40.361116",561373250,403611160,-11,148,416,3983]
[null,"56.133374","40.358129",561333740,403581290,-61,-2,366,3833]
[null,"56.16575","40.465054",561657500,404650540,344,5344,771,9179]
[null,"56.106398","40.443138",561063980,404431380,-398,4249,29,8084]
[null,"56.107647","40.445505",561076470,404455050,-382,4367,45,8202]
[null,"56.132213","40.356713",561322130,403567130,-75,-73,352,3762]
[null,"56.138432","40.408276",561384320,404082760,3,2506,430,6341]
[null,"56.148002","40.367619",561480020,403676190,122,473,549,4308]
[null,"56.14718","40.367665",561471800,403676650,112,475,539,4310]
[null,"56.110443","40.345842",561104430,403458420,-347,-616,80,3219]
[null,"56.1091658","40.3436697",561091658,403436697,-363,-725,64,3110]
[null,"56.15198","40.369898",561519800,403698980,172,587,599,4422]
[null,"56.128582","40.401442",561285820,404014420,-120,2164,307,5999]
[null,"56.169956","40.485532",561699560,404855320,397,6368,824,10203]
[null,"56.1697072","40.4700156",561697072,404700156.00000006,394,5593,821,9428]
[null,"56.139211","40.356118",561392110,403561180,12,-102,439,3733]
[null,"56.138461","40.398628",561384610,403986280,3,2023,430,5858]
[null,"56.106157","40.348014",561061570,403480140,-401,-508,26,3327]
[null,"56.1413","40.41927",561413000,404192700,39,3055,466,6890]
[null,"56.173976","40.481855",561739760,404818550.00000006,447,6185,874,10020]
[null,"56.163627","40.457242",561636270,404572420,318,4954,745,8789]
[null,"56.104031","40.437965",561040310,404379650,-427,3990,0,7825]
[null,"56.128041","40.371257",561280410,403712570,-127,655,300,4490]
[null,"56.132665","40.359569",561326650,403595690,-69,70,358,3905]
[null,"56.140834","40.389018",561408340,403890180,33,1543,460,5378]
[null,"56.117366","40.356827",561173660,403568270,-261,-67,166,3768]
[null,"56.135851","40.359824",561358510,403598240.00000006,-30,83,397,3918]
[null,"56.127818","40.3976929",561278180,403976929,-130,1976,297,5811]
[null,"56.1257222","40.3752681",561257222,403752681,-156,855,271,4690]
[null,"56.168885","40.449315",561688850,404493150,383,4558,810,8393]
[null,"56.166978","40.444723",561669780,404447230.00000006,359,4328,786,8163]
[null,"56.116039","40.366058",561160390,403660580,-277,395,150,4230]
[null,"56.110443","40.345842",561104430,403458420,-347,-616,80,3219]
[null,"56.1309142","40.4195427",561309142,404195427,-91,3069,336,6904]
[null,"56.15198","40.369898",561519800,403698980,172,587,599,4422]
[null,"56.142379","40.389636",561423790,403896360,52,1574,479,5409]
[null,"56.1682538","40.484426",561682538,404844260,375,6313,802,10148]
[null,"56.168298","40.4795",561682980,404795000,376,6067,803,9902]
[null,"56.108031","40.44471",561080310,404447100,-377,4327,50,8162]
[null,"56.11261","40.445277",561126100,404452770,-320,4356,107,8191]
[null,"56.171802","40.477204",561718020,404772040,420,5952,847,9787]
[null,"56.164242","40.4543729",561642420,404543729,325,4810,752,8645]
[null,"56.13061","40.370149",561306100,403701490,-95,599,332,4434]
[null,"56.172252","40.442146",561722520,404421460,425,4199,852,8034]
[null,"56.136732","40.354594",561367320,403545940,-19,-179,408,3656]
[null,"56.109808","40.281458",561098080,402814580,-355,-3835,72,0]
[null,"56.106516","40.354526",561065160,403545260,-396,-182,31,3653]
[null,"56.108368","40.43456",561083680,404345600,-373,3820,54,7655]
[null,"56.12206","40.377425",561220600,403774250,-202,963,225,4798]
[null,"56.15187","40.360544",561518700,403605440,171,119,598,3954]
[null,"56.16865","40.455454",{"$f":"SUBSTITUTE(B74,\".\",\",\")*10000000","v":561686500},{"$f":"SUBSTITUTE(C74,\".\",\",\")*10000000","v":404554540.00000006},{"$f":"INT((D74-D$2+F$2)/F$1)","v":380},{"$f":"INT((E74-E$2+G$2)/G$1)","v":4864},{"$f":"F74-H$1","v":807},{"$f":"G74-I$1","v":8699}]
[null,"56.133126","40.41288",561331260,404128800,-64,2736,363,6571]
[null,"56.139988","40.394696",561399880,403946960.00000006,22,1827,449,5662]
[null,"56.142652","40.38371",561426520,403837100,55,1277,482,5112]
[null,"56.104339","40.351205",561043390,403512050,-424,-348,3,3487]
[null,"56.1049705","40.3649966",561049705,403649966,-416,342,11,4177]
[null,"56.165708","40.471928",561657080,404719280,344,5688,771,9523]
[null,"56.161844","40.462046",561618440,404620460,295,5194,722,9029]
[null,"56.109767","40.430513",561097670,404305130,-356,3617,71,7452]
[null,"56.167138","40.452512",561671380,404525120,361,4717,788,8552]