How-To Geek on MSN

Why I can't quit Excel: 5 desktop features open-source alternatives are missing

From Power Query to the Data Model, here are the five architectural gaps that keep me paying for Microsoft 365.
GitHub

A free VBA library to make structural analysis easy in Microsoft Excel.

This project gives you the ability to perform 2D structural analysis on frame, truss, and beam structures using Visual Basic for Applications within Microsoft Excel. xlFrame uses the direct stiffness ...
IEEE

Object Identification With Minimal Precomputed Library Using Physical Aspect of Singularity Expansion Method

Abstract: In this letter, we propose a method for estimating the circumferential length of metal objects without any a priori information regarding object shape and dimension. Object type can also be ...
GitHub

Excel Visual Basic for Applications Pharmacy Functions Library

Custom pharmacy functions enabling a user to calculate patient metrics, lab values, and drug dosing. With the Pharmacy Function Library, you can perform commonly used clinical pharmacy calculations.
IEEE

Robotics library: An object-oriented approach to robot applications

Abstract: We discuss the architecture and software engineering principles of the Robotics Library (RL). Driven by requirements of robot systems, research projects, industrial applications, and ...
TechRepublic

Sample file: Excel dashboard with PivotChart and Slicer objects

This file demonstrates the techniques explained in the article Create a quick and effective dashboard using Excel’s PivotChart and Slicer objects. Discover the secrets to IT leadership success with ...