{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Simul","Feuil1","Impôts","IMPÔT CENTRE","syndicat"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"comments":1,"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":"Simul","index":0,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,4,3,6],[4,4,4,5],[5,4,5,5],[7,4,7,5]]}
[]
[null,"SIMULATEUR DE PAIE"]
[]
[null,"CISSS:"]
[null,"Syndicat :",null,null,"Pourcentage syndicat:",null,{"$f":"IF($C$4=\"EST\",HLOOKUP(C$5,syndicat!B6:F7,2,FALSE),IF($C$4=\"CENTRE\",HLOOKUP($C$5,syndicat!G6:M7,2,FALSE),IF(C4=\"OUEST\",HLOOKUP(C5,syndicat!N6:Y7,2,FALSE),\"\")))","v":""}]
[null,"Heures /jour:",null,null,"Heures /sem.:",null,{"$f":"C6*5","v":0}]
[null,"Taux horaire:"]
[null,"Statut:",null,null,"Entente 4 jrs :"]
[]
[]
[]
[null,"Rémunération:"]
[null,"Heures payées par période de 2 semaine",null,null,null,null,null,{"$f":"C7*E13","v":0}]
[null,"Heures de congés sans solde cotisables"]
[null,"Prime d'ancienneté",null,null,null,null,5,{"$f":"IF(E15=\"\",\"\",G15/G6*E15)","v":""}]
[null,"Prime Non-Chev. Quart",null,null,null,null,{"$f":"Impôts!P37","v":0.02},{"$f":"IF(E16=\"\",\"\",G16*$C$7*E16)","v":""}]
[null,"Prime Psy.",null,null,null,null,21.27,{"$f":"IF(E17=\"\",\"\",G17/G6*E17)","v":""}]
[null,"Prime compensatoire (ent. 4/jrs)",null,null,null,null,{"$f":"IF(AND(C8=\"TC\",G8=\"Oui\"),(IF(C18>0,C18,\"4,30%\")),\"\")","v":""},{"$f":"IF(E18=\"\",\"\",E18*C7*G18)","v":""}]
[]
[null,"Primes de fin de semaine",null,null,null,null,{"$f":"Impôts!P32","v":0.04},{"$f":"IF(E20=\"\",\"\",((E20*$C$7)+IF($E$15>0,E20*5/$G$6,0))*G20)","v":""}]
[null,"Primes de soir",null,null,null,null,{"$f":"Impôts!P33","v":0.04},{"$f":"IF(E21=\"\",\"\",((E21*$C$7)+IF($E$15>0,E21*5/$G$6,0))*G21)","v":""}]
[null,"Primes de soir majorées",null,null,null,null,{"$f":"Impôts!R33","v":0.08},{"$f":"IF(E22=\"\",\"\",((E22*$C$7)+IF($E$15>0,E22*5/$G$6,0))*G22)","v":""}]
[{"$f":"IF(Simul!C23=Impôts!N34,1,IF(Simul!C23=Impôts!N35,2,IF(Simul!C23=Impôts!N36,3,0)))","v":0},"Primes de nuit",null,null,null,null,{"$f":"IF(E23=\"\",\"\",IF(AND(C23=\"\",E23<>0),\"        Case C ?\",VLOOKUP(A23,Impôts!$O$34:$P$36,2)))","v":""},{"$f":"IF(E23=\"\",\"\",((E23*$C$7)+IF($E$15>0,E23*5/$G$6,0))*G23)","v":""}]
[{"$f":"IF(Simul!C23=Impôts!N34,1,IF(Simul!C23=Impôts!N35,2,IF(Simul!C23=Impôts!N36,3,0)))","v":0},"Primes de nuit majorées",null,null,null,null,{"$f":"IF(E24=\"\",\"\",IF(AND(C23=\"\",E24<>0),\"        Case C ?\",VLOOKUP(A24,Impôts!$Q$34:$R$36,2)))","v":""},{"$f":"IF(E24=\"\",\"\",((E24*$C$7)+IF($E$15>0,E24*5/$G$6,0))*G24)","v":""}]
[]
[]
[null,"Autre prime à %",null,null,null,null,null,{"$f":"IF(E27=\"\",\"\",G27*$C$7*E27)","v":""}]
[null,"Autre prime à %",null,null,null,null,null,{"$f":"IF(E28=\"\",\"\",G28*$C$7*E28)","v":""}]
[null,"Autre prime à montant",null,null,null,null,null,{"$f":"G29","v":0}]
[]
[{"$f":"IF(AND($C$8=\"TC\",$E$13<>0,$E$14<>0),1,\"\")","v":""},"Bénéfices marginaux maladie ",null,null,null,null,{"$f":"IF(OR(C8=\"TC\",C8=\"\"),\"\",IF(C31=\"\",VLOOKUP(C5,BM,2,FALSE),C31))","v":""},{"$f":"IF(G31<>\"\",SUM(H13,H16,H17)*G31,\"\")","v":""}]
[{"$f":"IF(AND($C$8=\"TC\",$E$13<>0,$E$14<>0),1,\"\")","v":""},"Bénéfices marginaux férié 5.7%",null,null,{"$f":"IF(AND($C$8=\"TP\",E13<>0),E13,IF(A32=1,E13,\"\"))","v":""},null,{"$f":"IF(OR($C$8=\"TC\",$C$8=\"\"),\"\",VLOOKUP($C$5,BM,3,FALSE))","v":""},{"$f":"IF(G32<>\"\",SUM($H$13,H16,H17)*G32,\"\")","v":""},{"$f":"SUM(H31:H33)","v":0}]
[{"$f":"IF(AND($C$8=\"TC\",$E$13<>0,$E$14<>0),1,\"\")","v":""},"Bénéfices marginaux psy. 2.2%",null,null,{"$f":"IF(AND($C$8=\"TP\",E17<>0),E17,IF(AND(A33=1,E17<>0),E17,\"\"))","v":""},null,{"$f":"IF(OR($C$8=\"TC\",$C$8=\"\"),\"\",IF(E17>0,VLOOKUP($C$5,BM,4,FALSE),\"\"))","v":""},{"$f":"IF(G33<>\"\",SUM(H13,H16,H17)*G33,\"\")","v":""}]
[]
[null,"Brut cotisable",null,null,null,null,null,{"$f":"IF(E14>0,(E14*C7)+H13,H13)","v":0}]
[]
[null,"Salaire Brut",null,null,{"$f":"IF(AND(G8=\"Oui\",C8=\"TC\",(E13+E14)<G6*2),E13+E14,IF(AND(C8=\"TC\",(E13+E14)<>G6*2),\"Vérifier les heures en TC\",IF(AND(C8=\"TP\",G8=\"Oui\"),\"Vérifier le statut\",IF(AND(C8=\"\",E13+E14<>0),\"Vérifier le statut\",IF(OR(G8=\"Non\",G8=\"\"),E13+E14,\"Vérifier les heures\")))))","v":0},null,null,{"$f":"SUM(H13:H34)","v":0}]
[]
[null,"Déductions",null,null,"Taux",null,"exemp.par paie"]
[null,"RRQ",null,null,{"$f":"Impôts!N8","v":6.4000000000000001E-2},null,{"$f":"Impôts!N13","v":134.61500000000001},{"$f":"IF(H37=0,0,($H$37+I58-G40)*E40)","v":0}," "]
[null,"Impôt Provincial",null,null,null,null,null,{"$f":"IFERROR(IF(C4=\"CENTRE\",'IMPÔT CENTRE'!E54,Impôts!E54),0)","v":0}]
[null,"Impôt fédéral",null,null,null,null,null,{"$f":"IFERROR(IF(C4=\"CENTRE\",'IMPÔT CENTRE'!E31,Impôts!E31),0)","v":0}]
[null,"RREGOP",null,null,{"$f":"Impôts!N21","v":9.3899999999999997E-2},null,{"$f":"IFERROR(IF(C4=\"CENTRE\",Impôts!B57*Impôts!B58/26/(G6*2)*IF(C37>0,C37,E37),Impôts!B57*Impôts!B58/Impôts!D1/(G6*2)*IF(C37>0,C37,E37)),0)","v":0},{"$f":"IFERROR((H35-G43)*E43-IF(C4=\"CENTRE\",'IMPÔT CENTRE'!D59,Impôts!D59),0)","v":0}]
[null,"Assurance-emploi taux réduit",null,null,{"$f":"Impôts!N9","v":1.32E-2},null,null,{"$f":"H37*E44","v":0}]
[null,"Syndicat à pourcentage ",{"$f":"IF($C$4=\"EST\",HLOOKUP(C$5,syndicat!B6:F8,3,FALSE),IF($C$4=\"CENTRE\",HLOOKUP($C$5,syndicat!G6:M8,3,FALSE),IF(C4=\"OUEST\",HLOOKUP(C5,syndicat!N6:Y8,3,FALSE),\"\")))","v":""},null,{"$f":"IFERROR(G5,0)","v":""},null,null,{"$f":"IF(AND($C$45=\"non\",$I$32=0),H13*$E$45,IF(I32>0,(H13+I32)*E45,IF(C45=\"oui\",H37*E45,\"\")))","v":""}]
[null,"RQAP",null,null,{"$f":"Impôts!N10","v":4.9399999999999999E-3},null,null,{"$f":"H37*E46","v":0}]
[]
[null,"REER"]
[null,"REER FTQ"]
[null,"REER CSN"]
[]
[null,"Assurance collective: Base"]
[null,"Option 1"]
[null,"Option 2"]
[null,"Option 3"]
[null,"Option 4"]
[null,"TVQ",null,null,null,null,null,{"$f":"ROUND(SUM(H52:H56)*0.09,2)","v":0}]
[null,"Part Patronale:"]
[null,"Stationnement"]
[null,"Autres déductions"]
[null,"Total des déductions",null,null,null,null,null,{"$f":"SUM(H40:H60)","v":0}]
[null,"Salaire Net :",null,null,null,null,null,{"$f":"H37-H61","v":0}]
[null,null,"  "]
[" "]

{"sheet":"Feuil1","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[]
["MP","simul"]

{"sheet":"Impôts","index":2,"n_rows":66,"n_cols":18,"rows_kept":66,"cut":false,"hidden":false,"merged":[[3,7,3,8],[5,6,5,7],[7,6,7,7],[27,6,27,7],[33,7,33,8],[35,6,35,7],[36,6,36,7],[39,10,39,11],[40,10,40,11],[15,12,15,13],[29,13,29,15]]}
[null,null,"Périodes de paie :",26]
[]
[null,"Pour calculer Impôt fédéral"]
[null,null,null,null,null,null,null,"Tableau fédéral"]
[1,"Rémunération brute ",null,{"$f":"Simul!H37","v":0}]
[2,"Regop",null,{"$f":"Simul!H43","v":0},null,null,"Revenu ",null,"Taux","Constante",null,null,"Déductions",null,"Maximum"]
[null,"RRQ",null,{"$f":"D5*P8","v":0},null,null,null,null,null,null,null,null,null,null,null,"Cotisation RRQ divisée",null,"RRQ 2"]
[null,"Syndicat",null,{"$f":"Simul!H45","v":""},null,null,"Imposable",null,"Fédéral",null,null,null,"RRQ",{"$f":"[1]Taux!J9","v":6.4000000000000001E-2},{"$f":"[1]Taux!$K$9","v":4160},{"$f":"[1]Taux!$L$9","v":0.01},{"$f":"[1]Taux!$M$9","v":"5.4%"},{"$f":"[1]Taux!$G$14","v":0.04}]
[null,"Reer",null,{"$f":"Simul!H48+Simul!H49+Simul!H50","v":0},null,null,{"$f":"[1]Taux!N19","v":0},{"$f":"[1]Taux!O19","v":55867},{"$f":"[1]Taux!P19","v":0.15},{"$f":"[1]Taux!Q19","v":0},null,null,"AE",{"$f":"[1]Taux!J10","v":1.32E-2},{"$f":"[1]Taux!$K$10","v":834.24}]
[3,"Net ligne 1-2",null,{"$f":"D5-SUM(D6:D9)","v":0},null,null,{"$f":"[1]Taux!N20","v":55867.01},{"$f":"[1]Taux!O20","v":111733},{"$f":"[1]Taux!P20","v":0.20499999999999999},{"$f":"[1]Taux!Q20","v":3073},null,null,"RQAP",{"$f":"[1]Taux!J11","v":4.9399999999999999E-3},{"$f":"[1]Taux!$K$11","v":464.36}]
[4,"Revenu imposable annuel",null,{"$f":"D10*D1","v":0},null,null,{"$f":"[1]Taux!N21","v":111733.01},{"$f":"[1]Taux!O21","v":173205},{"$f":"[1]Taux!P21","v":0.26},{"$f":"[1]Taux!Q21","v":9218},null,null,"Exemption féd.",{"$f":"[1]Taux!$J$12","v":15705},null,null,{"$f":"[1]Taux!$L$12","v":13521},{"$f":"[1]Taux!$M$12","v":"salaire > 235675"}]
[5,"Déduction habitant zones ",null,0,null,null,{"$f":"[1]Taux!N22","v":173205.01},{"$f":"[1]Taux!O22","v":246752},{"$f":"[1]Taux!P22","v":0.28999999999999998},{"$f":"[1]Taux!Q22","v":14414},null,null,"Exemption prov.",{"$f":"[1]Taux!$J$13","v":18056}]
[6,"Revenu imposable année ligne 4 - L5",null,{"$f":"D11-D12","v":0},null,null,{"$f":"[1]Taux!N23","v":246752.01},null,{"$f":"[1]Taux!P23","v":0.33},{"$f":"[1]Taux!Q23","v":24284},null,null,"Exemption RRQ",{"$f":"[1]Taux!$J$14","v":134.61500000000001},{"$f":"[1]Taux!$E$12","v":3500}]
[7,"Multiplie montant L6 par taux Tableau 1",null,{"$f":"E14*D13","v":0},{"$f":"IF(D13<=H9,I9,IF(AND(D13>=G10,D13<=H10),I10,IF(AND(D13>=G11,D13<=H11),I11,IF(AND(D13>=G12,D13<=H12),I12,IF(D13>=G13,I13,0)))))","v":0.15}]
[8,"Moins constante",null,{"$f":"E15","v":0},{"$f":"VLOOKUP(E14,I9:J13,2,FALSE)","v":0},null,"Crédit pour emploi",null,null,{"$f":"[1]Taux!$Q$26","v":1368}]
[9,"Imp Fédéral L7 - L8",null,{"$f":"D14-D15","v":0},null,null,"Abbattement fédéral",null,{"$f":"[1]Taux!$P$27","v":0.16500000000000001},null,null,null,"Formule CARRA"]
[10,"Moins crédits fédérals",null,null,null,null,null,null,null,null,null,null,"MGA",{"$f":"[1]Taux!$E$11","v":68500}]
[null,"Crédit personnel de base",null,{"$f":"IF(E14=I13,Q11,N11)","v":15705},null,null,null,"Max",null,null,null,null,"Réduction",{"$f":"[1]Taux!$F$39","v":1.5599999999999999E-2}]
[null,"RRQ",null,{"$f":"IF(E19>H19,H19,E19)","v":0},{"$f":"F19*G19","v":0},{"$f":"IF(Simul!H40=\"\",0,IF(K19>0,K19,0))","v":0},{"$f":"D1","v":26},{"$f":"O8","v":4160},{"$f":"H19/D1","v":160},null,{"$f":"IF(J19=H19,0,IF(Simul!H40+J19>H19,H19-J19,Simul!H40))","v":0},null,"Taux  ====>","Cotisation","Exemption"]
[null,"AE",null,{"$f":"IF(E20>H20,H20,E20)","v":0},{"$f":"F20*G20","v":0},{"$f":"IF(Simul!H44=\"\",0,IF(K20>0,K20,0))","v":0},{"$f":"D1","v":26},{"$f":"O9","v":834.24},{"$f":"H20/D1","v":32.086153846153849},null,{"$f":"IF(J20=H20,0,IF(Simul!H44+J20>H20,H20-J20,Simul!H44))","v":0},null,"RRPE",{"$f":"[1]Taux!$F$48","v":0.12670000000000001},{"$f":"[1]Taux!$E$45","v":0.35}]
[null,"RQAP",null,{"$f":"IF(E21>H21,H21,E21)","v":0},{"$f":"F21*G21","v":0},{"$f":"IF(Simul!H46=\"\",0,IF(K21>0,K21,0))","v":0},{"$f":"D1","v":26},{"$f":"O10","v":464.36},{"$f":"H21/D1","v":17.86},null,{"$f":"IF(J21=H21,0,IF(A35+J21>H21,H21-J21,A35))","v":0},null,"RREGOP",{"$f":"[1]Taux!$F$38","v":9.3899999999999997E-2},{"$f":"[1]Taux!$E$35","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K19:K21)*D1","v":0},null,"RRAS",{"$f":"[1]Taux!$F$48","v":0.12670000000000001},{"$f":"[1]Taux!$E$45","v":0.35}]
[null,"Cr Canadian pour emploi",null,{"$f":"IF(D5<0,-E23,E23)","v":1368},{"$f":"J15","v":1368},null,null,null,null,null,null,null,"RREGOP-CSST",{"$f":"[1]Taux!$F$38","v":9.3899999999999997E-2},{"$f":"[1]Taux!$E$35","v":0.25}]
[10,null,null,{"$f":"SUM(D18:D23)+IF(D5<0,K22,0)","v":17073},null,null,null,null,null,null,null,null,"Aucun",0,0]
[11,"Multiplie L10 par taux impot le + bas",null,0.15]
[12,"Total cr fédéral",null,{"$f":"D24*D25","v":2560.9499999999998}]
[13,"Impot fédéral L9  -  L12",null,{"$f":"D16-D26","v":-2560.9499999999998}]
[14,"Moins abbat féd 16,5% de L13",null,{"$f":"E28*D27","v":-422.55674999999997},{"$f":"I16","v":0.16500000000000001},null,"Crédit REER"]
[null,"Crédits fond des travailleurs",null,{"$f":"D1*E29*(IF(K29<I29,K29,I29))","v":0},{"$f":"J51","v":0.15},null,{"$f":"D1","v":26},5000,{"$f":"H29/G29","v":192.30769230769232},null,{"$f":"Simul!H49+Simul!H50","v":0}]
[15,"Total impot a payer L13  -  L14",null,{"$f":"D27-D28-D29","v":-2138.3932500000001},null,null,null,null,null,null,null,null,"Statut","Primes"]
[16,"Diviser L15 par périodes de paie",null,{"$f":"D30/D1","v":-82.245894230769238},{"$f":"IF(AND(D5>=0,D31<=0),0,IF(AND(D5<=0,D31>=0),0,D31))","v":0},null,null,null,null,null,null,null,"TC",null,null,"régulières",null,"majorées"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TP","fds",null,0.04]
[null,"Calcul de Impôt provincial",null,null,null,null,null,null,null,null,null,null,null,"soir",null,0.04,null,0.08]
[null,null,null,null,null,null,null,"Tableau provincial",null,null,null,null,null,"0 - 5 ans",1,0.11,1,0.14000000000000001]
[{"$f":"Simul!H37*Simul!E46","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"5 - 10 ans",2,0.12,2,0.15]
[14,"Rémunération annuelle de base",null,{"$f":"D5*D1","v":0},null,null,"Revenu ",null,"Taux","Constante",null,null,null,"10 ans et +",3,0.14000000000000001,3,0.16]
[15,"Crédit Impot provincial",null,null,null,null,"Imposable",null,"Provincial",null,null,null,null,"Non chev.quart",null,0.02]
[null,"Déduction pour emploi",null,{"$f":"IF(AND(D36>0,E38>J45),J45,IF(AND(D36<0,E38<-J45),-J45,E38))","v":0},{"$f":"D36*I45","v":0},null,{"$f":"[1]Taux!I19","v":0},{"$f":"[1]Taux!J19","v":51780},{"$f":"[1]Taux!K19","v":0.14000000000000001},{"$f":"[1]Taux!L19","v":0}]
[null,"Regop",null,{"$f":"IF(Simul!H43=\"\",0,IF(Simul!H43<>0,Simul!H43*D1))","v":false},null,null,{"$f":"[1]Taux!I20","v":51780.01},{"$f":"[1]Taux!J20","v":103545},{"$f":"[1]Taux!K20","v":0.19},{"$f":"[1]Taux!L20","v":2463}]
[null,"RRQ",null,null,null,null,{"$f":"[1]Taux!I21","v":103545.01},{"$f":"[1]Taux!J21","v":126000},{"$f":"[1]Taux!K21","v":0.24},{"$f":"[1]Taux!L21","v":7390},null,null,null,"Ent4jrs",null,"B.M."]
[null,"AE + RQAP",null,null,null,null,{"$f":"[1]Taux!I22","v":126000.01},null,{"$f":"[1]Taux!K22","v":0.25750000000000001},{"$f":"[1]Taux!L22","v":9489},null,null,null,"Oui",null,{"$f":"IF(Simul!C5=Impôts!#REF!,6%,6.21%)","v":{"$error":"#REF!"}}]
[null,"REER",null,{"$f":"(Simul!H48+Simul!H49+Simul!H50)*D1","v":0},null,null,null,null,null,null,null,null,null,"Non"]
[15,"Ass. Coll. Part patronale",null,{"$f":"(Simul!I58*D1)","v":0}]
[16,"Total",null,{"$f":"D36+D43-SUM(D37:D42)","v":0},null,null,null,null,"Taux","Maximum"]
[17,"Multiplier par 19%",null,null,null,null,"Crédit pour emploi",null,{"$f":"[1]Taux!$K$27","v":6.4399999999999999E-2},{"$f":"[1]Taux!$L$27","v":1380}]
[18,"Total des crédits",null,{"$f":"D44*D45","v":0}]
[null,"Impot à payer an L14 - L17",null,{"$f":"E47*D44","v":0},{"$f":"IF(D44<=H38,I38,IF(AND(D44>=G39,D44<=H39),I39,IF(AND(D44>=G40,D44<=H40),I40,IF(D44>=G41,I41,I41))))","v":0.14000000000000001}]
[null,"Constante d'impôt",null,{"$f":"E48","v":0},{"$f":"VLOOKUP(E47,I37:J42,2,FALSE)","v":0}]
[19,"Impôt personnel de base",null,{"$f":"N12","v":18056}]
[null,"Crédit perso  X 14% ",null,{"$f":"(D49*E50)","v":2527.84},0.14000000000000001,null,"Max. déduc",null,"REER:","Fédéral","Provincial"]
[null,"Crédit FTQ",null,{"$f":"IF(F51>=G51,G51,F51)","v":0},{"$f":"K52","v":0.15},{"$f":"(Simul!H49*D1)*E51","v":0},750,null,"CSN / FTQ",{"$f":"[1]Taux!$E$7","v":0.15}]
[null,"Crédit CSN",null,{"$f":"IF(F52>=G52,G52,F52)","v":0},{"$f":"K53","v":0.15},{"$f":"(Simul!H50*D1)*E52","v":0},1000,null,"FTQ",null,{"$f":"[1]Taux!$E$8","v":0.15}]
[20,null,null,null,null,null,null,null,"CSN",null,{"$f":"[1]Taux!$F$7","v":0.15}]
[null,"Retenu impot période paie",null,{"$f":"(D47-D48-D50-D51-D52)/D1","v":-97.22461538461539},{"$f":"IF(AND(D5>=0,D54<=0),0,IF(AND(D5<=0,D54>=0),0,D54))","v":0}]
[]
[]
["MGA",{"$f":"N17","v":68500}]
["Taux exemption",{"$f":"VLOOKUP(Simul!B43,Impôts!M20:O26,3)","v":0.25},"Ex. Annuelle",{"$f":"B57*B58","v":17125}]
["Réduction",{"$f":"N18","v":1.5599999999999999E-2},{"$f":"B59*((B57/(Simul!G6*D1*2)*IF(Simul!C37>0,Simul!C37,Simul!E37)-Simul!H35))","v":{"$error":"#DIV/0!"}},{"$f":"IF(B58=0,0,IF(Simul!E37<0,IF(C59>0,0,C59),IF(C59<0,0,C59)))","v":{"$error":"#DIV/0!"}}]
[]
[]
["Non Synd.",0,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"IMPÔT CENTRE","index":3,"n_rows":79,"n_cols":18,"rows_kept":79,"cut":false,"hidden":false,"merged":[[33,7,33,8],[35,6,35,7],[36,6,36,7],[39,10,39,11],[40,10,40,11],[29,13,29,15],[3,7,3,8],[5,6,5,7],[7,6,7,7],[15,12,15,13],[27,6,27,7]]}
[null,null,"Périodes de paie :",26]
[]
[null,"Pour calculer Impôt fédéral"]
[null,null,null,null,null,null,null,"Tableau fédéral"]
[1,"Rémunération brute ",null,{"$f":"Simul!H37","v":0}]
[2,"Regop",null,{"$f":"Simul!H43","v":0},null,null,"Revenu ",null,"Taux","Constante",null,null,"Déductions",null,"Maximum"]
[null,"RRQ",null,{"$f":"D5*Impôts!P8","v":0}]
[null,"Syndicat",null,{"$f":"Simul!H45","v":""},null,null,"Imposable",null,"Fédéral",null,null,null,"RRQ",{"$f":"[1]Taux!J9","v":6.4000000000000001E-2},{"$f":"[1]Taux!$K$9","v":4160}]
[null,"Reer",null,{"$f":"Simul!H48+Simul!H49+Simul!H50","v":0},null,null,{"$f":"[1]Taux!N19","v":0},{"$f":"[1]Taux!O19","v":55867},{"$f":"[1]Taux!P19","v":0.15},{"$f":"[1]Taux!Q19","v":0},null,null,"AE",{"$f":"[1]Taux!J10","v":1.32E-2},{"$f":"[1]Taux!$K$10","v":834.24}]
[3,"Net ligne 1-2",null,{"$f":"D5-SUM(D6:D9)","v":0},null,null,{"$f":"[1]Taux!N20","v":55867.01},{"$f":"[1]Taux!O20","v":111733},{"$f":"[1]Taux!P20","v":0.20499999999999999},{"$f":"[1]Taux!Q20","v":3073},null,null,"RQAP",{"$f":"[1]Taux!J11","v":4.9399999999999999E-3},{"$f":"[1]Taux!$K$11","v":464.36}]
[4,"Revenu imposable annuel",null,{"$f":"D10*D1","v":0},null,null,{"$f":"[1]Taux!N21","v":111733.01},{"$f":"[1]Taux!O21","v":173205},{"$f":"[1]Taux!P21","v":0.26},{"$f":"[1]Taux!Q21","v":9218},null,null,"Exemption féd.",{"$f":"[1]Taux!$J$12","v":15705},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[5,"Déduction habitant zones ",null,0,null,null,{"$f":"[1]Taux!N22","v":173205.01},{"$f":"[1]Taux!O22","v":246752},{"$f":"[1]Taux!P22","v":0.28999999999999998},{"$f":"[1]Taux!Q22","v":14414},null,null,"Exemption prov.",{"$f":"[1]Taux!$J$13","v":18056}]
[6,"Revenu imposable année ligne 4 - L5",null,{"$f":"D11-D12","v":0},null,null,{"$f":"[1]Taux!N23","v":246752.01},null,{"$f":"[1]Taux!P23","v":0.33},{"$f":"[1]Taux!Q23","v":24284},null,null,"Exemption RRQ",{"$f":"[1]Taux!$J$14","v":134.61500000000001},{"$f":"[1]Taux!$E$12","v":3500}]
[7,"Multiplie montant L6 par taux Tableau 1",null,{"$f":"E14*D13","v":0},{"$f":"IF(D13<=H9,I9,IF(AND(D13>=G10,D13<=H10),I10,IF(AND(D13>=G11,D13<=H11),I11,IF(AND(D13>=G12,D13<=H12),I12,IF(D13>=G13,I13,0)))))","v":0.15}]
[8,"Moins constante",null,{"$f":"E15","v":0},{"$f":"VLOOKUP(E14,I9:J13,2,FALSE)","v":0},null,"Crédit pour emploi",null,null,{"$f":"[1]Taux!$Q$26","v":1368}]
[9,"Imp Fédéral L7 - L8",null,{"$f":"D14-D15","v":0},null,null,"Abbattement fédéral",null,{"$f":"[1]Taux!$P$27","v":0.16500000000000001},null,null,null,"Formule CARRA"]
[10,"Moins crédits fédérals",null,null,null,null,null,null,null,null,null,null,"MGA",{"$f":"[1]Taux!$E$11","v":68500}]
[null,"Crédit personnel de base",null,{"$f":"IF(E14=I13,Q11,N11)","v":15705},null,null,null,"Max",null,null,null,null,"Réduction",{"$f":"[1]Taux!$F$39","v":1.5599999999999999E-2}]
[null,"RRQ",null,{"$f":"IF(E19>H19,H19,E19)","v":0},{"$f":"F19*G19","v":0},{"$f":"IF(Simul!H40=\"\",0,IF(K19>0,K19,0))","v":0},{"$f":"D1","v":26},{"$f":"O8","v":4160},{"$f":"H19/D1","v":160},null,{"$f":"IF(J19=H19,0,IF(Simul!H40+J19>H19,H19-J19,Simul!H40))","v":0},null,"Taux  ====>","Cotisation","Exemption"]
[null,"AE",null,{"$f":"IF(E20>H20,H20,E20)","v":0},{"$f":"F20*G20","v":0},{"$f":"IF(Simul!H44=\"\",0,IF(K20>0,K20,0))","v":0},{"$f":"D1","v":26},{"$f":"O9","v":834.24},{"$f":"H20/D1","v":32.086153846153849},null,{"$f":"IF(J20=H20,0,IF(Simul!H44+J20>H20,H20-J20,Simul!H44))","v":0},null,"RRPE",{"$f":"[1]Taux!$F$48","v":0.12670000000000001},{"$f":"[1]Taux!$E$45","v":0.35}]
[null,"RQAP",null,{"$f":"IF(E21>H21,H21,E21)","v":0},{"$f":"F21*G21","v":0},{"$f":"IF(Simul!H46=\"\",0,IF(K21>0,K21,0))","v":0},{"$f":"D1","v":26},{"$f":"O10","v":464.36},{"$f":"H21/D1","v":17.86},null,{"$f":"IF(J21=H21,0,IF(A35+J21>H21,H21-J21,A35))","v":0},null,"RREGOP",{"$f":"[1]Taux!$F$38","v":9.3899999999999997E-2},{"$f":"[1]Taux!$E$35","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K19:K21)*D1","v":0},null,"RRAS",{"$f":"[1]Taux!$F$48","v":0.12670000000000001},{"$f":"[1]Taux!$E$45","v":0.35}]
[null,"Cr Canadian pour emploi",null,{"$f":"IF(D5<0,-E23,E23)","v":1368},{"$f":"J15","v":1368},null,null,null,null,null,null,null,"RREGOP-CSST",{"$f":"[1]Taux!$F$38","v":9.3899999999999997E-2},{"$f":"[1]Taux!$E$35","v":0.25}]
[10,null,null,{"$f":"SUM(D18:D23)+IF(D5<0,K22,0)","v":17073},null,null,null,null,null,null,null,null,"Aucun",0,0]
[11,"Multiplie L10 par taux impot le + bas",null,0.15]
[12,"Total cr fédéral",null,{"$f":"D24*D25","v":2560.9499999999998}]
[13,"Impot fédéral L9  -  L12",null,{"$f":"D16-D26","v":-2560.9499999999998}]
[14,"Moins abbat féd 16,5% de L13",null,{"$f":"E28*D27","v":-422.55674999999997},{"$f":"I16","v":0.16500000000000001},null,"Crédit REER"]
[null,"Crédits fond des travailleurs",null,{"$f":"D1*E29*(IF(K29<I29,K29,I29))","v":0},{"$f":"J51","v":0.15},null,{"$f":"D1","v":26},5000,{"$f":"H29/G29","v":192.30769230769232},null,{"$f":"Simul!H49+Simul!H50","v":0}]
[15,"Total impot a payer L13  -  L14",null,{"$f":"D27-D28-D29","v":-2138.3932500000001},null,null,null,null,null,null,null,null,"Statut","Primes"]
[16,"Diviser L15 par périodes de paie",null,{"$f":"D30/D1","v":-82.245894230769238},{"$f":"IF(AND(D5>=0,D31<=0),0,IF(AND(D5<=0,D31>=0),0,D31))","v":0},null,null,null,null,null,null,null,"TC",null,null,"régulières",null,"majorées"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TP","fds",null,0.04]
[null,"Calcul de Impôt provincial",null,null,null,null,null,null,null,null,null,null,null,"soir",null,0.04,null,0.08]
[null,null,null,null,null,null,null,"Tableau provincial",null,null,null,null,null,"0 - 5 ans",1,0.11,1,0.14000000000000001]
[{"$f":"Simul!H37*Simul!E46","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"5 - 10 ans",2,0.12,2,0.15]
[14,"Rémunération annuelle de base",null,{"$f":"(Simul!H37+Simul!I58)*D1","v":0},null,null,"Revenu ",null,"Taux","Constante",null,null,null,"10 ans et +",3,0.14000000000000001,3,0.16]
[15,"Crédit Impot provincial",null,null,null,null,"Imposable",null,"Provincial",null,null,null,null,"Non chev.quart",null,0.02]
[null,"Déduction pour emploi",null,{"$f":"IF(AND(D36>0,E38>J45),J45,IF(AND(D36<0,E38<-J45),-J45,E38))","v":0},{"$f":"D36*I45","v":0},null,{"$f":"[1]Taux!I19","v":0},{"$f":"[1]Taux!J19","v":51780},{"$f":"[1]Taux!K19","v":0.14000000000000001},{"$f":"[1]Taux!L19","v":0}]
[null,"Regop",null,{"$f":"IF(Simul!H43=\"\",0,IF(Simul!H43<>0,Simul!H43*D1))","v":false},null,null,{"$f":"[1]Taux!I20","v":51780.01},{"$f":"[1]Taux!J20","v":103545},{"$f":"[1]Taux!K20","v":0.19},{"$f":"[1]Taux!L20","v":2463}]
[null,"RRQ",null,null,null,null,{"$f":"[1]Taux!I21","v":103545.01},{"$f":"[1]Taux!J21","v":126000},{"$f":"[1]Taux!K21","v":0.24},{"$f":"[1]Taux!L21","v":7390},null,null,null,"Ent4jrs",null,"B.M."]
[null,"AE + RQAP",null,null,null,null,{"$f":"[1]Taux!I22","v":126000.01},null,{"$f":"[1]Taux!K22","v":0.25750000000000001},{"$f":"[1]Taux!L22","v":9489},null,null,null,"Oui",null,{"$f":"IF(Simul!C5=Impôts!#REF!,6%,6.21%)","v":{"$error":"#REF!"}}]
[null,"REER",null,{"$f":"(Simul!H48+Simul!H49+Simul!H50)*D1","v":0},null,null,null,null,null,null,null,null,null,"Non"]
[15,"Ass. Coll. Part patronale",null,{"$f":"(Simul!I58*D1)","v":0}]
[16,"Total",null,{"$f":"D36+D43-SUM(D37:D42)","v":0},null,null,null,null,"Taux","Maximum"]
[17,"Multiplier par 20%",null,null,null,null,"Crédit pour emploi",null,{"$f":"[1]Taux!$K$27","v":6.4399999999999999E-2},{"$f":"[1]Taux!$L$27","v":1380}]
[18,"Total des crédits",null,{"$f":"D44*D45","v":0}]
[null,"Impot à payer an L14 - L17",null,{"$f":"E47*D44","v":0},{"$f":"IF(D44<=H38,I38,IF(AND(D44>=G39,D44<=H39),I39,IF(AND(D44>=G40,D44<=H40),I40,IF(D44>=G41,I41,I41))))","v":0.14000000000000001}]
[null,"Constante d'impôt",null,{"$f":"E48","v":0},{"$f":"VLOOKUP(E47,I37:J42,2,FALSE)","v":0}]
[19,"Impôt personnel de base",null,{"$f":"N12","v":18056}]
[null,"Crédit perso  X 14% ",null,{"$f":"(D49*E50)","v":2527.84},0.14000000000000001,null,"Max. déduc",null,"REER:","Fédéral","Provincial"]
[null,"Crédit FTQ",null,{"$f":"IF(F51>=G51,G51,F51)","v":0},{"$f":"K52","v":0.15},{"$f":"(Simul!H49*D1)*E51","v":0},750,null,"CSN / FTQ",{"$f":"[1]Taux!$E$7","v":0.15}]
[null,"Crédit CSN",null,{"$f":"IF(F52>=G52,G52,F52)","v":0},{"$f":"K53","v":0.15},{"$f":"(Simul!H50*D1)*E52","v":0},1000,null,"FTQ",null,{"$f":"[1]Taux!$E$8","v":0.15}]
[20,null,null,null,null,null,null,null,"CSN",null,{"$f":"[1]Taux!$F$7","v":0.15}]
[null,"Retenu impot période paie",null,{"$f":"(D47-D48-D50-D51-D52)/D1","v":-97.22461538461539},{"$f":"IF(AND(D5>=0,D54<=0),0,IF(AND(D5<=0,D54>=0),0,D54))","v":0}]
[]
[]
["MGA",{"$f":"N17","v":68500}]
["Taux exemption",{"$f":"VLOOKUP(Simul!B43,Impôts!M20:O26,3)","v":0.25},"Ex. Annuelle",{"$f":"B57*B58","v":17125}]
["Réduction",{"$f":"N18","v":1.5599999999999999E-2},{"$f":"B59*((B57/(Simul!G6*D1*2)*IF(Simul!C37>0,Simul!C37,Simul!E37)-Simul!H35))","v":{"$error":"#DIV/0!"}},{"$f":"IF(B58=0,0,IF(Simul!E37<0,IF(C59>0,0,C59),IF(C59<0,0,C59)))","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"syndicat","index":4,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,13,2,24],[2,6,2,12],[2,1,2,5]]}
[]
[]
[null,"EST",null,null,null,null,"CENTRE",null,null,null,null,null,null,"OUEST"]
["MONTÉRÉGIE EST","CAT. 1","CAT. 2","CAT. 3","CAT.  4",null,"CAT. 1","CAT. 2","CAT. 3","CAT.  4","CAT. 3 MTL ","CAT. 4 MTL ",null,"CAT. 1","CAT. 2","CAT. 3","CAT.  4","CAT. 1(Estrie)","CAT. 2(Estrie)","CAT. 3(Estrie)","CAT.  4(Estrie)","CAT. 1(Mtl)","CAT. 3(Mtl)","CAT. 4(Mtl)"]
["CODE SYNDICAT",191,192,193,194,null,221,222,823,229,null,238,null,191,192,193,194,"156 et 161",162,162,164,198,78,498]
["SYNDICAT","FIQ","CSN","CSN","APTS","SNS","FIQ","CSN","CSN","APTS","CSD","SCFP","SNS","FIQ","SCFP","SCFP","APTS","FIQ","CSN","CSN","CSN","CSQ","CSQ","CSQ","SNS"]
["TAUX",1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.6E-2,0,1.6500000000000001E-2,1.7500000000000002E-2,1.7500000000000002E-2,1.6E-2,1.2999999999999999E-2,1.2500000000000001E-2,0,1.8499999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.6E-2,1.8499999999999999E-2,1.8499999999999999E-2,1.8499999999999999E-2,1.8499999999999999E-2,1.4999999999999999E-2,"-",1.6E-2,0]
["se calcule sur primes","oui","non","non","non","non","oui","non","non","non","oui","oui","non","oui","oui","oui","non","oui","non","non","non","oui","oui","oui","non"]
[]
[]
[]
[]
["BM"]
["syndicat","maladie","férié","psy",null,null,"Taux plein"]
[]
["FIQ",0.04,5.2999999999999999E-2,0.02,null,"FIQ",0.06]
["CSN",4.2099999999999999E-2,5.7000000000000002E-2,2.1999999999999999E-2,null,"CSN",6.2100000000000002E-2]
["APTS",4.2099999999999999E-2,5.7000000000000002E-2,2.1999999999999999E-2,null,"APTS",6.2100000000000002E-2]
["APES",4.2099999999999999E-2,5.7000000000000002E-2,2.1999999999999999E-2,null,"APES",6.2100000000000002E-2]
["SCFP",4.2099999999999999E-2,5.7000000000000002E-2,2.1999999999999999E-2,null,"SCFP",6.2100000000000002E-2]
["SNS",4.2099999999999999E-2,5.7000000000000002E-2,2.1999999999999999E-2,null,"SNS",6.2100000000000002E-2]
["CADRE",0,5.7000000000000002E-2,2.1999999999999999E-2,null,"CADRE",0]
["CSD",4.2099999999999999E-2,5.7000000000000002E-2,2.1999999999999999E-2,null,"CSD",6.2100000000000002E-2]
["CSQ",4.2099999999999999E-2,5.7000000000000002E-2,2.1999999999999999E-2,null,"CSQ",6.2100000000000002E-2]
[]
[]
[]
[null,"CISSS"]
[null,"EST"]
[null,"CENTRE"]
[null,"OUEST"]
[]
[]
[null,"STATUT"]
[null,"TC"]
[null,"TP"]
[null,"TC en PARTIEL SANS SOLDE"]