{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Mitarbeiterinformationen","Lohn-und Gehaltsrechner","Einzelne Gehaltsabrechnungen"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Mitarbeiterinformationen","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"merged":[[1,0,1,12],[2,0,2,5]]}
[]
["Mitarbeiterinformationen"]
["[Firmenname]"]
["Mitarbeiter-ID","Mitarbeitername","Stundenlohn","Steuerstatus","Bundesfreibetrag (aus W-4)","Staatliche Steuer","Bundeseinkommenssteuer (Basierend auf Bundesfreibetrag)","Sozialversicherungssteuer","Medicare-Steuer","Gesamtbetrag der einbehaltenen Steuern","Abzug für Versicherungen","Sonstige reguläre Abzüge","Summe der regulären Abzüge (ohne Steuern)"]
[1,"Jesper Aaberg",{"v":10,"d":"10.00 €"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Tabelle1[[#This Row],[Staatliche Steuer]]+Tabelle1[[#This Row],[Bundeseinkommenssteuer (Basierend auf Bundesfreibetrag)]]+Tabelle1[[#This Row],[Sozialversicherungssteuer]]+Tabelle1[[#This Row],[Medicare-Steuer]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"20.00 €"},{"v":40,"d":"40.00 €"},{"$f":"Tabelle1[[#This Row],[Abzug für Versicherungen]]+Tabelle1[[#This Row],[Sonstige reguläre Abzüge]]","v":{"v":60,"d":"60.00 €"}}]
[2,"Wilson Pais",{"v":13,"d":"13.00 €"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Tabelle1[[#This Row],[Staatliche Steuer]]+Tabelle1[[#This Row],[Bundeseinkommenssteuer (Basierend auf Bundesfreibetrag)]]+Tabelle1[[#This Row],[Sozialversicherungssteuer]]+Tabelle1[[#This Row],[Medicare-Steuer]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"20.00 €"},{"v":52,"d":"52.00 €"},{"$f":"Tabelle1[[#This Row],[Abzug für Versicherungen]]+Tabelle1[[#This Row],[Sonstige reguläre Abzüge]]","v":{"v":72,"d":"72.00 €"}}]
[3,"Kathie Flood",{"v":10,"d":"10.00 €"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Tabelle1[[#This Row],[Staatliche Steuer]]+Tabelle1[[#This Row],[Bundeseinkommenssteuer (Basierend auf Bundesfreibetrag)]]+Tabelle1[[#This Row],[Sozialversicherungssteuer]]+Tabelle1[[#This Row],[Medicare-Steuer]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"20.00 €"},0,{"$f":"Tabelle1[[#This Row],[Abzug für Versicherungen]]+Tabelle1[[#This Row],[Sonstige reguläre Abzüge]]","v":{"v":20,"d":"20.00 €"}}]

{"sheet":"Lohn-und Gehaltsrechner","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,1,8],[2,0,2,5]]}
["Lohn-und Gehaltsrechner"]
[{"$nulls":9},"Ende des Zeitraums:",{"v":45688,"d":"4568800.00%"}]
[{"$f":"Mitarbeiterinformationen!$A$3","v":"[Firmenname]"}]
["Mitarbeiter-ID","Mitarbeitername","Reguläre Arbeitsstunden","Urlaubsstunden","Krankheitsstunden","Überstunden","Überstundensatz","Bruttogehalt","Steuern und Abzüge ","Sonstige Abzüge","Nettogehalt"]
[1,{"$f":"VLOOKUP(A5,Tabelle1[],2,FALSE)","v":"Jesper Aaberg"},{"v":50,"d":"50.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},null,null,{"$f":"(VLOOKUP(A5,Tabelle1[],3,FALSE)*(Tabelle2[[#This Row],[Reguläre Arbeitsstunden]]+Tabelle2[[#This Row],[Urlaubsstunden]]+Tabelle2[[#This Row],[Krankheitsstunden]])+Tabelle2[[#This Row],[Überstunden]]*Tabelle2[[#This Row],[Überstundensatz]])","v":{"v":560,"d":"560.00 €"}},{"$f":"VLOOKUP(A5,Tabelle1[],10,FALSE)*Tabelle2[[#This Row],[Bruttogehalt]]+Tabelle1[[#This Row],[Summe der regulären Abzüge (ohne Steuern)]]","v":{"v":273.08000000000004,"d":"273.08 €"}},{"v":20,"d":"20.00 €"},{"$f":"Tabelle2[[#This Row],[Bruttogehalt]]-Tabelle2[[#This Row],[Steuern und Abzüge ]]-Tabelle2[[#This Row],[Sonstige Abzüge]]","v":{"v":266.91999999999996,"d":"266.92 €"}}]
[2,{"$f":"VLOOKUP(A6,Tabelle1[],2,FALSE)","v":"Wilson Pais"},{"v":40,"d":"40.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$f":"(VLOOKUP(A6,Tabelle1[],3,FALSE)*(Tabelle2[[#This Row],[Reguläre Arbeitsstunden]]+Tabelle2[[#This Row],[Urlaubsstunden]]+Tabelle2[[#This Row],[Krankheitsstunden]])+Tabelle2[[#This Row],[Überstunden]]*Tabelle2[[#This Row],[Überstundensatz]])","v":{"v":520,"d":"520.00 €"}},{"$f":"VLOOKUP(A6,Tabelle1[],10,FALSE)*Tabelle2[[#This Row],[Bruttogehalt]]+Tabelle1[[#This Row],[Summe der regulären Abzüge (ohne Steuern)]]","v":{"v":269.86,"d":"269.86 €"}},{"v":52,"d":"52.00 €"},{"$f":"Tabelle2[[#This Row],[Bruttogehalt]]-Tabelle2[[#This Row],[Steuern und Abzüge ]]-Tabelle2[[#This Row],[Sonstige Abzüge]]","v":{"v":198.14,"d":"198.14 €"}}]
[3,{"$f":"VLOOKUP(A7,Tabelle1[],2,FALSE)","v":"Kathie Flood"},{"v":52,"d":"52.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2,"d":"2.00"},{"v":20,"d":"20.00 €"},{"$f":"(VLOOKUP(A7,Tabelle1[],3,FALSE)*(Tabelle2[[#This Row],[Reguläre Arbeitsstunden]]+Tabelle2[[#This Row],[Urlaubsstunden]]+Tabelle2[[#This Row],[Krankheitsstunden]])+Tabelle2[[#This Row],[Überstunden]]*Tabelle2[[#This Row],[Überstundensatz]])","v":{"v":560,"d":"560.00 €"}},{"$f":"VLOOKUP(A7,Tabelle1[],10,FALSE)*Tabelle2[[#This Row],[Bruttogehalt]]+Tabelle1[[#This Row],[Summe der regulären Abzüge (ohne Steuern)]]","v":{"v":233.08000000000004,"d":"233.08 €"}},{"v":20,"d":"20.00 €"},{"$f":"Tabelle2[[#This Row],[Bruttogehalt]]-Tabelle2[[#This Row],[Steuern und Abzüge ]]-Tabelle2[[#This Row],[Sonstige Abzüge]]","v":{"v":306.91999999999996,"d":"306.92 €"}}]

{"sheet":"Einzelne Gehaltsabrechnungen","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[1,2,1,7],[13,2,13,7],[25,2,25,7],[38,2,38,7]]}
[]
[null,null,{"$f":"(Mitarbeiterinformationen!$A$3)","v":"[Firmenname]"}]
[null,null,"Zeitraum:",{"$f":"'Lohn-und Gehaltsrechner'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Mitarbeitername",{"$f":"IFERROR(VLOOKUP(H3,Tabelle1[],2),\"\")","v":"Jesper Aaberg"},"Mitarbeiter-ID",1]
[]
[null,null,"Status",{"$f":"IFERROR(VLOOKUP(H3,Tabelle1[],4),\"\")","v":1},"Freibetrag (aus W-4)",{"$f":"IFERROR(VLOOKUP(H3,Tabelle1[],5,FALSE),\"\")","v":4},"Arbeitsstunden",{"$f":"IFERROR(VLOOKUP(H3,Tabelle2[],3,FALSE),\"\")","v":50}]
[null,null,"Stundensatz",{"$f":"IFERROR(VLOOKUP(H3,Tabelle1[],3,FALSE),\"\")","v":{"v":10,"d":"10.00 €"}},"Überstundensatz",{"$f":"IFERROR(VLOOKUP(H3,Tabelle2[],7,FALSE),\"\")","v":0},"Krankheitsstunden",{"$f":"IFERROR(VLOOKUP(H3,Tabelle2[],5,FALSE),\"\")","v":1}]
[null,null,"Steuern auf Sozialversicherung",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabelle1[],8,FALSE),\"\")*H9,\"\")","v":{"v":35.28,"d":"35.28 €"}},"Einkommensteuer ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabelle1[],7,FALSE),\"\")*H9,\"\")","v":{"v":156.8,"d":"156.80 €"}},"Urlaubsstunden",{"$f":"IFERROR(VLOOKUP(H3,Tabelle2[],4,FALSE),\"\")","v":5}]
[null,null,"Steuern auf Krankenversicherung ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabelle1[],9,FALSE),\"\")*H9,\"\")","v":{"v":8.120000000000001,"d":"8.12 €"}},"Kommunalsteuer ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabelle1[],6,FALSE),\"\")*H9,\"\")","v":{"v":12.879999999999999,"d":"12.88 €"}},"Überstunden",{"$f":"IFERROR(VLOOKUP(H3,Tabelle2[],6,FALSE),\"\")","v":0}]
[null,null,"Abzug für Versicherungen",{"$f":"IFERROR(VLOOKUP(H3,Tabelle1[],11,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Sonstige reguläre Abzüge",{"$f":"IFERROR(VLOOKUP(H3,Tabelle1[],12,FALSE),\"\")","v":{"v":40,"d":"40.00 €"}},"Bruttogehalt",{"$f":"IFERROR(VLOOKUP(H3,Tabelle2[],8,FALSE),\"\")","v":{"v":560,"d":"560.00 €"}}]
[null,null,"Steuern gesamt und reguläre Abzüge ",{"$f":"IFERROR(SUM(F7:F9)+SUM(D7:D9),\"\")","v":{"v":273.08000000000004,"d":"273.08 €"}},"Sonstige Abzüge",{"$f":"IFERROR(VLOOKUP(H3,Tabelle2[],10,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Steuern gesamt und Abzüge ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabelle2[],9,FALSE),\"\")+F10,\"\")","v":{"v":293.08000000000004,"d":"293.08 €"}}]
[{"$nulls":6},"Nettogehalt",{"$f":"IFERROR(VLOOKUP(H3,Tabelle2[],11,FALSE),\"\")","v":{"v":266.91999999999996,"d":"266.92 €"}}]
[]
[]
[null,null,{"$f":"(Mitarbeiterinformationen!$A$3)","v":"[Firmenname]"}]
[null,null,"Zeitraum:",{"$f":"'Lohn-und Gehaltsrechner'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Mitarbeitername",{"$f":"IFERROR(VLOOKUP(H15,Tabelle1[],2),\"\")","v":"Wilson Pais"},"Mitarbeiter-ID",2]
[]
[null,null,"Status",{"$f":"IFERROR(VLOOKUP(H15,Tabelle1[],4),\"\")","v":1},"Freibetrag (aus W-4)",{"$f":"IFERROR(VLOOKUP(H15,Tabelle1[],5,FALSE),\"\")","v":4},"Arbeitsstunden",{"$f":"IFERROR(VLOOKUP(H15,Tabelle2[],3,FALSE),\"\")","v":40}]
[null,null,"Stundensatz",{"$f":"IFERROR(VLOOKUP(H15,Tabelle1[],3,FALSE),\"\")","v":{"v":13,"d":"13.00 €"}},"Überstundensatz",{"$f":"IFERROR(VLOOKUP(H15,Tabelle2[],7,FALSE),\"\")","v":0},"Krankheitsstunden",{"$f":"IFERROR(VLOOKUP(H15,Tabelle2[],5,FALSE),\"\")","v":0}]
[null,null,"Steuern auf Sozialversicherung",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabelle1[],8,FALSE),\"\")*H21,\"\")","v":{"v":32.76,"d":"32.76 €"}},"Einkommensteuer ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabelle1[],7,FALSE),\"\")*H21,\"\")","v":{"v":145.60000000000002,"d":"145.60 €"}},"Urlaubsstunden",{"$f":"IFERROR(VLOOKUP(H15,Tabelle2[],4,FALSE),\"\")","v":0}]
[null,null,"Steuern auf Krankenversicherung ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabelle1[],9,FALSE),\"\")*H21,\"\")","v":{"v":7.54,"d":"7.54 €"}},"Kommunalsteuer ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabelle1[],6,FALSE),\"\")*H21,\"\")","v":{"v":11.959999999999999,"d":"11.96 €"}},"Überstunden",{"$f":"IFERROR(VLOOKUP(H15,Tabelle2[],6,FALSE),\"\")","v":0}]
[null,null,"Abzug für Versicherungen",{"$f":"IFERROR(VLOOKUP(H15,Tabelle1[],11,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Sonstige reguläre Abzüge",{"$f":"IFERROR(VLOOKUP(H15,Tabelle1[],12,FALSE),\"\")","v":{"v":52,"d":"52.00 €"}},"Bruttogehalt",{"$f":"IFERROR(VLOOKUP(H15,Tabelle2[],8,FALSE),\"\")","v":{"v":520,"d":"520.00 €"}}]
[null,null,"Steuern gesamt und reguläre Abzüge ",{"$f":"IFERROR(SUM(F19:F21)+SUM(D19:D21),\"\")","v":{"v":269.86,"d":"269.86 €"}},"Sonstige Abzüge",{"$f":"IFERROR(VLOOKUP(H15,Tabelle2[],10,FALSE),\"\")","v":{"v":52,"d":"52.00 €"}},"Steuern gesamt und Abzüge ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabelle2[],9,FALSE),\"\")+F22,\"\")","v":{"v":321.86,"d":"321.86 €"}}]
[{"$nulls":6},"Nettogehalt",{"$f":"IFERROR(VLOOKUP(H15,Tabelle2[],11,FALSE),\"\")","v":{"v":198.14,"d":"198.14 €"}}]
[]
[]
[null,null,{"$f":"(Mitarbeiterinformationen!$A$3)","v":"[Firmenname]"}]
[null,null,"Zeitraum:",{"$f":"'Lohn-und Gehaltsrechner'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Mitarbeitername",{"$f":"IFERROR(VLOOKUP(H27,Tabelle1[],2),\"\")","v":"Kathie Flood"},"Mitarbeiter-ID",3]
[]
[null,null,"Status",{"$f":"IFERROR(VLOOKUP(H27,Tabelle1[],4),\"\")","v":1},"Freibetrag (aus W-4)",{"$f":"IFERROR(VLOOKUP(H27,Tabelle1[],5,FALSE),\"\")","v":4},"Arbeitsstunden",{"$f":"IFERROR(VLOOKUP(H27,Tabelle2[],3,FALSE),\"\")","v":52}]
[null,null,"Stundensatz",{"$f":"IFERROR(VLOOKUP(H27,Tabelle1[],3,FALSE),\"\")","v":{"v":10,"d":"10.00 €"}},"Überstundensatz",{"$f":"IFERROR(VLOOKUP(H27,Tabelle2[],7,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Krankheitsstunden",{"$f":"IFERROR(VLOOKUP(H27,Tabelle2[],5,FALSE),\"\")","v":0}]
[null,null,"Steuern auf Sozialversicherung",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabelle1[],8,FALSE),\"\")*H33,\"\")","v":{"v":35.28,"d":"35.28 €"}},"Einkommensteuer ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabelle1[],7,FALSE),\"\")*H33,\"\")","v":{"v":156.8,"d":"156.80 €"}},"Urlaubsstunden",{"$f":"IFERROR(VLOOKUP(H27,Tabelle2[],4,FALSE),\"\")","v":0}]
[null,null,"Steuern auf Krankenversicherung ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabelle1[],9,FALSE),\"\")*H33,\"\")","v":{"v":8.120000000000001,"d":"8.12 €"}},"Kommunalsteuer ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabelle1[],6,FALSE),\"\")*H33,\"\")","v":{"v":12.879999999999999,"d":"12.88 €"}},"Überstunden",{"$f":"IFERROR(VLOOKUP(H27,Tabelle2[],6,FALSE),\"\")","v":2}]
[null,null,"Abzug für Versicherungen",{"$f":"IFERROR(VLOOKUP(H27,Tabelle1[],11,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Sonstige reguläre Abzüge",{"$f":"IFERROR(VLOOKUP(H27,Tabelle1[],12,FALSE),\"\")","v":0},"Bruttogehalt",{"$f":"IFERROR(VLOOKUP(H27,Tabelle2[],8,FALSE),\"\")","v":{"v":560,"d":"560.00 €"}}]
[null,null,"Steuern gesamt und reguläre Abzüge ",{"$f":"IFERROR(SUM(F31:F33)+SUM(D31:D33),\"\")","v":{"v":233.08,"d":"233.08 €"}},"Sonstige Abzüge",{"$f":"IFERROR(VLOOKUP(H27,Tabelle2[],10,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Steuern gesamt und Abzüge ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabelle2[],9,FALSE),\"\")+F34,\"\")","v":{"v":253.08000000000004,"d":"253.08 €"}}]
[{"$nulls":6},"Nettogehalt",{"$f":"IFERROR(VLOOKUP(H27,Tabelle2[],11,FALSE),\"\")","v":{"v":306.91999999999996,"d":"306.92 €"}}]
[]
[]
[]
[null,null,{"$f":"(Mitarbeiterinformationen!$A$3)","v":"[Firmenname]"}]
[null,null,"Zeitraum:",{"$f":"'Lohn-und Gehaltsrechner'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Mitarbeitername",{"$f":"IFERROR(VLOOKUP(H40,Tabelle1[],2),\"\")","v":""},"Mitarbeiter-ID"]
[]
[null,null,"Status",{"$f":"IFERROR(VLOOKUP(H40,Tabelle1[],4),\"\")","v":""},"Freibetrag (aus W-4)",{"$f":"IFERROR(VLOOKUP(H40,Tabelle1[],5,FALSE),\"\")","v":""},"Arbeitsstunden",{"$f":"IFERROR(VLOOKUP(H40,Tabelle2[],3,FALSE),\"\")","v":""}]
[null,null,"Stundensatz",{"$f":"IFERROR(VLOOKUP(H40,Tabelle1[],3,FALSE),\"\")","v":""},"Überstundensatz",{"$f":"IFERROR(VLOOKUP(H40,Tabelle2[],7,FALSE),\"\")","v":""},"Krankheitsstunden",{"$f":"IFERROR(VLOOKUP(H40,Tabelle2[],5,FALSE),\"\")","v":""}]
[null,null,"Steuern auf Sozialversicherung",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabelle1[],8,FALSE),\"\")*H46,\"\")","v":""},"Einkommensteuer ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabelle1[],7,FALSE),\"\")*H46,\"\")","v":""},"Urlaubsstunden",{"$f":"IFERROR(VLOOKUP(H40,Tabelle2[],4,FALSE),\"\")","v":""}]
[null,null,"Steuern auf Krankenversicherung ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabelle1[],9,FALSE),\"\")*H46,\"\")","v":""},"Kommunalsteuer ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabelle1[],6,FALSE),\"\")*H46,\"\")","v":""},"Überstunden",{"$f":"IFERROR(VLOOKUP(H40,Tabelle2[],6,FALSE),\"\")","v":""}]
[null,null,"Abzug für Versicherungen",{"$f":"IFERROR(VLOOKUP(H40,Tabelle1[],11,FALSE),\"\")","v":""},"Sonstige reguläre Abzüge",{"$f":"IFERROR(VLOOKUP(H40,Tabelle1[],12,FALSE),\"\")","v":""},"Bruttogehalt",{"$f":"IFERROR(VLOOKUP(H40,Tabelle2[],8,FALSE),\"\")","v":""}]
[null,null,"Steuern gesamt und reguläre Abzüge ",{"$f":"IFERROR(SUM(F44:F46)+SUM(D44:D46),\"\")","v":0},"Sonstige Abzüge",{"$f":"IFERROR(VLOOKUP(H40,Tabelle2[],10,FALSE),\"\")","v":""},"Steuern gesamt und Abzüge ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabelle2[],9,FALSE),\"\")+F47,\"\")","v":""}]
[{"$nulls":6},"Nettogehalt",{"$f":"IFERROR(VLOOKUP(H40,Tabelle2[],11,FALSE),\"\")","v":""}]