[X] My Assistant

Do you imperil everything or only the SGs?

Everything in the later rounds.

// Edit2: Google Spreadsheet export as xlsx and custom functions added since noone will believe me anyway :P
 hv_drops_quantified.zip ( 9.46k ) Number of downloads: 24

I have hard time reading it since you don't comment each step, but I appreciate the effort.
Also, custom function? How to make it work? I've got #name error.

A question on optimization:
Suppose you have 1m credit to spend. And you kill about one thousand mobs a day. What's the best drop training configuration? Suppose you have another 1m credit to spend, what's the next drop training is the best for you (and so on)?

Truth to be told, 1m is a big deal for me. And with less than 2 turns per second, 1k of mobs is the highest number I can kill before I got bored.

I have hard time reading it since you don't comment each step, but I appreciate the effort.
Also, custom function? How to make it work? I've got #name error.

A question on optimization:
Suppose you have 1m credit to spend. And you kill about one thousand mobs a day. What's the best drop training configuration? Suppose you have another 1m credit to spend, what's the next drop training is the best for you (and so on)?

Truth to be told, 1m is a big deal for me. And with less than 2 turns per second, 1k of mobs is the highest number I can kill before I got bored.

Yeah, that's just quick 'n' dirty, plug some numbers in, get some numbers out and was better than doing it on paper (IMG:[invalid] style_emoticons/default/tongue.gif)

The #name error problem you have, is because i made it in google spreadsheets because i couldn't find out how to do recursive functions for the training cost calculations in excel (google spreadsheets lets you use javascript).

You can get a working version [docs.google.com] here. You will need to make a copy (computed values will show up once you edit a field) since the last time i published a spreadsheet someone went ahead and pretty much destroyed it. Sorry about that.
Red fields are either constants or computed by them, change the yellow fields to the values you want, the green fields will then show the output.

Regarding the optimization: i'd say plug in your values and play around a bit, maybe give scrolls and so on a value or adjust the bazaar price (hint: D14) (IMG:[invalid] style_emoticons/default/biggrin.gif)

- Assuming Scav 40 and QM 14 and Arch 5 and Crys 3, a kill is worth 15.52c at a total cost of 18,392,547.00c

So if I'm understanding that right:

15.52c - 4.65c base = 10.87c gained per kill

Need to kill 1,692,047 monsters for that amount of training to break even

Need to play around 2000 PFUDOR-fests for that amount of training to pay off (or many many years worth of daily arenas)

That's a bit much, even for someone like Cats. And there are still tens of millions of credits worth of training to go, which would take a whole lot longer to break even. Yet there are some people who've maxed their trainings...? Well, maybe if I was planning on playing for 5+ years (???), but still... is there something I'm missing?

So if I'm understanding that right:

15.52c - 4.65c base = 10.87c gained per kill

Need to kill 1,692,047 monsters for that amount of training to break even

Need to play around 2000 PFUDOR-fests for that amount of training to pay off (or many many years worth of daily arenas)

That's a bit much, even for someone like Cats. And there are still tens of millions of credits worth of training to go, which would take a whole lot longer to break even. Yet there are some people who've maxed their trainings...? Well, maybe if I was planning on playing for 5+ years (???), but still... is there something I'm missing?

I haven't try his script (spread sheet?), so I cannot be sure.
If he consider cost of repair and ED in the calculation, the net income should be around there.
Or is it the raw credits drop chance * average credits per drop?
I think the income (not net income) should be higher than that by selling equipment.

So if I'm understanding that right:

15.52c - 4.65c base = 10.87c gained per kill

Need to kill 1,692,047 monsters for that amount of training to break even

Need to play around 2000 PFUDOR-fests for that amount of training to pay off (or many many years worth of daily arenas)

That's a bit much, even for someone like Cats. And there are still tens of millions of credits worth of training to go, which would take a whole lot longer to break even. Yet there are some people who've maxed their trainings...? Well, maybe if I was planning on playing for 5+ years (???), but still... is there something I'm missing?

tenboro is well aware of psychological aspect (?)

So if I'm understanding that right:

15.52c - 4.65c base = 10.87c gained per kill

Need to kill 1,692,047 monsters for that amount of training to break even

Need to play around 2000 PFUDOR-fests for that amount of training to pay off (or many many years worth of daily arenas)

That's a bit much, even for someone like Cats. And there are still tens of millions of credits worth of training to go, which would take a whole lot longer to break even. Yet there are some people who've maxed their trainings...? Well, maybe if I was planning on playing for 5+ years (???), but still... is there something I'm missing?

Your calculations makes the wrong assumption that each fest has 850 monster (?), while it typically has around 8200 monsters. So you only need to clear ~200 fests. People like cats can do that much in 30 days

This post has been edited by holy_demon: Jun 15 2015, 04:00

Damn, dropped a 0 (IMG:[invalid] style_emoticons/default/tongue.gif) That makes sense then.

Your calculations makes the wrong assumption that each fest has 850 monster (?), while it typically has around 8200 monsters. So you only need to clear ~200 fests. People like cats can do that much in 30 days

