{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Introduction","Organisme_logement","Menage","Pension_alimentaire","Revenus","Calcul","Charges_deductions","Remarques_bail","Loyer_a_payer","Feuille de travail","Parametres","Impr_PSL_FR","Impr_PSL_EN","Impr_PSL_annexe","Impr_non_PSL","Impr_non_PSL_annexe","Impr_bail_FR","Impr_bail_EN","Report"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":228,"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":"Introduction","index":0,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":false,"merged":[[18,2,18,33],[20,1,20,33],[22,3,23,33],[25,1,25,33],[1,9,1,25],[2,9,2,25],[4,1,4,33],[6,1,6,33],[12,21,12,24],[16,2,16,33]]}
[]
[null,null,null,null,null,null,null,null,null,"FEUILLE DE CALCUL DÉTAILLÉ"]
[null,null,null,null,null,null,null,null,null,"DU LOYER TOTAL À PAYER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"NO_VERSION","v":"2026.01"}]
[null,"INTRODUCTION AU FICHIER"]
[]
[null,"Bienvenue dans le fichier du Règlement sur les conditions de location des logements à loyer modique conçu par la Société d’habitation du Québec, dans le but de faciliter le calcul du loyer."]
[]
[null,"Pour une utilisation efficace de ce fichier, voici cinq consignes à respecter :"]
[]
[null,"1.","Assurez-vous d’avoir la dernière version du fichier avant d’effectuer vos calculs ;"]
[]
[null,"2.","Saisissez toujours vos données dans les cellules",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JAUNES",null,null,null,null,"seulement ;"]
[]
[null,"3. ","Utilisez la touche",null,null,null,null,null,null,null,null,null,"pour vous déplacer rapidement d’une cellule à l’autre ;"]
[]
[null,"4.","Assurez-vous d’être sorti du champ dans lequel vous venez de saisir une donnée lorsque vous noircissez les cases à cocher ou les boutons radio (en cliquant dans une autre cellule ou en appuyant sur la touche                  ) ;"]
[]
[null,"5.","Appuyez toujours sur le bouton                         (au bas de chaque feuille) lorsque vous avez terminé la saisie de chaque feuille séquentiellement."]
[]
[null,"Pour plus d’informations ou de précisions sur le fonctionnement du fichier, n’hésitez pas à consulter le Guide explicatif fourni avec ce fichier."]
[]
[null,"N.B.",null,"Afin que nous puissions mieux vous servir, veuillez porter à notre attention tout problème ou erreur que vous détecterez dans le présent fichier."]
[]
[]
[null,"FIN DE LA PAGE"]

{"sheet":"Organisme_logement","index":1,"n_rows":29,"n_cols":28,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,10,20,14],[1,9,1,25],[2,9,2,25],[4,1,4,33],[6,5,6,33],[8,5,8,33],[9,5,9,33],[13,1,13,33],[15,29,15,33],[17,5,17,23],[17,29,17,33],[18,5,18,33],[22,1,22,33],[24,14,24,15],[25,6,25,7],[25,9,25,10],[25,12,25,13],[25,21,25,22],[25,24,25,25],[25,27,25,28],[28,1,28,33],[26,6,26,7],[26,9,26,10],[26,12,26,13],[26,21,26,22],[26,24,26,25],[26,27,26,28]]}
[null,null,null,null,null,null," Impression:"]
[]
[null,null,null,null,null,null,null,null,null,"FEUILLE DE CALCUL DÉTAILLÉ\nDU LOYER TOTAL À PAYER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"NO_VERSION","v":"2026.01"}]
[null,"IDENTIFICATION DE L'ORGANISME"]
[]
[null,"Nom"]
[]
[null,"Adresse"]
[]
[]
[null,null,null,null,null,"Votre organisme est-il une coopérative d'habitation?"]
[]
[null,"IDENTIFICATION DU LOGEMENT"]
[]
[null,null,null,null,null,null,"PSL ou PSLQ",null,null,null,null,null,null,null,null,null,null,"Numéro de l'unité de logement"]
[]
[null,"Adresse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"App."]
[]
[]
[null,"Nombre de chambres"]
[]
[null,"DURÉE DU BAIL OU DE LA SUBVENTION"]
[]
[null,"Durée du bail ou de la subvention",null,null,null,null,null,null,null,null,null,null,null,null,12,null," mois"]
[null,null,null,null,null,null,"A",null,null,"M",null,null,"J",null,null,null,null,null,null,null,null,"A",null,null,"M",null,null,"J"]
[null,"débutant le",null,null,null,null,null,null,null,4,null,null,1,null,null,"et finissant le",null,null,null,null,null,null,null,null,4,null,null,1]
[]
[null,"FIN DE LA PAGE"]

{"sheet":"Menage","index":2,"n_rows":19,"n_cols":30,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,33],[6,1,6,3],[6,5,6,12],[6,14,6,15],[8,1,8,3],[8,5,8,12],[8,14,8,15],[10,1,10,3],[10,5,10,12],[10,14,10,15],[12,1,12,3],[12,5,12,12],[12,14,12,15],[18,1,18,33],[14,1,14,3],[14,5,14,12],[14,14,14,15],[16,1,16,3],[16,5,16,12],[16,14,16,15]]}
[]
[null,"IDENTIFICATION DU MÉNAGE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Famille",null,"Mineur",null,null,null,null,null,"Lien de"]
[null,null,null,null,null,"Prénom et nom",null,null,null,null,null,null,null,null,"Âge",null,null,"Étud.",null,"Hand.",null,"accueil",null,"émanc.",null,"Sexe",null,null,null,"parenté"]
[]
[null,"Occ. 1"]
[]
[null,"Occ. 2"]
[]
[null,"Occ. 3"]
[]
[null,"Occ. 4"]
[]
[null,"Occ. 5"]
[]
[null,"Occ. 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"FIN DE LA PAGE"]

{"sheet":"Pension_alimentaire","index":3,"n_rows":29,"n_cols":36,"rows_kept":29,"cut":false,"hidden":false,"merged":[[11,26,11,29],[9,18,9,21],[10,18,10,21],[10,34,10,37],[11,30,11,33],[11,34,11,37],[10,26,10,29],[10,30,10,33],[28,1,28,37],[1,1,1,37],[3,14,3,17],[3,18,3,21],[3,22,3,25],[3,26,3,29],[3,30,3,33],[3,34,3,37],[4,14,4,17],[4,18,4,21],[4,22,4,25],[4,26,4,29],[4,30,4,33],[4,34,4,37],[5,30,5,33],[5,34,5,37],[7,22,7,25],[5,26,5,29],[11,14,11,17],[11,18,11,21],[7,14,7,17],[7,18,7,21],[8,22,8,25],[5,18,5,21],[5,22,5,25],[9,22,9,25],[11,22,11,25],[8,18,8,21],[7,26,7,29],[10,22,10,25],[8,26,8,29],[9,26,9,29],[7,30,7,33],[7,34,7,37],[8,30,8,33],[8,34,8,37],[9,30,9,33],[9,34,9,37],[12,14,12,17],[12,18,12,21],[20,1,20,37],[22,1,22,37],[24,1,24,37],[19,1,19,37],[21,1,21,37],[23,1,23,37],[14,1,14,37],[12,22,12,25],[12,26,12,29],[12,30,12,33],[12,34,12,37],[25,1,25,37],[27,1,27,37],[15,35,15,37],[15,14,15,21],[26,1,26,37]]}
[]
[null,"ANNEXE - CALCUL PENSION ALIMENTAIRE REÇUE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Occ. 1",null,null,null,"Occ. 2",null,null,null,"Occ. 3",null,null,null,"Occ. 4",null,null,null,"Occ. 5",null,null,null,"Occ. 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CEL_NOM_1=\"\",\"\",LEFT(CEL_NOM_1,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_2=\"\",\"\",LEFT(CEL_NOM_2,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_3=\"\",\"\",LEFT(CEL_NOM_3,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_4=\"\",\"\",LEFT(CEL_NOM_4,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_5=\"\",\"\",LEFT(CEL_NOM_5,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_6=\"\",\"\",LEFT(CEL_NOM_6,12))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Lien occupant]",null,null,null,"[Lien occupant]",null,null,null,"[Lien occupant]",null,null,null,"[Lien occupant]",null,null,null,"[Lien occupant]"]
[null,"Pension alimentaire reçue"]
[null,"(A) Pension alimentaire reçue comme ex-conjoint"]
[null,"(B) Pension alimentaire reçue par enfant"]
[null,"(C) Déduction pour pension alimentaire pour chacun des enfants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S9<>\"\",-6000,0)","v":0},null,null,null,{"$f":"IF(W9<>\"\",-6000,0)","v":0},null,null,null,{"$f":"IF(AA9<>\"\",-6000,0)","v":0},null,null,null,{"$f":"IF(AE9<>\"\",-6000,0)","v":0},null,null,null,{"$f":"IF(AI9<>\"\",-6000,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S9>-S10,S9+S10,0)","v":0},null,null,null,{"$f":"IF(W9>-W10,W9+W10,0)","v":0},null,null,null,{"$f":"IF(AA9>-AA10,AA9+AA10,0)","v":0},null,null,null,{"$f":"IF(AE9>-AE10,AE9+AE10,0)","v":0},null,null,null,{"$f":"IF(AI9>-AI10,AI9+AI10,0)","v":0}]
[null,"(D) Pension alimentaire des enfants",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(($S$6:$AL$6=\"Enfant occ. 1\")*$S$11:$AL$11)","v":0},null,null,null,{"$f":"SUMPRODUCT(($W$6:$AL$6=\"Enfant occ. 2\")*$W$11:$AL$11)","v":0},null,null,null,{"$f":"SUMPRODUCT(($W$6:$AL$6=\"Enfant occ. 3\")*$W$11:$AL$11)","v":0},null,null,null,{"$f":"SUMPRODUCT(($W$6:$AL$6=\"Enfant occ. 4\")*$W$11:$AL$11)","v":0},null,null,null,{"$f":"SUMPRODUCT(($W$6:$AL$6=\"Enfant occ. 5\")*$W$11:$AL$11)","v":0},null,null,null,{"$f":"SUMPRODUCT(($W$6:$AL$6=\"Enfant occ. 6\")*$W$11:$AL$11)","v":0}]
[null,"(E) 52. Pension alimentaire reçue (note 1)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O8+O12","v":0},null,null,null,{"$f":"S8+S12","v":0},null,null,null,{"$f":"W8+W12","v":0},null,null,null,{"$f":"AA8+AA12","v":0},null,null,null,{"$f":"AE8+AE12","v":0},null,null,null,{"$f":"AI8+AI12","v":0}]
[]
[null,"FIN DE LA PAGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Version \" & NO_VERSION","v":"Version 2026.01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2026-03-19T13:53:03.070"}]
[]
[]
[]
[null,"Note 1:"]
[null,"Les pensions alimentaires que le ménage reçoit doivent être déclarées."]
[null,"Seules celles reçues pour les enfants auront droit à une déduction, d’un montant annuel maximal de 6 000 $ (500 $ par mois) par enfant."]
[null,"Les occupants sont identifiés dans les titres de colonnes au haut du tableau."]
[null,"Vous devez dans un premier temps définir les liens entre les occupants du ménage, en utilisant les menus déroulants (par exemple, dans la colonne de l’occupant 2, sélectionnez Conjoint occ. 1 si l’occupant 2 est le conjoint de l’occupant 1)."]
[null,"À la ligne A, saisissez le montant de la pension alimentaire reçue comme ex-conjoint – seulement si l’occupant identifié dans le titre de la colonne est un parent. Ce montant sera pris en compte dans le calcul du revenu."]
[null,"À la ligne B, si l’occupant identifié dans le titre de la colonne est un enfant, saisissez le montant de la pension alimentaire reçue pour lui (pension alimentaire totale reçue pour les enfants divisée par le nombre d’enfants)."]
[null,"À la ligne C, vous verrez la somme de 6 000 $ (montant annuel maximal de déduction par enfant), qui sera déduite du revenu du ménage. Le montant de la différence s’inscrit automatiquement à la ligne suivante, si le montant de la pension alimentaire pour l’enfant est supérieur à 6 000 $."]
[null,"À la ligne D, si l’occupant identifié dans le titre de la colonne est un parent, vous verrez la somme de toutes les pensions alimentaires reçues pour ses enfants."]
[null,"À la ligne E, vous verrez le montant pris en compte dans le calcul du revenu. Celui-ci sera reporté automatiquement dans la ligne 52 de l’onglet Revenus."]

