{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["data","فاتوره","مشتروات","مرتجع","مبيعات"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"data","index":0,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"م","كود الصنف","اسم الصنف","الخصم الأول","العدد - الكمية","الخصم الثاني","العدد - الكمية2","الخصم الثالث","العدد - الكمية3","الخصم الرابع","العدد - الكمية4"]
[null,{"$f":"IF(data!$C2=\"\",\"\",ROW()-1)","v":1},11,"استيك جيبولت 110 مم"]
[null,{"$f":"IF(data!$C3=\"\",\"\",ROW()-1)","v":2},12,"استيك جيبولت 125 مم"]
[null,{"$f":"IF(data!$C4=\"\",\"\",ROW()-1)","v":3},13,"استيك جيبولت 160 مم"]
[null,{"$f":"IF(data!$C5=\"\",\"\",ROW()-1)","v":4},14,"استيك جيبولت 200 مم"]
[null,{"$f":"IF(data!$C6=\"\",\"\",ROW()-1)","v":5},15,"استيك جيبولت 225 مم"]
[null,{"$f":"IF(data!$C7=\"\",\"\",ROW()-1)","v":6},16,"استيك جيبولت 250 مم"]
[null,{"$f":"IF(data!$C8=\"\",\"\",ROW()-1)","v":7},17,"استيك جيبولت 315 مم"]
[null,{"$f":"IF(data!$C9=\"\",\"\",ROW()-1)","v":8},18,"استيك جيبولت 355 مم"]
[null,{"$f":"IF(data!$C10=\"\",\"\",ROW()-1)","v":9},19,"استيك جيبولت 400 مم"]
[null,{"$f":"IF(data!$C11=\"\",\"\",ROW()-1)","v":10},20,"استيك جيبولت 450 مم"]
[null,{"$f":"IF(data!$C12=\"\",\"\",ROW()-1)","v":11},21,"استيك جيبولت 500 مم"]
[null,{"$f":"IF(data!$C13=\"\",\"\",ROW()-1)","v":12},22,"جيبولت فارغ مرحله 110 مم"]
[null,{"$f":"IF(data!$C14=\"\",\"\",ROW()-1)","v":13},23,"جيبولت فارغ مرحله 125 مم"]
[null,{"$f":"IF(data!$C15=\"\",\"\",ROW()-1)","v":14},24,"جيبولت فارغ مرحله 160 مم"]
[null,{"$f":"IF(data!$C16=\"\",\"\",ROW()-1)","v":15},25,"جيبولت فارغ مرحله 200 مم"]
[null,{"$f":"IF(data!$C17=\"\",\"\",ROW()-1)","v":16},26,"جيبولت فارغ مرحله 225 مم"]
[null,{"$f":"IF(data!$C18=\"\",\"\",ROW()-1)","v":17},27,"جيبولت فارغ مرحله 250 مم"]
[null,{"$f":"IF(data!$C19=\"\",\"\",ROW()-1)","v":18},28,"جيبولت فارغ مرحله 315 مم"]
[null,{"$f":"IF(data!$C20=\"\",\"\",ROW()-1)","v":19},29,"جيبولت فارغ مرحله 355 مم"]
[null,{"$f":"IF(data!$C21=\"\",\"\",ROW()-1)","v":20},30,"جيبولت فارغ مرحله 400 مم"]
[null,{"$f":"IF(data!$C22=\"\",\"\",ROW()-1)","v":21},31,"جيبولت فارغ مرحله 450 مم"]
[null,{"$f":"IF(data!$C23=\"\",\"\",ROW()-1)","v":22},32,"جيبولت فارغ مرحله 500 مم"]
[null,{"$f":"IF(data!$C24=\"\",\"\",ROW()-1)","v":23},33,"جيبولت كامل مرحله 110 مم","استيك جيبولت 110 مم",2]
[null,{"$f":"IF(data!$C25=\"\",\"\",ROW()-1)","v":24},34,"جيبولت كامل مرحله 125 مم","استيك جيبولت 125 مم",2]
[null,{"$f":"IF(data!$C26=\"\",\"\",ROW()-1)","v":25},35,"جيبولت كامل مرحله 160 مم","استيك جيبولت 160 مم",2]
[null,{"$f":"IF(data!$C27=\"\",\"\",ROW()-1)","v":26},36,"جيبولت كامل مرحله 200 مم","استيك جيبولت 200 مم",2]
[null,{"$f":"IF(data!$C28=\"\",\"\",ROW()-1)","v":27},37,"جيبولت كامل مرحله 225 مم","استيك جيبولت 225 مم",2]
[null,{"$f":"IF(data!$C29=\"\",\"\",ROW()-1)","v":28},38,"جيبولت كامل مرحله 250 مم","استيك جيبولت 250 مم",2]
[null,{"$f":"IF(data!$C30=\"\",\"\",ROW()-1)","v":29},39,"جيبولت كامل مرحله 315 مم","استيك جيبولت 315 مم",2]
[null,{"$f":"IF(data!$C31=\"\",\"\",ROW()-1)","v":30},40,"جيبولت كامل مرحله 355 مم","استيك جيبولت 355 مم",2]
[null,{"$f":"IF(data!$C32=\"\",\"\",ROW()-1)","v":31},41,"جيبولت كامل مرحله 400 مم","استيك جيبولت 400 مم",2]
[null,{"$f":"IF(data!$C33=\"\",\"\",ROW()-1)","v":32},42,"جيبولت كامل مرحله 450 مم","استيك جيبولت 450 مم",2]
[null,{"$f":"IF(data!$C34=\"\",\"\",ROW()-1)","v":33},43,"جيبولت كامل مرحله 500 مم","استيك جيبولت 500 مم",2]
[null,{"$f":"IF(data!$C35=\"\",\"\",ROW()-1)","v":34},44,"جيبولت فارغ مرحلتين 110 مم"]
[null,{"$f":"IF(data!$C36=\"\",\"\",ROW()-1)","v":35},45,"جيبولت فارغ مرحلتين 160 مم"]

{"sheet":"فاتوره","index":1,"n_rows":36,"n_cols":44,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,23,3,42],[3,20,4,20],[3,14,4,14],[3,15,4,15],[3,16,4,16],[0,1,0,3],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[0,4,1,4],[3,5,4,5],[0,6,0,8],[0,19,2,42],[0,14,0,16],[1,14,1,16],[2,14,2,16],[0,12,2,13],[0,9,0,10],[1,9,1,11],[2,9,2,11],[3,9,4,9],[3,10,4,10],[1,6,1,8],[2,6,2,8],[3,6,3,8],[3,19,4,19]]}
[null,"رقم الفاتورة",null,null,"التاريــــــــــخ","العميــــــــــــل","المــــــــــــــــــورد",null,null,"نوع الفاتورة",null,"مرتجع",null,null,null,null,null,null,null,"السياسة السعرية للعملاء",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"أسعار العملاء"]
[null,"مشتروات","مرتجع","مبيعات",null,"محمد2","ABC",null,null,"اجمالي قيمه الفاتورة"]
[null,{"$f":"IF(E7=\"\",\"\",IF($L$1=$B$2,MAX(مشتروات!C:C)+1))","v":false},{"$f":"IF(E7=\"\",\"\",IF($L$1=$C$2,MAX(مرتجع!C:C)+1))","v":4},{"$f":"IF(E7=\"\",\"\",IF($L$1=$D$2,MAX(مبيعات!C:C)+1))","v":false},"2020-05-05",null,"HTP"]
[null,"م","رقم الفاتورة","التاريخ","كود الصنف","اســم الصنـــــــــــف","العدد - الكمية",null,null,"السعر","الإجمالي",{"$f":"IF(L1=\"مشتروات\",\"المورد\",\"العميل\")","v":"العميل"},"سعر مضاف","إضافة","خصم","رصيد المخزن","الرصيد بعد البيع",null,null,"م","كود الصنف",null,null,"أسماء العملاء"]
[null,null,null,null,null,null,"المصنع","مخزن 1","مخزن 2",null,null,null,null,null,null,null,null,null,null,null,null,null,"اسم الصنف","محمد1","محمد2","محمد3","محمد4","محمد5","محمد6","محمد7","محمد8","محمد9","محمد10","محمد11","محمد12","محمد13","محمد14","محمد15","محمد16","محمد17","محمد18","محمد19","محمد20"]
[]
[null,{"$f":"IF(E7=\"\",\"\",ROW()-6)","v":1},{"$f":"IF(E7=\"\",\"\",IF($L$1=\"مبيعات\",$D$3,IF($L$1=\"مرتجع\",$C$3,IF($L$1=\"مشتروات\",$B$3))))","v":4},{"$f":"IF(E7=\"\",\"\",$E$3)","v":"2020-05-05"},13,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E7)=0,\"\",VLOOKUP(E7,data!$C$2:$L$500,2,FALSE))","v":"استيك جيبولت 160 مم"},3,6,5,{"$f":"IF(M7=\"\",IFERROR(VLOOKUP(E7,$U$7:$AQ$36,MATCH(F$2,$X$5:$AQ$5,0)+3,0),\"\"),M7)","v":15},{"$f":"IFERROR(IF(E7=\"\",\"\",SUM(G7:I7)*J7)+SUM(N7,-O7),\"\")","v":210},{"$f":"IF(E7=\"\",\"\",IF($L$4=$F$1,$F$2&\" \"&$F$3,$G$2&\" \"&$G$3))","v":"محمد2 "},null,null,null,null,{"$f":"IF(E7=\"\",\"\",SUM(P7)-SUM(G7:I7))","v":-14},null,null,{"$f":"IF(U7=\"\",\"\",ROW()-6)","v":1},30,null,{"$f":"IFERROR(VLOOKUP(U7,data,2,FALSE),\"\")","v":"جيبولت فارغ مرحله 400 مم"},33,45,null,null,null,null,null,null,null,10]
[null,{"$f":"IF(E8=\"\",\"\",ROW()-6)","v":""},{"$f":"IF(E8=\"\",\"\",IF($L$1=\"مبيعات\",$D$3,IF($L$1=\"مرتجع\",$C$3,IF($L$1=\"مشتروات\",$B$3))))","v":""},{"$f":"IF(E8=\"\",\"\",$E$3)","v":""},null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E8)=0,\"\",VLOOKUP(E8,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E8,$U$7:$AQ$36,F$2+3,0),\"\")","v":""},{"$f":"IFERROR(IF(E8=\"\",\"\",SUM(G8:I8)*J8)+SUM(N8,-O8),\"\")","v":""},{"$f":"IF(E8=\"\",\"\",IF($L$4=$F$1,$F$3,$G$2&\" \"&$G$3))","v":""},null,null,null,null,{"$f":"IF(E8=\"\",\"\",SUM(P8)-SUM(G8:I8))","v":""},null,null,{"$f":"IF(U8=\"\",\"\",ROW()-6)","v":2},23,null,"جيبولت فارغ مرحله 125 مم",6,10]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E9)=0,\"\",VLOOKUP(E9,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,3,28,null,"جيبولت فارغ مرحله 315 مم",7,20]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E10)=0,\"\",VLOOKUP(E10,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,4,24,null,"جيبولت فارغ مرحله 160 مم",8,10]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E11)=0,\"\",VLOOKUP(E11,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,5,13,null,"استيك جيبولت 160 مم",9,15]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E12)=0,\"\",VLOOKUP(E12,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,6,25,null,"جيبولت فارغ مرحله 200 مم",10,12]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E13)=0,\"\",VLOOKUP(E13,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,7,15,null,"استيك جيبولت 225 مم",11,14]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E14)=0,\"\",VLOOKUP(E14,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,8,12,null,"استيك جيبولت 125 مم",15,17]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E15)=0,\"\",VLOOKUP(E15,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,"",15,13]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E16)=0,\"\",VLOOKUP(E16,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,"",15,11]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E17)=0,\"\",VLOOKUP(E17,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,"",15,45]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E18)=0,\"\",VLOOKUP(E18,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,"",15,45]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E19)=0,\"\",VLOOKUP(E19,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E20)=0,\"\",VLOOKUP(E20,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E21)=0,\"\",VLOOKUP(E21,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E22)=0,\"\",VLOOKUP(E22,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E23)=0,\"\",VLOOKUP(E23,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E24)=0,\"\",VLOOKUP(E24,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E25)=0,\"\",VLOOKUP(E25,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E26)=0,\"\",VLOOKUP(E26,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E27)=0,\"\",VLOOKUP(E27,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E28)=0,\"\",VLOOKUP(E28,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E29)=0,\"\",VLOOKUP(E29,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E30)=0,\"\",VLOOKUP(E30,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"","","",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E31)=0,\"\",VLOOKUP(E31,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"",null,null,null,null,null,null,null,"",null,"",null,null,null,null,"",null,null,"",null,null,""]
[null,"",{"$f":"IF(E33=\"\",\"\",IF($L$1=\"مبيعات\",$D$3,IF($L$1=\"مرتجع\",$C$3,IF($L$1=\"مشتروات\",$B$3))))","v":""},"",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E33)=0,\"\",VLOOKUP(E33,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"",{"$f":"IFERROR(IF(E33=\"\",\"\",SUM(G33:I33)*J33)+SUM(N33,-O33),\"\")","v":""},"",null,null,null,null,"",null,null,"",null,null,""]
[null,"",{"$f":"IF(E34=\"\",\"\",IF($L$1=\"مبيعات\",$D$3,IF($L$1=\"مرتجع\",$C$3,IF($L$1=\"مشتروات\",$B$3))))","v":""},"",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E34)=0,\"\",VLOOKUP(E34,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"",{"$f":"IF(E35=\"\",\"\",IF($L$1=\"مبيعات\",$D$3,IF($L$1=\"مرتجع\",$C$3,IF($L$1=\"مشتروات\",$B$3))))","v":""},"",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E35)=0,\"\",VLOOKUP(E35,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]
[null,"",{"$f":"IF(E36=\"\",\"\",IF($L$1=\"مبيعات\",$D$3,IF($L$1=\"مرتجع\",$C$3,IF($L$1=\"مشتروات\",$B$3))))","v":""},"",null,{"$f":"IF(COUNTIF(data!$C$2:$C$500,E36)=0,\"\",VLOOKUP(E36,data!$C$2:$L$500,2,FALSE))","v":""},null,null,null,"","","",null,null,null,null,"",null,null,"",null,null,""]

