# Core Features

* **Smart preflight checks**

* Blocks export if column **E** (Rooms) is entirely empty.
* Aggregates hours per room from column **D** and **stops export** if any room exceeds the weekly capacity in **H1** (shows a detailed alert).
* Validates the selected **FET** file (path/extension/loadability).

# Teacher Name Handling

* **Raw names preserved** exactly as typed in **Sheet1** (no trimming or cleaning when exporting).
* **Fuzzy matching** to FET teachers using normalization + **Levenshtein** distance to suggest the closest match.
* A helper sheet **`Teacher_Map`** appears **only when mismatches exist**; it offers a dropdown (validated list) of official FET names pulled from **`FET_Teachers`**.
* Auto-creates/updates the **`FET_Teachers`** sheet and a named range for data validation.

# FET XML Processing

* **Clears all space constraints** and **keeps only** `C

Project Activity

See All Activity >

Follow AddTeacherHomeRooms

AddTeacherHomeRooms Web Site

Other Useful Business Software
MongoDB Atlas runs apps anywhere Icon
MongoDB Atlas runs apps anywhere

Deploy in 115+ regions with the modern database for every enterprise.

MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
Start Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of AddTeacherHomeRooms!

Additional Project Details

Registered

2025-08-16