{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Reservation","CHECK IN","Data","SCERCH"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Reservation","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,5,5,6],[5,9,5,10],[5,7,5,8],[18,1,18,5]]}
[]
[]
[null,null,"Reservation"]
[null,"Date","2020-05-30"]
[null,"Date","2020-06-25"]
[]
[null,"Date","2020-06-25"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Reservation"]
["Room","Start","Days","End","Status","Full Name",null,null,null,null,null,"CHECK IN"]
["Room 13","2020-05-10",{"$f":"IF(OR(B11=\"\",D11=\"\"),\"\",D11-B11)","v":20},"2020-05-30","CHECK IN","Delsie Edwards"]
["Room 21","2020-05-11",20,"2020-05-31","CHECK IN","Mary Mace"]
["Room 5","2020-05-12",20,"2020-06-01","Reservation","Kent Todmanson"]
["Room 7","2020-05-13",20,"2020-06-02","Reservation","Ted Brent"]
["Room 16","2020-06-14",9,"2020-06-23","Reservation","Ted Brent"]
[]
[]
[]
[null,"عند عمل CHECK IN لاى غرفة من القائمة المنسدلة تنتقل الى صفحة CHECK IN"]

{"sheet":"CHECK IN","index":1,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"CHECK IN"]
[]
[]
["Room","Start","Days","End","Status","Full Name"]

{"sheet":"Data","index":2,"n_rows":32,"n_cols":77,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Count"]
[null,{"$f":"MAX(B9:B500)","v":29},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,"Copied range for restoration if overbook",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,"Criteria",null,null,null,"Count",null,"Days overbooked"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Room","Start","End",null,{"$f":"COUNTA(BM9:BM31)","v":0},null,{"$f":"IF(BN10>BN9,BN10-BN9,BO10-BN9+1)","v":1}]
[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,"Criteria for limiting data",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,{"$f":"\"=\" &#REF!","v":{"$error":"#REF!"}},{"$f":"\">=\" &#REF!","v":{"$error":"#REF!"}},{"$f":"\"<=\" &#REF!","v":{"$error":"#REF!"}}]
[null,"ID","Room","Start","Days","End","Status","Cost per day","Deposit","Addition  Cost","Cost","Full Name","Address","Email","Phone ","Licience /Passport","Expenses 1","Descript1","Expenses 2","Descript2","Expenses 3","Descript3","Expenses 4","Descript4","Expenses 5","Descript5",null,null,null,null,null,null,"Start","End","ID","Room","Start","Days","End","Status","Cost per day","Deposit","Addition  Cost","Cost","Full Name","Address","Email","Phone ","Licience /Passport","Expenses 1","Descript1","Expenses 2","Descript2","Expenses 3","Descript3","Expenses 4","Descript4","Expenses 5","Descript5",null,{"$f":"\"=\" &#REF!","v":{"$error":"#REF!"}},{"$f":"\"<=\" &#REF!","v":{"$error":"#REF!"}},{"$f":"\">=\" &#REF!","v":{"$error":"#REF!"}},null,"Room","Start","End","Full Name","check in",null,null,"check Out"]
[null,1,"Room 15","2020-03-31",{"$f":"IF(OR(D9=\"\",F9=\"\"),\"\",F9-D9)","v":10},"2020-04-10","arrival",200,50,null,400,"Meagan Rouch","67 Pook St","meag@mmm.com","2345 2134","rt 565788",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AS9,AK9)","v":"Henry Purcible43832"},{"$f":"\">=\" &#REF! - 14","v":{"$error":"#REF!"}},{"$f":"\"<=\" &#REF! + 14","v":{"$error":"#REF!"}},3,"Room 1","2020-01-02",5,"2020-01-07","Unconfirmed",80,null,0,548,"Henry Purcible","56 Grease St","1234fred@dod.com.ad","2345 6789","1234 5678 45",23,"Drinks",null,null,null,null,null,null,45,"Towels",null,null,null,null,null,null,null,null,null,{"$f":"MONTH(AK9)","v":"1900-01-01"},{"$f":"DAY(AK9)","v":2},{"$f":"YEAR(AK9)","v":2020},{"$f":"MONTH(AM9)","v":1},{"$f":"DAY(AM9)","v":7},{"$f":"YEAR(AM9)","v":2020},"IND","B.B","01-00001"]
[null,2,"Room 25","2020-03-31",{"$f":"IF(OR(D10=\"\",F10=\"\"),\"\",F10-D10)","v":10},"2020-04-10","arrival",80,null,0,320,"Jenny Trerrfer","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AS10,AK10)","v":"Kent Todmanson43833"},null,null,4,"Room 15","2020-01-03",11,"2020-01-14","Paid",150,null,0,1650,"Kent Todmanson","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MONTH(AK10)","v":1},{"$f":"DAY(AK10)","v":3},{"$f":"YEAR(AK10)","v":2020},{"$f":"MONTH(AM10)","v":1},{"$f":"DAY(AM10)","v":14},{"$f":"YEAR(AM11)","v":1900},"IND","B.B","01-00002"]
[null,3,"Room 1","2020-03-31",{"$f":"IF(OR(D11=\"\",F11=\"\"),\"\",F11-D11)","v":10},"2020-04-10","arrival",80,null,0,548,"Henry Purcible","56 Grease St","1234fred@dod.com.ad","2345 6789","1234 5678 45",23,"Drinks",null,null,null,null,null,null,45,"Towels",null,null,null,null,null,{"$f":"CONCATENATE(AS11,AK11)","v":""}]
[null,4,"Room 15","2020-03-31",10,"2020-04-10","arrival",150,null,0,1650,"Kent Todmanson","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,5,"Room 5","2020-03-31",10,"2020-04-10","arrival",150,200,0,1300,"Trex Lawson","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,6,"Room 21","2020-03-31",10,"2020-04-10","arrival",80,null,0,480,"Neal Heart","56 Grease St","1234fred@dod.com.ad","2345 6789","1234 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,7,"Room 3","2020-03-31",10,"2020-04-10","arrival",120,null,0,600,"Delsie Drival","32 Trash Crt","1234fred@dod.com.ad","2346 6789","1235 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,8,"Room 8","2020-03-31",10,"2020-04-10","arrival",300,null,0,1200,"Trevor Westward","3/5 My Village","1234fred@dod.com.ad","2352 6789","1241 5678 45",22,"foods",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,9,"Room 27","2020-03-31",10,"2020-04-10","arrival",150,null,0,300,"Ted Brent","99 Holdering Ct","1234fred@dod.com.ad","2354 6789","1243 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,10,"Room 14","2020-03-31",10,"2020-04-10","arrival",230,null,0,2432,"Ben Y","67 Pretzel Rd","1234fred@dod.com.ad","2351 6789","1240 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,11,"Room 13","2020-03-31",10,"2020-04-10","arrival",200,null,0,711,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,12,"Room 7","2020-03-31",10,"2020-04-10","arrival",180,null,0,1080,"Merry Easton","45 Brentwood St","1234fred@dod.com.ad","2356 6789","1245 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,13,"Room 1","2020-03-31",10,"2020-04-10","arrival",150,null,0,2250,"Denny Bernt","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,14,"Room 23","2020-03-31",10,"2020-04-10","arrival",80,null,0,320,"Jenny Trerrfer","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,18,"Room 11","2020-02-03",9,"2020-02-12","departure",165,null,0,495,"Kentty Beckword","Nally Plaza","1234fred@dod.com.ad","2350 6789","1239 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,21,"Room 5","2020-02-04",9,"2020-02-13","departure",200,null,0,400,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,22,"Room 13","2020-02-05",9,"2020-02-14","departure",200,null,0,400,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,23,"Room 14","2020-02-06",9,"2020-02-15","departure",230,null,0,1150,"Ben Y","67 Pretzel Rd","1234fred@dod.com.ad","2351 6789","1240 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,24,"Room 13","2020-02-07",9,"2020-02-16","departure",200,null,0,545,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,25,"Room 13","2020-05-10",20,"2020-05-30","Reservation",200,null,0,640,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",67,"Towels",8,"Damage",67,"Drinks",8,"Towels",90,"Tokens",null,null,null,null,null,""]
[null,26,"Room 21","2020-05-11",20,"2020-05-31","Reservation",200,200,null,800,"Mary Mace","56 Tre st","Mer@adsfaf.com","341 1414","re234141341",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,27,"Room 5","2020-05-12",20,"2020-06-01","Reservation",150,null,0,1950,"Kent Todmanson","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,28,"Room 7","2020-05-13",20,"2020-06-02","Reservation",230,null,0,920,"Ted Brent","Shop6 Brentdale Shopping Centre","1234fred@dod.com.ad","2355 6789","1244 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,29,"Room 16","2020-06-14",9,"2020-06-23","Reservation",230,null,0,920,"Ted Brent","Shop6 Brentdale Shopping Centre","1234fred@dod.com.ad","2355 6789","1244 5678 45"]

{"sheet":"SCERCH","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,2,17,4]]}
[]
[null,"ROOM NO","Room 15"]
[null,"Date","2020-03-01"]
[null,"Date","2020-06-30"]
[]
[]
["Room","Start","Days","End","Status","Full Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"عمل بحث رقم الغرفة بين تاريخين"]