Algebra

Part of my job is being a spreadsheet monkey that analyzes or creates mountains of data. One of the things I love to do is find quick or elegant ways of doing things in Excel. Very commonly, I have to do is to take a cash flow stream that totals one number and "scale" it so that it totals a different number, but keep the relative amounts the same. For example, suppose you are budgeting the sales trip expenses for your department for next year. Usually you would start from this year's expenses, say they were $30,000 .