PERTEMUAN 12 tUGAS STI.xlsx

	A	B	C	D	F	G	H	I	J	K
1
2
3	Nama_Barang	Harga
4	Sabun	Rp2.500
5	Kopi	Rp3.000
6	Perman	Rp500
7	Teh	Rp1.000
8	Susu	Rp5.000			No.	Kode_barang	Nama_Barang	Jumlah_barang
9					1	S01	Sabun	100
10					2	K01	Kopi	123
11					3	P01	Perman	75
12					4	T01	Teh	203
13					5	S02	Susu	176
14
15
16			Kode_Barang	Kode_Beli		Kode_Beli	No_Identitas	Tgl_beli	Jumlah	Tot_Harga
17			S01	B0001		B0001	1	12/12/2022	88	Rp220.000
18			K01	B0001		B0001	1	12/13/2022	45	Rp135.000
19			P01	B0002		B0002	2	12/14/2022	74	Rp37.000
20			T01	B0002		B0002	2	12/15/2022	100	Rp100.000
21			S02	B0003		B0003	3	12/16/2022	175	Rp875.000
22
23
24
25							No_Identitas	Nama
26							1	Novita
27							2	Santi
28							3	Sindi
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100