8
Dispatch → Meta → Gameplay
How Economic Data is Calculated in the United States of Independence Hill | 3.9
Welcome to the United States of Independence Hill RP tutorial. This comprehensive tutorial will show you how to keep track of your stats, add enhancement stats, and how to open living, breathing markets. You chose an awesome RP strategy to learn about. Let's get started!
{} = UTN | $ = NSD | XAG = Silver | £ = Pound | ¥ = Proweri Yen | H$ = Harryan Dollar | A£ = Duck Billed Plat | $$ = US Dollar | ∆ = New Risa
Above is a list of symbols of registered currencies. Why would you need registered currencies? Because every nation has a different currency with a different exchange rate. Even you. If you're role playing as a bank, registering your friendly neighbor's currency gives you authorization to sell it on a foreign-to-foreign market that you'll create. You also want to display these registered currencies as a courtesy to those nations. Who doesn't enjoy free advertising for their region or nation? We'll explain more about what a foreign-to-foreign market is later on in this tutorial.
We're the Official Bank of:
International Treaty Organization | Type: Region
Number of Nations: 15
GRP: ¥1,468,213,918,974,550.00 $2,421,388,918,972,150.00
GRP Per Capita: ¥26,651.19 $43,953.33
Treasury: ¥71,530,000,000,000.00 |_$117,967,788,709,596.00
Exchange Rate: ¥1.00 = |_$1.65
The Irish |Type: Region
Number of Nations: 2
GRP: A£5,396,809,125,862 $1,993,724,990,454.00
GRP Per Capita: A£28,256 $10,438.35
Treasury: N/A N/A
Exchange Rate: A£1.00 = |_$0.37
Holy John Three: | Type: Region
Number of Nations: 11
GRP: $$220,809,406,053,215.00 $186,740,832,979,220.00
GRP Per Capita: $$32,019.93 $27,079.59
Treasury: N/A N/A
Exchange Rate: $$1.00= |_$0.85
If you're role playing as a bank, it's a good idea to canvas your embassies to see if they'd be interested in having you as their official bank. This is good for both parties because you'll gain social credit from others who RP and they'll be featured on your balance sheet, which will attract nations to want to join their region. Above is just one way to feature these regions. As the bank, you'll want to know things about who you're representing, like exchange rates, currency names and symbols, GDP figures, etc, so you can display these items.
(technical): The whole idea revolves around your spreadsheet and its ability to be refreshed at the intervals you're using in your RP without you having to do very much work at all besides hitting a refresh button and recording RP money movement. Technical instructions in this tutorial will be for Microsoft Excel only. What you'll want to do in this section is look up these region names on your favorite NS calculator. Open a few blank sheets in your excel window, with the first sheet being your RP balance sheet. Go to the second sheet. At the top, click data. Then click any box on that second sheet. At the top right hand side, you'll see a button called 'from the web.' Copy the link of the region you looked up using your favorite NS calculator, and paste it into a box that will pop up on excel. Hit 'ok.' It will gather a table of information from that NS calculator. Then a box will pop up asking if you'd like to open a brand new sheet or use the existing sheet. Click 'use existing sheet.' Then click 'ok.' Now go to your first sheet and click the cell you want your report to begin at. In that cell, type =, then go to your second sheet, click the information you want to display, and hit enter. You'll automatically be taken back to the first page and the cell you chose will be displaying the information you told it to. For simplicity, you'll want to at least emulate the style of display above for ease of use but there is no one particular way to layout the information. Repeat the same instructions for other bits of data you'd like to display. If you have any questions or need help forming data connects, please message me and I'll be glad to help.
General
(data gathered from Broomdces)
Total Population: 53,496,000,000
Criminals: 3,606,920,136.00
Elderly, Retired, & Disabled: 5,969,511,254.00
Military: 1,419,629,836.00
Students & Youth: 10,524,148,000.00
Total Unemployed: 6,767,943,839.00
Total Employed: 25,207,846,936.00
(It is assumed that 'total employed' takes into account the populations from the other groups, except 'unemployed.')
Regional Economy
(I added the stats of the money supply, savings & investment, and velocity of money- GRP and exchange rate stat gathered from NSDossier, Imports & Exports gathered from NSEconomy, income brackets are gathered from NS API Shards, Consumer spending is actually consumption and it's gathered from NSEconomy, Unemployment is also gathered from NSEconomy.)
GRP: {}1,204,562,997,162,030.00 | $2,349,764,861,415,540.00
GRP Per Capita: {}22,516.88 |_$43,924.12
Money Supply: {}1,154,562,997,162,030.00 |_$2,252,228,872,556,860.00
(money supply is GRP - {}50,000,000,000,000. However much is purchased of your currency on the money market is also subtracted from the money supply. You can manually adjust the money supply but it will impact velocity of money)
Velocity of Money: 1.0433
(velocity of money is GDP or GRP divided by the money supply. Higher velocities indicate higher degrees of inflation and activity. Lower velocities indicate the exact opposite.)
Exchange Rate: {}1.00 = $1.95
(For every $10 trillion NSD invested in your money market, add one cent to the exchange rate.)
Imports: {}138,814,767,705,317.00 |_$270,788,712,726,528.00
Exports: {}138,814,768,006,105.00 |_$270,788,713,313,280.00
(add international spending to imports and international revenue to exports, as that incorporates your RP activity on GE&T)
Trade Balance: {}300,787.44 |_$586,752.00
(the trade balance is reflective of your nation's regular activity along with your activity in economic RP.)
Avg Income of the Poorest 10%: {}31,411.64 |_$61,275.31
Avg Income of the Middle Class: {}121,573.64 |_$237,156.11
Avg Income of the Richest 10%: {}428,650.43 |_$836,176.87
Consumer Spending: {}589,372,773,805,455.00 |_$1,149,701,125,989,990.00
(Add your international spending from your economic RP to your consumption. Even though GRP - consumer speding = savings & private investment, adding to the GRP will cause looping errors on your spreadsheet. Do not add to the GRP.)
Savings & Private Investment: {}615,190,223,356,579.00 |_$1,200,063,735,425,550.00
Unemployment Rate: 12.72%
(In reality, interest rates affect the unemployment rate. In this system, however, it's the other way around. The unemployment rate affects the interest rate. NS stats are fiscal policy-driven. Governments can lower taxes, spend on infrastructure, etc via answering issues. However, monetary policy influences money supply, interest rates, and quantitative easing & tightening efforts. In the way economic data is calculated in the United States of Independence Hill, monetary policy is simulated to react to the actions of fiscal policy. Note: Not everything in reality can be emulated with high precision in the game.)
Notice how you have two columns- one for your currency and the other for the value to be displayed in NSD. When you go to load your data table for GRP/GDP, you're going to want to load it to the NSD side. In the cell to the left of it, you're going to want to put '=' then the name of the cell you put your GRP/GDP in and divide that by your exchange rate. Of course, you'll want to know what your exchange rate is. Here's the NSDossier formula to find your exchange rate:
=SQRT((GDP/GRP per capita*Economic Productivity)/404000000)
If you develop a foreign-to-domestic money market and other nations start buying your currency, add 0.01 for every $10 Trillion NSD they've invested. For example, if they spend $52 trillion, you'll want to add at the end of the exchange rate equation +0.052.
Exchange Rate by State
(data taken from Broomdces)
(Your currency depends on the ratio of your population to your GDP. The higher per capita GDP, the higher the value of your currency. Only time, money market activity, and answering issues moves the numbers.)
Trellick: {}1.00 = |_$1.16
Warnermark: {}1.00 = |_$1.33
TTZ: {}1.00 = |_$1.35
Eng App: {}1.00 = |_$1.24
Norte Am: {}1.00 = |_$1.41
Cannafield: {}1.00 = |_$1.09
Blueberry Grove: {}1.00 = |_$1.21
Planetary Production: {}1.00 = |_$1.22
Entalia: {}1.00 = |_$1.10
Var-Emp: {}1.00 = |_$1.23
Anthroponia: {}1.00 = |_$1.03
Bermuda Portal: {}1.00 = |_$0.94
Leatrali: {}1.00 = |_$0.81
AnRoPo: {}1.00 = |_$0.83
(for every $10 trillion NSD invested in your currency, add one cent to each exchange rate if you're role playing that you have states.)
Domestic Real Estate Market
Residential Real Estate Fund: {}115,262,584,984,057.00 |_$224,845,004,096,559.00 |_$1,338.54/share
Fund equation: ((total employed + total unemployed * total population) / (Poorest Income+avg Income+Richest 10%)) / 100
Price per share equation: (Value of the residential real estate fund in NSD / population) /3.14
Commercial Real Estate Fund: {}168,564,872,461,032.00 |_$328,822,830,446,488.00 |_$1,957.54/share
Fund equation: total employed * (total population / 8000000)
Price per share equation: Value of the commercial real estate fund in NSD / total population / 3.14
Industrial Real Estate Fund: {}178,057,937,174,364.00 |_$347,341,139,528,774.00 |_$2,067.78/share
Fund equation: ((Military + total employed) * population) / 8000000
Price per share equation: Value of industrial real estate fund in NSD / total population / 3.14
Total Real Estate Market Value: {}461,885,394,619,453.00 |_$901,008,974,071,821.00
(total value of all three funds)
Foreign Real Estate Investment
(Every time a nation chooses to use a particular financial instrument, such as buying real estate fund shares, buying or selling product, or investing in a money market, it's a good idea to record each transaction and make the applicable ones renew every NS year. The expansion of the balance sheet through the economic interactions initiated by other nations is directly correlated to international economic growth.
Harry Islands | 200 shares RREF (Residential Real Estate Fund: $267,708.57
(number of shares * price per share)
Money Market
(How it works: A nation or region buys your currency by making a deposit and sells it back to you when it appreciates in value. You have three columns. In column 1, you have the names of the investing nations. In column 2, you have amounts of your currency owned by investing nations. In column 3, you have the value of the investment in NSD.
When a nation makes a deposit in NSD, you'll convert it to your currency and put it in column 2. Then you'll multiply the amount in your currency by your exchange rate and put that figure in column 3. This ties the investment to the exchange rate, which means that these account values will rise and fall with it. For every $10 trillion NSD invested in your currency, add once cent to your exchange rate. The total of your currency owned in the money market by either yourself and/or foreign nations, subtract from the money supply.
You will notice that as soon as you're finished, that either a profit or a loss has already occurred. That's just the system doing it's job. The longer the account is open, the more likely you'll make a profit. ) Message me if you need help.
Reino do Brazil: {}780,287,910,869.46 |_$1,522,123,059,622.56
Sovetsya: {}19,507,197.77 |_$38,053,076.49
Anocratic empire: {}69,640,696.05 |_$135,849,483.07
Lodhs beard: {}19,507,197,771.74 |_$38,053,076,490.56
Kingdom of Bornai: {}390,143,955,434.73 |_$761,061,529,811.28
Union of Nobelia: {}12,024,984.92 |_$23,457,375.91
Coliantia: {}6,321,448.86 |_$12,331,375.31
Helos: {}513,500.00 |_$1,001,694.61
Reino do Brazil Agricultural Trust: {}23,067,611.53 |_$44,998,446.03
The Royal Treasury of the United Kingdom of Reino do Brazil: {}66,546,358,374.16 |_$129,813,297,379.35
Monforte: {}908,984,991.46 |_$1,773,175,000.00
The royal Bank of Beloura: {}2,101,788,297.83 |_$4,100,000,000.00
The United States of Independence Hill: {}25,641,025,600,000.00 |_$50,018,455,744,935.70
Empire of Magica: {}30,806,805.62 |_$60,095,444.99
Harry Islands: {}358,974.36 |_$700,258.38
Total Money Market Value: {}26,900,684,036,958.50 |_$52,475,696,370,394.20
Domestic Credit Market
(The domestic credit market is my invented stat. It provides the nation's private consumers a line of credit and their payments add up to whatever percentage excel calculates. This percentage, as well as the default rate, can either increase or decrease. To keep things simple, we bailout what is left so the credit market doesn't inevitably implode. It's probably the most stable build thus far.)
Credit Available: {}401,520,999,054,011.00 |_$783,254,953,805,180.00
Credit Available = (consumer spending + savings & investment)/3
Credit Per Capita: {}7,505.63 |_$14,641.37
Credit Per Capita = (Credit Available / population)
Consumer Interest Rate: 3.50%
Consumer Interest Rate = =SQRT(Credit Available / Unemployment Rate)/1604000000
Credit Utilization: {}326,519,804,444,384.00 |_$636,948,640,168,531.00
(Credit utilization = ((Credit Available / Credit Per Capita) *15450.123456789)-500000000000000
Interest Accrued: {}11,438,701,246,499.40 |_$22,313,700,746,727.20
(Consumer Interest Rate applied to Credit Utilization)
Consumer Debt: {}337,958,505,690,884.00 |_$659,262,340,915,258.00
(Interest Accrued + Credit Utilization)
Credit Default Rate: 3.44%
(Credit Default Rate = SQRT(((Total Black Market / Unemployment Rate) /9000000000000000000))
Total Credit Defaulted: {}11,630,650,861,889.70 |_$22,688,140,657,689.90
(Credit Default Rate applied to Consumer Debt)
Debt Paid by Consumers: {}326,327,854,828,994.00 |_$636,574,200,257,568.00
(Consumer Debt - Total Credit Defaulted)
Government Bailout: {}11,630,650,861,889.70 |_$22,688,140,657,689.90
(the government pays the rest so there is no debt cloud.)
Black Market
(data gathered from Broomdces)
(Keep in mind that buying & selling used goods out of your garage or yard is technically dealing in the black market. Not everything in the black market is illegal. I would assume 45-48% of the black market is the purchase and sales of used goods with the rest being illegal activity. That illegal activity is reflective of how much you're over or under governing your nation or region. Even accounting for second-hand sales activity, the example below shows a significant amount of money that could be otherwise included in the economy. The only way to cut the black market is to avoid over-regulation of industry, corruption, and over-reaching government. Avoiding those three things won't completely eliminate the black market but it will extremely benefit your nation.)
Guns & Weapons: {}33,589,812,719,048.30 |_$65,524,311,982,606.30
Drugs and Pharmaceuticals: {}75,542,690,972,740.30 |_$147,362,621,301,441.00
Extortion & Blackmail: {}126,663,865,250,027.00 |_$247,085,706,996,485.00
Counterfeit Goods: {}133,863,316,286,587.00 |_$261,129,818,518,296.00
Trafficking & Intl Sales: {}23,951,801,882,328.10 |_$46,723,253,630,802.30
Theft & Disappearance: {}61,602,726,626,612.80 |_$120,169,657,158,355.00
Counterfeit Currency & Instruments: {}105,902,483,820,160.00 |_$206,586,069,639,799.00
Illegal Mining, Logging, and Hunting: {}17,195,107,936,906.60 |_$33,542,837,123,159.20
Petty Crimes: {}76,440,114,770,267.80 |_$149,113,243,651,785.00
Bank & Insurance Fraud: {}67,549,634,174,558.20 |_$131,770,407,325,155.00
Tax Evasion: {}633,165,421,598,019.00 |_$1,235,128,310,133,740.00
Total Black Market: {}1,355,466,976,037,260.00 |_$2,644,136,237,461,630.00
Production
(These are supplies, I came up with these stats, and they either go up or down depending on other economic factors. These listings provide limits to what can be purchased.)
Energy
Barrels of Oil Produced: 36,101,819,920.01
(( Population / 556.17352614) * 365 + 1000000000) - 6000000 --------------Some numbers in any given production equation are reflective of buying and selling)
Barrels of Oil Used 28,088,322,979.01
(population / 556.17352614 * 365 / 1.25 + 1000 + 2000000 + 66043)
Gallons of Gasoline: 1,300,692,929.08
(Barrels of Oil Used / 19.36) - 150000 - 100000000 - 50000000 - 200
Gallons of Diesel: 2,647,491,530.98
(Barrels of Oil Used / 10.04) - 150000 - 150000000 - 200
Gallons of Jet Fuel: 6,408,554,116.88
(Barrels of Oil Used / 3.91) - 10000 - 150000 - 750000000 - 25000000 - 200
Gallons of Liquefied Petroleum: 16,330,270,336.63
(Barrels of Oil Used / 1.72) - 150000
Gallons of Heavy Fuel Oil: 16,719,089,868.46
(Barrels of Oil Used / 1.68) - 150000
Agriculture
Kilograms of Corn: 7,102,530,500.00
(Population / 3200) * 365 + 1000000000 + 643000
Kilograms of Wheat: 2,346,623,448.28
(Population / 14500) * 365 + 1000000000
Kilograms of Coffee Beans: 2,959,604,000.00
(Population / 10000) * 365 + 1000000000 + 7000000
Kilograms of Cocoa Beans: 1,952,604,000.00
(Population / 10000) * 365
Kilograms of Tobacco: 27,894,342.86
(Population / 700000) * 365
Kilograms of Cotton: 17,271,654,640.76
(Population / 1200) * 365 + 1000000000 - 45359.237
Kilograms of Industrial Hemp: 1,650,868,000.00
(Population / 30000) * 365 + 1000000000
Kilograms of Sheep's Wool: 2,001,335,384.62
(Population / 19500) * 365 + 1000000000
Kilograms of Cashmere: 488,151,000.00
(Population / 40000) * 365
Cost Indicators
(I also invented the cost indicator stats, these listings depend on how much is bought, sold, or listed in production. These prices fluctuate from NS year to NS year.)
Energy
Price Per Barrel of Oil: {}48.38 |_$94.38
SQRT(Oil Barrels Used / 1200) / 100
Price Per Gallon of Gasoline: {}2.12 |_$4.14
SQRT((Gallons of Gasoline Produced * 140000) / 40400000000000)
Price Per Gallon of Diesel: {}0.96 |_$1.87
SQRT((Gallons of Diesel Produced * 140000) / 404000000000000)
Price Per Gallon of Jet Fuel: {}1.49 |_$2.91
SQRT((Gallons of Jet Fuel Produced * 140000) / 404000000000000)
Price Per Gallon of Liquefied Petroleum: {}2.01 |_$3.92
SQRT((Gallons of LP Produced * 100000 ) / 404000000000000)
Price Per Gallon of Heavy Fuel Oil: {}2.03 |_$3.97
SQRT((Gallons of HFO Produced * 100000) / 404000000000000)
Agriculture
Price Per Kilogram of Corn: {}0.93 |_$1.81
SQRT((kilograms of corn produced *490000) / 4040000000000000)
Price Per Kilogram of Wheat: {}0.17 |_$0.33
SQRT((kilograms of wheat produced * 490000) / 40400000000000000)
Price Per Kilogram of Coffee Beans: {}1.89 |_$3.70
SQRT((Kilograms of coffee beans produced * 490000) / 404000000000000)
Price Per Kilogram of Cocoa Beans: {}1.89 |_$3.70
SQRT((kilograms of cocoa beans produced * 490000) / 404000000000000)
Price Per Kilogram of Tobacco: {}1.06 |_$2.06
SQRT((kilograms of tobacco produced * 80000) / 2000000000000)
Price Per Kilogram of Cotton: {}1.45 |_$2.82
SQRT((kilograms of cotton produced * 490000) / 4040000000000000)
Price Per Kilogram of Industrial Hemp: {}233.03 |_$454.58
SQRT((kilograms of industrial hemp produced * 1000000) / 30400000000)
Price Per Kilogram of Sheep's Wool: {}10.31 |_$20.11
SQRT((kilograms of sheep's wool produced * 260000) / 4040000000000)
Price Per Kilogram of Cashmere: {}57.85 |_$112.85
SQRT((kilograms of cashmere produced * 1000000) / 105000000000)
Government Budget
(data gathered from Broomdces)
Domestic Spending
Administration: {}14,778,444,712,934.60 $28,828,604,377,388.74
Social Safety Net: {}10,231,230,955,108.50 $19,958,264,568,961.43
New American Health Service: {}15,915,248,152,391.00 $31,046,189,329,495.57
Public Education System: {}20,462,461,910,217.10 $39,916,529,137,922.87
Defense: {}4,547,213,757,826.03 $8,870,339,808,427.31
Justice: {}11,368,034,394,565.00 $22,175,849,521,068.26
Commerce: {}20,462,461,910,217.10 $39,916,529,137,922.87
Transportation: {}5,684,017,197,282.51 $11,087,924,760,534.13
The Environment: {}5,684,017,197,282.51 $11,087,924,760,534.13
Social Equality: {}5,684,017,197,282.51 $11,087,924,760,534.13
(Tax rate gathered from Broomdces, Domestic Revenue is all the tax money paid from all 15 states, International revenue is money made from dealings with other nations on the GE&T forum, Domestic Spending is how much your total domestic government budget is, International Spending is how much you pay for dealings with other nations on the GE&T forum. The budget, depending on the state of your nation's economy, can either be a surplus or deficit. Money that isn't spent collects over time, so, even if you run into a deficit, you're still not totally broke.)
Tax Rate % of GDP/GRP: 70%
Domestic Revenue: {}843,194,098,013,424.00 |_$1,644,835,402,990,880.00
International Revenue: {}957,322,861,755.12 |_$1,867,468,639,566.18
Domestic Spending: {}233,389,146,072,572.00 |_$455,276,823,021,434.00
International Spending {}1,471,937,986,440.65 |_$2,871,338,540,922.92
Budget Surplus/Deficit: {}609,290,336,816,167.00 |_$1,188,554,710,068,090.00
As one can see by reviewing this balance sheet, this is a machine for growing and legitimizing a math-based free market system. Supplies and pricing provide constraint within the bounds of realism, the featuring of nations fosters good foreign relations, the featuring of the names of the storefronts provides courtesy advertising to trade partners, and the system itself, which is powered by three different data sources, NSDossier, Broomdces, and NationStates API shards, as well as my own equations produces predictable results.
Smaller regions and individual nations using this system will see more swings in their numbers. The smaller you are, the more of an impact answering issues has. The larger you are, the harder it is to make changes to your nation. Example- it's proven rather difficult to lower my taxes because those changes answer issues produces are infinitesimal at my scale. However, I have done a very good job at keeping the tax rate from going too far past 70%. I'm trying to cut taxes without compromising our universal healthcare system.
Back to recording contracts- If this system does one thing for you, if nothing else, it's that it allows you to keep track of your economic RP. If you're smooth enough, you might find ways to plug your international incidents RP into your economic RP.
If anyone reading this wants to implement this system for themselves and needs help, please message me and we'll talk.
