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 제안서
원격근무 프로젝트
활동 중 5년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.