Post new topic Reply to topic  [ 11 posts ] 
Author Message
User avatar
Team: Zephyr
Rank:
Main: Kval
Level: 2097

Joined: Mon Aug 26, 2013 6:47 am
Posts: 73
Post Some base maths in a spreadsheet
Made with openoffice, not sure if works with excel but can be used to quickly calculate things you may need in-game or cannot be bothered to work out.

Temporary Note on extraction rates!
[Commodities 0.67 / day / extractor]
[Nuke Waste 2 / min / extractor]
[All other 6 / min / extractor]

To enter the commodities one into the database (such as jelly beans or frozen blobs), the "0.00047" per minute will provide semi-accuracy.


http://i.imgur.com/JwVVnIn.png
there is a picture of him

http://www8.zippyshare.com/v/12368265/file.html
and here is the document

http://www54.zippyshare.com/v/27947282/file.html
and here is the .zip file containing the document for the extremely wary and untrusting.

How to use the spreadsheet:

Add in how many things you have or require where it asks and it will do the math for you. I may make the sheet more complicated in future to handle bigger things like math on augs and stuff but for now this will do (as my crests are nearly made!)

What are these links? I am skeptical. You have less than 3000 posts and no current contribution to our community. RAWR. (see beneath if you are of this kind)

Zippyshare is a filesharing site where you can share your things
imgur is an image uploading site where you can share your images


Last edited by kval on Tue Oct 01, 2013 12:42 am, edited 3 times in total.

Mon Sep 30, 2013 11:01 pm
Profile
over 9000!
User avatar
Team: Traders
Rank: Officer
Main: enkelin
Level: 5594

Joined: Wed Aug 01, 2007 12:28 pm
Posts: 11109
Post Re: Some base maths in a spreadsheet
Seems cool. For the extraction section it would be a nice improvement if you could hard-code the extraction rate of common commods instead of requiring the player to measure it and input that himself.

_________________
Hi, I'm Anil, a long-time player turned developer. I am Star Sonata's lead content developer, which means that I run weekly dev meetings and make sure that any proposed changes to the game receive proper review before going live.

http://www.starsonata.com/features


Mon Sep 30, 2013 11:41 pm
Profile
User avatar
Team: Zephyr
Rank:
Main: Kval
Level: 2097

Joined: Mon Aug 26, 2013 6:47 am
Posts: 73
Post Re: Some base maths in a spreadsheet
Yes he will be needing some updating, do you have any of these extraction rates?

Data is extremely difficult to collect with 1 character, no budget and a refusal to pay for a monopolized SM 20.

I do know that jelly beans, copper and vis seem to take a long time (around an hour) to make just one and i can only imagine this gets worse when it comes to frozen blobs and dark matter.


Mon Sep 30, 2013 11:52 pm
Profile
over 9000!
User avatar
Team: Traders
Rank: Officer
Main: enkelin
Level: 5594

Joined: Wed Aug 01, 2007 12:28 pm
Posts: 11109
Post Re: Some base maths in a spreadsheet
All basic commods except Nukes are 6/min, Nukes are 2/min. Most others are approximately 0.67 per day. There are a few exceptions like decayable commods and Psion Icicles but I am not sure how those work.

_________________
Hi, I'm Anil, a long-time player turned developer. I am Star Sonata's lead content developer, which means that I run weekly dev meetings and make sure that any proposed changes to the game receive proper review before going live.

http://www.starsonata.com/features


Mon Sep 30, 2013 11:59 pm
Profile
User avatar
Team: Zephyr
Rank:
Main: Kval
Level: 2097

Joined: Mon Aug 26, 2013 6:47 am
Posts: 73
Post Re: Some base maths in a spreadsheet
anilv wrote:
All basic commods except Nukes are 6/min, Nukes are 2/min. Most others are approximately 0.67 per day. There are a few exceptions like decayable commods and Psion Icicles but I am not sure how those work.

Are you sure about the commods / day? I am pretty sure overnight a total of 34 jelly beans were extracted with only 14 extractors on the base. Though i -am- extraction expert... It makes it extremely tricky to calculate.


Tue Oct 01, 2013 12:02 am
Profile
over 9000!
User avatar
Team: Traders
Rank: Officer
Main: enkelin
Level: 5594

