I'm not fully done yet, but perhaps you might like what I did in Open Office here:
https://docs.google....M2pXaUxDbWJNMWcI would need to replicate all changes into the SP tab as well, the duplicate both tabs and make image versions of them but the formatting changes I made were (the most significant):
First the order of weapon types. By and far, SMG's and HP's are sidearm-esque weapons and should be slightly weakear backup kinds of weapons, being weaker, I moved them to the top. Pretty much the entire order is from fastest shooting overall/average weakest gun types to strongest cannon/single shot weapons (SMG to HP to AR to ShG to SnR)
Next: I made 3 new rows for all weapons for the shield, armor and barrier damage bonuses. This allows the data to appear more clearly and for calculations to be done easily via references (no need to input some number data manually because the sheet can't identify "115.7 (1.5x for shields)" to simply mean 115.7 damage
Next: I mentioned this before, the freeze mechanic. I removed all of the intermittent stat name column data and froze one, singular double row. For weapon stat names, there are 2 columns-worth of room for the name of the data. I used 2 so that weapon Mods could fit under the freeze window without also freezing the stats of w/e first weapon that was in the second column of all weapon rows.
I highlighted all of the DPS's as light grey for rank I DPS's and darker grey for rank X DPS's. For stats that affect the gun no matter what rank it is I highlighted in a color called "pale green." it stands out.
I tried to label some rows with a unit name, whether or not it was an easy conversion (I found that in Gdocs, if you highlight a row, and click format > numbers > currency, and at the very bottom click "custom currency" you can put in any text you want behind numbers, including manual units and have them display in all cells with numbers and if you click "right" it puts the "currency symbol" behind the data, so you can label a damage stat as "# damage")
Penetration, piercing and time-related stats should have the appropriate unit identifier attached.
If I remember any more changes I made or why, I'll let you know.
P.S. I tried to find ways (such as reference symbols like *) to remove long text and writing in individual weapon stat columns so they could become as thin as possible and hopefully fit as many cells/columns/data/stats on one screen as possible for ease of use without hurting the eyes. This is most prominent with the Hurricane and Harrier-related cells.
Modifié par blaze55555, 30 août 2012 - 06:27 .