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

{"sheet":"Clients","index":0,"n_rows":31,"n_cols":6,"rows_kept":31}
["REF_CLIENT","NOM DU CLIENT","ADRESSE","CP - VILLE","TELEPHONE","CONTACT"]
[1,"GOLF CLUB D'ABLEIGES","Chaussée Jules César","95350 - ABLEIGES"]
[2,"BSA SHOP","rue machin","75010 - PARIS"]
[3,"TRIANGLE INTERIM","Rue de l'Eclipse - cs68298","95802 - CERGY PONTOISE"]
[4,"PIANO ROYAL"," 9, rue du Bois Robert","78210 - SAINT CYR-L'ECOLE"]
[5,"GOURMANDIT RECEPTION","20, avenue du Bosquet","95560 - BAILLET EN France"]
[6,"DINOGO"]
[7,"DELAPHOSE"]
[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":45,"n_cols":11,"rows_kept":45,"merged":[[0,0,0,1],[0,2,0,6],[1,0,1,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[11,0,11,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[16,0,16,6],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,6],[23,0,23,6],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4]]}
[null,null,"DEVIS"]
[]
["SERVEUR A LA CARTE",null,null,"Date"]
["Teddy ",null,null,"Réf.Client :"]
["38, boulevard de la République",null,null,"N° de devis :",{"$f":"YEAR(E3)&\"-\"&MONTH(E3)&\"-\"&TEXT(K5,\"0000\")","v":"1900-1-0001"},{"$nulls":5},1]
[]
[]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(E4,BaseClients,2,0),\"Nom du client \")","v":"Nom du client "}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(E4,BaseClients,3,0),\"Adresse \")","v":"Adresse "}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(E4,BaseClients,4,0),\"CP _ VILLE \")","v":"CP _ VILLE "}]
[]
["Description de la Prestation"]
[]
[]
[]
[]
[]
[{"$nulls":3},"Nbre de Personnel ","Nombre d'heures","Taux horaire","Montant"]
[{"$nulls":6},{"$f":"F19*E19*D19","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"F20*E20*D20","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"F21*E21*D21","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"F22*E22*D22","v":{"v":0,"d":"0.00 €"}}]
["Si heures supplémentaires de jour : 40€ de l'heure"]
["Si heures supplémentaires de nuit : 55€ de l'heure"]
[]
[null,null,"Sous total",{"$nulls":3},{"$f":"SUM(G19:G22)","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Remise"]
[null,null,"Montant Total",{"$nulls":3},{"$f":"G26-G27","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Acompte à la signature de 30%",{"$nulls":3},{"$f":"G28*30%","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"NET À PAYER A LA FIN DE LA PRESTATION",{"$nulls":3},{"$f":"G28-G29","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":4},"TVA non applicable, art. 293B du CGI"]
[]
[]
[]
[]
[]
["Paiement à la fin de la prestation "]
[]
["Bon pour accord le :"]
["Signature :"]
[]
["Commentaires :"]
["À la validation du devis, un acompte de 30% vous sera demandé"]
["Validité du devis : 1 semaine"]

{"sheet":"Facture","index":2,"n_rows":35,"n_cols":11,"rows_kept":35,"merged":[[0,0,0,1],[0,2,0,6],[1,0,1,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[11,0,11,6],[12,0,12,4],[12,5,12,6],[13,0,13,4],[13,5,13,6],[14,0,14,4],[14,5,14,6],[15,0,15,4],[15,5,15,6],[16,0,16,4],[16,5,16,6],[17,0,17,4],[17,5,17,6],[18,0,18,4],[18,5,18,6],[19,0,19,4],[19,5,19,6],[20,0,20,4],[20,5,20,6],[22,2,22,4],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,2,25,4],[25,5,25,6],[27,2,27,4],[27,5,27,6],[32,0,32,1],[33,0,33,1],[34,0,34,1]]}
[null,null,"FACTURE"]
[]
["SERVEUR A LA CARTE",null,null,"Date"]
["Teddy ",null,null,"Réf. Client :"]
["38, boulevard de la République",null,null,"N° de facture :",{"$f":"YEAR(E3)&\"-\"&MONTH(E3)&\"-\"&TEXT(K5,\"0000\")","v":"1900-1-0001"},{"$nulls":5},1]
[]
[]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(E4,BaseClients,2,0),\"Nom du client \")","v":"Nom du client "}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(E4,BaseClients,3,0),\"Adresse \")","v":"Adresse "}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(E4,BaseClients,4,0),\"CP - VILLE \")","v":"CP - VILLE "}]
[]
["PRESTATION"]
["DÉSIGNATION",{"$nulls":4},"MONTANT"]
{"$rows_empty":9}
[null,null,"Sous-total",null,null,{"$f":"SUM(F14:G21)","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Remise"]
[null,null,"Montant total ",null,null,{"$f":"F23-F24","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Acompte versé de 30%",null,null,{"$f":"F25*30%","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"NET À PAYER",null,null,{"$f":"F25-F26","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":4},"\"TVA non applicable, art. 293B du CGI\""]
[]
[]
[]
[]
["Paiement à la fin de la prestation ou à réception de facture"]
["par espèces, chèque ou paypal"]