Re: [Linux-users] Open Office Calc calculation problen
=IF(N68=N69,TRUE()) can also be written as =N68=N69, which returns TRUE or FALSE =ABS(N68-N69)0.005 will return TRUE if the two values are close enough, or FALSE if they're not. . . . adjust the tolerance value as required. gc On Tue, Nov 16, 2010 at 12:03 AM, Christopher Sawtell csawt...@gmail.comwrote: On 15 November 2010 23:48, Barry barr...@paradise.net.nz wrote: I have a spreadsheet which contains the following formula... =IF(N68=N69,TRUE()) The 2 cells referenced each contain an identical amount formatted 111.11 but the formula returns false. The reason for the error only shows when I reformat the cells to 12 decimal places. How do I set up my formula so that it will work on the displayed rounded values, not the calculated values? BTW the amount causing the problem is the result of calculating GST at 15/115 of the gross amount. Should I be rounding the GST calc? Ideally all money types should be calculated using fixed point arithmetic. Many programmers do not bother. Something like this is an alternative:- IF ((ABS(N69-N69)0.01),TRUE()) -- Sincerely etc. Christopher Sawtell ___ Linux-users mailing list Linux-users@lists.canterbury.ac.nz http://lists.canterbury.ac.nz/mailman/listinfo/linux-users ___ Linux-users mailing list Linux-users@lists.canterbury.ac.nz http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
Re: [Linux-users] ssh connection timed out
Roger Searle wrote, On 11/15/2010 05:00 PM: ro...@neptune:~$ sudo netstat -anltp | grep sshd tcp6 0 0 :::22 :::* LISTEN 6464/sshd Do you have a line that looks like this: tcp0 0 :::22 :::* LISTEN 1688/sshd Also look at tcpdump to see if the packets are hitting the right box On neptune sudo tcpdump -i eth0 port 22 and in another xterm try your ssh session attempt. ^C to stop it. -- Craig Falconer The Total Team - Secure Networks for Serious Business Office: 0800 888 326 / +643 974 9128 Email: workor...@totalteam.co.nz Web: http://www.totalteam.co.nz/ ___ Linux-users mailing list Linux-users@lists.canterbury.ac.nz http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
Re: [Linux-users] ssh connection timed out
IIRC ( having given up on vmware - is virtualbox an option? ) you can create up to 3 network connections, one of which offers networking to the host, and one is bridged. Is the bridged network set up on your Ubuntu client? Cheers, Steve On Mon, 2010-11-15 at 17:00 +1300, Roger Searle wrote: Hi, I am trying to ssh to a Ubuntu 8.04.4 LTS virtual machine - temporary host is an XP box running VMWare Server 2.02. Previously when hosted on an ubuntu box I could ssh to it, whether this move has something to do with this breakage or not I'm unsure. The VM appears to function normally in other ways. I can ping it from the network by name or IP address, I can ping from it by name or IP address. I can ssh from this box to another on the network. I believe the daemon is running and listening on port 22: ro...@neptune:~$ sudo /etc/init.d/ssh restart * Restarting OpenBSD Secure Shell server sshd [ OK ] ro...@neptune:~$ sudo netstat -anltp | grep sshd tcp6 0 0 :::22 :::* LISTEN 6464/sshd Nothing relevant in iptables: ro...@neptune:~$ sudo iptables -L Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination Nothing but commented lines in /etc/hosts.allow and hosts.deny. Error is always this: ro...@mercury:~$ ssh neptune ssh: connect to host neptune port 22: Connection timed out (same with ssh ro...@neptune or ssh ip-address) This also: ro...@mercury:~$ telnet neptune 22 Trying 10.2.1.202... telnet: Unable to connect to remote host: Connection timed out Here endeth my efforts. Can anyone suggest where to from here? Cheers, Roger ___ Linux-users mailing list Linux-users@lists.canterbury.ac.nz http://lists.canterbury.ac.nz/mailman/listinfo/linux-users -- Steve Holdoway BSc(Hons) MNZCS st...@greengecko.co.nz http://www.greengecko.co.nz MSN: st...@greengecko.co.nz Skype: sholdowa smime.p7s Description: S/MIME cryptographic signature ___ Linux-users mailing list Linux-users@lists.canterbury.ac.nz http://lists.canterbury.ac.nz/mailman/listinfo/linux-users