This is a collection of all the code that can be found on my YouTube channel Sigma Coding.
-
Updated
Mar 31, 2022 - Jupyter Notebook
{{ message }}
This is a collection of all the code that can be found on my YouTube channel Sigma Coding.
Code Blocks relating to everything VBA
A series of Visual Basic Applications (VBA) methods I wrote, mostly for Excel, to increase the speed and accuracy in working with data, charts and databases.
Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
User Defined Functions for multi-component thermodynamic calculations of the Predictive Peng-Robinson 1978 Equation of State. Clean VBA functions - no UI changes and no pop up messages. Errors are reported in cell comments. Import Math.bas, ModArraySupport.bas and ChemE_Functions.bas into PData.xlsx and save as xlsm or simply download PData.xlsm.
Lightweight tool to export ranges within an Excel sheet to CSV
VBA snippets and code library
Complex, Re-Usable, Performance-Optimised VBA Functions (2017 - 2019).
A VBA macro that facilitates version control by automatically importing/exporting other VBA macros in Office documents.
Excel VBA - Sales Transaction - Book Keeping
Financial Models using vba script and Python
VBA dictionary alternative to the Scripting.Dictionary which is Mac compatible and implements a IScriptingDictionary interface.
Just like me, you write Excel macros and you want a simple way to export your code as text files to your hard disk so that you can manage versions and load the code into e. g. GitHub? My vba_excel_export_code script is made for you. From now on it also manages the export of your ribbon.
Excel VBA macro to display built-in FaceId icons and numbers in a worksheet.
Connection with Excel-VBA to SQL database (mysql MariaDB). Or any database with the appropriate ODBC driver
Call Julia from Microsoft Excel worksheets and from VBA
Excel Pomodoro Timer
Visual Basic tool that returns table data from a website to excel sheet
Add a description, image, and links to the vba-excel topic page so that developers can more easily learn about it.
To associate your repository with the vba-excel topic, visit your repo's landing page and select "manage topics."
Is your feature request related to a problem? Please describe.
Related to the Load Combinations request
Describe the solution you'd like
Functions available to remove or edit existing loads on existing nodes or members.
Additional context
This will be necessary as part of the Load Combinations request. To remove existing loads and replace them with loads from a different LC w