{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Bookings","Home","Database","Support","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Bookings","index":0,"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/6/2020"},null,null,null,null,"Room",null,null,null,null,null,null,null,null,"Reat P.P",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,"June",null,null,null,null,"Arrival",null,null,null,null,null,null,null,null,"Total Charges",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,{"$f":"E12","v":"2020-06-08"},null,null,null,null,{"$f":"VLOOKUP(M4,Support!M2:N13,2,0)","v":6},null,null,null,"*","Days",null,null,null,null,null,null,null,null,"Sub Total",null,null,null,null,null,null,null,null,"Country",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,2020,null,null,null,null,"End",null,null,null,{"$f":"IF(V4=\"\",\"\",(V4+V5)-1)","v":""},null,null,null,"*","Other Charges",null,null,null,{"$f":"SUM(AZ3:BC7)","v":0},null,null,null,"*","Company",null,null,null,null,null,null,null,null,null,null,null,"Expense 4"]
[null,null,null,null,null,null,null,{"$f":"StDate+K7","v":"2020-06-08"},null,null,7,null,null,null,null,null,null,"Status",null,null,null,null,null,null,null,null,"AmountPaid",null,null,null,{"$f":"(AE3*V5)+(AE5+AE6)-AE4","v":0},null,null,null,"*","Meals",null,null,null,null,null,null,null,null,null,null,null,"Expense 5"]
[]
[null,null,"Unconfirmed",null,{"$f":"E12:F12","v":"2020-06-08"},null,{"$f":"G12:H12","v":"2020-06-09"},null,{"$f":"I12:J12","v":"2020-06-10"},null,{"$f":"K12:L12","v":"2020-06-11"},null,{"$f":"M12:N12","v":"2020-06-12"},null,{"$f":"O12:P12","v":"2020-06-13"},null,{"$f":"Q12:R12","v":"2020-06-14"},null,{"$f":"S12:T12","v":"2020-06-15"},null,{"$f":"U12:V12","v":"2020-06-16"},null,{"$f":"W12:X12","v":"2020-06-17"},null,{"$f":"Y12:Z12","v":"2020-06-18"},null,{"$f":"AA12:AB12","v":"2020-06-19"},null,{"$f":"AC12:AD12","v":"2020-06-20"},null,{"$f":"AE12:AF12","v":"2020-06-21"},null,{"$f":"AG12:AH12","v":"2020-06-22"},null,{"$f":"AI12:AJ12","v":"2020-06-23"},null,{"$f":"AK12:AL12","v":"2020-06-24"},null,{"$f":"AM12:AN12","v":"2020-06-25"},null,{"$f":"AO12:AP12","v":"2020-06-26"},null,{"$f":"AQ12:AR12","v":"2020-06-27"},null,{"$f":"AS12:AT12","v":"2020-06-28"},null,{"$f":"AU12:AV12","v":"2020-06-29"},null,{"$f":"AW12:AX12","v":"2020-06-30"},null,{"$f":"AY12:AZ12","v":"2020-07-01"},null,{"$f":"BA12:BB12","v":"2020-07-02"},null,{"$f":"BC12:BD12","v":"2020-07-03"},null,{"$f":"BE12:BF12","v":"2020-07-04"},null,{"$f":"BG12:BH12","v":"2020-07-05"}]
[null,null,"Confirmed",null,{"$f":"E12","v":"2020-06-08"},null,{"$f":"G12","v":"2020-06-09"},null,{"$f":"I12","v":"2020-06-10"},null,{"$f":"K12","v":"2020-06-11"},null,{"$f":"M12","v":"2020-06-12"},null,{"$f":"O12","v":"2020-06-13"},null,{"$f":"Q12","v":"2020-06-14"},null,{"$f":"S12","v":"2020-06-15"},null,{"$f":"U12","v":"2020-06-16"},null,{"$f":"W12","v":"2020-06-17"},null,{"$f":"Y12","v":"2020-06-18"},null,{"$f":"AA12","v":"2020-06-19"},null,{"$f":"AC12","v":"2020-06-20"},null,{"$f":"AE12","v":"2020-06-21"},null,{"$f":"AG12","v":"2020-06-22"},null,{"$f":"AI12","v":"2020-06-23"},null,{"$f":"AK12","v":"2020-06-24"},null,{"$f":"AM12","v":"2020-06-25"},null,{"$f":"AO12","v":"2020-06-26"},null,{"$f":"AQ12","v":"2020-06-27"},null,{"$f":"AS12","v":"2020-06-28"},null,{"$f":"AU12","v":"2020-06-29"},null,{"$f":"AW12","v":"2020-06-30"},null,{"$f":"AY12","v":"2020-07-01"},null,{"$f":"BA12","v":"2020-07-02"},null,{"$f":"BC12","v":"2020-07-03"},null,{"$f":"BE12","v":"2020-07-04"},null,{"$f":"BG12","v":"2020-07-05"}]
[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","v":"2020-06-08"},{"$f":"E12","v":"2020-06-08"},{"$f":"F12+1","v":"2020-06-09"},{"$f":"G12","v":"2020-06-09"},{"$f":"H12+1","v":"2020-06-10"},{"$f":"I12","v":"2020-06-10"},{"$f":"J12+1","v":"2020-06-11"},{"$f":"K12","v":"2020-06-11"},{"$f":"L12+1","v":"2020-06-12"},{"$f":"M12","v":"2020-06-12"},{"$f":"N12+1","v":"2020-06-13"},{"$f":"O12","v":"2020-06-13"},{"$f":"P12+1","v":"2020-06-14"},{"$f":"Q12","v":"2020-06-14"},{"$f":"R12+1","v":"2020-06-15"},{"$f":"S12","v":"2020-06-15"},{"$f":"T12+1","v":"2020-06-16"},{"$f":"U12","v":"2020-06-16"},{"$f":"V12+1","v":"2020-06-17"},{"$f":"W12","v":"2020-06-17"},{"$f":"X12+1","v":"2020-06-18"},{"$f":"Y12","v":"2020-06-18"},{"$f":"Z12+1","v":"2020-06-19"},{"$f":"AA12","v":"2020-06-19"},{"$f":"AB12+1","v":"2020-06-20"},{"$f":"AC12","v":"2020-06-20"},{"$f":"AD12+1","v":"2020-06-21"},{"$f":"AE12","v":"2020-06-21"},{"$f":"AF12+1","v":"2020-06-22"},{"$f":"AG12","v":"2020-06-22"},{"$f":"AH12+1","v":"2020-06-23"},{"$f":"AI12","v":"2020-06-23"},{"$f":"AJ12+1","v":"2020-06-24"},{"$f":"AK12","v":"2020-06-24"},{"$f":"AL12+1","v":"2020-06-25"},{"$f":"AM12","v":"2020-06-25"},{"$f":"AN12+1","v":"2020-06-26"},{"$f":"AO12","v":"2020-06-26"},{"$f":"AP12+1","v":"2020-06-27"},{"$f":"AQ12","v":"2020-06-27"},{"$f":"AR12+1","v":"2020-06-28"},{"$f":"AS12","v":"2020-06-28"},{"$f":"AT12+1","v":"2020-06-29"},{"$f":"AU12","v":"2020-06-29"},{"$f":"AV12+1","v":"2020-06-30"},{"$f":"AW12","v":"2020-06-30"},{"$f":"AX12+1","v":"2020-07-01"},{"$f":"AY12","v":"2020-07-01"},{"$f":"AZ12+1","v":"2020-07-02"},{"$f":"BA12","v":"2020-07-02"},{"$f":"BB12+1","v":"2020-07-03"},{"$f":"BC12","v":"2020-07-03"},{"$f":"BD12+1","v":"2020-07-04"},{"$f":"BE12","v":"2020-07-04"},{"$f":"BF12+1","v":"2020-07-05"},{"$f":"BG12","v":"2020-07-05"}]
[null,null,{"$f":"IF(Support!P2=\"\",\"\",Support!P2)","v":"Room 101"},"2 Beds"]
[null,null,{"$f":"IF(Support!P3=\"\",\"\",Support!P3)","v":"Room 102"},"4 Beds"]
[null,null,{"$f":"IF(Support!P4=\"\",\"\",Support!P4)","v":"Room 103"},"2 Beds"]
[null,null,{"$f":"IF(Support!P5=\"\",\"\",Support!P5)","v":"Room 104"},"3 Beds"]
[null,null,{"$f":"IF(Support!P6=\"\",\"\",Support!P6)","v":"Room 105"},"4 Beds"]
[null,null,{"$f":"IF(Support!P7=\"\",\"\",Support!P7)","v":"Room 106"},"2 Beds"]
[null,null,{"$f":"IF(Support!P8=\"\",\"\",Support!P8)","v":"Room 107"},"2 Beds"]
[null,null,{"$f":"IF(Support!P9=\"\",\"\",Support!P9)","v":"Room 108"},"2 Beds"]
[null,null,{"$f":"IF(Support!P10=\"\",\"\",Support!P10)","v":"Room 109"},"2 Beds"]
[null,null,{"$f":"IF(Support!P11=\"\",\"\",Support!P11)","v":"Room 110"},"2 Beds"]
[null,null,{"$f":"IF(Support!P12=\"\",\"\",Support!P12)","v":"Room 111"},"2 Beds"]
[null,null,{"$f":"IF(Support!P13=\"\",\"\",Support!P13)","v":"Room 112"},"2 Beds"]
[null,null,{"$f":"IF(Support!P14=\"\",\"\",Support!P14)","v":"Room 114"},"2 Beds"]
[null,null,{"$f":"IF(Support!P15=\"\",\"\",Support!P15)","v":"Room 115"},"2 Beds"]
[null,null,{"$f":"IF(Support!P16=\"\",\"\",Support!P16)","v":"Room 116"},"2 Beds"]
[null,null,{"$f":"IF(Support!P17=\"\",\"\",Support!P17)","v":"Room 117"},"2 Beds"]
[null,null,{"$f":"IF(Support!P18=\"\",\"\",Support!P18)","v":"Room 118"},"2 Beds"]
[null,null,{"$f":"IF(Support!P19=\"\",\"\",Support!P19)","v":"Room 119"},"2 Beds"]
[null,null,{"$f":"IF(Support!P20=\"\",\"\",Support!P20)","v":"Room 120"},"2 Beds"]
[null,null,{"$f":"IF(Support!P21=\"\",\"\",Support!P21)","v":"Room 121"},"2 Beds"]
[null,null,{"$f":"IF(Support!P22=\"\",\"\",Support!P22)","v":"Room 122"},"2 Beds"]
[null,null,{"$f":"IF(Support!P23=\"\",\"\",Support!P23)","v":"Room 123"},"3 Beds"]
[null,null,{"$f":"IF(Support!P24=\"\",\"\",Support!P24)","v":"Room 124"},"4 Beds"]
[null,null,{"$f":"IF(Support!P25=\"\",\"\",Support!P25)","v":"Room 125"},"5 Beds"]
[null,null,{"$f":"IF(Support!P26=\"\",\"\",Support!P26)","v":"Room 126"},"2 Beds"]
[null,null,{"$f":"IF(Support!P27=\"\",\"\",Support!P27)","v":"Room 127"},"3 Beds"]
[null,null,{"$f":"IF(Support!P28=\"\",\"\",Support!P28)","v":"Room 128"},"4 Beds"]
[null,null,{"$f":"IF(Support!P29=\"\",\"\",Support!P29)","v":"Room 129"},"2 Beds"]

{"sheet":"Home","index":1,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":true,"merged":[[3,4,5,14]]}
[]
[]
[]
[null,null,null,null,"Room Booking Form"]

{"sheet":"Database","index":2,"n_rows":5,"n_cols":32,"rows_kept":5,"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","AmountPaid","Balance","status","Desc1","Amount1","Desc2","Amount2","Desc3","Amount3","Desc4","Amount4"]
[{"$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","Passport",123,100,{"$f":"Q2*I2","v":200},10,210,0,200,10,"Check IN",null,null,"Towels",10,"Damage",10]
[{"$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","Passport",123456,100,300,100,400,100,200,100,"Check IN"]
[{"$f":"ROW()-1","v":3},"01-00004","Ahmed Ali","Egypt","Belize","Booking,com","2020-06-25","2020-06-27",2,1,2,"Room 114","Double","Bed & Brakfast","ID",1234,100,200,100,300,50,250,0,"Check IN"]
[null,"01-00005","adadad","sss","sss","sss","2020-06-28","2020-07-01"]

{"sheet":"Support","index":3,"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":"Sheet2","index":4,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,-119]

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