Excel - Revision history

Frank@tygron.nl at 14:35, 20 April 2026

2026-04-20T14:35:48Z

← Older revision		Revision as of 14:35, 20 April 2026
Line 138:		Line 138:
	\|howtos=		\|howtos=
	* [[How to prepare data in Microsoft Excel]]		* [[How to prepare data in Microsoft Excel]]
			\|api=*[[Api session items excelsheets]]
	}}		}}

	{{Indicator nav}}		{{Indicator nav}}

Rudolf@tygron.nl at 11:05, 25 February 2026

2026-02-25T11:05:00Z

← Older revision		Revision as of 11:05, 25 February 2026
Line 1:		Line 1:
	[[File:Tql_webinar.png\|link=https://www.tygron.com/nl/2019/05/22/tql-en-~~upgrades~~/]]		[[File:Tql_webinar.png\|link=https://www.tygron.com/nl/2019/05/22/tql-en-indicators/]]
	[[Category:files]]		[[Category:files]]

Frank@tygron.nl at 16:41, 21 February 2023

2023-02-21T16:41:25Z

← Older revision		Revision as of 16:41, 21 February 2023
Line 136:		Line 136:
	* [[Excel Indicator]]		* [[Excel Indicator]]
	* [[TQL]]		* [[TQL]]
			\|howtos=
			* [[How to prepare data in Microsoft Excel]]
	}}		}}

	{{Indicator nav}}		{{Indicator nav}}

Frank@tygron.nl: /* Excel formatting and descriptions */

2023-02-21T16:39:40Z

Excel formatting and descriptions

← Older revision		Revision as of 16:39, 21 February 2023
Line 130:		Line 130:
	COUNTIF and COUNTIFS don't seem to be processed correctly yet.		COUNTIF and COUNTIFS don't seem to be processed correctly yet.
	-->		-->

			{{article end
			\|seealso=
			* [[Var (Excel)]]
			* [[Excel Indicator]]
			* [[TQL]]
			}}

	{{Indicator nav}}		{{Indicator nav}}

Frank@tygron.nl: /* Excel formatting and descriptions */

2023-01-26T09:01:56Z

Excel formatting and descriptions

← Older revision		Revision as of 09:01, 26 January 2023
Line 131:		Line 131:
	-->		-->

	{{~~article end~~		{{Indicator nav}}
	~~\|seealso=~~
	* [[Excel indicator]]
	* [[Indicator]]
	}}

Frank@tygron.nl: /* Excel formatting and descriptions */

2023-01-25T16:38:37Z

Excel formatting and descriptions

← Older revision		Revision as of 16:38, 25 January 2023
Line 130:		Line 130:
	COUNTIF and COUNTIFS don't seem to be processed correctly yet.		COUNTIF and COUNTIFS don't seem to be processed correctly yet.
	-->		-->

			{{article end
			\|seealso=
			* [[Excel indicator]]
			* [[Indicator]]
			}}

Frank@tygron.nl at 13:53, 4 October 2022

2022-10-04T13:53:22Z

← Older revision		Revision as of 13:53, 4 October 2022
Line 99:		Line 99:
	===Maptype postfixes===		===Maptype postfixes===
	{{main\|Maptype postfix (Excel)}}		{{main\|Maptype postfix (Excel)}}
	The default, non-query output cells (EXPLANATION and SCORE) can output a single result, ~~but in some situations~~ the Excel should actually output separate results, based on the [[Map Type]]. This ~~is especially relevant in [[Simulation Type\|timeline]] Projects. In these cases,~~ the cell names ~~can be expanded by adding~~ maptype postfix to the name of the cell, such as:		The default, non-query output cells (EXPLANATION and SCORE) can output a single result. In situations where you want to compare the original (current) situation with the planned situation, the Excel should actually output separate results, based on the [[Map Type]]. This can be accomplished by expanding the cell names with an additional maptype postfix to the name of the cell, such as:

	<code>SCORE_CURRENT</code> or <code>SCORE_MAQUETTE</code>		<code>SCORE_CURRENT</code> or <code>SCORE_MAQUETTE</code>

