incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dwayne Henderson <its.code.in.h...@gmail.com>
Subject Re: Scenarios inside a scenario
Date Mon, 21 May 2012 14:50:41 GMT
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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message