Question: how to calculate bcws in excel?
Answer: Task BCWS = Planned Percent Complete x Task Budget.
Project BCWS = SUM(BCWS values of all parent and individual tasks)