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
3860.0	ADMIN	BRANCH	May	1683087526436	WOCE178346	MACMAHON MINING SERVICES, PT	-	-	VCE	A60H	320531	738	WARRANTY	RUNNING	-	MARTABE	JAKARTA	Replace water separator Assy TD9145	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Rizky Abdillah	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-03 11:18	2023-05-03 11:19	2023-05-03 11:19	2023-05-03 11:20	2023-05-03 11:19	2023-05-03 11:20	2023-05-03 17:00	2023-05-03 17:01	2023-05-03 17:02	1152.0	2.0	5.0	YES	0.0
3861.0	ADMIN	BRANCH	May	1683106251141	23178364	BARA PRIMA PRATAMA, PT	-	-	VT	FMX44084R-I SHIFT	B385160	9187	WARRANTY	RUNNING	-	BATU AMPAR	JAMBI	SPEED SENSOR	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Noval Qomaruzzaman Rasyid	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-05-03 16:30	2023-05-03 16:31	2023-05-05 10:02	2023-05-05 10:03	2023-05-05 10:02	2023-05-05 10:03	2023-05-05 17:07	2023-05-05 17:07	2023-05-05 17:07	1152.0	2492.0	48.0	YES	0.0
3862.0	MECHANIC	MECHANIC	May	1683106624971	wo23177183	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX44064R	894989	3000	NON WARRANTY	RUNNING	2023-05-03 00:00:00.0000000	pendingin	SAMARINDA	On proggres	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	done	Muhammad Ardani	Muhammad Ardani	081257577396	muhammadardani1721@gmail.com	2023-05-03 16:37	-	2023-05-03 16:43	2023-05-03 16:43	2023-05-03 16:43	2023-05-03 16:43	-	-	2023-05-04 14:02	1152.0	6.0	-	YES	-
3863.0	MECHANIC	MECHANIC	May	1683108578787	WOCE178882	INDOTRUCK UTAMA, PT.	-	-	VCE	EC200D	281395	4.2	STOK	RUNNING	2023-05-02 00:00:00.0000000	Yard Purwakarta	JAKARTA	Campaign W-ECU 4.1	ELECTRICAL	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive on office at 19.30 02/05/23 Done	Yusuf Rhama Dhani	Yusuf Rhama Dhani	082129756665	rhamay076@gmail.com	2023-05-03 17:09	2023-05-03 17:09	2023-05-03 17:10	2023-05-03 17:11	2023-05-03 17:10	2023-05-03 17:11	2023-05-03 17:12	2023-05-03 17:17	2023-05-16 17:01	1152.0	2.0	0.0	YES	0.0
3864.0	MECHANIC	MECHANIC	April	1682803122865	-	JHONLIN BARATAMA, PT	-	-	VCE	A40G	-	-	WARRANTY	BREAKDOWN	2023-04-30 00:00:00.0000000	Tanah Bumbu Kalimantan Selatan	BANJARMASIN	Backup Warranty	TRANSMISSION	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	.	Widianto	Widianto	085705256615	widi10anto@gmail.com	2023-04-30 04:18	2023-04-30 04:18	2023-04-30 04:19	2023-04-30 05:57	2023-04-30 04:19	2023-04-30 05:57	2023-05-02 13:41	2023-05-02 13:41	2023-05-02 13:41	1156.0	99.0	57.0	YES	0.0
3865.0	ADMIN	BRANCH	April	1682859098582	WO23177096	BIMA NUSA INTERNASIONAL, PT	-	-	VCE	EC480DL	275563	22023	NON WARRANTY	RUNNING	2023-04-30 00:00:00.0000000	Susubang	BALIKPAPAN	MIP EC480DL sn275563 PT BNI	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	inspection ec480dl	Nova Ardianto	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-04-30 19:51	2023-04-30 19:51	2023-04-30 19:52	2023-05-01 09:43	2023-04-30 19:52	2023-05-01 09:43	2023-05-05 15:05	2023-05-08 08:05	2023-05-08 08:06	1155.0	832.0	115.0	YES	0.0
3866.0	ADMIN	BRANCH	April	1682859524950	WO23177597	ASL TRANSPORT, PT.	-	-	VCE	EC200D	281060	2970	NON WARRANTY	STANDBY	2023-04-30 00:00:00.0000000	batuah	BALIKPAPAN	Inspeksi engine smoke EC200D sn281060 PT Asl	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	.	Fiqri Hamdani	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-04-30 19:58	2023-04-30 19:58	2023-04-30 19:59	2023-05-01 09:33	2023-04-30 19:59	2023-05-01 09:33	2023-05-01 17:21	2023-05-01 21:25	2023-05-01 21:25	1155.0	815.0	21.0	YES	0.0
3867.0	ADMIN	BRANCH	April	1682859844628	WOCE177909	INDONESIA PRATAMA, PT	-	-	VCE	L220H	12348	665	WARRANTY	BREAKDOWN	2023-04-30 00:00:00.0000000	Tabang	BALIKPAPAN	Fan shard L220H sn12348 PT IP	ENGINE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	a	Chandra Wijaya S	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-04-30 20:04	2023-04-30 20:04	2023-05-25 12:55	2023-05-25 14:00	2023-05-25 12:55	2023-05-29 09:47	2023-05-29 09:44	2023-05-29 10:01	2023-05-29 10:02	1155.0	35636.0	685.0	YES	0.0
3868.0	MECHANIC	MECHANIC	May	1682902415990	WO23177631	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898742	4750	WARRANTY	RUNNING	2023-05-01 00:00:00.0000000	batuah	SAMARINDA	VT63 ps250h	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-05-01 07:53	2023-05-01 07:53	2023-05-01 07:54	2023-05-01 18:11	2023-05-01 07:54	2023-05-01 18:11	2023-05-01 18:11	2023-05-01 19:47	2023-05-01 19:48	1155.0	618.0	10.0	YES	0.0
3869.0	ADMIN	BRANCH	May	1682993320268	WOCE178264	INDOTRUCK UTAMA, PT.	-	-	VCE	EC480DL	285074	4	WARRANTY	RUNNING	-	YARD PURWAKARTA	JAKARTA	Campaign installation WECU 4.1 EC480D SN 285074 ITU Purwakarta	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Mochamad Alfan Nafas	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-02 09:08	2023-05-02 09:08	2023-05-02 10:58	2023-05-02 13:02	2023-05-02 10:58	2023-05-02 13:02	2023-05-02 14:52	2023-05-02 16:11	2023-05-02 16:11	1153.0	234.0	5.0	YES	0.0