{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["produits","Clients","Synthèse","Corrigé"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":"produits","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["Référence","Code TVA","Désignation","Prix\nunitaire"]
["CR",1,"Abonnement Périodique",0.5]
["F50",1,"Abonnement Périodique Hors Série",1]
["FR",2,"CB A débit immédiat",25]
["JA",2,"CB A débit différé",30]
["LA",2,"Frais ouverture livret A",1.5]
["OE",2,"Ordres sur compte courant",1.5]
["OI",2,"Ordre sur titres de bourses",2]

{"sheet":"Clients","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["N° \nClient","Adresse","Code\npostal","Ville","Désignation"]
[41104,"10 rue Grurie","10340","CHANNES","Les fils du terroir"]
[41103,"12 grande rue","10210","CHAOURCE","Fil DUC"]
[41101,"25 rue principale","10200","JAUCOURT","Au beau tissu"]
[41105,"4 rue du moulin","10240","VAUCOGNE","Les lettres du moulin "]
[41107,"55 rue des Ponts","10140","VENDEUVRE","Au bon étoffe"]
[41102,"654 rue Croix Blanche","10120","St ANDRE","La quenouille"]
[41106,"7 rue des Vergers","10320","JAVERNANT","Cotonnerie Paris et fils"]

{"sheet":"Synthèse","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[18,7,18,8],[0,1,1,1],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8]]}
[null,"Taux de TVA",5.5E-2,"Code TVA 1"]
[null,null,0.19600000000000001,"Code TVA 2"]
[]
["N° Clients","Raison\nsociale","Référence\nProduit","Désignation\nProduit","Prix\nunitaire","Quantités\nachetées","Montant HT","Code TVA","Montant TVA","Montant TTC"]
[41101,{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,fournisseur,5,0))","v":"Au beau tissu"},"JA",{"$f":"IF(C5=\"\",\"\",VLOOKUP(C5,produits,3,0))","v":"CB A débit différé"},{"$f":"IF(D5=\"\",\"\",VLOOKUP(C5,produits,4,0))","v":30},3,{"$f":"IF(C5=\"\",\"\",E5*F5)","v":90},{"$f":"IF(C5=\"\",\"\",VLOOKUP(C5,produits,2,0))","v":2},{"$f":"IFERROR(IF(H5=1,$C$1*G5,$C$2*G5),\"\")","v":17.64},{"$f":"IF(C5=\"\",\"\",G5+I5)","v":107.64}]
[41104,"Les fils du terroir","OI","Ordre sur titres de bourses",2,30,{"$f":"IF(C6=\"\",\"\",E6*F6)","v":60},2,{"$f":"IFERROR(IF(H6=1,$C$1*G6,$C$2*G6),\"\")","v":11.76},{"$f":"IF(C6=\"\",\"\",G6+I6)","v":71.760000000000005}]
[41106,"Cotonnerie Paris et fils","F50","Abonnement Périodique Hors Série",1,2,2,1,0.11,2.11]
[null,"",null,"","",null,"","","",""]
[null,"",null,"","",null,"","","",""]
[null,"",null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,produits,3,0))","v":""},{"$f":"IF(D10=\"\",\"\",VLOOKUP(C10,produits,4,0))","v":""},null,{"$f":"IF(C10=\"\",\"\",E10*F10)","v":""},{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,produits,2,0))","v":""},{"$f":"IFERROR(IF(H10=1,$C$1*G10,$C$2*G10),\"\")","v":""},""]
[]
[null,"",null,"","",null,"","","",""]
["Nombre de Clients",{"$f":"COUNTA(C5:C12)","v":3}]
[null,null,null,null,null,null,null,"Total Général",null,{"$f":"SUM(J5:J12)","v":181.51000000000002}]
[null,null,null,null,"Total TVA 19,60%",{"$f":"SUMIF(H5:H12,1,I5:I12)","v":0.11},null,"Moyenne des achats",null,{"$f":"AVERAGE(J5:J12)","v":60.503333333333337}]
[null,null,null,null,"Total TVA 5,50 %",{"$f":"SUMIF(H5:H12,2,I5:I12)","v":29.4},null,"Achat le plus faible",null,{"$f":"MIN(J5:J12)","v":2.11}]
[null,null,null,null,null,null,null,"Achat le plus important",null,{"$f":"MAX(J5:J12)","v":107.64}]
[null,null,null,null,null,null,null,"Transport",null,{"$f":"IF(E20=2,0,3)","v":3}]
[null,null,null,null,null,null,null,"Nbre commandes > à 70 € HT",null,{"$f":"COUNTIF(G5:G12,\">70\")","v":1}]
[null,null,null,null,1]

{"sheet":"Corrigé","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Genève","Lausanne","Fribourg","Berne","Zurich"]
["Genève",0,65,130,166,310]
["Lausanne",65,0,50,101,245]
["Fribourg",130,50,0,36,180]
["Berne",166,101,36,0,144]
["Zurich",310,245,180,144,0]
[]
[]
[]
["Ville de départ",null,"Ville d'arrivée"]
["Zurich",null,"Berne"]
[]
["Nombre de Km",{"$f":"INDEX(B3:F7,MATCH(A12,villel,0),MATCH(C12,villec,0))","v":144}]