Find Jobs
Hire Freelancers

Edit Formulas and Verify Excel Spreadsheet

$100-250 AUD

In Progress
Posted over 5 years ago

$100-250 AUD

Paid on delivery
We have an almost complete spreadsheet with a number of formulas (Vlookups, Ratio Multipliers, Matches) and variables that need editing and verification. The spreadsheet works with 10 input variables, with a resulting 10 output variables. Each variable impacts on the output differently, and there are matrices in separate sheets that determine each factor, along with multiplier ratios based on these matrices. You will have 10 test cases (input and target output) to work with and the formulas/matrices will need to be edited so that each test case is equal to the target output. You may be required to edit formulas, multipliers, structure of calculations and matrices. A high level of experience in Excel and Data Analysis is favored. Please check attachment for example. Some explanation: Each input test case (Located in rows 15-24) is pasted in column B separately to a resulting output figure (Column P). The output is then pasted in each test case outputs in rows 28-37. Rows 54-63 will then measure the difference between rows 28-37 and 41-50 (standardised results). This is where the target results are nearest to 0 with the exception of 4 for CL. Our aim is to adjust the ratios and format of the formulas/workings to have very minimal difference in each output case when compared to the standardised results. We will send the remaining 2 test cases once the spreadsheet has been updated so that we can test its accuracy, since there are only 8 test cases at the moment.
Project ID: 18033077

About the project

