This repo illustrates how to estimate GCP energy consumption using data from the GCP Billing export in BigQuery. The script provided scans all resource usage over a trailing thirty day period and estimates consumption by using a hard-coded coefficient lookup table.