{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["persp sal X grd secteur","perps cad X grd secteur","persp sal X taille","persp cad X taille","perps sal X dpt","persp cad X dpt","Mise à jour","Feuil15"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"persp sal X grd secteur","index":0,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[51,0,54,0],[7,0,10,0],[11,0,14,0],[15,0,18,0],[19,0,22,0],[23,0,26,0],[27,0,30,0],[31,0,34,0],[35,0,38,0],[39,0,42,0],[43,0,46,0],[47,0,50,0]]}
[{"$f":"\"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR \" &anneen2& \" PAR RÉGION\"","v":"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR 2017 PAR RÉGION"}]
["- LES PERSPECTIVES D'ÉVOLUTION  DES EFFECTIFS "]
[]
[{"$f":"\"Tableau X :  Perspectives d'évolution des effectifs salariés pour \" &anneen2& \" dans chaque région par grand secteur\"","v":"Tableau X :  Perspectives d'évolution des effectifs salariés pour 2017 dans chaque région par grand secteur"}]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Auvergne - Rhône-Alpes","Industrie",0.25,0.09,0.66]
[null,"Construction",0.13,7.0000000000000007E-2,0.8]
[null,"Commerce",0.15,0.09,0.76]
[null,"Services",0.19,0.1,0.71]
["Bourgogne - Franche-Comté","Industrie",0.18,0.11,0.71]
[null,"Construction",0.16,0.08,0.76]
[null,"Commerce",0.13,7.0000000000000007E-2,0.8]
[null,"Services",0.13,7.0000000000000007E-2,0.8]
["Bretagne","Industrie",0.22,0.11,0.67]
[null,"Construction",0.19,0.06,0.75]
[null,"Commerce",0.16,0.05,0.79]
[null,"Services",0.22,0.05,0.73]
["Centre-Val de Loire","Industrie",0.32,0.14000000000000001,0.54]
[null,"Construction",0.1,0.05,0.85]
[null,"Commerce",0.17,0.05,0.78]
[null,"Services",0.19,0.06,0.75]
["Grand Est","Industrie",0.21,0.16,0.63000000000000012]
[null,"Construction",0.18,0.04,0.78]
[null,"Commerce",0.11,0.09,0.8]
[null,"Services",0.17,0.1,0.73]
["Hauts-de-France","Industrie",0.15,0.16,0.69]
[null,"Construction",0.16,7.0000000000000007E-2,0.77]
[null,"Commerce",0.16,7.0000000000000007E-2,0.77]
[null,"Services",0.19,0.08,0.73]
["Ile-de-France","Industrie",0.2,0.1,0.7]
[null,"Construction",0.23,7.0000000000000007E-2,0.7]
[null,"Commerce",0.15,0.08,0.77]
[null,"Services",0.22,0.08,0.7]
["Normandie","Industrie",0.19,0.11,0.7]
[null,"Construction",0.12,0.04,0.84]
[null,"Commerce",0.14000000000000001,0.09,0.77]
[null,"Services",0.17,0.06,0.77]
["Nouvelle-Aquitaine","Industrie",0.19,0.11,0.7]
[null,"Construction",0.13,0.09,0.78]
[null,"Commerce",0.17,7.0000000000000007E-2,0.76]
[null,"Services",0.2,7.0000000000000007E-2,0.73]
["Occitanie","Industrie",0.2,0.11,0.69]
[null,"Construction",0.21,0.04,0.75]
[null,"Commerce",0.09,0.09,0.82]
[null,"Services",0.19,0.06,0.75]
["Pays de la Loire","Industrie",0.2,0.06,0.74]
[null,"Construction",0.18,0.08,0.74]
[null,"Commerce",0.17,0.08,0.75]
[null,"Services",0.23,0.06,0.71]
["Pacac","Industrie",0.14000000000000001,0.13,0.73]
[null,"Construction",0.23,0.08,0.69]
[null,"Commerce",0.14000000000000001,0.05,0.81]
[null,"Services",0.17,0.09,0.74]

