{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["المخزن","رصيد العملاء","INVOICE","DATA SHEET","REPORT","تحصيلات العملاء","مرتجع مبيعات","المشتريات","صرف مخزنى"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":5,"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":"المخزن","index":0,"n_rows":150,"n_cols":12,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
[null,"كود","اسم الصنف","نوع المنتج","رصيد اول مدة","تكلفة اول مدة","القيمة الافتتاحية","وادر","منصرف","رصيد حالى","متوسط التكلفة","قيمة المخزون الحالى"]
[null,1,"oppo F5",null,100,4000,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":400000}]
[null,2,"iphone 7",null,50,5000,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":250000}]
[null,3,"sony z5",null,100,3000,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":300000}]
[null,4,"nokia 3310",null,10,500,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":5000}]
[null,5,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,6,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,7,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,8,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,9,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,10,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,11,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,12,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,13,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,14,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,15,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,16,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,17,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,18,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,19,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,20,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,21,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,22,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,23,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,24,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,25,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,26,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,27,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,28,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,29,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,30,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,31,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,32,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,33,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,34,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,35,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,36,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,37,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,38,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,39,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,40,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,41,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,42,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,43,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,44,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,45,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,46,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,47,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,48,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,49,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,50,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,51,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,52,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,53,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,54,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,55,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,56,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,57,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,58,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,59,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,60,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,61,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,62,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,63,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,64,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,65,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,66,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,67,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,68,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,69,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,70,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,71,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,72,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,73,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,74,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,75,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,76,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,77,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,78,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,79,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,80,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,81,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,82,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,83,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,84,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,85,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,86,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,87,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,88,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,89,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,90,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,91,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,92,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,93,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,94,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,95,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,96,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,97,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,98,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,99,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,100,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,101,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,102,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,103,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,104,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,105,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,106,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,107,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,108,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,109,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,110,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,111,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,112,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,113,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,114,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,115,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,116,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,117,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,118,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,119,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,120,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,121,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,122,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,123,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,124,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,125,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,126,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,127,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,128,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,129,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,130,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,131,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,132,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,133,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,134,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,135,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,136,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,137,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,138,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,139,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,140,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,141,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,142,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,143,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,144,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,145,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,146,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,147,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,null,null,null,null,null,{"$f":"Table1[[#This Row],[رصيد اول مدة]]*Table1[[#This Row],[تكلفة اول مدة]]","v":0}]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table1[القيمة الافتتاحية])","v":955000},null,null,null,null,{"$f":"SUBTOTAL(109,Table1[قيمة المخزون الحالى])","v":0}]

{"sheet":"رصيد العملاء","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["اسم العميل","الفرع","رصيد افتتاحى","مدين","دائن","مرتجع مبيعات","رصيد حالى"]
["Moh"," Mohandseen"]
["Ahmed","October"]
["Capital agro","Obour"]
["wahba","Gamra"]
["Ali","Assuit"]
["mom","Mansora"]

{"sheet":"INVOICE","index":2,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,2,3,3],[5,2,5,6],[4,2,4,5],[24,2,24,4],[25,2,28,4]]}
[]
[]
[]
[null,null,null,null,null,null," INVOICE #"]
[null,null,"ALANDALOUS FOR IMPORT AND EXPORT",null,null,null,8]
[null,null,"INVOICE DETAILS"]
[]
[]
[null,null,"DATE","2018-11-20",null,"TAX","YES"]
[null,null,"CUSTOMER NAME","Capital agro",null,"INVOICE NO",50]
[null,null,"BRANCH",{"$f":"IFERROR(VLOOKUP(D10,Table4[[اسم العميل]:[الفرع]],2,0),\"\")","v":"Obour"},null,"PAYMENT TERMS",40]
[null,null,"SALES PERSON","Abd Alaziz Ahmed",null,"DUE DATE",43454]
[]
[null,null,"SN","PRODUCT","QTY","UNIT PRICE","TOTAL AMOUNT"]
[null,null,1,"oppo F5",10,5000,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":50000}]
[null,null,2,"iphone 7",10,7000,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":70000}]
[null,null,3,"sony z5",5,4000,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":20000}]
[null,null,4,null,null,null,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":0}]
[null,null,5,null,null,null,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":0}]
[null,null,6,null,null,null,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":0}]
[null,null,7,null,null,null,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":0}]
[null,null,8,null,null,null,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":0}]
[null,null,9,null,null,null,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":0}]
[null,null,10,null,null,null,{"$f":"Table12[[#This Row],[Column11]]*Table12[[#This Row],[Column7]]","v":0}]
[null,null,"NOTES",null,null,"TOTAL SALES",{"$f":"SUM(G15:G24)","v":140000}]
[null,null,null,null,null,"DISCOUNT"]
[null,null,null,null,null,"TOTAL ",{"$f":"G25-G26","v":140000}]
[null,null,null,null,null,"WAT TAX 1%",{"$f":"IF(G9=\"YES\",G25*1/100,0)","v":1400}]
[null,null,null,null,null,"VAT TAX 14%",{"$f":"IF(G9=\"YES\",G25*14/100,0)","v":19600}]
[]
[null,null,null,null,null,"FINAL TOTAL",{"$f":"G25-G26-G28+G29","v":158200}]

{"sheet":"DATA SHEET","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["TAX",null,"Branch",null,"Sales Person",null,"Supliers",null,"Payment",null,"Catgory"]
["YES",null," Mohandseen",null,"M.Wahba",null,"KMN",null,"Cash",null,"Motor Oil"]
["NO",null,"October",null,"Abd Alaziz Ahmed",null,"MAS",null,"cheque",null,"Transmission Oil"]
[null,null,"Obour",null,"Omina Rashed",null,"NST",null,"Bank Deposit",null,"Specialty"]
[null,null,"Gamra",null,"Yomna Ashraf",null,null,null,null,null,"Grease"]
[null,null,"Assuit",null,"Ghada Gamal"]
[null,null,"Mansora",null,"Walla Ali"]
[null,null,null,null,"M.Mosalm"]
[null,null,null,null,"Hani Mohamed"]

{"sheet":"REPORT","index":4,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["TOTAL",null,null,null,null,{"$f":"SUM(F5:F1048576)","v":0},{"$f":"SUM(G5:G1048576)","v":0},{"$f":"SUM(H5:H1048576)","v":0},{"$f":"SUM(I5:I1048576)","v":0},{"$f":"SUM(J5:J1048576)","v":0},{"$f":"SUM(K5:K1048576)","v":0},null,null,null,{"$f":"SUM(O5:O1048576)","v":0}]
[]
["التاريخ","اسم العميل","الفرع","مسئول البيع","رقم الفاتورة","اجمالى المبيعات","خصم مسموح","الاجمالى بعد الخصم","ض . ا . ت .ص   1%","ض . ق    14%","صافى الفاتورة","شروط الدفع","تاريخ الاستحقاق","حالة الفاتورة","المتبقى من الفاتورة"]

{"sheet":"تحصيلات العملاء","index":5,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Date","Customer Name","Invoice No","Amount","Payment Type","Receit No","Notes"]

{"sheet":"مرتجع مبيعات","index":6,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Date","Customer Name","Invoice No","Amount","Recall Nu","Notes"]

{"sheet":"المشتريات","index":7,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Date","Suplier Name","Product Name","QTY","Cost","Total Amount"]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
[null,null,null,null,null,{"$f":"Table3[[#This Row],[QTY]]*Table3[[#This Row],[Cost]]","v":0}]
["Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table3[Total Amount])","v":0}]

{"sheet":"صرف مخزنى","index":8,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["التاريخ","اسم العميل","اسم الصنف","الكمية","رقم اذن الصرف","المخزن"]