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
4670.0	MECHANIC	MECHANIC	May	1685066538462	23179358	BUKIT ASAM ( Persero ) TBK., PT	-	-	VCE	EC480DL	275438	22755.9	NON WARRANTY	STANDBY	2023-05-26 00:00:00.0000000	pit 2 PT BA	MUARA ENIM	PM service 22.750	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	ready	Muhammad Akhyar Alfarizi	Muhammad Akhyar Alfarizi	085878305740	akhyaralfarizi12@gmail.com	2023-05-26 09:02	-	2023-05-26 09:02	-	2023-05-26 09:02	-	2023-05-26 11:38	2023-05-26 11:39	2023-05-26 11:40	1129.0	-	2.0	YES	-
4671.0	MECHANIC	BRANCH	May	1685067172993	WO23179793	AKR TRANSPORTASI INDONESIA, PT	-	-	VT	FM37064T-AS	776838	139006	NON WARRANTY	BREAKDOWN	2023-05-26 00:00:00.0000000	Ciwandan	CILEGON	Disc Clutch Replace FM370	TRANSMISSION	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job Completed at 9 Juni 2023	Muhammad Abdurrofi	Muhammad Abdurrofi	089650505566	abdurrofim19@gmail.com	2023-05-26 09:12	2023-05-26 09:13	2023-05-26 09:14	2023-05-26 09:55	2023-06-08 10:03	2023-06-08 10:30	2023-06-12 09:27	2023-06-12 22:57	2023-06-13 08:47	1129.0	43.0	7.0	YES	0.0
4672.0	MECHANIC	MECHANIC	May	1685067854119	0	INDOTRUCK UTAMA, PT.	-	-	VCE	EC950E	0	0	DEMO/TRIAL	STANDBY	2023-05-26 00:00:00.0000000	Workshop Banjarmasin	BANJARMASIN	Tes	ELECTRICAL	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Unit RFU	Ahmad Adji Ardianto	Ahmad Adji Ardianto	085741257008	ahmadaadji08@gmail.com	2023-05-26 09:24	2023-05-26 09:26	2023-05-26 09:27	2023-05-26 09:28	2023-05-26 09:27	2023-05-26 09:28	2023-05-26 09:31	2023-05-26 09:31	2023-05-26 09:32	1129.0	4.0	0.0	YES	2.0
4673.0	ADMIN	BRANCH	May	1685071461448	WOCE179623	CAKRAWALA KENCANA INDONESIA, PT	-	-	VCE	R60D	111094	84	WARRANTY	RUNNING	2023-05-26 00:00:00.0000000	BATULICIN	BANJARMASIN	BRAKE OIL LEAK FROM PRESSURE SWITCH BROKEN	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Ridwan Wahyu	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-05-26 10:24	2023-05-26 10:24	2023-05-31 06:48	2023-05-31 06:48	2023-05-31 06:48	2023-05-31 06:48	2023-05-31 06:50	2023-05-31 06:50	2023-05-31 06:50	1129.0	6984.0	116.0	YES	0.0
4674.0	ADMIN	BRANCH	May	1685072043042	WO23179757	SUKMA SURYA DUA TIGA EMPAT, PT	-	-	VCE	EC210D	231930	1	WARRANTY	RUNNING	2023-05-26 00:00:00.0000000	TEWEH	BANJARMASIN	COMMISSIONING UNIT EC210D SN231930	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job complete	Achmad faisal	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-05-26 10:34	2023-05-26 10:34	2023-05-28 09:24	2023-05-29 16:48	2023-05-28 09:24	2023-05-29 16:48	2023-05-30 12:01	2023-05-30 12:07	2023-05-30 12:08	1129.0	4694.0	97.0	YES	0.0
4675.0	ADMIN	BRANCH	May	1685073151926	‪‪‪WO23180406	INDOTRUCK UTAMA, PT.	-	-	SDLG	G9220	600639	7	WARRANTY	RUNNING	-	WORKSHOP ITU	SAMARINDA	PREDELIVERY INSPECTION	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Commissioning 1x SDLG G9220F done..arrive in office ITU-Samarinda	rendi juliadi	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-26 10:52	2023-05-26 10:52	2023-05-26 10:53	2023-05-26 16:57	2023-05-26 10:53	2023-05-26 18:55	2023-05-27 02:03	2023-05-27 05:27	2023-05-27 05:27	1129.0	365.0	15.0	YES	0.0
4676.0	ADMIN	BRANCH	May	1685088466133	WOCE179834	PRIMA SARANA MUSTIKA, PT	-	-	VCE	EC210D	231842	2081	WARRANTY	RUNNING	2023-05-26 00:00:00.0000000	KURUN	BANJARMASIN	ENGINE OVERHEAT	ENGINE	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Unit RFU	Piter Setiawan	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-05-26 15:07	2023-05-26 15:07	2023-05-31 16:05	2023-05-31 16:06	2023-05-31 16:05	2023-05-31 16:06	2023-05-31 16:09	2023-05-31 16:10	2023-05-31 16:10	1129.0	7258.0	121.0	YES	0.0
4677.0	MECHANIC	MECHANIC	May	1685144159744	0	HILLCONJAYA SAKTI, PT	-	-	VCE	R60D	0111031	12939	NON WARRANTY	BREAKDOWN	2023-05-27 00:00:00.0000000	HJS Kota baru	BANJARMASIN	reaplace pump pto	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	RFU	M. Arbain	M. Arbain	082155710456	bainadventure6@gmail.com	2023-05-27 06:35	2023-05-27 06:36	2023-05-27 06:36	2023-05-27 06:36	2023-05-27 06:36	2023-05-27 06:36	2023-05-28 05:17	2023-05-28 05:17	2023-05-28 05:17	1129.0	1.0	22.0	YES	0.0
4678.0	MECHANIC	MECHANIC	May	1685163378132	0	SUKMA SURYA DUA TIGA EMPAT, PT	-	-	VCE	SD110	-	-	WARRANTY	RUNNING	2023-05-27 00:00:00.0000000	Pengaron	BANJARMASIN	PM 500hour	ETC	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Unit RFU	Ahmad Adji Ardianto	Ahmad Adji Ardianto	085741257008	ahmadaadji08@gmail.com	2023-05-27 11:56	2023-05-27 11:56	2023-05-27 11:57	2023-05-27 14:44	2023-05-27 11:57	2023-05-27 14:44	-	2023-05-27 19:43	2023-05-27 19:44	1128.0	168.0	-	YES	0.0
4679.0	MECHANIC	MECHANIC	May	1685241903240	-	RIMBA PERKASA UTAMA, PT	-	-	VCE	A40G	324679	2277	WARRANTY	RUNNING	2023-05-28 00:00:00.0000000	sanga sanga	SAMARINDA	parking brake not applyd	ELECTRICAL	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	rfu	Yanuar Yacob	Yanuar Yacob	082255998574	yacobyanuar@gmail.com	2023-05-28 09:45	2023-05-28 09:45	2023-05-28 09:45	2023-05-28 16:36	2023-05-28 09:45	2023-05-28 16:36	2023-05-28 17:17	2023-05-28 17:17	2023-05-28 17:17	1127.0	411.0	7.0	NO	0.0