P
prodeji
OK here's my dilemma; hope I explain myself clearly as I'm new at
this.
I have a worksheet that pulls the names and IDs of casino players
enrolled in different groups from a database.
Every person in the group is assigned a player ID.
Not every person plays, however.
I'm compiling a report that shows actual and theoretical win for each
player.
Table X stores player names and IDs, table Y stores player statistics.
I calculate actual and theoretical win from table Y, set up a pivot
table, and link 2 other columns to the pivot table to display actual
and theoretical win.
Problem is, only players who actually play have any records in table
Y.
The bosses want to see ALL persons enrolled in group X, whether they
played or not.
With my limited knowledge of Excel, I have 2 options:
A. I modify the report to show ONLY those persons in the group who
actually played.
B. I show all persons in the group, but the player name/IDs and actual/
theoretical win figures will no longer match up.
e.g group 234 includes the following, modified to show only persons
who played:
Plyr ID Last Name First Name Theo Win Actual Win
53082 Duck Donald $0.60 $10.00
53084 Man Super $26.30 $70.00
53087 Baby Big $1.20 $3.75
53088 Dick Moby $28.10 $83.75
Everyone's play is correctly attributed to him/her, but when I modify
the report to include persons who did NOT play, Mr. Jolly Green Giant
now appears on the list, and has Big Baby's figures incorrectly
attributed to him, Big Baby in turn gets Moby Dick's data, and so on
and so on.
Plyr ID Last Name First Name Theo Win Actual
Win
53082 Duck Donald $0.60 $10.00
53084 Man Super $26.30 $70.00
53085 Giant Jolly Green $1.20
$3.75
53087 Baby Big $28.10 $83.75
53088 Dick Moby
How can I extract actual and theoretical win from the pivot table
(which contains ONLY those players who played, along with their
stats), match it up with the corresponding player IDs and names on the
report (which contains ALL player IDs/names whether they played or
not) and instruct Excel to skip or better yet populate with '$0.00'
those cells that belong to players who did NOT play?
As in Mr. Jolly Green Giant would now be included on the report, but
would have '$0.00' in his 'Theo Win' and 'Actual Win' columns:
Plyr ID Last Name First Name Theo Win Actual Win
53082 Duck Donald $0.60 $10.00
53084 Man Super $26.30 $70.00
53085 Giant Jolly Green $0.00
$0.00
53087 Baby Big $1.20 $3.75
53088 Dick Moby $28.10 $83.75
Really hope I'm being clear enough about what I need, as I said, I'm
new to this, but trying to be precise and provide all necesssary
information.
Any guidance is deeply appreciated.
Thanks,
this.
I have a worksheet that pulls the names and IDs of casino players
enrolled in different groups from a database.
Every person in the group is assigned a player ID.
Not every person plays, however.
I'm compiling a report that shows actual and theoretical win for each
player.
Table X stores player names and IDs, table Y stores player statistics.
I calculate actual and theoretical win from table Y, set up a pivot
table, and link 2 other columns to the pivot table to display actual
and theoretical win.
Problem is, only players who actually play have any records in table
Y.
The bosses want to see ALL persons enrolled in group X, whether they
played or not.
With my limited knowledge of Excel, I have 2 options:
A. I modify the report to show ONLY those persons in the group who
actually played.
B. I show all persons in the group, but the player name/IDs and actual/
theoretical win figures will no longer match up.
e.g group 234 includes the following, modified to show only persons
who played:
Plyr ID Last Name First Name Theo Win Actual Win
53082 Duck Donald $0.60 $10.00
53084 Man Super $26.30 $70.00
53087 Baby Big $1.20 $3.75
53088 Dick Moby $28.10 $83.75
Everyone's play is correctly attributed to him/her, but when I modify
the report to include persons who did NOT play, Mr. Jolly Green Giant
now appears on the list, and has Big Baby's figures incorrectly
attributed to him, Big Baby in turn gets Moby Dick's data, and so on
and so on.
Plyr ID Last Name First Name Theo Win Actual
Win
53082 Duck Donald $0.60 $10.00
53084 Man Super $26.30 $70.00
53085 Giant Jolly Green $1.20
$3.75
53087 Baby Big $28.10 $83.75
53088 Dick Moby
How can I extract actual and theoretical win from the pivot table
(which contains ONLY those players who played, along with their
stats), match it up with the corresponding player IDs and names on the
report (which contains ALL player IDs/names whether they played or
not) and instruct Excel to skip or better yet populate with '$0.00'
those cells that belong to players who did NOT play?
As in Mr. Jolly Green Giant would now be included on the report, but
would have '$0.00' in his 'Theo Win' and 'Actual Win' columns:
Plyr ID Last Name First Name Theo Win Actual Win
53082 Duck Donald $0.60 $10.00
53084 Man Super $26.30 $70.00
53085 Giant Jolly Green $0.00
$0.00
53087 Baby Big $1.20 $3.75
53088 Dick Moby $28.10 $83.75
Really hope I'm being clear enough about what I need, as I said, I'm
new to this, but trying to be precise and provide all necesssary
information.
Any guidance is deeply appreciated.
Thanks,