{"sheet":"Revenus","index":4,"n_rows":78,"n_cols":57,"rows_kept":78,"cut":false,"hidden":false,"merged":[[34,14,34,17],[34,18,34,21],[34,22,34,25],[34,26,34,29],[34,30,34,33],[34,34,34,37],[1,1,1,37],[3,7,3,9],[3,14,3,17],[3,18,3,21],[3,22,3,25],[3,26,3,29],[3,30,3,33],[3,34,3,37],[6,14,6,17],[6,18,6,21],[6,22,6,25],[6,26,6,29],[6,30,6,33],[6,34,6,37],[4,14,4,17],[4,18,4,21],[4,22,4,25],[4,26,4,29],[9,14,9,17],[9,18,9,21],[9,22,9,25],[9,26,9,29],[9,30,9,33],[9,34,9,37],[4,30,4,33],[4,34,4,37],[8,14,8,17],[8,18,8,21],[8,22,8,25],[8,26,8,29],[8,30,8,33],[8,34,8,37],[7,14,7,17],[7,18,7,21],[7,22,7,25],[7,26,7,29],[7,30,7,33],[7,34,7,37],[11,14,11,17],[11,18,11,21],[11,22,11,25],[11,26,11,29],[11,30,11,33],[11,34,11,37],[10,14,10,17],[10,18,10,21],[10,22,10,25],[10,26,10,29],[10,30,10,33],[10,34,10,37],[14,14,14,17],[14,18,14,21],[14,22,14,25],[14,26,14,29],[14,30,14,33],[14,34,14,37],[12,14,12,17],[12,18,12,21],[12,22,12,25],[12,26,12,29],[12,30,12,33],[12,34,12,37],[19,14,19,17],[19,18,19,21],[19,22,19,25],[19,26,19,29],[19,30,19,33],[19,34,19,37],[15,14,15,17],[15,18,15,21],[15,22,15,25],[15,26,15,29],[15,30,15,33],[15,34,15,37],[17,14,17,17],[17,18,17,21],[17,22,17,25],[17,26,17,29],[17,30,17,33],[17,34,17,37],[16,14,16,17],[16,18,16,21],[16,22,16,25],[16,26,16,29],[16,30,16,33],[16,34,16,37],[21,14,21,17],[21,18,21,21],[21,22,21,25],[21,26,21,29],[21,30,21,33],[21,34,21,37],[20,14,20,17],[20,18,20,21],[20,22,20,25],[20,26,20,29],[20,30,20,33],[20,34,20,37],[24,14,24,17],[24,18,24,21],[24,22,24,25],[24,26,24,29],[24,30,24,33],[24,34,24,37],[22,14,22,17],[22,18,22,21],[22,22,22,25],[22,26,22,29],[22,30,22,33],[22,34,22,37],[26,14,26,17],[26,18,26,21],[26,22,26,25],[26,26,26,29],[26,30,26,33],[26,34,26,37],[25,14,25,17],[25,18,25,21],[25,22,25,25],[25,26,25,29],[25,30,25,33],[25,34,25,37],[28,14,28,17],[28,18,28,21],[28,22,28,25],[28,26,28,29],[28,30,28,33],[28,34,28,37],[27,14,27,17],[27,18,27,21],[27,22,27,25],[27,26,27,29],[27,30,27,33],[27,34,27,37],[30,14,30,17],[30,18,30,21],[30,22,30,25],[30,26,30,29],[30,30,30,33],[30,34,30,37],[29,14,29,17],[29,18,29,21],[29,22,29,25],[29,26,29,29],[29,30,29,33],[29,34,29,37],[33,14,33,17],[33,18,33,21],[33,22,33,25],[33,26,33,29],[33,30,33,33],[33,34,33,37],[31,14,31,17],[31,18,31,21],[31,22,31,25],[31,26,31,29],[31,30,31,33],[31,34,31,37],[38,14,38,17],[38,18,38,21],[38,22,38,25],[38,26,38,29],[38,30,38,33],[38,34,38,37],[36,14,36,17],[36,18,36,21],[36,22,36,25],[36,26,36,29],[36,30,36,33],[36,34,36,37],[40,14,40,17],[40,18,40,21],[40,22,40,25],[40,26,40,29],[40,30,40,33],[40,34,40,37],[39,14,39,17],[39,18,39,21],[39,22,39,25],[39,26,39,29],[39,30,39,33],[39,34,39,37],[42,14,42,17],[42,18,42,21],[42,22,42,25],[42,26,42,29],[42,30,42,33],[42,34,42,37],[41,14,41,17],[41,18,41,21],[41,22,41,25],[41,26,41,29],[41,30,41,33],[41,34,41,37],[44,14,44,17],[44,18,44,21],[44,22,44,25],[44,26,44,29],[44,30,44,33],[44,34,44,37],[43,14,43,17],[43,18,43,21],[43,22,43,25],[43,26,43,29],[43,30,43,33],[43,34,43,37],[47,14,47,17],[47,18,47,21],[47,22,47,25],[47,26,47,29],[47,30,47,33],[47,34,47,37],[46,14,46,17],[46,18,46,21],[46,22,46,25],[46,26,46,29],[46,30,46,33],[46,34,46,37],[52,14,52,17],[52,18,52,21],[52,22,52,25],[52,26,52,29],[52,30,52,33],[52,34,52,37],[49,14,49,17],[49,18,49,21],[49,22,49,25],[49,26,49,29],[49,30,49,33],[49,34,49,37],[54,14,54,17],[54,18,54,21],[54,22,54,25],[54,26,54,29],[54,30,54,33],[54,34,54,37],[53,14,53,17],[53,18,53,21],[53,22,53,25],[53,26,53,29],[53,30,53,33],[53,34,53,37],[56,14,56,17],[56,18,56,21],[56,22,56,25],[56,26,56,29],[56,30,56,33],[56,34,56,37],[55,14,55,17],[55,18,55,21],[55,22,55,25],[55,26,55,29],[55,30,55,33],[55,34,55,37],[58,14,58,17],[58,18,58,21],[58,22,58,25],[58,26,58,29],[58,30,58,33],[58,34,58,37],[57,14,57,17],[57,18,57,21],[57,22,57,25],[57,26,57,29],[57,30,57,33],[57,34,57,37],[61,14,61,17],[61,18,61,21],[61,22,61,25],[61,26,61,29],[61,30,61,33],[61,34,61,37],[59,14,59,17],[59,18,59,21],[59,22,59,25],[59,26,59,29],[59,30,59,33],[59,34,59,37],[67,1,67,37],[77,1,77,37],[65,14,65,17],[65,18,65,21],[65,22,65,25],[65,26,65,29],[65,30,65,33],[65,34,65,37],[63,14,63,17],[63,18,63,21],[63,22,63,25],[63,26,63,29],[63,30,63,33],[63,34,63,37]]}
[]
[null,"REVENUS ANNUELS ET DÉDUCTIONS"]
[]
[null,"Année de revenus",null,null,null,null,null,null,null,null,null,null,null,null,"Occ. 1",null,null,null,"Occ. 2",null,null,null,"Occ. 3",null,null,null,"Occ. 4",null,null,null,"Occ. 5",null,null,null,"Occ. 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CEL_NOM_1=\"\",\"\",LEFT(CEL_NOM_1,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_2=\"\",\"\",LEFT(CEL_NOM_2,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_3=\"\",\"\",LEFT(CEL_NOM_3,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_4=\"\",\"\",LEFT(CEL_NOM_4,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_5=\"\",\"\",LEFT(CEL_NOM_5,12))","v":""},null,null,null,{"$f":"IF(CEL_NOM_6=\"\",\"\",LEFT(CEL_NOM_6,12))","v":""},null,null,null,null,null,null," REVENUS ANNUELS : Revenus bruts de l'année civile précédant le début du bail"]
[null,"Pension (retraite)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Année de revenus :",null,null,null,null,null,null,2021,null,null,"Occ. 1","Occ. 2","Occ. 3","Occ. 4","Occ. 5","Occ. 6"]
[null,"11. Pension de vieillesse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 21",null," 22",null," 23",null,"24",null,null,"Ass-E",{"$f":"SUM(O15:R18)","v":0},{"$f":"SUM(S15:V18)","v":0},{"$f":"SUM(W15:Z18)","v":0},{"$f":"SUM(AA15:AD18)","v":0},{"$f":"SUM(AE15:AH18)","v":0},{"$f":"SUM(AI15:AL18)","v":0}]
[null,"12. Allocation suppl. au revenu garanti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 11 Pension de vieillesse",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O8)","v":0},{"$f":"SUM(S8)","v":0},{"$f":"SUM(W8)","v":0},{"$f":"SUM(AA8)","v":0},{"$f":"SUM(AE8)","v":0},{"$f":"SUM(AI8)","v":0}]
[null,"13. Pension du RRQ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 12 Supplément au revenu garanti",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O9)","v":0},{"$f":"SUM(S9)","v":0},{"$f":"SUM(W9)","v":0},{"$f":"SUM(AA9)","v":0},{"$f":"SUM(AE9)","v":0},{"$f":"SUM(AI9)","v":0}]
[null,"14. Rente de conjoint survivant (RRQ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 13 Régie des rentes",null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,"15. Pension d'entreprise (privée/publique)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 14 Autres pensions",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O10:R13)","v":0},{"$f":"SUM(S10:V13)","v":0},{"$f":"SUM(W10:Z13)","v":0},{"$f":"SUM(AA10:AD13)","v":0},{"$f":"SUM(AE10:AH13)","v":0},{"$f":"SUM(AI10:AL13)","v":0}]
[null,"16. Pension d'un régime privé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 61 Intérêts de placements",null,null,null,null,null,null,null,null,null,{"$f":"O39","v":0},{"$f":"S39","v":0},{"$f":"W39","v":0},{"$f":"AA39","v":0},{"$f":"AE39","v":0},{"$f":"AI39","v":0}]
[null,"17. Pension d'un autre pays ou du gouv.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 41 Assurance-emploi",null,null,null,null,null,null,null,null,null,{"$f":"O25","v":0},{"$f":"S25","v":0},{"$f":"W25","v":0},{"$f":"AA25","v":0},{"$f":"AE25","v":0},{"$f":"AI25","v":0}]
[null,"Aide sociale et solidarité sociale (soutien du revenu)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 42 CSST",null,null,null,null,null,null,null,null,null,{"$f":"O26","v":0},{"$f":"S26","v":0},{"$f":"W26","v":0},{"$f":"AA26","v":0},{"$f":"AE26","v":0},{"$f":"AI26","v":0}]
[null,"21. Sans contrainte à l'emploi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 52 Pension alimentaire reçue",null,null,null,null,null,null,null,null,null,{"$f":"O35","v":0},{"$f":"S35","v":0},{"$f":"W35","v":0},{"$f":"AA35","v":0},{"$f":"AE35","v":0},{"$f":"AI35","v":0}]
[null,"22. Avec contraintes temp. à l'emploi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 47 Allocations d'aide à l'emploi",null,null,null,null,null,null,null,null,null,{"$f":"O31","v":0},{"$f":"S31","v":0},{"$f":"W31","v":0},{"$f":"AA31","v":0},{"$f":"AE31","v":0},{"$f":"AI31","v":0}]
[null,"23. Avec contraintes sévères à l'emploi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 48 Rétribution résidences d'accueil",null,null,null,null,null,null,null,null,null,{"$f":"O32","v":0},{"$f":"S32","v":0},{"$f":"W32","v":0},{"$f":"AA32","v":0},{"$f":"AE32","v":0},{"$f":"AI32","v":0}]
[null,"24. Programme de revenu de base (66/72)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 31",null," 32",null," 33",null,"34",null,null,null,{"$f":"SUM(O20:R23)","v":0},{"$f":"SUM(S20:V23)","v":0},{"$f":"SUM(W20:Z23)","v":0},{"$f":"SUM(AA20:AD23)","v":0},{"$f":"SUM(AE20:AH23)","v":0},{"$f":"SUM(AI20:AL23)","v":0}]
[null,"Revenus de travail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 79 Autres revenus",null,null,null,null,null,null,null,null,null,{"$f":"O48","v":0},{"$f":"S48","v":0},{"$f":"W48","v":0},{"$f":"AA48","v":0},{"$f":"AE48","v":0},{"$f":"AI48","v":0}]
[null,"31. Travail salarié",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) Sous-total des revenus"]
[null,"32. Travail à commission, pourboires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," DÉDUCTIONS",null,null,null,null,null,null,null,null,null,"Occ. 1","Occ. 2","Occ. 3","Occ. 4","Occ. 5","Occ. 6"]
[null,"33. Travail à son compte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 81","10 % des revenus de travail",null,null,null,null,null,null,null,null,{"$f":"RV_DED_TRAV1","v":0},{"$f":"RV_DED_TRAV2","v":0}]
[null,"34. Revenu d'entreprise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Seulement pour les occupants 1 et 2)"]
[null,"Prestations diverses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 86","Allocation d'aide à l'emploi"]
[null,"41. Assurance-emploi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Soustraire les premiers 1 560,00 $)"]
[null,"42. Prestation CSST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 88 Rétribution résidences d'accueil"]
[null,"43. Prestation SAAQ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres :",null,"82  83  84  85  89",null,null,null,null,null,null,null,{"$f":"SUM(O54:R57,O60)","v":0}]
[null,"44. Indemn. de victime d'un acte criminel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(2) Sous-total des déductions"]
[null,"45. Assurance-salaire, invalidité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenus annuels considérés"]
[null,"46. Allocation défense civile",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) – (2) = (3)"]
[null,"47. Allocation d'aide à l'emploi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenus mensuels considérés"]
[null,"48. Rétribution pour résidences d'accueil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(3) ÷ 12"]
[null,"Pension (autres)"]
[null,"51. Pension de vétéran"]
[null,"52. Pension alimentaire reçue",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pension_alimentaire!O13","v":0},null,null,null,{"$f":"Pension_alimentaire!S13","v":0},null,null,null,{"$f":"Pension_alimentaire!W13","v":0},null,null,null,{"$f":"Pension_alimentaire!AA13","v":0},null,null,null,{"$f":"Pension_alimentaire!AE13","v":0},null,null,null,{"$f":"Pension_alimentaire!AI13","v":0}]
[null,"Prestation spéciale"]
[null,"55. PCU/PCRE"]
[null,"Revenus autonomes"]
[null,"61. Revenu d'intérêt de placement"]
[null,"62. Revenu de location"]
[null,"63. Revenu d'exploitation agricole"]
[null,"64. Dividendes"]
[null,"65. Intérêts et placements retraite"]
[null,"66. Revenu placement retraite"]
[null,"67. Gain en capital"]
[null,"Autres revenus"]
[null,"71. Bourses d'études"]
[null,"79. Autres revenus"]
[]
[null,"Sous-total des revenus",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O7:R48)","v":0},null,null,null,{"$f":"SUM(S7:V48)","v":0},null,null,null,{"$f":"SUM(W7:Z48)","v":0},null,null,null,{"$f":"SUM(AA7:AD48)","v":0},null,null,null,{"$f":"SUM(AE7:AH48)","v":0},null,null,null,{"$f":"SUM(AI7:AL48)","v":0}]
[]
[null,"Déductions"]
[null,"81. 10 % pour les revenus de travail",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((IF(O57>(O22+O23),MAX((O20+O21),0),MAX((O20+O21+(O22+O23-O57)),0)))*0.1,2)","v":0},null,null,null,{"$f":"ROUND((IF(S57>(S22+S23),MAX((S20+S21),0),MAX((S20+S21+(S22+S23-S57)),0)))*0.1,2)","v":0}]
[null,"82. Frais d'hospitalisation ou d'héberg."]
[null,"83. Pension alimentaire versée"]
[null,"84. TVQ"]
[null,"85. Dépenses travailleurs autonomes"]
[null,"86. Allocation d'aide à l'emploi",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(IF(O31=\"\",0,O31),Parametres!U43)","v":0},null,null,null,{"$f":"MIN(IF(S31=\"\",0,S31),Parametres!U43)","v":0},null,null,null,{"$f":"MIN(IF(W31=\"\",0,W31),Parametres!U43)","v":0},null,null,null,{"$f":"MIN(IF(AA31=\"\",0,AA31),Parametres!U43)","v":0},null,null,null,{"$f":"MIN(IF(AE31=\"\",0,AE31),Parametres!U43)","v":0},null,null,null,{"$f":"MIN(IF(AI31=\"\",0,AI31),Parametres!U43)","v":0}]
[null,"88. Rétribution pour résidences d'accueil",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O32","v":0},null,null,null,{"$f":"S32","v":0},null,null,null,{"$f":"W32","v":0},null,null,null,{"$f":"AA32","v":0},null,null,null,{"$f":"AE32","v":0},null,null,null,{"$f":"AI32","v":0}]
[null,"89. Autres déductions"]
[]
[null,"Sous-total des déductions",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O53:R60)","v":0},null,null,null,{"$f":"SUM(S53:V60)","v":0},null,null,null,{"$f":"SUM(W53:Z60)","v":0},null,null,null,{"$f":"SUM(AA53:AD60)","v":0},null,null,null,{"$f":"SUM(AE53:AH60)","v":0},null,null,null,{"$f":"SUM(AI53:AL60)","v":0}]
[]
[null,"Revenus annuels considérés",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O57>(O22+O23),MAX(((O50-(O22+O23))-(O62-O57)),0),MAX(((O50-(O22+O23))+(O22+O23-O57))-(O62-O57),0))","v":0},null,null,null,{"$f":"IF(S57>(S22+S23),MAX(((S50-(S22+S23))-(S62-S57)),0),MAX(((S50-(S22+S23))+(S22+S23-S57))-(S62-S57),0))","v":0},null,null,null,{"$f":"IF(W57>(W22+W23),MAX(((W50-(W22+W23))-(W62-W57)),0),MAX(((W50-(W22+W23))+(W22+W23-W57))-(W62-W57),0))","v":0},null,null,null,{"$f":"IF(AA57>(AA22+AA23),MAX(((AA50-(AA22+AA23))-(AA62-AA57)),0),MAX(((AA50-(AA22+AA23))+(AA22+AA23-AA57))-(AA62-AA57),0))","v":0},null,null,null,{"$f":"IF(AE57>(AE22+AE23),MAX(((AE50-(AE22+AE23))-(AE62-AE57)),0),MAX(((AE50-(AE22+AE23))+(AE22+AE23-AE57))-(AE62-AE57),0))","v":0},null,null,null,{"$f":"IF(AI57>(AI22+AI23),MAX(((AI50-(AI22+AI23))-(AI62-AI57)),0),MAX(((AI50-(AI22+AI23))+(AI22+AI23-AI57))-(AI62-AI57),0))","v":0}]
[]
[null,"Revenus mensuels considérés",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(O64/12,2)","v":0},null,null,null,{"$f":"ROUND(S64/12,2)","v":0},null,null,null,{"$f":"ROUND(W64/12,2)","v":0},null,null,null,{"$f":"ROUND(AA64/12,2)","v":0},null,null,null,{"$f":"ROUND(AE64/12,2)","v":0},null,null,null,{"$f":"ROUND(AI64/12,2)","v":0}]
[]
[null,"INDEXATION DES REVENUS (FACULTATIF)"]
[]
[null,"À utiliser seulement lors de la reconduction du bail pour les ménages"]
[null,"dont le nombre d'occupants ainsi que les revenus sont stables."]
[]
[null,"Année de l'indexation"]
[]
[null,"Pour indexer les revenus, vous devez inscrire, dans la grille «REVENUS ANNUELS ET DÉDUCTIONS» ci-dessus,"]
[null,"les montants de revenu indexés selon les taux prescrits par la SHQ pour l'occupant concerné."]
[]
[null,"FIN DE LA PAGE"]

{"sheet":"Calcul","index":5,"n_rows":46,"n_cols":25,"rows_kept":46,"cut":false,"hidden":false,"merged":[[14,22,14,26],[11,7,11,14],[12,7,12,14],[11,22,11,26],[12,22,12,26],[13,22,13,26],[1,1,1,33],[4,6,4,14],[6,1,6,33],[7,6,7,14],[9,1,9,33],[36,1,36,33],[24,22,24,26],[38,6,38,13],[38,17,38,21],[43,17,43,21],[27,1,28,33],[25,22,25,26],[45,1,45,33],[39,6,39,13],[39,17,39,21],[40,6,40,13],[40,17,40,21],[41,6,41,13],[41,17,41,21],[15,22,15,26],[33,1,34,33],[17,22,17,26],[18,22,18,26],[16,22,16,26],[23,6,23,10],[23,22,23,26],[20,1,20,33]]}
[]
[null,"IDENTIFICATION DES OCCUPANTS 1 ET 2"]
[]
[null,"L'occupant 1."]
[null,"L'occupant 1,",null,null,null,null,{"$f":"IF(CEL_NOM_1=\"\", \"\", CEL_NOM_1)","v":""}]
[]
[null,{"$f":"IF(CEL_NOM_2=\"\", \"Il n'y a pas d'occupant 2.\", IF(CEL_INDE_2, \"Le revenu de l'occupant 2 est considéré.\", \"Le revenu de l'occupant 2 n'est pas considéré.\"))","v":"Il n'y a pas d'occupant 2."}]
[null,"L'occupant 2,",null,null,null,null,{"$f":"IF(CEL_NOM_2=\"\", \"\", CEL_NOM_2)","v":""}]
[]
[null,"CALCUL DE LA CONTRIBUTION MENSUELLE DE BASE"]
[]
[null,"A)","Occupant 1 :",null,null,null,null,{"$f":"IF(CEL_NOM_1=\"\", \"\", CEL_NOM_1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RV_REV_MENS_CONS1","v":0}]
[null,"B)","Occupant 2 :",null,null,null,null,{"$f":"IF(CEL_NOM_2=\"\", \"\", CEL_NOM_2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CEL_REVE_MENS_2","v":0}]
[null,"C)","Total de A et B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W12+W13","v":0}]
[null,"D)","Contribution mensuelle de base (25 % de C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(W14*0.25,2)","v":0}]
[null,"E)","Abattement (s'il y a lieu)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-CEL_ABAT","v":0}]
[null,"F)","Total de D moins E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W15+W16","v":0}]
[null,"G)","Loyer mensuel minimum de base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CEL_LOYM_BASE","v":0}]
[null,"H)","Loyer mensuel de base (le plus élevé de F et G)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(W17,W18)","v":0}]
[]
[null,"LOYER PROTÉGÉ (SI DEMANDÉ PAR L'OCCUPANT 1)"]
[]
[null,"I)","Loyer mensuel de base de l'année"]
[null,null,"antérieure",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\" + \",DOLLAR(Parametres!U66))","v":" + 50,00 $"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CEL_LOYM_BASE_ANN_ANT>0,CEL_LOYM_BASE_ANN_ANT+Parametres!U66,0)","v":0}]
[null,"J)","Loyer de référence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CEL_NOM_1=\"\",0,IF(Report!L5,MAX(CEL_LOYM_BASE_ANN_ANT,Parametres!U68),MAX(CEL_LOYM_BASE_ANN_ANT,Parametres!U67)))","v":0}]
[null,"K)","Loyer mensuel de base protégé (le plus bas de I et J ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W24=0,MIN(CEL_LOY_MENS_BASE,W25),IF(AND(MIN(W24,W25)<=CEL_LOY_MENS_BASE,MIN(W24,W25)<=W18),W18,MIN(W24,W25)))","v":0}]
[null,null,"sans que ce montant soit inférieur à G, si premier bail, le plus bas de J et H)"]
[null,{"$f":"Report!D55","v":"La mesure ne peut être activée, puisque le ménage n'y est pas éligible."}]
[]
[]
[null,null,"Mesure activée",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L'occupant 1 n'a plus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"droit à la mesure"]
[]
[null,"CONSERVER AU DOSSIER DU LOCATAIRE LA DEMANDE D'APPLICATION POUR LE LOYER PROTÉGÉ TANT ET AUSSI LONGTEMPS QU'IL SERA LOCATAIRE POUR L'ORGANISME."]
[]
[]
[null,"CONTRIBUTION MENSUELLE DES AUTRES OCCUPANTS DU MÉNAGE"]
[]
[null,"Occupant 3 :",null,null,null,null,{"$f":"IF(CEL_NOM_3=\"\", \"\", CEL_NOM_3)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"Report!K62","v":""}]
[null,"Occupant 4 :",null,null,null,null,{"$f":"IF(CEL_NOM_4=\"\", \"\", CEL_NOM_4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"Report!K63","v":""}]
[null,"Occupant 5 :",null,null,null,null,{"$f":"IF(CEL_NOM_5=\"\", \"\", CEL_NOM_5)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"Report!K64","v":""}]
[null,"Occupant 6 :",null,null,null,null,{"$f":"IF(CEL_NOM_6=\"\", \"\", CEL_NOM_6)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"Report!K65","v":""}]
[]
[null,"Contribution mensuelle totale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R39=\"\",0,R39)+IF(R40=\"\",0,R40)+IF(R41=\"\",0,R41)+IF(R42=\"\",0,R42)","v":0}]
[]
[null,"FIN DE LA PAGE"]

{"sheet":"Charges_deductions","index":6,"n_rows":47,"n_cols":27,"rows_kept":47,"cut":false,"hidden":false,"merged":[[13,26,13,30],[15,26,15,30],[16,26,16,30],[10,25,10,27],[1,1,1,33],[3,1,4,33],[6,26,6,30],[8,20,8,22],[8,26,8,30],[18,4,18,12],[18,26,18,30],[20,26,20,30],[44,24,44,28],[29,19,29,23],[31,19,31,23],[33,1,33,33],[22,1,22,33],[26,19,26,23],[28,19,28,23],[46,1,46,33],[35,1,36,33],[38,24,38,28],[39,24,39,28],[40,18,40,22],[40,24,40,28],[41,18,41,22],[41,24,41,28],[42,4,42,12],[42,24,42,28]]}
[]
[null,"CHARGES ADDITIONNELLES MENSUELLES"]
[]
[null,"Note : pour PSL ou PSLQ, ajouter les charges mentionnées ci-après seulement si elles sont incluses dans le coût du loyer inscrit au bail du locataire."]
[]
[]
[null,"Électricité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CHK_ELEC,Parametres!U81+CEL_NBRE_CHAM*Parametres!U82,\"\")","v":""}]
[]
[null,"Climatiseurs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de climatiseurs  ",null,null,null,null,null,null,{"$f":"IF(Report!M65=1,IF(U9=\"\",\"\",U9*Parametres!U83),\"\")","v":""}]
[]
[null,"Le coût du loyer inclut-il un stationnement?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numéro(s)"]
[]
[null,"Premier stationnement"]
[null,"Deuxième stationnement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Report!M97=1,CEL_COUT_STAT,\"\")","v":""}]
[]
[null,"Cuisinière",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CHK_CUIS,Parametres!U100,\"\")","v":""}]
[null,"Réfrigérateur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CHK_REFR,Parametres!U100,\"\")","v":""}]
[]
[null,"Autres :"]
[]
[null,"Total des charges additionnelles mensuelles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA7:AE19)","v":0}]
[]
[null,"DÉDUCTION MENSUELLE POUR APPAREILS MÉNAGERS"]
[]
[]
[]
[null,"Maximum déductible pour appareils ménagers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Report!C11,\"\",Report!K82)","v":0}]
[]
[null,"Cuisinière non fournie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Report!C11,\"\",MIN(Report!K84,T27))","v":0}]
[null,"Réfrigérateur non fourni",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Report!C11,\"\",MIN(Report!K85,T27-T29))","v":0}]
[]
[null,"Déduction mensuelle pour appareils ménagers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Report!C11,\"\",T29+T30)","v":0}]
[]
[]
[]
[null,"Note : pour PSL ou PSLQ, appliquer les déductions mentionnées ci-après seulement si elles ne sont pas incluses dans le coût du loyer inscrit au bail du locataire."]
[]
[]
[null,"Chauffage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!K91","v":""}]
[null,"Eau chaude",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!K92","v":""}]
[null,"Taxe d'eau (montant annuel)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Report!C11),\"\",IF(S41=\"\",\"\",ROUND(S41/12,2)))","v":""}]
[null,"Taxe de cueillette des ordures (montant annuel)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Report!C11),\"\",IF(S42=\"\",\"\",ROUND(S42/12,2)))","v":""}]
[null,"Autres :"]
[]
[null,"Total des déductions mensuelles PSL ou PSLQ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Report!C11), \"\", SUM(Y39:AC43))","v":""}]
[]
[null,"FIN DE LA PAGE"]

