Pinned Repositories
AutoChess
A very basic engine for something like Teamfight Tactics; using this to build an actual game would be a decent project. Has very basic AI units with HP bars under them.
Button-Movement
A short VBA program that lets you move a little guy around a map using buttons.
DetectPlagiarism
A set of macros made to detect plagiarism in student submissions. Converts .docx, .pdf, and .xlsm files to .txt, and then checks for recurring lines of code, with a whitelist, using a dictionary-based approach for speed. It expects a master folder containing one folder per student.
Hall_of_Fame
The most impressive VBA projects I received over the years.
ImageMovement
A short code that adds an image to the sheet and moves it around.
InOrOut
A macro that wins at a topological game. Heavy use of recursion.
ITB-ModLoader
A lua-based mod loader for the game Into the Breach
VBA-2048
A working game of 2048 in VBA. Uses a cute trick with fonts to avoid merging things twice in one move. For Skema students, this is post-session 6.
VBA-Game-Boggle
A short "game" of Boggle. Doesn't actually let you play the game, but it generates a random 4x4 grid of letters and finds all valid words in a given language (well, only two languages). Uses recursion. For Skema students, this code is post-session 6, and it uses a session 8 notion.
VBA-Game-Snake
A short game of Snake I coded in about an hour to showcase the .OnKey and .OnTime methods. Uses either collections or arrays.
Metalocif's Repositories
Metalocif/VBA-Game-Snake
A short game of Snake I coded in about an hour to showcase the .OnKey and .OnTime methods. Uses either collections or arrays.
Metalocif/ImageMovement
A short code that adds an image to the sheet and moves it around.
Metalocif/VBA-2048
A working game of 2048 in VBA. Uses a cute trick with fonts to avoid merging things twice in one move. For Skema students, this is post-session 6.
Metalocif/VBA-Game-Boggle
A short "game" of Boggle. Doesn't actually let you play the game, but it generates a random 4x4 grid of letters and finds all valid words in a given language (well, only two languages). Uses recursion. For Skema students, this code is post-session 6, and it uses a session 8 notion.
Metalocif/AutoChess
A very basic engine for something like Teamfight Tactics; using this to build an actual game would be a decent project. Has very basic AI units with HP bars under them.
Metalocif/Button-Movement
A short VBA program that lets you move a little guy around a map using buttons.
Metalocif/DetectPlagiarism
A set of macros made to detect plagiarism in student submissions. Converts .docx, .pdf, and .xlsm files to .txt, and then checks for recurring lines of code, with a whitelist, using a dictionary-based approach for speed. It expects a master folder containing one folder per student.
Metalocif/Hall_of_Fame
The most impressive VBA projects I received over the years.
Metalocif/InOrOut
A macro that wins at a topological game. Heavy use of recursion.
Metalocif/ITB-ModLoader
A lua-based mod loader for the game Into the Breach
Metalocif/RotatingLabyrinth
A macro that finds the shortest path through a labyrinth, with a twist: you can rotate the "walls" in all individual cells at once. The shortest path is not measured by the number of cells crossed, but by the number of rotations. Uses recursion, dictionaries, and implements a graph for the pathfinding.
Metalocif/VBA-Attestation-Maker
Makes attestations based on a Word and information in an Excel file, then saves them as PDFs.
Metalocif/Meta-s-Mods
A collection of mods for Into the Breach by Metalocif.
Metalocif/StS_VBA
A VBA clone of the excellent game Slay the Spire, which you can play within Excel. Should work fine on both PC and Mac. Heavily commented but messy code.
Metalocif/VBA-Game-Alien
A game about an alien moving around space, with objects that can be interacted with. Could be shorter and nicer, but I wanted it to be simple. For Skema students, this is post-session 3.
Metalocif/VBA-Game-Mahjong
A game of Mahjong playable in Excel. Run the macro and click a pair of tiles to play. Uses an array of 2D arrays to represent the pyramid of tiles.
Metalocif/VBA-Game-Minesweeper
A short game of Minesweeper I coded to mess with recursion. For Skema students, this is post-session 6.
Metalocif/VBA-Line-of-Sight
A quick implementation of a line of sight system in VBA (revealing cells around a central position, with possible obstructions). For Skema students, this is post-session 3.
Metalocif/VBA-Pig-Latin
A short exercise: given a sentence, for each word, take its first letter, put it to the end of the word, and append "ay". Punctuation should be unaffected. Because of that last part, this requires dictionaries.
Metalocif/VBA-World-Map
A cute, RPG-style map, made from pictures and predefined fill patterns. For Skema students, this is post-session 6.
Metalocif/Vextra
Vek + Extra