{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Tabelle1","Tabelle2","Tabelle3","Tabelle4","Tabelle5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Tabelle1","index":0,"n_rows":64,"n_cols":17,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,0,3,0],[5,0,8,0],[63,0,65,6],[45,5,62,5],[25,5,44,5],[25,6,27,6],[25,0,27,0],[25,1,27,1],[25,2,27,2],[25,3,27,3],[25,4,27,4]]}
[null,{"$f":"Tabelle2!$A$3","v":1981}]
[null,{"$f":"SUM(K2+1979)","v":1984},null,null,null,null,null,null,null,null,5]
[]
[null,null,null,null,null,null,null,null,null,null,19]
[]
[null,{"$f":"SUM(K4+1999)","v":2018}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Jahr","Ihr Alter","möglicheErsatzpflicht\n(Alter)","möglicheErsatzpflicht\n(Neubürger)","Ersatzpflicht","Altes Ersatzrecht (WPEG)","Bemerkungen"]
[]
[null,null,null,null,null,null,null,null,null,null,"Ergebnis","zu jung","zu alt (alt)"]
[2001,{"$f":"IF(AND(SUM((A29-$B$2)<=37>=20)),SUM(A29-$B$2),\"\")","v":17},{"$f":"IF(K29=\"00\",\"1\",\"2\")","v":"2"},{"$f":"IF($B$6>$A29,\"2\",\"1\")","v":"2"},{"$f":"IF(C29+D29<3,\"JA\",\"NEIN\")","v":"NEIN"},null,{"$f":"IF(J29=12,\"letzte Ersatzabgabe (11) - Wehrpflicht erfüllt\",\"\")","v":""},null,{"$f":"IF(E29=\"JA\",1,\"\")","v":""},{"$f":"SUM(H29:I29)","v":0},{"$f":"CONCATENATE(L29,M29)","v":"10"},{"$f":"IF($B29<20,1,0)","v":1},{"$f":"IF($B29>=31,1,0)","v":0}]
[2002,18,"2","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I30)>11,\"\",SUM($I$29:I30))","v":0},"",{"$f":"SUM(H30:I30)","v":0},{"$f":"CONCATENATE(L30,M30)","v":"10"},1,0]
[2003,19,"2","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I31)>11,\"\",SUM($I$29:I31))","v":0},"",0,"10",1,0]
[2004,20,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I32)>11,\"\",SUM($I$29:I32))","v":0},"",0,"00",0,0]
[2005,21,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I33)>11,\"\",SUM($I$29:I33))","v":0},"",0,"00",0,0]
[2006,22,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I34)>11,\"\",SUM($I$29:I34))","v":0},"",0,"00",0,0]
[2007,23,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I35)>11,\"\",SUM($I$29:I35))","v":0},"",0,"00",0,0]
[2008,24,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I36)>11,\"\",SUM($I$29:I36))","v":0},"",0,"00",0,0]
[2009,25,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I37)>11,\"\",SUM($I$29:I37))","v":0},"",0,"00",0,0]
[2010,26,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I38)>11,\"\",SUM($I$29:I38))","v":0},"",0,"00",0,0]
[2011,27,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I39)>11,\"\",SUM($I$29:I39))","v":0},"",0,"00",0,0]
[2012,28,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I40)>11,\"\",SUM($I$29:I40))","v":0},"",0,"00",0,0]
[2013,29,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I41)>11,\"\",SUM($I$29:I41))","v":0},"",0,"00",0,0]
[2014,30,"1","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I42)>11,\"\",SUM($I$29:I42))","v":0},"",0,"00",0,0]
[2015,31,"2","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I43)>11,\"\",SUM($I$29:I43))","v":0},"",0,"01",0,1]
[2016,32,"2","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I44)>11,\"\",SUM($I$29:I44))","v":0},"",0,"01",0,1]
[2017,33,"2","2","NEIN",null,"",{"$f":"IF(SUM($I$29:I45)>11,\"\",SUM($I$29:I45))","v":0},"",0,"01",0,1,null,null,null,"Gesetzesänderung per 01.01.2019 (Ersatzjahr 2018)"]
[2018,34,"1","1","JA","Neues Ersatzrecht (WPEG)","",{"$f":"IF(SUM($I$29:I46)>11,\"\",SUM($I$29:I46))","v":1},1,2,"00",{"$f":"IF($B46<19,1,0)","v":0},{"$f":"IF($B46>37,1,0)","v":0}]
[2019,35,"1","1","JA",null,"",{"$f":"IF(SUM($I$29:I47)>11,\"\",SUM($I$29:I47))","v":2},1,3,"00",0,0]
[2020,36,"1","1","JA",null,"",{"$f":"IF(SUM($I$29:I48)>11,\"\",SUM($I$29:I48))","v":3},1,4,"00",0,0]
[2021,37,"1","1","JA",null,"",{"$f":"IF(SUM($I$29:I49)>11,\"\",SUM($I$29:I49))","v":4},1,5,"00",0,0]
[2022,38,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I50)>11,\"\",SUM($I$29:I50))","v":4},"",4,"01",0,1]
[2023,39,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I51)>11,\"\",SUM($I$29:I51))","v":4},"",4,"01",0,1]
[2024,40,"2","1",{"$f":"IF(C52+D52<3,\"JA\",\"NEIN\")","v":"NEIN"},null,{"$f":"IF(J52=12,\"letzte Ersatzabgabe (11) - Wehrpflicht erfüllt\",\"\")","v":""},{"$f":"IF(SUM($I$29:I52)>11,\"\",SUM($I$29:I52))","v":4},"",{"$f":"SUM(H52:I52)","v":4},{"$f":"CONCATENATE(L52,M52)","v":"01"},{"$f":"IF($B52<19,1,0)","v":0},{"$f":"IF($B52>37,1,0)","v":1}]
[2025,41,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I53)>11,\"\",SUM($I$29:I53))","v":4},"",4,"01",0,1]
[2026,42,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I54)>11,\"\",SUM($I$29:I54))","v":4},"",4,"01",0,1]
[2027,43,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I55)>11,\"\",SUM($I$29:I55))","v":4},"",4,"01",0,1]
[2028,44,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I56)>11,\"\",SUM($I$29:I56))","v":4},"",4,"01",0,1]
[2029,45,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I57)>11,\"\",SUM($I$29:I57))","v":4},"",4,"01",0,1]
[2030,46,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I58)>11,\"\",SUM($I$29:I58))","v":4},"",4,"01",0,1]
[2031,47,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I59)>11,\"\",SUM($I$29:I59))","v":4},"",4,"01",0,1]
[2032,48,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I60)>11,\"\",SUM($I$29:I60))","v":4},"",4,"01",0,1]
[2033,49,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I61)>11,\"\",SUM($I$29:I61))","v":4},"",4,"01",0,1]
[2034,50,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I62)>11,\"\",SUM($I$29:I62))","v":4},"",4,"01",0,1]
[2035,51,"2","1","NEIN",null,"",{"$f":"IF(SUM($I$29:I63)>11,\"\",SUM($I$29:I63))","v":4},"",4,"01",0,1]
["Die Ersatzpflicht ist beendet, wenn\na) 11 Wehrpflichtersatzabgaben bezahlt wurden oder\nb) spätestens am Ende des Jahres, in welchem das 37. Altersjahr vollendet wurde (Ersatzjahr)"]

{"sheet":"Tabelle2","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Jahrgange","Einbürgerungsjahr"]
[]
[1981,2001]
[1982,2002]
[1983,2003]
[1984,2004]
[1985,2005]
[1986,2006]
[1987,2007]
[1988,2008]
[1989,2009]
[1990,2010]
[1991,2011]
[1992,2012]
[1993,2013]
[1994,2014]
[1995,2015]
[1996,2016]
[1997,2017]
[1998,2018]

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle4","index":3,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[1981]
[1982]
[1983]
[1984]
[1985]
[1986]
[1987]
[1988]
[1989]
[1990]
[1991]
[1992]
[1993]
[1994]
[1995]
[1996]
[1997]
[1998]

{"sheet":"Tabelle5","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}