{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Admin","Check for New PE's","SOFIA Query","June 2011","Summary","FINPLAN","Variance Explanation "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":95,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Admin","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Variance Sign","Variance Rank","Function"]
[null,null,"Positive",1,"ENVIRONMENTAL"]
[null,null,"Negative",{"$f":"D10+1","v":2},"FOSSIL"]
[null,null,null,{"$f":"D11+1","v":3},"RENEWABLES"]
[null,null,null,4,"NEW BUSINESS TRANSMISSION "]
[null,null,null,5,"NEW BUSINESS DISTRIBUTION"]
[null,null,null,6,"OTHER TRANSMISSION"]
[null,null,null,7,"OTHER DISTRIBUTION"]
[null,null,null,8,"JOINT SUB. & DIST. LINE"]
[null,null,null,9,"FLEET"]
[null,null,null,10,"TELECOMMUNICATIONS"]
[null,null,null,11,"CORPORATE SERVICES"]
[null,null,null,12,"OTHER"]
[null,null,null,13,"NON-UTILITY"]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]

{"sheet":"Check for New PE's","index":1,"n_rows":2000,"n_cols":4,"rows_kept":2000,"cut":false,"hidden":true,"merged":[]}
["SOFIA Query","Expenditure Report Line #","New PE's to Add to Expenditure Report","Function"]
[{"$f":"PE","v":"0090"},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A2, YTD_Actual), SUMIF(PE, $A2, YTD_Budget), SUMIF(PE, $A2, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A2, YTD_Actual), SUMIF(PE, $A2, YTD_Budget), SUMIF(PE, $A2, YTD_Variance_Dollars)) < -1), MATCH($A2, PE_Exp_Report, 0) + 10, 0)","v":170},{"$f":"IF(ISERROR($B2), $A2, \"\")","v":""}]
["0091",0,""]
["1001",0,""]
["1002",0,""]
["1004",0,""]
["1005",0,""]
["1007",0,""]
["1009",50,""]
["1010",51,""]
["1013",52,""]
["1015",53,""]
["1017",54,""]
["1019",0,""]
["1024",0,""]
["1026",0,""]
["1028",0,""]
["1031",14,""]
["1033",0,""]
["1034",0,""]
["1038",16,""]
["1039",0,""]
["1042",0,""]
["1050",0,""]
["1051",0,""]
["1052",57,""]
["1053",58,""]
["1054",0,""]
["1060",0,""]
["1065",0,""]
["1066",60,""]
["1068",0,""]
["1069",0,""]
["1070",0,{"$f":"IF(ISERROR($B34), $A34, \"\")","v":""}]
["1072",0,""]
["1076",0,""]
["1077",62,""]
["1078",0,""]
["1081",0,""]
["1088",0,""]
["1090",0,""]
["1091",0,""]
["1092",0,""]
["1093",0,""]
["1094",65,""]
["1096",0,""]
["1097",0,""]
["1100",66,""]
["1104",0,""]
["1105",0,""]
["1110",67,""]
["1111",68,""]
["1114",69,""]
["1116",0,""]
["1121",72,""]
["1122",73,""]
["1123",0,""]
["1125",0,""]
["1126",74,""]
["1128",0,""]
["1131",0,""]
["1133",75,""]
["1134",76,""]
["1135",0,""]
["1136",0,""]
[{"$f":"PE","v":"1137"},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A66, YTD_Actual), SUMIF(PE, $A66, YTD_Budget), SUMIF(PE, $A66, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A66, YTD_Actual), SUMIF(PE, $A66, YTD_Budget), SUMIF(PE, $A66, YTD_Variance_Dollars)) < -1), MATCH($A66, PE_Exp_Report, 0) + 10, 0)","v":0},""]
["1141",80,{"$f":"IF(ISERROR($B67), $A67, \"\")","v":""}]
["1144",0,""]
["1146",82,""]
["1147",83,""]
["1148",84,""]
["1149",0,""]
["1150",85,""]
["1152",0,""]
["1155",0,""]
["1158",18,""]
["1159",87,""]
["1167",19,""]
["1169",0,""]
["1172",0,""]
["1173",0,""]
["1175",0,""]
["1177",0,""]
["1178",0,""]
["1191",0,""]
["1196",92,""]
["1199",0,""]
["1200",0,""]
["1201",0,""]
["1202",0,""]
["1203",0,""]
["1204",0,""]
["1209",94,""]
["1210",95,""]
["1211",0,""]
["1221",96,""]
["1222",21,""]
["1227",0,""]
["1230",98,""]
["1231",0,""]
["1233",22,""]
["1235",0,""]
["1237",0,""]
["1238",0,""]
["1244",0,""]
["1247",23,""]
["1249",0,""]
["1250",0,""]
["1251",0,""]
["1253",0,""]
["1254",100,""]
["1256",24,""]
["1257",0,""]
["1258",102,""]
["1259",0,""]
["1262",103,""]
["1266",0,""]
["1267",104,""]
["1272",0,""]
["1276",25,""]
["1278",0,""]
["1279",26,""]
["1280",0,""]
["1281",0,""]
["1283",0,""]
["1284",0,""]
["1285",0,""]
["1287",0,""]
["1292",0,""]
[{"$f":"PE","v":"1294"},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A130, YTD_Actual), SUMIF(PE, $A130, YTD_Budget), SUMIF(PE, $A130, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A130, YTD_Actual), SUMIF(PE, $A130, YTD_Budget), SUMIF(PE, $A130, YTD_Variance_Dollars)) < -1), MATCH($A130, PE_Exp_Report, 0) + 10, 0)","v":0},""]
["1298",27,{"$f":"IF(ISERROR($B131), $A131, \"\")","v":""}]
["1299",28,""]
["1300",105,""]
["1305",0,""]
["1324",0,""]
["1331",0,""]
["1357",0,""]
["1362",0,""]
["1400",106,""]
["1401",0,""]
["1402",0,""]
["1403",107,""]
["1404",0,""]
["1405",0,""]
["1413",0,""]
["1417",0,""]
["1420",0,""]
["1421",108,""]
["1424",0,""]
["1427",0,""]
["1429",0,""]
["1434",0,""]
["1435",0,""]
["1436",0,""]
["1438",0,""]
["1444",0,""]
["1445",0,""]
["1451",0,""]
["1452",0,""]
["1461",0,""]
["1462",0,""]
["1465",112,""]
["1468",0,""]
["1469",0,""]
["1471",0,""]
["1482",0,""]
["1493",0,""]
["1494",0,""]
["1496",114,""]
["1497",0,""]
["1498",0,""]
["1499",0,""]
["1500",115,""]
["1501",0,""]
["1502",0,""]
["1511",0,""]
["1512",0,""]
["1513",0,""]
["1515",116,""]
["1523",0,""]
["1531",0,""]
["1532",117,""]
["1535",0,""]
["1546",0,""]
["1551",31,""]
["1552",0,""]
["1555",33,""]
["1556",0,""]
["1557",0,""]
["1559",0,""]
["1561",0,""]
["1563",0,""]
["1564",119,""]
[{"$f":"PE","v":"1567"},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A194, YTD_Actual), SUMIF(PE, $A194, YTD_Budget), SUMIF(PE, $A194, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A194, YTD_Actual), SUMIF(PE, $A194, YTD_Budget), SUMIF(PE, $A194, YTD_Variance_Dollars)) < -1), MATCH($A194, PE_Exp_Report, 0) + 10, 0)","v":0},""]
["1568",121,{"$f":"IF(ISERROR($B195), $A195, \"\")","v":""}]
["1569",122,""]
["1570",0,""]
["1572",0,""]
["1576",0,""]
["1581",0,""]
["1583",0,""]
["1584",0,""]
["1585",0,""]
["1592",34,""]
["1593",127,""]
["1600",128,""]
["1601",0,""]
["1604",129,""]
["1607",130,""]
["1610",131,""]
["1611",132,""]
["1613",36,""]
["1619",0,""]
["1640",37,""]
["1647",0,""]
["1649",0,""]
["1650",0,""]
["1653",0,""]
["1654",0,""]
["1655",0,""]
["1656",134,""]
["1657",0,""]
["1659",0,""]
["1666",0,""]
["1670",0,""]
["1671",0,""]
["1673",0,""]
["1674",0,""]
["1677",0,""]
["1678",0,""]
["1679",135,""]
["1680",0,""]
["1681",0,""]
["1683",0,""]
["1684",0,""]
["1685",0,""]
["1686",0,""]
["1687",0,""]
["1688",0,""]
["1689",0,""]
["1692",0,""]
["1699",0,""]
["1700",136,"","FOSSIL"]
["1705",137,""]
["1707",138,""]
["1708",0,""]
["1709",139,""]
["1716",0,""]
["1717",141,""]
["1721",0,""]
["1727",38,""]
["1728",39,""]
["1729",40,""]
["1732",143,""]
["1733",144,""]
["1734",0,""]
["1736",0,""]
[{"$f":"PE","v":"1737"},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A258, YTD_Actual), SUMIF(PE, $A258, YTD_Budget), SUMIF(PE, $A258, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A258, YTD_Actual), SUMIF(PE, $A258, YTD_Budget), SUMIF(PE, $A258, YTD_Variance_Dollars)) < -1), MATCH($A258, PE_Exp_Report, 0) + 10, 0)","v":0},""]
["1739",146,{"$f":"IF(ISERROR($B259), $A259, \"\")","v":""}]
["1740",0,""]
["1742",0,""]
["1743",148,""]
["1747",149,""]
["1749",0,""]
["1750",150,""]
["1752",0,""]
["1754",0,""]
["1755",151,""]
["1757",152,""]
["1758",0,""]
["1759",0,""]
["1761",0,""]
["1762",0,""]
["1763",0,""]
["1765",0,""]
["1766",154,""]
["1767",155,""]
["1769",0,""]
["1771",0,""]
["1772",0,""]
["1773",158,""]
["1774",159,""]
["1775",160,""]
["1777",0,""]
["1778",42,""]
["1781",0,""]
["1782",0,""]
["1783",0,""]
["1784",161,""]
["1785",162,""]
["1786",0,""]
["1787",0,""]
["1789",0,""]
["1791",0,""]
["1794",0,""]
["1799",0,""]
["1801",0,""]
["1802",0,""]
["1803",0,""]
["1804",0,""]
["1805",0,""]
["1808",0,""]
["1810",0,""]
["1811",0,""]
["1812",0,""]
["1813",0,""]
["1814",163,""]
["1815",0,""]
["1821",0,""]
["1822",0,""]
["1824",43,""]
["1826",0,""]
["1829",0,""]
["1830",0,""]
["1833",0,""]
["1839",0,""]
["1840",164,""]
["1841",0,""]
["1842",165,""]
["1843",0,""]
["1844",0,"","ENVIRONMENTAL"]
[{"$f":"PE","v":"1846"},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A322, YTD_Actual), SUMIF(PE, $A322, YTD_Budget), SUMIF(PE, $A322, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A322, YTD_Actual), SUMIF(PE, $A322, YTD_Budget), SUMIF(PE, $A322, YTD_Variance_Dollars)) < -1), MATCH($A322, PE_Exp_Report, 0) + 10, 0)","v":0},""]
["1847",44,{"$f":"IF(ISERROR($B323), $A323, \"\")","v":""}]
["1848",0,""]
["1850",0,""]
["1851",0,""]
["1852",0,""]
["1854",0,""]
["1855",0,""]
["1859",0,""]
["1866",0,""]
["1900",0,""]
["1901",0,""]
["1903",0,""]
["1904",0,""]
["2550",188,""]
["2551",189,""]
["2552",190,""]
["2553",185,""]
["2554",191,""]
["2555",192,""]
["2556",186,""]
["2558",187,""]
["2559",193,""]
["2601",0,""]
["2603",0,""]
["2604",0,"","OTHER TRANSMISSION"]
["2801",198,""]
["2802",199,""]
["2803",0,""]
["2804",0,"","OTHER TRANSMISSION"]
["2806",200,""]
["2808",201,""]
["2809",0,""]
["2810",202,""]
["2812",0,""]
["2814",203,""]
["2820",0,""]
["2821",0,""]
["2822",204,""]
["2825",205,""]
["2827",0,""]
["2828",206,"","OTHER TRANSMISSION"]
["2830",0,""]
["2833",0,""]
["2837",207,"","OTHER TRANSMISSION"]
["2838",208,""]
["2839",0,""]
["2841",0,""]
["2843",210,""]
["2844",211,""]
["2845",212,""]
["2846",213,""]
["2850",0,""]
["2852",214,"","OTHER TRANSMISSION"]
["2853",215,""]
["2854",216,""]
["2856",0,""]
["2859",0,""]
["2861",217,""]
["2863",218,""]
["2865",0,""]
["2867",219,""]
["2869",0,"","OTHER TRANSMISSION"]
["2874",220,"","OTHER TRANSMISSION"]
[{"$f":"PE","v":"2876"},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A386, YTD_Actual), SUMIF(PE, $A386, YTD_Budget), SUMIF(PE, $A386, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A386, YTD_Actual), SUMIF(PE, $A386, YTD_Budget), SUMIF(PE, $A386, YTD_Variance_Dollars)) < -1), MATCH($A386, PE_Exp_Report, 0) + 10, 0)","v":221},"","OTHER TRANSMISSION"]
["2882",222,{"$f":"IF(ISERROR($B387), $A387, \"\")","v":""},"OTHER TRANSMISSION"]
["2886",223,""]
["2888",224,"","OTHER DISTRIBUTION"]
["2889",0,""]
["2890",0,""]
["2892",227,""]
["2894",228,""]
["2895",0,""]
["2896",0,""]
["2897",0,""]
["3401",239,""]
["3402",240,""]
["3403",241,""]
["3404",242,""]
["3405",243,"","OTHER DISTRIBUTION"]
["3406",244,"","OTHER DISTRIBUTION"]
["3407",245,""]
["3408",246,""]
["3412",0,""]
["3418",0,""]
["3422",0,"","OTHER DISTRIBUTION"]
["3423",0,""]
["3428",0,""]
["3430",0,""]
["3435",0,""]
["3440",249,"","OTHER DISTRIBUTION"]
["3445",0,""]
["3448",250,""]
["3449",0,""]
["3453",0,""]
["3454",0,""]
["3455",0,""]
["3456",0,""]
["3457",0,""]
["3458",0,""]
["3459",0,""]
["3460",0,""]
["3461",252,""]
["3462",0,""]
["3463",0,""]
["3467",0,""]
["3468",0,""]
["3469",0,"","OTHER TRANSMISSION"]
["3475",0,"","OTHER TRANSMISSION"]
["3476",253,""]
["3477",0,""]
["3478",0,"","OTHER TRANSMISSION"]
["3479",229,"","OTHER TRANSMISSION"]
["3480",0,"","OTHER TRANSMISSION"]
["3481",255,""]
["3483",256,""]
["3484",0,""]
["3487",232,""]
["3488",0,""]
["3491",257,""]
["3498",258,""]
["3499",0,""]
["3500",259,"","OTHER DISTRIBUTION"]
["3501",260,""]
["3502",0,"","OTHER DISTRIBUTION"]
["3503",0,""]
["3505",0,"","OTHER DISTRIBUTION"]
["3507",0,""]
[{"$f":"PE","v":"3509"},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A450, YTD_Actual), SUMIF(PE, $A450, YTD_Budget), SUMIF(PE, $A450, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A450, YTD_Actual), SUMIF(PE, $A450, YTD_Budget), SUMIF(PE, $A450, YTD_Variance_Dollars)) < -1), MATCH($A450, PE_Exp_Report, 0) + 10, 0)","v":0},""]
["3511",0,{"$f":"IF(ISERROR($B451), $A451, \"\")","v":""}]
["3512",0,""]
["3513",263,""]
["3515",0,""]
["3516",0,""]
["3517",0,""]
["3518",0,""]
["3519",0,""]
["3601",0,""]
["3609",0,"","OTHER DISTRIBUTION"]
["3630",0,""]
["3631",0,""]
["3632",0,""]
["3633",264,""]
["3636",265,"","OTHER DISTRIBUTION"]
["3638",0,"","OTHER DISTRIBUTION"]
["3639",0,"","OTHER DISTRIBUTION"]
["3640",0,"","OTHER DISTRIBUTION"]
["3642",266,"","OTHER DISTRIBUTION"]
["3643",267,""]
["3645",0,""]
["3646",0,""]
["3647",0,""]
["3648",271,""]
["3649",0,""]
["3650",272,""]
["3651",0,""]
["3652",273,""]
["3653",0,""]
["3655",0,""]
["3688",0,""]
["3690",0,""]
["3691",274,"","OTHER DISTRIBUTION"]
["3692",0,""]
["3693",275,""]
["3695",0,""]
["3696",0,""]
["3698",276,""]
["3699",0,""]
["3700",281,""]
["3702",282,""]
["3713",0,""]
["3723",0,""]
["3726",0,""]
["3727",283,""]
["3728",0,""]
["3731",284,""]
["3735",0,""]
["3740",0,""]
["3742",285,""]
["3745",286,""]
["3747",0,""]
["3748",287,""]
["3751",0,""]
["3752",288,""]
["3753",289,""]
["3754",290,""]
["3755",291,""]
["3756",292,""]
["4300",313,""]
["4301",325,""]
["4302",314,""]
["4303",0,""]
[{"$f":"PE","v":"4304"},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A514, YTD_Actual), SUMIF(PE, $A514, YTD_Budget), SUMIF(PE, $A514, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A514, YTD_Actual), SUMIF(PE, $A514, YTD_Budget), SUMIF(PE, $A514, YTD_Variance_Dollars)) < -1), MATCH($A514, PE_Exp_Report, 0) + 10, 0)","v":300},""]
["4305",305,{"$f":"IF(ISERROR($B515), $A515, \"\")","v":""}]
["4306",316,""]
["4308",326,"","CORPORATE SERVICES"]
["4310",306,""]
["4311",307,""]
["4317",0,""]
["4318",0,""]
["4321",0,""]
["4328",317,"","CORPORATE SERVICES"]
["4344",327,""]
["4345",0,""]
["4347",0,""]
["4348",0,""]
["4351",0,""]
["4360",0,""]
["4366",319,""]
["4370",0,""]
["4371",0,""]
["4374",0,""]
["4375",0,""]
["4376",328,""]
["4377",0,""]
["4378",329,""]
["4379",0,""]
["4380",0,""]
["4381",0,""]
["4384",0,""]
["4385",308,"","CORPORATE SERVICES"]
["4386",0,""]
["4391",0,""]
["4395",0,""]
["4396",0,""]
["4400",330,""]
["4404",0,""]
["4779",0,""]
["4785",331,""]
["4790",332,""]
["4999",340,""]
["Total",346,""]
[" ",0,""]
[" ",0,""]
["Database: ",0,""]
["Information View: ",0,""]
["Loaded Query Name: ",0,""]
["Months: ",0,""]
[" ",0,""]
["PerForming RCN: ",0,""]
["Activity: ",0,""]
["Resource Type: ",0,""]
["Ferc Sub: ",0,""]
["Project: ",0,""]
["Location: ",0,""]
["Receiving ORG: ",0,""]
["Allocation Indicator: ",0,""]
["Work Order: ",0,""]
["Billing Work Order: ",0,""]
["Company: ",0,""]
[" ",0,""]
["Drill Drown: ",0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A578, YTD_Actual), SUMIF(PE, $A578, YTD_Budget), SUMIF(PE, $A578, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A578, YTD_Actual), SUMIF(PE, $A578, YTD_Budget), SUMIF(PE, $A578, YTD_Variance_Dollars)) < -1), MATCH($A578, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,{"$f":"IF(ISERROR($B579), $A579, \"\")","v":""}]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A642, YTD_Actual), SUMIF(PE, $A642, YTD_Budget), SUMIF(PE, $A642, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A642, YTD_Actual), SUMIF(PE, $A642, YTD_Budget), SUMIF(PE, $A642, YTD_Variance_Dollars)) < -1), MATCH($A642, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,{"$f":"IF(ISERROR($B643), $A643, \"\")","v":""}]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A706, YTD_Actual), SUMIF(PE, $A706, YTD_Budget), SUMIF(PE, $A706, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A706, YTD_Actual), SUMIF(PE, $A706, YTD_Budget), SUMIF(PE, $A706, YTD_Variance_Dollars)) < -1), MATCH($A706, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,{"$f":"IF(ISERROR($B707), $A707, \"\")","v":""}]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A770, YTD_Actual), SUMIF(PE, $A770, YTD_Budget), SUMIF(PE, $A770, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A770, YTD_Actual), SUMIF(PE, $A770, YTD_Budget), SUMIF(PE, $A770, YTD_Variance_Dollars)) < -1), MATCH($A770, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,{"$f":"IF(ISERROR($B771), $A771, \"\")","v":""}]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A834, YTD_Actual), SUMIF(PE, $A834, YTD_Budget), SUMIF(PE, $A834, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A834, YTD_Actual), SUMIF(PE, $A834, YTD_Budget), SUMIF(PE, $A834, YTD_Variance_Dollars)) < -1), MATCH($A834, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,{"$f":"IF(ISERROR($B835), $A835, \"\")","v":""}]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A898, YTD_Actual), SUMIF(PE, $A898, YTD_Budget), SUMIF(PE, $A898, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A898, YTD_Actual), SUMIF(PE, $A898, YTD_Budget), SUMIF(PE, $A898, YTD_Variance_Dollars)) < -1), MATCH($A898, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,{"$f":"IF(ISERROR($B899), $A899, \"\")","v":""}]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A962, YTD_Actual), SUMIF(PE, $A962, YTD_Budget), SUMIF(PE, $A962, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A962, YTD_Actual), SUMIF(PE, $A962, YTD_Budget), SUMIF(PE, $A962, YTD_Variance_Dollars)) < -1), MATCH($A962, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,{"$f":"IF(ISERROR($B963), $A963, \"\")","v":""}]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1007), $A1007, \"\")","v":""}]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1009), $A1009, \"\")","v":""}]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1011), $A1011, \"\")","v":""}]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1013), $A1013, \"\")","v":""}]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1015), $A1015, \"\")","v":""}]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1017), $A1017, \"\")","v":""}]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1019), $A1019, \"\")","v":""}]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1021), $A1021, \"\")","v":""}]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1023), $A1023, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1026, YTD_Actual), SUMIF(PE, $A1026, YTD_Budget), SUMIF(PE, $A1026, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1026, YTD_Actual), SUMIF(PE, $A1026, YTD_Budget), SUMIF(PE, $A1026, YTD_Variance_Dollars)) < -1), MATCH($A1026, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1087), $A1087, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1090, YTD_Actual), SUMIF(PE, $A1090, YTD_Budget), SUMIF(PE, $A1090, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1090, YTD_Actual), SUMIF(PE, $A1090, YTD_Budget), SUMIF(PE, $A1090, YTD_Variance_Dollars)) < -1), MATCH($A1090, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1151), $A1151, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1154, YTD_Actual), SUMIF(PE, $A1154, YTD_Budget), SUMIF(PE, $A1154, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1154, YTD_Actual), SUMIF(PE, $A1154, YTD_Budget), SUMIF(PE, $A1154, YTD_Variance_Dollars)) < -1), MATCH($A1154, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1215), $A1215, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1218, YTD_Actual), SUMIF(PE, $A1218, YTD_Budget), SUMIF(PE, $A1218, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1218, YTD_Actual), SUMIF(PE, $A1218, YTD_Budget), SUMIF(PE, $A1218, YTD_Variance_Dollars)) < -1), MATCH($A1218, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1279), $A1279, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1282, YTD_Actual), SUMIF(PE, $A1282, YTD_Budget), SUMIF(PE, $A1282, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1282, YTD_Actual), SUMIF(PE, $A1282, YTD_Budget), SUMIF(PE, $A1282, YTD_Variance_Dollars)) < -1), MATCH($A1282, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1343), $A1343, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1346, YTD_Actual), SUMIF(PE, $A1346, YTD_Budget), SUMIF(PE, $A1346, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1346, YTD_Actual), SUMIF(PE, $A1346, YTD_Budget), SUMIF(PE, $A1346, YTD_Variance_Dollars)) < -1), MATCH($A1346, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1407), $A1407, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1410, YTD_Actual), SUMIF(PE, $A1410, YTD_Budget), SUMIF(PE, $A1410, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1410, YTD_Actual), SUMIF(PE, $A1410, YTD_Budget), SUMIF(PE, $A1410, YTD_Variance_Dollars)) < -1), MATCH($A1410, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1471), $A1471, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1474, YTD_Actual), SUMIF(PE, $A1474, YTD_Budget), SUMIF(PE, $A1474, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1474, YTD_Actual), SUMIF(PE, $A1474, YTD_Budget), SUMIF(PE, $A1474, YTD_Variance_Dollars)) < -1), MATCH($A1474, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1535), $A1535, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1538, YTD_Actual), SUMIF(PE, $A1538, YTD_Budget), SUMIF(PE, $A1538, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1538, YTD_Actual), SUMIF(PE, $A1538, YTD_Budget), SUMIF(PE, $A1538, YTD_Variance_Dollars)) < -1), MATCH($A1538, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1599), $A1599, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1602, YTD_Actual), SUMIF(PE, $A1602, YTD_Budget), SUMIF(PE, $A1602, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1602, YTD_Actual), SUMIF(PE, $A1602, YTD_Budget), SUMIF(PE, $A1602, YTD_Variance_Dollars)) < -1), MATCH($A1602, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1663), $A1663, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1666, YTD_Actual), SUMIF(PE, $A1666, YTD_Budget), SUMIF(PE, $A1666, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1666, YTD_Actual), SUMIF(PE, $A1666, YTD_Budget), SUMIF(PE, $A1666, YTD_Variance_Dollars)) < -1), MATCH($A1666, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1727), $A1727, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1730, YTD_Actual), SUMIF(PE, $A1730, YTD_Budget), SUMIF(PE, $A1730, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1730, YTD_Actual), SUMIF(PE, $A1730, YTD_Budget), SUMIF(PE, $A1730, YTD_Variance_Dollars)) < -1), MATCH($A1730, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1791), $A1791, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1794, YTD_Actual), SUMIF(PE, $A1794, YTD_Budget), SUMIF(PE, $A1794, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1794, YTD_Actual), SUMIF(PE, $A1794, YTD_Budget), SUMIF(PE, $A1794, YTD_Variance_Dollars)) < -1), MATCH($A1794, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1855), $A1855, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1858, YTD_Actual), SUMIF(PE, $A1858, YTD_Budget), SUMIF(PE, $A1858, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1858, YTD_Actual), SUMIF(PE, $A1858, YTD_Budget), SUMIF(PE, $A1858, YTD_Variance_Dollars)) < -1), MATCH($A1858, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1919), $A1919, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1922, YTD_Actual), SUMIF(PE, $A1922, YTD_Budget), SUMIF(PE, $A1922, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1922, YTD_Actual), SUMIF(PE, $A1922, YTD_Budget), SUMIF(PE, $A1922, YTD_Variance_Dollars)) < -1), MATCH($A1922, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,{"$f":"IF(ISERROR($B1983), $A1983, \"\")","v":""}]
[0,0,""]
[0,0,""]
[{"$f":"PE","v":0},{"$f":"IF(OR(AVERAGE(SUMIF(PE, $A1986, YTD_Actual), SUMIF(PE, $A1986, YTD_Budget), SUMIF(PE, $A1986, YTD_Variance_Dollars)) > 1, AVERAGE(SUMIF(PE, $A1986, YTD_Actual), SUMIF(PE, $A1986, YTD_Budget), SUMIF(PE, $A1986, YTD_Variance_Dollars)) < -1), MATCH($A1986, PE_Exp_Report, 0) + 10, 0)","v":0},""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]
[0,0,""]

