I’ll start off by admitting two things. I love math and I love spreadsheets. The math thing goes back to when I was a kid, watching shows like Square One (and bonus points to anyone that remembers that show), but creating spreadsheets is definitely a new thing to me. So of course, any problems I need to solve are remedied by creating a spreadsheet.
Then crypto came into my life…
Now I enjoy creating the random scenario spreadsheet from time to time. If I had 30,000 Digibyte and the price went up to 0.03, what would my ending balance look like? Then if it went to 0.10 cents and so on…
About a month ago, I came across a website called coin-farm.net. This was through a random banner ad that looked interesting on some other crypto site I had just stumbled across (you know, one of those endless rabbit holes we get into where we’re trying to find the latest airdrop or upcoming project.) This site obviously has some slight language barrier issues (it's translated in Russian, if you'd prefer to use it like that). I’d like to explain the problem and then show you what I came up with…
Coin Farm is a website where you have birds that you purchase. Each bird lays eggs every minute (a different amount, depending on the bird). You can then sell the eggs to make money and start the process all over again. Each egg gets split, where 70% gets sent to your replenishment account (where you can spend to buy more birds) and 30% goes towards your withdrawal account (where you can actually redeem for Bitcoin). You can check back on your birds every day, week, month….doesn’t matter. The birds will continue to accumulate until you decide to collect and sell.
Seems pretty simple, right?
The chart above lays out how many eggs each bird lays. I also took the liberty of splitting up what those values mean between replenishment and withdrawal (per hour).
The spreadsheet I created will keep a working tally of your bird situation. In Row 10, you can enter how many of each color bird you have. The spreadsheet will then calculate how much each bird will create per hour in both replenishment and withdrawal.
For example, here is my current list of birds at the time of this article. This shows the amount I’m making each hour for replenishment if I don’t use ANY of the silver coins. The chart takes whatever is created every hour and continues to add to the previous total.
If you need some help with deciding how to divide up your coins to purchase birds, there is a calculator in the middle that will tell you how many silver coins you are using to purchase birds. But most importantly is below that. I have another calculator where you can manually type in what was left over from the previous day in both withdrawal and replenishment. At the end of 24 hours, the total for today is generated on the chart and an overall total is listed for the balance on both.
So you can purchase with Bitcoin, and there are perks for spending over a certain amount (but that’s at your own discretion). And while the website does have a slight language barrier, it's a fun little game to come back and check on your progress. If you guys do decide you'd like to give it a shot, feel free to use my affiliate link to help my progress move along a little faster too!
