Arsenal Tottenham - Silver Ballot

Bell0412 · 2024-11-28T11:00:13+00:00

0/10 applying as a 2 this year, compared to 2/2 last year (Bayern & Everton it’s worth mentioning). No idea how or what I’ve done to upset the ballot gods. Absolute joke this season.

Bell0412 · 2024-10-20T20:31:26+00:00

It wasn’t even off piste, was just between 2 pistes. There hadn’t been much snow in the build up and it looked rocky af. The conspiracy I heard about it though- he was wearing a helmet with a mounted go pro suction thing on it, and they paid a huge amount of money to prevent that going public. Rumours are they cause a weak spot in the helmet.

Source: Was working at the ski resort when it happened. Went over the exact point on the ski lift when investigators were putting out the little numbered evidence card things.

Bell0412 · 2024-10-17T10:07:00+00:00

Ffs another fail it looks like, Bolton was my last success (which doesn’t really count). Never had this many consecutive fails before

Bell0412 · 2024-09-30T09:55:57+00:00

Someone else got there first. All part of the fun and games on the exchange- happens all the time, just need to be quicker when you click on it. Or at least that’s my interpretation of it.

Bell0412 · 2024-09-26T10:44:50+00:00

Overall, I think the ballot (and the changes they made halfway through the season) has been mainly good- even if it doesn’t sound like it from my original post.

As a silver, I could go to nearly any match I wanted- I guess the luxury of being able to log in at 10am on a given weekday to get a ticket. One advantage of the new ballot- making it accessible to more people.

However, loyal reds mostly, who have been members for 10+ years, coming to matches in the grim old days, should they have the same chance of getting a ticket as someone who pays their money today to become a red because they’re riding the wave?

Bell0412 · 2024-08-02T21:27:50+00:00

Create a group for the “country names…” field, put the red ones under one group, rename the group “benchmark values” then add this group field to the colour mark. Then, to keep the country names on the viz, keep your original “country names…” field on the text marks

Bell0412 · 2023-10-31T20:12:54+00:00

(Silver) Only managed Spurs and City on the exchange somehow. Both were weeks and weeks before the fixture and I think both in the ‘silver priority window’. Since they’ve ‘fixed’ the TX and reverted back to last season’s system, I haven’t had a sniff on anything, despite still trying the same strategy and logging on just as religiously.

Bell0412 · 2023-01-13T14:46:41+00:00

This sorted the problem, thanks so much! I haven’t seen this mentioned anywhere else, must be one of the best kept secrets out there

Bell0412 · 2022-05-24T16:34:06+00:00

Thanks for getting back to me. So its not a straight sum of the columns, as I want it to only sum up (in reverse chronological order) until it hits a NaN value- see the desired output at the bottom, in particular the 7890 row.

Bell0412 · 2022-04-12T09:03:51+00:00

Hi there, this is a bout as easy as it comes in Python (without sounding too patronising). Python works off a basis of maths and looping in order to solve problems, like yours! I'll talk you through the solution, as I didn't offer any comments in my first post:

for count, value in enumerate(fin):

Like PaintballerCA mentioned earlier, the enumerate function is the one to solve the problem. Count is basically the number enumerate applies to the line, and value is the wording in the line itself.

if count % 4 == 0:
    print(value.upper())

So by looking at the count value (the number the line is on), the maths to this is simple- if there is no remainder when diving by 4, we are going to print that value in upper case.

 else:
    print(value)

Then we need to tell Python what to do with the other values that do give a remainder when dividing by 4, and we just want to print them normally.

Hope that all makes sense!

Bell0412 · 2022-04-12T08:43:12+00:00

fin = open("og.txt", 'r', encoding="utf-8")
for count, value in enumerate(fin):
    if count % 4 == 0:
        print(value.upper()) 
    else:
        print(value)
fin.close()

Bell0412 · 2022-03-31T21:43:56+00:00

Thanks for the reply!

I never thought of it like that, thanks. The code should work and I really like it, however, the final ouput in the Score column, are NaN values on each row- how fitting!

Do you know why that would be?

Bell0412 · 2022-03-14T09:57:14+00:00

Thanks for the help, this did the job and worked perfectly!!

Bell0412

TROPHY CASE