Comments on: Resources

By: Andrew Mason (Team OpenSolver)

Andrew Mason (Team OpenSolver) — Sun, 09 Oct 2022 21:26:06 +0000

In reply to Everett.

Google has refined and change its permissions over time. We don’t currently have anyone who can make changes to the permissions in our code, but would be keen to see this change made. Perhaps your organisation or someone else can help improve OpenSolver for Google Sheets in this way? Andrew

By: Everett

Everett — Thu, 06 Oct 2022 23:10:17 +0000

Hello,
I am trying to get permission from my organization to add the Google Sheets plugin but the feedback I received as that the https://www.googleapis.com/auth/spreadsheets is too excessive since the script will only be executed within the context of the required spreadsheet. Is it possible to replace it with the https://www.googleapis.com/auth/drive.file scope that limits access to the specific Google Drive file used with this app?

By: Andrew Mason (Team OpenSolver)

Andrew Mason (Team OpenSolver) — Thu, 25 Jul 2019 10:00:37 +0000

In reply to Mara.

No, as > makes no sense for non-integer values like 1.0 > 0.99999999999999999999999999999999999999999999999999. Andrew

By: Mara

Mara — Thu, 25 Jul 2019 08:30:54 +0000

Hi everyone!

Is it possible to set a constraint > than something else? It seems like I can only select >= in the ‘Model’ Window.

By: Andrew Mason (Team OpenSolver)

Andrew Mason (Team OpenSolver) — Wed, 10 Oct 2018 02:30:12 +0000

In reply to Angel.

Yes you can use integer programming for staff scheduling. Andrew

By: Angel

Angel — Wed, 10 Oct 2018 02:10:52 +0000

Hi,
Is it possible to create schedules by interval considering requirements?

I work for a small call center and I’m looking for something that help me to optimize my current Staffing.
Thanks

By: Andresa Silvia Gomes

Andresa Silvia Gomes — Mon, 09 Oct 2017 18:13:38 +0000

Hi there,

Do you have spreadsheet sample for Single Depot Vehicle Scheduling Problem?

If yes, can you please share it with me?

By: Dan

Dan — Tue, 26 Sep 2017 15:24:12 +0000

In reply to Mike.

Mike – Google Goal Programming. It’s a way to take a few different priorities into account.

By: Andrew Mason (Team OpenSolver)

Andrew Mason (Team OpenSolver) — Wed, 03 Aug 2016 22:33:46 +0000

In reply to Mike.

You can only solve one problem at a time, and hence you can only specify a single cell as the objective.

By: Mike

Mike — Sun, 31 Jul 2016 02:27:48 +0000

Hi, is it possible to solve multiple problems with this tool?

I have successfully made a break-even calculator in Google Sheets that solves a simple variable cost (based on selling price)/fixed cost formula, but I would like to use it for multiple items –

http://tinypic.com/r/102qzhi/9

But alas, when trying to implement over a range – “The objective cell must be a single cell. Please fix this and try again.”

many thanks,
Mike