{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Vordruck","Tabelle","Tabelle Vergleich","Nebenrechnung","Tabelle Abschlagsber"],"not_rendered":{"defined_names":18,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Vordruck","index":0,"n_rows":65,"n_cols":289,"rows_kept":65,"merged":[[2,1,2,12],[4,1,4,12],[11,4,11,10],[13,4,13,10],[18,266,18,269],[18,271,18,274],[19,7,19,9],[19,10,19,11],[19,20,20,20],[19,21,20,21],[19,22,19,23],[19,39,20,39],[19,40,20,40],[19,41,20,41],[19,42,20,42],[19,43,19,44],[19,45,20,45],[19,46,20,46],[19,47,19,48],[19,59,20,59],[19,60,20,60],[19,61,19,62],[19,83,20,83],[19,84,20,84],[19,87,20,87],[19,88,19,89],[19,95,20,95],[19,96,20,96],[19,99,20,99],[19,100,19,101],[19,108,20,108],[19,109,20,109],[19,112,20,112],[19,113,19,114],[19,121,20,121],[19,122,20,122],[19,125,20,125],[19,126,19,127],[19,139,20,139],[19,140,20,140],[19,141,19,142],[19,150,20,150],[19,151,19,152],[19,159,20,159],[19,160,20,160],[19,163,20,163],[19,164,19,165],[19,172,20,172],[19,173,20,173],[19,174,19,175],[19,183,20,183],[19,184,19,185],[19,192,20,192],[19,193,20,193],[19,194,19,195],[19,203,20,203],[19,204,19,205],[19,212,20,212],[19,213,20,213],[19,216,20,216],[19,217,19,218],[19,225,20,225],[19,226,20,226],[19,229,20,229],[19,230,19,231],[19,241,20,241],[19,242,20,242],[19,245,20,245],[19,246,19,247],[19,258,20,258],[19,259,20,259],[19,260,19,261],[19,276,19,277],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3]]}
[{"$nulls":14},"Anfang",{"$nulls":273},"Ende"]
[]
[null,"Versorgungsauskunft nach Ihren Angaben mit dem Berechnungsprogramm des",{"$nulls":13},"Nebenrechnung"]
[]
[null,"Thüringer Landesamtes für Finanzen",{"$nulls":279},"Grund für den Ruhestand",null,"Schwerbehinderung",null,"Personenkreis"]
[{"$nulls":281},"Erreichen der gesetzlichen Altersgrenze",1,"ja",null,"sonstiger Beamte / Richter",1]
[{"$nulls":281},"auf Antrag",3,"nein",null,"Lehrer",2]
[null,"Geburtsdatum:",{"$nulls":283},"Vollzugsbeamter mittlerer / gehobener Dienst",3]
[{"$nulls":285},"Vollzugsbeamter höherer Dienst",4]
[null,"Schwerbehinderung:",null,null,"nein",{"$f":"IF(R59=1,\" *!*\",\"\")","v":""},{"$nulls":279},"Uni-/FH-Professoren",5]
[]
[null,"Grund für Eintritt in den Ruhestand:",null,null,"Erreichen der gesetzlichen Altersgrenze",{"$nulls":29},"Plausi",{"$nulls":218},"Plausi 1",365,"Tage"]
[]
[null,"Personenkreis:",null,null,"sonstiger Beamte / Richter",{"$nulls":29},{"$f":"DATE(YEAR(E8)+60,MONTH(E8),DAY(E8))-1","v":"1959-12-30"},"Vollendung 60. LJ",{"$nulls":217},"Plausi 2","1994-12-31","spätester Beginn"]
[]
[null,"voraussichtlicher Versorgungsbeginn:",null,null,{"$f":"IF(E8=\"\",\"\",Nebenrechnung!M7)","v":""},{"$nulls":10},"Zeitgrenze","2010-01-01",{"$nulls":236},"Plausi 3","1995-12-31","spätestes Ende"]
[]
[null,{"$f":"IF(OR(Nebenrechnung!D3=3,Nebenrechnung!D3=4),\"vorzeitiger Versorgungsbeginn:\",\"\")","v":""},{"$nulls":3},{"$f":"IF(E8=\"\",\"\",Nebenrechnung!Y2)","v":""},{"$nulls":96},"Prüfsumme für 1601 + 1602",{"$nulls":12},{"$f":"\"Prüfsumme für \"&CZ19","v":"Prüfsumme für 1701"},{"$nulls":12},{"$f":"\"Prüfsumme für \"&DM19","v":"Prüfsumme für 1801"},{"$nulls":24},{"$f":"\"Prüfsumme für \"&EN19","v":"Prüfsumme für 1804"},{"$nulls":12},"Prüfsumme für 1805",{"$nulls":19},"Prüfsumme für 7802",{"$nulls":19},{"$f":"\"Prüfsumme für \"&GO19","v":"Prüfsumme für 7804"},{"$nulls":12},{"$f":"\"Prüfsumme für \"&HB20","v":"Prüfsumme für 7805"},{"$nulls":12},{"$f":"\"Prüfsumme für \"&HO20","v":"Prüfsumme für 7806"},"tatsächliche Tage","Zeiten nach","Prüfung des 10",{"$nulls":12},{"$f":"\"Prüfsumme für \"&IE20","v":"Prüfsumme für 7807"},"tatsächliche Tage","Zeiten nach","anrechenbare Tage","Prüfung des 10",{"$nulls":12},"Ende"]
[{"$nulls":15},8601,{"$nulls":8},1301,{"$nulls":4},1302,{"$nulls":4},1305,{"$nulls":14},8802,{"$nulls":4},1303,{"$nulls":8},1304,{"$nulls":4},1501,{"$nulls":4},1502,{"$nulls":4},1601,{"$nulls":11},1602,{"$nulls":12},1701,{"$nulls":12},1801,{"$nulls":12},1802,{"$nulls":4},1803,{"$nulls":8},1804,{"$nulls":10},1805,{"$nulls":12},7801,{"$nulls":8},7802,{"$nulls":10},7803,{"$nulls":8},7804,{"$nulls":10},7805,{"$nulls":11}," + 10JG 7807",7806,{"$nulls":12},"des Zeitraums","5 Jahres-Zeitraum / 2","Jahreszeitraums",7807,{"$nulls":12},"des Zeitraums","5 Jahres-Zeitraum / 2","des Zeitraums","Jahreszeitraums",8801,{"$nulls":11},9999,"Basisberechnung",{"$nulls":4},"Vergleichsberechnungen",{"$nulls":7},"Auflistung"]
[null," Dienst-, Beschäftigungszeiten",{"$nulls":5},"Teilzeit",null,null,"anzurechnen",null,"Kommentar",{"$nulls":4},{"$f":"P19","v":8601},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * Multiplikator","Ausgangswerte",{"$nulls":3},{"$f":"Y19","v":1301},{"$nulls":4},{"$f":"AD19","v":1302},{"$nulls":4},{"$f":"AI19","v":1305},"ergibt","Rest in","Startdatum","Enddatum","Jahre  in Tagen + Tage","Tage * 2/3","Vergleichswerte",null,"Jahre  in Tagen + Tage","Tage * TZ","Ausgangswerte",{"$nulls":3},{"$f":"AX19","v":8802},{"$nulls":4},{"$f":"BC19","v":1303},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * TZ","Ausgangswerte",{"$nulls":3},{"$f":"BL19","v":1304},{"$nulls":4},{"$f":"BQ19","v":1501},"ergibt","Rest in",null,null,{"$f":"BV19","v":1502},"ergibt","Rest in",null,null,{"$f":"CA19","v":1601},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * Multiplikator","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",{"$nulls":3},{"$f":"CM19","v":1602},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * Multiplikator","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",null,null,{"$f":"CZ19","v":1701},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * Multiplikator","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",null,null,{"$f":"DM19","v":1801},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * Multiplikator","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",null,null,{"$f":"DZ19","v":1802},{"$nulls":4},{"$f":"EE19","v":1803},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * TZ","Ausgangswerte",{"$nulls":3},{"$f":"EN19","v":1804},"ergibt","Rest in","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",null,null,{"$f":"EY19","v":1805},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * Multiplikator","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",null,null,{"$f":"FL19","v":7801},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * TZ","Ausgangswerte",{"$nulls":3},{"$f":"FU19","v":7802},"ergibt","Rest in","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",null,null,{"$f":"GF19","v":7803},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * TZ","Ausgangswerte",{"$nulls":3},{"$f":"GO19","v":7804},"ergibt","Rest in","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",null,null,{"$f":"GZ19","v":7805},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * Multiplikator","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",null,null,{"$f":"HM19","v":7806},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * Multiplikator","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",null," - max. 10 Jahre",{"$nulls":3},{"$f":"IC19","v":7807},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * Multiplikator","vorerst","vorerst Rest in","Jahre  in Tagen + Tage","Ausgangswerte",null,"Rest-Tage",7807," - max. 10 Jahre",7805,"7805 + 7807",null,null,{"$f":"IT19","v":8801},"ergibt","Rest in","Jahre  in Tagen + Tage","Tage * TZ","Ausgangswerte",{"$nulls":15},"um Kürzungen ergänzt",null,null,"Schlüssel"]
[null," (lückenloser beruflicher Werdegang)",null,null,"von","bis","Schlüssel","Zä","/","Ne","Jahre","Tage",{"$nulls":3},"von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahre","Tage","von","bis","Kommentar","Jahre","Tage","von","bis","Kommentar","Jahre","Tage","von","bis","Kommentar","Jahr(e)","Tagen",{"$nulls":4},"Jahre","Tage",null,null,"Jahre","Tage","von","bis","Kommentar","Jahre","Tage","von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahre","Tage","von","bis","Kommentar","Jahre","Tage","von","bis","Kommentar","Jahr(e)","Tagen","von","bis","Kommentar","Jahr(e)","Tagen","von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahr(e)","Tagen",null,"Jahre","Tage","von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"5*365","v":1825},"von","bis","kein Kommentar","Jahr(e)","Tagen",null,null,"Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"5*365","v":1825},"von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"3*365","v":1095},"von","bis","Kommentar","Jahre","Tage","von","bis","kein Kommentar","Jahr(e)","Tagen",null,null,"Jahre","Tage","von","bis","Kommentar","Jahr(e)","Tagen","Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"2*365","v":730},"von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"5*365","v":1825},"von","bis","kein Kommentar","Jahr(e)","Tagen",null,null,"Jahre","Tage","von","bis","Kommentar","Jahr(e)","Tagen","Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"2*365","v":730},"von","bis","kein Kommentar","Jahr(e)","Tagen",null,null,"Jahre","Tage","von","bis","Kommentar","Jahr(e)","Tagen","Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"3*365","v":1095},"von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"5*365","v":1825},"von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"5*365","v":1825},null,null,{"$f":"10*365-HV22","v":3650},"von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahr(e)","Tagen",null,"Jahre","Tage",{"$f":"5*365","v":1825},{"$nulls":3},{"$f":"10*365","v":3650},"von","bis","Kommentar","Jahr(e)","Tagen",null,null,"Jahre","Tage",{"$nulls":4},"Anfangsdatum","End-Datum","Jahre","Tage",null,"Anfangsdatum","End-Datum","Jahre","Tage"]
[{"$nulls":8},{"$f":"IF(H22=\"\",\"\",\"/\")","v":""},null,{"$f":"IF(ISNA(JQ22),\"\",IF(JQ22<>\"\",JQ22,IF($M22<>\"\",\" - - - \",\"\")))","v":""},{"$f":"IF(ISNA(JR22),\"\",IF(JR22<>\"\",JR22,IF($M22<>\"\",\" - - - \",\"\")))","v":""},{"$f":"IF(G22<>\"\",HLOOKUP(G22,$O$20:$JS$46,$O22,FALSE),\"\")","v":""},null,3,{"$f":"IF(AND($G22=P$19,$E22<>\"\",$E22<$Q$16),$E22,\"\")","v":""},{"$f":"IF(AND($G22=P$19,$F22<>\"\",$P22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=R$20,$E22<>\"\",P22>$Q$16),\"Achtung!\",\"\")","v":""},{"$f":"IF(V22<>\"\",INT(V22/365),IF(U22<>\"\",INT(U22/365),\"\"))","v":""},{"$f":"IF(V22<>\"\",ROUNDDOWN(MOD(V22,365)+0.009,2),IF(U22<>\"\",ROUNDDOWN(MOD(U22,365)+0.009,2),\"\"))","v":""},{"$f":"IF(AND(P22<>\"\",Q22<>\"\",R22=\"\"),(W22*365+X22)*9/10,\"\")","v":""},{"$f":"IF(AND(U22<>\"\",$H22<>\"\",$J22<>\"\"),U22*$H22/$J22,\"\")","v":""},{"$f":"IF($G22=R$20,$JI22,\"\")","v":""},{"$f":"IF($G22=R$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=Y$19,$E22<>\"\",$H22=\"\",$J22=\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=Y$19,$F22<>\"\",$H22=\"\",$J22=\"\"),$F22,\"\")","v":""},{"$f":"IF(AND(G22=AA$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF($G22=AA$20,$JI22,\"\")","v":""},{"$f":"IF($G22=AA$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=AD$19,$E22<>\"\",$H22=\"\",$J22=\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=AD$19,$F22<>\"\",$H22=\"\",$J22=\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=AF$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF($G22=AF$20,$JI22,\"\")","v":""},{"$f":"IF($G22=AF$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=AI$19,$E22<>\"\",$H22<>\"\",$J22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=AI$19,$F22<>\"\",$H22<>\"\",$J22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=AK$20,$E22<>\"\",OR($H22=\"\",$J22=\"\")),\"Teilzeit eingeben!\",\"\")","v":""},{"$f":"IF(OR(AU22<>\"\",AQ22<>\"\"),IF(AU22>AQ22,INT(AU22/365),INT(AQ22/365)),\"\")","v":""},{"$f":"IF(OR(AU22<>\"\",AQ22<>\"\"),IF(AU22>AQ22,ROUNDDOWN(MOD(AU22,365)+0.009,2),ROUNDDOWN(MOD(AQ22,365)+0.009,2)),\"\")","v":""},{"$f":"AI22","v":""},{"$f":"IF(AJ22<>\"\",IF(AJ22<$AI$14,AJ22,$AI$14),\"\")","v":""},{"$f":"IF(AND(AI22<>\"\",AJ22<>\"\",AK22=\"\"),AR22*365+AS22,\"\")","v":""},{"$f":"IF(AND(AI22<>\"\",AJ22<>\"\",AK22=\"\"),ROUNDDOWN(AP22*2/3+0.009,2),\"\")","v":""},{"$f":"IF($G22=AK$20,$JN22,\"\")","v":""},{"$f":"IF($G22=AK$20,$JO22,\"\")","v":""},{"$f":"IF(AND(AI22<>\"\",AJ22<>\"\",AK22=\"\"),AV22*365+AW22,\"\")","v":""},{"$f":"IF(AND(AI22<>\"\",AJ22<>\"\",AK22=\"\"),ROUNDDOWN(AT22*$H22/$J22+0.009,2),\"\")","v":""},{"$f":"IF($G22=AK$20,$JI22,\"\")","v":""},{"$f":"IF($G22=AK$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=AX$19,$E22<>\"\",$H22=\"\",$J22=\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=AX$19,$F22<>\"\",$H22=\"\",$J22=\"\"),IF($F22<DATE(YEAR(AX22),MONTH(AX22)+6,DAY(AX22))-1,$F22,DATE(YEAR(AX22),MONTH(AX22)+6,DAY(AX22))-1),\"\")","v":""},{"$f":"IF(AND($G22=AZ$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF($G22=AZ$20,$JI22,\"\")","v":""},{"$f":"IF($G22=AZ$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=BC$19,$E22<>\"\",$H22<>\"\",$J22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=BC$19,$F22<>\"\",$H22<>\"\",$J22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=BE$20,$E22<>\"\",OR($H22=\"\",$J22=\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(BI22<>\"\",INT(BI22/365),\"\")","v":""},{"$f":"IF(BI22<>\"\",ROUNDDOWN(MOD(BI22,365)+0.009,2),\"\")","v":""},{"$f":"IF(AND(BC22<>\"\",BD22<>\"\",BE22=\"\"),BJ22*365+BK22,\"\")","v":""},{"$f":"IF(AND(BC22<>\"\",BD22<>\"\",BE22=\"\"),ROUNDDOWN(BH22*$H22/$J22+0.009,2),\"\")","v":""},{"$f":"IF($G22=BE$20,$JI22,\"\")","v":""},{"$f":"IF($G22=BE$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=BL$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=BL$19,$F22<>\"\"),BL22-1,\"\")","v":""},{"$f":"IF(AND($G22=BN$20,$E22<>\"\",OR($H22=\"\",$J22=\"\")),\"keine Anrechnung!\",\"\")","v":""},{"$f":"IF($G22=BN$20,$JI22,\"\")","v":""},{"$f":"IF($G22=BN$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=BQ$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=BQ$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=BS$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(AND($G22=BS$20,BS22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=BS$20,BS22=\"\"),$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=BV$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=BV$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=BX$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(AND($G22=BX$20,BX22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=BX$20,BX22=\"\"),$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=CA$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=CA$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=CC$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(CJ22<>\"\",INT(CJ22/365),\"\")","v":0},{"$f":"IF(CJ22<>\"\",ROUNDDOWN(MOD(CJ22,365)+0.009,2),\"\")","v":0},{"$f":"IF(AND(CA22<>\"\",CB22<>\"\",CC22=\"\",$H22<>\"\",$J22<>\"\"),CK22*365+CL22,\"\")","v":""},{"$f":"IF(CF22<>\"\",CF22*$H22/$J22,\"\")","v":""},{"$f":"IF(CG22<>\"\",INT(CG22/365),IF(CK22<>\"\",CK22,\"\"))","v":""},{"$f":"IF(CG22<>\"\",ROUNDDOWN(MOD(CG22,365)+0.009,2),IF(CL22<>\"\",CL22,\"\"))","v":""},{"$f":"IF(AND(CH22<>\"\",CI22<>\"\"),IF(($CY23-(CH22*365+CI22))<0,$CY23,(CH22*365+CI22)),0)","v":0},{"$f":"IF(AND($G22=CC$20,CC22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=CC$20,CC22=\"\"),$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=CM$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=CM$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=CO$20,$E22<>\"\",OR($H22=\"\",$J22=\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(CV22<>\"\",INT(CV22/365),\"\")","v":0},{"$f":"IF(CV22<>\"\",ROUNDDOWN(MOD(CV22,365)+0.009,2),\"\")","v":0},{"$f":"IF(AND(CM22<>\"\",CN22<>\"\",CO22=\"\",$H22<>\"\",$J22<>\"\"),CW22*365+CX22,\"\")","v":""},{"$f":"IF(CR22<>\"\",CR22*$H22/$J22,\"\")","v":""},{"$f":"IF(CS22<>\"\",INT(CS22/365),IF(CW22<>\"\",CW22,\"\"))","v":""},{"$f":"IF(CS22<>\"\",ROUNDDOWN(MOD(CS22,365)+0.009,2),IF(CX22<>\"\",CX22,\"\"))","v":""},{"$f":"IF(AND(CT22<>\"\",CU22<>\"\"),IF(($CY23-(CT22*365+CU22))<0,$CY23,(CT22*365+CU22)),0)","v":0},{"$f":"IF(AND($G22=CO$20,CO22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=CO$20,CO22=\"\"),$JJ22,\"\")","v":""},{"$f":"CY23-CJ22-CV22","v":1825},{"$f":"IF(AND($G22=CZ$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=CZ$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(DI22<>\"\",INT(DI22/365),\"\")","v":0},{"$f":"IF(DI22<>\"\",ROUNDDOWN(MOD(DI22,365)+0.009,2),\"\")","v":0},{"$f":"IF(AND(CZ22<>\"\",DA22<>\"\",DB22=\"\",$H22<>\"\",$J22<>\"\"),DJ22*365+DK22,\"\")","v":""},{"$f":"IF(DE22<>\"\",DE22*$H22/$J22,\"\")","v":""},{"$f":"IF(DF22<>\"\",INT(DF22/365),IF(DJ22<>\"\",DJ22,\"\"))","v":""},{"$f":"IF(DF22<>\"\",ROUNDDOWN(MOD(DF22,365)+0.009,2),IF(DK22<>\"\",DK22,\"\"))","v":""},{"$f":"IF(AND(DG22<>\"\",DH22<>\"\"),IF((DL21-(DG22*365+DH22))<0,DL21,(DG22*365+DH22)),0)","v":0},{"$f":"IF(AND($G22=DB$20,DB22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=DB$20,DB22=\"\"),$JJ22,\"\")","v":""},{"$f":"DL21-DI22","v":1825},{"$f":"IF(AND($G22=DM$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=DM$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=DO$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(DV22<>\"\",INT(DV22/365),\"\")","v":0},{"$f":"IF(DV22<>\"\",ROUNDDOWN(MOD(DV22,365)+0.009,2),\"\")","v":0},{"$f":"IF(AND(DM22<>\"\",DN22<>\"\",DO22=\"\",$H22<>\"\",$J22<>\"\"),DW22*365+DX22,\"\")","v":""},{"$f":"IF(DR22<>\"\",DR22*$H22/$J22,\"\")","v":""},{"$f":"IF(DS22<>\"\",INT(DS22/365),IF(DW22<>\"\",DW22,\"\"))","v":""},{"$f":"IF(DS22<>\"\",ROUNDDOWN(MOD(DS22,365)+0.009,2),IF(DX22<>\"\",DX22,\"\"))","v":""},{"$f":"IF(AND(DT22<>\"\",DU22<>\"\"),IF((DY21-(DT22*365+DU22))<0,DY21,(DT22*365+DU22)),0)","v":0},{"$f":"IF(AND($G22=DO$20,DO22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=DO$20,DO22=\"\"),$JJ22,\"\")","v":""},{"$f":"DY21-DV22","v":1095},{"$f":"IF(AND($G22=DZ$19,$E22<>\"\",$H22=\"\",$J22=\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=DZ$19,$F22<>\"\",$H22=\"\",$J22=\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=EB$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF($G22=EB$20,$JI22,\"\")","v":""},{"$f":"IF($G22=EB$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=EE$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=EE$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(EK22<>\"\",INT(EK22/365),IF(EL22<>\"\",EL22,\"\"))","v":""},{"$f":"IF(EK22<>\"\",ROUNDDOWN(MOD(EK22,365)+0.009,2),IF(EM22<>\"\",EM22,\"\"))","v":""},{"$f":"IF(AND(EE22<>\"\",EF22<>\"\",EG22=\"\",$H22<>\"\",$J22<>\"\"),EL22*365+EM22,\"\")","v":""},{"$f":"IF(AND(EE22<>\"\",EF22<>\"\",EG22=\"\",$H22<>\"\",$J22<>\"\"),ROUNDDOWN(EJ22*$H22/$J22+0.009,2),\"\")","v":""},{"$f":"IF($G22=EG$20,$JI22,\"\")","v":""},{"$f":"IF($G22=EG$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=EN$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=EN$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=EP$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(EU22<>\"\",INT(EU22/365),\"\")","v":0},{"$f":"IF(EU22<>\"\",ROUNDDOWN(MOD(EU22,365)+0.009,2),\"\")","v":0},{"$f":"IF(EV22<>\"\",EV22,\"\")","v":""},{"$f":"IF(EW22<>\"\",EW22,\"\")","v":""},{"$f":"IF(AND(ES22<>\"\",ET22<>\"\"),IF((EX21-(ES22*365+ET22))<0,EX21,(ES22*365+ET22)),0)","v":0},{"$f":"IF(AND($G22=EP$20,EP22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=EP$20,EP22=\"\"),$JJ22,\"\")","v":""},{"$f":"EX21-EU22","v":730},{"$f":"IF(AND($G22=EY$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=EY$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=FA$20,$E22<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},{"$f":"IF(FH22<>\"\",INT(FH22/365),\"\")","v":0},{"$f":"IF(FH22<>\"\",ROUNDDOWN(MOD(FH22,365)+0.009,2),\"\")","v":0},{"$f":"IF(AND(EY22<>\"\",EZ22<>\"\",FA22=\"\",$H22<>\"\",$J22<>\"\"),FI22*365+FJ22,\"\")","v":""},{"$f":"IF(FD22<>\"\",FD22*$H22/$J22,\"\")","v":""},{"$f":"IF(FE22<>\"\",INT(FE22/365),IF(FI22<>\"\",FI22,\"\"))","v":""},{"$f":"IF(FE22<>\"\",ROUNDDOWN(MOD(FE22,365)+0.009,2),IF(FJ22<>\"\",FJ22,\"\"))","v":""},{"$f":"IF(AND(FF22<>\"\",FG22<>\"\"),IF((FK21-(FF22*365+FG22))<0,FK21,(FF22*365+FG22)),0)","v":0},{"$f":"IF(AND($G22=FA$20,FA22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=FA$20,FA22=\"\"),$JJ22,\"\")","v":""},{"$f":"FK21-FH22","v":1825},{"$f":"IF(AND($G22=FL$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=FL$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(FR22<>\"\",INT(FR22/365),IF(FS22<>\"\",FS22,\"\"))","v":""},{"$f":"IF(FR22<>\"\",ROUNDDOWN(MOD(FR22,365)+0.009,2),IF(FT22<>\"\",FT22,\"\"))","v":""},{"$f":"IF(AND(FL22<>\"\",FM22<>\"\",FN22=\"\",$H22<>\"\",$J22<>\"\"),FS22*365+FT22,\"\")","v":""},{"$f":"IF(AND(FL22<>\"\",FM22<>\"\",FN22=\"\",$H22<>\"\",$J22<>\"\"),ROUNDDOWN(FQ22*$H22/$J22+0.009,2),\"\")","v":""},{"$f":"IF($G22=FN$20,$JI22,\"\")","v":""},{"$f":"IF($G22=FN$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=FU$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=FU$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=FW$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(GB22<>\"\",INT(GB22/365),\"\")","v":0},{"$f":"IF(GB22<>\"\",ROUNDDOWN(MOD(GB22,365)+0.009,2),\"\")","v":0},{"$f":"IF(GC22<>\"\",GC22,\"\")","v":""},{"$f":"IF(GD22<>\"\",GD22,\"\")","v":""},{"$f":"IF(AND(FZ22<>\"\",GA22<>\"\"),IF((GE21-(FZ22*365+GA22))<0,GE21,(FZ22*365+GA22)),0)","v":0},{"$f":"IF(AND($G22=FW$20,FW22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=FW$20,FW22=\"\"),$JJ22,\"\")","v":""},{"$f":"GE21-GB22","v":730},{"$f":"IF(AND($G22=GF$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=GF$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(GL22<>\"\",INT(GL22/365),IF(GM22<>\"\",GM22,\"\"))","v":""},{"$f":"IF(GL22<>\"\",ROUNDDOWN(MOD(GL22,365)+0.009,2),IF(GN22<>\"\",GN22,\"\"))","v":""},{"$f":"IF(AND(GF22<>\"\",GG22<>\"\",GH22=\"\",$H22<>\"\",$J22<>\"\"),GM22*365+GN22,\"\")","v":""},{"$f":"IF(AND(GF22<>\"\",GG22<>\"\",GH22=\"\",$H22<>\"\",$J22<>\"\"),ROUNDDOWN(GK22*$H22/$J22+0.009,2),\"\")","v":""},{"$f":"IF($G22=GH$20,$JI22,\"\")","v":""},{"$f":"IF($G22=GH$20,$JJ22,\"\")","v":""},{"$f":"IF(AND($G22=GO$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=GO$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=GQ$20,$E22<>\"\",OR($H22<>\"\",$J22<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(GV22<>\"\",INT(GV22/365),\"\")","v":0},{"$f":"IF(GV22<>\"\",ROUNDDOWN(MOD(GV22,365)+0.009,2),\"\")","v":0},{"$f":"IF(GW22<>\"\",GW22,\"\")","v":""},{"$f":"IF(GX22<>\"\",GX22,\"\")","v":""},{"$f":"IF(AND(GT22<>\"\",GU22<>\"\"),IF((GY21-(GT22*365+GU22))<0,GY21,(GT22*365+GU22)),0)","v":0},{"$f":"IF(AND($G22=GQ$20,GQ22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=GQ$20,GQ22=\"\"),$JJ22,\"\")","v":""},{"$f":"GY21-GV22","v":1095},{"$f":"IF(AND($G22=GZ$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=GZ$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=HB$20,$E22<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},{"$f":"IF(HI22<>\"\",INT(HI22/365),\"\")","v":0},{"$f":"IF(HI22<>\"\",ROUNDDOWN(MOD(HI22,365)+0.009,2),\"\")","v":0},{"$f":"IF(AND(GZ22<>\"\",HA22<>\"\",HB22=\"\",$H22<>\"\",$J22<>\"\"),HJ22*365+HK22,\"\")","v":""},{"$f":"IF(HE22<>\"\",HE22*$H22/$J22,\"\")","v":""},{"$f":"IF(HF22<>\"\",INT(HF22/365),IF(HJ22<>\"\",HJ22,0))","v":0},{"$f":"IF(HF22<>\"\",ROUNDDOWN(MOD(HF22,365)+0.009,2),IF(HK22<>\"\",HK22,0))","v":0},{"$f":"IF(AND(HG22<>\"\",HH22<>\"\"),IF((HL23-(HG22*365+HH22))<0,HL23,(HG22*365+HH22)),0)","v":0},{"$f":"IF(AND($G22=HB$20,HB22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=HB$20,HB22=\"\"),$JJ22,\"\")","v":""},{"$f":"IF(HL23-HI22<0,0,HL23-HI22)","v":1825},{"$f":"IF(AND($G22=HM$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=HM$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=HO$20,$E22<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für Uni-Professoren!\",\"\")","v":""},{"$f":"IF(HV22<>\"\",INT((HV22+IA22)/365),\"\")","v":0},{"$f":"IF(HV22<>\"\",ROUNDDOWN(MOD((HV22+IA22),365)+0.009,2),\"\")","v":0},{"$f":"IF(AND(HM22<>\"\",HN22<>\"\",HO22=\"\",$H22<>\"\",$J22<>\"\"),HW22*365+HX22,\"\")","v":""},{"$f":"IF(HR22<>\"\",HR22*$H22/$J22,\"\")","v":""},{"$f":"IF(HS22<>\"\",INT(HS22/365),IF(HW22<>\"\",HW22,0))","v":0},{"$f":"IF(HS22<>\"\",ROUNDDOWN(MOD(HS22,365)+0.009,2),IF(HX22<>\"\",HX22,0))","v":0},{"$f":"IF(AND(HT22<>\"\",HU22<>\"\"),IF((HY21-(HT22*365+HU22))<0,HY21,(HT22*365+HU22)),0)","v":0},{"$f":"IF(AND($G22=HO$20,HO22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=HO$20,HO22=\"\"),$JJ22,\"\")","v":""},{"$f":"HY21-HV22","v":1825},{"$f":"IF(HT22<>\"\",HT22*365+HU22,\"\")","v":0},{"$f":"IF(HY22=0,IF((HZ22-HV22)/2<IB21,(HZ22-HV22)/2,IB21),0)","v":0},{"$f":"IF(IB21-HV23-IA22<0,0,IB21-HV23-IA22)","v":3650},{"$f":"IF(AND($G22=IC$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=IC$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(AND($G22=IE$20,$E22<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},{"$f":"IF(IL22<>\"\",INT((IL22+IQ22)/365),\"\")","v":0},{"$f":"IF(IL22<>\"\",ROUNDDOWN(MOD((IL22+IQ22),365)+0.009,2),\"\")","v":0},{"$f":"IF(AND(IC22<>\"\",ID22<>\"\",IE22=\"\",$H22<>\"\",$J22<>\"\"),IM22*365+IN22,\"\")","v":""},{"$f":"IF(IH22<>\"\",IH22*$H22/$J22,\"\")","v":""},{"$f":"IF(II22<>\"\",INT(II22/365),IF(IM22<>\"\",IM22,0))","v":0},{"$f":"IF(II22<>\"\",ROUNDDOWN(MOD(II22,365)+0.009,2),IF(IN22<>\"\",IN22,0))","v":0},{"$f":"IF(AND(IJ22<>\"\",IK22<>\"\"),IF((IO23-(IJ22*365+IK22))<0,IO23,(IJ22*365+IK22)),0)","v":0},{"$f":"IF(AND($G22=IE$20,IE22=\"\"),$JI22,\"\")","v":""},{"$f":"IF(AND($G22=IE$20,IE22=\"\"),$JJ22,\"\")","v":""},{"$f":"IF(IO23-IL22<0,0,IO23-IL22)","v":1825},{"$f":"IF(IJ22<>\"\",IJ22*365+IK22,\"\")","v":0},{"$f":"IF(AND(IO22=0,IP22>IO23,IS23>0),IF((IP22-IO23)/2<IS23-IO23,(IP22-IO23)/2,IS23-IO23),0)","v":0},{"$f":"IF(HI22>0,HI22,0)","v":0},{"$f":"IF(IS23-IL22-IQ22<0,0,IS23-IL22-IQ22)","v":3650},{"$f":"IF(AND($G22=IT$19,$E22<>\"\"),$E22,\"\")","v":""},{"$f":"IF(AND($G22=IT$19,$F22<>\"\"),$F22,\"\")","v":""},{"$f":"IF(IT22=\"\",\"\",IF(OR((IU22-IT22+1)<$IU$12,IT22>$IU$14,IU22>$IU$16),\"Eingabe nicht möglich!\",\"\"))","v":""},{"$f":"IF(AND(IY22<>\"\",IZ22<>\"\"),INT(IZ22/365)*2,IF(AND(IY22<>\"\",IZ22=\"\"),INT(IY22/365)*2,\"\"))","v":""},{"$f":"IF(AND(IY22<>\"\",IZ22<>\"\"),ROUNDDOWN(MOD(IZ22,365)+0.009,2)*2,IF(AND(IY22<>\"\",IZ22=\"\"),ROUNDDOWN(MOD(IY22,365)+0.009,2)*2,\"\"))","v":""},{"$f":"IF(AND(IT22<>\"\",IU22<>\"\",IV22=\"\"),JA22*365+JB22,\"\")","v":""},{"$f":"IF(AND(IT22<>\"\",IU22<>\"\",IV22=\"\",H22<>\"\",J22<>\"\"),ROUNDDOWN(IY22*$H22/$J22+0.009,2),\"\")","v":""},{"$f":"IF($G22=IV$20,$JI22,\"\")","v":""},{"$f":"IF($G22=IV$20,$JJ22,\"\")","v":""},{"$nulls":4},{"$f":"IF(F22<>\"\",INDIRECT(\"Z\"&19+$O22&\"S\"&MATCH($G22,$A$19:$JE$19,0),FALSE),\"\")","v":""},{"$f":"IF(F22<>\"\",INDIRECT(\"Z\"&19+$O22&\"S\"&MATCH($G22,$A$19:$JE$19,0)+1,FALSE),\"\")","v":""},{"$f":"IF($JH22<>\"\",Tabelle!P2,\"\")","v":""},{"$f":"IF($JH22<>\"\",Tabelle!Q2,\"\")","v":""},null,{"$f":"IF(F22<>\"\",INDIRECT(\"Z\"&19+$O22&\"S\"&MATCH($G22,$A$19:$JE$19,0)+5,FALSE),\"\")","v":""},{"$f":"IF(F22<>\"\",INDIRECT(\"Z\"&19+$O22&\"S\"&MATCH($G22,$A$19:$JE$19,0)+6,FALSE),\"\")","v":""},{"$f":"IF($JH22<>\"\",'Tabelle Vergleich'!P2,\"\")","v":""},{"$f":"IF($JH22<>\"\",'Tabelle Vergleich'!Q2,\"\")","v":""},null,{"$f":"IF($F22<>\"\",INDIRECT(\"Z\"&19+$O22&\"S\"&MATCH($G22,$A$19:$JE$19,0)+3,FALSE),\"\")","v":""},{"$f":"IF($F22<>\"\",INDIRECT(\"Z\"&19+$O22&\"S\"&MATCH($G22,$A$19:$JE$19,0)+4,FALSE),\"\")","v":""},null,{"$f":"IF(ISNUMBER(SMALL($P$19:$JE$19,O22-2))=TRUE,SMALL($P$19:$JE$19,O22-2),\"\")","v":1301}]
[{"$nulls":8},"",null,"","","",null,4,"","","",{"$f":"IF(V23<>\"\",INT(V23/365),IF(U23<>\"\",INT(U23/365),\"\"))","v":""},{"$f":"IF(V23<>\"\",ROUNDDOWN(MOD(V23,365)+0.009,2),IF(U23<>\"\",ROUNDDOWN(MOD(U23,365)+0.009,2),\"\"))","v":""},{"$f":"IF(AND(P23<>\"\",Q23<>\"\",R23=\"\"),(W23*365+X23)*9/10,\"\")","v":""},"","","","","","","","","","","","","",{"$f":"IF(AND($G23=AI$19,$E23<>\"\",$H23<>\"\",$J23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=AI$19,$F23<>\"\",$H23<>\"\",$J23<>\"\"),$F23,\"\")","v":""},{"$f":"IF(AND($G23=AK$20,$E23<>\"\",OR($H23=\"\",$J23=\"\")),\"Teilzeit eingeben!\",\"\")","v":""},{"$f":"IF(OR(AU23<>\"\",AQ23<>\"\"),IF(AU23>AQ23,INT(AU23/365),INT(AQ23/365)),\"\")","v":""},{"$f":"IF(OR(AU23<>\"\",AQ23<>\"\"),IF(AU23>AQ23,ROUNDDOWN(MOD(AU23,365)+0.009,2),ROUNDDOWN(MOD(AQ23,365)+0.009,2)),\"\")","v":""},{"$f":"AI23","v":""},{"$f":"IF(AJ23<>\"\",IF(AJ23<$AI$14,AJ23,$AI$14),\"\")","v":""},{"$f":"IF(AND(AI23<>\"\",AJ23<>\"\",AK23=\"\"),AR23*365+AS23,\"\")","v":""},{"$f":"IF(AND(AI23<>\"\",AJ23<>\"\",AK23=\"\"),ROUNDDOWN(AP23*2/3+0.009,2),\"\")","v":""},"","",{"$f":"IF(AND(AI23<>\"\",AJ23<>\"\",AK23=\"\"),AV23*365+AW23,\"\")","v":""},{"$f":"IF(AND(AI23<>\"\",AJ23<>\"\",AK23=\"\"),ROUNDDOWN(AT23*$H23/$J23+0.009,2),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(BI23<>\"\",INT(BI23/365),\"\")","v":""},{"$f":"IF(BI23<>\"\",ROUNDDOWN(MOD(BI23,365)+0.009,2),\"\")","v":""},{"$f":"IF(AND(BC23<>\"\",BD23<>\"\",BE23=\"\"),BJ23*365+BK23,\"\")","v":""},"","","",{"$f":"IF(AND($G23=BL$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=BL$19,$F23<>\"\"),BL23-1,\"\")","v":""},"","","",{"$f":"IF(AND($G23=BQ$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=BQ$19,$F23<>\"\"),$F23,\"\")","v":""},"","","",{"$f":"IF(AND($G23=BV$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=BV$19,$F23<>\"\"),$F23,\"\")","v":""},"","","",{"$f":"IF(AND($G23=CA$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=CA$19,$F23<>\"\"),$F23,\"\")","v":""},"",{"$f":"IF(CJ23<>\"\",INT(CJ23/365),\"\")","v":0},{"$f":"IF(CJ23<>\"\",ROUNDDOWN(MOD(CJ23,365)+0.009,2),\"\")","v":0},"","",{"$f":"IF(CG23<>\"\",INT(CG23/365),IF(CK23<>\"\",CK23,\"\"))","v":""},{"$f":"IF(CG23<>\"\",ROUNDDOWN(MOD(CG23,365)+0.009,2),IF(CL23<>\"\",CL23,\"\"))","v":""},0,"","",{"$f":"IF(AND($G23=CM$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=CM$19,$F23<>\"\"),$F23,\"\")","v":""},"",{"$f":"IF(CV23<>\"\",INT(CV23/365),\"\")","v":0},{"$f":"IF(CV23<>\"\",ROUNDDOWN(MOD(CV23,365)+0.009,2),\"\")","v":0},"","",{"$f":"IF(CS23<>\"\",INT(CS23/365),IF(CW23<>\"\",CW23,\"\"))","v":""},{"$f":"IF(CS23<>\"\",ROUNDDOWN(MOD(CS23,365)+0.009,2),IF(CX23<>\"\",CX23,\"\"))","v":""},0,"","",1825,{"$f":"IF(AND($G23=CZ$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=CZ$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(DI23<>\"\",INT(DI23/365),\"\")","v":0},{"$f":"IF(DI23<>\"\",ROUNDDOWN(MOD(DI23,365)+0.009,2),\"\")","v":0},"","",{"$f":"IF(DF23<>\"\",INT(DF23/365),IF(DJ23<>\"\",DJ23,\"\"))","v":""},{"$f":"IF(DF23<>\"\",ROUNDDOWN(MOD(DF23,365)+0.009,2),IF(DK23<>\"\",DK23,\"\"))","v":""},{"$f":"IF(AND(DG23<>\"\",DH23<>\"\"),IF((DL22-(DG23*365+DH23))<0,DL22,(DG23*365+DH23)),0)","v":0},"","",{"$f":"DL22-DI23","v":1825},{"$f":"IF(AND($G23=DM$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=DM$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"IF(AND($G23=DO$20,$E23<>\"\",OR($H23<>\"\",$J23<>\"\")),\"Achtung!\",\"\")","v":""},{"$f":"IF(DV23<>\"\",INT(DV23/365),\"\")","v":0},{"$f":"IF(DV23<>\"\",ROUNDDOWN(MOD(DV23,365)+0.009,2),\"\")","v":0},"","",{"$f":"IF(DS23<>\"\",INT(DS23/365),IF(DW23<>\"\",DW23,\"\"))","v":""},{"$f":"IF(DS23<>\"\",ROUNDDOWN(MOD(DS23,365)+0.009,2),IF(DX23<>\"\",DX23,\"\"))","v":""},{"$f":"IF(AND(DT23<>\"\",DU23<>\"\"),IF((DY22-(DT23*365+DU23))<0,DY22,(DT23*365+DU23)),0)","v":0},"","",{"$f":"DY22-DV23","v":1095},"","","","","",{"$f":"IF(AND($G23=EE$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=EE$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(EK23<>\"\",INT(EK23/365),IF(EL23<>\"\",EL23,\"\"))","v":""},{"$f":"IF(EK23<>\"\",ROUNDDOWN(MOD(EK23,365)+0.009,2),IF(EM23<>\"\",EM23,\"\"))","v":""},{"$f":"IF(AND(EE23<>\"\",EF23<>\"\",EG23=\"\",$H23<>\"\",$J23<>\"\"),EL23*365+EM23,\"\")","v":""},{"$f":"IF(AND(EE23<>\"\",EF23<>\"\",EG23=\"\",$H23<>\"\",$J23<>\"\"),ROUNDDOWN(EJ23*$H23/$J23+0.009,2),\"\")","v":""},"","",{"$f":"IF(AND($G23=EN$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=EN$19,$F23<>\"\"),$F23,\"\")","v":""},"",{"$f":"IF(EU23<>\"\",INT(EU23/365),\"\")","v":0},{"$f":"IF(EU23<>\"\",ROUNDDOWN(MOD(EU23,365)+0.009,2),\"\")","v":0},{"$f":"IF(EV23<>\"\",EV23,\"\")","v":""},{"$f":"IF(EW23<>\"\",EW23,\"\")","v":""},{"$f":"IF(AND(ES23<>\"\",ET23<>\"\"),IF((EX22-(ES23*365+ET23))<0,EX22,(ES23*365+ET23)),0)","v":0},"","",{"$f":"EX22-EU23","v":730},{"$f":"IF(AND($G23=EY$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=EY$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"IF(AND($G23=FA$20,$E23<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},{"$f":"IF(FH23<>\"\",INT(FH23/365),\"\")","v":0},{"$f":"IF(FH23<>\"\",ROUNDDOWN(MOD(FH23,365)+0.009,2),\"\")","v":0},"","",{"$f":"IF(FE23<>\"\",INT(FE23/365),IF(FI23<>\"\",FI23,\"\"))","v":""},{"$f":"IF(FE23<>\"\",ROUNDDOWN(MOD(FE23,365)+0.009,2),IF(FJ23<>\"\",FJ23,\"\"))","v":""},{"$f":"IF(AND(FF23<>\"\",FG23<>\"\"),IF((FK22-(FF23*365+FG23))<0,FK22,(FF23*365+FG23)),0)","v":0},"","",{"$f":"FK22-FH23","v":1825},{"$f":"IF(AND($G23=FL$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=FL$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(FR23<>\"\",INT(FR23/365),IF(FS23<>\"\",FS23,\"\"))","v":""},{"$f":"IF(FR23<>\"\",ROUNDDOWN(MOD(FR23,365)+0.009,2),IF(FT23<>\"\",FT23,\"\"))","v":""},{"$f":"IF(AND(FL23<>\"\",FM23<>\"\",FN23=\"\",$H23<>\"\",$J23<>\"\"),FS23*365+FT23,\"\")","v":""},{"$f":"IF(AND(FL23<>\"\",FM23<>\"\",FN23=\"\",$H23<>\"\",$J23<>\"\"),ROUNDDOWN(FQ23*$H23/$J23+0.009,2),\"\")","v":""},"","",{"$f":"IF(AND($G23=FU$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=FU$19,$F23<>\"\"),$F23,\"\")","v":""},"",{"$f":"IF(GB23<>\"\",INT(GB23/365),\"\")","v":0},{"$f":"IF(GB23<>\"\",ROUNDDOWN(MOD(GB23,365)+0.009,2),\"\")","v":0},{"$f":"IF(GC23<>\"\",GC23,\"\")","v":""},{"$f":"IF(GD23<>\"\",GD23,\"\")","v":""},{"$f":"IF(AND(FZ23<>\"\",GA23<>\"\"),IF((GE22-(FZ23*365+GA23))<0,GE22,(FZ23*365+GA23)),0)","v":0},"","",{"$f":"GE22-GB23","v":730},{"$f":"IF(AND($G23=GF$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=GF$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(GL23<>\"\",INT(GL23/365),IF(GM23<>\"\",GM23,\"\"))","v":""},{"$f":"IF(GL23<>\"\",ROUNDDOWN(MOD(GL23,365)+0.009,2),IF(GN23<>\"\",GN23,\"\"))","v":""},{"$f":"IF(AND(GF23<>\"\",GG23<>\"\",GH23=\"\",$H23<>\"\",$J23<>\"\"),GM23*365+GN23,\"\")","v":""},{"$f":"IF(AND(GF23<>\"\",GG23<>\"\",GH23=\"\",$H23<>\"\",$J23<>\"\"),ROUNDDOWN(GK23*$H23/$J23+0.009,2),\"\")","v":""},"","",{"$f":"IF(AND($G23=GO$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=GO$19,$F23<>\"\"),$F23,\"\")","v":""},"",{"$f":"IF(GV23<>\"\",INT(GV23/365),\"\")","v":0},{"$f":"IF(GV23<>\"\",ROUNDDOWN(MOD(GV23,365)+0.009,2),\"\")","v":0},{"$f":"IF(GW23<>\"\",GW23,\"\")","v":""},{"$f":"IF(GX23<>\"\",GX23,\"\")","v":""},{"$f":"IF(AND(GT23<>\"\",GU23<>\"\"),IF((GY22-(GT23*365+GU23))<0,GY22,(GT23*365+GU23)),0)","v":0},"","",{"$f":"GY22-GV23","v":1095},{"$f":"IF(AND($G23=GZ$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=GZ$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"IF(AND($G23=HB$20,$E23<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},{"$f":"IF(HI23<>\"\",INT(HI23/365),\"\")","v":0},{"$f":"IF(HI23<>\"\",ROUNDDOWN(MOD(HI23,365)+0.009,2),\"\")","v":0},"","",{"$f":"IF(HF23<>\"\",INT(HF23/365),IF(HJ23<>\"\",HJ23,0))","v":0},{"$f":"IF(HF23<>\"\",ROUNDDOWN(MOD(HF23,365)+0.009,2),IF(HK23<>\"\",HK23,0))","v":0},{"$f":"IF(AND(HG23<>\"\",HH23<>\"\"),IF((HL24-(HG23*365+HH23))<0,HL24,(HG23*365+HH23)),0)","v":0},"","",1825,{"$f":"IF(AND($G23=HM$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=HM$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"IF(AND($G23=HO$20,$E23<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},{"$f":"IF(HV23<>\"\",INT((HV23+IA23)/365),\"\")","v":0},0,{"$f":"IF(AND(HM23<>\"\",HN23<>\"\",HO23=\"\",$H23<>\"\",$J23<>\"\"),HW23*365+HX23,\"\")","v":""},"",{"$f":"IF(HS23<>\"\",INT(HS23/365),IF(HW23<>\"\",HW23,0))","v":0},{"$f":"IF(HS23<>\"\",ROUNDDOWN(MOD(HS23,365)+0.009,2),IF(HX23<>\"\",HX23,0))","v":0},{"$f":"IF(AND(HT23<>\"\",HU23<>\"\"),IF((HY22-(HT23*365+HU23))<0,HY22,(HT23*365+HU23)),0)","v":0},"","",{"$f":"HY22-HV23","v":1825},{"$f":"IF(HT23<>\"\",HT23*365+HU23,\"\")","v":0},{"$f":"IF(HY23=0,IF((HZ23-HV23)/2<IB22,(HZ23-HV23)/2,IB22),0)","v":0},{"$f":"IF(IB22-HV24-IA23<0,0,IB22-HV24-IA23)","v":3650},{"$f":"IF(AND($G23=IC$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=IC$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"IF(AND($G23=IE$20,$E23<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},{"$f":"IF(IL23<>\"\",INT((IL23+IQ23)/365),\"\")","v":0},{"$f":"IF(IL23<>\"\",ROUNDDOWN(MOD((IL23+IQ23),365)+0.009,2),\"\")","v":0},{"$f":"IF(AND(IC23<>\"\",ID23<>\"\",IE23=\"\",$H23<>\"\",$J23<>\"\"),IM23*365+IN23,\"\")","v":""},"",{"$f":"IF(II23<>\"\",INT(II23/365),IF(IM23<>\"\",IM23,0))","v":0},{"$f":"IF(II23<>\"\",ROUNDDOWN(MOD(II23,365)+0.009,2),IF(IN23<>\"\",IN23,0))","v":0},0,"","",1825,{"$f":"IF(IJ23<>\"\",IJ23*365+IK23,\"\")","v":0},{"$f":"IF(AND(IO23=0,IP23>IO24,IS24>0),IF((IP23-IO24)/2<IS24-IO24,(IP23-IO24)/2,IS24-IO24),0)","v":0},{"$f":"IF(HI23>0,HI23,0)","v":0},{"$f":"IF(IS24-IL23-IQ23<0,0,IS24-IL23-IQ23)","v":3650},{"$f":"IF(AND($G23=IT$19,$E23<>\"\"),$E23,\"\")","v":""},{"$f":"IF(AND($G23=IT$19,$F23<>\"\"),$F23,\"\")","v":""},{"$f":"IF(IT23=\"\",\"\",IF(OR((IU23-IT23+1)<$IU$12,IT23>$IU$14,IU23>$IU$16),\"Eingabe nicht möglich!\",\"\"))","v":""},{"$f":"IF(AND(IY23<>\"\",IZ23<>\"\"),INT(IZ23/365)*2,IF(AND(IY23<>\"\",IZ23=\"\"),INT(IY23/365)*2,\"\"))","v":""},{"$f":"IF(AND(IY23<>\"\",IZ23<>\"\"),ROUNDDOWN(MOD(IZ23,365)+0.009,2)*2,IF(AND(IY23<>\"\",IZ23=\"\"),ROUNDDOWN(MOD(IY23,365)+0.009,2)*2,\"\"))","v":""},{"$f":"IF(AND(IT23<>\"\",IU23<>\"\",IV23=\"\"),JA23*365+JB23,\"\")","v":""},"","","",{"$nulls":4},"","",{"$f":"IF($JH23<>\"\",Tabelle!P3,\"\")","v":""},{"$f":"IF($JH23<>\"\",Tabelle!Q3,\"\")","v":""},null,{"$f":"IF(K23<>\"\",INDIRECT(\"Z\"&19+$O23&\"S\"&MATCH($G23,$A$19:$JE$19,0),FALSE),\"\")","v":""},{"$f":"IF(K23<>\"\",INDIRECT(\"Z\"&19+$O23&\"S\"&MATCH($G23,$A$19:$JE$19,0)+1,FALSE),\"\")","v":""},{"$f":"IF($JH23<>\"\",Tabelle!U3,\"\")","v":""},{"$f":"IF($JH23<>\"\",Tabelle!V3,\"\")","v":""},null,"","",null,1302]
[{"$nulls":8},"",null,"","","",null,5,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",{"$f":"IF(CV24<>\"\",INT(CV24/365),\"\")","v":0},{"$f":"IF(CV24<>\"\",ROUNDDOWN(MOD(CV24,365)+0.009,2),\"\")","v":0},"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G24=FA$20,$E24<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G24=HB$20,$E24<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G24=HO$20,$E24<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",{"$f":"HY23-HV24","v":1825},0,{"$f":"IF(HY24=0,IF((HZ24-HV24)/2<IB23,(HZ24-HV24)/2,IB23),0)","v":0},3650,"","",{"$f":"IF(AND($G24=IE$20,$E24<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH24<>\"\",Tabelle!P4,\"\")","v":""},{"$f":"IF($JH24<>\"\",Tabelle!Q4,\"\")","v":""},null,"","",{"$f":"IF($JH24<>\"\",Tabelle!U4,\"\")","v":""},{"$f":"IF($JH24<>\"\",Tabelle!V4,\"\")","v":""},null,"","",null,1303]
[{"$nulls":8},"",null,"","","",null,6,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",{"$f":"IF(CV25<>\"\",INT(CV25/365),\"\")","v":0},{"$f":"IF(CV25<>\"\",ROUNDDOWN(MOD(CV25,365)+0.009,2),\"\")","v":0},"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G25=FA$20,$E25<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G25=HB$20,$E25<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G25=HO$20,$E25<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G25=IE$20,$E25<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},{"$f":"IF(IL25<>\"\",INT((IL25+IQ25)/365),\"\")","v":0},0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH25<>\"\",Tabelle!P5,\"\")","v":""},{"$f":"IF($JH25<>\"\",Tabelle!Q5,\"\")","v":""},null,"","",{"$f":"IF($JH25<>\"\",Tabelle!U5,\"\")","v":""},{"$f":"IF($JH25<>\"\",Tabelle!V5,\"\")","v":""},null,"","",null,1304]
[{"$nulls":8},"",null,"","","",null,7,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",{"$f":"IF(CV26<>\"\",INT(CV26/365),\"\")","v":0},{"$f":"IF(CV26<>\"\",ROUNDDOWN(MOD(CV26,365)+0.009,2),\"\")","v":0},"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G26=FA$20,$E26<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G26=HB$20,$E26<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G26=HO$20,$E26<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},{"$f":"IF(HV26<>\"\",INT((HV26+IA26)/365),\"\")","v":0},{"$f":"IF(HV26<>\"\",ROUNDDOWN(MOD((HV26+IA26),365)+0.009,2),\"\")","v":0},"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G26=IE$20,$E26<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH26<>\"\",Tabelle!P6,\"\")","v":""},{"$f":"IF($JH26<>\"\",Tabelle!Q6,\"\")","v":""},null,"","",{"$f":"IF($JH26<>\"\",Tabelle!U6,\"\")","v":""},{"$f":"IF($JH26<>\"\",Tabelle!V6,\"\")","v":""},null,"","",null,1305]
[{"$nulls":8},"",null,"","","",null,8,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",{"$f":"IF(CV27<>\"\",INT(CV27/365),\"\")","v":0},{"$f":"IF(CV27<>\"\",ROUNDDOWN(MOD(CV27,365)+0.009,2),\"\")","v":0},"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G27=FA$20,$E27<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G27=HB$20,$E27<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G27=HO$20,$E27<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},{"$f":"IF(HV27<>\"\",INT((HV27+IA27)/365),\"\")","v":0},{"$f":"IF(HV27<>\"\",ROUNDDOWN(MOD((HV27+IA27),365)+0.009,2),\"\")","v":0},"","",0,0,{"$f":"IF(AND(HT27<>\"\",HU27<>\"\"),IF((HY26-(HT27*365+HU27))<0,HY26,(HT27*365+HU27)),0)","v":0},"","",1825,0,{"$f":"IF(HY27=0,IF((HZ27-HV27)/2<IB26,(HZ27-HV27)/2,IB26),0)","v":0},3650,"","",{"$f":"IF(AND($G27=IE$20,$E27<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,{"$f":"IF(AND(IJ27<>\"\",IK27<>\"\"),IF((IO28-(IJ27*365+IK27))<0,IO28,(IJ27*365+IK27)),0)","v":0},"","",1825,0,0,0,{"$f":"IF(IS28-IL27-IQ27<0,0,IS28-IL27-IQ27)","v":3650},"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH27<>\"\",Tabelle!P7,\"\")","v":""},{"$f":"IF($JH27<>\"\",Tabelle!Q7,\"\")","v":""},null,"","",{"$f":"IF($JH27<>\"\",Tabelle!U7,\"\")","v":""},{"$f":"IF($JH27<>\"\",Tabelle!V7,\"\")","v":""},null,"","",null,1501]
[{"$nulls":8},"",null,"","","",null,9,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G28=FA$20,$E28<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G28=HB$20,$E28<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G28=HO$20,$E28<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G28=IE$20,$E28<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,{"$f":"IF(AND(IJ28<>\"\",IK28<>\"\"),IF((IO29-(IJ28*365+IK28))<0,IO29,(IJ28*365+IK28)),0)","v":0},"","",1825,{"$f":"IF(IJ28<>\"\",IJ28*365+IK28,\"\")","v":0},0,0,{"$f":"IF(IS29-IL28-IQ28<0,0,IS29-IL28-IQ28)","v":3650},"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH28<>\"\",Tabelle!P8,\"\")","v":""},{"$f":"IF($JH28<>\"\",Tabelle!Q8,\"\")","v":""},null,"","",{"$f":"IF($JH28<>\"\",Tabelle!U8,\"\")","v":""},{"$f":"IF($JH28<>\"\",Tabelle!V8,\"\")","v":""},null,"","",null,1502]
[{"$nulls":8},"",null,"","","",null,10,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G29=FA$20,$E29<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G29=HB$20,$E29<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G29=HO$20,$E29<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G29=IE$20,$E29<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,{"$f":"IF(IS30-IL29-IQ29<0,0,IS30-IL29-IQ29)","v":3650},"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH29<>\"\",Tabelle!P9,\"\")","v":""},{"$f":"IF($JH29<>\"\",Tabelle!Q9,\"\")","v":""},null,"","",{"$f":"IF($JH29<>\"\",Tabelle!U9,\"\")","v":""},{"$f":"IF($JH29<>\"\",Tabelle!V9,\"\")","v":""},null,"","",null,1601]
[{"$nulls":8},"",null,"","","",null,11,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G30=FA$20,$E30<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G30=HB$20,$E30<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G30=HO$20,$E30<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G30=IE$20,$E30<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH30<>\"\",Tabelle!P10,\"\")","v":""},{"$f":"IF($JH30<>\"\",Tabelle!Q10,\"\")","v":""},null,"","",{"$f":"IF($JH30<>\"\",Tabelle!U10,\"\")","v":""},{"$f":"IF($JH30<>\"\",Tabelle!V10,\"\")","v":""},null,"","",null,1602]
[{"$nulls":8},"",null,"","","",null,12,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",{"$f":"IF(AND(CT31<>\"\",CU31<>\"\"),IF(($CY32-(CT31*365+CU31))<0,$CY32,(CT31*365+CU31)),0)","v":0},"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G31=FA$20,$E31<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G31=HB$20,$E31<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G31=HO$20,$E31<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G31=IE$20,$E31<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH31<>\"\",Tabelle!P11,\"\")","v":""},{"$f":"IF($JH31<>\"\",Tabelle!Q11,\"\")","v":""},null,"","",{"$f":"IF($JH31<>\"\",Tabelle!U11,\"\")","v":""},{"$f":"IF($JH31<>\"\",Tabelle!V11,\"\")","v":""},null,"","",null,1701]
[{"$nulls":8},"",null,"","","",null,13,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",{"$f":"IF(AND(CH32<>\"\",CI32<>\"\"),IF(($CY33-(CH32*365+CI32))<0,$CY33,(CH32*365+CI32)),0)","v":0},"","","","","",0,0,"","","","",{"$f":"IF(AND(CT32<>\"\",CU32<>\"\"),IF(($CY33-(CT32*365+CU32))<0,$CY33,(CT32*365+CU32)),0)","v":0},"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G32=FA$20,$E32<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G32=HB$20,$E32<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G32=HO$20,$E32<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G32=IE$20,$E32<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH32<>\"\",Tabelle!P12,\"\")","v":""},{"$f":"IF($JH32<>\"\",Tabelle!Q12,\"\")","v":""},null,"","",{"$f":"IF($JH32<>\"\",Tabelle!U12,\"\")","v":""},{"$f":"IF($JH32<>\"\",Tabelle!V12,\"\")","v":""},null,"","",null,1801]
[{"$nulls":8},"",null,"","","",null,14,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",{"$f":"IF(AND(CH33<>\"\",CI33<>\"\"),IF(($CY34-(CH33*365+CI33))<0,$CY34,(CH33*365+CI33)),0)","v":0},"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G33=FA$20,$E33<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G33=HB$20,$E33<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G33=HO$20,$E33<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G33=IE$20,$E33<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH33<>\"\",Tabelle!P13,\"\")","v":""},{"$f":"IF($JH33<>\"\",Tabelle!Q13,\"\")","v":""},null,"","",{"$f":"IF($JH33<>\"\",Tabelle!U13,\"\")","v":""},{"$f":"IF($JH33<>\"\",Tabelle!V13,\"\")","v":""},null,"","",null,1802]
[{"$nulls":8},"",null,"","","",null,15,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G34=FA$20,$E34<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G34=HB$20,$E34<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G34=HO$20,$E34<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G34=IE$20,$E34<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH34<>\"\",Tabelle!P14,\"\")","v":""},{"$f":"IF($JH34<>\"\",Tabelle!Q14,\"\")","v":""},null,"","",{"$f":"IF($JH34<>\"\",Tabelle!U14,\"\")","v":""},{"$f":"IF($JH34<>\"\",Tabelle!V14,\"\")","v":""},null,"","",null,1803]
[{"$nulls":8},"",null,"","","",null,16,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G35=FA$20,$E35<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G35=HB$20,$E35<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G35=HO$20,$E35<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G35=IE$20,$E35<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH35<>\"\",Tabelle!P15,\"\")","v":""},{"$f":"IF($JH35<>\"\",Tabelle!Q15,\"\")","v":""},null,"","",{"$f":"IF($JH35<>\"\",Tabelle!U15,\"\")","v":""},{"$f":"IF($JH35<>\"\",Tabelle!V15,\"\")","v":""},null,"","",null,1804]
[{"$nulls":8},"",null,"","","",null,17,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G36=FA$20,$E36<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G36=HB$20,$E36<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G36=HO$20,$E36<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G36=IE$20,$E36<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH36<>\"\",Tabelle!P16,\"\")","v":""},{"$f":"IF($JH36<>\"\",Tabelle!Q16,\"\")","v":""},null,"","",{"$f":"IF($JH36<>\"\",Tabelle!U16,\"\")","v":""},{"$f":"IF($JH36<>\"\",Tabelle!V16,\"\")","v":""},null,"","",null,1805]
[{"$nulls":8},"",null,"","","",null,18,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G37=FA$20,$E37<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G37=HB$20,$E37<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G37=HO$20,$E37<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G37=IE$20,$E37<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH37<>\"\",Tabelle!P17,\"\")","v":""},{"$f":"IF($JH37<>\"\",Tabelle!Q17,\"\")","v":""},null,"","",{"$f":"IF($JH37<>\"\",Tabelle!U17,\"\")","v":""},{"$f":"IF($JH37<>\"\",Tabelle!V17,\"\")","v":""},null,"","",null,7801]
[{"$nulls":8},"",null,"","","",null,19,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G38=FA$20,$E38<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G38=HB$20,$E38<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G38=HO$20,$E38<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G38=IE$20,$E38<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH38<>\"\",Tabelle!P18,\"\")","v":""},{"$f":"IF($JH38<>\"\",Tabelle!Q18,\"\")","v":""},null,"","",{"$f":"IF($JH38<>\"\",Tabelle!U18,\"\")","v":""},{"$f":"IF($JH38<>\"\",Tabelle!V18,\"\")","v":""},null,"","",null,7802]
[{"$nulls":8},{"$f":"IF(H39=\"\",\"\",\"/\")","v":""},null,"","","",null,20,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G39=FA$20,$E39<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G39=HB$20,$E39<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G39=HO$20,$E39<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G39=IE$20,$E39<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH39<>\"\",Tabelle!P19,\"\")","v":""},{"$f":"IF($JH39<>\"\",Tabelle!Q19,\"\")","v":""},null,"","",{"$f":"IF($JH39<>\"\",Tabelle!U19,\"\")","v":""},{"$f":"IF($JH39<>\"\",Tabelle!V19,\"\")","v":""},null,"","",null,7803]
[{"$nulls":8},"",null,"","","",null,21,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G40=FA$20,$E40<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G40=HB$20,$E40<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G40=HO$20,$E40<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G40=IE$20,$E40<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH40<>\"\",Tabelle!P20,\"\")","v":""},{"$f":"IF($JH40<>\"\",Tabelle!Q20,\"\")","v":""},null,"","",{"$f":"IF($JH40<>\"\",Tabelle!U20,\"\")","v":""},{"$f":"IF($JH40<>\"\",Tabelle!V20,\"\")","v":""},null,"","",null,7804]
[{"$nulls":8},"",null,"","","",null,22,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G41=FA$20,$E41<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G41=HB$20,$E41<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G41=HO$20,$E41<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G41=IE$20,$E41<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH41<>\"\",Tabelle!P21,\"\")","v":""},{"$f":"IF($JH41<>\"\",Tabelle!Q21,\"\")","v":""},null,"","",{"$f":"IF($JH41<>\"\",Tabelle!U21,\"\")","v":""},{"$f":"IF($JH41<>\"\",Tabelle!V21,\"\")","v":""},null,"","",null,7805]
[{"$nulls":8},"",null,"","","",null,23,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G42=FA$20,$E42<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G42=HB$20,$E42<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G42=HO$20,$E42<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G42=IE$20,$E42<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH42<>\"\",Tabelle!P22,\"\")","v":""},{"$f":"IF($JH42<>\"\",Tabelle!Q22,\"\")","v":""},null,"","",{"$f":"IF($JH42<>\"\",Tabelle!U22,\"\")","v":""},{"$f":"IF($JH42<>\"\",Tabelle!V22,\"\")","v":""},null,"","",null,7806]
[{"$nulls":8},"",null,"","","",null,24,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G43=FA$20,$E43<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G43=HB$20,$E43<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,"","",{"$f":"IF(AND($G43=HO$20,$E43<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G43=IE$20,$E43<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH43<>\"\",Tabelle!P23,\"\")","v":""},{"$f":"IF($JH43<>\"\",Tabelle!Q23,\"\")","v":""},null,"","",{"$f":"IF($JH43<>\"\",Tabelle!U23,\"\")","v":""},{"$f":"IF($JH43<>\"\",Tabelle!V23,\"\")","v":""},null,"","",null,7807]
[{"$nulls":8},"",null,"","","",null,25,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G44=FA$20,$E44<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G44=HB$20,$E44<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,{"$f":"IF(AND(HG44<>\"\",HH44<>\"\"),IF((HL45-(HG44*365+HH44))<0,HL45,(HG44*365+HH44)),0)","v":0},"","",1825,"","",{"$f":"IF(AND($G44=HO$20,$E44<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G44=IE$20,$E44<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,0,3650,"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH44<>\"\",Tabelle!P24,\"\")","v":""},{"$f":"IF($JH44<>\"\",Tabelle!Q24,\"\")","v":""},null,"","",{"$f":"IF($JH44<>\"\",Tabelle!U24,\"\")","v":""},{"$f":"IF($JH44<>\"\",Tabelle!V24,\"\")","v":""},null,"","",null,8601]
[{"$nulls":8},"",null,"","","",null,26,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",0,"","","","","",0,0,"","","","",0,"","",{"$f":"CY46-CJ45-CV45","v":1825},"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G45=FA$20,$E45<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G45=HB$20,$E45<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,{"$f":"IF(AND(HG45<>\"\",HH45<>\"\"),IF((HL46-(HG45*365+HH45))<0,HL46,(HG45*365+HH45)),0)","v":0},"","",{"$f":"IF(HL46-HI45<0,0,HL46-HI45)","v":1825},"","",{"$f":"IF(AND($G45=HO$20,$E45<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",1825,0,0,3650,"","",{"$f":"IF(AND($G45=IE$20,$E45<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,{"$f":"IF(AND(IJ45<>\"\",IK45<>\"\"),IF((IO46-(IJ45*365+IK45))<0,IO46,(IJ45*365+IK45)),0)","v":0},"","",{"$f":"IF(IO46-IL45<0,0,IO46-IL45)","v":1825},0,0,0,{"$f":"IF(IS46-IL45-IQ45<0,0,IS46-IL45-IQ45)","v":3650},"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH45<>\"\",Tabelle!P25,\"\")","v":""},{"$f":"IF($JH45<>\"\",Tabelle!Q25,\"\")","v":""},null,"","",{"$f":"IF($JH45<>\"\",Tabelle!U25,\"\")","v":""},{"$f":"IF($JH45<>\"\",Tabelle!V25,\"\")","v":""},null,"","",null,8801]
[{"$nulls":8},"",null,"","","",null,27,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,"","","","",{"$f":"IF(AND(CH46<>\"\",CI46<>\"\"),IF(($CY$21-(CH46*365+CI46))<0,$CY$21,(CH46*365+CI46)),0)","v":0},"","","","","",0,0,"","","","",{"$f":"IF(AND(CT46<>\"\",CU46<>\"\"),IF(($CY$21-(CT46*365+CU46))<0,$CY$21,(CT46*365+CU46)),0)","v":0},"","",{"$f":"$CY$21-CJ46-CV46","v":1825},"","",{"$f":"\"\"","v":""},0,0,"","","","",0,"","",1825,"","","",0,0,"","","","",0,"","",1095,"","","","","","","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"IF(AND($G46=FA$20,$E46<>\"\",OR(Nebenrechnung!$H$3<3,Nebenrechnung!$H$3>4)),\"nur für Vollzug!\",\"\")","v":""},0,0,"","","","",0,"","",1825,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",730,"","",{"$f":"\"\"","v":""},"","","","","","","","","",0,0,"","",0,"","",1095,"","",{"$f":"IF(AND($G46=HB$20,$E46<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,{"$f":"IF(AND(HG46<>\"\",HH46<>\"\"),IF((HL21-(HG46*365+HH46))<0,HL21,(HG46*365+HH46)),0)","v":0},"","",{"$f":"IF(HL21-HI46<0,0,HL21-HI46)","v":1825},"","",{"$f":"IF(AND($G46=HO$20,$E46<>\"\",Nebenrechnung!$H$3<>7),\"nur für Uni-Professoren!\",\"\")","v":""},0,0,"","",0,0,0,"","",{"$f":"HY45-HV46","v":1825},0,0,3650,"","",{"$f":"IF(AND($G46=IE$20,$E46<>\"\",OR(Nebenrechnung!$H$3<5,Nebenrechnung!$H$3>6)),\"nur für FH-Professoren!\",\"\")","v":""},0,0,"","",0,0,{"$f":"IF(AND(IJ46<>\"\",IK46<>\"\"),IF((IO21-(IJ46*365+IK46))<0,IO21,(IJ46*365+IK46)),0)","v":0},"","",{"$f":"IF(IO21-IL46<0,0,IO21-IL46)","v":1825},0,0,0,{"$f":"IF(IS21-IL46-IQ46-SUM($IR$22:$IR$46)<0,0,IS21-IL46-IQ46-SUM($IR$22:$IR$46))","v":3650},"","","","","","","","","",{"$nulls":4},"","",{"$f":"IF($JH46<>\"\",Tabelle!P26,\"\")","v":""},{"$f":"IF($JH46<>\"\",Tabelle!Q26,\"\")","v":""},null,"","",{"$f":"IF($JH46<>\"\",Tabelle!U26,\"\")","v":""},{"$f":"IF($JH46<>\"\",Tabelle!V26,\"\")","v":""},null,"","",null,8802]
[{"$nulls":8},"Zwischenberechnung",null,{"$f":"IF(SUM(K22:K46)=0,\"\",SUM(K22:K46))","v":""},{"$f":"IF(SUM(L22:L46)=0,\"\",SUM(L22:L46))","v":""},null,null,28,{"$nulls":3},{"$f":"IF(SUM(S22:S46)=0,\"\",SUM(S22:S46))","v":""},{"$f":"IF(SUM(T22:T46)=0,\"\",SUM(T22:T46))","v":""},{"$nulls":7},{"$f":"IF(SUM(AB22:AB46)=0,\"\",SUM(AB22:AB46))","v":""},{"$f":"IF(SUM(AC22:AC46)=0,\"\",SUM(AC22:AC46))","v":""},{"$nulls":3},{"$f":"IF(SUM(AG22:AG46)=0,\"\",SUM(AG22:AG46))","v":""},{"$f":"IF(SUM(AH22:AH46)=0,\"\",SUM(AH22:AH46))","v":""},{"$nulls":3},{"$f":"IF(SUM(AL22:AL46)=0,\"\",SUM(AL22:AL46))","v":""},{"$f":"IF(SUM(AM22:AM46)=0,\"\",SUM(AM22:AM46))","v":""},{"$nulls":13},{"$f":"IF(SUM(BA22:BA46)=0,\"\",SUM(BA22:BA46))","v":""},{"$f":"IF(SUM(BB22:BB46)=0,\"\",SUM(BB22:BB46))","v":""},{"$nulls":3},{"$f":"IF(SUM(BF22:BF46)=0,\"\",SUM(BF22:BF46))","v":""},{"$f":"IF(SUM(BG22:BG46)=0,\"\",SUM(BG22:BG46))","v":""},{"$nulls":7},{"$f":"IF(SUM(BO22:BO46)=0,\"\",SUM(BO22:BO46))","v":""},{"$f":"IF(SUM(BP22:BP46)=0,\"\",SUM(BP22:BP46))","v":""},{"$nulls":13},{"$f":"IF(SUM(CD22:CD46)=0,\"\",SUM(CD22:CD46))","v":""},{"$f":"IF(SUM(CE22:CE46)=0,\"\",SUM(CE22:CE46))","v":""},{"$nulls":10},{"$f":"IF(SUM(CP22:CP46)=0,\"\",SUM(CP22:CP46))","v":""},{"$f":"IF(SUM(CQ22:CQ46)=0,\"\",SUM(CQ22:CQ46))","v":""},{"$nulls":11},{"$f":"IF(SUM(DC22:DC46)=0,\"\",SUM(DC22:DC46))","v":""},{"$f":"IF(SUM(DD22:DD46)=0,\"\",SUM(DD22:DD46))","v":""},{"$nulls":11},{"$f":"IF(SUM(DP22:DP46)=0,\"\",SUM(DP22:DP46))","v":""},{"$f":"IF(SUM(DQ22:DQ46)=0,\"\",SUM(DQ22:DQ46))","v":""},{"$nulls":11},{"$f":"IF(SUM(EC22:EC46)=0,\"\",SUM(EC22:EC46))","v":""},{"$f":"IF(SUM(ED22:ED46)=0,\"\",SUM(ED22:ED46))","v":""},{"$nulls":3},{"$f":"IF(SUM(EH22:EH46)=0,\"\",SUM(EH22:EH46))","v":""},{"$f":"IF(SUM(EI22:EI46)=0,\"\",SUM(EI22:EI46))","v":""},{"$nulls":7},{"$f":"IF(SUM(EQ22:EQ46)=0,\"\",SUM(EQ22:EQ46))","v":""},{"$f":"IF(SUM(ER22:ER46)=0,\"\",SUM(ER22:ER46))","v":""},{"$nulls":9},{"$f":"IF(SUM(FB22:FB46)=0,\"\",SUM(FB22:FB46))","v":""},{"$f":"IF(SUM(FC22:FC46)=0,\"\",SUM(FC22:FC46))","v":""},{"$nulls":11},{"$f":"IF(SUM(FO22:FO46)=0,\"\",SUM(FO22:FO46))","v":""},{"$f":"IF(SUM(FP22:FP46)=0,\"\",SUM(FP22:FP46))","v":""},{"$nulls":7},{"$f":"IF(SUM(FX22:FX46)=0,\"\",SUM(FX22:FX46))","v":""},{"$f":"IF(SUM(FY22:FY46)=0,\"\",SUM(FY22:FY46))","v":""},{"$nulls":9},{"$f":"IF(SUM(GI22:GI46)=0,\"\",SUM(GI22:GI46))","v":""},{"$f":"IF(SUM(GJ22:GJ46)=0,\"\",SUM(GJ22:GJ46))","v":""},{"$nulls":7},{"$f":"IF(SUM(GR22:GR46)=0,\"\",SUM(GR22:GR46))","v":""},{"$f":"IF(SUM(GS22:GS46)=0,\"\",SUM(GS22:GS46))","v":""},{"$nulls":9},{"$f":"IF(SUM(HC22:HC46)=0,\"\",SUM(HC22:HC46))","v":""},{"$f":"IF(SUM(HD22:HD46)=0,\"\",SUM(HD22:HD46))","v":""},{"$nulls":11},{"$f":"IF(SUM(HP22:HP46)=0,\"\",SUM(HP22:HP46))","v":""},{"$f":"IF(SUM(HQ22:HQ46)=0,\"\",SUM(HQ22:HQ46))","v":""},{"$nulls":14},{"$f":"IF(SUM(IF22:IF46)=0,\"\",SUM(IF22:IF46))","v":""},{"$f":"IF(SUM(IG22:IG46)=0,\"\",SUM(IG22:IG46))","v":""},{"$nulls":15},{"$f":"IF(SUM(IW22:IW46)=0,\"\",SUM(IW22:IW46))","v":""},{"$f":"IF(SUM(IX22:IX46)=0,\"\",SUM(IX22:IX46))","v":""},{"$nulls":21},""]
[{"$nulls":8},"das sind umgerechnet",null,{"$f":"IF(AND(K47=\"\",L47=\"\"),\"\",IF(AND(K47>0,L47=\"\"),K47,IF(AND(K47=\"\",L47>0),ROUND(L47/365,2),IF(AND(K47>0,L47>0),ROUND(L47/365,2)+K47,\"\"))))","v":""}," Jahre"]
[]
[{"$nulls":8},"ruhegehaltfähige Dienstjahre x Faktor",null,{"$f":"K48","v":""},{"$f":"IF(K48=\"\",\"\",\"  x 1,79375\")","v":""}]
[]
[{"$nulls":8},"Ruhegehaltsatz (Jahre x 1,79375 v.H.)",null,{"$f":"IF(K48=\"\",\"\",IF(ROUNDUP(K48*1.79375,2)<71.75,ROUNDUP(K48*1.79375,2),71.75))","v":""},"  v.H."]
[{"$nulls":15},"Plausiprüfungen"]
[]
[{"$nulls":8},"ruhegehaltfähige Dienstbezüge",null,null,"  €",{"$nulls":3},"vorzeitiger Vers.beg",null,{"$f":"IF(OR(F18<>\"\",AND(Nebenrechnung!D3<3,Vordruck!E18<>\"\")),1,0)","v":0}]
[]
[{"$nulls":8},"Ruhegehaltsatz",null,{"$f":"IF($K$52=\"\",\"\",$K$52)","v":""},"  v.H.",{"$nulls":3},"Kommentar: Achtung",null,{"$f":"IF(COUNTIF(M22:M46,\"Achtung!\")>0,1,0)","v":0}]
[]
[{"$nulls":8},"Zwischenergebnis",null,{"$f":"IF(OR(K55=\"\",K57=\"\"),\"\",ROUND(K55*K57/100,2))","v":""},"  €"]
[]
[{"$nulls":8},"./. Versorgungsabschlag",null,{"$f":"IF(K59=\"\",\"\",Nebenrechnung!$W$6)","v":""},"  %    "]
[]
[{"$nulls":8},{"$f":"IF(R65>0,\"Eingaben prüfen!\",\"voraussichtliches Ruhegehalt\")","v":"voraussichtliches Ruhegehalt"},null,{"$f":"IF(K59=\"\",\"\",IF(R65>0,\"---\",ROUND($K$59-($K$59*$K$61/100),2)))","v":""},"  €"]
[]
[{"$nulls":15},"Summe",null,{"$f":"SUM(R55:R64)","v":0}]

{"sheet":"Tabelle","index":1,"n_rows":26,"n_cols":23,"rows_kept":26,"hidden":true}
["Anfangs-datum","End-        datum","1.","2.","1. Korrektur wg. Schaltjahr","3.","4.","2. Korrektur wg. Schaltjahr","5.","6.","3. Korrektur wg. Schaltjahr","7.","8.","4. Korrektur wg. Schaltjahr","Korrektur wg. Schaltjahr iVm Zurechnungszeit","Jahre","Tage","gerundet","Bruchteil der Zu-rechnungs-zeit",null,"Zurechnungs-zeit","Jahre","Tage"]
[{"$f":"IF(Vordruck!E22=\"\",\"\",Vordruck!E22)","v":""},{"$f":"IF(Vordruck!JH22<>\"\",Vordruck!JH22,\"\")","v":""},{"$f":"IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)=0),IF(OR(AND(MONTH(A2)<3,MONTH(B2>2),AND(MONTH(A2)>2,MONTH(B2)<3))),TRUE,FALSE),B2)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)=0,OR(AND(MONTH(A2)<3,MONTH(B2)>2,AND(MONTH(A2)>2,MONTH(B2)<3),AND(MONTH(B2)>2,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2)))),TRUE,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C2<>\"\",D2<>\"\"),IF(OR(B2=\"\",A2=\"\"),IF(AND(C2=FALSE,D2=TRUE),B2-1,B2),IF(OR(AND(C2=FALSE,D2=TRUE),AND(C2=TRUE,D2=TRUE,(A2-B2)=1)),B2-1,B2)),B2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD(YEAR(B2),4)=0),IF(OR(AND(DAY(B2)=29,MONTH(B2)=2),AND(MONTH(B2)>2,MONTH(A2)<3),AND(MONTH(B2)>2,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2)),TRUE,FALSE),B2))","v":""},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD(YEAR(B2),4)=0,OR(AND(DAY(B2)=29,MONTH(B2)=2,MONTH(A2)>2),AND(MONTH(B2)>2,MONTH(A2)<3),AND(MONTH(B2)<2,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2))),TRUE,FALSE))","v":""},{"$f":"IF(E2<>\"\",IF(OR(B2=\"\",A2=\"\"),E2,IF(OR(AND(F2=FALSE,D2=TRUE,C2=FALSE),AND(F2=FALSE,G2=TRUE),AND(C2=FALSE,G2=TRUE)),B2-1,IF(OR(B2=\"\",A2=\"\"),E2,IF(AND(OR(AND(D2=TRUE,F2=TRUE),AND(F2=TRUE,G2=TRUE),AND(C2=TRUE,G2=TRUE)),(0-B2)=1),B2-1,E2)))),E2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)<>0),IF(AND(MONTH(A2)<3,OR(MONTH(B2)<MONTH(A2),AND(MONTH(B2)=MONTH(A2),DAY(B2)<DAY(A2)))),TRUE,FALSE),B2))","v":""},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)<>0,YEAR(B2)-1=YEAR(A2),AND(DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2,MONTH(A2)<3)),TRUE,FALSE))","v":""},{"$f":"IF(AND(E2<>\"\",H2<>\"\"),IF(OR(B2=\"\",A2=\"\"),H2,IF(OR(AND(I2=FALSE,J2=TRUE),AND(I2=TRUE,J2=TRUE,(0-B2)=1)),IF(AND(J2=TRUE,L2=TRUE,(0-B2)<>1),H2,B2-1),H2)),H2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD((YEAR(B2)-1),4)=0,MONTH(A2)<3,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2),TRUE,FALSE))","v":""},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD((YEAR(B2)-1),4)=0,MONTH(A2)<3,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2),TRUE,FALSE))","v":""},{"$f":"IF(AND(E2<>\"\",H2<>\"\"),IF(OR(B2=\"\",A2=\"\"),K2,IF(OR(AND(I2=FALSE,M2=TRUE),AND(L2=FALSE,M2=TRUE),AND(I2=TRUE,M2=TRUE),AND(L2=TRUE,M2=TRUE,(0-B2)=1)),B2-1,K2)),K2)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E2<>\"\",H2<>\"\"),IF(OR(B2=\"\",A2=\"\"),K2,IF(OR(AND(I2=FALSE,M2=TRUE),AND(L2=FALSE,M2=TRUE),AND(I2=TRUE,M2=TRUE),AND(L2=TRUE,M2=TRUE,(0-B2)=1)),B2-1,K2)),K2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(A2=\"\",A2=0),\"\",IF(AND(DAY(A2)=1,MONTH(A2)=1,DAY(B2)=31,MONTH(B2)=12),YEAR(B2)-YEAR(A2)+1,IF(OR(MONTH(B2)>MONTH(A2),(AND(MONTH(B2)=MONTH(A2),DAY(B2)>=DAY(A2))),(DATE(YEAR(B2),MONTH(A2),DAY(A2)))-B2=1),YEAR(B2)-YEAR(A2),(YEAR(B2)-1)-YEAR(A2))))","v":""},{"$f":"IF(OR(A2=\"\",A2=0),\"\",IF(AND(DAY(A2)=1,MONTH(A2)=1,DAY(B2)=31,MONTH(B2)=12),0,IF(DATE(YEAR(B2),MONTH(A2),DAY(A2))-B2=1,0,IF(B2>=(DATE(YEAR(B2),MONTH(A2),DAY(A2))),B2-DATE(YEAR(B2),MONTH(A2),DAY(A2))+1,B2-(DATE(YEAR(B2)-1,MONTH(A2),DAY(A2)))+1))))","v":""},{"$f":"IF(Q2=0,0,IF(Q2=\"\",\"\",ROUNDDOWN((Q2+0.009),2)))","v":""}]
[{"$f":"IF(Vordruck!E23=\"\",\"\",Vordruck!E23)","v":""},{"$f":"IF(Vordruck!JH23<>\"\",Vordruck!JH23,\"\")","v":""},{"$f":"IF(AND(MOD(YEAR(A3),4)=0,MOD(YEAR(B3),4)=0),IF(OR(AND(MONTH(A3)<3,MONTH(B3>2),AND(MONTH(A3)>2,MONTH(B3)<3))),TRUE,FALSE),B3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(MOD(YEAR(A3),4)=0,MOD(YEAR(B3),4)=0,OR(AND(MONTH(A3)<3,MONTH(B3)>2,AND(MONTH(A3)>2,MONTH(B3)<3),AND(MONTH(B3)>2,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3)))),TRUE,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C3<>\"\",D3<>\"\"),IF(OR(B3=\"\",A3=\"\"),IF(AND(C3=FALSE,D3=TRUE),B3-1,B3),IF(OR(AND(C3=FALSE,D3=TRUE),AND(C3=TRUE,D3=TRUE,(A3-B3)=1)),B3-1,B3)),B3)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)<>0,MOD(YEAR(B3),4)=0),IF(OR(AND(DAY(B3)=29,MONTH(B3)=2),AND(MONTH(B3)>2,MONTH(A3)<3),AND(MONTH(B3)>2,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3)),TRUE,FALSE),B3))","v":""},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)<>0,MOD(YEAR(B3),4)=0,OR(AND(DAY(B3)=29,MONTH(B3)=2,MONTH(A3)>2),AND(MONTH(B3)>2,MONTH(A3)<3),AND(MONTH(B3)<2,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3))),TRUE,FALSE))","v":""},{"$f":"IF(E3<>\"\",IF(OR(B3=\"\",A3=\"\"),E3,IF(OR(AND(F3=FALSE,D3=TRUE,C3=FALSE),AND(F3=FALSE,G3=TRUE),AND(C3=FALSE,G3=TRUE)),B3-1,IF(OR(B3=\"\",A3=\"\"),E3,IF(AND(OR(AND(D3=TRUE,F3=TRUE),AND(F3=TRUE,G3=TRUE),AND(C3=TRUE,G3=TRUE)),(0-B3)=1),B3-1,E3)))),E3)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)=0,MOD(YEAR(B3),4)<>0),IF(AND(MONTH(A3)<3,OR(MONTH(B3)<MONTH(A3),AND(MONTH(B3)=MONTH(A3),DAY(B3)<DAY(A3)))),TRUE,FALSE),B3))","v":""},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)=0,MOD(YEAR(B3),4)<>0,YEAR(B3)-1=YEAR(A3),AND(DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3,MONTH(A3)<3)),TRUE,FALSE))","v":""},{"$f":"IF(AND(E3<>\"\",H3<>\"\"),IF(OR(B3=\"\",A3=\"\"),H3,IF(OR(AND(I3=FALSE,J3=TRUE),AND(I3=TRUE,J3=TRUE,(0-B3)=1)),IF(AND(J3=TRUE,L3=TRUE,(0-B3)<>1),H3,B3-1),H3)),H3)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)<>0,MOD((YEAR(B3)-1),4)=0,MONTH(A3)<3,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3),TRUE,FALSE))","v":""},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)<>0,MOD((YEAR(B3)-1),4)=0,MONTH(A3)<3,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3),TRUE,FALSE))","v":""},{"$f":"IF(AND(E3<>\"\",H3<>\"\"),IF(OR(B3=\"\",A3=\"\"),K3,IF(OR(AND(I3=FALSE,M3=TRUE),AND(L3=FALSE,M3=TRUE),AND(I3=TRUE,M3=TRUE),AND(L3=TRUE,M3=TRUE,(0-B3)=1)),B3-1,K3)),K3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E3<>\"\",H3<>\"\"),IF(OR(B3=\"\",A3=\"\"),K3,IF(OR(AND(I3=FALSE,M3=TRUE),AND(L3=FALSE,M3=TRUE),AND(I3=TRUE,M3=TRUE),AND(L3=TRUE,M3=TRUE,(0-B3)=1)),B3-1,K3)),K3)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(A3=\"\",A3=0),\"\",IF(AND(DAY(A3)=1,MONTH(A3)=1,DAY(B3)=31,MONTH(B3)=12),YEAR(B3)-YEAR(A3)+1,IF(OR(MONTH(B3)>MONTH(A3),(AND(MONTH(B3)=MONTH(A3),DAY(B3)>=DAY(A3))),(DATE(YEAR(B3),MONTH(A3),DAY(A3)))-B3=1),YEAR(B3)-YEAR(A3),(YEAR(B3)-1)-YEAR(A3))))","v":""},{"$f":"IF(OR(A3=\"\",A3=0),\"\",IF(AND(DAY(A3)=1,MONTH(A3)=1,DAY(B3)=31,MONTH(B3)=12),0,IF(DATE(YEAR(B3),MONTH(A3),DAY(A3))-B3=1,0,IF(B3>=(DATE(YEAR(B3),MONTH(A3),DAY(A3))),B3-DATE(YEAR(B3),MONTH(A3),DAY(A3))+1,B3-(DATE(YEAR(B3)-1,MONTH(A3),DAY(A3)))+1))))","v":""},{"$f":"IF(Q3=0,0,IF(Q3=\"\",\"\",ROUNDDOWN((Q3+0.009),2)))","v":""}]
[{"$f":"IF(Vordruck!E24=\"\",\"\",Vordruck!E24)","v":""},{"$f":"IF(Vordruck!JH24<>\"\",Vordruck!JH24,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E25=\"\",\"\",Vordruck!E25)","v":""},{"$f":"IF(Vordruck!JH25<>\"\",Vordruck!JH25,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E26=\"\",\"\",Vordruck!E26)","v":""},{"$f":"IF(Vordruck!JH26<>\"\",Vordruck!JH26,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E27=\"\",\"\",Vordruck!E27)","v":""},{"$f":"IF(Vordruck!JH27<>\"\",Vordruck!JH27,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E28=\"\",\"\",Vordruck!E28)","v":""},{"$f":"IF(Vordruck!JH28<>\"\",Vordruck!JH28,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E29=\"\",\"\",Vordruck!E29)","v":""},{"$f":"IF(Vordruck!JH29<>\"\",Vordruck!JH29,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E30=\"\",\"\",Vordruck!E30)","v":""},{"$f":"IF(Vordruck!JH30<>\"\",Vordruck!JH30,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E31=\"\",\"\",Vordruck!E31)","v":""},{"$f":"IF(Vordruck!JH31<>\"\",Vordruck!JH31,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E32=\"\",\"\",Vordruck!E32)","v":""},{"$f":"IF(Vordruck!JH32<>\"\",Vordruck!JH32,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E33=\"\",\"\",Vordruck!E33)","v":""},{"$f":"IF(Vordruck!JH33<>\"\",Vordruck!JH33,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E34=\"\",\"\",Vordruck!E34)","v":""},{"$f":"IF(Vordruck!JH34<>\"\",Vordruck!JH34,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E35=\"\",\"\",Vordruck!E35)","v":""},{"$f":"IF(Vordruck!JH35<>\"\",Vordruck!JH35,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E36=\"\",\"\",Vordruck!E36)","v":""},{"$f":"IF(Vordruck!JH36<>\"\",Vordruck!JH36,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E37=\"\",\"\",Vordruck!E37)","v":""},{"$f":"IF(Vordruck!JH37<>\"\",Vordruck!JH37,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E38=\"\",\"\",Vordruck!E38)","v":""},{"$f":"IF(Vordruck!JH38<>\"\",Vordruck!JH38,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E39=\"\",\"\",Vordruck!E39)","v":""},{"$f":"IF(Vordruck!JH39<>\"\",Vordruck!JH39,\"\")","v":""},{"$f":"IF(AND(MOD(YEAR(A19),4)=0,MOD(YEAR(B19),4)=0),IF(OR(AND(MONTH(A19)<3,MONTH(B19>2),AND(MONTH(A19)>2,MONTH(B19)<3))),TRUE,FALSE),B19)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(MOD(YEAR(A19),4)=0,MOD(YEAR(B19),4)=0,OR(AND(MONTH(A19)<3,MONTH(B19)>2,AND(MONTH(A19)>2,MONTH(B19)<3),AND(MONTH(B19)>2,DATE(YEAR(B19),MONTH(A19),DAY(A19))>B19)))),TRUE,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C19<>\"\",D19<>\"\"),IF(OR(B19=\"\",A19=\"\"),IF(AND(C19=FALSE,D19=TRUE),B19-1,B19),IF(OR(AND(C19=FALSE,D19=TRUE),AND(C19=TRUE,D19=TRUE,(A19-B19)=1)),B19-1,B19)),B19)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B19=\"\",A19=\"\"),\"\",IF(AND(MOD(YEAR(A19),4)<>0,MOD(YEAR(B19),4)=0),IF(OR(AND(DAY(B19)=29,MONTH(B19)=2),AND(MONTH(B19)>2,MONTH(A19)<3),AND(MONTH(B19)>2,DATE(YEAR(B19),MONTH(A19),DAY(A19))>B19)),TRUE,FALSE),B19))","v":""},{"$f":"IF(OR(B19=\"\",A19=\"\"),\"\",IF(AND(MOD(YEAR(A19),4)<>0,MOD(YEAR(B19),4)=0,OR(AND(DAY(B19)=29,MONTH(B19)=2,MONTH(A19)>2),AND(MONTH(B19)>2,MONTH(A19)<3),AND(MONTH(B19)<2,DATE(YEAR(B19),MONTH(A19),DAY(A19))>B19))),TRUE,FALSE))","v":""},{"$f":"IF(E19<>\"\",IF(OR(B19=\"\",A19=\"\"),E19,IF(OR(AND(F19=FALSE,D19=TRUE,C19=FALSE),AND(F19=FALSE,G19=TRUE),AND(C19=FALSE,G19=TRUE)),B19-1,IF(OR(B19=\"\",A19=\"\"),E19,IF(AND(OR(AND(D19=TRUE,F19=TRUE),AND(F19=TRUE,G19=TRUE),AND(C19=TRUE,G19=TRUE)),(0-B19)=1),B19-1,E19)))),E19)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B19=\"\",A19=\"\"),\"\",IF(AND(MOD(YEAR(A19),4)=0,MOD(YEAR(B19),4)<>0),IF(AND(MONTH(A19)<3,OR(MONTH(B19)<MONTH(A19),AND(MONTH(B19)=MONTH(A19),DAY(B19)<DAY(A19)))),TRUE,FALSE),B19))","v":""},{"$f":"IF(OR(B19=\"\",A19=\"\"),\"\",IF(AND(MOD(YEAR(A19),4)=0,MOD(YEAR(B19),4)<>0,YEAR(B19)-1=YEAR(A19),AND(DATE(YEAR(B19),MONTH(A19),DAY(A19))>B19,MONTH(A19)<3)),TRUE,FALSE))","v":""},{"$f":"IF(AND(E19<>\"\",H19<>\"\"),IF(OR(B19=\"\",A19=\"\"),H19,IF(OR(AND(I19=FALSE,J19=TRUE),AND(I19=TRUE,J19=TRUE,(0-B19)=1)),IF(AND(J19=TRUE,L19=TRUE,(0-B19)<>1),H19,B19-1),H19)),H19)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B19=\"\",A19=\"\"),\"\",IF(AND(MOD(YEAR(A19),4)<>0,MOD((YEAR(B19)-1),4)=0,MONTH(A19)<3,DATE(YEAR(B19),MONTH(A19),DAY(A19))>B19),TRUE,FALSE))","v":""},{"$f":"IF(OR(B19=\"\",A19=\"\"),\"\",IF(AND(MOD(YEAR(A19),4)<>0,MOD((YEAR(B19)-1),4)=0,MONTH(A19)<3,DATE(YEAR(B19),MONTH(A19),DAY(A19))>B19),TRUE,FALSE))","v":""},{"$f":"IF(AND(E19<>\"\",H19<>\"\"),IF(OR(B19=\"\",A19=\"\"),K19,IF(OR(AND(I19=FALSE,M19=TRUE),AND(L19=FALSE,M19=TRUE),AND(I19=TRUE,M19=TRUE),AND(L19=TRUE,M19=TRUE,(0-B19)=1)),B19-1,K19)),K19)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E19<>\"\",H19<>\"\"),IF(OR(B19=\"\",A19=\"\"),K19,IF(OR(AND(I19=FALSE,M19=TRUE),AND(L19=FALSE,M19=TRUE),AND(I19=TRUE,M19=TRUE),AND(L19=TRUE,M19=TRUE,(0-B19)=1)),B19-1,K19)),K19)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(A19=\"\",A19=0),\"\",IF(AND(DAY(A19)=1,MONTH(A19)=1,DAY(B19)=31,MONTH(B19)=12),YEAR(B19)-YEAR(A19)+1,IF(OR(MONTH(B19)>MONTH(A19),(AND(MONTH(B19)=MONTH(A19),DAY(B19)>=DAY(A19))),(DATE(YEAR(B19),MONTH(A19),DAY(A19)))-B19=1),YEAR(B19)-YEAR(A19),(YEAR(B19)-1)-YEAR(A19))))","v":""},{"$f":"IF(OR(A19=\"\",A19=0),\"\",IF(AND(DAY(A19)=1,MONTH(A19)=1,DAY(B19)=31,MONTH(B19)=12),0,IF(DATE(YEAR(B19),MONTH(A19),DAY(A19))-B19=1,0,IF(B19>=(DATE(YEAR(B19),MONTH(A19),DAY(A19))),B19-DATE(YEAR(B19),MONTH(A19),DAY(A19))+1,B19-(DATE(YEAR(B19)-1,MONTH(A19),DAY(A19)))+1))))","v":""},{"$f":"IF(Q19=0,0,IF(Q19=\"\",\"\",ROUNDDOWN((Q19+0.009),2)))","v":""}]
[{"$f":"IF(Vordruck!E40=\"\",\"\",Vordruck!E40)","v":""},{"$f":"IF(Vordruck!JH40<>\"\",Vordruck!JH40,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E41=\"\",\"\",Vordruck!E41)","v":""},{"$f":"IF(Vordruck!JH41<>\"\",Vordruck!JH41,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E42=\"\",\"\",Vordruck!E42)","v":""},{"$f":"IF(Vordruck!JH42<>\"\",Vordruck!JH42,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E43=\"\",\"\",Vordruck!E43)","v":""},{"$f":"IF(Vordruck!JH43<>\"\",Vordruck!JH43,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E44=\"\",\"\",Vordruck!E44)","v":""},{"$f":"IF(Vordruck!JH44<>\"\",Vordruck!JH44,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E45=\"\",\"\",Vordruck!E45)","v":""},{"$f":"IF(Vordruck!JH45<>\"\",Vordruck!JH45,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!E46=\"\",\"\",Vordruck!E46)","v":""},{"$f":"IF(Vordruck!JH46<>\"\",Vordruck!JH46,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]

{"sheet":"Tabelle Vergleich","index":2,"n_rows":26,"n_cols":23,"rows_kept":26,"hidden":true}
["Anfangs-datum","End-        datum","1.","2.","1. Korrektur wg. Schaltjahr","3.","4.","2. Korrektur wg. Schaltjahr","5.","6.","3. Korrektur wg. Schaltjahr","7.","8.","4. Korrektur wg. Schaltjahr","Korrektur wg. Schaltjahr iVm Zurechnungszeit","Jahre","Tage","gerundet","Bruchteil der Zu-rechnungs-zeit",null,"Zurechnungs-zeit","Jahre","Tage"]
[{"$f":"IF(Vordruck!JL22=\"\",\"\",Vordruck!JL22)","v":""},{"$f":"IF(Vordruck!JM22<>\"\",Vordruck!JM22,\"\")","v":""},{"$f":"IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)=0),IF(OR(AND(MONTH(A2)<3,MONTH(B2>2),AND(MONTH(A2)>2,MONTH(B2)<3))),TRUE,FALSE),B2)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)=0,OR(AND(MONTH(A2)<3,MONTH(B2)>2,AND(MONTH(A2)>2,MONTH(B2)<3),AND(MONTH(B2)>2,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2)))),TRUE,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C2<>\"\",D2<>\"\"),IF(OR(B2=\"\",A2=\"\"),IF(AND(C2=FALSE,D2=TRUE),B2-1,B2),IF(OR(AND(C2=FALSE,D2=TRUE),AND(C2=TRUE,D2=TRUE,(A2-B2)=1)),B2-1,B2)),B2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD(YEAR(B2),4)=0),IF(OR(AND(DAY(B2)=29,MONTH(B2)=2),AND(MONTH(B2)>2,MONTH(A2)<3),AND(MONTH(B2)>2,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2)),TRUE,FALSE),B2))","v":""},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD(YEAR(B2),4)=0,OR(AND(DAY(B2)=29,MONTH(B2)=2,MONTH(A2)>2),AND(MONTH(B2)>2,MONTH(A2)<3),AND(MONTH(B2)<2,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2))),TRUE,FALSE))","v":""},{"$f":"IF(E2<>\"\",IF(OR(B2=\"\",A2=\"\"),E2,IF(OR(AND(F2=FALSE,D2=TRUE,C2=FALSE),AND(F2=FALSE,G2=TRUE),AND(C2=FALSE,G2=TRUE)),B2-1,IF(OR(B2=\"\",A2=\"\"),E2,IF(AND(OR(AND(D2=TRUE,F2=TRUE),AND(F2=TRUE,G2=TRUE),AND(C2=TRUE,G2=TRUE)),(0-B2)=1),B2-1,E2)))),E2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)<>0),IF(AND(MONTH(A2)<3,OR(MONTH(B2)<MONTH(A2),AND(MONTH(B2)=MONTH(A2),DAY(B2)<DAY(A2)))),TRUE,FALSE),B2))","v":""},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)<>0,YEAR(B2)-1=YEAR(A2),AND(DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2,MONTH(A2)<3)),TRUE,FALSE))","v":""},{"$f":"IF(AND(E2<>\"\",H2<>\"\"),IF(OR(B2=\"\",A2=\"\"),H2,IF(OR(AND(I2=FALSE,J2=TRUE),AND(I2=TRUE,J2=TRUE,(0-B2)=1)),IF(AND(J2=TRUE,L2=TRUE,(0-B2)<>1),H2,B2-1),H2)),H2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD((YEAR(B2)-1),4)=0,MONTH(A2)<3,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2),TRUE,FALSE))","v":""},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD((YEAR(B2)-1),4)=0,MONTH(A2)<3,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2),TRUE,FALSE))","v":""},{"$f":"IF(AND(E2<>\"\",H2<>\"\"),IF(OR(B2=\"\",A2=\"\"),K2,IF(OR(AND(I2=FALSE,M2=TRUE),AND(L2=FALSE,M2=TRUE),AND(I2=TRUE,M2=TRUE),AND(L2=TRUE,M2=TRUE,(0-B2)=1)),B2-1,K2)),K2)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E2<>\"\",H2<>\"\"),IF(OR(B2=\"\",A2=\"\"),K2,IF(OR(AND(I2=FALSE,M2=TRUE),AND(L2=FALSE,M2=TRUE),AND(I2=TRUE,M2=TRUE),AND(L2=TRUE,M2=TRUE,(0-B2)=1)),B2-1,K2)),K2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(A2=\"\",A2=0),\"\",IF(AND(DAY(A2)=1,MONTH(A2)=1,DAY(B2)=31,MONTH(B2)=12),YEAR(B2)-YEAR(A2)+1,IF(OR(MONTH(B2)>MONTH(A2),(AND(MONTH(B2)=MONTH(A2),DAY(B2)>=DAY(A2))),(DATE(YEAR(B2),MONTH(A2),DAY(A2)))-B2=1),YEAR(B2)-YEAR(A2),(YEAR(B2)-1)-YEAR(A2))))","v":""},{"$f":"IF(OR(A2=\"\",A2=0),\"\",IF(AND(DAY(A2)=1,MONTH(A2)=1,DAY(B2)=31,MONTH(B2)=12),0,IF(DATE(YEAR(B2),MONTH(A2),DAY(A2))-B2=1,0,IF(B2>=(DATE(YEAR(B2),MONTH(A2),DAY(A2))),B2-DATE(YEAR(B2),MONTH(A2),DAY(A2))+1,B2-(DATE(YEAR(B2)-1,MONTH(A2),DAY(A2)))+1))))","v":""},{"$f":"IF(Q2=0,0,IF(Q2=\"\",\"\",ROUNDDOWN((Q2+0.009),2)))","v":""}]
[{"$f":"IF(Vordruck!JL23=\"\",\"\",Vordruck!JL23)","v":""},{"$f":"IF(Vordruck!JM23<>\"\",Vordruck!JM23,\"\")","v":""},{"$f":"IF(AND(MOD(YEAR(A3),4)=0,MOD(YEAR(B3),4)=0),IF(OR(AND(MONTH(A3)<3,MONTH(B3>2),AND(MONTH(A3)>2,MONTH(B3)<3))),TRUE,FALSE),B3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(MOD(YEAR(A3),4)=0,MOD(YEAR(B3),4)=0,OR(AND(MONTH(A3)<3,MONTH(B3)>2,AND(MONTH(A3)>2,MONTH(B3)<3),AND(MONTH(B3)>2,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3)))),TRUE,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C3<>\"\",D3<>\"\"),IF(OR(B3=\"\",A3=\"\"),IF(AND(C3=FALSE,D3=TRUE),B3-1,B3),IF(OR(AND(C3=FALSE,D3=TRUE),AND(C3=TRUE,D3=TRUE,(A3-B3)=1)),B3-1,B3)),B3)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)<>0,MOD(YEAR(B3),4)=0),IF(OR(AND(DAY(B3)=29,MONTH(B3)=2),AND(MONTH(B3)>2,MONTH(A3)<3),AND(MONTH(B3)>2,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3)),TRUE,FALSE),B3))","v":""},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)<>0,MOD(YEAR(B3),4)=0,OR(AND(DAY(B3)=29,MONTH(B3)=2,MONTH(A3)>2),AND(MONTH(B3)>2,MONTH(A3)<3),AND(MONTH(B3)<2,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3))),TRUE,FALSE))","v":""},{"$f":"IF(E3<>\"\",IF(OR(B3=\"\",A3=\"\"),E3,IF(OR(AND(F3=FALSE,D3=TRUE,C3=FALSE),AND(F3=FALSE,G3=TRUE),AND(C3=FALSE,G3=TRUE)),B3-1,IF(OR(B3=\"\",A3=\"\"),E3,IF(AND(OR(AND(D3=TRUE,F3=TRUE),AND(F3=TRUE,G3=TRUE),AND(C3=TRUE,G3=TRUE)),(0-B3)=1),B3-1,E3)))),E3)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)=0,MOD(YEAR(B3),4)<>0),IF(AND(MONTH(A3)<3,OR(MONTH(B3)<MONTH(A3),AND(MONTH(B3)=MONTH(A3),DAY(B3)<DAY(A3)))),TRUE,FALSE),B3))","v":""},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)=0,MOD(YEAR(B3),4)<>0,YEAR(B3)-1=YEAR(A3),AND(DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3,MONTH(A3)<3)),TRUE,FALSE))","v":""},{"$f":"IF(AND(E3<>\"\",H3<>\"\"),IF(OR(B3=\"\",A3=\"\"),H3,IF(OR(AND(I3=FALSE,J3=TRUE),AND(I3=TRUE,J3=TRUE,(0-B3)=1)),IF(AND(J3=TRUE,L3=TRUE,(0-B3)<>1),H3,B3-1),H3)),H3)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)<>0,MOD((YEAR(B3)-1),4)=0,MONTH(A3)<3,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3),TRUE,FALSE))","v":""},{"$f":"IF(OR(B3=\"\",A3=\"\"),\"\",IF(AND(MOD(YEAR(A3),4)<>0,MOD((YEAR(B3)-1),4)=0,MONTH(A3)<3,DATE(YEAR(B3),MONTH(A3),DAY(A3))>B3),TRUE,FALSE))","v":""},{"$f":"IF(AND(E3<>\"\",H3<>\"\"),IF(OR(B3=\"\",A3=\"\"),K3,IF(OR(AND(I3=FALSE,M3=TRUE),AND(L3=FALSE,M3=TRUE),AND(I3=TRUE,M3=TRUE),AND(L3=TRUE,M3=TRUE,(0-B3)=1)),B3-1,K3)),K3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E3<>\"\",H3<>\"\"),IF(OR(B3=\"\",A3=\"\"),K3,IF(OR(AND(I3=FALSE,M3=TRUE),AND(L3=FALSE,M3=TRUE),AND(I3=TRUE,M3=TRUE),AND(L3=TRUE,M3=TRUE,(0-B3)=1)),B3-1,K3)),K3)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(A3=\"\",A3=0),\"\",IF(AND(DAY(A3)=1,MONTH(A3)=1,DAY(B3)=31,MONTH(B3)=12),YEAR(B3)-YEAR(A3)+1,IF(OR(MONTH(B3)>MONTH(A3),(AND(MONTH(B3)=MONTH(A3),DAY(B3)>=DAY(A3))),(DATE(YEAR(B3),MONTH(A3),DAY(A3)))-B3=1),YEAR(B3)-YEAR(A3),(YEAR(B3)-1)-YEAR(A3))))","v":""},{"$f":"IF(OR(A3=\"\",A3=0),\"\",IF(AND(DAY(A3)=1,MONTH(A3)=1,DAY(B3)=31,MONTH(B3)=12),0,IF(DATE(YEAR(B3),MONTH(A3),DAY(A3))-B3=1,0,IF(B3>=(DATE(YEAR(B3),MONTH(A3),DAY(A3))),B3-DATE(YEAR(B3),MONTH(A3),DAY(A3))+1,B3-(DATE(YEAR(B3)-1,MONTH(A3),DAY(A3)))+1))))","v":""},{"$f":"IF(Q3=0,0,IF(Q3=\"\",\"\",ROUNDDOWN((Q3+0.009),2)))","v":""}]
[{"$f":"IF(Vordruck!JL24=\"\",\"\",Vordruck!JL24)","v":""},{"$f":"IF(Vordruck!JM24<>\"\",Vordruck!JM24,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL25=\"\",\"\",Vordruck!JL25)","v":""},{"$f":"IF(Vordruck!JM25<>\"\",Vordruck!JM25,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL26=\"\",\"\",Vordruck!JL26)","v":""},{"$f":"IF(Vordruck!JM26<>\"\",Vordruck!JM26,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL27=\"\",\"\",Vordruck!JL27)","v":""},{"$f":"IF(Vordruck!JM27<>\"\",Vordruck!JM27,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL28=\"\",\"\",Vordruck!JL28)","v":""},{"$f":"IF(Vordruck!JM28<>\"\",Vordruck!JM28,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL29=\"\",\"\",Vordruck!JL29)","v":""},{"$f":"IF(Vordruck!JM29<>\"\",Vordruck!JM29,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL30=\"\",\"\",Vordruck!JL30)","v":""},{"$f":"IF(Vordruck!JM30<>\"\",Vordruck!JM30,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL31=\"\",\"\",Vordruck!JL31)","v":""},{"$f":"IF(Vordruck!JM31<>\"\",Vordruck!JM31,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL32=\"\",\"\",Vordruck!JL32)","v":""},{"$f":"IF(Vordruck!JM32<>\"\",Vordruck!JM32,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL33=\"\",\"\",Vordruck!JL33)","v":""},{"$f":"IF(Vordruck!JM33<>\"\",Vordruck!JM33,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL34=\"\",\"\",Vordruck!JL34)","v":""},{"$f":"IF(Vordruck!JM34<>\"\",Vordruck!JM34,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL35=\"\",\"\",Vordruck!JL35)","v":""},{"$f":"IF(Vordruck!JM35<>\"\",Vordruck!JM35,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL36=\"\",\"\",Vordruck!JL36)","v":""},{"$f":"IF(Vordruck!JM36<>\"\",Vordruck!JM36,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL37=\"\",\"\",Vordruck!JL37)","v":""},{"$f":"IF(Vordruck!JM37<>\"\",Vordruck!JM37,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL38=\"\",\"\",Vordruck!JL38)","v":""},{"$f":"IF(Vordruck!JM38<>\"\",Vordruck!JM38,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL39=\"\",\"\",Vordruck!JL39)","v":""},{"$f":"IF(Vordruck!JM39<>\"\",Vordruck!JM39,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL40=\"\",\"\",Vordruck!JL40)","v":""},{"$f":"IF(Vordruck!JM40<>\"\",Vordruck!JM40,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL41=\"\",\"\",Vordruck!JL41)","v":""},{"$f":"IF(Vordruck!JM41<>\"\",Vordruck!JM41,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL42=\"\",\"\",Vordruck!JL42)","v":""},{"$f":"IF(Vordruck!JM42<>\"\",Vordruck!JM42,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL43=\"\",\"\",Vordruck!JL43)","v":""},{"$f":"IF(Vordruck!JM43<>\"\",Vordruck!JM43,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL44=\"\",\"\",Vordruck!JL44)","v":""},{"$f":"IF(Vordruck!JM44<>\"\",Vordruck!JM44,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL45=\"\",\"\",Vordruck!JL45)","v":""},{"$f":"IF(Vordruck!JM45<>\"\",Vordruck!JM45,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]
[{"$f":"IF(Vordruck!JL46=\"\",\"\",Vordruck!JL46)","v":""},{"$f":"IF(Vordruck!JM46<>\"\",Vordruck!JM46,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",""]

{"sheet":"Nebenrechnung","index":3,"n_rows":130,"n_cols":27,"rows_kept":130,"hidden":true,"merged":[[0,11,0,12],[0,17,0,18],[8,13,33,13],[8,19,33,19]]}
["Geburtsjahr",null,null,"Grund für den Ruhestand",null,"Schwerbehinderung",null,"Personenkreis",null,"Grund + Personenkreis",null,"Regelaltersgrenze",null,"Lehrer","Professoren",null,null,"Altersgrenze - Antrag",{"$nulls":3},"Abschlagsberechnung",null,"Schwerbeh","Hinweis"]
[{"$f":"IF(Vordruck!E8<>\"\",Vordruck!E8,\"\")","v":""},null,null,{"$f":"Vordruck!E12","v":"Erreichen der gesetzlichen Altersgrenze"},null,{"$f":"IF(Vordruck!E10=\"nein\",FALSE,TRUE)","v":false},null,{"$f":"Vordruck!E14","v":"sonstiger Beamte / Richter"},null,{"$f":"IF(AND(D3>0,H3>0),CONCATENATE(D3&H4)*1,\"\")","v":11},null,"Jahre","Monate","31.1. bzw. 31.7.","31.03.",null,null,"Jahre","Monate",null,null,"vorz. Rentenbeg. bzw. gesetzl. Renteneintritt",{"$f":"IF(D3>2,IF(Vordruck!E18=\"\",\"\",Vordruck!E18),M7-1)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(D3>2,OR(W2<S7,Vordruck!E18=\"\")),\"Beachte: frühester Versorgungsbeginn \"&TEXT(S7,\"TT.MM.JJJJ\"),\"\")","v":{"$error":"#VALUE!"}}]
[{"$nulls":3},{"$f":"VLOOKUP(D2,Vordruck!JV6:JW9,2,FALSE)","v":1},{"$nulls":3},{"$f":"VLOOKUP(H2,Vordruck!JZ6:KA12,2,FALSE)","v":1},{"$nulls":3},{"$f":"IF(AND($D$3>0,$H$3>0),VLOOKUP($A$2,INDIRECT(N9),2),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND($D$3>0,$H$3>0),VLOOKUP($A$2,INDIRECT(N9),3),\"\")","v":{"$error":"#N/A"}},null,"30.09.",null,null,{"$f":"IF(AND($D$3>0,$H$3>0),VLOOKUP($A$2,INDIRECT(T9),2),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND($D$3>0,$H$3>0),VLOOKUP($A$2,INDIRECT(T9),3),\"\")","v":{"$error":"#N/A"}},null,null,"Regelaltersgrenze",{"$f":"IF(X3<>\"\",X3,M6)","v":{"$error":"#VALUE!"}},{"$f":"IF(F2=TRUE,IF(M6<EOMONTH(DATE(YEAR(M4)+65,MONTH(M4),DAY(M4))-1,0),M6,EOMONTH(DATE(YEAR(M4)+65,MONTH(M4),DAY(M4))-1,0)),\"\")","v":""},null,null,"Versorgungsabschlag bei Schwerbehinderung: max bis zum 65Lj"]
[{"$nulls":7},{"$f":"IF(OR(H3=1,H3=2,H3=5),1,H3)","v":1},{"$nulls":3},"Geb ",{"$f":"$A$2","v":""},{"$nulls":4},"Geb ",{"$f":"$A$2","v":""},null,null,"Diff. Jahr(e)+Tag(e)",{"$f":"IF(W2>W3,0,'Tabelle Abschlagsber'!P2)","v":{"$error":"#VALUE!"}},{"$f":"IF(W2>W3,0,'Tabelle Abschlagsber'!R2)","v":{"$error":"#VALUE!"}}]
[{"$nulls":11}," + Jahre ./. 1",{"$f":"DATE(YEAR(M4)+L3,MONTH(M4),DAY(M4))-1","v":{"$error":"#VALUE!"}},{"$f":"EOMONTH($M$6,0)","v":{"$error":"#VALUE!"}},{"$f":"EOMONTH($M$6,0)","v":{"$error":"#VALUE!"}},null,null," + Jahre ./. 1 ",{"$f":"DATE(YEAR(S4)+R3,MONTH(S4),DAY(S4))-1","v":{"$error":"#VALUE!"}},null,null,"umgerechnet",{"$f":"W4+(ROUND(X4/365,2))","v":{"$error":"#VALUE!"}}]
["vss. Versorgungsbeginn bei ",{"$nulls":3},"vss. Versorgungsbeginn bei ",{"$nulls":6}," + Monate -> Monatsende",{"$f":"EOMONTH(EDATE(M5,M3),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H3=2,IF(OR(D3=1,D3=3),IF(MONTH(N5)=1,N5,IF(MONTH(N5)<8,DATE(YEAR(N5),7,31),DATE(YEAR(N5)+1,1,31))),IF(MONTH(N5)<8,DATE(YEAR(N5),7,31),DATE(YEAR(N5)+1,7,31))),\"\")","v":""},{"$f":"IF(H3=5,IF(MONTH(O5)<=3,DATE(YEAR(O5),3,31),IF(MONTH(O5)<10,DATE(YEAR(O5),9,30),DATE(YEAR(O5)+1,3,31))),\"\")","v":""},null,null," + Monate -> Monatsende",{"$f":"EOMONTH(EDATE(S5,S3),0)","v":{"$error":"#VALUE!"}},null,null," x 3,6% (höchstens 18/10,8%)",{"$f":"IF(F2=FALSE,IF(W5*3.6<=18,ROUND(W5*3.6,2),18),IF(W5*3.6<=10.8,ROUND(W5*3.6,2),10.8))","v":{"$error":"#VALUE!"}}]
["1. gesetzliche Regelarbeitsgrenze",{"$nulls":3},"1. gesetzliche Regelarbeitsgrenze",{"$nulls":6},"vss. Versorgungsbeg.",{"$f":"IF(H3=2,N6+1,IF(H3=5,O6+1,M6+1))","v":{"$error":"#VALUE!"}},{"$nulls":4},"frühester Rentenbeginn",{"$f":"S6+1","v":{"$error":"#VALUE!"}}]
["sonstige Beamte (11)","§§ 43 Abs.1 und 2 ThürBG",null,null,"Vollzugsbeamte mD und gD (13)","§§ 117 Abs.1 und 2 ThürBG",{"$nulls":4},"Ermittlung der gesetzlichen Altersgrenzen",{"$nulls":5},"Ermittlung der Altersgrenzen bei Antragstellung"]
["Geburtsjahrgang","Jahre","Monate",null,"Geburtsjahrgang","Jahre","Monate",{"$nulls":3},11,"sBeamte","F2=Falsch",{"$f":"IF(AND(D3>0,H3>0),IF(F2=FALSE,VLOOKUP(J2,K9:L20,2,FALSE),VLOOKUP(J2,K23:L34,2,FALSE)),\"\")","v":"sBeamte"},null,null,11,"sBeamte",null,{"$f":"IF(AND(D3>0,H3>0),IF(F2=FALSE,VLOOKUP(J2,Q9:R20,2,FALSE),VLOOKUP(J2,Q23:R34,2,FALSE)),\"\")","v":"sBeamte"}]
["1900-01-01",65,0,null,"1900-01-01",60,0,{"$nulls":3},13,"vollzMD","F2=Falsch",{"$nulls":3},13,"vollzMD"]
["1946-01-01",65,0,null,"1951-01-01",60,0,{"$nulls":3},14,"vollzHD","F2=Falsch",{"$nulls":3},14,"vollzHD"]
["1947-01-01",65,1,null,"1952-01-01",60,1,{"$nulls":3},21,"sBeamteATZ","F2=Falsch",{"$nulls":3},21,"sBeamteATZ"]
["1947-01-02",65,1,null,"1952-01-02",60,{"$f":"G11+1","v":1},{"$nulls":3},23,"vollzMDatz","F2=Falsch",{"$nulls":3},23,"vollzMDatz"]
["1948-01-01",65,2,null,"1953-01-01",60,{"$f":"G13+1","v":2},{"$nulls":3},24,"vollzHDatz","F2=Falsch",{"$nulls":3},24,"vollzHDatz"]
["1949-01-01",65,{"$f":"C14+1","v":3},null,"1954-01-01",60,4,{"$nulls":3},31,"sBeamte","F2=Falsch",{"$nulls":3},31,"sBeamteAntrag","F2=falsch"]
["1950-01-01",65,{"$f":"C15+1","v":4},null,"1955-01-01",60,6,{"$nulls":3},33,"vollzMD","F2=Falsch",{"$nulls":3},33,"vollzMDantrag","F2=falsch"]
["1951-01-01",65,5,null,"1956-01-01",60,8,{"$nulls":3},34,"vollzHD","F2=Falsch",{"$nulls":3},34,"vollzHDantrag","F2=falsch"]
["1952-01-01",65,6,null,"1957-01-01",60,10,{"$nulls":3},41,"sBeamteATZ","F2=Falsch",{"$nulls":3},41,"sBeamteAntragATZ"]
["1953-01-01",65,7,null,"1958-01-01",61,0,{"$nulls":3},43,"vollzMDatz","F2=Falsch",{"$nulls":3},43,"vollzMDantragATZ"]
["1954-01-01",65,8,null,"1959-01-01",61,2,{"$nulls":3},44,"vollzHDatz","F2=Falsch",{"$nulls":3},44,"vollzHDantragATZ"]
["1955-01-01",65,9,null,"1960-01-01",61,4]
["1956-01-01",65,10,null,"1961-01-01",61,6]
["1957-01-01",65,11,null,"1962-01-01",61,8,{"$nulls":3},11,"sBeamteSchw","F2=Wahr",{"$nulls":3},11,"sBeamte"]
["1958-01-01",66,0,null,"1963-01-01",61,10,{"$nulls":3},13,"vollzMD","F2=Wahr",{"$nulls":3},13,"vollzMD"]
["1959-01-01",66,{"$f":"C24+2","v":2},null,"1964-01-01",62,0,{"$nulls":3},14,"vollzHD","F2=Wahr",{"$nulls":3},14,"vollzHD"]
["1960-01-01",66,{"$f":"C25+2","v":4},null,"2500-01-01",62,0,{"$nulls":3},21,"sBeamteATZ","F2=Wahr",{"$nulls":3},21,"sBeamteATZ"]
["1961-01-01",66,{"$f":"C26+2","v":6},{"$nulls":7},23,"vollzMDatz","F2=Wahr",{"$nulls":3},23,"vollzMDatz"]
["1962-01-01",66,{"$f":"C27+2","v":8},{"$nulls":7},24,"vollzHDatz","F2=Wahr",{"$nulls":3},24,"vollzHDatz"]
["1963-01-01",66,{"$f":"C28+2","v":10},null,"Vollzugsbeamte hD (14)","§§ 117 Abs.1 und 2 ThürBG",{"$nulls":4},31,"sBeamteSchw","F2=Wahr",{"$nulls":3},31,"sBeamteAntragSchw","F2=wahr"]
["1964-01-01",67,0,null,"Geburtsjahrgang","Jahre","Monate",{"$nulls":3},33,"vollzMD","F2=Wahr",{"$nulls":3},33,"vollzMDantragSchw","F2=wahr"]
["2500-01-01",67,0,null,"1900-01-01",60,0,{"$nulls":3},34,"vollzHD","F2=Wahr",{"$nulls":3},34,"vollzHDantragSchw","F2=wahr"]
[{"$nulls":4},"1951-01-01",60,0,{"$nulls":3},41,"sBeamteATZ","F2=Wahr",{"$nulls":3},41,"sBeamteAntragSchwATZ"]
[{"$nulls":4},"1952-01-01",60,3,{"$nulls":3},43,"vollzMDatz","F2=Wahr",{"$nulls":3},43,"vollzMDantragSchw"]
["1. gesetzliche Regelarbeitsgrenze + Schwerbehinderung",{"$nulls":3},"1952-01-02",60,3,{"$nulls":3},44,"vollzHDatz","F2=Wahr",{"$nulls":3},44,"vollzHDantragSchw"]
[{"$nulls":4},"1953-01-01",60,6]
["sonstige Beamte (11)","§§ 43 Abs.1 und 2 ThürBG",null,null,"1954-01-01",60,9]
["Geburtsjahrgang","Jahre","Monate",null,"1955-01-01",61,0]
["1900-01-01",65,0,null,"1956-01-01",61,4]
["1946-01-01",65,0,null,"1957-01-01",61,8]
["1947-01-01",65,1,null,"1958-01-01",62,0]
["1947-01-02",65,1,null,"1959-01-01",62,4]
["1948-01-01",65,2,null,"1960-01-01",62,8]
["1949-01-01",65,{"$f":"C42+1","v":3},null,"1961-01-01",63,0]
["1950-01-01",65,{"$f":"C43+1","v":4},null,"1962-01-01",63,4]
["1951-01-01",65,5,null,"1963-01-01",63,8]
["1952-01-01",65,6,null,"1964-01-01",64,0]
["1953-01-01",65,7,null,"2500-01-01",64,0]
["1954-01-01",65,8]
["1955-01-01",65,9]
["1956-01-01",65,10,null,"2. gesetzliche Altersgrenze mit ATZ"]
["1957-01-01",65,11]
["1958-01-01",66,0]
["1959-01-01",66,{"$f":"C52+2","v":2},null,"Vollzugsbeamte mD und gD (23)","§§ 117 Abs. 5, 118, 119"]
["1960-01-01",66,{"$f":"C53+2","v":4},null,"Geburtsjahrgang","Jahre","Monate"]
["1961-01-01",66,{"$f":"C54+2","v":6},null,"1900-01-01",60,0]
["1962-01-01",66,{"$f":"C55+2","v":8},null,"2500-01-01",60,0]
["1963-01-01",66,{"$f":"C56+2","v":10}]
["1964-01-01",67,0]
["2500-01-01",67,0,null,"Vollzugsbeamte mD und gD (24)","§§ 117 Abs. 5, 118, 119"]
[{"$nulls":4},"Geburtsjahrgang","Jahre","Monate"]
[{"$nulls":4},"1900-01-01",60,0]
[{"$nulls":4},"2500-01-01",60,0]
["2. gesetzliche Altersgrenze mit ATZ"]
[]
["sonstige Beamte (21)","§ 44 Abs.1 ThürBG",null,null,"3. Altersgrenze bei Antrag"]
["Geburtsjahrgang","Jahre","Monate"]
["1900-01-01",65,0,null,"Vollzugsbeamte mD und gD (33)","§§ 117 Abs. 5, 118, 119"]
["2500-01-01",65,0,null,"Geburtsjahrgang","Jahre","Monate"]
[{"$nulls":4},"1900-01-01",60,0]
[{"$nulls":4},"2500-01-01",60,0]
[]
["3. Altersgrenze bei Antrag",{"$nulls":3},"Vollzugsbeamte hD (34)","§§ 117 Abs. 5, 118, 119"]
[{"$nulls":4},"Geburtsjahrgang","Jahre","Monate"]
["sonstige Beamte (31)","§ 44 Abs.1 ThürBG",null,null,"1900-01-01",60,0]
["Geburtsjahrgang","Jahre","Monate",null,"2500-01-01",60,0]
["1900-01-01",62,0]
["2500-01-01",62,0]
[{"$nulls":4},"4. Altersgrenze bei Antrag mit ATZ"]
[]
["4. Altersgrenze bei Antrag mit ATZ"," (Eingabefeld: vorzeitiger Versorgungsbeginn)",null,null,"Vollzugsbeamte mD und gD (43)","§§ 117 Abs. 5, 118, 119"]
[" --> keine Prüfung nötig!!",{"$nulls":3},"Geburtsjahrgang","Jahre","Monate"]
["sonstige Beamte (41)","§ 44 Abs.1 ThürBG",null,null,"1900-01-01",60,0]
["Geburtsjahrgang","Jahre","Monate",null,"2500-01-01",60,0]
["1900-01-01",63,0]
["2500-01-01",63,0,null,"Vollzugsbeamte hD (44)","§§ 117 Abs. 5, 118, 119"]
[{"$nulls":4},"Geburtsjahrgang","Jahre","Monate"]
[{"$nulls":4},"1900-01-01",60,0]
["5. Altersgrenze bei Antrag + Schwerbehinderung (ohne ATZ)",{"$nulls":3},"2500-01-01",60,0]
[]
["Geburtsdatum"]
["sonstige Beamte (31) + Schw","§ 44 Abs. 2 ThürBG"]
["Geburtsjahrgang","Jahre","Monate",null,"Bei behinderten Vollzugsbeamten keine Sonderregelung der Altersgrenzen!"]
["1900-01-01",60,0,null,"5. Altersgrenze bei Antrag + Schwerbehinderung"]
["1951-01-01",60,0]
["1952-01-01",60,{"$f":"C94+1","v":1},null,"Vollzugsbeamte mD und gD (33)","§§ 117 Abs. 5, 118, 119"]
["1952-02-01",60,{"$f":"C95+1","v":2},null,"Geburtsjahrgang","Jahre","Monate"]
["1952-03-01",60,{"$f":"C96+1","v":3},null,"1900-01-01",60,0]
["1952-04-01",60,{"$f":"C97+1","v":4},null,"2500-01-01",60,0]
["1952-05-01",60,{"$f":"C98+1","v":5}]
["1952-06-01",60,6,null,"Vollzugsbeamte hD (34)","§§ 117 Abs. 5, 118, 119"]
["1952-07-01",60,6,null,"Geburtsjahrgang","Jahre","Monate"]
["1952-08-01",60,6,null,"1900-01-01",60,0]
["1952-09-01",60,6,null,"2500-01-01",60,0]
["1952-10-01",60,6]
["1952-11-01",60,6]
["1952-12-01",60,6]
["1952-12-31",60,6]
["1953-01-01",60,7]
["1954-01-01",60,8]
["1955-01-01",60,9]
["1956-01-01",60,10]
["1957-01-01",60,11]
["1958-01-01",61,0]
["1959-01-01",61,2]
["1960-01-01",61,4]
["1961-01-01",61,6]
["1962-01-01",61,8]
["1963-01-01",61,10]
["1964-01-01",62,0]
["2500-01-01",62,0]
[]
[]
["5. Altersgrenze bei Antrag + Schwerbehinderung + ATZ "]
["§44 Nr. 1"]
["Geburtsdatum"]
["sonstige Beamte (41) + Schw +ATZ","§ 44 Abs. 2 ThürBG"]
["Geburtsjahrgang","Jahre","Monate"]
["1900-01-01",60,0]
["2500-01-01",60,0]
[" --> bis Jahrgang 1954 möglich"]

{"sheet":"Tabelle Abschlagsber","index":4,"n_rows":2,"n_cols":18,"rows_kept":2,"hidden":true}
["Anfangs-datum","End-        datum","1.","2.","1. Korrektur wg. Schaltjahr","3.","4.","2. Korrektur wg. Schaltjahr","5.","6.","3. Korrektur wg. Schaltjahr","7.","8.","4. Korrektur wg. Schaltjahr","Korrektur wg. Schaltjahr iVm Zurechnungszeit","Jahre","Tage","gerundet"]
[{"$f":"IF(Nebenrechnung!W2=\"\",\"\",Nebenrechnung!W2)","v":{"$error":"#VALUE!"}},{"$f":"IF(Nebenrechnung!W3=\"\",\"\",Nebenrechnung!W3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)=0),IF(OR(AND(MONTH(A2)<3,MONTH(B2>2),AND(MONTH(A2)>2,MONTH(B2)<3))),TRUE,FALSE),B2)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)=0,OR(AND(MONTH(A2)<3,MONTH(B2)>2,AND(MONTH(A2)>2,MONTH(B2)<3),AND(MONTH(B2)>2,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2)))),TRUE,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C2<>\"\",D2<>\"\"),IF(OR(B2=\"\",A2=\"\"),IF(AND(C2=FALSE,D2=TRUE),B2-1,B2),IF(OR(AND(C2=FALSE,D2=TRUE),AND(C2=TRUE,D2=TRUE,(A2-B2)=1)),B2-1,B2)),B2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD(YEAR(B2),4)=0),IF(OR(AND(DAY(B2)=29,MONTH(B2)=2),AND(MONTH(B2)>2,MONTH(A2)<3),AND(MONTH(B2)>2,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2)),TRUE,FALSE),B2))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD(YEAR(B2),4)=0,OR(AND(DAY(B2)=29,MONTH(B2)=2,MONTH(A2)>2),AND(MONTH(B2)>2,MONTH(A2)<3),AND(MONTH(B2)<2,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2))),TRUE,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(E2<>\"\",IF(OR(B2=\"\",A2=\"\"),E2,IF(OR(AND(F2=FALSE,D2=TRUE,C2=FALSE),AND(F2=FALSE,G2=TRUE),AND(C2=FALSE,G2=TRUE)),B2-1,IF(OR(B2=\"\",A2=\"\"),E2,IF(AND(OR(AND(D2=TRUE,F2=TRUE),AND(F2=TRUE,G2=TRUE),AND(C2=TRUE,G2=TRUE)),(0-B2)=1),B2-1,E2)))),E2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)<>0),IF(AND(MONTH(A2)<3,OR(MONTH(B2)<MONTH(A2),AND(MONTH(B2)=MONTH(A2),DAY(B2)<DAY(A2)))),TRUE,FALSE),B2))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(B2),4)<>0,YEAR(B2)-1=YEAR(A2),AND(DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2,MONTH(A2)<3)),TRUE,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E2<>\"\",H2<>\"\"),IF(OR(B2=\"\",A2=\"\"),H2,IF(OR(AND(I2=FALSE,J2=TRUE),AND(I2=TRUE,J2=TRUE,(0-B2)=1)),IF(AND(J2=TRUE,L2=TRUE,(0-B2)<>1),H2,B2-1),H2)),H2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD((YEAR(B2)-1),4)=0,MONTH(A2)<3,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2),TRUE,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(B2=\"\",A2=\"\"),\"\",IF(AND(MOD(YEAR(A2),4)<>0,MOD((YEAR(B2)-1),4)=0,MONTH(A2)<3,DATE(YEAR(B2),MONTH(A2),DAY(A2))>B2),TRUE,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E2<>\"\",H2<>\"\"),IF(OR(B2=\"\",A2=\"\"),K2,IF(OR(AND(I2=FALSE,M2=TRUE),AND(L2=FALSE,M2=TRUE),AND(I2=TRUE,M2=TRUE),AND(L2=TRUE,M2=TRUE,(0-B2)=1)),B2-1,K2)),K2)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E2<>\"\",H2<>\"\"),IF(OR(B2=\"\",A2=\"\"),K2,IF(OR(AND(I2=FALSE,M2=TRUE),AND(L2=FALSE,M2=TRUE),AND(I2=TRUE,M2=TRUE),AND(L2=TRUE,M2=TRUE,(0-B2)=1)),B2-1,K2)),K2)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(A2=\"\",A2=0),\"\",IF(AND(DAY(A2)=1,MONTH(A2)=1,DAY(B2)=31,MONTH(B2)=12),YEAR(B2)-YEAR(A2)+1,IF(OR(MONTH(B2)>MONTH(A2),(AND(MONTH(B2)=MONTH(A2),DAY(B2)>=DAY(A2))),(DATE(YEAR(B2),MONTH(A2),DAY(A2)))-B2=1),YEAR(B2)-YEAR(A2),(YEAR(B2)-1)-YEAR(A2))))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(A2=\"\",A2=0),\"\",IF(AND(DAY(A2)=1,MONTH(A2)=1,DAY(B2)=31,MONTH(B2)=12),0,IF(DATE(YEAR(B2),MONTH(A2),DAY(A2))-B2=1,0,IF(B2>=(DATE(YEAR(B2),MONTH(A2),DAY(A2))),B2-DATE(YEAR(B2),MONTH(A2),DAY(A2))+1,B2-(DATE(YEAR(B2)-1,MONTH(A2),DAY(A2)))+1))))","v":{"$error":"#VALUE!"}},{"$f":"IF(Q2=0,0,IF(Q2=\"\",\"\",ROUNDDOWN((Q2+0.009),2)))","v":{"$error":"#VALUE!"}}]