Spy Journal 3.0 Filtering the web for you

I wrote this in 1999. I have no memory of writing it, or the circumstances that led to writing such painful words. I am absolutely sure it was not about my wife – I suspect it may have been about a friend who had some massive issues at that time.

Anyway here it is.

Done It Again

Words like twisted, painful and bitter

Aren't the words for a passionate lover

How I feel is broken and battered

Rejected, despised - I think I've been worked over

You set me up

I gave you my time, my heart, my caring

You said our love was honest and daring

After all my heartfelt devotion

You filled my head with violent emotion

You set me up

You lied, you cheated, you told me it was nothing

My friends all saw that I was hurting

I laughed it off and tried to ignore them

I squashed down the pain and tried not to listen

You set me up for a broken heart

© Timothy Miller 1999

Continuing to post my poetry online. This poem was written during a period selling Amway in 1999.

There was a young man from Coonabarabran

Who lived with his grandma and great aunty Nan

He went to work and sweated all day

While they stayed at home and spent all his pay

This state of affairs did continue to exist

Until the day he decided to resist

He said this job is driving me crazy

And grandma and Nan are just plain lazy

I know what to do he jumped up and said

If you want to do something to get ahead

Go meet some people – go say gidday

Get paid for shopping – just join Amway

He went to a meeting and got all fired up

He dreamed a dream – saw the winner’s cup

And now he lives a fun life each day

And grandma and Nan can’t spend all his pay

There’s so much money and so much time

And this line of the poem just has to rhyme

He’s going diamond and having a ball

The secret was dreaming and not thinking small

© Timothy Miller 1999

I shoot a lot – and well over 1.2 million photos. So its rare that i get a photo that to me is outstanding – though I do love what I do and I work hard on every shoot. Still there are moments when you just know you got a photo that is amazing. At least to me.

So here’s some work I am particularly proud of. Seems to be a common theme that most of them were shot on the Canon 85mm F1.8 prime lens.

The Subtotal function is commonly used when creating Subtotals on a table with the Data | Subtotals Menu command. However it can be just as easily used by writing the formula and has some powerful uses.
The syntax is SUBTOTAL(function_num,ref1,ref2,...)
The function numbers allow you to use any of the following functions in the subtotal:

The most common is of course the SUM function.
When and why should you use SUBTOTAL and not just the SUM function on its own.

The SUBTOTAL function has some powerful abilities that the commonly used SUM function doesn't. For example when summing a list of cells that contains hidden rows or columns the SUM function will include them. However the SUBTOTAL function only operates on visible cells. The values of the hidden cells are excluded from the total. This is especially useful when filtering a list if you want to see the total of the visible (or filtered) cells.
Note by default, if you have a filtered list of values and you double click the sum (sigma) icon on the toolbar after you select a cell below the bottom of the filtered range Excel will not use a SUM formula but automatically use a SUBTOTAL function.

The SUBTOTAL function ignores other subtotals within the range. So if you have several subtotals and a grand total, the grand total formula can be the subtotal of the entire range that includes the subtotals and it will ignore them.

Links to my other Articles about Subtotals including using outlining.

http://www.spyjournal.biz/exceltips/2005/03/creating-subtotals-in-excel.html

http://www.spyjournal.biz/data_filters_in_Excel_2003_and_2007