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
1870.0	MECHANIC	MECHANIC	February	1677326693150	0	JAGA USAHA SANDAI, PT	-	-	VCE	EC300DL	-	-	NON WARRANTY	STANDBY	2023-02-25 00:00:00.0000000	sandai	PONTIANAK	low rpm and suddenly shuts down	ENGINE	INSPECTION	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	completed	Doni Ardiansyah	Doni Ardiansyah	081285851832	ardiansyahdoni69@gmail.com	2023-02-25 19:04	2023-02-25 19:05	2023-02-25 19:05	2023-02-25 19:05	2023-02-25 19:05	2023-02-25 19:05	2023-02-26 17:01	2023-03-04 17:07	2023-03-06 07:18	1219.0	1.0	21.0	YES	0.0
1871.0	MECHANIC	MECHANIC	February	1677327367726	0	JAGA USAHA SANDAI, PT	-	-	VCE	EC300DL	271531	16555	NON WARRANTY	STANDBY	2023-02-25 00:00:00.0000000	Sandau	PONTIANAK	troubleshoot Low rpm and suddenly shutsdown	ENGINE	INSPECTION	RE-DO	-	-	-	LEADER	COMPLETED	COMPLETED	completed	catur muhamad rahmadhan	Catur Muhamad Rahmadhan	082256483951	caturfreedom@gmail.com	2023-02-25 19:16	2023-02-26 10:47	2023-02-26 10:47	2023-02-26 17:00	2023-02-26 10:47	2023-02-26 17:00	2023-02-28 08:58	2023-03-03 18:00	2023-03-06 07:19	1219.0	1304.0	61.0	YES	931.0
1872.0	MECHANIC	MECHANIC	February	1677419861484	401	BAHTERA PUTERA NUSANTARA, PT.	-	-	VT	FH16 64T	Pm60015	30471	NON WARRANTY	RUNNING	2023-02-26 00:00:00.0000000	SLR km 36	MUARA ENIM	Kaca head lamp lh kabur/ buram	ELECTRICAL	REPAIR	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Repair & Combine head lamp assy, action remove glass head lamp, cleanning, & install to unit, connect cable, tes tfunction lamp	Jumingan	Jumingan	085271117559	jumingan.volvo@gmail.com	2023-02-26 20:57	-	-	-	-	-	-	-	2023-02-26 22:39	1218.0	-	-	YES	-
1873.0	BRANCH	BRANCH	February	1677461394385	WO23173078	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898639	3500	NON WARRANTY	RUNNING	2023-02-27 00:00:00.0000000	Batuah	SAMARINDA	service 500hrs VT061	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Erni Wati	082353253757	admin.service.smd@indotruck-utama.co.id	2023-02-27 08:29	2023-02-27 08:30	2023-02-27 08:30	2023-02-27 15:01	2023-02-27 08:30	2023-02-27 15:01	2023-02-27 17:46	2023-02-27 20:00	2023-02-27 20:01	1218.0	392.0	9.0	YES	0.0
1874.0	MECHANIC	MECHANIC	February	1676959625152	173126	ULIMA NITRA, PT	-	-	VCE	EC480DL	270267	1164	WARRANTY	RUNNING	2023-02-21 00:00:00.0000000	SITE DBU	MUARA ENIM	replace altenator	ELECTRICAL	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	finish job replace altenator	Nurwandi Maulana	Nurwandi Maulana	082310710326	nurwandimaulana88@gmail.com	2023-02-21 13:07	-	-	-	-	-	-	-	2023-02-21 17:20	1223.0	-	-	YES	-
1875.0	BRANCH	BRANCH	February	1676962417884	21166794	DELI PRATAMA COAL, PT	-	-	VCE	EC300DL	271542	5601	NON WARRANTY	STANDBY	2023-02-14 00:00:00.0000000	KELUMPANG SELATAN	BANJARMASIN	REPAIR CYLINDER HEAD & REPLACE GASKET EC300DL SN271542	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	after install cylinder head unit rfu	Junaidi Arsyandi	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-02-21 13:53	2023-02-21 13:53	2023-02-28 12:14	2023-02-28 16:46	2023-02-28 12:14	2023-02-28 16:46	2023-03-04 12:04	2023-03-07 10:41	2023-03-07 10:41	1223.0	10253.0	262.0	YES	0.0
1876.0	BRANCH	BRANCH	February	1676965062346	WO23173507	INDOTRUCK UTAMA, PT.	-	-	SDLG	E660FL	625728	6.9	STOK	STANDBY	2023-02-21 00:00:00.0000000	palaran	SAMARINDA	Predelivery Inspection (PDI)	ENGINE	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Completed	Ricky Belo Padang	Erni Wati	082353253757	admin.service.smd@indotruck-utama.co.id	2023-02-21 14:37	2023-02-21 14:37	2023-02-21 14:38	2023-02-21 14:49	2023-02-21 14:38	2023-02-21 14:49	2023-02-21 17:29	2023-02-21 18:25	2023-02-21 18:26	1223.0	12.0	2.0	YES	0.0
1877.0	BRANCH	BRANCH	February	1676965477221	WO23173505	STRAITS MINING SERVICES, PT	-	-	SDLG	L956L	624702	494	Warranty	RUNNING	2023-02-21 00:00:00.0000000	Tabang	SAMARINDA	service 1000hrs	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	unit rfu arrive on office	rezana	Erni Wati	082353253757	admin.service.smd@indotruck-utama.co.id	2023-02-21 14:44	2023-02-21 14:44	2023-02-21 14:45	2023-02-22 08:36	2023-02-21 14:45	2023-02-22 08:36	2023-02-22 15:30	2023-02-22 22:53	2023-02-22 22:54	1223.0	1071.0	24.0	YES	0.0
1878.0	BRANCH	BRANCH	February	1676969774685	23173216	CAKRAWALA KENCANA INDONESIA, PT	-	-	VCE	A40G	324778	1	WARRANTY	RUNNING	2023-02-20 00:00:00.0000000	GAMBUT BARAT	BANJARMASIN	COMMISSIONING UNIT A40G SN324778	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Ridwan Wahyu	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-02-21 15:56	2023-02-21 15:56	2023-02-22 11:15	2023-02-22 11:16	2023-02-22 11:15	2023-02-22 11:16	2023-02-22 11:19	2023-02-22 11:21	2023-02-22 11:21	1223.0	1160.0	19.0	YES	0.0
1879.0	ADMIN	BRANCH	February	1676970939745	23173380	BARA PRIMA PRATAMA, PT	-	-	VT	FMX44084R-I SHIFT	B374717	19224	WARRANTY	RUNNING	-	BATU AMPAR	JAMBI	CAMPAIGN S2754	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Bagas Kurniansah	Karlina Aulia Fitri JMB ADMIN	081366256191	serviceadmin.jambi@indotruck-utama.co.id	2023-02-21 16:15	2023-02-21 16:15	2023-02-21 16:23	2023-02-21 16:33	2023-02-21 16:23	2023-02-21 16:33	2023-02-22 08:22	2023-02-22 08:25	2023-02-22 08:28	1223.0	18.0	16.0	YES	0.0