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
4360.0	-	MECHANIC	May	1684291784100	wo23178873	ADHIMIX RMC INDONESIA, PT.	-	-	SDLG	L956F	0625030	95	WARRANTY	RUNNING	2023-05-17 00:00:00.0000000	semarang	SEMARANG	o	ETC	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	ok	Muhammad Afifur Rohman	-	-	-	2023-05-17 09:49	2023-05-17 09:49	2023-05-17 09:51	2023-05-19 08:16	2023-05-17 09:51	2023-05-19 08:16	2023-05-19 08:17	-	2023-05-19 08:17	1138.0	2787.0	46.0	YES	0.0
4361.0	BRANCH	BRANCH	May	1684293220052	WO23179080	TELAGA HIKMAH, PT.	-	-	SDLG	LG936L	605453	14631	NON WARRANTY	RUNNING	2023-05-17 00:00:00.0000000	mesuji	PALEMBANG	Replace part recomendation	ETC	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job completed replace gasket cover valve, gasket intake manifold	Edy Nugroho	Indry Sasmitha	081271778108	adminsvc.palembang@indotruck-utama.co.id	2023-05-17 10:13	2023-05-17 10:16	2023-05-17 10:17	2023-05-19 08:00	2023-05-17 10:17	2023-05-19 08:03	2023-05-19 08:23	2023-05-19 08:24	2023-05-19 08:25	1138.0	2747.0	46.0	YES	3.0
4362.0	ADMIN	BRANCH	May	1684294512119	-	HIRMALITA KUTAI MAKMUR, PT	-	-	SDLG	LG956F	620722	-	NON WARRANTY	BREAKDOWN	-	EMBALUT	SAMARINDA	TRANSMISSI PROBLEM	TRANSMISSION	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Recomendasi part	rendi juliadi	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-17 10:35	2023-05-17 10:35	2023-05-17 10:36	2023-05-17 12:23	2023-05-17 10:36	2023-05-17 12:23	2023-05-18 18:02	2023-05-19 08:13	2023-05-24 15:09	1138.0	109.0	31.0	YES	0.0
4363.0	ADMIN	BRANCH	May	1684294934478	WO23178810	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	894989	3187	WARRANTY	RUNNING	-	PENDINGIN	SAMARINDA	BATTERY DROP REPLACE BATTERY	ELECTRICAL	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	ready for use	Heru Priyoga	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-17 10:42	2023-05-17 10:43	2023-05-17 10:43	2023-05-17 11:45	2023-05-17 10:43	2023-05-17 11:45	2023-05-17 15:59	2023-05-17 17:09	2023-05-17 17:19	1138.0	63.0	5.0	YES	0.0
4364.0	ADMIN	BRANCH	May	1684295271187	WO23179267	SUMI GITA JAYA PT	-	-	VCE	EC210D	231929	178	WARRANTY	RUNNING	-	DURI	PEKANBARU	AC Not Cold	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back to shop	INDRA MAHDI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-17 10:47	2023-05-17 10:48	2023-05-17 11:15	2023-05-17 13:22	2023-05-17 11:15	2023-05-17 13:22	2023-05-17 18:02	2023-05-25 15:03	2023-05-26 15:35	1138.0	155.0	7.0	YES	0.0
4365.0	ADMIN	BRANCH	May	1684310711832	WO23179304	SALIM IVOMAS PRATAMA TBK, PT	-	-	SDLG	LG936L	607244	130	WARRANTY	RUNNING	-	BALAM	PEKANBARU	Service 100 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back to shop	INDRA MAHDI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-17 15:05	2023-05-17 15:05	2023-05-18 08:39	2023-05-18 14:39	2023-05-18 08:39	2023-05-18 14:39	2023-05-19 20:55	2023-05-25 15:02	2023-05-26 15:08	1138.0	1414.0	53.0	YES	0.0
4366.0	BRANCH	BRANCH	May	1684376486064	WOCE179294	SUMBER MITRA JAYA, PT	-	-	VCE	A40G	324721	1556	WARRANTY	STANDBY	2023-05-18 00:00:00.0000000	Sambarata	BERAU	absorber opeeator seat leakage	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job closed	Burhanuddin	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-05-18 09:21	2023-05-18 09:25	2023-05-18 09:36	2023-05-18 12:06	2023-05-18 09:36	2023-05-18 12:06	2023-05-18 14:04	2023-05-18 15:10	2023-05-18 15:11	1137.0	165.0	4.0	YES	3.0
4367.0	MECHANIC	MECHANIC	May	1684400864827	WO23179506	SUMBER MANDIRI ABADI, CV	-	-	VCE	SD110	59432	250	WARRANTY	RUNNING	2023-05-18 00:00:00.0000000	ketapang	PONTIANAK	service 250 HM	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	arrived	Dian Sigit Purwito	Dian Sigit Purwito	085210531886	chindyrizky65@gmail.com	2023-05-18 16:07	2023-05-18 16:10	2023-05-18 16:11	2023-05-18 16:11	2023-05-18 16:11	2023-05-18 16:11	2023-05-18 16:12	2023-05-19 12:52	2023-05-22 09:18	1137.0	4.0	0.0	YES	2.0
4368.0	ADMIN	BRANCH	May	1684401956731	WO23179326	CITRA MITRA SEHATI PT	-	-	SDLG	E680F	607246	518	WARRANTY	RUNNING	2023-05-18 00:00:00.0000000	Bengkulu utara	BENGKULU	service 500	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Novriman	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-05-18 16:25	2023-05-18 16:26	2023-05-19 08:50	2023-05-19 13:41	2023-05-19 08:50	2023-05-19 13:41	2023-05-19 18:03	2023-05-19 19:53	2023-05-19 19:53	1137.0	1276.0	25.0	YES	0.0
4369.0	MECHANIC	MECHANIC	May	1684444887693	-	HARMONI PANCA UTAMA, PT	-	-	VCE	EC750D	280353	-	NON WARRANTY	BREAKDOWN	2023-05-19 00:00:00.0000000	separi	SAMARINDA	remove control valve	TRANSMISSION	INSPECTION	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	job done	Arif Sumardianto	Arif Sumardianto	081357952617	arifsumardianto2@gmail.com	2023-05-19 04:21	2023-05-19 04:21	2023-05-20 03:32	2023-05-23 18:24	2023-05-20 03:32	2023-05-23 18:24	2023-05-28 22:10	2023-05-29 07:10	2023-05-29 08:07	1137.0	6603.0	233.0	YES	0.0