Find Jobs
Hire Freelancers

Edit Formulas and Verify Excel Spreadsheet

$100-250 AUD

処理中
投稿日: 5年以上前

$100-250 AUD

完了時にお支払い
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.
プロジェクト ID: 18033077

プロジェクトについて

34個の提案
リモートプロジェクト
アクティブ 6年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
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 1日以内
5.0 (1 レビュー)
0.0
0.0
この仕事に34人のフリーランサーが、平均$152 AUDで入札しています
ユーザーアバター
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 4日以内
4.9 (418 レビュー)
8.2
8.2
ユーザーアバター
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 3日以内
4.9 (156 レビュー)
7.6
7.6
ユーザーアバター
"""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 1日以内
4.9 (279 レビュー)
7.1
7.1
ユーザーアバター
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 1日以内
4.8 (71 レビュー)
6.2
6.2
ユーザーアバター
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 2日以内
4.9 (79 レビュー)
6.1
6.1
ユーザーアバター
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 3日以内
4.7 (82 レビュー)
6.0
6.0
ユーザーアバター
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 3日以内
4.6 (53 レビュー)
5.8
5.8
ユーザーアバター
"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 10日以内
5.0 (20 レビュー)
4.8
4.8
ユーザーアバター
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 2日以内
4.9 (60 レビュー)
5.0
5.0
ユーザーアバター
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 5日以内
4.9 (31 レビュー)
5.0
5.0
ユーザーアバター
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 5日以内
4.9 (19 レビュー)
4.1
4.1
ユーザーアバター
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 3日以内
4.9 (27 レビュー)
4.2
4.2
ユーザーアバター
Hello, I am Pooja Rohra, Computer Instructor and Manager in reputed firm. I have plenty of experience doing Ms office work.
$222 AUD 10日以内
5.0 (5 レビュー)
3.6
3.6
ユーザーアバター
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 5日以内
5.0 (6 レビュー)
3.0
3.0
ユーザーアバター
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 5日以内
4.3 (4 レビュー)
3.1
3.1
ユーザーアバター
Excellent in excel work Excel functions like (vlookup , left , trim , upper...... so on)
$111 AUD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Management student with majors in Analytics. 3 years of hands-on experience in Data Analysis using excel
$150 AUD 7日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Rigorous, meticulous and fast worker. Relevant Skills and Experience In-depth skills in accounting and spreadsheets and database analysis
$194 AUD 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 10日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

AUSTRALIAのフラグ
Fawkner, Australia
0.0
0
お支払い方法確認済み
メンバー登録日:5月 19, 2018

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。