Campus Earnings Excel Spreadsheet Creation

Job ID: 38208653

Budget: $30 – $250 USD

I need a skilled Microsoft Excel expert to create intricate spreadsheets for me. Effective organization and an understanding of formulas are crucial to accurately calculate the earnings of various campuses. The data to be considered includes:

- Number of students per caseload
- Total revenue generated per student
- Student exceptionality eligibility areas (1-3)
- Student grade level
- Student ID number
- Student learning segments (1-6)
- Student services

The formulas required in this project will be the sum of total revenue generated per student and the revenue generated for all students on a caseload. Your role will involve integrating these formulas onto the spreadsheet to calculate campus earnings comprehensively.

Additionally, the calculated campus earnings will need to be categorized and presented in the Excel spreadsheet as follows:

- Total campus earnings per caseload
- Campus earnings per student exceptionality eligibility area
- Campus earnings per student grade level
- Campus earnings per student learning segment
- Campus earnings per student service

It's essential that you have prior experience dealing with complex Microsoft Excel tasks and possess an eye for detail. An understanding of primary and secondary campus environments would be greatly beneficial. I'm looking forward to analyzing organized, error-free, automated income data for my campuses.