# 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
Network Discovery Software | JDisc Discovery Icon
Network Discovery Software | JDisc Discovery

JDisc Discovery supports the IT organizationss of medium-sized businesses and large-scale enterprises.

JDisc Discovery is a comprehensive network inventory and IT asset management solution designed to help organizations gain clear, up-to-date visibility into their IT environment. It automatically scans and maps devices across the network, including servers, workstations, virtual machines, and network hardware, to create a detailed inventory of all connected assets. This includes critical information such as hardware configurations, software installations, patch levels, and relationshipots between devices.
Learn More
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