Post new topic Reply to topic  [ 19 posts ]  Go to page 1, 2  Next
Author Message
Content Dev
User avatar
Team: Star Revolution X
Rank: Operator
Main: Hober Mallow
Level: 3877

Joined: Wed Apr 09, 2008 3:08 pm
Posts: 3120
Post Spreadsheet Calculator
Alright so after tons of time and annoyance, I've finally finished the basic calculations. If you find any problems tell me!:

http://www.tinyurl.com/ss2calc I WOULD HIGHLY APPRECIATE IT IF PEOPLE WOULD TAKE THE TIME TO ADD STATS TO THE MAIN SHEETS!

The way it works is that there are a couple sheets with Augs/Shields/Ships/Energies, and in order to calculate anything you have to add the stats of the gear to those sheets. I will be working on adding more gear (Expanders and Solar Panels are things I plan on putting in asap) as time goes on.

The original document is not my own creation, was made by Andreas Simonsen. Wasn't completed and the math for Class Skills wasn't implemented, some of the math was wrong as well. I've been steadily fixing it up and trying to figure out how to put mods in. I know there are passive and active mods, and thats actually not a challenging thing to implement for things that you can only have one of :D ... Its the fucking modded weapons that I'm going to have to spend time implementing. Until then, make a copy and enjoy.

It is highly likely that I won't get around to adding mods, but I'll do the best I can to make some sort of progress towards it.

Alright, time to get back to writing papers.

_________________
Image


Mon Nov 24, 2014 7:47 pm
Profile
Content Dev
User avatar
Team: Star Revolution X
Rank: Operator
Main: Hober Mallow
Level: 3877

Joined: Wed Apr 09, 2008 3:08 pm
Posts: 3120
Post Re: Spreadsheet Calculator
Whoops, big problem with crit damage working on it now.

_________________
Image


Mon Nov 24, 2014 8:00 pm
Profile
User avatar
Team: Red Faction
Rank: Officer
Main: Tristana
Level: 3380

Joined: Wed Sep 29, 2010 10:14 pm
Posts: 5716
Post Re: Spreadsheet Calculator
Don't forget some classes can equip two capacitors!

_________________
Lemon Tristana Mercury Grape Banana
Cantaloupe Pear Raisin Melon Peach
Blueberry Mango Plum Jack Meiov babby spanch
Honeydew Apricot -wex- Raspberry


Mon Nov 24, 2014 10:27 pm
Profile
over 9000!
User avatar
Team: Traders
Rank: Director
Main: enkelin
Level: 5509

Joined: Wed Aug 01, 2007 12:28 pm
Posts: 11006
Post Re: Spreadsheet Calculator
Why not make the link view-only so people are encouraged to make copies?

_________________
(DefQon1) use a Rhino reconstruotereatarerer
-
(Pasta) I need to figure out how to get rid of this UrQa Suqqa Ukuk
(Bluenoser) Put your finger in your mouth and gag reflex should do the rest


Mon Nov 24, 2014 11:08 pm
Profile
over 9000!
User avatar
Team: Traders
Rank: Director
Main: enkelin
Level: 5509

Joined: Wed Aug 01, 2007 12:28 pm
Posts: 11006
Post Re: Spreadsheet Calculator
I suggest you add a stat for average DPS including critical hits.

Anyway, great job so far.

_________________
(DefQon1) use a Rhino reconstruotereatarerer
-
(Pasta) I need to figure out how to get rid of this UrQa Suqqa Ukuk
(Bluenoser) Put your finger in your mouth and gag reflex should do the rest


Mon Nov 24, 2014 11:14 pm
Profile
Content Dev
User avatar
Team: Star Revolution X
Rank: Operator
Main: Hober Mallow
Level: 3877

Joined: Wed Apr 09, 2008 3:08 pm
Posts: 3120
Post Re: Spreadsheet Calculator
anilv wrote:
I suggest you add a stat for average DPS including critical hits.

Anyway, great job so far.


The current DPS factors in crits.

anilv wrote:
Why not make the link view-only so people are encouraged to make copies?


Done.

ELITE wrote:
Don't forget some classes can equip two capacitors!


Hgggnnnnhhhhh

_________________
Image


Tue Nov 25, 2014 12:24 am
Profile
Content Dev
User avatar
Team: Star Revolution X
Rank: Operator
Main: Hober Mallow
Level: 3877

Joined: Wed Apr 09, 2008 3:08 pm
Posts: 3120
Post Re: Spreadsheet Calculator
Another update to the sheet

  • Reorganized some things and made it so all weapons have their end stats shown.
  • Multifiring is factored into all calculations. The sheet assumes you have the maximum amount of weapons possible equipped for each weapon.
  • Added spaces for chargers, expanders and capacitors.
  • Fixed an improper critical hit calculation. Critical hits should be properly calculated now.
  • Zen's for Range, Energy and Shield are incorporated in calculations as well.

_________________
Image


Tue Nov 25, 2014 12:33 pm
Profile
over 9000!
User avatar
Team: Traders
Rank: Director
Main: enkelin
Level: 5509

Joined: Wed Aug 01, 2007 12:28 pm
Posts: 11006
Post Re: Spreadsheet Calculator
A few quick questions that came to mind:

