{"text_format":"2","workbook":"xlsx","n_sheets":18,"sheets":["EP","EP - TS","OFII - Accueil","OFII - Accueil - TS","OFII - Audit","OFII - Audit dév.","OFII - Audit - TS","OFII - Audit - TS dév.","PP","PP - TS","Coord.","Coord. - TS","ITI","ITI - TS","SecFLE","SecFLE - TS","SRI","SRI - TS"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"EP","index":0,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Ecrivain public"]
[null,"Aman","Anicham","Chellamani 01","Chellamani 02","Chellamani 03","Chellamani 04","Ikram","Meimouna","Prithviraj","Rahifa","Shamina"]
["Salutations verbales",null,"ü",null,"ü",{"$nulls":4},"ü"]
["Commentaire sur la langue de communication",{"$nulls":10},"ü"]
[]
["Transaction de service 1","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Transaction de service 2",null,"ü","ü","ü","ü",null,null,null,"ü",null,"ü"]
["Transaction de service 3",null,null,null,"ü","ü"]
[]
["Remerciement","ü","ü","ü","ü","ü",null,"ü","ü","ü","ü","ü"]
["Salutations","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Souhait",null,null,null,"ü",null,null,null,"ü",null,"ü"]
["Rendez-vous prochain",null,null,null,"ü"]
[]
["+  attention sur l'enregistrement",{"$nulls":6},"ü","ü"]
["+ transaction intermédiaire ou parallèle",null,null,"ü","ü","ü"]
[null,null,null,"téléphone à l'assurance","téléphone à l'assurance et au garage","téléphone à des permanences juridiques"]
["+ bavardage",null,null,"ü",{"$nulls":4},"ü",null,"ü","ü"]

{"sheet":"EP - TS","index":1,"n_rows":11,"n_cols":22,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Ecrivain public","Aman","Anicham","Anicham","Chellamani 01","Chellamani 01","Chellamani 02","Chellamani 02","Chellamani 02","Chellamani 02","Chellamani 03","Chellamani 03","Chellamani 03","Chellamani 04","Chellamani 04","Ikram","Meimouna","Prithviraj","Prithviraj","Rahifa","Shamina","Shamina"]
[null,"Transaction 1","Transaction 1","Transaction 2","Transaction 1","Transaction 2","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 1","Transaction 2","Transaction 3","Transaction 1","Transaction 2","Transaction 1","Transaction 1","Transaction 1","Transaction 2","Transaction 1","Transaction 1","Transaction 2"]
["Verbalisation par l'usager","ü","ü","ü","ü","ü","ü","ü","ü",null,"ü","ü","ü",null,null,null,"ü","ü","ü","ü","ü"]
["Objectif proposé","écriture d'une demande de copie d'acte de mariage au ministère des affaires étrangères","complétion d'une demande d'allocations familiales","écriture d'une demande d'acte de naissance pour le mari et les enfants pour renouveler leur carte d'identité","déclaration  d'un incendie de voiture à l'assurance par courrier","écriture d'une lettre à l'OPAC, proposition de report","complétion d'un formulaire de déclaration d'accident pour l'assurance (voiture incendiée)","mise en contact de l'assureur et du garagiste (l'expert de l'assurance a besoin de la carte grise qu'a le garagiste, l'usager a besoin de signer le certificat de cession pour récupérer la CG, l'usager veut une expertise avant de signer le certificat)","lecture et appropriation d'un courrier de la C.M.U. (chèque d'aide pour payer une mutuelle après l'arrêt de la C.M.U. pour augmentation des revenus)","répondre au courrier de l'OPAC","contestation de la proposition de rachat de la voiture (épave) ou demande d'indemnisation par la responsable de l'incendie","réponse à un courrier de la permanence sociale, rappel de la situation","questions sur le fonctionnement du chèque d'aide à l'adhésion à une mutuelle envoyé par la sécurité sociale","envoi des documents demandés à l'assurance de la responsable de l'incendie","écriture d'un rappel de situation pour accélérer la réponse de l'interlocutrice","conseils sur les démarches à mettre en place en réaction à un courrier du Pôle Emploi (TS en cours de renouvellement)","déclaration aux impôts qu'un membre de la famille du mari n'habite pas à son adresse","écriture d'un courrier à la   caisse de retraite complémentaire pour l'informer de l'état des revenus d'une personne hospitalisée","lecture et appropriation d'un courrier de l'hôpital informant que la mutuelle refusait de prendre en charge les deux 1e mois d'hospitalisation","écriture d'une lettre de motivation pour s'inscrire à un stage linguistique professionnalisant","écriture d'une négociation du montant et des modalités de paiement d'une facture","tronqué"]
["Exposition de la situation-problème / Construction du dossier mental","ü","ü","ü","ü",null,"ü","ü","ü",null,"ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Réalisation de l'objectif","ü","ü","ü","ü",null,"ü","ü","ü",null,null,null,"ü","ü","refus","ü","ü","ü","ü","ü"]
["Redéfinition de ",{"$nulls":9},"ü","ü",{"$nulls":8},"ü"]
["l'objectif avec l'agent",{"$nulls":4},"report accepté",null,null,null,"reportée","conseil d'obtention d'un conseil spécialisé pour savoir s'il est avantageux de porter plainte contre la responsable et prise de RDV avec un juriste avant le délai de la proposition de rachat","réponse stricte à la demande du courrier, information sur le numéro de téléphone portable de l'usager",{"$nulls":8},"contestation de la facture (pas de devis, pas d'accord)"]
["Réalisation de l'objectif redéfini",null,null,"ü",{"$nulls":6},"ü","ü",{"$nulls":8},"ü"]
["Co-construction des attentes pour l'objectif au-delà de la rencontre","ü","ü","ü",null,null,null,"ü","ü",null,"ü","ü","ü","ü",null,"ü","ü","ü","ü","ü","ü","ü"]
["Clôture de la réalisation complète","ü","ü","ü","ü",null,null,"ü","ü",null,null,null,"ü","ü",null,"ü","ü","ü","ü","ü","tronqué"]

{"sheet":"OFII - Accueil","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Office de l'immigration - Accueil"]
[null,"Glaiza","Hai","Jimena","Ksaunich","Lian","Loussig","Nadezhda","Nancy","Sali","Vicente","Wan"]
["Gestion de la file d'attente","ü",null,"ü","ü",{"$nulls":5},"ü"]
["Recherche de l'agent adéquat",{"$nulls":7},"ü"]
["Salutations","ü",{"$nulls":5},"tronqué","ü",null,"ü"]
["Etablissement de la langue de communication",{"$nulls":4},"ü",null,"ü",null,"tronqué",null,"ü"]
[]
["Transaction de service 1","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Transaction de service 2","ü","ü","ü",null,null,"ü"]
["Transaction de service 3",{"$nulls":5},"ü"]
[]
["Remerciement","ü",null,"ü","ü",null,"ü","tronqué","ü","ü","ü","ü"]
["Salutations","ü","ü","ü","ü",null,"ü",null,"ü","ü"]
["Souhait","ü",null,"ü","ü",null,"ü",null,"ü"]
[]
["+ interruption (hors-sujet) par un collègue",null,"ü","ü",{"$nulls":7},"ü"]
["+ interruption (hors-sujet) par un usager","ü","ü",{"$nulls":7},"ü"]
["+  attention sur l'enregistrement",null,"ü",{"$nulls":5},"ü","ü"]
["+ demande de collaboration",null,"ü",{"$nulls":4},"ü","ü"]
[null,null,"(collègue interprète)",{"$nulls":5},"(collègue saisit le dossier)"]
["+ transaction intermédiaire ou parallèle",{"$nulls":7},"ü"]
[{"$nulls":8},"(recherche des lunettes)"]
["+ bavardage",null,"ü",{"$nulls":4},"ü","ü","ü"]

{"sheet":"OFII - Accueil - TS","index":3,"n_rows":11,"n_cols":20,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,4,6,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[0,0,1,0],[0,4,0,5],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,4,4,5]]}
["Office de l'immigration - Accueil","Hai","Hai","Glaiza","Glaiza",null,"Jimena","Jimena","Loussig","Loussig","Loussig","Nancy","Nadezhda","Nadezhda","Nadezhda","Kshaunich","Sali","Vicente","Lian","Wan"]
[null,"Transaction 1","Transaction 2","Transaction 1","Transaction 2",null,"Transaction 1","Transaction 2","Transaction 1","Transaction 2","Transaction 3","Transaction 1","Transaction 1","Transaction 2","Transaction 3","Transaction 1","Transaction 1","Transaction 1","Transaction 1","Transaction 1"]
["Verbalisation par l'usager","tronqué","ü","ü","ü",null,"ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Objectif proposé","obtention d'un tampon sur un certificat de formation linguistique","demande de convocation pour passer le dilf","dépôt de demande de titre de séjour pour le fils 1","dépôt de demande de titre de séjour pour le fils 2",null,"obtention du  titre de séjour","question sur le titre de séjour","dépôt de demande de titre de séjour","question sur les procédures d'obtention de la double nationalité","question sur les pré-requis pour l'obtention de la double nationalité","obtention d'un document de circulation","questions sur le titre de séjour","question sur les conséquences de la non-obtention du titre de séjour avant l'expiration du visa temporaire","question sur la situation administrative de la fille de l'usagère","prise de RDV préfecture pour renouvellement du titre de séjour","prise de RDV préfecture pour renouvellement du titre de séjour","obtention d'un titre de séjour","obtention d'un titre de séjour","obtention d'un titre de séjour"]
["Exposition de la situation-problème / Construction du dossier mental","ü","ü","ü","ü",null,null,null,"ü","ü",null,"ü","ü","ü",null,"ü","ü","ü"]
["Réalisation de l'objectif",null,"ü","ü","ü","réalisation partielle ad hoc, complément reporté","ü","ü","ü",null,"ü",null,"ü","ü","ü","ü","ü",null,"ü","ü"]
["Redéfinition de ","ü",{"$nulls":7},"ü",null,"ü",null,"ü",null,null,null,"ü"]
["l'objectif avec l'agent","explication de la procédure pour l'obtention du tampon",{"$nulls":7},"définition de l'agent compétent pour répondre",null,"obtention d'une convocation pour la visite médicale et le titre de séjour",null,"re-dépôt de dossier pour obtenir un reçu",null,null,null,"précisions sur les documents valant justificatif de domicile"]
["Réalisation de l'objectif redéfini","ü",{"$nulls":7},"ü",null,"ü",null,"ü",null,null,null,"ü"]
["Co-construction des attentes pour l'objectif au-delà de la rencontre",null,null,null,"ü",null,null,null,"ü",null,null,"ü",null,"ü",null,"ü","ü","ü","ü","ü"]
["Clôture de la réalisation complète",null,null,"ü","ü",null,"ü","ü",null,"ü","ü","ü",null,"ü","ü","ü","ü","ü","ü","ü"]

{"sheet":"OFII - Audit","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Office de l'immigration - Auditeurs"]
[null,"Batouly","Bouly","Chang","Fanja","Ilhamallah","Nielini","Ramona"]
["Salutations"]
[]
["Transaction de service 1","ü","ü","ü","ü","ü","ü","ü"]
["Transaction de service 2",null,null,"ü",null,null,null,"ü"]
[]
["Remerciement","ü","tronqué","ü","ü","tronqué","ü","tronqué"]
["Salutations","tronqué",null,null,"tronqué",null,"tronqué"]
["Souhait"]
[]
["+ interruption (hors-sujet) par un collègue",{"$nulls":6},"ü"]
["+  attention sur l'enregistrement",null,"ü","ü",null,"ü",null,"ü"]
["+ demande de collaboration","ü",null,null,null,"ü"]
[null,"(mari donne le n° de portable)",null,null,null,"(mari considère la possibilité de venir déposer un justificatif)"]
["+ bavardage",null,null,"ü",null,null,null,"ü"]

{"sheet":"OFII - Audit dév.","index":5,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Office de l'immigration - Auditeurs","Fanja","Batouly","Nielini","Ilhamallah","Bouly","Chang","Ramona"]
["Etapes de routine"]
["Complétion du formulaire numérique de l'audit","ü","ü","ü","ü","ü","ü","ü"]
["Offre/prise de RDV avec une assistante sociale","ü","ü","ü","ü","ü","ü","ü"]
["Prise de RDV pour la formation civique","ü","ü","ü","ü","ü","ü","ü"]
["Offre/prise de RDV pour la formation Vivre en France","ü","ü","ü","ü","ü",null,"ü"]
["Prise de RDV pour le bilan de compétences professionnelles","ü","ü","ü",null,"ü",null,"ü"]
["Evaluation des besoins de formation en français","ü",null,"ü",null,"ü","ü"]
["Signature du C.A.I.","ü","ü","ü","ü","ü","ü","ü"]
["Remise par l'agent de convocations, de documents de bienvenue et d'informations","ü","ü","ü","ü","ü","ü","ü"]
["Etapes hors routine"]
["Question sur la nationalité française",null,"ü",null,null,null,"ü"]
["Informations sur la procédure après l'audit",null,null,null,"ü"]
["Remise par l'agent d'un double du certificat de niveau en langue",null,"ü"]
["Organisation pour la remise d'un justificatif",null,null,null,"ü"]
["Proposition de formation dans le domaine de spécialité de l'usagère",null,null,null,"ü"]
["Orientation de l'usager vers le prochain bureau",{"$nulls":4},"ü","ü"]
["Conseils/demande d'informations sur une formation pour adulte existante mais non proposée dans le dispositif",{"$nulls":6},"ü"]

{"sheet":"OFII - Audit - TS","index":6,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Office de l'immigration - Auditeurs","Batouly","Bouly","Chang","Chang","Fanja","Ilhamallah","Nielini","Ramona","Ramona"]
[null,"Transaction 1","Transaction 1","Transaction 1","Transaction 2","Transaction 1","Transaction 1","Transaction 1","Transaction 1","Transaction 2"]
["Verbalisation par l'usager",null,null,null,"ü",{"$nulls":4},"ü"]
["Objectif proposé","signature du contrat d'accueil de l'intégration","signature du contrat d'accueil de l'intégration","signature du contrat d'accueil de l'intégration","demande d'informations sur l'obtention de la nationalité française","signature du contrat d'accueil de l'intégration","signature du contrat d'accueil de l'intégration","signature du contrat d'accueil de l'intégration","signature du contrat d'accueil de l'intégration","demande d'informations sur la formation pour adultes"]
["Exposition de la situation-problème / Construction du dossier mental","ü","ü","ü",null,"ü","ü","ü","ü"]
["Réalisation de l'objectif","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Co-construction des attentes pour l'objectif au-delà de la rencontre","ü","ü","ü",null,"ü","ü","ü","ü"]
["Clôture de la réalisation complète"]

{"sheet":"OFII - Audit - TS dév.","index":7,"n_rows":8,"n_cols":61,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Office de l'immigration - Auditeurs","Batouly","Batouly","Batouly","Batouly","Batouly","Batouly","Batouly","Batouly","Batouly","Bouly","Bouly","Bouly","Bouly","Bouly","Bouly","Bouly","Bouly","Bouly","Chang","Chang","Chang","Chang","Chang","Chang","Chang","Chang","Fanja","Fanja","Fanja","Fanja","Fanja","Fanja","Fanja","Fanja","Ilhamallah","Ilhamallah","Ilhamallah","Ilhamallah","Ilhamallah","Ilhamallah","Ilhamallah","Ilhamallah","Ilhamallah","Nielini","Nielini","Nielini","Nielini","Nielini","Nielini","Nielini","Nielini","Ramona","Ramona","Ramona","Ramona","Ramona","Ramona","Ramona","Ramona","Ramona"]
[null,"Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 7","Transaction 8","Transaction 9","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 7","Transaction 8","Transaction 9","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 7","Transaction 8","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 7","Transaction 8","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 7","Transaction 8","Transaction 9","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 7","Transaction 8","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 7","Transaction 8","Transaction 9"]
["Verbalisation par l'usager",{"$nulls":8},"ü",{"$nulls":15},"ü",{"$nulls":34},"ü"]
["Objectif proposé","complétion du formulaire numérique de l'audit","offre de RDV avec une assistante sociale","prise de RDV pour la formation civique","offre de formation Vivre en France","prise de RDV pour le bilan de compétences professionnelles","remise par l'agent d'un double du certificat de niveau en langue","signature du contrat d'accueil et d'intégration","remise par l'agent de convocations, de documents de bienvenue et d'informations","question sur l'utilité de la nationalité française","complétion du formulaire numérique de l'audit","offre de RDV avec une assistante sociale","prise de RDV pour la formation civique","offre de formation Vivre en France","prise de RDV pour le bilan de compétences professionnelles","évaluation des besoins de formation en français","signature du contrat d'accueil et d'intégration","remise par l'agent de convocations, de documents de bienvenue et d'informations","orientation de l'usager vers le prochain bureau","complétion du formulaire numérique de l'audit","offre de RDV avec une assistante sociale","prise de RDV pour la formation civique","évaluation des besoins de formation en français","signature du contrat d'accueil et d'intégration","remise par l'agent de convocations, de documents de bienvenue et d'informations","demande d'informations sur l'obtention de la nationalité française","orientation vers les prochains bureaux","complétion du formulaire numérique de l'audit","offre de RDV avec une assistante sociale","prise de RDV pour la formation civique","offre de formation Vivre en France","prise de RDV pour le bilan de compétences professionnelles","évaluation des besoins de formation en français","signature du contrat d'accueil et d'intégration","remise par l'agent de convocations, de documents de bienvenue et d'informations","informations sur la procédure après l'audit","complétion du formulaire numérique de l'audit","organisation de la remise d'un justificatif pour être dispensée du bilan de compétences professionnelles","offre de RDV avec une assistante sociale","prise de RDV pour la formation civique","offre de formation Vivre en France","proposition de formation dans le domaine professionnel de l'usagère","signature du contrat d'accueil et d'intégration","remise par l'agent de convocations, de documents de bienvenue et d'informations","complétion du formulaire numérique de l'audit","offre de RDV avec une assistante sociale","prise de RDV pour la formation civique","évaluation du besoin de formation Vivre en France","prise de RDV pour le bilan de compétences professionnelles","évaluation des besoins de formation en français","signature du contrat d'accueil et d'intégration","remise par l'agent de convocations, de documents de bienvenue et d'informations","complétion du formulaire numérique de l'audit","information sur les coordonnées de l'assistante sociale","conseils pour pallier l'inadéquation du dispositif avec les compétences de l'usagère","prise de RDV pour la formation civique","offre de formation Vivre en France","prise de RDV pour le bilan de compétences professionnelles","signature du contrat d'accueil et d'intégration","remise par l'agent de convocations, de documents de bienvenue et d'informations","demande d'informations sur la formation pour adultes"]
["Exposition de la situation-problème / Construction du dossier mental","ü",null,"ü",null,"ü","ü",null,null,null,"ü",{"$nulls":7},"ü","ü","ü",null,null,null,"ü",null,null,"ü","ü","ü","ü","ü",null,null,null,"ü","ü","PAS UNE TRANSACTION DE SERVICE",{"$nulls":6},"ü","ü",null,null,"ü","ü",null,null,"ü",null,"ü"]
["Réalisation de l'objectif","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü",null,"ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Co-construction des attentes pour l'objectif au-delà de la rencontre",null,null,"ü",null,"ü",null,null,"ü",null,null,null,"ü",null,"ü",null,null,"ü",null,null,null,"ü","ü",null,"ü",{"$nulls":4},"ü","ü","ü",null,null,"ü",null,"ü",null,null,"ü",null,null,null,"ü",null,null,"ü",null,"ü",null,null,"ü",null,null,null,"ü","ü","ü",null,"ü"]
["Clôture de la réalisation complète",null,null,"ü",{"$nulls":8},"ü",{"$nulls":8},"ü",{"$nulls":17},"ü",{"$nulls":6},"ü",{"$nulls":8},"ü"]

{"sheet":"PP","index":8,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Préfecture de police"]
[null,"Aiday","Brittany","Carlos","Hua","Juliana","Kylych","Li Na","Li Wei","Nourredine","Seybou","Shamina","Soo Ji","Suraj","Tarek","Wouleymatou","Xun","Yuliana"]
["Interpellation","ü",{"$nulls":6},"ü","ü",{"$nulls":4},"ü"]
["Gestion de la file d'attente",{"$nulls":6},"ü"]
["Salutations",null,"ü","ü","ü","ü","ü","ü","ü",null,"ü","ü","ü",null,null,"ü","ü","ü"]
[]
["Transaction de service 1","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Transaction de service 2",null,null,"ü",null,"ü",{"$nulls":6},"ü",null,"ü"]
["Transaction de service 3",null,null,"ü",null,"ü",{"$nulls":8},"ü"]
["Transaction de service 4",{"$nulls":4},"ü",{"$nulls":8},"ü"]
[]
["Remerciement","ü",null,"ü","ü","ü",null,"ü","ü","ü","ü",null,"ü","ü","ü","ü","ü"]
["Salutations",null,null,"ü","ü","ü","ü","ü","ü","ü",null,null,"ü","ü","ü","ü","ü"]
["Souhait","ü",null,"ü","ü","ü","ü","ü",null,"ü","ü",null,null,null,"ü","ü","ü"]
[]
["+ interruption (hors-sujet) par un collègue",null,null,null,"ü","ü",null,null,null,"ü",null,null,null,"ü"]
["+ bavardage hors-sujet","ü","ü",null,"ü",null,null,"ü",null,"ü","ü",null,null,"ü","ü","ü","ü","ü"]
["+  attention sur l'enregistrement",null,"ü",null,"ü",null,null,"ü",null,"ü",null,null,null,"ü"]
["+ alternance codique",null,null,"ü",null,null,null,"ü",{"$nulls":9},"ü"]

{"sheet":"PP - TS","index":9,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Préfecture de police","Aiday","Brittany","Carlos","Carlos","Carlos","Hua","Juana","Juana","Juana","Juana","Kylych","Li Na","Li Wei","Nourredine","Seybou","Seybou","Shawn","Soo Ji","Suraj","Suraj","Tarek","Tarek","Tarek","Tarek","Wouleymatou","Xun","Yuliana"]
[null,"Transaction 1","Transaction 1","Transaction 1","Transaction 2","Transaction 3","Transaction 1","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 1","Transaction 1","Transaction 1","Transaction 1","Transaction 1","Transaction 2","Transaction 1","Transaction 1","Transaction 1","Transaction 2","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 1","Transaction 1","Transaction 1"]
["Verbalisation par l'usager",null,"ü","ü","ü",null,null,"ü","ü","ü","ü",{"$nulls":4},"ü","ü","ü",null,"ü","ü","ü",null,"ü","ü"]
["Objectif proposé","obtention du titre de séjour","obtention du titre de séjour","obtention du titre de séjour","renseignement sur les lieux de vente des timbres","obtention du titre de séjour","obtention du titre de séjour","question \"par rapport aux timbres\"","renseignement sur le coût de la taxe entreprise pour un titre de séjour salarié","renseignement sur les horaires d'ouverture de la préfecture de police","durée de validité du titre de séjour salarié","obtention du titre de séjour","obtention du titre de séjour","obtention du titre de séjour","obtention du titre de séjour","obtention du titre de séjour","obtention du titre de séjour","renseignement sur la procédure quand l'usager a perdu son certificat médical","obtention du titre de séjour","renseignement sur l'avancement de disponibilité du titre de séjour","obtention du numéro de téléphone du service","renseignement sur la procédure d'obtention du titre de séjour","obtention du titre de séjour","renseignement sur la procédure vis-à-vis du titre de séjour quand le passeport arrive à expiration","renseignement sur les droititre de séjour inhérentitre de séjour au titre de séjour","obtention du titre de séjour","obtention du titre de séjour","obtention du titre de séjour"]
["Exposition de la situation-problème / Construction du dossier mental","ü","ü","ü",null,null,"ü","ü","ü",null,"ü","ü","ü","ü","ü","ü","ü","ü","ü",{"$nulls":7},"ü","ü"]
["Description de la procédure",null,null,"ü",null,"ü","ü",{"$nulls":4},"ü","ü",null,"ü",null,"ü",null,"ü",null,null,null,"ü",null,null,"ü","ü"]
["Réalisation de l'objectif","ü",null,null,"ü","ü","ü","ü",null,"ü","ü","ü","ü","ü","ü",null,"ü",{"$nulls":4},"ü","ü","ü","ü","ü","ü"]
["Redéfinition de ",null,"ü","ü",{"$nulls":4},"ü",{"$nulls":6},"ü",null,"ü","ü","ü",{"$nulls":7},"ü"]
["l'objectif avec l'agent",null,"redirection vers le bon bureau","achat des timbres OMI",{"$nulls":4},"redirection vers un autre bureau",{"$nulls":6},"achat des timbres OMI",null,"redirection vers le bureau médical","achat des timbres OMI","redirection vers le bon bureau","refus",{"$nulls":6},"redirection vers le bon bureau"]
["Description de la procédure de réalisation de l'objectif",null,"ü","ü",{"$nulls":11},"ü",null,"ü","ü","ü",{"$nulls":7},"ü"]
["Réalisation de l'objectif redéfini",null,"(dans un autre bureau)","(dans un autre bureau)",{"$nulls":4},"ü",{"$nulls":6},"(dans un autre bureau)",null,"(dans un autre bureau)","(dans un autre bureau)",{"$nulls":8},"(dans un autre bureau)"]
["Co-construction des attentes pour l'objectif au-delà de la rencontre",null,null,null,"ü",null,null,"ü",{"$nulls":10},"ü"]
["Clôture de la réalisation complète","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü",null,"ü",null,"ü","ü","ü",null,"ü","ü",null,"ü",null,"ü","ü",null,"ü"]

{"sheet":"Coord.","index":10,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Coordinatrice étudiants étrangers"]
[null,"Morena"]
["Salutations","tronqué"]
["Etablissement de la langue de communication"]
[]
["Transaction de service 1","ü"]
["Transaction de service 2","ü"]
["Transaction de service 3","ü"]
["Transaction de service 4","ü"]
["Transaction de service 5","ü"]
[]
["Remerciement","ü"]
["Salutations","ü"]
["Souhait"]
[]
["+  attention sur l'enregistrement"]

{"sheet":"Coord. - TS","index":11,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,5],[0,0,1,0]]}
["Coordinatrice étudiants étrangers","Morena","Morena","Morena","Morena","Morena"]
[null,"Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5"]
["Verbalisation par l'usager","tronqué","ü",null,null,"ü"]
["Objectif proposé","gestion d'un chevauchement de cours - encadrement erasmus","demande pour informer les enseignants de l'adaptation des modalités d'examens aux étudiants erasmus","évaluation du moral et du choc culturel de l'étudiante","prise de RDV avec la coordinatrice pour une signature","renseignement sur les dates des examens"]
["Exposition de la situation-problème / Construction du dossier mental","ü","ü","ü","ü"]
["Réalisation de l'objectif","ü",null,"ü","ü","ü"]
["Redéfinition de ",null,"ü"]
["l'objectif avec l'agent",null,"engagement de la coordinatrice à informer les enseignants*"]
["Réalisation de l'objectif redéfini",null,"ü"]
["Co-construction des attentes pour l'objectif au-delà de la rencontre","ü",null,"ü",null,"ü"]
["Clôture de la réalisation complète"]
[null,"* Ce service n'est pas dirigé vers l'usagère mais vers les collègues de l'agent/coordinatrice. Il n'est pas comptaibilisé dans les services dominants parce que le \"renseignement\" qu'il constitue ne s'adresse pas à l'usagère, contrairement à tous les autres."]

{"sheet":"ITI","index":12,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Institut de traducteurs et d'interprètes"]
[null,"Susan 01","Susan 02","Susan 03","Susan 04","Susan 05","Susan 06","Susan 07","Susan 08","Susan 09"]
["Salutations",{"$nulls":6},"ü","ü","ü"]
[]
["Transaction de service 1","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Transaction de service 2","ü","ü","ü","ü","ü","ü","ü","ü"]
["Transaction de service 3","ü",null,"ü","ü","ü","ü","ü","ü"]
["Transaction de service 4","ü",null,"ü","ü","ü","ü","ü"]
["Transaction de service 5","ü",null,null,null,"ü","ü","ü"]
["Transaction de service 6","ü",null,null,null,"ü","ü"]
["Transactions de service 7 à 15",{"$nulls":4},"ü","ü"]
["Transactions de service 15 à 23",{"$nulls":4},"ü"]
[]
["Remerciement","ü","ü","ü","ü","ü","ü",null,"ü","ü"]
["Salutations","ü","ü","ü","ü","ü","ü",null,"ü","ü"]
["Souhait","ü","ü",null,"ü","ü",null,null,"ü"]
[]
["+ interruption (hors-sujet) par un usager",{"$nulls":5},"ü"]
["+  attention sur l'enregistrement",{"$nulls":4},"ü",null,"ü","ü"]
["+ bavardage",{"$nulls":4},"ü"]

{"sheet":"ITI - TS","index":13,"n_rows":11,"n_cols":68,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Institut de traducteurs et d'interprètes","Susan 01","Susan 01","Susan 01","Susan 01","Susan 01","Susan 01","Susan 02","Susan 02","Susan 03","Susan 03","Susan 03","Susan 04","Susan 04","Susan 04","Susan 04","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 05","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 06","Susan 07","Susan 07","Susan 07","Susan 07","Susan 07","Susan 08","Susan 08","Susan 08","Susan 09","Susan 09","Susan 09","Susan 09","Susan 09","Susan 09"]
[null,"Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 1","Transaction 2","Transaction 1","Transaction 2","Transaction 3","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 7","Transaction 8","Transaction 9","Transaction 10","Transaction 11","Transaction 12","Transaction 13","Transaction 14","Transaction 15","Transaction 16","Transaction 17","Transaction 18","Transaction 19","Transaction 20","Transaction 21","Transaction 22","Transaction 23","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6","Transaction 7","Transaction 8","Transaction 9","Transaction 10","Transaction 11","Transaction 12","Transaction 13","Transaction 14","Transaction 15","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 1","Transaction 2","Transaction 3","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 5","Transaction 6"]
["Verbalisation par l'usager","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü",null,"ü","ü",null,null,"ü",null,null,null,"ü",null,"ü","ü","ü","ü",{"$nulls":5},"ü","ü",null,"ü","ü","ü",null,null,"ü",{"$nulls":4},"ü",null,null,"ü","ü",null,"ü","ü","ü","ü","ü",null,"ü",null,"ü","ü","ü",null,"ü","ü","ü","ü","ü","ü"]
["Objectif proposé","dépôt du sujet de mémoire d'une autre étudiante","mise au point sur l'obtention d'un stage","demande d'informations sur l'établissement d'une convention de stage","question sur le temps de travail pour le stage de traduction","question sur la langue dans laquelle le mémoire doit être écrit","question sur le début des examens après les vacances","question sur la nécessité d'une convention pour un stage court","question sur le moyen/lieu de retrait d'une convention de stage","mise au point sur l'obtention d'un stage","question sur le temps de travail du stage pour soutenir le mémoire et le rapport en même temps","co-signature de la convention","dépôt d'un certificat médical justifiant une absence","co-remplissage de la convention de stage","évaluation du bon déroulement du stage","co-signature de la convention","question sur la possibilité d'une équivalence avec une licence pour entrer en Master 1 à l'institut","conseil pour réussir en Master 1 : maitriser les langues","mise au point sur la situation actuelle de l'étudiante","information sur les langues étrangères de travail de l'étudiante","question sur la possibilité d'apprendre une nouvelle langue","information sur la valeur ajoutée du cursus d'origine de l'étudiante","information sur les trois parcours de l'institut (traduction, interprétation, relations internationales)","question sur les modalités d'entrée (exclusivité ou non des tests d'entrée aux parcours)","question sur le degré de sélectivité des tests","demande de confirmation sur la date des tests","conseil sur les modalités de la candidature","conseil sur la préparation aux tests","offre de réponse à d'autres questions (réalisée dans les transactions subordonnées suivantes)","question sur les préférences de l'étudiante concernant les parcours","conseils pour se renseigner et renseignements sur les trois parcours","demande d'informations sur le degré de théorie et de pratique dans la formation","demande d'informations sur la terminologie (langues A, B ou C)","offre de réponse à d'autres questions (réalisée dans les transactions subordonnées suivantes)","information sur les possibilités de valorisation du néerlandais","demande de confirmation de l'invalidité d'une rumeur (langues rares)","question sur le degré d'exigence de la maitrise des langues étrangères dans les tests d'admission","information sur la possibilité de poser d'autres questions par mail ou par RDV","conseil pour se renseigner davantage","demande d'évaluation pour intégrer la formation sans licence","évaluation des diplômes et de l'expérience professionnelle","évaluation des compétences en langues étrangères","évaluation des connaissances sur le métier","évaluation de la pertinence des langues maitrisées selon le marché du travail","question sur l'importance d'une langue rare pour le marché","évaluation de la maitrise de la langue maternelle","évaluation de la maitrise de l'informatique","demande d'informations générales sur le parcours audio-visuel","demande d'informations sur les lieux de travail privilégiés pour l'audio-visuel","conseil d'envoi d'un e-mail avant les tests","question sur la localisation des stages","question sur la répartition des cours dans la semaine","demande d'informations sur les préparations aux tests d'admission","question sur les modalités de dépôt de candidature","question concernant une offre de stage médical","recherche d'autres offres possibles","question sur la régularité de l'affichage des offres de stage","conseil sur la régularité de la visite de l'affichage par l'étudiante","demande de confirmation de l'intérêt et de la faisabilité d'un stage en 1e année","demande d'aide pour arranger un problème de chevauchement de cours","question sur les tarifs habituels en interprétation de liaison","conseil à l'étudiante de ne pas travailler sans déclarer ses revenus et information sur les solutions légales","demande d'attestation de stage obligatoire pour l'employeur","demande d'information sur les emplois du temps du 2d semestre","information de la responsable sur la prise en charge de traductions","demande d'accord pour qu'un enseignant donne un autre travail pour remplacer un contrôle continu pour lequel l'étudiante était absente","question sur les tâches à accomplir pendant le stage","question sur le nombre de pages du rapport de stage"]
["Exposition de la situation-problème / Construction du dossier mental","ü","ü","ü",null,"ü",null,"ü",null,"ü","ü","ü","ü","ü","ü",null,"ü","ü","ü","ü","ü",{"$nulls":6},"ü",null,null,"ü","ü","ü",null,null,"ü",null,null,null,"ü","ü","ü","ü",null,null,"ü","ü","ü",null,null,"ü",null,null,null,"ü","ü",null,null,"ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Réalisation de l'objectif","ü","ü","ü","ü","ü","ü","ü","ü","ü",null,"ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü",null,"ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü",null,"ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Redéfinition de ",{"$nulls":9},"ü",{"$nulls":13},"ü","ü",{"$nulls":13},"ü",{"$nulls":12},"ü"]
["l'objectif avec l'agent",{"$nulls":9},"information sur le fait que le rapport n'est pas soutenu",{"$nulls":13},"information sur les méthodes de sélection des évaluateurs","information sur la date des tests et sur la date d'ouverture des candidatures",{"$nulls":13},"évaluations et informations diverses (cf. transactions suivantes, intermédiaires pour la réalisation de l'objectif de l'étudiante)",{"$nulls":12},"précision sur le test concerné par la préparation"]
["Réalisation de l'objectif redéfini",{"$nulls":9},"ü",{"$nulls":13},"ü",{"$nulls":14},"ü",{"$nulls":12},"ü",{"$nulls":9},"ü",null,null,"ü"]
["Co-construction des attentes pour l'objectif au-delà de la rencontre",{"$nulls":5},"ü","ü",null,null,null,"ü",null,null,null,"ü",{"$nulls":23},"ü",{"$nulls":19},"ü"]
["Clôture de la réalisation complète"]

{"sheet":"SecFLE","index":14,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Secrétariats et scolarités de FLE"]
[null,"Agneska","Aiko","Friedrich","Iounna","Ling","Maria","Mayara","Sakura"]
["Salutations",{"$nulls":5},"ü"]
["Etablissement de la langue de communication","tronqué","tronqué","tronqué","tronqué","tronqué",null,"tronqué","tronqué"]
[]
["Transaction de service 1","ü","ü","ü","ü","ü","ü","ü","ü"]
["Transaction de service 2",null,null,null,"ü","ü",null,"ü"]
["Transaction de service 3",{"$nulls":4},"ü",null,"ü"]
["Transaction de service 4",{"$nulls":6},"ü"]
[]
["Remerciement",null,"tronqué",null,"tronqué","ü","ü","ü","ü"]
["Salutations",{"$nulls":4},"ü","ü",null,"ü"]
["Souhait",{"$nulls":4},"tronqué","ü"]

{"sheet":"SecFLE - TS","index":15,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Secrétariats et scolarités de FLE","Agneska","Aiko","Friedrich","Iounna","Iounna","Ling","Ling","Ling","Maria","Mayara","Mayara","Mayara","Mayara","Sakura","Sakura"]
[null,"Transaction 1","Transaction 1","Transaction 1","Transaction 1","Transaction 2","Transaction 1","Transaction 2","Transaction 3","Transaction 1","Transaction 1","Transaction 2","Transaction 3","Transaction 4","Transaction 1","Transaction 2"]
["Verbalisation par l'usager","tronqué","tronqué","tronqué","ü","ü","tronqué","ü","ü","ü","tronqué","ü","ü","ü","ü","tronqué"]
["Objectif proposé","inscription à l'université","inscription à l'université","inscription à l'université","demande de signature sur une attestation de bourse","demande de relevé de notes","question sur la nécessité de passer le test de connaissance du français avant de s'inscrire en licence","question sur l'accès aux renseignements concernant le test de connaissance du français","question sur le destinataire des courriers","remise du certificat de niveau du diplôme de langue française","inscription à l'université","question sur l'affichage des horaires de cours","question sur la localisation des cours","question sur l'existence d'un restaurant universitaire","question sur le paiement de la sécurité sociale","inscription universitaire"]
["Exposition de la situation-problème / Construction du dossier mental","ü","ü","ü",null,"ü","ü",null,null,"ü","ü",null,null,null,"ü"]
["Réalisation de l'objectif","ü","partiel (tronqué)","ü",null,"ü","ü","ü","ü","ü","ü","ü","ü","ü","tronqué","ü"]
["Redéfinition de ",null,null,null,"ü"]
["l'objectif avec l'agent",null,null,null,"conseil de revenir quand la responsable sera présente"]
["Réalisation de l'objectif redéfini",null,null,null,"ü",{"$nulls":9},"ü"]
["Co-construction des attentes pour l'objectif au-delà de la rencontre","ü","ü","ü","ü",null,"ü",null,null,null,"ü"]
["Clôture de la réalisation complète"]

{"sheet":"SRI","index":16,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Service des relations internationales"]
[null,"Anja","Bartek","Domenika","Johana","Kunz","Magda","Marilena","Mirella"]
["Salutations",null,null,null,"ü","ü",null,"ü"]
[]
["Transaction de service 1","ü","ü","ü","ü","ü","ü","ü","ü"]
["Transaction de service 2",null,null,null,"ü",null,null,"ü"]
["Transaction de service 3",{"$nulls":6},"ü"]
[]
["Remerciement","ü","ü","ü","ü","ü","ü","ü","ü"]
["Salutations","ü","ü","ü","ü","ü","ü","ü","ü"]
["Souhait","ü",null,null,"ü",null,null,null,"ü"]
["Compliment",{"$nulls":7},"ü"]
[]
["+ transaction autre",null,null,null,"ü",null,"ü","ü","ü"]
[{"$nulls":4},"cadeaux",null,null,"cadeaux","coursier"]
["+ bavardage","ü","ü",null,null,"ü",null,"ü","ü"]

{"sheet":"SRI - TS","index":17,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Service des relations internationales","Anja","Bartek","Domenika","Johana","Johana","Kunz","Magda","Magda","Marilena","Marilena","Marilena","Mirella","Mirella","Mirella"]
[null,"Transaction 1","Transaction 1","Transaction 1","Transaction 1","Transaction 2","Transaction 1","Transaction 1","Transaction 2","Transaction 1","Transaction 2","Transaction 3","Transaction 1","Transaction 2","Transaction 3"]
["Verbalisation par l'usager","ü","ü",null,"ü","ü","ü",null,null,"ü","ü","ü","ü","ü"]
["Objectif proposé","demande de signature de l'attestation d'accueil","demande de signature de l'attestation d'accueil","remplissage d'un document","demande de signature de l'attestation d'accueil","question sur les relevés de notes","demande de signature de l'attestation d'accueil","information sur un changement de résidence universitaire","signature du bon de déménagement","demande de signature de l'attestation d'accueil","demande de signature d'un document pour raccourcir la durée de séjour en chambre étudiante","demande de signature du relevé de notes","demande de signature de l'attestation d'accueil","demande de confirmation sur l'arrivée d'un autre étudiant dans sa chambre après son départ prévu","information au sujet d'une soirée d'accueil d'étudiants étrangers"]
["Exposition de la situation-problème / Construction du dossier mental",null,"ü","ü",null,null,"ü","ü",null,null,"ü","ü","ü"]
["Réalisation de l'objectif","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü","ü"]
["Redéfinition de ",{"$nulls":10},"ü"]
["l'objectif avec l'agent",{"$nulls":10},"renvoi auprès de la secrétaire compétente"]
["Réalisation de l'objectif redéfini",{"$nulls":10},"ü"]
["Co-construction des attentes pour l'objectif au-delà de la rencontre",{"$nulls":9},"ü"]