*** Solved.
*** Solved. If anyone would like a copy of the spreadsheet, join Slush's Pool and drop by our IRC. Look up "Eidolonius" or ask for a link to his site.
*** Solved.

The calculator atop your difficulty page is fabulous and it's really helped me get a handle on ROI for equipment purchases. To use it, however, I've got to hand copy difficulty predictions I make from my own spreadsheet into your form and hand-copy the BTC/mo result back. Any chance you'd be willing to share the equation with me so I can automate it?

The bottom part of my spreadsheet is this:

Date.....Difficulty.....MH/s......BTC/day

The top half of my spreadsheet generates the first two columns, I enter the third based on delivery dates of equipment. What I need is the formula for the fourth.

Put more simply, for a given Difficulty (D) and a given hashrate (H), what's the Excel formula to calculate BTC/day?

Thanks again for a great tool and double thanks if you can help me out with the math here.

Thanks,
D

P.S.: FYI, if you're considering adding more technical analysis tools, you might consider On Balance Volume next. I think that would be very useful to get a picture of the volume-based movement. (I do technical analysis of stocks for a living, so I especially appreciate having these tools applied to BTC.)


(Edit: Changed the desired output to BTC/day)