{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["facturation","articles"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":34,"n_cols":7,"rows_kept":34,"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":"IFERROR(VLOOKUP(C5,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C5,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},{"$f":"IF(AND(E5<>\"\",F5<>\"\"),E5*F5,IF(AND(F5<>\"\",E5=\"\"),\"nok\",\"\"))","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C6,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C6,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},{"$f":"IF(AND(E6<>\"\",F6<>\"\"),E6*F6,IF(AND(F6<>\"\",E6=\"\"),\"nok\",\"\"))","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C7,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C7,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C8,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C8,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C9,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C9,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C10,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C10,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C11,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C11,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C12,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C12,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C13,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C13,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C14,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C14,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C15,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C15,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C16,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C16,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C17,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C17,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C18,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C18,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C19,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C19,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C20,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C20,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C21,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C21,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C22,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C22,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C23,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C23,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C24,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C24,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C25,articles!$C$6:$E$15,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C25,articles!$C$6:$E$15,3,FALSE),\"\")","v":""},""]
[]
[]
[]
[]
[]
[null,null,null,null,"     Montant  HT",null,{"$f":"IF(COUNTIF(G5:G25,\"nok\")>0,\"Erreur\",SUM(G5:G25))","v":0}]
[null,null,null,null,"     TVA",0.2,{"$f":"G31*F32","v":0}]
[]
[null,null,null,null,"     Montant  TTC",null,{"$f":"G31+G32","v":0}]

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