The reports that are exported through Fusion Ops often times have several layers of information at the top that are not necessary and have to be reformatted before we can manipulate the data. For example, there are always four rows at the top that simply describe the report, the first thing I do whenever I open a report is delete these unnecessary rows.
Additionally, there are a couple of column headers that contain multiple rows of information. On the Productions Report, for example, there is a section for Quality that has a row that says "QTY" and below it the cells for the different types of waste are noted. The same is true for parameters and average pieces per hour. I have to delete and merge these headers in order to run pivot tables or filters on the data. Once these reformatting tasks are done I can very easily get the data I'm looking for, but it takes time to format these reports.
