List Types of Dimensions used in each view

I am trying to write a check script that pulls out the Dimension types used and returns a list of which sheets they are on (for finding rogue dimension types used). I have got the dimension types used but am at a complete impass as to how to check which views they are used on.

I just decided to go to Excel. does anyone have a more elegant solution?