/docs/community?hl=en

Solver Add-on fails for simple 2-cell problem in one Sheet but not another.

0

I am testing the Google Sheets Add-on "Solver". I find that it fails on a very simple 2-cell problem in a spreadsheet with a few other cells, but it works just fine in another spreadsheet that looks the same.

(I'm trying to do a harder Solver problem to optimize the design of fusion energy power plants based on simple scaling formulas, but it wouldn't work (though it does work in Excel). I then narrowed it down to this example.)

Cell B5 is initialized to 4.0
Cell B6 is set to

= (B5-2)^2

The solver/optimizer is set to minimize B6 by varying B5, and should give the answer that the optimal B5 is 2.0.

Instead, it gives the error message:

"Problem could not be loaded.

No variable cells defined."

I put a simple working example (5 rows long) in a google sheet "Test_Solver_fails" in the publicly-viewable folder:
https://drive.google.com/open?id=1wS9uG7fpYWJdNY8coNJapJCUnJQHe-_1
The sheet "Test_Solver_works" works just fine. The two sheets look identical to me (except for minor column width variations).

The sheet "Test_Solver_fails_public_editable" also reproduces the error and can be edited by anyone.  Please try to leave it in a state that reproduces the error, unless you figure out a way to fix it.

To verify the error really occurred (I've had problems with intermittent problems in google sheets), I put a screen shot showing the error message in
"Test_Solver_fails_screen_shot.png".

Any generous people have any ideas about what is going on or how to fix this?

Also, the side-panel interface to the Solver seems a bit flaky. It would be nice if there was a way to save and load different Solver scenarios like there are in the Excel version. Or is there a way to call the solver from a Google Javascript function, or from a function call from an Excel cell, and specify the scenario (objective cell, variable cells, constraint formulas) as arguments to the function?

Latest Update Latest Updates (0)

Relevant Answer Relevant Answers (0)

Our automated system analyzes the replies to choose the one that's most likely to answer the question.

This question is locked and replying has been disabled.

Discard post? You will lose what you have written so far.

Failed to attach file, click here to try again.

Edit link

Notifications are currently off and you won't receive updates. To turn them on, go toNotifications preferences on your Profile  page.

Discard post?

You will lose what you have written so far.

Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.

Create Reply

Edit Reply

This will remove the reply from the Answers section.

Notifications are off

Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.

Google user

This reply is no longer available.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

Google Employee — Google product team members and community managers

Community Specialist — Google partners who help ensure the quality of community content

Diamond Product Expert — Community members with product mastery who help other Google users and Product Experts

Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts

Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions

Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions

Product Expert Alumni — Former Product Experts who are no longer members of the program

Community content may not be verified or up-to-date.

/docs/threads

//accounts.google.com/ServiceLogin

You'll receive email notifications for new posts at

Unable to delete question.

Unable to update vote.

Unable to update subscription.

You have been unsubscribed

Deleted

Unable to delete reply.

Removed from Answers

Removed from Updates

Marked as Recommended Answer

Marked as Update

Removed recommendation

Undo

Unable to update reply.

Unable to update vote.

Thank you. Your response was recorded.

Unable to undo vote.

Thank you. This reply will now display in the answers section.

Link copied

Locked

Unlocked

Unable to lock

Unable to unlock

Pinned

Unpinned

Unable to pin

Unable to unpin

Marked

Unmarked

Unable to mark

Reported as off topic

Known Issue

Fixed

Marked Fixed

Unmarked Fixed

Unable to mark fixed

Unable to unmark fixed

/profile/0

false