Quote from: redphlegm on October 20, 2013, 10:32:09 PM

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

GodFader

Posts

Merits