Public Guild Spreadsheet


Pathfinder Online

1 to 50 of 57 << first < prev | 1 | 2 | next > last >>
Goblin Squad Member

5 people marked this as a favorite.

Just giving this a thread of its own:

There's a publicly shared Googledoc spreadsheet here with the guild numbers and stats as they were an hour ago.

Anyone is free to add their contact info to it. No guarantees I'll update the numbers, but anyone's welcome to try.

(edit) I've also added a column where you can put settlement name if you'd like to be known that way.

Goblin Squad Member

And someone has added an alignment field

Goblin Squad Member

'Twas I. Thought it might be handy, as this looks as if it could become a major comparison-shopping tool.

Goblin Squad Member

Thanks! Great tool.

Goblin Squad Member

1 person marked this as a favorite.

And this is one of the awesome things about the community.

Yay! Positive thread.

Goblin Squad Member

T7V Jazzlvraz wrote:
'Twas I. Thought it might be handy, as this looks as if it could become a major comparison-shopping tool.

It was, indeed, Handy. Thanks.


The contact field could be separated into PoC (Point-of-Contact: who you will be contacting) and MoC (Method-of-Contact: how you should contact them).

Theme is an important category to me; whether arcane/religious, casual/hardcore, aligned with one of the NPC factions, etc.

Since there are no guilds, it may be better to call it a 'Organizations' thread and add a column to designate whether they intend to be a nation, settlement, or CC.

In consideration of those organizations which intend to become nations, the settlement column could be changed to 'capitol'.

Adding an 'alliance/affiliates' column may not be amiss... though it could become quickly bloated and simultaneously outdated... or even underused as some alliances may be covert... *shrugs* Maybe make the data point for alliances the number of allies? #Allies.

Just some ideas; looks great! Thank you!

Goblin Squad Member

You do know it is currently May 30, not April 30, right? ;)

Goblin Squad Member

Fidelis Shane Gifford wrote:
You do know it is currently May 30, not April 30, right? ;)

I do, but am not 100% clear on the repercussions of changing the title of the publicly shared document.

(edit) apparently it's fine.

Goblin Squad Member

1 person marked this as a favorite.
Tertiary wrote:

The contact field could be separated into PoC (Point-of-Contact: who you will be contacting) and MoC (Method-of-Contact: how you should contact them).

Theme is an important category to me; whether arcane/religious, casual/hardcore, aligned with one of the NPC factions, etc.

Since there are no guilds, it may be better to call it a 'Organizations' thread and add a column to designate whether they intend to be a nation, settlement, or CC.

In consideration of those organizations which intend to become nations, the settlement column could be changed to 'capitol'.

Adding an 'alliance/affiliates' column may not be amiss... though it could become quickly bloated and simultaneously outdated... or even underused as some alliances may be covert... *shrugs* Maybe make the data point for alliances the number of allies? #Allies.

Just some ideas; looks great! Thank you!

It was pulled from the list of guilds on Goblinworks. Anyone can add columns and change what's there, you don't even have to log in. I expect that it will be completely irrelevant after the landrush, but if people want to put in their intentions around nation status, that's up to them.

Goblin Squad Member

Caldeathe Baequiannia wrote:
Fidelis Shane Gifford wrote:
You do know it is currently May 30, not April 30, right? ;)

I do, but am not 100% clear on the repercussions of changing the title of the publicly shared document.

(edit) apparently it's fine.

Ughh what the....I think I got pink eye when you changed the date. Not cool!!

Goblin Squad Member

<Magistry> Toombstone wrote:
Ughh what the....I think I got pink eye when you changed the date. Not cool!!

You are looking a bit pink today...

Goblin Squad Member

This is a good tool to have. Thanks, Caldeathe!

Fidelis information added.

Goblin Squad Member

I've added a "unconfirmed Members" column to the Google spreadsheet, so people can add what they believe the real numbers are, purely for informational purposes.

Please don't alter the number in the "Members" column to reflect anything that isn't in-play at Goblinworks.

