Spy Journal 3.0 Filtering the web for you

Geek Girl Profile -

Name: Laurel Papworth
Screen Names: SilkCharm or Laurel Papworth.
Personal Blogs:
http://silkcharm.blogspot.com (social networks blog)
http://laurelpapworth.com (corporate site)
http://bloggerati.com.au (not a blog but a social news site on Web 2.0 in Australia)
http://mymobilepals.com  (mobile phone social networks)
Social Networks:
Bebo, BlogTalkRadio, Cyworld, del.ico.us, Digg, Dopplr, Facebook, Flickr, FriendFeed, Friends Reunited, Furl, Hi5, Jaiku, Last.FM, Linked In, Ma.gnolia.com, MyBlogLog, MySpace, NewsVine, Ning, Plurk, Pownce, Second Life, Slideshare, Social Networks blog, SocialThing, StumbleUpon, Technorati, ThisIsMyJam, Tumblr, Twitter, Upcoming, Vimeo, Wikipedia, YouTube.

Data Filters are a very powerful way of analysing tables of data in Excel. Put simply they are a way of reducing the table down to just the items you want to see based on the selections you choose.

For example a simple table like this one, may have several hundred or thousand rows of data. However there may be only a few lines you are interested in. For example you may be only interested in people under the age of 18 or sales amounts that are negative (indicating a refund) or only see sales of red Ferraris.

Turning on the Filters

In Office 2003 Turn on the filters by selecting any cell in your table (contiguous section of data) and selecting Data, Filter, Auto Filter from the menu. (Keystroke ALT D F F)

The arrows will show up as in the next picture.

Here’s the specs of my next PC

• Intel S775 Core 2 Extreme QX9770 3.2GHz Quad-Core CPU
• Zalman CNPS9700 LED CPU Heatsink
• ASUS S775 P5N-T Deluxe Core 2 Motherboard
• Integrated Sound Card
• Integrated Gigabit Network Connection
• DDR2 8GB Geil 800MHz EVO ONE Quad DDR2 Kit
• 300GB Western Digital VelociRaptor 10000rpm Serial ATA HDD
• 1TB Seagate 7200rpm 32M Serial ATA HDD 24x7
• Seagate 750GB Freeagent Desktop External USB 2.0 HDD
• Internal All-in-1 Memory Card Reader Black
• Pioneer 4x BDR-202BK Blu-Ray DVD-RW Writer
• ASUS 9800GX2 1GB PCIe Overclocked Video Card
• ASUS 9800GX2 1GB PCIe Overclocked Video Card
• ASUS 9800GX2 1GB PCIe Overclocked Video Card
• 22" (55cm) Samsung 2243BW Widescreen LCD Monitor
• 22" (55cm) Samsung 2243BW Widescreen LCD Monitor
• 22" (55cm) Samsung 2243BW Widescreen LCD Monitor
• 22" (55cm) Samsung 2243BW Widescreen LCD Monitor
• 22" (55cm) Samsung 2243BW Widescreen LCD Monitor
• 22" (55cm) Samsung 2243BW Widescreen LCD Monitor
• Antec Twelve Hundred Black Case (No PS)
• Tagan 1300 Watt Power Supply
• Logitech G15 Gaming Keyboard
• Logitech MX Revolution Cordless Laser Mouse
• Logitech G25 Racing Wheel
• Powerware 5110/1000VA Line Interactive UPS

Total Price $11,065

I had to get up at 6:35 this morning. Was on the road by 6:45 and at the ground by 7:15. We stood around talking for a few minutes then headed into the change rooms to get rubbed, strapped and dressed. Coming  out on to the ground we discovered it was still quite wet with dew, and very small for an AFL ground. I think it was probably 30-40 metres short and probably 20 metres less wide. This made for an interesting game as 36 blokes got very close together – not a lot of room for kicking.

I was put at fullback for the entire game. The first bloke I had to mark up on playing full forward was way too fast for me. He got in front of me and took an easy mark. So I played a little in front of him for a it and spoiled the next couple of marks he ran for, and then a ball cam spiraling down toward us – I held him off and the ball sailed over my head and he grabbed it. Very annoying. Two goals scored on me. The next ball that came our way was way out on the sideline and was being tussled over by the forward pocket and half forward for their team and our back pocket and half back flank. My man went running there looking for the ball and as he got there I hit him hard. He didn’t come back for the rest of the game and I had a succession of other players rotate through full forward. One was a good 8 inches taller than me, but he was the easiest to mark. All though he ran hard he wasn’t too fast and i was able to keep body contact on him long enough to spoil his runs. I was also able to hold him away from the ball and stopped him getting involved in numerous passages of play. I did have one other chap that subbed for him who kicked two easy goals on me which was also annoying, but the rest of the guys who came in I either blocked them from marking or punched the ball away.

I had never played in the back line before the last game, and now I have had 2 games at full back, got coaches award for one and was mentioned second today. I didn’t think I had that good a game, but the other blokes all reckoned I did. Maybe I am just too hard on myself.