{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["الرئيسية","فاتورة","المخزون","وارد","ملخص مبيعات"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":"الرئيسية","index":0,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,13,17,17],[18,13,18,17]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,"Best Regards"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr.Emad"]

{"sheet":"فاتورة","index":1,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,1,12,5],[13,1,13,5],[15,1,15,6],[3,3,3,6],[2,3,2,6],[4,1,4,2],[4,3,4,6],[1,3,1,6],[3,1,3,2],[0,1,0,6],[1,1,1,2],[2,1,2,2]]}
[null,"Sales Invoice"]
[null,"رقم الفاتورة ",null,{"$f":"MAX('ملخص مبيعات'!$A:$A)+1","v":27},null,null,null,null,null,null,null,null,null,null,null,null,null,"wesam"]
[null,"التاريخ",null,{"$f":"TODAY()","v":"2020-08-23"},null,null,null,null,null,null,null,null,null,null,null,null,null,"ahmed"]
[null,"اسم العميل",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"omar"]
[null,"رقم الموبايل",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ali"]
[]
[null,"م","اسم الصنف","كود","كميه","السعر","الاجمالى ",null,"رقم الفاتورة ","التاريخ","اسم العميل","رقم الموبايل","اسم الصنف","كود","كميه","السعر","الاجمالى "]
[null,{"$f":"IF(C8=\"\",\"\",1)","v":""},null,{"$f":"IFERROR(VLOOKUP(C8,المخزون!A:B,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C8,المخزون!A:F,6,0),0)","v":0},{"$f":"PRODUCT(F8,E8)","v":0},null,{"$f":"$D$2","v":27},{"$f":"$D$3","v":"2020-08-23"},{"$f":"D4","v":0},{"$f":"D5","v":0},{"$f":"C8","v":0},"",0,0,0]
[null,{"$f":"IF(C9=\"\",\"\",B8+1)","v":""},null,{"$f":"IFERROR(VLOOKUP(C9,المخزون!A:B,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C9,المخزون!A:F,6,0),0)","v":0},0,null,{"$f":"$D$2","v":27},{"$f":"$D$3","v":"2020-08-23"},null,null,0,"",0,0,0]
[null,{"$f":"IF(C10=\"\",\"\",B9+1)","v":""},null,{"$f":"IFERROR(VLOOKUP(C10,المخزون!A:B,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C10,المخزون!A:F,6,0),0)","v":0},0,null,27,"2020-08-23",null,null,0,"",0,0,0]
[null,"",null,{"$f":"IFERROR(VLOOKUP(C11,المخزون!A:B,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C11,المخزون!A:F,6,0),0)","v":0},0,null,27,"2020-08-23",null,null,0,"",0,0,0]
[null,"",null,{"$f":"IFERROR(VLOOKUP(C12,المخزون!A:B,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C12,المخزون!A:F,6,0),0)","v":0},0,null,27,"2020-08-23",null,null,0,"",0,0,0]
[null,"خصم",null,null,null,null,null,null,27,"2020-08-23",null,null,{"$f":"B13","v":"خصم"},{"$f":"D13","v":0},0,0,0]
[null,"إجمالى الفاتورة",null,null,null,null,{"$f":"SUM(G8:G12)-G13","v":0},null,27,"2020-08-23",null,null,{"$f":"B14","v":"إجمالى الفاتورة"},0,0,0,0]
[]
[null,{"$f":"[1]!tafket(G14,\"جنيه\",\"قرش\")","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,"المستخدم:-","wesam"]
[null,null,null,null,null,{"$f":"NOW()","v":44066.700003587961}]

{"sheet":"المخزون","index":2,"n_rows":153,"n_cols":13,"rows_kept":153,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I4:I1048576)","v":1790}]
["اسم الصنف","كود الصنف","وارد  ","سعر الوارد","منصرف","سعر البيع","رصيد أخر","قيمة رصيد اخر تكلفة","الربح",null,null,null,{"$f":"SUMIF(A:A,A4,G:G)>=0","v":true}]
[1,1,{"$f":"SUMIF(وارد!A:A,المخزون!A4,وارد!C:C)","v":10},{"$f":"VLOOKUP(A4,وارد!A:D,4,0)","v":100},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A4,'ملخص مبيعات'!G:G)","v":3},{"$f":"VLOOKUP(A4,وارد!A:F,6,0)","v":150},{"$f":"C4-E4","v":7},{"$f":"G4*D4","v":700},{"$f":"(E4*F4)-(E4*D4)","v":150}]
[2,2,{"$f":"SUMIF(وارد!A:A,المخزون!A5,وارد!C:C)","v":10},{"$f":"VLOOKUP(A5,وارد!A:D,4,0)","v":75},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A5,'ملخص مبيعات'!G:G)","v":8},{"$f":"VLOOKUP(A5,وارد!A:F,6,0)","v":130},{"$f":"C5-E5","v":2},{"$f":"G5*D5","v":150},{"$f":"(E5*F5)-(E5*D5)","v":440}]
[3,3,{"$f":"SUMIF(وارد!A:A,المخزون!A6,وارد!C:C)","v":10},{"$f":"VLOOKUP(A6,وارد!A:D,4,0)","v":85},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A6,'ملخص مبيعات'!G:G)","v":7},{"$f":"VLOOKUP(A6,وارد!A:F,6,0)","v":130},3,255,315]
[4,4,{"$f":"SUMIF(وارد!A:A,المخزون!A7,وارد!C:C)","v":10},{"$f":"VLOOKUP(A7,وارد!A:D,4,0)","v":100},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A7,'ملخص مبيعات'!G:G)","v":2},{"$f":"VLOOKUP(A7,وارد!A:F,6,0)","v":150},8,800,100]
[5,5,{"$f":"SUMIF(وارد!A:A,المخزون!A8,وارد!C:C)","v":10},{"$f":"VLOOKUP(A8,وارد!A:D,4,0)","v":100},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A8,'ملخص مبيعات'!G:G)","v":2},{"$f":"VLOOKUP(A8,وارد!A:F,6,0)","v":150},8,800,100]
[6,6,{"$f":"SUMIF(وارد!A:A,المخزون!A9,وارد!C:C)","v":10},{"$f":"VLOOKUP(A9,وارد!A:D,4,0)","v":125},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A9,'ملخص مبيعات'!G:G)","v":2},{"$f":"VLOOKUP(A9,وارد!A:F,6,0)","v":175},8,1000,100]
[7,7,{"$f":"SUMIF(وارد!A:A,المخزون!A10,وارد!C:C)","v":10},{"$f":"VLOOKUP(A10,وارد!A:D,4,0)","v":150},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A10,'ملخص مبيعات'!G:G)","v":0},{"$f":"VLOOKUP(A10,وارد!A:F,6,0)","v":200},10,1500,0]
[8,8,{"$f":"SUMIF(وارد!A:A,المخزون!A11,وارد!C:C)","v":10},{"$f":"VLOOKUP(A11,وارد!A:D,4,0)","v":130},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A11,'ملخص مبيعات'!G:G)","v":3},{"$f":"VLOOKUP(A11,وارد!A:F,6,0)","v":200},7,910,210]
[9,9,{"$f":"SUMIF(وارد!A:A,المخزون!A12,وارد!C:C)","v":10},{"$f":"VLOOKUP(A12,وارد!A:D,4,0)","v":85},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A12,'ملخص مبيعات'!G:G)","v":0},{"$f":"VLOOKUP(A12,وارد!A:F,6,0)","v":130},10,850,0]
[10,10,{"$f":"SUMIF(وارد!A:A,المخزون!A13,وارد!C:C)","v":10},{"$f":"VLOOKUP(A13,وارد!A:D,4,0)","v":85},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A13,'ملخص مبيعات'!G:G)","v":0},{"$f":"VLOOKUP(A13,وارد!A:F,6,0)","v":130},10,850,0]
[11,11,{"$f":"SUMIF(وارد!A:A,المخزون!A14,وارد!C:C)","v":5},{"$f":"VLOOKUP(A14,وارد!A:D,4,0)","v":125},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A14,'ملخص مبيعات'!G:G)","v":3},{"$f":"VLOOKUP(A14,وارد!A:F,6,0)","v":200},2,250,225]
[12,12,{"$f":"SUMIF(وارد!A:A,المخزون!A15,وارد!C:C)","v":5},{"$f":"VLOOKUP(A15,وارد!A:D,4,0)","v":100},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A15,'ملخص مبيعات'!G:G)","v":1},{"$f":"VLOOKUP(A15,وارد!A:F,6,0)","v":175},4,400,75]
[13,13,{"$f":"SUMIF(وارد!A:A,المخزون!A16,وارد!C:C)","v":5},{"$f":"VLOOKUP(A16,وارد!A:D,4,0)","v":75},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A16,'ملخص مبيعات'!G:G)","v":1},{"$f":"VLOOKUP(A16,وارد!A:F,6,0)","v":150},4,300,75]
[14,14,{"$f":"SUMIF(وارد!A:A,المخزون!A17,وارد!C:C)","v":0},{"$f":"VLOOKUP(A17,وارد!A:D,4,0)","v":0},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A17,'ملخص مبيعات'!G:G)","v":0},{"$f":"VLOOKUP(A17,وارد!A:F,6,0)","v":0},0,0,0]
[15,15,{"$f":"SUMIF(وارد!A:A,المخزون!A18,وارد!C:C)","v":0},{"$f":"VLOOKUP(A18,وارد!A:D,4,0)","v":0},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A18,'ملخص مبيعات'!G:G)","v":0},{"$f":"VLOOKUP(A18,وارد!A:F,6,0)","v":0},0,0,0]
[16,16,{"$f":"SUMIF(وارد!A:A,المخزون!A19,وارد!C:C)","v":0},{"$f":"VLOOKUP(A19,وارد!A:D,4,0)","v":0},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A19,'ملخص مبيعات'!G:G)","v":0},{"$f":"VLOOKUP(A19,وارد!A:F,6,0)","v":0},0,0,0]
[17,17,{"$f":"SUMIF(وارد!A:A,المخزون!A20,وارد!C:C)","v":0},{"$f":"VLOOKUP(A20,وارد!A:D,4,0)","v":0},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A20,'ملخص مبيعات'!G:G)","v":0},{"$f":"VLOOKUP(A20,وارد!A:F,6,0)","v":0},0,0,0]
[18,18,{"$f":"SUMIF(وارد!A:A,المخزون!A21,وارد!C:C)","v":0},{"$f":"VLOOKUP(A21,وارد!A:D,4,0)","v":0},{"$f":"SUMIF('ملخص مبيعات'!E:E,المخزون!A21,'ملخص مبيعات'!G:G)","v":0},{"$f":"VLOOKUP(A21,وارد!A:F,6,0)","v":0},0,0,0]
[19,19,{"$f":"SUMIF(وارد!A:A,المخزون!A22,وارد!C:C)","v":0},{"$f":"VLOOKUP(A22,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A22,وارد!A:F,6,0)","v":0},0,0,0]
[20,20,{"$f":"SUMIF(وارد!A:A,المخزون!A23,وارد!C:C)","v":0},{"$f":"VLOOKUP(A23,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A23,وارد!A:F,6,0)","v":0},0,0,0]
[21,21,{"$f":"SUMIF(وارد!A:A,المخزون!A24,وارد!C:C)","v":0},{"$f":"VLOOKUP(A24,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A24,وارد!A:F,6,0)","v":0},0,0,0]
[22,22,{"$f":"SUMIF(وارد!A:A,المخزون!A25,وارد!C:C)","v":0},{"$f":"VLOOKUP(A25,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A25,وارد!A:F,6,0)","v":0},0,0,0]
[23,23,{"$f":"SUMIF(وارد!A:A,المخزون!A26,وارد!C:C)","v":0},{"$f":"VLOOKUP(A26,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A26,وارد!A:F,6,0)","v":0},0,0,0]
[24,24,{"$f":"SUMIF(وارد!A:A,المخزون!A27,وارد!C:C)","v":0},{"$f":"VLOOKUP(A27,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A27,وارد!A:F,6,0)","v":0},0,0,0]
[25,25,{"$f":"SUMIF(وارد!A:A,المخزون!A28,وارد!C:C)","v":0},{"$f":"VLOOKUP(A28,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A28,وارد!A:F,6,0)","v":0},0,0,0]
[26,26,{"$f":"SUMIF(وارد!A:A,المخزون!A29,وارد!C:C)","v":0},{"$f":"VLOOKUP(A29,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A29,وارد!A:F,6,0)","v":0},0,0,0]
[27,27,{"$f":"SUMIF(وارد!A:A,المخزون!A30,وارد!C:C)","v":0},{"$f":"VLOOKUP(A30,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A30,وارد!A:F,6,0)","v":0},0,0,0]
[28,28,{"$f":"SUMIF(وارد!A:A,المخزون!A31,وارد!C:C)","v":0},{"$f":"VLOOKUP(A31,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A31,وارد!A:F,6,0)","v":0},0,0,0]
[29,29,{"$f":"SUMIF(وارد!A:A,المخزون!A32,وارد!C:C)","v":0},{"$f":"VLOOKUP(A32,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A32,وارد!A:F,6,0)","v":0},0,0,0]
[30,30,{"$f":"SUMIF(وارد!A:A,المخزون!A33,وارد!C:C)","v":0},{"$f":"VLOOKUP(A33,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A33,وارد!A:F,6,0)","v":0},0,0,0]
[31,31,{"$f":"SUMIF(وارد!A:A,المخزون!A34,وارد!C:C)","v":0},{"$f":"VLOOKUP(A34,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A34,وارد!A:F,6,0)","v":0},0,0,0]
[32,32,{"$f":"SUMIF(وارد!A:A,المخزون!A35,وارد!C:C)","v":0},{"$f":"VLOOKUP(A35,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A35,وارد!A:F,6,0)","v":0},0,0,0]
[33,33,{"$f":"SUMIF(وارد!A:A,المخزون!A36,وارد!C:C)","v":0},{"$f":"VLOOKUP(A36,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A36,وارد!A:F,6,0)","v":0},0,0,0]
[34,34,{"$f":"SUMIF(وارد!A:A,المخزون!A37,وارد!C:C)","v":0},{"$f":"VLOOKUP(A37,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A37,وارد!A:F,6,0)","v":0},0,0,0]
[35,35,{"$f":"SUMIF(وارد!A:A,المخزون!A38,وارد!C:C)","v":0},{"$f":"VLOOKUP(A38,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A38,وارد!A:F,6,0)","v":0},0,0,0]
[36,36,{"$f":"SUMIF(وارد!A:A,المخزون!A39,وارد!C:C)","v":0},{"$f":"VLOOKUP(A39,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A39,وارد!A:F,6,0)","v":0},0,0,0]
[37,37,{"$f":"SUMIF(وارد!A:A,المخزون!A40,وارد!C:C)","v":0},{"$f":"VLOOKUP(A40,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A40,وارد!A:F,6,0)","v":0},0,0,0]
[38,38,{"$f":"SUMIF(وارد!A:A,المخزون!A41,وارد!C:C)","v":0},{"$f":"VLOOKUP(A41,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A41,وارد!A:F,6,0)","v":0},0,0,0]
[39,39,{"$f":"SUMIF(وارد!A:A,المخزون!A42,وارد!C:C)","v":0},{"$f":"VLOOKUP(A42,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A42,وارد!A:F,6,0)","v":0},0,0,0]
[40,40,{"$f":"SUMIF(وارد!A:A,المخزون!A43,وارد!C:C)","v":0},{"$f":"VLOOKUP(A43,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A43,وارد!A:F,6,0)","v":0},0,0,0]
[41,41,{"$f":"SUMIF(وارد!A:A,المخزون!A44,وارد!C:C)","v":0},{"$f":"VLOOKUP(A44,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A44,وارد!A:F,6,0)","v":0},0,0,0]
[42,42,{"$f":"SUMIF(وارد!A:A,المخزون!A45,وارد!C:C)","v":0},{"$f":"VLOOKUP(A45,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A45,وارد!A:F,6,0)","v":0},0,0,0]
[43,43,{"$f":"SUMIF(وارد!A:A,المخزون!A46,وارد!C:C)","v":0},{"$f":"VLOOKUP(A46,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A46,وارد!A:F,6,0)","v":0},0,0,0]
[44,44,{"$f":"SUMIF(وارد!A:A,المخزون!A47,وارد!C:C)","v":0},{"$f":"VLOOKUP(A47,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A47,وارد!A:F,6,0)","v":0},0,0,0]
[45,45,{"$f":"SUMIF(وارد!A:A,المخزون!A48,وارد!C:C)","v":0},{"$f":"VLOOKUP(A48,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A48,وارد!A:F,6,0)","v":0},0,0,0]
[46,46,{"$f":"SUMIF(وارد!A:A,المخزون!A49,وارد!C:C)","v":0},{"$f":"VLOOKUP(A49,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A49,وارد!A:F,6,0)","v":0},0,0,0]
[47,47,{"$f":"SUMIF(وارد!A:A,المخزون!A50,وارد!C:C)","v":0},{"$f":"VLOOKUP(A50,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A50,وارد!A:F,6,0)","v":0},0,0,0]
[48,48,{"$f":"SUMIF(وارد!A:A,المخزون!A51,وارد!C:C)","v":0},{"$f":"VLOOKUP(A51,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A51,وارد!A:F,6,0)","v":0},0,0,0]
[49,49,{"$f":"SUMIF(وارد!A:A,المخزون!A52,وارد!C:C)","v":0},{"$f":"VLOOKUP(A52,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A52,وارد!A:F,6,0)","v":0},0,0,0]
[50,50,{"$f":"SUMIF(وارد!A:A,المخزون!A53,وارد!C:C)","v":0},{"$f":"VLOOKUP(A53,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A53,وارد!A:F,6,0)","v":0},0,0,0]
[51,51,{"$f":"SUMIF(وارد!A:A,المخزون!A54,وارد!C:C)","v":0},{"$f":"VLOOKUP(A54,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A54,وارد!A:F,6,0)","v":0},0,0,0]
[52,52,{"$f":"SUMIF(وارد!A:A,المخزون!A55,وارد!C:C)","v":0},{"$f":"VLOOKUP(A55,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A55,وارد!A:F,6,0)","v":0},0,0,0]
[53,53,{"$f":"SUMIF(وارد!A:A,المخزون!A56,وارد!C:C)","v":0},{"$f":"VLOOKUP(A56,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A56,وارد!A:F,6,0)","v":0},0,0,0]
[54,54,{"$f":"SUMIF(وارد!A:A,المخزون!A57,وارد!C:C)","v":0},{"$f":"VLOOKUP(A57,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A57,وارد!A:F,6,0)","v":0},0,0,0]
[55,55,{"$f":"SUMIF(وارد!A:A,المخزون!A58,وارد!C:C)","v":0},{"$f":"VLOOKUP(A58,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A58,وارد!A:F,6,0)","v":0},0,0,0]
[56,56,{"$f":"SUMIF(وارد!A:A,المخزون!A59,وارد!C:C)","v":0},{"$f":"VLOOKUP(A59,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A59,وارد!A:F,6,0)","v":0},0,0,0]
[57,57,{"$f":"SUMIF(وارد!A:A,المخزون!A60,وارد!C:C)","v":0},{"$f":"VLOOKUP(A60,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A60,وارد!A:F,6,0)","v":0},0,0,0]
[58,58,{"$f":"SUMIF(وارد!A:A,المخزون!A61,وارد!C:C)","v":0},{"$f":"VLOOKUP(A61,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A61,وارد!A:F,6,0)","v":0},0,0,0]
[59,59,{"$f":"SUMIF(وارد!A:A,المخزون!A62,وارد!C:C)","v":0},{"$f":"VLOOKUP(A62,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A62,وارد!A:F,6,0)","v":0},0,0,0]
[60,60,{"$f":"SUMIF(وارد!A:A,المخزون!A63,وارد!C:C)","v":0},{"$f":"VLOOKUP(A63,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A63,وارد!A:F,6,0)","v":0},0,0,0]
[61,61,{"$f":"SUMIF(وارد!A:A,المخزون!A64,وارد!C:C)","v":0},{"$f":"VLOOKUP(A64,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A64,وارد!A:F,6,0)","v":0},0,0,0]
[62,62,{"$f":"SUMIF(وارد!A:A,المخزون!A65,وارد!C:C)","v":0},{"$f":"VLOOKUP(A65,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A65,وارد!A:F,6,0)","v":0},0,0,0]
[63,63,{"$f":"SUMIF(وارد!A:A,المخزون!A66,وارد!C:C)","v":0},{"$f":"VLOOKUP(A66,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A66,وارد!A:F,6,0)","v":0},0,0,0]
[64,64,{"$f":"SUMIF(وارد!A:A,المخزون!A67,وارد!C:C)","v":0},{"$f":"VLOOKUP(A67,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A67,وارد!A:F,6,0)","v":0},0,0,0]
[65,65,{"$f":"SUMIF(وارد!A:A,المخزون!A68,وارد!C:C)","v":0},{"$f":"VLOOKUP(A68,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A68,وارد!A:F,6,0)","v":0},0,0,0]
[66,66,{"$f":"SUMIF(وارد!A:A,المخزون!A69,وارد!C:C)","v":0},{"$f":"VLOOKUP(A69,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A69,وارد!A:F,6,0)","v":0},{"$f":"C69-E69","v":0},{"$f":"G69*D69","v":0},{"$f":"(E69*F69)-(E69*D69)","v":0}]
[67,67,{"$f":"SUMIF(وارد!A:A,المخزون!A70,وارد!C:C)","v":0},{"$f":"VLOOKUP(A70,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A70,وارد!A:F,6,0)","v":0},0,0,0]
[68,68,{"$f":"SUMIF(وارد!A:A,المخزون!A71,وارد!C:C)","v":0},{"$f":"VLOOKUP(A71,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A71,وارد!A:F,6,0)","v":0},0,0,0]
[69,69,{"$f":"SUMIF(وارد!A:A,المخزون!A72,وارد!C:C)","v":0},{"$f":"VLOOKUP(A72,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A72,وارد!A:F,6,0)","v":0},0,0,0]
[70,70,{"$f":"SUMIF(وارد!A:A,المخزون!A73,وارد!C:C)","v":0},{"$f":"VLOOKUP(A73,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A73,وارد!A:F,6,0)","v":0},0,0,0]
[71,71,{"$f":"SUMIF(وارد!A:A,المخزون!A74,وارد!C:C)","v":0},{"$f":"VLOOKUP(A74,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A74,وارد!A:F,6,0)","v":0},0,0,0]
[72,72,{"$f":"SUMIF(وارد!A:A,المخزون!A75,وارد!C:C)","v":0},{"$f":"VLOOKUP(A75,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A75,وارد!A:F,6,0)","v":0},0,0,0]
[73,73,{"$f":"SUMIF(وارد!A:A,المخزون!A76,وارد!C:C)","v":0},{"$f":"VLOOKUP(A76,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A76,وارد!A:F,6,0)","v":0},0,0,0]
[74,74,{"$f":"SUMIF(وارد!A:A,المخزون!A77,وارد!C:C)","v":0},{"$f":"VLOOKUP(A77,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A77,وارد!A:F,6,0)","v":0},0,0,0]
[75,75,{"$f":"SUMIF(وارد!A:A,المخزون!A78,وارد!C:C)","v":0},{"$f":"VLOOKUP(A78,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A78,وارد!A:F,6,0)","v":0},0,0,0]
[76,76,{"$f":"SUMIF(وارد!A:A,المخزون!A79,وارد!C:C)","v":0},{"$f":"VLOOKUP(A79,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A79,وارد!A:F,6,0)","v":0},0,0,0]
[77,77,{"$f":"SUMIF(وارد!A:A,المخزون!A80,وارد!C:C)","v":0},{"$f":"VLOOKUP(A80,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A80,وارد!A:F,6,0)","v":0},0,0,0]
[78,78,{"$f":"SUMIF(وارد!A:A,المخزون!A81,وارد!C:C)","v":0},{"$f":"VLOOKUP(A81,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A81,وارد!A:F,6,0)","v":0},0,0,0]
[79,79,{"$f":"SUMIF(وارد!A:A,المخزون!A82,وارد!C:C)","v":0},{"$f":"VLOOKUP(A82,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A82,وارد!A:F,6,0)","v":0},0,0,0]
[80,80,{"$f":"SUMIF(وارد!A:A,المخزون!A83,وارد!C:C)","v":0},{"$f":"VLOOKUP(A83,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A83,وارد!A:F,6,0)","v":0},0,0,0]
[81,81,{"$f":"SUMIF(وارد!A:A,المخزون!A84,وارد!C:C)","v":0},{"$f":"VLOOKUP(A84,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A84,وارد!A:F,6,0)","v":0},0,0,0]
[82,82,{"$f":"SUMIF(وارد!A:A,المخزون!A85,وارد!C:C)","v":0},{"$f":"VLOOKUP(A85,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A85,وارد!A:F,6,0)","v":0},0,0,0]
[83,83,{"$f":"SUMIF(وارد!A:A,المخزون!A86,وارد!C:C)","v":0},{"$f":"VLOOKUP(A86,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A86,وارد!A:F,6,0)","v":0},0,0,0]
[84,84,{"$f":"SUMIF(وارد!A:A,المخزون!A87,وارد!C:C)","v":0},{"$f":"VLOOKUP(A87,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A87,وارد!A:F,6,0)","v":0},0,0,0]
[85,85,{"$f":"SUMIF(وارد!A:A,المخزون!A88,وارد!C:C)","v":0},{"$f":"VLOOKUP(A88,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A88,وارد!A:F,6,0)","v":0},0,0,0]
[86,86,{"$f":"SUMIF(وارد!A:A,المخزون!A89,وارد!C:C)","v":0},{"$f":"VLOOKUP(A89,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A89,وارد!A:F,6,0)","v":0},0,0,0]
[87,87,{"$f":"SUMIF(وارد!A:A,المخزون!A90,وارد!C:C)","v":0},{"$f":"VLOOKUP(A90,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A90,وارد!A:F,6,0)","v":0},0,0,0]
[88,88,{"$f":"SUMIF(وارد!A:A,المخزون!A91,وارد!C:C)","v":0},{"$f":"VLOOKUP(A91,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A91,وارد!A:F,6,0)","v":0},0,0,0]
[89,89,{"$f":"SUMIF(وارد!A:A,المخزون!A92,وارد!C:C)","v":0},{"$f":"VLOOKUP(A92,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A92,وارد!A:F,6,0)","v":0},0,0,0]
[90,90,{"$f":"SUMIF(وارد!A:A,المخزون!A93,وارد!C:C)","v":0},{"$f":"VLOOKUP(A93,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A93,وارد!A:F,6,0)","v":0},0,0,0]
[91,91,{"$f":"SUMIF(وارد!A:A,المخزون!A94,وارد!C:C)","v":0},{"$f":"VLOOKUP(A94,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A94,وارد!A:F,6,0)","v":0},0,0,0]
[92,92,{"$f":"SUMIF(وارد!A:A,المخزون!A95,وارد!C:C)","v":0},{"$f":"VLOOKUP(A95,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A95,وارد!A:F,6,0)","v":0},0,0,0]
[93,93,{"$f":"SUMIF(وارد!A:A,المخزون!A96,وارد!C:C)","v":0},{"$f":"VLOOKUP(A96,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A96,وارد!A:F,6,0)","v":0},0,0,0]
[94,94,{"$f":"SUMIF(وارد!A:A,المخزون!A97,وارد!C:C)","v":0},{"$f":"VLOOKUP(A97,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A97,وارد!A:F,6,0)","v":0},0,0,0]
[95,95,{"$f":"SUMIF(وارد!A:A,المخزون!A98,وارد!C:C)","v":0},{"$f":"VLOOKUP(A98,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A98,وارد!A:F,6,0)","v":0},0,0,0]
[96,96,{"$f":"SUMIF(وارد!A:A,المخزون!A99,وارد!C:C)","v":0},{"$f":"VLOOKUP(A99,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A99,وارد!A:F,6,0)","v":0},0,0,0]
[97,97,{"$f":"SUMIF(وارد!A:A,المخزون!A100,وارد!C:C)","v":0},{"$f":"VLOOKUP(A100,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A100,وارد!A:F,6,0)","v":0},0,0,0]
[98,98,{"$f":"SUMIF(وارد!A:A,المخزون!A101,وارد!C:C)","v":0},{"$f":"VLOOKUP(A101,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A101,وارد!A:F,6,0)","v":0},0,0,0]
[99,99,{"$f":"SUMIF(وارد!A:A,المخزون!A102,وارد!C:C)","v":0},{"$f":"VLOOKUP(A102,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A102,وارد!A:F,6,0)","v":0},0,0,0]
[100,100,{"$f":"SUMIF(وارد!A:A,المخزون!A103,وارد!C:C)","v":0},{"$f":"VLOOKUP(A103,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A103,وارد!A:F,6,0)","v":0},0,0,0]
[101,101,{"$f":"SUMIF(وارد!A:A,المخزون!A104,وارد!C:C)","v":0},{"$f":"VLOOKUP(A104,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A104,وارد!A:F,6,0)","v":0},0,0,0]
[102,102,{"$f":"SUMIF(وارد!A:A,المخزون!A105,وارد!C:C)","v":0},{"$f":"VLOOKUP(A105,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A105,وارد!A:F,6,0)","v":0},0,0,0]
[103,103,{"$f":"SUMIF(وارد!A:A,المخزون!A106,وارد!C:C)","v":0},{"$f":"VLOOKUP(A106,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A106,وارد!A:F,6,0)","v":0},0,0,0]
[104,104,{"$f":"SUMIF(وارد!A:A,المخزون!A107,وارد!C:C)","v":0},{"$f":"VLOOKUP(A107,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A107,وارد!A:F,6,0)","v":0},0,0,0]
[105,105,{"$f":"SUMIF(وارد!A:A,المخزون!A108,وارد!C:C)","v":0},{"$f":"VLOOKUP(A108,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A108,وارد!A:F,6,0)","v":0},0,0,0]
[106,106,{"$f":"SUMIF(وارد!A:A,المخزون!A109,وارد!C:C)","v":0},{"$f":"VLOOKUP(A109,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A109,وارد!A:F,6,0)","v":0},0,0,0]
[107,107,{"$f":"SUMIF(وارد!A:A,المخزون!A110,وارد!C:C)","v":0},{"$f":"VLOOKUP(A110,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A110,وارد!A:F,6,0)","v":0},0,0,0]
[108,108,{"$f":"SUMIF(وارد!A:A,المخزون!A111,وارد!C:C)","v":0},{"$f":"VLOOKUP(A111,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A111,وارد!A:F,6,0)","v":0},0,0,0]
[109,109,{"$f":"SUMIF(وارد!A:A,المخزون!A112,وارد!C:C)","v":0},{"$f":"VLOOKUP(A112,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A112,وارد!A:F,6,0)","v":0},0,0,0]
[110,110,{"$f":"SUMIF(وارد!A:A,المخزون!A113,وارد!C:C)","v":0},{"$f":"VLOOKUP(A113,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A113,وارد!A:F,6,0)","v":0},0,0,0]
[111,111,{"$f":"SUMIF(وارد!A:A,المخزون!A114,وارد!C:C)","v":0},{"$f":"VLOOKUP(A114,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A114,وارد!A:F,6,0)","v":0},0,0,0]
[112,112,{"$f":"SUMIF(وارد!A:A,المخزون!A115,وارد!C:C)","v":0},{"$f":"VLOOKUP(A115,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A115,وارد!A:F,6,0)","v":0},0,0,0]
[113,113,{"$f":"SUMIF(وارد!A:A,المخزون!A116,وارد!C:C)","v":0},{"$f":"VLOOKUP(A116,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A116,وارد!A:F,6,0)","v":0},0,0,0]
[114,114,{"$f":"SUMIF(وارد!A:A,المخزون!A117,وارد!C:C)","v":0},{"$f":"VLOOKUP(A117,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A117,وارد!A:F,6,0)","v":0},0,0,0]
[115,115,{"$f":"SUMIF(وارد!A:A,المخزون!A118,وارد!C:C)","v":0},{"$f":"VLOOKUP(A118,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A118,وارد!A:F,6,0)","v":0},0,0,0]
[116,116,{"$f":"SUMIF(وارد!A:A,المخزون!A119,وارد!C:C)","v":0},{"$f":"VLOOKUP(A119,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A119,وارد!A:F,6,0)","v":0},0,0,0]
[117,117,{"$f":"SUMIF(وارد!A:A,المخزون!A120,وارد!C:C)","v":0},{"$f":"VLOOKUP(A120,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A120,وارد!A:F,6,0)","v":0},0,0,0]
[118,118,{"$f":"SUMIF(وارد!A:A,المخزون!A121,وارد!C:C)","v":0},{"$f":"VLOOKUP(A121,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A121,وارد!A:F,6,0)","v":0},0,0,0]
[119,119,{"$f":"SUMIF(وارد!A:A,المخزون!A122,وارد!C:C)","v":0},{"$f":"VLOOKUP(A122,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A122,وارد!A:F,6,0)","v":0},0,0,0]
[120,120,{"$f":"SUMIF(وارد!A:A,المخزون!A123,وارد!C:C)","v":0},{"$f":"VLOOKUP(A123,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A123,وارد!A:F,6,0)","v":0},0,0,0]
[121,121,{"$f":"SUMIF(وارد!A:A,المخزون!A124,وارد!C:C)","v":0},{"$f":"VLOOKUP(A124,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A124,وارد!A:F,6,0)","v":0},0,0,0]
[122,122,{"$f":"SUMIF(وارد!A:A,المخزون!A125,وارد!C:C)","v":0},{"$f":"VLOOKUP(A125,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A125,وارد!A:F,6,0)","v":0},0,0,0]
[123,123,{"$f":"SUMIF(وارد!A:A,المخزون!A126,وارد!C:C)","v":0},{"$f":"VLOOKUP(A126,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A126,وارد!A:F,6,0)","v":0},0,0,0]
[124,124,{"$f":"SUMIF(وارد!A:A,المخزون!A127,وارد!C:C)","v":0},{"$f":"VLOOKUP(A127,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A127,وارد!A:F,6,0)","v":0},0,0,0]
[125,125,{"$f":"SUMIF(وارد!A:A,المخزون!A128,وارد!C:C)","v":0},{"$f":"VLOOKUP(A128,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A128,وارد!A:F,6,0)","v":0},0,0,0]
[126,126,{"$f":"SUMIF(وارد!A:A,المخزون!A129,وارد!C:C)","v":0},{"$f":"VLOOKUP(A129,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A129,وارد!A:F,6,0)","v":0},0,0,0]
[127,127,{"$f":"SUMIF(وارد!A:A,المخزون!A130,وارد!C:C)","v":0},{"$f":"VLOOKUP(A130,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A130,وارد!A:F,6,0)","v":0},0,0,0]
[128,128,{"$f":"SUMIF(وارد!A:A,المخزون!A131,وارد!C:C)","v":0},{"$f":"VLOOKUP(A131,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A131,وارد!A:F,6,0)","v":0},0,0,0]
[129,129,{"$f":"SUMIF(وارد!A:A,المخزون!A132,وارد!C:C)","v":0},{"$f":"VLOOKUP(A132,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A132,وارد!A:F,6,0)","v":0},0,0,0]
[130,130,{"$f":"SUMIF(وارد!A:A,المخزون!A133,وارد!C:C)","v":0},{"$f":"VLOOKUP(A133,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A133,وارد!A:F,6,0)","v":0},{"$f":"C133-E133","v":0},{"$f":"G133*D133","v":0},{"$f":"(E133*F133)-(E133*D133)","v":0}]
[131,131,{"$f":"SUMIF(وارد!A:A,المخزون!A134,وارد!C:C)","v":0},{"$f":"VLOOKUP(A134,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A134,وارد!A:F,6,0)","v":0},0,0,0]
[132,132,{"$f":"SUMIF(وارد!A:A,المخزون!A135,وارد!C:C)","v":0},{"$f":"VLOOKUP(A135,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A135,وارد!A:F,6,0)","v":0},0,0,0]
[133,133,{"$f":"SUMIF(وارد!A:A,المخزون!A136,وارد!C:C)","v":0},{"$f":"VLOOKUP(A136,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A136,وارد!A:F,6,0)","v":0},0,0,0]
[134,134,{"$f":"SUMIF(وارد!A:A,المخزون!A137,وارد!C:C)","v":0},{"$f":"VLOOKUP(A137,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A137,وارد!A:F,6,0)","v":0},0,0,0]
[135,135,{"$f":"SUMIF(وارد!A:A,المخزون!A138,وارد!C:C)","v":0},{"$f":"VLOOKUP(A138,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A138,وارد!A:F,6,0)","v":0},0,0,0]
[136,136,{"$f":"SUMIF(وارد!A:A,المخزون!A139,وارد!C:C)","v":0},{"$f":"VLOOKUP(A139,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A139,وارد!A:F,6,0)","v":0},0,0,0]
[137,137,{"$f":"SUMIF(وارد!A:A,المخزون!A140,وارد!C:C)","v":0},{"$f":"VLOOKUP(A140,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A140,وارد!A:F,6,0)","v":0},0,0,0]
[138,138,{"$f":"SUMIF(وارد!A:A,المخزون!A141,وارد!C:C)","v":0},{"$f":"VLOOKUP(A141,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A141,وارد!A:F,6,0)","v":0},0,0,0]
[139,139,{"$f":"SUMIF(وارد!A:A,المخزون!A142,وارد!C:C)","v":0},{"$f":"VLOOKUP(A142,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A142,وارد!A:F,6,0)","v":0},0,0,0]
[140,140,{"$f":"SUMIF(وارد!A:A,المخزون!A143,وارد!C:C)","v":0},{"$f":"VLOOKUP(A143,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A143,وارد!A:F,6,0)","v":0},0,0,0]
[141,141,{"$f":"SUMIF(وارد!A:A,المخزون!A144,وارد!C:C)","v":0},{"$f":"VLOOKUP(A144,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A144,وارد!A:F,6,0)","v":0},0,0,0]
[142,142,{"$f":"SUMIF(وارد!A:A,المخزون!A145,وارد!C:C)","v":0},{"$f":"VLOOKUP(A145,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A145,وارد!A:F,6,0)","v":0},0,0,0]
[143,143,{"$f":"SUMIF(وارد!A:A,المخزون!A146,وارد!C:C)","v":0},{"$f":"VLOOKUP(A146,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A146,وارد!A:F,6,0)","v":0},0,0,0]
[144,144,{"$f":"SUMIF(وارد!A:A,المخزون!A147,وارد!C:C)","v":0},{"$f":"VLOOKUP(A147,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A147,وارد!A:F,6,0)","v":0},0,0,0]
[145,145,{"$f":"SUMIF(وارد!A:A,المخزون!A148,وارد!C:C)","v":0},{"$f":"VLOOKUP(A148,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A148,وارد!A:F,6,0)","v":0},0,0,0]
[146,146,{"$f":"SUMIF(وارد!A:A,المخزون!A149,وارد!C:C)","v":0},{"$f":"VLOOKUP(A149,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A149,وارد!A:F,6,0)","v":0},0,0,0]
[147,147,{"$f":"SUMIF(وارد!A:A,المخزون!A150,وارد!C:C)","v":0},{"$f":"VLOOKUP(A150,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A150,وارد!A:F,6,0)","v":0},0,0,0]
[148,148,{"$f":"SUMIF(وارد!A:A,المخزون!A151,وارد!C:C)","v":0},{"$f":"VLOOKUP(A151,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A151,وارد!A:F,6,0)","v":0},0,0,0]
[149,149,{"$f":"SUMIF(وارد!A:A,المخزون!A152,وارد!C:C)","v":0},{"$f":"VLOOKUP(A152,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A152,وارد!A:F,6,0)","v":0},0,0,0]
[150,150,{"$f":"SUMIF(وارد!A:A,المخزون!A153,وارد!C:C)","v":0},{"$f":"VLOOKUP(A153,وارد!A:D,4,0)","v":0},null,{"$f":"VLOOKUP(A153,وارد!A:F,6,0)","v":0},0,0,0]

{"sheet":"وارد","index":3,"n_rows":154,"n_cols":6,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["اسم الصنف","كود الصنف","كمية ","سعر ","قيمة","سعر البيع"]
[1,1,10,100,{"$f":"C5*D5","v":1000},150]
[2,2,10,75,{"$f":"C6*D6","v":750},130]
[3,3,10,85,850,130]
[4,4,10,100,1000,150]
[5,5,10,100,1000,150]
[6,6,10,125,1250,175]
[7,7,10,150,1500,200]
[8,8,10,130,1300,200]
[9,9,10,85,850,130]
[10,10,10,85,850,130]
[11,11,5,125,625,200]
[12,12,5,100,500,175]
[13,13,5,75,375,150]
[14,14]
[15,15]
[16,16]
[17,17]
[18,18]
[19,19]
[20,20]
[21,21]
[22,22]
[23,23]
[24,24]
[25,25]
[26,26]
[27,27]
[28,28]
[29,29]
[30,30]
[31,31]
[32,32]
[33,33]
[34,34]
[35,35]
[36,36]
[37,37]
[38,38]
[39,39]
[40,40]
[41,41]
[42,42]
[43,43]
[44,44]
[45,45]
[46,46]
[47,47]
[48,48]
[49,49]
[50,50]
[51,51]
[52,52]
[53,53]
[54,54]
[55,55]
[56,56]
[57,57]
[58,58]
[59,59]
[60,60]
[61,61]
[62,62]
[63,63]
[64,64]
[65,65]
[66,66]
[67,67]
[68,68]
[69,69]
[70,70]
[71,71]
[72,72]
[73,73]
[74,74]
[75,75]
[76,76]
[77,77]
[78,78]
[79,79]
[80,80]
[81,81]
[82,82]
[83,83]
[84,84]
[85,85]
[86,86]
[87,87]
[88,88]
[89,89]
[90,90]
[91,91]
[92,92]
[93,93]
[94,94]
[95,95]
[96,96]
[97,97]
[98,98]
[99,99]
[100,100]
[101,101]
[102,102]
[103,103]
[104,104]
[105,105]
[106,106]
[107,107]
[108,108]
[109,109]
[110,110]
[111,111]
[112,112]
[113,113]
[114,114]
[115,115]
[116,116]
[117,117]
[118,118]
[119,119]
[120,120]
[121,121]
[122,122]
[123,123]
[124,124]
[125,125]
[126,126]
[127,127]
[128,128]
[129,129]
[130,130]
[131,131]
[132,132]
[133,133]
[134,134]
[135,135]
[136,136]
[137,137]
[138,138]
[139,139]
[140,140]
[141,141]
[142,142]
[143,143]
[144,144]
[145,145]
[146,146]
[147,147]
[148,148]
[149,149]
[150,150]

{"sheet":"ملخص مبيعات","index":4,"n_rows":187,"n_cols":9,"rows_kept":187,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["رقم الفاتورة ","التاريخ","اسم العميل","رقم الموبايل","اسم الصنف","كود","كميه","السعر","الاجمالى "]
[]
[26,"2020-08-23",0,0,0,"",0,0,0]
[26,"2020-08-23",null,null,0,"",0,0,0]
[26,"2020-08-23",null,null,0,"",0,0,0]
[26,"2020-08-23",null,null,0,"",0,0,0]
[26,"2020-08-23",null,null,0,"",0,0,0]
[26,"2020-08-23",null,null,"خصم",0,0,0,0]
[26,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[25,"2020-08-23",0,0,0,"",0,0,0]
[25,"2020-08-23",null,null,0,"",0,0,0]
[25,"2020-08-23",null,null,0,"",0,0,0]
[25,"2020-08-23",null,null,0,"",0,0,0]
[25,"2020-08-23",null,null,0,"",0,0,0]
[25,"2020-08-23",null,null,"خصم",0,0,0,0]
[25,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[24,"2020-08-23",0,0,0,"",0,0,0]
[24,"2020-08-23",null,null,0,"",0,0,0]
[24,"2020-08-23",null,null,0,"",0,0,0]
[24,"2020-08-23",null,null,0,"",0,0,0]
[24,"2020-08-23",null,null,0,"",0,0,0]
[24,"2020-08-23",null,null,"خصم",0,0,0,0]
[24,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[23,"2020-08-23",0,0,0,"",0,0,0]
[23,"2020-08-23",null,null,0,"",0,0,0]
[23,"2020-08-23",null,null,0,"",0,0,0]
[23,"2020-08-23",null,null,0,"",0,0,0]
[23,"2020-08-23",null,null,0,"",0,0,0]
[23,"2020-08-23",null,null,"خصم",0,0,0,0]
[23,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[22,"2020-08-23",0,0,0,"",0,0,0]
[22,"2020-08-23",null,null,0,"",0,0,0]
[22,"2020-08-23",null,null,0,"",0,0,0]
[22,"2020-08-23",null,null,0,"",0,0,0]
[22,"2020-08-23",null,null,0,"",0,0,0]
[22,"2020-08-23",null,null,"خصم",0,0,0,0]
[22,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[21,"2020-08-23",0,0,0,"",0,0,0]
[21,"2020-08-23",null,null,0,"",0,0,0]
[21,"2020-08-23",null,null,0,"",0,0,0]
[21,"2020-08-23",null,null,0,"",0,0,0]
[21,"2020-08-23",null,null,0,"",0,0,0]
[21,"2020-08-23",null,null,"خصم",0,0,0,0]
[21,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[20,"2020-08-23",0,0,0,"",0,0,0]
[20,"2020-08-23",null,null,0,"",0,0,0]
[20,"2020-08-23",null,null,0,"",0,0,0]
[20,"2020-08-23",null,null,0,"",0,0,0]
[20,"2020-08-23",null,null,0,"",0,0,0]
[20,"2020-08-23",null,null,"خصم",0,0,0,0]
[20,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[19,"2020-08-23",0,0,0,"",0,0,0]
[19,"2020-08-23",null,null,0,"",0,0,0]
[19,"2020-08-23",null,null,0,"",0,0,0]
[19,"2020-08-23",null,null,0,"",0,0,0]
[19,"2020-08-23",null,null,0,"",0,0,0]
[19,"2020-08-23",null,null,"خصم",0,0,0,0]
[19,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[18,"2020-08-23",0,0,0,"",0,0,0]
[18,"2020-08-23",null,null,0,"",0,0,0]
[18,"2020-08-23",null,null,0,"",0,0,0]
[18,"2020-08-23",null,null,0,"",0,0,0]
[18,"2020-08-23",null,null,0,"",0,0,0]
[18,"2020-08-23",null,null,"خصم",0,0,0,0]
[18,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[17,"2020-08-23",0,0,0,"",0,0,0]
[17,"2020-08-23",null,null,0,"",0,0,0]
[17,"2020-08-23",null,null,0,"",0,0,0]
[17,"2020-08-23",null,null,0,"",0,0,0]
[17,"2020-08-23",null,null,0,"",0,0,0]
[17,"2020-08-23",null,null,"خصم",0,0,0,0]
[17,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[16,"2020-08-23",0,0,0,"",0,0,0]
[16,"2020-08-23",null,null,0,"",0,0,0]
[16,"2020-08-23",null,null,0,"",0,0,0]
[16,"2020-08-23",null,null,0,"",0,0,0]
[16,"2020-08-23",null,null,0,"",0,0,0]
[16,"2020-08-23",null,null,"خصم",0,0,0,0]
[16,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[15,"2020-08-23",0,0,0,"",0,0,0]
[15,"2020-08-23",null,null,0,"",0,0,0]
[15,"2020-08-23",null,null,0,"",0,0,0]
[15,"2020-08-23",null,null,0,"",0,0,0]
[15,"2020-08-23",null,null,0,"",0,0,0]
[15,"2020-08-23",null,null,"خصم",0,0,0,0]
[15,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[14,"2020-08-23",0,0,0,"",0,0,0]
[14,"2020-08-23",null,null,0,"",0,0,0]
[14,"2020-08-23",null,null,0,"",0,0,0]
[14,"2020-08-23",null,null,0,"",0,0,0]
[14,"2020-08-23",null,null,0,"",0,0,0]
[14,"2020-08-23",null,null,"خصم",0,0,0,0]
[14,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[13,"2020-08-23",0,0,0,"",0,0,0]
[13,"2020-08-23",null,null,0,"",0,0,0]
[13,"2020-08-23",null,null,0,"",0,0,0]
[13,"2020-08-23",null,null,0,"",0,0,0]
[13,"2020-08-23",null,null,0,"",0,0,0]
[13,"2020-08-23",null,null,"خصم",0,0,0,0]
[13,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[12,"2020-08-23","نها",1266356566,8,8,1,200,200]
[12,"2020-08-23",null,null,0,"",0,0,0]
[12,"2020-08-23",null,null,0,"",0,0,0]
[12,"2020-08-23",null,null,0,"",0,0,0]
[12,"2020-08-23",null,null,0,"",0,0,0]
[12,"2020-08-23",null,null,"خصم",0,0,0,0]
[12,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,200]
[11,"2020-08-23","عاطف الطويل",1023654123,1,1,1,150,150]
[11,"2020-08-23",null,null,2,2,1,130,130]
[11,"2020-08-23",null,null,3,3,1,130,130]
[11,"2020-08-23",null,null,0,"",0,0,0]
[11,"2020-08-23",null,null,0,"",0,0,0]
[11,"2020-08-23",null,null,"خصم",0,0,0,10]
[11,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,400]
[10,"2020-08-23","سيف",1236547896,2,2,1,130,130]
[10,"2020-08-23",null,null,3,3,1,130,130]
[10,"2020-08-23",null,null,0,"",0,0,0]
[10,"2020-08-23",null,null,0,"",0,0,0]
[10,"2020-08-23",null,null,0,"",0,0,0]
[10,"2020-08-23",null,null,"خصم",0,0,0,0]
[10,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,260]
[9,"2020-08-23","سيف",1236547896,1,1,0,150,150]
[9,"2020-08-23",null,null,2,2,0,130,130]
[9,"2020-08-23",null,null,0,"",0,0,0]
[9,"2020-08-23",null,null,0,"",0,0,0]
[9,"2020-08-23",null,null,0,"",0,0,0]
[9,"2020-08-23",null,null,"خصم",0,0,0,0]
[9,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,280]
[8,"2020-08-23","سيف",1236547896,0,"",0,0,0]
[8,"2020-08-23",null,null,0,"",0,0,0]
[8,"2020-08-23",null,null,0,"",0,0,0]
[8,"2020-08-23",null,null,0,"",0,0,0]
[8,"2020-08-23",null,null,0,"",0,0,0]
[8,"2020-08-23",null,null,"خصم",0,0,0,0]
[8,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,0]
[7,"2020-08-23","سيف",1236547896,1,1,1,150,150]
[7,"2020-08-23",null,null,2,2,1,130,130]
[7,"2020-08-23",null,null,0,"",0,0,0]
[7,"2020-08-23",null,null,0,"",0,0,0]
[7,"2020-08-23",null,null,0,"",0,0,0]
[7,"2020-08-23",null,null,"خصم",0,0,0,0]
[7,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,280]
[6,"2020-08-23","رنا",1234569852,6,6,2,175,350]
[6,"2020-08-23",null,null,8,8,2,200,400]
[6,"2020-08-23",null,null,11,11,2,200,400]
[6,"2020-08-23",null,null,0,"",0,0,0]
[6,"2020-08-23",null,null,0,"",0,0,0]
[6,"2020-08-23",null,null,"خصم",0,0,0,0]
[6,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,1150]
[5,"2020-08-23","عمر ",125655665656,11,11,1,200,200]
[5,"2020-08-23",null,null,12,12,1,175,175]
[5,"2020-08-23",null,null,13,13,1,150,150]
[5,"2020-08-23",null,null,0,"",0,0,0]
[5,"2020-08-23",null,null,0,"",0,0,0]
[5,"2020-08-23",null,null,"خصم",0,0,0,0]
[5,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,525]
[4,"2020-08-23","هنا",2313565,2,2,2,130,260]
[4,"2020-08-23",null,null,3,3,2,150,300]
[4,"2020-08-23",null,null,0,"",0,0,0]
[4,"2020-08-23",null,null,0,"",0,0,0]
[4,"2020-08-23",null,null,0,"",0,0,0]
[4,"2020-08-23",null,null,"خصم",0,0,0,0]
[4,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,560]
[3,"2020-08-23","رنا شوقى ",123654455,2,2,1,130,130]
[3,"2020-08-23",null,null,5,5,1,150,150]
[3,"2020-08-23",null,null,0,"",0,0,0]
[3,"2020-08-23",null,null,0,"",0,0,0]
[3,"2020-08-23",null,null,0,"",0,0,0]
[3,"2020-08-23",null,null,"خصم",0,0,0,0]
[3,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,280]
[2,"2020-08-23","محمد شوقى ",123654878,2,2,1,130,130]
[2,"2020-08-23",null,null,3,3,1,150,150]
[2,"2020-08-23",null,null,4,4,1,150,150]
[2,"2020-08-23",null,null,0,"",0,0,0]
[2,"2020-08-23",null,null,0,"",0,0,0]
[2,"2020-08-23",null,null,"خصم",0,0,0,30]
[2,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,400]
[1,"2020-08-23","محمود متولى ",325566565,1,1,1,150,150]
[1,"2020-08-23",null,null,2,2,1,125,125]
[1,"2020-08-23",null,null,3,3,2,150,300]
[1,"2020-08-23",null,null,4,4,1,150,150]
[1,"2020-08-23",null,null,5,5,1,150,150]
[1,"2020-08-23",null,null,"خصم",0,0,0,25]
[1,"2020-08-23",null,null,"إجمالى الفاتورة",0,0,0,850]