{"sheet":"perps cad X grd secteur","index":1,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[51,0,54,0],[7,0,10,0],[11,0,14,0],[15,0,18,0],[19,0,22,0],[23,0,26,0],[27,0,30,0],[31,0,34,0],[35,0,38,0],[39,0,42,0],[43,0,46,0],[47,0,50,0]]}
[{"$f":"\"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR \" &anneen2& \" PAR RÉGION\"","v":"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR 2017 PAR RÉGION"}]
["- LES PERSPECTIVES D'ÉVOLUTION  DES EFFECTIFS "]
[]
[{"$f":"\"Tableau X :  Perspectives d'évolution des effectifs cadres pour \" &anneen2& \" dans chaque région par grand secteur\"","v":"Tableau X :  Perspectives d'évolution des effectifs cadres pour 2017 dans chaque région par grand secteur"}]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Auvergne - Rhône-Alpes","Industrie",0.11,0.05,0.84]
[null,"Construction",0.04,0.03,0.93]
[null,"Commerce",0.06,0.04,0.9]
[null,"Services",0.13,0.04,0.83]
["Bourgogne - Franche-Comté","Industrie",0.12,0.08,0.8]
[null,"Construction",0.04,0,0.96]
[null,"Commerce",0.06,0.04,0.9]
[null,"Services",7.0000000000000007E-2,0.05,0.88]
["Bretagne","Industrie",0.09,0.08,0.82999999999999985]
[null,"Construction",7.0000000000000007E-2,0.04,0.89]
[null,"Commerce",0.05,0.02,0.93]
[null,"Services",0.1,0.03,0.87]
["Centre-Val de Loire","Industrie",0.16,7.0000000000000007E-2,0.77]
[null,"Construction",0,0.03,0.97]
[null,"Commerce",0.08,0.04,0.88]
[null,"Services",0.08,0.04,0.88000000000000012]
["Grand Est","Industrie",0.13,0.04,0.83]
[null,"Construction",0.11,0.02,0.87]
[null,"Commerce",0.05,0.04,0.90999999999999992]
[null,"Services",0.09,7.0000000000000007E-2,0.84]
["Hauts-de-France","Industrie",0.11,0.08,0.81]
[null,"Construction",0.09,0.03,0.88]
[null,"Commerce",0.11,0.04,0.85]
[null,"Services",0.11,0.03,0.86]
["Ile-de-France","Industrie",0.13,0.05,0.82000000000000006]
[null,"Construction",0.15,0.04,0.81]
[null,"Commerce",0.09,0.05,0.86]
[null,"Services",0.16,0.05,0.79]
["Normandie","Industrie",0.11,0.06,0.83]
[null,"Construction",0.05,0,0.95]
[null,"Commerce",0.03,0.04,0.93]
[null,"Services",0.09,0.05,0.86]
["Nouvelle-Aquitaine","Industrie",0.12,0.08,0.8]
[null,"Construction",0.12,0.06,0.82]
[null,"Commerce",0.08,0.01,0.91]
[null,"Services",0.09,0.04,0.87]
["Occitanie","Industrie",0.09,0.06,0.85]
[null,"Construction",0.11,0.01,0.88]
[null,"Commerce",0.05,0.05,0.9]
[null,"Services",0.09,0.04,0.86999999999999988]
["Pays de la Loire","Industrie",0.1,0.04,0.86]
[null,"Construction",7.0000000000000007E-2,0.02,0.90999999999999992]
[null,"Commerce",0.05,0.06,0.89]
[null,"Services",0.09,0.04,0.87]
["Pacac","Industrie",0.09,0.11,0.8]
[null,"Construction",0.05,0.04,0.91]
[null,"Commerce",0.05,0.01,0.94]
[null,"Services",0.09,0.06,0.85]

