You can use an equation like
{scoreTeam1=sum(if(Q1_1=="T1",5,0),if(Q1_2=="T1",3,0),if(Q1_3=="T1",1,0))}
{scoreTeam2=sum(if(Q1_1=="T2",5,0),if(Q1_2=="T2",3,0),if(Q1_3=="T2",1,0))}
with Q1 as questioncode and "T1", "T2", ... answer codes, T1=Team1, T2=Team2,...
Meaning:
If T1 is on the first place of the question "Q1_1", add 5, if not, add 0
If T1 is on the secondt place of the question "Q1_2", add 3, if not, add 0
If T1 is on the third place of the question "Q1_3", add 1, if not, add 0
This you do for all teams.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.