gistfile1.txt

var dropdown1 = this.getField("Dropdown1").value;
var dropdown1a = this.getField("Dropdown1a").value;
var dropdown2 = this.getField("Dropdown2").value;
var dropdown2a = this.getField("Dropdown2a").value;
var dropdown3 = this.getField("Dropdown3").value;
var dropdown3a = this.getField("Dropdown3a").value;
var dropdown4 = this.getField("Dropdown4").value;
var dropdown4a = this.getField("Dropdown4a").value;
var dropdown5 = this.getField("Dropdown5").value;
var dropdown5a = this.getField("Dropdown5a").value;
var dropdown6 = this.getField("Dropdown6").value;
var dropdown6a = this.getField("Dropdown6a").value;
var dropdown7 = this.getField("Dropdown7").value;
var dropdown7a = this.getField("Dropdown7a").value;
var dropdown8 = this.getField("Dropdown8").value;
var dropdown8a = this.getField("Dropdown8a").value;
var dropdown9 = this.getField("Dropdown9").value;
var dropdown9a = this.getField("Dropdown9a").value;
var dropdown10 = this.getField("Dropdown10").value;
var dropdown10a = this.getField("Dropdown10a").value;
var dropdown11 = this.getField("Dropdown11").value;
var dropdown11a = this.getField("Dropdown11a").value;
var dropdown12 = this.getField("Dropdown12").value;
var dropdown12a = this.getField("Dropdown12a").value;
var dropdown13 = this.getField("Dropdown13").value;
var dropdown13a = this.getField("Dropdown13a").value;
var dropdown14 = this.getField("Dropdown14").value;
var dropdown14a = this.getField("Dropdown14a").value;
var dropdown15 = this.getField("Dropdown15").value;
var dropdown15a = this.getField("Dropdown15a").value;
var dropdown16 = this.getField("Dropdown16").value;
var dropdown16a = this.getField("Dropdown16a").value;
var vacation1
var vacation1a
var vacation2
var vacation2a
var vacation3
var vacation3a
var vacation4
var vacation4a
var vacation5;
var vacation5a;
var vacation6;
var vacation6a;
var vacation7;
var vacation7a;
var vacation8;
var vacation8a;
var vacation9;
var vacation9a;
var vacation10;
var vacation10a;
var vacation11;
var vacation11a;
var vacation12;
var vacation12a;
var vacation13;
var vacation13a;
var vacation14;
var vacation14a;
var vacation15;
var vacation15a;
var vacation16;
var vacation16a;


if (dropdown1 == "V")
{
vacation1 = 7;
}
else if (dropdown1 == "1/2 V")
{
vacation1 = 3.5;
}
else
{
vacation1 = 0;
}

if (dropdown1a == "V")
{
vacation1a = 7;
}
else if (dropdown1a == "1/2 V")
{
vacation1a = 3.5;
}
else
{
vacation1a = 0;
}

if (dropdown2 == "V")
{
vacation2 = 7;
}
else if (dropdown2 == "1/2 V")
{
vacation2 = 3.5;
}
else
{
vacation2 = 0;
}

if (dropdown2a == "V")
{
vacation2a = 7;
}
else if (dropdown2a == "1/2 V")
{
vacation2a = 3.5;
}
else
{
vacation2a = 0;
}

if (dropdown3 == "V")
{
vacation3 = 7;
}
else if (dropdown3 == "1/2 V")
{
vacation3 = 3.5;
}
else
{
vacation3 = 0;
}

if (dropdown3a == "V")
{
vacation3a = 7;
}
else if (dropdown3a == "1/2 V")
{
vacation3a = 3.5;
}
else
{
vacation3a = 0;
}

if (dropdown4 == "V")
{
vacation4 = 7;
}
else if (dropdown4 == "1/2 V")
{
vacation4 = 3.5;
}
else
{
vacation4 = 0;
}

if (dropdown4a == "V")
{
vacation4a = 7;
}
else if (dropdown4a == "1/2 V")
{
vacation4a = 3.5;
}
else
{
vacation4a = 0;
}

if (dropdown5 == "V")
{
vacation5 = 7;
}
else if (dropdown5 == "1/2 V")
{
vacation5 = 3.5;
}
else
{
vacation5 = 0;
}

if (dropdown5a == "V")
{
vacation5a = 7;
}
else if (dropdown5a == "1/2 V")
{
vacation5a = 3.5;
}
else
{
vacation5a = 0;
}

if (dropdown6 == "V")
{
vacation6 = 7;
}
else if (dropdown6 == "1/2 V")
{
vacation6 = 3.5;
}
else
{
vacation6 = 0;
}

