{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Intro","Stock","Invoice","Print Invoice","Invoice Archive","Main Store","Customers"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":3,"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":"Intro","index":0,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,40,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1- اضافة قائمة منسدلة للعملاء تكون في الفاتورة تظهر فيCustomer Name \nبدلا من كتابة العميل كل مرة ويون مرتبط بها رقم الموبايل لكل عميل \n2- اظهار الدين السابق في الفاتورة لكل عميل عند انشاء فاتورة جديدة بأسمه\n3- تعديل شيت طباعة الفاتورة ليتناسب مع الطباعة على صفحة A5 أو ِA4\n4- عمل شيت للعملاء ترحل اليها المبيعات \n5- حيث ان هذا الملف ليس من انتاجي لذا ارجو شرح كيف تم اخفاء باقي الاعمدة والصفوف في شيت الفاتورة وشيت طباعة الفاتورة\nوشكرا جزيلا لحضراتكم"]

{"sheet":"Stock","index":1,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[13,8,20,10],[1,8,2,10],[4,8,5,8],[4,9,5,9],[4,10,5,10],[12,8,12,10]]}
["Item \nCode","Item Name","cost price","Sales Price","‎Beginning inventory","out of stock","Ending \ninventory"]
[1,"تيشرت بيزك قطن ",27,37,238,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},{"$f":"E2-F2","v":238},null,"إدخال كميات جديدة للمخزون",null,null,null,{"$f":"MATCH(I5,Table2[Item \nCode],0)+1","v":{"$error":"#N/A"}},{"$f":"\"a\"&M2","v":{"$error":"#N/A"}},{"$f":"SUMPRODUCT((TEXT(Table1[Date],\"yyyy\")=\"2020\")*(Table1[كود1]=A2)*Table1[كمية1]+(Table1[كود2]=A2)*Table1[كمية2]+(Table1[كود3]=A2)*Table1[كمية3]+(Table1[كود4]=A2)*Table1[كمية4]+(Table1[كود5]=A2)*Table1[كمية5]+(Table1[كود6]=A2)*Table1[كمية6]+(Table1[كود7]=A2)*Table1[كمية7]+(Table1[كود8]=A2)*Table1[كمية8]+(Table1[كود9]=A2)*Table1[كمية9]+(Table1[كود10]=A2)*Table1[كمية10])","v":0}]
[2,"تيشرت روزتا رياضى",27,37,130,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},{"$f":"E3-F3","v":130}]
[3,"ترنج غطس",115,155,16,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},{"$f":"E4-F4","v":16},null,"Item Code","Item Name","Quantity"]
[4,"ترنج ميلتون m:2xl",null,95,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0,null,null,{"$f":"IFERROR(VLOOKUP(I5,Table2[[Item \nCode]:[Item Name]],2,FALSE),\"\")","v":""}]
[5,"ترنج اطفال ",null,60,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[6,"شروال شبابى ملتون ",37,55,92,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":2},90]
[7,"شروال اولادى",25,35,1,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},1]
[8,"تيشرت اطفال بيزك عادى ",17,23,249,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},249]
[9,"تيشرت اولادى خروج ",null,25,3,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},3]
[10,"شورت اطفال 2:8",null,17,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[11," برامودا شبابى",31,38,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[12,"طقم بناتى برامودا ",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0,null,"محتاج"]
[13,"تيشرت بناتى مطبوع",17,23,16,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},16,null,"1- اضافة قائمة منسدلة للعملاء تكون في الفاتورة تظهر فيCustomer Name \nبدلا من كتابة العميل كل مرة ويون مرتبط بها رقم الموبايل لكل عميل \n2- اظهار الدين السابق في الفاتورة لكل عميل عند انشاء فاتورة جديدة بأسمه\n3- تعديل شيت طباعة الفاتورة ليتناسب مع الطباعة على صفحة A5 أو ِA4\n4- عمل شيت للعملاء ترحل اليها المبيعات \n5- حيث ان هذا الملف ليس من انتاجي لذا ارجو شرح كيف تم اخفاء باقي الاعمدة والصفوف في شيت الفاتورة وشيت طباعة الفاتورة\nوشكرا جزيلا لحضراتكم"]
[14,"جاكت غطس ",60,75,12,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},12]
[15,"شروال جيشى ",null,50,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[16,"شروال جيشى اولادى",30,35,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[17,"تيشرت كلفن ",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[18,"شروال حريمى ",37,50,16,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},16]
[19,"تيشيرت بولو ",38,65,11,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":1},10]
[20,"تيشرت قطن لاكوست",28,43,353,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},353]
[21,"طقم اطفال 2:12",16,35,42,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},42]
[22,"شورت",27,32,29,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},29]
[23,"طقم شبابي ملتون",64,85,45,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},45]
[24,"بنطلون غطس",55,80,1,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},1]
[25,"بنطلون ملتون 3 X",37,50,13,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},13]
[26,"شروال اطفال 2:8",null,31,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[27,"شروال اطفال 10:14",null,35,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[28,"شروال اطفال مقاسات مختلفة",null,35,22,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},22]
[29,"شروال اطفال مقاس S",null,37,56,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},56]
[30,"",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[31,"",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[32,"",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[33,"",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[34,"",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[35,"",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[36,"",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[37,"",null,null,0,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[38,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[39,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[40,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[41,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[42,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[43,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[44,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[45,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[46,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[47,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[48,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[49,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[50,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[51,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[52,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[53,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[54,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[55,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[56,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[57,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[58,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[59,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]
[60,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item \nCode]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item \nCode]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item \nCode]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item \nCode]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item \nCode]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item \nCode]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item \nCode]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item \nCode]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item \nCode]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item \nCode]])*Table1[كمية10])","v":0},0]

{"sheet":"Invoice","index":2,"n_rows":20,"n_cols":88,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,5],[0,1,0,6],[17,1,17,5],[18,1,18,5],[1,1,1,2],[2,1,2,2],[3,1,3,2],[1,3,1,6],[2,3,2,6],[3,3,3,6],[4,1,4,2],[4,3,4,6]]}
[null,"Sales Invoice",null,null,null,null,null,null,{"$f":"COUNTIF(Table1[invoice num],D2)","v":0},null,{"$f":"ISNUMBER(D3)","v":true},{"$f":"ISTEXT(D4)","v":false},{"$f":"ISTEXT(D5)","v":false}]
[null,"Inovoice Num:",null,{"$f":"IFERROR(INDEX(Table1[invoice num],COUNTA(Table1[invoice num]),0)+1,1)","v":2},null,null,null,null,null,null,"رقم الفاتورة","تاريخ","اجمالي فاتورة","ضريبه","اجمالي الضريبه","اجمالي بعد الضريبه","إسم العميل","مسلسل 1","بيان1","كود1","كمية1","سعر1","إجمالي 1","مسلسل 2","بيان2","كود2","كمية2","سعر2","إجمالي 2","مسلسل 3","بيان3","كود3","كمية3","سعر3","إجمالي 3","مسلسل 4","بيان4","كود4","كمية4","سعر4","إجمالي 4","مسلسل 5","بيان5","كود5","كمية5","سعر5","إجمالي 5","مسلسل 6","بيان6","كود6","كمية6","سعر6","إجمالي 6","مسلسل 7","بيان7","كود7","كمية7","سعر7","إجمالي 7","مسلسل 8","بيان8","كود8","كمية8","سعر8","إجمالي 8","مسلسل 9","بيان9","كود9","كمية9","سعر9","إجمالي 9","مسلسل 10","بيان10","كود10","كمية10","سعر10","إجمالي 10","مكسب 1","مكسب 2","مكسب 3","مكسب 4","مكسب 5","مكسب 6","مكسب 7","مكسب 8","مكسب 9","مكسب 10","رقم الموبيل"]
[null,"Date :",null,{"$f":"TODAY()","v":"2021-06-18"},null,null,null,null,null,null,{"$f":"IF(D2=\"\",\"\",D2)","v":2},{"$f":"IF(D3=\"\",\"\",D3)","v":"2021-06-18"},{"$f":"IF(G18=\"\",\"\",G18)","v":0},{"$f":"IF(B19=\"\",\"\",B19)","v":"Previous balance"},{"$f":"IF(G19=\"\",\"\",G19)","v":255},{"$f":"IF(G20=\"\",\"\",G20)","v":255},{"$f":"IF(D4=\"\",\"\",D4)","v":""},{"$f":"IF(B8=\"\",\"\",B8)","v":1},{"$f":"IF(C8=\"\",\"\",C8)","v":""},"",{"$f":"IF(E8=\"\",0,E8)","v":0},0,0,{"$f":"IF(B9=\"\",\"\",B9)","v":2},{"$f":"IF(C9=\"\",\"\",C9)","v":""},"",{"$f":"IF(E9=\"\",0,E9)","v":0},0,0,{"$f":"IF(B10=\"\",\"\",B10)","v":3},{"$f":"IF(C10=\"\",\"\",C10)","v":""},"",{"$f":"IF(E10=\"\",0,E10)","v":0},0,0,{"$f":"IF(B11=\"\",\"\",B11)","v":4},{"$f":"IF(C11=\"\",\"\",C11)","v":""},"",{"$f":"IF(E11=\"\",0,E11)","v":0},0,0,{"$f":"IF(B12=\"\",\"\",B12)","v":5},{"$f":"IF(C12=\"\",\"\",C12)","v":""},"",{"$f":"IF(E12=\"\",0,E12)","v":0},0,0,{"$f":"IF(B13=\"\",\"\",B13)","v":""},{"$f":"IF(C13=\"\",\"\",C13)","v":""},"",{"$f":"IF(E13=\"\",0,E13)","v":0},0,0,{"$f":"IF(B14=\"\",\"\",B14)","v":""},{"$f":"IF(C14=\"\",\"\",C14)","v":""},"",{"$f":"IF(E14=\"\",0,E14)","v":0},0,0,{"$f":"IF(B15=\"\",\"\",B15)","v":""},{"$f":"IF(C15=\"\",\"\",C15)","v":""},"",{"$f":"IF(E15=\"\",0,E15)","v":0},0,0,{"$f":"IF(B16=\"\",\"\",B16)","v":""},{"$f":"IF(C16=\"\",\"\",C16)","v":""},"",{"$f":"IF(E16=\"\",0,E16)","v":0},0,0,{"$f":"IF(B17=\"\",\"\",B17)","v":""},{"$f":"IF(C17=\"\",\"\",C17)","v":""},"",{"$f":"IF(E17=\"\",0,E17)","v":0},0,0,{"$f":"K8","v":0},{"$f":"K9","v":0},{"$f":"K10","v":0},{"$f":"K11","v":0},{"$f":"K12","v":0},{"$f":"K13","v":0},{"$f":"K14","v":0},{"$f":"K15","v":0},{"$f":"K16","v":0},{"$f":"K17","v":0},{"$f":"IF(D5=\"\",\"\",D5)","v":""}]
[null,"Customer Name:",null,null,null,null,null,18]
[null,"Mobile Number :"]
[]
[null,"Nu.","description","Code","Qua","Price","Total"]
[null,1,{"$f":"IFERROR(VLOOKUP(D8,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D8,Stock!$A:$D,4,0),0)","v":0},{"$f":"PRODUCT(F8,E8)","v":0},null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D8,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D8,Table2[cost price]))*E8","v":0}]
[null,2,{"$f":"IFERROR(VLOOKUP(D9,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D9,Stock!$A:$D,4,0),0)","v":0},0,null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D9,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D9,Table2[cost price]))*E9","v":0}]
[null,3,{"$f":"IFERROR(VLOOKUP(D10,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D10,Stock!$A:$D,4,0),0)","v":0},0,null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D10,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D10,Table2[cost price]))*E10","v":0}]
[null,4,{"$f":"IFERROR(VLOOKUP(D11,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D11,Stock!$A:$D,4,0),0)","v":0},0,null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D11,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D11,Table2[cost price]))*E11","v":0}]
[null,5,{"$f":"IFERROR(VLOOKUP(D12,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D12,Stock!$A:$D,4,0),0)","v":0},0,null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D12,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D12,Table2[cost price]))*E12","v":0}]
[null,{"$f":"IF(C13=\"\",\"\",B12+1)","v":""},{"$f":"IFERROR(VLOOKUP(D13,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D13,Stock!$A:$D,4,0),0)","v":0},{"$f":"PRODUCT(F13,E13)","v":0},null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D13,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D13,Table2[cost price]))*E13","v":0}]
[null,"",{"$f":"IFERROR(VLOOKUP(D14,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D14,Stock!$A:$D,4,0),0)","v":0},{"$f":"PRODUCT(F14,E14)","v":0},null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D14,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D14,Table2[cost price]))*E14","v":0}]
[null,"",{"$f":"IFERROR(VLOOKUP(D15,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D15,Stock!$A:$D,4,0),0)","v":0},0,null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D15,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D15,Table2[cost price]))*E15","v":0}]
[null,"",{"$f":"IFERROR(VLOOKUP(D16,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D16,Stock!$A:$D,4,0),0)","v":0},0,null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D16,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D16,Table2[cost price]))*E16","v":0}]
[null,"",{"$f":"IFERROR(VLOOKUP(D17,Stock!$A:$B,2,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(D17,Stock!$A:$D,4,0),0)","v":0},0,null,null,null,{"$f":"(SUMIF(Table2[Item \nCode],Invoice!D17,Table2[Sales Price])-SUMIF(Table2[Item \nCode],Invoice!D17,Table2[cost price]))*E17","v":0}]
[null,"Total Invoice",null,null,null,null,{"$f":"SUM(G8:G17)","v":0}]
[null,"Previous balance",null,null,null,null,{"$f":"IFERROR(VLOOKUP(H4,Customers!$A:$D,4,0),\"\")","v":255}]
[null,"Total After Tax",null,null,null,null,{"$f":"G18+G19","v":255}]

{"sheet":"Print Invoice","index":3,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,6,35,6],[6,1,8,6],[27,1,27,5],[25,1,25,5],[26,1,26,5],[9,1,9,2],[9,3,9,6],[10,1,10,2],[10,3,10,6],[11,1,11,2],[11,3,11,6],[12,3,12,6],[12,1,12,2],[29,2,30,6],[25,13,25,17],[26,13,26,17],[27,13,27,17],[9,13,9,14],[9,15,9,18],[10,13,10,14],[10,15,10,18],[11,13,11,14],[11,15,11,18],[12,13,12,14],[12,15,12,18]]}
[]
[]
[]
[]
[]
[]
[null,"Sales Invoice"]
[null,null,null,null,null,null,null,null,"رقم فاتوره خطأ"]
[]
[null,"Inovoice Num:",null,1,null,null,null,null,null,null,null,null,null,"Inovoice Num:",null,{"$f":"IF(D10=\"\",\"\",D10)","v":1}]
[null,"Date :",null,"2021-06-18",null,null,null,null,null,null,null,null,null,"Date :",null,{"$f":"IF(P10=\"\",\"\",IF(COUNTIF(Table1[invoice num],P10)<>1,I8,VLOOKUP(P10,Table1[],2,0)))","v":"2021-06-18"}]
[null,"Customer Name:",null,"أمينة",null,null,null,null,null,null,null,null,null,"Customer Name:",null,{"$f":"IFERROR(IF(P10=\"\",\"\",VLOOKUP(P10,Table1[],7,0)),\"\")","v":"أمينة"}]
[null,"Mobile Number :",null,"0000000000",null,null,null,null,null,null,null,null,null,"Mobile Number :",null,{"$f":"IFERROR(IF(P10=\"\",\"\",VLOOKUP(P10,Table1[],78,0)),\"\")","v":"0000000000"}]
[]
[null,"Nu.","description","Code","Qua","Price","Total",null,null,null,null,null,null,"Nu.","description","Code","Qua","Price","Total"]
[null,1,"شروال شبابى ملتون ",6,2,55,{"$f":"IF(PRODUCT(F16,E16)=0,\"\",PRODUCT(F16,E16))","v":110},null,null,null,null,null,null,{"$f":"IF(O16=\"\",\"\",1)","v":1},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],9,0)=0),\"\",VLOOKUP($D$10,Table1[],9,0)),\"\")","v":"شروال شبابى ملتون "},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],10,0)=0),\"\",VLOOKUP($D$10,Table1[],10,0)),\"\")","v":6},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],11,0)=0),\"\",VLOOKUP($D$10,Table1[],11,0)),\"\")","v":2},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],12,0)=0),\"\",VLOOKUP($D$10,Table1[],12,0)),\"\")","v":55},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],13,0)=0),\"\",VLOOKUP($D$10,Table1[],13,0)),\"\")","v":110},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],68,0)=0),\"\",VLOOKUP($D$10,Table1[],68,0)),\"\")","v":36}]
[null,2,"تيشيرت بولو ",19,1,65,65,null,null,null,null,null,null,{"$f":"IF(O17=\"\",\"\",N16+1)","v":2},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],15,0)=0),\"\",VLOOKUP($D$10,Table1[],15,0)),\"\")","v":"تيشيرت بولو "},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],16,0)=0),\"\",VLOOKUP($D$10,Table1[],16,0)),\"\")","v":19},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],17,0)=0),\"\",VLOOKUP($D$10,Table1[],17,0)),\"\")","v":1},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],18,0)=0),\"\",VLOOKUP($D$10,Table1[],18,0)),\"\")","v":65},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],19,0)=0),\"\",VLOOKUP($D$10,Table1[],19,0)),\"\")","v":65},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],69,0)=0),\"\",VLOOKUP($D$10,Table1[],69,0)),\"\")","v":27}]
[null,"","","","","",{"$f":"IF(PRODUCT(F18,E18)=0,\"\",PRODUCT(F18,E18))","v":""},null,null,null,null,null,null,{"$f":"IF(O18=\"\",\"\",N17+1)","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],21,0)=0),\"\",VLOOKUP($D$10,Table1[],21,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],22,0)=0),\"\",VLOOKUP($D$10,Table1[],22,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],23,0)=0),\"\",VLOOKUP($D$10,Table1[],23,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],24,0)=0),\"\",VLOOKUP($D$10,Table1[],24,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],25,0)=0),\"\",VLOOKUP($D$10,Table1[],25,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],70,0)=0),\"\",VLOOKUP($D$10,Table1[],70,0)),\"\")","v":""}]
[null,"","","","","",{"$f":"IF(PRODUCT(F19,E19)=0,\"\",PRODUCT(F19,E19))","v":""},null,null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],27,0)=0),\"\",VLOOKUP($D$10,Table1[],27,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],28,0)=0),\"\",VLOOKUP($D$10,Table1[],28,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],29,0)=0),\"\",VLOOKUP($D$10,Table1[],29,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],30,0)=0),\"\",VLOOKUP($D$10,Table1[],30,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],31,0)=0),\"\",VLOOKUP($D$10,Table1[],31,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],71,0)=0),\"\",VLOOKUP($D$10,Table1[],71,0)),\"\")","v":""}]
[null,"","","","","","",null,null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],33,0)=0),\"\",VLOOKUP($D$10,Table1[],33,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],34,0)=0),\"\",VLOOKUP($D$10,Table1[],34,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],35,0)=0),\"\",VLOOKUP($D$10,Table1[],35,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],36,0)=0),\"\",VLOOKUP($D$10,Table1[],36,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],37,0)=0),\"\",VLOOKUP($D$10,Table1[],37,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],72,0)=0),\"\",VLOOKUP($D$10,Table1[],72,0)),\"\")","v":""}]
[null,"","","","","","",null,null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],39,0)=0),\"\",VLOOKUP($D$10,Table1[],39,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],40,0)=0),\"\",VLOOKUP($D$10,Table1[],40,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],41,0)=0),\"\",VLOOKUP($D$10,Table1[],41,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],42,0)=0),\"\",VLOOKUP($D$10,Table1[],42,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],43,0)=0),\"\",VLOOKUP($D$10,Table1[],43,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],73,0)=0),\"\",VLOOKUP($D$10,Table1[],73,0)),\"\")","v":""}]
[null,"","","","","","",null,null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],45,0)=0),\"\",VLOOKUP($D$10,Table1[],45,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],46,0)=0),\"\",VLOOKUP($D$10,Table1[],46,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],47,0)=0),\"\",VLOOKUP($D$10,Table1[],47,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],48,0)=0),\"\",VLOOKUP($D$10,Table1[],48,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],49,0)=0),\"\",VLOOKUP($D$10,Table1[],49,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],74,0)=0),\"\",VLOOKUP($D$10,Table1[],74,0)),\"\")","v":""}]
[null,"","","","","","",null,null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],51,0)=0),\"\",VLOOKUP($D$10,Table1[],51,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],52,0)=0),\"\",VLOOKUP($D$10,Table1[],52,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],53,0)=0),\"\",VLOOKUP($D$10,Table1[],53,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],54,0)=0),\"\",VLOOKUP($D$10,Table1[],54,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],55,0)=0),\"\",VLOOKUP($D$10,Table1[],55,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],75,0)=0),\"\",VLOOKUP($D$10,Table1[],75,0)),\"\")","v":""}]
[null,"","","","","","",null,null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],57,0)=0),\"\",VLOOKUP($D$10,Table1[],57,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],58,0)=0),\"\",VLOOKUP($D$10,Table1[],58,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],59,0)=0),\"\",VLOOKUP($D$10,Table1[],59,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],60,0)=0),\"\",VLOOKUP($D$10,Table1[],60,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],61,0)=0),\"\",VLOOKUP($D$10,Table1[],61,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],76,0)=0),\"\",VLOOKUP($D$10,Table1[],76,0)),\"\")","v":""}]
[null,"","","","","","",null,null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],63,0)=0),\"\",VLOOKUP($D$10,Table1[],63,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],64,0)=0),\"\",VLOOKUP($D$10,Table1[],64,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],65,0)=0),\"\",VLOOKUP($D$10,Table1[],65,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],66,0)=0),\"\",VLOOKUP($D$10,Table1[],66,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],67,0)=0),\"\",VLOOKUP($D$10,Table1[],67,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],77,0)=0),\"\",VLOOKUP($D$10,Table1[],77,0)),\"\")","v":""}]
[null,"Total Invoice",null,null,null,null,{"$f":"SUM(G16:G25)","v":175},null,null,null,null,null,null,"Total Invoice",null,null,null,null,{"$f":"IFERROR(IF(P10=\"\",0,VLOOKUP(P10,Table1[],3,0)),0)","v":175}]
[null,"Previous balance",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(P10=\"\",\"\",VLOOKUP(P10,Table1[],4,0)),\"\")","v":"Previous balance"},null,null,null,null,{"$f":"IFERROR(IF(P10=\"\",0,VLOOKUP(P10,Table1[],5,0)),0)","v":255}]
[null,"Total After Tax",null,null,null,null,{"$f":"G26+G27","v":175},null,null,null,null,null,null,"Total After Tax",null,null,null,null,{"$f":"IFERROR(IF(P10=\"\",0,VLOOKUP(P10,Table1[],6,0)),0)","v":430}]
[]
[]
[]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$16,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$16,Table2[cost price]))*$E$16,0)","v":36},{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$21,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$21,Table2[cost price]))*$E$21,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$17,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$17,Table2[cost price]))*$E$17,0)","v":27},{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$22,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$22,Table2[cost price]))*$E$22,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$18,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$18,Table2[cost price]))*$E$18,0)","v":0},{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$23,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$23,Table2[cost price]))*$E$23,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$19,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$19,Table2[cost price]))*$E$19,0)","v":0},{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$24,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$24,Table2[cost price]))*$E$24,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$20,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$20,Table2[cost price]))*$E$20,0)","v":0},{"$f":"IFERROR((SUMIF(Table2[Item \nCode],$D$25,Table2[Sales Price])-SUMIF(Table2[Item \nCode],$D$25,Table2[cost price]))*$E$25,0)","v":0}]

