{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MyDate","Reservation","R-A"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"MyDate","index":0,"n_rows":19,"n_cols":25,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,"Clock"]
[]
["إسم المستخدم","الباسورد","أخر مستخدم","صلاحية إضافة مستخدم","MyDate","ورقة2","Clock","ورقة3","المحرم1442","صفر","ربيع الاول","ربيع الاخر","جمادي الاولي","جمادي الاخرة","رجب","شعبان","رمضان","شوال","ذو القعدة","ذو الحجه","المحرم1443","تاكيد الحجز","طباعة تاكيد الحجز عربي","طباعة تاكيد الحجز ENG"]
["ياسر ابو اليسر",5586,"ياسر ابو اليسر  2021/05/25  07:59","مشاهدة وتعديل",{"$f":"D4","v":"مشاهدة وتعديل"},{"$f":"E4","v":"مشاهدة وتعديل"},"مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل","مشاهدة وتعديل"]
["عبد الرحمن",1980,"ياسر ابو اليسر  2021/05/25  11:27",null,{"$f":"D5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["سهيل خميس",1990,"ياسر ابو اليسر  2021/05/25  11:29",null,{"$f":"D6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["محمد نهاري",2000,"ياسر ابو اليسر  2021/05/25  15:52",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ياسر ابو اليسر  2021/05/25  15:56",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ياسر ابو اليسر  2021/05/25  17:08",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ياسر ابو اليسر  2021/05/25  17:21",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ياسر ابو اليسر  2021/05/26  03:51",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ياسر ابو اليسر  2021/06/08  11:29",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ياسر ابو اليسر  2021/06/08  12:19",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ياسر ابو اليسر  2021/06/08  14:51",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,{"$f":"G18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"D19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Reservation","index":1,"n_rows":16,"n_cols":317,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,4,0,5],[0,6,0,7],[0,14,0,16],[0,8,0,10],[0,11,0,13]]}
[44339.490944560188,null,"عدد غرف الفندق",300,"عدد الاسرة",null,3000,null,{"$f":"NOW()","v":"2021-06-08T19:31:03.890"},null,null,"بلان",null,null,{"$f":"NOW()","v":"2021-06-08T19:31:03.890"}]
["م","رقم الحجز\nالفاتورة","اسم الشركة\nاسم النزيل\n0","اسم المندوب الشركة\nاسم المرافق ( افراد )\n0","الجنسية\n0\n0","رقم الشركة\nرقم هوية النزيل","نوع الحجز\nافراد-شركة","اسم المسؤل عن الحجز\n0","تاريخ الدخول\n0","تاريخ الخروج\n0","السعر\nللنزيل\n0\n0","عدد\nالغرف\n0","عدد\nالاسرة\n0","عدد\nالليالي\n0","الاجمالي\nللنزيل\n0","الاسم","الايام",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300]
[1,15,"شركة ","محمد 1","مصري",152365987125,"شركة","نهاري","2021-05-23","2021-05-27",100,{"$f":"COUNT(R3:LE3)","v":8},{"$f":"IFERROR($G$1/$D$1*L3,\"0\")","v":80},{"$f":"J3-I3","v":4},{"$f":"IFERROR(K3*L3*N3,\"شركة\")","v":3200},{"$f":"C3","v":"شركة "},{"$f":"IF(I3=\"\",\"\",IF(J3<=TODAY(),\"منتهي\",DATEDIF(TODAY(),J3,\"d\")))","v":"منتهي"},101,102,103,105,110,115,130,510]
[2,20,"احمد جمال","محمد 2","سعودي",11100,"افراد","نهاري","2021-05-25","2021-05-28",150,{"$f":"COUNT(R4:LE4)","v":7},70,{"$f":"J4-I4","v":3},3150,{"$f":"C4","v":"احمد جمال"},{"$f":"IF(I4=\"\",\"\",IF(J4<=TODAY(),\"منتهي\",DATEDIF(TODAY(),J4,\"d\")))","v":"منتهي"},202,304,506,708,910,1011,512]
[3,25,"شركة 2","محمد 3","مصري",15,"شركة","نهاري","2021-05-24","2021-05-26","شركة",{"$f":"COUNT(R5:LE5)","v":11},110,{"$f":"J5-I5","v":2},"شركة","شركة 2",{"$f":"IF(I5=\"\",\"\",IF(J5<=TODAY(),\"منتهي\",DATEDIF(TODAY(),J5,\"d\")))","v":"منتهي"},601,603,605,607,609,611,620,621,1012,1014,1015]
[4,30,"تليستار","مجدي","مصري",20,"شركة","عطيه","2021-06-08","2021-06-11","شركة",{"$f":"COUNT(R6:LE6)","v":6},60,{"$f":"J6-I6","v":3},"شركة","تليستار",3,401,402,403,405,1001,1005]
[5,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R7:LE7)","v":0},0,{"$f":"J7-I7","v":0},0,0,""]
[6,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R8:LE8)","v":0},0,{"$f":"J8-I8","v":0},0,0,""]
[7,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R9:LE9)","v":0},0,{"$f":"J9-I9","v":0},0,0,""]
[8,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R10:LE10)","v":0},0,{"$f":"J10-I10","v":0},0,0,""]
[9,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R11:LE11)","v":0},0,{"$f":"J11-I11","v":0},0,0,""]
[10,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R12:LE12)","v":0},0,{"$f":"J12-I12","v":0},0,0,""]
[11,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R13:LE13)","v":0},0,{"$f":"J13-I13","v":0},0,0,""]
[12,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R14:LE14)","v":0},0,{"$f":"J14-I14","v":0},0,0,""]
[13,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R15:LE15)","v":0},0,{"$f":"J15-I15","v":0},0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R16:LE16)","v":0},{"$f":"IFERROR($G$1/$D$1*L16,\"0\")","v":0},{"$f":"J16-I16","v":0},{"$f":"IFERROR(K16*L16*N16,\"شركة\")","v":0},0,""]

