{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Diag - Général et écosystème","Diag - RH","Diag - Modèle relationnel","Listes "],"not_rendered":{"images":1,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Diag - Général et écosystème","index":0,"n_rows":21,"n_cols":5,"rows_kept":21}
[]
[]
["Caractéristiques générales"]
["Nature de la structure juridique"]
["Date de création ou reprise de l'entreprise (format JJ/MM/AAAA)"]
["Nombre d'agents (y compris vous)",{"v":6,"d":"6 "}]
["Nombre de collaborateurs total \n(hormis vous et vos éventuels associés)",7]
["Nombre d’agences",5]
[]
[]
[null,"Code postal","Ville","Situation (zone urbaine, semi-urbaine, rurale, tertiaire ou quartier d'affaires)","ETP de collaborateurs par agence (hormis l'agent général)"]
["Agence 1",null,null,"Zone urbaine",3]
["Agence 2",null,null,"Zone tertiaire ou quartier d'affaires",2]
["Agence 3"]
["Agence 4"]
["Agence 5"]
["Agence 6"]
["Agence 7"]
["Agence 8"]
["Agence 9"]
["Agence 10"]

{"sheet":"Diag - RH","index":1,"n_rows":78,"n_cols":12,"rows_kept":78,"merged":[[42,0,42,1]]}
[]
[]
[]
["Descriptif des profils","Année de naissance","Fonction dans l'agence","Niveau dans la classification (classes 1 à 7)","Type de contrat (CDI, CDD, alternance)","Temps de travail (100%, 80%, 50%, etc.)","Ancienneté dans l’agence (en années)","Salaire brut fixe annuel","% de variable dans la rémunération ","Nombre de jour de formation année N-3","Nombre de jour de formation année N-2","Nombre de jour de formation année N-1"]
["Agent 1"]
["Agent 2"]
["Agent 3"]
["Agent 4"]
["Agent 5"]
["Agent 6"]
["Agent 7"]
["Agent 8"]
["Agent 9"]
["Agent 10"]
["Collaborateur 1",1988,"Commercial",4,"CDI",{"v":1,"d":"100%"},7,{"v":43700,"d":"43,700 €"},{"v":0.12,"d":"12%"},4,5,2]
["Collaborateur 2",1979,"Commercial",6,"CDI",{"v":1,"d":"100%"},14,{"v":56000,"d":"56,000 €"},{"v":0.15,"d":"15%"},4,4,2]
["Collaborateur 3",1996,"Assistant commercial",2,"Alternance",{"v":1,"d":"100%"},2,{"v":26000,"d":"26,000 €"},{"v":0.09,"d":"9%"},0,3,1]
["Collaborateur 4",1992,"Commercial",2,"CDI",{"v":1,"d":"100%"},3,{"v":32000,"d":"32,000 €"},{"v":0.1,"d":"10%"},1,2,1]
["Collaborateur 5"]
["Collaborateur 6"]
["Collaborateur 7"]
["Collaborateur 8"]
["Collaborateur 9"]
["Collaborateur 10"]
["Collaborateur 11"]
["Collaborateur 12"]
["Collaborateur 13"]
["Collaborateur 14"]
["Collaborateur 15"]
["Collaborateur 16"]
["Collaborateur 17"]
["Collaborateur 18"]
["Collaborateur 19"]
["Collaborateur 20"]
["Collaborateur 21"]
["Collaborateur 22"]
["Collaborateur 23"]
["Collaborateur 24"]
["Collaborateur 25"]
[]
[]
[]
[" Evaluer le niveau de chaque personnel de l'agence vous compris de 1 à 5 \n(1 pour manquante, 2 pour faible, 3 pour moyenne, 4 pour forte, 5 pour expert)",null,"A","B","C","D","E","F","G"]
["Agent 1","Niveau"]
["Agent 2","Niveau"]
["Agent 3","Niveau"]
["Agent 4","Niveau"]
["Agent 5","Niveau"]
["Agent 6","Niveau"]
["Agent 7","Niveau"]
["Agent 8","Niveau"]
["Agent 9","Niveau"]
["Agent 10","Niveau"]
["Collaborateur 1","Niveau",5,3,5,3,3,null,4]
["Collaborateur 2","Niveau",4,5,4,5,5,null,2]
["Collaborateur 3","Niveau",3,2,3,2,4,null,5]
["Collaborateur 4","Niveau",4,3,4,4,4,null,5]
["Collaborateur 5","Niveau"]
["Collaborateur 6","Niveau"]
["Collaborateur 7","Niveau"]
["Collaborateur 8","Niveau"]
["Collaborateur 9","Niveau"]
["Collaborateur 10","Niveau"]
["Collaborateur 11","Niveau"]
["Collaborateur 12","Niveau"]
["Collaborateur 13","Niveau"]
["Collaborateur 14","Niveau"]
["Collaborateur 15","Niveau"]
["Collaborateur 16","Niveau"]
["Collaborateur 17","Niveau"]
["Collaborateur 18","Niveau"]
["Collaborateur 19","Niveau"]
["Collaborateur 20","Niveau"]
["Collaborateur 21","Niveau"]
["Collaborateur 22","Niveau"]
["Collaborateur 23","Niveau"]
["Collaborateur 24","Niveau"]
["Collaborateur 25","Niveau"]

