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

LIC Space folds for good

Farmer co-operative LIC has closed its satellite-backed pasture measurement platform – Space.

Editorial: Time for common sense

OPINION: The case of four Canterbury high country stations facing costly and complex consent hearing processes highlights the dilemma facing the farming sector as the country transitions into a replacement for the Resource Management Act (RMA).

National

Machinery & Products

Calf feeding boost

Advantage Plastics says it is revolutionising calf meal storage and handling, making farm life easier, safer, and more efficient this…

JD's precision essentials

Farmers across New Zealand are renowned for their productivity and efficiency, always wanting to do more with less, while getting…

» Latest Print Issues Online

The Hound

Are they serious?

OPINION: The Greens aren’t serious people when it comes to the economy, so let’s not spend too much on their…

A hurry up!

OPINION: PM Chris Luxon is getting pinged lately for rolling out the old 'we're still a new government' line when…

» Connect with Rural News

» eNewsletter

Subscribe to our weekly newsletter