Notice that the spreadsheet contains data on three companies; each has different asset classes that were placed in service over a period of three years. Imagine what you’d have to do to manually ...
It creates a reusable function that takes three inputs: actual sales, sales quota, and a weighting factor. It returns a weighted performance score by dividing sales by quota and multiplying by the ...