Budget & Cost provided project information with cost of each quarter, help to have overview of project in SBS.

Template  : Budget & Costs

Calculation of KPI : https://docs.google.com/document/d/15dHA8wCSR7dcmS-gGUHH9KkBNz_fLH5sb29GSdQnd70

Query :  Budget and Costs V3    [view : CRV_Initiative_V3]

Query :  ForeseenProjectManager  [view : CRV_ZForeseenProjectManager ]

• Workbook_Open()   copy value from shee : Data1 to sheet : DataFromView 

  Reason behind ... originally the formula in BudgetCostsModel refer to DataFromView, later we applied Data1 to load data instead of using TableWizard because TW cause timeout issue when load huge data

• How to display cost of each type, quarter and year on hidden rows to be used as key picking the cost