Juli - 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 Juli 2013																																																			Periode Juli 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			54		12				3	69			10		3					13										0					7				1	8	0	0	64	0	22	0	0	0	4	90	1			21							21			2							2	0	0	23	0	0	0	0	0	0	23
12	2			59		6			1	1	67			7		1					8										0					1					1	0	0	66	0	8	0	0	1	1	76	2			14		1			1		16										0	0	0	14	0	1	0	0	1	0	16
13	3			53		15				2	70			23							23										0			3		5					8	0	0	79	0	20	0	0	0	2	101	3			29		3				2	34			3						1	4	0	0	32	0	3	0	0	0	3	38
14	4			111		11				4	126			19							19					2				1	3			55		5				2	62	0	0	185	0	18	0	0	0	7	210	4			19		2					21			2							2	0	0	21	0	2	0	0	0	0	23
15	5			165		6				3	174			21							21					1					1			90							90	0	0	276	0	7	0	0	0	3	286	5			19							19			5							5	0	0	24	0	0	0	0	0	0	24
16	6			60		6				1	67			12		2					14										0										0	0	0	72	0	8	0	0	0	1	81	6			11						1	12										0	0	0	11	0	0	0	0	0	1	12
17	7										0										0										0										0	0	0	0	0	0	0	0	0	0	0	7										0										0	0	0	0	0	0	0	0	0	0	0
18	Sub	0	0	502	0	56	0	0	1	14	573	0	0	92	0	6	0	0	0	0	98	0	0	0	0	3	0	0	0	1	4	0	0	148	0	18	0	0	0	3	169	0	0	742	0	83	0	0	1	18	844	Sub	0	0	113	0	6	0	0	1	3	123	0	0	12	0	0	0	0	0	1	13	0	0	125	0	6	0	0	1	4	136
19	8			162		17		1	1	6	187			29		3	2			4	38										0			39		12				3	54	0	0	230	0	32	2	1	1	13	279	8			41		4				1	46			3		2					5	0	0	44	0	6	0	0	0	1	51
20	9			118		6				6	130			12						8	20			1							1										0	0	0	131	0	6	0	0	0	14	151	9			35		1					36			4							4	0	0	39	0	1	0	0	0	0	40
21	10			98		18		1			117			25		10					35			1		1				1	3					7					7	0	0	124	0	36	0	1	0	1	162	10			39		3				1	43			3		1					4	0	0	42	0	4	0	0	0	1	47
22	11			265		13				2	280			32		4					36			1							1			204		5				1	210	0	0	502	0	22	0	0	0	3	527	11			12		4					16			2		4					6	0	0	14	0	8	0	0	0	0	22
23	12			79		5				1	85			10		3				4	17			1							1			10							10	0	0	100	0	8	0	0	0	5	113	12			19		1				1	21			6							6	0	0	25	0	1	0	0	0	1	27
24	13			34		4			1	1	40			9		2				12	23									2	2										0	0	0	43	0	6	0	0	1	15	65	13			13		2					15			1							1	0	0	14	0	2	0	0	0	0	16
25	14										0										0										0										0	0	0	0	0	0	0	0	0	0	0	14										0										0	0	0	0	0	0	0	0	0	0	0
26	15			107		14			1	3	125			21		1					22			1							1					1					1	0	0	129	0	16	0	0	1	3	149	15			50		2					52			3							3	0	0	53	0	2	0	0	0	0	55
27	Sub	0	0	863	0	77	0	2	3	19	964	0	0	138	0	23	2	0	0	28	191	0	0	5	0	1	0	0	0	3	9	0	0	253	0	25	0	0	0	4	282	0	0	1,259	0	126	2	2	3	54	1,446	Sub	0	0	209	0	17	0	0	0	3	229	0	0	22	0	7	0	0	0	0	29	0	0	231	0	24	0	0	0	3	258
28	16			248		6		1		4	259			18		4					22										0			180		2		1		3	186	0	0	446	0	12	0	2	0	7	467	16			16		1			1	3	21			1							1	0	0	17	0	1	0	0	1	3	22
29	17			97		7			1		105			40		1					41									1	1										0	0	0	137	0	8	0	0	1	1	147	17			41		6					47			3							3	0	0	44	0	6	0	0	0	0	50
30	18			149		18				9	176			32						4	36			1							1			59		10				3	72	0	0	241	0	28	0	0	0	16	285	18			28		4				2	34			2							2	0	0	30	0	4	0	0	0	2	36
31	19			67		8				2	77			20		4					24										0					2					2	0	0	87	0	14	0	0	0	2	103	19			10		2					12										0	0	0	10	0	2	0	0	0	0	12
32	20			79		1	1			1	82			15							15										0			43							43	0	0	137	0	1	1	0	0	1	140	20			12		2		1		1	16			3							3	0	0	15	0	2	0	1	0	1	19
33	21										0										0										0										0	0	0	0	0	0	0	0	0	0	0	21										0										0	0	0	0	0	0	0	0	0	0	0
34	22			154		11				3	168			28		7	1				36			2							2			40							40	0	0	224	0	18	1	0	0	3	246	22			46		4				1	51			6		4					10	0	0	52	0	8	0	0	0	1	61
35	23			115		7				3	125			36							36			2							2			30							30	0	0	183	0	7	0	0	0	3	193	23			20		3				1	24										0	0	0	20	0	3	0	0	0	1	24
36	Sub	0	0	909	0	58	1	1	1	22	992	0	0	189	0	16	1	0	0	4	210	0	0	5	0	0	0	0	0	1	6	0	0	352	0	14	0	1	0	6	373	0	0	1,455	0	88	2	2	1	33	1,581	Sub	0	0	173	0	22	0	1	1	8	205	0	0	15	0	4	0	0	0	0	19	0	0	188	0	26	0	1	1	8	224
37	24	1		138		8			1	1	149			17		3					20										0			58		4					62	1	0	213	0	15	0	0	1	1	231	24			41		1				1	43			5							5	0	0	46	0	1	0	0	0	1	48
38	25			177		9				6	192			24							24										0			123		4				5	132	0	0	324	0	13	0	0	0	11	348	25			39		2				2	43			4							4	0	0	43	0	2	0	0	0	2	47
39	26			114		6	1			3	124			21		4	4				29			1							1			55							55	0	0	191	0	10	5	0	0	3	209	26			17							17										0	0	0	17	0	0	0	0	0	0	17
40	27			49		5					54			23		8					31			2							2			7							7	0	0	81	0	13	0	0	0	0	94	27			7		2				1	10										0	0	0	7	0	2	0	0	0	1	10
41	28										0										0										0										0	0	0	0	0	0	0	0	0	0	0	28										0										0	0	0	0	0	0	0	0	0	0	0
42	29			193		7			1	5	206			34						5	39					1					1			90							90	0	0	317	0	8	0	0	1	10	336	29			39		4				2	45			5							5	0	0	44	0	4	0	0	0	2	50
43	30			185		22		2		11	220			25		10				1	36										0			114		15		2		7	138	0	0	324	0	47	0	4	0	19	394	30			22		4				1	27										0	0	0	22	0	4	0	0	0	1	27
44	31			82		9				3	94			32		2					34										0					1					1	0	0	114	0	12	0	0	0	3	129	31			21		2	1				24			2							2	0	0	23	0	2	1	0	0	0	26
45	Sub	1	0	938	0	66	1	2	2	29	1,039	0	0	176	0	27	4	0	0	6	213	0	0	3	0	1	0	0	0	0	4	0	0	447	0	24	0	2	0	12	485	1	0	1,564	0	118	5	4	2	47	1,741	Sub	0	0	186	0	15	1	0	0	7	209	0	0	16	0	0	0	0	0	0	16	0	0	202	0	15	1	0	0	7	225
46	Total	1	0	3,212	0	257	2	5	7	84	3,568	0	0	595	0	72	7	0	0	38	712	0	0	13	0	5	0	0	0	5	23	0	0	1,200	0	81	0	3	0	25	1,309	1	0	5,020	0	415	9	8	7	152	5,612	Total	0	0	681	0	60	1	1	2	21	766	0	0	65	0	11	0	0	0	1	77	0	0	746	0	71	1	1	2	22	843
47
48
49																																																				PT. Jasa Raharja (Persero)
50																																																				Cabang Kalimantan Timur
51
52																																																				Data Jumlah Unit Kendaraan
53																																																				Periode Juli 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			39		3				1	43			5							5	0	0	44	0	3	0	0	0	1	48
60																																																				2			44		2					46			3							3	0	0	47	0	2	0	0	0	0	49
61																																																				3			28		4				1	33			7							7	0	0	35	0	4	0	0	0	1	40
62																																																				4			42		3	1				46			3							3	0	0	45	0	3	1	0	0	0	49
63																																																				5			35						1	36			3							3	0	0	38	0	0	0	0	0	1	39
64																																																				6										0										0	0	0	0	0	0	0	0	0	0	0
65																																																				7										0										0	0	0	0	0	0	0	0	0	0	0
66																																																				Sub	0	0	188	0	12	1	0	0	3	204	0	0	21	0	0	0	0	0	0	21	0	0	209	0	12	1	0	0	3	225
67																																																				8			65		6				3	74			14							14	0	0	79	0	6	0	0	0	3	88
68																																																				9			101		6				3	110			14							14	0	0	115	0	6	0	0	0	3	124
69																																																				10			55		7					62			1							1	0	0	56	0	7	0	0	0	0	63
70																																																				11			47		1				1	49			6							6	0	0	53	0	1	0	0	0	1	55
71																																																				12			33		4					37			3							3	0	0	36	0	4	0	0	0	0	40
72																																																				13										0										0	0	0	0	0	0	0	0	0	0	0
73																																																				14										0										0	0	0	0	0	0	0	0	0	0	0
74																																																				15			71		3					74			9							9	0	0	80	0	3	0	0	0	0	83
75																																																				Sub	0	0	372	0	27	0	0	0	7	406	0	0	47	0	0	0	0	0	0	47	0	0	419	0	27	0	0	0	7	453
76																																																				16			49		2				1	52			6							6	0	0	55	0	2	0	0	0	1	58
77																																																				17			57		1					58			10							10	0	0	67	0	1	0	0	0	0	68
78																																																				18			57		2					59			2							2	0	0	59	0	2	0	0	0	0	61
79																																																				19			42							42			1							1	0	0	43	0	0	0	0	0	0	43
80																																																				20										0										0	0	0	0	0	0	0	0	0	0	0
81																																																				21										0										0	0	0	0	0	0	0	0	0	0	0
82																																																				22			80		7				1	88			7							7	0	0	87	0	7	0	0	0	1	95
83																																																				23			40		5					45			4							4	0	0	44	0	5	0	0	0	0	49
84																																																				Sub	0	0	325	0	17	0	0	0	2	344	0	0	30	0	0	0	0	0	0	30	0	0	355	0	17	0	0	0	2	374
85																																																				24			40		4				2	46			3		1					4	0	0	43	0	5	0	0	0	2	50
86																																																				25			59		2	2			1	64			5		1					6	0	0	64	0	3	2	0	0	1	70
87																																																				26			23		5					28			5							5	0	0	28	0	5	0	0	0	0	33
88																																																				27										0										0	0	0	0	0	0	0	0	0	0	0
89																																																				28										0										0	0	0	0	0	0	0	0	0	0	0
90																																																				29			82		4				1	87			10							10	0	0	92	0	4	0	0	0	1	97
91																																																				30			37		1					38			3							3	0	0	40	0	1	0	0	0	0	41
92																																																				31			42		3					45			8							8	0	0	50	0	3	0	0	0	0	53
93																																																				Sub	0	0	283	0	19	2	0	0	4	308	0	0	34	0	2	0	0	0	0	36	0	0	317	0	21	2	0	0	4	344
94																																																				Total	0	0	1,168	0	75	3	0	0	16	1,262	0	0	132	0	2	0	0	0	0	134	0	0	1,300	0	77	3	0	0	16	1,396
95
96
97																																																				PT. Jasa Raharja (Persero)
98																																																				Cabang Kalimantan Timur
99
100																																																				Data Jumlah Unit Kendaraan