Hello All, I am a new member to this forum and would appreciate your help. I have a relatively large data set (27,000+ rows of data and ZZ columns).
I am trying to develop a simple macros to perform some data reduction for this large set and need assistance. I have no experience in creating a macros or VBA.
In column A I have time in seconds. This is a continuous incremental reading take by LabView software. (i.e. 1,2,3,4...
In column B I have a counter value. This is also continuous reading also. I have a piece of equipment connected to LabView software that records a count of Items as a function of time. The value is either 0 or 1. This counter records values that can occur any time between 1 second and 1000's of seconds, depending upon the rate. (i.e. 0,0,0,1,0,0,1,0,1,0,0,0,0,0,0,1....
I would like to to determine an incremental counter rate or simply the frequency of counts per second for each increment . Because the recorded incremental count is not continuous, it fluctuates, and I am having difficulty determining an incremental frequency. I would like to avoid manually entering equations for each incremental time, because this is such a huge data set.
Any input would be greatly appreciated. I have provided a small example of my excel file if that helps. I can be reached at [email protected]
Thanks for your time and assistance.
Bookmarks