Wednesday, 15 October 2014

New rim weighting Excel macro

Just a quick post to say that I've created a new rim weighting macro that takes separate demographic and target ranges as inputs. This is a change to the previous macro that made you put targets against every cell in the macro.

So the input looks like this:


Clicking on the weight by order (new) button brings up the dialog:

As you can see, the form is much simpler. The output looks like this:

The macro can be found in versions 0.8.x+ of my add-in which is in turn found on Survey Science.