Search Results for "excel macro"
Sort By:
Showing 40 open source projects for "excel macro"
View related business solutions-
Total Network Visibility for Network Engineers and IT ManagersThis means every device on your network, and every interface on every device is automatically analyzed for performance, errors, QoS, and configuration.
-
InEight is a leader in construction project controls softwareMinimize risks, gain operational efficiency, control project costs, and make confident, informed decisions. InEight software has your back during every stage of construction, from accurate pre-planning to predictable execution and completion. When project teams collaborate effectively, every decision is backed by precise, authoritative insights.
-
1
Accouting Excel
Accounts32.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. PLEASE READ AccountingExcelReadMe.txt file or Guide menu in main menu of this Application to work with it. [2025] [Asis Kumar Goswami] akgbest77@yahoo.com -
2
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. -
3
SchoolManagement
SchoolMag is a free and opensource ANY PASSWORD CAN OPEN IT
SchoolMag is a free and opensource msexcel vba standard software for management of school. ANY PASSWORD CAN OPEN IT. Create a folder SchoolMaG1.4 in c drive of your pc and there extract the file SchoolMag1.4.zip. First go to excel option Trust Centre, trust centre 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. ... -
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. ... -
Thinkific is a leading platform for creating, marketing, and selling courses, digital products, communities and learning experiences.Create online courses, digital products, and communities that actually sell. An all-in-one solution for building your dream learning business.
-
5
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. -
6
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. -
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
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. -
9
DAPS4
A Fortran code for design and analysis of ring-stiffened shells
... • Ring-Frame Elastic Instability analysis (EFI). Solutions compare favorably with DTMB experimental results. DAPS4e’s IO is managed through a Visual Basic user form. Pre/post processing is done using linked macro-enabled Excel workbooks. The file DAPS4e.zip includes: • DAPS4e.5 executable and Fortran 77/95 source code. • Visual Basic user form and its 2017 Visual Studio project code. • Excel spreadsheet pre/post processors. • Technical documentation -
Knowledge Is The Cornerstone Of Your Business.MentorCity is a comprehensive and intuitive online mentoring software cultivating the future of organizations and individuals through the power of connections and relationships. Specifically created for associations, companies, and schools, MentorCity assists in member engagement, leadership development, succession planning, and diversity and inclusion strategies. Serving as a powerful personal development tool, MentorCity helps organizations save time and money by lessening matching responsibilities and allowing program administrator to focus their efforts on building a mentoring culture that achieves exceptional results.
-
10
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. -
11
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. -
12
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. -
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.
