Overview

This is a real-time weather Dashboard with a forecasting implemented. It utilises API (.csv or .tsv) data and image import functions to display in a dynamic spreadsheet. This allows the user the ability to use live data from any location that they enter. It will display the associated information with necessary lookup functions, conditional formatting, and image URL importing.

All necessary timestamps are available here:

• Introduction (00:00),
• Visual Crossing IMPORTXML (00:19),
• Weather Icon source lookup (00:55),
• Temperature and Features components (01:17),
• Weather Forecasting (03:30),
• Weather Icon implementation (05:10),
• Conditional Formatting (06:41)