Gold Standard (trade) - Revision history

Tao alexis at 15:44, 3 April 2025

2025-04-03T15:44:12Z

Tao alexis: /* Other Resources */

2025-03-31T20:43:36Z

Other Resources

Tao alexis: /* Other Resources */

2025-03-31T16:48:28Z

Other Resources

Tao alexis: /* Other Resources */

2025-03-29T16:39:55Z

Other Resources

Tao alexis: /* Other Resources */

2025-03-29T16:26:03Z

Other Resources

Tao alexis: /* Other Resources */

2025-03-29T16:24:35Z

Other Resources

Tao alexis: /* Other Resources */

2025-03-29T16:20:55Z

Other Resources

Tao alexis: /* Other Resources */

2025-03-29T16:20:20Z

Other Resources

Tao alexis: /* Other Resources */

2025-03-29T16:18:32Z

Other Resources

Tao alexis: /* Other Resources */

2025-03-29T16:16:47Z

Other Resources

@@ Line 4: / Line 4: @@
 In determining a price for raw resources — agricultural produce before coming to market, mineral ores, harvested oils, quarried stone and more — gold is a convenient standard because, first, it occurs naturally as nuggets or flakes, and is therefore tradeable without alteration.  The first tokens of currency were fashioned of gold, with minimal hammering.  As a material, it's rare, measurable and consistent — unlike, say, a system based on labour or grain production — especially since European-consistent cereals aren't produced at all in many parts of the game world.  Gold is therefore practical where pricing is concerned.
-With gold as the standard measure, we ensure that the value of gold itself differs only slightly from place to place.  Otherwise, the effect on the price of gold wuold cause all other prices in the system to fluctuate wildly (and make the availability of gold the only meaningful factor in determining those prices).  The method employed here, therefore, is to make gold 100 times less flexible than the price of any other material.  "Flexibility" itself is a system-defined metric with its own logic, which we shall explain going forward.
+With gold as the standard measure, we ensure that the value of gold itself differs only slightly from place to place.  Otherwise, the effect on the price of gold would cause all other prices in the system to fluctuate wildly (and make the availability of gold the only meaningful factor in determining those prices).  The method employed here, therefore, is to make gold 100 times less flexible than the price of any other material.  "Flexibility" itself is a system-defined metric with its own logic, which we shall explain going forward.
 == Gold Price ==

← Older revision		Revision as of 20:43, 31 March 2025
Line 118:		Line 118:

	See [[Trade System]]		See [[Trade System]]
		+
		+	[[Category: Trade]]

← Older revision		Revision as of 16:48, 31 March 2025
Line 115:		Line 115:

	We've thus built a template for any undeveloped good we wish to include. All we need do is repeat the line containing ore and adjust the numbers for how many local references there are, how many total references throughout the system for the commodity, and how much production we care to assign per reference. If we increase or decrease a number, that change is reflected in the calculations to make a given commodity's price rise or fall. If we introduce a new location in our game world, and increase the number of references to ore in that location, all things being equal, the price of ore will rise... UNLESS we also increase the amount of production. This is counter-intuitive, but references indicates VALUE, not SUPPLY. The actual production indicates supply. The system therefore doesn't operate on ill-considered supply counts, but upon a structured, location-weighted model, with the availability of references creating a counterbalancing "demand."		We've thus built a template for any undeveloped good we wish to include. All we need do is repeat the line containing ore and adjust the numbers for how many local references there are, how many total references throughout the system for the commodity, and how much production we care to assign per reference. If we increase or decrease a number, that change is reflected in the calculations to make a given commodity's price rise or fall. If we introduce a new location in our game world, and increase the number of references to ore in that location, all things being equal, the price of ore will rise... UNLESS we also increase the amount of production. This is counter-intuitive, but references indicates VALUE, not SUPPLY. The actual production indicates supply. The system therefore doesn't operate on ill-considered supply counts, but upon a structured, location-weighted model, with the availability of references creating a counterbalancing "demand."
		+

	See [[Trade System]]		See [[Trade System]]

