The spreadsheet is pretty basic and self-explanatory, but for example the cost is 22 and success rate 50%. My formula for actual cost was just the (cost * % failure) + cost, or 150% of the cost = 33. That seems fine, but as it progresses and you get to an 80% chance of failure with cost of 36, that formula comes back with avg cost of 64.8, and that just doesn't seem correct at all.
Last edited by BeatBama; 03-03-2011 at 01:19 PM.
How about:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Thank you! Now it's a little higher than I expected, but it definitely makes more sense.
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks