{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["charges sociales","Détails","STATISTIQUES MENSUELLES","entrée-sortie"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":102,"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":"charges sociales","index":0,"n_rows":84,"n_cols":33,"rows_kept":84,"cut":false,"hidden":false,"merged":[[70,5,74,5],[56,1,56,5],[77,1,77,5],[5,2,7,2],[47,5,51,5],[1,1,1,5],[3,1,4,1],[3,2,3,3],[3,4,4,4],[3,5,4,5]]}
[]
[null,"Tableau général des charges sociales"]
[]
[null,"CHARGES","TAUX",null,"TOTAL","Assiette"]
[null,null,"EMPLOYEUR","SALARIE"]
[null,"1.  CSG - non déductible (1)",null,2.4E-2,2.4E-2,"(Rémunération brute totale X 98,25 %) + cotisation patronale prévoyance 0,91 %"]
[null,"CSG - déductible",null,5.0999999999999997E-2,5.0999999999999997E-2]
[null,"2.  CRDS - non déductible",null,5.0000000000000001E-3,5.0000000000000001E-3]
[null,"3.  CONTRIBUTION SOLIDARITE AUTONOMIE",3.0000000000000001E-3,null,3.0000000000000001E-3,"Rémunération totale"]
[null,"4.  SECURITE SOCIALE (2)"]
[null,"▶ Assurance maladie, maternité, décès : - ensemble des départements"]
[null,"- Moselle, Bas-Rhin, Haut-Rhin",0.13100000000000001,2.2499999999999999E-2,{"$f":"SUM(C12:D12)","v":0.1535},"Rémunération totale"]
[null,"▶ Assurance vieillesse - plafonnée",8.4000000000000005E-2,6.7500000000000004E-2,{"$f":"SUM(C13:D13)","v":0.15150000000000002},"< 3086"]
[null,"▶ Assurance vieillesse - déplafonnée",1.6E-2,1E-3,{"$f":"SUM(C14:D14)","v":1.7000000000000001E-2},"Rémunération totale "]
[null,"▶ Allocations familiales",5.3999999999999999E-2,null,{"$f":"SUM(C15:D15)","v":5.3999999999999999E-2},"Rémunération totale "]
[null,"▶ Accidents du travail :",1.6E-2,0,{"$f":"SUM(C16:D16)","v":1.6E-2},"Rémunération totale "]
[null,"5.  RETRAITE COMPLEMENTAIRE"]
[null,"cadre et non cadre CBTP (AFPA)",5.2499999999999998E-2,4.7500000000000001E-2,{"$f":"SUM(C18:D18)","v":0.1},"Rémunération totale "]
[null,"▶ AGFF (cotisation à l'association de gestion du fonds de financement de l'AGIRC et de l'ARRCO)"]
[null,"  cadres et Non-cadres Tranche 1 (T1) ou A",1.2E-2,8.0000000000000002E-3,{"$f":"+SUM(C20:D20)","v":0.02},"0-3086"]
[null,"  cadres et Non-cadres Tranche 2 (T2) ou B",1.2999999999999999E-2,8.9999999999999993E-3,{"$f":"+SUM(C21:D21)","v":2.1999999999999999E-2},"de 3 086 € à 12 344 €"]
[null,"6.  PREVOYANCE (APGIS)"]
[null,"Tranche A",1.7160000000000002E-2,9.2399999999999999E-3,{"$f":"SUM(C23:D23)","v":2.64E-2},3086]
[null,"Tranche B",2.2689999999999998E-2,1.711E-2,{"$f":"SUM(C24:D24)","v":3.9800000000000002E-2},12344]
[null,"7.   TAXE PREVOYANCE (contributions patronales de prévoyance)",0.08,null,0.08,"Montant des contributions patronales de prévoyance"]
[null,"8.   CHOMAGE-EMPLOI"]
[null,"▶ Assurance chômage",0.04,2.4E-2,{"$f":"SUM(C27:D27)","v":6.4000000000000001E-2},"<12344"]
[null,"▶ Fonds de garantie des salaires (AGS)",3.0000000000000001E-3,null,{"$f":"SUM(C28:D28)","v":3.0000000000000001E-3},"<12344"]
[null,"▶ APEC (cadres) tranches A et B",3.6000000000000002E-4,2.4000000000000001E-4,{"$f":"SUM(C29:D29)","v":6.0000000000000006E-4},"de 0 à 12 344 €"]
[null,"9.  CONSTRUCTION-LOGEMENT"]
[null,"▶ cotisation de base",1E-3,0,{"$f":"SUM(C31:D31)","v":1E-3},"0-3086"]
[null,"▶ Participation des employeurs à la construction ( plus de 20 salariés)"]
[null,"+ cotisation supplémentaire pour les cabinets de 20 salariés et plus :",4.0000000000000001E-3,0,4.0000000000000001E-3,"0-3086"]
[null,"+ cotisation supplémentaire pour les cabinets de 20 salariés et plus :",1E-3,0,1E-3,"à partir de 3 086 €"]
[null,"10. FORMATION PROFESSIONNELLE (OPCA-PL) "]
[null,"▶ moins de 10 salariés",5.4999999999999997E-3,0,{"$f":"+SUM(C36:D36)","v":5.4999999999999997E-3},"Rémunération totale"]
[null,"▶ de 10 à 19 salariés",1.0500000000000001E-2,0,1.0500000000000001E-2,"Rémunération totale"]
[null,"▶ 20 salariés et plus",1.6E-2,0,1.6E-2,"Rémunération totale"]
[null,"11. ▶ Participation supplémentaire formation continue CIF/CDD",0.01,0,0.01,"Rémunération des salariés sous CDD *"]
[null,"12. Contribution au développement de l'apprentissage",1.8E-3,0,1.8E-3,"Rémunération totale"]
[null,"13.Taxe d'apprentissage (alsace-moselle)",2.5999999999999999E-3,0,2.5999999999999999E-3,"Rémunération totale"]
[null,"14. Participation construction (>20 salariés)",4.4999999999999997E-3,0,4.4999999999999997E-3,"Rémunération totale"]
[null,"15. TAXE SUR LES SALAIRES",4.2500000000000003E-2,0,4.2500000000000003E-2,7604]
[null,"(Entreprises non assujettis à la TVA)",8.5000000000000006E-2,0,8.5000000000000006E-2,15185]
[null,"(assiette annuelle)",0.13600000000000001,0,0.13600000000000001,150000]
[null,null,0.2,0,0.2,"1 50 000"]
[null,"16.Versement transport (entreprise > 9 salariés)"]
[null,"strasbourg",0.02,0,{"$f":"SUM(C48:D48)","v":0.02},"Totalité du salaire"]
[null,"Mulhouse",1.7999999999999999E-2,0,{"$f":"SUM(C49:D49)","v":1.7999999999999999E-2}]
[null,"colmar",6.0000000000000001E-3,0,{"$f":"SUM(C50:D50)","v":6.0000000000000001E-3}]
[null,"Cernay",0,0,{"$f":"SUM(C51:D51)","v":0}]
[null,"Soulce",0,0,{"$f":"SUM(C52:D52)","v":0}]
[]
[]
[]
[]
[null,"U.R.S.S.A.F"]
[null,"- Moselle, Bas-Rhin, Haut-Rhin",0.128,null,null,"Rémunération totale"]
[null,"▶ Assurance vieillesse - plafonnée",8.4000000000000005E-2,null,null,"< 3086"]
[null,"▶ Assurance vieillesse - déplafonnée",1.6E-2,null,null,"Rémunération totale "]
[null,"▶ Allocations familiales",5.3999999999999999E-2,null,null,"Rémunération totale "]
[null,"▶ Accidents du travail :",0.03,null,null,"Rémunération totale "]
[null,"9.  CONSTRUCTION-LOGEMENT"]
[null,"▶ cotisation de base",1E-3,0,{"$f":"SUM(C64:D64)","v":1E-3},"0-3086"]
[null,"▶ Participation des employeurs à la construction ( plus de 20 salariés)"]
[null,"+ cotisation supplémentaire pour les cabinets de 20 salariés et plus :",4.0000000000000001E-3,0,4.0000000000000001E-3,"0-3086"]
[null,"+ cotisation supplémentaire pour les cabinets de 20 salariés et plus :",1E-3,0,1E-3,"à partir de 3 086 €"]
[null,"3.  CONTRIBUTION SOLIDARITE AUTONOMIE",3.0000000000000001E-3,null,3.0000000000000001E-3,"Rémunération totale"]
[null,"▶ Accidents du travail :",0.03,0,{"$f":"SUM(C69:D69)","v":0.03},"Rémunération totale "]
[null,"16.Versement transport (entreprise > 9 salariés)"]
[null,"strasbourg",0.02,0,{"$f":"SUM(C71:D71)","v":0.02},"Totalité du salaire"]
[null,"Mulhouse",1.7999999999999999E-2,0,{"$f":"SUM(C72:D72)","v":1.7999999999999999E-2}]
[null,"colmar",6.0000000000000001E-3,0,{"$f":"SUM(C73:D73)","v":6.0000000000000001E-3}]
[null,"Cernay",0,0,{"$f":"SUM(C74:D74)","v":0}]
[null,"Soulce",0,0,{"$f":"SUM(C75:D75)","v":0}]
[null,"7.   TAXE PREVOYANCE (contributions patronales de prévoyance)",0.08,null,0.08,"Montant des contributions patronales de prévoyance"]
[]
[null,"ASSEDIC"]
[null,"▶ Assurance chômage",0.04,2.4E-2,{"$f":"SUM(C79:D79)","v":6.4000000000000001E-2},"<12344"]
[null,"▶ Fonds de garantie des salaires (AGS)",3.0000000000000001E-3,null,{"$f":"SUM(C80:D80)","v":3.0000000000000001E-3},"<12344"]
[]
[]
[null,"salaire brut","salaire brut","salaire brut","salaire brut","salaire brut","salaire brut","salaire brut","salaire brut","salaire brut","Tranche A","Tranche B","    Tranche A et B","tranche A et B ","salaire brut","salaire brut","la base est égale au plafond S.S. si salaire brut > plafond S.S., sinon = salaire brut","A+B+C",null,"salaire brut","salaire brut","salaire brut","salaire brut",null,null,null,7604,15185,150000,150000,null,"NET IMPOSABLE","La base est égale au salaire brut augmenté des cotisations patronales de prévoyance (G45), le tout multiplié par 97% "]
[null,0.13100000000000001,0.03,5.3999999999999999E-2,1.6E-2,8.4000000000000005E-2,0.01,3.0000000000000001E-3,1E-3,4.0000000000000001E-3,1.7160000000000002E-2,2.2689999999999998E-2,0.04,3.0000000000000001E-3,5.2499999999999998E-2,1.2E-2,1.2999999999999999E-2,2.2000000000000001E-3,3.6000000000000002E-4,1.8E-3,2.5999999999999999E-3,1.6E-2,4.4999999999999997E-3,"Total charges","Total","total base csg",{"$f":"4.25%/12","v":3.5416666666666669E-3},{"$f":"8.5%/12","v":7.0833333333333338E-3},{"$f":"13.6%/12","v":1.1333333333333334E-2},{"$f":"20%/12","v":1.6666666666666666E-2}]

{"sheet":"Détails","index":1,"n_rows":13,"n_cols":92,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["année"]
[2013]
["mois"]
[1]
["jour"]
["2013-03-01","date",{"$f":"DATE(A3,A5,TEXT(A7,\"j\"))","v":"2013-01-01"}]
[]
[]
["Matricule","Nom usuel","Prénom","Sexe","CNC","Date nai.","Date de retraite (64ans)","Retraite","N° SS","Régime SS","Libellé régime SS","Centre rés.","Centre coût","Centre de coût","Type contrat","Date début période d'essai","Date fin période d'essai","Date fin renouvellement période d'essai","Date début contrat","Date fin init.","Date de prolongation contrat","Motif recours contrat","Libellé motif recours","Date entrée","Motif entrée","Libellé motif entrée","Motif de situation","Libellé motif de situation","Date sortie","Motif sortie","Libellé motif sortie","Date ancienneté","ancienneté","ancienneté en année(arr sup)","Horaire","Date effet ho.","Motif absence","Libellé motif absence","Suspension co.","Date début suspension","Date fin suspension","Dossier paie","AIB du mois","ETP rémunéré","AIB réel","AIB temps plein","Prime exp.","Garantie du net","13 ème mois","Indemnité de fin de carrière","Salaire brut","Brut","A","B","C","E","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","Somme","Total","BASE","TAXE ","TAXE","TAXE ","TAXE 4","z","somme","MS ",null,"Charges","IJSS nettes","IJSS brutes","IJ prévoyance","indemnités de licenciement/fin contrat","indemnité de précarité","Indemnités journalières de congés payés"]
["15635","Nom1","Prénom 1",1,"Cadre","1949-08-06",{"$f":"EDATE(F11,64*12)","v":"2013-08-06"},{"$f":"IF(Détails!$O11=\"DD\",\"\",IF(AND(YEAR(G11)<=$A$3,Détails!$O11=\"DI\",$A$5=(MONTH(G11)-1)),\"retraite ce mois\",\"actif\"))","v":"actif"},"56915popo365",1,"NON COTISANT",1,67000,{"$f":"VALUE(M11)","v":67000},"DI",null,null,null,"1997-09-01",null,null,null,null,"1992-07-01",1,"Nouvelle entrée",1,"Entrée CDI ou CDD",null,null,null,"1992-08-01",{"$f":"DATEDIF(AF11,TODAY(),\"y\")&\" ans \"&DATEDIF(AF11,TODAY(),\"ym\")&\" mois \"&DATEDIF(AF11,TODAY(),\"md\")&\" jours \"","v":"20 ans 9 mois 1 jours "},{"$f":"(ROUNDUP((TODAY()-AF11)/365.25*4,0))/4","v":21},35,"2000-01-01",null,null,0,null,null,1,5069.6099999999997,1,35000,35000,0,null,{"$f":"IF(OR($A$5=3,$A$5=6,$A$5=9,$A$5=12),SUM(AS11,#REF!,AU11)/4,0)","v":0},{"$f":"IF(OR(H11=\"actif\",H11=\"\"),0,MAX((13*AH11*(SUM(AQ11,AU11))/60),(13*(SUM(AQ11,#REF!,AU11))/4)))","v":0},{"$f":"AZ11+AW11","v":8000},8000,{"$f":"AY11*'charges sociales'!$B$84","v":1048},{"$f":"AY11*'charges sociales'!$C$84","v":240},{"$f":"$AY11*'charges sociales'!D$84","v":432},{"$f":"IF($AY11>trancheA,($AY11-trancheA)*'charges sociales'!E$84,0)","v":78.623999999999995},{"$f":"IF($AY11<trancheA,$AY11*'charges sociales'!F$84,trancheA*'charges sociales'!F$84)","v":259.22399999999999},{"$f":"IF(OR(N11=67000,N11=67010),$AY11*2%,IF(N11=68012,$AY11*1.8%,$AY11*0.6%))","v":160},{"$f":"$AY11*'charges sociales'!H$84","v":24},{"$f":"$AY11*'charges sociales'!I$84","v":8},{"$f":"$AY11*'charges sociales'!J$84","v":32},{"$f":"IF(AY11>trancheA, trancheA*prévoyance1,AY11*prévoyance1)","v":52.955760000000005},{"$f":"IF(AY11>trancheA,(AY11-trancheA)*prévoyance2,0)","v":111.49865999999999},{"$f":"IF($AY11<12124,$AY11*'charges sociales'!M$84,'charges sociales'!M$84*12124)","v":320},{"$f":"IF($AY11<TrancheB,$AY11*'charges sociales'!N$84,'charges sociales'!N$84*TrancheB)","v":24},{"$f":"$AY11*'charges sociales'!O$84","v":420},{"$f":"IF($AY11>trancheA, trancheA*retraite1,$AY11*retraite1)","v":37.032000000000004},{"$f":"IF($AY11>trancheA,(AY11-trancheA)*retraite2,0)","v":63.881999999999998},{"$f":"$AY11*'charges sociales'!R$84","v":17.600000000000001},{"$f":"$AY11*'charges sociales'!S$84","v":2.8800000000000003},{"$f":"$AY11*'charges sociales'!T$84","v":14.4},{"$f":"$AY11*'charges sociales'!U$84","v":20.8},{"$f":"$AY11*'charges sociales'!V$84","v":128},{"$f":"$AY11*'charges sociales'!W$84","v":36},{"$f":"SUM(BA11:BV11)","v":3530.8964200000005},{"$f":"SUM(BW11,AY11)","v":11530.896420000001},{"$f":"AY11+BJ11+BK11","v":8164.45442},{"$f":"IF($BY11*12<'charges sociales'!AA$83,($BY11*'charges sociales'!AA$84),'charges sociales'!AA$83*'charges sociales'!AA$84)","v":26.930833333333336},{"$f":"IF($BY11*12>'charges sociales'!AB$83,('charges sociales'!AB$83-'charges sociales'!AA$83)*'charges sociales'!AB$84,IF(AND($BY11*12<'charges sociales'!AB$83,$BY11*12>'charges sociales'!AA$83),($BY11*12-'charges sociales'!AA$83)*'charges sociales'!AB$84,0))","v":53.698750000000004},{"$f":"IF(AND($BY11*12>'charges sociales'!$F$44,$BY11*12<'charges sociales'!$F$45),($BY11*12-'charges sociales'!$F$44)*taxe3/12,IF($BY11*12>'charges sociales'!$F$45,(('charges sociales'!$F$45-'charges sociales'!$F$44)*taxe3/12),0))","v":938.26913445333332},{"$f":"IF($BY11*12>'charges sociales'!AD$83,($BY11*12-'charges sociales'!AC$83)*'charges sociales'!AD$84,('charges sociales'!AD$83-'charges sociales'!AC$83)*'charges sociales'!AD$84)","v":0},{"$f":"8%*SUM(BJ11:BK11)","v":13.156353600000001},{"$f":"SUM(BW11,BZ11:CD11)","v":4562.9514913866678},{"$f":"SUM(CE11,AY11,CM11)-(CK11+CL11)","v":12562.951491386668},{"$f":"(AY11+BJ11+BK11)*0.97","v":7919.5207873999998},-2715.55,320,350,0]
[1536,"Nom2","Prénom 2",1,"non Cadre","1949-02-01","2013-02-01",{"$f":"IF(Détails!$O12=\"DD\",\"\",IF(AND(YEAR(G12)<=$A$3,Détails!$O12=\"DI\",$A$5=(MONTH(G12)-1)),\"retraite ce mois\",\"actif\"))","v":"retraite ce mois"},"8962popo",1,"général",null,67200,{"$f":"VALUE(M12)","v":67200},"DI",null,null,null,null,null,null,null,null,null,null,null,1,"Entrée CDI ou CDD",null,null,null,"1988-08-02","24 ans 9 mois 0 jours ",24.75,35,"1988-01-02",null,null,null,null,null,2,4000,1,4000,4000,150,0,{"$f":"IF(OR($A$5=3,$A$5=6,$A$5=9,$A$5=12),SUM(AS12,#REF!,AU12)/4,0)","v":0},{"$f":"IF(OR(H12=\"actif\",H12=\"\"),0,MAX((13*AH12*(SUM(AQ12,AU12))/60),(13*(SUM(AQ12,AU12))/4)))","v":22254.375},7000,7000,null,{"$f":"AY12*'charges sociales'!$C$84","v":210},{"$f":"$AY12*'charges sociales'!D$84","v":378},{"$f":"IF($AY12>trancheA,($AY12-trancheA)*'charges sociales'!E$84,0)","v":62.624000000000002},{"$f":"IF($AY12<trancheA,$AY12*'charges sociales'!F$84,trancheA*'charges sociales'!F$84)","v":259.22399999999999},{"$f":"IF(OR(N12=67000,N12=67010),$AY12*2%,IF(N12=68012,$AY12*1.8%,$AY12*0.6%))","v":42},{"$f":"$AY12*'charges sociales'!H$84","v":21},{"$f":"$AY12*'charges sociales'!I$84","v":7},{"$f":"$AY12*'charges sociales'!J$84","v":28},{"$f":"IF(AY12>trancheA, trancheA*prévoyance1,AY12*prévoyance1)","v":52.955760000000005},{"$f":"IF(AY12>trancheA,(AY12-trancheA)*prévoyance2,0)","v":88.808659999999989},{"$f":"IF($AY12<12124,$AY12*'charges sociales'!M$84,'charges sociales'!M$84*12124)","v":280},{"$f":"IF($AY12<TrancheB,$AY12*'charges sociales'!N$84,'charges sociales'!N$84*TrancheB)","v":21},{"$f":"$AY12*'charges sociales'!O$84","v":367.5},{"$f":"IF($AY12>trancheA, trancheA*retraite1,$AY12*retraite1)","v":37.032000000000004},{"$f":"IF($AY12>trancheA,(AY12-trancheA)*retraite2,0)","v":50.881999999999998},{"$f":"$AY12*'charges sociales'!R$84","v":15.4},{"$f":"$AY12*'charges sociales'!S$84","v":2.52},{"$f":"$AY12*'charges sociales'!T$84","v":12.6},{"$f":"$AY12*'charges sociales'!U$84","v":18.2},{"$f":"$AY12*'charges sociales'!V$84","v":112},{"$f":"$AY12*'charges sociales'!W$84","v":31.499999999999996},{"$f":"SUM(BA12:BV12)","v":2098.2464199999999},{"$f":"SUM(BW12,AY12)","v":9098.2464199999995},{"$f":"AY12+BJ12+BK12","v":7141.7644199999995},{"$f":"IF($BY12*12<'charges sociales'!AA$83,($BY12*'charges sociales'!AA$84),'charges sociales'!AA$83*'charges sociales'!AA$84)","v":26.930833333333336},{"$f":"IF($BY12*12>'charges sociales'!AB$83,('charges sociales'!AB$83-'charges sociales'!AA$83)*'charges sociales'!AB$84,IF(AND($BY12*12<'charges sociales'!AB$83,$BY12*12>'charges sociales'!AA$83),($BY12*12-'charges sociales'!AA$83)*'charges sociales'!AB$84,0))","v":53.698750000000004},{"$f":"IF(AND($BY12*12>'charges sociales'!$F$44,$BY12*12<'charges sociales'!$F$45),($BY12*12-'charges sociales'!$F$44)*taxe3/12,IF($BY12*12>'charges sociales'!$F$45,(('charges sociales'!$F$45-'charges sociales'!$F$44)*taxe3/12),0))","v":799.18329445333336},{"$f":"IF($BY12*12>'charges sociales'!AD$83,($BY12*12-'charges sociales'!AC$83)*'charges sociales'!AD$84,('charges sociales'!AD$83-'charges sociales'!AC$83)*'charges sociales'!AD$84)","v":0},{"$f":"8%*SUM(BJ12:BK12)","v":11.3411536},{"$f":"SUM(BW12,BZ12:CD12)","v":2989.4004513866666},{"$f":"SUM(CE12,AY12,CM12)-(CK12+CL12)","v":9989.4004513866676},{"$f":"(AY12+BJ12+BK12)*0.97","v":6927.5114873999992},-2715.55,340,0,0]
[1537,"Nom3","Prénom 3",2,"non Cadre","1970-02-02",{"$f":"EDATE(F13,64*12)","v":"2034-02-02"},{"$f":"IF(Détails!$O13=\"DD\",\"\",IF(AND(YEAR(G13)<=$A$3,Détails!$O13=\"DI\",$A$5=(MONTH(G13)-1)),\"retraite ce mois\",\"actif\"))","v":"actif"},15636589,2,"général",null,67200,{"$f":"VALUE(M13)","v":67200},"DI",null,null,null,null,null,null,null,null,"1987-05-01",null,null,1,"Entrée CDI ou CDD","2013-03-01","licenciement","lic convntionné","1987-08-03",{"$f":"DATEDIF(AF13,TODAY(),\"y\")&\" ans \"&DATEDIF(AF13,TODAY(),\"ym\")&\" mois \"&DATEDIF(AF13,TODAY(),\"md\")&\" jours \"","v":"25 ans 8 mois 29 jours "},{"$f":"(ROUNDUP((TODAY()-AF13)/365.25*4,0))/4","v":25.75},36,"1988-01-03",null,null,null,null,null,2,3500,1,3500,3500,150,0,{"$f":"IF(OR($A$5=3,$A$5=6,$A$5=9,$A$5=12),SUM(AS13,#REF!,AU13)/4,0)","v":0},{"$f":"IF(OR(H13=\"actif\",H13=\"\"),0,MAX((13*AH13*(SUM(AQ13,AU13))/60),(13*(SUM(AQ13,AU13))/4)))","v":0},4000,4000,null,{"$f":"AY13*'charges sociales'!$C$84","v":120},{"$f":"$AY13*'charges sociales'!D$84","v":216},{"$f":"IF($AY13>trancheA,($AY13-trancheA)*'charges sociales'!E$84,0)","v":14.624000000000001},{"$f":"IF($AY13<trancheA,$AY13*'charges sociales'!F$84,trancheA*'charges sociales'!F$84)","v":259.22399999999999},{"$f":"IF(OR(N13=67000,N13=67010),$AY13*2%,IF(N13=68012,$AY13*1.8%,$AY13*0.6%))","v":24},{"$f":"$AY13*'charges sociales'!H$84","v":12},{"$f":"$AY13*'charges sociales'!I$84","v":4},{"$f":"$AY13*'charges sociales'!J$84","v":16},{"$f":"IF(AY13>trancheA, trancheA*prévoyance1,AY13*prévoyance1)","v":52.955760000000005},{"$f":"IF(AY13>trancheA,(AY13-trancheA)*prévoyance2,0)","v":20.738659999999999},{"$f":"IF($AY13<12124,$AY13*'charges sociales'!M$84,'charges sociales'!M$84*12124)","v":160},{"$f":"IF($AY13<TrancheB,$AY13*'charges sociales'!N$84,'charges sociales'!N$84*TrancheB)","v":12},{"$f":"$AY13*'charges sociales'!O$84","v":210},{"$f":"IF($AY13>trancheA, trancheA*retraite1,$AY13*retraite1)","v":37.032000000000004},{"$f":"IF($AY13>trancheA,(AY13-trancheA)*retraite2,0)","v":11.882},{"$f":"$AY13*'charges sociales'!R$84","v":8.8000000000000007},{"$f":"$AY13*'charges sociales'!S$84","v":1.4400000000000002},{"$f":"$AY13*'charges sociales'!T$84","v":7.2},{"$f":"$AY13*'charges sociales'!U$84","v":10.4},{"$f":"$AY13*'charges sociales'!V$84","v":64},{"$f":"$AY13*'charges sociales'!W$84","v":18},{"$f":"SUM(BA13:BV13)","v":1280.2964200000001},{"$f":"SUM(BW13,AY13)","v":5280.2964200000006},{"$f":"AY13+BJ13+BK13","v":4073.6944199999998},{"$f":"IF($BY13*12<'charges sociales'!AA$83,($BY13*'charges sociales'!AA$84),'charges sociales'!AA$83*'charges sociales'!AA$84)","v":26.930833333333336},{"$f":"IF($BY13*12>'charges sociales'!AB$83,('charges sociales'!AB$83-'charges sociales'!AA$83)*'charges sociales'!AB$84,IF(AND($BY13*12<'charges sociales'!AB$83,$BY13*12>'charges sociales'!AA$83),($BY13*12-'charges sociales'!AA$83)*'charges sociales'!AB$84,0))","v":53.698750000000004},{"$f":"IF(AND($BY13*12>'charges sociales'!$F$44,$BY13*12<'charges sociales'!$F$45),($BY13*12-'charges sociales'!$F$44)*taxe3/12,IF($BY13*12>'charges sociales'!$F$45,(('charges sociales'!$F$45-'charges sociales'!$F$44)*taxe3/12),0))","v":381.92577445333336},{"$f":"IF($BY13*12>'charges sociales'!AD$83,($BY13*12-'charges sociales'!AC$83)*'charges sociales'!AD$84,('charges sociales'!AD$83-'charges sociales'!AC$83)*'charges sociales'!AD$84)","v":0},{"$f":"8%*SUM(BJ13:BK13)","v":5.8955536000000004},{"$f":"SUM(BW13,BZ13:CD13)","v":1748.7473313866669},{"$f":"SUM(CE13,AY13,CM13)-(CK13+CL13)","v":5488.7473313866667},{"$f":"(AY13+BJ13+BK13)*0.97","v":3951.4835873999996},-2715.55,0,0,260]

{"sheet":"STATISTIQUES MENSUELLES","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Mois","Budgété","Realisé","Ecart","Reprévision"]
[null,"Janvier",{"$f":"IF(Détails!$A$5=1,Détails!#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"C3-D3","v":{"$error":"#REF!"}}]
[null,"Février",{"$f":"IF(Détails!$A$5=2,Détails!#REF!,0)","v":0},null,{"$f":"C4-D4","v":0}]
[null,"Mars",{"$f":"IF(Détails!$A$5=3,Détails!#REF!,0)","v":0},null,0]
[null,"Avril",{"$f":"IF(Détails!A5=4,Détails!#REF!,0)","v":0},null,0]
[null,"Mai",{"$f":"IF(Détails!$A$5=5,Détails!#REF!,0)","v":0},null,0]
[null,"Juin",{"$f":"IF(Détails!$A$5=6,Détails!#REF!,0)","v":0},null,0]
[null,"Juillet",{"$f":"IF(Détails!$A$5=7,Détails!#REF!,0)","v":0},null,0]
[null,"Août",{"$f":"IF(Détails!A9=8,Détails!#REF!,0)","v":0},null,0]
[null,"Septembre",{"$f":"IF(Détails!$A$5=9,Détails!#REF!,0)","v":0},null,0]
[null,"Octobre",{"$f":"IF(Détails!$A$5=10,Détails!#REF!,0)","v":0},null,0]
[null,"Novembre",{"$f":"IF(Détails!$A$5=11,Détails!#REF!,0)","v":0},null,0]
[null,"Décembre",{"$f":"IF(Détails!$A$5=12,Détails!#REF!,0)","v":0},null,0]
[null,"TOTAL n"]

{"sheet":"entrée-sortie","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Entrants","Nom","prénom","etp","AIB","Date d'entrée","motif"]
[null,"xxxx","xxxx",1,2532.36,"2013-05-12","recrutement"]
[null,"yyyy","yyyy",1,25632,"2013-05-13","remplacement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["sortants","Nom","prénom","etp","AIB","Date de sortie","Motif"]
[null,"xxxx","xxxx",1,2532.36,"2013-05-12","licenciement"]
[null,"Nom_Usuel_172","Prénom_172",1,4000,"2013-01-31","retraite"]