***N O T I C E***
Often, when clicking on a file from a website the browser simply tries to OPEN the file and not download it. If your browser is trying to OPEN the file and it doesn't "know" how since it is a new file format, you might just get a blank page or some other error.
The best way to bypass browser issues like this one is to access the direct download option for your browser. This is almost always done by RIGHT CLICKING on the file link and then choosing to "Save Link As.." or something to that effect. Then select a location on your computer to save the file. Then of course just goto the document location and open the file.
To make this situation even MORE frustrating, the new file extensions of the new office documents are technically NOT a single file. Each docx or xlsx or in this case xltx file is an archive of multiple files and folders that collectively are interpreted by the Microsoft program to act as a single file. This is a problem because some computers and/or browsers are seeing the xltx file and determining that it is an archive (technically true) but then it is overriding the file extension and forcing an interpretation of ZIP (the most common way of archiving multiple files and folders). So then most people would not understand they would have to rename the .zip document in order for Excel to recognize this.
SOLUTION: I will no longer link to the file for a download! Instead I’ve programmed a series of email auto-responders to SEND you the file as an attachment. Follow the links below to fill out the brief form to receive the latest version of the spreadsheet you require.
ATTENTION: This program is writen using a proprietary software by Micro$oft called EXCEL. Furthermore, it uses new tools and features ONLY possible with newer versions of EXCEL.
Backwards compatability in this case is not possible, otherwise most of the advanced tools used and many of the complex formulas would not function.
Microsoft Excel 2007 or newer required.
If you have any questions, email Jared at
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
or call him at 208-227-7044
As an added value to our Distributor Sales Reps and End Users, Grigg Brothers offers its Custom Protocol Spreadsheet., which provides a framework for clear communication and organization of a customized fertilizer program. The worksheet is available for US and EU markets. Always make sure you use the most current version (ver numbers listed online). The current Excel 2007 version provides users with a lot of options and flexibility but it comes at a price: It is a proprietary Excel 2007 template file and not only must use Microsoft's Excel program but cannot use older versions of Excel since features were used that did not exist in prior versions.
Once the Excel template is opened, a new Excel document is created (this prevents you from altering the template accidentally) and it opens to the third of four worksheets (tabbed at the bottom of the screen). The worksheets are titled:
1) GUIDE
2) PRODUCT DATA
3) APPLICATION DATA
4) PROGRAM ANALYSIS
The cells have been locked to prevent accidental alterations that would easily and quickly wreck the functionality of the overall file. There are a lot of sophisticated database type associations and algorithms between the worksheets and changes could interfere with the functionality. An ulterior motive to lock the cells is to prevent competitors from usurping our product list. Interaction is highlighted with YELLOW. All cells that have a yellow fill can accept input from the user or be changed by the user. One example of this is on the PRODUCT DATA sheet in the "MSRP $ / gal" column. By default the prices are omitted from the template however, you could go through and enter all the current equivalent prices then RE-SAVE the template so you would not have to enter prices every time. With a modified template including prices this would benefit in the speed of compiling program scenarios.
The core of the entire file is the APPLICATION DATA worksheet. On this sheet the majority of important variables are entered. In the upper half of this sheet it is important to select the "Known Application Area" in either "FT2" or "Acres" BUT NOT BOTH! Watch for red corners in the upper right of cells. This indicates a helpful tip if you hover over that cell.
The next important variable is the number of times a spray mix will be applied. You could design up to four different mixes to create vairiable intervals of alternating products but of course it is optional. For a basic program you typically would only need to use MIX#1 and so a number in that field will set how many times that mix will be applied.
The next main section of this sheet is the heart of the program: What product at what rate. This selection process is "point and click" by dropping down the selection menu on each row to select the product and then entering the rate. The rest is automatic.
Once the program has been selected and rates applied then you can select the final worksheet PROGRAM ANALYSIS. Nearly every cell on this sheet is automatically calculated or reflected from the other sheets. If you entered a start and end date for the program it will even estimate your spray interval, number of tanks needed, etc. The more information entered on the other sheets, the more complete this analysis will be.
All of us at Grigg Brothers thank you for your support and wish you the best of luck. Please contact your local Grigg Brothers technical representative with further questions to get the most out of designing programs with this tool. Contact Jared at 208-227-7044 or
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
for technical issues related to this file or other integration questions, feature requests, or error reporting.
###
