{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["A propos du Cahier","Tableau de Bord","Annexe","HIDE"],"not_rendered":{"charts":2,"images":8,"macros":1,"external_links":1,"defined_names":4,"comments":2,"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":"A propos du Cahier","index":0,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[17,1,17,8],[0,0,0,8],[27,2,27,8],[29,2,29,8],[31,2,31,8],[15,1,15,8],[16,1,16,8],[45,2,45,8],[33,1,33,8],[23,1,23,8],[25,1,25,8],[35,1,35,8],[40,1,40,8],[42,0,42,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS"]
[null,"Toutes les données doivent être insérées dans le «Tableau de bord»."]
[null,"Les cellules en bleu clair sont des cellules d'entrée ; d'autres cellules sont protégées pour garantir l'intégrité du Cahier."]
[null,"Le tableau de bord affichera un résumé des résultats de la planification de l'espace. "]
[]
[null,"COMMENT UTILISER CE CAHIER"]
[]
[]
[]
[null,"1) ENTRER le nom du projet/ministère et l'adresse du projet dans les champs appropriés."]
[]
[null,"2) SÉLECTIONNEZ LE PROFIL D'ACTIVITÉ SOUHAITÉ\nSélectionnez dans la liste déroulante l'un des 3 profils en fonction des éléments suivants :"]
[]
[null,null,"Le profil autonome est mieux adapté aux groupes qui travailleront individuellement au bureau avec un niveau d'interaction limité. Il présente la plus forte proportion de points de travail individuels."]
[]
[null,null,"Le profil équilibré convient mieux aux groupes qui travailleront à la fois individuellement et en collaboration au bureau avec un niveau d'interaction modéré. Il a la distribution la plus équilibrée de points de travail avec une proportion égale de points de travail individuels et collaboratifs."]
[]
[null,null,"Le profil interactif est mieux adapté aux groupes qui travailleront en collaboration au bureau avec un niveau élevé d'interaction. Il présente la plus forte proportion de points de travail collaboratifs."]
[]
[null,"3) ENTREZ LES DONNÉES CONNUES\nEntrez les données clés dans les cellules appropriées. Entrez la solution d'espace en m²u et la population actuelle. Cela déterminera l'occupation cible qui est utilisée pour calculer les ratios et les distributions de points de travail optimaux."]
[]
[null,"4) AJUSTEZ CHAQUE POINT DE TRAVAIL INDIVIDUEL AU BESOIN\nUne distribution idéale de la quantité de points de travail sera automatiquement calculée pour chaque catégorie. Ceux-ci peuvent être modifiés manuellement pour répondre aux exigences ou préférences spécifiques du client, dans une plage prédéterminée, en utilisant les barres situées à côté de chaque cellule. La cellule deviendra orange si une quantité est trop élevée et bleue si une quantité est trop faible."]
[null,null,"- Faites défiler la barre vers la droite pour augmenter les quantités (augmente de 1 unité)"]
[null,null,"-Faites défiler la barre vers la gauche pour diminuer les quantités (diminue d'une unité)"]
[null,"Cliquez sur le bouton «Réinitialiser» pour réinitialiser toutes les cellules aux montants suggérés."]
[]
[null,"5) VÉRIFIER LES SURPLUS/DÉFICITS POUR ASSURER UNE PLANIFICATION OPTIMALE DE L'ESPACE\nSi vous dépassez l'espace disponible, le nombre deviendra ROUGE pour mettre en évidence le déficit. S'il vous reste de l'espace pour planifier, le nombre deviendra VERT pour indiquer le surplus. Ajustez simplement les quantités de points de travail en conséquence."]
[]
["CLIQUEZ ICI POUR COMMENCER A PLANIFIER"]
[]
[]
[null,"ANNEXE","Détails des points de travail du Milieu de travail GC"]
[]
[null,null,null,null,null,null,null,"DATE DE SORTIE DE LA VERSION :","2024-04-11"]

{"sheet":"Tableau de Bord","index":1,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,1,45,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[35,1,38,1],[40,1,43,1],[34,1,34,2],[12,4,12,5],[13,4,13,5],[15,4,15,5],[16,4,16,5],[29,1,31,1],[31,2,31,3],[22,2,22,3],[33,2,33,3],[23,2,23,3],[27,2,27,3],[29,2,29,3],[30,2,30,3],[22,4,23,4],[25,4,27,4],[29,4,31,4],[35,15,35,22],[28,14,32,14],[33,14,34,14],[31,15,31,16],[32,15,32,16],[34,7,34,8],[34,15,34,16],[29,15,29,16],[30,15,30,16],[3,4,3,12],[4,4,4,12],[6,4,6,12],[7,10,7,11],[8,10,8,11],[26,15,26,16],[27,15,27,16],[22,14,27,14],[28,15,28,16],[33,15,33,16],[26,2,26,3],[21,1,21,2],[22,1,23,1],[25,1,27,1],[21,7,21,8],[4,19,5,21],[7,8,7,9],[8,8,8,9],[9,8,9,9],[25,2,25,3],[21,14,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[9,10,9,11]]}
["CAHIER DE PLANIFICATION DU Milieu de travail GC"]
[]
[null,null,"INSCRIRE LES INFORMATIONS SUR LE PROJET",null,null,null,null,null,null,null,null,null,null,null,null,"VÉRIFIER LE RÉSULTAT"]
[null,null,null,"Nom de projet / Ministère:",null,null,null,null,null,null,null,null,null,null,null,"Solution d'espace total",{"$f":"E13","v":0}]
[null,null,null,"Adresse du projet:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Circulation (\"&S5&\"%)\"","v":"Circulation (35%)"},{"$f":"SUM(E13*-(S5/100))","v":0},null,35,"Adjust Circulation (35 - 40%) and \nBuilding Fit Factor (6 - 10%) as required"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Facteur d'ajustement du batiment (\"&S6&\"%)\"","v":"Facteur d'ajustement du batiment (6%)"},{"$f":"E13*-(S6/100)","v":0},null,6]
[null,null,"CHOISIR LE PROFIL D'ACTIVITÉ",null,"WORKPOINT DISTRIBUTION COMPARISON",null,null,null,null,null,null,null,null,null,null,"ESPACE DE PLANIFICATION",{"$f":"SUM(Q4:Q6)","v":0}]
[null,null,1,null,"Profil d'activité",null,null,null,{"$f":"HIDE!A37","v":"Autonome"},null,{"$f":"HIDE!A38","v":"Équilibré"},null,{"$f":"HIDE!A39","v":"Interactif"}]
[null,null,null,null,"Points de travail individuels",null,null,null,"50-65%",null,"30-50%",null,"5-30%",null,null,"Points de travail individuels",{"$f":"M34","v":0}]
[null,null,null,null,"Points de travail collaboratifs et espace de soutien",null,null,null,"35-50%",null,"50-70%",null,"70-95%",null,null,"Point de travail collaboratifs",{"$f":"M46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Espace de soutien",{"$f":"X36","v":0}]
[null,null,"INSCRIRE LES DONNÉES CLÉS",null,null,null,null,null,null,null,null,null,null,null,null,"ESPACE ALLOUÉ",{"$f":"SUM(Q9:Q11)","v":0}]
[null,null,null,"Solution d'espace en m2u:",0,null,"(Inclut AUCUN local à usage particulier (LUP))"]
[null,null,null,"L'espace est conçu pour :",{"$f":"ROUND(E13/11,0)","v":0},null,"La capacité de charge maximale des occupants ne doit jamais dépasser ce que ",null,null,null,null,null,null,null,null,"Espace de planification",{"$f":"Q7","v":0}]
[null,null,null,"Current number of FTEs:",0,null,"l'autorité compétente autorise (ex: le code national de la bâtiment) ",null,null,null,null,null,null,null,null,"Espace alloué",{"$f":"-Q12","v":0}]
[null,null,null,"Built-in growth:",null,null,"(obtained by subtracting actual population from target occupancy)",null,null,null,null,null,null,null,null,{"$f":"IF(Q16=0,\"PAS DE SURPLUS / DÉFICIT\", IF(Q16>0,\"SURPLUS\",\"DEFICIT\"))","v":"PAS DE SURPLUS / DÉFICIT"},{"$f":"Q7-Q12","v":0}]
[null,null,null,"Population à temps plein (LUP):",null,null,"(Uniquement lorsqu'il est directement adjacent au bureau général)"]
[]
[null,null,"AJUSTER LE NOMBRE DE POINTS DE TRAVAIL",null,null,null,null,null,null,null,null,null,null,null,null,"VERIFIER SURPLUS / DÉFICIT",{"$f":"Q16","v":0}]
[]
[]
[null,"POINTS DE TRAVAIL INDIVIDUELS",null,null,"Nombre total de siège"," Allocation Standard","QTÉ","Ajuster les quantités de points de travail requises à l'aide des barres",null,null,"Taille suggérée",null,"Espace requis",null,"ESPACES DE SOUTIEN",null,null," Allocation Standard","QTÉ.","Ajuster les quantités de points de travail requises à l'aide des barres",null,"Taille suggérée",null,"Espace requis"]
[null,{"$f":"HIDE!A6","v":"PRIMAIRE INDIVIDUEL OUVERT"},{"$f":"HIDE!B6","v":"Poste de travail"},null,{"$f":"G23+G24","v":0},{"$f":"HIDE!M6","v":0},0,null,null,"x",3.5,"=",{"$f":"G23*K23","v":0},null,{"$f":"HIDE!A22","v":"ESPACE À USAGE GÉNÉRAL"},{"$f":"HIDE!B22","v":"Cuisinette"},null,{"$f":"HIDE!M22","v":0},0,2,"x",5,"=",{"$f":"S23*V23","v":0}]
[null,null,{"$f":"HIDE!B7","v":"Capsule de travail"},null,null,{"$f":"HIDE!M7","v":0},0,null,null,"x",2.5,"=",0,null,null,{"$f":"HIDE!B23","v":"Salle de mieux-être"},null,{"$f":"HIDE!M23","v":0},0,2,"x",7.5,"=",0]
[null,null,null,null,{"$f":"G23+G24","v":0},null,null,null,null,null,null,null,{"$f":"M23+M24","v":0},null,null,{"$f":"HIDE!B24","v":"Salle d'équipement"},null,{"$f":"HIDE!M24","v":0},0,2,"x",5,"=",0]
[null,{"$f":"HIDE!A8","v":"PRIMAIRE INDIVIDUEL FERMÉ"},{"$f":"HIDE!B8","v":"Salle de concentration"},null,{"$f":"G26+G27+G28","v":0},{"$f":"HIDE!M8","v":0},0,null,null,"x",7.5,"=",{"$f":"G26*K26","v":0},null,null,{"$f":"HIDE!B25","v":"Casiers\n(Espace par ETP)"},null,{"$f":"HIDE!M25","v":0},0,116,"x",0.5,"=",{"$f":"S26*V26","v":0}]
[null,null,{"$f":"HIDE!B9","v":"Espace ministériel dédié\n(sous-ministre ou ministre)"},null,null,0,0,null,null,"x",29,"=",0,null,null,{"$f":"HIDE!B26","v":"Rangement partagé"},null,{"$f":"HIDE!M26","v":0},0,1,"x",5,"=",0]
[null,null,{"$f":"HIDE!B10","v":"Salle d'étdue\n(5m2 par occupant)"},null,null,{"$f":"HIDE!M10","v":0},0,null,null,"x",5,"=",0,null,null,{"$f":"HIDE!B27","v":"Salle des serveurs/télécommunication dédiée (1 par étage)"},null,{"$f":"HIDE!M27","v":0},0,1,"x",10,"=",0]
[null,null,null,null,{"$f":"G26+G27+G28","v":0},null,null,null,null,null,null,null,{"$f":"M26+M27+M28","v":0},null,{"$f":"HIDE!A28","v":"POINT DE TRAVAIL SUPPLÉMENTAIRES POUR LA POPULATION DU LUP ADJACENT"},{"$f":"HIDE!B28","v":"Cabine / Salle Téléphonique"},null,{"$f":"HIDE!M28","v":0},0,0,"x",6.5,"=",0]
[null,{"$f":"HIDE!A11","v":"SECONDAIRE INDIVIDUEL"},{"$f":"HIDE!B11","v":"Capsule de concentration"},null,{"$f":"G30+G31+G32","v":0},{"$f":"HIDE!M11","v":0},0,null,null,"x",4,"=",0,null,null,{"$f":"HIDE!B29","v":"Salon"},null,{"$f":"HIDE!M29","v":0},0,0,"x",10,"=",0]
[null,null,{"$f":"HIDE!B12","v":"Point de transition\n(1.5m2 par occupant)"},null,null,{"$f":"HIDE!M12","v":0},0,null,null,"x",1.5,"=",0,null,null,{"$f":"HIDE!B30","v":"Salle de travail"},null,{"$f":"HIDE!M30","v":0},0,0,"x",15,"=",0]
[null,null,{"$f":"HIDE!B13","v":"Cabine / Salle Téléphonique"},null,null,{"$f":"HIDE!M13","v":0},0,null,null,"x",6.5,"=",0,null,null,{"$f":"HIDE!B31","v":"Cuisinette"},null,{"$f":"HIDE!M31","v":0},0,0,"x",5,"=",0]
[null,null,null,null,{"$f":"G30+G31+G32","v":0},null,null,null,null,null,null,null,{"$f":"M30+M31+M32","v":0},null,null,{"$f":"HIDE!B32","v":"Casiers\n(Espace par ETP)"},null,{"$f":"HIDE!M32","v":0},0,0,"x",0.5,"=",0]
[null,null,"Nombre total de sièges individuels",null,{"$f":"SUM(E25+E29+E33)","v":0},null,null,null,null,null,null,"Espace total de points de travail individuels",{"$f":"SUM(M23:M24)+SUM(M26:M28)+SUM(M30:M32)","v":0},null,"OTHER",{"$f":"HIDE!B33","v":"Espace de soutien personnalisé"},null,{"$f":"HIDE!M33","v":0},0,0,"x",0,"=",{"$f":"S34*V34","v":0}]
[null,"COLLABORATIVE WORKPOINTS",null,null,"Nombre de siège estimé"," Allocation Standard","QTÉ.","Ajuster les quantités de points de travail requises à l'aide des barres",null,null,"Taille suggérée",null,"Espace requis",null,null,{"$f":"HIDE!B34","v":"Point de travail personnalisé"},null,{"$f":"HIDE!M34","v":0},0,0,"x",0,"=",0]
[null,{"$f":"HIDE!A14","v":"COLLABORATIF OUVERT"},{"$f":"HIDE!B14","v":"Point de discussion"},null,{"$f":"SUM(G36)*4","v":0},{"$f":"HIDE!M14","v":0},0,null,null,"x",4,"=",{"$f":"G36*K36","v":0},null,null,"Espace total pour les espaces de soutien",null,null,null,null,null,null,null,{"$f":"SUM(X23:X24)+SUM(X25:X35)","v":0}]
[null,null,{"$f":"HIDE!B15","v":"Enclave"},null,{"$f":"SUM(G37)*4","v":0},{"$f":"HIDE!M15","v":0},0,null,null,"x",7,"=",0]
[null,null,{"$f":"HIDE!B16","v":"Zone d'équipe"},null,{"$f":"SUM(G38)*8","v":0},{"$f":"HIDE!M16","v":0},0,null,null,"x",15,"=",0]
[null,null,{"$f":"HIDE!B17","v":"Salon"},null,{"$f":"SUM(G39)*10","v":0},{"$f":"HIDE!M17","v":0},0,null,null,"x",10,"=",0]
[null,null,null,null,{"$f":"SUM(E36:E39)","v":0},null,{"$f":"SUM(G36:G39)","v":0},null,null,null,null,null,{"$f":"SUM(M36:M39)","v":0}]
[null,{"$f":"HIDE!A18","v":"COLLABORATIF FERMÉ"},{"$f":"HIDE!B18","v":"Salle de travail"},null,{"$f":"SUM(G41)*6","v":0},{"$f":"HIDE!M18","v":0},0,null,null,"x",16,"=",0]
[null,null,{"$f":"HIDE!B19","v":"Salle de projet"},null,{"$f":"SUM(G42)*8","v":0},{"$f":"HIDE!M19","v":0},0,null,null,"x",20,"=",0]
[null,null,{"$f":"HIDE!B20","v":"Salle de réunion moyenne"},null,{"$f":"SUM(G43)*12","v":0},{"$f":"HIDE!M20","v":0},0,null,null,"x",32,"=",0]
[null,null,{"$f":"HIDE!B21","v":"Grande salle de réunion"},null,{"$f":"SUM(G44)*20","v":0},{"$f":"HIDE!M21","v":0},0,null,null,"x",60,"=",0]
[null,null,null,null,{"$f":"SUM(E41:E44)","v":0},null,{"$f":"SUM(G41:G44)","v":0},null,null,null,null,null,{"$f":"SUM(M41:M44)","v":0}]
[null,"Nombre estimé de sièges collaboratifs",null,null,{"$f":"SUM(E40+E45)","v":0},null,{"$f":"SUM(G40+G45)","v":0},null,null,null,null," Total de points de travail collaboratifs",{"$f":"SUM(M40+M45)","v":0}]

{"sheet":"Annexe","index":2,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,6,0,7],[20,0,25,0],[9,0,11,0],[16,0,19,0],[12,0,15,0],[4,0,5,0],[6,0,8,0],[2,1,2,7]]}
["ANNEXE: DÉTAILS DES POINTS DE TRAVAIL DU Milieu de travail GC",null,null,null,null,null,"Retour à «À propos du Cahier»"]
[]
["POINTS DE TRAVAIL","Un point de travail est un espace où quelqu'un peut effectuer son travail et est conçu spécifiquement pour prendre en charge différentes exigences fonctionnelles et/ou préférences personnelles. Chaque point de travail est équipé de mobilier et d'outils numériques qui prennent en charge une variété de tâches et divers degrés d'interaction ou de concentration."]
[null,"Nom des points de travail","Activité et durée typique","Nombre de siège","Niveau de confidentialité visuel","Niveau de confidentialité acoustique","Taille typique","Zone recommendée"]
[{"$f":"HIDE!A6","v":"PRIMAIRE INDIVIDUEL OUVERT"},{"$f":"HIDE!B6","v":"Poste de travail"},"Travail de concentration sur le moyen-long terme",1,"Faible-Moyen","Faible",{"$f":"[1]HIDE!C6","v":3.5},"Toutes"]
[null,{"$f":"HIDE!B7","v":"Capsule de travail"},"Travail de concentration à court et moyen terme dans un mobilier semi-fermé",1,"Faible-Moyen","Faible",{"$f":"[1]HIDE!C7","v":2.5},"Tranquille/Transitionnelle"]
[{"$f":"HIDE!A8","v":"PRIMAIRE INDIVIDUEL FERMÉ"},{"$f":"HIDE!B8","v":"Salle de concentration"},"Travail de concentration sur le moyen-long terme",1,"Moyen-Élevé","Moyen",{"$f":"[1]HIDE!C8","v":7.5},"Toutes"]
[null,{"$f":"HIDE!B9","v":"Espace ministériel dédié\n(sous-ministre ou ministre)"},"Bureau dédié (dont la salle de bain de 9m2) pour un Ministre",1,"Moyen-Élevé","Moyen-Élevé",{"$f":"[1]HIDE!C9","v":29},"Transitionnelle"]
[null,{"$f":"HIDE!B10","v":"Salle d'étdue\n(5m2 par occupant)"},"Salle de concentration partagée à court, moyen et long terme pour un travail ciblé avec une variété de points de travail individuels",1,"Faible-Moyen","Moyen",{"$f":"[1]HIDE!C10","v":4},"Tranquille"]
[{"$f":"HIDE!A11","v":"SECONDAIRE INDIVIDUEL"},{"$f":"HIDE!B11","v":"Capsule de concentration"},"Travail de concentration à court et moyen terme dans un mobilier informels semi-fermé",1,"Faible-Moyen","Faible",{"$f":"[1]HIDE!C11","v":2.5},"Tranquille"]
[null,{"$f":"HIDE!B12","v":"Point de transition\n(1.5m2 par occupant)"},"Espace de transition à court terme à utiliser entre les activités",1,"Faible","Faible",{"$f":"[1]HIDE!C12","v":1.5},"Toutes"]
[null,{"$f":"HIDE!B13","v":"Cabine / Salle Téléphonique"},"Salle à court terme pour les appels téléphoniques",1,"Moyen","Moyen-Élevé",{"$f":"[1]HIDE!C13","v":5},"Toutes"]
[{"$f":"HIDE!A14","v":"COLLABORATIF OUVERT"},{"$f":"HIDE!B14","v":"Point de discussion"},"Espace pour de brèves conversations impromptues",4,"Faible","Faible",{"$f":"[1]HIDE!C14","v":4},"Interactive/Transitionnelle"]
[null,{"$f":"HIDE!B15","v":"Enclave"},"Espace de rencontre informel court-moyen terme, ouvert ou semi-fermé",4,"Faible-Moyen","Faible",{"$f":"[1]HIDE!C15","v":5},"Interactive/Transitionnelle"]
[null,{"$f":"HIDE!B16","v":"Zone d'équipe"},"Zone informelle pour soutenir le travail d'équipe à moyen terme et la génération d'idées",8,"Faible-Moyen","Faible",{"$f":"[1]HIDE!C16","v":15},"Interactive"]
[null,{"$f":"HIDE!B17","v":"Salon"},"Aire ouverte avec des meubles pour manger et/ou interagir socialement","10+","Faible","Faible",{"$f":"[1]HIDE!C17","v":10},"Interactive/Transitionnelle"]
[{"$f":"HIDE!A18","v":"COLLABORATIF FERMÉ"},{"$f":"HIDE!B18","v":"Salle de travail"},"Salle fermée pour travail d'équipe à court et moyen terme ou réunions informelles",6,"Moyen-Élevé","Moyen",{"$f":"[1]HIDE!C18","v":16},"Interactive/Transitionnelle"]
[null,{"$f":"HIDE!B19","v":"Salle de projet"},"Salle fermée pour travail collaboratif ou créatif à moyen et long terme",8,"Moyen-Élevé","Moyen",{"$f":"[1]HIDE!C19","v":20},"Interactive/Transitionnelle"]
[null,{"$f":"HIDE!B20","v":"Salle de réunion moyenne"},"Salle fermée pour travail d'équipe à court et moyen terme ou réunions",12,"Moyen-Élevé","Moyen-Élevé",{"$f":"[1]HIDE!C20","v":32},"Interactive/Transitionnelle"]
[null,{"$f":"HIDE!B21","v":"Grande salle de réunion"},"Salle fermée pour réunions formelles et présentations","20+","Moyen-Élevé","Moyen-Élevé",{"$f":"[1]HIDE!C21","v":60},"Interactive/Transitionnelle"]
[{"$f":"HIDE!A22","v":"ESPACE À USAGE GÉNÉRAL"},{"$f":"HIDE!B22","v":"Cuisinette"},"Menuiserie de cuisine et appareils électroménagers uniquement - à combiner avec un salon pour inclure des sièges","N/A","Moyen","Moyen",{"$f":"[1]HIDE!C22","v":5},"Interactive/Transitionnelle"]
[null,{"$f":"HIDE!B23","v":"Salle de mieux-être"},"Salle de relaxation de courte à moyenne durée",1,"Moyen-Élevé","Moyen",{"$f":"[1]HIDE!C23","v":7.5},"Tranquille/Transitionnelle"]
[null,{"$f":"HIDE!B24","v":"Salle d'équipement"},"Centre d'affaires et imprimantes","N/A","Faible","Faible",{"$f":"[1]HIDE!C24","v":5},"Transitionnelle"]
[null,{"$f":"HIDE!B25","v":"Casiers\n(Espace par ETP)"},"Casiers de rangement individuels dans une zone centralisée, bancs et vestiaires","N/A","Faible","Faible",{"$f":"[1]HIDE!C25","v":0.5},"Transitionnelle"]
[null,{"$f":"HIDE!B26","v":"Rangement partagé"},"Espace ouvert ou fermé pour les ressources partagées ou le classement","N/A","Faible","Faible",{"$f":"[1]HIDE!C26","v":5},"Transitionnelle"]
[null,{"$f":"HIDE!B27","v":"Salle des serveurs/télécommunication dédiée (1 par étage)"},"Pièce fermée pour que les systèmes de télécommunication soient accessibles depuis l'extérieur de la zone sécurisée à côté du hall de l'ascenseur","N/A","N/A","N/A",{"$f":"[1]HIDE!C27","v":10},"N/A"]

{"sheet":"HIDE","index":3,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":true,"merged":[[2,13,2,14],[2,5,2,9],[3,5,3,9],[3,13,3,14],[5,0,6,0],[7,0,9,0],[10,0,12,0],[27,0,31,0],[26,5,26,9],[32,0,33,0],[13,0,16,0],[17,0,20,0],[21,0,26,0]]}
["FORMULAS AND CALCULATIONS"]
["HEADINGS IN RED INDICATE COLUMNS WHERE DATA CAN BE ALTERED. HEADINGS IN BLACK ARE CALCULATED USING FORMULAS."]
["Names input here are what the \"Dashboard\" and \"Appendix\" use to populate the name of workpoint categories","Names input here are what the \"Dashboard\" and \"Appendix\" use to populate workpoint names","This column identifies the m2 that the Reset button on the \"Dashboard\" uses in the Suggested Size column. This column is also used to populate the Suggested Size column on the \"Appendix\" tab.","This column identifies the m2 at which cells in the Suggested Size column on the \"Dashboard\" turn orange.","This is the factor used to calculate minimum permitted quantity (column \"N\" on this tab).","These columns set the quantity baselines for a target occupancy of 100. Values may be determined by a formula or be a manual input.",null,null,null,null,"This is the factor used to calculate maximum permitted quantity (column \"O\" on this tab).","This determines what activity profile on the \"Dashboard\" and displays the suggested quantities for a target occupancy of 100.","This uses the Activity Profile column on this sheet and determines the suggested number of workpoints based on Target Occupancy input in the \"Dashboard\". These quantites are used to populate the Standard Allocation columns on the \"Dashboard\"","These columns calculate, and round, the quantity range for each workpoint based on target occupancy (or SPS population for rows 28 to 32) result from m2 input in the \"Dashboard\". These quantities are used to determine when a cell should go blue or orange when a user adjusts the sliders."]
["TYPE","WORKPOINT","SUGGESTED SIZE","MAX. SIZE",null,"QTY. FOR 100 PEOPLE (1100m2u)",null,null,null,null,null,"ACTIVITY PROFILE","SUGGESTED QTY.","QTY. RANGE",null,"COMMENTS"]
[null,null,null,null,"FACTOR","MINIMUM","AUTONOMOUS","BALANCED","INTERACTIVE","MAXIMUM","FACTOR",{"$f":"IF('Tableau de Bord'!C8=1,\"AUTONOMOUS\",IF('Tableau de Bord'!C8=2,\"BALANCED\",\"INTERACTIVE\"))","v":"AUTONOMOUS"},null,"LOW","HIGH"]
["PRIMAIRE INDIVIDUEL OUVERT","Poste de travail",3.5,4.5,{"$f":"F6/100","v":0.15},15,40,30,20,60,{"$f":"J6/100","v":0.6},{"$f":"CHOOSE('Tableau de Bord'!$C$8, G6,H6,I6)","v":40},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L6/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E6, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K6, 0)","v":0}]
[null,"Capsule de travail",2.5,3.5,0.02,2,5,4,3,10,0.1,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G7,H7,I7)","v":5},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L7/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E7, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K7, 0)","v":0}]
["PRIMAIRE INDIVIDUEL FERMÉ","Salle de concentration",7.5,10,0.04,4,9,8,7,12,0.12,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G8,H8,I8)","v":9},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L8/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E8, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K8, 0)","v":0}]
[null,"Espace ministériel dédié\n(sous-ministre ou ministre)",29,29,0,0,0,0,0,0,0,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G9,H9,I9)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L9/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E9, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K9, 0)","v":0}]
[null,"Salle d'étdue\n(5m2 par occupant)",5,5,0.04,4,8,8,8,15,0.15,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G10,H10,I10)","v":8},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L10/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E10, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K10, 0)","v":0}]
["SECONDAIRE INDIVIDUEL","Capsule de concentration",4,4,0,0,2,2,2,6,0.06,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G11,H11,I11)","v":2},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L11/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E11, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K11, 0)","v":0}]
[null,"Point de transition\n(1.5m2 par occupant)",1.5,2,0.08,8,12,14,16,30,0.3,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G12,H12,I12)","v":12},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L12/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E12, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K12, 0)","v":0}]
[null,"Cabine / Salle Téléphonique",6.5,6.5,0.02,2,7,6,4,10,0.1,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G13,H13,I13)","v":7},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L13/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E13, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K13, 0)","v":0}]
["COLLABORATIF OUVERT","Point de discussion",4,8,0,0,0,0,0,5,0.05,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G14,H14,I14)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L14/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E14, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K14, 0)","v":0}]
[null,"Enclave",7,7,0,0,1,1,2,6,0.06,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G15,H15,I15)","v":1},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L15/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E15, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K15, 0)","v":0}]
[null,"Zone d'équipe",15,20,0.01,1,1,1,2,4,0.04,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G16,H16,I16)","v":1},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L16/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E16, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K16, 0)","v":0}]
[null,"Salon",10,15,0.01,1,2,2,2,3,0.03,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G17,H17,I17)","v":2},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L17/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E17, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K17, 0)","v":0}]
["COLLABORATIF FERMÉ","Salle de travail",16,20,0.01,1,3,3,4,6,0.06,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G18,H18,I18)","v":3},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L18/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E18, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K18, 0)","v":0}]
[null,"Salle de projet",20,25,0.01,1,1,2,3,6,0.06,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G19,H19,I19)","v":1},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L19/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E19, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K19, 0)","v":0}]
[null,"Salle de réunion moyenne",32,40,0.01,1,1,2,2,4,0.04,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G20,H20,I20)","v":1},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L20/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E20, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K20, 0)","v":0}]
[null,"Grande salle de réunion",60,70,0,0,1,1,1,2,0.02,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G21,H21,I21)","v":1},{"$f":"ROUNDDOWN('Tableau de Bord'!$E$14*HIDE!L21/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E21, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K21, 0)","v":0}]
["ESPACE À USAGE GÉNÉRAL","Cuisinette",{"$f":"IF('Tableau de Bord'!$E$14<25,5,IF(AND('Tableau de Bord'!$E$14>=25,'Tableau de Bord'!$E$14<50),10,15))","v":5},"N/A","N/A",1,1,1,1,1,"N/A",{"$f":"CHOOSE('Tableau de Bord'!$C$8, G22,H22,I22)","v":1},{"$f":"IF('Tableau de Bord'!$E$14=0,0,ROUNDUP('Tableau de Bord'!$E$14/150,0))","v":0},{"$f":"ROUNDUP('Tableau de Bord'!$E$14/150, 0)","v":0},{"$f":"ROUNDUP('Tableau de Bord'!$E$14/150, 0)","v":0},"1-5m2 for 1-24 occupants; 1-10m2 for 25-49 occupants; 1-15m2 for 50-150 occupants; 2-15m2 for 151-300 occupants and so on"]
[null,"Salle de mieux-être",7.5,10,"N/A",1,1,1,1,2,"N/A",{"$f":"CHOOSE('Tableau de Bord'!$C$8, G23,H23,I23)","v":1},{"$f":"IF('Tableau de Bord'!$E$14=0,0,ROUNDUP('Tableau de Bord'!$E$14*HIDE!L23/100,0))","v":0},1,{"$f":"ROUNDUP('Tableau de Bord'!$E$14/50, 0)","v":0},"WAS:  -  1s-7,5m2 for  every 50 occupants   New(Jan 2024)  :1x-7.5m2 for every 100 occupants "]
[null,"Salle d'équipement",5,10,{"$f":"F24/100","v":0.01},1,1,1,1,2,{"$f":"J24/100","v":0.02},{"$f":"CHOOSE('Tableau de Bord'!$C$8, G24,H24,I24)","v":1},{"$f":"IF('Tableau de Bord'!$E$14=0,0,ROUNDUP('Tableau de Bord'!$E$14*HIDE!L24/100,0))","v":0},{"$f":"ROUNDUP('Tableau de Bord'!$E$14*E24, 0)","v":0},{"$f":"ROUNDUP('Tableau de Bord'!$E$14*K24, 0)","v":0},"WAS:  1x-5m2 for every 50 occupants   New(Jan 2024)  :1x-5m2 for every 100 occupants "]
[null,"Casiers\n(Espace par ETP)",0.5,"N/A",{"$f":"F25/100","v":0.5},50,100,100,100,100,{"$f":"J25/100","v":1},{"$f":"CHOOSE('Tableau de Bord'!$C$8, G25,H25,I25)","v":100},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L25/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E25, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K25, 0)","v":0},"At least 1 per occupants (include space for coat closets and benches)"]
[null,"Rangement partagé",5,10,{"$f":"F26/100","v":0},0,0,0,0,1,{"$f":"J26/100","v":0.01},{"$f":"CHOOSE('Tableau de Bord'!$C$8, G26,H26,I26)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*HIDE!L26/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*E26, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$14*K26, 0)","v":0},"Default is 0. 1-5m2 per 100 occupants"]
[null,"Salle des serveurs/télécommunication dédiée (1 par étage)",10,"N/A","N/A","This workpoint always defaults to 1 regardless of m2, except when m2 = 0, then it defaults to 0",null,null,null,null,"N/A",{"$f":"IF('Tableau de Bord'!E13=0,0,1)","v":0},{"$f":"L27","v":0},0,{"$f":"L27","v":0},"Default is 1, but can be removed if not needed"]
["POINT DE TRAVAIL SUPPLÉMENTAIRES POUR LA POPULATION DU LUP ADJACENT","Cabine / Salle Téléphonique",6.5,6.5,{"$f":"F28/100","v":0.04},4,6,5,4,8,{"$f":"J28/100","v":0.08},{"$f":"CHOOSE('Tableau de Bord'!$C$8, G28,H28,I28)","v":6},{"$f":"ROUND('Tableau de Bord'!$E$17*HIDE!L28/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$17*E28,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$17*K28,0)","v":0}]
[null,"Salon",10,15,{"$f":"F29/100","v":0.02},2,2,2,2,3,{"$f":"J29/100","v":0.03},{"$f":"CHOOSE('Tableau de Bord'!$C$8, G29,H29,I29)","v":2},{"$f":"ROUND('Tableau de Bord'!$E$17*HIDE!L29/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$17*E29,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$17*K29,0)","v":0}]
[null,"Salle de travail",15,20,{"$f":"F30/100","v":0.02},2,2,3,4,6,{"$f":"J30/100","v":0.06},{"$f":"CHOOSE('Tableau de Bord'!$C$8, G30,H30,I30)","v":2},{"$f":"ROUND('Tableau de Bord'!$E$17*HIDE!L30/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$17*E30,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$17*K30,0)","v":0}]
[null,"Cuisinette",{"$f":"IF('Tableau de Bord'!$E$17<25,5,IF(AND('Tableau de Bord'!$E$17>=25,'Tableau de Bord'!$E$17<50),10,15))","v":5},"N/A","N/A",1,1,1,1,1,"N/A",{"$f":"CHOOSE('Tableau de Bord'!$C$8, G31,H31,I31)","v":1},{"$f":"IF('Tableau de Bord'!$E$17=0, 0, ROUNDUP('Tableau de Bord'!$E$17/150,0))","v":0},{"$f":"ROUNDUP('Tableau de Bord'!$E$17/150, 0)","v":0},{"$f":"ROUNDUP('Tableau de Bord'!$E$17/150, 0)","v":0},"1-5m2 for 1-24 occupants; 1-10m2 for 25-49 occupants; 1-15m2 for 50-150 occupants; 2-15m2 for 151-300 occupants and so on"]
[null,"Casiers\n(Espace par ETP)",0.5,"N/A",{"$f":"F32/100","v":1},100,100,100,100,125,{"$f":"J32/100","v":1.25},{"$f":"CHOOSE('Tableau de Bord'!$C$8, G32,H32,I32)","v":100},{"$f":"ROUND('Tableau de Bord'!$E$17*HIDE!L32/100,0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$17*E32, 0)","v":0},{"$f":"ROUND('Tableau de Bord'!$E$17*K32, 0)","v":0}]
["AUTRE","Espace de soutien personnalisé",{"$f":"ROUND('Tableau de Bord'!Q7*0.01,0)","v":0},{"$f":"ROUND('Tableau de Bord'!Q7*0.015,0)","v":0},"N/A",null,null,null,null,null,null,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G33,H33,I33)","v":0},{"$f":"CHOOSE('Tableau de Bord'!$C$8, H33,I33,J33)","v":0},0,0,"Can be used as required. Default size is 1% of total space for planning. Minimum is 0% and Maximum is 1.5%"]
[null,"Point de travail personnalisé",0,"N/A","N/A",null,null,null,null,null,null,{"$f":"CHOOSE('Tableau de Bord'!$C$8, G34,H34,I34)","v":0},{"$f":"CHOOSE('Tableau de Bord'!$C$8, H34,I34,J34)","v":0},0,0,"If adding a custom workpoint to support a specific function, specify quantity and size. Equal quantities of other workpoints will need to be reduced. Justification is required."]
[]
["ACTIVITY PROFILE DROPDOWN LIST"]
["Autonome"]
["Équilibré"]
["Interactif"]