How to manually adjust Indicators in Excel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
← Older editNewer edit →
Frank@tygron.nl (talk | contribs)
Tygron, Tygron_admin, Bureaucrats, Interface administrators, Administrators
45,137 edits
No edit summary
No edit summary
Line 1: Line 1:
{{stub|todo=
{{Editor steps
* Missing intro text
|title=
* Debug sheet is not for editing
| 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 Public [[GeoShare]]).
 
|Import the new Excel sheet.
{{Editor steps|title=| 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 Public [[GeoShare]]).|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.  
|The indicator should be visible in the top bar.
|"Update" platform.  
|Press "Debug Excel Sheet".
|Save the Debugged Excel Sheet 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 {{software}} and press "select Excel Sheet" again and "import" or "update" the saved Excel Sheet.  
}}
}}


Line 13: Line 19:
|howtos=
|howtos=
* [[How to configure a Query for an Excel Indicator]]
* [[How to configure a Query for an Excel Indicator]]
* [[How to implement an Excel Indicator]]
* [[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]]
|api=* [[Api session event editor indicator set excel]]
* [[Api session event editor indicator export debug excel]]
}}
}}
[[Category:How-to's]][[Category:Indicator]]
[[Category:How-to's]][[Category:Indicator]]

Revision as of 11:52, 6 July 2026

How to manually adjust Indicators in Excel:
  1. Go to Current Situation -> Indicators, "Add" a new Excel indicator in the bottom left corner.
  2. "Select Excel sheet" (in the middle right of the screen) of the desired new indicator (downloaded from the Public GeoShare).
  3. Import the new Excel sheet.
  4. The indicator should be visible in the top bar.
  5. "Update" platform.
  6. Press "Debug Excel Sheet".
  7. Save the Debugged Excel Sheet with the desired name.
  8. Open this file in Excel.
  9. Adjust the values in the column with the desired values (e.g. targets for each neighborhood) and save the file.
  10. Go back to the Tygron Platform and press "select Excel Sheet" again and "import" or "update" the saved Excel Sheet.

How-to's

See also

API Endpoints

Retrieved from "https://support.tygron.com/w/index.php?title=How_to_manually_adjust_Indicators_in_Excel&oldid=88829"