This script works to eliminate the hassle of working with reports in excel. Many people keep a large master spreadsheet and over time add data to the master spreadsheet. This works to get rid of the manual tasks of copying and pasting data and gives you back a clean copy of the updated info.
So we first start with our raw data in our excel sheet.
From here, we want to add some calculated columns so we can get some useful numeric values.
There are also some useful info in some of our other columns, but we still need to clean up how it's formatted so we can use it. With some of our cleaned columns, we will also join this table with some of our other tables that we have.
This table is not imported with our raw data, this is a table that is created manually, so we need to be able to join this info with our raw data.
We can also print out some quick pivot tables to show our data.
This is useful, because if we create these in excel we have to worry about going back in and refreshing the data, and making sure it's picking up all the information within the table.
Lastly we want to include some type of visuals.
Currently have the visuals not all in the same figure. Want to get it to a point where we have all the visuals in one figure and export it as an image to be sent via email or some other method.