{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["دراسة فندق","دراسة نسبيه للغرف","مصاريف","دراسة نسبة للمناسك"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[19,10,19,11],[21,9,21,13],[17,9,20,9],[20,10,20,11],[30,12,30,13],[30,5,34,9],[32,10,32,11],[33,10,33,11],[33,12,33,13],[31,12,31,13],[18,13,19,13],[12,2,13,2],[14,2,15,2],[16,2,21,2],[12,16,12,18],[13,16,13,18],[14,16,14,18],[3,4,36,4],[15,9,15,10],[23,1,24,3],[26,3,27,3],[29,1,30,1],[29,3,30,3],[34,10,34,11],[34,13,35,13],[32,12,32,13],[12,7,15,8],[17,16,17,18],[18,16,18,18],[15,11,15,12],[12,11,14,12],[16,10,16,13],[17,10,17,11],[18,10,18,11],[15,16,15,18],[16,16,16,18],[3,15,4,18],[1,1,1,18],[2,1,2,18],[11,6,11,12],[3,5,3,13],[3,1,4,3],[5,1,11,2],[8,8,10,13],[8,3,10,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[21,16,21,18],[37,1,37,18],[21,5,21,6],[21,7,21,8],[22,1,22,3],[22,5,22,13],[35,5,35,11],[31,1,32,1],[31,3,32,3],[33,1,33,3],[34,2,36,2],[36,12,36,13],[36,5,36,11],[31,10,31,11],[23,11,24,11],[26,1,27,1],[25,2,32,2],[23,5,28,10],[30,10,30,11],[22,15,22,18],[23,15,24,18],[25,15,36,18]]}
[]
[null,"ادخل اسم الفندق المراد دراسته "]
[]
[null," ادخال البيانات (حساب موسمي فقط )",null,null,null,"البيانات والقيم المالية",null,null,null,null,null,null,null,null,null,"بيان الدراسة مفصلة "]
[null,null,null,null,null,"نسبة \nالاشغال","عدد \nالاسرة/ الغرف","قيمة البيع","مجموع \nخلال الفترة","اجمالي الموسم","ضريبة مسار15%\n+2.5% إيواء","مبلغ البيع \nمخصوم الضريبة","مفتاح الضريبة","عدد الأشهر"]
[null,null,null,"موسم الحج",null,1,{"$f":"B14","v":0},{"$f":"D14","v":0},{"$f":"ROUND(H6*G6*F6,0)","v":0},{"$f":"ROUND(I6,0)","v":0},{"$f":"ROUND((I6-((I6/(15+100)*100))+(I6-(I6/(2.5+100)*100)))*M6,0)","v":0},{"$f":"ROUND(I6-K6,0)","v":0},1,1,null,"بيانات الموسم","الحج","رمضان","العمرة"]
[null,null,null,"موسم رمضان",null,0.95,{"$f":"B16","v":0},{"$f":"(D16/30)+H10","v":4},{"$f":"ROUND(H7*G7*F7,0)","v":0},{"$f":"ROUND(I7*30,0)","v":0},{"$f":"ROUND((J7-((J7/(15+100)*100))+(J7-(J7/(2.5+100)*100)))*M7,0)","v":0},{"$f":"ROUND(J7-K7,0)","v":0},1,1,null,"اجمالي الإيراد المتوقع",{"$f":"J6","v":0},{"$f":"J7","v":0},"غير مفعل "]
[null,null,null,"مواسم العمرة",null,0,{"$f":"G7*F8","v":0},{"$f":"(H7/2)+H11","v":6},{"$f":"ROUND(H8*G8,0)","v":0},{"$f":"ROUND(I8*30*N8,0)","v":0},{"$f":"ROUND((J8-((J8/(15+100)*100))+(J8-(J8/(2.5+100)*100)))*M8,0)","v":0},{"$f":"ROUND(J8-K8,0)","v":0},0,7,null,"الضريبة للإيراد",{"$f":"K6","v":0},{"$f":"K7","v":0}]
[null,null,null,"التحكم بقيمة البيع للغرفة  ",null,"القيمة ",null,"(-) أو (+)",null,null,null,null,null,null,null,"المصروفات التشغيلة",{"$f":"مصاريف!H31","v":43010},{"$f":"مصاريف!G31","v":4140}]
[null,null,null,null,null,"موسم رمضان ",null,4,null,null,null,null,null,null,null,"الرواتب الموسمية",{"$f":"N14","v":14000},{"$f":"N14","v":14000}]
[null,null,null,null,null,"مواسم العمرة",null,4,null,null,null,null,null,null,null,"طوارئ الرواتب",{"$f":"N16","v":2100},{"$f":"N16","v":2100}]
[null,null,null,null,null,null," حساب مصروفات الموظفين للموسم",null,null,null,null,null,null,null,null,"الإجمالي المصرفات",{"$f":"SUM(Q8:Q11)","v":59110},{"$f":"SUM(R8:R11)","v":20240},{"$f":"SUM(S8:S11)","v":0}]
[null,"عدد الأسرة ","الحج","قيمة البيع للسرير",null,"مشرف فندق",1,null,null,"عدد موظف الاستقبال",1,null,null,"مجموع الرواتب ",null,"الرواتب الدائمة السنه",{"$f":"I19","v":72000}]
[null,null,null,null,null,"الراتب  ",3500,null,null,"عدد حراس  الامن ",1,null,null,{"$f":"ROUND(((G13*G14)+(G15*G16)+(K13*K15)+(K14*K15)),0)","v":14000},null,"طوارئ الرواتب",{"$f":"I21","v":7200}]
[null,"عدد الغرف ","رمضان","قيمة البيع للغرفة شهري",null,"عدد عمال النظافة ",1,null,null,"الراتب",4000,null,null,"طوارئ 15%",null,"الايجار",{"$f":"M32","v":-110985}]
[null,null,null,null,null,"الراتب  ",2500,null,null,"مجموع الرواتب الموسمية + الطوارئ",null,{"$f":"ROUND(((G13*G14)+(G15*G16)+(K13*K15)+(K14*K15))+N16,0)","v":16100},null,{"$f":"ROUND(N14*15%,0)","v":2100},null,"ضريبة الايجار",{"$f":"M33","v":-16648}]
[null,"راتب مشرف الفندق ",null,"حارس الأمن والاستقبال ",null," العمالة الدائمة  ","عدد الموظفين ","الراتب ",null,null,"الدخل قبل التصفية",null,null,null,null,"زكاة النشاط",{"$f":"D30","v":-773}]
[null,null,null,null,null,"مشرف فندق ",1,1500,"مجموع الرواتب ",null," سعر البيع لمواسم العمرة مخصوم الضريبة",null,{"$f":"ROUND(L8,0)","v":0},"اجمالي الحج ورمضان",null,"الطوارئ",{"$f":"N28","v":0}]
[null,"راتب عامل النظافة  ",null,"الدلاله",null,"عامل صيانة ",1,1500,{"$f":"ROUND(((G18*H18)+(G19*H19)+(G20*H20)+(G21*H21))*12,0)","v":72000},null,"اجمالي سعر البيع للحج مخصوم الضريبة",null,{"$f":"ROUND(L6,0)","v":0},{"$f":"M19+M20","v":0},null,"الإجمالي للمصروفات",{"$f":"SUM(Q13:S18)","v":-49206}]
[null,null,null,null,null,"عامل نظافة ",1,1500,"احتياطي طوارئ 5%",null,"اجمالي سعر البيع لرمضان مخصوم الضريبة",null,{"$f":"ROUND(L7,0)","v":0},null,null,"النشاط","حج","رمضان","مواسم العمره"]
[null,"احتياطي طوارئ + مشتريات",null,"نسبة الايجار",null,"حارس فندق",1,1500,{"$f":"I19*10%","v":7200},null,"اختياطي الطوارئ والمشتريات",null,{"$f":"ROUND((M19+M20+M18)*B22,0)","v":0},null,null,"الدخل ",{"$f":"SUM(Q7-Q12)","v":-59110},{"$f":"R7-R12","v":-20240},{"$f":"S12","v":0}]
[null,0.05,null,0.7,null,"مجموع الرواتب 12 اشهر * 5%",null,{"$f":"ROUND((((G18*H18)+(G19*H19)+(G20*H20)+(G21*H21))*12)+I21,0)","v":79200},null,null,null,null,null,null,null,"صافي الأرباح ",{"$f":"(Q21+R21)-Q19","v":-30144}]
[]
[null,"بيانات إضافية ",null,null,null,"دخل النشاط بعد خصم المصروفات التشغيلية والرواتب والضرائب والطوارئ ",null,null,null,null,null,"إضافة دخل  موسم العمرة","الموسم","صافي الدخل "]
[null,null,null,null,null,null,null,null,null,null,null,null,"الحج",{"$f":"ROUND(M19-(مصاريف!H31+L16),0)","v":-59110}]
[null,"نسبة تشغيل ",null,"العوائد",null,null,null,null,null,null,null,false,"رمضان",{"$f":"ROUND(M20-(مصاريف!G31+L16),0)","v":-20240}]
[null,0.2,null,{"$f":"ROUND(M36*B27,0)","v":-6029},null,null,null,null,null,null,null,{"$f":"IF(L28>0,\"مفعل\",\"غير مفعل\")","v":"غير مفعل"},"مواسم العمرة ",{"$f":"ROUND(M18-(مصاريف!I31+((L16/2)*N8)),0)","v":-79534}]
[null,null,null,null,null,null,null,null,null,null,null,0,"  الطوارئ",{"$f":"ROUND(M21,0)","v":0}]
[null,"نسبة الزكاة ",null,"مبلغ الزكاة ",null,null,null,null,null,null,null,{"$f":"N27*L28","v":0},"المجموع",{"$f":"ROUND((N25+N26+L29)-(N28+H22),0)","v":-158550}]
[null,2.5000000000000001E-2,null,{"$f":"ROUND((N29-M34)*B30,0)","v":-773}]
[null,null,null,null,null,"ايجار الفندق ",null,null,null,null,"نسبة الايجار من اجمالي الدخل",null,{"$f":"D22","v":0.7}]
[null,null,null,null,null,null,null,null,null,null,"ايجار الفندق ",null,{"$f":"ROUND(N29*M31,0)","v":-110985}]
[null,null,null,null,null,null,null,null,null,null,"ضريبة الايجار",null,{"$f":"ROUND(M32*15%,0)","v":-16648}]
[null,"حساب الدخل بمعرفة سعر الايجار ",null,null,null,null,null,null,null,null,"الايجار شامل الضريبة",null,{"$f":"ROUND(M32+M33,0)","v":-127633}]
[null,"سعر الايجار",null,null,null,null,null,null,null,null,"  الطوارئ",null,{"$f":"ROUND(N28,0)","v":0},{"$f":"ROUND(M35+M36,0)","v":-30144}]
[null,"عدد الأسرة ",null,null,null,"العوائد المتوقعه بعد خصم الزكاة",null,null,null,null,null,null,{"$f":"ROUND((N29-M34-D30),0)","v":-30144}]
[null,"الناتج",null,{"$f":"D35/D36","v":{"$error":"#DIV/0!"}},null,"سعر الإيجــــــــــــــــــــــــــــــــار شامل الضريبة ",null,null,null,null,null,null,{"$f":"ROUND(M34,3)","v":-127633}]

{"sheet":"دراسة نسبيه للغرف","index":1,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[41,1,41,11],[16,2,16,3],[17,2,17,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[32,2,32,3],[33,2,33,3],[23,2,23,3],[19,7,19,8],[37,2,37,3],[25,2,25,3],[26,2,26,3],[30,2,30,10],[39,6,39,7],[2,1,2,11],[3,1,40,1],[3,2,3,10],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[14,2,14,3],[15,2,15,3],[19,9,19,10],[24,2,24,3],[26,7,26,8],[34,2,34,3],[37,7,37,8],[31,2,31,4],[39,4,39,5],[28,4,28,5],[28,6,28,7],[31,6,37,6],[35,2,35,3],[36,2,36,3],[12,6,18,6],[20,6,25,6],[9,6,10,10],[11,6,11,7],[26,9,26,10]]}
[]
[]
[]
[null,null,"البيانات والقيم المالية"]
[null,null,"نسبة \nالاشغال","عدد \nالاسرة/ الغرف","قيمة البيع","مجموع \nخلال الفترة","اجمالي الموسم","ضريبة مسار15%\n+2.5% إيواء","مبلغ البيع \nمخصوم الضريبة","مفتاح الضريبة","عدد الأشهر"]
[null,null,{"$f":"'دراسة فندق'!F6","v":1},{"$f":"'دراسة فندق'!G6","v":0},{"$f":"'دراسة فندق'!H6","v":0},{"$f":"'دراسة فندق'!I6","v":0},{"$f":"'دراسة فندق'!J6","v":0},{"$f":"'دراسة فندق'!K6","v":0},{"$f":"'دراسة فندق'!L6","v":0},{"$f":"'دراسة فندق'!M6","v":1},{"$f":"'دراسة فندق'!N6","v":1}]
[null,null,{"$f":"'دراسة فندق'!F7","v":0.95},{"$f":"'دراسة فندق'!G7","v":0},{"$f":"'دراسة فندق'!H7","v":4},{"$f":"'دراسة فندق'!I7","v":0},{"$f":"'دراسة فندق'!J7","v":0},{"$f":"'دراسة فندق'!K7","v":0},{"$f":"'دراسة فندق'!L7","v":0},{"$f":"'دراسة فندق'!M7","v":1},{"$f":"'دراسة فندق'!N7","v":1}]
[null,null,{"$f":"'دراسة فندق'!F8","v":0},{"$f":"'دراسة فندق'!G8","v":0},{"$f":"'دراسة فندق'!H8","v":6},{"$f":"'دراسة فندق'!I8","v":0},{"$f":"'دراسة فندق'!J8","v":0},{"$f":"'دراسة فندق'!K8","v":0},{"$f":"'دراسة فندق'!L8","v":0},{"$f":"'دراسة فندق'!M8","v":0},{"$f":"'دراسة فندق'!N8","v":7}]
[]
[null,null," سعر البيع لمواسم العمرة مخصوم الضريبة",null,{"$f":"'دراسة فندق'!M18","v":0},null,"بيان اجمالي المصروفات المتوقعه"]
[null,null,"اجمالي سعر البيع للحج مخصوم الضريبة",null,{"$f":"'دراسة فندق'!M19","v":0}]
[null,null,"اجمالي سعر البيع لرمضان مخصوم الضريبة",null,{"$f":"'دراسة فندق'!M20","v":0},null,"البند",null,"مقدار التشغيل "]
[null,null,"اختياطي الطوارئ والمشتريات",null,{"$f":"'دراسة فندق'!M21","v":0},null,"المصروفات التشغيلية","رواتب عام",{"$f":"E15*'دراسة نسبة للمناسك'!D6","v":0}]
[null,null,null,null,null,null,null,"التراخيص والضرائب",{"$f":"E15*'دراسة نسبة للمناسك'!D7","v":0}]
[null,null,"عدد الغرف",null,{"$f":"D7","v":0},null,null,"الكهرباء ",{"$f":"E15*'دراسة نسبة للمناسك'!D8","v":0}]
[null,null,"عدد الأسرة ",null,{"$f":"D6","v":0},null,null,"الماء",{"$f":"E15*'دراسة نسبة للمناسك'!D9","v":0}]
[null,null,"مجموع المصاريف التشغيلية",null,{"$f":"J20","v":0},null,null,"اتصالات ",{"$f":"E15*'دراسة نسبة للمناسك'!D10","v":0}]
[null,null,"مجموع الصيانة المقدره",null,{"$f":"J25","v":0},null,null,"عقود الصيانة ",{"$f":"E15*'دراسة نسبة للمناسك'!D11","v":0}]
[null,null,null,null,null,null,null,"مواصلات ",{"$f":"E15*'دراسة نسبة للمناسك'!D12","v":0}]
[null,null,"اجمالي الدخل بدون ضرائب ",null,{"$f":"E11+E12","v":0},null,null,"مجموع مصاريف التشغيلية",null,{"$f":"SUM(I13:I19)","v":0}]
[null,null,"الدخل بعد خصم المصروفات",null,{"$f":"E20-(E17+E18)","v":0},null,"مصروفات الصيانة","صيانة كهرباء",{"$f":"E15*'دراسة نسبة للمناسك'!D14","v":0}]
[null,null,"نسبة الايجار",null,{"$f":"'دراسة فندق'!D22","v":0.7},null,null,"صيانة سباكه",{"$f":"E15*'دراسة نسبة للمناسك'!D15","v":0}]
[null,null,"اجار الفدق",null,{"$f":"E21*E22","v":0},null,null,"صيانة مصاعد",{"$f":"E15*'دراسة نسبة للمناسك'!D16","v":0}]
[null,null,"الضريبة",null,{"$f":"ROUND(E23*15%,0)","v":0},null,null,"صيانات عامه للفندق",{"$f":"E15*'دراسة نسبة للمناسك'!D17","v":0}]
[null,null,"اجار الفندق شامل الضريبة",null,{"$f":"E23+E24","v":0}]
[null,null,"الأرباح المتوقعة",null,{"$f":"'دراسة نسبة للمناسك'!H30","v":0}]
[null,null,"الزكاه",null,{"$f":"'دراسة نسبة للمناسك'!H31","v":0},null,null,"مجموع مصاريف الصيانة",null,{"$f":"SUM(I21:I26)","v":0}]
[]
[null,null,null,null,"الإيجار شامل الضريبة ",null,{"$f":"E25","v":0}]
[]
[null,null,"دراسة أخرى مبنية على تعديل مصروفات الصيانة للفندق "]
[null,null,"تعديل مقدار الصيانة حسب  وضع الفندق ",null,null,null,"بيانات الصيانة بعد تعديل نسبة الصيانة","البند","مقدار التشغيل",null,{"$f":"'دراسة نسبة للمناسك'!D25","v":1}]
[null,null,"تعديل نسبة الصيانة",null,{"$f":"'دراسة نسبة للمناسك'!H20","v":1},null,null,"صيانة كهرباء",{"$f":"E15*'دراسة نسبة للمناسك'!D26","v":0}]
[null,null,"اجار الفندق",null,{"$f":"'دراسة نسبة للمناسك'!L27","v":0},null,null,"صيانة سباكه",{"$f":"E15*'دراسة نسبة للمناسك'!D27","v":0}]
[null,null,"الضريبة",null,{"$f":"'دراسة نسبة للمناسك'!K28","v":0},null,null,"صيانة مصاعد",{"$f":"E15*'دراسة نسبة للمناسك'!D28","v":0}]
[null,null,"الإيجار شامل الضريبة ",null,{"$f":"'دراسة نسبة للمناسك'!K29","v":0},null,null,"صيانات عامه للفندق",{"$f":"E15*'دراسة نسبة للمناسك'!D29","v":0}]
[null,null,"الأرباح المتوقعة",null,{"$f":"'دراسة نسبة للمناسك'!K30","v":0}]
[null,null,"الزكاة",null,{"$f":"'دراسة نسبة للمناسك'!K31","v":0},null,null,"مجموع مصاريف الصيانة",null,{"$f":"SUM(I33:I37)","v":0}]
[]
[null,null,null,null,"الإيجار شامل الضريبة ",null,{"$f":"E36","v":0}]

{"sheet":"مصاريف","index":2,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":true,"merged":[[25,8,27,8],[5,3,24,3],[28,1,29,5],[28,6,29,6],[30,1,30,5],[28,8,29,8],[25,7,27,7],[28,7,29,7],[25,1,27,5],[25,6,27,6],[20,1,24,1],[15,1,19,1],[2,1,2,8],[3,1,3,2],[3,4,3,8],[5,1,10,1],[11,1,14,1]]}
[]
[]
[null,"دراسة تقديرية لمتوسط بنود الصرف على الفرد"]
[null,"متوسط بنود الصرف"]
[null,"الاساسية","التفاصيل","نسبة الاستهلاك للسنه","عدد  ","قيمة/يوم","تكلفة شهر رمضان","الحج  تكلفة 20 يوم","تكلفة مواسم العمرة  "]
[null,"مصاريف تشغيل (موسمية)","كهرياء",0.7,{"$f":"'دراسة فندق'!$G$7","v":0},6,{"$f":"E6*F6*30","v":0},{"$f":"E6*F6*20","v":0},{"$f":"G6*8*$D$6","v":0}]
[null,null,"مياه",null,{"$f":"'دراسة فندق'!$G$7","v":0},4,{"$f":"E7*F7*30","v":0},{"$f":"E7*F7*20","v":0},{"$f":"G7*8*$D$6","v":0}]
[null,null,"هواتف وانترنت",null,4,30,{"$f":"E8*F8*30","v":3600},{"$f":"E8*F8*20","v":2400},20160]
[null,null,"المغسلة 4غسله بالشهر",null,{"$f":"'دراسة فندق'!G6","v":0},3,{"$f":"E9*F9*4","v":0},{"$f":"E9*F9*3","v":0},0]
[null,null,"مناديل 8 تغييرات بالشهر",null,{"$f":"'دراسة فندق'!G7","v":0},2,{"$f":"E10*F10*8","v":0},{"$f":"E10*F10*6","v":0},0]
[null,null,"مواد النظافة",null,{"$f":"'دراسة فندق'!G7","v":0},30,{"$f":"E11*F11","v":0},{"$f":"E11*F11/1.5","v":0},0]
[null,null,null,null,null,null,{"$f":"E12*F12*30","v":0},{"$f":"E12*F12*20","v":0},0]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
[null,null,"تصريح حج",null,30000,null,0,{"$f":"E21","v":30000},0]
[null,null,"سجل فندق ",null,5000,null,0,{"$f":"E22","v":5000},0]
[null,null,"أخرى",null,null,null,0,{"$f":"E23*F23*20","v":0},0]
[null,null,null,null,null,null,0,{"$f":"E24*F24*20","v":0},0]
[null,null,null,null,null,null,0,{"$f":"E25*F25*20","v":0},0]
[null,"المجموع",null,null,null,null,{"$f":"ROUND(SUM(G6:G25),0)","v":3600},{"$f":"ROUND(SUM(H6:H25),0)","v":37400},{"$f":"ROUND(SUM(I6:I25),0)","v":20160}]
[]
[]
[null,"مقدار الضريبة ",null,null,null,null,{"$f":"ROUND(G26*15%,0)","v":540},{"$f":"ROUND(H26*15%,0)","v":5610},{"$f":"ROUND(I26*15%,0)","v":3024}]
[]
[null,"الإجمالي ",null,null,null,null,{"$f":"ROUND(G26+G29,0)","v":4140},{"$f":"ROUND(H26+H29,0)","v":43010},{"$f":"ROUND(I26+I29,0)","v":23184}]

{"sheet":"دراسة نسبة للمناسك","index":3,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,1,2,12],[3,6,3,8],[3,1,3,3],[21,10,21,11],[10,9,10,12],[11,10,11,11],[14,9,14,12],[15,10,15,11],[12,9,12,10],[16,9,16,10],[12,11,12,12],[16,11,16,12],[17,9,17,10],[17,11,17,12],[12,1,12,2],[17,1,17,2],[30,7,30,8],[22,6,22,12],[23,6,23,8],[23,9,23,11],[24,7,24,8],[25,10,25,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,10,30,11],[29,1,29,2],[23,2,24,2],[17,7,17,8],[18,6,19,6],[20,7,20,8],[22,1,22,3],[25,7,25,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[21,6,21,9]]}
[null,"دراسة نسبية بمخرجات المناسك "]
[]
[]
[null,"بيانات مفصله بالنسبة لعدد غرف الفندق 66 غرفه",null,null,null,null,"بيانات ثابته بالنسبة لمخرجات المناسك"]
[null,"البند","السعر ","*66",null,null,"البند","السعر "]
[null,"رواتب عام",130000,{"$f":"ROUND(C6/66,0)","v":1970},null,null,"رواتب عام",130000]
[null,"التراخيص والضرائب",50000,{"$f":"ROUND(C7/66,0)","v":758},null,null,"التراخيص والضرائب",50000]
[null,"الكهرباء ",14000,212,null,null,"الكهرباء ",14000]
[null,"الماء",4000,61,null,null,"الماء",4000]
[null,"اتصالات ",17000,258,null,null,"اتصالات ",17000]
[null,"عقود الصيانة ",16000,242,null,null,"عقود الصيانة ",16000,null,"نسبة الصرف على الغرفه للمناسك"]
[null,"مواصلات ",20000,303,null,null,"مواصلات ",20000,{"$f":"SUM(H6:H12)","v":251000},null,{"$f":"ROUND(I12/66,0)","v":3803}]
[null,"مجموع بيانات التشغيل",null,{"$f":"SUM(D6:D12)","v":3804},null,null,"صيانة كهرباء",18000,null,"المصاريف التشغيلية بالنسبة لغرف الفندق المدروس",null,{"$f":"ROUND(K12*'دراسة فندق'!B16,0)","v":0}]
[null,"صيانة كهرباء",18000,273,null,null,"صيانة سباكه",18000]
[null,"صيانة سباكه",18000,273,null,null,"صيانة مصاعد",19000,null,"نسبة الصرف على الغرفه للمناسك"]
[null,"صيانة مصاعد",19000,{"$f":"ROUND(C16/66,0)","v":288},null,null,"صيانات عامه للفندق",50000,{"$f":"SUM(H13:H16)","v":105000},null,{"$f":"ROUND(I16/66,0)","v":1591}]
[null,"صيانات عامه للفندق",50000,{"$f":"ROUND(C17/66,0)","v":758},null,null,"المجموع",null,{"$f":"SUM(I16,I12)","v":356000}," الصيانة المقدرة بالنسبة للفندق المدروس",null,{"$f":"ROUND(K16*'دراسة فندق'!B16,0)","v":0}]
[null,"مجموع بيانات الصيانة",null,{"$f":"SUM(D14:D17)","v":1592},null,null,"الدخل مخصوم الضرائب",{"$f":"ROUND('دراسة فندق'!M19+'دراسة فندق'!M20,0)","v":0},null,"المجموع ",null,{"$f":"ROUND(L13+L17,0)","v":0}]
[null,null,null,null,null,null,"تقليل نسبة الصيانة","النسبة","الفائض من الصيانة "]
[null,null,null,null,null,null,null,1,{"$f":"ROUND((L17)-(L17*H20),0)","v":0}]
[null,null,null,null,null,null,"نسبة الصيانة المقدرة",{"$f":"L17-I20","v":0}]
[null,null,null,null,null,null,"نسبة الصرف على الغرفه للمناسك",null,null,null,{"$f":"ROUND(SUM(K12+K16),0)","v":5394}]
[null,"تعديل نتائج الصيانة بعد تغيير نسبة الصيانة",null,null,null,null,"استخراج النتيجة "]
[null,"البند","الفائض من الصيانة","نسبة الصيانة",null,null,"النتيجة بالنسبة للصيانة 100%",null,null,"النتيجة بالنسبة للصيانة متغيرة النسبة",null,null,{"$f":"H20","v":1}]
[null,null,null,{"$f":"K25","v":1},null,null,"الدخل مخصوم الضرائب",{"$f":"H18","v":0},null,"فائض نسبة الصيانة",{"$f":"H20","v":1},{"$f":"I20","v":0}]
[null,"صيانة كهرباء",{"$f":"D14-D26","v":0},{"$f":"D14*D25","v":273},null,null,"الدخل بعد خصم المصروفات",{"$f":"H25-L18","v":0},null,"الدخل بعد خصم المصروفات",{"$f":"H25-(L13+H21)","v":0}]
[null,"صيانة سباكه",{"$f":"D15-D27","v":0},{"$f":"D15*D25","v":273},null,null,"ايجار الفندق",{"$f":"'دراسة فندق'!D22+10%","v":0.79999999999999993},{"$f":"ROUND(H26*H27,0)","v":0},"ايجار الفندق",{"$f":"H27","v":0.79999999999999993},{"$f":"ROUND(K26*K27,0)","v":0}]
[null,"صيانة مصاعد",{"$f":"D16-D28","v":0},{"$f":"D16*D25","v":288},null,null,"الضريبة",{"$f":"ROUND(I27*15%,0)","v":0},null,"الضريبة",{"$f":"L27*15%","v":0}]
[null,"صيانات عامه للفندق",{"$f":"D17-D29","v":0},{"$f":"D17*D25","v":758},null,null,"الايجار شامل الضريبة",{"$f":"I27+H28","v":0},null,"الايجار شامل الضريبة",{"$f":"L27+K28","v":0}]
[null,"مجموع بيانات الصيانة بعد تغيير النسبة",null,{"$f":"SUM(D26:D29)","v":1592},null,null,"الأرباح المتوقعة",{"$f":"H26-H29","v":0},null,"الأرباح المتوقعة ",{"$f":"K26-K29","v":0}]
[null,null,null,null,null,null,"الزكاه",{"$f":"H30*2.5%","v":0},null,"الزكاة ",{"$f":"K30*2.5%","v":0}]