{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Facture commerciale","Clients"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Facture commerciale","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,1,1,3],[0,6,0,7],[1,6,1,7]]}
[null,"JOUETS TAILSPIN",null,null,"123 Main Street","Tél. : 01 02 03 04 05","tailspin@interestingsite.com",null,null,"Clients"]
[{"$nulls":4},"Ocean View,  MO 12345","Fax : 123-555-0124","www.tailspintoys.com"]
[]
[null,"Facturer à :","Lilli Allik","Téléphone :",{"$f":"IFERROR(VLOOKUP(NomFacture,ListeClients[],8,FALSE),\"\")","v":"432-555-0178"},null,"N° Facture :",34567]
[null,"Adresse :",{"$f":"IFERROR(VLOOKUP(NomFacture,ListeClients[],3,FALSE),\"\")","v":"345 Cherry Street"},"Télécopie :",{"$f":"IFERROR(VLOOKUP(NomFacture,ListeClients[],10,FALSE),\"\")","v":"432-555-0187"},null,"Date de facturation :",{"$f":"TODAY()","v":"2022-12-09"}]
[null,null,{"$f":"IF(VLOOKUP(NomFacture,ListeClients[],4,FALSE)<>\"\",VLOOKUP(NomFacture,ListeClients[],4,FALSE),IF(VLOOKUP(NomFacture,ListeClients[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(NomFacture,ListeClients[],5,FALSE),\", \",VLOOKUP(NomFacture,ListeClients[],6,FALSE),\" \",VLOOKUP(NomFacture,ListeClients[],7,FALSE)),CONCATENATE(VLOOKUP(NomFacture,ListeClients[],6,FALSE),\" \",VLOOKUP(NomFacture,ListeClients[],7,FALSE))))","v":"Suite 123"},"E-mail :",{"$f":"IFERROR(VLOOKUP(NomFacture,ListeClients[],9,FALSE),\"\")","v":"mike@excellentwebsite.com"},null,"Coordonnées :",{"$f":"IFERROR(VLOOKUP(NomFacture,ListeClients[],2,FALSE),\"\")","v":"Mike Gragg"}]
[null,null,{"$f":"IF(VLOOKUP(NomFacture,ListeClients[],4,FALSE)=\"\",\"\",IF(VLOOKUP(NomFacture,ListeClients[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(NomFacture,ListeClients[],5,FALSE),\", \",VLOOKUP(NomFacture,ListeClients[],6,FALSE),\" \",VLOOKUP(NomFacture,ListeClients[],7,FALSE)),CONCATENATE(VLOOKUP(NomFacture,ListeClients[],6,FALSE),\" \",VLOOKUP(NomFacture,ListeClients[],7,FALSE))))","v":"Paris, Île de France 12345"}]
[null,"DATE","N° ARTICLE","DESCRIPTION","QTÉ","PRIX UNITAIRE","REMISE","TOTAL"]
[null,{"$f":"TODAY()","v":"2022-12-09"},789807,"Blocs de bois",4,{"v":10,"d":"10.00 €"},{"v":2,"d":"2.00 €"},{"$f":"IF(AND(PostesFacture[[#This Row],[QTÉ]]<>\"\",PostesFacture[[#This Row],[PRIX UNITAIRE]]<>\"\"),(PostesFacture[[#This Row],[QTÉ]]*PostesFacture[[#This Row],[PRIX UNITAIRE]])-PostesFacture[[#This Row],[REMISE]],\"\")","v":{"v":38,"d":"38.00 €"}}]
[{"$nulls":7},{"$f":"IF(AND(PostesFacture[[#This Row],[QTÉ]]<>\"\",PostesFacture[[#This Row],[PRIX UNITAIRE]]<>\"\"),(PostesFacture[[#This Row],[QTÉ]]*PostesFacture[[#This Row],[PRIX UNITAIRE]])-PostesFacture[[#This Row],[REMISE]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(PostesFacture[[#This Row],[QTÉ]]<>\"\",PostesFacture[[#This Row],[PRIX UNITAIRE]]<>\"\"),(PostesFacture[[#This Row],[QTÉ]]*PostesFacture[[#This Row],[PRIX UNITAIRE]])-PostesFacture[[#This Row],[REMISE]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(PostesFacture[[#This Row],[QTÉ]]<>\"\",PostesFacture[[#This Row],[PRIX UNITAIRE]]<>\"\"),(PostesFacture[[#This Row],[QTÉ]]*PostesFacture[[#This Row],[PRIX UNITAIRE]])-PostesFacture[[#This Row],[REMISE]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(PostesFacture[[#This Row],[QTÉ]]<>\"\",PostesFacture[[#This Row],[PRIX UNITAIRE]]<>\"\"),(PostesFacture[[#This Row],[QTÉ]]*PostesFacture[[#This Row],[PRIX UNITAIRE]])-PostesFacture[[#This Row],[REMISE]],\"\")","v":""}]
[{"$nulls":6},"Sous-total de la facture",{"$f":"SUM(PostesFacture[TOTAL])","v":{"v":38,"d":"38.00 €"}}]
[{"$nulls":6},"Taux d’imposition",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"T.V.A.",{"$f":"SousTotalFacture*TauxTaxeVente","v":{"v":3.3819999999999997,"d":"3.38 €"}}]
[{"$nulls":6},"Frais d’expédition",{"v":5,"d":"5.00 €"}]
[null,{"$f":"\"Veuillez libeller tous les chèques à l’ordre de \"&UPPER(NomSociété)&\".\"","v":"Veuillez libeller tous les chèques à l’ordre de JOUETS TAILSPIN."},{"$nulls":4},"Acompte reçu",{"v":0,"d":"0.00 €"}]
[null,"Montant total dû dans 10 jours. Les comptes en souffrance sont soumis à des frais d’intérêt de 2 % par mois.",{"$nulls":4},"Total",{"$f":"SousTotalFacture+TaxeVente+Frais_dexpédition-Acompte","v":{"v":46.382,"d":"46.38 €"}}]

{"sheet":"Clients","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"CLIENTS",{"$nulls":10},"Facture commerciale"]
[null,"NOM DE LA SOCIÉTÉ","COORDONNÉES","ADRESSE","ADRESSE2","CITY","DÉPARTEMENT","CODE POSTAL","TÉLÉPHONE","E-MAIL","FAX"]
[null,"Lilli Allik","Mike Gragg","345 Cherry Street","Suite 123","Paris","Île de France",12345,"432-555-0178","mike@excellentwebsite.com","432-555-0187"]
[null,"Contoso, Ltd","Janine Mendoza","567 Walnut Lane",null,"Bordeaux","Aquitaine","09876","432-555-0189","contoso@websitegoeshere.com","05 22 33 44 05"]