Corsair Calculator

why does the excell 2001 + one go to a page that says this...

Note: This is an error message, not the page you were looking for. Unless you were looking for the error page, in which case this is the page which you were looking for.

Four Oh Four BAD

i feel so decieved cause that is the only one that would work here @ work and it doesn't also....

I wish I had Excel now so I could fix all these stupid errors I keep hearing about. More people use Excel, so I'd like to make it compatable for all of 'em. Sigh.

B> THIS THREAD STICKIED, hate having to search for it everytime i gotta wipe my comp and start over which is far too often/ look for it @ a friends house its a VERY useful calculator and is the only thing any Corsair would ever need ^_^ since it incorporates everything into it, equips where youc an list each individual item and it's stats to see what would be a better upgrade for you which REALLY helpped me out here when deciding which to upgrade next (also helpped me spy on what equips you have / had @ level 168 now i know what i need to gather to compair to ya a bit since you seem to be the only other active corsair over 170 ive seen besides myself who posts here

I really appreciate that. Its nice to know someone is making use of all my hard work.

On a sidenote, should I update it for the Octopus upgrade? Anyone interested in that?

I wish I had Excel now so I could fix all these stupid errors I keep hearing about. More people use Excel, so I'd like to make it compatable for all of 'em. Sigh.


I really appreciate that. Its nice to know someone is making use of all my hard work.

On a sidenote, should I update it for the Octopus upgrade? Anyone interested in that?

i dunno if doing that is a good thing... we all know Octopus is NOT a main skill... and if you make it look any better(which is easy) some ppl might be tempted to do it first...... lol and uhh if you need any feedback from an excell user or any help seeing anything i can help ya feel free to ask

i dunno if doing that is a good thing... we all know Octopus is NOT a main skill... and if you make it look any better(which is easy) some ppl might be tempted to do it first...... lol and uhh if you need any feedback from an excell user or any help seeing anything i can help ya feel free to ask

Well you'd have to be retarded to use it during training. All it would do is cause unnecessary aggro and get you hit, all the while not reducing the number of hits it would take you to kill. However, Octopus is a monster during bosses. The one thing you have to make sure of, though, is that Octo is actually attacking the boss. I say this because I often place my Octo on the top left platform in HT to make it attack the left head, but it doesn't attack the head unless you're slightly above octo (only happens when you jump or get hit), or you place Octo on the first step in front of HT. Still, I think Octo should be treated somewhat like a Snipe that only works at bosses.

Updates for v1.5:
-Now updated for Excel! I remade it myself in Excel 2007, so it should work and look great in Excel now
-Added delay, cast time, and efficiency to the Octopus section
-Made Bullseye work for Octopus' damage, and added the ability to turn it off separately from Bullseye
-Added a "DPS for Octopus" section. It says your DPS if you were to cast Octopus every time it cools down
-Updated the Dex/Attack ratio to be more accurate

 Spoiler

Hey, I really appreciate the time you took to make this and I would really love to use it.
Is it possible to upload one that is saved in a format operable in Excel 2003?
Thanks!

Hey, I really appreciate the time you took to make this and I would really love to use it.
Is it possible to upload one that is saved in a format operable in Excel 2003?
Thanks!

Oh what, really? Excel isn't compatible with itself? Motherf'cking Excel... way to suck.

Hold on, lemme see if Excel 2007 can save in an older format.

Here you go. Corsair Calcs (Excel 97-2003). I put it in the first post too.

Oh what, really? Excel isn't compatible with itself? Motherf'cking Excel... way to suck.

Because MICROSOFT. It's retarded, I know. All the stupid '07 Office programs have an updated file format that doesn't work with the good older versions. This has caused me much stress at college. Massive headache from professors who don't realize this...

Anyway, I appreciate the Excel version. I'll be sharing it with my friend for sure now.

There is a fix from Microsoft that you can install and it automatically converts 2007 to 2003 files. Ill look for it once I get home and post the link.

edit: actually, screw work, its christmass.

here

http://www.microsoft.com/downloads/detai...laylang=en

Does the one I posted work fine or should I convert using Carlos' link?

i did not explain myself clearly. that patch is for office 2003, you install that and when you try to open a 2007 file it converts it to 2003 for you, no errors.

Yeah. It lets Office 2003 read the 2007 format.

After all, the 2007 format is what Microsoft is trying to move toward. I don't really know what's improved over the 2003 one, but I do know that a blank Word document is less than half the file size...

As Russt said, the .xlsx format is a lot better than the .xls format. The lack of compatibility does suck since it takes years for people to catch up to the latest version but you should be able to read newer formats with limited ability in older versions at least.

Nearly every problem I have with Excel is with the compatibility problems. I like the program itself.

wow just wana say thanks for this (altho u probly hear that a lot, im a new Sair so just finding this)
This is probably the most useful thing ive ever seen someone make for MS

I used to keep several text files with hp calculations, range calculations and other stuff but now i dont need them anymore lol
and that hits to kill calculator thing is simply amazing, it must have took you some time to do all this. I appreciate you sharing it a lot.

EDIT: oh and thanks to this i know for certain that with SE even level 1 RF is better than max burst fire. I already suspected as much since more hits = more chances to crit but this helped confirm it. Now i know i made the right choice using RF on my recent zak runs, this is important to me since i cant get cannon lol.

