XRPL

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 5

DATA PENGIRIMAN BAHAN KONSUMSI

Untuk Bulan Desember 2001


TANGGAL JAM NAMA JUMLAH HARGA TOTAL
NO DIKIRIM DIKIRIM BAHAN SATUAN SATUAN DISKON HARGA JUMLAH DISKON TOTAL BAYAR
1 1-Dec-01 9:15:00 AM Beras Cianjur 1000 Liter Rp 2,800.00 5% Rp 2,800,000.00 Rp 140,000.00 Rp 2,660,000.00
2 2-Dec-01 8:30:00 AM Beras Karawang 1500 Liter Rp 2,000.00 6% Rp 3,000,000.00 Rp 180,000.00 Rp 2,820,000.00
3 3-Dec-01 11:20:00 AM Beras Tasik 800 Liter Rp 1,800.00 4% Rp 1,440,000.00 Rp 57,600.00 Rp 1,382,400.00
4 4-Dec-01 1:10:00 PM Beras Bojolali 850 Liter Rp 2,500.00 7% Rp 2,125,000.00 Rp 148,750.00 Rp 1,976,250.00
5 5-Dec-01 7:30:00 AM Beras Nusantara 750 Liter Rp 2,200.00 3% Rp 1,650,000.00 Rp 49,500.00 Rp 1,600,500.00
6 6-Dec-01 9:45:00 AM Beras Segitiga 900 Liter Rp 1,750.00 2% Rp 1,575,000.00 Rp 31,500.00 Rp 1,543,500.00
7 7-Dec-01 5:00:00 PM Beras Thailand 1100 Liter Rp 1,850.00 8% Rp 2,035,000.00 Rp 162,800.00 Rp 1,872,200.00
8 8-Dec-01 4:50:00 PM Beras Chines 1200 Liter Rp 1,700.00 4% Rp 2,040,000.00 Rp 81,600.00 Rp 1,958,400.00
9 9-Dec-01 3:30:00 PM Beras Merah 500 Liter Rp 2,100.00 6% Rp 1,050,000.00 Rp 63,000.00 Rp 987,000.00
10 10-Dec-01 11:00:00 AM Beras Gabah 350 Liter Rp 500.00 2% Rp 175,000.00 Rp 3,500.00 Rp 171,500.00
11 11-Dec-01 10:10:00 AM Gula Putih Halus 2500 Kg Rp 3,800.00 1% Rp 9,500,000.00 Rp 95,000.00 Rp 9,405,000.00
12 12-Dec-01 10:30:00 AM Gula Putih Kasar 2200 Kg Rp 3,500.00 1% Rp 7,700,000.00 Rp 77,000.00 Rp 7,623,000.00
13 13-Dec-01 8:50:00 AM Gula Merah 2000 Kg Rp 2,000.00 1.50% Rp 4,000,000.00 Rp 60,000.00 Rp 3,940,000.00
14 14-Dec-01 2:25:00 PM Telor Ayam Negeri 10 Peti Rp 500.00 0.50% Rp 5,000.00 Rp 25.00 Rp 4,975.00
15 15-Dec-01 4:30:00 PM Telor Ayam Kampung 8 Peti Rp 900.00 0.50% Rp 7,200.00 Rp 36.00 Rp 7,164.00
16 16-Dec-01 9:10:00 AM Telor Bebek 5 Peti Rp 1,000.00 0.80% Rp 5,000.00 Rp 40.00 Rp 4,960.00
17 17-Dec-01 9:15:00 AM Telor Puyuh 3 Peti Rp 250.00 0.60% Rp 750.00 Rp 4.50 Rp 745.50
18 18-Dec-01 10:00:00 AM Minyak Goreng Putih 15 Galon Rp 20,000.00 1.20% Rp 300,000.00 Rp 3,600.00 Rp 296,400.00
19 19-Dec-01 8:15:00 AM Minyak Goreng Kuning 13 Galon Rp 25,000.00 1.50% Rp 325,000.00 Rp 4,875.00 Rp 320,125.00
20 20-Dec-01 7:50:00 AM Minyak Sayur 10 Galon Rp 15,000.00 2.50% Rp 150,000.00 Rp 3,750.00 Rp 146,250.00
21 21-Dec-01 11:10:00 AM Minyak Jelanta 5 Galon Rp 12,000.00 3.50% Rp 60,000.00 Rp 2,100.00 Rp 57,900.00
22 22-Dec-01 1:30:00 PM Indomie 20 Dus Rp 28,000.00 2% Rp 560,000.00 Rp 11,200.00 Rp 548,800.00
23 23-Dec-01 2:20:00 PM Supermie 18 Dus Rp 25,000.00 4% Rp 450,000.00 Rp 18,000.00 Rp 432,000.00
24 24-Dec-01 5:15:00 PM Sarimie 17 Dus Rp 24,000.00 3% Rp 408,000.00 Rp 12,240.00 Rp 395,760.00
25 25-Dec-01 4:30:00 PM Salamie 15 Dus Rp 23,000.00 1% Rp 345,000.00 Rp 3,450.00 Rp 341,550.00
26 26-Dec-01 3:20:00 PM Susu Bendera Putih 12 Buah Rp 5,500.00 1.50% Rp 66,000.00 Rp 990.00 Rp 65,010.00
27 27-Dec-01 2:30:00 PM Susu Bendera Coklat 10 Buah Rp 5,000.00 2.20% Rp 50,000.00 Rp 1,100.00 Rp 48,900.00
28 28-Dec-01 12:30:00 PM Susu Indomilk 9 Buah Rp 4,500.00 2.30% Rp 40,500.00 Rp 931.50 Rp 39,568.50
29 29-Dec-01 6:00:00 PM Susu Dancow 12 Buah Rp 8,500.00 2.50% Rp 102,000.00 Rp 2,550.00 Rp 99,450.00
30 30-Dec-01 12:15:00 PM Susu Cap Nona 6 Buah Rp 4,000.00 2.80% Rp 24,000.00 Rp 672.00
RUMUS DENGAN ALAMAT ABSOLUT

