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
4560.0	ADMIN	BRANCH	May	1684811746074	WOCE179125	BERKAH ANUGERAH RIZQI ABADI COAL PT	-	-	VCE	A40G	324094	6480	NON WARRANTY	STANDBY	2023-05-16 00:00:00.0000000	SATUI	BANJARMASIN	INSTAL TRANSMISI A40G SN 324094	TRANSMISSION	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Handover mechanic	Ahmad Ridwansyah	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-05-23 10:15	2023-05-23 10:15	2023-06-15 10:38	2023-06-15 10:39	2023-06-15 10:38	2023-06-15 10:39	2023-06-15 10:39	2023-06-15 10:40	2023-06-15 13:55	1132.0	33143.0	552.0	YES	0.0
4561.0	ADMIN	BRANCH	May	1684811942923	WO23179108	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	888942	8056	NON WARRANTY	RUNNING	-	SANGA-SANGA	SAMARINDA	SERVICE 4000 HRS VT051	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	ready for use	Heru Priyoga	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-23 10:19	2023-05-23 10:19	2023-05-23 10:19	2023-05-23 10:56	2023-05-23 10:19	2023-05-23 10:56	2023-05-23 16:54	2023-05-23 18:40	2023-05-23 19:24	1132.0	37.0	6.0	YES	0.0
4562.0	ADMIN	BRANCH	May	1684826843776	WOCE179418	ARRALI JAYA ABADI, CV	-	-	VCE	EC210D	232102	1	WARRANTY	STANDBY	-	JAYAPURA	SORONG	Campaign EMQ52	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch office	Service koordinator (Sorong - Nusa tenggara)	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-05-23 14:27	2023-05-23 14:27	2023-05-24 18:22	2023-05-24 18:23	2023-05-24 18:22	2023-05-24 18:23	2023-05-24 18:24	2023-05-27 13:21	2023-05-31 13:26	1132.0	1676.0	27.0	YES	0.0
4563.0	ADMIN	BRANCH	May	1684828421889	WO23179839	JAGAAMAN SARANA, PT	-	-	VCE	EC350D	271007	8364	NON WARRANTY	RUNNING	-	LUWUK BUNTA	PALU	INSPECTION ENGINE BLACK SMOKE, CHECK PERFORMANCE INJECTOR&FUEL DELUTION EC350D	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	JOB DONE & UNIT RFU	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-05-23 14:53	2023-05-23 14:54	2023-05-23 14:55	2023-05-23 20:12	2023-05-23 14:55	2023-05-23 20:12	2023-05-23 23:06	2023-05-26 15:10	2023-05-26 16:19	1132.0	319.0	8.0	YES	0.0
4564.0	ADMIN	BRANCH	May	1684835005914	WO23179602	ARRALI JAYA ABADI, CV	-	-	VCE	EC210D	232102	1	WARRANTY	STANDBY	2023-05-23 00:00:00.0000000	Jayapura	SORONG	Commissioning Unit	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch office	Service koordinator (Sorong - Nusa tenggara)	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-05-23 16:43	2023-05-23 16:43	2023-05-24 11:20	2023-05-24 18:19	2023-05-24 11:20	2023-05-24 18:19	2023-05-24 18:21	2023-05-27 13:21	2023-05-30 16:54	1132.0	1536.0	25.0	YES	0.0
4565.0	ADMIN	BRANCH	May	1684887397603	WO 23179614	I WAYAN SUPADIYASA	-	-	SDLG	E660FL	625847	450	WARRANTY	RUNNING	-	TOILI-LUWUK	PALU	FREE SERVICE&PART HM500 E660FL SN625847	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	JOB DONE, UNIT RFU	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-05-24 07:16	2023-05-24 07:17	2023-05-24 07:17	2023-05-24 14:42	2023-05-24 07:17	2023-05-24 14:42	2023-05-24 19:06	2023-05-26 15:09	2023-05-26 16:19	1132.0	446.0	11.0	YES	0.0
4566.0	ADMIN	BRANCH	May	1684892373100	WO23179895	NUANSA ALAM KHATULISTIWA, PT	-	-	VCE	EC210D	231852	983	WARRANTY	RUNNING	-	KONAWE UTARA	KENDARI	Inspection and troubleshooting EC210D SN231935	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Debysantoso	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-05-24 08:39	2023-05-24 08:39	2023-05-24 08:58	2023-05-24 12:57	2023-05-24 08:58	2023-05-24 12:57	2023-05-26 13:28	2023-05-27 04:04	2023-05-29 07:43	1132.0	258.0	52.0	YES	0.0
4567.0	ADMIN	BRANCH	May	1684892817957	WO23179646	KRAKATAU JASA LOGISTIK, PT.	-	-	VCE	L250G	1031	32000	NON WARRANTY	STANDBY	2023-05-24 00:00:00.0000000	Ciwandan	CILEGON	Troubleshooting Engine can't Star & Alterntor not Charging	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Completed	Rizqin Aminullah	Cilegon Admin	85219742046	cilegon.sbs@indotruck-utama.co.id	2023-05-24 08:46	2023-05-24 08:47	2023-05-24 09:02	2023-05-24 10:16	2023-05-24 09:02	2023-05-24 10:16	2023-05-24 16:23	2023-05-24 17:21	2023-05-25 09:21	1132.0	89.0	7.0	YES	0.0
4568.0	ADMIN	BRANCH	May	1684894001683	WO23179628	GARUDA EXA, CV.	-	-	VCE	EC210D	283034	5639	WARRANTY	STANDBY	2023-05-24 00:00:00.0000000	Terbanggi besar	LAMPUNG	Free Inspecrtion	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Pekerjaan selesai	Rheno Bayu Saputro	Lampung Admin	81366256194	lampung.sbs@indotruck-utama.co.id	2023-05-24 09:06	-	2023-05-24 09:07	2023-05-24 15:16	2023-05-24 09:07	2023-05-24 15:16	2023-05-29 18:29	2023-05-29 19:45	2023-05-30 19:30	1131.0	370.0	129.0	YES	-
4569.0	ADMIN	BRANCH	May	1684894185471	WO23179629	BERKAT ANUGERAH AGUNG, PT	-	-	SDLG	L956F	624726	-	WARRANTY	STANDBY	2023-05-24 00:00:00.0000000	Gresik	SURABAYA	Service 1500 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Dwi Setiawan	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-05-24 09:09	2023-05-24 09:09	2023-05-24 09:26	2023-05-24 13:46	2023-05-24 09:26	2023-05-24 13:46	2023-05-24 16:15	2023-05-24 17:07	2023-05-25 14:09	1131.0	277.0	7.0	YES	0.0