{"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":0,"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!P36","v":0.02},{"$f":"IF(E16=\"\",\"\",G16*$C$7*E16)","v":""}]
[null,"Prime Psy.",null,null,null,null,20.04,{"$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(#REF!>0,#REF!,\"4,3%\")),\"\")","v":""},{"$f":"IF(E18=\"\",\"\",E18*C7*G18)","v":""}]
[]
[null,"Primes de fin de semaine",null,null,null,null,{"$f":"Impôts!P31","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!P32","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!R32","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!N33,1,IF(Simul!C23=Impôts!N34,2,IF(Simul!C23=Impôts!N35,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$33:$P$35,2)))","v":""},{"$f":"IF(E23=\"\",\"\",((E23*$C$7)+IF($E$15>0,E23*5/$G$6,0))*G23)","v":""}]
[{"$f":"IF(Simul!C24=Impôts!N33,1,IF(Simul!C24=Impôts!N34,2,IF(Simul!C24=Impôts!N35,3,0)))","v":0},"Primes de nuit majorées",null,null,null,null,{"$f":"IF(E24=\"\",\"\",IF(AND(C24=\"\",E24<>0),\"        Case C ?\",VLOOKUP(A24,Impôts!$Q$33:$R$35,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!N7","v":5.8999999999999997E-2},null,{"$f":"Impôts!N12","v":134.61538461538461},{"$f":"IF(H37=0,0,($H$37+I58-G40)*E40)","v":0}," "]
[null,"Impôt Provincial",null,null,null,null,null,{"$f":"IF(C4=\"CENTRE\",'IMPÔT CENTRE'!E53,Impôts!E53)","v":{"$error":"#DIV/0!"}}]
[null,"Impôt fédéral",null,null,null,null,null,{"$f":"IF(C4=\"CENTRE\",'IMPÔT CENTRE'!E30,Impôts!E30)","v":{"$error":"#DIV/0!"}}]
[null,"RREGOP",null,null,{"$f":"Impôts!N20","v":0.1033},null,{"$f":"IF(C4=\"CENTRE\",Impôts!B56*Impôts!B57/26/(G6*2)*IF(C37>0,C37,E37),Impôts!B56*Impôts!B57/Impôts!D1/(G6*2)*IF(C37>0,C37,E37))","v":{"$error":"#DIV/0!"}},{"$f":"(H35-G43)*E43-IF(C4=\"CENTRE\",'IMPÔT CENTRE'!D58,Impôts!D58)","v":{"$error":"#DIV/0!"}}]
[null,"Assurance-emploi taux réduit",null,null,{"$f":"Impôts!N8","v":1.18E-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":"G5","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!N9","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,"Part Patronale:"]
[null,"Stationnement"]
[null,"Autres déductions"]
[null,"total des déductions",null,null,null,null,null,{"$f":"SUM(H40:H60)","v":{"$error":"#DIV/0!"}}]
[null,"Salaire Net :",null,null,null,null,null,{"$f":"H37-H61","v":{"$error":"#DIV/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":65,"n_cols":18,"rows_kept":65,"cut":false,"hidden":true,"merged":[[34,6,34,7],[35,6,35,7],[38,10,38,11],[39,10,39,11],[14,12,14,13],[28,13,28,15],[3,7,3,8],[5,6,5,7],[6,6,6,7],[26,6,26,7],[32,7,32,8]]}
[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":{"$error":"#DIV/0!"}},null,null,"Revenu ",null,"Taux","Constante",null,null,"Déductions",null,"Maximum"]
[null,"Syndicat",null,{"$f":"Simul!H45","v":""},null,null,"Imposable",null,"Fédéral",null,null,null,"RRQ",5.8999999999999997E-2,3427.9]
[null,"Reer",null,{"$f":"Simul!H48+Simul!H49+Simul!H50","v":0},null,null,0,49020,0.15,0,null,null,"AE",1.18E-2,664.54]
[3,"Net ligne 1-2",null,{"$f":"D5-SUM(D6:D8)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H8+0.01","v":49020.01},98040,0.20499999999999999,2696,null,null,"RQAP",4.9399999999999999E-3,412.49]
[4,"Revenu imposable annuel",null,{"$f":"D9*D1","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H9+0.01","v":98040.01},151978,0.26,8088,null,null,"Exemption féd.",13808,null,null,13229]
[5,"Déduction habitant zones ",null,0,null,null,{"$f":"H10+0.01","v":151978.01},216511,0.28999999999999998,12648,null,null,"Exemption prov.",15728,null,null,12298]
[6,"Revenu imposable année ligne 4 - L5",null,{"$f":"D10-D11","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H11+0.01","v":216511.01},null,0.33,21308,null,null,"Exemption RRQ",{"$f":"O12/26","v":134.61538461538461},3500]
[7,"Multiplie montant L6 par taux Tableau 1",null,{"$f":"E13*D12","v":{"$error":"#DIV/0!"}},{"$f":"IF(D12<=H8,I8,IF(AND(D12>=G9,D12<=H9),I9,IF(AND(D12>=G10,D12<=H10),I10,IF(AND(D12>=G11,D12<=H11),I11,IF(D12>=G12,I12,0)))))","v":{"$error":"#DIV/0!"}}]
[8,"Moins constante",null,{"$f":"E14","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(E13,I8:J12,2,FALSE)","v":{"$error":"#DIV/0!"}},null,"Crédit pour emploi",null,null,1257]
[9,"Imp Fédéral L7 - L8",null,{"$f":"D13-D14","v":{"$error":"#DIV/0!"}},null,null,"Abbattement fédéral",null,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",61600]
[null,"Crédit personnel de base",null,{"$f":"N10","v":13808},null,null,null,"Max",null,null,null,null,"Réduction",1.84E-2]
[null,"RRQ",null,{"$f":"IF(E18>H18,H18,E18)","v":0},{"$f":"F18*G18","v":0},{"$f":"IF(Simul!H40=\"\",0,IF(K18>0,K18,0))","v":0},{"$f":"D1","v":26},{"$f":"O7","v":3427.9},{"$f":"H18/D1","v":131.84230769230768},null,{"$f":"IF(J18=H18,0,IF(Simul!H40+J18>H18,H18-J18,Simul!H40))","v":0},null,"Taux  ====>","Cotisation","Exemption"]
[null,"AE",null,{"$f":"IF(E19>H19,H19,E19)","v":0},{"$f":"F19*G19","v":0},{"$f":"IF(Simul!H44=\"\",0,IF(K19>0,K19,0))","v":0},{"$f":"D1","v":26},{"$f":"O8","v":664.54},{"$f":"H19/D1","v":25.559230769230769},null,{"$f":"IF(J19=H19,0,IF(Simul!H44+J19>H19,H19-J19,Simul!H44))","v":0},null,"RRPE",0.1229,0.35]
[null,"RQAP",null,{"$f":"IF(E20>H20,H20,E20)","v":0},{"$f":"F20*G20","v":0},{"$f":"IF(Simul!H46=\"\",0,IF(K20>0,K20,0))","v":0},{"$f":"D1","v":26},{"$f":"O9","v":412.49},{"$f":"H20/D1","v":15.865},null,{"$f":"IF(J20=H20,0,IF(A34+J20>H20,H20-J20,A34))","v":0},null,"RREGOP",0.1033,0.25]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K18:K20)*D1","v":0},null,"RRAS",0.1229,0.35]
[null,"Cr Canadian pour emploi",null,{"$f":"IF(D5<0,-E22,E22)","v":1257},{"$f":"J14","v":1257},null,null,null,null,null,null,null,"RREGOP-CSST",0.1033,0.25]
[10,null,null,{"$f":"SUM(D17:D22)+IF(D5<0,K21,0)","v":15065},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":"D23*D24","v":2259.75}]
[13,"Impot fédéral L9  -  L12",null,{"$f":"D15-D25","v":{"$error":"#DIV/0!"}}]
[14,"Moins abbat féd 16,5% de L13",null,{"$f":"E27*D26","v":{"$error":"#DIV/0!"}},{"$f":"I15","v":0.16500000000000001},null,"Crédit REER"]
[null,"Crédits fond des travailleurs",null,{"$f":"D1*E28*(IF(K28<I28,K28,I28))","v":0},{"$f":"J50","v":0.15},null,{"$f":"D1","v":26},5000,{"$f":"H28/G28","v":192.30769230769232},null,{"$f":"Simul!H49+Simul!H50","v":0}]
[15,"Total impot a payer L13  -  L14",null,{"$f":"D26-D27-D28","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Statut","Primes"]
[16,"Diviser L15 par périodes de paie",null,{"$f":"D29/D1","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D5>=0,D30<=0),0,IF(AND(D5<=0,D30>=0),0,D30))","v":{"$error":"#DIV/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(D35>0,E37>J44),J44,IF(AND(D35<0,E37<-J44),-J44,E37))","v":0},{"$f":"D35*I44","v":0},null,0,45105,0.15,0]
[null,"Regop",null,{"$f":"IF(Simul!H43=\"\",0,IF(Simul!H43<>0,Simul!H43*D1))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H37+0.01","v":45105.01},90200,0.2,2255]
[null,"RRQ",null,null,null,null,{"$f":"H38+0.01","v":90200.01},109755,0.24,5863,null,null,null,"Ent4jrs",null,"B.M."]
[null,"AE + RQAP",null,null,null,null,{"$f":"H39+0.01","v":109755.01},null,0.25750000000000001,7783,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":"D35+D42-SUM(D36:D41)","v":{"$error":"#DIV/0!"}},null,null,null,null,"Taux","Maximum"]
[17,"Multiplier par 20%",null,null,null,null,"Crédit pour emploi",null,0.06,1205]
[18,"Total des crédits",null,{"$f":"D43*D44","v":{"$error":"#DIV/0!"}}]
[null,"Impot à payer an L14 - L17",null,{"$f":"E46*D43","v":{"$error":"#DIV/0!"}},{"$f":"IF(D43<=H37,I37,IF(AND(D43>=G38,D43<=H38),I38,IF(AND(D43>=G39,D43<=H39),I39,IF(D43>=G40,I40,I40))))","v":{"$error":"#DIV/0!"}}]
[null,"Constante d'impôt",null,{"$f":"E47","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(E46,I36:J41,2,FALSE)","v":{"$error":"#DIV/0!"}}]
[19,"Impôt personnel de base",null,{"$f":"N11","v":15728}]
[null,"Crédit perso  X 15% ",null,{"$f":"(D48*E49)","v":2359.1999999999998},0.15,null,"Max. déduc",null,"REER:","Fédéral","Provincial"]
[null,"Crédit FTQ",null,{"$f":"IF(F50>=G50,G50,F50)","v":0},{"$f":"K51","v":0.15},{"$f":"(Simul!H49*D1)*E50","v":0},750,null,"CSN / FTQ",0.15]
[null,"Crédit CSN",null,{"$f":"IF(F51>=G51,G51,F51)","v":0},{"$f":"K52","v":0.2},{"$f":"(Simul!H50*D1)*E51","v":0},1000,null,"FTQ",null,0.15]
[20,null,null,null,null,null,null,null,"CSN",null,0.2]
[null,"Retenu impot période paie",null,{"$f":"(D46-D47-D49-D50-D51)/D1","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D5>=0,D53<=0),0,IF(AND(D5<=0,D53>=0),0,D53))","v":{"$error":"#DIV/0!"}}]
[]
[]
["MGA",{"$f":"N16","v":61600}]
["Taux exemption",{"$f":"VLOOKUP(Simul!B43,Impôts!M19:O25,3)","v":0.25},"Ex. Annuelle",{"$f":"B56*B57","v":15400}]
["Réduction",{"$f":"N17","v":1.84E-2},{"$f":"B58*((B56/(Simul!G6*D1*2)*IF(Simul!C37>0,Simul!C37,Simul!E37)-Simul!H35))","v":{"$error":"#DIV/0!"}},{"$f":"IF(B57=0,0,IF(Simul!E37<0,IF(C58>0,0,C58),IF(C58<0,0,C58)))","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":78,"n_cols":18,"rows_kept":78,"cut":false,"hidden":true,"merged":[[28,13,28,15],[3,7,3,8],[5,6,5,7],[6,6,6,7],[14,12,14,13],[26,6,26,7],[32,7,32,8],[34,6,34,7],[35,6,35,7],[38,10,38,11],[39,10,39,11]]}
[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":{"$error":"#DIV/0!"}},null,null,"Revenu ",null,"Taux","Constante",null,null,"Déductions",null,"Maximum"]
[null,"Syndicat",null,{"$f":"Simul!H45","v":""},null,null,"Imposable",null,"Fédéral",null,null,null,"RRQ",5.8999999999999997E-2,3427.9]
[null,"Reer",null,{"$f":"Simul!H48+Simul!H49+Simul!H50","v":0},null,null,0,49020,0.15,0,null,null,"AE",1.18E-2,664.54]
[3,"Net ligne 1-2",null,{"$f":"D5-SUM(D6:D8)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H8+0.01","v":49020.01},98040,0.20499999999999999,2696,null,null,"RQAP",4.9399999999999999E-3,412.49]
[4,"Revenu imposable annuel",null,{"$f":"D9*D1","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H9+0.01","v":98040.01},151978,0.26,8088,null,null,"Exemption féd.",13808,null,null,13229]
[5,"Déduction habitant zones ",null,0,null,null,{"$f":"H10+0.01","v":151978.01},216511,0.28999999999999998,12648,null,null,"Exemption prov.",15728,null,null,12298]
[6,"Revenu imposable année ligne 4 - L5",null,{"$f":"D10-D11","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H11+0.01","v":216511.01},null,0.33,21308,null,null,"Exemption RRQ",{"$f":"O12/26","v":134.61538461538461},3500]
[7,"Multiplie montant L6 par taux Tableau 1",null,{"$f":"E13*D12","v":{"$error":"#DIV/0!"}},{"$f":"IF(D12<=H8,I8,IF(AND(D12>=G9,D12<=H9),I9,IF(AND(D12>=G10,D12<=H10),I10,IF(AND(D12>=G11,D12<=H11),I11,IF(D12>=G12,I12,0)))))","v":{"$error":"#DIV/0!"}}]
[8,"Moins constante",null,{"$f":"E14","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(E13,I8:J12,2,FALSE)","v":{"$error":"#DIV/0!"}},null,"Crédit pour emploi",null,null,1257]
[9,"Imp Fédéral L7 - L8",null,{"$f":"D13-D14","v":{"$error":"#DIV/0!"}},null,null,"Abbattement fédéral",null,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",61600]
[null,"Crédit personnel de base",null,{"$f":"N10","v":13808},null,null,null,"Max",null,null,null,null,"Réduction",1.84E-2]
[null,"RRQ",null,{"$f":"IF(E18>H18,H18,E18)","v":0},{"$f":"F18*G18","v":0},{"$f":"IF(Simul!H40=\"\",0,IF(K18>0,K18,0))","v":0},{"$f":"D1","v":26},{"$f":"O7","v":3427.9},{"$f":"H18/D1","v":131.84230769230768},null,{"$f":"IF(J18=H18,0,IF(Simul!H40+J18>H18,H18-J18,Simul!H40))","v":0},null,"Taux  ====>","Cotisation","Exemption"]
[null,"AE",null,{"$f":"IF(E19>H19,H19,E19)","v":0},{"$f":"F19*G19","v":0},{"$f":"IF(Simul!H44=\"\",0,IF(K19>0,K19,0))","v":0},{"$f":"D1","v":26},{"$f":"O8","v":664.54},{"$f":"H19/D1","v":25.559230769230769},null,{"$f":"IF(J19=H19,0,IF(Simul!H44+J19>H19,H19-J19,Simul!H44))","v":0},null,"RRPE",0.1229,0.35]
[null,"RQAP",null,{"$f":"IF(E20>H20,H20,E20)","v":0},{"$f":"F20*G20","v":0},{"$f":"IF(Simul!H46=\"\",0,IF(K20>0,K20,0))","v":0},{"$f":"D1","v":26},{"$f":"O9","v":412.49},{"$f":"H20/D1","v":15.865},null,{"$f":"IF(J20=H20,0,IF(A34+J20>H20,H20-J20,A34))","v":0},null,"RREGOP",0.1033,0.25]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K18:K20)*D1","v":0},null,"RRAS",0.1229,0.35]
[null,"Cr Canadian pour emploi",null,{"$f":"IF(D5<0,-E22,E22)","v":1257},{"$f":"J14","v":1257},null,null,null,null,null,null,null,"RREGOP-CSST",0.1033,0.25]
[10,null,null,{"$f":"SUM(D17:D22)+IF(D5<0,K21,0)","v":15065},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":"D23*D24","v":2259.75}]
[13,"Impot fédéral L9  -  L12",null,{"$f":"D15-D25","v":{"$error":"#DIV/0!"}}]
[14,"Moins abbat féd 16,5% de L13",null,{"$f":"E27*D26","v":{"$error":"#DIV/0!"}},{"$f":"I15","v":0.16500000000000001},null,"Crédit REER"]
[null,"Crédits fond des travailleurs",null,{"$f":"D1*E28*(IF(K28<I28,K28,I28))","v":0},{"$f":"J50","v":0.15},null,{"$f":"D1","v":26},5000,{"$f":"H28/G28","v":192.30769230769232},null,{"$f":"Simul!H49+Simul!H50","v":0}]
[15,"Total impot a payer L13  -  L14",null,{"$f":"D26-D27-D28","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Statut","Primes"]
[16,"Diviser L15 par périodes de paie",null,{"$f":"D29/D1","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D5>=0,D30<=0),0,IF(AND(D5<=0,D30>=0),0,D30))","v":{"$error":"#DIV/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(D35>0,E37>J44),J44,IF(AND(D35<0,E37<-J44),-J44,E37))","v":0},{"$f":"D35*I44","v":0},null,0,45105,0.15,0]
[null,"Regop",null,{"$f":"IF(Simul!H43=\"\",0,IF(Simul!H43<>0,Simul!H43*D1))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H37+0.01","v":45105.01},90200,0.2,2255]
[null,"RRQ",null,null,null,null,{"$f":"H38+0.01","v":90200.01},109755,0.24,5863,null,null,null,"Ent4jrs",null,"B.M."]
[null,"AE + RQAP",null,null,null,null,{"$f":"H39+0.01","v":109755.01},null,0.25750000000000001,7783,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":"D35+D42-SUM(D36:D41)","v":{"$error":"#DIV/0!"}},null,null,null,null,"Taux","Maximum"]
[17,"Multiplier par 20%",null,null,null,null,"Crédit pour emploi",null,0.06,1205]
[18,"Total des crédits",null,{"$f":"D43*D44","v":{"$error":"#DIV/0!"}}]
[null,"Impot à payer an L14 - L17",null,{"$f":"E46*D43","v":{"$error":"#DIV/0!"}},{"$f":"IF(D43<=H37,I37,IF(AND(D43>=G38,D43<=H38),I38,IF(AND(D43>=G39,D43<=H39),I39,IF(D43>=G40,I40,I40))))","v":{"$error":"#DIV/0!"}}]
[null,"Constante d'impôt",null,{"$f":"E47","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(E46,I36:J41,2,FALSE)","v":{"$error":"#DIV/0!"}}]
[19,"Impôt personnel de base",null,{"$f":"N11","v":15728}]
[null,"Crédit perso  X 15% ",null,{"$f":"(D48*E49)","v":2359.1999999999998},0.15,null,"Max. déduc",null,"REER:","Fédéral","Provincial"]
[null,"Crédit FTQ",null,{"$f":"IF(F50>=G50,G50,F50)","v":0},{"$f":"K51","v":0.15},{"$f":"(Simul!H49*D1)*E50","v":0},750,null,"CSN / FTQ",0.15]
[null,"Crédit CSN",null,{"$f":"IF(F51>=G51,G51,F51)","v":0},{"$f":"K52","v":0.2},{"$f":"(Simul!H50*D1)*E51","v":0},1000,null,"FTQ",null,0.15]
[20,null,null,null,null,null,null,null,"CSN",null,0.2]
[null,"Retenu impot période paie",null,{"$f":"(D46-D47-D49-D50-D51)/D1","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D5>=0,D53<=0),0,IF(AND(D5<=0,D53>=0),0,D53))","v":{"$error":"#DIV/0!"}}]
[]
[]
["MGA",{"$f":"N16","v":61600}]
["Taux exemption",{"$f":"VLOOKUP(Simul!B43,Impôts!M19:O25,3)","v":0.25},"Ex. Annuelle",{"$f":"B56*B57","v":15400}]
["Réduction",{"$f":"N17","v":1.84E-2},{"$f":"B58*((B56/(Simul!G6*D1*2)*IF(Simul!C37>0,Simul!C37,Simul!E37)-Simul!H35))","v":{"$error":"#DIV/0!"}},{"$f":"IF(B57=0,0,IF(Simul!E37<0,IF(C58>0,0,C58),IF(C58<0,0,C58)))","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":true,"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,193,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","FTQ","FTQ","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.6500000000000001E-2,1.6500000000000001E-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"]