Find Jobs
Hire Freelancers

Automate setup of an excel model

$22500-45000 MXN

Closed
Posted about 7 years ago

$22500-45000 MXN

Paid on delivery
I need to automate setup of an excel model I have a working excel model that consists of 3 identically structured submodels (3 workbooks called WS, SMS and CC), 4 input workbooks and 1 summary workbook. Input for submodels consists of structured data tables with 200k-500k records of <15 fields. I need: 1. To automate data set-up For the submodels: 1.1 data validation that identifies null values from input 1.2 applying a (known and manually executed) algorithm to extend input data. This appends records to input data tables. 1.3 updating pivot tables in workbook 2. To automate input into summary workbook. Mainly linking-copy paste worksheets from submodels/input workbooks
Project ID: 13143680

About the project

16 proposals
Remote project
Active 7 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
16 freelancers are bidding on average $29,273 MXN for this job
User Avatar
Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat. and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
$22,500 MXN in 3 days
5.0 (519 reviews)
7.5
7.5
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 (18+ 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
$37,500 MXN in 30 days
4.9 (192 reviews)
7.0
7.0
User Avatar
Hello, I am among the highest rated Excel modeling developers. Please share the sheet and discuss details. I shall be able to surpass your expectations. Thank you, Usman
$35,000 MXN in 10 days
5.0 (85 reviews)
6.9
6.9
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.
$30,000 MXN in 30 days
4.9 (185 reviews)
6.7
6.7
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 complete your project. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ 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/
$22,500 MXN in 5 days
4.8 (180 reviews)
7.0
7.0
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$25,000 MXN in 30 days
4.9 (116 reviews)
6.4
6.4
User Avatar
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Best regards, Eyad
$35,526 MXN in 30 days
4.9 (20 reviews)
6.5
6.5
User Avatar
looking forward to discuss further about the project
$27,777 MXN in 5 days
4.9 (57 reviews)
6.1
6.1
User Avatar
Dear client I have done a number of projects in excel using vba macro. I understand the requirement in the project. I ensure you will be happy after hiring me. Please provide me the opportunity to do this project. Thanks Roy
$25,000 MXN in 10 days
4.9 (198 reviews)
6.1
6.1
User Avatar
"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Kinds Regards, Mehedi Hasan. 18th February (10)
$34,793 MXN in 30 days
4.8 (132 reviews)
6.2
6.2
User Avatar
I create all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards I am a specialist in financial reports, budget, costing reports, inventories, bill of materials construction models together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports, dynamic dashboard, and graphs. Throughout my career, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services. And have bullied all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards. Areas of expertise: • Implementation of information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP B1, ERP, Venture Capital system, CRM, etc.). • Business valuation and ratios (NPV, IRR, DCF, ROA, ROE, MCDA, CPI, SPI, EVM, KPI, Monte Carlo technique WACC, S-Curve methodology). • Developing of consolidated financial statements, financial plans (fitted to due diligence), feasibility studies, and measurement reporting tools for global companies. • Extensive experience in accounting, consolidating, forecasting, budgeting, and costing. • Budget Development & Management.
$30,000 MXN in 5 days
4.9 (32 reviews)
5.7
5.7
User Avatar
I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients.
$22,500 MXN in 7 days
5.0 (31 reviews)
5.4
5.4
User Avatar
Hello Dear, Perhaps you forgot to attach the file. OR Please give me you data file so that I can set the "Automated setup" for you. Reply for more discussion. Thanks ....
$22,500 MXN in 30 days
5.0 (14 reviews)
3.4
3.4
User Avatar
In the bid amount , I can provide the website version , android application , ios application . I am available on all days and can start at the earliest. You can release the payment in the end or as per your milestones. I shall give one year support to you .
$22,777 MXN in 33 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MEXICO
Mexico
0.0
0
Member since Feb 18, 2017

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.