Solver Mac Download
2021年1月24日Download here: http://gg.gg/nzqll
Before Microsoft began bundling the Solver with Excel for Mac, Frontline Systems worked with Microsoft’s Mac Business Unit to bring you a faster, easier to use, and more powerful Solver. The version that we provided was free and 100% compatible - your existing Solver models would work without any changes, whether they’re from Excel 2004. A modelling tool that we think improves on the built-in Solver window; OpenSolver has been developed for Excel 2007/2010/2013/2016 (including the 64bit versions) running on Windows, and supports Excel for Mac 2011 on Mac OS X, with limited support for Excel for Mac 2016. Sudoku Solver’s innovative design allows players of all skill levels to tackle Sudoku puzzles in new and exciting ways. It coaches new players on basic solution techniques, and challenges advanced. Version 2.5 for Mac and Windows. Download: - Solve Elec 2.5 for MacOS X (Universal Binary) 10,5 Mo - Solve Elec 2.5 for Windows 3,2 Mo - Circuits examples.
*Download Solver Add In Excel
*Solve Elec Mac Download
*Solver.xlam Download Mac Excel 2011
*Download Solver Table
*Microsoft Math Solver Download
*Solver Excel 2011 Mac DownloadDownload Solver Add In Excel
SolverStudio runs as an Excel add-in file for Excel 2007-2013. (The tools we use mean that Excel 2003 is not supported.) The download includes all the required components, including IronPython, PuLP, standard Python (CPython), the GNU Linear Programming Kit (GLPK), and AMPL and GAMs support files. SolverStudio has been beta tested under Windows Vista, Windows 7 and Windows 10 using Excel 2007, 2010, 2013, 2016 & 2019. Note that Excel 2013 requires releases 0.06.00.00 and later to work correctly.
Like many add-ins, SolverStudio will not work with some versions of Office 365 installed from the Windows Store; see this OpenSolver page for more info.
If you download this software, please leave a comment describing your experience in installing and running it. We’d love to know if it worked properly on your computer, or if there are bugs we need to fix.
To install SolverStudio:
A/ Install as an end user, not as an Administrator The standard Microsoft installer used by SolverStudio and other Excel add-ins installs for the current user only (i.e. into the current “profile”); it will not make SolverStudio available for other users and typically does not need Administrator privileges. Hence, SolverStudio should always be installed while logged on using your normal account. (See below for a more complicated all-users installation process most users will not need.) Depending on your machine, running SolverStudio’s “setup.exe” may try to install the .NET 4 and the Office support files if you do not already have these files already installed; this will probably require Administrator priviliges. You should not need administrator privileges to install SolverStudio itself if you already have these required system files. If you need to logon (or “Run As”) as an Administrator to complete the installation, be sure to run setup.exe again using your standard non-admin logon after completing the Administrator install.
B/ Uninstall Any Earlier Version To be safe, uninstall any earlier version of SolverStudio using the Control Panel’s Add/Remove programs, the Uninstall button under SolverStudio’s About menu, or the SolverStudio/SolverStudio/Uninstaller.exe file. (The latter two uninstall options now handle more cases than the Control Panel, including advanced all-user installations.)
C/ Download SolverStudio Zip File.
We recommend you download our latest release (announced on 20150813, and updated on 20150903 to include new MOSEK examples and again on 20151117 to fix an IronPython bug and again on 20160408 to fix issues with the latest Julia/JuMP release and again on 20160520 with CMPL, NEOS & GMPL improvements).
SolverStudio_00_09_03_00 20160520.zip (57209 downloads) 23 MB
If you hit download problems, an earlier version is available to be downloaded in smaller parts.
An older version, SolverStudio 0.5.4 (2013.06.25) is also available from our downloads archive, and does not require the full .Net 4 needed by later versions (as detailed below).
D/ Unblock Zip File. Right click on the downloaded.zip file, choose Properties, and click the Unblock button if there is one; see the image below. (You cannot install from files that have been ‘blocked‘ by Windows; see also here.)
E/ Extract Files. Extract the SolverStudio files from the .zip file to a convenient location; the files in this location are used whenever SolverStudio runs. (You can normally run SolverStudio from any location. In our labs running 64 bit Windows 7 with 32 bit Office 2010, we simply make SolverStudio available on a network drive. However, if you are installing for all users (see below), or you are an administrator setting up the machine for other less-privileged users to install themselves later, then copying the files into either Program Files if you are using 64 bit Office or a 32 bit Windows, or into Program Files (x86) if you are using 32 bit Office on a 64 bit Windows, may be safest as these are fully trusted locations.)
F/ Quit all copies of Excel.
G/ Run Setup.exe. Double click on the Setup.exe file, giving permission to install when requested. (If this fails, try clicking directly on SolverStudio.vsto, which will skip some of the installation steps, but may still work. Also see “Installation Errors” below.) Do not run as Administrator, but while logged in as the final end user, as installation is only for the current user. (If needed, see All-User installation notes below.)
Running Setup.exe will install any support files you need, as follows.
From version 0.6.0 onwards, SolverStudio uses the full .Net Framework 4.0. (Earlier versions used the “.Net Framework v4 Client Profile”, which is already installed on most machines.) SolverStudio also uses “Microsoft Visual Studio 2010 Tools (VSTO) for Office Runtime” which supports Office 2010 and later versions. (This VSTO link should always point at the latest version of this “VSTO 2010” file.) Running Setup.exe should install these automatically (but see below for possible errors).Solve Elec Mac Download
H/ Launch Excel. The SolverStudio commands should then appear under Excel’s Data tab.
I/ Sept 2018 Excel Update: Turn on “Optimize for Compatibility” The Sept 2018 update to Excel made changes that broke a number of Excel add-ins. These changes may give you a greyed-out SolverStudio editor window, or an editor window showing at a strange location. A workaround is documented at https://www.add-in-express.com/creating-addins-blog/2018/09/24/panes-problems-solved/ :
“A workaround is to choose the Optimize for compatibility option in Display Settings; see the status bar or File | Options | General. Select this option, restart the Office application and it will use the old Windows API.”
Thanks to Eldemar for confirming this works.
Disabled Add-in Problems: If SolverStudio does not show up in Excel, it may be “disabled” by Excel. This can happen if SolverStudio crashes, or something else goes wrong. Use Excel’s File… Options… Add-Ins…. Manage, and check to see if SolverStudio is in the “Disabled Application Add-ins” list. If it is, use COM Addins to enable SolverStudio.
Installation Error “The value of the property ‘type’ cannot be parsed”: Install VSTO Separately and/or use Run as Administrator
If you are behind a firewall or proxy server, or get an error such as “The value of the property ‘type’ cannot be parsed” the following comments from Ted Ralphs might be helpful. Installing SolverStudio from behind a proxy servers can be a bit problematic. We spent a lot of time trying to figure out how to do it and it turned out the problem was that the installer tries to fetch another installer (for Visual Studio 2010 Tools for Office (VSTO) Runtime) from the Microsoft Web site that is a pre-requisite. This can sometimes fail without giving any helpful error message. To get around it, we finally figured out that you can just follow these install instructions to download this “Visual Studio 2010 Tools for Office (VSTO) Runtime” installer and install those tools separately.
This error can sometimes also be fixed by installing as Administrator. That is, right-click “setup.exe” and choose “Run as Admininstrator”.
There is a good description of a variant of this error at the DataEverywhere VSTO Add-in help pages.
Installation Error “A runtime error occurred during the loading of the COM add-in“: Use Run As Administrator
If the above process for installing Visual Studio Tools for Office Runtime does not work, please try running as Adminstrator during the installation. That is, right-click “setup.exe” and choose “Run as Admininstrator”. We have had Excel report (under COM add-ins) that “A runtime error occurred during the loading of the COM Add-in.”; installing as Administrator fixed this.
Installation Error “InvalidDeploymentException: Exception reading manifest“: Install .Net 4.5 or use SolverStudio 0.08.02 or later
SolverStudio 0.08.01 and later versions are signed with a stronger certificate that can cause problems with older versions of .Net. We have upgraded our Visual Studio compiler to (hopefully) fix this in SolverStudio 0.08.02 and later. In SolverStudio 0.08.01, this new certificate can trigger a Microsoft bug in which SolverStudio cannot install unless you have .Net 4.5 installed. The error text starts “ISystem.Deployment.Application.InvalidDeploymentException: Exception reading manifest” and includes “System.Security.Cryptography.CryptographicException: SignatureDescription could not be created for the signature algorithm supplied.” See here and here for more details of this bug. You may wish to check which .Net version you have. If you encounter this error, please upgrade to .Net 4.5 or later, or use a later SolverStudio version.
Installation Error “The following Microsoft Office solution cannot be installed due to a general error“: Try installing parts separately
We have recently (Dec 2016) had reports (report 1, report 2) of “general errors”, eg “The following Microsoft Office solution cannot be installed due to a general error: SolverStudio.vsto. 0x80070002” (or error code 0x8007007E). We suggest you manually instal the full .Net Framework 4.0. and the “Microsoft Visual Studio 2010 Tools (VSTO) for Office Runtime”; you will almost certainly need to be logged in under an Administrator account.
All-user Installation: By default, SolverStudio is installed for the current user only (like all VSTO Office add-ins). Instructions are given under “SolverStudioSolverStudioAdvancedInstallers” on how to install SolverStudio for all users on a machine. (Many thanks to Daniel Frances from the University of Toronto for testing this in his labs.) It is important to copy the SolverStudio files into either Program Files or, if you are running a 32 bit Office on a 64 Windows, into Program Files (x86); putting them into the wrong program files folder will cause SolverStudio to fail.
Example Models: The download includes sample workbooks that show many of the features.
Uninstalling: SolverStudio can be removed by using the Windows Add/Remove Programs (or the equivalent under Vista/Windows 8), or using SolverStudio’s About… Uninstall button. Version 0.6.0 also includes an “Uninstaller.exe” file you can run. To uninstall an All-Users installation, we suggest using “Uninstaller.exe” and which typically needs to be “Run as administrator”. Advanced users may wish to explore the “AdvancedInstallers” for other uninstall options. After uninstalling, you can then delete the files you downloaded.
Upgrading SolverStudio When upgrading from a previous version, please uninstall SolverStudio first, and then install the new version.
We have come across an example where upgrading failed because of a glitch in Microsoft’s VSTO system used by SolverStudio. (Thanks, Ted, for helping us track this down.) When you install SolverStudio, it copies the files (including SolverStudio.dll) into a cache. Sometimes, the files in this cache are left open, and so the VSTO installer used by SolverStudio fails to update the files (without warning you). You then end up running an old copy of SolverStudio.dll, which typically gives errors when solving models etc. To fix this, please (1) restart Windows to close the SolverStudio.dll, (2) uninstall SolverStudio using the Control Panel or SolverStudio’s About… Uninstall button, (3) install SolverStudio again. Note that the location of the cached files is given in SolverStudio’s About box, so you can also try manually deleting this cached DLL (and the other files in the cached folder) to force Windows to update these when you next launch SolverStudio. On my machine the DLL location given in the SolverStudio’s About box is:
System.Reflection.Assembly.GetExecutingAssembly().Location:
C:Usersamas008AppDataLocalassemblydl3C5BH1QGV.QTQ4P3CWJ02.81Wc28f32d6689ff424_4f72ce01SolverStudio.DLL
Internet Access: We have been asked about SolverStudio’s internet access requirements.
AMPL on NEOS makes the following IP connection:
NEOS_HOST=”www.neos-server.org”
NEOS_PORT=3332
The AMPL student version installer menu accesses the AMPL site to do a download from http://www.ampl.com/NEW/TABLES/amplcml.zip; this is just a standard connection using Python’s urllib.urlretrieve().
The VSTO framework under which SolverStudio runs may do a check on the code signing certificate; I’m not sure what port this uses, but it has always worked fine in our testing. SolverStudio does not make any other internet connections apart from opening web pages.
SolverStudio has no affiliation with, nor is recommend by, Microsoft, AMPL, GAMS, GNU, or Frontline Systems. All trademark terms are the property of their respective owners.
Free Downloads
Watch this page for free downloads as they become available.
·DADM_Tools add-in: For various reasons, some users of our DADM and PMS books prefer not to use the Palisade add-ins discussed in these books. To provide another alternative, I created my own add-in called DADM_Tools that provides much of the basic functionality of the Palisade software. This add-in, written in Excel’s VBA language, is not used in the books but it is available here for free. Because it is totally free, no support is available. However, it is very easy to use, and it is compatible with Excel for Windows and Excel for Mac. Here is a link to instructions: DADM_Tools Help.docx. Here is a link to the add-in: DADM_Tools.xlam.
·Random Functions Add-Ins: The DADM_Tools add-in mentioned in the previous bullet includes, among other things, a simulation program. For technical reasons, the custom functions I developed to generate random numbers from various probability distributions are not included in the DADM_Tools add-in.
oFor Windows users, the random functions are contained in a special type of add-in (an XLL that works only with Excel for Windows 2010 or higher). First read the following: RandGen Add-In.docx (updated 1/24/2019). Then install the add-in by running the Setup file in: RandGenSetup.zip.
oFor Mac users, the random functions are in the following add-in: Random Functions for the Mac.xlam.
·Excel tutorial: Here is the free version of my Excel tutorial: Excel Tutorial for Windows.xlsx. (It provides information for upgrading to a more complete version called ExcelNow!.) You can also download a version of the tutorial for the Mac: Excel Tutorial for the Mac.xlsx. By comparing these, you can see which features in Excel for Windows are not included in Excel for the Mac.
·Analysis ToolPak Guide: This is a supplement to our books for those of you who would like to use Excel’s built-in Analysis ToolPak add-in, rather than StatTools, for statistical analysis. The zip file contains a pdf version of the guide and accompanying data files: Analysis ToolPak Guide.zip
·SolverTable Add-in: Each version below has a corresponding Help file (a Word file) that you should read before contacting me about problems. Each zip file below contains only two files: the .xla or .xlam add-in file and the Word help file. You should unzip both to the same folder (any folder of your choice) and then read the help file for more instructions. The next two bullets address some possible problems users have had.
oFor Solver that ships with Excel for Mac: SolverTable for Mac.zip Bitdefender adware removal mac.
¨(Note: If you downloaded this zip before 10/30/2020, download this version instead. The previous version didn’t recognize when a model has no feasible solutions. This version corrects the problem.) This version of SolverTable was created for the Mac in October 2020. The essence of SolverTable has always been that it makes multiple uninterrupted Solver runs. For technical reasons, this is not possible in Excel for Mac, which explains why a version of SolverTable had never been available for the Mac. However, this new version gets around the problem by making interrupted Solver runs. Before each run, you are prompted whether you want to make the next run. (This is explained more fully in the help file that is part of this zip file.) Admittedly, the interruptions slow down the process to some extent (besides the fact that Solver for the Mac is just plain slow), but it is much better than making multiple Solver runs manually, each with new input values. The good news is that the user interface and the results sheets are exactly the same as those for the Windows version of SolverTable.
oFor Solver that ships with Excel 2019 or Office 365: There is no “new” SolverTable add-in for either of these. As far as I’m aware, SolverTable for Excel 2016 should work fine with either of these. I’m currently using it with Office 365 and haven’t run into any problems.
oFor Solver that ships with Excel 2016: SolverTable 2016.zipSolver.xlam Download Mac Excel 2011
¨This version is basically the same as the 2013 version.
oFor Solver that ships with Excel 2013: SolverTable 2013.zip
¨This version wasn’t created because SolverTable 2010 wouldn’t work with Excel 2013. Rather, I made some technical changes in the software. Probably the main change is that this version now starts each Solver run from the original solution in the decision variable cells. (In previous versions, it started each Solver run from the previous Solver solution.)
¨Modified on 10/5/2015 to open the Help file in a simpler manner (less possibility of an error occurring).
oFor Solver that ships with Excel 2010:SolverTable 2010.zip
¨Modified on 10/5/2015 to open the Help file in a simpler manner (less possibility of an error occurring).
¨Modified on 4/26/2012 to fix a problem with long worksheet names. Basically, Excel allows worksheet names to be no longer than 31 characters. SolverTable creates a hidden sheet with its settings, and the name of the sheet is the model sheet name plus the suffix “_STS”. So if the name of your model sheet has from 28 to 31 characters, this would create an error. So
https://diarynote-jp.indered.space
Before Microsoft began bundling the Solver with Excel for Mac, Frontline Systems worked with Microsoft’s Mac Business Unit to bring you a faster, easier to use, and more powerful Solver. The version that we provided was free and 100% compatible - your existing Solver models would work without any changes, whether they’re from Excel 2004. A modelling tool that we think improves on the built-in Solver window; OpenSolver has been developed for Excel 2007/2010/2013/2016 (including the 64bit versions) running on Windows, and supports Excel for Mac 2011 on Mac OS X, with limited support for Excel for Mac 2016. Sudoku Solver’s innovative design allows players of all skill levels to tackle Sudoku puzzles in new and exciting ways. It coaches new players on basic solution techniques, and challenges advanced. Version 2.5 for Mac and Windows. Download: - Solve Elec 2.5 for MacOS X (Universal Binary) 10,5 Mo - Solve Elec 2.5 for Windows 3,2 Mo - Circuits examples.
*Download Solver Add In Excel
*Solve Elec Mac Download
*Solver.xlam Download Mac Excel 2011
*Download Solver Table
*Microsoft Math Solver Download
*Solver Excel 2011 Mac DownloadDownload Solver Add In Excel
SolverStudio runs as an Excel add-in file for Excel 2007-2013. (The tools we use mean that Excel 2003 is not supported.) The download includes all the required components, including IronPython, PuLP, standard Python (CPython), the GNU Linear Programming Kit (GLPK), and AMPL and GAMs support files. SolverStudio has been beta tested under Windows Vista, Windows 7 and Windows 10 using Excel 2007, 2010, 2013, 2016 & 2019. Note that Excel 2013 requires releases 0.06.00.00 and later to work correctly.
Like many add-ins, SolverStudio will not work with some versions of Office 365 installed from the Windows Store; see this OpenSolver page for more info.
If you download this software, please leave a comment describing your experience in installing and running it. We’d love to know if it worked properly on your computer, or if there are bugs we need to fix.
To install SolverStudio:
A/ Install as an end user, not as an Administrator The standard Microsoft installer used by SolverStudio and other Excel add-ins installs for the current user only (i.e. into the current “profile”); it will not make SolverStudio available for other users and typically does not need Administrator privileges. Hence, SolverStudio should always be installed while logged on using your normal account. (See below for a more complicated all-users installation process most users will not need.) Depending on your machine, running SolverStudio’s “setup.exe” may try to install the .NET 4 and the Office support files if you do not already have these files already installed; this will probably require Administrator priviliges. You should not need administrator privileges to install SolverStudio itself if you already have these required system files. If you need to logon (or “Run As”) as an Administrator to complete the installation, be sure to run setup.exe again using your standard non-admin logon after completing the Administrator install.
B/ Uninstall Any Earlier Version To be safe, uninstall any earlier version of SolverStudio using the Control Panel’s Add/Remove programs, the Uninstall button under SolverStudio’s About menu, or the SolverStudio/SolverStudio/Uninstaller.exe file. (The latter two uninstall options now handle more cases than the Control Panel, including advanced all-user installations.)
C/ Download SolverStudio Zip File.
We recommend you download our latest release (announced on 20150813, and updated on 20150903 to include new MOSEK examples and again on 20151117 to fix an IronPython bug and again on 20160408 to fix issues with the latest Julia/JuMP release and again on 20160520 with CMPL, NEOS & GMPL improvements).
SolverStudio_00_09_03_00 20160520.zip (57209 downloads) 23 MB
If you hit download problems, an earlier version is available to be downloaded in smaller parts.
An older version, SolverStudio 0.5.4 (2013.06.25) is also available from our downloads archive, and does not require the full .Net 4 needed by later versions (as detailed below).
D/ Unblock Zip File. Right click on the downloaded.zip file, choose Properties, and click the Unblock button if there is one; see the image below. (You cannot install from files that have been ‘blocked‘ by Windows; see also here.)
E/ Extract Files. Extract the SolverStudio files from the .zip file to a convenient location; the files in this location are used whenever SolverStudio runs. (You can normally run SolverStudio from any location. In our labs running 64 bit Windows 7 with 32 bit Office 2010, we simply make SolverStudio available on a network drive. However, if you are installing for all users (see below), or you are an administrator setting up the machine for other less-privileged users to install themselves later, then copying the files into either Program Files if you are using 64 bit Office or a 32 bit Windows, or into Program Files (x86) if you are using 32 bit Office on a 64 bit Windows, may be safest as these are fully trusted locations.)
F/ Quit all copies of Excel.
G/ Run Setup.exe. Double click on the Setup.exe file, giving permission to install when requested. (If this fails, try clicking directly on SolverStudio.vsto, which will skip some of the installation steps, but may still work. Also see “Installation Errors” below.) Do not run as Administrator, but while logged in as the final end user, as installation is only for the current user. (If needed, see All-User installation notes below.)
Running Setup.exe will install any support files you need, as follows.
From version 0.6.0 onwards, SolverStudio uses the full .Net Framework 4.0. (Earlier versions used the “.Net Framework v4 Client Profile”, which is already installed on most machines.) SolverStudio also uses “Microsoft Visual Studio 2010 Tools (VSTO) for Office Runtime” which supports Office 2010 and later versions. (This VSTO link should always point at the latest version of this “VSTO 2010” file.) Running Setup.exe should install these automatically (but see below for possible errors).Solve Elec Mac Download
H/ Launch Excel. The SolverStudio commands should then appear under Excel’s Data tab.
I/ Sept 2018 Excel Update: Turn on “Optimize for Compatibility” The Sept 2018 update to Excel made changes that broke a number of Excel add-ins. These changes may give you a greyed-out SolverStudio editor window, or an editor window showing at a strange location. A workaround is documented at https://www.add-in-express.com/creating-addins-blog/2018/09/24/panes-problems-solved/ :
“A workaround is to choose the Optimize for compatibility option in Display Settings; see the status bar or File | Options | General. Select this option, restart the Office application and it will use the old Windows API.”
Thanks to Eldemar for confirming this works.
Disabled Add-in Problems: If SolverStudio does not show up in Excel, it may be “disabled” by Excel. This can happen if SolverStudio crashes, or something else goes wrong. Use Excel’s File… Options… Add-Ins…. Manage, and check to see if SolverStudio is in the “Disabled Application Add-ins” list. If it is, use COM Addins to enable SolverStudio.
Installation Error “The value of the property ‘type’ cannot be parsed”: Install VSTO Separately and/or use Run as Administrator
If you are behind a firewall or proxy server, or get an error such as “The value of the property ‘type’ cannot be parsed” the following comments from Ted Ralphs might be helpful. Installing SolverStudio from behind a proxy servers can be a bit problematic. We spent a lot of time trying to figure out how to do it and it turned out the problem was that the installer tries to fetch another installer (for Visual Studio 2010 Tools for Office (VSTO) Runtime) from the Microsoft Web site that is a pre-requisite. This can sometimes fail without giving any helpful error message. To get around it, we finally figured out that you can just follow these install instructions to download this “Visual Studio 2010 Tools for Office (VSTO) Runtime” installer and install those tools separately.
This error can sometimes also be fixed by installing as Administrator. That is, right-click “setup.exe” and choose “Run as Admininstrator”.
There is a good description of a variant of this error at the DataEverywhere VSTO Add-in help pages.
Installation Error “A runtime error occurred during the loading of the COM add-in“: Use Run As Administrator
If the above process for installing Visual Studio Tools for Office Runtime does not work, please try running as Adminstrator during the installation. That is, right-click “setup.exe” and choose “Run as Admininstrator”. We have had Excel report (under COM add-ins) that “A runtime error occurred during the loading of the COM Add-in.”; installing as Administrator fixed this.
Installation Error “InvalidDeploymentException: Exception reading manifest“: Install .Net 4.5 or use SolverStudio 0.08.02 or later
SolverStudio 0.08.01 and later versions are signed with a stronger certificate that can cause problems with older versions of .Net. We have upgraded our Visual Studio compiler to (hopefully) fix this in SolverStudio 0.08.02 and later. In SolverStudio 0.08.01, this new certificate can trigger a Microsoft bug in which SolverStudio cannot install unless you have .Net 4.5 installed. The error text starts “ISystem.Deployment.Application.InvalidDeploymentException: Exception reading manifest” and includes “System.Security.Cryptography.CryptographicException: SignatureDescription could not be created for the signature algorithm supplied.” See here and here for more details of this bug. You may wish to check which .Net version you have. If you encounter this error, please upgrade to .Net 4.5 or later, or use a later SolverStudio version.
Installation Error “The following Microsoft Office solution cannot be installed due to a general error“: Try installing parts separately
We have recently (Dec 2016) had reports (report 1, report 2) of “general errors”, eg “The following Microsoft Office solution cannot be installed due to a general error: SolverStudio.vsto. 0x80070002” (or error code 0x8007007E). We suggest you manually instal the full .Net Framework 4.0. and the “Microsoft Visual Studio 2010 Tools (VSTO) for Office Runtime”; you will almost certainly need to be logged in under an Administrator account.
All-user Installation: By default, SolverStudio is installed for the current user only (like all VSTO Office add-ins). Instructions are given under “SolverStudioSolverStudioAdvancedInstallers” on how to install SolverStudio for all users on a machine. (Many thanks to Daniel Frances from the University of Toronto for testing this in his labs.) It is important to copy the SolverStudio files into either Program Files or, if you are running a 32 bit Office on a 64 Windows, into Program Files (x86); putting them into the wrong program files folder will cause SolverStudio to fail.
Example Models: The download includes sample workbooks that show many of the features.
Uninstalling: SolverStudio can be removed by using the Windows Add/Remove Programs (or the equivalent under Vista/Windows 8), or using SolverStudio’s About… Uninstall button. Version 0.6.0 also includes an “Uninstaller.exe” file you can run. To uninstall an All-Users installation, we suggest using “Uninstaller.exe” and which typically needs to be “Run as administrator”. Advanced users may wish to explore the “AdvancedInstallers” for other uninstall options. After uninstalling, you can then delete the files you downloaded.
Upgrading SolverStudio When upgrading from a previous version, please uninstall SolverStudio first, and then install the new version.
We have come across an example where upgrading failed because of a glitch in Microsoft’s VSTO system used by SolverStudio. (Thanks, Ted, for helping us track this down.) When you install SolverStudio, it copies the files (including SolverStudio.dll) into a cache. Sometimes, the files in this cache are left open, and so the VSTO installer used by SolverStudio fails to update the files (without warning you). You then end up running an old copy of SolverStudio.dll, which typically gives errors when solving models etc. To fix this, please (1) restart Windows to close the SolverStudio.dll, (2) uninstall SolverStudio using the Control Panel or SolverStudio’s About… Uninstall button, (3) install SolverStudio again. Note that the location of the cached files is given in SolverStudio’s About box, so you can also try manually deleting this cached DLL (and the other files in the cached folder) to force Windows to update these when you next launch SolverStudio. On my machine the DLL location given in the SolverStudio’s About box is:
System.Reflection.Assembly.GetExecutingAssembly().Location:
C:Usersamas008AppDataLocalassemblydl3C5BH1QGV.QTQ4P3CWJ02.81Wc28f32d6689ff424_4f72ce01SolverStudio.DLL
Internet Access: We have been asked about SolverStudio’s internet access requirements.
AMPL on NEOS makes the following IP connection:
NEOS_HOST=”www.neos-server.org”
NEOS_PORT=3332
The AMPL student version installer menu accesses the AMPL site to do a download from http://www.ampl.com/NEW/TABLES/amplcml.zip; this is just a standard connection using Python’s urllib.urlretrieve().
The VSTO framework under which SolverStudio runs may do a check on the code signing certificate; I’m not sure what port this uses, but it has always worked fine in our testing. SolverStudio does not make any other internet connections apart from opening web pages.
SolverStudio has no affiliation with, nor is recommend by, Microsoft, AMPL, GAMS, GNU, or Frontline Systems. All trademark terms are the property of their respective owners.
Free Downloads
Watch this page for free downloads as they become available.
·DADM_Tools add-in: For various reasons, some users of our DADM and PMS books prefer not to use the Palisade add-ins discussed in these books. To provide another alternative, I created my own add-in called DADM_Tools that provides much of the basic functionality of the Palisade software. This add-in, written in Excel’s VBA language, is not used in the books but it is available here for free. Because it is totally free, no support is available. However, it is very easy to use, and it is compatible with Excel for Windows and Excel for Mac. Here is a link to instructions: DADM_Tools Help.docx. Here is a link to the add-in: DADM_Tools.xlam.
·Random Functions Add-Ins: The DADM_Tools add-in mentioned in the previous bullet includes, among other things, a simulation program. For technical reasons, the custom functions I developed to generate random numbers from various probability distributions are not included in the DADM_Tools add-in.
oFor Windows users, the random functions are contained in a special type of add-in (an XLL that works only with Excel for Windows 2010 or higher). First read the following: RandGen Add-In.docx (updated 1/24/2019). Then install the add-in by running the Setup file in: RandGenSetup.zip.
oFor Mac users, the random functions are in the following add-in: Random Functions for the Mac.xlam.
·Excel tutorial: Here is the free version of my Excel tutorial: Excel Tutorial for Windows.xlsx. (It provides information for upgrading to a more complete version called ExcelNow!.) You can also download a version of the tutorial for the Mac: Excel Tutorial for the Mac.xlsx. By comparing these, you can see which features in Excel for Windows are not included in Excel for the Mac.
·Analysis ToolPak Guide: This is a supplement to our books for those of you who would like to use Excel’s built-in Analysis ToolPak add-in, rather than StatTools, for statistical analysis. The zip file contains a pdf version of the guide and accompanying data files: Analysis ToolPak Guide.zip
·SolverTable Add-in: Each version below has a corresponding Help file (a Word file) that you should read before contacting me about problems. Each zip file below contains only two files: the .xla or .xlam add-in file and the Word help file. You should unzip both to the same folder (any folder of your choice) and then read the help file for more instructions. The next two bullets address some possible problems users have had.
oFor Solver that ships with Excel for Mac: SolverTable for Mac.zip Bitdefender adware removal mac.
¨(Note: If you downloaded this zip before 10/30/2020, download this version instead. The previous version didn’t recognize when a model has no feasible solutions. This version corrects the problem.) This version of SolverTable was created for the Mac in October 2020. The essence of SolverTable has always been that it makes multiple uninterrupted Solver runs. For technical reasons, this is not possible in Excel for Mac, which explains why a version of SolverTable had never been available for the Mac. However, this new version gets around the problem by making interrupted Solver runs. Before each run, you are prompted whether you want to make the next run. (This is explained more fully in the help file that is part of this zip file.) Admittedly, the interruptions slow down the process to some extent (besides the fact that Solver for the Mac is just plain slow), but it is much better than making multiple Solver runs manually, each with new input values. The good news is that the user interface and the results sheets are exactly the same as those for the Windows version of SolverTable.
oFor Solver that ships with Excel 2019 or Office 365: There is no “new” SolverTable add-in for either of these. As far as I’m aware, SolverTable for Excel 2016 should work fine with either of these. I’m currently using it with Office 365 and haven’t run into any problems.
oFor Solver that ships with Excel 2016: SolverTable 2016.zipSolver.xlam Download Mac Excel 2011
¨This version is basically the same as the 2013 version.
oFor Solver that ships with Excel 2013: SolverTable 2013.zip
¨This version wasn’t created because SolverTable 2010 wouldn’t work with Excel 2013. Rather, I made some technical changes in the software. Probably the main change is that this version now starts each Solver run from the original solution in the decision variable cells. (In previous versions, it started each Solver run from the previous Solver solution.)
¨Modified on 10/5/2015 to open the Help file in a simpler manner (less possibility of an error occurring).
oFor Solver that ships with Excel 2010:SolverTable 2010.zip
¨Modified on 10/5/2015 to open the Help file in a simpler manner (less possibility of an error occurring).
¨Modified on 4/26/2012 to fix a problem with long worksheet names. Basically, Excel allows worksheet names to be no longer than 31 characters. SolverTable creates a hidden sheet with its settings, and the name of the sheet is the model sheet name plus the suffix “_STS”. So if the name of your model sheet has from 28 to 31 characters, this would create an error. So
https://diarynote-jp.indered.space
コメント