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
3881.0	BRANCH	BRANCH	May	1683074853775	WO23180100	LANTANA MULTI MINERAL, PT	-	-	VT	FMX44084R-I SHIFT	300099	0	WARRANTY	STANDBY	2023-05-03 00:00:00.0000000	Site Kjb	BERAU	Replace servo pipe	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job closed	Irwan Hermawan	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-05-03 07:47	2023-05-03 07:47	2023-05-03 07:52	2023-05-03 08:47	2023-05-12 07:46	2023-05-12 08:54	2023-05-12 17:23	2023-05-12 18:09	2023-05-12 18:25	1136.0	60.0	9.0	NO	0.0
3882.0	ADMIN	BRANCH	May	1683077196750	WO23178328	LESTARI WAHYU UTAMA, PT.	-	-	VCE	EC210D	282589	43169	NON WARRANTY	BREAKDOWN	2023-05-03 00:00:00.0000000	Transmart Manado	MANADO	Troubleshooting Engine Low Power	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job troubleshooting engine low power done	Riandy Hamzah	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2023-05-03 08:26	2023-05-03 08:26	2023-05-03 08:56	2023-05-03 10:36	2023-05-03 08:56	2023-05-03 10:36	2023-05-03 13:52	2023-05-03 14:47	2023-05-05 10:21	1136.0	130.0	5.0	YES	0.0
3883.0	ADMIN	BRANCH	May	1683077934229	WO23178306	GUNUNG HARTA TRANSPORT SOLUTIONS, PT.	-	-	VB	B11R	A198123	18054	NON WARRANTY	BREAKDOWN	2023-05-03 00:00:00.0000000	Malang	SURABAYA	TS Engine Low Power	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Reynaldi Gilang Prayoga	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-05-03 08:38	2023-05-03 08:39	2023-05-03 09:11	2023-05-03 11:41	2023-05-03 09:11	2023-05-03 11:41	2023-05-03 15:10	2023-05-03 16:32	2023-05-03 16:34	1136.0	183.0	6.0	YES	0.0
3884.0	ADMIN	BRANCH	May	1683078026644	WO23178430	NI'MA LAMANDI	-	-	VCE	EC210D	283259	3801	NON WARRANTY	BREAKDOWN	-	TIPO	PALU	Low Power engine	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	ARRIVE IN BRANCH OFFICE	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-05-03 08:40	2023-05-03 08:40	2023-05-03 08:56	2023-05-03 10:23	2023-05-03 08:56	2023-05-03 10:23	2023-05-04 07:58	2023-05-04 09:18	2023-05-08 14:05	1136.0	103.0	23.0	YES	0.0
3885.0	ADMIN	BRANCH	May	1683078152432	WO23177939	PQ SILICAS INDONESIA, PT	-	-	VT	FM37064R	A761266	-	NON WARRANTY	STANDBY	2023-05-03 00:00:00.0000000	Pasuruan	SURABAYA	Replace Brake Cylinder	BRAKE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Rudi Saputra	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-05-03 08:42	2023-05-03 09:12	2023-05-03 09:13	2023-05-03 11:37	2023-05-03 09:13	2023-05-03 11:37	2023-05-03 14:28	2023-05-03 16:33	2023-05-03 16:34	1136.0	175.0	5.0	YES	30.0
3886.0	ADMIN	BRANCH	May	1683078463139	WO23178383	INTERNATIONAL GREEN ENERGY PT	-	-	SDLG	L956F	624029	1657	NON WARRANTY	RUNNING	-	BUTON	PEKANBARU	Brake problem	BRAKE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai ITU	DARMO SUWITO	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-03 08:47	2023-05-03 08:47	2023-05-04 09:37	2023-05-04 13:59	2023-05-04 09:37	2023-05-04 13:59	2023-05-04 16:03	2023-05-04 19:56	2023-05-05 08:43	1136.0	291.0	6.0	YES	0.0
3887.0	MECHANIC	MECHANIC	May	1683078909599	.	JHONLIN BARATAMA, PT	-	-	VCE	A40G	324510	3282	WARRANTY	BREAKDOWN	2023-05-03 00:00:00.0000000	Serongga Tanah Bumbu, KalSel	BANJARMASIN	Coolant pump leak	ENGINE	REPAIR	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	make Report & part recomendation	Widianto	Widianto	085705256615	widi10anto@gmail.com	2023-05-03 08:55	2023-05-03 08:55	2023-05-03 08:55	2023-05-03 08:55	2023-05-03 08:55	2023-05-03 08:55	2023-05-03 17:27	2023-05-04 04:22	2023-05-04 04:23	1136.0	1.0	8.0	YES	0.0
3888.0	MECHANIC	MECHANIC	May	1683079318043	000377	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	314573	989	WARRANTY	RUNNING	2023-05-03 00:00:00.0000000	Msf bangko barat	MUARA ENIM	pm 200 hours DT 3010-12	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Redy pm 200 h star job 09.00-11.00	Deka Ali Septia J	Deka Ali Septia J	081272820949	dekajaya81893@gmail.com	2023-05-03 09:01	2023-05-03 09:03	2023-05-03 09:04	2023-05-03 09:23	2023-05-03 09:04	2023-05-03 09:23	2023-05-03 10:45	2023-05-03 13:21	2023-05-03 13:22	1136.0	21.0	1.0	YES	1.0
3889.0	ADMIN	BRANCH	May	1683079896525	WO23178326	HASIAN BINTANG PERSADA, PT.	-	-	SDLG	G9138	600597	500	WARRANTY	RUNNING	-	MEDAN	MEDAN	Mandatory Service 500 Hours LG 9138 F SN 600597	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	finish	Ferdian Dinata	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-05-03 09:11	2023-05-03 09:16	2023-05-03 15:14	2023-05-04 12:25	2023-05-03 15:14	2023-05-04 12:25	2023-05-06 09:20	2023-05-06 19:08	2023-05-06 19:09	1136.0	1633.0	72.0	YES	4.0
3890.0	ADMIN	BRANCH	May	1683079928892	WO23178335	GUNA AGUNG SEMESTA, PT.	-	-	SDLG	E6210F	609321	250	WARRANTY	RUNNING	-	LIBO	PEKANBARU	Service 250 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sqmpai kantor itu	DARMO SUWITO	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-03 09:12	2023-05-03 09:12	2023-05-03 09:36	2023-05-03 12:00	2023-05-03 09:36	2023-05-03 12:00	2023-05-03 16:32	2023-05-03 19:54	2023-05-05 15:54	1136.0	168.0	7.0	YES	0.0