Scenario Manager?

[Sisk]

Hi,

I've been sent the attached spreadsheet which calculates the share of the difference between cost and revenue. The mechanism then weights the difference between the customer and the contractor.

I've been asked to run a model based on certain scenarios and adjusting the two variables to ascertain what the share would be.

Is this better suited to a what if analysis (scenario manager) or given the structure of the data is this better suited to a formula?

Share Calculator.xlsm

 

[Dermot]

I suggest using a data table, see the Scenarios tab in this workbook

Link: Automation with Data tables.xlsx

 

[Sisk]

Thanks for this - I'll work through examples.