Indicator Tutorial (Solar Panels)

This tutorial guides you through the steps that are necessary to build your own simple Indicator using excel and TQL. In this example, an Indicator is build that calculates the amount of (different kinds of) houses with solar panels that are present in a neighbourhood.

You can use this tutorial in several ways:

• To practise building your own Indicator from scratch. Please note that for this, a good level of experience with working with Excel is required.
• To learn of what elements an Indicator consists, and to be able to adjust excisting Indicators to your own wishes. For this, do not only start with downloading the dummy Indicator (step 1 underneath), but also download the example Indicator in the Tygron Index named 'Houses with Solar Panels' straigt away, and compare both for each step.

Steps

How to create an 'Amount of Houses with Solar Panels' Indicator:

1. Download the 'Dummy Indicator' from the Video Tutorial page. Use this as a starting point for your own Indicator.
2. Explore the Dummy Indicator. Note that the grey area in the Dummy Indicator is meant for requesting information from the Tygron Platform using queries (TQL). The light blue area is meant for calculations - for instance adding and subtracting data from the Platform. The area on the far right is the html table meant for presenting the results.

1. Check which (housing) Functions with solar panels are present in the Tygron Platform.
2. Compose the right TQL queries necessary tot determine the amount of housing functions with solar panels per neighbourhood. Note that you need information about which neighbourhoods are present and how many (differtent kinds of) houses are present in both the Current and the Maquette state.

File:Tql.jpg

1. Determine and Fill in the required calculations in your Excel Indicator. For instance, the increased amount of buildings with solar panels is obtained by subtracting the amount in the Current state from the amount in the Maquette.
2. Think of how you want to show the results in the table in the Indicator panel and fill in the html table according to this.
3. Add the Indicator to your project and test it.
4. Optional: upgrade your Indicator. Add a column with the resources provided with the Solar Panels. Make an assumption for the resources per house with Solar Panels.

An example of an Indicator that was build following these steps can be found in the Tygron Index named 'Solar panels indicator'.

Also see

Tutorial: How to implement Indicators in the Tygron Platform