DATA TAMU HOTE

NAMA PETUGAS AULIA RIZQITA PUTRI 220803101059

Tarif Kamar 300,000 per hari

NO KODE Nama dan Kota Asal Nama Tamu

1 A123L9M Ali Surabaya Ali
2 A145L3T Lili Jakarta Lili
3 B125P3M Dedi Palembang Dedi
4 D196P2A Achmed Semarang Achmed
5 A158L4T Dechamez Pangkalpinang Dechamez
6 C256L9M Bombi Medan Bombi
7 B288P1L Bella Bekasi Bella
8 D290P4M Jorgenson Jogjakarta Jorgenson
9 A279P1L Burioo Solo Burioo
10 B173L2T Warno Jember Warno
11 B125L7L Budi Medan Budi
12 C167P5A Mikael Jayapura Mikael
13 A198P8M Leli Denpasar Leli
14 C174L6A Rasty Bondowoso Rasty
15 B129P4L Susan Lumajang Susan
16 C265L9T John Cilegon John
17 A234P4T Nina Kuningan Nina
18 C249L1A Yuni Cirebon Yuni
19 D126L7M Julius Bekasi Julius
20 B289L3L Bimo Jogjakarta Bimo
21 B209P3T Vina Solo Vina
22 A200L8M Eric Jember Eric
23 C120P2L Rita Medan Rita
24 D111P5A Albert Jayapura Albert
25 C190L7A Tasya Denpasar Tasya
26 B125P9M Helen Bondowoso Helen
27 C288L2L Dimas Surabaya Dimas
28 A278P9A Ricky Jakarta Ricky
29 C209L8T Lala Palembang Lala
30 D201P2A Nana Semarang Nana
31 D176L3M Jessica Pangkalpinang Jessica
32 C193P6T Margaret Medan Margaret
33 A102L8A Frank Bekasi Frank
34 C128L7L Andreanus Jogjakarta Andreanus
35 B127P5M Lolo Solo Lolo
36 D220P3L Samuel Jember Samuel
37 C282L7A Lulu Medan Lulu
38 A289L6T Vonny Jayapura Vonny
39 D278L8L Lila Jogjakarta Lila
40 C265P1A Silvia Solo Silvia
41 B149P2M Tata Jember Tata
42 D184L3T Raymond Medan Raymond
43 B192P2L Tina Jayapura Tina
44 C188P9A Stephen Jambi Stephen
45 A245P8M Denny Mataram Denny
46 D244L7A Melinda Bandung Melinda
47 B251L6L Roy Bogor Roy
48 C128L3L Erni Makasar Erni
49 D221P5T Andi Samarinda Andi
50 A173P7A Toto Bondowoso Toto
51 D229P6M Fadli Jember Fadli
52 A107L3T Rudy Nganjuk Rudy
53 A280L4L Susan Madiun Susan
54 C175L5M Toni Solo Toni
55 B140L2L Angel Jember Angel
56 D163P1A Mario Medan Mario
57 A271P1T Stefani Jayapura Stefani
58 C290P3T Iwan Jambi Iwan
59 B227L5A Titi Mataram Titi
60 D291P8L Ade Bandung Ade
61 B289L7M Adi Bogor Adi
62 D267P5T Ani Makasar Ani
63 A256P4L Ami Samarinda Ami
64 B104P6A Ina Bondowoso Ina
65 C184L4M Ida Jember Ida
66 D122P8A Ita Nganjuk Ita
67 A298P9T Tia Madiun Tia
68 B209L2T Tio Medan Tio
69 D201P3L Mia Bekasi Mia
70 D256L6M Mio Jogjakarta Mio
71 A174L8T Jony Solo Jony
72 B199L1M Jenny Jember Jenny
73 A177P8L Bianca Medan Bianca
74 D165P7T Melisa Jayapura Melisa
75 D187P9L Melina Denpasar Melina
76 B134P5L Eva Bondowoso Eva
77 A143P3A Jojo Lumajang Jojo
78 C111L2T Mira Cilegon Mira
79 C100L6A Keyto Kuningan Keyto
80 B126P2T Beny Cirebon Beny
81 D167P1M Amanda Bekasi Amanda
82 B112L8T Asri Jakarta Asri
83 C132L7L Banu Bekasi Banu
84 A134P3M Alvin Cirebon Alvin
85 C226P4A Andrew Jogjakarta Andrew
86 D224L8T Ansis Solo Ansis
87 C289P4A Charles Jember Charles
88 A245P6M Christo Medan Christo
89 C123L4A Sari Jayapura Sari
90 B267L3L Kathrine Jambi Kathrine
 91 B139P5M Neny Mataram Neny
