{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Mitarbeiterinformationen","Lohn-und Gehaltsrechner","Einzelne Gehaltsabrechnungen"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Mitarbeiterinformationen","index":0,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,10]],"flags":["formulas_cached_only"]}
[]
[null,"Mitarbeiterinformationen"]
[null,"Mitarbeiter-ID","Name","Stundenlohn","Steuerstatus","Bundesfreibetrag (aus W-4)","Staatliche Steuer (Prozentwert)","Bundeseinkommenssteuer (Prozentsatz basierend auf Bundesfreibetrag)","Sozialversicherungssteuer (Prozentsatz)","Medicare-Steuer (Prozentsatz)","Gesamtbetrag der einbehaltenen Steuern ( Prozentsatz)","Versicherung\nAbzüge\n(Euro)","Sonstige reguläre\nAbzüge\n(Euro)","Summe der regulären Abzüge (ohne Steuern, in Euro)"]
[null,1,"Detlev Hembrock",10,1,4,0.023,0.28,0.063,0.0145,0.38050000000000006,20,40,60]
[null,2,null,null,null,null,null,null,null,null,0,20,40,60]
[null,3,null,null,null,null,null,null,null,null,0,null,null,0]
[null,4,null,null,null,null,null,null,null,null,0,null,null,0]
[null,5,null,null,null,null,null,null,null,null,0,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0,null,null,0]
[null,21,null,null,null,null,null,null,null,null,0,null,null,0]
[null,22,null,null,null,null,null,null,null,null,0,null,null,0]
[null,23,null,null,null,null,null,null,null,null,0,null,null,0]
[null,24,null,null,null,null,null,null,null,null,0,null,null,0]
[null,25,null,null,null,null,null,null,null,null,0,null,null,0]

{"sheet":"Lohn-und Gehaltsrechner","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Lohn-und Gehaltsrechner",null,null,null,null,null,null,null,null,"Ende des Zeitraums:","2025-02-01"]
[null,"Mitarbeiter-ID","Mitarbeitername","Reguläre Arbeitsstunden","Urlaubsstunden","Krankheitsstunden","Überstunden","Überstundensatz","Bruttogehalt","Steuern und Abzüge ","Sonstiges\nAbzüge","Nettogehalt"]
[null,1,"Detlev Hembrock",50,5,1,null,null,560,273.08000000000004,20,266.91999999999996]
[null,2,0,null,null,null,null,null,0,60,null,-60]
[null,3,0,null,null,null,null,null,0,0,null,0]
[null,4,0,null,null,null,null,null,0,0,null,0]
[null,5,0,null,null,null,null,null,0,0,null,0]
[null,6,0,null,null,null,null,null,0,0,null,0]
[null,7,0,null,null,null,null,null,0,0,null,0]
[null,8,0,null,null,null,null,null,0,0,null,0]
[null,9,0,null,null,null,null,null,0,0,null,0]
[null,10,0,null,null,null,null,null,0,0,null,0]
[null,11,0,null,null,null,null,null,0,0,null,0]
[null,12,0,null,null,null,null,null,0,0,null,0]
[null,13,0,null,null,null,null,null,0,0,null,0]
[null,14,0,null,null,null,null,null,0,0,null,0]
[null,15,0,null,null,null,null,null,0,0,null,0]
[null,16,0,null,null,null,null,null,0,0,null,0]
[null,17,0,null,null,null,null,null,0,0,null,0]
[null,18,0,null,null,null,null,null,0,0,null,0]
[null,19,0,null,null,null,null,null,0,0,null,0]
[null,20,0,null,null,null,null,null,0,0,null,0]
[null,21,0,null,null,null,null,null,0,0,null,0]
[null,22,0,null,null,null,null,null,0,0,null,0]
[null,23,0,null,null,null,null,null,0,0,null,0]
[null,24,0,null,null,null,null,null,0,0,null,0]
[null,25,0,null,null,null,null,null,0,0,null,0]

