exuel Tutorial 5, Case Problem 1 , Tutorial 5, Case Problem 2 , Tutorial 6, Case Problem 1,Tutorial 6, Case Problem 2 ,Tutorial 7 Case Problem 1, Tutorial 7 Case Problem 2
aboznada007
players.xlsxDocumentation
| NBA Hoops Blog | |||
| Author | |||
| Date | |||
| Purpose | To track NBA player data | ||
| Data Definition Table | |||
| Field | Description | Data Type | Notes |
| First name | Text | ||
| Last name | Text | ||
| Salary | Player's salary | Number | Use Accounting format with no decimal places |
| Position | Player's position | Text | C (Center), PF (Power Forward), SF (Shooting Forward), SG (Shooting Guard), PG (Point Guard) |
| Team | Player's team | Text | Chicago Bulls, LA Lakers, Miami Heat, NY Knicks, Oklahoma Thunder, San Antonio Spurs |
| Division | Division player's team is assigned to | Text | Pacific, Atlantic, Northwest, Southeast |
Players
| First Name | Last Name | Salary | Position | Team | Division |
| Marco | Belinelli | 1957000 | SG | Chicago Bulls | Central |
| Carlos | Boozer | 15000000 | C | Chicago Bulls | Central |
| Jimmy | Butler | 1066920 | SG | Chicago Bulls | Central |
| Luol | Deng | 13305000 | SF | Chicago Bulls | Central |
| Taj | Gibson | 2155811 | PF | Chicago Bulls | Central |
| Richard | Hamilton | 5000000 | SG | Chicago Bulls | Central |
| Kirk | Hinrich | 3941000 | PG | Chicago Bulls | Central |
| Nazr | Mohammed | 854389 | C | Chicago Bulls | Central |
| Joakim | Noah | 11300000 | C | Chicago Bulls | Central |
| Vladimir | Radmanovic | 854389 | PF | Chicago Bulls | Central |
| Nate | Robinson | 854389 | PG | Chicago Bulls | Central |
| Derrick | Rose | 16402552 | PG | Chicago Bulls | Central |
| Marcus | Teague | 857000 | SG | Chicago Bulls | Central |
| Steve | Blake | 4000000 | PG | LA Lakers | Pacific |
| Kobe | Bryant | 27849149 | SG | LA Lakers | Pacific |
| Earl | Clark | 1240000 | PF | LA Lakers | Pacific |
| Chris | Duhon | 3500000 | PG | LA Lakers | Pacific |
| Devin | Ebanks | 1054389 | PF | LA Lakers | Pacific |
| Pau | Gasol | 19000000 | PF | LA Lakers | Pacific |
| Jordan | Hill | 3563600 | PF | LA Lakers | Pacific |
| Dwight | Howard | 19536360 | C | LA Lakers | Pacific |
| Antawn | Jamison | 854389 | PF | LA Lakers | Pacific |
| Jodie | Meeks | 1500000 | SG | LA Lakers | Pacific |
| Darius | Morris | 962195 | SG | LA Lakers | Pacific |
| Steve | Nash | 8900000 | PG | LA Lakers | Pacific |
| Metta | Peace | 7258960 | SF | LA Lakers | Pacific |
| Ray | Allen | 3090000 | SG | Miami Heat | Southeast |
| Joel | Anthony | 3750000 | C | Miami Heat | Southeast |
| Shane | Battier | 3135000 | SF | Miami Heat | Southeast |
| Chris | Bosh | 17545000 | C | Miami Heat | Southeast |
| Rodney | Carney | 854389 | PF | Miami Heat | Southeast |
| Mario | Chalmers | 4000000 | PG | Miami Heat | Southeast |
| Norris | Cole | 1082520 | PG | Miami Heat | Southeast |
| Josh | Harrellson | 762195 | PF | Miami Heat | Southeast |
| Udonis | Haslem | 4060000 | PF | Miami Heat | Southeast |
| LeBron | James | 17545000 | SG | Miami Heat | Southeast |
| James | Jones | 1500000 | SF | Miami Heat | Southeast |
| Rashard | Lewis | 1352181 | PF | Miami Heat | Southeast |
| Mike | Miller | 5800000 | PF | Miami Heat | Southeast |
| Dexter | Pittman | 854389 | C | Miami Heat | Southeast |
| Garrett | Temple | 854389 | SG | Miami Heat | Southeast |
| Dwyane | Wade | 17182000 | PG | Miami Heat | Southeast |
| Carmelo | Anthony | 20463024 | SF | NY Knicks | Atlantic |
| Ronnie | Brewer | 854389 | SG | NY Knicks | Atlantic |
| Marcus | Camby | 4590338 | C | NY Knicks | Atlantic |
| Tyson | Chandler | 13604188 | C | NY Knicks | Atlantic |
| Chris | Copeland | 473604 | SF | NY Knicks | Atlantic |
| Raymond | Felton | 3480453 | PG | NY Knicks | Atlantic |
| Jason | Kidd | 3090000 | PG | NY Knicks | Atlantic |
| Steve | Novak | 4054055 | SF | NY Knicks | Atlantic |
| Pablo | Prigioni | 473604 | PG | NY Knicks | Atlantic |
| Iman | Shumpert | 1633440 | SG | NY Knicks | Atlantic |
| JR | Smith | 2806452 | SG | NY Knicks | Atlantic |
| Amar'e | Stoudemire | 19948799 | PF | NY Knicks | Atlantic |
| Kurt | Thomas | 1352181 | C | NY Knicks | Atlantic |
| James | White | 854389 | SF | NY Knicks | Atlantic |
| Cole | Aldrich | 2445480 | C | Oklahoma Thunder | Northwest |
| Nick | Collison | 2929332 | PF | Oklahoma Thunder | Northwest |
| Daequan | Cook | 3090942 | PG | Oklahoma Thunder | Northwest |
| Kevin | Durant | 16669630 | SF | Oklahoma Thunder | Northwest |
| James | Harden | 5820417 | SG | Oklahoma Thunder | Northwest |
| Lazar | Hayward | 1174080 | SF | Oklahoma Thunder | Northwest |
| Serge | Ibaka | 2253062 | C | Oklahoma Thunder | Northwest |
| Reggie | Jackson | 1208400 | SG | Oklahoma Thunder | Northwest |
| Eric | Maynor | 2338721 | PG | Oklahoma Thunder | Northwest |
| Kendrick | Perkins | 8300531 | C | Oklahoma Thunder | Northwest |
| Thabo | Sefolosha | 3600000 | SG | Oklahoma Thunder | Northwest |
| Hasheem | Thabeet | 1200000 | C | Oklahoma Thunder | Northwest |
| Russell | Westbrook | 13668750 | PG | Oklahoma Thunder | Northwest |
| DeJuan | Blair | 1054000 | C | San Antonio Spurs | Southeast |
| Matt | Bonner | 3630000 | PF | San Antonio Spurs | Southeast |
| Nando | DeColo | 1400000 | PG | San Antonio Spurs | Southeast |
| Boris | Diaw | 4500000 | PF | San Antonio Spurs | Southeast |
| Tim | Duncan | 9638554 | C | San Antonio Spurs | Southeast |
| Manu | Ginobili | 14107492 | SG | San Antonio Spurs | Southeast |
| Danny | Green | 3500000 | SG | San Antonio Spurs | Southeast |
| Stephen | Jackson | 10059750 | SF | San Antonio Spurs | Southeast |
| Cory | Joseph | 1074720 | SG | San Antonio Spurs | Southeast |
| Kawhi | Leonard | 1809840 | SF | San Antonio Spurs | Southeast |
| Patty | Mills | 1085120 | PG | San Antonio Spurs | Southeast |
| Tony | Parker | 12500000 | PG | San Antonio Spurs | Southeast |
| Tiago | Splitter | 3944000 | C | San Antonio Spurs | Southeast |
