Bitcoin Forum
September 22, 2018, 04:30:54 AM *
News: ♦♦ New info! Bitcoin Core users absolutely must upgrade to previously-announced 0.16.3 [Torrent]. All Bitcoin users should temporarily trust confirmations slightly less. More info.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: ~arklan US group-buy "Slacker's Wall of Shame"  (Read 1673 times)
tvbcof
Legendary
*
Offline Offline

Activity: 2632
Merit: 1005


View Profile
May 10, 2013, 07:52:18 PM
 #1


I'm participating in this group-buy for USB miner sticks:

  https://bitcointalk.org/index.php?topic=195052.0

The buy is now closed and everyone would like to move on.  An amazingly high percentage of participants have paid, but there are some slackers.  These people need to put there money where their mouth is so they don't slow the process down for everyone else involved.  Obviously nobody wants to have any delays in obtaining these devices and getting them hashing.  Chop Chop people!

The organizer keeps a public spreadsheet and seems to keep it nicely up to date.  Here is a formula which shows who the slackers are:

https://docs.google.com/spreadsheet/tq?tqx=out:html&tq=select+A,B+where+D+%3D+''+&key=0AjCZrDbAiz_PdE4tbDR3X3owMHNMb1NyekJGWHN4QlE#gid=0

A permutation for unix or cygwin might look like this:

Code:
wget -qO- --no-check-certificate "https://docs.google.com/spreadsheet/tq?tqx=out:csv&tq=select A,B where D = '' &key=0AjCZrDbAiz_PdE4tbDR3X3owMHNMb1NyekJGWHN4QlE#gid=0"

Some people who have not been on this forum for a while may not realize or remember to look at the 'MY MESSAGES' thing on the blue bar up top there.  If it has a '[n]' by it, it means you have {n} unread messages.  If you do, please read them!

The organizer did not ask me to post this, and my not even agree that I should do so.  Nor do I personally really care about getting my single device at a high priority.  A lot of people are going totally ape-shit about it though.

One of the things which induced me to produce this OP is that many people do not realize that spreadsheets can be queried like this.  Publically accessible spreadsheets are enormously useful for coordinated projects.  The more people who realize that they can be dynamically queried, the more likely it is that the spreadsheets will be structured to make it more easy to do.

My formula above inaccurately pulls the bottom line which gives a misleading result.  It also leave out a slacker from 'NZ' because I didn't feel like trying to work out a text string match for 'payment' so I simply looked for a blank entry in one column.


1537590654
Hero Member
*
Offline Offline

Posts: 1537590654

View Profile Personal Message (Offline)

Ignore
1537590654
Reply with quote  #2

1537590654
Report to moderator
1537590654
Hero Member
*
Offline Offline

Posts: 1537590654

View Profile Personal Message (Offline)

Ignore
1537590654
Reply with quote  #2

1537590654
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1537590654
Hero Member
*
Offline Offline

Posts: 1537590654

View Profile Personal Message (Offline)

Ignore
1537590654
Reply with quote  #2

1537590654
Report to moderator
torusJKL
Hero Member
*****
Offline Offline

Activity: 621
Merit: 500


View Profile
May 11, 2013, 10:48:57 AM
 #2

Cool link.
Did not even know things like that where possible with Google docs.

If you find my post useful send some BTC: 167XM1Za8aG9CdbYuHFMpL2kvPsw6uC8da
Bitrated || bitcoin-otc || Moon Bitcoin Faucet
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!