Changeset 34960 for main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/voting-excel/xlsxutil.py

Timestamp:

2021-03-09T23:30:43+13:00 (3 years ago)

Author:

davidb

Message:

Changes associated with adding in Combined and Single Voting totals; adjustments to DL based on Terhi's feedback

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/voting-excel/xlsxutil.py (modified) (1 diff)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/voting-excel/xlsxutil.py

@@ -53 +53 @@
 
 
+
+# 1997:
+# Televoting by
+#  Austria, Germany, Sweeden, Switzerland, United Kingdom
+
+# 1998-2000: Televote, with Jury voting as backup plan
+
+# 2001-2002: All televote, or 50-50 mix if country so chooses, Jury backup
+#    2001: Jury: Bosnia & Herzegovina, Turkey, Russia
+#    2001: Mix:  Croatia, Greece, Malta
+#
+#    2002: Jury: Bosnia & Herzegovina, Turkey, Russia, FYR Macedonia, Romania
+#    2002: Mix:  Cyprus, Greece, Spain, Croatia, Finland, Malta, Slovenia, Lithuania
+
+# 2003: back to all Televote, with Jury voting as backup
+# 2004-2008: same as 2003
+
+# 2009-2012: Combined, except San Marino which was 100% Jury (due to size), Jury as backup
+
+# 2013-2015: As before, but how two types of votes combined different
+
+# 2016-      Jury and Tele given separately, added in
+
+def voting_mode(year):
+
+    vote_mode = None
+
+    if (year>=2013):
+        # Separate voting: Jury and Tele 
+        vote_mode = "Separated"
+    elif ((year>=2001) and (year<=2012)):
+        vote_mode = "Combined"
+    else:
+        vote_mode = "Single"
+
+    return vote_mode
+
+
+def nuanced_voting_type(country,year):
+
+    vote_type = None
+
+    if (year>=2013):
+        # Separate voting: Jury and Tele 
+        vote_type = "JT"
+        
+    elif ((year>=2009) and (year<=2012)):
+        if (country=="San Marino"):
+            vote_type = "J"
+        else:
+            # Combined Jury and Tele
+            vote_type = "C"
+    elif ((year>=2003) and (year<=2008)):
+        vote_type = "T"
+    elif (year==2002):
+        jury_list = [ "Bosnia and Herzegovina", "Turkey", "Russia", "FYR Macedonia", "Romania"]
+        comb_list = [ "Cyprus", "Greece", "Spain", "Croatia", "Finland", "Malta", "Slovenia", "Lithuania" ]
+        if (country in jury_list):
+            vote_type = "J"
+        elif (country in comb_list):
+            vote_type = "C"
+        else:
+            vote_type = "T"
+    elif (year==2001):
+        jury_list = [ "Bosnia and Herzegovina", "Turkey", "Russia" ]
+        comb_list = [ "Croatia", "Greece", "Malta" ]
+        if (country in jury_list):
+            vote_type = "J"
+        elif (country in comb_list):
+            vote_type = "C"
+        else:
+            vote_type = "T"
+    elif ((year>=1998) and (year<=2000)):
+        vote_type = "T"
+    elif (year==1997):
+        tele_list = [ "Austria", "Germany", "Sweeden", "Switzerland", "United Kingdom" ]
+        if (country in tele_list):
+            vote_type = "T"
+        else:
+            vote_type = "J"
+    else:
+        vote_type = "J"
+
+    return vote_type
+
+
+
 def load_xslx_sheet(excel_input_filename,sheetname):
     print "Loading: " + excel_input_filename