[Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED!

[bigbeninlondon]

Note that due to its fragmented nature, I am compiling a list here ( https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dHdIRGhHMG43N21raXJVSjA4dk5nUVE#gid=0) where those refunds I have confirmed via PM, original sheet and bigbeninlondon's sheet will be listed here. Those with conflicting amounts (i.e: PM'ed me stating 100 BTC but had 80 on other sheets) will be delayed at the moment.

Yay!  It has begun!

John, let me know if you need any clarification on anything.

Thanks!

[John (John K.)]

Note that due to its fragmented nature, I am compiling a list here ( https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dHdIRGhHMG43N21raXJVSjA4dk5nUVE#gid=0) where those refunds I have confirmed via PM, original sheet and bigbeninlondon's sheet will be listed here. Those with conflicting amounts (i.e: PM'ed me stating 100 BTC but had 80 on other sheets) will be delayed at the moment.

Yay!  It has begun!

John, let me know if you need any clarification on anything.

Thanks!

I'll PM you in a sec, there's indeed something I need to clarify here - thanks so much!!

[John (John K.)]

I am refunding based on the formula (chips * 782.1/10000) at the moment, and will sort out the issue with the fee etc later.

[John (John K.)]

Continuing this once I get back in about 1-2 hours and confirm something with bigbeninlondon.

[redphlegm]

I assume you'll be doing a sendmany transaction, John?

And Ben, I realize that anyone could fill out my form. This is why I wanted John to double check it in the end but it, like your form, got things a bit more organized. It didn't quite make it to generating a sendmany transaction from the results (which is what I wanted to accomplish), but between the two of us I would like to think it made John's job just a little bit easier.

Anyway, let me know if I can do anything else to push this along. One good thing has come of this whole ordeal - we know who has their heads up their asses and have found some more people who weren't known before who can actually pull some things together and may be good people to transact / work with in the future.

[redphlegm]

To aid you in the transaction, I have created the transaction that will take your data and require one small change to execute it. In column F, insert this formula and then drag it down to copy it to the rest of the rows that have addresses / amounts:

Code:

=concatenate("""",B2,"""",":",C2,", ")

Then somewhere else (doesn't really matter where - I put it in G2), put this:

Code:

=concatenate("sendmany ","""",""""," ","'","{",F2:F24,"}'"," 1 ","""","RaginAzn's Avalon Group buy 1 Refund","""")

Using those two in a copy of your spreadsheet, I generated this:
sendmany "" '{"1xbbjJcbeD4Qi88QmJmMgTFSdm7b5WCG4":5.013261,"1L5VE93qbbepo5CJtyeQaVF6sM8PnqrmPL":3.1284,"1QG2H6u9KvjyrgSpEB8sAQH2qzjUPDGmYp":5.013261,"19xZgcRduMiZENg8etHgW3R8KzakHGHvj":1.0026522,"1FKJzNP3bc81Ch2tchffKDs2J7Qj7cjmUN":5.013261,"17S1mgHyWHdpXSSDUtK9jY4Gpwi4sCeSAv":4.6926,"1NhSSrRW5Kqzki6TC2HVvHviEtQdxEBTeB":2.9008089,"17oDXLNifckeMjKk5CioRPHKu4txWAXPMG":1.0026522,"1Dq9q8MBbXFVSSHBtoysxnMwRzeG6rGtTo":6.64785,"1Ky1TKDV2cvHiNxE45sY4CfKyzkst8P4me":1.0026522,"174zoHrPuXNWVsRaNQYxYesihHYoKEKnsc":20.334600000000002,"1NpJWh55tae9Zd7VKRiWknVn8orDBDRi9V":50.1349563,"12hv7UcFgrBWLjWs5McPYP63Yza6ufT6Sw":23.463,"1GrEWEN9hMUAcKkCEtTKD6f2dQn68XKznt":2.0678724,"12KHW3i2Hamk1irY8b181N4vMXUnVYL1ah":4.0106088,"1HwrMG83oVJKABuLHouUvArCGsBuHqafTt":1.5305697,"1PVPGVQGfT8xiUYTNFkBxH7yRBQdUtNrvX":2.03346,"1Ki3sFg6bCasB6tkuMW41DCCpGFDgDHVgL":3.0079566,"17RXcRMUiXqsQkCqqYKXJkP1B4Lqm47hFB":1.0222047,"1CCa1scp5vLrbaha4MZ4sUFn3uboAjpRGX":20.053826100000002,"1F6WM3rjDzVDWRTMz5Q3pwU2T6dZ6Nrb9C":1.01673,"1Q1img1shsDS2sjy3781hpkSAW6eG1rUBm":39.105000000000004,"16SSPCBRxzaiXjA6XoCpq8tBvJdhoSSPmA":3.1635945,}' 1 "RaginAzn's Avalon Group buy 1 Refund"

The only thing to do to run it after that is to remove the comma before the closed curly bracket at the end (red, bold, and underlined). This is because it was a copied formula for the rest of the cells above it that contain the comma. Of course you can change the minconfirm (the 1 at the end) and the comment for the transaction.

Here's the code version with the unnecessary comma removed:

Code:

sendmany "" '{"1xbbjJcbeD4Qi88QmJmMgTFSdm7b5WCG4":5.013261,"1L5VE93qbbepo5CJtyeQaVF6sM8PnqrmPL":3.1284,"1QG2H6u9KvjyrgSpEB8sAQH2qzjUPDGmYp":5.013261,"19xZgcRduMiZENg8etHgW3R8KzakHGHvj":1.0026522,"1FKJzNP3bc81Ch2tchffKDs2J7Qj7cjmUN":5.013261,"17S1mgHyWHdpXSSDUtK9jY4Gpwi4sCeSAv":4.6926,"1NhSSrRW5Kqzki6TC2HVvHviEtQdxEBTeB":2.9008089,"17oDXLNifckeMjKk5CioRPHKu4txWAXPMG":1.0026522,"1Dq9q8MBbXFVSSHBtoysxnMwRzeG6rGtTo":6.64785,"1Ky1TKDV2cvHiNxE45sY4CfKyzkst8P4me":1.0026522,"174zoHrPuXNWVsRaNQYxYesihHYoKEKnsc":20.334600000000002,"1NpJWh55tae9Zd7VKRiWknVn8orDBDRi9V":50.1349563,"12hv7UcFgrBWLjWs5McPYP63Yza6ufT6Sw":23.463,"1GrEWEN9hMUAcKkCEtTKD6f2dQn68XKznt":2.0678724,"12KHW3i2Hamk1irY8b181N4vMXUnVYL1ah":4.0106088,"1HwrMG83oVJKABuLHouUvArCGsBuHqafTt":1.5305697,"1PVPGVQGfT8xiUYTNFkBxH7yRBQdUtNrvX":2.03346,"1Ki3sFg6bCasB6tkuMW41DCCpGFDgDHVgL":3.0079566,"17RXcRMUiXqsQkCqqYKXJkP1B4Lqm47hFB":1.0222047,"1CCa1scp5vLrbaha4MZ4sUFn3uboAjpRGX":20.053826100000002,"1F6WM3rjDzVDWRTMz5Q3pwU2T6dZ6Nrb9C":1.01673,"1Q1img1shsDS2sjy3781hpkSAW6eG1rUBm":39.105000000000004,"16SSPCBRxzaiXjA6XoCpq8tBvJdhoSSPmA":3.1635945}' 1 "RaginAzn's Avalon Group buy 1 Refund"

[DPoS]

that's nice and all, but this is a one and done event (the refund) so the time it takes to put together a script would be the same amount of time or more than just sending them out one by one

[ecliptic]

Yeah I also dislike the idea of scripting this. 

[RayJay]

Any idea why I am not in this new payout sheet ?
I filled out the from that was posted and verified my return address with bigbeninlondon.

[redphlegm]

Why is anyone against doing this? Don't you realize that this type of transaction is done all the time with mining pools, gambling sites, etc? It's not a script. It's a command built into the bitcoind protocol / API. Not only is it faster (eliminating doing each one individually), it also applies the mining fee to the one transaction (for everything) and not to each individual transaction. It's easier for John, cheaper for us, and faster for everyone.

There's no script. See here for sendmany: https://en.bitcoin.it/wiki/Original_Bitcoin_client/API_calls_list

[redphlegm]

that's nice and all, but this is a one and done event (the refund) so the time it takes to put together a script would be the same amount of time or more than just sending them out one by one

It doesn't take any time to put the command together. You can do it yourself and see. Open John's spreadsheet and then save a copy. Take the first bit of code, paste it into cell F2. Then select that cell, go to the bottom right corner where the plus sign shows up, and drag-copy it to all the cells below it in the rows that have content. After that, the second bit of code and paste it into G2 and press enter. Voila - you have the sendmany transaction with one extra comma. Copy the contents, remove the comma before the closed curly bracket, and press enter. Everyone's funds are sent in one transaction. This also saves time because only one transaction needs to be linked to everyone. We can see everything sent and John doesn't then have to copy / paste the transaction to every person - a time saver I neglected to mention initially.

Come to think of it, for as long as John has been doing escrow, I'd be surprised if he wasn't already familiar with sendmany. He might have already even used it.

[ecliptic]

Why is anyone against doing this? Don't you realize that this type of transaction is done all the time with mining pools, gambling sites, etc? It's not a script. It's a command built into the bitcoind protocol / API. Not only is it faster (eliminating doing each one individually), it also applies the mining fee to the one transaction (for everything) and not to each individual transaction. It's easier for John, cheaper for us, and faster for everyone.

There's no script. See here for sendmany: https://en.bitcoin.it/wiki/Original_Bitcoin_client/API_calls_list

Because you are doing this for the transfer of ~80,000$ and all it takes is one "whoops i made a typo sorry you're out 5000$ and you're not getting it back" or something else to go wrong, intentional or accidental

Less oversight for something like this is bad

what if the wrong person is listed?

Maybe you're right about TX but is a fee even required to get through on the current network?  i thought TX volume was far down from the peak

[Vycid]

Why is anyone against doing this? Don't you realize that this type of transaction is done all the time with mining pools, gambling sites, etc? It's not a script. It's a command built into the bitcoind protocol / API. Not only is it faster (eliminating doing each one individually), it also applies the mining fee to the one transaction (for everything) and not to each individual transaction. It's easier for John, cheaper for us, and faster for everyone.

There's no script. See here for sendmany: https://en.bitcoin.it/wiki/Original_Bitcoin_client/API_calls_list

Because you are doing this for the transfer of ~80,000$ and all it takes is one "whoops i made a typo sorry you're out 5000$ and you're not getting it back" or something else to go wrong, intentional or accidental

Less oversight for something like this is bad

what if the wrong person is listed?

Maybe you're right about TX but is a fee even required to get through on the current network?  i thought TX volume was far down from the peak

What? Typing them in one by one is magically less prone to error?

If we're super paranoid, John should ping 0.001 BTC to all of the addresses and confirm it's OK, THEN do the final send. But that seems unnecessary to me.

[ecliptic]

Why is anyone against doing this? Don't you realize that this type of transaction is done all the time with mining pools, gambling sites, etc? It's not a script. It's a command built into the bitcoind protocol / API. Not only is it faster (eliminating doing each one individually), it also applies the mining fee to the one transaction (for everything) and not to each individual transaction. It's easier for John, cheaper for us, and faster for everyone.

There's no script. See here for sendmany: https://en.bitcoin.it/wiki/Original_Bitcoin_client/API_calls_list

Because you are doing this for the transfer of ~80,000$ and all it takes is one "whoops i made a typo sorry you're out 5000$ and you're not getting it back" or something else to go wrong, intentional or accidental

Less oversight for something like this is bad

what if the wrong person is listed?

Maybe you're right about TX but is a fee even required to get through on the current network?  i thought TX volume was far down from the peak

What? Typing them in one by one is magically less prone to error?

If we're super paranoid, John should ping 0.001 BTC to all of the addresses and confirm it's OK, THEN do the final send. But that seems unnecessary to me.

Some of us are on edge because we have thousands of dollars in this and we've been going around in circles for weeks with different forms, confirmations, people gathering them, adjusting for chip transfers, people trying to scam/break said forms, etc.

maybe a send many is fine, but the last fucking thing that should happen is he finishes up this form and sends it out immediately

[Vycid]

Why is anyone against doing this? Don't you realize that this type of transaction is done all the time with mining pools, gambling sites, etc? It's not a script. It's a command built into the bitcoind protocol / API. Not only is it faster (eliminating doing each one individually), it also applies the mining fee to the one transaction (for everything) and not to each individual transaction. It's easier for John, cheaper for us, and faster for everyone.

There's no script. See here for sendmany: https://en.bitcoin.it/wiki/Original_Bitcoin_client/API_calls_list

Because you are doing this for the transfer of ~80,000$ and all it takes is one "whoops i made a typo sorry you're out 5000$ and you're not getting it back" or something else to go wrong, intentional or accidental

Less oversight for something like this is bad

what if the wrong person is listed?

Maybe you're right about TX but is a fee even required to get through on the current network?  i thought TX volume was far down from the peak

What? Typing them in one by one is magically less prone to error?

If we're super paranoid, John should ping 0.001 BTC to all of the addresses and confirm it's OK, THEN do the final send. But that seems unnecessary to me.

Some of us are on edge because we have thousands of dollars in this and we've been going around in circles for weeks with different forms, confirmations, people gathering them, adjusting for chip transfers, people trying to scam/break said forms, etc.

maybe a send many is fine, but the last fucking thing that should happen is he finishes up this form and sends it out immediately

I have 10.285 BTC in this, don't get haughty.

After weeks of collecting information, when exactly would you like this money to get refunded? I'm not clear on what you want to happen here.

Looks to me like the information is accurate for you anyway, so you'll get yours.

[bassclef]

Let's let John do this however he's most comfortable. I'm not listed on the new sheet, but I assume it's a work in progress.

Keep us updated.

[DPoS]

It doesn't take any time to put the command together. You can do it yourself and see. Open John's spreadsheet and then save a copy. Take the first bit of code, paste it into cell F2. Then select that cell,

and in the same cut and paste steps you send out each one by one ...  why be cute?

[Vycid]

It doesn't take any time to put the command together. You can do it yourself and see. Open John's spreadsheet and then save a copy. Take the first bit of code, paste it into cell F2. Then select that cell,

and in the same cut and paste steps you send out each one by one ...  why be cute?

Transaction fees, primarily. Doing it one by one doesn't change the risk of error at all.

That depends on John being comfortable with sendmany, of course. This is his show.

[ryepdx]

To aid you in the transaction, I have created the transaction...

...

Here's the code version with the unnecessary comma removed:

Code:

sendmany "" '{"1xbbjJcbeD4Qi88QmJmMgTFSdm7b5WCG4":5.013261,"1L5VE93qbbepo5CJtyeQaVF6sM8PnqrmPL":3.1284,"1QG2H6u9KvjyrgSpEB8sAQH2qzjUPDGmYp":5.013261,"19xZgcRduMiZENg8etHgW3R8KzakHGHvj":1.0026522,"1FKJzNP3bc81Ch2tchffKDs2J7Qj7cjmUN":5.013261,"17S1mgHyWHdpXSSDUtK9jY4Gpwi4sCeSAv":4.6926,"1NhSSrRW5Kqzki6TC2HVvHviEtQdxEBTeB":2.9008089,"17oDXLNifckeMjKk5CioRPHKu4txWAXPMG":1.0026522,"1Dq9q8MBbXFVSSHBtoysxnMwRzeG6rGtTo":6.64785,"1Ky1TKDV2cvHiNxE45sY4CfKyzkst8P4me":1.0026522,"174zoHrPuXNWVsRaNQYxYesihHYoKEKnsc":20.334600000000002,"1NpJWh55tae9Zd7VKRiWknVn8orDBDRi9V":50.1349563,"12hv7UcFgrBWLjWs5McPYP63Yza6ufT6Sw":23.463,"1GrEWEN9hMUAcKkCEtTKD6f2dQn68XKznt":2.0678724,"12KHW3i2Hamk1irY8b181N4vMXUnVYL1ah":4.0106088,"1HwrMG83oVJKABuLHouUvArCGsBuHqafTt":1.5305697,"1PVPGVQGfT8xiUYTNFkBxH7yRBQdUtNrvX":2.03346,"1Ki3sFg6bCasB6tkuMW41DCCpGFDgDHVgL":3.0079566,"17RXcRMUiXqsQkCqqYKXJkP1B4Lqm47hFB":1.0222047,"1CCa1scp5vLrbaha4MZ4sUFn3uboAjpRGX":20.053826100000002,"1F6WM3rjDzVDWRTMz5Q3pwU2T6dZ6Nrb9C":1.01673,"1Q1img1shsDS2sjy3781hpkSAW6eG1rUBm":39.105000000000004,"16SSPCBRxzaiXjA6XoCpq8tBvJdhoSSPmA":3.1635945}' 1 "RaginAzn's Avalon Group buy 1 Refund"

Thanks for putting that together, redphlegm.

[GodFader]

To aid you in the transaction, I have created the transaction that will take your data and require one small change to execute it. In column F, insert this formula and then drag it down to copy it to the rest of the rows that have addresses / amounts:

Code:

=concatenate("""",B2,"""",":",C2,", ")

Then somewhere else (doesn't really matter where - I put it in G2), put this:

Code:

=concatenate("sendmany ","""",""""," ","'","{",F2:F24,"}'"," 1 ","""","RaginAzn's Avalon Group buy 1 Refund","""")

Using those two in a copy of your spreadsheet, I generated this:
sendmany "" '{"1xbbjJcbeD4Qi88QmJmMgTFSdm7b5WCG4":5.013261,"1L5VE93qbbepo5CJtyeQaVF6sM8PnqrmPL":3.1284,"1QG2H6u9KvjyrgSpEB8sAQH2qzjUPDGmYp":5.013261,"19xZgcRduMiZENg8etHgW3R8KzakHGHvj":1.0026522,"1FKJzNP3bc81Ch2tchffKDs2J7Qj7cjmUN":5.013261,"17S1mgHyWHdpXSSDUtK9jY4Gpwi4sCeSAv":4.6926,"1NhSSrRW5Kqzki6TC2HVvHviEtQdxEBTeB":2.9008089,"17oDXLNifckeMjKk5CioRPHKu4txWAXPMG":1.0026522,"1Dq9q8MBbXFVSSHBtoysxnMwRzeG6rGtTo":6.64785,"1Ky1TKDV2cvHiNxE45sY4CfKyzkst8P4me":1.0026522,"174zoHrPuXNWVsRaNQYxYesihHYoKEKnsc":20.334600000000002,"1NpJWh55tae9Zd7VKRiWknVn8orDBDRi9V":50.1349563,"12hv7UcFgrBWLjWs5McPYP63Yza6ufT6Sw":23.463,"1GrEWEN9hMUAcKkCEtTKD6f2dQn68XKznt":2.0678724,"12KHW3i2Hamk1irY8b181N4vMXUnVYL1ah":4.0106088,"1HwrMG83oVJKABuLHouUvArCGsBuHqafTt":1.5305697,"1PVPGVQGfT8xiUYTNFkBxH7yRBQdUtNrvX":2.03346,"1Ki3sFg6bCasB6tkuMW41DCCpGFDgDHVgL":3.0079566,"17RXcRMUiXqsQkCqqYKXJkP1B4Lqm47hFB":1.0222047,"1CCa1scp5vLrbaha4MZ4sUFn3uboAjpRGX":20.053826100000002,"1F6WM3rjDzVDWRTMz5Q3pwU2T6dZ6Nrb9C":1.01673,"1Q1img1shsDS2sjy3781hpkSAW6eG1rUBm":39.105000000000004,"16SSPCBRxzaiXjA6XoCpq8tBvJdhoSSPmA":3.1635945,}' 1 "RaginAzn's Avalon Group buy 1 Refund"

The only thing to do to run it after that is to remove the comma before the closed curly bracket at the end (red, bold, and underlined). This is because it was a copied formula for the rest of the cells above it that contain the comma. Of course you can change the minconfirm (the 1 at the end) and the comment for the transaction.

Here's the code version with the unnecessary comma removed:

Code:

sendmany "" '{"1xbbjJcbeD4Qi88QmJmMgTFSdm7b5WCG4":5.013261,"1L5VE93qbbepo5CJtyeQaVF6sM8PnqrmPL":3.1284,"1QG2H6u9KvjyrgSpEB8sAQH2qzjUPDGmYp":5.013261,"19xZgcRduMiZENg8etHgW3R8KzakHGHvj":1.0026522,"1FKJzNP3bc81Ch2tchffKDs2J7Qj7cjmUN":5.013261,"17S1mgHyWHdpXSSDUtK9jY4Gpwi4sCeSAv":4.6926,"1NhSSrRW5Kqzki6TC2HVvHviEtQdxEBTeB":2.9008089,"17oDXLNifckeMjKk5CioRPHKu4txWAXPMG":1.0026522,"1Dq9q8MBbXFVSSHBtoysxnMwRzeG6rGtTo":6.64785,"1Ky1TKDV2cvHiNxE45sY4CfKyzkst8P4me":1.0026522,"174zoHrPuXNWVsRaNQYxYesihHYoKEKnsc":20.334600000000002,"1NpJWh55tae9Zd7VKRiWknVn8orDBDRi9V":50.1349563,"12hv7UcFgrBWLjWs5McPYP63Yza6ufT6Sw":23.463,"1GrEWEN9hMUAcKkCEtTKD6f2dQn68XKznt":2.0678724,"12KHW3i2Hamk1irY8b181N4vMXUnVYL1ah":4.0106088,"1HwrMG83oVJKABuLHouUvArCGsBuHqafTt":1.5305697,"1PVPGVQGfT8xiUYTNFkBxH7yRBQdUtNrvX":2.03346,"1Ki3sFg6bCasB6tkuMW41DCCpGFDgDHVgL":3.0079566,"17RXcRMUiXqsQkCqqYKXJkP1B4Lqm47hFB":1.0222047,"1CCa1scp5vLrbaha4MZ4sUFn3uboAjpRGX":20.053826100000002,"1F6WM3rjDzVDWRTMz5Q3pwU2T6dZ6Nrb9C":1.01673,"1Q1img1shsDS2sjy3781hpkSAW6eG1rUBm":39.105000000000004,"16SSPCBRxzaiXjA6XoCpq8tBvJdhoSSPmA":3.1635945}' 1 "RaginAzn's Avalon Group buy 1 Refund"

Hey, have you done this list by the new spreadsheet? because for some reason my return address isn't here