phelix
Legendary
Offline
Activity: 1708
Merit: 1020
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 09, 2011, 02:46:56 PM |
|
Updated to 1.3... includes all of JJG's suggestions and phelix's suggestion to include calculations for selling immediately (or in this case, daily, since hourly would be a bit insane and impractical.
Next update, I'm going to notate all of the calculations in comments on each calculated field, so that others can more easily double-check my work (and I can double-check it myself while writing out the notations as well).
I think you forgot to add/subtract some cells in the sums for "total net profit" and "total net profit daily" in version 1.3.
|
|
|
|
SgtSpike (OP)
Legendary
Offline
Activity: 1400
Merit: 1005
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 09, 2011, 03:15:41 PM |
|
Updated to 1.3... includes all of JJG's suggestions and phelix's suggestion to include calculations for selling immediately (or in this case, daily, since hourly would be a bit insane and impractical.
Next update, I'm going to notate all of the calculations in comments on each calculated field, so that others can more easily double-check my work (and I can double-check it myself while writing out the notations as well).
I think you forgot to add/subtract some cells in the sums for "total net profit" and "total net profit daily" in version 1.3. Hmmm... any idea what I am missing? I double checked it, and I did find one mistake in the net profit if traded daily... I wasn't including the uptime percentage in that calculation! Other than that though, everything looked good. To me, at least.
|
|
|
|
JJG
Member
![*](https://bitcointalk.org/Themes/custom1/images/star.gif)
Offline
Activity: 70
Merit: 20
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 09, 2011, 03:21:59 PM |
|
Yes you're right, i'm checking using the last few data points of difficulty increase. this is what i obtain ![](https://ip.bitcointalk.org/?u=http%3A%2F%2Fimg84.imageshack.us%2Fimg84%2F843%2Funledhl.png&t=665&c=Ajlz0kNW2ZgeRQ) around 1,7 mln difficulty for november, 6 months from now. i used the "gpu" historical data. To match this new value, i've to use 18% instead of 8.6% as "Expected average change in difficulty" in the spreadsheet. 18% is still going to give you way optimistic results, especially in the near term. You cannot use anything other than 40% if you want realistic results. If you're going to extrapolate that far out and assume that increases will fall in the future to 18%, then you're going to have to modify the spreadsheet to have a 'difficulty increase' that decreases by a % every month.
|
|
|
|
phelix
Legendary
Offline
Activity: 1708
Merit: 1020
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 09, 2011, 03:41:46 PM |
|
Updated to 1.3... includes all of JJG's suggestions and phelix's suggestion to include calculations for selling immediately (or in this case, daily, since hourly would be a bit insane and impractical.
Next update, I'm going to notate all of the calculations in comments on each calculated field, so that others can more easily double-check my work (and I can double-check it myself while writing out the notations as well).
I think you forgot to add/subtract some cells in the sums for "total net profit" and "total net profit daily" in version 1.3. Hmmm... any idea what I am missing? I double checked it, and I did find one mistake in the net profit if traded daily... I wasn't including the uptime percentage in that calculation! Other than that though, everything looked good. To me, at least. for short time frames the traded daily value gets much better than the stashed total profit. I think the cost of the cards is missing from the "total net profit daily". in the "total net profit" is the salvage hardware value included?
|
|
|
|
SgtSpike (OP)
Legendary
Offline
Activity: 1400
Merit: 1005
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 09, 2011, 03:51:07 PM |
|
You're right, thanks! The latest spreadsheet should fix all of those issues. Salvage value was not being included on the total net profit calculation, and initial capital expense was not being included in the total net profit if traded daily calculation.
|
|
|
|
sniper_sniperson
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 12, 2011, 10:41:59 PM |
|
Is it possible to lower the requirements for this spreadsheet ie to work on Excel 2003 without installing compatibility addon?
|
|
|
|
SgtSpike (OP)
Legendary
Offline
Activity: 1400
Merit: 1005
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 12, 2011, 10:46:10 PM Last edit: May 13, 2011, 06:33:20 AM by SgtSpike |
|
Is it possible to lower the requirements for this spreadsheet ie to work on Excel 2003 without installing compatibility addon?
Here you go: http://www.justinbporter.com/bitcoin_mine_or_invest_1.32.xlsIt gave a warning about the conditional formatting, so I'm not sure if the red/green highlights will still work, but the numbers themselves should be ok.
|
|
|
|
|
SgtSpike (OP)
Legendary
Offline
Activity: 1400
Merit: 1005
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 13, 2011, 06:33:32 AM |
|
Gah, my bad. Try it again.
|
|
|
|
phelix
Legendary
Offline
Activity: 1708
Merit: 1020
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 13, 2011, 11:28:30 AM |
|
With OpenOffice it works like a charm ![Cheesy](https://bitcointalk.org/Smileys/default/cheesy.gif)
|
|
|
|
|
SgtSpike (OP)
Legendary
Offline
Activity: 1400
Merit: 1005
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 13, 2011, 04:25:34 PM |
|
I'm refusing to install JRE ![Grin](https://bitcointalk.org/Smileys/default/grin.gif) Lolwut? Office requires JRE?
|
|
|
|
Raize
Donator
Legendary
Offline
Activity: 1419
Merit: 1015
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 13, 2011, 07:51:00 PM |
|
OpenOffice has and does. Although I think there is a way to install it without installing JRE as well if you're willing to unpack the installation files yourself.
|
|
|
|
DavinciJ15
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 24, 2011, 06:40:35 PM |
|
Your spreadsheet is very depressing. It's so easy to forget how fast an exponential growth moves, I guess that's how we got a debt based currency. In 6 months my 6 Giga hashes will get me 0.08 bitcoins per day!?
What makes no sense is bitcoins need to be $1000 in 6 months for me to continue mining.
|
|
|
|
SgtSpike (OP)
Legendary
Offline
Activity: 1400
Merit: 1005
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 24, 2011, 06:42:47 PM |
|
Your spreadsheet is very depressing. It's so easy to forget how fast an exponential growth moves, I guess that's how we got a debt based currency. In 6 months my 6 Giga hashes will get me 0.08 bitcoins per day!?
What makes no sense is bitcoins need to be $1000 in 6 months for me to continue mining.
Sorry to be the bearer of bad news... ![Sad](https://bitcointalk.org/Smileys/default/sad.gif) I would advise people against investing in new mining hardware at this point. It is still very profitable TODAY, but with the exponential growth not expected to decline any time soon, mining is going to have slim margins, at best, in the not-so-distant future.
|
|
|
|
darbsllim
Sr. Member
![*](https://bitcointalk.org/Themes/custom1/images/star.gif) ![*](https://bitcointalk.org/Themes/custom1/images/star.gif) ![*](https://bitcointalk.org/Themes/custom1/images/star.gif)
Offline
Activity: 297
Merit: 251
Founder, Filmmaker, Fun Guy
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 24, 2011, 06:49:55 PM |
|
Your spreadsheet is very depressing. It's so easy to forget how fast an exponential growth moves, I guess that's how we got a debt based currency. In 6 months my 6 Giga hashes will get me 0.08 bitcoins per day!?
What makes no sense is bitcoins need to be $1000 in 6 months for me to continue mining.
Thats why I think the best place to profit is with BitCoin Business Davinci =) BTW this is Brad from email we've been chatting back and forth about silver and bitcoins.
|
Brad Mills, Investor - Former miner - Former Bitcoin Business Owner - Survivor of the Great Bitcoin Crashes of 2011 and 2012, the MtGox Heist of 2014 & the 2017 crypto bubble. Bitrated user: bradmillscan.
|
|
|
Dobrodav
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 26, 2011, 05:53:03 AM |
|
404 errors.
|
|
|
|
SgtSpike (OP)
Legendary
Offline
Activity: 1400
Merit: 1005
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 26, 2011, 06:24:54 AM |
|
Should be fixed. I am in the middle of switching web hosts.
|
|
|
|
Tally-ho
Newbie
Offline
Activity: 19
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 31, 2011, 01:12:39 AM |
|
Very nice tool, thanks!
|
|
|
|
evlew
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 04, 2011, 11:11:05 PM |
|
cans someone explain the "expected average change in difficulty" and the "next difficulty starts in this many days" fields?
Thanks in advance. What are realistic numbers to plug in here?
|
|
|
|
|