Dynamic Model EXCEL , VBA
$30-250 USD
Paid on delivery
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.
Project ID: #16449600
About the project
20 freelancers are bidding on average $165 for this job
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
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.
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
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
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
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
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.
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
Hey, I have prior experience in data entry and excel. I hope you will consider my bid. thanks..............................
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
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
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
I am the best for this work! :) You will not regret! +++++++++++++++++++++++++++++++++++++++++++++++