A Multiple Sheet Template for a Sports Team

A Multiple Sheet Template for a Sports Team

A Multiple Sheet Template for a Sports Team

You have just gotten a job with the Pacific Northwest Soccer Club, and you quickly realize that there isn’t a consistent way for all the coaches to keep track of their team statistics. To help with this, you decide to make a template for Season Stats for each team. Since you are also the coach of the High Flyers this season, you will need to use the template to enter your team’s statistics into a team spreadsheet.

When saving files for submission, include your last name in the file name.

  1. Open the data file PR6 Data and save the file to your computer as PR6 Pacific NW Sports Team.
  2. Copy the range B11:G22 in the Season Stats sheet to the same range in the Player Stats sheet.
  3. Group the sheets and add the following formulas to both sheets:
  4. In C22 and D22, you’ll need to count the Xs in rows 12 through 21. To do this, use a COUNTA formula.
  5. In E22 and F22, sum rows 12 through 21.
  6. In G12, calculate Goal Percentage by dividing the number of Goals by the number of Shots. This will display an error message because there are zeros in column F. We don’t want to display error messages in the file, so an IF statement that tests the value of column F will solve this problem.
  7. Change the formula in G12 with the following three pieces:

o    Test – is F12 greater than zero

o    If the Test is True – divide the number of Goals by the number of Shot

o    If the Test is False – enter a zero

  1. Copy G12 down the column through G22. Format these cells as percentages.
  2. For an extra challenge put the “banded row” format back in G12:G22.
  3. Ungroup the sheets.
  4. Save the file as a template called PR6 Pacific NW Team Template.xltx. Make sure to save your template to your USB and not the default folder for templates on your hard drive!
  5. Make a new file using the PR6 Pacific NW Team Templateand save it as PR6 High Flyers.xlsx.
  6. In the Season Stats sheet, enter the following data:

o    D3 – High Flyers

o    D4 – Fall and the current year (i.e. – Fall 2016)

o    D5 – Pacific Northwest Soccer

  1. Enter your name, phone number, and email address in row 8.
  2. Make four copies of the Player Stats worksheet. Rename the player worksheets Player 1, Player 2, Player 3, Player 4, and Player 5.
  3. Group the Player sheets. Enter the following formulas:
  4. A formula in D4 that points to cell D3 in the Season Stats sheet. Note: Your formula will be =’Season Stats’!D3 instead of =’Season Stats’!D3:G3 because D3:G3 are merged together. If you follow the directions as stated in the directions that are currently there you will get a spill error.
  5. A formula in D5 that points to cell D4 in the Season Statssheet.
  6. A formula in D6 that points to cell D5 in the Season Stats sheet.
  7. Ungroup the sheets.
  8. Click on the Player 1 sheet. Enter the Player Name: Juan Ramirez. Enter the following data from Table 1:

 

Player 1 Sheet
  Played Started Shots Goals
Game 1 x x 2 1
Game 2 x x 3 1
Game 3        
Game 4 x      
Game 5 x x 2 0
Game 6 x      
Game 7        
Game 8 x x 1 1
Game 9 x x 4 2
Game 10 x x 3 3
  1. Click on the Player 2 sheet. Enter the Player Name: Zach Johnson. Enter the following data from Table 2: Table 2: Player 2 Sheet

 

Player 2 Sheet
  Played Started Shots Goals
Game 1 x x 1 1
Game 2 x x 2 1
Game 3 x x 1 1
Game 4 x x 1 1
Game 5 x x 2 0
Game 6 x x 5 2
Game 7 x x 4 2
Game 8 x x 1 1
Game 9 x x 4 1
Game 10 x x 3 2
  1. Click on the Player 3 sheet. Enter the Player Name: Vito Lawrenz. Enter the following data from Table 3: Table 3: Player 3 Sheet

 

Player 3 Sheet
  Played Started Shots Goals
