We are excited to announce new expanded compatibility of our Least Cost Ration Calculator to Google Sheets. We hope you find the added accessibility and shareability of the Google Sheets Least Cost Ration Calculator as beneficial as we do.
You'll find helpful information on getting started below.
Enjoy!
First step - please log out of all your google accounts, then log back in to just one account. This LCR calculator uses the OpenSolver extension. It's free and simple to use, but you'll have to install it. Click here for a video walking you through how to install it.
After you have the OpenSolver Extension installed, you'll need to download a copy of the Google Sheets LCR file.
Here's a link to the file: https://docs.google.com/spreadsheets/d/1bgTnNv8J6LHhJePcpiGdqf5bqEdzsRz7LG-d14nBtFk/edit?usp=copy
Here's a video showing you what to do. https://youtu.be/g7pe8XcveFE
You may need to enter the parameters into OpenSolver. Here's a video walking you through doing that: https://youtu.be/M5DCQ_EI8Xs
The parameters are shown in the picture below.