Difference between revisions of "Adafruit Order"

From ATXHackerspace

Jump to: navigation, search
(Jun Adafruit Order)
Line 1: Line 1:
__NOTOC__
+
<p>__NOTOC__
== Adafruit Wholesale Order  ==
+
</p>
 +
<h2> Adafruit Wholesale Order  </h2>
 +
<p>We get various discounts from Adafruit if we order $250 worth of stuff. It's the Adafruit wholesale discount! So, if you want to get in on an order, add your request to this page. When the total gets to be ~$250, the order goes in, and is delivered to the hackerspace.
 +
</p><p>There have been various non-paying people on the last couple orders. SO, in order to put the order in this time, when the order is complete we'll be taking the payments <i><b>BEFORE</b></i> placing the order. Sorry, but the hackerspace just can't absorb $70-100 in unpaid items.
 +
</p>
 +
<h2> Jun Adafruit Order </h2>
 +
<table border="2" align="center" id="orderTable">
  
We get various discounts from Adafruit if we order $250 worth of stuff. It's the Adafruit wholesale discount! So, if you want to get in on an order, add your request to this page. When the total gets to be ~$250, the order goes in, and is delivered to the hackerspace.
+
<tr>
 
+
<th scope="col"> ITEM#
There have been various non-paying people on the last couple orders. SO, in order to put the order in this time, when the order is complete we'll be taking the payments '''''BEFORE''''' placing the order. Sorry, but the hackerspace just can't absorb $70-100 in unpaid items.
+
</th>
 
+
<th scope="col"> DESCRIPTION
== Jun Adafruit Order ==
+
</th>
 
