Senior Internship - Week 4 Progress Report

Hours Worked: 19

Total Hours: 57

Last week I had expected to create a data structure that would allow me to best format and use input data for the construction of the scheduling application. I knew this would be a hard process and expected to use python to do this. However, I did not end up using python at all. I used VBA and additional excel sheets within my workbook to reformat the data. I found this method to be easier and more lightweight as I have yet again avoided introducing python into the program. Ease of use of the scheduling is a big factor in its success since this will be used by my manager.

The main issue I encountered this week was on Tuesday when - while finishing up the construction logic for my 'summary' sheet - I found myself struggling to comprehend how to best use VBA's dictionaries to store data that can later be dumped into cells. I ended up watching a tutorial on VBA for about an hour and rewrote my summary script from scratch. This wasn't a big deal, though, because I preferred understanding my code than praying it did what I wanted.

Next week I hope to put the scheduling program on pause and to begin using python to create the class account password tool. I want to make it read a csv so I will first create a prototype.