697DCK-22-R-00265 Section J Attachment 2.xlsx

XLSX spreadsheet 44 KB Posted Mar 29, 2022

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

View the file

Other files

File	Type	Posted
Notice to Suppliers.pdf	PDF	Apr 22, 2022
RFO 697DCK-22-R-00265 RESPONSES TO QUESTIONS.pdf	PDF	Apr 20, 2022
697DCK-22-R-00265 SF-33.pdf	PDF	Mar 29, 2022
697DCK-22-R-00265 Section J Attachment 1.xlsx	XLSX spreadsheet	Mar 29, 2022
SIR 697DCK-22-R-00265.pdf	PDF	Mar 29, 2022

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/22	9,871.500	9,830.350	9,846.075	9,859.800	9,864.300	9,917.175	9,918.150	9,887.625	9,831.100	9,745.725	9,714.550	9,738.450	9,746.200	9,725.850	9,734.275	9,724.050	9,790.800	9,904.100	9,898.350	9,894.450	9,891.475	9,850.850	9,845.975	9,911.775
1/2/22	10,001.675	10,016.250	10,004.075	10,008.375	9,993.050	9,993.725	10,058.675	9,963.125	9,846.150	10,010.200	10,011.475	10,036.100	10,034.650	10,051.600	10,033.075	10,019.075	10,094.300	10,234.525	10,223.125	10,184.400	10,136.100	10,139.675	10,148.325	10,183.500
1/3/22	10,136.475	10,201.675	10,289.825	10,308.875	10,390.175	10,526.350	10,590.975	10,700.675	10,626.100	10,639.325	10,656.325	10,688.375	10,750.550	10,777.225	10,780.350	10,835.450	10,882.500	10,837.300	10,550.200	10,545.650	10,605.150	10,557.400	10,578.850	10,567.825
1/4/22	10,541.200	10,549.950	10,577.750	10,670.825	10,720.375	10,874.350	10,880.150	10,989.000	10,969.300	10,996.275	11,028.100	11,045.500	10,908.200	10,890.625	10,767.525	10,718.500	10,709.550	10,733.525	10,731.425	10,715.475	10,729.450	10,719.225	10,708.850	10,747.150
1/5/22	10,715.375	10,677.025	10,682.175	10,639.500	10,639.350	10,722.950	10,907.600	11,083.000	11,083.225	11,094.250	11,091.725	10,300.100	10,806.650	10,449.875	10,251.000	10,621.300	10,556.975	10,376.125	10,276.000	10,242.125	10,241.050	10,189.400	10,153.050	10,183.525
1/6/22	10,104.625	10,070.500	10,020.550	10,035.000	10,146.650	10,306.225	10,616.750	10,818.900	10,878.450	10,845.950	10,850.150	10,831.575	10,849.025	10,955.225	10,823.800	10,605.300	10,466.700	10,504.500	10,546.550	10,427.150	10,431.700	10,331.275	10,355.750	10,336.100
1/7/22	10,306.200	10,297.675	10,337.500	10,327.250	10,527.650	10,816.525	10,867.675	10,871.000	10,673.400	10,810.850	11,059.325	11,208.550	11,126.525	11,010.725	10,977.700	10,836.400	10,744.275	10,788.650	10,734.025	10,753.175	10,763.425	10,731.125	10,764.575	10,751.625
1/8/22	10,705.425	10,684.625	10,685.675	10,697.025	10,743.600	10,777.675	10,919.900	10,943.050	10,867.400	10,837.750	10,770.300	10,648.675	10,764.950	10,725.000	10,581.950	10,502.050	10,449.325	10,615.150	10,709.350	10,740.900	10,810.675	10,805.800	10,750.025	10,637.350
1/9/22	10,620.025	10,612.675	10,593.700	10,611.175	10,612.500	10,622.475	10,750.950	10,653.125	10,494.300	10,399.000	10,364.900	10,349.900	10,287.100	10,297.400	10,206.875	10,181.750	10,150.500	10,246.025	10,213.375	10,174.475	10,128.625	10,082.050	10,056.925	10,073.200
1/10/22	10,118.675	10,183.175	10,247.100	10,281.100	10,356.625	10,616.350	10,735.975	10,980.225	10,967.000	11,030.750	10,937.125	10,861.800	10,788.650	10,860.100	10,854.425	10,798.475	10,585.775	10,610.725	10,608.225	10,634.625	10,646.050	10,792.050	10,813.825	10,780.450
1/11/22	10,814.175	10,828.050	10,785.100	10,701.225	10,782.525	10,972.200	11,322.025	11,641.725	11,766.250	11,801.625	11,704.850	11,509.575	11,262.300	11,223.875	11,112.375	11,183.125	11,160.775	11,089.625	11,066.225	11,049.025	11,086.450	10,856.300	10,889.450	10,999.800
1/12/22	10,878.000	10,948.175	11,011.375	10,938.775	10,802.050	10,891.650	11,321.575	11,535.200	11,591.675	11,417.300	11,297.750	11,189.325	11,007.250	10,894.150	10,936.900	10,887.175	10,780.850	10,490.150	10,434.250	10,473.825	10,441.050	10,421.350	10,390.250	10,422.775
1/13/22	10,389.575	10,386.650	10,377.700	10,470.675	10,460.525	10,572.825	10,856.900	11,086.625	11,295.850	11,078.225	11,131.175	10,886.125	10,560.875	10,395.825	10,350.400	10,291.900	10,046.275	9,948.175	9,862.050	9,883.125	9,853.800	9,791.825	9,781.125	9,735.900
1/14/22	9,761.300	9,753.050	9,766.575	9,769.300	9,813.325	9,922.300	10,017.900	10,172.050	10,283.650	10,343.950	10,343.075	10,278.775	9,954.700	9,906.700	9,857.725	9,783.700	9,812.225	9,924.875	10,095.000	10,003.900	9,977.725	9,979.925	10,025.075	10,027.275
1/15/22	10,015.625	10,033.825	10,086.625	10,121.725	10,186.875	10,224.750	10,265.525	10,178.075	10,088.175	10,024.150	9,944.500	9,893.600	9,869.275	9,865.300	9,851.650	9,890.075	9,943.675	10,142.450	10,156.200	10,196.825	10,214.375	10,157.300	10,166.825	10,313.025
1/16/22	10,377.575	10,269.375	10,312.750	10,324.775	10,363.200	10,400.700	10,435.525	10,328.125	10,249.875	10,185.350	10,122.450	10,067.475	9,876.000	9,833.650	9,772.700	9,760.725	9,809.300	9,896.800	9,910.650	9,874.725	9,872.700	9,753.075	9,723.825	9,688.025
1/17/22	9,617.000	9,399.525	9,438.650	9,505.500	9,547.975	9,664.600	9,676.000	9,852.975	9,921.950	9,913.975	9,754.000	9,695.475	9,700.050	9,699.775	9,742.325	9,755.600	9,810.525	9,874.425	9,895.225	9,925.250	9,951.300	9,909.650	9,855.600	9,856.950
1/18/22	9,897.575	9,914.325	9,954.650	9,931.200	9,897.275	10,056.950	10,281.900	10,563.900	10,555.775	10,590.375	10,704.800	10,609.550	10,563.550	10,414.300	10,461.925	10,380.025	10,225.675	10,171.750	10,175.025	10,128.400	10,144.300	10,073.600	10,111.500	10,071.275
1/19/22	10,101.400	10,075.250	10,111.400	10,101.425	10,149.775	10,236.325	10,472.275	10,626.475	10,663.050	10,591.625	10,702.600	10,701.225	10,480.975	10,560.875	10,444.900	10,377.875	10,246.750	10,030.050	9,946.950	9,878.125	9,874.525	9,830.350	9,829.200	9,781.175
1/20/22	9,757.625	9,699.475	9,735.600	9,734.325	9,700.500	9,863.600	10,094.350	10,415.700	10,487.550	10,616.475	10,592.525	10,626.275	10,610.550	10,606.575	10,596.925	10,532.775	10,523.300	10,437.850	10,355.350	10,292.225	10,277.325	10,251.950	10,288.900	10,306.375
1/21/22	10,337.325	10,353.625	10,359.625	10,379.075	10,461.500	10,632.525	10,905.725	11,092.800	11,083.200	11,107.025	11,145.475	11,086.600	10,917.400	10,913.275	10,893.475	10,733.925	10,681.075	10,548.325	10,489.275	10,480.250	10,480.800	10,484.625	10,507.925	10,430.325
1/22/22	10,430.575	10,427.425	10,427.550	10,442.325	10,478.000	10,418.050	10,251.200	10,041.925	9,908.800	9,806.375	9,738.725	9,637.475	9,565.150	9,429.775	9,416.175	9,770.700	9,914.200	10,095.750	10,205.100	10,246.350	10,275.575	10,302.850	10,296.000	10,304.125
1/23/22	10,300.675	10,296.525	10,307.500	10,346.200	10,290.800	10,336.325	10,359.750	10,240.200	10,126.900	10,011.450	9,884.975	9,757.175	9,662.100	9,605.200	9,569.850	9,608.675	9,728.450	9,914.025	9,949.775	10,012.800	10,000.575	9,982.800	9,988.175	9,996.750
1/24/22	9,982.825	10,016.625	10,110.100	10,135.325	10,184.750	10,360.725	10,508.875	10,753.850	10,765.425	10,769.025	10,680.800	10,574.575	10,483.300	10,456.850	10,469.200	10,495.025	10,365.350	10,209.275	10,174.850	10,183.400	10,174.725	10,143.200	10,109.725	10,060.350
1/25/22	10,021.600	10,009.125	9,956.225	9,964.400	9,984.075	10,160.775	10,372.500	10,656.675	10,812.250	10,785.875	10,852.800	10,771.725	10,747.225	10,637.925	10,636.025	10,531.450	10,348.050	10,167.025	10,099.325	10,089.125	10,139.075	10,157.700	10,145.475	10,200.175
1/26/22	10,165.150	10,174.675	10,168.525	10,229.400	10,263.600	10,477.550	10,769.600	11,061.250	11,023.550	11,175.575	11,195.975	11,188.225	10,907.475	10,802.450	10,810.775	10,781.900	10,655.075	10,437.800	10,490.025	10,468.050	10,494.600	10,493.675	10,538.250	10,531.525
1/27/22	10,505.550	10,520.275	10,560.150	10,596.975	10,613.975	10,758.925	10,985.950	11,225.275	11,374.500	11,328.575	11,264.275	11,122.900	10,974.250	10,778.325	10,820.800	10,583.975	10,440.875	10,381.100	10,433.225	10,446.700	10,489.000	10,536.100	10,431.950	10,378.900
1/28/22	10,308.450	10,273.175	10,230.150	10,283.800	10,304.450	10,476.300	10,639.800	10,901.925	10,824.150	10,849.150	10,916.300	10,694.150	10,453.625	10,361.600	10,323.975	10,244.350	10,192.700	10,158.900	10,198.675	10,170.025	10,186.600	10,182.275	10,179.525	10,192.475
1/29/22	10,225.000	10,251.475	10,306.500	10,355.925	10,371.750	10,427.075	10,494.075	10,450.100	10,363.400	10,320.125	10,306.975	10,304.675	10,319.250	10,346.850	10,337.950	10,353.150	10,369.925	10,495.225	10,573.100	10,587.075	10,573.550	10,606.400	10,637.850	10,678.150
1/30/22	10,696.125	10,698.800	10,693.275	10,682.050	10,698.575	10,663.725	10,733.550	10,578.925	10,485.750	10,359.700	10,282.875	10,239.425	10,170.250	10,135.400	10,119.950	10,114.175	10,122.500	10,300.800	10,419.000	10,453.500	10,472.250	10,445.225	10,451.000	10,456.725
1/31/22	10,366.475	10,392.175	10,412.075	10,439.175	10,472.950	10,688.850	10,787.475	10,942.925	11,000.500	10,944.650	10,924.575	10,735.200	10,689.950	10,654.450	10,614.275	10,508.350	10,422.475	10,403.075	10,434.825	10,412.000	10,433.550	10,431.950	10,449.550	10,433.200

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/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	18.661532	17.868486	18.08028	17.720535	17.748177	17.022882	16.959203	16.208505	17.038913	17.251367	22.674113	24.354956	24.211156	23.522916	23.172983	22.556487	23.46691	25.338578	22.88791	19.116547	19.780615	21.961952	21.512255	13.503267
1/2/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	13.244438	19.221777	19.319808	19.118196	20.913192	18.29581	19.760988	20.066114	22.652984	20.355955	24.81769	31.141724	26.568758	29.162946	26.438648	26.070055	28.657591	45.663522	32.48766	34.577341	30.673227	28.39703	28.331431	26.032668
1/3/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	24.415965	24.245455	23.301613	23.423778	24.65311	25.407713	23.868109	28.066756	36.351051	45.553867	47.783405	59.150621	66.553991	41.600306	39.178381	43.463743	45.238748	84.466458	65.696606	60.765095	70.876187	69.2692	49.427769	42.253829
1/4/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	25.79018	26.158733	39.820104	44.052783	50.562466	61.27964	66.339572	66.65382	73.855372	45.505063	63.274796	58.609679	58.473549	53.555628	48.997513	44.830012	46.284324	55.434007	49.402178	50.550813	50.220064	45.959211	49.242394	43.571021
1/5/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	67.908033	50.655398	62.750173	55.872345	50.884917	51.361806	54.435449	63.781462	56.303469	57.335079	46.808454	40.681545	49.363613	49.76754	40.407702	43.129963	41.039633	102.963466	62.565173	51.722499	40.058185	37.807714	36.65036	34.662295
1/6/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	33.754796	33.695836	33.40044	33.426032	35.149729	33.008103	44.256459	62.259404	50.587633	42.896122	39.870511	37.481052	36.159527	35.929223	43.736128	45.097581	42.809312	42.252002	0.446407	27.546316	38.840018	39.669683	40.494348	21.634889
1/7/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	29.992511	45.799883	44.993191	48.077007	46.937593	48.014838	51.278357	64.238723	54.388162	49.330871	94.924457	86.842975	96.796184	71.470345	53.299791	85.752594	107.739778	232.855728	249.209966	120.643039	78.491882	65.721859	61.696957	62.789258
1/8/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	76.397999	81.061575	73.974746	69.31189	57.649955	80.17305	119.931425	68.703073	107.829339	72.661652	71.51151	73.075095	43.760481	43.438285	42.299462	43.852227	48.948081	89.484042	51.069834	53.112479	49.585103	46.733636	45.557072	40.067237
1/9/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	48.659	49.672409	46.402983	38.847809	38.219488	33.912221	33.833596	32.6179	30.699358	34.7272	39.940368	46.237311	43.962013	43.73218	42.321854	42.092978	46.00471	64.78848	52.052345	48.269908	41.386462	41.774058	37.004347	31.210836
1/10/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	31.824815	32.236343	32.813614	33.281038	37.532934	48.059829	62.982796	50.602365	50.02585	49.320609	52.16689	89.312559	128.903996	40.74347	98.556695	177.317086	318.460455	258.166419	85.791347	74.002426	60.328972	61.912679	55.200258	47.664518
1/11/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	49.738684	65.932352	61.517434	61.542878	55.044135	61.008395	66.569714	75.655726	78.247231	53.139529	52.701543	12.592249	2.984849	46.716138	54.137542	260.421323	914.530992	1174.117706	207.278975	167.836031	207.419323	213.743975	424.148567	260.920026
1/12/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	133.805865	83.291891	78.029516	86.767963	71.363923	60.081455	106.977318	88.910959	59.488748	49.698641	26.471673	40.292455	42.571496	34.366039	7.441395	-27.727255	40.217179	65.232682	41.080828	40.374324	41.771153	34.467467	35.495015	30.376861
1/13/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	26.202944	48.306952	48.916842	43.557148	45.41664	44.681789	647.382791	87.844375	50.966605	43.960713	40.223347	39.190574	40.682705	39.398335	42.776262	41.561217	42.998246	55.179312	45.330115	45.733573	42.830316	41.352898	40.991315	41.991048
1/14/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	39.6753	37.535149	35.376627	36.738765	38.859304	39.189456	51.710001	48.888736	45.475235	44.507327	78.999608	50.693001	46.01622	46.365168	45.905794	41.910534	46.640768	63.063194	50.395185	50.551264	47.206701	55.431157	45.178314	41.299171
1/15/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	47.468728	44.655918	45.63035	47.977696	46.956832	51.353236	53.261002	71.696099	60.855432	44.527561	91.256157	74.796359	235.76198	475.918061	64.485902	73.235272	174.233757	155.836795	128.034464	86.88779	148.295417	241.548463	154.538997	300.425267
1/16/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	446.073243	209.914766	163.262177	176.470456	123.482131	129.888935	197.29131	1095.581737	345.18621	329.080253	330.170395	237.657738	411.683775	249.632096	201.406052	243.376136	227.524743	117.097947	116.30053	98.917451	84.067058	-22.68306	50.216279	42.385182
1/17/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	36.245456	48.49031	-24.544956	17.951969	44.343065	41.45	50.166073	56.079064	-12.753234	29.317395	59.569471	180.497917	175.655975	53.321011	62.581869	55.314683	53.96709	77.679186	69.563289	54.57232	53.607767	65.145216	49.518367	40.842785
1/18/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	36.109047	47.646889	49.685669	72.168772	51.271538	53.95023	57.541567	67.432685	57.007705	61.506025	62.03008	59.898403	51.695301	55.878866	56.454407	45.896101	56.211092	73.6145	64.551847	53.680116	50.445434	60.066239	43.115412	46.020568
1/19/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	47.774801	46.69927	51.400932	53.12552	51.98478	55.970708	63.297133	117.830743	67.034634	44.470096	35.850713	36.818587	33.875821	33.815527	34.680965	38.459153	39.94822	47.797425	43.965884	40.043166	37.590043	38.227972	35.018983	35.663024
1/20/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	32.59457	34.703182	34.691391	34.150841	38.735182	36.846217	41.591396	45.191367	49.312327	42.423756	83.746142	65.686276	65.021873	64.033567	63.407666	64.118513	56.798146	70.768892	73.730527	70.760158	72.179576	67.744813	70.977457	63.57918
1/21/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	57.250064	61.591432	70.620484	69.459902	76.70858	88.70841	99.484413	112.302648	93.241409	97.403291	165.296929	115.295543	124.121177	89.793264	93.349328	139.611776	89.914014	98.419492	54.728998	80.856881	86.634905	108.677838	110.102384	155.851935
1/22/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	116.31559	128.0253	151.965269	116.110705	228.242265	77.707697	117.739675	122.417187	162.021776	78.951419	63.283206	58.924	42.606848	42.710039	39.583154	40.17566	58.464822	110.30899	154.99358	303.449005	110.490163	129.104039	80.20039	77.392196
1/23/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	163.35425	74.3264	81.28903	72.520522	104.022474	96.639857	65.818998	59.373658	50.976516	41.412193	42.272093	55.685154	91.901565	68.478687	47.092521	58.13489	63.123537	70.389353	28.261105	22.262173	35.405967	25.782721	46.072565	37.733167
1/24/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	32.192404	37.933553	44.925498	44.888411	46.589972	51.035071	97.22958	79.695464	52.294883	36.05923	45.508531	45.067925	46.100179	40.637071	30.034932	47.020383	49.929793	139.311128	58.215812	56.335347	50.429657	40.671343	37.439833	34.240123
1/25/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	38.126617	40.967114	40.459443	41.196934	41.8736	46.449472	59.120636	-14.63401	71.566572	58.45015	44.334147	53.369293	44.539306	29.61884	36.808502	27.964735	40.965812	47.861744	53.418562	48.014223	46.103711	44.220648	43.508397	40.326565
1/26/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	37.898859	42.260291	41.906044	42.745544	43.832176	46.462816	51.179553	50.76725	51.398727	43.608778	56.080367	53.993258	46.077757	42.83201	41.904652	58.750087	56.219194	83.910706	82.638298	78.522792	68.262984	66.861328	90.581182	80.147423
1/27/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	55.556607	68.417455	63.332973	62.926777	65.534624	144.492938	223.367122	98.82888	69.92164	49.0049	65.750057	55.837029	51.844095	50.715398	55.607301	57.796194	60.85571	240.117448	97.557063	63.193367	83.585643	298.921628	103.432311	56.280643
1/28/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	55.359664	54.337893	51.527243	50.454157	64.312374	52.164384	223.124576	391.731836	97.559516	79.458978	69.79068	62.845567	63.381504	65.83264	61.136214	58.364186	64.963729	70.65323	64.946671	58.852707	59.903666	61.837428	69.688553	65.179554
1/29/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	50.491705	54.328262	58.257215	61.33988	59.501639	56.547699	59.450862	61.260092	90.86745	84.746047	105.825916	127.243821	792.175124	202.639885	199.154231	173.427205	232.479712	161.02252	117.618522	130.342593	142.755887	193.780123	294.451236	174.758887
1/30/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	270.624827	444.1727	79.206295	99.862834	73.753553	118.176469	101.525608	153.128426	95.3194	128.197939	111.223296	145.663004	85.808392	83.255063	77.397759	92.999845	139.672822	146.396516	370.386755	513.813728	175.453734	186.865627	111.537213	101.40343
1/31/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	86.386294	85.530764	95.799586	87.393508	120.558765	95.44034	592.16605	266.819688	152.953943	130.283155	92.298888	91.367473	70.934526	56.481604	49.010084	56.063951	71.85071	302.062673	307.361171	102.291711	98.112317	227.958071	825.339088	664.350491

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/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	19.983961	17.669	17.353786	17.147685	16.952339	16.893248	16.96089	17.449467	18.902836	19.010508	23.95431	24.421046	24.533107	24.462569	23.806741	23.156808	23.793422	25.647883	24.46349	22.399576	23.365479	23.244984	23.985774	21.517144
1/2/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	21.427667	20.486806	20.299149	19.770078	19.350581	20.441155	17.418466	20.984717	22.557974	22.509104	22.70692	22.997756	24.900498	23.830599	23.855658	23.965949	24.832292	33.561071	29.08782	28.391357	26.654451	25.316828	30.536774	25.319263
1/3/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	20.429412	19.675089	19.448649	18.089856	19.78027	23.439852	28.361226	36.405204	37.259101	36.238803	37.574808	36.872123	30.780755	31.152318	31.607185	33.326723	43.691417	63.166107	48.588392	44.891179	41.847308	42.106548	34.976372	30.176989
1/4/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	24.732927	18.884344	19.002896	19.562186	22.45271	22.102012	44.360299	51.262522	49.252611	37.319571	47.897954	45.028191	43.902689	43.407552	42.664229	42.794936	45.452617	57.376031	54.069663	51.561823	49.896891	47.833516	44.738071	42.0592
1/5/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	57.736181	55.578491	54.398876	51.813359	53.558767	58.348382	65.725131	72.513117	64.565939	59.347337	49.572415	48.340913	46.444549	44.43391	44.488905	44.463663	45.894581	57.648567	51.509502	46.789204	45.021103	44.124336	43.505051	38.733671
1/6/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	40.769501	36.844453	34.786582	36.149563	37.931161	36.147605	44.742829	57.120532	54.805912	51.462449	55.978799	53.34749	51.048608	48.928143	49.301236	49.852557	57.295555	71.863897	62.313671	59.098998	57.918032	56.322678	52.749526	47.162378
1/7/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	41.323255	42.082497	41.634654	44.475966	44.348008	47.906098	56.797561	77.964812	66.903792	57.9371	88.306294	82.173969	71.386628	66.14874	65.098948	78.331432	104.319393	141.196019	131.466355	117.736301	103.859342	97.97835	83.222539	77.405147
1/8/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	69.148451	62.739267	61.528789	59.408902	56.228624	63.512015	64.317408	75.78359	59.293049	47.13989	54.416558	46.163568	43.972106	42.122836	41.319673	42.234137	44.6921	63.099624	57.430661	55.538913	53.097851	52.503165	47.836422	46.724476
1/9/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	50.49116	47.169378	46.958923	46.225036	44.515434	44.564896	42.563372	43.307737	45.276825	45.54202	45.048011	46.173238	43.739478	42.871856	42.546399	42.328048	41.326924	54.270912	48.397005	44.020664	44.059024	43.824191	44.187979	41.608841
1/10/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	40.55654	41.558233	41.877398	41.694655	44.011313	46.856357	57.785495	69.320259	65.034595	57.706012	56.803293	55.100714	54.23711	52.370753	51.251574	52.55953	58.717766	98.6302	87.049204	77.622473	73.102975	69.0359	62.392222	56.881749
1/11/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	59.597552	58.116948	57.724698	58.506697	57.06577	65.622553	127.01495	123.487615	95.967835	91.887806	91.623618	82.442654	76.248064	76.211854	72.093171	79.5391	104.997299	158.086129	137.261493	118.254742	104.496671	101.814036	86.614094	86.064696
1/12/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	74.311645	69.022376	68.113427	56.685868	57.600663	66.862386	83.426444	99.077336	68.462399	60.918973	47.559655	44.997317	43.299873	43.499784	42.866431	43.411008	45.634896	56.755849	58.067024	54.778271	50.763196	48.492145	43.29819	39.92808
1/13/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	45.777569	42.987541	40.383041	39.114729	39.390438	42.86066	56.821469	65.516746	57.777873	49.697836	46.440205	43.792576	42.339262	42.110468	42.276146	42.648636	44.550459	55.580436	52.28108	49.334121	47.979747	46.657326	43.470702	39.517554
1/14/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	43.156543	39.935924	39.361471	39.829885	40.704689	43.146425	51.685112	63.480603	55.301667	47.790368	61.568294	56.858189	55.17264	52.246871	51.376505	54.279797	57.914808	74.9527	66.681787	65.890981	65.749268	62.246196	58.448842	54.741673
1/15/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	52.849279	55.781742	54.523562	56.184743	56.179166	56.630295	58.012258	62.658163	60.941059	58.486303	74.53807	73.768336	69.814962	67.767125	66.693158	71.729426	87.643851	126.414378	114.592618	98.691632	97.334381	92.067854	88.556508	80.343638
1/16/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	70.888469	71.384016	72.415281	69.969354	71.406508	75.305447	79.022797	86.493439	85.364511	76.825689	76.972895	69.672011	69.80317	67.4188	65.890737	66.284282	69.853475	90.239991	74.26895	65.397236	62.485192	61.417245	58.931865	50.634372
1/17/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	58.430463	58.344739	54.154577	54.999658	58.123031	59.562545	62.035897	68.712833	70.265466	69.765235	75.360783	74.257313	70.872076	69.566923	69.620453	73.345942	74.585932	100.189107	85.114253	78.385575	70.228291	68.637086	65.795812	64.670346
1/18/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	59.982441	60.320887	60.342085	59.709129	60.863759	65.969691	82.439161	95.26129	76.70929	65.875309	65.454397	60.034503	57.617901	57.006935	55.739052	54.613774	62.926767	100.362957	90.620144	77.851717	70.919156	68.995856	65.219278	57.755009
1/19/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	67.305831	60.413316	57.184244	58.392796	60.916479	65.730034	77.992525	87.360751	67.056558	59.257383	51.652522	50.911321	47.673924	45.239517	44.602871	45.033045	48.365809	63.016035	59.74445	51.73481	47.751365	48.427696	46.383005	43.772647
1/20/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	41.258441	41.847789	41.628444	41.495571	41.218256	43.320996	53.250246	73.308005	63.723576	62.300015	83.088688	78.044809	77.208349	78.001132	75.689687	78.825913	85.787273	107.518646	103.819054	98.403221	99.018166	97.497423	94.545084	79.919537
1/21/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	80.138334	80.415162	80.570924	83.998813	85.865042	91.935008	113.355062	145.900736	116.858518	107.434074	128.097067	136.826664	128.362815	120.418834	116.690358	126.401832	133.489333	163.53491	149.788397	130.685335	121.314633	118.644336	119.960246	123.053868
1/22/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	115.149075	107.105613	109.216343	111.911334	114.473577	119.924614	133.23718	153.138108	149.616715	119.784637	92.538117	79.363424	81.798933	77.411864	69.636524	65.702199	73.05644	105.522559	99.468712	88.545115	89.03286	90.867704	86.30599	77.58495
1/23/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	85.73183	82.449638	78.40378	76.050499	72.089926	68.066451	76.004651	87.536854	82.162972	71.429712	65.905282	59.802547	57.637586	56.749608	56.116114	56.581913	60.806605	83.54092	82.374486	71.494184	69.255706	67.497638	67.550448	65.981697
1/24/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	64.739433	62.071914	61.27806	63.307854	66.111809	75.282964	94.681686	107.201361	85.215851	71.959251	71.795248	64.961669	60.99116	56.751262	52.934699	52.443631	60.797907	100.350278	90.079881	76.347546	68.078733	64.432901	56.530767	55.592182
1/25/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	50.447912	49.101652	47.112787	47.076974	49.304101	50.209208	62.605462	66.936658	58.378189	58.881046	56.683971	53.568072	51.423458	50.183012	48.9763	48.616057	50.088907	67.343084	63.736475	60.370376	58.157239	57.915836	51.365826	49.248721
1/26/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	47.242094	48.263204	48.455196	49.150721	50.614405	54.910202	75.594097	85.987338	69.684942	60.240069	87.345941	81.279211	67.572498	63.704926	61.466287	65.511757	82.256191	124.025536	119.086412	106.126106	96.573218	93.057253	88.771636	81.925985
1/27/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	78.223136	79.352468	79.161841	78.70032	82.843531	86.935082	129.987412	145.277504	99.889013	79.31298	68.898475	62.992423	58.189632	58.41867	56.089713	58.034075	60.552595	108.174626	85.374445	70.632498	63.98768	62.164139	60.036748	55.309395
1/28/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	59.797552	58.76438	59.337093	60.609154	61.217235	63.598944	72.70264	83.491631	82.101588	74.486961	78.47711	69.206652	64.420681	63.613203	62.784925	63.800492	64.075871	79.442856	77.933492	68.583006	64.140698	64.237948	62.093386	58.68892
1/29/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	64.536412	64.052926	64.482203	63.51504	64.992094	66.933072	72.937897	91.816367	106.39149	101.63894	126.559347	126.329293	122.425183	111.64269	89.895471	91.291642	113.362762	168.985547	160.032343	130.20778	124.370135	126.180508	122.58991	121.343913
1/30/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	146.712818	139.718882	137.597069	141.730277	141.067445	157.98182	170.859008	165.697239	143.062174	120.94053	113.046791	97.381399	95.710911	88.571627	82.947629	86.409357	109.468253	187.268083	173.085589	157.725647	138.749142	120.507407	108.26806	105.358467
1/31/22	AECO_RESID_AGG	RESIDUAL_METERED_EDC	106.177404	103.199991	106.175415	106.038424	113.168008	135.946121	167.469463	180.264666	139.358014	120.10111	109.820071	98.023787	86.351368	78.295146	74.201815	72.966613	95.073709	157.501547	143.308222	132.051657	111.22441	102.517691	84.809814	70.994252

Cap-Trans PLC

Projected Capacity and Transmission Pk Load Contributions to be used for sample invoices
Capacity Peak Load Contribution	13,413.66	kW
Transmission Peak Load Contribution	12,291.40	kW

File details come from the government source that posted it. Updated Mar 29, 2022.