Admission Daily Report

Upload every day. Students are matched by Registration No, so a repeated student is updated, not counted twice. Needs these columns: Registration No, Name, Course, Admission Date, Branch Name, Fees Offered, Status.

Use the layout of BDM_Incentive_Calculation_Revised_Policy_v4.xlsx: a sheet named Working with the BDM rows (targets, achievement, average fees, achieved revenue by course) and the Centre Manager rows below them. An optional sheet Policy Inputs updates the policy rates. Each upload replaces the earlier incentive data.

Every upload is recorded here with the date, time and file name. The log is kept even when you clear the admissions.

Admin can upload files and change settings. Viewer can only see the reports. To add a person: first create their login in Supabase (Authentication → Users → Add user), then type their email here.

The file has one row per course and one column per branch. Fill "All Branches" for a common fee, and a branch column only where that branch is different. Empty cells are left unchanged. Or pick a branch below and type its amounts.

Type the numbers in the table, or upload the file. Each ERP course is counted under one target group; set that below.

Rates and conditions used by module 04. Changes apply straight away. The "Policy Inputs" sheet of the incentive file also updates them.