Part Spreadsheet
Category Item Quantity Order Date Needed Date Shipping Lag Time Purchase Request Number 2 1 2 [3]
Accessories 24 pack AA Battery Sensors Sensors Sensors Aquatel TDR Moisture Sensor Probe Temp. Sensor ADC Transistor Zener Diode Resistors
2 1 10 13
11/17/2008
Select one on Saturday: DO Sensors
3
Housing Housing Housing Housing Housing Housing Housing Housing
4" PVC Tubing Normal Caps Screw Adapter Screw Caps PVC Cement PVC Cleaner Plumbng tape Silicone
For the following wait for the power supply and temperature board designs Accessories Shielded Cable 50' Accessories Cable Junctions Accessories Labeling Accessories Misc. Housing & Assembly
Assumptions: 5 land motes (2 temp & moisture sensors/mote) 3 water motes (1 temp & D.O. sensors / mote)
Manufacturer P/N
Distributor Estimated Cost Price / Unit Total Amount Paid (incl. tax and shipping)
Energizer
EVR-EN91 Battery Mart
$24.77 $100.00 $240.00 $71.50
$8.40 $100.00 $24.00 $5.50
$24.77
Automata TDR Automata Vegetronix VG400 Vegetronix National Semiconductor LM35CAZ Digikey
$2,100.00
$700.00
$100.00
$50.00
$2,686.27
"Explicitly describe each part, quantity needed, the optimal vendor, actual price (including shipping), likely lag time
Table 1: Budget Overview
Category Cost $100.00 $25.36 $98.16 $130.19 $183.25 $536.96 Sensors Power Supply Temperature Board Housing Accessories Total
Total w/out DO Sensor:
#VALUE!
Table 2: Sensors.
Quantity Item Preferred Vendor P/N Shipping Lag Time Needed Date
1 Moisture Sensor Automata 10 Moisture Sensor ??? 3 Dissolved Oxygen Sensor ???
Aquatel TDR ??? ???
??? ???
2/1/2009 2/1/2009 Total
Table 3: Power Supply.
Quantity 10 10 10 20 Preferred Vendor Micropower LDO Regulator Micrel 10k Resistors Digikey 2.2uF Capacitors Digikey 9V Battery Straps Digikey Item Purchase Receipt Order Date Date MIC29201-5.0WT 11/17/2008 11/19/2008 MFR-25FBF-10K01/20/2008 12/1/2008 1 TAP225K035SCS 11/20/2008 12/1/2008 232K-ND 11/20/2008 12/1/2008 Total P/N Purchase Order Date Receipt Date P/N
Table 4: Temperature Board.
Quantity Item Preferred Vendor
12 16 30 4
Temperature Chip Digikey 18k Resistors Digikey 1N914 Diode Digikey Epoxy for Water Protection Horn Trader
LM35CAZ 11/20/2008 P18.0KCACT-ND 11/20/2008 P18.0KCACT-ND 11/20/2008
12/1/2008 12/1/2008 12/1/2008 Total
Table 5: Housing.
Quantity Item Preferred Vendor --P/N Expected Shipping Lag Time 1 week 1 week Needed Date 2/6/2009 2/6/2009
1 10'x4" PVC Tubing Trader Horn 8 Normal Caps Trader Horn
8 8 1 1 1 1
Screw Adapter Screw Caps PVC Cement PVC Cleaner Plumbing Tape Silicone
Trader Horn Trader Horn Trader Horn Trader Horn Trader Horn Trader Horn
-------
1 week 1 week 1 week 1 week 1 week 1 week
2/6/2009 2/6/2009 2/6/2009 2/6/2009 2/6/2009 2/6/2009 Total Needed Date
Table 6: Accessories.
Quantity Item Preferred Vendor All-Battery.com Digikey ExpressPCB Jameco Electronics Jameco Electronics P/N Expected Shipping Lag Time
20 Duracell Coppertop 9V battery 8 Hirose DF9-51S-1V 1 Conn. PCB Miniboard Package 25' 15-Wire Shielded Cable 25' 9-Wire Shielded Cable Misc. Notes: alpha wire co. 18.5' 5 wire wire - 35006 6 39' 7 wire 8 wire - 35008 20' 9 wire 10 wire - 35010
30320 H10408CT-ND Miniboard 3 days 644447 3 days 644412 3 days 2/1/2009 2/1/2009
need a "direct burial" cable, see >
to handle constant submersion.
eed 21mA for 30 minutes a day