{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Stock","Invoice","Print Invoice","Invoice Archive"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Stock","index":0,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,8,16,8],[15,9,16,9],[15,10,16,10],[1,8,2,10],[4,8,5,8],[4,9,5,9],[4,10,5,10],[12,8,13,10]]}
["Item Code","Item Name","cost price","Sales Price","رصيد اول","المنصرف","رصيد اخر"]
[10,"مايه",5,10,55,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},{"$f":"E2-F2","v":55},null,"إدخال كميات جديدة للمخزون",null,null,null,{"$f":"MATCH(I5,Table2[Item Code],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}]
[11,"شيبسي",6,10,54,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":2},{"$f":"E3-F3","v":52}]
[null,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},{"$f":"E4-F4","v":0},null,"Item Code","Item Name","Quantity"]
[null,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},0,null,null,{"$f":"IFERROR(VLOOKUP(I5,Table2[[Item Code]:[Item Name]],2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},0]
[null,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},0]
[null,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},0]
[null,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},0]
[null,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},0]
[null,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},0]
[null,null,null,null,null,{"$f":"SUMPRODUCT((Table1[كود1]=Table2[[#This Row],[Item Code]])*Table1[كمية1]+(Table1[كود2]=Table2[[#This Row],[Item Code]])*Table1[كمية2]+(Table1[كود3]=Table2[[#This Row],[Item Code]])*Table1[كمية3]+(Table1[كود4]=Table2[[#This Row],[Item Code]])*Table1[كمية4]+(Table1[كود5]=Table2[[#This Row],[Item Code]])*Table1[كمية5]+(Table1[كود6]=Table2[[#This Row],[Item Code]])*Table1[كمية6]+(Table1[كود7]=Table2[[#This Row],[Item Code]])*Table1[كمية7]+(Table1[كود8]=Table2[[#This Row],[Item Code]])*Table1[كمية8]+(Table1[كود9]=Table2[[#This Row],[Item Code]])*Table1[كمية9]+(Table1[كود10]=Table2[[#This Row],[Item Code]])*Table1[كمية10])","v":0},0]
[null,null,null,null,null,null,null,null,"إدخال كميات المرتجع للمخزون"]
[]
[null,null,null,null,null,null,null,null,"Item Code","Item Name","Quantity"]
[null,null,null,null,null,null,null,null,11,{"$f":"IFERROR(VLOOKUP(I16,Table2[[Item Code]:[Item Name]],2,FALSE),\"\")","v":"شيبسي"},5]