{"sheet":"Remarques_bail","index":7,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[10,1,10,33],[11,1,11,33],[13,1,13,33],[15,1,18,33],[1,1,1,33],[3,1,4,33],[6,1,6,33],[7,1,7,33],[8,1,8,33],[9,1,9,33]]}
[]
[null,"REMARQUES"]
[]
[null,"Note : les remarques, inscrites dans cette section, seront reproduites seulement sur le formulaire de reconduction du bail."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FIN DE LA PAGE"]
[]
[null,"Pour imprimer, cliquer sur  le bouton \"Impression SHQ\", situé en haut,  \nà la fin de la barre d'outils qui débute par \"Fichier, Édition…\"."]

{"sheet":"Loyer_a_payer","index":8,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,22,10,26],[1,1,1,33],[2,1,2,33],[4,22,4,26],[7,1,7,33],[8,1,8,33],[25,1,25,5],[25,8,25,12],[25,15,25,19],[25,21,25,27],[25,29,25,33],[12,1,13,28],[17,22,17,26],[18,22,18,26],[19,22,19,26],[21,1,21,33],[26,1,26,5],[26,7,26,13],[26,15,26,19],[26,22,26,26],[26,29,26,33],[31,1,31,5],[31,8,31,12],[31,15,31,19],[31,22,31,26],[31,29,31,33],[27,20,27,21],[27,22,27,26],[27,27,27,28],[27,29,27,33],[29,1,29,33],[27,1,27,5],[27,6,27,7],[27,8,27,12],[27,13,27,14],[27,15,27,19],[32,1,32,5],[32,7,32,13],[32,15,32,19],[32,22,32,26],[32,29,32,33],[37,1,37,5],[37,8,37,12],[37,15,37,19],[37,22,37,26],[37,29,37,33],[33,20,33,21],[33,22,33,26],[33,27,33,28],[33,29,33,33],[35,1,35,33],[33,1,33,5],[33,6,33,7],[33,8,33,12],[33,13,33,14],[33,15,33,19],[45,1,48,33],[38,1,38,5],[38,7,38,13],[38,15,38,19],[38,22,38,26],[38,29,38,33],[39,1,39,5],[39,6,39,7],[39,8,39,12],[39,13,39,14],[39,15,39,19],[39,20,39,21],[39,22,39,26],[39,27,39,28],[39,29,39,33],[41,1,41,33]]}
[]
[null,"INFORMATION OBLIGATOIRE POUR LE CALCUL"]
[null,"DE LA SUBVENTION DE SUPPLÉMENT AU LOYER"]
[]
[null,"Coût du loyer inscrit au bail"]
[null,"(excluant tous les services non reliés à l'habitation)"]
[]
[null,"INFORMATIONS COMPLÉMENTAIRES"]
[null,"POUR LES COOPÉRATIVES D'HABITATION"]
[]
[null,"Rabais de membre établi par la coopérative"]
[null,"(inscrit au bail ou à un contrat en annexe)"]
[null,"Le rabais de membre consenti par la coopérative pour un membre subventionné doit être semblable à celui consenti pour un membre non subventionné."]
[]
[]
[null,"Le locataire est-il membre de la coopérative?"]
[]
[null,"Rabais de membre établi par la coopérative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(GRP_MEMB_COOP=2,IF(CEL_RABA_MEMB=\"\",\"\",CEL_RABA_MEMB),\"\")","v":""}]
[null,"Rabais de membre limité par la réglementation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Report!F11=1,GRP_MEMB_COOP=2),Report!K107,\"\")","v":""}]
[null,"Supplément non membre que doit défrayer le locataire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Report!F11=1,GRP_MEMB_COOP=2),MIN(W18,W19),\"\")","v":""}]
[]
[null,"LOYER MENSUEL TOTAL"]
[]
[null,"Le loyer total que devra débourser mensuellement le ménage correspond à :"]
[]
[null,"Contribution",null,null,null,null,null,null,"Charges",null,null,null,null,null,null,null,null,null,null,null,null,"Loyer mensuel",null,null,null,null,null,null,null,"Supplément"]
[null,"mensuelle",null,null,null,null,null,"additionnelles",null,null,null,null,null,null,null,"Déductions",null,null,null,null,null,null,"total",null,null,null,null,null,null,"non membre"]
[null,{"$f":"IF(Report!C11,\"\",Report!K102+Report!K103)","v":0},null,null,null,null,"+",null,{"$f":"IF(Report!C11,\"\",Report!K104)","v":0},null,null,null,null,"–",null,{"$f":"IF(Report!C11,\"\",Report!K105)","v":0},null,null,null,null,"=",null,{"$f":"IF(Report!C11,\"\",Report!K106)","v":0},null,null,null,null,"+",null,{"$f":"IF(Report!C11,\"\",Report!K108)","v":""}]
[]
[null,"CALCUL DE LA PART DU MÉNAGE (PSL ou PSLQ)"]
[]
[null,"Contribution",null,null,null,null,null,null,"Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,"Part du",null,null,null,null,null,null,"Supplément"]
[null,"mensuelle",null,null,null,null,null,"additionnelles",null,null,null,null,null,null,null,"Déductions",null,null,null,null,null,null,"ménage",null,null,null,null,null,null,"non membre"]
[null,{"$f":"IF(NOT(Report!C11),\"\",Report!K102+Report!K103)","v":""},null,null,null,null,"+",null,{"$f":"IF(NOT(Report!C11),\"\",Report!K104)","v":""},null,null,null,null,"–",null,{"$f":"IF(NOT(Report!C11),\"\",Report!K105)","v":""},null,null,null,null,"=",null,{"$f":"IF(NOT(Report!C11),\"\",Report!K106)","v":""},null,null,null,null,"+",null,{"$f":"IF(NOT(Report!C11),\"\",Report!K108)","v":""}]
[]
[null,"CALCUL DE LA SUBVENTION (PSL ou PSLQ)"]
[]
[null,"Loyer",null,null,null,null,null,null,"Rabais",null,null,null,null,null,null,"Loyer",null,null,null,null,null,null,"Part du",null,null,null,null,null,null,"Supplément"]
[null,"au bail",null,null,null,null,null,"de membre",null,null,null,null,null,null,null,"reconnu",null,null,null,null,null,null,"ménage",null,null,null,null,null,null,"au loyer"]
[null,{"$f":"IF(NOT(Report!C11),\"\",Report!K109)","v":""},null,null,null,null,"–",null,{"$f":"IF(NOT(Report!C11),\"\",Report!K110)","v":""},null,null,null,null,"=",null,{"$f":"IF(NOT(Report!C11),\"\",Report!K111)","v":""},null,null,null,null,"–",null,{"$f":"IF(NOT(Report!C11),\"\",Report!K112)","v":""},null,null,null,null,"=",null,{"$f":"IF(NOT(Report!C11),\"\",Report!K113)","v":""}]
[]
[null,"FIN DE LA PAGE"]
[]
[]
[]
[null,"Pour imprimer, cliquer sur  le bouton \"Impression SHQ\"  situé dans la barre de tâches à l'onglet compléments."]

{"sheet":"Feuille de travail","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Parametres","index":10,"n_rows":116,"n_cols":66,"rows_kept":116,"cut":false,"hidden":true,"merged":[[26,65,29,66],[31,65,35,66],[21,65,24,66],[24,1,24,12],[24,13,24,19],[24,20,24,33],[31,1,31,33],[32,1,33,12],[32,13,32,33],[33,13,33,19],[33,20,33,26],[33,27,33,33],[29,13,29,19],[29,20,29,33],[26,1,26,33],[27,1,27,12],[27,13,27,19],[27,20,27,33],[28,1,28,12],[28,13,28,19],[28,20,28,33],[29,1,29,12],[21,1,21,33],[22,1,22,12],[3,1,3,33],[4,1,4,12],[4,13,4,33],[1,1,1,33],[9,1,9,12],[9,13,9,19],[9,20,9,33],[10,1,10,12],[10,13,10,19],[10,20,10,33],[5,1,5,12],[5,13,5,33],[6,1,6,12],[6,13,6,33],[8,1,8,33],[14,1,14,12],[14,13,14,19],[14,20,14,33],[15,1,15,12],[15,13,15,19],[15,20,15,33],[11,1,11,12],[11,13,11,19],[11,20,11,33],[12,1,12,33],[13,1,13,12],[13,13,13,19],[13,20,13,33],[22,13,22,19],[22,20,22,33],[23,1,23,12],[23,13,23,19],[23,20,23,33],[17,1,17,33],[18,1,18,12],[18,13,18,19],[18,20,18,33],[19,1,19,12],[19,13,19,19],[19,20,19,33],[34,1,34,12],[34,13,34,19],[34,20,34,26],[34,27,34,33],[35,1,35,12],[35,13,35,19],[35,20,35,26],[35,27,35,33],[50,1,50,12],[50,13,50,19],[50,20,50,26],[48,1,48,26],[49,1,49,26],[41,1,41,33],[42,1,42,19],[42,20,42,33],[51,1,51,12],[51,13,51,19],[51,20,51,26],[65,1,65,19],[65,20,65,33],[66,1,66,19],[66,20,66,33],[64,1,64,33],[57,1,57,33],[67,1,67,19],[67,20,67,33],[58,1,58,19],[58,20,58,33],[81,1,81,19],[81,20,81,33],[73,1,73,33],[74,1,74,19],[74,20,74,33],[80,1,80,19],[93,23,93,33],[99,1,99,19],[99,20,99,33],[92,1,92,11],[92,12,92,22],[92,23,92,33],[80,20,80,33],[79,1,79,33],[91,1,91,11],[91,12,91,22],[91,23,91,33],[89,1,89,11],[89,12,89,22],[89,23,89,33],[90,1,90,11],[90,12,90,22],[90,23,90,33],[82,1,82,19],[82,20,82,33],[88,1,88,11],[115,1,115,11],[115,12,115,22],[115,23,115,33],[112,1,112,11],[112,12,112,22],[112,23,112,33],[113,1,113,11],[113,12,113,22],[113,23,113,33],[12,65,19,66],[2,1,2,33],[2,35,2,66],[26,35,29,64],[31,35,35,64],[21,35,24,64],[12,35,15,64],[17,35,19,64],[114,1,114,11],[114,12,114,22],[114,23,114,33],[105,1,105,19],[105,20,105,33],[98,1,98,33],[111,1,111,11],[111,12,111,22],[111,23,111,33],[110,1,110,33],[88,12,88,22],[88,23,88,33],[87,1,87,33],[104,1,104,33],[93,1,93,11],[93,12,93,22]]}
[]
[null,"ANNEXE \nLOYER MINIMUM DE BASE\nSelon la composition du ménage\net selon que l'occupant 1 ou les occupants 1 et 2 reçoivent ou non\ndes prestations d'assistance-emploi en vertu de\nla Loi sur le soutien du revenu et favorisant l'emploi et la solidarité sociale"]
[null,"L'OCCUPANT OU LES OCCUPANTS SONT PRESTATAIRES DE L'ASSISTANCE-EMPLOI (2026)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE DES VALEURS POUR L'ASSITANCE-EMPLOI"]
[null,"Article 8,1 - Ménage sans enfant"]
[null,"Composition du ménage",null,null,null,null,null,null,null,null,null,null,null,"Loyer minimum de base"]
[null,"1 adulte",null,null,null,null,null,null,null,null,null,null,null,207.25]
[null,"2 adultes",null,null,null,null,null,null,null,null,null,null,null,314.5]
[]
[null,"Article 8,2 - Ménage avec enfant sans contrainte à l'emploi"]
[null,"Nombre d'adultes",null,null,null,null,null,null,null,null,null,null,null,"1 enfant",null,null,null,null,null,null,"2 enfants et plus"]
[null,"1 adulte",null,null,null,null,null,null,null,null,null,null,null,268.5,null,null,null,null,null,null,298.75]
[null,"2 adultes et plus",null,null,null,null,null,null,null,null,null,null,null,344.75,null,null,null,null,null,null,368.75]
[null,"Article 8,3 - Ménage avec enfant \noccupants 1 et 2 ont des contraintes temporaires à l'emploi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Est prestataire du programme d'aide sociale, avec contraintes temporaires.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Nombre d'adultes",null,null,null,null,null,null,null,null,null,null,null,"1 enfant",null,null,null,null,null,null,"2 enfants et plus"]
[null,"1 adulte",null,null,null,null,null,null,null,null,null,null,null,310,null,null,null,null,null,null,340.25]
[null,"2 adultes et plus",null,null,null,null,null,null,null,null,null,null,null,416,null,null,null,null,null,null,440]
[]
[null,"Article 8,4 - Ménage avec enfant\nl'un des occupants est sans contrainte et l'autre avec des contraintes temporaires à l'emploi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seulement si le deuxième occupant  : \nEst prestataire du programme d'aide sociale, sans contraintes à l'emploi,\nSinon ce choix appartient à ART 8,7"]
[null,"Nombre d'adultes",null,null,null,null,null,null,null,null,null,null,null,"1 enfant",null,null,null,null,null,null,"2 enfants et plus"]
[null,"2 adultes / 2 adultes et plus",null,null,null,null,null,null,null,null,null,null,null,383.25,null,null,null,null,null,null,407.25]
[]
[null,"Article 8,5 - Ménage avec enfant dont au moins l'un des occupants est bénéficiaire du programme de solidarité sociale (contraintes sévères à l'emploi) - PRESTATIONS RÉGULIÈRES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Est prestataire du programme de solidarité sociale, avec contraintes sévères.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Nombre d'adultes",null,null,null,null,null,null,null,null,null,null,null,"1 enfant",null,null,null,null,null,null,"2 enfants et plus"]
[null,"1 adulte",null,null,null,null,null,null,null,null,null,null,null,382.5,null,null,null,null,null,null,413.75]
[null,"2 adultes et plus",null,null,null,null,null,null,null,null,null,null,null,506.25,null,null,null,null,null,null,531]
[]
[null,"Article 8,6 - Ménage avec enfant dont les occupants sont TOUS bénéficiaires du programme régulier de solidarité sociale (contraintes sévères à l'emploi) – PROGRAMME DE REVENU DE BASE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Est prestataire du programme de revenu de base (66/72).\n\n1. Lorsqu'un ménage avec enfant(s) bénéficie du Programme de revenu de base, il faut toujours vérifier la situation des deux occupants afin d'appliquer le bon loyer minimum. En effet, si les deux occupants reçoivent un revenu de base, le loyer minimum est de 686,25$ ou de 711,00$ selon le nombre d'enfant. Si l'un des occupant ne reçoit pas de revenu de base, c’est le loyer minimum du tableau ci-dessous selon la composition du ménage qui s’applique.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Nombre d'adultes",null,null,null,null,null,null,null,null,null,null,null,"1 enfant",null,null,null,null,null,null,"2 enfants et plus"]
[null,"1 adulte",null,null,null,null,null,null,null,null,null,null,null,477.25,null,null,null,null,null,null,508.5]
[null,"2 adultes",null,null,null,null,null,null,null,null,null,null,null,686.25,null,null,null,null,null,null,711]
[]
[null,"Article 8,7 - Ménage dont l'un des occupants est non prestataire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Est prestataire du programme d'aide sociale, sans contraintes à l'emploi,\nou\nN'est pas prestataire de l'aide sociale et solidarité sociale.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Nombre d'adultes",null,null,null,null,null,null,null,null,null,null,null,"Nombre d'enfants"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,null,null,null,null,null,null,"2 et plus"]
[null,"1 adulte",null,null,null,null,null,null,null,null,null,null,null,207.25,null,null,null,null,null,null,268.5,null,null,null,null,null,null,298.75]
[null,"2 adultes et plus",null,null,null,null,null,null,null,null,null,null,null,314.5,null,null,null,null,null,null,344.75,null,null,null,null,null,null,368.75]
[]
[]
[]
[]
[]
[null,"ALLOCATIONS D'AIDE À L'EMPLOI D'EMPLOI-QUÉBEC (Ne plus modifier, n'est pas dans l'avis d'indexation)"]
[null,"Montant annuel maximal déductible",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1560]
[]
[]
[]
[]
[]
[null,"Article 6,1 - CALCUL DU LOYER MENSUEL DE BASE - Occupant 2"]
[null,"lorsqu'il est un enfant de l'occupant 1 ou de son conjoint"]
[null,"Tranche d'âge",null,null,null,null,null,null,null,null,null,null,null,"18 à 20 ans",null,null,null,null,null,null,"21 à 24 ans"]
[null,"Revenu mensuel maximum considéré",null,null,null,null,null,null,null,null,null,null,null,479,null,null,null,null,null,null,952]
[]
[]
[]
[]
[]
[null,"ABATTEMENT MENSUEL (Ne plus modifier, n'est pas dans l'avis d'indexation)"]
[null,"Montant maximal de l'abattement mensuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[]
[]
[]
[]
[]
[null,"Article 6,2 - LOYER PROTÉGÉ (Mesure pour les travailleurs)"]
[null,"Montant d'indexation du loyer mensuel de base (ne pas modifier)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,"Loyer de référence pour l'occupant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,725]
[null,"Loyer de référence pour les occupants 1 et 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,808]
[]
[]
[]
[]
[]
[null,"Article 10 - CONTRIBUTION MENSUELLE DES PERSONNES INDÉPENDANTES"]
[null,"Contribution maximale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120.5]
[]
[]
[]
[]
[null,"Article 11 - CHARGES ADDITIONNELLES (Le titre de cette section était \"TARIFS D'ÉLECTRICITÉ DOMESTIQUE\" auparavant)"]
[null,"Tarif de base (studio)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38.85]
[null,"Chaque chambre additionnelle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2]
[null,"Chaque climatiseur (ne pas modifier)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[]
[]
[]
[]
[null,"COÛT DES STATIONNEMENTS (Ne plus modifier, n'est pas dans l'avis d'indexation)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Extérieur sans prise",null,null,null,null,null,null,null,null,null,null,5]
[null,"Premier stationnement",null,null,null,null,null,null,null,null,null,null,"Extérieur avec prise",null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,"Intérieur",null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,"Extérieur sans prise",null,null,null,null,null,null,null,null,null,null,20]
[null,"Deuxième stationnement",null,null,null,null,null,null,null,null,null,null,"Extérieur avec prise",null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,"Intérieur",null,null,null,null,null,null,null,null,null,null,50]
[]
[]
[]
[]
[null,"CHARGE ADDITIONNELLE POUR APPAREILS MÉNAGERS FOURNIS (Ne plus modifier, n'est pas dans l'avis d'indexation)"]
[null,"Charge additionnelle pour cuisinière et réfrigérateur fournis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,"DÉDUCTION POUR APPAREILS MÉNAGERS NON FOURNIS (Ne plus modifier, n'est pas dans l'avis d'indexation)"]
[null,"Déduction pour cuisinière et réfrigérateur non fournis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[]
[]
[]
[]
[null,"Article 12 - DÉDUCTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Chauffage",null,null,null,null,null,null,null,null,null,null,"Eau chaude"]
[null,"Studio et 1 chambre",null,null,null,null,null,null,null,null,null,null,65.75,null,null,null,null,null,null,null,null,null,null,13.45]
[null,"2 chambres",null,null,null,null,null,null,null,null,null,null,71.5,null,null,null,null,null,null,null,null,null,null,14.8]
[null,"3 chambres",null,null,null,null,null,null,null,null,null,null,77.55,null,null,null,null,null,null,null,null,null,null,16.2]
[null,"Plus de 3 chambres",null,null,null,null,null,null,null,null,null,null,95.6,null,null,null,null,null,null,null,null,null,null,17.95]

{"sheet":"Impr_PSL_FR","index":11,"n_rows":77,"n_cols":41,"rows_kept":77,"cut":false,"hidden":true,"merged":[[10,1,10,40],[11,1,11,20],[11,21,11,40],[12,1,12,18],[12,19,12,20],[12,21,12,34],[12,35,12,36],[12,37,12,40],[1,11,1,30],[2,11,2,30],[3,11,3,30],[5,1,5,20],[5,21,5,40],[6,21,6,40],[9,1,9,12],[9,13,9,15],[9,16,9,20],[9,21,9,34],[9,35,9,37],[9,38,9,40],[7,1,7,20],[7,21,7,34],[7,35,7,36],[7,37,7,40],[8,1,8,20],[8,21,8,40],[15,30,15,31],[15,32,15,33],[15,34,15,40],[16,23,16,29],[16,30,16,31],[16,32,16,33],[16,34,16,40],[13,1,13,18],[13,19,13,20],[13,21,13,34],[13,35,13,36],[13,37,13,40],[14,1,14,20],[14,21,14,40],[16,1,16,2],[16,3,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,20],[16,21,16,22],[15,1,15,2],[15,3,15,9],[17,1,17,2],[17,3,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,20],[17,21,17,22],[17,23,17,29],[17,34,17,40],[18,1,18,2],[18,30,18,31],[18,32,18,33],[18,3,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,20],[18,21,18,22],[18,23,18,29],[17,30,17,31],[17,32,17,33],[15,23,15,29],[19,34,19,40],[20,1,20,2],[20,3,20,8],[20,10,20,13],[20,14,20,19],[20,21,20,22],[20,23,20,28],[20,30,20,33],[20,34,20,39],[19,1,19,2],[19,3,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,20],[19,21,19,22],[19,23,19,29],[19,30,19,31],[19,32,19,33],[15,10,15,11],[15,12,15,13],[15,14,15,20],[15,21,15,22],[18,34,18,40],[22,1,22,9],[22,10,22,13],[22,14,22,19],[22,21,22,29],[22,30,22,33],[22,34,22,39],[21,1,21,9],[21,10,21,13],[21,14,21,19],[21,21,21,29],[21,30,21,33],[21,34,21,39],[25,30,25,31],[26,1,26,2],[26,3,26,21],[26,22,26,23],[26,24,26,25],[26,26,26,27],[26,28,26,29],[26,30,26,31],[23,1,23,40],[24,1,25,2],[24,3,25,21],[24,22,25,23],[24,24,24,31],[24,32,25,33],[24,34,25,40],[25,24,25,25],[25,26,25,27],[25,28,25,29],[26,32,26,33],[26,34,26,40],[27,1,27,2],[27,3,27,21],[27,22,27,23],[27,24,27,25],[27,26,27,27],[27,28,27,29],[27,30,27,31],[27,32,27,33],[27,34,27,40],[34,28,34,29],[34,34,34,38],[28,1,28,2],[28,3,28,21],[28,22,28,23],[28,24,28,25],[28,26,28,27],[28,28,28,29],[28,30,28,31],[28,32,28,33],[28,34,28,40],[35,14,35,18],[42,34,42,38],[43,14,43,18],[43,19,43,20],[43,34,43,38],[31,1,31,40],[29,1,29,2],[29,3,29,21],[29,22,29,23],[29,24,29,25],[29,26,29,27],[29,28,29,29],[35,19,35,20],[35,28,35,29],[35,34,35,38],[29,30,29,31],[29,32,29,33],[29,34,29,40],[30,1,30,33],[33,28,33,29],[33,34,33,38],[30,34,30,39],[34,14,34,18],[34,19,34,20],[36,39,36,40],[37,14,37,18],[38,14,38,18],[39,14,39,18],[39,34,39,38],[40,14,40,18],[44,25,44,32],[44,34,44,38],[45,1,45,20],[45,34,45,38],[45,39,45,40],[41,30,41,32],[41,34,41,38],[40,34,40,38],[36,14,36,18],[36,34,36,38],[48,7,48,10],[48,11,48,13],[48,14,48,18],[48,34,48,38],[51,39,51,40],[57,1,57,40],[58,2,58,10],[58,11,58,15],[58,18,58,22],[58,25,58,29],[58,31,58,37],[55,1,55,20],[53,34,53,38],[53,39,53,40],[49,14,49,18],[49,34,49,38],[52,25,52,32],[50,34,50,38],[51,14,51,18],[51,19,51,20],[51,34,51,38],[52,34,52,38],[59,11,59,15],[59,16,59,17],[59,18,59,22],[59,23,59,24],[62,25,62,29],[62,30,62,31],[59,32,59,36],[61,4,61,8],[61,11,61,15],[61,18,61,22],[61,25,61,29],[61,31,61,37],[59,4,59,8],[59,9,59,10],[62,11,62,15],[62,16,62,17],[62,18,62,22],[62,23,62,24],[59,25,59,29],[59,30,59,31],[62,32,62,36],[65,1,65,40],[66,22,66,23],[66,24,66,25],[66,26,66,27],[66,35,66,36],[67,39,67,40],[66,37,66,38],[66,39,66,40],[62,4,62,8],[62,9,62,10],[68,1,68,40],[74,15,74,16],[74,17,74,18],[74,19,74,20],[74,35,74,36],[74,37,74,38],[74,39,74,40],[67,12,67,13],[67,22,67,23],[67,24,67,25],[67,26,67,27],[67,35,67,36],[67,37,67,38],[76,35,76,40],[75,1,75,14],[75,15,75,16],[75,17,75,18],[75,19,75,20],[75,21,75,34],[75,35,75,36],[76,21,76,23],[75,37,75,38],[75,39,75,40]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROGRAMME DE"]
[null,null,null,null,null,null,null,null,null,null,null,"SUPPLÉMENT AU LOYER"]
[null,null,null,null,null,null,null,null,null,null,null,"Calcul de la subvention"]
[]
[null,"IDENTIFICATION DE L'ORGANISME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDENTIFICATION DU LOGEMENT"]
[null," Nom et adresse de l'organisme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Adresse du logement"]
[null,"NomOrg01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AdrLog",null,null,null,null,null,null,null,null,null,null,null,null,null,"App."]
[null,"AdrOrg01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," N° de l'unité\n de logement :",null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Nombre de\n chambre(s) :",null,null,3]
[null,"IDENTIFICATION DU MÉNAGE ET DES REVENUS"]
[null,"Occupant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Occupant 2"]
[null," Nom et prénom (nom de fille, s'il y a lieu)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Âge",null," Nom et prénom (nom de fille, s'il y a lieu)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Âge",null,"Lien de parenté"]
[null,"Steph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,"enf1",null,null,null,null,null,null,null,null,null,null,null,null,null,35,null,"Fils"]
[null,"Revenus annuels et déductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenus annuels et déductions"]
[null,"Code\nde la\nsource",null,"Revenus",null,null,null,null,null,null,"Année",null,"Code\nde la\nsource",null,"Déductions",null,null,null,null,null,null,"Code\nde la\nsource",null,"Revenus",null,null,null,null,null,null,"Année",null,"Code\nde la\nsource",null,"Déductions"]
[]
[]
[]
[]
[null,"Total",null,0,null,null,null,null,null,"(1)","Total ",null,null,null,0,null,null,null,null,null,"(2)","Total",null,0,null,null,null,null,null,"(1)","Total ",null,null,null,0,null,null,null,null,null,"(2)"]
[null,"Revenu annuel considéré",null,null,null,null,null,null,null,null,"(1) – (2)",null,null,null,0,null,null,null,null,null,"(3)","Revenu annuel considéré",null,null,null,null,null,null,null,null,"(1) – (2)",null,null,null,0,null,null,null,null,null,"(3)"]
[null,"Revenu mensuel considéré",null,null,null,null,null,null,null,null,"(3) ÷ 12",null,null,null,0,null,null,null,null,null,"(4)","Revenu mensuel considéré",null,null,null,null,null,null,null,null,"(3) ÷ 12",null,null,null,0,null,null,null,null,null,"(5)"]
[null,"Autres membres du ménage"]
[null,"N° de\nl'occu-\npant",null,"Nom et prénom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Âge",null,"Statut (cochez)",null,null,null,null,null,null,null,"Sexe",null,"Revenus mensuels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Étudiant",null,"Handi-\ncapé",null,"Famille\nd'accueil",null,"Mineur\némancipé"]
[null,"3",null,"enf2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,null,null,null,null,null,null,null,null,"M",null,0]
[null,"4",null,"enf3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,null,"M",null,0]
[null,"5"]
[null,"6"]
[null,"Total des revenus mensuels des autres membres du ménage ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"(6)"]
[null,"DÉTERMINATION DE LA CONTRIBUTION AU LOYER"]
[null,"1",null,"Contribution mensuelle de base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2",null,"Contribution mensuelle des personnes indépendantes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° de l'occupant",null,null,null,null,null,3,null,null,null,null,null,0]
[null,null,"A)","Occupant 1",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"(4)",null,null,null,null,null,null,null,null,4,null,null,null,null,null,0]
[null,null,"B)","Occupant 2",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"(5)"]
[null,null,"C)","Total de (4) et (5)",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"Contribution mensuelle totale",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"(9)"]
[null,null,"D)","Taux d'effort 25 %",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"E)","Abattement",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"3",null,"Charges additionnelles mensuelles"]
[null,null,"F)","Total de D moins E",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"Électricité",null,null,null,null,null,null,null,null,null,null,null,48.7]
[null,null,"G)","Loyer mensuel minimum de base",null,null,null,null,null,null,null,null,null,null,268,null,null,null,null,null,null,null,"Climatiseur(s)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stationnement(s) : no(s)",null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,"H)","Loyer mensuel de base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuisinière"]
[null,null,null,"(Sélectionner le plus élevé de F et G)",null,null,null,null,null,null,null,null,null,null,268,null,null,null,null,"(7)",null,null,"Réfrigérateur",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres :",null,null,"Autre charge",null,null,null,null,null,null,null,null,6]
[null,"Loyer protégé (si demandé par l'occupant 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total des charges additionnelles",null,null,null,null,null,null,null,null,null,null,null,59.7,null,null,null,null,"(10)"]
[]
[null,null,"I)","Loyer mensuel de base de l'année",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4",null,"Déductions mensuelles (si non incluses au bail)"]
[null,null,null,"antérieure",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"+ \", DOLLAR(Parametres!U66))","v":"+ 50,00 $"},null,null,0,null,null,null,null,null,null,null,"Chauffage",null,null,null,null,null,null,null,null,null,null,null,69.45]
[null,null,"J)","Loyer de référence",null,null,null,null,null,null,null,null,null,null,634,null,null,null,null,null,null,null,"Eau chaude",null,null,null,null,null,null,null,null,null,null,null,14.5]
[null,null,"K)","Loyer mensuel de base protégé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxe d'eau (montant annuel)",null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,"(Sélectionner le plus bas de I et J sans",null,null,null,null,null,null,null,null,null,null,268,null,null,null,null,"(8)",null,null,"Taxe cueillette ordures (mnt. annuel)",null,null,null,null,null,null,null,null,null,null,null,10.83]
[null,null,null," que ce montant soit inférieur à G)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres :",null,null,"Test",null,null,null,null,null,null,null,null,12]
[null,null,"Mesure activée :",null,null,null,null,null,"Oui",null,null,"Non",null,null,null,"L'occupant 1 n'a plus",null,null,null,null,null,null,"Total des déductions",null,null,null,null,null,null,null,null,null,null,null,116.78,null,null,null,null,"(11)"]
[null,null,"Période :",null,null,null,null,null,null,null,null,null,null,null,null,"droit à la mesure"]
[null,"Indexation automatique des revenus (réf. Article 19)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le loyer comprend-il un stationnement?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Oui",null,null,"Non"]
[null,null,null,"1ère",null,null,"2e",null,"3e",null,null,"année de l'indexation",null,null,null,null,null,null,null,null,null,null,"Le locataire est-il membre de la coopérative?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Oui",null,null,"Non"]
[null,"LOYER À PAYER ET SUPPLÉMENT AU LOYER"]
[null,null,"Contribution ((7) ou (8)) + (9)",null,null,null,null,null,null,null,null,"Charges (10)",null,null,null,null,null,null,"Déductions (11)",null,null,null,null,null,null,"Part du ménage",null,null,null,null,null,"Supplément non membre"]
[null,null,null,null,268,null,null,null,null,"+",null,59.7,null,null,null,null,"–",null,116.78,null,null,null,null,"=",null,211,null,null,null,null,"+",null,10]
[]
[null,null,null,null,"Loyer au bail",null,null,null,null,null,null,"Rabais de membre",null,null,null,null,null,null,"Loyer reconnu",null,null,null,null,null,null,"Part du ménage",null,null,null,null,null,"Supplément au loyer"]
[null,null,null,null,600,null,null,null,null,"–",null,10,null,null,null,null,"=",null,590,null,null,null,null,"–",null,211,null,null,null,null,"=",null,379]
[]
[]
[null,"DURÉE DE LA SUBVENTION DU SUPPLÉMENT AU LOYER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,"M",null,"J",null,null,null,null,null,null,null,null,"A",null,"M",null,"J"]
[null,null,"La présente a une durée de",null,null,null,null,null,null,null,null,null,12,null,null,"mois,",null,null,"débutant le",null,null,null,22,null,6,null,1,null,null,null,"et finissant le",null,null,null,null,23,null,6,null,1]
[null,"ATTESTATION ET ACCORD DES PARTIES"]
[null,null,"À titre de bénéficiaire d'un logement social, je déclare que tous les renseignements et les pièces fournis à l'appui de cette déclaration sont, au meilleur de mes        "]
[null,null,"connaissances, véridiques, exacts et complets.  De plus, je consens à ce que l'organisme vérifie mes revenus auprès de mon employeur, du ministère du Revenu, des        "]
[null,null,"autres ministères et organismes gouvernementaux et de tout autre organisme concerné, et j'autorise ce ou ces derniers à lui fournir les renseignements.  Je reconnais        "]
[null,null,"que cette déclaration a la même force et le même effet que si elle était faite sous serment.        "]
[null,null,"Bénéficiaire",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,"Organisme (personne mandatée)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null," Signature (Occupant 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,"M",null,"J",null," Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,"M",null,"J"]
[]
[null,"SHQ-2001-05 M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"Report!P27","v":"2026.01"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2026-03-19T13:53:03.070"}]

{"sheet":"Impr_PSL_EN","index":12,"n_rows":77,"n_cols":41,"rows_kept":77,"cut":false,"hidden":true,"merged":[[10,1,10,40],[11,1,11,20],[11,21,11,40],[12,1,12,18],[12,19,12,20],[12,21,12,34],[12,35,12,36],[12,37,12,40],[1,11,1,30],[2,11,2,30],[3,11,3,30],[5,1,5,20],[5,21,5,40],[6,21,6,40],[9,1,9,12],[9,13,9,15],[9,16,9,20],[9,21,9,34],[9,35,9,37],[9,38,9,40],[7,1,7,20],[7,21,7,34],[7,35,7,36],[7,37,7,40],[8,1,8,20],[8,21,8,40],[15,30,15,31],[15,32,15,33],[15,34,15,40],[16,23,16,29],[16,30,16,31],[16,32,16,33],[16,34,16,40],[13,1,13,18],[13,19,13,20],[13,21,13,34],[13,35,13,36],[13,37,13,40],[14,1,14,20],[14,21,14,40],[16,1,16,2],[16,3,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,20],[16,21,16,22],[15,1,15,2],[15,3,15,9],[17,1,17,2],[17,3,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,20],[17,21,17,22],[17,23,17,29],[17,34,17,40],[18,1,18,2],[18,30,18,31],[18,32,18,33],[18,3,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,20],[18,21,18,22],[18,23,18,29],[17,30,17,31],[17,32,17,33],[15,23,15,29],[19,34,19,40],[20,1,20,2],[20,3,20,8],[20,10,20,13],[20,14,20,19],[20,21,20,22],[20,23,20,28],[20,30,20,33],[20,34,20,39],[19,1,19,2],[19,3,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,20],[19,21,19,22],[19,23,19,29],[19,30,19,31],[19,32,19,33],[15,10,15,11],[15,12,15,13],[15,14,15,20],[15,21,15,22],[18,34,18,40],[22,1,22,9],[22,10,22,13],[22,14,22,19],[22,21,22,29],[22,30,22,33],[22,34,22,39],[21,1,21,9],[21,10,21,13],[21,14,21,19],[21,21,21,29],[21,30,21,33],[21,34,21,39],[25,30,25,31],[26,1,26,2],[26,3,26,21],[26,22,26,23],[26,24,26,25],[26,26,26,27],[26,28,26,29],[26,30,26,31],[23,1,23,40],[24,1,25,2],[24,3,25,21],[24,22,25,23],[24,24,24,31],[24,32,25,33],[24,34,25,40],[25,24,25,25],[25,26,25,27],[25,28,25,29],[26,32,26,33],[26,34,26,40],[27,1,27,2],[27,3,27,21],[27,22,27,23],[27,24,27,25],[27,26,27,27],[27,28,27,29],[27,30,27,31],[27,32,27,33],[27,34,27,40],[34,28,34,29],[34,34,34,38],[28,1,28,2],[28,3,28,21],[28,22,28,23],[28,24,28,25],[28,26,28,27],[28,28,28,29],[28,30,28,31],[28,32,28,33],[28,34,28,40],[35,14,35,18],[42,34,42,38],[43,14,43,18],[43,19,43,20],[43,34,43,38],[31,1,31,40],[29,1,29,2],[29,3,29,21],[29,22,29,23],[29,24,29,25],[29,26,29,27],[29,28,29,29],[35,19,35,20],[35,28,35,29],[35,34,35,38],[29,30,29,31],[29,32,29,33],[29,34,29,40],[30,1,30,33],[33,28,33,29],[33,34,33,38],[30,34,30,39],[34,14,34,18],[34,19,34,20],[36,39,36,40],[37,14,37,18],[38,14,38,18],[39,14,39,18],[39,34,39,38],[40,14,40,18],[44,25,44,32],[44,34,44,38],[45,1,45,20],[45,34,45,38],[45,39,45,40],[41,30,41,32],[41,34,41,38],[40,34,40,38],[36,14,36,18],[36,34,36,38],[48,6,48,9],[48,11,48,13],[48,14,48,18],[48,34,48,38],[53,39,53,40],[57,1,57,40],[58,2,58,10],[58,11,58,15],[58,18,58,22],[58,25,58,29],[58,31,58,37],[55,1,55,20],[53,34,53,38],[49,14,49,18],[49,34,49,38],[52,25,52,32],[52,34,52,38],[51,14,51,18],[51,19,51,20],[50,34,50,38],[51,34,51,38],[59,11,59,15],[59,16,59,17],[59,18,59,22],[59,23,59,24],[62,25,62,29],[62,30,62,31],[59,32,59,36],[61,4,61,8],[61,11,61,15],[61,18,61,22],[61,25,61,29],[61,31,61,37],[59,4,59,8],[59,9,59,10],[62,11,62,15],[62,16,62,17],[62,18,62,22],[62,23,62,24],[59,25,59,29],[59,30,59,31],[62,32,62,36],[65,1,65,40],[66,22,66,23],[66,24,66,25],[66,26,66,27],[66,35,66,36],[67,39,67,40],[66,37,66,38],[66,39,66,40],[62,4,62,8],[62,9,62,10],[68,1,68,40],[74,15,74,16],[74,17,74,18],[74,19,74,20],[74,35,74,36],[74,37,74,38],[74,39,74,40],[67,12,67,13],[67,22,67,23],[67,24,67,25],[67,26,67,27],[67,35,67,36],[67,37,67,38],[76,35,76,40],[75,1,75,14],[75,15,75,16],[75,17,75,18],[75,19,75,20],[75,21,75,34],[75,35,75,36],[75,37,75,38],[75,39,75,40],[76,21,76,23]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"RENT SUPPLEMENT PROGRAM"]
[null,null,null,null,null,null,null,null,null,null,null,"Subsidy calculation"]
[]
[null,"IDENTIFICATION OF THE ORGANIZATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDENTIFICATION OF THE DWELLING"]
[null," Name and address of the agency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Address of the dwelling"]
[null,"NomOrg01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AdrLog",null,null,null,null,null,null,null,null,null,null,null,null,null,"Apt."]
[null,"AdrOrg01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," File number :",null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Number \nof rooms :",null,null,3]
[null,"IDENTIFICATION OF HOUSEHOLD AND INCOME"]
[null,"Occupant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Occupant 2"]
[null," Family name and first name (maiden name if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Age",null," Family name and first name (maiden name if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Age",null,"Kinship"]
[null,"Steph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,"enf1",null,null,null,null,null,null,null,null,null,null,null,null,null,35,null,"Son"]
[null,"Annual income and deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual income and deductions"]
[null,"Source code",null,"Income",null,null,null,null,null,null,"Year",null,"Source code",null,"Deductions",null,null,null,null,null,null,"Source code",null,"Income",null,null,null,null,null,null,"Year",null,"Source code",null,"Deductions"]
[]
[]
[]
[]
[null,"Total",null,0,null,null,null,null,null,"(1)","Total ",null,null,null,0,null,null,null,null,null,"(2)","Total",null,0,null,null,null,null,null,"(1)","Total ",null,null,null,0,null,null,null,null,null,"(2)"]
[null,"Annual income considered",null,null,null,null,null,null,null,null,"(1) – (2)",null,null,null,0,null,null,null,null,null,"(3)","Annual income considered",null,null,null,null,null,null,null,null,"(1) – (2)",null,null,null,0,null,null,null,null,null,"(3)"]
[null,"Monthly income considered",null,null,null,null,null,null,null,null,"(3) ÷ 12",null,null,null,0,null,null,null,null,null,"(4)","Monthly income considered",null,null,null,null,null,null,null,null,"(3) ÷ 12",null,null,null,0,null,null,null,null,null,"(5)"]
[null,"Other household members"]
[null,"Occu-\npant \nno.",null,"Family name and first name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Age",null,"Status (check)",null,null,null,null,null,null,null,"Sex",null,"Monthly income"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Student",null,"Handi-\ncapped",null,"Foster family",null,"Emancipa-\nted minor"]
[null,"3",null,"enf2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,null,null,null,null,null,null,null,null,"M",null,0]
[null,"4",null,"enf3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,null,"M",null,0]
[null,"5"]
[null,"6"]
[null,"Total monthly income of other household members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"(6)"]
[null,"CALCULATION OF THE RENT CONTRIBUTION"]
[null,"1",null,"Basic monthly contribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2",null,"Monthly contribution of independent persons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Occupant No.",null,null,null,null,null,3,null,null,null,null,null,0]
[null,null,"A)","Occupant 1",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"(4)",null,null,null,null,null,null,null,null,4,null,null,null,null,null,0]
[null,null,"B)","Occupant 2",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"(5)"]
[null,null,"C)","Total of (4) and (5)",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"Total monthly contribution",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"(9)"]
[null,null,"D)","Rent-to-income rate 25%",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"E)","Abatement",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"3",null,"Additional charges (if included in the rent)"]
[null,null,"F)","Total of D minus E",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"Domestic electricity",null,null,null,null,null,null,null,null,null,null,null,48.7]
[null,null,"G)","Basic minimum monthly rent",null,null,null,null,null,null,null,null,null,null,268,null,null,null,null,null,null,null,"Air conditioner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parking: No.",null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,"H)","Basic monthly rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stove"]
[null,null,null,"(The higher of F or G)",null,null,null,null,null,null,null,null,null,null,268,null,null,null,null,"(7)",null,null,"Refrigerator",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other :",null,null,"Autre charge",null,null,null,null,null,null,null,null,6]
[null,"Protected rent (if requested by occupant 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total charges",null,null,null,null,null,null,null,null,null,null,null,59.7,null,null,null,null,"(10)"]
[]
[null,null,"I)","Basic monthly rent for the preceding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4",null,"Monthly deductions (if not included in the rent)"]
[null,null,null,"year",null,null,null,null,null,null,"+",{"$f":"Parametres!U66","v":50},null,null,0,null,null,null,null,null,null,null,"Heating",null,null,null,null,null,null,null,null,null,null,null,69.45]
[null,null,"J)","Reference rent",null,null,null,null,null,null,null,null,null,null,634,null,null,null,null,null,null,null,"Hot water",null,null,null,null,null,null,null,null,null,null,null,14.5]
[null,null,"K)","Basic monthly protected rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water tax (annual amount)",null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,"(The lower of I and J)",null,null,null,null,null,null,null,null,null,null,268,null,null,null,null,"(8)",null,null,"Garbage collection tax (ann. amount)",null,null,null,null,null,null,null,null,null,null,null,10.83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other :",null,null,"Test",null,null,null,null,null,null,null,null,12]
[null,null,"Measure activated :",null,null,null,null,null,"Yes",null,null,"No",null,null,null,"Occupant 1 does not",null,null,null,null,null,null,"Total deductions",null,null,null,null,null,null,null,null,null,null,null,116.78,null,null,null,null,"(11)"]
[null,null,"Period :",null,null,null,null,null,null,null,null,null,null,null,"have a right to this measure"]
[null,"Automatic indexation of income (ref. Article 19)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Does the rent include a parking space?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No"]
[null,null,null,"1st",null,null,"2nd",null,"  3rd",null,null,"year of indexation",null,null,null,null,null,null,null,null,null,null,"Is the lessee a member of the cooperative?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No"]
[null,"RENT PAYABLE AND RENT SUPPLEMENT"]
[null,null,"Contribution ((7) or (8)) + (9)",null,null,null,null,null,null,null,null,"Charges (10)",null,null,null,null,null,null,"Deductions (11)",null,null,null,null,null,null,"Household share",null,null,null,null,null,"Non-member supplement"]
[null,null,null,null,268,null,null,null,null,"+",null,59.7,null,null,null,null,"–",null,116.78,null,null,null,null,"=",null,211,null,null,null,null,"+",null,10]
[]
[null,null,null,null,"Rent as per lease",null,null,null,null,null,null,"Member rebate",null,null,null,null,null,null,"Recognized rent",null,null,null,null,null,null,"Household share",null,null,null,null,null,"Rent supplement"]
[null,null,null,null,600,null,null,null,null,"–",null,10,null,null,null,null,"=",null,590,null,null,null,null,"–",null,211,null,null,null,null,"=",null,379]
[]
[]
[null,"LENGTH OF THE RENT SUPPLEMENT SUBSIDY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",null,"M",null,"D",null,null,null,null,null,null,null,null,"Y",null,"M",null,"D"]
[null,null,"These presents last for",null,null,null,null,null,null,null,null,null,12,null,null,"months,",null,null,"beginning",null,null,null,22,null,6,null,1,null,null,null,"and ending",null,null,null,null,23,null,6,null,1]
[null,"ATTESTATION ET ACCORD DES PARTIES"]
[null,null,"As the recipient of a social housing unit, I declare that all the information and documents provided in support of this declaration are, to the best of my "]
[null,null,"knowledge, true, accurate and complete. In addition, I agree to allow the organization to verify my income with my employer, the Ministère du Revenu,"]
[null,null,"other government departments and organizations and any other organization concerned, and I authorize them to provide him with such information."]
[null,null,"I acknowledge that this declaration has the same force as if it had been given under oath."]
[null,null,"Recipient",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,"Agency",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null," Signature (Occupant 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",null,"M",null,"D",null," Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",null,"M",null,"D"]
[]
[null,"SHQ-2001-05A M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"Report!P27","v":"2026.01"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2026-03-19T13:53:03.070"}]

{"sheet":"Impr_PSL_annexe","index":13,"n_rows":59,"n_cols":41,"rows_kept":59,"cut":false,"hidden":true,"merged":[[22,1,22,2],[22,21,22,22],[22,3,22,9],[22,12,22,13],[22,14,22,20],[22,23,22,29],[22,30,22,31],[22,32,22,33],[22,34,22,40],[22,10,22,11],[1,11,1,30],[2,11,2,30],[3,11,3,30],[4,11,4,30],[6,1,6,40],[7,1,7,20],[7,21,7,40],[8,1,8,18],[8,19,8,20],[8,21,8,34],[8,35,8,36],[8,37,8,40],[9,1,9,18],[9,19,9,20],[9,21,9,34],[9,35,9,36],[9,37,9,40],[10,1,10,20],[10,21,10,40],[11,1,11,2],[11,3,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,20],[11,21,11,22],[11,23,11,29],[11,30,11,31],[11,32,11,33],[11,34,11,40],[12,34,12,40],[13,1,13,2],[13,3,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,20],[13,21,13,22],[13,23,13,29],[13,30,13,31],[13,32,13,33],[13,34,13,40],[12,1,12,2],[12,3,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,20],[12,21,12,22],[12,23,12,29],[12,30,12,31],[12,32,12,33],[14,34,14,40],[15,1,15,2],[15,3,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,20],[15,21,15,22],[15,23,15,29],[15,30,15,31],[15,32,15,33],[15,34,15,40],[14,1,14,2],[14,3,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,20],[14,21,14,22],[14,23,14,29],[14,30,14,31],[14,32,14,33],[16,34,16,40],[17,1,17,2],[17,3,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,20],[17,21,17,22],[17,23,17,29],[17,30,17,31],[17,32,17,33],[17,34,17,40],[16,1,16,2],[16,3,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,20],[16,21,16,22],[16,23,16,29],[16,30,16,31],[16,32,16,33],[18,34,18,40],[19,1,19,2],[19,3,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,20],[19,21,19,22],[19,23,19,29],[19,30,19,31],[19,32,19,33],[19,34,19,40],[18,1,18,2],[18,3,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,20],[18,21,18,22],[18,23,18,29],[18,30,18,31],[18,32,18,33],[20,34,20,40],[21,1,21,2],[21,3,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,20],[21,21,21,22],[21,23,21,29],[21,30,21,31],[21,32,21,33],[21,34,21,40],[20,1,20,2],[20,3,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,20],[20,21,20,22],[20,23,20,29],[20,30,20,31],[20,32,20,33],[23,34,23,40],[24,1,24,2],[24,3,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,20],[24,21,24,22],[24,23,24,29],[24,30,24,31],[24,32,24,33],[24,34,24,40],[23,1,23,2],[23,3,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,20],[23,21,23,22],[23,23,23,29],[23,30,23,31],[23,32,23,33],[25,34,25,40],[26,1,26,2],[26,3,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,20],[26,21,26,22],[26,23,26,29],[26,30,26,31],[26,32,26,33],[26,34,26,40],[25,1,25,2],[25,3,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,20],[25,21,25,22],[25,23,25,29],[25,30,25,31],[25,32,25,33],[27,34,27,40],[28,1,28,2],[28,3,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,20],[28,21,28,22],[28,23,28,29],[28,30,28,31],[28,32,28,33],[28,34,28,40],[27,1,27,2],[27,3,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,20],[27,21,27,22],[27,23,27,29],[27,30,27,31],[27,32,27,33],[29,34,29,40],[30,1,30,2],[30,3,30,9],[30,10,30,11],[30,12,30,13],[30,14,30,20],[30,21,30,22],[30,23,30,29],[30,30,30,31],[30,32,30,33],[30,34,30,40],[29,1,29,2],[29,3,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,20],[29,21,29,22],[29,23,29,29],[29,30,29,31],[29,32,29,33],[31,34,31,40],[32,1,32,2],[32,3,32,9],[32,10,32,11],[32,12,32,13],[32,14,32,20],[32,21,32,22],[32,23,32,29],[32,30,32,31],[32,32,32,33],[32,34,32,40],[31,1,31,2],[31,3,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,20],[31,21,31,22],[31,23,31,29],[31,30,31,31],[31,32,31,33],[33,34,33,40],[34,1,34,2],[34,3,34,9],[34,10,34,11],[34,12,34,13],[34,14,34,20],[34,21,34,22],[34,23,34,29],[34,30,34,31],[34,32,34,33],[34,34,34,40],[33,1,33,2],[33,3,33,9],[33,10,33,11],[33,12,33,13],[33,14,33,20],[33,21,33,22],[33,23,33,29],[33,30,33,31],[33,32,33,33],[35,34,35,40],[36,1,36,2],[36,3,36,9],[36,10,36,11],[36,12,36,13],[36,14,36,20],[36,21,36,22],[36,23,36,29],[36,30,36,31],[36,32,36,33],[36,34,36,40],[35,1,35,2],[35,3,35,9],[35,10,35,11],[35,12,35,13],[35,14,35,20],[35,21,35,22],[35,23,35,29],[35,30,35,31],[35,32,35,33],[38,34,38,40],[39,1,39,2],[39,3,39,9],[39,10,39,11],[39,12,39,13],[39,14,39,20],[39,21,39,22],[39,23,39,29],[39,30,39,31],[39,32,39,33],[39,34,39,40],[38,1,38,2],[38,3,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,20],[38,21,38,22],[38,23,38,29],[38,30,38,31],[38,32,38,33],[40,34,40,40],[41,1,41,2],[41,3,41,9],[41,10,41,11],[41,12,41,13],[41,14,41,20],[41,21,41,22],[41,23,41,29],[41,30,41,31],[41,32,41,33],[41,34,41,40],[40,1,40,2],[40,3,40,9],[40,10,40,11],[40,12,40,13],[40,14,40,20],[40,21,40,22],[40,23,40,29],[40,30,40,31],[40,32,40,33],[42,34,42,40],[43,1,43,2],[43,3,43,9],[43,10,43,11],[43,12,43,13],[43,14,43,20],[43,21,43,22],[43,23,43,29],[43,30,43,31],[43,32,43,33],[43,34,43,40],[42,1,42,2],[42,3,42,9],[42,10,42,11],[42,12,42,13],[42,14,42,20],[42,21,42,22],[42,23,42,29],[42,30,42,31],[42,32,42,33],[44,34,44,40],[45,1,45,2],[45,3,45,9],[45,10,45,11],[45,12,45,13],[45,14,45,20],[45,21,45,22],[45,23,45,29],[46,21,46,22],[46,23,46,29],[45,34,45,40],[44,1,44,2],[44,3,44,9],[44,10,44,11],[44,12,44,13],[44,14,44,20],[44,21,44,22],[44,23,44,29],[44,30,44,31],[44,32,44,33],[45,30,45,31],[45,32,45,33],[46,34,46,40],[47,1,47,2],[47,3,47,8],[47,10,47,13],[47,14,47,19],[47,21,47,22],[47,34,47,39],[46,1,46,2],[46,3,46,9],[46,10,46,11],[46,12,46,13],[46,14,46,20],[46,30,46,31],[46,32,46,33],[47,23,47,28],[47,30,47,33],[54,9,54,10],[54,13,54,17],[48,1,48,9],[48,10,48,13],[48,14,48,19],[48,21,48,29],[54,29,54,30],[48,30,48,33],[54,33,54,37],[48,34,48,39],[37,1,37,2],[37,21,37,22],[56,33,56,37],[56,38,56,39],[58,35,58,40],[51,1,51,40],[53,9,53,10],[53,13,53,17],[53,29,53,30],[53,33,53,37],[37,32,37,33],[37,34,37,40],[37,3,37,9],[37,10,37,11],[37,12,37,13],[37,14,37,20],[37,23,37,29],[37,30,37,31],[49,1,49,9],[49,10,49,13],[49,14,49,19],[49,21,49,29],[49,30,49,33],[49,34,49,39]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROGRAMME DE"]
[null,null,null,null,null,null,null,null,null,null,null,"SUPPLÉMENT AU LOYER"]
[null,null,null,null,null,null,null,null,null,null,null,"Calcul de la subvention"]
[null,null,null,null,null,null,null,null,null,null,null,"ANNEXE"]
[]
[null,"REVENUS ET DÉDUCTIONS DÉTAILLÉS – OCCUPANTS 1 ET 2"]
[null,"Occupant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Occupant 2"]
[null," Nom et prénom (nom de fille, s'il y a lieu)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Âge",null," Nom et prénom (nom de fille, s'il y a lieu)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Âge",null,"Lien de parenté"]
[]
[null,"Revenus annuels et déductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenus annuels et déductions"]
[null,"Code\nde la\nsource",null,"Revenus",null,null,null,null,null,null,"Année",null,"Code\nde la\nsource",null,"Déductions",null,null,null,null,null,null,"Code\nde la\nsource",null,"Revenus",null,null,null,null,null,null,"Année",null,"Code\nde la\nsource",null,"Déductions"]
[null,"11",null,null,null,null,null,null,null,null,null,null,"81",null,null,null,null,null,null,null,null,"11",null,null,null,null,null,null,null,null,null,null,"81"]
[null,"12",null,null,null,null,null,null,null,null,null,null,"82",null,null,null,null,null,null,null,null,"12",null,null,null,null,null,null,null,null,null,null,"82"]
[null,"13",null,null,null,null,null,null,null,null,null,null,"83",null,null,null,null,null,null,null,null,"13",null,null,null,null,null,null,null,null,null,null,"83"]
[null,"14",null,null,null,null,null,null,null,null,null,null,"84",null,null,null,null,null,null,null,null,"14",null,null,null,null,null,null,null,null,null,null,"84"]
[null,"15",null,null,null,null,null,null,null,null,null,null,"85",null,null,null,null,null,null,null,null,"15",null,null,null,null,null,null,null,null,null,null,"85"]
[null,"16",null,null,null,null,null,null,null,null,null,null,"86",null,null,null,null,null,null,null,null,"16",null,null,null,null,null,null,null,null,null,null,"86"]
[null,"17",null,null,null,null,null,null,null,null,null,null,"88",null,null,null,null,null,null,null,null,"17",null,null,null,null,null,null,null,null,null,null,"88"]
[null,"21",null,null,null,null,null,null,null,null,null,null,"89",null,null,null,null,null,null,null,null,"21",null,null,null,null,null,null,null,null,null,null,"89"]
[null,"22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22"]
[null,"23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23"]
[null,"24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24"]
[null,"31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31"]
[null,"32",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32"]
[null,"33",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33"]
[null,"34",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"34"]
[null,"41",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"41"]
[null,"42",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"42"]
[null,"43",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"43"]
[null,"44",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"44"]
[null,"45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45"]
[null,"46",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46"]
[null,"47",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47"]
[null,"48",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48"]
[null,"51",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51"]
[null,"52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"52"]
[null,"55",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55"]
[null,"61",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"61"]
[null,"62",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"62"]
[null,"63",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"63"]
[null,"64",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"64"]
[null,"65",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"65"]
[null,"66",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"66"]
[null,"67",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"67"]
[null,"71",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"71"]
[null,"79",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"79"]
[null,"Total",null,null,null,null,null,null,null,"(1)",null,null,null,null,null,null,null,null,null,null,"(2)","Total",null,null,null,null,null,null,null,"(1)",null,null,null,null,null,null,null,null,null,null,"(2)"]
[null,"Revenu annuel considéré",null,null,null,null,null,null,null,null,"(1) – (2)",null,null,null,null,null,null,null,null,null,"(3)","Revenu annuel considéré",null,null,null,null,null,null,null,null,"(1) – (2)",null,null,null,null,null,null,null,null,null,"(3)"]
[null,"Revenu mensuel considéré",null,null,null,null,null,null,null,null,"(3) ÷ 12",null,null,null,null,null,null,null,null,null,"(4)","Revenu mensuel considéré",null,null,null,null,null,null,null,null,"(3) ÷ 12",null,null,null,null,null,null,null,null,null,"(5)"]
[]
[null,"CONTRIBUTION MENSUELLE DES PERSONNES INDÉPENDANTES"]
[]
[null,null,"N° de l'occupant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° de l'occupant"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contribution mensuelle totale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(9)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2026-03-19T13:53:03.070"}]

{"sheet":"Impr_non_PSL","index":14,"n_rows":78,"n_cols":41,"rows_kept":78,"cut":false,"hidden":true,"merged":[[3,1,3,40],[4,3,4,24],[4,25,4,26],[4,27,4,28],[4,29,4,40],[5,3,5,24],[5,25,5,26],[5,27,5,28],[5,29,5,40],[6,1,6,2],[6,3,6,24],[6,25,6,26],[6,27,6,28],[6,29,6,40],[7,1,7,2],[7,3,7,24],[7,25,7,26],[7,27,7,28],[7,29,7,40],[8,1,8,2],[8,3,8,24],[8,25,8,26],[8,27,8,28],[8,29,8,40],[9,1,9,2],[9,3,9,24],[9,25,9,26],[9,27,9,28],[9,29,9,40],[14,1,14,40],[15,8,15,10],[15,11,15,15],[15,16,15,20],[15,21,15,25],[15,26,15,30],[15,31,15,35],[15,36,15,40],[10,1,10,2],[10,3,10,24],[10,25,10,26],[10,27,10,28],[10,29,10,40],[11,1,11,2],[11,3,11,24],[11,25,11,26],[11,27,11,28],[11,29,11,40],[17,11,17,15],[17,16,17,20],[17,21,17,25],[17,26,17,30],[17,31,17,35],[17,36,17,40],[16,11,16,15],[16,16,16,20],[16,21,16,25],[16,26,16,30],[16,31,16,35],[16,36,16,40],[19,11,19,15],[19,16,19,20],[19,21,19,25],[19,26,19,30],[19,31,19,35],[19,36,19,40],[18,11,18,15],[18,16,18,20],[18,21,18,25],[18,26,18,30],[18,31,18,35],[18,36,18,40],[21,11,21,15],[21,16,21,20],[21,21,21,25],[21,26,21,30],[21,31,21,35],[21,36,21,40],[20,11,20,15],[20,16,20,20],[20,21,20,25],[20,26,20,30],[20,31,20,35],[20,36,20,40],[23,11,23,15],[23,16,23,20],[23,21,23,25],[23,26,23,30],[23,31,23,35],[23,36,23,40],[22,11,22,15],[22,16,22,20],[22,21,22,25],[22,26,22,30],[22,31,22,35],[22,36,22,40],[25,11,25,15],[25,16,25,20],[25,21,25,25],[25,26,25,30],[25,31,25,35],[25,36,25,40],[24,11,24,15],[24,16,24,20],[24,21,24,25],[24,26,24,30],[24,31,24,35],[24,36,24,40],[26,11,26,15],[26,16,26,20],[26,21,26,25],[26,26,26,30],[26,31,26,35],[26,36,26,40],[29,1,29,10],[29,11,29,15],[29,16,29,20],[29,21,29,25],[29,26,29,30],[29,31,29,35],[28,26,28,30],[28,31,28,35],[28,36,28,40],[27,11,27,15],[27,16,27,20],[27,21,27,25],[27,26,27,30],[27,31,27,35],[27,36,27,40],[28,11,28,15],[28,16,28,20],[28,21,28,25],[31,11,32,15],[31,16,32,20],[31,21,32,25],[31,26,32,30],[31,31,32,35],[31,36,32,40],[29,36,29,40],[30,11,30,15],[30,16,30,20],[30,21,30,25],[30,26,30,30],[30,31,30,35],[30,36,30,40],[35,11,35,15],[35,16,35,20],[35,21,35,25],[35,26,35,30],[35,31,35,35],[35,36,35,40],[33,11,34,15],[33,16,34,20],[33,21,34,25],[33,26,34,30],[33,31,34,35],[33,36,34,40],[36,36,36,40],[37,1,37,10],[37,11,37,15],[37,16,37,20],[37,21,37,25],[37,26,37,30],[37,31,37,35],[37,36,37,40],[36,3,36,10],[36,11,36,15],[36,16,36,20],[36,21,36,25],[36,26,36,30],[36,31,36,35],[45,9,45,15],[45,33,45,39],[38,36,39,40],[39,1,39,10],[40,1,40,10],[40,11,41,14],[40,15,41,15],[40,31,41,35],[38,1,38,10],[38,11,39,15],[38,16,39,20],[38,21,39,25],[38,26,39,30],[38,31,39,35],[40,36,41,40],[41,1,41,10],[40,16,41,19],[40,20,41,20],[40,21,41,25],[40,26,41,30],[42,2,42,39],[43,33,43,39],[44,33,44,39],[46,33,46,39],[48,33,48,39],[49,33,49,39],[50,33,50,39],[51,1,51,19],[52,21,54,22],[52,23,54,28],[52,29,54,34],[52,35,54,40],[55,14,56,18],[55,21,55,22],[55,23,55,28],[55,29,55,34],[55,35,55,40],[56,21,56,22],[56,23,56,28],[56,29,56,34],[56,35,56,40],[59,14,60,18],[59,19,60,19],[59,21,60,22],[59,23,60,40],[61,35,61,40],[62,10,62,11],[62,35,62,40],[57,14,58,18],[57,21,57,22],[57,23,57,28],[57,29,57,34],[57,35,57,40],[58,21,58,34],[58,35,58,39],[66,14,66,18],[67,1,68,13],[67,14,68,18],[67,19,68,19],[67,29,68,34],[67,35,68,40],[63,35,63,40],[64,1,64,19],[64,35,64,40],[65,14,65,18],[65,21,65,34],[65,35,65,38],[65,39,65,40],[69,21,69,34],[69,35,69,38],[69,39,69,40],[70,2,70,13],[70,14,72,19],[70,21,72,21],[70,22,72,26],[70,27,72,33],[70,34,70,40],[71,2,71,13],[71,34,71,40],[72,35,72,40],[73,1,73,40],[74,22,74,23],[74,24,74,25],[74,26,74,27],[74,35,74,36],[74,37,74,38],[74,39,74,40],[75,39,75,40],[77,35,77,40],[75,12,75,13],[75,22,75,23],[75,24,75,25],[75,26,75,27],[75,35,75,36],[75,37,75,38],[77,31,77,33]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feuille de calcul détaillé du loyer total à payer"]
[]
[null," IDENTIFICATION DU MÉNAGE ET DES REVENUS"]
[null,null,null,"Nom et prénom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Âge",null,"Sexe",null,"Lien de parenté"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avec l'occupant 1 ou son conjoint"]
[null,"1",null,"Nom prenom 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,"M",null,"Occupant 1"]
[null,"2",null,"conjointe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,"F",null,"Conjoint"]
[null,"3",null,"Nom prenom 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,"F",null,"Fils, fille "]
[null,"4",null,"sdafa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,null,"M",null,"Fils, fille "]
[null,"5"]
[null,"6"]
[null," Indiquez le ou les nombres identifiant les occupants étudiants"]
[null," (majeurs à temps plein et à charge)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOMBRE(S)"]
[null," REVENUS ANNUELS : Revenus bruts de l'année civile précédant le début du bail"]
[null," Année de revenus :",null,null,null,null,null,null,2025,null,null,"Occ. 1",null,null,null,null,"Occ. 2",null,null,null,null,"Occ. 3",null,null,null,null,"Occ. 4",null,null,null,null,"Occ. 5",null,null,null,null,"Occ. 6"]
[null," 21",null," 22",null," 23",null,"24",null,null,"Ass-E"]
[null," 11 Pension de vieillesse",null,null,null,null,null,null,null,null,null,10000,null,null,null,null,9000]
[null," 12 Supplément au revenu garanti"]
[null," 13 Régie des rentes"]
[null," 14 Autres pensions"]
[null," 61 Intérêts de placements"]
[null," 41 Assurance-emploi"]
[null," 42 CSST"]
[null," 52 Pension alimentaire reçue"]
[null," 47 Allocations d'aide à l'emploi"]
[null," 48 Rétribution résidences d'accueil"]
[null," 31",null," 32",null," 33",null,"34"]
[null," 79 Autres revenus"]
[null,"(1) Sous-total des revenus",null,null,null,null,null,null,null,null,null,10000,null,null,null,null,9000,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null," DÉDUCTIONS",null,null,null,null,null,null,null,null,null,"Occ. 1",null,null,null,null,"Occ. 2",null,null,null,null,"Occ. 3",null,null,null,null,"Occ. 4",null,null,null,null,"Occ. 5",null,null,null,null,"Occ. 6"]
[null," 81","10 % des revenus de travail",null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,"N/A",null,null,null,null,"N/A",null,null,null,null,"N/A",null,null,null,null,"N/A"]
[null,null,"(Seulement pour les occupants 1 et 2)"]
[null," 86","Allocation d'aide à l'emploi"]
[null,null,{"$f":"CONCATENATE(\"(Soustraire les premiers \", DOLLAR(Parametres!U43), \")\")","v":"(Soustraire les premiers 1 560,00 $)"}]
[null," 88 Rétribution résidences d'accueil"]
[null,"Autres :"]
[null,"(2) Sous-total des déductions",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"Revenus annuels considérés",null,null,null,null,null,null,null,null,null,10000,null,null,null,null,9000,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"(1) – (2) = (3)"]
[null,"Revenus mensuels considérés",null,null,null,null,null,null,null,null,null,833.33,null,null,null,"(4)",750,null,null,null,"(5)",0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"(3) ÷ 12"]
[null," 1.","Calcul du loyer mensuel de base"]
[null," A)",null,"Occupant 1 :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,833.33,null,null,null,null,null,null,"(4)"]
[null," B)",null,"Occupant 2 :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750,null,null,null,null,null,null,"(5)"]
[null," C)",null,"Total de (4) + (5)",null,null,null,null,null,1583.33,null,null,null,null,null,null,null,null,null,null,null,"D) Taux d'effort 25 %",null,null,null,null,null,null,null,null,null,null,null,395.83]
[null," E)",null,"Abattement",null,null,null,"(2 % du total des revenus annuels de travail des occupants 1 et 2 après déduction de 10 % –",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"maximum \", DOLLAR(Parametres!U59), \")\")","v":"maximum 30,00 $)"}]
[null," F)",null,"Total de D moins E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,395.83]
[null," G)",null,"Loyer mensuel minimum de base (voir tableau des loyers minimums)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,383.25]
[null," H)",null,"Loyer mensuel de base (sélectionner le plus élevé de F et G)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,395.83,null,null,null,null,null,null,"(7)"]
[null,"Loyer protégé (si demandé par l'occupant 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 2.",null,"Contribution mensuelle des personnes indépendantes"]
[null,null,"Si l'occupant 1 ou 2 ont des revenus de travail (codes 31, 32, 33) ou des",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No.\nocc.",null,"Revenus mensuels\nconsidérés",null,null,null,null,null,"Contribution à\n25 %",null,null,null,null,null,"Contribution\nconsidérée"]
[null,null,"allocations d'aide à l'emploi (code 47) et n'ont pas reçu de prestations"]
[null,null,"en vertu de la Loi sur la sécurité de la vieillesse (code 11 ou 12)."]
[null,"I)","Loyer majoré (Loyer mensuel de base de",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,3,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[null,null,{"$f":"CONCATENATE(\"l'année antérieure + \", DOLLAR(Parametres!U66), \")\")","v":"l'année antérieure + 50,00 $)"}]
[null,"J)","Loyer de référence : ",null,null,null,null,null,null,{"$f":"CONCATENATE(DOLLAR(Parametres!U67), \" pour\")","v":"725,00 $ pour"},null,null,null,null,808]
[null,null,{"$f":"CONCATENATE(\"l'occ. 1 et \", DOLLAR(Parametres!U68), \" pour les occ. 1 et 2\")","v":"l'occ. 1 et 808,00 $ pour les occ. 1 et 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contribution totale des personnes indépendantes",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"(9)"]
[null,"K)","Loyer mensuel de base protégé",null,null,null,null,null,null,null,null,null,null,null,395.83,null,null,null,null,"(8)",null," 3.",null,"Charges additionnelles mensuelles"]
[null,null,"(Le plus bas de I et J sans être < à G )"]
[null,null,null,null,"Mesure activée :",null,null,null,null,null,"Oui",null,null,"Non",null,null,null,null,null,null,null," Électricité domestique",null,null,null,null,null,null,null,"(Voir tarification)"]
[null,"Période :",null,null,"1",null,"2",null,"3",null,"4",null,null,null,null,null,null,null,null,null,null," Climatiseur(s)",null,null,null,null,null,null,null,"(Voir tarification)"]
[null,null,"L'occupant 1 n'a plus droit à la mesure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Stationnement(s)",null,null,null,null,null,null,null,"(Voir tarification)"]
[null,"Indexation automatique du revenu (article 19)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Autres charges :"]
[null," Loyer mensuel de base de l'année antérieure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total des charges additionnelles",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"(10)"]
[null," Pourcentage d'indexation accordé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 4.",null,"Déductions mensuelles (si applicables)"]
[null," Loyer mensuel de base indexé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(7)",null," Cuisinière non fournie",null,null,null,null,null,null,null," Art. 9 du règlement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Réfrigérateur non fourni"]
[null,null,null,"1ère",null,null,"2e",null,"3e",null,null,"année de l'indexation",null,null,null,null,null,null,null,null,null,"Total des déductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(11)"]
[null," 5.","Loyer mensuel total",null,null,null,null,null,null,null,null,null,null,null,395.83,null,null,null,null,null,null," 6.","Loyer mensuel\ntotal arrondi",null,null,null,null,396,null,null,null,null,null,null,"Supplément non"]
[null,null,"((7) ou (8)) + (9) + (10) – (11)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"membre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[null,"DURÉE DU BAIL OU DE LA SUBVENTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,"M",null,"J",null,null,null,null,null,null,null,null,"A",null,"M",null,"J"]
[null,null,"La présente a une durée de",null,null,null,null,null,null,null,null,null,12,null,null,"mois,",null,null,"débutant le",null,null,null,26,null,4,null,1,null,null,null,"et finissant le",null,null,null,null,27,null,4,null,1]
[]
[null,"À CONSERVER AU DOSSIER DU LOCATAIRE AVEC LES PREUVES DE REVENUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"Report!P27","v":"2026.01"},null,null,null,{"$f":"NOW()","v":"2026-03-19T13:53:03.070"}]

{"sheet":"Impr_non_PSL_annexe","index":15,"n_rows":14,"n_cols":36,"rows_kept":14,"cut":false,"hidden":true,"merged":[[7,11,7,12],[7,13,7,18],[7,19,7,24],[7,25,7,30],[1,9,1,40],[4,11,6,12],[4,13,6,18],[4,19,6,24],[4,25,6,30],[8,11,8,12],[8,13,8,18],[8,19,8,24],[8,25,8,30],[9,11,9,12],[9,13,9,18],[9,19,9,24],[9,25,9,30],[13,35,13,40],[10,11,10,12],[10,13,10,18],[10,19,10,24],[10,25,10,30],[11,11,11,23],[11,24,11,29]]}
[]
[null,null,null,null,null,null,null,null,null,"Feuille de calcul détaillé du loyer total à payer\nAnnexe"]
[]
[null,null,null,null,null,null,null,null,null,null,null," 2.",null,"Contribution mensuelle des personnes indépendantes"]
[null,null,null,null,null,null,null,null,null,null,null,"No.\nocc.",null,"Revenus mensuels\nconsidérés",null,null,null,null,null,"Contribution à\n25 %",null,null,null,null,null,"Contribution\nconsidérée"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"3"]
[null,null,null,null,null,null,null,null,null,null,null,"4"]
[null,null,null,null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,null,"6"]
[null,null,null,null,null,null,null,null,null,null,null,"Contribution totale des personnes indépendantes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(9)"]
[]
[null,"À CONSERVER AU DOSSIER DU LOCATAIRE AVEC LES PREUVES DE REVENUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2026-03-19T13:53:03.070"}]

{"sheet":"Impr_bail_FR","index":16,"n_rows":64,"n_cols":40,"rows_kept":64,"cut":false,"hidden":true,"merged":[[7,1,7,20],[7,21,7,40],[8,1,8,16],[8,17,8,20],[8,21,8,40],[9,1,9,20],[9,21,9,40],[1,11,1,30],[2,11,2,30],[3,11,3,30],[5,18,5,25],[6,1,6,20],[6,21,6,40],[10,1,10,20],[10,21,10,40],[11,1,11,20],[11,21,11,40],[12,1,12,15],[12,16,12,17],[12,19,12,20],[12,22,12,23],[12,24,12,26],[12,27,12,28],[17,22,17,32],[17,34,17,38],[18,3,18,12],[18,14,18,18],[18,19,18,20],[18,22,18,32],[18,34,18,38],[12,30,12,31],[12,33,12,34],[13,1,13,15],[13,16,13,20],[14,18,14,25],[15,1,15,40],[21,2,21,12],[21,34,21,38],[21,39,21,40],[22,14,22,18],[23,14,23,18],[24,14,24,18],[24,34,24,38],[19,2,19,12],[19,22,19,32],[19,34,19,38],[20,3,20,12],[20,14,20,18],[20,19,20,20],[20,22,20,32],[20,34,20,38],[27,25,27,28],[27,29,27,32],[27,34,27,38],[28,14,28,18],[28,19,28,20],[28,34,28,38],[25,14,25,18],[25,34,25,38],[26,14,26,18],[26,25,26,28],[26,29,26,32],[26,34,26,38],[41,16,41,17],[30,1,30,20],[30,34,30,38],[32,30,32,32],[32,34,32,38],[33,7,33,10],[33,11,33,13],[33,14,33,18],[33,25,33,32],[33,34,33,38],[34,14,34,18],[34,34,34,38],[51,37,51,38],[34,39,34,40],[35,34,35,38],[35,39,35,40],[36,14,36,18],[36,19,36,20],[37,22,37,28],[37,31,37,38],[41,25,41,29],[41,30,41,31],[41,32,41,36],[38,34,38,38],[44,2,44,40],[50,22,50,23],[50,24,50,25],[50,26,50,27],[50,35,50,36],[50,37,50,38],[40,2,40,10],[40,11,40,15],[40,25,40,29],[40,31,40,37],[41,2,41,10],[41,11,41,15],[50,39,50,40],[63,35,63,40],[62,1,62,14],[62,15,62,16],[62,17,62,18],[62,19,62,20],[62,21,62,34],[62,35,62,36],[62,37,62,38],[62,39,62,40],[63,21,63,22],[51,39,51,40],[52,1,52,40],[61,15,61,16],[61,17,61,18],[61,19,61,20],[61,35,61,36],[61,37,61,38],[61,39,61,40],[51,12,51,13],[51,22,51,23],[51,24,51,25],[51,26,51,27],[51,35,51,36]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RECONDUCTION DU BAIL"]
[]
[null,"Nom et adresse du locataire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nom et adresse de l'organisme"]
[null,"Nom prenom 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nom org"]
[null,"Adr log 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"App.  ",null,null,null,"Adr org 1"]
[null,"Adr log 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adr org 2"]
[]
[null,"Madame, Monsieur,"]
[null,"Votre bail a été reconduit pour la période du ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,null,"–",4,null,"–",1,null,"au",null,null,27,null,"–",4,null,"–",1,null,"."]
[null,"Le montant mensuel de votre loyer sera de ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,396,null,null,null,null,null,"et a été établi comme suit :"]
[]
[null,"DÉTERMINATION DE LA CONTRIBUTION AU LOYER"]
[null,"1",null,"Contribution mensuelle de base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2",null,"Contribution mensuelle des personnes indépendantes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nom enfant 3"]
[null,null,"A)","Nom prenom 1",null,null,null,null,null,null,null,null,null,null,833.33,null,null,null,null,"(4)",null,null,""]
[null,null,"Occupant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"B)","Nom prenom 2",null,null,null,null,null,null,null,null,null,null,750,null,null,null,null,"(5)",null,null,""]
[null,null,"Occupant 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contribution mensuelle totale",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"(9)"]
[null,null,"C)","Total de (4) et (5)",null,null,null,null,null,null,null,null,null,null,1583.33]
[null,null,"D)","Taux d'effort 25 % ",null,null,null,null,null,null,null,null,null,null,395.83,null,null,null,null,null,null,"3",null,"Charges additionnelles mensuelles"]
[null,null,"E)","Abattement ",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"Électricité"]
[null,null,"F)","Total de D moins E",null,null,null,null,null,null,null,null,null,null,395.83,null,null,null,null,null,null,null,"Climatiseur(s)"]
[null,null,"G)","Loyer mensuel minimum de base ",null,null,null,null,null,null,null,null,null,null,344.75,null,null,null,null,null,null,null,"Cochez,",null,null,"Premier",null,null,null,"Additionnel"]
[null,null,"H)","Loyer mensuel de base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extérieur  Intérieur",null,null,null,"Extérieur  Intérieur"]
[null,null,null,"(Sélectionner le plus élevé de F et G)",null,null,null,null,null,null,null,null,null,null,395.83,null,null,null,null,"(7)",null,null,"Avec prise"]
[]
[null,"Loyer protégé (si demandé par l'occupant 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sans prise"]
[]
[null,null,"I)","Loyer mensuel de base de l'année",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stationnement(s) : no(s)"]
[null,null,null,"antérieure",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"+ \", DOLLAR(Parametres!U66))","v":"+ 50,00 $"},null,null,0,null,null,null,null,null,null,null,"Autres : "]
[null,null,"J)","Loyer de référence ",null,null,null,null,null,null,null,null,null,null,808,null,null,null,null,null,null,null,"Total des charges additionnelles",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"(10)"]
[null,null,"K)","Loyer mensuel de base protégé"]
[null,null,null,"(Sélectionner le plus bas de I et J sans",null,null,null,null,null,null,null,null,null,null,395.83,null,null,null,null,"(8)",null,"4",null,"Déductions mensuelles (si applicables)"]
[null,null,null," que ce montant soit inférieur à G)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuisinière non fournie ",null,null,null,null,null,null,null,null,"Réfrigérateur non fournie "]
[null,null,"Mesure activée :",null,null,null,null,null,"Oui",null,null,"Non",null,null,null,"L'occupant 1 n'a plus",null,null,null,null,null,null,"Total des déductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     (11)"]
[null,null,"Période :",null,null,null,null,null,null,null,null,null,null,null,null,"droit à la mesure"]
[null,null,"Loyer mensuel total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loyer mensuel",null,null,null,null,null,null,null,null,null,null,"Supplément non membre"]
[null,null,"(( 7 ou 8) + 9 + 10 - 11)",null,null,null,null,null,null,null,null,395.83,null,null,null,null,null,null,null,null,"Total arrondi",null,null,null,null,396,null,null,null,null,"+"]
[]
[]
[null,null,"  Le calcul a été effectué à partir des preuves de revenus que vous avez fournies pour votre ménage ainsi que des "]
[null,null,"  informations que vous avez transmises à l'organisme."]
[]
[null,null,"  Le montant de votre loyer a été indexé pour la 1re",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2e",null,"3e",null,"année, conformément aux pourcentages d' augmentations"]
[null,null,"  accordés  annuellement  par les gouvernements.    Si en cours d' année vous bénéficiez d' une nouvelle  source de revenus ou"]
[null,null,"  que vos revenus sont modifiés autrement que par les indexations prévues,  vous devez avisez le locateur dans le mois qui suit"]
[null,null,"  un tel changement."]
[]
[null,"REMARQUES"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature (personne mandatée)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,"M",null,"J"]
[]
[null,"SHQ-2001-05 M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"Report!P27","v":"2026.01"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2026-03-19T13:53:03.070"}]

{"sheet":"Impr_bail_EN","index":17,"n_rows":64,"n_cols":40,"rows_kept":64,"cut":false,"hidden":true,"merged":[[7,1,7,20],[7,21,7,40],[8,1,8,16],[8,17,8,20],[8,21,8,40],[9,1,9,20],[9,21,9,40],[1,11,1,30],[2,11,2,30],[3,11,3,30],[5,18,5,25],[6,1,6,20],[6,21,6,40],[10,1,10,20],[10,21,10,40],[11,1,11,20],[11,21,11,40],[12,1,12,15],[12,16,12,17],[12,19,12,20],[12,22,12,23],[12,24,12,26],[12,27,12,28],[17,22,17,32],[17,34,17,38],[18,3,18,12],[18,14,18,18],[18,19,18,20],[18,22,18,32],[18,34,18,38],[12,30,12,31],[12,33,12,34],[13,1,13,15],[13,16,13,20],[14,18,14,25],[15,1,15,40],[21,2,21,12],[21,34,21,38],[21,39,21,40],[22,14,22,18],[23,14,23,18],[24,14,24,18],[24,34,24,38],[19,2,19,12],[19,22,19,32],[19,34,19,38],[20,3,20,12],[20,14,20,18],[20,19,20,20],[20,22,20,32],[20,34,20,38],[27,25,27,28],[27,29,27,32],[27,34,27,38],[28,14,28,18],[28,19,28,20],[28,22,28,25],[28,34,28,38],[25,14,25,18],[25,34,25,38],[26,14,26,18],[26,25,26,28],[26,29,26,32],[26,34,26,38],[30,1,30,20],[30,22,30,25],[30,34,30,38],[32,30,32,32],[32,34,32,38],[33,6,33,9],[33,11,33,13],[33,14,33,18],[33,25,33,32],[33,34,33,38],[44,2,44,40],[50,22,50,23],[50,24,50,25],[50,26,50,27],[50,35,50,36],[50,37,50,38],[50,39,50,40],[40,2,40,10],[40,11,40,15],[40,25,40,29],[40,31,40,37],[41,2,41,10],[41,11,41,15],[41,16,41,17],[34,39,34,40],[35,34,35,38],[35,39,35,40],[36,14,36,18],[36,19,36,20],[37,22,37,28],[37,31,37,38],[41,25,41,29],[41,30,41,31],[41,32,41,36],[38,34,38,38],[34,14,34,18],[34,34,34,38],[51,39,51,40],[52,1,52,40],[61,15,61,16],[61,17,61,18],[61,19,61,20],[61,35,61,36],[61,37,61,38],[61,39,61,40],[63,35,63,40],[62,1,62,14],[62,15,62,16],[62,17,62,18],[62,19,62,20],[62,21,62,34],[62,35,62,36],[62,37,62,38],[62,39,62,40],[51,12,51,13],[51,22,51,23],[51,24,51,25],[51,26,51,27],[51,35,51,36],[51,37,51,38]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEASE RENEWAL"]
[]
[null,"Name and address of tenant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name and address of organization"]
[]
[]
[]
[]
[null,"Dear Madam, Dear Sir,"]
[null,"Your lease has been renewed for the period from",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"–",null,null,"–",null,null,"to",null,null,null,null,"–",null,null,"–",null,null,"."]
[null,"Your total monthly rent will be: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"and it has been calculated as follows :"]
[]
[null,"CALCULATION OF THE RENT CONTRIBUTION"]
[null,"1",null,"Basic monthly contribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2",null,"Monthly contribution of independent persons"]
[]
[null,null,"A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(4)"]
[null,null,"Occupant 1"]
[null,null,"B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(5)"]
[null,null,"Occupant 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total monthly contribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(9)"]
[null,null,"C)","Total of (4) and (5)"]
[null,null,"D)","Rent-to-income rate 25% ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3",null,"Additional monthly charges"]
[null,null,"E)","Abatement ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Domestic electricity"]
[null,null,"F)","Total of D minus E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air conditioner"]
[null,null,"G)","Basic minimum monthly rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check",null,null,"First",null,null,null,"Additional"]
[null,null,"H)","Basic monthly rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outdoor  Indoor",null,null,null,"Outdoor    Indoor"]
[null,null,null,"(The higher of F and G)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(7)",null,null,"With electrical \noutlet"]
[]
[null,"Protected rent (if requested by occupant 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Without electrical \noutlet"]
[]
[null,null,"I)","Basic monthly rent for the preceding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parking :                      no."]
[null,null,null,"year",null,null,null,null,null,null,"+",{"$f":"Parametres!U66","v":50},null,null,null,null,null,null,null,null,null,null,"Other : "]
[null,null,"J)","Reference rent ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total additional charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(10)"]
[null,null,"K)","Basic monthly protected rent"]
[null,null,null,"(The lower of I or J)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(8)",null,"4",null,"Monthly deductions (if applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stove not included ",null,null,null,null,null,null,null,null,"Refrigerator not included"]
[null,null,"Measure activated :",null,null,null,null,null,"Yes",null,null,"No",null,null,"  Occupant 1 does not have",null,null,null,null,null,null,null,"Total deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     (11)"]
[null,null,"Period:",null,null,null,null,null,null,null,null,null,null,null,"   a right to this measure"]
[null,null,"Total monthly rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounded total",null,null,null,null,null,null,null,null,null,null,"Non-member supplement "]
[null,null,"(( 7 or 8) + 9 + 10 - 11)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"monthly rent",null,null,null,null,null,null,null,null,null,"+"]
[]
[]
[null,null,"  This calculation is based on the proof of income you have provided for your household and on the information you have given"]
[null,null,"  to the orgainzation."]
[]
[null,null,"  Your rent has been indexed for the",null,null,null,null,null,null,null,null,null,null,"1st",null,null,"2nd",null,null,"3rd",null,null,"year, according to the annual indexation rate established"]
[null,null,"  by the competent authorities. However, if during the year, you obtain a new source of income or begin to receive a different"]
[null,null,"  type of allowance, you must inform the lessor thereof in the month following such a change."]
[]
[]
[null,"COMMENTS"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature (authorized person)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",null,"M",null,"D"]
[]
[null,"SHQ-2001-05A M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"Report!P27","v":"2026.01"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2026-03-19T13:53:03.070"}]

{"sheet":"Report","index":18,"n_rows":144,"n_cols":20,"rows_kept":144,"cut":false,"hidden":true,"merged":[[38,2,38,11],[39,10,39,11],[40,10,40,11],[29,2,29,11],[31,10,31,11],[1,7,1,8],[1,12,1,13],[33,10,33,11],[35,10,35,11],[36,10,36,11],[16,2,16,11],[17,2,17,11],[18,2,18,11],[19,2,19,11],[20,2,20,11],[12,2,12,13],[13,3,13,13],[14,3,14,13],[51,10,51,11],[52,10,52,11],[53,10,53,11],[54,3,55,10],[56,2,56,3],[56,5,56,9],[56,10,56,11],[41,10,41,11],[42,10,42,11],[43,10,43,11],[44,10,44,11],[45,10,45,11],[47,2,47,11],[57,10,57,11],[59,2,59,11],[60,2,60,3],[60,5,60,6],[60,7,60,8],[60,10,60,11],[63,2,63,3],[63,5,63,6],[63,7,63,8],[63,10,63,11],[66,2,66,11],[66,12,66,13],[68,10,68,11],[61,2,61,3],[61,5,61,6],[61,7,61,8],[61,10,61,11],[61,12,61,13],[62,2,62,3],[62,5,62,6],[62,7,62,8],[62,10,62,11],[63,12,63,13],[64,2,64,3],[64,5,64,6],[64,7,64,8],[64,10,64,11],[79,10,79,11],[80,10,80,11],[81,10,81,11],[83,10,83,11],[84,10,84,11],[85,10,85,11],[73,10,73,11],[74,10,74,11],[74,12,74,13],[76,10,76,11],[78,2,78,11],[69,10,69,11],[70,10,70,11],[72,10,72,11],[72,12,72,13],[111,10,111,11],[112,10,112,11],[89,2,89,11],[90,10,90,11],[91,10,91,11],[92,10,92,11],[94,2,94,11],[95,10,95,11],[96,10,96,11],[97,3,98,9],[97,10,97,11],[97,12,97,13],[100,2,100,11],[101,10,101,11],[102,10,102,11],[103,10,103,11],[104,10,104,11],[105,10,105,11],[106,10,106,11],[87,10,87,11],[107,10,107,11],[108,10,108,11],[109,10,109,11],[110,10,110,11],[139,9,139,11],[115,2,115,3],[115,4,115,5],[115,7,115,11],[116,9,116,11],[117,9,117,11],[121,2,121,11],[122,7,122,11],[123,9,123,11],[133,2,133,11],[134,2,134,4],[134,7,134,11],[137,2,137,4],[137,7,137,11],[138,9,138,11],[128,7,128,10],[115,12,115,14],[129,5,129,6],[129,7,129,8],[129,9,129,10],[130,7,130,8],[130,9,130,10],[124,9,124,11],[125,2,125,5],[128,2,128,4],[128,5,128,6],[122,2,122,5]]}
[null,null,"Cette couleur : cellules avec formules.",null,null,null,"Cette couleur : cellules inutilisées."]
[null,null,null,null,"Famille","Mineur",null,"Lien de parenté",null,"Enfant","Personne",null,"Assistance-emploi",null,null,"Table des liens",null,null,"Table des valeurs pour l'assistance-emploi"]
[null,null,"Étud.","Hand.","accueil","émanc.","Sexe","Index","Valeur","à charge","indépend.","Contrib.","Index","Valeur",null,"de parenté",null,null,"Les cellules S4 à S9 sont utilisées dans les listes de valeurs au haut de l'onglet Calcul."]
[null,1,false,false,false,false,0,1,{"$f":"IF(H4=1,$Q$14,9)","v":0},{"$f":"IF(CEL_NOM_1=\"\", \"\", IF(AND(CEL_AGE_1<18, NOT(CHK_MINE_1)), FALSE, IF(AND(CEL_AGE_1>=18, CHK_ETUD_1), FALSE, FALSE)))","v":""},{"$f":"IF(CEL_NOM_1=\"\", \"\", AND(OR(CEL_AGE_1>=18, CHK_MINE_1), AND(NOT(CEL_ENFC_1), NOT(AND(CHK_FAMA_1,COM_PARE_1=6)))))","v":""},true,1,{"$f":"IF(REP_OCC_1=1,$T$4,IF(REP_OCC_1=2,$T$5,IF(REP_OCC_1=3,$T$6,IF(REP_OCC_1=4,$T$7,IF(REP_OCC_1=5,$T$8,IF(REP_OCC_1=6,$T$9))))))","v":0},null,null,9]
[1,2,false,false,false,false,0,1,{"$f":"IF(H5=1,$Q$18,IF(H5=2,$Q$19,IF(H5=3,$Q$20,IF(H5=4,$Q$21,IF(H5=5,$Q$22,IF(H5=6,$Q$23,9))))))","v":9},{"$f":"IF(CEL_NOM_2=\"\", \"\", IF(AND(CEL_AGE_2<18, NOT(CHK_MINE_2)), IF(H5=2,FALSE,TRUE), IF(AND(CEL_AGE_2>=18, CHK_ETUD_2), IF(H5=2,FALSE,TRUE), FALSE)))","v":""},{"$f":"IF(CEL_NOM_2=\"\", \"\", AND(OR(CEL_AGE_2>=18, CHK_MINE_2), AND(NOT(CEL_ENFC_2), NOT(AND(CHK_FAMA_2,COM_PARE_2=6)))))","v":""},{"$f":"IF(CEL_NOM_2=\"\", FALSE, IF(CEL_INDE_2, TRUE, FALSE))","v":false},1,{"$f":"IF(REP_OCC_2=1,$T$4,IF(REP_OCC_2=2,$T$5,IF(REP_OCC_2=3,$T$6,IF(REP_OCC_2=4,$T$7,IF(REP_OCC_2=5,$T$8,IF(REP_OCC_2=6,$T$9, 9))))))","v":0},null,"Occupant 1",0,1,"n'est pas prestataire de l'aide sociale et solidarité sociale"]
[null,3,false,false,false,false,0,1,{"$f":"IF(H6=1,$Q$18,IF(H6=2,$Q$19,IF(H6=3,$Q$20,IF(H6=4,$Q$21,IF(H6=5,$Q$22,IF(H6=6,$Q$23,9))))))","v":9},{"$f":"IF(CEL_NOM_3=\"\", \"\", IF(AND(CEL_AGE_3<18, NOT(CHK_MINE_3)), IF(H6=2,FALSE,TRUE), IF(AND(CEL_AGE_3>=18, CHK_ETUD_3), IF(H6=2,FALSE,TRUE), FALSE)))","v":""},{"$f":"IF(CEL_NOM_3=\"\", \"\", AND(OR(CEL_AGE_3>=18, CHK_MINE_3), AND(NOT(CEL_ENFC_3), NOT(AND(CHK_FAMA_3,COM_PARE_3=6)))))","v":""},{"$f":"IF(CEL_NOM_3=\"\", FALSE, IF(CEL_INDE_3, TRUE, FALSE))","v":false},null,null,null,"Conjoint",1,2,"est prestataire du programme d'aide sociale, sans contraintes à l'emploi,"]
[1,4,false,false,false,false,0,1,{"$f":"IF(H7=1,$Q$18,IF(H7=2,$Q$19,IF(H7=3,$Q$20,IF(H7=4,$Q$21,IF(H7=5,$Q$22,IF(H7=6,$Q$23,9))))))","v":9},{"$f":"IF(CEL_NOM_4=\"\", \"\", IF(AND(CEL_AGE_4<18, NOT(CHK_MINE_4)), IF(H7=2,FALSE,TRUE), IF(AND(CEL_AGE_4>=18, CHK_ETUD_4), IF(H5=7,FALSE,TRUE), FALSE)))","v":""},{"$f":"IF(CEL_NOM_4=\"\", \"\", AND(OR(CEL_AGE_4>=18, CHK_MINE_4), AND(NOT(CEL_ENFC_4), NOT(AND(CHK_FAMA_4,COM_PARE_4=6)))))","v":""},{"$f":"IF(CEL_NOM_4=\"\", FALSE, IF(CEL_INDE_4, TRUE, FALSE))","v":false},null,null,null,"Fils, fille ",3,3,"est prestataire du programme d'aide sociale, avec contraintes temporaires."]
[1,5,false,false,false,false,0,1,{"$f":"IF(H8=1,$Q$18,IF(H8=2,$Q$19,IF(H8=3,$Q$20,IF(H8=4,$Q$21,IF(H8=5,$Q$22,IF(H8=6,$Q$23,9))))))","v":9},{"$f":"IF(CEL_NOM_5=\"\", \"\", IF(AND(CEL_AGE_5<18, NOT(CHK_MINE_5)), IF(H8=2,FALSE,TRUE), IF(AND(CEL_AGE_5>=18, CHK_ETUD_5), IF(H8=2,FALSE,TRUE), FALSE)))","v":""},{"$f":"IF(CEL_NOM_5=\"\", \"\", AND(OR(CEL_AGE_5>=18, CHK_MINE_5), AND(NOT(CEL_ENFC_5), NOT(AND(CHK_FAMA_5,COM_PARE_5=6)))))","v":""},{"$f":"IF(CEL_NOM_5=\"\", FALSE, IF(CEL_INDE_5, TRUE, FALSE))","v":false},null,null,null,"Petit-fils, petite-fille",5,4,"est prestataire du programme de solidarité sociale, avec contraintes sévères."]
[1,6,false,false,false,false,0,1,{"$f":"IF(H9=1,$Q$18,IF(H9=2,$Q$19,IF(H9=3,$Q$20,IF(H9=4,$Q$21,IF(H9=5,$Q$22,IF(H9=6,$Q$23,9))))))","v":9},{"$f":"IF(CEL_NOM_6=\"\", \"\", IF(AND(CEL_AGE_6<18, NOT(CHK_MINE_6)), IF(H9=2,FALSE,TRUE), IF(AND(CEL_AGE_6>=18, CHK_ETUD_6), IF(H9=2,FALSE,TRUE), FALSE)))","v":""},{"$f":"IF(CEL_NOM_6=\"\", \"\", AND(OR(CEL_AGE_6>=18, CHK_MINE_6), AND(NOT(CEL_ENFC_6), NOT(AND(CHK_FAMA_6,COM_PARE_6=6)))))","v":""},{"$f":"IF(CEL_NOM_6=\"\", FALSE, IF(CEL_INDE_6, TRUE, FALSE))","v":false},null,null,null,"Autres liens",7,5,"est prestataire du programme de revenu de base (66/72)."]
[null,null,null,null,null,null,null,null,null,"Adultes",{"$f":"IF(CEL_INDE_1=\"\",0,IF(CEL_INDE_1,1,0))+IF(CEL_INDE_2=\"\",0,IF(CEL_INDE_2,1,0))+IF(CEL_INDE_3=\"\",0,IF(CEL_INDE_3,1,0))+IF(CEL_INDE_4=\"\",0,IF(CEL_INDE_4,1,0))+IF(CEL_INDE_5=\"\",0,IF(CEL_INDE_5,1,0))+IF(CEL_INDE_6=\"\",0,IF(CEL_INDE_6,1,0))","v":0}]
[null,null,false,"Programme PSL",null,0,"Coopérative d'habitation",null,null,"Enfants",{"$f":"IF(CEL_INDE_1=\"\",0,IF(CEL_INDE_1,0,1))+IF(CEL_INDE_2=\"\",0,IF(CEL_INDE_2,0,1))+IF(CEL_INDE_3=\"\",0,IF(CEL_INDE_3,0,1))+IF(CEL_INDE_4=\"\",0,IF(CEL_INDE_4,0,1))+IF(CEL_INDE_5=\"\",0,IF(CEL_INDE_5,0,1))+IF(CEL_INDE_6=\"\",0,IF(CEL_INDE_6,0,1))","v":0},null,null,null,null,"Liens de parenté"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1)"]
[null,null,"Calcul du loyer minimum de base",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q4","v":9}]
[null,null,"Occupant 1 : ",{"$f":"INDEX($S$4:$S$9,MATCH($M$4,$B$4:$B$9,0),1)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P5","v":"Occupant 1"},{"$f":"Q5","v":0}]
[null,null,"Occupant 2 : ",{"$f":"INDEX($S$4:$S$9,MATCH($M$5,$B$4:$B$9,0),1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Adu-Enf","Occupation",null,"Liens de parenté"]
[null,3,{"$f":"SUBSTITUTE(Parametres!$B$13,\"Article \",\"\")","v":"8,3 - Ménage avec enfant \noccupants 1 et 2 ont des contraintes temporaires à l'emploi"},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"PRM_ART_8_\"& $B17 &\"_\"& IF(CEL_NBRE_ADUL>=2,2,CEL_NBRE_ADUL) &\"ADU_\"& IF(CEL_NBRE_ENFA>=2,2,CEL_NBRE_ENFA) &\"ENF\"),\"\")","v":""},{"$f":"IF(AND(REP_OCC_1<>2,REP_OCC_2<>2,REP_OCC_1<>3,REP_OCC_2<>3,REP_OCC_1<>5,REP_OCC_2<>5,OR(REP_OCC_1=4,REP_OCC_2=4)),M17,\"-\")","v":"-"},null,"(2)"]
[null,4,{"$f":"SUBSTITUTE(Parametres!$B$18,\"Article \",\"\")","v":"8,4 - Ménage avec enfant\nl'un des occupants est sans contrainte et l'autre avec des contraintes temporaires à l'emploi"},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"PRM_ART_8_\"& $B18 &\"_\"& IF(CEL_NBRE_ADUL>=2,2,CEL_NBRE_ADUL) &\"ADU_\"& IF(CEL_NBRE_ENFA>=2,2,CEL_NBRE_ENFA) &\"ENF\"),\"\")","v":""},{"$f":"IF(AND(OR(REP_OCC_1=3,REP_OCC_2=3),OR(REP_OCC_1=4,REP_OCC_2=4)),M18,\"-\")","v":"-"},null,null,{"$f":"Q4","v":9}]
[null,5,{"$f":"SUBSTITUTE(Parametres!$B$22,\"Article \",\"\")","v":"8,5 - Ménage avec enfant dont au moins l'un des occupants est bénéficiaire du programme de solidarité sociale (contraintes sévères à l'emploi) - PRESTATIONS RÉGULIÈRES"},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"PRM_ART_8_\"& $B19 &\"_\"& IF(CEL_NBRE_ADUL>=2,2,CEL_NBRE_ADUL) &\"ADU_\"& IF(CEL_NBRE_ENFA>=2,2,CEL_NBRE_ENFA) &\"ENF\"),\"\")","v":""},{"$f":"IF(AND(REP_OCC_1<>2,REP_OCC_2<>2,OR(REP_OCC_1=5,REP_OCC_2=5),OR(REP_OCC_1=5,REP_OCC_2=5,REP_OCC_1=6,REP_OCC_2=6)),M19,\"-\")","v":"-"},null,{"$f":"P6","v":"Conjoint"},1]
[null,6,{"$f":"SUBSTITUTE(Parametres!$B$27,\"Article \",\"\")","v":"8,6 - Ménage avec enfant dont les occupants sont TOUS bénéficiaires du programme régulier de solidarité sociale (contraintes sévères à l'emploi) – PROGRAMME DE REVENU DE BASE"},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"PRM_ART_8_\"& $B20 &\"_\"& IF(CEL_NBRE_ADUL>=2,2,CEL_NBRE_ADUL) &\"ADU_\"& IF(CEL_NBRE_ENFA>=2,2,CEL_NBRE_ENFA) &\"ENF\"),\"\")","v":""},{"$f":"IF(AND(REP_OCC_1<>2,REP_OCC_2<>2,REP_OCC_1<>3,REP_OCC_2<>3,REP_OCC_1<>4,REP_OCC_2<>4,REP_OCC_2<>3,REP_OCC_1<>5,REP_OCC_2<>5,OR(REP_OCC_1=6,REP_OCC_2=6)),M20,\"-\")","v":"-"},null,"Fils, fille ",3]
[null,7,{"$f":"SUBSTITUTE(Parametres!$B$32,\"Article \",\"\")","v":"8,7 - Ménage dont l'un des occupants est non prestataire"},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"PRM_ART_8_\"&$B21&\"_\"& IF(CEL_NBRE_ADUL>=2,2,CEL_NBRE_ADUL) &\"ADU_\"& IF(CEL_NBRE_ENFA>=2,2,CEL_NBRE_ENFA) &\"ENF\"),\"\")","v":""},{"$f":"IF(AND(OR(REP_OCC_1<>1,REP_OCC_2<>1),SUM(N17:N20)=0),M21,\"-\")","v":"-"},null,"Petit-fils, petite-fille",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Résidant fam. acc.",6]
[null,null,null,null,null,null,null,null,null,null,null,null,"Loyer minimum de base :",{"$f":"SUM(N17:N21)","v":0},null,{"$f":"P9","v":"Autres liens"},{"$f":"Q9","v":7}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026.01"]
[]
[]
[null,null,"Calcul du revenu mensuel considéré de l'occupant 2"]
[null,null,{"$f":"IF(CEL_CONT_2,1,2)","v":2},{"$f":"IF(C31=1,\"Le revenu de l'occupant 2 est considéré\",IF(C31=2,\"Le revenu de l'occupant 2 n'est pas considéré\",\"\"))","v":"Le revenu de l'occupant 2 n'est pas considéré"}]
[null,null,null,{"$f":"IF(C31=2,\"Revenu mensuel considéré :\",\"\")","v":"Revenu mensuel considéré :"},null,null,null,null,null,null,{"$f":"IF(C31=2,0,\"\")","v":0}]
[null,null,{"$f":"IF(C31=1,IF(COM_PARE_2=3,1,2),\"\")","v":""},{"$f":"IF(C33=1,\"L'occupant 2 est un enfant de l'occupant 1\",IF(C33=2,\"L'occupant 2 n'est pas un enfant de l'occupant 1\",\"\"))","v":""}]
[null,null,null,{"$f":"IF(C33=2,\"Revenu mensuel considéré :\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(C33=2,RV_REV_MENS_CONS2,\"\")","v":""}]
[null,null,{"$f":"IF(C33=1,IF(CEL_AGE_2<21,1,IF(CEL_AGE_2<25,2,3)),\"\")","v":""},{"$f":"IF(C35=1,\"L'enfant est âgé de moins de 21 ans\",IF(C35=2,\"L'enfant est âgé entre 21 et 24 ans\",IF(C35=3,\"L'enfant est âgé de plus de 24 ans\",\"\")))","v":""}]
[null,null,null,{"$f":"IF(C35=\"\",\"\",\"Revenu mensuel considéré :\")","v":""},null,null,null,null,null,null,{"$f":"IF(C35=1,MIN(RV_REV_MENS_CONS2,Parametres!N52),IF(C35=2,MIN(RV_REV_MENS_CONS2,Parametres!U52),IF(C35=3,RV_REV_MENS_CONS2,\"\")))","v":""}]
[null,null,null,"Revenu mensuel considéré :",null,null,null,null,null,null,{"$f":"IF(K32=\"\",0,K32)+IF(K34=\"\",0,K34)+IF(K36=\"\",0,K36)","v":0}]
[]
[null,null,"Calcul de l'abattement mensuel"]
[null,null,null,"Revenu annuel total de travail (moins 10 %) de l'occupant 1 :",null,null,null,null,null,null,{"$f":"ROUND(SUM(Revenus!O20:R23)*0.9,2)","v":0}]
[null,null,null,"Revenu annuel total de travail (moins 10 %) de l'occupant 2 :",null,null,null,null,null,null,{"$f":"ROUND(SUM(Revenus!S20:V23)*0.9,2)","v":0}]
[null,null,null,"Revenu annuel total considéré de l'occupant 2 :",null,null,null,null,null,null,{"$f":"CEL_REVE_MENS_2*12","v":0}]
[null,null,null,"Revenu annuel total de travail considéré de l'occupant 2 :",null,null,null,null,null,null,{"$f":"MIN(K41,K42)","v":0}]
[null,null,null,"Revenu annuel total de travail considéré des occupants 1 et 2 :",null,null,null,null,null,null,{"$f":"K40+K43","v":0}]
[null,null,null,"Calcul de l'abattement mensuel (2 % des revenus annuels de travail)",null,null,null,null,null,null,{"$f":"ROUND(K44*0.02,2)","v":0}]
[null,null,null,{"$f":"CONCATENATE(\"Abattement mensuel (maximum \",DOLLAR(Parametres!U59),\")\")","v":"Abattement mensuel (maximum 30,00 $)"},null,null,null,null,null,null,{"$f":"MIN(K45,Parametres!U59)","v":0}]
[]
[null,null,"Activation du loyer protégé"]
[null,null,{"$f":"IF(OR(AND(SUM(Revenus!$O$7:$R$8)+SUM(Revenus!$S$7:$V$8)=0,SUM(Revenus!$O$20:$R$23,Revenus!$O$31)+SUM(Revenus!$S$20:$V$23,Revenus!$S$31)>0),AND(SUM(Revenus!$O$7:$R$8)>0,SUM(Revenus!$O$20:$R$23,Revenus!$O$31)=0,SUM(Revenus!$S$7:$V$8)=0,SUM(Revenus!$S$20:$V$23,Revenus!$S$31)>0)),\n    1,\n    2)","v":2},{"$f":"IF(C49=\"\",\n    \"\",\n    IF(C49=1,\n        \"L'occupant 1 rend le ménage éligible à la mesure\",\n        IF(C49=2,\n            \"L'occupant 1 ne rend pas le ménage éligible à la mesure\",\n            \"\")))","v":"L'occupant 1 ne rend pas le ménage éligible à la mesure"}]
[null,null,{"$f":"IF(OR(AND(SUM(Revenus!$O$7:$R$8)+SUM(Revenus!$S$7:$V$8)=0,SUM(Revenus!$O$20:$R$23,Revenus!$O$31)+SUM(Revenus!$S$20:$V$23,Revenus!$S$31)>0),AND(SUM(Revenus!$O$7:$R$8)=0,SUM(Revenus!$O$20:$R$23,Revenus!$O$31)>0,SUM(Revenus!$S$7:$V$8)>0,SUM(Revenus!$S$20:$V$23,Revenus!$S$31)=0)),\n    1,\n    2)","v":2},{"$f":"IF(C50=\"\",\n    \"\",\n    IF(C50=1,\n        \"L'occupant 2 rend le ménage éligible à la mesure\",\n        IF(C50=2,\n            \"L'occupant 2 ne rend pas le ménage éligible à la mesure\",\n            \"\")))","v":"L'occupant 2 ne rend pas le ménage éligible à la mesure"}]
[null,null,{"$f":"IF(SUM(Revenus!$O$7:$S$8)>0,0,IF(OR(C49=1,C50=1),1,0))","v":0},{"$f":"IF(C51=\"\",\n    \"\",\n    IF(C51=0,\n        \"Le ménage n'est pas éligible à la mesure\",\n        IF(C51=1,\n            \"Le ménage est éligible à la mesure\",\n            \"\")))","v":"Le ménage n'est pas éligible à la mesure"}]
[null,null,null,"Loyer mensuel de base (ou loyer mensuel de base indexé)",null,null,null,null,null,null,{"$f":"CEL_LOY_MENS_BASE","v":0}]
[null,null,null,"Loyer minimum de base",null,null,null,null,null,null,{"$f":"CEL_LOYM_BASE","v":0}]
[null,null,null,"Loyer mensuel de base protégé",null,null,null,null,null,null,{"$f":"CEL_LOY_MENS_BASE_PROT","v":0}]
[null,null,{"$f":"IF(C51=1,\n    IF(K54=K53,\n        5,\n        IF(K54=\"\",\n            \"\",\n            IF(K54<K53,\n                3,\n                IF(K54<K52,\n                    1,\n                    2)))),\n    4)","v":4},{"$f":"IF(C55=\"\",\n    \"\",\n    IF(C55=1,\n        \"La mesure peut être activée.\",\n        IF(C55=2,\n            \"La mesure ne peut être activée, puisque le loyer protégé est égal ou supérieur au loyer de base.\",\n            IF(C55=3,\n                \"La mesure ne peut être activée, puisque le loyer protégé est inférieur ou égal au loyer minimum de base.\",\n                IF(C55=4,\n                    \"La mesure ne peut être activée, puisque le ménage n'y est pas éligible.\",\n                    IF(C55=5,\n                        \"La mesure peut être activée, en tenant compte que le loyer mensuel de base ne peut être inférieur au loyer mensuel minimum de base.\",\n                        \"\"))))))","v":"La mesure ne peut être activée, puisque le ménage n'y est pas éligible."}]
[]
[null,null,"Mesure activée",null,"Période","L'occupant 1 n'a plus droit à la mesure",null,null,null,null,"Activation"]
[null,null,false,null,0,false,null,null,null,null,{"$f":"IF(F58,FALSE,IF(OR(C55=1,C55=5),IF(C58,TRUE,FALSE),FALSE))","v":false}]
[]
[null,null,"Contribution mensuelle des personnes indépendantes"]
[null,null,"Occupant",null,"Indép.","Revenus mens.",null,0.25,null,null,"Montant considéré"]
[null,null,3,null,{"$f":"CEL_INDE_3","v":""},{"$f":"IF(E62=\"\",\"\",IF(E62,RV_REV_MENS_CONS3,\"\"))","v":""},null,{"$f":"IF(F62=\"\",\"\",F62*0.25)","v":""},null,null,{"$f":"IF(H62=\"\",\"\",MIN(H62,Parametres!$U$75))","v":""},null,"Charge électricité"]
[null,null,4,null,{"$f":"CEL_INDE_4","v":""},{"$f":"IF(E63=\"\",\"\",IF(E63,RV_REV_MENS_CONS4,\"\"))","v":""},null,{"$f":"IF(F63=\"\",\"\",F63*0.25)","v":""},null,null,{"$f":"IF(H63=\"\",\"\",MIN(H63,Parametres!$U$75))","v":""},null,false]
[null,null,5,null,{"$f":"CEL_INDE_5","v":""},{"$f":"IF(E64=\"\",\"\",IF(E64,RV_REV_MENS_CONS5,\"\"))","v":""},null,{"$f":"IF(F64=\"\",\"\",F64*0.25)","v":""},null,null,{"$f":"IF(H64=\"\",\"\",MIN(H64,Parametres!$U$75))","v":""},null,"Climatiseurs"]
[null,null,6,null,{"$f":"CEL_INDE_6","v":""},{"$f":"IF(E65=\"\",\"\",IF(E65,RV_REV_MENS_CONS6,\"\"))","v":""},null,{"$f":"IF(F65=\"\",\"\",F65*0.25)","v":""},null,null,{"$f":"IF(H65=\"\",\"\",MIN(H65,Parametres!$U$75))","v":""},null,0]
[]
[null,null,"Coût du stationnement",null,null,null,null,null,null,null,null,null,"Stationnements",null,null,null,null,null,"Table des valeurs pour"]
[null,null,null,"Premier calcul",null,null,null,null,null,null,null,null,"Index","Valeur",null,null,null,null,"les stationnements"]
[null,null,null,"Coût du premier stationnement",null,null,null,null,null,null,{"$f":"IF($N$69=0,0,IF($N$69=1,Parametres!$X$89,IF($N$69=2,Parametres!$X$90,IF($N$69=3,Parametres!$X$91,0))))","v":0},null,1,{"$f":"IF(M69=1,$T$69,IF(M69=2,$T$70,IF(M69=3,$T$71,IF(M69=4,$T$72,0))))","v":0},null,null,null,null,null,0]
[null,null,null,"Coût du deuxième stationnement",null,null,null,null,null,null,{"$f":"IF($N$70=0,0,IF($N$70=1,Parametres!$X$92,IF($N$70=2,Parametres!$X$93,IF($N$70=3,Parametres!$X$94,0))))","v":0},null,1,{"$f":"IF(M70=1,$T$69,IF(M70=2,$T$70,IF(M70=3,$T$71,IF(M70=4,$T$72,0))))","v":0},null,null,null,null,"Extérieur sans prise",1]
[null,null,null,"Coût des stationnements ",null,null,null,null,null,null,{"$f":"K69+K70","v":0},null,1,null,null,null,null,null,"Extérieur avec prise",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intérieur",3]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cuisin.","Réfrig."]
[null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
[null,null,"Déductions pour les appareils ménagers",null,null,null,null,null,null,null,null,null,"Cuisin.","Réfrig."]
[null,null,null,"Loyer mensuel de base (ou loyer mensuel protégé)",null,null,null,null,null,null,{"$f":"IF(K58,K54,K52)","v":0},null,false,false]
[null,null,null,"Loyer minimum de base",null,null,null,null,null,null,{"$f":"CEL_LOYM_BASE","v":0}]
[null,null,null,"Déduction maximale pour les appareils ménagers",null,null,null,null,null,null,{"$f":"IF(C11,0,MIN(MAX(K80-K81,0),2*Parametres!U106))","v":0}]
[]
[null,null,null,"Déduction pour cuisinière non fournie",null,null,null,null,null,null,{"$f":"IF(CHK_CUIS_NON_FOURN,Parametres!U106,0)","v":0}]
[null,null,null,"Déduction pour réfrigérateur non fourni",null,null,null,null,null,null,{"$f":"IF(CHK_REFR_NON_FOURN,Parametres!U106,0)","v":0}]
[null,null,null,"Total des déductions pour les appareils ménagers",null,null,null,null,null,null,{"$f":"K84+K85","v":0}]
[]
[null,null,null,"Déduction appliquée pour les appareils ménagers",null,null,null,null,null,null,{"$f":"MIN(K82,K86)","v":0}]
[]
[null,null,"Déductions PSL",null,null,null,null,null,null,null,null,null,"Chauff.","Eau ch."]
[null,null,null,{"$f":"IF(M91,\"Déduction pour chauffage activée\",\"Déduction pour chauffage non activée\")","v":"Déduction pour chauffage non activée"},null,null,null,null,null,null,{"$f":"IF(NOT(C11),\"\",IF(M91,IF(CEL_NBRE_CHAM=0,Parametres!M113,IF(CEL_NBRE_CHAM=1,Parametres!M113,IF(CEL_NBRE_CHAM=2,Parametres!M114,IF(CEL_NBRE_CHAM=3,Parametres!M115,IF(CEL_NBRE_CHAM>3,Parametres!M116,\"\"))))),\"\"))","v":""},null,false,false]
[null,null,null,{"$f":"IF(N91,\"Déduction pour eau chaude activée\",\"Déduction pour eau chaude non activée\")","v":"Déduction pour eau chaude non activée"},null,null,null,null,null,null,{"$f":"IF(NOT(C11),\"\",IF(N91,IF(CEL_NBRE_CHAM=0,Parametres!X113,IF(CEL_NBRE_CHAM=1,Parametres!X113,IF(CEL_NBRE_CHAM=2,Parametres!X114,IF(CEL_NBRE_CHAM=3,Parametres!X115,IF(CEL_NBRE_CHAM>3,Parametres!X116,\"\"))))),\"\"))","v":""},null,false,false]
[null,null,null,"Total des déductions PSL",null,null,null,null,null,null,{"$f":"IF(K91=\"\",0,K91)+IF(K92=\"\",0,K92)","v":0}]
[]
[null,null,"Loyer mensuel de base indexé",null,null,null,null,null,null,null,null,null,"Stat.","Membre"]
[null,null,null,"Loyer mensuel de base indexé",null,null,null,null,null,null,-1,null,"loyer","COOP"]
[null,null,null,"Loyer minimum de base",null,null,null,null,null,null,{"$f":"CEL_LOYM_BASE","v":0},null,0,0]
[null,null,{"$f":"IF(K96=\"\",0,IF(K96<K97,2,1))","v":2},{"$f":"IF(C98=0,\"Le loyer mensuel de base indexé n'est pas activé.\",IF(C98=1,\"Le loyer mensuel de base indexé est retenu.\",IF(C98=2,\"Le loyer mensuel de base indexé n'est pas retenu, puisqu'il est inférieur au loyer minimum de base.\",\"\")))","v":"Le loyer mensuel de base indexé n'est pas retenu, puisqu'il est inférieur au loyer minimum de base."},null,null,null,null,null,null,{"$f":"IF(C98=0,\"\",IF(C98=1,K96,IF(C98=2,\"\",\"\")))","v":""},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Calcul du loyer à payer et du supplément au loyer"]
[null,null,null,"Loyer mensuel de base",null,null,null,null,null,null,{"$f":"IF(K58,K54,K52)","v":0}]
[null,null,null,"Contribution mensuelle des personnes indépendantes",null,null,null,null,null,null,{"$f":"CEL_CONT_PERS_IND","v":0}]
[null,null,null,"Charges",null,null,null,null,null,null,{"$f":"CEL_CHARG_MENS","v":0}]
[null,null,null,"Déductions",null,null,null,null,null,null,{"$f":"IF(C11,0,CEL_DEDUC_MENS_APPM)+IF(C11,CEL_DEDUC_MENS_PSL,0)","v":0}]
[null,null,null,"Part du ménage (montant arrondi)",null,null,null,null,null,null,{"$f":"ROUND(MAX(SUM(K102:L104)-K105,0),0)","v":0}]
[null,null,null,"Supplément non membre maximal",null,null,null,null,null,null,{"$f":"ROUND(SUM(K102:L104)*0.1,2)","v":0}]
[null,null,null,"Supplément non membre que doit défrayer le locataire",null,null,null,null,null,null,{"$f":"CEL_SUPPL_NON_MEMB","v":""}]
[null,null,null,"Loyer au bail",null,null,null,null,null,null,{"$f":"IF(C11,Loyer_a_payer!CEL_LOY_BAIL,\"\")","v":""}]
[null,null,null,"Rabais de membre",null,null,null,null,null,null,{"$f":"IF(C11,IF(Loyer_a_payer!CEL_RABA_MEMB=\"\",0,Loyer_a_payer!CEL_RABA_MEMB),\"\")","v":""}]
[null,null,null,"Loyer reconnu",null,null,null,null,null,null,{"$f":"IF(C11,MAX(K109-K110,0),\"\")","v":""}]
[null,null,null,"Part du ménage",null,null,null,null,null,null,{"$f":"IF(C11,K106,\"\")","v":""}]
[null,null,null,"Supplément au loyer",null,null,null,null,null,null,{"$f":"IF(C11,MAX(K111-K112,0),\"\")","v":""}]
[]
[null,null,"Formulaire d'impression PSL"]
[null,null,"Stationnement",null,"Membre coop",null,null,"Loyer protégé",null,null,null,null,"Indexation"]
[null,null,"Oui","Non","Oui","Non",null,"Oui","Non","L'occ. 1 n'a plus droit…",null,null,"1ère","2e","3e"]
[null,null,true,false,false,true,null,false,true,false,null,null,false,false,false]
[null,null,null,null,null,null,null,"Période :",1,2,3,4]
[null,null,"Annexe utilisée",null,false,null,null,null,false,false,false,false]
[]
[null,null,"Formulaire d'impression non PSL"]
[null,null,"Assistance-emploi",null,null,null,null,"Loyer protégé"]
[null,null,21,22,23,24,null,"Oui","Non","L'occ. 1 n'a plus droit…"]
[null,null,false,false,false,false,null,false,true,false]
[null,null,"Revenus de travail",null,null,null,null,"Période :",1,2,3,4]
[null,null,31,32,33,34,null,null,false,false,false,false]
[null,null,false,false,false,false]
[null,null,"Indexation",null,null,"Annexe utilisée",null,"Déductions mensuelles"]
[null,null,"1ère","2e","3e",false,null,"Cuisinière",null,"Réfrigérateur"]
[null,null,false,false,false,null,null,false,null,false]
[]
[]
[null,null,"Formulaire d'impression reconduction bail"]
[null,null,"Stationnement 1",null,null,"Cuisin.","Réfrig.","Revenus indexés"]
[null,null,"Intérieur","Ext.prise","Ext.spris",false,false,false,false,false,false,false]
[null,null,false,false,false,null,null,false,false,false,false,true]
[null,null,"Stationnement 2",null,null,null,null,"Loyer protégé"]
[null,null,false,false,false,null,null,"Oui","Non","L'occ. 1 n'a plus droit…"]
[null,null,null,null,null,null,null,false,true,false]
[null,null,null,null,null,null,null,"Période :",1,2,3,4]
[null,null,null,null,null,null,null,null,false,false,false,false]
[]
[null,null,"Code de langue sélectionné",null,null,null,1,{"$f":"IF(G144=1,\"FR\",\"EN\")","v":"FR"}]