{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Plan_Hydranten","Plan_Wasserbezug","Set-Up"],"not_rendered":{"charts":0,"images":2,"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":"Plan_Hydranten","index":0,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Name","Farbe","Adresse","Kommentar","Bild_1","Bild_2","Type","IconScale","longitude (Länge)","latitude (Breite)","Leerspalte","BeschreibungText","Beschreibung","Icon","Koordinaten"]
["Unbekannt","ff0000ff","Hengstacker. 2","Neuer Stao!","xx1_Pic_1.jpg",null,"Neu",null,8.8905316130868108,47.1911812331427,null,{"$f":"CONCATENATE(C2,IF(D2<>\"\",CONCATENATE(\" \",D2),\"\"))","v":"Hengstacker. 2 Neuer Stao!"},{"$f":"CONCATENATE(L2,IF(E2<>\"\",IF(F2<>\"\",CONCATENATE(L2,'Set-Up'!$C$7,E2,'Set-Up'!$C$8,F2,'Set-Up'!$C$9),CONCATENATE('Set-Up'!$C$4,E2,'Set-Up'!$C$5)),\"\"))","v":"Hengstacker. 2 Neuer Stao!&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/xx1_Pic_1.jpg\" style=\"max-height:200px;\" /&gt;"},{"$f":"getIconURL(G2)","v":"http://www.fhoch3.peterliwiese.ch/icons/HyderantNeuKlein.png"},{"$f":"CONCATENATE(I2,\",\",J2)","v":"8.89053161308681,47.1911812331427"}]
["127 Tuggen","ff00ffff",null,null,"127_Pic_Tuggen_1.jpg",null,"Blau",null,8.9113699999999998,47.185409999999997,null,"",{"$f":"CONCATENATE(L3,IF(E3<>\"\",IF(F3<>\"\",CONCATENATE(L3,'Set-Up'!$C$7,E3,'Set-Up'!$C$8,F3,'Set-Up'!$C$9),CONCATENATE('Set-Up'!$C$4,E3,'Set-Up'!$C$5)),\"\"))","v":"&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/127_Pic_Tuggen_1.jpg\" style=\"max-height:200px;\" /&gt;"},{"$f":"getIconURL(G3)","v":"https://api3.geo.admin.ch/color/0,0,255/marker-24@2x.png"},{"$f":"CONCATENATE(I3,\",\",J3)","v":"8.91137,47.18541"}]
[12,"ff00ffff",null,"Steht 2m vom der Strasse entfernt in der Wiese","012_Pic_1.jpg",null,"Alt",null,8.8763773821061704,47.192785603448499,null," Steht 2m vom der Strasse entfernt in der Wiese",{"$f":"CONCATENATE(L4,IF(E4<>\"\",IF(F4<>\"\",CONCATENATE(L4,'Set-Up'!$C$7,E4,'Set-Up'!$C$8,F4,'Set-Up'!$C$9),CONCATENATE('Set-Up'!$C$4,E4,'Set-Up'!$C$5)),\"\"))","v":" Steht 2m vom der Strasse entfernt in der Wiese&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/012_Pic_1.jpg\" style=\"max-height:200px;\" /&gt;"},"http://www.fhoch3.peterliwiese.ch/icons/HyderantAltKlein.png","8.87637738210617,47.1927856034485"]
[13,"ff00ffff",null,"Angemalt","013_Pic_1.jpg",null,"Alt",null,8.8817299999999992,47.192520000000002,null," Angemalt",{"$f":"CONCATENATE(L5,IF(E5<>\"\",IF(F5<>\"\",CONCATENATE(L5,'Set-Up'!$C$7,E5,'Set-Up'!$C$8,F5,'Set-Up'!$C$9),CONCATENATE('Set-Up'!$C$4,E5,'Set-Up'!$C$5)),\"\"))","v":" Angemalt&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/013_Pic_1.jpg\" style=\"max-height:200px;\" /&gt;"},"http://www.fhoch3.peterliwiese.ch/icons/HyderantAltKlein.png","8.88173,47.19252"]
[17,"ff00ffff",null,"Mit 75er Abgang","017_Pic_1.jpg",null,"Alt",null,8.8795550132558603,47.195772320853301,null," Mit 75er Abgang",{"$f":"CONCATENATE(L6,IF(E6<>\"\",IF(F6<>\"\",CONCATENATE(L6,'Set-Up'!$C$7,E6,'Set-Up'!$C$8,F6,'Set-Up'!$C$9),CONCATENATE('Set-Up'!$C$4,E6,'Set-Up'!$C$5)),\"\"))","v":" Mit 75er Abgang&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/017_Pic_1.jpg\" style=\"max-height:200px;\" /&gt;"},"http://www.fhoch3.peterliwiese.ch/icons/HyderantAltKlein.png","8.87955501325586,47.1957723208533"]
[19,"ff00ffff",null,"In Hecke versteckt am Fusswegli","019_Pic_1.jpg","019_Pic_2.jpg","Alt",null,8.8857543416776199,47.195479531079698,null," In Hecke versteckt am Fusswegli",{"$f":"CONCATENATE(L7,IF(E7<>\"\",IF(F7<>\"\",CONCATENATE(L7,'Set-Up'!$C$7,E7,'Set-Up'!$C$8,F7,'Set-Up'!$C$9),CONCATENATE('Set-Up'!$C$4,E7,'Set-Up'!$C$5)),\"\"))","v":" In Hecke versteckt am Fusswegli In Hecke versteckt am Fusswegli&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/019_Pic_1.jpg \" style=\"max-height:200px;\" /&gt;&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/019_Pic_2.jpg\" style=\"max-height:200px;\" /&gt;"},"http://www.fhoch3.peterliwiese.ch/icons/HyderantAltKlein.png","8.88575434167762,47.1954795310797"]
[20,"ff00ffff",null,"Angemalt","020_Pic_1.jpg",null,"Alt",null,8.8878699999999995,47.194479999999999,null," Angemalt",{"$f":"CONCATENATE(L8,IF(E8<>\"\",IF(F8<>\"\",CONCATENATE(L8,'Set-Up'!$C$7,E8,'Set-Up'!$C$8,F8,'Set-Up'!$C$9),CONCATENATE('Set-Up'!$C$4,E8,'Set-Up'!$C$5)),\"\"))","v":" Angemalt&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/020_Pic_1.jpg\" style=\"max-height:200px;\" /&gt;"},"http://www.fhoch3.peterliwiese.ch/icons/HyderantAltKlein.png","8.88787,47.19448"]