{"sheet":"persp sal X taille","index":2,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR \" &anneen2& \" PAR RÉGION\"","v":"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR 2017 PAR RÉGION"}]
["- LES PERSPECTIVES D'ÉVOLUTION  DES EFFECTIFS "]
[]
[{"$f":"\"Tableau X :  Perspectives d'évolution des effectifs salariés pour \" &anneen2& \" dans chaque région par taille\"","v":"Tableau X :  Perspectives d'évolution des effectifs salariés pour 2017 dans chaque région par taille"}]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Auvergne - Rhône-Alpes","moins de 50 salariés",0.16,7.0000000000000007E-2,0.77]
[null,"de 50 à 99 salariés",0.22,0.14000000000000001,0.64]
[null,"de 100 à 199 salariés",0.26,0.05,0.69]
[null,"de 200 à 499 salariés",0.26,0.13,0.61]
[null,"500 salariés et plus",0.19,0.26,0.55000000000000004]
["Bourgogne - Franche-Comté","moins de 50 salariés",0.13,7.0000000000000007E-2,0.8]
[null,"de 50 à 199 salariés",0.19,0.1,0.71]
[null,"200 salariés et plus",0.17,0.17,0.66]
["Bretagne","moins de 50 salariés",0.17,0.05,0.78]
[null,"de 50 à 199 salariés",0.26,7.0000000000000007E-2,0.67]
[null,"200 salariés et plus",0.25,0.12,0.63]
["Centre-Val de Loire","moins de 50 salariés",0.16,0.06,0.78]
[null,"de 50 à 199 salariés",0.27,0.08,0.65]
[null,"200 salariés et plus",0.28999999999999998,0.13,0.57999999999999996]
["Grand Est","moins de 50 salariés",0.15,7.0000000000000007E-2,0.78]
[null,"de 50 à 99 salariés",0.2,7.0000000000000007E-2,0.73]
[null,"de 100 à 199 salariés",0.16,0.16,0.68]
[null,"de 200 à 499 salariés",0.24,0.13,0.63]
[null,"500 salariés et plus",0.12,0.51,0.37]
["Hauts-de-France","moins de 50 salariés",0.16,0.09,0.75]
[null,"de 50 à 99 salariés",0.16,0.08,0.76]
[null,"de 100 à 199 salariés",0.2,0.1,0.7]
[null,"200 salariés et plus",0.21,0.13,0.66]
["Ile-de-France","moins de 50 salariés",0.17,7.0000000000000007E-2,0.76]
[null,"de 50 à 99 salariés",0.25,0.06,0.69]
[null,"de 100 à 199 salariés",0.22,0.09,0.69]
[null,"de 200 à 499 salariés",0.23,0.11,0.66]
[null,"500 salariés et plus",0.39,0.21,0.4]
["Normandie","moins de 50 salariés",0.14000000000000001,0.08,0.78]
[null,"de 50 à 199 salariés",0.19,7.0000000000000007E-2,0.74]
[null,"200 salariés et plus",0.21,0.09,0.7]
["Nouvelle-Aquitaine","moins de 50 salariés",0.16,7.0000000000000007E-2,0.77]
[null,"de 50 à 199 salariés",0.21,0.11,0.68]
[null,"200 salariés et plus",0.25,0.08,0.67]
["Occitanie","moins de 50 salariés",0.15,7.0000000000000007E-2,0.78]
[null,"de 50 à 99 salariés",0.19,0.05,0.76]
[null,"de 100 à 199 salariés",0.27,7.0000000000000007E-2,0.66]
[null,"200 salariés et plus",0.21,0.11,0.68]
["Pays de la Loire","moins de 50 salariés",0.16,0.06,0.78]
[null,"de 50 à 99 salariés",0.22,0.1,0.68]
[null,"de 100 à 199 salariés",0.25,0.05,0.7]
[null,"de 200 à 499 salariés",0.27,0.09,0.64]
[null,"500 salariés et plus",0.26,0.06,0.68]
["Pacac","moins de 50 salariés",0.16,0.06,0.78]
[null,"de 50 à 199 salariés",0.18,0.1,0.72]
[null,"200 salariés et plus",0.19,0.16,0.65]

