Spreadsheet: 219701d1362889067-vlookup-and-conditional-formatting-order-book-short-1
Sheet: March 13

AMBERTECHNOLOGY(NZ)LIMITED |  |  | Ex Rate
 | Stock Status Report |  | 0.75
StockCode | Description | COST PER ITEM USD | Cost NZD | Value in stock NZD | In Stock | COST THIS ORDER NZD | On Order | Back Order Value | Back Order | Available | [NAME] | Mth Ave | Last 6 Mnth | YTD | Mar $ value | Mar | Feb $ value | Feb | Jan $ value | 2012-01-01 00:00:00 | Dec $ value | Dec | Nov $ value | Nov | Oct $ value | Oct | Sept $ value | Sept | Aug $ value | Aug | July $ value | July | June $ value | June | May $ value | May | April $ value | April | Mar $ value | Mar | Feb $ value | Feb | Jan $ value | 2012-01-01 00:00:00 | Dec $ value | Dec | Nov $ value | Nov
912.041.00 | P/PACK SMPS 15VDC 2AMP IN LINE |  | 0 | 0 | 2 |  |  | 0 |  | 2 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
EXT-DVI-2-HDSDIS | GENFEN DVI-2 HDSDIS TO  HDSDIS SCALER |  | 0 |  |  |  |  | 0 |  |  | 0.25 | 0.08333333333333333 | 1 | 1 | 0 | 1 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-AADC2DVI | ADC to DVI Adapter |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADA-3.52RCA | Mini-Stereo to RCA Adapter |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADA-ADC2VGA | ADC to VGA Adapter |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADA-AIRCLICK | AirClick |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADA-DOCK400 | Dock to Firewire 400 Cable |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADA-DOCK800 | Dock to Firewire 800 Cable |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADA-EARJAMS | EarJams |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADA-IBEAM | iBeam |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADA-IMIC | iMic |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADA-PODPOD | Podpod |  | 0 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADAMDP2DPF | [NAME] to Display Port Adapter | 13.05 | 17.4 | 0 | 0 |  |  | 0 |  | 0 | 0.5 | 0.1666666666666667 | 1 | 2 | 17.4 | 1 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 17.4 | 1 | 0 |  | 0 |  | 0 |  | 17.4 | 1 | 0
GE-ADAMDP2HDMI | [NAME] port to HDMI Adapter | 22.05 | 29.4 | 58.8 | 2 |  |  | 0 |  | 2 | 0.5 | 0.1666666666666667 | 1 | 2 | 29.4 | 1 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 29.4 | 1 | 29.4 | 1 | 0 |  | 0 |  | 0 |  | 0
GE-ADVI2DVICMP | DVI to DVI & Component Adapter | 17.55 | 23.4 | 23.4 | 1 |  |  | 0 |  | 1 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GE-ADVI2DVIRGBHV | DVI to DVI and RGBHV | 17.55 | 23.4 |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Totals |  |  | 82.2 | 5 | 0 | 0 | 0 | 0 | 5 | 1.25 | 0.4166666666666666 | 3 | 5 | 46.8 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 46.8 | 2 | 29.4 | 1 | 0 | 0 | 0 | 0 | 17.4 | 1 | 0 | 0
 | Cost in USD | 0 |  |  |  |  |  | Dollar cost to Amber |  | Quantity
 |  |  |  |  | Apr - June |  |  | 46.8 |  | 2
 |  |  |  |  | Jan - Mar |  |  | 29.4 |  | 1
 |  |  |  |  | Oct - Dec |  |  | 0 |  | 0
 |  |  |  |  | July - Sept |  |  | 0 |  | 0