Community editable (anonymously) List Here

Goblin Squad Member

Bump


Ozem's Vigil is a settlemnt, not a guild, but otherwise, great work. Keep it up.

Goblin Squad Member

It is a guild; guilds are the groups that are setting up the settlement, only relevant for the Land Rush. As Ozem's Vigil is the name of the settlement, and there isn't another name for the collection of groups setting up the settlement, it should be counted as the guild's name (as far as I understand, of course).

Goblin Squad Member

Loth'Xal wrote:
Ozem's Vigil is a settlemnt, not a guild, but otherwise, great work. Keep it up.

I took everything from the landrush pages on Friday around 5 EDT, and have changed little but numbers since. Either that's the way it is on GW, or someone else changed it. Anyone is welcome to modify it at any time.

(edit) I did add the (including Fidelis) after Ozem's vigil.


Caldeathe Baequiannia wrote:
Loth'Xal wrote:
Ozem's Vigil is a settlemnt, not a guild, but otherwise, great work. Keep it up.

I took everything from the landrush pages on Friday around 5 EDT, and have changed little but numbers since. Either that's the way it is on GW, or someone else changed it. Anyone is welcome to modify it at any time.

(edit) I did add the (including Fidelis) after Ozem's vigil.

Fair enough.

Goblin Squad Member

Far too late, but I've listed this in the Guild Information section of the Guild Recruitment & Helpful Links.

Goblin Squad Member

Nihimon wrote:
Far too late, but I've listed this in the Guild Information section of the Guild Recruitment & Helpful Links.

There's still 9 weeks to go, eh!

Scarab Sages Goblinworks Executive Founder

Would this be worth setting up on the Wiki instead of in a Google Doc? I can setup a sortable table there. That way the data can be sorted but while being edited it will always be in the same order.

Goblin Squad Member

Dakcenturi wrote:
Would this be worth setting up on the Wiki instead of in a Google Doc? I can setup a sortable table there. That way the data can be sorted but while being edited it will always be in the same order.

If people find it more useful elsewhere, that is a good thing. I only set up what I had access to.

Caldeathe
Acting administrator for Elkhaven and
Spiritual adviser to Erastil's Irregulars and the Family Morrigan.

Goblin Squad Member

1 person marked this as a favorite.

...and proud Canadian

Goblin Squad Member

@ Caldeathe

It is hard to keep up on all the threads recently but this is a great one.

Thanks Sir. :)

Goblin Squad Member

T7V Jazzlvraz wrote:
...and proud Canadian

it's hard not to be.....

Scarab Sages Goblinworks Executive Founder

I started a listing on the wiki with a sortable table. Continuing to work on it.

LINK

Goblin Squad Member

Dakcenturi wrote:

I started a listing on the wiki with a sortable table. Continuing to work on it.

LINK

It should be possible to mostly move the data over from the spreadsheet without manual entry, but I'm not sure it will prove as accessible as the Google doc, which can be edited by anyone at any time.

Scarab Sages Goblinworks Executive Founder

Anyone can edit the wiki once they have their account approved. The great thing about the wiki is that people can start getting on there and adding in content around other areas. As I noted in my post about PFOFan.com I am moving away from a custom wiki so that we can utilize the official pathfinder wiki as a repository of information. I figure this is relevant since these chartered companies are going to actually have a place in the game once it launches.

In either case, once I have everything updated I can also simply update the wiki once a week as needed. However, if you can spit out a formatted message from the excel data then I could easily add that instead. If this is an option shot me a PM and we can discuss as needed.

Goblin Squad Member

If I can get a look at the underlying text, I'll know pretty quick, but I'd be surprised if it won't work.

I applied for an account. when that is active I'll take a look at the text.

Scarab Sages Goblinworks Executive Founder

Here is the formatting and an formatted example:

