{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Clients","Devis","Facture"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Clients","index":0,"n_rows":31,"n_cols":6,"rows_kept":31}
["RÉF_CLIENT","NOM DU CLIENT","ADRESSE","CP - VILLE","TELEPHONE","E-MAIL"]
[1,"essai","baume","13300 SALON"]
[2,"2ème essai"]
[3]
[4]
[5,"GOURMANDIT RECEPTIONS","20, avenue du Bosquet","95560 - BAILLET EN France"]
[6]
[7]
[8,"Madame Virginie BABUT","Moulin des Cherottes","27240 - DAMVILLE"]
[9,"Madame Virginie ZACZEK",null,"78860 - SAINT NOM LA BRETECHE"]
[10,"Madame Marie-Claude BABY",null,"75014 - PARIS"]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]

{"sheet":"Devis","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"merged":[[0,3,0,4],[1,3,1,5],[3,0,3,2],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[11,0,11,5],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[37,0,37,1],[37,3,37,5]]}
[{"$nulls":3},"DEVIS N°",null,{"$f":"YEAR(F4)&\"_\"&MONTH(F4)&\"_\"&TEXT(K5,\"0000\")","v":"1900_1_0003"}]
[{"$nulls":3},"Devis valable 1 semaine"]
[]
["SERVEUR A LA CARTE",{"$nulls":3},"Date"]
[{"$nulls":4},"Réf. Client",{"$nulls":5},3]
[]
[]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(F5,Clients,2,0),\"Nom du client \")","v":"Nom du client "}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(F5,Clients,3,0),\"Adresse \")","v":"Adresse "}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(F5,Clients,4,0),\"CP-VILLE \")","v":"CP-VILLE "}]
[]
["DESCRIPTION DE LA PRESTATION"]
[]
[]
[]
[]
[]
[null,null,"Nombre de Personnel","Nombre d'heures","Taux horaire","Montant"]
[]
[]
[]
[]
[null,"Si heures supplémentaires de jour : 40€ l'heure"]
[null,"Si heures supplémentaires de nuit : 55€ l'heure"]
[]
[{"$nulls":3},"Sous Total"]
[{"$nulls":3},"Remise"]
[{"$nulls":3},"MONTANT TOTAL"]
[]
["Conditions de règlement :",null,null,"NET A PAYER"]
["Acompte à la signature du devis :"]
["Solde à la fin de la Prestation"]
[]
["Merci de nous retourner un exemplaire de ce devis, signé avec votre nom et revêtu de la mention"]
["\"Bon pour accord\". Accompagné du règlement de l'acompte à l'ordre de "]
[]
[]
["Pour l'entreprise",null,null,"Pour le client"]
[{"$nulls":3},"À","le :"]
[{"$nulls":3},"Mention :"]
[{"$nulls":3},"Nom :","Signature :"]

{"sheet":"Facture","index":2,"n_rows":37,"n_cols":11,"rows_kept":37,"merged":[[0,3,0,4],[1,3,1,5],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[12,0,12,3],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[28,3,28,5]]}
[{"$nulls":3},"FACTURE N° ",null,{"$f":"YEAR(F4)&\"_\"&MONTH(F4)&\"_\"&TEXT(K5,\"0000\")","v":"1900_1_0001"}]
[]
[]
["SERVEUR A LA CARTE",{"$nulls":3},"Date"]
[{"$nulls":4},"Réf. Clients",{"$nulls":5},1]
[]
[]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(F5,Clients,2,0),\"Nom du client\")","v":"Nom du client"}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(F5,Clients,3,0),\"Adresse\")","v":"Adresse"}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(F5,Clients,4,0),\"CP -VILLE\")","v":"CP -VILLE"}]
[]
[]
["DESCRIPTION DE LA PRESTATION",{"$nulls":3},"MONTANT"]
{"$rows_empty":11}
[{"$nulls":3},"Remise"]
[{"$nulls":3},"TOTAL"]
[{"$nulls":3},"Acompte"]
[{"$nulls":3},"NET A PAYER"]
[{"$nulls":3},"*TVA non applicable , art.293B du CGI*"]
[]
["Conditions de règlement :","Paiement par chèque ou espèces à la fin de la Prestation"]
[null,"Chèque à l'ordre de "]
[]
[]
["Devis n°",null,"Date",null,null,"Montant"]
[]
["Date de l'Acompte",null,"Mode de paiement",null,null,"Montant"]