|
Post by ninopettis on Mar 6, 2015 16:54:15 GMT -5
I didn't know which forum to put this in but it involves mostly things from this forum so I chose here. I've put together a spreadsheet that uses Marvel4's Advanced Warfare data and probaddie's recoil stats. It shows TTK and other things, is affected by attachments chosen, and has accuracy modifiers. It's forever a work in progress, and is only set up to work with certain guns. I'm posting it here both because people could find it useful, and also for advice on how to improve it. I'll go through some of the features below: direct download link to spreadsheet [REMOVED OUT OF DATE DESCRIPTION]Edit: Fixed a bug with burst fire data columns that showed burst times for ALL weapons when frame rounding was turned off. Fixed all the attachment dropdowns in the attachments section. Renamed the erroneously-named "ADS move" column on the data sheet to "Move speed". Resized the comment boxes that were too small.
Edit: Fixed a major mistake with the formula that calculated burst duration. Also changed the accuracy modifiers from 30% and 15% to 35% and 20%.
Edit: Somehow missed a huge mistake where ASM1's intro firetime length was set to 0. I think I did that before the 03/03 patch changes were released. Fixed that. Also made some formatting changes to accommodate adding more guns soon.
Edit: Fixed another major typo where I didn't enter the recent patch's range buff for the KF5.
Edit: I've posted the new version of the spreadsheet, along with new screenshots. It's bigger than the previous file and takes a longer time to open. I removed the old description that explains the document from this thread, because it's largely out-of-date.
|
|
banana
True Banana
Zoro > Law
Posts: 1,577
|
Post by banana on Mar 6, 2015 20:41:55 GMT -5
@ 57 fps the hair trigger shoots at 855 rpm so maybe that's why?
|
|
|
Post by ninopettis on Mar 7, 2015 10:22:05 GMT -5
@ 57 fps the hair trigger shoots at 855 rpm so maybe that's why? I thought it was a possibility, but I wasn't sure. In the post I linked, I mentioned a video that showed PS4 framerate stay mostly at 60fps but occasionally dip to 59 fps, and around that time, frame duration seems to get halved on the small graph. I hope that this is the reason for actual frame rates differing from the frame rounded numbers, because I could maybe work something into the spreadsheet to account for framerates occasionally being halved. I still don't know exactly how it works though. There's other videos on Youtube showing framerates on AW. It's also different on each console. Edit: I actually just went through and counted how many times frame length got halved in the video, and it was 36 times, which is 1 time per every 8.28 seconds. It should only take 2.5 seconds to empty the clip of an AK12, so it should be rare to see any frames dropped in that time. Yet, in my test, the Hair Trigger would ALWAYS empty its clip faster than the base AK.
|
|
lllRL
True Bro
Posts: 101
|
Post by lllRL on Mar 7, 2015 18:05:47 GMT -5
Yeah whenever I've tested it the base AK12 seems to fire at around 690-700rpm on my PS4, while the Hair Trigger matches the Bal-27. I don't use the Bal anymore for that reason - same ROF (with the awful intro fire time), less range, and more recoil even with a grip. The Bal only wins up to 5m or with headshots, but I'd rather aim for centre mass with everyone flying around
|
|
|
Post by ninopettis on Apr 5, 2015 0:42:55 GMT -5
I dunno if anyone cares about this spreadsheet but I'll post an updated version soon. It's got a lot of fixes and some new features like use of a headshot multiplier, lerped fire rates, probaddie's adjusted recoil stats, different modifiers, plus I also added the AE4, EM1, EPM3, A45, MP443, and PDW, but still no Ohm, Akimbo, RW1, snipers, or shotguns. I want to add an ADS time modifier to TTK that uses hipfire accuracy while not ADS, but just haven't had time.
|
|
|
Post by ninopettis on Apr 5, 2015 20:19:49 GMT -5
You should make a google doc version so people actually look at this. The BTK by feet section can be condensed greatly by making the collumns the BTK and making the cells the distance. I suppose that makes the other variables related to feet more difficult though. Id like to say the same for the ttk by feet section but that one gets complicated at some points (if im reading this right its because youre scaling by accuracy, which personally I dont think is good since its very misleading to still call the units seconds). If you keep it as an excel document (or just lock cells in a google doc) you could move those to a more descrete location and instead let the user choose one or two weapons to plot the ttk for over distance, which would be a hell of a lot easier to read. The same could probably be done for accuracy by feet....well sort of....I dont really know how that stats useful in the first place since the situations are way too variable to use it as a rule of thumb even (which is already an issue with ttk in the first place). At the very least if you keep the stats vs distance sections, plots would be useful because scrolling back and forth to read and put everything together is a real pest. Attempting to make a more simplified document that's viewable online was on my to-do list. Hopefully I'll give it a go. I didn't want these tables to be condensed. I wanted to show how the data changes as range progresses. I used to not have the big HTK or Accuracy tables at all; everything was put into the TTK table. But the formulas got too big that it made sense to make tables for each TTK, HTK, and Accuracy. It also can be useful to look at for reference. But, I grayed out those columns and kept them at the end of the sheet for a reason: the TTK close, TTK mid, and TTK long columns summarise them, and are also customizable in case one disagrees with their parameters. In the new document I also have a HTK table that includes 1 headshot, using binomial formula to add it to TTK, though I've been hiding the columns. I didn't do one for 2 headshots, 3 headshots, etc. because statistically they weren't anywhere near as significant. Finally, I didn't know a simple way to add linear interpolation for the ASM and HBR, meaning I HAD to make new columns for TTK lerp just because cells in Excel have a character limit. I won't explain further because it's boring, but these cells aren't really useful to look at and are also hidden. The unit for TTK is seconds, and yeah, it uses the accuracy columns. Using seconds is still correct, but it refers to average time to kill, based on accuracy. E.g., it doesn't take people 4 shots and therefore only 0.255 (0.085*3) seconds to kill with an AK12 RIP because people miss shots. Technically, you could go to the modifiers sheet and set accuracy to 100%, and remove the recoil accuracy modifiers too, then it'd go back to being a pure TTK document. I guess I could make X amount of graph tabs, with their contents changing depending on which guns are selected. I haven't tried anything like that and I dunno if I could do it. However, the document isn't difficult for me to read, but obviously that's because I made it so I know what everything means. I've tried to make it as simple as possible though. I think I know what you mean when you say that situations are way too variable. However, the fact remains that every person has an average accuracy, and it makes more sense to use average accuracy than 100% accuracy. When I look at the document to compare guns, I don't do much scrolling back and forth. I look at the TTK overall, close, mid, and long columns. If I want to check and see why one of them has the number that it does, then I'll scroll along to check those columns, but most of the time I just trust that the modifiers are correct.
|
|