I have been working on this "tool" for quite a while now. It allows the user to keep track of the missing skills (Elites as well as Allegiance or Titles) required to UAS (or Unlock All Skills) a character. It seems to be the most complete tool for skill tracking I have seen until now.
I made this "release" version easier to use - hope that it will help you as well.
The first sheet includes a summary (# of skills already learned and # of skills missing). Each profession is on a different tab.
Basically, you will just have to choose between "Yes" or "No". The spreadsheet is made and protected in order to avoid unintentional overwrite or data corruption.
This tool also takes special attributes' skills in consideration (Strength, Fast Casting…) for the summary.
I guess there is nothing else to say! (Please let me know if there are some errors of any kind!)
UAS Skill Tracker
XcSiV.3
pipedream
I like the tool you created, very comprehensive containing all skills. The only things I like better about mine (one it also track vanquishing too & elite skills only) but mainly that is has links to wiki for all skill locations and everything. If you copy the elite skill images from my doc (the links will paste with them) and add to yours (I got them from wiki anyways)... I think it would be pretty cool.
http://www.guildwarsguru.com/forum/s...php?t=10214199
If you wanted to play with my suggestion you can unlock my doc the same way you locked yours... I didn't assign a password, same as you.
Unfortunately the Excel 2007 version is much more impressive visually but most people don't have the latest version yet, still the 03-97 is fully functional.
BTW your use of Excel formulas to create is impressive, from a fellow Excel guru (well try to be, I use it at work for about 30% of my day).
http://www.guildwarsguru.com/forum/s...php?t=10214199
If you wanted to play with my suggestion you can unlock my doc the same way you locked yours... I didn't assign a password, same as you.
Unfortunately the Excel 2007 version is much more impressive visually but most people don't have the latest version yet, still the 03-97 is fully functional.
BTW your use of Excel formulas to create is impressive, from a fellow Excel guru (well try to be, I use it at work for about 30% of my day).
XcSiV.3
Thanks!
Well Looks like I will use your tool as soon as I am done with capping the missing skills! Vanquisher is the next on my list
I thought about putting links everywhere, but this would have taken just tooo much time
Ahahah and thank for the "Excel Recognition".. I also use Excel a lot... learned all this at work also!
Edit: this is much simpler than I thought... new version with links to come! (concatenate "gw.wiki.com" and skill name for those who know)
Well Looks like I will use your tool as soon as I am done with capping the missing skills! Vanquisher is the next on my list
I thought about putting links everywhere, but this would have taken just tooo much time
Ahahah and thank for the "Excel Recognition".. I also use Excel a lot... learned all this at work also!
Edit: this is much simpler than I thought... new version with links to come! (concatenate "gw.wiki.com" and skill name for those who know)
Bytor
Nice file, helpful, but for each of the professions, the primary/exclusive attribute, ie fast casting, soul reaping, etc. is blanked out. If I highlight those cells I see the info, but when i unprotect and unlock the cells the formatting changes are not accepted. weird stuff.