{"sheet":"SOFIA Query","index":2,"n_rows":574,"n_cols":12,"rows_kept":574,"cut":false,"hidden":true,"merged":[]}
["PE","Walker Description","YTD Actual","YTD Budget","YTD Variance $","YTD Variance %"]
["0090","PERDIDO LANDFILL GAS TO ENERGY PROJECT",1035.03,0,1035.03,1]
["0091","PERDIDO LANDFILL GAS ENERGY",0,60000,-60000,-1]
["1001","ECRC-CRIST-4-5 OPACITY REPLACEMENT",0,0,0,0]
["1002","CRIST UNIT 5 TURBINE CONTROL REPLACEMENT",0,0,0,0]
["1004","CRIST 6 AIR HEATER BASKETS",0,0,0,0]
["1005","CRIST UNIT 4 TURBINE CONTROL REPLACEMENT",0,0,0,0]
["1007","CRIST 7 HRA SIDEWALLS HEADER TO HEADER",0,0,0,0]
["1009","CRIST 7 REHEATER",20959.32,0,20959.32,1]
["1010","CRIST U6 PRIMARY SUPERHEATER REPLACEMENT",2245202.77,1249992,995210.77,0.79617371151175398]
["1013","CRIST 6 HRA SIDEWALLS HEADER TO HEADER",3088216.67,3450000,-361783.33,-0.104864733333333]
["1015","CRIST 6 STATIC EXCITER AND VOLTAGE REGULATOR",1290455.81,1099998,190457.81,0.173143778443234]
["1017","CRIST 7 STATIC EXCITER AND VOLTAGE REGULATOR",410541.99,0,410541.99,1]
["1019","CRIST 4 HP ROTOR & BLADES",0,0,0,0]
["1024","CRIST 7 - 7A 4160 VAC VOLT BREAKERS 1",0,0,0,0]
["1026","CRIST 6 PRIMARY/SECONDARY ASH COLLECTOR REPLACEMENT",0,0,0,0]
["1028","CRIST 7 PRIMARY/SECONDARY ASH COLLECTOR REPLACEMENT",0,0,0,0]
["1031","ECRC AIR CRIST UNIT 7 SCR CATALYST REPLACEMENT",213075.4,150000,63075.4,0.42050266666666702]
["1033","ENVIR-WASTE-CRIST FLY ASH LANDFILL STORAGE CELL CAPPING",0,0,0,0]
["1034","CRIST U6 BREAKERS CABLE & SWITCHES PER ARC FLASH STUDY",0,100000,-100000,-1]
["1038","ECRC-AIR-CRIST 6 UPGR PRECIP",840040.5,150000,690040.5,4.6002700000000001]
["1039","CRIST 5 BOTTOM ASH DOGHOUSE AND SLUICE GATE",0,0,0,0]
["1042","CRIST MODE 2&3 ASH SYSTEM REMOVAL EQUIPMENT",0,0,0,0]
["1050","CRIST UNIT 4 FOSTER BOILER SAFETY RELIEF VALVE REPLACEMENT",0,0,0,0]
["1051","CRIST UNIT 5 FOSTER BOILER SAFETY RELIEF VALVE REPLACEMENT",0,0,0,0]
["1052","CRIST 6 - 6A 4160 VOLT BREAKERS",816737.73,199998,616739.73,3.0837294872948702]
["1053","CRIST 6 - 6B 4160 VOLT BREAKERS",310185.94,187500,122685.94,0.65432501333333304]
["1054","CRIST REPLACEMENT OF UNIT 5 ECONOMIZER INLET HEADER",0,0,0,0]
["1060","ECRC-AIR-CRIST 7 FGAS MONITORS",0,45000,-45000,-1]
["1065","CRIST 7 CONDENSER CLEANING SYSTEM",0,0,0,0]
["1066","CRIST 6 REHEAT SPRAY SYSTEM",255408.03,250000,5408.03,2.1632120000000001E-2]
["1068","CRIST 7 RETIREMENT OF COOLING TOWER NON-ECRC",0,0,0,0]
["1069","CRIST U6 #2 DEMINERALIZER",0,0,0,0]
["1070","CRIST 6 & 7 REPLACE COOLING TOWER BUILDING",0,0,0,0]
["1072","CRIST 4-7 NITROGEN CAPPING SYSTEM",0,210200,-210200,-1]
["1076","CRIST UNIT 7 HYDROGEN COOLER",0,0,0,0]
["1077","CRIST UNIT 6 TURBINE OIL COOLER",154529.91,144942,9587.91,6.61499772322722E-2]
["1078","ENVIR-WATER-CRIST-CMN INTAKE SCREEN & CIRC WATER PUMP PIPING",0,0,0,0]
["1081","CRIST HURRICANE SHELTERS",0,0,0,0]
["1088","CRIST UNIT 6 FINISHING SUPERHEAT HEADER",0,460000,-460000,-1]
["1090","CRIST 7 AIRHEATER SOOT BLOWERS",0,0,0,0]
["1091","CRIST 7 AIR HEATER BASKETS",0,0,0,0]
["1092","CRIST 7 REPLACE FINISHING SUPER HEAT OUTLET HEADER",0,600000,-600000,-1]
["1093","CRIST 6 HYDROGEN COOLERS",0,0,0,0]
["1094","CRIST FUEL HANDLING CRANE",4529334.1500000004,7327603,-2798268.85,-0.38188052081969998]
["1096","CRIST UNIT 6 SERVICE WATER COOLER REPLACEMENT",0,0,0,0]
["1097","CRIST 6 - DIVISION WALL HEADER",0,0,0,0]
["1100","CRIST-MINOR MISC ITEMS",383641.76,249900,133741.76000000001,0.53518111244497801]
["1104","CRIST 7 SUPERHEAT SPRAY NOZZLE HEADER",0,0,0,0]
["1105","CRIST-#9 CONVEYOR STRUCTURAL METAL",0,0,0,0]
["1110","CRIST-7 REHEAT OUTLET HEADER REPLACEMENT",2974.34,0,2974.34,1]
["1111","CRIST-6 LOWER ECNONMIZER AND HEADER REPLACEMENT",1590463.62,2450000,-859536.38,-0.35083117551020399]
["1114","CRIST 5-PULVERIZED COAL PIPING",45180.78,749700,-704519.22,-0.93973485394157696]
["1116","CRIST-5 GENERATOR STATOR REWIND",0,0,0,0]
["1121","CRIST 6 REHEAT HEADER",226240.95,1100000,-873759.05,-0.79432640909090901]
["1122","CRIST BARGE HAUL SYSTEM",172608.32,0,172608.32,1]
["1123","CRIST #7 CONDENSER EXPANSION JOINTS",0,0,0,0]
["1125","CRIST #7C CONDENSATE PUMP MOTOR",0,0,0,0]
["1126","CRIST 4 & 5 REPLACE INTAKE SCREENS",201395.14,0,201395.14,1]
["1128","CRIST INTAKE SCREENS",0,0,0,0]
["1131","CRIST #7 CIRCULATION WATER ISOLATION VALUES & EXPAN JOINTS",0,0,0,0]
["1133","CRIST 6 FD FAN OUTLET POSITIONER REPLACEMENTS",18399.79,137500,-119100.21,-0.86618334545454501]
["1134","CRIST 6 CONTROL UPGRADE",80986.28,385000,-304013.71999999997,-0.789646025974026]
["1135","CRIST 5 L-O TURBINE BLADE",0,0,0,0]
["1136","CRIST 5-16,17 AND 18 STAGE TURBINE BLADE",0,0,0,0]
["1137","CRIST 6 GRAPHICS UPGRADE",0,330000,-330000,-1]
["1141","CRIST 7 MAIN TURBINE OIL COOLERS",206039.88,0,206039.88,1]
["1144","CRIST 7 OVATION 400 CONTROLLERS REPLACEMENT",0,0,0,0]
["1146","CRIST 7 BATTER BANK",196410.63,250000,-53589.37,-0.21435747999999999]
["1147","CRIST 4&5 BATTER BANK",53149.43,0,53149.43,1]
["1148","CRIST - MISC ITEMS",1338799.73,250008,1088791.73,4.3550275591181098]
["1149","CRIST 4-7 ASH SYSTEM AIR COMPRESSOR",0,0,0,0]
["1150","CRIST 6 - BATTERY BANK",318044.76,250000,68044.759999999995,0.27217903999999998]
["1152","CRIST CONDENSATE MAKEUP PIPING",0,0,0,0]
["1155","ECRC-WATER-CRIST-INSTALL RAW WATER WELL FLOWMETERS",0,0,0,0]
["1158","ECRC-AIR-CRIST SCR U7 MISC",12600,25002,-12402,-0.49604031677465799]
["1159","CRIST U7 REPL BREAKERS CABLE & SWITCHES PER ARC FLASH STUDY",329096.34000000003,87468,241628.34,2.7624770201673798]
["1167","ECRC-AIR-CRIST SNCR MISCELLANEOUS",6018.24,12498,-6479.76,-0.51846375420067203]
["1169","CRIST 6 REPLACE COLD END AIR HEATER BASKETS",0,0,0,0]
["1172","CRIST U5 REPL BREAKERS CABLE & SWITHCES FOR ARC FLASH STUDY",0,0,0,0]
["1173","CRIST 7 6A HIGH PRESSURE HEATER",0,0,0,0]
["1175","ECRC AIR CRIST 4 PRECIPITATOR INTERNALS (PLATE WIRE SUPPORT)",0,0,0,0]
["1177","CRIST U6 SW COOLER REPLACEMENT",0,500000,-500000,-1]
["1178","ECRC-WATER-CRIST ECUA RECLAIM ACID ADD SYSTEM",0,200000,-200000,-1]
["1191","ECRC-AIR CRIST 5 PRECIPITATOR INTERNALS (PLATE WIRE SUPPORT)",0,0,0,0]
["1196","CRIST 6 REHEAT AND SUPERHEAT DAMPERS",697559.8,415800,281759.8,0.67763299663299703]
["1199","ECRC-AIR-CRIST 7 ELECTROSTATIC PRECIP (ESP) REPLACMNT",0,0,0,0]
["1200","CRIST 6&7 IGNITER AIR SYSTEM",0,0,0,0]
["1201","CRIST TRACTOR TO REPLACE D1ON",0,0,0,0]
["1202","CRIST 6 ASH SYSTEM 600 VAC MCC",0,0,0,0]
["1203","CRIST UNIT 7 ASH SYSTEM 600 VAC M",0,0,0,0]
["1204","ECRC CRIST 6 REPLACE CONDENSER TUBES",0,0,0,0]
["1209","CRIST ASH SYSTEM AIR COMPRESSORS",80963.360000000001,135000,-54036.639999999999,-0.40027140740740702]
["1210","CRIST CYBER SECURITY",3501.31,199920,-196418.69,-0.98248644457783096]
["1211","ECRC-WATER-CRIST ASH POND MONITORING WELLS",0,0,0,0]
["1221","CRIST REPLACE HYDROMIXERS",420097.96,1000000,-579902.04,-0.57990204000000001]
["1222","ECRC-AIR-CRIST SCRUBBER",7358450.71,7769141,-410690.29,-5.2861737224231098E-2]
["1227","ECRC-CRIST WATER CONSERVATION PROJECT",0,0,0,0]
["1230","CRIST 6 REPL REHEATER",4748157.16,1732500,3015657.16,1.7406390533910501]
["1231","CRIST 6&7 BOILER AWARE PROGRAM",0,80000,-80000,-1]
["1233","ECRC-AIR-CRIST SCRUBBER MISCELLANEOUS",125753.63,75000,50753.63,0.67671506666666703]
["1235","CRIST SECURITY MAIN BLDG",0,0,0,0]
["1237","ENVIR-CRIST-REPLACE PLANT SCADA SYSTEM",0,0,0,0]
["1238","ENVIR-CRIST-REPLACE PLANT LDMS SYSTEM",0,0,0,0]
["1244","ECRC-AIR-CRIST RATA CEM TEST TRAILER",0,0,0,0]
["1247","ECRC-AIR-CRIST 4&5 BYPASS STACK CEMS EQUIPMENT",-391049.08,0,-391049.08,1]
["1249","ECRC CRIST 6 PRECIP VOLTAGE CONTROL",0,0,0,0]
["1250","ECRC AIR CRIST 7 SCR ASH PIPING& VIBRATORS",0,0,0,0]
["1251","ENVIR - WASTE - CRIST COMMON INTERIM LANDFILL II",0,0,0,0]
["1253","ENVIR-WASTE-CRIST FLY ASH LANDFILL STORAGE CELL DEVEL",0,0,0,0]
["1254","CRIST COMMON CONVEYOR BELTS REPLACEMENT",137760.76,0,137760.76,1]
["1256","ECRC -  AIR - CRIST 6&7 BY PASS STACK CEMS EQUIPMENT",453664.73,0,453664.73,1]
["1257","CRIST 4-7 DEMINERALIZER NEUTRALIZATION BASIN PUMPS",0,0,0,0]
["1258","CRIST 4-7 DEMINERALIZER CONTROLS REPLACEMENT",102350.52,0,102350.52,1]
["1259","CRIST UNITS 6&7 SIMULATOR AND ENGINEERING WORKSTATION",0,0,0,0]
["1262","CRIST UNIT 6 HOT REHEAT PIPING",19526.84,1000002,-980475.16,-0.98047319905360197]
["1266","CRIST 4-7 NEW SIDE COAL YARD 4160 VOLT BREAKERS",0,0,0,0]
["1267","CRIST 4-7 NEW SIDE COAL YARD 575 VOLT BREAKERS",122223.85,0,122223.85,1]
["1272","ECRC - CRIST - SWITCHYARD SPCC PROJECT",0,0,0,0]
["1276","ENVIR-WASTE-CRIST ASH POND DISCHARGE WEIR REPLACEMENT",243096.63,0,243096.63,1]
["1278","CRIST UNITS 6-7 ELEVATOR REPLACEMENT",0,0,0,0]
["1279","ECRC-AIR-CRIST 6 SCR",49686940.439999998,45106612,4580328.4400000004,0.101544501724049]
["1280","ECRC-WATER-CRIST COMMON SURFACE WATER SAMPLING BOAT",0,0,0,0]
["1281","CRIST 4-7 ENGINE GENERATOR",0,0,0,0]
["1283","ECRC-AIR-CRIST 4-7 CEMS SYSTEM FOR SCRUBBERS",0,0,0,0]
["1284","ECRC-AIR-CRIST 7GAS CANE COOLING FANS",0,0,0,0]
["1285","CRIST ROLLING DOORS AND DIESEL SUMP PUMPS",0,0,0,0]
["1287","ECRC-AIR-CRIST 4-5-6 NOX REDUCTION EQUIPMENT",0.08,0,0.08,1]
["1292","CRIST COAL CONVEYOR FIRE SYSTEM",0,0,0,0]
["1294","CRIST COMMON PURCHASE OF D-10 TRACK DOZIER",0,0,0,0]
["1298","ECRC - CRIST WATER CONSERVATION PROGRAM",345746.29,440000,-94253.71,-0.21421297727272701]
["1299","ECRC-WATER-CRIST 4-7 ASH POND CHEMISTRY CONTROL",604.4,0,604.4,1]
["1300","SCHOLZ - MISC. STEAM PLANT ADDITIONS",48051.72,60000,-11948.28,-0.19913800000000001]
["1305","ECRC-AIR SCHOLZ 2 PRECIP PLATES & WIRES",0,0,0,0]
["1324","ECRC-AIR-REPLACE SCHOLZ UNIT 1 CEMS FLOW MONITORS",0,0,0,0]
["1331","SCHOLZ 2 REPLACE #4 FEED WATER HEATER TUBE BUNDLE",0,0,0,0]
["1357","ECRC-AIR-SCHOLZ 1 & 2 CEMS REPLACEMENT",0,0,0,0]
["1362","ECRC-AIR-SCHOLZ MERCURY MONITORING",0,0,0,0]
["1400","SMITH 1&2 - MISC. STEAM PLANT ADDITIONS",123177.77,212418,-89240.23,-0.42011613893361199]
["1401","SMITH REPLOACE CONTROL ROOM ROOF",0,0,0,0]
["1402","SMITH REPLACE PLANT ADMIN ROOF",0,0,0,0]
["1403","SMITH 3 - 3A & 3B GAS TURBINES AIR FILTRATION SYSTEM",52576.47,0,52576.47,1]
["1404","ECRC-SMITH-WATER-SPCC UPGRADE",0,0,0,0]
["1405","SMITH UNIT 1-NON ECRC COST OF REMOVAL ON SNCR UNIT 1 PROJECT",0,0,0,0]
["1413","SMITH UNIT 1 & 2 EXPANSION JOINT REPLACEMENTS",0,0,0,0]
["1417","SMITH UNIT#2 REPLACE HORIZONTAL SUPERHEATER",0,0,0,0]
["1420","SMITH 1 DCS UPGRADE AND CONTROL ROOM MODIFICATIONS",0,0,0,0]
["1421","SMITH - UNIT A COMBUSTION TURBINE CONTROLS REPLACEMENT",1881592.34,0,1881592.34,1]
["1424","SMITH 3 - TURBINE CONTROLS REPLACEMENT",0,1500000,-1500000,-1]
["1427","SMITH 1 - VACUUM PUMPS",0,250000,-250000,-1]
["1429","SMITH UNIT #1 REPLACE HORIZONAL SUPERHEATER",0,0,0,0]
["1434","SMITH 1 - FLY ASH AND SOOTBLOWER CONTROLS",0,200000,-200000,-1]
["1435","SMITH UNIT #2 REPLACE HP TURBINE BLADES",0,0,0,0]
["1436","SMITH UNIT #1 REPLACE HP TURBINE BLADES",0,0,0,0]
["1438","SMITH 3 - LTSA",0,0,0,0]
["1444","ECRC-AIR-SMITH 1 & 2 CEMS FLOW SYSTEM REPLACEMENT",0,0,0,0]
["1445","ECRC-AIR-SMITH 1 & 2 CEMS GAS MONITORS REPLACEMENT",0,0,0,0]
["1451","REPLACE SMITH UNIT #1 HOT REHEAT PIPING",0,0,0,0]
["1452","SMITH UNIT 2-REPLACE HOT REHEAT PIPING",0,0,0,0]
["1461","ECRC-SMITH UNIT 1 PRECIPITATOR AIR UPGRADE",0,0,0,0]
["1462","ECRC - AIR - SMITH UNIT 2 PRECIPITATOR UPGRADE",0,0,0,0]
["1465","SMITH 2 - REPLACE DUCTWORK/EXPANSION JOINTS",351.26,0,351.26,1]
["1468","ECRC-AIR-SMITH 1 SNCR",0,0,0,0]
["1469","ECRC-AIR-SMITH 2 SNCR",0,0,0,0]
["1471","SMITH 1 - REPLACE RETRACTS ON BOILERS",0,350000,-350000,-1]
["1482","SMITH 1 REPL LP FEEDWATER HEATER",0,0,0,0]
["1493","SMITH REPLACE CONDENSER PEDESTALS",0,0,0,0]
["1494","SMITH - AIR COMPRESSOR REPLACEMENT",0,0,0,0]
["1496","SMITH 2 - EXPANSION JOINT REPLACEMENT",192836.92,0,192836.92,1]
["1497","SMITH - REPLACE WALL BLOWERS",0,0,0,0]
["1498","SMITH 1 & 2 - SAFETY VALVE REPLACEMENT",0,0,0,0]
["1499","SMITH 3 OVATION CONTROL SYSTEM UPGRADE",0,0,0,0]
["1500","DANIEL-MISC. STEAM PLANT ADDITIONS & IMP.",77613.02,111907,-34293.980000000003,-0.306450713538921]
["1501","ECRC-DANIEL ASH POND WELL",0,36107,-36107,-1]
["1502","ECRC DANIEL SCRUBBER COMMON",0,1375301,-1375301,-1]
["1511","DANIEL 1 ACE TWIP C05254   MS PE 2155",0,0,0,0]
["1512","ECRC -AIR-DANIEL 1 ECO MERCURY MONITOR 2120",0,0,0,0]
["1513","ECRC AIR DANIEL 2 ECO MERCURY MONITOR 2121",0,0,0,0]
["1515","DANIEL 2 ACE TWIP C05348   MS PE 2185",458711.75,100286,358425.75,3.5740357577328798]
["1523","DANIEL WATER TREATMENT PLANT",0,0,0,0]
["1531","DANIEL 1 HP/IP TURBINE UPGRADE",0,0,0,0]
["1532","DANIEL 2 HP/IP TURBINE UPGRADE",5369263.9199999999,2613072,2756191.92,1.0547707525854599]
["1535","DANIEL 1 WESTINGHOUSE WDPF CONTROLS SYSTEM",0,0,0,0]
["1546","DANIEL 1 HYDROGEN COOLER TUBING",0,0,0,0]
["1551","ECRC-AIR-DANIEL 1 & 2 SCRUBBER",12459476.15,10485251,1974225.15,0.188285921815319]
["1552","ECRC-AIR-DANIEL 2 SCRUBBER",0,10473721,-10473721,-1]
["1555","ECRC - WASTE - DANIEL ASH STORAGE",11569.68,0,11569.68,1]
["1556","DANIEL 1 SUPERHEATER",0,0,0,0]
["1557","DANIEL 1&2 CONVEYOR BELT  1D  C01719",0,18792,-18792,-1]
["1559","DANIEL 1 MILL PIPING UNITS",0,0,0,0]
["1561","DANIEL 1 PRECI ASH VALVE & TRUNK LINE",0,0,0,0]
["1563","DANIEL 2 SUPERHEATER",0,0,0,0]
["1564","DANIEL 2 CAPITAL VALVE REPLACEMENTS C03256",34489.01,24801,9688.01,0.390629813313979]
["1567","DANIEL 1&2 CONTROL ROOM A/C SYSTEMS",0,100349,-100349,-1]
["1568","DANIEL 1 HOT AIR HEATER BASKET",298.51,0,298.51,1]
["1569","DANIEL 2 HOT AIR HEATER BASKET",403142.62,376315,26827.62,7.1290328581108897E-2]
["1570","ECRC AIR DANIEL CEMS GAS ANALYZERS",0,0,0,0]
["1572","DANIEL 1&2 FIRE PROTECTION CONTROLS",0,37500,-37500,-1]
["1576","DANIEL 2 CONDENSER TUBES",0,0,0,0]
["1581","DANIEL !&2 CONVEYOR DIRECT DRIVE GEARBOXES C07627",0,110429,-110429,-1]
["1583","DANIEL 2 MILL PIPING",0,0,0,0]
["1584","DANIEL 1&2 AIR COMPRESSORS C07607 1D & 2B",0,140491,-140491,-1]
["1585","DANIEL 2 INLET VANES ON PA FANS",0,185702,-185702,-1]
["1592","ECRC-AIR-DANIEL 1 & 2 CEMS BACKUP AIR COMPRESSOR",3092.53,0,3092.53,1]
["1593","DANIEL 2D BWCP REPLACEMENT",193399.58,0,193399.58,1]
["1600","SMITH 3 - MISC. STEAM PLANT ADDITIONS",1251403.92,599760,651643.92000000004,1.0865078031212501]
["1601","ECRC-WATER-SMITH RECLAIMED WATER PROJECT UNIT 3",0,2514286,-2514286,-1]
["1604","SMITH - BUILD NEW WAREHOUSE FOR INVENTORY",9500,0,9500,1]
["1607","SMITH - FISH EXCLUSION DEVICE",281275.78999999998,0,281275.78999999998,1]
["1610","SMITH - CYBER SECURITY",145486.73000000001,83620,61866.73,0.73985565654149699]
["1611","SMITH 3 - WATER LAB BUILDING REPLACEMENT",90391.93,0,90391.93,1]
["1613","ENVIRONMENTAL-WASTE-SMITH CAP ASH LANDFILL CELLS",209609.86,0,209609.86,1]
["1619","SMITH 3 - AIR HANDLING UNIT",0,85000,-85000,-1]
["1640","ENVIRONMENTAL-AIR-SMITH 3 CEMS REPLACEMENT",13736.68,0,13736.68,1]
["1647","ECRC-AIR-SMITH 1&2 MERCURY MONITORING",0,0,0,0]
["1649","SMITH 1&2 NO 2 & S BELT REPLACEMENTS",0,0,0,0]
["1650","SMITH-INSTALL TRIPPER CONTROLS",0,0,0,0]
["1653","SMITH - PURCHASE NEW COAL TRACTOR",0,0,0,0]
["1654","SMITH 1&2 - REPLACE 20 TON AIR CONDITIONER",0,0,0,0]
["1655","SMITH NEW #6 WELL",0,0,0,0]
["1656","SMITH 1&2 REPLACE NO.1 AND TRIPPER BELTS",3764.68,0,3764.68,1]
["1657","SMITH - RESTORE ELECTRIC SHOP AFTER FIRE",0,0,0,0]
["1659","SMITH UPGRADE ELEVATOR AND CONTROLS",0,0,0,0]
["1666","SMITH UNIT 3 - REPLACE COOLING TOWER MAKEUP PUMP",0,0,0,0]
["1670","SMITH - DUST SUPPRESSION SYSTEM FOR TRIPPER FLOOR",0,0,0,0]
["1671","SMITH 3 - TURBINE VIBRATION MONITOR",0,0,0,0]
["1673","SMITH-CATEGORY 5 HURRICANE SHELTERS",0,0,0,0]
["1674","SMITH-U2 GENERATOR HYDROGEN SEALS",0,0,0,0]
["1677","ENVIR-WATER-SMITH COMMON FISH EXCLUSION DEVICE",0,0,0,0]
["1678","SMITH UNIT 1 PRECIPITATOR RETIREMENT",0,0,0,0]
["1679","SMITH 3 - CORROSION PROJECT",124341.82,400000,-275658.18,-0.68914545000000005]
["1680","SMITH AUTOMATIC FIRE PROTECTION #2 CONVEYOR BELT",0,0,0,0]
["1681","SMITH - #1 AUTOMATIC FIRE PROTECTION",0,0,0,0]
["1683","SMITH - BOILER FEED PUMP MOTOR",0,0,0,0]
["1684","ECRC-AIR-SMITH CT AIR PARAMETRIC MONITOR",0,0,0,0]
["1685","SMITH U1 A SERVICE WATER UPDATE",0,0,0,0]
["1686","SMITH U1 EXTRACTION STEAM EXPANSION JOINTS",0,0,0,0]
["1687","SMITH U1 EXPANSION JOINTS",0,0,0,0]
["1688","SMITH - STACK BREACH WORK AND JOINT REPAIRS",0,0,0,0]
["1689","SMITH COMBUSTION TURBINE GENERATOR FIELD REWIND",0,0,0,0]
["1692","SMITH 3 - SPARE ROTOR ASSEMBLY",0,0,0,0]
["1699","SMITH 1&2 SEAWALL FLOOD GATES",0,0,0,0]
["1700","SCHERER-MISC. ADDITIONS & IMPROVEMENTS",1619915.28,0,1619915.28,1]
["1705","SCHERER 3 SUPERHEATER OUTLET",25394.94,0,25394.94,1]
["1707","SCHERER 3&4 RELOCATION OF FIRE HOUSE TRESTLE",-367.5,0,-367.5,1]
["1708","SCHERER 3 PULVERIZER GEARBOX REPLACEMENT",0,0,0,0]
["1709","SCHERER 3 HP TURBINE ROTOR",-123148.66,375750,-498898.66,-1.32774094477711]
["1716","SCHERER PORTABLE EQUIPMENT",0,14330,-14330,-1]
["1717","SCHERER LAND PURCHASE",6883.84,15625,-8741.16,-0.55943423999999997]
["1721","SCHERER -TRACKED DOZER",0,90686,-90686,-1]
["1727","ENVIR-AIR-SCHERER SELECTIVE CATALYTIC REDUCT (SCR)",1333406.73,2618619,-1285212.27,-0.490797733461798]
["1728","ENVIR-AIR-SCHERER SCRUBBER",4113305.28,3794918,318387.28000000003,8.38983292919636E-2]
["1729","ENVIR-AIR-SCHERER BAGHOUSE",134778.82999999999,466349,-331570.17,-0.71099148920658095]
["1732","SCHERER 3 REPLACE CHILLER",101343.7,0,101343.7,1]
["1733","SCHERER 3 BOILER SONIC CLEANING EQUIP",60740.6,0,60740.6,1]
["1734","SCHERER 3 REPLACE FSSS",0,0,0,0]
["1736","SCHERER REPLACE MOVE AND REPLACE TRESTLE FEEDERS",0,625,-625,-1]
["1737","SCHERER 3 REPLACE SERVICE WATER PIPING",0,0,0,0]
["1739","SCHERER 3 REPLACE GENERATOR 500KV BREAKER",289563.36,0,289563.36,1]
["1740","SCHERER 3 REPLACE MAIN TURBINE CONTROLS",0,0,0,0]
["1742","SCHERER 3 REPL STATION SERV TRANSFORMER",0,250000,-250000,-1]
["1743","SCHERER COMMON SERVICE WATER PIPING",129.93,0,129.93,1]
["1747","SCHERER 3 BOILER WATER CIRC PUMP",21.17,0,21.17,1]
["1749","ENVIRON SCHERER HG CONTROL MONITORS",0,0,0,0]
["1750","SCHERER - MISC ADDITIONS AND IMPROVMENTS",87753.73,212578,-124824.27,-0.58719279511520495]
["1752","SCHERER - REPLACE COAL SAMPLING SYSTEM 3-4",0,0,0,0]
["1754","SCHERER SCRAPER PAN - COMMON",0,0,0,0]
["1755","SCHERER TRESTLE DUST SUPPRESSION COMMON",-6581.63,0,-6581.63,1]
["1757","SCHERER 3 REPLACE AIR HEATER BASKETS",54332.41,0,54332.41,1]
["1758","SCHERER 3 GENERATOR FIELD REWIND",0,0,0,0]
["1759","SCHERER 3 REPLACE PFP VOLUTE",0,0,0,0]
["1761","SCHERER 3 CONDENSATE POLISHER",0,1250,-1250,-1]
["1762","SCHERER 3 FLY ASH HOPPER LEVEL MONITORING SYSTEM",0,0,0,0]
["1763","SCHERER 3 CYCLE ISOLATION VALVE",0,0,0,0]
["1765","ENVIRONMENTAL SCHERER 3 INSTALL O2/CO ANALYZERS",0,81500,-81500,-1]
["1766","SCHERER 3 & 4 REPLACE 3D - DUSTLESS TRANSFER",10197.08,0,10197.08,1]
["1767","SCHERER 3 & 4 INSTALL ELEVATOR AT C CRUSHER HOUSE",7457.01,75000,-67542.990000000005,-0.90057319999999996]
["1769","SCHERER 3 & 4 INSTALL SERVICE WATER LINE FOR DUST SUPPRESSIO",0,57813,-57813,-1]
["1771","SCHERER 3 REPLACE BFP VALVES",0,0,0,0]
["1772","SCHERER - REPLACE SERVICE BLDG AH UNIT AND CONTROLS",0,1014,-1014,-1]
["1773","SCHERER COMMON REPLACE COAL PILE RUN-OFF POND PIPING",9547.59,0,9547.59,1]
["1774","SCHERER 3 REPLACE FRONT PENDANT REHEATER",1537.55,750,787.55,1.05006666666667]
["1775","SCHERER 3 REPLACE SOOTBLOWER CONTROLS",28317.33,0,28317.33,1]
["1777","SCHERER REPLACE 4A & 4B TRANSFER CHUTE",0,0,0,0]
["1778","ENVIR - SCHERER - ENVIRONMENTAL SITE PLAN",432875.69,468920,-36044.31,-7.6866651027893904E-2]
["1781","SCHERER - REPLACEMENT OF SIMULATOR SOFTWARE",0,0,0,0]
["1782","SCHERER UNIT 3 BOILER WATER CIRCULATING PUMP 3D",0,0,0,0]
["1783","SCHERER 3 REPLACE ER & EL CONVEYOR CHUTES 358701",0,0,0,0]
["1784","SCHERER 3 TRAVELING WATER SCREEN ON COOLING TOWER 369703",589.98,0,589.98,1]
["1785","SCHERER COMMON REVERSE OSMOSIS WATER TREATMENT PLANT",8352.59,0,8352.59,1]
["1786","SCHERER 3 REPLACE COAL TRANSPORT LINES 369703",0,0,0,0]
["1787","SCHERER 3 REPLACE FLAME SCANNERS 369703",0,0,0,0]
["1789","SCHERER 3 REPLACE CONDENSATE MOTOR",0,0,0,0]
["1791","ENVIR-SCHERER 3 RADIANT REHEAT SURFACE BOILER MODIFICATIONS",0,0,0,0]
["1794","SCHERER 3 & 4 REPLACE 3D FIXED TRIPPER CHUTES",0,0,0,0]
["1799","SCHERER - INSTALL SECURITY SYSTEM",0,0,0,0]
["1801","DANIEL COMMON FLOOR DRAINS AND WASH SYSTEM",0,0,0,0]
["1802","DANIEL 1 CONVEYOR BELT WASH SYSTEM",0,0,0,0]
["1803","DANIEL 2 CONVEYOR BELT WASH SYSTEM",0,0,0,0]
["1804","DANIEL 1&2 DUSTLESS TRANSFER CHUTES (4 CHUTES) 2037",0,0,0,0]
["1805","DANIEL 1&2 DUST EXTRACTION SYSTEM ON BUNKERS",0,0,0,0]
["1808","DANIEL UNIT 1&2 LAB ANALYSIS EQUIPMENT",0,0,0,0]
["1810","ECRC AIR DANIEL 2 ACTIVATED CARBON INJECTION C01769",0,0,0,0]
["1811","DANIEL 1 EXPANSION JOINTS C01693",0,0,0,0]
["1812","DANIEL 2 ECONOMIZER C02539",0,0,0,0]
["1813","DANIEL 1 HYDRO COOLER TUBING C02540",0,0,0,0]
["1814","DANIEL 2 EXPANSION JOINTS C00435 & C00437",93857.74,130373,-36515.26,-0.28008299264418202]
["1815","DANIEL COMMON 1-4 ACID CAUSTIC TANK SKID C02543",0,0,0,0]
["1821","DANIEL UNIT 2 BURNER NOZZLE TIPS",0,0,0,0]
["1822","DANIEL 1 VOLTAGE REGULATOR",0,0,0,0]
["1824","ECRC-AIR-DANIEL 1 LO NOX BURNERS",516.64,0,516.64,1]
["1826","ECRC-AIR-DANIEL 2 LO NOX BURNERS",0,0,0,0]
["1829","ECRC-DANIEL 1 FLOW MONITOR & PROBE (CEMS) C03392",0,0,0,0]
["1830","ECRC-DANIEL 2 FLOW MONITOR & PROBE (CEMS) C03394",0,0,0,0]
["1833","DANIEL U2 ROTATING TURBINE BLADE REPLACEMENT",0,0,0,0]
["1839","DANIEL 1 ECONOMIZER C02538",0,0,0,0]
["1840","DANIEL TRACTOR DOZER PURCHASE",892351.78,0,892351.78,1]
["1841","DANIEL BOILER FEED PUMP 1A",0,0,0,0]
["1842","DANIEL 1 GSU TRANSFORMER",201057.44,2503668,-2302610.56,-0.919694847719426]
["1843","DANIEL BOILER FEED PUMP 1B REPLACEMENT",0,0,0,0]
["1844","DANIEL 2 BOILER WATER CIRCULATING PUMP C04149",0,0,0,0]
["1846","DANIEL 2 BOILER FEED PUMP 2B C04157",0,0,0,0]
["1847","ECRC DANIEL SCRUBBER LAND",3315.26,0,3315.26,1]
["1848","DANIEL 1 EXPANSION JOINT REPLACEMENTS",0,0,0,0]
["1850","DANIEL 2 CLINKER GRINDERS",0,0,0,0]
["1851","DANIEL 1 ID FAN REPLACEMENT",0,0,0,0]
["1852","DANIEL U2 EXCITER REPLACEMENT",0,0,0,0]
["1854","DANIEL 1 PRECIPITATOR CONTROL ROOM HVAC",0,0,0,0]
["1855","DANIEL 2 PRECIPITATOR CONTROL ROOM HVAC",0,0,0,0]
["1859","DANIEL 1 LUBE OIL SKIDS ON ID FANS",0,0,0,0]
["1866","DANIEL 1 & 2 ID FAN DRIVES",0,0,0,0]
["1900","CRIST -REPLACE EXISTING PIPE & SUPPORT STRUCTURE ON 4&5 COOL",0,0,0,0]
["1901","CRIST - REPLACE EXISTING SUPPORT STRUCTURE ON 4 & 5 DUCT.",0,0,0,0]
["1903","CRIST AIR DRYER AND COMPRESSOR REPLACEMENT",0,0,0,0]
["1904","CRIST COMMON TRAVELING SCREENS",0,0,0,0]
["2550","CUSTOMER'S METERS",414096.46,432000,-17903.54,-4.1443379629629601E-2]
["2551","LINE TRANSFORMERS",3393091.83,3087000,306091.83,9.9155111758989306E-2]
["2552","NEW BUSINESS DISTRIBUTION",1791279.26,2745000,-953720.74,-0.34743924954462702]
["2553","NEW BUSINESS STREET LIGHTS",220249.15,280278,-60028.85,-0.21417610372558701]
["2554","NEW BUSINESS - UNDERGROUND",1772557.12,3327000,-1554442.88,-0.46722058310790499]
["2555","ADVANCED METERING INFRASTRUCTURE",8387734.4299999997,7214000,1173734.43,0.162702305239811]
["2556","PRIVATE STREET & YARD LIGHTS",714751.13,852185,-137433.87,-0.161272341099644]
["2558","ADVANCED ENERGY MANAGEMENT (AEM)",835918.49,1140788,-304869.51,-0.26724466772090899]
["2559","METER TREATERS",67766,148000,-80234,-0.54212162162162203]
["2601","SKYGEN 230KV POWER SUPPLY",0,0,0,0]
["2603","2603 BUILD SHAKY JOE SWAMP TRANSMISSION SUBSTATION",0,0,0,0]
["2604","TYNDALL AFB POWER SUPPLY",0,0,0,0]
["2801","TRANS SUB INFRASTRUCTURE PROJECTS",-131432.51,340000,-471432.51,-1.38656620588235]
["2802","TRANS LINE INFRASTRUCTURE PROJECT",3353228.17,1450000,1903228.17,1.3125711517241401]
["2803","ALLIGATOR SWAMP SVC",0,0,0,0]
["2804","FT.WALTON & PENSACOLA TRANS LINE ADD. & IMP",0,0,0,0]
["2806","CRIST-BRENTWOOD 115 KV REPLACE INSULATORS",500561.34,0,500561.34,1]
["2808","SHOAL RIVER-SANTA ROSA 230KV NEW TL",-1568.75,0,-1568.75,1]
["2809","SINAI CEMETARY SUBSTATION UPGRADE",0,0,0,0]
["2810","HIGHLAND  CTY-MILLERS FERRY 115KV LINE REPL",-93995.91,60000,-153995.91,-2.5665985]
["2812","SHOAL RVR 115KV LINE",0,0,0,0]
["2814","LAGUNA-SANTA ROSA 230KV CONVERSION",257778.04,311506,-53727.96,-0.172478090309657]
["2820","DEVILLIERS-GOULDING 115KV LINE RECONDUCTOR",0,0,0,0]
["2821","MILLER BAYOU 230/115 KV PWR SUPPLY",0,0,0,0]
["2822","TRANS LINE SWITCH REPLACEMENT PROJECT 2006-2008",2032.86,200000,-197967.14,-0.98983569999999999]
["2825","SINAI CEMETERY 230 KV REACTOR",103186.74,0,103186.74,1]
["2827","LAGUNA 230 KV SUB 50MVA REACTOR",0,0,0,0]
["2828","GLENDALE PROT & CONTROL SYS REPL",486259.99,650000,-163740.01,-0.25190770769230802]
["2830","WRIGHT-OCEAN CITY 115KV RECOND",0,0,0,0]
["2833","LULLWATER LONG BEACH 115 KV RECONDUCTOR",0,0,0,0]
["2837","WRIGHT RELAY MODERNIZATION 2015",3795.38,0,3795.38,1]
["2838","WEWA PROTECTION AND CONTROL REPLACEMENT",-57597.43,0,-57597.43,1]
["2839","BELLEVIEW 230 & 115KV PROT & CONTROL SYS REPL",0,0,0,0]
["2841","CALLAWAY-PARKER TAP LINE",0,0,0,0]
["2843","CALLAWAY 230 & 115KV PROT & CONTROL SYS REPL",932737.33,910000,22737.33,2.4986076923076899E-2]
["2844","SINAI -WOODRUFF 115KV FIBER INSTALLATION",197444.67,498750,-301305.33,-0.60412096240601498]
["2845","TRANSMISSION TOOLS & TEST EQUIPMENT (SGIG)",22702.92,0,22702.92,1]
["2846","TRANSMISSION ROW CLEARING",-20246.900000000001,0,-20246.900000000001,1]
["2850","BELLVIEW 230/115 KV BREAKER REPLACEMENT",0,0,0,0]
["2852","BRENTWOOD 230/115KV AUTOBANK",132258.22,100000,32258.22,0.32258219999999999]
["2853","LAGUNA BEACH 230-115KV AUTOBANK",3678518.72,4400000,-721481.28,-0.163973018181818]
["2854","WRIGHT-FT WALTON BEACH",456308.59,718750,-262441.40999999997,-0.365135874782609]
["2856","GULF BREEZE RELIABILITY UPGRADE",0,0,0,0]
["2859","OCEAN CITY LOWSIDE BUS REBUILD",0,0,0,0]
["2861","LAGUNA SANTA ROSA 115KV REPLACE INSULATORS",665510.68000000005,1402500,-736989.32,-0.52548258110516899]
["2863","RAT POND 115KV TAP - TL",1055400.6000000001,0,1055400.6000000001,1]
["2865","BRENTWOOD-PINE FOREST 115KV RECONDUCTOR",0,0,0,0]
["2867","HOLMES CREEK-HIGHLAND CITY NEW 230KV TL",921204.28,1815311,-894106.72,-0.49253638632719099]
["2869","CRIST 115KV CKT BRKR REPL",0,0,0,0]
["2874","SMITH-LAGUNA 230KV CONVERSION",14940163.51,15088167,-148003.49,-9.8092425673708596E-3]
["2876","BRENTWOOD- BAYOU CHICO 115KV RECONDUCTOR",1121.54,0,1121.54,1]
["2882","MOLINO - PINE FOREST 115KV RECONDUCTOR",63090.879999999997,399000,-335909.12,-0.84187749373433596]
["2886","RECONDUCTOR CRIST-BARRY 230KV LINE",1260.8699999999999,0,1260.8699999999999,1]
["2888","SINAI - CALLAWAY 115KV TL RECONDUCTOR",2030761.98,4355000,-2324238.02,-0.53369414925373104]
["2889","CRIST - AIR PRODUCTS REBUILD",0,565000,-565000,-1]
["2890","SLOCOMB - HOLMES CREEK 230KV REBUILD",0,120000,-120000,-1]
["2892","CRIST FILTERED CAPBANK",16374.01,4500000,-4483625.99,-0.99636133111111103]
["2894","S CRESTVIEW RELAY S HOUSE REPL",488748.41,0,488748.41,1]
["2895","BLACKWATER SUB 12KV FEEDER BAY",0,0,0,0]
["2896","SHOAL RVR 230/115KV RELAY S HOUSE REPL",0,0,0,0]
["2897","CALLAWAY 230KV RELAY S HOUSE REPL",0,0,0,0]
["3401","DIST SUB INFRASTRUCTURE PROJECTS",423178.17,250000,173178.17,0.69271267999999997]
["3402","MISC. DISTRIBUTION IMPROVEMENTS & REPL.",2566870.25,1704000,862870.25,0.50637925469483602]
["3403","DIST. ADDITIONS & RETIR. DUE TO HWY. COMM.",289622.05,378000,-88377.95,-0.233804100529101]
["3404","DISTRIBUTION LINE MINOR PROJECTS",585324.1,316000,269324.09999999998,0.85229145569620202]
["3405","UNDERGROUND SYSTEM ADDITIONS & IMPROVE.",840632.17,680000,160632.17000000001,0.23622377941176501]
["3406","DISTRIBUTION UNDERGROUND CONVERSIONS",1330105.8799999999,318000,1012105.88,3.1827228930817602]
["3407","MISC CAPITAL ACCRUALS",-883795.02,0,-883795.02,1]
["3408","DISTRIBUTION IMPROVEMENTS-OSMOSE",688284.71,869000,-180715.29,-0.20795775604142699]
["3412","ECRC-SUB WATER TREATMENT TRL",0,0,0,0]
["3418","GULF BREEZE RELIABILITY UPGRADE",0,0,0,0]
["3422","OCEAN CITY LOWSIDE BUS REBUILD",0,350000,-350000,-1]
["3423","SANDESTIN 115/12KV TX ADDITION",0,0,0,0]
["3428","JAY ROAD 115/12KV TX UPGRADE",0,0,0,0]
["3430","BEACH HAVEN 115KV 30 MVAR CAP BANK",0,0,0,0]
["3435","BRENTWOOD DS RELIABILITY UPGRADE",0,0,0,0]
["3440","BAY COUNTY SUB BANK UPGRADE AND NEW 12KV FEEDER BAY",926927.58,1600000,-673072.42,-0.4206702625]
["3445","CROOKED CREEK SUB NEW FEEDER",0,0,0,0]
["3448","DISTRIBUTION SUB RELAY SCHEME CHANGEOUTS",15002.37,0,15002.37,1]
["3449","BEAVER CREEK 115/12KV NEW SUBSTATION",0,0,0,0]
["3453","DIST 12KV BREAKER REPLACEMENT PROGRAM 2006-2007",0,50000,-50000,-1]
["3454","EAST CRESTVIEW 12KV BREAKER ADDITION",0,0,0,0]
["3455","GRACEVILLE 115/12KV TX UPGRADE",0,0,0,0]
["3456","HATHAWAY BANK UPGRADES 2006-2007",0,0,0,0]
["3457","LULLWATER BANK UPGRADE 2005-2006",0,0,0,0]
["3458","REGULATOR REPLACEMENTS",0,0,0,0]
["3459","CAVERNS ROAD 115/12KV TX UPGRADE",0,0,0,0]
["3460","EAST BAY 115/12KV BANK #3 2006-2007",0,0,0,0]
["3461","NAVARRE 115/12KV BANK #2 2007-2008",1083877.23,1440000,-356122.77,-0.24730747916666701]
["3462","GRACEVILLE 30 MVAR CAPACITY BANK 2008-2009",0,0,0,0]
["3463","AVALON 115KV 30 MVAR CAPACITOR BANK 2007-2008",0,0,0,0]
["3467","CRYSTAL BEACH NEW 12KV BAY",0,0,0,0]
["3468","CROOKED CREEK NEW 12KV BAY",0,0,0,0]
["3469","LULLWATER 115 KVCAPBANK",0,0,0,0]
["3475","MOBILE TRANSFORMER",0,0,0,0]
["3476","BEACH HAVEN RELAY MODERNIZATION 2008",-5488.08,0,-5488.08,1]
["3477","VALPARAISO RELAY MODERNIZATION 2008",0,0,0,0]
["3478","MONSANTO PROT & CONTROL SYS. REPL",0,0,0,0]
["3479","EASTGATE RELAY MODERNIZATION 2010",37775.629999999997,40000,-2224.37,-5.5609250000000103E-2]
["3480","REDWOOD RELAY MODERNIZATION 2010",0,0,0,0]
["3481","GREENWOOD PROT & CONTROL SYS REPL",-77459.259999999995,0,-77459.259999999995,1]
["3483","GOULDING PROT & CONTROL SYS REPL",300792.59000000003,1235000,-934207.41,-0.75644324696356302]
["3484","BAYOU CHICO PROT & CONTROL SYS REPL",0,40000,-40000,-1]
["3487","LONG BEACH PROT & CONTROL SYS REPL",4626.8100000000004,0,4626.8100000000004,1]
["3488","LIVE OAK PROT & CONTROL SYS REPL",0,0,0,0]
["3491","HENDERSON PARK SUB 115/12 KV NEW SUB AND FEEDER",2031301.73,3105000,-1073698.27,-0.345796544283414]
["3498","SMART GRID - ECONOMIC STIMULUS",2191049.13,990000,1201049.1299999999,1.2131809393939399]
["3499","EST DSO EXP CLEARANCE",0,0,0,0]
["3500","ASSET MANAGEMENT IMPROVEMENT PROGRAMS",208108.6,927000,-718891.4,-0.77550312837109003]
["3501","MISC DISTRIBUTION LINE SPECIFIC FEEDER IMPROVS",4512.18,626000,-621487.81999999995,-0.99279204472843396]
["3502","SHOAL RIVER OCB 9812",0,0,0,0]
["3503","GRACEVILLE SUB - OCB 9112 RECOND",0,0,0,0]
["3505","CANTONMENT SUB - OCB 6992 RECONDUCTOR",0,0,0,0]
["3507","NAVY FEDERAL-NATURE WALK",0,0,0,0]
["3509","PACE SUB - OCB 7022 PHASE ADDITION",0,0,0,0]
["3511","DEVILLIERS SUB - OCB 7414 INSTALL",0,75000,-75000,-1]
["3512","BLACKWATER SUB - OCB 5612 RECONDUCTOR",0,0,0,0]
["3513","CROOKED CREEK SUB - OCB NEW REC",34990.550000000003,0,34990.550000000003,1]
["3515","PACE SUB-7292 PHASE ADDITION PACE LN",0,0,0,0]
["3516","PACE SUB-7292 RECONDUCTOR ANDREA LN",0,0,0,0]
["3517","CRYSTAL BEACH SUB - CONSTRUCT NEW 795 FEEDER",0,0,0,0]
["3518","JAY ROAD 7252 RECONDUCTOR",0,0,0,0]
["3519","CROOKED CREEK - CONSTRUCT NEW 795 FEEDER",0,0,0,0]
["3601","FAIRFIELD 7762 FEEDER EXTENSION (GSI RECYCLING)",0,0,0,0]
["3609","REDWOOD SUB OCB 8702 RECONDUCTOR & WATSON BAYOU",0,0,0,0]
["3630","BEACH HAVEN SUB OCB 6052 FDR IMPROVMENT",0,0,0,0]
["3631","JAY ROAD OCB FDR IMPROVMENT",0,0,0,0]
["3632","LULLWATER SUBSTATION FEEDER UPGRADE",0,0,0,0]
["3633","WEST PERDIDO KEY CROSSING ENHANCEMENTS",90706,59000,31706,0.537389830508475]
["3636","EAST BAY 5832 PHASE ADDITION",14158.2,70000,-55841.8,-0.79774]
["3638","GLENDALE RD - OCB 7902 RECONDUCTOR",0,0,0,0]
["3639","PANAMA CITY AIRPORT SUBSTATION FEEDER",0,0,0,0]
["3640","SPANISH MILL SUBSTATION-ECUA FEEDERS",0,0,0,0]
["3642","CHIPLEY 9202 - PHASE ADDITION",86051.17,82000,4051.17,4.9404512195121902E-2]
["3643","CONSTRUCT NEW HENDERSON BCH DIST SUBSTATION",311165.33,500000,-188834.67,-0.37766934000000002]
["3645","BAY COUNTY SUB-NEW FEEDER",0,333000,-333000,-1]
["3646","WHITING SUB-NEW FEEDER",0,0,0,0]
["3647","UNLOCATED TX ADD - CANCEL",0,0,0,0]
["3648","VALPARAISO 9252-AIRPORT RECONDUCTOR",229230.96,0,229230.96,1]
["3649","STORM SUPPORT/OTHER UTILITIES",0,0,0,0]
["3650","STORM SUPPORT - OVERHEAD",752.97,0,752.97,1]
["3651","STORM SUPPORT - UNDERGROUND",0,0,0,0]
["3652","STORM HARDENING - OVERHEAD",291332.18,397000,-105667.82,-0.26616579345088198]
["3653","STORM HARDENING - JOINT USE",0,0,0,0]
["3655","BRENTWOOD SUB - OCB 6774 FEEDER IMP",0,0,0,0]
["3688","LONG BEACH SUB RECONDUCTOR OCB 8542",0,0,0,0]
["3690","PARKER SUB RECONSTUCT 3 1/0 TO LAIRD SUB",0,0,0,0]
["3691","EAST HILL SUB CONVERT 2 - 4KV FDR 12/4KV TO 12KV",215035.03,300000,-84964.97,-0.283216566666667]
["3692","EAST BAY SUB OCB 5832 CONSTRUCT 3 # 1/0 FROM HWY 87",0,0,0,0]
["3693","DEVILLIERS SUB OCB 7414 REPLACE 20 PROTECTORS",295337.59999999998,245000,50337.599999999999,0.20545959183673501]
["3695","LONG BEACH SUB - RECONDUCTOR OCB 8532",0,0,0,0]
["3696","EAST BAY SUB - CONSTRUCT 795 FEEDER ON HWY 98",0,0,0,0]
["3698","NAVARRE SUB - NEW 795 FEEDER",386040.46,725000,-338959.54,-0.46753040000000001]
["3699","HATHAWAY SUB - TWO NEW FEEDERS, RECONDUCTOR",0,0,0,0]
["3700","SYSTEM REACTIVE CORRECTIVE CAPACITY",320771.14,274000,46771.14,0.170697591240876]
["3702","CIRCUIT SWITCHER IMPR - TS (2004-2008)",62714.57,105000,-42285.43,-0.40271838095238099]
["3713","DUKE FIELD 115/12 KV NEW SUB AND FEEDER",0,0,0,0]
["3723","LONGSHOT 115/12KV POWER SUPPLY",0,0,0,0]
["3726","LULLWATER SUB NEW TERMINAL (NEW)",0,0,0,0]
["3727","HINSON'S CROSSROADS BANK ADDITION (NEW)",89971.23,50000,39971.230000000003,0.79942460000000004]
["3728","BLACKWATER SUBSTATION FEEDER #3 ADDITION",0,0,0,0]
["3731","LULLWATER SUB BANK ADDITION (NEW)",4934.57,0,4934.57,1]
["3735","W.PHILLIPS INLET 115/12 KV SUB",0,0,0,0]
["3740","CROOKED CRK NEW SUB PROPERTY",0,0,0,0]
["3742","EMS TRANS SYSTEM ADD AND IMPROVMENTS",407930.88,350000,57930.879999999997,0.16551679999999999]
["3745","JAY ROAD BANK UPGRADE",-2042.63,0,-2042.63,1]
["3747","PANAMA CITY AIRPORT SUB",0,0,0,0]
["3748","FIBER OPTIC EQUIP",412345.76,0,412345.76,1]
["3751","SANTA ROSA MIRAMAR 115KV LINE #2",0,0,0,0]
["3752","FAIRFIELD RING BUS",-31797.77,0,-31797.77,1]
["3753","HOLIDAY NEW SUB 2009",89950.74,0,89950.74,1]
["3754","ECUA 230/12 KV NEW SUB NEW FDR",3084.35,0,3084.35,1]
["3755","JAY ROAD BANK UPGRADE (SGIG)",289804.48,0,289804.48,1]
["3756","OPTICAL GROUND WIRE (SGIG)",-409139.81,0,-409139.81,1]
["4300","OFFICE FURNITURE & MECHANICAL EQUIP.",26088.07,121110,-95021.93,-0.78459194121047005]
["4301","TOOLS, IMPLEMENTS AND TEST EQUIP. 5 YR (DEPRECIATE)",84977.81,82000,2977.81,3.63147560975609E-2]
["4302","MISC. BUILDINGS, LAND, AND EQUIP.",94971.91,176328,-81356.09,-0.46139064697609]
["4303","SECURITY",0,20250,-20250,-1]
["4304","AUTOMOBILES, AUTO TRUCKS & EQUIP.",381601.99,800000,-418398.01,-0.52299751250000004]
["4305","WIRELESS SYSTEMS",34685.72,189900,-155214.28,-0.81734744602422305]
["4306","AV EQUIP/PRINT SERVICES",53452.01,24750,28702.01,1.1596771717171701]
["4308","POWER DELIVERY TECHNOLOGY IMPROVEMENTS",16117.79,25000,-8882.2099999999991,-0.3552884]
["4310","VOICE & DATA CONVERGED NETWORK",159724.03,615000,-455275.97,-0.74028613008130095]
["4311","TRANSPORT NETWORK ADD/IMPROVE",62501.25,100000,-37498.75,-0.37498749999999997]
["4317","ENERGY MANAGEMENT SYSTEM REPLACEMENT",0,0,0,0]
["4318","MOBILE RADIO SYSTEM",0,0,0,0]
["4321","REMOTE TERMINAL UNITS",0,0,0,0]
["4328","DESTIN ROOF",272925.31,375000,-102074.69,-0.27219917333333299]
["4344","T&D WAREHOUSE EQUIPMENT REPLACEMENT",2205.34,150000,-147794.66,-0.98529773333333304]
["4345","MILTON LINE SV & WHSE ROOF",0,0,0,0]
["4347","PINE FOREST ADMIN WHS & LS ROOF",0,0,0,0]
["4348","PURCHASE LAND - SALAMANCA STREET",0,0,0,0]
["4351","GENERAL WAREHOUSE REPLACE FIRE ALARM SYSTEM",0,0,0,0]
["4360","PINE FOREST NEW OFFICE FACILITY",0,0,0,0]
["4366","CORPORATE OFFICE 3RD FLOOR REENOVATIONS",111989.24,0,111989.24,1]
["4370","GULF POWER OPERATIONS CENTER",0,0,0,0]
["4371","GULF POWER VEHICLE MAINTENANCE CENTER",0,0,0,0]
["4374","TEMPORARY STORM CENTER AT PINE FOREST",0,0,0,0]
["4375","PANAMA CITY BEACH ROOF",0,0,0,0]
["4376","GLSCAPE AND MRO",1115721.0900000001,2009303,-893581.91,-0.44472232908625497]
["4377","GULF BREEZE ROOF",0,0,0,0]
["4378","PQWER CONTROL CENTER",3974.45,5000,-1025.55,-0.20510999999999999]
["4379","ECCR-PURCHASE THERMAL IMAGE TOOLS",0,0,0,0]
["4380","ECCR-PURCHASE DISPLAY CASE",0,0,0,0]
["4381","DISTRIBUTION OPERATIONS CENTER",0,0,0,0]
["4384","DATA NETWORKS ADDITIONS",0,0,0,0]
["4385","FIELD COMPUTERS",10232.120000000001,30000,-19767.88,-0.65892933333333303]
["4386","IT COSTS FOR PACE BLVD MOVE",0,0,0,0]
["4391","CUSTOMER INFORMATION SYSTEM",0,0,0,0]
["4395","INFORMATION RESOURCES - FMS",0,0,0,0]
["4396","PUR TV-CORP OFF-ACCT CONF ROOM",0,0,0,0]
["4400","TRANSMISSION TOOLS & TEST EQUIPMENT",120588.2,130000,-9411.7999999999993,-7.2398461538461606E-2]
["4404","CORPORATE OFFICE COOLING TOWER",0,0,0,0]
["4779","PLANT TRANSFER",0,0,0,0]
["4785","ACCRUED PAYROLL",766267.95,0,766267.95,1]
["4790","UNASS OVERHEADS",-29093.99,0,-29093.99,1]
["4999","NEW PRODUCTS AND SERVICES",67630.649999999994,74425,-6794.3500000000104,-9.1291232784682597E-2]
["Total","Total",{"$f":"SUM(C$2:C$552)","v":183053912.79999992},{"$f":"SUM(D$2:D$552)","v":204742461},-21688548.199999992,{"$f":"E553/D553","v":-0.10593087576494449}]
[" "]
[" "]
["Database: ",null,"Gulf Power ",null,null," Beginning Balances: ",null,"NO"]
["Information View: ",null,"Capital-Expenditures (100%) ",null,null," Period 13: ",null,"NO"]
["Loaded Query Name: ",null," ",null,null," Commitments: ",null,"Data Types: ",null,"Actual "," Capital Budget BY FINAL "]
["Months: ",null,"Jan 11-Jun 11 "," Jan 11-Jun 11 "]
[" "]
["PerForming RCN: "]
["Activity: "]
["Resource Type: "]
["Ferc Sub: ",null,"Incl 30000000 thru 39999999"]
["Project: ",null,"Incl 0090 thru 499999"]
["Location: "]
["Receiving ORG: "]
["Allocation Indicator: "]
["Work Order: "]
["Billing Work Order: "]
["Company: "]
[" "]
["Drill Drown: "]
[null," PRCN "," Activity "," R/T "," FercSub "," Loc "," Project "," EWO "," RRCN "," AI "," BWO "," COMPANY "]

