MENU
    Viewing the Source Data
    • 1 Minute to read
    • Dark
    • PDF

    Viewing the Source Data

    • Dark
    • PDF

    Article summary

    Here is the source data, which is an Excel spreadsheet of sales opportunities. Opportunity Name would represent the prospective customers. Opportunity Owner would represent the Sales Rep's name. ARR is the revenue potential over a Term of months beginning on Service Start.

    ModelingImagesEDSMOppSourceData1.png

    We will calculate the Service End, and spread the revenue for all opportunities across months beginning from a Planning Start Month of January 2018 to a Planning End Month of December 2019.


    Was this article helpful?