← Back to listings

OpenSolver

Published by University of Auckland

Desktop Excel VBA add-in from Andrew Mason and students in the Department of Engineering Science at the University of Auckland (later development by Jack Dunn at MIT) that extends Excel's built-in Solver with more powerful open-source solvers. Vendor pages call it OpenSolver for Excel / the Open Source Optimization Solver for Excel. This listing is the desktop Excel add-in (OpenSolver.xlam) — not OpenSolver for Google Sheets, and not SolverStudio (a separate free Excel modelling tool). Default Linear build uses the COIN-OR CBC engine for linear and integer programmes, with optional Gurobi if you have a license; an experimental Advanced (non-linear) zip adds extra solvers and NEOS cloud solving and is not listed separately. Compatible with existing Excel Solver models; no artificial limits on variables or constraints beyond machine memory. Includes a model visualizer that highlights decision variables, objective, and constraints on the sheet, a QuickSolve mode for re-solving after right-hand-side changes, and a VBA API (RunOpenSolver). Install: download the Linear zip from SourceForge (Windows or Mac selected automatically from opensolver.org/installing-opensolver), on Windows right-click the zip → Properties → Unblock (required since the July 2016 Office security update), extract so OpenSolver.xlam stays with all files and subfolders, then double-click OpenSolver.xlam and enable macros. Commands appear under Excel's Data tab on Windows or the Menu Bar on Mac. Session-only until you check About OpenSolver → Load OpenSolver when Excel starts, or copy files into the Excel add-ins folder. Current stable Linear release OpenSolver 2.9.3 (1 Mar 2020; Gurobi 9.0 support): OpenSolver2.9.3_LinearWin.zip 4,967,716 bytes last-modified 17 Dec 2020; OpenSolver2.9.3_LinearMac.zip 16,036,940 bytes last-modified 17 Dec 2020. OpenSolver 2.9.4 Beta (15 Jan 2021) is also offered from the SourceForge files page. Windows: vendor says Excel 2007 and later; tested on 32- and 64-bit Windows 7/10 with Excel 2010/2013/2016. Help (updated July 2025) documents current Microsoft 365 desktop (confirmed on Microsoft 365 Apps for Enterprise Version 2507 Build 16.0.19029.20136 64-bit, 12 Aug 2025) if ActiveX/RefEdit is enabled in Trust Center; avoid NOMAD and the About OpenSolver dialog on those 2025 Excel builds or Excel can crash. Not Excel on the web and not Windows Store Excel (Click-to-Run / desktop install required). Mac: Excel for Mac 2011 on OS X newer than 10.7; limited Excel 2016 for Mac (need at least 15.28, then run Solvers/osx/OpenSolver Solvers.pkg). Vendor reports Excel 16.16.7 (late 2018) broke Mac support; a user reported High Sierra + Excel 16.24 worked and Mojave did not. Free and open source under the GPL; no paid license. Publisher asks users to donate to COIN-OR. Winner of the 2011 INFORMS COIN-OR Cup. Satalia SolveEngine is no longer available.

Price: Free

Platforms: Windows, Mac

Excel versions: 2010, 2013, 2016, 2019, 2021, 365

data-etlproductivity

Get started

