I’ve spent most of my time at work recently building a big ol’ database with specifications of screens. Once the structure had been completed, I needed to import all existing data (stored in an Excel spreadsheet) in to the database. I’ve build the database with a form where everything can be put in. Functionality of this form includes automatically calculating aspect ratios from width and height pixel dimensions – something that didn’t exist in the spreadsheet.
Here’s the Excel formula to calculate aspect ratios:
=(A1/GCD(A1,B1))&":"&(B1/GCD(A1,B1))
This assumes width is in A1 and height is in B1
One thing to note with this that aspect ratios of 16:10 will be displayed as 8:5. 8:5 is the correct ratio but is instead referred to as 16:10 for easier comparison against 16:9.
Thank you!