CASorter
asked on
need excel to show gaps in data
i have a set of data that looks like this
it represents events per minute
evttyp station hour minute events
30 STAT0102 3 9 15 2
30 STAT0102 3 9 16 3
30 STAT0102 3 9 17 8
30 STAT0102 3 9 20 10
30 STAT0102 3 9 21 2
30 STAT0102 3 9 22 1
30 STAT0102 3 9 25 6
30 STAT0102 3 9 26 3
30 STAT0102 3 10 4 3
30 STAT0102 3 10 5 5
30 STAT0102 3 10 6 10
30 STAT0102 3 10 7 1
30 STAT0102 3 10 12 1
30 STAT0102 3 10 13 4
30 STAT0102 3 10 14 3
30 STAT0102 3 10 15 8
30 STAT0102 3 10 16 10
30 STAT0102 3 10 17 11
30 STAT0102 3 10 18 5
30 STAT0102 3 10 19 3
30 STAT0102 3 10 20 2
30 STAT0102 3 10 29 1
i need it to show the gaps where there are no events in a given minute or series of minutes
so i need
30 STAT0102 3 9 15 2
30 STAT0102 3 9 16 3
30 STAT0102 3 9 17 8
30 STAT0102 3 9 18 0
30 STAT0102 3 9 19 0
30 STAT0102 3 9 20 10
30 STAT0102 3 9 21 2
30 STAT0102 3 9 22 1
30 STAT0102 3 9 23 0
30 STAT0102 3 9 24 0
30 STAT0102 3 9 25 6
30 STAT0102 3 9 26 3
30 STAT0102 3 9 27 0
30 STAT0102 3 9 28 0
30 STAT0102 3 9 29 0
30 STAT0102 3 9 30 0
...
...
30 STAT0102 3 10 1 0
30 STAT0102 3 10 2 0
30 STAT0102 3 10 3 0
30 STAT0102 3 10 4 3
30 STAT0102 3 10 5 0
30 STAT0102 3 10 6 0
and so on.
is there a way to do this in xcell..... or do i just need to do it programaticaly.
i was hoping to be able to cut and past the raw data to the Spread sheet and have the
resulting data populate out....
it represents events per minute
evttyp station hour minute events
30 STAT0102 3 9 15 2
30 STAT0102 3 9 16 3
30 STAT0102 3 9 17 8
30 STAT0102 3 9 20 10
30 STAT0102 3 9 21 2
30 STAT0102 3 9 22 1
30 STAT0102 3 9 25 6
30 STAT0102 3 9 26 3
30 STAT0102 3 10 4 3
30 STAT0102 3 10 5 5
30 STAT0102 3 10 6 10
30 STAT0102 3 10 7 1
30 STAT0102 3 10 12 1
30 STAT0102 3 10 13 4
30 STAT0102 3 10 14 3
30 STAT0102 3 10 15 8
30 STAT0102 3 10 16 10
30 STAT0102 3 10 17 11
30 STAT0102 3 10 18 5
30 STAT0102 3 10 19 3
30 STAT0102 3 10 20 2
30 STAT0102 3 10 29 1
i need it to show the gaps where there are no events in a given minute or series of minutes
so i need
30 STAT0102 3 9 15 2
30 STAT0102 3 9 16 3
30 STAT0102 3 9 17 8
30 STAT0102 3 9 18 0
30 STAT0102 3 9 19 0
30 STAT0102 3 9 20 10
30 STAT0102 3 9 21 2
30 STAT0102 3 9 22 1
30 STAT0102 3 9 23 0
30 STAT0102 3 9 24 0
30 STAT0102 3 9 25 6
30 STAT0102 3 9 26 3
30 STAT0102 3 9 27 0
30 STAT0102 3 9 28 0
30 STAT0102 3 9 29 0
30 STAT0102 3 9 30 0
...
...
30 STAT0102 3 10 1 0
30 STAT0102 3 10 2 0
30 STAT0102 3 10 3 0
30 STAT0102 3 10 4 3
30 STAT0102 3 10 5 0
30 STAT0102 3 10 6 0
and so on.
is there a way to do this in xcell..... or do i just need to do it programaticaly.
i was hoping to be able to cut and past the raw data to the Spread sheet and have the
resulting data populate out....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
you were correct, I needed to do it programmatically, it wasn't that hard, just wanted to see if it could be done with excel.....
thanks for the pointer.
thanks for the pointer.
ASKER
I am working on one now.
as a sql SP