{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Anleitung","Örtliche Zuordnung","OPTA Generator","OPTA Tabelle","Werte","Formeln","Version"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":33,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Anleitung","index":0,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,1,11]]}
[]
["Tabellenblatt: Örtliche Zuordnung"]

{"sheet":"Örtliche Zuordnung","index":1,"n_rows":166,"n_cols":192,"rows_kept":166,"cut":false,"hidden":false,"merged":[]}
["A#",{"$f":"IF(ISBLANK(A1),\"\",\"Abk_\"&A1)","v":"Abk_A#"},"AIC",{"$f":"IF(ISBLANK(C1),\"\",\"Abk_\"&C1)","v":"Abk_AIC"},"DLG",{"$f":"IF(ISBLANK(E1),\"\",\"Abk_\"&E1)","v":"Abk_DLG"},"DON",{"$f":"IF(ISBLANK(G1),\"\",\"Abk_\"&G1)","v":"Abk_DON"},null,{"$f":"IF(ISBLANK(I1),\"\",\"Abk_\"&I1)","v":""},null,{"$f":"IF(ISBLANK(K1),\"\",\"Abk_\"&K1)","v":""},null,{"$f":"IF(ISBLANK(M1),\"\",\"Abk_\"&M1)","v":""},null,{"$f":"IF(ISBLANK(O1),\"\",\"Abk_\"&O1)","v":""},null,{"$f":"IF(ISBLANK(Q1),\"\",\"Abk_\"&Q1)","v":""},null,{"$f":"IF(ISBLANK(S1),\"\",\"Abk_\"&S1)","v":""},null,{"$f":"IF(ISBLANK(U1),\"\",\"Abk_\"&U1)","v":""},null,{"$f":"IF(ISBLANK(W1),\"\",\"Abk_\"&W1)","v":""},null,{"$f":"IF(ISBLANK(Y1),\"\",\"Abk_\"&Y1)","v":""},null,{"$f":"IF(ISBLANK(AA1),\"\",\"Abk_\"&AA1)","v":""},null,{"$f":"IF(ISBLANK(AC1),\"\",\"Abk_\"&AC1)","v":""},null,{"$f":"IF(ISBLANK(AE1),\"\",\"Abk_\"&AE1)","v":""},null,{"$f":"IF(ISBLANK(AG1),\"\",\"Abk_\"&AG1)","v":""},null,{"$f":"IF(ISBLANK(AI1),\"\",\"Abk_\"&AI1)","v":""},null,{"$f":"IF(ISBLANK(AK1),\"\",\"Abk_\"&AK1)","v":""},null,{"$f":"IF(ISBLANK(AM1),\"\",\"Abk_\"&AM1)","v":""},null,{"$f":"IF(ISBLANK(AO1),\"\",\"Abk_\"&AO1)","v":""},null,{"$f":"IF(ISBLANK(AQ1),\"\",\"Abk_\"&AQ1)","v":""},null,{"$f":"IF(ISBLANK(AS1),\"\",\"Abk_\"&AS1)","v":""},null,{"$f":"IF(ISBLANK(AU1),\"\",\"Abk_\"&AU1)","v":""},null,{"$f":"IF(ISBLANK(AW1),\"\",\"Abk_\"&AW1)","v":""},null,{"$f":"IF(ISBLANK(AY1),\"\",\"Abk_\"&AY1)","v":""},null,{"$f":"IF(ISBLANK(BA1),\"\",\"Abk_\"&BA1)","v":""},null,{"$f":"IF(ISBLANK(BC1),\"\",\"Abk_\"&BC1)","v":""},null,{"$f":"IF(ISBLANK(BE1),\"\",\"Abk_\"&BE1)","v":""},null,{"$f":"IF(ISBLANK(BG1),\"\",\"Abk_\"&BG1)","v":""},null,{"$f":"IF(ISBLANK(BI1),\"\",\"Abk_\"&BI1)","v":""},null,{"$f":"IF(ISBLANK(BK1),\"\",\"Abk_\"&BK1)","v":""},null,{"$f":"IF(ISBLANK(BM1),\"\",\"Abk_\"&BM1)","v":""},null,{"$f":"IF(ISBLANK(BO1),\"\",\"Abk_\"&BO1)","v":""},null,{"$f":"IF(ISBLANK(BQ1),\"\",\"Abk_\"&BQ1)","v":""},null,{"$f":"IF(ISBLANK(BS1),\"\",\"Abk_\"&BS1)","v":""},null,{"$f":"IF(ISBLANK(BU1),\"\",\"Abk_\"&BU1)","v":""},null,{"$f":"IF(ISBLANK(BW1),\"\",\"Abk_\"&BW1)","v":""},null,{"$f":"IF(ISBLANK(BY1),\"\",\"Abk_\"&BY1)","v":""},null,{"$f":"IF(ISBLANK(CA1),\"\",\"Abk_\"&CA1)","v":""},null,{"$f":"IF(ISBLANK(CC1),\"\",\"Abk_\"&CC1)","v":""},null,{"$f":"IF(ISBLANK(CE1),\"\",\"Abk_\"&CE1)","v":""},null,{"$f":"IF(ISBLANK(CG1),\"\",\"Abk_\"&CG1)","v":""},null,{"$f":"IF(ISBLANK(CI1),\"\",\"Abk_\"&CI1)","v":""},null,{"$f":"IF(ISBLANK(CK1),\"\",\"Abk_\"&CK1)","v":""},null,{"$f":"IF(ISBLANK(CM1),\"\",\"Abk_\"&CM1)","v":""},null,{"$f":"IF(ISBLANK(CO1),\"\",\"Abk_\"&CO1)","v":""},null,{"$f":"IF(ISBLANK(CQ1),\"\",\"Abk_\"&CQ1)","v":""},null,{"$f":"IF(ISBLANK(CS1),\"\",\"Abk_\"&CS1)","v":""},null,{"$f":"IF(ISBLANK(CU1),\"\",\"Abk_\"&CU1)","v":""},null,{"$f":"IF(ISBLANK(CW1),\"\",\"Abk_\"&CW1)","v":""},null,{"$f":"IF(ISBLANK(CY1),\"\",\"Abk_\"&CY1)","v":""},null,{"$f":"IF(ISBLANK(DA1),\"\",\"Abk_\"&DA1)","v":""},null,{"$f":"IF(ISBLANK(DC1),\"\",\"Abk_\"&DC1)","v":""},null,{"$f":"IF(ISBLANK(DE1),\"\",\"Abk_\"&DE1)","v":""},null,{"$f":"IF(ISBLANK(DG1),\"\",\"Abk_\"&DG1)","v":""},null,{"$f":"IF(ISBLANK(DI1),\"\",\"Abk_\"&DI1)","v":""},null,{"$f":"IF(ISBLANK(DK1),\"\",\"Abk_\"&DK1)","v":""},null,{"$f":"IF(ISBLANK(DM1),\"\",\"Abk_\"&DM1)","v":""},null,{"$f":"IF(ISBLANK(DO1),\"\",\"Abk_\"&DO1)","v":""},null,{"$f":"IF(ISBLANK(DQ1),\"\",\"Abk_\"&DQ1)","v":""},null,{"$f":"IF(ISBLANK(DS1),\"\",\"Abk_\"&DS1)","v":""},null,{"$f":"IF(ISBLANK(DU1),\"\",\"Abk_\"&DU1)","v":""},null,{"$f":"IF(ISBLANK(DW1),\"\",\"Abk_\"&DW1)","v":""},null,{"$f":"IF(ISBLANK(DY1),\"\",\"Abk_\"&DY1)","v":""},null,{"$f":"IF(ISBLANK(EA1),\"\",\"Abk_\"&EA1)","v":""},null,{"$f":"IF(ISBLANK(EC1),\"\",\"Abk_\"&EC1)","v":""},null,{"$f":"IF(ISBLANK(EE1),\"\",\"Abk_\"&EE1)","v":""},null,{"$f":"IF(ISBLANK(EG1),\"\",\"Abk_\"&EG1)","v":""},null,{"$f":"IF(ISBLANK(EI1),\"\",\"Abk_\"&EI1)","v":""},null,{"$f":"IF(ISBLANK(EK1),\"\",\"Abk_\"&EK1)","v":""},null,{"$f":"IF(ISBLANK(EM1),\"\",\"Abk_\"&EM1)","v":""},null,{"$f":"IF(ISBLANK(EO1),\"\",\"Abk_\"&EO1)","v":""},null,{"$f":"IF(ISBLANK(EQ1),\"\",\"Abk_\"&EQ1)","v":""},null,{"$f":"IF(ISBLANK(ES1),\"\",\"Abk_\"&ES1)","v":""},null,{"$f":"IF(ISBLANK(EU1),\"\",\"Abk_\"&EU1)","v":""},null,{"$f":"IF(ISBLANK(EW1),\"\",\"Abk_\"&EW1)","v":""},null,{"$f":"IF(ISBLANK(EY1),\"\",\"Abk_\"&EY1)","v":""},null,{"$f":"IF(ISBLANK(FA1),\"\",\"Abk_\"&FA1)","v":""},null,{"$f":"IF(ISBLANK(FC1),\"\",\"Abk_\"&FC1)","v":""},null,{"$f":"IF(ISBLANK(FE1),\"\",\"Abk_\"&FE1)","v":""},null,{"$f":"IF(ISBLANK(FG1),\"\",\"Abk_\"&FG1)","v":""},null,{"$f":"IF(ISBLANK(FI1),\"\",\"Abk_\"&FI1)","v":""},null,{"$f":"IF(ISBLANK(FK1),\"\",\"Abk_\"&FK1)","v":""},null,{"$f":"IF(ISBLANK(FM1),\"\",\"Abk_\"&FM1)","v":""},null,{"$f":"IF(ISBLANK(FO1),\"\",\"Abk_\"&FO1)","v":""},null,{"$f":"IF(ISBLANK(FQ1),\"\",\"Abk_\"&FQ1)","v":""},null,{"$f":"IF(ISBLANK(FS1),\"\",\"Abk_\"&FS1)","v":""},null,{"$f":"IF(ISBLANK(FU1),\"\",\"Abk_\"&FU1)","v":""},null,{"$f":"IF(ISBLANK(FW1),\"\",\"Abk_\"&FW1)","v":""},null,{"$f":"IF(ISBLANK(FY1),\"\",\"Abk_\"&FY1)","v":""},null,{"$f":"IF(ISBLANK(GA1),\"\",\"Abk_\"&GA1)","v":""},null,{"$f":"IF(ISBLANK(GC1),\"\",\"Abk_\"&GC1)","v":""},null,{"$f":"IF(ISBLANK(GE1),\"\",\"Abk_\"&GE1)","v":""},null,{"$f":"IF(ISBLANK(GG1),\"\",\"Abk_\"&GG1)","v":""},null,{"$f":"IF(ISBLANK(GI1),\"\",\"Abk_\"&GI1)","v":""}]
["Achsheim","ACHHM","Adelzhausen","ADHSN","Aislingen","AINGN","Alerheim","ALRHM"]
["Adelsried","ADSRD","Affing","AFFNG","Altenbaindt","ALTBT","Altisheim","ALTHM"]
["Affaltern","AFTRN","Aichach","AICHA","Asbach","ASBCH","Amerbach","AMMBH"]
["Agawang","AGAWG","Aindling","AINLG","Bachhagel","BHHG1","Amerdingen","AMNGN"]
["Allmannshofen","ALMHF","Allenberg","ALLBG","Bachhagel-Burghagel","BHHG3","Appetshofen - Lierheim","APLHM"]
["Altenmünster","ALMST","Alsmoos","ALSMS","Bachhagel-Oberbechingen","BHHG2","Asbach-Bäumenheim","ASBHM"]
["Anhausen","ANHSN","Anwalting","ANWIG","Bächingen","BANGN","Asbach-Bäumenheim Agco Fendt","AFNDT"]
["Anried","ANRD_","Aulzhausen","ALHSN","Baumgarten","BAUMG","Auchsesheim","AUCHM"]
["Aretsried","ARERD","Baar","BAAR_","Bergheim","BRGHM","Aufhausen","AFHSN"]
["Auerbach","AURBC","Bachern","BCHRN","Binswangen","BINWG","Auhausen","AUHSN"]
["Aystetten","AYSTE","Baindlkirch","BDLKH","Bissingen","BSNGN","Baierfeld","BAIFD"]
["Baiershofen","BAIHN","Burgadelzhausen","BADHN","Bliensbach","BLIBH","Baldingen","BANGN"]
["Batzenhofen","BAZHN","Dasing","DASNG","Blindheim","BLDHM","Balgheim","BALHM"]
["Biberbach","BIBBC","Derching","DCHIG","Bocksberg","BOKBG","Bayerdilling","BAYNG"]
["Biburg","BIBR_","Ebenried","EBNRD","Burgmagerbein","BRGMB","Belzheim-Ehingen a. Ries","BELHM"]
["Bieselbach","BISBC","Echsheim","EHSHM","Buttenwiesen","BTWSN","Berg","BERG"]
["Birkach","BIRKA","Ecknach","ECKNH","Deisenhofen","DSHFN","Bergendorf","BERDF"]
["Blankenburg","BLABG","Edenried","EDNRD","Diemantstein","DIEST","Bergstetten","BERTN"]
["Bobingen","BOBGN","Eismannsberg","EISBG","Dillingen","DILLG","Birkhausen","BIHSN"]
["Bobingen IWB","IWBBO","Eresried","ERERD","Dillingen Bosch","BOSCH","Blossenau - Tagmersheim","BLNAU"]
["Bonstetten","BONST","Eurasburg","EURBG","Donaualtheim","DONAH","Bollstadt","BOLST"]
["Breitenbronn","BRBRN","Freienried","FRERD","Echenbrunn","ECHBR","Brachstadt","BRAST"]
["Buch","BUCH_","Friedberg","FRDBG","Ellerbach","ELLBC","Brünsee - Marbach","BRNSE"]
["Deubach","DEUBC","Friedberg Federal Mogul","FEDMG","Eppisburg","EPPBG","Buchdorf","BUCDF"]
["Deuringen","DEUGN","Gallenbach","GLLBH","Finningen","FINGN","Bühl i. Ries","BUEHL"]
["Diedorf","DIEDF","Gebenhofen","GEBHN","Frauenriedhausen","FRHSN","Burgmannshofen - Übersfeld","BRGHF"]
["Dinkelscherben","DKSCH","Griesbeckerzell","GRSBZ","Frauenstetten","FSTET","Daiting","DATIG"]
["Döpshofen","DOPHN","Grimolzhausen","GRHSN","Fristingen","FRNGN","Deiningen","DENGN"]
["Edenbergen","EDEBG","Gundelsdorf","GNDDF","Fronhofen","FROHN","Donaumünster / Erlingshofen","DERHN"]
["Ehingen","EHNGN","Haberskirch","HABKH","Glött","GLOTT","Donauwörth","DONTH"]
["Eisenbrechtshofen","EBRHN","Handzell","HANDZ","Göllingen","GLNGN","Donauwörth Airbus-Helicopters","ABHEL"]
["Ellgau","ELGAU","Haslangkreit","HSLKR","Gottmannshofen","GOTHN","Dornstadt / Hirschbrunn","DORST"]
["Emersacker","EMACK","Haunswies","HNSWI","Gremheim","GREHM","Druisheim","DRUHM"]
["Eppishofen","EPIHN","Hausen","HAUSN","Gundelfingen","GUNGN","Dürrenzimmern","DURZI"]
["Erlingen","ERNGN","Heretshausen","HRHSN","Gundelfingen Gartner","GARTN","Ebermergen","EMRGN"]
["Ettelried","ETERD","Hochdorf","HOCDF","Haunsheim","HAUHM","Ederheim","EDEHM"]
["Feigenhofen","FGNHN","Hofhegnenberg","HOHBG","Hausen","HAUSN","Eggelstetten","EGGST"]
["Fischach","FSCHA","Hollenbach","HOLBC","Hirschbach","HIRBC","Ehingen","EHNGN"]
["Fleinhausen","FLHSN","Hörmannsberg","HMSBG","Höchstädt","HOEST","Ehringen","ERNGN"]
["Gabelbach","GABBC","Hügelshart","HUHRT","Hochstein","HOCHS","Enkingen","EKNGN"]
["Gabelbachergreut","GAGRT","Igenhausen","IGHSN","Hohenreichen","HOHRN","Erlbach","ERLBH"]
["Gablingen","GBNGN","Inchenhofen","INHFN","Holzheim","HOLZH","Etting","ETTIG"]
["Gennach","GENNH","Kissing","KISIG","Kesselostheim","KOSHM","Feldheim","FLDHM"]
["Gersthofen","GSTHN","Klingen","KLIGN","Kicklingen","KINGN","Fessenheim","FESHM"]
["Gersthofen IGS","IGS","Kühbach","KUHBC","Landshausen","SYST2","Flotzheim - Kreut","FLOHM"]
["Gessertshausen","GEHSN","Kühnhausen","KHHSN","Laugna","LAUGA","Forheim","FORHM"]
["Graben","GRABN","Laimering","LMRIG","Lauingen","LANGN","Fremdingen","FRNGN"]
["Grimoldsried","GRMRD","Mainbach","MAIBC","Lauingen Same-Deuz-Fahr","SMDZF","Fünfstetten","FUNST"]
["Großaitingen","GRNGN","Mauerbach","MAUBC","Lauterbach","LAUBH","Gansheim","GANHM"]
["Grünenbaindt","GRNBA","Merching","MCHIG","Leiheim","LEIHM","Gempfing - Überacker","GEMIG"]
["Häder","HADER","Mering","MERIG","Lutzingen","LUNGN","Genderkingen","GKNGN"]
["Hainhofen","HAIHN","Mering Baierberg","MERBG","Mödingen","MONGN","Gosheim","GOSHM"]
["Hammel","HAMML","Motzenhofen","MTZHN","Mörslingen","MSNGN","Graisbach","GRABA"]
["Hegnenbach","HGNBH","Mühlhausen","MUHSN","Oberglauheim","OGLHM","Grosselfingen","GSNGN"]
["Hennhofen","HENHN","Oberbachern","OBACH","Oberliezheim","OLIHM","Großsorheim","GROHM"]
["Herbertshofen","HERHN","Oberbernbach","OBERB","Obermedlingen","OMNGN","Gunzenheim","GUNHM"]
["Herbertshofen Lechstahl","LCHST","Obergriesbach","OGRSB","Oberthürheim","THHM2","Hafenreut","HAFRT"]
["Heretsried","HERRD","Oberschneitbach","OSHNB","Oberringingen","ORNGN","Hagau","HAGAU"]
["Hiltenfingen","HINGN","Oberschönbach","OSHBA","Osterbuch","OSTBH","Hainsfarth","HAFTH"]
["Hirblingen","HRNGN","Oberwittelsbach","OWIBA","Peterswörth","PEWTH","Hamlar","HAMLR"]
["Horgau","HRGAU","Osterzhausen","OSHSN","Pfaffenhofen","PFHFN","Harburg","HARBR"]
["Horgauergreut","HORGT","Ottmaring","OTTIG","Prettelshofen","PRHFN","Hausen","HAUSN"]
["Kleinaitingen","KLNGN","Paar - Harthausen","PHART","Reistingen","ZRHM2","Heißesheim","HEIHM"]
["Klimmach","KLMAC","Petersdorf","PETDF","Rieblingen","RBNGN","Herblingen","HBNGN"]
["Klosterlechfeld","KLOFD","Pichl - Binnenbach","PBIBA","Riedsend","RIEND","Herkheim","HRKHM"]
["Königsbrunn","KOEBR","Pöttmes","POETT","Roggden","ROGDN","Heroldingen","HONGN"]
["Konradshofen","KONHN","Rapperzell","RAPZL","Schabringen","SCNGN","Heuberg","HEUBG"]
["Kühlenthal","KUETL","Rederzhausen","RDHSN","Schretzheim","SCHHM","Hochaltingen","HANGN"]
["Kutzenhausen","KUHSN","Rehling","REHIG","Schwennenbach","SCHBH","Hochfeld","HOHFD"]
["Langenneufnach","LGNNC","Reicherstein","RCHST","Schwenningen","SWNGN","Hohenaltheim","HATHM"]
["Langenreichen","LGNRC","Ried","RIED","Sonderheim","SODHM","Holheim","HOLHM"]
["Langerringen","LGNGN","Rieden","RIEDN","Sontheim","SOTHM","Holzheim","HLZHM"]
["Langweid","LANWD","Rinnenthal","RINTL","Staufen","SYST3","Holzkirchen","HLZCN"]
["Langweid Huntsman","HUNTM","Rohrbach","ROHBA","Steinheim","STEHM","Hoppingen","HPNGN"]
["Lauterbrunn","LAUBN","Ruppertszell","RUPZL","Stillnau","STLNA","Huisheim","HUIHM"]
["Lechfeld Bundeswehr","BWLCH","Sainbach","SAIBC","Syrgenstein","SYST1","Hürnheim","HUEHM"]
["Leitershofen","LEIHN","Schiltberg","SCHBG","Thalheim","THAHM","Itzing","ITZIG"]
["Lindach","LNDAC","Schmiechen","SCHCN","Unterbechingen","UBNGN","Kaisheim","KAIHM"]
["Lützelburg","LTZBG","Schnellmannskreuth","SCHMK","Unterbissingen","UBSGN","Kaisheim JVA","JVAKH"]
["Maingründel","MAIGD","Schönbach","SCHBH","Unterglauheim","UGLHM","Kleinerdlingen","KLNGN"]
["Margertshausen","MAGHN","Schorn","SCHRN","Unterliezheim","ULZHM","Kleinsorheim","KORHM"]
["Markt","MARKT","Sielenbach","SIEBC","Untermedlingen","UMNGN","Kölburg","KOLBR"]
["Meitingen","MEIGN","Sirchenried","SIERD","Unterringingen","URNGN","Laub","LAUB_"]
["Meitingen SGL-Carbon","SGLCB","Stätzling","STZIG","Unterthürheim","THHM1","Lechsend","LECND"]
["Mickhausen","MIKHN","Steinach","STNAH","Veitriedhausen","VRHSN","Lehmingen","LENGN"]
["Mittelneufnach","MTNCH","Steindorf","STNDF","Villenbach","VILBH","Leitheim","LEIHM"]
["Mittelstetten","MTSTN","Stockensau","STSAU","Weisingen","WSNGN","Lochenbach","LCHBH"]
["Münster","MNSTR","Stotzard","STOTZ","Wengen","WNGEN","Löpsingen","LPNGN"]
["Neukirchen","NEUKH","Sulzbach","SLZBC","Wertingen","WRNGN","Maihingen","MANGN"]
["Neumünster","NEUMS","Taiting - Bitzenhofen","TAIBZ","Wittislingen","WINGN","Marktoffingen","MOFGN"]
["Neusäß","NEUSS","Tödtenried","TODRD","Wolpertstetten","WPSTE","Marxheim","MRXHM"]
["Nordendorf","NORDF","Todtenweis","TODWS","Wortelstetten","WOSTE","Mauren","MAURN"]
["Oberottmarshausen","OOTHN","Unterbergen","UNBRG","Ziertheim","ZRHM1","Megesheim","MEGHM"]
["Oberschöneberg","OSHBG","Unterbernbach","UBERB","Zoltingen","ZONGN","Mertingen","MRNGN"]
["Ortlfingen","ORNGN","Unterwittelsbach","UWIBC","Zöschingen","ZSNGN","Merzingen","MZNGN"]
["Ostendorf","OSTDF","Walchshofen","WAHFN","Zusamaltheim","ZUAHM","Minderoffingen","MINGN"]
["Ottmarshausen","OTTHN","Wessiszell","WESZL",null,null,"Mittelstetten","MTSTN"]
["Reichertshofen","RHHSN","Wiesenbach","WIEBH",null,null,"Mönchsdeggingen","MDNGN"]
["Reinhartshausen","RNHSN","Wiffertshausen","WFHSN",null,null,"Monheim","MONHM"]
["Reinhartshofen","RNHHN","Willprechtszell - Schönleiten","WLPSL",null,null,"Möttingen","MTNGN"]
["Reitenbuch","REIBC","Wulfertshausen","WUHSN",null,null,"Mündling","MDLNG"]
["Rettenbergen","RETBG","Zahling","ZALIG",null,null,"Munningen","MUNGN"]
["Reutern","REUTN","Zillenberg","ZILBG",null,null,"Münster","MNSTR"]
["Ried","RIED",null,null,null,null,"Munzingen","MNNGN"]
["Rommelsried","ROMRD",null,null,null,null,"Nähermemmingen","NMNGN"]
["Scherstetten","SHSTN",null,null,null,null,"Natterholz","NTHLZ"]
["Schlipsheim","SHLHM",null,null,null,null,"Neuhausen","NEHSN"]
["Schwabegg","SHWEG",null,null,null,null,"Niederaltheim","NALHM"]
["Schwabmühlhausen","SMHSN",null,null,null,null,"Niederhofen","NIDHN"]
["Schwabmünchen","SMUCN",null,null,null,null,"Niederschönenfeld","NSCFD"]
["Schwabmünchen Osram","OSRMS",null,null,null,null,"Niederschönenfeld JVA","JVANS"]
["Siegertshofen","SIGHN",null,null,null,null,"Nittingen","NTNGN"]
["Stadtbergen","STBGN",null,null,null,null,"Nordheim","NODHM"]
["Steinekirch","STNKC",null,null,null,null,"Nördlingen","NDNGN"]
["Steppach","STPAC",null,null,null,null,"Nördlingen SCA Packaging","SCAPG"]
["Stettenhofen","STNHN",null,null,null,null,"Nußbühl-Heidmersbrunn","NUHBN"]
["Straßberg","STRBG",null,null,null,null,"Oberndorf a. Lech","OBNDF"]
["Streitheim","STRHM",null,null,null,null,"Oberpeiching","OBPNG"]
["Täfertingen","TFNGN",null,null,null,null,"Oettingen","OTNGN"]
["Thierhaupten","THPTN",null,null,null,null,"Oppertshofen","OPPHN"]
["Tronetshofen","TROHN",null,null,null,null,"Otting","OTTIG"]
["Untermeitingen","UMNGN",null,null,null,null,"Pessenburgheim","PBGHM"]
["Unterschöneberg","USHBG",null,null,null,null,"Pfäfflingen","PFNGN"]
["Ustersbach","USTBH",null,null,null,null,"Rain","RAIN_"]
["Vallried","VALRD",null,null,null,null,"Rehau","REHAU"]
["Waldberg","WLDBG",null,null,null,null,"Reimlingen","RLNGN"]
["Walkertshofen","WLKHN",null,null,null,null,"Ried","RIED_"]
["Waltershofen","WLTHN",null,null,null,null,"Riedheim - Stadel","RHMST"]
["Wehringen","WENGN",null,null,null,null,"Riedlingen","RDNGN"]
["Welden","WELDN",null,null,null,null,"Rögling","RGLIG"]
["Westendorf","WSTDF",null,null,null,null,"Rohrbach","RORBC"]
["Westheim","WSTHM",null,null,null,null,"Ronheim","RONHM"]
["Willishausen","WIHSN",null,null,null,null,"Rudelstetten","RUSTN"]
["Willmatshofen","WILHN",null,null,null,null,"Sallach","SALAC"]
["Wollbach","WOLBH",null,null,null,null,"Schaffhausen","SAHSN"]
["Wollishausen","WOHSN",null,null,null,null,"Schäfstall","SFSTL"]
["Wollmetshofen","WOLHN",null,null,null,null,"Schmähingen","SMNGN"]
["Wörleschwang","WSCHG",null,null,null,null,"Schopflohe","SPFLH"]
["Zusamzell","ZUZLL",null,null,null,null,"Schrattenhofen","SRAHN"]
["Zusmarshausen","ZUHSN",null,null,null,null,"Schweinspoint","SWPNT"]
[null,null,null,null,null,null,"Schwörsheim","SWSHM"]
[null,null,null,null,null,null,"Seglohe","SEGLH"]
[null,null,null,null,null,null,"Staudheim","STDHM"]
[null,null,null,null,null,null,"Steinhart","STNHT"]
[null,null,null,null,null,null,"Sulzdorf","SLZDF"]
[null,null,null,null,null,null,"Tagmersheim","TAGHM"]
[null,null,null,null,null,null,"Tapfheim","TPFHM"]
[null,null,null,null,null,null,"Untermagerbein","UMGBN"]
[null,null,null,null,null,null,"Unterpeiching","UPEIG"]
[null,null,null,null,null,null,"Utzwingen","UTNGN"]
[null,null,null,null,null,null,"Wächtering","WATIG"]
[null,null,null,null,null,null,"Wallerdorf","WALDF"]
[null,null,null,null,null,null,"Wallerstein","WASTN"]
[null,null,null,null,null,null,"Warching","WARIG"]
[null,null,null,null,null,null,"Wechingen","WHNGN"]
[null,null,null,null,null,null,"Weilheim","WEIHM"]
[null,null,null,null,null,null,"Wemding","WEMIG"]
[null,null,null,null,null,null,"Wittesheim","WITHM"]
[null,null,null,null,null,null,"Wolferstadt","WOLST"]
[null,null,null,null,null,null,"Wörnitzostheim","WOSHM"]
[null,null,null,null,null,null,"Wörnitzstein","WOSTN"]
[null,null,null,null,null,null,"Zirgesheim","ZRGHM"]
[null,null,null,null,null,null,"Ziswingen","ZWNGN"]
[null,null,null,null,null,null,"Zusum - Rettingen","ZRNGN"]
[null,null,null,null,null,null,"Zwerchstraß","ZWSTR"]

{"sheet":"OPTA Generator","index":2,"n_rows":34,"n_cols":29,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,25,5,25],[9,1,9,7],[14,8,14,24],[14,1,14,7],[11,1,11,7],[7,8,7,24],[9,8,9,24],[11,8,11,24],[8,1,8,7],[8,8,8,24],[10,1,10,7],[10,8,10,24],[13,1,13,7],[13,8,13,24],[12,1,12,7],[12,8,12,24],[4,1,4,7],[4,8,4,24],[6,1,6,7],[6,8,6,24],[7,1,7,7],[17,8,17,24],[30,1,30,20],[29,1,29,20],[15,8,15,24],[15,1,15,7],[16,1,16,7],[16,8,16,24],[17,1,17,7],[20,1,20,24],[22,8,24,8],[22,21,24,21],[22,20,24,20],[22,2,24,2],[22,1,24,1],[22,13,24,13],[22,12,24,12],[22,3,24,3],[25,6,26,8],[25,3,26,5],[22,11,24,11],[22,10,24,10],[22,9,24,9],[22,7,24,7],[22,6,24,6],[22,24,24,24],[22,23,24,23],[22,22,24,22],[22,5,24,5],[22,4,24,4],[21,25,25,25],[32,1,32,20],[33,1,33,20],[2,4,2,5],[2,1,2,2],[25,1,26,2],[22,14,24,14],[25,24,26,24],[25,22,26,23],[25,14,26,21],[25,9,26,13],[22,19,24,19],[22,18,24,18],[22,17,24,17],[22,16,24,16],[22,15,24,15]]}
[]
[null,"OPTA Generator für npol BOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spalte ausblenden"]
[null,"Version 0.8",null,null,"2015-04-21"]
[]
[null,"Anmerkung:",null,null,null,null,null,null,"Eingabefelder (hellgrün) sind Auswahllisten"]
[]
[null,null,null,null,null,null,null,null,"Bayern",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","BY","Fester Wert","01-02"]
[null,{"$f":"IF(ISBLANK(I8),\"Auswahlt fehlt\",\"\")","v":""},null,null,null,null,null,null,"Feuerwehr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(I8,Organisation,Werte!B2:B13)","v":"FW "},{"$f":"Z8&REPT(\" \",3-LEN(Z8))","v":"FW "},"Organisation, 3 stellig","03-05"]
[null,{"$f":"IF(ISBLANK(I9),\"Auswahlt fehlt\",\"\")","v":""},null,null,null,null,null,null,"Schwaben",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vorauswahl für das Feld Landkreis"]
[null,{"$f":"IF(ISBLANK(I10),\"Auswahlt fehlt\",\nIF(OR(ISBLANK(I11),ISBLANK(I12)),\"\",\nIF(AND($Z$11=\"Oez\",NOT(ISERROR(MATCH($I$10,Bezirk,0)))),\"Regierungsbezirk nicht möglich\",\nIF(AND($Z$11=\"UeE\",ISERROR(MATCH($I$10,Bezirk,0)),$I$10<>$I$12),\"Zeilen 10 und 12 unterschiedlich\",\"\"))))","v":""},null,null,null,null,null,null,"Dillingen a.d.Donau, Landkreis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(\"WERT_Landkreis\",Werte!E:F,MATCH(I10,Werte!E:E,0),FALSE)","v":"DLG"},{"$f":"Z10&REPT(\" \",3-LEN(Z10))","v":"DLG"},"Landkreis, 3 stellig","06-08"]
[null,{"$f":"IF(ISBLANK(I11),\"Auswahlt fehlt\",\nIF(AND(NOT(ISERROR(MATCH($I$10,Bezirk,0))),Z11=\"Oez\"),\"Reg. Zuordnung nicht möglich\",\"\"))","v":""},null,null,null,null,null,null,"Örtliche Zuordnung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(\"WERT_Auswahl_I12\",Werte!G:H,MATCH(I11,Werte!G:G,0),FALSE)","v":"OeZ"},null,"Örtliche Zuordnung oder Überörtliche Einheiten"]
[null,{"$f":"IF(Z11=\"UeE\",\"\",IF(ISBLANK(I11),\"\",IF(ISERROR(MATCH(Z10,'Örtliche Zuordnung'!1:1,0)),\"Örtl. Zuordnung KfSt./Lkr. fehlt\",IF(ISBLANK(I12),\"Auswahlt fehlt\",\"\"))))","v":""},null,null,null,null,null,null,"Unterthürheim",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($Z$11=\"Oez\",ISERROR(MATCH($I$10,Bezirk,0))),HLOOKUP(\"Abk_\"&$Z$10,Reg_Ortsnamen,MATCH($I$12,OFFSET('Örtliche Zuordnung'!A:A,,MATCH($Z$10,'Örtliche Zuordnung'!$1:$1,0)-1),0),FALSE),IF(AND($Z$11=\"UeE\",ISERROR(MATCH($I$10,Bezirk,0)),$I$10<>$I$12),NA(),HLOOKUP(\"WERT_Landkreis\",Werte!E:F,MATCH($I$12,Werte!E:E,0),FALSE)))","v":"THHM1"},{"$f":"IF($Z$11=\"Oez\",Z12&REPT(\" \",5-LEN(Z12)),Z12&REPT(\" \",3-LEN(Z12)))","v":"THHM1"},{"$f":"IF(ISBLANK(I11),\"\",I11)","v":"Örtliche Zuordnung"},{"$f":"IF($Z$11=\"Oez\",\"09-13\",\"09-11\")","v":"09-13"}]
[null,{"$f":"IF(ISBLANK(I11),\"\",IF(AND($Z$11=\"UeE\",ISBLANK(I13)),\"Auswahlt fehlt\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($Z$11=\"Oez\",ISERROR(MATCH($I$10,Bezirk,0))),\"\",IF(AND($Z$11=\"UeE\",ISERROR(MATCH($I$10,Bezirk,0)),$I$10<>$I$12),NA(),HLOOKUP(\"WERT_Fachdienst\",Werte!I:J,MATCH($I$13,Werte!I:I,0),FALSE)))","v":""},{"$f":"Z13&REPT(\" \",1-LEN(Z13))","v":" "},{"$f":"IF($Z$11=\"UeE\",\"Fachdienstzuweisung\",\"\")","v":""},{"$f":"IF($Z$11=\"UeE\",\"12\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(I11),\"\",IF(AND($Z$11=\"UeE\",ISBLANK(I14)),\"Auswahlt fehlt\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($Z$11=\"Oez\",ISERROR(MATCH($I$10,Bezirk,0))),\"\",IF(AND($Z$11=\"UeE\",ISERROR(MATCH($I$10,Bezirk,0)),$I$10<>$I$12),NA(),HLOOKUP(\"WERT_Lfd_Nummer\",Werte!K:L,MATCH($I$14,Werte!K:K,0),FALSE)))","v":""},{"$f":"Z14&REPT(\" \",1-LEN(Z14))","v":" "},{"$f":"IF($Z$11=\"UeE\",\"Lfd. Nummer\",\"\")","v":""},{"$f":"IF($Z$11=\"UeE\",\"13\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(I15),\"Auswahlt fehlt\",\"\")","v":""},null,null,null,null,null,null,"10 – Führungs- u. Mannschaftstransportfahrzeuge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(\"Funknamen Vorauswahl\",Werte!M:N,MATCH(I15,Werte!M:M,0),FALSE)","v":"Ausw10"},null,"Vorauswahl für das Feld Funktionsbezeichnung"]
[null,{"$f":"IF(ISBLANK(I16),\"Auswahlt fehlt\",\"\")","v":""},null,null,null,null,null,null,"Mehrzweckfahrzeug",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(\"WERT_OPTA\",Werte!R:S,MATCH(I16,Werte!R:R,0),FALSE)","v":"MZF   11"},{"$f":"Z16&REPT(\" \",8-LEN(Z16))","v":"MZF   11"},"Normbezeichnung","14-21"]
[null,{"$f":"IF(ISBLANK(I17),\"Auswahlt fehlt\",\"\")","v":""},null,null,null,null,null,null,"1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(\"WERT_Lfd_Nummer\",Werte!K:L,MATCH(I17,Werte!K:K,0),FALSE)","v":"1"},{"$f":"REPT(\" \",2-LEN(Z17))&Z17","v":" 1"},"Laufende Nummer","22-23"]
[null,{"$f":"IF(ISBLANK(I18),\"Auswahlt fehlt\",\"\")","v":""},null,null,null,null,null,null,"1. fest verbautes Funkgerät",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(\"WERT_Funkgeraet\",Werte!Y:Z,MATCH(I18,Werte!Y:Y,0),FALSE)","v":""},{"$f":"Z18&REPT(\" \",1-LEN(Z18))","v":" "},"Ggf. Kennziffer 1 stellig (1-9, A-Z), z.B. Funkgerät","24"]
[]
[]
[null,"OPTA"]
[null,"01","02","03","04","05","06","07","08","09",10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,"Spalte ausblenden"]
[null,{"$f":"MID($B$31,B22,1)","v":"B"},"Y","F","W"," ","D","L","G","T","H","H","M","1","M","Z","F"," "," "," ","1","1"," ","1"," "]
[]
[]
[null,"Block\n1\nLand",null,"Block\n2\nOrganisation",null,null,"Block\n3\nReg. Zuordn.",null,null,"Block\n4.1\nÖrtliche Zuordnung",null,null,null,null,"Block\n4.2\nFunktionszuordnung",null,null,null,null,null,null,null,"Block\n4.3\nOrdKenn",null,"Bl.\n5\nErg."]
[]
[]
[]
[null,"Generierte OPTA Zeichenkette"]
[null,{"$f":"IF(ISERROR(AA7&AA8&AA10&AA12&AA16&AA17&AA18),\"xxxxxxxxxxxxxFehler !xxx\",IF($Z$11=\"Oez\",$AA7&AA8&AA10&AA12&AA16&AA17&AA18,AA7&AA8&AA10&AA12&AA13&AA14&AA16&AA17&AA18))","v":"BYFW DLGTHHM1MZF   11 1 "}]
[]
[null,"ELDIS Ausleitung"]
[null,{"$f":"IF(ISBLANK(B31),\"\",RIGHT(B31,16))","v":"THHM1MZF   11 1 "}]

