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 15:03:45 GMT
You're welcome, Dwayne. OOo hid this dropdown box under the Validity function, and I stumbled
across it on another forum--or maybe the OOo Community forum.

Jim

On May 21, 2012, at 9:50 AM, Dwayne Henderson wrote:

> Bless you Jim, I really appreciate this! :-)
> 
> Let me play around with this for a while and report back ASAP!
> 
> --Dwayne
> 
> On Mon, May 21, 2012 at 4:46 PM, Jim Plante <jimplante@me.com> wrote:
> 
>> 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
>> 
>> 


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