{"sheet":"persp cad X taille","index":3,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR \" &anneen2& \" PAR RÉGION\"","v":"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR 2017 PAR RÉGION"}]
["- LES PERSPECTIVES D'ÉVOLUTION  DES EFFECTIFS "]
[]
[{"$f":"\"Tableau X :  Perspectives d'évolution des effectifs cadres pour \" &anneen2& \" dans chaque région par taille\"","v":"Tableau X :  Perspectives d'évolution des effectifs cadres pour 2017 dans chaque région par taille"}]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Auvergne - Rhône-Alpes","moins de 50 salariés",7.0000000000000007E-2,0.03,0.9]
[null,"de 50 à 99 salariés",0.13,0.04,0.83]
[null,"de 100 à 199 salariés",0.15,0.05,0.8]
[null,"de 200 à 499 salariés",0.19,0.05,0.76]
[null,"500 salariés et plus",0.17,0.19,0.64]
["Bourgogne - Franche-Comté","moins de 50 salariés",0.06,0.03,0.91]
[null,"de 50 à 199 salariés",0.13,0.05,0.82]
[null,"200 salariés et plus",0.1,0.15,0.75]
["Bretagne","moins de 50 salariés",0.04,0.03,0.93]
[null,"de 50 à 199 salariés",0.13,0.06,0.81]
[null,"200 salariés et plus",0.16,0.04,0.8]
["Centre-Val de Loire","moins de 50 salariés",0.06,0.03,0.91]
[null,"de 50 à 199 salariés",0.11,0.05,0.84]
[null,"200 salariés et plus",0.19,0.09,0.72]
["Grand Est","moins de 50 salariés",0.06,0.04,0.9]
[null,"de 50 à 99 salariés",0.15,0.05,0.8]
[null,"de 100 à 199 salariés",0.08,7.0000000000000007E-2,0.85]
[null,"de 200 à 499 salariés",0.2,0.04,0.76]
[null,"500 salariés et plus",7.0000000000000007E-2,0.22,0.71]
["Hauts-de-France","moins de 50 salariés",0.06,0.05,0.89]
[null,"de 50 à 99 salariés",0.12,0.05,0.83]
[null,"de 100 à 199 salariés",0.17,0.06,0.77]
[null,"200 salariés et plus",0.19,0.03,0.78]
["Ile-de-France","moins de 50 salariés",0.11,0.05,0.84]
[null,"de 50 à 99 salariés",0.2,0.04,0.76]
[null,"de 100 à 199 salariés",0.13,0.05,0.82]
[null,"de 200 à 499 salariés",0.18,0.06,0.76]
[null,"500 salariés et plus",0.32,0.1,0.57999999999999996]
["Normandie","moins de 50 salariés",0.06,0.03,0.91]
[null,"de 50 à 199 salariés",0.11,0.05,0.84]
[null,"200 salariés et plus",0.19,0.09,0.72]
["Nouvelle-Aquitaine","moins de 50 salariés",7.0000000000000007E-2,0.04,0.89]
[null,"de 50 à 199 salariés",0.15,0.06,0.79]
[null,"200 salariés et plus",0.14000000000000001,0.04,0.82]
["Occitanie","moins de 50 salariés",0.06,0.04,0.9]
[null,"de 50 à 99 salariés",0.13,0.05,0.82]
[null,"de 100 à 199 salariés",0.17,0.01,0.82]
[null,"200 salariés et plus",0.11,0.05,0.84]
["Pays de la Loire","moins de 50 salariés",0.04,0.05,0.91]
[null,"de 50 à 99 salariés",0.08,0.05,0.87]
[null,"de 100 à 199 salariés",0.17,0.01,0.82]
[null,"de 200 à 499 salariés",0.1,0.05,0.85]
[null,"500 salariés et plus",0.23,0,0.77]
["Pacac","moins de 50 salariés",0.06,0.04,0.9]
[null,"de 50 à 199 salariés",0.1,0.09,0.81]
[null,"200 salariés et plus",0.14000000000000001,0.06,0.8]

