Copy of Section J Attachment 2.xlsx

XLSX spreadsheet 42 KB Posted Apr 1, 2021

Attached to: Delivery of Firm Load Following Electric Supply Service
Solicitation number: 697DCK-21-R-00174
Issued by: Department of Transportation Federal Aviation Administration Southern Region

View the file

Other files

File	Type	Posted
Responses to Questions SIR 697DCK-21-R-00174.pdf	PDF	Apr 22, 2021
Section J Attachment 1.xlsx	XLSX spreadsheet	Apr 2, 2021
697DCK-21-R-00174 SF-33.pdf	PDF	Apr 1, 2021
Section J Attachment 1.pdf	PDF	Apr 1, 2021
697DCK-21-R-00174SIR.pdf	PDF	Apr 1, 2021

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Hourly Metered kWh

Sample Invoice Data

Section J - Attachment 2

Federal Aviation Administration

William J. Hughes Technical Center

Projected Hourly Metered Data to be used for sample invoices- kWh

Date	1:00	2:00	3:00	4:00	5:00	6:00	7:00	8:00	9:00	10:00	11:00	12:00	13:00	14:00	15:00	16:00	17:00	18:00	19:00	20:00	21:00	22:00	23:00	24:00
1/1/21	8,829.100	8,818.000	8,842.600	8,908.950	8,963.600	8,998.300	9,020.000	8,949.300	8,870.550	8,798.400	8,736.800	8,682.700	8,651.200	8,626.800	8,629.250	8,632.150	8,732.000	8,777.650	8,768.450	8,764.150	8,701.850	8,678.300	8,622.350	8,602.550
1/2/21	8,586.200	8,586.000	8,609.600	8,584.300	8,592.150	8,600.800	8,628.150	8,573.800	8,485.050	8,428.000	8,369.000	8,341.900	8,334.650	8,303.350	8,287.400	8,293.100	8,389.850	8,588.800	8,578.600	8,600.500	8,611.950	8,638.300	8,622.750	8,647.850
1/3/21	8,686.150	8,747.600	8,763.500	8,737.700	8,777.950	8,789.850	8,770.150	8,733.350	8,650.100	8,558.800	8,505.300	8,465.350	8,451.800	8,407.900	8,448.100	8,534.650	8,581.600	8,660.150	8,681.800	8,725.000	8,722.000	8,690.100	8,647.550	8,661.450
1/4/21	8,676.500	8,692.150	8,726.350	8,774.800	8,805.150	8,828.600	8,967.750	9,073.900	9,072.600	9,135.000	9,266.150	9,574.250	9,471.500	9,445.350	9,339.750	9,302.250	9,335.350	9,380.700	9,362.550	9,298.350	9,348.600	9,309.800	9,259.850	9,244.000
1/5/21	9,212.750	9,249.450	9,240.350	9,247.100	9,294.100	9,372.900	9,478.700	9,670.250	9,696.350	9,753.900	9,840.400	9,782.150	9,694.100	9,828.950	9,886.850	9,796.700	9,785.900	9,735.350	9,692.550	9,698.650	9,642.400	9,663.900	9,568.650	9,532.600
1/6/21	9,529.650	9,524.050	9,562.300	9,590.700	9,630.600	9,734.750	9,917.950	10,076.150	10,028.950	10,040.050	10,082.500	10,097.500	10,091.350	10,097.250	10,087.850	10,019.950	10,048.450	10,000.050	10,041.200	10,028.750	10,035.150	9,972.450	9,956.550	9,944.550
1/7/21	9,911.300	9,925.350	9,914.200	9,951.750	9,998.250	10,091.000	10,244.400	10,413.300	10,441.350	10,482.900	10,516.900	10,360.350	10,211.250	10,192.200	10,099.550	10,021.450	10,115.350	10,047.700	10,022.500	10,003.650	10,039.750	10,009.750	9,994.200	10,019.250
1/8/21	9,960.900	9,959.600	9,979.950	10,006.250	10,041.900	10,154.850	10,274.500	10,387.400	10,376.950	10,441.700	10,401.450	10,428.900	10,317.150	10,275.250	10,166.100	10,014.400	10,070.550	10,021.000	10,024.450	10,017.050	10,120.000	9,982.250	10,001.800	9,993.850
1/9/21	9,964.650	9,962.150	9,958.200	9,991.600	10,039.400	10,082.800	10,206.900	10,192.100	10,084.150	7,370.450	7,371.300	7,275.350	7,215.300	7,225.900	9,048.400	9,278.150	9,664.000	9,632.550	9,593.550	9,544.300	9,556.650	9,586.100	9,553.000	9,563.400
1/10/21	9,573.200	9,549.750	9,598.650	9,586.700	9,634.650	9,641.900	9,789.150	9,788.650	9,714.750	9,640.500	9,565.700	9,427.650	9,392.150	9,316.250	9,282.000	9,238.750	9,300.800	9,442.750	9,508.900	9,592.200	9,583.750	9,586.150	9,582.400	9,638.800
1/11/21	9,636.650	9,669.600	9,690.650	9,717.150	9,763.800	9,846.300	9,936.500	10,141.100	10,111.900	10,063.600	9,923.650	9,829.900	9,242.100	10,006.700	9,946.800	9,853.800	9,580.850	9,632.850	9,610.000	9,608.250	9,612.850	9,580.300	9,610.650	9,589.750
1/12/21	9,622.700	9,606.450	9,671.550	9,659.300	9,713.650	9,800.350	9,986.300	10,106.300	10,319.500	10,371.200	10,314.050	10,182.850	9,989.400	9,938.450	9,878.600	9,950.200	9,957.800	9,805.600	9,883.500	9,858.250	9,934.050	9,903.400	9,904.950	9,901.300
1/13/21	9,899.050	9,911.550	9,932.750	9,949.850	9,996.950	10,101.200	10,266.850	10,384.950	10,487.050	10,408.850	10,302.050	10,168.050	10,037.700	10,023.600	10,112.850	10,047.300	10,014.250	9,859.350	9,904.350	9,907.150	9,989.250	9,967.500	9,941.350	9,947.750
1/14/21	9,942.150	9,923.000	9,878.250	9,911.100	9,928.800	10,038.100	10,221.100	10,432.950	10,523.950	10,520.500	10,478.500	10,257.450	10,122.500	10,534.350	10,403.950	9,961.150	9,859.400	9,827.700	9,897.250	9,911.300	9,975.400	9,991.850	10,032.300	10,004.850
1/15/21	9,998.700	9,957.050	9,944.950	9,961.450	10,035.300	10,110.900	10,214.250	10,304.950	10,325.800	10,337.100	10,136.950	10,002.450	9,928.100	9,883.700	9,861.500	9,761.050	9,735.500	9,698.550	9,725.650	9,691.000	9,629.450	9,590.100	9,552.550	9,529.350
1/16/21	9,525.200	9,504.350	9,510.700	9,535.200	9,523.150	9,553.200	9,604.950	9,367.950	8,718.650	8,723.700	8,661.000	8,644.100	8,593.100	8,620.350	8,621.050	8,834.150	9,446.550	9,640.050	9,733.650	9,735.800	9,735.100	9,688.850	9,685.200	9,727.000
1/17/21	9,762.550	9,746.100	9,777.550	9,756.850	9,812.700	9,826.300	9,850.800	9,581.900	9,014.800	8,945.600	8,903.050	8,844.200	8,774.000	9,542.050	9,471.650	9,461.450	9,569.200	9,723.600	9,711.200	9,696.900	9,669.800	9,630.350	9,637.250	9,637.150
1/18/21	9,656.250	9,670.250	9,704.150	9,718.450	9,759.350	9,829.300	9,836.550	9,751.650	9,684.600	9,600.650	9,526.150	9,544.200	9,556.150	9,629.550	9,614.350	9,660.000	9,729.000	9,794.150	9,882.450	9,921.650	9,928.500	9,950.950	9,948.400	9,856.850
1/19/21	10,068.450	9,978.550	10,006.900	10,050.450	10,057.650	10,148.950	10,269.550	10,464.500	10,415.600	10,360.250	10,249.050	10,155.950	10,124.200	10,022.400	9,999.050	9,924.850	9,699.550	9,732.200	9,949.450	9,970.800	9,987.350	9,991.300	9,957.650	9,973.650
1/20/21	9,966.450	9,931.350	9,891.800	9,950.550	9,960.450	10,016.550	10,192.800	10,332.550	10,001.700	9,975.750	10,060.600	9,947.350	9,920.550	9,875.800	9,881.500	9,765.500	9,773.800	9,682.600	9,674.600	9,687.800	9,704.100	9,711.050	9,684.100	9,671.900
1/21/21	9,707.700	9,697.600	9,714.250	9,725.300	9,796.750	9,919.350	10,131.550	10,285.600	10,284.750	10,253.000	10,173.100	10,057.550	9,883.450	9,812.800	9,753.150	9,601.500	9,592.900	9,539.000	9,536.650	9,532.450	9,620.800	9,618.600	9,593.000	9,585.550
1/22/21	9,598.450	9,511.300	9,529.650	9,540.350	9,584.450	9,648.950	9,793.600	9,911.550	10,033.800	9,961.800	9,860.700	9,802.850	9,829.600	9,781.200	9,709.200	9,701.650	9,626.350	9,639.650	9,672.950	9,745.850	9,760.150	9,773.800	9,789.000	9,802.150
1/23/21	9,802.100	9,751.000	9,742.900	9,752.550	9,801.800	9,847.100	9,889.250	9,862.650	9,910.950	9,890.250	9,863.950	9,822.300	9,774.650	9,786.650	9,747.300	9,699.250	9,751.050	9,875.700	9,952.050	9,975.200	9,975.500	9,961.300	9,943.100	9,992.900
1/24/21	10,010.150	10,008.500	10,017.250	10,048.800	10,071.700	10,096.600	10,134.000	10,032.250	9,959.050	9,911.150	9,852.700	9,816.450	9,779.400	9,675.150	9,644.350	9,661.400	9,703.150	9,860.300	9,922.300	9,918.700	9,881.700	9,860.650	9,854.250	9,870.050
1/25/21	9,891.100	9,854.600	9,833.500	9,847.800	9,887.750	9,950.350	10,077.300	10,175.800	10,201.400	10,292.850	10,282.050	10,121.050	10,030.950	9,931.150	9,813.200	9,844.550	9,872.250	9,896.800	9,963.400	9,895.750	9,908.350	9,842.350	9,836.050	9,814.700
1/26/21	9,813.250	9,813.300	9,814.000	9,834.950	9,849.200	9,920.800	10,026.600	9,926.200	9,748.900	9,718.900	9,748.400	9,665.900	9,610.250	10,052.400	10,021.700	10,047.200	10,078.450	9,959.550	9,894.400	9,853.650	9,817.800	9,797.000	9,727.350	9,736.000
1/27/21	9,718.400	9,742.950	9,733.750	9,782.650	9,782.850	9,879.950	10,081.000	10,253.500	10,441.850	10,636.600	10,646.000	10,518.350	10,486.950	10,515.950	10,411.000	10,313.050	10,261.750	10,144.300	10,139.250	10,080.000	10,121.300	10,076.950	10,052.550	10,065.100
1/28/21	10,081.000	10,067.450	10,070.950	10,145.350	10,180.700	10,291.550	10,480.600	10,805.850	10,892.450	11,033.800	11,030.700	10,981.100	10,880.550	10,810.800	10,730.750	10,593.750	10,589.350	10,480.950	10,531.550	10,550.550	10,563.600	10,511.800	10,524.050	10,473.750
1/29/21	10526.85	10524.95	10517.05	10505.3	10566.85	10641.1	10779.05	10938.9	11161.85	11129.05	10897.35	11061.25	10916.65	10882.35	10778.4	10703.7	10651.5	10567.35	10618.9	10627.75	10656.55	10608.85	10610.55	10613.45
1/30/21	10617.65	10578.1	10587.1	10600.6	10605.1	10628	10639.6	10493.45	10391.5	10325.9	10281.3	10249.85	10148.6	10104.85	9998.55	9997.7	10032.25	10241.45	10359.15	10404.6	10456.15	10482.7	10473.75	10475.8
1/31/21	10457.65	10440.95	10402.9	10426.2	10418.35	10420.55	10430.4	10282.05	10215.35	10185.85	10097.7	10059.5	10028.8	10030.3	10031.25	10061.75	10135.85	10292.25	10327.65	10348.1	10317.45	10276.7	10264.35	10277.2

