Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,030
Son of a _(gun)_! What are the odds?!
Just spent ten minutes checking code and couldn't find a bug. Opened the source file and I'll be danged!
Source file is a mainframe report that is 936 "pages" long and has 82,889 lines. My code tosses header rows as it reads the file. Danged if the report didn't have EXACTLY 65,535 rows of actual data. More often than not, this report bridges two worksheets every month. But when the second worksheet had zero rows of data, I thought my previously bullet proof code had run into some screwball character in the file or something.
Who woulda thunk it?! Obviously not a "one-in-a-million", but given that this report normally runs 60K to 80K rows of data, gotta figure it was a 1-in-10,000 or 1-in-20,000 shot.
[I have a suspicion that one of our stats-lovin' members is gonna tell me that figuring cumulative odds of hitting number "x" on "n" tries is such and such, still - I would think it's one heck of a long shot.]
Just spent ten minutes checking code and couldn't find a bug. Opened the source file and I'll be danged!
Source file is a mainframe report that is 936 "pages" long and has 82,889 lines. My code tosses header rows as it reads the file. Danged if the report didn't have EXACTLY 65,535 rows of actual data. More often than not, this report bridges two worksheets every month. But when the second worksheet had zero rows of data, I thought my previously bullet proof code had run into some screwball character in the file or something.
Who woulda thunk it?! Obviously not a "one-in-a-million", but given that this report normally runs 60K to 80K rows of data, gotta figure it was a 1-in-10,000 or 1-in-20,000 shot.
[I have a suspicion that one of our stats-lovin' members is gonna tell me that figuring cumulative odds of hitting number "x" on "n" tries is such and such, still - I would think it's one heck of a long shot.]
Last edited: