{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Gegevens van werknemer","Loonkostencalculator","Afzonderlijke loonstrookjes"],"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":"Gegevens van werknemer","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,"Gegevens van werknemer"]
[null,"Werknemer-ID","Naam","Uurloon","Fiscale status","Overheidstoelage (W4)","Provinciale belasting (percentage)","Inkomstenbelasting (percentage, gebaseerd op overheidstoelage)","Sociale zekerheidsbelasting (percentage)","Medicare, Amerikaanse ziektekostenverzekering (percentage)","Totaal ingehouden belasting (percentage)","Verzekering\nInhoudingen\n(Euro’s)","Overige reguliere\nInhoudingen\n(Euro’s)","Totale reguliere inhoudingen (exclusief belastingen, in Euro’s)"]
[null,1,"Jimmy de Graaf",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":"Loonkostencalculator","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Loonkostencalculator",null,null,null,null,null,null,null,null,"Periode eindigend op:","2025-02-01"]
[null,"Werknemer-ID","Naam werknemer","Normale gewerkte uren","Vakantie-uren","Ziekteverlof","Overuren","Overurentarief","Brutosalaris","Totaal van belastingen en inhoudingen ","Overig\nInhoudingen","Nettosalaris"]
[null,1,"Jimmy de Graaf",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":"Afzonderlijke loonstrookjes","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,"[Bedrijfsnaam]"]
[null,null,"Periode:","2025-02-01","Naam werknemer","Jimmy de Graaf","Werknemer-ID",1]
[]
[null,null,"Fiscale status",1,"Federale toelage (uit W-4)",4,"Gewerkte uren",50]
[null,null,"Uurtarief",10,"Overurentarief",0,"Ziekteverlof",1]
[null,null,"Sociale zekerheidsbelasting",35.28,"Federale inkomensbelasting ",156.8,"Vakantie-uren",5]
[null,null,"Zorgverzekeringsbelasting ",8.120000000000001,"Provinciale belasting ",12.879999999999999,"Overuren",0]
[null,null,"Ingehouden verzekeringen",20,"Andere gewone inhoudingen",40,"Brutosalaris",560]
[null,null,"Totaal van belastingen en reguliere inhoudingen ",273.08000000000004,"Overige inhoudingen",20,"Totaal van belastingen en inhoudingen ",293.08000000000004]
[null,null,null,null,null,null,"Nettosalaris",266.91999999999996]
[]
[]
[null,null,"[Bedrijfsnaam]"]
[null,null,"Periode:","2025-02-01","Naam werknemer",0,"Werknemer-ID",2]
[]
[null,null,"Fiscale status",0,"Federale toelage (uit W-4)",0,"Gewerkte uren",0]
[null,null,"Uurtarief",0,"Overurentarief",0,"Ziekteverlof",0]
[null,null,"Sociale zekerheidsbelasting",0,"Federale inkomensbelasting ",0,"Vakantie-uren",0]
[null,null,"Zorgverzekeringsbelasting ",0,"Provinciale belasting ",0,"Overuren",0]
[null,null,"Ingehouden verzekeringen",20,"Andere gewone inhoudingen",40,"Brutosalaris",0]
[null,null,"Totaal van belastingen en reguliere inhoudingen ",60,"Overige inhoudingen",0,"Totaal van belastingen en inhoudingen ",60]
[null,null,null,null,null,null,"Nettosalaris",-60]
[]
[]
[null,null,"[Bedrijfsnaam]"]
[null,null,"Periode:","2025-02-01","Naam werknemer",0,"Werknemer-ID",3]
[]
[null,null,"Fiscale status",0,"Federale toelage (uit W-4)",0,"Gewerkte uren",0]
[null,null,"Uurtarief",0,"Overurentarief",0,"Ziekteverlof",0]
[null,null,"Sociale zekerheidsbelasting",0,"Federale inkomensbelasting ",0,"Vakantie-uren",0]
[null,null,"Zorgverzekeringsbelasting ",0,"Provinciale belasting ",0,"Overuren",0]
[null,null,"Ingehouden verzekeringen",0,"Andere gewone inhoudingen",0,"Brutosalaris",0]
[null,null,"Totaal van belastingen en reguliere inhoudingen ",0,"Overige inhoudingen",0,"Totaal van belastingen en inhoudingen ",0]
[null,null,null,null,null,null,"Nettosalaris",0]
[]
[]
[null,null,"[Bedrijfsnaam]"]
[null,null,"Periode:","2025-02-01","Naam werknemer",0,"Werknemer-ID",4]
[]
[null,null,"Fiscale status",0,"Federale toelage (uit W-4)",0,"Gewerkte uren",0]
[null,null,"Uurtarief",0,"Overurentarief",0,"Ziekteverlof",0]
[null,null,"Sociale zekerheidsbelasting",0,"Federale inkomensbelasting ",0,"Vakantie-uren",0]
[null,null,"Zorgverzekeringsbelasting ",0,"Provinciale belasting ",0,"Overuren",0]
[null,null,"Ingehouden verzekeringen",0,"Andere gewone inhoudingen",0,"Brutosalaris",0]
[null,null,"Totaal van belastingen en normale inhoudingen ",0,"Overige inhoudingen",0,"Totaal van belastingen en inhoudingen ",0]
[null,null,null,null,null,null,"Nettosalaris",0]