{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Acceuil","Créer Devis","Créer Facture","BDD_Produits","BDD_Clients","BDD_Infos_Entreprise"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"Acceuil","index":0,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,14,17,16],[19,14,19,16],[20,14,20,16],[22,14,25,16],[8,1,9,3],[8,5,9,7],[1,2,4,15],[5,2,5,15],[10,14,11,16],[12,14,15,16],[16,14,16,16]]}
[]
[null,null,"GESTION AUTO-ENTREPRISE V1.0"]
[]
[]
[]
[null,null,"Micro-Logiciel édité par: M. Taury Nicolas - E-mail: nico.taury@outlook.com - Tel: 07.50.81.63.72"]
[]
[]
[null,"NAVIGATION",null,null,null,"EDITION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Après Vente (SAV)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pour toutes modifications ou réparations de ce micro-logiciel, veuillez nous contacter."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Par téléphone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07.50.81.63.72"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Par e-mail"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nico.taury@outlook.com"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le SAV est disponible gratuitement pour les utilisateurs ayant acheté ce micro-logiciel"]

{"sheet":"Créer Devis","index":1,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,5,46,7],[11,0,13,3],[42,1,42,4],[44,5,45,6],[44,7,45,7],[37,1,37,4],[38,1,38,4],[39,1,39,4],[40,1,40,4],[41,1,41,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[15,0,16,0],[15,1,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[8,0,8,2],[8,5,8,6],[9,0,9,2],[9,5,9,6],[10,5,10,6],[5,0,5,2],[5,5,5,7],[6,0,6,2],[6,5,6,7],[7,0,7,2],[0,0,1,7],[3,0,3,2],[3,5,3,7],[4,0,4,2],[4,5,4,7]]}
["DEVIS"]
[]
[]
["Informations Entreprise",null,null,null,null,"Informations Client"]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!B2,BDD_Infos_Entreprise!B2)","v":"Taury Nicolas AE"}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!C2,BDD_Infos_Entreprise!C2)","v":"Taury Nicolas"},null,null,null,null,{"$f":"IFERROR(VLOOKUP(F5,registre_clients,3,0),\"\")","v":""}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!D2,BDD_Infos_Entreprise!D2)","v":"187 chemin des Mathieux"},null,null,null,null,{"$f":"IFERROR(VLOOKUP(F5,registre_clients,4,0)& \" \" &VLOOKUP(F5,registre_clients,5,0),\"\")","v":""}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!E2,BDD_Infos_Entreprise!E2) & \" \" & LOOKUP(BDD_Infos_Entreprise!F2,BDD_Infos_Entreprise!F2)","v":"27560 Epreville en Lieuvin"}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!G2,BDD_Infos_Entreprise!G2)","v":"51498680100033"},null,null,null,null,"Référence Client",null,{"$f":"IFERROR(VLOOKUP(F5,registre_clients,2,0),\"\")","v":""}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!H2,BDD_Infos_Entreprise!H2)","v":"07.50.81.63.72"},null,null,null,null,"Devis N°",null,"D201690011"]
[null,null,null,null,null,"Date",null,{"$f":"TODAY()","v":"2016-09-21"}]
["Dispensé d'immatriculation au registre du commerce et des sociétés (RCS) et au répertoire des métiers (RM)"]
[]
[]
[]
["Réérence Produit","Description",null,null,null,"Prix Unitaire (HT)","Quantité","Montant (HT)"]
[]
[null,{"$f":"IFERROR(VLOOKUP(A18,produits,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(A18,produits,3,0),\"\")","v":""},null,{"$f":"IFERROR(SUM(F18*G18),\"\")","v":""}]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[]
[null,null,null,null,null,"TOTAL (HT)",null,{"$f":"SUM(H18:H43)","v":0}]
[]
[null,null,null,null,null,"TVA non applicable, Art 293B du CGI"]

