{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["itemout","perform","Accmove","AccMove D","itemmove"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":40,"comments":1,"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":"itemout","index":0,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,7],[5,1,5,3],[5,5,5,7]]}
[0,"الصرف",null,null,null,null,null,null,null,0]
["نوع الحركة","صرف منتج تام",null,"الاذن اليدوي","test",null,null,null,null,0]
["اذن رقم",{"$f":"IFERROR(IF(B2= \"صرف منتج تام\",[1]setup!D4,IF(B2= \"صرف تام ض\",[1]setup!D11,IF(B2= \"مردودات مبيعات\",[1]setup!D13,[1]setup!D3))),[1]setup!D3)","v":260401},null,"التعامل",null,null,null,null,null,0]
["التاريخ",{"$f":"TODAY()","v":"2026-04-29"},null,null,null,null,null,null,null,0]
["كود العميل",350,null,null,null,null,null,{"$f":"SUM(H8:H8)","v":620},null,0]
["اسم العميل",{"$f":"IFERROR(VLOOKUP(B5,[1]acc!B:C,2,FALSE),\"\")","v":"test 4me"},null,null,"المندوب",null,null,null,null,0,"صافي ",null,null,"معامل التكاليف",0.09]
["م","كود الصنف","اسم الصنف","مواصفات","الوحدة","الكمية","السعر","القيمة","العدد","وزن الالف","الكمية بالكيلو","كود الخامة ","سعر الكيلو","التكلفة المعيارية"]
[1,1,"خامة pvc شرنك",null,null,20,31,{"$f":"F8*G8","v":620},null,null,{"$f":"IF(E8=\"كيلو\",F8*1,IF(E8=\"طن\",F8*1000,IF(E8=\"جرام\",F8/1000,IF(E8=\"كرتونة\",F8,IF(E8=\"كيس\",F8*J8/1000,F8)))))","v":20},null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E8=\"طن\",G8/1000,IF(E8=\"كيلو\",G8,IF(E8=\"جرام\",G8*1000,IF(E8=\"كيس\",H8/K8,IF(E8=\"كرتونة\",G8,F8)))))),VLOOKUP(L8,[1]items!B:I,5,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(B$2=\"خامات\",M8,K8*M8*(1+O$6)),0)","v":0}]
[2,2,"خامات استرتش",null,null,15,33,{"$f":"F9*G9","v":495},null,null,15,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E9=\"طن\",G9/1000,IF(E9=\"كيلو\",G9,IF(E9=\"جرام\",G9*1000,IF(E9=\"كيس\",H9/K9,IF(E9=\"كرتونة\",G9,F9)))))),VLOOKUP(L9,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[3,3,"كرتون",null,null,10,35,{"$f":"F10*G10","v":350},null,null,10,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E10=\"طن\",G10/1000,IF(E10=\"كيلو\",G10,IF(E10=\"جرام\",G10*1000,IF(E10=\"كيس\",H10/K10,IF(E10=\"كرتونة\",G10,F10)))))),VLOOKUP(L10,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[4,4,"كور",null,null,5,37,185,null,null,5,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E11=\"طن\",G11/1000,IF(E11=\"كيلو\",G11,IF(E11=\"جرام\",G11*1000,IF(E11=\"كيس\",H11/K11,IF(E11=\"كرتونة\",G11,F11)))))),VLOOKUP(L11,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[5,5,"سيلوتيب",null,null,5,39,195,null,null,5,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E12=\"طن\",G12/1000,IF(E12=\"كيلو\",G12,IF(E12=\"جرام\",G12*1000,IF(E12=\"كيس\",H12/K12,IF(E12=\"كرتونة\",G12,F12)))))),VLOOKUP(L12,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[6,6,"لزق استرتش فيسيا",null,null,10,41,{"$f":"F13*G13","v":410},null,null,10,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E13=\"طن\",G13/1000,IF(E13=\"كيلو\",G13,IF(E13=\"جرام\",G13*1000,IF(E13=\"كيس\",H13/K13,IF(E13=\"كرتونة\",G13,F13)))))),VLOOKUP(L13,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[7,7,"مواد خامه",null,null,15,43,{"$f":"F14*G14","v":645},null,null,15,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E14=\"طن\",G14/1000,IF(E14=\"كيلو\",G14,IF(E14=\"جرام\",G14*1000,IF(E14=\"كيس\",H14/K14,IF(E14=\"كرتونة\",G14,F14)))))),VLOOKUP(L14,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[8,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E15=\"طن\",G15/1000,IF(E15=\"كيلو\",G15,IF(E15=\"جرام\",G15*1000,IF(E15=\"كيس\",H15/K15,IF(E15=\"كرتونة\",G15,F15)))))),VLOOKUP(L15,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[9,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E16=\"طن\",G16/1000,IF(E16=\"كيلو\",G16,IF(E16=\"جرام\",G16*1000,IF(E16=\"كيس\",H16/K16,IF(E16=\"كرتونة\",G16,F16)))))),VLOOKUP(L16,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[10,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E17=\"طن\",G17/1000,IF(E17=\"كيلو\",G17,IF(E17=\"جرام\",G17*1000,IF(E17=\"كيس\",H17/K17,IF(E17=\"كرتونة\",G17,F17)))))),VLOOKUP(L17,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[11,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E18=\"طن\",G18/1000,IF(E18=\"كيلو\",G18,IF(E18=\"جرام\",G18*1000,IF(E18=\"كيس\",H18/K18,IF(E18=\"كرتونة\",G18,F18)))))),VLOOKUP(L18,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[12,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E19=\"طن\",G19/1000,IF(E19=\"كيلو\",G19,IF(E19=\"جرام\",G19*1000,IF(E19=\"كيس\",H19/K19,IF(E19=\"كرتونة\",G19,F19)))))),VLOOKUP(L19,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[13,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E20=\"طن\",G20/1000,IF(E20=\"كيلو\",G20,IF(E20=\"جرام\",G20*1000,IF(E20=\"كيس\",H20/K20,IF(E20=\"كرتونة\",G20,F20)))))),VLOOKUP(L20,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[14,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E21=\"طن\",G21/1000,IF(E21=\"كيلو\",G21,IF(E21=\"جرام\",G21*1000,IF(E21=\"كيس\",H21/K21,IF(E21=\"كرتونة\",G21,F21)))))),VLOOKUP(L21,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[15,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E22=\"طن\",G22/1000,IF(E22=\"كيلو\",G22,IF(E22=\"جرام\",G22*1000,IF(E22=\"كيس\",H22/K22,IF(E22=\"كرتونة\",G22,F22)))))),VLOOKUP(L22,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[16,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E23=\"طن\",G23/1000,IF(E23=\"كيلو\",G23,IF(E23=\"جرام\",G23*1000,IF(E23=\"كيس\",H23/K23,IF(E23=\"كرتونة\",G23,F23)))))),VLOOKUP(L23,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[17,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E24=\"طن\",G24/1000,IF(E24=\"كيلو\",G24,IF(E24=\"جرام\",G24*1000,IF(E24=\"كيس\",H24/K24,IF(E24=\"كرتونة\",G24,F24)))))),VLOOKUP(L24,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[18,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E25=\"طن\",G25/1000,IF(E25=\"كيلو\",G25,IF(E25=\"جرام\",G25*1000,IF(E25=\"كيس\",H25/K25,IF(E25=\"كرتونة\",G25,F25)))))),VLOOKUP(L25,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[19,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E26=\"طن\",G26/1000,IF(E26=\"كيلو\",G26,IF(E26=\"جرام\",G26*1000,IF(E26=\"كيس\",H26/K26,IF(E26=\"كرتونة\",G26,F26)))))),VLOOKUP(L26,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[20,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E27=\"طن\",G27/1000,IF(E27=\"كيلو\",G27,IF(E27=\"جرام\",G27*1000,IF(E27=\"كيس\",H27/K27,IF(E27=\"كرتونة\",G27,F27)))))),VLOOKUP(L27,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[21,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E28=\"طن\",G28/1000,IF(E28=\"كيلو\",G28,IF(E28=\"جرام\",G28*1000,IF(E28=\"كيس\",H28/K28,IF(E28=\"كرتونة\",G28,F28)))))),VLOOKUP(L28,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[22,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E29=\"طن\",G29/1000,IF(E29=\"كيلو\",G29,IF(E29=\"جرام\",G29*1000,IF(E29=\"كيس\",H29/K29,IF(E29=\"كرتونة\",G29,F29)))))),VLOOKUP(L29,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[23,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E30=\"طن\",G30/1000,IF(E30=\"كيلو\",G30,IF(E30=\"جرام\",G30*1000,IF(E30=\"كيس\",H30/K30,IF(E30=\"كرتونة\",G30,F30)))))),VLOOKUP(L30,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[24,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E31=\"طن\",G31/1000,IF(E31=\"كيلو\",G31,IF(E31=\"جرام\",G31*1000,IF(E31=\"كيس\",H31/K31,IF(E31=\"كرتونة\",G31,F31)))))),VLOOKUP(L31,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[25,null,"",null,null,null,null,0,null,null,0,null,{"$f":"IFERROR(IF(B$2=\"استلام خامات\",(IF(E32=\"طن\",G32/1000,IF(E32=\"كيلو\",G32,IF(E32=\"جرام\",G32*1000,IF(E32=\"كيس\",H32/K32,IF(E32=\"كرتونة\",G32,F32)))))),VLOOKUP(L32,[1]items!B:I,5,FALSE)),\"\")","v":""},0]
[null,null,null,null,null,null,"الصافي قبل ض",{"$f":"SUM(H8:H32)","v":2900}]
[null,null,null,null,null,null,"ض قيمة مضافة",{"$f":"IFERROR(IF(E$3<>\"\",H$33*0.14,0),0)","v":0}]
[null,null,null,null,null,null,"ض الخصم",{"$f":"IFERROR(IF(E$3<>\"\",H$33*0.01,0),0)","v":0}]
[null,null,null,null,null,null,"الصافي",{"$f":"H33+H34-H35","v":2900}]

{"sheet":"perform","index":1,"n_rows":11,"n_cols":28,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[0,null,null,null,null,null,null,null,null,null,null,{"$f":"N2/K2","v":36.25},null,{"$f":"(K1*L1)","v":0},null,{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17}]
[0,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K5:K48389)","v":-80},{"$f":"IFERROR(SUBTOTAL(1,L5:L47737),0)","v":37},null,{"$f":"SUBTOTAL(9,N5:N47737)","v":-2900},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,Z5:Z47737)","v":-80}]
["متابعة اذون"]
["م","رقم الاذن","تاريخ الاذن","كود العميل","اسم العميل","رقم امر التوريد","كود الصنف","اسم الصنف","المندوب","الوحدة","الكمية","السعر","كمية تسليم","القيمة","حالة الامر","رقم الفاتورة ","تاريخ  الفاتورة","كود الخامة","صافي الكمية","عجز الكمية","نوع العجز","نوع الحركة","القيمة","group","اذن العميل"]
[{"$f":"IF((A4)<>\"م\",(A4)+1,1)","v":1},260401,"2026-04-29",350,"test 4me","test",1,"خامة pvc شرنك",null,null,-20,31,null,{"$f":"(K5*L5)","v":-620},null,"no",null,null,null,null,null,"صرف منتج تام",null,null,null,{"$f":"IF(M5>0,M5*-1,K5)","v":-20},{"$f":"IF(M5>0,(K5+M5)/K5,0)","v":0},{"$f":"MONTH(C5)","v":4}]
[{"$f":"IF((A5)<>\"م\",(A5)+1,1)","v":2},260401,"2026-04-29",350,"test 4me","test",2,"خامات استرتش",null,null,-15,33,null,{"$f":"(K6*L6)","v":-495},null,"no",null,null,null,null,null,"صرف منتج تام",null,null,null,{"$f":"IF(M6>0,M6*-1,K6)","v":-15},{"$f":"IF(M6>0,(K6+M6)/K6,0)","v":0},{"$f":"MONTH(C6)","v":4}]
[{"$f":"IF((A6)<>\"م\",(A6)+1,1)","v":3},260401,"2026-04-29",350,"test 4me","test",3,"كرتون",null,null,-10,35,null,{"$f":"(K7*L7)","v":-350},null,"no",null,null,null,null,null,"صرف منتج تام",null,null,null,{"$f":"IF(M7>0,M7*-1,K7)","v":-10},{"$f":"IF(M7>0,(K7+M7)/K7,0)","v":0},{"$f":"MONTH(C7)","v":4}]
[{"$f":"IF((A7)<>\"م\",(A7)+1,1)","v":4},260401,"2026-04-29",350,"test 4me","test",4,"كور",null,null,-5,37,null,{"$f":"(K8*L8)","v":-185},null,"no",null,null,null,null,null,"صرف منتج تام",null,null,null,{"$f":"IF(M8>0,M8*-1,K8)","v":-5},{"$f":"IF(M8>0,(K8+M8)/K8,0)","v":0},{"$f":"MONTH(C8)","v":4}]
[{"$f":"IF((A8)<>\"م\",(A8)+1,1)","v":5},260401,"2026-04-29",350,"test 4me","test",5,"سيلوتيب",null,null,-5,39,null,{"$f":"(K9*L9)","v":-195},null,"no",null,null,null,null,null,"صرف منتج تام",null,null,null,{"$f":"IF(M9>0,M9*-1,K9)","v":-5},{"$f":"IF(M9>0,(K9+M9)/K9,0)","v":0},{"$f":"MONTH(C9)","v":4}]
[{"$f":"IF((A9)<>\"م\",(A9)+1,1)","v":6},260401,"2026-04-29",350,"test 4me","test",6,"لزق استرتش فيسيا",null,null,-10,41,null,{"$f":"(K10*L10)","v":-410},null,"no",null,null,null,null,null,"صرف منتج تام",null,null,null,{"$f":"IF(M10>0,M10*-1,K10)","v":-10},{"$f":"IF(M10>0,(K10+M10)/K10,0)","v":0},{"$f":"MONTH(C10)","v":4}]
[{"$f":"IF((A10)<>\"م\",(A10)+1,1)","v":7},260401,"2026-04-29",350,"test 4me","test",7,"مواد خامه",null,null,-15,43,null,{"$f":"(K11*L11)","v":-645},null,"no",null,null,null,null,null,"صرف منتج تام",null,null,null,{"$f":"IF(M11>0,M11*-1,K11)","v":-15},{"$f":"IF(M11>0,(K11+M11)/K11,0)","v":0},{"$f":"MONTH(C11)","v":4}]

{"sheet":"Accmove","index":2,"n_rows":10,"n_cols":22,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19}]
[0,"الرصيد",null,null,null,null,null,{"$f":"SUBTOTAL(9,H$4:$H84149)","v":20300},{"$f":"SUBTOTAL(9,$I$4:I84149)","v":0},{"$f":"H2-I2","v":20300},null,{"$f":"SUBTOTAL(9,L4:L5)","v":0},null,{"$f":"SUBTOTAL(9,N4:N5)","v":0}]
["م","كود االحساب","اسم الحساب","رقم امر التوريد","رقم الاذن","يدوي","تاريخ الحركة",0,"دائن",{"$f":"SUMIFS(H3:H$4,B3:B$4,B3)-SUMIFS(I3:I$4,B3:B$4,B3)","v":0},null,"ض مبيعات",null,"ض ا ت ص","التصنيف","نوع الحركة","group","الاذن مسلسل","البيان","التوجيه","مدين $","دائن $"]
[{"$f":"ROW()-3","v":1},350,"test 4me",null,260401,"test",46141,2900,null,{"$f":"SUMIFS(H$4:H4,B$4:B4,B4)-SUMIFS(I$4:I4,B$4:B4,B4)","v":2900},20,0,null,0,null,"صرف منتج تام",null,null,null,{"$f":"MONTH(G4)","v":4}]
[{"$f":"ROW()-3","v":2},350,"test 4me",null,260401,"test",46141,2900,null,{"$f":"SUMIFS(H$4:H5,B$4:B5,B5)-SUMIFS(I$4:I5,B$4:B5,B5)","v":5800},15,0,null,0,null,"صرف منتج تام",null,null,null,{"$f":"MONTH(G5)","v":4}]
[{"$f":"ROW()-3","v":3},350,"test 4me",null,260401,"test",46141,2900,null,{"$f":"SUMIFS(H$4:H6,B$4:B6,B6)-SUMIFS(I$4:I6,B$4:B6,B6)","v":8700},10,0,null,0,null,"صرف منتج تام",null,null,null,{"$f":"MONTH(G6)","v":4}]
[{"$f":"ROW()-3","v":4},350,"test 4me",null,260401,"test",46141,2900,null,{"$f":"SUMIFS(H$4:H7,B$4:B7,B7)-SUMIFS(I$4:I7,B$4:B7,B7)","v":11600},5,0,null,0,null,"صرف منتج تام",null,null,null,{"$f":"MONTH(G7)","v":4}]
[{"$f":"ROW()-3","v":5},350,"test 4me",null,260401,"test",46141,2900,null,{"$f":"SUMIFS(H$4:H8,B$4:B8,B8)-SUMIFS(I$4:I8,B$4:B8,B8)","v":14500},5,0,null,0,null,"صرف منتج تام",null,null,null,{"$f":"MONTH(G8)","v":4}]
[{"$f":"ROW()-3","v":6},350,"test 4me",null,260401,"test",46141,2900,null,{"$f":"SUMIFS(H$4:H9,B$4:B9,B9)-SUMIFS(I$4:I9,B$4:B9,B9)","v":17400},10,0,null,0,null,"صرف منتج تام",null,null,null,{"$f":"MONTH(G9)","v":4}]
[{"$f":"ROW()-3","v":7},350,"test 4me",null,260401,"test",46141,2900,null,{"$f":"SUMIFS(H$4:H10,B$4:B10,B10)-SUMIFS(I$4:I10,B$4:B10,B10)","v":20300},15,0,null,0,null,"صرف منتج تام",null,null,null,{"$f":"MONTH(G10)","v":4}]

