Reporting Table

[coordinaters]

Dear all,

i need to compile the number of Train Service Degradation >10mins travelling time versus scheduled timetable in a table format.


Definition:
"Train Service Degradation" means any incident which results in a lengthening of travelling time of more than or equal to 10 minutes, over a duration of 60 minutes or more.

Requirements for reporting table:
(a) Each instance of Service Degradation shall be accompanied by data of affected train within the incident sector.
(b) As a minimum, train/system information for each affected train include date, start time, end time, train ID, service number, trip number, location , direction train bound, difference in travelling time(actual vs schedule).

I noted a table (table1) that minimally meet this requirement.

However, i received another table (table 2) with the additional columns in green.

I already a table 1 which mentions about service degradation. Will the table suffice?
Appreciate your valuable comments and inputs on table 2 - Thank you!

Regards,
Coordinaters


Table 1

Date​	Weeknum​	Start Time (HH:MMS)​	End Time (HH:MMS)​	Train ID​	Service Number / Trip Number​	Location​	Bound​	Actual Travelling Time (HH:MMS)​	Scheduled Travelling Time (HH:MMS)​	Deviation (Actual - Scheduled) (HH:MMS)​
​	​	​	​	​
​	​	​	​	​
​	​	​	​	​
​	​	​	​	​
​	​	​	​	​
​	​	​	​	​
​	​	​	​	​
​	​	​	​	​

Table 2

Date​

Start Time (HH:MMS)​

End Time (HH:MMS)​

Train ID​

Service Number / Trip Number​

Location​

Bound​

Dep XO BB PF (HH:MMSS)​

Arr UI BB PF (HH:MMSS)​

Actual Travelling Time (HH:MMS)​

Scheduled Travelling Time (HH:MMS)​

Scheduled Arrival Time (HH:MMS)​

Deviation (Actual - Scheduled) (HH:MMS)​

20/08/2020​

9:14​

10:30​

78​

124 / 1078​

XO-UI​

BB​

08:53:09​

09:18:14​

00:25:05​

00:17:22​

09:11:17​

00:07:43​

35​

231 / 1079​

XO-UI​

BB​

08:54:43​

09:22:57​

00:28:14​

00:17:22​

09:13:30​

00:10:52​

12​

125 / 1080​

XO-UI​

BB​

08:57:22​

09:26:48​

00:29:26​

00:17:22​

09:16:05​

00:12:04​

75​

232 / 1081​

XO-UI​

BB​

08:59:33​

09:32:11​

00:32:38​

00:17:22​

09:18:18​

00:15:16​

79​

126 / 1082​

XO-UI​

BB​

09:02:16​

09:35:48​

00:33:32​

00:17:22​

09:20:53​

00:16:10​

77​

233 / 1083​

XO-UI​

BB​

09:04:19​

09:39:29​

00:35:10​

00:17:22​

09:23:06​

00:17:48​

55​

101 / 1084​

XO-UI​

BB​

09:06:54​

09:42:54​

00:36:00​

00:17:22​

09:25:41​

00:18:38​

63​

201 / 1085​

XO-UI​

BB​

09:09:06​

09:47:04​

00:37:58​

00:17:22​

09:27:54​

00:20:36​

25​

202 / 1086​

XO-UI​

BB​

09:14:16​

09:52:36​

00:38:20​

00:17:22​

09:30:19​

00:20:58​

53​

102 / 1087​

XO-UI​

BB​

09:18:44​

09:59:52​

00:41:08​

00:17:22​

09:32:42​

00:23:46​

50​

203 / 1088​

XO-UI​

BB​

09:24:01​

10:08:07​

00:44:06​

00:17:22​

09:35:07​

00:26:44​

4​

103 / 1089​

XO-UI​

BB​

09:27:37​

10:14:44​

00:47:07​

00:17:22​

09:37:30​

00:29:45​

17​

204 / 1090​

XO-UI​

BB​

09:29:06​

10:19:04​

00:49:58​

00:17:22​

09:39:55​

00:32:36​

14​

104/ 1091​

XO-UI​

BB​

09:30:34​

10:24:05​

00:53:31​

00:17:22​

09:42:18​

00:36:09​

34​

205 / 1092​

XO-UI​

BB​

...