|
Seen it, done it.
One favourite was a statutory pension calculation and having a right old barney with the client. They were convinced our numbers were too low and, should any member have a low pension the statutory part should have caused it to be higher and they would be breaking the law if they didn't meet the statutory component.
After several test cases with real data, I found the problem. They had been rounding the wrong way. For years! In some cases they had even been over paying pensions.
veni bibi saltavi
|
|
|
|
|
I have had similar experiences where data has been checked by three people and none of them spotted the incorrect population of data. We ended up sending out 30,000 emails to largely the wrong people.
In the case mentioned above it was because when you sort a dataset within SAS the sorting is lost as soon as that dataset is used within a SQL statement. So our data looked good on the sort, however as the sort was lost when that dataset was subsequently queried nobody spotted it.
It happens to everyone given time
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
OriginalGriff wrote: Until I realise the Excel formula is using 29 days data and dividing by 30...and has been doing that for 3 years Your whole life was a lie!
|
|
|
|
|
I thought that was the cake?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
That would be convenient as there is no spoon to eat the cake with
|
|
|
|
|
OriginalGriff wrote: Excel formula is using 29 days data and dividing by 30...and has been doing that for 3 years
So you could have been a trillionaire, but now you just get by?
|
|
|
|
|
Out of curiosity, why do you have the number of days hard-coded? Excel can easily determine the number of days in a range.
|
|
|
|
|
Well, that's just silly talk!
|
|
|
|
|
Gets the cake from honoured leader [6]
What process is used in making cake?
veni bibi saltavi
modified 18-Sep-15 6:31am.
|
|
|
|
|
I would say "REDLEA" but is that a cake?
I do know that's a chicken shop.
I ain't got no signature.
|
|
|
|
|
No, that isn't right, you got one white peg though
veni bibi saltavi
|
|
|
|
|
"BAKING"?
I get the "KING" part, but not sure about "BA".
You have just been Sharapova'd.
|
|
|
|
|
BA = honoured, as an Bachelor or Art; tenuous at best
Whatevs, it's you come Monday
veni bibi saltavi
|
|
|
|
|
Oh! I totally forgot I am up for FSOW as well...
You have just been Sharapova'd.
|
|
|
|
|
∂óŎŎÓÓòƍ (8)
No clues to start.
PooperPig - Coming Soon
|
|
|
|
|
Balloons?
You have just been Sharapova'd.
|
|
|
|
|
You're up next week!
PooperPig - Coming Soon
|
|
|
|
|
Oh, I didn't anticipate that to be correct. Sorry for spoiling the fun.
You have just been Sharapova'd.
|
|
|
|
|
Balloons
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
You're so good at making these up that I am not sure I want to answer them anymore. This is entrtaining.
|
|
|
|
|
707 thanks!
I made this one easy as I don't think I will have time to do one.
Wanted to do double letters as using the same letter more than once makes 'em easier to solve (I think, anyway!)
And I remembered that Balloon was one of only a few words that have consecutive doubles..
The rest is the slog of looking through the characters to find something suitable.
I couldn't find one I thought looked enough like a bursting balloon though
PooperPig - Coming Soon
|
|
|
|
|
Movie Quote Of The Day
Stop the suicides or I swear I will shoot him.
Which movie?
|
|
|
|
|
I refuse to answer due to the complete ugliness of the story. I've read better toilet paper.
Geek code v 3.12 {
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- r++>+++ y+++*
Weapons extension: ma- k++ F+2 X
}
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
|
|
|
|
|
ya... you do ... but we have plenty of guards...
DVL
|
|
|
|
|
True story
#region(start signature)
Life's like a nose, you've got to get out of it whats in it!
#endregion
|
|
|
|