Mental Health

Adult

Children

Substance Use

Developmental

1.800.928.8000

How to Use the Measure Filter File for the Comparative Report

This page answers in detail some of the requirements needed to use the Measure Filter file for the Comparative Report. It is an additional aid to DCBS workers and RPCs in making placement choices between PCC programs and can be used to quickly compare programs on specific measures. Individual elements of the Comparative Report (or Comparative Report Program and Filter File) should not be used in isolation. Both are intended to be used together in making placement decisions. If you have questions about the PCC Comparative Report or Comparative Report Program and Filter File please contact the PCC program’s “Report Contact” or Tye Reece at CRP (859) 455-7452 ext. 3328.

Excel Macro Security Settings: This is a Microsoft Excel file. Prior to clicking on the link to use it, ensure that the security settings in Excel on the computer being used are set to medium. To do this open Excel, click on Tools, then Macros, then Security which will bring up a dialog box. Click the radio button next to medium. Click OK.

Opening the file: Click the link to the Comparative Report Program and Measure Filter file. You will be prompted to Open or Save the file. Click “Save” and select a destination on your computer so that you may use it at any time. Go to the folder where you saved the file and open it.

Upon opening the file you will be prompted to “disable or enable macros”, click “enable macros”.

You will then be prompted to open the file as “read only”, click yes.

From there the file will open and you will see a form with instructions on how to use the filter. If you enter child or program criteria in the form you need to click the “Filtered” button to see results. If you do not want to filter the results, click “Unfiltered”.

You will now see an Excel spreadsheet with program names and several cells with “#N/A” in them. Follow the instructions at the top of the page to select various measure results to view. You can sort your results by measure result by clicking the Sort buttons at the top of each column.

You can go back and start over by clicking the blue “Go Back and Refilter Results” button.

If you click on a program’s name you will be taken to their comparative report.

If you have any questions, contact Tye Reece at (859) 455-7452 ext. 3328.

FEATURED VIDEO

RELATED SERVICES

LATEST HEADLINES

FIND A LOCATION

110 Roach Street, Georgetown, KY 40324
Phone: 502.863.4734
Fax: 502.863.4735

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

438 Washington Street, Stanton, KY 40380
Phone: 606.663.2274
Fax: 606.663.2210

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

403 Gibson Lane, Richmond KY 40475
Phone: 859.661.4530

Monday – Friday: Morning 8:00 – 12:00 Afternoon 1:00 – 4:00

415 Gibson Lane, Richmond, KY 40475
Phone: 859.661.4526
Fax: 859.623.9160

411 Gibson Lane, Richmond, KY 40475
Phone: 859.626.5030
Fax: 859.626.8020

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

322 Frontier Boulevard, Stanford, KY 40484
Phone: 606.365.2197
Fax: 606.365.8310

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

324 Southview Drive, Nicholasville, KY 40356
Phone: 859.885.6315
Fax: 859.887.1886

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

257 Parkland Heights, Cynthiana, KY 41031
Phone: 859.234.6940
Fax: 859.234.5772

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

First Steps – Birth to Age 3 Developmental Delays
2935 Dolphin Drive, Suite 204, Elizabethtown, KY 42701
Phone: 270.737.5921 or 1.800.678.1879
Fax: 270.982.0829

191 Doctors Drive, Frankfort, KY 40601
Phone: 502.223.2182
Fax: 502.223.3338

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

149 Richmond Road, Irvine, KY 40336
Phone: 606.723.5128
Fax: 606.723.3288

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
For support, questions and to make an appointment contact the 24-Hour Helpline 1.800.928.8000

325 Professional Avenue, Winchester, KY 40391
Phone: 859.744.2562
Fax: 859.745.0020

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday. For support, questions and to make an appointment contact the 24-Hour Helpline 1.800.928.8000

650 High Street, Danville, KY 40422
Phone: 859.236.2726
Fax: 859.236.0373

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

4223 Lexington Road, Suite D, Paris, KY 40361
Phone: 859.987.6127
Fax: 859.987.7728

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

1060 Glensboro Road, Lawrenceburg KY 40342
Phone: 502.839.7203
Fax: 502.839.0041

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

201 Mechanic Street, Second Floor, Lexington, KY 40507
Phone: 859.721.8505
Fax: 859.253.1177

Monday – Friday | Morning 8:00 – 12:00 Afternoon 1:00 – 4:00

201 Mechanic, Street, Lexington, KY 40507
Phone: 859.721.8501
Fax: 859.253.1177

3479 Buckhorn Drive, Suite 106, Lexington, KY 40515
Phone: 859.246.7282
Fax: 859.246.7675

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

1351 Newtown Pike Building 3, Lexington, KY 40511
Phone: 859.225.3296
Fax: 859.254.2412

201 Mechanic Street, Lexington, KY 40507
Phone: 859.425.1210
Fax: 859.425.1213

Open Access is available 8:00 a.m.-5:00 p.m. Monday-Friday
Contact the 24-Hour Help Line to make arrangements 1.800.928.8000

1351 Newtown Pike, Building 5, Lexington, KY 40511
Phone: 859.233.0444
Fax: 859.225.6027

201 Mechanic Street, Lexington, KY 40507
Phone: 859.977.6080
Fax: 859.977.4502

1351 Newtown Pike, Building 5, Lexington, KY 40511
Phone: 859.271.9448 or 1.800.454.2764
Fax: 859.272.6893

600 Old Frankfort Circle, Lexington, KY 40510
Phone: 859.425.2746
Fax: 859.425.2623

1351 Newtown Pike, Building 1, Lexington, KY 40511 View Map
Phone: 859.253.1686
Fax: 859.255.4866

201 Mechanic Street, Lexington, KY 40507
Phone: 859.977.6080
Fax: 859.977.4502

1351 Newtown Pike, Building 5, Lexington, KY 40511
Phone: 859.233.0444
Fax: 859.268.8888

1351 Newtown Pike, Building 5, Lexington, KY 40511
Phone: 859.272.7483
Fax: 859.233.0144

New Vista Newsletter

Sign up to receive updates from New Vista.