# incubator-ooo-users mailing list archives

##### Site index · List index
Message view
Top
From Tony <ableton...@gmail.com>
Subject Re: Scenarios inside a scenario
Date Sat, 19 May 2012 16:52:47 GMT
```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 <jimplante@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 <jimplante@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
>
>

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