{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["AEI","Paramètres","Subvention fonctionnement-25-26"],"not_rendered":{"images":2,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"AEI","index":0,"n_rows":46,"n_cols":71,"rows_kept":46,"merged":[[5,2,5,18],[7,1,9,1],[27,0,29,0],[31,0,33,0]]}
[]
[]
[]
[null,null,"Estimation du montant de l'allocation exceptionnelle pour l'intégration (AEI)"]
[]
[null,null,"Cet outil sert à produire une estimation pour l'exercice financier 2026-2027. Il ne reflète pas le montant réel de votre allocation."]
[]
[null,"Veuillez lire les instructions avant d'utiliser le simulateur"]
[null,null,"Instruction 1 :  Vous devez remplir les cases bleues selon votre situation. Lorsqu’un menu déroulant est disponible, veuillez choisir l’option correspondant à votre situation.  \t\t"]
[null,null,"Instruction 2 : Veuillez choisir, dans le menu déroulant sous le nom de chaque enfant, l'option correspondant à sa situation (Non-SEH, SEH, SEHNSE-1 ou SEHNSE-2)"]
[]
[null,"Sigles et acronymes"]
[null,"Palier :"]
[null,"SEH : Supplément pour enfant handicapé versé par Retraite Québec"]
[null,"SEHNSE : Supplément pour enfant handicapé nécessitant des soins exceptionnels délivré par Retraite Québec"]
[null,"SEHNSE-1 : Supplément pour enfant handicapé nécessitant des soins exceptionnels (palier 1) versé par Retraite Québec"]
[null,"SEHNSE-2 : Supplément pour enfant handicapé nécessitant des soins exceptionnels (palier 2) versé par Retraite Québec"]
[null,"Non SEH : Aucun supplément pour enfant handicapé versé par Retraite Québec"]
[null,"AEI : Allocation exceptionnelle pour l'intégration "]
[null,"MES : Mesure exceptionnelle de soutien à l'intégration en service de garde "]
[null,"PISG : Portail inscription service de garde"]
[]
[null,"Veuillez sélectionner le nombre d'enfants",4]
[]
[null,"Identification de l'enfant par le numéro de PISG ","1XXXXXXXXXXX",null,"2XXXXXXXXXX",null,"3XXXXXXXXXX",null,"4XXXXXXXXXX",null,"5XXXXXXXXXX",null,"6XXXXXXXXXX",null,"7XXXXXXXXXX",null,"8XXXXXXXXXX",null,"9XXXXXXXXXX",null,"10XXXXXXXXX",null,"11XXXXXXXXX",null,"12XXXXXXXXX",null,"13XXXXXXXXX",null,"14XXXXXXXXX",null,"15XXXXXXXXX",null,"16XXXXXXXXX",null,"17XXXXXXXXX",null,"18XXXXXXXXX",null,"19XXXXXXXXX",null,"20XXXXXXXX",null,"21XXXXXXXXX",null,"22XXXXXXXXX",null,"23XXXXXXXXX",null,"24XXXXXXXXX",null,"25XXXXXXXXX",null,"26XXXXXXXXX",null,"27XXXXXXXXX",null,"28XXXXXXXXX",null,"29XXXXXXXXX",null,"30XXXXXXXXX",null,"31XXXXXXXXX",null,"32XXXXXXXXX",null,"33XXXXXXXXX",null,"34XXXXXXXXX",null,"35XXXXX"]
[null,"Sélectionner le palier correspondant à chaque enfant","Non SEH",null,"SEH",null,"SEHNSE-2",null,"SEHNSE-1",null,"Non SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"SEH",null,"Non SEH",null,"Non SEH",null,"Non SEH",null,"Non SEH",null,"Non SEH",null,"Non SEH",null,"Non SEH",null,"SEH",null,"SEHNSE-1",null,"SEHNSE-2"]
[]
["AEI","Nombre d'heures admissibles au SEH selon le palier sélectionné (SEH, SEHNSE-1, SEHNSE-2)",{"$f":"IF(C26=\"SEH\",3,IF(C26=\"SEHNSE-1\",8,IF(C26=\"SEHNSE-2\",6,IF(C26=\"Non SEH\",0))))","v":0},null,{"$f":"IF(E26=\"SEH\",3,IF(E26=\"SEHNSE-1\",8,IF(E26=\"SEHNSE-2\",6,IF(E26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(G26=\"SEH\",3,IF(G26=\"SEHNSE-1\",8,IF(G26=\"SEHNSE-2\",6,IF(G26=\"Non SEH\",0))))","v":6},null,{"$f":"IF(I26=\"SEH\",3,IF(I26=\"SEHNSE-1\",8,IF(I26=\"SEHNSE-2\",6,IF(I26=\"Non SEH\",0))))","v":8},null,{"$f":"IF(K26=\"SEH\",3,IF(K26=\"SEHNSE-1\",8,IF(K26=\"SEHNSE-2\",6,IF(K26=\"Non SEH\",0))))","v":0},null,{"$f":"IF(M26=\"SEH\",3,IF(M26=\"SEHNSE-1\",8,IF(M26=\"SEHNSE-2\",6,IF(M26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(O26=\"SEH\",3,IF(O26=\"SEHNSE-1\",8,IF(O26=\"SEHNSE-2\",6,IF(O26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(Q26=\"SEH\",3,IF(Q26=\"SEHNSE-1\",8,IF(Q26=\"SEHNSE-2\",6,IF(Q26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(S26=\"SEH\",3,IF(S26=\"SEHNSE-1\",8,IF(S26=\"SEHNSE-2\",6,IF(S26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(U26=\"SEH\",3,IF(U26=\"SEHNSE-1\",8,IF(U26=\"SEHNSE-2\",6,IF(U26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(W26=\"SEH\",3,IF(W26=\"SEHNSE-1\",8,IF(W26=\"SEHNSE-2\",6,IF(W26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(Y26=\"SEH\",3,IF(Y26=\"SEHNSE-1\",8,IF(Y26=\"SEHNSE-2\",6,IF(Y26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AA26=\"SEH\",3,IF(AA26=\"SEHNSE-1\",8,IF(AA26=\"SEHNSE-2\",6,IF(AA26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AC26=\"SEH\",3,IF(AC26=\"SEHNSE-1\",8,IF(AC26=\"SEHNSE-2\",6,IF(AC26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AE26=\"SEH\",3,IF(AE26=\"SEHNSE-1\",8,IF(AE26=\"SEHNSE-2\",6,IF(AE26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AG26=\"SEH\",3,IF(AG26=\"SEHNSE-1\",8,IF(AG26=\"SEHNSE-2\",6,IF(AG26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AI26=\"SEH\",3,IF(AI26=\"SEHNSE-1\",8,IF(AI26=\"SEHNSE-2\",6,IF(AI26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AK26=\"SEH\",3,IF(AK26=\"SEHNSE-1\",8,IF(AK26=\"SEHNSE-2\",6,IF(AK26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AM26=\"SEH\",3,IF(AM26=\"SEHNSE-1\",8,IF(AM26=\"SEHNSE-2\",6,IF(AM26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AO26=\"SEH\",3,IF(AO26=\"SEHNSE-1\",8,IF(AO26=\"SEHNSE-2\",6,IF(AO26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AQ26=\"SEH\",3,IF(AQ26=\"SEHNSE-1\",8,IF(AQ26=\"SEHNSE-2\",6,IF(AQ26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AS26=\"SEH\",3,IF(AS26=\"SEHNSE-1\",8,IF(AS26=\"SEHNSE-2\",6,IF(AS26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AU26=\"SEH\",3,IF(AU26=\"SEHNSE-1\",8,IF(AU26=\"SEHNSE-2\",6,IF(AU26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AW26=\"SEH\",3,IF(AW26=\"SEHNSE-1\",8,IF(AW26=\"SEHNSE-2\",6,IF(AW26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(AY26=\"SEH\",3,IF(AY26=\"SEHNSE-1\",8,IF(AY26=\"SEHNSE-2\",6,IF(AY26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(BA26=\"SEH\",3,IF(BA26=\"SEHNSE-1\",8,IF(BA26=\"SEHNSE-2\",6,IF(BA26=\"Non SEH\",0))))","v":0},null,{"$f":"IF(BC26=\"SEH\",3,IF(BC26=\"SEHNSE-1\",8,IF(BC26=\"SEHNSE-2\",6,IF(BC26=\"Non SEH\",0))))","v":0},null,{"$f":"IF(BE26=\"SEH\",3,IF(BE26=\"SEHNSE-1\",8,IF(BE26=\"SEHNSE-2\",6,IF(BE26=\"Non SEH\",0))))","v":0},null,{"$f":"IF(BG26=\"SEH\",3,IF(BG26=\"SEHNSE-1\",8,IF(BG26=\"SEHNSE-2\",6,IF(BG26=\"Non SEH\",0))))","v":0},null,{"$f":"IF(BI26=\"SEH\",3,IF(BI26=\"SEHNSE-1\",8,IF(BI26=\"SEHNSE-2\",6,IF(BI26=\"Non SEH\",0))))","v":0},null,{"$f":"IF(BK26=\"SEH\",3,IF(BK26=\"SEHNSE-1\",8,IF(BK26=\"SEHNSE-2\",6,IF(BK26=\"Non SEH\",0))))","v":0},null,{"$f":"IF(BM26=\"SEH\",3,IF(BM26=\"SEHNSE-1\",8,IF(BM26=\"SEHNSE-2\",6,IF(BM26=\"Non SEH\",0))))","v":0},null,{"$f":"IF(BO26=\"SEH\",3,IF(BO26=\"SEHNSE-1\",8,IF(BO26=\"SEHNSE-2\",6,IF(BO26=\"Non SEH\",0))))","v":3},null,{"$f":"IF(BQ26=\"SEH\",3,IF(BQ26=\"SEHNSE-1\",8,IF(BQ26=\"SEHNSE-2\",6,IF(BQ26=\"Non SEH\",0))))","v":8},null,{"$f":"IF(BS26=\"SEH\",3,IF(BS26=\"SEHNSE-1\",8,IF(BS26=\"SEHNSE-2\",6,IF(BS26=\"Non SEH\",0))))","v":6}]
[null,"Nombre de jours d'occupation \nSEH, SEHNSE-1 ou SEHNSE-2 \ndu 1er septembre 2026 au 31 mars 2027"]
[null,"Nombre total d'heures admissibles à l'AEI du 1er septembre 2026 au 31 mars 2027",{"$f":"ROUND(C28*C29,2)","v":0},null,{"$f":"ROUND(E28*E29,2)","v":0},null,{"$f":"ROUND(G28*G29,2)","v":0},null,{"$f":"ROUND(I28*I29,2)","v":0},null,{"$f":"ROUND(K28*K29,2)","v":0},null,{"$f":"ROUND(M28*M29,2)","v":0},null,{"$f":"ROUND(O28*O29,2)","v":0},null,{"$f":"ROUND(Q28*Q29,2)","v":0},null,{"$f":"ROUND(S28*S29,2)","v":0},null,{"$f":"ROUND(U28*U29,2)","v":0},null,{"$f":"ROUND(W28*W29,2)","v":0},null,{"$f":"ROUND(Y28*Y29,2)","v":0},null,{"$f":"ROUND(AA28*AA29,2)","v":0},null,{"$f":"ROUND(AC28*AC29,2)","v":0},null,{"$f":"ROUND(AE28*AE29,2)","v":0},null,{"$f":"ROUND(AG28*AG29,2)","v":0},null,{"$f":"ROUND(AI28*AI29,2)","v":0},null,{"$f":"ROUND(AK28*AK29,2)","v":0},null,{"$f":"ROUND(AM28*AM29,2)","v":0},null,{"$f":"ROUND(AO28*AO29,2)","v":0},null,{"$f":"ROUND(AQ28*AQ29,2)","v":0},null,{"$f":"ROUND(AS28*AS29,2)","v":0},null,{"$f":"ROUND(AU28*AU29,2)","v":0},null,{"$f":"ROUND(AW28*AW29,2)","v":0},null,{"$f":"ROUND(AY28*AY29,2)","v":0},null,{"$f":"ROUND(BA28*BA29,2)","v":0},null,{"$f":"ROUND(BC28*BC29,2)","v":0},null,{"$f":"ROUND(BE28*BE29,2)","v":0},null,{"$f":"ROUND(BG28*BG29,2)","v":0},null,{"$f":"ROUND(BI28*BI29,2)","v":0},null,{"$f":"ROUND(BK28*BK29,2)","v":0},null,{"$f":"ROUND(BM28*BM29,2)","v":0},null,{"$f":"ROUND(BO28*BO29,2)","v":0},null,{"$f":"ROUND(BQ28*BQ29,2)","v":0},null,{"$f":"ROUND(BS28*BS29,2)","v":0}]
[]
["MES","Nombre d'heures quotidiennes admissibles à la MES autorisées pour l'exercice financier 2026-2027"]
[null,"Nombre de jours d'occupation admissibles liés au droit acquis entre le 1er septembre 2026 et le 31 mars 2027"]
[null,"Nombre total d'heures liées au droit acquis du 1er septembre 2026 au 31 mars 2027",{"$f":"ROUND(C32*C33,2)","v":0},null,{"$f":"ROUND(E32*E33,2)","v":0},null,{"$f":"ROUND(G32*G33,2)","v":0},null,{"$f":"ROUND(I32*I33,2)","v":0},null,{"$f":"ROUND(K32*K33,2)","v":0},null,{"$f":"ROUND(M32*M33,2)","v":0},null,{"$f":"ROUND(O32*O33,2)","v":0},null,{"$f":"ROUND(Q32*Q33,2)","v":0},null,{"$f":"ROUND(S32*S33,2)","v":0},null,{"$f":"ROUND(U32*U33,2)","v":0},null,{"$f":"ROUND(W32*W33,2)","v":0},null,{"$f":"ROUND(Y32*Y33,2)","v":0},null,{"$f":"ROUND(AA32*AA33,2)","v":0},null,{"$f":"ROUND(AC32*AC33,2)","v":0},null,{"$f":"ROUND(AE32*AE33,2)","v":0},null,{"$f":"ROUND(AG32*AG33,2)","v":0},null,{"$f":"ROUND(AI32*AI33,2)","v":0},null,{"$f":"ROUND(AK32*AK33,2)","v":0},null,{"$f":"ROUND(AM32*AM33,2)","v":0},null,{"$f":"ROUND(AO32*AO33,2)","v":0},null,{"$f":"ROUND(AQ32*AQ33,2)","v":0},null,{"$f":"ROUND(AS32*AS33,2)","v":0},null,{"$f":"ROUND(AU32*AU33,2)","v":0},null,{"$f":"ROUND(AW32*AW33,2)","v":0},null,{"$f":"ROUND(AY32*AY33,2)","v":0},null,{"$f":"ROUND(BA32*BA33,2)","v":0},null,{"$f":"ROUND(BC32*BC33,2)","v":0},null,{"$f":"ROUND(BE32*BE33,2)","v":0},null,{"$f":"ROUND(BG32*BG33,2)","v":0},null,{"$f":"ROUND(BI32*BI33,2)","v":0},null,{"$f":"ROUND(BK32*BK33,2)","v":0},null,{"$f":"ROUND(BM32*BM33,2)","v":0},null,{"$f":"ROUND(BO32*BO33,2)","v":0},null,{"$f":"ROUND(BQ32*BQ33,2)","v":0},null,{"$f":"ROUND(BS32*BS33,2)","v":0}]
[]
[null,"Nombre total d'heures par enfant",{"$f":"MAX(C30,C34)","v":0},null,{"$f":"MAX(E30,E34)","v":0},null,{"$f":"MAX(G30,G34)","v":0},null,{"$f":"MAX(I30,I34)","v":0},null,{"$f":"MAX(K30,K34)","v":0},null,{"$f":"MAX(M30,M34)","v":0},null,{"$f":"MAX(O30,O34)","v":0},null,{"$f":"MAX(Q30,Q34)","v":0},null,{"$f":"MAX(S30,S34)","v":0},null,{"$f":"MAX(U30,U34)","v":0},null,{"$f":"MAX(W30,W34)","v":0},null,{"$f":"MAX(Y30,Y34)","v":0},null,{"$f":"MAX(AA30,AA34)","v":0},null,{"$f":"MAX(AC30,AC34)","v":0},null,{"$f":"MAX(AE30,AE34)","v":0},null,{"$f":"MAX(AG30,AG34)","v":0},null,{"$f":"MAX(AI30,AI34)","v":0},null,{"$f":"MAX(AK30,AK34)","v":0},null,{"$f":"MAX(AM30,AM34)","v":0},null,{"$f":"MAX(AO30,AO34)","v":0},null,{"$f":"MAX(AQ30,AQ34)","v":0},null,{"$f":"MAX(AS30,AS34)","v":0},null,{"$f":"MAX(AU30,AU34)","v":0},null,{"$f":"MAX(AW30,AW34)","v":0},null,{"$f":"MAX(AY30,AY34)","v":0},null,{"$f":"MAX(BA30,BA34)","v":0},null,{"$f":"MAX(BC30,BC34)","v":0},null,{"$f":"MAX(BE30,BE34)","v":0},null,{"$f":"MAX(BG30,BG34)","v":0},null,{"$f":"MAX(BI30,BI34)","v":0},null,{"$f":"MAX(BK30,BK34)","v":0},null,{"$f":"MAX(BM30,BM34)","v":0},null,{"$f":"MAX(BO30,BO34)","v":0},null,{"$f":"MAX(BQ30,BQ34)","v":0},null,{"$f":"MAX(BS30,BS34)","v":0}]
[]
[null,"Nombre total d'heures",{"$f":"SUM(C36:BS36)","v":0}]
[]
[null,"Taux horaire de l'accompagnatrice (note1) ",{"v":30.43,"d":"30.43 $"}]
[]
[null,"Estimation de l'allocation exceptionnelle pour l'intégration (AEI)",{"$f":"ROUND(C38*C40,2)","v":{"v":0,"d":"0.00 $"}}]
[]
[]
[null,"Note 1"]
[null,"La rémunération horaire globale comprend les contributions de l’employeur aux régimes obligatoires, les journées d’absence rémunérées et\nla formation du personnel."]

{"sheet":"Paramètres","index":1,"n_rows":42,"n_cols":3,"rows_kept":42,"hidden":true}
[null,"Palier SEH"]
[null,"Non SEH"]
[null,"SEH"]
[null,"SEHNSE-2"]
[null,"SEHNSE-1"]
[]
[null,"Sélection du nombre d'enfant","Olivier dit 35 le 30 juin 2026"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]

{"sheet":"Subvention fonctionnement-25-26","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"hidden":true}
["modèle","inférieur","supérieur","Budget "]
[1,0,140,{"v":95555,"d":"95,555 $"}]
[2,140,280,{"v":243977,"d":"243,977 $"}]
[3,280,420,{"v":344976,"d":"344,976 $"}]
[4,420,560,{"v":431178,"d":"431,178 $"}]
[5,560,700,{"v":524091,"d":"524,091 $"}]
[6,700,850,{"v":577585,"d":"577,585 $"}]
[7,850,1000,{"v":681394,"d":"681,394 $"}]
[8,1000,1150,{"v":769463,"d":"769,463 $"}]
[9,1150,1300,{"v":875537,"d":"875,537 $"}]
[10,1300,1500,{"v":954027,"d":"954,027 $"}]
[11,1500,1700,{"v":1067447,"d":"1,067,447 $"}]
[12,1700,1900,{"v":1191124,"d":"1,191,124 $"}]
[13,1900,9999999,{"v":1299198,"d":"1,299,198 $"}]