{"sheet":"Plan_Wasserbezug","index":1,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Name","Farbe","Adresse","Kommentar","Bild_1","Bild_2","Type","IconScale","longitude (Länge)","latitude (Breite)","Leerspalte","BeschreibungText","Beschreibung","Icon","Koordinaten"]
["A","ff00ffff","KIBAG AG, Kieswerk","Ab See",null,null,"Wasserbezug","<scale>0.5</scale>",8.8917999999999999,47.205750000000002,null,{"$f":"CONCATENATE(C2,IF(D2<>\"\",CONCATENATE(\" \",D2),\"\"))","v":"KIBAG AG, Kieswerk Ab See"},{"$f":"CONCATENATE(L2,IF(E2<>\"\",IF(F2<>\"\",CONCATENATE(L2,'Set-Up'!$C$7,E2,'Set-Up'!$C$8,F2,'Set-Up'!$C$9),CONCATENATE('Set-Up'!$C$4,E2,'Set-Up'!$C$5)),\"\"))","v":"KIBAG AG, Kieswerk Ab See"},{"$f":"getIconURL(G2)","v":"https://api3.geo.admin.ch/color/0,255,0/marker-24@2x.png"},{"$f":"CONCATENATE(I2,\",\",J2)","v":"8.8918,47.20575"}]
["B","ff00ffff","Flugplatz Franzrueti","Ab See",null,null,"Wasserbezug","<scale>0.5</scale>",8.8641000000000005,47.203560000000003,null,"Flugplatz Franzrueti Ab See",{"$f":"CONCATENATE(L3,IF(E3<>\"\",IF(F3<>\"\",CONCATENATE(L3,'Set-Up'!$C$7,E3,'Set-Up'!$C$8,F3,'Set-Up'!$C$9),CONCATENATE('Set-Up'!$C$4,E3,'Set-Up'!$C$5)),\"\"))","v":"Flugplatz Franzrueti Ab See"},{"$f":"getIconURL(G3)","v":"https://api3.geo.admin.ch/color/0,255,0/marker-24@2x.png"},"8.8641,47.20356"]

{"sheet":"Set-Up","index":2,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"Hier nichts ändern, wenn Sie nicht genau wissen, was Sie machen!!!"]
[null,"Mandant","8855_TryIt",null,null,"Anführungszeichen","\""]
[null,"Base URLPictures","http://www.rothlin.com/maps/img/"]
[null,"OnePicture_1",{"$f":"CONCATENATE(\"&lt;BR/&gt;&lt;img src=\",G2,C3)","v":"&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/"}]
[null,"OnePicture_2","\" style=\"max-height:200px;\" /&gt;"]
[]
[null,"TwoPicture_1",{"$f":"CONCATENATE(\"&lt;BR/&gt;&lt;img src=\",G2,C3)","v":"&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/"}]
[null,"TwoPicture_2",{"$f":"CONCATENATE(\" \",G2,\" style=\",G2,\"max-height:200px;\",G2,\" /&gt;&lt;BR/&gt;&lt;img src=\",G2,C3)","v":" \" style=\"max-height:200px;\" /&gt;&lt;BR/&gt;&lt;img src=\"http://www.rothlin.com/maps/img/"}]
[null,"TwoPicture_3",{"$f":"C5","v":"\" style=\"max-height:200px;\" /&gt;"}]
[]
[]
[]
[null,null,null,null,null,"Base URL Icons","http://www.fhoch3.peterliwiese.ch/icons/"]
[null,null,null,null,null,"Neu",{"$f":"CONCATENATE(G13,\"HyderantNeuKlein.png\")","v":"http://www.fhoch3.peterliwiese.ch/icons/HyderantNeuKlein.png"}]
[null,null,null,null,null,"Alt",{"$f":"CONCATENATE(G13,\"HyderantAltKlein.png\")","v":"http://www.fhoch3.peterliwiese.ch/icons/HyderantAltKlein.png"}]
[null,null,null,null,null,"Wasserbezug","https://api3.geo.admin.ch/color/0,255,0/marker-24@2x.png"]
[null,null,null,null,null,"Rot","https://api3.geo.admin.ch/color/255,0,0/marker-24@2x.png"]
[null,null,null,null,null,"Blau","https://api3.geo.admin.ch/color/0,0,255/marker-24@2x.png"]
[null,null,null,null,null,"Ref","https://api3.geo.admin.ch/color/0,128,0/circle-24@2x.png"]
[]
[]
[null,"Filename",{"$f":"MyName()","v":"Plaene_8855_TryIt.xlsm"}]
[null,"FullFilename",{"$f":"MyFullName()","v":"G:\\_Daten_2020_02_19\\SourceCode\\XML\\KML_Karten\\8855_TryIt\\Plaene_8855_TryIt.xlsm"}]
[null,"FilePath",{"$f":"LEFT(C23,LEN(C23)-LEN(C22))","v":"G:\\_Daten_2020_02_19\\SourceCode\\XML\\KML_Karten\\8855_TryIt\\"}]
[]
[]
[]
[]
[]
[]
[null,"Delimiter","|"]
[null,"Upperleft","A1"]
[]
[]
[]
[]
[null,"FTP-Server","ftp.peterliwiese.ch"]
[null,"UserName",{"$f":"CONCATENATE(C2,\"@fhoch3.peterliwiese.ch\")","v":"8855_TryIt@fhoch3.peterliwiese.ch"}]
[null,"Password","TryIt_007"]
[null,"Remote Directory",{"$f":"CONCATENATE(\"/public_html/fhoch3/\",C2)","v":"/public_html/fhoch3/8855_TryIt"}]
[null,"TempLocalFile",{"$f":"CONCATENATE(C24,C2,\".bas\")","v":"G:\\_Daten_2020_02_19\\SourceCode\\XML\\KML_Karten\\8855_TryIt\\8855_TryIt.bas"}]
[]
[null,"Base URL Web-Service","http://www.fhoch3.peterliwiese.ch/"]
[null,"URL Web-Service",{"$f":"CONCATENATE(C43,\"cgi-bin/convertKML_Plaene.pl?Mandant=\",C2)","v":"http://www.fhoch3.peterliwiese.ch/cgi-bin/convertKML_Plaene.pl?Mandant=8855_TryIt"}]
[null,"URL Plan (kml)",{"$f":"CONCATENATE(C43,C2,\"/Plan_Hydranten.xml\")","v":"http://www.fhoch3.peterliwiese.ch/8855_TryIt/Plan_Hydranten.xml"}]
[null,"URL Plan (kml)",{"$f":"CONCATENATE(C43,C2,\"/Plan_Wasserbezug.xml\")","v":"http://www.fhoch3.peterliwiese.ch/8855_TryIt/Plan_Wasserbezug.xml"}]
[null,"URL Plan (kml)"]
[]
[null,"Auf Karte","https://map.geo.admin.ch/?lang=de&topic=ech&bgLayer=ch.swisstopo.pixelkarte-farbe&layers=ch.swisstopo.zeitreihen,ch.bfs.gebaeude_wohnungs_register,ch.bav.haltestellen-oev,ch.swisstopo.swisstlm3d-wanderwege,KML%7C%7Chttp:%2F%2Fwww.fhoch3.peterliwiese.ch%2F8855_TryIt%2FPlan_Hydranten.xml,KML%7C%7Chttp:%2F%2Fwww.fhoch3.peterliwiese.ch%2F8855_TryIt%2FPlan_Wasserbezug.xml&layers_visibility=false,false,false,false,true,true&layers_timestamp=18641231,,,,,&E=2708917.53&N=1228839.36&zoom=7"]
[null,"Auf Karte (Bitly)","https://bit.ly/2T1qfrz"]
[null,"Homepage",{"$f":"CONCATENATE(C43,C2)","v":"http://www.fhoch3.peterliwiese.ch/8855_TryIt"}]
[]
[null,"Hilfreiche Online-Tools"]
[null,"QR-Generator","https://www.qrcode-generator.de/"]
[null,"Bitly","https://bitly.com/"]