scenario analysis

Hi - I'm wondering if there is a more efficient way to think about this to present scenarios and charts. This table shows how many patients get enrolled each month in a clinical trial for drug study and the cumulative patients enrolled over time (column I and J). The more clinics (sites) you...

So I'm new to VBA and trying to automate my financial models. I've got this large complex stock valuation model on excel that reads either string bear, bull, or base from a single cell that has a dropdown that has the options of bear, bull, or base. The model will use different inputs depending...

I'm trying to create a scenario matrix for sequences of 4 constrained outputs. For each scenario below, I have a maximal number of laps completed by each rider (9), a minimum number completed by each rider (0.5) and the number of laps completed by each rider can vary in increments of 0.5. The...

Hi there MrExcel community, this is my first forum post! So I have just recently started a new job and blagged that I could do some basic VBA and ...well... let's just say that I am on a steep learning curve :) I have a basic repetitive task that I am hoping one of you could help me with. I've...

Sorry for the lousy title I have had a request from a different team to see if I could solve a problem for them....I cant. So I am turning to my friends here to see if you have an ideas. Basically we have a 13 week promotion table[Col A] That shows the consumer take up as a percentage [Col B]...

Hi, I need a non-invasive custom VBA "what-if" scenario function as follows: WHATIF(Output_Cell, Cell1, Value1, Cell2, Value2, ...) This would give the hypothetical value of the output cell if each of the given input Cells 1 to X were changed to the respective scenario values 1 to X, but...

Hello there, please I need help as I have a data for a call center answering call survey, that survey set by a customer to get us his satisfaction grade about his waiting on Queue till call center agent answer his call, I have 4 Inputs: Group of Customer Average waiting time for customers on...

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

Hi - I'm trying to create a way for different scenarios for an income statement (table in worksheet 1). I would ideally like to have a drop down list that calls data from worksheet 2 and populates worksheet 1. Help? The source of scenario data is layed out as follows (table in worksheet 2)...

Hi Guys, I'm trying to do some scenario analysis in Excel and am currently populating the table manually. Just wondering, is there a way to generate all possible scenarios within excel using a formula? The first few rows of the table look like below, and as its going to take me until 2018 to...