Please see the section for 3 most common problems:
once you make sure your computer has both macro's and the solver-function enabled and you have the .xlsm file save in a trusted location on your device you should have full functionality to blend
How do I find my username to purchase OptiBlend XLSM and why do I need to provide it?
OptiBlend XLSM needs to know your username to give you access. Each version purchased is good for one user and the program will search for your username to grant access to it.
To find your username on Mac iOS:
Open Terminal (you can search for it with Spotlight Cmd + Space, then type "Terminal")
Type this command and press Enter: whoami
The output is your username
To find your username on Windows PC:
Press Windows + R, type cmd, and press Enter (this simply opens the command prompt)
In the Command Prompt window, type: whoami
You’ll see something like: computername\yourusername
→ Your username is the part after the backslash (\).
What is the difference in the Windows PC and Mac iOS versions?
You need to request a version based on your operating system for blending function to work properly.
3 MOST COMMON ISSUES FOR OPENING AND FULL FUNCTIONALITY TO BLEND:
1. VERIFY YOU HAVE ENABLED MACROS
2. ENABLE THE SOLVER FUNCTION
3. SAVE THE .XLSM FILE IN A TRUSTED FOLDER
1. VERIFY YOU HAVE ENABLED MACROS
Make sure the Excel file is saved as a macro-enabled workbook (.xlsm).
If Excel displays a yellow warning bar at the top when you open the file, click "Enable Content" or "Enable Macros".
Files downloaded from the internet or email might be blocked by Windows.
Right-click the file > Properties > check "Unblock" if it’s there, then click OK.
If you do not see this option you can also go to File > Options > Trust Center ?> Trust Center Settings > Trusted Locations
Make sure you have the file saved in a folder that Excel considers a trusted location (or add one where it is saved)
How do I enable macros in Microsoft Excel?
For Windows (Excel Desktop):
Open Excel. > Go to File > Options.
Click "Trust Center" on the left pane.
Click "Trust Center Settings…" on the right.
Choose "Macro Settings" from the list.
Select "Enable all macros" (not recommended for general use) or "Disable all macros with notification" (preferred).
Make sure "Trust access to the VBA project object model" is checked if needed.
Click OK, then OK again to exit settings.
For macOS (Excel for Mac):
Open Excel. Go to Excel > Preferences > Security.
Check the box "Enable all macros" or "Disable all macros with notification".
There is no Trust Center like on Windows, so the options are simpler.
2. ENABLE THE SOLVER FUNCTION
Enable Solver in Excel for Windows:
Open Excel. > Go to the File tab > click Options.
In the Excel Options dialog box, click Add-ins on the left.
At the bottom, make sure Excel Add-ins is selected in the “Manage” dropdown.
Click the Go… button.
In the Add-Ins box, check the box next to Solver Add-in. Click OK.
Enable Solver in Excel for Mac:
Open Excel. Go to the Tools menu.
Select Excel Add-ins….
In the Add-Ins window, check the box for Solver Add-in. Click OK.
3. SAVE THE .XLSM FILE IN A TRUSTED FOLDER
Windows: Excel Trusted Location Setup
Open Excel (you can open any workbook or just a blank one).
Click on File (top left).
Select Options (at the bottom of the left panel).
In the Excel Options window, click on Trust Center (left-hand side).
Click the Trust Center Settings button.
In the Trust Center, choose Trusted Locations from the left menu.
Click Add new location...
In the dialog that opens:
Click Browse... and select the folder you want to trust.
Optionally, check Subfolders of this location are also trusted.
Click OK to confirm.
Click OK in all windows to save your changes and exit.
Mac iOS, Excel does not offer a built-in UI to manage trusted locations like Windows does, but here’s how to handle it:
Option 1: Grant Full Disk Access (workaround for macros/VBA issues)
Go to System Settings > Privacy & Security > Full Disk Access.
Click the + button and add Microsoft Excel. Restart Excel.
Option 2: Store files in Microsoft-recommended locations
Macros and scripts are more trusted when: Saved in your Documents folder.
Opened from OneDrive, especially if signed in to your Microsoft account.
Not downloaded directly from the internet (right-click downloaded files and select "Remove from Quarantine" in Terminal using xattr if needed).
Why is 21-0-21 not removable from my ingredient list?
Occasionally, there are ingredients that are very similar in cost when blending, 21-0-21 is a product for example, if selected as active the blender will force it into the blend even if it costs just a bit more (typically the blend is always going to calculate the blend the cheapest possible way, but this is one small exception)
If you have other products that you would like to add and force it to use in your version, please send us a message.
Why am I not seeing a total blend cost?
If pricing parameters are out of range or a blend cannot be created based on provided inputs you may not receive a price. Please verify accuracy of the input pricing and double check targeted nutrient values. A price will also not be provided if pricing is not realistic (i.e. way more than it should be), this is to help prevent inaccurate pricing.
On the Itemized Blend sheet you need to have both a rate (lbs/ac) and the total pounds of ingredients must sum to 2,000 lbs.
What is Titan XC and why is there a calculator for it?
What is Titan XC?
Titan XC is a biocatalyst fertilizer additive made by Loveland Products (Nutrien Ag Solutions)
Specifically designed to be applied to dry granular fertilizers.
Contains a concentrated blend of enzymes and organic acids.
Applied directly to fertilizer before spreading or blending.
How do I use the calculator?
Titan XC is applied to P and K portions of the blend (not nitrogen) such as MAP, DAP, and POTASH
Simple enter in the rate of product per acre and how many pounds per ton of ingredient that you want to apply Titan XC to
This will give you a per acre cost of Titan XC base on your per gallon cost
Benefits of Titan XC on dry fertilizer:
Increases nutrient availability by helping release bound nutrients in the soil.
Enhances microbial activity in the soil, which supports nutrient cycling.
Helps fertilizers break down and mineralize faster, leading to quicker plant uptake.
Can improve efficiency of P and K fertilizers (like MAP, DAP, potash).
May lead to better root development and early season vigor.
Potential for higher yield and better return on investment by maximizing what’s already being applied.
