Aller au contenu

Photo

ME3 Weapon/Build/Consumable Calculator: Time to Kill every enemy with your setup


  • Veuillez vous connecter pour répondre
172 réponses à ce sujet

#26
mrs_anomaly

mrs_anomaly
  • Members
  • 2 900 messages
This is fantastico! I'm such an intuitive *coughlazy* player that this would be awesome to check out. How do I do that?

#27
Tybo

Tybo
  • Members
  • 1 294 messages

ISHYGDDT wrote...

Very nice.  So I played around with the calculator a bit, are you sure Ravagers don't have headshot bonuses?


Ravagers don't get headshots, but they do take spikes of damage when the sacs break.  I wasn't sure how much, so i didn't include it.

#28
Tybo

Tybo
  • Members
  • 1 294 messages

mrs_anomaly wrote...

This is fantastico! I'm such an intuitive *coughlazy* player that this would be awesome to check out. How do I do that?


Use File>Make a copy, and you will make a file you can edit yourself.  To do so, you will need to be signed in to a google account.  The download as excel spreadsheet doesn't seem to work, as it doesn't import the functions I wrote for this program.

#29
ISHYGDDT

ISHYGDDT
  • Members
  • 6 930 messages

tyhw wrote...

ISHYGDDT wrote...

Very nice.  So I played around with the calculator a bit, are you sure Ravagers don't have headshot bonuses?


Ravagers don't get headshots, but they do take spikes of damage when the sacs break.  I wasn't sure how much, so i didn't include it.


Hmm.  Maybe there's some double hit detection with the ravager because they seem to take more damage shot in the 'eye.' Or maybe it's just my imagination.

#30
Tybo

Tybo
  • Members
  • 1 294 messages

ISHYGDDT wrote...

tyhw wrote...

ISHYGDDT wrote...

Very nice.  So I played around with the calculator a bit, are you sure Ravagers don't have headshot bonuses?


Ravagers don't get headshots, but they do take spikes of damage when the sacs break.  I wasn't sure how much, so i didn't include it.


Hmm.  Maybe there's some double hit detection with the ravager because they seem to take more damage shot in the 'eye.' Or maybe it's just my imagination.


My gues would be that shooting the 'eye' breaks all the sacs but the bottom one, leading to the highest damage from bursting sacs.  But to the best of my knowledge, Ravagers don't get headshots.  

#31
Manuel La Bor

Manuel La Bor
  • Members
  • 567 messages
This is GREAT!

but wasn't this grimybunyips thing months ago?

#32
Tybo

Tybo
  • Members
  • 1 294 messages

UnknownMercenary wrote...

It's great that this got updated. Nice work!


I didn't just update it, I improved it!:D

But this seriously wouldn't have been possible without Grimy_Bunyip's calculator as a base.  I corrected the damage formulas to match the current understanding of weapon damage and added in the time to kill function.  I also added in a bunch of features such as weapon damage multipliers against defenses (acolyte, typhoon) and added the new weapons/mods/enemies/modes.  But almost all of the database work was in place, and he wrote the spreadsheet in a well organized manner that allowed me to pretty easily add in new things.

#33
Tybo

Tybo
  • Members
  • 1 294 messages

Manuel La Bor wrote...

This is GREAT!

but wasn't this grimybunyips thing months ago?


Yup.  I stole his framework and improved/updated it.  

#34
BjornDaDwarf

BjornDaDwarf
  • Members
  • 3 729 messages
Played around with a few things tonight, one thing I noticed is the RoF on the GPSMG. According to some tests Peddro did awhile back, the max RoF on it is 720. You've got it at well over a thousand.

#35
ToaOrka

ToaOrka
  • Members
  • 3 508 messages
I've been using the manifest detailer for too long, I'm too lazy to learn a new calculator.

Regardless, kudos to you for putting in the effort for a calculator.

#36
Hymmnos

Hymmnos
  • Members
  • 363 messages
Sniper HVB III is missing.

Looks good though.
I'll check it out in depth... tomorrow. 11:00 PM isn't the time to be staring at numbers.

Modifié par Hymmnos, 27 novembre 2012 - 03:28 .


