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 <[email protected]> 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 <[email protected]> wrote: >>> >>>> Is there no way to put two scenarios (currencies and weights) inside >>>> another scenario (languages)? >>>> >>>> Thanks! >>>> >>>> Tony >>>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
