Automate setup of an excel model

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

Taidot: tietojenkäsittely, Excel, Visual Basic

Näytä lisää: equity research valuation model excel, commercial real estate valuation model excel sample, vba excel addin automate install, excel vba automate web query, real estate development model excel, options model excel, excel outlook automate, financial model excel, banking model excel, understand evaluation model excel sheets, active directory excel file automate add user, export excel data automate, nepra tariff model excel, bank model excel, excel vba automate excel graphs

Tietoa työnantajasta:
( 0 arvostelua ) Mexico

Projektin tunnus: #13143680

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$37500 MXN 30 päivässä
(258 arvostelua)

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 f Lisää

$22500 MXN 3 päivässä
(519 arvostelua)

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 ex Lisää

$37500 MXN 30 päivässä
(192 arvostelua)

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

$35000 MXN 10 päivässä
(85 arvostelua)

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.

$30000 MXN 30 päivässä
(185 arvostelua)

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, Lisää

$22500 MXN 5 päivässä
(180 arvostelua)

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 y Lisää

$25000 MXN 30 päivässä
(116 arvostelua)

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 Lisää

$35526 MXN 30 päivässä
(20 arvostelua)

looking forward to discuss further about the project

$27777 MXN 5 päivässä
(57 arvostelua)

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. T Lisää

$25000 MXN 10 päivässä
(198 arvostelua)

"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 sev Lisää

$34793 MXN 30 päivässä
(132 arvostelua)

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, Lisää

$30000 MXN 5 päivässä
(32 arvostelua)
$37500 MXN 10 päivässä
(63 arvostelua)

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients.

$22500 MXN 7 päivässä
(31 arvostelua)

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 ....

$22500 MXN 30 päivässä
(14 arvostelua)

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 milest Lisää

$22777 MXN 33 päivässä
(0 arvostelua)