{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ورقة1","تعريف الغرف","وحدات قياس الكيلو وات","وحدات قياس المساحه","وحدات قياس العماله","توزيع التكاليف"],"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":"ورقة1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"تعريف الغرف","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"T","T","T","T","T","T","T"]
[]
[null,"رقم الغرفه","النوع","السعر","ايام الاقامه التقديريه","ايام الاقامه الفعليه","اجمالى ايام الاقامه","المساحه م2","التكلفه الكليه","المعادله لا تعمل ( @column) فى النكلفه الكيه فى الفرف"]
[null,"غرفه 101","Single",2000,200,null,200,4,null,"التكلفه الكليه فى الغرف\n=SUMIF(التوزيعات!$C:$C;[@COLUMN1];التوزيعات!P:P)"]
[null,"غرفه 102","Single",2000,230,null,230,4]
[null,"غرفه 103","Single",2000,260,null,260,4]
[null,"غرفه 104","Double",2500,350,null,350,6]
[null,"غرفه 105","Double",2500,150,null,150,6]
[null,"غرفه 106","Double",2500,195,null,195,6]

{"sheet":"وحدات قياس الكيلو وات","index":2,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,"الغرف"]
[null,null,"غرفه 101",{"$f":"IF(C2<>\"\",SUMIF('تعريف الغرف'!$B:$B,'وحدات قياس المساحه'!C4,'تعريف الغرف'!$H:$H),\"\")","v":4},{"$f":"IF(C2<>\"\",D2/$D$3,\"\")","v":1},null,null,null,null,null,null,null,null,{"$f":"IF(C2<>\"\",$N$3*E1,\"\")","v":0}]
[null,null,"غرفه 102",{"$f":"IF(C3<>\"\",SUMIF('تعريف الغرف'!$B:$B,'وحدات قياس المساحه'!C5,'تعريف الغرف'!$H:$H),\"\")","v":4},null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,"غرفه 103",{"$f":"IF(C4<>\"\",SUMIF('تعريف الغرف'!$B:$B,'وحدات قياس المساحه'!C6,'تعريف الغرف'!$H:$H),\"\")","v":4},null,null,null,null,null,null,null,null,null,0]
[null,null,"غرفه 104",{"$f":"IF(C5<>\"\",SUMIF('تعريف الغرف'!$B:$B,'وحدات قياس المساحه'!C7,'تعريف الغرف'!$H:$H),\"\")","v":6},null,null,null,null,null,null,null,null,null,0]
[null,null,"غرفه 105",{"$f":"IF(C6<>\"\",SUMIF('تعريف الغرف'!$B:$B,'وحدات قياس المساحه'!C8,'تعريف الغرف'!$H:$H),\"\")","v":6},null,null,null,null,null,null,null,null,null,0]
[null,null,"غرفه 106",{"$f":"IF(C7<>\"\",SUMIF('تعريف الغرف'!$B:$B,'وحدات قياس المساحه'!C9,'تعريف الغرف'!$H:$H),\"\")","v":6},null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"الاجمالى"]
[null,null,null,"فقط الغرف","%",null,"المطبخ","الاستقبال","النظافه","اداريين","الامن","متنوع","اخرى","عام خدمى"]

{"sheet":"وحدات قياس المساحه","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"الاجمالى"]
[null,null,null,"فقط الغرف","%",null,"المطبخ","الاستقبال","الامن","عام خدمى"]
[null,null,"الغرف"]
[null,null,"غرفه 101",null,{"$f":"IF(C4<>\"\",D4/$D$3,\"\")","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF(C4<>\"\",$J$3*E3,\"\")","v":0}]
[null,null,"غرفه 102",null,null,null,null,null,null,{"$f":"IF(C5<>\"\",$J$3*E4,\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,"غرفه 103",null,null,null,null,null,null,0]
[null,null,"غرفه 104",null,null,null,null,null,null,0]
[null,null,"غرفه 105",null,null,null,null,null,null,0]
[null,null,"غرفه 106",null,null,null,null,null,null,0]

{"sheet":"وحدات قياس العماله","index":4,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"الاجمالى"]
[null,null,null,"فقط الغرف","%",null,"المطبخ","الاستقبال","نظافه","عمال","اداريين","الامن","عام خدمى"]
[null,null,"الغرف"]
[null,null,"غرفه 101",null,null,null,null,{"$f":"IF(C4<>\"\",$H$3*E4,\"\")","v":0},null,null,null,null,{"$f":"IF(C4<>\"\",$M$3*E3,\"\")","v":0}]
[null,null,"غرفه 102",null,null,null,null,null,null,null,null,null,{"$f":"IF(C5<>\"\",$M$3*E4,\"\")","v":0}]
[null,null,"غرفه 103",null,null,null,null,null,null,null,null,null,0]
[null,null,"غرفه 104",null,null,null,null,null,null,null,null,null,0]
[null,null,"غرفه 105",null,null,null,null,null,null,null,null,null,0]
[null,null,"غرفه 106",null,null,null,null,null,null,null,null,null,0]

{"sheet":"توزيع التكاليف","index":5,"n_rows":8,"n_cols":21,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"الغرف","Q  الاقامه ",null,"MIX",null,"KWH",null,"M2",null,null,null,null,null,"اجمالى التكلف اليوميه","الاهلاكات المباشرة","الاهلاكات الغيرالمباشرة","الطاقه الكهربائيه","القيمه الايجاريه","نكلفه العماله اليوميه"]
[]
[null,null,null,"Q  ","%","Q  ","%","Q  ","%","Q  ","%",null,null,null,null,null,null,0,null,0]
[]
[]
[null,null,"غرفه 101",200,"",null,"",0,"",0,"",null,null,null,null,null,0]
[null,null,"غرفه 102"]