92 D298L6A Theresia Bandung Theresia
93 C299L2L Vino Bogor Vino
94 A296L1M Revandi Makasar Revandi
95 D267L9T Darren Samarinda Darren
96 A256L8M Dylan Bondowoso Dylan
97 B178L6L Sonia Jember Sonia
98 D235P5A Bonita Nganjuk Bonita
99 A256P4T Mikhael Madiun Mikhael
100 B113L4L Lory Jogjakarta Lory
DATA TAMU HOTEL "ONOANUNE"

Kota Asal JKL Kelas No Kamar

Surabaya L A 123
Jakarta L A 145
Palembang P B 125
Semarang P D 196
Pangkalpinang L A 158
Medan L C 256
Bekasi P B 288
Jogjakarta P D 290
Solo P A 279
Jember L B 173
Medan L B 125
Jayapura P C 167
Denpasar P A 198
Bondowoso L C 174
Lumajang P B 129
Cilegon L C 265
Kuningan P A 234
Cirebon L C 249
Bekasi L D 126
Jogjakarta L B 289
Solo P B 209
Jember L A 200
Medan P C 120
Jayapura P D 111
Denpasar L C 190
Bondowoso P B 125
Surabaya L C 288
Jakarta P A 278
Palembang L C 209
Semarang P D 201
Pangkalpinang L D 176
Medan P C 193
Bekasi L A 102
Jogjakarta L C 128
Solo P B 127
Jember P D 220
Medan L C 282
Jayapura L A 289
Jogjakarta L D 278
Solo P C 265
Jember P B 149
Medan L D 184
Jayapura P B 192
Jambi P C 188
Mataram P A 245
Bandung L D 244
Bogor L B 251
Makasar L C 128
Samarinda P D 221
Bondowoso P A 173
Jember P D 229
Nganjuk L A 107
Madiun L A 280
Solo L C 175
Jember L B 140
Medan P D 163
Jayapura P A 271
Jambi P C 290
Mataram L B 227
Bandung P D 291
Bogor L B 289
Makasar P D 267
Samarinda P A 256
Bondowoso P B 104
Jember L C 184
Nganjuk P D 122
Madiun P A 298
Medan L B 209
Bekasi P D 201
Jogjakarta L D 256
Solo L A 174
Jember L B 199
Medan P A 177
Jayapura P D 165
Denpasar P D 187
Bondowoso P B 134
Lumajang P A 143
Cilegon L C 111
Kuningan L C 100
Cirebon P B 126
Bekasi P D 167
Jakarta L B 112
Bekasi L C 132
Cirebon P A 134
Jogjakarta P C 226
Solo L D 224
Jember P C 289
Medan P A 245
Jayapura L C 123
Jambi L B 267
Mataram P B 139
Bandung L D 298
Bogor L C 299
Makasar L A 296
Samarinda L D 267
Bondowoso L A 256
Jember L B 178
Nganjuk P D 235
Madiun P A 256
Jogjakarta L B 113
Lama Menginap Biaya SPASI LEN
9 Rp 2,700,000.00 4 12
3 Rp 900,000.00 5 12
3 Rp 900,000.00 5 14
2 Rp 600,000.00 7 15
4 Rp 1,200,000.00 9 22
9 Rp 2,700,000.00 6 11
1 Rp 300,000.00 6 12
4 Rp 1,200,000.00 10 20
1 Rp 300,000.00 7 11
2 Rp 600,000.00 6 12
7 Rp 2,100,000.00 5 10
5 Rp 1,500,000.00 7 15
8 Rp 2,400,000.00 5 13
6 Rp 1,800,000.00 6 15
4 Rp 1,200,000.00 6 14
9 Rp 2,700,000.00 5 12
4 Rp 1,200,000.00 5 13
1 Rp 300,000.00 5 12
7 Rp 2,100,000.00 7 13
3 Rp 900,000.00 5 15
3 Rp 900,000.00 5 9
8 Rp 2,400,000.00 5 11
2 Rp 600,000.00 5 10
5 Rp 1,500,000.00 7 15
7 Rp 2,100,000.00 6 14
9 Rp 2,700,000.00 6 15
2 Rp 600,000.00 6 14
9 Rp 2,700,000.00 6 13
8 Rp 2,400,000.00 5 14
2 Rp 600,000.00 5 13
3 Rp 900,000.00 8 21
6 Rp 1,800,000.00 9 14
8 Rp 2,400,000.00 6 12
7 Rp 2,100,000.00 10 20
5 Rp 1,500,000.00 5 9
3 Rp 900,000.00 7 13
7 Rp 2,100,000.00 5 10
6 Rp 1,800,000.00 6 14
8 Rp 2,400,000.00 5 15
1 Rp 300,000.00 7 11
2 Rp 600,000.00 5 11
3 Rp 900,000.00 8 13
2 Rp 600,000.00 5 13
9 Rp 2,700,000.00 8 13
8 Rp 2,400,000.00 6 13
7 Rp 2,100,000.00 8 15
6 Rp 1,800,000.00 4 9
3 Rp 900,000.00 5 12
5 Rp 1,500,000.00 5 14
7 Rp 2,100,000.00 5 14
6 Rp 1,800,000.00 6 12
3 Rp 900,000.00 5 12
4 Rp 1,200,000.00 6 12
5 Rp 1,500,000.00 5 9
2 Rp 600,000.00 6 12
1 Rp 300,000.00 6 11
1 Rp 300,000.00 8 16
3 Rp 900,000.00 5 10
5 Rp 1,500,000.00 5 12
8 Rp 2,400,000.00 4 11
7 Rp 2,100,000.00 4 9
5 Rp 1,500,000.00 4 11
4 Rp 1,200,000.00 4 13
6 Rp 1,800,000.00 4 13
4 Rp 1,200,000.00 4 10
8 Rp 2,400,000.00 4 11
9 Rp 2,700,000.00 4 10
2 Rp 600,000.00 4 9
3 Rp 900,000.00 4 10
6 Rp 1,800,000.00 4 14
8 Rp 2,400,000.00 5 9
1 Rp 300,000.00 6 12
8 Rp 2,400,000.00 7 12
7 Rp 2,100,000.00 7 15
9 Rp 2,700,000.00 7 15
5 Rp 1,500,000.00 4 13
3 Rp 900,000.00 5 13
2 Rp 600,000.00 5 12
6 Rp 1,800,000.00 6 14
2 Rp 600,000.00 5 12
1 Rp 300,000.00 7 13
8 Rp 2,400,000.00 5 12
7 Rp 2,100,000.00 5 11
3 Rp 900,000.00 6 13
4 Rp 1,200,000.00 7 17
8 Rp 2,400,000.00 6 10
4 Rp 1,200,000.00 8 14
6 Rp 1,800,000.00 8 13
4 Rp 1,200,000.00 5 13
3 Rp 900,000.00 9 14
5 Rp 1,500,000.00 5 12
6 Rp 1,800,000.00 9 16
2 Rp 600,000.00 5 10
1 Rp 300,000.00 8 15
9 Rp 2,700,000.00 7 16
8 Rp 2,400,000.00 6 15
6 Rp 1,800,000.00 6 12
5 Rp 1,500,000.00 7 14
4 Rp 1,200,000.00 8 14
4 Rp 1,200,000.00 5 15
 RESUME JML TAMU, LAMA DAN BIAYA BERDASAR KOTA ASAL
