Topic: [Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED! - page 11. (Read 150591 times)

Yeah I also dislike the idea of scripting this. 

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

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:

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

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:

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.

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

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.

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

Yay!  It has begun!

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

Thanks!

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.

Hey all,

My apologies for the delay - my restore of a secure operating system took longer than I expected, and am back for good now.

And no, I'm not stalling - I am desperate as you guys are to send out this refund for once and for all as I am absolutely gaining nothing (except angry PM's and the added risk) for holding the coins here. I am comparing the lists (RaginAzn Avalon Group Buy #1 Refund (Responses)and RagingAzn628 Group Buy) bigbeninlondon had kindly set up here, and have loaded the funds up to be sent ASAP.

Cheers,
John

Sorry, definitely not pissed at you. Just annoyed with the situation. It seems to me as though John K. has been stalling. Sorry if it came off as me being pissed at you. I'm grateful for what you are doing. I know it's a headache for you. I just don't understand why John hasn't made good on these refunds yet. And if he still needs something in order for that to happen, he needs to state what he needs, in plain english, so we can get this thing behind us already.

Great news!

John K is back.

I don't know about you guys, but I am excited to put this particular disaster behind me.

No need for drama guys, if you sent a tx for the extra btc, JohnK knows about those. Sign a message to him in PM with the original address and he will be able to verify you that way.

I wasn't accusing, but it's odd that your exact payment was paid to some address; I presume John K. set it aside.

Well why don't you do us all a favor and pound on John K for us all?

You probably have a lot more info on him than any of us

No. I did NOT get paid. John.K kept everything. I never received a single BTC from this GB. Go back to earlier posts to verify this.

This is something you'll have to check back with John K. about.  One thing I did notice is that after John K. paid for the chips, there were two additional transactions; one paying John K for his 11 some odd btc for the escrow service + 7.821 for Raging's Fee (Anyone know what happened to that by the way?  Here's the txid: 36905473f73a53874f81da80629be982ec269116e59c0ca723032f94e9aae149.  Did Raging already get paid?  Maybe that's why he doesn't mind "not getting his fee"?), and then another for 5.16 btc to this address: 16kbqtQNtLGvERubGS4QDmgLgv5fQAQcZy (tx id: e03868aa432c035196bd7476551ac5fafec8b7d5915b256c7385d778c5fa0528)

Is that yours?  Did you get your refund?  Maybe that's a reserve address where John K. parked your money.

You should still be in the original spreadsheet. You are not. All 10000 of the chips were accounted for by people listed there.

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing#gid=0

Therefore I can't see how you are entitled to a refund.

If you can sign with one of the original funding addresses that might be a different story, but that means you should control an alias in that list.

I'm an idiot about this I know... I sent my payment and then I got pulled in for a business trip that went to hell and I honestly have had a crazy life the past few months before I logged back in here.... Ugh. I never posted on this thread...