Multi-lingual Job Board

The job board that I created using google docs has been a very useful and powerful planning and organizational tool for me. In fact, I consider the ability to plan 2 weeks in advance the best part of my job board. In a recent disicussion on twitter with Scott Dickson (@scottAllD) he asked if there was a way to translate the contents of the job board as some of his staff didn't speak very good English. I looked into it and it turns out that Google has included a translate function in Sheets! A few mintutes later I had added the functionality to my job board to translate between any 2 languages or more!

This discussion reminded me that not only is my job board a planning and organizational tool, but it is also a powerful communication tool! The ability to translate adds so much to golf maintenance crews that are more diverse than my crew (we all speak english).

Spanish anyone? how about Chinese?

For those of you who use my job board I will share the formula that gives the job board the ability to translate for you. Just paste this formula into cells C4:F8. You will also need to add a column to the right of the employee names in the "lists" sheet. This will be where you put the language codes for each employee into. "en" for English, "es"for Spanish. A full list of the language codes can be found here. Just use the 2 letter code in column 2. Now all you have to do is add tasks to the planner and voila, they appear in the desired language on the job board!

=iferror(googletranslate(iferror(hlookup($A$1,Planner!$C$1:$P$27,C$3+$B4,false())),"auto",vlookup($A4,Lists!$B$1:$C$24,2,false())))

I have set the input language to "Auto." What this does is use the system language settings as the input language. I highly encourage people to check out my formulas and learn how they work. Google has a great function help section that you can use to reverse engineer the formulas I use in my sheets.

add a colum to the right of the employee names

The really cool thing here is that you can assign different languages for each employee. One issue that I do see arising is how google translates the different tasks I have outlined. As I only speak one language I cannot check to make sure any of the translate correctly. I guess some trail and error would be required to ensure that each taks put into the job board is translated in a meaninful way for your staff.

If you have a multi-lingual crew I highly recommend checking out the =googletranslate function in Google Sheets. This adds a powerful tool that most of the paid software job boards can't offer and best of all it's free!

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 ...

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...

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 ...

Fusariummy

Search This Blog