I found a quick and dirty solution for the #VALUE problem by runnig SEP.
- Open the VBA macro editor by pressing Alt-F11
- go into Module7 (it contains the Sub SEP() as first function)
- search for the comment 'MHSpd and comment out all its lines by adding a ' before it
- search for the comment 'OHSpd and comment out all its lines by adding a ' before it
- Save and run SEP
I don't know, what exactly it does and how it effects the result, but because the most weapons have a similar speed (3.3 in the most cases), the result should be good enought.