Forum Settings
       
Reply To Thread

Store TP CalculatorFollow

#1 Nov 17 2009 at 2:22 PM Rating: Good
*
86 posts
So when i hit level 70 and needed to figure out a 6-hit for my SAM, I got annoyed with all the math I had to do every time if i wanted to try multiple sets of gear combininations in an attempt to create the best 6-hit. I also got annoyed with trying to figure out x-hit builds for GTK's of different delays. So what I did was I created an excel Spreadsheet to help me calculate not only a 6hit for my Oni, but also any x-hit/GTK combo that I wanted.

This spreedsheet will adjust the value of the sTP trait to match your level, account for sTP merits if you are level 75 and Calculate Base TP returned for GTK's with a delay of 0-999. You can enter in gear and their sTP value's for a TP and a Single Hit WS Set of Gear.

The Spreadsheet was made with Excel 2007. I have not tried converting it to a 2003 format because of the limitation on nested formulas, but if you wanted to you could try it using the Compatibility Pack for 2003 (Linky).

Here is a look at what the spreadsheet looks like. (Linky)

Click Here to download

Known Issues:
-Currently does not account for a sTP cap.

I've protected everything but the white cells to prevent people from accidently typing over a formula, but you can turn this off to make modifications if you would like.

Please let me know what you think about it. :) I've tested it as best I can, and as far as I am aware, it is accurate. If you find any miscalculations please let me know so i can try to fix them. I'm hoping at least 1 or 2 people will find this useful. :)

____________________________
Fenrir.Mauddib
THF99 > NIN99 > WAR99
#2 Nov 17 2009 at 2:59 PM Rating: Decent
Scholar
***
1,107 posts
FFXI calculator not only does STP needed, but also includes delay and a plethora of other information.
____________________________
80 Pup Brd, 75 War Rdm Drg Sam Mnk Pld Bst Thf Whm Nin Smn Blm Rng, 72 Drk, 63 Cor, 50 Blu, 40 Dnc Sch
#3 Nov 18 2009 at 12:21 AM Rating: Good
Edited by bsphil
******
21,739 posts
Requim wrote:
FFXI calculator not only does STP needed, but also includes delay and a plethora of other information.
When I read the thread title I immediately thought %windir%\system32\calc.exe. >_>
____________________________
His Excellency Aethien wrote:
Almalieque wrote:
If no one debated with me, then I wouldn't post here anymore.
Take the hint guys, please take the hint.
gbaji wrote:
I'm not getting my news from anywhere Joph.
#4 Nov 18 2009 at 11:12 PM Rating: Good
Scholar
****
9,209 posts
bsphil wrote:
Requim wrote:
FFXI calculator not only does STP needed, but also includes delay and a plethora of other information.
When I read the thread title I immediately thought %windir%\system32\calc.exe. >_>

^ this
Windows -> Run... ->type 'calc' -> OK
or do it in your brain just for practice.
Reply To Thread

Colors Smileys Quote OriginalQuote Checked Help

 

Recent Visitors: 16 All times are in CDT
Anonymous Guests (16)