Bitcoin Forum
November 23, 2017, 06:13:31 AM *
News: Latest stable version of Bitcoin Core: 0.15.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: ~arklan US group-buy "Slacker's Wall of Shame"  (Read 1662 times)
tvbcof
Legendary
*
Online Online

Activity: 2324


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.


1511417611
Hero Member
*
Offline Offline

Posts: 1511417611

View Profile Personal Message (Offline)

Ignore
1511417611
Reply with quote  #2

1511417611
Report to moderator
1511417611
Hero Member
*
Offline Offline

Posts: 1511417611

View Profile Personal Message (Offline)

Ignore
1511417611
Reply with quote  #2

1511417611
Report to moderator
Remember that Bitcoin is still beta software. Don't put all of your money into BTC!
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1511417611
Hero Member
*
Offline Offline

Posts: 1511417611

View Profile Personal Message (Offline)

Ignore
1511417611
Reply with quote  #2

1511417611
Report to moderator
1511417611
Hero Member
*
Offline Offline

Posts: 1511417611

View Profile Personal Message (Offline)

Ignore
1511417611
Reply with quote  #2

1511417611
Report to moderator
1511417611
Hero Member
*
Offline Offline

Posts: 1511417611

View Profile Personal Message (Offline)

Ignore
1511417611
Reply with quote  #2

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

Activity: 623


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!