Spreadsheet: 108021d1305131420-vlookup-assistance-vlookup
Sheet: 2011 2nd Qtr

FMIS Effective Date | Fiscal_Year | St | Project-No-w\Suffix | State_Project_No | Expenditure_Date | Last_Action_Date | Authorization_Date | Total_Cost | Federal_Funds | Expenditure_Amt | Unexpended_Bal | Fiscal_Quarter | Value Tier | Date Tier | TIER | CF
 | 2011 | PJ | 0011032-00 | 736_99_1521 | 2009-11-09 11:41:29 | 2009-11-09 11:41:29 | 2008-07-01 00:00:00 | 4938198 | 3950558.5 | 3269265.56 | 681292.94
 |  | PJ | 1607501-00 | 106_02_0011,H.001793 | 2009-12-14 08:46:27 | 2011-01-14 12:02:18 | 2009-07-02 00:00:00 | 2040000 | 1632000 | 11826.47 | 1620173.53
 |  | PJ | 1701515-00 | 450_10_0124 | 2009-11-09 11:41:30 | 2010-09-02 17:24:38 | 2003-07-21 00:00:00 | 13806139 | 10923406.76 | 10240028.8 | 683377.959999999
 |  | PJ | 5102506-00 | 714_51_0007 | 2009-03-09 13:03:23 | 2009-11-18 09:15:53 | 2006-06-19 00:00:00 | 1727605 | 1382083.14 | 775677.23 | 606405.9100000001
 |  | PJ | ERE3025-00 | 700_92_0023 | 2009-10-08 03:01:28 | 2009-10-08 03:01:28 | 2008-09-01 00:00:00 | 3210000 | 3210000 | 1212383.02 | 1997616.98
 |  | PJ | LA08003-00 | 745_99_0017 |  | 2009-08-25 15:57:27 | 2009-08-24 00:00:00 | 818000 | 654400 | 0 | 654400
 |  | PJ | LA08004-00 | 745_99_0016 |  | 2009-08-25 15:58:34 | 2009-08-25 00:00:00 | 856800 | 685440 | 0 | 685440
 |  | PJ | LA08005-00 | 745_99_0018 |  | 2009-08-25 15:59:37 | 2009-08-24 00:00:00 | 1925020 | 1540016 | 0 | 1540016
 |  | PJ | TKUP001-00 | 737_99_0451 | 2009-04-08 12:23:51 | 2009-04-08 12:23:51 | 1997-11-01 00:00:00 | 9859981 | 8415000 | 7900241.21 | 514758.79
 |  | PJ | 0004201-00 |  | 2005-09-29 00:23:22 | 2010-09-20 15:30:21 | 2001-05-01 00:00:00 | 489115 | 489115 | 413799.34 | 75315.65999999997
 |  | PJ | 0121145-00 | 454_04_0053 | 2007-09-12 08:35:41 | 2008-08-25 10:07:24 | 2004-07-07 00:00:00 | 8854527 | 7969074 | 7854804.15 | 114269.8499999996
 |  | PJ | 1004540-00 | 744_10_0023 | 2008-11-20 10:20:00 | 2009-12-08 00:00:00 | 2006-06-22 00:00:00 | 287500 | 230000 | 2218.48 | 227781.52
 |  | PJ | 1703518-00 | 737_96_0040 | 2009-01-28 08:49:43 | 2009-01-28 08:49:43 | 2003-09-16 00:00:00 | 450000 | 360000 | 291103.21 | 68896.78999999998
 |  | PJ | 2107501-00 | 737_21_0001 |  | 2009-12-03 09:59:01 | 2008-04-02 00:00:00 | 306200 | 275580.37 | 0 | 275580.37
 |  | PJ | 2308510-00 | 737_23_0003 |  | 2009-03-16 15:33:50 | 2008-12-10 00:00:00 | 283787 | 283786.8 | 0 | 283786.8
 |  | PJ | 2506505-00 | 126_03_0013 | 2008-10-06 11:04:48 | 2008-10-06 11:04:48 | 2007-04-23 00:00:00 | 144250 | 115400 | 22529.57 | 92870.43
 |  | PJ | 2608508-00 | 450_15_0135 |  | 2008-05-15 15:47:26 | 2008-05-15 00:00:00 | 490800 | 392640 | 0 | 392640
 |  | PJ | 2807504-00 | 742_28_0003 |  | 2007-08-22 16:40:57 | 2007-04-24 00:00:00 | 247020 | 247020 | 0 | 247020
 |  | PJ | 2907504-00 | 742_29_0002 |  | 2007-09-12 16:53:44 | 2007-09-11 00:00:00 | 289520 | 289520 | 0 | 289520
 |  | PJ | 3608504-00 | 737_36_0015 |  | 2008-10-21 09:09:55 | 2008-10-14 00:00:00 | 300000 | 300000 | 0 | 300000
 |  | PJ | 3708502-00 | 737_37_0012 |  | 2008-08-20 15:39:20 | 2008-08-14 00:00:00 | 279400 | 279400 | 0 | 279400
 |  | PJ | 3803504-00 | 742_38_0004 | 2008-10-06 11:04:11 | 2009-12-08 00:00:00 | 2007-01-03 00:00:00 | 920000 | 736000 | 298540.26 | 437459.74
 |  | PJ | 4404504-00 | 714_44_0002 |  | 2005-05-17 16:31:44 | 2005-05-17 00:00:00 | 89920 | 89920 | 0 | 89920
 |  | PJ | 4707502-00 | 847_02_0030 |  | 2007-11-26 13:52:20 | 2007-11-26 00:00:00 | 55167 | 55167 | 0 | 55167
 |  | PJ | 4906500-00 | 700_03_0120 | 2008-07-17 08:47:51 | 2008-07-17 08:47:51 | 2007-11-19 00:00:00 | 238050 | 190440 | 1563.45 | 188876.55
 |  | PJ | 4907502-00 | 742_49_0001 |  | 2007-09-12 16:53:40 | 2007-09-11 00:00:00 | 50595 | 50595.2 | 0 | 50595.2
 |  | PJ | 5006023-00 | 700_17_0069,700_17_69 | 2009-01-28 08:49:40 | 2010-09-20 15:30:33 | 1987-05-01 00:00:00 | 2209362 | 2106071.7 | 1937302.71 | 168768.9900000002
 |  | PJ | 5107501-00 | 742_51_0001 |  | 2007-09-12 16:53:46 | 2007-09-12 00:00:00 | 309760 | 309760 | 0 | 309760
 |  | PJ | 5208504-00 | 737_52_0009 |  | 2009-04-14 15:33:35 | 2009-01-06 00:00:00 | 216000 | 216000 | 0 | 216000
 |  | PJ | 5506501-00 | 855_07_0013,H.008413 |  | 2011-01-28 13:57:12 | 2008-09-23 00:00:00 | 318000 | 254400 | 0 | 254400
 |  | PJ | 8368001-00 | 714_37_0102 | 2008-05-13 14:12:33 | 2008-05-13 14:12:33 | 2005-04-12 00:00:00 | 556300 | 556300 | 458230.05 | 98069.95000000001
 |  | PJ | 9408500-00 | 737_94_0049 |  | 2008-08-20 15:47:26 | 2008-08-07 00:00:00 | 67440 | 56200 | 0 | 56200
 |  | PJ | 9907540-00 | 744_99_0128 |  | 2010-09-07 16:11:53 | 2007-12-07 00:00:00 | 92000 | 73600 | 0 | 73600
 |  | PJ | 9908576-00 | 701_65_1192 |  | 2009-03-03 16:49:32 | 2009-01-13 00:00:00 | 86577 | 77918.94 | 0 | 77918.94
 |  | PJ | ERE1031-00 | 704_90_0008 | 2008-08-05 13:13:50 | 2008-08-08 12:23:25 | 2005-08-29 00:00:00 | 37955048 | 37955048 | 37533909.84 | 421138.1599999964
 |  | PJ | ERE1109-00 | 704_26_0008 | 2008-05-16 10:22:49 | 2009-03-23 13:31:11 | 2007-11-19 00:00:00 | 112169 | 112168.59 | 7775.37 | 104393.22
 |  | PJ | ERE2035-00 | 705_97_0005 | 2008-12-08 14:30:47 | 2008-12-08 14:30:47 | 2005-09-24 00:00:00 | 21114000 | 21113999.61 | 20868141.07 | 245858.5399999991
 |  | PJ | ERE2053-00 | 451_06_0141 |  | 2010-09-08 11:25:08 | 2005-09-24 00:00:00 | 52723 | 52723.2 | 0 | 52723.2
 |  | PJ | ERE3117-00 | 064_30_0037 |  | 2009-09-03 16:50:43 | 2008-09-01 00:00:00 | 218447 | 218446.75 | 0 | 218446.75
 |  | PJ | ERE4086-00 | 851_09_0007 |  | 2009-08-27 14:25:25 | 2008-09-13 00:00:00 | 157825 | 157825 | 0 | 157825
 |  | PJ | LA07001-00 | 745_35_0006,745_35_0007 |  | 2009-03-16 14:07:16 | 2009-01-25 00:00:00 | 187500 | 150000 | 0 | 150000
 |  | PJ | TPF5012-00 | 736_99_1017 | 2007-09-29 00:15:36 | 2007-09-29 00:27:26 | 2001-06-22 00:00:00 | 250000 | 250000 | 87708.03 | 162291.97
 |  | PJ | 0000240-00 | 736_99_1426 | 2008-01-09 10:20:20 | 2008-01-09 10:20:20 | 2007-01-01 00:00:00 | 397581 | 150000 | 150000 | 0
 |  | PJ | 0002001-00 |  | 1991-06-30 00:00:00 | 2010-09-20 15:30:13 | 1991-04-01 00:00:00 | 30000 | 30000 | 11368.44 | 18631.56
 |  | PJ | 0002153-00 |  | 1995-03-22 00:00:00 | 2010-09-20 15:30:14 | 1989-12-01 00:00:00 | 16000 | 16000 | 13447.56 | 2552.440000000001
 |  | PJ | 0002187-00 | 000_00_0064 | 2004-04-21 00:57:19 | 2010-09-20 15:30:17 | 1996-07-01 00:00:00 | 20000 | 20000 | 7974.51 | 12025.49
 |  | PJ | 003S034-00 | 714_03_0105 | 2003-09-04 13:34:25 | 2010-07-23 16:29:39 | 2000-12-01 00:00:00 | 159000 | 159000 | 155907.9 | 3092.100000000006
 |  | PJ | 0204054-00 | 451_08_0061 | 2007-10-22 10:14:30 | 2007-10-22 10:14:30 | 2001-05-01 00:00:00 | 4869138 | 4366368.86 | 4325053.94 | 41314.91999999993
 |  | PJ | 0305509-00 | 265_01_0045 | 2007-12-14 10:24:00 | 2007-12-14 10:24:00 | 2006-04-18 00:00:00 | 45027 | 45027 | 44798.13 | 228.8700000000026
 |  | PJ | 0704501-00 | 451_04_0049 | 2007-05-10 08:58:45 | 2007-05-10 08:58:45 | 2004-08-17 00:00:00 | 2033763 | 1829088.61 | 1824363.38 | 4725.229999999981
 |  | PJ | 0905517-00 | 700_09_0161 | 2007-04-13 09:33:56 | 2008-11-07 10:34:32 | 2006-05-11 00:00:00 | 515360 | 411920.94 | 411920.94 | 0
 |  | PJ | 1002506-00 | 031_06_0045 | 2007-08-13 13:11:04 | 2010-07-22 15:08:45 | 2003-03-10 00:00:00 | 168336 | 168336 | 158501.62 | 9834.380000000005
 |  | PJ | 1407501-00 | 085_08_0030 |  | 2007-04-19 13:45:29 | 2007-04-18 00:00:00 | 57500 | 46000 | 0 | 46000
 |  | PJ | 1604502-00 | 714_16_0005 | 2007-12-14 10:24:01 | 2007-12-14 10:24:01 | 2005-03-03 00:00:00 | 194980 | 194980 | 186717.94 | 8262.059999999998
 |  | PJ | 1604503-00 | 714_16_0007 | 2008-01-11 13:14:11 | 2008-01-11 13:14:11 | 2005-03-04 00:00:00 | 167600 | 167600 | 164650.16 | 2949.839999999997
 |  | PJ | 1701503-00 | 744_17_0019 | 2007-06-20 11:20:43 | 2007-06-20 11:20:43 | 2002-12-06 00:00:00 | 126640 | 126640 | 111723.04 | 14916.95999999999
 |  | PJ | 2302502-00 | H.970475,397_05_0013 | 2004-10-21 09:05:39 | 2011-01-26 22:33:16 | 2002-11-19 00:00:00 | 126906.72 | 101525.38 | 101525.38 | 0
 |  | PJ | 2603516-00 | 006_02_0068 | 2007-03-12 08:15:56 | 2009-01-28 15:17:21 | 2003-11-21 00:00:00 | 65954 | 52763.88 | 38405.89 | 14357.99000000001
 |  | PJ | 2604520-00 | 736_26_0003 | 2007-12-20 10:14:33 | 2007-12-20 10:14:33 | 2004-08-02 00:00:00 | 62500 | 50000 | 49695.27 | 304.7299999999959
 |  | PJ | 2605515-00 | 064_01_0043 | 2007-07-10 14:02:31 | 2007-07-10 14:02:31 | 2005-08-29 00:00:00 | 525289 | 525289 | 508238.65 | 17050.34999999998
 |  | PJ | 2605516-00 | 007_02_0096 | 2007-06-11 08:14:31 | 2010-09-20 15:30:29 | 2007-05-15 00:00:00 | 104480 | 104480 | 61945.6 | 42534.4
 |  | PJ | 2701502-00 | [NAME] | 2007-12-13 09:17:54 | 2007-12-13 09:17:54 | 2003-04-10 00:00:00 | 185132 | 185132.21 | 167219.33 | 17912.87999999998
 |  | PJ | 3107508-00 | 451_05_0099 | 2008-01-23 10:09:01 | 2008-01-23 10:09:01 | 2007-08-17 00:00:00 | 2877259 | 2420607 | 2420607 | 0
 |  | PJ | 3203500-00 | 273_03_0023 | 2007-08-13 13:11:05 | 2007-08-13 13:11:05 | 2004-08-25 00:00:00 | 131480 | 131480 | 111187.77 | 20292.23
 |  | PJ | 3203501-00 | 273_03_0024 | 2007-09-12 08:35:42 | 2007-09-12 08:35:42 | 2005-01-10 00:00:00 | 35740 | 35740 | 10381.81 | 25358.19
 |  | PJ | 3302509-00 | 714_33_0002 | 2007-08-13 13:11:04 | 2007-08-13 13:11:04 | 2003-12-15 00:00:00 | 169429 | 169429 | 149320.54 | 20108.45999999999
 |  | PJ | 3307501-00 | 714_33_0014 |  | 2007-11-26 13:52:22 | 2007-11-26 00:00:00 | 5661 | 5661 | 0 | 5661
 |  | PJ | 3603537-00 | 700_36_0171 | 2007-04-19 10:40:20 | 2009-12-08 00:00:00 | 2004-03-12 00:00:00 | 47209 | 37767.2 | 24772.98 | 12994.22
 |  | PJ | 3604506-00 | 736_36_0041 | 2007-10-02 13:57:32 | 2007-10-02 13:57:32 | 2005-03-04 00:00:00 | 150000 | 120000 | 105757.91 | 14242.09
 |  | PJ | 3605502-00 | H.970226,046_02_0022 | 2007-08-13 13:11:01 | 2011-01-28 11:53:02 | 2005-08-04 00:00:00 | 55285.01 | 55285.01 | 55285.01 | 0
 |  | PJ | 3606519-00 | 046_02_0023 | 2007-05-11 08:53:41 | 2007-05-11 08:53:41 | 2007-01-25 00:00:00 | 57500 | 46000 | 39619.84 | 6380.159999999996
 |  | PJ | 3805501-00 | 062_02_0115 | 2006-11-16 13:32:33 | 2006-11-16 13:32:33 | 2005-08-29 00:00:00 | 234600 | 234600 | 198729.99 | 35870.01000000001
 |  | PJ | 3805502-00 | 062_02_0116 | 2006-11-16 13:32:33 | 2006-11-16 13:32:33 | 2005-08-29 00:00:00 | 23000 | 23000 | 13332.14 | 9667.86
 |  | PJ | 3901505-00 | 224_02_0029 | 2005-08-12 09:45:45 | 2010-07-22 15:08:37 | 2002-08-13 00:00:00 | 2464361 | 1969520.3 | 1932825.98 | 36694.32000000007
 |  | PJ | 4001508-00 | 369_01_0006 | 2007-05-11 08:53:41 | 2009-09-10 09:29:48 | 2002-06-10 00:00:00 | 58892 | 47113.88 | 28812.59 | 18301.29
 |  | PJ | 4061003-00 | 863_02_0021 | 2006-10-12 15:38:46 | 2010-07-22 15:08:38 | 1993-07-01 00:00:00 | 128093 | 87251.43 | 87251.43 | 0
 |  | PJ | 5205512-00 | 006_08_0033 | 2007-10-10 10:26:40 | 2007-10-10 10:26:40 | 2005-08-29 00:00:00 | 616785 | 616784.58 | 615602.3200000001 | 1182.259999999893
 |  | PJ | 5206501-00 | 714_52_0012 | 2007-05-11 08:53:38 | 2007-05-11 08:53:38 | 2006-03-09 00:00:00 | 75000 | 75000 | 35283.45 | 39716.55
 |  | PJ | 5303514-00 | 714_53_0108 | 2007-07-10 14:02:34 | 2007-07-10 14:02:34 | 2005-02-15 00:00:00 | 135200 | 135200 | 125582 | 9618
 |  | PJ | 5304513-00 | 714_53_0111 | 2007-06-11 08:14:32 | 2007-06-11 08:14:32 | 2005-08-16 00:00:00 | 139840 | 139840 | 111703.99 | 28136.00999999999
 |  | PJ | 5305502-00 | 714_26_0023 | 2007-06-11 08:14:33 | 2007-06-11 08:14:33 | 2005-02-15 00:00:00 | 151720 | 151720 | 128204.37 | 23515.62999999999
 |  | PJ | 6202502-00 | 700_62_0009 | 2008-01-09 10:20:34 | 2008-01-09 10:20:34 | 2003-02-14 00:00:00 | 59603 | 47682.4 | 44318.98 | 3363.419999999998
 |  | PJ | 8447001-00 | 714_37_0112 | 2006-10-16 16:45:48 | 2006-10-16 16:45:48 | 2003-03-10 00:00:00 | 195337 | 195337 | 162209.95 | 33127.04999999999
 |  | PJ | 9906508-00 | 700_99_0396 | 2006-12-15 13:09:53 | 2006-12-15 13:09:53 | 2006-06-05 00:00:00 | 13296 | 13295.6 | 11441.99 | 1853.610000000001
 |  | PJ | 9906509-00 | 737_99_0813 | 2007-11-08 09:17:05 | 2007-11-08 09:17:05 | 2006-06-23 00:00:00 | 60205 | 55480 | 53750.69 | 1729.309999999998
 |  | PJ | 9907538-00 | 737_99_0891 |  | 2007-09-10 13:55:37 | 2007-08-22 00:00:00 | 20000 | 10000 | 0 | 10000
 |  | PJ | ERE1012-00 | 006_05_0084 | 2007-08-13 13:11:00 | 2007-08-13 13:11:00 | 2005-08-29 00:00:00 | 984509 | 984509.19 | 984509.19 | 0
 |  | PJ | ERE1047-00 | 704_96_0004 | 2007-07-10 14:02:31 | 2007-07-10 14:02:31 | 2005-08-29 00:00:00 | 565830 | 565829.56 | 565829.56 | 0
 |  | PJ | ERE1053-00 | 704_92_0033 | 2007-07-10 14:02:31 | 2007-07-10 14:02:31 | 2007-03-27 00:00:00 | 596048 | 596048.21 | 596048.21 | 0
 |  | PJ | ERE1082-00 | 704_90_0033 | 2007-08-13 13:11:00 | 2007-08-13 13:11:00 | 2007-04-24 00:00:00 | 19748 | 19748.21 | 16918.15 | 2830.059999999998
 |  | PJ | ERE1092-00 | 283_08_0167 | 2007-06-11 08:14:31 | 2007-06-11 08:14:31 | 2005-08-29 00:00:00 | 63128 | 63128 | 62044.42 | 1083.580000000002
 |  | PJ | ERE1104-00 | 283_08_0169 | 2007-04-17 13:17:25 | 2007-04-17 13:17:25 | 2005-08-29 00:00:00 | 22700 | 22700 | 21880.28 | 819.7200000000012
 |  | PJ | ERE2011-00 | 031_04_0046 | 2007-08-13 13:11:00 | 2007-08-13 13:11:00 | 2005-09-24 00:00:00 | 261758 | 261758.16 | 261712.47 | 45.69000000000233
 |  | PJ | ERE2013-00 | 382_04_0048 | 2007-08-13 13:11:00 | 2007-08-13 13:11:00 | 2005-09-24 00:00:00 | 331815 | 331815.26 | 325540.59 | 6274.669999999984
 |  | PJ | ERE2020-00 | 031_03_0024 | 2007-09-12 08:35:40 | 2007-09-12 08:35:40 | 2005-09-24 00:00:00 | 164324 | 164324.2 | 159425.43 | 4898.770000000019
 |  | PJ | LA06004-00 | 745_97_0006 |  | 2007-09-04 15:42:15 | 2007-08-30 00:00:00 | 31250 | 25000 | 0 | 25000
 |  | PJ | NBIS892-00 | 700_99_0366 | 2007-10-05 13:48:44 | 2010-08-17 14:49:20 | 2005-04-04 00:00:00 | 934700 | 747760 | 747760 | 0
 |  | PJ | TPF5405-00 |  | 2007-10-26 00:13:08 | 2007-10-26 00:19:53 | 2005-10-31 00:00:00 | 511910 | 511910 | 511910 | 0
 | Totals | Totals | Total Projects |  |  |  |  |  |  | Total Unexp: