Image 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. 

Shaiq's Calculations

New! FileStresses Beneath Pads Under Eccentric Loads
New! FileAnalysis & Design of Weld Groups
New! FileIndian Steel Sections
New! FileHistoric 1939 UK Steel Section Properties
New! FileUK Steel Section Properties
New! FileSafe Loads in Axial Compression to BS449
New! FileCapacities of Bolts and Welds to BS449: Part 2
New! FileCapacities of Bolts and Welds to BS5950-1
New! FileCrane Design Guide to BS 5950
New! FileBS 5950 Circular Hollow members
New! FileUnits Conversion
New! FileContinuous Beam Analysis (up to 4 spans)
New! FileLoads beneath Rigid Pile Caps or Rafts
New! FileReinforced Concrete Circular Columns
New! FileReinforced Concrete Rectangular Columns
New! FileRC Rectangular Section Design to BS8110: Part 1 & 2
New! FileReinforced Concrete Sections to BS 8007

Yakpol Strikes Again


FileTravelling salesman problem


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.