CompModel Speed Comparison

We were curious just how much faster it is to create a compensation model in CompModel versus a traditional spreadsheet. Here's our test.

Traditional spreadsheet

1. Gather source data into one worksheet
   (10 minutes)


2. Increase current pay ranges by 2.9% using formulas in new columns
   (5 minutes)


3. Create formulas in new columns to check for employees that fall below the minimum of the new pay ranges
   (5 minutes)


4. Create formulas in new columns to increase all employees pay by 4.0% without having pay increase beyond the range maximum
   (5 minutes)


5. Create a 5 segment pay range distribution for current and model pay ranges using formulas
   (10 minutes)


6. Move all employees to next higher segment to increase overall equity
   (5 minutes)

Total Time: 40 minutes

CompModel.net

1. Gather source data into one worksheet
   (10 minutes)


2. Import data into CompModel.net
   (less than 1 minute)


3. Increase ranges by 2.9% using the "Pay Range" operation
   (less than 1 minute)


4. Increase all employees pay by 4.0% without having pay increase beyond the range maximum using "Base Pay" operation
   (less than 1 minute)


5. Create a 5 segment pay range distribution for current and model pay ranges using "Model Settings"
   (less than 1 minute)


6. Move all employees to next higher segment to increase overall equity using "Base Pay" operation
   (less than 1 minute)

Total Time: Less than 15 minutes

CompModel.net is 56% faster than using traditional spreadsheet formulas.

This is just a simple example. More complex models can be created in CompModel, and the time savings would be even greater.