ABCDFGHILMNOPQRSTUVWXYZAA
1
2
3
27/2/2020Reservation IDStatusChannelCheck InCheck OutGuest
Total Amount
# Nights
Rate per night
AutoRack
Gain/night
RoomSeasonYearDayWeekend
4
1234567BOOKED
Simple Booking
4/6/204/8/20Test guest 1$332.672$166.34$174.00-$7.66Room 2Holiday20202FALSE
5
1234568BOOKED
Simple Booking
3/14/203/15/20Test guest 2$237.981$237.98$199.00$38.98Room 7High20207TRUE
6
1234569BOOKED
Simple Booking
3/13/203/14/20Test guest 3$187.131$187.13$159.00$28.13Room 2High20206TRUE
7
1234570BOOKEDBooking.com6/28/207/4/20Test guest 4$429.406$71.57$64.00$7.57Room 10Low20201FALSE
8
1234571BOOKEDBooking.com3/27/204/1/20Test guest 5$820.805$164.16$159.00$5.16Room 3High20206TRUE
9
1234572BOOKED
Simple Booking
8/17/208/26/20Test guest 6$1,322.559$146.95$149.00-$2.05Room 3High20202FALSE
10
11
12
26/2/2020Reservation IDStatusChannelCheck InCheck OutGuest
Total Amount
# Nights
Rate per night
AutoRack
Gain/night
RoomSeasonYearDayWeekend
13
1234573BOOKEDExpedia7/27/207/30/20Test guest 7$296.813$98.94$129.00-$30.06Room 13High20202FALSE
14
1234574BOOKEDExpedia7/27/207/30/20Test guest 8$296.813$98.94$129.00-$30.06Room 13High20202FALSE
15
1234575BOOKEDBooking.com4/27/204/30/20Test guest 9$535.003$178.33$124.00$54.33Room 2Low20202FALSE
16
1234576BOOKEDBooking.com2/26/202/27/20Test guest 10$80.751$80.75$129.00-$48.25Room 1High20204FALSE
17
1234577BOOKEDBooking.com8/25/208/28/20Test guest 11$264.003$88.00$129.00-$41.00Room 1High20203FALSE
18
1234578BOOKEDExpedia5/24/205/29/20Test guest 12$342.675$68.53$119.00-$50.47Room 1Low20201FALSE
19
1234579BOOKED
Simple Booking
12/23/2012/26/20Test guest 13$298.323$99.44$149.00-$49.56Room 1Holiday20204FALSE
20
1234580BOOKED
Simple Booking
9/15/209/19/20Test guest 14$711.734$177.93$179.00-$1.07Room 7Mid20203FALSE
21
22
23
Key:
1: "Season" is calculated using a formula that evaluates what range the Check In date falls within (date ranges defined on 'Rack Rates' sheet).
24
2 :"Year" is extracted from the Check In Date (for use in another formula)
25
3: "Day" identifies the day number of the day of guest Check In.
26
4: "Weekend" evaluates whether the Check In date is a weekday or weekend (weekend inthis case defined as Friday or Saturday).
27
5: "AutoRack" is the rack rate applicable, based on the combination of:
28
a) Check In date
29
b) Season
30
c) Weekend or weekday
31
d) Year (date ranges may vary from year to year)
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