PDA

View Full Version : FAO-Ono: Editing the spreadsheet

TimJBart
31-10-2005, 17:19
Hi there Ono, or anyone who knows how to work the Pro Evo results spreadsheet!

I need to fit 2 more places onto the PS2 league to make 13 players but with my very limited knowledge of excel I can not get it working properly. The bit I am confused about is the equations that are in the home and away wins, goal difference and points. Where are you getting BJ76, BL63 and CE82 from!? I imagine it is some code that isn't overtly displayed?

I got the names, games played, and points working, but everything in between is a bit hazy! Also, I cannot get the extra 2 names on the bottom of the league to get updated in the table sort macro.

You could probably do this in about 2 seconds but seeing as I have no knowledge I'm hitting a brick wall! I can do all the styling as well it's just these equations I'm a bit confused about.

Could you let me know where I'm going wrong so if there are any future adjustments I don't have to hassle you again!
steviep922
31-10-2005, 17:24
Hi there Ono, or anyone who knows how to work the Pro Evo results spreadsheet!

I need to fit 2 more places onto the PS2 league to make 13 players but with my very limited knowledge of excel I can not get it working properly. The bit I am confused about is the equations that are in the home and away wins, goal difference and points. Where are you getting BJ76, BL63 and CE82 from!? I imagine it is some code that isn't overtly displayed?

I got the names, games played, and points working, but everything in between is a bit hazy! Also, I cannot get the extra 2 names on the bottom of the league to get updated in the table sort macro.

You could probably do this in about 2 seconds but seeing as I have no knowledge I'm hitting a brick wall! I can do all the styling as well it's just these equations I'm a bit confused about.

Could you let me know where I'm going wrong so if there are any future adjustments I don't have to hassle you again!


I've got a version that will allow up to 17 teams. I'll email it to you.
TimJBart
31-10-2005, 17:32
I've got a version that will allow up to 17 teams. I'll email it to you.

thanks mate...I've just found where those seemingly random figures come from, was obvious really, now I've just got to work out how they work....

...or just get yours and delete the 4 i dont need ;)

Cheers :thumbs:

Interesting fact: I was in Bracknell today
steviep922
31-10-2005, 17:46
YGM.

Interesting fact no. 2, i was in Yateley today!!
TimJBart
31-10-2005, 18:42
No way!?! our lives are mirrored! On what business were you in my home town?

I was meeting a colleague at his house as we were driving to Maidenhead.

Spreadsheet is sorted thanks!
scottwilson82
31-10-2005, 19:58
No way!?! our lives are mirrored! On what business were you in my home town?

I was meeting a colleague at his house as we were driving to Maidenhead.

Spreadsheet is sorted thanks!

Stevie was over at yours seeing your wife :thumbs: ;)
steviep922
31-10-2005, 20:30
Stevie was over at yours seeing your wife :thumbs: ;)

:D

I was visiting one of my customers on blackbushe business park.
TimJBart
07-11-2005, 14:51
Stevie was over at yours seeing your wife :thumbs: ;)

Only just noticed this slur...if I was married I'd lamp you...both!