{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Home","Database","Support","Bookings","Sheet1","Check IN","Receipt","INVOICE","Paymetns"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[3,4,5,14]]}

{"sheet":"Database","index":1,"n_rows":16,"n_cols":25,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["S.NO","R Card NO","Guest Name","Addres","Country","Company","Arrival","Deparue","Days","Adult","Children","Room","Room Type","Meals","ID type","ID Number","Reat P.P","Total Charges","Other Charges","Sub Total","Discount","AmountPad","Balance","status","Notes"]
[{"$f":"ROW()-1","v":1},"01-00001","AAAAAAA","BBBBBBB","Afghanistan","Booking,com","2020-06-01","2020-06-03",2,2,0,"Room 101","Double","H.B","Passport",1111,100,200,0,200,20,120,60,"Check IN","FFFF"]
[{"$f":"ROW()-1","v":2},"01-00002","Alaa Mohamed Mohamed Ali","Egypt","Abkhazia","Booking,com","2020-06-01","2020-06-05",4,1,0,"Room 102","Single","B.B","ID",123,100,400,0,400,30,200,170,"Check IN","."]
[{"$f":"ROW()-1","v":3},"01-00003","Ali ahmed Ali","Egypt","Aruba","Booking,com","2020-06-23","2020-06-26",3,1,0," 116 Deluxe Room","Single","Bed & Brakfast","Passport",8888,100,300,20,320,120,50,{"$f":"T4-(U4+V4)","v":150},"Check IN","......"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Support","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Room","Meals","status","Room Type","Country","Combany","ID Type"]
[" 101 Standard Room","B.O","Reservation","Single","Abkhazia","Booking,com","ID"]
[" 102 Standard Room","Bed & Brakfast","Check IN","Double","Afghanistan",null,"Passport"]
[" 103 Standard Room","H.B","Check OUT",null,"Akrotiri",null,"Driver License"]
[" 104 Standard Room","F.B",null,null,"Aland"]
[" 105 Standard Room","ALL SOFT",null,null,"Albania"]
[" 106 Standard Room","ALL HARD",null,null,"Algeria"]
[" 107 Standard Room",null,null,null,"American Samoa"]
[" 108 Standard Room",null,null,null,"Andorra"]
[" 109 Standard Room",null,null,null,"Angola"]
[" 110 Standard Room",null,null,null,"Anguilla"]
[" 111 Deluxe Room",null,null,null,"Antigua and Barbuda"]
[" 112 Deluxe Room",null,null,null,"Argentina"]
[" 114 Deluxe Room",null,null,null,"Armenia"]
[" 115 Deluxe Room",null,null,null,"Aruba"]
[" 116 Deluxe Room",null,null,null,"Ascension Island"]
[" 117 Deluxe Room",null,null,null,"Australia"]
[null,null,null,null,"Austria"]
[null,null,null,null,"Azerbaijan"]
[null,null,null,null,"Bahamas, The"]
[null,null,null,null,"Bahrain"]
[null,null,null,null,"Bangladesh"]
[null,null,null,null,"Barbados"]
[null,null,null,null,"Belarus"]
[null,null,null,null,"Belgium"]
[null,null,null,null,"Belize"]
[null,null,null,null,"Benin "]
[null,null,null,null,"Bermuda"]
[null,null,null,null,"Bhutan"]
[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":"Bookings","index":3,"n_rows":40,"n_cols":60,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,21,0,35],[0,40,0,54],[1,8,1,15],[1,17,1,24],[1,26,1,33],[1,35,1,45],[2,55,2,58],[3,12,3,15],[3,17,3,20],[3,21,3,24],[3,26,3,29],[3,30,3,33],[2,7,2,9],[2,12,2,15],[2,17,2,20],[2,21,2,24],[2,26,2,29],[2,30,2,33],[4,7,4,9],[4,12,4,15],[4,17,4,20],[4,21,4,24],[4,26,4,29],[2,35,2,38],[2,39,2,45],[2,47,2,50],[2,51,2,54],[4,30,4,33],[4,35,4,38],[4,39,4,45],[4,47,4,50],[4,51,4,54],[4,55,4,58],[3,35,3,38],[3,39,3,45],[3,47,3,50],[3,51,3,54],[3,55,3,58],[6,55,6,58],[8,2,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[5,39,5,45],[5,47,5,50],[5,51,5,54],[5,55,5,58],[6,7,6,9],[6,17,6,20],[6,21,6,24],[6,26,6,29],[6,30,6,33],[6,35,6,38],[5,12,5,15],[5,17,5,20],[5,21,5,24],[5,26,5,29],[5,30,5,33],[5,35,5,38],[8,14,8,15],[8,16,8,17],[8,18,8,19],[8,20,8,21],[8,22,8,23],[8,24,8,25],[6,39,6,45],[6,47,6,50],[6,51,6,54],[9,20,9,21],[9,22,9,23],[8,50,8,51],[8,52,8,53],[8,54,8,55],[8,56,8,57],[8,58,8,59],[9,2,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[8,38,8,39],[8,40,8,41],[8,42,8,43],[8,44,8,45],[8,46,8,47],[8,48,8,49],[8,26,8,27],[8,28,8,29],[8,30,8,31],[8,32,8,33],[8,34,8,35],[8,36,8,37],[10,2,10,3],[11,2,11,3],[9,48,9,49],[9,50,9,51],[9,52,9,53],[9,54,9,55],[9,56,9,57],[9,58,9,59],[9,36,9,37],[9,38,9,39],[9,40,9,41],[9,42,9,43],[9,44,9,45],[9,46,9,47],[9,24,9,25],[9,26,9,27],[9,28,9,29],[9,30,9,31],[9,32,9,33],[9,34,9,35],[9,12,9,13],[9,14,9,15],[9,16,9,17],[9,18,9,19]]}
[]
[null,null,null,null,null,null,null,null,"Dates",null,null,null,null,null,null,null,null,"                            Room Details",null,null,null,null,null,null,null,null,"                Costing",null,null,null,null,null,null,null,null,"        Contact Details",null,null,null,null,null,null,null,null,null,null,null,"Additional Expenses",null,null,null,null,"Amount",null,null,"Description"]
[null,null,null,null,null,null,"ID",null,null,null,"ID",null,{"$f":"1 & \"/\" &M5 &\"/\"& M6","v":"1/7/2017"},null,null,null,null,"Room",null,null,null,"Room 6",null,null,null,null,"Day Cost",null,null,null,null,null,null,null,null,"Full Name",null,null,null,null,null,null,null,null,null,null,null,"Expense 1"]
[null,null,null,null,null,null,null,"Monday Date",null,null,null,null,"July",null,null,null,null,"Arrival",null,null,null,"2015-01-12",null,null,null,null,"Deposit",null,null,null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,"Expense 2"]
[null,null,null,null,null,null,null,"2017-01-02",null,null,null,null,{"$f":"VLOOKUP(M4,[1]Lists!H7:I18,2,0)","v":7},null,null,null,null,"Days",null,null,null,10,null,null,null,null,"Additional Cost",null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,"Expense 3"]
[null,null,null,null,null,null,null,"Date Select",null,null,null,null,2017,null,null,null,null,"End",null,null,null,{"$f":"IF(V4=\"\",\"\",(V4+V5)-1)","v":"2015-01-21"},null,null,null,"*","Expenses",null,null,null,{"$f":"SUM(AZ3:BC7)","v":0},null,null,null,"*","Phone",null,null,null,null,null,null,null,null,null,null,null,"Expense 4"]
[null,null,null,null,null,null,null,{"$f":"StDate+K7","v":"2017-01-07"},null,null,null,null,null,null,null,null,null,"Status",null,null,null,"Confirmed",null,null,null,null,"Total",null,null,null,{"$f":"(AE3*V5)+(AE5+AE6)-AE4","v":0},null,null,null,"*","Licience",null,null,null,null,null,null,null,null,null,null,null,"Expense 5"]
[]
[null,null,"Unconfirmed",null,{"$f":"E12+1","v":"2017-01-03"},null,{"$f":"G12+1","v":"2017-01-04"},null,{"$f":"I12+1","v":"2017-01-05"},null,{"$f":"K12+1","v":"2017-01-06"},null,{"$f":"M12+1","v":"2017-01-07"},null,{"$f":"O12+1","v":"2017-01-08"},null,{"$f":"Q12+1","v":"2017-01-09"},null,{"$f":"S12+1","v":"2017-01-10"},null,{"$f":"U12+1","v":"2017-01-11"},null,{"$f":"W12+1","v":"2017-01-12"},null,{"$f":"Y12+1","v":"2017-01-13"},null,{"$f":"AA12+1","v":"2017-01-14"},null,{"$f":"AC12+1","v":"2017-01-15"},null,{"$f":"AE12+1","v":"2017-01-16"},null,{"$f":"AG12+1","v":"2017-01-17"},null,{"$f":"AI12+1","v":"2017-01-18"},null,{"$f":"AK12+1","v":"2017-01-19"},null,{"$f":"AM12+1","v":"2017-01-20"},null,{"$f":"AO12+1","v":"2017-01-21"},null,{"$f":"AQ12+1","v":"2017-01-22"},null,{"$f":"AS12+1","v":"2017-01-23"},null,{"$f":"AU12+1","v":"2017-01-24"},null,{"$f":"AW12+1","v":"2017-01-25"},null,{"$f":"AY12+1","v":"2017-01-26"},null,{"$f":"BA12+1","v":"2017-01-27"},null,{"$f":"BC12+1","v":"2017-01-28"},null,{"$f":"BE12+1","v":"2017-01-29"},null,{"$f":"BG12+1","v":"2017-01-30"}]
[null,null,"Confirmed",null,{"$f":"E12","v":"2017-01-02"},null,{"$f":"G12","v":"2017-01-03"},null,{"$f":"I12","v":"2017-01-04"},null,{"$f":"K12","v":"2017-01-05"},null,{"$f":"M12","v":"2017-01-06"},null,{"$f":"O12","v":"2017-01-07"},null,{"$f":"Q12","v":"2017-01-08"},null,{"$f":"S12","v":"2017-01-09"},null,{"$f":"U12","v":"2017-01-10"},null,{"$f":"W12","v":"2017-01-11"},null,{"$f":"Y12","v":"2017-01-12"},null,{"$f":"AA12","v":"2017-01-13"},null,{"$f":"AC12","v":"2017-01-14"},null,{"$f":"AE12","v":"2017-01-15"},null,{"$f":"AG12","v":"2017-01-16"},null,{"$f":"AI12","v":"2017-01-17"},null,{"$f":"AK12","v":"2017-01-18"},null,{"$f":"AM12","v":"2017-01-19"},null,{"$f":"AO12","v":"2017-01-20"},null,{"$f":"AQ12","v":"2017-01-21"},null,{"$f":"AS12","v":"2017-01-22"},null,{"$f":"AU12","v":"2017-01-23"},null,{"$f":"AW12","v":"2017-01-24"},null,{"$f":"AY12","v":"2017-01-25"},null,{"$f":"BA12","v":"2017-01-26"},null,{"$f":"BC12","v":"2017-01-27"},null,{"$f":"BE12","v":"2017-01-28"},null,{"$f":"BG12","v":"2017-01-29"}]
[null,null,"Cancelled",null,"Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After","Morn","After"]
[null,null,"Paid",null,{"$f":"H7-(IF(WEEKDAY(H7)=1,6,WEEKDAY(H7)-2))","v":"2017-01-02"},{"$f":"E12","v":"2017-01-02"},{"$f":"F12+1","v":"2017-01-03"},{"$f":"G12","v":"2017-01-03"},{"$f":"H12+1","v":"2017-01-04"},{"$f":"I12","v":"2017-01-04"},{"$f":"J12+1","v":"2017-01-05"},{"$f":"K12","v":"2017-01-05"},{"$f":"L12+1","v":"2017-01-06"},{"$f":"M12","v":"2017-01-06"},{"$f":"N12+1","v":"2017-01-07"},{"$f":"O12","v":"2017-01-07"},{"$f":"P12+1","v":"2017-01-08"},{"$f":"Q12","v":"2017-01-08"},{"$f":"R12+1","v":"2017-01-09"},{"$f":"S12","v":"2017-01-09"},{"$f":"T12+1","v":"2017-01-10"},{"$f":"U12","v":"2017-01-10"},{"$f":"V12+1","v":"2017-01-11"},{"$f":"W12","v":"2017-01-11"},{"$f":"X12+1","v":"2017-01-12"},{"$f":"Y12","v":"2017-01-12"},{"$f":"Z12+1","v":"2017-01-13"},{"$f":"AA12","v":"2017-01-13"},{"$f":"AB12+1","v":"2017-01-14"},{"$f":"AC12","v":"2017-01-14"},{"$f":"AD12+1","v":"2017-01-15"},{"$f":"AE12","v":"2017-01-15"},{"$f":"AF12+1","v":"2017-01-16"},{"$f":"AG12","v":"2017-01-16"},{"$f":"AH12+1","v":"2017-01-17"},{"$f":"AI12","v":"2017-01-17"},{"$f":"AJ12+1","v":"2017-01-18"},{"$f":"AK12","v":"2017-01-18"},{"$f":"AL12+1","v":"2017-01-19"},{"$f":"AM12","v":"2017-01-19"},{"$f":"AN12+1","v":"2017-01-20"},{"$f":"AO12","v":"2017-01-20"},{"$f":"AP12+1","v":"2017-01-21"},{"$f":"AQ12","v":"2017-01-21"},{"$f":"AR12+1","v":"2017-01-22"},{"$f":"AS12","v":"2017-01-22"},{"$f":"AT12+1","v":"2017-01-23"},{"$f":"AU12","v":"2017-01-23"},{"$f":"AV12+1","v":"2017-01-24"},{"$f":"AW12","v":"2017-01-24"},{"$f":"AX12+1","v":"2017-01-25"},{"$f":"AY12","v":"2017-01-25"},{"$f":"AZ12+1","v":"2017-01-26"},{"$f":"BA12","v":"2017-01-26"},{"$f":"BB12+1","v":"2017-01-27"},{"$f":"BC12","v":"2017-01-27"},{"$f":"BD12+1","v":"2017-01-28"},{"$f":"BE12","v":"2017-01-28"},{"$f":"BF12+1","v":"2017-01-29"},{"$f":"BG12","v":"2017-01-29"}]
[null,null,{"$f":"IF([1]Lists!K7=\"\",\"\",[1]Lists!K7)","v":"Room 1"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K8=\"\",\"\",[1]Lists!K8)","v":"Room 2"},"4 Beds"]
[null,null,{"$f":"IF([1]Lists!K9=\"\",\"\",[1]Lists!K9)","v":"Room 3"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K10=\"\",\"\",[1]Lists!K10)","v":"Room 4"},"3 Beds"]
[null,null,{"$f":"IF([1]Lists!K11=\"\",\"\",[1]Lists!K11)","v":"Room 5"},"4 Beds"]
[null,null,{"$f":"IF([1]Lists!K12=\"\",\"\",[1]Lists!K12)","v":"Room 6"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K13=\"\",\"\",[1]Lists!K13)","v":"Room 7"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K14=\"\",\"\",[1]Lists!K14)","v":"Room 8"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K15=\"\",\"\",[1]Lists!K15)","v":"Room 9"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K16=\"\",\"\",[1]Lists!K16)","v":"Room 10"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K17=\"\",\"\",[1]Lists!K17)","v":"Room 11"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K18=\"\",\"\",[1]Lists!K18)","v":"Room 12"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K19=\"\",\"\",[1]Lists!K19)","v":"Room 13"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K20=\"\",\"\",[1]Lists!K20)","v":"Room 14"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K21=\"\",\"\",[1]Lists!K21)","v":"Room 15"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K22=\"\",\"\",[1]Lists!K22)","v":"Room 16"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K23=\"\",\"\",[1]Lists!K23)","v":"Room 17"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K24=\"\",\"\",[1]Lists!K24)","v":"Room 18"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K25=\"\",\"\",[1]Lists!K25)","v":"Room 19"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K26=\"\",\"\",[1]Lists!K26)","v":"Room 20"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K27=\"\",\"\",[1]Lists!K27)","v":"Room 21"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K28=\"\",\"\",[1]Lists!K28)","v":"Room 22"},"3 Beds"]
[null,null,{"$f":"IF([1]Lists!K29=\"\",\"\",[1]Lists!K29)","v":"Room 23"},"4 Beds"]
[null,null,{"$f":"IF([1]Lists!K30=\"\",\"\",[1]Lists!K30)","v":"Room 24"},"5 Beds"]
[null,null,{"$f":"IF([1]Lists!K31=\"\",\"\",[1]Lists!K31)","v":"Room 25"},"2 Beds"]
[null,null,{"$f":"IF([1]Lists!K32=\"\",\"\",[1]Lists!K32)","v":"Room 26"},"3 Beds"]
[null,null,{"$f":"IF([1]Lists!K33=\"\",\"\",[1]Lists!K33)","v":"Room 27"},"4 Beds"]
[null,null,{"$f":"IF([1]Lists!K34=\"\",\"\",[1]Lists!K34)","v":"Room 28"},"2 Beds"]

{"sheet":"Sheet1","index":4,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Room 101","2 Beds","Single","No Booking",{"$f":"IF(OR(C6=\"\",E6=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C6, Database!$O$2:$O$6000,E6, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 102","4 Beds","Single"," Booking",{"$f":"IF(OR(C7=\"\",E7=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C7, Database!$O$2:$O$6000,E7, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 103","2 Beds","Single"," Booking",{"$f":"IF(OR(C8=\"\",E8=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C8, Database!$O$2:$O$6000,E8, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 104","3 Beds","Single",null,{"$f":"IF(OR(C9=\"\",E9=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C9, Database!$O$2:$O$6000,E9, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 105","4 Beds","Single",null,{"$f":"IF(OR(C10=\"\",E10=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C10, Database!$O$2:$O$6000,E10, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 106","2 Beds","Single",null,{"$f":"IF(OR(C11=\"\",E11=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C11, Database!$O$2:$O$6000,E11, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 107","2 Beds","Single",null,{"$f":"IF(OR(C12=\"\",E12=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C12, Database!$O$2:$O$6000,E12, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 108","2 Beds","Single",null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C13, Database!$O$2:$O$6000,E13, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 109","2 Beds","Single",null,{"$f":"IF(OR(C14=\"\",E14=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C14, Database!$O$2:$O$6000,E14, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 110","2 Beds","Single",null,{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C15, Database!$O$2:$O$6000,E15, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 111","2 Beds","Double",null,{"$f":"IF(OR(C16=\"\",E16=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C16, Database!$O$2:$O$6000,E16, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 112","2 Beds","Double",null,{"$f":"IF(OR(C17=\"\",E17=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C17, Database!$O$2:$O$6000,E17, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 114","2 Beds","Double",null,{"$f":"IF(OR(C18=\"\",E18=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C18, Database!$O$2:$O$6000,E18, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 115","2 Beds","Double",null,{"$f":"IF(OR(C19=\"\",E19=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C19, Database!$O$2:$O$6000,E19, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 116","2 Beds","Double",null,{"$f":"IF(OR(C20=\"\",E20=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C20, Database!$O$2:$O$6000,E20, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 117","2 Beds","Double",null,{"$f":"IF(OR(C21=\"\",E21=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C21, Database!$O$2:$O$6000,E21, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 118","2 Beds","Double",null,{"$f":"IF(OR(C22=\"\",E22=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C22, Database!$O$2:$O$6000,E22, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 119","2 Beds","Double",null,{"$f":"IF(OR(C23=\"\",E23=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C23, Database!$O$2:$O$6000,E23, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 120","2 Beds","Double",null,{"$f":"IF(OR(C24=\"\",E24=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C24, Database!$O$2:$O$6000,E24, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 121","2 Beds","Double",null,{"$f":"IF(OR(C25=\"\",E25=\"\"),\"\",IF(COUNTIFS( Database!$L$2:$L$6000,C25, Database!$O$2:$O$6000,E25, Database!$G$2:$G$6000, \"<=\"&TODAY(), Database!$H$2:$H$6000, \">=\"&TODAY()),\"booking\",\"no booking \"))","v":"no booking "}]
[null,null,"Room 122","2 Beds","Double"]
[null,null,"Room 123","3 Beds","Double"]
[null,null,"Room 124","4 Beds","Double"]
[null,null,"Room 125","5 Beds","Double"]
[null,null,"Room 126","2 Beds","Double"]
[null,null,"Room 127","3 Beds","Double"]
[null,null,"Room 128","4 Beds","Double"]
[null,null,"Room 129","2 Beds","Double"]
[null,null,"Room 130","3 Beds","Double"]

{"sheet":"Check IN","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Receipt","index":6,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,3,11,11],[7,4,7,6],[8,5,8,6],[8,7,8,8],[8,9,8,11],[9,9,9,11],[10,9,10,11]]}
[1]
[]
[]
[]
[]
[]
[null,null,null,"Receipt for Guests"]
[]
[null,null,null,"I received I (we) (s) Sr (s)",null,{"$f":"INDEX(Database!A2:Z100,A1,3)","v":"AAAAAAA"},null,"the amount ",null,{"$f":"INDEX(Database!A2:Z100,A1,22)","v":120}]
[null,null,null,"regarding the hosting of the day",null,{"$f":"INDEX(Database!A2:Z100,A1,7)","v":"2020-06-01"},"per day",{"$f":"INDEX(Database!A2:Z100,A1,8)","v":"2020-06-03"},"in the bedroom",{"$f":"INDEX(Database!A2:Z100,A1,12)","v":"Room 101"}]
[null,null,null,"Specification: daily rates",null,{"$f":"INDEX(Database!A2:Z100,A1,17)","v":100},"Payment type",null,"and spending",68]
[null,null,null,"with revenues expected for the company x"]
[]
[]
[null,null,null,"Date",null,null,null,"signature"]

{"sheet":"INVOICE","index":7,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,1,38,2],[38,7,38,8],[9,2,9,3],[10,2,10,4],[11,2,11,3],[12,2,12,3],[32,1,34,5],[37,7,37,8]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,"Hotel Bill",null,null,null,null,null,null,null,{"$f":"IF(C4=\"\",\"vazio\",CONCATENATE(C4,G4))","v":"vazio"}]
[null,"BELL TO"]
[null,"NAME    :","Ali ahmed Ali"]
[null,"COMPANY  ","Booking,com",null,null,null,null,"DATE          :",{"$f":"TODAY()","v":"2020-06-24"}]
[null,"Adress","Egypt",null,null,null,null,"INVOICE     : ","01-00003"]
[]
[null,null,null,null,"ROOM "," 116 Deluxe Room"]
[null,"CHECK IN","CHECK OUT","Night","RoomType","No.Of.Pax","MEALS","Rate P.P","AMOUNT"]
[null,"2020-06-23","2020-06-26",0,"Single",1,"Bed & Brakfast",100,300]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"SUB TOTAL",{"$f":"+I17","v":300}]
[null,null,null,null,null,null,null,"Exstra",20]
[null," Nots :-",null,null,null,null,null,"TOTAL",{"$f":"+I31+I32","v":320}]
[null,null,null,null,null,null,null,"Discount",120]
[null,null,null,null,null,null,null,"AmountPIad",50]
[null,null,null,null,null,null,null,"Balance",150]
[]
[]
[null,"GUEST SIGN",null,null,null,null,null,"ACC SIGN"]

{"sheet":"Paymetns","index":8,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Date","Payments Type","Card Number","Batch NO","Amount"]