{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["consignes","schéma facture"," facture"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"consignes","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"voici 2 onglets avec "]
[null,null,"les schémas de calcul comme celui vu au cours; à vous de trouver les formules pour obtenir le total"]
[null,null,"il est prévu 3 produits maximum , si il n'y en a que 2 il suffit de mettre la quantité égale à 0"]
[]
[null,null,"le modèle de facture qui doit aussi contenir des formules"]
[]
[]
[]
[null,null,"rem : les formules sont dans les cellules avec fond rouge"]

{"sheet":"schéma facture","index":1,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"frite",null,null,"farine",null,null,"casier jup"]
[]
["marchandises",120,null,null,"marchandises",151,null,"marchandises",110]
["remise",0.04,null,null,"remise",0.04,null,"remise",0.04]
["différence",null,null,null,"différence",null,null,"différence"]
["escompte",0.02,null,null,"escompte",0.02,null,"escompte",0.02]
[]
["différence",null,null,null,"différence",null,null,"différence"]
["transport",null,null,null,"transport",25,null,"transport"]
["emb non repris",10.5,null,null,"emb non repris",0,null,"emb non repris"]
[]
["somme",null,null,null,"somme",null,null,"somme"]
["tva",0.21,null,null,"tva",0.06,null,"tva",0.21]
["somme",null,null,null,"somme",null,null,"somme"]
[]
["emb repris",null,null,null,"emb repris",10,null,"emb repris",110]
[]
["somme avec escompte",null,null,null,"somme",null,null,"somme"]
["somme sans escompte"]
[]
[]
[]
[null,"somme"]
[null,"escompte",{"$f":"C6+G6+J6","v":0}]
[null,"somme"]

{"sheet":" facture","index":2,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[40,3,40,4],[40,5,40,6],[40,7,41,8],[40,9,41,10],[32,5,32,6],[32,7,33,8],[32,9,33,9],[32,10,33,10],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[28,2,28,4],[29,2,29,4],[30,2,30,4],[32,0,33,0],[32,1,33,1],[32,2,32,3],[32,4,33,4],[27,2,27,4],[18,0,18,7],[18,8,18,9],[19,0,19,10],[21,0,22,0],[21,1,22,1],[21,2,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[16,8,16,9],[3,6,3,8],[3,9,3,10],[5,6,5,8],[5,9,5,10],[8,6,8,10],[9,6,9,10],[10,6,10,10],[11,6,11,10],[12,6,12,10],[14,7,14,9],[15,7,15,9]]}
[]
[]
[]
[{"$nulls":6},"Facture n°:",null,null,"………….."]
[]
[{"$nulls":6},"Date de facturation :",null,null,"…./…./…."]
{"$rows_empty":8}
[{"$nulls":6},"Client: "]
[{"$nulls":6},"Contrat: "]
[{"$nulls":6},"TVA:"]
[]
["doit pour prestation(s) et/ou marchandise(s) livrée(s)/emportée(s) le",{"$nulls":7},"………………….."]
["payable(s) à 30 jours fin de mois ou ..% d'escompte si paiement au comptant par virement."]
[]
["Réf,","Quantité","Libellé",null,null,"Prix unitaire","Prix brut","Réductions",null,"Totaux","Code"]
[{"$nulls":7},"%","Montant"]
["fri25",3,"trancheuses",null,null,398.75,null,5,null,null,3]
["ref bie23",10,"coca",null,null,11.1,null,5,null,null,1]
["ref far10",10,"farine",null,null,2,{"$nulls":4},1]
[]
[]
[]
[]
[]
[]
["Code","Totaux","Escompte",null,"Prix net hors TVA","Emballages",null,"Port",null,"Montant taxable","TVA"]
[null,null,"%","Montant",null,"Repris","Non repris"]
[1,{"$f":"SUMIF(K24:K31,\"=1\",J24:J31)","v":0},2,null,null,45,null,25]
[2,{"$f":"SUMIF(K24:K31,\"=2\",J24:J31)","v":0},2]
[3,{"$f":"SUMIF(K24:K31,\"=3\",J24:J31)","v":0},2,null,null,null,5]
[]
[]
["Code","% TVA "]
[1,6,null,"Escompte à bonifier ",null,{"$f":"D38","v":0},null,"A PAYER",null,{"$f":"J38+K38+F38+F41","v":0}]
[2,12]
[3,21]
[]
[{"$nulls":4},"si je paie dans les délais ( escompte accordé)",{"$nulls":4},{"$f":"J41-F41","v":0}]
[{"$nulls":4},"si je paie hors délais",{"$nulls":4},{"$f":"J41","v":0}]