Board Thread:General Discussion/@comment-25087059-20140623045159

Because I have no life I decided to create a spread-sheet based income calculator which puts to use the data that has been collected on this site. The main benefit is that it allows you to see how modifying your collection frequency will affect income.

On the first sheet is a cell where you set the frequency of collecting, in hours. For example, if you collect every 2 hours, put 2. If you collect once a day, enter 24. Then, for every monster, it calculates income per bed per collection, days to breaking even on food cost, and allows you to enter what monsters you have on your islands to find out what your total collection should be each day, taking into consideration level and happiness.

On the second sheet is a dynamic chart which allows you to compare the income rates of different monsters to see how they compare.

Here are a few screen shots:

Calculator, Comparison Chart, Data Page

You can download it here: http://dropcanvas.com/hlllv/1

It will come preloaded with the data from my islands so you'll have an easier time seeing how it works.

Please be aware that the file is macro-enabled. I tried to do the whole thing using only formulas and no VBA code, but I was unable to dynamically refresh the comparison chart content based on user-selection without a small bit of code. You can always open it without enabling macros to inspect in case your paranoid, but I promise there's no virus. :) 