{"id":187,"date":"2016-03-03T21:27:22","date_gmt":"2016-03-03T21:27:22","guid":{"rendered":"http:\/\/marco-krapf.de\/?page_id=187"},"modified":"2024-12-31T18:03:41","modified_gmt":"2024-12-31T17:03:41","slug":"excel","status":"publish","type":"page","link":"https:\/\/marco-krapf.de\/gb\/excel\/","title":{"rendered":"Excel Tools"},"content":{"rendered":"
Microsoft Excel Tools<\/span>Add-in xl DuplikatManager<\/span>Add-in xl PairCompare<\/span>Add-in XL export<\/span>Add-in ELPHIN Toolbox<\/span>GaloppSim<\/span>Add-in AddIn-Man<\/span>Add-in Add-in Code Counter<\/span>Add-in ONE CELL MODE<\/span><\/div>
\n

Microsoft Excel Tools<\/h1>\n

\"\"\"\"\"\"\"\"\"\" \"\"\"\"\"\"<\/p>\n

All tools are developed and maintained with private effort and provided for free download. I would be very happy about a small donation to t<\/span>his foundation for sick children in the region of Heilbronn\/Germany. Read more on the website of the foundation<\/a>.<\/p>\n

\"\"<\/p>\n<\/div>\n

\n

Add-in xl DuplikatManager<\/h1>\n

\"Download<\/p>\n

Open source tool for finding, deleting and exporting duplicates in an Excel worksheet with lots of extra features.<\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>xlDuplikatManager_v2.0<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
GUI languages<\/td>German, English<\/td>\n<\/tr>\n
Where is the add-in after activation?<\/td>\"Data\" tab, next to the \"Data tools\" group<\/td>\n<\/tr>\n
File size<\/td>538 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>3425<\/td>\n<\/tr>\n
Source lines of code<\/td>2166<\/td>\n<\/tr>\n
Comment lines of code<\/td>574<\/td>\n<\/tr>\n
Blank lines<\/td>685<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor as there is no password protection.<\/p>\n

Installation<\/strong>
\nThe tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> the tool\u00b4s icon is added on the “Data” tab next to the “Data tools” group.<\/p>\n

Automatic installation (recommended for Windows)<\/strong>
\n\n\txl DuplikatManager\t(5117 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Manual installation<\/strong>
\n\n\txl DuplikatManager\t(5510 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Features<\/strong>
\n– Selection of multiple ranges on the worksheet while holding down the Ctrl key
\n<\/span>– Two search modes: consider each selected area separately or merge non-contiguous columns
\n<\/span>– Ignore upper\/lower-case letters and\/or blanks for the search if needed
\n<\/span>– Coloured highlighting of duplicates, unique values or all different values
\n<\/span>– Output duplicates, unique values or all different values<\/span> \u200b\u200bon a new worksheet (optionally the entire rows)
\n<\/span>– Different deletion modes: only duplicates, complete lines, with and without compression (also in combination)
\n<\/span>– Restoration of deleted duplicates possible
\n<\/span>– Jump to individual duplicates with delete and restore function
\n<\/span>– Non-destructive processing (the original content can be restored until a new area is selected or the tool is shut down)
\n<\/span>– Permanent display of the number of duplicates, unique values, different values \u200b\u200band deleted duplicates
\n<\/span>– Integrated quick guide with pictures, tips and examples
\n<\/span>– The tool language can be switched between German and English<\/span><\/span><\/p>\nngg_shortcode_0_placeholder<\/div>\n

\n

Add-in xl PairCompare<\/h1>\n

\"\"<\/p>\n

Open source tool for comparing two selected areas and searching for data record pairs on a worksheet.<\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>xlPairCompareV1P1.xlam<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface languages<\/td>German, English<\/td>\n<\/tr>\n
Where is the add-in after activation?<\/td>\"Data\" tab, next to the \"Data tools\" group<\/td>\n<\/tr>\n
File size<\/td>289 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>3174<\/td>\n<\/tr>\n
Source lines of code<\/td>2271<\/td>\n<\/tr>\n
Comment lines of code<\/td>365<\/td>\n<\/tr>\n
Blank lines<\/td>538<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor.<\/p>\n

Installation
\n<\/strong>The tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> the tool\u00b4s icon is added on the “Data” tab next to the “Data tools” group.<\/p>\n

Automatic installation (recommended for Windows)<\/strong>
\n\n\txl PairCompare\t(4642 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Manual installation<\/strong>
\n\n\txl PairCompare\t(12393 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Videos<\/strong>
\nTrailer (1:32)<\/a>
\nVideo tutorial: Demonstration of the features (German) (8:05)<\/a><\/p>\n

Features<\/strong>
\n– Finding value pairs, i.e. data records that occur in both selected areas
\n– Highlighting of single values and\/or value pairs on the worksheet
\n– Visualise data record pairs on the worksheet
\n– Output of detected single values and\/or value pairs on the worksheet
\n– Removing critical characters such as control characters possible
\n– Ignore lower\/upper-case letters and\/or spaces possible when comparing
\n– Quick selection of the areas possible by automatically marking adjacent cells
\n– GUI can be switched between English and German<\/p>\nngg_shortcode_1_placeholder<\/div>\n

\n

Add-in XL export<\/h1>\n

\"\"<\/p>\n

Open source tool for exporting worksheet content to a text or CSV file with lots of special features.<\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>XL_export_v1-0.xlam<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface languages<\/td>German, English<\/td>\n<\/tr>\n
Where is the add-in after activation?<\/td>\"Data\" tab, next to the \"Data tools\" group<\/td>\n<\/tr>\n
File size<\/td>180 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>1226<\/td>\n<\/tr>\n
Source lines of code<\/td>923<\/td>\n<\/tr>\n
Comment lines of code<\/td>122<\/td>\n<\/tr>\n
Blank lines<\/td>181<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor.<\/p>\n

Installation<\/strong>
\nThe tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> the tool\u00b4s icon is added on the “Data” tab next to the “Data tools” group.<\/p>\n

Automatic installation (recommended for Windows)<\/strong>
\n\n\tXL export\t(4673 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Manual installation<\/strong>
\n\n\tXL export\t(4633 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Features<\/strong>
\n– Choice of the area to be exported
\n– Export as text file, CSV or custom file type
\n– Free choice of delimiter
\n– Delimiter at the end of a row can be deleted
\n– Unnecessary spaces can be deleted
\n– Control characters can be deleted
\n– Conversion to upper-case or lower-case letters possible
\n– Preview of the export file
\n– Automatically saving the tool settings<\/p>\nngg_shortcode_2_placeholder<\/div>\n

\n

Add-in ELPHIN Toolbox<\/h1>\n

\"\"<\/p>\n

Open source tool that adds an extra ribbon tab which provides extended functions for Microsoft Excel.<\/p>\n

The ELPHIN Toolbox is named after the little crofting community of Elphin which can be found in the south west Sutherland area of the Scottish Highlands.<\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>ELPHIN_Toolbox.xlam<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface language<\/td>English, German<\/td>\n<\/tr>\n
Where is the add-in after activation in the AI edition?<\/td>New menu strip tab \"ELPHIN Toolbox\"<\/td>\n<\/tr>\n
File size<\/td>300 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>2911<\/td>\n<\/tr>\n
Source lines of code<\/td>1958<\/td>\n<\/tr>\n
Comment lines of code<\/td>480<\/td>\n<\/tr>\n
Blank lines<\/td>473<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor as there is no password protection.<\/p>\n

Installation<\/strong>
\nThe tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> the toolbox is inserted into the Excel menu strip as a new tab “ELPHIN Toolbox”.<\/p>\n

Automatische Installation (empfohlen f\u00fcr Windows)<\/strong>
\n\n\tELPHIN Toolbox\t(5052 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Manuelle Installation<\/strong>
\n\n\tELPHIN Toolbox\t(5192 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Features<\/strong>
\n– Convert all letters to upper-case letters (as value or function)
\n– Convert all letters to lower-case letters (as value or function)
\n– Capitalize each word (as value or function)
\n– Remove all spaces at the beginning of a cell (as value)
\n– Remove all spaces at the end of a cell (as value)
\n– Remove all spaces at the beginning and the end of the cell (as value)
\n– Remove multiple spaces (as value or function)
\n– Check the selected cells for non-breaking spaces
\n– Replace non-breaking spaces in the selected cells
\n– Check the selected cells for non-printing control characters
\n– Remove control characters in the selected cells
\n– Absolute value of a real number (as value or function)
\n– Convert the result of a formula or function to a value
\n– Hide formula result zero (0)
\n– Remove empty rows or columns
\n– Memorize row or colum nnumber
\n– Compare worksheets
\n– SG DataSet Finder for finding matching data records across different Excel files
\n– Undo option can be deactivated for performance improvement
\n– GUI languages: English and German<\/p>\n

<\/p>\n<\/div>\n

\n

GaloppSim<\/h1>\n

\"\"<\/p>\n

Open source horse racing simulator for Microsoft Excel in two editions: AI (Add-in) and RS (Run Simple \u2013 Excel workbook with macros).
\n<\/strong><\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>GaloppSim.xlam (AI edition)
\nGaloppSim.xlsm (RS edition)<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface language<\/td>English, German<\/td>\n<\/tr>\n
Where is the add-in after activation in the AI edition?<\/td>New menu strip tab GALOPPSIM<\/td>\n<\/tr>\n
File size<\/td>3.84 MB (AI edition)
\n3.77 MB (RS edition)<\/td>\n<\/tr>\n
Lines of code (total)<\/td>15103<\/td>\n<\/tr>\n
Source lines of code<\/td>11344<\/td>\n<\/tr>\n
Comment lines of code<\/td>1528<\/td>\n<\/tr>\n
Blank lines<\/td>2231<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor.<\/p>\n

Installation<\/strong>
\nThe tool is delivered in two editions. The AI edition is an Excel Add-in (.xlam) which, after installation and activation<\/a>, is inserted into the Excel menu strip as a new tab “GALOPPSIM” and is then available in every Excel instance.
\nThe RS edition is an Excel workbook with macros (.xlsm) which does not need to be installes. All you need to do is open the file and allow running macros (Run Simple).<\/p>\n

Run Simple – No installation<\/strong>
\n\n\tGaloppSim - RS edition\t(3281 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Add-in – Manual installation<\/strong>
\n\n\tGaloppSim - AI edition\t(3345 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Features<\/strong>
\n– 32 races to choose including a race on a snow track, a race in the Wadden Sea, a fine dust race, a pig race, a deer race, a camel race in the desert, a vole race, a race in outer space (including alien attacks) and a race with coronavirus tests
\n– 141 different racing tactics
\n– Six betting types (Win, Show, 2 sur 4, Exacta, Trifecta, Superfecta)
\n– Graphical elements along the track (tribunes, buildings, trees, food and beverage etc.)
\n– Advertising on the track
\n– Race specific options, depending on the race (fine dust slider, sand dust switch, water splash switch, water level and lugworm sliders, mouse hole slider, road crossing, police car, planet selection, alien switch and kidnapping likelikood sliders…)
\n– Three camera modes including Focused Run (where the camera has one selected horse in focus during the race)
\n– Starting procedure with fixed or random starting box drawing<\/span><\/span><\/span>
\n– Horse can refuse to run
\n– Hoof prints
\n– Race Speed Monitor (Speed and Distance mode)
\n– Momentum display (relative speed of each horse compared to the others) with speed bars or icons
\n– Race recorder wth replay, save and load buttons
\n– Race info in a pop-up or on the worksheet
\n– Photo finish
\n– Tactics revelation option
\n– Race speed from normal to 5 times faster
\n– Seven colour modes including Dark Mode, black-and-white and PopArt
\n– Voice output possible for some information
\n– Pixel movie showing the initial idea of the horse racing simulator
\n– Auto zoom function for perfect fit on all screens
\n– Various Excel options selectable
\n– Super Developer Tools including Test Automation and Machine Learning mode for Data Scientists
\n– GUI languages: English and German<\/p>\n

Screenshots (Add-in)<\/strong><\/p>\nngg_shortcode_3_placeholderScreenshots (Run Simple)<\/strong><\/p>\nngg_shortcode_4_placeholderAdvertising
\n<\/strong>For a donation to the foundation “Gro\u00dfe Hilfe f\u00fcr kleine Helden”, it is possible to place advertisements for certain races, which will then be displayed in all subsequent versions. The editor to create the advertisement and calculate the advertising costs can be downloaded here:<\/p>\n

\n\tAdvertising editor\t(5539 downloads\t)\n<\/a>\n<\/h3>\n

Excluded from the publication are politically incorrect, morally indecent ads etc.<\/p>\n

\"\"<\/p>\n<\/div>\n

\n

Add-in AddIn-Man<\/h1>\n

\"\"<\/p>\n

Open source tool for comfortable opening the default folder for Microsoft Office add-ins and launching the Excel add-in manager.<\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>AddIn-Man.xlam<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface language<\/td>Deutsch<\/td>\n<\/tr>\n
Where is the add-in after activation?<\/td>\"Home\" tab, new group \"AddIn-Man\"<\/td>\n<\/tr>\n
File size<\/td>68 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>25<\/td>\n<\/tr>\n
Source lines of code<\/td>10<\/td>\n<\/tr>\n
Comment lines of code<\/td>12<\/td>\n<\/tr>\n
Blank lines<\/td>3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor.<\/p>\n

Installation<\/strong>
\nThe tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> a new group “AddIn-Man” is added to the “Home” tab.<\/p>\n

Automatic installation (recommended for Windows)<\/strong>
\n\n\tAddIn-Man\t(5071 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Manual installation<\/strong>
\n\n\tAddIn-Man\t(5115 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Features<\/strong>
\n– Button for opening the default folder for Microsoft Office add-ins in the Windows Explorer
\n– Button for launching the Excel add-in manager<\/p>\nngg_shortcode_5_placeholder<\/div>\n

\n

Add-in Add-in Code Counter<\/h1>\n

\"\"<\/p>\n

Open source tool for counting the lines of code in Excel Add-ins (.xlam)<\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>Addin-CodeCounter.xlam<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface language<\/td>English<\/td>\n<\/tr>\n
Where is the add-in after activation?<\/td>\"Developer\" tab, new group \"Add-in Code Counter\"<\/td>\n<\/tr>\n
File size<\/td>27 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>258<\/td>\n<\/tr>\n
Source lines of code<\/td>190<\/td>\n<\/tr>\n
Comment lines of code<\/td>27<\/td>\n<\/tr>\n
Blank lines<\/td>41<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor.<\/p>\n

Installation<\/strong>
\nThe tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> a new group “Add-in Code Counter” is added to the “Developer” tab.<\/p>\n

Automatic installation (recommended for Windows)<\/strong>
\n\n\tCode Counter\t(4628 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Manual installation<\/strong>
\n\n\tCode Counter\t(4653 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Features<\/strong>
\n– Counting lines of code (active source code, comment lines, blank lines, total lines) of a whole VBA project
\n– Optional: Counting lines of code of each component of the VBA Project individually, such as modules, class modules, user forms and worksheets
\n– Optional: Writing the results to a plain text file<\/p>\nngg_shortcode_6_placeholder<\/div>\n

\n

Add-in ONE CELL MODE<\/h1>\n

\"\"<\/p>\n

Completely useless open source tool for merging all cells of an Excel worksheet. Coded on urgent request for a highly esteemed colleague who has the steady desire for merging cells.<\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>ONECELL10.xlam<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface language<\/td>English<\/td>\n<\/tr>\n
Where is the add-in after activation?<\/td>New tab \"Absolute Beginner Add-ins\"<\/td>\n<\/tr>\n
File size<\/td>24 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>13<\/td>\n<\/tr>\n
Source lines of code<\/td>12<\/td>\n<\/tr>\n
Comment lines of code<\/td>0<\/td>\n<\/tr>\n
Blank lines<\/td>1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor.<\/p>\n

Installation<\/strong>
\nThe tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> the tool\u00b4s icon is added on the new ribbon tab “Absolute Beginner Add-ins”.<\/p>\n

Automatic installation (recommended for Windows)<\/strong>
\n\n\tONE CELL MODE\t(4499 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Manual installation<\/strong>
\n\n\tONE CELL MODE\t(4321 downloads\t)\n<\/a>\n<\/strong><\/p>\n

Features<\/strong>
\n– Merging all cells of an Excel worksheet, so that there will be only one cell left (A1)<\/p>\nngg_shortcode_7_placeholder<\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-187","page","type-page","status-publish","hentry"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"gb","enabled_languages":["de","gb"],"languages":{"de":{"title":true,"content":true,"excerpt":false},"gb":{"title":true,"content":true,"excerpt":false}}},"_links":{"self":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/comments?post=187"}],"version-history":[{"count":228,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/187\/revisions"}],"predecessor-version":[{"id":3351,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/187\/revisions\/3351"}],"wp:attachment":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/media?parent=187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}