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
3390.0	ADMIN	BRANCH	April	1681181708400	WO23176875	WAHANA INDO TRADA MOBILINDO,PT.	-	-	VB	A60H	202144	142311	NON WARRANTY	RUNNING	2023-04-11 00:00:00.0000000	cibinong	JAKARTA	replace bearinv B11R	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Eko Suharyanto	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-04-11 09:55	2023-04-11 09:55	2023-04-11 09:59	2023-04-11 11:21	2023-04-11 09:59	2023-04-11 11:21	2023-04-12 00:44	2023-04-12 02:32	2023-04-12 09:38	1174.0	86.0	14.0	YES	0.0
3391.0	MECHANIC	MECHANIC	April	1681182087605	0	TITIAN TRANS ENERGY, PT	-	-	VCE	EC950E	0	0	WARRANTY	RUNNING	2023-04-10 00:00:00.0000000	tabang	SAMARINDA	comissioning	ETC	INSPECTION	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	done	Arman Maulana Saputra	Arman Maulana Saputra	082352031001	arman.maulana1072@gmail.com	2023-04-11 10:01	2023-04-11 10:01	2023-04-11 10:01	2023-04-11 16:16	2023-04-11 10:01	2023-04-11 16:16	2023-04-24 14:17	2023-04-24 21:16	2023-04-24 21:16	1174.0	375.0	316.0	YES	0.0
3392.0	ADMIN	BRANCH	April	1681182130620	WOCE176874	INDOTRUCK UTAMA, PT.	-	-	VCE	EC200D	281443	4.5	WARRANTY	RUNNING	2023-04-11 00:00:00.0000000	yard purwakarta	JAKARTA	campaign install WECU-4.1 SB398/61	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive on office	Yusuf Rhama Dhani	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-04-11 10:02	2023-04-11 10:03	2023-04-11 10:22	2023-04-11 11:40	2023-04-11 10:22	2023-04-11 11:40	2023-04-11 16:47	2023-04-11 19:01	2023-04-14 10:49	1174.0	98.0	6.0	YES	0.0
3393.0	ADMIN	BRANCH	April	1680835901805	WO23176684	UTAMA TRAKTOR,CV.	-	-	SDLG	L968F	620575	1750	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 1750 jam L-06 SN 620575 UT	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	lupa update sampai office sory 18.14	Janu Ramadhan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-07 09:51	2023-04-07 09:56	2023-04-07 12:41	2023-04-07 13:19	2023-04-07 12:41	2023-04-07 13:19	2023-04-07 14:33	2023-04-08 11:02	2023-04-15 11:23	1178.0	201.0	4.0	YES	4.0
3394.0	-	BRANCH	April	1680862294960	WO23174288	HARMONIS PERKASAINDAH POHUWATO, PT	-	-	SDLG	LG936L	607002	247	WARRANTY	RUNNING	2023-04-07 00:00:00.0000000	kab. Gorontalo	MANADO	Mandatory Service 250hm	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	ok	Febryanto Ishak Aihua	-	-	-	2023-04-07 17:11	-	2023-04-07 17:11	2023-04-09 11:59	2023-04-07 17:11	2023-04-09 11:59	2023-04-11 11:34	2023-04-12 09:57	2023-04-12 09:58	1178.0	2568.0	90.0	YES	-
3395.0	MECHANIC	MECHANIC	April	1680920097874	WOSD176663	TIDAR KERINCI AGUNG, PT	-	-	SDLG	G9138	600558	7	WARRANTY	RUNNING	2023-04-08 00:00:00.0000000	Bungo	JAMBI	Replace Cutting Edge	ETC	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	done	Ardiansyahnur	Ardiansyahnur	082353107865	ardiansyahnur2002@gmail.com	2023-04-08 09:14	2023-04-08 09:15	2023-04-08 13:56	-	2023-04-08 13:56	-	2023-04-27 06:33	2023-04-13 08:45	2023-04-27 06:33	1177.0	-	119.0	NO	0.0
3396.0	MECHANIC	MECHANIC	April	1680921081564	000377	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	302275	2237	WARRANTY	RUNNING	2023-04-08 00:00:00.0000000	Tanjung Enim Site Banko	MUARA ENIM	Service 200 Hours	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	RFU	Boby Anggara	Boby Anggara	082337836906	boby040893@gmail.com	2023-04-08 09:31	2023-04-08 09:34	2023-04-08 09:32	2023-04-08 09:33	2023-04-08 09:32	2023-04-08 09:33	-	-	2023-04-08 18:18	1177.0	2.0	-	YES	3.0
3397.0	-	MECHANIC	April	1681006013387	wo23176598	AKR TRANSPORTASI INDONESIA, PT	-	-	VT	FM37064T-AS	778530	131478	NON WARRANTY	RUNNING	2023-04-09 00:00:00.0000000	semarang	SEMARANG	-	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	ok	Muhammad Afifur Rohman	-	-	-	2023-04-09 09:06	2023-04-09 09:09	2023-04-09 09:10	-	2023-04-09 09:11	-	2023-04-10 09:00	2023-04-10 09:00	2023-04-10 09:00	1176.0	-	23.0	YES	2.0
3398.0	ADMIN	BRANCH	April	1681039029242	WO23176598	AKR TRANSPORTASI INDONESIA, PT	-	-	VT	FM37064T	YV2XM30DXGB778530	1	NON WARRANTY	RUNNING	-	SEMARANG	SEMARANG	YV2XM30DXGB778530 WO23176598 BASIC SERVICE B 9737 BEI VT AKR TRANSPORTASI INDONESIA, PT 0038 ITU-000005914 SRWE Created Triyono Smg 4/6/2023 9.00	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-04-09 18:17	2023-04-09 18:17	2023-04-09 18:17	2023-04-09 18:17	2023-04-09 18:17	2023-04-09 18:17	2023-04-09 18:18	2023-04-09 18:18	2023-04-09 18:18	1176.0	1.0	0.0	YES	0.0
3399.0	ADMIN	BRANCH	April	1681090370616	23176786	DWI ARTHA SEJATI, PT	-	-	SDLG	LG953	622005	500	WARRANTY	RUNNING	-	TANJABBAR	JAMBI	MANDATORY SERVICE 500 H	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Nyampai kantor jam 21.30 tanggal 10 April 2023	Hafiz Rusydi	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-04-10 08:32	2023-04-10 08:33	2023-04-10 09:23	2023-04-10 14:32	2023-04-10 09:23	2023-04-10 14:32	2023-04-10 16:30	-	2023-04-11 10:54	1176.0	360.0	7.0	YES	0.0