Optimize event selection

[K Rich]

Hi, I am trying to select the best event for a particular day. There are 3 types of possible events, and there can be multiple instances of the same possible event. I need to figure out which is the longest contiguous event for each event type, and then which is the longest contiguous event out of all the event types. Here is a sample from my spreadsheet where 1st col is time, next 3 cols are the event types, called ones, twos & threes. What I would like is a table showing the longest contiguous span of time for each event type, and which is the longest of all the spans for the day.
Time ones twos threes
1130 0 0 0
1135 0 0 0
1140 1 0 0
1145 0 0 3
1150 1 0 3
1155 1 0 3
1200 1 2 3
1205 1 2 3
1210 0 2 3
1215 0 2 3
1220 0 2 0
1225 0 2 0
1230 1 2 0
1235 1 2 0
1240 1 2 0
1245 1 2 0
1250 1 2 0
1255 1 2 0
1300 1 2 0
1305 1 2 0
1310 1 0 3
1315 1 2 3
1320 0 2 3
1325 0 0 0
1330 0 0 0
1335 1 0 0
1340 1 0 0
1345 0 0 0
1350 0 0 0
1355 0 0 0
1400 0 0 0