Template:StellarData.calculateEx

• [[{{{_pageName}}}]] -> {{{world}}} -> {{{UWP}}} -> ++ -1 ++ 7 = +0 ## 9

This template is used in conjunction with a query on the StellarData cargo table to recalculate the Economic Extension (Ex) values. The economic data changes with some changes to the UWP data. So starting from the base T5 Second Survey data and having data adjusted over time (e.g. New Era) the Economic data needs to be redone.

this thread has the example of how the values should be changes for small era changes.

The stellar data query required for using this template.

{{#cargo_query: tables=StellarData
 |fields=_pageName, world, GROUP_CONCAT(uwp, ' ',ix,' ',COALESCE(ex, '----'), ' ', era ORDER BY era SEPARATOR ', ')=UWP, giants, belts
 |where=sector='Spinward Marches' and subsector='Regina'
 |group by=_pageName,world
 |format=template
 |template=StellarData.calculateEx
 |named args=yes
}}

The output is a list with the existing data:

Alell (world)/data -> Alell (world) -> B56789C-A 3 B7C+5 Milieu 1116, B56789C-B 3 B7C-2 New Era -> B ++ 7 ++ C = -2 ## 165

The output values are:

• A link to the world's data page for access to updating the data
• The world name
• The important current data to verify the changes, and be used for the calulations
  • The starting (Milieu 1116) UWP
  • The starting importance
  • The starting Ex value
  • The starting era name
  • The updated UWP
  • The updated importance
  • The updated Ex value, or ----- if none set
  • The updated era name
• The updated Ex value separated into its constituent parts.
  • Resources: This is not changed from the starting value unless the TL moves from 7 to 8 or vice versa.
  • Labor: Calculated as Pop - 1
  • Infrastructure: This is not changed from the starting value unless the population moves from 0 to 1, 3 to 4, or 6 to 7, or vice versa.
  • Efficiency: Always generated as a flux value.
• A counter for the random number generator. This is used as a verification.