Laporan Gaji Pegawai.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Laporan Gaji Pegawai
2	PT. ANIS
3	Jl. Kucing Imut 2
4
5	NO	KODE JABATAN	NAMA	JABATAN	STATUS	DIVISI	GAJI POKOK	JUMLAH ANAK	Tunj. Anak	Total gaji
6	1	A-1-M	DEWIK	KEPALA	MERRIED	DISTRIBUTOR	Rp 2.500.000	2	5000000	Rp 7.500.000
7	2	A-2-M	ANTON	STAFF	MERRIED	DISTRIBUTOR	Rp 2.500.000	3	7500000	Rp 10.000.000
8	3	B-1-S	WULAN	KEPALA	SINGLE	ENGINEERING	Rp 2.300.000	0	0	Rp 2.300.000
9	4	B-3-M	TONI	OPERATOR	MERRIED	ENGINEERING	Rp 2.300.000	1	2300000	Rp 4.600.000
10	5	A-3-S	DIDIK	OPERATOR	SINGLE	DISTRIBUTOR	Rp 2.500.000	0	0	Rp 2.500.000
11	6	D-3-M	TOTOK	OPERATOR	MERRIED	QUALITY CONTROL	Rp 2.600.000	3	7800000	Rp 10.400.000
12	7	D-2-S	BAYU	STAFF	SINGLE	QUALITY CONTROL	Rp 2.600.000	0	0	Rp 2.600.000
13	8	B-2-S	ANDO	STAFF	SINGLE	ENGINEERING	Rp 2.300.000	0	0	Rp 2.300.000
14	9	C-2-M	ANANDA	STAFF	MERRIED	PRODUKSI	Rp 2.000.000	1	2000000	Rp 4.000.000
15	10	C-1-M	RINA	KEPALA	MERRIED	PRODUKSI	Rp 2.000.000	0	0	Rp 2.000.000
16	Total seluruh gaji									Rp 48.200.000
17	Gaji terbesar									Rp 10.400.000
18	Gaji terendah									Rp 2.000.000
19	Gaji rata-rata									Rp 4.820.000
20	Jumlah data									10
21
22		Table Bantu:
23		KODE	DIVISI	GAJI POKOK
24		A	DISTRIBUTOR	Rp 2.500.000
25		B	ENGINEERING	Rp 2.300.000
26		C	PRODUKSI	Rp 2.000.000
27		D	QUALITY CONTROL	Rp 2.600.000
28
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