{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","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":"Feuil1","index":0,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,11,21,12],[25,4,25,5],[15,7,17,7],[9,8,10,8],[12,8,13,8],[15,8,16,8],[12,7,14,7],[19,12,19,14],[5,8,7,8],[3,7,4,8],[3,12,4,12],[5,7,8,7],[9,7,11,7],[3,9,3,11],[3,13,3,14],[5,14,8,14],[9,14,11,14],[12,14,14,14],[15,14,17,14]]}
[]
[null,null,null,null,null,null,null,"  2) Déclaration des chiffres d'affaires"]
[]
[null,null,null,null,null,null,null,"Années et options",null,"Chiffre d'affaires",null,null,"%","Revenu"]
[null,null,null,null,null,null,null,null,null,"Catégories","Réalisé","Annualisé",null,"Ventilé","Total"]
[null,null,null,null,null,null,null,2018,{"$f":"IF(Feuil2!D4<2016,\"CA annualisé\",\"CA déclaré\")","v":"CA annualisé"},"Ventes",null,{"$f":"IF(I9=\"oui\",(K6*365)/Feuil2!C6,\"\")","v":""},71,{"$f":"IF(L6=\"\",\"\",L6-((L6*M6)/100))","v":""},{"$f":"IF(Feuil2!D4=1900,\"\",SUM(N6:N9))","v":""}]
[null,null,null,null,null,null,null,null,null,"Prestations",null,{"$f":"IF(I9=\"oui\",(K7*365)/Feuil2!C6,\"\")","v":""},50,{"$f":"IF(L7=\"\",\"\",L7-((L7*M7)/100))","v":""}]
[null,null,null,null,null,null,null,null,null,"Libéral",null,{"$f":"IF(I9=\"oui\",(K8*365)/Feuil2!C6,\"\")","v":""},34,{"$f":"IF(L8=\"\",\"\",L8-((L8*M8)/100))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"NC",{"$f":"IF(I9=\"non\",E22,\"\")","v":""}]
[null,null,null,null,null,null,null,2017,"CA annualisé","Ventes",null,{"$f":"IF(I12=\"oui\",(K10*365)/Feuil2!C6,\"\")","v":""},71,{"$f":"IF(Feuil2!D4=1900,\"\",IF(AND(L10=\"\",I12=\"non\"),K10-((K10*M10)/100),L10-((L10*M10)/100)))","v":""},{"$f":"IF(OR(Feuil2!D4>=2017,E26=\"\"),\"\",SUM(N10:N12))","v":""}]
["A) Les chiffres nécessaires au calcul des prestations en espèces \"maternité",null,null,null,null,null,null,null,null,"Prestations",null,{"$f":"IF(I12=\"oui\",(K11*365)/Feuil2!C6,\"\")","v":""},50,{"$f":"IF(Feuil2!D4=1900,\"\",IF(AND(L11=\"\",I12=\"non\"),K11-((K11*M11)/100),L11-((L11*M11)/100)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Feuil2!D4=2017,\"oui\",\"non\")","v":"non"},"Libéral",null,{"$f":"IF(I12=\"oui\",(K12*365)/Feuil2!C6,\"\")","v":""},34,{"$f":"IF(Feuil2!D4=1900,\"\",IF(AND(L12=\"\",I12=\"non\"),K12-((K12*M12)/100),L12-((L12*M12)/100)))","v":""}]
["    1) Revenu moyen de référence",null,null,null,null,null,null,2016,"CA annualisé","Ventes",null,{"$f":"IF(I15=\"oui\",(K13*365)/Feuil2!C6,\"\")","v":""},71,{"$f":"IF(Feuil2!D4=1900,\"\",IF(AND(L13=\"\",I15=\"non\"),K13-((K13*M13)/100),L13-((L13*M13)/100)))","v":""},{"$f":"IF(OR(Feuil2!D4>=2017,E26=\"\"),\"\",SUM(N13:N15))","v":""}]
[null,"PASS 2015 ",38040,null,null,null,null,null,null,"Prestations",null,{"$f":"IF(I15=\"oui\",(K14*365)/Feuil2!C6,\"\")","v":""},50,{"$f":"IF(Feuil2!D4=1900,\"\",IF(AND(L14=\"\",I15=\"non\"),K14-((K14*M14)/100),L14-((L14*M14)/100)))","v":""}]
[null,"PASS 2016",38616,null,null,null,null,null,{"$f":"IF(Feuil2!D4=2016,\"oui\",\"non\")","v":"non"},"Libéral",null,{"$f":"IF(I15=\"oui\",(K15*365)/Feuil2!C6,\"\")","v":""},34,{"$f":"IF(Feuil2!D4=1900,\"\",IF(AND(L15=\"\",I15=\"non\"),K15-((K15*M15)/100),L15-((L15*M15)/100)))","v":""}]
[null,"PASS 2017",39228,null,null,null,null,2015,"CA annualisé","Ventes",null,{"$f":"IF(I18=\"oui\",(K16*365)/Feuil2!C6,\"\")","v":""},71,{"$f":"IF(Feuil2!D4=1900,\"\",IF(AND(L16=\"\",I18=\"non\"),K16-((K16*M16)/100),L16-((L16*M16)/100)))","v":""},{"$f":"IF(OR(Feuil2!D4>=2016,E26=\"\"),\"\",SUM(N16:N18))","v":""}]
[null,null,null,null,null,null,null,null,null,"Prestations",null,{"$f":"IF(I18=\"oui\",(K17*365)/Feuil2!C6,\"\")","v":""},50,{"$f":"IF(Feuil2!D4=1900,\"\",IF(AND(L17=\"\",I18=\"non\"),K17-((K17*M17)/100),L17-((L17*M17)/100)))","v":""}]
[null,"Revenu de référence en",null,2018,{"$f":"((SUM(C14:C16)/3)*10)/100","v":3862.8},null,null,null,{"$f":"IF(Feuil2!D4=2015,\"oui\",\"non\")","v":"non"},"Libéral",null,{"$f":"IF(I18=\"oui\",(K18*365)/Feuil2!C6,\"\")","v":""},34,{"$f":"IF(Feuil2!D4=1900,\"\",IF(AND(L18=\"\",I18=\"non\"),K18-((K18*M18)/100),L18-((L18*M18)/100)))","v":""}]
[]
["   2) Plafond Annuel de Sécurité sociale (PASS) - Année 2018",null,null,null,null,null,null,"C) Calcul du revenu annuel moyen de référence de la période",null,null,null,null,{"$f":"IF(Feuil2!D4=1900,\"\",IF(Feuil2!D4<=2015,\"2015 à 2017\",IF(Feuil2!D4=2016,\"2016 à 2017\",IF(Feuil2!D4=2017,\"2017\",IF(Feuil2!D4=2018,\"2018\",\"\")))))","v":""}]
[null,"Mensuel",3311]
[null,"Annuel",39732,0.1,{"$f":"(C22*10)/100","v":3973.2},null,null,null,null,null,null,{"$f":"IF(Feuil2!D4=1900,0,IF(Feuil2!D4<=2015,(O16+O13+O10)/3,IF(Feuil2!D4=2016,(O13+O10)/2,IF(Feuil2!D4=2017,O10,IF(Feuil2!D4=2018,O6,0)))))","v":0}]
[]
["B) Date de début d'activité et déclaration de chiffre d'affaires",null,null,null,null,null,null,"D) Droits Prestations en espèces \"Maternité\""]
[]
["  1) Saisir ici la date de début d'activité",null,null,null,null,null,null,"             Cliquez sur ce bouton"]

{"sheet":"Feuil2","index":1,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[71,null,{"$f":"EOMONTH(Feuil1!E26,0)","v":"1900-01-31"},{"$f":"Feuil1!E26","v":"00:00:00"}]
[50,null,{"$f":"C1","v":"1900-01-31"},{"$f":"IF(C3=31,(C2-D1)-1,C2-D1)","v":30},{"$f":"DATE(YEAR(C2),12,31)","v":"1900-12-31"},{"$f":"DATEDIF(D1,E2,\"d\")","v":366},33200,82800]
[34,null,{"$f":"DAY(DATE(YEAR(C2),MONTH(C2)+1,1)-1)","v":31},{"$f":"YEAR(C2)","v":1900},null,"dont",{"$f":"(G2*F2)/365","v":33290.95890410959},{"$f":"(H2*F2)/365","v":83026.849315068495}]
[null,null,{"$f":"MONTH(C2)","v":1},{"$f":"D3","v":1900}]
["oui",null,{"$f":"(12-C4)*30","v":330},{"$f":"D3-1","v":1899}]
["non",null,{"$f":"C5+D2","v":360}]
[null,null,{"$f":"Feuil1!N20","v":0}]

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