wow just wana say thanks for this (altho u probly hear that a lot, im a new Sair so just finding this)
This is probably the most useful thing ive ever seen someone make for MS

I used to keep several text files with hp calculations, range calculations and other stuff but now i dont need them anymore lol
and that hits to kill calculator thing is simply amazing, it must have took you some time to do all this. I appreciate you sharing it a lot.

EDIT: oh and thanks to this i know for certain that with SE even level 1 RF is better than max burst fire. I already suspected as much since more hits = more chances to crit but this helped confirm it. Now i know i made the right choice using RF on my recent zak runs, this is important to me since i cant get cannon lol.

My job was 99% physical labor, so I'd be bored if I wasn't thinking of something the whole time. So I dedicated about 3 days of work just thinking about a way to accurately calculate hits to KO with algebra. I'd like to figure out how to make it work with SE at some point, too.

Thanks, I appreciate the compliments. If there's anything you can think of that's not in the calculator that would be useful to you (and other people as well), tell me and I'll probably add it in.

...If there's anything you can think of that's not in the calculator that would be useful to you (and other people as well), tell me and I'll probably add it in.

ok after a few days of using the calc here goes:

• Maybe you could consider a 'helpful data' page that would have stuff like hp and def values for commonly trained on monsters (skeles, newts, etc). I found it quite tedious to always be heading to hiddenstreet.net when i needed to find these values so i ended up making this myself lol and adding it to the calc.
  
  
  
• Firstly, i dont even know if a formula exists for this but ill suggest it anyways; many a time when moving to a higher level training spot i would just walk in and hope i have enough hp to survive an attack. Maybe you could add a function that takes your def (and level if that affects it in anyway), the monsters attack points and calculates min, max and avg damage that monster would do to you.
  
  
  
• I noticed that even though at level 1 battleship torpedo hits 4 monsters at a time, if i set number of monsters to greater than 4 the dps for torpedo still goes up even though i inputted that it is at lvl 1. This is pretty minor though and may not be even worth fixing i guess.
  

so ya, mostly 'icing on the cake' type stuff nothing major, maybe if you're bored one day and want something to do

all that stuff is just lazy talk now.....

except the last 1 i guess

ok after a few days of using the calc here goes:

• Maybe you could consider a 'helpful data' page that would have stuff like hp and def values for commonly trained on monsters (skeles, newts, etc). I found it quite tedious to always be heading to hiddenstreet.net when i needed to find these values so i ended up making this myself lol and adding it to the calc.

I guess I could list some of the more popular monsters... but this isn't really a text dump. If you need to remember several monsters, you could always write it down in the gray area (it's all editable), or just memorize it. There's nothing stopping you from making your own little list near the bottom of the Data tab or making another tab with that sort of information. But yeah, Hidden Street is the information dump -- my calc is for calculating.

• Firstly, i dont even know if a formula exists for this but ill suggest it anyways; many a time when moving to a higher level training spot i would just walk in and hope i have enough hp to survive an attack. Maybe you could add a function that takes your def (and level if that affects it in anyway), the monsters attack points and calculates min, max and avg damage that monster would do to you.

I guess I assumed this type of thing was common knowledge. Skeles do about 3.5k, transformed Newties do up to 2.8, Newties do 2.1, etc. If it's just about finding out if you can take a hit, just ask a friend or something. I personally don't see the use of a "Damage Received" section beyond being able to see if you can take a single hit, and I don't think that deserves a section. If you really don't know anyone in an area who can tell you if you can take a hit nor can you go there at 0% to find out manually, you could always figure it yourself using the Formula Compilation.

• I noticed that even though at level 1 battleship torpedo hits 4 monsters at a time, if i set number of monsters to greater than 4 the dps for torpedo still goes up even though i inputted that it is at lvl 1. This is pretty minor though and may not be even worth fixing i guess.

Yeah, my Calc assumes you're not trying to screw with it. If you know Torpedo doesn't hit more than 4 monsters, then don't enter in more than 4 for the monster section. I can't just limit it to 4 when Torp's level is low because you have other skills (Air Strike, Flamethrower, Ice Splitter) that can hit 6 mobs all the time. At the very least, I don't let you enter in less than 1 or more than 6 monsters. (try entering a negative number into any skill level or monster HP)

so ya, mostly 'icing on the cake' type stuff nothing major, maybe if you're bored one day and want something to do

Not to shoot down all your suggestions, but I try not to add things that I deem to have very little to no use so that it doesn't clutter up the calculator. Everything that's on it now I have used for some purpose or another, and I've gotten rid of things I had before that no one would use.

Once again, if you find any errors or can think of something that others would find use for, feel free to voice them.

How exactly does the octupus delay box work? What am I supposed to put in there? :x

How exactly does the octupus delay box work? What am I supposed to put in there? :x

You know how Snipe or Air Strike have a cooldown of 5 seconds? Well, you know how it *says* 5 seconds but you actually end up waiting 7 or 9 seconds? Well the "Octopus Delay" box is the amount of time (in seconds) that you expect to wait in addition to the skill's natural cooldown. So if you think it usually takes 3 extra seconds for the skill to cool down, you would put 3 in that box and my calculator would calculate Octopus as though you casted it every 13 seconds.

Ohhh cool that sounds like a nice feature.