You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Tony <ab...@gmail.com> on 2012/05/19 10:08:35 UTC
Scenarios inside a scenario
Is there no way to put two scenarios (currencies and weights) inside
another scenario (languages)?
Thanks!
Tony
Re: Scenarios inside a scenario
Posted by Tony <ab...@gmail.com>.
Jim,
Would it be possible for you to take a look at this?
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=53969&p=235679
I just wrote a detailed explanation of my problem.
Thank you for writing.
Tony
On Sat, May 19, 2012 at 6:45 PM, Jim Plante <ji...@me.com> wrote:
>
> Conversion factors for the two scenarios can be handled by a VLOOKUP().
>
> Since I haven't seen your problem personally, I'm guessing at a solution.
> Your file is no longer available. If this annoys you, just say so and I'll
> leave you to it.
>
> I'd add a sheet to reflect the 1kg, 1.5kg, and 2kg prices beside the
> countries. Let's call it "Weights" and structure it like this:
> Country 1 1.5 2
> Brazil 10.25 15.00 20.00
> Russia 17.00 27.50 32.00
>
> VLOOKUP (Weights.A1:Weights.A6 "=" Invoice.E21; Weights.A1:Weights.D6; 4;
> FALSE)
>
> The first argument says to look up the word found in cell E21 on sheet
> "Invoice" in the table found on Sheet "Weights" from cell A1 to cell A6.
> The *last* argument, "FALSE", says this has to be an exact match.
>
> The second argument says to look on the "Weights" sheet from A1 to D6. The
> third argument, the index, says to take the return value from column number
> 4 of that array. (The first column is "1", not "0").
>
> This would return 20.00 for Brazil, or 32.00 for Russia, since the answer
> is to be found in column 4. You might want to use an HLOOKUP to set that
> index.
>
> Jim Plante
>
>
> On May 19, 2012, at 10:42 AM, Tony wrote:
>
> > On Sat, May 19, 2012 at 5:38 PM, Jim Plante <ji...@me.com> wrote:
> >
> >> Have you tried imbedding a Calc spreadsheet?
> >>
> >
> > I'm sorry, I thought a scenario _was_ an embedded Calc spreadsheet?
> >
> > Tony
> >
> >
> >>
> >> Jim Plante
> >>
> >> On May 19, 2012, at 3:08 AM, Tony 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
>
>
Re: Scenarios inside a scenario
Posted by Jim Plante <ji...@me.com>.
Conversion factors for the two scenarios can be handled by a VLOOKUP().
Since I haven't seen your problem personally, I'm guessing at a solution. Your file is no longer available. If this annoys you, just say so and I'll leave you to it.
I'd add a sheet to reflect the 1kg, 1.5kg, and 2kg prices beside the countries. Let's call it "Weights" and structure it like this:
Country 1 1.5 2
Brazil 10.25 15.00 20.00
Russia 17.00 27.50 32.00
VLOOKUP (Weights.A1:Weights.A6 "=" Invoice.E21; Weights.A1:Weights.D6; 4; FALSE)
The first argument says to look up the word found in cell E21 on sheet "Invoice" in the table found on Sheet "Weights" from cell A1 to cell A6. The *last* argument, "FALSE", says this has to be an exact match.
The second argument says to look on the "Weights" sheet from A1 to D6. The third argument, the index, says to take the return value from column number 4 of that array. (The first column is "1", not "0").
This would return 20.00 for Brazil, or 32.00 for Russia, since the answer is to be found in column 4. You might want to use an HLOOKUP to set that index.
Jim Plante
On May 19, 2012, at 10:42 AM, Tony wrote:
> On Sat, May 19, 2012 at 5:38 PM, Jim Plante <ji...@me.com> wrote:
>
>> Have you tried imbedding a Calc spreadsheet?
>>
>
> I'm sorry, I thought a scenario _was_ an embedded Calc spreadsheet?
>
> Tony
>
>
>>
>> Jim Plante
>>
>> On May 19, 2012, at 3:08 AM, Tony 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
Re: Scenarios inside a scenario
Posted by Tony <ab...@gmail.com>.
On Sat, May 19, 2012 at 5:38 PM, Jim Plante <ji...@me.com> wrote:
> Have you tried imbedding a Calc spreadsheet?
>
I'm sorry, I thought a scenario _was_ an embedded Calc spreadsheet?
Tony
>
> Jim Plante
>
> On May 19, 2012, at 3:08 AM, Tony 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
>
>
Re: Scenarios inside a scenario
Posted by Jim Plante <ji...@me.com>.
Have you tried imbedding a Calc spreadsheet?
Jim Plante
On May 19, 2012, at 3:08 AM, Tony 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
Re: Scenarios inside a scenario
Posted by Jim Plante <ji...@me.com>.
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 <ji...@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 <ab...@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
Re: Scenarios inside a scenario
Posted by Dwayne Henderson <it...@gmail.com>.
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 <ji...@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 <ab...@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
>
>
Re: Scenarios inside a scenario
Posted by Jim Plante <ji...@me.com>.
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 <ab...@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
Re: Scenarios inside a scenario
Posted by Tony <ab...@gmail.com>.
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 <ab...@gmail.com> wrote:
> Is there no way to put two scenarios (currencies and weights) inside
> another scenario (languages)?
>
> Thanks!
>
> Tony
>