Automated Project Timeline and Resource Allocation Matrix

Create an advanced project management tool in Excel that generates Gantt-like timelines with dynamic resource allocation tracking. Develop a system where task dependencies, resource constraints, and timeline adjustments automatically recalculate critical path and potential bottlenecks. Include visual indicators for resource utilization, potential conflicts, and capacity planning.