PathTest

tag

Entity
Header
Footer
Document
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://earth.google.com/kml/2.1">
<Document>
</Document>
</kml>
Point
<Placemark>
 <Point>
  <coordinates> 
</coordinates>
 </Point>
</Placemark>
Line
<Placemark>
 <LineString>
  <coordinates>
</coordinates>
 </LineString>
</Placemark>
Polygon
<Placemark>
 <Polygon>
  <outerBoundaryIs>
   <LinearRing>
    <coordinates>
</coordinates>
</LinearRing>
</outerBoundaryIs>
</Polygon>
</Placemark>
KML
<?xml version="1.0" encoding="UTF-8"?> <kml xmlns="http://earth.google.com/kml/2.2"> <Document>  <name>KmlFile</name>  <Style id="sn_ylw-pushpin">   <IconStyle>    <scale>1.1</scale>    <Icon>     <href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href>    </Icon>    <hotSpot x="20" y="2" xunits="pixels" yunits="pixels"/>   </IconStyle>   <LineStyle>    <color>fff700ff</color>    <width>3.1</width>   </LineStyle>  </Style>  <StyleMap id="msn_ylw-pushpin">   <Pair>    <key>normal</key>    <styleUrl>#sn_ylw-pushpin</styleUrl>   </Pair>   <Pair>    <key>highlight</key>    <styleUrl>#sh_ylw-pushpin</styleUrl>   </Pair>  </StyleMap>  <Style id="sh_ylw-pushpin">   <IconStyle>    <scale>1.3</scale>    <Icon>     <href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href>    </Icon>    <hotSpot x="20" y="2" xunits="pixels" yunits="pixels"/>   </IconStyle>   <LineStyle>    <color>fff700ff</color>    <width>3.1</width>   </LineStyle>  </Style>  <Placemark>   <name>Radtour 01.07.2008</name>   <styleUrl>#msn_ylw-pushpin</styleUrl>   <LineString>    <tessellate>1</tessellate>    <coordinates> 10.66644576149434,53.86228656289354,0 10.66727147988793,53.86173877435738,0 10.66937327524646,53.8628141702595,0 10.67305777555254,53.86092680106309,0 10.67329453439572,53.86141497948177,0 10.6762157643762,53.85816771073371,0 10.67799287905545,53.85725370285766,0 10.68075297529465,53.85654223712855,0 10.68266011304817,53.85076114928572,0 10.68419473605418,53.84625094900549,0 10.68604840609594,53.84028967354818,0 10.68804464373461,53.83480189043491,0 10.68890950766321,53.83247988645034,0 10.69783790617977,53.83533479202894,0 10.69959699820998,53.83539519711906,0 10.70206875675402,53.83501898503383,0 10.70404472977025,53.83504725039013,0 10.70494172179806,53.83385597855619,0 10.7055575338876,53.83355376501556,0 10.70746883162518,53.83387087258604,0 10.70935719346315,53.83439823793937,0 10.7109005016155,53.8334810531918,0 10.71451102686494,53.83457681508829,0 10.71642113767473,53.83285218024529,0 10.72003299769419,53.82680339164641,0 10.72212406695277,53.8232374697924,0 10.72238326960141,53.82300960539141,0 10.72725596736363,53.82032452642492,0 10.7316522934989,53.81807982632198,0 10.73786840702932,53.81496504224964,0 10.7416322699695,53.81294487487787,0 10.74536225630537,53.81072615181071,0 10.74776209084686,53.80929223816265,0 10.74853467475251,53.80780837853817,0 10.74975600138755,53.80628647332493,0 10.75010569455829,53.80463158188934,0 10.75032516910876,53.80207671690731,0 10.75060749804649,53.80076366314941,0 10.75153151551241,53.79979382683446,0 10.75275781239797,53.79912859912571,0 10.7537142328818,53.79865401932776,0 10.75461803915714,53.79762278939369,0 10.75599444679175,53.7950527446862,0 10.7563002037151,53.79396902839812,0 10.75695517095878,53.79280010542106,0 10.75703153514668,53.79097510068159,0 10.75668355334281,53.78916014703234,0 10.75626866516156,53.78742409148801,0 10.76369372336906,53.78429187420654,0 10.76607337673779,53.7832759020699,0 10.76773351849077,53.78233816841907,0 10.76824681539158,53.78155928804063,0 10.76926581378892,53.77933785920565,0 10.77008291357212,53.77803651928086,0 10.77102321667549,53.77677013508271,0 10.77101459446565,53.77542994850902,0 10.7705508181856,53.77440908593618,0 10.76998230422124,53.77331647422687,0 10.76984321603616,53.77256993160595,0 10.77003951991057,53.77215017115866,0 10.76907402246843,53.77166250153432,0 10.76850023196288,53.77081166754118,0 10.76871132895198,53.7696058729344,0 10.76879600030102,53.76873562595578,0 10.76903508927441,53.76840396227035,0 10.76950261316479,53.76749356111693,0 10.76967241559339,53.76679348856921,0 10.76955460388089,53.76594818146395,0 10.76917207806966,53.76489059497613,0 10.76885312450676,53.76398184420122,0 10.76827057627966,53.76337514683843,0 10.76761066031636,53.76272321050528,0 10.76724287356444,53.76171621725916,0 10.76674775760956,53.76103557336936,0 10.76562904892,53.76002847104695,0 10.76406358764989,53.75839676196789,0 10.76327429989186,53.75722817849218,0 10.76266652327125,53.75673380465541,0 10.76199398871239,53.75622355922069,0 10.76138148034046,53.75520838584669,0 10.76122745448447,53.75454968274425,0 10.76089184889473,53.75347441311587,0 10.76066050505439,53.75282360751775,0 10.7606873977182,53.75185918956841,0 10.76019219832368,53.75114050206209,0 10.75951298889753,53.75008058570535,0 10.75942280175735,53.7496449664751,0 10.75946980451177,53.74884678527884,0 10.7594918134285,53.74840282419342,0 10.75906902917907,53.74793516655185,0 10.75890151602823,53.74764803250665,0 10.75902595485181,53.74726925059299,0 10.75947269217002,53.74685665050531,0 10.76007159284838,53.74656482292025,0 10.76072061112089,53.74630368660032,0 10.76234271698274,53.74484608218566,0 10.76323135871296,53.74419662183657,0 10.76400406193117,53.74371732385626,0 10.76443260506139,53.74346718978005,0 10.7642050496633,53.7433739096486,0 10.76425542299347,53.74281860730341,0 10.7644590710306,53.74167425623278,0 10.76448848410953,53.74056830131155,0 10.76484488427214,53.73994882091392,0 10.76548911808169,53.73889754879509,0 10.76629297278311,53.73815571143695,0 10.76726602237301,53.73750672642544,0 10.76740287168616,53.7370469978081,0 10.76631045233785,53.73698735289302,0 10.7660474932335,53.73649073163371,0 10.76611503460759,53.73597845034839,0 10.76635212965479,53.73530255351595,0 10.7668936471878,53.73447802462871,0 10.76686934064057,53.73340435786595,0 10.76719213799414,53.73246812124061,0 10.7671745790249,53.73176161772503,0 10.76714452577201,53.7305528369406,0 10.76723418537465,53.72928673669013,0 10.7672082179167,53.72907345203345,0 10.76730981474979,53.72841346998614,0 10.76753031299678,53.72807810587302,0 10.76782724970856,53.72782414909843,0 10.7679566843333,53.72766532829857,0 10.76981885086153,53.72744863202455,0 10.76964497420047,53.72712600385637,0 10.76914914950208,53.72656153595525,0 10.76918162629248,53.72625023032332,0 10.76946210107796,53.72587693426293,0 10.77004161272411,53.72480945486382,0 10.7696670490855,53.72428401940802,0 10.76910342983656,53.72401652948719,0 10.76823053273205,53.72359049511125,0 10.76779399642597,53.72314078189591,0 10.76781033630891,53.7227524429274,0 10.76820955039851,53.72214859010509,0 10.7683196064412,53.72191730775199,0 10.7682971693808,53.72133137587047,0 10.76801667498721,53.72036544642098,0 10.76779490482809,53.71975428212251,0 10.76729693714739,53.71870967185317,0 10.76675849040436,53.71739133470947,0 10.76681180204923,53.71677061012864,0 10.76719186569086,53.71639415196857,0 10.76706595638883,53.71590910442749,0 10.76745012488342,53.71442383525208,0 10.76771443020888,53.71392857867755,0 10.76781215238975,53.71349520228251,0 10.76856557613358,53.7127747470316,0 10.76929316044517,53.7121476552917,0 10.76957306701708,53.71200093662553,0 10.77005735571758,53.71171079791455,0 10.76947244158565,53.71108510086527,0 10.76898815063252,53.71037857843123,0 10.76883552850779,53.70982019140099,0 10.76842418849162,53.70945260318444,0 10.76887581640813,53.70895389297583,0 10.77047251492084,53.70878215422182,0 10.77282929942484,53.70910551586845,0 10.77473318917507,53.70966391355768,0 10.77646307393695,53.71026638887826,0 10.77699682495691,53.71045705131444,0 10.77809191483891,53.71030409423224,0 10.78030566069513,53.70976787971593,0 10.78191301238039,53.70938915136298,0 10.78149669706671,53.70894455115272,0 10.78142525989809,53.70855790925763,0 10.78148882996237,53.70831229220252,0 10.78297607993292,53.70788985246713,0 10.78479893258135,53.70735631290862,0 10.7864484723459,53.7070408835766,0 10.78722206923653,53.70642106264502,0 10.78788047696578,53.70546429071598,0 10.78863043831842,53.70429586599396,0 10.78894580975803,53.70249928033628,0 10.78968804315122,53.70094174495949,0 10.79009978524741,53.69858666763987,0 10.79051023092431,53.69589768033249,0 10.78278199728106,53.69763987135327,0 10.77726377951213,53.69898162455528,0 10.77420833610857,53.69924445209237,0 10.77353851284056,53.69900233775457,0 10.7709741850318,53.69914127985459,0 10.76789792497721,53.6992552198841,0 10.76645196082941,53.69888422439367,0 10.76458272233029,53.69913018393945,0 10.76177753983249,53.69943209752778,0 10.76061515429805,53.69943598823117,0 10.75774076808098,53.69966695163904,0 10.75562855972886,53.70058437918838,0 10.75362025572076,53.70202162248202,0 10.75169872905174,53.7039312629734,0 10.75032724031185,53.70528468959358,0 10.75047896566565,53.70601173838018,0 10.74948348019664,53.70669514336857,0 10.7472941614477,53.7083290720323,0 10.74593042277088,53.71033055344965,0 10.74437377513439,53.71127764812947,0 10.74307731128279,53.71244433553778,0 10.74220469246593,53.7135675964495,0 10.7421969176536,53.71444087669256,0 10.74351577262208,53.71575188821223,0 10.7428264030388,53.71706398664201,0 10.74290047278643,53.71810473214273,0 10.7439188902234,53.71846719229719,0 10.74325788422361,53.7194582884433,0 10.74262243661833,53.72023447586628,0 10.7423824318483,53.72086871766427,0 10.74258748706141,53.72219829396601,0 10.7433687631251,53.72312275109149,0 10.74322524981207,53.72374658422184,0 10.74343987579758,53.72486849933301,0 10.74313094754093,53.72591580383128,0 10.74329854079903,53.72644124014687,0 10.74413592056341,53.72706892744394,0 10.74511704307251,53.72747805238354,0 10.74574051797421,53.72808757823773,0 10.74698749348887,53.72869694627914,0 10.74730208832143,53.72973297596,0 10.74768656048421,53.73035732138293,0 10.7476645860078,53.73136440836354,0 10.74835979446308,53.73193410334896,0 10.74833672678899,53.73255890805896,0 10.74920121646994,53.73303097132995,0 10.74821881094906,53.73428065705472,0 10.74750127877542,53.73568655952612,0 10.7469027432482,53.73686553793501,0 10.74556110491841,53.7378872382201,0 10.74412983879169,53.73854829045005,0 10.74194343801386,53.73906387961394,0 10.73997395008409,53.73962008735573,0 10.73920571426248,53.73980721330163,0 10.73809751937171,53.74077203834501,0 10.73744610770964,53.74162468890751,0 10.73672183008328,53.74246416113682,0 10.73551703537612,53.74269258046444,0 10.73390961994087,53.74348924981462,0 10.73316537150387,53.74464152745469,0 10.73359525569116,53.74618681600258,0 10.73349881895037,53.74731060442389,0 10.73335493962793,53.74790825173856,0 10.73258389179466,53.74826447714782,0 10.73178926169815,53.74872036708568,0 10.7313627894421,53.74950168469896,0 10.731149275932,53.74987074659319,0 10.73122148918306,53.7500555948533,0 10.73093482664935,53.75035371272847,0 10.73072224717797,53.75146134342464,0 10.73110523066944,53.75213013729098,0 10.73160900876825,53.75279857541085,0 10.73149160317858,53.75330970723127,0 10.73187561510494,53.75447614498171,0 10.73187647735348,53.75530079844945,0 10.73163768000522,53.7557693306107,0 10.73206942727896,53.75661578717429,0 10.73242973099495,53.75701402153284,0 10.7324783130924,53.7574548779838,0 10.73331973606059,53.75829434258696,0 10.73327298585478,53.75896256574777,0 10.73296140518983,53.75928930400586,0 10.73317826576,53.75961631724711,0 10.73301295021474,53.76018340854836,0 10.73344711175244,53.76105007254115,0 10.73383311717367,53.76154672652447,0 10.73373701282308,53.76194516942445,0 10.73503910259059,53.76263680615598,0 10.73525654553539,53.76314814981129,0 10.73595341415316,53.76385817569664,0 10.73633802792199,53.76424172122705,0 10.73617024633199,53.76469648710657,0 10.73617076899228,53.76493792286357,0 10.73653054592309,53.765279540337,0 10.73633732984482,53.76565015107773,0 10.73708148881602,53.76662064266598,0 10.73758974522501,53.76761399666769,0 10.7379515135174,53.76796857315581,0 10.73884248862535,53.76858149243777,0 10.73951715382,53.76910620965844,0 10.73987862424379,53.76944787870759,0 10.74019832741352,53.77113058272023,0 10.74178844640039,53.77205431014691,0 10.74321053652545,53.77290726460237,0 10.74374084548741,53.77313473581482,0 10.74473016308237,53.77445853941926,0 10.74518876174885,53.77514157152186,0 10.74477934705023,53.7755401456774,0 10.74620482758658,53.77619566204493,0 10.74718913851056,53.77613690762411,0 10.74786722369365,53.77642225275728,0 10.74827783551663,53.77674978742303,0 10.74918866787948,53.77689002207017,0 10.7503517275794,53.77789945584581,0 10.75232273225073,53.77819612830059,0 10.75422380555783,53.77860667673546,0 10.7550668562681,53.77857744533117,0 10.75562096186823,53.77824962430039,0 10.75678204947778,53.77850408715837,0 10.75885211442349,53.77937177258966,0 10.76022404062272,53.78005395813121,0 10.76114310947386,53.78090764704164,0 10.76222725455266,53.78164684442282,0 10.76406028332207,53.78148964527466,0 10.76579900986235,53.78096244697748,0 10.76625701843304,53.78099063133917,0 10.76667548725476,53.78227338981497,0 10.76670057197123,53.78277204431677,0 10.76675770628141,53.78300951304407,0 10.76399782177693,53.78419809656059,0 10.76259976431082,53.78478880343236,0 10.7614313051302,53.78535326083412,0 10.76193737350442,53.78578343972271,0 10.76321732817526,53.78602886934627,0 10.76425172919268,53.78639778982374,0 10.76520879495453,53.78612409694856,0 10.76575364699434,53.78631455335579,0 10.76649727374966,53.78828688544571,0 10.76682298686713,53.78900017071325,0 10.76757901386425,53.78897765404852,0 10.76822931126208,53.78911173711273,0 10.76821320862339,53.78948072422374,0 10.76824543229786,53.78964321159699,0 10.76859424099391,53.78977673193538,0 10.76927989704815,53.78990370782591,0 10.76978985906821,53.79035256252632,0 10.77070323033502,53.79072874718517,0 10.76973587165158,53.79125004387282,0 10.76876232967614,53.79170741374366,0 10.7682097183981,53.79222440895049,0 10.7665678094869,53.79200255283256,0 10.76594267141213,53.79321886323262,0 10.76349114476817,53.79300342207635,0 10.76274755913408,53.79490317612344,0 10.76297510053368,53.79529709482655,0 10.76061420628798,53.79587350801938,0 10.76009078001829,53.79608766012484,0 10.75992053859422,53.79764656433598,0 10.75968053375001,53.79763883510921,0 10.75924323977314,53.79897014184842,0 10.75944348969028,53.79902520308071,0 10.75914209432078,53.8006547967433,0 10.75823275595405,53.80060783911331,0 10.75863560847834,53.80122440141889,0 10.75889098625859,53.80208537599741,0 10.75908245658802,53.80442036870588,0 10.7591092544771,53.80563278971818,0 10.75920650782123,53.80730356644696,0 10.75911138713377,53.80797160276843,0 10.7590056754012,53.80935385541972,0 10.75887964939928,53.8099373128448,0 10.75917649871236,53.8101954821654,0 10.75988255917871,53.81035340681599,0 10.76053337368811,53.81048641525756,0 10.76049813538857,53.81221935321032,0 10.75976829149508,53.8132800939728,0 10.75868139060204,53.81467616707109,0 10.75819472207088,53.81549339274653,0 10.7579670045895,53.81681446994811,0 10.75839809543297,53.81722802345672,0 10.75890759681917,53.8175843639409,0 10.75719621110747,53.81878050310796,0 10.75643425006504,53.81935769868277,0 10.75564543185536,53.81929302943517,0 10.75457989007916,53.81898096825595,0 10.75219390943842,53.81880544812851,0 10.75193109625909,53.8196310134775,0 10.75308275061352,53.82060329273023,0 10.75484031964051,53.82157153199311,0 10.75747868267847,53.82307531161994,0 10.75666558500141,53.82419711321099,0 10.75627045114587,53.82436438347103,0 10.75329552088644,53.82429594437934,0 10.75065795009169,53.82414724277807,0 10.75009340363927,53.82401752159696,0 10.74952705261444,53.82427707240659,0 10.7473460919871,53.82343746820085,0 10.74699338983486,53.82313802807463,0 10.74690945793665,53.82265569428782,0 10.74606209620498,53.82285914938815,0 10.74484096700395,53.823813976606,0 10.74360742869148,53.82462676758662,0 10.74237593798703,53.8256954669485,0 10.74219394726173,53.82610148762802,0 10.74187224546752,53.8268801950027,0 10.74135417421458,53.82763286467466,0 10.73997069033065,53.82812610569229,0 10.73856271922332,53.82869343604712,0 10.73764978535202,53.82957249095459,0 10.73733395076077,53.82989435052175,0 10.73757377115722,53.83061216873957,0 10.73777207815424,53.83112222927909,0 10.73693954584657,53.83140118921605,0 10.73693478586759,53.83197368721508,0 10.73591777090202,53.83236563560109,0 10.73531140902281,53.83288138173882,0 10.73407123507421,53.83343954090321,0 10.73384660693131,53.83368011167048,0 10.73329492913467,53.8337035979417,0 10.73267504591952,53.83381183125304,0 10.73177449533982,53.83423555583902,0 10.73097242688083,53.83470146880555,0 10.73030914538246,53.83473603689141,0 10.72890942516982,53.83482980827223,0 10.72836024699019,53.83472127839706,0 10.72735279583327,53.83471133825186,0 10.72578833539158,53.8347130748844,0 10.7247928517006,53.83489530397127,0 10.72266828002704,53.83540257554015,0 10.72186537049002,53.83591071105267,0 10.72077714491024,53.83579460545433,0 10.71881223256332,53.83608713478838,0 10.71788330441709,53.83633689617182,0 10.71709734484101,53.83666935801148,0 10.71671964601924,53.83775198469612,0 10.71884625577653,53.83790917597344,0 10.72008427553919,53.83838997129,0 10.72165606304648,53.8396717157892,0 10.72267022820591,53.84039188255876,0 10.72276386213508,53.84113530478844,0 10.72278201015565,53.84136943283273,0 10.7216338146491,53.84153405912912,0 10.72031954698082,53.84169081942787,0 10.71919573057042,53.84185236916647,0 10.7184326187177,53.84179549600076,0 10.71820673563236,53.84154824754822,0 10.71718590986096,53.84177678811914,0 10.71549864512305,53.84149603640823,0 10.71427129570775,53.84138086201855,0 10.7137877053688,53.84118970581529,0 10.71279246025661,53.84086929595015,0 10.71199318288413,53.84055648026744,0 10.71043125678459,53.84048633049007,0 10.71040353522037,53.84117833564044,0 10.70833512983904,53.84113194889625,0 10.70848968156642,53.84033445272505,0 10.70901819233144,53.8394568488613,0 10.70767639436923,53.8390338496142,0 10.70633810464349,53.83861409575583,0 10.70417633984036,53.83828134664835,0 10.7031675077844,53.83807558091492,0 10.70150169643391,53.83755342866252,0 10.7007741863903,53.83744624952956,0 10.70010154592232,53.83747791311112,0 10.69963490527205,53.83760418772795,0 10.6983624400558,53.83701104437137,0 10.6978813249054,53.83733281962235,0 10.69784942112138,53.83769870383995,0 10.69596970727676,53.83821479412841,0 10.69559618027098,53.8381328045805,0 10.69493465470967,53.83801301188605,0 10.69448703076962,53.83783021160264,0 10.69360791845597,53.83791297305368,0 10.69356557970063,53.83802635626259,0 10.68907771014237,53.83747798966972,0 10.68850315587369,53.8379421713425,0 10.68780808568057,53.83840824133824,0 10.68679054621124,53.83857845238845,0 10.68569559515042,53.84145660415474,0 10.68487548769508,53.84376011587896,0 10.68392118927213,53.84662993710992,0 10.68277537916289,53.85010655461267,0 10.6823158956157,53.85199830363926,0 10.68139790141835,53.85434433520799,0 10.68104594350415,53.85576612793033,0 10.680581334802,53.85652730022427,0 10.67838663436106,53.85713281180315,0 10.67709515004051,53.85766348170782,0 10.67587945636437,53.85866476457427,0 10.67515612936545,53.85973218234624,0 10.67371587877426,53.86130835651706,0 10.67312720741657,53.86147170319239,0 10.6731406721359,53.86092615297927,0 10.67077534518053,53.86199959377616,0 10.66908009066901,53.8627458408385,0 10.66731663459117,53.86188563982287,0 10.66661149859274,53.86228995353939,0 </coordinates>   </LineString>  </Placemark> </Document> </kml> 
</kml>
Folder
<Folder>
</Folder>

Sheet

length

<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://earth.google.com/kml/2.1">
<Document><Folder><name> Sum = 3984.293 km  2475.725 mi</name><Folder><name>Segment</name><Folder><name>1-2</name>=concatenate("<Placemark> <name>From ",A3," to ",A4,"</name> <description><![CDATA[Seg = ",round(F4,3)," km  ",round(F4*0.621371192,3)," mi<br>Sum = ",round(G4,3)," km  ",round(G4*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C3+C4)/2,",",(B3+B4)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D3:D4,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>2-3</name>=concatenate("<Placemark> <name>From ",A4," to ",A5,"</name> <description><![CDATA[Seg = ",round(F5,3)," km  ",round(F5*0.621371192,3)," mi<br>Sum = ",round(G5,3)," km  ",round(G5*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C4+C5)/2,",",(B4+B5)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D4:D5,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>3-4</name>=concatenate("<Placemark> <name>From ",A5," to ",A6,"</name> <description><![CDATA[Seg = ",round(F6,3)," km  ",round(F6*0.621371192,3)," mi<br>Sum = ",round(G6,3)," km  ",round(G6*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C5+C6)/2,",",(B5+B6)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D5:D6,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>4-5</name>=concatenate("<Placemark> <name>From ",A6," to ",A7,"</name> <description><![CDATA[Seg = ",round(F7,3)," km  ",round(F7*0.621371192,3)," mi<br>Sum = ",round(G7,3)," km  ",round(G7*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C6+C7)/2,",",(B6+B7)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D6:D7,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>5-6</name>=concatenate("<Placemark> <name>From ",A7," to ",A8,"</name> <description><![CDATA[Seg = ",round(F8,3)," km  ",round(F8*0.621371192,3)," mi<br>Sum = ",round(G8,3)," km  ",round(G8*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C7+C8)/2,",",(B7+B8)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D7:D8,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder></Folder><Folder><name>Base points</name><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>1</name> <Point>  <coordinates> -110.67,36.12,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>2</name> <Point>  <coordinates> -118.4,33.94,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>3</name> <Point>  <coordinates> -120.4,32.94,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>4</name> <Point>  <coordinates> -130.4,30.94,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>5</name> <Point>  <coordinates> -118.4,43.94,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>6</name> <Point>  <coordinates> -115.4,45,5000 </coordinates> </Point></Placemark></Folder></Folder></Document>
</kml>
R km
6372.795
Point
F atitude
L longitude
Concat
Points
Great-circle distance (km)
Sum length
Place
Line
Group
Result
1
36.12
-110.67
-110.67,36.12,5000 
<Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>1</name> <Point>  <coordinates> -110.67,36.12,5000 </coordinates> </Point></Placemark>
0
0
<Folder><name>Segment</name><Folder><name>1-2</name>=concatenate("<Placemark> <name>From ",A3," to ",A4,"</name> <description><![CDATA[Seg = ",round(F4,3)," km  ",round(F4*0.621371192,3)," mi<br>Sum = ",round(G4,3)," km  ",round(G4*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C3+C4)/2,",",(B3+B4)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D3:D4,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>2-3</name>=concatenate("<Placemark> <name>From ",A4," to ",A5,"</name> <description><![CDATA[Seg = ",round(F5,3)," km  ",round(F5*0.621371192,3)," mi<br>Sum = ",round(G5,3)," km  ",round(G5*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C4+C5)/2,",",(B4+B5)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D4:D5,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>3-4</name>=concatenate("<Placemark> <name>From ",A5," to ",A6,"</name> <description><![CDATA[Seg = ",round(F6,3)," km  ",round(F6*0.621371192,3)," mi<br>Sum = ",round(G6,3)," km  ",round(G6*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C5+C6)/2,",",(B5+B6)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D5:D6,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>4-5</name>=concatenate("<Placemark> <name>From ",A6," to ",A7,"</name> <description><![CDATA[Seg = ",round(F7,3)," km  ",round(F7*0.621371192,3)," mi<br>Sum = ",round(G7,3)," km  ",round(G7*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C6+C7)/2,",",(B6+B7)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D6:D7,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>5-6</name>=concatenate("<Placemark> <name>From ",A7," to ",A8,"</name> <description><![CDATA[Seg = ",round(F8,3)," km  ",round(F8*0.621371192,3)," mi<br>Sum = ",round(G8,3)," km  ",round(G8*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C7+C8)/2,",",(B7+B8)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D7:D8,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder></Folder>
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://earth.google.com/kml/2.1">
<Document><Folder><name> Sum = 3984.293 km  2475.725 mi</name><Folder><name>Segment</name><Folder><name>1-2</name>=concatenate("<Placemark> <name>From ",A3," to ",A4,"</name> <description><![CDATA[Seg = ",round(F4,3)," km  ",round(F4*0.621371192,3)," mi<br>Sum = ",round(G4,3)," km  ",round(G4*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C3+C4)/2,",",(B3+B4)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D3:D4,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>2-3</name>=concatenate("<Placemark> <name>From ",A4," to ",A5,"</name> <description><![CDATA[Seg = ",round(F5,3)," km  ",round(F5*0.621371192,3)," mi<br>Sum = ",round(G5,3)," km  ",round(G5*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C4+C5)/2,",",(B4+B5)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D4:D5,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>3-4</name>=concatenate("<Placemark> <name>From ",A5," to ",A6,"</name> <description><![CDATA[Seg = ",round(F6,3)," km  ",round(F6*0.621371192,3)," mi<br>Sum = ",round(G6,3)," km  ",round(G6*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C5+C6)/2,",",(B5+B6)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D5:D6,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>4-5</name>=concatenate("<Placemark> <name>From ",A6," to ",A7,"</name> <description><![CDATA[Seg = ",round(F7,3)," km  ",round(F7*0.621371192,3)," mi<br>Sum = ",round(G7,3)," km  ",round(G7*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C6+C7)/2,",",(B6+B7)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D6:D7,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder><Folder><name>5-6</name>=concatenate("<Placemark> <name>From ",A7," to ",A8,"</name> <description><![CDATA[Seg = ",round(F8,3)," km  ",round(F8*0.621371192,3)," mi<br>Sum = ",round(G8,3)," km  ",round(G8*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C7+C8)/2,",",(B7+B8)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D7:D8,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder></Folder><Folder><name>Base points</name><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>1</name> <Point>  <coordinates> -110.67,36.12,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>2</name> <Point>  <coordinates> -118.4,33.94,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>3</name> <Point>  <coordinates> -120.4,32.94,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>4</name> <Point>  <coordinates> -130.4,30.94,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>5</name> <Point>  <coordinates> -118.4,43.94,5000 </coordinates> </Point></Placemark><Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>6</name> <Point>  <coordinates> -115.4,45,5000 </coordinates> </Point></Placemark></Folder></Folder></Document>
</kml>
2
33.94
-118.4
-118.4,33.94,5000 
<Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>2</name> <Point>  <coordinates> -118.4,33.94,5000 </coordinates> </Point></Placemark>
744.35039004384
744.35039004384
=concatenate("<Placemark> <name>From ",A3," to ",A4,"</name> <description><![CDATA[Seg = ",round(F4,3)," km  ",round(F4*0.621371192,3)," mi<br>Sum = ",round(G4,3)," km  ",round(G4*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C3+C4)/2,",",(B3+B4)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)
=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D3:D4,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)
<Folder><name>1-2</name>=concatenate("<Placemark> <name>From ",A3," to ",A4,"</name> <description><![CDATA[Seg = ",round(F4,3)," km  ",round(F4*0.621371192,3)," mi<br>Sum = ",round(G4,3)," km  ",round(G4*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C3+C4)/2,",",(B3+B4)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D3:D4,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder>
 
3
32.94
-120.4
-120.4,32.94,5000 
<Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>3</name> <Point>  <coordinates> -120.4,32.94,5000 </coordinates> </Point></Placemark>
216.393452146755
960.743842190595
=concatenate("<Placemark> <name>From ",A4," to ",A5,"</name> <description><![CDATA[Seg = ",round(F5,3)," km  ",round(F5*0.621371192,3)," mi<br>Sum = ",round(G5,3)," km  ",round(G5*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C4+C5)/2,",",(B4+B5)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)
=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D4:D5,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)
<Folder><name>2-3</name>=concatenate("<Placemark> <name>From ",A4," to ",A5,"</name> <description><![CDATA[Seg = ",round(F5,3)," km  ",round(F5*0.621371192,3)," mi<br>Sum = ",round(G5,3)," km  ",round(G5*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C4+C5)/2,",",(B4+B5)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D4:D5,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder>
4
30.94
-130.4
-130.4,30.94,5000 
<Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>4</name> <Point>  <coordinates> -130.4,30.94,5000 </coordinates> </Point></Placemark>
969.300445216304
1930.0442874069
=concatenate("<Placemark> <name>From ",A5," to ",A6,"</name> <description><![CDATA[Seg = ",round(F6,3)," km  ",round(F6*0.621371192,3)," mi<br>Sum = ",round(G6,3)," km  ",round(G6*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C5+C6)/2,",",(B5+B6)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)
=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D5:D6,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)
<Folder><name>3-4</name>=concatenate("<Placemark> <name>From ",A5," to ",A6,"</name> <description><![CDATA[Seg = ",round(F6,3)," km  ",round(F6*0.621371192,3)," mi<br>Sum = ",round(G6,3)," km  ",round(G6*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C5+C6)/2,",",(B5+B6)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D5:D6,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder>
5
43.94
-118.4
-118.4,43.94,5000 
<Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>5</name> <Point>  <coordinates> -118.4,43.94,5000 </coordinates> </Point></Placemark>
1788.56420403448
3718.60849144137
=concatenate("<Placemark> <name>From ",A6," to ",A7,"</name> <description><![CDATA[Seg = ",round(F7,3)," km  ",round(F7*0.621371192,3)," mi<br>Sum = ",round(G7,3)," km  ",round(G7*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C6+C7)/2,",",(B6+B7)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)
=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D6:D7,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)
<Folder><name>4-5</name>=concatenate("<Placemark> <name>From ",A6," to ",A7,"</name> <description><![CDATA[Seg = ",round(F7,3)," km  ",round(F7*0.621371192,3)," mi<br>Sum = ",round(G7,3)," km  ",round(G7*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C6+C7)/2,",",(B6+B7)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D6:D7,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder>
6
45
-115.4
-115.4,45,5000 
<Placemark>  <Style>  <IconStyle>   <Icon>    <href>root://icons/palette-2.png</href>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle> </Style><name>6</name> <Point>  <coordinates> -115.4,45,5000 </coordinates> </Point></Placemark>
265.684693872607
3984.29318531398
=concatenate("<Placemark> <name>From ",A7," to ",A8,"</name> <description><![CDATA[Seg = ",round(F8,3)," km  ",round(F8*0.621371192,3)," mi<br>Sum = ",round(G8,3)," km  ",round(G8*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C7+C8)/2,",",(B7+B8)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)
=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D7:D8,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)
<Folder><name>5-6</name>=concatenate("<Placemark> <name>From ",A7," to ",A8,"</name> <description><![CDATA[Seg = ",round(F8,3)," km  ",round(F8*0.621371192,3)," mi<br>Sum = ",round(G8,3)," km  ",round(G8*0.621371192,3)," mi ]]></description><Style>  <IconStyle>   <scale>0.7</scale>   <Icon>    <href>root://icons/palette-3.png</href>    <x>96</x>    <y>96</y>    <w>32</w>    <h>32</h>   </Icon>  </IconStyle>  <LabelStyle>   <scale>0.7</scale>  </LabelStyle> </Style> <Point> <coordinates> ",(C7+C8)/2,",",(B7+B8)/2,",5000 ",[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$3)=concatenate("<Placemark>  <LineString>  <tessellate>1</tessellate> <coordinates>",D7:D8,[file:///tmp/editgrid_exp_foZnqF.xls]tag!$C$4)</Folder>
pakistan