{"sheet":"June 2011","index":3,"n_rows":349,"n_cols":20,"rows_kept":349,"cut":false,"hidden":false,"merged":[[1,2,1,8],[348,1,348,5]]}
[6]
[null,null,"Place an X in the box when your data is verified:"]
[null,null,null,"Vicki Mack",null,"Allison Bryant",null,null,"Sarah Seckinger"]
[null,null,null,"Hal Banks",null,"Carol Stevens"]
[null,null,null,"Paul Pratofiorito",null,"Debbie Deatherage"]
[null,null,null,"Allison Beaty",null,"Barbara Gambill"]
[]
[]
["Business",null,null,null,null,null,null,null,null,null,"YTD","Year-End",null,"Year-End","Year-End"]
["Unit",null,"PE","Walker Description","Coor.","YTD Actual","YTD Budget","YTD Variance $","YTD Variance %","*","Explanation","Projected","Original Budget","Variance","Variance %","**"]
[]
["POWER GENERATION"]
[null,"ENVIRONMENTAL"]
[null,null,"1031",{"$f":"VLOOKUP($C14, Walker_Description, 2, FALSE)","v":"ECRC AIR CRIST UNIT 7 SCR CATALYST REPLACEMENT"},"VICKI",{"$f":"SUMIF(PE, $C14, YTD_Actual)","v":213075.4},{"$f":"SUMIF(PE, $C14, YTD_Budget)","v":150000},{"$f":"SUMIF(PE, $C14, YTD_Variance_Dollars)","v":63075.4},{"$f":"SUMIF(PE, $C14, YTD_Variance_Percentage)","v":0.42050266666666702},{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H14<-250000,H14>250000,I14<-0.1,I14>0.1),(OR(H14>=10000,H14<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H14<=-250000,H14>=250000),(OR(H14>=10000,H14<=-10000))),\"*\",\"\"))","v":"*"},null,null,150000,{"$f":"L14-M14","v":-150000},{"$f":"IF(M14=0,IF(L14>0,100,IF(L14=0,0,-100)),(N14/M14)*100)","v":-100}]
[null,null,"1033","ENVIR-WASTE-CRIST FLY ASH LANDFILL STORAGE CELL CAPPING","VICKI",0,0,0,0,null,null,null,350000,{"$f":"L15-M15","v":-350000},{"$f":"IF(M15=0,IF(L15>0,100,IF(L15=0,0,-100)),(N15/M15)*100)","v":-100}]
[null,null,"1038","ECRC-AIR-CRIST 6 UPGR PRECIP","VICKI",840040.5,150000,690040.5,4.6002700000000001,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H16<-250000,H16>250000,I16<-0.1,I16>0.1),(OR(H16>=10000,H16<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H16<=-250000,H16>=250000),(OR(H16>=10000,H16<=-10000))),\"*\",\"\"))","v":"*"},null,null,13250000,-13250000,-100,{"$f":"IF(OR(N16>999999,N16<-999999),\"**\",\"\")","v":"**"}]
[null,null,"1060","ECRC-AIR-CRIST 7 FGAS MONITORS","VICKI",0,45000,-45000,-1,"*",null,null,45000,-45000,-100]
[null,null,"1158","ECRC-AIR-CRIST SCR U7 MISC","VICKI",12600,25002,-12402,-0.49604031677465799,"*",null,null,50000,-50000,-100]
[null,null,"1167","ECRC-AIR-CRIST SNCR MISCELLANEOUS","VICKI",6018.24,12498,-6479.76,-0.51846375420067203,"",null,null,25000,-25000,-100]
[null,null,"1178","ECRC-WATER-CRIST ECUA RECLAIM ACID ADD SYSTEM","VICKI",0,200000,-200000,-1,"*",null,null,500000,-500000,-100]
[null,null,"1222","ECRC-AIR-CRIST SCRUBBER","VICKI",7358450.71,7769141,-410690.29,-5.2861737224231098E-2,null,null,null,15153624,{"$f":"L21-M21","v":-15153624},{"$f":"IF(M21=0,IF(L21>0,100,IF(L21=0,0,-100)),(N21/M21)*100)","v":-100}]
[null,null,"1233","ECRC-AIR-CRIST SCRUBBER MISCELLANEOUS","VICKI",125753.63,75000,50753.63,0.67671506666666703,"*",null,null,150000,{"$f":"L22-M22","v":-150000},{"$f":"IF(M22=0,IF(L22>0,100,IF(L22=0,0,-100)),(N22/M22)*100)","v":-100}]
[null,null,"1247","ECRC-AIR-CRIST 4&5 BYPASS STACK CEMS EQUIPMENT","VICKI",-391049.08,0,-391049.08,1,"*",null,null,0,{"$f":"L23-M23","v":0},{"$f":"IF(M23=0,IF(L23>0,100,IF(L23=0,0,-100)),(N23/M23)*100)","v":0}]
[null,null,"1256","ECRC -  AIR - CRIST 6&7 BY PASS STACK CEMS EQUIPMENT","VICKI",453664.73,0,453664.73,1,"*",null,null,0,{"$f":"L24-M24","v":0},{"$f":"IF(M24=0,IF(L24>0,100,IF(L24=0,0,-100)),(N24/M24)*100)","v":0}]
[null,null,"1276","ENVIR-WASTE-CRIST ASH POND DISCHARGE WEIR REPLACEMENT","VICKI",243096.63,0,243096.63,1,"*",null,null,0,0,0,{"$f":"IF(OR(N25>999999,N25<-999999),\"**\",\"\")","v":""}]
[null,null,"1279","ECRC-AIR-CRIST 6 SCR","VICKI",49686940.439999998,45106612,4580328.4400000004,0.101544501724049,"*",null,null,81940189,-81940189,-100,{"$f":"IF(OR(N26>999999,N26<-999999),\"**\",\"\")","v":"**"}]
[null,null,"1298","ECRC - CRIST WATER CONSERVATION PROGRAM","VICKI",345746.29,440000,-94253.71,-0.21421297727272701,"*",null,null,700000,-700000,-100]
[null,null,"1299","ECRC-WATER-CRIST 4-7 ASH POND CHEMISTRY CONTROL","VICKI",604.4,0,604.4,1,"",null,null,0,0,0,{"$f":"IF(OR(N28>999999,N28<-999999),\"**\",\"\")","v":""}]
[null,null,"1501","ECRC-DANIEL ASH POND WELL","VICKI",0,36107,-36107,-1,"*",null,null,72195,-72195,-100]
[null,null,"1502","ECRC DANIEL SCRUBBER COMMON","VICKI",0,1375301,-1375301,-1,"*",null,null,7036456,-7036456,-100]
[null,null,"1551","ECRC-AIR-DANIEL 1 & 2 SCRUBBER","VICKI",12459476.15,10485251,1974225.15,0.188285921815319,"*",null,null,20042892,{"$f":"L31-M31","v":-20042892},{"$f":"IF(M31=0,IF(L31>0,100,IF(L31=0,0,-100)),(N31/M31)*100)","v":-100}]
[null,null,"1552","ECRC-AIR-DANIEL 2 SCRUBBER","VICKI",0,10473721,-10473721,-1,"*",null,null,20100432,{"$f":"L32-M32","v":-20100432},{"$f":"IF(M32=0,IF(L32>0,100,IF(L32=0,0,-100)),(N32/M32)*100)","v":-100}]
[null,null,"1555","ECRC - WASTE - DANIEL ASH STORAGE","VICKI",11569.68,0,11569.68,1,"*",null,null,0,0,0]
[null,null,"1592","ECRC-AIR-DANIEL 1 & 2 CEMS BACKUP AIR COMPRESSOR","VICKI",3092.53,0,3092.53,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H34<-250000,H34>250000,I34<-0.1,I34>0.1),(OR(H34>=10000,H34<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H34<=-250000,H34>=250000),(OR(H34>=10000,H34<=-10000))),\"*\",\"\"))","v":""},null,null,0,{"$f":"L34-M34","v":0},{"$f":"IF(M34=0,IF(L34>0,100,IF(L34=0,0,-100)),(N34/M34)*100)","v":0}]
[null,null,"1601","ECRC-WATER-SMITH RECLAIMED WATER PROJECT UNIT 3","VICKI",0,2514286,-2514286,-1,"*",null,null,6000000,{"$f":"L35-M35","v":-6000000},-100]
[null,null,"1613","ENVIRONMENTAL-WASTE-SMITH CAP ASH LANDFILL CELLS","VICKI",209609.86,0,209609.86,1,"*",null,null,200000,{"$f":"L36-M36","v":-200000},-100]
[null,null,"1640","ENVIRONMENTAL-AIR-SMITH 3 CEMS REPLACEMENT","VICKI",13736.68,0,13736.68,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H37<-250000,H37>250000,I37<-0.1,I37>0.1),(OR(H37>=10000,H37<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H37<=-250000,H37>=250000),(OR(H37>=10000,H37<=-10000))),\"*\",\"\"))","v":"*"},null,null,200000,{"$f":"L37-M37","v":-200000},{"$f":"IF(M37=0,IF(L37>0,100,IF(L37=0,0,-100)),(N37/M37)*100)","v":-100}]
[null,null,"1727","ENVIR-AIR-SCHERER SELECTIVE CATALYTIC REDUCT (SCR)","VICKI",1333406.73,2618619,-1285212.27,-0.490797733461798,"*",null,null,3051935,-3051935,-100,{"$f":"IF(OR(N38>999999,N38<-999999),\"**\",\"\")","v":"**"}]
[null,null,"1728","ENVIR-AIR-SCHERER SCRUBBER","VICKI",4113305.28,3794918,318387.28000000003,8.38983292919636E-2,"*",null,null,5729800,-5729800,-100]
[null,null,"1729","ENVIR-AIR-SCHERER BAGHOUSE","VICKI",134778.82999999999,466349,-331570.17,-0.71099148920658095,"*",null,null,475062,-475062,-100]
[null,null,"1765","ENVIRONMENTAL SCHERER 3 INSTALL O2/CO ANALYZERS","VICKI",0,81500,-81500,-1,"*",null,null,81500,-81500,{"$f":"IF(M40=0,IF(L41>0,100,IF(L41=0,0,-100)),(N41/M40)*100)","v":-17.155655472338346},{"$f":"IF(OR(N41>999999,N41<-999999),\"**\",\"\")","v":""}]
[null,null,"1778","ENVIR - SCHERER - ENVIRONMENTAL SITE PLAN","VICKI",432875.69,468920,-36044.31,-7.6866651027893904E-2,"",null,null,747496,-747496,{"$f":"IF(M42=0,IF(L42>0,100,IF(L42=0,0,-100)),(N42/M42)*100)","v":-100},{"$f":"IF(OR(N42>999999,N42<-999999),\"**\",\"\")","v":""}]
[null,null,"1824","ECRC-AIR-DANIEL 1 LO NOX BURNERS","VICKI",516.64,0,516.64,1,"",null,null,0,0,{"$f":"IF(M41=0,IF(L43>0,100,IF(L43=0,0,-100)),(N43/M41)*100)","v":0},{"$f":"IF(OR(N43>999999,N43<-999999),\"**\",\"\")","v":""}]
[null,null,"1847","ECRC DANIEL SCRUBBER LAND","VICKI",3315.26,0,3315.26,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H44<-250000,H44>250000,I44<-0.1,I44>0.1),(OR(H44>=10000,H44<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H44<=-250000,H44>=250000),(OR(H44>=10000,H44<=-10000))),\"*\",\"\"))","v":""},null,null,0,{"$f":"L44-M44","v":0},{"$f":"IF(M42=0,IF(L44>0,100,IF(L44=0,0,-100)),(N44/M42)*100)","v":0},{"$f":"IF(OR(N44>999999,N44<-999999),\"**\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,""]
[null,"TOTAL ENVIRONMENTAL","Remove",{"$f":"$B46","v":"TOTAL ENVIRONMENTAL"},null,{"$f":"SUM(F14:F45)","v":77610625.220000029},{"$f":"SUM(G14:G45)","v":86288225},{"$f":"SUM(H14:H45)","v":-8677599.7799999993},{"$f":"IF(G46=0,1,+H46/G46)","v":-0.10056528315421948},null,null,{"$f":"SUM(L14:L45)","v":0},176126581,{"$f":"+L46-M46","v":-176126581},{"$f":"(N46/M46)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
[null,"FOSSIL",null,null,null,null,null,null,null,""]
[null,null,"1007",{"$f":"VLOOKUP($C49, Walker_Description, 2, FALSE)","v":"CRIST 7 HRA SIDEWALLS HEADER TO HEADER"},"VICKI",{"$f":"SUMIF(PE, $C49, YTD_Actual)","v":0},{"$f":"SUMIF(PE, $C49, YTD_Budget)","v":0},{"$f":"SUMIF(PE, $C49, YTD_Variance_Dollars)","v":0},{"$f":"SUMIF(PE, $C49, YTD_Variance_Percentage)","v":0},{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H49<-250000,H49>250000,I49<-0.1,I49>0.1),(OR(H49>=10000,H49<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H49<=-250000,H49>=250000),(OR(H49>=10000,H49<=-10000))),\"*\",\"\"))","v":""},null,null,1000000,{"$f":"L49-M49","v":-1000000},{"$f":"IF(M49=0,IF(L49>0,100,IF(L49=0,0,-100)),(N49/M49)*100)","v":-100}]
[null,null,"1009","CRIST 7 REHEATER","VICKI",20959.32,0,20959.32,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H50<-250000,H50>250000,I50<-0.1,I50>0.1),(OR(H50>=10000,H50<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H50<=-250000,H50>=250000),(OR(H50>=10000,H50<=-10000))),\"*\",\"\"))","v":"*"},null,null,2000000,-2000000,-100,{"$f":"IF(OR(N50>999999,N50<-999999),\"**\",\"\")","v":"**"}]
[null,null,"1010","CRIST U6 PRIMARY SUPERHEATER REPLACEMENT","VICKI",2245202.77,1249992,995210.77,0.79617371151175398,"*",null,null,2500000,-2500000,-100]
[null,null,"1013","CRIST 6 HRA SIDEWALLS HEADER TO HEADER","VICKI",3088216.67,3450000,-361783.33,-0.104864733333333,"*",null,null,3450000,-3450000,-100]
[null,null,"1015","CRIST 6 STATIC EXCITER AND VOLTAGE REGULATOR","VICKI",1290455.81,1099998,190457.81,0.173143778443234,"*",null,null,2200000,-2200000,-100]
[null,null,"1017","CRIST 7 STATIC EXCITER AND VOLTAGE REGULATOR","VICKI",410541.99,0,410541.99,1,"*",null,null,1700000,-1700000,-100]
[null,null,"1034","CRIST U6 BREAKERS CABLE & SWITCHES PER ARC FLASH STUDY","VICKI",0,100000,-100000,-1,"*",null,null,100000,-100000,-100,{"$f":"IF(OR(N55>999999,N55<-999999),\"**\",\"\")","v":""}]
[null,null,"1039","CRIST 5 BOTTOM ASH DOGHOUSE AND SLUICE GATE","VICKI",0,0,0,0,"",null,null,138300,-138300,-100]
[null,null,"1052","CRIST 6 - 6A 4160 VOLT BREAKERS","VICKI",816737.73,199998,616739.73,3.0837294872948702,"*",null,null,400000,-400000,-100]
[null,null,"1053","CRIST 6 - 6B 4160 VOLT BREAKERS","VICKI",310185.94,187500,122685.94,0.65432501333333304,"*",null,null,375000,-375000,-100]
[null,null,"1063",{"$error":"#N/A"},"VICKI",0,0,0,0,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H59<-250000,H59>250000,I59<-0.1,I59>0.1),(OR(H59>=10000,H59<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H59<=-250000,H59>=250000),(OR(H59>=10000,H59<=-10000))),\"*\",\"\"))","v":""},null,null,null,{"$f":"L59-M59","v":0},{"$f":"IF(M59=0,IF(L59>0,100,IF(L59=0,0,-100)),(N59/M59)*100)","v":0}]
[null,null,"1066","CRIST 6 REHEAT SPRAY SYSTEM","VICKI",255408.03,250000,5408.03,2.1632120000000001E-2,"",null,null,250000,-250000,-100]
[null,null,"1072","CRIST 4-7 NITROGEN CAPPING SYSTEM","VICKI",0,210200,-210200,-1,"*",null,null,210200,-210200,-100]
[null,null,"1077","CRIST UNIT 6 TURBINE OIL COOLER","VICKI",154529.91,144942,9587.91,6.61499772322722E-2,"",null,null,290000,-290000,-100]
[null,null,"1088","CRIST UNIT 6 FINISHING SUPERHEAT HEADER","VICKI",0,460000,-460000,-1,"*",null,null,1150000,-1150000,-100]
[null,null,"1092","CRIST 7 REPLACE FINISHING SUPER HEAT OUTLET HEADER","VICKI",0,600000,-600000,-1,"*",null,null,1500000,-1500000,-100]
[null,null,"1094","CRIST FUEL HANDLING CRANE","VICKI",4529334.1500000004,7327603,-2798268.85,-0.38188052081969998,"*",null,null,7327603,-7327603,-100]
[null,null,"1100","CRIST-MINOR MISC ITEMS","VICKI",383641.76,249900,133741.76000000001,0.53518111244497801,"*",null,null,500000,-500000,-100,null,"Year End projection increased due to change in accounting policy for issuing stores items (spares) with RUC's  "]
[null,null,"1110","CRIST-7 REHEAT OUTLET HEADER REPLACEMENT","VICKI",2974.34,0,2974.34,1,"",null,null,1000000,-1000000,-100]
[null,null,"1111","CRIST-6 LOWER ECNONMIZER AND HEADER REPLACEMENT","VICKI",1590463.62,2450000,-859536.38,-0.35083117551020399,"*",null,null,2450000,-2450000,-100]
[null,null,"1114","CRIST 5-PULVERIZED COAL PIPING","VICKI",45180.78,749700,-704519.22,-0.93973485394157696,"*",null,null,1500000,-1500000,-100]
[null,null,"1116","CRIST-5 GENERATOR STATOR REWIND","VICKI",0,0,0,0,"",null,null,3500000,-3500000,-100]
[null,null,"1120",{"$error":"#N/A"},"VICKI",0,0,0,0,"",null,null,null,0,0]
[null,null,"1121","CRIST 6 REHEAT HEADER","VICKI",226240.95,1100000,-873759.05,-0.79432640909090901,"*",null,null,1100000,{"$f":"L72-M72","v":-1100000},{"$f":"IF(M72=0,IF(L72>0,100,IF(L72=0,0,-100)),(N72/M72)*100)","v":-100}]
[null,null,"1122","CRIST BARGE HAUL SYSTEM","VICKI",172608.32,0,172608.32,1,"*",null,null,0,{"$f":"L73-M73","v":0},{"$f":"IF(M73=0,IF(L73>0,100,IF(L73=0,0,-100)),(N73/M73)*100)","v":0}]
[null,null,"1126","CRIST 4 & 5 REPLACE INTAKE SCREENS","VICKI",201395.14,0,201395.14,1,"*",null,null,500000,-500000,-100]
[null,null,"1133","CRIST 6 FD FAN OUTLET POSITIONER REPLACEMENTS","VICKI",18399.79,137500,-119100.21,-0.86618334545454501,"*",null,null,137500,{"$f":"L75-M75","v":-137500},{"$f":"IF(M75=0,IF(L75>0,100,IF(L75=0,0,-100)),(N75/M75)*100)","v":-100}]
[null,null,"1134","CRIST 6 CONTROL UPGRADE","VICKI",80986.28,385000,-304013.71999999997,-0.789646025974026,"*",null,null,385000,-385000,-100]
[null,null,"1135","CRIST 5 L-O TURBINE BLADE","VICKI",0,0,0,0,"",null,null,566000,-566000,-100]
[null,null,"1136","CRIST 5-16,17 AND 18 STAGE TURBINE BLADE","VICKI",0,0,0,0,"",null,null,300000,-300000,-100]
[null,null,"1137","CRIST 6 GRAPHICS UPGRADE","VICKI",0,330000,-330000,-1,"*",null,null,330000,-330000,-100]
[null,null,"1141","CRIST 7 MAIN TURBINE OIL COOLERS","VICKI",206039.88,0,206039.88,1,"*",null,null,null,0,0]
[null,null,"1144","CRIST 7 OVATION 400 CONTROLLERS REPLACEMENT","VICKI",0,0,0,0,"",null,null,100000,-100000,-100]
[null,null,"1146","CRIST 7 BATTER BANK","VICKI",196410.63,250000,-53589.37,-0.21435747999999999,"*",null,null,250000,-250000,-100]
[null,null,"1147","CRIST 4&5 BATTER BANK","VICKI",53149.43,0,53149.43,1,"*",null,null,250000,-250000,-100]
[null,null,"1148","CRIST - MISC ITEMS","VICKI",1338799.73,250008,1088791.73,4.3550275591181098,"*",null,null,500000,-500000,-100,null,"Year End projection increased due to change in accounting policy for issuing stores items (spares) with RUC's  "]
[null,null,"1150",{"$f":"VLOOKUP($C85, Walker_Description, 2, FALSE)","v":"CRIST 6 - BATTERY BANK"},"VICKI",{"$f":"SUMIF(PE, $C85, YTD_Actual)","v":318044.76},{"$f":"SUMIF(PE, $C85, YTD_Budget)","v":250000},{"$f":"SUMIF(PE, $C85, YTD_Variance_Dollars)","v":68044.759999999995},{"$f":"SUMIF(PE, $C85, YTD_Variance_Percentage)","v":0.27217903999999998},"*",null,null,250000,-250000,-100]
[null,null,"1152","CRIST CONDENSATE MAKEUP PIPING","VICKI",0,0,0,0,"",null,null,300000,-300000,-100]
[null,null,"1159","CRIST U7 REPL BREAKERS CABLE & SWITCHES PER ARC FLASH STUDY","VICKI",329096.34000000003,87468,241628.34,2.7624770201673798,"*",null,null,175000,-175000,-100]
[null,null,"1160",{"$error":"#N/A"},"VICKI",0,0,0,0,"",null,null,null,0,0]
[null,null,"1172","CRIST U5 REPL BREAKERS CABLE & SWITHCES FOR ARC FLASH STUDY","VICKI",0,0,0,0,"",null,null,250000,-250000,-100]
[null,null,"1177","CRIST U6 SW COOLER REPLACEMENT","VICKI",0,500000,-500000,-1,"*",null,null,500000,-500000,-100]
[null,null,"1179",{"$error":"#N/A"},"VICKI",0,0,0,0,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H91<-250000,H91>250000,I91<-0.1,I91>0.1),(OR(H91>=10000,H91<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H91<=-250000,H91>=250000),(OR(H91>=10000,H91<=-10000))),\"*\",\"\"))","v":""},null,null,0,{"$f":"L91-M91","v":0},{"$f":"IF(M91=0,IF(L91>0,100,IF(L91=0,0,-100)),(N91/M91)*100)","v":0}]
[null,null,"1196","CRIST 6 REHEAT AND SUPERHEAT DAMPERS","VICKI",697559.8,415800,281759.8,0.67763299663299703,"*",null,null,840000,-840000,-100]
[null,null,"1200","CRIST 6&7 IGNITER AIR SYSTEM","VICKI",0,0,0,0,"",null,null,250000,-250000,-100]
[null,null,"1209","CRIST ASH SYSTEM AIR COMPRESSORS","VICKI",80963.360000000001,135000,-54036.639999999999,-0.40027140740740702,"*",null,null,135000,-135000,-100]
[null,null,"1210","CRIST CYBER SECURITY","VICKI",3501.31,199920,-196418.69,-0.98248644457783096,"*",null,null,400000,-400000,-100]
[null,null,"1221","CRIST REPLACE HYDROMIXERS","VICKI",420097.96,1000000,-579902.04,-0.57990204000000001,"*",null,null,1000000,-1000000,-100]
[null,null,"1223",{"$error":"#N/A"},"VICKI",0,0,0,0,"",null,null,null,0,0]
[null,null,"1230","CRIST 6 REPL REHEATER","VICKI",4748157.16,1732500,3015657.16,1.7406390533910501,"*",null,null,3500000,-3500000,-100,{"$f":"IF(OR(N98>999999,N98<-999999),\"**\",\"\")","v":"**"}]
[null,null,"1231","CRIST 6&7 BOILER AWARE PROGRAM","VICKI",0,80000,-80000,-1,"*",null,null,80000,-80000,-100]
[null,null,"1254","CRIST COMMON CONVEYOR BELTS REPLACEMENT","VICKI",137760.76,0,137760.76,1,"*",null,null,150000,-150000,-100,{"$f":"IF(OR(N100>999999,N100<-999999),\"**\",\"\")","v":""}]
[null,null,"1257","CRIST 4-7 DEMINERALIZER NEUTRALIZATION BASIN PUMPS","VICKI",0,0,0,0,"",null,null,210000,{"$f":"L101-M101","v":-210000},{"$f":"IF(M101=0,IF(L101>0,100,IF(L101=0,0,-100)),(N101/M101)*100)","v":-100}]
[null,null,"1258","CRIST 4-7 DEMINERALIZER CONTROLS REPLACEMENT","VICKI",102350.52,0,102350.52,1,"*",null,null,0,0,0]
[null,null,"1262","CRIST UNIT 6 HOT REHEAT PIPING","VICKI",19526.84,1000002,-980475.16,-0.98047319905360197,"*",null,null,2000000,-2000000,-100]
[null,null,"1267","CRIST 4-7 NEW SIDE COAL YARD 575 VOLT BREAKERS","VICKI",122223.85,0,122223.85,1,"*",null,null,0,{"$f":"L104-M104","v":0},{"$f":"IF(M104=0,IF(L104>0,100,IF(L104=0,0,-100)),(N104/M104)*100)","v":0}]
[null,null,"1300","SCHOLZ - MISC. STEAM PLANT ADDITIONS","VICKI",48051.72,60000,-11948.28,-0.19913800000000001,"*",null,null,120000]
[null,null,"1400","SMITH 1&2 - MISC. STEAM PLANT ADDITIONS","VICKI",123177.77,212418,-89240.23,-0.42011613893361199,"*",null,null,425000,-425000,-100,{"$f":"IF(OR(N106>999999,N106<-999999),\"**\",\"\")","v":""}]
[null,null,"1403","SMITH 3 - 3A & 3B GAS TURBINES AIR FILTRATION SYSTEM","VICKI",52576.47,0,52576.47,1,"*",null,null,0,0,0]
[null,null,"1421","SMITH - UNIT A COMBUSTION TURBINE CONTROLS REPLACEMENT","VICKI",1881592.34,0,1881592.34,1,"*",null,null,0,0,0,{"$f":"IF(OR(N108>999999,N108<-999999),\"**\",\"\")","v":""}]
[null,null,"1424","SMITH 3 - TURBINE CONTROLS REPLACEMENT","VICKI",0,1500000,-1500000,-1,"*",null,null,1500000,{"$f":"L109-M109","v":-1500000},{"$f":"IF(M109=0,IF(L109>0,100,IF(L109=0,0,-100)),(N109/M109)*100)","v":-100}]
[null,null,"1427","SMITH 1 - VACUUM PUMPS","VICKI",0,250000,-250000,-1,"*",null,null,250000,-250000,-100]
[null,null,"1434","SMITH 1 - FLY ASH AND SOOTBLOWER CONTROLS","VICKI",0,200000,-200000,-1,"*",null,null,200000,-200000,-100]
[null,null,"1465","SMITH 2 - REPLACE DUCTWORK/EXPANSION JOINTS","VICKI",351.26,0,351.26,1,"",null,null,0,0,0]
[null,null,"1471","SMITH 1 - REPLACE RETRACTS ON BOILERS","VICKI",0,350000,-350000,-1,"*",null,null,350000,-350000,-100]
[null,null,"1496","SMITH 2 - EXPANSION JOINT REPLACEMENT","VICKI",192836.92,0,192836.92,1,"*",null,null,300000,-300000,-100]
[null,null,"1500","DANIEL-MISC. STEAM PLANT ADDITIONS & IMP.","VICKI",77613.02,111907,-34293.980000000003,-0.306450713538921,"*",null,null,212632,-212632,-100]
[null,null,"1515","DANIEL 2 ACE TWIP C05348   MS PE 2185","VICKI",458711.75,100286,358425.75,3.5740357577328798,"*",null,null,200541,-200541,-100]
[null,null,"1532","DANIEL 2 HP/IP TURBINE UPGRADE","VICKI",5369263.9199999999,2613072,2756191.92,1.0547707525854599,"*",null,null,5228233,-5228233,-100,{"$f":"IF(OR(N117>999999,N117<-999999),\"**\",\"\")","v":"**"}]
[null,null,"1557","DANIEL 1&2 CONVEYOR BELT  1D  C01719","VICKI",0,18792,-18792,-1,"*",null,null,37601,-37601,-100]
[null,null,"1564","DANIEL 2 CAPITAL VALVE REPLACEMENTS C03256","VICKI",34489.01,24801,9688.01,0.390629813313979,"",null,null,51638,-51638,-100]
[null,null,"1567",{"$f":"VLOOKUP($C120, Walker_Description, 2, FALSE)","v":"DANIEL 1&2 CONTROL ROOM A/C SYSTEMS"},"VICKI",{"$f":"SUMIF(PE, $C120, YTD_Actual)","v":0},{"$f":"SUMIF(PE, $C120, YTD_Budget)","v":100349},{"$f":"SUMIF(PE, $C120, YTD_Variance_Dollars)","v":-100349},{"$f":"SUMIF(PE, $C120, YTD_Variance_Percentage)","v":-1},"*",null,null,100349,-100349,-100,{"$f":"IF(OR(N120>999999,N120<-999999),\"**\",\"\")","v":""}]
[null,null,"1568","DANIEL 1 HOT AIR HEATER BASKET","VICKI",298.51,0,298.51,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H121<-250000,H121>250000,I121<-0.1,I121>0.1),(OR(H121>=10000,H121<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H121<=-250000,H121>=250000),(OR(H121>=10000,H121<=-10000))),\"*\",\"\"))","v":""},null,null,0,{"$f":"L121-M121","v":0},{"$f":"IF(M121=0,IF(L121>0,100,IF(L121=0,0,-100)),(N121/M121)*100)","v":0},{"$f":"IF(OR(N121>999999,N121<-999999),\"**\",\"\")","v":""}]
[null,null,"1569","DANIEL 2 HOT AIR HEATER BASKET","VICKI",403142.62,376315,26827.62,7.1290328581108897E-2,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H122<-250000,H122>250000,I122<-0.1,I122>0.1),(OR(H122>=10000,H122<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H122<=-250000,H122>=250000),(OR(H122>=10000,H122<=-10000))),\"*\",\"\"))","v":""},null,null,376315,-376315,-100]
[null,null,"1572","DANIEL 1&2 FIRE PROTECTION CONTROLS","VICKI",0,37500,-37500,-1,"*",null,null,37500,-37500,-100]
[null,null,"1581","DANIEL !&2 CONVEYOR DIRECT DRIVE GEARBOXES C07627","VICKI",0,110429,-110429,-1,"*",null,null,110429,-110429,-100]
[null,null,"1584","DANIEL 1&2 AIR COMPRESSORS C07607 1D & 2B","VICKI",0,140491,-140491,-1,"*",null,null,140491,-140491,-100]
[null,null,"1585","DANIEL 2 INLET VANES ON PA FANS","VICKI",0,185702,-185702,-1,"*",null,null,185702,-185702,-100]
[null,null,"1593","DANIEL 2D BWCP REPLACEMENT","VICKI",193399.58,0,193399.58,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H127<-250000,H127>250000,I127<-0.1,I127>0.1),(OR(H127>=10000,H127<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H127<=-250000,H127>=250000),(OR(H127>=10000,H127<=-10000))),\"*\",\"\"))","v":"*"},null,null,185702,{"$f":"L127-M127","v":-185702},{"$f":"IF(M127=0,IF(L127>0,100,IF(L127=0,0,-100)),(N127/M127)*100)","v":-100}]
[null,null,"1600","SMITH 3 - MISC. STEAM PLANT ADDITIONS","VICKI",1251403.92,599760,651643.92000000004,1.0865078031212501,"*",null,null,1200000,-1200000,-100,{"$f":"IF(OR(N128>999999,N128<-999999),\"**\",\"\")","v":"**"}]
[null,null,"1604","SMITH - BUILD NEW WAREHOUSE FOR INVENTORY","VICKI",9500,0,9500,1,"",null,null,2250000,{"$f":"L129-M129","v":-2250000},{"$f":"IF(M129=0,IF(L129>0,100,IF(L129=0,0,-100)),(N129/M129)*100)","v":-100}]
[null,null,"1607","SMITH - FISH EXCLUSION DEVICE","VICKI",281275.78999999998,0,281275.78999999998,1,"*",null,null,0,0,0]
[null,null,"1610","SMITH - CYBER SECURITY","VICKI",145486.73000000001,83620,61866.73,0.73985565654149699,"*",null,null,167407,-167407,-100,{"$f":"IF(OR(N131>999999,N131<-999999),\"**\",\"\")","v":""}]
[null,null,"1611","SMITH 3 - WATER LAB BUILDING REPLACEMENT","VICKI",90391.93,0,90391.93,1,"*",null,null,0,0,0]
[null,null,"1619","SMITH 3 - AIR HANDLING UNIT","VICKI",0,85000,-85000,-1,"*",null,null,85000,-85000,-100,{"$f":"IF(OR(N133>999999,N133<-999999),\"**\",\"\")","v":""}]
[null,null,"1656","SMITH 1&2 REPLACE NO.1 AND TRIPPER BELTS","VICKI",3764.68,0,3764.68,1,"",null,null,0,0,0]
[null,null,"1679","SMITH 3 - CORROSION PROJECT","VICKI",124341.82,400000,-275658.18,-0.68914545000000005,"*",null,null,1000000,-1000000,-100]
[null,null,"1700","SCHERER-MISC. ADDITIONS & IMPROVEMENTS","VICKI",1619915.28,0,1619915.28,1,"*",null,null,0,0,0]
[null,null,"1705","SCHERER 3 SUPERHEATER OUTLET","VICKI",25394.94,0,25394.94,1,"*",null,null,0,0,0]
[null,null,"1707","SCHERER 3&4 RELOCATION OF FIRE HOUSE TRESTLE","VICKI",-367.5,0,-367.5,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H138<-250000,H138>250000,I138<-0.1,I138>0.1),(OR(H138>=10000,H138<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H138<=-250000,H138>=250000),(OR(H138>=10000,H138<=-10000))),\"*\",\"\"))","v":""},null,null,0,{"$f":"L138-M138","v":0},{"$f":"IF(M138=0,IF(L138>0,100,IF(L138=0,0,-100)),(N138/M138)*100)","v":0}]
[null,null,"1709","SCHERER 3 HP TURBINE ROTOR","VICKI",-123148.66,375750,-498898.66,-1.32774094477711,"*",null,null,375750,-375750,-100]
[null,null,"1716","SCHERER PORTABLE EQUIPMENT","VICKI",0,14330,-14330,-1,"*",null,null,18959,-18959,-100]
[null,null,"1717","SCHERER LAND PURCHASE","VICKI",6883.84,15625,-8741.16,-0.55943423999999997,"",null,null,31250,-31250,-100]
[null,null,"1721","SCHERER -TRACKED DOZER","VICKI",0,90686,-90686,-1,"*",null,null,90686,-90686,-100,{"$f":"IF(OR(N142>999999,N142<-999999),\"**\",\"\")","v":""}]
[null,null,"1732","SCHERER 3 REPLACE CHILLER","VICKI",101343.7,0,101343.7,1,"*",null,null,0,0,0]
[null,null,"1733","SCHERER 3 BOILER SONIC CLEANING EQUIP","VICKI",60740.6,0,60740.6,1,"*",null,null,0,{"$f":"L144-M144","v":0},{"$f":"IF(M144=0,IF(L144>0,100,IF(L144=0,0,-100)),(N144/M144)*100)","v":0}]
[null,null,"1736","SCHERER REPLACE MOVE AND REPLACE TRESTLE FEEDERS","VICKI",0,625,-625,-1,"",null,null,7351,-7351,-100]
[null,null,"1739","SCHERER 3 REPLACE GENERATOR 500KV BREAKER","VICKI",289563.36,0,289563.36,1,"*",null,null,0,{"$f":"L146-M146","v":0},{"$f":"IF(M146=0,IF(L146>0,100,IF(L146=0,0,-100)),(N146/M146)*100)","v":0}]
[null,null,"1742","SCHERER 3 REPL STATION SERV TRANSFORMER","VICKI",0,250000,-250000,-1,"*",null,null,250000,-250000,-100]
[null,null,"1743","SCHERER COMMON SERVICE WATER PIPING","VICKI",129.93,0,129.93,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H148<-250000,H148>250000,I148<-0.1,I148>0.1),(OR(H148>=10000,H148<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H148<=-250000,H148>=250000),(OR(H148>=10000,H148<=-10000))),\"*\",\"\"))","v":""},null,null,0,{"$f":"L148-M148","v":0},{"$f":"IF(M148=0,IF(L148>0,100,IF(L148=0,0,-100)),(N148/M148)*100)","v":0}]
[null,null,"1747","SCHERER 3 BOILER WATER CIRC PUMP","VICKI",21.17,0,21.17,1,"",null,null,0,0,0]
[null,null,"1750","SCHERER - MISC ADDITIONS AND IMPROVMENTS","VICKI",87753.73,212578,-124824.27,-0.58719279511520495,"*",null,null,351633,-351633,-100]
[null,null,"1755","SCHERER TRESTLE DUST SUPPRESSION COMMON","VICKI",-6581.63,0,-6581.63,1,"",null,null,0,0,0]
[null,null,"1757","SCHERER 3 REPLACE AIR HEATER BASKETS","VICKI",54332.41,0,54332.41,1,"*",null,null,0,0,0]
[null,null,"1761","SCHERER 3 CONDENSATE POLISHER","VICKI",0,1250,-1250,-1,"",null,null,50000,-50000,-100,{"$f":"IF(OR(N153>999999,N153<-999999),\"**\",\"\")","v":""}]
[null,null,"1766","SCHERER 3 & 4 REPLACE 3D - DUSTLESS TRANSFER","VICKI",10197.08,0,10197.08,1,"*",null,null,0,{"$f":"L154-M154","v":0},{"$f":"IF(M154=0,IF(L154>0,100,IF(L154=0,0,-100)),(N154/M154)*100)","v":0}]
[null,null,"1767","SCHERER 3 & 4 INSTALL ELEVATOR AT C CRUSHER HOUSE","VICKI",7457.01,75000,-67542.990000000005,-0.90057319999999996,"*",null,null,75000,-75000,-100]
[null,null,"1769",{"$f":"VLOOKUP($C156, Walker_Description, 2, FALSE)","v":"SCHERER 3 & 4 INSTALL SERVICE WATER LINE FOR DUST SUPPRESSIO"},"VICKI",{"$f":"SUMIF(PE, $C156, YTD_Actual)","v":0},{"$f":"SUMIF(PE, $C156, YTD_Budget)","v":57813},{"$f":"SUMIF(PE, $C156, YTD_Variance_Dollars)","v":-57813},{"$f":"SUMIF(PE, $C156, YTD_Variance_Percentage)","v":-1},"*",null,null,57813,-57813,-100]
[null,null,"1772","SCHERER - REPLACE SERVICE BLDG AH UNIT AND CONTROLS","VICKI",0,1014,-1014,-1,"",null,null,2315,-2315,-100]
[null,null,"1773","SCHERER COMMON REPLACE COAL PILE RUN-OFF POND PIPING","VICKI",9547.59,0,9547.59,1,"",null,null,0,0,0]
[null,null,"1774","SCHERER 3 REPLACE FRONT PENDANT REHEATER","VICKI",1537.55,750,787.55,1.05006666666667,"",null,null,375000,{"$f":"L159-M159","v":-375000},{"$f":"IF(M159=0,IF(L159>0,100,IF(L159=0,0,-100)),(N159/M159)*100)","v":-100}]
[null,null,"1775","SCHERER 3 REPLACE SOOTBLOWER CONTROLS","VICKI",28317.33,0,28317.33,1,"*",null,null,0,0,0]
[null,null,"1784","SCHERER 3 TRAVELING WATER SCREEN ON COOLING TOWER 369703","VICKI",589.98,0,589.98,1,"",null,null,0,0,0]
[null,null,"1785","SCHERER COMMON REVERSE OSMOSIS WATER TREATMENT PLANT","VICKI",8352.59,0,8352.59,1,"",null,null,93750,-93750,-100]
[null,null,"1814","DANIEL 2 EXPANSION JOINTS C00435 & C00437","VICKI",93857.74,130373,-36515.26,-0.28008299264418202,"*",null,null,130373,-130373,-100]
[null,null,"1840","DANIEL TRACTOR DOZER PURCHASE","VICKI",892351.78,0,892351.78,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H164<-250000,H164>250000,I164<-0.1,I164>0.1),(OR(H164>=10000,H164<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H164<=-250000,H164>=250000),(OR(H164>=10000,H164<=-10000))),\"*\",\"\"))","v":"*"},null,null,0,{"$f":"L164-M164","v":0},{"$f":"IF(M164=0,IF(L164>0,100,IF(L164=0,0,-100)),(N164/M164)*100)","v":0}]
[null,null,"1842","DANIEL 1 GSU TRANSFORMER","VICKI",201057.44,2503668,-2302610.56,-0.919694847719426,"*",null,null,5005394,-5005394,-100]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H166<-250000,H166>250000,I166<-0.1,I166>0.1),(OR(H166>=10000,H166<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H166<=-250000,H166>=250000),(OR(H166>=10000,H166<=-10000))),\"*\",\"\"))","v":""}]
[null,"TOTAL FOSSIL","Remove",{"$f":"$B167","v":"TOTAL FOSSIL"},null,{"$f":"SUM(F49:F166)","v":38728062.649999999},{"$f":"SUM(G49:G166)","v":37872935},{"$f":"F167-G167","v":855127.64999999851},{"$f":"IF(G167=0,1,+H167/G167)","v":2.257885875493934E-2},null,null,{"$f":"SUM(L49:L166)","v":0},69168715,{"$f":"L167-M167","v":-69168715},{"$f":"(N167/M167)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H168<-250000,H168>250000,I168<-0.1,I168>0.1),(OR(H168>=10000,H168<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H168<=-250000,H168>=250000),(OR(H168>=10000,H168<=-10000))),\"*\",\"\"))","v":""}]
[null,"RENEWABLES",null,null,null,null,null,null,null,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H169<-250000,H169>250000,I169<-0.1,I169>0.1),(OR(H169>=10000,H169<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H169<=-250000,H169>=250000),(OR(H169>=10000,H169<=-10000))),\"*\",\"\"))","v":""}]
[null,null,"0090",{"$f":"VLOOKUP($C170, Walker_Description, 2, FALSE)","v":"PERDIDO LANDFILL GAS TO ENERGY PROJECT"},"VICKI",{"$f":"SUMIF(PE, $C170, YTD_Actual)","v":1035.03},{"$f":"SUMIF(PE, $C170, YTD_Budget)","v":0},{"$f":"SUMIF(PE, $C170, YTD_Variance_Dollars)","v":1035.03},{"$f":"SUMIF(PE, $C170, YTD_Variance_Percentage)","v":1},{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H170<-250000,H170>250000,I170<-0.1,I170>0.1),(OR(H170>=10000,H170<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H170<=-250000,H170>=250000),(OR(H170>=10000,H170<=-10000))),\"*\",\"\"))","v":""},null,null,0,{"$f":"L170-M170","v":0},{"$f":"IF(M170=0,IF(L170>0,100,IF(L170=0,0,-100)),(N170/M170)*100)","v":0}]
[null,null,"0091",{"$f":"VLOOKUP($C171, Walker_Description, 2, FALSE)","v":"PERDIDO LANDFILL GAS ENERGY"},"VICKI",{"$f":"SUMIF(PE, $C171, YTD_Actual)","v":0},{"$f":"SUMIF(PE, $C171, YTD_Budget)","v":60000},{"$f":"SUMIF(PE, $C171, YTD_Variance_Dollars)","v":-60000},{"$f":"SUMIF(PE, $C171, YTD_Variance_Percentage)","v":-1},{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H171<-250000,H171>250000,I171<-0.1,I171>0.1),(OR(H171>=10000,H171<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H171<=-250000,H171>=250000),(OR(H171>=10000,H171<=-10000))),\"*\",\"\"))","v":"*"},null,null,120000,{"$f":"L171-M171","v":-120000},{"$f":"IF(M171=0,IF(L171>0,100,IF(L171=0,0,-100)),(N171/M171)*100)","v":-100}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H172<-250000,H172>250000,I172<-0.1,I172>0.1),(OR(H172>=10000,H172<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H172<=-250000,H172>=250000),(OR(H172>=10000,H172<=-10000))),\"*\",\"\"))","v":""}]
[null,"TOTAL RENEWABLES","Remove",{"$f":"$B173","v":"TOTAL RENEWABLES"},null,{"$f":"SUM(F170:F172)","v":1035.03},{"$f":"SUM(G170:G172)","v":60000},{"$f":"F173-G173","v":-58964.97},{"$f":"IF(G173=0,1,+H173/G173)","v":-0.98274950000000005},null,null,{"$f":"SUM(L170:L172)","v":0},120000,{"$f":"L173-M173","v":-120000},{"$f":"(N173/M173)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
["TOTAL POWER GENERATION",null,null,null,null,{"$f":"F167+F46+F173","v":116339722.90000004},{"$f":"G167+G46+G173","v":124221160},{"$f":"F175-G175","v":-7881437.0999999642},{"$f":"IF(G175=0,1,+H175/G175)","v":-6.3446816146298782E-2},null,null,{"$f":"+L173+L167+L46","v":0},245415296,{"$f":"L175-M175","v":-245415296},{"$f":"(N175/M175)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
["POWER DELIVERY",null,null,null,null,null,null,null,null,""]
[null,"NEW BUSINESS TRANSMISSION ",null,null,null,null,null,null,null,""]
[null,null,"2601",{"$f":"VLOOKUP($C179, Walker_Description, 2, FALSE)","v":"SKYGEN 230KV POWER SUPPLY"},"SARAH",{"$f":"SUMIF(PE, $C179, YTD_Actual)","v":0},{"$f":"SUMIF(PE, $C179, YTD_Budget)","v":0},{"$f":"SUMIF(PE, $C179, YTD_Variance_Dollars)","v":0},{"$f":"SUMIF(PE, $C179, YTD_Variance_Percentage)","v":0},"",null,null,0,{"$f":"L179-M179","v":0},{"$f":"IF(M179=0,IF(L179>0,100,IF(L179=0,0,-100)),(N179/M179)*100)","v":0}]
[null,null,"2603",{"$f":"VLOOKUP($C180, Walker_Description, 2, FALSE)","v":"2603 BUILD SHAKY JOE SWAMP TRANSMISSION SUBSTATION"},"SARAH",{"$f":"SUMIF(PE, $C180, YTD_Actual)","v":0},{"$f":"SUMIF(PE, $C180, YTD_Budget)","v":0},{"$f":"SUMIF(PE, $C180, YTD_Variance_Dollars)","v":0},{"$f":"SUMIF(PE, $C180, YTD_Variance_Percentage)","v":0},"",null,null,0,{"$f":"L180-M180","v":0},{"$f":"IF(M180=0,IF(L180>0,100,IF(L180=0,0,-100)),(N180/M180)*100)","v":0}]
[null,null,null,null,null,null,null,null,null,""]
[null,"TOTAL NEW BUSINESS TRANSMISSION ","Remove",{"$f":"$B182","v":"TOTAL NEW BUSINESS TRANSMISSION "},null,{"$f":"SUM(F179:F181)","v":0},{"$f":"SUM(G179:G181)","v":0},{"$f":"F182-G182","v":0},{"$f":"IF(G182=0,1,+H182/G182)","v":1},null,null,{"$f":"SUM(L179:L181)","v":0},0,{"$f":"L182-M182","v":0},{"$f":"(N182/M182)*100","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,""]
[null,"NEW BUSINESS DISTRIBUTION",null,null,null,null,null,null,null,""]
[null,null,"2553",{"$f":"VLOOKUP($C185, Walker_Description, 2, FALSE)","v":"NEW BUSINESS STREET LIGHTS"},"HAL",{"$f":"SUMIF(PE, $C185, YTD_Actual)","v":220249.15},{"$f":"SUMIF(PE, $C185, YTD_Budget)","v":280278},{"$f":"SUMIF(PE, $C185, YTD_Variance_Dollars)","v":-60028.85},{"$f":"SUMIF(PE, $C185, YTD_Variance_Percentage)","v":-0.21417610372558701},"*",null,null,516547,{"$f":"L185-M185","v":-516547},{"$f":"IF(M185=0,IF(L185>0,100,IF(L185=0,0,-100)),(N185/M185)*100)","v":-100},{"$f":"IF(OR(N185>999999,N185<-999999),\"**\",\"\")","v":""}]
[null,null,"2556","PRIVATE STREET & YARD LIGHTS","HAL",714751.13,852185,-137433.87,-0.161272341099644,"*",null,null,1570269,-1570269,-100,"**"]
[null,null,"2558","ADVANCED ENERGY MANAGEMENT (AEM)","HAL",835918.49,1140788,-304869.51,-0.26724466772090899,"*",null,null,2427577,-2427577,-100]
[null,null,"2550","CUSTOMER'S METERS","PAUL",414096.46,432000,-17903.54,-4.1443379629629601E-2,"",null,null,750000,-750000,-100]
[null,null,"2551","LINE TRANSFORMERS","PAUL",3393091.83,3087000,306091.83,9.9155111758989306E-2,"*",null,null,6000000,-6000000,-100]
[null,null,"2552","NEW BUSINESS DISTRIBUTION","PAUL",1791279.26,2745000,-953720.74,-0.34743924954462702,"*",null,null,5281000,-5281000,-100]
[null,null,"2554","NEW BUSINESS - UNDERGROUND","PAUL",1772557.12,3327000,-1554442.88,-0.46722058310790499,"*",null,null,6674000,-6674000,-100,"**"]
[null,null,"2555","ADVANCED METERING INFRASTRUCTURE","PAUL",8387734.4299999997,7214000,1173734.43,0.162702305239811,"*",null,null,15826000,-15826000,-100,"**"]
[null,null,"2559","METER TREATERS","PAUL",67766,148000,-80234,-0.54212162162162203,"*",null,null,247000,-247000,-100,""]
[null,null,null,null,null,null,null,null,null,""]
[null,"TOTAL NEW BUSINESS DISTRIBUTION","Remove",{"$f":"$B195","v":"TOTAL NEW BUSINESS DISTRIBUTION"},null,{"$f":"SUM(F185:F194)","v":17597443.870000001},{"$f":"SUM(G185:G194)","v":19226251},{"$f":"F195-G195","v":-1628807.129999999},{"$f":"IF(G195=0,1,+H195/G195)","v":-8.4717875055308436E-2},null,null,{"$f":"SUM(L185:L194)","v":0},39292393,{"$f":"L195-M195","v":-39292393},{"$f":"SUM(O185:O194)","v":-900}]
[null,null,null,null,null,null,null,null,null,""]
[null,"OTHER TRANSMISSION",null,null,null,null,null,null,null,""]
[null,null,"2801",{"$f":"VLOOKUP($C198, Walker_Description, 2, FALSE)","v":"TRANS SUB INFRASTRUCTURE PROJECTS"},"SARAH",{"$f":"SUMIF(PE, $C198, YTD_Actual)","v":-131432.51},{"$f":"SUMIF(PE, $C198, YTD_Budget)","v":340000},{"$f":"SUMIF(PE, $C198, YTD_Variance_Dollars)","v":-471432.51},{"$f":"SUMIF(PE, $C198, YTD_Variance_Percentage)","v":-1.38656620588235},"*",null,null,650000,{"$f":"L198-M198","v":-650000},{"$f":"IF(M198=0,IF(L198>0,100,IF(L198=0,0,-100)),(N198/M198)*100)","v":-100},{"$f":"IF(OR(N198>999999,N198<-999999),\"**\",\"\")","v":""}]
[null,null,"2802","TRANS LINE INFRASTRUCTURE PROJECT","SARAH",3353228.17,1450000,1903228.17,1.3125711517241401,"*",null,null,3000000,-3000000,-100,{"$f":"IF(OR(N199>999999,N199<-999999),\"**\",\"\")","v":"**"}]
[null,null,"2806","CRIST-BRENTWOOD 115 KV REPLACE INSULATORS","SARAH",500561.34,0,500561.34,1,"*",null,null,462500,-462500,-100]
[null,null,"2808","SHOAL RIVER-SANTA ROSA 230KV NEW TL","SARAH",-1568.75,0,-1568.75,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H201<-250000,H201>250000,I201<-0.1,I201>0.1),(OR(H201>=10000,H201<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H201<=-250000,H201>=250000),(OR(H201>=10000,H201<=-10000))),\"*\",\"\"))","v":""},null,null,0,{"$f":"L201-M201","v":0},{"$f":"IF(M201=0,IF(L201>0,100,IF(L201=0,0,-100)),(N201/M201)*100)","v":0}]
[null,null,"2810","HIGHLAND  CTY-MILLERS FERRY 115KV LINE REPL","SARAH",-93995.91,60000,-153995.91,-2.5665985,"*",null,null,505000,-505000,-100,{"$f":"IF(OR(N202>999999,N202<-999999),\"**\",\"\")","v":""}]
[null,null,"2814","LAGUNA-SANTA ROSA 230KV CONVERSION","SARAH",257778.04,311506,-53727.96,-0.172478090309657,"*",null,null,499083,-499083,-100]
[null,null,"2822","TRANS LINE SWITCH REPLACEMENT PROJECT 2006-2008","SARAH",2032.86,200000,-197967.14,-0.98983569999999999,"*",null,null,500000,-500000,-100,{"$f":"IF(OR(N204>999999,N204<-999999),\"**\",\"\")","v":""}]
[null,null,"2825","SINAI CEMETERY 230 KV REACTOR","SARAH",103186.74,0,103186.74,1,"*",null,null,0,0,0,{"$f":"IF(OR(N205>999999,N205<-999999),\"**\",\"\")","v":""}]
[null,null,"2828","GLENDALE PROT & CONTROL SYS REPL","SARAH",486259.99,650000,-163740.01,-0.25190770769230802,"*",null,null,650000,-650000,-100,{"$f":"IF(OR(N206>999999,N206<-999999),\"**\",\"\")","v":""}]
[null,null,"2837","WRIGHT RELAY MODERNIZATION 2015","SARAH",3795.38,0,3795.38,1,"",null,null,0,0,0]
[null,null,"2838","WEWA PROTECTION AND CONTROL REPLACEMENT","SARAH",-57597.43,0,-57597.43,1,"*",null,null,0,0,0]
[null,null,"2839","BELLEVIEW 230 & 115KV PROT & CONTROL SYS REPL","SARAH",0,0,0,0,"",null,null,90000,-90000,-100]
[null,null,"2843","CALLAWAY 230 & 115KV PROT & CONTROL SYS REPL","SARAH",932737.33,910000,22737.33,2.4986076923076899E-2,"",null,null,1045000,-1045000,-100,{"$f":"IF(OR(N210>999999,N210<-999999),\"**\",\"\")","v":"**"}]
[null,null,"2844","SINAI -WOODRUFF 115KV FIBER INSTALLATION","SARAH",197444.67,498750,-301305.33,-0.60412096240601498,"*",null,null,498750,-498750,-100]
[null,null,"2845","TRANSMISSION TOOLS & TEST EQUIPMENT (SGIG)","SARAH",22702.92,0,22702.92,1,"*",null,null,0,0,0]
[null,null,"2846","TRANSMISSION ROW CLEARING","SARAH",-20246.900000000001,0,-20246.900000000001,1,"*",null,null,0,0,0]
[null,null,"2852","BRENTWOOD 230/115KV AUTOBANK","SARAH",132258.22,100000,32258.22,0.32258219999999999,"*",null,null,100000,-100000,-100,{"$f":"IF(OR(N214>999999,N214<-999999),\"**\",\"\")","v":""}]
[null,null,"2853","LAGUNA BEACH 230-115KV AUTOBANK","SARAH",3678518.72,4400000,-721481.28,-0.163973018181818,"*",null,null,4900000,-4900000,-100]
[null,null,"2854","WRIGHT-FT WALTON BEACH CHANGE OUT POLES                     ","SARAH",456308.59,718750,-262441.40999999997,-0.365135874782609,"*",null,null,718750,-718750,-100]
[null,null,"2861","LAGUNA SANTA ROSA 115KV REPLACE INSULATORS","SARAH",665510.68000000005,1402500,-736989.32,-0.52548258110516899,"*",null,null,1492500,-1492500,-100,{"$f":"IF(OR(N217>999999,N217<-999999),\"**\",\"\")","v":"**"}]
[null,null,"2863","Wright - Freedom Way 115kV Sub and Line","SARAH",1055400.6000000001,0,1055400.6000000001,1,"*",null,null,0,0,0,{"$f":"IF(OR(N218>999999,N218<-999999),\"**\",\"\")","v":""}]
[null,null,"2867","HOLMES CREEK-HIGHLAND CITY NEW 230KV TL","SARAH",921204.28,1815311,-894106.72,-0.49253638632719099,"*",null,null,3180004,-3180004,-100]
[null,null,"2874","SMITH-LAGUNA 230KV CONVERSION","SARAH",14940163.51,15088167,-148003.49,-9.8092425673708596E-3,"",null,null,22426334,-22426334,-100]
[null,null,"2876","BRENTWOOD- BAYOU CHICO 115KV RECONDUCTOR","SARAH",1121.54,0,1121.54,1,"",null,null,0,0,0,{"$f":"IF(OR(N219>999999,N219<-999999),\"**\",\"\")","v":"**"}]
[null,null,"2882","MOLINO - PINE FOREST 115KV RECONDUCTOR","SARAH",63090.879999999997,399000,-335909.12,-0.84187749373433596,"*",null,null,625000,-625000,-100]
[null,null,"2886","RECONDUCTOR CRIST-BARRY 230KV LINE","SARAH",1260.8699999999999,0,1260.8699999999999,1,"",null,null,0,0,0]
[null,null,"2888","SINAI - CALLAWAY 115KV TL RECONDUCTOR","SARAH",2030761.98,4355000,-2324238.02,-0.53369414925373104,"*",null,null,7235000,-7235000,-100]
[null,null,"2889","CRIST - AIR PRODUCTS REBUILD","SARAH",0,565000,-565000,-1,"*",null,null,1125000,-1125000,-100]
[null,null,"2890","SLOCOMB - HOLMES CREEK 230KV REBUILD","SARAH",0,120000,-120000,-1,"*",null,null,270000,-270000,-100]
[null,null,"2892","CRIST FILTERED CAPBANK","SARAH",16374.01,4500000,-4483625.99,-0.99636133111111103,"*",null,null,4900000,-4900000,-100]
[null,null,"2894","S CRESTVIEW RELAY S HOUSE REPL","SARAH",488748.41,0,488748.41,1,"*",null,null,1375000,-1375000,-100]
[null,null,"3479","EASTGATE RELAY MODERNIZATION 2010","SARAH",37775.629999999997,40000,-2224.37,-5.5609250000000103E-2,"",null,null,40000,-40000,-100]
[null,null,"3480","REDWOOD RELAY MODERNIZATION 2010","SARAH",0,0,0,0,"",null,null,20000,-20000,-100]
[null,null,"3484","BAYOU CHICO PROT & CONTROL SYS REPL","SARAH",0,40000,-40000,-1,"*",null,null,40000,-40000,-100]
[null,null,"3487","LONG BEACH PROT & CONTROL SYS REPL","SARAH",4626.8100000000004,0,4626.8100000000004,1,"",null,null,20000,-20000,-100]
[null,null,"3488","LIVE OAK PROT & CONTROL SYS REPL","SARAH",0,0,0,0,"",null,null,35000,-35000,-100]
[null,null,null,null,null,null,null,null,null,""]
[null,"TOTAL OTHER TRANSMISSION","Remove",{"$f":"$B235","v":"TOTAL OTHER TRANSMISSION"},null,{"$f":"SUM(F198:F234)","v":30048010.669999998},{"$f":"SUM(G198:G234)","v":37963984},{"$f":"F235-G235","v":-7915973.3300000019},{"$f":"IF(G235=0,1,+H235/G235)","v":-0.2085127137868355},null,null,{"$f":"SUM(L198:L234)","v":0},56402921,{"$f":"L235-M235","v":-56402921},{"$f":"(N235/M235)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
[null,"OTHER DISTRIBUTION",null,null,null,null,null,null,null,""]
[null,null,"2895",{"$f":"VLOOKUP($C238, Walker_Description, 2, FALSE)","v":"BLACKWATER SUB 12KV FEEDER BAY"},"SARAH",{"$f":"SUMIF(PE, $C238, YTD_Actual)","v":0},{"$f":"SUMIF(PE, $C238, YTD_Budget)","v":0},{"$f":"SUMIF(PE, $C238, YTD_Variance_Dollars)","v":0},{"$f":"SUMIF(PE, $C238, YTD_Variance_Percentage)","v":0},"",null,null,15000,{"$f":"L238-M238","v":-15000},{"$f":"IF(M238=0,IF(L238>0,100,IF(L238=0,0,-100)),(N238/M238)*100)","v":-100},{"$f":"IF(OR(N238>999999,N238<-999999),\"**\",\"\")","v":""}]
[null,null,"3401","DIST SUB INFRASTRUCTURE PROJECTS","SARAH",423178.17,250000,173178.17,0.69271267999999997,"*",null,null,1000000,-1000000,-100,"**"]
[null,null,"3402","MISC. DISTRIBUTION IMPROVEMENTS & REPL.","PAUL",2566870.25,1704000,862870.25,0.50637925469483602,"*",null,null,3646000,-3646000,-100]
[null,null,"3403","DIST. ADDITIONS & RETIR. DUE TO HWY. COMM.","PAUL",289622.05,378000,-88377.95,-0.233804100529101,"*",null,null,1108000,-1108000,-100]
[null,null,"3404","DISTRIBUTION LINE MINOR PROJECTS","PAUL",585324.1,316000,269324.09999999998,0.85229145569620202,"*",null,null,750000,-750000,-100,""]
[null,null,"3405","UNDERGROUND SYSTEM ADDITIONS & IMPROVE.","PAUL",840632.17,680000,160632.17000000001,0.23622377941176501,"*",null,null,2175000,-2175000,-100,"**"]
[null,null,"3406","DISTRIBUTION UNDERGROUND CONVERSIONS","PAUL",1330105.8799999999,318000,1012105.88,3.1827228930817602,"*",null,null,857000,-857000,-100,""]
[null,null,"3407","MISC CAPITAL ACCRUALS","PAUL",-883795.02,0,-883795.02,1,"*",null,null,0,0,0]
[null,null,"3408","Distribution Improvements - Osmose","PAUL",688284.71,869000,-180715.29,-0.20795775604142699,"*",null,null,1750000,-1750000,-100]
[null,null,"3418","GULF BREEZE RELIABILITY UPGRADE","SARAH",0,0,0,0,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H247<-250000,H247>250000,I247<-0.1,I247>0.1),(OR(H247>=10000,H247<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H247<=-250000,H247>=250000),(OR(H247>=10000,H247<=-10000))),\"*\",\"\"))","v":""},null,null,20000,-20000,-100]
[null,null,"3422","OCEAN CITY LOWSIDE BUS REBUILD","SARAH",0,350000,-350000,-1,"*",null,null,550000,-550000,-100]
[null,null,"3440","BAY COUNTY SUB BANK UPGRADE AND NEW 12KV FEEDER BAY","SARAH",926927.58,1600000,-673072.42,-0.4206702625,"*",null,null,1600000,-1600000,-100,"**"]
[null,null,"3448","Misc Distribution Upgrades (SGIG)","SARAH",15002.37,0,15002.37,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H250<-250000,H250>250000,I250<-0.1,I250>0.1),(OR(H250>=10000,H250<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H250<=-250000,H250>=250000),(OR(H250>=10000,H250<=-10000))),\"*\",\"\"))","v":"*"},null,null,0,{"$f":"L250-M250","v":0},{"$f":"IF(M250=0,IF(L250>0,100,IF(L250=0,0,-100)),(N250/M250)*100)","v":0},{"$f":"IF(OR(N250>999999,N250<-999999),\"**\",\"\")","v":""}]
[null,null,"3453","DIST 12KV BREAKER REPLACEMENT PROGRAM 2006-2007","SARAH",0,50000,-50000,-1,"*",null,null,150000,-150000,-100,""]
[null,null,"3461","NAVARRE 115/12KV BANK #2 2007-2008","SARAH",1083877.23,1440000,-356122.77,-0.24730747916666701,"*",null,null,1440000,-1440000,-100,"**"]
[null,null,"3476","BEACH HAVEN RELAY MODERNIZATION 2008","SARAH",-5488.08,0,-5488.08,1,"",null,null,0,0,0]
[null,null,"3477","VALPARAISO RELAY MODERNIZATION 2008","SARAH",0,0,0,0,"",null,null,0,0,0]
[null,null,"3481","GREENWOOD PROT & CONTROL SYS REPL","SARAH",-77459.259999999995,0,-77459.259999999995,1,"*",null,null,0,0,0,""]
[null,null,"3483","GOULDING PROT & CONTROL SYS REPL","SARAH",300792.59000000003,1235000,-934207.41,-0.75644324696356302,"*",null,null,1235000,-1235000,-100]
[null,null,"3491","HENDERSON PARK SUB 115/12 KV NEW SUB AND FEEDER","SARAH",2031301.73,3105000,-1073698.27,-0.345796544283414,"*",null,null,3105000,-3105000,-100]
[null,null,"3498","SMART GRID - ECONOMIC STIMULUS","PAUL",2191049.13,990000,1201049.1299999999,1.2131809393939399,"*",null,null,1980000,-1980000,-100,"**"]
[null,null,"3500","ASSET MANAGEMENT IMPROVEMENT PROGRAMS","PAUL",208108.6,927000,-718891.4,-0.77550312837109003,"*",null,null,1801000,-1801000,-100,"**"]
[null,null,"3501","MISC DISTRIBUTION LINE SPECIFIC FEEDER IMPROVS","PAUL",4512.18,626000,-621487.81999999995,-0.99279204472843396,"*",null,null,1000000,-1000000,-100,"**"]
[null,null,"3507","NAVY FEDERAL-NATURE WALK","PAUL",0,0,0,0,"",null,null,1000000,-1000000,-100,"**"]
[null,null,"3511","DEVILLIERS SUB - OCB 7414 INSTALL","PAUL",0,75000,-75000,-1,"*",null,null,200000,-200000,-100]
[null,null,"3513","CROOKED CREEK SUB - OCB NEW REC","PAUL",34990.550000000003,0,34990.550000000003,1,"*",null,null,100000,-100000,-100,""]
[null,null,"3633","WEST PERDIDO KEY CROSSING ENHANCEMENTS","PAUL",90706,59000,31706,0.537389830508475,"*",null,null,59000,-59000,-100]
[null,null,"3636","EAST BAY 5832 PHASE ADDITION","PAUL",14158.2,70000,-55841.8,-0.79774,"*",null,null,70000,-70000,-100]
[null,null,"3642","CHIPLEY 9202 - PHASE ADDITION","PAUL",86051.17,82000,4051.17,4.9404512195121902E-2,"",null,null,82000,-82000,-100]
[null,null,"3643","CONSTRUCT NEW HENDERSON BCH DIST SUBSTATION","PAUL",311165.33,500000,-188834.67,-0.37766934000000002,"*",null,null,500000,-500000,-100]
[null,null,"3645","BAY COUNTY SUB-NEW FEEDER","PAUL",0,333000,-333000,-1,"*",null,null,333000,-333000,-100]
[null,null,"3646","WHITING SUB-NEW FEEDER","PAUL",0,0,0,0,"",null,null,500000,-500000,-100]
[null,null,"3647","UNLOCATED TX ADD - CANCEL","PAUL",0,0,0,0,"",null,null,242000,-242000,-100]
[null,null,"3648","VALPARAISO 9252-AIRPORT RECONDUCTOR","PAUL",229230.96,0,229230.96,1,"*",null,null,270000,-270000,-100]
[null,null,"3650","STORM SUPPORT - OVERHEAD","PAUL",752.97,0,752.97,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H272<-250000,H272>250000,I272<-0.1,I272>0.1),(OR(H272>=10000,H272<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H272<=-250000,H272>=250000),(OR(H272>=10000,H272<=-10000))),\"*\",\"\"))","v":""},null,null,null,{"$f":"L272-M272","v":0},{"$f":"IF(M272=0,IF(L272>0,100,IF(L272=0,0,-100)),(N272/M272)*100)","v":0}]
[null,null,"3652","STORM HARDENING - OVERHEAD","PAUL",291332.18,397000,-105667.82,-0.26616579345088198,"*",null,null,811000,-811000,-100]
[null,null,"3691","EAST HILL SUB CONVERT 2 - 4KV FDR 12/4KV TO 12KV","PAUL",215035.03,300000,-84964.97,-0.283216566666667,"*",null,null,300000,-300000,-100]
[null,null,"3693","DEVILLIERS SUB OCB 7414 REPLACE 20 PROTECTORS","PAUL",295337.59999999998,245000,50337.599999999999,0.20545959183673501,"*",null,null,491000,-491000,-100]
[null,null,"3698","NAVARRE SUB - NEW 795 FEEDER","PAUL",386040.46,725000,-338959.54,-0.46753040000000001,"*",null,null,645000,-645000,-100]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H277<-250000,H277>250000,I277<-0.1,I277>0.1),(OR(H277>=10000,H277<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H277<=-250000,H277>=250000),(OR(H277>=10000,H277<=-10000))),\"*\",\"\"))","v":""}]
[null,"TOTAL OTHER DISTRIBUTION","Remove",{"$f":"$B278","v":"TOTAL OTHER DISTRIBUTION"},null,{"$f":"SUM(F238:F277)","v":14473646.830000002},{"$f":"SUM(G238:G277)","v":17624000},{"$f":"F278-G278","v":-3150353.1699999981},{"$f":"IF(G278=0,1,+H278/G278)","v":-0.17875358431684057},"*",null,{"$f":"SUM(L238:L277)","v":0},29785000,{"$f":"L278-M278","v":-29785000},{"$f":"(N278/M278)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
[null,"JOINT SUB. & DIST. LINE",null,null,null,null,null,null,null,""]
[null,null,"3700",{"$f":"VLOOKUP($C281, Walker_Description, 2, FALSE)","v":"SYSTEM REACTIVE CORRECTIVE CAPACITY"},"PAUL",{"$f":"SUMIF(PE, $C281, YTD_Actual)","v":320771.14},{"$f":"SUMIF(PE, $C281, YTD_Budget)","v":274000},{"$f":"SUMIF(PE, $C281, YTD_Variance_Dollars)","v":46771.14},{"$f":"SUMIF(PE, $C281, YTD_Variance_Percentage)","v":0.170697591240876},"*",null,null,381000,{"$f":"L281-M281","v":-381000},{"$f":"IF(M281=0,IF(L281>0,100,IF(L281=0,0,-100)),(N281/M281)*100)","v":-100},null,null,null,null,"*"]
[null,null,"3702","CIRCUIT SWITCHER IMPR - TS (2004-2008)","SARAH",62714.57,105000,-42285.43,-0.40271838095238099,"*",null,null,250000,-250000,-100]
[null,null,"3727","HINSON'S CROSSROADS BANK ADDITION (NEW)","SARAH",89971.23,50000,39971.230000000003,0.79942460000000004,"*",null,null,50000,-50000,-100]
[null,null,"3731","LULLWATER SUB BANK ADDITION (NEW)","SARAH",4934.57,0,4934.57,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H284<-250000,H284>250000,I284<-0.1,I284>0.1),(OR(H284>=10000,H284<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H284<=-250000,H284>=250000),(OR(H284>=10000,H284<=-10000))),\"*\",\"\"))","v":""},null,null,50000,{"$f":"L284-M284","v":-50000},{"$f":"IF(M284=0,IF(L284>0,100,IF(L284=0,0,-100)),(N284/M284)*100)","v":-100}]
[null,null,"3742","EMS TRANS SYSTEM ADD AND IMPROVMENTS","SARAH",407930.88,350000,57930.879999999997,0.16551679999999999,"*",null,null,635000,-635000,-100]
[null,null,"3745","JAY ROAD BANK UPGRADE","SARAH",-2042.63,0,-2042.63,1,"",null,null,0,0,0,null,null,null,null,"*"]
[null,null,"3748","FIBER OPTIC EQUIP","SARAH",412345.76,0,412345.76,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H287<-250000,H287>250000,I287<-0.1,I287>0.1),(OR(H287>=10000,H287<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H287<=-250000,H287>=250000),(OR(H287>=10000,H287<=-10000))),\"*\",\"\"))","v":"*"},null,null,0,{"$f":"L287-M287","v":0},{"$f":"IF(M287=0,IF(L287>0,100,IF(L287=0,0,-100)),(N287/M287)*100)","v":0},null,null,null,null,"*"]
[null,null,"3752","FAIRFIELD RING BUS","SARAH",-31797.77,0,-31797.77,1,"*",null,null,0,0,0]
[null,null,"3753","HOLIDAY NEW SUB 2009","SARAH",89950.74,0,89950.74,1,"*",null,null,50000,-50000,-100]
[null,null,"3754","ECUA 230/12 KV NEW SUB NEW FDR","SARAH",3084.35,0,3084.35,1,"",null,null,0,0,0]
[null,null,"3755","JAY ROAD BANK UPGRADE (SGIG)","SARAH",289804.48,0,289804.48,1,"*",null,null,0,0,0]
[null,null,"3756","OPTICAL GROUND WIRE (SGIG)","SARAH",-409139.81,0,-409139.81,1,"*",null,null,245000,-245000,-100]
[null,null,null,null,null,null,null,null,null,""]
[null,"TOTAL JOINT SUB. & DIST. LINE","Remove",{"$f":"$B294","v":"TOTAL JOINT SUB. & DIST. LINE"},null,{"$f":"SUM(F281:F293)","v":1238527.51},{"$f":"SUM(G281:G293)","v":779000},{"$f":"F294-G294","v":459527.51},{"$f":"IF(G294=0,1,+H294/G294)","v":0.58989410783055196},null,null,{"$f":"SUM(L281:L293)","v":0},1611000,{"$f":"L294-M294","v":-1611000},{"$f":"(N294/M294)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
["TOTAL POWER DELIVERY",null,"Remove",{"$f":"$A296","v":"TOTAL POWER DELIVERY"},null,{"$f":"F294+F278+F235+F195+F182","v":63357628.879999995},{"$f":"G294+G278+G235+G195+G182","v":75593235},{"$f":"F296-G296","v":-12235606.120000005},{"$f":"IF(G296=0,1,+H296/G296)","v":-0.16186112580047679},null,null,{"$f":"L182+L294+L278+L235+L195","v":0},127091314,{"$f":"L296-M296","v":-127091314},{"$f":"(N296/M296)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,"FLEET",null,null,null,null,null,null,null,""]
[null,null,"4304",{"$f":"VLOOKUP($C300, Walker_Description, 2, FALSE)","v":"AUTOMOBILES, AUTO TRUCKS & EQUIP."},"ALLISON Bryant",{"$f":"SUMIF(PE, $C300, YTD_Actual)","v":381601.99},{"$f":"SUMIF(PE, $C300, YTD_Budget)","v":800000},{"$f":"SUMIF(PE, $C300, YTD_Variance_Dollars)","v":-418398.01},{"$f":"SUMIF(PE, $C300, YTD_Variance_Percentage)","v":-0.52299751250000004},{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H300<-250000,H300>250000,I300<-0.1,I300>0.1),(OR(H300>=10000,H300<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H300<=-250000,H300>=250000),(OR(H300>=10000,H300<=-10000))),\"*\",\"\"))","v":"*"},null,null,1700000,{"$f":"L300-M300","v":-1700000},{"$f":"IF(M300=0,IF(L300>0,100,IF(L300=0,0,-100)),(N300/M300)*100)","v":-100}]
[null,"`",null,null,null,null,null,null,null,""]
[null,"TOTAL FLEET","Remove",{"$f":"$B302","v":"TOTAL FLEET"},null,{"$f":"F300","v":381601.99},{"$f":"G300","v":800000},{"$f":"F302-G302","v":-418398.01},{"$f":"IF(G302=0,1,+H302/G302)","v":-0.52299751250000004},"*",null,{"$f":"L300","v":0},1700000,{"$f":"L302-M302","v":-1700000},{"$f":"(N302/M302)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
[null,"TELECOMMUNICATIONS",null,null,null,null,null,null,null,""]
[null,null,"4305",{"$f":"VLOOKUP($C305, Walker_Description, 2, FALSE)","v":"WIRELESS SYSTEMS"},"DEBBIE",{"$f":"SUMIF(PE, $C305, YTD_Actual)","v":34685.72},{"$f":"SUMIF(PE, $C305, YTD_Budget)","v":189900},{"$f":"SUMIF(PE, $C305, YTD_Variance_Dollars)","v":-155214.28},{"$f":"SUMIF(PE, $C305, YTD_Variance_Percentage)","v":-0.81734744602422305},"*",null,null,202900,{"$f":"L305-M305","v":-202900},{"$f":"IF(M305=0,IF(L305>0,100,IF(L305=0,0,-100)),(N305/M305)*100)","v":-100},4305]
[null,null,"4310",{"$f":"VLOOKUP($C306, Walker_Description, 2, FALSE)","v":"VOICE & DATA CONVERGED NETWORK"},"DEBBIE",{"$f":"SUMIF(PE, $C306, YTD_Actual)","v":159724.03},{"$f":"SUMIF(PE, $C306, YTD_Budget)","v":615000},{"$f":"SUMIF(PE, $C306, YTD_Variance_Dollars)","v":-455275.97},{"$f":"SUMIF(PE, $C306, YTD_Variance_Percentage)","v":-0.74028613008130095},"*",null,null,890000,{"$f":"L306-M306","v":-890000},{"$f":"IF(M306=0,IF(L306>0,100,IF(L306=0,0,-100)),(N306/M306)*100)","v":-100},4310]
[null,null,"4311",{"$f":"VLOOKUP($C307, Walker_Description, 2, FALSE)","v":"TRANSPORT NETWORK ADD/IMPROVE"},"DEBBIE",{"$f":"SUMIF(PE, $C307, YTD_Actual)","v":62501.25},{"$f":"SUMIF(PE, $C307, YTD_Budget)","v":100000},{"$f":"SUMIF(PE, $C307, YTD_Variance_Dollars)","v":-37498.75},{"$f":"SUMIF(PE, $C307, YTD_Variance_Percentage)","v":-0.37498749999999997},"*",null,null,575000,{"$f":"L307-M307","v":-575000},{"$f":"IF(M307=0,IF(L307>0,100,IF(L307=0,0,-100)),(N307/M307)*100)","v":-100},4311]
[null,null,"4385",{"$f":"VLOOKUP($C308, Walker_Description, 2, FALSE)","v":"FIELD COMPUTERS"},"DEBBIE",{"$f":"SUMIF(PE, $C308, YTD_Actual)","v":10232.120000000001},{"$f":"SUMIF(PE, $C308, YTD_Budget)","v":30000},{"$f":"SUMIF(PE, $C308, YTD_Variance_Dollars)","v":-19767.88},{"$f":"SUMIF(PE, $C308, YTD_Variance_Percentage)","v":-0.65892933333333303},"*",null,null,50000,{"$f":"L308-M308","v":-50000},{"$f":"IF(M308=0,IF(L308>0,100,IF(L308=0,0,-100)),(N308/M308)*100)","v":-100},4385]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H309<-250000,H309>250000,I309<-0.1,I309>0.1),(OR(H309>=10000,H309<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H309<=-250000,H309>=250000),(OR(H309>=10000,H309<=-10000))),\"*\",\"\"))","v":""}]
[null,"TOTAL TELECOMMUNICATIONS","Remove",{"$f":"$B310","v":"TOTAL TELECOMMUNICATIONS"},null,{"$f":"SUM(F305:F309)","v":267143.12},{"$f":"SUM(G305:G309)","v":934900},{"$f":"F310-G310","v":-667756.88},{"$f":"IF(G310=0,1,+H310/G310)","v":-0.71425487217884265},null,null,{"$f":"SUM(L305:L309)","v":0},1717900,{"$f":"L310-M310","v":-1717900},{"$f":"(N310/M310)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
[null,"CORPORATE SERVICES",null,null,null,null,null,null,null,""]
[null,null,"4300",{"$f":"VLOOKUP($C313, Walker_Description, 2, FALSE)","v":"OFFICE FURNITURE & MECHANICAL EQUIP."},"BARBARA",{"$f":"SUMIF(PE, $C313, YTD_Actual)","v":26088.07},{"$f":"SUMIF(PE, $C313, YTD_Budget)","v":121110},{"$f":"SUMIF(PE, $C313, YTD_Variance_Dollars)","v":-95021.93},{"$f":"SUMIF(PE, $C313, YTD_Variance_Percentage)","v":-0.78459194121047005},"*",null,null,135110,{"$f":"L313-M313","v":-135110},{"$f":"IF(M313=0,IF(#REF!>0,100,IF(#REF!=0,0,-100)),(N313/M313)*100)","v":-100}]
[null,null,"4302","MISC. BUILDINGS, LAND, AND EQUIP.","BARBARA",94971.91,176328,-81356.09,-0.46139064697609,"*",null,null,251328,-251328,{"$f":"IF(M314=0,IF(#REF!>0,100,IF(#REF!=0,0,-100)),(N314/M314)*100)","v":-100}]
[null,null,"4303","SECURITY","BARBARA",0,20250,-20250,-1,"*",null,null,40500,-40500,{"$f":"IF(M315=0,IF(#REF!>0,100,IF(#REF!=0,0,-100)),(N315/M315)*100)","v":-100}]
[null,null,"4306","AV EQUIP/PRINT SERVICES","BARBARA",53452.01,24750,28702.01,1.1596771717171701,"*",null,null,45000,-45000,{"$f":"IF(M316=0,IF(#REF!>0,100,IF(#REF!=0,0,-100)),(N316/M316)*100)","v":-100},"37,700  will be offset by Power Delivery Pe 2552"]
[null,null,"4328","DESTIN ROOF","BARBARA",272925.31,375000,-102074.69,-0.27219917333333299,"*",null,null,375000,-375000,{"$f":"IF(M317=0,IF(#REF!>0,100,IF(#REF!=0,0,-100)),(N317/M317)*100)","v":-100}]
[null,null,"4360","PINE FOREST NEW OFFICE FACILITY","BARBARA",0,0,0,0,"",null,null,2475000,-2475000,{"$f":"IF(M318=0,IF(#REF!>0,100,IF(#REF!=0,0,-100)),(N318/M318)*100)","v":-100}]
[null,null,"4366","CORPORATE OFFICE 3RD FLOOR REENOVATIONS","BARBARA",111989.24,0,111989.24,1,"*",null,null,null,0,{"$f":"IF(M319=0,IF(L319>0,100,IF(L319=0,0,-100)),(N319/M319)*100)","v":0}]
[null,null,"4404","CORPORATE OFFICE COOLING TOWER","BARBARA",0,0,0,0,"",null,null,241180,-241180,{"$f":"IF(M320=0,IF(#REF!>0,100,IF(#REF!=0,0,-100)),(N320/M320)*100)","v":-100}]
[]
[null,"TOTAL CORPORATE SERVICES","Remove",{"$f":"$B322","v":"TOTAL CORPORATE SERVICES"},null,{"$f":"SUM(F313:F321)","v":559426.54},{"$f":"SUM(G313:G321)","v":717438},{"$f":"F322-G322","v":-158011.45999999996},{"$f":"IF(G322=0,1,+H322/G322)","v":-0.22024406290160259},null,null,{"$f":"SUM(L313:L321)","v":0},{"$f":"SUM(M313:M321)","v":3563118},{"$f":"SUM(N313:N321)","v":-3563118},{"$f":"(N322/M322)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
[null,"OTHER",null,null,null,null,null,null,null,""]
[null,null,"4301",{"$f":"VLOOKUP($C325, Walker_Description, 2, FALSE)","v":"TOOLS, IMPLEMENTS AND TEST EQUIP. 5 YR (DEPRECIATE)"},"PAUL",{"$f":"SUMIF(PE, $C325, YTD_Actual)","v":84977.81},{"$f":"SUMIF(PE, $C325, YTD_Budget)","v":82000},{"$f":"SUMIF(PE, $C325, YTD_Variance_Dollars)","v":2977.81},{"$f":"SUMIF(PE, $C325, YTD_Variance_Percentage)","v":3.63147560975609E-2},"",null,null,366000,{"$f":"L325-M325","v":-366000},{"$f":"IF(M325=0,IF(L325>0,100,IF(L325=0,0,-100)),(N325/M325)*100)","v":-100}]
[null,null,"4308","POWER DELIVERY TECHNOLOGY IMPROVEMENTS","PAUL",16117.79,25000,-8882.2099999999991,-0.3552884,"",null,null,61000,-61000,-100]
[null,null,"4344","T&D WAREHOUSE EQUIPMENT REPLACEMENT","ALLISON BEATY",2205.34,150000,-147794.66,-0.98529773333333304,"*",null,null,150000,-150000,-100]
[null,null,"4376","GLSCAPE AND MRO","CAROL",1115721.0900000001,2009303,-893581.91,-0.44472232908625497,"*",null,null,4022632,-4022632,-100]
[null,null,"4378","PQWER CONTROL CENTER","SARAH",3974.45,5000,-1025.55,-0.20510999999999999,"",null,null,5000,-5000,-100]
[null,null,"4400","TRANSMISSION TOOLS & TEST EQUIPMENT","SARAH",120588.2,130000,-9411.7999999999993,-7.2398461538461606E-2,"",null,null,250000,-250000,-100]
[null,null,"4785","ACCRUED PAYROLL",null,766267.95,0,766267.95,1,"*",null,null,0,0,0]
[null,null,"4790","UNASS OVERHEADS",null,-29093.99,0,-29093.99,1,{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H332<-250000,H332>250000,I332<-0.1,I332>0.1),(OR(H332>=10000,H332<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H332<=-250000,H332>=250000),(OR(H332>=10000,H332<=-10000))),\"*\",\"\"))","v":"*"},null,null,0,{"$f":"L332-M332","v":0},{"$f":"IF(M332=0,IF(L332>0,100,IF(L332=0,0,-100)),(N332/M332)*100)","v":0}]
[null,null,null,null,null,null,null,null,null,""]
[null,"TOTAL OTHER","Remove",{"$f":"$B334","v":"TOTAL OTHER"},null,{"$f":"SUM(F325:F333)","v":2080758.64},{"$f":"SUM(G325:G333)","v":2401303},{"$f":"SUM(H325:H333)","v":-320544.3600000001},{"$f":"IF(G334=0,1,+H334/G334)","v":-0.13348767731519101},null,null,{"$f":"SUM(L325:L333)","v":0},4854632,{"$f":"L334-M334","v":-4854632},{"$f":"(N334/M334)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
["TOTAL GENERAL PLANT",null,"Remove",{"$f":"$A337","v":"TOTAL GENERAL PLANT"},null,{"$f":"F334+F322+F310+F302","v":3288930.29},{"$f":"G334+G322+G310+G302","v":4853641},{"$f":"F337-G337","v":-1564710.71},{"$f":"IF(G337=0,1,+H337/G337)","v":-0.32237874824281398},null,null,{"$f":"L322+L310+L302+L334","v":0},11835650,{"$f":"L337-M337","v":-11835650},{"$f":"(N337/M337)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
["NON-UTILITY",null,null,null,null,null,null,null,null,""]
[null,null,"4999",{"$f":"VLOOKUP($C340, Walker_Description, 2, FALSE)","v":"NEW PRODUCTS AND SERVICES"},"HAL",{"$f":"SUMIF(PE, $C340, YTD_Actual)","v":67630.649999999994},{"$f":"SUMIF(PE, $C340, YTD_Budget)","v":74425},{"$f":"SUMIF(PE, $C340, YTD_Variance_Dollars)","v":-6794.3500000000104},{"$f":"SUMIF(PE, $C340, YTD_Variance_Percentage)","v":-9.1291232784682597E-2},{"$f":"IF(AND(OR($A$1=3,$A$1=6,$A$1=9,$A$1=12),OR(H340<-250000,H340>250000,I340<-0.1,I340>0.1),(OR(H340>=10000,H340<=-10000))),\"*\",IF(AND(OR($A$1=1,$A$1=2,$A$1=4,$A$1=5,$A$1=7,$A$1=8,$A$1=10,$A$1=11),OR(H340<=-250000,H340>=250000),(OR(H340>=10000,H340<=-10000))),\"*\",\"\"))","v":""},null,null,224339,{"$f":"L340-M340","v":-224339},{"$f":"IF(M340=0,IF(L340>0,100,IF(L340=0,0,-100)),(N340/M340)*100)","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
["TOTAL NON-UTILITY",null,"Remove",{"$f":"$A342","v":"TOTAL NON-UTILITY"},null,{"$f":"F340","v":67630.649999999994},{"$f":"G340","v":74425},{"$f":"H340","v":-6794.3500000000104},{"$f":"IF(G342=0,1,+H342/G342)","v":-9.1291232784682708E-2},null,null,{"$f":"L340","v":0},224339,{"$f":"L342-M342","v":-224339},{"$f":"(N342/M342)*100","v":-100}]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
["TOTAL CAPITAL",null,null,null,null,{"$f":"F342+F296+F175+F337","v":183053912.72000003},{"$f":"G342+G296+G175+G337","v":204742461},{"$f":"F345-G345","v":-21688548.279999971},{"$f":"IF(G345=0,1,+H345/G345)","v":-0.10593087615567917},null,null,{"$f":"L342+L296+L175+L337","v":0},384566599,{"$f":"L345-M345","v":-384566599},{"$f":"(N345/M345)*100","v":-100}]
[null,null,"Total","SOFIA Query Total",null,{"$f":"SUMIF(PE, $C346, YTD_Actual)","v":183053912.79999992},{"$f":"SUMIF(PE, $C346, YTD_Budget)","v":204742461},{"$f":"SUMIF(PE, $C346, YTD_Variance_Dollars)","v":-21688548.199999992},{"$f":"SUMIF(PE, $C346, YTD_Variance_Percentage)","v":-0.10593087576494449}]
[null,null,"Check",null,null,{"$f":"F346-F345","v":7.99998939037323E-2},0,7.9999979585409164E-2,3.9073468072192696E-10]
[]
[null,"* YTD VARIANCE EXPLANATION NEEDED EACH QUARTER IF YTD VARIANCE EXCEEDS \n10% OR $250,000, WHICHEVER IS LESS.\n (LESS THAN $10,000 DOES NOT REQUIRE AN EXPLANATION) \nFOR NON-QUARTER MONTHS, EXPLAIN VARIANCES OVER $250,000 ONLY."]

{"sheet":"Summary","index":4,"n_rows":116,"n_cols":15,"rows_kept":116,"cut":false,"hidden":false,"merged":[[6,8,6,9],[5,4,5,9],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Gulf Power Company"]
[{"$f":"EOMONTH(DATE(2011, 'June 2011'!$A$1, 1), 0)","v":"2011-06-30"}]
["Year-to-Date Capital Expenditures"]
["Thousands of Dollars"]
[]
[null,null,null,null,"Year-to-Date",null,null,null,null,null,null,null,null,"Re-Estimated","Estimated "]
[null,null,null,null,null,null,null,null,"Variance",null,null,"Original",null,2010,"Year-End"]
["Business Unit",null,null,null,"Actual",null,"Budget",null,"$","%",null,"Budget",null,"Expenditures","Variance"]
["Power Generation:"]
["New Generation Projects",null,null,null,0,null,0,null,{"$f":"(E10-G10)","v":0},{"$f":"IF(G10=0,IF(D10>0,100,IF(D10=0,0,-100)),(I10/G10)*100)","v":0},null,0,null,0,{"$f":"N10-L10","v":0}]
["Environmental",null,null,null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL ENVIRONMENTAL\", 'June 2011'!F:F)/1000","v":77610.625220000031},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL ENVIRONMENTAL\", 'June 2011'!G:G)/1000","v":86288.225000000006},null,{"$f":"(E11-G11)","v":-8677.599779999975},{"$f":"IF(G11=0,IF(E11>0,100,IF(D11=0,0,-100)),(I11/G11)*100)","v":-10.056528315421918},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL ENVIRONMENTAL\", 'June 2011'!M:M)/1000","v":176126.58100000001},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL ENVIRONMENTAL\", 'June 2011'!L:N)/1000","v":0},{"$f":"N11-L11","v":-176126.58100000001}]
["Production Modifications",null,null,null,0,null,0,null,null,null,null,null,null,0,0]
["Fossil Steam & CT",null,null,null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL FOSSIL\", 'June 2011'!F:F)/1000","v":38728.06265},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL FOSSIL\", 'June 2011'!G:G)/1000","v":37872.934999999998},null,{"$f":"(E13-G13)","v":855.12765000000218},{"$f":"IF(G13=0,IF(E13>0,100,IF(D13=0,0,-100)),(I13/G13)*100)","v":2.2578858754939439},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL FOSSIL\", 'June 2011'!M:M)/1000","v":69168.714999999997},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL FOSSIL\", 'June 2011'!L:N)/1000","v":0},-69168.714999999997]
["Renewables",null,null,null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL RENEWABLES\", 'June 2011'!F:F)/1000","v":1.0350299999999999},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL RENEWABLES\", 'June 2011'!G:G)/1000","v":60},null,{"$f":"(E14-G14)","v":-58.964970000000001},{"$f":"IF(G14=0,IF(E14>0,100,IF(D14=0,0,-100)),(I14/G14)*100)","v":-98.274950000000004},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL RENEWABLES\", 'June 2011'!M:M)/1000","v":120},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL RENEWABLES\", 'June 2011'!L:N)/1000","v":0},-120]
["Hydro",null,null,null,0,null,0,null,{"$f":"(E15-G15)","v":0},{"$f":"IF(G15=0,IF(D15>0,100,IF(D15=0,0,-100)),(I15/G15)*100)","v":0},null,0,null,0,0]
["Nuclear",null,null,null,0,null,0,null,{"$f":"(E16-G16)","v":0},{"$f":"IF(G16=0,IF(D16>0,100,IF(D16=0,0,-100)),(I16/G16)*100)","v":0},null,0,null,0,0]
["Nuclear Fuel",null,null,null,0,null,0,null,{"$f":"(E17-G17)","v":0},{"$f":"IF(G17=0,IF(D17>0,100,IF(D17=0,0,-100)),(I17/G17)*100)","v":0},null,0,null,0,0]
["Total Power Generation",null,null,null,{"$f":"SUM(E10:E17)","v":116339.72290000002},null,{"$f":"SUM(G10:G17)","v":124221.16},null,{"$f":"SUM(I10:I17)","v":-7881.4370999999728},{"$f":"IF(G18=0,IF(D18>0,100,IF(D18=0,0,-100)),(I18/G18)*100)","v":-6.3446816146298852},null,{"$f":"SUM(L10:L17)","v":245415.296},null,{"$f":"SUM(N10:N17)","v":0},-245415.296]
["Power Delivery:"]
["Transmission",null,null,null,{"$f":"(SUMIF('June 2011'!$B:$B, \"TOTAL OTHER TRANSMISSION\", 'June 2011'!F:F)+SUMIF('June 2011'!$B:$B, \"TOTAL NEW BUSINESS TRANSMISSION \", 'June 2011'!F:F))/1000","v":30048.01067},null,{"$f":"(SUMIF('June 2011'!$B:$B, \"TOTAL OTHER TRANSMISSION\", 'June 2011'!G:G)+SUMIF('June 2011'!$B:$B, \"TOTAL NEW BUSINESS TRANSMISSION\", 'June 2011'!G:G))/1000","v":37963.983999999997},null,{"$f":"(E20-G20)","v":-7915.9733299999971},{"$f":"IF(G20=0,IF(E20>0,100,IF(D20=0,0,-100)),(I20/G20)*100)","v":-20.851271378683538},null,{"$f":"(SUMIF('June 2011'!$B:$B,\"TOTAL OTHER TRANSMISSION\",'June 2011'!M:M)+SUMIF('June 2011'!$B:$B,\"TOTAL NEW BUSINESS TRANSMISSION\",'June 2011'!M:M))/1000","v":56402.921000000002},null,{"$f":"(SUMIF('June 2011'!$B:$B, \"TOTAL OTHER TRANSMISSION\",'June 2011'!L:N)+SUM('June 2011'!N182))/1000","v":0},-56402.921000000002]
["Distribution",null,null,null,{"$f":"(SUMIF('June 2011'!$B:$B, \"TOTAL OTHER DISTRIBUTION\", 'June 2011'!F:F)+SUMIF('June 2011'!$B:$B, \"TOTAL NEW BUSINESS DISTRIBUTION\", 'June 2011'!F:F))/1000","v":32071.090700000004},null,{"$f":"(SUMIF('June 2011'!$B:$B, \"TOTAL OTHER DISTRIBUTION\", 'June 2011'!G:G)+SUMIF('June 2011'!$B:$B, \"TOTAL NEW BUSINESS DISTRIBUTION\", 'June 2011'!G:G))/1000","v":36850.250999999997},null,{"$f":"(E21-G21)","v":-4779.1602999999923},{"$f":"IF(G21=0,IF(E21>0,100,IF(D21=0,0,-100)),(I21/G21)*100)","v":-12.969139070450275},null,{"$f":"(SUMIF('June 2011'!$B:$B, \"TOTAL OTHER DISTRIBUTION\", 'June 2011'!M:M)+SUMIF('June 2011'!$B:$B, \"TOTAL NEW BUSINESS DISTRIBUTION\", 'June 2011'!M:M))/1000","v":69077.392999999996},null,{"$f":"(SUMIF('June 2011'!$B:$B, \"TOTAL OTHER DISTRIBUTION\", 'June 2011'!L:N)+SUMIF('June 2011'!$B:$B, \"TOTAL NEW BUSINESS DISTRIBUTION\", 'June 2011'!L:N))/1000","v":0},-69077.392999999996]
["Joint Sub. & Dist. Lines",null,null,null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL JOINT SUB. & DIST. LINE\", 'June 2011'!F:F)/1000","v":1238.5275100000001},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL JOINT SUB. & DIST. LINE\", 'June 2011'!G:G)/1000","v":779},null,{"$f":"(E22-G22)","v":459.52751000000012},{"$f":"IF(G22=0,IF(E22>0,100,IF(D22=0,0,-100)),(I22/G22)*100)","v":58.98941078305522},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL JOINT SUB. & DIST. LINE\", 'June 2011'!M:M)/1000","v":1611},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL JOINT SUB. & DIST. LINE\", 'June 2011'!L:N)/1000","v":0},-1611]
["Total Power Delivery",null,null,null,{"$f":"SUM(E20:E22)","v":63357.628880000004},null,{"$f":"SUM(G20:G22)","v":75593.234999999986},null,{"$f":"SUM(I20:I22)","v":-12235.606119999989},{"$f":"IF(G23=0,IF(E23>0,100,IF(E23=0,0,-100)),(I23/G23)*100)","v":-16.186112580047663},null,{"$f":"SUM(L20:L22)","v":127091.314},null,{"$f":"SUM(N20:N22)","v":0},-127091.314]
["General Plant:"]
["Fleet",null,null,null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL FLEET\", 'June 2011'!F:F)/1000","v":381.60199},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL FLEET\", 'June 2011'!G:G)/1000","v":800},null,{"$f":"(E25-G25)","v":-418.39801},{"$f":"IF(G25=0,IF(E25>0,100,IF(D25=0,0,-100)),(I25/G25)*100)","v":-52.299751250000007},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL FLEET\", 'June 2011'!M:M)/1000","v":1700},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL FLEET\", 'June 2011'!L:N)/1000","v":0},-1700]
["Telecommunications",null,null,null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL TELECOMMUNICATIONS\", 'June 2011'!F:F)/1000","v":267.14312000000001},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL TELECOMMUNICATIONS\", 'June 2011'!G:G)/1000","v":934.9},null,{"$f":"(E26-G26)","v":-667.75687999999991},{"$f":"IF(G26=0,IF(E26>0,100,IF(D26=0,0,-100)),(I26/G26)*100)","v":-71.425487217884253},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL TELECOMMUNICATIONS\", 'June 2011'!M:M)/1000","v":1717.9},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL TELECOMMUNICATIONS\", 'June 2011'!L:N)/1000","v":0},-1717.9]
["Corporate Services",null,null,null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL CORPORATE SERVICES\", 'June 2011'!F:F)/1000","v":559.42654000000005},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL CORPORATE SERVICES\", 'June 2011'!G:G)/1000","v":717.43799999999999},null,{"$f":"(E27-G27)","v":-158.01145999999994},{"$f":"IF(G27=0,IF(E27>0,100,IF(D27=0,0,-100)),(I27/G27)*100)","v":-22.024406290160258},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL CORPORATE SERVICES\", 'June 2011'!M:M)/1000","v":3563.1179999999999},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL CORPORATE SERVICES\", 'June 2011'!L:N)/1000","v":0},-3563.1179999999999]
["Other",null,null,null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL OTHER\", 'June 2011'!F:F)/1000","v":2080.75864},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL OTHER\", 'June 2011'!G:G)/1000","v":2401.3029999999999},null,{"$f":"(E28-G28)","v":-320.54435999999987},{"$f":"IF(G28=0,IF(E28>0,100,IF(D28=0,0,-100)),(I28/G28)*100)","v":-13.348767731519089},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL OTHER\", 'June 2011'!M:M)/1000","v":4854.6319999999996},null,{"$f":"SUMIF('June 2011'!$B:$B, \"TOTAL OTHER\", 'June 2011'!L:N)/1000","v":0},-4854.6319999999996]
["Total General",null,null,null,{"$f":"SUM(E25:E28)","v":3288.9302900000002},null,{"$f":"SUM(G25:G28)","v":4853.6409999999996},null,{"$f":"SUM(I25:I28)","v":-1564.7107099999996},{"$f":"IF(G29=0,IF(E29>0,100,IF(E29=0,0,-100)),(I29/G29)*100)","v":-32.237874824281391},null,{"$f":"SUM(L25:L28)","v":11835.65},null,{"$f":"SUM(N25:N28)","v":0},-11835.65]
["Other",null,null,null,{"$f":"SUMIF('June 2011'!A:A, \"TOTAL NON-UTILITY\", 'June 2011'!F:F)/1000","v":67.630649999999989},null,{"$f":"SUMIF('June 2011'!$A:$A, \"TOTAL NON-UTILITY\", 'June 2011'!G:G)/1000","v":74.424999999999997},null,{"$f":"(E30-G30)","v":-6.7943500000000085},{"$f":"IF(G30=0,IF(E30>0,100,IF(D30=0,0,-100)),(I30/G30)*100)","v":-9.1291232784682688},null,{"$f":"SUMIF('June 2011'!$A:$A, \"TOTAL NON-UTILITY\", 'June 2011'!M:M)/1000","v":224.339},null,{"$f":"SUMIF('June 2011'!$A:$A, \"TOTAL NON-UTILITY\", 'June 2011'!L:N)/1000","v":0},-224.339]
["Total Capital",null,null,null,{"$f":"(E18+E23+E29+E30)","v":183053.91272000002},null,{"$f":"(G18+G23+G29+G30)","v":204742.46099999998},null,{"$f":"(E31-G31)","v":-21688.548279999959},{"$f":"IF(G31=0,IF(E31>0,100,IF(E31=0,0,-100)),(I31/G31)*100)","v":-10.593087615567912},null,{"$f":"(L18+L23+L29+L30)","v":384566.59899999999},null,{"$f":"(N18+N23+N29+N30)","v":0},-384566.59899999999]
[null,null,null,null,{"$f":"ROUND(E31-'June 2011'!F345/1000,0)","v":0},null,{"$f":"ROUND(G31-'June 2011'!G345/1000,0)","v":0},null,{"$f":"ROUND(I31-'June 2011'!H345/1000, 0)","v":0},null,null,{"$f":"ROUND(L31-'June 2011'!M345/1000,0)","v":0},null,{"$f":"N31-'June 2011'!L345/1000","v":0},{"$f":"O31-'June 2011'!N345/1000","v":0}]
[]
[]
[]
[null,null,null,null,null,"       January Year-to-date"]
[null,null,null,null,null,null,null,null,null,"Original ","Year-end"]
[null,null,null,null,"Actual",null,"Budget",null,"Variance","Budget","Variance"]
["Power Generation:"]
["Environmental",null,null,null,{"$f":"E11","v":77610.625220000031},null,{"$f":"G11","v":86288.225000000006},null,{"$f":"E40-G40","v":-8677.599779999975},{"$f":"'June 2011'!M46/1000","v":176126.58100000001},{"$f":"O11","v":-176126.58100000001}]
["Fossil Steam, CT & Other",null,null,null,{"$f":"E14+E13","v":38729.097679999999},null,{"$f":"G14+G13","v":37932.934999999998},null,{"$f":"E41-G41","v":796.16268000000127},{"$f":"SUM('June 2011'!M167+'June 2011'!M173)/1000","v":69288.714999999997},{"$f":"O13+O14","v":-69288.714999999997}]
["Total Power Generation",null,null,null,{"$f":"E40+E41","v":116339.72290000002},null,{"$f":"G40+G41","v":124221.16},null,{"$f":"I40+I41","v":-7881.4370999999737},{"$f":"SUM(J40:J41)","v":245415.296},{"$f":"K40+K41","v":-245415.296}]
["Power Delivery:"]
["Transmission",null,null,null,{"$f":"E20","v":30048.01067},null,{"$f":"G20","v":37963.983999999997},null,{"$f":"E44-G44","v":-7915.9733299999971},{"$f":"'June 2011'!M235/1000","v":56402.921000000002},{"$f":"O20","v":-56402.921000000002}]
["   Lighting & AEM",null,null,null,{"$f":"('June 2011'!F185+'June 2011'!F186+'June 2011'!F187)/1000","v":1770.91877},null,{"$f":"('June 2011'!G185+'June 2011'!G186+'June 2011'!G187)/1000","v":2273.2510000000002},null,-502.33223000000021,{"$f":"SUM('June 2011'!M185+'June 2011'!M186+'June 2011'!M187)/1000","v":4514.393},{"$f":"('June 2011'!N185+'June 2011'!N186+'June 2011'!N187)/1000","v":-4514.393}]
["   AMI",null,null,null,{"$f":"'June 2011'!F192/1000","v":8387.7344300000004},null,{"$f":"'June 2011'!G192/1000","v":7214},null,1173.7344300000004,{"$f":"'June 2011'!M192/1000","v":15826},{"$f":"'June 2011'!N192/1000","v":-15826}]
["   Transformers",null,null,null,{"$f":"'June 2011'!F189/1000","v":3393.0918300000003},null,{"$f":"'June 2011'!G189/1000","v":3087},null,306.0918300000003,{"$f":"'June 2011'!M189/1000","v":6000},{"$f":"'June 2011'!N189/1000","v":-6000}]
["   NB - UG",null,null,null,{"$f":"'June 2011'!F191/1000","v":1772.5571200000002},null,{"$f":"'June 2011'!G191/1000","v":3327},null,-1554.4428799999998,{"$f":"'June 2011'!M191/1000","v":6674},{"$f":"'June 2011'!N191/1000","v":-6674}]
["   NB - Other",null,null,null,{"$f":"E50-SUM(E45:E48)","v":2273.1417200000014},null,{"$f":"G50-SUM(G45:G48)","v":3325},null,-1051.8582799999986,{"$f":"J50-SUM(J45:J48)","v":6278},{"$f":"K50-SUM(K45:K48)","v":-6278},"NB (OH) & Meters "]
["New Business Distribution",null,null,null,{"$f":"'June 2011'!F195/1000","v":17597.443870000003},null,{"$f":"'June 2011'!G195/1000","v":19226.251},null,-1628.8071299999974,{"$f":"'June 2011'!M195/1000","v":39292.392999999996},{"$f":"'June 2011'!N195/1000","v":-39292.392999999996}]
["Other Distribution",null,null,null,{"$f":"E21-E50","v":14473.646830000002},null,{"$f":"G21-G50","v":17623.999999999996},null,-3150.3531699999949,{"$f":"'June 2011'!M278/1000","v":29785},{"$f":"O21-K50","v":-29785}]
["Joint Sub. & Dist. Lines",null,null,null,{"$f":"E22","v":1238.5275100000001},null,{"$f":"G22","v":779},null,459.52751000000012,{"$f":"'June 2011'!M294/1000","v":1611},{"$f":"O22","v":-1611}]
["Total Power Delivery",null,null,null,{"$f":"E44+E50+E51+E52","v":63357.628880000004},null,{"$f":"G44+G50+G51+G52","v":75593.235000000001},null,-12235.606119999997,{"$f":"J44+J50+J51+J52","v":127091.314},{"$f":"K44+K50+K51+K52","v":-127091.314}]
["Total General & Other",null,null,null,{"$f":"E30+E29","v":3356.5609400000003},null,{"$f":"G30+G29","v":4928.0659999999998},null,-1571.5050599999995,{"$f":"SUM('June 2011'!M337+'June 2011'!M342)/1000","v":12059.989},{"$f":"O30+O29","v":-12059.989}]
["Total Capital",null,null,null,{"$f":"E42+E53+E54","v":183053.91272000002},null,{"$f":"G42+G53+G54","v":204742.46100000001},null,-21688.548279999988,{"$f":"J42+J53+J54","v":384566.59899999999},{"$f":"K42+K53+K54","v":-384566.59899999999}]
[]
[]
[null,null,null,null,null,"        January Year-to-date"]
[null,null,null,null,null,null,null,null,null,"Original ","Year-end"]
[null,null,null,null,"Actual",null,"Budget",null,"Variance","Budget","Variance"]
["Other Environmental:"]
["  Crist Scrubber",null,null,null,{"$f":"'June 2011'!F24/1000","v":453.66472999999996},null,{"$f":"'June 2011'!G24/1000","v":0},null,{"$f":"E62-G62","v":453.66472999999996},{"$f":"'June 2011'!M25/1000","v":0},{"$f":"'June 2011'!N25/1000","v":0}]
["  Crist 6 SCR",null,null,null,{"$f":"'June 2011'!F25/1000","v":243.09663},null,{"$f":"'June 2011'!G25/1000","v":0},null,{"$f":"E63-G63","v":243.09663},{"$f":"'June 2011'!M26/1000","v":81940.188999999998},{"$f":"'June 2011'!N26/1000","v":-81940.188999999998}]
["  Crist Water Conservation",null,null,null,{"$f":"'June 2011'!F30/1000","v":0},null,{"$f":"'June 2011'!G30/1000","v":1375.3009999999999},null,{"$f":"E64-G64","v":-1375.3009999999999},{"$f":"'June 2011'!M30/1000","v":7036.4560000000001},{"$f":"'June 2011'!N30/1000","v":-7036.4560000000001}]
["  Scherer SCR",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Scherer Scrubber",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Scherer Baghouse",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Scherer Other Envion.",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Other",null,null,null,{"$f":"E40-SUM(E62:E68)","v":{"$error":"#REF!"}},null,{"$f":"G40-SUM(G62:G68)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"J40-SUM(J62:J68)","v":{"$error":"#REF!"}},{"$f":"K40-SUM(K62:K68)","v":{"$error":"#REF!"}}]
["Total Other Environmental",null,null,null,{"$f":"SUM(E62:E69)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G62:G69)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I62:I69)","v":{"$error":"#REF!"}},{"$f":"SUM(J62:J69)","v":{"$error":"#REF!"}},{"$f":"SUM(K62:K69)","v":{"$error":"#REF!"}}]
[]
["Fossil Steam, CT & Other:"]
["  Scherer Misc Additions",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"E73-G73","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Smith LTSA",null,null,null,{"$f":"'June 2011'!F117/1000","v":5369.2639200000003},null,{"$f":"'June 2011'!G117/1000","v":2613.0720000000001},null,{"$f":"E74-G74","v":2756.1919200000002},{"$f":"'June 2011'!M117/1000","v":5228.2330000000002},{"$f":"'June 2011'!M117/1000","v":5228.2330000000002}]
["  Perdido Landfill ",null,null,null,{"$f":"'June 2011'!F171/1000","v":0},null,{"$f":"'June 2011'!G171/1000","v":60},null,{"$f":"E75-G75","v":-60},{"$f":"'June 2011'!M171/1000","v":120},-2753.4639999999999]
["  Other ",null,null,null,{"$f":"E41-SUM(E73:E75)","v":{"$error":"#REF!"}},null,{"$f":"G41-SUM(G73:G75)","v":{"$error":"#REF!"}},null,{"$f":"E76-G76","v":{"$error":"#REF!"}},{"$f":"J41-SUM(J73:J75)","v":{"$error":"#REF!"}},{"$f":"K41-SUM(K73:K75)","v":{"$error":"#REF!"}}]
["Total Fossile Steam, CT & Other",null,null,null,{"$f":"SUM(E73:E76)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G73:G76)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I73:I76)","v":{"$error":"#REF!"}},{"$f":"SUM(J73:J76)","v":{"$error":"#REF!"}},{"$f":"SUM(K73:K76)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"January Year-to-Date"]
[null,null,null,null,null,null,null,null,null,"Original ","Year-end"]
[null,null,null,null,"Actual",null,"Budget",null,"Variance","Budget","Variance"]
["Transmission:"]
["  Trans. Sub Infrastructure",null,null,null,{"$f":"('June 2011'!F198+'June 2011'!F199)/1000","v":3221.7956600000002},null,{"$f":"('June 2011'!G198+'June 2011'!G199)/1000","v":1790},null,{"$f":"E84-G84","v":1431.7956600000002},{"$f":"SUM('June 2011'!M198+'June 2011'!M199)/1000","v":3650},{"$f":"('June 2011'!N198+'June 2011'!N199)/1000","v":-3650}]
["  Shoal River 115KV",null,null,null,{"$f":"'June 2011'!F205/1000","v":103.18674},null,{"$f":"'June 2011'!G205/1000","v":0},null,103.18674,{"$f":"'June 2011'!M205/1000","v":0},{"$f":"'June 2011'!N205/1000","v":0}]
["  Devillers-Goulding 115KV",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Lullwater LB 115KV Rec.",null,null,null,{"$f":"'June 2011'!F215/1000","v":3678.51872},null,{"$f":"'June 2011'!G215/1000","v":4400},null,-721.48127999999997,{"$f":"'June 2011'!M215/1000","v":4900},{"$f":"'June 2011'!N215/1000","v":-4900}]
["  Transm ROW Clearing",null,null,null,{"$f":"'June 2011'!F219/1000","v":921.20428000000004},null,{"$f":"'June 2011'!G219/1000","v":1815.3109999999999},null,-894.10671999999988,{"$f":"'June 2011'!M219/1000","v":3180.0039999999999},{"$f":"'June 2011'!N219/1000","v":-3180.0039999999999}]
["  Brentwood-Bayou Chico 115KV",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Other ",null,null,null,{"$f":"E44-SUM(E84:E89)","v":{"$error":"#REF!"}},null,{"$f":"G44-SUM(G84:G89)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"J44-SUM(J84:J89)","v":{"$error":"#REF!"}},{"$f":"K44-SUM(K84:K89)","v":{"$error":"#REF!"}}]
["Total Transmission",null,null,null,{"$f":"SUM(E84:E90)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G84:G90)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I84:I90)","v":{"$error":"#REF!"}},{"$f":"SUM(J84:J90)","v":{"$error":"#REF!"}},{"$f":"SUM(K84:K90)","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,null,null,null,"January Year-to-Date"]
[null,null,null,null,null,null,null,null,null,"Original ","Year-end"]
[null,null,null,null,"Actual",null,"Budget",null,"Variance","Budget","Variance"]
["New Business Distribution:"]
["   Lighting & AEM",null,null,null,{"$f":"E45","v":1770.91877},null,{"$f":"G45","v":2273.2510000000002},null,{"$f":"I45","v":-502.33223000000021},4514.393,-4514.393]
["   AMI",null,null,null,{"$f":"E46","v":8387.7344300000004},null,7214,null,1173.7344300000004,15826,-15826]
["   Transformers",null,null,null,3393.0918300000003,null,3087,null,306.0918300000003,6000,-6000]
["   NB - UG",null,null,null,1772.5571200000002,null,3327,null,-1554.4428799999998,6674,-6674]
["   NB - Other",null,null,null,2273.1417200000014,null,3325,null,-1051.8582799999986,6278,-6278]
["Total NB Distribution",null,null,null,{"$f":"SUM(E99:E103)","v":17597.443870000003},null,{"$f":"SUM(G99:G103)","v":19226.251},null,{"$f":"SUM(I99:I103)","v":-1628.8071299999979},{"$f":"SUM(J99:J103)","v":39292.392999999996},{"$f":"SUM(K99:K103)","v":-39292.392999999996}]
[]
["Distribution (Non-NB):"]
["  Misc Distribution Improvement",null,null,null,{"$f":"('June 2011'!F238+'June 2011'!F239+'June 2011'!F240)/1000","v":2990.0484200000001},null,{"$f":"('June 2011'!G238+'June 2011'!G239+'June 2011'!G240)/1000","v":1954},null,{"$f":"E107-G107","v":1036.0484200000001},{"$f":"SUM('June 2011'!M238+'June 2011'!M239+'June 2011'!M240)/1000","v":4661},{"$f":"('June 2011'!N238+'June 2011'!N239+'June 2011'!N240)/1000","v":-4661}]
["  Distribution Line Minor Proj.",null,null,null,{"$f":"'June 2011'!F241/1000","v":289.62205},null,{"$f":"'June 2011'!G241/1000","v":378},null,-88.377949999999998,{"$f":"'June 2011'!M241/1000","v":1108},{"$f":"'June 2011'!N241/1000","v":-1108}]
["  Underground System Adds.",null,null,null,{"$f":"('June 2011'!F242+'June 2011'!F243)/1000","v":1425.9562700000001},null,{"$f":"('June 2011'!G242+'June 2011'!G243)/1000","v":996},null,429.95627000000013,{"$f":"SUM('June 2011'!M242+'June 2011'!M243)/1000","v":2925},{"$f":"('June 2011'!N242+'June 2011'!N243)/1000","v":-2925}]
["  Lullwater 115KV Capbank",null,null,null,{"$f":"'June 2011'!F255/1000","v":-77.45926},null,{"$f":"'June 2011'!G255/1000","v":0},null,-77.45926,{"$f":"'June 2011'!M255/1000","v":0},{"$f":"'June 2011'!N255/1000","v":0}]
["  West Perdido Key Enh.",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Storm Support - UG",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Storm Hardening",null,null,null,{"$f":"('June 2011'!#REF!+'June 2011'!#REF!)/1000","v":{"$error":"#REF!"}},null,{"$f":"('June 2011'!#REF!+'June 2011'!#REF!)/1000","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"SUM('June 2011'!#REF!+'June 2011'!#REF!)/1000","v":{"$error":"#REF!"}},{"$f":"('June 2011'!#REF!+'June 2011'!#REF!)/1000","v":{"$error":"#REF!"}}]
["  Devillers Sub",null,null,null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}},null,{"$f":"E114-G114","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!","v":{"$error":"#REF!"}},{"$f":"'June 2011'!#REF!/1000","v":{"$error":"#REF!"}}]
["  Other ",null,null,null,{"$f":"E51-SUM(E107:E114)","v":{"$error":"#REF!"}},null,{"$f":"G51-SUM(G107:G114)","v":{"$error":"#REF!"}},null,{"$f":"E115-G115","v":{"$error":"#REF!"}},{"$f":"J51-SUM(J107:J114)","v":{"$error":"#REF!"}},{"$f":"K51-SUM(K107:K114)","v":{"$error":"#REF!"}}]
["Total  Distribution (Non-NB)",null,null,null,{"$f":"SUM(E107:E115)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G107:G115)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I107:I115)","v":{"$error":"#REF!"}},{"$f":"SUM(J107:J115)","v":{"$error":"#REF!"}},{"$f":"SUM(K107:K115)","v":{"$error":"#REF!"}}]

{"sheet":"FINPLAN","index":5,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,0,0,14],[1,0,1,14]]}
["Capital Expenditures  -- Gulf Power Company"]
["(Thousands of Dollars)"]
["Non-SWE"]
["SWE Retail     SWE Wholesale     ",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Current Year"]
["1) Generation"]
["  New Regulated  F/H Generation",null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C6:N6)","v":0}]
["  New Unregulated F/H Generation (SWE Wholesale)",null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C7:N7)","v":0}]
["  New Unregulated F/H Generation (SWE Retail)",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
["        Total New Generation",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
["  Regulated F/H Generation: Retrofits",null,{"$f":"'June 2011'!F167/1000","v":38728.06265},null,null,null,null,null,null,null,null,null,null,null,38728.06265]
["  Nuclear Generation: Retrofits",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
["        Total Generation: Retrofits",null,{"$f":"SUM(C10:C11)","v":38728.06265},null,null,null,null,null,null,null,null,null,null,null,38728.06265]
["  Regulated Generation: Environmental",null,{"$f":"'June 2011'!F46/1000","v":77610.625220000031},null,null,null,null,null,null,null,null,null,null,null,77610.625220000031]
["Total  Generation",null,{"$f":"C9+C12+C13","v":116338.68787000002},{"$f":"D9+D12+D13","v":0},0,0,0,0,0,0,0,0,0,0,116338.68787000002]
[]
["2) Nuclear Fuel"]
["  Farley",null,0]
["  Hatch",null,0]
["  Vogle",null,0]
["Total Nuclear Fuel",null,{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["3) Transmission"]
["  New Generation Connections",null,0]
["  Other",null,{"$f":"('June 2011'!F235+'June 2011'!F294)/1000+SUMIF('June 2011'!C:C, 4321, 'June 2011'!F:F)/1000","v":31286.53818}]
["Total Transmission",null,{"$f":"C23+C24","v":31286.53818},{"$f":"D23+D24","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["4) Distribution"]
["  New Business",null,{"$f":"+SUMIF('June 2011'!C:C, 2558, 'June 2011'!F:F)/1000+SUMIF('June 2011'!C:C, 2560, 'June 2011'!F:F)/1000","v":835.91849000000002}]
["  Other",null,{"$f":"('June 2011'!F195+'June 2011'!F278)/1000-C28","v":31235.172210000004}]
["Total  Distribution",null,{"$f":"C29+C28","v":32071.090700000004},{"$f":"D29+D28","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["5) General Plant & Miscellaneous"]
["  Buildings",null,{"$f":"'June 2011'!F322/1000","v":559.42654000000005}]
["  Fleet",null,{"$f":"'June 2011'!F302/1000","v":381.60199}]
["  Telecommunications",null,{"$f":"'June 2011'!F310/1000","v":267.14312000000001}]
["  Other ",null,{"$f":"('June 2011'!F334+'June 2011'!#REF!+'June 2011'!F342)/1000-SUMIF('June 2011'!C:C, 4321, 'June 2011'!F:F)/1000","v":{"$error":"#REF!"}}]
["Total General Plant & Miscellaneous",null,{"$f":"SUM(C33:C36)","v":{"$error":"#REF!"}},{"$f":"SUM(D33:D36)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Unallocated Changes to Capital  **",null,0]
[]
["Latest Projection (Sum Above)",null,{"$f":"C14+C20+C25+C30+C37+C39","v":{"$error":"#REF!"}},{"$f":"D14+D20+D25+D30+D37+D39","v":0},0,0,0,0,0,0,0,0,0,0,116338.68787000002]
["      Official Budget",null,31175.061000000002,null,null,null,null,null,null,null,null,null,null,null,277958]
["Difference",null,{"$f":"C41-C42","v":{"$error":"#REF!"}},{"$f":"D41-D42","v":0},0,0,0,0,0,0,0,0,0,0,-161619.31212999998]
[]
["Total from Capital Expenditures Report",null,{"$f":"'June 2011'!F345/1000","v":183053.91272000002}]
["Variance",null,{"$f":"C45-C41","v":{"$error":"#REF!"}}]

{"sheet":"Variance Explanation ","index":6,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9]]}
["Gulf Power Company"]
[{"$f":"Summary!A2","v":"2011-06-30"}]
["YTD / Proforma Capital Variance Explanation"]
["Thousands of Dollars"]
[]
[]
["Business Unit","YTD Variance Amount",null,"Variance Sign","Variance Rank","Variance Amount","PE","Variance Explanation",null,"Estimated\nYear-End\nVariance",null,"Year End Variance","Summarized Explanation","Budget Coordinator's Explanation"]
[]
["Power Generation:",null,null,null,null,"Power Generation (Environmental)"]
[null,null,null,"Positive",2,{"$f":"IF($D10 = \"Positive\", LARGE(YTD_Variance_Environmental, $E10), SMALL(YTD_Variance_Environmental, $E10))/1000","v":1974.22515},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F10*1000, YTD_Variance_Environmental, 0), 1)","v":"1551"},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F10*1000, YTD_Variance_Environmental, 0), 2) & \" - \" & IF(ISBLANK($M10), IF($N10 = 0, \"\", $N10), $M10)","v":"ECRC-AIR-DANIEL 1 & 2 SCRUBBER - "},null,null,null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F10*1000, YTD_Variance_Environmental, 0), 12)/1000","v":-20042.892},null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F10*1000, YTD_Variance_Environmental, 0), 9)","v":0}]
[null,null,null,"Negative",1,{"$f":"IF($D11 = \"Positive\", LARGE(YTD_Variance_Environmental, $E11), SMALL(YTD_Variance_Environmental, $E11))/1000","v":-10473.721},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F11*1000, YTD_Variance_Environmental, 0), 1)","v":"1552"},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F11*1000, YTD_Variance_Environmental, 0), 2) & \" - \" & IF(ISBLANK($M11), IF($N11 = 0, \"\", $N11), $M11)","v":"ECRC-AIR-DANIEL 2 SCRUBBER - "},null,null,null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F11*1000, YTD_Variance_Environmental, 0), 12)/1000","v":-20100.432000000001},null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F11*1000, YTD_Variance_Environmental, 0), 9)","v":0}]
[null,null,null,"Negative",4,{"$f":"IF($D12 = \"Positive\", LARGE(YTD_Variance_Environmental, $E12), SMALL(YTD_Variance_Environmental, $E12))/1000","v":-1375.3009999999999},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F12*1000, YTD_Variance_Environmental, 0), 1)","v":"1502"},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F12*1000, YTD_Variance_Environmental, 0), 2) & \" - \" & IF(ISBLANK($M12), IF($N12 = 0, \"\", $N12), $M12)","v":"ECRC DANIEL SCRUBBER COMMON - "},null,null,null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F12*1000, YTD_Variance_Environmental, 0), 12)/1000","v":-7036.4560000000001},null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F12*1000, YTD_Variance_Environmental, 0), 9)","v":0}]
["New Generation Projects",{"$f":"Summary!I10","v":0},null,null,null,{"$f":"SUM(F$10:F$12)","v":-9874.7968499999988},null,"Net Variance - ECRC Daniel Scrubber PE's",null,{"$f":"Summary!O10","v":0}]
["Environmental",{"$f":"Summary!I11","v":-8677.599779999975},"*","Positive",1,{"$f":"IF($D14 = \"Positive\", LARGE(YTD_Variance_Environmental, $E14), SMALL(YTD_Variance_Environmental, $E14))/1000","v":4580.3284400000002},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F14*1000, YTD_Variance_Environmental, 0), 1)","v":"1279"},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F14*1000, YTD_Variance_Environmental, 0), 2) & \" - \" & IF(ISBLANK($M14), IF($N14 = 0, \"\", $N14), $M14)","v":"ECRC-AIR-CRIST 6 SCR - "},null,{"$f":"Summary!O11","v":-176126.58100000001},null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F14*1000, YTD_Variance_Environmental, 0), 12)/1000","v":-81940.188999999998},null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F14*1000, YTD_Variance_Environmental, 0), 9)","v":0}]
["Production Modifications",{"$f":"Summary!I12","v":0},null,"Negative",5,{"$f":"IF($D15 = \"Positive\", LARGE(YTD_Variance_Environmental, $E15), SMALL(YTD_Variance_Environmental, $E15))/1000","v":-1285.21227},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F15*1000, YTD_Variance_Environmental, 0), 1)","v":"1727"},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F15*1000, YTD_Variance_Environmental, 0), 2) & \" - \" & IF(ISBLANK($M15), IF($N15 = 0, \"\", $N15), $M15)","v":"ENVIR-AIR-SCHERER SELECTIVE CATALYTIC REDUCT (SCR) - "},null,{"$f":"Summary!O12","v":0},null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F15*1000, YTD_Variance_Environmental, 0), 12)/1000","v":-3051.9349999999999},null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F15*1000, YTD_Variance_Environmental, 0), 9)","v":0}]
["Fossil Steam & CT",{"$f":"Summary!I13","v":855.12765000000218},"*","Negative",3,{"$f":"IF($D16 = \"Positive\", LARGE(YTD_Variance_Environmental, $E16), SMALL(YTD_Variance_Environmental, $E16))/1000","v":-2514.2860000000001},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F16*1000, YTD_Variance_Environmental, 0), 1)","v":"1601"},{"$f":"INDEX(ENVIRONMENTAL, MATCH($F16*1000, YTD_Variance_Environmental, 0), 2) & \" - \" & IF(ISBLANK($M16), IF($N16 = 0, \"\", $N16), $M16)","v":"ECRC-WATER-SMITH RECLAIMED WATER PROJECT UNIT 3 - "},null,{"$f":"Summary!O13","v":-69168.714999999997},null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F16*1000, YTD_Variance_Environmental, 0), 12)/1000","v":-6000},null,{"$f":"INDEX(ENVIRONMENTAL, MATCH(F16*1000, YTD_Variance_Environmental, 0), 9)","v":0}]
["Renewables",{"$f":"Summary!I14","v":-58.964970000000001},null,null,{"$f":"F17-$B$14","v":-416.36690000002272},{"$f":"SUM(F13:F16)","v":-9093.9666799999977},null,null,null,{"$f":"Summary!O14","v":-120}]
["Hydro",{"$f":"Summary!I15","v":0},null,null,null,null,null,null,null,{"$f":"Summary!O15","v":0}]
["Nuclear",{"$f":"Summary!I16","v":0},null,null,null,"Power Generation (Fossil Steam & CT & Renewables)",null,null,null,{"$f":"Summary!O16","v":0}]
["Nuclear Fuel",{"$f":"Summary!I17","v":0},null,"Positive",1,{"$f":"IF($D20 = \"Positive\", LARGE(YTD_Variance_Fossil, $E20), SMALL(YTD_Variance_Fossil, $E20))/1000","v":3015.6571600000002},{"$f":"INDEX(FOSSIL, MATCH($F20*1000, YTD_Variance_Fossil, 0), 1)","v":"1230"},{"$f":"INDEX(FOSSIL, MATCH($F20*1000, YTD_Variance_Fossil, 0), 2) & \" - \" & IF(ISBLANK($M20), IF($N20 = 0, \"\", $N20), $M20)","v":"CRIST 6 REPL REHEATER - "},null,{"$f":"Summary!O17","v":0},null,{"$f":"INDEX(FOSSIL, MATCH(F20*1000, YTD_Variance_Fossil, 0), 12)/1000","v":-3500},null,{"$f":"INDEX(FOSSIL, MATCH(F20*1000, YTD_Variance_Fossil, 0), 9)","v":0}]
["Total Power Generation",{"$f":"SUM(B13:B20)","v":-7881.4370999999728},null,"Positive",2,2756.1919199999998,"1532","DANIEL 2 HP/IP TURBINE UPGRADE - ",null,{"$f":"SUM(J13:J20)","v":-245415.296},null,-5228.2330000000002,null,0]
[null,null,null,"Positive",3,1881.5923400000001,"1421","SMITH - UNIT A COMBUSTION TURBINE CONTROLS REPLACEMENT - ",null,null,null,0,null,0]
[null,null,null,"Positive",4,1619.9152799999999,"1700","SCHERER-MISC. ADDITIONS & IMPROVEMENTS - ",null,null,null,{"$f":"INDEX(FOSSIL, MATCH(F23*1000, YTD_Variance_Fossil, 0), 12)/1000","v":0},null,{"$f":"INDEX(FOSSIL, MATCH(F23*1000, YTD_Variance_Fossil, 0), 9)","v":0}]
[null,null,null,"Negative",4,-980.47516000000007,"1262","CRIST UNIT 6 HOT REHEAT PIPING - ",null,null,null,-2000,null,0]
[null,null,null,"Negative",3,-1500,"1424","SMITH 3 - TURBINE CONTROLS REPLACEMENT - ",null,null,null,-1500,null,0]
[null,null,null,"Negative",2,-2302.6105600000001,"1842","DANIEL 1 GSU TRANSFORMER - ",null,null,null,-5005.3940000000002,null,0]
["Power Delivery:",null,null,"Negative",1,-2798.2688499999999,"1094","CRIST FUEL HANDLING CRANE - ",null,null,null,-7327.6030000000001,null,0]
["Transmission",{"$f":"Summary!I20","v":-7915.9733299999971},null,null,{"$f":"F28-$B$16+$B$17","v":777.90950999999814},{"$f":"SUM(F20:F27)","v":1692.0021300000003},null,null,null,{"$f":"Summary!O20","v":-56402.921000000002}]
["Distribution",{"$f":"Summary!I21","v":-4779.1602999999923},null,null,null,null,null,null,null,{"$f":"Summary!O21","v":-69077.392999999996}]
["Joint Sub. & Dist. Lines",{"$f":"Summary!I22","v":459.52751000000012},null,null,null,"Power Delivery",null,null,null,{"$f":"Summary!O22","v":-1611}]
["Total Power Delivery",{"$f":"SUM(B28:B30)","v":-12235.606119999989},"*","Positive",1,{"$f":"IF($D31 = \"Positive\", LARGE(YTD_Variance_Power_Delivery, $E31), SMALL(YTD_Variance_Power_Delivery, $E31))/1000","v":1903.2281699999999},{"$f":"INDEX(POWER_DELIVERY, MATCH($F31*1000, YTD_Variance_Power_Delivery, 0), 1)","v":"2802"},{"$f":"INDEX(POWER_DELIVERY, MATCH($F31*1000, YTD_Variance_Power_Delivery, 0), 2) & \" - \" & IF(ISBLANK($M31), IF($N31 = 0, \"\", $N31), $M31)","v":"TRANS LINE INFRASTRUCTURE PROJECT - "},null,{"$f":"SUM(J28:J30)","v":-127091.314},null,{"$f":"INDEX(POWER_DELIVERY, MATCH(F31*1000, YTD_Variance_Power_Delivery, 0), 12)/1000","v":-3000},null,{"$f":"INDEX(POWER_DELIVERY, MATCH(F31*1000, YTD_Variance_Power_Delivery, 0), 9)","v":0}]
[null,null,null,"Negative",14,-721.48128000000008,"2853","LAGUNA BEACH 230-115KV AUTOBANK - ",null,null,null,-4900,null,0]
[null,null,null,"Negative",13,-736.98931999999991,"2861","LAGUNA SANTA ROSA 115KV REPLACE INSULATORS - ",null,null,null,-1492.5,null,0]
[null,null,null,"Negative",12,-883.79502000000002,"3407","MISC CAPITAL ACCRUALS - ",null,null,null,0,null,0]
[null,null,null,"Negative",11,-894.10672,"2867","HOLMES CREEK-HIGHLAND CITY NEW 230KV TL - ",null,null,null,-3180.0039999999999,null,0]
[null,null,null,"Negative",10,-934.20740999999998,"3483","GOULDING PROT & CONTROL SYS REPL - ",null,null,null,-1235,null,0]
[null,null,null,"Negative",9,-953.72073999999998,"2552","NEW BUSINESS DISTRIBUTION - ",null,null,null,-5281,null,0]
[null,null,null,"Negative",8,-1073.6982700000001,"3491","HENDERSON PARK SUB 115/12 KV NEW SUB AND FEEDER - ",null,null,null,-3105,null,0]
[null,null,null,"Negative",7,-1554.4428799999998,"2554","NEW BUSINESS - UNDERGROUND - ",null,null,null,-6674,null,0]
[null,null,null,"Negative",5,-2324.2380200000002,"2888","SINAI - CALLAWAY 115KV TL RECONDUCTOR - ",null,null,null,-7235,null,0]
[null,null,null,"Negative",3,-4483.6259900000005,"2892","CRIST FILTERED CAPBANK - ",null,null,null,-4900,null,0]
["General Plant:",null,null,null,{"$f":"F42-$B$31","v":-421.47136000001046},{"$f":"SUM(F31:F41)","v":-12657.07748}]
[]
[null,null,null,null,null,"General Plant and Other"]
[null,null,null,"Negative",4,{"$f":"IF($D45 = \"Positive\", LARGE(YTD_Variance_General_Plant, $E45), SMALL(YTD_Variance_General_Plant, $E45))/1000","v":-455.27596999999997},{"$f":"INDEX(TOTAL_GENERAL_PLANT, MATCH($F45*1000, YTD_Variance_General_Plant, 0), 1)","v":"4310"},{"$f":"INDEX(TOTAL_GENERAL_PLANT, MATCH($F45*1000, YTD_Variance_General_Plant, 0), 2) & \" - \" & IF(ISBLANK($M45), IF($N45 = 0, \"\", $N45), $M45)","v":"VOICE & DATA CONVERGED NETWORK - "},null,null,null,{"$f":"INDEX(TOTAL_GENERAL_PLANT, MATCH(F45*1000, YTD_Variance_General_Plant, 0), 12)/1000","v":-890},null,{"$f":"INDEX(TOTAL_GENERAL_PLANT, MATCH(F45*1000, YTD_Variance_General_Plant, 0), 9)","v":0}]
[null,null,null,"Negative",2,{"$f":"IF($D46 = \"Positive\", LARGE(YTD_Variance_General_Plant, $E46), SMALL(YTD_Variance_General_Plant, $E46))/1000","v":-893.58190999999999},{"$f":"INDEX(TOTAL_GENERAL_PLANT, MATCH($F46*1000, YTD_Variance_General_Plant, 0), 1)","v":"4376"},{"$f":"INDEX(TOTAL_GENERAL_PLANT, MATCH($F46*1000, YTD_Variance_General_Plant, 0), 2) & \" - \" & IF(ISBLANK($M46), IF($N46 = 0, \"\", $N46), $M46)","v":"GLSCAPE AND MRO - "},null,null,null,{"$f":"INDEX(TOTAL_GENERAL_PLANT, MATCH(F46*1000, YTD_Variance_General_Plant, 0), 12)/1000","v":-4022.6320000000001},null,{"$f":"INDEX(TOTAL_GENERAL_PLANT, MATCH(F46*1000, YTD_Variance_General_Plant, 0), 9)","v":0}]
["Fleet",{"$f":"Summary!I25","v":-418.39801},null,null,{"$f":"F47-$B$51+$B$54","v":209.05847999999958},{"$f":"SUM(F45:F46)","v":-1348.85788},null,null,null,{"$f":"Summary!O25","v":-1700}]
["Telecommunications",{"$f":"Summary!I26","v":-667.75687999999991},null,null,null,null,null,null,null,{"$f":"Summary!O26","v":-1717.9}]
["Corporate Services",{"$f":"Summary!I27","v":-158.01145999999994},null,null,null,null,null,null,null,{"$f":"Summary!O27","v":-3563.1179999999999}]
["Other",{"$f":"Summary!I28","v":-320.54435999999987},null,null,null,null,null,null,null,{"$f":"Summary!O28","v":-4854.6319999999996}]
["Total General",{"$f":"SUM(B47:B50)","v":-1564.7107099999996},"*",null,null,null,null,null,null,{"$f":"SUM(J47:J50)","v":-11835.65}]
[]
[]
["Other",{"$f":"Summary!I30","v":-6.7943500000000085},"*",null,null,null,null,null,null,{"$f":"Summary!O30","v":-224.339}]
[]
[]
["Total Capital",{"$f":"B21+B31+B51+B54","v":-21688.548279999963},null,null,null,null,null,null,null,{"$f":"J21+J31+J51+J54","v":-384566.59899999999}]
[null,{"$f":"ROUND(B57-Summary!I31,0)","v":0},null,null,null,null,null,null,null,{"$f":"J57-'June 2011'!N345/1000","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]