{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Feuille 1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Feuille 1","index":0,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,4,0,8],[2,1,2,8],[14,3,15,3],[14,5,15,5],[14,7,15,7],[17,3,18,3],[17,5,18,5],[36,7,37,7],[40,1,40,8],[41,1,41,8],[42,1,42,8],[17,7,18,7],[21,1,21,8],[33,3,34,3],[33,5,34,5],[33,7,34,7],[36,3,37,3],[36,5,37,5]]}
[{"$nulls":4},"Seules les cases jaunes sont modifiables"]
[]
[null,"CALCULER VOTRE REVENU A PARTIR DU PRIX DE VENTE"]
[]
[{"$nulls":4},"TVA",null,"TVA",null,"TVA"]
[{"$nulls":4},0.2,null,0.055,null,"-"]
[null,"Prix de vente TTC",null,null,10.0,null,10.0,null,10.0]
[null,"Prix de vente HT (Hors Taxes)",null,null,{"$f":"E7/(1+$E$6)","v":8.333333333},null,{"$f":"G7/(1+$G$6)","v":9.478672986},null,{"$f":"I7","v":10}]
[null,"Frais de service Responsable de Ruche (Hors Taxes)",0.1115,null,{"$f":"ROUND(E8*$C$9,2)","v":0.93},null,{"$f":"ROUND(G8*$C$9,2)","v":1.06},null,{"$f":"ROUND(I8*$C$9,2)","v":1.12}]
[null,"Frais de service Equanum SAS (1) (Hors Taxes)",0.1115,null,{"$f":"ROUND(E8*$C$10,2)","v":0.93},null,{"$f":"ROUND(G8*$C$10,2)","v":1.06},null,{"$f":"ROUND(I8*$C$10,2)","v":1.12}]
[null,"Frais de location Gare SNCF",0.017,null,{"$f":"ROUND(E8*$C$11,2)","v":0.14},null,{"$f":"ROUND(G8*$C$11,2)","v":0.16},null,{"$f":"ROUND(I8*$C$11,2)","v":0.17}]
[null,"Votre revenu HT (Hors Taxes)",null,null,{"$f":"E8-E9-E10-E11","v":6.333333333},null,{"$f":"G8-G9-G10-G11","v":7.198672986},null,{"$f":"I8-I9-I10-I11","v":7.59}]
[]
[null,"TVA récoltée",null,null,{"$f":"E7-E8","v":1.666666667},null,{"$f":"G7-G8","v":0.5213270142},null,{"$f":"I7-I8","v":0}]
[null,"TVA facturée par Equanum SAS + SNCF (2)",null,"ou",{"$f":"ROUND((E10+E11)*$E$6,2)","v":0.21},"ou",{"$f":"ROUND((G10+G11)*$E$6,2)","v":0.24},"ou",{"$f":"ROUND((I10+I11)*$E$6,2)","v":0.26}]
[null,"TVA facturée par le Responsable de Ruche, Equanum SAS + SNCF (2)",null,null,{"$f":"(E9*$E$6)+E15","v":0.396},null,{"$f":"(G9*$E$6)+G15","v":0.452},null,{"$f":"(I9*$E$6)+I15","v":0.484}]
[]
[null,"Revenu net (activité Responsable de Ruche non soumis à TVA)",null,"ou",{"$f":"E7-E9-E10-E15-E11","v":7.79},"ou",{"$f":"G7-G9-G10-G15-G11","v":7.48},"ou",{"$f":"I7-I9-I10-I15-I11","v":7.33}]
[null,"Revenu net (activité Responsable de Ruche soumis à TVA)",null,null,{"$f":"E7-E9-E10-E16-E11","v":7.604},null,{"$f":"G7-G9-G10-G16-G11","v":7.268},null,{"$f":"I7-I9-I10-I16-I11","v":7.106}]
[]
[]
[null,"CALCULER VOTRE PRIX DE VENTE A PARTIR DE VOTRE REVENU"]
[]
[{"$nulls":4},"TVA",null,"TVA",null,"TVA"]
[{"$nulls":4},0.2,null,0.055,null,"-"]
[null,"Votre revenu HT (Hors Taxes)",null,null,{"$f":"E12","v":6.333333333},null,{"$f":"G12","v":7.198672986},null,{"$f":"I12","v":7.59}]
[null,"Prix de vente HT (Hors Taxes)",null,null,{"$f":"E26/(1-($C$28+$C$29+$C$30))","v":8.333333333},null,{"$f":"G26/(1-($C$28+$C$29+$C$30))","v":9.471938139},null,{"$f":"I26/(1-($C$28+$C$29+$C$30))","v":9.986842105}]
[null,"Frais de service Responsable de Ruche (Hors Taxes)",0.1115,null,{"$f":"ROUND(E27*$C$28,2)","v":0.93},null,{"$f":"ROUND(G27*$C$28,2)","v":1.06},null,{"$f":"ROUND(I27*$C$28,2)","v":1.11}]
[null,"Frais de service Equanum SAS (1) (Hors Taxes)",0.1115,null,{"$f":"ROUND(E27*$C$29,2)","v":0.93},null,{"$f":"ROUND(G27*$C$29,2)","v":1.06},null,{"$f":"ROUND(I27*$C$29,2)","v":1.11}]
[null,"Frais de location Gare SNCF",0.017,null,{"$f":"E27*$C$30","v":0.1416666667},null,{"$f":"G27*$C$30","v":0.1610229484},null,{"$f":"I27*$C$30","v":0.1697763158}]
[null,"Prix de vente TTC",null,null,{"$f":"ROUND(E27*(1+E25),2)","v":10},null,{"$f":"ROUND(G27*(1+G25),2)","v":9.99},null,{"$f":"I27","v":9.986842105}]
[]
[null,"TVA récoltée",null,null,{"$f":"E31-E27","v":1.666666667},null,{"$f":"G31-G27","v":0.5180618608},null,{"$f":"I31-I27","v":0}]
[null,"TVA facturée par Equanum SAS (2)",null,"ou",{"$f":"ROUND((E29+E30)*$E$25,2)","v":0.21},"ou",{"$f":"ROUND((G29+G30)*$E$25,2)","v":0.24},"ou",{"$f":"ROUND((I29+I30)*$E$25,2)","v":0.26}]
[null,"TVA facturée par le Responsable de Ruche et Equanum SAS (2)",null,null,{"$f":"(E28*E25)+E34","v":0.396},null,{"$f":"(G28*E25)+G34","v":0.452},null,{"$f":"(I28*E25)+I34","v":0.482}]
[]
[null,"Revenu net (activité Responsable de Ruche non soumis à TVA)",null,"ou",{"$f":"E31-E28-E29-E34-E30","v":7.788333333},"ou",{"$f":"G31-G28-G29-G34-G30","v":7.468977052},"ou",{"$f":"I31-I28-I29-I34-I30","v":7.337065789}]
[null,"Revenu net (activité Responsable de Ruche soumis à TVA)",null,null,{"$f":"E31-E28-E29-E35-E30","v":7.602333333},null,{"$f":"G31-G28-G29-G35-G30","v":7.256977052},null,{"$f":"I31-I28-I29-I35-I30","v":7.115065789}]
[]
[]
[null,"(1) Equanum SAS est la société de la Ruche Mama "]
[null,"(2) La TVA facturée varie selon le statut de l'entreprise de votre Responsable de Ruche. Certains ne facturent pas la TVA. D'autres la facturent à un taux de 20%. \nLes frais de service de la Ruche Mama sont toujours facturés avec une TVA à 20%. "]
[null,"Remarque : Ce tableau est une simple aide à la gestion. Il n’a aucune valeur comptable. En raison des arrondis, le montant affiché sur vos factures peut différer."]