Bolide Banner
"BABYYYYY SHAAAAARK!"

Coin Birds: Calculating Profit and Purchasing Power

By LoonyLiberal | Dollars and Nonsense | 27 Dec 2020


BUILD A LITTLE BIRDHOUSE IN YOUR SOUL-TOSHIS

Having created a spreadsheet for tracking ChickHen data, I decided to do the same for Coin Birds. Yes, Coin Birds provides a profit calculator that clearly displays daily profits in terms of USD. However, I can't find a clear conversion rate from silver coins to USD. Also, knowing exactly when I can buy a premium bird is handy information.

Be warned that this spreadsheet is a bit more involved due to the way that Coin Birds presents data (or does not present data *coughTotalEggsPerHourCough*).


THE COIN BIRDS SPREADSHEET

Green cells indicate manually-entered data. Yellow cells indicate formulas. Significant numerical cells are formatted to display negative values as red text. I use the format code "NNNNMMMM DD, YYYY HH:MM AM/PM" to display dates and times.

Coin Birds Flock Productivity

Fig. 1: Calculating Eggs Per Hour and Eggs Per Day in Coin Birds is a Flocking Headache!

  • Price Per Bird: These manual fields are the current prices for each bird. Due to surprise sales, these values change periodically. Verifying and updating these values daily may be a worthwhile way to make my flock-enhancement methods worthwhile.
  • Number of Birds: These manual fields indicate how many birds of each type I own. Note that I excluded Super Birds. Unless I'm misunderstanding the game's mechanics, Super Birds produce one less silver coin per hour than King Birds, yet Super Birds cost twice as much as a King Bird. Are you flocking kidding me?!?
  • Hourly Eggs: Multiply the number of birds by their eggs-per-hour rate to determine how many eggs are generated. The eggs-per-hour for each bird type has not changed since I joined Coin Birds, so I feel safe in hard-coding those values in formulas.
    • Green: "=c2*5"
    • Yellow: "=c3*55"
    • Brown: "=c4*277"
    • Blue: "=c5*1430"
    • Red: "=c6*7230"
    • King: "=c7*21925"
  • Daily Eggs: Multiply the Hourly Eggs by 24 to determine how many eggs per day each bird type generates.
    • Green: "=d2*24"
    • Yellow: "=d3*24"
    • Brown: "=d4*24"
    • Blue: "=d5*24"
    • Red: "=d6*24"
    • King: "=d7*24"
  • Coins Per Day: "=SUM(e2:e7)/100". 100 eggs equals one silver coin, so dividing the daily total by 100 converts eggs to silver coins.
  • Last Management Date/Time: Manually entering the last time I managed my flock will allow me to calculate when I can buy premium birds and when I can withdraw.
  • Last Purchase Pool Balance: Manually entering the most recent value of the purchase pool will allow me to calculate when I can buy premium birds.
  • Last Withdrawal Book: Manually entering the most recent value of the withdrawal pool will allow me to calculate when I can make a withdrawal.

Coin Birds Purchasing Statistics

Fig. 2: Bird Seed Money

  • Daily Coins for Purchase: "=b9*0.7". Coin Birds places 70% of coins from egg sales into the purchase pool, so multiplying the daily coin earnings by 0.7 will calculate the daily contributions to the purchase pool.
  • Coins Needed for Next [Type]: The logic is the same for all six bird types: subtract the value of the current purchase pool from the cost of the bird type. If the value is negative, display the value in red for a visual cue.
    • King: "=b7-b12"
    • Red: "=b6-b12"
    • Blue: "=b5-b12"
    • Brown: "=b4-b12"
    • Yellow: "=b3-b12"
    • Green: "=b2-b12"
  • Days Until [Type]: The logic is the same for all six bird types: divide the coins needed to buy the bird type by the daily coins for purchase to determine how many days until a purchase is possible Decimal points are hidden but not discarded.
    • King: "=b17/b15"
    • Red: "=b21/b15"
    • Blue: "=b25/b15"
    • Brown: "=b29/b15"
    • Yellow: "=b33/b15"
    • Green: "=b37/b15"
  • Next [Type]: The logic is the same for all six bird types: add the number of days until next purchase to the date of the last login activity to calculate the date and time that the next purchase is possible.
    • King: "=b11+b18"
    • Red: "=b11+b22"
    • Blue: "=b11+b26"
    • Brown: "=b11+b30"
    • Yellow: "=b11+b34"
    • Green: "=b11+b38"

Coin Birds Cashout Calculations

Fig. 3: High Minimum Withdrawals Divided by Low Daily Profits Equals One Sad Loony Liberal

  • Daily Coins for Withdrawal: "=b9*0.3". Coin Birds puts 30% of silver coins from egg sales into the withdrawal pool. Multiplying the daily egg count by 0.3 shows how many silver coins are placed in the withdrawal pool each day.
  • Minimum BTC Withdrawal: Coin Birds provides both the minimum number of coins necessary to trigger a BitCoin withdrawal and the amount of Bitcoin that the withdrawal will provide.
  • Coins Until BTC Withdrawal: "=b43-b13". Subtract the current size of the withdrawal pool from the minimum withdrawal threshold to calculate how many more silver coins are necessary to qualify for a BitCoin withdrawal.
  • Days Until BTC Withdrawal: "=b44/b41". Divide the remaining coins needed for a BitCoin withdrawal by the coins added to the withdrawal pool each day. Decimal points are hidden but not discarded.
  • Next BTC Withdrawal: "=b11+b45". Add the number of days until BitCoin withdrawal to the date of the last activity to display the date and time when the BitCoin withdrawal is possible.
  • Minimum PayPal Withdrawal: Coin Birds provides both the minimum number of coins necessary to trigger a PayPal withdrawal and the amount of USD that the withdrawal will provide (before PayPal charges its fees).
  • Coins Until PayPal Withdrawal: "=b48-b13". Subtract the current size of the withdrawal pool from the minimum withdrawal threshold to calculate how many more silver coins are necessary to qualify for a PayPal withdrawal.
  • Days Until PayPa Withdrawal: "=b48/b41". Divide the remaining coins needed for a PayPal withdrawal by the coins added to the withdrawal pool each day. Decimal points are hidden but not discarded.
  • Next PayPal Withdrawal: "=b11+b50". Add the number of days until PayPal withdrawal to the date of the last activity to display the date and time when the PayPal withdrawal is possible.

DIVISION BY DODOS

Coin Birds provides some useful data, such as daily profits in USD and the value of withdrawals. However, those data points are not enough to answer questions such as "When can I make a BitCoin withdrawal?" or "When can I buy a King Bird?" Hopefully, this spreadsheet will make my Coin Birds experience easier.

Please leave a comment if you find a flaw in my logic or syntax or email me at [email protected] if you would like a data-free template for managing your own Coin Birds flock.

How do you rate this article?


1

0

LoonyLiberal
LoonyLiberal

I have 15 years of experience as a software tester. I've been writing off-and-on for 28 years. I adapt quickly to new technologies and new methodologies. And I believe that humor is the most important social skill.


Dollars and Nonsense
Dollars and Nonsense

Are you familiar with the phrase "funny money?" Finances are no laughing matter unless we make jokes about them. The purpose of this blog is to put a comedic slant on anything related to finances. Cryptocurrency, dollars, stocks, golden parachutes... if it goes ka-ching, I'll make it guffaw.

Send a $0.01 microtip in crypto to the author, and earn yourself as you read!

20% to author / 80% to me.
We pay the tips from our rewards pool.