Excel Commands

[Asrial]

Is there a math command for Excel that basically says if something is below 0, make it 0?

[EDIT: Nevermind, think I found it.

=If("your formula"<0,0,"your formula")

So simple but I'm learning Excel formulas on the fly.]

[Celephais]

MAX(0,X)

[Asrial]

Thanks Celephais :)

Getting Tavarion's training spreadsheet updated for post-cap training (now that I've reached that point).

[Deathravin]

Does Tsoran's not do that?

I guess not that greatly though. But the more I think about it, I can't really think of a good way to make it in such a way that you can see a progression similar to the 0-100 portion...

[Celephais]

I always figured a good way to plan it out was to assume 60 M/PTPs as a new level. At 150,000 exp it would be relatively on par w/ 99-100 (112,500), and the TP amount is the max (of either individually) you could have been getting per level.

So a character with 7,722,500 exp would just hit level 101, and 10 million exp = level 116.

[Asrial]

Does Tsoran's not do that?

I guess not that greatly though. But the more I think about it, I can't really think of a good way to make it in such a way that you can see a progression similar to the 0-100 portion...I don't know if Tsoran's does it or not. I've always used Tavarion's, because I feel Tsoran's does too much for my tastes, so while I have a couple of Tsoran's spreadsheets.. I don't know the ins and outs of them.

As for the 'such a way' part, I guess it comes down to aesthetics. I already have a fully functional method of keeping track of remaining TP's as you play around with skills. ..but it's not laid out in a 0-100 format. You basically are only changing how many ranks of X skill you want to have. I could also add, now that I think about it, a spot to display how much XP you need to get a negative TP amount back up to 0.

It really comes down to how people want to see the data and how they want to train.

Coming from GS3, I alway waited until I leveled before training all my skills.

..but now that I'm 100, I'm probably going to train skills as I get the TP's.

Also, my mentality has changed from 0-100 progression training to 1x/2x/3x skill training. If that makes sense.