A Jumlah JML TAMU BERDASARJKL LAMA
No KOTA
TAMU L P MENGINAP
1 Bandung 3 2 1 21
2 Bekasi 6 3 3 27
3 Bogor 3 3 0 15
4 Bondowoso 6 2 4 41
5 Cilegon 2 2 0 11
6 Cirebon 3 1 2 6
7 Denpasar 3 1 2 24
8 Jakarta 3 2 1 20
9 Jambi 3 1 2 15
10 Jayapura 7 2 5 30
11 Jember 10 6 4 38
12 Jogjakarta 7 5 2 36
13 Kuningan 2 1 1 10
14 Lumajang 2 0 2 7
15 Madiun 3 1 2 17
16 Makasar 3 2 1 9
17 Mataram 3 1 2 18
18 Medan 10 5 5 51
19 Nganjuk 3 1 2 16
20 Palembang 2 1 1 11
21 Pangkalpinang 2 2 0 7
22 Samarinda 3 1 2 18
23 Semarang 2 0 2 4
24 Solo 7 3 4 31
25 Surabaya 2 2 0 11
JUMLAH 100 50 50 494

B Bekasi 6 3 3 27
R KOTA ASAL

JUMLAH BIAYA
Rp 6,300,000.00
Rp 8,100,000.00
Rp 4,500,000.00
Rp 12,300,000.00
Rp 3,300,000.00
Rp 1,800,000.00
Rp 7,200,000.00
Rp 6,000,000.00
Rp 4,500,000.00
Rp 9,000,000.00
Rp 11,400,000.00
Rp 10,800,000.00
Rp 3,000,000.00
Rp 2,100,000.00
Rp 5,100,000.00
Rp 2,700,000.00
Rp 5,400,000.00
Rp 15,300,000.00
Rp 4,800,000.00
Rp 3,300,000.00
Rp 2,100,000.00
Rp 5,400,000.00
Rp 1,200,000.00
Rp 9,300,000.00
Rp 3,300,000.00
Rp 148,200,000.00

8100000
 RESUME JUMLAH KELAS PER KOTA ASAL
