Biar lebih jelas, klik aja disini
Sabtu, 21 Januari 2012
Sabtu, 14 Januari 2012
MS Excel : Data Angsuran Motor
| ANGSURAN MOTOR | ||||||||||||||||||
| 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | |||||||
| NO | NAMA | ALAMAT | HARGA | HARGA + BUNGA | ASURANSI | ANGSURAN | TOTAL | |||||||||||
| JANUARI | FEBRUARI | MARET | APRIL | MEI | JUNI | JULI | AGUSTUS | SEPTEMBER | OKTOBER | NOVEMBER | DESEMBER | |||||||
| 1 | Agus Goceng | Dago | Rp 15,000,000.00 | Rp 15,500,000.00 | Rp 1,000,000.00 | Rp 1,740,000.00 | Rp 1,595,000.00 | Rp 1,450,000.00 | Rp 1,305,000.00 | Rp 1,160,000.00 | Rp 1,015,000.00 | Rp 870,000.00 | Rp 725,000.00 | Rp 580,000.00 | Rp 435,000.00 | Rp 290,000.00 | Rp 145,000.00 | Rp 11,310,000.00 |
| 2 | Bayu GG | Riung | Rp 7,500,000.00 | Rp 8,000,000.00 | Rp 1,500,000.00 | Rp 780,000.00 | Rp 715,000.00 | Rp 650,000.00 | Rp 585,000.00 | Rp 520,000.00 | Rp 455,000.00 | Rp 390,000.00 | Rp 325,000.00 | Rp 260,000.00 | Rp 195,000.00 | Rp 130,000.00 | Rp 65,000.00 | Rp 5,070,000.00 |
| 3 | Irsyad Aras | Margahayu | Rp 30,000,000.00 | Rp 35,000,000.00 | Rp 4,000,000.00 | Rp 3,720,000.00 | Rp 3,410,000.00 | Rp 3,100,000.00 | Rp 2,790,000.00 | Rp 2,480,000.00 | Rp 2,170,000.00 | Rp 1,860,000.00 | Rp 1,550,000.00 | Rp 1,240,000.00 | Rp 930,000.00 | Rp 620,000.00 | Rp 310,000.00 | Rp 24,180,000.00 |
| 4 | James Coln | Panyileukan | Rp 16,500,000.00 | Rp 17,000,000.00 | Rp 2,000,000.00 | Rp 1,800,000.00 | Rp 1,650,000.00 | Rp 1,500,000.00 | Rp 1,350,000.00 | Rp 1,200,000.00 | Rp 1,050,000.00 | Rp 900,000.00 | Rp 750,000.00 | Rp 600,000.00 | Rp 450,000.00 | Rp 300,000.00 | Rp 150,000.00 | Rp 11,700,000.00 |
| 5 | Lilis M | Arya Graha | Rp 8,000,000.00 | Rp 8,500,000.00 | Rp 1,000,000.00 | Rp 900,000.00 | Rp 825,000.00 | Rp 750,000.00 | Rp 675,000.00 | Rp 600,000.00 | Rp 525,000.00 | Rp 450,000.00 | Rp 375,000.00 | Rp 300,000.00 | Rp 225,000.00 | Rp 150,000.00 | Rp 75,000.00 | Rp 5,850,000.00 |
| 6 | Mimin | Ciwastra | Rp 9,550,000.00 | Rp 10,050,000.00 | Rp 1,500,000.00 | Rp 1,026,000.00 | Rp 940,500.00 | Rp 855,000.00 | Rp 769,500.00 | Rp 684,000.00 | Rp 598,500.00 | Rp 513,000.00 | Rp 427,500.00 | Rp 342,000.00 | Rp 256,500.00 | Rp 171,000.00 | Rp 85,500.00 | Rp 6,669,000.00 |
| 7 | Peter Par | Ledeng | Rp 14,500,000.00 | Rp 15,000,000.00 | Rp 1,250,000.00 | Rp 1,650,000.00 | Rp 1,512,500.00 | Rp 1,375,000.00 | Rp 1,237,500.00 | Rp 1,100,000.00 | Rp 962,500.00 | Rp 825,000.00 | Rp 687,500.00 | Rp 550,000.00 | Rp 412,500.00 | Rp 275,000.00 | Rp 137,500.00 | Rp 10,725,000.00 |
| 8 | Wawan Hendra | Braga | Rp 11,000,000.00 | Rp 11,500,000.00 | Rp 1,000,000.00 | Rp 1,260,000.00 | Rp 1,155,000.00 | Rp 1,050,000.00 | Rp 945,000.00 | Rp 840,000.00 | Rp 735,000.00 | Rp 630,000.00 | Rp 525,000.00 | Rp 420,000.00 | Rp 315,000.00 | Rp 210,000.00 | Rp 105,000.00 | Rp 8,190,000.00 |
| 9 | Waluyo | Cibiru | Rp 25,000,000.00 | Rp 25,500,000.00 | Rp 3,000,000.00 | Rp 2,700,000.00 | Rp 2,475,000.00 | Rp 2,250,000.00 | Rp 2,025,000.00 | Rp 1,800,000.00 | Rp 1,575,000.00 | Rp 1,350,000.00 | Rp 1,125,000.00 | Rp 900,000.00 | Rp 675,000.00 | Rp 450,000.00 | Rp 225,000.00 | Rp 17,550,000.00 |
| 10 | Walter | Cicadas | Rp 21,500,000.00 | Rp 22,000,000.00 | Rp 2,550,000.00 | Rp 2,334,000.00 | Rp 2,139,500.00 | Rp 1,945,000.00 | Rp 1,750,500.00 | Rp 1,556,000.00 | Rp 1,361,500.00 | Rp 1,167,000.00 | Rp 972,500.00 | Rp 778,000.00 | Rp 583,500.00 | Rp 389,000.00 | Rp 194,500.00 | Rp 15,171,000.00 |
| http://www.4shared.com/file/gWEAxLYf/Wisnu_Prayudha_X-K_Smk4_KKPI.html? | download file nya yah... biar jelas | |||||||||||||||||
Langganan:
Postingan (Atom)