It is difficult to calculate these values manually and while calculators make it easier, Excel is the preferred tool for finding these values over a range of cells.

You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.