Bitcoin Forum
October 18, 2017, 06:31:19 PM
 News: Latest stable version of Bitcoin Core: 0.15.0.1  [Torrent]. (New!)
 Home Help Search Donate Login Register
 Pages: [1]
kiwiasian
Full Member

Offline

Activity: 168

 June 05, 2011, 03:16:02 PM

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.

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

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

www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
1508351479
Hero Member

Offline

Posts: 1508351479

Ignore
 1508351479

1508351479
 Report to moderator
1508351479
Hero Member

Offline

Posts: 1508351479

Ignore
 1508351479

1508351479
 Report to moderator
1508351479
Hero Member

Offline

Posts: 1508351479

Ignore
 1508351479

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

Offline

Posts: 1508351479

Ignore
 1508351479

1508351479
 Report to moderator
1508351479
Hero Member

Offline

Posts: 1508351479

Ignore
 1508351479

1508351479
 Report to moderator
CentroniX
Member

Offline

Activity: 109

 June 05, 2011, 03:39:35 PM

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

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

Activity: 168

 June 05, 2011, 03:42:23 PM

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

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

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.

www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
broker11
Jr. Member

Offline

Activity: 30

 June 05, 2011, 06:23:12 PM

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

Offline

Activity: 168

 June 06, 2011, 01:39:23 AM

Thanks

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

www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
kiwiasian
Full Member

Offline

Activity: 168

 June 06, 2011, 07:34:41 PM

Bump

I'm sure many can benefit from this

www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
kiwiasian
Full Member

Offline

Activity: 168

 June 08, 2011, 02:41:43 AM

Bump

www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
dlasher
Sr. Member

Offline

Activity: 468

 July 20, 2011, 07:57:29 AM

omoba4real
Newbie

Offline

Activity: 2

 June 29, 2017, 01:13:55 PM

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.

http://i.imgur.com/IVylp.jpg
http://i.imgur.com/lVABK.jpg

How to use
1. First, enter the date in the leftmost column. You can then drag the cell down to automatically create following dates.
http://i.imgur.com/WB67n.jpg
http://i.imgur.com/GeZqV.jpg

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.
http://i.imgur.com/Wk4rG.jpg

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.
http://i.imgur.com/jiOoT.jpg

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.

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

I hope you guys find this useful. Donate if you did.
-ck
Moderator
Legendary

Offline

Activity: 2310

Ruu \o/

 June 29, 2017, 01:56:50 PM