Download the template (File – Make a Copy): https://docs.google.com/spreadsheets/d/1Kae1Lb2F8E3YddodS6V8W0mrlz4CQ1o5FAhDkYXvlz8/edit?usp=sharing
How to Create an Ethereum Mining Calculator from Start to Finish
Use this template to mechanically calculate Ethereum mining income by {hardware}.
Setup: Download the free Google Sheets template within the video description to observe alongside. Click “File – Make a copy” to start out your personal calculator
Step 1: Download the Spreadstreet Google Sheets Add-in. Login with one of many 4 social logins.
Step 2: In cell D1 of the “Data” tab, pull within the ticker data from CoinMarketCap.
Step 3: In cell A1 of the “GPU” tab, pull within the stats endpoint from WhatToMine.
Step 4: In cell A1 of the “Equipment” tab, pull within the “Mining Equipment” endpoint from Cryptocompare.
Step 5: In the “Summary” tab, mess around with the inputs to see how the yearly revenue adjustments from totally different {hardware} and vitality prices.
Best practices: Use “Insert” to forestall pinging the providers API upon refreshes and reloads
Download the add-in: https://spreadstreet.io/tools/google-sheets-add-in
Comments