Forum Discussion

mexicarla's avatar
mexicarla
Copper Contributor
Apr 23, 2020

Scenario manager alternatives?

I have a National Incentive budget from Head Office, against which I have to calculate my projected 'spend' on growth incentives for my key sales accounts. I created an Excel workbook which contains...
excel
Formulas and Functions
wumolad's avatar
wumolad
Iron Contributor
Apr 23, 2020

mexicarla Can you send an excel sheet containing some fictitious data to follow your explanation? Not sure I understand your points. Seeing the datasheet will make it easier to understand.

  • mexicarla's avatar
    mexicarla
    Copper Contributor
    Apr 23, 2020

    wumolad Absolutely!  Give me a little time to make my details anonymous. Thanks for the quick reply!!!!

      • mexicarla's avatar
        mexicarla
        Copper Contributor
        Apr 24, 2020

        wumolad Here we go. Have slimmed it down to 3 'customers' ... you'll get the idea I'm sure. 

        No hidden tabs but there are some named ranges for which you won't be able to get a list I'm afraid.

        Any suggestions/feedback is welcomed. Many thanks. 

Resources