{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["facturation","articles"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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,3],[1,4,1,5]]}
[]
[null,null,"Facturation",null,"Facture n° :",null,"srt-105"]
[]
[]
[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,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C6=\"\",\"\",VLOOKUP(C6,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},{"$f":"IF(F6=\"\",\"\",E6*F6)","v":""}]
[null,null,null,{"$f":"IF(C7=\"\",\"\",VLOOKUP(C7,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C7=\"\",\"\",VLOOKUP(C7,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C9=\"\",\"\",VLOOKUP(C9,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C9=\"\",\"\",VLOOKUP(C9,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),2,FALSE))","v":""},null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,OFFSET(articles!$C$1:$E$1,0,0,COUNTA(articles!$C:$E)-1),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":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"Code article","Désignation","Prix unitaire HT","Stocks"]
[null,null,"b001","CAISSON PLUS 2 ARMOIRES 2 PORTES",250,2,null,null,3]
[null,null,"b002","BUREAU MDF /1M40 ",325,3,null,null,5]
[null,null,"b003","TABLE POUR ORDINATEUR",175,6,null,null,6]
[null,null,"b004","TABLE DE TRAVAIL 2M40 MDF",290,1,null,null,4]
[null,null,"b005","BIBLIOTHEQUE 4PRTE",445,0,null,null,0]
[null,null,"b006","ETAGERE DE RANGEMENT",90,0,null,null,0]
[null,null,"b007","CHAISE ROUL",85,4,null,null,4]
[null,null,"b008","CHAISE FIXE",70,12,null,null,12]
[null,null,"b009","CHAISE EN BOIS",105,3,null,null,3]
[null,null,"b010","Câble HDMI",18,9,null,null,9]
[null,null,"b011","Imprimante DeskJet HP 1532",159,2,null,null,2]
[null,null,"b012","Carte SD 512 Mo",21,12,null,null,15]