{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Commande","bas de page facture","bas de page devis"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Commande","index":0,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,2,17,7],[0,3,0,9],[3,3,4,4],[13,5,13,11]]}
[{"$f":"TODAY()","v":"2013-10-27"},null,0,"DEVIS"]
[]
[{"$f":"DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))","v":"2014-10-27"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"chantier :"]
[]
[]
[null,null,null,null,null,"",null,null,null,null,null,null,"",""]
[]
[]
[1,null,false]
["Espèce",null,"LIBELLE ",null,null,null,null,null,"Prix HT","unité","Quantité",{"$f":"IF(DOC_TYPE=1,\"Montant\",\"Montant HT\")","v":"Montant HT"},"tva",null,"tva 7","tva 19,6"]

{"sheet":"bas de page facture","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10]]}
[null,null,"Arrêtée la présente facture à la somme de : "]
[null,null,{"$f":"chiffrelettre(MTTC)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,"TVA2= 19,6 %",{"$f":"OFFSET(F3,-4,10)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"TVA1= 7 %",{"$f":"OFFSET(F3,-4,9)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"MONTANT H.T.",null,null,{"$f":"OFFSET(L4,-5,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,"date de paiement ","a réception de la facture ",null,null,"TVA GLOBALE",null,null,{"$f":"SUM(G3:G4)","v":{"$error":"#REF!"}},null,{"$f":"L6","v":{"$error":"#REF!"}}]
[null,null,null,null,"mode de paiement ","par chèque ",null,null,"ACOMPTE VERSE "]
[null,null,null,null,null,null,null,null,"MONTANT TTC",null,null,{"$f":"SUM(L5:L6)-L7","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,"RESTE A PAYER ",null,null,0]
[null,null,null,null,null,null,null,null,"dont ",0,"de tva "]

{"sheet":"bas de page devis","index":2,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10]]}
[null,null,"Arrêté le présent devis à la somme de : "]
[null,null,{"$f":"chiffrelettre(MTTC)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,"TVA2= 19,6 %",{"$f":"OFFSET(F3,-4,10)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"TVA1= 7 %",{"$f":"OFFSET(F3,-4,9)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"MONTANT H.T.",null,null,{"$f":"OFFSET(L4,-5,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,"date de paiement ","à réception du devis",null,null,"TVA GLOBALE",null,null,{"$f":"SUM(G3:G4)","v":{"$error":"#REF!"}},null,{"$f":"L6","v":{"$error":"#REF!"}}]
[null,null,null,null,"mode de paiement ","par chèque "]
[null,null,null,null,null,null,null,null,"MONTANT TTC",null,null,{"$f":"SUM(L5:L6)-L7","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,null,"Après acceptation, nous retourner un exemplaire de ce devis et de "]
[null,null,"l'attestation daté, signé et précédé de la mention",null,null,null,null,"Le Client ",null,null,"artisan... "]
[]
[null,null,"Bon pour accord  le......./......./2013 "]
[null,null,"Je verse un acompte de 30% soit: 0,00€"]
[]
[null,null,"Comme suite à votre demande, je vous prie de trouver ci-dessous ma meilleure offre de prix "]
[null,null,"établie suivant les éléments que vous avez bien voulu me transmettre: "]