{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Home","Database","Support","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Home","index":0,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,4,5,14]]}
[]
[]
[]
[null,null,null,null,"Room Booking Form"]

{"sheet":"Database","index":1,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["S.NO","R Card NO","Guest Name","Addres","Country","Company","Arrival","Departure","Days","Adult","Children","Room","Room Type","Meals"]
[{"$f":"ROW()-1","v":1},"01-00002","Alaa","Egypt","Bahamas, The","Booking,com","2020-06-28","2020-06-30",2,1,3,"Room101","Double","B.O"]
[{"$f":"ROW()-1","v":2},"01-00003","Alaa Mohamed Mohamed Ali","Egypt - Aswan","American Samoa","Booking,com","2020-06-28","2020-06-29",3,1,0,"Room 104","Double","ALL SOFT"]
[{"$f":"ROW()-1","v":3},"01-00004","Ahmed Ali","Egypt","Belize","Booking,com","2020-07-13","2020-07-15",2,1,2,"Room 114","Single","Bed & Brakfast"]
[{"$f":"ROW()-1","v":4},"01-00005","Mohamed Ahmed","Egypt","Albania","Booking,com","2020-08-19","2020-08-23",3,5,0,"Room 105","Single","Bed & Brakfast"]

{"sheet":"Support","index":2,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Room","Meals","status","Room Type","Country","Combany","ID Type",null,"Status",null,"Years",null,"Months","Index",null,"Rooms",null,"Description"]
["Room 101","B.O","Reservation","Single","Abkhazia","Booking,com","ID",null,"Unconfirmed",null,2020,null,"January",1,null,"Room 101",null,"Towels"]
["Room 102","Bed & Brakfast","Check IN","Double","Afghanistan",null,"Passport",null,"Confirmed",null,2021,null,"February",2,null,"Room 102",null,"Damage"]
["Room 103","H.B","Check OUT",null,"Akrotiri",null,"Driver License",null,"Paid",null,2022,null,"March",3,null,"Room 103",null,"Drinks"]
["Room 104","F.B",null,null,"Aland",null,null,null,"Cancelled",null,2023,null,"April",4,null,"Room 104",null,"Tokens"]
["Room 105","ALL SOFT",null,null,"Albania",null,null,null,"Chick In",null,2024,null,"May",5,null,"Room 105",null,"Foods"]
["Room 106","ALL HARD",null,null,"Algeria",null,null,null,"Chick Out",null,2025,null,"June",6,null,"Room 106"]
["Room 107",null,null,null,"American Samoa",null,null,null,null,null,2026,null,"July",7,null,"Room 107"]
["Room 108",null,null,null,"Andorra",null,null,null,null,null,2027,null,"August",8,null,"Room 108"]
["Room 109",null,null,null,"Angola",null,null,null,null,null,null,null,"September",9,null,"Room 109"]
["Room 110",null,null,null,"Anguilla",null,null,null,null,null,null,null,"October",10,null,"Room 110"]
["Room 111",null,null,null,"Antigua and Barbuda",null,null,null,null,null,null,null,"November",11,null,"Room 111"]
["Room 112",null,null,null,"Argentina",null,null,null,null,null,null,null,"December",12,null,"Room 112"]
["Room 114",null,null,null,"Armenia",null,null,null,null,null,null,null,null,13,null,"Room 114"]
["Room 115",null,null,null,"Aruba",null,null,null,null,null,null,null,null,14,null,"Room 115"]
["Room 116",null,null,null,"Ascension Island",null,null,null,null,null,null,null,null,15,null,"Room 116"]
["Room 117",null,null,null,"Australia",null,null,null,null,null,null,null,null,16,null,"Room 117"]
[null,null,null,null,"Austria",null,null,null,null,null,null,null,null,17,null,"Room 118"]
[null,null,null,null,"Azerbaijan",null,null,null,null,null,null,null,null,18,null,"Room 119"]
[null,null,null,null,"Bahamas, The",null,null,null,null,null,null,null,null,19,null,"Room 120"]
[null,null,null,null,"Bahrain",null,null,null,null,null,null,null,null,20,null,"Room 121"]
[null,null,null,null,"Bangladesh",null,null,null,null,null,null,null,null,21,null,"Room 122"]
[null,null,null,null,"Barbados",null,null,null,null,null,null,null,null,22,null,"Room 123"]
[null,null,null,null,"Belarus",null,null,null,null,null,null,null,null,null,null,"Room 124"]
[null,null,null,null,"Belgium",null,null,null,null,null,null,null,null,null,null,"Room 125"]
[null,null,null,null,"Belize",null,null,null,null,null,null,null,null,null,null,"Room 126"]
[null,null,null,null,"Benin ",null,null,null,null,null,null,null,null,null,null,"Room 127"]
[null,null,null,null,"Bermuda",null,null,null,null,null,null,null,null,null,null,"Room 128"]
[null,null,null,null,"Bhutan",null,null,null,null,null,null,null,null,null,null,"Room 129"]
[null,null,null,null,"Bolivia"]
[null,null,null,null,"Bosnia and Herzegovina"]
[null,null,null,null,"Botswana"]
[null,null,null,null,"Brazil"]
[null,null,null,null,"Brunei"]
[null,null,null,null,"Bulgaria"]
[null,null,null,null,"Burkina Faso "]
[null,null,null,null,"Burundi"]

{"sheet":"Sheet1","index":3,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Room Number","Floor","Room Type","No.of.Pax","Room Statuse","Reat /Day"]
["Room101","Ground","Double",1,{"$f":"IF(OR(A2=\"\",C2=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A2,Database!$M$2:$M$6000,C2,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},200]
["Room102","Ground","Double",{"$f":"D2+1","v":2},{"$f":"IF(OR(A3=\"\",C3=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A3,Database!$M$2:$M$6000,C3,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},{"$f":"+F2+50","v":250}]
["Room 103","Ground","Single",{"$f":"D3+1","v":3},{"$f":"IF(OR(A4=\"\",C4=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A4,Database!$M$2:$M$6000,C4,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},{"$f":"+F3+50","v":300}]
["Room 104","Ground","Double",4,{"$f":"IF(OR(A5=\"\",C5=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A5,Database!$M$2:$M$6000,C5,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},{"$f":"+F4+50","v":350}]
["Room 105","Ground","Single",5,{"$f":"IF(OR(A6=\"\",C6=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A6,Database!$M$2:$M$6000,C6,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"booked"},400]
["Room 106","Ground","Double",6,{"$f":"IF(OR(A7=\"\",C7=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A7,Database!$M$2:$M$6000,C7,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},450]
["Room 107","Ground","Single",7,{"$f":"IF(OR(A8=\"\",C8=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A8,Database!$M$2:$M$6000,C8,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},500]
["Room 108","Ground","Double",8,{"$f":"IF(OR(A9=\"\",C9=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A9,Database!$M$2:$M$6000,C9,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},550]
["Room 109","Ground","Single",9,{"$f":"IF(OR(A10=\"\",C10=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A10,Database!$M$2:$M$6000,C10,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},600]
["Room 110","Ground","Double",10,{"$f":"IF(OR(A11=\"\",C11=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A11,Database!$M$2:$M$6000,C11,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},650]
["Room 111","1st floor","Single",11,{"$f":"IF(OR(A12=\"\",C12=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A12,Database!$M$2:$M$6000,C12,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},700]
["Room 112","1st floor","Double",12,{"$f":"IF(OR(A13=\"\",C13=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A13,Database!$M$2:$M$6000,C13,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},750]
["Room 114","1st floor","Single",13,{"$f":"IF(OR(A14=\"\",C14=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A14,Database!$M$2:$M$6000,C14,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},800]
["Room 115","1st floor","Double",14,{"$f":"IF(OR(A15=\"\",C15=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A15,Database!$M$2:$M$6000,C15,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},850]
["Room 116","1st floor","Single",15,{"$f":"IF(OR(A16=\"\",C16=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A16,Database!$M$2:$M$6000,C16,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},900]
["Room 117","1st floor","Double",16,{"$f":"IF(OR(A17=\"\",C17=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A17,Database!$M$2:$M$6000,C17,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},950]
["Room 118","1st floor","Single",17,{"$f":"IF(OR(A18=\"\",C18=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A18,Database!$M$2:$M$6000,C18,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1000]
["Room 119","1st floor","Double",18,{"$f":"IF(OR(A19=\"\",C19=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A19,Database!$M$2:$M$6000,C19,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1050]
["Room 120","1st floor","Single",19,{"$f":"IF(OR(A20=\"\",C20=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A20,Database!$M$2:$M$6000,C20,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1100]
["Room 121","2nd floor","Double",20,{"$f":"IF(OR(A21=\"\",C21=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A21,Database!$M$2:$M$6000,C21,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1150]
["Room 122","2nd floor","Single",21,{"$f":"IF(OR(A22=\"\",C22=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A22,Database!$M$2:$M$6000,C22,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1200]
["Room 123","2nd floor","Double",2,{"$f":"IF(OR(A23=\"\",C23=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A23,Database!$M$2:$M$6000,C23,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1250]
["Room 124","2nd floor","Single",1,{"$f":"IF(OR(A24=\"\",C24=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A24,Database!$M$2:$M$6000,C24,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1300]
["Room 125","2nd floor","Double",2,{"$f":"IF(OR(A25=\"\",C25=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A25,Database!$M$2:$M$6000,C25,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1350]
["Room 126","2nd floor","Single",1,{"$f":"IF(OR(A26=\"\",C26=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A26,Database!$M$2:$M$6000,C26,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1400]
["Room 127","2nd floor","Double",2,{"$f":"IF(OR(A27=\"\",C27=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A27,Database!$M$2:$M$6000,C27,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1450]
["Room 128","2nd floor","Single",1,{"$f":"IF(OR(A28=\"\",C28=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A28,Database!$M$2:$M$6000,C28,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1500]
["Room 129","2nd floor","Double",2,{"$f":"IF(OR(A29=\"\",C29=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A29,Database!$M$2:$M$6000,C29,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1550]
["Room 130","2nd floor","Single",1,{"$f":"IF(OR(A30=\"\",C30=\"\"),\"\",IF(COUNTIFS(Database!$L$2:$L$6000,A30,Database!$M$2:$M$6000,C30,Database!$G$2:$G$6000,\"<=\"&TODAY(),Database!$H$2:$H$6000,\">\"&TODAY()),\"booked\",\"Available \"))","v":"Available "},1600]