Search Results for "excel macro"
Sort By:
Showing 40 open source projects for "excel macro"
View related business solutions-
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.
-
Go from Code to Production URL in SecondsSkip the Kubernetes configs. Cloud Run handles HTTPS, scaling, and infrastructure automatically. Two million requests free per month.
-
1
Accouting Excel
Accounts33.zip is a MS Excel VBA Software of Financial Accounting
...Trading Account in included. Go to excel option then advance option then trust Centre setting then enable macro settings. User can delete previous data and start fresh, this and Cash Flow Statement have been included. Print and convert to pdf file option is included in every statement page. PLEASE READ AccountingExcelReadMe.txt file or Guide menu in main menu of this Application to work with it -
2
SchoolManagement
SchoolManagement is a free and opensource excel vba application
SchoolMag is a free and opensource msexcel vba standard software for management of school. ANY PASSWORD CAN OPEN IT. Right click and unblock all files SchoolMagement15.zipped Forder. First go to excel option Trust Centre, trust center setting, macro setting and opt for enable macro, then go to ActiveX setting and opt for enable control without restriction and then click on ok. First click on Profile View and Set to set particulars such as name, address, phone no, email id etc of the school. Click on Admission / Registration button to admit new student and modify students basic data. ... -
3
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. -
4
Tibetan Unicode Keyboard
Screen keyboards in MS Excel and in Java for typing Tibetan characters
A Tibetan character is formed by stacking the middle (core) character with lower character stack(s) and upper stack. The tools in this package has been tested to work well in Windows 10 and above. The Java version is in the project titled Tibetan Java Keyboard. The MS Excel version does not work on Excel operating in MacOS. The Excel version uses Excel macros and VBA codes. One needs to Enable Macro to allow it to work. The motivation for this project is due to old proprietary Tibetan fonts not displaying properly on different systems. However, with the Tibetan unicode fonts being available and maturing in recent years, it makes documents typed in Tibetan unicode fonts readable on different operating systems. ... -
Earn up to 16% annual interest with Nexo.Generate interest, access liquidity without selling, and execute trades seamlessly. All in one platform. Geographic restrictions, eligibility, and terms apply.
-
5
Thick-Wall Composite PV
Stress-Strain analysis of thick-wall composite cylindrical PV
TWOPV.xlsm is a macro enabled Excel workbook for calculating stress and strain in a thick-wall cylindrical pressure vessel under external hydrostatic pressure. Vessel walls are a special case orthogonal composite laminate having a 2:1 ratio of circumferential to longitudinal oriented laminae. Inputs are: 1) unidirectional composite (UDC) properties, 2) cylinder radii and 3) pressure. -
6
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. -
7
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 solutions are obtained by superposing FD solutions in uniform random phase. ... -
8
DAPS4e.6
A Fortran code for design and analysis of ring-stiffened shells
... • Ring-frame stress and Elastic Instability analysis (EFI). Solutions compare favorably with DTMB experimental results. DAPS4e.6’s IO is managed through a Visual Basic UserForm. Pre/post processing is done using macro-enabled Excel workbooks. The file DAPS4e.6.zip includes: • DAPS4e.6 executable and Fortran 95 source code. • Visual Basic UserForm and its 2022 Visual Basic project code. • Excel workbook pre/post processors. • Technical documentation -
9
Schedule Creator
Microsoft Excel macro workbook that creates monthy calendar schedules
This Microsoft Excel macro enabled workbook assists you in creating a schedule for your retail store. Click on a button and enter the month and year that you wish to create a calendar schedule for. The macros will create a calendar that allows you to select your configured staff from a list, enter the hours, and then automatically sum the hours for each day, week, and for the entire month. -
$300 in Free Credit Towards Top Cloud ServicesStart your project in minutes. After credits run out, 20+ products include free monthly usage. Only pay when you're ready to scale.
-
10
Excel2GED
Excel genealogy sprdsht w/ macro for converting data to GEDCOM format.
Excel2GED is an Excel spreadsheet with a macro for converting genealogy data into a GEDCOM-formatted text file with a '.ged' file extension. A GEDCOM file is generated by clicking the VBA-coded macro buttons 'Export' or 'Export to GEDCOM' after creating & selecting a recipient folder. That file can then be imported into a genealogy program, with family relationships already defined, BMD data included, and source notes attached. -
11
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. -
12
Flashcards - Good Plus Fast
Use Excel to create categorized flashcards and track your progress.
Use this macro-enabled Excel template to create flashcards with categories and hints. Track your progress with metrics within each category, session, term/definition, and in total. -
13
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. -
14
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... -
15
Planar Elastica
A collection of technical notes on planar elasticas and sample code
...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 elastica problems. They are described in the above note. 3. Three supplemental technical notes entitled: a.) Bend Test Models; b.) ... -
16
HP93kShmooExcel
Excel macro to display HP 93000 Shmoo
HP93000 Shmoo Excel Tools read the shmoo files in hp93000 shmoo text-file format, and show them or overlay them. -
17
Excel Toolbox
Toolbox with menu/ribbon and help - to store your own macro tools
Excel Toolbox A place to store your own excel macro's and make them easy accesable with a menu/ribbon and help page. - menu is created from a sheet/table in the addin. - ribbon is generated from sheet/table and placed in the addin. - help page, an excel sheet in the addin, user is shown a copy. -
18
Sudoku spreadsheets
Sudoku! Help to solve puzzles. Solve them for you. Generate puzzles.
Sudoku! Spreadsheets with formulas to help you solve sudoku puzzles. - simple (but large) formulas that work in both excel and oo calc. - simple (short) formulas using 2 functions in VBA / OO Calc. Excel Addin to make playing sudoku in excel easier. - macros to mark cells, test your solution, erase the solution. - macro to help you solve the puzzle by giving hints, or even the answer. Version 1.4 of the addin can also generate puzzles for you. ... -
19
Excel link finder
Find external links quickly with this macro
External links can slow a workbook down on opening or recalculating and missing links will affect formulas. Data - Edit Links will not always give sufficient information for you to identify a link. Let this macro find them quickly for you. Every link found is listed on a worksheet. No other changes are made to your workbook. Finds linked formulas, names, objects, shapes, chart sheets, data validation and conditional formatting. -
20
PilotGenerator
Macro VBA générant des feuilles de pilote à partir d'un planning
PilotGenerator génère des feuilles de pilote, permettant de visualiser les employés présents sur différents postes pour chaque journée. Prend en entrée un planning avec les horaires d'arrivée et de départ de chaque employé. -
21
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. -
22
pyspread
Python spreadsheet application
Pyspread is a non-traditional spreadsheet application that is based on and written in the programming language Python. The goal of pyspread is to be the most pythonic spreadsheet. Pyspread expects Python expressions in its grid cells, which makes a spreadsheet specific language obsolete. Each cell returns a Python object that can be accessed from other cells. These objects can represent anything including lists or matrices. Dependencies + Python (>=2.7, <3.0) + numpy... -
23
RFC SAT Macro Excel
Macro en Excel que calcula RFC con homoclave
Esta es una macro en Excel que fue diseñada para calcular el RFC con homoclave. Se incluye el archivo XLSM (macro excel) y el código de la macro en TXT. -
24
This project aims to recreate IBM DDS Debugging Template form (GX21-7717-3) for AS/400 using Microsoft Excel including VBA macro for automation. The project also includes AS/400 Data description specification (SX41-9891-00 UM/050*)
-
25
Quick Query Tool for Siebel DB
Excel-based macro to query Siebel database and store results.
A *really* simple Excel based macro execute SQL queries and store results in the workbook. Useful for quick queries, that need back and forth between Siebel application and database. Useless if you are already having SQL Developer, TOAD or some such tool.
