{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Fiche frais du personnel"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"Fiche frais du personnel","index":0,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,1,1,3],[62,1,62,10]]}
[null,null,null,null,"CEForestier"]
[null,null,null,null,"Frais de personnel",null,null,null,null,null,"Formulaire de calcul"]
[]
[null,null,"Case à compléter :"]
[null,null,"Entreprise :",null,null,null,null,null,"Année :",{"$f":"YEAR(TODAY())","v":2020}]
[null,null,"Canton :","VD"]
[null,null,"Employé :",null,null,null,null,null,"Centre de  charge (CEFuniquement)"]
[null,null,"Année de naissance :"]
[]
[]
[null,"1. Salaire brut ",null,null,null,null,null,null,null,null,"GF/P"]
[null,"   a) sans allocations familiales, mais vacances, jours fériés,"]
[null,"       13e salaire, supplément de lieu et dédommagement intmepéries inclus",null,null,null,null,null,null,{"$f":"I16-(I14+I15)","v":0}]
[null,"   b) Part; indemnité perte de gains (comme 2a)",null,null,null,null,null,null,{"$f":"I19","v":0}]
[null,"   c) Part; indemnité accident ou maladie (comme 2b+2c)  ",null,null,null,null,null,null,{"$f":"I20+I21","v":0}]
[null,"   Total",null,null,null,null,null,null,null,"Fr.",100]
[]
[null,"2. Remboursements"]
[null,"   a) APG "]
[null,"   b) Prestation d'assurance en cas d'accident, de maladie, ou d'invalidité   "]
[null,"   c) Indemnité journalière maladie          "]
[null,"   d) Intempéries"]
[null,"   Total",null,null,null,"",null,null,{"$f":"SUM(I19:I22)","v":0},"Fr.",243]
[]
[null,"4. Déductions sociales (part de l'employeur)"]
[null," - AVS / AI / APG  (1a+1b * %)",null,null,null,{"$f":"_xlfn.IFS(J5-D8<18,\"Non soumis\",J5-D8>17,\"Soumis\")","v":"Soumis"},5.2750000000000004,"%",{"$f":"(I13+I14)*G26/100","v":0}]
[null," - Assurance chômage  (1a+1b * %)",null,null,null,{"$f":"_xlfn.IFS(J5-D8<18,\"Non soumis\",J5-D8>17,\"Soumis\")","v":"Soumis"},{"$f":"_xlfn.IFS(I16<148201,1.1,I16>148200,0.5)","v":1.1000000000000001},"%",{"$f":"IF((I13+I14)>148200,ROUND((((G27/100)*148200)+((I13+I14-97200)*0.005))*20,0)/20,ROUND(((G27/100)*(I13+I14))*20,0)/20)","v":0}]
[null," - Caisse allocations familiales  (1a+1b * %)",null,null,null,{"$f":"D6","v":"VD"},{"$f":"_xlfn.IFS(D6=\"VD\",2.83,D6=\"FR\",2.85,D6=\"GE\",2.45,D6=\"NE\",2.1,D6=\"JU\",2,D6=\"BE\",2,D6=\"VS\",2)","v":2.83},"%",{"$f":"ROUND(((G28/100)*(I13+I14))*20,0)/20","v":0}]
[null," - Frais administratifs AVS/AI/APG",null,null,null,{"$f":"_xlfn.IFS(J5-D8<18,\"Non soumis\",J5-D8>17,\"Soumis\")","v":"Soumis"},{"$f":"_xlfn.IFS(D6=\"VD\",1.6,D6=\"FR\",5,D6=\"GE\",2.4,D6=\"NE\",1.8,D6=\"JU\",2.5,D6=\"BE\",1.7,D6=\"VS\",0.5)","v":1.6},"%",{"$f":"_xlfn.IFS(D6=\"VD\",(I26*G29)/100,D6=\"FR\",(I26*G29)/100,D6=\"GE\",(I26*G29)/100,D6=\"BE\",(I26*G29)/100,D6=\"JU\",(I26*G29)/100,D6=\"NE\",(I26*G29)/100,D6=\"VS\",((I13+I14)*G29)/100)","v":0}]
[null," - SUVA acc. prof.  (1a %), individuel taux moyen",null,null,null,null,2.2000000000000002,"%",{"$f":"IF(I13<148200,ROUND((((G30/100)*I13))*20,0)/20,ROUND(((G30/100)*(148200))*20,0)/20)","v":0}]
[null," - SUVA acc. prof. coûts admin taux moyen",null,null,null,null,12.5,"%",{"$f":"(I30*G31)/100","v":0}]
[null," - SUVA acc. non prof. (1a %), individuel non obligatoire",null,null,null,null,null,"%",{"$f":"(I16*G32)/100","v":0}]
[null," - SUVA acc. non prof. coûts adm. non obligatoire",null,null,null,null,{"$f":"_xlfn.IFS(G32>0,13.75,G32<1,\" \")","v":" "},"%",{"$f":"_xlfn.IFS(G32>0,(I32*G33)/100,G32<1,0)","v":0}]
[null," - Caisse de pension"]
[null," - Indemnité journalières maladie"]
[null," - Caisse maladie"]
[null," - Complémentaire accidents"]
[null," - Charges sociales particulières"]
[null,{"$f":"IF(D6=\"VS\",\" - Allocations familiales prestations complémentaires de l'entreprise\", \" - Autre\")","v":" - Autre"}]
[null,"   Total",null,null,null,"",null,null,{"$f":"SUM(I26:I39)","v":0},"Fr.",101]
[]
[null,"5. Vacations"]
[null,"   - Repas"]
[null,"   - Frais Km"]
[null,"   - Divers"]
[null,"   Total",null,null,null,"",null,null,{"$f":"SUM(I43:I45)","v":0},"Fr.",103]
[]
[null,"6. Divers"]
[null,"   - Indemnités, jetons de présence",null,null,null,null,null,null,null,null,104]
[null,"   - Habillement de protection, frais de cours",null,null,null,null,null,null,null,null,109]
[null,"   - Divers",null,null,null,null,null,null,null,null,109]
[null,"   - Frais de personnel calculés",null,null,null,null,null,null,null,null,169]
[null,"  Total",null,null,null,null,null,null,{"$f":"SUM(I49:I52)","v":0},"Fr."]
[]
[null,"Total général",null,null,null,null,null,null,{"$f":"SUM(I16+I40+I46+I49+I50+I52-I23)","v":0},"Fr."]
[]
[null,"Coût horaire",null,null,null,"Heures productives",null,"=",{"$f":"IF(G57=0,\" \",ROUND((I55/G57)*20,0)/20)","v":" "},"Fr./h"]
[]
[null,"Remarques"," - Saisir seulement les frais de l'employeur"]
[null,null," - Soumis à l'AVS :  dès 1er janvier qui suit le 17e anniversaire"]
[null,null," - Limite supérieure pour la SUVA : salaire brut CHF 148'200,--."]
[null,null," - Limite supérieure AC : salaire brut CHF 148'200.-- 1.1%, dès CHF 148'200.-- 0.5%"]
[null,"Le résultat obtenu à l'aide du présent formulaire n'a qu'une valeur indicative. Si vous souhaitez obtenir des renseignements juridiquement vlables, veuillez vous adresser à votre caisse de copensation"]