Suicide Kings Excel Spreadsheet App

Suicide Kings is a list system offering an alternative to /roll and DKP systems that unfairly favor those who can make every raid and can easily be manipulated to push out the talented, but time contrained, members of your guild.

I built this spreadsheet in MS Excel as a proof of concept for a mod I have in mind and the type of interface I'd like to build, but I'm feeling like just keeping it Excel is probably easier.

Tell me what you all think.

~T~

-------------------------------------------------------------------------------------------------

Link to Download the Spreadsheet - WARNING! Requires you to allow macros to run - be careful that you only download the file from the Profit guild website.

Here is the link to the topic discussing this particular variation of Suicide Kings - It's a combination of Suicide Kings and Loot Council.

YouTube.com Video explaining the basics of how the spreadsheet is setup

Sample BBC Code Output of Raid Drops List

---------------------------------------------------------------------------
THE FOLLOWING IS A POST ON OUR FORUMS WITH
OUTPUT FROM THE SPREADSHEET
----------------------------------------------------------------------------

Suicide Kings Style Loot List for 25-mans -updated after each raid

The Issue: Need to track who's receiving loot and spread the drops around.

The Solution: Use a Suicide Kings style system and track it here on this list (updated live during raids).

Here's the spreadsheet we use to track loot (Excel 2003 or later):
http://profit.guildlaunch.com/guild/library/32245/SKList.xls - REMEMBER to Record Attendance and Refresh the Pivot Tables before using them

**NOTE: you MUST set your Security to Medium in the Tools > Options window and choose the Enable Macros button when loading this spreadsheet.

http://www.youtube.com/watch?v=pPkjO6L4D3I

Rules:

1) Top person in Loot Code list suicides or pass the item to the next on the list (tanks and healers get gear first).

2) Winner drops to the bottom of list under the last member in attendance. Others get bumped up the list Suicide Kings style - absent members hold existing spots.

3) Info next to someone's name indicates how many upgrades received on 25-man raids and the last number indicates number of raids attended.

4) Masterlooter/officers always reserve the right to determine if certain members can or cannot suicide items with special low drop rate, highly desirable items.

5) Masterlooter/officers always reserve the right on rare occasions to DEFAULT an item to someone in a raid and/or not suicide the person to the bottom of the class list for various reasons, such as current or future role in raids, class or spec preference related to an item, or being the only raid member who can use an item that is a marginal or miniscule upgrade. The purpose of this is to not see items get DE'd simply because an individual would pass them up to stay at the top of the list and wait for a much better upgrade.

6) **NEW**: If the Raid Leader has requested that you switch to an alt during a raid, your main character will be counted in the SK list as if it were in attendance and move up the list accordingly.

Loot Codes
T - Tank - Druid(Feral), Warrior(Prot), Paladin(Prot)
H - Healer - Priest(Holy), Druid(Resto), Shaman(Resto), Paladin(Holy)
C - DPS Caster *1 - Mage, Warlock, Priest(Shadow), Druid(Moonkin), Shaman(Elem.)
M - DPS Melee *2 - Warrior(Arms,Fury), Rogue
Y - DPS Hybrid *3 - Hunter, Paladin(Ret), Shaman(Enh.)

*1 items classifed as DPS Caster can be passed to Healers, if they can use, but preference is given to DPS Caster
*2 items classified as DPS Melee can be passed to DPS Hybrid, if they can use, but preference is given to DPS Melee
*3 items classifed as DPS Hybrid almost always favor Hunters over melee casters

1.0.0.2 =
- 1 suicide
- 0 trash loot
- 0 epic mats (nether vortex, heart of darkness, etc.)
- 2 raids attended since 3/10

YOU WILL NOT APPEAR ON THIS LIST UNTIL YOU HAVE ATTENDED A RAID

1 C (Pri) Sasilas 0.0.0.2
2 C (Sha) Lawngdawng 0.1.0.7
3 C (Pri) Dulce (shadow) 0.0.0.2
4 Y (Hun) Sigimli 1.1.0.4
5 C (Mag) Debauchrey 2.0.0.8
6 C (Pri) Tepal 0.0.0.7
7 T (War) Nasha 0.2.0.4
8 T (War) Elfs 1.0.0.1
9 Y (Hun) Durrthock 1.0.0.10
10 H (Pri) Dulce (holy) 0.1.0.8
11 H (Dru) Energetic 1.0.0.2
12 H (Pri) Elfss 1.0.0.1
13 H (Pri) Iceshadow 0.1.0.1
14 C (Loc) Lillandra 1.0.0.2
15 M (Rog) Varice 2.3.0.6
16 H (Pal) Dregin (holy) 2.0.0.4
17 Y (Sha) Lumines 2.4.0.6
18 H (Pri) Althalus 0.0.0.1
19 T (Dru) Annibus 2.0.0.1
20 C (Pri) Succubus 0.0.0.2
21 C (Loc) Erador 2.0.0.2
22 H (Pri) Chelese 3.0.0.10
23 M (Rog) Strongherth 0.0.0.1
24 H (Sha) Navare 1.3.0.9
25 C (Sha) Ntldrxp 2.0.0.3
26 Y (Sha) Geist 0.0.0.5
27 C (Mag) Shariandar 0.0.0.1
28 Y (Hun) Lilalust 4.0.0.2
29 H (Pal) Norrin 0.0.0.3
30 H (Pri) Thalia 2.1.0.6
31 C (Mag) Arapmoi 0.0.0.3
32 H (Pal) Alions 1.1.0.2
33 Y (Hun) Geto 0.0.0.4
34 C (Mag) Drae 1.1.0.5
35 H (Pri) Phatso 0.0.0.2
36 H (Pri) Jaqauy 0.0.0.1
37 H (Pal) Maidean 0.0.0.1
38 H (Dru) Yellania 2.0.0.1
39 C (Sha) Thundos (elem) 3.2.0.10
40 H (Dru) Mundrood 0.0.0.1
41 T (Pal) Dregin (prot) 1.3.0.6
42 C (Mag) Frostboy 2.0.0.1
43 C (Mag) Arterr 0.0.0.2
44 H (Sha) Blueguy 1.2.0.5
45 C (Loc) Bemorra 2.0.0.6
46 T (Dru) Shifthappenz 3.0.0.6
47 H (Pal) Ujin (holy) 2.1.0.7
48 C (Mag) Gegy 0.0.0.2
49 H (Dru) Rezurection 3.0.0.10
50 H (Pri) Pegil 0.0.0.1
51 T (Dru) Fenriz 0.0.0.1
52 T (War) Ibuliwyfi 0.0.0.1
53 C (Mag) Slickster 1.1.0.6
54 C (Loc) Caramela 0.0.0.1
55 Y (Hun) Cantgetright 0.0.0.1
56 M (War) Michaelson 0.0.0.1
57 H (Dru) Yggdrasil 0.0.0.2
58 C (Mag) Macha 1.0.0.1
59 C (Loc) Murdertrain 0.0.0.2
60 T (Pal) Smashemup 0.0.0.2
61 C (Loc) Chukknorris 2.0.0.3
62 T (War) Thrilldwarf 2.5.0.8
63 C (Loc) Firedahl 1.0.0.2
64 T (War) Shez 2.1.0.9
65 H (Pal) Ghanum 1.0.0.1
66 M (War) Blikefire 2.1.0.6