tugas excel aplikasi hi

2
DAFTAR PENERIMA KREDIT PROFESI GUR NO KODE JENIS KENDARAAN HARGA UANG MUKA 1 B-1-001 YANTO YAMAHA 12500000 Rp3,750,000 2 D-3-007 RANI KAWASAKI 10500000 Rp3,150,000 3 A-1-021 NINA HONDA 14500000 Rp4,350,000 4 D-4-027 BELA KAWASAKI 10500000 Rp3,150,000 5 C-1-002 DENY SUZUKI 13000000 Rp3,900,000 6 B-1-005 HUSEN YAMAHA 12500000 Rp3,750,000 7 A-4-023 FITRI HONDA 14500000 Rp4,350,000 8 C-4-011 NOER SUZUKI 13000000 Rp3,900,000 9 A-3-029 AHMAD HONDA 14500000 Rp4,350,000 10 B-4-008 LINA YAMAHA 12500000 Rp3,750,000 11 E-2-022 SHOFIE VESPA 8500000 Rp2,550,000 12 A-2-005 GINA HONDA 14500000 Rp4,350,000 KODE HARGA KODE LAMA KREDIT A HONDA 1 1 B YAMAHA 2 2 C SUZUKI 3 3 D KAWASAKI 4 4 E VESPA Rp.8.500.000 NAMA KREDITUR JENIS KENDARAAN Rp.14.500.00 0 Rp.12.500.00 0 Rp.13.000.00 0 Rp.10.500.00 0

Upload: reza-rizki

Post on 02-Oct-2015

1 views

Category:

Documents


0 download

DESCRIPTION

Matakuliah aplikasi hi tentang excel

TRANSCRIPT

Sheet1DAFTAR PENERIMA KREDIT PROFESI GURUNOKODENAMA KREDITURJENIS KENDARAANHARGAUANG MUKASISA KREDITLAMA KREDITBUNGA/TAHUN

1B-1-001YANTOYAMAHA12500000Rp3,750,000Rp8,750,000114%2D-3-007RANIKAWASAKI10500000Rp3,150,000Rp7,350,000316%3A-1-021NINAHONDA14500000Rp4,350,000Rp10,150,000114%4D-4-027BELAKAWASAKI10500000Rp3,150,000Rp7,350,000420%5C-1-002DENYSUZUKI13000000Rp3,900,000Rp9,100,000114%6B-1-005HUSENYAMAHA12500000Rp3,750,000Rp8,750,000114%7A-4-023FITRIHONDA14500000Rp4,350,000Rp10,150,000420%8C-4-011NOERSUZUKI13000000Rp3,900,000Rp9,100,000420%9A-3-029AHMADHONDA14500000Rp4,350,000Rp10,150,000316%10B-4-008LINAYAMAHA12500000Rp3,750,000Rp8,750,000420%11E-2-022SHOFIEVESPA8500000Rp2,550,000Rp5,950,000215%12A-2-005GINAHONDA14500000Rp4,350,000Rp10,150,000215%Persen Uang Muka30%KODEJENIS KENDARAANHARGAKODELAMA KREDITHARGAAHONDARp.14.500.0001114%BYAMAHARp.12.500.0002215%CSUZUKIRp.13.000.0003316%DKAWASAKIRp.10.500.0004420%EVESPARp.8.500.000

Sheet2

Sheet3