Find Jobs
Hire Freelancers

Build Excel dashboard with macros that generates a break-even gragh of data

$250-750 USD

Completed
Posted over 7 years ago

$250-750 USD

Paid on delivery
This is an advanced Excel dashboard with macros that will be used to dynamically create break-even graphs used for analysis and client business proposals. I will want the gragh to show various linear equations to graphically compare them to other linear equations to help determine the best linear equation, which represents the most financially palatable solution and approach for my clients and my business to work together. I am a software reseller, and I will be using this Excel program to quickly evaluate potential software partners (Independent Software Vendors) to determine which financial framework, which consists of fees and commissions would be mutally attactive to both parties. It would be beneficial if the freelancer has knowlege of break-even graphs and of linear equations as well as well with the Excel programing knowlege to create a fairly complex financial analysis and proposal tool. I attached examples of the graphs that I am doing manually, but this will need to be presented in a proposal formate as a PDF or Word document.
Project ID: 11828450

About the project

27 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
Awarded to:
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. It might help you to know that I own a small business registered in the state of Illinois. My company is called Arrow Science and Technology. I could bill you as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$350 USD in 7 days
4.8 (177 reviews)
7.1
7.1
27 freelancers are bidding on average $421 USD for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$250 USD in 3 days
4.9 (466 reviews)
8.3
8.3
User Avatar
Hello, I am audit manager. I have bachelor degree in finances and have worked with business projects so I know what are you talking about. I have been programmer for like 5-6 years and know using this knowledge in creating macros. However, I can help you with that project. I made simple average bid but price and time may vary depended on details. I can offer less price depended on exactly how much time it will take to finish your project. So feel free to contact with me and lets discuss details in private chat
$555 USD in 10 days
5.0 (149 reviews)
8.2
8.2
User Avatar
Hi, I am good at Excel and vba. Plz provide me the excel file details further to get the scope of work. Looking forward to discuss in the chat. I have seen the snapshots, which shows the graphs with the equations.
$250 USD in 3 days
5.0 (1107 reviews)
8.3
8.3
User Avatar
Excel Expert.. ZERO ERROR GUARANTEED!! Please read my reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.
$250 USD in 3 days
5.0 (313 reviews)
7.8
7.8
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$500 USD in 5 days
5.0 (481 reviews)
8.0
8.0
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy
$400 USD in 10 days
4.9 (482 reviews)
7.4
7.4
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
$500 USD in 4 days
5.0 (314 reviews)
7.4
7.4
User Avatar
Hi there. I can work on your job but earliest I can start is 1st of November. If this is ok for you we can discuss in detail. Thank you.
$1,176 USD in 15 days
5.0 (141 reviews)
7.2
7.2
User Avatar
Hi, I have read the project and understand your requirement. I did many work like this with my financial and excel competency. I am a highly trained on Excel and VBA Macros. I did many project regarding automated yahoo finance/forex stock update dashboard . I did many project related to KPI template using Excel and so on. I only take work for 5***** review. I will continue the work until you fully satisfied. I take your work for my own responsibility and this is not my automated proposal. Kind regards, Fatima
$250 USD in 10 days
4.9 (183 reviews)
6.9
6.9
User Avatar
Greetings! I am an Engineer with 17+ years of Industry experience. I have completed a Black Belt project (Six Sigma) and several Green belt Projects in my career. As part of these projects I have had to perform lot of similar analysis. I understand your model requirements and can do the needful. 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 as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. 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
$350 USD in 5 days
5.0 (225 reviews)
7.0
7.0
User Avatar
Hello there, I am an Expert in creating Excel dashboards and have done some very complex financial dashboards for my clients. For more than 500 projects here on freelancer, I have been consistently rated excellent for the quality work I deliver. I reviewed the requirements brief you shared and also the two sample graphs that were attached with the description and can certainly create a proposal creation tool for your purpose that will also allow you to evaluate different fee and commission structures with minimum effort. I would be using a combination of macros and formulas to present the results in the most intuitive way possible. To be able to suggest a suitable structure for the workbook, I will need some sample data that goes as an input to your model, perhaps some existing documents that you created manually and a list of variables that are normally used in your proposals. Based on these, I would come up with more detailed queries to elicit the requirement and then present the overall scheme for the workbook. Once approved, will develop the code and other features in the workbook. Does this sound like a good plan? Do let me know. Thanks and Regards, Rishi (Automyze Consulting)
$600 USD in 15 days
4.8 (97 reviews)
6.5
6.5
User Avatar
Hello, My name is Chris and, as you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. Break-even graphs, linear equations and data analysis are some of the advanced topics I'm teaching using both Excel built-in tools and formulas, and VBA coding. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$500 USD in 6 days
4.9 (70 reviews)
6.6
6.6
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.
$500 USD in 15 days
4.9 (115 reviews)
6.3
6.3
User Avatar
Most of the reviews on my profile are for excel. I come with an experience of over 15 years in excel and contributor to various sites, where users post queries related to excel. I am efficient in creating macros and vba code. Point is - I've the speed and will be able to turn in your project with a very little TAT. Also, as I've a post graduate degree in Business Administration, I've studied the concepts of break -even analysis and I would be able to apply them on your sheet as per your requirements. Let's discuss the details over the chat and we can take it further from there. Thanks. Varun Bansal
$388 USD in 7 days
4.7 (64 reviews)
5.4
5.4
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
$250 USD in 5 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. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. feel free to contact me over the web site chat for further details brgds. Itay p.s. the graphical presentation of your fist graph is mistaken... (the 2 lines do not meet at 140K and also C=140K - X=500K (not 750K) ...
$444 USD in 5 days
5.0 (12 reviews)
4.2
4.2
User Avatar
Hello, my name is Martín Ghia from Argentine. I'm industrial engineer and I have been working using excel and program advanced macros for modeling process during the last 12 years. Currently I'm working in a large food processor company and start doing projects as freelancer to complement my primary jobs increasing my income. As I'm starting on freelancer.com community I bid a low price for my job. If you choose me I guarantee the best result to your project. I hope hearing from you soon. Best regards. Martin
$250 USD in 7 days
5.0 (1 review)
1.9
1.9
User Avatar
I am expert in excel I can do this project
$277 USD in 10 days
5.0 (2 reviews)
1.2
1.2
User Avatar
Hi could you please send me your sample? I have experience working in a large international bank and have used macros in various capacities. Presentation of of output should also be good.
$500 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, My pleasure is to do your job. But want to your job as a challenge and want to meet my self with you. Just give a chance to prove my self toward you. Let me do your work .I will make you happy with an amazing feedback. If you want i will do a sample work for you. If you like this sample then hand over me this job. Let’s meet in chat box. I am waiting for your reply. Best Regards SULTANA2020
$277 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Schaumburg, United States
0.0
0
Payment method verified
Member since Aug 4, 2016

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.