{"sheet":"Créer Facture","index":2,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,5,49,7],[50,5,50,7],[51,5,51,7],[52,5,53,7],[0,0,1,7],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[15,7,16,7],[8,0,8,2],[9,0,9,2],[3,5,3,7],[4,5,4,7],[5,5,5,7],[6,5,6,7],[8,5,8,6],[9,5,9,6],[7,0,7,2],[10,5,10,6],[15,0,16,0],[15,1,16,4],[15,5,16,5],[15,6,16,6],[11,0,13,3],[28,1,28,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[40,1,40,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[41,1,41,4],[42,1,42,4],[44,5,45,6],[44,7,45,7],[46,5,46,7],[44,0,44,1],[44,2,44,3]]}
["FACTURE"]
[]
[]
["Informations Entreprise",null,null,null,null,"Informations Client"]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!B2,BDD_Infos_Entreprise!B2)","v":"Taury Nicolas AE"}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!C2,BDD_Infos_Entreprise!C2)","v":"Taury Nicolas"},null,null,null,null,{"$f":"IFERROR(VLOOKUP(F5,registre_clients,3,0),\"\")","v":""}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!D2,BDD_Infos_Entreprise!D2)","v":"187 chemin des Mathieux"},null,null,null,null,{"$f":"IFERROR(VLOOKUP(F5,registre_clients,4,0)& \" \" &VLOOKUP(F5,registre_clients,5,0),\"\")","v":""}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!E2,BDD_Infos_Entreprise!E2) & \" \" & LOOKUP(BDD_Infos_Entreprise!F2,BDD_Infos_Entreprise!F2)","v":"27560 Epreville en Lieuvin"}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!G2,BDD_Infos_Entreprise!G2)","v":"51498680100033"},null,null,null,null,"Référence Client",null,{"$f":"IFERROR(VLOOKUP(F5,registre_clients,2,0),\"\")","v":""}]
[{"$f":"LOOKUP(BDD_Infos_Entreprise!H2,BDD_Infos_Entreprise!H2)","v":"07.50.81.63.72"},null,null,null,null,"Facture N°",null,"F201690012"]
[null,null,null,null,null,"Date",null,{"$f":"TODAY()","v":"2016-09-21"}]
["Dispensé d'immatriculation au registre du commerce et des sociétés (RCS) et au répertoire des métiers (RM)"]
[]
[]
[]
["Réérence Produit","Description",null,null,null,"Prix Unitaire (HT)","Quantité","Montant (HT)"]
[]
[null,{"$f":"IFERROR(VLOOKUP(A18,produits,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(A18,produits,3,0),\"\")","v":""},null,{"$f":"IFERROR(SUM(F18*G18),\"\")","v":""}]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[null,"",null,null,null,"",null,""]
[]
["Mode de Paiement",null,null,null,null,"TOTAL (HT)",null,{"$f":"SUM(H18:H43)","v":0}]
[]
[null,null,null,null,null,"TVA non applicable, Art 293B du CGI"]
[]
[]
[null,null,null,null,null,"Informations"]
[null,null,null,null,null,"Paiement à 30 jours"]
[null,null,null,null,null,"Taux des pénalités de retard : 11%"]
[null,null,null,null,null,"Indemnité forfaitaire de 40€ HT pour frais de recouvrement"]

{"sheet":"BDD_Produits","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Ref. Produit","Description","Prix"]

{"sheet":"BDD_Clients","index":4,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Nom et Prénom","Ref. Client","Adresse","Code Postal","Ville","N° Téléphone","Adresse E-mail"]
["John Doe","JD78250","128 Route de la Rue","78250","La Ville","00.00.00.00.00","john.doe@fai.com"]
["Dupont Guy","CL00001","659 Rue de Paris","75013","Paris 13°","01.43.55.88.66","dupont.guy@fai.fr"]

{"sheet":"BDD_Infos_Entreprise","index":5,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["N° Entreprise","Dénomination","Nom et Prénom","Adresse","Code Postal","Ville","SIRET","N° Téléphone"]
[1,"Taury Nicolas AE","Taury Nicolas","187 chemin des Mathieux","27560","Epreville en Lieuvin","51498680100033","07.50.81.63.72"]