Search Results for "excel vba programming"
Sort By:
Showing 37 open source projects for "excel vba programming"
View related business solutions-
AI-powered service management for IT and enterprise teamsGive your IT, operations, and business teams the ability to deliver exceptional services—without the complexity. Maximize operational efficiency with refreshingly simple, AI-powered Freshservice.
-
Turn Your Content into Interactive Magic - For FreeTransform anything you share into an engaging digital experience - for free. Instantly convert your PDFs, slides, and files into dynamic, interactive sessions with built-in collaboration tools, activities, and real-time assessment. From teaching to training to team building, make every presentation unforgettable. Used by millions for education, business, and professional development.
-
1
AtteStat
The package for statistical data analysis and applied mathematics
Less means - more power. The high performance open source package for statistical data analysis and applied mathematics AtteStat is an add-in for desktop versions of the Microsoft Excel spreadsheets. Both 32-bit and 64-bit in one package. The combination of the unsurpassed convenience of spreadsheets and the effective interception of Microsoft Excel exceptions (frontend) and the maximum speed of the C++ programming language (backend). Winner of contest Microsoft Office Extensions (PC Magazine... -
2
XLibraryDisplay
A sequence analysis tool for protein engineering
XLibraryDisplay is an intuitive sequence analysis program optimized for protein engineering. It is ideal for all directed evolution platforms including phage, ribosome, and yeast display. Analysis can be quickly done on hundreds to thousands of sequences. Best suited for Sanger sequencing. Requirements: Microsoft Windows XP, 7, 8, or 10 and Excel 2007, 2010, 2013, or 2016 Described in Stafford et al JCIM 2014: http://pubs.acs.org/doi/abs/10.1021/ci500362s -
3
ClooWrapperVBA
COM-wrapper of Cloo to execute OpenCL code from Excel.
The wrapper allows to execute OpenCL code on CPU and GPU devices from VBA. Sources are available under https://github.com/Excel-lent/ClooWrapperVBA -
4
Layered-Wall Cylindrical Pressure Vessel
An Excel workbook suitable for preliminary design and analysis
LWCPV.3.zip includes: 1. A macro enabled Excel workbook (LWCPV.xlsm) for preliminary design and analysis of long cylindrical, layered-wall pressure vessels (PVs) subjected to external hydrostatic pressure. The following four types of layered-wall construction are addressed: a. Two-layer isotropic. b. Three-layer isotropic sandwich-wall; and c. Three-layer sandwich-wall with orthotropic outer layers and isotropic... -
Crowdtesting That Delivers | TesteumTesteum connects your software, app, or website to a worldwide network of testers, delivering detailed feedback in under 48 hours. Ensure functionality and refine UX on real devices, all at a fraction of traditional costs. Trusted by startups and enterprises alike, our platform streamlines quality assurance with actionable insights.
-
5
Simple Cylindrical Pressure Vessels
Excel workbooks suitable for preliminary design and analysis
SCPV is a family of three macro enabled Excel workbooks for analysis of long cylindrical pressure vessels with flat endcaps subjected to external hydrostatic pressure. CPVanalysis.xlsm does stress and stability analyses. It plots stresses, deflections and the equilibrium path for imperfect circular cylinders showing the onset of yielding and limit points in relation to elastic and inelastic bifurcation buckling pressures. Two types of initial geometric imperfections, outer diameter out... -
6
Ship, Tow-Tether and Moonpool Models
Linked Excel workbooks for preliminary study of the title systems
The file “Ship, Tow-Tether and Moonpool Models.zip” is a collection of linked macro-enabled Excel workbooks suitable for conceptual to preliminary design of the title systems. The file “Block Diagram.pdf” shows linkages and summarizes each workbooks’ major features. FD and TD at the end of a file name denotes frequency domain and time domain solutions, respectively. Except for the moonpool TD model, which is a solution to the nonlinear equations of motion for the moonpool piston mode, TD... -
7
GrainSizeTools script
A Python script for estimating the grain size from thin sections
... the areas of the grain profiles measured grain-by-grain on planar sections and does not require previous experience with Python programming language (see documentation below and FAQ). For users with coding skills, the script is organized in a modular way facilitating the reuse and code extension. Lopez-Sanchez, MA (2018). GrainSizeTools: a Python script for grain size analysis and paleopiezometry based on grain size. Journal of Open Source Software, 3(30), 863, https://doi.org/10.21105/joss.00863 -
8
Stress-Strain Curve
Aids for creating and scaling Stress-Strain Curves
S-S Curve.zip includes: 1. A macro enabled Excel workbook (S-S Curve Helper.xlsm) for creating a Stress-Strain curve using the Ramberg-Osgood formula and commonly available material properties. Combinations of tensile or compressive and engineering or true forms can be selected. 2. A procedure for Stress-Strain curve scaling. 3. A formula for plastic Poison’s Ratio between the proportional limit and fully plastic condition. -
9
Plastic Bending Modulus
A macro enabled Excel workbook for estimating plastic bending modulus.
Bending Modulus.xlsm is a macro enabled Excel workbook for estimating plastic bending modulus. Inputs are tensile yield and ultimate strengths and section factor. -
Build Securely on AWS with Proven FrameworksMoving to the cloud brings new challenges. How can you manage a larger attack surface while ensuring great network performance? Turn to Fortinet’s Tested Reference Architectures, blueprints for designing and securing cloud environments built by cybersecurity experts. Learn more and explore use cases in this white paper.
-
10
Planar Elastica
A collection of technical notes on planar elasticas and sample code
The collection Planar Elastica (Planar Elastica.zip) includes: 1. A technical note deriving the governing equations for a planar elastic subjected to general end loading (i.e., combined bending moment, angled direct load and torsional moment). This note is heart of this project. 2. Macro enabled Excel spreadsheet examples that illustrate use of the above result. These examples range in sophistication from large displacement leaf springs to one requiring simultaneous solution of two... -
11
Cable Spool
A macro enabled Excel workbook for estimating drum loading by a cable.
Cable Spool.xlsm was developed to estimate loading on a storage drum due to winding of a steel cable. It was later updated to estimate internal loading in GRP ruggedized single fiber fiber-optic cable spools. Adhesive was applied as the cable was wound on a flanged mandrel. After the adhesive cured, the mandrel was removed leaving a spool composed of cable rings bound together by the adhesive. Both cables were very stiff radially. Hence, only axial and bending of the cable and mandrel... -
12
Excel Google Earth KML Creator
Convert site coordinates, sectors and MW links in Excel to KML format
This handy Excel VBA macro was designed for the telecom market, where you are able to convert points to KML, as well as sectors (as used in mobile network base stations) and links (as used for microwave links). Technical info presented in the resulting KML output file is not to be used for engineering / planning purposes. This was not the intention of this VBA tool. The only intention was to create a conversion tool with additional information presented in the KML file for display only... -
13
This Excel Add-In enables working with chemical formulas, like contracting them and calculating their molar masses. Dieses Excel Add-In erlaubt das Arbeiten mit chemischen Formeln, wie das Zusammenfassen zu Summenformeln und Berechnen von molaren Massen.
-
14
GLPK for Windows
Windows binaries for the GNU Linear Programming Kit (GLPK)
GLPK 4.65 (GNU Linear Programming Kit, http://www.gnu.org/software/glpk/) is a solver for large-scale linear programming (LP), and mixed integer programming (MIP). This project supplies the most recent Windows executables - 2018-03-17. Linux and OSX users should download the source distribution from http://ftp.gnu.org/gnu/glpk -
15
COASTEXCEL
A VBA enabled EXCEL spreadsheet to calculate water-wave properties
COASTEXCEL is a Microsoft-Excel spreadsheet with Visual Basic for Applications (VBA) functions to calculate fundamental wave properties using linear wave theory, simple wave transformations, tidal elevations, tsunami travel time, wind wave growth parameters, design wave heights using Raleigh’s probability distribution, breakwater dimensions and longshore sediment transport rates. -
16
XL Toolbox
Data analysis and visualization for Excel, for free
XL Toolbox is a free Excel statistics addin that helps analyzing and presenting data: Smart custom error bars, chart design, chart export to TIFF; formula builder, transpose wizard, analysis of variance (ANOVA); automatic backups, workbook management and more. -
17
Excelsi-R
Excel's Interface to R
Excelsi-R is an Excel add-in that allows Excel spreadsheets to harness the power of the R statistical language by connecting to a running R process. R does not need to be installed on the computer running Excel, but it does require access to an R instance running Rserve (which can be on a remote computer). It supports incorporating R plots and graphs in an Excel workbook. -
18
SQUID2 software processes SHRIMP ion microprobe data. It derives ages for the U-Th-Pb system, radiogenic Pb isotope ratios and raw isotope ratios. It is jointly developed by Dr Ken Ludwig, Geoscience Australia and the SQUID2 Development Group. SQUID2 is a Microsoft Excel add-In that processes PD files produced by SHRIMP ion microprobes into a variety of parameters, including raw isotope ratios, radiogenic Pb isotope ratios, ages for the U-Th-Pb system, and, via user-specified algorithms...
-
19
bitrate-xls
calculator for avi-file streams
A "bitwise precision tool" bitrate calculator using MS-EXCELL programming. The results are used for DVD Video to audio-video streams. It helps compute VIDEO- & AUDIO-Bitrates, aspect ratio, screen size, choose audio format cbr. Has units MB,pixel,d:h:m:s, kbps, etc -
20
alvinLAS
Excel Add in to import LAS (Log ASCII Standard) to Excel Sheet
Currently only LAS 2.0 unwrapped is supported. -
21
ExcelPython
An interface for calling Python from Excel
ExcelPython is a lightweight, easily distributable library for interfacing Excel and Python. It enables easy access to Python scripts from Excel VBA, allowing you to substitute VBA with Python for complex automation tasks which would be facilitated by Python's extensive standard library. v2 is a major rewrite of ExcelPython! - see GitHub site for more details. LICENSE NOTICE MIT License, please see new GitHub site for more details. Copyright 2012-2014 by Eric Reynolds. -
22
Leeds Census Tool
Using Excel 2010 and VBA to create a data reporting tool for Leeds
Excel allows the simple creation of reports and tables, this project is to create an API for the manipulation of Census and other data in such a way that customizable reports and tables can easily be generated for any (and aggregated) geographies from Census and other available data. -
23
Lego Charts for Excel
Plot Excel data as photo-realistic 3D LEGO® models
Using a sequence of Open Source CAD/CAM and graphics tools, integrated through Excel macro code, "Lego Charts" extends the idea of the Excel 3-D bar chart. It allows the placement, shapes and colours of the bars to represent further dimensions to the data. The chart is presented as a photo-realistic model apparently constructed out of LEGO® [1] bricks. The downloaded package consists of an Excel template to create the charts, an extensive installation and user guide, and two fully-worked... -
24
Dex to Wiktionary
Linguistic analysis
Scopul proiectului este conversia definițiilor din DEX '98, luate de pe dexonline.ro, din text simplu în formatul structurat folosite de Wiktionary. Programul convertește definițiile în 3 pași: - descarcă și extrage definițiile de pe dexonline.ro - parsează definițiile și le împarte în părți mai mici care sunt clasificate - asamblează bucățile într-un format arborescent, pe care apoi îl parsează și generează formatul cerut de Wiktionary -
25
This program estimates the lightning flashover rates of overhead electric power transmission and distribution lines, according to IEEE Stds. 1243 and 1410. New BSD License and IEEE Copyright. Now includes line arrester evaluation using the OpenEtran simulator, licensed under GPL. This feature was developed with support from EPRI and Dominion Virginia Power.