Alamat Absolut berarti cell yang kolom dan barisnya terkunci. Alamat ini ditan
CONTOH
1 2 3 4 5 6 7 8 9

1 2 3 4 5 6 7 8 9 10

2 3 4 5 6 7 8 9 10 11

3 4 5 6 7 8 9 10 11 12

4 5 6 7 8 9 10 11 12 13

5 6 7 8 9 10 11 12 13 14

6 7 8 9 10 11 12 13 14 15

7 8 9 10 11 12 13 14 15 16

8 9 10 11 12 13 14 15 16 17

9 10 11 12 13 14 15 16 17 18

10 11 12 13 14 15 16 17 18 19
MAT ABSOLUT

nci. Alamat ini ditandai dengan $ pada posisi kolom dan barisnya

10 11 12 13 14 15

11 12 13 14 15 16

12 13 14 15 16 17

13 14 15 16 17 18

14 15 16 17 18 19

15 16 17 18 19 20

16 17 18 19 20 21

17 18 19 20 21 22

18 19 20 21 22 23

19 20 21 22 23 24

20 21 22 23 24 25
DAFTAR HARGA FOTO COPY

HARGA/LEMBAR
JUMLAH
LEMBAR FOLIO BURAM A4 A3
Rp 150 Rp 100 Rp 200 Rp 300
45 Rp 6,750 Rp 4,500 Rp 9,000 Rp 13,500
33 Rp 4,950 Rp 3,300 Rp 6,600 Rp 9,900
24 Rp 3,600 Rp 2,400 Rp 4,800 Rp 7,200
22 Rp 3,300 Rp 2,200 Rp 4,400 Rp 6,600
16 Rp 2,400 Rp 1,600 Rp 3,200 Rp 4,800
36 Rp 5,400 Rp 3,600 Rp 7,200 Rp 10,800
12 Rp 1,800 Rp 1,200 Rp 2,400 Rp 3,600
55 Rp 8,250 Rp 5,500 Rp 11,000 Rp 16,500
67 Rp 10,050 Rp 6,700 Rp 13,400 Rp 20,100
68 Rp 10,200 Rp 6,800 Rp 13,600 Rp 20,400
25 Rp 3,750 Rp 2,500 Rp 5,000 Rp 7,500
6 Rp 900 Rp 600 Rp 1,200 Rp 1,800
27 Rp 4,050 Rp 2,700 Rp 5,400 Rp 8,100
37 Rp 5,550 Rp 3,700 Rp 7,400 Rp 11,100
85 Rp 12,750 Rp 8,500 Rp 17,000 Rp 25,500
76 Rp 11,400 Rp 7,600 Rp 15,200 Rp 22,800

You might also like