Rudolf@tygron.nl: /* How do Excel files relate to the {{software}} */

2021-03-04T08:09:49Z

How do Excel files relate to the {{software}}

← Older revision		Revision as of 08:09, 4 March 2021
Line 12:		Line 12:
	One of the core functions of the {{software}} is to calculate prospective effects of actions and scenarios. Depending on the case being explored, what exactly to calculate and the precise method of calculation can vary. To provide the greatest freedom in the ability to configure a project with relevant, accurate, and third-party approved calculation models, the {{software}} allows some calculation to be made in Excel files. Most notably [[indicators]] can easily be created or adjusted by inspecting and editing the underlying Excel file. By defining specific cells to act as input and output for the calculation, the {{software}} can perform calculations using user-defined Excel files.		One of the core functions of the {{software}} is to calculate prospective effects of actions and scenarios. Depending on the case being explored, what exactly to calculate and the precise method of calculation can vary. To provide the greatest freedom in the ability to configure a project with relevant, accurate, and third-party approved calculation models, the {{software}} allows some calculation to be made in Excel files. Most notably [[indicators]] can easily be created or adjusted by inspecting and editing the underlying Excel file. By defining specific cells to act as input and output for the calculation, the {{software}} can perform calculations using user-defined Excel files.

	Excels can also output text to provide information about the current state of the [[Session]] or provide insight into the calculation of some value. To make information provided in this fashion clear and understandable to a user, the output can be styled with [[HTML]]. The {{software}} will interpret the text output of an Excel file as HTML if possible.		Excels can also output text to provide information about the current state of the [[Session]] or provide insight into the calculation of some value. To make information provided in this fashion clear and understandable to a user, the output can be styled with [[HTML]]. The {{software}} will interpret the text output of an Excel file as [[HTML]] if possible.

	==General structure of Excel files==		==General structure of Excel files==

Rudolf@tygron.nl: /* VARs */

2021-03-03T16:01:04Z

VARs

← Older revision		Revision as of 16:01, 3 March 2021
Line 105:		Line 105:
	===VARs===		===VARs===
	{{main\|Var (Excel)}}		{{main\|Var (Excel)}}
	Calculated numbers can be automatically injected into the EXPLANATION output cell by defining specific cells as VAR cells. These effectively serve as additional output cells. The {{software}} will take the value in the EXPLANATION cell and inject into ~~specifically~~ marked ~~spots~~ the numbers which are output in the VAR cells.		Calculated numbers can be automatically injected into the EXPLANATION output cell by defining specific cells as VAR cells. These effectively serve as additional output cells. The {{software}} will take the value in the EXPLANATION cell and inject into spots marked with "%s" the numbers which are output in the VAR cells.

			A cell named <code>VAR_0</code> will have its numeric value inserted in the EXPLANATION output cell's content, which for example would be "The value is %s, and now we know.".

	==Excel tips and tricks==		==Excel tips and tricks==

Rudolf@tygron.nl: /* Maptype postfixes */

2021-03-03T15:57:21Z

Maptype postfixes

← Older revision		Revision as of 15:57, 3 March 2021
Line 99:		Line 99:
	===Maptype postfixes===		===Maptype postfixes===
	{{main\|Maptype postfix (Excel)}}		{{main\|Maptype postfix (Excel)}}
	The default, non-query output cells (EXPLANATION and SCORE) can output a single result, but in some situations the Excel should actually output separate results, based on the [[Map Type]]. This is especially relevant in [[Simulation Type\|timeline]] Projects. In these cases, the cell names can be expanded by adding a <code>~~_CURRENT~~</code> or <code>~~_MAQUETTE~~</code> ~~to the name of the cell.~~		The default, non-query output cells (EXPLANATION and SCORE) can output a single result, but in some situations the Excel should actually output separate results, based on the [[Map Type]]. This is especially relevant in [[Simulation Type\|timeline]] Projects. In these cases, the cell names can be expanded by adding maptype postfix to the name of the cell, such as:

			<code>SCORE_CURRENT</code> or <code>SCORE_MAQUETTE</code>

	===VARs===		===VARs===