Tag Archives: Visual Basic for Applications (VBA)

Scheduling Tool

scheduling-tool-icon

Dates

Technology

Programming, Visual Basic for Applications (VBA), Microsoft Excel

Info

I developed this experimental Scheduling Tool in Excel using VBA. It displays an automated schedule, based on events & tasks. Tasks are broken down into subtasks & weighted based on various metrics (e.g. length of tasks, time till deadline). These are then slotted around events (that have fixed times), based on various metrics. The tool would readjust the schedule automatically as unforeseen incidents occurred, however as it stored intermediate values within Excel workbooks, it was slow.

Continue reading