Em Andamento

create excel macro for converting table

A macro shall transform a table from one format into another. The table gives time intervals and further values assigned to these intervals. I am interested in converting the time intervals (calendar data) into a series, and assigning numeric values to these intervals in the series in a consecutive order. Attached is a sample structure that gives you an impression what shall be done. So, basically, the task is the following: 1) read out the time intervals. 2) create a calendar series out of that data 3) for each column in the table, extract the numeric values 4) create a new table for each column with contains the time series (2) and the numeric values (3) Upon acceptance of the project I would submit a more detailed table.

Habilidades: Processamento de dados, Excel, Visual Basic, Visual Basic para Apps

Veja mais: find an engineer to create a bistable structure, create macro or formula to calculate quantity of patterns along a row of numbers, create brochure describing company structure business model culture, create macro solidworks, create macro outlook 2007 dial contact, java create excel file read file, automatically create macro outlook, create brochure decribing company structure, create macro email completed word document, create text file read file, create macro cut paste data, create macro cut paste web database, create macro wordperfect, create macro outlook 2003

Acerca do Empregador:
( 68 comentários ) Leipzig, Germany

ID do Projeto: #16720342

Concedido a:

sloker18

I am proficient with excel macro/VBA development, I have checked your sample file, I can write the code to retrieve and convert the data into new format as specified, if you are interested feel free to message me so we Mais

$20 USD em 1 dia
(11 Comentários)
3.5

12 freelancers estão ofertando em média $25 para esse trabalho

$26 USD em 1 dia
(293 Comentários)
7.2
JackieXu

hello. how are you? i am expert of python, Microsoft Word,Microsoft Excel, excel VBA and data Scraping. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best r Mais

$25 USD em 1 dia
(24 Comentários)
4.6
INFINITYADVERT

HI, I have 9 years of experience and can do this task for you. I have understood the project. I have a great knowledge of excel. I have worked in government sector also. I will solve your problem. :) THanks

$30 USD in 0 dias
(3 Comentários)
3.1
maximwang8661

i just went through your job post. it's very interesting to me. If you hire me, I can start working for you right now.

$25 USD em 1 dia
(2 Comentários)
1.9
DataExpert3

Dear Employer, I will give you the best result by using my past experience. You can chat with me and let's get started. Also ready to show you samples of similar projects I have completed. Thank You.

$25 USD in 2 dias
(3 Comentários)
2.1
$25 USD em 1 dia
(0 Comentários)
0.0
eshwar665

with my very good talent and experience of 15 years i will surely complete the given work on time and satisfy the requirements .

$25 USD em 1 dia
(0 Comentários)
0.0
$25 USD em 1 dia
(0 Comentários)
0.0
aniruddhachttrj

A proposal has not yet been provided

$20 USD in 2 dias
(0 Comentários)
0.0
aseeyasubuhan

A proposal has not yet been provided

$25 USD in 2 dias
(0 Comentários)
0.0
shreya1131

A proposal has not yet been provided

$30 USD in 5 dias
(0 Comentários)
0.0