PDA

View Full Version : Skill List Spreadsheet


Knigh7s
May 30, 2005, 07:52 AM
THE ORIGINAL
GW Ultimate Checklist v2a l Last Update: 03-28-07

This was origanally made for just myself. But I went ahead and posted it online to share with the Guild War Community. Dont know if it will be of any use to anyone. I just compiled it from any and every source I could find online. So hopefully everything is correct and nothing is missing.

Downloads:
The Original GW Ultimate Checklist - Excel Version(removed for v2b - coming end of April '07)

Features:

Catagorized Skills List
Highlighted Elite Skills
Runes List
Weapon Modifier List
PRINTABLE SKILLS LIST - Separate *.zip file
PRINTABLE RUNES LIST - Separate *.zip file


Requirements:
OpenOffice - NO LONGER SUPPORTED FOR ITS LIMITATIONS
Excel 97/2000/XP

File Type:
*.zip

Publisher:
Knigh7s (ingame: Fall N Angel, Kuragari Tenchi)

Known Issues:
Don’t Know of any yet.

Working On:
Printable Skills Lists
||||||||||||||||||||
Printable Runes List
||||||||||||||||||||
Printable Weapon Mods List
||||||||||||||||||||
Redoing the Runes List
||||||||||||||||||||

MAJOR UPDATE COMING
- GUI update
- new features

Credits:
Draken
Guild Wars Guru
GW Online

History:

version 2a
Completely redone from scratch
Private release

version 1.5
Factions Skills Added
Printable Factions Elite Skills List

version 1.4
Printable Skills List in PDF format
Printable Elite Skills List in PDF format

version 1.3
Printable Skills List

version 1.2
Runes List
Wepon Mods List

version 1.0
Prophecy character skills
Elite skills



Check out my Guild Wars How-to and FAQs (http://www.guildwarsguru.com/forum/showthread.php?t=25802) thread.
Guild Wars Guides and Tip 'n Tricks (http://knigh7s.net/gw)

Feel free to post any SUGGESTIONS, ERRORS or UPDATES for the list, and if you would like to contribute.

Knigh7s
Jun 03, 2005, 05:55 AM
Update now Available.

Draken
Jun 07, 2005, 04:00 AM
mmm nice work. you might think about adding runes and mabye if you feel its handy enough weapon components (http://www.guildwarsguru.com/forum/showpost.php?p=118484&postcount=28). so i can keep track of everything i have to unlock!

Knigh7s
Jun 08, 2005, 06:48 AM
mmm nice work. you might think about adding runes and mabye if you feel its handy enough weapon components (http://www.guildwarsguru.com/forum/showpost.php?p=118484&postcount=28). so i can keep track of everything i have to unlock!
Thank you! I'll look for some Runes resources and info, and i'll start adding the Weapon Components tonight. Got any Suggestions on organizing the WC system? Like should I add the attributes for each item or just leave it Item specific only??

Viruzzz
Jun 08, 2005, 10:29 AM
i'm sure other people will find it usefull. but personally i don't really like it. the black bars aren't pretty. i really don't like looking at them. no offense meant or anything, just leaving my impression

Knigh7s
Jun 09, 2005, 06:41 AM
i'm sure other people will find it usefull. but personally i don't really like it. the black bars aren't pretty. i really don't like looking at them. no offense meant or anything, just leaving my impression
Ya, I wasnt liking the black bars also. I changed it to just blank space. Hope it looks better. I was mainly working on content not looks yet.

New Update not uploaded yet. still working on the rune and weapon components lists

Knigh7s
Jun 12, 2005, 05:33 PM
I'm Working on Elite Skill Location Page
Runes List and Weapon Components coming soon

Knigh7s
Jun 18, 2005, 09:00 PM
Runes List and Weapon Components has been added. Enjoy!

Draken
Jun 18, 2005, 10:34 PM
thanks, but do i have to register to download?

Knigh7s
Jun 19, 2005, 06:49 AM
thanks, but do i have to register to download?

Fixed. direct d/l now.

Draken
Jun 19, 2005, 02:01 PM
missing divine boon for monks

Knigh7s
Jun 20, 2005, 01:56 AM
Thank you. Uploaded and fixed

Ollj
Jun 25, 2005, 02:12 AM
Not all replies read, not having most actual version, following errors found:

Mind Burn (E) is an elite
Fire Attunement (E) is no Elite
Ether Prodigy (E) is an elite
Glyph of Energy (E) is an Elite
Mind Burn (E) is an elite
Echo (Me) is an elite
Ether Renewal (Me) is missing (and is an elite)
Leech signet (Me) is missing (no elite)
Contemplation of Purity (Mo) is missing (AND is an Elite)
Divine Boon (Mo) is missing (no elite)
Source Healing (Mo) is missing (no elite)
Scourge Sacrifice (Mo) is Missing (no elite)
Shielding Hands (Mo) is missing (no elite)
Aura of the Lich (N) is elite
Barbed Signet (N) is missing (no elite)
Enfeeble (N) is missing (no elite) [ != enfeebling blood]
Rigor Mortis (N) is missing (no elite)
Soul Feast (N) is missing (no elite)
Maiming Strike (R) is missing (no elite)
Ferocious Strike (R) is missing (no elite)
Spike Trap (R) is elite

Pelias
Jun 25, 2005, 06:01 AM
Could you make it printable on A4 format?

=HT=Ingram
Jun 25, 2005, 06:26 AM
Could you make it printable on A4 format?

try this one out...

Skills List.pdf (http://66.135.185.60/forums/index.php?act=Attach&type=post&id=73582)

Knigh7s
Jun 25, 2005, 07:54 AM
Working on updates right now. i just havnt put up the latest version yet. been so busy with work and the wild fires here in Vegas burning my eyes! so not to much comp time atm.

Ollj, Thanks for the updates :D, But alot of all that is on my list already. just a couple was missing.(was this meant for my post)

Pelias, Working on that. thx

forever
Jun 30, 2005, 01:44 PM
Found a minor error in your spreadsheet.

You put Ether Renewal in your Mesmer skills, should be deleted.

Great work. Thanks for sharing.

Barkam
Jun 30, 2005, 09:36 PM
Thanks for compiling this for us and sharing it to the community. The updates are very beneficial also. Thanks again.

Julia Darkheart
Jul 05, 2005, 01:04 PM
Hmmm... Still getting a deadlink on the top d/l link. Is it me or is there a problem?

Knigh7s
Jul 05, 2005, 01:10 PM
Hmmm... Still getting a deadlink on the top d/l link. Is it me or is there a problem?

Fixed, you caught me while I was updating the upload! hehe

Now Available:

Printable Skills List w/Elite skills, All skills on ONE(1) page.

Pelias
Jul 06, 2005, 09:48 AM
I love you.

Knigh7s
Jul 06, 2005, 11:36 AM
I love you.

Aww Thank You! :p

JoDiamonds
Jul 06, 2005, 01:01 PM
woot, excellent. good stuff.

Knigh7s
Jul 06, 2005, 04:25 PM
printable RUNE LIST now Available!!

Saba The Hobo
Jul 07, 2005, 08:14 PM
Great stuff ;) .



I love you.

Snuk the Great
Jul 23, 2005, 05:26 PM
Still has a litle flaw in it. It is missing Major Inspiration Magic Rune. And I realy do can buy it :P.

Ah and this list here also shows min and max for the upgrades, maybe get it in here too (and give some credit to Paladin_Adoni too :))
http://www.guildwarsguru.com/forum/showthread.php?t=25712

Knigh7s
Jul 27, 2005, 09:46 PM
Update yet again.

Twidget
Aug 01, 2005, 11:24 AM
I have 3 words for you...

:) :) YOU ARE AWESOME!!! :) :)

