Every Cent Counts
-
Or, every .01 of a cent, as reflected in this issue that has just been assigned to me: Original captured amount : 175704.6128 rounded : 175704 Between and the figure was rounded and displyed on as :175,705.00 This is a home loan, for hundreds of thousands, and rounding of cents is a problem? His hands felt the grasp of strong white hairs, and he knew he would not survive this fungus.
-
Or, every .01 of a cent, as reflected in this issue that has just been assigned to me: Original captured amount : 175704.6128 rounded : 175704 Between and the figure was rounded and displyed on as :175,705.00 This is a home loan, for hundreds of thousands, and rounding of cents is a problem? His hands felt the grasp of strong white hairs, and he knew he would not survive this fungus.
ProffK wrote: This is a home loan, for hundreds of thousands, and rounding of cents is a problem? I would guess "Yes". Bankers don't trust applications unless they can see exactly where each cent (or fraction thereof) is. Lose a cent here or a cent there and pretty soon they all add up and someone is wondering where all these cents went.
Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
-
ProffK wrote: This is a home loan, for hundreds of thousands, and rounding of cents is a problem? I would guess "Yes". Bankers don't trust applications unless they can see exactly where each cent (or fraction thereof) is. Lose a cent here or a cent there and pretty soon they all add up and someone is wondering where all these cents went.
Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
I understand that, so let me reform my issue; who sells a house or borrows for a house and includes cents in the amount? By the way, from my sister's days as an articled clerk auditor, I know that several Rand, never mind just cents, are always written off as rounding errors etc. His hands felt the grasp of strong white hairs, and he knew he would not survive this fungus.
-
I understand that, so let me reform my issue; who sells a house or borrows for a house and includes cents in the amount? By the way, from my sister's days as an articled clerk auditor, I know that several Rand, never mind just cents, are always written off as rounding errors etc. His hands felt the grasp of strong white hairs, and he knew he would not survive this fungus.
ProffK wrote: who sells a house or borrows for a house and includes cents in the amount? My house cost £95944.95
Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
-
ProffK wrote: who sells a house or borrows for a house and includes cents in the amount? My house cost £95944.95
Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
-
That is truly the first time I have seen that, and I've been dealing with property sales and home loans for almost six years now. His hands felt the grasp of strong white hairs, and he knew he would not survive this fungus.
My mortgage itself was for £84000.
Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
-
Or, every .01 of a cent, as reflected in this issue that has just been assigned to me: Original captured amount : 175704.6128 rounded : 175704 Between and the figure was rounded and displyed on as :175,705.00 This is a home loan, for hundreds of thousands, and rounding of cents is a problem? His hands felt the grasp of strong white hairs, and he knew he would not survive this fungus.
There is a saying: Look after the pennies and the pounds will look after themsleves which could be applied here. Or as my business analyst wife puts it: rounding errors are still errors. '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
-
Or, every .01 of a cent, as reflected in this issue that has just been assigned to me: Original captured amount : 175704.6128 rounded : 175704 Between and the figure was rounded and displyed on as :175,705.00 This is a home loan, for hundreds of thousands, and rounding of cents is a problem? His hands felt the grasp of strong white hairs, and he knew he would not survive this fungus.
Use doubles, not floats. Do not round until the end of time (or the loan). We needed (at NU) to get accuracy of less than 1p on a 40 year 20 million pound pension scheme; its possible, but tricky. (And who's to say the actuaries were right & we were wrong?!)
-
Use doubles, not floats. Do not round until the end of time (or the loan). We needed (at NU) to get accuracy of less than 1p on a 40 year 20 million pound pension scheme; its possible, but tricky. (And who's to say the actuaries were right & we were wrong?!)
-
The issue isn't with calculations, which I'm sure require some accuracy, but with an actual loan application being made for an amount including cents. His hands felt the grasp of strong white hairs, and he knew he would not survive this fungus.
Shrugs. :sigh: The customer is always right, Keep coding, take the money. The customer is always right, Keep coding, take the money. The customer is always right, Keep coding, take the money. The customer is always right, Keep coding, take the money. The customer is always right, Keep coding, take the money. The customer is always right, Keep coding, take the money. etc.
-
Use doubles, not floats. Do not round until the end of time (or the loan). We needed (at NU) to get accuracy of less than 1p on a 40 year 20 million pound pension scheme; its possible, but tricky. (And who's to say the actuaries were right & we were wrong?!)
Use "currency" (fixed point, not floating) (In SQL use data type "money") '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
-
Or, every .01 of a cent, as reflected in this issue that has just been assigned to me: Original captured amount : 175704.6128 rounded : 175704 Between and the figure was rounded and displyed on as :175,705.00 This is a home loan, for hundreds of thousands, and rounding of cents is a problem? His hands felt the grasp of strong white hairs, and he knew he would not survive this fungus.
ProffK wrote: Original captured amount : 175704.6128 rounded : 175704 Between and the figure was rounded and displyed on as :175,705.00 In the US when working with currency - at least in the insurance business and financing of said - the rounding is done a bit different. If the amount is say 1.49 it will round ( if you are rounding to dollars ) to 1.00. If the amount is 1.50 it will round to 2.00. It even gets a bit tricker than that. Suppose the amount is 1.49678. This will round to 2.00 because firstly you round it from 1.49678 to 1.50 ( the closest cent wise round ) before rounding to dollars. We have customers that do the strangest things. Some round to 5.00 increments and then adjust the loan APR to reflect this. As long as the numbers are correct and the customer signs the form all is well. Richard "Under certain circumstances, profanity provides a relief denied even to prayer --Mark Twain (1835 - 1910)
-
ProffK wrote: This is a home loan, for hundreds of thousands, and rounding of cents is a problem? I would guess "Yes". Bankers don't trust applications unless they can see exactly where each cent (or fraction thereof) is. Lose a cent here or a cent there and pretty soon they all add up and someone is wondering where all these cents went.
Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
Hrmm... but, if we leave ProffK's application as-is, we could then devise a program to collect those discarded fractions of a cent into a bank account held by us. So long as we only move small amounts at a time, it should be fool proof. We'll be rich! Err.. if nothing else, we can sell the movie[^] rights. ;P --Jesse
-
Hrmm... but, if we leave ProffK's application as-is, we could then devise a program to collect those discarded fractions of a cent into a bank account held by us. So long as we only move small amounts at a time, it should be fool proof. We'll be rich! Err.. if nothing else, we can sell the movie[^] rights. ;P --Jesse
Wasn't this one of the sub-plots in Superman III?
Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
-
Wasn't this one of the sub-plots in Superman III?
Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
Yeah... that's where the guys in Office Space stole the idea. --Jesse