Half an hour fiddling with Excel and several hours fiddling with Access later, here I have it: Summary Economic Data for the Small Commonwealth Economy.
Gini Coefficient/Lorenz Curve
Gini Coefficient for Gralus: 0.25428526
Gini Coefficient for Shireroth: 0.51309508
See Document for full tables
GDP
For the September Quarter (from 05-06-09* to 05-09-09)
Shireroth
Consumption: $14,487.41
Investment: $1,300.00
Government Spending: $46,454.20
Net Exports: $32,818.00
GDP: $95,059.61
Imports: $6,954.00
Exports: $39,772.00
For the period from of the 19-06-09 to 19-09-09**Gralus
Consumption: $24,791.00
Investment: $5,500.00
Government Spending: $92,148.00
Net Exports: -$36,246.00
GDP: $86,193.00
Imports: $40,191.00
Exports: $3,945.00
Nelaga
Consumption: $0.00
Investment: $0.00
Government Spending: $20,500.00
Net Exports: -$3,400.00
GDP: $17,100.00
Imports: $15,500.00
Exports: $12,100.00
For the June Quarter (06-03-09 to 06-06-09)**Natopia
Consumption: $0.00
Investment: $0.00
Government Spending: $1,150.00
Net Exports: $1,400.00
GDP: $2550.00
Imports: $0.00
Exports: $1,400.00
*This date was a couple days after Gralus joined, chosen so as to avoid most of the initial distributions.Shireroth
Consumption: $70,113.99
Investment: $1,572.44
Government Spending: $40,884.72
Net Exports: $15,281.95
GDP: $127,853.10
Imports: $26,854.83
Exports: $42,136.78
**Ditto for Nelaga and Natopia.
***The three months prior to the first period, while Shireroth was the only nation using the bank. Imports are probably all transactions going to me/Nathan who changed our accounts after the bank went international.
Now I've worked it out once, the GDP calculator is totally automated (all I have to do is update the tables). The Gini Coefficient Calculator requires a little more work, but is quick enough to do. We're probably the first micronation to actually be able to generate this data from real transactions, instead of making up little numbers.
For reference:
Consumption = All spending from a certain nation by Private Accounts.
Investment = All spending from a certain nation by Company Accounts.
Government Spending = All spending from a certain nation by Government Accounts.
Imports = All spending from a certain nation destined for any other nation.
Exports = All spending from any other nations destined for a certain nation.
Net Exports = Exports - Imports
GDP = C + I + G + NX