RT-LMP Rate

Projected Real-Time Residual Metered Load Aggregate LMP to be used for sample invoice
Start of Real-Time LMP Data			100	200	300	400	500	600	700	800	900	1000	1100	1200	1300	1400	1500	1600	1700	1800	1900	2000	2100	2200	2300	2400
Date	Name	Type	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP
1/1/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	11.150938	16.074231	17.454452	17.223655	17.710509	16.9643	16.802848	17.208587	17.138242	18.857925	26.006638	22.351435	23.749528	22.516207	21.915917	21.448668	21.30076	22.000499	22.50721	21.978366	21.727489	21.854667	22.257238	19.905763
1/2/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.160631	19.320459	17.97195	17.35027	17.736171	17.30234	18.011457	16.864281	15.889525	15.680123	14.659088	13.863761	14.469024	15.495149	15.226954	17.127674	19.708639	24.870684	24.705578	22.029127	24.832442	23.018148	21.875912	18.23501
1/3/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	17.464264	16.960672	16.903471	17.048109	16.951034	16.282782	16.608158	17.638723	19.205778	23.452327	22.795218	27.457641	23.47378	21.839132	23.261921	24.567098	34.817976	24.685648	24.976571	27.941641	27.394904	23.869855	22.914665	22.102091
1/4/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.626871	17.118712	18.55293	16.542438	17.548472	24.09525	22.877547	25.77903	31.76124	25.528411	26.32178	18.174778	16.527872	17.017706	19.041861	16.947992	16.023475	21.004985	20.964419	19.094529	15.266889	15.621033	16.081629	3.291301
1/5/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	10.265222	16.697772	15.332706	15.097098	14.434931	14.619794	15.494991	19.902987	23.871176	19.986701	20.292966	22.984817	19.556746	19.655218	17.819363	17.434386	17.700621	22.734331	20.874017	18.034888	16.826997	16.726258	16.594035	16.156541
1/6/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	14.002779	17.722145	16.957831	16.997625	16.570852	16.161446	17.544347	18.916451	18.297443	18.079328	17.942099	18.433174	17.912062	17.881262	17.570167	17.75709	18.21201	21.581221	20.730895	19.185881	18.392177	17.963252	18.170416	17.407407
1/7/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	18.139987	18.748518	18.734912	18.252263	17.817344	17.299708	19.497304	46.198135	22.262754	21.869268	19.353417	19.774678	19.976318	19.053999	18.337158	18.542668	18.566783	25.147556	22.114352	22.969411	23.092304	24.054082	23.207621	22.896552
1/8/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.95185	19.14344	18.662455	18.549325	19.285254	19.811634	23.200757	29.940728	37.232363	36.597685	26.765412	31.04187	28.750782	25.557097	23.824431	25.421171	24.678782	36.299876	25.35683	25.351786	25.521682	24.142981	23.016009	21.264341
1/9/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.923558	21.655077	20.115354	19.894255	20.21593	21.699311	36.475609	23.587146	21.18327	20.472758	19.683275	18.654028	18.981938	17.487212	17.739917	18.952649	18.512298	20.199645	20.749697	19.958165	18.78911	19.182454	16.279552	19.298621
1/10/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.670864	19.651886	19.412105	18.390842	17.371458	18.071853	19.834089	19.707288	18.977455	16.878991	17.771959	4.838877	15.185158	16.348943	16.686031	16.876446	17.300187	14.494367	23.454778	21.995211	20.207486	23.824902	24.701456	20.941725
1/11/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	24.116963	25.692249	24.291979	22.867891	25.649173	24.861475	25.546264	31.914834	32.248344	28.879591	24.986036	29.609923	26.04389	25.018732	23.901867	23.157115	20.971444	26.812785	25.467849	24.010687	23.902041	25.982454	24.961907	21.407634
1/12/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.377234	20.887925	20.93979	21.377751	23.470117	22.865185	23.962041	26.674619	27.731741	21.438986	20.091736	20.107695	20.544032	19.619213	18.685835	18.338063	19.961806	23.057283	27.171698	24.421758	20.896298	21.068304	22.912134	20.742165
1/13/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	22.036755	20.46019	20.608715	25.732712	26.680973	21.027302	32.115642	37.99705	67.531404	21.921544	21.332241	22.185013	21.689317	21.085773	18.225835	18.287515	18.246498	18.906983	21.043286	21.990774	22.897746	24.155707	22.285336	21.606308
1/14/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.988973	19.427698	19.903982	19.928388	20.165566	19.911881	19.630054	30.618687	27.45259	23.756474	25.723896	21.781592	20.430987	19.253523	19.731886	18.967934	19.458981	20.470763	22.407321	19.986897	18.674968	18.822475	19.78707	20.23205
1/15/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.736546	19.897361	19.697972	19.50447	19.100847	17.570513	18.016066	19.070797	20.004197	21.545783	23.621905	21.380085	22.04632	21.871091	22.398983	25.250675	25.614123	31.845375	26.108641	24.924115	24.90564	22.315221	20.298822	19.875106
1/16/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.209363	22.681933	21.726668	20.02677	19.41511	20.030694	21.11268	22.464303	25.082302	24.526901	23.542414	22.853252	21.012087	20.568942	20.587404	20.502562	21.944661	25.829678	27.352897	24.518006	24.399346	21.45741	20.450101	20.068721
1/17/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.953029	20.348355	20.432272	20.370587	20.587721	20.604886	20.863233	21.571167	22.216588	21.371015	20.665772	20.465068	20.599198	20.591035	21.215926	21.107618	22.225628	24.951806	27.033222	23.439665	22.289373	21.291788	20.545062	20.127814
1/18/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.776155	19.641349	19.454852	19.375728	19.389519	20.343263	19.855011	21.342154	20.559369	20.866946	21.426579	22.218861	22.231769	22.864057	22.699164	22.23968	23.833731	25.159035	22.953529	24.174592	23.160302	23.030743	20.898759	20.240252
1/19/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.799671	19.296844	18.371195	18.208957	18.148908	18.854978	19.369985	44.787504	23.555836	20.70418	21.137844	20.865637	20.875381	19.258036	18.456032	18.758832	18.820625	20.432784	22.24446	21.776328	21.852857	20.424449	20.114626	18.946852
1/20/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	18.717161	18.807102	18.564553	18.935327	19.235853	19.97576	21.115599	24.914762	22.617153	21.684459	20.457207	20.213956	19.863338	18.741231	17.691934	18.105222	18.706314	20.579679	23.173001	22.975284	21.692301	21.269304	20.989594	19.864863
1/21/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.129896	19.434772	19.913054	19.950295	22.127442	24.943076	26.635012	32.246687	26.982347	23.200067	19.074646	19.130354	18.095372	17.803932	17.757638	17.583261	18.113379	20.235164	22.099765	21.474745	20.330929	19.18656	18.164903	17.747592
1/22/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	17.453116	17.58847	16.597978	16.673581	17.985792	18.659077	17.45593	20.000606	20.126089	17.914979	20.670754	22.284749	22.258136	21.919672	20.115062	19.633648	22.076752	26.147562	33.643004	22.353802	22.822814	20.24994	20.864902	21.184734
1/23/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.203133	20.831662	20.472073	20.782246	20.491592	15.724369	15.52723	15.274715	14.774091	18.936126	20.420974	21.842591	21.907914	20.858148	20.370538	19.919879	21.037388	44.756155	29.828736	23.696563	21.559494	22.229843	24.675559	25.227957
1/24/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	23.712599	22.774247	21.673999	21.507449	22.42403	18.534547	17.683005	18.039048	17.720279	18.127036	19.146759	19.830385	24.675774	23.721774	25.241631	21.113587	24.464863	26.815458	24.448152	24.345557	22.998598	20.425187	22.069239	24.304363
1/25/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	23.341599	22.012305	21.963723	20.286765	20.689898	22.573163	26.676112	24.165213	26.745622	25.763648	28.008029	25.922441	52.597602	26.733209	24.033526	25.524278	29.665404	81.515741	57.338764	59.750319	26.921019	22.050173	20.516182	20.140127
1/26/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.752951	21.941588	20.386711	20.701711	21.531443	17.303873	17.028222	19.311194	21.448481	29.557907	28.786392	32.574393	26.82247	26.145058	24.942729	21.406325	22.892082	23.112699	25.016286	20.807125	19.341493	19.909665	19.937907	18.530009
1/27/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	18.427748	18.198011	17.725303	17.618547	17.448047	17.644882	18.533672	23.521466	23.798409	23.649715	21.760906	25.147643	23.91439	24.403356	24.357868	22.602006	24.627644	24.103222	25.573882	24.830816	23.864	21.73398	20.918764	20.692992
1/28/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.806168	20.647053	20.515701	20.172346	20.406185	20.947144	24.453423	26.315349	54.274428	26.347562	29.048452	28.850752	26.789751	25.175897	24.140588	24.064552	26.298282	29.735137	33.585168	31.60539	31.00367	26.264116	29.652088	27.1143
1/29/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	23.409358	28.828172	35.647308	31.718203	30.666193	31.645479	33.662808	23.056449	11.6448	-10.351754	-4.068028	-12.089824	10.004031	8.046403	11.842634	9.526929	26.774445	247.67062	43.409786	25.107045	21.689184	19.101425	15.619227	23.271525
1/30/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	13.364084	9.198946	21.560302	25.296004	29.404075	32.57847	33.087387	28.966006	19.986466	13.810249	17.532573	17.093513	17.658887	17.578153	16.110034	18.133142	20.562295	26.749911	28.885666	26.916137	4.692061	3.310546	20.511604	3.711161
1/31/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	18.068517	19.659236	14.155036	19.951235	20.109306	19.322919	25.628362	29.509761	25.491663	33.817207	29.641443	39.539653	37.552171	108.548895	37.086167	31.794536	34.097411	144.501716	65.333664	39.300879	41.35347	29.679697	24.866737	19.393938

