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 / View
Query : Budget and Costs V3 [view : CRV_Initiative_V3]
Query : ForeseenProjectManager [view : CRV_ZForeseenProjectManager ]
Script / Macro
- 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
The best way to get IT support is to use the new
Service One Platform.