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.
- 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.)
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.
20 freelancers are bidding on average $165 for this job
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.
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