Download the template (File – Make a Copy):
How to Create an Ethereum Mining Calculator from Start to Finish
Use this template to automatically calculate Ethereum mining profits by hardware.
Setup: Download the free Google Sheets template in the video description to follow along. Click “File – Make a copy” to start your own calculator
Step 1: Download the Spreadstreet Google Sheets Add-in. Login with one of the four social logins.
Step 2: In cell D1 of the “Data” tab, pull in the ticker information from CoinMarketCap.
Step 3: In cell A1 of the “GPU” tab, pull in the stats endpoint from WhatToMine.
Step 4: In cell A1 of the “Equipment” tab, pull in the “Mining Equipment” endpoint from Cryptocompare.
Step 5: In the “Summary” tab, play around with the inputs to see how the yearly profit changes from different hardware and energy costs.
Best practices: Use “Insert” to prevent pinging the services API upon refreshes and reloads
Download the add-in: