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
3250.0	ADMIN	BRANCH	April	1680747612389	WO23176613	RAPI OMYA INTERNATIONAL, PT	-	-	SDLG	L968F	620538	8.3	WARRANTY	RUNNING	-	PANGKALAN KERINCI	PEKANBARU	Commisioning unit	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	pku	Sapto Adi Putra	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-04-06 09:20	2023-04-06 09:20	2023-04-06 09:51	2023-04-06 13:30	2023-04-06 09:51	2023-04-06 13:30	2023-04-06 16:53	2023-04-06 19:04	2023-04-17 11:40	1179.0	250.0	7.0	YES	0.0
3251.0	ADMIN	BRANCH	April	1680750837902	23177426	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	302802	2237	WARRANTY	RUNNING	2023-04-06 00:00:00.0000000	Banko, Muara Enim	MUARA ENIM	Battery Drops/ Broken DT3010-07 (Status Warranty)	ELECTRICAL	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Finished	Wahyu Dwi Cahyono	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-06 10:13	2023-04-06 10:20	2023-04-08 15:06	2023-04-08 15:30	2023-04-08 15:06	2023-04-08 15:30	2023-04-08 16:36	2023-04-08 17:08	2023-04-08 19:53	1179.0	3197.0	54.0	YES	6.0
3252.0	ADMIN	BRANCH	April	1680753737131	23176835	BENAL AITI BARA PERKASA, PT	-	-	VCE	A40G	324227	4500	NON WARRANTY	RUNNING	-	SAROLANGUN	JAMBI	MANDATORY SERVICE 4500 H	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job competed jam 18.00 note : di lokasi tidak ada jaringan	Teten Kurniyawan	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-04-06 11:02	2023-04-06 11:02	2023-04-06 15:52	2023-04-06 20:17	2023-04-06 15:52	2023-04-06 20:17	2023-04-07 21:52	2023-04-07 21:53	2023-04-07 21:54	1179.0	556.0	34.0	YES	0.0
3253.0	ADMIN	BRANCH	April	1680754139222	WO23176564	HARMONI PANCA UTAMA, PT	-	-	VT	FM44064R	-	-	NON WARRANTY	STANDBY	2023-04-06 00:00:00.0000000	Muara Teweh	SURABAYA	Troubleshooting Unit Malfunction	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Reynaldi Gilang Prayoga	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-04-06 11:08	2023-04-06 11:09	2023-04-06 11:23	2023-04-06 12:23	2023-04-06 11:23	2023-04-06 12:23	2023-04-06 15:09	2023-04-06 16:34	2023-04-11 10:04	1179.0	75.0	4.0	YES	0.0
3254.0	ADMIN	BRANCH	April	1680759588395	WO23176637	INDOTRUCK UTAMA, PT.	-	-	VCE	EC210D	231936	-	WARRANTY	RUNNING	2023-04-06 00:00:00.0000000	Makassar	MAKASSAR	AI and PDI Unit	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Davit Witanto	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-04-06 12:39	2023-04-06 12:40	2023-04-06 12:42	2023-04-06 12:42	2023-04-06 12:42	2023-04-06 12:42	2023-04-06 16:59	2023-04-06 17:00	2023-04-07 09:06	1179.0	3.0	4.0	YES	0.0
3255.0	ADMIN	BRANCH	April	1680765483219	WOCE176654	ULIMA NITRA, PT	-	-	VCE	EC480DL	274441-2	25172	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	Warr hose arm cylinder AB169 SN 274441 VCRM UN	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-06 14:18	2023-04-06 14:18	2023-04-15 11:25	2023-04-15 12:03	2023-04-15 11:25	2023-04-15 12:03	2023-04-15 13:09	2023-04-15 14:47	2023-04-15 14:51	1179.0	39.0	1.0	YES	0.0
3256.0	MECHANIC	MECHANIC	April	1680830684175	WO23175811	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	899434	4000	WARRANTY	RUNNING	2023-04-07 00:00:00.0000000	BATUAH	SAMARINDA	VT73 PS4000H	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-04-07 08:24	2023-04-07 08:24	2023-04-07 08:25	2023-04-07 10:02	2023-04-08 05:20	2023-04-08 12:57	2023-04-08 19:00	2023-04-09 11:14	2023-04-09 11:14	1179.0	98.0	7.0	YES	0.0
3257.0	ADMIN	BRANCH	April	1680587351708	WOSD176442	CIPTA JAYA LAKSANA, PT	-	-	SDLG	G9138	600532	-	WARRANTY	RUNNING	-	KUTAI BARAT	SAMARINDA	AC PROBLEM	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Repair AC done	rendi juliadi	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-04-04 12:49	2023-04-04 12:49	2023-04-04 12:50	2023-04-07 11:18	2023-04-04 12:50	2023-04-07 11:18	2023-04-09 20:41	2023-04-11 09:13	2023-04-11 09:13	1181.0	4229.0	127.0	YES	0.0
3258.0	ADMIN	BRANCH	April	1680587639156	WO23176376	PP. LONDON SUMATRA INDONESIA TBK, PT	-	-	VCE	EC210B	81253	-	NON WARRANTY	BREAKDOWN	-	CAMP BARU	SAMARINDA	HYDRAULIC LEAK	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job Done	Marsono	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-04-04 12:53	2023-04-04 12:54	2023-04-04 12:54	2023-04-06 17:20	2023-05-29 08:11	2023-05-30 06:54	2023-05-30 14:05	2023-06-02 08:11	2023-06-02 08:12	1181.0	3147.0	65.0	YES	0.0
3259.0	ADMIN	BRANCH	April	1680588856010	WO23176597	GUNUNG BAYAN PRATAMACOAL, PT	-	-	VCE	EC210D	253392	255	WARRANTY	RUNNING	2023-04-04 00:00:00.0000000	Melak	BALIKPAPAN	Service 250 EC210D SN253392 PT GBU	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	service	Nova Ardianto	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-04-04 13:14	2023-04-04 13:14	2023-04-04 13:40	2023-04-04 19:01	2023-04-04 16:20	2023-04-04 19:01	2023-04-04 21:02	2023-04-05 08:06	2023-04-05 08:07	1181.0	347.0	7.0	YES	0.0