{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["شيت المخازن كامل","شيت اليومي"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[[113,2,113,4],[2,2,2,4],[5,7,8,7],[109,0,109,1],[109,2,109,5],[110,2,110,3]]}
[null,"فندق البحر الاحمر"]
[]
[null,null,"طلبيه مخزن الاغذيه ابريل 2022"]
[null,"يضاف 14% ضريبة للاصناف الخاضعة للضريبة"]
["م","الصنف","الوحده","الكميه","المورد","السعر","الاجمالى","ملاحظات"]
[1,"سمنه","علبه",40,"النور",53.75,{"$f":"D6*F6","v":2150}]
[2,"زبده خباز","بوكس",5,"المصريه للمخابز",596.5,2982.5]
[3,"زيت مطبخ","زجاجه",300,"الطيب",32.5,9750]
[4,"زيت جالون","جالون 20 لتر",10,"المتحده",630,6300]
[5,"زبده بورشن","باكيت",6,"ابو عشره",120,720]
[6," جبنه شيدر","كيلو",90,"الحمد",21.25,1912.5]
[7,"جبنه موزريلا","كيلو",18,"الحمد",53,954]
[8,"جبنه بيضاء","جالون",100,"السلام/ابوليف",245,24500]
[9,"طبق بيض","طبق",300,"الرحاب/الشرقيه",55,16500]
[10,"لبن فريش","باكيت",600,"فرجللو",14.33,8598]
[11,"لبن بودر","باكيت",900,"ابو عشره",63.7,57330]
[12,"زبادي ","جالون",100,"ويلمر",45,4500]
[13,"زبادي بورشن","عدد",3000,"ويلمر",1.9375,5812.5]
[14,"فاصوليا حمراء","كانز400 جم",12,"الوطنيه/النيل",9.17,110.03999999999999]
[15,"طحينه جالون","جالون",12,"النور",320,3840]
[16,"صلصه طماطم","علبه",60,"واي جي",39,2340]
[17,"خل ","زجاجه",36,"الهدي/النور",5.42,195.12]
[18,"شوفان","باكيت",10,"الوطنيه/النيل",12,120]
[19,"سويت كورن","كانز400 جم",24,"ابو عشره",12.5,300]
[20,"كسكسي","كيلو",70,"الوطنيه/النيل",24,1680]
[21,"سوشي","باكيت",2,"الوطنيه/النيل",118,236]
[22,"اعشاب ينسون","عدد",180,"الواصف",3.4,612]
[23,"قهوه عبد المعبود فاتح","باكيت",30,"الواصف",23,690]
[24,"كوفي فلتر","باكيت",15,"كيمو",135,2025]
[25,"شاي فتله ليبتون","باكيت",252,"الواصف",35.56,8961.1200000000008]
[26,"شاي اصطاف","كيلو",18,"البحر الاحمر",94.45,1700.1000000000001]
[27,"اعشاب نعناع","باكيت",24,"الواصف",3.4,81.599999999999994]
[28,"نسكافيه 450 جم","باكيت",56,"ابو عشره",170.5,9548]
[29,"نسكويك 750 جم","باكيت",8,"ابو عشره",49.32,394.56]
[30,"نسكافيه بورشن","عدد",500,"الواصف",12.5,6250]
[31,"مكرونه لسان عصفور","بوكس",25,"الشريف",124,3100]
[32,"مكرونه مرمريه","بوكس",5,"الشريف",124,620]
[33,"مكرونه فرن","بوكس",50,"الشريف",124,6200]
[34,"مكرونه اسباجيتي","بوكس",50,"الشريف",124,6200]
[35,"مكرونه شعريه","بوكس",10,"الشريف",124,1240]
[36,"طرشي مشكل","جالون",50,"وطنيه",72,3600]
[37,"زيتون اسود","جالون",5,"وطنيه",180,900]
[38,"زيتون اخضر","جالون",6,"وطنيه",224,1344]
[39,"مرقه دجاج","علبه",24,"ابو عشره",43.9,1053.5999999999999]
[40,"كاتشب 10 ك","جالون",50,"بست برودكت",96,4800]
[41,"مايونيز ساندويتش","جالون",20,"UTC",97.62,1952.4]
[42,"مسطرده جالون","جالون",10,"بست برودكت",96,960]
[43,"حمص الشام","كيلو",25,"عسكريه",29.45,736.25]
[44,"فول مجروش","كيلو",25,"عسكريه",16,400]
[45,"فول تدميس","كيلو",150,"عسكريه",14,2100]
[46,"كركم","كيلو",10,"النور",41.8,418]
[47,"ارز","كيلو",1500,"الهاشميه",10.5,15750]
[48,"فاصوليا","كيلو",50,"عسكريه",25,1250]
[49,"كسبره بودر","كيلو",30,"عسكريه",35,1050]
[50,"كمون بودر","كيلو",5,"عسكريه",83,415]
[51,"بابريكا","كيلو",10,"ابو عشره",56,560]
[52,"فلفل اسود بودر","كيلو",30,"عسكريه",105,3150]
[53,"سمسم","كيلو",20,"عسكريه",55,1100]
[54,"شربات رومان","زجاجه",36,"الانبولي",24.35,876.6]
[55,"عصير 200 مم مانجو","باكيت",675,"الصقر",1.47,992.25]
[56,"شربات نعناع","زجاجه",24,"الانبولي",33.020000000000003,792.48]
[57,"عصير برتقال بودر","باكيت",100,"دريم",87.72,8772]
[58,"عصير اناناس بودر","باكيت",100,"دريم",87.72,8772]
[59,"كولاته هندي","كيلو",2000,"فيوتشر/متحده",73,146000]
[60,"كبده امريكي","كيلو",500,"فيوتشر/متحده",64,32000]
[61,"ظهر هندي","كيلو",2000,"فيوتشر/متحده",73,146000]
[62,"برجر","كيلو",100,"الجارحي/الصقر",34,3400]
[63,"هوت دوج","كيلو",150,"الجارحي/الصقر",37,5550]
[64,"لانشون ساده","كيلو",60,"الجارحي/الصقر",34,2040]
[65,"كورن فليكس شيكو بوبس","شيكاره",3,"ماس فود",320,{"$f":"D70*F70","v":960}]
[66,"شيكولاته بني","بلوك",36,"دريم",154.24,5552.64]
[67,"سيمولينا","شيكاره",7,"توريد",660,4620]
[68,"دقيق","شيكاره",40,"الهاشميه/الطيب",600,24000]
[69,"بسكوت ايس كريم","عدد",15,"اللوتس",45,675]
[70,"ايس كريم شيكولاته","باكيت",30,"دريم",65.789000000000001,1973.67]
[71,"ايس كريم فانيلا","باكيت",70,"دريم",63.156999999999996,4420.99]
[72,"عسل ابيض","برطمان",120,"النور",7.08,849.6]
[73,"عسل اسود","برطمان",60,"النور",6,360]
[74,"مربي مشمش","جالون",20,"جولدن باك",90.21,1804.1999999999998]
[75,"مربي تين","جالون",5,"جولدن باك",90.21,451.04999999999995]
[76,"مربي فراوله","جالون",20,"جولدن باك",90.21,1804.1999999999998]
[77,"مربي بورشن فراوله","بوكس*260",2,"فرجللو",131.35,262.7]
[78,"فول سوداني","كيلو",50,"النور",36,1800]
[79,"بيكنج بودر","باكيت",5,"ابو عشره",59.55,297.75]
[80,"كورن فلاور","باكيت",96,"ابو عشره",4.87,467.52]
[81,"كريم باستري","شيكاره",3,"دريم",482.46,1447.3799999999999]
[82,"خميره","باكيت",20,"المصطفي",21.93,438.6]
[83,"انجاتو جيل","جالون",5,"جولدن باك",161.66999999999999,808.34999999999991]
[84,"جيلاتينا","كيلو",5,"جولدن باك",116.14,580.70000000000005]
[85,"عسل جلكوز","علبه",1,"دريم",387.15,387.15]
[86,"جلاش","باكيت ",250,"ابو عشره",7,1750]
[87,"كنافه","كيلو",70,"الهدي",25.5,1785]
[88,"بابينج جيلي فراوله","جالون",10,"دريم",104.31,1043.0999999999999]
[89,"بايبنج جيلي شيكولاته","جالون",10,"دريم",111.93,1119.3000000000002]
[90,"كريم شانتي","كيلو",150,"جولدن باك",57.35,8602.5]
[91,"سكر خشن","كيلو",1000,"الهاشميه",11.4,11400]
[92,"سكر بودر","باكيت",30,"الطيب",12.5,375]
[93,"سكر بورشن باللوجو","باكيت",1000,"القنصل",8.5,8500]
[94,"اوراك فراخ","كيلو",1500,"السيف",50,75000]
[95,"بط","كيلو",100,"فيوتشر/متحده",47,4700]
[96,"لانشون فراخ","كيلو",24,"الجارحي/الصقر",38,912]
[97,"رومي","كيلو",500,"فيوتشر/متحده",64,32000]
[98,"بلطي","كيلو",70,"ال موسي/وهيب",30,2100]
[99,"سمك فيله","باكيت",200,"ال موسي/وهيب",48,9600]
[100,"ماكريل","كيلو",200,"ال موسي/وهيب",35,7000]
[101,"كريب استيك","باكيت",10,"ال موسي/وهيب",11,110]
[102,"ملوخيه فروزن","بوكس",10,"فوديكو",95,950]
[103,"باميه فروزن","بوكس",10,"فوديكو",135,1350]
[104,"بطاطس بون فريت","بوكس",30,"البحر الاحمر",229.06,6871.8]
["الاسعار غير شاملة ضريبة القيمة المضافة 14% ",null,"الاجمالى ",null,null,null,{"$f":"SUM(G6:G109)","v":824317.82}]
[null,"مشتريات الفندق"," مدير مشتريات المجموعه  ",null,"  مدير مالي الفنادق","  مدير مالي المجموعه"]
[]
[]
[]
[null,null,null,null,"السيد رئيس مجلس الاداره"]

{"sheet":"شيت اليومي","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,2,21,4],[22,0,22,7],[2,2,2,4],[3,1,3,4],[17,0,17,1],[17,2,17,5],[18,0,19,9]]}
[null,"فندق البحر الاحمر"]
[]
[null,null,"طلبيه مخزن الاغذيه ابريل 2022"]
[null,"يضاف 14% ضريبة للاصناف الخاضعة للضريبة"]
["م","الصنف","الوحده","الكميه","المورد","السعر","الاجمالى","ملاحظات"]
[1,"سمنه",{"$f":"IFERROR(VLOOKUP($B6,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":"علبه"},null,{"$f":"IFERROR(VLOOKUP($B6,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":"النور"},{"$f":"IFERROR(VLOOKUP($B6,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":53.75},{"$f":"IFERROR(F6*D6,\"\")","v":0}]
[2,null,{"$f":"IFERROR(VLOOKUP($B7,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B7,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B7,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},{"$f":"IFERROR(F7*D7,\"\")","v":""}]
[3,null,{"$f":"IFERROR(VLOOKUP($B8,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B8,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B8,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
[4,null,{"$f":"IFERROR(VLOOKUP($B9,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B9,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
[5,null,{"$f":"IFERROR(VLOOKUP($B10,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B10,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
[6,null,{"$f":"IFERROR(VLOOKUP($B11,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B11,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
[7,null,{"$f":"IFERROR(VLOOKUP($B12,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B12,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
[8,null,{"$f":"IFERROR(VLOOKUP($B13,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B13,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
[9,null,{"$f":"IFERROR(VLOOKUP($B14,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B14,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
[10,null,{"$f":"IFERROR(VLOOKUP($B15,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B15,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
[11,null,{"$f":"IFERROR(VLOOKUP($B16,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B16,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
[12,null,{"$f":"IFERROR(VLOOKUP($B17,'شيت المخازن كامل'!$B$6:$F$109,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B17,'شيت المخازن كامل'!$B$6:$F$109,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17,'شيت المخازن كامل'!$B$6:$F$109,5,0),\"\")","v":""},""]
["الاسعار غير شاملة ضريبة القيمة المضافة 14% ",null,"الاجمالى ",null,null,null,{"$f":"SUM(G6:G17)","v":0}]
["مشتريات الفندق                                 مدير مشتريات المجموعه                                    مدير مالي الفندق                                         مدير مالي الفنادق                                       مدير مالي المجموعه"]
[]
[]
[]
["السيد رئيس مجلس الاداره"]