{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["INTERFACE","RAPPORT","DATA","GRAPHIQUE","INVENTAIRE LIQ","INVENTAIRE CONSOMMABLES","EVOLUTION TABAC","Notes","Types","ListeFournisseurs","ListeProduits","DIY","TCD","D1","Feuil1","Tutoriel"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":33,"comments":2,"pivot_tables":1},"unopened":[{"sheet":"GRAPHIQUE","index":3,"reason":"not_a_worksheet"},{"sheet":"D1","index":13,"reason":"not_a_worksheet"}],"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":"INTERFACE","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"RAPPORT","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["PARAMETRAGE","Valeurs",null,"INVESTISSEMENTS","EURO","%"]
["DATE ARRET",null,null,"TOTAL DEPENSES",{"$f":"SUM(PRIX)","v":0},{"$f":"IF(ISERROR($E2/$E$2),\"\",$E2/$E$2)","v":""}]
["MAINTENANT",{"$f":"NOW()","v":"2014-01-02T11:26:58.730"},null,"Consommables",{"$f":"SUM(PRIX*IF(GENRE=\"Consommables\",1,0))","v":0},{"$f":"IF(ISERROR($E3/$E$2),\"\",$E3/$E$2)","v":""}]
["NB JOURS DEPUIS E-CIG ",{"$f":"B3-B2","v":41641.47706863426},null,"Liquides",{"$f":"SUM(PRIX*IF(GENRE=\"Liquides\",1,0))","v":0},{"$f":"IF(ISERROR($E4/$E$2),\"\",$E4/$E$2)","v":""}]
[null,null,null,"Matériel",{"$f":"SUM(PRIX*IF(GENRE=\"Matériel\",1,0))","v":0},{"$f":"IF(ISERROR($E5/$E$2),\"\",$E5/$E$2)","v":""}]
["TABAC","Valeurs",null,"Tabac",{"$f":"SUM(PRIX*IF(GENRE=\"Tabac\",1,0))","v":0},{"$f":"IF(ISERROR($E6/$E$2),\"\",$E6/$E$2)","v":""}]
["Nb cigarettes / jour",null,null,"Frais de port",{"$f":"SUM(PRIX*IF(GENRE=\"Frais\",1,0))","v":0},{"$f":"IF(ISERROR($E7/$E$2),\"\",$E7/$E$2)","v":""}]
["Nb cigarettes par paquet"]
["Prix d'un paquet cigarettes actuel",null,null,"E- LIQUIDES","Calculs"]
["Prix actuel unitaire",{"$f":"IF(ISERROR(B9/B8),\"\",(B9/B8))","v":""},null,"Volume de liquides achetés (ml)",{"$f":"SUM(VOLUME)","v":0}]
["Coût tabac / Jour",{"$f":"IF(ISERROR(B7*B10),\"\",(B7*B10))","v":""},null,"Volume de liquides restant (ml)",""]
[null,null,null,"liquides consommés (ml)",{"$f":"IF(ISERROR(E10-E11),\"\",(E10-E11))","v":""}]
["ECONOMIES","Valeurs",null,"Consommation journalière calculée (ml)",{"$f":"IF(ISERROR(E12/B4),\"\",(E12/B4))","v":""}]
["Nb cigarettes économisées",{"$f":"IF(ISERROR(ROUND(B4*B7,2)),\"\",ROUND(B4*B7,2))","v":0},null,"Nb de jours de consommation theorique d'après stock ",{"$f":"IF(ISERROR(E10/E13),\"\",(E10/E13))","v":""}]
["Economies depuis arrêt",{"$f":"IF(ISERROR(B14*B10),\"\",(B14*B10))","v":""},null,"Nb de jours de consommation restant ",{"$f":"IF(ISERROR(E11/E13),\"\",(E11/E13))","v":""}]
["Economies par jour",{"$f":"IF(ISERROR(B15/B4),\"\",(B15/B4))","v":""}]
["Amortissement dans (jours)",{"$f":"IF(ISERROR(IF((B21/B16)<0,ABS(B21/B16),\"Amortissement réalisé \")),\"\",IF((B21/B16)<0,ABS(B21/B16),\"Amortissement réalisé \"))","v":""}]
["Date de retour sur investissement",{"$f":"IF(ISERROR(B3+B17),B3-(avgmonthcost/Coût_tabac___Jour),(B3+B17))","v":{"$error":"#VALUE!"}}]
["Cout estimé du vapotage /j sur invest",{"$f":"IF(ISERROR(E2/E14),\"\",(E2/E14))","v":""}]
["Cout estimé du vapotage /mensuel",{"$f":"IF(ISERROR(B19*(365/12)),\"\",(B19*(365/12)))","v":""}]
["Balance",{"$f":"IF(ISERROR(B15-E2),\"\",(B15-E2))","v":""}]

{"sheet":"DATA","index":2,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["DATE ACHAT","FOURNISSEURS","PRODUITS","QUANTITE","GENRE","CONTENANCE","PRIX","VOLUME","MOIS ","ANNEE","Prix tabac de ref","Nicotine"]
[40858,"TEST","TEST",0,"Consommables",0,0,0,11,2011,0]

{"sheet":"INVENTAIRE LIQ","index":4,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Désignation","Stock achat","Stock inventaire","Statut","Prix","Coût au ml","Ecart Stock","Dépenses",null,"TOT DEP",{"$f":"SUM(H:H)","v":0},"VOL EN STOCK",{"$f":"SUM(C:C)","v":0}]

{"sheet":"INVENTAIRE CONSOMMABLES","index":5,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Désignation","Stock acheté","Stock actuel","Stock Valeur","Prix initial lot","Statut","Dépenses",null,null,"Total",{"$f":"SUM(G:G)","v":0}]

{"sheet":"EVOLUTION TABAC","index":6,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE REF TABAC","PRIX TABAC REF","NB JOURS ","NB CIG JOUR","COUT JOUR EURO","ECONOMIES SUR PERIODE EURO"]

{"sheet":"Notes","index":7,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Genres / Types","Désignation","Notes sur 10","Commentaires"]

{"sheet":"Types","index":8,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Genre"]
["Consommables"]
["Liquides"]
["Matériel"]
["Frais"]
["Tabac"]

{"sheet":"ListeFournisseurs","index":9,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Noms fournisseurs"]
["TEST"]

{"sheet":"ListeProduits","index":10,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Noms des produits"]
["TEST"]

{"sheet":"DIY","index":11,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["FORMULA","%","ML"]
["VG",{"$f":"100-SUM(B3:B9)","v":100},{"$f":"B2*TOT%","v":0}]
["PG",null,{"$f":"B3*TOT%","v":0}]
["EAU",null,0]
["ALCOOL",null,0]
["PARFUM 1",null,0]
["PARFUM 2",null,0]
["PARFUM 3",null,0]
["PARFUM 4",null,0]
["TOTAUX",100]

{"sheet":"TCD","index":12,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["GENRE","Consommables"]
[]
["Étiquettes de lignes","Somme de PRIX"]
["TEST",0]

{"sheet":"Feuil1","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tutoriel","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}