Monthly Report Dashboard

Sl No	Inquiry Source	Input Source	Job Created Month	Booking Id	WO Number	Customer Name	Customer Phone	Customer PIC	Product	Unit Model	Serial Number	Hour Meter	Unit Status	Unit Condition	Failure Date	Location	Branch Support	Issue	Function Group	Service Code	Service Type	Job Code	Job Group	Job Description	Creator Group	Status	Status Note	Note	Mechanic Name	Creator Name	Creator Phone	Creator Email	Job Created	First Responce Time	OTW to Site	Arrive On Site	OTW to Site Final	Arrive On Site Final	Back To Office	Arrive in Branch Office	Completed Date	Aging	ART	MTTR	FTF	FRT
1070.0	ADMIN	BRANCH	January	1675127164379	23171783	TAMBANG BUKIT TAMBI, PT.	-	-	VCE	A40E	12684	16772	NON WARRANTY	BREAKDOWN	-	PADANG KELAPO	JAMBI	TROUBLE SHOOTING FAN MOTOR UP NORMAL & CHECK ERROR BY VTT	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job competed note : di lokasi tidak ada jaringan	Teten Kurniyawan	Karlina Aulia Fitri JMB ADMIN	081366256191	serviceadmin.jambi@indotruck-utama.co.id	2023-01-31 08:06	2023-01-31 08:06	2023-01-31 09:50	2023-02-03 13:04	2023-01-31 09:50	2023-02-03 13:04	2023-02-03 13:07	2023-02-03 16:56	2023-02-03 16:57	1245.0	4618.0	77.0	YES	0.0
1071.0	BRANCH	BRANCH	January	1675129030033	WO23171518	BIMA NUSA INTERNASIONAL, PT	-	-	VCE	EC480DL	274724	25813	NON WARRANTY	RUNNING	2023-01-31 00:00:00.0000000	Gerogot	BALIKPAPAN	MIP EC480DL SN274724 HM25813 PT BNI	ETC	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	a	victor julius	Novan miftakhul rozak	081331838430	admin.vcrm@indotruck-utama.co.id	2023-01-31 08:37	2023-01-31 08:37	2023-02-18 15:41	2023-02-19 09:17	2023-02-18 15:41	2023-02-19 09:17	2023-02-24 07:13	2023-02-25 07:18	2023-02-25 07:18	1245.0	27401.0	574.0	YES	0.0
1072.0	BRANCH	BRANCH	January	1675129284024	WO23170226	INDOTRUCK UTAMA, PT.	-	-	VCE	R100E	111017	4000	STOK	STANDBY	2023-01-31 00:00:00.0000000	Balikpapan	BALIKPAPAN	Repair R100E SN111017 Stock Balikpapan	ETC	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	a	Nova Ardianto	Novan miftakhul rozak	081331838430	admin.vcrm@indotruck-utama.co.id	2023-01-31 08:41	2023-01-31 08:42	2023-01-31 08:42	2023-01-31 08:42	2023-01-31 08:42	2023-01-31 08:42	2023-02-06 10:42	2023-02-06 10:42	2023-02-06 10:42	1245.0	1.0	146.0	YES	0.0
1073.0	BRANCH	BRANCH	January	1675137280365	23171797	BINTANG UTARA PUTRA, PT	-	-	VB	B11R	208557	40230	WARRANTY	RUNNING	2023-01-31 00:00:00.0000000	Workshop ITU Medan	MEDAN	Basic Service II	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Completed	Joys Alfedro Siregar	Annisa Shaila Ambar Wulan	081361470025	shailadithia@gmail.com	2023-01-31 10:54	2023-01-31 10:54	2023-02-27 14:42	2023-02-27 14:53	2023-02-27 14:42	2023-02-27 14:53	2023-02-27 19:29	2023-02-27 19:43	2023-02-27 19:49	1244.0	39119.0	656.0	YES	0.0
1074.0	BRANCH	CALL CENTER	January	1675137440198	WO23171804	DINAS SUMBER DAYA AIR PROVINSI DKI JAKARTA	-	-	VCE	EC210BLC	77536	1	NON WARRANTY	STANDBY	-	HALIM	JAKARTA	Pengechekan XS-23	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Ibnu Nasir	Arief Wiratman JKT ADMIN	081316041299	arief.wiratman@indotruck-utama.co.id	2023-01-31 10:57	2023-01-31 10:57	2023-01-31 11:17	2023-01-31 11:41	2023-01-31 11:17	2023-01-31 11:41	2023-01-31 17:33	2023-01-31 17:33	2023-01-31 17:33	1244.0	44.0	6.0	YES	0.0
1075.0	ADMIN	BRANCH	January	1675143773402	WO23171801	BONGKOTAN JATI UTAMA, PT.	-	-	VB	B11R	YV3T2T423LA199260	-	NON WARRANTY	RUNNING	2023-01-31 00:00:00.0000000	JEPARA	SEMARANG	YV3T2T423LA199260 WO23171801 T/S Air System and Retarder Malfunction VB B11R VB BONGKOTAN JATI UTAMA, PT. 2696 ITU-000009726 SRWE Created Triyono Smg	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	9	Andri Kurniawan	Muchammad Rivkhi Indiarta	083838871090	rivkhi.indiarta@indotruck-utama.co.id	2023-01-31 12:42	2023-01-31 12:43	2023-01-31 12:43	2023-01-31 12:43	2023-01-31 12:43	2023-01-31 12:43	2023-01-31 17:25	2023-01-31 17:25	2023-01-31 17:25	1244.0	1.0	4.0	YES	0.0
1076.0	ADMIN	BRANCH	January	1674884516826	23171652	ALFERO MINERAL SEJAHTERA, PT	-	-	VCE	A40F	13431	12000	NON WARRANTY	RUNNING	2023-01-28 00:00:00.0000000	Bengkulu utara	BENGKULU	troubleshooting brake system	BRAKE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Agus Nugroho	Ari Sofyan	085228555522	admsvc.bengkulu@indotruck-utama.co.id	2023-01-28 12:41	2023-01-28 12:42	2023-01-28 13:11	2023-01-28 15:23	2023-01-28 13:11	2023-01-28 15:23	2023-01-30 14:29	2023-01-30 16:50	2023-01-30 16:50	1247.0	161.0	49.0	YES	0.0
1077.0	BRANCH	BRANCH	January	1674887711038	23171290	BUKIT ASAM ( Persero ) TBK., PT	-	-	VCE	EC480DL	284488	-	WARRANTY	STANDBY	2023-01-28 00:00:00.0000000	Banko, Muara Enim	MUARA ENIM	PM 1.250 Hours EXCA3010-06	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Change engine oil, replace fuel filter oil filter, clean air cleaner filter AC, download matris	Aris Setiawan	Aditya Pratama Branch Head Muara Enim	082280065515	adityajogja2013@gmail.com	2023-01-28 13:35	2023-01-28 13:35	-	-	-	-	-	-	2023-01-28 13:48	1247.0	-	-	NO	0.0
1078.0	MECHANIC	MECHANIC	January	1675042993611	WO23171371	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	899295	0	WARRANTY	RUNNING	2023-01-30 00:00:00.0000000	batuah	SAMARINDA	service 250hrs	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Arman Maulana Saputra	Arman Maulana Saputra	082352031001	arman.maulana1072@gmail.com	2023-01-30 08:43	2023-01-30 08:43	2023-01-30 08:43	2023-01-30 13:20	2023-01-30 08:43	2023-01-30 13:20	2023-01-31 05:20	2023-01-31 08:18	2023-01-31 08:18	1246.0	277.0	20.0	YES	0.0
1079.0	MECHANIC	MECHANIC	January	1675043102807	WO23171371	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	899295	0	WARRANTY	RUNNING	2023-01-30 00:00:00.0000000	Batuah	SAMARINDA	Service 250H	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	completed	Ricky Belo Padang	Ricky Belo Padang	082246158497	rickybelopadang16@gmail.com	2023-01-30 08:45	-	2023-01-30 08:45	2023-01-30 13:21	2023-01-30 08:45	2023-01-30 13:21	2023-01-31 17:15	2023-02-01 07:14	2023-02-01 07:15	1246.0	277.0	32.0	YES	-