{"id":9,"date":"2007-08-04T08:06:39","date_gmt":"2007-08-04T12:06:39","guid":{"rendered":"http:\/\/blogs.law.harvard.edu\/butala\/2007\/08\/04\/week\/"},"modified":"2007-08-04T08:06:39","modified_gmt":"2007-08-04T12:06:39","slug":"week","status":"publish","type":"post","link":"https:\/\/archive.blogs.harvard.edu\/butala\/2007\/08\/04\/week\/","title":{"rendered":"week++"},"content":{"rendered":"<p>I pretty much spent this week Excelling, or at least attempting to. I created a database of all of their teleconsultation records with macros that automatically generated useful summaries whenever it was updated with session attendance logs. <\/p>\n<p>After the first day, I was impressed with how I picked up VBA so easily (I had learned some VB 6 back in high school). I had written code to separate parts of a single name, search the total attendance for duplicates, delete the repeats, and display unique names alongside counts and the dates attended. I later learned this was called a filter, and excel had this feature built in.<\/p>\n<p>Two days later, the same thing happened again. Except this time, I had programmed a pivot table. Or actually like 6 different pivot tables. Oh well, at least I know how to program in VB again.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I pretty much spent this week Excelling, or at least attempting to. I created a database of all of their teleconsultation records with macros that automatically generated useful summaries whenever it was updated with session attendance logs. After the first day, I was impressed with how I picked up VBA so easily (I had learned [&hellip;]<\/p>\n","protected":false},"author":1483,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/archive.blogs.harvard.edu\/butala\/wp-json\/wp\/v2\/posts\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/archive.blogs.harvard.edu\/butala\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/archive.blogs.harvard.edu\/butala\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/butala\/wp-json\/wp\/v2\/users\/1483"}],"replies":[{"embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/butala\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":0,"href":"https:\/\/archive.blogs.harvard.edu\/butala\/wp-json\/wp\/v2\/posts\/9\/revisions"}],"wp:attachment":[{"href":"https:\/\/archive.blogs.harvard.edu\/butala\/wp-json\/wp\/v2\/media?parent=9"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/butala\/wp-json\/wp\/v2\/categories?post=9"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/butala\/wp-json\/wp\/v2\/tags?post=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}