{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":0,"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":"Blad1","index":0,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10]]}
["FCUD patronale bijdrage 0,05% kinderopvang - koninklijk besluit 19 augustus 1997 - \nbijzonder reglement 2 september 1997."]
["Barema's van toepassing vanaf 1 juni 2011"]
[null,null,null,null,"index",1.546]
["attaché (Niveau A - regionale coördinator - Master)"]
["ancien.","basis '95","maand","jaar","H&S /mnd","H&S/jaar","V.G.","E.P.","TOT.","TOT - V.G."]
[0,21880,{"$f":"ROUND(D6/12,2)","v":2818.87},{"$f":"ROUND(B6*$F$3,2)","v":33826.480000000003},0,{"$f":"E6*12","v":0},{"$f":"(C6+E6)*0.92","v":2593.3604},{"$f":"ROUND(662.7+2.5%*(D6+F6),2)","v":1508.36},{"$f":"SUM(D6,F6,G6,H6)","v":37928.200400000002},{"$f":"SUM(D6,F6,H6)","v":35334.840000000004}]
[1,22325,2876.2,34514.449999999997,0,{"$f":"E7*12","v":0},{"$f":"(C7+E7)*0.92","v":2646.1039999999998},{"$f":"ROUND(662.7+2.5%*(D7+F7),2)","v":1525.56},{"$f":"SUM(D7,F7,G7,H7)","v":38686.113999999994},{"$f":"SUM(D7,F7,H7)","v":36040.009999999995}]
[2,22770,2933.54,35202.42,0,0,2698.8568,1542.76,39444.036800000002,36745.18]
[3,23215,2990.87,35890.39,0,0,2751.6003999999998,1559.96,40201.950400000002,37450.35]
[4,23660,3048.2,36578.36,0,0,2804.3440000000001,1577.16,40959.864000000001,38155.520000000004]
[5,24105,3105.53,37266.33,0,0,2857.0876000000003,1594.36,41717.777600000001,38860.69]
[6,24550,3162.86,37954.300000000003,0,0,2909.8312000000001,1611.56,42475.691200000001,39565.86]
[7,24995,3220.19,38642.269999999997,0,0,2962.5748000000003,1628.76,43233.604800000001,40271.03]
[8,25440,3277.52,39330.239999999998,0,0,3015.3184000000001,1645.96,43991.518399999994,40976.199999999997]
[9,25885,3334.85,40018.21,0,0,3068.0619999999999,1663.16,44749.432000000001,41681.370000000003]
[10,26330,3392.18,40706.18,0,{"$f":"E16*12","v":0},3120.8056000000001,1680.35,{"$f":"SUM(D16,F16,G16,H16)","v":45507.335599999999},{"$f":"SUM(D16,F16,H16)","v":42386.53}]
[11,26775,3449.51,41394.15,0,0,3173.5492000000004,1697.55,46265.249200000006,43091.700000000004]
[12,27220,3506.84,42082.12,0,0,3226.2928000000002,1714.75,47023.162800000006,43796.87]
[13,27665,{"$f":"ROUND(D19/12,2)","v":3564.17},42770.09,0,0,3279.0364000000004,1731.95,47781.076399999991,44502.039999999994]
[14,28110,3621.51,43458.06,0,0,3331.7892000000002,1749.15,48538.999199999998,45207.21]
[15,28555,3678.84,44146.03,0,0,3384.5328000000004,1766.35,49296.912799999998,45912.38]
[16,29000,3736.17,44834,0,{"$f":"E22*12","v":0},{"$f":"(C22+E22)*0.92","v":3437.2764000000002},1783.55,{"$f":"SUM(D22,F22,G22,H22)","v":50054.826400000005},{"$f":"SUM(D22,F22,H22)","v":46617.55}]
[17,29445,3793.5,{"$f":"ROUND(B23*$F$3,2)","v":45521.97},0,{"$f":"E23*12","v":0},{"$f":"(C23+E23)*0.92","v":3490.02},1800.75,{"$f":"SUM(D23,F23,G23,H23)","v":50812.74},{"$f":"SUM(D23,F23,H23)","v":47322.720000000001}]
[18,29890,3850.83,46209.94,0,{"$f":"E24*12","v":0},{"$f":"(C24+E24)*0.92","v":3542.7636000000002},1817.95,{"$f":"SUM(D24,F24,G24,H24)","v":51570.653599999998},{"$f":"SUM(D24,F24,H24)","v":48027.89}]
[19,30335,{"$f":"ROUND(D25/12,2)","v":3908.16},{"$f":"ROUND(B25*$F$3,2)","v":46897.91},0,{"$f":"E25*12","v":0},{"$f":"(C25+E25)*0.92","v":3595.5072},1835.15,{"$f":"SUM(D25,F25,G25,H25)","v":52328.567200000005},{"$f":"SUM(D25,F25,H25)","v":48733.060000000005}]
[20,30780,{"$f":"ROUND(D26/12,2)","v":3965.49},{"$f":"ROUND(B26*$F$3,2)","v":47585.88},0,{"$f":"E26*12","v":0},{"$f":"(C26+E26)*0.92","v":3648.2507999999998},1852.35,{"$f":"SUM(D26,F26,G26,H26)","v":53086.480799999998},{"$f":"SUM(D26,F26,H26)","v":49438.229999999996}]
["technisch deskundige (Niveau B - lokale coördinator - Bachelor)"]
["ancien.","basis '95","maand","jaar","H&S /mnd","H&S/jaar","V.G.","E.P.","TOT.","TOT - V.G."]
[0,16804,{"$f":"ROUND(D29/12,2)","v":2164.92},{"$f":"ROUND(B29*$F$3,2)","v":25978.98},23.19,{"$f":"E29*12","v":278.28000000000003},{"$f":"(C29+E29)*0.92","v":2013.0612000000001},{"$f":"ROUND(662.7+2.5%*(D29+F29),2)","v":1319.13},{"$f":"SUM(D29,F29,G29,H29)","v":29589.4512},{"$f":"SUM(D29,F29,H29)","v":27576.39}]
[1,17057,{"$f":"ROUND(D30/12,2)","v":2197.5100000000002},26370.12,23.19,{"$f":"E30*12","v":278.28000000000003},2043.0440000000003,{"$f":"ROUND(662.7+2.5%*(D30+F30),2)","v":1328.91},{"$f":"SUM(D30,F30,G30,H30)","v":30020.353999999999},{"$f":"SUM(D30,F30,H30)","v":27977.309999999998}]
[2,17310,2230.11,26761.26,23.19,278.28000000000003,2073.0360000000001,1338.69,30451.265999999996,28378.229999999996]
[3,17563,2262.6999999999998,27152.400000000001,23.19,278.28000000000003,2103.0187999999998,1348.47,30882.168799999999,28779.15]
[4,17563,2262.6999999999998,27152.400000000001,23.19,278.28000000000003,2103.0187999999998,1348.47,30882.168799999999,28779.15]
[5,17856,2300.4499999999998,27605.38,23.19,278.28000000000003,2137.7487999999998,1359.79,31381.198800000002,29243.45]
[6,17856,2300.4499999999998,27605.38,23.19,278.28000000000003,2137.7487999999998,1359.79,31381.198800000002,29243.45]
[7,18247,2350.8200000000002,28209.86,23.19,278.28000000000003,2184.0892000000003,1374.9,32047.129200000003,29863.040000000001]
[8,18247,2350.8200000000002,28209.86,23.19,278.28000000000003,2184.0892000000003,1374.9,32047.129200000003,29863.040000000001]
[9,18920,2437.5300000000002,29250.32,0,0,2242.5276000000003,1393.96,32886.8076,30644.28]
[10,18920,2437.5300000000002,29250.32,0,0,2242.5276000000003,1393.96,32886.8076,30644.28]
[11,19593,2524.23,30290.78,0,0,2322.2916,1419.97,34033.041599999997,31710.75]
[12,19593,2524.23,30290.78,0,0,2322.2916,1419.97,34033.041599999997,31710.75]
[13,20218,{"$f":"ROUND(D42/12,2)","v":2604.75},31257.03,0,0,{"$f":"(C42+E42)*0.92","v":2396.37},1444.13,{"$f":"SUM(D42,F42,G42,H42)","v":35097.53},{"$f":"SUM(D42,F42,H42)","v":32701.16}]
[14,20218,2604.75,31257.03,0,0,2396.37,1444.13,35097.53,32701.16]
[15,20843,2685.27,32223.279999999999,0,0,2470.4484000000002,1468.28,36162.008399999999,33691.56]
[16,20843,2685.27,32223.279999999999,0,{"$f":"E45*12","v":0},2470.4484000000002,1468.28,36162.008399999999,33691.56]
[17,21468,2765.79,{"$f":"ROUND(B46*$F$3,2)","v":33189.53},0,{"$f":"E46*12","v":0},2544.5268000000001,1492.44,37226.496800000001,34681.97]
[18,21468,2765.79,33189.53,0,{"$f":"E47*12","v":0},2544.5268000000001,1492.44,37226.496800000001,34681.97]
[19,22093,{"$f":"ROUND(D48/12,2)","v":2846.32},{"$f":"ROUND(B48*$F$3,2)","v":34155.78},0,{"$f":"E48*12","v":0},{"$f":"(C48+E48)*0.92","v":2618.6144000000004},1516.59,{"$f":"SUM(D48,F48,G48,H48)","v":38290.984399999994},{"$f":"SUM(D48,F48,H48)","v":35672.369999999995}]
[20,22093,{"$f":"ROUND(D49/12,2)","v":2846.32},{"$f":"ROUND(B49*$F$3,2)","v":34155.78},0,{"$f":"E49*12","v":0},{"$f":"(C49+E49)*0.92","v":2618.6144000000004},1516.59,{"$f":"SUM(D49,F49,G49,H49)","v":38290.984399999994},{"$f":"SUM(D49,F49,H49)","v":35672.369999999995}]
["administratief assistent (Niveau C - begeleiding - diploma Hoger Secundair onderwijs)"]
["ancien.","basis '95","maand","jaar","H&S /mnd","H&S/jaar","V.G.","E.P.","TOT.","TOT - V.G."]
[0,14273.7,{"$f":"ROUND(D52/12,2)","v":1838.93},{"$f":"ROUND(B52*$F$3,2)","v":22067.14},46.37,{"$f":"E52*12","v":556.43999999999994},{"$f":"(C52+E52)*0.92","v":1734.4760000000001},{"$f":"ROUND(662.7+2.5%*(D52+F52),2)","v":1228.29},{"$f":"SUM(D52,F52,G52,H52)","v":25586.345999999998},{"$f":"SUM(D52,F52,H52)","v":23851.87}]
[1,14541.01,{"$f":"ROUND(D53/12,2)","v":1873.37},22480.400000000001,46.37,{"$f":"E53*12","v":556.43999999999994},{"$f":"(C53+E53)*0.92","v":1766.1607999999999},{"$f":"ROUND(662.7+2.5%*(D53+F53),2)","v":1238.6199999999999},{"$f":"SUM(D53,F53,G53,H53)","v":26041.620800000001},{"$f":"SUM(D53,F53,H53)","v":24275.46}]
[2,14808.32,1907.81,22893.66,46.37,556.43999999999994,1797.8455999999999,1248.95,26496.8956,24699.05]
[3,15075.63,1942.24,23306.92,46.37,556.43999999999994,1829.5211999999999,1259.28,26952.161199999995,25122.639999999996]
[4,15075.63,1942.24,23306.92,46.37,556.43999999999994,1829.5211999999999,1259.28,26952.161199999995,25122.639999999996]
[5,15431.97,1988.15,23857.83,46.37,556.43999999999994,1871.7584000000002,1273.06,27559.088400000001,25687.33]
[6,15431.97,1988.15,23857.83,46.37,556.43999999999994,1871.7584000000002,1273.06,27559.088400000001,25687.33]
[7,15788.31,2034.06,24408.73,46.37,556.43999999999994,1913.9956,1286.83,28165.995599999995,26252]
[8,15788.31,2034.06,24408.73,46.37,556.43999999999994,1913.9956,1286.83,28165.995599999995,26252]
[9,16411.919999999998,2114.4,25372.83,23.19,278.28000000000003,1966.5828000000001,1303.98,28921.6728,26955.09]
[10,16411.919999999998,2114.4,25372.83,23.19,278.28000000000003,1966.5828000000001,1303.98,28921.6728,26955.09]
[11,17035.53,2194.7399999999998,26336.93,23.19,278.28000000000003,2040.4956,1328.08,29983.785599999996,27943.29]
[12,17035.53,2194.7399999999998,26336.93,23.19,278.28000000000003,2040.4956,1328.08,29983.785599999996,27943.29]
[13,17659.14,{"$f":"ROUND(D65/12,2)","v":2275.09},27301.03,23.19,278.28000000000003,{"$f":"(C65+E65)*0.92","v":2114.4176000000002},1352.18,{"$f":"SUM(D65,F65,G65,H65)","v":31045.907599999999},{"$f":"SUM(D65,F65,H65)","v":28931.489999999998}]
[14,17659.14,2275.09,27301.03,23.19,278.28000000000003,2114.4176000000002,1352.18,31045.907599999999,28931.489999999998]
[15,18282.75,2355.4299999999998,28265.13,23.19,278.28000000000003,2188.3303999999998,1376.29,32108.0304,29919.7]
[16,18282.75,2355.4299999999998,28265.13,23.19,{"$f":"E68*12","v":278.28000000000003},2188.3303999999998,1376.29,32108.0304,29919.7]
[17,18906.36,2435.77,{"$f":"ROUND(B69*$F$3,2)","v":29229.23},0,{"$f":"E69*12","v":0},2240.9084000000003,1393.43,32863.568399999996,30622.66]
[18,18906.36,2435.77,29229.23,0,{"$f":"E70*12","v":0},2240.9084000000003,1393.43,32863.568399999996,30622.66]
[19,19529.97,{"$f":"ROUND(D71/12,2)","v":2516.11},{"$f":"ROUND(B71*$F$3,2)","v":30193.33},0,{"$f":"E71*12","v":0},{"$f":"(C71+E71)*0.92","v":2314.8212000000003},1417.53,{"$f":"SUM(D71,F71,G71,H71)","v":33925.681199999999},{"$f":"SUM(D71,F71,H71)","v":31610.86}]
[20,19529.97,{"$f":"ROUND(D72/12,2)","v":2516.11},{"$f":"ROUND(B72*$F$3,2)","v":30193.33},0,{"$f":"E72*12","v":0},{"$f":"(C72+E72)*0.92","v":2314.8212000000003},1417.53,{"$f":"SUM(D72,F72,G72,H72)","v":33925.681199999999},{"$f":"SUM(D72,F72,H72)","v":31610.86}]
["administratief medewerker (Niveau D - geen diplomavereisten)"]
["ancien.","basis '95","maand","jaar","H&S /mnd","H&S/jaar","V.G.","E.P.","TOT.","TOT - V.G."]
[0,12951.56,{"$f":"ROUND(D75/12,2)","v":1668.59},{"$f":"ROUND(B75*$F$3,2)","v":20023.11},46.37,{"$f":"E75*12","v":556.43999999999994},{"$f":"(C75+E75)*0.92","v":1577.7631999999999},{"$f":"ROUND(662.7+2.5%*(D75+F75),2)","v":1177.19},{"$f":"SUM(D75,F75,G75,H75)","v":23334.503199999999},{"$f":"SUM(D75,F75,H75)","v":21756.739999999998}]
[1,13091.65,{"$f":"ROUND(D76/12,2)","v":1686.64},20239.689999999999,46.37,{"$f":"E76*12","v":556.43999999999994},1594.3692000000001,{"$f":"ROUND(662.7+2.5%*(D76+F76),2)","v":1182.5999999999999},{"$f":"SUM(D76,F76,G76,H76)","v":23573.099199999997},{"$f":"SUM(D76,F76,H76)","v":21978.729999999996}]
[2,13231.74,1704.69,20456.27,46.37,556.43999999999994,1610.9752000000001,1188.02,23811.7052,22200.73]
[3,13371.83,1722.74,20672.849999999999,46.37,556.43999999999994,1627.5812000000001,1193.43,24050.301199999998,22422.719999999998]
[4,13371.83,1722.74,20672.849999999999,46.37,556.43999999999994,1627.5812000000001,1193.43,24050.301199999998,22422.719999999998]
[5,13566.5,1747.82,20973.81,46.37,556.43999999999994,1650.6548,1200.96,24381.864799999999,22731.21]
[6,13566.5,1747.82,20973.81,46.37,556.43999999999994,1650.6548,1200.96,24381.864799999999,22731.21]
[7,13761.17,1772.9,21274.77,46.37,556.43999999999994,1673.7284,1208.48,24713.418399999999,23039.69]
[8,13761.17,1772.9,21274.77,46.37,556.43999999999994,1673.7284,1208.48,24713.418399999999,23039.69]
[9,13955.84,1797.98,21575.73,46.37,556.43999999999994,1696.8019999999999,1216,25044.971999999998,23348.17]
[10,13955.84,1797.98,21575.73,46.37,556.43999999999994,1696.8019999999999,1216,25044.971999999998,23348.17]
[11,14150.51,1823.06,21876.69,46.37,556.43999999999994,1719.8755999999998,1223.53,25376.535599999996,23656.659999999996]
[12,14150.51,1823.06,21876.69,46.37,556.43999999999994,1719.8755999999998,1223.53,25376.535599999996,23656.659999999996]
[13,14345.18,{"$f":"ROUND(D88/12,2)","v":1848.14},22177.65,46.37,556.43999999999994,{"$f":"(C88+E88)*0.92","v":1742.9492},1231.05,{"$f":"SUM(D88,F88,G88,H88)","v":25708.089199999999},{"$f":"SUM(D88,F88,H88)","v":23965.14}]
[14,14345.18,1848.14,22177.65,46.37,556.43999999999994,1742.9492,1231.05,25708.089199999999,23965.14]
[15,14669.29,1889.89,22678.720000000001,46.37,556.43999999999994,1781.3592000000001,1243.58,26260.099199999997,24478.739999999998]
[16,14669.29,1889.89,22678.720000000001,46.37,{"$f":"E91*12","v":556.43999999999994},1781.3592000000001,1243.58,26260.099199999997,24478.739999999998]
[17,14993.4,1931.65,23179.8,46.37,{"$f":"E92*12","v":556.43999999999994},1819.7784000000001,1256.1099999999999,26812.128399999998,24992.35]
[18,14993.4,1931.65,{"$f":"ROUND(B93*$F$3,2)","v":23179.8},46.37,{"$f":"E93*12","v":556.43999999999994},1819.7784000000001,1256.1099999999999,26812.128399999998,24992.35]
[19,15317.51,{"$f":"ROUND(D94/12,2)","v":1973.41},{"$f":"ROUND(B94*$F$3,2)","v":23680.87},46.37,{"$f":"E94*12","v":556.43999999999994},{"$f":"(C94+E94)*0.92","v":1858.1976},1268.6300000000001,{"$f":"SUM(D94,F94,G94,H94)","v":27364.137599999998},{"$f":"SUM(D94,F94,H94)","v":25505.94}]
[20,15317.51,{"$f":"ROUND(D95/12,2)","v":1973.41},{"$f":"ROUND(B95*$F$3,2)","v":23680.87},46.37,{"$f":"E95*12","v":556.43999999999994},{"$f":"(C95+E95)*0.92","v":1858.1976},1268.6300000000001,{"$f":"SUM(D95,F95,G95,H95)","v":27364.137599999998},{"$f":"SUM(D95,F95,H95)","v":25505.94}]
[]
["- Opmerking 1:",null,null,"Bedragen vakantiegeld (V.G.) en eindejaarspremie (E.P.) zijn indicatief."]
[null,null,null,"Voor deze berekeningen zullende verplichtingen van de paritaire comité's"]
[null,null,null,"gerespecteerd worden op basis van de brutolonen zoals aangegeven."]
["- Opmerking 2:",null,null,"De patronale bijdragen komen integraal voor subsidiëring in aanmerking."]