{"sheet":"perps sal X dpt","index":4,"n_rows":110,"n_cols":5,"rows_kept":110,"cut":false,"hidden":false,"merged":[[98,0,101,0],[105,0,109,0],[80,0,87,0],[62,0,69,0],[54,0,58,0],[73,0,76,0],[91,0,94,0],[43,0,50,0],[21,0,25,0],[29,0,32,0],[36,0,39,0],[9,0,16,0]]}
[{"$f":"\"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR \" &anneen2& \" PAR RÉGION\"","v":"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR 2017 PAR RÉGION"}]
["- LES PERSPECTIVES D'ÉVOLUTION  DES EFFECTIFS "]
[]
[{"$f":"\"Tableau X :  Perspectives d'évolution des effectifs salariés pour \" &anneen2& \" dans chaque région par département\"","v":"Tableau X :  Perspectives d'évolution des effectifs salariés pour 2017 dans chaque région par département"}]
[]
[]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Auvergne - Rhône-Alpes","Loire (42) + Haute-Loire (43)",0.16352201257861637,9.4339622641509441E-2,0.74213836477987427]
[null,"Allier(03) + Cantal (15) + Puy-de-Dôme (63)",0.16129032258064516,0.10138248847926266,0.73732718894009208]
[null,"Ardèche (07) + Drôme (26)",0.15079365079365079,7.1428571428571438E-2,0.77777777777777768]
[null,"Ain (01)",0.14285714285714288,0.1326530612244898,0.72448979591836737]
[null,"Isère (38)",0.25423728813559321,7.9096045197740106E-2,0.66666666666666674]
[null,"Rhône (69)",0.20317460317460317,9.5238095238095233E-2,0.70158730158730165]
[null,"Savoie (73)",0.22340425531914893,7.4468085106382975E-2,0.7021276595744681]
[null,"Haute-Savoie (74)",0.22549019607843138,9.8039215686274522E-2,0.67647058823529405]
[]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Bourgogne - Franche-Comté","Côte-dOr (21)",0.14285714285714288,5.8441558441558447E-2,0.79870129870129869]
[null,"Nièvre (58) + Yonne (89)",0.10256410256410257,0.1111111111111111,0.78632478632478642]
[null,"Saône-et-Loire (71)",0.13636363636363635,7.575757575757576E-2,0.78787878787878785]
[null,"Haute-Saone (70) + Territoire de Belfort (90)",0.17857142857142858,8.3333333333333343E-2,0.73809523809523814]
[null,"Jura (25) + Doubs (39)",0.1807909604519774,0.10734463276836158,0.71186440677966101]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Bretagne","Côtes-d'Armor (22)",0.2,3.5294117647058823E-2,0.76470588235294112]
[null,"Finistère (29)",0.24031007751937986,6.2015503875968998E-2,0.69767441860465107]
[null,"Ille-et-Vilaine (35)",0.20118343195266275,5.9171597633136092E-2,0.73964497041420119]
[null,"Morbihan (56)",0.17431192660550457,9.1743119266055051E-2,0.73394495412844041]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Centre-Val de Loire","Cher (18) + Indre (36)",0.25287356321839083,3.4482758620689655E-2,0.71264367816091945]
[null," Loir-et-Cher (41) + Loiret (45)",0.21764705882352942,7.6470588235294124E-2,0.70588235294117652]
[null,"Eure-et-Loir (28)",0.14754098360655737,8.1967213114754092E-2,0.77049180327868849]
[null,"Indre-et-Loire (37)",0.20792079207920794,0.10891089108910892,0.68316831683168322]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Grand-Est","Bas-Rhin (67)",0.18220338983050849,0.1059322033898305,0.71186440677966101]
[null,"Haut-Rhin (68)",0.14473684210526316,5.9210526315789477E-2,0.79605263157894735]
[null,"Marne (51)",0.18604651162790697,0.13953488372093023,0.67441860465116277]
[null,"Meurthre-et-Moselle (54)",0.16528925619834708,0.10743801652892562,0.72727272727272729]
[null,"Moselle (57)",0.17419354838709677,0.1032258064516129,0.72258064516129039]
[null,"Meuse (55) + Ardennes (08)",0.15492957746478875,0.11267605633802816,0.73239436619718301]
[null,"Haute-Marne (52) + Aube (10)",0.14736842105263157,0.1368421052631579,0.71578947368421053]
[null,"Vosges (88)",0.17073170731707318,0.10975609756097562,0.71951219512195119]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Hauts-de-France","Aisne (02)",0.1326530612244898,7.1428571428571438E-2,0.79591836734693866]
[null,"Nord (59)",0.21256038647342992,8.212560386473429E-2,0.70531400966183566]
[null,"Oise (60)",0.13953488372093023,0.10852713178294573,0.75193798449612403]
[null,"Pas-de-Calais (62)",0.12727272727272726,0.12121212121212122,0.75151515151515158]
[null,"Somme (80)",0.16822429906542055,0.13084112149532712,0.7009345794392523]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Ile de France","Paris (75)",0.20664206642066421,7.9335793357933573E-2,0.71402214022140231]
[null,"Seine-et-Marne (77)",0.20089285714285715,8.0357142857142863E-2,0.71875]
[null,"Yvelines (78)",0.16666666666666669,7.407407407407407E-2,0.75925925925925919]
[null,"Essonne (91)",0.21472392638036808,6.7484662576687116E-2,0.71779141104294486]
[null,"Hauts-de-Seine (92)",0.27659574468085107,6.0283687943262408E-2,0.66312056737588643]
[null,"Seine-Saint-Denis (93)",0.1464968152866242,0.17197452229299362,0.68152866242038213]
[null,"Val-de-Marne (94)",0.18831168831168832,7.792207792207792E-2,0.73376623376623373]
[null,"Val-d'Oise (95)",0.17751479289940827,7.1005917159763315E-2,0.75147928994082847]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Normandie","Orne (61) + Eure (27)",0.17777777777777778,5.9259259259259255E-2,0.76296296296296295]
[null,"Calvados (14)",0.23931623931623933,0.10256410256410257,0.658119658119658]
[null,"Manche (50)",0.13402061855670103,4.1237113402061848E-2,0.82474226804123718]
[null,"Seine-Maritime (76)",0.1388888888888889,8.7301587301587297E-2,0.77380952380952384]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Nouvelle-Aquitaine ","Lot-et-Garonne (47) + Landes (40)",0.12903225806451613,7.5268817204301078E-2,0.79569892473118276]
[null,"Gironde (33)",0.24311926605504589,5.9633027522935783E-2,0.69724770642201828]
[null,"Deux-Sèvres (79)",0.2162162162162162,5.405405405405405E-2,0.72972972972972971]
[null,"Pyrénées Atlantiques (64)",0.20535714285714285,0.1517857142857143,0.6428571428571429]
[null,"Correze (19) + Dordogne (24)",0.15966386554621848,6.7226890756302518E-2,0.77310924369747891]
[null,"Creuse (23) + Haute-Vienne (87)",0.11009174311926605,4.5871559633027525E-2,0.84403669724770636]
[null,"Charente (16) + Charente-Maritime (17)",0.15950920245398773,9.815950920245399E-2,0.74233128834355822]
[null," Vienne (86)",0.19178082191780821,0.1095890410958904,0.69863013698630139]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Occitanie","Aude (11) + Lozère (48) + Pyrénées Orientales (66)",0.13768115942028986,7.9710144927536225E-2,0.78260869565217395]
[null,"Gard (30) + Hérault (34)",0.185,0.05,0.76500000000000001]
[null,"Ariège (9) + Aveyron (12) + Gers (32)+ Lot (46) + Hautes-Pyrénées (65) + Tarn (81) + Tarn-et-Garonne (82)",0.13333333333333333,7.0588235294117646E-2,0.79607843137254908]
[null,"Haute-Garonne (31)",0.23766816143497757,8.9686098654708515E-2,0.67264573991031384]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Pays de la Loire"," Mayenne (53) + Sarthe (72)",0.21264367816091956,8.6206896551724144E-2,0.70114942528735624]
[null,"Loire-Atlantique (44)",0.2570093457943925,7.476635514018691E-2,0.66822429906542058]
[null,"Maine-et-Loire (49)",0.13194444444444445,5.5555555555555552E-2,0.8125]
[null,"Vendée (85)",0.17431192660550457,3.669724770642202E-2,0.78899082568807344]
[]
[]
[null,null,"Croissance de l'effectif salarié","Réduction de l'effectif salarié","Stabilité de l'effectif salarié"]
["Provence Alpes Côte d'Azur et Corse","Alpes de Haute-Provence (4) +Hautes-Alpes (5) + Corse (20)",0.16,5.333333333333333E-2,0.78666666666666674]
[null,"Alpes-Maritimes (06)",0.15642458100558659,0.1005586592178771,0.74301675977653625]
[null,"Bouches-du-Rhône (13)",0.18250950570342206,8.3650190114068435E-2,0.73384030418250945]
[null,"Var (83)",0.13,7.0000000000000007E-2,0.8]
[null,"Vaucluse (84)",0.18292682926829268,9.7560975609756101E-2,0.71951219512195119]

