Hei
i have one matrix with municipality numers vertically and the number of students on each of four schools horisontally. Like this:
Table1:
LOAD * INLINE [
Mnr, S1, S2, S3,S4
1, 18, 2, 10, 1
2, 12, 13, 4, 4
3, 9, 12, 6, 15
4, 3, 17, 5, 11
];
As well I have a table with the expected population in each municipalty next year. Like this:
Table2:
LOAD * INLINE [
Mnr, Population_nextYear
1, 35
2, 31
3, 52
4, 25
];
I then want to "spread" the population i each municipality next year according to the school-preference in Table1. This means i have to calculate the percentage per school per municipality (each municipalyt should sum to 100%) from Table1, and then multiply each school-percentage with the expected population next year in the relevant municipality from Table2. The result should than be a Table3 with the four Mnr vertically and the four schools horisontally, populated with the number of students based on the population next year.
I want to do this in a set analysis. How can i do this?
Regards,
Torbjørn
