OxygenOffice Professional

windows

OxygenOffice Professional (originally: OpenOffice.org Premium) is an enhanced version of original OpenOffice.org. OxygenOffice Professional contains more extras like templates, cliparts, samples and fonts.

http://www.download.com/OxygenOffice-Professional/3000-2064_4-10772250.html

Sean’s Shinies

• ThinkGeek Annoy-o-tron

  Product Webpage

  $10
  Our friends at ThinkGeek.com definitely have an evil streak in them — the Annoy-o-tron is a small electronic doohickey that’s designed to annoy people by emitting irritating beeps at irregular intervals so that it’s incredibly distracting but also incredibly hard to locate. It’s pretty easy to hide, and comes with a magnet for sticking to a metallic surface. The downside is that if your victim ever finds it — they’re probably going to smash it, and you’ll be out $10. Comes with three different annoying sounds.

  Shiny
  - drive co-workers crazy
  - easy to hide
  - irregular beeps – hard to locate
  Dull
  - if they find it, they’ll break it
  - may annoy YOU too

  Annoy-o-tron
  ThinkGeek.com

Sean’s Shinies

• ThinkGeek Annoy-o-tron

  Product Webpage

  $10
  Our friends at ThinkGeek.com definitely have an evil streak in them — the Annoy-o-tron is a small electronic doohickey that’s designed to annoy people by emitting irritating beeps at irregular intervals so that it’s incredibly distracting but also incredibly hard to locate. It’s pretty easy to hide, and comes with a magnet for sticking to a metallic surface. The downside is that if your victim ever finds it — they’re probably going to smash it, and you’ll be out $10. Comes with three different annoying sounds.

  Shiny
  - drive co-workers crazy
  - easy to hide
  - irregular beeps – hard to locate
  Dull
  - if they find it, they’ll break it
  - may annoy YOU too

  Annoy-o-tron
  ThinkGeek.com

RAID De-Mystified

Frank Linhares

Co-Host/Producer: www.DigitalUnderground.tv

With technology advancing at lightening speeds what was once only available to higher end users or server based environment is now available to the average user. RAID is the best way to ensure that you have some form of redundancy for your data. RAID 0, RAID 1, RAID 5, RAID 1+0 all of this can be very confusing.

RAID (Redundant array of independent disks, formerly redundant array of inexpensive disks) is in short a failover system for hard drives. A certain number of hard drives (2–4) work together as one logical drive. If anyone of those disks fails at any time none of the data is lost, you simply have to replace the failed drive and the system will automatically rebuild the array.

RAID comes in many flavours.

RAID 0 (also known as a stripe set or striped volume). This is essentially a JBOB (Just a bunch of disks) configuration and provides no data redundancy and is not recommended for maintaining data integrity. Essentially you add up the space of two hard drives (or more) and it will show up as a single big drive.

RAID 1 creates an exact copy or mirror of a set of data. This is great for ensuring that data integrity is maintained because if any disk fails the other one immediately takes over and is completely transparent to the user.

Raid 5 uses stripping to both provide performance and redundancy. By using a min of 3 disks you can achieve super fast speeds and complete data redundancy, as long as only one drive dies. If multiple hard drives fail you will lose all your data. You generally get 75% of your total drive capacity in order to maintain speed and redundancy.

Pivot Tables in Excel 2007

Bill Jelen

www.mrexcel.com

Create your first pivot table. Summarize revenue by region and product.
• Insert – Pivot Table.
• Verify the data range. Click OK.
• Note the new interface. You now select fields in the field list and arrange them in four drop zones at the bottom of the field list. This is easier than dragging fields into the worksheet.
• Simply checkmark the Region and Revenue fields.
• When you check the Product field, you need to drag it to the column area.

Change the Pivot Table:
• Add Customers as a new row field.
• Notice the expand and collapse functionality

New Features in Excel 2007
1. Formatting a pivot table has dramatically improved. There are now 24K formats instead of the old 14 formats. Remarkably, most of the new formats look good, while none of the old formats looked good.
2. Filtering by row fields; easy to filter dates to a specific month, revenue to above average, or text fields to those containing a value.

I will post show notes at http://www.mrexcel.com/tip154.shtml