Thanks so very much for this, it is exactly what I was looking for.

n0tsane
Aug 05, 2005, 03:04 AM
Great work!!! THANK YOU!!!

Ok... now for some things to point out.

Necro:
Plague Sending - Extra space before the P
Rigor Flesh - Should be Rotting Flesh
Both problems show up in the xls and pdf formats

Warrior:
No total skills number entered in the xls file.

Other than that, everything looks really good. I'm not sure about the other classes, I only noticed because I was going through my own skills that I have.

Knigh7s
Aug 06, 2005, 08:37 AM
Great work!!! THANK YOU!!!

Ok... now for some things to point out.

Necro:
Plague Sending - Extra space before the P
Rigor Flesh - Should be Rotting Flesh
Both problems show up in the xls and pdf formats

Warrior:
No total skills number entered in the xls file.

Other than that, everything looks really good. I'm not sure about the other classes, I only noticed because I was going through my own skills that I have.

Thanks for pointing them out. I just fixed them, but still working on other updates. I should have my updates uploaded by the end of today!!!

Knigh7s
Aug 08, 2005, 05:07 AM
Thanks all for the support!

Version 1.5 is now out! Download it and check it out. Major Face lift and fixes!

n0tsane
Aug 19, 2005, 12:46 AM
Nice additions! Everything is looking real good. So far the only thing I see that may need to be fixed is on the rune list page, 1B where Elementalist starts is centered and it doesn’t display right. Just need to take it off center and it looks fine.

