Question about price calculation

[DiogoDaSilva]

Hello Cristiano @crispe ,

Thanks a lot for your work.

I have two questions regarding the price calculation:

1. Would it be possible to show on the HTML page the pricing factors individually like:

• Preço Actual: 0.11159
• PM: Y €
• AG: X €
• FP: W %
• TAR: Z €
  By the way what is AG?

2. I was consulting todays prices and I got the following prices:

{price: 0.11165, readingDate: "2024-02-02 10:15:00"}
{price: 0.23909, readingDate: "2024-02-02 10:30:00"}
{price: 0.23911, readingDate: "2024-02-02 10:45:00"}
{price: 0.23914, readingDate: "2024-02-02 11:00:00"}
{price: 0.23917, readingDate: "2024-02-02 11:15:00"}
{price: 0.23923, readingDate: "2024-02-02 11:30:00"}
{price: 0.23928, readingDate: "2024-02-02 11:45:00"}
{price: 0.2411, readingDate: "2024-02-02 12:00:00"}
{price: 0.24107, readingDate: "2024-02-02 12:15:00"}
{price: 0.24102, readingDate: "2024-02-02 12:30:00"}
{price: 0.24094, readingDate: "2024-02-02 12:45:00"}
{price: 0.11084, readingDate: "2024-02-02 13:00:00"}

I could not understand how you got the final price, I am using your formula with the following inputs:

pm => 0.08398 € (10h omie)
ag => ???
fp => 1,09583 (BTN 10:15 from https://view.officeapps.live.com/op/view.aspx?src=https%3A//www.e-redes.pt/sites/eredes/files/2023-12/Perfis_Perdas_E-REDES_2024_0.xlsx&wdOrigin=BROWSELINK)
tar => 0,1511 € (TAR Horário Ponta do Tarifário da Coopérnico )

My calculations:
(0.08398 + ??? + 0.004 + 0.01 + 0.005) * (1.09583) + 0.1511 => 0.26395 €

And this is different from your 10:15 pricing of 0.11159 €

At 12:00, my calculations give me:
pm => 0.054 €/kwh (12h omie)
ag => ???
fp => 1,0977967 (BTN 12:00 from previous eredes excel)
tar => 0,0237 €

(0.054 + ??? + 0.004 + 0.01 + 0.005) * (1.0977967) + 0.0237 => 0.10384 €

While your pricing for 12:00 is: 0.2411 €

@crispe, Could you help me understand what I am doing wrong?

Thanks in advance.