Advanced Permutation Table We use Python's handy itertools.permutations() function to populate a local Access table with unique permutation values.
Reader Challenge Logic Puzzle Solution Part 3: Counting the Possible Configurations When I first read through the five-house logic puzzle, I kept thinking, "I should just brute force this thing." I was so naive...
Reader Challenge Logic Puzzle Solution Bonus: SQL Server Edition Reader Johann Preissl writes in with a pure T-SQL solution to the Five-House Logic Puzzle. No tables or VBA required!
Reader Challenge Logic Puzzle Solution Part 2: Testing the neighborhood Class Module In part 2 of my Access solution for the five-house logic problem, we test the neighborhood class module.
Reader Challenge Logic Puzzle Solution Part 1: The oNeighborhood Class Module In part 1 of my Access solution for the five-house logic problem, I demonstrate the class module I used to model a neighborhood configuration.
Reader Challenge Solving the Five-House Logic Problem by Hand In this follow-up to my post on the classic Five-House Logic Problem, I provide the solution to the riddle plus a few tips for finding it.
Reader Challenge Reader Challenge: Einstein's Five-House Logic Problem In part 1 of this series, I introduce a classic logic problem that took me nearly two hours to solve by hand. Later in the series, we'll use Access to program a solution.
Reader Challenge Calculating Gift Counts for "The Twelve Days of Christmas": Recursion Edition In the second solution to my recent reader challenge, I use recursion to calculate the cumulative number of gifts given for each day of the "12 Days of Christmas."
Reader Challenge Calculating Gift Counts for "The Twelve Days of Christmas": Looping Edition In the first solution to my recent reader challenge, I use a loop to calculate the cumulative number of gifts given for each day of the "12 Days of Christmas."
Reader Challenge Reader Challenge: Write a Formula to Calculate Gift Totals in "The Twelve Days of Christmas" How many total gifts does one's true love deliver by the nth day of Christmas? It's a deceptively tricky problem to solve.