{"text_format":"1","workbook":"xlsx","n_sheets":3,"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":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"ورق 1",null,null,null,"ورق 2",null,null,null,"ورق 3"]
[]
[null,"وارد","صادر ","رصيد",null,"وارد","صادر ","رصيد",null,"وارد","صادر ","رصيد"]
[null,1000,null,{"$f":"B6-C6","v":1000},null,1500,null,{"$f":"F6-G6","v":1500},null,3000,null,{"$f":"J6-K6","v":3000}]
[null,null,null,{"$f":"D6+B7-C7","v":1000},null,null,null,{"$f":"H6+F7-G7","v":1500},null,null,null,{"$f":"L6+J7-K7","v":3000}]
[null,null,null,{"$f":"D7+B8-C8","v":1000},null,null,null,{"$f":"H7+F8-G8","v":1500},null,null,null,{"$f":"L7+J8-K8","v":3000}]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]
[null,null,null,1000,null,null,null,1500,null,null,null,3000]

{"sheet":"الاطباق","index":1,"n_rows":33,"n_cols":31,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,"طبق مقاس1",null,null,null,"طبق مقاس2",null,null,null,"طبق مقاس3",null,null,null,"طبق مقاس4",null,null,null,"طبق مقاس6",null,null,null,"طبق مقاس7",null,null,null,"طبق مقاس8"]
[null,null,null,null,"وارد","صادر ","رصيد",null,"وارد","صادر ","رصيد",null,"وارد","صادر ","رصيد",null,"وارد","صادر ","رصيد",null,"وارد","صادر ","رصيد",null,"وارد","صادر ","رصيد",null,"وارد","صادر ","رصيد"]
[null,null,null,null,1000,null,{"$f":"E5-F5","v":1000},null,1000,null,{"$f":"I5-J5","v":1000},null,1000,null,{"$f":"M5-N5","v":1000},null,1000,null,{"$f":"Q5-R5","v":1000},null,1000,null,{"$f":"U5-V5","v":1000},null,1000,null,{"$f":"Y5-Z5","v":1000},null,1000,null,{"$f":"AC5-AD5","v":1000}]
[null,null,null,null,null,null,{"$f":"G5+E6-F6","v":1000},null,null,null,{"$f":"K5+I6-J6","v":1000},null,null,null,{"$f":"O5+M6-N6","v":1000},null,null,null,{"$f":"S5+Q6-R6","v":1000},null,null,null,{"$f":"W5+U6-V6","v":1000},null,null,null,{"$f":"AA5+Y6-Z6","v":1000},null,null,null,{"$f":"AE5+AC6-AD6","v":1000}]
[null,null,null,null,null,null,{"$f":"G6+E7-F7","v":1000},null,null,null,{"$f":"K6+I7-J7","v":1000},null,null,null,{"$f":"O6+M7-N7","v":1000},null,null,null,{"$f":"S6+Q7-R7","v":1000},null,null,null,{"$f":"W6+U7-V7","v":1000},null,null,null,{"$f":"AA6+Y7-Z7","v":1000},null,null,null,{"$f":"AE6+AC7-AD7","v":1000}]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]
[null,null,null,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000,null,null,null,1000]

{"sheet":"اسطمبات","index":2,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[[16,6,18,15],[20,6,22,15],[24,1,25,15]]}
[]
[]
[]
[null,null,null,null,null,"طبق1","طبق2","طبق4"]
[null,null,null,null,"اسطمبة1",3,4,1]
[null,null,null,null,null,"طبق 3","طبق2","طبق5"]
[null,null,null,null,"اسطمبة2",3,2,6]
[null,null,null,null,null,"طبق 8","طبق7","طبق6","طبق4"]
[null,null,null,null,"اسطمبة3",2,3,2,2]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"شرح هذا الموضوع كالاتى هذا مصنع يقوم بتصنيع اطباق حلويات كل طبق وله مقاس ويستخدم اكتر من نوع فى تصنيع الاطباق"]
[]
[]
[]
[null,null,null,null,null,null,"والمطلوب عند عمل امر تصنيع بالفورم اقوم بالتسجيل فيه رقم الاسطمبة المطلوبة بالتصنيع وعدد الورق الذى دخل فى التصنيع",null,null,null,null,null,null,null,null,null,null,"مثلا اسطمبة 1 الطبق رقم 1يصنع منه 3الفورم يقوم بالضرب *عددالورق وترحليه لكارت صنف الطبق"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مثلا عدد الورق 100",null,"واسطمبة 2"]
[]
[null,"وينتج عن ذلك يتم تخفيض الورق المسحوب منه للتصنيع سواء ورق 1او ورق2 او ورق3 وبالنسبة للاطبق يقوم الفورم  بضرب عددالاوراق *عددالطبق المذكور بالاسطمبة وترحيله لكارت صنف الطبق",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طبق3*100",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طبق2*100",200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طبق5*100",400]
[]
[]
[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,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,"اى 1000ورقة * 3 طبق مقاس 3 =3000طبق مقاس3 وترحل لكرات الصنف"]