There's a lot of things not figured in.
- The most obvious is that not everything will go to the bazaar, i only checked prices for average and sup equip that i had on hand, which were somewhere between 180-400c each. The difference to Exq+ should about cover repair costs and mag and leg can be sold in WTS, which doesn't factor in at all.
- Another thing i didn't factor in is the growth of crystal drops in fests, so probably even less will be needed. (currently assuming 3 * crystarium_bonus for every mob)
- Regular credit drops aren't counted since (according to the wiki) they stay the same regardless of training
- ED is roughly covered with precursor drops, if just as opportunity cost
- Definitively the biggest factor is the aforementioned "good drops" that can yield 5-20m+ at once. With maxed trainings you have a 1.2% chance of equipment drop from each monster, so a 8200 mob PFest would on average yield 98.4 pieces of equipment, probably 70% sup>25% exq > 4.9% mag > 0.1% leg (no those values are just guesstimates that aren't based on anything but my poor luck (IMG:[invalid] style_emoticons/default/smile.gif))

Is an element staff of element worth more than an element staff of destruction?

This post has been edited by qw3rty67: Jun 15 2015, 05:20

Few corrections:
-Max drop without training is 25% against 1250pl+ monster. Im not sure about 2.5 or 5 % scavenger gives now.
-(B12-B14)*0,001+B6*0,0001 probably mistake in arti, because training says +10% to base chance and you add it after all. Real chance looks like 0,15 or even 0,2% also. I d changed it to =(B12-B14)*(0,002+B6*0,0002)
- Average crystal price is closer to 4,6 credits.
-UPD. Correct pay back amount isnt training/drop also. Its (Loot-base loot).

After that only crystal perks gives 18 credits per mob
With full training and 2,5% scavenger 26,5 credits
With full training and 5% scavenger 28,9 credits



This post has been edited by nec1986: Jun 15 2015, 06:35

Few corrections:
-Max drop without training is 25% against 1250pl+ monster. Im not sure about 2.5 or 5 % scavenger gives now.
-(B12-B14)*0,001+B6*0,0001 probably mistake in arti, because training says +10% to base chance and you add it after all. Real chance looks like 0,15 or even 0,2% also. I d changed it to =(B12-B14)*(0,002+B6*0,0002)
- Average crystal price is closer to 4,6 credits.
-UPD. Correct pay back amount isnt training/drop also. Its (Loot-base loot).

After that only crystal perks gives 18 credits per mob
With full training and 2,5% scavenger 26,5 credits
With full training and 5% scavenger 28,9 credits

you will become the next skillchip , nec (IMG:[invalid] style_emoticons/default/laugh.gif)

(IMG:[invalid] style_emoticons/default/duck.gif)

by what level would you expect someone to have collected all ponies for OFC?

if your are wondering i only have 2 right now.

by what level would you expect someone to have collected all ponies for OFC?

if your are wondering i only have 2 right now.

Whenever you have the spare credits I'd assume.

by what level would you expect someone to have collected all ponies for OFC?

if your are wondering i only have 2 right now.

If your requirement is to find them for yourself instead of buying from other players, then 400+, maybe 430+. Depends on experience multipliers and battle type.

But I'd recommend buying OFC as soon as you have a halfway decent melee starting set, and play either DwD, grindfest, or IW regularly. (It's not that useful in normal arena)

by what level would you expect someone to have collected all ponies for OFC?

if your are wondering i only have 2 right now.

right now (IMG:[invalid] style_emoticons/default/laugh.gif)

you can open WTB to buy them , OFC very usefull for melee ~ other than 2H (IMG:[invalid] style_emoticons/default/laugh.gif)

This post has been edited by nobody_xxx: Jun 15 2015, 08:01

Few corrections:
-Max drop without training is 25% against 1250pl+ monster. Im not sure about 2.5 or 5 % scavenger gives now.
-(B12-B14)*0,001+B6*0,0001 probably mistake in arti, because training says +10% to base chance and you add it after all. Real chance looks like 0,15 or even 0,2% also. I d changed it to =(B12-B14)*(0,002+B6*0,0002)
- Average crystal price is closer to 4,6 credits.
-UPD. Correct pay back amount isnt training/drop also. Its (Loot-base loot).

After that only crystal perks gives 18 credits per mob
With full training and 2,5% scavenger 26,5 credits
With full training and 5% scavenger 28,9 credits

Thanks for paying attention, and i thought i only had to hide from skillchip (IMG:[invalid] style_emoticons/default/biggrin.gif)
- fixed the artifact thing, that actually seemed high to me before but i didn't dig deeper, thanks again
- adjusted crys price to 55k/cryspack
- made it a good bit more ugly(if that was even possible) to include unadjusted values

Regarding the first point, i'm just going with 5% for now since that's what's displayed (IMG:[invalid] style_emoticons/default/smile.gif)
I always assumed the PL bonus amounted to *0.015 for a total of 11.5% base drop... in case it's added is it added before or after scavenger? (IMG:[invalid] style_emoticons/default/tongue.gif)

I think it just sum.
For example i cleared 20 rounds arena (because all others is done and im lazy to do sg) and got:
8 draughts+pots
3 gears
9 times crystals
For 77 mobs 20 drops. Its not very accurate because low amount of samples, but drop chance is 25.9%. Pl bonus should be something like 12,5-13%, because sometimes i face even 800, but usually its near 1100. And other 13% is my ordinary drop+scavenger.

Maybe i ll collect a bit more samples.

Thanks for paying attention, and i thought i only had to hide from skillchip (IMG:[invalid] style_emoticons/default/biggrin.gif)
- fixed the artifact thing, that actually seemed high to me before but i didn't dig deeper, thanks again
- adjusted crys price to 55k/cryspack
- made it a good bit more ugly(if that was even possible) to include unadjusted values

Regarding the first point, i'm just going with 5% for now since that's what's displayed (IMG:[invalid] style_emoticons/default/smile.gif)
I always assumed the PL bonus amounted to *0.015 for a total of 11.5% base drop... in case it's added is it added before or after scavenger? (IMG:[invalid] style_emoticons/default/tongue.gif)

It should be 2.5% AFAIK.

Base drop chance is 10%
15% max PL bonus.
2.5% trainning bonus.

Additive.

This post has been edited by Colman: Jun 15 2015, 08:59

It always was 1% in training page?
Because i dont know exact.

This post has been edited by nec1986: Jun 15 2015, 09:21