Bitcoin Forum

Bitcoin => Bitcoin Technical Support => Topic started by: altcointalk14 on January 28, 2016, 08:02:28 PM



Title: excel file to make public bitcoin address
Post by: altcointalk14 on January 28, 2016, 08:02:28 PM
Hello,

Has anyone found an excel spreadsheet that you can enter your string of 256  ones & zeros and it would spit out the HEX format and the public address?


Title: Re: excel file to make public bitcoin address
Post by: DannyHamilton on January 29, 2016, 02:08:29 AM
Not aware of an Excel spreadsheet to do that, but I did write a simple C program that generates addresses from a WIF private key. It would be pretty simple to modify the program to work with 256 ones & zeros instead of a WIF key


Title: Re: excel file to make public bitcoin address
Post by: deepceleron on January 29, 2016, 02:42:45 AM
It would be tedious to write as you couldn't use numbers. Excel uses floats.

BIN2DEC() only supports 10 bits. HEX2DEC() only supports 40 bits.

even n = 115792089237316195423570985008687907852837564279074904382605163141518161494337 pasted into a cell:
1.15792089237316E+77

This guy made a spreadsheet that does SHA256 of some text, which is already impressive. It has about 80 sheets of formulas. https://bitcointalk.org/index.php?topic=809430.0