{"sheet":"مشتروات","index":2,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,5,1],[0,2,5,2],[0,3,5,3],[0,4,5,4],[0,10,5,10],[0,14,5,14],[0,15,5,15],[0,16,5,16],[0,5,5,5],[1,6,5,6],[1,7,5,7],[1,8,5,8],[0,9,5,9],[0,6,0,8],[0,11,5,11],[0,12,5,12],[0,13,5,13]]}
[null,"م","رقم الفاتورة","التاريخ","كود الصنف","اســم الصنـــــــــــف","العدد - الكمية",null,null,"السعر","الإجمالي","المورد","سعر مضاف","إضافة","خصم","رصيد المخزن","الرصيد بعد البيع"]
[null,null,null,null,null,null,"المصنع","مخزن 1","مخزن 2"]
[]
[]
[]
[]
[]
[null,1,1,"2020-05-05",30,"جيبولت فارغ مرحله 400 مم",20,null,null,36,720,"ABC HTP",null,null,null,null,-20]
[null,2,1,"2020-05-05",13,"استيك جيبولت 160 مم",33,null,null,40,1320,"ABC HTP",null,null,null,null,-33]
[null,1,2,"2020-05-05",12,"استيك جيبولت 125 مم",100,null,null,2,200,"ABC HTP",null,null,null,null,-100]
[null,1,3,"2020-05-05",12,"استيك جيبولت 125 مم",5,null,null,10,50,"ABC HTP",null,null,null,null,-5]
[null,1,4,"2020-05-05",30,"جيبولت فارغ مرحله 400 مم",1,null,null,25,25,"ABC HTP",null,null,null,null,-1]
[null,2,4,"2020-05-05",23,"جيبولت فارغ مرحله 125 مم",1,null,null,23,23,"ABC HTP",null,null,null,null,-1]
[null,3,4,"2020-05-05",13,"استيك جيبولت 160 مم",1,null,null,25,25,"ABC HTP",null,null,null,null,-1]
[null,1,5,"2020-05-05",15,"استيك جيبولت 225 مم",1,null,null,10,10,"ABC HTP",null,null,null,null,-1]
[null,2,5,"2020-05-05",25,"جيبولت فارغ مرحله 200 مم",1,null,null,11,11,"ABC HTP",null,null,null,null,-1]
[null,3,5,"2020-05-05",12,"استيك جيبولت 125 مم",1,null,null,12,12,"ABC HTP",null,null,null,null,-1]
[null,4,5,"2020-05-05",24,"جيبولت فارغ مرحله 160 مم",1,null,null,13,13,"ABC HTP",null,null,null,null,-1]
[null,1,6,"2020-05-05",30,"جيبولت فارغ مرحله 400 مم",33,null,null,12,396,"ABC HTP",null,null,null,null,-33]

{"sheet":"مرتجع","index":3,"n_rows":15,"n_cols":25,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,5,1],[0,2,5,2],[0,3,5,3],[0,4,5,4],[0,5,5,5],[0,15,5,15],[0,16,5,16],[1,6,5,6],[1,7,5,7],[1,8,5,8],[0,9,5,9],[0,10,5,10],[0,11,5,11],[0,12,5,12],[0,13,5,13],[0,14,5,14],[0,6,0,8],[0,22,5,22],[0,23,5,23],[0,24,5,24],[0,17,5,17],[0,18,5,18],[0,19,5,19],[0,20,5,20],[0,21,5,21]]}
[null,"م","رقم الفاتورة","التاريخ","كود الصنف","اســم الصنـــــــــــف","العدد - الكمية",null,null,"السعر","الإجمالي","العميـــــــــــــــل","سعر مضاف","إضافة","خصم","رصيد المخزن","الرصيد بعد البيع","الاضافة الأولى","العدد - الكمية","الاضافة الثانية","العدد - الكمية","الاضافة الثالثة","العدد - الكمية","الاضافة الرابعة","العدد - الكمية"]
[null,null,null,null,null,null,"المصنع","مخزن 1","مخزن 2"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($E7,data,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($E7,data,4,FALSE)*SUM($G7:$I7),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($E7,data,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($E7,data,6,FALSE)*SUM($G7:$I7),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($E7,data,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($E7,data,8,FALSE)*SUM($G7:$I7),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($E7,data,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($E7,data,10,FALSE)*SUM($G7:$I7),\"\")","v":""}]
[null,1,1,"2020-05-05",30,"جيبولت فارغ مرحله 400 مم",1,null,null,15,15,"علي ",null,null,null,null,-1]
[null,2,1,"2020-05-05",23,"جيبولت فارغ مرحله 125 مم",2,null,null,12,24,"علي ",null,null,null,null,-2]
[null,1,2,"2020-05-05",12,"استيك جيبولت 125 مم",2,null,null,10,20,"علي السيد",null,null,null,null,-2]
[null,2,2,"2020-05-05",15,"استيك جيبولت 225 مم",2,null,null,11,22,"علي السيد",null,null,null,null,-2]
[null,1,3,"2020-05-05",30,"جيبولت فارغ مرحله 400 مم",null,null,null,null,0,"علي السيد",null,null,null,null,0]
[null,2,3,"2020-05-05",23,"جيبولت فارغ مرحله 125 مم",null,null,null,null,0,"علي السيد",null,null,null,null,0]
[null,3,3,"2020-05-05",28,"جيبولت فارغ مرحله 315 مم",null,null,null,null,0,"علي السيد",null,null,null,null,0]
[null,4,3,"2020-05-05",25,"جيبولت فارغ مرحله 200 مم",null,null,null,null,0,"علي السيد",null,null,null,null,0]

{"sheet":"مبيعات","index":4,"n_rows":21,"n_cols":25,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,5,1],[0,2,5,2],[0,3,5,3],[0,4,5,4],[0,5,5,5],[0,15,5,15],[0,16,5,16],[1,6,5,6],[1,7,5,7],[1,8,5,8],[0,9,5,9],[0,10,5,10],[0,11,5,11],[0,12,5,12],[0,13,5,13],[0,14,5,14],[0,6,0,8],[0,22,5,22],[0,23,5,23],[0,24,5,24],[0,17,5,17],[0,18,5,18],[0,19,5,19],[0,20,5,20],[0,21,5,21]]}
[null,"م","رقم الفاتورة","التاريخ","كود الصنف","اســم الصنـــــــــــف","العدد - الكمية",null,null,"السعر","الإجمالي","العميــــــــــل","سعر مضاف","إضافة","خصم","رصيد المخزن","الرصيد بعد البيع","الخصم الأول","العدد - الكمية","الخصم الثاني","العدد - الكمية","الخصم الثالث","العدد - الكمية","الخصم الرابع","العدد - الكمية"]
[null,null,null,null,null,null,"المصنع","مخزن 1","مخزن 2"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E7,data,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E7,data,4,FALSE)*SUM($G7:$I7),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E7,data,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E7,data,6,FALSE)*SUM($G7:$I7),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E7,data,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E7,data,8,FALSE)*SUM($G7:$I7),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E7,data,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E7,data,10,FALSE)*SUM($G7:$I7),\"\")","v":""}]
[null,1,1,"2020-05-05",30,"جيبولت فارغ مرحله 400 مم",14,28,36,35,2733,"abn fer",11,16,13,170,92]
[null,2,1,"2020-05-05",23,"جيبولت فارغ مرحله 125 مم",42,32,48,36,4405,"abn fer",17,16,3,336,214]
[null,3,1,"2020-05-05",28,"جيبولت فارغ مرحله 315 مم",10,26,34,37,2600,"abn fer",18,12,2,432,362]
[null,4,1,"2020-05-05",24,"جيبولت فارغ مرحله 160 مم",41,23,17,38,3077,"abn fer",16,10,11,144,63]
[null,5,1,"2020-05-05",13,"استيك جيبولت 160 مم",9,5,30,39,1723,"abn fer",14,17,10,480,436]
[null,6,1,"2020-05-05",25,"جيبولت فارغ مرحله 200 مم",14,28,11,40,2136,"abn fer",20,18,2,96,43]
[null,7,1,"2020-05-05",15,"استيك جيبولت 225 مم",19,16,16,41,2102,"abn fer",12,13,2,48,-3]
[null,8,1,"2020-05-05",12,"استيك جيبولت 125 مم",35,20,36,42,3823,"abn fer",19,11,10,288,197]
[null,1,2,"2020-05-05",23,"جيبولت فارغ مرحله 125 مم",2,null,null,20,40,"abn fer",null,null,null,null,-2]
[null,2,2,"2020-05-05",13,"استيك جيبولت 160 مم",4,null,null,30,120,"abn fer",null,null,null,null,-4]
[null,3,2,"2020-05-05",12,"استيك جيبولت 125 مم",5,null,null,40,200,"abn fer",null,null,null,null,-5]
[null,1,3,"2020-05-05",28,"جيبولت فارغ مرحله 315 مم",3,null,1,20,80,"علي ",null,null,null,null,-4]
[null,1,4,"2020-05-05",30,"جيبولت فارغ مرحله 400 مم",1,1,2,10,40,"علي ",null,null,null,null,-4]
[null,2,4,"2020-05-05",25,"جيبولت فارغ مرحله 200 مم",4,5,1,11,110,"علي ",null,null,null,null,-10]