Bitcoin Forum
December 04, 2016, 08:15:26 AM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Premade Excel spreadsheet to keep track of your Bitcoin earnings  (Read 2870 times)
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 05, 2011, 03:16:02 PM
 #1

So I've compiled this Excel spreadsheet for my personal use but thought I'd like to share with the rest of the Bitcoin community. This is a really handy way to keep track of your earnings and exchanges, with formulas embedded into the document to auto-calculate certain values. All you have to do is enter the pool you mined on, and the BTC you made that day.




How to use
1. First, enter the date in the leftmost column. You can then drag the cell down to automatically create following dates.



2. Enter the name of the pool you've been mining on.

3. Enter the MtGox rate that day. I always record my data at 6 PM every day so the results are consistent.

4. Enter the amount of BTC you've made that day. You can check whether or not you've mined for 24 hours by clicking the "Note" style on any 24 hr cell.

5. Enter the difficulty that day.

6. If you want, enter any notes that may be relevant to your mining statistics.

Auto-Computation Features
1. BTC is automatically highlighted green, yellow, or red based on if you had a lucky mining day, an average mining day, or a bad luck mining day, respectively. You might say, well as time goes by, difficulty goes up and I will make less BTC a day! So all the cells will become highlighted red..right?
I've made a formula to automatically compute the average of all the cells under the BTC column. If you look at cell O2, that is the BTC average for all the values in column D.


I have set up the following formula to determine how lucky your mining day is:
If your BTC/day is within a 0.2 BTC variance of the average, then your cell will be highlighted yellow.
If your BTC/day is higher than the average + 0.2 BTC, then your cell will be highlighted green.
If your BTC/day is lower than the average - 0.2 BTC, then your cell will be highlighted red.

This allows for the colors to be auto-updated based on a changing average.

2. The BTC sum is auto-calculated when you enter in values. The BTC sum is merely the total amount of BTC you've made thus far. However, the counter resets when you enter data in the "Exchange" column:

3. The Exchange column is used for entering data about a market exchange. For example, I recently exchanged 4.05 BTC at a rate of 15 USD/BTC on 5/31. Thus, I entered that data into that column. Whenever data is entered in that cell, the BTC sum will automatically reset (since you've sold all your BTC). You can, however, manually change the value of the BTC sum if you did not sell all of your bitcoins.


4. Graphs are automaticaly created and updated based on the values you enter. There are graphs for BTC/day, BTC sum, the rate, and the difficulty.

Download
http://www.share.cx/files/988415982015/Bitcoin_Statistics.xlsx.html

I hope you guys find this useful. Smiley Donate if you did.

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
1480839326
Hero Member
*
Offline Offline

Posts: 1480839326

View Profile Personal Message (Offline)

Ignore
1480839326
Reply with quote  #2

1480839326
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1480839326
Hero Member
*
Offline Offline

Posts: 1480839326

View Profile Personal Message (Offline)

Ignore
1480839326
Reply with quote  #2

1480839326
Report to moderator
1480839326
Hero Member
*
Offline Offline

Posts: 1480839326

View Profile Personal Message (Offline)

Ignore
1480839326
Reply with quote  #2

1480839326
Report to moderator
CentroniX
Member
**
Offline Offline

Activity: 109


View Profile
June 05, 2011, 03:39:35 PM
 #2

Thanks for this! Exactly along the lines of what I've been wanting, but too lazy to create myself.  Grin

Also, this works great in Numbers on the iPad. The only feature that appears ot to work is the color-highlighting. Graphs, calculations, etc all work as they should. Very cool!

cent
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 05, 2011, 03:42:23 PM
 #3

Thanks for this! Exactly along the lines of what I've been wanting, but too lazy to create myself.  Grin

Also, this works great in Numbers on the iPad. The only feature that appears ot to work is the color-highlighting. Graphs, calculations, etc all work as they should. Very cool!

cent

You're welcome Smiley

Also: since I'm a n00b at Excel, if anyone knows quite a lot about Excel--does anyone know how to take the first number in the "Exchange" column and subtract it from the BTC sum, so that you don't have to manually enter in the BTC sum if you don't sell all of your coins?

Edit: I've made a formula for a BTC sum cell like this:
Code:
=IF(I8>0, E7+D8-I8, E7+D8)

But as long as there is a value in the "Exchange" column other than a number, I get an error.

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
broker11
Jr. Member
*
Offline Offline

Activity: 30


View Profile
June 05, 2011, 06:23:12 PM
 #4

You could extract the first four numbers in column I using in J8:
=left(I8,4)
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 06, 2011, 01:39:23 AM
 #5

Thanks Cheesy

But I've decided against implementing the feature, since it varies how much BTC is exchanged (i.e. 2, 4.1, or 6.93)

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 06, 2011, 07:34:41 PM
 #6

Bump

I'm sure many can benefit from this

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 08, 2011, 02:41:43 AM
 #7

Bump

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
dlasher
Sr. Member
****
Offline Offline

Activity: 468



View Profile WWW
July 20, 2011, 07:57:29 AM
 #8


Page not found

This page may be in preparation, please check back in a few minutes.

Sad
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!