I was once again working on the VBA macro today and for the first time in forever I wasn't running into a million problems left and right. Granted, I did end up posting another StackOverflow question and that part of the code still doesn't work like I want it to, but for the most part all of the problems I came across today had solutions that were only a few google searches and different attempts away. Due to this, I made so much progress! It's starting to look like this is really going to happen, and that I'll actually be able to make a macro that does everything it needs to by Friday! I finally got it to get all the data in the correct format, put it into the Excel workbook, move over the specified data to another sheet, calculate the average and standard deviation for each hour, and then create two graphs for both the average usage and all the usage for that specific day of the week. Now I just need to automate it over the different days of the week so I get not just Monday's data and graphs, but also those for the other week days. I've made some progress towards that end, but I've still got a few kinks to work out. It's so close though!!!
This morning there was the reproducibility workshop, which Valentina led. I wish that my macro had been finished so that I could give it to another group to try and run. However, they would have to have Microsoft Access on their computer and they would need the data set we were given, so maybe it would not have worked anyways. My thoughts about the workshop were that it was a really good idea, and I thought it would help us see new issues, but in reality I don't think it was as meaningful because most of the groups didn't seem to have code that they wanted to share with the aim that it was reproducible. Instead, it seemed like the groups just chose the nearest code they could find, even though realistically the code probably wasn't made for a client or anyone else to use, and instead it was just going to be used by the creator to do some function once and then the results would be published for a larger audience.
This morning there was the reproducibility workshop, which Valentina led. I wish that my macro had been finished so that I could give it to another group to try and run. However, they would have to have Microsoft Access on their computer and they would need the data set we were given, so maybe it would not have worked anyways. My thoughts about the workshop were that it was a really good idea, and I thought it would help us see new issues, but in reality I don't think it was as meaningful because most of the groups didn't seem to have code that they wanted to share with the aim that it was reproducible. Instead, it seemed like the groups just chose the nearest code they could find, even though realistically the code probably wasn't made for a client or anyone else to use, and instead it was just going to be used by the creator to do some function once and then the results would be published for a larger audience.