Macro to analyse data

$20-30 NZD / hour

Completed

Posted

almost 9 years ago

$20-30 NZD / hour

I need to have a macro written to add up the values (rainfall) over a 24 hour period The data is continuously being added to, so the macro needs to always look for the end of the data in column Q and then add up the last 24 entries for tab "Factory" and the last 48 entries for tab 'CTL' and put that total in a cell at the top of the spreadsheet (Q4). It would also be good to have some code written to open our weather application and auto populate the spreadsheet but this job is just a simple macro to start with and then we may venture more after that.

Data Processing

Excel

Project ID: 8245612

About the project

8 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

$20 NZD in 1 day

5.0

(59 reviews)

4.8

8 freelancers are bidding on average $22 NZD/hour for this job

@Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$30 NZD in 4 days

4.9

(294 reviews)

7.5

@nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. You don't need a macro for calculating the sum of the last 24/48 entries, it can be done with advanced formulas composed from Excel built in functions. I have a free solution ready for you for summing up the last 24 entries, I can send you it immediately if you open a chat. I can complete the other formula (summing 48 entries) immediately if you award me the project. I can create a macro importing new data for an extra $15 if you provide the structure and file format of the new data. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards Regards

$22 NZD in 1 day

4.9

(56 reviews)

5.6

@fabest

Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice

$20 NZD in 5 days

4.9

(13 reviews)

5.3

@Ameba871117

HI I can do iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiit

$22 NZD in 1 day

5.0

(11 reviews)

3.7

@hiteshbbakutra

Professional data scientist and excel expert. More than 5 years of experience in handling complex data sets. Can finish this job in minutes. Already created similar automation sheet for some other clients. Can send sample work before start.

$20 NZD in 1 day

4.8

(4 reviews)

2.6

@fb55504d0e01bfc

Hi, I have too much experience on weather data logging, conversion and treatment using all kinds of tools (workbooks, matlab, R, etc). I can surely help you in this and in your future conversion projects. Thank you for taking my offer in consideration Sincerely Panagiotis

$25 NZD in 1 day

5.0

(1 review)

2.2

@pharaolancers

We are group of interdisciplinary professionals from different engineering backgrounds aiming at finishing projects effectively and with the highest quality. We have got experience in writing different macros for different applications thus we can master these basic calculations in minimum time. We have listed 2 hrs/week as this project will take 2 hours max. However, we can work more hrs/week to finish more macros if needed.

$20 NZD in 2 days