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. :)