Weaponchart with personalstats calculator - Preview

I’m making an excelsheet depending on Paul Christal’s Weaponchart and some addendums, which includes formulas about the personal damage provided by the item info.

Untill now you have to add your personal minimum dmg for every weapon you want to know. I want to develop it for easier handling with following ideas:

  • every weapon class gets its own sheet
  • possibility to fill in your personal stats for only one reference weapon (i.e. D-1 for rifle, 1x0 for LB and so on) and all other minimum damages for that weapon class are calculated automaticaly. But therefor I would need the stats from ppl with other skill levels…

Sadly I dont have the webspace to post a link to the complete excelsheet here :frowning: , so I can only provide you with a screenshoot of the actual version. But I hope it will give an impression.

https://www.planetcalypsoforum.com/gallery/files/2/0/3/4/Weaponchart.jpg

Note: basic assumption is average dmg=(max dmg/mindmg)/2

All hints, suggestions and support for advancenment are happily welcome :yup:

D1 is a bad example because it’s not that accurate to divide 8 by say 2.1. Could be accurate enough, but maybe a better choice would be a high-damaging common auction weapon. None come to mind but maybe MK2 and maybe one of the FireForges… Or maybe an option of each. Then someone could look into the auction item and check stats.

I have to yet check some other weapons and see if BLP seems to show a difference for me, compared to LWT. In pracice though, as far as I remember, that mattered a lot. My frequency may be correct but I seem to do more damage in the upper range for “favored” weapon types.