Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- #
- # base data: https://www.hypercomments.com/api/go?url=http%3A%2F%2Fwww.eurovision.tv%2Fupload%2Fvoting%2FESC-2016-grand_final-full_results.xls
- #
- # usage: ./esc_sort.sh Germany
- # or empty or some other country eg Russia ...
- csvfile="H4sIAL4aOlcAA319S5MmuXHkfX5FnXRKoyWAfB6plSjRVpTJOLuHPRZnyoa9albTanpII3+9PoS7
- RwQyv6Z1qafF8sxEAoiXRwTy15//8Pr+6XX657fPP3365U9TnaeyTXWZarW/16ks08v08t2vCfxf
- f3/74Y8vv3/78y9/+Pzph6mWqawdVptdWPtPxv+fP769/Ofb1z++fXx+ff/x5/7rxx0f6H73Yn+P
- D/j1398+/vD66f+/vk/lnMoDXuwpj5/W/5eM/fdf3n96/fjbdPTfnf3Gj79m+5mKo3779fXz36al
- /89t2qf6+Lv2S+ZA/Pzx+va5Ax6POzrUAPsDGQ/7518+Px72+MdjKG3a+iO3qUOW6XDQ9399+/Ht
- vU/F0Sdm63898Mdj2M1B//b28afX97/1Rz2e0ae89H8UuyS/328+Xt9/eJvs3ez/bDYewwzIf33p
- 89pffe8jetwMM7w9brTGpP7y89eP18998LjL4579X316a6zt3/788cvPtug2531ZZ1vZcU2/f6xQ
- v9Xj15vdYrWlOvv/m3H/8enrH3+xf/WlO2xku639/Bjty7TEkz++vH59/PexF/qdNpuLw8YwD7f8
- /S8///z4zz71913tv/1fe4ztz6+f3h9ztWIVl8m25pZH9fr1L/1RNozHeGzz9HGV4Un/978/Hnd6
- s9+sD5DtiDr1Bdoc9LvXz19f+yPK46/HsNfJRl/Tff7t7cvHT/15kI4t/YyLbWv0+O9mM27z+VjH
- YhttGNj7p69vP77870/vP/345SGxfZPN/LGJW/NNP/70Zgtg4vy4X7Pl7eN8mR4rz19L/Eu/2/n4
- v76zS5/dF8dcJL9PGgUFQveYnoS+yn3BZsMLYcdzvnlBkvu68qdvKf07YyX3fQ2riS0E45CgEQfJ
- 7w9tutdsq74Mt6P4998t2qRLVk2aJWmAxfbVav8tfRcGhgqgdpnHDoaUj/MtDdB3BPahyX5Hn8Mj
- qQFK+mOTvjuCCqCafuOw7a5dTXQtqPl1FYAVPh8D3LijY42hAUxT9r2y2p+t73i9H2T/lE4u3AW1
- DeNOog8diFW3LV3HhZfsU4vsFMc+HXUAUvbX/tv+p2zSiTGxEP9j2iGtlO6WRwbx70+ASVltY5r5
- yk+T/JuCroVWC8JttoM4qIA+VZiyrmyOrnp9qSn/6Y8tzjEuTR/TYfdvfGKt0pIa0ij5fbawbZo2
- OJWlL7XLtel8/4Mpc9RVso9+R9MWXRhCUfkFN+E2kSoFRtbeog0XJOGGwVtpGEs4DA526aZqq0to
- xBFJ+S70Wfom22hiLkBIONYHa1AWGtKYLIl3n6vdoOEpOCosPJYI9gGLNj7UzTzcGJjKPUuAQynm
- K4z4TuWydTF3jAR9lRitnL1yXR7ZcTO6m3bT7IYk3gXCfND82aPhi4y4kOYta75uxUt+riS5i91h
- w2zZNDiQklwXmd4KbUmnJcZn0txly365mdpap7x3Jc7d9YOdXri1xldwc24jOvnH1jehIMxdpBaJ
- 1wLjblY/LS2F2p0k0/N1dZMRW5/CjV3f90mjpaGtiiGO4n2aF2brsZq+W7oqiPsmy15ta82a8SRQ
- gw4ACOq/LFD8BF1VQLUnnva3KYOAXoX/pB0whVyGubqY9QZD2D0U+CN5mJJ6ugi7Nvo5rKULfTVP
- vb+tpDDv7sGnh4Gin9qG3Z2lfhN2p4uQdmPIfYNnOZsu6Wu4O8LlfWdkgx1Um4w/cS7sXb88AO0i
- S0nWZ/k/TR5RNz5xq9gO0u/9v2b6Wqwt1YENCJqA49uGmZBbb9aEEdqSrBBhg2nvf4oc0D5teU9R
- HRwmtCvW/YQvTogUQTGFsZjp7LNyxKBMBcC21e6WQB6yzkta4NBbmkWHUGaca4FVTkm7WHUCqQiK
- jEX/e00GI+sAGOA19k4dN+xFrndGyfApEBZluATbVOxB/8RMiIUVIU8u2Ka0qVkabfbLiL3KN8I6
- PAAh/3y95CrnC3UhzG0KxuMSyXCDRt8s3rYILaNotRvdXW7K4gKckJDhzcyOTe1hYrMN0yAB3i0W
- Wk2tt76hMkp+eVN0uUnQ6/Wp7pzPdEjdpa43rPzzCsMEW+cSE7gI0xeG8PDATU4DluJ0uCCHqZuu
- h+uwnPTTNwX8Vbpyv46QUg2ipsz6x+H6N6Ah2XyJ00RSIWV6PCXb3sB05UHK4HJHyncZ/8D9TEOE
- jNvwoKZ3++cKdZIGyNC9ynH3YOH2LpL06g6fyfFsQh4wBfDYNWYU+25bx/1AQV9SfLUw4rIQ67KA
- dOUPqlJqrNvkPHHnzYYujJTrTR6kGjwozj8d+1AJr31juGqY6Tn0HWTMVmCuTB4YAljxk6Yn3/Pm
- 9JtvAq82L7/wmchrssDFrAHcLgGlNWDyDxriRv9IKJr9Rt3FsXpQ4DCa/SJV2OR8b+MMSWsYfdEU
- D5oZfoiuYG71G0O8hk3vAFcWYCvcxno8IKA0xUm9ArmBh5lx0hQb/M6TfB68Kp9b1xOnOSHVYgYQ
- QLHAVBILjRNpgV1b0d+RGmKmVapFVO44slAP5q4bFSHPM22rCAKK0VwIVTAn+XZJN0BIQzf4yKQY
- VoURK4OoYVzUCiXFYiaecOAEk0ZYaE0w/K5pHAJt0J0BsCM2C2t6lFQBxbvIpXSHZFggsH5kZcX6
- lXEWrmzeYphVYcUqTtVvTBWwBpe2muv0MLXfSeyfUnWHmLq+CXBHA1/l2tzRBhXcTerCGTJwdueX
- 5G+JOntJN05xPDYAOAJs/wykaJvxLtgKzTcVEHIEDs51t019tRPGJZrmw2gYanNh5AWsScstiSwT
- zl35DSFLFXsZOs5wFOrF9+7mvocgkmezBv7g/gNX3mc2UfTkiIyG6CR2LCxFWlkD6IZBieA96cqD
- mpvFEG1JpA0XIr1T7D0PUcbFdLE+GXqdNMBhJQwnqV61DNA3rr4wPLJ0Zj9MUGEbhqGFVJ/kd+ua
- nFvh3NDPiMrWqcrGOIbe/EyrQXVUktBy1SndFb5ANecLyYpxneCgFXB+C7daizFdI/mTHCMN0jE8
- 1q26PHgEjbU//KVL9ZefH79++aeXf3/7+PvbT1/+8uk9RfULmSUsnbNBTy+66AVQlSB06myB2dPL
- bpb/IGkTP+XbDx0Teqs4oRUsc+mi8uwy5wOqMiFNP5TVZ1c5OcCIuZGW0ZQ/vcbpf2a0CmMECcvT
- +Y9cgHHog3Pz/BIpn0UM6KIQ4x/MXvYvFlmcwaF5dhX1EoIvMAzmBz5HS0WtMv1FhOE/mICReqgm
- dyBLuyA83X1UXo2E4xJ8/zefQkWGRGvh34fpzWfw5KJsFPOTrFz9B0+JeAak4JEM3zM8ldwBIn+H
- kenG5hsvATfG9pRpH+nObw5IfEYhCa6cmSzss2uc2+CCpFzRU7wrRWTOYETK4sb5+W5kKNRi+ai2
- /sFudGeo2LK0cIbooT19nUt0hPT2Qi8bxOu3nxhe0kzmaAkOxWVXStSicgaK7noIdHWmNhohF0Sp
- CV1wU5c7p3g1/dDfP8OzfrS4m3mFRnLGdJ3AKfN5kqeuEtthEKEIF3GlO122EefK72AmnHxTZywd
- paTHzKALltgushhNONdWi6o8vJCgjs9VOLSKkZyDyhiAUk6FhQg7tyw9Cp9FV0erLSQWFKm4WEoy
- oSVitXKS3+5i4q/LiMgUqDExYrYDk2hQJM3pOTlvEU8N1wnLYLxpiaBdwIiIZuzcxRzizdSdj82U
- yU6dsJF5R6o+Bgf9IYL8FNt32anuO8Fb87CaZKjjoCpOSgcY8BNeUaw8NMMGT+JACYwxti+XVQLH
- TD5bKgeMWYzsIv2KYUGFNnc4/MYU+EY5xn97dcJ3mn4Ju4pLUJ5TJRGC3ZOhuwhg+piBvUk6aUwz
- OxhzvnWWdIsq5klsAFdGSHd+ZO+rNvND2gSCiK/Ij+2sOSo24Q6BdDeLZg8UxIDQj2nxrKfHJtic
- s5SPkEkJGJ2kLQ/hEcpDpyWyFrDAVFECUgNUZ0R3J1cECS6kKMXG7H/fLD6tLvoLHdpCqXnIvi8r
- RB9jnj1XXRAL+ysybqoA7CwpQ42BQJkmJYsjz4xOhpAS6JPrZ3JtCxlPNHEOR1qZf1phf6YXLa2I
- rY6UqBXIxRkMolxnT24IB3Heo7yIKZ9xD15ynJ4PWiV8w/yDQPJ0LmIC6Ggf3kWm/Y6eubiIizKc
- q1W/Ncii7eEHCOvpYdDGMBG2rnqaj7h7/gMJDDijxd8d6FvRonIlMQtzxifBpuozJ4EZXIe5VJ+g
- 61bza5HYJSQqGmbqOqXz4jYU6h3h84J07mrWSbPipYrKtJLA2MU6ECiRbiTdN5V1UfKBkkiL2WSW
- a5ZRJ0wmfTEGDVUC/a6bAFGqxH2kH3gbmswUWDQqc1aCrD5uyOlKK+OivOXxJAt9UOxVWQS3RXuD
- +62J+fBUCQw5YU9yGWQ/fVSQ5ULvbKGASVw4KkryzFCYe7oMG9AluU4eJJ5J1wIFOT6MA97hLFgN
- RaxbZCiryKDC6DhvX1llUSNICUI88qguAlxZQQmCKYrXdFtPZDI2rk6OXcTRpbipKA31HDOkZwTf
- hJN5xg350v1+RSYtZ2UidrJd1FHjFZLUxcz+lkPbCxICKzN+qIaLgnHBMjexSIia5m17Bg/LXJC9
- 8Xo7hE0XuGQ5/UHEcwUmJ50pAU8jns/G4WRCabbJlvCGL0gJuPv9lU/gtr0siwt6UwXrGnkY0z/j
- BXLfa5A6J6urngxbTvwqn0bFD9rUI3xIfrKQ/ADf3O5o6YzVNjQVlemVK1JqQ9VBofdolC+jBlcw
- qwQyzcuzQTtP4HtjVxnLHe0MwTlkMeviVmHEkyGorl5WZlXuO0rO/ykvYE1e+rN1//RKDmslOaqk
- +XXMF52zQm02pChYmnR9gByHXTRbofrsK3989y9v7396/fhvVzssVziY5jsS5Oo37Ek3noyE+ysK
- f1dOKNPbjGNAqbqwl9Kohdme0lgrnu/rrsMmJT5HxjYDo+RZwR/13TLCPE1qzqmV0nrpus9PVFYg
- Lb0jRVNsDwhFvbPSGFgTxU7uyUGppgIZQbl9VDnCUddsYm7pYMNBEEhqpmiFD9J90Is+vzmjsrnJ
- VhWALzG1CqYgrN8xDCy0yaqCC+W/MmxseUDdns0X6EF/pigBc26aUmRVNJpwVB4gKwp5w0ZJ8aF5
- CFHMFB6qo8jj8gIp+L2LGKw2PC9ypFXlEF5OJgy1wknHq4UHkO+UiiZKpOyjoWNYpE+vTDZuXE7s
- o24CfGSjHjhggeqKEm/oaL9nBA4LHC2ULVEd/evPX78MTQ+Nj1ThBfekcE/Lo1cFEJ4BE/yqAg4K
- fmkTVUFgMyOwUN+zZeDUDhQ2RQ+VzTbMVIyvRQ0we/H0yUr3AUTab43K1aLalmGO3AeZRSDuilCX
- AanshjqLknssiCuBwtw2yww8bhZQkcQ+ac+vqNp9XOggaYFKTrVKo2Dj+BRnLwOJip15/4cM+Roz
- N1F9YTfbWctj4/sbUgVszNIzebxJaIXLSVXLu5/mQ5oOiAdKAxS5J3x0HadV7oN3zZiuQ0V1V7A+
- OCiBhe09iOGwaMPYoAeQDjpSEasAkUWAOayodH2AHeJVEngrUVk1PSbnCbDGU66SGNbG9BuzTo07
- Ek65j2mU/VVFPTPDP3BeftNEG1RSMwep+v7w3/zq//3q9796+d3rD28/jnrghLJm+QPi8hv6Wjal
- VGZRpw/Vwe3Cq15gsXqliJ42gberspNQyPFV1dvCy7tdkwsvFmaeRVU9HVqwDrtaXQo7q7oo3fEe
- yFifGNWaOXPP5jcqrBduprDCN3RiGSHOUe73dOypmbKKB6Wxac+viJrN4inIrEhvF0jTMK4/mGmH
- U3JfMVc4O+vF6FQ+VMl9N+VWjdzxRrm9Tw+UUHM+2ujOPp47NmVDF1QyoU/RTct9OJ4INadlzxWR
- N7ATIqeaO0/yzw9lcR84AptG7b+BIaE3cB+6d2mt3IhbtHLd0OG2FEtPVPu7b8o7Ftorumia2jK+
- sfi5f3NOyt/V/vMNgDhyVqZDhcFPL7jHOHWjqKvL6PmDpOnUhVs3NCQi3P7Np3fbt67fDtFAJ1la
- bTICr44OxRuWsIKDFPZeHV7ZdhcpVGHHQId2vzD1RnsnrOuuIhpBhXCaPQKpszbSBY10KSIYB1FR
- VRHHBWXse8K4eoIm2FlyudLLFsz9G/ROb8m/EcRVUVN+ceZ0yyYQGP6NmVcTGjTOdR1BkJIfs7zX
- 6qLToxyf3OTfNHCbYdV9Zb0FhHUR2sPS8HpJujiVrj23++J7nbjQLPAbkTT00NAfm5wc9cihkFNy
- T6D6QJTTPEhmUJdodOoFUXYDGeEyTi5VRyo/XXE8gGlrgqQxDugX9enTqRJKns5h4Rua6RqMnC+5
- U6yFlcQ19/EOq2TKcoGvZFJlXFqM6VIKOpPdWlW7V8ZbJj9HNWNKyRkOm2zMkMBnWoNuIeoJz5GY
- g+LFu4Q/42BLYaURO6IJzcJfVce1sptkzjdNoo8sBPd9+C3AUfItHACUgw0ExP6UCqGuA+uveZHY
- Nxs0giWlGYhJvgh2QPUORCISl7qDOCSxPKxBtG4y3Fmo06ioOVMpj7loJj1k1EJFUfcmvnRjXJ+e
- mI5oKOmhofIBS3TFKT6/qG/9zMgsygcTRWeKVwgLtrMwuc2sZ+kbnWNj9eeKJLKY9a6GOKo4oWGR
- lRBNkp7loUqFE+3NLWRWCZMQG3vF2i6b+VhDyvCsRKfPV8nPkwzDyJ1mCMAWakDXOIVm/xBduA23
- k/yqlQUdl0w2a1DRvQlf0gIGEOSOuQrvqnSYSiYoZ8LfGQqaq8Wj7QzPJMWmDMpJqgI7WNDUyqGq
- HhhDaF/BPGnC5EBRIUh+rGw3qZ5S1FTcEij4iUUkqhYP0i6gN3IUSHuyVoLkfm01stdUJCBcYics
- Dw+SD801woTEn4qrVEn8ULo+s0niK9yJ5q5ALK8fygD/hFXauzwif0XKfFEj/KyqwTbgcje3pdsa
- e6s7P+EPDYYSi4lVtIA1bhX9m0WbCJIKw+0jAzlh1hrrw9r1bRwY5B7FSDl/LEA0dbE2PjlhwtC/
- nycl7FnLe9nTqlmoysaUiCAz8F6IZOF6U6XPuARJpkVlslgQjoW2mB+3pA4tEimr3QuYJ/1ZOanm
- 7TnCPzlxZcNuX5zKEvZy2IrqNYZKWWFzIXaj78b9dw5A7+vcSbmU0OyOUUFSSlMiMIq58eKFRQcj
- NcqkpAdAT3gu3uUH2XEEJdX126Hhj2+YWjSWaAwBI4OtxVlLR6g0i4ujw8RXjZ62d26r2IHkgg+e
- wrpFtb+nTTMuWehVlR7USiu1Eh/sGUl2uhcli+pwQ4lsS8msNRGKPkBPRG5IhnI5xrtFlwbai/aI
- wQSJ4HydlotYA0GRVWEN56GFzAImIdMRXm1iX9PLuELwZqIya0b2CnaKY7oXF6uzDHbTLSbvS7k+
- dRIJyxBp1j7e3rKnfUaZM1k67jfg7gzils44ORRrEf0ko+g1DEfqJiE8G2uoFhQjzmw5Ei5VGC70
- yg9vXyCGAl1lVheSuCU/UGba9++sErDhpUOqG/rQFqYnuTBASaQPBT6FVIhcEsDy8Uk1CZrXYhMX
- 8l+Ul1xRKSJE8szVeYfCXHoPnNQk+Kv2HdiR1VcVgr+w9KlEp4LezXuy2KlYo8M8jTmRdk2G3A8F
- mod9lA5NW6Xc1iw4wF0Kl5ZsNDk0b1DYtX4ltVVrZHFykjxaHmMwbFjJu8oKN2iQ7pZvwqig+ISF
- 2HAowpJXWLJuZdA7GWZ0Y+ZVIWvACiPpxs5paDiXqLogUXySYajDZo6+AdSQJ5sigcknJVZURCzJ
- exXsIuQ7wo9anC5N2KuIbxOL8Y4JOr86NIn3ytAXRwQYnxC3pOgqKU+W04M6h3ka0IojkGLetCP9
- ld3JbippU/kfLLKAFN8DgYF5szr/QRB3spWaPOXYtuGZUUwIRFXMwdUVLtUUNllaEwN4oD5vydM+
- vEGGmW1fM29QYjWNygXBuPlbUpAVv7Bszo+LEy6ZbrK5SliBxvbHRse0SgHZW1uG+0mOKyPdg0qU
- XooPjycgFsZzLcpDfWS02vg14mKTn4B4cH0gPttUQgovQTCdflZR6r+nIvlYcXZVytFYOL10TIYl
- GlxyxhJIBvrAbvK80Vhwi6zjXeWRF5T5uPeE+ojf/vA2cuSs/IaBZU2Qoy5CfZp4coorDlQS9N5V
- HU29TE0IOsbX9EKKinGx3YV1s33Iu2iTerde0uPZ/qO++UquhULmqLDdC16hqAEww0L+Kx+1y3+s
- AzB55Kgx2aOBRZjEmCkLgCipjmOLqsMFDC1V4UMQBaHsL2KWN5gIyoNP79CoiDZF1+q+shT9k/Ea
- qgrctPkLkh9X+WaZRaivAy6JvjxsnruiIMYfTOFXHbOpywplLowffAi+ySgQ8Ps+LhhwuBZi7Wd5
- TT4qLz1mpdnBlBb1vXAu+wWURfVTY8Z9ofpj9R03bLIlQVL2DLKJLR2FJsMqQQmeYuW95MMHdusg
- YKCjFgw6SH5TdVYXdTnogAg6zb/9uIg/24dWEss1Ye5HpGE9T++wyui7/DfIxRZRi7AXBbCRWGCK
- bB1GmhRA0RlpDDVGoLqDKiqgdhTLbxlB40+zz5JKElk+M+63z05LO00ukHJjVZmF4MkFcbHfVOkk
- wlZr9jHIvc6g2EHcswNCoHToaWWEwGocyv7HTfYxpeAQdYyvL61Lv871YCnBPgzNzz495YscTDJl
- VJJ9RS+bdiiMpz82HZVyajYq3yTf0vuN6ZZXSi98HB+eMuwwC/Domgvtx6AEFOUU1udZFYGDUmOg
- 2bXCo6ypuz6y/O9RfUX1eQ4PTPS6Dvc5k/kflgqyukUwBwtmFvDjqQ7YwDYVpHe7LmpxS9n+RX1V
- 65jspwQMpx+D2V+ZiBTkKvwewPrRvUu+442L2yLiqzpdMuGzBiiIl2i7VftKYE6Pq7rn5BDS/bwG
- 8EC04/5sfuuo7oV62LxCmQiZ80Wlm5XaRnIBmLv0qDw7E7RmnEv2yUJrj5AJoFQfkdeFBeau41Sl
- fDfqPY6kkLhacZC5skdUlsOAkjU/2MhdxLIm2NBHpAoxr8cLnMfjtJYsh4CzT4ybcsRlO9lIqS2O
- ywR5gwdapAkX6GWOCVIMT8BG5PVXREQhn5we74glwply9nx59+86ri7FV1Vnyh9Lb6dlIRlRIuq0
- wvrOpGhUN+KtirrgcRjHcNfg06v7+eISsMldeFcv4PNqPLuToa6cm+qtUFsWsRvQN/EFbykqgi6O
- Qcf0NvOPnnJt6aaj6NLKt+ymGcyPOjonnYeE1LXeN5WrrOm4noVMGlBx1sii+nMnZoFIgXhRqyiY
- JO1+g+UDyCFo4r3w+ziptCSmO7hzzlIS2oMVsZ5/4wrFkYaql/PEMd/Jzycl/SC+nPrBQElYd+Y0
- C6uYqEjxND+bFBVppdLkS2UZSlz5OrUIeMLuYlQmrKZkVZMgxxEDihadOjkt3TxgM1Bw5PiyAY9D
- m005GoLCioxRYy3KDIHnejpjtk1sG/T4NRaBxMXKGieGMfml711+xVXExokKtEvooaMhFrkBsNt8
- f6fNVlYgep8S7kbYUyebwcee+i0Iv9fUos63+BkELcAjNQ4vy60VtBSRuf3+VKPHmjJHxNHMKiVL
- s3XKuAsFiT5EKZUpVUxrelKIfcIR8aa4mERPYiPjdXgcyN+7k+35pBqcWBqRhPrQu82cCPqKhKVT
- iNW3Jqqg82Ga1lTvurmBUMeL1jWotUMJjMakS3pifF2AhFRtLKlKoJy/1smBHtDrecNxZee0Rlyf
- 7kT5XsAcL1ONYloNSGX1pvsrWyrp/xAzZqVHgp0Q9swsNkW7MyhL3CR124M0RSkOdFaeaTBp4f+Z
- voQG1Hhu5aTMb6nPpQ6r7BLsqZmC2ei6OeZaArzzHRZkl9cBdBFfecY0UbtLr1/w7PNAWzDC0fgY
- l4y+sifOzuQ9BDidl4P9NDvcJtaBnrw+qHE2Vi2O96MsY3+jhK+c15lKFrqqtdDPAgicbHTEQ2UL
- Ox64fBihHGOYEy2kQ4M1h65aqUNQWRo4SvaGmQCDoqOV00xfjiTE9ubBGmnRo7i06NiPhbZ3HJ4s
- +C6qSgew1Os8u/x6AYV3yLULNIx0/NTIAKSn+zHDB8t8VSkz3tB7ZPQNlFAKjklJLlfH/FREgLx/
- llFik7dfL0+Mb4Qsk05DZYPSZTWo0lqytM4Rp9HdOPKiQ+1L/qpSurmUALiiMns2ousovEiuJG0q
- aZKv/+Kwe7scq8ZmdWcsCX1ztZuqhRUjwTIDPXbyn6TIWCHWGR3AUqtccZfgjM55oMSQLVxmGVP+
- Nn8/4GBigAsZU+LsGD3APSwREIqhi2qfqsKdkmYhn5vl3oQKcwLmEfRuYe/i6UH8OiWzi1JIC0nX
- uElOZhsXs8NXsuhQa+jtcOrW8eQrX8vrS7kF12ixj0clZ3xh9S+0XZPU8XGKnFWEVb1gfE0wSnpT
- PTbG1m2zRsXUl0imOfwsDsgPEI+wt/It4jlu0JvSiY3RDeys1ox5LT/K0Gv0b9P9iTQZPMChbJ2P
- vH7Uq1AZFCWrdDsKKg4d2KYWDQ2/+/L5xy9/Sa52hQvMze8MsXD3U4IrP+hQSTFm9LNDQIuSoHNi
- qnXBeO4nMg5eZwHdLGj+9ofUCntEynBPiOwhJu3yYRtHqfw7im/XFNj6POXa0ZLKR1XXIyBleJlO
- r01kUbYQqb2djROqV6ZHIqAOvSKjQ3nXKSRCRYM72/w3yjItqk/xYKBRIuxcmC+zB9bQYXvmAvwV
- 47AMFeRmUyVYdr3FTxWvLvQnpi96YeIRzLNfUTAX5wZJXcLQ+rBgsiuN8RZkiI8oilI2Ne+r7Ksb
- ReGyky5PRk66MH4u1qzqLq83joWObrBGRpH7ut2X5pP39+5BdVGHaFwXZ33mGR46vYGW2m/rBSo8
- AgyMzNrN1pf3r2/vbz99fMkaYCX3u0Y4nID3sy0Z7y5jbiNd8kQP4PgF36zteslwPJZ3c9bUqpbA
- cfTOHpVW4PUTKkrTPDJfo746A/2gC5WAqtHhMsh0fLjzYXYVcs4JKb/dW5Zlrl2/OjSd3hvNH2sq
- VEvYOBET9bqbt05kFFXDCXqHtgH52cukh26YwYfga04FYWfeBJ792ug4LOKwRiCVxA5XgB/0QXY/
- oVIBm/udlYWu0qvxbKkKte5v9BOkEB2ZtcXocOcReri+JZLJCZk8StcbjE+ls8ttYaJXTH0audE1
- AYOj82iJtc3Dloh0WFNpnwq7r4IjJbLgeBKYgjj0JQ/y4kA0cmvhrN82Zwr8TfO2ST7uy3f/+eXj
- r69BrpvUwAtWYpeIJ4Sd2rdUvvkS97t3je5o152DDiZ0PBrjUKW0qkvTTT3G3yRbLpB7xukzA2CM
- NhRI2fII4OUwypmtSAi3NCPh8Vf2vk86Z5aQOFRvkypZGEk9VB1Bmaqbw12IE3GIk1ZQvO8aGuaN
- KGqFlpuJrOC1L6fPaDoi10hkBa4Wrmg9/Ywtr6er0tVpWPIXFnUCLWMVD2HZXygoBazpRE09M4J9
- /jT2Pg/PjNM0iyS7kIJ6qAoNjMfjwlnzb1nEiMJfWKMty4LIHmYSJZHXeUDnhA/i9RMhCGFwv5G0
- iX7lJY8595YtDAHPVMqbl4Yakye0VtceAbs7C+7jKwTLN01fC9rUR73RbnUcd43H9YUOuDMjS4Zd
- JH3liTqsMmdSjNgnHwhVTzV6ECmZhI+yzrla5E/MGZrOtoDBUkcxdgFRTsyfKuKsaX4E8l6UGTWh
- B3qG9jQ1ico7ULy5eVaFmKhZXyZPq3gVGkFJ3A9ulJLbPQiTtDc28yK6VauHZisVtMEzrgyDH+pF
- i+UZcG47ncZLvaGx+6d/sNz822M5wkKMmf9cKcagNPXMFMXrSCg/jCPdLeSY9UbgemFONTA5/vYL
- gzoDoUF5n3dlAUvxbhxCcg48/THdQ4iLcdVBIyeHnkbsof4Ka4VOZ9NS46pAJaoiELMPl1Qjulav
- VNo9nkZRB7HwWJ+k5QqpgxfFaUy+PkzIogwp7kXYk0OsdNbRQtI2oe8dopnHd5kkOrNy6stBgvfh
- zwmU28hW5ZtTJS5hNNLzJCtQqZfS81S45gZKXZ/UKpqZ1HISNZg5z0Vg1LnAcKp2cpjnXOUi54p8
- 1XAz/7rnCZHcPHwhIJ3rIIoL0gluUnMaQr6Iz0KDVf8ekBZVPSferj97wb3eLYrV/Zz9lnovCRuK
- 1ryQa0v9RXpkqlkTj8mi4WGNoqXkhO2nnK/DUyXCxgoypkXDIBGpEC2M7Joq/YijGEPxQinCpsfy
- QYRP9Urskb/KU079VVKj7UnVpCFdRdjMB91i6xXwG6ZD6Qs7gqR+vn99f/ndY3e+p2h9U8056S8I
- WUJeq1iojnZxq8v1gifBOlslWVy5jPjLSS2zeljlvVxu7zI9s0JQCSVzPTNSHd/s2rUj9ZG4GFB+
- XAsPUlAXPkUsT5oL90YvtHG94MglaOTZouVqRUl818wJmc6up55IifTLAKK3jF+JI2VzW4Mg8/w8
- ig0n9fRwIE9+9s8bZxyhA1RD3gmS/C1CLm/zyO8ePP2u2ls1zV3GOXwLbBM7WdDY0fd/fnyk15c4
- emRVtJeQys4h3a08uoUnwzhZ8oZZIq/ISCiPkfy9shqn3JHu+yVcpOeaQr1nkseAvfK8CiRCWLA3
- bAuaf1Ju/DAHztq+LiDtzcz4paY6wTzAiydPjq7gAwHmaI63jiNtdzr0LQgVrrIrEi8dqSB8uH2A
- enLUyxnVehHBEP7ElV/V87LR8Rb2VsaKrhw6hCXf1v34OawoJRSKnbg4z1adOWdKngikChvjXZbc
- EKepSV/5BqFYQDAufWMDE1XsLJtR3Qt9ZsLy8dlNykTsURpUfPAzktiNw08wJ/QQn5wR1yZQrp/b
- WFgKlmLzZfWUndc4FH4y2fQhUFnIDxaaNaL8TkHfVy8LLUFdEyY3vtGBLcoamKT5pJpgLyICvd98
- 2GMKymmRi9rgpACAyt68TKrti10IEXDNs+isQ4u18+OaTL+vOsxmv832Jz+zWx2FmIY8oOt5LwvL
- FE7Ub9d0y+hE2ZGHXrzb+vvPX/7yNpbYNPEyTX15Drr6AP45qkMl5tTBuuBZ4q5NPMGQC5Lx4yc+
- w7fWyYTDzYOtF4ta2JjYMszbUWEjeC+vXAgcHYCTG2DNpXIxT564I2Opsv05z6bEuShxP3MA1IbC
- ZY5eZ/yhvU7yLKS79qsMak1EucNS2ZzKGCpqk016fJ4zQW8VX3hj+256Wm/I9UYzuzM/sY/PjA/X
- wBVFu7QlKgM0dqYwI7JQ7IbbpXMg3QtpbMLpClM46QCv/Nzk3UGH+/B0AAxZb5UnMLaIEVIRmDO9
- TOw93TMkV97gvOvQAsJ4uR0LZUrUJA2Pkzo4WCO1yvEpIy4bds/6FNbfdhXsg7uw8OK6mK92jj/u
- HEc48ujuLcg0zNrw3Sq3p96MB9ATo96YpoAT1xL4fqQENHdFMq/QATLs5fi2qqjppKkmLEcCEz4Y
- oEo+QTwEmE2ot0nfs+Kv/binRQLr2ZuYC/f6dfCA58Ama60CzBP2KnBm7RO1jWEuh1F785V3twBG
- mW+IixsoOfmvhkgfvfCevcZIsOsZTGMIe/FUdkPmXEvoJ8cwKVWRfpapxJv5sTEqgigyTwFKGThR
- 9yW+Ypw2TfownUJ9r+wKmIQcX9cqSNLTc8Lz/GtzqZwmmAOA3Ho3ukRFbXsMhAwFyYUFXeETV6SF
- tGp+BkwbWDYFyzHbESeoGLHqzF6O6FYnu0PDUpHlKY1cWVXpgNq4udkkpqwcoGENRw6oi5xuKqBA
- Fh3H2BP6pLZ9VmW4knCEZr+7Mj1qH61ZKICA5d7RJZ3jcfiWB87Zc2hNputnUUZCkYUrqtg9J9V7
- JFRI7AnPx0iHopJlonL9zCreWB0e6W7+zTgkd8xBwsnKBIznuazR9yeLxAlLhTPrjRrWWkVda42y
- repsJGEhkiyDSnV+CTZ+GYJN09WbmfTM6EtZya7tjNjTvSiRiFe9crfLI4ekSlfGQxEQdvXH8dDU
- LszOe8drGWY8mVsd+QcrSKkFCmKLQsoDERaq0mOB/UB4msNFP3N+XPocBGifdUp1mxrT3cqWOLkn
- 0v26Zz4Cgie/eGnr93/99PXvELHkf5cJn1WsMhsD7uqCF+pqJ+60P+KSJ8LMcoeiiurLFZfyuebV
- rpCR6wNSCR1SClUF0y61AYaA83j/gq8em1UbURDwBa4BTFZlNJJnLdHsltl1y91guRNWTHtlbhME
- RYk9F9DMt1tKpTH9QBc0QdOBjDu1bqUvY6Fvgg6foGPnXzbWeQFSnayKBqIac9gPkWyrUbocTb7D
- DFBbHNSGs0wv/ZcETWYcftypMGu/bkhl3hrZSD+gvNx3SjSTb5LmGiWIw1ihRnxJ2S9OG5pH6gdL
- 4MMSSKjOtGaBcx9gZuRtQoYDuTJuSMo1McFeTDJuEy/I23QSwJLJmOuKms4v7GuvUUE8jHNUMKc7
- YpgsV8bp1orvK4Pbg/wFLetV/nPOnTWbNnEWytzQV4VD2lc1ENQ316suXkFl0gryDNm8XjK2y5DP
- UYL22TOgSdBBXlBzUe2E8jvS6+mdn/O9fJud1A23U/3tJGm7B3/Fxyeo0IAZbMAVKa2iduOqVCRF
- 9YoP1XJIV/Pg7hs0PlZbPW2xJtfjtjzJBxFh5d01tx3g/XPwiVZl69enw060/6Z2Ah2C8Aw/1OxB
- 6A5lxOvTK+KjmXAyCw9fq88HpDTADC3SGCFAQd9GzzJ+MZjMt35j6DrLinyMir2/IXjpC1dVVVUo
- X35Yvys4eAQVQw9R/H1zMU9w6rCbTUWF23MJpULasAXQ0WkM0H3cF59HXfNVRzOWbyiB1J87T35a
- jRVPfqfJkDZanVdVSuTFMU8OmV7lPR6JNBH+2REYmx9lEFpU+KGIgMefl4i1BZOGOmlEdnh0OHxH
- IC8iYKXNxm3NPeEwFQCtEz4huuqIHJ+YxDecZBBX1oc/tItgcU48Ti862L31UFWC5CMrZZ8GB1jA
- dPCdf/pGIpBx0cJXkTdINak+p0NrrteLQ3/5wvonaIYWOieY/CWjea+l8xq8slS44di7Saee8ag9
- f6g8llUkmaoH6/iaccI0MlNeRUeHyUcnX4WbS9VH5TI49fbBoV28dlMAivyhEqaqo37O4T7BHLL5
- rKzeQDnMvqsDsiJbygAJeJXtRYH5rIbpNopKOhVjnvywThXTX27nrsZCf3+mz82JHtFP6nn3SMXH
- mS6Xy54eKQ+HUfL+5KrLMdRNrWv58IzLJZFwKH7um6zcE7i39aI52IMiCd0Fre7eFc4Megt382Ov
- szqci2Vd2+eEY6GPKzYO40DeaRWxAm/mgk7H0EeH55K4kAveP5mp3s0StdQXaHJRCm0GjAg8lOvq
- DEnHDSy77NN129A/Ae9b4N1ZtdJtMtTiDxRLm1DQc8WO2crSvGYQbvJ1DKn+kCXlG8usyv3eySPZ
- 3A0v7bkMUbtITblBAYl1HbU3GZ6TlFHRicIXbDpqD3/WaOC6QEMzNexKka1P9kQ0FKfIFXrn6Soz
- dlxlzVty+a/4+OwM6pQX1eWD7vofJmaHblKoAAA="
- # format: From country,To country,Jury A,Jury B,Jury C,Jury D,Jury E,Jury Rank,Televote Rank,Jury Points,Televote Points # field sep:,
- #csv=`cat esc-2016_gf_fr-nix.csv`
- csv=`echo "${csvfile}" | base64 -d | gunzip`
- # cat esc-2016_gf_fr-nix.csv | gzip | base64 | base64 -d | gunzip # compress option for inline csv (ratio 1:3)
- line="-------------- --- -- - - "
- getUniqCountry() {
- countryList=`echo "${csv}" | awk -F , '{print $1","}' | sort -u | tr -d '\n'`
- }
- rankingJT() {
- echo "${line}"
- echo "Ranking per Jury- and Tele-votes (j:t) - sort by j"
- echo "${line}"
- oIFS=${IFS}
- IFS=','
- for c in ${countryList}; do
- echo "${csv}" | awk -F , -v c=${c} 'BEGIN {jcount=0;tcount=0;} {if ($2==c) {jcount+=$10; tcount+=$11}} END {if (jcount!=0 && tcount!=0){print jcount":"tcount" "c}}'
- done | sort -n | tac
- IFS=${oIFS}
- }
- singleVotesPerCountry() {
- # in $1 country
- echo "${line}"
- echo "${1} Ranking per country per Jury- and Tele-votes (j:t) - sort by j"
- echo "${line}"
- oIFS=${IFS}
- IFS=','
- for c in ${countryList}; do
- if [ "${1}" = "${c}" ]; then
- echo "${csv}" | awk -F , -v c=${c} 'BEGIN {jcount=0;tcount=0;} {jsc=0; tsc=0; if ($2==c) {jcount+=$10; tcount+=$11;
- jsc=$10; tsc=$11;
- if (jsc==" ") jsc=0;
- if (tsc==" ") tsc=0;
- if (jsc!=0 || tsc!=0) {
- print jsc":"tsc " "$1
- }
- }
- } END {if (jcount!=0 && tcount!=0){print jcount":"tcount" * for "c" * "}}'
- fi
- done | sort -n | tac
- IFS=${oIFS}
- }
- getUniqCountry
- if [ "${1}" != "" ]; then
- singleVotesPerCountry "${1}"
- fi
- rankingJT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement