{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Facture 2019","Produits"],"not_rendered":{"images":3,"macros":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Facture 2019","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"merged":[[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[5,6,6,6],[6,3,6,5],[9,1,9,7],[10,2,10,7],[11,2,11,7],[12,2,12,7],[13,2,13,7],[14,2,14,7],[15,2,15,7],[41,1,41,7]]}
[{"$nulls":5},"FACTURE"]
[]
[{"$nulls":3},"Audrey PIOLI",null,null,"Date :",{"$f":"TODAY()","v":"2019-12-10"}]
[{"$nulls":3},"1 rue du clos de la ferme – 78660 ABLIS",null,null,"N° Facture :",11]
[{"$nulls":3},"Téléphone : 06 14 85 58 69"]
[{"$nulls":3},"Courriel : pioli.audrey@gmail.com"]
[{"$nulls":3},"N°FBO : 330001457102"]
[]
[]
[null,"Facturer à :"]
[]
[null,"Nom :","test"]
[null,"Adresse :","frlj"]
[null,"Téléphone :",{"v":1111111111,"d":"11 11 11 11 11"}]
[null,"Courriel :","geùmk"]
[]
[]
[null,"Référence","Description","Qté","Prix unitaire catalogue TTC","Remise","Prix unitaire TTC\navec remise ","Total TTC"]
[null,null,{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,table,2,0))","v":""},null,{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,table,3,0))","v":""},null,{"$f":"IF(B19=\"\",\"\",IF(F19=0.15,VLOOKUP(B19,table,4,0),E19-(E19*F19)))","v":""},{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,null,"",null,"",null,"",{"$f":"Tableau1[[#This Row],[Qté]]*Tableau1[[#This Row],[Prix unitaire TTC\navec remise ]]","v":{"$error":"#VALUE!"}}]
[null,"Hors frais de livraison"]
[]
[{"$nulls":6},"Total : ",{"$f":"SUMIF(Tableau1[Total TTC],\">0\",Tableau1[Total TTC])","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Produits","index":1,"n_rows":100,"n_cols":6,"rows_kept":100}
["ref","designation","prix normal","Prix Novus customer"]
[830,"Pack GO 2 FBO",360.49,360.49]
[715,"PULPE a l'unité (99,7%)",{"v":32.5,"d":"32.50"},{"v":27.6,"d":"27.60"}]
[734,"PULPE a l'unité (90,7%)",{"v":32.5,"d":"32.50"},{"v":27.6,"d":"27.60"}]
[777,"PULPE a l'unité (84,3%)",{"v":32.5,"d":"32.50"},{"v":27.6,"d":"27.60"}]
[3715,"TRIPACK PULPE d'ALOE VERA  99,7%",97.51,82.89]
[3734,"TRIPACK BERRY NECTAR  90,7% d'aloe",97.51,82.89]
[3777,"TRIPACK ALOE PÊCHE  84,3% d'aloe",97.51,82.89]
[7333,"TRIPACK MIXTE",97.51,82.89]
[71612,"ALOE VERA 330 ML à l'unité (99,7%)",10.83,{"v":9.2,"d":"9.20"}]
[7372,"ALOE VERA 330 ML à l'unité (90,7%)",10.83,{"v":9.2,"d":"9.20"}]
[77812,"ALOE VERA 330 ML à l'unité (84,3%)",10.83,{"v":9.2,"d":"9.20"}]
[610,"FOREVER ACTIVE PRO B : 30 capsules",35.37,30.07]
[376,"ARTIC SEA : 120 capsules",39.25,33.35]
[196,"FREEDOM - 89%  d'aloe",44.35,{"v":37.7,"d":"37.70"}]
[551,"MOVE 90 capsules",60.15,51.15]
[264,"Active HA - 60 capsules",38.75,32.95]
[205,"GEL MSM (118ml)",{"v":33.7,"d":"33.70"},28.66,null," "]
[206,"CALCIUM - 90 comp",31.05,{"v":26.4,"d":"26.40"}]
[48,"ABSORBENT-C  100 comprimés",{"v":22.6,"d":"22.60"},{"v":19.2,"d":"19.20"}]
[354,"FOREVER KIDS 120 comprimés",17.85,{"v":15.2,"d":"15.20"}]
[439,"FOREVER DAILY  60  comprimés",{"v":20.2,"d":"20.20"},{"v":17.2,"d":"17.20"}]
[355,"IMMUBLEND (60 comprimés: 1/j)",{"v":21.6,"d":"21.60"},18.35]
[456,"PACK VITAL 5",{"v":284.3,"d":"284.30"},{"v":242.3,"d":"242.30"}]
[72,"LYCIUM + : 100 comprimés",42.45,36.05]
[312,"NUTRA Q10 - 30 sachets",30.95,{"v":26.3,"d":"26.30"}]
[73,"GINKGO Plus - 60 comprimés",{"v":40.3,"d":"40.30"},{"v":34.3,"d":"34.30"}]
[621,"FOREVER SUPERGREENS",37.14,19.86]
[65,"AIL-THYM  100 capsules",23.35,31.57]
[68,"FIELDS OF GREENS",{"v":15.5,"d":"15.50"},{"v":13.2,"d":"13.20"}]
[200,"INFUSION 25 sachets",{"v":22.6,"d":"22.60"},{"v":19.2,"d":"19.20"}]
[374,"VITOLIZE Hommes  60 capsules",{"v":33.2,"d":"33.20"},{"v":28.2,"d":"28.20"}]
[215,"MULTI-MACA 60 comprimés",{"v":33.9,"d":"33.90"},{"v":28.8,"d":"28.80"}]
[475,"CURE DETOX C9  (2 pulpes, protéines, coupe-faim, brûleur de graisse, fibres + 1 livret d'explication et de suivi) - Réf : 475 nature/vanille",133.55,113.05]
[476,"CURE DETOX C9  (2 pulpes, protéines, coupe-faim, brûleur de graisse, fibres + 1 livret d'explication et de suivi) - Réf 476 : nature/chocolat",133.55,113.05]
[629,"CURE DETOX C9  (2 pulpes, protéines, coupe-faim, brûleur de graisse, fibres + 1 livret d'explication et de suivi) - Ref 629 : pêche/vanille",133.55,113.05]
[630,"CURE DETOX C9  (2 pulpes, protéines, coupe-faim, brûleur de graisse, fibres + 1 livret d'explication et de suivi) - Réf 630 : pêche/chocolat",133.55,113.05]
[625,"CURE DETOX C9  (2 pulpes, protéines, coupe-faim, brûleur de graisse, fibres + 1 livret d'explication et de suivi) - Berry/Vanille",133.55,113.05]
[626,"CURE DETOX C9  (2 pulpes, protéines, coupe-faim, brûleur de graisse, fibres + 1 livret d'explication et de suivi) -  Berry/Chocolat ",133.55,113.05]
[528,"Programme FIT 15: Débutant (ref 528 V/ 529 C)",156.55,{"v":133.2,"d":"133.20"}]
[532,"Programme FIT 15: Intermédiaire (532 V / 533 C)",156.55,{"v":133.2,"d":"133.20"}]
[536,"Programme FIT 15: Avancé (536 V / 537 C) ",156.55,{"v":133.2,"d":"133.20"}]
[71,"GARCINIA 70 capsules",42.45,36.05]
[463,"FOREVER THERM - 60 comprimés",36.85,{"v":31.3,"d":"31.30"}]
[289,"Forever Lean 120 capsules",{"v":38.8,"d":"38.80"},32.95]
[470,"Forever Lite Ultra Vanille 390g",{"v":26.6,"d":"26.60"},{"v":22.6,"d":"22.60"}]
[464,"Forever Fiber (30 sachets)",23.85,{"v":20.3,"d":"20.30"}]
[64,"HEAT Lotion Emulsion THERMOGENE (118ml)",{"v":21.7,"d":"21.70"},18.46]
[520,"FASTBREAK",51.25,43.55]
[473,"ARGI+ : (300g)",70.45,59.85]
[321,"FAB (canette 248 ml)",38.35,32.45]
[440,"FAB X (canette 248 ml)",38.35,32.45]
[207,"MIEL (500g)",{"v":21.6,"d":"21.60"},18.35]
[26,"BEE POLLEN  100 comprimés",{"v":19.6,"d":"19.60"},16.65]
[27,"BEE PROPOLIS  60 comprimés",40.96,{"v":34.8,"d":"34.80"}]
[36,"GELEE ROYALE - 60 comprimés",{"v":42.4,"d":"42.40"},{"v":36,"d":"36.00"}]
[51,"CREME PROPOLIS (118ml)",{"v":28.9,"d":"28.90"},{"v":24.6,"d":"24.60"}]
[61,"GELLY (118 ml)",{"v":21.7,"d":"21.70"},18.46]
[62,"LOTION  ALOES (118 ml)",{"v":21.7,"d":"21.70"},18.46]
[40,"ALOE FIRST (473ml)",{"v":28.9,"d":"28.90"},{"v":24.6,"d":"24.60"}]
[28,"DENTIFRICE FOREVER BRIGHT (130 g)",{"v":11.2,"d":"11.20"},{"v":9.5,"d":"9.50"}]
[521,"SHAMPOING aloès & jojoba (296ml)",{"v":25.7,"d":"25.70"},{"v":21.8,"d":"21.80"}]
[522,"APRES-SHAMPOING aloès & jojoba (296ml)",23.75,{"v":20.2,"d":"20.20"}]
[67,"STICK DEODORANT  (91g)",10.45,{"v":8.9,"d":"8.90"}]
[284,"Savon corps et visage à l'avocat (142g)",7.15,6.05]
[523,"SAVON LIQUIDE TRES DOUX (473 ml)",19.25,16.36]
[70,"LOTION APRES-RASAGE GENTLEMAN's PRIDE (118 ml)",{"v":21.7,"d":"21.70"},18.46]
[1318,"MANUGEL  (59 ml)",{"v":4.5,"d":"4.50"},{"v":3.8,"d":"3.80"}]
[1022,"STICK LEVRES",{"v":5.1,"d":"5.10"},{"v":4.3,"d":"4.30"}]
[617,"CREME SOLAIRE Aloe",22.75,19.34]
[524,"Forever Travel Kit ",{"v":24.9,"d":"24.90"},{"v":24.9,"d":"24.90"}]
[238,"GOMMAGE -Aloe SCRUB (99g)",22.96,{"v":19.5,"d":"19.50"}]
[234,"MASQUE FACIAL Marine Mask (113g)",{"v":24.2,"d":"24.20"},{"v":20.6,"d":"20.60"}]
[616,"MASQUE BIO-CELLULOSE x 5",{"v":57.6,"d":"57.60"},48.96]
[63,"CREME VISAGE MOISTURISING (118 ml)",{"v":21.7,"d":"21.70"},18.46]
[559,"SOIN EXFOLIANT (60 ml)",19.96,{"v":17,"d":"17.00"}]
[560,"LOTION TONIFIANTE (130 ml)",{"v":23.8,"d":"23.80"},20.26]
[561,"CREME CONTOUR DES YEUX (21g)",19.96,{"v":17,"d":"17.00"}]
[557,"SOIN DE JOUR SPF 20",{"v":39.7,"d":"39.70"},33.76]
[612,"ACTIVATEUR",16.97,14.42]
[341,"MASQUE POUDRE VISAGE",22.25,{"v":18.9,"d":"18.90"}]
[569,"EYELINER",{"v":21.9,"d":"21.90"},{"v":18.6,"d":"18.60"}]
[187,"SERUM Anti-Age Alpha E Factor",{"v":48.2,"d":"48.20"},40.96]
[69,"CREME Anti-Age R3 FACTOR (56,7g)",{"v":48.2,"d":"48.20"},40.96]
[311,"SOIN HYDRATANT INTENSE SONYA (pot de 71g)",{"v":35.2,"d":"35.20"},{"v":29.9,"d":"29.90"}]
[236,"EPIBLANC (28,3g)",{"v":21.5,"d":"21.50"},18.25]
[605,"GEL NETTOYANT",{"v":25.8,"d":"25.80"},{"v":21.9,"d":"21.90"}]
[606,"GEL ECLAT",{"v":24.4,"d":"24.40"},20.75]
[279,"LOTION TONIFIANTE AU THE BLANC",{"v":41.7,"d":"41.70"},{"v":24,"d":"24.00"}]
[608,"GEL HYDRATANT SONYA",28.25,35.45]
[607,"MASQUE GEL",{"v":25.8,"d":"25.80"},{"v":21.9,"d":"21.90"}]
[609,"TROUSSE",93.49,{"v":79.5,"d":"79.50"}]
[554,"DEMAQUILLANT HYDRATANT",28.75,24.46]
[555,"SERUM RAFFERMISSANT",56.95,{"v":48.4,"d":"48.40"}]
[558,"CREME REPARATRICE",{"v":63.5,"d":"63.50"},53.95]
[556,"COMPLEXE RAFFERMISSANT",{"v":49.8,"d":"49.80"},42.35]
[553,"4 PRODUITS",{"v":191.6,"d":"191.60"},162.85]
[307,"Forever Aloe MPD",35.35,30.05]
[30,"Formule animale",{"v":28.9,"d":"28.90"},{"v":24.6,"d":"24.60"}]
[0,null,{"v":0,"d":"0.00"}]