34 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
Hi, I hope you're doing great today! I'm very excited to offer my service. I've read your project description with great interest and my skills appear to match your requirements well. I've also viewed the attachment and it looks very do-able within a day. As I've just started in Freelancer, I'm currently accepting all jobs but yes, we can certainly have a chat to agree on the expectations you have and how you would like the service delivered. I'm very excited to work with you and look forward to hearing from you. Thanks, RJ
$120 AUD in 1 day
5.0 (1 review)
0.0
0.0
34 freelancers are bidding on average $152 AUD for this job
User Avatar
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Processing, Excel, Mathematics, Statistical Analysis, Statistics. Please ping me for more discussion.
$210 AUD in 4 days
4.9 (418 reviews)
8.2
8.2
User Avatar
Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$194 AUD in 3 days
4.9 (156 reviews)
7.6
7.6
User Avatar
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 250+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$150 AUD in 1 day
4.9 (279 reviews)
7.1
7.1
User Avatar
I have Masters degree in Economics and Statistics with 7years of professional experience working as a Quantitative Analyst (in the field of Statistics). A professional statistical analyst seeking opportunity to provide highest quality services in the following areas of Statistics, Econometric, SPSS, STATISTICA, SAS, Eviews, Minitab, Mathematica and MS Excel. Looking for outstanding opportunities to apply my academic credentials coupled with my previous experiences. So get your statistical job done here ! I can do: 1. Statistical programming like C programming 2. Computing for Data Analysis 3. Time Series & Econometric 4. Economic Modeling 5. R language and Python 6. Academic data analysis and report writing.
$100 AUD in 1 day
4.8 (71 reviews)
6.2
6.2
User Avatar
Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.
$100 AUD in 2 days
4.9 (79 reviews)
6.1
6.1
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$150 AUD in 3 days
4.7 (82 reviews)
6.0
6.0
User Avatar
I am very able to edit the formula and verify the excel sheet flawlessly as per your requirement. I am ready to start. regards
$194 AUD in 3 days
4.6 (53 reviews)
5.8
5.8
User Avatar
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$100 AUD in 10 days
5.0 (20 reviews)
4.8
4.8
User Avatar
Hi Good Day! A serious freelancer here. I can help you to complete your excel works in 2 days. I am a vba macro developer for over 8 years now and has  strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
$150 AUD in 2 days
4.9 (60 reviews)
5.0
5.0
User Avatar
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$194 AUD in 5 days
4.9 (31 reviews)
5.0
5.0
User Avatar
HELLO! As an: - Bachelor of Applied Mathematics - Engineer in Statistics and Applied Economics - Microsoft Office Technician (Microsoft Graduate: MOS Diploma), - I have skills in programming language R, Python, Minitab, SPSS I am able, available and ready to do this kind of work in the best conditions, ------------------------------------------------------------
$100 AUD in 5 days
4.9 (19 reviews)
4.1
4.1
User Avatar
Dear Sirsenor, I am interested and available to work on your project. with typically detail oriented person, I am able to work on your project with high accuracy & best quality work. I have read through your project description, take a look attachment file and available to do it immediately. below is my proposal: ### Proposal ### 1. Re-arrange spread sheet into a. "Summary" sheet (consist of input, output, comparison, Delta with maintain conditional formating) b. "Calc" sheet (to calculate output result based on input data with maintain your formula term) c. "dBase" sheet (consist of data matrix 1/2/3) 2. Create excel VBA (embeded into summary sheet or create user interface form) to proceed output calculation based on input data and place input/output data into correct summary cell Kindly please advice how you categorized input/output data to be place into JS/JT/JST/DD & etc test? ################ Hopefully you will award the project to me. Looking forward to hearing from you soon. Thanks & Best Regards, GS Anggara You may check my latest portfolio and client review on below link: https://www.freelancer.com/u/gsanggara
$100 AUD in 3 days
4.9 (27 reviews)
4.2
4.2
User Avatar
Hello, I am Pooja Rohra, Computer Instructor and Manager in reputed firm. I have plenty of experience doing Ms office work.
$222 AUD in 10 days
5.0 (5 reviews)
3.6
3.6
User Avatar
Hello! It is more than likely that nobody reads what I am writing. The positioning algorithm of this platform does this ... Still, I'm going to make some reflections before commenting on your work: 1. I do not have many comments: Normal, I just started as a freelancer and I appear from the bottom half of the list ... I am invisible to most employers ... 2. If you do not have comments, maybe you do not know: False! It's just that I've just started ... I'm not saying it's better than the others, but not worse either. 3. I do not know if you can do the work: False! If I am offering, I can do it. 4. Those who have more comments are sure they are better: False! They just take more time on the platform ... Some will be better and others will be worse ... Having said that, I will comment on your case: I can do what you need. I'm used to doing work in excel and with very complicated formulas. Also, if necessary, I can create macros or VBA code to finish polishing the details until the optimal result is obtained. As I said, I do not say it's better than the rest of the freelance, I simply say that if I'm offering it, it's because I can do the job over time, with the quality and the established price. I only want an opportunity. I remain at your disposal for whatever you want. Best regards.
$100 AUD in 5 days
5.0 (6 reviews)
3.0
3.0
User Avatar
I'm expert in MS Excel formulas and I can do what you need. I have used all types of advanced formulas in Excel and I also have good background on Data analysis. I understand the analysis of the formulas has to be made carefully and I can do that. Do not hesitate to contact me so we can further discuss the details.
$166 AUD in 5 days
4.3 (4 reviews)
3.1
3.1
User Avatar
Excellent in excel work Excel functions like (vlookup , left , trim , upper...... so on)
$111 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i will work for you . am free for 20 hours . i am excel expert . its my first time to bid a project but i will do for you in 8 dollar
$194 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Management student with majors in Analytics. 3 years of hands-on experience in Data Analysis using excel
$150 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Rigorous, meticulous and fast worker. Relevant Skills and Experience In-depth skills in accounting and spreadsheets and database analysis
$194 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We have an almost complete spreadsheet with a number of formulas (Vlookups, Ratio Multipliers, Matches) and variables that need editing and verification. The spreadsheet works with 10 input variables, with a resulting 10 output variables. Each variable impacts on the output differently, and there are matrices in separate sheets that determine each factor, along with multiplier ratios based on these matrices. You will have 10 test cases (input and target output) to work with and the formulas/matrices will need to be edited so that each test case is equal to the target output. You may be required to edit formulas, multipliers, structure of calculations and matrices. A high level of experience in Excel and Data Analysis is favored. Please check attachment for example. Some explanation: Each input test case (Located in rows 15-24) is pasted in column B separately to a resulting output figure (Column P). The output is then pasted in each test case outputs in rows 28-37. Rows 54-63 will then measure the difference between rows 28-37 and 41-50 (standardised results). This is where the target results are nearest to 0 with the exception of 4 for CL. Our aim is to adjust the ratios and format of the formulas/workings to have very minimal difference in each output case when compared to the standardised results. We will send the remaining 2 test cases once the spreadsheet has been updated so that we can test its accuracy, since there are only 8 test cases at the moment.
$194 AUD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Fawkner, Australia
0.0
0
Payment method verified
Member since May 19, 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.