Convert Those Pesky Metric Measurements

Easy spreadsheet makes conversions simple and offers range of options.

Agriculture is becoming more global every day and the system of measurement is not consistent around the world. Reports come in about export shipments and production values in tons, kilograms, pounds, bushels, hectares, acres and more. Converting these values to a common measurement can be a challenge to the most number savvy and downright impossible for some. Iowa State University has a simple and easy to use spreadsheet that will allow the user to convert everything from simple linear measurements all the way to crop prices in different currencies. Keeping all of these conversions in one place allows the user to make conversions to any set of reported information and put it into term that make sense.  

William Edwards and Ann Johanns developed the spreadsheet to simplify the process of converting between different measurements, prices, currencies, temperatures, and even application rates all in one place. Overseas travel and the need to convert USDA reports to English measures have increased the need for these simple conversions in an easily understood format. This spreadsheet covers nearly all of the important conversion factors that today's agriculturalist will need. These conversions are a necessary tool in every farmer's toolbox as agriculture increases its global interactions.

We're featuring the spreadsheet as our Farm Futures Spreadsheet of the Month. The 121-kilobyte spreadsheet should work with Excel 2000, 2002, 2010 or Excel XP. You can download it by using the link below.

Do you have a spreadsheet that's made a difference on your operation that you'd be willing to share with other readers? Drop us a line at [email protected] with a description of the spreadsheet. We'll pay $75 if we feature your farmer-written noncommercial program as our Spreadsheet of the Month.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.