#37
Tybo

Tybo
  • Members
  • 1 294 messages

BjornDaDwarf wrote...

Played around with a few things tonight, one thing I noticed is the RoF on the GPSMG. According to some tests Peddro did awhile back, the max RoF on it is 720. You've got it at well over a thousand.


Good catch.  I've fixed it now, thanks.

#38
Tybo

Tybo
  • Members
  • 1 294 messages

Hymmnos wrote...

Sniper HVB III is missing.

Looks good though.
I'll check it out in depth... tomorrow. 11:00 PM isn't the time to be staring at numbers.


Good catch, thanks.  I've fixed it now.  I had Sniper HVB II twice instead...

#39
Hymmnos

Hymmnos
  • Members
  • 363 messages

tyhw wrote...

Hymmnos wrote...

Sniper HVB III is missing.

Looks good though.
I'll check it out in depth... tomorrow. 11:00 PM isn't the time to be staring at numbers.


Good catch, thanks.  I've fixed it now.  I had Sniper HVB II twice instead...

Blame the hours. That usually works for me. :whistle:

#40
SeanThen1

SeanThen1
  • Members
  • 1 055 messages
Can people throw out some quick conclusions for each weapon type (SMG, AR, etc)? Curious to see what people are drawing from the spreadsheet.

#41
Tybo

Tybo
  • Members
  • 1 294 messages

SeanThen1 wrote...

Can people throw out some quick conclusions for each weapon type (SMG, AR, etc)? Curious to see what people are drawing from the spreadsheet.


This spreadsheet is more useful for build/consumable/mod optimization.

With regards to weapons, you'll see the same old things: claymore and javelins one shot enemies.  Hurricanes and PPRs and Harriers and Reegars and Piranhas and Typhoons own bosses.  

This calculator just shows you how to optimize their use, so you don't waste skill points. The one thing that I find very useful is that it helps you calculate exactly how much weapon damage you need to one shot smaller enemies with the lighter weapons.

Modifié par tyhw, 27 novembre 2012 - 04:15 .


#42
Tybo

Tybo
  • Members
  • 1 294 messages
double post

Modifié par tyhw, 27 novembre 2012 - 04:15 .


#43
Tybo

Tybo
  • Members
  • 1 294 messages
bump

#44
AaronEh

AaronEh
  • Members
  • 415 messages

tyhw wrote...

bump


It looks like the firing rate for Marksman is higher than it should be.  Taking all the Accuracy evolutions should give me 35% boost to fire rate but the spreadsheet is showing 50% - even more if you pick Firing Rate evolution.

Thanks.

#45
Tybo

Tybo
  • Members
  • 1 294 messages

AaronEh wrote...

tyhw wrote...

bump


It looks like the firing rate for Marksman is higher than it should be.  Taking all the Accuracy evolutions should give me 35% boost to fire rate but the spreadsheet is showing 50% - even more if you pick Firing Rate evolution.

Thanks.


Thanks, you are correct.  I've fixed it now.  Unfortunately, you will have to make a new copy of the spreadsheet to update it with this fix.

#46
Deerber

Deerber
  • Members
  • 16 823 messages
Wow! This is just wonderful!

Epic job Tyhw, and thank you so so much for this!

#47
Tybo

Tybo
  • Members
  • 1 294 messages
Updated for the Asari Huntress. Tactical Cloak now works for the huntress. In the near future, I will update this so that the skill index pulls the data from my own copy, and you won't have to re-download the calculator any time a skill gets balance changed.

#48
k1ngl1ves

k1ngl1ves
  • Members
  • 6 659 messages
This is good. This is very good...

#49
Noahsun

Noahsun
  • Members
  • 107 messages

tthw wrote...

Lord_Sirian wrote...

I KNEW ABOUT THIS BEFORE IT WENT MAINSTREAM!

Nice work. :D


What a hipster...... 


get this man a PBR tallboy stat

#50
Tybo

Tybo
  • Members
  • 1 294 messages
Updated for Reload Cancelling. Changing reload animation cancel to true will calculate times with reload cancelling. Switching it to false will calculate times without it.