Skip to main content

Automatically Updating Hargraves ETo, Pace Turf Growth Potential, and Smith Kerns Dollar Spot Model Google Spreadsheet

Last week I decided to learn to code so that I could pull weather data off the internet and into my spreadsheets. This would allow my weather related models to update by themselves without me having to intervene. I have enough stuff to do than worry about updating weather data manually when computer can do it for me.


After some trial and error I was able to pull past weather data and a 7 day forecast for any location on earth into my spreadsheet and analyze it to calculate evapotranspiration, growth potential and the dollar spot potential.


Follow the directions carefully and please, do not request to edit this file. Simply go to File -> Make a copy and you will have your very own version to edit. Further instructions are on the spreadsheet.


Having this data at your fingertips makes decision making easier. You can see how much water your grass might use, what the disease pressure is, and how optimal the conditions are for growth.

I have also been working on a Heads Up Display (HUD) to display all the information that I gather so that it is front and center to help me make decisions.

That's one of the biggest advantages of google sheets. You can share the workload with adding data into the sheets with forms or automatically with scripts and instantly analyze that data in useful ways that can help you make better decisions based on the facts.


If you are interested in making a HUD for yourself I highly recommend learning how the =importrange() function in google sheets works so that you can pull data from any of your spreadsheets into one place easily and in real time.

If you like my blog and want to support what I do you can support me on Patreon or paypal. Thanks!

Labels:

Popular posts from this blog

Turfgrass speedo is still my most important tool for managing turf growth after 4 years.

It wasn't the easiest year for growing grass , but the conditions were still pretty good. Almost 4 years ago exactly, I came up with the idea of comparing actual clipping yields to the "ideal" clipping yield or the clipping yield adjusted using the Growth Potential Model . Since then, it has proved to be a much more useful tool to manage growth than I originally thought .  It has been almost a decade since I started making observations on plant health and playability and how it relates to the clipping yield. I have been constantly searching for ways to get the growth rate right as often as I can and this tool seems to be the best way I have seen so far, and might ultimately, be the best way going forward. To prove this point I will discuss in a future post, the success I've had with pest control in the past few years (for the most part (Not withstanding the times where I think my greens are dead but they actually aren't...thanks T)). Never needed less There are ...
Read more

Do you have enough?

I recently discussed how we can use fertilizer ratios to simplify how much fertilizer we apply to help us keep above the MLSN guidelines . When we get a soil test done it is a static amount of nutrients found in the soil. Even if you are above the MLSN guidelines at the time of testing, it doesn't guarantee that you will remain at or above the guidelines as the grass grows and consumes nutrients. There is math that you can use to determine exactly how much nutrient you need to apply to ensure that you remain at or above the MLSN guidelines. For many, this is much too complicated. For that reason I made a quick cheat sheet to help you determine how much of each nutrient you can expect to use each year based off a few different annual nitrogen rates. Nutrient use is based primarily on nitrogen use so the left 2 columns are a few different nitrogen rates. The columns for each nutrient are in PPM and are designed to help you look at your current soil test PPM (mehlich 3) and determin...
Read more

How to quantify nutrient content in liquid fertilizer

In a recent post, I discussed how it was actually cheaper to spray soluble vs granular fertilizer. What about if we use pre-mixed liquid fertilizer? How do we even figure out how much nutrient we are applying with pre-mixed liquid fertilizer?  Before I learned that you could simply dissolve soluble fertilizer in water and apply it in a sprayer, I was a big user of pre-mixed liquid fertilizers. One of the issues I initially had was figuring out exactly how much of each nutrient I was applying. The math wasn't as straightforward is it was with granular fertilizers. It turns out, it's actually not that difficult but requires an extra step.  First, we need to convert the liquid volume into a mass. Many products will have the product density displayed on the label or you can look in the Safety Data Sheet (SDS) for that information as well. No SDS? Should you be using products without an SDS? Even if this information isn't included on the label it is very easy to figure out. All ...
Read more