Joined: Wed Aug 01, 2007 12:28 pm
Posts: 11109
Post Re: Some base maths in a spreadsheet
I am quite sure. And it's not tricky at all to adjust for ExE. Just divide by 0.935^L where L is the level you have in ExE.

_________________
Hi, I'm Anil, a long-time player turned developer. I am Star Sonata's lead content developer, which means that I run weekly dev meetings and make sure that any proposed changes to the game receive proper review before going live.

http://www.starsonata.com/features


Tue Oct 01, 2013 12:15 am
Profile
User avatar
Team: Zephyr
Rank:
Main: Kval
Level: 2097

Joined: Mon Aug 26, 2013 6:47 am
Posts: 73
Post Re: Some base maths in a spreadsheet
anilv wrote:
I am quite sure. And it's not tricky at all to adjust for ExE. Just divide by 0.935^L where L is the level you have in ExE.

Ah! But my level in ExE changed daily and that is the difficult factor. Now i no longer have bases in wild.


Tue Oct 01, 2013 12:19 am
Profile
Content Dev
User avatar
Team: JMC
Rank: Director
Main: Blue Dwarf
Level: 2061

Joined: Fri Apr 29, 2011 5:39 pm
Posts: 3336
Post Re: Some base maths in a spreadsheet
Extractors have a power rating and some extract faster (or slower) than others. Although most extractors have a power of 1, some have higher.

Also, build time is effected by multibuild discount. ;)

_________________
"What you mean you killed him cha cha cha?!"

Support


Tue Oct 01, 2013 11:35 am
Profile
User avatar
Team: Zephyr
Rank:
Main: Kval
Level: 2097

Joined: Mon Aug 26, 2013 6:47 am
Posts: 73
Post Re: Some base maths in a spreadsheet
Blue Dwarf wrote:
Extractors have a power rating and some extract faster (or slower) than others. Although most extractors have a power of 1, some have higher.

Also, build time is effected by multibuild discount. ;)

Gimme some numbers and ill work them in.


Tue Oct 01, 2013 6:07 pm
Profile
User avatar
Team: Perfect Nation
Rank: Director
Main: number666.5
Level: 3479

Joined: Wed May 03, 2006 4:12 pm
Posts: 3457
Location: nowhere
Post Re: Some base maths in a spreadsheet
Blue Dwarf wrote:
Extractors have a power rating and some extract faster (or slower) than others. Although most extractors have a power of 1, some have higher.

Also, build time is effected by multibuild discount. ;)

adv, earthforce, undead, normal fermium and xmas have 2 iirc
not sure about hte MB bonus thing, all i know atm it starts with 9 builds giving 1 free to the items/commods that it can. and it ends with 1k giving 300 free.
i have seen on our team forums somewhere the exact calculation for it, will take a look there

_________________
Valkyrie300 wrote:
You need to thoroughly think before sprouting exaggerated statements


Fri Oct 25, 2013 8:31 am
Profile
Content Dev
User avatar
Team: JMC
Rank: Director
Main: Blue Dwarf
Level: 2061

Joined: Fri Apr 29, 2011 5:39 pm
Posts: 3336
Post Re: Some base maths in a spreadsheet
lordjeroen wrote:
Blue Dwarf wrote:
Extractors have a power rating and some extract faster (or slower) than others. Although most extractors have a power of 1, some have higher.

Also, build time is effected by multibuild discount. ;)

adv, earthforce, undead, normal fermium and xmas have 2 iirc
not sure about hte MB bonus thing, all i know atm it starts with 9 builds giving 1 free to the items/commods that it can. and it ends with 1k giving 300 free.
i have seen on our team forums somewhere the exact calculation for it, will take a look there

It's actually 271 you get for free, but the calculation for that is on the wiki (and my IRC bot does it as a command: !savings (builds) [numItems]).

As for the power ratings, Advanced, Earthforce, Undead and Christmas Extractors don't all have a rating of 2. Although 2 is just about the highest you'll be able to find anywhere, maybe this should go in the stat string.

_________________
"What you mean you killed him cha cha cha?!"

Support


Fri Oct 25, 2013 12:45 pm
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 


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.