{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Coti","Fiches 1 et 2","Fiches 3 et 4","Vide à imprimer"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Coti","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"merged":[[0,1,0,8],[3,4,3,5],[3,6,3,7],[9,6,9,8],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[16,2,16,4],[17,3,17,4],[17,6,17,8],[18,3,18,4],[18,6,18,8]]}
[null,"Décompte de salaire"]
[null,null,"Cellules bleues à compléter"]
[]
[null,null,"Charges sociales",null,"Employeur",null,"Employé"]
[null,null,"  ./. Caisse de pens.",null,12,"%",10,"%"]
[null,null,"  ./. Ass acc non prof",null,0.4,"%",1.46,"%"]
[null,null,"  ./. AVS/AI/APG/AC",null,6.35,"%",6.05,"%"]
[]
[null,null,"Allocation par enfant",null,{"v":150,"d":"150.00"}]
[]
[{"$nulls":3},"annuel","mensuel",null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,null,"Seuil d'entrée",{"v":19350,"d":"19,350.-"},{"$f":"D12/12","v":{"v":1612.5,"d":"1,612.50"}},null,{"$f":"E12","v":{"v":1612.5,"d":"1,612.50"}},null,{"$f":"E13-E12","v":268.75}]
[null,null,"Salaire assuré  minimum",{"v":22575,"d":"22,575.-"},{"$f":"D13/12","v":{"v":1881.25,"d":"1,881.25"}},null,{"$f":"E13+(E13-E12)","v":{"v":2150,"d":"2,150.00"}},null,{"$f":"G19","v":{"v":3118.75,"d":"3,118.75"}}]
[null,null,"Salaire assuré maximum",{"v":77400,"d":"77,400.-"},{"$f":"D14/12","v":{"v":6450,"d":"6,450.00"}},null,{"$f":"E14","v":{"v":6450,"d":"6,450.00"}},null,{"$f":"(D14-D13)/12","v":{"v":4568.75,"d":"4,568.75"}}]
[{"$nulls":6},{"v":20000,"d":"20,000.00"}]
[]
[null,null,"Simulateur"]
[null,null,"Salaire brut","Salaire cotisant LPP",null,null,"Salaire coordonné"]
[null,null,{"v":5000,"d":"5,000.00"},{"$f":"LOOKUP(C19,G11:I15)","v":{"v":3118.75,"d":"3,118.75"}},null,{"v":10000,"d":"10,000.00"},{"$f":"C19-E13","v":{"v":3118.75,"d":"3,118.75"}}]

{"sheet":"Fiches 1 et 2","index":1,"n_rows":56,"n_cols":12,"rows_kept":56,"merged":[[0,8,0,11],[3,3,3,6],[4,3,4,6],[9,2,9,10],[13,2,13,10],[15,4,15,5],[15,6,15,7],[17,11,18,11],[19,4,19,8],[20,4,20,8],[22,4,22,5],[22,6,22,7],[22,8,22,9],[30,8,30,11],[33,3,33,6],[34,3,34,6],[39,2,39,10],[43,2,43,10],[45,4,45,5],[45,6,45,7],[47,11,48,11],[49,4,49,8],[50,4,50,8],[52,4,52,5],[52,6,52,7],[52,8,52,9]]}
[null,"FICHE DE SALAIRE",{"$nulls":4},"mois :",null,"B"]
[]
[]
[null,"Nom :",null,"TUANORFA Laure"]
[null,"Avs no",{"$nulls":6},"AVS o/n","n"]
[null,"Nb enfants",{"$nulls":6},"LPP o/n","n"]
[]
[]
[null,null,"Décompte"]
[null,null,"Salaire déterminant AVS",{"$nulls":8},{"v":690,"d":"690.00"}]
[]
[null,null,"Allocations enfants",{"$nulls":8},{"$f":"D6*Coti!$E$9","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Salaire brut",{"$nulls":8},{"$f":"L10+L12","v":{"v":690,"d":"690.00"}}]
[]
[null,null,"Charges sociales",null,"totales",null,"à charge",null,"s/CHF"]
[null,null,"  ./. Caisse de pens.",null,{"$f":"Coti!$E$5+Coti!$G$5","v":22},"%",{"$f":"Coti!$G$5","v":10},"%",{"$f":"IF(L10<Coti!$G$12,0,IF(AND(L10>Coti!$G$12-0.1,L10<Coti!$G$13),Coti!$I$12,IF(L10>Coti!$G$14,Coti!$I$14,IF(L10>Coti!$G$13-0.1,L10-Coti!$E$13))))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(J6=\"o\",I17*G17/100,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"  ./. Ass acc non prof",null,{"$f":"Coti!$E$6+Coti!$G$6","v":1.8599999999999999},"%",{"$f":"Coti!$G$6","v":1.46},"%",{"$f":"L10","v":{"v":690,"d":"690.00"}},null,{"$f":"I18*G18/100","v":{"v":10.074,"d":"10.07"}},{"$f":"SUM(K17:K19)","v":{"v":10.074,"d":"10.07"}}]
[null,null,"  ./. AVS/AI/APG/AC",null,{"$f":"Coti!$E$7+Coti!$G$7","v":12.399999999999999},"%",{"$f":"Coti!$G$7","v":6.05},"%",{"$f":"L10","v":{"v":690,"d":"690.00"}},null,{"$f":"IF(J5=\"o\",I19*G19/100,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"Autres déductions",{"$nulls":7},"  -"]
[null,null,"Bonifications",null,"assurance malade",{"$nulls":5}," +",{"v":120,"d":"120.00"}]
[]
[null,null,"Frais de déplacements",null,"Nb de km",null,"Tarif",null,"Forfait"]
[{"$nulls":5},"km",null,"fr.",null,"fr.",null,{"$f":"(E24*G24)+I24","v":{"v":0,"d":"0.00"}}]
[null,null,"Arrondi au fr. sup.",{"$nulls":8},{"$f":"L26-(L14-L18-L20+L21+L24)","v":{"v":0.07399999999995543,"d":"0.07"}}]
[null,null,"Montant net",{"$nulls":7},"   Net :",{"$f":"CEILING((L14-L18-L20+L21+L24),1)","v":{"v":800,"d":"800.00"}}]
[]
[]
[]
[]
[null,"FICHE DE SALAIRE",{"$nulls":4},"mois :"]
[]
[]
[null,"Nom :",null,"DEWERT Hélène"]
[null,"Avs no",{"$nulls":6},"AVS o/n","o"]
[null,"Nb enfants",null,1,{"$nulls":4},"LPP o/n","o"]
[]
[]
[null,null,"Décompte"]
[null,null,"Salaire déterminant AVS",{"$nulls":8},{"v":4200,"d":"4,200.00"}]
[]
[null,null,"Allocations enfants",{"$nulls":8},{"$f":"D36*Coti!$E$9","v":{"v":150,"d":"150.00"}}]
[]
[null,null,"Salaire brut",{"$nulls":8},{"$f":"L40+L42","v":{"v":4350,"d":"4,350.00"}}]
[]
[null,null,"Charges sociales",null,"totales",null,"à charge",null,"s/CHF"]
[null,null,"  ./. Caisse de pens.",null,{"$f":"Coti!$E$5+Coti!$G$5","v":22},"%",{"$f":"Coti!$G$5","v":10},"%",{"$f":"IF(L40<Coti!$G$12,0,IF(AND(L40>Coti!$G$12-0.1,L40<Coti!$G$13),Coti!$I$12,IF(L40>Coti!$G$14,Coti!$I$14,IF(L40>Coti!$G$13-0.1,L40-Coti!$E$13))))","v":{"v":2318.75,"d":"2,318.75"}},null,{"$f":"IF(J36=\"o\",I47*G47/100,0)","v":{"v":231.875,"d":"231.88"}}]
[null,null,"  ./. Ass acc non prof",null,{"$f":"Coti!$E$6+Coti!$G$6","v":1.8599999999999999},"%",{"$f":"Coti!$G$6","v":1.46},"%",{"$f":"L40","v":{"v":4200,"d":"4,200.00"}},null,{"$f":"I48*G48/100","v":61.32},{"$f":"SUM(K47:K49)","v":{"v":547.295,"d":"547.30"}}]
[null,null,"  ./. AVS/AI/APG/AC",null,{"$f":"Coti!$E$7+Coti!$G$7","v":12.399999999999999},"%",{"$f":"Coti!$G$7","v":6.05},"%",{"$f":"L40","v":{"v":4200,"d":"4,200.00"}},null,{"$f":"IF(J35=\"o\",I49*G49/100,0)","v":{"v":254.1,"d":"254.10"}}]
[null,null,"Autres déductions",null,"avance de salaire",{"$nulls":5},"  -",{"v":400,"d":"400.00"}]
[null,null,"Bonifications",{"$nulls":7}," +"]
[]
[null,null,"Frais de déplacements",null,"Nb de km",null,"Tarif",null,"Forfait"]
[{"$nulls":5},"km",null,"fr.",null,"fr.",null,{"$f":"(E54*G54)+I54","v":{"v":0,"d":"0.00"}}]
[null,null,"Arrondi au fr. sup.",{"$nulls":8},{"$f":"L56-(L44-L48-L50+L51+L54)","v":{"v":0.29500000000007276,"d":"0.30"}}]
[null,null,"Montant net",{"$nulls":7},"   Net :",{"$f":"CEILING((L44-L48-L50+L51+L54),1)","v":{"v":3403,"d":"3,403.00"}}]

{"sheet":"Fiches 3 et 4","index":2,"n_rows":56,"n_cols":12,"rows_kept":56,"merged":[[0,8,0,11],[3,3,3,6],[4,3,4,6],[9,2,9,10],[13,2,13,10],[15,4,15,5],[15,6,15,7],[17,11,18,11],[19,4,19,8],[20,4,20,8],[22,4,22,5],[22,6,22,7],[22,8,22,9],[30,8,30,11],[33,3,33,6],[34,3,34,6],[39,2,39,10],[43,2,43,10],[45,4,45,5],[45,6,45,7],[47,11,48,11],[49,4,49,8],[50,4,50,8],[52,4,52,5],[52,6,52,7],[52,8,52,9]]}
[null,"FICHE DE SALAIRE",{"$nulls":4},"mois :"]
[]
[]
[null,"Nom :",null,"HATAN Charles"]
[null,"Avs no",{"$nulls":6},"AVS o/n","o"]
[null,"Nb enfants",null,3,{"$nulls":4},"LPP o/n","o"]
[]
[]
[null,null,"Décompte"]
[null,null,"Salaire déterminant AVS",{"$nulls":8},{"v":7800,"d":"7,800.00"}]
[]
[null,null,"Allocations enfants",{"$nulls":8},{"$f":"D6*Coti!$E$9","v":{"v":450,"d":"450.00"}}]
[]
[null,null,"Salaire brut",{"$nulls":8},{"$f":"L10+L12","v":{"v":8250,"d":"8,250.00"}}]
[]
[null,null,"Charges sociales",null,"totales",null,"à charge",null,"s/CHF"]
[null,null,"  ./. Caisse de pens.",null,{"$f":"Coti!$E$5+Coti!$G$5","v":22},"%",{"$f":"Coti!$G$5","v":10},"%",{"$f":"IF(L10<Coti!$G$12,0,IF(AND(L10>Coti!$G$12-0.1,L10<Coti!$G$13),Coti!$I$12,IF(L10>Coti!$G$14,Coti!$I$14,IF(L10>Coti!$G$13-0.1,L10-Coti!$E$13))))","v":{"v":4568.75,"d":"4,568.75"}},null,{"$f":"IF(J6=\"o\",I17*G17/100,0)","v":{"v":456.875,"d":"456.88"}}]
[null,null,"  ./. Ass acc non prof",null,{"$f":"Coti!$E$6+Coti!$G$6","v":1.8599999999999999},"%",{"$f":"Coti!$G$6","v":1.46},"%",{"$f":"L10","v":{"v":7800,"d":"7,800.00"}},null,{"$f":"I18*G18/100","v":113.88},{"$f":"SUM(K17:K19)","v":{"v":1042.655,"d":"1,042.66"}}]
[null,null,"  ./. AVS/AI/APG/AC",null,{"$f":"Coti!$E$7+Coti!$G$7","v":12.399999999999999},"%",{"$f":"Coti!$G$7","v":6.05},"%",{"$f":"L10","v":{"v":7800,"d":"7,800.00"}},null,{"$f":"IF(J5=\"o\",I19*G19/100,0)","v":{"v":471.9,"d":"471.90"}}]
[null,null,"Autres déductions",{"$nulls":7},"  -"]
[null,null,"Bonifications",{"$nulls":7}," +"]
[]
[null,null,"Frais de déplacements",null,"Nb de km",null,"Tarif",null,"Forfait"]
[{"$nulls":5},"km",null,"fr.",320,"fr.",null,{"$f":"(E24*G24)+I24","v":{"v":320,"d":"320.00"}}]
[null,null,"Arrondi au fr. sup.",{"$nulls":8},{"$f":"L26-(L14-L18-L20+L21+L24)","v":{"v":0.6549999999997453,"d":"0.65"}}]
[null,null,"Montant net",{"$nulls":7},"   Net :",{"$f":"CEILING((L14-L18-L20+L21+L24),1)","v":{"v":7528,"d":"7,528.00"}}]
[]
[]
[]
[]
[null,"FICHE DE SALAIRE",{"$nulls":4},"mois :"]
[]
[]
[null,"Nom :"]
[null,"Avs no",{"$nulls":6},"AVS o/n","o"]
[null,"Nb enfants",{"$nulls":6},"LPP o/n","o"]
[]
[]
[null,null,"Décompte"]
[null,null,"Salaire déterminant AVS",{"$nulls":8},{"v":0,"d":"0.00"}]
[]
[null,null,"Allocations enfants",{"$nulls":8},{"$f":"D36*Coti!$E$9","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Salaire brut",{"$nulls":8},{"$f":"L40+L42","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Charges sociales",null,"totales",null,"à charge",null,"s/CHF"]
[null,null,"  ./. Caisse de pens.",null,{"$f":"Coti!$E$5+Coti!$G$5","v":22},"%",{"$f":"Coti!$G$5","v":10},"%",{"$f":"IF(L40<Coti!$G$12,0,IF(AND(L40>Coti!$G$12-0.1,L40<Coti!$G$13),Coti!$I$12,IF(L40>Coti!$G$14,Coti!$I$14,IF(L40>Coti!$G$13-0.1,L40-Coti!$E$13))))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(J36=\"o\",I47*G47/100,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"  ./. Ass acc non prof",null,{"$f":"Coti!$E$6+Coti!$G$6","v":1.8599999999999999},"%",{"$f":"Coti!$G$6","v":1.46},"%",{"$f":"L40","v":{"v":0,"d":"0.00"}},null,{"$f":"I48*G48/100","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K47:K49)","v":{"v":0,"d":"0.00"}}]
[null,null,"  ./. AVS/AI/APG/AC",null,{"$f":"Coti!$E$7+Coti!$G$7","v":12.399999999999999},"%",{"$f":"Coti!$G$7","v":6.05},"%",{"$f":"L40","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(J35=\"o\",I49*G49/100,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"Autres déductions",{"$nulls":7},"  -"]
[null,null,"Bonifications",{"$nulls":7}," +"]
[]
[null,null,"Frais de déplacements",null,"Nb de km",null,"Tarif",null,"Forfait"]
[{"$nulls":5},"km",null,"fr.",null,"fr.",null,{"$f":"(E54*G54)+I54","v":{"v":0,"d":"0.00"}}]
[null,null,"Arrondi au fr. sup.",{"$nulls":8},{"$f":"L56-(L44-L48-L50+L51+L54)","v":{"v":0,"d":"0.00"}}]
[null,null,"Montant net",{"$nulls":7},"   Net :",{"$f":"CEILING((L44-L48-L50+L51+L54),1)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Vide à imprimer","index":3,"n_rows":56,"n_cols":12,"rows_kept":56,"merged":[[0,8,0,11],[3,3,3,6],[4,3,4,6],[9,2,9,10],[13,2,13,10],[15,4,15,5],[15,6,15,7],[17,11,18,11],[19,4,19,8],[20,4,20,8],[22,4,22,5],[22,6,22,7],[22,8,22,9],[30,8,30,11],[33,3,33,6],[34,3,34,6],[39,2,39,10],[43,2,43,10],[45,4,45,5],[45,6,45,7],[47,11,48,11],[49,4,49,8],[50,4,50,8],[52,4,52,5],[52,6,52,7],[52,8,52,9]]}
[null,"FICHE DE SALAIRE",{"$nulls":4},"mois :"]
[]
[]
[null,"Nom :"]
[null,"Avs no",{"$nulls":6},"AVS o/n"]
[null,"Nb enfants",{"$nulls":6},"LPP o/n"]
[]
[]
[null,null,"Décompte"]
[null,null,"Salaire déterminant AVS"]
[]
[null,null,"Allocations enfants",{"$nulls":8},{"$f":"D6*Coti!$E$9","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Salaire brut",{"$nulls":8},{"$f":"L10+L12","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Charges sociales",null,"totales",null,"à charge",null,"s/CHF"]
[null,null,"  ./. Caisse de pens.",null,null,"%",null,"%",{"$f":"IF(L10<Coti!$G$12,0,IF(AND(L10>Coti!$G$12-0.1,L10<Coti!$G$13),Coti!$I$12,IF(L10>Coti!$G$14,Coti!$I$14,IF(L10>Coti!$G$13-0.1,L10-Coti!$E$13))))","v":0},null,{"$f":"IF(J6=\"o\",I17*G17/100,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"  ./. Ass acc non prof",null,null,"%",null,"%",{"$f":"L10","v":0},null,{"$f":"I18*G18/100","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K17:K19)","v":{"v":0,"d":"0.00"}}]
[null,null,"  ./. AVS/AI/APG/AC",null,null,"%",null,"%",{"$f":"L10","v":0},null,{"$f":"IF(J5=\"o\",I19*G19/100,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"Autres déductions",{"$nulls":7},"  -"]
[null,null,"Bonifications",{"$nulls":7}," +"]
[]
[null,null,"Frais de déplacements",null,"Nb de km",null,"Tarif",null,"Forfait"]
[{"$nulls":5},"km",null,"fr.",null,"fr.",null,{"$f":"(E24*G24)+I24","v":{"v":0,"d":"0.00"}}]
[null,null,"Arrondi au fr. sup.",{"$nulls":8},{"$f":"L26-(L14-L18-L20+L21+L24)","v":{"v":0,"d":"0.00"}}]
[null,null,"Montant net",{"$nulls":7},"   Net :",{"$f":"CEILING((L14-L18-L20+L21+L24),1)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[]
[null,"FICHE DE SALAIRE",{"$nulls":4},"mois :"]
[]
[]
[null,"Nom :"]
[null,"Avs no",{"$nulls":6},"AVS o/n"]
[null,"Nb enfants",{"$nulls":6},"LPP o/n"]
[]
[]
[null,null,"Décompte"]
[null,null,"Salaire déterminant AVS"]
[]
[null,null,"Allocations enfants",{"$nulls":8},{"$f":"D36*Coti!$E$9","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Salaire brut",{"$nulls":8},{"$f":"L40+L42","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Charges sociales",null,"totales",null,"à charge",null,"s/CHF"]
[null,null,"  ./. Caisse de pens.",{"$nulls":4},"%",{"$f":"IF(L40<Coti!$G$12,0,IF(AND(L40>Coti!$G$12-0.1,L40<Coti!$G$13),Coti!$I$12,IF(L40>Coti!$G$14,Coti!$I$14,IF(L40>Coti!$G$13-0.1,L40-Coti!$E$13))))","v":0},null,{"$f":"IF(J36=\"o\",I47*G47/100,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"  ./. Ass acc non prof",{"$nulls":4},"%",{"$f":"L40","v":0},null,{"$f":"I48*G48/100","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K47:K49)","v":{"v":0,"d":"0.00"}}]
[null,null,"  ./. AVS/AI/APG/AC",{"$nulls":4},"%",{"$f":"L40","v":0},null,{"$f":"IF(J35=\"o\",I49*G49/100,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"Autres déductions",{"$nulls":7},"  -"]
[null,null,"Bonifications",{"$nulls":7}," +"]
[]
[null,null,"Frais de déplacements",null,"Nb de km",null,"Tarif",null,"Forfait"]
[{"$nulls":5},"km",null,"fr.",null,"fr.",null,{"$f":"(E54*G54)+I54","v":{"v":0,"d":"0.00"}}]
[null,null,"Arrondi au fr. sup.",{"$nulls":8},{"$f":"L56-(L44-L48-L50+L51+L54)","v":{"v":0,"d":"0.00"}}]
[null,null,"Montant net",{"$nulls":7},"   Net :",{"$f":"CEILING((L44-L48-L50+L51+L54),1)","v":{"v":0,"d":"0.00"}}]