{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["facture","Client sponsor","NumFacture"],"not_rendered":{"charts":0,"images":2,"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":"facture","index":0,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,2,1,3],[38,0,38,3],[36,0,36,2],[37,0,37,2]]}
[1,20231013001]
[]
[]
[]
[null,null,""]
[]
[null,"Client"]
[null,null,{"$f":"IFERROR(IF(VLOOKUP($C$5,ListeClients[],1,FALSE)=0,\"\",VLOOKUP($C$5,ListeClients[],1,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(VLOOKUP($C$5,ListeClients[],2,FALSE)=0,\"\",VLOOKUP($C$5,ListeClients[],2,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(VLOOKUP($C$5,ListeClients[],3,FALSE)=0,\"\",VLOOKUP($C$5,ListeClients[],4,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(VLOOKUP($C$5,ListeClients[],4,FALSE)=0,\"\",VLOOKUP($C$5,ListeClients[],4,FALSE)),\"\")","v":""}]
[]
[]
["Date"]
["2023-10-13"]
["N° FACTURE"]
[20231017001]
[]
[]
[]
[]
["Quantité","Désignation","Prix unitaire TTC","Prix total TTC"]
[1,"PARTICIPATION PUBLICITAIRE",45,{"$f":"IF(OR(A23=\"\",C23=\"\"),\"\",A23*C23)","v":45}]
[null,"sur programmes théâtre 2024"]
[null,"\"Silence on tourne\""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total ttc",{"$f":"SUM(D23:D32)","v":45}]
[]
[]
["Chèque libellé à l'ordre du Cercle Théâtral"]
["Virement (IBAN)"]

{"sheet":"Client sponsor","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Nom","métier","adresse"," code postal et ville"]
[" "]
["MR  BERTAUX Freddy","carreleur","5, chemin des 4 vents","79430   La Chapelle Saint Laurent"]
["Ets BLAY","menuisierie","33, rue du Gâts des Noyer","79430   La Chapelle Saint Laurent"]
["MON BRICO",null,"9, avenue de Paris","79320   Moncoutant"]
["CELIO ","meubles","65, route de Niort","79430   La Chapelle Saint Laurent"]
["Garage de la Chapelle","garage","23, route de Bressuire","79430   La Chapelle Saint Laurent"]
["CREDIT MUTUEL BOCASEVRE",null,"6, rue de la HUCHETTE","79300   Bressuire"]
["Mr FAVREAU Nicolas","élagueur","le chiron","79430   La Chapelle Saint Laurent"]
["Les Serres de l'Ouine",null,"les Rataudières","79430   La Chapelle Saint Laurent"]
["GAN assurances","Antony Richard","16 Place du 5 Mai","79300   Bressuire"]
["Sarl GEFFRE  BELLOIN","Charcutier traiteur","20 route de Bressuire","79430   La Chapelle Saint Laurent"]

{"sheet":"NumFacture","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["NumFacture"]
[20231013001]