Under Data->Validity...
Select "Cell Range"
That cell range should be your big-ass scenario set out on another sheet.
Example:
Your scenario is on sheet "weights."
On the sheet that makes reference to this, select the cell that displays the
weight, and choose Data->Validity...; select "Cell Range" from the dropdown
box. Enter "weights.A1:weights.c80".
When you select the primary cell, a dropdown will appear showing all 80
selections; scroll down and pick one.
This is still too much of a PITA for regular use, but you asked.
Let's simplify a little. Suppose your desired entry is like so:
We'll call this the Primary sheet, and name it "Prime".
A B C
1 English USD 0,5kg
2
3
On another sheet named "Criteria" have something like this
A
1 English
2 Norwegian
3 Portuguese
...
15 USD
16 GBP
17 ESC
....
30 0.5kg
31 1kg
32 1.5kg
33 2.0kg (personally, I'd leave off the "kg" in this table.k)
....
88 DHL
89 FEX
90 UPS
Select cell Prime.A1. Select Data->Validity...
In the dialog, instead of "All values" you'll use the dropdown to select "Cell
Range."
Either enter the range in the entry box, or hit the little minimizer button at
the side and select the "Criteria" sheet; select cells a1:a3 for the language.
Move to B1 on the Primary sheet, select Data->Validity... and do it again. This
time, select A15:A17
And so on.
After these cells are filled, your sheet can do a lookup of prices or use an
external web-query import if your shipper provides a price sheet based on
weights.
Regards,
Jim
On May 21, 2012, at 7:00 AM, Tony wrote:
> At budsjettmodell.xls <http://home.no/dwaynie/budsjettmodell.xls> (courtesy
> of Innovation Norway <http://innovasjonnorge.no/>) - say for the sheet
> "Fast" - what sort of dropdowns are they using?
>
> Can't I just use those types of dropdowns inside a scenario? Or those types
> of dropdowns without a scenario at all?
>
> I'm desperately trying to avoid having one big ass scenario containing:
>
> English - USD - 0,5kg
> English - USD - 1kg
> English - USD - 1,5kg
> English - USD - 2kg
> English - USD - 2,5kg
> English - USD - 3kg
> English - USD - 3,5kg
> English - USD - 4kg
> English - USD - 4,5kg
> English - USD - 5kg
> English - USD - 5,5kg
> English - USD - 6kg
> English - USD - 6,5kg
> English - USD - 7kg
> English - USD - 7,5kg
> English - USD - 8kg
> English - USD - 8,5kg
> English - USD - 9kg
> English - USD - 9,5kg
> English - USD - 10kg
> English - USD - 10,5kg
> English - USD - 11kg
> English - USD - 11,5kg
> English - USD - 12kg
> English - USD - 12,5kg
> English - USD - 13kg
> English - USD - 13,5kg
> English - USD - 14kg
> English - USD - 14,5kg
> English - USD - 15kg
> English - EUR - 0,5kg
> English - EUR - 1kg
> English - EUR - 1,5kg
> English - EUR - 2kg
> English - EUR - 2,5kg
> English - EUR - 3kg
> English - EUR - 3,5kg
> English - EUR - 4kg
> English - EUR - 4,5kg
> English - EUR - 5kg
> English - EUR - 5,5kg
> English - EUR - 6kg
> English - EUR - 6,5kg
> English - EUR - 7kg
> English - EUR - 7,5kg
> English - EUR - 8kg
> English - EUR - 8,5kg
> English - EUR - 9kg
> English - EUR - 9,5kg
> English - EUR - 10kg
> English - EUR - 10,5kg
> English - EUR - 11kg
> English - EUR - 11,5kg
> English - EUR - 12kg
> English - EUR - 12,5kg
> English - EUR - 13kg
> English - EUR - 13,5kg
> English - EUR - 14kg
> English - EUR - 14,5kg
> English - EUR - 15kg
> English - GBP - 0,5kg
> English - GBP - 1kg
> English - GBP - 1,5kg
> English - GBP - 2kg
> English - GBP - 2,5kg
> English - GBP - 3kg
> English - GBP - 3,5kg
> English - GBP - 4kg
> English - GBP - 4,5kg
> English - GBP - 5kg
> English - GBP - 5,5kg
> English - GBP - 6kg
> English - GBP - 6,5kg
> English - GBP - 7kg
> English - GBP - 7,5kg
> English - GBP - 8kg
> English - GBP - 8,5kg
> English - GBP - 9kg
> English - GBP - 9,5kg
> English - GBP - 10kg
> English - GBP - 10,5kg
> English - GBP - 11kg
> English - GBP - 11,5kg
> English - GBP - 12kg
> English - GBP - 12,5kg
> English - GBP - 13kg
> English - GBP - 13,5kg
> English - GBP - 14kg
> English - GBP - 14,5kg
> English - GBP - 15kg
> English - USD - 0,5 pounds
> English - USD - 1 pounds
> English - USD - 1,5 pounds
> English - USD - 2 pounds
> English - USD - 2,5 pounds
> English - USD - 3 pounds
> English - USD - 3,5 pounds
> English - USD - 4 pounds
> English - USD - 4,5 pounds
> English - USD - 5 pounds
> English - USD - 5,5 pounds
> English - USD - 6 pounds
> English - USD - 6,5 pounds
> English - USD - 7 pounds
> English - USD - 7,5 pounds
> English - USD - 8 pounds
> English - USD - 8,5 pounds
> English - USD - 9 pounds
> English - USD - 9,5 pounds
> English - USD - 10 pounds
> English - USD - 10,5 pounds
> English - USD - 11 pounds
> English - USD - 11,5 pounds
> English - USD - 12 pounds
> English - USD - 12,5 pounds
> English - USD - 13 pounds
> English - USD - 13,5 pounds
> English - USD - 14 pounds
> English - USD - 14,5 pounds
> English - USD - 15 pounds
> English - EUR - 0,5 pounds
> English - EUR - 1 pounds
> English - EUR - 1,5 pounds
> English - EUR - 2 pounds
> English - EUR - 2,5 pounds
> English - EUR - 3 pounds
> English - EUR - 3,5 pounds
> English - EUR - 4 pounds
> English - EUR - 4,5 pounds
> English - EUR - 5 pounds
> English - EUR - 5,5 pounds
> English - EUR - 6 pounds
> English - EUR - 6,5 pounds
> English - EUR - 7 pounds
> English - EUR - 7,5 pounds
> English - EUR - 8 pounds
> English - EUR - 8,5 pounds
> English - EUR - 9 pounds
> English - EUR - 9,5 pounds
> English - EUR - 10 pounds
> English - EUR - 10,5 pounds
> English - EUR - 11 pounds
> English - EUR - 11,5 pounds
> English - EUR - 12 pounds
> English - EUR - 12,5 pounds
> English - EUR - 13 pounds
> English - EUR - 13,5 pounds
> English - EUR - 14 pounds
> English - EUR - 14,5 pounds
> English - EUR - 15 pounds
> English - GBP - 0,5 pounds
> English - GBP - 1 pounds
> English - GBP - 1,5 pounds
> English - GBP - 2 pounds
> English - GBP - 2,5 pounds
> English - GBP - 3 pounds
> English - GBP - 3,5 pounds
> English - GBP - 4 pounds
> English - GBP - 4,5 pounds
> English - GBP - 5 pounds
> English - GBP - 5,5 pounds
> English - GBP - 6 pounds
> English - GBP - 6,5 pounds
> English - GBP - 7 pounds
> English - GBP - 7,5 pounds
> English - GBP - 8 pounds
> English - GBP - 8,5 pounds
> English - GBP - 9 pounds
> English - GBP - 9,5 pounds
> English - GBP - 10 pounds
> English - GBP - 10,5 pounds
> English - GBP - 11 pounds
> English - GBP - 11,5 pounds
> English - GBP - 12 pounds
> English - GBP - 12,5 pounds
> English - GBP - 13 pounds
> English - GBP - 13,5 pounds
> English - GBP - 14 pounds
> English - GBP - 14,5 pounds
> English - GBP - 15 pounds
> Norwegian - USD - 0,5kg
> Norwegian - USD - 1kg
> Norwegian - USD - 1,5kg
> Norwegian - USD - 2kg
> Norwegian - USD - 2,5kg
> Norwegian - USD - 3kg
> Norwegian - USD - 3,5kg
> Norwegian - USD - 4kg
> Norwegian - USD - 4,5kg
> Norwegian - USD - 5kg
> Norwegian - USD - 5,5kg
> Norwegian - USD - 6kg
> Norwegian - USD - 6,5kg
> Norwegian - USD - 7kg
> Norwegian - USD - 7,5kg
> Norwegian - USD - 8kg
> Norwegian - USD - 8,5kg
> Norwegian - USD - 9kg
> Norwegian - USD - 9,5kg
> Norwegian - USD - 10kg
> Norwegian - USD - 10,5kg
> Norwegian - USD - 11kg
> Norwegian - USD - 11,5kg
> Norwegian - USD - 12kg
> Norwegian - USD - 12,5kg
> Norwegian - USD - 13kg
> Norwegian - USD - 13,5kg
> Norwegian - USD - 14kg
> Norwegian - USD - 14,5kg
> Norwegian - USD - 15kg
> Norwegian - EUR - 0,5kg
> Norwegian - EUR - 1kg
> Norwegian - EUR - 1,5kg
> Norwegian - EUR - 2kg
> Norwegian - EUR - 2,5kg
> Norwegian - EUR - 3kg
> Norwegian - EUR - 3,5kg
> Norwegian - EUR - 4kg
> Norwegian - EUR - 4,5kg
> Norwegian - EUR - 5kg
> Norwegian - EUR - 5,5kg
> Norwegian - EUR - 6kg
> Norwegian - EUR - 6,5kg
> Norwegian - EUR - 7kg
> Norwegian - EUR - 7,5kg
> Norwegian - EUR - 8kg
> Norwegian - EUR - 8,5kg
> Norwegian - EUR - 9kg
> Norwegian - EUR - 9,5kg
> Norwegian - EUR - 10kg
> Norwegian - EUR - 10,5kg
> Norwegian - EUR - 11kg
> Norwegian - EUR - 11,5kg
> Norwegian - EUR - 12kg
> Norwegian - EUR - 12,5kg
> Norwegian - EUR - 13kg
> Norwegian - EUR - 13,5kg
> Norwegian - EUR - 14kg
> Norwegian - EUR - 14,5kg
> Norwegian - EUR - 15kg
> Norwegian - GBP - 0,5kg
> Norwegian - GBP - 1kg
> Norwegian - GBP - 1,5kg
> Norwegian - GBP - 2kg
> Norwegian - GBP - 2,5kg
> Norwegian - GBP - 3kg
> Norwegian - GBP - 3,5kg
> Norwegian - GBP - 4kg
> Norwegian - GBP - 4,5kg
> Norwegian - GBP - 5kg
> Norwegian - GBP - 5,5kg
> Norwegian - GBP - 6kg
> Norwegian - GBP - 6,5kg
> Norwegian - GBP - 7kg
> Norwegian - GBP - 7,5kg
> Norwegian - GBP - 8kg
> Norwegian - GBP - 8,5kg
> Norwegian - GBP - 9kg
> Norwegian - GBP - 9,5kg
> Norwegian - GBP - 10kg
> Norwegian - GBP - 10,5kg
> Norwegian - GBP - 11kg
> Norwegian - GBP - 11,5kg
> Norwegian - GBP - 12kg
> Norwegian - GBP - 12,5kg
> Norwegian - GBP - 13kg
> Norwegian - GBP - 13,5kg
> Norwegian - GBP - 14kg
> Norwegian - GBP - 14,5kg
> Norwegian - GBP - 15kg
> Norwegian - USD - 0,5 pounds
> Norwegian - USD - 1 pounds
> Norwegian - USD - 1,5 pounds
> Norwegian - USD - 2 pounds
> Norwegian - USD - 2,5 pounds
> Norwegian - USD - 3 pounds
> Norwegian - USD - 3,5 pounds
> Norwegian - USD - 4 pounds
> Norwegian - USD - 4,5 pounds
> Norwegian - USD - 5 pounds
> Norwegian - USD - 5,5 pounds
> Norwegian - USD - 6 pounds
> Norwegian - USD - 6,5 pounds
> Norwegian - USD - 7 pounds
> Norwegian - USD - 7,5 pounds
> Norwegian - USD - 8 pounds
> Norwegian - USD - 8,5 pounds
> Norwegian - USD - 9 pounds
> Norwegian - USD - 9,5 pounds
> Norwegian - USD - 10 pounds
> Norwegian - USD - 10,5 pounds
> Norwegian - USD - 11 pounds
> Norwegian - USD - 11,5 pounds
> Norwegian - USD - 12 pounds
> Norwegian - USD - 12,5 pounds
> Norwegian - USD - 13 pounds
> Norwegian - USD - 13,5 pounds
> Norwegian - USD - 14 pounds
> Norwegian - USD - 14,5 pounds
> Norwegian - USD - 15 pounds
> Norwegian - EUR - 0,5 pounds
> Norwegian - EUR - 1 pounds
> Norwegian - EUR - 1,5 pounds
> Norwegian - EUR - 2 pounds
> Norwegian - EUR - 2,5 pounds
> Norwegian - EUR - 3 pounds
> Norwegian - EUR - 3,5 pounds
> Norwegian - EUR - 4 pounds
> Norwegian - EUR - 4,5 pounds
> Norwegian - EUR - 5 pounds
> Norwegian - EUR - 5,5 pounds
> Norwegian - EUR - 6 pounds
> Norwegian - EUR - 6,5 pounds
> Norwegian - EUR - 7 pounds
> Norwegian - EUR - 7,5 pounds
> Norwegian - EUR - 8 pounds
> Norwegian - EUR - 8,5 pounds
> Norwegian - EUR - 9 pounds
> Norwegian - EUR - 9,5 pounds
> Norwegian - EUR - 10 pounds
> Norwegian - EUR - 10,5 pounds
> Norwegian - EUR - 11 pounds
> Norwegian - EUR - 11,5 pounds
> Norwegian - EUR - 12 pounds
> Norwegian - EUR - 12,5 pounds
> Norwegian - EUR - 13 pounds
> Norwegian - EUR - 13,5 pounds
> Norwegian - EUR - 14 pounds
> Norwegian - EUR - 14,5 pounds
> Norwegian - EUR - 15 pounds
> Norwegian - GBP - 0,5 pounds
> Norwegian - GBP - 1 pounds
> Norwegian - GBP - 1,5 pounds
> Norwegian - GBP - 2 pounds
> Norwegian - GBP - 2,5 pounds
> Norwegian - GBP - 3 pounds
> Norwegian - GBP - 3,5 pounds
> Norwegian - GBP - 4 pounds
> Norwegian - GBP - 4,5 pounds
> Norwegian - GBP - 5 pounds
> Norwegian - GBP - 5,5 pounds
> Norwegian - GBP - 6 pounds
> Norwegian - GBP - 6,5 pounds
> Norwegian - GBP - 7 pounds
> Norwegian - GBP - 7,5 pounds
> Norwegian - GBP - 8 pounds
> Norwegian - GBP - 8,5 pounds
> Norwegian - GBP - 9 pounds
> Norwegian - GBP - 9,5 pounds
> Norwegian - GBP - 10 pounds
> Norwegian - GBP - 10,5 pounds
> Norwegian - GBP - 11 pounds
> Norwegian - GBP - 11,5 pounds
> Norwegian - GBP - 12 pounds
> Norwegian - GBP - 12,5 pounds
> Norwegian - GBP - 13 pounds
> Norwegian - GBP - 13,5 pounds
> Norwegian - GBP - 14 pounds
> Norwegian - GBP - 14,5 pounds
> Norwegian - GBP - 15 pounds
>
> On Sat, May 19, 2012 at 10:08 AM, Tony <[email protected]> wrote:
>
>> Is there no way to put two scenarios (currencies and weights) inside
>> another scenario (languages)?
>>
>> Thanks!
>>
>> Tony
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
