Em Andamento

Improve my Excel Macros

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.

## Deliverables

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.

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic, Visual Basic para Apps

Ver mais: writing macros in excel, writing macros, writing excel macros, works need excel, which graph to use for data, where are graphs used, what is placement new, what is a temp, what graph to use for data, what are graphs used for, what are graphs for, sample graph data, max graph, make pretty graphs, improve writing, how to improve writing, how to improve my writing, how to graph data, how to create graph, how to create a graph, how many graphs are there, how excel works, how do you graph data, how can i make my writing better, how can i improve my writing

Acerca do Empregador:
( 11 comentários ) United States

ID do Projeto: #2985155

Premiar a:


See private message.

$68 USD em 14 dias
(85 Avaliações)

2 freelancers estão ofertando em média $77 para este trabalho


See private message.

$85 USD in 14 dias
(3 Comentários)