Google Sheet updates for June Invoice Data

[joachimweyl]

Motivation

Update sheets that we use for tracking information and discrepancies.

Completion Criteria

all sheets that utilize the monthly Invoice data are updated.

Description

• [ ] Copy previous months sheet
• [ ] Rename to include - In Progress
• [ ] Review known issues, should be gone if not 0001
  • rezar@bu.edu
  • smonti@bu.edu
  • liagos@bu.edu
  • kthanasi@bu.edu
• [ ] Create HU&BU sheet
• [ ] Create a Lenovo only sheet
• [ ] Create the institutional Rollup sheet
• [ ] Update Billed Utilization
• [ ] Update Monthly Cost Recoveries
• [ ] Add the new BU internal sheet
• [ ] Add the new BU contacts sheet
• [ ] Review with Scott & Milson
• [ ] Clean up items requested in this meeting
• [ ] have it reviewed by Wayne, Nancy & Michael
• [ ] Clean up items requested in this meeting
• [ ] Create CSVs
• [ ] upload CSV to Dropbox of MGHPCC
• [ ] Create PDFs
• [ ] Remove - In Progress
• [ ] Update Billed Utilization Pivot table

Completion dates

Desired - 2024-07-01 Required - 2024-07-02