How to manually adjust Indicators in Excel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
(Created page with "{{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...")
 
No edit summary
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 indicator [[index store]])|Import the new excel sheet|Index should be visible in the indicator grid|Update platform |Press Debug Excel sheet|Save Debugged Excel sheet 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 Excel sheet'' again and import or update the saved 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 indicator [https://store.tygron.com/ Index Store])|Import the new excel sheet|Index should be visible in the indicator grid|Update platform |Press Debug Excel sheet|Save Debugged Excel sheet 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 Excel sheet'' again and import or update the saved Excel sheet  
}}
}}

Revision as of 13:34, 10 September 2020

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 indicator Index Store)
  3. Import the new excel sheet
  4. Index should be visible in the indicator grid
  5. Update platform
  6. Press Debug Excel sheet
  7. Save Debugged Excel sheet with desired name
  8. Open this file in Excel
  9. Adjust the values in the column with the desired value (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
Retrieved from "https://support.tygron.com/w/index.php?title=How_to_manually_adjust_Indicators_in_Excel&oldid=37159"