jasondragon
Oct 05, 2005, 03:20 PM
monk skills messed up Bless signet and Blessed skills. Also Aura of Faith is not in order.

jasondragon
Oct 18, 2005, 05:10 PM
missing necro skill awaken the blood.

Knigh7s
Oct 19, 2005, 04:27 PM
Thanks to everyone that has posted bugs or missing items. I will get an update ready as soon as possible. Ive just been so busy with a new addition to my family.

thank you again

Knigh7s

jasondragon
Oct 24, 2005, 05:13 AM
muddy terrain is not an elite for ranger skills.

Kasissia
Jan 17, 2006, 08:50 PM
Thanks, great job!

:D

Knigh7s
Jan 20, 2006, 05:59 PM
Hello GW Community! Im not dead yet, still around. Ive been really busy with my personal life and a 4 month old baby boy, that i havnt had much time to play and update everyones requests. As I slowly move back into the game scene, I will start updating and adding the new Factions content. But for now thank you for all your patience.

Knigh7s

Crusheer
Jan 03, 2007, 11:16 AM
Hi, link to download XLS version ain't active. Could somebody upload it again?

xcutioner
Jan 03, 2007, 12:21 PM
Couln't you have waited another 17 days for the thread's one year anniversary since someone last posted here? :)

Martinet
Jan 05, 2007, 03:07 AM
I can't download it, anyone help me pls?

Knigh7s
Mar 16, 2007, 05:15 PM
The excel spreadsheet I was working on has been lost. I dont have the time to recreate the spreadsheet anylonger.

IF I can find my usb drive that has my backup, then I will continue with the release.

The new one was no normal skills checklist...

we will see...

Knigh7s
Mar 28, 2007, 05:12 PM
I just found my backup of version 2! I will continue working on it and will have it up no later than the end of April. And trust me it will be worth the wait! =P

BlueNovember
May 02, 2007, 05:09 AM
I just found my backup of version 2! I will continue working on it and will have it up no later than the end of April. And trust me it will be worth the wait! =P

May 2nd. :P
Double XP for skill caps weekend approaching. Was planning on starting skill hunter tracks. Think you'll have it up by then?
No worries if not man, gj so far; seems you've impressed a lot of people with it =)

Knigh7s
May 04, 2007, 01:42 AM
Ok, I'm guilty of some heavy procrastination and lazyness. I just can't find the motivation to continue atm. And I havn't really been on GW for a couple weeks as well. But we will see, I will "try" and re-open the file this weekend and take a looksi.

jkyarr
May 29, 2007, 04:37 PM
I can't say I blame you for not feeling like it... Thats a lot of info to maintain and provide. Might I suggest that you submit it as it is to the community and we can see if there's an easier way to share the burden of maintaining it? Open source your xls LOL! I'm interested in doing a DpS / DpE breakdown by skill, and I don't want to have to duplicate the basic skill info just to get on with the good stuff. We ought to see if ArenaNet could provide the basic data in xls format... should be a relative easy query for them (assuming that there is some sort of database) to provide a skill list by profession and attribute type that includes the skill name, Description, Damage Range, Energy Cost, and Recharge Time. Then we'd at least have a bible to interpret however we wanted. :-P How about it ArenaNet?

Knigh7s
May 29, 2007, 09:33 PM
We will see, I've actually been working on it like once a week or so. The Spreadsheet is actually linked to my website database, where it creates a .txt file that you can download that automatically updates the database files within the spreadsheet. But I keep hitting some problems, because I don't know "that much" of Excel VB to use it to it's potential.

I am working on a new layout for it as well.

Teaser:
http://gamer.lobbynetworks.net/images/stories/other/gwuc_teaser.jpg
I am aware that it is missing some characters classes, I'm am a bit behind!