{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"Feuil1","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["الرقم","تاريخ العملية","اسم المنتوج","الكمية","سعر البيع","خصم","المجموع"]
[{"$f":"IF(C7<>0,1,\"\")","v":1},{"$f":"IF(C7<>0,TODAY(),\"\")","v":"2022-03-27"},"فيلتر 1000 ل",1,{"$f":"IF(C7<>0,(VLOOKUP(C7,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":1300},100,{"$f":"IF(C7<>0,((E7*D7)-F7),\"\")","v":1200}]
[{"$f":"IF(C8<>0,A7+1,\"\")","v":2},"2022-03-27","فايتر 1",1,{"$f":"IF(C8<>0,(VLOOKUP(C8,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":600},null,600]
[3,"2022-03-27","فايتر 3",1,{"$f":"IF(C9<>0,(VLOOKUP(C9,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":350},null,350]
[4,"2022-03-27","سخان 100w",1,{"$f":"IF(C10<>0,(VLOOKUP(C10,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":850},50,800]
[5,"2022-03-27","فيلتر  صغير ",1,{"$f":"IF(C11<>0,(VLOOKUP(C11,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":750},50,700]
[6,"2022-03-27","سخان ماء",1,{"$f":"IF(C12<>0,(VLOOKUP(C12,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":250},50,200]
[7,"2022-03-27","ديفيزور",2,{"$f":"IF(C13<>0,(VLOOKUP(C13,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":30},null,60]
[8,"2022-03-27","بوقال 2",1,{"$f":"IF(C14<>0,(VLOOKUP(C14,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":1450},50,1400]
[9,"2022-03-27","فايتر 1",1,{"$f":"IF(C15<>0,(VLOOKUP(C15,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":600},null,600]
[10,"2022-03-27","اكل اسماك كبيرة",1,{"$f":"IF(C16<>0,(VLOOKUP(C16,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":150},50,100]
[11,"2022-03-27","اعشاب اصطناعية ك",2,{"$f":"IF(C17<>0,(VLOOKUP(C17,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":150},null,300]
[12,"2022-03-27","كيم برايقة",1,{"$f":"IF(C18<>0,(VLOOKUP(C18,[1]Feuil2!$B$3:$E$271,4,0)),\"\")","v":200},null,200]
[13,"2022-03-27","صابل حجارة رفيعة",1,{"$f":"IF(C19<>0,VLOOKUP(C19,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":250},50,200]
["","",null,null,{"$f":"IF(C27<>0,VLOOKUP(C20,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C28<>0,VLOOKUP(C21,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C29<>0,VLOOKUP(C22,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C30<>0,VLOOKUP(C23,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C31<>0,VLOOKUP(C24,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C32<>0,VLOOKUP(C25,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C33<>0,VLOOKUP(C26,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C34<>0,VLOOKUP(C27,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C35<>0,VLOOKUP(C28,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C36<>0,VLOOKUP(C29,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C37<>0,VLOOKUP(C30,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C38<>0,VLOOKUP(C31,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C39<>0,VLOOKUP(C32,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C40<>0,VLOOKUP(C33,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C41<>0,VLOOKUP(C34,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C42<>0,VLOOKUP(C35,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"SUM(E7:E35)","v":6930},{"$f":"SUM(F7:F35)","v":400},{"$f":"SUM(G7:G35)","v":6710}]

{"sheet":"Feuil2","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["الرقم","تاريخ العملية","اسم المنتوج","الكمية","سعر البيع","خصم","المجموع"]
[{"$f":"IF(C7<>0,1,\"\")","v":""}]
[{"$f":"IF(C8<>0,A7+1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
["",{"$f":"IF(C20<>0,TODAY(),\"\")","v":""},null,null,{"$f":"IF(C27<>0,VLOOKUP(C20,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,{"$f":"IF(C20<>0,((E20*D20)-F20),\"\")","v":""}]
["","",null,null,{"$f":"IF(C28<>0,VLOOKUP(C21,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C29<>0,VLOOKUP(C22,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C30<>0,VLOOKUP(C23,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C31<>0,VLOOKUP(C24,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C32<>0,VLOOKUP(C25,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C33<>0,VLOOKUP(C26,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C34<>0,VLOOKUP(C27,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C35<>0,VLOOKUP(C28,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C36<>0,VLOOKUP(C29,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C37<>0,VLOOKUP(C30,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C38<>0,VLOOKUP(C31,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C39<>0,VLOOKUP(C32,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C40<>0,VLOOKUP(C33,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C41<>0,VLOOKUP(C34,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
["","",null,null,{"$f":"IF(C42<>0,VLOOKUP(C35,[1]Feuil2!$B$3:$E$271,4,0),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"SUM(E7:E35)","v":0},{"$f":"SUM(F7:F35)","v":0},{"$f":"SUM(G7:G35)","v":0}]