{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["récapitulatif","Nouveau statut"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":323,"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":"récapitulatif","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,1,10,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Récapitulatif par année"]
[]
[null,"Choix de l' année",2027]
[]
[]
[null,"Toutes les années"]
[]
[]
[]
["Nathalie",{"$f":"CONCATENATE(A20,\" \",$C$13)","v":"Nathalie 2027"}]
["Véronique","Véronique 2027"]
["Elodie R","Elodie R 2027"]
["Céline","Céline 2027"]

{"sheet":"Nouveau statut","index":1,"n_rows":45,"n_cols":21,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,20,1,20],[0,7,0,8],[0,17,1,17],[0,19,1,19],[0,12,0,13],[1,12,1,13],[0,14,0,15],[0,9,0,10],[0,18,2,18],[15,0,15,1],[2,0,2,1],[32,0,32,1],[19,0,19,1]]}
["Année",null,null,"ENTREE dans l'établis.","Base","Augmentation générale","Prime","Ancien calcul CCN 51",null,"Charges patronales",null,"Montant","Changement ancienneté en cours d'année",null,"Nouvelle proposition",null,"Ecarts","Charges patronales S.S.","Charges patronales fiscales - abattement","Masse salariale nouveau satut","Ecarts"]
[2022,2022,null,null,"Mensuel","annuelle","Exceptionnelle en euros","taux CCN","Brut","sociales","fiscales - abattement","Coûts   ssalariaux","selon CCN 51",null,1.4E-2,"Brut","mensuel"]
["Nathalie",null,null,"2002-07-08",5952.3709677419365,null,null,null,null,null,null,null,6,6,"Tous les ans",7380.9400000000014]
["Nathalie",2021,"Nathalie 2021","2021-07-08",5952.3709677419365,0,null,0.24,7380.9400000000014,3374.5482988000003,689.68268476622234,11445.170983566226,null,null,0.24,7380.9400000000014,0,3374.5482988000003,689.68268476622234,11445.170983566226,0]
["Nathalie",2022,"Nathalie 2022","2022-07-08",5952.3709677419365,0,null,0.24,7380.9400000000014,3316.9769668000004,689.81868476622253,11387.735651566223,null,null,0.254,7464.273193548388,83.333193548386589,3354.0785712316133,702.03079761468689,11520.382562394689,83.333193548386589]
["Nathalie",2023,"Nathalie 2023","2023-07-08",5952.3709677419365,0,null,0.28000000000000003,7499.9874193548403,3459.1691092361298,707.26456026402889,11666.421088855001,714.28451612903234,833.33193548387123,0.26800000000000002,7499.9874193548403,0,3459.1691092361298,707.26456026402889,11666.421088855001,0]
["Nathalie",2024,"Nathalie 2024","2024-07-08",5952.3709677419365,0,null,0.28000000000000003,7619.0348387096792,3618.0288427612913,724.71043576183547,11961.774117232806,null,null,0.28200000000000003,7630.939580645163,11.904741935483798,3623.6338333593553,726.45502331161606,11981.028437316134,11.904741935483798]
["Nathalie",2025,"Nathalie 2025","2025-07-08",5952.3709677419365,0,null,0.28000000000000003,7619.0348387096792,3440.3529503225814,724.71043576183547,11784.098224794096,null,null,0.29600000000000004,7714.2727741935505,95.237935483871297,3482.9719264516134,738.66713616008064,11935.911836805244,95.237935483871297]
["Nathalie",2026,"Nathalie 2026","2026-07-08",5952.3709677419365,0,null,0.32,7738.0822580645181,3498.7338047741946,742.15631125964183,11978.972374098354,833.33193548387123,952.37935483871001,0.31000000000000005,7738.0822580645181,0,3498.7338047741946,742.15631125964183,11978.972374098354,0]
["Nathalie",2027,"Nathalie 2027","2027-07-08",5952.3709677419365,0,null,0.32,7857.1296774193561,3529.9289905419359,759.60218675744818,12146.660854718739,null,null,0.32400000000000007,7880.9391612903246,23.809483870968506,3540.5323060890332,763.09136185700959,12184.562829236367,23.809483870968506]
["Nathalie",2028,"Nathalie 2028","2028-07-08",5952.3709677419365,0,null,0.32,7857.1296774193561,3529.9289905419359,759.60218675744818,12146.660854718739,null,null,0.33800000000000008,7964.2723548387112,107.1426774193551,3577.6439105038717,775.30347470547417,12317.219740048056,107.1426774193551]
["Nathalie",2029,"Nathalie 2029","2029-07-08",5952.3709677419365,0,null,0.36,7976.177096774195,3549.3349986477424,779.68913057525469,12305.201225997193,952.37935483871001,1071.4267741935485,0.35200000000000009,7976.177096774195,0,3549.3349986477424,779.68913057525469,12305.201225997193,0]
["Nathalie",2030,"Nathalie 2030","2030-07-08",5952.3709677419365,0,null,0.36,8095.2245161290339,3633.1450078812913,794.49393775306112,12522.863461763387,null,null,0.3660000000000001,8130.9387419354862,35.714225806452305,3649.0375526513558,799.72770040240334,12579.703994989246,35.714225806452305]
["Nathalie",2031]
["Nathalie","vide"]
[" Véronique",null,null,"1995-11-06",3537.5909090909086,null,null,null,null,null,null,null,null,null,null,4669.619999999999]
["Véronique",2021,"Véronique 2021","2021-11-06",3537.5909090909086,0,null,0.32,4669.619999999999,2295.2269903999995,585.21177968533323,7550.0587700853321,null,null,0.32,4669.619999999999,null,2295.2269903999995,585.21177968533323,7550.0587700853321,0]
["Véronique",2022,null,"2022-11-06",1179.1969696969695,0,null,0.32,1556.5399999999997,710.65701547999993,129.00360323733329,2396.2006187173329,null,null,0.33400000000000002,1573.0487575757575,16.508757575757727,718.19428685630305,131.42288902152725,2422.665933453588,16.508757575757727]
["Véronique","vide"]
["Elodie",null,null,"2006-04-03",2728.7499999999986,null,null,null,null,null,null,null,3,9,null,3165.3499999999985]
["Elodie R",2021,"Elodie R 2021","2021-04-03",2728.7499999999986,0,null,0.2,3274.4999999999982,1492.8936674999991,87.901971102221921,4855.2956386022188,null,null,0.2,3274.4999999999982,null,1492.8936674999991,87.901971102221921,4855.2956386022188,0]
["Elodie R",2022,"Elodie R 2022","2022-04-03",2728.7499999999986,0,null,0.2,3274.4999999999982,1492.8936674999991,88.037971102221888,4855.4316386022183,null,null,0.21400000000000002,3312.7024999999985,38.202500000000327,1510.3107602874995,93.636379386222018,4916.6496396737202,38.202500000000327]
["Elodie R",2023,"Elodie R 2023","2023-04-03",2728.7499999999986,0,null,0.2,3274.4999999999982,1492.8936674999991,88.037971102221888,4855.4316386022183,null,null,0.22800000000000004,3350.9049999999984,76.4050000000002,1527.7278530749993,99.23478767022192,4977.8676407452194,76.4050000000002]
["Elodie R",2024,"Elodie R 2024","2024-04-03",2728.7499999999986,0,null,0.24,3356.3624999999984,1530.2160091874994,100.03456028222195,4986.6130694697194,136.43749999999994,491.17499999999973,0.24200000000000005,3356.3624999999984,0,1530.2160091874994,100.03456028222195,4986.6130694697194,0]
["Elodie R",2025,"Elodie R 2025","2025-04-03",2728.7499999999986,0,null,0.24,3383.6499999999983,1542.6567897499992,104.03342334222197,5030.3402130922195,null,null,0.25600000000000006,3427.3099999999986,43.660000000000309,1562.5620386499995,110.43160423822201,5100.3036428882206,43.660000000000309]
["Elodie R",2026,"Elodie R 2026","2026-04-03",2728.7499999999986,0,null,0.24,3383.6499999999983,1542.6567897499992,104.03342334222197,5030.3402130922195,null,null,0.27000000000000007,3465.5124999999985,81.862500000000182,1579.6417064999994,116.03001252222197,5161.1842190222196,81.862500000000182]
["Elodie R",2027,"Elodie R 2027","2027-04-03",2728.7499999999986,0,null,0.28000000000000003,3465.5124999999985,1579.6417064999994,116.03001252222197,5161.1842190222196,163.72499999999991,573.0374999999998,0.28400000000000009,3465.5124999999985,0,1579.6417064999994,116.03001252222197,5161.1842190222196,0]
["Elodie R",2028,"Elodie R 2028","2028-04-03",2728.7499999999986,0,null,0.28000000000000003,3492.7999999999984,1591.8370359999992,120.02887558222193,5204.6659115822195,null,null,0.2980000000000001,3541.9174999999987,49.117500000000291,1613.7886290999993,127.226829090222,5282.9329581902202,49.117500000000291]
["Elodie R",2029,"Elodie R 2029","2029-04-03",2728.7499999999986,0,null,0.28000000000000003,3492.7999999999984,1591.8370359999992,120.02887558222193,5204.6659115822195,null,null,0.31200000000000011,3580.1199999999985,87.320000000000164,1630.8620903999993,132.82523737422196,5343.8073277742196,87.320000000000164]
["Elodie R",2030,"Elodie R 2030","2030-04-03",2728.7499999999986,0,null,0.32,3574.6624999999981,1628.4230244999992,132.02546476222193,5335.1109892622198,191.01249999999993,654.89999999999975,0.32600000000000012,3574.6624999999981,0,1628.4230244999992,132.02546476222193,5335.1109892622198,0]
["Elodie R",2031]
["Elodie R","vide"]
["Céline",null,null,"2010-11-04",2527.4107142857133,null,null,null,null,null,null,null,10,2,null,2830.6999999999989]
["Céline",2021,"Céline 2021","2021-11-04",2527.4107142857133,0,null,0.12,2830.6999999999989,1039.5887284999997,20.168420994222004,3890.4571494942206,null,null,0.16,2931.7964285714274,null,1076.7168973749997,34.793026307507773,4043.3063522539351,101.09642857142853]
["Céline",2022,"Céline 2022","2022-11-04",2527.4107142857133,0,null,0.16,2847.5494047619036,1001.6397408720235,22.49252187976964,3871.681667513697,252.74107142857133,67.397619047619017,0.17400000000000002,2847.5494047619036,0,1001.6397408720235,22.49252187976964,3871.681667513697,0]
["Céline",2023,"Céline 2023","2023-11-04",2527.4107142857133,0,null,0.16,2931.7964285714274,1031.2740527321425,34.679692974174429,3997.7501742777445,null,null,0.18800000000000003,3002.5639285714274,70.767499999999927,1056.1668746946427,44.916916693474434,4103.6477199595447,70.767499999999927]
["Céline",2024,"Céline 2024","2024-11-04",2527.4107142857133,0,null,0.16,2931.7964285714274,1031.2740527321425,34.679692974174429,3997.7501742777445,null,null,0.20200000000000004,3037.9476785714273,106.15124999999989,1068.6132856758925,50.035528553124379,4156.5964928004441,106.15124999999989]
["Céline",2025,"Céline 2025","2025-11-04",2527.4107142857133,0,null,0.2,3032.892857142856,1066.8352269642855,49.304298287460085,4149.0323823946019,null,null,0.21600000000000005,3073.3314285714278,40.438571428571777,1081.0596966571427,55.154140412774439,4209.5452656413454,40.438571428571777]
["Céline",2026,"Céline 2026","2026-11-04",2527.4107142857133,0,null,0.2,3032.892857142856,1066.8352269642855,49.304298287460085,4149.0323823946019,421.23511904761892,84.247023809523782,0.23000000000000007,3032.892857142856,0,1066.8352269642855,49.304298287460085,4149.0323823946019,0]
["Céline",2027,"Céline 2027","2027-11-04",2527.4107142857133,0,null,0.2,3032.892857142856,1066.8352269642855,49.304298287460085,4149.0323823946019,null,null,0.24400000000000008,3144.0989285714277,111.2060714285717,1105.9525186196427,65.3913641320745,4315.4428113231443,111.2060714285717]
["Céline",2028,"Céline 2028","2028-11-04",2527.4107142857133,0,null,0.24,3133.9892857142845,1102.3964011964283,63.928903600745912,4300.3145905114588,null,null,0.25800000000000006,3179.4826785714276,45.493392857143135,1118.3989296008926,70.509975991724446,4368.3915841640446,45.493392857143135]
["Céline",2029,"Céline 2029","2029-11-04",2527.4107142857133,0,null,0.24,3133.9892857142845,1102.3964011964283,63.928903600745912,4300.3145905114588,505.48214285714266,101.09642857142853,0.27200000000000008,3133.9892857142845,0,1102.3964011964283,63.928903600745912,4300.3145905114588,0]
["Céline",2030,"Céline 2030","2030-11-04",2527.4107142857133,0,null,0.24,3133.9892857142845,1102.3964011964283,63.928903600745912,4300.3145905114588,null,null,0.28600000000000009,3250.2501785714276,116.26089285714306,1143.2917515633926,80.74719971102445,4474.2891298458444,116.26089285714306]
["Céline",2031]
["Céline","vide"]