if (dropdown6a == "V")
{
vacation6a = 7;
}
else if (dropdown6a == "1/2 V")
{
vacation6a = 3.5;
}
else
{
vacation6a = 0;
}

if (dropdown7 == "V")
{
vacation7 = 7;
}
else if (dropdown7 == "1/2 V")
{
vacation7 = 3.5;
}
else
{
vacation7 = 0;
}

if (dropdown7a == "V")
{
vacation7a = 7;
}
else if (dropdown7a == "1/2 V")
{
vacation7a = 3.5;
}
else
{
vacation7a = 0;
}

if (dropdown8 == "V")
{
vacation8 = 7;
}
else if (dropdown8 == "1/2 V")
{
vacation8 = 3.5;
}
else
{
vacation8 = 0;
}

if (dropdown8a == "V")
{
vacation8a = 7;
}
else if (dropdown8a == "1/2 V")
{
vacation8a = 3.5;
}
else
{
vacation8a = 0;
}

if (dropdown9 == "V")
{
vacation9 = 7;
}
else if (dropdown9 == "1/2 V")
{
vacation9 = 3.5;
}
else
{
vacation9 = 0;
}

if (dropdown9a == "V")
{
vacation9a = 7;
}
else if (dropdown9a == "1/2 V")
{
vacation9a = 3.5;
}
else
{
vacation9a = 0;
}

if (dropdown10 == "V")
{
vacation10 = 7;
}
else if (dropdown10 == "1/2 V")
{
vacation10 = 3.5;
}
else
{
vacation10 = 0;
}

if (dropdown10a == "V")
{
vacation10a = 7;
}
else if (dropdown10a == "1/2 V")
{
vacation10a = 3.5;
}
else
{
vacation10a = 0;
}

if (dropdown11 == "V")
{
vacation11 = 7;
}
else if (dropdown11 == "1/2 V")
{
vacation11 = 3.5;
}
else
{
vacation11 = 0;
}

if (dropdown11a == "V")
{
vacation11a = 7;
}
else if (dropdown11a == "1/2 V")
{
vacation11a = 3.5;
}
else
{
vacation11a = 0;
}

if (dropdown12 == "V")
{
vacation12 = 7;
}
else if (dropdown12 == "1/2 V")
{
vacation12 = 3.5;
}
else
{
vacation12 = 0;
}

if (dropdown12a == "V")
{
vacation12a = 7;
}
else if (dropdown12a == "1/2 V")
{
vacation12a = 3.5;
}
else
{
vacation12a = 0;
}

if (dropdown13 == "V")
{
vacation13 = 7;
}
else if (dropdown13 == "1/2 V")
{
vacation13 = 3.5;
}
else
{
vacation13 = 0;
}

if (dropdown13a == "V")
{
vacation13a = 7;
}
else if (dropdown13a == "1/2 V")
{
vacation13a = 3.5;
}
else
{
vacation13a = 0;
}

if (dropdown14 == "V")
{
vacation14 = 7;
}
else if (dropdown14 == "1/2 V")
{
vacation14 = 3.5;
}
else
{
vacation14 = 0;
}

if (dropdown14a == "V")
{
vacation14a = 7;
}
else if (dropdown14a == "1/2 V")
{
vacation14a = 3.5;
}
else
{
vacation14a = 0;
}

if (dropdown15 == "V")
{
vacation15 = 7;
}
else if (dropdown15 == "1/2 V")
{
vacation15 = 3.5;
}
else
{
vacation15 = 0;
}

if (dropdown15a == "V")
{
vacation15a = 7;
}
else if (dropdown15a == "1/2 V")
{
vacation15a = 3.5;
}
else
{
vacation15a = 0;
}

if (dropdown16 == "V")
{
vacation16 = 7;
}
else if (dropdown16 == "1/2 V")
{
vacation16 = 3.5;
}
else
{
vacation16 = 0;
}

if (dropdown16a == "V")
{
vacation16a = 7;
}
else if (dropdown16a == "1/2 V")
{
vacation16a = 3.5;
}
else
{
vacation16a = 0;
}

event.value = (vacation1 + vacation1a + vacation2 + vacation2a + vacation3 + vacation3a + vacation4 + vacation4a + vacation5 + vacation5a + vacation6 + vacation6a + vacation7 + vacation7a + vacation8 + vacation8a + vacation9 + vacation9a + vacation10 + vacation10a + vacation11 + vacation11a + vacation12 + vacation12a + vacation13 + vacation13a + vacation14 + vacation14a + vacation15 + vacation15a + vacation16 + vacation16a)