Find Jobs
Hire Freelancers

Excel/VBA Automation Project - RAG Dashboard

$30-250 USD

Completed
Posted over 12 years ago

$30-250 USD

Paid on delivery
This is a dashboard project for a RAG (Red, Amber, Green) built in Excel. Formulas for thresholds and format will be provided. User input required., should look and feel like a powerpoint presentation. Automation is key. No input file, only user input. Requires stored values from the previous days calculation and the ability to save historical data. Charts showing trends of historical data is a big plus. I'll send you the info and show me a sample to win the bid.
Project ID: 1317417

About the project

13 proposals
Remote project
Active 12 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
Hi, I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel dashboard [login to view URL] see the different dashboard samples in the attached file. I am interested to work for your project. Please see my PM for more ddetails. Regards Fibin
$60 USD in 3 days
4.9 (25 reviews)
4.8
4.8
13 freelancers are bidding on average $115 USD for this job
User Avatar
Hello, please see the PM for details.
$200 USD in 3 days
5.0 (25 reviews)
7.2
7.2
User Avatar
Excel Whiz here ;) Please see PMB for more details
$67 USD in 0 day
4.9 (65 reviews)
5.9
5.9
User Avatar
Such jobs are my daily practice. 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. Please, see PMB for a RAG sample I recently made for a similar bid of mine. If you send me a sample file, I'm ready to create a draft pilot in order to make sure everything is rightly understood. Regards!
$120 USD in 3 days
4.9 (15 reviews)
4.7
4.7
User Avatar
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I am expert in Excel both excel standard and Vba coding. Now I have my own development similar to your project using in my own business. More detail provided in PM.
$60 USD in 3 days
5.0 (13 reviews)
4.3
4.3
User Avatar
Please, check my PM.
$50 USD in 0 day
5.0 (11 reviews)
4.1
4.1
User Avatar
Hi, I have a good deal of experience in data processing using excel. Please check PMB
$110 USD in 2 days
5.0 (7 reviews)
4.1
4.1
User Avatar
Hi, Please check PMB
$60 USD in 4 days
5.0 (1 review)
3.0
3.0
User Avatar
Hello, have done several Excel macros including car retailers and salary projection. Please check PM for a sample. Also, please tell me exactly what will you need. Will it be like a color picker?
$149 USD in 9 days
4.3 (2 reviews)
1.7
1.7
User Avatar
Dear BrLady7, Although I'm new on this site I'm an expert in using Excel and programming it using VBA macros as well as add-ins in C++ and C#. So any of these can be selected to come to a solution for your task, depending on what would fit best. Please send me additional details as you mention in task description. As far as I understand your task now, a single Excel file that will be automated by macros and by conditional formatting will suit your needs best. If you want it to look and feel like a PowerPoint presentation but need also to store data from every time a file is used, then at least one hidden worksheet will need to be created to store historical data and to display charts based on it. You will need to specify who gets access to the stored data and how, since security of stored data may be enforced by password if needed. I would also like to know what would you like to see as a sample of my capabilities. Does it have to be something specifically prepared for you and working towards your task, or just anything demonstrating what I can do in Excel? Kind regards, Pavel
$220 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am quite capable and willing to take up this project.
$200 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This sounds like an interesting project. I enjoy making dashboards and have done several for my current and past employers. I rely heavily on my data analysis background, VBA expertise, Conditional formatting (automatic color & formatting of a field based on its contents), and my warehouse of coding from all past projects. This bid reflects a 5-hour max time estimate. Regards, Terry
$150 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi With Six years of experience in excel VBA programming I will be able to provide you the solution Cheers!!
$50 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Columbus, United States
5.0
4
Member since Nov 19, 2011

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.