New Skill-Tracking Requirements Spreadsheet 10/11/2007 08:57 PM CDT
This all new personal Bard requirements spreadsheet has the user friendly skill-tracking that you've only been able to get at http://www.zairius.com.

Now you need only copy EXP ALL from the game and paste into the "Skills" tab of this spreadsheet and BOOM. You now know which of your skills qualify for your top lores, weapons, magic, armor, and survivals. Gone are the days of having to either manually enter in numbers by hand or continually load an external website!

With this new spreadsheet, you will see what you need as a minimum for all of your music skills(this is a requirement), which of your music skills is the lowest, and how much leeway and/or remaining that you have/need in order to advance for that music skill in addition to every other one of your requirement skills for the target circle that you specify.

In addition, there is a "Goals" column(column N) where you can set a due date, and the spreadsheet will calculate how many ranks you need daily in order to meet your circle requirements.

You'll also be able to turn the borders on/off by utilizing the drop down located near the top right of the "Requirements" tab.

All of this with the personal feel of having a single file for your character can be had by downloading the file located at: http://soundsoftime.bravehost.com/bard_planner_v2.xls

__
~Leilond
http://i67.photobucket.com/albums/h307/ss1shadow/leilondsootherin.png
http://soundsoftime.bravehost.com/bard_planner_v2.xls - New Skill-Tracking Bard Requirements Spreadsheet
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/11/2007 10:41 PM CDT
Very nice.

Thanks!

GENT
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/12/2007 12:07 PM CDT
Wow, this is really good. I won't even bother asking how you got it to parse the EXP ALL.




Aveda's Field Guide
http://dr.aveda.googlepages.com
Hot hot hot scripts, Antique P5 maps, a macro tutorial, skill & stat training advice, and plenty of Bardly goodness.
Reckus 4 is out! Now with vocal support! 9/18/2007
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/13/2007 08:04 PM CDT
I tried using the spreadsheet yesterday, but it doesn't recognize any of my instrument skills. Every other section other than lore functions correctly, so I don't think it's something on my end.

Just thought I'd let you know I encountered a bug. Thanks for sharing the sheet.

~Micka
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/13/2007 08:58 PM CDT
Hmm, by chance, whenever you pasted your EXP ALL did it drop below row 30?


__
~Leilond
http://i67.photobucket.com/albums/h307/ss1shadow/leilondsootherin.png
http://soundsoftime.bravehost.com/bard_planner_v2.xls - Personal Skill-Tracking Bard Spreadsheet
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/13/2007 10:30 PM CDT
Yes, it went to row 33.
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/14/2007 03:02 PM CDT
Hah... I didn't think it was possible to know that many different skills, but apparently I was wrong.

There's an updated file at the url in my signature that should work for you now. Everything down to row 40 should be fine now, just incase any new skills are introduced into the game.

__
~Leilond
http://i67.photobucket.com/albums/h307/ss1shadow/leilondsootherin.png
http://soundsoftime.bravehost.com/bard_planner_v2.xls - Personal Skill-Tracking Bard Spreadsheet
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/14/2007 07:53 PM CDT
Thanks. It's a nice spreadsheet.

~Micka
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/15/2007 12:00 AM CDT
>>>I didn't think it was possible to know that many different skills,

Just for future reference:

Daerri has 53 skills above 0.00%.

And I don't even TRY hard to make her the Bard Of All Tradeskills. Imagine if I tried harder, and I could see her total going over 60 in a blink. Admittedly, most of the skills she's missing are either armor or weapons, but that's just a challenge I haven't gotten around to yet.

Amagaim; the player of,


The whole of nature is a conjugation of the verb to eat, in the active and the passive.
--- William Ralph Inge
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/22/2007 11:35 AM CDT
Its because you play the OBOE!!!!

>>I tried using the spreadsheet yesterday, but it doesn't recognize any of my instrument skills.




~Bardette Sasabee
Reply
Re: New Skill-Tracking Requirements Spreadsheet 10/22/2007 08:28 PM CDT
<<Its because you play the OBOE!!!!

Not for years Sasacat. I've been using the didjeridu for ages - what a fun instrument.

~Micka
Reply
Re: New Skill-Tracking Requirements Spreadsheet 11/03/2007 11:46 AM CDT
Leilond,

I love your spreadsheet! I was wondering if you could expand the magic section though to add four skills under magic. I know, 4 skills are not required however, I like to keep 4 up into my tops. I admit I attempted to add to the spreadsheet a row for that and well, the moment I did, my survival section with wonky. I tried to figure out why and well, I now feel like I need to go back and get a degree in math after looking at all your calculations. Wow is all I can say! Yes, very nice spreadsheet. Anyway if you can add a fourth line for magic's I would be ever greatful!


~Eoworfinia~
Dartenian fades into view.
A horde of Lawrence Welk fans decend on the area.
Dartenian whimpers softly.
Reply
Re: New Skill-Tracking Requirements Spreadsheet 11/03/2007 12:10 PM CDT
Hey there,

Your request actually already exists in the spreadsheet, believe it or not. In order to see it, all you have to do is go into Tools*>*Protection*>*Unprotect Sheet

From there, you should see a little + box next to row 33 on the 'Requirements' tab. If you click that little + box, you'll see an additional array of skills. The skills in this category are not actual guild requirements. They are as follows...

Tertiary Weapon
Quaternary Weapon
Quinary Weapon
Senary Weapon
Secondary Magic 3
Tertiary Armor

Secondary Magic 3 is what you're referring to. I also track this skill(TM), in addition to all of these other skill placements quite frequently. Please let me know if you have any questions.

__
~Leilond
http://i67.photobucket.com/albums/h307/ss1shadow/leilondsootherin.png
http://soundsoftime.bravehost.com/bard_planner_v2.xls - Personal Skill-Tracking Bard Spreadsheet
Reply
Re: New Skill-Tracking Requirements Spreadsheet 11/03/2007 04:11 PM CDT
That's great! Only problem is, it's finding my secondary magic instead of my next, magical devices. When you spoke of TM, then I thought, okay, I want to track PM, Harness, PP, MD and TM. Suggestions? Also, Tert armor is showing the same as my secondary armor.


~Eoworfinia~
Dartenian fades into view.
A horde of Lawrence Welk fans decend on the area.
Dartenian whimpers softly.
Reply
Re: New Skill-Tracking Requirements Spreadsheet 11/03/2007 05:46 PM CDT
Ahh--sorry about that.

The link below should give you the newly updated file which should be working correctly.

Thank you for the compliments, by the way!

__
~Leilond
http://i67.photobucket.com/albums/h307/ss1shadow/leilondsootherin.png
http://soundsoftime.bravehost.com/bard_planner_v2.xls - Personal Skill-Tracking Bard Spreadsheet
Reply