Closed

Dynamic Model EXCEL , VBA

Require to create the model which will include below logic:

Project need be completed by 11am GMT on 11th March than if you can't complete please do not big.

Requirments:

- allocate next available time slot based on assumptions for 15 min intervals.

- split the volumes between 3 different categories

- be quick enough < when new data is dumped it would need be recalculated on i5 class PC with max 5min.

Logic (please find attached file for current logic which don't include all requirments.)

3 tabs

INBOUND - data split by actual date

CORE - data split by day of the week instead day

MODEL - need summarize 2 tabs based on if in collumn D there is no text or if there is some text ( if there is text than it's need check in tab core - column U for relevant information)

Overall Logic for tab INBOUND:

Based on delivery time (column J) and running time (column I) find next avaiable slot that product can be unloaded. This is based on assumptions of the slots available in time of day. This variable is available in tab MODEL - column H ( ie if there are 10 records which have delivery time at 10am and running time is 1h but on the MODEL tab there are only 5 available slots than 5 trailers can be unloaded but other 5 need be moved to 11am, if there are 5 slots also available at 11am than anything arriving after 11am would need be moved to next available slot)

Updated times for each record need be updated in column K and L. There can't be more records planned to be unloaded than variable in table MODEL.

When this is completed column N need be split based on percentage in column S T and U (this need be done in 15 min intervals ie if there is slot between 10:15 and 11:15 and there are 1200 items than it would be 300 items in each 15 min and assuming that column S , T , U showing 33.3% each than this would be showing 100 items per 15 min per each type)

Overall Logic for tab CORE:

this require this same logic as tab INBOUND however it's require that information can be summarize by day of the week instead actual date.

Failing to provide working solution till 11AM GMT time on 11th March equal cancellation of the project and there will be no payment made.

I will pick up person who have enough feedback and experience at 11AM GMT time 9th March which would mean that you have 2 days to complete task. If you have less than 80% completed on time please do not bid.

If there is something not clear please let me know and i will get back to you ASAP.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel vba create table dynamic range, excel vba select range with variable number of rows, excel copy dynamic range to another sheet, excel vba dynamic range selection, excel vba dynamic named range, excel macro dynamic range selection, excel vba dynamic array, excel vba dynamic range based on cell value, excel vba userform create unique, create herd model excel, excel vba macro create word, excel vba dynamic create workbook, solver inputs dynamic excel vba, excel vba dynamic form, excel vba dynamic classes, excel vba create dynamic form, vba dynamic forms excel, dynamic form excel vba, excel vba dynamic workbook name, excel vba xml create xml document

About the Employer:
( 1 review ) Newcastle, United Kingdom

Project ID: #16449600

21 freelancers are bidding on average $167 for this job

schoudhary1553

Hi there..... Warm Greetings We came along with your request for Dynamic Model EXCEL , VBA and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have prof More

$200 USD in 3 days
(240 Reviews)
7.5
SBITServices

Hello , I have read your project description , checked the file and understood your requirement. I am an excel Expert and can develop in Visual basic.I have 6 years experience in Visual Basic. I can complete task withi More

$120 USD in 2 days
(325 Reviews)
7.2
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 USD in 3 days
(238 Reviews)
6.9
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$250 USD in 2 days
(94 Reviews)
6.2
katilinas

Greetings, I'm ready to work on "dynamic model excel with vba" project. Relevant Skills Excel, VBA Milestones 153 USD - code writing 38 USD - userfriendly interface I can achieve the results that you are asking fo More

$191 USD in 3 days
(108 Reviews)
6.3
expertatwork

Thanks for the heads up. Yes, I can develop this excel model. Please reply, we can discuss further and get it started soon. Thank you

$99 USD in 3 days
(198 Reviews)
6.1
$155 USD in 3 days
(28 Reviews)
5.3
aubrey03

I am an Excel VBA Specialist. I have all the skill sets you are looking for. Feel free to check my profile. You may contact me so we can discuss the details of this project.

$250 USD in 3 days
(22 Reviews)
4.9
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards. Please provide the password to More

$155 USD in 3 days
(19 Reviews)
4.3
nurnga1218

Hi, I like your challenge. I'll never ask milestone release if I can't finish it in the time you asked. Instead I'll cancel it so you can receive it. No wasting time. I'll start it after you reply me. I'm waiting for i More

$55 USD in 1 day
(36 Reviews)
4.4
$155 USD in 3 days
(1 Review)
3.8
vaidyag

Hi, I have extensive work experience in excel and macros and I have executed many projects. I was working in Infosys , a op tier company in India, for 10+ years and i am freelancing now. I understand that you wa More

$222 USD in 2 days
(6 Reviews)
3.0
maheen1995

Hey, I have prior experience in data entry and excel. I hope you will consider my bid. thanks..............................

$155 USD in 3 days
(2 Reviews)
2.8
Ranjan2201

I have 8+ years of experience in with Advanced excel and VBA. Believe i can complete this in less than 1.5 day as i have completed similar assignments in past Looking forward to hear from you

$155 USD in 2 days
(1 Review)
1.4
$155 USD in 3 days
(0 Reviews)
0.0
managent88

-Professional Excel, Visual Basic, Visual Basic for Apps expert ! Best Result in Time!------------------------------ Hello sir. I've really rich experience for your project, so your project is very interesting to me. More

$200 USD in 3 days
(0 Reviews)
0.0
AndyPeterSmith

This will be my first project though freelancer however I have been developing and coding with Excel and Access for over 5 years. I work with Microsoft Excel and Access on a daily basis creating applications to manipu More

$166 USD in 2 days
(0 Reviews)
0.0
DavidGerman7

Hello, I'm david, I can provide you perfect work as you looking for . we can discuss more in chat . I will be waiting for your response . I have very great experience about your project , if you want discuss more More

$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0