Find Jobs
Hire Freelancers

Create Excel VBA

£20-250 GBP

Completed
Posted about 6 years ago

£20-250 GBP

Paid on delivery
I am looking to streamline a data analysis process with an Excel VBA workbook. The worksheet would require to sets of data to pasted into names sheets. Both data sets are the same size, with a fixed width of 49 columns (1 date field, with 48 data points) but a variable length (though this is typically, but not always, 365 or 366 rows depending on if the data spans a leap year). The data set would pasted into the sheet starting at cell B2 (row A would contain the headers and would be fixed within the sheet). In the A column, the day of the week for each row would need to be calculated based on the data in column B. Once the data has been pasted into the relevant worksheets the following processing needs to occur: 1) Total for each of the 48 data points in the last row of the data set 2) Minimum value of each of the 48 data points below total 3) Maximum value of each the 48 data points below minimum 4) Average value of each of the 48 data points below the maximum 5) Total for each row in column AY 6) Total for a subset of data in columns AZ (this will be based on user input and the range set from a lookup table) 7) Total for a subset of data in columns BA (as above) A third worksheet would need to be created which has the same dimensions of the other two sheets, and it would contain: Column A - Day (the same as the two data sets) Column B - Date (the same as the two data sets) Columns C - AX - the result of a mathematical operation from the corresponding cells in each data sheet Columns AY, AZ, BA - totals as per the data sets Below last row - the same total / min / max / average as the data sets Then a number of tables would need to be generated: Firstly, a table which, by month, showed the total from one of the data sets Then, for the same data set, the total for each day of the week for the entire period From the tables I would need three charts to be generated: Bar chart which plots the monthly totals Pie chart which shows percentage of total for each day of the week Scatter chart which plots the entire length of the data series, with each day of the week representing one series (I can send you a sample chart) Then the data needs to to parsed in such a way that I can create surface plots, one plot for each three months of data. Typically the data will span a whole year so there would normally be four plots. The plots would have the date on the x axis (with the range set automatically) and the headers from the data set on the y-axis. The value of each data point would be on the z-axis. The z-axis needs to have the maximum value calculated from the whole data set, the with majority unit set to 10% of the maximum. Some additional charts also need to be generated: A simple line plot of the data which matches 25-Dec A simple line plot that plots a line for each weekday (i.e 7 plots) using the average of the of the 48 datapoint related to each day on the x-axis A simple plot which uses some of the data from the calculated third data sheet (to be later defined)
Project ID: 16405052

About the project

20 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

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:
User Avatar
- Based on both the data sets, for the particular 48 data points, calculation of Min, Max Average and subset calculations be done. - Third sheet with the data sheets and the necessary tables for the Bar, Pie and Scatter charts. - Surface chart based on each 3 months of data. - On the fix and flipping side, identify the properties, orignial cost, all additional costs and have a sale price fixed. - Track the sales amount and calculate the profit. - Additional features can be included to track the customers showing interest until the property deal gets closed. - Additional charts and Smple line plots can be discussed. - Have done similar calculations and graphing charts (Freelancer projects) My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Pl. go through my portfolio some of the highcompled projects done.
£250 GBP in 7 days
4.7 (53 reviews)
6.0
6.0
20 freelancers are bidding on average £216 GBP for this job
User Avatar
Hi, my name is Sevinc. I read your "Create Excel VBA" project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
£250 GBP in 3 days
4.9 (333 reviews)
8.0
8.0
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.
£250 GBP in 3 days
5.0 (117 reviews)
6.4
6.4
User Avatar
sir Excel VBA expert
£250 GBP in 1 day
4.7 (83 reviews)
6.3
6.3
User Avatar
Thanks for the heads up. Yes, I can develop this excel macro. Please reply, we can discuss further and get it started soon. Thank you.
£60 GBP in 2 days
4.8 (205 reviews)
6.1
6.1
User Avatar
Hi, I have excellent experience in excel VBA, Charts and formula. have worked on multiple projects in automation of process in excel and creation of dashboards. I have worked in Infosys which is a top tier IT company for more than 10 years. Thanks Regards vaidy
£150 GBP in 3 days
5.0 (15 reviews)
5.2
5.2
User Avatar
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel macro enabled project very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
£555 GBP in 10 days
4.7 (33 reviews)
5.8
5.8
User Avatar
Hello, I am a EXCEL EXPERT with Ms-Excel Related work Including Macros with 10 years of Exprience. I have already completed About 2000+ On Various Freelance Websites I can give you quality work in quick time Thank you Mohammed Sutarwala (Always work with a Proven Freelancer)
£33 GBP in 2 days
4.8 (44 reviews)
5.6
5.6
User Avatar
I am not a random bidder.. I have 14+ years of exp with various project exposure.. Please ping me if you are interested with my proposal and thank you...
£200 GBP in 3 days
4.9 (28 reviews)
5.0
5.0
User Avatar
Greeting, I have understood your Create Excel VBA task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps
£200 GBP in 3 days
4.8 (14 reviews)
5.2
5.2
User Avatar
Hello. I propose to make necessary macros/sheet templates in 3 days. The task include a lot of things to do, so I'd like to have a person who can clarify any subtleties which cannot be anticipated from the start. Could you please also share a sample of input data? This will help in understanding the job. Best regards, Alexander.
£115 GBP in 3 days
5.0 (18 reviews)
4.5
4.5
User Avatar
Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | VBA Expert |
£150 GBP in 3 days
5.0 (9 reviews)
4.1
4.1
User Avatar
A proposal has not yet been provided
£222 GBP in 5 days
5.0 (2 reviews)
2.4
2.4
User Avatar
Hello, I m new to freelancer, I have two years experience in the field of data entry,data processing, excel. My typing speed is 90 WPM with 100% accuracy. I would like to tell you that i have all the desired skills for this project and will complete it in specified time and I would like to offer my service to you.
£111 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Proposal: 1. Let's have a kick off meeting in order to verify every single step you want to mapparently atomate vby using VBA inside Excel. 2. Let's make in 3 days a Beta version of the Modules VBA you'll need. 3. Maybe my BId is higher than the rest, but is real. 4. let's start booking and working on this right awat, in order to put it inside my stressed agenda. 5. You will obtain a great result. Hire me. Kind Regards.
£777 GBP in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Woodstock, United Kingdom
0.0
0
Payment method verified
Member since Mar 2, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.