{"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,"2022-01-01",null,"2023-05-10"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"TOTAL","index":1,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,2,0,11]]}
[null,null,"إجمالي حركة الأصناف"]
["م","المخازن","النوع","كود الصنف","اسم الصنف","الوحدة","رصيد اول","حد الطلب","إضافة","مرتجع داخلي","مرتجع للمورد","منصرف","إهلاك","رصيد آخر","TRUE"]
[{"$f":"ROW()-2","v":1},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":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
["م","رقم الاذن","التاريخ","المخزن","الحركة","كود الصنف","النوع","اسم الصنف","الوحدة","الكمية","المورد/المنصرف له","المستلم","ملاحظات"]
[{"$f":"ROW()-2","v":1}]

{"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,null,null,null,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," "]

{"sheet":"itm","index":4,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,2,0,5],[2,2,2,4],[3,6,3,7],[1,2,1,3],[10,1,10,2]]}
[null,null,"كرت صنف",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($C$3,Table2[[#All],[اسم الصنف]:[رصيد آخر]],10,0)","v":{"$error":"#N/A"}},{"$f":"SUMIF(Table7[الحركة],\"إضافة\",Table7[الكمية])+SUMIF(Table7[الحركة],\"مرتجع مورد\",Table7[الكمية])-SUMIF(Table7[الحركة],\"صرف\",Table7[الكمية])-SUMIF(Table7[الحركة],\"مرتجع للمورد\",Table7[الكمية])","v":3040},{"$f":"M1-N1","v":{"$error":"#N/A"}},{"$f":"SUMIFS(Table7[الكمية],Table7[الحركة],\"إضافة\",Table7[الحركة],\"صرف\")","v":0},{"$f":"TODAY()","v":"2023-12-14"}]
[null,"كود الصنف",10215,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01"]
[null,"اسم الصنف","تيشرت صوف موديل1020"]
[null,"من تاريخ","2022-01-01","حتى تاريخ","2023-05-14","المخزن",{"$f":"INDEX(Table2[],MATCH($C$2,TOTAL!D3:D3,0),2)","v":{"$error":"#N/A"}}]
[null,"م#","التاريخ","رقم الإذن","بيــــــــان","الحركة","الكمية","الرصيد"]
[]
[null,null,null,null,"رصيد أول المدة",null,null,160]
[null,7,44903,147,"قماش","إضافة",1520,{"$f":"IF(OR(F8=\"إضافة\",F8=\"مرتجع داخلي\"),H7+G8,H7-G8)","v":1680}]
[null,19,44903,147,"قماش","إضافة",1520,{"$f":"IF(OR(F9=\"إضافة\",F9=\"مرتجع داخلي\"),H8+G9,H8-G9)","v":3200}]
[]
[null,"الـرصـــيد الحــالـــي",null,null,null,null,null,3200]

{"sheet":"Data","index":5,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":true,"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,"مخزن الصيانة"]