{"sheet":"Invoice","index":1,"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-09"},null,null,null,null,null,null,{"$f":"IF(D2=\"\",\"\",D2)","v":2},{"$f":"IF(D3=\"\",\"\",D3)","v":"2021-06-09"},{"$f":"IF(G18=\"\",\"\",G18)","v":0},{"$f":"IF(B19=\"\",\"\",B19)","v":"Tax 0%"},{"$f":"IF(G19=\"\",\"\",G19)","v":0},{"$f":"IF(G20=\"\",\"\",G20)","v":0},{"$f":"IF(D4=\"\",\"\",D4)","v":""},{"$f":"IF(B8=\"\",\"\",B8)","v":11},{"$f":"IF(C8=\"\",\"\",C8)","v":""},"",{"$f":"IF(E8=\"\",0,E8)","v":0},0,0,{"$f":"IF(B9=\"\",\"\",B9)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},"",{"$f":"IF(E9=\"\",0,E9)","v":0},0,0,{"$f":"IF(B10=\"\",\"\",B10)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},"",{"$f":"IF(E10=\"\",0,E10)","v":0},0,0,{"$f":"IF(B11=\"\",\"\",B11)","v":""},{"$f":"IF(C11=\"\",\"\",C11)","v":""},"",{"$f":"IF(E11=\"\",0,E11)","v":0},0,0,{"$f":"IF(B12=\"\",\"\",B12)","v":""},{"$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,"Mobile Number :"]
[]
[null,"Nu.","description","Code","Qua","Price","Total"]
[null,11,{"$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 Code],Invoice!D8,Table2[Sales Price])-SUMIF(Table2[Item Code],Invoice!D8,Table2[cost price]))*E8","v":0}]
[null,{"$f":"IF(C9=\"\",\"\",B8+1)","v":""},{"$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 Code],Invoice!D9,Table2[Sales Price])-SUMIF(Table2[Item Code],Invoice!D9,Table2[cost price]))*E9","v":0}]
[null,{"$f":"IF(C10=\"\",\"\",B9+1)","v":""},{"$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 Code],Invoice!D10,Table2[Sales Price])-SUMIF(Table2[Item Code],Invoice!D10,Table2[cost price]))*E10","v":0}]
[null,"",{"$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 Code],Invoice!D11,Table2[Sales Price])-SUMIF(Table2[Item Code],Invoice!D11,Table2[cost price]))*E11","v":0}]
[null,"",{"$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 Code],Invoice!D12,Table2[Sales Price])-SUMIF(Table2[Item Code],Invoice!D12,Table2[cost price]))*E12","v":0}]
[null,"",{"$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 Code],Invoice!D13,Table2[Sales Price])-SUMIF(Table2[Item Code],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 Code],Invoice!D14,Table2[Sales Price])-SUMIF(Table2[Item Code],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 Code],Invoice!D15,Table2[Sales Price])-SUMIF(Table2[Item Code],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 Code],Invoice!D16,Table2[Sales Price])-SUMIF(Table2[Item Code],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 Code],Invoice!D17,Table2[Sales Price])-SUMIF(Table2[Item Code],Invoice!D17,Table2[cost price]))*E17","v":0}]
[null,"Total Invoice",null,null,null,null,{"$f":"SUM(G8:G17)","v":0}]
[null,"Tax 0%",null,null,null,null,{"$f":"G18*RIGHT(B19,3)","v":0}]
[null,"Total After Tax",null,null,null,null,{"$f":"G18+G19","v":0}]

{"sheet":"Print Invoice","index":2,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[]
[]
[]
[]
[]
[null,"Sales Invoice"]
[null,null,null,null,null,null,null,null,"رقم فاتوره خطأ"]
[]
[null,"Inovoice Num:",null,null,null,null,null,null,null,null,null,null,null,"Inovoice Num:",null,{"$f":"IF(D10=\"\",\"\",D10)","v":""}]
[null,"Date :",null,"",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":""}]
[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,"",null,null,null,null,null,null,null,null,null,"Mobile Number :",null,{"$f":"IFERROR(IF(P10=\"\",\"\",VLOOKUP(P10,Table1[],78,0)),\"\")","v":""}]
[]
[null,"Nu.","description","Code","Qua","Price","Total",null,null,null,null,null,null,"Nu.","description","Code","Qua","Price","Total"]
[null,"","","","","",{"$f":"IF(PRODUCT(F16,E16)=0,\"\",PRODUCT(F16,E16))","v":""},null,null,null,null,null,null,{"$f":"IF(O16=\"\",\"\",1)","v":""},{"$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":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],11,0)=0),\"\",VLOOKUP($D$10,Table1[],11,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],12,0)=0),\"\",VLOOKUP($D$10,Table1[],12,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],13,0)=0),\"\",VLOOKUP($D$10,Table1[],13,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],68,0)=0),\"\",VLOOKUP($D$10,Table1[],68,0)),\"\")","v":""}]
[null,"","","","","","",null,null,null,null,null,null,{"$f":"IF(O17=\"\",\"\",N16+1)","v":""},{"$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":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],17,0)=0),\"\",VLOOKUP($D$10,Table1[],17,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],18,0)=0),\"\",VLOOKUP($D$10,Table1[],18,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],19,0)=0),\"\",VLOOKUP($D$10,Table1[],19,0)),\"\")","v":""},{"$f":"IFERROR(IF(OR($D$10=\"\",VLOOKUP($D$10,Table1[],69,0)=0),\"\",VLOOKUP($D$10,Table1[],69,0)),\"\")","v":""}]
[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":0},null,null,null,null,null,null,"Total Invoice",null,null,null,null,{"$f":"IFERROR(IF(P10=\"\",0,VLOOKUP(P10,Table1[],3,0)),0)","v":0}]
[null,"",null,null,null,null,{"$f":"IF(B27=\"\",0,G26*RIGHT(B27,3))","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(P10=\"\",\"\",VLOOKUP(P10,Table1[],4,0)),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(P10=\"\",0,VLOOKUP(P10,Table1[],5,0)),0)","v":0}]
[null,"Total After Tax",null,null,null,null,{"$f":"G26+G27","v":0},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":0}]
[]
[]
[]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$16,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$16,Table2[cost price]))*$E$16,0)","v":0},{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$21,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$21,Table2[cost price]))*$E$21,0)","v":0},1]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$17,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$17,Table2[cost price]))*$E$17,0)","v":0},{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$22,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$22,Table2[cost price]))*$E$22,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$18,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$18,Table2[cost price]))*$E$18,0)","v":0},{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$23,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$23,Table2[cost price]))*$E$23,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$19,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$19,Table2[cost price]))*$E$19,0)","v":0},{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$24,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$24,Table2[cost price]))*$E$24,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$20,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$20,Table2[cost price]))*$E$20,0)","v":0},{"$f":"IFERROR((SUMIF(Table2[Item Code],$D$25,Table2[Sales Price])-SUMIF(Table2[Item Code],$D$25,Table2[cost price]))*$E$25,0)","v":0}]

{"sheet":"Invoice Archive","index":3,"n_rows":50,"n_cols":82,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Nu.","invoice num","Date","Total Invoice","Tax","Total Tax","Total After Tax","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":{"$error":"#N/A"}},{"$f":"\"B\"&CC1","v":{"$error":"#N/A"}}]
[null,"Total","تاريخ",{"$f":"IFERROR(SUM(OFFSET(D1,2,0,COUNTA(Table1[invoice num])-1,1)),0)","v":20},null,{"$f":"IFERROR(SUM(OFFSET(F1,2,0,COUNTA(Table1[invoice num])-1,1)),0)","v":0},{"$f":"IFERROR(SUM(OFFSET(G1,2,0,COUNTA(Table1[invoice num])-1,1)),0)","v":20},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]
[{"$f":"IF(B3=\"\",\"\",1)","v":1},1,"2021-06-09",20,"Tax 0%",0,20,"ا",11,"شيبسي",11,2,10,20,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,"","","",0,0,0,8,0,0,0,0,0,0,0,0,0,"01111"]
[{"$f":"IF(B4=\"\",\"\",A3+1)","v":""}]
[{"$f":"IF(B5=\"\",\"\",A4+1)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]