Kalinosky et al. (2013a) developed a guidance manual and workshop series on street sweeping best practices, as well as a spreadsheet calculator tool “for predicting sediment and nutrient loads to street surfaces in urban areas based on overhead tree canopy; estimating the amount of material that can be removed and the cost of removal in targeted sweeping operations; and designing sweeping programs to meet nutrient reduction goals.”
Inputs into the calculator include:
Based on those simple inputs, the tool estimates nutrient recovery and cost per pound of P removed (Kalinosky et al. 2013b).
The calculator can be accessed at the link below or by sending an email to Larry Baker to get a copy (free and open source). Note that if you download the calculator from the link below you will need to open the file and save it as an .xlsm (macro enabled file). A Quick Reference Guide and User Support Manual are also available at the links below.