← Older revision		Revision as of 16:39, 29 March 2025
Line 111:		Line 111:
	\| style="background-color:#fcf6e9;"\| \|\| style="background-color:#fcf6e9;"\|A3 \|\| style="background-color:#fcf6e9;"\|B3 \|\| style="background-color:#fcf6e9;"\|C3 \|\| style="background-color:#fcf6e9;"\|D3 \|\| style="background-color:#fcf6e9;"\|E3 \|\| style="background-color:#fcf6e9;"\|D3/C3B3 \|\| style="background-color:#fcf6e9;"\|=C3$K$2 \|\| style="background-color:#fcf6e9;"\|=B3/C3G3 \|\| style="background-color:#fcf6e9;"\|=H3/F3 \|\| style="background-color:#fcf6e9;"\|=(C3/B30.02)+1 \|\| style="background-color:#fcf6e9;"\|=I3J38.715*192		\| style="background-color:#fcf6e9;"\| \|\| style="background-color:#fcf6e9;"\|A3 \|\| style="background-color:#fcf6e9;"\|B3 \|\| style="background-color:#fcf6e9;"\|C3 \|\| style="background-color:#fcf6e9;"\|D3 \|\| style="background-color:#fcf6e9;"\|E3 \|\| style="background-color:#fcf6e9;"\|D3/C3B3 \|\| style="background-color:#fcf6e9;"\|=C3$K$2 \|\| style="background-color:#fcf6e9;"\|=B3/C3G3 \|\| style="background-color:#fcf6e9;"\|=H3/F3 \|\| style="background-color:#fcf6e9;"\|=(C3/B30.02)+1 \|\| style="background-color:#fcf6e9;"\|=I3J38.715*192
	\|}</div><div style="clear:both;"></div>		\|}</div><div style="clear:both;"></div>
		+
		+	For those unfamiliar with excel, the dollar signs in Excel formulas are used to lock a reference, preventing it from changing when the formula is copied to other cells. $K$2 means both the column K and the row 2 are fixed. So no matter where you copy that formula, it will always pull the value from cell K2. This ensures that every resource uses the price of gold in Marzabol as a stable anchor for comparison, instead of shifting to some other row or column during replication. It's essential for keeping location-specific constants intact across multiple rows.
		+
		+	We've thus built a template for any undeveloped good we wish to include. All we need do is repeat the line containing ore and adjust the numbers for how many local references there are, how many total references throughout the system for the commodity, and how much production we care to assign per reference. If we increase or decrease a number, that change is reflected in the calculations to make a given commodity's price rise or fall. If we introduce a new location in our game world, and increase the number of references to ore in that location, all things being equal, the price of ore will rise... UNLESS we also increase the amount of production. This is counter-intuitive, but references indicates VALUE, not SUPPLY. The actual production indicates supply. The system therefore doesn't operate on ill-considered supply counts, but upon a structured, location-weighted model, with the availability of references creating a counterbalancing "demand."
		+
		+	See [[Trade System]]

@@ Line 95: / Line 95: @@
 Note that the unit employed to designate one commodity from another does not need to match that of any other.  We can thus price anything from carats to heads of livestock, without needing to adjust the formulas by which the desired number is obtained.  The end result, column K, gives the price per column F, the unit given.
