{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["الصفحة الرئيسية","اذون الصرف","توزيع المخزون","كهرباء"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"الصفحة الرئيسية","index":0,"n_rows":11,"n_cols":24,"rows_kept":11,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مراكز الإنتاج تصنيع","تصنيع",100,"مبني 1","خامة 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مراكز الإنتاج تصنيع","تصنيع",101,"مبني 2","خامة 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مراكز الإنتاج تجميع","تجميع",200,"مبني 8","خامات مساعده"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مراكز الإنتاج تجميع","تجميع",201,"مبني 9","وقود وزيوت"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"خدمات الانتاج",null,300,"مخازن","قطع غيار ومهمات"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"خدمات الانتاج",null,301,"ورشة صيانة","مصروفات صيانة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"خدمات التسويقية",null,400,"صالة 1","مصروفات اخرى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"خدمات التسويقية",null,401,"صالة 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"خدمات الادارية",null,500,"مدير المصنع"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"خدمات الادارية",null,501,"الادارة"]

{"sheet":"اذون الصرف","index":1,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["اصول ثابتة","مصارف صيانة","مصروفات اخرى","رقم الاذن","كود المخزن","التاريخ","اسم الطالب","كود الصنف","اسم الصنف","عمود1","الوحدة","الكمية المطلوبة","سعر الوحدة","القيمة","مركز التكلفة","نوع المخزون"]
[null,null,null,1,22,"2021-07-01","علي",564,"خامة رقم 1",null,"كيلو",300,120,{"$f":"L3*M3","v":36000},"مبني 1","خامة 1"]
[null,null,null,2,22,"2021-07-05","سيد",566,"خامة رقم 2",null,"كيلو",300,120,36000,"مبني 2","خامة 2"]

{"sheet":"توزيع المخزون","index":2,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"توزيع المخزون","2021-07-01","2021-07-05",{"$f":"\">=\"&E1","v":">=44378"},{"$f":"\"<=\"&F1","v":"<=44382"}]
["عمود1","عمود2","رقم مركز التكلفة","مركز التكلفة","خامة 1","خامة 2","اجمالي خامات رئيسية","خامات مساعده","اجمالي الخامات","وقود وزيوت","قطع غيار ومهمات","مصروفات صيانة","كهرباء","مصروفات اخرى","الاجمالي"]
[]
["مراكز الإنتاج تصنيع","تصنيع",100,"مبني 1",{"$f":"SUMIFS('اذون الصرف'!$N$3:$N$20,'اذون الصرف'!$O$3:$O$20,D4,'اذون الصرف'!$P$3:$P$20,الجدول3[[#Headers],[خامة 1]],'اذون الصرف'!$F$3:$F$20,$G$1,'اذون الصرف'!$F$3:$F$20,'توزيع المخزون'!$H$1)","v":36000},{"$f":"SUMIFS('اذون الصرف'!$N$3:$N$20,'اذون الصرف'!$O$3:$O$20,D4,'اذون الصرف'!$P$3:$P$20,الجدول3[[#Headers],[خامة 2]],'اذون الصرف'!$F$3:$F$20,$G$1,'اذون الصرف'!$F$3:$F$20,'توزيع المخزون'!$H$1)","v":0},{"$f":"E4+F4","v":36000},null,{"$f":"G4+H4","v":36000},null,null,null,{"$f":"SUMIFS(كهرباء!$D$3:$D$9,كهرباء!$C$3:$C$9,D4,كهرباء!$A$3:$A$9,$G$1,كهرباء!$A$3:$A$9,'توزيع المخزون'!$H$1)","v":23000},null,{"$f":"SUBTOTAL(109,I4:N4)","v":59000}]
["مراكز الإنتاج تصنيع","تصنيع",101,"مبني 2",{"$f":"SUMIFS('اذون الصرف'!$N$3:$N$20,'اذون الصرف'!$O$3:$O$20,D5,'اذون الصرف'!$P$3:$P$20,الجدول3[[#Headers],[خامة 1]],'اذون الصرف'!$F$3:$F$20,$G$1,'اذون الصرف'!$F$3:$F$20,'توزيع المخزون'!$H$1)","v":0},{"$f":"SUMIFS('اذون الصرف'!$N$3:$N$20,'اذون الصرف'!$O$3:$O$20,D5,'اذون الصرف'!$P$3:$P$20,الجدول3[[#Headers],[خامة 2]],'اذون الصرف'!$F$3:$F$20,$G$1,'اذون الصرف'!$F$3:$F$20,'توزيع المخزون'!$H$1)","v":36000},null,null,null,null,null,null,{"$f":"SUMIFS(كهرباء!$D$3:$D$9,كهرباء!$C$3:$C$9,D5,كهرباء!$A$3:$A$9,$G$1,كهرباء!$A$3:$A$9,'توزيع المخزون'!$H$1)","v":21000},null,{"$f":"SUBTOTAL(109,I5:N5)","v":21000}]
["اجمالي التصنيع",null,null,"اجمالي التصنيع",{"$f":"SUM(E4:E5)","v":36000},{"$f":"SUM(F4:F5)","v":36000},36000,0,36000,0,0,0,44000,0,80000]
["مراكز الإنتاج تجميع","تجميع",200,"مبني 8",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(كهرباء!$D$3:$D$9,كهرباء!$C$3:$C$9,D7,كهرباء!$A$3:$A$9,$G$1,كهرباء!$A$3:$A$9,'توزيع المخزون'!$H$1)","v":0},null,0]
["مراكز الإنتاج تجميع","تجميع",201,"مبني 9",null,null,null,null,null,null,null,null,{"$f":"SUMIFS(كهرباء!$D$3:$D$9,كهرباء!$C$3:$C$9,D8,كهرباء!$A$3:$A$9,$G$1,كهرباء!$A$3:$A$9,'توزيع المخزون'!$H$1)","v":0},null,0]
["اجمالي التصنيع",null,null,"اجمالي التجميع",{"$f":"SUM(E7:E8)","v":0},{"$f":"SUM(F7:F8)","v":0},0,0,0,0,0,0,0,0,0]
["اجمالي المراكز",null,null,"اجمالي المراكز",{"$f":"E6+E9","v":36000},{"$f":"F6+F9","v":36000},36000,0,36000,0,0,0,44000,0,80000]
["خدمات الانتاج",null,300,"مخازن",null,null,null,null,null,null,null,null,null,null,0]
["خدمات الانتاج",null,301,"ورشة صيانة",null,null,null,null,null,null,null,null,null,null,0]
["اجمالي خدمات الانتاج",null,null,"اجمالي خدمات الانتاج",{"$f":"SUM(E11:E12)","v":0},{"$f":"SUM(F11:F12)","v":0},0,0,0,0,0,0,0,0,0]
["خدمات التسويقية",null,400,"صالة 1",null,null,null,null,null,null,null,null,null,null,0]
["خدمات التسويقية",null,401,"صالة 2",null,null,null,null,null,null,null,null,null,null,0]
["اجمالي خدمات التسويقية",null,null,"اجمالي خدمات التسويقية",{"$f":"SUM(E14:E15)","v":0},{"$f":"SUM(F14:F15)","v":0},0,0,0,0,0,0,0,0,0]
["خدمات الادارية",null,500,"مدير المصنع",null,null,null,null,null,null,null,null,null,null,0]
["خدمات الادارية",null,501,"الادارة",null,null,null,null,null,null,null,null,null,null,0]
["اجمالي خدمات الادارية",null,null,"اجمالي خدمات الادارية",{"$f":"SUM(E17:E18)","v":0},{"$f":"SUM(F17:F18)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"الاجمالي العــام",{"$f":"E10+E13+E16+E19","v":36000},{"$f":"F10+F13+F16+F19","v":36000},36000,0,36000,0,0,0,44000,0,80000]

{"sheet":"كهرباء","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["شهر","رقم مركز التكلفة","اسم مركز التكلفة","الاجمالي ( بالجنيه )"]
["2021-07-01",100,"مبني 1",23000]
["2021-07-01",101,"مبني 2",21000]
["2021-07-01"]
["2021-07-01"]