{"sheet":"Invoice Archive","index":4,"n_rows":49,"n_cols":82,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Nu.","invoice num","Date","Total Invoice","Previous balance","Total Previous balance","Total Balance","Customer Name","مسلسل 1","بيان1","كود1","كمية1","سعر1","إجمالي 1","مسلسل 2","بيان2","كود2","كمية2","سعر2","إجمالي 2","مسلسل 3","بيان3","كود3","كمية3","سعر3","إجمالي 3","مسلسل 4","بيان4","كود4","كمية4","سعر4","إجمالي 4","مسلسل 5","بيان5","كود5","كمية5","سعر5","إجمالي 5","مسلسل 6","بيان6","كود6","كمية6","سعر6","إجمالي 6","مسلسل 7","بيان7","كود7","كمية7","سعر7","إجمالي 7","مسلسل 8","بيان8","كود8","كمية8","سعر8","إجمالي 8","مسلسل 9","بيان9","كود9","كمية9","سعر9","إجمالي 9","مسلسل 10","بيان10","كود10","كمية10","سعر10","إجمالي 10","مكسب 1","مكسب 2","مكسب 3","مكسب 4","مكسب 5","مكسب 6","مكسب 7","مكسب 8","مكسب 9","مكسب 10","رقم التليفون",null,{"$f":"MATCH('Print Invoice'!D10,Table1[invoice num],0)+1","v":3},{"$f":"\"B\"&CC1","v":"B3"}]
[null,"Total","تاريخ",{"$f":"IFERROR(SUM(OFFSET(D1,2,0,COUNTA(Table1[invoice num])-1,1)),0)","v":175},null,{"$f":"IFERROR(SUM(OFFSET(F1,2,0,COUNTA(Table1[invoice num])-1,1)),0)","v":255},{"$f":"IFERROR(SUM(OFFSET(G1,2,0,COUNTA(Table1[invoice num])-1,1)),0)","v":430},null,null,null,0,{"$f":"0","v":0},{"$f":"SUMIF(Table1[كود1],B2,Table1[كمية1])+SUMIF(Table1[كود2],B2)","v":0},null,null,null,null,{"$f":"0","v":0},null,null,null,null,null,0,null,null,null,null,{"$f":"0","v":0},{"$f":"0","v":0},null,null,null,null,{"$f":"0","v":0},0]
[null,1,"2021-06-18",175,"Previous balance",255,430,"أمينة",1,"شروال شبابى ملتون ",6,2,55,110,2,"تيشيرت بولو ",19,1,65,65,3,"","",0,0,0,4,"","",0,0,0,5,"","",0,0,0,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,36,27,0,0,0,0,0,0,0,0,"0000000000"]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B11=\"\",\"\",A10+1)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Main Store","index":5,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Item \nCode","Item \nName","cost \nprice","Sales \nPrice","رصيد \nاول","المنصرف","رصيد \nاخر","Total  \ncost price","Total  \nSales Price","Profit \nmargin"]
["01",{"$f":"Table2[[#This Row],[Item Name]]","v":"تيشرت بيزك قطن "},27,37,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":238},{"$f":"Table2[[#This Row],[out of stock]]","v":0},{"$f":"E2-F2","v":238},{"$f":"C2*G2","v":6426},{"$f":"D2*G2","v":8806},{"$f":"I2-H2","v":2380}]
["02",{"$f":"Table2[[#This Row],[Item Name]]","v":"تيشرت روزتا رياضى"},27,37,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":130},{"$f":"Table2[[#This Row],[out of stock]]","v":0},{"$f":"E3-F3","v":130},{"$f":"C3*G3","v":3510},{"$f":"D3*G3","v":4810},{"$f":"I3-H3","v":1300}]
["03",{"$f":"Table2[[#This Row],[Item Name]]","v":"ترنج غطس"},115,155,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":16},{"$f":"Table2[[#This Row],[out of stock]]","v":0},{"$f":"E4-F4","v":16},{"$f":"C4*G4","v":1840},{"$f":"D4*G4","v":2480},{"$f":"I4-H4","v":640}]
["04",{"$f":"Table2[[#This Row],[Item Name]]","v":"ترنج ميلتون m:2xl"},null,95,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["05",{"$f":"Table2[[#This Row],[Item Name]]","v":"ترنج اطفال "},null,60,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["06",{"$f":"Table2[[#This Row],[Item Name]]","v":"شروال شبابى ملتون "},37,50,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":92},{"$f":"Table2[[#This Row],[out of stock]]","v":2},90,3330,4500,1170]
["07",{"$f":"Table2[[#This Row],[Item Name]]","v":"شروال اولادى"},25,35,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":1},{"$f":"Table2[[#This Row],[out of stock]]","v":0},1,25,35,10]
["08",{"$f":"Table2[[#This Row],[Item Name]]","v":"تيشرت اطفال بيزك عادى "},17,23,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":249},{"$f":"Table2[[#This Row],[out of stock]]","v":0},249,4233,5727,1494]
["09",{"$f":"Table2[[#This Row],[Item Name]]","v":"تيشرت اولادى خروج "},null,25,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":3},{"$f":"Table2[[#This Row],[out of stock]]","v":0},3,0,75,75]
["10",{"$f":"Table2[[#This Row],[Item Name]]","v":"شورت اطفال 2:8"},null,17,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["11",{"$f":"Table2[[#This Row],[Item Name]]","v":" برامودا شبابى"},31,38,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["12",{"$f":"Table2[[#This Row],[Item Name]]","v":"طقم بناتى برامودا "},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},{"$f":"E13-F13","v":0},{"$f":"C13*G13","v":0},{"$f":"D13*G13","v":0},0]
["13",{"$f":"Table2[[#This Row],[Item Name]]","v":"تيشرت بناتى مطبوع"},17,23,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":16},{"$f":"Table2[[#This Row],[out of stock]]","v":0},16,272,368,96]
["14",{"$f":"Table2[[#This Row],[Item Name]]","v":"جاكت غطس "},60,75,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":12},{"$f":"Table2[[#This Row],[out of stock]]","v":0},12,720,900,180]
["15",{"$f":"Table2[[#This Row],[Item Name]]","v":"شروال جيشى "},null,50,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["16",{"$f":"Table2[[#This Row],[Item Name]]","v":"شروال جيشى اولادى"},30,35,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["17",{"$f":"Table2[[#This Row],[Item Name]]","v":"تيشرت كلفن "},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["18",{"$f":"Table2[[#This Row],[Item Name]]","v":"شروال حريمى "},37,50,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":16},{"$f":"Table2[[#This Row],[out of stock]]","v":0},16,592,800,208]
["19",{"$f":"Table2[[#This Row],[Item Name]]","v":"تيشيرت بولو "},38,50,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":11},{"$f":"Table2[[#This Row],[out of stock]]","v":1},10,380,500,120]
["20",{"$f":"Table2[[#This Row],[Item Name]]","v":"تيشرت قطن لاكوست"},28,43,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":353},{"$f":"Table2[[#This Row],[out of stock]]","v":0},353,9884,15179,5295]
["21",{"$f":"Table2[[#This Row],[Item Name]]","v":"طقم اطفال 2:12"},16,35,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":42},{"$f":"Table2[[#This Row],[out of stock]]","v":0},42,672,1470,798]
["22",{"$f":"Table2[[#This Row],[Item Name]]","v":"شورت"},27,32,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":29},{"$f":"Table2[[#This Row],[out of stock]]","v":0},29,783,928,145]
["23",{"$f":"Table2[[#This Row],[Item Name]]","v":"طقم شبابي ملتون"},64,85,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":45},{"$f":"Table2[[#This Row],[out of stock]]","v":0},45,2880,3825,945]
["24",{"$f":"Table2[[#This Row],[Item Name]]","v":"بنطلون غطس"},55,80,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":1},{"$f":"Table2[[#This Row],[out of stock]]","v":0},1,55,80,25]
["25",{"$f":"Table2[[#This Row],[Item Name]]","v":"بنطلون ملتون 3 X"},37,50,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":13},{"$f":"Table2[[#This Row],[out of stock]]","v":0},13,481,650,169]
["26",{"$f":"Table2[[#This Row],[Item Name]]","v":"شروال اطفال 2:8"},null,31,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["27",{"$f":"Table2[[#This Row],[Item Name]]","v":"شروال اطفال 10:14"},null,35,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["28","شروال اطفال مقاسات مختلفة",null,35,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":22},{"$f":"Table2[[#This Row],[out of stock]]","v":0},22,0,770,770]
["29","شروال اطفال مقاس S",null,37,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":56},{"$f":"Table2[[#This Row],[out of stock]]","v":0},56,0,2072,2072]
["30",{"$f":"Table2[[#This Row],[Item Name]]","v":""},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["31",{"$f":"Table2[[#This Row],[Item Name]]","v":""},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["32",{"$f":"Table2[[#This Row],[Item Name]]","v":""},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["33",{"$f":"Table2[[#This Row],[Item Name]]","v":""},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["34",{"$f":"Table2[[#This Row],[Item Name]]","v":""},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["35",{"$f":"Table2[[#This Row],[Item Name]]","v":""},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["36",{"$f":"Table2[[#This Row],[Item Name]]","v":""},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["37",{"$f":"Table2[[#This Row],[Item Name]]","v":""},null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["38",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["39",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["40",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["41",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["42",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["43",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["44",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["45",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["46",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["47",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["48",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["49",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]
["50",null,null,null,{"$f":"Table2[[#This Row],[‎Beginning inventory]]","v":0},{"$f":"Table2[[#This Row],[out of stock]]","v":0},0,0,0,0]

{"sheet":"Customers","index":6,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Sn.","Name","Mob.","Previous \ndebit balance"]
[1,"عمرو فتحى ",null,{"$f":"[2]العملاء!A3","v":1351}]
[2," مصطفى معروف",null,{"$f":"[2]العملاء!A4","v":1375}]
[3,"ضياء فتحى ",null,{"$f":"[2]العملاء!A5","v":457}]
[4,"احمد الشرقاوى ",null,{"$f":"[2]العملاء!A6","v":703}]
[5,"حسام مصطفى ",null,{"$f":"[2]العملاء!A7","v":0}]
[6,"على حسن ابو يزن ",null,{"$f":"[2]العملاء!A8","v":1787}]
[7,"ك /عاطف",null,{"$f":"[2]العملاء!A9","v":0}]
[8," ك/محمود رياضى",null,{"$f":"[2]العملاء!A10","v":780}]
[9,"على ناجى   ",null,{"$f":"[2]العملاء!A11","v":290}]
[10,"ام محمد مطاى ",null,{"$f":"[2]العملاء!A12","v":6894}]
[11,"رمضان عبد الجواد",null,{"$f":"[2]العملاء!A13","v":945}]
[12,"شريف عسكر ",null,{"$f":"[2]العملاء!A14","v":1310}]
[13,"عبد الله الصعيدى",null,{"$f":"[2]العملاء!A15","v":847}]
[14,"أ/ جمعه ",null,{"$f":"[2]العملاء!A16","v":215}]
[15,"كيمو المنيا ",null,{"$f":"[2]العملاء!A17","v":0}]
[16,"طه ابو الحسن ",null,{"$f":"[2]العملاء!A18","v":0}]
[17,"سامح شعبان ",null,{"$f":"[2]العملاء!A19","v":2795}]
[18,"أمنية",null,{"$f":"[2]العملاء!A20","v":255}]
[19,"على محمد عبد العزيز ",null,{"$f":"[2]العملاء!A21","v":1277}]
[20,"مصطفى حسنى ",null,{"$f":"[2]العملاء!A22","v":5468}]
[21,"ملك محمد ",null,{"$f":"[2]العملاء!A23","v":0}]
[22,"أ/ هبه ",null,{"$f":"[2]العملاء!A24","v":10}]
[23,"حسن على السيد ",null,{"$f":"[2]العملاء!A25","v":1345}]
[24,"محمود بني مزار",null,{"$f":"[2]العملاء!A26","v":8152}]
[25," مدام /حنان     مشغل ",null,{"$f":"[2]العملاء!A27","v":265}]
[26,"ام/ حسام مشغل ",null,{"$f":"[2]العملاء!A28","v":1378}]
[27,"ام عبد الله     مشغل ",null,{"$f":"[2]العملاء!A29","v":150}]
[28,"ايهاب حسان   مشغل ",null,{"$f":"[2]العملاء!A30","v":760}]
[29,"اصلاح",null,{"$f":"[2]العملاء!A31","v":130}]
[30,"ام /وليد مشغل ",null,{"$f":"[2]العملاء!A32","v":349}]
[31,"سحر   مشغل",null,{"$f":"[2]العملاء!A33","v":100}]
[32,"محمد بيومي",null,{"$f":"[2]العملاء!A34","v":0}]
[33,"محمد خلف",null,{"$f":"[2]العملاء!A35","v":0}]
[34,"عملاء آخرون",null,{"$f":"[2]العملاء!A36","v":595}]
[35,"أبودومة",null,{"$f":"[2]العملاء!A37","v":2065}]
[36,"جمال عيد",null,{"$f":"[2]العملاء!A38","v":0}]