Skip to main content

Posts

Sudoku in Excel: Intersection methods

Excel is well known as an environment in which you can create models. Many modellers secure the integrity of their model by a combination of protecting and/or hiding sensitive cells. This is understandable when the model becomes the live or final version. Nevertheless, I have railed against using Excel in this way for 3 decades but have failed to convince colleagues. Using Excel to model solution methods in Sudoku is intended to demonstrate why it is such an excellent environment for exposing the strengths (and weaknesses) of any particular solution method. I concentrate here on two very similar methods referred to as “Intersection”. Background I have published a number of blogs / articles covering the more straightforward elements of users interacting with their Sudoku puzzles. This article builds on the previous publications. Title Source Date Spatial Modelling Techniques in Microsoft Excel EuSpRIG 14th Annual Conference, Greenwich July 20...

The Blood Sugar diet: The Food Table - data sources

The foods we eat vary hugely, even within a relatively small country like the United Kingdom. There is no question of providing the calorific value of every foodstuff that forms your every day diet. The table below was created to meet the needs of my wife and I, while we were on an 8-week diet.  While the specific items in our dietary list may be eccentric, I hope links to our sources of information about calorie content will lead you to the data you need for your own food list.  Much of the data is sourced from the United States Department of Agriculture (USDA)  https://ndb.nal.usda.gov/ndb/  . I have not searched the USDA database, rather Google searches for food calorie information most often provides as the most important source. I use this where appropriate. Ingrediemt Calories Unit Multiple Source Web Page apple 52 g 100 www https://www.healthline.com/nutrition/foods/apples ...