Prac2.Hoàng Thị Ngọc Liên

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 25

Number Room code Full Name Sex Check-in date Check-out date

1 pd12 Female 10/4/2024 11/4/2024


2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
Number of adults Number of children Room type Room Price Payment method
Standard 60
Breakfast Menu Menu details
Menu2 Menu1 Menu2 Menu3
Egg bread Beef noodle soup Vegetable salad
Pate bread Quang Noodles Cereal
Butter bread Pho Fruit
Dates Year Month Day of month Day of week Formatted
1/29/2003 2003 1 29 Wednesday 29-Jan-2003
12/22/1919 1919 12 22 Monday 22-Dec-1919
6/12/1973 1973 6 12 Tuesday 12-Jun-1973
8/3/1914 1914 8 3 Monday 03-Aug-1914
2/15/1983 1983 2 15 Tuesday 15-Feb-1983
11/11/1992 1992 11 11 Wednesday 11-Nov-1992
11/8/1940 1940 11 8 Friday 08-Nov-1940
8/9/1944 1944 8 9 Wednesday 09-Aug-1944
1/17/1986 1986 1 17 Friday 17-Jan-1986
1/3/1996 1996 1 3 Wednesday 03-Jan-1996
7/19/1925 1925 7 19 Sunday 19-Jul-1925
6/8/1969 1969 6 8 Sunday 08-Jun-1969
12/3/1941 1941 12 3 Wednesday 03-Dec-1941
3/4/1911 1911 3 4 Saturday 04-Mar-1911
1/8/1936 1936 1 8 Wednesday 08-Jan-1936
8/2/1982 1982 8 2 Monday 02-Aug-1982
10/26/1966 1966 10 26 Wednesday 26-Oct-1966
1/13/1958 1958 1 13 Monday 13-Jan-1958
11/15/1908 1908 11 15 Sunday 15-Nov-1908
Real
Bought Sold Months kept Years kept Working Retire date
days
4/27/2012 8/22/2013 482 1 345 10/3/2013
12/1/2012 9/4/2014 642 2 459 10/16/2014
7/30/2013 5/13/2015 652 2 467 6/24/2015
7/10/2013 3/15/2015 613 2 438 4/24/2015
11/17/2019 7/22/2022 978 3 700 9/2/2022
1/2/2020 7/3/2023 1278 4 913 8/14/2023
1/18/2017 2/3/2021 1477 4 1056 3/17/2021
10/6/2018 1/7/2022 1189 3 850 2/18/2022
9/10/2017 9/23/2019 743 2 531 11/4/2019
4/11/2016 2/10/2020 1400 4 1001 3/23/2020
11/7/2022 10/8/2023 335 1 240 11/17/2023
1/14/2014 12/21/2016 1072 3 767 2/1/2017
11/19/2013 7/16/2016 970 3 694 8/26/2016
8/26/2020 5/9/2024 1352 4 967 6/20/2024
12/30/2015 11/7/2016 313 1 224 12/19/2016
12/25/2022 1/8/2027 1475 4 1055 2/19/2027
6/29/2016 8/17/2019 1144 3 818 9/27/2019
9/7/2014 10/31/2016 785 2 561 12/12/2016
2/18/2011 12/26/2011 311 1 222 2/6/2012
8/11/2018 8/17/2021 1102 3 787 9/28/2021
4/4/2022 7/14/2024 832 2 595 8/23/2024
Number Booking reference Booking date Surname Firstname
1 291 10/9/2021 Nguyễn Lan Anh
2 629 5/5/2021 Trần Cao Ánh
3 179 4/9/2020 Nguyễn Gia Bảo
4 644 3/2/2021 Hoàng Mạnh Bằng
5 294 8/11/2020 Trần Quế Chi
6 958 5/7/2019 Đào Mạnh Cường
7 938 2/9/2020 Cù Thùy Dung
8 788 8/2/2018 Trần Minh Dũng
9 696 12/4/2020 Hoàng Phan Đức
10 456 4/3/2018 Hồ Minh Hà
11 603 12/11/2019 Phan Xuân Hồng
12 798 9/28/2020 Cao Hoàng Minh
13 114 3/21/2020 Nguyễn Anh Mạnh
14 316 7/6/2019 Trần Hoàng Nam
15 578 3/6/2021 Cao Thế Phong
16 825 4/8/2020 Mai Minh Phương
17 323 12/5/2017 Trần Minh Thư
18 807 3/5/2019 Điền Mai Thương
19 429 11/5/2020 Phương Hà Vi
20 710 12/6/2019 Nguyễn Y Vân
21 748
22 993
23 531
24 510
25 582
26 720
27 446
28 328
29 527
30 198
31 977
32 479
33 606
34 213
35 332
36 209
37 743
38 440
39 355
40 744
41 574
42 239
43 435
44 277
45 150
46 784
47 600
48 426
49 663
50 511
51 524
52 548
53 983
54 854
55 702
56 263
57 994
58 136
59 642
60 478
61 643
62 125
63 499
64 927
65 171
66 564
67 511
68 908
69 615
70 157
71 502
72 280
73 403
74 630
75 113
76 231
77 354
78 685
79 593
80 657
81 281
82 183
83 383
84 794
85 274
86 717
87 789
88 713
89 422
90 532
91 421
92 135
93 468
94 826
95 484
96 299
97 471
98 265
99 970
100 447
101 850
102 331
103 918
104 503
105 267
106 599
107 573
108 390
109 689
110 563
111 870
112 591
113 505
114 598
115 694
116 384
117 625
118 236
119 426
120 457
121 295
122 464
123 223
124 294
125 422
126 465
127 983
128 320
129 638
130 389
131 552
132 990
133 152
134 286
135 544
136 784
137 747
138 348
139 387
140 174
141 417
142 168
143 552
144 351
145 391
146 458
147 750
148 236
149 874
150 452
151 674
152 581
153 341
154 702
155 203
156 689
157 740
158 362
159 506
160 720
161 522
162 497
163 258
164 456
165 896
166 769
167 264
168 131
169 442
170 434
171 406
172 457
173 812
174 758
175 357
176 528
177 469
178 825
179 389
180 641
181 614
182 487
183 695
184 488
185 794
186 888
187 146
188 804
189 348
190 581
191 675
192 522
193 432
194 266
195 488
196 405
197 531
198 899
199 301
200 499
201 626
202 468
203 712
204 153
205 595
206 495
207 797
208 652
209 227
210 863
211 363
212 336
213 446
214 705
215 885
216 836
217 244
218 273
219 478
220 115
221 420
222 390
223 799
224 992
225 273
226 419
227 261
228 653
229 705
230 509
231 907
232 188
233 949
234 212
235 712
236 916
237 256
238 863
239 524
240 872
241 159
242 157
243 309
244 617
245 187
246 388
247 129
248 514
249 488
250 643
Fullname Title No. of nights Accom. Reqd. Dietary requirements
Nguyễn Lan Anh Ms 1 Vegetarian
Trần Cao Ánh Ms 1 No dairy
Nguyễn Gia Bảo Mr 2 None
Hoàng Mạnh Bằng Dr 0 Vegan
Trần Quế Chi Ms 3 None
Đào Mạnh Cường Mr 2 No dairy
Cù Thùy Dung Ms 1 None
Trần Minh Dũng Mr 3 Vegan
Hoàng Phan Đức Mr 0 Vegetarian
Hồ Minh Hà Dr 2 Vegetarian
Phan Xuân Hồng Mr 1 Vegetarian
Cao Hoàng Minh Mr 3 No dairy
Nguyễn Anh Mạnh Dr 3 None
Trần Hoàng Nam Mr 2 None
Cao Thế Phong Mr 3 Vegan
Mai Minh Phương Ms 1 No dairy
Trần Minh Thư Ms 2 None
Điền Mai Thương Ms 0 None
Phương Hà Vi Ms 3 No dairy
Nguyễn Y Vân Dr 2 Vegetarian
Category Cost Payment method Breakfast Preference
Full fee 350 Cheque Fruit menu
Full fee 350 Cheque Nut menu
Student 90 Debit/Credit Card Vegetable menu
Student 90 PayPal Fruit menu
Discount fee 180 PayPal Vegetable menu
Full fee 350 Cheque Vegetable menu
Full fee 350 Cheque Fruit menu
Student 90 PayPal Fruit menu
Discount fee 180 Invoice Vegetable menu
Discount fee 180 Cheque Fruit menu
Full fee 350 Debit/Credit Card Vegetable menu
Full fee 350 PayPal Nut menu
Student 90 PayPal Nut menu
Student 90 Cheque Fruit menu
Full fee 350 Debit/Credit Card Vegetable menu
Discount fee 180 Invoice Nut menu
Discount fee 180 Invoice Vegetable menu
Student 90 Debit/Credit Card Vegetable menu
Full fee 350 Cheque Nut menu
Discount fee 180 PayPal Vegetable menu
Menu Details City tax rate Total payment
Apples, Oranges, Cherries, Mangos, Peaches, Kiwis 24.5 374.5
Peanuts, Walnuts, Cashews, Almonds 24.5 374.5
Carrots, Broccoli, Potato, Cauliflower, Kale 6.3 96.3
Apples, Oranges, Cherries, Mangos, Peaches, Kiwis 6.3 96.3
Carrots, Broccoli, Potato, Cauliflower, Kale 12.6 192.6
Carrots, Broccoli, Potato, Cauliflower, Kale 24.5 374.5
Apples, Oranges, Cherries, Mangos, Peaches, Kiwis 24.5 374.5
Apples, Oranges, Cherries, Mangos, Peaches, Kiwis 6.3 96.3
Carrots, Broccoli, Potato, Cauliflower, Kale 12.6 192.6
Apples, Oranges, Cherries, Mangos, Peaches, Kiwis 12.6 192.6
Carrots, Broccoli, Potato, Cauliflower, Kale 24.5 374.5
Peanuts, Walnuts, Cashews, Almonds 24.5 374.5
Peanuts, Walnuts, Cashews, Almonds 6.3 96.3
Apples, Oranges, Cherries, Mangos, Peaches, Kiwis 6.3 96.3
Carrots, Broccoli, Potato, Cauliflower, Kale 24.5 374.5
Peanuts, Walnuts, Cashews, Almonds 12.6 192.6
Carrots, Broccoli, Potato, Cauliflower, Kale 12.6 192.6
Carrots, Broccoli, Potato, Cauliflower, Kale 6.3 96.3
Peanuts, Walnuts, Cashews, Almonds 24.5 374.5
Carrots, Broccoli, Potato, Cauliflower, Kale 12.6 192.6
0 0

You might also like