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
6827.0	ADMIN	BRANCH	August	1690866173869	WO23184426	MENGGALA VICTORY JAYA, PT.	-	-	SDLG	E6210F	0609627	-	NON WARRANTY	STANDBY	2023-08-01 00:00:00.0000000	Sorong	SORONG	Service 250 Hours	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Done	Afrizal Fawzi	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-08-01 12:02	2023-08-01 12:03	2023-08-01 12:10	2023-08-01 12:10	2023-08-01 12:10	2023-08-01 12:10	2023-08-01 12:26	2023-08-01 12:29	2023-08-01 15:19	1078.0	7.0	0.0	NO	0.0
6828.0	ADMIN	BRANCH	August	1690866203130	WO23184287	KARYA PRATAMA NIAGAJAYA, PT.	-	-	SDLG	LG936L	604738	9050	NON WARRANTY	RUNNING	-	MEDAN	MEDAN	Replace Engine	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	finished	Ferdian Dinata	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-08-01 12:03	2023-08-01 12:03	2023-08-01 12:13	2023-08-01 13:57	2023-08-01 12:13	2023-08-01 13:57	2023-08-01 15:38	2023-08-01 20:32	2023-08-02 11:11	1078.0	114.0	3.0	YES	0.0
6829.0	ADMIN	BRANCH	August	1690867045546	WO23184403	PASELA JAYA,PT.	-	-	VCE	EC200D	00280537	-	NON WARRANTY	STANDBY	2023-08-01 00:00:00.0000000	sorong	SORONG	Troubleshoot Engine Black Smoke	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job Done	Sugiharto Wicaksono	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-08-01 12:17	2023-08-01 12:17	2023-08-02 14:08	2023-08-02 14:10	2023-08-02 14:08	2023-08-02 14:10	2023-08-02 14:12	2023-08-02 16:13	2023-08-04 06:21	1078.0	1553.0	25.0	NO	0.0
6830.0	ADMIN	BRANCH	August	1690870043044	WOSD184534	BARA REZEKI HAMIZAN, PT	-	-	SDLG	G9220	600594	1015	WARRANTY	STANDBY	2023-08-01 00:00:00.0000000	BINUANG	BANJARMASIN	AC HOT AC COMMPRESSOR	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	UNIT RFU	Subiyanto	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-08-01 13:07	2023-08-01 13:07	2023-08-02 10:26	-	2023-08-02 10:26	-	2023-08-03 18:35	2023-08-03 18:36	2023-08-03 18:36	1078.0	-	53.0	YES	0.0
6831.0	ADMIN	BRANCH	August	1690871162861	WO23184546	LOURY NAJOAN	-	-	SDLG	E660FL	625754	-	WARRANTY	RUNNING	-	MAUMBI MANADO	MANADO	Inspect Vibrating Cabin	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive	Hari Manaf Pongoliu	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2023-08-01 13:26	2023-08-01 13:26	2023-08-01 14:02	2023-08-01 15:14	2023-08-01 14:02	2023-08-01 15:14	2023-08-01 17:32	2023-08-01 17:32	2023-08-03 15:28	1078.0	109.0	4.0	YES	0.0
6832.0	MECHANIC	MECHANIC	August	1690873428232	WO23184546	LOURY NAJOAN	-	-	SDLG	E660FL	625754	-	WARRANTY	STANDBY	2023-08-01 00:00:00.0000000	Maumbi	MANADO	Inspect Vibrating Cabin	ETC	INSPECTION	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Arive	Meinhart putrev parangen	Meinhart putrev parangen	082293985163	meinhartparangen@gmail.com	2023-08-01 14:03	2023-08-01 14:04	2023-08-01 14:04	2023-08-01 15:32	2023-08-01 14:04	2023-08-01 15:32	2023-08-01 16:41	2023-08-01 17:26	2023-08-03 15:29	1078.0	88.0	2.0	YES	0.0
6833.0	ADMIN	BRANCH	August	1690878411482	WO23184253	ULIMA NITRA, PT	-	-	VCE	EC480DL	285033	1000	WARRANTY	RUNNING	-	MUARATARA	PALEMBANG	SERVICE MAINTENANCE 1000 HOURS	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Ready job	Binharun Sipahutar	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-08-01 15:26	2023-08-01 15:27	2023-08-01 15:28	2023-08-01 18:23	2023-08-01 15:28	2023-08-01 18:23	2023-08-03 06:49	2023-08-04 05:49	2023-08-04 05:49	1078.0	177.0	39.0	YES	0.0
6834.0	ADMIN	BRANCH	August	1690878571848	WO23184259	ULIMA NITRA, PT	-	-	VCE	EC480DL	285036	750	WARRANTY	RUNNING	-	MUARATARA	PALEMBANG	SERVICE MAINTENANCE 750 HOURS	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back to office palembang	Edy Nugroho	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-08-01 15:29	2023-08-01 15:30	2023-08-01 15:31	2023-08-01 18:13	2023-08-02 12:06	2023-08-01 18:13	2023-08-02 12:40	2023-08-04 09:21	2023-08-04 09:22	1078.0	164.0	21.0	YES	1.0
6835.0	ADMIN	BRANCH	August	1690880454306	WO23184419	EAST INFINITA INDONESIA, PT	-	-	VT	FL664R	B433623	10364	NON WARRANTY	RUNNING	-	DURI	PEKANBARU	Electrical system problem	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	TRISKI ADRIAN	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-08-01 16:00	2023-08-01 16:01	2023-08-02 08:40	2023-08-02 15:10	2023-08-02 08:40	2023-08-02 15:10	2023-08-07 15:22	2023-08-08 08:49	2023-08-08 14:40	1078.0	1389.0	143.0	YES	0.0
6836.0	ADMIN	BRANCH	August	1690882862345	WOSD184580	PEBANA ADI SARANA, PT	-	-	SDLG	L956F	625025	1	WARRANTY	RUNNING	-	PANGKALAN	PEKANBARU	Seal input shaft front axle leak	ECT	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Sampai	MUHAMMAD FITRIO DEHEN	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-08-01 16:41	2023-08-01 16:41	2023-08-02 08:41	2023-08-02 13:55	2023-08-02 08:41	2023-08-02 13:55	2023-08-03 10:49	2023-08-03 14:57	2023-08-03 15:34	1078.0	1275.0	42.0	YES	0.0