{"sheet":"OPTA Tabelle","index":3,"n_rows":1001,"n_cols":3,"rows_kept":1001,"cut":false,"hidden":false,"merged":[]}
["Nr.","OPTA Tabelle","ELDIS Ausleitung"]
[{"$f":"ROW()-1","v":1},"BYFW DONALTHMMZF   11 1 ","ALTHMMZF   11 1 "]
[{"$f":"ROW()-1","v":2}]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[{"$f":"ROW()-1","v":66}]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[{"$f":"ROW()-1","v":130}]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[{"$f":"ROW()-1","v":194}]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[{"$f":"ROW()-1","v":258}]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[{"$f":"ROW()-1","v":322}]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[{"$f":"ROW()-1","v":386}]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[{"$f":"ROW()-1","v":450}]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[{"$f":"ROW()-1","v":514}]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[{"$f":"ROW()-1","v":578}]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[{"$f":"ROW()-1","v":642}]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[{"$f":"ROW()-1","v":706}]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[{"$f":"ROW()-1","v":770}]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[{"$f":"ROW()-1","v":834}]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[{"$f":"ROW()-1","v":898}]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[{"$f":"ROW()-1","v":962}]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]

{"sheet":"Werte","index":4,"n_rows":265,"n_cols":31,"rows_kept":265,"cut":false,"hidden":true,"merged":[[21,0,25,3]]}
["Organisation","Wert_Organisation","Bezirk Vorauswahl","WERT_Bezirk","Landkreis","WERT_Landkreis","Auswahlfeld Zuordnung","WERT_Auswahl_I12","Fachdienst","WERT_Fachdienst","Lfd_Nummer","WERT_Lfd_Nummer","Funktionsbezeichnung Vorauswahl","Funknamen Vorauswahl","Lfd_ANummer","WERT_Lfd_ANummer",null,"Funktionsbezeichnung","WERT_OPTA","Länge","Anz. Leerzeichen","Pos. Erstes Leerzeichen","Ordnungskennung","WERT_Ordnungskennung","Funkgeraet","WERT_Funkgeraet",null,"aus Org. OPTA-Liste",null,"Landkreis","Kfz-Kennz"]
["Arbeiter-Samariter-Bund","ASB","Mittelfranken","MFR","Bayern","BY","Örtliche Zuordnung","OeZ","Ohne Zuweisung"," ","Ohne Zuweisung"," ","00 – Einrichtungen und Funktionen","Ausw00","Ohne Zuweisung"," ","00","Einsatzleiter Bergrettung","ELBR   7",{"$f":"LEN(S2)","v":8},{"$f":"IF(LEN(S2)-LEN(SUBSTITUTE(LOWER(S2),\" \",))=0,\"\",LEN(S2)-LEN(SUBSTITUTE(LOWER(S2),\" \",)))","v":3},{"$f":"IF(ISERR(SEARCH(\" \",S2)),\"\",SEARCH(\" \",S2))","v":5},"0","0","Handsprechfunkgerät ohne Fahrzeugzuordnung","",null,"MOBWAC 0",null,"Augsburg, Kreisfreie Stadt","A"]
["Bergwacht Bayern","BGW","Niederbayern","NBY","Mittelfranken","MFR","Überörtliche Einheiten","UeE","Führung","1","1","1","10 – Führungs- u. Mannschaftstransportfahrzeuge","Ausw10","1","1","00","Einsatzleiter Rettungsdienst","ELRD   7",8,3,5,"1","1","1. Handsprechfunkgerät des Fahrzeuges","1",null,"       0",null,"Augsburg, Landkreis","A#"]
["Deutsche Lebensrettungs-Gesellschaft","DLR","Oberbayern","OBY","Ansbach, Kreisfreie Stadt","AN",null,null,"Information und Kommunikation (IuK)","2","2","2","20 – Tanklöschfahrzeuge","Ausw20","2","2","00","Einsatzleiter Wasserrettung","ELWR   7",8,3,5,"2","2","2. Handsprechfunkgerät des Fahrzeuges","2",null,"LTR    1",null,"Aschaffenburg, Kreisfreie Stadt","AB"]
["Deutsches Rotes Kreuz","DRK","Oberfranken","OFR","Ansbach, Landkreis","AN#",null,null,"Technik und Sicherheit","3","3","3","30 – Hubrettungs-, Wechsellader-, u. Kranfahrzeuge","Ausw30","3","3","00","Feuerwehreinsatzzentrale München","FEZ-M# 0",8,1,7,"3","3","3. Handsprechfunkgerät des Fahrzeuges","3",null,"LTRSTV 2",null,"Aschaffenburg, Landkreis","AB#"]
["Feuerwehr","FW ","Oberpfalz","OPF","Erlangen, Kreisfreie Stadt","ER",null,null,"Sanitätsdienst","4","4","4","40 – Lösch- und Tragkraftspritzenfahrzeuge","Ausw40","4","4","00","Feuerwehrhaus","FWH    0",8,4,4,"4","4","4. Handsprechfunkgerät des Fahrzeuges","4",null,"       3",null,"Aichach-Friedberg, Landkreis","AIC"]
["Integrierte Leitstellen","ILS","Schwaben","SBN","Erlangen-Höchstadt, Landkreis","ERH",null,null,"Suchen & Ortung","5","5","5","50 – Gerätewagen, Schlauchwagen","Ausw50","5","5","00","Funkstelle FüGK","FÜGK   0",8,3,5,"5","5","5. Handsprechfunkgerät des Fahrzeuges","5",null,"       4",null,"Amberg, Kreisfreie Stadt","AM"]
["Johanniter Unfallhilfe","JUH","Unterfranken","UFR","Fürth, Kreisfreie Stadt","FÜ",null,null,"Betreuung","6","6","6","60 – Rüst- und Gerätewagen","Ausw60","6","6","00","Funkzentrale","ZENTR  0",8,2,6,"6","6","6. Handsprechfunkgerät des Fahrzeuges","6",null,"ELTR   7",null,"Ansbach, Kreisfreie Stadt","AN"]
["Katastrophenschutzeinheiten","KAT",null,null,"Fürth, Landkreis","FÜ#",null,null,"Rettung","7","7","7","70 – Landrettungsdienst","Ausw70","7","7","00","Integrierte Leitstelle","ILS    0",8,4,4,"7","7","7. Handsprechfunkgerät des Fahrzeuges","7",null,"KONFÜ  7",null,"Ansbach, Landkreis","AN#"]
["Malteser Hilfsdienst","MHD",null,null,"Neustadt a.d.Aisch-Bad Windsheim, Landkreis","NEA",null,null,"Bergrettung","8","8","8","80 – Berg- und Höhlenrettung","Ausw80","8","8","00","Kommandant","KDT    1",8,4,4,"8","8","8. Handsprechfunkgerät des Fahrzeuges","8",null,"       8",null,"Altötting, Landkreis","AÖ"]
["Rettungshubschrauber","CHR",null,null,"Nürnberg, Kreisfreie Stadt","N",null,null,"Wasserrettung","9","9","9","90 – Wasserrettung","Ausw90","9","9","00","Kommandant-Stellvertreter (Mz.)","STVKDT 2",8,1,7,"9","9","9. Handsprechfunkgerät des Fahrzeuges","9",null,"MTW   14",null,"Amberg-Sulzbach, Landkreis","AS"]
["sonst. BOS anerk.Rettungsdienste","RD",null,null,"Nürnberger Land, Landkreis","LAU",null,null,"Brandschutz / ABC / CBRN","0","10","10",null,null,"A","A","00","Kreisbrandinspektor Bereich 1","KBI    1",8,4,4,"10","10","1. fest verbautes Funkgerät","",null,"LUFZG 15",null,"Bamberg, Kreisfreie Stadt","BA"]
["sonst. Einh. d. Kat-Schutzes ","SON",null,null,"Roth, Landkreis","RH",null,null,null,null,"11","11",null,null,"B","B","00","Kreisbrandinspektor Bereich 2","KBI    2",8,4,4,"11","11","2. fest verbautes Funkgerät","A",null,"FMKWG 16",null,"Bamberg, Landkreis","BA#"]
["Technisches Hilfswerk","THW",null,null,"Schwabach, Kreisfreie Stadt","SC",null,null,null,null,"12","12",null,null,"C","C","00","Kreisbrandinspektor Bereich 3","KBI    3",8,4,4,"12","12","3. fest verbautes Funkgerät","B",null,"       0",null,"Berchtesgadener Land, Landkreis","BGL"]
["Wasserwacht","WW",null,null,"Weißenburg-Gunzenhausen, Landkreis","WUG",null,null,null,null,"13","13",null,null,"D","D","00","Kreisbrandinspektor Bereich 4","KBI    4",8,4,4,"13","13","4. fest verbautes Funkgerät","C",null,"LTRWR  1",null,"Bayreuth, Kreisfreie Stadt","BT"]
["Werkfeuerwehr","FW",null,null,"Niederbayern","NBY",null,null,null,null,"14","14",null,null,"E","E","00","Kreisbrandinspektor Bereich 5","KBI    5",8,4,4,"14","14","5. fest verbautes Funkgerät","D",null,"LTRTEC 2",null,"Bayreuth, Landkreis","BT#"]
[null,null,null,null,"Deggendorf, Landkreis","DEG",null,null,null,null,"15","15",null,null,"F","F","00","Kreisbrandmeister Bereich 1","KBM    1",8,4,4,"15","15","6. fest verbautes Funkgerät","E",null,"ZFWR   3",null,"Cham, Landkreis","CHA"]
[null,null,null,null,"Dingolfing-Landau, Landkreis","DGF",null,null,null,null,"16","16",null,null,"G","G","00","Kreisbrandmeister Bereich 2","KBM    2",8,4,4,"16","16","7. fest verbautes Funkgerät","F",null,"ZFWR   4",null,"Coburg, Kreisfreie Stadt","CO"]
[null,null,null,null,"Freyung-Grafenau, Landkreis","FRG",null,null,null,null,"17","17",null,null,"H","H","00","Kreisbrandmeister Bereich 3","KBM    3",8,4,4,"17","17","8. fest verbautes Funkgerät","G",null,"LTRWAC 5",null,"Coburg, Landkreis","CO#"]
[null,null,null,null,"Kelheim, Landkreis","KEH",null,null,null,null,"18","18",null,null,"I","I","00","Kreisbrandmeister Bereich 4","KBM    4",8,4,4,"18","18","9. fest verbautes Funkgerät","H",null,"ELWR   7",null,"Dachau, Landkreis","DAH"]
[null,null,null,null,"Landshut, Kreisfreie Stadt","LA",null,null,null,null,"19","19",null,null,"J","J","00","Kreisbrandmeister Bereich 5","KBM    5",8,4,4,"19","19","10. fest verbautes Funkgerät","I",null,"SONSTI 9",null,"Deggendorf, Landkreis","DEG"]
["Spaltenüberschriften in Zeile 1\ndürfen NICHT geändert werden",null,null,null,"Landshut, Landkreis","LA#",null,null,null,null,"20","20",null,null,"K","K","00","Kreisbrandrat","KBR    1",8,4,4,"20","20","11. fest verbautes Funkgerät","J",null,"KDOW  10",null,"Dingolfing-Landau, Landkreis","DGF"]
[null,null,null,null,"Passau, Kreisfreie Stadt","PA",null,null,null,null,"21","21",null,null,"L","L","00","Kreiseinsatzzentrale","KEZ    0",8,4,4,"21","21","12. fest verbautes Funkgerät","K",null,"MZF   11",null,"Dillingen a.d.Donau, Landkreis","DLG"]
[null,null,null,null,"Passau, Landkreis","PA#",null,null,null,null,"22","22",null,null,"M","M","00","Leitender Notarzt","LNA    6",8,4,4,"22","22","13. fest verbautes Funkgerät","L",null,"ELW1  12",null,"Donau-Ries, Landkreis","DON"]
[null,null,null,null,"Regen, Landkreis","REG",null,null,null,null,"23","23",null,null,"N","N","00","Leiter allgem.","LTR    1",8,4,4,"23","23","14. fest verbautes Funkgerät","M",null,"MTWBH 14",null,"Ebersberg, Landkreis","EBE"]
[null,null,null,null,"Rottal-Inn, Landkreis","PAN",null,null,null,null,"24","24",null,null,"O","O","00","Leiter Bergrettung","LTRBR  1",8,2,6,"24","24","15. fest verbautes Funkgerät","N",null,"BRFZG 81",null,"Erding, Landkreis","ED"]
[null,null,null,null,"Straubing, Kreisfreie Stadt","SR",null,null,null,null,"25","25",null,null,"P","P","00","Leiter der Berufsfeuerwehr","LTRBF  1",8,2,6,"25","25","16. fest verbautes Funkgerät","O",null,"SNEFZ 82",null,"Eichstätt, Landkreis","EI"]
[null,null,null,null,"Straubing-Bogen, Landkreis","SR#",null,null,null,null,"26","26",null,null,"Q","Q","00","Leiter der Feuerwehr Stellv.","STVLTR 2",8,1,7,"26","26","17. fest verbautes Funkgerät","P",null,"HÖLFZ 83",null,"Erlangen, Kreisfreie Stadt","ER"]
[null,null,null,null,"Oberbayern","OBY",null,null,null,null,"27","27",null,null,"R","R","00","Leiter FW allgem.","LTRFW  1",8,2,6,"27","27","18. fest verbautes Funkgerät","Q",null,"NABHÖ 86",null,"Erlangen-Höchstadt, Landkreis","ERH"]
[null,null,null,null,"Altötting, Landkreis","AÖ",null,null,null,null,"28","28",null,null,"S","S","00","Leiter HAW / ständ. Wache","LTRHAW 1",8,1,7,"28","28","19. fest verbautes Funkgerät","R",null,"GWORT 87",null,"Fürstenfeldbruck, Landkreis","FFB"]
[null,null,null,null,"Bad Tölz-Wolfratshausen, Landkreis","TÖL",null,null,null,null,"29","29",null,null,"T","T","00","Leiter HiOrg","LTRSAN 1",8,1,7,"29","29","20. fest verbautes Funkgerät","S",null,"RTBG  88",null,"Forchheim, Landkreis","FO"]
[null,null,null,null,"Berchtesgadener Land, Landkreis","BGL",null,null,null,null,"30","30",null,null,"U","U","00","Leiter ILS","LTRILS 1",8,1,7,"30","30","21. fest verbautes Funkgerät","T",null,"RTCAN 88",null,"Freyung-Grafenau, Landkreis","FRG"]
[null,null,null,null,"Dachau, Landkreis","DAH",null,null,null,null,"31","31",null,null,"V","V","00","Leiter IuK","LTRIUK 8",8,1,7,"31","31","22. fest verbautes Funkgerät","U",null,"RTHÖL 88",null,"Freising, Landkreis","FS"]
[null,null,null,null,"Ebersberg, Landkreis","EBE",null,null,null,null,"32","32",null,null,"W","W","00","Leiter KatS","LTRFGK 1",{"$f":"LEN(S34)","v":8},{"$f":"IF(LEN(S34)-LEN(SUBSTITUTE(LOWER(S34),\" \",))=0,\"\",LEN(S34)-LEN(SUBSTITUTE(LOWER(S34),\" \",)))","v":1},{"$f":"IF(ISERR(SEARCH(\" \",S34)),\"\",SEARCH(\" \",S34))","v":7},"32","32","23. fest verbautes Funkgerät","V",null,"BWSON 89",null,"Fürth, Kreisfreie Stadt","FÜ"]
[null,null,null,null,"Eichstätt, Landkreis","EI",null,null,null,null,"33","33",null,null,"X","X","00","Leiter stv.","STVLTR 2",8,1,7,"33","33","24. fest verbautes Funkgerät","W",null,"FWH    0",null,"Fürth, Landkreis","FÜ#"]
[null,null,null,null,"Erding, Landkreis","ED",null,null,null,null,"34","34",null,null,"Y","Y","00","Leiter Wasserrettung","LTRWR  1",8,2,6,"34","34","25. fest verbautes Funkgerät","X",null,"FWH    0",null,"Garmisch-Partenkirchen, Landkreis","GAP"]
[null,null,null,null,"Freising, Landkreis","FS",null,null,null,null,"35","35",null,null,"Z","Z","00","mobile Wache, Container, Anhänger","MOBWAC 0",8,1,7,"35","35","26. fest verbautes Funkgerät","Y",null,"ZENTR  0",null,"Günzburg, Landkreis","GZ"]
[null,null,null,null,"Fürstenfeldbruck, Landkreis","FFB",null,null,null,null,"36","36",null,null,null,null,"00","OrgL","ORGL   6",8,3,5,"36","36","27. fest verbautes Funkgerät","Z",null,"ZENTR   ",null,"Haßberge, Landkreis","HAS"]
[null,null,null,null,"Garmisch-Partenkirchen, Landkreis","GAP",null,null,null,null,"37","37",null,null,null,null,"00","örtlicher Einsatzleiter","ÖEL    3",8,4,4,"37","37",null,null,null,"KEZ    0",null,"Hof, Kreisfreie Stadt","HO"]
[null,null,null,null,"Ingolstadt, Kreisfreie Stadt","IN",null,null,null,null,"38","38",null,null,null,null,"00","ortsfeste Funkstelle","FUNKST 0",8,1,7,"38","38",null,null,null,"FUNKST 0",null,"Hof, Landkreis","HO#"]
[null,null,null,null,"Landsberg am Lech, Landkreis","LL",null,null,null,null,"39","39",null,null,null,null,"00","sonstige Funktion","SONSTI 9",8,1,7,"39","39",null,null,null,"KDT    1",null,"Ingolstadt, Kreisfreie Stadt","IN"]
[null,null,null,null,"Miesbach, Landkreis","MB",null,null,null,null,"40","40",null,null,null,null,"00","Stadtbrandrat","SBR    1",8,4,4,"40","40",null,null,null,"KBR    1",null,"Kronach, Landkreis","KC"]
[null,null,null,null,"Mühldorf a.Inn, Landkreis","MÜ",null,null,null,null,"41","41",null,null,null,null,"00","Stadtbrandrat","SBR    1",8,4,4,"41","41",null,null,null,"LTR    1",null,"Kempten (Allgäu), Kreisfreie Stadt","KE"]
[null,null,null,null,"München, Landeshauptstadt, Kreisfreie Stadt","M",null,null,null,null,"42","42",null,null,null,null,"00","Stadtbrandrat","SBR    1",8,4,4,"42","42",null,null,null,"LTR    1",null,"Kelheim, Landkreis","KEH"]
[null,null,null,null,"München, Landkreis","M#",null,null,null,null,"43","43",null,null,null,null,"00","Stützpunkt","STÜTZP 0",8,1,7,"43","43",null,null,null,"SBR    1",null,"Kaufbeuren, Kreisfreie Stadt","KF"]
[null,null,null,null,"Neuburg-Schrobenhausen, Landkreis","ND",null,null,null,null,"44","44",null,null,null,null,"00","Taktisch-Technische Betriebsstelle","TTB    9",8,4,4,"44","44",null,null,null,"SBR    1",null,"Bad Kissingen, Landkreis","KG"]
[null,null,null,null,"Pfaffenhofen a.d.Ilm, Landkreis","PAF",null,null,null,null,"45","45",null,null,null,null,"00","techn. Leiter Wasserrettung","LTRTEC 2",8,1,7,"45","45",null,null,null,"SBR    1",null,"Kitzingen, Landkreis","KT"]
[null,null,null,null,"Rosenheim, Kreisfreie Stadt","RO",null,null,null,null,"46","46",null,null,null,null,"00","Wache","WACHE  0",8,2,6,"46","46",null,null,null,"SBR    1",null,"Kulmbach, Landkreis","KU"]
[null,null,null,null,"Rosenheim, Landkreis","RO#",null,null,null,null,"47","47",null,null,null,null,"00","weitere Führungsfunktion .3","       3",8,7,1,"47","47",null,null,null,"KDTSTV 2",null,"Landshut, Kreisfreie Stadt","LA"]
[null,null,null,null,"Starnberg, Landkreis","STA",null,null,null,null,"48","48",null,null,null,null,"00","weitere Führungsfunktion .4","       4",8,7,1,"48","48",null,null,null,"KBI    2",null,"Landshut, Landkreis","LA#"]
[null,null,null,null,"Traunstein, Landkreis","TS",null,null,null,null,"49","49",null,null,null,null,"10","Einsatzleitwagen 1","ELW1  12",8,2,5,"49","49",null,null,null,"LTRSTV 2",null,"Nürnberger Land, Landkreis","LAU"]
[null,null,null,null,"Weilheim-Schongau, Landkreis","WM",null,null,null,null,"50","50",null,null,null,null,"10","Einsatzleitwagen 1","ELW1  12",8,2,5,"50","50",null,null,null,"LTRSTV 2",null,"Lindau (Bodensee), Landkreis","LI"]
[null,null,null,null,"Oberfranken","OFR",null,null,null,null,"51","51",null,null,null,null,"10","Einsatzleitwagen 1der UG SAN EL","ELWRD 12",8,1,6,"51","51",null,null,null,"LTRSTV 2",null,"Lichtenfels, Landkreis","LIF"]
[null,null,null,null,"Bamberg, Kreisfreie Stadt","BA",null,null,null,null,"52","52",null,null,null,null,"10","Einsatzleitwagen 1 der UG ÖEL","ELWÖEL12",8,"","","52","52",null,null,null,"SBI    2",null,"Landsberg am Lech, Landkreis","LL"]
[null,null,null,null,"Bamberg, Landkreis","BA#",null,null,null,null,"53","53",null,null,null,null,"10","Einsatzleitwagen 2","ELW2  13",8,2,5,"53","53",null,null,null,"SBI    2",null,"München, Landeshauptstadt, Kreisfreie Stadt","M"]
[null,null,null,null,"Bayreuth, Kreisfreie Stadt","BT",null,null,null,null,"54","54",null,null,null,null,"10","Einsatzleitwagen 2der UG SAN EL","ELWRD 13",8,1,6,"54","54",null,null,null,"SBI    2",null,"München, Landkreis","M#"]
[null,null,null,null,"Bayreuth, Landkreis","BT#",null,null,null,null,"55","55",null,null,null,null,"10","Einsatzleitwagen 2 der UG ÖEL","ELWÖEL13",8,"","","55","55",null,null,null,"DDIENS 2",null,"Miesbach, Landkreis","MB"]
[null,null,null,null,"Coburg, Kreisfreie Stadt","CO",null,null,null,null,"56","56",null,null,null,null,"10","Fernmeldekraftwagen","FMKWG 16",8,1,6,"56","56",null,null,null,"KBM    3",null,"Miltenberg, Landkreis","MIL"]
[null,null,null,null,"Coburg, Landkreis","CO#",null,null,null,null,"57","57",null,null,null,null,"10","Fernmeldekraftwagen","FMKW  16",8,2,5,"57","57",null,null,null,"       3",null,"Memmingen, Kreisfreie Stadt","MM"]
[null,null,null,null,"Forchheim, Landkreis","FO",null,null,null,null,"58","58",null,null,null,null,"10","Feuersicherheitswache-Trupp","SIWA  18",8,2,5,"58","58",null,null,null,"SBM    3",null,"Unterallgäu, Landkreis","MN"]
[null,null,null,null,"Hof, Kreisfreie Stadt","HO",null,null,null,null,"59","59",null,null,null,null,"10","Kommandowagen","KDOW  10",8,2,5,"59","59",null,null,null,"SBM    2",null,"Main-Spessart, Landkreis","MSP"]
[null,null,null,null,"Hof, Landkreis","HO#",null,null,null,null,"60","60",null,null,null,null,"10","Kraftrad","Krad  17",8,2,5,"60","60",null,null,null,"SBM    3",null,"Mühldorf a.Inn, Landkreis","MÜ"]
[null,null,null,null,"Kronach, Landkreis","KC",null,null,null,null,"61","61",null,null,null,null,"10","Luftbeobachter","LUBEO 15",8,1,6,"61","61",null,null,null,"ZF     3",null,"Nürnberg, Kreisfreie Stadt","N"]
[null,null,null,null,"Kulmbach, Landkreis","KU",null,null,null,null,"62","62",null,null,null,null,"10","Luftfahrzeug","LUFZG 15",8,1,6,"62","62",null,null,null,"GF     4",null,"Neuburg-Schrobenhausen, Landkreis","ND"]
[null,null,null,null,"Lichtenfels, Landkreis","LIF",null,null,null,null,"63","63",null,null,null,null,"10","Luftretter","LURET 15",8,1,6,"63","63",null,null,null,"IDIENS 4",null,"Neustadt a.d.Aisch-Bad Windsheim, Landkreis","NEA"]
[null,null,null,null,"Wunsiedel i.Fichtelgebirge, Landkreis","WUN",null,null,null,null,"64","64",null,null,null,null,"10","Mannschaftstransportwagen","MTW   14",{"$f":"LEN(S66)","v":8},{"$f":"IF(LEN(S66)-LEN(SUBSTITUTE(LOWER(S66),\" \",))=0,\"\",LEN(S66)-LEN(SUBSTITUTE(LOWER(S66),\" \",)))","v":3},{"$f":"IF(ISERR(SEARCH(\" \",S66)),\"\",SEARCH(\" \",S66))","v":4},"64","64",null,null,null,"       4",null,"Rhön-Grabfeld, Landkreis","NES"]
[null,null,null,null,"Oberpfalz","OPF",null,null,null,null,"65","65",null,null,null,null,"10","Mehrzweckfahrzeug","MZF   11",8,3,4,"65","65",null,null,null,"WALEIT 5",null,"Neustadt a.d.Waldnaab, Landkreis","NEW"]
[null,null,null,null,"Amberg, Kreisfreie Stadt","AM",null,null,null,null,"66","66",null,null,null,null,"10","MTW Betreuung","MTWBT 14",8,1,6,"66","66",null,null,null,"WALEIT 5",null,"Neumarkt i.d.OPf., Landkreis","NM"]
[null,null,null,null,"Amberg-Sulzbach, Landkreis","AS",null,null,null,null,"67","67",null,null,null,null,"10","MTW Sanitätsdienst","MTWSAN14",8,"","","67","67",null,null,null,"WAEIFÜ 6",null,"Neu-Ulm, Landkreis","NU"]
[null,null,null,null,"Cham, Landkreis","CHA",null,null,null,null,"68","68",null,null,null,null,"20","Flugfeldlöschfahrzeug","FLF   29",8,3,4,"68","68",null,null,null,"ZF     6",null,"Oberallgäu, Landkreis","OA"]
[null,null,null,null,"Neumarkt i.d.OPf., Landkreis","NM",null,null,null,null,"69","69",null,null,null,null,"20","Sonderlöschmittelfahrzeug","LFSON 27",8,1,6,"69","69",null,null,null,"ZF     6",null,"Ostallgäu, Landkreis","OAL"]
[null,null,null,null,"Neustadt a.d.Waldnaab, Landkreis","NEW",null,null,null,null,"70","70",null,null,null,null,"20","Sondertanklöschfahrzeug","TLFSON29",8,"","","70","70",null,null,null,"WAZF   6",null,"Passau, Kreisfreie Stadt","PA"]
[null,null,null,null,"Regensburg, Kreisfreie Stadt","R",null,null,null,null,"71","71",null,null,null,null,"20","Tanklöschfahrzeug 16 / 25","TLF25 21",8,1,6,"71","71",null,null,null,"ELTR   7",null,"Passau, Landkreis","PA#"]
[null,null,null,null,"Regensburg, Landkreis","R#",null,null,null,null,"72","72",null,null,null,null,"20","Tanklöschfahrzeug 16 / 25 mit Rettungssatz","TLF25 20",8,1,6,"72","72",null,null,null,"EVD    7",null,"Pfaffenhofen a.d.Ilm, Landkreis","PAF"]
[null,null,null,null,"Schwandorf, Landkreis","SAD",null,null,null,null,"73","73",null,null,null,null,"20","Tanklöschfahrzeug 16/24","TLF24 22",8,1,6,"73","73",null,null,null,"EVD    7",null,"Rottal-Inn, Landkreis","PAN"]
[null,null,null,null,"Tirschenreuth, Landkreis","TIR",null,null,null,null,"74","74",null,null,null,null,"20","Tanklöschfahrzeug 2000","TLF20 22",8,1,6,"74","74",null,null,null,"EVD    7",null,"Regensburg, Kreisfreie Stadt","R"]
[null,null,null,null,"Weiden i.d.OPf., Kreisfreie Stadt","WEN",null,null,null,null,"75","75",null,null,null,null,"20","Tanklöschfahrzeug 24/48","TLF48 23",8,1,6,"75","75",null,null,null,"EVD    7",null,"Regensburg, Landkreis","R#"]
[null,null,null,null,"Schwaben","SBN",null,null,null,null,"76","76",null,null,null,null,"20","Tanklöschfahrzeug 24/50","TLF50 23",8,1,6,"76","76",null,null,null,"SGL    8",null,"Regen, Landkreis","REG"]
[null,null,null,null,"Aichach-Friedberg, Landkreis","AIC",null,null,null,null,"77","77",null,null,null,null,"20","Tanklöschfahrzeug 3000","TLF30 21",8,1,6,"77","77",null,null,null,"SGL    8",null,"Roth, Landkreis","RH"]
[null,null,null,null,"Augsburg, Kreisfreie Stadt","A",null,null,null,null,"78","78",null,null,null,null,"20","Tanklöschfahrzeug 8/18","TLF18 22",8,1,6,"78","78",null,null,null,"SONSTI 9",null,"Rosenheim, Kreisfreie Stadt","RO"]
[null,null,null,null,"Augsburg, Landkreis","A#",null,null,null,null,"79","79",null,null,null,null,"20","TLF 4000","TLF40 23",8,1,6,"79","79",null,null,null,"SONSTI 9",null,"Rosenheim, Landkreis","RO#"]
[null,null,null,null,"Dillingen a.d.Donau, Landkreis","DLG",null,null,null,null,"80","80",null,null,null,null,"20","Trockenlöschfahrzeug","TROLF 25",8,1,6,"80","80",null,null,null,"SONSTI 9",null,"Schwandorf, Landkreis","SAD"]
[null,null,null,null,"Donau-Ries, Landkreis","DON",null,null,null,null,"81","81",null,null,null,null,"30","Bagger","BAGGER39",8,"","","81","81",null,null,null,"SONSTI 9",null,"Schwabach, Kreisfreie Stadt","SC"]
[null,null,null,null,"Günzburg, Landkreis","GZ",null,null,null,null,"82","82",null,null,null,null,"30","Drehleiter 12/9mit Korb","DLK12 32",8,1,6,"82","82",null,null,null,"SONSTI 9",null,"Straubing, Kreisfreie Stadt","SR"]
[null,null,null,null,"Kaufbeuren, Kreisfreie Stadt","KF",null,null,null,null,"83","83",null,null,null,null,"30","Drehleiter 12/9 ohne Korb","DL 12 32",8,2,3,"83","83",null,null,null,"SONSTI 9",null,"Straubing-Bogen, Landkreis","SR#"]
[null,null,null,null,"Kempten (Allgäu), Kreisfreie Stadt","KE",null,null,null,null,"84","84",null,null,null,null,"30","Drehleiter 16/4 mit Korb","DLK16 32",8,1,6,"84","84",null,null,null,"KDOW  10",null,"Starnberg, Landkreis","STA"]
[null,null,null,null,"Lindau (Bodensee), Landkreis","LI",null,null,null,null,"85","85",null,null,null,null,"30","Drehleiter 16/4 ohne Korb","DL 16 32",8,2,3,"85","85",null,null,null,"MZF   11",null,"Schweinfurt, Kreisfreie Stadt","SW"]
[null,null,null,null,"Memmingen, Kreisfreie Stadt","MM",null,null,null,null,"86","86",null,null,null,null,"30","Drehleiter 18/12 mit Korb","DLK18 31",8,1,6,"86","86",null,null,null,"ELW1  12",null,"Schweinfurt, Landkreis","SW#"]
[null,null,null,null,"Neu-Ulm, Landkreis","NU",null,null,null,null,"87","87",null,null,null,null,"30","Drehleiter 18/12 ohne Korb","DL 18 31",8,2,3,"87","87",null,null,null,"ELW2  13",null,"Tirschenreuth, Landkreis","TIR"]
[null,null,null,null,"Oberallgäu, Landkreis","OA",null,null,null,null,"88","88",null,null,null,null,"30","Drehleiter 23/12 mit Korb","DLK23 30",8,1,6,"88","88",null,null,null,"MTW   14",null,"Bad Tölz-Wolfratshausen, Landkreis","TÖL"]
[null,null,null,null,"Ostallgäu, Landkreis","OAL",null,null,null,null,"89","89",null,null,null,null,"30","Drehleiter 23/12 ohne Korb","DL 23 30",8,2,3,"89","89",null,null,null,"LUBEO 15",null,"Traunstein, Landkreis","TS"]
[null,null,null,null,"Unterallgäu, Landkreis","MN",null,null,null,null,"90","90",null,null,null,null,"30","Gelenkmast","GMXY  33",8,2,5,"90","90",null,null,null,"FMKWG 16",null,"Weiden i.d.OPf., Kreisfreie Stadt","WEN"]
[null,null,null,null,"Unterfranken","UFR",null,null,null,null,"91","91",null,null,null,null,"30","Kranwagen","KWXY  34",8,2,5,"91","91",null,null,null,"SIWA  18",null,"Weilheim-Schongau, Landkreis","WM"]
[null,null,null,null,"Aschaffenburg, Kreisfreie Stadt","AB",null,null,null,null,"92","92",null,null,null,null,"30","Rettungstreppe","RTREPE38",8,"","","92","92",null,null,null,"TLF25 21",null,"Würzburg, Kreisfreie Stadt","WÜ"]
[null,null,null,null,"Aschaffenburg, Landkreis","AB#",null,null,null,null,"93","93",null,null,null,null,"30","sonstiges Hubrettungsfahrzeug","HRFSON33",8,"","","93","93",null,null,null,"TLF30 21",null,"Würzburg, Landkreis","WÜ#"]
[null,null,null,null,"Bad Kissingen, Landkreis","KG",null,null,null,null,"94","94",null,null,null,null,"30","Stapler","STAPL 39",8,1,6,"94","94",null,null,null,"TLF24 22",null,"Weißenburg-Gunzenhausen, Landkreis","WUG"]
[null,null,null,null,"Haßberge, Landkreis","HAS",null,null,null,null,"95","95",null,null,null,null,"30","Teleskopgelenkmast","TGMXY 33",8,1,6,"95","95",null,null,null,"TLF20 22",null,"Wunsiedel i.Fichtelgebirge, Landkreis","WUN"]
[null,null,null,null,"Kitzingen, Landkreis","KT",null,null,null,null,"96","96",null,null,null,null,"30","Teleskoplader","TLADER39",{"$f":"LEN(S98)","v":8},{"$f":"IF(LEN(S98)-LEN(SUBSTITUTE(LOWER(S98),\" \",))=0,\"\",LEN(S98)-LEN(SUBSTITUTE(LOWER(S98),\" \",)))","v":""},{"$f":"IF(ISERR(SEARCH(\" \",S98)),\"\",SEARCH(\" \",S98))","v":""},"96","96",null,null,null,"TLF18 22"]
[null,null,null,null,"Main-Spessart, Landkreis","MSP",null,null,null,null,"97","97",null,null,null,null,"30","Teleskopmast","TMXY  33",8,2,5,"97","97",null,null,null,"TLF48 23"]
[null,null,null,null,"Miltenberg, Landkreis","MIL",null,null,null,null,"98","98",null,null,null,null,"30","Wechselladerfahrzeug (kurz mit Kran)","WLFK  35",8,2,5,"98","98",null,null,null,"TLF50 23"]
[null,null,null,null,"Rhön-Grabfeld, Landkreis","NES",null,null,null,null,"99","99",null,null,null,null,"30","Wechselladerfahrzeug (kurz, ohne Kran)","WLF   35",8,3,4,"99","99",null,null,null,"TLF40 23"]
[null,null,null,null,"Schweinfurt, Kreisfreie Stadt","SW",null,null,null,null,null,null,null,null,null,null,"30","Wechselladerfahrzeug (lang mit Kran)","WLFLK 36",8,1,6,null,null,null,null,null,"TROLF 25"]
[null,null,null,null,"Schweinfurt, Landkreis","SW#",null,null,null,null,null,null,null,null,null,null,"30","Wechselladerfahrzeug (lang, ohne Kran)","WLFL  36",8,2,5,null,null,null,null,null,"LFSON 27"]
[null,null,null,null,"Würzburg, Kreisfreie Stadt","WÜ",null,null,null,null,null,null,null,null,null,null,"40","Hilfeleistungslöschgruppenfahrzeug 10","HLF10 42",8,1,6,null,null,null,null,null,"TLFSO 29"]
[null,null,null,null,"Würzburg, Landkreis","WÜ#",null,null,null,null,null,null,null,null,null,null,"40","Hilfeleistungslöschgruppenfahrzeug 20","HLF20 40",8,1,6,null,null,null,null,null,"DLK23 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Kleinlöschfahrzeug","KLF   49",8,3,4,null,null,null,null,null,"DL 23 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","LF-Katastrophenschutz","LFKat 41",8,1,6,null,null,null,null,null,"DLK18 31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug 10/6 mit Rettungssatz","LF10  42",8,2,5,null,null,null,null,null,"DL 18 31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug 10/6 ohne Rettungssatz","LF10  43",8,2,5,null,null,null,null,null,"DLK12 32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug 16/12 ohne Rettungssatz","LF16  41",8,2,5,null,null,null,null,null,"DL 12 32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug 16-12 mit Rettungssatz","LF16  40",8,2,5,null,null,null,null,null,"DLK12 32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug 8/6 mit Rettungssatz","LF86  42",8,2,5,null,null,null,null,null,"DL 12 32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug 8/6 ohne Rettungssatz","LF86  43",8,2,5,null,null,null,null,null,"GMXY  33"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug LF 20 ohne Rettungssatz","LF20  41",8,2,5,null,null,null,null,null,"SONST 33"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug LF10","LF10  43",8,2,5,null,null,null,null,null,"TMXY  33"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug LF16-TS","LF16TS48",8,"","",null,null,null,null,null,"KWXY  34"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug LF8-1","LF8 1 48",8,2,4,null,null,null,null,null,"WLFK  35"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Löschgruppenfahrzeug LF8-2","LF8 2 48",8,2,4,null,null,null,null,null,"WLF   35"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","mittleres Löschfahrzeug","MLF   47",8,3,4,null,null,null,null,null,"WLFLK 36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","sonstiges Löschfahrzeug","LFSON 49",8,1,6,null,null,null,null,null,"WLFL  36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Staffellöschfahrzeug","STLF  47",8,2,5,null,null,null,null,null,"BAGER 39"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Tragkraftspritzenanhänger","TSA   45",8,3,4,null,null,null,null,null,"STAPL 39"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Tragkraftspritzenfahrzeug","TSF   44",8,3,4,null,null,null,null,null,"HLF20 40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Tragkraftspritzenfahrzeug mit Preßluftatmern","TSFPA 44",8,1,6,null,null,null,null,null,"LF16  40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40","Tragkraftspritzenfahrzeug-Wasser","TSFW  46",8,2,5,null,null,null,null,null,"LF16  40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Betreuungs LKW","LKWBT 56",8,1,6,null,null,null,null,null,"LF20  40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen","GW    50",8,4,3,null,null,null,null,null,"LF16TS41"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen Atemschutz","GWA   53",8,3,4,null,null,null,null,null,"HLF10 42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen Atemschutz / Strahlenschutz","GWAS  53",8,2,5,null,null,null,null,null,"LFKAT 42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen Gefahrgut","GWG   52",{"$f":"LEN(S130)","v":8},{"$f":"IF(LEN(S130)-LEN(SUBSTITUTE(LOWER(S130),\" \",))=0,\"\",LEN(S130)-LEN(SUBSTITUTE(LOWER(S130),\" \",)))","v":3},{"$f":"IF(ISERR(SEARCH(\" \",S130)),\"\",SEARCH(\" \",S130))","v":4},null,null,null,null,null,"LF106 42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen GSG","GWGSG 52",8,1,6,null,null,null,null,null,"LF86  42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen Höhenrettung","GWHÖRG59",8,"","",null,null,null,null,null,"LF8   43"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen Logistik 1","GWL1  55",8,2,5,null,null,null,null,null,"TSF   44"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen Logistik 2","GWL2  56",8,2,5,null,null,null,null,null,"TSFPA 44"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen Öl","GWÖL  51",8,2,5,null,null,null,null,null,"TSA   45"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen sonstiger","GWSON 59",8,1,6,null,null,null,null,null,"TSFW  46"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen Strahlenschutz","GWS…53",6,"","",null,null,null,null,null,"MLF   47"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Gerätewagen Technik u Sicherheit","GWTUS 53",8,1,6,null,null,null,null,null,"STLF  47"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","GW Tierrettung","GWTIER59",8,"","",null,null,null,null,null,"LFSON 49"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","GW Tiertransport","GWTTSP59",8,"","",null,null,null,null,null,"GW    50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","GW Umwelt","GWUMWT59",8,"","",null,null,null,null,null,"KRAD  50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","GW-San 25","GWS25 54",8,1,6,null,null,null,null,null,"PKW   50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","GW-San 50","GWS50 55",8,1,6,null,null,null,null,null,"PKW   50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Lastkraftwagen < 7,5 to.","LKW   55",8,3,4,null,null,null,null,null,"VAN   50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Lastkraftwagen > 7,5 to.","LKW   56",8,3,4,null,null,null,null,null,"GWÖL  51"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Personenkraftwagen","PKW   50",8,3,4,null,null,null,null,null,"RWÖL  51"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Personenkraftwagen (Kombi)","PKW   50",8,3,4,null,null,null,null,null,"GWGSG 52"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Rüstwagen Öl","RWÖl  51",8,2,5,null,null,null,null,null,"GWG   52"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Schlauchwagen 1000","SW100057",8,"","",null,null,null,null,null,"GWA   53"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50","Schlauchwagen 2000","SW200058",8,"","",null,null,null,null,null,"GWAS  53"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","ABC-Erkunder","ABCER 66",8,1,6,null,null,null,null,null,"GWS   53"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Dekontaminationsmehrzweckfahrzeug","DMF   67",8,3,4,null,null,null,null,null,"GWL1  55"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Gerätewagen Dekon-P","DEKONP67",8,"","",null,null,null,null,null,"LKW   55"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Gerätewagen Dekon-V","DEKONV68",8,"","",null,null,null,null,null,"GWL2  56"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Gerätewagen Meßtechnik","GWMESS 6",8,1,7,null,null,null,null,null,"LKW   56"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Kleinalarmfahrzeug","KLAF  65",8,2,5,null,null,null,null,null,"SW100057"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Lichtmastfahrzeug","LIMA  63",8,2,5,null,null,null,null,null,"SW200058"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Rüstwagen (neue Norm)","RW …  61",8,3,3,null,null,null,null,null,"GWSON 59"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Rüstwagen (sonstiger)","RWSON 63",8,1,6,null,null,null,null,null,"GWTIER59"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Rüstwagen 1","RW1   62",8,3,4,null,null,null,null,null,"GWTTSP59"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Rüstwagen 2","RW2   61",8,3,4,null,null,null,null,null,"GWUMWT59"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Rüstwagen 3","RW3   60",{"$f":"LEN(S162)","v":8},{"$f":"IF(LEN(S162)-LEN(SUBSTITUTE(LOWER(S162),\" \",))=0,\"\",LEN(S162)-LEN(SUBSTITUTE(LOWER(S162),\" \",)))","v":3},{"$f":"IF(ISERR(SEARCH(\" \",S162)),\"\",SEARCH(\" \",S162))","v":4},null,null,null,null,null,"RW    60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Stromgeneratorfahrzeug","GENERA63",8,"","",null,null,null,null,null,"RW3   60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60","Vorausrüstwagen","VRW   62",8,3,4,null,null,null,null,null,"RW2   61"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Arzttruppwagen","ATW   77",8,3,4,null,null,null,null,null,"RW1   62"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","First Responder","FIRST 79",8,1,6,null,null,null,null,null,"VRW   62"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Großraum-Rettungswagen","GRTW  76",8,2,5,null,null,null,null,null,"LIMA  63"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Helfer vor Ort","HVO   79",8,3,4,null,null,null,null,null,"RWSON 63"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Infektions-Rettungswagen","IRTW  71",8,2,5,null,null,null,null,null,"GENERA63"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Intensiv-Transportwagen","ITW   70",8,3,4,null,null,null,null,null,"KLAF  65"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Krankentransportwagen","KTW   72",8,3,4,null,null,null,null,null,"ABCER 66"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Krankentransportwagen 4 Tragen","KTW4T 73",8,1,6,null,null,null,null,null,"GWMES 66"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Krankentransportwagen Typ B","KTWB  73",8,2,5,null,null,null,null,null,"DMF   67"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Notarzteinsatzfahrzeug","NEF   76",8,3,4,null,null,null,null,null,"FIRST 79"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Notarztwagen","NAW   70",8,3,4,null,null,null,null,null,"SANLTR 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","organisationseigener KTW (SEG)","KTW   72",8,3,4,null,null,null,null,null,"SNLTSV 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","organisationseigener RTW (SEG)","RTW   71",8,3,4,null,null,null,null,null,"SANZF  3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Rettungswagen","RTW   71",8,3,4,null,null,null,null,null,"SANGF  4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","SAN-Trupp","SANTR 78",8,1,6,null,null,null,null,null,"SANLTR 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Schwerlast-Rettungswagen","SRTW  71",8,2,5,null,null,null,null,null,"SONSTI 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","sonstiges Rettungsdienstfahrzeug","RDSON 74",8,1,6,null,null,null,null,null,"KDOW  10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70","Verlegungsarzteinsatzfahrzeug","VEF   76",8,3,4,null,null,null,null,null,"MZF   11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80","Bergrettungsfahrzeug","BRFZG 81",8,1,6,null,null,null,null,null,"ELW2  13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80","Canyon- / Höhlenretter","CRHÖR 87",8,1,6,null,null,null,null,null,"MTW   14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80","Gerätewagen Höhlen / Bergrettung","GWBHÖ 84",8,1,6,null,null,null,null,null,"MTWBT 14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80","Gerätewagen LKLD","GWLKLD83",8,"","",null,null,null,null,null,"MTWSA 14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80","Notarzt Berg- / Höhlenrettung","NABHÖ 86",8,1,6,null,null,null,null,null,"KOMBI 50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80","Schneefahrzeug Bergrettung","SNEFZ 82",8,1,6,null,null,null,null,null,"GWGSG 52"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80","sonstiges Einsatzmittel Bergwacht","BWSON 89",8,1,6,null,null,null,null,null,"GWT&S 53"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80","Such / Lawinenteam","SUCH  85",8,2,5,null,null,null,null,null,"GWS25 54"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","Boot","BOOT  99",8,2,5,null,null,null,null,null,"GWS50 55"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","Geländefahrzeug Wasserrettung","ATVWR 95",8,1,6,null,null,null,null,null,"LKWBT 56"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","Gerätewagen Boot","GWBOOT91",8,"","",null,null,null,null,null,"RTW   71"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","GW Taucher","GWTAU 91",{"$f":"LEN(S194)","v":8},1,6,null,null,null,null,null,"KTW   72"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","GW Wasserrettung","GWWR  91",8,2,5,null,null,null,null,null,"KTW4T 73"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","Kommandowagen Wasserrettung","KDOWWR90",null,null,null,null,null,null,null,null,"KTWB  73"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","MTW-Wasserrettung","MTWWR 94",null,null,null,null,null,null,null,null,"ATV   75"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","Rettungsschwimmer","WASRRS98",null,null,null,null,null,null,null,null,"ATW   77"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","sonstiges Einsatzfahrzeug Wasserrettung","WRSONS92",null,null,null,null,null,null,null,null,"SANTR 78"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","Streife","WASRST98",null,null,null,null,null,null,null,null,"HVO   79"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","Wasserretter","WASRRT98",null,null,null,null,null,null,null,null,"LTR    1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","Wasserrettung Trupp","WASRTR98",null,null,null,null,null,null,null,null,"LTRSTV 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90","Zubringer PKW Wasserrettung","PKWWR 90",null,null,null,null,null,null,null,null,"LDF    3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHTLTR 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SYSADM 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONSTI 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUEGK  0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTRFGK 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTRSTV 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTRSB  4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACHBE 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ÖEL    7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONSTI 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KDOW  10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MZF   11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELWÖEL12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELW2  13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MTW   14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LUFZG 15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FMKWG 16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LNA    1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTR    1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA     2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTRSTV 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALEIT 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELRD   7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORGLRD 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONSTI 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KDOW  10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MZF   11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELWRD 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELW2  13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MTWRD 14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTH   15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FMKWG 16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRTW  71"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRTW  71"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITW   71"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NAW   71"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTW   71"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRTW  71"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KTW   72"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEF   76"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VEF   76"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTRWR  1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTRTEC 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZFWR   3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZFWR   4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTRWAC 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOOTFÜ 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELWR   7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONSTI 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KDOW  10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MZF   11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELW1  12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MTWWR 14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LURET 15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GWTAU 91"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GWWR  91"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTWAS 98"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOOT  99"]

{"sheet":"Formeln","index":5,"n_rows":48,"n_cols":2,"rows_kept":48,"cut":false,"hidden":true,"merged":[[39,0,44,0],[13,0,16,0],[47,0,51,0]]}
["Datenquelle für I8 - Auswahl Organisation"]
["=Organisation","Bereich \"Organisation\" in Tab.Blatt \"Werte\""]
[]
["Datenquelle für I9 - Vorauswahl für Landkeis"]
["=Bezirk","Bereich \"Bezirk\" in Tab.Blatt \"Werte\""]
[]
["Datenquelle für I10 - Landkeis"]
["=INDIREKT($I$9)","Bereich \"Lkr. pro Bezirk\" in Tab.Blatt \"Werte\""]
[]
["Datenquelle für I11 - Vorauswahl regionale / überörtliche Zuordnung"]
["=Auswahl_Zuordnung","Bereich \"Auswahl_Zuordnung\" in Tab.Blatt \"Werte\""]
[]
["Datenquelle für I12 - Regionale / überörtliche Zuordnung"]
["=WENN($Z$11=\"OeZ\";\n     BEREICH.VERSCHIEBEN('Örtliche Zuordnung'!$A$1;1;VERGLEICH($Z$10;'Örtliche Zuordnung'!$1:$1;0)-1;\n     ANZAHL2(BEREICH.VERSCHIEBEN('Örtliche Zuordnung'!$A:$A;;VERGLEICH($Z$10;'Örtliche Zuordnung'!$1:$1;0)-1))-1);\nINDIREKT($I$9))"]
[null,"Bereich \"Regionale Ortsnamen\" in Tab.Blatt \"OPTA Generator\""]
[null,"Bereich \"Lkr. im Bezirk\" in Tab.Blatt \"Werte\""]
[]
[]
["Datenquelle für I13 - Fachdienstzuweisung"]
["=WENN($Z$11=\"OeZ\";$AA$1;Fachdienst)","Bereich \"Fachdienst\" in Tab.Blatt \"Werte\""]
[]
["Datenquelle für I14 - Lfd. Nummer"]
["=WENN($Z$11=\"OeZ\";$AA$1;Lfd_Nummer_9)","Bereich \"Lfd_Nummer_9\" in Tab.Blatt \"Werte\""]
[]
["Datenquelle für I15 - Vorauswahl für Funktionsbezeichnung"]
["=Funktionsbezeichnung_Vorauswahl","Bereich \"Funktionsbezeichnung_Vorauswahl\" in Tab.Blatt \"Werte\""]
[]
["Datenquelle für I16 - Normbezeichnung"]
["=INDIREKT($Z$15)","Bereich \"Teil_Funktionsbezeichnung\" in Tab.Blatt \"Werte\""]
[]
["Datenquelle für I17 - Lfd. Nummer"]
["=Lfd_Nummer_99","Bereich \"Lfd_Nummer_99\" in Tab.Blatt \"Werte\""]
[]
["Datenquelle für I18 - Kennziffer"]
["=Funkgeraet","Bereich \"Funkgeraet\" in Tab.Blatt \"Werte\""]
[]
[]
[]
["Prüfung für I10 - Landkreis"]
["=WENN(ISTLEER(I10);\"Auswahlt fehlt\";\nWENN(ODER(ISTLEER(I11);ISTLEER(I12));\"\";\nWENN(UND(NICHT(ISTFEHLER(VERGLEICH($I$12;Bezirk;0)));ISTFEHLER(VERGLEICH($I$10;Bezirk;0)));\"Landkreis nicht möglich\";\nWENN(UND($Z$11=\"ReZ\";NICHT(ISTFEHLER(VERGLEICH($I$10;Bezirk;0))));\"Regierungsbezirk nicht möglich\";\nWENN(UND($Z$11=\"UeE\";ISTFEHLER(VERGLEICH($I$10;Bezirk;0));$I$10<>$I$12);\"Landkreise unterschiedlich\";\"\")))))","Keine Auswahl Landkreis"]
[null,"Keine Auswahl ReZ / UeE"]
[]
[]
[]
[]
[]
["Formel für Z12 - Regionale / überörtliche Zuordnung"]
["=WENN(UND($Z$11=\"Oez\";ISTFEHLER(VERGLEICH($I$10;Bezirk;0)));\n     WVERWEIS(\"Abk_\"&$Z$10;Reg_Ortsnamen;VERGLEICH($I$12;BEREICH.VERSCHIEBEN('Örtliche Zuordnung'!A:A;;VERGLEICH($Z$10;'Örtliche Zuordnung'!$1:$1;0)-1);0);FALSCH);\nWENN(UND($Z$11=\"UeE\";ISTFEHLER(VERGLEICH($I$10;Bezirk;0));$I$10<>$I$12);\n     NV();\n          WVERWEIS(\"WERT_Landkreis\";Werte!E:F;VERGLEICH($I$12;Werte!E:E;0);FALSCH)))","Prüfung: "]

{"sheet":"Version","index":6,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Version","Datum","Bearbeiter","Änderungen"]