{"sheet":"R-A","index":2,"n_rows":33,"n_cols":33,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,32,2],[5,0,5,2],[8,0,8,2],[11,0,11,2],[14,0,14,2],[17,0,17,2],[20,0,20,2],[1,3,1,5],[1,6,1,9],[23,0,23,2],[26,0,26,2],[29,0,29,2]]}
[]
[null,null,null,"تاريخ البلان",null,null,"2021-06-08"]
[]
["مشغول","فارغ","مكرر",101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130]
[null,null,null,{"$f":"IF(AND(D$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$4)),\"\")","v":1},{"$f":"IF(AND(E$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$4)),\"\")","v":1},{"$f":"IF(AND(F$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$4)),\"\")","v":1},{"$f":"IF(AND(G$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$4)),\"\")","v":1},{"$f":"IF(AND(H$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$4)),\"\")","v":1},{"$f":"IF(AND(I$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$4)),\"\")","v":1},{"$f":"IF(AND(J$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$4)),\"\")","v":1},{"$f":"IF(AND(K$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$4)),\"\")","v":1},{"$f":"IF(AND(L$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$4)),\"\")","v":1},{"$f":"IF(AND(M$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$4)),\"\")","v":1},{"$f":"IF(AND(N$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$4)),\"\")","v":1},{"$f":"IF(AND(O$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$4)),\"\")","v":1},{"$f":"IF(AND(P$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$4)),\"\")","v":1},{"$f":"IF(AND(Q$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$4)),\"\")","v":1},{"$f":"IF(AND(R$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$4)),\"\")","v":1},{"$f":"IF(AND(S$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$4)),\"\")","v":1},{"$f":"IF(AND(T$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$4)),\"\")","v":1},{"$f":"IF(AND(U$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$4)),\"\")","v":1},{"$f":"IF(AND(V$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$4)),\"\")","v":1},{"$f":"IF(AND(W$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$4)),\"\")","v":1},{"$f":"IF(AND(X$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$4)),\"\")","v":1},{"$f":"IF(AND(Y$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$4)),\"\")","v":1},{"$f":"IF(AND(Z$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$4)),\"\")","v":1},{"$f":"IF(AND(AA$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$4)),\"\")","v":1},{"$f":"IF(AND(AB$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$4)),\"\")","v":1},{"$f":"IF(AND(AC$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$4)),\"\")","v":1},{"$f":"IF(AND(AD$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$4)),\"\")","v":1},{"$f":"IF(AND(AE$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$4)),\"\")","v":1},{"$f":"IF(AND(AF$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$4)),\"\")","v":1},{"$f":"IF(AND(AG$4<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$4)),\"\")","v":1}]
["الاسم"]
["مشغول","فارغ","مكرر",201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230]
[null,null,null,{"$f":"IF(AND(D$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$7)),\"\")","v":1},{"$f":"IF(AND(E$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$7)),\"\")","v":1},{"$f":"IF(AND(F$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$7)),\"\")","v":1},{"$f":"IF(AND(G$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$7)),\"\")","v":1},{"$f":"IF(AND(H$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$7)),\"\")","v":1},{"$f":"IF(AND(I$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$7)),\"\")","v":1},{"$f":"IF(AND(J$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$7)),\"\")","v":1},{"$f":"IF(AND(K$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$7)),\"\")","v":1},{"$f":"IF(AND(L$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$7)),\"\")","v":1},{"$f":"IF(AND(M$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$7)),\"\")","v":1},{"$f":"IF(AND(N$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$7)),\"\")","v":1},{"$f":"IF(AND(O$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$7)),\"\")","v":1},{"$f":"IF(AND(P$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$7)),\"\")","v":1},{"$f":"IF(AND(Q$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$7)),\"\")","v":1},{"$f":"IF(AND(R$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$7)),\"\")","v":1},{"$f":"IF(AND(S$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$7)),\"\")","v":1},{"$f":"IF(AND(T$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$7)),\"\")","v":1},{"$f":"IF(AND(U$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$7)),\"\")","v":1},{"$f":"IF(AND(V$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$7)),\"\")","v":1},{"$f":"IF(AND(W$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$7)),\"\")","v":1},{"$f":"IF(AND(X$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$7)),\"\")","v":1},{"$f":"IF(AND(Y$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$7)),\"\")","v":1},{"$f":"IF(AND(Z$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$7)),\"\")","v":1},{"$f":"IF(AND(AA$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$7)),\"\")","v":1},{"$f":"IF(AND(AB$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$7)),\"\")","v":1},{"$f":"IF(AND(AC$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$7)),\"\")","v":1},{"$f":"IF(AND(AD$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$7)),\"\")","v":1},{"$f":"IF(AND(AE$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$7)),\"\")","v":1},{"$f":"IF(AND(AF$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$7)),\"\")","v":1},{"$f":"IF(AND(AG$7<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$7)),\"\")","v":1}]
["الاسم"]
["مشغول","فارغ","مكرر",301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330]
[null,null,null,{"$f":"IF(AND(D$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$10)),\"\")","v":1},{"$f":"IF(AND(E$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$10)),\"\")","v":1},{"$f":"IF(AND(F$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$10)),\"\")","v":1},{"$f":"IF(AND(G$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$10)),\"\")","v":1},{"$f":"IF(AND(H$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$10)),\"\")","v":1},{"$f":"IF(AND(I$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$10)),\"\")","v":1},{"$f":"IF(AND(J$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$10)),\"\")","v":1},{"$f":"IF(AND(K$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$10)),\"\")","v":1},{"$f":"IF(AND(L$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$10)),\"\")","v":1},{"$f":"IF(AND(M$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$10)),\"\")","v":1},{"$f":"IF(AND(N$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$10)),\"\")","v":1},{"$f":"IF(AND(O$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$10)),\"\")","v":1},{"$f":"IF(AND(P$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$10)),\"\")","v":1},{"$f":"IF(AND(Q$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$10)),\"\")","v":1},{"$f":"IF(AND(R$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$10)),\"\")","v":1},{"$f":"IF(AND(S$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$10)),\"\")","v":1},{"$f":"IF(AND(T$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$10)),\"\")","v":1},{"$f":"IF(AND(U$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$10)),\"\")","v":1},{"$f":"IF(AND(V$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$10)),\"\")","v":1},{"$f":"IF(AND(W$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$10)),\"\")","v":1},{"$f":"IF(AND(X$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$10)),\"\")","v":1},{"$f":"IF(AND(Y$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$10)),\"\")","v":1},{"$f":"IF(AND(Z$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$10)),\"\")","v":1},{"$f":"IF(AND(AA$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$10)),\"\")","v":1},{"$f":"IF(AND(AB$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$10)),\"\")","v":1},{"$f":"IF(AND(AC$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$10)),\"\")","v":1},{"$f":"IF(AND(AD$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$10)),\"\")","v":1},{"$f":"IF(AND(AE$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$10)),\"\")","v":1},{"$f":"IF(AND(AF$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$10)),\"\")","v":1},{"$f":"IF(AND(AG$10<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$10)),\"\")","v":1}]
["الاسم"]
["مشغول","فارغ","مكرر",401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430]
[null,null,null,{"$f":"IF(AND(D$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$13)),\"\")","v":0},{"$f":"IF(AND(E$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$13)),\"\")","v":0},{"$f":"IF(AND(F$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$13)),\"\")","v":0},{"$f":"IF(AND(G$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$13)),\"\")","v":1},{"$f":"IF(AND(H$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$13)),\"\")","v":0},{"$f":"IF(AND(I$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$13)),\"\")","v":1},{"$f":"IF(AND(J$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$13)),\"\")","v":1},{"$f":"IF(AND(K$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$13)),\"\")","v":1},{"$f":"IF(AND(L$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$13)),\"\")","v":1},{"$f":"IF(AND(M$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$13)),\"\")","v":1},{"$f":"IF(AND(N$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$13)),\"\")","v":1},{"$f":"IF(AND(O$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$13)),\"\")","v":1},{"$f":"IF(AND(P$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$13)),\"\")","v":1},{"$f":"IF(AND(Q$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$13)),\"\")","v":1},{"$f":"IF(AND(R$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$13)),\"\")","v":1},{"$f":"IF(AND(S$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$13)),\"\")","v":1},{"$f":"IF(AND(T$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$13)),\"\")","v":1},{"$f":"IF(AND(U$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$13)),\"\")","v":1},{"$f":"IF(AND(V$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$13)),\"\")","v":1},{"$f":"IF(AND(W$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$13)),\"\")","v":1},{"$f":"IF(AND(X$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$13)),\"\")","v":1},{"$f":"IF(AND(Y$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$13)),\"\")","v":1},{"$f":"IF(AND(Z$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$13)),\"\")","v":1},{"$f":"IF(AND(AA$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$13)),\"\")","v":1},{"$f":"IF(AND(AB$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$13)),\"\")","v":1},{"$f":"IF(AND(AC$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$13)),\"\")","v":1},{"$f":"IF(AND(AD$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$13)),\"\")","v":1},{"$f":"IF(AND(AE$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$13)),\"\")","v":1},{"$f":"IF(AND(AF$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$13)),\"\")","v":1},{"$f":"IF(AND(AG$13<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$13)),\"\")","v":1}]
["الاسم"]
["مشغول","فارغ","مكرر",501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530]
[null,null,null,{"$f":"IF(AND(D$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$16)),\"\")","v":1},{"$f":"IF(AND(E$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$16)),\"\")","v":1},{"$f":"IF(AND(F$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$16)),\"\")","v":1},{"$f":"IF(AND(G$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$16)),\"\")","v":1},{"$f":"IF(AND(H$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$16)),\"\")","v":1},{"$f":"IF(AND(I$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$16)),\"\")","v":1},{"$f":"IF(AND(J$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$16)),\"\")","v":1},{"$f":"IF(AND(K$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$16)),\"\")","v":1},{"$f":"IF(AND(L$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$16)),\"\")","v":1},{"$f":"IF(AND(M$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$16)),\"\")","v":1},{"$f":"IF(AND(N$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$16)),\"\")","v":1},{"$f":"IF(AND(O$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$16)),\"\")","v":1},{"$f":"IF(AND(P$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$16)),\"\")","v":1},{"$f":"IF(AND(Q$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$16)),\"\")","v":1},{"$f":"IF(AND(R$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$16)),\"\")","v":1},{"$f":"IF(AND(S$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$16)),\"\")","v":1},{"$f":"IF(AND(T$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$16)),\"\")","v":1},{"$f":"IF(AND(U$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$16)),\"\")","v":1},{"$f":"IF(AND(V$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$16)),\"\")","v":1},{"$f":"IF(AND(W$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$16)),\"\")","v":1},{"$f":"IF(AND(X$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$16)),\"\")","v":1},{"$f":"IF(AND(Y$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$16)),\"\")","v":1},{"$f":"IF(AND(Z$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$16)),\"\")","v":1},{"$f":"IF(AND(AA$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$16)),\"\")","v":1},{"$f":"IF(AND(AB$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$16)),\"\")","v":1},{"$f":"IF(AND(AC$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$16)),\"\")","v":1},{"$f":"IF(AND(AD$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$16)),\"\")","v":1},{"$f":"IF(AND(AE$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$16)),\"\")","v":1},{"$f":"IF(AND(AF$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$16)),\"\")","v":1},{"$f":"IF(AND(AG$16<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$16)),\"\")","v":1}]
["الاسم"]
["مشغول","فارغ","مكرر",601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630]
[null,null,null,{"$f":"IF(AND(D$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$19)),\"\")","v":1},{"$f":"IF(AND(E$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$19)),\"\")","v":1},{"$f":"IF(AND(F$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$19)),\"\")","v":1},{"$f":"IF(AND(G$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$19)),\"\")","v":1},{"$f":"IF(AND(H$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$19)),\"\")","v":1},{"$f":"IF(AND(I$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$19)),\"\")","v":1},{"$f":"IF(AND(J$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$19)),\"\")","v":1},{"$f":"IF(AND(K$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$19)),\"\")","v":1},{"$f":"IF(AND(L$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$19)),\"\")","v":1},{"$f":"IF(AND(M$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$19)),\"\")","v":1},{"$f":"IF(AND(N$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$19)),\"\")","v":1},{"$f":"IF(AND(O$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$19)),\"\")","v":1},{"$f":"IF(AND(P$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$19)),\"\")","v":1},{"$f":"IF(AND(Q$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$19)),\"\")","v":1},{"$f":"IF(AND(R$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$19)),\"\")","v":1},{"$f":"IF(AND(S$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$19)),\"\")","v":1},{"$f":"IF(AND(T$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$19)),\"\")","v":1},{"$f":"IF(AND(U$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$19)),\"\")","v":1},{"$f":"IF(AND(V$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$19)),\"\")","v":1},{"$f":"IF(AND(W$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$19)),\"\")","v":1},{"$f":"IF(AND(X$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$19)),\"\")","v":1},{"$f":"IF(AND(Y$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$19)),\"\")","v":1},{"$f":"IF(AND(Z$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$19)),\"\")","v":1},{"$f":"IF(AND(AA$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$19)),\"\")","v":1},{"$f":"IF(AND(AB$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$19)),\"\")","v":1},{"$f":"IF(AND(AC$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$19)),\"\")","v":1},{"$f":"IF(AND(AD$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$19)),\"\")","v":1},{"$f":"IF(AND(AE$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$19)),\"\")","v":1},{"$f":"IF(AND(AF$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$19)),\"\")","v":1},{"$f":"IF(AND(AG$19<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$19)),\"\")","v":1}]
["الاسم"]
["مشغول","فارغ","مكرر",701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730]
[null,null,null,{"$f":"IF(AND(D$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$22)),\"\")","v":1},{"$f":"IF(AND(E$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$22)),\"\")","v":1},{"$f":"IF(AND(F$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$22)),\"\")","v":1},{"$f":"IF(AND(G$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$22)),\"\")","v":1},{"$f":"IF(AND(H$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$22)),\"\")","v":1},{"$f":"IF(AND(I$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$22)),\"\")","v":1},{"$f":"IF(AND(J$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$22)),\"\")","v":1},{"$f":"IF(AND(K$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$22)),\"\")","v":1},{"$f":"IF(AND(L$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$22)),\"\")","v":1},{"$f":"IF(AND(M$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$22)),\"\")","v":1},{"$f":"IF(AND(N$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$22)),\"\")","v":1},{"$f":"IF(AND(O$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$22)),\"\")","v":1},{"$f":"IF(AND(P$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$22)),\"\")","v":1},{"$f":"IF(AND(Q$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$22)),\"\")","v":1},{"$f":"IF(AND(R$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$22)),\"\")","v":1},{"$f":"IF(AND(S$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$22)),\"\")","v":1},{"$f":"IF(AND(T$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$22)),\"\")","v":1},{"$f":"IF(AND(U$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$22)),\"\")","v":1},{"$f":"IF(AND(V$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$22)),\"\")","v":1},{"$f":"IF(AND(W$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$22)),\"\")","v":1},{"$f":"IF(AND(X$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$22)),\"\")","v":1},{"$f":"IF(AND(Y$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$22)),\"\")","v":1},{"$f":"IF(AND(Z$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$22)),\"\")","v":1},{"$f":"IF(AND(AA$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$22)),\"\")","v":1},{"$f":"IF(AND(AB$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$22)),\"\")","v":1},{"$f":"IF(AND(AC$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$22)),\"\")","v":1},{"$f":"IF(AND(AD$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$22)),\"\")","v":1},{"$f":"IF(AND(AE$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$22)),\"\")","v":1},{"$f":"IF(AND(AF$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$22)),\"\")","v":1},{"$f":"IF(AND(AG$22<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$22)),\"\")","v":1}]
["الاسم"]
["مشغول","فارغ","مكرر",801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830]
[null,null,null,{"$f":"IF(AND(D$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$25)),\"\")","v":1},{"$f":"IF(AND(E$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$25)),\"\")","v":1},{"$f":"IF(AND(F$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$25)),\"\")","v":1},{"$f":"IF(AND(G$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$25)),\"\")","v":1},{"$f":"IF(AND(H$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$25)),\"\")","v":1},{"$f":"IF(AND(I$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$25)),\"\")","v":1},{"$f":"IF(AND(J$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$25)),\"\")","v":1},{"$f":"IF(AND(K$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$25)),\"\")","v":1},{"$f":"IF(AND(L$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$25)),\"\")","v":1},{"$f":"IF(AND(M$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$25)),\"\")","v":1},{"$f":"IF(AND(N$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$25)),\"\")","v":1},{"$f":"IF(AND(O$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$25)),\"\")","v":1},{"$f":"IF(AND(P$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$25)),\"\")","v":1},{"$f":"IF(AND(Q$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$25)),\"\")","v":1},{"$f":"IF(AND(R$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$25)),\"\")","v":1},{"$f":"IF(AND(S$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$25)),\"\")","v":1},{"$f":"IF(AND(T$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$25)),\"\")","v":1},{"$f":"IF(AND(U$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$25)),\"\")","v":1},{"$f":"IF(AND(V$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$25)),\"\")","v":1},{"$f":"IF(AND(W$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$25)),\"\")","v":1},{"$f":"IF(AND(X$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$25)),\"\")","v":1},{"$f":"IF(AND(Y$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$25)),\"\")","v":1},{"$f":"IF(AND(Z$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$25)),\"\")","v":1},{"$f":"IF(AND(AA$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$25)),\"\")","v":1},{"$f":"IF(AND(AB$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$25)),\"\")","v":1},{"$f":"IF(AND(AC$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$25)),\"\")","v":1},{"$f":"IF(AND(AD$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$25)),\"\")","v":1},{"$f":"IF(AND(AE$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$25)),\"\")","v":1},{"$f":"IF(AND(AF$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$25)),\"\")","v":1},{"$f":"IF(AND(AG$25<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$25)),\"\")","v":1}]
["الاسم"]
["مشغول","فارغ","مكرر",901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930]
[null,null,null,{"$f":"IF(AND(D$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$28)),\"\")","v":1},{"$f":"IF(AND(E$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$28)),\"\")","v":1},{"$f":"IF(AND(F$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$28)),\"\")","v":1},{"$f":"IF(AND(G$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$28)),\"\")","v":1},{"$f":"IF(AND(H$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$28)),\"\")","v":1},{"$f":"IF(AND(I$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$28)),\"\")","v":1},{"$f":"IF(AND(J$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$28)),\"\")","v":1},{"$f":"IF(AND(K$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$28)),\"\")","v":1},{"$f":"IF(AND(L$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$28)),\"\")","v":1},{"$f":"IF(AND(M$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$28)),\"\")","v":1},{"$f":"IF(AND(N$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$28)),\"\")","v":1},{"$f":"IF(AND(O$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$28)),\"\")","v":1},{"$f":"IF(AND(P$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$28)),\"\")","v":1},{"$f":"IF(AND(Q$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$28)),\"\")","v":1},{"$f":"IF(AND(R$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$28)),\"\")","v":1},{"$f":"IF(AND(S$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$28)),\"\")","v":1},{"$f":"IF(AND(T$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$28)),\"\")","v":1},{"$f":"IF(AND(U$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$28)),\"\")","v":1},{"$f":"IF(AND(V$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$28)),\"\")","v":1},{"$f":"IF(AND(W$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$28)),\"\")","v":1},{"$f":"IF(AND(X$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$28)),\"\")","v":1},{"$f":"IF(AND(Y$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$28)),\"\")","v":1},{"$f":"IF(AND(Z$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$28)),\"\")","v":1},{"$f":"IF(AND(AA$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$28)),\"\")","v":1},{"$f":"IF(AND(AB$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$28)),\"\")","v":1},{"$f":"IF(AND(AC$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$28)),\"\")","v":1},{"$f":"IF(AND(AD$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$28)),\"\")","v":1},{"$f":"IF(AND(AE$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$28)),\"\")","v":1},{"$f":"IF(AND(AF$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$28)),\"\")","v":1},{"$f":"IF(AND(AG$28<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$28)),\"\")","v":1}]
["الاسم"]
["مشغول","فارغ","مكرر",1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030]
[null,null,null,{"$f":"IF(AND(D$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=D$31)),\"\")","v":0},{"$f":"IF(AND(E$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=E$31)),\"\")","v":1},{"$f":"IF(AND(F$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=F$31)),\"\")","v":1},{"$f":"IF(AND(G$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=G$31)),\"\")","v":1},{"$f":"IF(AND(H$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=H$31)),\"\")","v":0},{"$f":"IF(AND(I$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=I$31)),\"\")","v":1},{"$f":"IF(AND(J$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=J$31)),\"\")","v":1},{"$f":"IF(AND(K$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=K$31)),\"\")","v":1},{"$f":"IF(AND(L$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=L$31)),\"\")","v":1},{"$f":"IF(AND(M$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=M$31)),\"\")","v":1},{"$f":"IF(AND(N$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=N$31)),\"\")","v":1},{"$f":"IF(AND(O$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=O$31)),\"\")","v":1},{"$f":"IF(AND(P$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=P$31)),\"\")","v":1},{"$f":"IF(AND(Q$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Q$31)),\"\")","v":1},{"$f":"IF(AND(R$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=R$31)),\"\")","v":1},{"$f":"IF(AND(S$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=S$31)),\"\")","v":1},{"$f":"IF(AND(T$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=T$31)),\"\")","v":1},{"$f":"IF(AND(U$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=U$31)),\"\")","v":1},{"$f":"IF(AND(V$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=V$31)),\"\")","v":1},{"$f":"IF(AND(W$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=W$31)),\"\")","v":1},{"$f":"IF(AND(X$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=X$31)),\"\")","v":1},{"$f":"IF(AND(Y$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Y$31)),\"\")","v":1},{"$f":"IF(AND(Z$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=Z$31)),\"\")","v":1},{"$f":"IF(AND(AA$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AA$31)),\"\")","v":1},{"$f":"IF(AND(AB$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AB$31)),\"\")","v":1},{"$f":"IF(AND(AC$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AC$31)),\"\")","v":1},{"$f":"IF(AND(AD$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AD$31)),\"\")","v":1},{"$f":"IF(AND(AE$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AE$31)),\"\")","v":1},{"$f":"IF(AND(AF$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AF$31)),\"\")","v":1},{"$f":"IF(AND(AG$31<>\"\"),1-SUMPRODUCT((Reservation!$I$3:$I$200<=$G$2)\n*(Reservation!$J$3:$J$200>=$G$2+1)\n*(Reservation!$R$3:$IU$200=AG$31)),\"\")","v":1}]
["الاسم"]