{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["facturation","articles"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"facturation","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,2,1,6]]}
[]
[null,null,"Facturation"]
[]
[]
[null,null,"Code article","                                    D e s i  g n a t i o n","Quantité","P.U  -  H.T","Montant   en  H.T"]
[null,null,null,{"$f":"IF(C6=\"\",\"\",VLOOKUP(C6,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C6=\"\",\"\",VLOOKUP(C6,articles!$C$6:$E$15,3,FALSE))","v":""},{"$f":"IF(F6=\"\",\"\",E6*F6)","v":""}]
[null,null,null,{"$f":"IF(C7=\"\",\"\",VLOOKUP(C7,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C7=\"\",\"\",VLOOKUP(C7,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C9=\"\",\"\",VLOOKUP(C9,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C9=\"\",\"\",VLOOKUP(C9,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,articles!$C$6:$E$15,2,FALSE))","v":""},null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,articles!$C$6:$E$15,3,FALSE))","v":""},""]
[]
[]
[]
[]
[]
[null,null,null,null,"     Montant  HT",null,{"$f":"SUM(G6:G26)","v":0}]
[null,null,null,null,"     TVA",0.2]
[]
[null,null,null,null,"     Montant  TTC",null,{"$f":"G32*(1+F33)","v":0}]

{"sheet":"articles","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Code article","Désignation","Prix unitaire HT"]
[null,null,"b001","CAISSON PLUS 2 ARMOIRES 2 PORTES",250]
[null,null,"b002","BUREAU MDF /1M40 ",325]
[null,null,"b003","TABLE POUR ORDINATEUR",175]
[null,null,"b004","TABLE DE TRAVAIL 2M40 MDF",290]
[null,null,"b005","BIBLIOTHEQUE 4PRTE",445]
[null,null,"b006","ETAGERE DE RANGEMENT",90]
[null,null,"b007","CHAISE ROUL",85]
[null,null,"b008","CHAISE FIXE",70]
[null,null,"b009","CHAISE EN BOIS",105]