Em Andamento

macro subroutine to add data elements

Hi

Following is project description

Have a spreadsheet of 93K data elements. 1 column of 93K rows.

Need to add every 100 elements and multiply by 10, to create a result of 930 data points in another column.

In other words: Need Sum(1:99)*10, Sum(100:199)*10, and so on

Also need to graph(scatter plot) above data on y axis. x axis will correspond to row numbers.

For example data points for graph in (x,y) is (1, Sum(1:99)*10) (2, Sum(100:199)*10) and so on.

Need a macro/subroutine that can be used against another dataset.

Habilidades: Excel, Visual Basic

Ver mais: data plot, macro spreadsheet, create macro project, macro add, add data, create macro, add spreadsheet, add points, sum numbers, plot graph, elements , macro add row data, graph data, spreadsheet add, create graph data, subroutine plot, macro data spreadsheet, data management excel macro, subroutine plot graph, data web excel macro, data graph, data excel sheet macro, post data add firefox

Acerca do Empregador:
( 1 comentário ) Somerset, United States

ID do Projeto: #5121288

Premiar a:

Teloquence

Hired by the Employer

$50 USD em 1 dia
(160 Avaliações)
6.5