[libreoffice-users] PDF Creation

2023-03-15 Thread Hylton Conacher (ZR1HPC)
Hi, Running LO 7.4.5.1 and am endeavouring to create a fillable PDF form using Writer. The file will be viewed using the free Adobe Reader software. What I am battling with is the document saving the remote text that is entered so that when it is sent back to me via email as an attachment,

Re: [libreoffice-users] INDEX MATCH to find MAX value?

2022-12-20 Thread Hylton Conacher (ZR1HPC)
the cells below. I hope this helps. Rémy. Le dimanche 18 décembre 2022 à 21:18 +0200, Hylton Conacher (ZR1HPC) a écrit : Hi, I have a RAW Data csv data sheet created which has several of the same date entries in column A and an increasing numerical value in another column i.e.: C   M

[libreoffice-users] INDEX MATCH to find MAX value?

2022-12-18 Thread Hylton Conacher (ZR1HPC)
Hi, I have a RAW Data csv data sheet created which has several of the same date entries in column A and an increasing numerical value in another column i.e.: C M 2022-01-01 0 2022-01-01 0 2022-01-01 0.1 2022-01-01 0.0 2022-01-02 0.0 2022-01-02 0.0

Re: [libreoffice-users] [CLOSED] VLOOKUP Syntax to find MAX on a particular date

2022-08-10 Thread Hylton Conacher (ZR1HPC)
this thread as closed and shall be starting a new thread as I move the data file to Base. Expect the Base questions soon 0:) Apologies again Thank-you Hylton On 2022/08/08 21:25, Hylton Conacher (ZR1HPC) wrote: Hi, Using LO Calc 7.3.2.2 and I have a 28 column table RAW Data table in excess of 65k rows

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-10 Thread Hylton Conacher (ZR1HPC)
Hi Steve, et al, On 2022/08/09 23:05, Steve Edmonds wrote: ... Further to Johnny's question, how is the CSV delimited. Do you just have commas between values or are some values also quoted in " ". There are no " "'s, all comma separated. When I import a simple CSV using Sheet>Insert sheet

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-09 Thread Hylton Conacher (ZR1HPC)
On 2022/08/09 14:53, Johnny Rosenberg wrote: Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC) mailto:hyl...@conacher.co.za>>: Hi Johnny, On 2022/08/08 22:19, Johnny Rosenberg wrote: > Den mån 8 aug. 2022 kl 21:47 skrev Hylton Conacher (ZR1HPC) >

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-09 Thread Hylton Conacher (ZR1HPC)
On 2022/08/08 23:55, Michael H wrote: 1. Vlookup can only return columns to the left of the column you search so you need to introduce the date into a leftward column (N2=B2, copy it, paste into column N, all rows) All the examples I see on the net show that the left most column is the one

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-09 Thread Hylton Conacher (ZR1HPC)
Hi Johnny, On 2022/08/08 22:19, Johnny Rosenberg wrote: Den mån 8 aug. 2022 kl 21:47 skrev Hylton Conacher (ZR1HPC) mailto:hyl...@conacher.co.za>>: Hi, Using LO Calc 7.3.2.2 and I have a 28 column table RAW Data table in excess of 65k rows. A three column sample below:

[libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-08 Thread Hylton Conacher (ZR1HPC)
Hi, Using LO Calc 7.3.2.2 and I have a 28 column table RAW Data table in excess of 65k rows. A three column sample below: DateSimple Date Outdoor Temp 2022-01-01T00:05:00+02:00 2022-01-01 00:05:00 17.5 2022-01-01T00:00:00+02:00 2022-01-01

Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?

2021-12-19 Thread Hylton Conacher (ZR1HPC)
On 2021/12/15 21:11, Hylton Conacher (ZR1HPC) wrote: Hi, I am quickly losing patience with a task that requires a sum of values that occur on the same date, but at different times. My raw data sheet is in 4 columns Date/Time | Value 1| Value Y| Value z 2021-10-08 08:00:00| 5| 7| 0.15 2021-10

Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?

2021-12-16 Thread Hylton Conacher (ZR1HPC)
On 2021/12/15 23:45, Michael D. Setzer II wrote: On 15 Dec 2021 at 21:11, Hylton Conacher (ZR1HPC) wrote: Date sent: Wed, 15 Dec 2021 21:11:55 +0200 To: LibreOffice Users From: "Hylton Conacher (ZR1HPC)" Subject:[l

Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?

2021-12-16 Thread Hylton Conacher (ZR1HPC)
On 2021/12/15 23:29, John Kaufmann wrote: > On 2021-12-15 14:11, Hylton Conacher (ZR1HPC) wrote: >> ... >> I am quickly losing patience with a task that requires a sum of values that occur on the same date, but at different times. >> >> My raw data sh

[libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?

2021-12-15 Thread Hylton Conacher (ZR1HPC)
Hi, I am quickly losing patience with a task that requires a sum of values that occur on the same date, but at different times. My raw data sheet is in 4 columns Date/Time | Value 1| Value Y| Value z 2021-10-08 08:00:00| 5| 7| 0.15 2021-10-08 14:05:16| 3| 10| 5 2021-10-09 10:05:30| 15| 3| 25

Re: [libreoffice-users] Calc airithmetic snafu

2021-11-26 Thread Hylton Conacher (ZR1HPC)
, 2021, at 9:12 AM, "Hylton Conacher (ZR1HPC)" mailto:hyl...@conacher.co.za>> wrote: Hi, Using LO7.2.2.2 <http://7.2.2.2> Calc on iMac 11.6.1(Big Sur). I have a data column that ends in alphabetic letters i.e.   C      |  D 2| 2.4 km|

[libreoffice-users] Calc airithmetic snafu

2021-11-26 Thread Hylton Conacher (ZR1HPC)
Hi, Using LO 7.2.2.2 Calc on iMac 11.6.1(Big Sur). I have a data column that ends in alphabetic letters i.e.   C      |  D 2| 2.4 km|    2.4 3| 4.8 km|    4.8 As the ' km' can't be added in column C, I used the LEFT formula to only extract the first 3 digits, namely =LEFT(C2,3). This works

Re: [libreoffice-users] Updating Data in Calc

2021-06-15 Thread Hylton Conacher (ZR1HPC)
On 2021/06/15 11:28, Dave Howorth wrote: On Mon, 14 Jun 2021 21:35:49 +0200 "Hylton Conacher (ZR1HPC)" wrote: It has often puzzled me why when knowledgeable members of mailing lists such as this, find fault in what someone, less qualified than themselves, suggests. It is not taken v

Re: [libreoffice-users] Updating Data in Calc

2021-06-14 Thread Hylton Conacher (ZR1HPC)
Dear Brian, On 2021/06/13 18:52, Brian Barker wrote: At 15:01 13/06/2021 +0200, Hylton Conacher wrote: A simple sum will do it i.e.: In cell Y4 insert [...] =SUM(M18-$W$4) I'm often puzzled by suggestions such as this. In what way do you think that =SUM(Xm-Yn) differs from =Xm-Yn? The minus

Re: [libreoffice-users] Updating Data in Calc

2021-06-13 Thread Hylton Conacher (ZR1HPC)
Hi Vince, On 2021/06/12 17:20, Vince@Verizon wrote: Hello: Using LO vers 7.1.3.2 (x64) on desktop Windows 10 Home (64-bit). I would greatly receiving an explanation of a formula or function in Calc that updates the data within cell $Y$4 each time the data in column [M] changes.  The formula

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

2021-05-30 Thread Hylton Conacher (ZR1HPC)
Bravo Remy, On 2021/05/29 20:29, Remy Gauthier wrote: Hello, I created something that ressembles what Johnny created, and I understand your data is formatted like so: Data1 Data2 blank Data3 Data4 blank Data5 Data6 You want Data6 to be the maximum of Data2 and Data4 (and possibly more

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

2021-05-30 Thread Hylton Conacher (ZR1HPC)
On 2021/05/29 23:36, Johnny Rosenberg wrote: Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: Hi Johnny, On 2021/05/28 23:44, Johnny Rosenberg wrote: Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: Hi

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

2021-05-29 Thread Hylton Conacher (ZR1HPC)
Hi Johnny, On 2021/05/28 23:44, Johnny Rosenberg wrote: Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: Hi, I have LO 7.0.6.2 and am battling with understanding which formula to use as well as the syntax for that formula. I am aware of the availa

[libreoffice-users] Calc Formula confusion an understanding needed Index/Match

2021-05-28 Thread Hylton Conacher (ZR1HPC)
Hi, I have LO 7.0.6.2 and am battling with understanding which formula to use as well as the syntax for that formula. I am aware of the availability of vlookup, hlookup, Index/Match formula and have settled I think on the right one i.e. Index/Match Below is a portion of my spreadsheet that

[libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?

2021-01-27 Thread Hylton Conacher (ZR1HPC)
Hi, I have a 134 column spreadsheet I am tidying up. An issue has arisen where if I delete a cell's content I do not know what other cell is referencing the deleted cell's content? How can I determine this or should I raise a feature enhancement and if so where? Regards Hylton I am a

[libreoffice-users] Con50: Quarantine errors

2021-01-21 Thread Hylton Conacher (ZR1HPC)
Hi Lizel, Please add the following addresses onto the back-end of FortiMail. Thanks Hylton -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

[libreoffice-users] LO 6.4.6.2 CALC : Appropriate formula?

2020-09-15 Thread Hylton Conacher (ZR1HPC)
HI, USING I have eight data values on a single row with corresponding dates next to each value in the format below i.e. A B C D E F G H 25 01/07 blank 60 09/05 blank 30 26/7 In the 2nd row I would like to show the highest

Re: [libreoffice-users] [SOLVED] Re: Calc 6.0.6.2 IF criteria statement help

2018-11-15 Thread Hylton Conacher (ZR1HPC)
Hi Remy, On 2018/11/13 01:22, remygauthier wrote: Hi, Unclaimed_slips.ods I went back to the original post and downloaded the file you had uploaded to Google Drive. I made what I think were the

Re: [libreoffice-users] Calc 6.0.6.2 IF criteria statement help

2018-11-12 Thread Hylton Conacher (ZR1HPC)
s NBSP == space, but sometimes not. This affects matches, but also sorting.. and sort failures breaks many responses, not just one. These sorting issues are constant for a single edition of libreoffice, but seem to change without any notice on updates.) On Sat, Nov 10, 2018 at 7:44 AM Hylton Conach

[libreoffice-users] Calc 6.0.6.2 IF criteria statement help

2018-11-10 Thread Hylton Conacher (ZR1HPC)
Hi, What I need help with is the formula to find any row from Data.$A$3 to Data$A$1000 and after shortening the 8 digit date value to 6 digit value, and having the same 6 digit value as Summary.$A4, forward ONLY those rows onto the next part of the formula i.e. SUMIF. I have a formula shown

[libreoffice-users] IF doesn't respect AND?

2018-09-27 Thread Hylton Conacher (ZR1HPC)
Hi, I have a spreadsheet of two tabs with tab 1 named 'Data' and the other named 'Summary'. The purpose of this spreadsheet group is to record all credit card account transactions on the 'Data' sheet and then see what value or transaction slips have not bee submitted by suppliers i.e. the

Re: [libreoffice-users] Add column values according to part of date value

2018-08-24 Thread Hylton Conacher (ZR1HPC)
Greetings Brian, To assist I redo my example data: Date:Text :A :B 20180803:Cattle Baron:430.00:BLANK 20180805:Dischem :BLANK :1233.39 20180805:Checkers :BLANK:606.71 20180901:PNP :2000.00 :BLANK 20181001:WW : BLANK

[libreoffice-users] Add column values according to part of date value

2018-08-24 Thread Hylton Conacher (ZR1HPC)
Using LibreOffice Calc 6.0.6.2 on macOS High Sierra. I have data in 4 columns titled Date:Text:A:B A typical row example is: 20180822:PNP:blank:500.00 OR 20180822:PNP:500.00:blank A row will only have a value in column A or B, never both on the same row. There may be multiple rows with

[libreoffice-users] Spellcheck/Find text selection colour?

2018-05-28 Thread Hylton Conacher (ZR1HPC)
Hi, I am using Libreoffice 5.4.7 and deal with large volumes of text and data between Writer and Calc. Very often I need to search for a particular string of text or number and using Ctrl-F allows me to do this. What I am battling with and would like to be able to change is the colour

Re: [libreoffice-users] Calc: Calculate number of days until yesterday IE TODAY-1 to assist in array determination for COUNTIF?

2018-04-28 Thread Hylton Conacher (ZR1HPC)
Morning Brian, Thanks for the reply. On 2018/04/27 20:20, Brian Barker wrote: At 18:04 27/04/2018 +0200, Hylton Conacher wrote: I am running LibreOffice 5.4.6.2 and am using a spreadsheet to enable me to draw graphs based on rainfall received per year, up until the date prior to today. The

[libreoffice-users] Calc: Calculate number of days until yesterday IE TODAY-1 to assist in array determination for COUNTIF?

2018-04-27 Thread Hylton Conacher (ZR1HPC)
Hi, I am running LibreOffice 5.4.6.2 and am using a spreadsheet to enable me to draw graphs based on rainfall received per year, up until the date prior to today. The figures also allow me to compare current rainfall to date to the same period in a previous year. I agree I should probably

Re: [libreoffice-users] Calc: Export as PDF

2018-03-28 Thread Hylton Conacher (ZR1HPC)
bugzilla report 116667 has been resolved/fixed. On 2018/03/27 22:20, Steve Edmonds wrote: Hi. Have you checked Format>Print ranges and checked View>Page break to see that the graphs fit on the page. Does File>Prit preview show all graphs. Steve On 28/03/18 09:01, Hylton Conache

Re: [libreoffice-users] Calc: Export as PDF

2018-03-28 Thread Hylton Conacher (ZR1HPC)
ended all the sheets and defined the print range as the entire sheet and then all graphs showed on Print Preview. I Exported as PDF and viola' all graphs appeared. Thanks, I'll certainly remember to check print range in future. Regards Hylton Steve On 28/03/18 09:01, Hylton Conacher (ZR1HPC) wrote

[libreoffice-users] Calc: Export as PDF

2018-03-27 Thread Hylton Conacher (ZR1HPC)
Hi, I have a large spreadsheet of 23 sheets of which all but two contain full page graphs i.e. at 200% magnification the graph stretches until column K and down to row 25. On a monthly basis I need to select 11 of the sheets, 10 of which hold graphs and Export as PDF into a single PDF. The

Re: [libreoffice-users] Calc: Filtering formula

2017-12-01 Thread Hylton Conacher (ZR1HPC)
On 01/12/2017 21:57, T. R. Valentine wrote: I messed up. Should be: Thank you for the correction. The formula, with a little amendment works flawlessly. =SUMIFS($D$7:$D$1000,$C$7:$C$1000,"=Sold",$D$7:$D$1000,"<0") With this formula I can now search for a certain string in column C and SUM

[libreoffice-users] Calc: Filtering formula

2017-12-01 Thread Hylton Conacher (ZR1HPC)
Hi, I have two adjacent columns where the first contains text and the second contains 9 digit numbers both above and below zero. I would like to SUM the contents of the second column provided it meets two criteria, namely that the first column contains a certain text string and the number

Re: [libreoffice-users] libreoffice 5.3.5.2 display issue

2017-08-22 Thread Hylton Conacher (ZR1HPC)
Hi, On 20/08/2017 23:23, FHDATA wrote: hello, I use the Still version and it's been a couple of days I switched to new Still release 5.3.5.x and I see the row numbers getting smooshed together when I scroll up-and-down (slow or fast does not matter). makes it difficult to see row  numbers or

Re: [libreoffice-users] libreoffice 5.3.5.2 display issue

2017-08-21 Thread Hylton Conacher (ZR1HPC)
Hi, On 20/08/2017 23:23, FHDATA wrote: hello, I use the Still version and it's been a couple of days I switched to new Still release 5.3.5.x and I see the row numbers getting smooshed together when I scroll up-and-down (slow or fast does not matter). makes it difficult to see row  numbers or

[libreoffice-users] Calc 5.3.4.2 Data into cell on 'Frozen' column error

2017-08-06 Thread Hylton Conacher (ZR1HPC)
Hi, I have recently downloaded and installed LO i.e.: Version: 5.3.4.2 Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3 CPU Threads: 4; OS Version: Mac OS X 10.12.6; UI Render: default; Layout Engine: new; Locale: en-ZA (en_GB.UTF-8); Calc: group In previous versions of Calc I have many

Re: [libreoffice-users] COUNTIF / DAYS / ?

2017-05-10 Thread Hylton Conacher (ZR1HPC)
Michael, Thank-you for the time and response On 08/05/2017 08:54, Michael D. Setzer II wrote: Not sure if I fully understand what you are looking at, but here is what I have attempted. Assuming you column data is: A is month B is day of Month C is the rain on day in 2016 D is the rain on day

Re: [libreoffice-users] COUNTIF / DAYS / ?

2017-05-10 Thread Hylton Conacher (ZR1HPC)
milar. Regards Hylton Le dimanche 07 mai 2017 à 21:55 +0200, Hylton Conacher (ZR1HPC) a écrit : Hi, I have a spreadsheet I use to draw graphs and extract information about the rainfall in my area for the last two years. I need to create a formula that will count how many days it rained betwe

[libreoffice-users] COUNTIF / DAYS / ?

2017-05-07 Thread Hylton Conacher (ZR1HPC)
Hi, I have a spreadsheet I use to draw graphs and extract information about the rainfall in my area for the last two years. I need to create a formula that will count how many days it rained between the start of the year, both last year and this year, so I can compare the amount of rainfall

Re: [libreoffice-users] Base and Java

2016-12-02 Thread Hylton Conacher (ZR1HPC)
On 28/11/2016 18:52, Keith Barber wrote: I've created a smallish (200-odd members) membership database in Base. Just in case it's relevant, I populated it with data from a Calc spreadsheet which itself originated as a MS Excel spreadsheet created by my predecessor. On trying to open the table,

[libreoffice-users] Calc formula syntax assistance

2015-12-19 Thread Hylton Conacher (ZR1HPC)
Hi, Running :O 5.0.3.2 on IMac and have seen there is a 5.0.4 update, however, perhaps my issue does not require an update. Anyway, the formula involves COUNTIF with the search range on another sheet and the search criteria in a cell adjacent to the countif formula.

[libreoffice-users] Calc: Searching for values in a certain range string

2014-02-08 Thread Hylton Conacher (ZR1HPC)
Hi, I am looking for a pointer or two to enable me to accomplish what I seek. What I seek is to be able to have a sheet of Lottery results downloaded from the Internet and pasted into a Calc sheet. On another Calc sheet I will have a listing of the 6 numbers held for each specific draw date.

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-04 Thread Hylton Conacher (ZR1HPC)
On 05/01/14 02:10, Ryan Ashley wrote: I have developed a spreadsheet which contains a sheet for the cover and basic information as well as one sheet for every month. There is a cell with a number on every sheet at location H35. I want the average of all of those which are not zero on the first

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

2013-10-21 Thread Hylton Conacher (ZR1HPC)
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

Re: [libreoffice-users] Calc IF problem

2013-10-21 Thread Hylton Conacher (ZR1HPC)
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 =

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

2013-10-21 Thread Hylton Conacher (ZR1HPC)
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

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

2013-10-21 Thread Hylton Conacher (ZR1HPC)
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: =IF(0G4=$G$20,G4*$F$20,IF($G$20G4=$J$20,(G4-$G$20)*$I$20+($F$20*$G$20),IF($J$20G4=$M$20,(G4-$G$20-$J$20)*$L$20+(($G$20*$F$20)+($J$20*$I$20),IF($M$20G4=$P$20

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

2013-10-21 Thread Hylton Conacher (ZR1HPC)
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.

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

2013-10-21 Thread Hylton Conacher (ZR1HPC)
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,

[libreoffice-users] Calc Function Wizard - IF Result differences

2013-10-19 Thread Hylton Conacher (ZR1HPC)
Hi, Entering a formula into the Function Wizard in Calc shows up two different answers in the 'Result' and 'Function Result' answer box. If the editing cursor is placed in a certain section of the formula, only the 'Function Result' answer box holds the correct answer i.e. 751.52004.

[libreoffice-users] Calc IF problem

2013-10-10 Thread Hylton Conacher (ZR1HPC)
Hi, 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 = 1.25 J20 = 200 i.e. 150.0001 - 350 units K20 = I*J L20 = 1.25 M20 = 250 i.e.

Re: [libreoffice-users] Change Y axis labels in Calc chart

2013-03-03 Thread Hylton Conacher (ZR1HPC)
On 25/02/13 17:48, PeterTheBike wrote: In this chart I want to use the names in the legend to be labels in the Y axis instead of the numeric values. Is there a way this can be done please? Sample_position_chart.ods http://nabble.documentfoundation.org/file/n4039977/Sample_position_chart.ods

Re: [libreoffice-users] Re: Calc scale formula conundrum/ logic confusion

2013-02-17 Thread Hylton Conacher (ZR1HPC)
Hi Tom, On 14/02/13 16:41, Tom wrote: Hi :) Yes, of course you can ask different questions. I just thought it was exactly the same question again in which case my answer wouldn't have been so wrong. Thanks , I was hoping so. snip I wonder if there is a really good Maths forum for getting

Re: [libreoffice-users] Calc scale formula conundrum/ logic confusion

2013-02-14 Thread Hylton Conacher (ZR1HPC)
Hi Tom, Brian, On 14/02/13 10:52, Brian Barker wrote: At 07:45 14/02/2013 +, Tom Davies wrote: Someone else asked a very similar question about a month ago ... That someone else was (not surprisingly) the same person! ... and i think someone created a neat calculation or spreadsheet to

Re: [libreoffice-users] Calc SUM Error 502 - How to add results of three IF formulae? - SOLVED

2013-02-04 Thread Hylton Conacher (ZR1HPC)
A BIG THANK YOU to Brian Barker and Johnny Rosenberg as being instrumental in solving the problem by giving me the knowledge I needed to sort out the issue. Bravo guys and Thanks again Hylton -- Hylton is a Lions Club

Re: [libreoffice-users] Calc SUM Error 502 - How to add results of three IF formulae?

2013-02-03 Thread Hylton Conacher (ZR1HPC)
Brian, Thank you, and sorry for the double post of this message. The calculation you provided worked perfectly after correctly identifying the necessary cells to be used. funny though the same formula does not work just 2 columns to the left? See below and I am sure identify the cause as I

[libreoffice-users] Calc SUM Error 502 - How to add results of three IF formulae?

2013-02-02 Thread Hylton Conacher (ZR1HPC)
Hi, I have a formula below which is giving me an Err: 502 on Calc 3.4.5 when I try and calculate a currency total using a sliding scale. =SUMIF(b6c2,d2,0),(IF(b6-c2)c3,d3,0),(IF(b6-c2-c3)c4,sum((b6-c2)-c3)*b4,0 Each IF statement outs only a single answer and all I want to do is SUM

[libreoffice-users] Re: Calc sliding scale formulae? - SOLVED Part 1

2013-01-26 Thread Hylton Conacher (ZR1HPC)
On 10/01/13 17:38, Hylton Conacher (ZR1HPC) wrote: Hi, I am using Calc 3.4.5 on openSuSe Linux 11.2 I am working on a spreadsheet to cater for the monthly measurement of household electricity consumption, new unit purchase and costing of used units. The electricity supplier gives me the first

Fwd: Re: [libreoffice-users] Calc sliding scale formulae?

2013-01-21 Thread Hylton Conacher (ZR1HPC)
This message never seemed to get thru :( Original Message Subject: Re: [libreoffice-users] Calc sliding scale formulae? Date: Fri, 18 Jan 2013 14:00:19 +0200 From: Hylton Conacher (ZR1HPC) hyl...@conacher.co.za Reply-To: LibreOffice Users users@global.libreoffice.org To: users

Re: [libreoffice-users] Calc sliding scale formulae?

2013-01-21 Thread Hylton Conacher (ZR1HPC)
will be using a result in some cells in the formula in another cell. --Dan On 01/18/2013 07:00 AM, Hylton Conacher (ZR1HPC) wrote: It has been privately suggested to me that I want my work done for me, however, whilst I have had theory from the list on how the formulae should work, I have not had anyone

Re: [libreoffice-users] Calc sliding scale formulae?

2013-01-18 Thread Hylton Conacher (ZR1HPC)
. On 01/10/2013 10:38 AM, Hylton Conacher (ZR1HPC) wrote: Hi, I am using Calc 3.4.5 on openSuSe Linux 11.2 I am working on a spreadsheet to cater for the monthly measurement of household electricity consumption, new unit purchase and costing of used units. The electricity supplier gives me the first

Re: [libreoffice-users] Calc sliding scale formulae?

2013-01-16 Thread Hylton Conacher (ZR1HPC)
Jay, Thank you. Your input is appreciated. My comments below. On 10/01/13 19:36, Jay Lozier wrote: On 01/10/2013 10:38 AM, Hylton Conacher (ZR1HPC) wrote: Hi, I am using Calc 3.4.5 on openSuSe Linux 11.2 I am working on a spreadsheet to cater for the monthly measurement of household

[libreoffice-users] Calc sliding scale formulae?

2013-01-10 Thread Hylton Conacher (ZR1HPC)
Hi, I am using Calc 3.4.5 on openSuSe Linux 11.2 I am working on a spreadsheet to cater for the monthly measurement of household electricity consumption, new unit purchase and costing of used units. The electricity supplier gives me the first 150 units of electricity at R1.29 per unit. The

Re: [libreoffice-users] SOLVED - pdf creation issue on a single file?

2012-08-02 Thread Hylton Conacher (ZR1HPC)
, Hylton Conacher (ZR1HPC) wrote: Hi, I have an rainfall.ods document that has 24 tabs. Two of the tabs contain figures and the balance contain graphs of the figures. I recently experienced a problem, it would seem after my last tab addition, that prevents me from creating a PDF file of the selected

Re: [libreoffice-users] pdf creation issue on a single file?

2012-07-31 Thread Hylton Conacher (ZR1HPC)
Brian and Miguel, On 31/07/12 03:03, Brian Barker wrote: At 15:42 28/07/2012 +0200, Hylton Conacher wrote: I have an rainfall.ods document that has 24 tabs. Two of the tabs contain figures and the balance contain graphs of the figures. I recently experienced a problem, it would seem after my

Re: [libreoffice-users] pdf creation issue on a single file?

2012-07-30 Thread Hylton Conacher (ZR1HPC)
On 29/07/12 23:50, MiguelAngel wrote: El 29/07/12 18:12, Hylton Conacher (ZR1HPC) escribió: Hi Miguel, On 28/07/12 18:07, MiguelAngel wrote: El 28/07/12 15:42, Hylton Conacher (ZR1HPC) escribió: Hi, I have an rainfall.ods document that has 24 tabs. Two of the tabs contain figures

Re: [libreoffice-users] pdf creation issue on a single file?

2012-07-29 Thread Hylton Conacher (ZR1HPC)
. LibreOffice 3.4.5 OOO340m1 (Build:1505) A newer edition of LO has not appeared via my Yast software manager, despite there being a few updates. On 07/28/2012 09:42 AM, Hylton Conacher (ZR1HPC) wrote: Hi, I have an rainfall.ods document that has 24 tabs. Two of the tabs contain figures

Re: [libreoffice-users] pdf creation issue on a single file?

2012-07-29 Thread Hylton Conacher (ZR1HPC)
me the choice to print the file or print to a PDF file and asks where to save it and a name for it . . You must be a windows user LOL ! I really feel sorry for windows users ROFLMAO On 07/28/2012 06:42 AM, Hylton Conacher (ZR1HPC) wrote: Hi, I have an rainfall.ods document that has 24 tabs. Two

Re: [libreoffice-users] pdf creation issue on a single file?

2012-07-29 Thread Hylton Conacher (ZR1HPC)
Hi Miguel, On 28/07/12 18:07, MiguelAngel wrote: El 28/07/12 15:42, Hylton Conacher (ZR1HPC) escribió: Hi, I have an rainfall.ods document that has 24 tabs. Two of the tabs contain figures and the balance contain graphs of the figures. I recently experienced a problem, it would seem after my

[libreoffice-users] pdf creation issue on a single file?

2012-07-28 Thread Hylton Conacher (ZR1HPC)
Hi, I have an rainfall.ods document that has 24 tabs. Two of the tabs contain figures and the balance contain graphs of the figures. I recently experienced a problem, it would seem after my last tab addition, that prevents me from creating a PDF file of the selected sheets(12). The PDF

[libreoffice-users] Calc: Identifying duplicate cell values with conditional formatting?

2011-12-12 Thread Hylton Conacher (ZR1HPC)
Hi, Using LibreOffice 3.3.1 and am in the process of editing a 68000 row, 10 column file. There are two main columns that contain the data to be cleaned up with multiple instances of duplication i.e. the same text but only the text case differs between two rows or the text is totally different

[libreoffice-users] Calc row filter extraction

2011-07-28 Thread Hylton Conacher (ZR1HPC)
Hi all, I have a 'data' spreadsheet sheet for my family medical aid on LO 3.3.1 with multiple columns and different information in each column. Please see the text example I include below. What I would ideally like to do is have rows on sheet A, where Column D is the same, linked onto another

Re: [libreoffice-users] Conditional formatting cell copying? - SOLVED

2011-07-16 Thread Hylton Conacher (ZR1HPC)
Tnx all, The solution was to reference the cells without the $ sign before them. If I copied that cell and selected the cells I wanted to apply the conditional format to, selected Paste Special and selected Formats and Formula, it worked a treat. Thanks to whoever thought of the

Re: [libreoffice-users] [Calc] Create and export chart

2011-07-14 Thread Hylton Conacher (ZR1HPC)
Hi Thorsten, On 13/07/11 19:18, Thorsten Kampe wrote: Hi, I have a Calc file which contains multiple sheets. - every sheet contains one month of data: from May 2010 to July 2011. - every sheet has two columes: in column A the days and in column B the actual data. This sounds very

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread Hylton Conacher (ZR1HPC)
Hi Dave, Thanks for the answer, and sorry for the belated reply, however it doesn't work using LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 On OpenSuse 11.0 You are quite correct that the conditional formulae are copied too, however the formulae still refer to the same cell

Re: [libreoffice-users] Conditional formatting cell copying?

2011-07-13 Thread Hylton Conacher (ZR1HPC)
Hi Regina, See my earlier reply to Dave in addition to the below:. Copying and writing the conditions are not the problem. Getting the condition to automatically increment is the problem e.g. I have cell A1 that has the formula to add the contents of cells B1, C1 and D1. Cell A1 also has 3