Dr Shaiq Khan is a Chartered Structural Engineer working freelance in the building trade. In his day to day work, he develops and uses spreadsheets for the design and maintenance of buildings. This enables him to enhance the quality of work for his clients. He is generous enough to share his technical expertise with fellow professionals.
I managed to track Shaiq down and I talked to him about his extensive career, his motivations for sharing his knowledge and simply to thank him. You can listen to the interview by clicking on the link.
Yakpol Strikes Again
This spreadsheet solves the famous travelling salesman problem of finding the shortest cyclical itinerary for a travelling salesman who must visit each of N cities in turn. In addition a penalty may me assigned for each river crossing. An algorithm is based on the method of simulated annealing published in the Numerical Recipes in C, 2nd edition (1992).
Yakov Polyakov is another 'spreadsheet king' and an ExcelCalcs User. He is very worthy of our praise and has helped me out of a few tight spots in my time with his many superb structural engineering spreadsheets - you'll find a link to his site here.