Google tables automatic function extension?
In the photo, we see statistics for individual players. The individual table on the right is the result of all the tables on the left. My question is, if I add more of these tables, each with more stats that produce a different overall result, how can I easily update the right table without having to manually add individual columns to each function? I hope you understand my question.
I don't know what the numbers and terms mean. But the solution seems to me to go in a whole other direction: the data belongs sensibly normalized first and then can be run with pivot tables of any desired evaluations. Even those that nobody thinks about today.
So…
First column: the PV1, PV2, …
Second column: the ACS, KILLS, …
Third column: the Scept1X#DACH, …
Fourth column: the points
is a fifth column for the percentage distributions. As I said, I am completely unclear.
Therefore, the data table is an actual set of numbers. Some data points will have to be duplicated, but this will help you with various.