Lt. Commander
Join Date: Dec 2007
Posts: 120
# 151
12-08-2010, 07:39 AM
So, with the new totals information, I can see that as long as you have one power setting set to 100, you maximize power gains from efficiency. So, a setting of 100/50/25/25 will give you the same overall power gain as 100/40/35/25, or any other valid combination of 100/*/*/*. You can of course put the 100 in any power setting you want (Weapons, Shields, Engines, Aux).

Balanced, is the worst for efficiency. Balanced seems to be around 90% (some quick checks were around 90-92%) as efficient as any of the other power presets. Which isn't horrible, but still, when you are getting over 100 total gains, which is pretty easy, that's around a loss of 8+ power point gain that you could be getting from efficiency. More than can be compensated for by a console.

Going up to 75 as your highest power setting will net you the same results as using the Balanced setting. Using 80 starts closing the gap. So, if you're trying to reach a goal of having high power in two settings, like Shields and Aux, try to keep one above 75 at least. Your still losing power when you drop your highest power setting below 100, but it's not as bad.

I mention it because it's just not what I expected.

Also, Patrician, with the new Borg Universal Console that's going to be available for Season 3, that grants a +5 bonus to weapons(?), you may want to change up the Consoles section. Plus, I've seen that there's some other stuff that grants bonus power too, like a deflector dish that gives bonus Aux (pre-order reward I think).

If you change Console, to "Equipment" and then Plasma Distribution Manifold to +Weapon Power, etc. then people would know where to account for that bonus power. If you want, I could update that too, and upload and you could check it over and share on your server. Don't forget the tooltips (Comments) too if you get around to it.
Lt. Commander
Join Date: Dec 2007
Posts: 120
# 152 v2.4.0.b
12-08-2010, 02:07 PM
Alright, I went ahead and made the changes mentioned above to the Consoles section and tweaked the UI adding a Radio button for Efficient Captain and Joined Trill, so you can easily switch between the two if you're trying to decide on which traits/race for a new character. I also added a checkbox to the Efficient Engines option, the Warp Theorist trait so you can toggle them on or off with 1 click (instead of selecting the field, typing in y, and hitting enter).

Added some Data Validation too, and the Skill options can be done with a drop down, so, you can choose your skill level from 0-9 with a mouse, or just type it in like you did before. If you type in an invalid value, you get a warning. Same with the custom power fields.

The ship selection also got a drop down too, I turned off data validation on that though, as if you typed in lower case c, if gave a validation error (although your formula was okay with lower cases). So, typing in values works, as well as selecting from the drop down, but you can enter an invalid entry with no warnings.

I also changed the Efficient BO part so you just choose the number of Efficient BO's you have (0 to 5). Just a few less clicks to get what you want. If you type in a value above 5 though, you get a warning.

Moved Custom 1 to above Custom 2, as one of the columns it was using was resized, and Custom 1 and 2 were different widths which looked clunky. This also gives some space under the Misc area to add specific devices so they are only 1 click to toggle. Although, I noticed that the Efficient engine is integrated into the big math formula unfortunately, so it might be nicer to pull it out of there at some point and put it into the Ship bonus section so the big formula doesn't have to be modified if we want to add something under Misc.

I checked quite a few times to make sure I didn't break any of the maths.

I've also updated the About... section with the changes I've made.

EDIT: Had Efficient bonus set to 15, set it back to 10 (I thought it was 15, but don't have any confirmation handy).

EDIT: Just as a note, I'm mainly tweaking the spreadsheet with options I'd like to see added and just making it available to Patrician so he can check them out and use them, or not, as well as anyone else who might like the changes. This is not an official version by Patrician, this is just my tweaks as a fan of his work.

EDIT: Fixed the link so now it points to version b, which has the UI tweaks, had the link to version a which only had the addition of Total Raw Power gains.

EDIT: Okay, added the checkbox for Efficient Engines but forgot to modify the logic so it was added in. New upload now works.
Lt. Commander
Join Date: Dec 2007
Posts: 120
# 153 v2.4.0c
12-09-2010, 11:03 AM
Okay, here's a new version available. Again, this is a version I tweaked with changes I want to see and not an official Patrician version (Patrician is of course free to use it as he see's fit though).

This version is mostly a behind the scenes tweaking. I wanted to make it easier to add equipment, in case of future updates to the game that include equipment with bonuses to any of the power settings. What I did was take the power bonus calculation for all equipment (ship type, consoles and so far Efficient Engines) and did the math in the Equipment Gains section on the lower right. Then changed the formula in the Raw Gains section to get the bonus power from the Equipment Gains sum instead of looking all over for it.

It cleans up the formulas a bit, and most importantly, if you want to add something that gave, as a made up example, +5 power to Sheilds and +5 Power to Aux, you only have to modify the Equipment Gains section in those two fields, instead of what was done for the Efficient engines and checking for it in 6 different formulas for each power (in other words, I would of had to change 12 fields instead of 2 to add the imaginary +Shield/Aux console mentioned above).

I also checked the Shield Regen tab to make sure I didn't break anything there, and it looks good, no changes were needed.

Download version 2.4.0c:
Lt. Commander
Join Date: Dec 2007
Posts: 120
# 154
12-09-2010, 04:04 PM
It's always nice to see a creation gain legs of it's own. I'm pleased with your "Get 'er Done" attitude Malcivious. I do appreciate it. I haven't had a chance to look at the new versions you've posted until now, and here at work they've blocked my access to file sharing sites (ie GoogleDocs), so I can't download it here. So I still haven't seen 'em. Heh. I will try to find time by this weekend to grok your changes/suggestions. They sound most impressive!

