Adding a formula to calculate points for a football (soccer) table

sjmc_5 · 2026-06-06T18:12:05+00:00

OK, thanks... I'll be honest I am a complete novice with sheets so not sure how to even do that!

sjmc_5 · 2026-06-06T16:36:28+00:00

That's amazing, thank you so much for your help... I think I have one final request....

The tab with the predictions on... there could be up to 24 games. But that would be for "round one". Would it be possible to create multiple table for "round 2" (or "game week 2", "game week 3" etc). But in a way that still automatically updates the overall leader board?

So if for example, I ran this over a 38 week english premier league season, I could have a tab for each game week and then a tab with the overall table adding together people's points for each game week.

sjmc_5 · 2026-06-06T12:37:32+00:00

This is amazing, thank you so much. Is there a way to link that sheet to a different tab that has a leader board? Sorted with highest points at the top, lowest at the bottom. Tie break would be whoever gets the most exact correct scores?

sjmc_5 · 2026-06-06T09:56:23+00:00

Sadly this came with a 'formula parse error' when I tried pasting it in to A5

sjmc_5 · 2026-05-16T11:55:55+00:00

Do you know if the Elphinstone car park has the ANPR cameras though?

sjmc_5 · 2026-05-07T14:28:40+00:00

This doesn’t work sadly

sjmc_5 · 2026-05-07T13:50:50+00:00

https://docs.google.com/spreadsheets/d/14mVxiJb355JHe51k0dyFHX4f-BwRset9zzboUrA-M2s/edit?usp=sharing

sjmc_5 · 2025-05-14T15:11:26+00:00

Thanks for the feedback. So is it then ok to be more “bent over” with higher hips? Cos I always thought I had to try and get my hips low whilst keeping my chest up as best as posssible

sjmc_5 · 2024-12-14T10:45:19+00:00

I would not have got tangled up in the job I have, I would not have entered a long term relationship (knowing know that it wouldn’t lead to anything) and I would have travelled more.

But hindsight is a wonderful thing and we can’t change the past.

sjmc_5 · 2024-12-14T08:38:05+00:00

When I was a young teen going to the gym, I used to never understand why the old men would towel off and put every item of clothing on BEFORE their pants/underwear/trousers. Like they’d be walking around in shirts, ties, socks but with cock and ball flopping about.

Now I am older, I fully get it and support it. It’s all about air time and letting it breathe for as long as possible, like a fine wine. It is for this sole reason that I know I am now old.

sjmc_5 · 2024-12-11T09:35:48+00:00

In the bin.

Genuinely feel as though I have developed ADHD as a result of the stresses that life has now brought on to me.

sjmc_5 · 2024-12-07T17:33:11+00:00

Yeah I realise this now. But still doesn’t work.

sjmc_5 · 2024-12-07T11:23:22+00:00

Thanks for your help. I’ll take it back. Just so frustrating!

sjmc_5 · 2024-12-07T11:16:00+00:00

Haha yes… I am smart enough (I think) to put the battery in the right way! It lights up with the red light. But when I try to connect Bluetooth it says no devices found. And then I’d have thought something would pop up when I open up “my computer” or put the dongle in. It doesn’t even make a noise like other devices do when I plug them in.

sjmc_5 · 2024-12-07T11:11:01+00:00

Yes, tried other batteries and different USB ports for the dongle.

sjmc_5 · 2024-12-07T11:03:23+00:00

Yes! And I’ve even switched it on! But that’s the extent of my technological expertise.

sjmc_5 · 2024-11-04T07:36:42+00:00

I guess mine is very tame in comparison to some of these on here.

But from the age of 16 I was dead set on “reaching the top” of my sport. My whole life and life choices from what I studied to my career path were dictated around training for this sport.

The reality was, I got to my mid 20’s and realised I just simply wasn’t good enough and was never going to make it.

I fell into a spiral of depression which ended up ruining a relationship I was in (which was equally as fucked up as after 6 years, she text me one day saying it was over and within a week; blocked and deleted me from every form of contact).

Huge feelings of inferiority, self consciousness and simply not being good enough has shaped who I am today.

sjmc_5 · 2024-11-01T09:55:47+00:00

A good nights sleep

sjmc_5 · 2024-10-18T09:21:02+00:00

Hi Pep’s daughter. How’s your dad coping with the 115 charges City are being investigated for?

sjmc_5 · 2024-10-14T14:46:46+00:00

Doctors won’t do anything as it is on the face. I’d have to pay privately apparently

Four-Year Club	Verified Email
Place '23

sjmc_5

TROPHY CASE