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
5420.0	ADMIN	BRANCH	June	1686883034751	-	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	888883	8750	NON WARRANTY	RUNNING	-	SANGA-SANGA	SAMARINDA	SERVICE 750HRS VT048	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	completed service	Diky Maulana Tarmiji	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-06-16 09:37	2023-06-16 09:37	2023-06-16 09:38	2023-06-16 10:21	2023-06-16 09:38	2023-06-16 10:21	2023-06-16 13:03	2023-06-16 20:35	2023-06-16 20:35	1108.0	44.0	3.0	NO	0.0
5421.0	ADMIN	BRANCH	June	1686888813320	WO23181407	MACMAHON MINING SERVICES, PT	-	-	VCE	A60H	320525	1000	NON WARRANTY	RUNNING	-	MARTABE	JAKARTA	PM 1000	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Tomi Jullio	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-06-16 11:13	2023-06-16 11:13	2023-06-16 11:16	2023-06-16 11:17	2023-06-16 11:16	2023-06-16 11:17	2023-06-16 11:17	2023-06-16 11:18	2023-06-16 11:18	1108.0	4.0	0.0	YES	0.0
5422.0	ADMIN	BRANCH	June	1686904239457	WO23181343	ULIMA NITRA, PT	-	-	VCE	EC480DL	285033	250	WARRANTY	RUNNING	-	MUARATARA	PALEMBANG	Service maintenance 250 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	lesai	Ponco Krisno Pratomo	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-16 15:30	2023-06-16 15:31	2023-06-16 15:31	2023-06-17 10:22	2023-06-16 15:31	2023-06-17 10:22	-	-	2023-06-17 13:56	1108.0	1132.0	-	YES	0.0
5423.0	MECHANIC	MECHANIC	June	1686960858874	WO23181152	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898876	5250	WARRANTY	RUNNING	2023-06-17 00:00:00.0000000	batuah	SAMARINDA	VT71 ps250h	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Done , kondisi lapangan hujan	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-06-17 07:14	2023-06-17 07:17	2023-06-17 07:17	2023-06-17 08:45	2023-06-17 07:17	2023-06-17 08:45	2023-06-17 19:06	2023-06-17 19:06	2023-06-17 19:06	1108.0	91.0	11.0	YES	3.0
5424.0	ADMIN	BRANCH	June	1686965519575	WO23181595	DERMAGA SUKSES MANDIRI, PT.	-	-	SDLG	L956F	625344	3	WARRANTY	RUNNING	-	CEMARA ASRI	MEDAN	Commissioning Unit L956 F SN 625344	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	finished	Bonar Suryadi Siregar	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-06-17 08:31	2023-06-17 08:32	-	2023-06-17 12:36	-	2023-06-17 12:36	2023-06-17 15:20	2023-06-17 21:25	2023-06-17 21:25	1108.0	244.0	6.0	YES	0.0
5425.0	-	MECHANIC	June	1686974509323	WOCE181246	GORONTALO PANGAN LESTARI, PT	-	-	VCE	EC210D	283528	576.2	WARRANTY	BREAKDOWN	2023-06-17 00:00:00.0000000	bualemo	MANADO	trebleshooting electrik and replace injektor	ENGINE	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	.	Bagas Ferdiansyah Pakaya	-	-	-	2023-06-17 11:01	2023-06-17 11:02	2023-06-17 11:18	2023-06-17 11:18	2023-06-17 11:18	2023-06-17 11:18	2023-06-19 08:01	2023-06-21 07:54	2023-06-22 08:52	1107.0	17.0	44.0	YES	0.0
5426.0	ADMIN	BRANCH	June	1686975853775	WO23181588	KARNI JAYA NUSANTARA, PT.	-	-	SDLG	LG936L	607234	2	WARRANTY	RUNNING	-	MARTAPURA	PALEMBANG	Commisioning new machine	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	start job	Bayu Pradana	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-17 11:24	2023-06-17 11:24	2023-06-17 11:26	2023-06-17 15:34	2023-06-17 11:26	2023-06-17 15:34	2023-06-19 10:48	2023-06-19 10:49	2023-06-19 10:50	1107.0	250.0	47.0	YES	0.0
5427.0	ADMIN	BRANCH	June	1686976249716	WO23181214	BUKIT ASAM ( Persero ) TBK., PT	-	-	VCE	EC480DL	275438	23107.9	NON WARRANTY	STANDBY	2023-06-17 00:00:00.0000000	Banko, Muara Enim	MUARA ENIM	RPM abnormal EXCA09	ELECTRICAL	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Finished	Ilham Ramandana Yusuf	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-06-17 11:30	2023-06-17 11:31	2023-06-17 11:38	2023-06-17 13:30	2023-06-17 11:38	2023-06-17 13:30	2023-06-17 16:20	2023-06-17 17:00	2023-06-17 17:01	1107.0	119.0	4.0	YES	1.0
5428.0	MECHANIC	BRANCH	June	1687067351703	181009	LAZ COAL MANDIRI, PT	-	-	SDLG	G9220	600569	2011	WARRANTY	RUNNING	2023-06-18 00:00:00.0000000	kintap	BANJARMASIN	.	ETC	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	.	Rahmad	Rahmad	+628115031218	rahmadal889@gmail.com	2023-06-18 12:49	2023-06-18 12:49	2023-06-18 12:50	2023-06-18 12:50	2023-06-18 12:50	2023-06-18 12:50	2023-06-18 12:50	2023-06-18 12:50	2023-06-18 12:51	1106.0	1.0	0.0	YES	0.0
5429.0	MECHANIC	MECHANIC	June	1687067615162	0	GAWI MAKMUR KALIMANTAN, PT.	-	-	VCE	SD110	58620	7937	NON WARRANTY	RUNNING	2023-06-18 00:00:00.0000000	jorong	BANJARMASIN	drum noise	ETC	INSPECTION	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	unit RFU	Risky Prabowo	Risky Prabowo	085820339919	riskybowo674@gmail.com	2023-06-18 12:53	2023-06-18 12:53	2023-06-18 12:54	2023-06-18 17:05	2023-06-18 12:54	2023-06-18 17:05	2023-06-18 17:57	2023-06-19 15:25	2023-06-19 15:25	1106.0	252.0	5.0	YES	0.0