So. This is hard to explain.
For more than two weeks, I have been putting all my energy towards a rebuild of one key part of my trade table. I'm not changing any of the math, I'm only adjusting the manner in which the excel file is built. The part I'm fixing corresponds to the calculation of transport against references. See the link for a file that can be downloaded; the key page is the "New Master" tab.
Now, why anyone would care, I don't know; but I've been working on this day and night to the exclusion of all else, as long as 12 hours a day when I have the whole day. I started on Friday the 15th. I'm still working on it. I guess this has been 62-68 hours of continuous work. Why? Because it is manually rewriting more than 40,000 excel entries.
Previously, the "master" page that accounted for all production for all market cities was a simple chart, 892 products across the top of the page and 1,067 market cities down the left side. This made a chart of 951,764 cells, mostly empty, with about 5% of the cells filled with references. When I wanted to calculate the distance effect on references, as shown on the wiki link, I had to multiply the whole list of cities against all the cells (because it wasn't feasible to pick and choose cells is such a large field), which was getting incomprehensibly slow and file crashing for my computer to manage.
And, of course, the problem was only going to get worse, because I had to add more markets: Burma, all of Great Britain, Iceland and part of Africa - a total of another 150 markets. Something had to change.
So, now I have built the table so that it sorts each kind of product into its own individual chart; the calculation is made automatically when the distances are input into the file (as can be seen on the downloaded link) and added together. I will then add another page that correlates the individual products so that it can be compared with the prices table.
This actually reduces my mechanics by one whole file, as it compresses two files into one (don't worry about it, it would take me too long to explain those files). Plus it adds information, as now the user can go down the list and see where the largest amount of imported value is coming from.
I offer this for geeks only. Most of you just won't care, won't get anything out of the excel file, won't understand why I'm doing this. But it is definitely better.
I'm pretty close now to getting all the data recalculated; but most of that is on another file, not linked, sorted but not actually pasted onto the new folder. It has been a long, long effort. I'm pretty tired of just crunching numbers. But this is the reason I haven't been writing much; unlike making monsters, which screams blog material, rewriting numbers into new fields and organizing data, not so much.
I'll be done this soon, however, and looking for something else to do. I think, in the future, it will be easier to add new markets to my trade tables, and that is what I want right now. Earlier, I had to pretty much do big chunks of new data all at once, basically waiting to collect a chunk before updating everything. Now I should be able to do one city at a time, very easily.
I'm really glad about this.
Showing posts with label Trade & Production. Show all posts
Showing posts with label Trade & Production. Show all posts
Thursday, September 28, 2017
Friday, April 14, 2017
Notes on Stavanger's Economy
A very long time ago, I wrote a series of posts that I called "never too much economics." I have to apologize to start: if you have not followed past posts I have written on hex generation, economics and my trade system, I'm going to lose your attention very quickly. There's nothing I can do about that. I have been working on this method for logically calculating the structure underlying any part of my world, very large world that it is. The work shown today represents just a few hours of work for this particular region in my game, that created for the Juvenis campaign.
I'm going to use some of the details of that post in order to address this map:
This is a part of my larger game world expanded from 20-mile hexes to 6.67-mile hexes (6-mile for short), using a hex generator I've talked about on my blog before ~ though not for a long time.
The map shows production for food, hammers and coin, similar to the same measurements for the old game, Civilization IV. Five years ago, I defined one food as sufficient to feed 167 persons at a minimal rate of sustenance, a very unpleasant 1,700 calories per day. We may assume that is for any period, as we're not actually measuring the weight of food, only its consumption vs. its production.
Back in the day, I also wrote that a hex with two food symbols showing should be read as the binary number "11" ~ which would be 3 in the base-ten system. A hex with three food symbols showing would equal the binary "111," or 7 in the base-ten system. Thus, three food showing will feed not 500 persons, but 1,167. The greatest production on the map above is the hex surrounding Stavanger, showing a loaf and two slices, or "1111111," or 127 in base-ten, enough to feed 21,167 persons. That's not bad, but the county of Rogaland, depicted above, has a population of 25,627.
How much food is showing, in base-ten numbers? I may have miscounted, but I get 392 food altogether, enough to feed 65,335 people. That is, at sustenance level. That 1,700 calories is fairly low, so we can double that amount for the people around Stavanger and still have enough food for export. This makes sense. Norway is a relatively rich country, with productive forests, plenty of water, excellent soil (where there is soil) and a relatively low population. It ought to be an exporting region ~ even if it is only enough to feed 7,040 persons at a comfortable 3,400 calories a day. There are many more people than that in the world.
The coins showing work the same way as food. The number of coins in a given hex show an exponential progression, so that the hex with Stavanger in it would have 63 coins (binary 111111). Altogether, the region shown has 115 coins - so Stavanger by itself represents more than half the total wealth of the region. This, too, makes sense.
My post on coins argued for a fixed rate of 2,500 g.p. per coin showing, with the understanding the the principle of money is that it flows through the hands of people on a continuous basis. In effect, I argued, this would mean that the total income for all the persons in the region would be three times the actual physical wealth ~ arguing for a low velocity that would correspond to a 17th century world.
I'd like to deviate from that old number, however, as it was based on an ill-proposed Player's Handbook reference. I should be able to do better. For this, I'll turn to my trade tables, specifically the list of goods and services that are produced in Rogaland.
As it happens, Rogaland has a very poor collection of references for my trade tables:
That is a very sad collection of things. Clearly, the encyclopedia I drew from did not have much of a description for Stavanger ~ but the trick is not to rush forward and change it, because that seems best, but to presume that the region is economically depressed, regardless of how much food it produces or the number of people.
At present, my overall trade numbers (subject to change as I add more regions) indicate that one reference is worth 941.18 gold ounces, or 7,647 gold pieces per reference. Since the total value for Rogaland is only four times that, or 30,588 g.p., it is plain that the number per coin shown on the map is going to be less than 2,500. 30,588 divided by 115 equal 265 g.p. per coin.
With a per capita income of only 1.19 g.p. per person, we have to wonder how anyone can afford to buy books and statues from the party for 1,750 g.p., as recently happened in the campaign. I admit, that is a problem; but I paid out that money before making the above calculations.
We can push the velocity of the money in the region by 1, to a total of 4, then presume that the total income of the region passes specifically through the hands of the merchants (along with the upper class, the nobility and the hoi polloi, as detailed in my original post). If the merchants represent 0.1% of the total population, this makes the average yearly income for a merchant in Stavanger (they would all be in the trade town) a total of 1,190 g.p. per year.
We can also assume an accumulation of wealth, arguing that gold (and everything else that doesn't spoil) is steadily mined and added to the system, where it spreads outwards in the form of trade and ultimately collects in the hordes and savings of people. We might argue that if 2% of the total coins in the world is irrevocably lost to monsters, lost hiding places and being sunk in the sea every year, then there is something like 51 years worth of accumulated gold pieces in the world (at that point, loss more or less equals production). That is more than enough for an apothecary to dig into their accumulated 56,000 g.p. of wealth to buy something very special.
This could mean that the monetary assets for Rogaland are considerable, even if much less than other regions with far more references to goods, services and manufacturing. Like any good economist, it depends on how we propose to juggle the numbers.
I think I would want to create additional regions, then spread the income over several regions and not just use Rogaland as an isolated measurement. I'd argue that the loss of coin from the system was higher, just to reduce the pure wealth available. I think a combination of factors could lead to a better approximation.
What we want, of course, is to be able to identify the wealth produced by a specific hex, giving us a number as to how much coin is a) regularly flowing out of that hex, if the player wishes to start a venture of some sort, and b) how much gold is buried in the hex, in terms of plundering it from monsters and/or dungeons.
This lets the gold of the hex determine how much product is sold in Stavanger, if the party decides to go fishing or lumberjacking, rather than trying to figure out specific production figures for every imaginable sort of product. The player spends x time in this forest, which produces y amount of money per year for z number of people (determined by food supply). This makes a very simple calculation for how much money the player can make from time spent, without the fuss of guessing how much fruit or flax or feldspar a given hex can produce.
Finally, I come to hammers.
I am at a loss here. My old thinking has one primary problem: the system does not generate what sort of buildings have already been created, or what has been done with the hammers generally in the last 750+ years of Stavanger's existence (founded 862). If we are only talking of the hammers being used for civic improvement, then they are only available to those who actually control the hex. If so, I can safely ignore them for the time being.
I would like another value attached to the hammers, however ~ a problem I haven't considered for a very long time and thus also a problem I have distance on. Since I've only rediscovered the problem in the last couple of days, I haven't even begun to solve it.
What I'd like is some meaning that is applicable to player characters at any point. It could represent the amount of labor in the area, available or otherwise. It might somehow represent the present existing infrastructure, but I'm not sure how. It is easy to add it all together to get the size of Rogaland's military, the work force directly under control of the upper classes or even the amount of original created artwork that can be found (related to the bard). I just need to think about it.
I'm going to use some of the details of that post in order to address this map:
This is a part of my larger game world expanded from 20-mile hexes to 6.67-mile hexes (6-mile for short), using a hex generator I've talked about on my blog before ~ though not for a long time.
The map shows production for food, hammers and coin, similar to the same measurements for the old game, Civilization IV. Five years ago, I defined one food as sufficient to feed 167 persons at a minimal rate of sustenance, a very unpleasant 1,700 calories per day. We may assume that is for any period, as we're not actually measuring the weight of food, only its consumption vs. its production.
Back in the day, I also wrote that a hex with two food symbols showing should be read as the binary number "11" ~ which would be 3 in the base-ten system. A hex with three food symbols showing would equal the binary "111," or 7 in the base-ten system. Thus, three food showing will feed not 500 persons, but 1,167. The greatest production on the map above is the hex surrounding Stavanger, showing a loaf and two slices, or "1111111," or 127 in base-ten, enough to feed 21,167 persons. That's not bad, but the county of Rogaland, depicted above, has a population of 25,627.
How much food is showing, in base-ten numbers? I may have miscounted, but I get 392 food altogether, enough to feed 65,335 people. That is, at sustenance level. That 1,700 calories is fairly low, so we can double that amount for the people around Stavanger and still have enough food for export. This makes sense. Norway is a relatively rich country, with productive forests, plenty of water, excellent soil (where there is soil) and a relatively low population. It ought to be an exporting region ~ even if it is only enough to feed 7,040 persons at a comfortable 3,400 calories a day. There are many more people than that in the world.
The coins showing work the same way as food. The number of coins in a given hex show an exponential progression, so that the hex with Stavanger in it would have 63 coins (binary 111111). Altogether, the region shown has 115 coins - so Stavanger by itself represents more than half the total wealth of the region. This, too, makes sense.
My post on coins argued for a fixed rate of 2,500 g.p. per coin showing, with the understanding the the principle of money is that it flows through the hands of people on a continuous basis. In effect, I argued, this would mean that the total income for all the persons in the region would be three times the actual physical wealth ~ arguing for a low velocity that would correspond to a 17th century world.
I'd like to deviate from that old number, however, as it was based on an ill-proposed Player's Handbook reference. I should be able to do better. For this, I'll turn to my trade tables, specifically the list of goods and services that are produced in Rogaland.
As it happens, Rogaland has a very poor collection of references for my trade tables:
That is a very sad collection of things. Clearly, the encyclopedia I drew from did not have much of a description for Stavanger ~ but the trick is not to rush forward and change it, because that seems best, but to presume that the region is economically depressed, regardless of how much food it produces or the number of people.
At present, my overall trade numbers (subject to change as I add more regions) indicate that one reference is worth 941.18 gold ounces, or 7,647 gold pieces per reference. Since the total value for Rogaland is only four times that, or 30,588 g.p., it is plain that the number per coin shown on the map is going to be less than 2,500. 30,588 divided by 115 equal 265 g.p. per coin.
With a per capita income of only 1.19 g.p. per person, we have to wonder how anyone can afford to buy books and statues from the party for 1,750 g.p., as recently happened in the campaign. I admit, that is a problem; but I paid out that money before making the above calculations.
We can push the velocity of the money in the region by 1, to a total of 4, then presume that the total income of the region passes specifically through the hands of the merchants (along with the upper class, the nobility and the hoi polloi, as detailed in my original post). If the merchants represent 0.1% of the total population, this makes the average yearly income for a merchant in Stavanger (they would all be in the trade town) a total of 1,190 g.p. per year.
We can also assume an accumulation of wealth, arguing that gold (and everything else that doesn't spoil) is steadily mined and added to the system, where it spreads outwards in the form of trade and ultimately collects in the hordes and savings of people. We might argue that if 2% of the total coins in the world is irrevocably lost to monsters, lost hiding places and being sunk in the sea every year, then there is something like 51 years worth of accumulated gold pieces in the world (at that point, loss more or less equals production). That is more than enough for an apothecary to dig into their accumulated 56,000 g.p. of wealth to buy something very special.
This could mean that the monetary assets for Rogaland are considerable, even if much less than other regions with far more references to goods, services and manufacturing. Like any good economist, it depends on how we propose to juggle the numbers.
I think I would want to create additional regions, then spread the income over several regions and not just use Rogaland as an isolated measurement. I'd argue that the loss of coin from the system was higher, just to reduce the pure wealth available. I think a combination of factors could lead to a better approximation.
What we want, of course, is to be able to identify the wealth produced by a specific hex, giving us a number as to how much coin is a) regularly flowing out of that hex, if the player wishes to start a venture of some sort, and b) how much gold is buried in the hex, in terms of plundering it from monsters and/or dungeons.
This lets the gold of the hex determine how much product is sold in Stavanger, if the party decides to go fishing or lumberjacking, rather than trying to figure out specific production figures for every imaginable sort of product. The player spends x time in this forest, which produces y amount of money per year for z number of people (determined by food supply). This makes a very simple calculation for how much money the player can make from time spent, without the fuss of guessing how much fruit or flax or feldspar a given hex can produce.
Finally, I come to hammers.
I am at a loss here. My old thinking has one primary problem: the system does not generate what sort of buildings have already been created, or what has been done with the hammers generally in the last 750+ years of Stavanger's existence (founded 862). If we are only talking of the hammers being used for civic improvement, then they are only available to those who actually control the hex. If so, I can safely ignore them for the time being.
I would like another value attached to the hammers, however ~ a problem I haven't considered for a very long time and thus also a problem I have distance on. Since I've only rediscovered the problem in the last couple of days, I haven't even begun to solve it.
What I'd like is some meaning that is applicable to player characters at any point. It could represent the amount of labor in the area, available or otherwise. It might somehow represent the present existing infrastructure, but I'm not sure how. It is easy to add it all together to get the size of Rogaland's military, the work force directly under control of the upper classes or even the amount of original created artwork that can be found (related to the bard). I just need to think about it.
Monday, July 14, 2008
Sources Table
This is the link to my Sources file [dead link], that I posted a portion of on Sunday. It seems to work.
However, you will need Vista to see it. I had been working in XL, but I moved to Vista about a year ago and, after some months of trial and annoyance, in which I needed to go into the system and turn off every FUCKING automatic feature, I now find myself quite comfortable with it. Mostly, for the excel file in question, I'm not limited in my number of columns to about three hundred. I now have three thousand at my disposal...and instead of 64,000 crummy rows, I have more than a million.
So yes, I like Vista.
I would post a file readable by XL, but I can no longer duplicate the file into XL.
If you can see the file, you may notice that there are some blocks which are oddly colored for apparently no reason. These are notes to myself. This is only the first step of the next program, which is to take all the references noted on the Sources table and apply them to the "Prices" table. That is, the table which automatically generates the prices of all the goods in question, providing the players with the equipment list, the only part of this process they ever see.
All of the numbers are references in the 1952 Colliers Encyclopedia I use for this. My back posts explain why (I'm too lazy to link it here, it was only a couple of weeks ago).
The file is not complete. Nor will it be complete any time soon. Great Britain, the Low Countries, Iberia, most of Africa, Ocean and the entire New World has not been added (though there are a few random references from other entries I've read...such as a country saying it imports timber from America). This makes it difficult for someone to "steal" it and publish it for themselves. Obviously, I would be hiring a lawyer if that were to happen.
Enjoy
However, you will need Vista to see it. I had been working in XL, but I moved to Vista about a year ago and, after some months of trial and annoyance, in which I needed to go into the system and turn off every FUCKING automatic feature, I now find myself quite comfortable with it. Mostly, for the excel file in question, I'm not limited in my number of columns to about three hundred. I now have three thousand at my disposal...and instead of 64,000 crummy rows, I have more than a million.
So yes, I like Vista.
I would post a file readable by XL, but I can no longer duplicate the file into XL.
If you can see the file, you may notice that there are some blocks which are oddly colored for apparently no reason. These are notes to myself. This is only the first step of the next program, which is to take all the references noted on the Sources table and apply them to the "Prices" table. That is, the table which automatically generates the prices of all the goods in question, providing the players with the equipment list, the only part of this process they ever see.
All of the numbers are references in the 1952 Colliers Encyclopedia I use for this. My back posts explain why (I'm too lazy to link it here, it was only a couple of weeks ago).
The file is not complete. Nor will it be complete any time soon. Great Britain, the Low Countries, Iberia, most of Africa, Ocean and the entire New World has not been added (though there are a few random references from other entries I've read...such as a country saying it imports timber from America). This makes it difficult for someone to "steal" it and publish it for themselves. Obviously, I would be hiring a lawyer if that were to happen.
Enjoy
Saturday, July 12, 2008
Commodities List Part II
Well, I ought to finish this list.
Yes, I know, not the list you were hoping for. These are the main chemicals produced in actual reality, which were not invented in the 20th century…so obviously none of the polymer group is included.
Most campaigns wouldn’t allow black powder; I accept that it can be pretty useful and that it could spoil a campaign. The best use I think comes from putting the black powder into a small, tied bag, upon which is then cast a fire trap spell. The bag is then tossed into the middle of a group of humanoids, using an audible glamer, causing the bag to make a definite clinking sound. Money! The humanoids open the bag, setting off the fire trap, which sets off the black powder…boom!
Remember, anything that can be used by the party can also be used by the DM.
Strictly speaking, ivory is not stoneware…but it has more in common with that than anything else, so I include it with this group.
Massive section, and the most complicated. That is because iron ore is made into pig iron which is made into ironmongery which is made into tools which is made into armor (yes, I consider armor a tool). Each step modifies the price, so that the price of armor is based on the availability of toolmakers, who depend on the availability of blacksmiths producing ironmongery, which depends on the availability of smelted iron, which depends on the availability of ore.
Good thing most of that is common.
A similar pathway has to be followed for copper ore smelted into brass alloy, smithed and then made into tools and precision tools. But I will be going more into all of this later.
I decided to lump all the cereals together because, basically, most cultures just eat what is local. Later I did the same with fruits and vegetables. It’s true, one type might be worth more than another, but for the purposes of the game, it just made sense to assume that if the players were in Norway, the bread would be made of oats, and if they were in Ethiopia, it would be made of teff. This is especially true of fruits and vegetables, which do not transport well in a medieval setting.
You can argue about whether or not a particular fruit is tropical or temperate (orchard), but I don’t really care. You organize them however it suits you.
Some of these groupings may seem strange to you. That is because the FAO (Food and Agricultural Organization) does not include potatoes with “vegetables,” yet does include watermelons, which are clearly fruits. That is because the organization of fruits, nuts and vegetables is dependent on the manner in which the crops are grown, NOT in their biological classification. Since I am using FAO statistics for my production numbers, I have simply adopted their methods.
Pretty straightforward. The list above doesn’t quite include it all, but other creatures, such as griffons, oliphants and so on can be extrapolated from the above group.
And yes, I include “slaves” as “livestock.” I’m really not hung up on the fearfulness that some seem to have about the prospect of slavery and culture. It had been going on for 10,000 years and I think the prospect of having slaves is as relevant to fantasy as the prospect of owning a twenty foot high oliphant.
Like fruits and vegetables, I would assume the culture would eat whatever fish was local. Quite a number of those listed are extraordinarily local.
As I said, I don’t have to adhere to these groupings. I could break them down, work out a specific trading model for any one of them and add it to my system.
The problem with that is that my system is huge as it is, and I’m not anxious to make it more complicated.
The file which has all these references listed is an excel file with 14 pages. It’s 4.3 megabytes in size. So while I would love to send a copy to people who requested one, that might be difficult through email (but not impossible).
I don’t really care about the copyright on this. It’s useless without further development (adding in those parts of the world not yet added) and without the table that follows it.
I just can’t reproduce it here, except in a lot of sections. To give you an idea, I’ll take part of one table, the one that lists off the trading cities in the “organized” part of my world. Please note that I have done very little to edit these. I am reproducing them as they appear on my computer…some of the figures are in red or pink, indicating that these are not finalized numbers:










This looks like a lot of work, but it wasn’t put together in a weekend. It was built up over a period of about seven years, since 2001. I have completely reorganized it twice. I never want to have to do that again.
You may also see that it is impossible to define geographically some of these areas. Some are historical, such as Terra Scania, part of Denmark in 1650. But other parts, such as the first one on the list, Altslok, do not exist on Earth.
This is because I made a decision years ago that in any part of the world where humans numbered less than 1 person per square mile, that area would be occupied by non-human races: orcs, goblins, dwarves, elves, what have you. Since my population figures depend on the spread of human beings in 1650, that means vast areas of central Russia and Turkestan are occupied by non-humans, particularly Siberia.
Altslok, for example, corresponds to four earth-territories. The first is an area of Kazakhstan formerly called East Kazakhstan (which I call Croft). The others are three parts of Siberia: Gorno-Altaysk (Roth); Khakassia (Khath) and Tuva (Tuvath). Together these are arranged along the Altai Mountains, comprising a Dwarven Kingdom: a civilized, densely populated island of civilization amid orcs to the west, haruchai to the south and east, and hobgoblins and bugbears to the north.
I remember what these territories are and where they are because I have another huge table, called “Cities”…from which I extrapolate the population figures noted here. You’ll see that Altslok only has two primary markets: Croftshelm and Bokoth. The products of both Roth and Croft are together gathered at Croftshelm before they are traded outwards; because war cannot go on always, I have a world where orcs trade with dwarves—although tensions are necessarily a part of such arrangements. The limits in trade are indicated by the “1” which appears beside both Croftshelm and Bokoth.
Not like Archangel or Astrakhan, just below. Both relatively small populations, but profoundly important trading cities.
I could spend a long time just talking about the kingdoms…and I will, but not now.
Mostly I want to end this by pointing out that the table is extensive. This should provide some evidence of that.
Don’t hesitate to ask questions. I can’t remember to explain everything.
Alchemy:
Alkali: bitter salt, sal ammoniac, soda ash
Black powder: Greek fire, fireworks
Cosmetics
Dyestuffs: carbon black, catechu, henna, indigo, madder, murex, ocher, more
Medicinal plants and drugs: bromine, healing earth, iodine, nutgall, perilla seed, santonin, senna, tonic, more
Ink
Lamp oil
Lye
Perfume: attar of roses, civet, lotus, musk, more
Pitch
Poison
Paint
Soap (including borax)
Sulphur (refined)
Vitriol
Wood alcohol
Yes, I know, not the list you were hoping for. These are the main chemicals produced in actual reality, which were not invented in the 20th century…so obviously none of the polymer group is included.
Most campaigns wouldn’t allow black powder; I accept that it can be pretty useful and that it could spoil a campaign. The best use I think comes from putting the black powder into a small, tied bag, upon which is then cast a fire trap spell. The bag is then tossed into the middle of a group of humanoids, using an audible glamer, causing the bag to make a definite clinking sound. Money! The humanoids open the bag, setting off the fire trap, which sets off the black powder…boom!
Remember, anything that can be used by the party can also be used by the DM.
Building materials & stoneware
Bricks
Cement
Ceramics: earthenware, pottery
Enamelware
Faience & majolica
Glassware
Ivory carving
Jade carving
Lacquerware
Masonry
Porcelain
Quicklime
Sculpture & statuary
Tiles
Strictly speaking, ivory is not stoneware…but it has more in common with that than anything else, so I include it with this group.
Metalwork:
Smelting
Alloys
Brass
Pewter
Pig iron
Metalsmithing
Engraving
Minting
Jewelry (includes lapidary)
Brassware
Bronzewares: bells, cannon, statuary
Coppersmithing
Goldsmithing
Silversmithing
Precision tools
Ironmongery
Armor
Tools
Weapons
Leadsmithing
Pewterware
Tinsmithing
Massive section, and the most complicated. That is because iron ore is made into pig iron which is made into ironmongery which is made into tools which is made into armor (yes, I consider armor a tool). Each step modifies the price, so that the price of armor is based on the availability of toolmakers, who depend on the availability of blacksmiths producing ironmongery, which depends on the availability of smelted iron, which depends on the availability of ore.
Good thing most of that is common.
A similar pathway has to be followed for copper ore smelted into brass alloy, smithed and then made into tools and precision tools. But I will be going more into all of this later.
Crops:
Anise
Cacao
Cardamon
Cereals: barley, gram, maize, millet, oats, rice, rye, sorghum, teff, tucusso, wheat
Chamomile
Cinnamon
Cloves
Coffee: coffee, chicory, harari
Coriander
Cumin
Ginseng
Ginger
Groundnuts
Hops
Licorice
Nutmeg
Oilseed: cottonseed, linseed, mustard seed, poppyseed, safflower seed, sesame, sunflower seed, tamarind seed
Paprika
Pepper
Pulses: alfalfa, castor beans, chickpeas, clover, flowers, fodder, hay, lentils, peas (dry), soybeans, vetch
Saffron
Tumeric
Sugarcane
Tea
Tobacco
I decided to lump all the cereals together because, basically, most cultures just eat what is local. Later I did the same with fruits and vegetables. It’s true, one type might be worth more than another, but for the purposes of the game, it just made sense to assume that if the players were in Norway, the bread would be made of oats, and if they were in Ethiopia, it would be made of teff. This is especially true of fruits and vegetables, which do not transport well in a medieval setting.
Fruits & vegetables:
Citrus: citrons, grapefruit, lemons, limes, mandarin oranges, oranges, tangerines
Orchard fruits: apples, apricots, blackberries, cherries, currants, juniper berries, grapes, peaches, pears, plums, raspberries, strawberries, whortleberries
Tropical fruits: avocadoes, bananas, breadfruit, cantaloupes, dates, figs, guavas, loquats, mangoes, olives, papayas, pineapples, pomegranates
You can argue about whether or not a particular fruit is tropical or temperate (orchard), but I don’t really care. You organize them however it suits you.
Tubers: arrowroot, potatoes, sugarbeets, sweet potatoes, tapioca, taro root, yams
Vegetables: asparagus, beans, cabbages, cucumbers, eggplants, garlic, lichee nuts, lily roots, melons, mushrooms, onions, peas, peppers, radishes, rhubarb, tomatoes, turnips, watermelons
Treenuts: almonds, betel nuts, carobs, cashews, chestnuts, coconuts, filbert nuts, hazelnuts, palm nuts, pistachios, tung nuts, walnuts
Some of these groupings may seem strange to you. That is because the FAO (Food and Agricultural Organization) does not include potatoes with “vegetables,” yet does include watermelons, which are clearly fruits. That is because the organization of fruits, nuts and vegetables is dependent on the manner in which the crops are grown, NOT in their biological classification. Since I am using FAO statistics for my production numbers, I have simply adopted their methods.
Livestock & animal products:
Camels
Cattle: buffalo, cows, water buffalo, yaks
Dogs
Donkeys
Elephants
Fowl: chickens, fighting cocks, cormorants, ducks, geese, turkeys
Goats
Griffs (hippogriffs, that is)
Horses
Leopards
Mules
Rabbits
Reindeer
Sheep
Slaves
Swine
Bear paws
Bristles (from pigs)
Wax: candle & beeswax, vegetable tallow, ozocerite (which is a mineral, but fits here)
Honey
Horn
Ivory
Ostrich feathers
Sea Ivory (walrus, narwhal, whale tooth)
Tortoise shell
Pretty straightforward. The list above doesn’t quite include it all, but other creatures, such as griffons, oliphants and so on can be extrapolated from the above group.
And yes, I include “slaves” as “livestock.” I’m really not hung up on the fearfulness that some seem to have about the prospect of slavery and culture. It had been going on for 10,000 years and I think the prospect of having slaves is as relevant to fantasy as the prospect of owning a twenty foot high oliphant.
Fish:
This is a long list. It is as long as references I have found for each of these different creatures or products:
Fish: anchovies, barbel, bonito, bream, carp, catfish, cod, crabs, crayfish, cuttlefish, eels, flatfish, flounder, gudgeon, haddock, hake, halibut, herring, lamprey, lobster, lungen, mackerel, mullet, navagu, oyster, perch, pike, roach, salmon, salon, sardine, shark, sturgeon, tilapia, trout, tuna, vogla, whitefish
Fish fins
Seaweed
Sponges & sea slugs
Turtles
Like fruits and vegetables, I would assume the culture would eat whatever fish was local. Quite a number of those listed are extraordinarily local.
As I said, I don’t have to adhere to these groupings. I could break them down, work out a specific trading model for any one of them and add it to my system.
The problem with that is that my system is huge as it is, and I’m not anxious to make it more complicated.
The file which has all these references listed is an excel file with 14 pages. It’s 4.3 megabytes in size. So while I would love to send a copy to people who requested one, that might be difficult through email (but not impossible).
I don’t really care about the copyright on this. It’s useless without further development (adding in those parts of the world not yet added) and without the table that follows it.
I just can’t reproduce it here, except in a lot of sections. To give you an idea, I’ll take part of one table, the one that lists off the trading cities in the “organized” part of my world. Please note that I have done very little to edit these. I am reproducing them as they appear on my computer…some of the figures are in red or pink, indicating that these are not finalized numbers:










This looks like a lot of work, but it wasn’t put together in a weekend. It was built up over a period of about seven years, since 2001. I have completely reorganized it twice. I never want to have to do that again.
You may also see that it is impossible to define geographically some of these areas. Some are historical, such as Terra Scania, part of Denmark in 1650. But other parts, such as the first one on the list, Altslok, do not exist on Earth.
This is because I made a decision years ago that in any part of the world where humans numbered less than 1 person per square mile, that area would be occupied by non-human races: orcs, goblins, dwarves, elves, what have you. Since my population figures depend on the spread of human beings in 1650, that means vast areas of central Russia and Turkestan are occupied by non-humans, particularly Siberia.
Altslok, for example, corresponds to four earth-territories. The first is an area of Kazakhstan formerly called East Kazakhstan (which I call Croft). The others are three parts of Siberia: Gorno-Altaysk (Roth); Khakassia (Khath) and Tuva (Tuvath). Together these are arranged along the Altai Mountains, comprising a Dwarven Kingdom: a civilized, densely populated island of civilization amid orcs to the west, haruchai to the south and east, and hobgoblins and bugbears to the north.
I remember what these territories are and where they are because I have another huge table, called “Cities”…from which I extrapolate the population figures noted here. You’ll see that Altslok only has two primary markets: Croftshelm and Bokoth. The products of both Roth and Croft are together gathered at Croftshelm before they are traded outwards; because war cannot go on always, I have a world where orcs trade with dwarves—although tensions are necessarily a part of such arrangements. The limits in trade are indicated by the “1” which appears beside both Croftshelm and Bokoth.
Not like Archangel or Astrakhan, just below. Both relatively small populations, but profoundly important trading cities.
I could spend a long time just talking about the kingdoms…and I will, but not now.
Mostly I want to end this by pointing out that the table is extensive. This should provide some evidence of that.
Don’t hesitate to ask questions. I can’t remember to explain everything.
Thursday, June 26, 2008
Wide, Wide World
When I decided to create an economy for my world, I did not sit down with a real hot cup of coffee and scratch out some notes about which places would produce what: “Let’s see, France and Italy will have a lot of wine, Russia has some trees, India has indigo…” However long I could have gone at the system that way, it would never have been what I needed. I wanted a comprehensive system, something that would include virtually every product in use and its availability. More than that, it had to give a price for those products…a different price for each location where that object would be purchased.
This last, of course, was the major bitch in the project. If we establish a geographical location for the production of materials, it stands to reason that the distance from that geographical location is going to have something to do with the material cost.
Before I could get into that, I needed a source: a comprehensive tome that would list off the locations where objects were produced, so that an estimate could begin. Of course, there was no need for me to be arbitrary about it—the planet earth is filled with books about what is produced and where (part of the benefits of running a system on this planet)…but a consistent one, ah, there’s the rub.
I grew up with an encyclopedia that was purchased the year my parents were married, in 1958. It’s interesting that encyclopedias produced at that time were focused primarily on history and geography, unlike encyclopedias today that are focused on science and social science. I was lucky enough to happen upon a duplicate of that set, the Colliers Encyclopedia, printed in 1952. There are some fascinating idiosyncrasies about a set of facts volumes printed during the Korean War—when space travel was not conceived of, when Libya had no oil production, when Vietnam is still a part of the French colony of Indochina.
Most important to me, the encyclopedia has articles on literally thousands of geographical locations: cities, provinces, plateaus, vales, rivers, lakes, mountain ranges, seas, forests…and each article includes, as was standard at the time, a list of what that particular location produces economically.
Or, at least what it did in 1952.
The age of the book is its best feature—the closer to Renaissance period Europe, the better (my world operates in circa 1650). Of course, there are numerous listings for the production of automobiles, turbines, electrical cable, steel, uranium, radium and so on. For these things I read wagons, windmills, rope, pig iron, mithril and adamantium (the last two are a bit cute, but at least I’m not deciding where they’re found). I make other substitutions as needed.
Very often, the encyclopedias make more than one reference to a particular place in terms of its production of a particular item. For example, I have 7 references to the Island of Elba off the coast of Tuscany for its production of iron ore. As I make my way through the encyclopedia, I make note of each of these references; statistically, it is fair to argue that seven references would mean that a location produces seven times as much as another location, say Val d’Aosta, which has one reference.
Not always true, I know. But I dare anyone to find as complete a listing.
My “trade tables” as they are now, do not include most of Africa, any of the New World, or Western Europe. This has taken some time to accumulate the data. Altogether I have 19,400 references for areas stretching from the eastern half of Germany and Italy to Japan. More than 400 of those references are “iron ore”…so Elba’s seven have a relevance to the local area of Italy, but they would have very little effect on prices in Turkestan or China.
Because the encyclopedia is an independent source, the substance of those things produced vary widely. Some of the more obscure and profound references I have found, many of which I’ve been forced to look up, have included ozokerite, vogla (for which I could not find an English site), catechu, artyk (for which I could find no representative site at all, though it is a building stone used in Azerbaijan and Armenia), kumis, kenaf, asafoetida, perilla seed, brocade, teff, bear paws and sea slugs. These are things I would not have come up with on my own—even the spellchecker doesn’t recognize most of them. Altogether, there are more than 600 different products, which I group together into 279 commodities and services.
Why 279? Because these are what I have been able to find additional statistics for: specifically, production statistics. I began years ago with two books, the United Nations Industrial Statistics Yearbook (1988, earliest one I could find) and the Food and Agricultural Organization Yearbook (same year, for consistency). These two books provided me with a considerable volume of statistics…not as complete as I would have liked, but it was a considerable start.
The numbers, of course, did NOT correspond to 1650. Obviously we produce considerably more pig iron per population than was ever produced in 1650…and there are NO statistics for that period.
And this is the point when an assumption must be made? No, this is when more research is required.
I tore into every book on the Industrial Revolution and the economic development of Europe and the world that I could find, including quite a few very boring published theses. I have yet to find any clear figures…and for some time the numbers floated around as I compared data between what I was reading. I settled on a rough division of 500 between the late 1980s and the mid-17th century. That is, world production of anything would be approximately 1/500th of the present…adjusted individually for various products as evidence allowed. It has not been perfect—but as I pointed out yesterday, neither is the census. Doesn’t mean it lacks practicality.
It has made it possible for me to get a sense for the value of a product with my having as little arbitrary influence on that number as possible. I can, if questioned, “show” my work and challenge others to improve it.
Please…improve my work. I’m trying to do it myself, all the time.
That’s enough for now. I’m enjoying this, so I may post later today, and probably tomorrow.
This last, of course, was the major bitch in the project. If we establish a geographical location for the production of materials, it stands to reason that the distance from that geographical location is going to have something to do with the material cost.
Before I could get into that, I needed a source: a comprehensive tome that would list off the locations where objects were produced, so that an estimate could begin. Of course, there was no need for me to be arbitrary about it—the planet earth is filled with books about what is produced and where (part of the benefits of running a system on this planet)…but a consistent one, ah, there’s the rub.
I grew up with an encyclopedia that was purchased the year my parents were married, in 1958. It’s interesting that encyclopedias produced at that time were focused primarily on history and geography, unlike encyclopedias today that are focused on science and social science. I was lucky enough to happen upon a duplicate of that set, the Colliers Encyclopedia, printed in 1952. There are some fascinating idiosyncrasies about a set of facts volumes printed during the Korean War—when space travel was not conceived of, when Libya had no oil production, when Vietnam is still a part of the French colony of Indochina.
Most important to me, the encyclopedia has articles on literally thousands of geographical locations: cities, provinces, plateaus, vales, rivers, lakes, mountain ranges, seas, forests…and each article includes, as was standard at the time, a list of what that particular location produces economically.
Or, at least what it did in 1952.
The age of the book is its best feature—the closer to Renaissance period Europe, the better (my world operates in circa 1650). Of course, there are numerous listings for the production of automobiles, turbines, electrical cable, steel, uranium, radium and so on. For these things I read wagons, windmills, rope, pig iron, mithril and adamantium (the last two are a bit cute, but at least I’m not deciding where they’re found). I make other substitutions as needed.
Very often, the encyclopedias make more than one reference to a particular place in terms of its production of a particular item. For example, I have 7 references to the Island of Elba off the coast of Tuscany for its production of iron ore. As I make my way through the encyclopedia, I make note of each of these references; statistically, it is fair to argue that seven references would mean that a location produces seven times as much as another location, say Val d’Aosta, which has one reference.
Not always true, I know. But I dare anyone to find as complete a listing.
My “trade tables” as they are now, do not include most of Africa, any of the New World, or Western Europe. This has taken some time to accumulate the data. Altogether I have 19,400 references for areas stretching from the eastern half of Germany and Italy to Japan. More than 400 of those references are “iron ore”…so Elba’s seven have a relevance to the local area of Italy, but they would have very little effect on prices in Turkestan or China.
Because the encyclopedia is an independent source, the substance of those things produced vary widely. Some of the more obscure and profound references I have found, many of which I’ve been forced to look up, have included ozokerite, vogla (for which I could not find an English site), catechu, artyk (for which I could find no representative site at all, though it is a building stone used in Azerbaijan and Armenia), kumis, kenaf, asafoetida, perilla seed, brocade, teff, bear paws and sea slugs. These are things I would not have come up with on my own—even the spellchecker doesn’t recognize most of them. Altogether, there are more than 600 different products, which I group together into 279 commodities and services.
Why 279? Because these are what I have been able to find additional statistics for: specifically, production statistics. I began years ago with two books, the United Nations Industrial Statistics Yearbook (1988, earliest one I could find) and the Food and Agricultural Organization Yearbook (same year, for consistency). These two books provided me with a considerable volume of statistics…not as complete as I would have liked, but it was a considerable start.
The numbers, of course, did NOT correspond to 1650. Obviously we produce considerably more pig iron per population than was ever produced in 1650…and there are NO statistics for that period.
And this is the point when an assumption must be made? No, this is when more research is required.
I tore into every book on the Industrial Revolution and the economic development of Europe and the world that I could find, including quite a few very boring published theses. I have yet to find any clear figures…and for some time the numbers floated around as I compared data between what I was reading. I settled on a rough division of 500 between the late 1980s and the mid-17th century. That is, world production of anything would be approximately 1/500th of the present…adjusted individually for various products as evidence allowed. It has not been perfect—but as I pointed out yesterday, neither is the census. Doesn’t mean it lacks practicality.
It has made it possible for me to get a sense for the value of a product with my having as little arbitrary influence on that number as possible. I can, if questioned, “show” my work and challenge others to improve it.
Please…improve my work. I’m trying to do it myself, all the time.
That’s enough for now. I’m enjoying this, so I may post later today, and probably tomorrow.
Subscribe to:
Posts (Atom)