Game 1 x x 0 0
Game 2 x x 1 1
Game 3 x x 2 0
Game 4 x   1 1
Game 5 x x 2 0
Game 6 x x 3 1
Game 7 x x 2 1
Game 8 x x 1 1
Game 9 x x 1 1
Game 10 x x 1 1
  1. Make up information for the names and data in the Player 4 and Player 5 sheets.
  2. Go to the Season Stats sheet and click on cell C12. Enter a 3-D formula to COUNTA (count text) in C12 through sheets Player 1 through Player 5. Copy the formula in C12 through D22 (be sure to preserve the original formatting).
  3. Change the formulas in C22 and D22 from COUNTA to Sum.
  4. Click on E12. Enter a 3-D formula to Sum E12 in sheets Player 1 through Player 5. Copy the formulas through F22 (again, be sure to preserve the original formatting).
  5. Preview the worksheets in Print Preview. Notice that only part of the data is printing for each worksheet. This is because a Print Area was incorrectly set when the file was first created. You need to clear this Print Area for each worksheetindividually (modifying print areas cannot be done on grouped sheets). Exit Backstage View and for each worksheet, click the Print Area button on the Page Layout tab and select Clear Print Area.
  6. Save the PR6 High Flyers workbook.
  7. Submit the PR6 High Flyers workbook and PR6 Pacific NW Team Templatetemplate file as directed by your instructor.

Are you overwhelmed by your class schedule and need help completing this assignment? You deserve the best professional and plagiarism-free writing services. Allow us to take the weight off your shoulders by clicking this button.

Get help

Who Will Write your Paper

Writer avatar
Tutor_Charles

Rating: 4.9/5    Reviews 377

Success rate 97%

Completed projects: 545

I am an experienced writer offering professional services across diverse fields. I provide quality work with strict adherence to the deadline.

Writer avatar
Tutor_Dr. Edith

Rating: 4.8/5    Reviews 381

Success rate 99%

Completed projects: 490

I am an experienced writer with great research and analytical skills. Original quality paper and on-time delivery are guaranteed. Let's do this!

Writer avatar
Tutor_Dr.Judy

Rating: 4.7/5    Reviews 316

Success rate 96%

Completed projects: 398

I am a professional writer with more than 8 years of experience. My mission is to provide you with high-quality paper in a timely fashion.

Writer avatar
Tutor_Ian

Rating: 4.8/5    Reviews 371

Success rate 100%

Completed projects: 432

Hi, I deliver quality papers on time following all the instructions provided. Client's satisfaction is my priority. Welcome for plagiarism-free papers.

Writer avatar
Tutor_Prof. Allan

Rating: 4.8/5    Reviews 400

Success rate 96%

Completed projects: 487

With over half a decade of academic experience, I'm committed both to efficiency and punctuality. If it's quality you're looking for, then I'm here to provide!

Writer avatar
Tutor_Prof. Gabie

Rating: 4.9/5    Reviews 447

Success rate 96%

Completed projects: 546

A quality-driven, skilled writer with over 5 years of experience in various disciplines. I deliver plagiarism-free papers and content of impeccable quality, always original and always before the deadline!

Writer avatar
Tutor_Sarah

Rating: 4.9/5    Reviews 427

Success rate 96%

Completed projects: 567

I have been a full-time freelance researcher and writer for a period of over 6 years. I have successfully completed over 1000 projects and assignments. I have had a good professional relationship with my clients. Try me today!

Writer avatar
Tutor_Stella

Rating: 4.9/5    Reviews 305

Success rate 96%

Completed projects: 404

I am a proficient writer with knowledge across a wide range of academic disciplines. I guarantee quality, timely and original content.

Writer avatar
Tutor_SylviaYoung

Rating: /5    Reviews 419

Success rate 99%

Completed projects: 506

Hi, count on me to deliver quality and exemplary papers. I will pay attention to all your instructions, and meet all your expectations.