{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Germo","Avalible","Travel Band","Fujy","Tomy Tour","Sun International","Golden Valley","E.H.T","Out Boon","Alpah Travel","Gomaa Abbas","4 Season","Air Link","Sheet1","Sheet2","Sheet3","print"],"not_rendered":{"charts":0,"images":2,"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":"Germo","index":0,"n_rows":13,"n_cols":22,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount",null,null,null,null,"Germo","Single",0.15]
["Germo","Famliy","2019-04-15","2019-04-20",5,1,100,1500,0.15,1275,{"$f":"SUM(J2:J1000)","v":17552.5},{"$f":"SUM(F2:F1000)","v":17},null,"2019-04-22",10000,null,null,null,null,"Avalible","Double",0.1]
["Germo","Famliy","2019-04-20","2019-04-24",4,1,100,1200,0.15,1020,{"$f":"SUM(O2:O10000)","v":10000},null,null,null,null,null,null,null,null,"Travel Band","Famliy","No Commission"]
["Germo","Famliy","2019-04-20","2019-04-25",5,4,100,6000,0.15,5100,null,null,null,null,null,null,null,null,null,"Fujy","Triple"]
["Germo","Single","2019-04-20","2019-04-25",5,1,100,750,0.15,637.5,null,null,null,null,null,null,null,null,null,"Tomy Tour","Jouner Swiet"]
["Germo","Single","2019-04-23","2019-04-30",7,8,100,8400,0.15,7140,null,null,null,null,null,null,null,null,null,"Sun International","Royal Swiet"]
["Germo","Double","2019-04-23","2019-04-30",7,2,100,2800,0.15,2380,null,null,null,null,null,null,null,null,null,"Golden Valley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.H.T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Out boon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alpah Travel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gomaa Abbas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 Season"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Link"]

{"sheet":"Avalible","index":1,"n_rows":4,"n_cols":21,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount",null,null,null,null,null,"2019-04-16"]
["Avalible","Triple","2019-04-24","2019-04-29",5,1,100,1470,0.15,1249.5,{"$f":"SUM(J2:J1000)","v":4199},{"$f":"SUM(F2:F1000)","v":4},null,"2019-05-01",500,null,null,null,null,null,"2019-04-20"]
["Avalible","Double","2019-04-24","2019-04-29",5,2,100,2000,0.15,1700,{"$f":"SUM(O2:O10000)","v":500}]
["Avalible","Triple","2019-04-24","2019-04-29",5,1,100,1470,0.15,1249.5]

{"sheet":"Travel Band","index":2,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
["Travel Band","Double","2019-04-15","2019-04-19",4,1,100,800,0.15,680,{"$f":"SUM(J2:J1000)","v":19550},{"$f":"SUM(F2:F1000)","v":22},null,"2019-05-01",500]
["Travel Band","Famliy","2019-04-20","2019-04-26",6,2,100,3600,0.15,3060,{"$f":"SUM(O2:O10000)","v":2500},null,null,"2019-04-25",2000]
["Travel Band","Double","2019-04-22","2019-04-27",5,2,100,2000,0.15,1700]
["Travel Band","Double","2019-04-22","2019-04-28",6,2,100,2400,0.15,2040]
["Travel Band","Single","2019-04-22","2019-04-28",6,2,100,1800,0.15,1530]
["Travel Band","Double","2019-04-23","2019-04-27",4,3,100,2400,0.15,2040]
["Travel Band","Double","2019-04-25","2019-04-30",5,10,100,10000,0.15,8500]

{"sheet":"Fujy","index":3,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
["Fujy","Double","2019-04-16","2019-04-22",6,1,100,1200,0.15,1020,{"$f":"SUM(J2:J1000)","v":12039.4},{"$f":"SUM(F2:F1000)","v":13},null,"2019-05-01",500]
["Fujy","Double","2019-04-20","2019-04-26",6,1,100,1200,0.15,1020,{"$f":"SUM(O2:O10000)","v":500}]
["Fujy","Triple","2019-04-20","2019-04-26",6,1,100,1764,0.15,1499.4]
["Fujy","Double","2019-04-25","2019-04-30",5,10,100,10000,0.15,8500]

{"sheet":"Tomy Tour","index":4,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J2:J1000)","v":0},{"$f":"SUM(F2:F1000)","v":0},null,"2019-05-01",500]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O2:O10000)","v":500}]

{"sheet":"Sun International","index":5,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
["SUN INT","Double","2019-04-15","2019-04-19",4,1,100,800,0.15,680,{"$f":"SUM(J2:J1000)","v":18402.5},{"$f":"SUM(F2:F1000)","v":19},null,"2019-05-01",500]
["SUN INT","Famliy","2019-04-20","2019-04-26",6,1,100,1800,0.15,1530,{"$f":"SUM(O2:O10000)","v":500}]
["SUN INT","Famliy","2019-04-20","2019-04-25",5,5,100,7500,0.15,6375]
["SUN INT","Double","2019-04-24","2019-04-29",5,8,100,8000,0.15,6800]
["SUN INT","Double","2019-04-25","2019-04-29",4,1,100,800,0.15,680]
["SUN INT","Double","2019-04-25","2019-04-30",5,2,100,2000,0.15,1700]
["SUN INT","Single","2019-04-25","2019-04-30",5,1,100,750,0.15,637.5]

{"sheet":"Golden Valley","index":6,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
["Golden","Famliy","2019-04-16","2019-04-19",3,3,100,2700,0.15,2295,{"$f":"SUM(J2:J1000)","v":10934.4},{"$f":"SUM(F2:F1000)","v":10},null,"2019-05-01",500]
["Golden","Triple","2019-04-16","2019-04-19",3,2,100,1764,0.15,1499.4,{"$f":"SUM(O2:O10000)","v":500}]
["Golden Valley","Famliy","2019-04-20","2019-04-25",5,2,100,3000,0.15,2550]
["Golden Valley","Famliy","2019-04-20","2019-04-26",6,3,100,5400,0.15,4590]

{"sheet":"E.H.T","index":7,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
["E.H.T","Single","2019-04-22","2019-04-25",3,2,100,900,0.15,765,{"$f":"SUM(J2:J1000)","v":2295},{"$f":"SUM(F2:F1000)","v":4},null,"2019-05-01",500]
["E.H.T","Famliy","2019-04-22","2019-04-25",3,2,100,1800,0.15,1530,{"$f":"SUM(O2:O10000)","v":500}]

{"sheet":"Out Boon","index":8,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
["Out boon","Famliy","2019-04-20","2019-04-27",7,2,100,4200,0.15,3570,{"$f":"SUM(J2:J1000)","v":3570},{"$f":"SUM(F2:F1000)","v":2},null,"2019-05-01",500]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O2:O10000)","v":500}]

{"sheet":"Alpah Travel","index":9,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
["Alpah Travel","Famliy","2019-04-21","2019-04-27",6,5,100,9000,0.15,7650,{"$f":"SUM(J2:J1000)","v":10370},{"$f":"SUM(F2:F1000)","v":9},null,"2019-05-01",500]
["Alpah Travel","Double","2019-04-26","2019-04-30",4,4,100,3200,0.15,2720,{"$f":"SUM(O2:O10000)","v":500}]

{"sheet":"Gomaa Abbas","index":10,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
["Gomaa Abbas","Famliy","2019-04-20","2019-04-25",5,2,100,3000,0.15,2550,{"$f":"SUM(J2:J1000)","v":2550},{"$f":"SUM(F2:F1000)","v":2},null,"2019-05-01",500]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O2:O10000)","v":500}]

{"sheet":"4 Season","index":11,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J2:J1000)","v":0},{"$f":"SUM(F2:F1000)","v":0},null,"2019-05-01",500]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O2:O10000)","v":500}]

{"sheet":"Air Link","index":12,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate P.P","R.Price","Comm","R.Price Net",{"$f":"Germo!K2+Avalible!K2+'Travel Band'!K2+Fujy!K2+'Tomy Tour'!K2+'Sun International'!K2+'Golden Valley'!K2+E.H.T!K2+'Out Boon'!K2+'Alpah Travel'!K2+'Gomaa Abbas'!K2+'4 Season'!K2+'Air Link'!K2","v":117442.79999999999},null,null,"Date Of Payment","Amount"]
["Air Link","Double","2019-04-15","2019-04-19",4,1,100,800,0.15,680,{"$f":"SUM(J2:J1000)","v":15980},{"$f":"SUM(F2:F1000)","v":14},null,"2019-05-01",500]
["Air Link","Famliy","2019-04-15","2019-04-20",5,3,100,4500,0.15,3825,{"$f":"SUM(O2:O10000)","v":500}]
["Air Link","Famliy","2019-04-15","2019-04-21",6,2,100,3600,0.15,3060]
["Air Link","Famliy","2019-04-21","2019-04-25",4,2,100,2400,0.15,2040]
["Air Link","Double","2019-04-21","2019-04-26",5,2,100,2000,0.15,1700]
["Air Link","Famliy","2019-04-21","2019-04-26",5,3,100,4500,0.15,3825]
["Air Link","Double","2019-04-22","2019-04-27",5,1,100,1000,0.15,850]

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

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

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

{"sheet":"print","index":16,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,3,2,6],[1,3,1,6],[1,7,1,8],[1,1,1,2]]}
[]
[null,{"$f":"NOW()","v":"2019-04-25T13:53:17.910"},null,"Company Name",null,null,null,"Albatros Hotels"]
[null,null,null,"Germo"]
["Guest Name","Room CAT","Check In","Check Out ","NIT","No.Rooms","Rate Per Persone","Room Price","Commision","Room Price Net"]
["Germo","Famliy","2019-04-15","2019-04-20",5,1,100,1500,0.15,1275]
["Germo","Famliy","2019-04-20","2019-04-24",4,1,100,1200,0.15,1020]
["Germo","Famliy","2019-04-20","2019-04-25",5,4,100,6000,0.15,5100]
["Germo","Single","2019-04-20","2019-04-25",5,1,100,750,0.15,637.5]
["Germo","Single","2019-04-23","2019-04-30",7,8,100,8400,0.15,7140]
["Germo","Double","2019-04-23","2019-04-30",7,2,100,2800,0.15,2380]
[]
[null,null,null,"Total Rooms",null,17,null,null,"Total Amount","17552.50 $"]