How to create a grid of new developments
When working with a Project which explores the effects of new developments, there often arrises a need to have known, detailed, static data loaded in for the original situation, but to have a dynamic calculation for all future developments. To combine static datasets and dynamic calculation results, it is neccesary to know which locations have new developments. This can be arranged by leveraging built-in Building Timestate logic and raising it into the Attribute space.
- Ensure a Grid Overlay exists with a Project-wide static dataset
- Ensure a Grid Overlay exists with a Project-wide dynamic calculation
- Create an Excel file with the following named cell:
Name: UPDATE_BUILDING_FUTURE_PLAN_WHERE_STATE_IS_PLANNED_CONSTRUCTION
Value: 1 - Upload the file as a Single Excel Panel.
- Add an Average Overlay, with the following configuration:
Averaging operator: MAX (Set this value via the configuration wizard)
Averaging distance: 0
Averaging Attribute: FUTURE_PLAN - Add a Combo Overlay, with the following configuration:
Input A: The static dataset
Input B: The dynamic calculation
Input C: The created Average Overlay for the FUTURE_PLAN Attribute
Formula: IF( GT(C,0), A, B )
With this configuration, any Buildings created as part of a future design (Parametric Designs, Measures, or Actions, will automatically be assigned a "FUTURE_PLAN" Attribute, which is then highlighted in the created Average Overlay. Based on that result, either the original static data, or the dynamically determined new result is shown. This merges the two based on the presence of new developments.