{"sheet":"Einzelne Gehaltsabrechnungen","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,"[Firmenname]"]
[null,null,"Zeitraum:","2025-02-01","Mitarbeitername","Detlev Hembrock","Mitarbeiter-ID",1]
[]
[null,null,"Status",1,"Freibetrag (aus W-4)",4,"Arbeitsstunden",50]
[null,null,"Stundensatz",10,"Überstundensatz",0,"Krankheitsstunden",1]
[null,null,"Steuern auf Sozialversicherung",35.28,"Einkommensteuer ",156.8,"Urlaubsstunden",5]
[null,null,"Steuern auf Krankenversicherung ",8.120000000000001,"Kommunalsteuer ",12.879999999999999,"Überstunden",0]
[null,null,"Abzug für Versicherungen",20,"Sonstige reguläre Abzüge",40,"Bruttogehalt",560]
[null,null,"Steuern gesamt und reguläre Abzüge ",273.08000000000004,"Sonstige Abzüge",20,"Steuern gesamt und Abzüge ",293.08000000000004]
[null,null,null,null,null,null,"Nettogehalt",266.91999999999996]
[]
[]
[null,null,"[Firmenname]"]
[null,null,"Zeitraum:","2025-02-01","Mitarbeitername",0,"Mitarbeiter-ID",2]
[]
[null,null,"Status",0,"Freibetrag (aus W-4)",0,"Arbeitsstunden",0]
[null,null,"Stundensatz",0,"Überstundensatz",0,"Krankheitsstunden",0]
[null,null,"Steuern auf Sozialversicherung",0,"Einkommensteuer ",0,"Urlaubsstunden",0]
[null,null,"Steuern auf Krankenversicherung ",0,"Kommunalsteuer ",0,"Überstunden",0]
[null,null,"Abzug für Versicherungen",20,"Sonstige reguläre Abzüge",40,"Bruttogehalt",0]
[null,null,"Steuern gesamt und reguläre Abzüge ",60,"Sonstige Abzüge",0,"Steuern gesamt und Abzüge ",60]
[null,null,null,null,null,null,"Nettogehalt",-60]
[]
[]
[null,null,"[Firmenname]"]
[null,null,"Zeitraum:","2025-02-01","Mitarbeitername",0,"Mitarbeiter-ID",3]
[]
[null,null,"Status",0,"Freibetrag (aus W-4)",0,"Arbeitsstunden",0]
[null,null,"Stundensatz",0,"Überstundensatz",0,"Krankheitsstunden",0]
[null,null,"Steuern auf Sozialversicherung",0,"Einkommensteuer ",0,"Urlaubsstunden",0]
[null,null,"Steuern auf Krankenversicherung ",0,"Kommunalsteuer ",0,"Überstunden",0]
[null,null,"Abzug für Versicherungen",0,"Sonstige reguläre Abzüge",0,"Bruttogehalt",0]
[null,null,"Steuern gesamt und reguläre Abzüge ",0,"Sonstige Abzüge",0,"Steuern gesamt und Abzüge ",0]
[null,null,null,null,null,null,"Nettogehalt",0]
[]
[]
[null,null,"[Firmenname]"]
[null,null,"Zeitraum:","2025-02-01","Mitarbeitername",0,"Mitarbeiter-ID",4]
[]
[null,null,"Status",0,"Freibetrag (aus W-4)",0,"Arbeitsstunden",0]
[null,null,"Stundensatz",0,"Überstundensatz",0,"Krankheitsstunden",0]
[null,null,"Steuern auf Sozialversicherung",0,"Einkommensteuer ",0,"Urlaubsstunden",0]
[null,null,"Steuern auf Krankenversicherung ",0,"Kommunalsteuer ",0,"Überstunden",0]
[null,null,"Abzug für Versicherungen",0,"Sonstige reguläre Abzüge",0,"Bruttogehalt",0]
[null,null,"Steuern gesamt und reguläre Abzüge ",0,"Sonstige Abzüge",0,"Steuern gesamt und Abzüge ",0]
[null,null,null,null,null,null,"Nettogehalt",0]