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.

Editor → Current Situation (Ribbon tab) → Panels (Ribbon bar) → Single Panels (Left panel)

How to create a grid of new developments:

1. Ensure a Grid Overlay exists with a Project-wide static dataset
2. Ensure a Grid Overlay exists with a Project-wide dynamic calculation
3. Create an Excel file with the following named cell:
   Name: UPDATE_BUILDING_FUTURE_PLAN_WHERE_STATE_IS_PLANNED_CONSTRUCTION
   Value: 1
4. Upload the file as a Single Excel Panel.
5. 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
6. 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.

Notes

• This technique relies on all new developments featuring a newly creation Building. Any locations where old constructions are merely removed but no new Buildings are placed will not be assigned the Attribute.

See also

• Excel
• Panels
• Update building attribute (TQL)
• Timestate

External links

• File:Future plan updater.xlsx