Find Jobs
Hire Freelancers

Create a macro in Excel to display dashboard

$30-250 USD

Closed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I use an application that exports some data in a .xls file. I would like to have a macro written that imports the file and creates a new .xls file with some better dashboard guages. I would like to keep the existing data in the file but display it along with 3 new dashboard speedometer objects. I'm thinking something like this: [login to view URL] There are a couple of new (but easy) calculations I would like to run on the existing data in the file. Basically I would like to make the existing file prettier and display the data better, and I dont have control of the application that creates it. I would like it to be as automated as possible. I've attached an example file.
Project ID: 11472090

About the project

34 proposals
Remote project
Active 8 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
34 freelancers are bidding on average $129 USD for this job
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I Have 100% completion ratio. I have gone through the video and I can do this. I had earlier done the same work related to gauge. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$90 USD in 1 day
4.9 (561 reviews)
8.5
8.5
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$200 USD in 3 days
5.0 (336 reviews)
7.5
7.5
User Avatar
EXCEL/VBA expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that i can start with the implementation.
$250 USD in 2 days
4.9 (339 reviews)
7.7
7.7
User Avatar
Greetings Hiring Manager! I viewed the YouTube Video and understand what you are expecting. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel (including a complex KPI dashboard project for Management Reporting). I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$50 USD in 3 days
5.0 (258 reviews)
7.2
7.2
User Avatar
Hi, MS Excel expert here I've read the project description and watched youtube video, and clearly understand your requirement I've completed several projects like this with 5 star rating, you can check my profile as proof Feel free to award Thanks
$99 USD in 6 days
5.0 (86 reviews)
6.7
6.7
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$120 USD in 4 days
4.9 (126 reviews)
6.4
6.4
User Avatar
Dear sir, Greetings. I could make it more functional, automated where ever possible and create a stunning dashboard. Plz let me know if you are interested. Thank you.
$155 USD in 2 days
4.8 (106 reviews)
6.1
6.1
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flaw I am very much able to work on this. ***I am ready to start Waiting for further discussion with thanks and regards
$155 USD in 3 days
4.6 (45 reviews)
5.6
5.6
User Avatar
Hello there, Yes sure we can keep the existing data in the file but display it along with 3 new dashboard speedometer objects. I have reviewed your job post and would like to propose my interest in working for this task, as I am having expertise with C#, ASP.NET MVC,.NET Framework, VB.NET, Visual Basic, VBScript. I am a senior software engineer with 13years of experience with strong technological background and analytic thinking. Yes I am a .NET Lead Developer and I have 12+ years of development experience in which as a team lead. For development we follow SDLC or agile methodology based on discussion with customers. Give us a chance and will prove to be asset for you and promise a long term healthy service. I expertise in Agile and third party integration of Webex, Livemeeting, Telerik controls, ADFS, OneLogin, SMS gateway, payment gateway and various other services. One of our major success is our first charity project for local school, which is working great since last 4 years, further we are flexible to work onshore or from offshore. Programming is my passion, we always have believed in running that extra mile with energy store, so we keep learning the customer domain and competition. Moving forward, If you grant me the opportunity to work on this job, be assured I can work with minimal or no supervision, meet deadlines, and understand directions in one go. Awaiting an affirmative response from your end! Thanks and Best Regards Janvi
$277 USD in 7 days
5.0 (3 reviews)
4.8
4.8
User Avatar
I have quite a bit of experience in making Excel reports and dashboards (about 8 years' worth in the banking world), usually pulling the data from a database such as SQL Server or Access. You don't mention where the data is coming from, and say that you have no control over the process that creates it, which is something I would need to look into. What I can say with certainty regarding dashboard design is that usually it is best to mock up a few different design ideas and exchange and test various ideas over a few days - meaning you should allow a couple of weeks for the project. There are some screenshots of Excel reports and dashboards that I have done recently for Freelancer clients on my profile for your reference. I am online at the moment if you would like to discuss it with me.
$250 USD in 10 days
5.0 (8 reviews)
4.7
4.7
User Avatar
Hi, I'm very interested to do your project. I have great knowledge on about your project. I have already read your description and I feel like I would be a great fit for the project. I can start your project right now. I have extensive data entry experience. I have huge knowledge Data entry advantage other task easily and having ability to give back to you fine result. So you can select me for a good result. # My objective is to provide 100% fast and accurate service to my client. # Organize data before inputting. # Attention to detail and accuracy when inputting information. # knowledgeable in microsoft office. I;m hard worker and my goal is client satisfaction to provide the best quality services. Thank You for your time and consideration. sincerely, Nimesha
$35 USD in 2 days
5.0 (6 reviews)
4.2
4.2
User Avatar
Dear sir, I am an expert in excel and also I am an economist (BA+MBA) by profession. The speedometer in that youtube is web based this is not so recomended to be used as can be an open door to your system for hacks and torjens. there are other tricks that can be used using excel build in tools/graphs to create speedometers. if of interest pls contact me over the website chat and we can discuss further. brgds, itay
$83 USD in 3 days
5.0 (12 reviews)
4.3
4.3
User Avatar
Hi, Native English speaker. Excel/VBA expert. I can get this done for you quickly and elegantly. I have a lot of experience shaping data and creating dashboards. Do feel free to send me a chat request and I'd love to discuss the project further, particularly regarding your data source and the necessary manipulations. Best, Jay
$222 USD in 3 days
5.0 (4 reviews)
3.1
3.1
User Avatar
Hi , can you resend attachment, as i dont see it here I am an Engineer with 8 years or experience. And from last 8 years I am also working on Data Entry/ Excel. I feel I can call myself as an expert in Copy Typing/Data Entry/ Excel. I have created many Macros for my organization. Being a corporate employee I believe in fulfilling client's expectation. Please give me a chance to prove my self. Please don't hesitate in giving me offline message in chat if I am not available for the moment,as I am following my mail id constantly, I can login here in seconds.
$66 USD in 5 days
4.9 (3 reviews)
2.0
2.0
User Avatar
Hello Sir, About Me ------------------------- I am an experienced Developer from Sri Lanka with bachelor’s degree in computer science. currently working as, a SAP developer. In my free times I am doing part time administrative related tasks. I have more than 7 years’ computer experiences. About the Task – ------------------------ I have done several this kind of data manipulation tasks. Below are few of them - Create excel template for a stock management consultancy group which manipulate data to use daily - Retrieve data from different sources (different Excel workbooks, worksheets, ERP systems) - Send data to another system (different Excel workbooks, worksheets, ERP systems) - Macro creations for data clearings - Summary Generations - Generate Financial reports I'll try my best to complete this ASAP with required quality. I am looking forward to work with you. Thanks & Regard, Hasini
$66 USD in 3 days
5.0 (2 reviews)
1.5
1.5
User Avatar
I am very good at Excel macros using VBA. Some of the macros that I built include - Fetching data from Oracle tables into spreadsheet Consolidating multiple files into a single spreadsheet Read from multiple text documents in a folder and fill in a Spreadsheet These are some of the complex tasks that I was able to achieve. So, I believe I will be able to help you in your project.
$160 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have lot of experience in using Excel. I have been building dashboards and I have been using Excel to build presentations. I am also particularly good with built-in functions and I can build Pivot tables. I have a passion for accuracy and I believe I can do a good job for you at a good price.
$150 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I work as BI Developer. I do a lot of automation in Excel and love to work with macros. I am sure I can help you with what you need. Just let me know. Wish you a great day! Sergiu.
$111 USD in 3 days
5.0 (1 review)
0.0
0.0
User Avatar
Possess excellent 8+ years of experience in software technologies have done vba to stock analysis in past .please accept bid .looking forward to work
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Tacoma, United States
5.0
2
Member since Sep 15, 2015

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.