Solved

need excel to show gaps in data

Posted on 2013-12-03
3
259 Views
Last Modified: 2013-12-03
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....
0
Comment
Question by:CASorter
  • 2
3 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
Comment Utility
I think you would have to do a VBA program. Do you want to have one or would you do it yourself?
0
 

Author Comment

by:CASorter
Comment Utility
that's wht I kind of figured.

I am working on one now.
as a sql SP
0
 

Author Closing Comment

by:CASorter
Comment Utility
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.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now