!Guild Number
!Name
!Settlement Name
!Settlement Hex
!Alignment
!Motto
!Primary Timezone
!Website
|-
|2
|[[The Seventh Veil]]
|Phaeros
|LR1 +00+17
|True Neutral
|Creation. Destruction. Exploration. Contemplation. Magic. Nature. Mysteries.
|
|[[http://www.khaiognos.org/phpBB Link]]

Goblin Squad Member

Should be straightforward.

You've chosen to leave settlement hex as a single field? It makes it harder to group in areas.

Goblin Squad Member

Can it be edited in cell, or do they have to open the entire page and make changes?

Does it deal well with multiple editors? Typically there are 4-15 people looking at the spreadsheet at the same time, and they can each be modifying different cells.

If it's like a standard wiki, it might be better as a weekly or daily capture, so people can look and sort, but leave the editing for elsewhere?

Scarab Sages Goblinworks Executive Founder

Yeah I think that the weekly capture is probably the best route. You can have multiple people editing but (it has been awhile since I have been in this situation) I believe it tells you that someone else already edited the page and thus you can review their changes before posting yours. (I could be mistaken but that is how I think it works).

The editing does take place on the page level not the individual cell level. I figure spitting out the results of the excel sheet in the above mentioned format wouldn't be too difficult I am just not as much an excel guru as I am in other technical areas. :P

Goblin Squad Member

Just a heads-up. Phantasmagoria and its 6 votes have joined another top 33 "guild". Phantasmagoria has been disbanded in the leadership board and an official announcement will come soon.

Goblin Squad Member

Andros Morino wrote:
Just a heads-up. Phantasmagoria and its 6 votes have joined another top 33 "guild".

Excellent job of building suspense :)

Scarab Sages Goblinworks Executive Founder

I would like to request that a column on the spreadhseet be added for primary timezone so that people know where the majorit of members are and the timezone the group uses for a basis of meetings and the like.

I haven't updated the current version but if you would out a means to spit out the data in the proper format here is what the new format would look like:

!Guild Number
!Name
!Settlement Name
!Settlement Hex
!Settlement Column
!Settlement Row
!Alignment
!Motto
!Primary Timezone
!Website
|-
|2
|[[The Seventh Veil]]
|Phaeros
|LR1 +00+17
|+00
|+17
|True Neutral
|Creation. Destruction. Exploration. Contemplation. Magic. Nature. Mysteries.
|
|[[http://www.khaiognos.org/phpBB Link]]

Goblin Squad Member

Dakcenturi wrote:
I would like to request that a column on the spreadhseet be added for primary timezone so that people know where the majorit of members are and the timezone the group uses for a basis of meetings and the like.

I have done so.

Goblin Squad Member

Dakcenturi wrote:
I would like to request that a column on the spreadhseet be added for primary timezone so that people know where the majorit of members are and the timezone the group uses for a basis of meetings and the like.

Personally, I would prefer not to give the impression that T7V has a primary time zone. We already have players all over the world, and we want to continue attracting more of those players. I think that having a "primary timezone" would complicate that purpose, rather than facilitating it.

I think it makes a lot of sense for Companies to advertise a primary time zone, since those are the folks you'll actually be playing with when you log in.

Goblin Squad Member

Nihimon wrote:
Dakcenturi wrote:
I would like to request that a column on the spreadhseet be added for primary timezone so that people know where the majorit of members are and the timezone the group uses for a basis of meetings and the like.

Personally, I would prefer not to give the impression that T7V has a primary time zone. We already have players all over the world, and we want to continue attracting more of those players. I think that having a "primary timezone" would complicate that purpose, rather than facilitating it.

I think it makes a lot of sense for Companies to advertise a primary time zone, since those are the folks you'll actually be playing with when you log in.

I thought the same, Nihimon, but those with a wide variety can simply leave them blank.

Perhaps we can begin building a true crowd-forged, "Company" page on the same basis,.

Scarab Sages Goblinworks Executive Founder

Caldeathe Baequiannia wrote:
Nihimon wrote:
Dakcenturi wrote:
I would like to request that a column on the spreadhseet be added for primary timezone so that people know where the majorit of members are and the timezone the group uses for a basis of meetings and the like.

Personally, I would prefer not to give the impression that T7V has a primary time zone. We already have players all over the world, and we want to continue attracting more of those players. I think that having a "primary timezone" would complicate that purpose, rather than facilitating it.

I think it makes a lot of sense for Companies to advertise a primary time zone, since those are the folks you'll actually be playing with when you log in.

I thought the same, Nihimon, but those with a wide variety can simply leave them blank.

Perhaps we can begin building a true crowd-forged, "Company" page on the same basis,.

Well I think most of the guilds don't want to be limited to one timezone. However, I would assume that all guilds have a primary timezone that the majority of it's members exist in or that it's leadership generally holds meetings and events in. This is what I would expect to be in the primary timezone.

As Caldeathe noted though it is just as viable an option to leave it blank.

Liberty's Edge Goblin Squad Member

I added a 'Distance' tab with the formulas to calculate the distance between two input hexes, assuming either that you move from the center of each hex to the center of one of its adjacent hexes until reaching the destination OR assuming a straight line from the center of the start hex to the center of the destination hex. Note that if there are elevation changes en route you would need to calculate the distance from the start hex to the pass and then add that to the distance from the pass to the end hex.

Dunno if this is needed for the land rush spreadsheet, but there was some previous discussion about how to figure out the distance between settlements so this should help.

Goblin Squad Member

CBDunkerson wrote:

I added a 'Distance' tab with the formulas to calculate the distance between two input hexes, assuming either that you move from the center of each hex to the center of one of its adjacent hexes until reaching the destination OR assuming a straight line from the center of the start hex to the center of the destination hex. Note that if there are elevation changes en route you would need to calculate the distance from the start hex to the pass and then add that to the distance from the pass to the end hex.

Dunno if this is needed for the land rush spreadsheet, but there was some previous discussion about how to figure out the distance between settlements so this should help.

Nice! Thanks.

Scarab Sages Goblinworks Executive Founder

I added a column to the spreadsheet after the website and name columns to format it for a link in the wiki. I've also managed to utilize a converter to get this into a wiki format quicker then manually editing it.

So I will update this page on the wiki after each of the land rush votes based on the data captured in the spreadsheet here.

Link to the wiki page

Might be worth while to have guilds starting putting in their own information on the wiki (especially those that have settlements already) so that it can be an easy repository of information that is modifiable instead of static like the recruitment posts here. Additionally, it might be good to start tracking the history of these groups (specifically around settlements)

Goblin Squad Member

Ah! That's the one. I moved them to the end of the sheet, because they broke the scripted sorts.

Dark Archive Goblin Squad Member

Added guild website link.
And slogan.
Whether you like it or not!

Goblin Squad Member

Added 2 Guilds
145 Band of the Red Hand (Wheel of time based)
146 Crypt Builder's Union

No websites
No contact info

Goblin Squad Member

Greetings all!

I added a couple updates for Hammerfist Clan, such as our now official alignment as well as our motto. We currently have an open poll for our Settlement name; once that closes, I will update the document with that name. Thanks so much for getting this document going, Caldeathe!

Respectfully,

BD

Goblin Squad Member

<Hammerfist Clan> Blood Dragon wrote:

Greetings all!

I added a couple updates for Hammerfist Clan, such as our now official alignment as well as our motto. We currently have an open poll for our Settlement name; once that closes, I will update the document with that name. Thanks so much for getting this document going, Caldeathe!

Respectfully,

BD

Also, our settlement now has a name, and has been added to the spreadsheet. =)

Goblin Squad Member

<Hammerfist Clan> Blood Dragon wrote:
Also, our settlement now has a name, and has been added to the spreadsheet. =)

I like it :)

1 to 50 of 57 << first < prev | 1 | 2 | next > last >>
Community / Forums / Paizo / Licensed Products / Digital Games / Pathfinder Online / Public Guild Spreadsheet All Messageboards

Want to post a reply? Sign in.