March 2018,  OneVoice CSDA Newsletter

PI #6—Percent of Current Support Paid by Percentage Band—Great Concept, Let’s Expand Our Thinking! —Part II

By Adam Perry, Child Support Program Manager, El Dorado County DCSS

Well, a lot has taken place since the last time I updated you on the Banding Toolkit back in the September 2017 issue. I wanted to take this opportunity to update you on where we are and what the future holds. We are excited that the Banding Toolkit is available to counties that want to utilize the tool. You can find the toolkit on the LCSA Secure Website (CPQ\CS1257 Based Performance Reports and Data\ DR Based Reports\ BANDING). We have been receiving some great feedback from counties that are using the tool and are working on ways to make the toolkit even better.

Caseworker Banding Tool—How does it look now?

If you remember from the September issue, the Banding Toolkit was created in MS Excel and consisted of three pivot worksheets that allowed caseworkers to drill down to cases that may need intervention: Monthly Banding, YTD Banding, and Arrears Distributed Banding.

Although as an end-user this format was efficient, the monthly maintenance, DR access, and Excel skills needed to create the pivot tables did not allow counties to easily maintain and utilize the toolkit. Thanks to the tremendous collaboration of CSDA, Frank Shipley and Cort Millward in Alameda, and Phil Kryder in Santa Barbara, a new version of the toolkit is now available in MS Access. The monthly data is available on the LCSA Secure Website and the monthly maintenance and technical knowledge needed is minimal. Below is an example of what the caseworker would see in the new version.

What are we working on now?

Currently we are working on the impact analysis portion of the toolkit. This will allow supervisor, managers, and program performance staff to utilize the data in the Banding Toolkit to measure impacts on current support and arrears collections based on specific interventions taken in a specific month. The tool will allow you to measure impacts up to six months after a specific intervention.

We also are working on improvements in the existing toolkit based on feedback we have received.

  1. We hope to have some solutions in the coming months for large counties that may not be able to utilize the tool effectively due to the large amount of data needed to run the toolkit.
  2. We hope to have some solutions/documentation for regionalized counties if they would like to have a regionalized version of the toolkit.
  3. We are working on providing follow up webcasts and/or additional training materials.

Both Frank Shipley and I especially want to recognize Cort Millward in Alameda County for all his hard work. His knowledge and skill in MS Access were invaluable in converting the toolkit into MS Access!

If you have any questions, suggestions, or would like assistance in deploying the tool in your LCSA, please contact me at 530-642-7377 or