My spreadsheet calculator for suits, templates, ssi

[controlfive]

Making this was strangley fun, so I ended up developing it enough that some of you might get some use out of it. Some screenshots of each sheet in action:

http://i37.***********/28bffar.jpg
http://i34.***********/fjj8kz.jpg
http://i34.***********/9fqfk3.jpg


The first sheet totals up your mods, shows the difference between your values and the caps, and shows your stat totals after you input your base stats and your suit.

The second sheet is pretty simple, just a way to organize your template. Totals up the three columns: real skill, skill from items, and both real skill + items together.

The third sheet calculates your attack speed after you input your weapon speed, stam, and ssi. I made sure that the ticks rounded down to whole numbers and that 1.25 was the minimum attack speed value on this.


Download Links:
(New!) http://www.megaupload.com/?d=DI77TUMD
(Old!) http://www.megaupload.com/?d=TIK2C1OT

 

[HeathBar]

It looks great but may I suggest you put it on Google docs instead of hosting it on your current site? I'm a little weary of downloading things off unknown websites.

 

[Lynk]

I'm a little weary of downloading things off unknown websites.

Unless it's adult rated video clips!

 

[controlfive]

Dropbox is a legit site

I would use google docs for a dl link but apparently it uses an older version of excel and it's destroying 90% of my formatting, and even a couple of the formulas.

Compare http://spreadsheets.google.com/ccc?key=0AvX9fXuTUv6vdG5vU3pPTkdfSlprYlVuVUZ4LV9TbXc&hl=en with the screenshot :C

I put it up on megaupload: http://www.megaupload.com/?d=TIK2C1OT

If there's somewhere else you (or anyone else) prefer to download from, lemme know.

 

[Lynk]

If only there was a legal way to scan your character data, import it into the spreadsheet, and then have the spreadsheet perform the calculations on what you need on the rest of your gear to hit your desired stats/skills/lmc/lrc/etc.

 

[Flutter]

If only there was a legal way to scan your character data, import it into the spreadsheet, and then have the spreadsheet perform the calculations on what you need on the rest of your gear to hit your desired stats/skills/lmc/lrc/etc.

/sign

And Lynk your sig is too small. Make it more manly.

 

[Lynk]

I'm horrible with Paint. In fact I need to get new screenshots tonight for the new sig.

If anyone is good with sigs please message me

 

[popps]

If only there was a legal way to scan your character data, import it into the spreadsheet, and then have the spreadsheet perform the calculations on what you need on the rest of your gear to hit your desired stats/skills/lmc/lrc/etc.

UOAssist could help, perhaps ?

 

[Beer_Cayse]

looks slick, however I (and some others) have Office 2003. It appears you used Office 2007 - Excel 2003 barf on the conversion (even with the MS conversion pack) due to some cells apparently having more than 3 levels of conditional formatting. <shrug>

I'm going to work with it and see what - if anything - might have broken in the conversion.

 

[controlfive]

My bad, I don't have any experience with compatibility between 03 and 07, but judging by how it looks on google docs (which I guess is 03), it looks to be quite a bit different.

I don't think I have more than 3 conditional formatting on any cells, but I could be wrong.

There should be 2 on the bulk of the first sheet (C2:X30). Negative numbers get a light red background with a black border and positives get a light green background with a black border.

There should be one on the total column cells that give the cell a green/green highlight when the total reaches the cap.

There's 3 on the Difference column cells. One that makes the text greyed if the difference is equal to the cap*(-1), one that makes the text red if it's any other negative number, and one that makes the text green if it's >0.

I didn't use any conditional formatting on the stats area or the other two sheets.

Feel free to reup for the other 03ers if you can make it look presentable

 

[TheGhostRaider]

just download the ExcelViewer, from Microsoft. it free. No need to convert your document, just save then as 03 document instead. I have made up a spreadsheet to calculated the armor value and skill. this way Ic an build suit on paper. t help me make the pieces that I needs. Nice work on this one. I will give it a try.

 

[controlfive]

Bumping once more for an update in case anybody uses this, lol. I just added sheets for two extra suits and a sheet that imports all of the totals from the three suits to compare them side by side. I also added a graph for luck that lets you toggle whether or not you're using a luck statue and adds your luck statue bonus to the graph after you input your account age.

Screenshot:

http://i37.***********/2mqrreu.jpg

Download Link: http://www.megaupload.com/?d=DI77TUMD

 

[Artemyth]

Nice!