Get from Microsoft StoreVisit websiteRead documentationGet support

  • Epoch SRA

    Microsoft Excel Office.js add-in from Epoch SRA (marketplace title Epoch SRA, AppSource WA200012389, publisher Epoch SRA / PN200007625, builtFor Microsoft 365, AppVersion 2.0.0.1) that installs from the Microsoft Marketplace Excel add-in store and opens an Epoch SRA Home-tab task pane so planning engineers and project-controls teams can run calibrated Monte Carlo schedule risk analysis inside Excel: import an MS Project XML schedule or an Excel schedule table, map a 5x5 risk register, compute seeded P50/P80 finish dates, and export a risk-adjusted Gantt. Marketplace title Epoch SRA | Microsoft Marketplace (https://marketplace.microsoft.com/en-us/product/office/WA200012389 HTTP 200): Epoch SRA by Epoch SRA; Get it now (CTA_Get). Marketplace JSON (https://marketplace.microsoft.com/view/app/WA200012389?country=US HTTP 200): appActionType FREE; hasPrices false; additionalPurchasesRequired true; WorksWith Excel_2016_Mac, Excel_2019, Excel_2019_Mac, Excel_Online, Win32_Excel, Excel_M365_Mac, Excel_M365_Win; ReleaseDate 2026-10-03; AppVersion 2.0.0.1; SupportLink https://addin.epochsra.com/support.html; PrivacyPolicyUrl https://addin.epochsra.com/privacy.html; determinedStorefronts Appsource; linkedAddIns empty; short description Calibrated Monte Carlo schedule risk analysis inside Excel: import your MS Project or Excel schedule. Marketplace description: Epoch SRA turns the schedule and risk register you already maintain into a defensible P50/P80 forecast without a dedicated risk analyst and without leaving Excel; imports MS Project XML or an Excel schedule table including all four dependency types with lags; reads a 5x5 likelihood and severity risk register; runs a seeded reproducible Monte Carlo; writes P50 and P80 finish dates, top risk drivers, probabilistic criticality, and a since-last-run view; renders a risk-adjusted Gantt exportable as PNG with run provenance and a multi-page PDF report; a full-featured 7-day free trial starts on first use with no sign-up; licenses are per named user and are purchased at epochsra.com. Vendor homepage title Epoch SRA – schedule risk analysis Excel add-in | Monte Carlo on MS Project schedules (https://epochsra.com/ HTTP 200): the risk-adjusted schedule in Excel; Every plan starts in the add-in with a 7-day free trial, full-featured, no signup, no card; Monthly €119 per seat / month; Annual €990 per seat / year (30% off); Perpetual €1,300 per seat + €350 / year maintenance (€1,650 first year); prices ex-VAT; license keys delivered by email within 24 hours; built by Equinox Consulting in Luxembourg. Vendor support title Support – Epoch SRA (https://addin.epochsra.com/support.html HTTP 200): install in Excel via Insert > Get Add-ins (or Home > Add-ins), search for Epoch SRA and click Add; Microsoft Excel with Office JavaScript API ExcelApi 1.8 or later: Microsoft 365 (Windows and Mac), Office 2021/2019, and Excel on the web; all computation is local. Vendor privacy title Privacy Policy – Epoch SRA (https://addin.epochsra.com/privacy.html HTTP 200): last updated 9 August 2026; schedule, risk register and results never leave the workbook; no account and no analytics in the add-in. Vendor guide title Reading your risk-adjusted schedule – Epoch SRA (https://epochsra.com/guide.html HTTP 200). Vendor EULA title End-User License Agreement – Epoch SRA (https://addin.epochsra.com/eula.html HTTP 200).

  • SPC for Excel

    Excel add-in (.xlam) from BPI Consulting, LLC (12220 N. MacArthur Blvd, Suite F 102, Oklahoma City, OK 73162, United States; legal representative William H McNeese) for statistical process control and statistical analysis inside Microsoft Excel. The homepage titles it SPC for Excel | Statistical Process Control Software Add-in and calls it complete statistical analysis and SPC tools inside Excel; it says the software provides a complete set of statistical process control and statistical analysis tools directly inside Microsoft Excel and is used by tens of thousands of users in 80 countries. The about page calls SPC for Excel a statistical process control (SPC) software add-in that works directly inside Microsoft Excel, first developed in the early 1990s; all tools are accessed directly from the Excel ribbon; no separate application. The software product page says it runs directly inside Microsoft Excel, installs locally, is easy to uninstall, uses perpetual licenses, and has no annual or maintenance fees. This listing is SPC for Excel Version 7 — not the Version 7 site license as a second catalog row. Install (spcforexcel.com/spc-for-excel-installation): distributed as zip SPC_for_Excel_V7.zip for both PC and Mac (demo zip includes Demo in the name); files include spcforexcelv7.xlam, example files, Getting Started with SPC for Excel_V7.pdf, and Installing SPC for Excel Version 7.pdf. PC: unzip, Unblock spcforexcelv7.xlam, Excel File → Options → Add-Ins → Go (Manage Excel Add-ins) → Browse to spcforexcelv7.xlam (choose No if asked to move the file to the add-ins folder); ribbon should appear between Home and Insert; add the folder as a Trusted Location if the tab is missing. Mac: unzip, Excel Tools → Add-ins → Browse to spcforexcelv7.xlam. FAQ: Version 7 will run on any PC that will run Excel 2013 or later or on a Mac with Excel 2016 or later; it works with Office 365 for both PC and Mac. Store product page requirement: Excel 2016 or later (including Office 365) for PCs or Excel 2019 and later (including Office 365) for the Mac; download size 12 MB. Software page also names Excel 365 / 2021 / 2019 back to 2013. Current revision-history build 7.0.1.0 dated 6/22/2026 (Descriptive Statistics / Box-Whisker updates). Pricing (spcforexcel.com/ordering-information): per-user starting at $329 USD for a single user; 2–10 users $296/user (10% off); 11–20 $279; 21–50 $263; site license $5,900 (anyone employed at one physical location may use the software); upgrade from an earlier version $145/user; one-time fee for the current version; no maintenance or annual fees; new builds of the current version are free; there is a charge only if you upgrade to a future version; license is perpetual as long as the software works in future versions of Excel. Catalog Add to cart: SPC for Excel Version 7 $329.00; Version 7 Site License $5,900.00; Version 7 Upgrade $145.00. Free 30-day full-featured demo with no credit card and no obligation to purchase; works with Excel on Windows and macOS; email delivers the download link and installation instructions. Money-back guarantee (returns policy). Order online with credit card or purchase order, fax the order form, email sales@spcforexcel.com, or call 800-274-2874 / 281-304-9504. Publisher: BPI Consulting, LLC. Support: support@spcforexcel.com / 1-800-274-2874.

  • XLSTAT

    Windows/Mac Excel add-in from Lumivero / Addinsoft SAS (vendor title XLSTAT | Statistical Software for Excel) that runs statistical analysis, visualization, and modeling inside desktop Microsoft Excel. Vendor homepage title XLSTAT | Statistical Software for Excel (https://www.xlstat.com/ HTTP 200): The leading data analysis and statistical solution for microsoft excel; XLSTAT is a powerful yet flexible Excel data analysis add-on that allows 150,000+ users in over 120 countries to analyze, customize, and share results within Microsoft Excel; Directly integrated into Microsoft Excel; Try XLSTAT Advanced; Buy now; solutions XLSTAT Essentials / Standard / Advanced. Vendor download title XLSTAT, Your data analysis solution (https://www.xlstat.com/download HTTP 200): 14-day free trial equivalent to XLSTAT Advanced; over 300 statistical features including AI-assisted tools; trial cannot be renewed or extended; Download XLSTAT for Windows; Download XLSTAT for Mac; INSTALL XLSTAT Run the downloaded file, Open XLSTAT at the end of the installation; ACTIVATE Launch the Application and fill in the form; no credit card and no charge when the trial expires; after the trial purchase a license or switch to the free version with a limited number of basic features. Vendor Windows install title Installing XLSTAT on Windows | XLSTAT Help Center (https://help.xlstat.com/6379-installing-xlstat-windows HTTP 200): download the latest version from the Free Trial page; Double-click on xlstat.exe; Advanced button to choose the install folder; All users vs Current user (Current user may install without administrator privilege); Accept the license agreement; after install, run XLSTAT right away before exiting the wizard so it runs in Microsoft Excel. Vendor supported systems title Supported systems for XLSTAT | XLSTAT Help Center (https://help.xlstat.com/6396-supported-systems-xlstat HTTP 200): Windows 11 / 10 / 8 / 7; Microsoft Excel 32-bit and 64-bit Excel from Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013 (service pack 1 required), Excel 2010 (service pack 2 required); Mac macOS 14 Sonoma, 13 Ventura, 12 Monterey, 11 Big Sur, 10.15 Catalina, 10.14 Mojave, 10.13 High Sierra, 10.12 Sierra, 10.11 El Capitan; Excel from Microsoft 365, Excel 2021, Excel 2019 (16.18 or greater), Excel 2016 (16.8 or greater); 4 GB RAM; Intel or Apple ARM-based on Mac; 1 GB disk. Vendor Windows requirements title Requirements for XLSTAT on Windows | XLSTAT Help Center (https://help.xlstat.com/6417-requirements-xlstat-windows HTTP 200): Windows 7/8/10/11; 4 GB RAM; Pentium or compatible; 1 GB disk; Office 2016/2019/2021/365 no Service Pack required. Vendor commercial pricing title Commercial | Statistical Software for Excel (https://www.xlstat.com/pricing/company HTTP 200): 12-month individual subscription for businesses, consultants, and professionals; prices for one single-user license; XLSTAT Advanced $1,995 /year (300+ statistical tools, AI-powered description/interpretation, R integration); XLSTAT Standard $1,410 /year; XLSTAT Essentials $380 /year; network license via contact form. Vendor privacy title Privacy policy | Statistical Software for Excel (https://www.xlstat.com/legal/privacy-policy HTTP 200): Last Updated April 3, 2023; Lumivero, LLC Data Privacy Policy; Lumivero main office Denver, Colorado, USA; related entity Addinsoft SAS (France). Vendor contact title Contact our sales team | Statistical Software for Excel (https://www.xlstat.com/contact/sales HTTP 200): Commercial Inquiries and Technical Support; recipients of form data Addinsoft SAS and XLSTAT. Help Center also documents xlstat.dmg on Mac (https://help.xlstat.com/ HTTP 200 trending article Blocked to install XLSTAT on MAC - xlstat.dmg can’t be opened). This listing is the real XLSTAT Excel statistics add-in — not the quarantined fake xlstat-for-excel dashboard record, not @RISK, not DecisionTools Suite, not Predict!, not SharpCloud, and not XLSTAT 3D Plot or LatentClass as standalone products.

  • ActiveData For Excel

    Windows Excel add-in from InformationActive Inc. that adds advanced data analysis and worksheet-management features to Microsoft Excel as a single module on the familiar Excel ribbon. Product page title ActiveData For Excel; homepage title ActiveData - Analytics For Excel. Vendor copy: ActiveData For Excel is an add-in for Microsoft Excel; join, merge, match, query, summarize, categorize, locate duplicate and missing items, combine, split, splice, slice and dice data; over 100 features. This listing is ActiveData For Excel (Business and Professional editions share the same installer; the 30-day evaluation is the full Professional Edition) — not ActiveData For Office / SQL as a second catalog row (vendor lists that as a separate free product, Version 2.0.46 dated July 8, 2010), not the eBook Data Analysis with ActiveData, not Top Audit Tests Using ActiveData for Excel, and not the Self Study Course Auditing, Fraud Detection and Cash Recovery as their own listings. French, German, and Japanese versions are localizations of the same add-in, not separate catalog rows. Publisher InformationActive Inc., founded in 2003 by John West (original developer of the IDEA audit platform); ActiveData for Excel released in 2004; about page says 5,000+ companies and 100,000+ users in 70 countries. Postal address 2706-221 Lyon St N, Ottawa, Ontario, Canada, K1R 7X5; contact title Contact Us; sales +1 (613) 569-4675 x 184; support +1 (613) 569-4675 x 175; email support@informationactive.com; US Eastern time zone (GMT - 5); support hours 11AM-7PM EST. Homepage (April 2023): New version ActiveData 5.0.508. Product catalog title ActiveData For Excel Product Catalog, prices in $US: product 1000 ActiveData For Excel - Professional Edition $299.00 (Analysis, Workbook and Worksheet command sets); product 1020 ActiveData For Excel - Business Edition $149.00 (Workbook and Worksheet command sets); product 1021 Upgrade From Business Edition to Professional $150.00; product 1001 Support (1 Year) $49.00; product 1007 Support (2 Years) $89.00; product 1008 Support (3 Years) $129.00. Professional edition (for auditors and accountants) adds computer-assisted audit techniques (CAATs): stratification, aging, sampling (random, stratified and monetary/PPS), digital analysis using Benford's Law, cross tabs, duplicate key detection/removal, and gap detection. Business Versus Pro edition title ActiveData For Excel - Business Versus Pro Edition also lists summarize, statistics, outlier analysis, join/merge, compare, combine, split, query by example/match, Levenshtein fuzzy matching, COM automation, Terminal Server, and silent install; Professional-only analytical rows include stratification, aging, Benford's Law, sampling, duplicate/gap detection, and cross tabulate. Download title ActiveData For Excel - Download: evaluation is the full Professional Edition and is active for 30 days after installation, then activate as Business or Professional by purchasing a license; workbook commands on the ActiveData ribbon remain active after the evaluation period without a license. Runs with Excel 2013 or later in both 32- and 64-bit versions; Windows 7 or later; Terminal Server and Citrix; administrator privileges required to install. Close Excel before installing; uninstall any older version first (Windows 10+ Settings > Apps > ActiveData > Uninstall). Direct installers HTTP 200 application/octet-stream with MZ PE magic: https://www.informationactive.com/ad/downloads/1000/ActiveDatax64.exe Content-Length 12196456 last-modified Tue, 14 Mar 2023 03:24:43 GMT; https://www.informationactive.com/ad/downloads/1000/ActiveDatax86.exe Content-Length 12193928 last-modified Tue, 14 Mar 2023 03:23:45 GMT. Legacy Excel 2000-2003 package adata.msi linked from the download page returned HTTP 404 from this host. Refunds title Refunds and Delivery: full refund within 30 days of purchasing; disc delivery if unable to download. Privacy Statement last updated January 15, 2025. Homepage teaser images HTTP 200: images/adxl-teaser-1.gif image/gif 77446 bytes; images/adxl-260x80.png image/png 11657 bytes. Sample training PDF https://www.informationactive.com/data/attachments/TopAuditTestsUsingActiveDataSample.pdf HTTP 200 application/pdf 520704 bytes. Do not dual-list ACL or IDEA (those are third-party CAAT tools ActiveData compares against).

  • ALM DataHub

    Microsoft Excel Office.js add-in from Genixus Labs Ltd (marketplace title ALM DataHub, AppSource WA200012065, publisher Genixus Labs / PN200007483, builtFor Microsoft 365, AppVersion 1.0.0.1) that installs from the Microsoft Marketplace Excel add-in store and opens from the Excel Home ribbon / Add-ins pane / ALM DataHub ribbon tab / task pane so signed-in users can pull UK actuarial and fixed-income market data with native ALM.* worksheet functions. Marketplace title ALM DataHub | Microsoft Marketplace (https://marketplace.microsoft.com/en-us/product/office/WA200012065 HTTP 200): ALM DataHub by Genixus Labs; Get it now (CTA_Get). Marketplace JSON (https://marketplace.microsoft.com/view/app/WA200012065?country=US HTTP 200): appActionType FREE; hasPrices false; additionalPurchasesRequired true; WorksWith Excel_2019_Mac, Excel_Online, Win32_Excel, Excel_M365_Mac, Excel_M365_Win; ReleaseDate 2026-09-14; AppVersion 1.0.0.1; SupportLink https://almdatahub.com/support; PrivacyPolicyUrl https://almdatahub.com/privacy; determinedStorefronts Appsource; linkedAddIns empty; short description UK actuarial market data - gilt curves, SONIA, PRA spreads, inflation, life tables - in Excel. Marketplace description: ALM DataHub puts UK actuarial and fixed-income market data inside Excel as native ALM.* worksheet functions — 48 functions across 19 series, drawn from public publications of the Bank of England, the ONS, and the PRA; yield curves (gilt nominal, SONIA OIS, implied inflation, Solvency II risk-free term structures for UK/EU/US/Canada; gilt history back to 1970); Smith-Wilson fits via ALM.SW_FIT; rates and FX (SONIA, Bank Rate, SONIA Compounded Index, Sterling ERI, 22 sterling FX pairs); inflation (RPI, CPI, CPIH, RPIX; RPI back to 1948); PRA fundamental spreads for Matching Adjustment; ONS national period life tables; vectorised formulas and discovery helpers (ALM.LATEST_DATE, ALM.AVAILABLE_SERIES); sign in once from the task pane; formulas resolve through batched REST API calls; Getting started: 14-day free trial at almdatahub.com then GBP 79 per user per month or GBP 790 per year. Vendor homepage title ALM DataHub — UK Actuarial and Fixed Income Market Data (https://almdatahub.com/ HTTP 200): Get the Excel add-in; See the data; Start free trial; One add-in. One token. Zero CSV downloads; ALM DataHub is a trading name of Genixus Labs Ltd, registered in England and Wales, company no. 16720079. Vendor Excel product title Excel Add-in — ALM DataHub (https://almdatahub.com/excel HTTP 200): Market Data as Worksheet Functions; 48 functions, one prefix ALM.*; Install the add-in from Microsoft AppSource or central IT deployment; Sign in from the task pane; Compatibility Excel 2016 or later on Windows and Mac, and Excel for the web; Microsoft 365 subscriptions included; Get it on AppSource https://marketplace.microsoft.com/en-us/product/WA200012065; Home → Add-ins → search ALM DataHub. Vendor install guide title Install the Excel Add-in — ALM DataHub (https://almdatahub.com/excel-addin/install HTTP 200): on Microsoft AppSource; installation one click from inside Excel on Windows, Mac, and Excel for the web; Home tab → Add-ins → More Add-ins → Store → search ALM DataHub → Add; ALM DataHub tab appears in the ribbon; Task pane and sign in; same steps in Excel for the web at excel.cloud.microsoft; or click Get it now on the AppSource listing; check with =ALM.SONIA("2024-03-15"). Vendor pricing title Pricing — ALM DataHub (https://almdatahub.com/pricing HTTP 200): One Subscription. Everything; Monthly £79/user/month + VAT where applicable, rolling monthly, cancel any time; Annual £790/user/year + VAT where applicable; 14-day free trial of full access; Excel add-in 48 ALM.* functions included on every plan; REST API + Power Query templates included in the same subscription. Vendor support title Support — ALM DataHub (https://almdatahub.com/support HTTP 200): Excel add-in topic; support@almdatahub.com. Vendor privacy title Privacy Policy — ALM DataHub (https://almdatahub.com/privacy HTTP 200): last updated 29 August 2026; Genixus Labs Ltd company number 16720079; Excel add-in named as a delivery surface; no usage telemetry on which functions are called. Marketplace Get it now is free to install; public 14-day trial then £79 per user per month / £790 per user per year HTML is live. This listing is the Excel Office.js add-in ALM DataHub WA200012065 — not the REST API as a standalone product, Power Query templates as a standalone product, Python/R/curl scripting, the partner programme, or Bank of England / ONS / PRA source publications as standalone products.

  • Analyse-it

    Windows COM add-in from Analyse-it Software, Ltd. (Leeds, England; founded 1997; company no. 3022685) that runs statistical analysis, method validation, diagnostic performance, and quality control inside desktop Microsoft Excel. Analyses sit on an Excel ribbon tab with options in a task pane; results are written back as ordinary worksheets so colleagues can open them without a licence. This is the desktop Excel add-in — not Excel on the web, not macOS, and not a standalone statistics package. Five editions: Standard (descriptive statistics, hypothesis tests, ANOVA, regression, PCA, logistic regression, correlation, contingency tables); Quality Control (Shewhart/CUSUM/EWMA control charts, process capability, Pareto); Medical (Bland-Altman, ROC diagnostic accuracy, reference intervals, Kaplan-Meier/Cox survival); Method Validation (method comparison, precision, linearity, detection limits, 11 CLSI evaluation protocols); Ultimate (all editions). Install: download the dual 32/64-bit .EXE from analyse-it.com/free-trial, close Excel, run the installer (per-user default needs no administrator rights; ALLUSERS=1 for every account). Analyse-it starts with Excel and offers a 15-day trial of every edition with no sign-up, no licence key, and no card; trial analyses are watermarked and results cannot be copied out until licensed. Windows only: Excel 365 and Excel 2024/2021/2019/2016 (32- and 64-bit desktop). Install docs also list Excel 2013 or later and Windows 8/10/11 or Windows Server 2016/2019/2022. Not Excel for Mac (COM add-ins unsupported) and not Excel Online. Pricing (analyse-it.com/store/buy and analyse-it.com/products): Standard US$155/year or US$395 perpetual; Quality Control US$290/year or US$760 perpetual; Medical US$340/year or US$815 perpetual; Method Validation US$475/year or US$1155 perpetual; Ultimate US$575/year or US$1495 perpetual; 30-day money-back guarantee; licences do not auto-renew. Publisher: Analyse-it Software, Ltd., The Tannery, 91 Kirkstall Road, Leeds LS3 1HS, United Kingdom. Support: support@analyse-it.com.