Jana.safferova: založena nová stránka s textem „3 - Type of the column to use as a variable“

2022-08-19T09:37:57Z

založena nová stránka s textem „3 - Type of the column to use as a variable“

← Starší verze		Verze z 19. 8. 2022, 09:37
Řádek 57:		Řádek 57:
	If it is necessary to assign a color to an unserved job, [https://wiki.solvertech.cz/wiki/TAS:Pokro%C4%8Dil%C3%A9/Pluginy/Input,_Output/Import/ScenarioImporter/P%C5%99idej_sloupec_ColumnsAdd it is necessary to create a dynamic column] "color", optimally setting it to the default color "Red".		If it is necessary to assign a color to an unserved job, [https://wiki.solvertech.cz/wiki/TAS:Pokro%C4%8Dil%C3%A9/Pluginy/Input,_Output/Import/ScenarioImporter/P%C5%99idej_sloupec_ColumnsAdd it is necessary to create a dynamic column] "color", optimally setting it to the default color "Red".

	It is then possible to change the colour of the job using conditions. Note that the colour notation is different than in [https://wiki.solvertech.cz/wiki/TAS:Pokro%C4%8Dil%C3%A9/Pluginy/Input,_Output/Import/ScenarioImporter/AfterConsolidationColumnsCalculated AfterConsolidationColumnsCalculated].		It is then possible to change the colour of the job using conditions. Note that the colour notation is different than in [https://wiki.solvertech.cz/wiki/TAS:Pokro%C4%8Dil%C3%A9/Pluginy/Input,_Output/Import/ScenarioImporter/AfterConsolidationColumnsCalculated/en AfterConsolidationColumnsCalculated].

	If you want to assign a legend to a colour, read [[TAS:Obecné/Mapy/Využívané_mapové_podklady/HERE_mapové_podklady/Zobrazení_legendy_barev_na_mapě\|Displaying a colour legend on the map]]		If you want to assign a legend to a colour, read [[TAS:Obecné/Mapy/Využívané_mapové_podklady/HERE_mapové_podklady/Zobrazení_legendy_barev_na_mapě/en\|Displaying a colour legend on the map]]

	'''Example:'''		'''Example:'''

Jana.safferova: založena nová stránka s textem „left“

2022-08-17T11:46:45Z

založena nová stránka s textem „340px|left“

Nová stránka

<languages />
<br />
It is used to calculate based on some condition.

'''Explanation:'''

<string>1;2;3;4;;5</string>

1 - Type of column into which we want the condition to be written

2 - Name of the column where we want the condition to be written

3 - Type of the column to use as a variable

4 - The name of the column we will use as a variable

5 - condition (separated from the input columns by two semicolons) - Write here the previous type and the column name together as one word.

'''Example:'''

<string>stop2;workingtime;stop2;duration;;stop2duration</string>

In this case, the value that is in the duration column in track 2 is written to the workingtime column in track 2.

'''Other condition options:'''

'''Simple Calculation:'''

<string>stop2;demand1;stop1;demand1;;-stop1demand1</string>

Here the minus value from demand 1 track 1 is written into demand 1 track 2

'''Complicated condition:'''

<string>job;specialcodes;stop1;address;job;specialcodes;;stop1address==Opatovská cesta 10. 04011 Košice?jobspecialcodes-kosice:jobspecialcodes</string>

If the value "Opatovská cesta 10. 04011 Košice" appears in trace 1 of the adress column, the value from the specialcode and additionally "-kosice" will be written into the specialcodes column. If this condition is not met, only special codes will be written. In this condition, job;specialcodes is used once as the type/name of the column to overwrite the condition and a second time as a variable that is overwritten in this column - so it is necessary to have the job;specialcodes column in the string twice - once at the beginning (type/name of the column) and a second time as a variable.

'''Events Containing Time'''

If it is necessary to assess events that contain time information, "XXX" is used instead of a colon to separate the events.

<string>dynamic;cas_celkem;dynamic;naklad;;dynamicnaklad&gt;100?1400XXX1700</string>

If the value in the dynamic column "load" is greater than 100, the dynamic column cas_celkem will be set to 14:00, otherwise to 17:00.

'''Determine if the field is empty'''

If you need to determine whether a field is empty or contains any value, the syntax is:

<string>stop1;name;stop1;name;;stop1name==?NIKDO:stop1name</string>

If the "name" field of track 1 is empty, the value "NONE" is filled in, if it is not empty, it keeps its value.

'''Assigning a colour to an unserved job'''

If it is necessary to assign a color to an unserved job, [https://wiki.solvertech.cz/wiki/TAS:Pokro%C4%8Dil%C3%A9/Pluginy/Input,_Output/Import/ScenarioImporter/P%C5%99idej_sloupec_ColumnsAdd it is necessary to create a dynamic column] "color", optimally setting it to the default color "Red".

It is then possible to change the colour of the job using conditions. Note that the colour notation is different than in [https://wiki.solvertech.cz/wiki/TAS:Pokro%C4%8Dil%C3%A9/Pluginy/Input,_Output/Import/ScenarioImporter/AfterConsolidationColumnsCalculated AfterConsolidationColumnsCalculated].

If you want to assign a legend to a colour, read [[TAS:Obecné/Mapy/Využívané_mapové_podklady/HERE_mapové_podklady/Zobrazení_legendy_barev_na_mapě|Displaying a colour legend on the map]]

'''Example:'''

<code> 1 <string>dynamic;color;dynamic;color;stop1;demand1;;stop1demand1&lt;51?LawnGreen:dynamiccolor</string> </code><br />

<code> 2 <string>dynamic;color;dynamic;color;stop1;demand1;;stop1demand1&gt;50?SkyBlue:dynamiccolor</string></code><br />

If the job has demand1 less than 51, the color of the uncirculated job is set to "LawnGreen". If larger, it is set to "SkyBlue".

Colours:

[[File:TAS_Pokroile_Pluginy_Input,_Output_Import_ScenarioImporter_ColumnsCalculatedart-color-table.png|340px|left]]

'''Swapping of delivery and collection'''

If you need to swap delivery and collection, please follow the [[TAS:Pokročilé/Pluginy/Input,_Output/Import/ScenarioImporter/Časté_chyby_a_jejich_řešení/Přehození_svozu_a_rozvozu/en|Swap collection and delivery]]

the "?" character separates the condition from the event

the ":" character separates events from each other

the character "XXX" separates the time events from each other

the "==" character determines whether the condition is equal to the given value

the "&gt;" character determines whether the condition is greater than the given value

the character "&lt;" determines whether the condition is smaller than the given value

the character "&gt;&lt;" determines whether the condition contains the given value

TAS:Pokročilé/Pluginy/Input, Output/Import/ScenarioImporter/ColumnsCalculated/en - Historie editací

Jana.safferova: založena nová stránka s textem „3 - Type of the column to use as a variable“

Jana.safferova: založena nová stránka s textem „left“