{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Transitieberekening"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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"}

{"sheet":"Transitieberekening","index":0,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[[56,2,56,6],[59,2,59,6],[39,2,39,6],[5,2,5,6],[14,5,14,6],[15,2,15,6],[33,2,33,6],[35,2,35,6],[50,2,50,6],[51,2,51,6]]}
[]
[]
[]
[]
[]
[null,null,"BEREKENING TRANSITIEVERGOEDING **"]
[]
[null,null,"Naam:","John Doe"]
[]
[null,null,"Geboren (dd/mm/jjjj):","1979-08-15","*","Leeftijd in dienst:",{"$f":"IFERROR(IF(OR(D10=0,D11=0,D12=0),\"-\",IF(DATEDIF(D10,D11,\"Y\")=0,\"\",DATEDIF(D10,D11,\"Y\"))),\"\")","v":27}]
[null,null,"In dienst (dd/mm/jjjj):","2007-07-01","*","Leeftijd uit dienst:",{"$f":"IFERROR(IF(OR(D10=0,D11=0,D12=0),\"-\",IF(DATEDIF(D10,D12,\"Y\")=0,\"\",DATEDIF(D10,D12,\"Y\"))),\"\")","v":41}]
[null,null,"Uit dienst (dd/mm/jjjj):","2021-01-01","*"]
[]
[null,null,"AOW gerechtigde leeftijd bereikt? ","Nee","*"]
[]
[null,null,"BEREKENING INKOMEN **"]
[]
[null,null,null,"Invoer",null,"Maandbedragen","Jaarbedragen"]
[null,null,"Bruto maandloon",2500,"*",{"$f":" D19","v":2500},{"$f":"IFERROR(12*D19,0)","v":30000}]
[null,null,"Vaste looncomponenten ",null,null,{"$f":"SUM(F21:F22)","v":166.66666666666666},{"$f":"SUM(G21:G22)","v":2000}]
[null,null,"Overwerkvergoedingen laatste jaar",1000,null,{"$f":"IFERROR(SUM(D21/12),0)","v":83.333333333333329},{"$f":"IFERROR(SUM(D21),0)","v":1000}," "]
[null,null,"Ploegentoeslagen laatste jaar",1000,null,{"$f":"IFERROR(SUM(D22/12),0)","v":83.333333333333329},{"$f":"IFERROR(SUM(D22),0)","v":1000}]
[null,null,"Variabele looncomponenten  ",null,null,{"$f":"SUM(F24:F26)","v":208.33333333333334},{"$f":"SUM(G24:G26)","v":2500}]
[null,null,"Som van bonussen laatste 3 jaar",7500,null,{"$f":"IFERROR(SUM(D24/36),0)","v":208.33333333333334},{"$f":"IFERROR(SUM(D24/3),0)","v":2500}]
[null,null,"Som van winstuitkeringen laatste 3 jaar",null,null,{"$f":"IFERROR(SUM(D25/36),0)","v":0},{"$f":"IFERROR(SUM(D25/3),0)","v":0}," "]
[null,null,"Som van eindejaarsuitkeringen laatste 3 jaar",null,null,{"$f":"IFERROR(SUM(D26/36),0)","v":0},{"$f":"IFERROR(SUM(D26/3),0)","v":0}]
[null,null,"Subtotaal",null,null,{"$f":"IFERROR(SUM(F19+F20+F23),0)","v":2875},{"$f":"SUM(G19+G20+G23)","v":34500}]
[null,null,"Vakantiegeld","ja","*",null,{"$f":"IF(D28=\"Ja\",0.08*G19,0)","v":2400}]
[null,null,"13e maand","ja","*",null,{"$f":"IF(D29=\"Ja\",D19,0)","v":2500}]
[]
[null,null,"Totaal",null,null,{"$f":"G31/12","v":3283.3333333333335},{"$f":"SUM(G27:G29)","v":39400}]
[]
[]
[null,null,"TRANSITIEVERGOEDING:"]
[]
[null,null,{"$f":"IF(OR(D10=0,D11=0,D12=0,D14=\"maak keuze:\",D19=0,D28=\"maak keuze:\",D29=\"maak keuze:\"),\"Vul eerst de relevante cellen in.\",IF(D14=\"Ja\",\"Werknemer heeft AOW gerechtigde leefdtijd bereikt en daarom geen recht op een vergoeding.\",IF(G38=\"nee\",MIN(83000,G49),MIN(G31,G49))))","v":14775}]
[]
[null,null,null,null,null,"Jaarsalaris hoger dan 83.000?",{"$f":"IF(G31>83000,\"Ja\",\"Nee\")","v":"Nee"}]
[]
[null,null,"SPECIFICATIE BEREKENING"]
[]
[null,null,"Uurloon",null,null,null,{"$f":"F31/(40*4.333)","v":18.943764904992694}]
[null,null,"Dagloon uitgaande van 8 uur per dag",null,null,null,{"$f":"G42*8","v":151.55011923994155}]
[]
[null,null,"Diensttijd",null,null,"Weging"]
[null,null,"1.in gehele jaren",{"$f":"DATEDIF(D11,D12,\"y\")","v":13},null,0.33333333333333331,{"$f":"IF(ISERROR(D46*(F46*F31)),\"-\",(D46*(F46*F31)))","v":14227.777777777777}]
[null,null,"2. Maanden na gehele jaren",{"$f":"DATEDIF(D11,D12,\"YM\")","v":6},null,0.33333333333333331,{"$f":"IF(ISERROR(D47*(F47*F31/12)),\"-\",(D47*(F47*F31/12)))","v":547.22222222222217}]
[null,null,"3. Dagen na gehele jaren en gehele maanden",{"$f":"D12-DATE(YEAR(D12),MONTH(D12),1)","v":0},null,0.33333333333333331,{"$f":"G43*D48/F31*F48*F31/12","v":0}]
[null,null,null,null,null,"Totaal",{"$f":"SUM(G46:G48)","v":14775}]
[]
[null,null,"De (interactieve) tools van Hulp Bij Reorganiseren zijn bedoeld als hulpmiddel. \nMet het beschikbaar stellen daarvan beoogt Hulp Bij Reorganiseren niet een juridisch advies te geven. \nAan de uitkomst van de tools van Hulp Bij Reorganiseren kunnen geen rechten worden ontleend en Hulp Bij Reorganiseren is niet aansprakelijk voor (de gevolgen van) het gebruik van de tools. Mocht u vragen hebben over (de uitkomst van) de tools dan kunt u contact met ons opnemen via het contactformulier."]
[null,null,"Deze tool is gecreëerd in samenwerking met Uw Actuaris."]
[null,null,"* Verplicht veld"]
[null,null,"** Gebruik entertoets in deze tool"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Maak keuze:"]
[null,null,"Ja"]
[null,null,"Nee"]
[null,null,"2013-05-01"]