tugas aplikom excel 1

3
Kode Kamar EKO EXC LUX Tarif / Hari Sing 300000 550000 800000 Tarif / Hari Doub 400000 650000 900000 Kelas Kamar Ekonomi Eksekutif Mewah Kode Kamar Nama Tamu Kelas Kamar EXC-1 OLGA Eksekutif-Single EKO-2 DESTA Ekonomi-Double LUX-1 BARBY Mewah-Single EKO-2 GYRDA Ekonomi-Double LUX-2 FADHIL Mewah-Double EXC-2 ANITRI Eksekutif-Double LUX-1 CANTIKA Mewah-Single EKO-2 AYESHA Ekonomi-Double

Upload: didik

Post on 06-Nov-2015

19 views

Category:

Documents


5 download

DESCRIPTION

ms excel

TRANSCRIPT

Sheet1Kode KamarEKOEXCLUXTarif / Hari Single300000550000800000Tarif / Hari Double400000650000900000Kelas KamarEkonomiEksekutifMewahKode KamarNama TamuKelas KamarTarif/HariTanggal DatangTanggal PergiLama NginapTagihanPajakPotonganTotal BayarEXC-1OLGA Eksekutif-Single5500004-Jan-067-Jan-064 Hari 2200000110000003300000EKO-2DESTAEkonomi-Double40000010-Jan-0615-Jan-066 Hari 24000002400007200001920000LUX-1BARBYMewah-Single80000011-Jan-0616-Jan-066 Hari 4800000240000014400005760000EKO-2GYRDAEkonomi-Double40000013-Jan-0615-Jan-063 Hari 120000012000001320000LUX-2FADHILMewah-Double90000014-Jan-0616-Jan-063 Hari 270000027000002970000EXC-2ANITRIEksekutif-Double65000014-Jan-0627-Jan-0614 Hari 91000009100004550009555000LUX-1CANTIKAMewah-Single80000022-Jan-061-Feb-0610 Hari 8000000400000024000009600000EKO-2AYESHAEkonomi-Double4000001-Feb-065-Feb-065 Hari 200000020000002200000