A couple of weeks ago, I got the bug to play with making some more spreadsheets and charts. Kind of missed the big spreadsheet and charts from tracking zoo donation activity a few years ago and trying to stir up some shard rivalry!
I decided it might be interesting to keep track of the information on the official UO site that lists how many guilds each shard has and the number of veteran characters there are in the top 10 guilds on each shard. I thought I'd share the numbers I've gathered so far just to give folks something to mull over.
There's a set of Google spreadsheets for each shard and also a set that combines numbers for all shards. At the top right corner of each spreadsheet, you'll find a link that takes you to the Web page that is/was the source of the data in that spreadsheet. (In the "All Shards" set of sheets, however, the first two spreadsheets and their corresponding charts get their numbers from all the individual shard spreadsheets.) The "current data" spreadsheets get their data from the UO website and the "historical data" spreadsheets get their data from the Internet Archive's "Way Back Machine" website. Note that the historical data spreadsheets also include numbers of order and chaos guilds for the years that those types of guilds were allowed. Also listed are the number of warring guilds, up to a maximum of ten. I believe "veteran characters" are characters with total real skills of at least 700 that were logged in during the most recent 30 days, and I think the "number of guilds" reported only includes guilds that had at least one character logged in during the most recent 30 days. I'm not sure if that character had to have at least 700 real skill points or not, however, for the guild to be counted.
So, without further ado, below are the links to the Google spreadsheets. Have fun browsing the spreadsheets and charts. I've only typed in the historical data on some of the spreadsheets so far, but will slowly be adding it for the other ones as I get time. (The shards with an asterisk before the name have a spreadsheet and charts with historical info.) I'll try to keep adding the current information on a daily basis for as long as I'm able to and hopefully I won't miss too many days in the process. Keep in mind when you look at the historical data that there are many many gaps in the data. I could only type in what ended up being archived and in all cases no info seems to have been archived past August 2008.
Use the tabs at the bottom of a page to navigate between spreadsheets and charts. Holler if links don't work and I'll try to provide better ones.
*All Shards: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFN5TXJLVmQtNWNVZ3NvU1JRTWc3QVE&hl=en CURRENTLY LOCKED UNTIL I CAN FIX THE CHARTS! Sorry!
*Arirang: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdG5odm9lb3pkTU1yb0ZiSUQwcEhTZUE&hl=en
*Asuka: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdDZEOW4wVjIwQUdrZDUzZ2IxcG8zcnc&hl=en
*Atlantic: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFhWOVhQX0kxSjBEUlZyeERHVE9RT0E&hl=en
*Baja: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdElleXVPVmZIRFNHekNvWHdzMkZZT1E&hl=en
*Balhae: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEJxaXFha1FOc09YRVV0YlhEandHVFE&hl=en
*Catskills: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdHlNb3JEa3ZJNW4zYURNNjdPQzZlMlE&hl=en
*Chesapeake: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdHJGeVZTVHJlZXpESWowR1RhLUtBR1E&hl=en
*Drachenfels: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdDk1YmtmWTc0NWhzM0JibEZLc25FZVE&hl=en
*Europa: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdExqZkpucjdCempDR2k0bHR3TzNxaVE&hl=en
*Formosa: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFVTN2psbmhfMXBiSVhfbUtSd2lodkE&hl=en
*Great Lakes: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdHNkTmJEQUxMODU0VUZBMzRUOXJYTXc&hl=en
*Hokuto: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFo0dFl1aDRqdTZlQklIMnIxTDc4elE&hl=en
Izumo: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdGtKeUhjbWhSOHdhSE1FaHlfVXd6V3c&hl=en
Lake Austin: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEFiVUxrM1ViTXV4YWxLQVhCclJrckE&hl=en
*Lake Superior: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdGlwUDg3Y2s3LVpCbHMta0ZaaC10bVE&hl=en
Legends: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFo1WjczQUtSZ05NQ1cyUXFMOVhvWFE&hl=en
Mizuho: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEJxdWIwZ1JYbFJTd2NMcEt4WVl2ZlE&hl=en
Mugen: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdGZTTlljcm5aV0QzTjlTUUhQbVIxN1E&hl=en
Napa Valley: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdG9XZVROOHdIcFJzSTcwaEFmZTBYa3c&hl=en
Oceania: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdERjQ1ltMElxb1QwVWtNOUNYWTFZaEE&hl=en
Origin: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFoxNllsVFFNdm5fUE9WREEtQzBtdmc&hl=en
*Pacific: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFR1MWtkUGZlVW1jSVFrQXVnSFczQkE&hl=en
Sakura: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFFuM2hqR2Y3cUZVNFJONl9DRTcwSVE&hl=en
*Siege Perilous: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEFqcGxaZWNYazg4QzlTS0xWVEZObUE&hl=en
Sonoma: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdGhBVzRVb3VMVEpXVWhCODVKTW4teWc&hl=en
Wakoku: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFdRUzBXT1BHQXAzTXh0LVJWTmNNVUE&hl=en
Yamato: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEtpenpXMDJ2OVRXalFfUFFBQ2l1cEE&hl=en
Top 20 Guilds: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdDdyd2pVYjBqX0dhMUE3el8xTXJyRXc&hl=en
Historical Data: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdENWOWhTemd0TmdOS2ZoZng3SXpXUWc&hl=en
I decided it might be interesting to keep track of the information on the official UO site that lists how many guilds each shard has and the number of veteran characters there are in the top 10 guilds on each shard. I thought I'd share the numbers I've gathered so far just to give folks something to mull over.
There's a set of Google spreadsheets for each shard and also a set that combines numbers for all shards. At the top right corner of each spreadsheet, you'll find a link that takes you to the Web page that is/was the source of the data in that spreadsheet. (In the "All Shards" set of sheets, however, the first two spreadsheets and their corresponding charts get their numbers from all the individual shard spreadsheets.) The "current data" spreadsheets get their data from the UO website and the "historical data" spreadsheets get their data from the Internet Archive's "Way Back Machine" website. Note that the historical data spreadsheets also include numbers of order and chaos guilds for the years that those types of guilds were allowed. Also listed are the number of warring guilds, up to a maximum of ten. I believe "veteran characters" are characters with total real skills of at least 700 that were logged in during the most recent 30 days, and I think the "number of guilds" reported only includes guilds that had at least one character logged in during the most recent 30 days. I'm not sure if that character had to have at least 700 real skill points or not, however, for the guild to be counted.
So, without further ado, below are the links to the Google spreadsheets. Have fun browsing the spreadsheets and charts. I've only typed in the historical data on some of the spreadsheets so far, but will slowly be adding it for the other ones as I get time. (The shards with an asterisk before the name have a spreadsheet and charts with historical info.) I'll try to keep adding the current information on a daily basis for as long as I'm able to and hopefully I won't miss too many days in the process. Keep in mind when you look at the historical data that there are many many gaps in the data. I could only type in what ended up being archived and in all cases no info seems to have been archived past August 2008.
Use the tabs at the bottom of a page to navigate between spreadsheets and charts. Holler if links don't work and I'll try to provide better ones.
*All Shards: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFN5TXJLVmQtNWNVZ3NvU1JRTWc3QVE&hl=en CURRENTLY LOCKED UNTIL I CAN FIX THE CHARTS! Sorry!
*Arirang: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdG5odm9lb3pkTU1yb0ZiSUQwcEhTZUE&hl=en
*Asuka: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdDZEOW4wVjIwQUdrZDUzZ2IxcG8zcnc&hl=en
*Atlantic: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFhWOVhQX0kxSjBEUlZyeERHVE9RT0E&hl=en
*Baja: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdElleXVPVmZIRFNHekNvWHdzMkZZT1E&hl=en
*Balhae: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEJxaXFha1FOc09YRVV0YlhEandHVFE&hl=en
*Catskills: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdHlNb3JEa3ZJNW4zYURNNjdPQzZlMlE&hl=en
*Chesapeake: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdHJGeVZTVHJlZXpESWowR1RhLUtBR1E&hl=en
*Drachenfels: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdDk1YmtmWTc0NWhzM0JibEZLc25FZVE&hl=en
*Europa: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdExqZkpucjdCempDR2k0bHR3TzNxaVE&hl=en
*Formosa: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFVTN2psbmhfMXBiSVhfbUtSd2lodkE&hl=en
*Great Lakes: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdHNkTmJEQUxMODU0VUZBMzRUOXJYTXc&hl=en
*Hokuto: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFo0dFl1aDRqdTZlQklIMnIxTDc4elE&hl=en
Izumo: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdGtKeUhjbWhSOHdhSE1FaHlfVXd6V3c&hl=en
Lake Austin: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEFiVUxrM1ViTXV4YWxLQVhCclJrckE&hl=en
*Lake Superior: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdGlwUDg3Y2s3LVpCbHMta0ZaaC10bVE&hl=en
Legends: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFo1WjczQUtSZ05NQ1cyUXFMOVhvWFE&hl=en
Mizuho: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEJxdWIwZ1JYbFJTd2NMcEt4WVl2ZlE&hl=en
Mugen: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdGZTTlljcm5aV0QzTjlTUUhQbVIxN1E&hl=en
Napa Valley: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdG9XZVROOHdIcFJzSTcwaEFmZTBYa3c&hl=en
Oceania: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdERjQ1ltMElxb1QwVWtNOUNYWTFZaEE&hl=en
Origin: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFoxNllsVFFNdm5fUE9WREEtQzBtdmc&hl=en
*Pacific: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFR1MWtkUGZlVW1jSVFrQXVnSFczQkE&hl=en
Sakura: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFFuM2hqR2Y3cUZVNFJONl9DRTcwSVE&hl=en
*Siege Perilous: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEFqcGxaZWNYazg4QzlTS0xWVEZObUE&hl=en
Sonoma: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdGhBVzRVb3VMVEpXVWhCODVKTW4teWc&hl=en
Wakoku: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdFdRUzBXT1BHQXAzTXh0LVJWTmNNVUE&hl=en
Yamato: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdEtpenpXMDJ2OVRXalFfUFFBQ2l1cEE&hl=en
Top 20 Guilds: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdDdyd2pVYjBqX0dhMUE3el8xTXJyRXc&hl=en
Historical Data: https://spreadsheets.google.com/ccc?key=0Aj2lpjetLFwwdENWOWhTemd0TmdOS2ZoZng3SXpXUWc&hl=en