I have a base that has all of our employees (~200) in a people tab. Every month our finance department sends me an updated Excel with everyone that months actuals in terms of employees. Given the number I would like to be able to CSV import this file and then be able to update the people, as well identify who is no longer on the list - and who is new to the list.
Additionally, it would be helpful to be able to use this information in the extensions/interfaces to show charts on the over month-to-month headcount change.
I think I will need to have some record indicator for each person that the records can align to but every idea I have had so far seems overly complicated.
I think one solution that I have been trying to avoid is having a new tab for each month. Then the name record would be linked with the people tab. This seems like it would end up messy, visually at a minimum - unless someone knows a way to hide tabs.