Template:Change/sandbox

This is the template sandbox page for Template:Change (diff).
See also the companion subpage for test cases.

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

This template uses Lua:

Module:Change (sandbox)

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_number|2nd_number|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}}

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=&nbsp;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	1,250,000	1,000,000	−20.00%
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	1,250,000	1,000,000	+25.00%
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.

TemplateData

This is the TemplateData for this template used by TemplateWizard, VisualEditor and other tools. See a monthly parameter usage report for Template:Change in articles based on its TemplateData.

TemplateData for Change

No description.

Template parameters[Edit template data]
Parameter		Description	Type	Status
1st_number	`1`	The first number displayed representing the base value	Number	required
2nd_number	`2`	The second number displayed representing the object value	Number	optional
dec	`dec`	Number of decimal places to round the percentage change to	Number	optional
pre	`pre`	Prefix to the first and second numbers	String	optional
pre1	`pre1`	Prefix to the first number	String	optional
pre2	`pre2`	Prefix to the second number	String	optional
suf	`suf`	Suffix to the first and second numbers	String	optional
suf1	`suf1`	Suffix to the first number	String	optional
suf2	`suf2`	Suffix to the second number	String	optional
sort	`sort`	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). Suggested values `on` `off`	Unknown	optional
italics	`italics`	Makes the output italic Suggested values `on` `off` Default off	Unknown	optional
bold	`bold`	Makes the output bold Suggested values `on` `off` Default off	Unknown	optional
invert	`invert`	Switches the base and object values in the calculation of percentage change Suggested values `on` `off` Default off	Unknown	optional
align	`align`	Adjusts the alignment of text in cells Suggested values `center` `left` `right` Default right	Unknown	optional
rowspan	`rowspan`	Adjusts the row span of cells Default 1	Number	optional
bgcolour	`bgcolour`	Adjusts the background colour of cells, or by default, inherits from the table Default inherit Example lightblue	Unknown	optional
disp	`disp`	This controls what is outputted. "\|dist=out" produces the percentage change only (and thus the "\|align=", "\|rowspan=" and "\|=bgcolour" parameters do not work with "\|disp=out"). "\|disp=row" produces three cells in a table row. Suggested values `out` `row` Default row	Unknown	optional

Tracking

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