{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home_","TOTAL","Daily","Report","itm","Data"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":10,"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":"Home_","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"خامات كود 006"]
[null,null,"2024-01-01",null,"2025-01-01"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"TOTAL","index":1,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,2,0,11]]}
[null,null,"إجمالي حركة الأصناف"]
["م","المخازن","النوع","كود الصنف","اسم الصنف","الوحدة","رصيد اول","حد الطلب","إضافة","مرتجع داخلي","مرتجع للمورد","منصرف","إهلاك","رصيد آخر","TRUE"]
[{"$f":"ROW()-2","v":1},"ارض اللواء","رئيسي",2,"شوال دقيق اهرامات","كيس",0,5,{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],Table2[[#Headers],[إضافة]],Table1[اسم الصنف],Table2[اسم الصنف])","v":5},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],Table2[[#Headers],[مرتجع داخلي]],Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],Table2[[#Headers],[مرتجع للمورد]],Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],\"صرف\",Table1[اسم الصنف],Table2[اسم الصنف])","v":4},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],\"إهلاك\",Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"Table2[[#This Row],[رصيد اول]]+Table2[[#This Row],[إضافة]]+Table2[[#This Row],[مرتجع داخلي]]-(Table2[[#This Row],[منصرف]]+Table2[[#This Row],[مرتجع للمورد]]+Table2[[#This Row],[إهلاك]])","v":1},{"$f":"Table2[[#This Row],[رصيد آخر]]>Table2[[#This Row],[حد الطلب]]","v":false}]
[{"$f":"ROW()-2","v":2},1,2,1,"سكر","حبة",1,10,{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],Table2[[#Headers],[إضافة]],Table1[اسم الصنف],Table2[اسم الصنف])","v":50},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],Table2[[#Headers],[مرتجع داخلي]],Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],Table2[[#Headers],[مرتجع للمورد]],Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],\"صرف\",Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],\"إهلاك\",Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"Table2[[#This Row],[رصيد اول]]+Table2[[#This Row],[إضافة]]+Table2[[#This Row],[مرتجع داخلي]]-(Table2[[#This Row],[منصرف]]+Table2[[#This Row],[مرتجع للمورد]]+Table2[[#This Row],[إهلاك]])","v":51},{"$f":"Table2[[#This Row],[رصيد آخر]]>Table2[[#This Row],[حد الطلب]]","v":true}]
[{"$f":"ROW()-2","v":3},null,null,null,null,null,null,null,{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],Table2[[#Headers],[إضافة]],Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],Table2[[#Headers],[مرتجع داخلي]],Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],Table2[[#Headers],[مرتجع للمورد]],Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],\"صرف\",Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"SUMIFS(Table1[الكمية],Table1[الحركة],\"إهلاك\",Table1[اسم الصنف],Table2[اسم الصنف])","v":0},{"$f":"Table2[[#This Row],[رصيد اول]]+Table2[[#This Row],[إضافة]]+Table2[[#This Row],[مرتجع داخلي]]-(Table2[[#This Row],[منصرف]]+Table2[[#This Row],[مرتجع للمورد]]+Table2[[#This Row],[إهلاك]])","v":0},{"$f":"Table2[[#This Row],[رصيد آخر]]>Table2[[#This Row],[حد الطلب]]","v":false}]

{"sheet":"Daily","index":2,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
["م","رقم الاذن","التاريخ","المخزن","الحركة","كود الصنف","النوع","اسم الصنف","الوحدة","الكمية","المورد/المنصرف له","المستلم","ملاحظات"]
[{"$f":"ROW()-2","v":1},5,"2024-11-07","ارض اللواء","صرف",2,"رئيسي","شوال دقيق اهرامات","كيس",4,"المطعم","المطعم","وحدات"]
[{"$f":"ROW()-2","v":2},3,"2024-11-07","ارض اللواء","إضافة",2,"رئيسي","شوال دقيق اهرامات","كيس",5,"مصطفى العطار","عماد","لاتوجد"]
[{"$f":"ROW()-2","v":3},25,"2024-11-07",1,"إضافة",1,2,"سكر","حبة",50,5255,555,9999]
[{"$f":"ROW()-2","v":4}]

{"sheet":"Report","index":3,"n_rows":15,"n_cols":24,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"رقم الاذن","المخزن","الحركة","كود الصنف","النوع","اسم الصنف","المورد/المنصرف له","التاريخ","التاريخ"]
[null,null,"رقم الاذن",null,"الحركة",null,"اسم الصنف","خامات كود 006","من تاريخ",null,null,null,null,null,null,5,"مخزن الإنتاج التام","صرف",null,null,"شوال دقيق اهرامات",null,">=16/05/2023","<="]
[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,"2020-01-01",{"$f":"TODAY()","v":"2024-11-07"}]
[null,"رقم الاذن","التاريخ","المخزن","الحركة","كود الصنف","النوع","اسم الصنف","الوحدة","الكمية","المورد/المنصرف له","المستلم","ملاحظات"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"itm","index":4,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,2,0,5],[2,2,2,4],[3,6,3,7],[1,2,1,3],[9,1,9,2]]}
[null,null,"كرت صنف",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($C$3,Table2[[#All],[اسم الصنف]:[رصيد آخر]],10,0)","v":51},{"$f":"SUMIF(Table7[الحركة],\"إضافة\",Table7[الكمية])+SUMIF(Table7[الحركة],\"مرتجع مورد\",Table7[الكمية])-SUMIF(Table7[الحركة],\"صرف\",Table7[الكمية])-SUMIF(Table7[الحركة],\"مرتجع للمورد\",Table7[الكمية])","v":50},{"$f":"M1-N1","v":1},{"$f":"SUMIFS(Table7[الكمية],Table7[الحركة],\"إضافة\",Table7[الحركة],\"صرف\")","v":0},{"$f":"TODAY()","v":"2024-11-07"}]
[null,"كود الصنف",1,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01"]
[null,"اسم الصنف","سكر"]
[null,"من تاريخ","2022-01-01","حتى تاريخ","2024-11-07","المخزن",{"$f":"INDEX(Table2[],MATCH($C$2,TOTAL!D3:D5,0),2)","v":1}]
[null,"م#","التاريخ","رقم الإذن","بيــــــــان","الحركة","الكمية","الرصيد"]
[]
[null,null,null,null,"رصيد أول المدة",null,null,1]
[null,3,45603,25,2,"إضافة",50,{"$f":"IF(OR(F8=\"إضافة\",F8=\"مرتجع داخلي\"),H7+G8,H7-G8)","v":51}]
[]
[null,"الـرصـــيد الحــالـــي",null,null,null,null,null,51]

{"sheet":"Data","index":5,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"الوحدات",null,"المخازن",null,"الموردين",null,"جهات الصرف",null,"إضافة"]
[null,"كيلو",null,"مخزن الإنتاج التام",null,"شركة السعد",null,"الإنتاج",null,"صرف"]
[null,"عدد",null,"مخزن التعبئة",null,"أبو إبراهيم",null,"الصيانة",null,"مرتجع داخلي"]
[null,"كرتونة",null,"مخزن نصف مصنع",null,"مشغل الندى",null,null,null,"مرتجع للمورد"]
[null,"بالتة",null,"مخزن خامات",null,"Blue Cat",null,null,null,"إهلاك"]
[null,"دستة",null,"مخزن الصيانة"]