+ Reply to Thread
Results 1 to 6 of 6

Free desktop Solver replacement for Excel 365 (Office 365 A1) - Analytic Solver Cloud?

  1. #1
    Registered User
    Join Date
    05-08-2020
    Location
    Lublin, Poland
    MS-Off Ver
    2003, 2007, 2010, 2019 (home); 2002, 2007, 2016, 365 (work)
    Posts
    69

    Free desktop Solver replacement for Excel 365 (Office 365 A1) - Analytic Solver Cloud?

    My problem is the following.

    This semester I will be teaching my students online. The university subscribed Office 365 A1 plan which is a preferred software platform not only for communications between teachers and students (Teams, Outlook) but also for computer laboratory classes which involve usage of MS office desktop apps. The problem is that Excel 365 online (accessed via web browsers) has no Solver which is necessary for me and some of my colleagues. The university's IT staff seem not to understand what I'm talking about installing any add-ins. So, I need to give them some link with a description what to do.
    Will the one below be OK?
    https://solver.zendesk.com/hc/en-us/...icrosoft-Store
    Or this one?
    https://appsource.microsoft.com/pl/p...4?tab=Overview

    By the way, is there any free cloud replacement for Analytic Toolpack which could be installed analogically as a cloud Solver?

    Thank you very much for help

    PK
    Przemyslaw Kowalik, Lublin Univ. of Technology

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Free desktop Solver replacement for Excel 365 (Office 365 A1) - Analytic Solver Cloud?

    You could test OpenSolver a freebie build by the University of Auckland NZ. I would recommend OpenSolver2.9.0AdwansedWin as this contains both a linear and a non linear model.
    These integrates nicely with Excel spread sheets.

    Link OpenSolver:
    https://opensolver.org/

    Frontline Solvers (makers of Excel solver) has an option where students can download a free sample of their most advanced solver model. Have a look and see if this is something for you. Link:
    https://www.solver.com/welcome-students

    Alf

  3. #3
    Registered User
    Join Date
    05-08-2020
    Location
    Lublin, Poland
    MS-Off Ver
    2003, 2007, 2010, 2019 (home); 2002, 2007, 2016, 365 (work)
    Posts
    69

    Re: Free desktop Solver replacement for Excel 365 (Office 365 A1) - Analytic Solver Cloud?

    OK, I know OpenSolver and academic options from Frontline Systems but it is not what I'm looking for. Both links point to solvers which are physically sets of files stored on the user's disk and accessed from locally installed copy of destop Excel. But this will not work for online Excel which is opened as a web service in the web browser like below (screenshot from Edge, document's URL visible, UI is in Polish)

    Excel-online-2.png

    I managed to download a cloud-based free version of Frontline Systems Solver and install in the desktop Excel 2019. It looks like this:

    CloudSolver1.png


    CloudSolver2.png
    What I need is to be able to access the same solver (or a similar one) from online Excel via a web browser. I cannot install this (or any other add-in) by myself because this functionality is blocked by the university admin.
    I need to know how it can be done in order to tell him. He seems to be reluctant to help if he needs to look for any info by himself.

    Any suggestions?

  4. #4
    Registered User
    Join Date
    05-08-2020
    Location
    Lublin, Poland
    MS-Off Ver
    2003, 2007, 2010, 2019 (home); 2002, 2007, 2016, 365 (work)
    Posts
    69

    Re: Free desktop Solver replacement for Excel 365 (Office 365 A1) - Analytic Solver Cloud?

    May I ask any admin to move this thread to the Office 365 section of the forum? I think that it would be more compliant with the subject of the thread but when I posted the post #1, this section wasn't available (at least not visible for me).

  5. #5
    Registered User
    Join Date
    09-14-2018
    Location
    China
    MS-Off Ver
    Office 2010
    Posts
    41

    Re: Free desktop Solver replacement for Excel 365 (Office 365 A1) - Analytic Solver Cloud?

    Have you tried OpenSolver for Google Sheets?
    This should be an online version. I didn't use it though.

    Jimmy

  6. #6
    Registered User
    Join Date
    05-08-2020
    Location
    Lublin, Poland
    MS-Off Ver
    2003, 2007, 2010, 2019 (home); 2002, 2007, 2016, 365 (work)
    Posts
    69

    Re: Free desktop Solver replacement for Excel 365 (Office 365 A1) - Analytic Solver Cloud?

    No, I haven't tried that combo (though I know about it).
    However, it seems that there have been some technical issues, probably still not solved
    https://opensolver.org/opensolver-fo...sers/#comments

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Staff scheduling with maximum free WE - to be calculated by Solver
    By athinaida in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-12-2020, 05:11 AM
  2. Excel solver - Trouble with linear programming using solver excel
    By spicyscreamer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2017, 08:01 AM
  3. Inclusion of Free Solver in Excel 2013
    By prschoef in forum Excel General
    Replies: 8
    Last Post: 07-06-2016, 02:55 PM
  4. [SOLVED] Excel Solver VBA - Solver Violating Constraints
    By lespaul00 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-19-2015, 04:00 PM
  5. [SOLVED] Excel Add Ins - Funcres.xla and solver.xla for office xp
    By hiren in forum Excel General
    Replies: 0
    Last Post: 02-05-2006, 11:35 AM
  6. [SOLVED] Excel Add Ins - Funcres.xla and solver.xla for office xp
    By hiren in forum Excel General
    Replies: 1
    Last Post: 02-05-2006, 09:30 AM
  7. Replies: 1
    Last Post: 04-06-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1