Excel Toolset

ExcelToolset, add-in for Microsoft Excel, is a collection of unique tools and features designed to simplify and automate your daily tasks. This solution, implemented entirely in .NET 6 C# using ExcelDna, takes full advantage of modern libraries and optimizations, including asynchronous and parallel computing. ExcelToolset is designed with a modular structure that offers a clear and organized view of its functionality. Each function is documented, providing a description of its operation and associated parameters. There is a multilingual implementation: it supports interoperability between different languages, ensuring greater flexibility for multilingual users.

Functionality

Excel Toolset consists of the following libraries:

Psychrometric Chart: Calculation of the physical properties of humid air.
Sensitivity Analysis: Sensitivity analysis of specific parameters.
Air, Water and Methane Gas: Calculation of pressure drops, pipe diameters and more.
Economic: Calculation of Breakeven Point (PBT), Annuity Factor and Discounted Payback Time.
Engineering: Calculation of Total Sound Pressure and A-Weighted Decibels.
Development: Support for VBA development.
Generic: General data operations in Excel such as interpolation, sorting, rounding and filtering.

Installation procedure

There are two ways to install ExcelToolset:

Installer:
- The installer checks the requirements and, if met, installs the add-in in Excel.
- It does not require administrative privileges if you are using a Windows "unprotected" folder.
- It is essential to have .NET Desktop Runtime 6.0.x installed, in the same bit version as Excel; you can download it from the following link.
  The installer can check for the .NET Desktop Runtime but cannot install it on its own. If missing the installation is interrupted and you must proceed with the installation yourself; the error message shows the Excel bit version.
Manual installation:
- It is essential to have .NET Desktop Runtime 6.0.x installed in the same bit version as Excel. Link download .NET Desktop Runtime 6.0.x How to find the bit version of Excel
- Download the add-in and copy it to a folder of your choice.
- Activate the add-in in Excel (Develop tab -> Excel Add-ins).

Activation

To enable ExcelToolset, follow these steps:

Make sure you have a verified email account.
Activate the licenses inside the reserved area of the site
The first time you start Excel enter your account login details.

Update

ExcelToolset does not currently support automatic updates but is able to notify you of the availability of new versions.
You can update the application via the installer of the new version or by manually replacing the existing installation files with new ones (See Installation Procedure).

Download

ExcelToolset is provided "as is" without express warranty.

Spreadsheets

Dimensionamento UTA

Changelog

V.1.0.0

First release

Informativa uso cookie