{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Facture Client","Data Vendus","Inventaire","Achat","Fournisseur","Dépenses"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Facture Client","index":0,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,5,0,6],[8,4,8,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"FACTURE N⁰ :",null,100]
[]
[null,"Mode de paiement"]
[null,"Visa","x","visa"]
[null,"Comptant"]
[null,"Débit",null,null,null,"DATE DE LA FACTURE",{"$f":"TODAY()","v":"2016-05-30"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C20,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C20,Inventaire!A:F,6,FALSE))","v":0},{"$f":"B20*F20","v":0}]
[null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C21,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C21,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C22,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C22,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C22,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C22,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C23,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C23,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C23,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C23,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C24,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C24,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C24,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C24,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C25,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C25,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C25,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C25,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C26,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C26,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C26,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C26,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C27,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C27,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C27,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C27,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C28,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C28,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C28,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C28,Inventaire!A:F,6,FALSE))","v":0},{"$f":"B28*F28","v":0}]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C29,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C29,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C29,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C29,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C30,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C30,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C30,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C30,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C31,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C31,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C31,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C31,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C32,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C32,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C32,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C32,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C33,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C33,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C33,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C33,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C34,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C34,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C34,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C34,Inventaire!A:F,6,FALSE))","v":0},{"$f":"B34*F34","v":0}]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C35,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C35,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C35,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C35,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C36,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C36,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C36,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C36,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C37,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C37,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C37,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C37,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C38,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C38,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C38,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C38,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C39,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C39,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C39,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C39,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C40,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C40,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C40,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C40,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,{"$f":"IF(ISERROR(VLOOKUP(C41,Inventaire!A:J,3,FALSE))=TRUE,\"\",VLOOKUP(C41,Inventaire!A:J,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(C41,Inventaire!A:F,6,FALSE))=TRUE,0,VLOOKUP(C41,Inventaire!A:F,6,FALSE))","v":0},0]
[null,null,null,null,null,"SOUS-TOTAL",{"$f":"SUM(G20:G41)","v":0}]
[null,"N⁰ TPS :772785093RT0001",null,null,"TPS","5%",{"$f":"G42*F43","v":0}]
[null,"N⁰ TVQ :1022344044TQ0001",null,null,"TVQ","9,975%",{"$f":"G42*F44","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"ROUNDDOWN(G42+G43+G44,2)","v":0}]

{"sheet":"Data Vendus","index":1,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No facture","Format Paiement","Date Vente","Sous-total","TPS","TVQ","Total complet","Quantité","Numéro de produit","Description","Prix Unitaire","Montant"]

{"sheet":"Inventaire","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["No produit","Code Couleur","Description produit","Caractéristique","Nom du Fournisseur","Prix Détails","Qté acheté","Démo Client","Qté Vendus","Qté Inventaire"]
[null,null,null,null,null,null,null,null,null,{"$f":"G2-H2-I2","v":0}]

{"sheet":"Achat","index":3,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["No produit","Code Couleur","Description produit","Nom du Fournisseur","Coûtant","Qté acheté"]
[83426,7832,"Laine Katia Azteca 100 gr. Couleur 7832"]

{"sheet":"Fournisseur","index":4,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Nom du fournisseur","Adresse","Adresse 2","Ville","Pays","Site Internet","No Téléphone","No Fax","Courriel"]

{"sheet":"Dépenses","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}