Discuss the mаin principles оf the symbоlic interаctiоnist perspective. Whаt does it emphasize about social behavior?
Here is the spreаdsheet templаte. Exаm 2 - Part 1 Template F25.xlsm Dоwnlоad this file. Rename it tо include your last name. Do all your work (that is, enter your VBA code) in this spreadsheet. You'll submit this file at the end of the exam. Rules: You may use any and all course materials during the exam. You may not use materials that are not part of the course. In particular, you may not search or browse the web, or use GenAI (e.g., ChatGPT, Copilot). All you work, as per the course guidelines, must use commands and approaches covered in class. You may not give or receive assistance to other students. Instructions: The worksheet MLB Data contains salary information about Major League Baseball players for the 2025 season. The player names are in columns B. Column C is the player’s team, D is the player’s position, E is the player’s annual salary, and column F provides the number of years over which the player’s contract extends. The worksheet Divisions contains a list of all 30 MLB teams along with their divisions. (Each team is in a division.) There is also a heading for Team Salary. The buttons you will need have already been created. Using any VBA code we have covered in class (functions, Do While loops, etc.), create code that accomplishes the tasks below. Your code may add as many intermediate columns as you like to the worksheet. Your code should work for any number of rows of data, not just the data in this worksheet. Some problems below rely on the results of previous tasks. If you couldn’t do the previous task, don’t let that stop you from continuing. You may, if you wish, simply write in some data as needed so that you may continue working. Make sure that each time the Calculate button is clicked, the correct answers are displayed. Be sure to use proper indentation. You should document your code enough so that I know which problem your code refers to. REMINDER: SAVE OFTEN. Make sure that if your code goes into an infinite loop you don’t lose any work! Calculate Button Compute the following when the Calculate button is clicked: 1) Write the division that each player is in in column G. (Each team is in one of six possible Divisions. Again, a list of the teams and their division is provided in the Divisions worksheet.) (5 pts) 2) Write “Multiyear” in column H if the number of years on the contract (in column F) is greater than one. It should remain empty otherwise. (2 pts) 3) Calculate the total value of each player’s contract in column I. The total value of a player’s contract is the Annual Salary times the number of years of the contract. (2 pts) 4) Determine the name of the player earning the maximum Annual Salary and put that name in cell N4. (4 pts) 5) Determine the maximum Annual Salary and put that value in cell N5. (3 pts) 6) Determine the minimum Annual Salary and put that value in cell N6. (3 pts) 7) Determine the number of players making the minimum Annual Salary and write that value to N7. (4 pts) 8) In the Divisions worksheet in column C write the salary for each team. The salary for a team is the sum of the Annual Salaries for all the players on that team. (You’ll probably find it helpful to do the worksheet version of this problem in column D and use this to guide your VBA work.) (6 pts) 9) In the MLB Data worksheet, column J write the fraction of the team salary accounted for by the player. For example, if the player’s Annual Salary is $2,000,000 and his Team Salary is $100,000,000 then the fraction of team salary for this player would be $2,000,000 / $100,000,000 = 0.02. (5 pts) 10) Copy columns A:D for all players on team NYM to the worksheet One Team. Include the column headings. There should be no blank rows between players on the One Team worksheet. (5 pts) Format Button 11) The Format button should do the formatting below. On the MLB Data worksheet: a) Format the Total Value amounts as Accounting with no decimal places. (1 pt) b) Bold all column headings. (1 pt) c) Format % of Team Salary data to Percent format with two decimal places. (1 pt) On the Divisions worksheet: d) Format the Team Salary data as Accounting with no decimal places. (2 pts) Reset Button 12) The Reset button should return the workbook to its initial state. This means the following should be cleared: a) In the MLB Data worksheet, the cells containing the Division, Multiple?, Total Value and % of Team Salary (though the column headings should remain) (1 pt) b) In the MLB Data worksheet, the values in N4:N7 (1 pt) c) In the Division worksheet, the Team Salary data (but not the column heading) (1 pt) d) Everything in the One Team worksheet. (1 pt) e) If you created any intermediate columns, you should delete those as well. You do not have to deal with resetting any formatting. 13) Be sure you’ve documented your code so that I can see which problem each part of your code addresses. Be sure to use proper indentation. (5 pts) Be sure to submit your work here when done.