How to manually adjust Indicators in Excel - Revision history

Rudolf@tygron.nl at 10:47, 11 November 2024

2024-11-11T10:47:23Z

← Older revision		Revision as of 10:47, 11 November 2024
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.
	}}		}}

Hedi@tygron.com at 10:17, 3 February 2023

2023-02-03T10:17:24Z

← Older revision		Revision as of 10:17, 3 February 2023
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 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.
	}}		}}

Hedi@tygron.com at 10:16, 3 February 2023

2023-02-03T10:16:52Z

← Older revision		Revision as of 10:16, 3 February 2023
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.\|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.
	}}		}}

Frank@tygron.nl at 09:03, 27 January 2023

2023-01-27T09:03:39Z

← Older revision		Revision as of 09:03, 27 January 2023
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 manually adjust Indicators in Excel]]
	* [[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]]

Frank@tygron.nl at 09:03, 27 January 2023

2023-01-27T09:03:33Z

@@ 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.|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.
 }}
 [[Category:How-to's]]

Frank@tygron.nl at 15:05, 20 January 2023

2023-01-20T15:05:35Z

← Older revision		Revision as of 15:05, 20 January 2023
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.\|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 [https://store.tygron.com/ 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.
	}}		}}
			[[Category:How-to's]]

Reijn@tygron.com at 07:36, 11 September 2020

2020-09-11T07:36:59Z

← Older revision		Revision as of 07:36, 11 September 2020
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.\|The indicator should be visible in the top bar.\|"Update" platform. \|Press "Debug Excelsheet".\|Save 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 [https://store.tygron.com/ 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.
	}}		}}

Reijn@tygron.com at 14:34, 10 September 2020

2020-09-10T14:34:22Z

← Older revision		Revision as of 14:34, 10 September 2020
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 Excelsheet".\|Save Debugged Excelsheet with 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 [https://store.tygron.com/ Tygron Index]).\|Import the new Excelsheet.\|The indicator should be visible in the top bar.\|"Update" platform. \|Press "Debug Excelsheet".\|Save 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.
	}}		}}

Reijn@tygron.com at 13:44, 10 September 2020

2020-09-10T13:44:17Z

← Older revision		Revision as of 13:44, 10 September 2020
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 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 [https://store.tygron.com/ Tygron Index]).\|Import the new Excelsheet.\|Index should be visible in the indicator grid.\|"Update" platform. \|Press "Debug Excelsheet".\|Save Debugged Excelsheet with 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.
	}}		}}

Reijn@tygron.com at 13:41, 10 September 2020

2020-09-10T13:41:06Z

← Older revision		Revision as of 13:41, 10 September 2020
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\|"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 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
	}}		}}