Lukket

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.

Ferdigheter: Dataregistrering, Databehandling, Excel, Visual Basic, Visual Basic for apper

Se mer: 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

Om arbeidsgiveren:
( 1 anmeldelse ) Newcastle, United Kingdom

Prosjekt-ID: #16449600

21 frilansere byr i snitt $167 for denne jobben

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 Mer

$200 USD på 3 dager
(240 Omtaler)
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 Mer

$120 USD på 2 dager
(325 Omtaler)
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 på 3 dager
(238 Omtaler)
6.9
zebracaro

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

$250 USD på 2 dager
(94 Omtaler)
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 Mer

$191 USD på 3 dager
(108 Omtaler)
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 på 3 dager
(198 Omtaler)
6.1
$155 USD på 3 dager
(28 Omtaler)
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 på 3 dager
(22 Omtaler)
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 Mer

$155 USD på 3 dager
(19 Omtaler)
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 Mer

$55 USD på 1 dag
(36 Omtaler)
4.4
$155 USD på 3 dager
(1 anmeldelse)
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 Mer

$222 USD på 2 dager
(6 Omtaler)
3.0
maheen1995

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

$155 USD på 3 dager
(2 Omtaler)
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 på 2 dager
(1 anmeldelse)
1.4
$155 USD på 3 dager
(0 Omtaler)
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. Mer

$200 USD på 3 dager
(0 Omtaler)
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 Mer

$166 USD på 2 dager
(0 Omtaler)
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 Mer

$155 USD på 3 dager
(0 Omtaler)
0.0
$155 USD på 3 dager
(0 Omtaler)
0.0
$155 USD på 3 dager
(0 Omtaler)
0.0