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
4060.0	ADMIN	BRANCH	May	1683356362791	WOCE178482	MANDIRI INTI PERKASA, PT	-	-	VCE	L350F	3104	3784	WARRANTY	RUNNING	-	SESAYAP	TARAKAN	INSTALL PART WARRANTY L350H	ECT	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Complete Reporting	rendy	Tarakan Admin	89538317607	tarakan.sbs@indotruck-utama.co.id	2023-05-06 13:59	2023-05-06 13:59	2023-05-06 14:03	2023-05-06 16:00	2023-05-06 14:03	2023-05-06 16:00	2023-05-10 14:24	2023-05-10 16:13	2023-05-10 16:14	1149.0	121.0	96.0	YES	0.0
4061.0	MECHANIC	MECHANIC	May	1683407861112	.	JHONLIN BARATAMA, PT	-	-	VCE	A40G	-	-	WARRANTY	RUNNING	2023-05-07 00:00:00.0000000	Batulicin	BANJARMASIN	Monitoring Unit operation	ETC	OTHER	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	.	Widianto	Widianto	085705256615	widi10anto@gmail.com	2023-05-07 04:17	2023-05-07 04:17	2023-05-07 04:18	2023-05-07 05:48	2023-05-07 04:18	2023-05-07 05:48	2023-05-07 17:26	2023-05-07 18:42	2023-05-07 18:42	1149.0	91.0	13.0	YES	0.0
4062.0	MECHANIC	MECHANIC	May	1683505909361	WO23178308	FARINDA BERSAUDARA, PT	-	-	SDLG	L933L	606447	250	WARRANTY	RUNNING	2023-05-08 00:00:00.0000000	Bongan	SAMARINDA	SDLG933L PS250H	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-05-08 07:31	2023-05-08 07:32	2023-05-08 07:32	2023-05-08 07:32	2023-05-08 07:32	2023-05-08 07:32	2023-05-12 04:17	2023-05-12 04:17	2023-05-12 04:17	1148.0	1.0	92.0	YES	0.0
4063.0	ADMIN	BRANCH	May	1683510227272	WO23178442	SARANA AGUNG PERKASA, PT	-	-	VCE	EC210B	76824	1	NON WARRANTY	BREAKDOWN	2023-05-08 00:00:00.0000000	Larantuka	SURABAYA	Troubleshoot unit can't running	ETC	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Muhammad Hatta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-05-08 08:43	2023-05-08 08:43	2023-05-08 09:01	2023-05-09 09:07	2023-05-08 09:01	2023-05-09 09:07	2023-05-16 17:46	2023-05-17 09:58	2023-05-17 09:59	1148.0	1464.0	201.0	YES	0.0
4064.0	ADMIN	BRANCH	May	1683512951100	WO23178406	TERMINAL PETIKEMAS SURABAYA, PT	-	-	VT	FM44064R	A888996	-	WARRANTY	STANDBY	2023-05-08 00:00:00.0000000	Surabaya	SURABAYA	Campaign S2386	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Rudi Saputra	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-05-08 09:29	2023-05-08 09:29	2023-05-08 12:26	2023-05-08 13:35	2023-05-08 12:26	2023-05-08 13:35	2023-05-10 09:45	2023-05-10 09:46	2023-05-10 10:06	1147.0	247.0	48.0	YES	0.0
4065.0	ADMIN	BRANCH	May	1683515926045	WO23178453	BINTANG UTARA PUTRA, PT	-	-	VB	B11R	208524	100	WARRANTY	RUNNING	-	MEDAN	MEDAN	Mandatory Service Volvo Bus B11R SN 208524	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	bto	Andrianto	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-05-08 10:18	2023-05-08 10:19	2023-05-08 13:47	2023-05-08 13:47	2023-05-08 13:47	2023-05-08 13:47	2023-05-08 17:04	2023-05-09 09:01	2023-05-09 09:01	1147.0	209.0	6.0	YES	0.0
4066.0	ADMIN	BRANCH	May	1683522413490	WO23178566	SUMBER MITRA JAYA, PT	-	-	SDLG	LG936	-	-	NON WARRANTY	RUNNING	-	PEKALONGAN	SEMARANG	WO23178566 REPAIR & REPLACE ADDITIONAL PARTS BRAKE SYSTEM WL1010/WL9301 OTH 1186 ITU-000008861 SRWE Created Triyono Smg 5/8/2023 60.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-05-08 12:06	2023-05-08 12:10	2023-05-11 09:20	2023-05-11 09:20	2023-05-11 09:20	2023-05-11 09:20	2023-05-11 17:59	2023-05-11 17:59	2023-05-11 18:00	1147.0	4154.0	77.0	YES	3.0
4067.0	ADMIN	BRANCH	May	1683522479835	WO23178576	SUMBER MITRA JAYA, PT	-	-	SDLG	LG936L	-	-	NON WARRANTY	RUNNING	-	PEKALONGAN	SEMARANG	WO23178576 REPLACE WO 21164658 GOH ENGINE WL1010 SDLG 936L OTH 1186 ITU-000008861 SRWE Created Triyono Smg 5/8/2023 139.00	ENGINE	OVERHAUL	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-05-08 12:07	2023-05-08 12:09	2023-05-11 09:21	2023-05-11 09:21	2023-05-11 09:21	2023-05-11 09:21	2023-05-13 11:09	2023-05-13 11:09	2023-05-13 11:09	1147.0	2.0	49.0	YES	1.0
4068.0	ADMIN	BRANCH	May	1683525065390	WO23178579	MALLOROANG JAYA TRANS, PT	-	-	SDLG	E6210F	609701	10	WARRANTY	RUNNING	2023-05-08 00:00:00.0000000	Malili	MAKASSAR	Commissioning and Field Guidance	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	wahyu sugiono	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-05-08 12:51	2023-05-08 12:51	2023-05-08 12:54	2023-05-09 06:55	2023-05-08 12:54	2023-05-09 06:55	2023-05-10 07:59	2023-05-11 14:54	2023-05-13 06:38	1147.0	1084.0	43.0	YES	0.0
4069.0	MECHANIC	MECHANIC	May	1683586864972	.	JHONLIN BARATAMA, PT	-	-	VCE	A40G	-	-	WARRANTY	RUNNING	2023-05-09 00:00:00.0000000	Batulicin	BANJARMASIN	monitoring unit	ETC	OTHER	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	.	Widianto	Widianto	085705256615	widi10anto@gmail.com	2023-05-09 06:01	2023-05-09 06:01	2023-05-09 06:01	2023-05-09 06:01	2023-05-09 06:01	2023-05-09 06:01	2023-05-09 17:00	2023-05-10 05:14	2023-05-10 05:14	1147.0	0.0	10.0	YES	0.0