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
2470.0	ADMIN	BRANCH	March	1678327877239	WO23174299	PQ SILICAS INDONESIA, PT	-	-	VT	FM37064T	A761266	-	NON WARRANTY	STANDBY	2023-03-09 00:00:00.0000000	Pasuruan	SURABAYA	Annual Service	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Faisal Abdul Rosid	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-03-09 09:11	2023-03-09 09:11	2023-03-09 09:17	2023-03-10 09:20	2023-03-09 09:17	2023-03-10 09:20	2023-03-10 15:07	2023-03-10 17:01	2023-03-13 08:27	1207.0	1449.0	29.0	YES	0.0
2471.0	MECHANIC	MECHANIC	March	1678327897890	wo23174436	ANUGERAH MULYA PERKASA ULU BELU, PT	-	-	SDLG	E6210F	609322	506	WARRANTY	RUNNING	2023-03-09 00:00:00.0000000	ulu belu	LAMPUNG	ms service 500	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	pekerjaan selesai	M.Zaenal Ma'Arif	M.Zaenal Ma'Arif	089646576197	mzmarif60@gmail.com	2023-03-09 09:11	2023-03-09 09:11	2023-03-09 09:21	2023-03-09 12:34	2023-03-09 09:21	2023-03-09 12:34	2023-03-09 14:25	2023-03-09 18:20	2023-03-09 21:25	1207.0	203.0	5.0	YES	0.0
2472.0	ADMIN	BRANCH	March	1678327981311	WO23174447	INDONESIA PRATAMA, PT	-	-	VCE	A40G	324720	10	WARRANTY	STANDBY	2023-03-09 00:00:00.0000000	Tabang	BALIKPAPAN	Commissioning A40G SN324720 IP	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	done	earlyana pamilu	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-03-09 09:13	2023-03-09 09:18	2023-03-09 09:19	2023-03-09 10:22	2023-03-09 09:19	2023-03-09 10:22	2023-03-09 16:16	2023-03-10 09:39	2023-03-10 09:48	1207.0	69.0	7.0	-	5.0
2473.0	ADMIN	BRANCH	March	1678328119498	WO23174393	BERKAT ANUGERAH AGUNG, PT	-	-	VT	FM37064T	-	-	NON WARRANTY	STANDBY	2023-03-09 00:00:00.0000000	Surabaya	SURABAYA	TS Gearbox Shifting	TRANSMISSION	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Rudi Saputra	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-03-09 09:15	2023-03-09 09:15	2023-03-09 09:24	2023-03-09 09:36	2023-03-09 09:24	2023-03-09 09:36	2023-03-10 09:37	2023-03-10 09:38	2023-03-13 08:27	1207.0	21.0	24.0	YES	0.0
2474.0	BRANCH	BRANCH	March	1678328548427	0	HILLCONJAYA SAKTI, PT	-	-	VCE	SD110	550480	7065	NON WARRANTY	RUNNING	-	KONAWE UTARA	KENDARI	Troubleshooting travel system	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Debysantoso	Sri Masriana	081342985588	sri.suyuti@indotruck-utama.co.id	2023-03-09 09:22	2023-03-09 09:22	2023-03-09 09:23	2023-03-09 12:56	2023-03-09 09:23	2023-03-09 12:56	2023-03-11 07:54	2023-03-12 14:52	2023-03-12 14:53	1207.0	214.0	46.0	YES	0.0
2475.0	ADMIN	BRANCH	March	1678328583132	WO23174429	FUSHOR GALANGAN SAMPIT, PT	-	-	VCE	EC210B	77048	1	WARRANTY	STANDBY	2023-03-09 00:00:00.0000000	MENTAWA BARU, KETAPANG	BANJARMASIN	INSPECTION ENGINE CAN'T START EC210B	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	unit RFU	Muksim Triharyadi	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-03-09 09:23	2023-03-09 09:23	2023-05-12 10:17	2023-05-12 10:17	2023-05-12 10:17	2023-05-12 10:17	2023-05-12 10:17	2023-05-12 10:17	2023-05-12 10:18	1207.0	92214.0	1536.0	YES	0.0
2476.0	MECHANIC	MECHANIC	March	1678328601228	WO23174435	MITRA GUNUNG MAKMUR, PT.	-	-	SDLG	L968L	620523	-	WARRANTY	BREAKDOWN	-	KEDIRI	SURABAYA	Replace Injector 1 Pc and Troubleshooting Engine White Smoke	ENGINE	REPAIR	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job done	Hasan Romadhona	Hasan Romadhona	085349763182	hasan.romadhona@gmail.com	2023-03-09 09:23	2023-03-09 09:23	2023-03-09 09:25	2023-03-09 13:01	2023-03-09 09:25	2023-03-09 13:01	2023-03-13 14:10	2023-03-14 13:47	2023-03-14 13:48	1207.0	218.0	100.0	YES	0.0
2477.0	MECHANIC	BRANCH	March	1678328701188	WO23174458	HILLCONJAYA SAKTI, PT	-	-	VCE	SD110	550480	7065	NON WARRANTY	RUNNING	-	KONAWE UTARA	KENDARI	Troubleshootng Travel system	ELECTRICAL	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	travell back	RAHMAN GUSTI YAKSA	RAHMAN GUSTI YAKSA	082297097655	gustiyaksaaa20@gmail.com	2023-03-09 09:25	2023-03-09 09:25	2023-03-09 09:25	2023-03-10 08:07	2023-03-09 09:25	2023-03-10 08:07	2023-03-10 10:00	2023-03-13 07:57	2023-03-13 07:58	1207.0	1362.0	24.0	YES	0.0
2478.0	MECHANIC	MECHANIC	March	1678329770573	WOCE174373	MANADO KARYA ANUGRAH, PT.	-	-	VCE	L220F	26697	11609	WARRANTY	BREAKDOWN	2023-03-09 00:00:00.0000000	Tika tindung	MANADO	replace injector	ENGINE	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	job completed	Hari Manaf Pongoliu	Hari Manaf Pongoliu	081241576651	irahanafiah23@gmail.com	2023-03-09 09:42	2023-03-09 12:23	2023-03-09 12:23	2023-03-09 12:24	2023-03-15 11:55	2023-03-15 12:11	2023-03-15 17:39	2023-03-15 21:01	2023-04-14 10:16	1207.0	161.0	19.0	YES	160.0
2479.0	MECHANIC	MECHANIC	March	1678334453231	-	DINAS PERTANIAN DAN PETERNAKAN KABUPATEN KUTAI KARTANEGARA	-	-	SDLG	E660FL	625772	303	WARRANTY	RUNNING	2023-03-09 00:00:00.0000000	EL 2	SAMARINDA	SDLG E660FL ps250h	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Done	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-03-09 11:00	2023-03-09 11:01	2023-03-09 11:01	2023-03-09 13:41	2023-03-09 11:01	2023-03-09 13:41	2023-03-09 15:36	2023-03-09 17:50	2023-03-09 17:52	1207.0	160.0	4.0	YES	0.0