{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Room Reservation","Available"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Room Reservation","index":0,"n_rows":12,"n_cols":37,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Booking No","Guest Name","Guest Phone","Guest Country","Guest ID","Check In","Check Out","Adult Guests","Children Guests","Room Type","Room No"]
[1,"MAIRAJ",29038423,"India",null,"2020-06-11","2020-06-12",1,1,"Standard",101]
[2,"MARYAM",2348203,"Pakistan",null,"2020-06-12","2020-06-15",2,0,"Standard",110]
[3,"Shanza Waseem",239423,"USA",null,"2020-06-12","2020-06-15",2,1,"Superior",125]
[4,"Adeeba Kanwal",2342432,"England",null,"2020-06-12","2020-06-15",1,1,"Superior",120]
[null,"Adeeba Kanwal",null,null,null,"2020-06-12","2020-06-15",null,null,"Standard",105]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Available"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Available"]

{"sheet":"Available","index":1,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"TODAY()","v":"2020-06-13"}]
[]
[null,null,"Room No","Room Type","Status"]
[null,null,101,"Standard",{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C6,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D6,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"محجوزة"}]
[null,null,{"$f":"+C6+1","v":102},"Standard",{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C7,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D7,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,{"$f":"+C7+1","v":103},"Standard",{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C8,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D8,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,104,"Standard",{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C9,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D9,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,105,"Standard",{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C10,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D10,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"محجوزة"}]
[null,null,106,"Standard",{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C11,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D11,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,107,"Standard",{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C12,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D12,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,108,"Standard",{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C13,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D13,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,109,"Standard",{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C14,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D14,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,110,"Standard",{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C15,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D15,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"محجوزة"}]
[null,null,111,"Superior",{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C16,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D16,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,112,"Superior",{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C17,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D17,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,113,"Superior",{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C18,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D18,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,114,"Superior",{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C19,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D19,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,115,"Superior",{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C20,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D20,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,116,"Superior",{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C21,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D21,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,117,"Superior",{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C22,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D22,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,118,"Superior",{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C23,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D23,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,119,"Superior",{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C24,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D24,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,120,"Superior",{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C25,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D25,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"محجوزة"}]
[null,null,121,"Superior",{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C26,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D26,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,122,"Superior",{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C27,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D27,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,123,"Superior",{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C28,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D28,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,124,"Superior",{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C29,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D29,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,125,"Superior",{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C30,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D30,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"محجوزة"}]
[null,null,126,"Superior",{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C31,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D31,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,127,"Superior",{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C32,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D32,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,128,"Superior",{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C33,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D33,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,129,"Superior",{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C34,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D34,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]
[null,null,130,"Superior",{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND(ISNUMBER(MATCH($C35,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D35,'Room Reservation'!$J$2:$J$6000,0))),\"محجوزة\",\"غير محجوزة \"))","v":"غير محجوزة "}]