{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Hausses salariales"],"not_rendered":{"defined_names":157},"read":"whole","date_system":"1900"}

{"sheet":"Hausses salariales","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"merged":[[1,1,2,6],[1,8,2,11],[4,8,6,8],[4,9,5,10],[4,11,6,11],[5,2,5,4],[6,2,6,4],[8,3,9,3],[8,4,8,5],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[]
[null,"Augmentations salariales annuelles prévues",{"$nulls":6},"Calcul du taux réel d'augmentation \ndes salaires sur l'année civile"]
[]
[]
[{"$nulls":8},"Période","Augmentations",null,"Indice \ndu mois "]
[null,null,"Augmentation générale totale prévue (AG)"]
[null,null,"Augmentation individuelle totale prévue (AI)",{"$nulls":6},"Générales","Individuelles"]
[{"$nulls":8},"Janvier",{"$f":"SUMIF($D$11:$D$14,\"=\"&I8,$E$11:$E$14)","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIF($D$11:$D$14,\"=\"&I8,$F$11:$F$14)","v":{"v":0,"d":"0.00%"}},{"$f":"(1+J8+K8)","v":{"v":1,"d":"1.00000"}}]
[{"$nulls":3},"Mois \nd'application","Augmentations",{"$nulls":3},"Février",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"$f":"L8*(1+J9+K9)","v":{"v":1,"d":"1.00000"}}]
[{"$nulls":4},"Générales","Individuelles",null,null,"Mars",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":8},"Avril",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":8},"Mai",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":8},"Juin",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":8},"Juillet",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":3},"Total",{"$f":"SUM(E11:E14)","v":{"v":0,"d":"0.00%"}},{"$f":"SUM(F11:F14)","v":{"v":0,"d":"0.00%"}},null,null,"Août",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":3},{"$f":"IF(OR(E16<>0,F16<>0),\"Ecart\",\" \")","v":" "},{"$f":"E15-F6","v":{"v":0,"d":"0.00%"}},{"$f":"F15-F7","v":{"v":0,"d":"0.00%"}},null,null,"Septembre",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":8},"Octobre",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":8},"Novembre",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":8},"Décembre",{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":1,"d":"1.00000"}]
[{"$nulls":8},"Total ",{"$f":"SUM(J8:J19)","v":{"v":0,"d":"0.00%"}},{"$f":"SUM(K8:K19)","v":{"v":0,"d":"0.00%"}},{"$f":"SUM(L8:L19)","v":{"v":12,"d":"12.00000"}}]
[]
[{"$nulls":10},"Taux réel",{"$f":"(GEOMEAN(L8:L19))-1","v":{"v":0,"d":"0.00%"}}]