Hacked this out this morning while shopping for laptops. Hope it’s of help, cause I sure had problems dusting off old algebra skills while learning how to punch in excel formulas.
Basically you type in diagonal size and aspect ratio (4:3, 16:9 or 16:10). It spits out the horizontal and vertical size of the screen.
Also calculates how a 16:9 movie would show on a 4:3 screen.
Files in openoffice and excel95 format. Files hosted by filefactory, seems to work.
Excel: http://www.filefactory.com/file/bad9a9/
Openoffice: http://www.filefactory.com/file/baa2d9/