Bitcoin Forum
May 07, 2024, 07:37:13 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
  Home Help Search Login Register More  
  Show Posts
Pages: [1]
1  Bitcoin / Group buys / Re: [Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED! on: October 21, 2013, 04:05:10 AM
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
2  Bitcoin / Group buys / Re: [Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED! on: September 16, 2013, 04:39:32 AM
I bought 63.35 chips (5.1BTC before fees, 5.35 after fees)
return address:
1NgU5qj9Dh8JUSjonCrMPdJKm8vVqctnSf
3  Bitcoin / Group buys / Re: [Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED! on: April 28, 2013, 05:30:08 PM
info sent.
About the overpayment, I would be happy if you sent the BTCs that left to this address: 12Yu5SprMPRbCZVpMQCVKg7Q7XtCvevb5a

Thanks josh Smiley
4  Bitcoin / Group buys / Re: [Group Buy] Avalon ASICs CHIPS! Using JohnK as Escrow! Pledge reached!! on: April 22, 2013, 07:05:13 PM
5.1BTC sent
5  Bitcoin / Group buys / Re: [Group Buy] Avalon ASICs CHIPS! Using JohnK as Escrow! 600+ / 780 BTC pledged! on: April 20, 2013, 06:33:25 PM
Hey, I'm on the spread sheet for 5.125BTC, just want to know if i can add it to 5.277BTC just to include the shippment to Israel, and if I can do it should I transfer the extra ship payment to josh already ?
6  Other / Beginners & Help / Re: Why can't I reply in other forums posts? on: April 20, 2013, 06:15:51 PM
I have more than 5 hours, so this is probably about me not having 5 posts yet.

Thanks for replying so fast Smiley
7  Other / Beginners & Help / Why can't I reply in other forums posts? on: April 20, 2013, 05:49:20 PM
Topic
8  Other / Beginners & Help / Re: Hello from newbie on: April 20, 2013, 05:43:21 PM
lol, it's pretty sad to see so much posts like that just for having the option send PM's
9  Other / Beginners & Help / Re: What's your Mhash/s? (Pissing contest here) on: April 20, 2013, 05:28:13 PM
14.6MH/s with nvidi 525GTM (laptop)
10  Other / Beginners & Help / Re: Is BFL a scam? on: April 16, 2013, 05:03:21 PM
Nobody really knows.
It looks like it but for some reason there are alot of people who believes in this company.
Pages: [1]
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!