Excel Project Dpendecies Calculation and Formula

Hello Everyone,

I have recently joined the forum. I need help to understand which formula or logic will be used to calculate the task dependencies. I am attaching the sheet herein has question as well. Only small sheet. I have created data validation field in the Column C. Now what I want to do;

Task Spreadsheet

Activity Task Dependency Start Date Actual Duration (Days) Actual Finish Date Actual % Completion Resources Actual Task Cost
Task A FS 15/07/2022 3 18/07/2022 100% R3, R2 9000
Task B FS 18/07/2022 4 22/07/2022 75% R5 6000
Task C FS 22/07/2022 8 30/07/2022 60% R3, R4 36000
Task D SS 30/07/2022 10 09/08/2022 50% R4 25000
Task E FS 09/08/2022 13 22/08/2022 25% R1, R3 39000

1. Link Start date with Task so every time I change the task date will be calculated automatically.
2. Actual Duration is fixed
3. Only Start and Finish date will vary with any change in TASK ( FS, SS, FF, SF)

I have a test to attend tomorrow, if anyone can help me out fill the file and tell me the formula and logic. I will be obliged.



Thanks,