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

2013-01-18 Thread Hylton Conacher (ZR1HPC)
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 indicating how I can get Calc to only use a particular formula range until its result exceeds the amount allowed for

[libreoffice-users] Thunderbird Address Book as Data Source

2013-01-18 Thread David Burleigh
It is very nice that the new 4.0 release includes support for the Thunderbird address book as a data source for mail merges, but it seems to only recognize the Personal Address Book and not any other address books defined in Thunderbird. Is there any way to get it to recognize additional address

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

2013-01-18 Thread Dan Lewis
Perhaps the private suggestion was correct. Perhaps your understanding of Algebra is not as good as it needs to be. After all this is an Algebra problem. Now for some questions: 1. How much will 1 to 150 units cost? What is the formula to determine this? 2. How much will 151 to 599

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

2013-01-18 Thread Tom Davies
Hi :) That was my approach too but then i forgot to send my spreadsheet to Hylton and by the time i remembered Jay had produced an answer that took it to the next level.  I think it's good to see these sorts of problems occasionally because it pushes us outside of our normal thought processes. 

Re: [libreoffice-users] Re: Thunderbird Address Book as Data Source

2013-01-18 Thread webmaster-Kracked_P_P
On 01/18/2013 11:59 AM, Alex Thurgood wrote: On 01/15/2013 03:15 AM, David Burleigh wrote: Hi David, It is very nice that the new 4.0 release includes support for the Thunderbird address book as a data source for mail merges, but it seems to only recognize the Personal Address Book and not

Re: [libreoffice-users] Re: Thunderbird Address Book as Data Source

2013-01-18 Thread James Knott
webmaster-Kracked_P_P wrote: Why do you want both Personaladdress book and Collected ones? I would say that Thunderbird wanted them to be different so you, the user, can choose which address you collected by returning theemail that would go in your personally used address book. MOST of the

Re: [libreoffice-users] Re: Thunderbird Address Book as Data Source

2013-01-18 Thread Dan Lewis
On 01/18/2013 04:58 PM, webmaster-Kracked_P_P wrote: On 01/18/2013 11:59 AM, Alex Thurgood wrote: On 01/15/2013 03:15 AM, David Burleigh wrote: Hi David, It is very nice that the new 4.0 release includes support for the Thunderbird address book as a data source for mail merges, but it seems