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
322.0	BRANCH	MECHANIC	January	1673416108206	21159830	ARRALI JAYA ABADI, CV	-	-	VCE	EC200D	280273	4500	WARRANTY	BREAKDOWN	2023-01-11 00:00:00.0000000	Jayapura	SORONG	(280273) Battrey flat - CV Arrali Jaya Abadi	ENGINE	OTHER	RE-DO	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	Service koordinator (Sorong - Nusa tenggara)	Trifenia Soukotta	081240668088	admin.sorong@indotruck-utama.co.id	2023-01-11 12:48	2023-01-11 12:50	2023-02-13 10:02	2023-02-13 10:03	2023-02-13 10:02	2023-02-13 10:03	2023-02-13 10:05	2023-02-17 13:45	2023-02-17 13:46	1245.0	47355.0	789.0	YES	2.0
323.0	BRANCH	MECHANIC	January	1673416604891	170399	ARRALI JAYA ABADI, CV	-	-	VCE	EC200D	281139	1699	WARRANTY	BREAKDOWN	2023-01-11 00:00:00.0000000	Jayapura	SORONG	(281139) Engine black smoke - CV Arrali Jaya Abadi	ENGINE	OTHER	RE-DO	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	Service koordinator (Sorong - Nusa tenggara)	Trifenia Soukotta	081240668088	admin.sorong@indotruck-utama.co.id	2023-01-11 12:56	2023-01-11 12:56	2023-01-13 06:00	2023-01-13 18:07	2023-01-13 06:00	2023-01-13 18:07	2023-01-13 18:09	2023-01-18 06:58	2023-01-18 07:01	1245.0	3190.0	53.0	YES	0.0
324.0	BRANCH	MECHANIC	January	1673416798725	170400	ARRALI JAYA ABADI, CV	-	-	VCE	EC200D	250283	395	WARRANTY	RUNNING	2023-01-11 00:00:00.0000000	Jayapura	SORONG	(250283) Install radio unit EC200D - CV Arrali Jaya Abadi	ENGINE	OTHER	RE-DO	-	-	-	LEADER	COMPLETED	COMPLETED	Selesai	Service koordinator (Sorong - Nusa tenggara)	Trifenia Soukotta	081240668088	admin.sorong@indotruck-utama.co.id	2023-01-11 12:59	2023-01-11 13:00	2023-01-14 05:17	-	2023-01-14 05:17	-	2023-01-15 11:32	2023-01-18 06:57	2023-01-18 07:00	1245.0	-	94.0	YES	0.0
325.0	MECHANIC	MECHANIC	January	1673418343999	401	BAHTERA PUTERA NUSANTARA, PT.	-	-	VT	FH1655064T	PM 15 -a765543	29985	NON WARRANTY	BREAKDOWN	2023-01-11 00:00:00.0000000	bpn	MUARA ENIM	brake problem	BRAKE	REPAIR	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	cannibal torque plate brake pos 5 and install, cannibal pinion and adjuster and install pos 3..install lining &tire,pos 5&6, remove brake pos 3	Budi Nur Andika	Budi Nur Andika	081354014449	budinurandika@gmail.com	2023-01-11 13:25	2023-01-11 13:27	-	-	-	-	-	-	2023-01-12 20:28	1245.0	-	-	NO	1.0
326.0	BRANCH	BRANCH	January	1673418661605	170322	BERKAH ANUGERAH RIZQI ABADI COAL PT	-	-	SDLG	G9220	600554	1074	NON WARRANTY	STANDBY	2023-01-11 00:00:00.0000000	SATUI	BANJARMASIN	WIPER MOTOR NOT FUNCTION G9220F SN600554	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	replace wiper motor RH completed	Achmad faisal	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-01-11 13:31	2023-01-11 13:31	2023-01-30 08:21	2023-01-30 16:56	2023-01-30 08:21	2023-01-30 16:56	-	-	2023-02-10 08:24	1245.0	27565.0	-	YES	0.0
327.0	BRANCH	BRANCH	January	1673418834669	170330	HILLCONJAYA SAKTI, PT	-	-	VCE	EC950E	370130	4931	NON WARRANTY	STANDBY	2023-01-11 00:00:00.0000000	KOTABARU	BANJARMASIN	CRANKSHAFT SEAL LEAK EC950E SN370130	TRANSMISSION	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Test grounding,...	Sonny Adi Putra	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-01-11 13:33	2023-01-11 13:34	2023-01-17 17:38	2023-01-17 17:38	2023-01-17 17:38	2023-01-17 17:38	2023-01-17 17:40	2023-01-17 17:40	2023-01-17 17:41	1245.0	8884.0	148.0	YES	0.0
328.0	BRANCH	BRANCH	January	1673419136542	21170349	INDOTRUCK UTAMA, PT.	-	-	SDLG	E660FL	625792	1	WARRANTY	RUNNING	2023-01-11 00:00:00.0000000	.	BANJARMASIN	AI & PDI UNIT	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	RFU 09-01-23	eko supri	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-01-11 13:38	2023-01-11 13:44	2023-01-13 15:15	2023-01-13 15:15	2023-01-13 15:15	2023-01-13 15:15	2023-01-13 15:17	2023-01-13 15:17	2023-01-13 15:18	1245.0	2977.0	49.0	YES	5.0
329.0	BRANCH	BRANCH	January	1673419281408	21170331	INDOTRUCK UTAMA, PT.	-	-	SDLG	G9220	600591	9	WARRANTY	RUNNING	2023-01-11 00:00:00.0000000	.	BANJARMASIN	AI & PDI UNIT	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	RFU	Muhamad Erdi Setiawan	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-01-11 13:41	2023-01-11 13:43	2023-01-11 14:57	2023-01-11 14:57	2023-01-11 14:57	2023-01-11 14:57	-	-	2023-01-11 14:58	1245.0	76.0	-	YES	2.0
330.0	BRANCH	BRANCH	January	1673419843852	170496	MARYONO	-	-	SDLG	L968L	620525	1773	NON WARRANTY	STANDBY	2023-01-11 00:00:00.0000000	BATI BATI	BANJARMASIN	CYLINDER STERING LEAK L968F SN620525	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	unit waiting part	Junaidi Arsyandi	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-01-11 13:50	2023-01-11 13:51	2023-01-15 12:32	2023-01-18 13:01	2023-01-15 12:32	2023-01-18 13:01	2023-01-23 06:42	2023-01-25 11:07	2023-01-25 11:07	1245.0	10031.0	280.0	YES	0.0
331.0	MECHANIC	MECHANIC	January	1673420515377	WO23170433	BINTANG ALAM REJEKI, PT.	-	-	VCE	A40G	322115	18082	NON WARRANTY	RUNNING	2023-01-11 00:00:00.0000000	muara badak	SAMARINDA	A40G B119 SERVICE 2000HRS	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-01-11 14:01	2023-01-11 14:02	2023-01-11 14:02	2023-01-11 15:42	2023-01-11 14:02	2023-01-11 15:42	2023-01-12 06:46	2023-01-12 06:47	2023-01-12 06:47	1245.0	100.0	16.0	YES	0.0