On 20/10/13 01:15, Paul wrote:
As I noticed you're practically around the corner from me, I got
interested, and had a look at your spreadsheet :)
[tl;dr: I got solutions, but need some help uploading the file. Also,
it may be that you could work it out in a *much* simpler way, using
what you
On Mon, 21 Oct 2013 14:32:40 +0200
Hylton Conacher (ZR1HPC) hyl...@conacher.co.za wrote:
appreciated especially as he also indicates that using VLOOKUP would
not work, in this case. MIN and MAX are still under testing here :)
Brian indicated that VLOOKUP would work; I don't say different, I'm
Let me rather put it this way: I don't think using VLOOKUP solves the
underlying problem, which is that too much is being done in one
formula.
For any complicated formula, I feel the best solution is either a
custom written user function, or intermediate steps in columns. Hide
those columns, or
Another trick that occurred to me when viewing that spreadsheet was
this one: Some of the column headers contain values that are needed in
calculations. Say for instance you have a column header in cell A1 that
reads Max units 250. You can extract the value (250) with
=VALUE(RIGHT(A1,3))
Or, you
On 19/10/13 16:46, Brian Barker wrote:
At 19:11 10/10/2013 +0200, Hylton Conacher wrote:
I have a spreadsheet with four pricing ranges for a certain number of
units.
G4 = 601
H4 = calculated by below formula = 751.25 but should be 751.52
.
F20 = 1.25
G20 = 150 i.e. 0-150 units
h20 = F*G
I20 =
Jay,
On 19/10/13 19:23, Jay Lozier wrote:
Hylton,
If you can breakup the formula into smaller units you might find the
problem.
Often when I have had a similar problem I found the my problem
was I reversed test in an IF clause.
Thanks, I have checked all the IF tests and mathematically they
On 19/10/13 19:32, Jean-Francois Nifenecker wrote:
Hi,
Le 19/10/2013 14:36, Hylton Conacher (ZR1HPC) a écrit :
The initial formula is:
On 19/10/13 20:25, Brian Barker wrote:
At 14:36 19/10/2013 +0200, Hylton Conacher wrote:
Entering a formula into the Function Wizard in Calc shows up two
different answers in the 'Result' and 'Function Result' answer box.
Certainly: there would otherwise be no point in having two boxes.
Hi, Pedro,
On 10/19/13 5:04 PM, Pedro wrote:
Hi snowshed
snowshed wrote
Giving LO another chance, and experimenting with toolbar placement on
the screen, basically moving them from the default horizontal position
at the top, to a vertical position the side.
Since you are running a 4.1
At 16:55 21/10/2013 +0200, Hylton Conacher wrote:
On 19/10/13 16:46, Brian Barker wrote:
To get the best help from others, you really do need to explain
your problem in detail - and that means words, not formulae or
values. Once you have defined your problem, it is very likely
someone can
Hi :)
Uploading files to Nabble is usually easier. Either click on the links in
this email, or navigate from
LibreOffice.org
(errr, or google-it using LibreOffice Nabble (or something) for your
search)
Just above the space to entire your Message is a row of buttons including
one called
Hi :)
If you are on Ubuntu 12.04 or more recent (and probably 10.04 did it but i
just didn't notice at the time or forgot), or on Win7 (possibly Vista too)
or probably any version of Mac or iThings then ...
Grab the title-bar of the 1st one and drag it sharply off right (or off
left).
Once the
Hi Paul,
On 21/10/13 00:26, Paul wrote:
Ok, so I just used a file hosting service found via Google search.
Here's the file I modified with my two solutions:
http://www.filedropper.com/electricity_1
It didn't work the first time or two that I tried to download the file
to check, not sure why,
At 17:31 21/10/2013 +0200, Hylton Conacher wrote:
On 19/10/13 19:32, Jean-Francois Nifenecker wrote:
Le 19/10/2013 14:36, Hylton Conacher a écrit :
The initial formula is:
[...]
this is waaay too convoluted to be easily checked.
I would agree, but it should still work.
Any formula that
At 18:40 21/10/2013 +0200, Hylton Conacher wrote:
I like Brian's MIN/MAX idea too but the price might well need to
change on a month, it just depends on when the local authority
increases prices.
That idea is equally applicable to your current arrangement - with
the price band values
I still think the VLOOKUP function can help tremendously but it does, in
practice, need one or two more columns in the lookup table.
The table as it exists has the number of units in each range, rather
than the values at the breakpoints. These breakpoint values are vital,
as they are what
Hi All,
Just a reminder that we are discussing changing our QA public call time.
If you're at all interested in joining and the current time does not
work, please take a few minutes to look at the options and add your
desired time.
http://doodle.com/z5xic72ng9q3hz8v7aqhxbgt/admin?#table
Hi
Perhaps you can help.
My students submit examinations done in LibreOffice Calc to a web page.
I bundle them up and download them to a Windows XP box running
LO Version 3.6.4.3 (Build ID: 2ef5aff). In previous semesters, an older
version was used. There were no problems like this in previous
Hi guys,
When i run the MS Excel macro in libre office, it runs correctly but shows
the output while clicking on the cell on which output comes.
Option VBASupport 1
Sub Button1_Click()
Dim a As Integer
Dim b As Integer
Dim c As Integer
Range(B1).Select
a = ActiveCell.Text
Range(B3).Select
b =
Hi,
3.6 is EOL - please try with 4.1 and see if the problem is still there.
All the best,
Joel
On 10/21/2013 12:33 PM, David Gast wrote:
Hi
Perhaps you can help.
My students submit examinations done in LibreOffice Calc to a web page.
I bundle them up and download them to a Windows XP box
20 matches
Mail list logo