{"sheet":"persp cad X dpt","index":5,"n_rows":110,"n_cols":5,"rows_kept":110,"cut":false,"hidden":false,"merged":[[9,0,16,0],[91,0,94,0],[98,0,101,0],[105,0,109,0],[21,0,25,0],[29,0,32,0],[36,0,39,0],[43,0,50,0],[54,0,58,0],[62,0,69,0],[73,0,76,0],[80,0,87,0]]}
[{"$f":"\"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR \" &anneen2& \" PAR RÉGION\"","v":"LES RECRUTEMENTS PRÉVUS ET PERSPECTIVES POUR 2017 PAR RÉGION"}]
["- LES PERSPECTIVES D'ÉVOLUTION  DES EFFECTIFS "]
[]
[{"$f":"\"Tableau X :  Perspectives d'évolution des effectifs cadres pour \" &anneen2& \" dans chaque région par département\"","v":"Tableau X :  Perspectives d'évolution des effectifs cadres pour 2017 dans chaque région par département"}]
[]
[]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Auvergne - Rhône-Alpes","Loire (42) + Haute-Loire (43)",8.8050314465408799E-2,1.8867924528301886E-2,0.89308176100628922]
[null,"Allier(03) + Cantal (15) + Puy-de-Dôme (63)",8.294930875576037E-2,2.3041474654377878E-2,0.89400921658986177]
[null,"Ardèche (07) + Drôme (26)",4.7619047619047616E-2,4.7619047619047616E-2,0.90476190476190477]
[null,"Ain (01)",6.1224489795918366E-2,7.1428571428571438E-2,0.86734693877551028]
[null,"Isère (38)",0.13559322033898305,6.2146892655367235E-2,0.80225988700564965]
[null,"Rhône (69)",0.1492063492063492,4.4444444444444446E-2,0.80634920634920637]
[null,"Savoie (73)",8.5106382978723402E-2,4.2553191489361701E-2,0.87234042553191482]
[null,"Haute-Savoie (74)",7.8431372549019607E-2,1.9607843137254902E-2,0.90196078431372551]
[]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Bourgogne - Franche-Comté","Côte-dOr (21)",0.1103896103896104,4.5454545454545456E-2,0.84415584415584421]
[null,"Nièvre (58) + Yonne (89)",5.9829059829059832E-2,5.1282051282051287E-2,0.88888888888888884]
[null,"Saône-et-Loire (71)",8.3333333333333343E-2,6.8181818181818177E-2,0.8484848484848484]
[null,"Haute-Saone (70) + Territoire de Belfort (90)",4.7619047619047616E-2,5.9523809523809527E-2,0.8928571428571429]
[null,"Jura (25) + Doubs (39)",9.6045197740112997E-2,3.9548022598870053E-2,0.86440677966101687]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Bretagne","Côtes-d'Armor (22)",7.0588235294117646E-2,4.7058823529411764E-2,0.88235294117647056]
[null,"Finistère (29)",0.10852713178294573,4.6511627906976744E-2,0.84496124031007758]
[null,"Ille-et-Vilaine (35)",9.4674556213017749E-2,2.3668639053254437E-2,0.88165680473372787]
[null,"Morbihan (56)",5.5045871559633024E-2,4.5871559633027525E-2,0.89908256880733939]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Centre-Val de Loire","Cher (18) + Indre (36)",9.1954022988505746E-2,1.1494252873563218E-2,0.89655172413793105]
[null," Loir-et-Cher (41) + Loiret (45)",0.12941176470588237,6.4705882352941183E-2,0.80588235294117649]
[null,"Eure-et-Loir (28)",4.9180327868852458E-2,1.6393442622950821E-2,0.93442622950819665]
[null,"Indre-et-Loire (37)",5.9405940594059403E-2,5.9405940594059403E-2,0.88118811881188119]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Grand-Est","Bas-Rhin (67)",0.13135593220338981,5.9322033898305086E-2,0.80932203389830504]
[null,"Haut-Rhin (68)",0.1118421052631579,3.2894736842105261E-2,0.85526315789473684]
[null,"Marne (51)",3.1007751937984499E-2,6.9767441860465115E-2,0.89922480620155043]
[null,"Meurthre-et-Moselle (54)",0.11570247933884298,5.7851239669421489E-2,0.82644628099173556]
[null,"Moselle (57)",0.1096774193548387,4.5161290322580649E-2,0.84516129032258069]
[null,"Meuse (55) + Ardennes (08)",4.2253521126760563E-2,4.2253521126760563E-2,0.91549295774647887]
[null,"Haute-Marne (52) + Aube (10)",6.3157894736842107E-2,7.3684210526315783E-2,0.86315789473684201]
[null,"Vosges (88)",8.5365853658536592E-2,3.6585365853658541E-2,0.87804878048780499]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Hauts-de-France","Aisne (02)",6.1224489795918366E-2,2.0408163265306124E-2,0.91836734693877542]
[null,"Nord (59)",0.13285024154589373,5.0724637681159424E-2,0.81642512077294682]
[null,"Oise (60)",0.124031007751938,1.550387596899225E-2,0.86046511627906985]
[null,"Pas-de-Calais (62)",6.6666666666666666E-2,3.6363636363636362E-2,0.89696969696969697]
[null,"Somme (80)",8.4112149532710276E-2,9.3457943925233641E-2,0.82242990654205617]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Ile de France","Paris (75)",0.16051660516605168,4.9815498154981548E-2,0.78966789667896675]
[null,"Seine-et-Marne (77)",9.375E-2,4.0178571428571432E-2,0.8660714285714286]
[null,"Yvelines (78)",0.11728395061728396,4.9382716049382713E-2,0.83333333333333326]
[null,"Essonne (91)",0.12883435582822086,4.9079754601226995E-2,0.82208588957055218]
[null,"Hauts-de-Seine (92)",0.21276595744680851,4.6099290780141848E-2,0.74113475177304966]
[null,"Seine-Saint-Denis (93)",8.9171974522292988E-2,7.6433121019108277E-2,0.83439490445859876]
[null,"Val-de-Marne (94)",0.15584415584415584,7.792207792207792E-2,0.76623376623376627]
[null,"Val-d'Oise (95)",8.8757396449704137E-2,4.1420118343195263E-2,0.86982248520710059]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Normandie","Orne (61) + Eure (27)",8.1481481481481488E-2,5.9259259259259255E-2,0.85925925925925928]
[null,"Calvados (14)",0.11965811965811966,5.9829059829059832E-2,0.8205128205128206]
[null,"Manche (50)",6.1855670103092786E-2,2.0618556701030924E-2,0.91752577319587625]
[null,"Seine-Maritime (76)",7.5396825396825393E-2,3.968253968253968E-2,0.88492063492063489]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Nouvelle-Aquitaine ","Lot-et-Garonne (47) + Landes (40)",6.4516129032258063E-2,5.3763440860215048E-2,0.88172043010752688]
[null,"Gironde (33)",0.12385321100917432,5.9633027522935783E-2,0.8165137614678899]
[null,"Deux-Sèvres (79)",0.13513513513513514,4.0540540540540543E-2,0.82432432432432434]
[null,"Pyrénées Atlantiques (64)",8.9285714285714288E-2,6.25E-2,0.8482142857142857]
[null,"Correze (19) + Dordogne (24)",7.5630252100840331E-2,3.3613445378151259E-2,0.89075630252100835]
[null,"Creuse (23) + Haute-Vienne (87)",0.10091743119266056,2.7522935779816512E-2,0.87155963302752293]
[null,"Charente (16) + Charente-Maritime (17)",8.5889570552147243E-2,3.6809815950920248E-2,0.87730061349693256]
[null," Vienne (86)",0.12328767123287671,5.4794520547945202E-2,0.82191780821917804]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Occitanie","Aude (11) + Lozère (48) + Pyrénées Orientales (66)",7.2463768115942032E-2,5.0724637681159424E-2,0.87681159420289856]
[null,"Gard (30) + Hérault (34)",0.09,5.0000000000000001E-3,0.90500000000000003]
[null,"Ariège (9) + Aveyron (12) + Gers (32)+ Lot (46) + Hautes-Pyrénées (65) + Tarn (81) + Tarn-et-Garonne (82)",6.6666666666666666E-2,5.8823529411764712E-2,0.87450980392156863]
[null,"Haute-Garonne (31)",0.11659192825112108,5.3811659192825115E-2,0.82959641255605376]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Pays de la Loire"," Mayenne (53) + Sarthe (72)",8.0459770114942528E-2,5.7471264367816091E-2,0.86206896551724144]
[null,"Loire-Atlantique (44)",0.10280373831775702,4.6728971962616821E-2,0.85046728971962626]
[null,"Maine-et-Loire (49)",6.25E-2,2.0833333333333336E-2,0.91666666666666674]
[null,"Vendée (85)",8.2568807339449532E-2,2.7522935779816512E-2,0.88990825688073405]
[]
[]
[null,null,"Croissance de l'effectif cadre","Réduction de l'effectif cadre","Stabilité de l'effectif cadre"]
["Provence Alpes Côte d'Azur et Corse","Alpes de Haute-Provence (4) +Hautes-Alpes (5) + Corse (20)",0.12,1.3333333333333332E-2,0.8666666666666667]
[null,"Alpes-Maritimes (06)",9.4972067039106156E-2,3.9106145251396648E-2,0.86592178770949713]
[null,"Bouches-du-Rhône (13)",6.4638783269961975E-2,6.8441064638783272E-2,0.86692015209125473]
[null,"Var (83)",7.0000000000000007E-2,0.06,0.87]
[null,"Vaucluse (84)",4.878048780487805E-2,7.3170731707317083E-2,0.87804878048780499]

{"sheet":"Mise à jour","index":6,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,"La Macro_région permet de passer en revue tous les résultats nécessaires à l'anlayse des régions (bilan, perspectives, prévisions)"]
[]
[]
[]
[]
[null,null,null,null,"La Macro-arrondis permet de gérer les évolutions d'une année sur l'autre, les epsilons, les volumes par régions ainsi que la somme des parts qui doit être égale à 100 (niveau d'expérience, fonction…)"]
[]
[]
[]
[null,null,null,null,"La Macro_supprime permet le nettoyage du fichier"]
[]
[]
[]
[null,null,null,null,"La Macro_version_finale permet le passage de la version complétée à la version finale "]
[]
[]
[]
[]
["N.B : les onglets en rouge comportent des formules Excel. "]

{"sheet":"Feuil15","index":7,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[2015]
[2016]
[2017]