Tuesday, October 25, 2011

Ah, India

And don't it look weird:

A Land of Silly Putty

The bizarre appearance is, as ever, the distortion of flattening the northern hemisphere into a hex disc, caused by strange things like shortening the circumference from pi to 3 times the diameter.  It also helps to remember that the direction North is somewhere at the top left of the above, and not the centre top, which is typical of maps.

All I care about is that it is a standardized reckoning within my world in every capacity, in playability, in representation, in comparison to other regions world-wide, and of course my trade table.

Getting this done feels like a tremendous weight off me.  I actually started India about three years ago, then stopped to do other regions, leaving it half done.  That proved to be a mistake.  I changed certain aspects of my mapping in 2009, and since that happened I practically had to do all that I had done before one more time.  So for me, this is a map done with one and a half times the work shown.  Feels good to have that all finished and sorted out at last.  There's still the Maldives and Laccadive islands to do, and the Andaman & Nicobar Islands too, but they wouldn't look good on the blog anyway - they're too small.

The map shown is a collection of 14 separate sections that I've been working on a couple of months now (which is why some labels appear twice, and why there's a pink glitch in the middle of Nepal ... colored on one map and not on the other - has to be fixed).  Some of these, as they were previously, can be found on the Wiki, linked on the right hand side.

The strange twist on the right is the 90th parallel, that forces the map to 'turn the corner,' as I have described elsewhere on this blog.  It was unfortunate that the turn went right through the middle of the the Bengal delta of the Ganges from the left and the Brahmaputra, which swings out of Tibet (where it hasn't been drawn in) at the top of the map and then down into India.  That too makes the map look weird.  This is the first large area I've done that's this close to the equator.  I begin to wonder how this will make Indonesia look.

Well, the map speaks for everything else, so I'll shut up.

A Note To My Readers

Yes, it's true.  Since last week it seems that this blog has been all about the subscription and the data I'm providing off line, and I don't doubt there's a little unhappiness about that.  But the gentle reader must admit, if people have given me a sum of money, I am somewhat beholden towards servicing the needs of those people, at least as far as my responsibilities demand.  And if there hasn't been more general information here in a week, well, I could just as easily have not posted at all, right?  Quite a lot of blogs take a week or a month off, and I haven't done anything like that.

But I would like to reassure my loyal readers that I am here and I haven't made any plans to stop blogging about all the things I typically blog about.  I came within a hair's breath of finishing India last night, with plans to publish it today ... but the Ganges-Brahmaputra delta proved more daunting than I expected and at 11:00 PM last night I knocked off.  I don't know if I can finish today, but I'll post the whole map of the area this week.

I'm up to writing a post about Gunpowder for my civ IV technology posts, and I meant to write something general about the online campaign - which is also content I'm adding to the Internet daily, I hasten to add.  I also have plans for one other thing ... if I dare do it.  So all I can say is please be patient, don't lose faith, the blog and my interest in communicating about D&D to the general readership has not been compromised.

I can't help wanting to share everything, however, and if people are willing to pay for the gritty in depth stuff, who am I not to take advantage of that?  I've been working hard at this hobby for more than 30 years, and I don't know any craftsperson anywhere who doesn't start to think eventually that it might be worth putting a few things on a table at a flea market.

Finally, one special note to the happy, wonderful people at YDIS who eagerly anticipate my being diagnosed with cancer.  A hooker will charge you $100 to fuck you.  I would be happy to offer the same service.

Prices Template - Part C - Raw Material Cost

The 'Raw Material Cost' tab is the crux of the table, and indeed the crux of the whole trade system.  These is the practical calculations I've been holding back all this time.  As you can see, there are a lot of them.  As I said before, they've been built up one by one over time, until you have what you see here.

in each case, the references from the previous table are used as a ratio to calculate the price of various items, usually per ounce or sometimes per specific object.  Furs, for instance, are calculated per pelt, animals per head, gems per cubic centimeter and so on.  Much of this table uses other parts of this table in order to calculate the total price of things - probably the best example of this is the cow.

If you go to lines 922 and 923, you can see the price of a cow or a calf outlined.  The price of the cow is based upon the basic cost per head (determined on the reference table), then augmented by the cost to feed the cow for a two year period, whereupon it will be at the height of its meat, leather and milk production ... though it may be kept for a longer period.  A calf, you will notice, is fed for only three months, and that is why a calf costs less.

The price of the forage for the cow can be found on line 782, this price being based upon the total 'cereals' shown on the reference table, which is used in calculating the cost of 'preparing' the base cost of general cereals.  You will note there is also a 'inkeeper feed' cost, which is calculated by the number of market references in this particular market city.

The price of milk is then hinged on the price of the cow, and how much milk it is predicted it will produce in a year (all production figures for the reference table are annual, which determines all prices throughout the system).  You can find raw milk costs on line 208, along with the cost of cream & kumiss, butter & ghee, and ordinary cheese.  Other cheeses of course are calculated against these prices.

The price of cowhide can be found on line 370, as opposed to horsehide or sheepskin and so on, which are all determined by the price of those animals as opposed to cows.  The cost of salt is added (from line 591), then the cost of tanning the hide, plus the size of the hide and its cost per ounce.  This is then used to give the cost of cowhide leather craft, found on line 388.  That line shows the cost of leather armor there, along with the costs of gloves, hats and boots, which are considered more expensive to produce than leathercraft.

If you want, you can have your leathercraft embroidered, which would mean my creating a calculation for it using the reference for embroidery found on the 'References' tab, line 493.  You could have it embossed (again, I'd have to make the calculation, but that's actually quite easy), from 'References' line 492 ('artworks').  You could also have it sewn with gems ('References', line 809, 'lapidary') or fitted with fur ('References', line 361).  It is really all up to you, and the prices are all worked out according to the general system.  Obviously, once I create a new calculation for a specific thing, I leave it in the system.

If you want the cost of cow meat, you can find it on the 'Raw Material Cost' tab on line 252.  'On the hoof' means the price paid to the rancher who brings in a live cow.  The 'Stockyard' price is what you pay if you buy the cow unslaughtered.  The 'Abattoir' price is what you pay for a side of slaughtered cow that hasn't been cut into steaks for you.  The 'Butcher' price is the cost for cut up and ready to cook.  'Inn Fare' is the additional cost the inn charges you.  'Smokehouse' is the cost of drying or smoking ready meat.  Sausage is the cost for the meat in that way, where as Pates are more expensive still.  Pates de foie gras is the cost of goose liver pates (which has its own cost track, naturally) made in that particular manner.

So you can see that everything is hinged together.  The number of stockyard references determines the mark-up on cows, the slaughtering references determines the mark-up at the abattoir, and so on and so forth, so that each stage has a specific price and each price is logical for the place and condition for which the meat is sold.  And every part of the table works exactly the same way.

Thus if you think of a combination of things that doesn't at this point exist, you can follow the process of mixing those things together to get the appropriate, logical price.

Now, there is another calculation here that might seem a little unreasonable, but you'll have to believe me that it works.  Part of the problem, as I said yesterday, is not having proper figures for a lot of specific items.  Fruits, for instance, the same thing as yesterday.  I have references for fruits, but I don't have total production for every kind of fruit, not even from the U.N., which tends to skip some items in their annual report or simply mixes them together.

I used to solve this by having a 'fruit' price on the table and telling players it was whatever was local.  But then I reasoned I could assess a price for fruits (or other things) on the number of references I had for that particular fruit measured against all other fruits.  If I then used a log calculation to work out a ratio, I could keep the difference in price from getting out of hand, and get specific prices for specific varieties of things ... like fruits, or cereals, or vegetables or kinds of stone or what have you.

Thus you can see on lines 839 to 871 that each type of fruit has a ratio, and that this ratio is multiplied against the general price for all fruits (line 831).  This gives me a price for things as obscure as whortleberries or citrons, for which I had no world-wide production statistics.

The rest of this is pretty much just familiarizing yourself with the massive number of calculations on this page (there are about 2,200 of them), determining the raw price on a wide variety of goods and services.  I am probably better off answering questions here than attempting to guess what things need to be deciphered.  Good luck!

Prices Template - Part B - Spells

Working out the price of spells was tricky business.  What was needed to fit the system was a level of supply, which could be determined by the number of clerics who had a given spell (or ability to use a spell), which then denoted a 'production' of that spell.  In order to determine the number of clerics of given levels, I turned to my own demographic efforts - a table which, for the present, isn't in the accessed folder but which I shall endeavor to locate before the weekend.  You can read something about those demographics, and the explanation of Adherents, Zealots and so on, here.

It follows that certain statuses of cleric have certain levels, and that higher level (and more able) clerics are less accessible to the general public.  It is easier to see a local priest than the clerics dwelling in the monastical order, or those in the service of an archbishop.  Thus, it's easier to get a first level spell from a poor friar (adherent) than a crusader (adventurer) or a cardinal (title holder).  This table is meant to reflect that.  Of course, a friar won't have 5th level spells at all - if you want a 5th level spell cast, you will need to see someone more important.  You'll also note that 7th level spells aren't available ... they are just too rare, given the population of clerics among even 2 million people ... so if your party can't get there to be raised, don't count on resurrection as an alternative.

The second half of the table defines the number of 'references' for clerics based upon the total number of 'market' references for that particular market zone.  Thus an area like Germany has more markets that are close to each other, and thus a greater likelihood that prices will be reduced on things like cast spells.  A place like Astrakhan should be expensive.

You will also note that I've added a feature where you may have to wait to obtain the spells you want.  You can read about this here.

I trust you can work out the remainder from the excel spreadsheet.  Obviously, any questions you have I'd be happy to answer.

Monday, October 24, 2011

Prices Template - Part A - References

Now, all the previous work I've been describing since yesterday exists in order to drive this table.  It all comes down to the data you've inserted on the 'Input Data' tab, which is then converted into prices and availability.

Let me first say that this file is a mathematical disaster.  Not only is it indecently complicated, but it represents several incarnations of data creation, each of which vary in some degree and each of which - I am sorry to say - tends to leave some bit of calculation that manages to survive into the next incarnation.  So it goes.  I do my best to update things when I see them, but the reality is that there's more here than I have time to update, or care to take the time, and in any event it can wait for the next time to come along that I make this file even MORE complicated.  The subscriber will please observe that this table was created one patient entry at a time, starting about 2006, and has experienced now six overhauls since its original creation - one which I started and did not finish just this summer.  At this point I don't even want to look at this table to finish that overhaul until after I can add Italy, India and the Low Countries to the Selected table.

So, things are unfortunately messy, but if you are patient you can pull them apart and probably make my life unhappy by bickering or identifying errors, things that don't seem to make much sense and outright unreasonable assumptions that are found there.

Here is the original problem.  The first efforts were based upon the production numbers I had available from the United Nations International Statistics Yearbook and from the United Nations Food & Agriculture Organization's Agricultural Yearbook.  Between the two, I could get an idea of the production of cereals, fruits, vegetables, oils, treenuts, crops, fish, livestock, metals & alloys, materials, chemicals, textiles, woods, foodstuffs and mining in the world at the time of the yearbooks.  This was then modified in a rather ad hoc fashion to reflect the world in the 17th century, in a completely inaccurate way that really doesn't matter anyway, this is Dungeons and Dragons, and not my doctoral thesis for Harvard.  Ultimately, all I really cared about from the beginning was getting kind of close.  Since first mucking about with these statistics in depth (researching beginning around the year 2000), I feel justified in believing that I am close enough, and a damn sight better than some other perfectionist could probably manage.  Where there seem to be irrational gaps in the prices template, you can believe the gaps probably exist there because there were insurmountable gaps in my research ... or possibly the later research hasn't yet caught some glitch from an earlier incarnation.

Am I getting across yet that there are many reasons why something might look illogical?  Sorry, but as it is the only way I can tell the reason for a bit of illogic is by trying to remember why I did it a particular way four years ago ... and in my old age my memory is going.  Usually the best thing anyway is to just try and fix it the best way it can be fixed.

With all that out of the way, let's start by looking at the 'References' tab.

This tab simultaneously groups and breaks down the raw data into convenient bits that can be addressed and reworked in the 'Raw Material Cost' tab.  At one time this was supposed to give me a base price for everything ... now it is only supposed to give me a base price for commodities that don't experience any premier industrial development.  However, there are things that still remain that are semi-industrial - like artworks and embroidery.  Eventually the pricing for these things will be moved forward, but for the time being they can remain as priced on this page.

An explanation for the calculations on this page can be found, as ever, about three quarters of the way through this really useful post.  The number of references for the specific market are divided by the number of total references and then multiplied by gold references to get their innate value, then adjusted for distance (the percentages in column K) and ultimately assigned a base "cost."  Adamantite, for instance (the mineral and not the metal), has a base price of 98.36 copper pieces (column M, the coin not specified).  All prices, except on the 'Market Page' tab, are specified throughout the table in copper pieces, then translated for convenience for the player.

The columns that refer to 'Second Tier References' is a development meant to compensate for the lack of proper reliable information.  To see a complicated example of this working, see lines 967 through 1016 - FRUITS.  From the encyclopedia I have references for sources producing 'fruits,' 'citrus fruits,' 'berries,' 'orchard fruits,' and of course a wide variety of particular fruits such as apples, apricots, oranges, grapefruits, raspberries, dates, figs, loquats, juniper berries, tangerines, guavas, pomegranates, olives, grapes, currants and so on.  Obviously it doesn't work to have separate prices for 'fruits' and for 'tangerines,' so we must presume that references for fruits are distributed into whatever the local fruit of the area is ... and the local fruit is in turn also determined by the inputed data from the Selected table.

Thus, the 'Second Tier References' is the redistribution of more generalized references (citrus, fruit, berries) into more specific references (bananas, breadfruit, limes), according to the availability of these fruits.  If the market is in a part of the world where there are more bananas than apples, the distribution of 'fruit' references will reflect that.  If you understand excel, you can see how the numbers are thus redistributed.

Other places where this was necessary include tubers, metallurgy (where 'founding' could refer to any metal and not just iron), distilling and 'building stone' ... which could really be anything.  A few places did not need this redistribution because of the way the table uses the data.  'Cereals,' for instance, could be applied to the general cost to fodder for animals, and because of this did not need to be sorted into its particular kind of grain ... the larger, cheaper price could be applied to groats and such to define it from grains which were specific and therefore eaten by people.  Whenever I could generate a separate price that provided a unique item, I did this.  It added depth to the general availability for the players.

Because the 'world value in oz. gold' column (column H) is determined by the number of gold references divided into the total number of ounces gold, when I rework this table to include new information from Africa, Spain/Portugal and England (from a reference I made on the encyclopedia post) there will be a dramatic change in many prices throughout the system.  I admit that I don't know if it means the prices will rise or fall ... because there are so many changes that will come from the bulk Italy/India/Low Countries regions being separated out as well.  In any case, prices will adjust and I expect the players will too.

For the moment I'll stop here, and pick up the next tab, 'Spells,' on the following post.  I know that for subscribers this is a huge amount of information to take in all at once; but I am bringing you up to speed on a world that has been in a state of creation for 27 years.  I began running 'Earth' in 1984.  I've had a lot of time to think about these things and steadily bring them forward.  You've had two days to see what's here.  It will take time to understand what exactly you're looking at in the general picture.  And once I get past the trade tables, much of the rest is quite simple.

Selected Table

Moving on.  The Selected table refers to selecting the data which determines prices for a market city.  The City distances and the Source table totals are put together here to come up with the distribution for the desired market city.

The first tab, called 'Selection,' determines the shortest distance to market zones that have more than one market city.  For example, you can see that the Archangel zone (zones listed across the top) has two markets in it, "Archangel" and "Sudborough."  Now I must admit this table is a hang-over from before I discovered the MIN function in excel, and I haven't updated this since last year.  Again, I will update it after working out the market city distances, which should be after Christmas.

In the meantime, if a given city - Astrakhan, say - is closer to Sudborough than to Archangel, than the Sudborough distance is used for determining distribution out of that zone.  It's really pretty simple, so I'll move on.

The 'Market Provinces' tab, then, shows the distances that will be used.  Take note that distances are shown on this table to Africa, America and so on - these are average distances to these places, which serves somewhat to smooth out the results for the present, until these areas are properly divided out.  If a city is equi-distant to everything in China, then the distinctness is lost.  There's nothing I can really do about this - until I can map China, it is either consider it all one portion, or discount it from the table altogether.  Neither is very desireable.  I could subdivide China now, but that's a lot of trouble and I suppose I feel I need to save work where I can.

Note also that Italy is still listed as a single unit on this table.  The upgraded version will divide Italy ... and probably the Low Countries and India also, since I can get those separated and made ready for this table through December.

Very well.  As an experiment, lets get ready to highlight a line and copy it.  I'll highlight Astrakhan, line 5, so you can follow along with me.  Don't highlight the whole line, just the numbers between column C and column ND.  At present, that's 351 zones.  There will be many more when the new zones are added.

Move to the next table, 'Input Distance.'  Paste the data as a 'VALUE' ... but the only thing that will happen if you paste normally is that the highlighting will change.

You can look over this sheet but there is nothing you need do.  You can see that the Sources table data has been copied here, and that the products are listed down the side.  If you move to the 'Collect Index' tab, the distances that you have entered from Astrakhan have been divided into the Sources data, and that collected in a series of numbers running down column B next to the products in column A.  If you've done it right, you should see a population of 2,152,088.1 and a Total References of 404.5.

At this point you will want to open the Prices Template table.  On that table you will see that the first tab reads 'Input Data.'  (ignore the gobbledy gook on the 'Jewellery' tab ... that's just leftover from when I was trying to solve this problem.

You will see on the Input Data table a similar list to the one on the Selected table.  They line up perfectly, so all you need do is copy the data from the 'Collect Index' on the Selected (column B, lines 4 to 907) and paste them AS VALUES to the 'Input Data' page on the Prices Template.  Get it lined up, or you'll have problems.

There you go, you have just created all the prices for everything for the market of Astrakhan.  It takes less than 30 seconds to create a price list for any city - you just copy and paste twice.  This is the goal for all the work I do otherwise.

A bit more here and then I'll move on to the Prices Table next.  And that will be a long, long post (or possibly two or three).

You'll note two tabs marked 'Birth Process' and 'Sheet2.'  This is a half-done effort I have put down for the time being that determines the birth location for a new character depending on what market zone the character is generated in (you've just learned how to change the data for a market zone).  I've been sort of juggling the numbers, not being happy with them, so I've left off making this table properly.  but you can see from 'Sheet2' a list of zones and what dominant race of humanoid controls that zone.  Thus, it is unlikely that a human character will be from a zone where the population is made up of gnolls.  You can wander through the other bits of tables there - it should be evident what I was trying to do.  Eventually I'll get around to fixing all this and making it pretty, but for the time being it isn't a priority.

Sunday, October 23, 2011

Market Cities New Start Table

I was going to start the New Selected table, as I said, but I have to write about the Market Cities table a bit first.  You will note that it says "New Start" ... that is because I'm keeping all the old data for a little while until I'm sure this new system works.  It seems to, but one can never tell.  When I feel confident, I'll change the title to Market Distances, a name that at the moment is being used by the old file.

Before going into it, you will probably have found that you are getting a 'circular reference' warning when you open the file.  There's nothing wrong here - the file is fine.  But you will have to go into your computer and tell it to stop resolving circular issues.  I admit, I'm not sure this can be done on everyone's excel; I use Vista, which I am not sorry to say I love, however others feel about it.  I can tell you how to fix the problem in Vista.  In other formats you're on your own.

The way you do it is to open the Office Button and select Excel Options at the bottom of the pop-up.  Once there, click on 'Formulas,' second from the top on the left.  Then, on the top right of the pop-up for changing formula options, you'll see a button for 'Enable iterative calculation.'  Click it.  Then change the 100 in the box below to 1, and change the 0.001 to 0.  There, you're all set.  No more circular arguments.

However, be warned about randomly messing with this table.  The formulas are interactively sensitive, so if you type the wrong thing on the page you'll get error messages which will cascade everywhere and ruin the data.  At the moment, testing it, I can't seem to think of a way to make it do that (I removed formulas to make it more streamlined, so it might be immune now).

You'll note that if you hit the function key F9, the numbers will change.  This is because there ARE circular functions, but they can't cascade back and forth and crash the files because the iteration has been set to 1.  Each time you refresh, the numbers calculate.  There's a lot of calculation here, so it can take a long time for them to stabilize.  I made some changes last week so they haven't stabilized since that change ... but they will eventually.  It usually takes about five or six minutes of hitting the button.  This is much less time than the manual calculations I used to have to do.  But recently my life got a whole lot easier, and I'm very happy about that.

This table is still in the process of being reformatted; that is why there are only about one fifth of the total cities included.  I'll be getting the rest up in the next few weeks.

The lines in orange are the accurate distance between the cities, selecting the shortest route.  The others are calculations, as the post I linked talks about.  These numbers are used for the Selected table, so I needed to talk about them here.

If you want to mess with this and get the numbers to stabilize, do.  Then change one distance, making it lower, and watch them restabilize.  It's fun.

Someone who's a programmer could probably do this easier than on excel, but I asked for that two and a half years ago and got no comments back.  There are times I hate programmers.

But the guys who invented excel deserve deification.

Sources Table

Because of the size of this table, I used to have it chopped into parts ... but that has become inconvenient and now I just keep it in one piece.  It's 21 megs, big for an excel file, so if your computer is slow you're going to have trouble with this one.  What's really annoying is that it is all empty space.  This format is easiest however for the whole thing, as it can be filtered and compared most easily.

Along the top are 954 possible products and services, and down the side are the various locations for references identified by the aforegoing Encyclopedia folder.  Thus, if you scan down to lines 20 through 26, describing the Archangel "zone" (as I call it), and column AHW ("fish") you can see the Encyclopedia makes one reference to Onega Lake having fish, one reference to "Sudborough" having fish, and three references to the White Sea having fish.

Now, I'd better explain about the names you'll find here.  There is no 'Sudborough' anywhere near Archangel that you'll find on a map or an encyclopedia.  In mixing my world and the D&D world together, certain weird aspects get applied to names of some regions.  Modern Archangelsk, for instance, in actual history was founded as Archangel in 1584 by English traders in a big empty land on the south shore of the White Sea.  In my D&D world, Archangel was founded in 1584 by English traders who stumbled across a small area of winter halflings who had successfully retrenched a region surrounded by gnoll-infested forests.  The English joined with the halflings and the region still battles off gnoll raiders.  The city of 'Sudborough' is a halfling town which in the real, modern world is called "Onega."  So where it says in the encylopedia that Onega produces fish, I write down on this Sources table that Sudborough produces fish.

There are quite a lot of examples of this.  The first two zones, Croft and Khath under ALTSLOK, are four modern oblasts in 1952 Russia: East Kazakhstan (Croft), Gorno-Altay (Roth), Khakass (Khath) and Tuva (Tuvath).  Because in the real world the human population was so low, I filled these regions up with dwarves, being that they are mostly the Altai-Tuva mountain ranges separating modern Siberia from Mongolia.  Croftshelm, Rithdome, Rothering and Bokoth are towns.  Moth Basin is a river valley in modern Khakass.

All of these equivalents are found on the Cities file, in mapmaking, if you want to look and compare.  I'll be getting to a description of the Cities by and by.

For the moment, take note that the KINGDOMS are in capital letters, while the name of the trade zone is in bold, highlighted more darkly to distinguish it.  Totals for the zone are gathered from the individual locations for references (thus the Archangel zone has 5 references for fish, 1 reference for cod and 2 references for herring).  There is a column then for total fish (AJR, darker than the other fish columns), which shows Archangel as having 8 fish references.

So goes the whole table.  Various groups of things are added together for later application in the system, such as grains, pulses, fruits, medicinal plants, woodcrafting, skins, meat and so on.  This is done partly to compensate for having only a certain number of things for which I have adequate production figures, letting me estimate the base amount of said product or group of products being produced in 1650.  There will be more about this, later.

Sorry, I'm jumping around a bit.  Going back to the far left of the table, column D, 'TOTAL REF.', the subscriber can see there are totals for each location.  It would be nice to think that these totals could be used to determine the economy of a specific locale, but this isn't so.  The data simply isn't precise enough for that.  It is good enough (because there is so much of it) for me to apply the later system of distances and availability to get a good set of trading tables ... but this source table is really completely unreliable as hard data.  You can muck with it if you want and try to pound it into that, but I suspect you will be disappointed in the grand picture.  Still, some places do produce a lot of different types of things, and some are much more heterogeneous in products, and something might be gleaned from that.

As you can see, there are a LOT of different places that sources come from.  The sources listed here are in two forms.  Those where the place names have been sorted out into 'zones,' and a second group where they haven't been.  Starting on line 2768, you can see Africa is listed all as one big body (not including Egypt), along with America, China, East Indies, England, France, Greenland, India, Ireland, Japan, Portugal/Spain and Southeast Asia.  These are places where I have gathered the references, so I know those totals, but I have yet to map these areas and thus distribute the sources into their market zones.

You'll note there are references for America and for the East Indies, but that I had said in the Encyclopedia post that I hadn't done those areas yet.  Still, entries in the encyclopedia for European, African and other areas make a general reference here and there to the Americas (especially a long article about gemstones in the book), and those references were duly recorded here.

So what makes a 'zone'?  To begin with, it must have a market city.  Column F shows the number of encyclopedia references to a city being a 'port,' a 'trading centre,' a 'market' or a 'commercial' hub ... and these are all interpreted as 'market.'  Search Hamburg and you'll find 15 references in the markets column.  Bremen in turn came out a 14.  London came in at 12, Barcelona and Lubeck managed 11 and both Shanghai and Constantinople amounted to 10.  I didn't decide how many these places had ... this was the encyclopedia referring to their trading statuses over and over.

You can search out other places in the old world for their totals.

I drew the line at dividing up secondary territories into tinier and tinier zones, so some zones have more than one trading city in them - such as Cuxhaven and Hamburg both being in the Hamburg zone, or a region like Transylvania having six markets: Grosswarden, Hermannstadt, Klausenburg, Kronstadt, Neumarkt and Sathmar.  Those are their 17th century German names.  Klausenburg is modern Cluj, Kronstadt is modern Brasov and so on.  I try to keep the 17th century name for use, but sometimes the actual name is the one shown on the table - I simply haven't gotten around to fixing it.

So, a zone is a secondary region with however many market cities there are, one that has at least one trading city (this is as much because I have stats for population for that region as anything else).  What about a region without a market city?  I then assign that region to a nearby market, one that seems most logical.  Thus, at the very top in the zone of Croft, the region of Roth has no trading city, and is then assigned to Croft.

These zones are the outsource for the trading tables that determine the price of everything.  The subscriber can see that the 'Totals' tab on the table shows only the totals for the various zones, and not the lesser locations within those zones.  It also shows the total number of references for each product:  2,903 market references, 70 tin, 19 raisins, 24 tapestries and so on and on ... 14,879 references in total.

One thing, however,  This table has been updated since it was used to create the next table, called NEW Selected, which I will be talking about soon.  I like to refer to these things as 'incarnations.'  The Incarnation of the pricing table is dependent on the latest updating of the Selected table, which is dependent upon the latest Incarnation of the Sources, Cities and Market Cities (distances) tables, which are in turn dependent upon work done before those tables can be updated.

Thus, if I record from the encyclopedia into the Sources table, and update it, we can assume that the pricing table is now out of date ... until the next time I fix the Selected table based on the new sources I've found.  THEN I can update the prices table.

At the present, I've most recently added much of Africa and Spain to the sources table, but I have yet to upgrade the prices to accept them.  This is typical ... I don't like to update every time there's a change, so I wait until there are a lot of new sources, and then work up through the tables to get them all up to date.  Right now, I am thinking I might get the pricing table up to date sometime after Christmas.  I'll have holiday time to really work in December.

Oh, I was going to say that you can see I've started to sort India into zones.  This is because I'm nearly finished mapping India, and I was interested in seeing - initially - how it would go.  I actually get a kick from this, wondering where the largest numbers of references will come down, even if it isn't hardcore economics data.

Encyclopedia Folder

Might just as well start at the simplest, least interesting thing.  Let me just say I had a bad copy of the folder up the first time - an older version.  The newer version is now in the files, so be sure you're looking at what I uploaded later.  You can tell because Ireland is in the completed files.

Having grown up with a particular encyclopedia my parents possessed, the date of which goes back to 1952, and having been familiar in my youth with all things geography in a really big way, I had long before stumbled across lists of products produced in certain areas at certain times.  If you take a look in the 'Complete Entries' folder, and past that into 'Completed Regions' (there are no other regions at the moment, with completed describing what has been put into the sources table, which we'll get to next), you'll find a long list of the regions I've researched for 'references', as according to the system I described back here.  This is merely the raw data for those references.

Back in the 1990's, when I started recording this information in order to be sure that it was complete, I did not have the internet.  For earlier, failed incarnations of trade tables, going back to the late 80s, I'd just copied the material straight out of the encyclopedias ... but I was always losing pages and I couldn't easily check something that should have been in an area, so in '97 I started writing everything out, straight copying the material out of the encyclopedia.  It made sense, because if I needed to search something other than trade, the data was digital.

This became less and less necessary as the net, and particularly wikipedia, got thorough and reliable.  Finally I started just writing out the products themselves ... though most of the files have a few entries at the beginning when I was copying everything that was relative to 1650 (no later history copied).

Some of it is flotsam and jetsam, a note here or there of something that should have been copied on some other file, but is still a file of its own ('Alba Iulia' for instance).  True to my word, I'm providing the rough data, so I'm not bothering to fancy up the material any more than I need it to be fancied.  I have no real reason to waste time fixing the few bits here and there, I can search them all anyway and they can be just as they are.

You can see an example of me writing everything in the Russia files, and me writing just the products in the France files.  It's been an ongoing project all this past 14 years now.  When I haven't got anything else to do, I just work on more of this.

Going to the top of the 'Encyclopedia' folder, what's there are things I haven't copied out yet (in complete, anyway): Canada, America, the East Indies ... all short, partial files.  The places to be researched - everywhere that has a geographical entry in the encyclopedia - can be found in the 'Working Index,' just a long list of names.  Teal and some brown for Canada/United States, Pink for Latin America and Green for the East Indies and Oceania.  There used to be lists like this for Asia, Europe and Africa, but those have been researched, item by item.

Subscriber's Introduction

This is general information for the subscribers who have come onboard with my proposal.  You now have access to half a gig of materials which I've built and which have accumulated over the years.  This does not represent everything that I've done, or everything that I plan to put forward, but for the time being its a lot to poke through.  I'm going to be describing the tables in a series of posts that can be read here.  If you have questions, please address them here so that I can build up a popular FAQ for the future.  Obviously, if you have anything personal, you can still email me at alexiss1@telus.net ... but I'd be just as happy to answer general questions out in the open.

I'd like to say that virtually all of this material is in some state of flux, which me making changes on a non-regular basis.  I tend to work at something until either I dry up on it and need a break for awhile, or until a moment of inspiration hits me on some other project and I go rushing off in that direction.  I will try to outline what's missing, what's half done, and what I hope to do in the future ... and then as I update tables there should be some evidence of my working on those things.

Some of this material is dry, dull data that may not look very interesting.  I've included it so that it can be seen how A becomes B and is turned into C ... like the showing the math work example I gave in a comment a couple of days ago.  I've included my general information for both the maps and the trade tables; at present all the maps ... including many vegetation maps which are not online ... are up to date as of yesterday.  I am nearly finished India.  I only have the Bengal delta of the Ganges and Brahmaputra to do.

Dropbox seems to work excellently ... so WickedMurph, if you're out there somewhere, I'll give you a 20% discount on a subscription for being enormously helpful in this.  It is appreciated.

I'm sure something else will occur to me, but right now I'm going to get started on table descriptions.

Friday, October 21, 2011

A Generated Weather Table

Yes, for a few days I'll probably harp on the proposal I've made this week ... but in the meantime I'm still working on the weather tables.  I'm fairly happy at the moment with temperature, precipitation and wind speed ... I'll be wanting to work on wind direction, probably, and unusual events occurring during storms next.

At the moment, however, the below table is generated from inputing the average low, the average high and the number of days per month with precipitation.  These are very easy statistics to gather, easy to create yourself for your own campaign, and easy to steal from a part of the world you're having your campaign occur.  True, at the moment they are detailed for temperate and arctic weather conditions - deserts and tropical jungles will need changes to be made, based on Koppen's Climate Classification system ... but one thing at a time.

Here is the table, generated for weather in Cuxhaven, where my offline party is, for August.  Observers will note that the party has already experienced those conditions shown for the 15th.  I can generate the rest of this at a click, so these are probably NOT the conditions the party will experience when they actaully wake up on the 16th.


Rainfall times occur at some point during the period indicated, which can be divided into 6 hour periods for convenience - though not necessarily.  A day's typical low occurs just before sun rise, and the high usually mid-afternoon, points in the day that are typically only 9 hours apart.  But since those float, a DM is justified in working the details out as desired.

Obviously, this is only going to get more and more complicated the more features I add to it over time.  And I should add that this table is meant to be fitted seamlessly with the wilderness damage effects table which I have spoken about from time to time.  Development never ends.

Thursday, October 20, 2011

Putting It Right Out There

Seems to me that there is little reason to wait.  If subscribers would like to jump on board with the offer made in the previous post, I will have time to start delivering material to you in some form this Sunday, October 23 - understanding that the data will be delivered in exactly the format and state that it exists at present on my computer.  I'm not going to spend time cleaning up things, though I will post upon each file so that the subscriber can understand what they're looking at and how it is applied.  I don't want to spend my life answering questions about how to use excel/publisher or how excel/publisher works, but I will explain how I've used it and what the various things are meant to accomplish and even how they might be altered by the subscriber for their own purpose.

Donations can be delivered to me using the "Donate" button on the right; please remember to calculate the surcharge for paypal.  If you want to pay me by some other means, you'll have to contact me through alexiss1@telus.net and work that out with me.

For those who don't know, and who may or may not be having trust issues, my name is Alexis Smolensk.  To the best of my knowledge most of the google references on the web do in fact refer to me, including my IMDb listing.  I hope not to encourage any stalkers, but you never know.

I am offering a piece of me for sale.  I am completely sincere.  I do not believe that anyone who has an interest in granular game design will be disappointed.