Find Jobs
Hire Freelancers

Build complex Excel spreadsheet (add formulas to make existing design work)

$250-750 USD

Завершено
Опублікований about 8 years ago

$250-750 USD

Оплачується при отриманні
included I have a spreadsheet that I use for work. I import a csv file into this sheet, and that data is used to fill out all of the other fields in the report so that I can gather intelligence from that raw data. I have attached a zip file that contains: 1. The mockup of what I want the final product to look like. I have included instructions on each tab detailing how it should function. 2. A sample of the export file that will be imported into this mockup spreadsheet. 3. I have also included my existing spreadsheet, which has all of the current formulas in it and is functional. It is much less robust, with less fields and tabs, which is why I am trying to expand it. PLEASE NOTE: I am not 100% sure that the existing formulas are all correct -- they may not include all of the relevant data, or they may not be feeding to the correct cells, etc, and so I would really prefer that someone start from scratch and not try to use the existing formulas. It is included mainly to understand how the sheet is supposed to work. THIS IS A COMPLICATED SPREADSHEET AND REQUIRES SOMEONE WITH DEEP EXCEL SKILLS. Please do not waste my time or yours if you are not very good at Excel. Don't worry about my budget, I want an honest estimate of what it will take to get this done right. I am not interested in the low bid, but the most qualified.
ID проекту: 9631732

Про проект

