As you note, SAM's Merchant Plant financial model requires time series data over the entire analysis period as input for energy market revenue prices, and any additional revenue from ancillary services. Depending on the simulation time step, this can be a huge amount of data that is unwieldy to work with, can cause simulation run times to be long, and display of tables and graphs on the Results page to be glitchy.
Unfortunately, the Mode options in the Edit Lifetime Data window do not include an option for a daily rate schedule that repeats over the analysis period.
One option would be to write an LK script to assign values to the input array. Here's an example of how:
analysis_period = get('analysis_period');
ts_per_day = 24;
// modify these arrays with your data
daily_price_schedule = [ 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40 ]; // $/MW
daily_cleared_capacity_schedule = [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 ]; // MW
i=0;
for ( y=0; y<analysis_period; y++ )
{
for ( d=0; d<365; d++ )
{
for ( ts=0; ts<ts_per_day; ts++ )
{
arr[i][0] = daily_cleared_capacity_schedule[ts];
arr[i][1] = daily_price_schedule[ts];
i++;
}
}
}
set('mp_energy_market_revenue',arr);
for a fully commented version of the script that you can download and modify.