Difference between revisions of "Adafruit Order"

From ATXHackerspace

Jump to: navigation, search
(July Adafruit Order)
 
(15 intermediate revisions by 2 users not shown)
Line 4: Line 4:
 
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.  
 
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.  
+
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.
  
== July Adafruit Order ==
+
If there are any major items that are marked <font color='red'>OUT OF STOCK</font> the order will not be placed until either 1) the rest of the order totals more than $250 or 2) the major items come back into stock .. usually 5-7 days.
 +
 
 +
== September 2013 Adafruit Order is OPEN ==
  
 
{| border="2" align="center" id="orderTable"
 
{| border="2" align="center" id="orderTable"
Line 18: Line 20:
 
! scope="col" | MEMBER
 
! scope="col" | MEMBER
 
|-
 
|-
|859
+
|9999
|[http://www.adafruit.com/products/859 Raspberry Pi Box laser-cut case]
+
|[http://www.adafruit.com/products/9999 Example Item]
 
|1
 
|1
|$14.95
+
|$1.00
 +
|$1.00
 +
|$1.00
 +
|Martin Bogomolni
 +
|-
 +
|SHIPPING
 +
|UPS 2nd Day
 +
|&nbsp;
 +
|$??.??
 +
|&nbsp;
 +
|'''$??.??'''
 
|&nbsp;
 
|&nbsp;
|$14.95
 
|Roland McIntosh
 
 
|}
 
|}
  
Line 33: Line 43:
 
</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: 30px;background-color: green; color: white; font-weight: bold;background-image: -moz-linear-gradient(#5b5, #272);background-image: -webkit-linear-gradient(#5b5, #272);">6% 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: 0px;background-color: green; color: white; font-weight: bold;background-image: -moz-linear-gradient(#5b5, #272);background-image: -webkit-linear-gradient(#5b5, #272);">0% of $250 goal</div></div>
  
 
== Adding it up ==
 
== Adding it up ==
Line 61: Line 71:
  
 
Floating point rounding errors can happen due to IEEE 754 float representation in javscript.  You'd have to convert dollars to cents to fix.
 
Floating point rounding errors can happen due to IEEE 754 float representation in javscript.  You'd have to convert dollars to cents to fix.
 
== Jun Adafruit Order '''IS CLOSED'''==
 
 
{| border="2" align="center" id="orderTable"
 
|-
 
! scope="col" | ITEM#
 
! scope="col" | DESCRIPTION
 
! scope="col" | QTY
 
! scope="col" | COST
 
! scope="col" | DISCOUNT_COST
 
! scope="col" | TOTAL
 
! scope="col" | MEMBER
 
|-
 
| 170
 
| [http://www.adafruit.com/products/170 Adafruit ARDX - v1.3 Experimentation Kit for Arduino (Uno R3) - v1.3]
 
| 1
 
| $85.00
 
| &nbsp;$68.00
 
| $68.00
 
| Shadow
 
 
|-
 
| 454
 
| [http://www.adafruit.com/products/454 Miniature 8x8 Red LED Matrix]
 
| 50
 
| $3.56
 
| &nbsp;$2.40
 
| $120.00
 
| Christian Miller
 
 
|-
 
| 259
 
| [http://www.adafruit.com/products/259 USB LiIon/LiPoly charger - v1.2]
 
| 1
 
| $12.50
 
| &nbsp;OUT OF STOCK
 
| ~$12.50
 
| Jonathan Kelly
 
 
|-
 
|459
 
|[https://www.adafruit.com/products/459 Bi-Color (Red/Green) 12-LED Bargraph - BL-AR12Z3010DUG-11]
 
|8
 
|$1.95
 
|&nbsp;$1.35
 
|$10.80
 
|Steven Noreyko
 
|-
 
|861
 
|[https://www.adafruit.com/products/861 Miniature 8x8 Green LED Matrix - BL-M07C881UG-11]
 
|2
 
|$3.95
 
|&nbsp;$2.80
 
|$5.60
 
|Steven Noreyko
 
|-
 
|881
 
|[http://www.adafruit.com/products/881 Adafruit 0.56" 4-Digit 7-Segment Display w/I2C Backpack - Blue]
 
|1
 
|$11.95
 
|&nbsp;$8.40
 
|$8.40
 
|Steven Noreyko
 
|-
 
|284
 
|[https://www.adafruit.com/products/284 FTDI friend + extras v1.0]
 
|1
 
|$14.75
 
|&nbsp;$10.50
 
|$10.50
 
|Jessica Ross
 
|-
 
|418
 
|[https://www.adafruit.com/products/418 Arduino Uno Ethernet]
 
|1
 
|$65.00
 
|&nbsp;$65.00
 
|$65.00
 
|Jessica Ross
 
|-
 
|175
 
|[https://www.adafruit.com/products/175 Music & sound add-on pack for Arduino - v1.1]
 
|1
 
|$35.00
 
|&nbsp;$35.00
 
|$35.00
 
|Jessica Ross
 
|-
 
|14
 
|[https://www.adafruit.com/products/14 MintyBoost Kit - v3.0]
 
|1
 
|$19.50
 
|&nbsp;$13.65
 
|$13.65
 
|Andrew Harris
 
|-
 
|16
 
|[https://www.adafruit.com/products/16 Altoids Gum sized tin]
 
|1
 
|$2
 
|&nbsp;$1.40
 
|$1.40
 
|Andrew Harris
 
|}
 
 
'''SUBTOTAL : $338.35 + $30.85 shipping = TOTAL $369.20'''
 
 
 
== Feb Adafruit Order '''IS CLOSED'''==
 
 
{| border="2" align="center" id="FEB_orderTable"
 
|-
 
! scope="col" | ITEM#
 
! scope="col" | DESCRIPTION
 
! scope="col" | QTY
 
! scope="col" | COST
 
! scope="col" | DISCOUNT_COST
 
! scope="col" | TOTAL
 
! scope="col" | MEMBER
 
|-
 
| 165
 
| [http://www.adafruit.com/products/165 Temp Sensor]
 
| 6
 
| $2.00
 
| $1.60
 
| $9.60
 
| Martin
 
|-
 
| 98
 
| [http://www.adafruit.com/products/98 GPS Logger Shield]
 
| 1
 
| $19.50
 
| $19.50
 
| $19.50
 
| Martin
 
|-
 
| 377
 
| [http://www.adafruit.com/products/377 Rotary Encoder + Extras -]
 
| 2
 
| $4.50
 
| &nbsp;?
 
| ~$9
 
| Roland M.
 
|-
 
| 501
 
| [http://www.adafruit.com/products/501 5V 1A (1000mA) USB port power supply]
 
| 2
 
| $4.95
 
| &nbsp;?
 
| ~$9.90
 
| Roland M.
 
|-
 
| 268
 
| [http://www.adafruit.com/products/268 Powerswitch Tail 2]
 
| 1
 
| $24.95
 
| &nbsp;?
 
| ~$24.95
 
| Roland M.
 
|-
 
| 412
 
| [http://www.adafruit.com/products/412 Small push-pull solenoid]
 
| 1
 
| $9.95
 
| &nbsp;?
 
| ~$9.95
 
| Roland M.
 
|-
 
| 571
 
| [http://www.adafruit.com/products/571 Adafruit Perma-Proto Half-sized Breadboard PCB - 3 Pack!]
 
| 1
 
| $9.95
 
| &nbsp;?
 
| ~$9.95
 
| Roland M.
 
|-
 
| 678
 
| [http://www.adafruit.com/products/678 RF Touch Wheel Controller for Analog RGB LED Strips]
 
| 1
 
| $39.95
 
| &nbsp;?
 
| ~$39.95
 
| Roland M.
 
|-
 
| 677
 
| [http://www.adafruit.com/products/677 Terminal block - 4 pin Euro-Style]
 
| 1
 
| $2.50
 
| &nbsp;?
 
| ~$2.50
 
| Roland M.
 
|-
 
| 579
 
| [http://www.adafruit.com/products/579 4-pin JST SM Receptacle Cable]
 
| 4
 
| $1.50
 
| &nbsp;?
 
| ~$6.00
 
| Roland M.
 
|-
 
| 578
 
| [http://www.adafruit.com/products/578 4-pin JST SM Plug Cable]
 
| 4
 
| $1.50
 
| &nbsp;?
 
| ~$6.00
 
| Roland M.
 
|-
 
| 675
 
| [http://www.adafruit.com/products/675 Sewable Electroluminscent (EL) Wire Welted Piping- Aqua 5 meters]
 
| 1
 
| $19.95
 
| &nbsp;?
 
| ~$19.95
 
| MElbert
 
|-
 
| 345
 
| [http://www.adafruit.com/products/345 Nunchucky]
 
| 1
 
| $3.00
 
| &nbsp;?
 
| ~$3.00
 
| MElbert
 
|-
 
| 362
 
| [http://www.adafruit.com/products/362 MiFare Classic (13.56MHz RFID/NFC) Sticker - 1KB ]
 
| 4
 
| $2.50
 
| &nbsp;??
 
| ~$10.00
 
| pwheat
 
|-
 
| 436
 
| [http://www.adafruit.com/products/364 PN532 NFC/RFID controller breakout board - v1.3 ]
 
| 1
 
| $50.00
 
| &nbsp;??
 
| ~$50.00
 
| pwheat
 
|-
 
| 436
 
| [https://www.adafruit.com/products/436 Sugru Multicolor pack]
 
| 1
 
| $17.95
 
| &nbsp;??
 
| ~$17.95
 
| pwheat
 
|-
 
| 128
 
| [http://www.adafruit.com/products/128 XBee Module - Series 01 - XB24-AWI-001]
 
| 4
 
| $23.00
 
| &nbsp;??
 
| ~$92.00
 
| Tuna
 
|-
 
| 247
 
| [http://www.adafruit.com/products/247 USB XBee Adapter]
 
| 1
 
| $20
 
| &nbsp;??
 
| ~$20
 
| Tuna
 
|-
 
| 126
 
| [http://www.adafruit.com/products/126 XBee Adapter kit - v1.1]
 
| 1
 
| $10
 
| &nbsp;??
 
| ~$10
 
| Tuna
 
|}
 
<div style="display:none"> ABOVE IS FEB table -- that order is CLOSED</div>
 

Latest revision as of 20:16, 28 August 2013

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.

If there are any major items that are marked OUT OF STOCK the order will not be placed until either 1) the rest of the order totals more than $250 or 2) the major items come back into stock .. usually 5-7 days.

September 2013 Adafruit Order is OPEN

ITEM# DESCRIPTION QTY COST DISCOUNT_COST TOTAL MEMBER
9999 Example Item 1 $1.00 $1.00 $1.00 Martin Bogomolni
SHIPPING UPS 2nd Day   $??.??   $??.??  


0% 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.