incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jim Plante <jimpla...@me.com>
Subject Re: Scenarios inside a scenario
Date Mon, 21 May 2012 14:46:42 GMT
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 <abletony84@gmail.com> wrote:
> 
>> Is there no way to put two scenarios (currencies and weights) inside
>> another scenario (languages)?
>> 
>> Thanks!
>> 
>> Tony
>> 


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message