{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["رئيسي ","ورقة1"],"not_rendered":{"charts":0,"images":2,"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":257,"n_cols":4,"rows_kept":257,"cut":false,"hidden":false,"merged":[[256,0,256,1],[225,0,225,3],[72,0,72,3],[67,0,67,3],[82,0,82,3],[185,0,185,3],[194,0,194,3],[200,0,200,3],[208,0,208,3],[221,0,221,3],[232,0,232,3],[131,0,131,3],[113,0,113,3],[93,0,93,3]]}
["صنف","كمية"]
["كرتونة صنف اول",1000]
["كرتونة صنف اول",200]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["أحمد يوسف علي خاطر","1960-05-21","قفط - درب السبعي","فني شبكة"]
["حمادة محمد إبراهيم الديري","1984-01-04","قفط - درب السبعي","فني شبكة"]
["عبدالباسط عبدالوهاب محمد حسن","1974-01-13","قفط - المنشية البحري","رئيس شبكات"]
["سعد الدين محمد طه محمد","1961-12-21","قفط -البراهمه","فني شبكة"]
["عبده سعيد محمد سعيد","1960-01-13","قفط - المنشية البحري","عامل خدمات"]
["عمر محمد موسى عبد الغني","1962-01-30","قفط -البراهمه","عامل خدمات"]
["يوسف حسن محمود يوسف","1959-11-23","قفط - الظافرية","عامل خدمات"]
["أشرف عيد حامد احمد","1969-10-05","قفط - الظافرية","فني شبكة"]
[]
["رمضان عبد الحميد شحات احمد","1971-10-02","قفط - البارود","فني شبكة"]
["حمد الله ابوالحسن أحمد عويضه","1962-07-14","قفط - الشيخية","فني شبكة"]
["عبد العليم عبد التواب محمد حامد","1965-11-20","قفط - الشيخية","فني شبكة"]
["مصباح خضري علي عبدالعظيم","1975-01-04","قفط - الكلاحين","سباك"]
["أسامة جمعة شحات محارب","1987-03-31","قفط - ش . الانصاري","فني شبكة"]
[]
["جمال شعبان محمود احمد","1961-12-06","قفط - القلعه","فني شبكة"]
["ناصر محمد علي أحمد","1964-08-04","قفط - القلعه","فني شبكة"]
["سليمان محمد سيد احمد","1961-03-25","قفط - القلعه","فني شبكة"]
["عبدالحميد عبدالسلام أحمد","1963-06-05","قفط - القلعه","فني شبكة"]
["ناصر محمد إبراهيم علي","1968-02-16","قفط - القلعه","فني شبكة"]
["محمد عاشور جاد حامد","1973-05-24","قفط - القلعه","فني شبكة"]
["حسين جاد سليمان سلامه","1962-10-10","قفط - القلعه","فني شبكة"]
[]
["فهمي بربري حسين رشوان","1960-02-17","قفط -البراهمه","فني شبكة"]
["عبدالمجيد قاسم محمد عمر","1962-08-17","قفط -البراهمه","فني شبكة"]
["عبد الفراج محمد حامد علي","1963-05-03","قفط -البراهمه","فني شبكة"]
["خير محمود سليمان حامد","1962-09-27","قفط -البراهمه","فني شبكة"]
["ورداني جاد الرب محمد","1963-01-27","قفط -البراهمه","فني شبكة"]
["سليم عبد النبي سليم حامد","1961-10-12","قفط -البراهمه","فني شبكة"]
["محمد بشاري حسن محمود","1960-03-09","قفط -البراهمه","فني شبكة"]
["محمد أحمد مرسي محمد","1961-08-31","قفط -البراهمه","فني شبكة"]
["حجاج ربيع علي إبراهيم","1986-08-05","قفط -البراهمه","فني شبكة"]
["ناصر حسين مخلوف حسن","1978-10-09","قفط -البراهمه","فني شبكة"]
["رجب ابراهيم سيدي احمد ابراهيم","1984-05-14","قفط -البراهمه","فني شبكة"]
["حمودة خير جاد محمد","1988-03-30","قفط -البراهمه","سباك"]
[]
["أمين محمود أحمد عبد الحكيم","1960-12-15","قفط - نجع الحجيري","فني شبكة"]
["فارس سلامة محمود احمد","1979-05-14","قفط - الكلاحين","فني شبكة"]
["أبوالحمد محمود ضاحي","1974-02-11","قفط - الكلاحين","فني شبكة"]
[]
["جمال محمود بعره سعيد","1961-10-08","قفط - بئر عنبر","فني تشغيل"]
["عبد الشافي على أبو بكر جوده","1971-01-20","قفط - بئر عنبر","فني تشغيل"]
["حلمي محمد احمد احمد","1963-02-15","قفط - درب السبعي","فني تشغيل"]
["رمضان علي محمد هلال","1960-03-01","قفط - نجع الحجيري","فني تشغيل"]
["سيد أبو الحسن محمد مصطفي","1963-12-22","قفط - الكلاحين","فني تشغيل"]
["ناصر حسين محمود علي","1964-07-16","قفط - الكلاحين","فني تشغيل"]
[]
["عبد الله جلال محمد عبيد","1961-08-02","قفط - الظافرية","مدير تشغيل"]
["عيد محمد علي مبارك","1960-03-29","قفط - كوبري القلعه","سائق"]
["محمد أحمد محمد أحمد","1963-11-13","قفط - الكلاحين","سائق"]
["سيد عبيد الله أحمد عبدالله","1964-12-08","قفط - ش . المحطة","عامل كسح"]
["صلاح إبراهيم محسن محمد","1963-01-05","قفط - بجوار مستشفى قفط","سائق"]
["عبد الناصر توفيق محمود عطيه","1965-12-13","قفط - عمارات حي الامل","كهربائي"]
["محمود يوسف محسن محمد","1975-03-03","قفط - بجوار كوبر الزعير غربي","سائق"]
["عادل محمود أحمد يوسف","1969-01-01","قفط - القلعه","سائق"]
["أحمد مغربي خضري محمد","1960-04-02","قفط - نجع السويس","سائق"]
["علي محمد يوسف عبد الله","1983-08-05","قفط -البراهمه","سائق"]
["محمد أبو زيد مبارك ابوزيد","1978-11-16","قفط - غرب كوبر الزعير","سائق"]
["أبو الحسن محمد أحمد علي","1974-05-19","قفط - درب السبعي","سائق"]
["شعبان أحمد علي أحمد","1972-01-19","قفط -البراهمه","سائق"]
["محمد خديوي حبيب إبراهيم","1963-03-12","قفط - القلعه","سائق"]
["مختار عبد الرحيم محسن محمد","1962-09-08","قفط - المنشية البحري","سائق"]
["أحمد عرنوس فهمي إبراهيم","1975-08-26","قفط -البراهمه","سائق"]
["محمد إبراهيم احمد علي","1973-05-01","قفط - نجع الحجيري","سائق"]
["عماري عويضة محمود محمود","1977-10-08","قفط - الكلاحين","عامل كسح"]
["ضياء محمود آدم أحمد","1984-09-25","قفط - نجع كوم المؤمنين","مشرف امن"]
["حسين عبد المنعم حسين أحمد","1985-02-23","قفط - درب السبعي","مشرف امن"]
["نبيل احمد عبد الرحيم الرموزي","1983-12-22","قفط - ش .الانصاري","مشرف امن"]
["عبد المسيح يوحنا بولس خليل","1980-02-10","قفط - الشيخية","مشرف امن"]
["محمد حداد زايد يونس","1987-01-01","قفط - القلعه","سائق"]
[null,null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"ورقة1","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,4,11,13]]}
["اول",{"$f":"IFERROR(IF(A1<>\"\",LOOKUP(2,1/('رئيسي '!B2:B17<>\"\")/('رئيسي '!A2:A17=\"كرتونة صنف \"&$A$1),'رئيسي '!B2:B17)-INDEX(B2:B20,MATCH(MAX(B2:B20*(C2:C20=A1)),B2:B20*(C2:C20=A1),0))&\"علبة\",\"\"),0)","v":"-799علبة"},{"$f":"getBalance()","v":2},null,null,"الدالة موجوة في خلية B1"]
[null,995,"اول",null,"ولكن عند إضافة كمية 200 في ورقة رئيسي النتيجة خطا",null,null,null,null,null,null,null,"الدالة هنا تعمل جيد "]
[null,996,"اول"]
[null,997,"اول"]
[null,998,"اول"]
[null,999,"اول"]
[null,195,"اول"]
[null,196,"اول"]
[null,197,"اول"]
[null,198,"اول"]
[null,null,null,null,"المطلوب تعديل لهذه الدالة لجلب اخر قيمة في عمود B في ورقة رئيسي 200 تخصم منها اخر قيمة في عمود B وهي 198 المطلوب  النتيجة هي 2 علبة "]
[]
[]
[null,null,null,null,null,null,"بنفس شروط الدالة كمثال كلمة اول في خلية A1 "]