From ATXHackerspace
Martinbogo (talk | contribs) |
(→April/May 2013 Adafruit Order) |
||
Line 49: | Line 49: | ||
|$45.00 | |$45.00 | ||
|Jessica Ross | |Jessica Ross | ||
+ | |- | ||
+ | |1278 | ||
+ | |[http://www.adafruit.com/products/1278 BeagleBone Black] | ||
+ | |1 | ||
+ | |$45.00 | ||
+ | |$45.00 | ||
+ | |$45.00 | ||
+ | |Eric Blount | ||
|- | |- | ||
| | | | ||
Line 55: | Line 63: | ||
| | | | ||
| | | | ||
− | |'''$ | + | |'''$208''' |
| | | | ||
|} | |} |
Revision as of 18:07, 26 April 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.
April/May 2013 Adafruit Order
ITEM# | DESCRIPTION | QTY | COST | DISCOUNT_COST | TOTAL | MEMBER |
---|---|---|---|---|---|---|
1278 | BeagleBone Black | 2 | $45.00 | $45.00 | $90.00 | Martin Bogomolni |
954 | USB to TTL serial Cable | 2 | $9.95 | $7.00 | $14.00 | Martin Bogomolni |
276 | 5V, 2A Power Supply | 2 | $9.95 | $7.00 | $14.00 | Martin Bogomolni |
1278 | BeagleBone Black | 1 | $45.00 | $45.00 | $45.00 | Jessica Ross |
1278 | BeagleBone Black | 1 | $45.00 | $45.00 | $45.00 | Eric Blount |
$208 |
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.
Jun Adafruit Order IS CLOSED
ITEM# | DESCRIPTION | QTY | COST | DISCOUNT_COST | TOTAL | MEMBER |
---|---|---|---|---|---|---|
170 | Adafruit ARDX - v1.3 Experimentation Kit for Arduino (Uno R3) - v1.3 | 1 | $85.00 | $68.00 | $68.00 | Shadow |
454 | Miniature 8x8 Red LED Matrix | 50 | $3.56 | $2.40 | $120.00 | Christian Miller |
259 | USB LiIon/LiPoly charger - v1.2 | 1 | $12.50 | OUT OF STOCK | ~$12.50 | Jonathan Kelly |
459 | Bi-Color (Red/Green) 12-LED Bargraph - BL-AR12Z3010DUG-11 | 8 | $1.95 | $1.35 | $10.80 | Steven Noreyko |
861 | Miniature 8x8 Green LED Matrix - BL-M07C881UG-11 | 2 | $3.95 | $2.80 | $5.60 | Steven Noreyko |
881 | Adafruit 0.56" 4-Digit 7-Segment Display w/I2C Backpack - Blue | 1 | $11.95 | $8.40 | $8.40 | Steven Noreyko |
284 | FTDI friend + extras v1.0 | 1 | $14.75 | $10.50 | $10.50 | Jessica Ross |
418 | Arduino Uno Ethernet | 1 | $65.00 | $65.00 | $65.00 | Jessica Ross |
175 | Music & sound add-on pack for Arduino - v1.1 | 1 | $35.00 | $35.00 | $35.00 | Jessica Ross |
14 | MintyBoost Kit - v3.0 | 1 | $19.50 | $13.65 | $13.65 | Andrew Harris |
16 | Altoids Gum sized tin | 1 | $2 | $1.40 | $1.40 | Andrew Harris |
SUBTOTAL : $338.35 + $30.85 shipping = TOTAL $369.20
Feb Adafruit Order IS CLOSED
ITEM# | DESCRIPTION | QTY | COST | DISCOUNT_COST | TOTAL | MEMBER |
---|---|---|---|---|---|---|
165 | Temp Sensor | 6 | $2.00 | $1.60 | $9.60 | Martin |
98 | GPS Logger Shield | 1 | $19.50 | $19.50 | $19.50 | Martin |
377 | Rotary Encoder + Extras - | 2 | $4.50 | ? | ~$9 | Roland M. |
501 | 5V 1A (1000mA) USB port power supply | 2 | $4.95 | ? | ~$9.90 | Roland M. |
268 | Powerswitch Tail 2 | 1 | $24.95 | ? | ~$24.95 | Roland M. |
412 | Small push-pull solenoid | 1 | $9.95 | ? | ~$9.95 | Roland M. |
571 | Adafruit Perma-Proto Half-sized Breadboard PCB - 3 Pack! | 1 | $9.95 | ? | ~$9.95 | Roland M. |
678 | RF Touch Wheel Controller for Analog RGB LED Strips | 1 | $39.95 | ? | ~$39.95 | Roland M. |
677 | Terminal block - 4 pin Euro-Style | 1 | $2.50 | ? | ~$2.50 | Roland M. |
579 | 4-pin JST SM Receptacle Cable | 4 | $1.50 | ? | ~$6.00 | Roland M. |
578 | 4-pin JST SM Plug Cable | 4 | $1.50 | ? | ~$6.00 | Roland M. |
675 | Sewable Electroluminscent (EL) Wire Welted Piping- Aqua 5 meters | 1 | $19.95 | ? | ~$19.95 | MElbert |
345 | Nunchucky | 1 | $3.00 | ? | ~$3.00 | MElbert |
362 | MiFare Classic (13.56MHz RFID/NFC) Sticker - 1KB | 4 | $2.50 | ?? | ~$10.00 | pwheat |
436 | PN532 NFC/RFID controller breakout board - v1.3 | 1 | $50.00 | ?? | ~$50.00 | pwheat |
436 | Sugru Multicolor pack | 1 | $17.95 | ?? | ~$17.95 | pwheat |
128 | XBee Module - Series 01 - XB24-AWI-001 | 4 | $23.00 | ?? | ~$92.00 | Tuna |
247 | USB XBee Adapter | 1 | $20 | ?? | ~$20 | Tuna |
126 | XBee Adapter kit - v1.1 | 1 | $10 | ?? | ~$10 | Tuna |