-This brings us to the world value of ore in ounces of gold.  This is a bit tricky.  Whereas 2 ounces of ore are the same value as two ounces of gold, remember that "local" gold has been adjusted for rarity.  This means that we want to multiply the total references for ore against the value of gold '''in Marzabol," which is distinct from its universal price.  Another market would have a slightly different price for the same amount of available ore.  Value is mutable, depending on our location — we want our trade system to reflect this.  The bottom line of the chart gives the excel calculations for row 3.
+This brings us to the world value of ore in ounces of gold.  This is a bit tricky.  Whereas 2 ounces of ore are the same value as two ounces of gold, remember that "local" gold has been adjusted for rarity.  This means that we want to multiply the total references for ore against the value of gold '''in Marzabol''', which is distinct from its universal price.  Another market would have a slightly different price for the same amount of available ore.  Value is mutable, depending on our location — we want our trade system to reflect this.  The bottom line of the chart gives the excel calculations for row 3.
 {| class="wikitable" style="float:left; margin-right: 25px; text-align:center; background-color:#d4f2f2; font-family: inherit;"

@@ Line 105: / Line 105: @@
 | style="background-color:#fcf6e9;"|'''2''' || gold || 1.2 || 2.0 || 2,640.00 || oz. || 1,584.00 || 2,640.00 || 1,584.00 || 1.0 || 1.0003 || 1,673.78
 |-
-| style="background-color:#fcf6e9;"|'''3''' || ore || 1.2 || 2.0 || 8,000,000.00 || lb. || 4,800,000.00 || 3,347.56 || 2,008.56 || 0.000418 ||
+| style="background-color:#fcf6e9;"|'''3''' || ore || 1.2 || 2.0 || 8,000,000.00 || lb. || 4,800,000.00 || 3,347.56 || 2,008.56 || 0.000418 || 1.033 || 0.7235
 |-
 | style="background-color:#fcf6e9;"| || style="background-color:#fcf6e9;"|A2 || style="background-color:#fcf6e9;"|B2 || style="background-color:#fcf6e9;"|C2 || style="background-color:#fcf6e9;"|D2 || style="background-color:#fcf6e9;"|E2 || style="background-color:#fcf6e9;"|D2/C2*B2 || style="background-color:#fcf6e9;"|=D2 || style="background-color:#fcf6e9;"|=F2 || style="background-color:#fcf6e9;"|=H2/F2 || style="background-color:#fcf6e9;"|=(C2/B2*0.0002)+1 || style="background-color:#fcf6e9;"|=I2*J2*8.715*192

@@ Line 107: / Line 107: @@
 | style="background-color:#fcf6e9;"|'''3''' || ore || 1.2 || 2.0 || 8,000,000.00 || lb. || 4,800,000.00 || 3,347.56 || 2,008.56 || 0.000418 ||
 |-
-| style="background-color:#fcf6e9;"| || style="background-color:#fcf6e9;"|A2 || style="background-color:#fcf6e9;"|B2 || style="background-color:#fcf6e9;"|C2 || style="background-color:#fcf6e9;"|D2 || style="background-color:#fcf6e9;"|E2 || style="background-color:#fcf6e9;"|D2/C2*B2 || style="background-color:#fcf6e9;"|=D2 || style="background-color:#fcf6e9;"|=F2 || style="background-color:#fcf6e9;"|=H2/F2 || style="background-color:#fcf6e9;"|=(D2/C2*0.0002)+1 || style="background-color:#fcf6e9;"|=I2*J2*8.715*192
+| style="background-color:#fcf6e9;"| || style="background-color:#fcf6e9;"|A2 || style="background-color:#fcf6e9;"|B2 || style="background-color:#fcf6e9;"|C2 || style="background-color:#fcf6e9;"|D2 || style="background-color:#fcf6e9;"|E2 || style="background-color:#fcf6e9;"|D2/C2*B2 || style="background-color:#fcf6e9;"|=D2 || style="background-color:#fcf6e9;"|=F2 || style="background-color:#fcf6e9;"|=H2/F2 || style="background-color:#fcf6e9;"|=(C2/B2*0.0002)+1 || style="background-color:#fcf6e9;"|=I2*J2*8.715*192
 |-
 | style="background-color:#fcf6e9;"| || style="background-color:#fcf6e9;"|A3 || style="background-color:#fcf6e9;"|B3 || style="background-color:#fcf6e9;"|C3 || style="background-color:#fcf6e9;"|D3 || style="background-color:#fcf6e9;"|E3 || style="background-color:#fcf6e9;"|D3/C3*B3 || style="background-color:#fcf6e9;"|=C3*$K$2 || style="background-color:#fcf6e9;"|=B3/C3*G3 || style="background-color:#fcf6e9;"|=H3/F3 || style="background-color:#fcf6e9;"|=(C3/B3*0.02)+1 || style="background-color:#fcf6e9;"|=I3*J3*8.715*192
 |}</div><div style="clear:both;"></div>

@@ Line 91: / Line 91: @@
 | style="background-color:#fcf6e9;"|'''3''' || ore || 1.2 || 2.0 || 8,000,000.00 || lb. || 4,800,000.00 || colspan="5"|details to come
 |-
-| style="background-color:#fcf6e9;"| || style="background-color:#fcf6e9;"|A2 || style="background-color:#fcf6e9;"|B2 || style="background-color:#fcf6e9;"|C2 || style="background-color:#fcf6e9;"|D2 || style="background-color:#fcf6e9;"|E2 || style="background-color:#fcf6e9;"|D2/C2*B2 || style="background-color:#fcf6e9;"|=D2 || style="background-color:#fcf6e9;"|=F2 || style="background-color:#fcf6e9;"|=H2/F1 || style="background-color:#fcf6e9;"|=(D2/C2*0.0002)+1 || style="background-color:#fcf6e9;"|=I2*J2*8.715*192
+| style="background-color:#fcf6e9;"| || style="background-color:#fcf6e9;"|A2 || style="background-color:#fcf6e9;"|B2 || style="background-color:#fcf6e9;"|C2 || style="background-color:#fcf6e9;"|D2 || style="background-color:#fcf6e9;"|E2 || style="background-color:#fcf6e9;"|D2/C2*B2 || style="background-color:#fcf6e9;"|=D2 || style="background-color:#fcf6e9;"|=F2 || style="background-color:#fcf6e9;"|=H2/F1 || style="background-color:#fcf6e9;"|=(C2/B2*0.0002)+1 || style="background-color:#fcf6e9;"|=I2*J2*8.715*192
 |}<div style="clear:both;"></div><div style="clear:both;"></div>
 Note that the unit employed to designate one commodity from another does not need to match that of any other.  We can thus price anything from carats to heads of livestock, without needing to adjust the formulas by which the desired number is obtained.  The end result, column K, gives the price per column F, the unit given.
@@ Line 109: / Line 109: @@
 | style="background-color:#fcf6e9;"| || style="background-color:#fcf6e9;"|A2 || style="background-color:#fcf6e9;"|B2 || style="background-color:#fcf6e9;"|C2 || style="background-color:#fcf6e9;"|D2 || style="background-color:#fcf6e9;"|E2 || style="background-color:#fcf6e9;"|D2/C2*B2 || style="background-color:#fcf6e9;"|=D2 || style="background-color:#fcf6e9;"|=F2 || style="background-color:#fcf6e9;"|=H2/F2 || style="background-color:#fcf6e9;"|=(D2/C2*0.0002)+1 || style="background-color:#fcf6e9;"|=I2*J2*8.715*192
 |-
-| style="background-color:#fcf6e9;"| || style="background-color:#fcf6e9;"|A3 || style="background-color:#fcf6e9;"|B3 || style="background-color:#fcf6e9;"|C3 || style="background-color:#fcf6e9;"|D3 || style="background-color:#fcf6e9;"|E3 || style="background-color:#fcf6e9;"|D3/C3*B3 || style="background-color:#fcf6e9;"|=C3*$K$2 || style="background-color:#fcf6e9;"|=B3/C3*G3 || style="background-color:#fcf6e9;"|=H3/F3 || style="background-color:#fcf6e9;"|=(D3/C3*0.02)+1 || style="background-color:#fcf6e9;"|=I3*J3*8.715*192
+| style="background-color:#fcf6e9;"| || style="background-color:#fcf6e9;"|A3 || style="background-color:#fcf6e9;"|B3 || style="background-color:#fcf6e9;"|C3 || style="background-color:#fcf6e9;"|D3 || style="background-color:#fcf6e9;"|E3 || style="background-color:#fcf6e9;"|D3/C3*B3 || style="background-color:#fcf6e9;"|=C3*$K$2 || style="background-color:#fcf6e9;"|=B3/C3*G3 || style="background-color:#fcf6e9;"|=H3/F3 || style="background-color:#fcf6e9;"|=(C3/B3*0.02)+1 || style="background-color:#fcf6e9;"|=I3*J3*8.715*192
 |}</div><div style="clear:both;"></div>

← Older revision		Revision as of 16:16, 29 March 2025
Line 94:		Line 94:
	\|}<div style="clear:both;"></div><div style="clear:both;"></div>		\|}<div style="clear:both;"></div><div style="clear:both;"></div>
	Note that the unit employed to designate one commodity from another does not need to match that of any other. We can thus price anything from carats to heads of livestock, without needing to adjust the formulas by which the desired number is obtained. The end result, column K, gives the price per column F, the unit given.		Note that the unit employed to designate one commodity from another does not need to match that of any other. We can thus price anything from carats to heads of livestock, without needing to adjust the formulas by which the desired number is obtained. The end result, column K, gives the price per column F, the unit given.
		+
		+	This brings us to the world value of ore in ounces of gold. This is a bit tricky. Whereas 2 ounces of ore are the same value as two ounces of gold, remember that "local" gold has been adjusted for rarity. This means that we want to multiply the total references for ore against the value of gold '''in Marzabol," which is distinct from its universal price. Another market would have a slightly different price for the same amount of available ore. Value is mutable, depending on our location — we want our trade system to reflect this. The bottom line of the chart gives the excel calculations for row 3.
		+
		+	{\| class="wikitable" style="float:left; margin-right: 25px; text-align:center; background-color:#d4f2f2; font-family: inherit;"
		+	\|+oz. per Local Availability
		+	! style="background-color:#fcf6e9;"\| !! style="background-color:#fcf6e9;"\|A !! style="background-color:#fcf6e9;"\|B !! style="background-color:#fcf6e9;"\|C !! style="background-color:#fcf6e9;"\|D !! style="background-color:#fcf6e9;"\|E !! style="background-color:#fcf6e9;"\|F !! style="background-color:#fcf6e9;"\|G !! style="background-color:#fcf6e9;"\|H !! style="background-color:#fcf6e9;"\|I !! style="background-color:#fcf6e9;"\|J !! style="background-color:#fcf6e9;"\|K
		+	\|-
		+	! style="background-color:#fcf6e9;"\|1 !! style="width:70px"\|resource !! style="width:70px"\|local references !! style="width:70px"\|total references !! style="width:70px"\|production !! style="width:70px"\|unit !! style="width:70px"\|local availability !! style="width:70px"\|world value (oz. gold) !! style="width:70px"\|local value (oz. gold) !! style="width:70px"\|oz. per local availability !! style="width:70px"\|adjustment for rarity !! style="width:70px"\|c.p./unit
		+	\|-
		+	\| style="background-color:#fcf6e9;"\|'''2''' \|\| gold \|\| 1.2 \|\| 2.0 \|\| 2,640.00 \|\| oz. \|\| 1,584.00 \|\| 2,640.00 \|\| 1,584.00 \|\| 1.0 \|\| 1.0003 \|\| 1,673.78
		+	\|-
		+	\| style="background-color:#fcf6e9;"\|'''3''' \|\| ore \|\| 1.2 \|\| 2.0 \|\| 8,000,000.00 \|\| lb. \|\| 4,800,000.00 \|\| 3,347.56 \|\| 2,008.56
		+	\|-
		+	\| style="background-color:#fcf6e9;"\| \|\| style="background-color:#fcf6e9;"\|A2 \|\| style="background-color:#fcf6e9;"\|B2 \|\| style="background-color:#fcf6e9;"\|C2 \|\| style="background-color:#fcf6e9;"\|D2 \|\| style="background-color:#fcf6e9;"\|E2 \|\| style="background-color:#fcf6e9;"\|D2/C2B2 \|\| style="background-color:#fcf6e9;"\|=D2 \|\| style="background-color:#fcf6e9;"\|=F2 \|\| style="background-color:#fcf6e9;"\|=H2/F2 \|\| style="background-color:#fcf6e9;"\|=(D2/C20.0002)+1 \|\| style="background-color:#fcf6e9;"\|=I2J28.715*192
		+	\|-
		+	\| style="background-color:#fcf6e9;"\| \|\| style="background-color:#fcf6e9;"\|A3 \|\| style="background-color:#fcf6e9;"\|B3 \|\| style="background-color:#fcf6e9;"\|C3 \|\| style="background-color:#fcf6e9;"\|D3 \|\| style="background-color:#fcf6e9;"\|E3 \|\| style="background-color:#fcf6e9;"\|D3/C3B3 \|\| style="background-color:#fcf6e9;"\|=C3$K$2 \|\| style="background-color:#fcf6e9;"\|=B3/C3G3 \|\| style="background-color:#fcf6e9;"\|=H3/F3 \|\| style="background-color:#fcf6e9;"\|=(D3/C30.02)+1 \|\| style="background-color:#fcf6e9;"\|=I3J38.715*192
		+	\|}</div><div style="clear:both;"></div>