Search content
Sort by
Showing 10 of 10 results by GodFader
Re: [Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED!
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:
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
Re: [Group Buy] Avalon ASICs CHIPS! Using JohnK as Escrow! 600+ / 780 BTC pledged!
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 ?