SolverStudio (original) (raw)
SolverStudio is a free Excel plug-in developed at the University of Auckland that supports optimization and simulation modelling in a spreadsheet using an algebraic modeling language. It is popular in education, the public sector and industry for optimization users because it uses industry-standard modelling languages and is faster than traditional Excel optimisation approaches. The GNU clone of AMPL, GMPL (GNU MathProg Language) is included with SolverStudio.
| Property | Value |
|---|---|
| dbo:abstract | SolverStudio is a free Excel plug-in developed at the University of Auckland that supports optimization and simulation modelling in a spreadsheet using an algebraic modeling language. It is popular in education, the public sector and industry for optimization users because it uses industry-standard modelling languages and is faster than traditional Excel optimisation approaches. SolverStudio adds a text editor to Excel that is used to create a text-based optimization (or simulation) model using a modelling language such as PuLP, AMPL, GAMS or Julia/JuMP. SolverStudio also provides a tool for naming data on a spreadsheet (and specifying indices for this data), allowing the data to be used in the model. When the model is run, the system automatically reads input data from the spreadsheet and provides it to the model, and then writes the model results back to the spreadsheet. SolverStudio works with a range of commercial and open source modelling systems. By default, it uses PuLP, an open-source Python COIN-OR modelling language. A second open-source Python option is Pyomo which supports non-linear and stochastic programming and provides access to a larger range of solvers. Another supported linear and non-linear modelling option is Julia/JuMP. SolverStudio also makes the two popular commercial modelling languages, AMPL and GAMS available to Excel users. SolverStudio allows models written using these languages to be solved on the user's own PC, or in the cloud using NEOS. The GNU clone of AMPL, GMPL (GNU MathProg Language) is included with SolverStudio. SolverStudio includes the open-source COIN-OR CMPL modelling language, and the Python-based SimPy simulation language. SolverStudio supports general programming using both Python and IronPython, allowing these programming languages to be used to script Excel using the standard VBA interfaces. (en) |
| dbo:wikiPageID | 50087102 (xsd:integer) |
| dbo:wikiPageLength | 3990 (xsd:nonNegativeInteger) |
| dbo:wikiPageRevisionID | 1054582442 (xsd:integer) |
| dbo:wikiPageWikiLink | dbr:Pyomo dbr:Python_(programming_language) dbr:Algebraic_modeling_language dbc:Microsoft_Office-related_software dbr:Julia_(programming_language) dbr:Visual_Basic_for_Applications dbr:General_Algebraic_Modeling_System dbr:Spreadsheet dbc:University_of_Auckland dbr:COIN-OR dbr:GNU_Project dbr:AMPL dbr:IronPython dbc:Mathematical_optimization_software dbr:Microsoft_Excel dbr:Optimization dbr:Simulation |
| dbp:wikiPageUsesTemplate | dbt:Official_website dbt:Short_description dbt:Use_New_Zealand_English dbt:Use_dmy_dates |
| dcterms:subject | dbc:Microsoft_Office-related_software dbc:University_of_Auckland dbc:Mathematical_optimization_software |
| rdfs:comment | SolverStudio is a free Excel plug-in developed at the University of Auckland that supports optimization and simulation modelling in a spreadsheet using an algebraic modeling language. It is popular in education, the public sector and industry for optimization users because it uses industry-standard modelling languages and is faster than traditional Excel optimisation approaches. The GNU clone of AMPL, GMPL (GNU MathProg Language) is included with SolverStudio. (en) |
| rdfs:label | SolverStudio (en) |
| owl:sameAs | wikidata:SolverStudio https://global.dbpedia.org/id/2MJD8 |
| prov:wasDerivedFrom | wikipedia-en:SolverStudio?oldid=1054582442&ns=0 |
| foaf:homepage | http://solverstudio.org |
| foaf:isPrimaryTopicOf | wikipedia-en:SolverStudio |
| is dbo:wikiPageWikiLink of | dbr:Pyomo dbr:COIN-OR dbr:AMPL |
| is foaf:primaryTopic of | wikipedia-en:SolverStudio |