attach a sample file for testing
1st time post and I've got something that just doesn't make sense.
I'm importing data from a Yahoo group website that I use to calculate monthly dues for a group of associates.
I had an issue a while ago where someone didn't enter their data correctly and I'm trying to write an audit script to make sure all the numbers are correct before doing the billing.
Here's an example of the CSV data that I'm importing:
"09/01/2012", "Big Bird", "717.32", "718.87", "1.55", "801.8", "803.4", "1.6"
"09/07/2012", "Big Bird", "718.87", "720.21", "1.34", "803.4", "804.6", "1.2"
Here is how the data looks after I import it:
Date Name Tach time-in Tach time-out Flown Ttime Hobbs time-in Hobbs time-out Flown Htime 9/1/2012 Big Bird 717.32 718.87 1.55 801.8 803.4 1.6 9/7/2012 Big Bird 718.87 720.21 1.34 803.4 804.6 1.2
So I want to have a formula that verifies that 718.87-717.32 really equals 1.55.
Problem is when I calcuate 718.87-717.32 and compare it to the 1.55 that I imported, they don't match!
I've confirmed that all the cells holding the numbers I imported are set to Number and increased the precision of the numbers to make sure I wasn't getting a rounding error (which seemed unlikely due to the simple numbers I'm using).
Are you using "text to columns" ?
Because when I imported CSV files earlier, the data didn't get the correct "comma" when I used the "text to columns" function. So I had to change that.
I'm working in a norwegian excel though, dunno if it's the same with the english version
@Patel - My goal is to validate the numbers that people have entered into a database that is being exported as a CSV text file. People are entering the numbers manually and I want to audit them before calculating the money they owe. The problem is my audit routine is failing because it can't compare my calculated value with the imported value correctly. I think your idea about the calculating precision is correct, but I can't figure it out. I've tried to increase the number of decimal places to make sure there wasn't any rounding going on and the numbers are very simple. Thanks for looking.
@danielsto - I'm doing an import of a CSV text file so no "text to columns" is being used.
There are currently 1 users browsing this thread. (0 members and 1 guests)