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

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

Hi Everyone, I'm trying to do some predictive forecasting with parameters but I'm coming across an issue when using parameters into the future. What i'm trying to do is forecast the amount of people on a waiting list in the future but this can be altered by using parameters which will remove...

Hi all, I know how to use What if Analysis to create a Datatable. When I look at others' excel model, I saw =TABLE(P12,S10) in the cell. I know it's a Datatable using two variables. My question is how to locate that formula in the workbook. How do I know what formula the Datatable using...

Hi, I have an Excel model that uses historical data as one of its inputs. The historical data is voluminous, hence instead of importing into excel and using VLOOKUP (or something similar), i opted to putting the huge database into MS Access, and then import into Powerpivot and using RELATED to...

Hi, Just wondering if anyone can help me. I'm currently trying to solve an equation and put it into an excel formula. If I have the following info: <tbody> Customers 10 Total Revenue $200 Revenue Per Customer $20 </tbody> I want to increase my total revenue by $100 and the increase...

Hi All, I have a range of values - margin delivered from sales across 20 products. They are sorted from biggest to smallest. I have a formula that allows the retailer to enter in the start and finish product e.g. What is the margin contribution from products ranked 5 to product ranked 15, or...

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

Ok first port, i have about 10 variables (A1,B1,...,J1) that are given as input to a large table with about 200,000 cells (2,000x100). After some calculations we have an output that is a table with 10,000 cells (200x50) Now i need to test the above with hundreds of different sets of 10...

Hi all, I have a dataset on sheet 1 and on sheet 2 i created a pivot table and i want to perform what-if analysis on the pivot table data. The problem is that the What-If analysis doesn't appear under the analyze tab and i cant select it from the Pivottable option (Data tab)--> Enable cell...