Excel VBA Script to convert VCF file with multiple entries to CSV file
This is an Excel based VBA script used to import bulk .VCF files that contain more than 1 Vcard and then convert them to a comma separated .CSV file or Excel xls file that can then be imported into Outlook, Google, or any other application that supports import of contacts using CSV files. This has been written to support VCF 2.0, 2.1, 3.0 and 4.0 formatted files including those with printable encoding (MIME) and has been tested with bulk VCF files from Backupify, Google Contacts (Gmail...
A small tool for optimization of complex problems.
This is a Particle Swarm Optimization tool written in VBA for Excel. It is easy to modify in order to enable the users to code their own objective function, constraints and way to handle constraints. Published under licence CC-BY-SA 4.0
Relationship Visualizer - Convert Excel data into Graphviz graphs
Collect data in Excel and have the Graphviz graphing engine draw the data connections without ever leaving Excel. The combination of these two tools makes it easy to quickly visualize complex data relationships. A “data” worksheet allows you to collect item and relationship data using Excel’s familiar table format. A "styles" worksheet lets you create named styles for visual attributes. Styles can be associated to rows in the "data" worksheet, and collected into views. A “graph” worksheet...
Excel Telefon Rehberini Cep Telefonuna Aktarma
Türkçe and English Version * Programın bulunduğu dizinde, rehberiniz.vcf olarak dosya oluşturmaktadır. * Oluşan rehberiniz.vcf dosyayı cep telefonunuza mail olarak gönderiniz. * Cep telefonundan gelen maili açıp, eklentileri seçip, Önizle deyin. (İlgili program seçimi çıkar ise Rehber i seçin) * Çıkan listeden Cihaz ı seçerek aktarımı tamamlayın. Eklenecek resim foto boyutları 200x200 olmalıdır. English; * In the directory where the program is found, the file is created as...
Essential Excel Add-In is a Microsoft Excel Add-In, written in VBA, that contains useful User Defined Functions (UDFs) and macros to performs a number of different tasks that either Excel does not provide (Regular Expressions (RegEx), improved VLookUp).
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 purpose...
Excel KPI Dashboard
> KPI Spreadsheet Dashboard > Create KPI structure, define targets and control the performance of your company > Build Strategy, create Action Plan to achieve the objectives and set up deadlines. > Assign KPI to managers and control their performance. > Analyze each of the KPI and compare with the targets defined, change the period as you want. > Build your customized KPI Dashboard by selecting the best structure analysis.
Populates dates, higlights business days and fiscal month start dates.
Fiscal Calendar in Excel generates an elegant calendar based on the year you type into cell J1, with July 1 being the first day of the fiscal year. The fiscal month begins on the last Monday of the previous month with a full work week (5 days). For example, the Monday ten days before Thanksgiving will be the first week of fiscal month December (November 13 in 2017). Fiscal Calendar in Excel allows you highlight certain business days each month and it'll highlight holidays every year. If you...
XLW is a C++ wrapper for the Excel C API described in the Microsoft Excel 97 Developer's Kit. It makes xll programming automatic. Its powerful interface will empower your C, C# or C++ numerics by embedding them in Excel just like the built-in functions.
An open source Solver-compatible optimization engine for Microsoft Excel on Windows and Mac using the Coin-OR CBC linear and integer programming optimizer. You can also use other solvers like Gurobi (if you have it installed), solvers on the NEOS cloud, and various non-linear solvers are supported too.
Performs a cell-by-cell comparison of Excel Worksheets.
Spreadsheet Compare (Excel compare) is a Microsoft Excel Add-In, written in VBA, that performs a cell-by-cell comparison of Worksheets within the same or different Workbooks. Requires Excel 2000 or later. Check out the Home Page for more info!
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
Extends Project to export Excel report, audit the schedule and more...
This Microsoft Project add-in includes over 20 features for MS Project 2013 and 2016. You'll be able to see the full chain of predecessor tasks based on the current task, audit your schedule based on industry best practices, see all tasks coming up in the next "x" weeks. This add-in also gives you the power to export a report of your entire project into Microsoft Excel with dates, dates and time, filters, and to see a "Who Does What When" table.
VBA add-ins which convert Microsoft Office contents to textile/HTML
This project provides VBA add-ins which convert Microsoft Office contents to textile or HTML format. Currently the following two VBA add-ins are ready. * xls2textile: Excel to Textile/HTML * ppt2textile: PowerPoint to Textile 2017/1/11: Fixed the Download button to link the latest version.
Quick column reference for Excel® VBA programming
This is a simple program for Excel® VBA programmers. It provides a quick column name/number conversion. For instance, if you want to use a Cells(row, column) reference, you need to know the column number. Type the column name (for instance "CN") in the Input box. Output will display the column number (92). Conversely, if you are working on your code and want to know what column it refers to in the spreadsheet, type the column number in the Input box (for instance 456). Output will display...
Create graphviz diagrams with excel
Free, easy to use, excel tool to create data and process flow diagrams with table data In separate excel sheets you define items(nodes), lines(edges) and grouping(clusters) Separate definition of node, edge and cluster styles Graph settings sheet Output control sheet Examples and readme are included in the zip file Get it working: -Install graphviz (http://graphviz.org/Download.php) -Download Excel to Graphviz -Open one of the ExcelToGraphviz workbooks -Go to sheet settings and update...
EXCEL VBA chess engine with chess board
VBA chess engine for EXCEL / WORD / POWERPOINT ( level: 2200 ELO ) with chess board GUI. Full EXCEL install needed (no viewers or OpenOffice) also: VisualBasic 6 compile for winboard (2750 ELO), needs a chess GUI like ARENA latest version here: https://github.com/RZulu54/ChessBrainVB/releases
A small but powerfull application For mass devices config & backup
Mass Config A small but powerfull excel application For mass devices configuration / backup, can use also to send configuration / commands to Linux server This is an open source application Tested with: - network device - cisco,nortel and juniper - Operetion systems - Debian linux uses telnet / SSH to connect to devices, for every device from the list, you can set the commands to send All devices output is saved in the 'Output' directory, you can load this output data to the excel Please let...
Fan made Conan RPG 2d20 by Modiphius Spreadsheet. If you are a skilled Excel programmer and you are interrested in helping with the project do not hesitate to contact me at email@example.com .
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.
Le but du projet est d'implanter les fonctions modbus tcp en VBA de façon a les utiliser dans excel. Le projet pourra par la suite communiquer en modbus RTU
JETT - Java Excel Template Translator
JETT is a Java 5.0 API that reads an Excel spreadsheet as a template, takes your data, and creates a new Excel spreadsheet that contains your data, formatted as in the template. It works with .xls and .xlsx template spreadsheets.
KelimeBulur - Kelimelik, Scrable yardımcısı
Kelimelik ve Scrable tarzı oyunlarda yardımcı olarak kullanabileceğiniz excel programıdır. Excel 2010 da test edilmiştir. Detaylı kullanım yardımıcı programın içinde resimli olarak anlatılmıştır. ** Çoklu oyuncu desteği vardır. **** HARF TABLOSU **** kaç adet olduğunu, kaç adet kullanıldığını, kaç adet kaldığını her bir harfin puanını görebilir siniz. **** ÖZEL KELİME BULMA **** j* J ile başlayanlar *J J ile bitenler *J* J içerenler ?J İkinci harfi J olanlar ??J...
Excel genealogy sprdsht w/ macro for converting data to gedcom format.
Excel genealogy spreadsheet with macro for converting data to gedcom format. Unlike other similar Excel2gedcom converters, family relationships are preserved .GEDCOM generation is initiated with a push of a VBA coded macro button. Spreadsheet protection password = "x2g" Current bug shows all children under last spouse. If you find this to be the case, for now, enter only one partner and fix the problem in your genealogy software. For a man with multiple wives having children with each, enter...
Consolidate your Bill of Materials
KiCAD BOM Excel Add-In used to consolidate BOM (Bill of Materials) generated by KiCAD. This page is no longer up-to-date. You can find the latest version http://www.cybercircuits.co.nz/web/kicad-excel-addin-consolidate-bill-of-materials If you are looking for this Add-in bundled with KiCad in a Portable package please see https://sourceforge.net/projects/kicad4-portable/ Known Issues: Microsoft Office 2010 on a computer running Windows 7 will report an invalid signature. Since version 2.1...