Board Thread:Plants vs. Zombies Heroes/@comment-27053902-20160729215549/@comment-3474455-20160730013702

MyopicCat wrote: Should you buy single packs or multipacks? And which multipacks are best, 1000 gem, 2000 or 5000 gem multipacks? I did the math, and the answer surprised me ...

Obviously there is no correct answer for everyone, it depends on how patient you are. But "how patient you are" can be quantified using the concept of "discount rate" from basic economics. (I should probably use the term "pure rate of time preference", but let's not muddy the waters too much). I made a spreadsheet that estimates your personal discount rate, and then calculates which pack type is optimal for your discount rate.

I consider myself a fairly patient person and was saving up to buy a 2000 or 5000 gem multipack. But it turns out that the best pack for me is the 1000 gem multipack. Yay for math (when it brings swift gratification)!

To try my spreadsheet out, click this link (it will prompt you to create a copy of my spreadsheet in you Google docs area). Answer the question at the top (fill in cell A5) and scroll down to row 29 to see the optimal pack type for your discount rate.

https://docs.google.com/spreadsheets/d/1Satm72kvGnbxG1toYGbflsngsymNGRu47VYFUXJA-Ug/copy

If you just want to check my calculations (view only mode), click this instead:

https://docs.google.com/spreadsheets/d/1Satm72kvGnbxG1toYGbflsngsymNGRu47VYFUXJA-Ug/edit Interesting...

I have tried your spreadsheets and here's my experience with it:
 * If I put 800 (which is the average earning for a free-to-play person within 8 days), the spreadsheet will tell me that the 5000 gem mega pack is still the best option. So in the end, the mega pack is still going to be the preferred choice, given that most of the players here are freeloaders.
 * When the gem amount begins to get absurdly high, things get confusing because the spreadsheet will tell you that the single pack is the best option. This gets absurd at the 40000 gem mark - when you get 5000 gems per day, the obvious choice is to buy a single mega pack, instead of wasting time clicking the single pack 50 times.

So yea you might wanna explain your calculations a bit. And maybe fix it.