Please see attached table. We have students taking training for 5 to 6 weeks. In Spreadsheet we need to add hours with key in for each employee, students’ classes even when they weekly get the schedule on hourly basis and determine average numbers of hours worked weekly for instructors and monthly based upon 7-day workweek. We have almost 9 work sheets in single file which is related to each file with certain number of columns. We want to calculate the student’s number of hours based on their packages and want to check their estimated hours. We have one main data sheet which is linked with instructors’ sheet, students’ sheet, Fleet sheet, Instructor Hours sheet, instructor planner sheet and 4 different schedule sheets (weekly basis). Data will be fetched from main data sheet which will be used in other linked sheets.
we also want to calculate the overall cost with number of lessons students scheduled based on their packages. I will be provided a blueprint of the sheet. The successful freelancer must be able to work with formulas and pivot tables. You will also be required to provide input and ideas on how to improve this sheet.