Google Sheet updates for August 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 the previous month's sheet
• Rename to include - In Progress
• include URI manually for billable
• Review known issues, should be gone if not 0001
  • [email protected]
  • [email protected]
• Create HU&BU sheet
• Manually calculate ESI BM
  • RHELAI 4 nodes (3 nodes * 4 GPUs * $2.078 * 24 hours * 7 days of the month) + (1 nodes * 4 GPUs * $2.078 * 24 hours * 31 days of the month) = $4,189.25 + $6,184.13 = $10,373.38
  • Kruize 1 node (1 node * 4 GPUs * $2.078 * 24 hours * 31 days in month) = $6,184.13
  • InstructLab 1 node (1 node * 4 GPUs * $2.078 * 24 hours * 5 days in month) = $997.44
  • InstructLab 3 FC430s + 3 FC830s ((3 nodes * 24 hours * 31 days * .75)+(3 nodes * 24 hours * 31 days * 3.97) = 1,674 + 8,861.04 = $10,535.04
• Create a Lenovo only sheet
• Create the institutional Rollup sheet
• Check the Test sheet
• Update Billed Utilization
• Update Monthly Cost Recoveries
• Add the new BU internal sheet
• Add the new BU contacts sheet
• Update SAIL Sheet
• Review with Scott & Milson
• Clean up items requested in this meeting (needed for CSV creation)
  • [email protected] has a $1000 credit when he comes back
• have it reviewed by Wayne, Nancy & Michael
• Clean up items requested in this meeting (needed for CSV creation)
  • fix GPU rate
• confirm with @msdisme that we bill for Orran
• Create CSVs
• upload CSV to Dropbox of MGHPCC
• Create PDFs
• Remove - In Progress
• Create new issue to fix Billed Utilization Pivot table
• Provide PDFs to Nancy
• Fix BU&HU sheet name
• fix BM for last month
• create pr to add
  • [email protected]
  • [email protected]
  • [email protected]

Completion dates

Desired - 2024-09-03
Required - 2024-09-04