scenario manager

Good afternoon all, I use this tool a lot and right now I need to draw a lot of scenarios. As you know, adding scenarios is a manual process. Do you know any VBA expression that allows you to create different scenarios at the same time? Thanks in advance for your time! Best regards, Sofia

Hi, Is there a workaround to add reference cell instead of entering values manually in Scenario manager-Enter values for each of the changing cells, or any alternative suggested method. Because I am using percentage and need full decimals, and it is difficult to enter manually. Thank you very...

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...

Hello, I want to use scenario manager for my calculations but i have too many scenarios(around 1000) with 4 variables. It takes time to write scenarios manually. Besides i may change the scenarios over time. Is there a way to upload scenarios from excel spreadsheet? Or is there another way to...

Hello, <o:p></o:p> <o:p> </o:p> I am struggling with a solution to testing a piece of work. I have been sent it by someone more senior to me who said he has no idea how to test, well neither do I!<o:p></o:p> <o:p> </o:p> Hopefully one kind person out there can help me.<o:p></o:p> <o:p> </o:p> I...

So I have this problem due tonight and I just cannot figure it out at all. I am going to provide the data and am looking for the equation I would enter into the chart. (EXCEL 2007) Here are the problems we have to do. 1. (10 points) Define names for the cells C2:C9 and the cell C21. Fill in the...

IThe following is an example data set: New Price ?? this is what I want to solve Customer Units Price Gross Margin Ext Price Ext Margin ABC...