{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calcul","Taux","Feuil3"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":"Calcul","index":0,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10]]}
[]
[null,null,null,null,null,"Mode d'emploi du simulateur"]
[null,null,null,null,null," - Indiquez la date de début d'activité,"]
[null,null,null,null,null," - Choisissez votre type d'activité,"]
[null,null,null,null,null," - Cochez éventuellement lers options PFL et ACCRE,"]
[null,null,null,null,null," - Indiquez le ou les CA prévisionnels",null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-07-25"}]
[null,null,null,null,null," - Indiquez si vous exercez en Alsace ou en Moselle",null,null,null,null,null,null,{"$f":"DATE(YEAR(C8),12,31)","v":"2018-12-31"}]
["Date de début d'activité :",null,"2018-01-01",null,null," - Prenez connaissance du montant des charges en 2018",null,null,null,null,null,null,{"$f":"DATEDIF(C8,M7,\"d\")","v":364}]
[null,null,null,null,null,null,null,null,null,null,null,null,170000]
[null,null,null,null,null,null,null,null,null,null,null,null,70000]
[null,null,null,null,false,null,"En fonction de la date de début d'activité que vous avez indiquée,"]
[null,null,null,null,false,null,"votre chiffre d'affaires ne pourra pas dépasser en ",null,null,null,2018]
[null,null,null,null,null,null,{"$f":"IF(E11=TRUE,(M9*M8)/364,IF(E12=TRUE,(M10*M8)/364,IF(E14=TRUE,(M10*M8)/364,IF(E15=TRUE,(M10*M8)/364,\"\"))))","v":""},{"$f":"IF(AND(E11=TRUE,E12=TRUE),\"de ventes et de location de meublés dont\",IF(AND(E11=TRUE,E14=TRUE),\"de ventes et de location de meublés dont\",IF(AND(E11=TRUE,E15=TRUE),\"de ventes et location de meublés dont\",IF(E11=TRUE,\"de ventes et de location de meublés\",IF(E12=TRUE,\"de prestations de service artisanales\",IF(E14=TRUE,\"d'activité libérale relevant du RSI\",IF(E15=TRUE,\"d'activité libérale relevant de la CIPAV\",\"\")))))))","v":""},null,null,null,null,null,null,"Cotisations Sociales Ventes/Location Meublés",{"$f":"IF(E11=TRUE,J16,\"\")","v":""},{"$f":"IF(AND(E11=TRUE,Taux!C2=TRUE),Taux!D2,IF(AND(E11=TRUE,Taux!C2=FALSE),Taux!B2,\"\"))","v":""},{"$f":"IF(E11=TRUE,P13*Q13,\"\")","v":""}]
[null,null,null,null,false,null,{"$f":" IF(AND(E11=TRUE,E12=TRUE),(M10*M8)/364,IF(AND(E11=TRUE,E14=TRUE),(M10*M8)/364,IF(AND(E11=TRUE,E15=TRUE),(M10*M8)/364,\"\")))","v":""},{"$f":"IF(AND(E11=TRUE,E12=TRUE),\"de prestations de service artisanales\",IF(AND(E11=TRUE,E14=TRUE),\"d'activité libérale relevant du RSI\",IF(AND(E11=TRUE,E15=TRUE),\"d'activité libérale relevant de la CIPAV\",\"\")))","v":""},null,null,null,null,null,null,"Cotisations Sociales Prestations Artisanales",{"$f":"IF(E12=TRUE,J17,\"\")","v":""},{"$f":"IF(AND(E12=TRUE,Taux!C2=TRUE),Taux!D3,IF(AND(E12=TRUE,Taux!C2=FALSE),Taux!B3,\"\"))","v":""},{"$f":"IF(E12=TRUE,P14*Q14,\"\")","v":""}]
[null,null,null,null,false,null,"Indiquez ici le ou les chiffres d'affaires prévisionnels :",null,null,null,null,null,null,null,"Cotisations Sociales Activité Libérale SSI",{"$f":"IF(E14=TRUE,J18,\"\")","v":""},{"$f":"IF(AND(E14=TRUE,Taux!C2=TRUE),Taux!D4,IF(AND(E14=TRUE,Taux!C2=FALSE),Taux!B4,\"\"))","v":""},{"$f":"IF(E14=TRUE,P15*Q15,\"\")","v":""}]
[null,null,null,null,null,null,"1 - Ventes et location de meublés",null,null,0,null,null,{"$f":"IF(AND(N16=1,N20>0),M9-M10,J16)","v":0},{"$f":"IF(E11=TRUE,1,0)","v":0},"Cotisations sociales Activité libérale CIPAV",{"$f":"IF(E15=TRUE,J19,\"\")","v":""},{"$f":"IF(AND(E15=TRUE,Taux!C2=TRUE),Taux!D5,IF(AND(E15=TRUE,Taux!C2=FALSE),Taux!B5,\"\"))","v":""},{"$f":"IF(E15=TRUE,P16*Q16,\"\")","v":""}]
[null,null,null,null,null,null,"2 - Prestations de service art. ou com.",null,null,0,null,null,{"$f":"J17","v":0},{"$f":"IF(E12=TRUE,1,0)","v":0},"Versement libératoire Impôt Revenu BIC Vente",{"$f":"IF(AND(E11=TRUE,Taux!F2=TRUE),J16,\"\")","v":""},{"$f":"IF(AND(Taux!F2=TRUE,Calcul!E11=TRUE),Taux!G2,\"\")","v":""},{"$f":"IF(AND(Taux!F2=TRUE,Calcul!E11=TRUE),P17*Q17,\"\")","v":""}]
[null,null,null,null,null,null,"3 - Activités libérales relevant de la SSI",null,null,0,null,null,{"$f":"(J18)","v":0},{"$f":"IF(E14=TRUE,1,0)","v":0},"Versement libératoire Impôt Revenu BIC",{"$f":"IF(AND(E12=TRUE,Taux!F2=TRUE),J17,\"\")","v":""},{"$f":"IF(AND(Taux!F2=TRUE,Calcul!E12=TRUE),Taux!G3,\"\")","v":""},{"$f":"IF(AND(Taux!F2=TRUE,Calcul!E12=TRUE),P18*Q18,\"\")","v":""}]
[null,null,null,null,null,null,"4 - Activités libérales relevant de la CIPAV",null,null,0,null,null,{"$f":"(J19)","v":0},{"$f":"IF(E15=TRUE,1,0)","v":0},"Versement libératoire Impôt Revenu BNC",{"$f":"IF(AND(E14=TRUE,Taux!F2=TRUE),Taux!H4,IF(AND(E15=TRUE,Taux!F2=TRUE),Taux!H4,\"\"))","v":""},{"$f":"IF(AND(Taux!F2=TRUE,Calcul!E14),Taux!G4,IF(AND(Taux!F2=TRUE,Calcul!E15=TRUE),Taux!G4,\"\"))","v":""},{"$f":"IF(AND(Taux!F2=TRUE,Calcul!E14=TRUE), P19*Q19,IF(AND(Taux!F2=TRUE,Calcul!E15=TRUE),P19*Q19,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J17:K19)","v":0},{"$f":"SUM(N17:N19)","v":0},"Contribution Formation Professionnelle",{"$f":"IF(Taux!J5>0,Taux!J5,\"\")","v":""},null,{"$f":"IF(Taux!K5>0,Taux!K5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M16+M20","v":0},null,"Taxe pour Frais Chambre Consulaire",{"$f":"IF(E11=TRUE,J16,IF(E12=TRUE,J17,IF(AND(E11=TRUE,E12=TRUE),J16+J17,IF(E11=FALSE,\"\",IF(E12=FALSE,\"\",\"\")))))","v":""},null,{"$f":"IF(P21=\"\",\"\",Taux!S6)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J16+M20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Total",null,null,{"$f":"SUM(R13:R21)","v":0}]
[]
[]
["© UPSME Juillet 2018"]

{"sheet":"Taux","index":1,"n_rows":6,"n_cols":19,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,11,0,16],[0,17,1,17],[0,18,1,18]]}
["Montant","Social","Accre","Taux accre","Montant cotis","Option pfl","PFL 1","Base PFL","CFP","Base CFP","Montant CFP","TFCC",null,null,null,null,null,"Base TFCC","Montant"]
[{"$f":"Calcul!J16","v":0},0.128,true,3.2000000000000001E-2,{"$f":"IF(C2=TRUE,A2*D2,A2*B2)","v":0},true,0.01,{"$f":"A2","v":0},1E-3,{"$f":"A2","v":0},{"$f":"J2*I2","v":0},"Catégorie","Tx Normal","Option Als.","Alsace","Option Mo.","Moselle"]
[{"$f":"Calcul!J17","v":0},0.22,false,5.5E-2,{"$f":"IF(C2=TRUE,A3*D3,A3*B3)","v":0},null,1.7000000000000001E-2,{"$f":"A3","v":0},3.0000000000000001E-3,{"$f":"A3","v":0},{"$f":"J3*I3","v":0},"Ventes",1.4999999999999999E-4,false,1.4999999999999999E-4,false,1.4999999999999999E-4,{"$f":"A2","v":0},{"$f":"R3*M3","v":0}]
[{"$f":"Calcul!J18","v":0},0.22,null,5.5E-2,{"$f":"IF(C2=TRUE,A4*D4,A4*B4)","v":0},null,2.1999999999999999E-2,{"$f":"A4+A5","v":0},2E-3,{"$f":"A4+A5","v":0},{"$f":"J4*I4","v":0},"Prest. Art.",4.7999999999999996E-3,null,6.4999999999999997E-3,null,8.3000000000000001E-3,{"$f":"A3","v":0},{"$f":"IF(AND(N3=FALSE,P3=FALSE),R4*M4,IF(AND(P3=FALSE,N3=TRUE),R4*O4,IF(AND(P3=TRUE,N3=FALSE),R4*Q4,\"\")))","v":0}]
[{"$f":"Calcul!J19","v":0},0.22,null,5.5E-2,{"$f":"IF(C2=TRUE,A5*D5,A5*B5)","v":0},null,2.1999999999999999E-2,null,2E-3,{"$f":"SUM(J2:J4)","v":0},{"$f":"SUM(K2:K4)","v":0},"Achat/Vente",2.2000000000000001E-3,null,2.8999999999999998E-3,null,3.7000000000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R3:R5)","v":0},{"$f":"SUM(S3:S5)","v":0}]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}