Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scenario Analysis... simple
Howdie,
I have 12 total scores. Each score is an A, B, C or D (say in a1,b1,c1,d1) I have a formulae which calculates Percentages of each, combines them, and then gives an overall result (say in cell E1) I want to see effects of scoring 12 A, and zero B,C,D and then 11A, 1B,zero C's etc ANy ideas? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scenario Analysis... simple
Are you sure you want to do this. There are about 20,000 permiutations and
combinations of 12 scores in 4 categories? Unless I have missunderstood your question... "Darin Kramer" wrote: Howdie, I have 12 total scores. Each score is an A, B, C or D (say in a1,b1,c1,d1) I have a formulae which calculates Percentages of each, combines them, and then gives an overall result (say in cell E1) I want to see effects of scoring 12 A, and zero B,C,D and then 11A, 1B,zero C's etc ANy ideas? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scenario Analysis... simple
Sorry I misread your post... The combinations are far less than that. I'll
look at it again... "Jim Thomlinson" wrote: Are you sure you want to do this. There are about 20,000 permiutations and combinations of 12 scores in 4 categories? Unless I have missunderstood your question... "Darin Kramer" wrote: Howdie, I have 12 total scores. Each score is an A, B, C or D (say in a1,b1,c1,d1) I have a formulae which calculates Percentages of each, combines them, and then gives an overall result (say in cell E1) I want to see effects of scoring 12 A, and zero B,C,D and then 11A, 1B,zero C's etc ANy ideas? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scenario Analysis... simple
You are still over 2,000 combinations. I can not imagine that this is what
you wanted... "Jim Thomlinson" wrote: Sorry I misread your post... The combinations are far less than that. I'll look at it again... "Jim Thomlinson" wrote: Are you sure you want to do this. There are about 20,000 permiutations and combinations of 12 scores in 4 categories? Unless I have missunderstood your question... "Darin Kramer" wrote: Howdie, I have 12 total scores. Each score is an A, B, C or D (say in a1,b1,c1,d1) I have a formulae which calculates Percentages of each, combines them, and then gives an overall result (say in cell E1) I want to see effects of scoring 12 A, and zero B,C,D and then 11A, 1B,zero C's etc ANy ideas? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scenario Analysis... simple
Sub DD()
i = 0 For j = 0 To 12 For k = 0 To 12 For l = 0 To 12 For m = 0 To 12 If j + k + l + m = 12 Then i = i + 1 Cells(i, 1) = j Cells(i, 2) = k Cells(i, 3) = l Cells(i, 4) = m End If Next m: Next l: Next k: Next j End Sub gives me 455 combinations. -- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... Howdie, I have 12 total scores. Each score is an A, B, C or D (say in a1,b1,c1,d1) I have a formulae which calculates Percentages of each, combines them, and then gives an overall result (say in cell E1) I want to see effects of scoring 12 A, and zero B,C,D and then 11A, 1B,zero C's etc ANy ideas? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scenario Analysis... simple
Fantastic Tom. As always very impressive. Thanks *** Sent via Developersdex http://www.developersdex.com *** |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scenario Analysis... simple
My math skills are just way off... I am going to chaulk this up to a monday
morning thing... I used to be Ok at this kind of thing... Good job Tom "Tom Ogilvy" wrote: Sub DD() i = 0 For j = 0 To 12 For k = 0 To 12 For l = 0 To 12 For m = 0 To 12 If j + k + l + m = 12 Then i = i + 1 Cells(i, 1) = j Cells(i, 2) = k Cells(i, 3) = l Cells(i, 4) = m End If Next m: Next l: Next k: Next j End Sub gives me 455 combinations. -- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... Howdie, I have 12 total scores. Each score is an A, B, C or D (say in a1,b1,c1,d1) I have a formulae which calculates Percentages of each, combines them, and then gives an overall result (say in cell E1) I want to see effects of scoring 12 A, and zero B,C,D and then 11A, 1B,zero C's etc ANy ideas? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
simple yet complex scenario - goal seek problem | Excel Worksheet Functions | |||
faster, more effective scenario analysis? | Excel Discussion (Misc queries) | |||
Simple statistical analysis | Excel Worksheet Functions | |||
scenario analysis-multiple variables | Excel Worksheet Functions |