How to manually adjust Indicators in Excel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 1: Line 1:
{{stub|todo=
* Missing intro text
* Debug sheet is not for editing
}}
{{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.  
{{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.  
}}
}}

Latest revision as of 10:47, 11 November 2024

This article is a stub. The following information should be added:
  • Missing intro text
  • Debug sheet is not for editing
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 Excelsheet.
  4. The indicator should be visible in the top bar.
  5. "Update" platform.
  6. Press "Debug Excelsheet".
  7. Save the Debugged Excelsheet 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 Excelsheet" again and "import" or "update" the saved Excelsheet.