ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Name:
Gde Sumerta
(contoh)
3
NIM:2015834125(contoh)
4
ROOMNAMEMEMBERR-TYPERATECHECK
Stay (days)
AMOUNT
DISCOUNT
TOTAL
Room Rate in USD
5
INOUTMEMBER≥ 7daysCODER-TYPERATE
6
E102IzumiYes4457844585SSuite90
7
E225YukieNo4458244585DDeluxe70
8
D305
Your brief name
No4457744585EEconomy40
9
D412YokoNo4458144585
10
S719TomoYes4458144585
11
S820KyokoYes4457744585
12
S915KaomiNo4458044585
13
Membership discount =
10%
Total average stay=
Total=
14
Stay ≥7 days discount =
5%
Average for Suite=
Bonus=
15
Pay=
16
Informations:
17
R-TYPE
Determined by the first letter of "ROOM code" refering to the "Rate in USD" table. Use vlookup() and string function.
10%
18
RATE
Determined by the first letter of "ROOM code" refering to the "Rate in USD" table. Use vlookup() and string function.
10%
19
Stay
Check-out - check-in
-
20
AMOUNTStay x RATE-
21
DISCOUNT
The guest get discount (D13 x amount) if they are member
10%
22
The guest get discount (D14 x Amount) if they stay 7 days or more.
10%
23
TOTAL
AMOUNT - DISCOUNT (member) and DISCOUNT (≥7 days)
10%
24
Bonus
Two digit number from behind (right) of your NIM. Must USE RIGHT() function!
5%
25
Total average stay = average
-
26
Average for Suite is the average for Suite only (cell I14)
10%
27
Total, Pay, Total average stay
10%
28
Row 4,5 centered V&H (vertically and horizontally)
5%
29
Line (border) just like above, double line, merged etc)
10%
30
Cell B15
Your name with white color
5%
31
G6:H12
Date formatted
5%
32
Cell C2
Your long name
33
Cell C3
Your student reg number
34
Cell C8
Your brief name (nama singkat)
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