{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Home","Menu","De regeling","Gevolgen van mijn keuze","Gevolgen opleiding","Gevolgen tijd","Gevolgen geld","Mijn gegevens","Nuttige links","Wat kan ik kiezen","Rekenblad","Basiswaarden"],"not_rendered":{"charts":0,"images":42,"macros":1,"external_links":5,"defined_names":37,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partners van "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goed (= duurzaam) werken in de GGZ"]
[]
[]
[]
[null,"Balansbudget GGZ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"   "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Menu","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Balansbudget GGZ"]

{"sheet":"De regeling","index":2,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Het Balansbudget uitgelegd"]

{"sheet":"Gevolgen van mijn keuze","index":3,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Gevolgen van mijn keuze"]

{"sheet":"Gevolgen opleiding","index":4,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Gevolgen van deelname"]
[]
[]
[]
[null,null,null,"Opleiding"]

{"sheet":"Gevolgen tijd","index":5,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Gevolgen van deelname"]
[]
[]
[]
[null,null,null,"Tijd"]

{"sheet":"Gevolgen geld","index":6,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Gevolgen van deelname"]
[]
[]
[]
[null,null,null,"Geld"]

{"sheet":"Mijn gegevens","index":7,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,4,17,13],[23,4,23,13]]}
[]
[null,null,null,"Tool balansbudget"]
[]
[]
[null,null,"Mijn gegevens"]
[]
[null,null,"Beantwoord de onderstaande vragen. De antwoorden zijn nodig om de omvang van jouw balansbudget te berekenen."]
[]
[]
[null,null,null,null,"Ben je op 1 juli van dit kalenderjaar in dienst?"]
[]
[]
[]
[]
[]
[null,null,null,null,"Hoeveel uur per week werk je op 1 juli?"]
[]
[]
[]
[]
[]
[null,null,null,null,"Wat is je bruto (parttime) maandsalaris?"]

{"sheet":"Nuttige links","index":8,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nuttige links"]
[]
[]
[]
[]
[null,"Partners"]
[null,"CNV Zorg & Welzijn"]
[null,"FBZ Vakbond voor zorgprofessionals"]
[null,"FNV Zorg & Welzijn"]
[null,"NU'91 Dé beroepsorganisatie voor zorgprofessionals"]
[null,"Denederlandseggz.nl"]
[null,"O&O fonds GGZ/goedwerkenindeggz"]
[]
[null,"Toeslagen"]
[null,"Toeslagen (belastingdienst.nl)"]
[null,"Mijn toeslagen- Inloggen"]
[]
[null,"Pensioen"]
[null,"Mijnpensioenoverzicht.nl"]
[null,"PFZW | Particulieren"]
[null,"MijnPFZW - Inloggen"]
[null,"PFZW Toekomstverkenner"]
[]
[null,"Overig"]
[null,"CAO GGZ 2021-2024 (denederlandseggz.nl)"]
[null,"WerkUrenBerekenaar (nibud.nl)"]
[null,"Zorginspirator"]
[null,"Inzicht loopbaankeuzes en financiële gevolgen - O&O fonds GGZ"]
[]
[null,"Wist je dat?"]
[null,"Er een handige CAO app GGZ is?"]
[null,"Ga naar de App Store of naar Google Play en download de app!"]
[]
[]
[]
[]
[]
[]
[null,"CAO-artikelen Balansbudget"]
[null,"Preambule: Versterken inzetbaarheid Balansregeling"]
[null,"H2 artikel 30 lid 3 (hersteluren), artikel 35 (recht op balansbudget), artikel 36 (keuze aanwending balansbudget), artikel 37 (vervallen aanspraak balansbudget bij generatiepact)"]
[null,"H7 artikel 13 (inzetten balansbudget voor opleiding en ontwikkeling)"]
[null,"Bijlage XV: voorwaarden deelname Generatiepact"]
[]
[null,"Andere mogelijke relevante cao-artikelen met een relatie met balans en balansbudget"]
[null,"Extra hersteluren (H2 artikel 30)"]
[null,"Generatiepact (H2 artikel 37 en Bijlage XV)"]
[null,"LFB (H2 artikel 18 en 19)"]
[null,"Loopbaanadvies (H7 artikel 3)"]
[null,"Jaargesprek (H7 artikel 1 lid 5)"]

{"sheet":"Wat kan ik kiezen","index":9,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(Uren_per_week=\"\",Uren_per_week=0,Bruto_PT_maandsalaris=\"\",Bruto_PT_maandsalaris=0),\"Vul eerst je werkuren/salaris in op het scherm Mijn gegevens\",\"\")","v":"Vul eerst je werkuren/salaris in op het scherm Mijn gegevens"}]

{"sheet":"Rekenblad","index":10,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[]
["Balansbudget fulltime",500]
[]
["Deeltijdfactor",{"$f":"B45","v":0}]
[]
["Balansbudget naar rato",{"$f":"MIN(B2,B2*B4)","v":0}]
[]
[]
["Geld"]
[]
["Jaarsalaris",{"$f":"12*Bruto_PT_maandsalaris","v":0}]
[]
[{"$f":"Basiswaarden!A44","v":"Vakantiebijslag"},{"$f":"B11*Basiswaarden!B44","v":0}]
[]
[{"$f":"Basiswaarden!A46","v":"EJU"},{"$f":"B11*Basiswaarden!B46","v":0}]
[]
["Jaarsalaris incl. VT en EJU ",{"$f":"SUM(B11:B15)","v":0}]
[]
["Normaal tarief",{"$f":"IF(B17<Basiswaarden!A7,Basiswaarden!C6,Basiswaarden!C7)","v":0.36670000000000003}]
[]
["Bijzonder tarief",{"$f":"VLOOKUP(B11,Basiswaarden!$A$12:$E$25,4,TRUE)","v":{"$error":"#N/A"}}]
[]
["Bijzonder tarief toepassen?","ja"]
[]
["Toegepast tarief",{"$f":"IF(B23=\"nee\",B19,B21)","v":{"$error":"#N/A"}},null,{"$f":"IF(B23=\"nee\",A19,A21)","v":"Bijzonder tarief"}]
[]
["Netto balansbudget",{"$f":"B6*(1-B25)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IFERROR(IF(C56<>1,\"\",\"Het balansbudget bedraagt circa \n€ \"&ROUND(B27,)&\",- netto\"),\"\")","v":""}]
[]
[]
["Studie"]
[]
["Balansbudget ingezet voor studie"]
["+20% netto",{"$f":"B6*1.2","v":0},null,null,null,null,null,{"$f":"IF(C56<>1,\"\",\"Als je jouw balansbudget inzet voor een opleiding, kun je circa € \"&ROUND(B33,)&\",- aan een opleiding besteden.\")","v":"Als je jouw balansbudget inzet voor een opleiding, kun je circa € 0,- aan een opleiding besteden."}]
["+20% bruto",{"$f":"B33*(1-B25)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IFERROR(IF(C56<>1,\"\",\"Keert jouw werkgever het opleidingsbudget bruto uit? \n\nDan kun je circa € \"&ROUND(B34,)&\",- zonder en € \"&ROUND(B38,)&\",- met inzet van LFB aan een opleiding besteden. \n\nVraag hiernaar bij je leidinggevende.\"),\"\")","v":""}]
[]
["Balansbudget ingezet voor studie + opnemen van minimaal 20 LFB uren voor studie"]
["+40%",{"$f":"B6*1.4","v":0},null,null,null,null,null,{"$f":"IF(C56<>1,\"\",\"Als je minimaal \"&ROUNDUP(B40,0)&\" LFB uren inzet, kun je zelfs circa € \"&ROUND(B37,0)&\",- aan een opleiding besteden!\")","v":"Als je minimaal 0 LFB uren inzet, kun je zelfs circa € 0,- aan een opleiding besteden!"}]
["+40% bruto",{"$f":"B37*(1-B25)","v":{"$error":"#N/A"}}]
[]
["Minimale lfb inzet",{"$f":"20*B4","v":0}]
[]
[]
["Tijd"]
[]
["Deeltijdfactor",{"$f":"Uren_per_week/Fulltime_norm","v":0}]
[]
["Uren per maand",{"$f":"B45*Uren_per_maand","v":0}]
[]
["Uurloon",{"$f":"Bruto_PT_maandsalaris/B47","v":{"$error":"#DIV/0!"}}]
[null,null,"uur",null,"minuten",null,null,{"$f":"IFERROR(IF(C56<>1,\"\",\"Het balansbudget in tijd is \"&C51&\" uur en    \"&E51&\" minuten\"),\"\")","v":""}]
["Budget in uren",{"$f":"B6/B49","v":{"$error":"#DIV/0!"}},{"$f":"ROUNDDOWN(B51,0)","v":{"$error":"#DIV/0!"}},{"$f":"B51-C51","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D51*60,0)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Voorwaarde(n)"]
[]
["Voorwaarde",null,1,null,null,null,null,{"$f":"IF(C56<>1,\"Je hebt dit jaar geen recht op het Balansbudget\",\"VERDER\")","v":"VERDER"}]
["In dienst op 1 juli"]

{"sheet":"Basiswaarden","index":11,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Inkomensbelasting 2024"]
[]
["Van","tot","Tarief",null,"Bron:","U bereikt in 2024 de AOW-leeftijd (belastingdienst.nl)"]
[0,75518,0.36670000000000003]
[75518,null,0.495]
[]
["Bijzonder tarief"]
[]
["Van","T/m","Opbouw tarief","Verrek. %"]
[null,11778,0,0,{"$f":"C12+D12","v":0}]
[{"$f":"B12","v":11778},12410,0.36969999999999997,-8.43E-2,{"$f":"C13+D13","v":0.28539999999999999}]
[{"$f":"B13","v":12410},22982,0.36969999999999997,-0.31430000000000002,5.5399999999999949E-2]
[22982,24813,0.36969999999999997,-2.47E-2,0.34499999999999997]
[24813,32709,0.36969999999999997,4.1599999999999998E-2,0.4113]
[32709,35179,0.36969999999999997,4.1599999999999998E-2,0.4113]
[35179,38099,0.36969999999999997,4.1599999999999998E-2,0.4113]
[38099,39958,0.36969999999999997,4.1599999999999998E-2,0.4113]
[39958,40022,0.36969999999999997,0.13139999999999999,0.50109999999999999]
[40022,44771,0.36969999999999997,0.13139999999999999,0.50109999999999999]
[44771,58171,0.36969999999999997,0.13139999999999999,0.50109999999999999]
[58171,75519,0.36969999999999997,0.13139999999999999,0.50109999999999999]
[75519,134930,0.495,6.5100000000000005E-2,0.56010000000000004]
[134930,null,0.495,0,0.495]
[]
[]
[]
[]
["Bron:","Wat is het bijzonder tarief 2024? Dit betaal je over eenmalige beloningen | De Zaak"]
[]
[]
[]
[]
[]
["Arbeidsduur"]
[]
["Fulltime norm",36,"uur"]
["Uren per maand",156,"uur"]
[]
[]
["Grondslagen"]
[]
["Vakantiebijslag",0.08]
[]
["EJU",8.3299999999999999E-2]