8 replies to this topic

[Tritous]

Hello all,

I've developed a simple tool in excel to make it easier to track the efforts made by your clan.  Input their contributions and names, input your clan totals and targets, input your choice of thresholds.  The output is a table of contributions; members categorised by contributions, the totals calculated for each group, and formatted nicely for a bbs forum

I will be using this tool for my clan, I'm sure other leaders will find this useful for keeping track of theirs.

Citadel Contribution Calculator v11.09.21.xltx

I'm sure the forum admins will have to add a disclaimer that they are not responsible for 3rd party tools.  It is free from macros (I'm just good with formulae), excel 2007/2010 compatible, and simple to use

If someone can test with 2003 i'd be grateful.  There are no advanced features, but 2003 has a lower limit on max number of cells used.  


Instructions:
Fill in current clan progress and your targets (optional) at the top
Fill in how much each member of your clan has done (including those who have done none).
Fill in target thresholds at the top (optional).

The output page has a grey box.  select this, copy, and paste it to the text editor or forum of your choice.  The format is designed for bbs forums

Sorry for the lack of instructions in the tool, I did make it for myself originally


Enjoy

[Sy_Accursed]

Pro-tip:

If its excel just put it on google docs.
Known website, download not required, allows you to make tweaks and refine it and users always are using latest version.

[Tritous]

hah, forgot that thing existed.  

Do you know if google doc accepts tempates?

[Sy_Accursed]

I believe any standard excel format can be imported to google docs

[Tritous]

perhaps not, maybe it's just that it's too big (600kb), but google seems to not be able to convert it even after 15 minutes.  it isn't the most simple of spreadsheets.  It doesnt accept templates at all, so all that happens is it becomes a file host (although not a bad one).  Cheers anyway

[Tritous]

new version up.  one bugfix, and made it compatible with autofilter now so you can more easily find things

[Tritous]

v11.09.21 up.  Changes mainly around making it easier to put in a whole list of members and just adding in values for those who have reported their contribution (improvement in how it handles the "none" category)

[aklegend]

can you please re upload this file?

[Quyneax]

Please don't bump one-year-old topics unless you have something to add to the discussion. PM the creator of the thread if you want the file after so much time - the discussion here has ended for a reason. Thank you.