Example Excel Workbooks Using Macros
The following workbooks are all examples of my work, demonstrating a variety of diverse tasks that can be solved with Excel. All of these workbooks contain VBA macros, allowing complex functionality with simple usability.
They are all easy to enhance or restructure to match more complex or specific requirements. Often minor changes to formatting allow a workbook to be applied to a similar problem in a different field.
| Directory Lister |
Lists all of the files in a chosen directory. Lots of options such as choosing the file types to include or exclude, search sub-directories. Can specify output formatting of the list e.g. full path, partial path, uppercase etc. This is a great tool when requiring a list of files e.g. preparing a release note for a software project, or finding all graphic files on a computer. Scans over 1000 files per second. |
| Data Grouping |
Allows ad-hoc reports to be created out of data sheets by grouping like data together. For example, can group by Region, Sales Person and Product and see sub-totals for each. Column order can be changed easily to change the order of grouping. Formatting can be set by the user. This is similiar to a pivot table but easier to understand and summarise. |
| Sales Map |
Graphically displays the sales of various products onto a map of Europe to display the sales per product, per year, per city. The user can select which years, products and cities are displayed to customise the map and analyse the data. |
| Matrix Depth Viewer |
Given a 3D matrix, clicking on any cell displays the values of all the same cells through the depth of the matrix in a 3D type manner. The most recent results are at the font, fading to the oldest results at the rear. |
| Password Generator |
Creates random passwords following options provided by the user e.g. length, use upper/lower case, punctuation, numbers. Also provides details on the strength of the created password and its theoretical resistance to a brute force attack. |
| Matrix Viewer |
Given a 3D matrix, clicking on any cell displays the values of all the same cells through the depth of the matrix. Each value is shown on a bar chart depicting its relative size. This allow quick comparisons over multiple time slots. |
| Data Matrix Analyzer |
Allows the analysis of monthly rainfall for many locations, allowing a comparison between 2 years, using colour coding of the matrix to show changes over time. Easily adaptable to other 3D data problems. |