Template:Change/sandbox

Template documentation[view] [edit] [history] [purge]

Use

This template calculates the percent change between two real number values and displays the result in a sortable format.

The syntax for this template is as follows.

{{change|1st No.|2nd No.|dec=rounding|pre=prefix|suf=suffix|sort=on/off|italics=on/off|bold=on/off|invert=on/off|disp=row/out|rowspan=rowspan|align=alignment|bgcolour=background colour}}

parameter	function
1	1st No. is the first number displayed representing the base value.
2	2nd No. is the second number displayed representing the object value.
dec	This is the number of decimal places to round the percentage change to.
pre	This adds a prefix to the first and second numbers.
pre1	This adds a prefix to the first number.
pre2	This adds a prefix to the second number.
suf	This adds a suffix to the first and second numbers.
suf1	This adds a suffix to the first number.
suf2	This adds a suffix to the second number.
sort	This adds or removes the {{nts}}-compatible sort key from the first two cells. The default is only to add this if a prefix or suffix is used (i.e. only if needed).
italics	This can either have the value of on or off. italics=on makes the output italic. The default is italics=off.
bold	This can either have the value of on or off. bolds=on makes the output bold. The default is bold=off.
invert	This can either have the value of on or off. invert=on switches the base and object values in the calculation of percentage change. The default is invert=off.
align	This adjusts the alignment of text in cells. align=center and align=left aligns the text to the centre and left respectively. The default is align=right.
rowspan	This adjust the row span of cells. The default is rowspan=1.
bgcolour	This adjusts the background colour of cells. The default is bgcolour=inherit (inherits this value from the table).
disp	This controls what is output. disp=out produces the percentage change only (and thus align, rowspan and bgcolour do not work with disp=out). The default is disp=row which produces three cells in a table row.

Examples

The following sortable tables illustrate the use of this template.

Wiki markup		Tables
{|class="wikitable sortable" !Region !first !second !change |- |Big Meadow |{{change|1830000|1900679.75}} |- |Little Meadow |{{change|400000|500000}} |- |Mount Acme |{{change|2450000|2205678.37}} |- |Acmevale North |{{change|1250000|1000000|rowspan=2}} |- |Acmevale South |- |Homeport |{{change|5120000|5589462.60|dec=0}} |- |Longwood |{{change|930000|930027.92|dec=3}} |- |Meadowbrook |{{change|2450000|2450000.00|pre=$}} |- |Johnstown |{{change|3400000|3902340.05|suf= kg}} |- |Lakewood |{{change|2250000|2236005.56|align=center}} |- style="background-color:lightblue" | Fox Hollow |{{change|1180000|1190345.32|bgcolour=lightblue}} |- |Riverton |{{change|10550000|11236005.55|bold=on}} |- |Timber Creek |{{change|1360000|1310948.30|italics=on}} |- |Terminated |{{change|1500|0.00|bold=on|italics=on}} |- |Upstart |{{change|0|26250.50|align=left}} |- |}			Without extra code Region first second change Big Meadow 1,830,000 1,900,679.75 +3.86% Little Meadow 400,000 500,000 +25.00% Mount Acme 2,450,000 2,205,678.37 −9.97% Acmevale North 1,250,000 1,000,000 −20.00% Acmevale South Homeport 5,120,000 5,589,462.6 +9% Longwood 930,000 930,027.92 +0.003% Meadowbrook $2,450,000 $2,450,000 0.00% Johnstown 3,400,000 kg 3,902,340.05 kg +14.77% Lakewood 2,250,000 2,236,005.56 −0.62% Fox Hollow 1,180,000 1,190,345.32 +0.88% Riverton 10,550,000 11,236,005.55 +6.50% Timber Creek 1,360,000 1,310,948.3 −3.61% Terminated 1,500 0 −100.00% Upstart 0 26,250.5 NA		With |disp=out Region change Big Meadow +3.86% Little Meadow +25.00% Mount Acme −9.97% Acmevale North −20.00% Acmevale South Homeport +9% Longwood +0.003% Meadowbrook 0.00% Johnstown +14.77% Lakewood −0.62% Fox Hollow +0.88% Riverton +6.50% Timber Creek −3.61% Terminated −100.00% Upstart NA
			With |invert=on Region first second change Big Meadow 1,830,000 1,900,679.75 −3.72% Little Meadow 400,000 500,000 −20.00% Mount Acme 2,450,000 2,205,678.37 +11.08% Acmevale North 1,250,000 1,000,000 +25.00% Acmevale South Homeport 5,120,000 5,589,462.6 −8% Longwood 930,000 930,027.92 −0.003% Meadowbrook $2,450,000 $2,450,000 0.00% Johnstown 3,400,000 kg 3,902,340.05 kg −12.87% Lakewood 2,250,000 2,236,005.56 +0.63% Fox Hollow 1,180,000 1,190,345.32 −0.87% Riverton 10,550,000 11,236,005.55 −6.11% Timber Creek 1,360,000 1,310,948.3 +3.74% Terminated 1,500 0 NA Upstart 0 26,250.5 −100.00%		With |invert=on and |disp=out Region change Big Meadow −3.72% Little Meadow −20.00% Mount Acme +11.08% Acmevale North +25.00% Acmevale South Homeport −8% Longwood −0.003% Meadowbrook 0.00% Johnstown −12.87% Lakewood +0.63% Fox Hollow −0.87% Riverton −6.11% Timber Creek +3.74% Terminated NA Upstart −100.00%

This template uses Module:Math and Template:ntsh, and produces a sort compatible with Template:nts and Template:ntsh.

Tracking

Invalid input is tracked using WhatLinksHere for {{change/error}}.

See also

• Template:Change2 is a simplified version of this template.
• Template:Changes compares up to 20 numbers in either ascending or descending order.

The above documentation is transcluded from Template:Change/doc. (edit | history)
Editors can experiment in this template's sandbox (edit | diff) and testcases (edit) pages.
Add categories to the /doc subpage. Subpages of this template.