Distribution Planning (Excel) This file will show you how the percentage of distribution of local option tax would change among cities in a county if they pass or rescind the tax. Just change "yes" to "no" or vice versa in the Passed ? column. The file will calculate the change.