I have a set of macros for excel that I am using to collate data from our experiments. However I suck at writing these macros as I have to brute force myself through VB and excel sytax.
What I have works, but its not flexible at all.
So what I need is for someone to try out my macros on a sample data file, see what each of the buttons do and then modify the set of macros to ask for how many cells there will be to collate (and remember that number for next time) and then provide the cleaned up data and graphs for any data set with any number of cells.
There is a main window which houses buttons for each macro I might want to use. This main window should be where I put the number of cells, and it should just remember what I used last time.
The main macros are as follows:
**delete every other:** this should not care how many cells are needed, it just gets rid of every other line of data. No modification of this macro should be needed
**clean up data**: adds some columns, adds column headings, calculates data for new columns. This will definitely need to know number of cells. The main function is to create data from the raw data. like differences in cell values, averages, standard deviations, max and mins, and so forth. The number of columns for this data depends on the number of cells, and the placement of these columns is right after the hours data, therefore, it is also dependant lon the number of cells.
**Create hours:** This adds a single colum of time in hours. It needs to know the number of cells because the column gets places after all the cell data, less cells, the lower the column number
**Fix Zeros:** This function is no longer used, but it gets rid of zeros in the temp data. This function does not need modification
**Create Temp Graph:** This creates a graph of all the temperatures. It needs to know the number of cells becuase it plots temp vs. hours, the location of the hours column is dependant on the number of cells.
**Create V and I graph:** this plots total voltage and current. Its plotted against hours. therefore the number of cells is important for this function to work.
**Create dV graph:** plots cell max, min, average and standard deviation along with current. Its plotted against hours. therefore the number of cells is important for this function to work.
**Create dV and I graph:** Plots the raw cell voltages and current against hours. The number of cells is important to be able to see all the cell voltages and becuase the placement of the hours column depends on the number of cells.
**Pressure data and Graph:** this function weans out some pressure differential data and creates columns for it. Then it plots the raw pressure data against hours. It needs to know the number of cells so it can read teh correct column for hours, and so it can put the differential data in the correct place.
all the code was originally made by recording, and then modified as needed. It probably programmed pretty stupidly. You are welcome to improve the code if it makes the cell number variability work better. all I care is that I get the functionality I have programmed in this.
I would load the sample file, and see what the buttons do, so you can understand what I want. Then go from there to make it flexible.
Attached is a sample raw data file. A completeed data file, and the macros.