I especially like the idea of radio buttons. I didn't know that could be done in Excel. I'm anxiously looking forward to seeing your file to deconstruct the method (and learn how it's done)!

I'd never thought about the Neodymium Deflector Dish Aux bonus, I don't have one and it's so seldom mentioned here on the forums (for example, no one's brought it up in this thread until now). Plus it was short-sighted of me to think they wouldn't later add other items that boost Ship's power (such as the Borg STF gear). I'm sure combining the ship equipment formulation is good thinking.
Lt. Commander
Join Date: Dec 2007
Posts: 120
# 155
12-09-2010, 08:18 PM
There's a Tutorial for Radio Buttons and Check Boxes here:

It's not exactly something you can just see and figure out how it was implemented. It's a bit clunky I think, since they don't actually reside inside a cell, but I think I implemented them in an decent way. My main goal was to make it easier to toggle values so you can decide how important a skill or device is by seeing the results with and without it quickly.

The latest version I made ship selection available by a drop down, but I don't think its overall better because, while it's nice to choose "Battle Cruiser" instead of looking at the key, and typing in BC, I don't really like the way the drop down boxes are working. When I click on a cell with a drop down box, I want it to expand automatically and allow me to choose my selection with a mousewheel, or arrow key, and that doesn't work. :| So as far as Ship Selection as a Drop Down List Box, I'm on the fence about that.

The data validation is nice though, because you don't have to check to make sure it's right in the formula, but as far as drop down functionality, it's not as smooth as I'd like.

EDIT: Also, all the latter versions have changes from the previous versions. I just kept a and b available in case there was something about the latest change(s) that you didn't like. So, c currently has all the changes I've implemented.
Lt. Commander
Join Date: Dec 2007
Posts: 120
# 156
12-22-2010, 10:54 AM
I'm working on a new Calculator that includes the Aegis and Borg gear, and the new KDF Nausicaan ship. There will be some other updates/changes that I'd been working on before too. I hope to have this out today, tomorrow at the latest.

Alas, I have been unable to see the check boxes/drop-downs in Malcivious' versions. According to the tutorial link he provided (thanks!), these features are from Office 2007, which I don't have access to at the moment. (I'm sorry, I only have Office 2000 at home and 2003 at work)
Lt. Commander
Join Date: Dec 2007
Posts: 120
# 157
12-22-2010, 10:45 PM
Now available: New version 3.0.0 of the Ship Power Calculator:
- Modified layout and arrangement to compensate for additions and future improvements.
- Added new Klingon ship:
- Nausicaan Guramba Siege Destroyer Innate: +10 Weapons, +5 Engines
- Nausicaan Guramba Siege Destroyer Siege Mode: +10 Weapons, +5 Shields, -5 Eng
- Added Aegis and Assimilated (Borg) Equipment Sets.
- Added "Info" link to STO Wiki for Efficient Impulse Engine and Sets.
- Renamed and modified "Skill Level Calc" page to support additional formulas.
- Reworked the formula tables on the new "Calculations" page.
- Moved instructions to the About page, and modified it's layout.
- Updated notes about respec to include Honor as a valid alternate currency.
- Made the Raw Power Gains easier to read by reducing the decimal places down to 2.
- Rearranged the Raw Power Gains charts to match the Power Settings. Added a "Total" field to display the overall amount of added power per setting.
- Restored some missing updates.
- Renamed the "Updates" zone to "Change Log"
- Various formula, phrasing, and display changes.
Let me know what you think of the changes...
Lt. Commander
Join Date: Dec 2007
Posts: 120
# 158
12-22-2010, 11:00 PM
Awesome! I can't wait to check it out when I get off work. Thanks for keeping up the great work!
Lt. Commander
Join Date: Dec 2007
Posts: 120
# 159
12-22-2010, 11:03 PM
Originally Posted by PatricianVetinari
Alas, I have been unable to see the check boxes/drop-downs in Malcivious' versions. According to the tutorial link he provided (thanks!), these features are from Office 2007, which I don't have access to at the moment.
Aww.. well foo. I didn't realize that was such a new feature. Well, the new changes sound great. I'll have to check it out.
Lt. Commander
Join Date: Dec 2007
Posts: 120
# 160
12-23-2010, 07:32 AM
Originally Posted by Victory275 View Post
Awesome! I can't wait to check it out when I get off work. Thanks for keeping up the great work!
You're welcome.

Originally Posted by Malcivious
Aww.. well foo. I didn't realize that was such a new feature. Well, the new changes sound great. I'll have to check it out.
Yeah! I couldn't be more disappointed, myself!! Radio buttons and drop-down boxes with validity checks... Those sounded great!

And dagnabbit! Thinking about you and your suggestions I just realized I forgot to add the Neodymium Deflector Dish you reminded me about! >slaps own forehead< DUH! ...I'll have to get that added asap.

Edit: Now available: New version 3.0.3 of the Ship Power Calculator:
- Added the Neodymium Deflector Dish to Ship Equipment (+8 Aux Power).
- Corrected a spelling error on the About page.
- Added a Title to the main page.
- Special thanks to Malcivious for his support and suggestions/inspirations.
12/27 Edit: Uploaded v3.0.3 fixing a broken formula in one of the Aux calculations.

With the v3 calculation/formula changes, it's much easier to add new items/ships now. (Thanks to Mal for the inspiration on that one.)
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

All times are GMT -7. The time now is 07:16 PM.