Also, I think you made a mistake in breaking out the PBG characters, for example Huderu. PBG = 020, which you converted into P=2, B=0, G=0. I think you need to add zero padding for correct import. 
https://docs.google.com/spreadsheets/d/1hAOoxliGdlaWbJ4DTL3ICMFZH5OH18-ISFjw7HpNimE/edit#gid=1314013041&range=R206



-------- Original Message --------
On January 17, 2018 3:01 PM, Ethan Henry <xxxxxx@gmail.com> wrote:

Hello Travellers. Long time, no see.

So the other day I was curious about the distribution of a bunch of things in the official Imperial survey data so I pulled the raw data from travellermap.com, tweaked it a bit by hand and then pulled it into a google spreadsheet to do some analysis.

You can play with the sheet here: https://docs.google.com/spreadsheets/d/1hAOoxliGdlaWbJ4DTL3ICMFZH5OH18-ISFjw7HpNimE/edit?usp=sharing

Feel free to make a copy and tweak the pivot tables yourself if you like that sort of thing.

For example 93% of the population of the Marches is on the 42 pop 9 & A worlds. There are 397 other inhabited worlds that make up the remaining 7% of the population of the Marches. So there's a lot of concentration of population and a lot - A LOT - of empty space to hide if you want to.

92B of the 375B of the sophonts in the Marches live on a TL 8 or lower world. 50B live at TL 8. That's like 6.7 Earth's at today's TL.

There are 14 TL 5 Agricultural worlds. There's one extremely high-tech Ag world, Tenalphi, that's TL E, size 7 and has 60M inhabitants. It's a nearly Earth-like planet that basically only has New York state and California, or a country between the size of France & Italy. Quite possibly the population is distributed over the entire planet so it ends up being endless Kansas.

Anyway, if you also like spreadsheets, have a look.
-----
The Traveller Mailing List
Archives at http://archives.simplelists.com/tml
Report problems to xxxxxx@simplelists.com
To unsubscribe from this list please go to 
http://www.simplelists.com/confirm.php?u=0og3DHdoRHgL9lI7peOXYWnk6UF4c1zE