What's new
By:
  • Visit Rebornbuddy
  • Visit Panda Profiles
  • Visit LLamamMagic
  • Visit Resources
  • Visit Downloads
  • Visit Portal

Hellcoms simple investment calculator

This puts things into a whole new perspective D:

Needing 115 hrs to just get +11 GF D:
 
aqh said:
This puts things into a whole new perspective D:

Needing 115 hrs to just get +11 GF D:
Click to expand...

Yeah, I actually did the calculations because I was curious how worthwhile it was to spend 40m on gear to attain 600-700k GPH and how long I would have to bot for in order to catch up to a 2m worth account doing 320-350k GPH. I have to say I was actually very surprised by the results though because already after 100 hours the 40m would be earned back on top of having catched up to the 2m investment. I'm guessing the sweet spot exists somewhere in between.
 
Hellcom said:
Yeah, I actually did the calculations because I was curious how worthwhile it was to spend 40m on gear to attain 600-700k GPH and how long I would have to bot for in order to catch up to a 2m worth account doing 320-350k GPH. I have to say I was actually very surprised by the results though because already after 100 hours the 40m would be earned back on top of having catched up to the 2m investment. I'm guessing the sweet spot exists somewhere in between.
Click to expand...

Well needless to say, you did a very fine job :p
 
aqh said:
Well needless to say, you did a very fine job :p
Click to expand...

Thanks ^^

Did a few extra changes, mostly cosmetic and uploaded a new screenshot. If anyone has ideas to improve user friendlyness please post here or PM me.
 
Love this! I am going to link this in my guide if you don't mind (link to this thread that is, so people can see this and +rep you!)
 
ahah yep, it gets harder if you have to factor in other stats aswell that might help you move or kill faster :)
 
zerinot said:
ahah yep, it gets harder if you have to factor in other stats aswell that might help you move or kill faster :)
Click to expand...

Actually I've been thinking of making some rought estimates for those as well. Starting to get a feeling for it now since I've made some comparisons on DH. And like movespeed moving from 12-25 can be counted as a 10% GPH increase or so while at least for core of arreat and that kind of farms you could probably figure a somewhat accurate number for the GPH increase you get with increased pickup radius as well.
 
The math appears to be wrong to me.

=(B3/B2)*(B2+B5) should be =(B3/(1+(B2/100))*(((B2+B5)/100)+1)

As is, if you have 0 GF and 1000 GPH then it would try to divide by 0 instead of 1. This causes the other values to be off as well.

Otherwise, useful spreadsheet and thanks!
 
Gomit said:
The math appears to be wrong to me.

=(B3/B2)*(B2+B5) should be =(B3/(1+(B2/100))*(((B2+B5)/100)+1)

As is, if you have 0 GF and 1000 GPH then it would try to divide by 0 instead of 1. This causes the other values to be off as well.

Otherwise, useful spreadsheet and thanks!
Click to expand...

Ah yes, thank you. I didn't take in to account that 250% MF is actually 350% because you also have the base of 100. Numbers looked more or less correct so I didn't notice it. Making the edit.
 
Badabump, I guess there's not much to discuss about this. But it's still useful ;) So no reason for it to hit page 10. If you like it feel free to bump ;P
 
Great excel for people who are gonna start up a bot char, or are new to the whole GF thing - Well done mate!
 
You must log in or register to reply here.
Back
Top