To see the kind of UI and tools you're dealing with, I've taken to editing a copy of the most recent updated version.
I've done the following:
docs.google.com/spreadsheet/ccc?key=0AovrJmXi58nfdFBFdWtXRWVlQmxkYlJ1TlA1eHVReXca few things:
1. I first started by finding what seems to universally be called a "freeze" function and implemented it. Dunno why that term is used but for all intents and puroses, for data table programs it appears to be a solid standard word used for a given function I like which you may notice first: Dunno if this is necessary but I started by clicking the "B" for column "B" before I looked for the function as that's how it works in OpenOffice Spreadsheet; next, where I found it was under the "View" tab > Go to "Freeze Columns >" and click 1 column, or you can merge the columns 1 & 2 for the guns and freeze 2 columns (you'll have to add space between the stat names and guns) this allows the mod stats to also be frozen. That's it.
2. Next I noticed the 4/5 of the leftmost images reacted poorly, I suppose freezing that column made a hard edge which they could not cross, but were, as such, I merely moved them back into place.
3. I sought out all of those thick, pesky, stat-name columns, and cut&pasted the data following them over to the left until all of it was gone (as you don't use a universal column, say every 3 columns, for all guns, I had to do this manually, and unlike OOSpreadsheet, I could not highlight a Range and drag it with a mouseclick - I had to highlight a range, right-click > Cut, then find where I wanted the upper-left-most cell would end up, right-click in that cell, and click "paste." I did this the whole way across each weapon type until there was only the left-most column stating the names of the stats.
4. I believe my next step was shifting the images over to match the new positions of cells, however I did this simultaneously with 3.
5. I think the last thing I did was: I was a tad OCDically bothered by the fact that the row-coloring wasn't consistantly to the end of the column or to at least a specific column for all rows and all guns, so I merely went down the ~210 row line clicking each row number and clicking bg color > black/light blue (depending on the row I was deciding the color for)
I'm very appreciative of you retrieving this data, it's much-appreciated, and I hope I can help any format troubles/tediousnesses you have in the future, if you care to ask. I'm starting to get very intrigued with what one can do with some of these programs...
Edit: as google docs, though flushed out and awesome for a free online-office tools thingy, I find the UI less than perfect, so I have only so far edited sheet 1 for MP weapon stats with images.
Modifié par blaze55555, 20 août 2012 - 09:18 .
Retour en haut
supposing I equip a typhoon with an AP 5 mod; will the AP mod "override" the innate AP of the weapon? or will they stack? same question if I used AP ammo.
