{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Base","FACTURIER"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"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":"Base","index":0,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"FONCTION DE RECHERCHE:RECHERCHEV"]
["Référence ","Désignation","PRIX","Stock","Benefice","Prix de revient","Prix d'achat FCFA","Prix d'achat € $","Valeur €","Valeur $","Frais transi"]
["HA33S","ALARME AUTONOME HA33S",{"$f":"F3*1.25","v":148250},1,{"$f":"C3-F3","v":29650},{"$f":"G3+K3","v":118600},{"$f":"H3*I3*J3","v":78600},120,655,1,40000]
["SC84","ALARME AUTONOME IR SC84",{"$f":"F4*1.25","v":76962.5},2,15392.5,61570,61570,94,655,1,0]
["ALC003","ALARME CENTRALE",{"$f":"F5*1.5","v":0},10,0,0,0,0,0,0,0]
["ALC004","ALARME CENTRALE",0,20,0,0,0,0,0,0]
["CM005","CAMERA",0,40,0,0,0]
["CM006","CAMERA",0,75,0,0,0]
["CM007","CAMERA",0,5,0,0,0]
["HKV2032","CAMERA  120 WDR",138240,4,46080,92160,42160,68,1,620,50000]
["HKV2042","CAMERA -IW 120 WDR",152310,2,50770,101540,41540,67,1,620,60000]
["HKV2542","CAMERA -IWS 120db",179280,8,59760,119520,59520,96,1,620,60000]
["HKV7108","ENREGISTREUR ",194160,4,64720,129440,69440,112,1,620,60000]
["HKV012","CAMERA ",0,4,0,0,0]
["HKV013","CAMERA ",0,5,0,0,0,0,0,0]
["CS50","CARTE FREQUENCE S50",1950,8,650,1300,300,0.5,1,600,1000]
["CS70","CARTE FREQUENCE S70",2130,7,710,1420,420,0.7,1,600,1000]
["CF016","CARTE FREQUENCE",0,22,0,0,0]
["RFID01","CLAVIER DIGICODE RFID ACCES",{"$f":"F19*1.25","v":62500},2,12500,50000,50000,50000,1,1]
[]
[null,null,null,null,12500]

{"sheet":"FACTURIER","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,21,26,31],[5,2,6,2],[0,0,2,4]]}
[]
[]
[]
[]
["Code",{"$f":"CONCATENATE(B6,E7)","v":"AZIZEFT0133"}]
["Client","AZIZE",null,"Date:",{"$f":"TODAY()","v":42780}]
["Adresse",null,null,"FACTURE","FT0133"]
["Contact"]
[]
["Référence","Désignation","Qté","Prix unitaire","Montant total"]
["RFID01",{"$f":"VLOOKUP(A11,[1]Base!A3:D200,2,FALSE)","v":"CLAVIER DIGICODE RFID ACCES"},2,{"$f":"VLOOKUP(A11,[2]Base!A3:D200,3,FALSE)","v":62500},{"$f":"C11*D11","v":125000}]
["SC84",{"$f":"VLOOKUP(A12,[1]Base!A3:D201,2,FALSE)","v":"ALARME AUTONOME IR SC84"},1,{"$f":"VLOOKUP(A12,[2]Base!A4:D201,3,FALSE)","v":76962.5},76962.5]
["CF016",{"$f":"VLOOKUP(A13,[1]Base!A3:D202,2,FALSE)","v":"CARTE FREQUENCE"},1,{"$f":"VLOOKUP(A13,[2]Base!A3:D202,3,FALSE)","v":0},0]
["HKV2032",{"$f":"VLOOKUP(A14,[1]Base!A3:D203,2,FALSE)","v":"CAMERA HKV DS-2CD2032F-IW 120 WDR"},3,{"$f":"VLOOKUP(A14,[2]Base!A4:D203,3,FALSE)","v":138240},414720]
["HKV2042",{"$f":"VLOOKUP(A15,[1]Base!A3:D204,2,FALSE)","v":"CAMERA HKV DS-2CD2042WD-IW 120 WDR"},3,{"$f":"VLOOKUP(A15,[2]Base!A3:D204,3,FALSE)","v":152310},456930]
[]
[]
[]
[null,null,null,"Main d'œuvre",45000]
[]
[null,null,null,"Total HT",{"$f":"SUM(E11:E20)","v":1118612.5}]
[null,null,0,"TVA",{"$f":"IF(C22>0,E21*0.18,0)","v":0}]
[null,null,null,"Acompte",0]
[null,null,null,"Net a payer",{"$f":"IF(E23>0,(E21+E22)-E23,E21+E22)","v":1118612.5}]