Spreadsheet: 108021d1305131420-vlookup-assistance-vlookup
Sheet: 2011 1st 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 | 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 | 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 | 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 | 2300506-00 | 700_23_0209 | 2006-11-03 11:32:23 | 2006-11-03 11:32:23 | 2000-09-01 00:00:00 | 136188 | 108772 | 108772 | 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 | 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 | 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 | 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 | 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 | 9900508-00 | 700_99_0255 | 2004-02-03 13:21:11 | 2010-08-12 16:37:02 | 2002-08-27 00:00:00 | 313648 | 250918.39 | 214921.21 | 35997.18000000002
 |  | 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
 | 2011 | 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
 |  | PJ | 0010032-00 | 736_99_1523 | 2009-09-21 00:00:00 | 2009-09-21 00:00:00 | 2008-07-01 00:00:00 | 16718939 | 13375150.39 | 10606358.12 | 2768792.27
 |  | PJ | 0801516-00 | 742_08_0002 |  | 2009-12-08 00:00:00 | 2008-03-19 00:00:00 | 2028000 | 1622400 | 0 | 1622400
 |  | PJ | 1707504-00 | 742_17_0156 | 2009-04-08 00:00:00 | 2009-12-08 00:00:00 | 2008-06-10 00:00:00 | 2875000 | 2300000 | 2016.94 | 2297983.06
 |  | PJ | 2306505-00 | 399_02_0015 |  | 2009-08-14 00:00:00 | 2009-08-05 00:00:00 | 1042279 | 833823 | 0 | 833823
 |  | PJ | 3603501-00 | 742_36_0124 | 2009-06-23 00:00:00 | 2009-12-08 00:00:00 | 2006-06-19 00:00:00 | 5034022 | 4027217.6 | 2995538.22 | 1031679.38
 |  | PJ | 5102506-00 | 714_51_0007 | 2009-03-09 00:00:00 | 2009-11-18 00:00:00 | 2006-06-19 00:00:00 | 1727605 | 1382083.14 | 775677.23 | 606405.91
 |  | PJ | 5206508-00 | 013_13_0032 |  | 2010-07-13 00:00:00 | 2007-11-19 00:00:00 | 1019000 | 815200 | 0 | 815200
 |  | PJ | 6000514-00 | 085_05_0026 | 2009-08-13 00:00:00 | 2010-06-07 00:00:00 | 2009-05-27 00:00:00 | 8349521 | 6679617.16 | 6378.4 | 6673238.76
 |  | PJ | 6034001-00 | 744_36_0004 | 2009-05-27 00:00:00 | 2009-12-08 00:00:00 | 2007-05-18 00:00:00 | 1574080 | 1495376 | 72275.54 | 1423100.46
 |  | PJ | 9906521-00 | 736_99_1424 | 2009-09-21 00:00:00 | 2009-09-21 00:00:00 | 2006-08-09 00:00:00 | 2730000 | 2730000 | 1359823.71 | 1370176.29
 |  | PJ | 9907522-00 | 736_99_1494 | 2009-04-08 00:00:00 | 2010-09-07 00:00:00 | 2007-09-17 00:00:00 | 2850000 | 2850000 | 1505815.73 | 1344184.27
 |  | PJ | 9908540-00 | 701_65_1137 |  | 2010-09-20 00:00:00 | 2008-12-24 00:00:00 | 895940 | 716752.23 | 0 | 716752.23
 |  | PJ | 9908579-00 | 700_99_0494 |  | 2009-06-09 00:00:00 | 2009-04-15 00:00:00 | 2300000 | 2300000 | 0 | 2300000
 |  | PJ | 9908581-00 | 700_99_0496 |  | 2009-06-04 00:00:00 | 2009-06-04 00:00:00 | 2400000 | 1920000 | 0 | 1920000
 |  | PJ | ERE3121-00 | 737_17_0023 |  | 2010-08-26 00:00:00 | 2008-09-01 00:00:00 | 1299144 | 1299143.44 | 0 | 1299143.44
 |  | PJ | ERP1108-00 | 704_36_0080 |  | 2009-12-21 00:00:00 | 2008-01-03 00:00:00 | 1572000 | 1572000 | 0 | 1572000
 |  | PJ | ERP2006-00 | 450_03_0075 | 2009-04-08 00:00:00 | 2009-04-08 00:00:00 | 2008-06-23 00:00:00 | 764837 | 764836.8 | 207.73 | 764629.07
 |  | PJ | LA08003-00 | 745_99_0017 |  | 2009-08-25 00:00:00 | 2009-08-24 00:00:00 | 818000 | 654400 | 0 | 654400
 |  | PJ | LA08004-00 | 745_99_0016 |  | 2009-08-25 00:00:00 | 2009-08-25 00:00:00 | 856800 | 685440 | 0 | 685440
 |  | PJ | LA08005-00 | 745_99_0018 |  | 2009-08-25 00:00:00 | 2009-08-24 00:00:00 | 1925020 | 1540016 | 0 | 1540016
 |  | PJ | TKUP001-00 | 737_99_0451 | 2009-04-08 00:00:00 | 2009-04-08 00:00:00 | 1997-11-01 00:00:00 | 9859981 | 8415000 | 7900241.21 | 514758.79
 |  | PJ | 0004201-00 |  | 2005-09-29 00:00:00 | 2010-09-20 00:00:00 | 2001-05-01 00:00:00 | 489115 | 489115 | 413799.34 | 75315.66
 |  | PJ | 0021014-00 | 700_09_0139 | 2008-06-10 00:00:00 | 2010-09-16 00:00:00 | 2002-03-27 00:00:00 | 195375 | 155000 | 76800 | 78200
 |  | PJ | 0021018-00 | 700_09_0141 | 2007-10-05 00:00:00 | 2010-09-16 00:00:00 | 2002-03-27 00:00:00 | 422596 | 330000 | 150434.18 | 179565.82
 |  | PJ | 0105274-00 | 700_18_0053 | 2008-06-13 00:00:00 | 2010-03-15 00:00:00 | 1997-03-01 00:00:00 | 952211 | 855585 | 786649.43 | 68935.57
 |  | PJ | 0121145-00 | 454_04_0053 | 2007-09-12 00:00:00 | 2008-08-25 00:00:00 | 2004-07-07 00:00:00 | 8854527 | 7969074 | 7854804.15 | 114269.85
 |  | PJ | 1002508-00 | 714_10_0109 | 2008-05-07 00:00:00 | 2008-05-07 00:00:00 | 2006-11-13 00:00:00 | 261060 | 261060 | 139893.42 | 121166.58
 |  | PJ | 1008511-00 | 737_10_0115 |  | 2008-09-15 00:00:00 | 2008-08-20 00:00:00 | 280800 | 280800 | 0 | 280800
 |  | PJ | 1605500-00 | 300_04_0029 | 2008-04-15 00:00:00 | 2008-04-15 00:00:00 | 2005-03-04 00:00:00 | 407140 | 407140 | 172403.38 | 234736.62
 |  | PJ | 2107501-00 | 737_21_0001 |  | 2009-12-03 00:00:00 | 2008-04-02 00:00:00 | 306200 | 275580.37 | 0 | 275580.37
 |  | PJ | 2302502-00 | 397_05_0013 | 2004-10-21 00:00:00 | 2004-10-21 00:00:00 | 2002-11-19 00:00:00 | 194353 | 155482.4 | 101525.38 | 53957.02
 |  | PJ | 2608508-00 | 450_15_0135 |  | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 490800 | 392640 | 0 | 392640
 |  | PJ | 2807504-00 | 742_28_0003 |  | 2007-08-22 00:00:00 | 2007-04-24 00:00:00 | 247020 | 247020 | 0 | 247020
 |  | PJ | 2907504-00 | 742_29_0002 |  | 2007-09-12 00:00:00 | 2007-09-11 00:00:00 | 289520 | 289520 | 0 | 289520
 |  | PJ | 3306500-00 | 714_33_0011 | 2008-01-11 00:00:00 | 2008-01-11 00:00:00 | 2006-04-18 00:00:00 | 206120 | 206120 | 138731.47 | 67388.53
 |  | PJ | 3605502-00 | 046_02_0022 | 2007-08-13 00:00:00 | 2009-06-04 00:00:00 | 2005-08-04 00:00:00 | 244600 | 244600 | 55285.01 | 189314.99
 |  | PJ | 3705502-00 | 714_37_0104 | 2007-06-11 00:00:00 | 2007-06-11 00:00:00 | 2005-03-04 00:00:00 | 182260 | 182260 | 109290.7 | 72969.3
 |  | PJ | 3705503-00 | 714_37_0105 | 2007-06-11 00:00:00 | 2007-06-11 00:00:00 | 2005-03-04 00:00:00 | 201720 | 201720 | 119715.13 | 82004.87
 |  | PJ | 3707506-00 | 742_37_0018 |  | 2007-09-12 00:00:00 | 2007-09-12 00:00:00 | 274164 | 274164 | 0 | 274164
 |  | PJ | 3708502-00 | 737_37_0012 |  | 2008-08-20 00:00:00 | 2008-08-14 00:00:00 | 279400 | 279400 | 0 | 279400
 |  | PJ | 4404504-00 | 714_44_0002 |  | 2005-05-17 00:00:00 | 2005-05-17 00:00:00 | 89920 | 89920 | 0 | 89920
 |  | PJ | 4707502-00 | 847_02_0030 |  | 2007-11-26 00:00:00 | 2007-11-26 00:00:00 | 55167 | 55167 | 0 | 55167
 |  | PJ | 4906500-00 | 700_03_0120 | 2008-07-17 00:00:00 | 2008-07-17 00:00:00 | 2007-11-19 00:00:00 | 238050 | 190440 | 1563.45 | 188876.55
 |  | PJ | 4907502-00 | 742_49_0001 |  | 2007-09-12 00:00:00 | 2007-09-11 00:00:00 | 50595 | 50595.2 | 0 | 50595.2
 |  | PJ | 5107501-00 | 742_51_0001 |  | 2007-09-12 00:00:00 | 2007-09-12 00:00:00 | 309760 | 309760 | 0 | 309760
 |  | PJ | 5506501-00 | 855_07_0013 |  | 2008-09-23 00:00:00 | 2008-09-23 00:00:00 | 240000 | 192000 | 0 | 192000
 |  | PJ | 8368001-00 | 714_37_0102 | 2008-05-13 00:00:00 | 2008-05-13 00:00:00 | 2005-04-12 00:00:00 | 556300 | 556300 | 458230.05 | 98069.95
 |  | PJ | 9408500-00 | 737_94_0049 |  | 2008-08-20 00:00:00 | 2008-08-07 00:00:00 | 56200 | 56200 | 0 | 56200
 |  | PJ | 9907537-00 | 700_99_0445 |  | 2009-11-25 00:00:00 | 2008-06-04 00:00:00 | 396341 | 317073.06 | 0 | 317073.06
 |  | PJ | 9907540-00 | 744_99_0128 |  | 2010-09-07 00:00:00 | 2007-12-07 00:00:00 | 92000 | 73600 | 0 | 73600
 |  | PJ | 9908532-00 | 701_65_1056 |  | 2009-09-10 00:00:00 | 2008-07-30 00:00:00 | 506828 | 405462.4 | 0 | 405462.4
 |  | PJ | 9908533-00 | 701_65_1083 |  | 2009-09-10 00:00:00 | 2008-07-30 00:00:00 | 539172 | 431337.6 | 0 | 431337.6
 |  | PJ | 9908534-00 | 701_65_1084 |  | 2009-09-10 00:00:00 | 2008-07-30 00:00:00 | 148236 | 118588.8 | 0 | 118588.8
 |  | PJ | ERE1031-00 | 704_90_0008 | 2008-08-05 00:00:00 | 2008-08-08 00:00:00 | 2005-08-29 00:00:00 | 37955048 | 37955048 | 37533909.84 | 421138.16
 |  | PJ | ERE1109-00 | 704_26_0008 | 2008-05-16 00:00:00 | 2009-03-23 00:00:00 | 2007-11-19 00:00:00 | 112169 | 112168.59 | 7775.37 | 104393.22
 |  | PJ | ERE2053-00 | 451_06_0141 |  | 2010-09-08 00:00:00 | 2005-09-24 00:00:00 | 52723 | 52723.2 | 0 | 52723.2
 |  | PJ | ERE3117-00 | 064_30_0037 |  | 2009-09-03 00:00:00 | 2008-09-01 00:00:00 | 218447 | 218446.75 | 0 | 218446.75
 |  | PJ | ERE4086-00 | 851_09_0007 |  | 2009-08-27 00:00:00 | 2008-09-13 00:00:00 | 157825 | 157825 | 0 | 157825
 |  | PJ | TPF5012-00 | 736_99_1017 | 2007-09-29 00:00:00 | 2007-09-29 00:00:00 | 2001-06-22 00:00:00 | 250000 | 250000 | 87708.03 | 162291.97
 |  | Totals | Total Projects |  |  |  |  |  |  | Total Unexp: