A leader is a man who has the ability to get other people to do what they don’t want to do and like it.
— Truman
I was asked today how to use Excel to estimate the power usage of two optical components at case temperatures for which we had no data. I initially solved the problem in Mathcad by fitting an equation of the form to the data and computing the corresponding power.
Since most of the engineers where I work do not use Mathcad, I was asked if I could demonstrate how to get the same answer using Excel. On the assumption that some of you may have similar problems, I have included my SFP_Power spreadsheet here that solves the problem using Solver, an Excel add-in. No macros were required to solve this problem.