The Visual Crossing Weather Data Service enables users anywhere to load weather data into Excel, Google Sheets, Relational Databases, Business Intelligence Tools and more. Recently released was a downloadable workbook that allows the user to simply enter locations and query the data to their Excel workbook.
Degree Day Calculator
Degree Days are a way to help determine how much warmth or cold there has been, typically over a season such as winter, summer or a plant's growing season. Degree Days are used to determine a building's typical heating or cooling requirements over a season. They are used in agriculture, farming and gardening to plan plant and crop planting, management and harvest dates. In this blog we provide Microsoft Excel-based degree day calculator that you can download and use.
Multi-site Weather Forecast Workbook
In this blog we will show you the Multi-Site Forecast Workbook which is a modified variation of the Weather Workbook dedicated to showing the forecast for multiple sites in an Excel Pivot Table for optimal viewing. One of the biggest requests we get from users is the ability have a forecast for just a few weather variables where they can quickly see the forecast for all of their locations in a single view. They also want the capability to easily modify those locations as well as flag any temperatures that are outside of a particular range.