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.

2 comments:

  1. thank you so much for this. It has saved me hours of work on a data set that at first glance required simple weighting but in actual fact needed something much more complex.

    ReplyDelete
  2. This is incredibly useful. Thanks so much for sharing it.

    ReplyDelete