This post is really to ask for a good suggestion on how to accomplish this task.
I have made a Template in excel that calculates sales opportunities. The first few columns data is directly imported from the amount of new business sales. The last few columns is where the formulas are stored...