Baseball Standings

I'm using Numbers to keep track of my leagues baseball standings but I'm wondering if there is a way to automate the system a bit. Right now I have two tables for each league. The first table has 4 columns. One for date, winner, looser and final score. The second table is your standard standings table with team, wins, losses and percentages.

Is there a function I can use in the second table that will track each time a team is listed in the winner column of the first table and enter that value in the wins column?

G5, Mac OS X (10.4.10)

Posted on Apr 21, 2008 6:02 AM

19 replies

KOENIG Yvan

Level 8

41,825 points

Apr 27, 2008 2:05 AM in response to Jerrold Green1

Don't worry, I'm not trying to learn baseball. I assumes that beeing born on 31/12/1943, it's too late 😉

I wrote about the checkboxes because all in all, adding the two ties auxiliary columns was already modifying the original Score table design.
But I must add that your soluce has at least one advantage: it gives to some users the ability to discover the SUBSTITUTE() function.
If Apple built 168 functions in the app, it's not to slow it, it's because they thought that they may be useful for many of us.

Yvan KOENIG (from FRANCE dimanche 27 avril 2008 11:05:06)

Dakoda Author

Level 1

145 points

Apr 27, 2008 6:52 AM in response to pw1840

That's the only thing missing from PW's solution. I don't mind the " **" with the tie games, it's another signal that the game ended in a tie. The only issue I've been having is not typing the team name exactly the same each time..... even though I've been extremely careful I've missed a few. BTW.... there are over 150 teams in this league.

I appreciate everyone's help with this solution. It's working like a charm as long as I'm careful!!!!

pw1840

Level 3

860 points

Apr 27, 2008 8:22 AM in response to Dakoda

Dakota,

I had no idea you were dealing with so many teams. It's no wonder you can use all the computer help you can get. When the process is so dependent on consistent (if not correct) spelling, putting those names into a pop-up menu would solve that problem. But with 150 teams I would think that rather unwieldy. If you haven't done this already, look into auto-completion. Menu > Numbers > Preferences and check "Show auto-completion list . . .". It, too, may be a bit cumbersome, but once you get used to it your spelling problem should lessen. Have a great season!

pw

Apr 28, 2008 1:13 PM in response to Dakoda

Dakoda,

I hope that your league secretary gets paid! Fat chance, right?

Here's something you may want to consider. I've added a name check column that flags spelling errors.

The formula in the Name Check column is: =IF(ISBLANK(C2), "", IF(ISERROR(VLOOKUP(Winner,Stats :: Team:'Team#',5,0)&VLOOKUP(Loser,Stats :: Team:'Team#',5,0)),"ERR","OK")). I also gave the Name Check cells a conditional format to display ERR in red.

I know that you might not want to number the teams as I did in the Stats table, so you could eliminate that column and give the VLOOKUP functions something else to look for. (I was thinking about another approach when I started and I just left the team numbers there out of laziness.)

I think you need some sort of error check with that many teams.

Good luck,

Jerry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Baseball Standings