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
3560.0	ADMIN	BRANCH	April	1681720490242	WO23177485	BALIKPAPAN READYMIX, PT	-	-	VCE	EC210D	231887	495	WARRANTY	RUNNING	-	BULURI	PALU	FREE SERVICE & PARTS 500 HM	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive in branch office	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-04-17 15:34	-	2023-04-17 15:39	2023-04-18 08:06	2023-04-17 15:39	2023-04-18 08:06	2023-04-18 09:51	2023-04-18 10:37	2023-04-26 07:27	1168.0	991.0	18.0	YES	-
3561.0	MECHANIC	MECHANIC	April	1681741276531	WO23175792	MUTIARA SELATAN LOGISTIK, CV	-	-	SDLG	E680F	606972	1751	NON WARRANTY	BREAKDOWN	2023-04-17 00:00:00.0000000	ITU PALU	PALU	Sunking units, black smoke and error display	ELECTRICAL	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Unit RFU	Sugiharto Wicaksono	Sugiharto Wicaksono	082187569393	sugihartowicaksono@gmail.com	2023-04-17 21:21	2023-04-17 21:22	2023-04-17 21:23	2023-04-17 21:25	2023-04-17 21:23	2023-04-17 21:25	2023-05-05 08:48	2023-05-05 08:49	2023-05-05 08:50	1168.0	4.0	419.0	YES	1.0
3562.0	MECHANIC	MECHANIC	April	1681750358686	WOSD177203	TIDAR KERINCI AGUNG, PT	-	-	SDLG	G9138	600558	52.6	WARRANTY	BREAKDOWN	2023-04-17 00:00:00.0000000	Bungo	JAMBI	Replace turbocharger	ENGINE	REPAIR	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	job done	MUHAMAD RYAN HIDAYAH	MUHAMAD RYAN HIDAYAH	082131031513	ryanhidayah510@gmail.com	2023-04-17 23:52	2023-04-17 23:53	2023-04-17 23:53	2023-04-26 21:38	2023-04-26 21:44	2023-05-01 07:15	2023-05-01 07:18	2023-05-01 07:19	2023-05-01 07:19	1168.0	12826.0	319.0	NO	0.0
3563.0	ADMIN	BRANCH	April	1681782022185	WO23176876	HILLCONJAYA SAKTI, PT	-	-	VCE	EC480DL	284904	1	WARRANTY	RUNNING	2023-04-18 00:00:00.0000000	.	BANJARMASIN	COMMISSIONING UNIT	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Unit Ready For Use	Piter Setiawan	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-04-18 08:40	2023-04-18 08:40	2023-04-22 15:55	2023-04-22 15:56	2023-04-22 15:55	2023-04-22 15:56	-	-	2023-04-22 16:51	1168.0	6196.0	-	YES	0.0
3564.0	ADMIN	BRANCH	April	1681782236671	WO23176880	HILLCONJAYA SAKTI, PT	-	-	VCE	EC350DL	271233	9	WARRANTY	RUNNING	2023-04-18 00:00:00.0000000	.	BANJARMASIN	COMMISSIONING UNIT	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Unit Ready For Use	Piter Setiawan	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-04-18 08:43	2023-04-18 08:44	2023-04-21 22:32	2023-04-21 22:32	2023-04-21 22:32	2023-04-21 22:32	-	-	2023-04-22 09:32	1168.0	5149.0	-	YES	0.0
3565.0	ADMIN	BRANCH	April	1681782627192	WO23176887	HILLCONJAYA SAKTI, PT	-	-	VCE	EC210D	231896	1	WARRANTY	RUNNING	2023-04-18 00:00:00.0000000	.	BANJARMASIN	COMMISSIONING UNIT	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	unit ready for use	Zainur Yahya	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-04-18 08:50	2023-04-18 08:50	2023-04-21 19:20	2023-04-21 19:20	2023-04-21 19:20	2023-04-21 19:20	-	-	2023-04-21 19:23	1168.0	4950.0	-	YES	0.0
3566.0	ADMIN	BRANCH	April	1681785241140	WO23177504	NUANSA ALAM KHATULISTIWA, PT	-	-	VCE	EC210D	231935	42.5	WARRANTY	RUNNING	-	KONAWE UTARA	KENDARI	Commissioning EC210D SN 231935	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Debysantoso	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-04-18 09:34	2023-04-18 09:34	2023-04-18 10:15	2023-04-18 17:28	2023-04-18 10:15	2023-04-18 17:28	2023-04-19 19:57	2023-04-19 22:04	2023-04-20 09:53	1167.0	474.0	34.0	YES	0.0
3567.0	ADMIN	BRANCH	April	1681785381576	WO23177506	NUANSA ALAM KHATULISTIWA, PT	-	-	VCE	EC210D	231936	9.3	WARRANTY	RUNNING	-	KONAWE UTARA	KENDARI	Commissionin EC210D SN 231936	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Debysantoso	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-04-18 09:36	2023-04-18 09:36	2023-04-18 10:15	2023-04-18 17:27	2023-04-18 10:15	2023-04-18 17:27	2023-04-19 19:57	2023-04-19 22:04	2023-04-20 09:52	1167.0	471.0	34.0	YES	0.0
3568.0	ADMIN	BRANCH	April	1681789285090	WO23177454	DERMAGA SUKSES MANDIRI, PT.	-	-	SDLG	L956F	624046	1750	NON WARRANTY	RUNNING	-	KIM	MEDAN	Maintenance Service	ECT	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	otw	Ferdian Dinata	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-04-18 10:41	-	2023-04-18 13:05	2023-04-18 13:05	2023-04-18 13:05	2023-04-18 13:05	2023-04-18 16:43	-	2023-04-19 16:12	1167.0	144.0	6.0	YES	-
3569.0	ADMIN	BRANCH	April	1681789927049	WO23177508	ROSALIA INDAH TRANSPORT, PT.	-	-	VB	B11R	YV3T2T428LA200516	-	NON WARRANTY	RUNNING	-	PALUR	SEMARANG	YV3T2T428LA200516 WO23177508 T/S TRANSMISSION SYSTEM INCLUDE CALIBRATION SDD 161 VB ROSALIA INDAH TRANSPORT, PT. 2597 ITU-000010074 SRWE Invoiced Triyono Smg 4/18/2023 9.00	TRANSMISSION	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-04-18 10:52	2023-04-18 10:52	2023-04-18 10:52	2023-04-18 10:52	2023-04-18 10:52	2023-04-18 10:52	2023-04-18 18:49	2023-04-18 18:49	2023-04-18 18:49	1167.0	1.0	7.0	YES	0.0