Juni - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE
1	PT.Jasa Raharja (Persero)																																																			PT. Jasa Raharja (Persero)
2	Cabang Kalimantan Timur																																																			Cabang Kalimantan Timur
3
4	Data Jumlah Unit Kendaraan																																																			Data Jumlah Unit Kendaraan
5	Periode Juni 2012																																																			Periode Juni 2012
6	Samsat Tanah Grogot																																																			Samsat Long Ikis
7
8	Tanggal	Jenis Kendaraan																																																		Tanggal	Jenis Kendaraan
9		Tahun Berjalan									Jumlah	Tahun Lalu									Jumlah	Prorata									Jumlah	STCK									Jumlah	Total									Jumlah		Tahun Berjalan									Jumlah	Tahun Lalu									Jumlah	Total									Jumlah
10		A	B	C1	C2	DU	DP	EU	EP	F	Jumlah	A	B	C1	C2	DU	DP	EU	EP	F	Jumlah	A	B	C1	C2	DU	DP	EU	EP	F	Jumlah	A	B	C1	C2	DU	DP	EU	EP	F	Jumlah	A	B	C1	C2	DU	DP	EU	EP	F	Jumlah		A	B	C1	C2	DU	DP	EU	EP	F	Jumlah	A	B	C1	C2	DU	DP	EU	EP	F	Jumlah	A	B	C1	C2	DU	DP	EU	EP	F	Jumlah
11	1			30			2			4	36			6			5			1	12			1							1										0	0	0	37	0	0	7	0	0	5	49	1			11							11						2				2	0	0	11	0	0	2	0	0	0	13
12	2			66			6			2	74			3							3										0			35			1				36	0	0	104	0	0	7	0	0	2	113	2			7							7			2							2	0	0	9	0	0	0	0	0	0	9
13	3										0										0										0										0	0	0	0	0	0	0	0	0	0	0	3										0										0	0	0	0	0	0	0	0	0	0	0
14	4	1		152			12	1		17	183			13						1	14			1							1			83			3			11	97	1	0	249	0	0	15	1	0	29	295	4			38						1	39			1							1	0	0	39	0	0	0	0	0	1	40
15	5			85			9			3	97			22							22			1							1										0	0	0	108	0	0	9	0	0	3	120	5			35			5				40			2							2	0	0	37	0	0	5	0	0	0	42
16	6			98		1	8		1	4	112			5			2				7										0			47							47	0	0	150	0	1	10	0	1	4	166	6			22			1			1	24			3			1			1	5	0	0	25	0	0	2	0	0	2	29
17	7			148		2	12			13	175			27		3	3				33										0			59			2			2	63	0	0	234	0	5	17	0	0	15	271	7			37			2			2	41			7							7	0	0	44	0	0	2	0	0	2	48
18	Sub	1	0	579	0	3	49	1	1	43	677	0	0	76	0	3	10	0	0	2	91	0	0	3	0	0	0	0	0	0	3	0	0	224	0	0	6	0	0	13	243	1	0	882	0	6	65	1	1	58	1,014	Sub	0	0	150	0	0	8	0	0	4	162	0	0	15	0	0	3	0	0	1	19	0	0	165	0	0	11	0	0	5	181
19	8			85			9			2	96			13							13										0			32			7				39	0	0	130	0	0	16	0	0	2	148	8			17			1			1	19										0	0	0	17	0	0	1	0	0	1	19
20	9			87			6			5	98			2			1				3										0			56						1	57	0	0	145	0	0	7	0	0	6	158	9			6			1				7										0	0	0	6	0	0	1	0	0	0	7
21	10										0										0										0										0	0	0	0	0	0	0	0	0	0	0	10										0										0	0	0	0	0	0	0	0	0	0	0
22	11			85			29			4	118			10							10										0			3			18			1	22	0	0	98	0	0	47	0	0	5	150	11			27			4			3	34										0	0	0	27	0	0	4	0	0	3	34
23	12			172			14			4	190			9							9									1	1			99							99	0	0	280	0	0	14	0	0	5	299	12			28			3			3	34										0	0	0	28	0	0	3	0	0	3	34
24	13			83		1	11		1	6	102			7							7			3			1				4			19			2				21	0	0	112	0	1	14	0	1	6	134	13			22						2	24			1							1	0	0	23	0	0	0	0	0	2	25
25	14			138			21			10	169			13							13			1							1			62			9			5	76	0	0	214	0	0	30	0	0	15	259	14			25			5			2	32			2							2	0	0	27	0	0	5	0	0	2	34
26	15			71			6	1		4	82			8							8										0			11							11	0	0	90	0	0	6	1	0	4	101	15			24			6			2	32			5							5	0	0	29	0	0	6	0	0	2	37
27	Sub	0	0	721	0	1	96	1	1	35	855	0	0	62	0	0	1	0	0	0	63	0	0	4	0	0	1	0	0	1	6	0	0	282	0	0	36	0	0	7	325	0	0	1,069	0	1	134	1	1	43	1,249	Sub	0	0	149	0	0	20	0	0	13	182	0	0	8	0	0	0	0	0	0	8	0	0	157	0	0	20	0	0	13	190
28	16			56			9			1	66			3						4	7										0			26							26	0	0	85	0	0	9	0	0	5	99	16			8			3			1	12										0	0	0	8	0	0	3	0	0	1	12
29	17										0										0										0										0	0	0	0	0	0	0	0	0	0	0	17										0										0	0	0	0	0	0	0	0	0	0	0
30	18			99	1		16	1	1	5	123			17			4				21										0				1		5		1	4	11	0	0	116	2	0	25	1	2	9	155	18			46			2			1	49			4							4	0	0	50	0	0	2	0	0	1	53
31	19			166			10			10	186			13							13										0			88							88	0	0	267	0	0	10	0	0	10	287	19			28			3			2	33			3			1				4	0	0	31	0	0	4	0	0	2	37
32	20			111			4			4	119			16			3			5	24										0			63							63	0	0	190	0	0	7	0	0	9	206	20			23			4			1	28										0	0	0	23	0	0	4	0	0	1	28
33	21			130			12			6	148			12			3				15			2							2			48			3			4	55	0	0	192	0	0	18	0	0	10	220	21			30				1		1	32			2							2	0	0	32	0	0	0	1	0	1	34
34	22	1		53			10				64	2		12						1	15										0										0	3	0	65	0	0	10	0	0	1	79	22			34							34			2							2	0	0	36	0	0	0	0	0	0	36
35	23			69			1			4	74			3							3										0			34							34	0	0	106	0	0	1	0	0	4	111	23			10			2			1	13										0	0	0	10	0	0	2	0	0	1	13
36	Sub	1	0	684	1	0	62	1	1	30	780	2	0	76	0	0	10	0	0	10	98	0	0	2	0	0	0	0	0	0	2	0	0	259	1	0	8	0	1	8	277	3	0	1,021	2	0	80	1	2	48	1,157	Sub	0	0	179	0	0	14	1	0	7	201	0	0	11	0	0	1	0	0	0	12	0	0	190	0	0	15	1	0	7	213
37	24										0										0										0										0	0	0	0	0	0	0	0	0	0	0	24										0										0	0	0	0	0	0	0	0	0	0	0
38	25			123		1	12			1	137			6							6			3							3			47							47	0	0	179	0	1	12	0	0	1	193	25			39			4			2	45			5							5	0	0	44	0	0	4	0	0	2	50
39	26			131			4			3	138			9							9			2							2			80							80	0	0	222	0	0	4	0	0	3	229	26			12			1			1	14										0	0	0	12	0	0	1	0	0	1	14
40	27			73			22			3	98			13						1	14			1							1			24			11			1	36	0	0	111	0	0	33	0	0	5	149	27			18			1			1	20										0	0	0	18	0	0	1	0	0	1	20
41	28	1		77			13			8	99			5							5			1						1	2			21			6			7	34	1	0	104	0	0	19	0	0	16	140	28			14						3	17										0	0	0	14	0	0	0	0	0	3	17
42	29			71			2	1		1	75			8			1			1	10										0			46							46	0	0	125	0	0	3	1	0	2	131	29			16							16										0	0	0	16	0	0	0	0	0	0	16
43	30			44			15			4	63			7							7										0			15			8				23	0	0	66	0	0	23	0	0	4	93	30			5							5										0	0	0	5	0	0	0	0	0	0	5
44	31										0										0										0										0	0	0	0	0	0	0	0	0	0	0	31										0										0	0	0	0	0	0	0	0	0	0	0
45	Sub	1	0	519	0	1	68	1	0	20	610	0	0	48	0	0	1	0	0	2	51	0	0	7	0	0	0	0	0	1	8	0	0	233	0	0	25	0	0	8	266	1	0	807	0	1	94	1	0	31	935	Sub	0	0	104	0	0	6	0	0	7	117	0	0	5	0	0	0	0	0	0	5	0	0	109	0	0	6	0	0	7	122
46	Total	3	0	2,503	1	5	275	4	3	128	2,922	2	0	262	0	3	22	0	0	14	303	0	0	16	0	0	1	0	0	2	19	0	0	998	1	0	75	0	1	36	1,111	5	0	3,779	2	8	373	4	4	180	4,355	Total	0	0	582	0	0	48	1	0	31	662	0	0	39	0	0	4	0	0	1	44	0	0	621	0	0	52	1	0	32	706
47
48
49																																																				PT. Jasa Raharja (Persero)
50																																																				Cabang Kalimantan Timur
51
52																																																				Data Jumlah Unit Kendaraan
53																																																				Periode Juni 2012
54																																																				Samsat Paymen Point Tanah Grogot
55
56																																																				Tanggal	Jenis Kendaraan
57																																																					Tahun Berjalan									Jumlah	Tahun Lalu									Jumlah	Total									Jumlah
58																																																					A	B	C1	C2	DU	DP	EU	EP	F	Jumlah	A	B	C1	C2	DU	DP	EU	EP	F	Jumlah	A	B	C1	C2	DU	DP	EU	EP	F	Jumlah
59																																																				1			25		1					26			3							3	0	0	28	0	1	0	0	0	0	29
60																																																				2										0										0	0	0	0	0	0	0	0	0	0	0
61																																																				3										0										0	0	0	0	0	0	0	0	0	0	0
62																																																				4			46			2				48			6			1				7	0	0	52	0	0	3	0	0	0	55
63																																																				5			53			4				57			6							6	0	0	59	0	0	4	0	0	0	63
64																																																				6			60		1	5			1	67			2							2	0	0	62	0	1	5	0	0	1	69
65																																																				7			44			2				46			9							9	0	0	53	0	0	2	0	0	0	55
66																																																				Sub	0	0	228	0	2	13	0	0	1	244	0	0	26	0	0	1	0	0	0	27	0	0	254	0	2	14	0	0	1	271
67																																																				8			49			1				50			5							5	0	0	54	0	0	1	0	0	0	55
68																																																				9										0										0	0	0	0	0	0	0	0	0	0	0
69																																																				10										0										0	0	0	0	0	0	0	0	0	0	0
70																																																				11			50			1			3	54			8							8	0	0	58	0	0	1	0	0	3	62
71																																																				12			39		1	3		1	2	46			5			1				6	0	0	44	0	1	4	0	1	2	52
72																																																				13			41			5			1	47			6							6	0	0	47	0	0	5	0	0	1	53
73																																																				14			44			1			2	47			8							8	0	0	52	0	0	1	0	0	2	55
74																																																				15			31			2			2	35			2							2	0	0	33	0	0	2	0	0	2	37
75																																																				Sub	0	0	254	0	1	13	0	1	10	279	0	0	34	0	0	1	0	0	0	35	0	0	288	0	1	14	0	1	10	314
76																																																				16										0										0	0	0	0	0	0	0	0	0	0	0
77																																																				17										0										0	0	0	0	0	0	0	0	0	0	0
78																																																				18			52			5				57			4							4	0	0	56	0	0	5	0	0	0	61
79																																																				19			21			1			1	23			1							1	0	0	22	0	0	1	0	0	1	24
80																																																				20			35			2			1	38			4							4	0	0	39	0	0	2	0	0	1	42
81																																																				21			36						2	38			7							7	0	0	43	0	0	0	0	0	2	45
82																																																				22			27			3			3	33			6							6	0	0	33	0	0	3	0	0	3	39
83																																																				23										0										0	0	0	0	0	0	0	0	0	0	0
84																																																				Sub	0	0	171	0	0	11	0	0	7	189	0	0	22	0	0	0	0	0	0	22	0	0	193	0	0	11	0	0	7	211
85																																																				24										0										0	0	0	0	0	0	0	0	0	0	0
86																																																				25			41			7			3	51			4							4	0	0	45	0	0	7	0	0	3	55
87																																																				26			26						2	28						1				1	0	0	26	0	0	1	0	0	2	29
88																																																				27			26			2			1	29			4							4	0	0	30	0	0	2	0	0	1	33
89																																																				28			29			3			1	33			1							1	0	0	30	0	0	3	0	0	1	34
90																																																				29			8						1	9			4						1	5	0	0	12	0	0	0	0	0	2	14
91																																																				30										0										0	0	0	0	0	0	0	0	0	0	0
92																																																				31										0										0	0	0	0	0	0	0	0	0	0	0
93																																																				Sub	0	0	130	0	0	12	0	0	8	150	0	0	13	0	0	1	0	0	1	15	0	0	143	0	0	13	0	0	9	165
94																																																				Total	0	0	783	0	3	49	0	1	26	862	0	0	95	0	0	3	0	0	1	99	0	0	878	0	3	52	0	1	27	961
95
96
97																																																				PT. Jasa Raharja (Persero)
98																																																				Cabang Kalimantan Timur
99
100																																																				Data Jumlah Unit Kendaraan