• Sharebar

## There was a young man from Coonabarabran

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

## Some recent photos I am pretty proud of

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.

## Using the SUBTOTAL Function in Excel

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:

 Function_num  (includes hidden values) Function_num  (ignores hidden values) Function 1 101 AVERAGE 2 102 COUNT 3 103 COUNTA 4 104 MAX 5 105 MIN 6 106 PRODUCT 7 107 STDEV 8 108 STDEVP 9 109 SUM 10 110 VAR 11 111 VARP

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.

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

http://www.spyjournal.biz/data_filters_in_Excel_2003_and_2007

## Back to School

No I am not going back to school. However as part of a blog circle that is the theme for this month.

When the topic was posted i had no idea on what to write. I don’t have many happy memories of my school years. I was bullied heavily for most of it. Skinny and small with glasses, a smart wit and tongue, I didn’t fit in well. Taking French in a largely blue collar school, playing the violin (there were two violinists in the entire school) and being a Christian marked me out as different, and in packs people fear those who are different because they threaten the pack mentality. There was a certain level of thuggery and a pecking order rapidly established based on physical superiority early on in my high school years. I learnt quickly to avoid confrontation wherever possible.

As an academic minded kid I was also not really stretched by my schooling. For most of my life I rarely if ever did homework. I didn’t study for exams but breezed through them with almost no study (except for French).

So holidays were for me blessed relief from the hum drum of school and the constant planning to escape the bullies i had upset on any particular day who were waiting for me down the road. I knew all the back ways home and i could run and bike fast! Back to school was a long time ago and i have little memory of those times.

As an adult now with kids who are home-schooled we also don’t really understand the “back to school” phenomenon. Admittedly we do have holidays but our schooling is so much more relaxed than the normal school families experience. And to be fair my wife manages 99% of that.

I pondered that for a while. I ruminated various ideas and wrote some posts in my head that never saw the light of day.

And then it dawned on me.

Life is school.

We are always at school. We are always learning. And if we aren’t. then we are missing the learning opportunities being given to us every moment of every day.

As a photographer I have taken well over a million photos. Over the weekend I took 11,000 at an event, most of which were shot in the same location – just of different people. You might think that isn’t a place to learn. And in some ways that is correct. In fact if I didn’t already have the skills and gear to manage that and perform I wouldn’t have been hired to shoot. But as I watch people coming through an “electric shock therapy” obstacle where they are electrocuted as they run through mud I am constantly learning. Technically I am managing the environment, light, gear and people around me to ensure I can get the shot, and I am striving to get each shot better than the last. This is learning. Using the knowledge of the past to improve the future.

And if in micro adjustments I can shoot the 10,001st photo better than the 10,000th one than I have learnt. I have used my past to change my future.

So I cast my mind further out and wonder at how many opportunities we get every day to learn that we just ignore, or don’t even recognise.

• When my child shows me something she is proud of or just wants to show me, am I learning a little more about her personality and her mind, or am I distracted and ignoring her?
• When I am driving am I fine-tuning my ability to manage my car and thus almost imperceptibly improve the safety of those in my car and around me?
• As I craft this article and think about the impact I may be having on others with my words, am I careful about which words I use?

As you read this are you conscious of the learning you can take out of this small article, or are you letting it flow on by? What moments do you have each day that you can learn from but just ignore?

As we learn to live in the present moment and forget the distractions of a future we cannot change by worrying about it, I challenge you to unlock the enormous potential of your past to change your future by learning from your mistakes and improving the way you do everything.

• Don’t just keep doing things the same way. There is no gain in that. All of mankind’s greatest achievements came from dissatisfaction with the status quo.
• Do constantly look for improvement – even in the most minute of things, wash the dishes just that little bit more efficiently and save water, time or electricity. The gains may be eternal for someone you can impact with that saved time.

My prayer is that as I can continue to be open to learning that I will change and grow. Back to school is every day.

PS my past school life doesn’t bother me. I made those observations but I don't carry around grudges or bitterness (I hope). Rather I look for ways to positively influence others to not let their past destroy them, or to destroy others.

Finally I’ll leave you with a photo of someone being electrocuted! They even paid for that pleasure.

This blog post is part of a blog circle.  Our theme for this month is Back to School.  Please come back this week, and read the posts of the others in my circle: