Search Results for "excel vba programming"
Sort By:
Showing 37 open source projects for "excel vba programming"
View related business solutions-
Keep company data safe with Chrome EnterpriseMake AI work your way with Chrome Enterprise. Block unapproved sites and set custom data controls that align with your company's policies.
-
Our Free Plans just got better! | Auth0You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
-
1
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 -
2
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 RE) in 2006. Registered 2002-05-23 with the Federal Service for Intellectual Property. ... -
3
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... -
4
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... -
MongoDB Atlas runs apps anywhereMongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
-
5
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 -
6
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 ... -
7
GrainSizeTools script
A Python script for estimating the grain size from thin sections
Homepage & docs: http://marcoalopez.github.io/GrainSizeTools/ GrainSizeTools is a free, open-source, cross-platform script written in Python that provides several tools for (1) estimating average grain size in polycrystalline materials, (2) characterizing the nature of the distribution of grain sizes (either from apparent distributions or approximating 3D grain size distributions via stereology), and estimating differential stress via paleopizometers. The script requires as the input the... -
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. -
Level Up Your Cyber Defense with External Threat ManagementMove beyond alerts. Gain full visibility, context, and control over your external attack surface to stay ahead of every threat.
-
10
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... -
11
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... -
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. -
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
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. -
20
alvinLAS
Excel Add in to import LAS (Log ASCII Standard) to Excel Sheet
Currently only LAS 2.0 unwrapped is supported. -
21
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 -
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
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 -
24
Tools for T-RFLP data analysis
VB macros and a template for the analysis of T-RFLP data using Excel.
A collection of Visual Basic macros and a template for the analysis of terminal restriction fragment length polymorphism data using Microsoft Excel. -
25
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...
