Sabtu, 25 Februari 2012

Latihan II (Excel)

Selasa, 31 Januari 2012

Laporan Penghasilan Sewa Play Station

No Penyewa Alamat Kota Tipe S Tgl Sewa Tgl Kembali Lama Sewa Tarip Per Hari Jumlah Biaya Denda Total Biaya
1 Smile Jl.Otis 12 Jakarta Timur A June 3, 2004 June 18,2004 15  Rp         1.500,00  Rp      22.500,00  Rp    500,00  Rp   23.000,00
2 Cindy Jl.Jatinegara 1 Jakarta Timur C June 23,2004 July 17, 2004 24  Rp             500,00  Rp      12.000,00 Rp1.400,00  Rp   13.400,00
3 Pasha Jl.Prapatan 34 Jakarta Pusat C July 10, 2004 July 16, 2004 6  Rp             500,00  Rp        3.000,00  Rp             -    Rp      3.000,00
4 Nana Jl.Merdeka 2 Jakarta Barat A June 2, 2004 June 11,2004 9  Rp         1.500,00  Rp      13.500,00  Rp             -    Rp   13.500,00
5 Very Jl.Satang 12 Jakarta Barat B June 7, 2004 June 26,2004 8  Rp         1.000,00  Rp        8.000,00  Rp             -    Rp      8.000,00
6 Haikal Jl.Kebun Sirih Jakarta Barat B June 23,2004 July 1, 2004 3  Rp         1.000,00  Rp        3.000,00  Rp             -    Rp      3.000,00
7 Jovita Jl.Karawang 2 Jakarta Barat C July 8, 2004 July 11, 2004 16  Rp             500,00  Rp        8.000,00  Rp    600,00  Rp      8.600,00
8 Dicky Jl.Beringin 43 Jakarta Barat B August 07,2004 August 23,2004 16  Rp         1.000,00  Rp      16.000,00  Rp    600,00  Rp   16.600,00
9 Rini Jl.Surabaya 54 Jakarta Timur A August 12,2004 August 12,2004 0  Rp         1.500,00  Rp                     -    Rp             -    Rp                   -