{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Année","Export CEF"],"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":"Année","index":0,"n_rows":56,"n_cols":27,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,13,1,17],[4,3,4,4],[0,6,0,7]]}
[null,null,null,"CEForestier",null,null,"Année :"]
[null,null,null,"Frais de personnel",null,null,null,"Elément d'exploitation",null,null,null,null,null,"Remplir les case en vert clair",null,null,null,null,null,null,null,null,null,null,null,null,"Formulaire de calcul"]
[]
[null,null,null,null,null,null,"Garde forest.",null,"Contremaître",null,"Bûcheron",null,"Bûcheron",null,"Bûcheron",null,"Apprenti",null,"Apprenti",null,"Apprenti",null,"Temporaire",null,"Temporaire","TOTAUX"]
[1,"Salaire brut ",null,"Saisir le nom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G F/P"]
[null,"   a) sans alloc. Fam., mais vacances, jours fériés,"]
[null,"       13e sal., suppl. de lieu et dédomm. Intemp. inclus",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"G7+I7+K7+M7+O7+Q7+S7+U7+W7+Y7","v":0}]
[null,"   b) Part; indemnité perte de gains (comme 2a)",null,null,null,null,0,null,{"$f":"I13","v":0},null,{"$f":"K13","v":0},null,{"$f":"M13","v":0},null,{"$f":"O13","v":0},null,{"$f":"Q13","v":0},null,{"$f":"S13","v":0},null,{"$f":"U13","v":0},null,{"$f":"W13","v":0},null,{"$f":"Y13","v":0},{"$f":"G8+I8+K8+M8+O8+Q8+S8+U8+W8+Y8","v":0}]
[null,"   c) Part; indemnité acc. ou maladie (comme 2b+2c)  ",null,null,null,null,0,null,{"$f":"I14+I15","v":0},null,{"$f":"K14+K15","v":0},null,{"$f":"M14+M15","v":0},null,{"$f":"O14+O15","v":0},null,0,null,0,null,{"$f":"U14+U15","v":0},null,{"$f":"W14+W15","v":0},null,{"$f":"Y14+Y15","v":0},{"$f":"G9+I9+K9+M9+O9+Q9+S9+U9+W9+Y9","v":0}]
[null,"   Total"," (= ligne de saisie du salaire brut)",null,null,null,{"$f":"SUM(G7:G9)","v":0},null,{"$f":"SUM(I7:I9)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"G10+I10+K10+M10+O10+Q10+S10+U10+W10+Y10","v":0},100]
[]
["2.","Remboursements "]
[null,"   a) Accident professionnel ",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"G13+I13+K13+M13+O13+Q13+S13+U13+W13+Y13","v":0}]
[null,"   b) Indemnité journalière accident   SUVA     ",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"G14+I14+K14+M14+O14+Q14+S14+U14+W14+Y14","v":0}]
[null,"   c) Indemnité journalière maladie          ",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"G15+I15+K15+M15+O15+Q15+S15+U15+W15+Y15","v":0}]
[null,"   d) Intempéries",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"G16+I16+K16+M16+O16+Q16+S16+U16+W16+Y16","v":0}]
[null,"   Total",null,"",null,null,{"$f":"SUM(G13:G16)","v":0},null,{"$f":"SUM(I13:I16)","v":0},null,{"$f":"SUM(K13:K16)","v":0},null,{"$f":"SUM(M13:M16)","v":0},null,{"$f":"SUM(O13:O16)","v":0},null,{"$f":"SUM(Q13:Q16)","v":0},null,{"$f":"SUM(S13:S16)","v":0},null,{"$f":"SUM(U13:U16)","v":0},null,{"$f":"SUM(W13:W16)","v":0},null,{"$f":"SUM(Y13:Y16)","v":0},{"$f":"G17+I17+K17+M17+O17+Q17+S17+U17+W17+Y17","v":0},240]
[]
["4.","Charges sociales (part employeur) "]
[null,"   - AVS / AI /  (1a+1b * %)  (illimité)            ",null,null,"%",null,{"$f":"ROUND(((F20/100)*(G7+G8))*20,0)/20","v":0},{"$f":"F20","v":0},{"$f":"ROUND(((H20/100)*(I7+I8))*20,0)/20","v":0},{"$f":"H20","v":0},{"$f":"ROUND(((J20/100)*(K7+K8))*20,0)/20","v":0},{"$f":"J20","v":0},{"$f":"ROUND(((L20/100)*(M7+M8))*20,0)/20","v":0},{"$f":"L20","v":0},{"$f":"ROUND(((N20/100)*(O7+O8))*20,0)/20","v":0},{"$f":"N20","v":0},{"$f":"ROUND(((P20/100)*(Q7+Q8))*20,0)/20","v":0},{"$f":"P20","v":0},{"$f":"ROUND(((R20/100)*(S7+S8))*20,0)/20","v":0},{"$f":"R20","v":0},{"$f":"ROUND(((T20/100)*(U7+U8))*20,0)/20","v":0},{"$f":"T20","v":0},{"$f":"ROUND(((V20/100)*(W7+W8))*20,0)/20","v":0},{"$f":"V20","v":0},{"$f":"ROUND(((X20/100)*(Y7+Y8))*20,0)/20","v":0},{"$f":"G20+I20+K20+M20+O20+Q20+S20+U20+W20+Y20","v":0}]
[null,"   - Assurance chômage  (1a+1b * %) ",null,null,"%",null,{"$f":"IF((G7+G8)>106800,ROUND((((F21/100)*106800)+((G7+G8-97200)*0.005))*20,0)/20,ROUND(((F21/100)*(G7+G8))*20,0)/20)","v":0},0,{"$f":"IF((I7+I8)>106800,ROUND((((H21/100)*106800)+((I7+I8-97200)*0.005))*20,0)/20,ROUND(((H21/100)*(I7+I8))*20,0)/20)","v":0},0,{"$f":"IF((K7+K8)>106800,ROUND((((J21/100)*106800)+((K7+K8-97200)*0.005))*20,0)/20,ROUND(((J21/100)*(K7+K8))*20,0)/20)","v":0},0,{"$f":"IF((M7+M8)>106800,ROUND((((L21/100)*106800)+((M7+M8-97200)*0.005))*20,0)/20,ROUND(((L21/100)*(M7+M8))*20,0)/20)","v":0},0,{"$f":"IF((O7+O8)>106800,ROUND((((N21/100)*106800)+((O7+O8-97200)*0.005))*20,0)/20,ROUND(((N21/100)*(O7+O8))*20,0)/20)","v":0},0,{"$f":"IF((Q7+Q8)>106800,ROUND((((P21/100)*106800)+((Q7+Q8-97200)*0.005))*20,0)/20,ROUND(((P21/100)*(Q7+Q8))*20,0)/20)","v":0},0,{"$f":"IF((S7+S8)>106800,ROUND((((R21/100)*106800)+((S7+S8-97200)*0.005))*20,0)/20,ROUND(((R21/100)*(S7+S8))*20,0)/20)","v":0},0,{"$f":"IF((U7+U8)>106800,ROUND((((T21/100)*106800)+((U7+U8-97200)*0.005))*20,0)/20,ROUND(((T21/100)*(U7+U8))*20,0)/20)","v":0},0,{"$f":"IF((W7+W8)>106800,ROUND((((V21/100)*106800)+((W7+W8-97200)*0.005))*20,0)/20,ROUND(((V21/100)*(W7+W8))*20,0)/20)","v":0},0,{"$f":"IF((Y7+Y8)>106800,ROUND((((X21/100)*106800)+((Y7+Y8-97200)*0.005))*20,0)/20,ROUND(((X21/100)*(Y7+Y8))*20,0)/20)","v":0},0]
[null,"   - Caisse all. Fam. (1a+1b * %) (illimité)                                 ",null,null,"%",null,{"$f":"ROUND(((F22/100)*(G7+G8))*20,0)/20","v":0},0,{"$f":"ROUND(((H22/100)*(I7+I8))*20,0)/20","v":0},0,{"$f":"ROUND(((J22/100)*(K7+K8))*20,0)/20","v":0},0,{"$f":"ROUND(((L22/100)*(M7+M8))*20,0)/20","v":0},0,{"$f":"ROUND(((N22/100)*(O7+O8))*20,0)/20","v":0},0,{"$f":"ROUND(((P22/100)*(Q7+Q8))*20,0)/20","v":0},0,{"$f":"ROUND(((R22/100)*(S7+S8))*20,0)/20","v":0},0,{"$f":"ROUND(((T22/100)*(U7+U8))*20,0)/20","v":0},0,{"$f":"ROUND(((V22/100)*(W7+W8))*20,0)/20","v":0},0,{"$f":"ROUND(((X22/100)*(Y7+Y8))*20,0)/20","v":0},0]
[null,"   - Coûts adm. AVS/AI (0.3%), individuel",null,null,"%",null,{"$f":"ROUND(((F23/100)*(2*G20))*20,0)/20","v":0},0,{"$f":"ROUND(((H23/100)*(2*I20))*20,0)/20","v":0},0,{"$f":"ROUND(((J23/100)*(2*K20))*20,0)/20","v":0},0,{"$f":"ROUND(((L23/100)*(2*M20))*20,0)/20","v":0},0,{"$f":"ROUND(((N23/100)*(2*O20))*20,0)/20","v":0},0,{"$f":"ROUND(((P23/100)*(2*Q20))*20,0)/20","v":0},0,{"$f":"ROUND(((R23/100)*(2*S20))*20,0)/20","v":0},0,{"$f":"ROUND(((T23/100)*(2*U20))*20,0)/20","v":0},0,{"$f":"ROUND(((V23/100)*(2*W20))*20,0)/20","v":0},0,{"$f":"ROUND(((X23/100)*(2*Y20))*20,0)/20","v":0},0]
[null,"   - SUVA  acc. prof.  (1a * %), individuel         ",null,null,"%",null,{"$f":"IF(G7<106800,ROUND((((F24/100)*G7))*20,0)/20,ROUND(((F24/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(I7<106800,ROUND((((H24/100)*I7))*20,0)/20,ROUND(((H24/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(K7<106800,ROUND((((J24/100)*K7))*20,0)/20,ROUND(((J24/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(M7<106800,ROUND((((L24/100)*M7))*20,0)/20,ROUND(((L24/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(O7<106800,ROUND((((N24/100)*O7))*20,0)/20,ROUND(((N24/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(Q7<106800,ROUND((((P24/100)*Q7))*20,0)/20,ROUND(((P24/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(S7<106800,ROUND((((R24/100)*S7))*20,0)/20,ROUND(((R24/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(U7<106800,ROUND((((T24/100)*U7))*20,0)/20,ROUND(((T24/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(W7<106800,ROUND((((V24/100)*W7))*20,0)/20,ROUND(((V24/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(Y7<106800,ROUND((((X24/100)*Y7))*20,0)/20,ROUND(((X24/100)*(106800))*20,0)/20)","v":0},0]
[null,"   - Coûts adm. SUVA",null,null,"%",null,{"$f":"IF(G7<106800,ROUND((((F25/100)*G7))*20,0)/20,ROUND(((F25/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(I7<106800,ROUND((((H25/100)*I7))*20,0)/20,ROUND(((H25/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(K7<106800,ROUND((((J25/100)*K7))*20,0)/20,ROUND(((J25/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(M7<106800,ROUND((((L25/100)*M7))*20,0)/20,ROUND(((L25/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(O7<106800,ROUND((((N25/100)*O7))*20,0)/20,ROUND(((N25/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(Q7<106800,ROUND((((P25/100)*Q7))*20,0)/20,ROUND(((P25/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(S7<106800,ROUND((((R25/100)*S7))*20,0)/20,ROUND(((R25/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(U7<106800,ROUND((((T25/100)*U7))*20,0)/20,ROUND(((T25/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(W7<106800,ROUND((((V25/100)*W7))*20,0)/20,ROUND(((V25/100)*(106800))*20,0)/20)","v":0},0,{"$f":"IF(Y7<106800,ROUND((((X25/100)*Y7))*20,0)/20,ROUND(((X25/100)*(106800))*20,0)/20)","v":0},0]
[null,"   - SUVA  acc. non prof. Frais adm. inclus (1a * %), pas oblligatoire              ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   - Caisse de pension (PV)                        ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   - Indemnité journalières maladie           ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   - Caisse maladie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   - Complémentaire accidents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   - Charges socilaes particulières",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   - Allocations familiales (prest. Compl. de l'entreprise)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"   Total",null,"",null,null,{"$f":"SUM(G20:G32)","v":0},null,{"$f":"SUM(I20:I32)","v":0},null,{"$f":"SUM(K20:K32)","v":0},null,{"$f":"SUM(M20:M32)","v":0},null,{"$f":"SUM(O20:O32)","v":0},null,{"$f":"SUM(Q20:Q32)","v":0},null,{"$f":"SUM(S20:S32)","v":0},null,{"$f":"SUM(U20:U32)","v":0},null,{"$f":"SUM(W20:W32)","v":0},null,{"$f":"SUM(Y20:Y32)","v":0},0,101]
[]
["5.","Vacations "]
[null,"   - Repas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G36+I36+K36+M36+O36+Q36+S36+U36+W36+Y36","v":0}]
[null,"   - Frais Km",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G37+I37+K37+M37+O37+Q37+S37+U37+W37+Y37","v":0}]
[null,"   - Divers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G38+I38+K38+M38+O38+Q38+S38+U38+W38+Y38","v":0}]
[null,"   Total",null,"",null,null,{"$f":"SUM(G36:G38)","v":0},null,{"$f":"SUM(I36:I38)","v":0},null,{"$f":"SUM(K36:K38)","v":0},null,{"$f":"SUM(M36:M38)","v":0},null,{"$f":"SUM(O36:O38)","v":0},null,{"$f":"SUM(Q36:Q38)","v":0},null,{"$f":"SUM(S36:S38)","v":0},null,{"$f":"SUM(U36:U38)","v":0},null,{"$f":"SUM(W36:W38)","v":0},null,{"$f":"SUM(Y36:Y38)","v":0},null,103]
[]
["6.","Divers "]
[null,"   - Indemnités, jetons de présence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G42+I42+K42+M42+O42+Q42+S42+U42+W42+Y42","v":0},104]
[null,"   - Habillement de protection, frais de cours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109]
[null,"   - Divers (téléphone)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G44+I44+K44+M44+O44+Q44+S44+U44+W44+Y44","v":0},109]
[null,"   - Frais de personnel calculés",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G45+I45+K45+M45+O45+Q45+S45+U45+W45+Y45","v":0},169]
[null,"  Total",null,null,null,null,{"$f":"SUM(G42:G45)","v":0},null,{"$f":"SUM(I42:I45)","v":0},null,{"$f":"SUM(K42:K45)","v":0},null,{"$f":"SUM(M42:M45)","v":0},null,{"$f":"SUM(O42:O45)","v":0},null,{"$f":"SUM(Q42:Q45)","v":0},null,{"$f":"SUM(S42:S45)","v":0},null,{"$f":"SUM(U42:U45)","v":0},null,{"$f":"SUM(W42:W45)","v":0},null,{"$f":"SUM(Y42:Y45)","v":0},{"$f":"G46+I46+K46+M46+O46+Q46+S46+U46+W46+Y46","v":0}]
[]
[null,"Total général",null,null,null,null,{"$f":"SUM(G10+G33+G39+G46-G17)","v":0},null,{"$f":"SUM(I10+I33+I39+I46-I17)","v":0},null,{"$f":"SUM(K10+K33+K39+K46-K17)","v":0},null,{"$f":"SUM(M10+M33+M39+M46-M17)","v":0},null,{"$f":"SUM(O10+O33+O39+O46-O17)","v":0},null,{"$f":"SUM(Q10+Q33+Q39+Q46-Q17)","v":0},null,{"$f":"SUM(S10+S33+S39+S46-S17)","v":0},null,{"$f":"SUM(U10+U33+U39+U46-U17)","v":0},null,{"$f":"SUM(W10+W33+W39+W46-W17)","v":0},null,{"$f":"SUM(Y10+Y33+Y39+Y46-Y17)","v":0},{"$f":"G48+I48+K48+M48+O48+Q48+S48+U48+W48+Y48","v":0}]
[null,null,null,null,null,"heures  productives",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G49+I49+K49+M49+O49+Q49+S49+U49+W49+Y49","v":0}]
[null,"Coût horaire",null,null,null,"=",{"$f":"IF(G48=0,\" \",IF(G49=0,\"\",ROUND((G48/G49)*20,0)/20))","v":" "},"=",{"$f":"IF(I48=0,\" \",IF(I49=0,\"\",ROUND((I48/I49)*20,0)/20))","v":" "},"=",{"$f":"IF(K48=0,\" \",IF(K49=0,\"\",ROUND((K48/K49)*20,0)/20))","v":" "},"=",{"$f":"IF(M48=0,\" \",IF(M49=0,\"\",ROUND((M48/M49)*20,0)/20))","v":" "},"=",{"$f":"IF(O48=0,\" \",IF(O49=0,\"\",ROUND((O48/O49)*20,0)/20))","v":" "},"=",{"$f":"IF(Q48=0,\" \",IF(Q49=0,\"\",ROUND((Q48/Q49)*20,0)/20))","v":" "},"=",{"$f":"IF(S48=0,\" \",IF(S49=0,\"\",ROUND((S48/S49)*20,0)/20))","v":" "},"=",{"$f":"IF(U48=0,\" \",IF(U49=0,\"\",ROUND((U48/U49)*20,0)/20))","v":" "},"=",{"$f":"IF(W48=0,\" \",IF(W49=0,\"\",ROUND((W48/W49)*20,0)/20))","v":" "},"=",{"$f":"IF(Y48=0,\" \",IF(Y49=0,\"\",ROUND((Y48/Y49)*20,0)/20))","v":" "},{"$f":"IF(Z48=0,\" \",IF(Z49=0,\"\",ROUND((Z48/Z49)*20,0)/20))","v":" "}]
[]
[null,"Remarques"," - saisir seulement les frais de l'employeur",null,null,null,null,null," - Limite supérieure pour la SUVA: salaire brut CHF 106'800,--."]
[null,null," - soumis à l'AVS: - dès 1er janvier qui suit le 17e anniversaire",null,null,null,null,null," - Limite supérieure assurance chômage: salaire brut CHF 106'800.- , dès CHF 106'800 pas de cotisation"]
[null,null," -  montant minimum de cotiosation de l'employé: Fr. 425 p.an",null,null,null,null,null," - ne prendre en compte que les charges sociales payées par l'employeur!"]
[]
[null,null,"champs à remplir"]

{"sheet":"Export CEF","index":1,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Linie","Datum","Beleg","Konto","D/C","Text1","Betrag","NBTID","SchlagID","KTID","KEA","NBSTID","EG","Menge","Einheit"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[{"$f":"ROW()","v":3},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!G5&Année!$B$5","v":"Salaire brut "},{"$f":"Année!G10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!F5","v":0},{"$f":"Année!AA10","v":100}]
[{"$f":"ROW()","v":4},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!G5&Année!B12","v":"Remboursements "},{"$f":"Année!G17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!F5","v":0},{"$f":"Année!AA17","v":240}]
[{"$f":"ROW()","v":5},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!G5&Année!B19","v":"Charges sociales (part employeur) "},{"$f":"Année!G33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!F5","v":0},{"$f":"Année!AA33","v":101}]
[{"$f":"ROW()","v":6},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!G5&Année!B35","v":"Vacations "},{"$f":"Année!G39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!F5","v":0},{"$f":"Année!AA39","v":103}]
[{"$f":"ROW()","v":7},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!G5&Année!B41","v":"Divers "},{"$f":"Année!G46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!F5","v":0},{"$f":"Année!AA44","v":109}]
[{"$f":"ROW()","v":8},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!I5&Année!B5","v":"Salaire brut "},{"$f":"Année!I10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!H5","v":0},{"$f":"Année!AA10","v":100}]
[{"$f":"ROW()","v":9},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!I5&Année!B12","v":"Remboursements "},{"$f":"Année!I17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!H5","v":0},{"$f":"Année!AA17","v":240}]
[{"$f":"ROW()","v":10},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!I5&Année!B19","v":"Charges sociales (part employeur) "},{"$f":"Année!I33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!H5","v":0},{"$f":"Année!AA33","v":101}]
[{"$f":"ROW()","v":11},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!I5&Année!B35","v":"Vacations "},{"$f":"Année!I39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!H5","v":0},{"$f":"Année!AA39","v":103}]
[{"$f":"ROW()","v":12},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!I5&Année!B41","v":"Divers "},{"$f":"Année!I46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!H5","v":0},{"$f":"Année!AA44","v":109}]
[{"$f":"ROW()","v":13},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!K5&Année!B5","v":"Salaire brut "},{"$f":"Année!K10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!J5","v":0},{"$f":"Année!AA10","v":100}]
[{"$f":"ROW()","v":14},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!K5&Année!B12","v":"Remboursements "},{"$f":"Année!K17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!J5","v":0},{"$f":"Année!AA17","v":240}]
[{"$f":"ROW()","v":15},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!K5&Année!B19","v":"Charges sociales (part employeur) "},{"$f":"Année!K33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!J5","v":0},{"$f":"Année!AA33","v":101}]
[{"$f":"ROW()","v":16},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!K5&Année!B35","v":"Vacations "},{"$f":"Année!K39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!J5","v":0},{"$f":"Année!AA39","v":103}]
[{"$f":"ROW()","v":17},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!K5&Année!B41","v":"Divers "},{"$f":"Année!K46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!J5","v":0},{"$f":"Année!AA44","v":109}]
[{"$f":"ROW()","v":18},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!M5&Année!B5","v":"Salaire brut "},{"$f":"Année!M10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!L5","v":0},{"$f":"Année!AA10","v":100}]
[{"$f":"ROW()","v":19},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!M5&Année!B12","v":"Remboursements "},{"$f":"Année!M17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!L5","v":0},{"$f":"Année!AA17","v":240}]
[{"$f":"ROW()","v":20},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!M5&Année!B19","v":"Charges sociales (part employeur) "},{"$f":"Année!M33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!L5","v":0},{"$f":"Année!AA33","v":101}]
[{"$f":"ROW()","v":21},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!M5&Année!B35","v":"Vacations "},{"$f":"Année!M39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!L5","v":0},{"$f":"Année!AA39","v":103}]
[{"$f":"ROW()","v":22},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!M5&Année!B41","v":"Divers "},{"$f":"Année!M46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!L5","v":0},{"$f":"Année!AA44","v":109}]
[{"$f":"ROW()","v":23},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!O5&Année!B5","v":"Salaire brut "},{"$f":"Année!O10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!N5","v":0},{"$f":"Année!AA10","v":100}]
[{"$f":"ROW()","v":24},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!O5&Année!B12","v":"Remboursements "},{"$f":"Année!O17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!N5","v":0},{"$f":"Année!AA17","v":240}]
[{"$f":"ROW()","v":25},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!O5&Année!B19","v":"Charges sociales (part employeur) "},{"$f":"Année!O33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!N5","v":0},{"$f":"Année!AA33","v":101}]
[{"$f":"ROW()","v":26},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!O5&Année!B35","v":"Vacations "},{"$f":"Année!O39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!N5","v":0},{"$f":"Année!AA39","v":103}]
[{"$f":"ROW()","v":27},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!O5&Année!B41","v":"Divers "},{"$f":"Année!O46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!N5","v":0},{"$f":"Année!AA44","v":109}]
[{"$f":"ROW()","v":28},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Q5&Année!B5","v":"Salaire brut "},{"$f":"Année!Q10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!P5","v":0},{"$f":"Année!AA10","v":100}]
[{"$f":"ROW()","v":29},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Q5&Année!B12","v":"Remboursements "},{"$f":"Année!Q17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!P5","v":0},{"$f":"Année!AA17","v":240}]
[{"$f":"ROW()","v":30},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Q5&Année!B19","v":"Charges sociales (part employeur) "},{"$f":"Année!Q33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!P5","v":0},{"$f":"Année!AA33","v":101}]
[{"$f":"ROW()","v":31},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Q5&Année!B35","v":"Vacations "},{"$f":"Année!Q39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!P5","v":0},{"$f":"Année!AA39","v":103}]
[{"$f":"ROW()","v":32},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Q5&Année!B41","v":"Divers "},{"$f":"Année!Q46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!P5","v":0},{"$f":"Année!AA44","v":109}]
[{"$f":"ROW()","v":33},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!S5&Année!B5","v":"Salaire brut "},{"$f":"Année!S10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!R5","v":0},{"$f":"Année!AA10","v":100}]
[{"$f":"ROW()","v":34},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!S5&Année!B12","v":"Remboursements "},{"$f":"Année!S17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!R5","v":0},{"$f":"Année!AA17","v":240}]
[{"$f":"ROW()","v":35},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!S5&Année!B19","v":"Charges sociales (part employeur) "},{"$f":"Année!S33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!R5","v":0},{"$f":"Année!AA33","v":101}]
[{"$f":"ROW()","v":36},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!S5&Année!B35","v":"Vacations "},{"$f":"Année!S39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!R5","v":0},{"$f":"Année!AA39","v":103}]
[{"$f":"ROW()","v":37},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!S5&Année!B41","v":"Divers "},{"$f":"Année!S46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!R5","v":0},{"$f":"Année!AA44","v":109}]
[{"$f":"ROW()","v":38},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!U$5&Année!$B$5","v":"Salaire brut "},{"$f":"Année!U$10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!T5","v":0},{"$f":"Année!$AA$10","v":100}]
[{"$f":"ROW()","v":39},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!U$5&Année!$B$12","v":"Remboursements "},{"$f":"Année!U$17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!T5","v":0},{"$f":"Année!$AA$17","v":240}]
[{"$f":"ROW()","v":40},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!U$5&Année!$B$19","v":"Charges sociales (part employeur) "},{"$f":"Année!U$33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!T5","v":0},{"$f":"Année!$AA$33","v":101}]
[{"$f":"ROW()","v":41},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!U$5&Année!$B$35","v":"Vacations "},{"$f":"Année!U$39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!T5","v":0},{"$f":"Année!$AA$39","v":103}]
[{"$f":"ROW()","v":42},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!U$5&Année!$B$41","v":"Divers "},{"$f":"Année!U$46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!T$5","v":0},{"$f":"Année!$AA$44","v":109}]
[{"$f":"ROW()","v":43},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!W$5&Année!$B$5","v":"Salaire brut "},{"$f":"Année!W$10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!V$5","v":0},{"$f":"Année!$AA$10","v":100}]
[{"$f":"ROW()","v":44},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!W$5&Année!$B$12","v":"Remboursements "},{"$f":"Année!W$17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!V$5","v":0},{"$f":"Année!$AA$17","v":240}]
[{"$f":"ROW()","v":45},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!W$5&Année!$B$19","v":"Charges sociales (part employeur) "},{"$f":"Année!W$33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!V$5","v":0},{"$f":"Année!$AA$33","v":101}]
[{"$f":"ROW()","v":46},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!W$5&Année!$B$35","v":"Vacations "},{"$f":"Année!W$39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!V$5","v":0},{"$f":"Année!$AA$39","v":103}]
[{"$f":"ROW()","v":47},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!W$5&Année!$B$41","v":"Divers "},{"$f":"Année!W$46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!V$5","v":0},{"$f":"Année!$AA$44","v":109}]
[{"$f":"ROW()","v":48},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Y5&Année!$B$5","v":"Salaire brut "},{"$f":"Année!Y$10","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!X$5","v":0},{"$f":"Année!$AA$10","v":100}]
[{"$f":"ROW()","v":49},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Y5&Année!$B$12","v":"Remboursements "},{"$f":"Année!Y$17","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!X$5","v":0},{"$f":"Année!$AA$17","v":240}]
[{"$f":"ROW()","v":50},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Y5&Année!$B$19","v":"Charges sociales (part employeur) "},{"$f":"Année!Y$33","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!X$5","v":0},{"$f":"Année!$AA$33","v":101}]
[{"$f":"ROW()","v":51},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Y5&Année!$B$35","v":"Vacations "},{"$f":"Année!Y$39","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!X$5","v":0},{"$f":"Année!$AA$39","v":103}]
[{"$f":"ROW()","v":52},{"$f":"\"31.12.\"&Année!$I$1:$I$1","v":"31.12."},null,"Tab frais pers",null,{"$f":"Année!Y5&Année!$B$41","v":"Divers "},{"$f":"Année!Y$46","v":0},{"$f":"Année!$I$2","v":0},"-",{"$f":"Année!X$5","v":0},{"$f":"Année!$AA$44","v":109}]