AH ? CGOP ... Document1 Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 12 A" A Aa Ap EEVEEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste BIUvab X X A L Av Pane State Clinic PPE Rental Rate AL 4/19/2008 " $2, 655.00 " AL 5/3/2008 " $2, 655.00 " AL 5/17/2008 " $2, 655.00 " AL 5/31/2008 " $2, 655.00 " AL 6/14/2008 ' $2, 655.00 " AL 6/28/2008 " $2, 655.00 " AL 7/12/2008 " $2, 655.00 " AL 7/26/2008 ' $2, 655.00 " AL 8/9/2008 " $2, 655.00 " AL 8/23/200 ' $2, 655.00 " AL 9/6/2008 " $2, 655.00 " AL 9/20/200 ' $2, 655 .00 " AL 10/4/2008 " $2, 655.00 " AL 10/18/2008 $2, 655.00" AL 11/1/2008 ' $2, 655.00 " AL 11/15/2008 $2, 655.00 " AL 11/29/2008 " $2, 655.00 " AL 12/13/2008 $2, 655.00 ' AL 12/27/2008 $2, 655 . 00 AL NN+ 4/19/2008 $870 . 00 AL 5/3/2008 $870 . 00 AL 5/17/2008 $870 . 00 AL 5/31/2008 $870. 00 AL 6/14/2008 $870.00 AL 6/28/2008 $870 . 00 AL 7/12/2008 $870 . 00 AL 7/26/2008 $870 . 00 UNNN NN NN NN AL 8/9/2008 $870 . 00 AL 8/23/200 $870 . 00 AL 9/6/ 2008 $870.00 AL 9/20/2008 $870.00 AL 10/4/2008 $870 . 00 AL 10/18/2008 $870 . 00 AL UNNNN 11/1/2008 $870. 00 AL 11/15/200 $870.00 AL 11/29/2008 $870. 00 AL 12/13/2008 $870 . 00 AL WNN 12/27/2008 $870. 00 AL 4/19/2008 $870.00 AL 5/3/2008 $870.00 AL 5/17/2008 $870 . 00 AL 5/31/2008 $870.00 AL 6/14/2008 $870 . 00 AL w ww ww ww ww ww 6/28/2008 $870. 00 AL 7/12/2008 $870. 00 AL 7/26/2008 $870. 00 AL 8/9/2008 $870. 00 AL 8/23/2008 $870 . 00 AL 9/6/2008 $870. 00 AL 9/20/2008 $870. 00 AL 10/4/2008 $870 . 00 AL 10/18/2008 $870 .00 AL 11/1/2008 $870. 00 AL w ww ww 11/15/2008 $870 . 00 AL 11/29/2008 $870. 00 AL 12/13/2008 $870. 00 + Page 1 of 11 2543 words English (United States) Accessibility: Investigate Focus E 106%2 . C ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 AA ab Wrap Text v General LIX V V LY AP - O. Paste IUV DVAv Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State A B H 1 J K L M N P Q R te Clinic Total Hours S T Clinical Hours U V W Non-Clinical Hours X Support Staff Hours PPE Y 796.06 303.48 153.75 338.83 4/19/08 769.1 266.87 155.50 346.75 5/3/08 766.26 303.89 126.71 VOUAWN 335.66 5/17/08 588.88 246.28 88.34 254.26 5/3 1/08 612.4 264.14 137.49 210.80 14/08 674.44 306.74 143.62 224.08 6/28/08 554.60 250.19 121.49 182.92 7/12/08 654.78 285.87 90.16 278.75 7/26/08 787.57 271.84 173.83 341.90 8/9/08 20.4 262.06 172.59 285.76 8/23/08 740.10 281.54 141.93 316.63 9/6/08 814.95 294.45 162.41 358.09 9/20/08 782.17 263.67 150.50 368.00 10/4/08 15 736.17 245.08 142.09 349.00 10/18/08 16 775.62 280.98 166.33 328.31 11/1/08 17 777.84 273.55 164.16 340.13 11/15/08 18 628.01 225.40 128.79 273.82 11/29/08 19 771.73 289.91 136.59 345.23 2/13/08 20 564.89 173.56 123.83 267.50 12/27/08 21 352.91 104.13 109.11 139.67 4/19/08 22 371.59 119.82 120.08 131.69 5/3/08 23 325.93 95.37 110.62 19.94 24 5/17/08 332.4 124.79 81.98 125.67 5/31/08 25 461.26 181.38 132.56 147.32 6/14/08 26 394.84 153.96 111.16 129.72 6/28/08 27 326.60 96.69 91.05 138.86 7/12/08 28 450.34 153.02 113.47 183.85 7/26/08 29 560.97 1 19.16 162.06 279.75 8/9/08 30 411.54 90.81 129.01 191.72 8/23/08 31 359.93 102.98 99.07 157.8 9/6/08 32 363.58 112.59 113.31 137.68 9/20/0 33 145.17 116.06 114.55 214.5 10/4/08 34 388.98 90.07 107.42 191.49 10/18/08 35 416.07 109.37 109.45 197.25 36 11/1/08 N W WW WW WW WW WWNNNNNNNNNNNNNNNNNNN. 394.24 179.74 103.83 110.67 37 11/15/08 294.87 132.96 71.43 90.48 1 1/29/08 38 382.13 162.18 96.94 123.01 12/13/08 39 321.42 126.68 82.51 112.23 12/27/08 40 208.11 46.80 42.35 118.96 4/19/08 41 185.42 36.98 39.21 109.23 5/3/08 42 19'99 74.06 43.32 149.23 5/17/08 43 203.49 50.77 42.18 110.54 5/31/08 44 159.34 47.33 34.54 77.47 6/14/08 45 253.72 93.10 18.55 112.07 6/28/08 46 220.96 79.35 43.04 98.57 7/12/08 47 210.82 50.64 40.68 119.50 7/26/0 48 80.0 0.00 0.00 80.0 8/9/08 49 161.65 28.43 93.25 8/23/08 50 213.6 48.78 11.95 152.94 9/6/08 280 20 50 16 10 82 172 01 Hours Visits & Charges Labor Expenses + Ready 1 Accessibility: Good to go + 100%AH ? CGOP ... Document1 Share Comments Home Insert Draw Design Layout References Mailings Review View ? Tell me Calibri (Bo... v 12 A" A Aa Ap EV EEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste BI Uvab X X A LA Pane IN 7/25/2009 $525 . 00 4/19/2008 $525 . 00 TX 5/3/2008 $525. 00 TX 5/17/2008 $525 . 00 5/31/2008 $525.00 TX 6/14/2008 $525. 00 TX 6/28/2008 $525 . 00 TX 7/12/2008 $525. 00 7/26/2008 $525 . 00 TX 8/9/2008 $525. 00 TX 8/23/2008 $525. 00 9/6/2008 $525. 00 9/20/2008 $525 . 00 TX 10/4/2008 $525 . 00 TX 10/18/2008 $525 . 00 11/1/2008 $525 . 00 TX 11/15/2008 $525. 00 TX 11/29/2008 $525. 00 TX 12/13/2008 $525. 00 2/27/2008 $525 . 00 TX 2/7/2009 $525 . 00 TX 2/21/2009 $525 . 00 3/7/2009 $525. 00 TX 3/21/2009 $525.00 4/4/2009 $525. 00 TX 4/18/2009 $525. 00 TX 5/2/2009 $525. 00 TX 5/16/2009 $525 . 00 5/30/2009 $525 . 00 TX 6/13/2009 $525. 00 TX 6/27/2009 $525 . 00 TX 7/11/2009 $525 . 00 TX 7/25/2009 $525 . 00 VA 4/19/2008 $750 . 00 VA 5/3/2008 $750 . 00 VA 5/17/2008 $750 . 0 VA 5/31/2008 $750 . 00 VA 6/14/2008 $750.00 VA 6/28/2008 $750. 00 VA 7/12/2008 $750 . 00 VA 7/26/2008 $750 . 00 VA 8/9/2008 $750 . 00 VA 8/23/2008 $750 . 00 VA 9/6/2008 $ 750 . 00 VA 9/20/2008 $750. 00 VA 10/4/2008 $750 . 00 VA 10/18/2008 $750 . 00 VA 11/1/2008 $750. 00 VA 11/15/2008 $750 . 00 VA 11/29/2008 $750 . 00 VA 12/13/2008 $750 . 00 VA 12/27/2008 $750. 00 VA 2/7/2009 $750 . 00 VA 2/21/2009 $ 750 . 00 VA 3/7/2009 $750. 00 VA 3/21/2009 $750 . 00 VA 4/4/2009 $750 . 00 E + 106% Page 10 of 11 2543 words English (United States) Accessibility: Investigate Focus2 . G ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 AA = ab Wrap Text General LIX V V Paste BIUV vAv Merge & Center v $ ~ % " 00 20 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State A B E F H 1 J K L M N P Q R S T U V W X 151 H 197.00 125.00 72.00 0.00 2/7/09 452 )H 99.50 127.50 72.00 0.00 2/2 1/09 53 H 193.50 121.50 72.00 0.00 3/7/09 454 )H 219.40 139.40 80.00 0.00 3/21/09 55 DH 217.15 137.15 80.00 0.00 4/4/09 191.02 113.50 77.52 0.00 4/18/09 or DH 210.65 138.65 72.00 0.00 5/2/09 458 H 205.78 133.78 72.00 0.00 5/16/0 459 )H 167.80 119.80 48.00 0.00 5/30/09 60 H 196.90 116.90 80.00 0.00 6/13/09 92.03 112.03 80.00 0.00 6/27/09 462 H 147.65 75.65 72.00 0.00 7/1 1/09 463 H 175.75 113.75 62.00 ).00 125/0 64 :C 178.06 108.1 69.96 0.00 4/19/08 65 ;C 226.05 131.55 94.50 0.00 5/3/08 466 ;C 209.35 125.35 84 00 0.00 5/17/08 467 ;C 196.90 126.90 70.00 0.00 5/31/08 468 C 201.9 120.35 81.58 0.00 6/14/08 469 C 178.25 110.75 67.50 0.00 6/28/08 470 ;C 163.90 84.15 79.75 0.00 7/12/08 471 C 122.50 42.50 30.00 0.00 7/26/08 472 C 83.75 30.25 53.50 0.00 8/9/08 473 C 119.90 48.90 71.00 0.00 8/23/08 474 ;C 180.00 108.00 72.00 0.00 9/6/08 475 0 188.40 108.40 80.00 0.00 9/20/08 476 C 184.85 104.8 80.00 .00 10/4/08 477 ;C 152.65 73.15 79.50 0.00 10/18/08 478 C 166.20 84.95 81.25 0.00 11/1/08 479 C 165.25 82.50 82.75 0.00 11/15/08 480 C 138.77 73.35 65.42 0.00 1/29/08 181 C 157.80 78.80 79.00 0.00 12/13/08 182 C 118.55 $7.05 61.50 0.00 12/27/08 83 N 153.09 72.00 81.09 0.00 4/19/08 484 N 149.50 72.00 77.50 0.00 5/3/08 485 N 149.50 72.00 77.50 0.00 5/17/08 86 NV 132.55 64.80 67.75 0.00 5/31/08 87 N 153.83 72.00 81.83 0.00 6/14/08 488 N 160.34 80.00 80.34 0.00 6/28/08 489 N 148.10 75.60 72.50 0.00 /12/0 490 N 120.59 80.00 40.59 0.00 7/26/08 91 N 160.33 80.00 80.33 0.00 8/9/08 492 N 60.50 80.00 80.50 0.00 8/23/08 493 N 182.83 110.50 72.33 0.00 9/6/08 494 N 186.43 108.00 78.43 0.00 9/20/08 95 IN 200.55 125.80 74.75 0.00 10/4/08 490N 153.75 96.00 57.75 0.00 10/18/08 497 N 92.70 12.7 80.00 0.00 11/1/08 498 N 150.95 73.70 77.25 0.00 11/15/08 499 N 128.00 64.00 64.00 0.00 11/29/08 500 N 159.25 80.00 79.25 0.00 12/13/08 70 nn 72 00 non Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%AH ? CGOP ... Document1 Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 12 A" A Aa Ap EEVEEVEE 24 T AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste BIUvab X X A L Av Pane VA 4/18/2009 $750. 00 VA 5/2/2009 $750 . 00 VA 5/16/2009 $750 . 00 VA 5/30/2009 $750 . 00 VA 6/13/2009 $ 750 . 00 VA 6/27/2009 $ 750. 00 VA 7/11/2009 $750 . 00 VA 7/25/2009 $750 . 00 WI 4/19/200 $750 . 00 WI 5/3/2008 $750 . 00 WI 5/17/2008 $750 . 00 WI 5/31/2008 $750 . 00 WI 6/14/2008 $750 . 00 WI 6/28/2008 $750. 00 WI 7/12/2008 $ 750 . 00 WI 7/26/2008 $ 750 . 00 WI 8/9/2008 $750. 00 WI 8/23/200 $750 . 00 WI 9/6/2008 $750 . 00 WI 9/20/200 $ 750 . 00 WI 10/4/2008 $750 . 00 WI 10/18/2008 $750 . 00 WI 11/1/2008 $750. 00 WI 11/15/2008 $750. 00 WI 11/29/2008 $ 750 . 00 WI 12/13/2008 $ 750 . 00 WI 12/27/2008 $750 . 00 WI 2/7/2009 $750. 00 WI 2/21/2009 $750 . 00 WI 3/7/2009 $750. 00 WI 3/21/2009 $750 . 00 WI 4/4/2009 $750 . 00 WI 4/18/2009 $750 . 00 WI 5/2/2009 $750 . 00 WI 5/16/2009 $750 . 00 WI 5/30/2009 $750 . 00 WI 6/13/2009 $750. 00 WI 6/27/2009 $750. 00 WI 7/11/200 $750. 00 WI 7/25/2009 $ 750. 00 + 106% Page 11 of 11 2543 words English (United States) & Accessibility: Investigate Focus E2 . G ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 AA ab Wrap Text v General LY AY - O. Paste IUV vAv Merge & Center v $ ~ % " 00 20 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State B C D E F G H 1 J K L M N 0 P Q R S T U V W X 501 TN 144.0 72.00 72.00 0.00 12/27/0 502 TN 164.75 34.75 80.00 0.00 2/7/09 103 TN 152.50 72.50 80.00 0.00 2/21/09 504 TN 154.50 76.00 78.50 0.00 3/7/09 505 TN 100.00 60.00 40.00 0.00 3/21/09 506 TN 172.00 92.00 80.00 0.00 4/4/09 507 TN 156.00 84-00 72.00 0.00 4/18/09 08 TN 168.00 88.00 80.00 0.00 5/2/09 509 TN 158.80 8.80 80.00 0.00 5/16/09 510 T 120.00 56.00 64.00 0.00 5/30/09 511 TN 128.00 18.00 80.00 0.00 6/13/09 512 T 129.75 60.00 69.75 0.00 6/27/09 513 T 100.00 28.00 72.00 0.00 /1 1/0 514 TM 152.50 6.50 76.00 0.00 7/25/09 515 TX 293.50 72.00 113.00 108.50 1/19/08 516 TX 270.42 68.40 111.00 91.02 5/3/08 517 TX 257.54 72.00 106.02 79.52 5/17/08 518 TX 255.80 64.80 119.00 72.00 5/31/08 519 TX 236.02 36.00 129.00 71.02 6/14/08 520 TX 289.51 72.00 147.02 70.49 6/28/08 521 TX 235.90 50.40 126.50 59.00 7/12/08 522 TX 255.50 36.00 147.00 72.50 7/26/08 523 TX 240.50 72.00 105.50 63.00 8/9/08 524 TX 277.00 72.00 153.00 52.00 8/23/08 525 TX 244.55 64.80 128.00 51.75 9/6/08 526 TX 216.00 72.00 113.00 31.00 9/20/08 527 TX 261.00 72.00 128.50 60.50 10/4/08 528 TX 280.00 72.00 142.50 65.50 0/18/0 251.75 72.00 137.00 12.75 11/1/08 130 TX 253.07 64-80 124.02 64.25 1/15/08 531 TX 160.90 50.40 72.00 38.50 11/29/08 532 TX 209.05 64.80 80.00 64.25 12/13/08 533 TX 174.00 54.00 64.00 56.00 2/27/0 534 TX 271.60 128.60 80.00 63.00 2/7/09 535 TX 280.25 140.00 71.00 69.25 2/21/09 536 TX 290.80 141.80 80.00 69.00 3/7/09 537 TX 244.87 126.10 58.00 60.77 3/21/09 538 TX 89.80 144.80 71.00 74.00 4/4/09 39 TX 306.00 152.00 80.00 74.00 /18/09 540 TX 283.75 152.00 80.00 51.75 5/2/09 541 TX 300.25 152.00 80.00 68.25 5/16/09 542 TX 277.55 136.80 71.00 69.75 5/30/09 43 TX 253.25 104.00 73.00 76.25 6/13/09 544 TX 305.25 152.00 80.00 73.25 6/27/09 545 TX 261.15 122.40 74.50 64.25 7/1 1/0 546 TX 227.85 124.10 31.00 72.75 7/25/09 547 V 296.83 152.00 53.00 91.83 4/19/08 548 VA 299.50 152.00 62.00 85.50 5/3/08 549 VA 288.80 144.80 65.00 79.00 5/17/08 550 VA 235.20 115.20 56.00 64.00 5/31/08 551 VA 273 00 144 00 36 50 9250 6/14/08 Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%2 . G ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 VA A ab Wrap Text General LIX V V LY AP - O. Paste IUV vAv Merge & Center v $ ~ % " 00 0 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State A B E H 1 J K L M N P Q R S T U V W X Y 551 VA 273.00 144.00 36.50 92.50 6/14/0 552 VA 300.21 152.00 73.00 75.21 6/28/08 553 V 251.0 113 60 66.00 71.42 7/12/08 54 VA 246.52 113.60 44.00 88.92 7/26/08 555 V 184.60 39.52 70.00 75.08 8/9/08 556 VA 179.75 27.00 76.00 76.75 3/23/08 557 V 134.58 5.50 59.00 70.08 9/6/08 558 VA 219.75 80.00 77.50 62.25 9/20/08 559 VA 231.00 80.00 80.00 71.00 10/4/08 560 VA 250.50 80.00 72.00 98.50 10/18/08 561 VA 237.67 87.00 66.00 84.67 11/1/08 562 VA 231.7 80.00 65.00 86.75 11/15/08 563 VA 196.50 64.00 63.00 69.50 11/29/08 564 VA 229.66 83.00 65.50 81.16 12/13/08 565 VA 157.00 72.00 48.50 36.50 12/27/08 566 VA 301.70 152.00 77.00 72.70 2/7/09 67 VA 286.62 152.00 71.50 63.12 2/21/09 568 VA 296.13 152.00 80.00 64.13 3/7/09 569 VA 301.50 152.00 69.00 80.50 3/21/09 570 V 291.7 144.00 80.00 67.75 4/4/09 571 VA 294.89 144.80 69.50 80.59 4/18/09 572 VA 294.50 152.00 80.00 62.50 5/2/09 573 VA 304.0 152.00 77.50 74.50 5/16/09 574 V 284.05 136.80 69.00 78.25 5/30/09 575 VA 305.33 144.00 92.83 6/13/09 312.43 152.00 68-50 576 VA 32.00 128.43 6/27/09 577 VA 273.13 136.80 66.50 69.83 7/1 1/09 578 VA 289.88 44.80 76.00 69.08 7/25/09 579 W 269.50 160.00 81.50 28.00 1/19/0 580 W 266.75 152.00 73.25 41.50 5/3/08 581 WI 205.25 108.00 80.75 16.50 5/17/08 582 W 229.00 64.00 165.00 0.00 5/31/08 583 WI 206.50 91.50 115.00 0.00 6/14/08 584 WI 266.90 148.40 1 18.50 0.00 6/28/08 685 WI 144.83 90.08 54.75 0.00 7/12/08 586 W 195.75 72.00 123.75 0.00 /26/08 587 WI 224.00 72.00 72.00 80.00 8/9/08 588 W 233.00 72.00 81.00 80.00 8/23/08 089 W 208.80 64.80 72.0 72.00 9/6/08 590 W 211.30 55.80 75.50 80.00 9/20/08 591 W 218.25 72.00 66.00 80.25 10/4/08 592 W 238.00 72.00 86.00 80.00 10/18/08 93 W 207.75 36.00 91.75 80.00 11/1/08 594 W 266.55 64.80 121.75 80.00 11/15/08 595 W 173.90 63.90 45.50 64.50 11/29/08 596 W 200.00 72.00 48.00 80.00 12/13/08 597 W 208.80 64-80 72.00 72.00 12/27/08 698 W 212.00 72.00 60.00 80.00 2/7/09 599 W 177.50 72.00 24.50 81.00 2/21/09 600 W 232.00 2.00 80.00 80.00 3/7/09 Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%2 . C ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 VA A ab Wrap Text v General LIX V V LY AP - O. Paste vAv Merge & Center v $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State B E F H 1 J K L M N P Q R S T U V W X Y 601 224.00 72.00 72.00 80.00 3/21/09 602 176.00 72.00 40.00 64.00 4/4/09 603 184.00 72.00 72.00 40.0 4/18/09 504 196.00 36.00 80.00 80.0 5/2/09 605 160.00 0.00 30.00 80.00 5/16/09 606 144.00 0.00 72.00 72.00 5/30/09 607 152.00 0.00 72.00 80.00 6/13/09 608 160.00 0.00 80.00 80.0 /27/09 09 64.00 0.00 40.00 24.00 7/1 1/09 610 120.0 0.00 30.00 40.00 7/25/09 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 D Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%AH ? CGOP ... Document1 Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 12 A" A Aa Ap AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE BIUvab X X A LA Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste Pane AL 3 12/27/2008 $870. 00 AL 4/19/2008 $945 . 00 AL 4 5/3/2008 $945 . 00 AL 4 5/17/2008 $ 945 . 00 AL 4 5/31/2008 $945. 00 AL 6/14/2008 $945 . 00 AL 6/28/2008 $945. 00 AL DDDDD 7/12/2008 $945 . 00 AL 7/26/2008 $945. 00 AL 8/9/2008 $ 945 . 00 AL 8/23/200 $945. 00 AL DDDDD 9/6/2008 $945 . 00 AL 9/20/2008 $ 945 . 00 AL 10/4/2008 $ 945 . 00 AL 10/18/200 $945.00 AL 11/1/2008 $ 945. 00 AL DDDDD 11/15/2008 $ 945 . 00 AL 11/29/2008 $945. 00 AL 12/13/2008 $945 . 00 AL 12/27/2008 $945 . 00 AL 9/6/2008 $495 . 00 AL 9/20/2008 $495.00 AL 10/4/2008 $ 495 . 00 AL 10/18/2008 $495.00 AL 11/1/2008 $495. 00 AL 11/15/200 $495 . 00 AL 11/29/2008 $495 . 00 AL 12/13/2008 $495 . 00 AL 12/27/2008 $495 . 00 co 4/19/2008 $570 . 00 co 5/3/2008 $570 . 00 co 5/17/2008 $570. 00 5/31/2008 $570 .00 co 6/14/2008 $570 . 00 Co 6/28/2008 $570 . 00 co 7/12/2008 $570 . 00 Co 7/26/2008 $570. 00 co 8/9/2008 $570 . 00 co 8/23/2008 $570. 00 Co 9/6/2008 $570. 00 co 9/20/2008 $570 . 00 co 10/4/2008 $570 . 00 co 10/18/2008 $570 . 00 Co 11/1/2008 $570 . 00 co 11/15/2008 $570. 00 11/29/2008 $570 . 00 co 12/13/2008 $570 . 00 co 12/27/2008 $570. 00 co 2/7/2009 $570 . 00 co 2/21/2009 $570. 00 co 3/7/2009 $570. 00 co 3/21/2009 $570 . 00 co 4/4/2009 $570 . 00 co 4/18/2009 $570. 00 5/2/2009 $570 . 00 co 5/16/2009 $570 . 00 5/30/ 2009 $570 . 00 E Page 2 of 11 2543 words English (United States) Accessibility: Investigate Focus + 106%2 . C ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 AA ab Wrap Text General LIX V V LY AP - O. Paste BIUV Merge & Center v $ ~ % " 00 0 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 4 X V fx State A E H 1 J K L M N P Q R S T U V W X Y 51 AL 82.2 59.46 49.82 173.01 9/20/08 52 AL 243.1 53.80 51.10 138.28 10/4/08 225.6 52.07 44.54 129.05 10/18/08 54 AL 292.45 57.45 59.25 175.75 11/1/08 55 AL 285.63 63.00 45.53 177.10 11/15/08 56 AL 223.72 70.55 50.70 102.47 1/29/08 57 AL 270.00 77.65 41.92 150.43 12/13/08 58 AL 158.07 1.20 24.17 72.70 12/27/08 59 AL 27.80 2.80 80.00 65.00 4/19/08 60 219.97 82.80 72.00 65.17 5/3/08 61 232.80 82.80 80.00 70.00 5/17/08 62 PRP 252.60 75.60 72.00 105.00 5/31/08 63 AL 317.8 82.80 80.00 155.00 6/14/08 64 AL 165.0 72.00 80.00 13.00 6/28/08 65 293.4 68.40 64.00 161.00 7/12/08 66 AL $71.90 77.40 91.50 203.00 7/26/08 67 AL 288.40 7.40 104.00 107.00 8/9/08 68 AL 259.2 78.20 80.00 101.00 8/23/08 - CICICICICICICICICI A A A A A A A A A A A A A A A A A A A W W WW WW WW 69 242.20 70.20 84.00 88.00 9/6/08 70 264.20 74.70 84.00 105.50 9/20/08 71 264.20 82.20 80.00 102.0 10/4/08 72 AL 195.20 05.20 100.00 90.00 10/18/08 AL 296.4 126.75 67.71 102.00 11/1/08 74 AL 222.89 95.80 40.84 86.25 11/15/08 75 AL 208.38 63.60 65.78 79.00 11/29/08 76 AL 254.3 83.00 75.33 96.00 12/13/08 77 AL 224.67 74.00 74.67 76.00 2/27/0 78 136.8 64.80 72.00 0.00 9/6/08 79 AL 156.50 76.50 80.00 0.00 9/20/08 80 AL 156.50 76.50 80.00 0.00 10/4/08 81 AL 150.20 70.20 80.00 0.00 10/18/08 AL 155.40 7.40 78.00 0.00 11/1/08 83 154.00 82.00 72.00 0.00 11/15/08 84 127.60 63.60 64.00 0.00 1/29/08 85 150.88 1.8 79.00 0.00 12/13/08 86 133.80 '0.80 63.00 0.00 12/27/08 87 281.0 172.50 88.50 20.00 4/19/08 88 323.00 143.00 160.00 20.00 5/3/08 89 351.25 176.25 155.00 20.00 5/17/08 90 303.45 151.20 137.25 15.00 5/31/08 335.60 155.60 164.00 16.00 6/14/08 92 8 8 8 8 8 8 8 8 8 8 8 8 8 8 RRRR 338.50 174.75 147.75 6.00 6/28/08 93 285.67 130.67 143.00 12.00 7/12/08 94 339.59 79.5 160.00 0.00 7/26/08 340.00 180.00 160.00 0.00 8/9/08 332.75 209.00 123.75 0.00 8/23/08 97 315.18 168.43 146.75 0.00 9/6/08 98 329.42 169.42 160.00 0.00 9/20/08 99 313.17 169.17 144.00 0.00 10/4/08 100 315.75 158.00 157.75 0 00 10/18/08 170 no AGAED non Hours Visits & Charges Labor Expenses + Ready 1 Accessibility: Good to go + 100%AH ? CGOP ... Document1 Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Home Calibri (Bo... v 12 A" A Aa Ap EV EEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste BI U vab X2 X A L Av Pane Co 6/13/2009 $570 . 00 co 6/27/2009 $570 . 00 co 7/11/2009 $570 . 00 co 7/25/2009 $570 . 00 IA 4/19/2008 $990.00 IA 5/3/2008 $990. 00 IA 5/17/2008 $990 . 00 IA 5/31/2008 $990. 00 IA 6/14/2008 $990 . 00 IA 6/28/2008 $990 . 00 IA 7/12/2008 $990 . 00 IA 7/26/2008 $990 . 00 IA 8/9/200 $990. 00 IA 8/23/2008 $990. 00 IA 9/6/2008 $990 . 00 IA 9/20/2008 $990 . 00 IA 10/4/2008 $990. 00 IA 10/18/2008 $990 . 00 IA 11/1/2008 $990 . 00 IA 11/15/2008 $990 . 00 IA 11/29/2008 $990. 00 IA 12/13/2008 $990 . 00 IA 12/27/2008 $990 . 00 IA 2/7/2009 $990. 00 IA 2/21/2009 $990 . 00 IA 3/7/2009 $990 . 00 IA 3/21/2009 $990 . 00 IA 4/4/2009 $990. 00 IA 4/18/200 $990 . 00 IA 5/2/2009 $990 . 00 IA 5/16/2009 $990 . 00 IA 5/30/2009 $990 . 00 IA 6/13/2009 $990 . 00 IA 6/27/2009 $990. 00 IA 7/11/2009 $990 . 00 IA 7/25/2009 $990 . 00 IA 4/19/2008 $990 . 00 IA 5/3/ 2008 $990 . 00 IA 5/17/2008 $990 .00 IA 5/31/2008 $990. 00 IA 6/14/200 $990 . 00 IA 6/28/2008 $990 . 00 IA 7/12/2008 $990.00 IA 7/26/2008 $990 . 00 IA 8/9/2008 $990 . 0 IA U N N N N N N N N N N N N N N N N N N N H 8/23/200 $990 . 00 IA 9/6/2008 $990. 00 IA 9/20/2008 $990. 00 IA 10/4/2008 $990 . 00 IA 10/18/2008 $990. 00 IA 11/1/2008 $990 . 00 IA 11/15/2008 $990 . 00 IA 11/29/2008 $990 . 00 IA 12/13/2008 $990 .00 IA 12/27/2008 $990. 00 IA 2/7/2009 $990 . 00 TA 2/21/2009 $990 . 00 + 106% Page 3 of 11 2543 words English (United States) Accessibility: Investigate Focus E2 . C ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 VA A ab Wrap Text v General LIX V V LY AP - O. Paste BIUV vAv Merge & Center v $ ~ % " 00 0 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State A B D E G H 1 J K L M N P Q R S T U V W X Y 101 CO 336.53 172.03 164.50 0.00 11/1/08 102 CO 341.42 190.42 151.00 0.00 11/15/08 3 CO 299.35 170.35 129.00 0.00 1/29/08 4 CO 364.42 201.42 163.00 0.00 5 co 12/13/08 245.50 133.50 112.00 0.00 12/27/08 106 CO 260.17 179.17 81.00 0.00 2/7/09 7 Co 258.75 177.75 81.00 0.00 2/21/09 108 253.00 167.00 86.00 0.00 3/7/09 109 239.00 159.00 80.00 0.00 3/21/09 110 CO 271.50 151.50 80.00 40.00 4/4/09 111 co 252.58 142.25 80.00 30.33 4/18/09 2 CO 284.33 162.50 81.00 40.83 5/2/09 113 Co 268.00 147.50 80.00 40.50 5/16/09 114 0 221.0 122.50 55.50 43.00 5/30/09 115 Co 280.75 147.25 80.00 53.50 6/13/09 116 C 280.08 153.00 0.00 127.08 6/27/09 117 214.92 120.67 0.00 94.25 /1 1/09 118 co 388.58 174.08 78.50 36.00 7/25/09 119 IA 158.50 72.00 64.00 22.50 4/19/08 120 I 143.08 72.00 54.08 17.00 5/3/08 121 IA 91-34 0.00 69.34 22.00 5/17/08 122 IA 75.50 0.00 57.00 18.50 5/31/08 123 IA 84.10 0.00 57.60 26.50 6/14/08 124 IA 144.83 7.0 52.83 15.00 6/28/08 125 IA 130.00 72.00 55.00 3.00 7/12/08 26 150.50 80.00 69.50 1.00 7/26/08 127 1/ 149.00 116.00 27.00 6.00 8/9/08 28 1 183.95 127.20 51.75 5.00 8/23/08 29 1 151.30 112.80 20.25 18.25 9/6/08 130 1 186.01 126.10 46.91 13.00 9/20/08 31 1 191.97 118.80 34.17 39.00 10/4/08 132 1 223.55 118.80 60.75 44.00 10/18/08 33 1 223.23 114.40 54.83 54.00 11/1/08 34 IA 232-99 122.00 67.99 43.00 11/15/08 35 IA 178.85 104.60 47.00 27.25 11/29/08 36 1 231.92 111.00 76.92 44.00 2/13/08 137 IA 170.10 77.60 55.50 37.00 12/27/08 38 1 264.63 108.00 123.63 33.00 2/7/09 39 28.10 104.00 84.10 40.00 2/21/09 140 IA 229.69 105.02 88.67 36.00 3/7/09 41 1 228.98 00.0 92.48 36.50 3/21/09 42 1 223.18 100.50 84.68 38.00 4/4/09 43 IA 228.97 104.00 97.97 27.00 4/18/09 144 234.33 100.83 88.50 45.00 5/2/09 145 1 211.09 101.00 77.09 33.00 5/16/09 46 IA 229.00 106.50 92.50 30.00 5/30/09 47 257.9 115.00 92.92 50.00 6/13/09 48 202.42 82.75 90.67 29.00 /27/09 49 IA 283.38 153.00 100.38 30.00 7/1 1/0 150 IA 320.02 166.25 109.77 44.00 7/25/09 Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%AH ? CGOP ... Document1 Share Comments Home Insert Draw Design Layout References Mailings Review View ? Tell me Calibri (Bo... v 12 A" A Aa Ap EV EEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE BI Uvab X X A LA Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste Pane IA 2 3/7/2009 $990 . 00 3/21/2009 $990 . 00 IA 2 4/4/2009 $990. 00 IA 4/18/2009 $990 . 00 IA 5/2/2009 $990. 00 IA 5/16/2009 $990 . 0 IA NNNN NN 5/30/200 $990 . 00 IA 6/13/2009 $990 . 00 IA 6/27/2009 $990 . 00 IA 7/11/2009 $990 . 00 IA 7/25/2009 $990 . 00 IL 4/19/2008 " $2, 430.00 " IL 5/3/2008 " $2, 430.00 " IL 5/17/2008 " $2, 430.00 " IL 5/31/2008 " $2, 430.00 " IL 6/14/2008 " $2, 430.00 " IL 6/28/2008 ' $2, 430.00 " IL 7/12/2008 " $2, 430.00 " IL 7/26/2008 " $2, 430.00 " IL 8/9/2008 " $2, 430.00 " IL 8/23/2008 ' $2, 430.00 " IL 9/6/2008 $2, 430.00 " IL 9/20/2008 $2, 430.00 " IL 10/4/2008 ' $2, 430.00 " IL 10/18/2008 " $2, 430.00 " IL 11/1/2008 ' $2, 430.00 " IL 11/15/2008 ' $2, 430.00 " IL 11/29/2008 $2, 430. 00 " IL 12/13/2008 ' $2, 430.00 " IL 12/27/2008 $2, 430.00 " IL 2/7/2009 " $2, 430.00 " IL 2/21/200 " $2, 430.00 " IL 3/7/2009 ' $2, 430.00 " IL 3/21/2009 ' $2, 430.00 " IL 4/4/2009 $2, 430 . 00 " IL 4/18/2009 " $2, 430.00 " IL 5/2/2009 ' $2, 430.00 " IL 5/16/2009 ' $2, 430.00 " IL 5/30/2009 $2, 430. 00 " IL 6/13/200 ' $2, 430.00 " IL 6/27/2009 $2, 430.00" IL 7/11/2009 ' $2, 430.00 ' IL 7/25/2009 " $2, 430.00 " IN 7/25/2009 $825. 00 IN 4/19/2008 $825. 00 IN 5/3/2008 $825 .00 IN 5/17/2008 $825.00 IN 5/31/2008 $825 . 00 IN NNNN NN NN NN 6/14/2008 $825. 00 IN 6/28/2008 $825 .00 IN 7/12/2008 $825 . 00 IN 7/26/2008 $825. 00 IN 8/9/2008 $825. 00 IN 8/23/2008 $825. 00 IN 9/6/2008 $825 . 00 IN NNN 9/20/2008 $825.00 IN 10/4/2008 $825 . 00 Focus + 106% Page 4 of 11 2543 words English (United States) Accessibility: Investigate2 . C ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 AA ab Wrap Text v General LIX V V LY AP - O. Paste BIU V vAv SEE Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State B E H I J K L M N P Q R S T U V W X Y 151 132.5 0.00 0.00 132.50 4/19/08 152 131.50 0.00 0.00 131.50 5/3/08 153 144.25 0.00 0.00 144.25 5/17/08 154 138.50 0.00 0.00 138.50 5/31/08 155 107.5 0.00 0.00 107.50 6/14/08 156 163.25 0.00 0.00 163.25 6/28/08 157 114.00 0.00 0.00 114.00 /12/0 158 189.7 0.00 1.00 188.75 7/26/08 159 126.50 0.00 0.00 126.50 8/9/08 160 151.75 0.00 0.50 151.25 8/23/08 161 188.00 0.00 0.00 88.00 9/6/08 162 276.50 0.00 0.00 276.50 9/20/08 163 93.00 0.00 0.00 93.00 10/4/08 164 100.50 0.00 0.50 100.00 10/18/08 165 100.0 0.00 0.00 100.00 1 1/1/08 166 70.00 0.00 0.00 70.00 1/15/08 167 - N N N N N N N N N N N N N N N N N N N N N N N N NN NN NNNN 128.00 0.00 0.00 128.00 11/29/08 168 214.50 0.00 0.50 214.00 12/13/08 169 174.75 0 00 0.00 174.75 12/27/08 170 201.00 0.00 0.00 201.00 2/7/09 171 207.50 0.00 0.50 207.00 2/21/09 172 203.00 0.00 0.00 203.00 3/7/09 173 226.83 0.00 0.00 226.83 /21/0 174 188.25 0.00 0.00 188.25 4/4/09 175 198.83 0.00 0.00 198.83 4/18/09 176 164.08 0.00 1.58 162.50 5/2/09 177 159.0 0.00 0.00 159.00 5/16/09 178 176.25 0.00 0.00 176.25 5/30/09 179 166.25 0.00 0.00 166.25 6/13/09 180 148.00 32.50 0.00 115.50 6/27/09 181 102.0 0 00 0.0 102.00 7/1 1/09 182 127.00 0.00 0.00 127.00 7/25/09 183 612.75 452.75 160.00 0.00 4/19/08 184 591.85 431.85 60.0 0.00 5/3/08 185 601.00 443.00 158.00 0.00 5/17/08 186 482.00 339.75 142.25 0.00 5/31/08 187 570.00 410.00 160.00 0.00 6/14/08 188 540.00 380.00 160.00 0.00 /28/0 189 509.25 364.25 145.00 0.0 7/12/08 190 505.50 377.50 114.00 14.00 7/26/08 191 71.85 334.35 120.50 17.00 8/9/08 192 498.75 333.75 150.00 15.00 123/0 193 380.75 247.25 124.50 9.00 9/6/08 194 451.25 299.25 152.00 0.00 9/20/08 195 441.50 291.50 150.00 0.00 10/4/08 196 371.40 246.90 124.50 0.00 10/18/08 197 511.0 368.00 43.0 0.00 11/1/08 198 487.75 327.75 160.00 0.0 11/15/08 19 439.00 302.00 137.0 0.00 11/29/08 200 529.50 378.00 151.50 0.00 2/13/08 201 ann Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%AH ? CGOP ... Document1 Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 12 A" A Aa Ap EV EEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE V V Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste BI Uvab X X A DAY Pane 10/18/2008 $825. 00 IN 2 11/1/2008 $825. 00 IN 11/15/200 $825. 00 IN 11/29/2008 $825 . 00 IN 12/13/2008 $825 . 00 IN 12/27/2008 $825. 00 NN NN NN NN IN 2/7/2009 $825 . 00 IN 2/21/2009 $825 . 00 IN 3/7/2009 $825 . 00 IN 3/21/2009 $825. 00 IN 2 4/4/2009 $825. 00 IN 4/18/2009 $825. 00 IN 5/2/2009 $825 . 00 IN 5/16/2009 $825 . 00 IN 5/30/2009 $825. 00 IN - NNNN 6/13/2009 $825 . 00 IN 6/27/2009 $825. 00 MI 4/19/2008 $945 . 00 MI 5/3/2008 $945. 00 MI 5/17/2008 $ 945 . 00 MI 5/31/2008 $945. 00 MI 6/14/2008 $ 945 . 00 MI 6/28/2008 $ 945 . 00 MI 7/12/2008 $945. 00 MI 7/26/2008 $945 .00 MI 8/9/2008 $945. 00 8/23/2008 $945 . 0 MI 9/6/2008 $ 945 . 00 MI 9/20/2008 $945 . 00 MI 10/4/2008 $945. 00 MI 2/7/2009 $945 . 00 2/21/2009 $945. 00 MI 3/7/2009 $945 . 00 3/21/2009 $945. 0 MI 4/4/2009 $945.00 MI /2009 $ 945 . 00 MI 5/2/2009 $945 . 00 5/16/2009 $945. 0 MI 5/30/2009 $ 945 . 00 MI 6/13/2009 $945 . 00 MI 6/27/2009 $945. 00 MI 7/11/2009 $945 . 00 N N N N N N N N N N N N N N H H H H H H H H H H H H H H H 7/25/2009 $ 945 . 00 MI 4/19/2008 $540. 00 MI 5/3/2008 $540 . 00 MI 5/17/2008 $540 . 00 MI 5/31/2008 $540 . 00 MI 6/14/2008 $540 . 00 MI 6/28/2008 $540 . 00 MI 7/12/2008 $540 . 00 MI 7/26/2008 $540 . 00 MI 8/9/2008 $540. 00 MI 8/23/200 $540. 00 MI 9/6/2008 $540 . 00 MI 9/20/2008 $540 . 00 MI 10/4/2008 $540. 00 MI 10/18/2008 $540 . 00 106% Page 5 of 11 2543 words English (United States) Accessibility: Investigate Focus +2 . G ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 AA ab Wrap Text v General LIX V V LY AP - O. Paste IUV DVAv SEE Merge & Center v $ ~ % " 00 0 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State A B E H 1 J K L M N P Q R S T U V W X Y 201 IL 367.35 251.10 1 16.25 0.00 2/27/0 202 IL 556.05 396.0 160.00 0.00 2/7/09 203 IL 510.94 350.94 160.00 0.00 2/21/09 204 IL 508.45 376.95 131.50 0.00 3/7/09 205 IL 535.09 382.59 152.50 0.00 3/21/09 206 IL 505.75 351.25 154.50 0.00 4/4/09 207 IL 529.07 369.07 160.00 0.00 4/18/09 208 IL 572.90 415.90 157.00 0.00 5/2/09 09 IL 553.81 396.56 157.25 0.00 5/16/09 210 IL 461.81 352.6 109.17 0.00 5/30/09 211 IL 489.53 354.76 134.77 0.00 6/13/09 212 IL 487.09 371.57 115.52 0.00 6/27/09 213 IL 480.67 338.67 148.00 0.00 7/1 1/09 214 IL 450.18 329.18 121.00 0.00 7/25/09 215 IN 187.38 86.00 101.38 0.00 7/25/09 216 IN 363.75 03.75 160.00 0.00 4/19/08 217 IN 374.00 216.00 158.00 0.00 5/3/08 218 IN 348.50 196.50 152.00 0.00 5/17/08 219 IN 344.8 208.80 136.00 0.00 5/31/08 220 IN 350.67 06.6 144.00 0.00 6/14/08 221 IN 369.00 217.00 152.00 0.00 6/28/08 222 IN 240.35 136.35 104.00 0.00 7/12/08 223 I 267.75 151.75 116.00 0.00 7/26/08 224 IN 304.75 148.75 156.00 0.00 8/9/08 225 IN 312.00 152.00 160.00 0.00 8/23/08 226 IN 249.20 133.20 116.00 0.00 9/6/08 227 IN 305.00 152.00 153.00 0.00 9/20/08 228 IN 294.7 148.70 146.00 0.00 10/4/08 229 IN 301.00 142.00 159.00 0.00 10/18/08 230 IN 299.75 147.75 152.00 0.00 11/1/08 231 IN 0.00 J J N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N - . 290.0 145.00 145.00 11/15/08 232 I 226.10 124.10 102.00 0.00 11/29/08 233 IN 251.75 142.75 109.00 0.00 12/13/08 234 IN 206.05 111.55 94.50 0.00 2/27/0 235 IN 332.67 153.00 179.67 0.00 2/7/09 236 IN 259.07 152.00 107.07 0.00 2/21/09 237 IN 257.62 154.00 103.62 0.00 3/7/09 238 IN 246.66 54.25 92.41 0.00 3/21/09 239 IN 247.35 144 80 102.55 0.00 4/4/09 240 IN 255.0 152.00 103.00 0.00 /18/09 241 I 279.25 153.00 126.25 0.00 5/2/09 242 IN 265.92 148.50 117.42 0.00 5/16/09 243 IN 256.72 140.05 116.67 0.00 5/30/09 244 I 270.96 162.25 113.71 0.00 6/13/09 245 I 259.83 152.00 107.83 0.00 6/27/09 246 M 308.0 235.00 73.00 0.00 4/19/08 247 M 298.30 218.30 80.00 0.00 5/3/08 248 M 298.00 232.00 66.00 0.00 5/17/08 249 M 265.60 193.60 72.00 0.00 5/31/08 250 M 289.67 209.67 80.00 0.00 6/14/08 Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%AH ? CGOP ... Document1 Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 12 A" A Aa Ap EEVEEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE V V Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste BI Uvab X X|A DAY Pane MI 11/1/2008 $540. 00 MI 2 11/15/2008 $540 . 00 MI 11/29/2008 $540 . 00 MI 12/13/2008 $540 . 00 MI 12/27/2008 $540. 00 MI 2/7/2009 $540. 00 MI NNN NN NN 2/21/200 $540 . 00 MI 3/7/2009 $540 . 00 MI 3/21/2009 $540 . 00 MI 4/4/2009 $540 . 00 MI 4/18/2009 $540. 00 MI UNNNN 5/2/2009 $540. 00 MI 5/16/2009 $540 . 00 MI 5/30/2009 $540. 00 MI 6/13/2009 $540 .00 MI NNN 6/27/2009 $540 . 00 7/11/2009 $540. 00 MI 2 7/25/2009 $540 . 00 4/19/200 $585. 0 MI 5/3/2008 $585. 00 w w ww MI 5/17/2008 $585 . 00 MI 5/31/2008 $585. 00 MI 6/14/2008 $585 . 00 6/28/2008 $585.00 MI 7/12/2008 $585. 00 MI 7/26/2008 $585 . 00 MI 8/9/2008 $585. 00 ww ww ww ww MI 8/23/2008 $585 . 00 MI 9/6/2008 $585.00 MI 9/20/2008 $585 . 00 MI 10/4/2008 $585. 00 MI 10/18/2008 $585. 00 MI 11/1/2008 $585. 00 MI www 11/15/2008 $585. 00 MI 11/29/2008 $585 . 00 MI 12/13/2008 $585 . 00 MI 12/27/2008 $585 . 00 MI www 2/7/2009 $585. 00 MI 2/21/2009 $585 . 00 MI 3/7/2009 $585 . 00 MI 3/21/2009 $585 . 00 MI 4/4/2009 $585. 00 MI 4/18/2009 $585 . 00 MI 5/2/2009 $585. 00 MI 5/16/2009 $585 . 00 MI 5/30/2009 $585 . 00 MI 6/13/2009 $585 . 00 HHH HH W W W W W W W w ww 6/27/2009 $585 . 00 MI 7/11/2009 $585.00 7/25/2009 $585 . 00 MS 4/19/2008 $870. 00 MS 5 / 3 / 2008 $870.00 5/17/2008 $870. 00 5/31/200 $870.00 GELEE 6/14/2008 $870.00 6/28/2008 $870 . 00 7/12/2008 $870 . 00 English (United States) Accessibility: Investigate Focus + 106% Page 6 of 11 2543 words2 . C ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 AA ab Wrap Text v General LIX V V Conditional Format Cell Insert Delete Format Sort & Find & Analyze Paste BIUV vAv SEE Merge & Center v $ ~ % " Formatting as Table Styles Filter Select Data A1 X V fx State E F H 1 J K L M N 0 P Q R S T U V W X B 251 282.63 234.63 48.00 0.00 6/28/08 252 273.60 201.60 72.00 0.00 7/12/08 253 95.60 115.60 80.00 0.00 7/26/08 254 94.23 0.00 94.23 0.00 8/9/08 255 87.54 0.00 87.54 0.00 8/23/08 256 79.23 0.00 79.23 0.00 9/6/08 257 63.61 0.00 63.61 0.00 9/20/0 258 00 0 0.00 0.0 0.00 10/4/08 259 29.00 0.00 29.00 0.00 2/7/09 260 63.00 0.00 63.00 0.00 2/21/09 261 19.50 0.00 19.50 0.00 3/7/09 262 9.00 0.00 9.00 0.00 3/21/09 263 39.0 0.00 39.00 0.00 4/4/09 264 14 50 0.00 44.50 0.00 4/18/09 265 44.00 0.00 44.00 0.00 5/2/09 266 18.08 0.00 48.08 0.00 5/16/09 267 67.66 0.00 67.66 0.00 5/30/09 268 79.33 0.00 79.33 0.00 6/13/09 269 151.17 72.00 79.17 0.00 6/27/09 270 134.56 64.80 69.76 0.00 7/1 1/09 271 151.9 2.00 79.92 0.00 7/25/09 272 192.88 107.38 85.50 0.00 4/19/08 273 144.18 67.68 76.50 0.00 5/3/08 274 201.75 117.50 84.25 0.00 5/17/08 275 179.0 90.30 73.25 15.50 5/31/08 276 256.75 21.75 54.00 81.00 6/14/08 277 255.5 135.79 69.75 50.00 6/28/08 278 45.46 139.71 64.25 41.50 7/12/08 279 55.82 154.82 56.50 44.50 7/26/08 280 248.3 149.34 53.50 45.50 8/9/08 281 256.4 135.17 73.75 47.50 3/23/0 282 240.66 126.64 67.52 46.50 9/6/08 283 259.5 156.58 54.00 49.00 9/20/08 284 282.9 155.15 81.25 46.50 10/4/08 285 292.2 167.59 77.75 46.92 10/18/08 286 ( N N N N N N N N N N N N N N N N N N N N N N N N N NN NN- 279.5 158.08 82.48 39.00 11/1/08 287 261.50 149.25 60.50 51.75 11/15/08 288 229.10 123.10 64.00 42.00 1/29/08 289 262.5 143.75 79.00 39.83 12/13/08 290 205.1 114.10 65.00 26.00 12/27/08 291 231.5 129.50 82.00 20.00 2/7/09 292 238.5 138.50 80.00 20.00 2/21/09 293 249.0 153.50 75.00 20.50 3/7/09 294 44.50 143.50 80.00 21.00 121/09 295 253.50 153.50 78.00 22.00 4/4/09 296 256.00 149.00 80.00 27.00 4/18/09 297 257.1 41.13 80.00 36.00 5/2/09 298 263.6 152.50 77.00 34.17 5/16/09 299 221.5 135.80 52.00 33.75 5/30/09 300 227.5 143.00 46.48 38 02 6/13/09 cinzinn Hours Visits & Charges Labor Expenses + + 100% Ready Accessibility: Good to goAH ? CGOP ... Document1 Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 12 A" A Aa Ap AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE MV V Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste BI U vab X X |A DAY Pane 7/26/2008 $870 . 00 8/9/2008 $870 . 00 8/23/2008 $870 .00 9/6/2008 $870.00 9/20/2008 $870 . 00 10/4/2008 $870 . 00 10/18/2008 $870. 00 11/1/2008 $870. 00 11/15/2008 $870 .00 11/29/200 $870 . 00 12/13/2008 $870.00 12/27/2008 $870 . 00 2/7/2009 $870. 00 2/21/2009 $870 . 00 3/7/2009 $870.00 3/21/2009 $870. 00 4/4/2009 $870 . 00 4/18/2009 $870.00 5/2/2009 $870. 00 5/16/2009 $870 . 00 5/30/2009 $870 . 00 6/13/2009 $870.00 6/27/2009 $870 .00 7/11/2009 $870. 00 7/25/2009 $870.00 4/19/2008 $ 960.00 H H H P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P H H H H H 5/3/2008 $960 . 00 5/17/2008 $960.00 5/31/2008 $960.00 6/14/2008 $960. 00 OH 6/28/2008 $960.00 7/12/2008 $960.00 OH 7/26/2008 $960.00 8/9/2008 $960 . 00 8/23/2008 $960. 00 9/6/2008 $960. 00 OH 9/20/2008 $960.00 OH 10/4/2008 $960. 00 OH 10/18/2008 $960 . 00 OH 11/1/2008 $960.00 11/15/200 $960.00 OH 11/29/2008 $960.00 OH 12/13/2008 $960 . 00 OH 12/27/2008 $960. 00 OH 2/7/2009 $960 . 00 OH 2/21/2009 $960 . 00 OH 3/7/2009 $ 960 . 00 3/21/2009 $960.00 OH 4/4/2009 $960. 00 OH 4/18/2009 $ 960 . 00 OH 5/2/2009 $960 . 00 OH 5/16/2009 $960 . 00 OH 5/30/2009 $960 . 00 6/13/2009 $960.00 OH 6/27/2009 $960. 00 OH 7/11/2009 $ 960. 00 OH 7/25/2009 $960 . 00 + Page 7 of 11 2543 words English (United States) Accessibility: Investigate Focus E 106%2 . G ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 AA ab Wrap Text v General LIX V V LY AP - O. Paste BIUV vAv Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Formatting as Table Styles DV Find & Analyze Filter Select Data A1 X V fx State A B E H 1 J K L M N 0 P Q R S T U V W X 301 MI 214.50 143.50 30.00 41.00 6/2 /709 302 MI 215.54 141.54 29.00 45.00 7/1 1/09 303 MI 241.16 152.66 33.00 55.50 7/25/09 304 MI 170.05 88.80 72.00 9.25 AWWWWONN N 4/19/08 05 MI 177.40 97.40 80.00 0.00 5/3/08 306 MI 176.5 96.50 80.00 0.00 5/17/08 307 MI 152.60 80.60 72.00 0.00 5/3 1/08 08 MI 175.20 95.20 80.00 0.00 6/14/08 309 MI 157.80 77.80 80.00 0.00 6/28/08 310 M 151.20 78.20 73.00 0.00 7/12/08 1 1 Ml 152.60 72.60 80.00 0.00 7/26/08 312 M 146.01 66.00 80.01 0.00 8/9/08 313 M 143.6 63.00 76.67 4.00 8/23/08 314 M 123.10 57.60 65.50 0.00 9/6/08 315 MI 146.46 64.80 77.9 3.75 /20/08 316 MI 166.48 85.48 81.00 00 0 0/4/0 317 M 198.47 118.47 80.00 0.00 10/18/08 318 MI 193.32 114.06 79.26 0.00 11/1/08 319 M 188.55 112.80 75.75 0.00 11/15/08 320 MI 151.50 87.50 64.00 0.00 11/29/08 321 M 192.00 112.00 80.00 0.00 12/1 3/0 322 M 157.90 97.40 60.50 0.00 12/27/08 323 MI 3 190.6 110.60 80.00 0.00 2/7/09 $24 MI 84.3 111.60 72.75 0.00 2/21/09 325 M " W W WW WW WW ON 177.20 101.70 75.50 0.00 3/7/09 326 M 173.70 93.70 80.00 0.00 121/09 327 M 157.70 85.70 72.00 0.00 4/4/09 328 MI 165.60 90.60 75.00 0.00 4/18/09 329 MI 165.05 93.80 71.25 0.00 5/2/09 330 M 175.90 95.90 80.00 0.00 5/16/09 331 M 148.75 82.50 48.25 18.00 5/30/09 332 MI 3 157.15 85.15 72.00 0.00 6/13/09 $33 MI 173.80 93.80 80.00 0.00 6/27/09 334 M 171.60 91.60 80.00 0.00 7/1 1/09 335 MI 162.80 82.80 80.00 0.00 7/25/09 336 M 222.47 64.80 77.67 80.00 4/19/08 837 MS 228.95 70.20 78.75 80.00 5/3/08 338 MS 314.45 79.20 156.75 78.50 5/17/08 339 M 212.90 72.90 72.00 68.00 5/31/08 340 Ms 89.25 52.00 -2.75 40.00 6/14/08 341 MS 227.75 72.00 77.25 78.50 6/28/08 342 MS 167.72 64.80 44.67 58.25 7/12/08 343 MS 205.42 72.00 61.25 72.17 7/26/08 344 M 205.25 63.00 67.25 75.00 8/9/08 345 MS 209.8 72.00 64.00 73.83 123/08 346 MS 204.20 44.70 88.00 71.50 9/6/08 347 MS 244.3 59.20 106.67 78.50 9/20/08 348 M 214.00 52.00 83.50 78.50 0/4/0 349 MS 206.5 32 00 96.00 78.50 10/18/08 350 MS 194.50 32.00 84.00 78.50 11/1/08 innn on an 70 25 A4MEMO Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%AH ? CGOP ... Document1 Share Comments Home Insert Draw Design Layout References Mailings Review View ? Tell me Calibri (Bo... v 12 A" A Aa Ap EV EVEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Norma BIUvab X X A L Av Pane Paste 4/19/2008 $870 . 00 OH 5/3/2008 $870 . 00 OH 5/17/2008 $870. 00 OH 5/31/2008 $870.00 NNNN NN NN OH 6/14/2008 $870 . 00 OH 6/28/2008 $870 . 00 OH 7/12/2008 $870. 00 7/26/2008 $870 . 00 OH 8/9/2008 $870. 00 OH 8/23/2008 $870. 00 OH 9/6/2008 $870. 00 9/20/2008 $870 .00 OH NNNNN NN 10/4/2008 $870. 00 OH 10/18/2008 $870 . 00 OH 11/1/2008 $870. 00 OH 11/15/2008 $870. 00 OH 11/29/2008 $870 . 00 OH 12/13/2008 $870.00 12/27/2008 $870. 00 OH 2/7/2009 $870 . 00 NNNN NN 2/21/2009 $870. 00 OH 3/7/2009 $870. 00 3/21/2009 $870 . 00 OH 4/4/2009 $870 . 00 4/18/200 $870.00 OH 5/2/2009 $870.00 OH 5/16/2009 $870 . 00 5/30/2009 $870 . 00 W W N N N N N N N N N N OH 6/13/2009 $870.00 6/27/2009 $870.00 OH 7/11/2009 $870 .00 7/25/2009 $870. 00 OH 4/19/200 $750. 00 5/3/2008 $750 . 00 OH 5/17/2008 $750 . 00 5/31/2008 $750. 00 OH 6/14/2008 $750. 00 OH 6/28/2008 $750 . 00 OH 7/12/2008 $750 . 00 OH 7/26/2008 $750 . 00 ww ww ww ww ww 8/9/2008 $750 . 00 OH 8/23/200 $750 . 00 OH 9/6/2008 $750 . 00 OH 9/20/2008 $750. 00 OH 10/4/2008 $750 . 00 OH 10/18/2008 $750 . 00 OH 11/1/2008 $ 750 . 00 11/15/200 $750 . 00 w ww ww ww w OH 11/29/2008 $750 . 00 OH 12/13/2008 $750. 00 OH 12/27/2008 $750 . 00 2/7/2009 $750 . 00 OH 2/21/2009 $750 . 00 3/7/2009 $750 . 00 OH 3/21/2009 $ 750. 00 ww ww OH 4/4/2009 $750 . 00 OH 4/18/2009 $750 . 00 + 106% English (United States) Accessibility: Investigate Focus Page 8 of 11 2543 words2 . G ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 VA A ab Wrap Text General LIX V V LY AP - O. Paste IUV vAv SEE Merge & Center v $ ~ % " 00 0 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State A B D E G H I J K L M N P Q R S T U V W X Y 351 MS 90.2 32.00 80.00 78.25 11/15/08 352 MS 158.00 28.00 66.00 64.00 11/29/08 353 MS 94.00 23.00 71.00 0.00 12/13/08 354 MS 36.0 30.00 76.00 30.00 12/27/08 SW Cq 218.00 38.00 108.00 72.00 2/7/09 356 MS 134.50 34.50 100.00 0.00 2/21/09 357 MS 205.50 31.00 96.00 78.50 3/7/09 358 MS 170.00 42.00 92.00 36.00 3/21/09 359 MS 165.92 0.00 94.00 71.92 4/4/09 360 MS 184.50 4.50 100.00 80.00 4/18/09 361 MS 232.50 44.50 100.00 88.00 5/2/09 362 MS 197.50 1.50 92.00 64.00 5/16/09 63 MS 180.50 28.50 80.00 72.00 5/30/09 364 MS 193.50 29.50 84.00 80.00 6/13/09 365 MS 267.00 105.00 89.00 73.00 6/27/09 366 MS 251.8 107.30 72.50 72.00 7/1 1/09 367 MS 268.50 104.50 84.00 80.00 7/25/09 368 OH 223.25 59.25 155.50 8.50 4/19/08 369 OH 263.58 78.75 160.00 24.83 5/3/08 370 OH 286.91 79.25 160.00 47.66 5/17/0 371 OH 287.60 93.10 149.50 45.00 5/31/08 372 0 263.00 53.50 159.00 50.50 6/14/08 373 OH 242.75 49.00 160.00 33.75 6/28/08 374 OH 200.38 17.40 139.00 43.98 7/12/08 375 OH 239.33 116.00 80.00 43.33 7/26/08 376 0 245.65 113.65 80.00 50.00 8/9/08 377 OH 279.00 155.50 80.00 43.50 8/23/08 378 OH 224.55 127.55 72.00 25.00 9/6/08 379 OH 219.25 135.50 67.75 16.00 9/20/08 380 223.50 138.00 80.00 5.50 10/4/08 I OH 244.0 143.00 77.00 24.00 10/18/08 382 OH 211.20 11.70 80.00 19.50 11/1/08 383 OH 237.30 130.05 76.75 30.50 1/15/08 4 /OH 174.50 94.50 64.00 16.00 11/29/08 385 0 145.35 65.35 80.00 0.00 2/13/08 386 OH 196.55 109.80 86.75 0.00 12/27/08 387 OH 217.00 123.00 78.00 16.00 2/7/09 388 OH 217.50 106.00 80.00 31.50 2/21/09 389 0 239.00 131.50 80.00 27.50 3/7/09 390 OH 253.60 138.60 80.00 35.00 3/21/09 391 OH 246.80 136.80 80.00 30.00 4/4/09 392 OH 257.45 42.20 80.00 35.25 4/18/09 3 OH 212.10 117.10 80.00 15.00 5/2/09 394 0 239.0 117.00 71.00 51.00 5/16/09 395 OH 213.05 102.80 71.75 38.50 5/30/09 396 OH 262.50 109.00 80.00 73.50 6/13/09 397 OH 237.47 105.30 80.00 52.17 6/27/09 8 OH 250.2 102.00 72.00 76.25 7/1 1/09 9 OH 259.23 108.00 80.00 71.23 7/25/09 400 OH UN 275.90 210.90 65.00 0.00 1/19/08 401 OH 215 46 213 80 21 66 5/3/08 Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%AH ? CGOP ... Document1 Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 12 A" A Aa Ap EV EVEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Paste BIUvab X X A L Av Pane 5/2/2009 $750 . 00 OH 5/16/2009 $ 750 . 00 OH 5/30/2009 $750 . 00 OH 6/13/2009 $750 . 00 OH 6/27/2009 $750 . 00 OH 7/11/2009 $750 . 00 OH - ww 7/25/2009 $750. 00 SC 4/19/2008 $990 . 00 SC 5/3/2008 $990 . 00 SC 5/17/2008 $990. 00 sc 5/31/2008 $990. 00 SC 6/14/2008 $990 . 00 sc 6/28/2008 $990.00 SC 7/12/2008 $990 . 00 sc 7/26/2008 $990 . 00 SC 8/9/2008 $990. 00 SC 8/23/2008 $990 . 00 SC 9/6/2008 $990. 00 SC 9/20/200 $990 . 00 SC 10/4/2008 $990 . 00 SC 10/18/2008 $990 . 00 sc 11/1/2008 $990 . 00 SC 11/15/2008 $990 . 00 SC 11/29/2008 $990 . 00 SC 12/13/2008 $990. 00 SC 12/27/2008 $990 . 00 IN 4/19/2008 $525 . 00 IN 5/3/ 2008 $525 . 00 IN 5/17/2008 $525. 00 IN 5/31/2008 $525 . 00 IN 6/14/2008 $525. 00 IN 6/28/2008 $525 . 00 7/12/2008 $525. 00 IN 7/26/2008 $525. 00 IN 8/9/2008 $525. 00 IN 8/23/200 $525 . 00 9/6/2008 $525.00 IN 9/20/2008 $525. 00 IN 10/4/2008 $525 . 00 IN 10/18/2008 $525 . 00 IN 11/1/2008 $525 . 00 IN 11/15/2008 $525 . 00 IN 11/29/2008 $525 . 00 IN 12/13/2008 $525 . 00 IN 12/27/2008 $525. 00 IN 2/7/2009 $525. 00 IN 2/21/2009 $525. 00 IN 3/7/2009 $525 . 00 IN 3/21/2009 $525 . 00 IN 4/4/2009 $525 . 00 IN 4/18/2009 $525. 00 IN 5/2/2009 $525. 00 IN 5/16/2009 $525. 00 IN 5/30/2009 $525. 00 IN 6/13/2009 $525 . 00 IN 6/27/2009 $525 . 00 TN 7/11/2009 $525 . 00 106% English (United States) Accessibility: Investigate Focus E + Page 9 of 11 2543 words2 . C ... Sample Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 AA ab Wrap Text v General LY AP - O. Paste BIU DVAv SEE Merge & Center v $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx State C D E G H 1 J K L M N 0 P Q R S T U V W X Y 401 315.46 213.80 80.00 21.66 5/3/08 402 308.02 203.35 80.00 24.67 5/17/08 403 293.90 193.10 69.56 31.24 5/31/08 404 320.55 211.60 68.00 40.95 6/14/08 405 316.93 198.80 77.00 41.13 128/0 406 281.20 80.4 69.00 31.75 7/12/08 407 302.81 189.20 80.00 33.61 7/26/08 408 324.60 213.90 79.50 31.20 8/9/08 409 308.58 192.90 78.00 37.68 8/23/08 410 308.51 192.60 74.00 41.91 9/6/08 411 317.16 196.57 80.00 40.59 9/20/08 412 330.57 214.90 34.17 10/4/08 413 325.60 215.60 21-50 87.00 23.00 10/18/08 414 310.66 197.91 81.00 31.75 11/1/08 415 342.19 226.85 80.00 35.34 11/15/08 416 271.26 170.17 73.00 28.09 11/29/08 $17 $22.71 208.70 80.00 34.01 12/1 3/0 418 284.65 194.00 61.00 29.65 2/27/08 419 305.58 96.5 80.00 29.08 2/7/09 420 313.04 204.20 80.00 28.84 2/21/09 421 317.05 211.30 80.00 25.75 3/7/09 422 286.05 190.05 80.00 16.00 /21/09 423 307.10 210.60 80.00 16.50 4/4/09 424 316.45 221.20 80.00 15.25 1/18/09 425 322.85 226.60 88.00 8.25 5/2/09 N W W W W W W W W W WW WW WW WW WWNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN 426 308.35 217.60 77.00 13.75 5/16/09 427 281.45 198.20 72.00 11.25 /30/0 428 297.95 195.70 80.00 22.25 6/13/09 429 297.25 185.50 76.00 35.75 6/27/09 430 254.80 152.55 72.00 30.25 7/1 1/09 431 321.12 210.37 75.00 35.75 125/0 432 242.00 162.00 80.00 00 0 4/19/08 433 228.50 148.50 80.00 0.00 5/3/08 434 223.50 159.50 64.00 0.00 5/17/08 435 189.50 117.00 72.50 0.00 131/0 436 238.00 158.00 80.00 0.00 6/14/08 137 224.00 52.0 72.00 0.00 6/28/08 438 190.00 126.00 64.00 0.00 7/12/08 439 216.00 144.00 72.00 0.00 7126/0 440 222.50 159.50 63.00 0.00 8/9/08 441 225.00 145.00 80.00 0.00 8/23/08 442 191.52 34.0 57.52 0.00 9/6/08 443 222.00 166.00 56.00 0.00 9/20/08 444 184.00 121.00 63.00 0.00 10/4/08 445 219.50 147.50 72.00 0.00 0/18/0 446 228.23 148.23 80.00 0.00 11/1/08 447 221.50 149.50 72.00 0.00 11/15/08 448 193.00 124.00 69.00 0.00 11/29/08 449 209.00 151.50 57.50 0.00 12/13/08 450 140.00 84.00 56.00 0.00 12/27/0 451 107 nn 125 00 72 0n 2/7/0Q Hours Visits & Charges Labor Expenses + Ready Accessibility: Good to go + 100%w w The purpose of these exercises is to get you more comfortable building a dataset from multiple sources, and then analyzing it to provide further insight. You will likely need to reference the \"Excel Notes\" that I've provided. [recommend saving the notes to your computer desktop so that you have them for a reference whenever you may need them in the future. The exercises will start out with some of the simpler commands (e.g. adding columns together), and progress to more complicated commands (eg. concatenate, vlookup, etc.) With continued practice on, and comfort with, the commands below, you will be able to creatively apply what you've leamed to conduct analysis that meets the overwhelming majority of the data analysis needs of even the largest companies across all industries. Feel free to work at your own pace. NOTE : All commands discmsed are for PC '5. If you have an Apple computer, some command: may be slightly different. Files Save all four of the files provided to an accessible location. Begin by opening the le titled "Sample Data". Take a moment to assess the data provided. It is an example dataset of a national physical therapy provider. On the \"Hours" tab, you should see seven columns and 610 rows. It provides you with clinics across different states, with the labor hours worked at that clinic for that PPE (pay period ending). \"Clinical\" refers to physical therapists, \"Support Staff\" refers to physical therapy aides, and \"Non-Clinica " refers to administrative staff (people like you and me). As you can certainly ascertain yourself, the data is by state, by clinic, by PPE (two week periods) because that is when hours are reported (for payroll purposes). On the \"Visits & Charges" tab, you'll see the gross charges (before insurance adjustments), visits (patient Visits to the clinic), and units (number of CPT codes (number to identify what was performed on the patient) executed). Again, these are broken down by state, by clinic, by PPE, Whv is the data in the "Visitr & Charges " tab categorized by state by clinic by PPE? Certainly, you might think, this data could be displayed by other date ranges. You would be correct in drinking this. However, if we want to examine the charges, visits, and units with respect to the labor it took to generate this production, then it needs to match the date ranges that we have for the hours worked. This is why the data was pulled by PPE. Lastly, you'll see the \"Labor Expenses\" tab This tab is almost identical to the \"Hours\" tabr Except, this time, we have the money spent on each labor category instead of the hours worked for that PPE at that clinic in that state. Also, where we have the total hours worked by all labor categories, we don't have the total money spent on all labor categories combined. Part I Sum Let's use this opportunity to create a column that sums the individual labor expense buckets. In cell 01, type \"l'otal Exp". Now, in cell 62, add the three labor expense categories together. You can do this in a couple of different ways, both illustrated below. =d2+e2+f2 You should get $19,658.51 for state=A1, clinic=1, and PPEt/19/20008. This approach is straightforward, but could become long and cumbersome if you have a large number of columns to add together. Alternatively, you could use the following: =sum(d2 : f2) With this command, you are telling Excel that you want to sum a group of numbers. \"d2\" tells Excel where to start. The colon after that basically tells Excel \"and keep going until\". Then you type the cell where you want to tell Excel to stop, f2 in our case. This same approach can be used to sum cells in the same column (e.g. =surn(d2:d610)). We now have the three labor categories summed for the second row. However, we need to sum them for all of the rows. You could repeatedly type one of the above commands into each corresponding cell in column G. However, I doubt you want to do that. Moreover, your boss will probably be upset with you for spending that much time performing that task. Instead try one of these three possible alternatives. 1) If you click on cell 62, you should see a bold black outline around the cell. In the bottom right comer of that should be a little black box. If you click and drag that box all the way to row 610, it will copy the formula down for all of the rows (automatically adjusting the formula for the row that it is in). Instead of perfomring the click and drag, double-click on that same black box. It should send the formula all the way down in the same manner that the click and drag did. NOTE: Be carell with this method. Sometimes, if there is an empty cell in one of the neighboring columns, it will stop there instead of going all the way down. Always double-cheek to make sure it went all the way down. You could also copy the formula (right-click on the cell or, aer selecting the cell, hit Ctrl+c), and then paste it into the desired cells. Paste by highlighting the cells, right- clicking and selecting paste. Alternatively, you could highlight the cells and hit Ctrl+v to paste the formula into the cells. Open Formulas It's good practice to not leave active formulas in your spreadsheet unless you have good reason to do so. There are many reasons for this. If you accidentally change data in one of the referenced columns, it will also make the new value change. Also, Excel doesn't have the \"horsepower\" that the more advanced statistical software packages have. It is constantly performing the formulas you have open, displaying the returned answer. The more of these you have going, the slower Excel becomes. Lastly, if you want to perform a vlookup (referenced later) to bring data over to another location, Excel won't nd the data needed. In Excel's mind, the only thing there is a formula. Paste Special Values It's important to remember that, when you have active formulas, the value being displayed isn't what's actually in the cell. The formula is in the cell. However, this is easily changed by using a version of copy and paste. Take column G (with the sum formula active for all of the rows), and copy the entire column by right-clicking on the entire column (right click on the \"G" at the top of the column). After you've copied it, we're going to paste the actual values (the sums desired) right on top of the formulas. To do this, rst right-click on the entire column again. This time, we're going to \"paste special values\" by selecting the clipboard that has \"1 2 3" on it. Now instead of the cells having active formulas in them, the actual values from the equation are what Excel recognizes as being in the cell. The formulas themselves are now gone. Get External Data We've got a lot of valuable data between the three tabs. There is another key piece of information, though, that we don't yet have in this le RENT! Rent for the facility is a vital, factor to consider. This information is in a separate le titled \"Rent\". But, it's not an Excel le. It's a text file. Again, you're likely to have data sent to you from many different sources. A lot of soware packages will export data as a text le. Not to worry, though. Excel can bring it into a spreadsheet relatively easily. First, you need to insert a new spreadsheet. Along the row of tabs at the bottom (Hours, Visits & Charges, Labor Expenses), you should see a \"+\" at the end. Click on that to insert a new sheet. Make sure that cell Al is selected. This way, when we import the rent data, it starts it in cell A1. Now, along the top row of tabs (Home, Insert, etc.), select \"DATA\". Then, within \"Get External Data", select \"From Text\". It will then have you select the le. Find the \"Rent\" le that you saved, and select it. The Text Import Wizard should now pop up. In Step 1, you need to select how Excel should separate the information in your le into different columns. \"Fixed Width" means that there is a distinct distance marking that should be used to begin each new column. If you use this, it will give you the ability to tell Excel where each distance marking for a new column should be. However, the data here is \"Delimited\here, so simply click \"Finish". Make sure, in the following pop up box, that you put the data into the existing work sheet starting in Al (=$A$l). You should now have four columns in this new tab: State, Clinic, PPE, and Rent. Label this newly created sheet \"Rent" by double-clicking on the tab at the bottom (will likely currently say \"Sheetl\information in that cell. Knowing what it needs to match on, Excel now wants to know where to go looking. So, after the \\"Fields, Items, & Sets", then choose \"Calculated Field\". You should see a pop-up box allowing you to name the new eld and enter the formula. Let's name it \"Productivity". In the formula box, type the following: = Visits/( 'Clinical Hours/8) For \"Visits\" and \"Clinical Hours\explanatory variables (Input X Range). Doing this should provide you with an output similar to what is below: SUMMARY OUTPUT Regression Statistics 0.618995 Multiple R 847 0.383155 R Square 859 Adjusted R 0.380097 Square 128 97.46219 Standard Error 147 Observations 309 ANOVA Significanc df SS MS OF 3569667.34 1189889. 125.2662 4.11398E- Regression 3 115 703 63 5746821.65 9498.878 Residual 605 766 9316488.99 Tota 608 Coefficien Standard Upper Lowe Upper Error t Stat P-value Lower 95% 95% 95.0% 95.0% 19.65314 10.0991628 1.946017 0.052115 39.48682 0.180526 39.48682 Intercep 67 414 297 0.1805266 011 011 0.768673 0.05825582 13.19478 4.05034E- 0.6542648 0.883081 0.654264 0.883081 Clinical Hours 057 38 35 55 259 855 259 Non-Clinical 0.354490 0.12808997 2.767508 0.005821 0. 1029350 0.606045 0.102935 0.606045 Hours 05 238 76 024 076 024 Support Staff 0.392661 0.05750685 6.828082 2.09842E- 0.2797242 0.505598 0.279724 0.505598 Hours 562 5 677 62 862 262 862 While this is not a statistically strong model for many reasons, this exercise does at least walk you through how to perform a basic regression in Excel. It gives you various measures for the "goodness of fit" for the model. Here, we have an Adjusted R-square of 0.38. Meaning that about 38% of the variation in the number of visits is explained by the explanatory variables here. The coefficient estimates tell us more precisely the impact that a change in any of one those variables (the various hours worked categories) has on the number of visits. The P-value tells us the level of statistical significance that each of those coefficient estimates has (how much we can trust it). Again, this is a rough regression meant for illustration purposes only. However, you are encourages to try alternate regressions with different dependent and explanatory variables to see how it changes. Page 12 of 12