Results 1 to 6 of 6

pivot table setup

Threaded View

  1. #1
    Registered User
    Join Date
    01-06-2010
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    16

    pivot table setup

    Hey

    I am trying to make a spreadsheet for the purpose of tracking how accurate a guess is for an nfl pick.

    So what I have is a schedule, and will after each game mark a winner. If the guess was correct, I want to be able to assign each team playing 1 point if correct. If the guess was incorrect, I want it to subtract a point.

    I want to be able to update this every week and have the total points tally up weekly, so I can see what teams are getting more correct guesses and what teams are getting wrong picks.

    I hope this makes sense. I was thinking a pivot table would work, however it was only giving the points to one team, and I couldnt figure out how to do it for both.

    Can anyone make a very simple version of this, you can just use team a, team b, etc, and I dont need scores.

    When I tried, my categories were
    away team, home team, winner, guessed winner, points

    the home and away fields I have, the winner I have data up through the last game, guessed winner I have, and points was just a =if(guessed winner = winner,1,-1)

    Thanks for any help!!
    Attached Files Attached Files
    Last edited by andyman3; 10-07-2011 at 06:08 PM. Reason: attached spreadsheet

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1