Alexie0830
New Member
- Joined
- Oct 5, 2017
- Messages
- 1
Hi Everyone,
We are trying to recreate MS Projects functionality in XLS and running into a few issues (weak in VBA).
We've created Gantt Chart which has multiple dependencies (tasks cant begin unless previous task finishes or task must complete if other task finishes).
To add additional complexity - the task can not be executed (go live) if it falls into certain weeks of the month. (Closing week - Accounting calendar).
Example:
Closing - every 4th week of the month (for 5 business days) - during this time no task can go live (it could be executed but not released)
- Task 1 (main)
- Task 2 (dependent on Main)
Option A: Task 2 must finish if Task 1 finishes
Option B: Task 2 cant start unless Task 1 finishes.
Has anyone tried to do this in XLS?
Any insight will be greatly appreciated.
We are trying to recreate MS Projects functionality in XLS and running into a few issues (weak in VBA).
We've created Gantt Chart which has multiple dependencies (tasks cant begin unless previous task finishes or task must complete if other task finishes).
To add additional complexity - the task can not be executed (go live) if it falls into certain weeks of the month. (Closing week - Accounting calendar).
Example:
Closing - every 4th week of the month (for 5 business days) - during this time no task can go live (it could be executed but not released)
- Task 1 (main)
- Task 2 (dependent on Main)
Option A: Task 2 must finish if Task 1 finishes
Option B: Task 2 cant start unless Task 1 finishes.
Has anyone tried to do this in XLS?
Any insight will be greatly appreciated.
