u/Fetish_anxiety

I'm trying to do a program that would output a spreadsheet

Translation:

The selection process of proposals of RTVE for Benidorm Fest 2027 ended last thursday at 22:00. In total, close to 900 proposals have been presented over the 115 days the submission process was open, 350 in the last 24 hours before the deadline.

After closing the process of song reception, the best 16 proposals will be selected, which could be increased to 20 proposals, as it is established by the Benidorm Fest 2027 rules, in the case that the candidatures have a high musical cuality. Also, the corporation can invite direcly singers and authors of recognized prestige in the current musical scene.

RTVE brang forward the opening of song submissions for the sixth edition of the festival for the first time in its history. The objective is to continue to improve the planning of all the selection process and posterior work for the selecte entries

En mi caso entraron 2 veces en el aula para hablarnos sobre erratas en la gráfica del ejercicio, pero al menos esos errores no afectaban los calculos o el resultado, pero al hablarlo con otra persona al salir del examen me dijo que las gráficas no coincidían, y que según una gráfica la fase inicial era π, pero según la otra gráfica la fase inicial sería 0. La verdad es que era una persona bastante lista, y cuando me lo dijo me dejo bastante convencido

Edit: ya ha salido el examen, y no, no había ningun problema con eso pero aún así, seguía habiendo dos herratas que sigue siendo bastante vergonzoso

https://preview.redd.it/8jf2dzxju20h1.png?width=1045&format=png&auto=webp&s=d6008b03cb29fb6ae8aafa21b8bbbc2deb29de1f

So I put the last 4 years result into anexcel and basicly what I did was put the results into an excel with the running order of each participant, then I multiplied the running order by the number of participants minus in the final minus one minus the result (so for Nemo, who was first, it would be 24-1 so they would be counted 23 times, the 22 for Baby Lasagna, 21 for Alyna and Jerry Heil, etc.) this way I can take into account all the results but still have the top results having the heavier impact, then I added them and did the average (which is under "Average best"). The "Advantage" refers to the advantage that entries have by performing in the 2nd half and it is calculated by the "Average best" minus half of the number of participants.

So lets put an example of a year in which there were 26 participants in the final. If the "Average best" was 13 then the advantage would be of 0 and you could say that that year there was no advantage by performing on the second half, but if in that same year the "Average best" was 15 the the advantage would be of 2 and you could say that countries that performed in the second half had a strong advantage.

As the results show, in all the past four years there has been an advantage by performing later in the running order but it has become less strong since 2024, which was the first year in which you could vote since the start of the sow and not have to wait until the end to vote. It is also worth noticing that the running order isnt completly random and it is made taking into account that entries with a latter running order will score less. Producers will try not to have the ending result being affected greatly by running order, so they will try to make the best entries perform latter, which could affect the results.

Australia wins a semi every three years, they won a semi in 2016, in 2019, in 2023, and now, in 2026, after two consecutive NQ's, they are sending an entry that could very well win the semi