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
2850.0	MECHANIC	MECHANIC	March	1679728194410	CC23175159	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	AA302275	2028	WARRANTY	RUNNING	2023-03-25 00:00:00.0000000	Bangko Barat, Muara Enim	MUARA ENIM	Schedule service 400 hours DT 3010-03	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Unit ready for use	Muhammad Zohran	Muhammad Zohran	082307126013	muhzohran@gmail.com	2023-03-25 14:09	2023-03-25 14:11	2023-03-25 14:26	2023-03-25 14:45	2023-03-25 14:26	2023-03-25 14:45	2023-03-25 18:40	2023-03-25 19:20	2023-03-25 19:23	1191.0	36.0	4.0	YES	1.0
2851.0	MECHANIC	MECHANIC	March	1679728283073	CC23175159	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	AA302275	-	WARRANTY	RUNNING	2023-03-25 00:00:00.0000000	Bangko barat muara enim	MUARA ENIM	Schedule Service 2000 hours DT 3010-03	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Complete and Ready	M. Riski Ibrahim	M. Riski Ibrahim	0895610719859	mriskiibrahim999@gmail.com	2023-03-25 14:11	2023-03-25 14:11	2023-03-25 14:33	2023-03-25 14:51	2023-03-25 14:33	2023-03-25 14:51	2023-03-26 05:36	2023-03-26 05:37	2023-03-26 05:38	1191.0	40.0	15.0	YES	0.0
2852.0	MECHANIC	MECHANIC	March	1679729388857	WO23174633	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898900	3781	WARRANTY	BREAKDOWN	2023-03-25 00:00:00.0000000	BATUAH	SAMARINDA	DIFF MID BROKEN VT72	ETC	OTHER	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE ( REMOVE DIFFERENTIAL MID FMX400 VT72)	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-03-25 14:29	2023-03-25 14:30	2023-03-25 14:30	2023-03-25 15:33	2023-03-25 14:30	2023-03-25 15:33	2023-03-25 17:57	2023-03-25 18:54	2023-03-25 18:55	1191.0	64.0	3.0	YES	0.0
2853.0	BRANCH	BRANCH	March	1679793577203	23175902	INDOTRUCK UTAMA, PT.	-	-	VB	B11R	212380	-	WARRANTY	STANDBY	-	PELABUHAN IKT	JAKARTA	Replace solenoid valve VCB engine brake B11R Eu5 212380, warranty	ENGINE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Eko Suharyanto	Rahman Dendi	081388101230	rahman_dendi@yahoo.com	2023-03-26 08:19	2023-03-26 08:28	2023-03-28 09:43	2023-03-28 10:36	2023-03-28 09:43	2023-03-28 10:36	2023-03-28 15:42	2023-03-28 15:49	2023-03-29 16:39	1191.0	3016.0	55.0	YES	8.0
2854.0	BRANCH	BRANCH	March	1679793740367	23175908	INDOTRUCK UTAMA, PT.	-	-	VB	B11R	212417	-	WARRANTY	STANDBY	-	PELABUHAN IKT	JAKARTA	Replace solenoid valve VCB engine brake B11R Eu5 212417, warranty	ENGINE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Eko Suharyanto	Rahman Dendi	081388101230	rahman_dendi@yahoo.com	2023-03-26 08:22	2023-03-26 08:26	2023-03-28 09:43	2023-03-28 10:35	2023-03-28 09:43	2023-03-28 10:35	2023-03-28 15:41	2023-03-28 15:49	2023-03-29 16:35	1191.0	3014.0	55.0	YES	3.0
2855.0	ADMIN	BRANCH	March	1679881648760	WO23175206	DINAS PEKERJAAN UMUM KOTA MEDAN	-	-	VCE	EC55D	233824	515	WARRANTY	RUNNING	2023-03-27 00:00:00.0000000	Medan	MEDAN	Mandatory Service 500 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Andrianto	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-03-27 08:47	2023-03-27 08:47	2023-03-27 09:12	2023-03-28 09:13	2023-03-27 09:12	2023-03-28 09:13	2023-03-28 09:18	2023-03-28 15:18	2023-03-28 15:19	1190.0	1466.0	24.0	YES	0.0
2856.0	ADMIN	BRANCH	March	1679883374685	WO23173721	AKMAL JAYA PERKASA PT	-	-	SDLG	L956F	624362	331	NON WARRANTY	RUNNING	-	TENGGARONG	SAMARINDA	SERVICE 250 HRS	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-03-27 09:16	2023-03-27 09:17	2023-03-27 09:17	2023-03-27 11:00	2023-03-27 09:17	2023-03-27 11:00	2023-03-27 17:40	2023-03-27 17:42	2023-03-27 17:43	1189.0	104.0	8.0	YES	0.0
2857.0	BRANCH	BRANCH	March	1679364413198	WO23175615	PRIMA SARANA GEMILANG, PT	-	-	VCE	EC950E	380428	500	WARRANTY	STANDBY	2023-03-21 00:00:00.0000000	Sambarata	BERAU	service 500 hrs	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job closed	Syahrul	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-03-21 09:06	2023-03-21 09:09	2023-03-21 09:51	2023-03-21 11:21	2023-03-21 09:51	2023-03-21 11:21	2023-03-21 20:31	2023-03-21 20:32	2023-03-22 16:10	1195.0	134.0	11.0	YES	2.0
2858.0	ADMIN	BRANCH	March	1679364442015	WO23174322	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324771	1	WARRANTY	STANDBY	-	MUARA LAWAI	MUARA ENIM	Commissioning new unit A40G SN 324771 LDA	ENGINE	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampe kantor	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-03-21 09:07	2023-03-21 09:07	2023-03-31 11:06	2023-03-31 11:40	2023-03-31 11:06	2023-03-31 11:40	2023-03-31 13:05	2023-03-31 13:50	2023-03-31 13:52	1195.0	46.0	2.0	YES	0.0
2859.0	ADMIN	BRANCH	March	1679365012641	WO23174362	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324768	1	WARRANTY	STANDBY	-	MUARA LAWAI	MUARA ENIM	T/s parking brake not active AD72 SN 324768 LDA	BRAKE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	Ichsan Ali Rosidi	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-03-21 09:16	2023-03-21 09:17	2023-03-31 11:04	2023-03-31 11:36	2023-03-31 11:04	2023-03-31 11:36	2023-03-31 13:01	2023-03-31 13:48	2023-03-31 13:52	1195.0	40.0	2.0	YES	0.0