Solver with Google Drive

• Log into your Google Drive account (Chrome is the recommended browser) and click +New, Google Sheets.  You can also click +New, File upload, and Open with Google Sheets if you have a file already started.
  
• Enter or edit spreadsheet contents as if in Excel (instructions provided separately).
• Click Add-ons, Solver, Start.  The Solver parameters screen appears to the right.
• Select settings in Solver in a manner similar to Excel 2010 or 2013 (which is essentially identical to the Excel in Office 365) except that the Solving Method should be "Standard LP/Quadratic" and you must click Options to access the Assume Non-negative checkbox.
• Note:  it seems to work better to click the cell(s) on thespreadsheet, then click in the box where you want those cells used (Excel normally works the other way).
• As in Excel, look for the notice "Solver found a solution..."  Anything else means that there is a problem, and any solution you may see is incorrect.
• There are no options for reports as in Excel.  If an assignment requires a report, type in the date and time that you solved the problem in a clearly visible space on your spreadsheet.
• IMPORTANT:  for MGT 371 homework in Dr. Fisher's online class, click Share in the upper right and add wfisher@sfasu.edu with the "Can edit" option.  Also include your name and the assignment in the comment space available for that purpose.  That is the only way that the professor can tell whether you did the assignment correctly.  Check with your professor if using Google Drive Solver in other classes.
  

• When a spreadsheet is shared or re-opened, Solver is not automatically re-opened with it.  However, settings are preserved when Solver is re-opened. 
  
• Solver settings are NOT preserved if the file is downloaded as an Excel file.