Are you considering ROF cap? Are the Lagrange skills in yet (related)?

_________________
(DefQon1) use a Rhino reconstruotereatarerer
-
(Pasta) I need to figure out how to get rid of this UrQa Suqqa Ukuk
(Bluenoser) Put your finger in your mouth and gag reflex should do the rest


Tue Nov 25, 2014 12:57 pm
Profile
Content Dev
User avatar
Team: Star Revolution X
Rank: Operator
Main: Hober Mallow
Level: 3877

Joined: Wed Apr 09, 2008 3:08 pm
Posts: 3120
Post Re: Spreadsheet Calculator
Working on adding control skills as we speak. Class got canceled today, so I figured I might as well get as much done as possible on this. Rate of fire on the calc was broken, and has been fixed. Since you mentioned it, I will add a check to make sure RoF does not go above the cap. If it goes above the cap, is the RoF wasted?

I just realized how much I changed, whoever made this calc didn't design it to be expanded easily. :shock:

EDIT: I don't think your copy of the sheet will update automatically, so you'll have to make a new copy of the original one. I will try to find a way to push the data to copies of the workbooks in the future. For now, if you add anything to any of the gear tabs you will have to remember to copy them into the relevant tabs in the updated Spreadsheets document.
I'll probably use this http://cloudlab.newvisions.org/scripts/sheetspider, but I need to figure out how to use it first :lol:

_________________
Image


Tue Nov 25, 2014 1:32 pm
Profile
Content Dev
User avatar
Team: Star Revolution X
Rank: Operator
Main: Hober Mallow
Level: 3877

Joined: Wed Apr 09, 2008 3:08 pm
Posts: 3120
Post Re: Star Sonata 2 Calculator
*deleted*

_________________
Image


Tue Nov 25, 2014 1:49 pm
Profile
over 9000!
User avatar
Team: Traders
Rank: Director
Main: enkelin
Level: 5509

Joined: Wed Aug 01, 2007 12:28 pm
Posts: 11006
Post Re: Spreadsheet Calculator
Compute R = expected ROF, and if it's over 10/sec then multiply your average DPS figure (which already has R multipled in) by 10/R to replace the expected ROF by the cap.

_________________
(DefQon1) use a Rhino reconstruotereatarerer
-
(Pasta) I need to figure out how to get rid of this UrQa Suqqa Ukuk
(Bluenoser) Put your finger in your mouth and gag reflex should do the rest


Tue Nov 25, 2014 4:19 pm
Profile
Team: Deep Space Federation
Rank: Councilor
Main: Rendghast
Level: 1423

Joined: Sat Jan 03, 2015 12:47 am
Posts: 442
Post Re: Spreadsheet Calculator
Noticed this on the newer shipbuilder thread. For some reason, i cannot get the berserker skills to work right on this sheet. Both Ordinance Supremacy and Arsenal Expert decrease my speed, and Imp Armor increases my damage? Am i doing it wrong or did someone mess the core sheet up?

_________________
Image
Image
Image


Mon Sep 28, 2015 2:33 am
Profile
Content Dev
User avatar
Team: Star Revolution X
Rank: Operator
Main: Hober Mallow
Level: 3877

Joined: Wed Apr 09, 2008 3:08 pm
Posts: 3120
Post Re: Spreadsheet Calculator
The way it works is that the skills go from top to bottom, the ones you pick from the drop down menu don't actually do anything.

Impervious Armor
Ordinance Supremacy
Arsenal Expertise

Is how it should look when you select them.

_________________
Image


Tue Sep 29, 2015 11:38 pm
Profile
Team: Deep Space Federation
Rank: Soldier
Main: Brugle
Level: 2676

Joined: Sun Feb 17, 2013 5:24 am
Posts: 362
Location: Norway
Post Re: Spreadsheet Calculator
MasterTrader please feel free to copy the data I have extracted from the wiki.
StarSonata items/equipment data

I have mapped the following items towards a list of Effects:
- Skills
- Overloaders
- Augmenters
- Shields
- Ships
- Engines
- Weapons
- Solar Panels
- Capacitors
- Diffusers
- Hull Expanders
- Radars
- Scoops
- Cloaks

Should in more or less be the same format as your file, since I'm still using the same logic. There might however be some changes on the effect names, but can be easily changed (please make a copy first).

There is also a worksheet stating the effects of the items modifications that can be applied with a bindomite, it is however just a work in progress at this time. I want it more in a database format.

Also please note I changed the Drone X operations and so forth to rather list the individual effects to temporary drones instead, i.e. Temporary Drone Shield, Temporary Drone Damage ....


Wed Sep 30, 2015 3:57 am
Profile
Content Dev
User avatar
Team: Star Revolution X
Rank: Operator
Main: Hober Mallow
Level: 3877

Joined: Wed Apr 09, 2008 3:08 pm
Posts: 3120
Post Re: Spreadsheet Calculator
I haven't edited this calculator in forever, mainly because I don't play this game very much anymore. If you want to make a copy of it and do some additions, feel free. I may come back one day, or get the urge to update it. But for right now I don't think I'll be touching the calculator in any meaningful way for quite some time. :wink:

_________________
Image


Wed Sep 30, 2015 11:03 am
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 19 posts ]  Go to page 1, 2  Next


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © phpBB Group.