WDQ spreadsheet calculator

The weighted displacement quotient compares how much crime occurs between a targeted area (A), a buffer area (B) and a control area (C) before and during the operation to see how crime in those areas has changed. If crime has been displaced into the surrounding buffer or if that surrounding buffer has actually experienced some benefits due to its proximity to the operation, the WDQ will be able to detect that change. The Excel spreadsheet calculates the weighted displacement quotient as well as a number of other calculations. All you have to do is feed in the amount of crime in three areas before and during (or after) a police operation. The three areas are a target area, a buffer area, and a control area.

For further information on the WDQ, see: Bowers, K.J. and Johnson , S.D. (2003) ‘Measuring the geographical displacement and diffusion of benefit effects of crime prevention activity’, Journal of Quantitative Criminology, 19:3, pp. 275-301. For details of the Total Net Effect, see Guerette, R. T. (2009). Analyzing crime displacement and diffusion ( Tool Guide No. 10). Washington DC: Center for Problem Oriented Policing. Full details of the analytical procedure are available on the ‘Analysis details’ tab of the spreadsheet.

WDQinputOn the first page (shown here) you enter values into the yellow boxes. Stage one asks for crime counts for the target area, a buffer area, and a control area both before and during (or after) the operation. At stage two, you can enter the name of the operation, or if you prefer, the name of the police district or area.

Once you can done that, click the yellow results tab shown at the bottom of the screen. This will take you to the results page where you can print the output and see the result. An example is shown below.


The SEPTIC program is designed for reasonable numbers. Cells filled with a value of zero will result in a warning on the results page. The statistics used in this program will not function with a zero value in the control area.

Proceed to the download page