Daljit Dhadwal

Ideas, books, software, and other useful tools

Seasonal adjustment with Demetra+

Demetra+ is a free program provided by Eurostat and the National Bank of Belgium. The software provides a full set of tools for testing whether seasonality exists and then adjusting for it using either the X-12-ARIMA or the TRAMO/SEATS methods. Links: Download JDEMETRA+ (the most up to date version of Demetra+. It is written in […]

Splitting data into separate worksheets in Excel

Here’s some data in Excel 2007 copied from the Northwind Traders database that comes with Microsoft Access. In this post, I’ll cover how to create separate worksheets that only show the information for people having a specific job title. The final result will look like this: This can easily be accomplished in a few steps […]

Brooks’ law

From the Wikipedia article on Brooks’ law: Brooks’ law is a principle in software development which says that “adding manpower to a late software project makes it later”. It was coined by Fred Brooks in his 1975 book The Mythical Man-Month. The corollary of Brooks’ Law is that there is an incremental person who, when […]