{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["save","data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"save","index":0,"n_rows":27,"n_cols":27,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["رقم الفاتورة","نوع الحجز\nشركة-افراد","اسم الشركة\nاسم النزيل","اسم المندوب الشركة\nاسم المرافق ( افراد )","الجنسية","رقم الشركة\nرقم هوية النزيل","اسم المسؤل عن الحجز","تاريخ الدخول","تاريخ الخروج","السعر\nللنزيل\n","عدد\nالغرف","عدد\nالاسرة","عدد\nالليالي","الاجمالي\nللنزيل","الاسم","الايام","غرفة 1","غرفة 2","غرفة 3","غرفة 4","غرفة 5","غرفة 6","غرفة 7","غرفة 8","غرفة 9","غرفة 10","تجميع ارقام الغرف كاملة"]
[null,null,{"$f":"data!E1","v":"اسم الفندق هنا"}]
[5,"شركة",1,"حمدي","مصري",211,"نهاري","2021-06-11","2021-06-11",null,{"$f":"COUNT(Q3:Z3)","v":3},{"$f":"IFERROR($G$1/$D$1*K3,\"0\")","v":"0"},{"$f":"I3-H3","v":0},{"$f":"IFERROR(J3*K3*M3,\"شركة\")","v":0},{"$f":" تجزئة_الاسماء_والارقام(C3,1)","v":"1"},{"$f":"IF(H3=\"\",\"\",IF(I3<=TODAY(),\"منتهي\",DATEDIF(TODAY(),I3,\"d\")))","v":"منتهي"},101,102,103,null,null,null,null,null,null,null,{"$f":"Combine(Q3:Z3)","v":"101~102~103~~~~~~~"}]
[6,"شركة",2,"حمدي","مصري",212,"نهاري","2021-06-11","2021-06-11",null,3,{"$f":"IFERROR($G$1/$D$1*K4,\"0\")","v":"0"},{"$f":"I4-H4","v":0},{"$f":"IFERROR(J4*K4*M4,\"شركة\")","v":0},{"$f":" تجزئة_الاسماء_والارقام(C4,1)","v":"2"},{"$f":"IF(H4=\"\",\"\",IF(I4<=TODAY(),\"منتهي\",DATEDIF(TODAY(),I4,\"d\")))","v":"منتهي"},105,107,108,null,null,null,null,null,null,null,"105~107~108~~~~~~~"]
[7,"شركة",3,"حمدي","مصري",213,"نهاري","2021-06-11","2021-06-11",null,3,{"$f":"IFERROR($G$1/$D$1*K5,\"0\")","v":"0"},{"$f":"I5-H5","v":0},{"$f":"IFERROR(J5*K5*M5,\"شركة\")","v":0},{"$f":" تجزئة_الاسماء_والارقام(C5,1)","v":"3"},{"$f":"IF(H5=\"\",\"\",IF(I5<=TODAY(),\"منتهي\",DATEDIF(TODAY(),I5,\"d\")))","v":"منتهي"},201,202,203,null,null,null,null,null,null,null,"201~202~203~~~~~~~"]
[8,"شركة",4,"حمدي","مصري",214,"نهاري","2021-06-11","2021-06-11",null,3,{"$f":"IFERROR($G$1/$D$1*K6,\"0\")","v":"0"},{"$f":"I6-H6","v":0},{"$f":"IFERROR(J6*K6*M6,\"شركة\")","v":0},{"$f":" تجزئة_الاسماء_والارقام(C6,1)","v":"4"},{"$f":"IF(H6=\"\",\"\",IF(I6<=TODAY(),\"منتهي\",DATEDIF(TODAY(),I6,\"d\")))","v":"منتهي"},401,405,406,null,null,null,null,null,null,null,"401~405~406~~~~~~~"]
[5,"شركة","اكرام","محمد","تركي",310,"نهاري","2021-06-10","2021-06-10","شركة",10,{"$f":"IFERROR($G$1/$D$1*K7,\"0\")","v":"0"},{"$f":"I7-H7","v":0},{"$f":"IFERROR(J7*K7*M7,\"شركة\")","v":"شركة"},{"$f":" تجزئة_الاسماء_والارقام(C7,1)","v":"اكرام"},{"$f":"IF(H7=\"\",\"\",IF(I7<=TODAY(),\"منتهي\",DATEDIF(TODAY(),I7,\"d\")))","v":"منتهي"},601,602,603,604,605,606,607,608,609,610,"601~602~603~604~605~606~607~608~609~610"]
[17,"افراد","خالد","يييييي","سسسس",100,"نهاري","2021-06-05","2021-06-10",100,3,"0",5,1500,"خالد","منتهي",101,102,103,null,null,null,null,null,null,null,"101~102~103~~~~~~~"]
[17,"افراد","ياسر ابو اليسر","زوجته","مصري",1312313213,"نهاري","2021-06-10","2021-06-10",150,10,"0",0,0,"ياسر","منتهي",1030,102,103,105,107,108,109,1001,1003,1005,"1030~102~103~105~107~108~109~1001~1003~1005"]
[5,"شركة","الاوائل","حمدي","مصري",211,"نهاري","2021-06-11","2021-06-01","شركة",5,"0",-10,"شركة","الاوائل","منتهي",1001,1002,1003,1004,1005,null,null,null,null,null,"1001~1002~1003~1004~1005~~~~~"]
[5,"شركة","الاوائل","حمدي","مصري",211,"نهاري","2021-06-11","2021-06-11",null,2,"0",0,0,"الاوائل","منتهي",109,111,null,null,null,null,null,null,null,null,"109~111~~~~~~~~"]
[4,"شركة","الاوائل","حمدي","مصري",210,"نهاري","2021-06-11","2021-06-11","شركة",5,"0",0,"شركة","الاوائل","منتهي",401,402,403,501,502,null,null,null,null,null,"401~402~403~501~502~~~~~"]
[4,"شركة","تليستار للسياحة","محمد","مصر",252,"احمد عطيه","2021-06-01","2021-06-02",null,8,"0",1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[6,"شركة","تليستار للسياحة","محمد","مصر",254,"احمد عطيه","2021-06-01","2021-06-04",null,8,"0",3,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[8,"شركة","تليستار للسياحة","محمد","مصر",256,"احمد عطيه","2021-06-01","2021-06-07",null,8,"0",6,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[5,"شركة","تليستار للسياحة","محمد","مصر",253,"احمد عطيه","2021-06-01","2021-06-03",null,8,"0",2,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[7,"شركة","تليستار للسياحة","محمد","مصر",255,"احمد عطيه","2021-06-01","2021-06-05",null,8,"0",4,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[4,"شركة","تليستار للسياحة","محمد","مصر",252,"احمد عطيه","2021-06-01","2021-06-02",null,8,"0",1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[6,"شركة","تليستار للسياحة","محمد","مصر",254,"احمد عطيه","2021-06-01","2021-06-04",null,8,"0",3,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[8,"شركة","تليستار للسياحة","محمد","مصر",256,"احمد عطيه","2021-06-01","2021-06-07",null,8,"0",6,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[5,"شركة","تليستار للسياحة","محمد","مصر",253,"احمد عطيه","2021-06-01","2021-06-03",null,8,"0",2,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[4,"شركة","تليستار للسياحة","محمد","مصر",252,"احمد عطيه","2021-06-01","2021-06-02",null,8,"0",1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[8,"شركة","تليستار للسياحة","محمد","مصر",256,"احمد عطيه","2021-06-01","2021-06-07",null,8,"0",6,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[7,"شركة","تليستار للسياحة","محمد","مصر",255,"احمد عطيه","2021-06-01","2021-06-05",null,8,"0",4,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[7,"شركة","تليستار للسياحة","محمد","مصر",255,"احمد عطيه","2021-06-01","2021-06-05",null,8,"0",4,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[5,"شركة","تليستار للسياحة","محمد","مصر",253,"احمد عطيه","2021-06-01","2021-06-03",null,8,"0",2,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[6,"شركة","تليستار للسياحة","محمد","مصر",254,"احمد عطيه","2021-06-01","2021-06-04",null,8,"0",3,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]

{"sheet":"data","index":1,"n_rows":40,"n_cols":27,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,4,0,5],[0,13,0,15],[0,10,0,12],[0,7,0,8]]}
[44339.490944560188,null,null,300,"اسم الفندق هنا",null,2800,{"$f":"NOW()","v":"2021-06-13T13:55:25.280"},null,null,"plan",null,null,{"$f":"NOW()","v":"2021-06-13T13:55:25.280"}]
["رقم الفاتورة","نوع الحجز\nشركة-افراد","اسم الشركة\nاسم النزيل","اسم المندوب الشركة\nاسم المرافق ( افراد )","الجنسية","رقم الشركة\nرقم هوية النزيل","اسم المسؤل عن الحجز","تاريخ الدخول","تاريخ الخروج","السعر\nللنزيل\n","عدد\nالغرف","عدد\nالاسرة","عدد\nالليالي","الاجمالي\nللنزيل","الاسم","الايام","غرفة 1","غرفة 2","غرفة 3","غرفة 4","غرفة 5","غرفة 6","غرفة 7","غرفة 8","غرفة 9","غرفة 10","تجميع ارقام الغرف كاملة"]
[2,"شركة","تليستار للسياحة","محمد","مصر",250,"احمد عطيه","2021-06-01","2021-06-17","شركة",{"$f":"COUNT(Q3:Z3)","v":8},{"$f":"IFERROR($G$1/$D$1*K3,\"0\")","v":74.666666666666671},{"$f":"I3-H3","v":16},{"$f":"IFERROR(J3*K3*M3,\"شركة\")","v":"شركة"},{"$f":" تجزئة_الاسماء_والارقام(C3,1)","v":"تليستار"},{"$f":"IF(H3=\"\",\"\",IF(I3<=TODAY(),\"منتهي\",DATEDIF(TODAY(),I3,\"d\")))","v":4},205,206,207,208,209,210,null,null,211,101,{"$f":"Combine(Q3:Z3)","v":{"$error":"#VALUE!"}}]
[3,"شركة","تليستار للسياحة","محمد","مصر",251,"احمد عطيه","2021-06-01","2021-06-17",null,8,74.666666666666671,16,0,"تليستار",4,205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[19,"شركة","تليستار للسياحة","محمد","مصر",267,"احمد عطيه","2021-06-01","2021-06-17",null,8,74.666666666666671,16,0,"تليستار",4,205,206,207,208,209,210,null,null,211,101,{"$error":"#VALUE!"}]
[20,"شركة","تليستار للسياحة","محمد","مصر",268,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[21,"شركة","تليستار للسياحة","محمد","مصر",269,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[22,"شركة","تليستار للسياحة","محمد","مصر",270,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[23,"شركة","تليستار للسياحة","محمد","مصر",271,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[24,"شركة","تليستار للسياحة","محمد","مصر",272,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[25,"شركة","تليستار للسياحة","محمد","مصر",273,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[26,"شركة","تليستار للسياحة","محمد","مصر",274,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[27,"شركة","تليستار للسياحة","محمد","مصر",275,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[28,"شركة","تليستار للسياحة","محمد","مصر",276,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[29,"شركة","تليستار للسياحة","محمد","مصر",277,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[30,"شركة","تليستار للسياحة","محمد","مصر",278,"احمد عطيه","2021-06-01","2021-06-02",null,8,74.666666666666671,1,0,"تليستار","منتهي",205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[2,"شركة","تليستار للسياحة","محمد","مصر",250,"احمد عطيه","2021-06-01","2021-06-17",null,8,74.666666666666671,16,0,"تليستار",4,205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[3,"شركة","تليستار للسياحة","محمد","مصر",251,"احمد عطيه","2021-06-01","2021-06-17",null,8,74.666666666666671,16,0,"تليستار",4,205,206,207,208,209,210,null,null,211,101,"205~206~207~208~209~210~~~211~101"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(Q20:Z20)","v":0},0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$f":"Combine(Q20:Z20)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","",null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]