+
<th scope="col"> QTY
{| border="2" align="center" id="orderTable"
+
</th>
|-
+
<th scope="col"> COST
! scope="col" | ITEM#  
+
</th>
! scope="col" | DESCRIPTION  
+
<th scope="col"> DISCOUNT_COST
! scope="col" | QTY  
+
</th>
! scope="col" | COST  
+
<th scope="col"> TOTAL
! scope="col" | DISCOUNT_COST  
+
</th>
! scope="col" | TOTAL  
+
<th scope="col"> MEMBER
! scope="col" | MEMBER
+
</th></tr>
|-
+
<tr>
| 170  
+
<td> 170
| [http://www.adafruit.com/products/170 Adafruit ARDX - v1.3 Experimentation Kit for Arduino (Uno R3) - v1.3]
+
</td>
| 1  
+
<td> <a href="http://www.adafruit.com/products/170">Adafruit ARDX - v1.3 Experimentation Kit for Arduino (Uno R3) - v1.3</a>
| $85.00  
+
</td>
| &nbsp;$68.00  
+
<td> 1
| $68.00  
+
</td>
| Shadow
+
<td> $85.00
 
+
</td>
|-
+
<td> &#160;$68.00
| 454
+
</td>
| [http://www.adafruit.com/products/454 Miniature 8x8 Red LED Matrix]
+
<td> $68.00
| 50  
+
</td>
| $3.56  
+
<td> Shadow
| &nbsp;$2.40  
+
</td></tr>
| $120.00
+
<tr>
| Christian Miller
+
<td> 454
 
+
</td>
|-
+
<td> <a href="http://www.adafruit.com/products/454">Miniature 8x8 Red LED Matrix</a>
| 259
+
</td>
| [http://www.adafruit.com/products/259 USB LiIon/LiPoly charger - v1.2]
+
<td> 50
| 1  
+
</td>
| $12.50
+
<td> $3.56
| &nbsp;OUT OF STOCK  
+
</td>
| ~$12.50  
+
<td> &#160;$2.40
| Jonathan Kelly
+
</td>
 
+
<td> $120.00
|-
+
</td>
|459
+
<td> Christian Miller
|[https://www.adafruit.com/products/459 Bi-Color (Red/Green) 12-LED Bargraph - BL-AR12Z3010DUG-11]
+
</td></tr>
|8
+
<tr>
|$1.95
+
<td> 259
|&nbsp;$1.35
+
</td>
|$10.80
+
<td> <a href="http://www.adafruit.com/products/259">USB LiIon/LiPoly charger - v1.2</a>
|Steven Noreyko
+
</td>
|-
+
<td> 1
|861
+
</td>
|[https://www.adafruit.com/products/861 Miniature 8x8 Green LED Matrix - BL-M07C881UG-11]
+
<td> $12.50
|2
+
</td>
|$3.95
+
<td> &#160;OUT OF STOCK
|&nbsp;$2.80
+
</td>
|$5.60
+
<td> ~$12.50
|Steven Noreyko
+
</td>
|-
+
<td> Jonathan Kelly
|881
+
</td></tr>
|[http://www.adafruit.com/products/881 Adafruit 0.56" 4-Digit 7-Segment Display w/I2C Backpack - Blue]
+
<tr>
|1
+
<td>459
|$11.95
+
</td>
|&nbsp;$8.40
+
<td><a href="https://www.adafruit.com/products/459">Bi-Color (Red/Green) 12-LED Bargraph - BL-AR12Z3010DUG-11</a>
|$8.40
+
</td>
|Steven Noreyko
+
<td>8
|-
+
</td>
|284
+
<td>$1.95
|[https://www.adafruit.com/products/284 FTDI friend + extras v1.0]
+
</td>
|1
+
<td>&#160;$1.35
|$14.75
+
</td>
|&nbsp;$10.50
+
<td>$10.80
|$10.50
+
</td>
|Jessica Ross
+
<td>Steven Noreyko
|-
+
</td></tr>
|418
+
<tr>
|[https://www.adafruit.com/products/418 Arduino Uno Ethernet]
+
<td>861
|1
+
</td>
|$65.00
+
<td><a href="https://www.adafruit.com/products/861">Miniature 8x8 Green LED Matrix - BL-M07C881UG-11</a>
|&nbsp;$65.00
+
</td>
|$65.00
+
<td>2
|Jessica Ross
+
</td>
|-
+
<td>$3.95
|175
+
</td>
|[https://www.adafruit.com/products/175 Music & sound add-on pack for Arduino - v1.1]
+
<td>&#160;$2.80
|1
+
</td>
|$35.00
+
<td>$5.60
|&nbsp;$35.00
+
</td>
|$35.00
+
<td>Steven Noreyko
|Jessica Ross
+
</td></tr>
|-
+
<tr>
|14
+
<td>881
|[https://www.adafruit.com/products/14 MintyBoost Kit - v3.0]
+
</td>
|1
+
<td><a href="http://www.adafruit.com/products/881">Adafruit 0.56" 4-Digit 7-Segment Display w/I2C Backpack - Blue</a>
|$19.50
+
</td>
|&nbsp;$13.65
+
<td>1
|$13.65
+
</td>
|Andrew Harris
+
<td>$11.95
|-
+
</td>
|16
+
<td>&#160;$8.40
|[https://www.adafruit.com/products/16 Altoids Gum sized tin]
+
</td>
|1
+
<td>$8.40
|$2
+
</td>
|&nbsp;$1.40
+
<td>Steven Noreyko
|$1.40
+
</td></tr>
|Andrew Harris
+
<tr>
|-
+
<td>284
|859
+
</td>
|[http://www.adafruit.com/products/859 Raspberry Pi Box laser-cut case]
+
<td><a href="https://www.adafruit.com/products/284">FTDI friend + extras v1.0</a>
|1
+
</td>
|$14.95
+
<td>1
|&nbsp;
+
</td>
|$14.95
+
<td>$14.75
|Roland McIntosh
+
</td>
|}
+
<td>&#160;$10.50
 
+
</td>
 
+
<td>$10.50
<br>
+
</td>
 +
<td>Jessica Ross
 +
</td></tr>
 +
<tr>
 +
<td>418
 +
</td>
 +
<td><a href="https://www.adafruit.com/products/418">Arduino Uno Ethernet</a>
 +
</td>
 +
<td>1
 +
</td>
 +
<td>$65.00
 +
</td>
 +
<td>&#160;$65.00
 +
</td>
 +
<td>$65.00
 +
</td>
 +
<td>Jessica Ross
 +
</td></tr>
 +
<tr>
 +
<td>175
 +
</td>
 +
<td><a href="https://www.adafruit.com/products/175">Music &amp; sound add-on pack for Arduino - v1.1</a>
 +
</td>
 +
<td>1
 +
</td>
 +
<td>$35.00
 +
</td>
 +
<td>&#160;$35.00
 +
</td>
 +
<td>$35.00
 +
</td>
 +
<td>Jessica Ross
 +
</td></tr>
 +
<tr>
 +
<td>14
 +
</td>
 +
<td><a href="https://www.adafruit.com/products/14">MintyBoost Kit - v3.0</a>
 +
</td>
 +
<td>1
 +
</td>
 +
<td>$19.50
 +
</td>
 +
<td>&#160;$13.65
 +
</td>
 +
<td>$13.65
 +
</td>
 +
<td>Andrew Harris
 +
</td></tr>
 +
<tr>
 +
<td>16
 +
</td>
 +
<td><a href="https://www.adafruit.com/products/16">Altoids Gum sized tin</a>
 +
</td>
 +
<td>1
 +
</td>
 +
<td>$2
 +
</td>
 +
<td>&#160;$1.40
 +
</td>
 +
<td>$1.40
 +
</td>
 +
<td>Andrew Harris
 +
</td></tr>
 +
<tr>
 +
<td>859
 +
</td>
 +
<td><a href="http://www.adafruit.com/products/859">Raspberry Pi Box laser-cut case</a>
 +
</td>
 +
<td>1
 +
</td>
 +
<td>$14.95
 +
</td>
 +
<td>&#160;
 +
</td>
 +
<td>$14.95
 +
</td>
 +
<td>Roland McIntosh
 +
</td></tr></table>
 +
<p><br />
 +
<br />
 +
</p>
 
<div style="display:none" class="explanation README">
 
<div style="display:none" class="explanation README">
  You don't have to mess with the progress bar, it's a PITA to do manually, and Roland will likely do it himself when he's bored.  But if you WANT to:
+
<pre class="_fck_mw_lspace"> You don't have to mess with the progress bar, it's a PITA to do manually, and Roland will likely do it himself when he's bored.  But if you WANT to:
  Change the width of the inner div to some # of pixels out of 500.  Formulas:  newWidth = currentTotal / $250 * 500px;  percent = round(currentTotal / $250 * 100)
+
Change the width of the inner div to some # of pixels out of 500.  Formulas:  newWidth = currentTotal / $250 * 500px;  percent = round(currentTotal / $250 * 100)
 +
</pre>
 
</div>
 
</div>
 
 
<div style="width: 500px; text-align: center; border: 1px solid black;margin: 0 auto;background-image: -moz-linear-gradient(#ddd, #fff);background-image: -webkit-linear-gradient(#ddd, #fff);"><div class="CHANGE_WIDTH_HERE" style="width: 500px;background-color: green; color: white; font-weight: bold;background-image: -moz-linear-gradient(#5b5, #272);background-image: -webkit-linear-gradient(#5b5, #272);">100% of $250 goal</div></div>
 
<div style="width: 500px; text-align: center; border: 1px solid black;margin: 0 auto;background-image: -moz-linear-gradient(#ddd, #fff);background-image: -webkit-linear-gradient(#ddd, #fff);"><div class="CHANGE_WIDTH_HERE" style="width: 500px;background-color: green; color: white; font-weight: bold;background-image: -moz-linear-gradient(#5b5, #272);background-image: -webkit-linear-gradient(#5b5, #272);">100% of $250 goal</div></div>
 +
<h2> Adding it up </h2>
 +
<p>Mostly you can add it up your total in your head or with a calculator just as quickly as copy/pasting this, but you can also use some tools to help.
 +
</p>
 +
<h3> Copy/paste + awk </h3>
 +
<p>Copy/paste the table from your web browser into a text file.  You should get tab delimited output (tested using Google Chrome pasting into vim).  Save the text file as "order.tsv" and run:
 +
</p>
 +
<pre class="_fck_mw_lspace"> awk -F"\t" '/YOURNAMEHERE/ {print $6}' order.tsv | tr -d '~$ '| awk '{sum+=$1}END{print sum}'
 +
</pre>
 +
<h3> screen scraping with lynx and grep </h3>
 +
<p>This avoids the copy/paste, but requires that your name not appear on any other lines in this page.
 +
</p>
 +
<pre>
 +
  lynx -width=500 -dump &quot;http://www.atxhackerspace.org/index.php?title=Adafruit_Order&quot; | egrep -o &quot;[0-9\.]*[0-9]*[ ]+YOURNAMEHERE&quot; | awk '{sum+=$1}END{print sum}'
 +
</pre>
 +
<p>Here's one for elinks, which uses a vertical pipe and variable whitespace when rendering table cells:
 +
</p>
 +
<pre>
 +
  elinks --dump-width 500 -dump &quot;http://www.atxhackerspace.org/index.php?title=Adafruit_Order&quot; | egrep -o &quot;[0-9\.]*[0-9]*[ ]+\|[ ]*YOURNAMEHERE&quot; | awk '{sum+=$1}END{print sum}'
 +
</pre>
 +
<h3> Built-in browser javascript console sniffing via DOM </h3>
 +
<p>You can open a javsacript console in Google Chrome or Firefox with Firebug installed by pressing the F12 key.  Then paste in:
 +
</p>
 +
<pre>
 +
  var NAME_REGEXP=/YOURNAMEHERE/;var t = document.getElementById(&quot;orderTable&quot;);var sum=0;for( var i =0; i &lt; t.rows.length&#160;; ++i){var r = t.rows[i]; if( NAME_REGEXP.test(r.cells[6].textContent) ) { sum+= parseFloat( r.cells[5].textContent.replace(/[^\d\.]/g,'' ), 10); } };console.log( NAME_REGEXP.source + &quot; owes: $&quot; + sum );
 +
</pre>
 +
<p>Floating point rounding errors can happen due to IEEE 754 float representation in javscript.  You'd have to convert dollars to cents to fix.
 +
</p><p><br />
 +
</p>
 +
<h2> Feb Adafruit Order <b>IS CLOSED</b></h2>
 +
<table border="2" align="center" id="FEB_orderTable">
  
== Adding it up ==
+
<tr>
Mostly you can add it up your total in your head or with a calculator just as quickly as copy/pasting this, but you can also use some tools to help.
+
<th scope="col"> ITEM#
=== Copy/paste + awk ===
+
</th>
Copy/paste the table from your web browser into a text file.  You should get tab delimited output (tested using Google Chrome pasting into vim).  Save the text file as "order.tsv" and run:
+
<th scope="col"> DESCRIPTION
  awk -F"\t" '/YOURNAMEHERE/ {print $6}' order.tsv | tr -d '~$ '| awk '{sum+=$1}END{print sum}'
+
</th>
 
+
<th scope="col"> QTY
=== screen scraping with lynx and grep ===
+
</th>
This avoids the copy/paste, but requires that your name not appear on any other lines in this page.
+
<th scope="col"> COST
<pre><nowiki>
+
</th>
  lynx -width=500 -dump "http://www.atxhackerspace.org/index.php?title=Adafruit_Order" | egrep -o "[0-9\.]*[0-9]*[ ]+YOURNAMEHERE" | awk '{sum+=$1}END{print sum}'
+
<th scope="col"> DISCOUNT_COST
</nowiki></pre>
+
</th>
 
+
<th scope="col"> TOTAL
Here's one for elinks, which uses a vertical pipe and variable whitespace when rendering table cells:
+
</th>
 
+
<th scope="col"> MEMBER
<pre><nowiki>
+
</th></tr>
  elinks --dump-width 500 -dump "http://www.atxhackerspace.org/index.php?title=Adafruit_Order" | egrep -o "[0-9\.]*[0-9]*[ ]+\|[ ]*YOURNAMEHERE" | awk '{sum+=$1}END{print sum}'
+
<tr>
</nowiki></pre>
+
<td> 165
 
+
</td>
=== Built-in browser javascript console sniffing via DOM ===
+
<td> <a href="http://www.adafruit.com/products/165">Temp Sensor</a>
You can open a javsacript console in Google Chrome or Firefox with Firebug installed by pressing the F12 key. Then paste in:
+
</td>
 
+
<td> 6
<pre><nowiki>
+
</td>
  var NAME_REGEXP=/YOURNAMEHERE/;var t = document.getElementById("orderTable");var sum=0;for( var i =0; i < t.rows.length ; ++i){var r = t.rows[i]; if( NAME_REGEXP.test(r.cells[6].textContent) ) { sum+= parseFloat( r.cells[5].textContent.replace(/[^\d\.]/g,'' ), 10); } };console.log( NAME_REGEXP.source + " owes: $" + sum );
+
<td> $2.00
</nowiki></pre>
+
</td>
 
+
<td> $1.60
Floating point rounding errors can happen due to IEEE 754 float representation in javscript. You'd have to convert dollars to cents to fix.
+
</td>
 
+
<td> $9.60
 
+
</td>
== Feb Adafruit Order '''IS CLOSED'''==
+
<td> Martin
 
+
</td></tr>
{| border="2" align="center" id="FEB_orderTable"
+
<tr>
|-
+
<td> 98
! scope="col" | ITEM#
+
</td>
! scope="col" | DESCRIPTION
+
<td> <a href="http://www.adafruit.com/products/98">GPS Logger Shield</a>
! scope="col" | QTY
+
</td>
! scope="col" | COST
+
<td> 1
! scope="col" | DISCOUNT_COST
+
</td>
! scope="col" | TOTAL
+
<td> $19.50
! scope="col" | MEMBER
+
</td>
|-
+
<td> $19.50
| 165
+
</td>
| [http://www.adafruit.com/products/165 Temp Sensor]
+
<td> $19.50
| 6
+
</td>
| $2.00
+
<td> Martin
| $1.60
+
</td></tr>
| $9.60
+
<tr>
| Martin
+
<td> 377
|-
+
</td>
| 98
+
<td> <a href="http://www.adafruit.com/products/377">Rotary Encoder + Extras -</a>
| [http://www.adafruit.com/products/98 GPS Logger Shield]
+
</td>
| 1
+
<td> 2
| $19.50
+
</td>
| $19.50
+
<td> $4.50
| $19.50
+
</td>
| Martin
+
<td> &#160;?
|-
+
</td>
| 377
+
<td> ~$9
| [http://www.adafruit.com/products/377 Rotary Encoder + Extras -]
+
</td>
| 2
+
<td> Roland M.
| $4.50
+
</td></tr>
| &nbsp;?  
+
<tr>
| ~$9  
+
<td> 501
| Roland M.
+
</td>
|-
+
<td> <a href="http://www.adafruit.com/products/501">5V 1A (1000mA) USB port power supply</a>
| 501
+
</td>
| [http://www.adafruit.com/products/501 5V 1A (1000mA) USB port power supply]
+
<td> 2
| 2  
+
</td>
| $4.95
+
<td> $4.95
| &nbsp;?
+
</td>
| ~$9.90
+
<td> &#160;?
| Roland M.
+
</td>
|-
+
<td> ~$9.90
| 268
+
</td>
| [http://www.adafruit.com/products/268 Powerswitch Tail 2]
+
<td> Roland M.
| 1
+
</td></tr>
| $24.95  
+
<tr>
| &nbsp;?
+
<td> 268
| ~$24.95
+
</td>
| Roland M.
+
<td> <a href="http://www.adafruit.com/products/268">Powerswitch Tail 2</a>
|-
+
</td>
| 412  
+
<td> 1
| [http://www.adafruit.com/products/412 Small push-pull solenoid]
+
</td>
| 1  
+
<td> $24.95
| $9.95  
+
</td>
| &nbsp;?  
+
<td> &#160;?
| ~$9.95  
+
</td>
| Roland M.
+
<td> ~$24.95
|-
+
</td>
| 571  
+
<td> Roland M.
| [http://www.adafruit.com/products/571 Adafruit Perma-Proto Half-sized Breadboard PCB - 3 Pack!]
+
</td></tr>
| 1  
+
<tr>
| $9.95  
+
<td> 412
| &nbsp;?  
+
</td>
| ~$9.95  
+
<td> <a href="http://www.adafruit.com/products/412">Small push-pull solenoid</a>
| Roland M.
+
</td>
|-
+
<td> 1
| 678  
+
</td>
| [http://www.adafruit.com/products/678 RF Touch Wheel Controller for Analog RGB LED Strips]
+
<td> $9.95
| 1  
+
</td>
| $39.95  
+
<td> &#160;?
| &nbsp;?  
+
</td>
| ~$39.95  
+
<td> ~$9.95
| Roland M.
+
</td>
|-
+
<td> Roland M.
| 677  
+
</td></tr>
| [http://www.adafruit.com/products/677 Terminal block - 4 pin Euro-Style]
+
<tr>
| 1  
+
<td> 571
| $2.50  
+
</td>
| &nbsp;?  
+
<td> <a href="http://www.adafruit.com/products/571">Adafruit Perma-Proto Half-sized Breadboard PCB - 3 Pack!</a>
| ~$2.50  
+
</td>
| Roland M.
+
<td> 1
|-
+
</td>
| 579  
+
<td> $9.95
| [http://www.adafruit.com/products/579 4-pin JST SM Receptacle Cable]
+
</td>
| 4  
+
<td> &#160;?
| $1.50  
+
</td>
| &nbsp;?  
+
<td> ~$9.95
| ~$6.00  
+
</td>
| Roland M.
+
<td> Roland M.
|-
+
</td></tr>
| 578  
+
<tr>
| [http://www.adafruit.com/products/578 4-pin JST SM Plug Cable]
+
<td> 678
| 4  
+
</td>
| $1.50  
+
<td> <a href="http://www.adafruit.com/products/678">RF Touch Wheel Controller for Analog RGB LED Strips</a>
| &nbsp;?  
+
</td>
| ~$6.00  
+
<td> 1
| Roland M.
+
</td>
|-
+
<td> $39.95
| 675
+
</td>
| [http://www.adafruit.com/products/675 Sewable Electroluminscent (EL) Wire Welted Piping- Aqua 5 meters]
+
<td> &#160;?
| 1
+
</td>
| $19.95  
+
<td> ~$39.95
| &nbsp;?  
+
</td>
| ~$19.95
+
<td> Roland M.
| MElbert
+
</td></tr>
|-
+
<tr>
| 345
+
<td> 677
| [http://www.adafruit.com/products/345 Nunchucky]
+
</td>
| 1
+
<td> <a href="http://www.adafruit.com/products/677">Terminal block - 4 pin Euro-Style</a>
| $3.00  
+
</td>
| &nbsp;?  
+
<td> 1
| ~$3.00
+
</td>
| MElbert
+
<td> $2.50
|-
+
</td>
| 362  
+
<td> &#160;?
| [http://www.adafruit.com/products/362 MiFare Classic (13.56MHz RFID/NFC) Sticker - 1KB ]
+
</td>
| 4
+
<td> ~$2.50
| $2.50  
+
</td>
| &nbsp;??  
+
<td> Roland M.
| ~$10.00  
+
</td></tr>
| pwheat
+
<tr>
|-
+
<td> 579
| 436
+
</td>
| [http://www.adafruit.com/products/364 PN532 NFC/RFID controller breakout board - v1.3 ]
+
<td> <a href="http://www.adafruit.com/products/579">4-pin JST SM Receptacle Cable</a>
| 1
+
</td>
| $50.00
+
<td> 4
| &nbsp;??  
+
</td>
| ~$50.00  
+
<td> $1.50
| pwheat
+
</td>
|-
+
<td> &#160;?
| 436
+
</td>
| [https://www.adafruit.com/products/436 Sugru Multicolor pack]
+
<td> ~$6.00
| 1
+
</td>
| $17.95
+
<td> Roland M.
| &nbsp;??  
+
</td></tr>
| ~$17.95  
+
<tr>
| pwheat
+
<td> 578
|-
+
</td>
| 128  
+
<td> <a href="http://www.adafruit.com/products/578">4-pin JST SM Plug Cable</a>
| [http://www.adafruit.com/products/128 XBee Module - Series 01 - XB24-AWI-001]
+
</td>
| 4
+
<td> 4
| $23.00  
+
</td>
| &nbsp;??  
+
<td> $1.50
| ~$92.00  
+
</td>
| Tuna
+
<td> &#160;?
|-
+
</td>
| 247
+
<td> ~$6.00
| [http://www.adafruit.com/products/247 USB XBee Adapter]
+
</td>
| 1
+
<td> Roland M.
| $20
+
</td></tr>
| &nbsp;??
+
<tr>
| ~$20
+
<td> 675
| Tuna
+
</td>
|-
+
<td> <a href="http://www.adafruit.com/products/675">Sewable Electroluminscent (EL) Wire Welted Piping- Aqua 5 meters</a>
| 126
+
</td>
| [http://www.adafruit.com/products/126 XBee Adapter kit - v1.1]
+
<td> 1
| 1
+
</td>
| $10
+
<td> $19.95
| &nbsp;??
+
</td>
| ~$10
+
<td> &#160;?
| Tuna
+
</td>
|}
+
<td> ~$19.95
 +
</td>
 +
<td> MElbert
 +
</td></tr>
 +
<tr>
 +
<td> 345
 +
</td>
 +
<td> <a href="http://www.adafruit.com/products/345">Nunchucky</a>
 +
</td>
 +
<td> 1
 +
</td>
 +
<td> $3.00
 +
</td>
 +
<td> &#160;?
 +
</td>
 +
<td> ~$3.00
 +
</td>
 +
<td> MElbert
 +
</td></tr>
 +
<tr>
 +
<td> 362
 +
</td>
 +
<td> <a href="http://www.adafruit.com/products/362">MiFare Classic (13.56MHz RFID/NFC) Sticker - 1KB </a>
 +
</td>
 +
<td> 4
 +
</td>
 +
<td> $2.50
 +
</td>
 +
<td> &#160;??
 +
</td>
 +
<td> ~$10.00
 +
</td>
 +
<td> pwheat
 +
</td></tr>
 +
<tr>
 +
<td> 436
 +
</td>
 +
<td> <a href="http://www.adafruit.com/products/364">PN532 NFC/RFID controller breakout board - v1.3 </a>
 +
</td>
 +
<td> 1
 +
</td>
 +
<td> $50.00
 +
</td>
 +
<td> &#160;??
 +
</td>
 +
<td> ~$50.00
 +
</td>
 +
<td> pwheat
 +
</td></tr>
 +
<tr>
 +
<td> 436
 +
</td>
 +
<td> <a href="https://www.adafruit.com/products/436">Sugru Multicolor pack</a>
 +
</td>
 +
<td> 1
 +
</td>
 +
<td> $17.95
 +
</td>
 +
<td> &#160;??
 +
</td>
 +
<td> ~$17.95
 +
</td>
 +
<td> pwheat
 +
</td></tr>
 +
<tr>
 +
<td> 128
 +
</td>
 +
<td> <a href="http://www.adafruit.com/products/128">XBee Module - Series 01 - XB24-AWI-001</a>
 +
</td>
 +
<td> 4
 +
</td>
 +
<td> $23.00
 +
</td>
 +
<td> &#160;??
 +
</td>
 +
<td> ~$92.00
 +
</td>
 +
<td> Tuna
 +
</td></tr>
 +
<tr>
 +
<td> 247
 +
</td>
 +
<td> <a href="http://www.adafruit.com/products/247">USB XBee Adapter</a>
 +
</td>
 +
<td> 1
 +
</td>
 +
<td> $20
 +
</td>
 +
<td> &#160;??
 +
</td>
 +
<td> ~$20
 +
</td>
 +
<td> Tuna
 +
</td></tr>
 +
<tr>
 +
<td> 126
 +
</td>
 +
<td> <a href="http://www.adafruit.com/products/126">XBee Adapter kit - v1.1</a>
 +
</td>
 +
<td> 1
 +
</td>
 +
<td> $10
 +
</td>
 +
<td> &#160;??
 +
</td>
 +
<td> ~$10
 +
</td>
 +
<td> Tuna
 +
</td></tr></table>
 
<div style="display:none"> ABOVE IS FEB table -- that order is CLOSED</div>
 
<div style="display:none"> ABOVE IS FEB table -- that order is CLOSED</div>

Revision as of 22:07, 22 June 2012

Adafruit Wholesale Order

We get various discounts from Adafruit if we order $250 worth of stuff. It's the Adafruit wholesale discount! So, if you want to get in on an order, add your request to this page. When the total gets to be ~$250, the order goes in, and is delivered to the hackerspace.

There have been various non-paying people on the last couple orders. SO, in order to put the order in this time, when the order is complete we'll be taking the payments BEFORE placing the order. Sorry, but the hackerspace just can't absorb $70-100 in unpaid items.

Jun Adafruit Order

ITEM# DESCRIPTION QTY COST DISCOUNT_COST TOTAL MEMBER
170 <a href="http://www.adafruit.com/products/170">Adafruit ARDX - v1.3 Experimentation Kit for Arduino (Uno R3) - v1.3</a> 1 $85.00  $68.00 $68.00 Shadow
454 <a href="http://www.adafruit.com/products/454">Miniature 8x8 Red LED Matrix</a> 50 $3.56  $2.40 $120.00 Christian Miller
259 <a href="http://www.adafruit.com/products/259">USB LiIon/LiPoly charger - v1.2</a> 1 $12.50  OUT OF STOCK ~$12.50 Jonathan Kelly
459 <a href="https://www.adafruit.com/products/459">Bi-Color (Red/Green) 12-LED Bargraph - BL-AR12Z3010DUG-11</a> 8 $1.95  $1.35 $10.80 Steven Noreyko
861 <a href="https://www.adafruit.com/products/861">Miniature 8x8 Green LED Matrix - BL-M07C881UG-11</a> 2 $3.95  $2.80 $5.60 Steven Noreyko
881 <a href="http://www.adafruit.com/products/881">Adafruit 0.56" 4-Digit 7-Segment Display w/I2C Backpack - Blue</a> 1 $11.95  $8.40 $8.40 Steven Noreyko
284 <a href="https://www.adafruit.com/products/284">FTDI friend + extras v1.0</a> 1 $14.75  $10.50 $10.50 Jessica Ross
418 <a href="https://www.adafruit.com/products/418">Arduino Uno Ethernet</a> 1 $65.00  $65.00 $65.00 Jessica Ross
175 <a href="https://www.adafruit.com/products/175">Music & sound add-on pack for Arduino - v1.1</a> 1 $35.00  $35.00 $35.00 Jessica Ross
14 <a href="https://www.adafruit.com/products/14">MintyBoost Kit - v3.0</a> 1 $19.50  $13.65 $13.65 Andrew Harris
16 <a href="https://www.adafruit.com/products/16">Altoids Gum sized tin</a> 1 $2  $1.40 $1.40 Andrew Harris
859 <a href="http://www.adafruit.com/products/859">Raspberry Pi Box laser-cut case</a> 1 $14.95   $14.95 Roland McIntosh



100% of $250 goal

Adding it up

Mostly you can add it up your total in your head or with a calculator just as quickly as copy/pasting this, but you can also use some tools to help.

Copy/paste + awk

Copy/paste the table from your web browser into a text file. You should get tab delimited output (tested using Google Chrome pasting into vim). Save the text file as "order.tsv" and run:

 awk -F"\t" '/YOURNAMEHERE/ {print $6}' order.tsv | tr -d '~$ '| awk '{sum+=$1}END{print sum}'

screen scraping with lynx and grep

This avoids the copy/paste, but requires that your name not appear on any other lines in this page.

  lynx -width=500 -dump "http://www.atxhackerspace.org/index.php?title=Adafruit_Order" | egrep -o "[0-9\.]*[0-9]*[ ]+YOURNAMEHERE" | awk '{sum+=$1}END{print sum}'

Here's one for elinks, which uses a vertical pipe and variable whitespace when rendering table cells:

  elinks --dump-width 500 -dump "http://www.atxhackerspace.org/index.php?title=Adafruit_Order" | egrep -o "[0-9\.]*[0-9]*[ ]+\|[ ]*YOURNAMEHERE" | awk '{sum+=$1}END{print sum}'

Built-in browser javascript console sniffing via DOM

You can open a javsacript console in Google Chrome or Firefox with Firebug installed by pressing the F12 key. Then paste in:

  var NAME_REGEXP=/YOURNAMEHERE/;var t = document.getElementById("orderTable");var sum=0;for( var i =0; i < t.rows.length ; ++i){var r = t.rows[i]; if( NAME_REGEXP.test(r.cells[6].textContent) ) { sum+= parseFloat( r.cells[5].textContent.replace(/[^\d\.]/g,'' ), 10); } };console.log( NAME_REGEXP.source + " owes: $" + sum );

Floating point rounding errors can happen due to IEEE 754 float representation in javscript. You'd have to convert dollars to cents to fix.


Feb Adafruit Order IS CLOSED

ITEM# DESCRIPTION QTY COST DISCOUNT_COST TOTAL MEMBER
165 <a href="http://www.adafruit.com/products/165">Temp Sensor</a> 6 $2.00 $1.60 $9.60 Martin
98 <a href="http://www.adafruit.com/products/98">GPS Logger Shield</a> 1 $19.50 $19.50 $19.50 Martin
377 <a href="http://www.adafruit.com/products/377">Rotary Encoder + Extras -</a> 2 $4.50  ? ~$9 Roland M.
501 <a href="http://www.adafruit.com/products/501">5V 1A (1000mA) USB port power supply</a> 2 $4.95  ? ~$9.90 Roland M.
268 <a href="http://www.adafruit.com/products/268">Powerswitch Tail 2</a> 1 $24.95  ? ~$24.95 Roland M.
412 <a href="http://www.adafruit.com/products/412">Small push-pull solenoid</a> 1 $9.95  ? ~$9.95 Roland M.
571 <a href="http://www.adafruit.com/products/571">Adafruit Perma-Proto Half-sized Breadboard PCB - 3 Pack!</a> 1 $9.95  ? ~$9.95 Roland M.
678 <a href="http://www.adafruit.com/products/678">RF Touch Wheel Controller for Analog RGB LED Strips</a> 1 $39.95  ? ~$39.95 Roland M.
677 <a href="http://www.adafruit.com/products/677">Terminal block - 4 pin Euro-Style</a> 1 $2.50  ? ~$2.50 Roland M.
579 <a href="http://www.adafruit.com/products/579">4-pin JST SM Receptacle Cable</a> 4 $1.50  ? ~$6.00 Roland M.
578 <a href="http://www.adafruit.com/products/578">4-pin JST SM Plug Cable</a> 4 $1.50  ? ~$6.00 Roland M.
675 <a href="http://www.adafruit.com/products/675">Sewable Electroluminscent (EL) Wire Welted Piping- Aqua 5 meters</a> 1 $19.95  ? ~$19.95 MElbert
345 <a href="http://www.adafruit.com/products/345">Nunchucky</a> 1 $3.00  ? ~$3.00 MElbert
362 <a href="http://www.adafruit.com/products/362">MiFare Classic (13.56MHz RFID/NFC) Sticker - 1KB </a> 4 $2.50  ?? ~$10.00 pwheat
436 <a href="http://www.adafruit.com/products/364">PN532 NFC/RFID controller breakout board - v1.3 </a> 1 $50.00  ?? ~$50.00 pwheat
436 <a href="https://www.adafruit.com/products/436">Sugru Multicolor pack</a> 1 $17.95  ?? ~$17.95 pwheat
128 <a href="http://www.adafruit.com/products/128">XBee Module - Series 01 - XB24-AWI-001</a> 4 $23.00  ?? ~$92.00 Tuna
247 <a href="http://www.adafruit.com/products/247">USB XBee Adapter</a> 1 $20  ?? ~$20 Tuna
126 <a href="http://www.adafruit.com/products/126">XBee Adapter kit - v1.1</a> 1 $10  ?? ~$10 Tuna
ABOVE IS FEB table -- that order is CLOSED