SPIKE: How to find expense authority information other than MOU

[MaxWardle]

Describe the Issue This ticket is a result of a meeting with Rosemarie, Catherine, Abibat, and I about the current state of the quarterly billing reports. Rosemarie stated that it takes a sizeable amount of time to sort through the MOUs (stored on the LAN) to find expense authority information. There is apparently no lookup tool to find expense authority contact based on account coding, but may be worth looking into. It also may be worth exploring if there is a way to correlate information we already store to an MOU. Another option might be to just store the Expense Authority name and contact in our metadata somewhere.

Additional Context Add any other context, attachments or screenshots

Acceptance Criteria

• [ ] investigate if there is a way to look up expense authority information based on account coding
• [x] is there information that we already store that we could show in the spread sheet that would make it easier to match the MOU with the account coding?
• [ ] look into where we would store expense authority information if we wanted to include it in the spread sheet
• [ ] meeting with team to discuss findings
• [ ] findings recorded somewhere
• [ ] relevant tickets created

[MaxWardle]

Regarding the second acceptance criteria, the project set's team name is in the MOU file name. We could add a column with a list of team names that are related to the account coding. That may help relate Account Coding to an MOU, and subsequently an expense authority.