{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["دراسة فندق","مصاريف"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,5,35,11],[37,1,37,13],[31,1,32,1],[31,3,32,3],[33,1,33,3],[34,2,36,2],[36,12,36,13],[36,5,36,11],[34,10,34,11],[34,13,35,13],[32,12,32,13],[30,5,34,9],[32,10,32,11],[33,10,33,11],[33,12,33,13],[31,12,31,13],[2,1,2,13],[5,1,11,2],[12,7,15,8],[22,1,22,3],[22,5,22,13],[19,10,19,11],[21,9,21,13],[17,9,20,9],[8,8,10,13],[8,3,10,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[12,2,13,2],[14,2,15,2],[16,2,21,2],[26,3,27,3],[29,1,30,1],[29,3,30,3],[25,2,32,2],[23,5,28,10],[30,10,30,11],[31,10,31,11],[23,11,24,11],[26,1,27,1],[1,1,1,13],[11,6,11,12],[3,5,3,13],[15,11,15,12],[21,5,21,6],[21,7,21,8],[12,11,14,12],[3,1,4,3],[16,10,16,13],[17,10,17,11],[18,10,18,11],[20,10,20,11],[3,4,36,4],[30,12,30,13],[15,9,15,10],[23,1,24,3]]}
[]
[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":271},{"$f":"D14","v":3000},{"$f":"H6*G6*F6","v":813000},{"$f":"I6","v":813000},{"$f":"(I6-((I6/(15+100)*100))+(I6-(I6/(2.5+100)*100)))*M6","v":1258.7274655355257},{"$f":"I6-K6","v":811741.27253446449},0.01,1]
[null,null,null,"موسم رمضان",null,0.95,{"$f":"B16","v":61},{"$f":"(D16/30)+H10","v":90},{"$f":"H7*G7*F7","v":5215.5},{"$f":"I7*30","v":156465},{"$f":"(J7-((J7/(15+100)*100))+(J7-(J7/(2.5+100)*100)))*M7","v":242.2469777306469},{"$f":"J7-K7","v":156222.75302226935},0.01,1]
[null,null,null,"مواسم العمرة",null,0.5,{"$f":"G7*F8","v":30.5},{"$f":"(H7/2)+H11","v":45},{"$f":"H8*G8","v":1372.5},{"$f":"I8*30*N8","v":288225},{"$f":"(J8-((J8/(15+100)*100))+(J8-(J8/(2.5+100)*100)))*M8","v":446.24443266171789},{"$f":"J8-K8","v":287778.75556733826},0.01,7]
[null,null,null,"التحكم بقيمة البيع للغرفة  ",null,"القيمة ",null,"(-) أو (+)"]
[null,null,null,null,null,"موسم رمضان "]
[null,null,null,null,null,"مواسم العمرة"]
[null,null,null,null,null,null," حساب مصروفات الموظفين للموسم"]
[null,"عدد الأسرة ","الحج","قيمة البيع للسرير",null,"مشرف فندق",1,null,null,"عدد موظف الاستقبال",1,null,null,"مجموع الرواتب "]
[null,271,null,3000,null,"الراتب  ",3500,null,null,"عدد حراس  الامن ",1,null,null,{"$f":"((G13*G14)+(G15*G16)+(K13*K15)+(K14*K15))","v":14000}]
[null,"عدد الغرف ","رمضان","قيمة البيع للغرفة شهري",null,"عدد عمال النظافة ",1,null,null,"الراتب",4000,null,null,"طوارئ 15%"]
[null,61,null,2700,null,"الراتب  ",2500,null,null,"مجموع الرواتب الموسمية + الطوارئ",null,{"$f":"((G13*G14)+(G15*G16)+(K13*K15)+(K14*K15))+N16","v":16100},null,{"$f":"N14*15%","v":2100}]
[null,"راتب مشرف الفندق ",null,"حارس الأمن والاستقبال ",null," العمالة الدائمة  ","عدد الموظفين ","الراتب ",null,null,"الدخل قبل التصفية"]
[null,null,null,null,null,"مشرف فندق ",1,1500,"مجموع الرواتب ",null," سعر البيع لمواسم العمرة مخصوم الضريبة",null,{"$f":"L8","v":287778.75556733826}]
[null,"راتب عامل النظافة  ",null,"الدلاله",null,"عامل صيانة ",1,1500,{"$f":"((G18*H18)+(G19*H19)+(G20*H20)+(G21*H21))*12","v":72000},null,"اجمالي سعر البيع للحج مخصوم الضريبة",null,{"$f":"L6","v":811741.27253446449}]
[null,null,null,null,null,"عامل نظافة ",1,1500,"احتياطي طوارئ 5%",null,"اجمالي سعر البيع لرمضان مخصوم الضريبة",null,{"$f":"L7","v":156222.75302226935}]
[null,"احتياطي طوارئ + مشتريات",null,"نسبة الايجار",null,"حارس فندق",1,1500,{"$f":"I19*10%","v":7200},null,"اختياطي الطوارئ والمشتريات",null,{"$f":"(M19+M20+M18)*B22","v":125574.27811240722}]
[null,0.1,null,0.7,null,"مجموع الرواتب 12 اشهر * 5%",null,{"$f":"(((G18*H18)+(G19*H19)+(G20*H20)+(G21*H21))*12)+I21","v":79200}]
[]
[null,"بيانات إضافية ",null,null,null,"دخل النشاط بعد خصم المصروفات التشغيلية والرواتب والضرائب",null,null,null,null,null,"إضافة دخل  موسم العمرة","الموسم","صافي الدخل "]
[null,null,null,null,null,null,null,null,null,null,null,null,"الحج",{"$f":"M19-(مصاريف!H31+L16)","v":733551.62253446446}]
[null,"نسبة تشغيل ",null,"العوائد",null,null,null,null,null,null,null,false,"رمضان",{"$f":"M20-(مصاريف!G31+L16)","v":107971.05302226935}]
[null,0.2,null,{"$f":"M36*B27","v":24212.357812820526},null,null,null,null,null,null,null,{"$f":"IF(L28>0,\"مفعل\",\"غير مفعل\")","v":"غير مفعل"},"مواسم العمرة ",{"$f":"M18-(مصاريف!I31+((L16/2)*N8))","v":51379.235567338241}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(L26,TRUE)","v":0},"  الطوارئ",{"$f":"M21","v":125574.27811240722}]
[null,"نسبة الزكاة ",null,"مبلغ الزكاة ",null,null,null,null,null,null,null,{"$f":"N27*L28","v":0},"المجموع",{"$f":"(N25+N26+L29)-(N28+H22)","v":636748.39744432666}]
[null,2.5000000000000001E-2,null,{"$f":"(N29-M34)*B30","v":3104.1484375410932}]
[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":"N29*M31","v":445723.87821102864}]
[null,null,null,null,null,null,null,null,null,null,"ضريبة الايجار",null,{"$f":"M32*15%","v":66858.581731654296}]
[null,"حساب الدخل بمعرفة سعر الايجار ",null,null,null,null,null,null,null,null,"الايجار شامل الضريبة",null,{"$f":"M32+M33","v":512582.45994268294}]
[null,"سعر الايجار",null,null,null,null,null,null,null,null,"  الطوارئ",null,{"$f":"N28","v":125574.27811240722},{"$f":"M35+M36","v":246636.06717650985}]
[null,"عدد الأسرة ",null,null,null,"العوائد المتوقعه ",null,null,null,null,null,null,{"$f":"(N29-M34-D30)","v":121061.78906410263}]
[null,"الناتج",null,{"$f":"D35/D36","v":{"$error":"#DIV/0!"}},null,"سعر الإيجــــــــــــــــــــــــــــــــار شامل الضريبة ",null,null,null,null,null,null,{"$f":"M34","v":512582.45994268294}]

{"sheet":"مصاريف","index":1,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"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":61},6,{"$f":"E6*F6*30","v":10980},{"$f":"E6*F6*20","v":7320},{"$f":"G6*8*$D$6","v":61487.999999999993}]
[null,null,"مياه",null,{"$f":"'دراسة فندق'!$G$7","v":61},4,{"$f":"E7*F7*30","v":7320},{"$f":"E7*F7*20","v":4880},{"$f":"G7*8*$D$6","v":40992}]
[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":271},3,{"$f":"E9*F9*4","v":3252},{"$f":"E9*F9*3","v":2439},18211.199999999997]
[null,null,"مناديل 8 تغييرات بالشهر",null,{"$f":"'دراسة فندق'!G7","v":61},2,{"$f":"E10*F10*8","v":976},{"$f":"E10*F10*6","v":732},5465.5999999999995]
[null,null,"مواد النظافة",null,{"$f":"'دراسة فندق'!G7","v":61},30,{"$f":"E11*F11","v":1830},{"$f":"E11*F11/1.5","v":1220},10248]
[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":"SUM(G6:G25)","v":27958},{"$f":"SUM(H6:H25)","v":53991},{"$f":"SUM(I6:I25)","v":156564.80000000002}]
[]
[]
[null,"مقدار الضريبة ",null,null,null,null,{"$f":"G26*15%","v":4193.7},{"$f":"H26*15%","v":8098.65},{"$f":"I26*15%","v":23484.720000000001}]
[]
[null,"الإجمالي ",null,null,null,null,{"$f":"G26+G29","v":32151.7},{"$f":"H26+H29","v":62089.65},{"$f":"I26+I29","v":180049.52000000002}]