103 réponses à ce sujet

[Grimy Bunyip]

Calculator Link:
https://docs.google....MNDIyUXc#gid=17
Weapon Stats Sheet Link:
https://docs.google....AzX1B3NlE#gid=3

Calculator
I'm sure there's a number of other calculators out there.
So I tried to make one that's as easy and intuitive to use as possible.

To edit & use it:
Click File -> Make a Copy

To bring down drop down menus:
Highlight yellow cells, then click the small arrow to the right of the cell.

Unfortunately, keeping the calculator intuitive complicates the calculation side of things.
so consider this a beta test, as there are probably a few bugs to work out due to the complexity.
The citations for which information I referenced to produce the calculator are listed on the relevant sheets of the calculator.

I hope at least someone likes it [smilie]http://social.bioware.com/images/forum/emoticons/heart.png[/smilie]

Modifié par Grimy Bunyip, 13 mai 2012 - 01:22 .

[Barneyk]

Nice!

[Dustin1280]

nice job!

Modifié par Dustin1280, 20 avril 2012 - 12:41 .

[Grimy Bunyip]

Modifié par Grimy Bunyip, 24 mai 2012 - 01:49 .

[Maria Caliban]

I changed it to asari adept but the it's keeping the infultrator section below the power list.

[Grimy Bunyip]

Maria Caliban wrote...

I changed it to asari adept but the it's keeping the infultrator section below the power list.

The yellow input cells don't force updates, I don't think that's a functionality of google doc.

So say you have Infiltrator -> Salarian infiltrator set initially.
but your rank 6 for skill 1 is still set to sniper damage bonus.
It'll stay that way until you edit the "sniper damage bonus" cell to stasis bubble or something like that.

edit:
I've isolated the issue I'm referring to.
apparently it's inconsistent, and the last few people who contacted google representatives couldn't get a fix.
http://groups.google...ces/p8lObGw9KFs

I'll try remaking the spreadsheet with the custom code and cross my fingers.

edit2:
that didn't work.
Supposedly uploading to google templates does work though, I'm going to try that instead.

Modifié par Grimy Bunyip, 20 avril 2012 - 03:14 .

[Maria Caliban]

Yes, I manually entered the powers, but the area where I put in the ranks information still has the infultrator power ranks.

[Grimy Bunyip]

Maria Caliban wrote...

Yes, I manually entered the powers, but the area where I put in the ranks information still has the infultrator power ranks.

by "ranks information" you mean the numbers? 6/6/6/6/0?

or do you mean that it's saying you have an asari adept with tactical cloak?

edit: template didn't work either.
I'm really out of ideas now

Modifié par Grimy Bunyip, 20 avril 2012 - 03:15 .

[Grimy Bunyip]

Bump

Posted a quick fix for the people who are interested in knowing how many shots or headshots it takes to kill something.

I sent a query to google, hopefully they can fix it soon.
From the looks of the google support groups, this isn't something I can fix on my end.

[Grimy Bunyip]

bump, fixed a few typos including one that made the calculator think every gun was a sniper rifle

Modifié par Grimy Bunyip, 20 avril 2012 - 03:57 .

[youki886]

That's great!
It help me a lot,but there is still some issue on hunter mode's damage bonus.

[nwj94]

Very useful, much appreciated.

[dnaxv]

Nice, this is awesome, but I can't seem to get Hunter Mode power evolutions to show up.

[Grimy Bunyip]

dnaxv wrote...

Nice, this is awesome, but I can't seem to get Hunter Mode power evolutions to show up.

youki886 wrote...

That's great!
It help me a lot,but there is still some issue on hunter mode's damage bonus.

bump, i'll look into it

edit: fixed
thanks for all the heads up
It would literally take me hours and hours to double check all the hidden cells where the calculations and Input processing is done >_<

Modifié par Grimy Bunyip, 21 avril 2012 - 12:02 .

[Djoums]

Very nice, thanks for your work !

It seems the AP mods are broken, they actually decrease your dps against armor.

[Grimy Bunyip]

Djoums wrote...

Very nice, thanks for your work !

It seems the AP mods are broken, they actually decrease your dps against armor.

fixed, thanks for the heads up
I swear sign convention is the bane of my existence.

Modifié par Grimy Bunyip, 21 avril 2012 - 12:20 .

[Grimy Bunyip]

bump

[Djoums]

How do you compute dps with charged weapons ? I compared the gps with the claymore and it turns out the gps has a 50% higher sustained dps but a 50% lesser burst dps so i wonder if charge is being taken into account.

Edit : also, accuracy mods seem broken too unless a lower value is better (what does the value mean exactly ?)

Modifié par Djoums, 21 avril 2012 - 11:57 .

[Grimy Bunyip]

Djoums wrote...

How do you compute dps with charged weapons ? I compared the gps with the claymore and it turns out the gps has a 50% higher sustained dps but a 50% lesser burst dps so i wonder if charge is being taken into account.

Edit : also, accuracy mods seem broken too unless a lower value is better (what does the value mean exactly ?)

I don't compute DPS with charged weapons yet because I haven't looked into charge up mechanics fully yet.
so that number you got is from just spamming the gps without charge up.

and yeah that was a mistake, I thought lower values were better but that's not true.

Modifié par Grimy Bunyip, 21 avril 2012 - 04:18 .

[Grimy Bunyip]

bump

[Grimy Bunyip]

bump

[Grimy Bunyip]

bump

[SeijiTataki]

Proximity Mine doesn't seem to have the option of applying a damage debuff; more specifically, if I select it, I can't adjust it to have applied a debuff effect at all (or the fact that its damage dealt would have a minor impact on the health totals of any enemies it hits)

[Grimy Bunyip]

SeijiTataki wrote...

Proximity Mine doesn't seem to have the option of applying a damage debuff; more specifically, if I select it, I can't adjust it to have applied a debuff effect at all (or the fact that its damage dealt would have a minor impact on the health totals of any enemies it hits)

This is correct.
I haven't added non-passive abilities yet.

to clarify.
Tactical Cloak
Adrenaline Rush
Hunter Mode
Marksman
Racials such as Salarian Operative

These are the only skills that will affect the calculations as of now.

Modifié par Grimy Bunyip, 22 avril 2012 - 10:19 .

[Grimy Bunyip]

bump