{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["facturation","articles"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"facturation","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"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"]
[{"$nulls":3},{"$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":""}]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[{"$nulls":3},{"$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":""},""]
[]
[]
[]
[]
[]
[{"$nulls":4},"     Montant  HT",null,{"$f":"SUM(G6:G26)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":4},"     TVA",{"v":0.2,"d":"20%"}]
[]
[{"$nulls":4},"     Montant  TTC",null,{"$f":"G32*(1+F33)","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"articles","index":1,"n_rows":13,"n_cols":6,"rows_kept":13}
[null,null,"Code article","Désignation","Prix unitaire HT","Stocks"]
[null,null,"b001","CAISSON PLUS 2 ARMOIRES 2 PORTES",{"v":250,"d":"250.00 €"},2]
[null,null,"b002","BUREAU MDF /1M40 ",{"v":325,"d":"325.00 €"},3]
[null,null,"b003","TABLE POUR ORDINATEUR",{"v":175,"d":"175.00 €"},6]
[null,null,"b004","TABLE DE TRAVAIL 2M40 MDF",{"v":290,"d":"290.00 €"},1]
[null,null,"b005","BIBLIOTHEQUE 4PRTE",{"v":445,"d":"445.00 €"},0]
[null,null,"b006","ETAGERE DE RANGEMENT",{"v":90,"d":"90.00 €"},0]
[null,null,"b007","CHAISE ROUL",{"v":85,"d":"85.00 €"},4]
[null,null,"b008","CHAISE FIXE",{"v":70,"d":"70.00 €"},12]
[null,null,"b009","CHAISE EN BOIS",{"v":105,"d":"105.00 €"},3]
[null,null,"b010","Câble HDMI",{"v":18,"d":"18.00 €"},9]
[null,null,"b011","Imprimante DeskJet HP 1532",{"v":159,"d":"159.00 €"},2]
[null,null,"b012","Carte SD 512 Mo",{"v":21,"d":"21.00 €"},12]