sensitivity analysis

PRODUCT. SALES. CONTRIBUTION A. $250. 25% B $350. 35% C. $100 10% D. $300 30% I am trying to build a simple tool to update contribution % based on user input (new sales volume) for a...

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

Hey everyone, I have two difficulties to finalize my Sensitivity Analysis and hope that someone can help me out. This is my simplified basis table: <tbody> Income Statement Forecast NET SALES 4907,7 Number of Stores 368 Net Sales per Store 13,3 Cost...

I'am trying to place a macro code to copy Monte Carlo simulation results from a "results" sheet to the "simulation results" sheet. I browsed plenty of forums and solutions bit my macro is still not working as I want. This is my last version that is work but tt copies and paste values only 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...

I'm performing multiple variable sensitivity analysis in an Excel model, and I'm now running into some obstacles when sketching the functionality in VBA. The code needs to do the following: Store the variables and their values into an array (done) Go through each combination of the variable...

Hi All, I'm looking to do a two-variable what-if sensitivity analysis, however, instead of just doing a simple sensitivity to a row cell and a column cell, I would like to shift an entire array as the column and row variables (see below). The reason being that I have multiple "consumer...

Hi All, I'm looking to do a two-variable what-if sensitivity analysis, however, instead of just doing a simple sensitivity to a row cell and a column cell, I would like to shift an entire array as the column and row variables (see below). The reason being that I have multiple "consumer...

Hi, Ive used data tables a fair amount in excel but given the time they take to recalculate (i have many in one s/sheet) im looking to create a macro rather which only runs when i choose to run it, but I've never really used macros before so am hoping for an easy example to get started. Ive...