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
2660.0	ADMIN	BRANCH	March	1679044391237	WO23175077	ASRINDO CITRASENI SATRIA, PT	-	-	VT	FM37064T	B636628	23465	NON WARRANTY	RUNNING	-	DURI	PEKANBARU	Cruvise ctrl not function	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	TRISKI ADRIAN	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-03-17 16:13	2023-03-17 16:13	2023-03-17 16:30	2023-03-18 15:28	2023-03-17 16:30	2023-03-18 15:28	2023-03-20 08:24	2023-03-20 11:35	2023-03-30 11:28	1199.0	1395.0	64.0	YES	0.0
2661.0	ADMIN	BRANCH	March	1679044879064	WOCE175042	MACMAHON MINING SERVICES, PT	-	-	VCE	A60H	320531	1	WARRANTY	RUNNING	-	MARTABE	JAKARTA	Replace Electronic Unit	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Tomi Jullio	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-03-17 16:21	2023-03-17 16:22	2023-03-17 16:25	2023-03-17 16:25	2023-03-17 16:25	2023-03-17 16:25	2023-03-17 16:26	2023-03-17 16:26	2023-03-17 16:27	1199.0	4.0	0.0	YES	0.0
2662.0	ADMIN	BRANCH	March	1679045509018	WO23175005	MACMAHON MINING SERVICES, PT	-	-	VCE	A60H	320554	1	NON WARRANTY	STANDBY	-	MARTABE	JAKARTA	Commisioning A60H SN. 320554	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Tomi Jullio	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-03-17 16:31	2023-03-17 16:32	2023-03-17 16:34	2023-03-17 16:35	2023-03-17 16:34	2023-03-17 16:35	2023-03-17 16:35	2023-03-17 16:35	2023-03-17 16:36	1199.0	3.0	0.0	YES	1.0
2663.0	BRANCH	BRANCH	March	1679099754782	WOCE175119	PRIMA SARANA GEMILANG, PT	-	-	VCE	EC210D	253393	0	WARRANTY	STANDBY	2023-03-18 00:00:00.0000000	Sambarata	BERAU	replace weatherstrip	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	progress by mekanik on site from jkt	Syahrul	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-03-18 07:35	2023-03-18 07:36	2023-03-18 07:54	-	2023-03-18 07:54	-	2023-03-18 21:16	2023-03-18 21:19	2023-04-07 07:48	1199.0	10182.0	13.0	YES	0.0
2664.0	BRANCH	BRANCH	March	1679099920030	WOCE175114	PRIMA SARANA GEMILANG, PT	-	-	VCE	R60D	111071	3787	WARRANTY	STANDBY	2023-03-18 00:00:00.0000000	sambarata	BERAU	replace pressure switch	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	machine RFU	Syahrul	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-03-18 07:38	2023-03-18 07:38	2023-03-18 07:53	2023-03-18 09:12	2023-03-18 07:53	2023-03-18 09:14	2023-03-18 21:16	2023-03-18 21:18	2023-03-18 21:21	1199.0	94.0	13.0	YES	0.0
2665.0	BRANCH	BRANCH	March	1679100470701	WO23175110	PRIMA SURYA PUTRA, PT.	-	-	VCE	L90GZ	679596	11309	NON WARRANTY	BREAKDOWN	2023-03-18 00:00:00.0000000	PLTU teluk bayur	BERAU	water lines leak	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job closed	Ferdy	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-03-18 07:47	2023-03-18 07:48	2023-03-18 10:40	2023-03-18 13:17	2023-03-18 10:40	2023-03-18 13:17	2023-03-18 16:57	2023-03-18 17:39	2023-03-18 17:41	1199.0	329.0	9.0	YES	0.0
2666.0	ADMIN	MECHANIC	March	1679191136203	WO23175121	ADI JAYA BETON, PT	-	-	SDLG	E680F	607213	445	WARRANTY	RUNNING	2023-03-19 00:00:00.0000000	Bali	SURABAYA	Service 500 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job done	Muhammad Hatta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-03-19 08:58	2023-03-19 08:59	2023-03-19 09:12	2023-03-25 10:44	2023-03-19 09:12	2023-03-25 10:44	2023-03-25 21:11	2023-03-26 12:52	2023-03-30 08:48	1198.0	8745.0	156.0	YES	0.0
2667.0	ADMIN	MECHANIC	March	1679191397691	WO23175123	PUTRA ARYA SATYA, PT	-	-	SDLG	LG953L	622059	110	WARRANTY	RUNNING	2023-03-19 00:00:00.0000000	Bali	SURABAYA	Service 100 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job done	Ajik Pramusinta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-03-19 09:03	2023-03-19 09:03	2023-03-19 09:17	2023-03-21 12:41	2023-03-19 09:17	2023-03-21 12:41	2023-03-24 09:26	2023-03-30 08:40	2023-03-30 08:41	1197.0	3098.0	120.0	YES	0.0
2668.0	ADMIN	BRANCH	March	1679278985904	WO23175192	INDOTRUCK UTAMA, PT.	-	-	SDLG	E6138F	606349	8	DEMO / TRIAL	RUNNING	-	BUKIT KAPUR	PEKANBARU	Commisioning unit	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	BELLIARD SUSANTO	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-03-20 09:23	2023-03-20 09:23	2023-03-20 12:54	-	2023-03-20 12:54	-	2023-03-21 19:32	2023-03-22 18:18	2023-03-24 09:43	1196.0	-	34.0	YES	0.0
2669.0	ADMIN	BRANCH	March	1679281153524	WO23173714	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX44066R	894989	2500	NON WARRANTY	RUNNING	-	SANGA-SANGA	SAMARINDA	SERVICE 500 HRS ADT079	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Service 500 H done Unit ready for use	Marsono	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-03-20 09:59	2023-03-20 10:00	2023-03-20 10:00	2023-03-20 12:10	2023-03-20 10:00	2023-03-20 12:10	2023-03-20 16:10	2023-03-20 17:19	2023-03-20 17:21	1196.0	131.0	6.0	YES	0.0