## Camp CounselorEdit

### How to project the cost of reaching your next building goalEdit

At some point nearly every player has come to the realization that they have way too little income and need to stop leveling up until they pad their bottom line (a.k.a. "Camping"). Or they decide they need to pad their attack/defense stats by buying those types of buildings. But how long will that take? Because of the complexity of the building cost structure in the game, this is not easy to figure out, but it can be done.

1) Set a goal

First you have to decide on a goal. I’ve tried to keep to a simple formula for hourly income. I believe your net income (after maintenance) should at least be equal to whatever your level is in the game divided by 10 and multiplied by 1,000,000. So at level 10 your net income should be 1 million. At level 35 it should be 3.5 million and at level 100 it should be 10 million. But everyone has their own opinion on this, so you’ll have to decide for yourself what your target should be.

2) Determine building quantities for your goal

This is the hardest part. You have to project how many of each type of building you should buy to maintain equality and hit your target goal. The best way to do this is to set up a spreadsheet. Your spreadsheet should have a different line for each building type with columns set up for (A) income per building, (B) quantity of buildings, (C) total income from that building type, (D) cost of the next building, (E) cost / benefit ratio for that next building, and finally (F) the incremental cost for that building type.

- A: This should be obvious. 100 for farms, 450 for harbors, 560 for markets, etc.
- B: When the spreadsheet is setup, this number is what you will increase and decrease to determine your building quantities. Start by entering your current quantity for each building.
- C: Multiply A times B for total income from this building
- D: The cost of the next building is calculated by adding 10 to the quantity and multiplying by the increment value (ColumnB + 10) x ColumnF
- E: Divide column D by Column A to get your cost / benefit ratio.
- F: This is the increment for the building type. See the buildings page if you don’t already have it.

You should also have a total running for all lines in Column C to see the total income from all buildings. Now you can manipulate the quantities for each building type so that the cost benefit ratio (column E) is as close as possible for all buildings while still totaling up to your goal income. I recommend using the nearest column on the provided tables as a jumping off point.

Of course this can be done without a spreadsheet, but it will take you a long while. Keep in mind, there are plenty of free spreadsheet apps available for your Apple device. Learning to use them is just a matter of looking up how to enter formulas for that particular program. Only columns C, D, and E will require a formula, plus an extra one at the bottom of column C for a total of all lines above it.

To be sure your formulas are right, enter a quantity for farms of 1000. Your columns (Column G is explained in step 3) should now show as follows:

A | B | C | D | E | F | G | H |
---|---|---|---|---|---|---|---|

Income | Quantity | Total Inc. | Next Cost | Cost/Ben | Increment | Total Cost | Name |

100 | 1000 | 100,000 | 252,500 | 2525 | 250 | 127,375,000 | Farms |

3) Calculate the total cost to buy that specific quantity of each building

This can also be best done on your spreadsheet since the numbers are all already there. Just add another column (G) for each line. But if you don’t use one, you can still do this manually. First multiple increment (F) times 9. Then add the cost of the next building (D) and divide that total by 2 to get an average cost. Then multiply by the quantity (B) and you get your total cost. So your spreadsheet formula would look something like: ((F*9)+D)/2*B.

4) Calculate totals for existing buildings and projected buildings and subtract them.

This is pretty easy. Add up your totals (in column G) based on the formula in the previous step for all income buildings (or whatever type of building you are projecting). Then change your quantities back to your current number to get the total current cost and the difference between them is how much you have to earn (or farm) to buy enough buildings to reach your goal.

5) Divide the total of your projected cost by your income average

This is where I bet a lot of folks make a mistake. They divide the total projected cost by their current income to get how long it will take to get to their goal. But when you get near your goal your income will be higher than it is now so it will take less time than you’re projecting. The right way is to add your current income to what your projected income will be when you reach your goal and then divide by 2 to get an average. Then divide the cost of reaching your goal by that average to get how many hours it will take to get there.

6) Divide total hours to get days, weeks or months (…or years)

I really shouldn’t have to explain this, but if you want to convert that number of hours to days, weeks or months you divide by 24 to get days, then divide by 7 or 30 to get weeks or months. You could also divide by 365 to get years. But if that’s the case, your goal is WAY too high!