{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Base","FACTURIER"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":2,"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":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"FONCTION DE RECHERCHE:RECHERCHEV",null,null,null,null,null,10]
["Référence ","Désignation","PRIX","Stock Départ","Stock","Benefice","Prix de revient","Prix d'achat FCFA","Prix d'achat € $","Valeur €","Valeur $","Frais transi"]
["HA33S","ALARME AUTONOME HA33S",{"$f":"G3*1.25","v":148250},30,{"$f":"D3-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A3)*FACTURIER!$C$11:$C$1000)","v":28},{"$f":"C3-G3","v":29650},{"$f":"H3+L3","v":118600},{"$f":"I3*J3*K3","v":78600},120,655,1,40000]
["SC84","ALARME AUTONOME IR SC84",{"$f":"G4*1.25","v":76962.5},30,{"$f":"D4-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A4)*FACTURIER!$C$11:$C$1000)","v":30},15392.5,61570,61570,94,655,1,0]
["ALC003","ALARME CENTRALE",{"$f":"G5*1.5","v":0},30,{"$f":"D5-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A5)*FACTURIER!$C$11:$C$1000)","v":30},0,0,0,0,0,0,0]
["ALC004","ALARME CENTRALE",0,30,{"$f":"D6-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A6)*FACTURIER!$C$11:$C$1000)","v":30},0,0,0,0,0,0]
["CM005","CAMERA",0,30,{"$f":"D7-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A7)*FACTURIER!$C$11:$C$1000)","v":30},0,0,0]
["CM006","CAMERA",0,30,{"$f":"D8-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A8)*FACTURIER!$C$11:$C$1000)","v":30},0,0,0]
["CM007","CAMERA",0,30,{"$f":"D9-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A9)*FACTURIER!$C$11:$C$1000)","v":30},0,0,0]
["HKV2032","CAMERA  120 WDR",138240,30,{"$f":"D10-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A10)*FACTURIER!$C$11:$C$1000)","v":30},46080,92160,42160,68,1,620,50000]
["HKV2042","CAMERA -IW 120 WDR",152310,30,{"$f":"D11-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A11)*FACTURIER!$C$11:$C$1000)","v":27},50770,101540,41540,67,1,620,60000]
["HKV2542","CAMERA -IWS 120db",179280,30,{"$f":"D12-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A12)*FACTURIER!$C$11:$C$1000)","v":30},59760,119520,59520,96,1,620,60000]
["HKV7108","ENREGISTREUR ",194160,30,{"$f":"D13-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A13)*FACTURIER!$C$11:$C$1000)","v":30},64720,129440,69440,112,1,620,60000]
["HKV012","CAMERA ",0,30,{"$f":"D14-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A14)*FACTURIER!$C$11:$C$1000)","v":27},0,0,0]
["HKV013","CAMERA ",0,30,{"$f":"D15-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A15)*FACTURIER!$C$11:$C$1000)","v":30},0,0,0,0,0,0]
["CS50","CARTE FREQUENCE S50",1950,30,{"$f":"D16-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A16)*FACTURIER!$C$11:$C$1000)","v":24},650,1300,300,0.5,1,600,1000]
["CS70","CARTE FREQUENCE S70",2130,30,{"$f":"D17-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A17)*FACTURIER!$C$11:$C$1000)","v":30},710,1420,420,0.7,1,600,1000]
["CF016","CARTE FREQUENCE",0,30,{"$f":"D18-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A18)*FACTURIER!$C$11:$C$1000)","v":29},0,0,0]
["RFID01","CLAVIER DIGICODE RFID ACCES",{"$f":"G19*1.25","v":62500},30,{"$f":"D19-SUMPRODUCT((FACTURIER!$A$11:$A$1000=Base!A19)*FACTURIER!$C$11:$C$1000)","v":30},12500,50000,50000,50000,1,1]

{"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":42781}]
["Adresse",null,null,"FACTURE","FT0133"]
["Contact"]
[]
["Référence","Désignation","Qté","Prix unitaire","Montant total"]
["ha33s",{"$f":"VLOOKUP(A11,[1]Base!A3:D200,2,FALSE)","v":"ALARME AUTONOME HA33S"},2,{"$f":"VLOOKUP(A11,[2]Base!A3:D200,3,FALSE)","v":148250},{"$f":"C11*D11","v":296500}]
["CS50",{"$f":"VLOOKUP(A12,[1]Base!A3:D201,2,FALSE)","v":"CARTE FREQUENCE S50"},6,{"$f":"VLOOKUP(A12,[2]Base!A4:D201,3,FALSE)","v":1950},11700]
["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]
["HKV012",{"$f":"VLOOKUP(A14,[1]Base!A3:D203,2,FALSE)","v":"CAMERA HKV"},3,{"$f":"VLOOKUP(A14,[2]Base!A4:D203,3,FALSE)","v":0},0]
["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":810130}]
[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":810130}]