{"sheet":"Diag - Modèle relationnel","index":2,"n_rows":82,"n_cols":8,"rows_kept":82,"merged":[[44,0,45,0],[44,2,44,4]]}
[]
[]
[]
[null,"Répartir le temps de travail des collaborateurs à hauteur de leur temps disponible : 1 pour collaborateur à temps plein, 0,5 pour un collaborateur à mi temps)"]
[null,"Activité / Temps de travail (nombre d'ETP)","A","B","C","D","TOTAL "]
["Agent 1",{"v":1,"d":"1.00"},0.45,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},0.05,{"$f":"SUM(C6:F6)","v":{"v":1,"d":"100%"}}]
["Agent 2",{"v":0,"d":"0.00"}]
["Agent 3",{"v":0,"d":"0.00"}]
["Agent 4",{"v":0,"d":"0.00"}]
["Agent 5",{"v":0,"d":"0.00"}]
["Agent 6",{"v":0,"d":"0.00"}]
["Agent 7",{"v":0,"d":"0.00"}]
["Agent 8",{"v":0,"d":"0.00"}]
["Agent 9",{"v":0,"d":"0.00"}]
["Agent 10",{"v":0,"d":"0.00"}]
["Collaborateur 1",{"v":1,"d":"1.00"},0.33,0.55,{"v":0.1,"d":"0.10"},0.02,{"$f":"SUM(C16:F16)","v":{"v":1,"d":"100%"}}]
["Collaborateur 2",{"v":1,"d":"1.00"},0.45,{"v":0.4,"d":"0.40"},null,0.15,{"$f":"SUM(C17:F17)","v":{"v":1,"d":"100%"}}]
["Collaborateur 3",{"v":1,"d":"1.00"},{"v":0.4,"d":"0.40"},{"v":0.3,"d":"0.30"},0.15,0.15,{"$f":"SUM(C18:F18)","v":{"v":1,"d":"100%"}}]
["Collaborateur 4",{"v":0,"d":"0.00"},{"$nulls":4},{"$f":"SUM(C19:F19)","v":{"v":0,"d":"0%"}}]
["Collaborateur 5",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 6",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 7",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 8",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 9",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 10",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 11",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 12",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 13",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 14",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 15",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 16",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 17",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 18",{"v":0,"d":"0.00"},{"$nulls":4},{"$f":"SUM(C33:F33)","v":{"v":0,"d":"0%"}}]
["Collaborateur 19",{"v":0,"d":"0.00"},{"$nulls":4},{"$f":"SUM(C34:F34)","v":{"v":0,"d":"0%"}}]
["Collaborateur 20",{"v":0,"d":"0.00"},{"$nulls":4},{"$f":"SUM(C35:F35)","v":{"v":0,"d":"0%"}}]
["Collaborateur 21",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 22",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 23",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 24",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["Collaborateur 25",{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0%"}]
["TOTAL",{"$f":"SUM(B6:B40)","v":{"v":4,"d":"4.00"}},{"$nulls":4},{"$f":"SUM(C41:E41)","v":{"v":0,"d":"0%"}}]
[]
[]
[null,"Répartir le temps de travail des collaborateurs à hauteur de leur temps disponible : 1 pour collaborateur à temps plein, 0,5 pour un collaborateur à mi temps)"]
["Analyse des ETP en fonction de la modalité de réalisation","Lieu","Agence",null,null,"Terrain","Télétravail "]
[null,"Modalité","Back office","Accueil physique","Téléphone",null,null,"TOTAL "]
["Agent 1",{"v":1,"d":"1.00"},0.25,0.15,{"v":0.1,"d":"0.10"},{"v":0.5,"d":"0.50"},null,{"$f":"SUM(C47:G47)","v":{"v":1,"d":"100%"}}]
["Agent 2",{"v":0,"d":"0.00"}]
["Agent 3",{"v":0,"d":"0.00"}]
["Agent 4",{"v":0,"d":"0.00"}]
["Agent 5",{"v":0,"d":"0.00"}]
["Agent 6",{"v":0,"d":"0.00"}]
["Agent 7",{"v":0,"d":"0.00"}]
["Agent 8",{"v":0,"d":"0.00"}]
["Agent 9",{"v":0,"d":"0.00"}]
["Agent 10",{"v":0,"d":"0.00"}]
["Collaborateur 1",{"v":1,"d":"1.00"},{"v":0.3,"d":"0.30"},{"v":0.3,"d":"0.30"},{"v":0.4,"d":"0.40"},null,null,{"v":1,"d":"100%"}]
["Collaborateur 2",{"v":1,"d":"1.00"},{"v":0.5,"d":"0.50"},{"v":0.2,"d":"0.20"},{"v":0.3,"d":"0.30"},null,null,{"v":1,"d":"100%"}]
["Collaborateur 3",{"v":1,"d":"1.00"},{"v":0.2,"d":"0.20"},{"v":0.5,"d":"0.50"},{"v":0.3,"d":"0.30"},null,null,{"v":1,"d":"100%"}]
["Collaborateur 4",{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0%"}]
["Collaborateur 5",{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0%"}]
["Collaborateur 6",{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0%"}]
["Collaborateur 7",{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0%"}]
["Collaborateur 8",{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0%"}]
["Collaborateur 9",{"v":0,"d":"0.00"}]
["Collaborateur 10",{"v":0,"d":"0.00"}]
["Collaborateur 11",{"v":0,"d":"0.00"}]
["Collaborateur 12",{"v":0,"d":"0.00"}]
["Collaborateur 13",{"v":0,"d":"0.00"}]
["Collaborateur 14",{"v":0,"d":"0.00"}]
["Collaborateur 15",{"v":0,"d":"0.00"}]
["Collaborateur 16",{"v":0,"d":"0.00"}]
["Collaborateur 17",{"v":0,"d":"0.00"}]
["Collaborateur 18",{"v":0,"d":"0.00"}]
["Collaborateur 19",{"v":0,"d":"0.00"}]
["Collaborateur 20",{"v":0,"d":"0.00"}]
["Collaborateur 21",{"v":0,"d":"0.00"}]
["Collaborateur 22",{"v":0,"d":"0.00"}]
["Collaborateur 23",{"v":0,"d":"0.00"}]
["Collaborateur 24",{"v":0,"d":"0.00"}]
["Collaborateur 25",{"v":0,"d":"0.00"}]
["TOTAL",{"$f":"SUM(B47:B81)","v":{"v":4,"d":"4.00"}},{"$f":"SUM(C47:C66)","v":1.25},{"$f":"SUM(D47:D66)","v":1.15},{"$f":"SUM(E47:E66)","v":{"v":1.1,"d":"1.10"}},{"$f":"SUM(F47:F66)","v":{"v":0.5,"d":"0.50"}},{"$f":"SUM(G47:G66)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Listes ","index":3,"n_rows":52,"n_cols":11,"rows_kept":52}
[]
["Situation ",{"$nulls":3},"Type de contrat ",null,"Temps de travail",null,"Niveau (compétences)",null,"Classification "]
["Zone rurale",{"$nulls":3},"Alternance",null,{"v":1,"d":"100%"},null,1,null,1]
["Zone semi-urbaine",{"$nulls":3},"CDD",null,{"v":0.8,"d":"80%"},null,2,null,2]
["Zone urbaine",{"$nulls":3},"CDI",null,{"v":0.5,"d":"50%"},null,3,null,3]
["Zone tertiaire ou quartier d'affaires",{"$nulls":3},"Stage",null,"Autre",null,4,null,4]
[{"$nulls":8},5,null,5]
[{"$nulls":10},6]
[{"$nulls":10},7]
["Statut juridique entreprise",{"$nulls":5},"Tendance et projection"]
["Entreprise individuelle (EI)",{"$nulls":5},"En baisse"]
["Entreprise unipersonnelle à responsabilité limitée (EURL)",{"$nulls":5},"En hausse"]
["Société à responsabilité limitée (SARL)",{"$nulls":5},"Stable"]
["Société anonyme (SA)"]
["Société par actions simplifiée (SAS)"]
["Société en nom collectif (SNC)"]
["Société coopérative de production (SCOP)"]
[]
[]
["Nombre entreprises dont com > ou = 5% du CA total des agences",{"$nulls":5},"Activités réalisées par la société "]
[0]
[1,{"$nulls":5},"X"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[]
[]
[]
[]
["Echelle de 0 Pas du tout à 5 beaucoup",{"$nulls":3},"Réseaux sociaux"]
[0,{"$nulls":3},"Oui "]
[1,{"$nulls":3},"Non"]
[2]
[3]
[4]
[5]