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

2013-02-14 Thread Tom Davies
...@conacher.co.za To: users@global.libreoffice.org Sent: Thursday, 14 February 2013, 6:07 Subject: [libreoffice-users] Calc scale formula conundrum/ logic confusion Using Calc 3.4.5 on openSuse 11.2 I am trying to work out the currency value of the amount of electricity units I have left

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

2013-02-14 Thread Brian Barker
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 help figure it out. Now the trick is trying to find it

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

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

2013-02-13 Thread zr1hpc
Using Calc 3.4.5 on openSuse 11.2 I am trying to work out the currency value of the amount of electricity units I have left at the end of the month (G2). This same formula will be used for the other 11 months of the year with only the G2 reference changing to G3, G4...etc. For those who wish to