Can someone explain and help me with this earned value spreadsheet?

ID Task Name Duration Start Finish Cost % Complete W1 W2 W3 W4 W5 BAC PV EV AC CV SV CPI SPI EAC $7,500 $3,000 0 Project 1 5wk W1-01 W5-D5 $30,000 28% $2,500 $1,000 1 Task 1 5wk W1-01 W5-05 $10,000 50% Details Cost Actual Cost Cost Actual Cost Cost Actual Cost Cost Actual Cost $4,500 $7,500 $7,500 $4,250 $4,000 $1,000 $1,500 $2,500 $2,500 $1,500 $2,000 $500 $2,250 $3,750 $3,750 $2,000 $3,200 $ $750 $ 1,250 $ 1,250 $500 $ 2,450 $ 1,250 $3,750 $1,500 2 Task 2 5wk W1-01 W5-D5 $15,000 25% $1,250 $500 3 Task 3 5wk W1-01 W5-D5 $5,000 75% Today (end of W3) Q1 Project Metric Value What does it indicate about the project? SO CV SV CPI $0 0.00 0.00 $0 SPI EAC Metrics Metrics Q2 Task Name What do they indicate about the task? What do they indicate about the task? CV SV SPI 0.00 Task 1 Task 2 Task 3 $0 $0 $0 $0 $0 $0 0.00 0.00 0.00 0.00 0.00 Q3 What is the overall condition of this project? Details This assignment has been modified to focus more directly on calculating and interpreting Earned Value (EV) project metrics. It uses a spreadsheet extracted from a MS Project file showing a small project with 3 tasks and 5 weeks duration. For the Earned Value calculations, it is currently the end of week 3, and that is the date as of which the EV metrics should be calculated. You will have one attempt to submit the assignment. 1. Download the attached Excel worksheet: Earned Value - Lastname, Firstname.xlsx 2. Save it with your name in the title 3. In the spreadsheet, calculate and enter the values for all 9 EV metrics for each of the 3 tasks and the Summary (Project 1) task. 4. After you have entered the EV metrics, answer Q1, Q2, and Q3 in the spreadsheet (enter your response in the respective spreadsheet cells). Q1 asks you to interpret the meaning of the 5 performance metrics for the project as a whole. o Q2 asks you to interpret the CV and SV metrics and the CPI and SPI metrics for each of the 3 tasks. Q3 asks you to describe the overall condition of the project based on the information revealed by the EV metrics. 5. Save your file, attach it to the assignment, and submit it. 0