Suljettu

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

About the Employer:
( 0 reviews ) Mexico

Projektin tunnus: #13143680

16 freelanceria on tarjonnut keskimäärin 29273 $ tähän työhön

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

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)
7.5
schoudhary1553

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)
7.0
maverick44000

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)
6.9
P0L

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)
6.7
cugamelover

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)
7.0
paris2785

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)
6.4
esalem

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)
6.5
srinichal

looking forward to discuss further about the project

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

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)
6.1
mehedi276

"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)
6.2
dgled

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)
5.7
37500 $ MXN 10 päivässä
(63 arvostelua)
5.6
axiomswb

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)
5.4
smb310570

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)
3.4
king18yat

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)
0.0