27 пропозицій(-ї)
Дистанційний проект
Активність 8 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
Hello, I was excited when I saw this project posted. This is exactly the type of work I did in my previous position and I believe I will be able to exceed your expectations. I worked for a commercial mortgage company and we used many of the same metrics when analyzing our portfolio. Finishing and validating all of your formulas will be a simple task. Our company was the servicer for all of the loans we closed and I automated many of the back end processes. I have listed a few of the projects below. Inspection Process - Users would enter the loan numbers of properties being inspected. Google maps would open and place the properties on the directions map so the user was able to plan the easiest route. A custom email was automatically created in outlook populated with borrower information notifying the borrower of the inspection. The inspection form, deferred maintenance letter and expense reimbursement form was automatically created. Fedex automation - User would enter the loan number and [login to view URL] would automatically open, login into the company account and automatically enter postal information of borrower. User only requirement was to confirm the information is correct and then press print. I also automated the financial analysis, risk rating and check processing. I believe I will be able to add tremendous value to your current and possibly future projects. Please let me know if you have any questions or concerns. Regards, Kevin
$650 USD за 10 дні(-в)
5,0 (1 відгук)
3,6
3,6
27 freelancers are bidding on average $610 USD for this job
Аватарка користувача
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$550 USD за 4 дні(-в)
5,0 (848 відгуки(-ів))
9,2
9,2
Аватарка користувача
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.
$550 USD за 10 дні(-в)
5,0 (483 відгуки(-ів))
8,0
8,0
Аватарка користувача
Hi, I am an Excel macro expert and would be happy to take on your project. May have to study a bit more and understand the requirements in detail before I can give my final confirmation. To start with, kindly provide the VBA password. Let me know and we can discuss. Regards, Arul
$600 USD за 10 дні(-в)
5,0 (173 відгуки(-ів))
7,4
7,4
Аватарка користувача
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 за 5 дні(-в)
5,0 (319 відгуки(-ів))
7,4
7,4
Аватарка користувача
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: 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/
$700 USD за 7 дні(-в)
4,8 (178 відгуки(-ів))
7,2
7,2
Аватарка користувача
I am an ACCA (UK) professional , APA and Mcom finance. After carefully reading your project description, I think that I am the perfect candidate! With over 8 years of experience in advanced use of MS Excel, I can guarantee getting the job right the first time. Feel free to view my 100% positive reviews before you hire me and rest assured that you will receive top-quality work at an affordable cost. Kind regards, Javed
$555 USD за 10 дні(-в)
4,9 (105 відгуки(-ів))
6,7
6,7
Аватарка користувача
Hello there, I reviewed the spreadsheets you shared and have a good understanding of what you are looking for. I can create the desired spreadsheet that will take the csv data as input and generate the output dashboards. I am an expert in Excel and have done more than 490 spreadsheet templates here on freelancer with excellent ratings. As required, I can assure you that I know Complex excel functions, my Analytical skills are excellent, I have done several reports (some example in my profile and can share more) and I am an excellent Marco & Excel VBA programmer. You may see comments of the clients with whom I have worked and they echo the same sentiment. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to hear from you. Thanks and Regards, Rishi
$666 USD за 15 дні(-в)
4,8 (97 відгуки(-ів))
6,5
6,5
Аватарка користувача
Hi I am going through the requirements. I have 10+ years of experience in Excel. Please check my reviews and ratings. Macro file is password protected to view the code what it does . Please ping back so that i can discuss with you and i can propose solution. Please be assured about the solution accuracy. I am very honest professional and i give more importance to the job than $. Thank You Regards Rishi
$444 USD за 7 дні(-в)
4,9 (156 відгуки(-ів))
6,0
6,0
Аватарка користувача
Have a wonderful day! Excel automation is my masterpiece in my accounting field. I can handle very well complex formula and functions and can understand the existing formulas. Feel free to message me to start the job. Thank you so much.
$250 USD за 3 дні(-в)
4,9 (73 відгуки(-ів))
5,7
5,7
Аватарка користувача
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in few data analytics projects involving SAS & R. Also I have worked on many projects involving Excel (Pivot Table, Macros) and VBA. I believe I have enough expertise to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh Kanna
$444 USD за 10 дні(-в)
5,0 (38 відгуки(-ів))
5,7
5,7
Аватарка користувача
I am an extremely reliable new freelancer looking to build my reputation back up after a three-year hiatus. I have a deep and extensive knowledge of Excel, and would love to tackle this project, as I enjoy working on difficult projects, especially when they are in Excel!! If you have any questions about my ability to take this on, please do no hesitate to ask. I look forward to discussing this with you further!
$388 USD за 14 дні(-в)
5,0 (8 відгуки(-ів))
4,3
4,3
Аватарка користувача
Hello, my name is Vasile, I work a lot with advanced formulas and VBA in the reporting environment for my regular job @Oracle as global reporting analyst so anything you throw at me, if described correctly should be no problem to fix. I looked through your files and it looks like an interesting project and I'm 100% sure I can make it work based on your description and have no problem to start from scratch, i see some formulas you have that can be improved / optimized. I have created a couple of similar projects in the past, I could use some of the templates to speed up the process for what you need. Please let me know if you think you need me and we'll take it from there. Thanks!
$666 USD за 5 дні(-в)
5,0 (11 відгуки(-ів))
3,9
3,9
Аватарка користувача
I am new to Freelancer but I have good offline experience in Excel and VBA. I can do the job. I just need your complete requirements and I am good to go. Thanks!
$611 USD за 7 дні(-в)
5,0 (2 відгуки(-ів))
1,7
1,7
Аватарка користувача
Hi! In my porfolio I have the project, which looks like yours or can show your my qualification. I have made a lot of business plans and models for my clients. Everything will be done urgent in 2-3 days. Please see my portfolio. I'm well experienced in excel/spreadsheets/business plans, but I'm new user on this site, that is why my price is so low.
$250 USD за 3 дні(-в)
4,9 (8 відгуки(-ів))
1,8
1,8
Аватарка користувача
Hi, Let handle your works to professionals. I am an engineer and expert in the field. I can guarantee 100% accuracy and quick completion of the task. You can view my reviews to assure quality of my woks. Hope to `her you from soon. Thanks.....
$305 USD за 2 дні(-в)
4,7 (3 відгуки(-ів))
1,5
1,5
Аватарка користувача
Hi. I'm Max Han specialized in followings: - Excel programming(VBA) - Automation manual job.(Data scraping or input data on the web sites or specific programs) I'm working for a software company as a excel developer for last 10 years. But I don't go to my office daily, so I'm looking for second job. I registered in this site few days ago, so I have no reviews. Please understand it. Mainly I developed stock market data related excel programs. Please see my portfolio. I want to make long-relationship with you. Thank you for reading my proposal. *** If you are not busy, see my portfolio please.
$2 777 USD за 20 дні(-в)
0,0 (1 відгук)
0,0
0,0

Про клієнта

Прапор UNITED STATES
Austin, United States
5,0
1
Спосіб оплати верифіковано
На сайті з лют. 12, 2016

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.