Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Microsoft Excel,Statistics freelancer for VBA Macro needed with a loop to transpose some data job

Posted at - Jul 5, 2022


I have an excel file with hourly prices in it per day per sheet ('Auction Clearing Price [EUR/MWh]'). Each sheet is a day with multiple Auction ID's. Each workfile a month.

I need a VBA code with a transpose and a loop so that I can extract the data (Used to be able to do it myself). The data, 'Auction Clearing Price [EUR/MWh]', should come out horizontal with the day and the Auction ID to the left of it.

I will share the original data sheet and the example how the result should look with shortlisted candidates. Each Auction ID should have its own sheet. I have made the first 2.

In short, I need every 'Auction Clearing Price [EUR/MWh]' of every Auction ID in a horizontal format.

Please only apply if you can do this like in an hour or so as it really should take you no more then 10 minutes to make the code.

I am okay with tweaking it myself to extract and so forth.

ps. no need for you to take into account the daylight saving times effects in previous month.
ps2 I have added some old macro's in the Data Transpose file for your convenience. Maybe best to be ignored :)

About the recuiterMember since Sep 8, 2017 Milan
from Zuid-Holland, Netherlands

Skills & Expertise Required

Microsoft Excel Statistics 

Candidate shortlisted and hiredHiring open till - Jul 12, 2022

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$34.78
Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Data Mining And Management category.