Ok, I've been putting together a spreadsheet to help me design my titans. Its all full of stupidly overcomplicated formulas to give me an idea of how the titan would perform in various situations.

But one thing I haven't managed to figure out, is a way to calculate the titan's scan range, shield coverage, and weapon range from its inputted techs.

The best I've managed is a very large, very ugly set of nested IFs that check whether the tech is under 10, else if it is under 14, else under 20, etc, up to 1190... and outputs 0, 1, 2, etc appropriately.
It is already written, but I still spent hours and hours trying to think of a better way... some formula that would allow me to plug in a tech value and get a tech generation back.

I think I got close, but then I just couldn't focus my mind anymore and gave up. If only I could remember all that calculus I learned.

Only way I can figure tech gens other than the table provided is by making three columns, A B and C. C starts at 2 and increases by 2 each row. B starts at 4 and increases by C each row, and A starts at 10 and increases by B each row. I know there should be a formula to represent this, just can't think of how.
I nailed down formulas to represent B and C, just not A.
C = 2xtech gen + 2 and B = tech gen squared + tech gen + 4
I figured B by plotting out some points and playing with numbers, but A looks like some kinda x^3 curve and the points I can't seem to figure it from the points.





<--- Math Geek.... with a headache...

Greenwolf wrote:

The best I've managed is a very large, very ugly set of nested IFs that check whether the tech is under 10, else if it is under 14, else under 20, etc, up to 1190... and outputs 0, 1, 2, etc appropriately. It is already written, but I still spent hours and hours trying to think of a better way... some formula that would allow me to plug in a tech value and get a tech generation back.

1190! That's optimistic!

heheh.. well.. just so it wouldn't bug out if i popped in some really big number without thinking it through.

If you really want a forumulae to calculate what tech band a titans tech is in try entering this into Excel.

Code:

=+TRUNC(ROUND(((11*2^(1/3))/((810+SQRT(143748+6561*(-10+Tech)^2)-81*Tech)^(1/3)))-(((810+SQRT(143748+6561*(-10+Tech)^2)-81*Tech)^(1/3))/(3*2^(1/3))),8))

Where Tech is the field on the spreadsheet that contains the tech level you want to calculate the tech band for.

Please don't ask me to explain how this works as I don't understand it myself. All credit for this should go to the now long departed Chameleon, who created a Titan design and comparison spreadsheet quite some time ago.

If you want to use this very useful utility yourself it's still available for download from the following website.

Only registered users can see links on this forum! Register or Login on forum!

Some of the damage calculations and perhaps the critical % chances might by now be a little out of synch with the sphere, although I don't think most of those areas have been altered for a long time now, so I'm not 100% sure on that one.

I decided to work out the formula for the tech gen boundaries, and this is what I came up with.

f(n) = (n^3 + 11n + 30) / 3

f(0) = 10, f(1) = 14, f(2) = 20, etc, etc

This probably explains Chameleon's frightening formula, as he's trying to determine a cubic root.

nice... how'd ya figure that out..
i got it pinned to 1/3*x^3 + something + 10, just couldn't figure out the middle...

Wow haven't seen that for a while. When I first starting playing I messed around with excel sheets and discovered that formula for tech!) in my quest to find the "mathematically" perfect titan.

I have since abandoned my quest as I find that you can't predict every factor.

Experience, your enemies design, tactics all play a part in designing titans. Best to play it by ear.

Naturally, you'll ignore me, though. Have fun!

heh, well, as you said, experience is important. barring that, a bit of math will have to do until i gain that experience. not so much going for mathmatically perfect, there is obviously no such thing, but i can design a few builds with fine-tuned abilities in certain areas..
and i've worked out half a dozen designs, planning on producing lots of all of them to see how each works out and then redesign and such based on how things actually work in reality rather than theory.

Looks like the problem is already solved but one different approach is to use the lookup function. vlookup or hlookup. Just read the help files (which, holy cow, are helpful). Paste the entire tech table, scan, weap, etc, into a different worksheet (not workbook) and lookup away.

If it still gives you grief let me know and I can put a bit of effort into it.

its solved.. i did have a kludged version of it working, which i haven't bothered replacing yet... more curiosity than anything..
and i am using microsoft works spreadsheet... too poor for excel

I cant be bothered to pay for excel so I use open office (http://www.openoffice.org/). All the features of excel and word with none of the cost.

And I will say nothing more for fear of starting a religious word processor war.

If you dont like my advice then take it out on me in the sphere

and if i like your advice but chose to shoot you in the sphere anyway? (although I don't have a single weapon system atm)

If you choose to shoot at me just get a ticket and line up behind frosty nuts because it is his turn to kick me all over the sphere at the moment

I use openoffice as well and I'd certainly recommend it to people.

You are slowly catching me up Grunts in the tech race. I've paused on the threshhold of Blue tech as to upgrade now would blight a large proportion of my clan.

heh, well i'm in no hurry... need guns first to actually shoot anyone..

and i suppose its always possible to download Office for free
<3 torrents