Pikeman Archive

As I was going through my inventory and my bank vault last night I was getting irritated at the sheer number of weapons that I own. Both crafted and looted weapons take up a lot of space in my storage. I was trying to decide which ones to destroy, which ones to sell and which ones to keep. Then I realized that I didn.t realy know which ones were the best ones. Because I am also a Master Smuggler and like to slice my own weapons, I usually buy at least 5 of each kind of weapon when I buy them, and then try to weigh the best results.

I also know that as I progress through the pikeman skill tree I will have speed increases which will affect the DPS of my weapons. Earlier on I want speedier weapons, later on I want high damage weapons.

So I decided to make a spreadsheet for al of my weapons. It came out so nice that I decided to share it with pikemans everywhere! This isan early revision and might not have all the features everyone would want, but never fear I will be adding thigns to it as we go along. This requires a rudimentary knowledge of Excel to utilize. The spreadsheet can be found here:

http://www.velvetshadow.com/media/sebcaweaps.xls

notes:

I left my polearms in it so you could see how the calculations work. You are going to want to delete my entries and add your own. Don't delete the calculated cells, "DPS" and "True Speed" (columns A and I respectively) simply delete the other fields and type your own info in. The cells at the top of the spreadsheet allow you to put in your own speed mod and you can also change the damage and speed modifier to calculate yrou DPS with a particular special. Last, and most importantly, this spreadsheet will work with *any* weapon type, so if you like it you will probably want to add more rows. Remember to use the auto-fill feature in Excel (or copy and paste the formula) to make sure you have the formula in every row. (Example, hover your mouse over the A and I cell in the last row and then use the little 'plus' icon in the lower right corner of the cell to 'pull down' the formula to more rows.)

Anyway thanks for your time hope you enjoy and please give me any suggestions you might have.

Colonel Sebca En'wil
Master Bioengineer
Master Smuggler
Imperial Planetologist, Flurry
Exploiting the Galactic Ecosystem since 2003

get urself some new lances brotha'!

Colonel Sebca En'wil
Master Bioengineer
Master Smuggler
Imperial Planetologist, Flurry
Exploiting the Galactic Ecosystem since 2003