Sheet scale from view scale macro

I would like help in developing a macro to evaluate the views on a sheet, populate the sheet scale with the most common view scale, then change those view scales to match the sheet scales.

SolidworksApi macros