Re: [Discuss] Financial database / balance?

2012-01-15 Thread Richard Pieri
On Jan 15, 2012, at 8:07 AM, Jerry Feldman wrote: Actually, most spreadsheets use doubles. Yes, they do, and Microsoft has a support page of workarounds for IEEE rounding errors in various versions of Excel because of them: http://support.microsoft.com/kb/214118 --Rich P.

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Jerry Feldman
On 01/15/2012 11:06 AM, Richard Pieri wrote: On Jan 15, 2012, at 8:07 AM, Jerry Feldman wrote: Actually, most spreadsheets use doubles. Yes, they do, and Microsoft has a support page of workarounds for IEEE rounding errors in various versions of Excel because of them:

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Richard Pieri
On Jan 15, 2012, at 11:44 AM, Jerry Feldman wrote: So, while the OP could certainly use canned BCD libraries or integers, using floats and doubles should work fine for most personal stuff. Maybe. I still think that the right way to do it is with arbitrary precision BCD, but that's probably

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Jerry Feldman
On 01/15/2012 12:25 PM, Richard Pieri wrote: On Jan 15, 2012, at 11:44 AM, Jerry Feldman wrote: So, while the OP could certainly use canned BCD libraries or integers, using floats and doubles should work fine for most personal stuff. Maybe. I still think that the right way to do it is with

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Jack Coats
I have had issues with IBMs packed decimal being to short (8 bytes, giving 15 decimal digits plus a sign) for keeping assets of large companies. (yes, very large. Normally we resorted to either writing our own math package or using 'dollar only' accounting. The IRS normally is OK with that.

Re: [Discuss] Financial database / balance?

2012-01-15 Thread markw
On Jan 14, 2012, at 1:23 PM, ma...@mohawksoft.com wrote: That's a HORRIBLE idea! 3 decimal places are worse that IEEE. If it just a home accounting package, use doubles. If it is for the banking industry use a financial math library. IEEE-754 is exactly what you don't want to use.

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Jack Coats
On Fri, Jan 13, 2012 at 8:13 PM, Jack Coats j...@coats.org wrote: When I did mainframe bean counting in the last century, we basically kept a database with the 'end of year' and each 'end of month' amounts for each account, and a MTD (month to date) summery.  We kept the in the month journal

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Richard Pieri
On Jan 15, 2012, at 1:25 PM, Daniel C. wrote: Richard, I'm kind of curious what you have to say about double-entry bookkeeping. It's overkill for most personal finances. Take a look at GNUCash if you want to see how a double-entry financial package works. --Rich P.

Re: [Discuss] Financial database / balance?

2012-01-15 Thread markw
On Jan 15, 2012, at 1:56 PM, ma...@mohawksoft.com wrote: You are confusing display of a double with use of a double. 0.36999556 is numerically, with finite precision less than 15 decimal places, effectively 0.37. No, I'm not. While .36999 etc. is effectively 0.37, it isn't

Re: [Discuss] Comcast gets rid of the remaining analog channels

2012-01-15 Thread Tom Metro
Jerry Feldman wrote: On 01/14/2012 08:23 PM, Bill Bogstad wrote: As I understand it, they are required by FCC regulations to transmit rebroadcasts of over the air channels in the clear. They must provide free equipment to their basic subscribers... Yes, the letter reiterated the same deal

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Jack Coats
I think we all agree, for finances we want integer math, no matter how we implement it. That is counting pennies or mills at the unit of measure. Floating point and binary conversions with their apparent inconsistencies are beyond what we are wanting to live with (like rounding errors, etc).

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Jerry Feldman
On 01/15/2012 01:25 PM, Daniel C. wrote: On Fri, Jan 13, 2012 at 7:43 PM, Richard Pieri richard.pi...@gmail.com wrote: You could go with a double-entry system. It's more complex to write and use but double-entry book-keeping ensures that mistakes and errors are caught immediately. I

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Jerry Feldman
IBM's packed decimal had an effectively unlimited number of digits that the COBOL or PL/1 programmer expressed (such as the COBOL 999.99 has 9 digits with 2 to the right of the decimal point and took up 5 bytes with the sign taking up the rightmost nybble. External decimal is similar except

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Jerry Feldman
On 01/15/2012 02:51 PM, Richard Pieri wrote: On Jan 15, 2012, at 1:56 PM, ma...@mohawksoft.com wrote: You are confusing display of a double with use of a double. 0.36999556 is numerically, with finite precision less than 15 decimal places, effectively 0.37. No, I'm not. While

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Richard Pieri
On Jan 15, 2012, at 4:13 PM, ma...@mohawksoft.com wrote: 0.999 for all intent and purposes is the same a one. And a 0 with an infinite number of 9s after the decimal point equals one. This is true for scientific math, but not for financial math. I find it confusing that you make

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Jerry Feldman
On 01/15/2012 04:21 PM, Jack Coats wrote: I think we all agree, for finances we want integer math, no matter how we implement it. That is counting pennies or mills at the unit of measure. Floating point and binary conversions with their apparent inconsistencies are beyond what we are

Re: [Discuss] Is MythTV dead?

2012-01-15 Thread Tom Metro
Rich Braun wrote: Tom Metro wrote: If you use MythTV as a front-end, have you tried XBMC? If so, why do you prefer MythTV's front-end? Thanks to your posting, I just did. It was a F R U S T R A T I N G waste of 2 hours of my life. The bottom line is summed up at

Re: [Discuss] Financial database / balance?

2012-01-15 Thread markw
On 01/15/2012 02:51 PM, Richard Pieri wrote: On Jan 15, 2012, at 1:56 PM, ma...@mohawksoft.com wrote: You are confusing display of a double with use of a double. 0.36999556 is numerically, with finite precision less than 15 decimal places, effectively 0.37. No, I'm not. While

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Richard Pieri
On Jan 15, 2012, at 6:19 PM, ma...@mohawksoft.com wrote: To address the assertion that you can't represent some numbers exactly, this is partially true. You can use doubles for calculation, but you can't just use printf( %f); to display the value. You need to play some tricks. with floor(),

Re: [Discuss] open protocols for IP-TV

2012-01-15 Thread Tom Metro
Rich Braun wrote: Tom Metro suggested: And the best way to break free of the old-world TV model that the existing studios, networks, and cable companies are clinging to is to reduce barriers for the new upstarts to reach our living rooms. Go to Best Buy and take a look at their TV

Re: [Discuss] Financial database / balance?

2012-01-15 Thread Daniel C.
On Sun, Jan 15, 2012 at 6:19 PM, ma...@mohawksoft.com wrote: That said, there are subtle differences between the two, but beyond that there are different expectations of what precision means. For instance, if you were to write a amortization calculator, you might be tempted to carry

[Discuss] Raid 5 Disk Won't Rebuild

2012-01-15 Thread Chris O'Connell
Greetings Everyone, I have a 6 disk Raid 5 on a Proliant ML350 G3 running Ubuntu 10.04 32-bit and one of the disks failed. No matter what I do I can't get the replacement disk to rebuild. It comes online, rebuilds for 20 minutes then shuts off. I've tried downloading the HP Array utilities for

Re: [Discuss] Debian is now the most popular Linux distribution on web servers

2012-01-15 Thread Edward Ned Harvey
From: discuss-bounces+blu=nedharvey@blu.org [mailto:discuss- bounces+blu=nedharvey@blu.org] On Behalf Of Tom Metro It's easy to speculate that RedHat doesn't get the volume that CentOS does because it costs money, but what does this say about Ubuntu Server, which although commercial

Re: [Discuss] Raid 5 Disk Won't Rebuild

2012-01-15 Thread Edward Ned Harvey
From: discuss-bounces+blu=nedharvey@blu.org [mailto:discuss- bounces+blu=nedharvey@blu.org] On Behalf Of Chris O'Connell I have a 6 disk Raid 5 on a Proliant ML350 G3 running Ubuntu 10.04 32-bit and one of the disks failed. No matter what I do I can't get the replacement disk to