<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d11216437\x26blogName\x3dAggro+Me\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttp://aggrome.blogspot.com/search\x26blogLocale\x3den_US\x26v\x3d2\x26homepageUrl\x3dhttp://aggrome.blogspot.com/\x26vt\x3d2813804064508799754', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Monday, July 11, 2005

Math Makes my Head Hurt



A lot of people seem to be under some confusion about how exactly the guild patron system works so I did a spreadsheet for it. The first 9 rows are just a calculation of the guild status gained per writ, depending on how many patrons you have. I just plugged in 4,000 status per writ as an example.

If you want you can sign up for this site and then copy my spreadsheet and plug in your own numbers. It's free and I didn't see any ads. But, if you have a spreadsheet program, it might be simpler to just make your own. Just do the following:

For less than 12 patrons divide column B (status points) by 12.

For more than 12 divide column B by column A (number of patrons).

The result will be the status points added to your guild level for each writ (or heritage) you complete. Of course, you have to input the correct number of status points per writ. That way you can see, for example, how many writs you need to run each week to gain a certain amount of guild status points.

Now, let's get a little more complicated. Here's a common problem: Let's say you have a patron named Bob who quit EQII. Bob went to play Guild Wars, to go find himself in Bora Bora or whatever. But his status points are still there. On the other hand, you are carrying the weight of an extra patron, which reduces the status gained for each writ you complete.

So, what do you do? Cut Bob loose and lose the status or keep plugging away with less status per writ? Well, one solution would be to see how many status points you are away from Guild Level 30. Then you can do a calculation similar to the one I did in rows 11 to 16.

In my example, the absent patron was the 13th patron and had 50,000 status points. So, what I did was divide the remaining status points by the status received per writ with 13 patrons. That will give you the number of writs needed to get to 30. But what if you want to cut him? Well, then you first need to add the absent patron's status to the total status needed and divide by the status per writ with 12 patrons. You can see in my example that if you are 300,000 status points away it makes sense to keep him. If you are 700,000 status points away then cut him loose.

If I'm incorrect in my calculations please let me know - I'm really not that good at math.

I think the patron system does the job adequately but I also find it can be a fuse for a guild drama bomb. There are at least three possibilities for trouble: One, other patrons who get annoyed at an underperforming patron; Two, a patron who is sick of doing writs and gets frustrated; Three, people who feel left out because they are not patrons and want to contribute to the guild. It's a delicate situation for any guild leader.

On another topic, even if you read my Haiku humor post on Friday, there are now some reader contributions up so scroll on down!

5 Comments:

Anonymous Anonymous said...

just one remark: if u dont expect bob to come back u should cut him anyway because ull loose his status sooner or later anyway (as u can loose guild lvls ... my guild dinged lvl20 three times i think). and i kinda doubt that u cant loose lvl30 once uve dinged.

greetings
Logaras

5:07 AM  
Anonymous Scott Adams said...

Man did out guild wrestle with this issue! Lots of discussion and things tried.

We finally have patron guidelines in place that seem to work ok for us. You can see them at www.vindicators.net

8:26 AM  
Blogger Aggro Me said...

Logaras, you have a point but I guess the philosophy behind my example was to get to 30 by any means and worry about the consequences later.

Scott, I really like your patron guidelines - they seem reasonable and fair. Like you said it is really an issue guilds have to wrestle with. It was definitely the one issue we discussed the most.

10:23 AM  
Blogger supernoob said...

Can you say "Aggro has too much time on his hands?" LOL!

12:30 PM  
Blogger Ryan Shwayder said...

My opinion is that the patron system is good except for the fact that it causes so much dissent. They should really just remove status loss altogether, because it hurts more than it helps (not to mention, it doesn't make sense as far as progression goes in the rest of the game. See Adventuring or Tradeskilling).

11:14 PM  

Post a Comment

<< Home