EXCEL HELP Chemical Applicaton Records Cancel The title field is required!

1. Mark Murphy

   

   0 posts
   
   1/18/2017 10:01 AM

   Anybody willing to submit an excel spreadsheet with dropdowns, rate formulas etc? We are trying to streamline our record-keeping for chemical application logs. We don't have an excel wizard on staff but would probably be able to make something that works for us if we can use formulas that others have already blueprinted. Look forward to your responses. Please kindly forward your spreadsheets to cgregorski@1757golfclub.com.
   
   Thanks

   
   
   
   
2. Larry Allan

   

   0 posts
   
   1/18/2017 11:01 AM

   SPaRKs has a very good package if you are looking for a great set of forms and inventory keeping. I pretty much abandoned Excel for the purpose
   
   https://www.sparks2web.com/SPaRKS/logon.jsp

   
   
   
   
3. Steve Datwyler

   

   2 posts
   
   1/18/2017 7:01 PM

   Dr Bill Kreuser from UNL has a great web based program called GreenkeeperApp that can track chemical applications specific to your golf course. You can populate your area square footage/acreage, sprayer/equipment, many products/rates are already in the database and you can add more, it tracks GDD for PGR applications, lots of great features, much easier that working off of an Excel spreadsheet.
   
   http://www.greenkeeperapp.com/

   
   
   
   
4. Clay Putnam

   

   33 posts
   
   1/19/2017 6:01 AM

   Mark Murphy said: Anybody willing to submit an excel spreadsheet with dropdowns, rate formulas etc? We are trying to streamline our record-keeping for chemical application logs. We don't have an excel wizard on staff but would probably be able to make something that works for us if we can use formulas that others have already blueprinted. Look forward to your responses. Please kindly forward your spreadsheets to cgregorski@1757golfclub.com.
   
   Thanks

   
   
   Mark,
   
   Any excel spreadsheet with dropdown menus will require some working knowledge of excel to input the appropriate products (fertilizer, fungicide, herbicide, etc). You will need to create a separate list of products you want in the dropdown menu then import that list into the dropdown menu of the application ledger. Its not that difficult once you've done it but it can seem daunting to get started. Do a "creating dropdown menu" search on youtube. You'll find some easy to follow tutorials.

   
   
   
   
5. Chris Cook

   

   0 posts
   
   1/19/2017 8:01 AM

   I second what Larry said. I've been using Sparks for several years now and it is very useful. Inventory tracking, application planning, reports, and thorough records are all huge benefits of the system. And it's only $185/year. As long as you update the unit costs of what products you plan to use that year, the application costs will be accurate and you can track your costs throughout the season much closer.

   
   
   
   
6. Paul Double

   

   37 posts
   
   1/20/2017 7:01 AM

   I really like the sound of the Sparks software and I checked out their website. My question to those who have been using it, do they keep it updated. As products are put on the market or if labels change, are they quick to update or do they only update every few months. Just curious as I may get this software.
   Thanks
   Paul

   
   
   
   
7. Chris Cook

   

   0 posts
   
   1/20/2017 8:01 AM

   Paul, the database will have a substantial amount of products and container sizes loaded already. However, it is likely not to have everything, especially any fairly new items. The web-based version they recently went to allows for more frequent software updates. They also seem to listen to feedback and update the software as needed to fix small issues. Each winter, I have my vendors send me updated unit costs of the products I know I'm going to use and this allows me to plan my budget down to the penny for the upcoming year. Talk to Andy and he'll answer any additional questions you have. He's been very helpful over the years.

   
   
   
   
8. Larry Allan

   

   0 posts
   
   1/21/2017 9:01 AM

   I think Paul nailed it with his answer.
   One other thing for any international supers who need to do the work in metric. It is not a metric based system however because of the systems flexibility, it was extremely easy to modify to Metric. Because you name the container size ie in my case "10 Liters" You simply tell the program that a 10 litre container has 340 US ounces. Once you have set up the container size to your requirements, the program does all the work in telling you how many containers you need based on your "Plan"
   
   I would highly recommend the program. Andy is extremely helpful even when you accidentally pocket dial him in the middle of the night