DA-LMP Rate

Projected Day-Ahead Residual Metered Load Aggregate LMP to be used for sample invoice
Start of Day Ahead LMP Data			100	200	300	400	500	600	700	800	900	1000	1100	1200	1300	1400	1500	1600	1700	1800	1900	2000	2100	2200	2300	2400
Date	Name	Type	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP	TotalLMP
1/1/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	18.293495	17.048437	17.154092	17.077434	17.102789	17.173405	16.96815	16.99997	16.573083	16.817577	16.249427	16.118841	16.034395	16.459687	18.605988	18.098113	19.963178	22.750538	22.600042	21.161511	21.23379	19.660414	17.693381	17.128862
1/2/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	16.573047	16.939232	16.256088	15.595466	15.641883	15.688163	15.77824	16.563369	17.189036	19.235371	19.438515	18.494112	17.231451	16.507955	16.001193	16.880075	18.988256	22.597707	22.872219	21.694099	21.513649	20.354529	18.965056	17.663737
1/3/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	18.163423	17.011702	16.377606	16.093507	16.089847	15.598805	15.648626	16.032682	17.608294	18.682435	19.451697	20.783066	20.641712	20.38578	20.107076	20.201996	21.531383	23.697512	21.83011	20.198129	21.033916	20.311922	18.663194	17.364203
1/4/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	17.957562	14.567073	14.542558	14.570661	14.215946	14.565721	15.525884	16.43634	16.298489	18.169121	20.545521	19.746003	19.372416	18.838035	18.65098	18.776072	18.634762	25.116286	22.456238	21.76083	20.629355	19.74794	17.855183	16.421304
1/5/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	16.87904	16.331033	16.010876	15.417207	14.94929	17.659579	22.175467	23.262352	23.689481	23.699595	23.477389	24.367709	22.913129	22.942641	22.31517	22.660338	22.682931	33.69367	27.754807	25.456597	25.582178	22.661891	21.134475	18.93634
1/6/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.022649	19.375631	18.759867	18.776031	18.94377	19.994123	22.533406	25.025532	22.799347	20.388192	21.241234	21.873897	20.419553	19.999056	20.250084	20.534718	21.931649	32.214419	25.880505	23.831728	22.531635	23.02447	21.552584	20.689755
1/7/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.966354	19.41273	18.793432	18.729841	19.374881	19.697258	20.192625	25.303177	22.70725	20.48932	20.449693	20.44149	19.618565	19.151442	19.171267	19.24302	20.507887	26.931465	23.489862	24.241223	24.71867	24.81389	22.37983	19.99303
1/8/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.856366	19.398838	19.019653	18.923951	19.488317	19.482281	26.729559	32.916372	29.733046	27.391633	26.143518	24.388299	22.6612	21.734064	21.64773	21.726778	25.999441	33.817314	27.197175	24.995224	25.710983	24.148884	23.66074	22.381036
1/9/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	22.708776	22.048849	20.792119	21.253619	21.031484	21.486181	20.957931	22.157753	23.001524	22.049769	22.21136	21.313666	20.349619	19.540969	19.271113	19.604544	21.599149	27.332706	25.358746	23.160664	21.961263	22.724839	21.852207	21.734028
1/10/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.405656	20.758716	20.152012	20.191584	19.571617	21.00483	21.806377	23.513315	21.660489	19.951337	20.228184	19.940261	19.739518	18.935282	18.533755	18.96467	21.158536	27.390326	26.016821	24.789614	24.408448	24.618466	22.786946	22.170281
1/11/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	23.739981	22.421617	21.688023	21.611074	21.549315	23.452765	28.46453	40.560937	37.532166	31.102005	30.684092	28.031842	25.544655	24.359363	23.55581	23.125379	24.531631	32.214767	29.401668	27.10473	24.582427	25.071151	24.408859	22.065394
1/12/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.429694	21.063228	20.754195	20.775587	20.945511	22.635828	24.758382	31.677656	24.829802	23.550847	22.061422	22.852488	21.98019	21.458237	20.87944	21.007433	21.366864	29.696011	25.711065	24.331341	23.313221	22.879609	22.291444	21.153374
1/13/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	22.842656	22.234589	22.088926	21.830692	22.978235	24.449007	28.859642	38.346878	29.473743	27.488803	24.424243	23.409495	21.989151	21.799581	21.298129	21.431713	21.835215	28.602126	27.67953	26.96079	25.257486	24.980044	22.914853	21.950612
1/14/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	22.957241	22.056746	21.853587	22.805323	23.457405	24.752611	29.001707	34.055087	29.63718	27.376468	26.703326	24.547819	23.225963	22.380507	22.103039	22.119357	23.281844	28.179921	28.585589	27.186813	25.55462	24.235528	23.21087	22.542299
1/15/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.302262	20.67049	20.380197	20.503899	21.275609	22.273026	26.0027	24.526496	26.242856	25.434325	25.761395	24.2984	24.046564	22.897574	22.564617	22.677903	22.705382	26.214264	22.659159	21.091342	20.884821	21.147521	19.535031	19.187015
1/16/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	17.958616	17.827114	17.378322	17.277966	17.16313	17.438231	18.271358	19.07143	20.53669	22.398519	22.362999	21.081994	20.360922	18.927297	18.897368	18.73778	19.697408	23.002469	23.09356	21.407142	20.742165	20.568717	19.870639	19.312721
1/17/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.007923	20.200047	19.945147	19.577697	19.929517	20.160061	21.244842	23.040118	23.64521	22.972014	21.387351	21.265515	20.320606	19.726622	19.859274	19.929085	22.116837	26.270563	25.051692	24.259134	24.192737	23.412187	22.106858	20.992718
1/18/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.278135	19.963471	19.778056	19.969334	20.958382	21.951931	23.200153	23.984996	25.851811	24.70012	24.74424	25.398336	23.4009	22.721493	22.718011	22.785287	24.936118	30.701056	29.539726	26.638752	26.871732	25.952508	24.250494	22.827169
1/19/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.698893	20.260248	19.93985	19.828961	20.162313	21.330829	24.781724	28.234732	24.919379	23.011591	22.968865	22.536801	21.474952	20.701479	20.455484	20.344014	21.454565	25.56935	26.343882	25.289303	24.145082	23.578411	21.746215	20.851853
1/20/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.693256	19.932048	19.762626	19.687758	19.604352	19.910039	22.35229	29.699923	24.820636	22.975262	23.107095	21.723543	21.018801	19.841095	19.455433	19.924883	20.918392	24.665242	24.909839	24.232907	25.250213	23.397781	21.836395	21.119511
1/21/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.613679	19.120556	19.087271	19.040571	19.242665	20.50121	26.702217	32.280863	26.009395	21.906415	20.640431	20.463536	19.270863	18.621945	18.443282	18.487874	19.7114	23.593901	23.83951	23.162544	22.498783	21.15567	19.729956	18.947179
1/22/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	18.720704	18.639732	18.685167	18.803663	19.87322	21.129944	22.899731	25.069966	24.409553	23.220637	23.459433	22.961511	22.553223	22.145173	21.894005	21.565295	22.241209	26.720503	25.802744	24.358987	23.63824	23.72127	22.998208	22.724498
1/23/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	23.566854	23.158868	23.254618	22.096236	23.055075	21.581512	20.724396	19.840736	20.427344	21.122174	21.347538	22.040157	21.787339	22.359787	22.038671	21.172838	22.609966	30.963923	27.785357	25.700106	26.058865	25.978468	24.443651	24.223374
1/24/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	22.989228	22.469865	22.264275	21.851634	21.937091	20.487075	19.06627	18.355821	18.369398	19.097719	20.288022	20.998833	21.391814	21.289878	21.160866	20.530441	22.224978	29.791228	26.23841	26.426381	25.816043	24.073836	24.41229	23.021426
1/25/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.510072	20.945467	21.134664	21.253102	21.398616	23.800218	26.736909	30.318793	27.252409	24.737568	23.656918	24.061015	24.76412	25.006314	25.671674	24.42959	25.020887	29.529473	25.84902	25.645593	25.636721	23.977914	21.362108	20.125697
1/26/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.474823	19.246604	18.789398	18.824426	20.061233	21.42753	22.977027	23.937914	26.100872	25.642704	26.48248	25.705286	24.493706	23.94044	23.16129	21.780025	23.016271	27.975334	26.570236	24.872887	24.461419	21.782587	21.103715	19.458565
1/27/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.78766	19.315726	18.618233	18.688983	19.31288	17.326812	17.849801	19.772044	19.799311	20.478137	21.84261	22.734175	22.758408	22.398878	21.618457	21.506039	21.771237	25.149159	25.782556	24.420902	22.935368	22.050744	22.097629	20.796703
1/28/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.19953	20.982438	20.270639	19.215808	20.550117	21.310851	25.050377	27.359668	28.708195	28.41774	31.559266	31.854671	29.920619	28.08257	27.817663	28.347939	31.255524	41.544329	45.203739	40.594508	37.09662	36.501845	32.94448	30.317041
1/29/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	33.171717	32.545015	31.580871	31.552532	32.329985	35.88333	43.639308	59.31433	46.466911	37.322874	40.288974	38.234229	34.163132	33.170769	32.834652	35.065399	38.003612	67.941033	61.510722	52.161138	44.230461	41.119962	38.181208	32.93594
1/30/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	29.052027	29.030393	28.342208	28.025305	28.12814	29.406366	32.461157	36.837748	35.656092	29.305394	27.158755	26.347716	24.330514	23.255392	22.133973	22.835057	24.871818	33.348591	33.4575	30.235006	28.559463	27.874754	25.762042	23.294647
1/31/21	AECO_RESID_AGG	RESIDUAL_METERED_EDC	26.984323	26.227085	24.845644	23.008388	23.219689	23.488813	24.083584	26.181254	28.681093	29.078062	27.926533	27.541126	28.591827	27.555236	26.51959	25.758829	28.345836	36.178169	32.011141	28.821093	26.986898	25.134134	23.899736	20.521992

Cap-Trans PLC

Projected Capacity and Transmission Pk Load Contributions to be used for sample invoices
Capacity Peak Load Contribution	9,405.99	kW
Transmission Peak Load Contribution	9,723.91	kW

File details come from the government source that posted it. Updated Apr 1, 2021.