Tuesday, 10 September 2013 16:04

Sorting your rams and your rows

Written by 

NEW ZEALAND farmers lead the world in efficiently turning pasture into milk, meat and wool. And our technical skills and innovation are undisputed, e.g. developing new grass types and electric fencing.

 

But in computer innovation, farmers sometimes get left behind – more likely to be sorting stock in the yards than sorting rows in a spreadsheet. 

Using computers for on-farm business decisions is crucial as we make use of data for many tasks, such as managing data from eartags and running milking machines.  The challenge is to make those decisions quickly and efficiently.  

Mastering a spreadsheet, sharing files via the internet or navigating a city using a smartphone may not be as technically stimulating as building a seed drill, but you need to be able to do it.

This column will give practical advice and grow a wider understanding of how technology is changing and how this could be applied on your farm.

If you are spending time entering data twice or taking information from one system to another, then there is almost always a better and faster way.

For example, Microsoft Excel should be a farmer’s best friend. It has powerful functions including conditional formatting, advanced sorting and filtering, plus timesaving lookup and reference formulas such as the ‘vlookup’ and transpose functions.  

One of my favourite, but misunderstood, Excel functions is pivot tables: these allow you to quickly sort and arrange your data in any way you want. A farmer friend I showed this to promptly saw he could save 30 minutes at the end of each day.  

To learn more about pivot tables, download a quick sheet here: www.rippedorange.co.nz/pivottable

Next month, we will explore the world of Cloud Computing, which has nothing to do with weather forecasting – but all to do with working together and saving time.

• David Jackson, of Canterbury, studied at Lincoln University and has had several years agribusiness experience. He now helps people make the most of technology. Ripped Orange is a technology training company.

Featured

Govt Commits $4m to Rural Wellbeing Initiatives

While the District Field Days brought with it a welcome dose of sunshine, it also attracted a significant cohort of sitting members from the Beehive – as one might expect in an election year.

Shane Jordan Beats Brother to Win NZ Timbersports Title

While not all sibling rivalries come to blows, one headline event at the recent New Zealand Rural Games held in Palmerston North certainly did, when reigning World Champion Jack Jordan was denied the opportunity of defending his world title in Europe later this year, after being beaten by his big brother’s superior axle blows, at the Stihl Timbersports Nationals.

National

Machinery & Products

Chinese Tractors Eye Western Europe

Having caused quite a stir at last year’s Agritechnica, Chinese manufacturer Zoomlion is reported to be conducting large-scale field trials…

Franz Grimme Turns 80

Franz Grimme recently celebrated his 80th birthday earlier March and continues to be an entrepreneur with passion and pioneering spirit,…

» Latest Print Issues Online

The Hound

What A Choice!

OPINION: If you ask this old mutt, the choice at the next election isn't shaping up as a contest of…

Your Call!

OPINION: A mate of yours says we're long overdue for a reckoning on what value farmers really get for the…

» Connect with Rural News

» eNewsletter

Subscribe to our weekly newsletter