Nicolas Kruchten

Nicolas Kruchten
builds data visualization tools
at Plotly in Montreal, Canada.

Bridge-Optimizing Genetic Algorithm in Excel VBA


In the fall of 2003, my classmates and I were given an assignment in our Bridge Design course, to model the Salginatobel Bridge as a truss and analyse it using the Stiffness Method in Excel (ignoring buckling effects). As an additional challenge, we were to be awarded bonus marks if we could improve upon the efficiency of this, our professor's favourite bridge, by moving the members around.

Full post »



© Nicolas Kruchten 2010-2021