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
3840.0	ADMIN	BRANCH	May	1683093814048	WOSD178350	TRAKARYA TRANSPORTASI RIZKA JAYA, PT	-	-	SDLG	E660FL	625749	643	WARRANTY	STANDBY	2023-05-03 00:00:00.0000000	metro	LAMPUNG	INPECTION,TROUBLE SHOTING HOUSE PUMP HYDROLIK	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Pekerjaan selesai	Heri Sucipto	Lampung Admin	81366256194	lampung.sbs@indotruck-utama.co.id	2023-05-03 13:03	2023-05-03 13:04	2023-05-03 13:05	2023-05-03 15:28	2023-05-03 13:05	2023-05-03 15:28	2023-05-03 18:43	2023-05-04 07:08	2023-05-04 14:34	1152.0	145.0	5.0	YES	0.0
3841.0	MECHANIC	MECHANIC	May	1683095086954	000377	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	408249	990	WARRANTY	RUNNING	2023-05-03 00:00:00.0000000	MSF bangko barat	MUARA ENIM	pm 200 h DT 3010-11	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Redy pm 200 hours DT 3010-11	Deka Ali Septia J	Deka Ali Septia J	081272820949	dekajaya81893@gmail.com	2023-05-03 13:24	2023-05-03 13:25	2023-05-03 13:26	-	2023-05-03 13:26	-	2023-05-03 16:12	2023-05-03 16:48	2023-05-03 16:48	1152.0	-	2.0	YES	0.0
3842.0	MECHANIC	MECHANIC	May	1683109459846	WOCE178833	INDOTRUCK UTAMA, PT.	-	-	VCE	EC480DL	285081	5.9	STOK	RUNNING	2023-05-03 00:00:00.0000000	Yard Purwakarta	JAKARTA	Campaign W-ECU 4.1	ELECTRICAL	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive on office at 19.00 03/05/23	Yusuf Rhama Dhani	Yusuf Rhama Dhani	082129756665	rhamay076@gmail.com	2023-05-03 17:24	2023-05-03 17:24	2023-05-03 17:25	2023-05-03 17:27	2023-05-03 17:25	2023-05-03 17:27	2023-05-03 17:27	2023-05-05 10:39	2023-05-16 16:56	1152.0	3.0	0.0	YES	0.0
3843.0	MECHANIC	MECHANIC	April	1682817841566	WO23176604	BINTANG ALAM REJEKI, PT.	-	-	VCE	A40G	324760	500	WARRANTY	RUNNING	2023-04-30 00:00:00.0000000	sanga-sanga	SAMARINDA	B160 PS500H	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DINE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-04-30 08:24	2023-04-30 08:24	2023-04-30 08:24	2023-04-30 15:13	2023-04-30 08:24	2023-04-30 15:13	2023-04-30 17:36	2023-04-30 17:36	2023-04-30 17:36	1156.0	409.0	9.0	YES	0.0
3844.0	MECHANIC	MECHANIC	April	1682854022510	--	PRIMA SARANA MUSTIKA, PT	-	-	SDLG	E6210F	0609403	-	WARRANTY	BREAKDOWN	2023-04-30 00:00:00.0000000	Kuala Kurun,Kalteng	BANJARMASIN	Engine White Smoke	ENGINE	REPAIR	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	UNIT BREAKDOWN .REPORTING FOR CLAIM WARANTY	Piter Setiawan	Piter Setiawan	081227300498	setiawanpiter1@gmail.com	2023-04-30 18:27	2023-04-30 18:29	2023-04-30 18:30	2023-04-30 18:30	2023-04-30 18:30	2023-04-30 18:30	-	-	2023-04-30 18:36	1155.0	3.0	-	YES	2.0
3845.0	MECHANIC	MECHANIC	May	1682918036567	000377	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	302342	2570	WARRANTY	RUNNING	2023-05-01 00:00:00.0000000	MSF Bangko barat	MUARA ENIM	PM 200 hours DT3010-04	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Redy pm 200 hours DT 3010-04 start 13.00-15.00	Deka Ali Septia J	Deka Ali Septia J	081272820949	dekajaya81893@gmail.com	2023-05-01 12:13	2023-05-01 12:14	2023-05-01 12:15	2023-05-01 12:48	2023-05-01 12:15	2023-05-01 12:48	2023-05-01 14:49	2023-05-01 15:53	2023-05-01 15:54	1154.0	35.0	2.0	YES	0.0
3846.0	MECHANIC	MECHANIC	May	1682984157183	WO23177912	BINTANG ALAM REJEKI, PT.	-	-	VCE	A40G	13351	31500	NON WARRANTY	RUNNING	2023-05-02 00:00:00.0000000	muara badak	SAMARINDA	B114 PS500H	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-05-02 06:35	2023-05-02 06:36	2023-05-02 06:37	2023-05-02 20:50	2023-05-02 06:37	2023-05-02 20:50	2023-05-02 20:52	2023-05-02 20:53	2023-05-02 20:54	1154.0	854.0	14.0	YES	1.0
3847.0	BRANCH	BRANCH	May	1682992961264	WO23179910	PRIMA SARANA GEMILANG, PT	-	-	VCE	R60D	111090	1000	WARRANTY	RUNNING	2023-05-02 00:00:00.0000000	sambarata	BERAU	Service 1000 Hrs	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job closed	Syahrul	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-05-02 09:02	2023-05-02 09:04	2023-05-02 09:06	2023-05-02 09:56	2023-05-02 09:06	2023-05-02 09:56	2023-05-02 18:07	2023-05-02 19:04	2023-05-02 19:28	1153.0	54.0	9.0	YES	1.0
3848.0	ADMIN	BRANCH	May	1682995546909	WOCE178266	HILLCON JAYASAKTI, PT	-	-	VCE	A60H	320500	2414	WARRANTY	RUNNING	2023-05-02 00:00:00.0000000	KOTABARU	BANJARMASIN	REAR CAMERA FAIL	ETC	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	replace reverse camera cek monitor kamera (ok) take foto	Wardani	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-05-02 09:45	2023-05-02 09:46	-	-	-	-	-	-	2023-05-14 14:47	1153.0	-	-	YES	0.0
3849.0	ADMIN	BRANCH	May	1682998374689	WOCE178263	TITIAN TRANS ENERGY, PT	-	-	VCE	A60H	320473	-	NON WARRANTY	BREAKDOWN	-	TABANG	SAMARINDA	ENGINE PROBLEM, REPLACE INJECTOR	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Replace injector done machine RFU	rendi juliadi	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-02 10:32	2023-05-02 10:33	2023-05-02 10:34	2023-05-03 20:45	2023-05-02 10:34	2023-05-03 20:45	2023-05-12 12:44	2023-05-13 07:40	2023-05-13 07:42	1153.0	2052.0	242.0	YES	0.0