{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["200"],"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":"200","index":0,"n_rows":52,"n_cols":33,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Data",null,"points",{"$f":"COUNT(D3:D110)","v":48},null,null,"Path of a salesman",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29842.540438743246,29758.246470205526]
["№","Name","X","Y",null,null,"№","Name","X","Y",null,"Length"]
[1,"Olympia (Washington)",5,81.5,null,{"$f":"VLOOKUP(A3,$G$3:$H$50,1,FALSE)","v":1},1,{"$f":"IF($G3<>\"\",INDEX(B$3:B$51,$G3),NA())","v":"Olympia (Washington)"},{"$f":"IF($G3<>\"\",INDEX(C$3:C$51,$G3),NA())","v":5},{"$f":"IF($G3<>\"\",INDEX(D$3:D$51,$G3),NA())","v":81.5},null,{"$f":"IF(AND(ISNUMBER(I3:J4)),SQRT((I3-I4)^2+(J3-J4)^2),\"\")","v":30.104604227703891},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[2,"Montgomery (Alabama)",67.08646616541354,25.710843373493951,null,{"$f":"VLOOKUP(A4,$G$3:$H$50,1,FALSE)","v":2},43,{"$f":"IF($G4<>\"\",INDEX(B$3:B$51,$G4),NA())","v":"Salt Lake City (Utah)"},{"$f":"IF($G4<>\"\",INDEX(C$3:C$51,$G4),NA())","v":23.778195488721813},{"$f":"IF($G4<>\"\",INDEX(D$3:D$51,$G4),NA())","v":57.969879518072275},null,{"$f":"IF(AND(ISNUMBER(I4:J5)),SQRT((I4-I5)^2+(J4-J5)^2),\"\")","v":12.866995917897039},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,156]
[3,"Phoenix (Arizona)",23.609022556390979,30.265060240963848,null,3,11,{"$f":"IF($G5<>\"\",INDEX(B$3:B$51,$G5),NA())","v":"Boise (Idaho)"},{"$f":"IF($G5<>\"\",INDEX(C$3:C$51,$G5),NA())","v":15.99624060150378},{"$f":"IF($G5<>\"\",INDEX(D$3:D$51,$G5),NA())","v":68.216867469879503},null,{"$f":"IF(AND(ISNUMBER(I5:J6)),SQRT((I5-I6)^2+(J5-J6)^2),\"\")","v":14.013247002967043},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,175,200]
[4,"Little Rock (Arkansas)",56.936090225563937,35.578313253012048,null,4,25,{"$f":"IF($G6<>\"\",INDEX(B$3:B$51,$G6),NA())","v":"Helena (Montana)"},{"$f":"IF($G6<>\"\",INDEX(C$3:C$51,$G6),NA())","v":23.609022556390979},{"$f":"IF($G6<>\"\",INDEX(D$3:D$51,$G6),NA())","v":79.981927710843365},null,{"$f":"IF(AND(ISNUMBER(I6:J7)),SQRT((I6-I7)^2+(J6-J7)^2),\"\")","v":18.67083993770429},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,126]
[5,"Sacramento (California)",7.5375939849624327,49.240963855421676,null,5,1,{"$f":"IF($G7<>\"\",INDEX(B$3:B$51,$G7),NA())","v":"Olympia (Washington)"},{"$f":"IF($G7<>\"\",INDEX(C$3:C$51,$G7),NA())","v":5},{"$f":"IF($G7<>\"\",INDEX(D$3:D$51,$G7),NA())","v":81.5},null,{"$f":"IF(AND(ISNUMBER(I7:J8)),SQRT((I7-I8)^2+(J7-J8)^2),\"\")","v":7.5903614457831452},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,162]
[6,"Denver (Colorado)",35.451127819548908,53.795180722891573,null,{"$error":"#N/A"},36,{"$f":"IF($G8<>\"\",INDEX(B$3:B$51,$G8),NA())","v":"Salem (Oregon)"},{"$f":"IF($G8<>\"\",INDEX(C$3:C$51,$G8),NA())","v":5},{"$f":"IF($G8<>\"\",INDEX(D$3:D$51,$G8),NA())","v":73.909638554216855},null,{"$f":"IF(AND(ISNUMBER(I8:J9)),SQRT((I8-I9)^2+(J8-J9)^2),\"\")","v":22.667964492187824},null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,94]
[7,"Hartford (Connecticut)",90.09398496240604,61.385542168674704,null,7,27,{"$f":"IF($G9<>\"\",INDEX(B$3:B$51,$G9),NA())","v":"Carson City (Nevada)"},{"$f":"IF($G9<>\"\",INDEX(C$3:C$51,$G9),NA())","v":10.413533834586481},{"$f":"IF($G9<>\"\",INDEX(D$3:D$51,$G9),NA())","v":51.897590361445801},null,{"$f":"IF(AND(ISNUMBER(I9:J10)),SQRT((I9-I10)^2+(J9-J10)^2),\"\")","v":3.9151876597636468},null,{"$f":"INDEX({\"Quickly\";\"Normally\";\"Slowly\";\"Very slowly\"},MATCH(N8,{0;9;12;15}))","v":"Very slowly"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,32]
[8,"Dover (Delaware)",85.357142857142861,51.897590361445801,null,8,5,{"$f":"IF($G10<>\"\",INDEX(B$3:B$51,$G10),NA())","v":"Sacramento (California)"},{"$f":"IF($G10<>\"\",INDEX(C$3:C$51,$G10),NA())","v":7.5375939849624327},{"$f":"IF($G10<>\"\",INDEX(D$3:D$51,$G10),NA())","v":49.240963855421676},null,{"$f":"IF(AND(ISNUMBER(I10:J11)),SQRT((I10-I11)^2+(J10-J11)^2),\"\")","v":24.867161766307859},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,105]
[9,"Tallahassee (Florida)",70.469924812030072,18.5,null,9,3,{"$f":"IF($G11<>\"\",INDEX(B$3:B$51,$G11),NA())","v":"Phoenix (Arizona)"},{"$f":"IF($G11<>\"\",INDEX(C$3:C$51,$G11),NA())","v":23.609022556390979},{"$f":"IF($G11<>\"\",INDEX(D$3:D$51,$G11),NA())","v":30.265060240963848},null,{"$f":"IF(AND(ISNUMBER(I11:J12)),SQRT((I11-I12)^2+(J11-J12)^2),\"\")","v":13.038867606426159},null,"Total:",{"$f":"L52","v":494.07336358498952},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,97]
[10,"Atlanta (Georgia)",70.300751879699234,31.02409638554218,null,10,30,{"$f":"IF($G12<>\"\",INDEX(B$3:B$51,$G12),NA())","v":"Santa Fe (New Mexico)"},{"$f":"IF($G12<>\"\",INDEX(C$3:C$51,$G12),NA())","v":33.928571428571445},{"$f":"IF($G12<>\"\",INDEX(D$3:D$51,$G12),NA())","v":38.234939759036145},null,{"$f":"IF(AND(ISNUMBER(I12:J13)),SQRT((I12-I13)^2+(J12-J13)^2),\"\")","v":14.215593274251342},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,167]
[11,"Boise (Idaho)",15.99624060150378,68.216867469879503,null,11,35,{"$f":"IF($G13<>\"\",INDEX(B$3:B$51,$G13),NA())","v":"Oklahoma City (Oklahoma)"},{"$f":"IF($G13<>\"\",INDEX(C$3:C$51,$G13),NA())","v":48.139097744360946},{"$f":"IF($G13<>\"\",INDEX(D$3:D$51,$G13),NA())","v":37.855421686746979},null,{"$f":"IF(AND(ISNUMBER(I13:J14)),SQRT((I13-I14)^2+(J13-J14)^2),\"\")","v":9.0869301490288077},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,98]
[12,"Springfield (Illinois)",61.672932330827074,53.795180722891573,null,12,4,{"$f":"IF($G14<>\"\",INDEX(B$3:B$51,$G14),NA())","v":"Little Rock (Arkansas)"},{"$f":"IF($G14<>\"\",INDEX(C$3:C$51,$G14),NA())","v":56.936090225563937},{"$f":"IF($G14<>\"\",INDEX(D$3:D$51,$G14),NA())","v":35.578313253012048},null,{"$f":"IF(AND(ISNUMBER(I14:J15)),SQRT((I14-I15)^2+(J14-J15)^2),\"\")","v":10.131259577763892},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,170]
[13,"Indianapolis (Indiana)",67.255639097744336,53.795180722891573,null,13,23,{"$f":"IF($G15<>\"\",INDEX(B$3:B$51,$G15),NA())","v":"Jackson (Mississippi)"},{"$f":"IF($G15<>\"\",INDEX(C$3:C$51,$G15),NA())","v":60.488721804511272},{"$f":"IF($G15<>\"\",INDEX(D$3:D$51,$G15),NA())","v":26.090361445783117},null,{"$f":"IF(AND(ISNUMBER(I15:J16)),SQRT((I15-I16)^2+(J15-J16)^2),\"\")","v":14.785065697877888},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,49]
[14,"Des Moines (Iowa)",54.906015037593974,61.006024096385509,null,14,42,{"$f":"IF($G16<>\"\",INDEX(B$3:B$51,$G16),NA())","v":"Austin (Texas)"},{"$f":"IF($G16<>\"\",INDEX(C$3:C$51,$G16),NA())","v":47.800751879699241},{"$f":"IF($G16<>\"\",INDEX(D$3:D$51,$G16),NA())","v":18.5},null,{"$f":"IF(AND(ISNUMBER(I16:J17)),SQRT((I16-I17)^2+(J16-J17)^2),\"\")","v":11.171861677837352},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,186,153]
[15,"Topeka (Kansas)",51.35338345864664,51.138554216867441,null,15,17,{"$f":"IF($G17<>\"\",INDEX(B$3:B$51,$G17),NA())","v":"Baton Rouge (Louisiana)"},{"$f":"IF($G17<>\"\",INDEX(C$3:C$51,$G17),NA())","v":58.966165413533837},{"$f":"IF($G17<>\"\",INDEX(D$3:D$51,$G17),NA())","v":18.879518072289152},null,{"$f":"IF(AND(ISNUMBER(I17:J18)),SQRT((I17-I18)^2+(J17-J18)^2),\"\")","v":11.510017995888823},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149,70]
[16,"Frankfort (Kentucky)",69.454887218045101,48.102409638554207,null,16,9,{"$f":"IF($G18<>\"\",INDEX(B$3:B$51,$G18),NA())","v":"Tallahassee (Florida)"},{"$f":"IF($G18<>\"\",INDEX(C$3:C$51,$G18),NA())","v":70.469924812030072},{"$f":"IF($G18<>\"\",INDEX(D$3:D$51,$G18),NA())","v":18.5},null,{"$f":"IF(AND(ISNUMBER(I18:J19)),SQRT((I18-I19)^2+(J18-J19)^2),\"\")","v":7.9651776232815923},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,169,139]
[17,"Baton Rouge (Louisiana)",58.966165413533837,18.879518072289152,null,17,2,{"$f":"IF($G19<>\"\",INDEX(B$3:B$51,$G19),NA())","v":"Montgomery (Alabama)"},{"$f":"IF($G19<>\"\",INDEX(C$3:C$51,$G19),NA())","v":67.08646616541354},{"$f":"IF($G19<>\"\",INDEX(D$3:D$51,$G19),NA())","v":25.710843373493951},null,{"$f":"IF(AND(ISNUMBER(I19:J20)),SQRT((I19-I20)^2+(J19-J20)^2),\"\")","v":6.2098542835642023},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,140]
[18,"Augusta (Maine)",95,71.25301204819273,null,18,10,{"$f":"IF($G20<>\"\",INDEX(B$3:B$51,$G20),NA())","v":"Atlanta (Georgia)"},{"$f":"IF($G20<>\"\",INDEX(C$3:C$51,$G20),NA())","v":70.300751879699234},{"$f":"IF($G20<>\"\",INDEX(D$3:D$51,$G20),NA())","v":31.02409638554218},null,{"$f":"IF(AND(ISNUMBER(I20:J21)),SQRT((I20-I21)^2+(J20-J21)^2),\"\")","v":5.8634823935413536},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,17]
[19,"Annapolis (Maryland)",83.665413533834567,51.138554216867441,null,19,39,{"$f":"IF($G21<>\"\",INDEX(B$3:B$51,$G21),NA())","v":"Columbia (South Carolina)"},{"$f":"IF($G21<>\"\",INDEX(C$3:C$51,$G21),NA())","v":76.05263157894737},{"$f":"IF($G21<>\"\",INDEX(D$3:D$51,$G21),NA())","v":32.162650602409613},null,{"$f":"IF(AND(ISNUMBER(I21:J22)),SQRT((I21-I22)^2+(J21-J22)^2),\"\")","v":7.3999913005060813},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,90]
[20,"Boston (Massachusetts)",92.800751879699263,64.042168674698772,null,20,32,{"$f":"IF($G22<>\"\",INDEX(B$3:B$51,$G22),NA())","v":"Raleigh (North Carolina)"},{"$f":"IF($G22<>\"\",INDEX(C$3:C$51,$G22),NA())","v":80.281954887218035},{"$f":"IF($G22<>\"\",INDEX(D$3:D$51,$G22),NA())","v":38.234939759036145},null,{"$f":"IF(AND(ISNUMBER(I22:J23)),SQRT((I22-I23)^2+(J22-J23)^2),\"\")","v":7.4066328557856149},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,89]
[21,"Lansing (Michigan)",70.131578947368439,65.180722891566234,null,21,45,{"$f":"IF($G23<>\"\",INDEX(B$3:B$51,$G23),NA())","v":"Richmond (Virginia)"},{"$f":"IF($G23<>\"\",INDEX(C$3:C$51,$G23),NA())","v":81.973684210526329},{"$f":"IF($G23<>\"\",INDEX(D$3:D$51,$G23),NA())","v":45.44578313253011},null,{"$f":"IF(AND(ISNUMBER(I23:J24)),SQRT((I23-I24)^2+(J23-J24)^2),\"\")","v":7.7315004339315214},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,11]
[22,"St. Paul (Minnesota)",55.582706766917305,73.909638554216855,null,22,46,{"$f":"IF($G24<>\"\",INDEX(B$3:B$51,$G24),NA())","v":"Charleston (West Virginia)"},{"$f":"IF($G24<>\"\",INDEX(C$3:C$51,$G24),NA())","v":75.037593984962442},{"$f":"IF($G24<>\"\",INDEX(D$3:D$51,$G24),NA())","v":48.861445783132538},null,{"$f":"IF(AND(ISNUMBER(I24:J25)),SQRT((I24-I25)^2+(J24-J25)^2),\"\")","v":5.6340705279718497},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,168]
[23,"Jackson (Mississippi)",60.488721804511272,26.090361445783117,null,23,16,{"$f":"IF($G25<>\"\",INDEX(B$3:B$51,$G25),NA())","v":"Frankfort (Kentucky)"},{"$f":"IF($G25<>\"\",INDEX(C$3:C$51,$G25),NA())","v":69.454887218045101},{"$f":"IF($G25<>\"\",INDEX(D$3:D$51,$G25),NA())","v":48.102409638554207},null,{"$f":"IF(AND(ISNUMBER(I25:J26)),SQRT((I25-I26)^2+(J25-J26)^2),\"\")","v":8.3103176408002035},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,167,110]
[24,"Jefferson City (Missouri)",57.10526315789474,49.240963855421676,null,24,41,{"$f":"IF($G26<>\"\",INDEX(B$3:B$51,$G26),NA())","v":"Nashville (Tennessee)"},{"$f":"IF($G26<>\"\",INDEX(C$3:C$51,$G26),NA())","v":66.071428571428584},{"$f":"IF($G26<>\"\",INDEX(D$3:D$51,$G26),NA())","v":40.512048192771076},null,{"$f":"IF(AND(ISNUMBER(I26:J27)),SQRT((I26-I27)^2+(J26-J27)^2),\"\")","v":12.513436413252656},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,23]
[25,"Helena (Montana)",23.609022556390979,79.981927710843365,null,25,24,{"$f":"IF($G27<>\"\",INDEX(B$3:B$51,$G27),NA())","v":"Jefferson City (Missouri)"},{"$f":"IF($G27<>\"\",INDEX(C$3:C$51,$G27),NA())","v":57.10526315789474},{"$f":"IF($G27<>\"\",INDEX(D$3:D$51,$G27),NA())","v":49.240963855421676},null,{"$f":"IF(AND(ISNUMBER(I27:J28)),SQRT((I27-I28)^2+(J27-J28)^2),\"\")","v":6.0568118060968583},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170,42]
[26,"Lincoln (Nebraska)",49.323308270676712,57.969879518072275,null,26,15,{"$f":"IF($G28<>\"\",INDEX(B$3:B$51,$G28),NA())","v":"Topeka (Kansas)"},{"$f":"IF($G28<>\"\",INDEX(C$3:C$51,$G28),NA())","v":51.35338345864664},{"$f":"IF($G28<>\"\",INDEX(D$3:D$51,$G28),NA())","v":51.138554216867441},null,{"$f":"IF(AND(ISNUMBER(I28:J29)),SQRT((I28-I29)^2+(J28-J29)^2),\"\")","v":7.1265847809236416},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,173]
[27,"Carson City (Nevada)",10.413533834586481,51.897590361445801,null,27,26,{"$f":"IF($G29<>\"\",INDEX(B$3:B$51,$G29),NA())","v":"Lincoln (Nebraska)"},{"$f":"IF($G29<>\"\",INDEX(C$3:C$51,$G29),NA())","v":49.323308270676712},{"$f":"IF($G29<>\"\",INDEX(D$3:D$51,$G29),NA())","v":57.969879518072275},null,{"$f":"IF(AND(ISNUMBER(I29:J30)),SQRT((I29-I30)^2+(J29-J30)^2),\"\")","v":6.3549027329932155},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,153,185]
[28,"Concord (New Hampshire)",91.95488721804513,67.078313253012041,null,28,14,{"$f":"IF($G30<>\"\",INDEX(B$3:B$51,$G30),NA())","v":"Des Moines (Iowa)"},{"$f":"IF($G30<>\"\",INDEX(C$3:C$51,$G30),NA())","v":54.906015037593974},{"$f":"IF($G30<>\"\",INDEX(D$3:D$51,$G30),NA())","v":61.006024096385509},null,{"$f":"IF(AND(ISNUMBER(I30:J31)),SQRT((I30-I31)^2+(J30-J31)^2),\"\")","v":9.8887527934779822},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,22]
[29,"Trenton (New Jersey)",86.710526315789494,56.072289156626503,null,29,12,{"$f":"IF($G31<>\"\",INDEX(B$3:B$51,$G31),NA())","v":"Springfield (Illinois)"},{"$f":"IF($G31<>\"\",INDEX(C$3:C$51,$G31),NA())","v":61.672932330827074},{"$f":"IF($G31<>\"\",INDEX(D$3:D$51,$G31),NA())","v":53.795180722891573},null,{"$f":"IF(AND(ISNUMBER(I31:J32)),SQRT((I31-I32)^2+(J31-J32)^2),\"\")","v":5.5827067669172621},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,193]
[30,"Santa Fe (New Mexico)",33.928571428571445,38.234939759036145,null,30,13,{"$f":"IF($G32<>\"\",INDEX(B$3:B$51,$G32),NA())","v":"Indianapolis (Indiana)"},{"$f":"IF($G32<>\"\",INDEX(C$3:C$51,$G32),NA())","v":67.255639097744336},{"$f":"IF($G32<>\"\",INDEX(D$3:D$51,$G32),NA())","v":53.795180722891573},null,{"$f":"IF(AND(ISNUMBER(I32:J33)),SQRT((I32-I33)^2+(J32-J33)^2),\"\")","v":5.5319665836806582},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,111]
[31,"Albany (New York)",88.402255639097731,64.801204819277103,null,31,34,{"$f":"IF($G33<>\"\",INDEX(B$3:B$51,$G33),NA())","v":"Columbus (Ohio)"},{"$f":"IF($G33<>\"\",INDEX(C$3:C$51,$G33),NA())","v":72.669172932330838},{"$f":"IF($G33<>\"\",INDEX(D$3:D$51,$G33),NA())","v":54.933734939759006},null,{"$f":"IF(AND(ISNUMBER(I33:J34)),SQRT((I33-I34)^2+(J33-J34)^2),\"\")","v":10.382167145161324},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,103]
[32,"Raleigh (North Carolina)",80.281954887218035,38.234939759036145,null,32,37,{"$f":"IF($G34<>\"\",INDEX(B$3:B$51,$G34),NA())","v":"Harrisburg (Pennsylvania)"},{"$f":"IF($G34<>\"\",INDEX(C$3:C$51,$G34),NA())","v":82.988721804511272},{"$f":"IF($G34<>\"\",INDEX(D$3:D$51,$G34),NA())","v":56.072289156626503},null,{"$f":"IF(AND(ISNUMBER(I34:J35)),SQRT((I34-I35)^2+(J34-J35)^2),\"\")","v":4.9799249143269133},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,58]
[33,"Bismarck (North Dakota)",42.556390977443613,81.120481927710841,null,33,19,{"$f":"IF($G35<>\"\",INDEX(B$3:B$51,$G35),NA())","v":"Annapolis (Maryland)"},{"$f":"IF($G35<>\"\",INDEX(C$3:C$51,$G35),NA())","v":83.665413533834567},{"$f":"IF($G35<>\"\",INDEX(D$3:D$51,$G35),NA())","v":51.138554216867441},null,{"$f":"IF(AND(ISNUMBER(I35:J36)),SQRT((I35-I36)^2+(J35-J36)^2),\"\")","v":1.8542071006544874},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,128]
[34,"Columbus (Ohio)",72.669172932330838,54.933734939759006,null,34,8,{"$f":"IF($G36<>\"\",INDEX(B$3:B$51,$G36),NA())","v":"Dover (Delaware)"},{"$f":"IF($G36<>\"\",INDEX(C$3:C$51,$G36),NA())","v":85.357142857142861},{"$f":"IF($G36<>\"\",INDEX(D$3:D$51,$G36),NA())","v":51.897590361445801},null,{"$f":"IF(AND(ISNUMBER(I36:J37)),SQRT((I36-I37)^2+(J36-J37)^2),\"\")","v":4.3885939452883465},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,29]
[35,"Oklahoma City (Oklahoma)",48.139097744360946,37.855421686746979,null,35,29,{"$f":"IF($G37<>\"\",INDEX(B$3:B$51,$G37),NA())","v":"Trenton (New Jersey)"},{"$f":"IF($G37<>\"\",INDEX(C$3:C$51,$G37),NA())","v":86.710526315789494},{"$f":"IF($G37<>\"\",INDEX(D$3:D$51,$G37),NA())","v":56.072289156626503},null,{"$f":"IF(AND(ISNUMBER(I37:J38)),SQRT((I37-I38)^2+(J37-J38)^2),\"\")","v":6.2990832653175453},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168,191]
[36,"Salem (Oregon)",5,73.909638554216855,null,36,7,{"$f":"IF($G38<>\"\",INDEX(B$3:B$51,$G38),NA())","v":"Hartford (Connecticut)"},{"$f":"IF($G38<>\"\",INDEX(C$3:C$51,$G38),NA())","v":90.09398496240604},{"$f":"IF($G38<>\"\",INDEX(D$3:D$51,$G38),NA())","v":61.385542168674704},null,{"$f":"IF(AND(ISNUMBER(I38:J39)),SQRT((I38-I39)^2+(J38-J39)^2),\"\")","v":2.2317540773661206},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,197]
[37,"Harrisburg (Pennsylvania)",82.988721804511272,56.072289156626503,null,37,38,{"$f":"IF($G39<>\"\",INDEX(B$3:B$51,$G39),NA())","v":"Providence (Rhode Island)"},{"$f":"IF($G39<>\"\",INDEX(C$3:C$51,$G39),NA())","v":92.293233082706763},{"$f":"IF($G39<>\"\",INDEX(D$3:D$51,$G39),NA())","v":61.765060240963813},null,{"$f":"IF(AND(ISNUMBER(I39:J40)),SQRT((I39-I40)^2+(J39-J40)^2),\"\")","v":2.332980528913088},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,176]
[38,"Providence (Rhode Island)",92.293233082706763,61.765060240963813,null,38,20,{"$f":"IF($G40<>\"\",INDEX(B$3:B$51,$G40),NA())","v":"Boston (Massachusetts)"},{"$f":"IF($G40<>\"\",INDEX(C$3:C$51,$G40),NA())","v":92.800751879699263},{"$f":"IF($G40<>\"\",INDEX(D$3:D$51,$G40),NA())","v":64.042168674698772},null,{"$f":"IF(AND(ISNUMBER(I40:J41)),SQRT((I40-I41)^2+(J40-J41)^2),\"\")","v":3.1517710777047752},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,199]
[39,"Columbia (South Carolina)",76.05263157894737,32.162650602409613,null,39,28,{"$f":"IF($G41<>\"\",INDEX(B$3:B$51,$G41),NA())","v":"Concord (New Hampshire)"},{"$f":"IF($G41<>\"\",INDEX(C$3:C$51,$G41),NA())","v":91.95488721804513},{"$f":"IF($G41<>\"\",INDEX(D$3:D$51,$G41),NA())","v":67.078313253012041},null,{"$f":"IF(AND(ISNUMBER(I41:J42)),SQRT((I41-I42)^2+(J41-J42)^2),\"\")","v":5.1672838015061666},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173,108]
[40,"Pierre (South Dakota)",43.402255639097774,71.632530120481931,null,40,18,{"$f":"IF($G42<>\"\",INDEX(B$3:B$51,$G42),NA())","v":"Augusta (Maine)"},{"$f":"IF($G42<>\"\",INDEX(C$3:C$51,$G42),NA())","v":95},{"$f":"IF($G42<>\"\",INDEX(D$3:D$51,$G42),NA())","v":71.25301204819273},null,{"$f":"IF(AND(ISNUMBER(I42:J43)),SQRT((I42-I43)^2+(J42-J43)^2),\"\")","v":4.7368421052631362},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,185,129]
[41,"Nashville (Tennessee)",66.071428571428584,40.512048192771076,null,41,44,{"$f":"IF($G43<>\"\",INDEX(B$3:B$51,$G43),NA())","v":"Montpelier (Vermont)"},{"$f":"IF($G43<>\"\",INDEX(C$3:C$51,$G43),NA())","v":90.263157894736864},{"$f":"IF($G43<>\"\",INDEX(D$3:D$51,$G43),NA())","v":71.25301204819273},null,{"$f":"IF(AND(ISNUMBER(I43:J44)),SQRT((I43-I44)^2+(J43-J44)^2),\"\")","v":6.7148174751165612},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,36]
[42,"Austin (Texas)",47.800751879699241,18.5,null,42,31,{"$f":"IF($G44<>\"\",INDEX(B$3:B$51,$G44),NA())","v":"Albany (New York)"},{"$f":"IF($G44<>\"\",INDEX(C$3:C$51,$G44),NA())","v":88.402255639097731},{"$f":"IF($G44<>\"\",INDEX(D$3:D$51,$G44),NA())","v":64.801204819277103},null,{"$f":"IF(AND(ISNUMBER(I44:J45)),SQRT((I44-I45)^2+(J44-J45)^2),\"\")","v":18.27461793693357},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,193,159]
[43,"Salt Lake City (Utah)",23.778195488721813,57.969879518072275,null,43,21,{"$f":"IF($G45<>\"\",INDEX(B$3:B$51,$G45),NA())","v":"Lansing (Michigan)"},{"$f":"IF($G45<>\"\",INDEX(C$3:C$51,$G45),NA())","v":70.131578947368439},{"$f":"IF($G45<>\"\",INDEX(D$3:D$51,$G45),NA())","v":65.180722891566234},null,{"$f":"IF(AND(ISNUMBER(I45:J46)),SQRT((I45-I46)^2+(J45-J46)^2),\"\")","v":8.3672982297732013},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,75]
[44,"Montpelier (Vermont)",90.263157894736864,71.25301204819273,null,44,47,{"$f":"IF($G46<>\"\",INDEX(B$3:B$51,$G46),NA())","v":"Madison (Wisconsin)"},{"$f":"IF($G46<>\"\",INDEX(C$3:C$51,$G46),NA())","v":61.842105263157904},{"$f":"IF($G46<>\"\",INDEX(D$3:D$51,$G46),NA())","v":66.319277108433738},null,{"$f":"IF(AND(ISNUMBER(I46:J47)),SQRT((I46-I47)^2+(J46-J47)^2),\"\")","v":9.8383767163272342},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,67]
[45,"Richmond (Virginia)",81.973684210526329,45.44578313253011,null,45,22,{"$f":"IF($G47<>\"\",INDEX(B$3:B$51,$G47),NA())","v":"St. Paul (Minnesota)"},{"$f":"IF($G47<>\"\",INDEX(C$3:C$51,$G47),NA())","v":55.582706766917305},{"$f":"IF($G47<>\"\",INDEX(D$3:D$51,$G47),NA())","v":73.909638554216855},null,{"$f":"IF(AND(ISNUMBER(I47:J48)),SQRT((I47-I48)^2+(J47-J48)^2),\"\")","v":14.888961186199451},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,132]
[46,"Charleston (West Virginia)",75.037593984962442,48.861445783132538,null,46,33,{"$f":"IF($G48<>\"\",INDEX(B$3:B$51,$G48),NA())","v":"Bismarck (North Dakota)"},{"$f":"IF($G48<>\"\",INDEX(C$3:C$51,$G48),NA())","v":42.556390977443613},{"$f":"IF($G48<>\"\",INDEX(D$3:D$51,$G48),NA())","v":81.120481927710841},null,{"$f":"IF(AND(ISNUMBER(I48:J49)),SQRT((I48-I49)^2+(J48-J49)^2),\"\")","v":9.5255822143391136},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,7]
[47,"Madison (Wisconsin)",61.842105263157904,66.319277108433738,null,47,40,{"$f":"IF($G49<>\"\",INDEX(B$3:B$51,$G49),NA())","v":"Pierre (South Dakota)"},{"$f":"IF($G49<>\"\",INDEX(C$3:C$51,$G49),NA())","v":43.402255639097774},{"$f":"IF($G49<>\"\",INDEX(D$3:D$51,$G49),NA())","v":71.632530120481931},null,{"$f":"IF(AND(ISNUMBER(I49:J50)),SQRT((I49-I50)^2+(J49-J50)^2),\"\")","v":14.656310564634154},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,171]
[48,"Cheyenne (Wyoming)",35.789473684210549,59.108433734939773,null,48,48,{"$f":"IF($G50<>\"\",INDEX(B$3:B$51,$G50),NA())","v":"Cheyenne (Wyoming)"},{"$f":"IF($G50<>\"\",INDEX(C$3:C$51,$G50),NA())","v":35.789473684210549},{"$f":"IF($G50<>\"\",INDEX(D$3:D$51,$G50),NA())","v":59.108433734939773},null,{"$f":"IF(AND(ISNUMBER(I50:J51)),SQRT((I50-I51)^2+(J50-J51)^2),\"\")","v":38.070643934050779},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,191,61]
[null,null,null,null,null,null,1,{"$f":"IF($G51<>\"\",INDEX(B$3:B$51,$G51),NA())","v":"Olympia (Washington)"},{"$f":"IF($G51<>\"\",INDEX(C$3:C$51,$G51),NA())","v":5},{"$f":"IF($G51<>\"\",INDEX(D$3:D$51,$G51),NA())","v":81.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,197,112]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L$3:L51)","v":494.07336358498952},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]