The RoundRepx.xlsx Model

How to round a set of numbers so the total is unchanged.

View the model

Download the model

Given a set of numbers with fractional parts, we want to round each to a nearby integer so that the integers sum to a specified target. This problem might arise in preparing a report where numbers are rounded to fewer digits, or in choosing a number of representatives for each state in a legislature, based on population.

Keywords:

Fair Allocation | Rounding | Alabama Paradox | Proportional Representation |