Spiral Knights - Help me build a SK Calculator

Help me build a SK Calculator

13 replies [Last post]

Sun, 10/28/2012 - 23:10

Thenewteddy

I've gotten started on one
http://www.filesend.net/download.php?f=ed01de02eaa166c8e852318917442c01
It has some quick reference charts, and, a mist calculator. It tells you when your mist will be full based on how much you have now.

I'd like to have it include more things, but I'll need some help, as I'm still new. I'm handy with excel and calculations, so just tell me what it needs and let me worry about the how.

NOTE
I've sent a few of you (good quality posters) a note in the mail if I thought/think you may know things that could help.

Mon, 10/29/2012 - 14:11

Rhea

Nice calculator. You can save

Nice calculator. You can save yourself a Worksheet if you change the formula to:

=(TIME(,(100-E2)*13.2,))+NOW()

(with "E2" being whichever cell you'll be inputting how much Mist currently have left)

My recommendation is to include a cell where people can input the current CE price. This way you can include:

- CE to CR
- CR to CE
- Total CR cost of crafting for each Star Level

You can also add unbind and recipe costs as references.

Mon, 10/29/2012 - 15:54

Thenewteddy

I'd like to add such things,

I'd like to add such things, do you know the amounts?

Mon, 10/29/2012 - 21:35

Kremurgh

-- insert titel --

Convert a CE price to a cr price
cr = ( [CE actual price] / 100 ) * [how many CE]
And the reverse case
CE = cr / ( [CE actual price] / 100 )

I have ton's of other exel stuff for SK but it's kinda useless :\
e.g. =(H112-H111)/108+NOW()
H111 is your actual EM, H112 is your needed EM. The result is the hour when you get the desired amount.

Tue, 10/30/2012 - 05:31

Thenewteddy

If you have 111 rows that

If you have 111 rows that must be some file!! Mind sharing? Perhaps together we could pump out something everyone would love?

Tue, 10/30/2012 - 08:19

Kremurgh

111-86=25

At the start I was trying hava a list for how many material I need to craft every itams I want. 86 mat + some random rows = 25 real rows.
And because it was for personal use I don't really care about lisibility, so it's realy hard to understand what stand for what. I'll try to make a clean, and annotated, version of it.

Tue, 10/30/2012 - 13:44

Rhea

These are the costs: * |

These are the costs:

* | Recipe | Crown | CE | Unbind --------------------------------- 5 | 25,000 | 5,000 | 800 | 4,000 4 | 10,000 | 2,500 | 400 | 1,800 3 | 4,000 | 1,000 | 200 | 600 2 | 1,000 | 400 | 50 | 200 1 | 250 | 200 | 10 | 10

Tue, 10/30/2012 - 16:11

Kremurgh

Stuff, not all stuff I've

Stuff, not all stuff I've made but I don't know what to add ... Ho I'm french so the formula maybe going to be corrupted >w<
Anyway my stuff, ask if you want something more :D
http://www.mediafire.com/?isg4jbdo6dcqm3z

... I should prevent: If you put a price in the "CE price" column the row take it for the CE price. And you only have to use gray tinted cell, all the rest is for result and stuff. (Except one, you will figure which easily ...)

~ Hope it help

Tue, 10/30/2012 - 17:31

Thenewteddy

I'll examine this in more

I'll examine this in more detail in a bit.

Anyone else have anything they feel might or could be useful?

Tue, 11/06/2012 - 19:35

Knight-Of-India

good

keep trying if this works out perhaps they will patch it best of luck

Thu, 11/08/2012 - 21:32

#10

Kremurgh

what ?

"they will patch it", they patch what ?

Mon, 11/19/2012 - 07:50

#11

Pawsmack

Uh...

I'll check if I have friends who know how to? Lol.

Mon, 11/19/2012 - 09:07

#12

Wolfe-Knight

This might be useful

As I do very little coding I am unable to help you in that respect, but I can provide you with this http://dl.dropbox.com/u/22735865/SpiralKnights_energycalc.htm, I have been using it for awhile and it seem to be very effective and simple in execution. Sorry I am unable to help further.

Tue, 11/20/2012 - 12:03

#13

Mohandar

Here.

Search

Help me build a SK Calculator