How to manually adjust Indicators in Excel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
← Older edit
Maxim@tygron.com (talk | contribs)
Tygron, Tygron_admin, Bureaucrats, Administrators
5,955 edits
Reijn@tygron.com (talk | contribs)
Tygron
864 edits
No edit summary
Maxim@tygron.com (talk | contribs)
Tygron, Tygron_admin, Bureaucrats, Administrators
5,955 edits
No edit summary
 
(14 intermediate revisions by 5 users not shown)
Line 1: Line 1:
{{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 [https://store.tygron.com/ Tygron Index])|Import the new Excelsheet|Index should be visible in the indicator grid|Update platform |Press Debug Excel sheet|Save Debugged Excelsheet with desired name|Open this file in Excel|Adjust the values in the column with the desired value (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
{{Editor steps
|title=
| Go to Current Situation -> Indicators, "Add" a new Excel indicator in the bottom left corner.
|Click "Select Excel sheet" (middle right) to choose the indicator downloaded from the Public [[GeoShare]].
|Import the new Excel sheet.
|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.
}}
}}
{{article end
|seealso=
* [[Indicator]]
|howtos=
* [[How to configure a Query for an Excel Indicator]]
* [[How to make the Green Garden Indicator]]
* [[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]]

Latest revision as of 11:32, 13 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. Click "Select Excel sheet" (middle right) to choose the 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=91034"