[X] My Assistant

Uh, the ehWiki explains how to calculate number of credits required for one training session, but how do I calculate several of them in a single equation?
For example, raising the Adept Learner from Level 11 to level 200 and the Ability Boost from 80 to 175?

This post has been edited by LostLogia4: Mar 23 2014, 09:04

Add them together?

That's the very basic concept, yes, but it's not very practical when you have to calculate all of them separately. I need a single equation or something like that to solve the problem.

This post has been edited by LostLogia4: Mar 23 2014, 11:33

(IMG:[sd.keepcalm-o-matic.co.uk] http://sd.keepcalm-o-matic.co.uk/i/keep-calm-and-use-excel-4.png)

(IMG:[sd.keepcalm-o-matic.co.uk] http://sd.keepcalm-o-matic.co.uk/i/keep-calm-and-use-excel-4.png)

Why, I JUST knew I would get this answer, so I used the VLOOKUP function... on an OpenOffice Calc. Converted that as xlsx format either way. Here it is, in a zip file.

[attachmentid=39246]
Note: Excludes Misc Posting (useless), Culinarian (insufficient data) and Gentleman (forbiddingly expensive).

This post has been edited by LostLogia4: Mar 24 2014, 04:52

That's the very basic concept, yes, but it's not very practical when you have to calculate all of them separately. I need a single equation or something like that to solve the problem.

You want a single equation ?

Like this ? (IMG:[invalid] style_emoticons/default/tongue.gif)

This post has been edited by Colman: Mar 23 2014, 13:25

^You almost beat Hujan with his 6 doubleposts.

You want a single equation ?

Like this ? (IMG:[invalid] style_emoticons/default/tongue.gif)

You should also add another factor which corresponds to different types of training. (IMG:[invalid] style_emoticons/default/tongue.gif)

And here's my version tailored at unix geeks (in R):

CODE

level <- function(max_level, base_cost, level_cost, exponent) {
  vec <- seq(0, max_level-1)
  round((vec*level_cost + base_cost)**(1 + exponent*vec))
}

costs <-
list(misc_posting     = c(  20,  5000,   100, 0.0280232009 ) ,
     adept_learner    = c( 300,   100,    50, 0.000417446  ) ,
     assimilator      = c(  10, 50000, 50000, 0.0058690916 ) ,
     ability_boost    = c( 500,   100,   100, 0.0005548607 ) ,
     power_tank       = c(  20,  2000,  1000, 0            ) ,
     scavenger        = c(  50,   500,   500, 0.0088310825 ) ,
     luck_of_the_draw = c(  25,  2000,  2000, 0.0168750623 ) ,
     quartermaster    = c(  20,  5000,  5000, 0.017883894  ) ,
     archeologist     = c(  10, 25000, 25000, 0.030981982  ) ,
     set_collector    = c(   4, 12500, 12500, 0            ) ,
     pack_rat         = c(   5, 20000, 20000, 0            ) ,
     refined_aura     = c(   4, 25000, 25000, 0            ) )

prices <- lapply(costs, function(x){ level(x[1], x[2], x[3], x[4]) })

Then

Adept Learner from Level 11 to level 200

is:

CODE

sum(prices$adept_learner[12:200])

And

Ability Boost from 80 to 175

is:

CODE

sum(prices$ability_boost[81:175])

(if anyone can be arsed to dump the script to the wiki next to the excel spreadsheet that's there, feel free (IMG:[invalid] style_emoticons/default/tongue.gif))

^You almost beat Hujan with his 6 doubleposts.

All because I couldn't upload the .xls file attachment with a slow-mo mobinternet. And did you mean a sextuple or septuple post, or just six separate doubleposts?
Btw, "Hujan" literally means rain in Indonesian language (and Malay language by extension), fyi.
Raining spams? anyone?

@blue_penguin
Never heard of "R" programming language till today, and the code looks quite lightweight.
I tried my luck in vb.net before, but no luck doing that with little programming experience.

As for the good-ol Excel spreadsheet with vlookup function, here's the v1.0 sheet.
[attachmentid=39246]
Note: Excludes Misc Posting (useless), Culinarian (insufficient data) and Gentleman (forbiddingly expensive).

This post has been edited by LostLogia4: Mar 24 2014, 06:49

Added the updated spreadsheet here.

Still excludes Misc Posting, Culinarian and Gentleman for usual reasons.

This post has been edited by LostLogia4: Mar 28 2014, 03:03

^You almost beat Hujan with his 6 doubleposts.

https://forums.e-hentai.org/index.php?showtopic=70184

This post has been edited by Beryl: Mar 28 2014, 03:13

You really overdid that one, Beryl.
I guess even mods have their own sense of humour.

This post has been edited by LostLogia4: Mar 31 2014, 04:28