https://bugs.freedesktop.org/show_bug.cgi?id=72994
Priority: medium
Bug ID: 72994
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Make the same logic for Goal Seek and Solver tools
from end-user perspective
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: grof...@hotmail.com
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.4.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 91159
--> https://bugs.freedesktop.org/attachment.cgi?id=91159&action=edit
solver_vs_goal_seek.png
Using LibreOffice Calc 4.1.4.2 on Windows XP.
I am looking at how Goal Seek and Solver are operating from end-user
perspective and it looks like this two tools have separate logic, but from
end-user perspective Solver is "Goal Seek advance tool" or "Goal Seek on
steroids". I know there are two different tools, but I as end-user would expect
them to work according to the same logic. So using this two tools should be way
more simpler = similar.
I like the idea how Solver is working and I would suggest to do the same logic
for Goal Seek.
*** SOLVER ***
Very simple sample:
1. In cell A1 type in: 100
2. In cell A2 type in formula: =A1*10
3. Tools | Solver.
4.
a) Target cell: $A$2
b) Optimize result to Value of: 2000
c) By changing cells: $A$1
d) Options button. Solver engine: "LibreOffice Linear Solver" and OK button to
return to previous dialog.
e) Click on Solve button. Dialog "Solving Result" is opened. Values in sheet
has CHANGED! and dialog asking if "Keep Result" or "Restore Previous" buttons.
If "Keep Result" is clicked then the solving result is preserved (applied to
sheet) and if "Restore Previous" it restores values to values before using
Solver.
So logic behind Solver is to ACCEPT new values automatically.
*** GOAL SEEK ***
Very simple sample:
Repeat steps 1 and 2 from "Solver" section above.
3. Tools | Goal Seek.
4.
a) Formula cell: $A$2
b) Target value: 2000
c) Variable cell: $A$1
5. OK button.
6. New dialog with "Yes/No" question.
Sheet is not updated automatically.
See solver_vs_goal_seek.png attachment for details of current user interface
state.
SUGGESTIONS TO IMPROVE END-USER EXPERIENCE FOR GOAL SEEK DIALOGS:
I love the 'Solver' logic, so Solver is OK. All the changes go to Tools | Goal
Seek. Bellow are suggestions how to make Goal Seek as similar to Solver as
possible, to remove confusion in end-user eyes and to easily switch from one
tool to another.
1. In Goal Seek remove "Default Settings" label, because it is useless (Solver
does not have this kind of label).
2. Change "Formula cell" label to "Target cell" (the same label as Solver has).
3. Change "Target value" label to "Value of" (the same label as Solver has).
4. Change "Variable Cell" label to "By changing cell" (cell = singular, not
cells as in Solver - Solver has option to have multiple cells selection).
5. Change "OK" button label to "Seek" (the same logic as Solver has).
6. Add "Advance Options (Solver) plus button at the bottom. When clicked the
Goal Seek dialog closes and Solver dialog opens (if some values where entered
in Goal Seek dialog then it should preserve in Solver dialog). Because Goal
Seek in my end-user eyes is Solver's small brother, so changing to big brother
should be easy.
7. When clicking on Seek button and solution is provided, instead of current
Yes/No button create the same logic dialog as in Solver - the only change from
Solver is to add "'Seeking' successfully finished." instead of "'Solving'
successfully finished."
8. When "Seeking successfully finished" dialog opens then AUTOMATICALLY update
sheet with new values and make it possible for user to "Restore Previous"
state.
See Suggestions.png file for details.
Hope to see Goal Seek user interface logic little bit closer to Solver tool,
because Goal Seek is small brother of Solver tool.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
