Highline Excel Class 22: Budgets, Scenarios & Scenarios Report

I have this scenario

A B C D

1 John Susan $10
2 John John $10
3 Peter John $20
4 John Peter $0


What I want is easy I guess; but I don't know wich formula is the best.
I need to create a report that gives me all the differents scenarios for
example.

How many "John" in B are now in C ( I need just a number not a list)
How many "Johns" in B are still "John" in C
How much money a "john B Peter C" collect
A very important one how many names start with a "J"

The only problem is I have almost a hundred of differents columns, so is
impossible to do it manually and I need a report weekly so I was thinking
wich function is the best fit for this.

Any, ANY help or idea is welcome because I'm lost I have no idea how to do
it. Thank you in advance

Hi

I am trying to put a simple (well, kind of simple) model which looks at all potential scenarios.

Say I have 3 people, each of which can be either A B or C (or two could be A and one C for example).

My question is, is there a function in Excel which lists all the potential scenarios? Not important if only ABC but it would be useful if I go A to Z!

Thanks in advance!

Hi I was hoping someone could help me out. I have attached a spreadsheet that has different scenarios that I need an if function to work with. I have detailed it on the spreadsheet exactly what I need to achieve and I would be so gradeful if someone could help me.

Thank you

frankie

I have 1 column for 18 rows of data (data1, data 2, etc.). Each time one
of the data fields changes, it creates a different named result, and will
only ?fit? 1 result (vendor). E.g., one of the variable results has the
following type of formula:
IF(AND
(C11>=720,C6<=125000,C6>0,C5+C6<=1000000,C9<=1,C10<>"CO",C10="NR",C13<=45,C16="NOO",C15<=4,C17="N",C 22="N")
,(Sheet1!A320),"No Vendor Match")
?where the cell on Sheet 1 (different Sheet), at A320 is a specific named
result, e.g., ?Vendor 23?, else ?No Vendor Match?. The formula currently
works, but only for each vendor ID (e.g., A320).
Problem: I have a couple hundred ?vendors?, all related to different
?formulas? (parameters); hence, a couple hundred ?rows? of scenarios
(formulas). However, if a scenario fits a particular ?vendor?, I want that
vendor name/number to show in a single blank cell below my 18 rows of data
input (regardless of the vendor cell reference).
Right now, the individual vendor only shows within the cell containing the
formula, hence the user never knows where in the hundred or so rows the
result will appear.

Basic data input sheet:
data 1 (0 to 100)
data 2 (A to c)
data 3 (67 to 89)
data 4 (etc.)
data 5
data 6
data 7
data 8
data 9
data 10
data 11
data 12
data 13
data 14
data 15
data 16
data 17
data 18

Vendor: _________(result)

--
Message posted via http://www.officekb.com

I'm wanting to creat a form in excel that will allow the user to step through
a series of questions, each one dependant on the previous, in order to work
out which process out of 5 different options they need to follow.

Eg: is customer a company or individual?
If Company selected next question to display will be "Do they want to change
name or close account?" etc etc

What sort of formulae do I need to use to do this?

I'm creating a custom line column chart on 2 axes. The data comprises of the following which I would like to chart out:

Year Revenue (1,2) Results for the year(1,2) Cumulative results (1,2)
1
2
3
etc.

(1,2) reflect each of two scenarios (best case and worst case).

When creating the chart I need to get the revenue (1,2) in columnar form (i.e. bars) , and results for the year (1,2) and cumulative results (1,2) as lines. By default this does not happen (there are 3 in columnar and 3 in bar form).

How can I get the 2 data points as bars and the other 4 data points as lines?

Thanks in advance.

Regards

I have a very complex set of formulas which take in two static numeric input parameters, and results in two values. For example:

Input Parameters (B1, B2)
Salespeople Profit Margin

Output Values (B3, B4)
Revenue Profit

I manually manipulate my two input parameters, and the program outputs Revenue and Profit, based on the two inputs entered. Nothing special here so far.

However, I want to chart out -lots- of different scenarios based on changing the input values and then chart out the results for each scenario. I plan on manually populating the input values myself in the results worksheet, but am looking for a way in Excel to not have to cut/paste hundreds of scenarios (and cut/paste the results as well) back into the results sheet. I am not looking to 'solve' to a minimum or maximum or optimum value. I just want a big spreadsheet of the results (which I intend to graph and perform some data discovery).

I want to run a simulation on a separate worksheet which iterates down my previously chosen input parameters (Salespeople, and profit margin), and then tells me what the results are (revenue, profit) 'as if' I manually did each scenario and recorded it down myself. For example, here is my results worksheet which displays a few scenarios I have pre-defined and want a way to automatically populate C and D.
A B C D
Salespeople Profit-Margin Revenue Profit
1 5%
2 5%
3 5%
4 5%
5 5%
1 10%
2 10%
3 10%
4 10%
5 10%
1 15%
2 15%
3 15%
4 15%
5 15%
etc.

Is there an easy way to do this in Excel without having to learn VBA?

Hi all- I am wasting time on this when I know there is a better way. Trying to analyze various scenarios- two customers we make sales (max capacity to make sales is 3.5 million TOTAL) and recognize net profits at two different percentages (constraints for both go from 0-10%)) One customer has no rebate, the other has a rebate varying anywhere from 2-25%. I am trying to demonstrate various scenarios that would show what sales mix/ profit amounts/ rebates are in their best interest- example- take customer a at 1 million in sales at 10% profit, customer b at 2.5 in sales at 10% profit 15% rebate.....what other scenario (any of the 5 variables changing) might equal this? I've tried scenarios, solver, goal seek, manual....at my wits end...can someone advise? I am not the best- dont' do macros etc- but can hold my own. Thanks for any advice.

I've created three different scenarios and have been able to view them by clicking on the Show button. When I generate a Summary report, the changed cells appear, but the results cells do not. Any suggestions??

Can someone explain how to use this feature in Excel? Trying to figure out if this will help with creating budgets..


Thanks so much.