jethro's blog

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

Construction work

2009-07-31 mucking around 046Today was a DIY day. I designed and built this enclosure for the blue tongue skinks this morning. Start to finish around 2.5 hours.

The base and sides are medium density fibreboard as are the end and centre pieces. the bottom is braced with 3x2 batons that also work as feet.

The centre top piece is a bit of MDF, and the end mesh pieces are bits of an old bird cage that was lying around in the rubbish heap to be taken to the tip. Now it forms the essential part of letting light in and keeping our snakes and stopping the skinks from escaping. One end is hinged ad allows easy access to the skinks while the other end is fixed but has two openings in it.

2009-07-31 mucking around 048 2009-07-31 mucking around 047

Job well done.

Oh and Heidi helped Tim the Toolman as well.

jethro's picture

Default sorting options in Excel

This article has been written in response to a readers question.

CB107982_LoRes Traci writes:

When I take a spreadsheet that someone else has created & remove some unwanted columns & rows, add a notes column of my own outside of the last column of their original spreadsheet, it won’t pick up that last “notes” column when it sorts.  If I highlight the entire document it will, but most people don’t highlight the whole thing when they sort.  We share this document with other people, they sort it and don’t realize that they didn’t sort the notes field.  Do you know of a fix to include the extra added “notes” column in the “my data has headers” “sort by” option that will travel with the document?

jethro's picture

Excel News from Charley Kyd

Introducing IncSight DB

Charley Kyd has extended his offerings for business excel users with a new product called IncSight DB.

Unlike his first plug-n-play dashboard product, this one links its reports to an Excel database. This design offers several great advantages:

  • It should take less than an hour to set up a report.
  • Reports can be updated in seconds each period.
  • The Excel database can contain formulas that return data from PivotTables, text files, OLAP databases, and other sources.

You can see a video of IncSight DB at his site, which shows how he sets up a new dashboard in about 20 minutes.

Charley is offering a $10 coupon for all orders of $50 or more. But the coupon will be good only for the rest of July. So if you're thinking about ordering, now's the time.

Coupon code: July 2009

When you order IncSight DB, enter this code in the payment form and choose Apply. After you do so, you'll see the discount amount subtracted from your order.

Charley also writes about Excel 2010

jethro's picture

Fashion Sales

Be Warned - Geek girls (and other readers of the gentle female persuasion) may be excited after viewing the following notices of clothing on sale! Boyfriends and husbands should watch for signs of wallet fingering and wardrobe shuffling and muttering – “There’s no room i here - what can i throw out to make room for all these yummy clothes?” Spyjournal takes no responsibility for sudden increases in credit card limits.

These adverts were found on Missy Confidential - not affiliated with Spyjournal.

Brisbane

3400_2996abdb7066_204x347

Madaboochoo are having a massive warehouse sale where you could win $5000* worth of new season designer clothing.

All you have to do to win this amazing prize is come along on the day of the sale and purchase any item of clothing.

*Please see the website for full terms and conditions of entry www.madaboochoo.com.au

WHEN
Saturday 25th July, 2009- one day only.

WHERE
Unit 9, 21 Duntroon Street, Brendale, Brisbane