Comprehensive Excel Assignment Assistance

A spreadsheet with detailed instructions is attached, and I need the entire assignment completed exactly as outlined there. The work involves three core pieces:

• Data entry – copy the raw values into the correct sheets and ranges without altering formatting.
• Formulas and calculations – build dynamic formulas (SUMIFS, VLOOKUP/XLOOKUP, pivot tables if specified) so every total, percentage, or lookup updates automatically when source data changes.
• Creating charts – generate the charts requested in the file, styling them to match any colour or layout cues already present.

Please keep every worksheet structure intact, add only the cells or tabs the assignment explicitly calls for, and double-check that all formulas return the same answers shown in the sample solutions (or, when no answers are given, that they recalculate correctly after I test with new figures). When finished, return the updated .xlsx file; no PDFs or screenshots are necessary unless the instructions say otherwise.

I’ll review the workbook against the attached brief, so accuracy and clean, readable formulas matter more than speed. If anything in the brief seems ambiguous, flag it early so we can clarify before you proceed further.