A JUMLAH KELAS
No KOTA
A B C
1 Bandung 0 0 0
2 Bekasi 1 1 1
3 Bogor 0 2 1
4 Bondowoso 2 3 1
5 Cilegon 0 0 2
6 Cirebon 1 1 1
7 Denpasar 1 0 1
8 Jakarta 2 1 0
9 Jambi 0 1 2
10 Jayapura 2 1 2
11 Jember 1 5 2
12 Jogjakarta 0 2 2
13 Kuningan 1 0 1
14 Lumajang 1 1 0
15 Madiun 3 0 0
16 Makasar 1 0 1
17 Mataram 1 2 0
18 Medan 2 2 4
19 Nganjuk 1 0 0
20 Palembang 0 1 1
21 Pangkalpinang 1 0 0
22 Samarinda 1 0 0
23 Semarang 0 0 0
24 Solo 2 2 2
25 Surabaya 1 0 1
JUMLAH 25 25 25

B Bandung 0 0 0
ASAL
S
D
3
3
0
0
0
0
1
0
0
2
2
3
0
0
0
1
0
2
2
0
1
2
2
1
0
25

3
 RESUME BIAYA BERDASAR KOTA DAN KELAS
A JUMLAH KELAS
No KOTA
A B C
1 Bandung Rp - Rp - Rp -
2 Bekasi Rp 2,400,000.00 Rp 300,000.00 Rp 2,100,000.00
3 Bogor Rp - Rp 3,900,000.00 Rp 600,000.00
4 Bondowoso Rp 4,500,000.00 Rp 6,000,000.00 Rp 1,800,000.00
5 Cilegon Rp - Rp - Rp 3,300,000.00
6 Cirebon Rp 900,000.00 Rp 600,000.00 Rp 300,000.00
7 Denpasar Rp 2,400,000.00 Rp - Rp 2,100,000.00
8 Jakarta Rp 3,600,000.00 Rp 2,400,000.00 Rp -
9 Jambi Rp - Rp 900,000.00 Rp 3,600,000.00
10 Jayapura Rp 2,100,000.00 Rp 600,000.00 Rp 2,700,000.00
11 Jember Rp 2,400,000.00 Rp 3,900,000.00 Rp 2,400,000.00
12 Jogjakarta Rp - Rp 2,100,000.00 Rp 3,300,000.00
13 Kuningan Rp 1,200,000.00 Rp - Rp 1,800,000.00
14 Lumajang Rp 900,000.00 Rp 1,200,000.00 Rp -
15 Madiun Rp 5,100,000.00 Rp - Rp -
16 Makasar Rp 300,000.00 Rp - Rp 900,000.00
17 Mataram Rp 2,400,000.00 Rp 3,000,000.00 Rp -
18 Medan Rp 4,200,000.00 Rp 2,700,000.00 Rp 7,200,000.00
19 Nganjuk Rp 900,000.00 Rp - Rp -
20 Palembang Rp - Rp 900,000.00 Rp 2,400,000.00
21 Pangkalpinang Rp 1,200,000.00 Rp - Rp -
22 Samarinda Rp 1,200,000.00 Rp - Rp -
23 Semarang Rp - Rp - Rp -
24 Solo Rp 2,700,000.00 Rp 2,400,000.00 Rp 1,800,000.00
25 Surabaya Rp 2,700,000.00 Rp - Rp 600,000.00
JUMLAH Rp 41,100,000.00 Rp 30,900,000.00 Rp 36,900,000.00

B Bogor Rp - Rp 3,900,000.00 Rp 600,000.00

KELAS

D
Rp 6,300,000.00
Rp 3,300,000.00
Rp -
Rp -
Rp -
Rp -
Rp 2,700,000.00
Rp -
Rp -
Rp 3,600,000.00
Rp 2,700,000.00
Rp 5,400,000.00
Rp -
Rp -
Rp -
Rp 1,500,000.00
Rp -
Rp 1,200,000.00
Rp 3,900,000.00
Rp -
Rp 900,000.00
Rp 4,200,000.00
Rp 1,200,000.00
Rp 2,400,000.00
Rp -
Rp 39,300,000.00

Rp -
Compatibility Report for UTS Aplikasi Komputer
bisnis AULIA RIZQITA PUTRI 1059.xls
Run on 15/10/2024 09:23

If the workbook is saved in an earlier file format

or opened in an earlier version of Microsoft Excel,
the listed features will not be available.

Significant loss of functionality # of Version

occurrence
s

One or more functions in this workbook are not 250

available in versions prior to Excel 2007. When
recalculated in earlier versions, these functions
will return a #NAME? error instead of their
current results.

2 Jml Tamu'!E6:F30
Excel 97-
2003

3 Rekap Kelas'!D6:G30
Excel 97-
2003

4 Biaya Berdasar
Excel
Kelas'!D6:G30
97-
2003

Minor loss of fidelity

Some cells or styles in this workbook contain 11 Excel 97-

formatting that is not supported by the selected 2003
file format. These formats will be converted to
the closest format available.