VBA to find date/time of sorted events based on given conditions
- or -
Post a project like this$21/hr
- Posted:
- Proposals: 11
- Remote
- #3820808
- Expired
As a Virtual Assistant, I am here to help you grow your business by providing support with administrative tasks, social media management, customer service, and more, so you don't have to do it alone.
Quezon City
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX |2D Animator| Video Editing |Photoshop Expert
Karachi
Planning and cost engineer (Primavera P6) /Autodesk render/Quantity takeoff/Excel Macros
Cairo
|Financial Accountant|Lead Generation Expert| Ms Excel Expert |Content Writer|
Islamabad
387349130262135147030599213306174614090763442346666157849145085724928783082
Description
Experience Level: Entry
Hi,
Please see the attached Excel workbook.
I have a list of events that are sorted in chronological order, see column A (which may contain various text information).
I have the estimated minimum date time for when each event happened in column B.
I have the estimated maximum date time for when each event happened in column C.
I also have a formula in column D that uses iterative calculation to estimate the specific date and time for each event, so that the events are evenly distributed within the constraints given by columns B and C.
Please see the chart for an illustration of columns B, C, and D versus the events in column A.
1. I need a VBA or formula solution estimate best fit, while also accounting for the following:
2. The solution needs to take into consideration the following constraints:
a. Events can only happen within the given earliest and latest estimated dates and times seen in columns B and C.
b. Events can only happen between a minimum time and a maximum time defined for each day, see table Calendar in the sheet Time_constraints. (If a day isn't captured in this table, the minimum time should be 11 AM and the maximum time should be 22 PM).
c. Events can not happen at the exact same date + time as other events.
d. Evens shall be as smoothly and evenly distributed within the given constraints as possible.
I hope someone is able to solve this.
Best regards,
Øystein Ange
Please see the attached Excel workbook.
I have a list of events that are sorted in chronological order, see column A (which may contain various text information).
I have the estimated minimum date time for when each event happened in column B.
I have the estimated maximum date time for when each event happened in column C.
I also have a formula in column D that uses iterative calculation to estimate the specific date and time for each event, so that the events are evenly distributed within the constraints given by columns B and C.
Please see the chart for an illustration of columns B, C, and D versus the events in column A.
1. I need a VBA or formula solution estimate best fit, while also accounting for the following:
2. The solution needs to take into consideration the following constraints:
a. Events can only happen within the given earliest and latest estimated dates and times seen in columns B and C.
b. Events can only happen between a minimum time and a maximum time defined for each day, see table Calendar in the sheet Time_constraints. (If a day isn't captured in this table, the minimum time should be 11 AM and the maximum time should be 22 PM).
c. Events can not happen at the exact same date + time as other events.
d. Evens shall be as smoothly and evenly distributed within the given constraints as possible.
I hope someone is able to solve this.
Best regards,
Øystein Ange
Øystein A.
0% (0)Projects Completed
2
Freelancers worked with
2
Projects awarded
9%
Last project
20 Feb 2023
Norway
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies