How to manually adjust Indicators in Excel: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 10: | Line 10: | ||
* [[How to implement an Excel Indicator]] | * [[How to implement an Excel Indicator]] | ||
* [[How to make the Green Garden Indicator]] | * [[How to make the Green Garden Indicator]] | ||
* [[How to use the Query Tool to test queries from an Excel Indicator spreadsheet]] | * [[How to use the Query Tool to test queries from an Excel Indicator spreadsheet]] | ||
}} | }} | ||
[[Category:How-to's]][[Category:Indicator]] | [[Category:How-to's]][[Category:Indicator]] |
Revision as of 09:03, 27 January 2023
How to manually adjust Indicators in Excel:
- Go to Current Situation -> Indicators, "Add" a new Excel indicator in the bottom left corner.
- "Select Excel sheet" (in the middle right of the screen) of the desired new indicator (downloaded from the Tygron Index).
- Import the new Excelsheet.
- The indicator should be visible in the top bar.
- "Update" platform.
- Press "Debug Excelsheet".
- Save the Debugged Excelsheet with the desired name.
- Open this file in Excel.
- Adjust the values in the column with the desired values (e.g. targets for each neighborhood) and save the file.
- Go back to the Tygron platform and press "select Excelsheet" again and "import" or "update" the saved Excelsheet.