Does Workfront Scenario Plan export to Excel? | Community
Skip to main content
D
DavidAl1
March 10, 2021
Question

Does Workfront Scenario Plan export to Excel?

  • March 10, 2021
  • 4 replies
  • 1800 views

We are updating quarterly budgets and roadmaps. Before Scenario planner we would adjust projects in Resource Manager, export to Excel where we would slice and dice the data to produce spending and resource graphs. We would like to do this from Scenario Planner for each plan

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    4 replies

    kynabaker16
    Adobe Employee
    kynabaker16Adobe Employee
    Adobe Employee
    March 10, 2021

    Hi David! This is a great question that I don't know off the top of my head, but I know people who do! We have a group specifically for Scenario Planner that the product team watches closely, so I'm going to move your question to that group so they see it.

    Thank you!

    Kyna

    kynabaker16
    Adobe Employee
    kynabaker16Adobe Employee
    Adobe Employee
    March 10, 2021

    Hi @Kyle Silberbauer - inactive‚ and @Anna Asatryan‚ I know you've both been involved in Scenario Planner, can you help answer David's question?

    K
    KyleSi
    March 10, 2021

    Hey David! Right now, no, Scenario Planner does not export directly to Excel/csv. You can report on the SP Initiatives and Job Roles via the regular WF custom Reports module though, and export from there.

    But to provide the best suggestion for you, I would need more information on your use-case:

    Which fields were you using in the Resource Planner export (e.g. AVL, PLN, ACT, VAR, etc.)?

    And which view would you export (e.g. "View by Project" with a quarterly time frame...)?

    D
    DavidAl1Author
    March 11, 2021

    Hi Kyle,

    In Resource Manager I would use AVL and BDG with Costs/QTR for each Project/Initiative. The difference in AVL and BDG would indicate if we had excess resources or needed to increase head

    count. I may also drill down into FTE to indicate specific roles that were over or under utilized.

    This is our first exercise using Scenario Planner so I'll need to play around with how to generate reports based on scenarios.

    Can you point me to any examples or fields I would use to distinguish between plans?

    K
    KyleSi
    March 12, 2021

    We intend for SP to answer that AVL vs. BDG question from within the application itself. For example, we're currently developing better visualizations for Job Role utilization across all Initiatives on the Plan, but you would use this visualization from within SP. Unfortunately, this data is not exportable--though we have heard from other customers as well that they prefer the export, and we may develop that in the future.

    The reports/exports I referred to are for comparing your Plan to what actually happened. I.e. there is an "Initiative Job Role" report that allows you to compare the Initiative Job Role hours vs. the Project PLN or ACT hours.

      Terms & ConditionsAccessibility statement

      Loading footer...