Mei - 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 Mei 2013																																																			Periode Mei 2013
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	DP	DU	EP	EU	F	Jumlah	A	B	C1	C2	DP	DU	EP	EU	F	Jumlah	A	B	C1	C2	DP	DU	EP	EU	F	Jumlah	A	B	C1	C2	DP	DU	EP	EU	F	Jumlah	A	B	C1	C2	DP	DU	EP	EU	F	Jumlah		A	B	C1	C2	DP	DU	EP	EU	F	Jumlah	A	B	C1	C2	DP	DU	EP	EU	F	Jumlah	A	B	C1	C2	DP	DU	EP	EU	F	Jumlah
11	1			42		7	1			2	52			14		2				1	17										0					3					3	0	0	56	0	12	1	0	0	3	72	1			16						1	17										0	0	0	16	0	0	0	0	0	1	17
12	2			81		5				5	91			4							4										0			8							8	0	0	93	0	5	0	0	0	5	103	2			22		1					23			3							3	0	0	25	0	1	0	0	0	0	26
13	3			45		11	1			6	63			16						1	17										0					2					2	0	0	61	0	13	1	0	0	7	82	3			19						1	20			3		1					4	0	0	22	0	1	0	0	0	1	24
14	4			42		9			1	2	54			9						1	10			1							1					1					1	0	0	52	0	10	0	0	1	3	66	4			6							6			1							1	0	0	7	0	0	0	0	0	0	7
15	5										0										0										0										0	0	0	0	0	0	0	0	0	0	0	5										0										0	0	0	0	0	0	0	0	0	0	0
16	6			96		7				2	105			13							13			2							2			2							2	0	0	113	0	7	0	0	0	2	122	6			25		3				2	30			4							4	0	0	29	0	3	0	0	0	2	34
17	7			180		8				3	191			42						4	46									1	1			90							90	0	0	312	0	8	0	0	0	8	328	7			22						1	23			1							1	0	0	23	0	0	0	0	0	1	24
18	Sub	0	0	486	0	47	2	0	1	20	556	0	0	98	0	2	0	0	0	7	107	0	0	3	0	0	0	0	0	1	4	0	0	100	0	6	0	0	0	0	106	0	0	687	0	55	2	0	1	28	773	Sub	0	0	110	0	4	0	0	0	5	119	0	0	12	0	1	0	0	0	0	13	0	0	122	0	5	0	0	0	5	132
19	8			223		20	1	1		9	254			13		2				3	18										0			133		11		1		3	148	0	0	369	0	33	1	2	0	15	420	8			17		7				1	25			2							2	0	0	19	0	7	0	0	0	1	27
20	9										0										0										0										0	0	0	0	0	0	0	0	0	0	0	9										0										0	0	0	0	0	0	0	0	0	0	0
21	10			68		3		1		2	74			18		2					20					1					1										0	0	0	86	0	6	0	1	0	2	95	10			23		2				4	29										0	0	0	23	0	2	0	0	0	4	29
22	11			51		4				2	57			20						1	21			1						1	2			2		2				2	6	0	0	74	0	6	0	0	0	6	86	11			10		2					12			2							2	0	0	12	0	2	0	0	0	0	14
23	12										0										0										0										0	0	0	0	0	0	0	0	0	0	0	12										0										0	0	0	0	0	0	0	0	0	0	0
24	13			123		6		1		3	133			24							24					2					2			26				1			27	0	0	173	0	8	0	2	0	3	186	13			43		2			1		46			5							5	0	0	48	0	2	0	0	1	0	51
25	14			107		13		2		4	126			15						4	19					1					1			27		8		2			37	0	0	149	0	22	0	4	0	8	183	14			17		3				3	23										0	0	0	17	0	3	0	0	0	3	23
26	15			129		9				10	148			7		1				2	10										0			68		4				7	79	0	0	204	0	14	0	0	0	19	237	15			25		3					28										0	0	0	25	0	3	0	0	0	0	28
27	Sub	0	0	701	0	55	1	5	0	30	792	0	0	97	0	5	0	0	0	10	112	0	0	1	0	4	0	0	0	1	6	0	0	256	0	25	0	4	0	12	297	0	0	1,055	0	89	1	9	0	53	1,207	Sub	0	0	135	0	19	0	0	1	8	163	0	0	9	0	0	0	0	0	0	9	0	0	144	0	19	0	0	1	8	172
28	16			66		8				2	76			16							16			3							3										0	0	0	85	0	8	0	0	0	2	95	16			32		3				2	37			1							1	0	0	33	0	3	0	0	0	2	38
29	17			95		17	1		2	4	119			22							22			1		1					2			55		6				4	65	0	0	173	0	24	1	0	2	8	208	17			29		2				1	32			2							2	0	0	31	0	2	0	0	0	1	34
30	18			31		1				3	35			11							11			1							1										0	0	0	43	0	1	0	0	0	3	47	18			13		1				1	15										0	0	0	13	0	1	0	0	0	1	15
31	19										0										0										0										0	0	0	0	0	0	0	0	0	0	0	19										0										0	0	0	0	0	0	0	0	0	0	0
32	20			86		7				4	97			12		1					13			2							2										0	0	0	100	0	8	0	0	0	4	112	20			35		2					37			9							9	0	0	44	0	2	0	0	0	0	46
33	21			101		6		2		2	111			16							16										0			50		1		1		1	53	0	0	167	0	7	0	3	0	3	180	21			12						1	13			1							1	0	0	13	0	0	0	0	0	1	14
34	22			108		9				3	120			15		4					19										0			34							34	0	0	157	0	13	0	0	0	3	173	22			16						1	17			5							5	0	0	21	0	0	0	0	0	1	22
35	23			205		8				5	218			6		5					11									1	1			149						1	150	0	0	360	0	13	0	0	0	7	380	23			28		2				1	31			5							5	0	0	33	0	2	0	0	0	1	36
36	Sub	0	0	692	0	56	1	2	2	23	776	0	0	98	0	10	0	0	0	0	108	0	0	7	0	1	0	0	0	1	9	0	0	288	0	7	0	1	0	6	302	0	0	1,085	0	74	1	3	2	30	1,195	Sub	0	0	165	0	10	0	0	0	7	182	0	0	23	0	0	0	0	0	0	23	0	0	188	0	10	0	0	0	7	205
37	24			102		17		1	1	6	127			8							8			1							1			62		15		1		4	82	0	0	173	0	32	0	2	1	10	218	24			25		2				2	29			1							1	0	0	26	0	2	0	0	0	2	30
38	25										0										0										0										0	0	0	0	0	0	0	0	0	0	0	25										0										0	0	0	0	0	0	0	0	0	0	0
39	26										0										0										0										0	0	0	0	0	0	0	0	0	0	0	26										0										0	0	0	0	0	0	0	0	0	0	0
40	27			79		12	1			3	95			23		4				3	30			2		1					3			3							3	0	0	107	0	17	1	0	0	6	131	27			37		2				3	42			1							1	0	0	38	0	2	0	0	0	3	43
41	28			68		11				6	85			11		2				4	17										0			14		4					18	0	0	93	0	17	0	0	0	10	120	28			17							17			1						2	3	0	0	18	0	0	0	0	0	2	20
42	29			162		5		2		1	170			11				1		1	13										0			113		2		1			116	0	0	286	0	7	0	4	0	2	299	29			20							20			4							4	0	0	24	0	0	0	0	0	0	24
43	30			76		3			1	3	83			12							12										0			42							42	0	0	130	0	3	0	0	1	3	137	30			21		3				1	25			2							2	0	0	23	0	3	0	0	0	1	27
44	31			34		13				1	48			14							14										0			12		7					19	0	0	60	0	20	0	0	0	1	81	31			8		2					10			6		1					7	0	0	14	0	3	0	0	0	0	17
45	Sub	0	0	521	0	61	1	3	2	20	608	0	0	79	0	6	0	1	0	8	94	0	0	3	0	1	0	0	0	0	4	0	0	246	0	28	0	2	0	4	280	0	0	849	0	96	1	6	2	32	986	Sub	0	0	128	0	9	0	0	0	6	143	0	0	15	0	1	0	0	0	2	18	0	0	143	0	10	0	0	0	8	161
46	Total	0	0	2,400	0	219	5	10	5	93	2,732	0	0	372	0	23	0	1	0	25	421	0	0	14	0	6	0	0	0	3	23	0	0	890	0	66	0	7	0	22	985	0	0	3,676	0	314	5	18	5	143	4,161	Total	0	0	538	0	42	0	0	1	26	607	0	0	59	0	2	0	0	0	2	63	0	0	597	0	44	0	0	1	28	670
47
48
49																																																				PT. Jasa Raharja (Persero)
50																																																				Cabang Kalimantan Timur
51
52																																																				Data Jumlah Unit Kendaraan
53																																																				Periode Mei 2013
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	DP	DU	EP	EU	F	Jumlah	A	B	C1	C2	DP	DU	EP	EU	F	Jumlah	A	B	C1	C2	DP	DU	EP	EU	F	Jumlah
59																																																				1			27							27			7							7	0	0	34	0	0	0	0	0	0	34
60																																																				2			33		1					34			5							5	0	0	38	0	1	0	0	0	0	39
61																																																				3			27		2					29			6							6	0	0	33	0	2	0	0	0	0	35
62																																																				4										0										0	0	0	0	0	0	0	0	0	0	0
63																																																				5										0										0	0	0	0	0	0	0	0	0	0	0
64																																																				6			52		2				1	55			5							5	0	0	57	0	2	0	0	0	1	60
65																																																				7			50		2					52			9		1					10	0	0	59	0	3	0	0	0	0	62
66																																																				Sub	0	0	189	0	7	0	0	0	1	197	0	0	32	0	1	0	0	0	0	33	0	0	221	0	8	0	0	0	1	230
67																																																				8			39		1					40			6							6	0	0	45	0	1	0	0	0	0	46
68																																																				9										0										0	0	0	0	0	0	0	0	0	0	0
69																																																				10			56		4			1		61			10							10	0	0	66	0	4	0	0	1	0	71
70																																																				11										0										0	0	0	0	0	0	0	0	0	0	0
71																																																				12										0										0	0	0	0	0	0	0	0	0	0	0
72																																																				13			63		2			1	3	69			5							5	0	0	68	0	2	0	0	1	3	74
73																																																				14			45		3					48			4		1					5	0	0	49	0	4	0	0	0	0	53
74																																																				15			38		2					40			2							2	0	0	40	0	2	0	0	0	0	42
75																																																				Sub	0	0	241	0	12	0	0	2	3	258	0	0	27	0	1	0	0	0	0	28	0	0	268	0	13	0	0	2	3	286
76																																																				16			38		3				2	43			8							8	0	0	46	0	3	0	0	0	2	51
77																																																				17			37		1					38			4							4	0	0	41	0	1	0	0	0	0	42
78																																																				18										0										0	0	0	0	0	0	0	0	0	0	0
79																																																				19										0										0	0	0	0	0	0	0	0	0	0	0
80																																																				20			46		3					49			5							5	0	0	51	0	3	0	0	0	0	54
81																																																				21			31						1	32			2							2	0	0	33	0	0	0	0	0	1	34
82																																																				22			37		2		2			41			3							3	0	0	40	0	2	0	2	0	0	44
83																																																				23			44		1	1				46			3							3	0	0	47	0	1	1	0	0	0	49
84																																																				Sub	0	0	233	0	10	1	2	0	3	249	0	0	25	0	0	0	0	0	0	25	0	0	258	0	10	1	2	0	3	274
85																																																				24			33		5			1		39			3							3	0	0	36	0	5	0	0	1	0	42
86																																																				25										0										0	0	0	0	0	0	0	0	0	0	0
87																																																				26										0										0	0	0	0	0	0	0	0	0	0	0
88																																																				27			60		2				1	63			9							9	0	0	69	0	2	0	0	0	1	72
89																																																				28			28		4				1	33			14							14	0	0	42	0	4	0	0	0	1	47
90																																																				29			20		1	2				23										0	0	0	20	0	1	2	0	0	0	23
91																																																				30			22		3					25			3							3	0	0	25	0	3	0	0	0	0	28
92																																																				31			23		1					24			1							1	0	0	24	0	1	0	0	0	0	25
93																																																				Sub	0	0	186	0	16	2	0	1	2	207	0	0	30	0	0	0	0	0	0	30	0	0	216	0	16	2	0	1	2	237
94																																																				Total	0	0	849	0	45	3	2	3	9	911	0	0	114	0	2	0	0	0	0	116	0	0	963	0	47	3	2	3	9	1,027
95
96
97																																																				PT. Jasa Raharja (Persero)
98																																																				Cabang Kalimantan Timur
99
100																																																				Data Jumlah Unit Kendaraan