Documentation
| Shelly Cashman Excel 2019 | Module 6: SAM Project 1b | |
| Roscoe's Sports Blog | |
| CREATE, SORT, AND QUERY TABLES | |
| Author: | Gaelle Achille |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
August Articles
| Article Title | Author | Publication Date | Number of Words | Article Type | Sports Level | Payment |
| Last-minute duel in golf | Martin | 8/2/21 | 322 | News | Professional | $ 386 |
| European road bicycle racing? | Pedraza | 8/5/21 | 174 | Opinion | Professional | $ 209 |
| This year could be big in tennis | Tovar | 8/7/21 | 250 | Profile | Professional | $ 300 |
| Third base is a power position | O'Brien | 8/8/21 | 314 | Opinion | College | $ 377 |
| Ups and downs in the NFC East | Fuentes | 8/10/21 | 504 | Feature | Professional | $ 605 |
| Ranking NBA journeymen | Romano | 8/10/21 | 446 | Analysis | Professional | $ 535 |
| Fantasy baseball movers and shakers | O'Brien | 8/11/21 | 482 | Opinion | Professional | $ 578 |
| Women's softball championship | Pedraza | 8/12/21 | 181 | News | Amateur | $ 217 |
| Ups and downs in the NFC South | Fuentes | 8/12/21 | 512 | Feature | Professional | $ 614 |
| Ups and downs in the NFC North | Fuentes | 8/13/21 | 524 | Feature | Professional | $ 629 |
| Had enough with preseason football? | Walsh | 8/14/21 | 487 | Opinion | Professional | $ 584 |
| Ankle injuries are killing the NBA's best | Romano | 8/15/21 | 359 | Opinion | Professional | $ 431 |
| NFL waiver wire | Fuentes | 8/16/21 | 397 | News | Professional | $ 476 |
| Major league baseball is for the young | O'Brien | 8/17/21 | 562 | Profile | Professional | $ 674 |
| College football is around the corner | Aken | 8/18/21 | 602 | Feature | College | $ 722 |
| Quarterback stability is everything | Walsh | 8/19/21 | 434 | Opinion | College | $ 521 |
| Women's soccer and more | Tovar | 8/20/21 | 227 | News | Amateur | $ 272 |
| Eleventh-inning errors | O'Brien | 8/21/21 | 382 | News | College | $ 458 |
| Hernandez comes roaring back | Martin | 8/22/21 | 280 | Analysis | High School | $ 336 |
| Pace of MLB rebuild picks up | O'Brien | 8/24/21 | 420 | Feature | Professional | $ 504 |
| Time for another MLB expansion? | Tovar | 8/25/21 | 388 | Opinion | Professional | $ 466 |
| Head-to-head points and ranks | Aken | 8/27/21 | 230 | News | High School | $ 276 |
| New to fantasy baseball? | Tovar | 8/28/21 | 256 | Feature | Professional | $ 307 |
| Closer trends and strategies | O'Brien | 8/30/21 | 314 | Analysis | College | $ 377 |
| Hidden college football stars | Walsh | 8/31/21 | 477 | Profile | College | $ 572 |
Current Articles
| Article Title | Author | Publication Date | Number of Words | Article Type | Sports Level | Payment | Approved? | Published? |
| College football coaching changes | Aken | 9/1/21 | 420 | News | College | $ 504 | No | No |
| So you want to add an ace? | Tovar | 9/2/21 | 514 | Opinion | Professional | $ 617 | Yes | Yes |
| Power conferences in the NFL | Fuentes | 9/2/21 | 522 | Analysis | Professional | $ 626 | Yes | No |
| Friday night lights | Martin | 9/3/21 | 360 | News | High school | $ 432 | No | No |
| European games | Pedraza | 9/4/21 | 259 | Feature | Amateur | $ 311 | Yes | Yes |
| Better helmets, better games | Aken | 9/4/21 | 358 | Opinion | College | $ 430 | Yes | Yes |
| MLB playoff picture | Tovar | 9/5/21 | 526 | Analysis | Professional | $ 631 | No | No |
| Eight-team playoff is better | Walsh | 9/6/21 | 490 | Opinion | College | $ 588 | Yes | No |
| It's always raining at the Open | Martin | 9/7/21 | 366 | Feature | Professional | $ 439 | Yes | Yes |
| Women's hoops preview | Romano | 9/8/21 | 304 | Feature | College | $ 365 | Yes | Yes |
| Another ref crisis? | Fuentes | 9/9/21 | 401 | Opinion | Professional | $ 481 | Yes | Yes |
| Articles in Progress | ||||||||
| Article Title | Author | Publication Date | Number of Words | Article Type | Sports Level | Payment | Approved? | Published? |
| Article Title | Author | Publication Date | Number of Words | Article Type | Sports Level | Payment | Approved? | Published? |
Proposed Articles
| Article Title | Author | Publication Date | Number of Words | Article Type | Sports Level | Payment | Article Type | Number Proposed | Total Payment | Average Payment | ||
| QB roundup | Fuentes | 9/10/21 | 504 | Feature | College | $ 605 | Analysis | |||||
| Early Heisman talk | Aken | 9/11/21 | 459 | Analysis | College | $ 551 | Feature | |||||
| Little League World Series | Pedraza | 9/12/21 | 510 | News | Amateur | $ 612 | News | |||||
| Pennant race heats up | Kanga | 9/12/21 | 522 | News | Professional | $ 626 | Opinion | |||||
| This week's picks | Walsh | 9/13/21 | 584 | Analysis | Professional | $ 701 | Profile | |||||
| On the leader board | Martin | 9/14/21 | 345 | News | Professional | $ 414 | ||||||
| College catcher does it again | Tovar | 9/15/21 | 338 | Profile | College | $ 406 | Sept 2020 Article Summary | |||||
| On-the-mound decisions | Kanga | 9/15/21 | 530 | Opinion | Professional | $ 636 | ||||||
| Road ahead for AFC East | Fuentes | 9/16/21 | 502 | Analysis | Professional | $ 602 | ||||||
| Powerhouses in the SEC | Aken | 9/16/21 | 423 | Profile | College | $ 508 | ||||||
| The difference is recruiting | Walsh | 9/17/21 | 497 | Opinion | College | $ 596 | ||||||
| Free agent tracker | Romano | 9/18/21 | 384 | Feature | Professional | $ 461 | ||||||
| On-the-mound decisions | Kanga | 9/18/21 | 530 | Opinion | Professional | $ 636 | ||||||
| NL West is where the action is | O'Brien | 9/19/21 | 423 | Analysis | Professional | $ 508 | ||||||
| Surprises out of the NFC North | Fuentes | 9/20/21 | 446 | Feature | Professional | $ 535 | ||||||
August Advertising
| Article Title | Author | Publication Date | Number of Words | Article Type | Sports Level | Ad Amt |
| Last-minute duel in golf | Martin | 8/2/21 | 322 | News | Professional | $ 805 |
| European road bicycle racing? | Pedraza | 8/5/21 | 174 | Opinion | Professional | $ 435 |
| This year could be big in tennis | Tovar | 8/7/21 | 250 | Profile | Professional | $ 625 |
| Third base is a power position | O'Brien | 8/8/21 | 314 | Opinion | College | $ 785 |
| Ups and downs in the NFC East | Fuentes | 8/10/21 | 504 | Feature | Professional | $ 1,260 |
| Ranking NBA journeymen | Romano | 8/10/21 | 446 | Analysis | Professional | $ 1,115 |
| Fantasy baseball movers and shakers | O'Brien | 8/11/21 | 482 | Opinion | Professional | $ 1,205 |
| Women's softball championship | Pedraza | 8/12/21 | 181 | News | Amateur | $ 453 |
| Ups and downs in the NFC South | Fuentes | 8/12/21 | 512 | Feature | Professional | $ 1,280 |
| Ups and downs in the NFC North | Fuentes | 8/13/21 | 524 | Feature | Professional | $ 1,310 |
| Had enough with preseason football? | Walsh | 8/14/21 | 487 | Opinion | Professional | $ 1,218 |
| Ankle injuries are killing the NBA's best | Romano | 8/15/21 | 359 | Opinion | Professional | $ 898 |
| NFL waiver wire | Fuentes | 8/16/21 | 397 | News | Professional | $ 993 |
| Major league baseball is for the young | O'Brien | 8/17/21 | 562 | Profile | Professional | $ 1,405 |
| College football is around the corner | Aken | 8/18/21 | 602 | Feature | College | $ 1,505 |
| Quarterback stability is everything | Walsh | 8/19/21 | 434 | Opinion | College | $ 1,085 |
| Women's soccer and more | Tovar | 8/20/21 | 227 | News | Amateur | $ 568 |
| Eleventh-inning errors | O'Brien | 8/21/21 | 382 | News | College | $ 955 |
| Hernandez comes roaring back | Martin | 8/22/21 | 280 | Analysis | High School | $ 700 |
| Pace of MLB rebuild picks up | O'Brien | 8/24/21 | 420 | Feature | Professional | $ 1,050 |
| Time for another MLB expansion? | Tovar | 8/25/21 | 388 | Opinion | Professional | $ 970 |
| Head-to-head points and ranks | Aken | 8/27/21 | 230 | News | High School | $ 575 |
| New to fantasy baseball? | Tovar | 8/28/21 | 256 | Feature | Professional | $ 640 |
| Closer trends and strategies | O'Brien | 8/30/21 | 314 | Analysis | College | $ 785 |
| Hidden college football stars | Walsh | 8/31/21 | 477 | Profile | College | $ 1,193 |
Lookup
| ID | Article Title | Article Type | Publication Date | Ad Amt | Article Information | ||
| O210 | European road bicycle racing? | Opinion | 8/5/21 | $ 435 | Article ID | A720 | |
| N329 | Women's softball championship | News | 8/12/21 | $ 453 | Article Title | ||
| N447 | Women's soccer and more | News | 8/20/21 | $ 568 | Publication Date | ||
| N552 | Head-to-head points and ranks | News | 8/27/21 | $ 575 | |||
| F316 | European games | Feature | 9/4/21 | $ 622 | Ad Amt | ||
| P453 | This year could be big in tennis | Profile | 8/7/21 | $ 625 | > 500 | ||
| F311 | New to fantasy baseball? | Feature | 8/28/21 | $ 640 | Number of Articles | ||
| A598 | Hernandez comes roaring back | Analysis | 8/22/21 | $ 700 | |||
| F240 | Women's hoops preview | Feature | 9/8/21 | $ 730 | |||
| O697 | Third base is a power position | Opinion | 8/8/21 | $ 785 | Article Type | ||
| A230 | Closer trends and strategies | Analysis | 8/30/21 | $ 785 | Analysis | ||
| N533 | Last-minute duel in golf | News | 8/2/21 | $ 805 | Average Ad Amt | ||
| O239 | Better helmets, better games | Opinion | 9/4/21 | $ 859 | |||
| N251 | Friday night lights | News | 9/3/21 | $ 864 | |||
| F325 | It's always raining at the Open | Feature | 9/7/21 | $ 878 | |||
| O325 | Ankle injuries are killing the NBA's best | Opinion | 8/15/21 | $ 898 | |||
| N245 | Eleventh-inning errors | News | 8/21/21 | $ 955 | |||
| O310 | Another ref crisis? | Opinion | 9/9/21 | $ 962 | |||
| O220 | Time for another MLB expansion? | Opinion | 8/25/21 | $ 970 | |||
| N512 | NFL waiver wire | News | 8/16/21 | $ 993 | |||
| N247 | College football coaching changes | News | 9/1/21 | $ 1,008 | |||
| F305 | Pace of MLB rebuild picks up | Feature | 8/24/21 | $ 1,050 | |||
| O736 | Quarterback stability is everything | Opinion | 8/19/21 | $ 1,085 | |||
| A720 | Ranking NBA journeymen | Analysis | 8/10/21 | $ 1,115 | |||
| O307 | Eight-team playoff is better | Opinion | 9/6/21 | $ 1,176 | |||
| P672 | Hidden college football stars | Profile | 8/31/21 | $ 1,193 | |||
| O789 | Fantasy baseball movers and shakers | Opinion | 8/11/21 | $ 1,205 | |||
| O521 | Had enough with preseason football? | Opinion | 8/14/21 | $ 1,218 | |||
| O238 | So you want to add an ace? | Opinion | 9/2/21 | $ 1,234 | |||
| A156 | Power conferences in the NFL | Analysis | 9/2/21 | $ 1,253 | |||
| F328 | Ups and downs in the NFC East | Feature | 8/10/21 | $ 1,260 | |||
| A162 | MLB playoff picture | Analysis | 9/5/21 | $ 1,262 | |||
| F887 | Ups and downs in the NFC South | Feature | 8/12/21 | $ 1,280 | |||
| F543 | Ups and downs in the NFC North | Feature | 8/13/21 | $ 1,310 | |||
| P622 | Major league baseball is for the young | Profile | 8/17/21 | $ 1,405 | |||
| F482 | College football is around the corner | Feature | 8/18/21 | $ 1,505 |