List your ASFM entries (1 Viewer)

  • Thread starter Thread starter AGinAg (37)
  • Start date Start date
win_the_game said:
As I don't fancy the pressure of hosting ASFM anytime soon, I've decided to make use of my VERY BASIC PIVOT TABLE skills and gift Moopy this spreadsheet instead.

Click on any of the cells to bring up the Pivot Table Editor.

Use the Filter tool at the bottom of the Editor to select a poster and display a list of their entries and results. Remember to clear the previous filter first as it doesn't yet work if you try to view multiple posters.

If any of our spreadsheet whizz kids can think of a better way to present the data, I'm happy to give you access and let you run with it.
Click to expand...

Spreadsheet fully updated.
 
David 5000 said:
My updated list:


ASFM IV - War Of Words - Panic (1st)
Click to expand...
This was an amazing song and a worthy winner. I don’t think I ever knew the artist (I assumed it was an anonymous La Roux project). EDIT: Oh it was! :D

I think I only entered this once, in 2011, with ‘Fais passer le mot’ (which I can barely hum now) - it came 6th (I think).
 
Last edited:
  • Like
Reactions: D5K
392966.jpg

R-6153536-1526751719-5940.jpeg.jpg

33ec43bcee7e48cd81047eb3f5e7ab39.jpg

maxresdefault.jpg

AE.jpeg

4261D4E7-C09B-4D99-B6B2-0C581A93C3E3.jpeg

maxresdefault.jpg

1303982.jpg

avatars-000183737289-yvl3x1-t500x500.jpg

03_.jpg

62ee0c223450221d8e65e77c94f2e68d.jpg

90
 
win_the_game said:
As I don't fancy the pressure of hosting ASFM anytime soon, I've decided to make use of my VERY BASIC PIVOT TABLE skills and gift Moopy this spreadsheet instead.

Click on any of the cells to bring up the Pivot Table Editor.

Use the Filter tool at the bottom of the Editor to select a poster and display a list of their entries and results. Remember to clear the previous filter first as it doesn't yet work if you try to view multiple posters.

If any of our spreadsheet whizz kids can think of a better way to present the data, I'm happy to give you access and let you run with it.
Click to expand...

BETA UPDATE :disco::disco::disco:

I've added a couple of extra tabs to the spreadsheet.

You can now view:

Points received from - Which posters vote for you.
Points given to - Which posters do you vote for.

You will also see the number of times/ASFM edtions they've voted for you, for some context.

I've not included votes from the semi finals or from ASFM - A Beryl-ation, as the voting system was an outlier and would distort the results. Happy to add them in if anyone is particularly keen for them.

I'm having a bit of an issue trying to sort the data from high to low so it's a work in progress. (Excel is a piece of piss compared to Google Sheets).


Anyway to use, it's the same as before;

Click on any of the cells to bring up the Pivot Table Editor.

Use the Filter tool at the bottom of the Editor to select a poster and display a list of points etc. Remember to clear the previous filter first as it doesn't yet work if you try to view multiple posters.
 
I really struggle with that spreadsheet. I think I need to open the laptop.
 
Ag said:
I really struggle with that spreadsheet. I think I need to open the laptop.
Click to expand...

Yes Google have an app builder. I might have a look at that, at some point and see if there is an easier way to present the data.
 
I’ve tried it on the Google Sheets app on my iPad and I still cant get it to work :(

Brilliant work once again @win_the_game !! :disco:
 
I've had 3 pints can someone do my points given/received from, I CANNOT FIGURE IT OUT.
 
Do you have to go through poster by poster? If so I think that’s a job for tomorrow.
 
Me too, please! I can’t make it work on my phone (and I’m too lazy to reach for the ipad rn).
 
You must log in or register to reply here.

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
Back
Top Bottom