{"sheet":"AccMove D","index":3,"n_rows":11,"n_cols":26,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[0]
[0]
[0]
["م","رقم الاذن","التاريخ","كود المورد","اسم المورد","رقم امر التوريد","كود الصنف","اسم الصنف","المندوب","الوحدة","الكمية","السعر","كمية تسليم","القيمة","حالة الامر","رقم الفاتورة ","تاريخ  الفاتورة","كود الخامة","صافي الكمية","عجز الكمية","نوع العجز","نوع الحركة","قيمة الاذن","مدين ","دائن ","رصيد"]
[{"$f":"ROW()-4","v":1},260401,"2026-04-29",350,"test 4me","test",1,"خامة pvc شرنك",null,null,20,31,null,{"$f":"(K5*L5)","v":620},null,"no",null,null,null,null,null,"صرف منتج تام",{"$f":"IF(B5<>B4,SUMIFS(N:N,B:B,B5,V:V,V5),0)","v":2900},{"$f":"IF(OR(V5<>V4,B5<>B4),SUMIFS(N:N,B:B,B5,V:V,V5),0)","v":2900},null,{"$f":"SUMIFS(X$4:X5,D$4:D5,D5)-SUMIFS(Y$4:Y5,D$4:D5,D5)","v":2900}]
[{"$f":"ROW()-4","v":2},260401,"2026-04-29",350,"test 4me","test",2,"خامات استرتش",null,null,15,33,null,{"$f":"(K6*L6)","v":495},null,"no",null,null,null,null,null,"صرف منتج تام",{"$f":"IF(B6<>B5,SUMIFS(N:N,B:B,B6,V:V,V6),0)","v":0},{"$f":"IF(OR(V6<>V5,B6<>B5),SUMIFS(N:N,B:B,B6,V:V,V6),0)","v":0},null,{"$f":"SUMIFS(X$4:X6,D$4:D6,D6)-SUMIFS(Y$4:Y6,D$4:D6,D6)","v":2900}]
[{"$f":"ROW()-4","v":3},260401,"2026-04-29",350,"test 4me","test",3,"كرتون",null,null,10,35,null,{"$f":"(K7*L7)","v":350},null,"no",null,null,null,null,null,"صرف منتج تام",{"$f":"IF(B7<>B6,SUMIFS(N:N,B:B,B7,V:V,V7),0)","v":0},{"$f":"IF(OR(V7<>V6,B7<>B6),SUMIFS(N:N,B:B,B7,V:V,V7),0)","v":0},null,{"$f":"SUMIFS(X$4:X7,D$4:D7,D7)-SUMIFS(Y$4:Y7,D$4:D7,D7)","v":2900}]
[{"$f":"ROW()-4","v":4},260401,"2026-04-29",350,"test 4me","test",4,"كور",null,null,5,37,null,{"$f":"(K8*L8)","v":185},null,"no",null,null,null,null,null,"صرف منتج تام",{"$f":"IF(B8<>B7,SUMIFS(N:N,B:B,B8,V:V,V8),0)","v":0},{"$f":"IF(OR(V8<>V7,B8<>B7),SUMIFS(N:N,B:B,B8,V:V,V8),0)","v":0},null,{"$f":"SUMIFS(X$4:X8,D$4:D8,D8)-SUMIFS(Y$4:Y8,D$4:D8,D8)","v":2900}]
[{"$f":"ROW()-4","v":5},260401,"2026-04-29",350,"test 4me","test",5,"سيلوتيب",null,null,5,39,null,{"$f":"(K9*L9)","v":195},null,"no",null,null,null,null,null,"صرف منتج تام",{"$f":"IF(B9<>B8,SUMIFS(N:N,B:B,B9,V:V,V9),0)","v":0},{"$f":"IF(OR(V9<>V8,B9<>B8),SUMIFS(N:N,B:B,B9,V:V,V9),0)","v":0},null,{"$f":"SUMIFS(X$4:X9,D$4:D9,D9)-SUMIFS(Y$4:Y9,D$4:D9,D9)","v":2900}]
[{"$f":"ROW()-4","v":6},260401,"2026-04-29",350,"test 4me","test",6,"لزق استرتش فيسيا",null,null,10,41,null,{"$f":"(K10*L10)","v":410},null,"no",null,null,null,null,null,"صرف منتج تام",{"$f":"IF(B10<>B9,SUMIFS(N:N,B:B,B10,V:V,V10),0)","v":0},{"$f":"IF(OR(V10<>V9,B10<>B9),SUMIFS(N:N,B:B,B10,V:V,V10),0)","v":0},null,{"$f":"SUMIFS(X$4:X10,D$4:D10,D10)-SUMIFS(Y$4:Y10,D$4:D10,D10)","v":2900}]
[{"$f":"ROW()-4","v":7},260401,"2026-04-29",350,"test 4me","test",7,"مواد خامه",null,null,15,43,null,{"$f":"(K11*L11)","v":645},null,"no",null,null,null,null,null,"صرف منتج تام",{"$f":"IF(B11<>B10,SUMIFS(N:N,B:B,B11,V:V,V11),0)","v":0},{"$f":"IF(OR(V11<>V10,B11<>B10),SUMIFS(N:N,B:B,B11,V:V,V11),0)","v":0},null,{"$f":"SUMIFS(X$4:X11,D$4:D11,D11)-SUMIFS(Y$4:Y11,D$4:D11,D11)","v":2900}]

{"sheet":"itemmove","index":4,"n_rows":11,"n_cols":19,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[" ",null,{"$f":"COLUMN()","v":3},null,{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},null,null,{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},null,null,{"$f":"COLUMN()","v":13},null,null,{"$f":"COLUMN()","v":16},null,null,{"$f":"COLUMN()","v":19}]
[0,"حركات الاصناف"]
[0,null,null,null,null,null,"الرصيد",null,{"$f":"SUBTOTAL(9,I1003:I3914)","v":0},{"$f":"SUBTOTAL(9,J1003:J3914)","v":0},null,null,{"$f":"I3-J3","v":0}]
["م","كود الصنف","اسم الصنف","المواصفات","الوحدة","نوع الحركة","رقم الاذن","رقم الفاتورة","كمية الاضافة  / كيلو","كمية الصرف /كيلو ","الرصيد","المورد او العميل","التكلفة/ الكيلو","سعر البيع",null,"رقم اذن العميل","كمية المنتج التام","كمية المكون","الرصيد"]
[{"$f":"IF((A4)<>\"م\",(A4)+1,1)","v":1},1,"خامة pvc شرنك",null,null,"صرف منتج تام",260401,"test",null,20,{"$f":"SUMIFS(I$5:I5,B$5:B5,B5)-SUMIFS(J$5:J5,B$5:B5,B5)","v":-20},350,"",null,"2026-04-29"]
[{"$f":"IF((A5)<>\"م\",(A5)+1,1)","v":2},2,"خامات استرتش",null,null,"صرف منتج تام",260401,"test",null,15,{"$f":"SUMIFS(I$5:I6,B$5:B6,B6)-SUMIFS(J$5:J6,B$5:B6,B6)","v":-15},350,"",null,"2026-04-29"]
[{"$f":"IF((A6)<>\"م\",(A6)+1,1)","v":3},3,"كرتون",null,null,"صرف منتج تام",260401,"test",null,10,{"$f":"SUMIFS(I$5:I7,B$5:B7,B7)-SUMIFS(J$5:J7,B$5:B7,B7)","v":-10},350,"",null,"2026-04-29"]
[{"$f":"IF((A7)<>\"م\",(A7)+1,1)","v":4},4,"كور",null,null,"صرف منتج تام",260401,"test",null,5,{"$f":"SUMIFS(I$5:I8,B$5:B8,B8)-SUMIFS(J$5:J8,B$5:B8,B8)","v":-5},350,"",null,"2026-04-29"]
[{"$f":"IF((A8)<>\"م\",(A8)+1,1)","v":5},5,"سيلوتيب",null,null,"صرف منتج تام",260401,"test",null,5,{"$f":"SUMIFS(I$5:I9,B$5:B9,B9)-SUMIFS(J$5:J9,B$5:B9,B9)","v":-5},350,"",null,"2026-04-29"]
[{"$f":"IF((A9)<>\"م\",(A9)+1,1)","v":6},6,"لزق استرتش فيسيا",null,null,"صرف منتج تام",260401,"test",null,10,{"$f":"SUMIFS(I$5:I10,B$5:B10,B10)-SUMIFS(J$5:J10,B$5:B10,B10)","v":-10},350,"",null,"2026-04-29"]
[{"$f":"IF((A10)<>\"م\",(A10)+1,1)","v":7},7,"مواد خامه",null,null,"صرف منتج تام",260401,"test",null,15,{"$f":"SUMIFS(I$5:I11,B$5:B11,B11)-SUMIFS(J$5:J11,B$5:B11,B11)","v":-15},350,"",null,"2026-04-29"]