The Same Instrument Appearing on Three Different Lists
Departmental spreadsheets brought in as they are
Same item on more than one list, surfaced on import
By department, by campus, or the whole university
Departments still manage their own equipment
1. The Problem
A multi-campus university has as many asset registers as it has departments, and each is maintained by somebody with other responsibilities. The formats differ, the level of detail differs, and the same equipment appears more than once: a spectrometer bought by one department, moved to a shared facility, and recorded again there. Add the lists together and the total is confidently wrong.
That matters when the university has to report an aggregate position, for its annual accounts, for a NAAC or NIRF submission, or when the vice-chancellor asks a straightforward question about what the institution owns. It also matters for procurement, because a department raising a purchase has no way of knowing that the same instrument is standing idle two buildings away.
2. How ASTITVAAMS Handles It
The first phase is usually consolidation rather than tagging, because the lists already exist. Four things do the work:
Import what departments already have
Existing spreadsheets are brought in as they are, in their own formats, rather than asking every department to start again.
Duplicates surfaced, not silently merged
Where the same item appears on two lists, it is flagged for a person to confirm. Automatic merging would hide exactly the errors you are trying to find.
Departments keep control
Each department manages its own equipment and sees its own register. Consolidation is about visibility upward, not taking control away.
Reports that roll up and drill down
The same data answers a departmental query and a university-wide one, so nobody is collecting files to build a total.
The university stops adding up lists that overlap. ASTITVAAMS holds every campus in one register and identifies duplicates rather than compounding them, and a total is something you can defend.
3. What Changes for You
- ✓An aggregate figure you can stand behind: For annual accounts or an accreditation submission, the total comes from one register rather than a sum of overlapping spreadsheets.
- ✓Duplicate purchases become avoidable: A department can check whether the instrument it is about to buy is already on campus and underused.
- ✓Departments lose no autonomy: Each still manages its own equipment. What changes is that the centre can see the whole without asking for files.
Take This Away
A PDF covering how existing departmental spreadsheets are imported, how duplicates are surfaced for review, and what consolidated reporting looks like. Useful for a registrar and finance office.