The Daily WTF: Curious Perversions in Information Technology

2009-05-08 Reply Admin

Zapp Brannigan:
Most of the accountants I know can barely use SUM and COUNT. A few can use VLOOKUP if they have an example from from another spreadsheet and several hours to spare. A formula that complex had to be done by a college intern or an IT busybody. They will, however, do everything in a spreadsheet including database tables and word processing documents. A word to the newbies, don't spend more than 30 seconds formatting a report for accounting, they are only going to re-key it into Excel and reformat it themselves anyway.

Yeah. Sometimes, though, they have no choice but to (re-)key the data in. Take my wife's former employer (a taxi company). First she got all of the corporate vouchers, half filled in by taxi drivers (whose handwriting is worse than doctors, as far as I can tell). Then she had to cross-reference the trips in the dispatch system. Then, because the purveyors of said system had disabled copy/paste during one of their upgrades, she had to key all of that information into Quickbooks (or Excel, depending on which cantankerous client the bill was going to). Of course, then she had to staple them to sheets of paper and Xerox them because the people being billed would refuse to pay unless they saw a copy of the voucher (and sometimes refused anyway).

That's thousands of vouchers per month.

All with the worst handwriting you've ever seen.

Being paid to work hourly, but no overtime because the owner was morally opposed to spending money. 50-60 hours a week.

I actually wrote her a Perl program to reformat her 30k-50k line Excel spreadsheet and create the formulas. Saved her 8 hours a month. Owner never knew, and didn't care.

I'm glad she quit.

2009-05-08 Reply Admin

There is a simple solution to apps like this - don't support them.

I worked in a job where the policy was "if you build it or another staff member builds it, then you are responsible for what goes wrong with it". This policy arose as result of situations similar to the one described. It forced critical apps to come out of the woodwork and be re-developed if necessary and cut down on pesky service desk inquiries.

MS Office 'extensibility' is responsible for so many problems its a wonder someone hasn't tried to sue them!

2009-05-09 Reply Admin

Wi nøt trei a høliday in Sweden this yer? See the løveli lakes The wønderful telephøne system And mäni interesting furry animals

2009-05-09 Reply Admin

Sorry, meant to quote. was simply too funny...

bjolling:
Real-modo:
My parents had a problem with a spreadsheet my sister set up for them, and they asked me for help.
I _____________________ and now they ___________.
A møøse once bit my sister ... No realli!

Wi nøt trei a høliday in Sweden this yer? See the løveli lakes The wønderful telephøne system And mäni interesting furry animals

2009-05-09 Reply Admin

Use action verb?

Maurits · 2009-05-09 Reply Admin

N Morrison:
Buddy:
For ridiculous Excel formulas, I'd try to convince them to do it in steps, one per column, then hide the intermediate results.
Convert them to your own functions written in VBA. Much easier to debug and maintain, and often far simpler.

I've just put a price on N Morrison's head.

2009-05-09 Reply Admin

arty the king:
Wi nøt trei a høliday in Sweden this yer? See the løveli lakes The wønderful telephøne system And mäni interesting furry animals

Too bad we don't use ø in the swedish language then...

2009-05-09 Reply Admin

Sparr:
"...*365.25+1900" is going to fail when you pass 2100, which is not a leap year. 2000 was an exception to an exception to an exception to the rule (that years have 365 days).

Ok! Cool, thanks. Pretty sure Excel won't be used in 2100 anymore, though. (At least I hope so.)

saepius

2009-05-09 Reply Admin

Protector one:

Ok! Cool, thanks. Pretty sure Excel won't be used in 2100 anymore, though. (At least I hope so.)

saepius

I'll betcha $100 it's still in use in 2100. Consider: Kodak, made up name in use almost 100 years later. Ditto Rolex. This assumes we don't run out of power or off ouselves first.

DaveK · 2009-05-09 Reply Admin

Maurits:
N Morrison:
Buddy:
For ridiculous Excel formulas, I'd try to convince them to do it in steps, one per column, then hide the intermediate results.
Convert them to your own functions written in VBA. Much easier to debug and maintain, and often far simpler.

I've just put a price on N Morrison's head.

Smart move. N Morrison is a VBA programmer. [image]

He'll probably end up doing himself just to claim the reward.

halcyon1234 · 2009-05-09 Reply Admin

blunden:
arty the king:
Wi nøt trei a høliday in Sweden this yer? See the løveli lakes The wønderful telephøne system And mäni interesting furry animals
Too bad we don't use ø in the swedish language then...

Then how do you spell wøøsh?

2009-05-10 Reply Admin

Dr. Evil:
JdFalcon04:
bjolling:
Real-modo:
My parents had a problem with a spreadsheet my sister set up for them, and they asked me for help.
I _____________________ and now they ___________.
A møøse once bit my sister ... No realli!

Mind you, møøse bites kan be pretty nasti...

No realli! She was Karving her initials on the møøse with the sharpened end of an interspace tøøthbrush given her by Svenge - her brother-in-law - an Oslo dentist and star of many Norwegian møvies: "The Høt Hands of an Oslo Dentist", "Fillings of Passion", "The Huge Mølars of Horst Nordfink"...

Møøse trained to mix concrete and sign complicated insurance forms by: JURGEN WIGG

2009-05-10 Reply Admin

When I hear the word "Excel", I reach for my pistol

hatterson · 2009-05-10 Reply Admin

Married to an accountant:
Zapp Brannigan:
Most of the accountants I know can barely use SUM and COUNT. A few can use VLOOKUP if they have an example from from another spreadsheet and several hours to spare. A formula that complex had to be done by a college intern or an IT busybody. They will, however, do everything in a spreadsheet including database tables and word processing documents. A word to the newbies, don't spend more than 30 seconds formatting a report for accounting, they are only going to re-key it into Excel and reformat it themselves anyway.

Yeah. Sometimes, though, they have no choice but to (re-)key the data in. Take my wife's former employer (a taxi company). First she got all of the corporate vouchers, half filled in by taxi drivers (whose handwriting is worse than doctors, as far as I can tell). Then she had to cross-reference the trips in the dispatch system. Then, because the purveyors of said system had disabled copy/paste during one of their upgrades, she had to key all of that information into Quickbooks (or Excel, depending on which cantankerous client the bill was going to). Of course, then she had to staple them to sheets of paper and Xerox them because the people being billed would refuse to pay unless they saw a copy of the voucher (and sometimes refused anyway).

That's thousands of vouchers per month.

All with the worst handwriting you've ever seen.

Being paid to work hourly, but no overtime because the owner was morally opposed to spending money. 50-60 hours a week.

I actually wrote her a Perl program to reformat her 30k-50k line Excel spreadsheet and create the formulas. Saved her 8 hours a month. Owner never knew, and didn't care.

I'm glad she quit.

I fail to see the difference between "paid to work hourly, but no overtime" and "salary"

In one you get the same amount each week which is based on 40 hours times your base salary. In the other you get the same amount each week which was initially based on what would have been your hourly rate times 40. Unless you mean the owner promised overtime but then didn't pay it. In which case after about week 2 you either quit or sue.

Also, why the hell would the owner care that she's using a little perl program. Was he also opposed to a free way to do things faster?

hatterson · 2009-05-10 Reply Admin

MadtM:
Protector one:

Ok! Cool, thanks. Pretty sure Excel won't be used in 2100 anymore, though. (At least I hope so.)

saepius

I'll betcha $100 it's still in use in 2100. Consider: Kodak, made up name in use almost 100 years later. Ditto Rolex. This assumes we don't run out of power or off ouselves first.

I don't understand the comparison between Rolex, Kodak and Excel unless you mean the words themselves. In that case, I agree the word "Excel" will likely be around in 2100.

However given the exponential growth of computer it's almost unfathomable that Excel as we know it will be around in 90 years. Perhaps Microsoft (or whoever they've morphed into at that point) will still have a program called Excel, but I very much doubt that it will even remotely resemble our current Excel.

2009-05-10 Reply Admin

"N Morrison is a VBA programmer."

Wrong again. Algol 68. Has anyone seen my Burroughs B6700?

2009-05-10 Reply Admin

hatterson:
I don't understand the comparison between Rolex, Kodak and Excel unless you mean the words themselves. In that case, I agree the word "Excel" will likely be around in 2100.
However given the exponential growth of computer it's almost unfathomable that Excel as we know it will be around in 90 years. Perhaps Microsoft (or whoever they've morphed into at that point) will still have a program called Excel, but I very much doubt that it will even remotely resemble our current Excel.

Yeah, I was just thinking the words themselves. I read recently that Rolex, the name alone, is worth 3 billion dollars.

I see Excel as a software implementation of an accountant's tablet. Sure, there are a zillion bells and whistles, but what you see first is recognizable and usable rows and columns. Cuniform tablets, accountants pads, data tables: rows and columns. We won't cast off that metaphor anytime soon. When the power runs out we'll go back to the accountant's tablet and long for the days when we had Excel.

But cell Z24 is a travesty.

2009-05-10 Reply Admin

Was this software developed in India?

2009-05-10 Reply Admin

That sort of reminds me about how we don't know what the programming language scientists will be using in 2100 will look like, but we're pretty sure it will be called Fortran.

coyo · 2009-05-10 Reply Admin

Code Dependent:
My solution would be to say, "You need to roll 24Z back to its previous formula."

What they'll hear is "You have to flurb the wootle", and you damn well know that. That doesn't come close to solving their problem.

2009-05-10 Reply Admin

Renan_S2:
cod3_complete:

I've had people assume that just because I program computers that I also routinely assemble the cellphones that they use. Sigh

Same with me. Some people see me as "someone which knows all about electronics and computers", and if I tell them I don't know they usually come with excuses of the type "c'mon, don't be unhelpful". I so damn hate that.

To make it worse, I study electronics engineering. This makes people think I can repair pretty much anything which uses batteries or goes plugged into an outlet.

"c'mon, don't be unhelpful" is just a polite way to say "you suck as an electronics engineer." And they are damn right.

2009-05-10 Reply Admin

dpm:
Kermos:
The girl better have been drop dead gorgeous and at least performed sexual favours afterwards.
"At least"??? What more do you want, money and a parade? Hell, if she's drop-dead gorgeous and willing to perform sexual favours, I'd fix a sendmail.cf raw (without m4) and call it even.

Nope. Fixing sendmail.cf raw IS a sexual service in itself, like, ya know, with a bullwhip, leather outfits, a huge dildo rimmed up your anus and no freakin' lubricants. So what you basically ask for is a sexual services rendered twice, and that, my friend, is damn unfair.

2009-05-10 Reply Admin

AMerrickanGirl:
I've been using the Format Painter icon pretty much since I've been using Office.
It always amazed me that people use these products for years and never click on anything new. I see my coworkers struggling to build Word docs and spreadsheets, doing everything the long way, and when I try to show them a faster way, they always say, "Well, I need to take a class."

I didn't take a class. Clicking "Help" pretty much taught me everything I need to know about Word and Excel.

Congratulations, and thank-you for sharing.

2009-05-10 Reply Admin

BigG:
AMerrickanGirl:
I've been using the Format Painter icon pretty much since I've been using Office.
It always amazed me that people use these products for years and never click on anything new. I see my coworkers struggling to build Word docs and spreadsheets, doing everything the long way, and when I try to show them a faster way, they always say, "Well, I need to take a class."

I didn't take a class. Clicking "Help" pretty much taught me everything I need to know about Word and Excel.

Amen Sister (I'm assuming sister?)!!

Apparently we're the small mintority that can teach themselves. I'm usually getting yelled at for using styles and (gasp!) autonumber in Word. Heck, I learned a lot just by playing around, and if that didn't work I'd resort to "Help".

It's a tool, use it. Don't treat it like a neat typwriter for $Diety's Sake!

Oh My, Oh My....Two of you incredibly smart people that can work out how to use MS products.
The rest of us are positively green with envy

2009-05-10 Reply Admin

Renan_S2:
cod3_complete:

I've had people assume that just because I program computers that I also routinely assemble the cellphones that they use. Sigh

Same with me. Some people see me as "someone which knows all about electronics and computers", and if I tell them I don't know they usually come with excuses of the type "c'mon, don't be unhelpful". I so damn hate that.

To make it worse, I study electronics engineering. This makes people think I can repair pretty much anything which uses batteries or goes plugged into an outlet.

Can't you...???

2009-05-10 Reply Admin

Lumberjack:
“I did make a small change to 24Z a while back,” the accountant added, “but for the life of me, I can't figure out why it's not matching up billing terms.”

Ok, what I'm dying to know is what did she change and what was going on in her head at that very moment.

She was trying to access the FlightSim that appeared in some versions of Excel....I think she edited the wrong cell.

2009-05-10 Reply Admin

James M:
Welcome to investment banking, the entire system runs on Excel as a combination of VBA code and cell formulae, which goes some way to explaining the mess the industry is in! I see things like this every day.
Though surely it would be cell Z24, not 24Z?

I once had the gaul to suggest replacing a horrendously complicated spreadsheet with a real program. As the Financial Research assistance where constantly having trouble with it anyway. The response was. If you do so the software will become your sole responsibility and the research department will refuse to take any further care of it. Update the various parameter lists and weightings. My argument that I could furnish the system with very simple configuration files that where easy to update fell on death ears.

2009-05-10 Reply Admin

hatterson:
Married to an accountant:
Being paid to work hourly, but no overtime because the owner was morally opposed to spending money. 50-60 hours a week.
I fail to see the difference between "paid to work hourly, but no overtime" and "salary"

perhaps he meant she was paid time for her overtime, rather than time-and-a-half?

uxor==husband

2009-05-10 Reply Admin

Konrad:
I once had the gaul

and when they refused, you shrugged?

hatterson · 2009-05-10 Reply Admin

Anonymous Lexicographer:
hatterson:
Married to an accountant:
Being paid to work hourly, but no overtime because the owner was morally opposed to spending money. 50-60 hours a week.
I fail to see the difference between "paid to work hourly, but no overtime" and "salary"
perhaps he meant she was paid time for her overtime, rather than time-and-a-half?
uxor==husband

In which case you would be left with quit and/or sue/call the labor board. Over 40 hours a week is overtime as regulated by the FLSA unless you're a salary employee.

2009-05-10 Reply Admin

can't think of anything funny:
I'm just suprised no one has mentioned yet that you can double click on the little paint-brush to continue applying the same format until you click it again.
Saves so much time (and yes, I also use styles, and define my own, and use the Alt + Shift + left or right shortcuts to switch to header 1,2,3 etc (and up or down can re-order bullet points or word tables).

That may have sounded a little geeky

Awesome, didn't know that one. Thanks.

2009-05-11 Reply Admin

hatterson:
Anonymous Lexicographer:
hatterson:
Married to an accountant:
Being paid to work hourly, but no overtime because the owner was morally opposed to spending money. 50-60 hours a week.
I fail to see the difference between "paid to work hourly, but no overtime" and "salary"
perhaps he meant she was paid time for her overtime, rather than time-and-a-half?
uxor==husband
In which case you would be left with quit and/or sue/call the labor board. Over 40 hours a week is overtime as regulated by the FLSA unless you're a salary employee.

Correction: unless you're an exempt employee. You can be salaried/non-exempt. Exempt employees include managers and professionals like doctors and lawyers, but not staff programmers. If you're salaried, they still have to pay you overtime, they just have to do the math to figure out your hourly equivalent.

Zagyg · 2009-05-11 Reply Admin

Zapp Brannigan:
Most of the accountants I know can barely use SUM and COUNT. A few can use VLOOKUP if they have an example from from another spreadsheet and several hours to spare. A formula that complex had to be done by a college intern or an IT busybody. They will, however, do everything in a spreadsheet including database tables and word processing documents. A word to the newbies, don't spend more than 30 seconds formatting a report for accounting, they are only going to re-key it into Excel and reformat it themselves anyway.

How peculiar. In all the firms I worked for, most of the accountants know more about Excel (including formulea and VBA) than most of the IT department. I assumed this was fairly normal.

2009-05-11 Reply Admin

coyo:
Code Dependent:
My solution would be to say, "You need to roll 24Z back to its previous formula."

What they'll hear is "You have to flurb the wootle", and you damn well know that. That doesn't come close to solving their problem.

What? Not zoink the spiffler? You sure?

:-P

Erzengel · 2009-05-11 Reply Admin

David:
hatterson:
Anonymous Lexicographer:
hatterson:
Married to an accountant:
Being paid to work hourly, but no overtime because the owner was morally opposed to spending money. 50-60 hours a week.
I fail to see the difference between "paid to work hourly, but no overtime" and "salary"
perhaps he meant she was paid time for her overtime, rather than time-and-a-half?
uxor==husband
In which case you would be left with quit and/or sue/call the labor board. Over 40 hours a week is overtime as regulated by the FLSA unless you're a salary employee.
Correction: unless you're an exempt employee. You can be salaried/non-exempt. Exempt employees include managers and professionals like doctors and lawyers, but not staff programmers. If you're salaried, they still have to pay you overtime, they just have to do the math to figure out your hourly equivalent.

From FLSA:

Exempt professional job duties The job duties of the traditional "learned professions" are exempt. These include lawyers, doctors, dentists, teachers, architects, clergy. Also included are registered nurses (but not LPNs), accountants (but not bookkeepers), engineers (who have engineering degrees or the equivalent and perform work of the sort usually performed by licensed professional engineers), actuaries, scientists (but not technicians), pharmacists, and other employees who perform work requiring "advanced knowledge" similar to that historically associated with the traditional learned professions. Professionally exempt work means work which is predominantly intellectual, requires specialized education, and involves the exercise of discretion and judgment. Professionally exempt workers must have education beyond high school, and usually beyond college, in fields that are distinguished from (more "academic" than) the mechanical arts or skilled trades. Advanced degrees are the most common measure of this, but are not absolutely necessary if an employee has attained a similar level of advanced education through other means (and perform essentially the same kind of work as similar employees who do have advanced degrees).

So, if a degree means you're likely to be exempt, is that why HR always wants IT to have a degree?

It also specifically says Accountants are exempt from FLSA rights, as in they have no rights from the FLSA. What rights they have from other acts or statutes, I don't know.

I'd also like to add that it depends on the state as well. In California, the laws are much stricter on businesses: More than 8 hours in a day is overtime, more than 40 hours a week is overtime, more than 8 hours on your seventh day of the week is double time.

2009-05-11 Reply Admin

Zagyg:
Zapp Brannigan:
Most of the accountants I know can barely use SUM and COUNT. A few can use VLOOKUP if they have an example from from another spreadsheet and several hours to spare. A formula that complex had to be done by a college intern or an IT busybody. They will, however, do everything in a spreadsheet including database tables and word processing documents. A word to the newbies, don't spend more than 30 seconds formatting a report for accounting, they are only going to re-key it into Excel and reformat it themselves anyway.
How peculiar. In all the firms I worked for, most of the accountants know more about Excel (including formulea and VBA) than most of the IT department. I assumed this was fairly normal.

I reckon you were dealing with what most companies would call Analysts. We're the happy bunch of people who sit within Finance, but translate data into meaningful information (and occasionally vice versa). You get the Sales and Marketing people who need help converting data into helpful information for their account set, the Accountants who want a nice easy way to avoid re-doing all their calculations when the Cost Of Goods change, and you also have the IT people who are too remote from the business and need the business requirements explaining, like taking the main data warehouse down during the financial month end is not a good idea.

2009-05-11 Reply Admin

coyo:
Code Dependent:
My solution would be to say, "You need to roll 24Z back to its previous formula."

What they'll hear is "You have to flurb the wootle", and you damn well know that. That doesn't come close to solving their problem.

How do you do that? No kidding, I can't find the button!

2009-05-11 Reply Admin

Anonymous Coward:
ounos:
jonnyq:
You accidentally the whole point.
That was also what I.

Recursive humor is.

Is that you Yoda?

SenTree · 2009-05-11 Reply Admin

Michael:
BigG:
AMerrickanGirl:
I've been using the Format Painter icon pretty much since I've been using Office.
It always amazed me that people use these products for years and never click on anything new. I see my coworkers struggling to build Word docs and spreadsheets, doing everything the long way, and when I try to show them a faster way, they always say, "Well, I need to take a class."

I didn't take a class. Clicking "Help" pretty much taught me everything I need to know about Word and Excel.

Amen Sister (I'm assuming sister?)!!

Apparently we're the small mintority that can teach themselves. I'm usually getting yelled at for using styles and (gasp!) autonumber in Word. Heck, I learned a lot just by playing around, and if that didn't work I'd resort to "Help".

It's a tool, use it. Don't treat it like a neat typwriter for $Diety's Sake!
Oh My, Oh My....Two of you incredibly smart people that can work out how to use MS products.
The rest of us are positively green with envy

Shame one of them hasn't found the spellcheck yet ! [Prays fervently to Muphry before posting...]

2009-05-11 Reply Admin

In a previous life, I had to maintain a 1 megabyte Symphony spreadsheet (that was 20 years ago, so it required crying-edge 80386 computers with beaucoup ram) that had many such formulas.

To save time, I programmed a formula reformatter that nicely indented the parentheses.

operagost · 2009-05-11 Reply Admin

ubersoldat:
What's that you call Excel? Really, last time I used Excel was like ten years ago.

Congratulations; you are the computing equivalent of this guy.

2009-05-11 Reply Admin

pfftt! That formula's not so big. I used to maintain an application that calculated the performance of annuities. The calculations in the app had to match those in a spreadsheet for each annuity product (the duplication actually helped with verification). When the calcs didn't match, I would just take a very deep breath, get comfortable, and get mentally prepared for a very long session. I would end up tracing through dozens of cells each having formulas as long as that. If I suspected the problem was in the spreadsheet, I would have to explain the path through all the calcs back to the actuary.

AMerrickanGirl · 2009-05-11 Reply Admin

This actually reminds me of some Access queries that I had to maintain.

The purpose was to assign a score based on a range. Like if the percentage was 0 the score was 100; percentage between .01 and .05, the score was 90, etc.

The queries had a series of nested IIF statements which did this. It was bad enough that they were hard to figure out by looking at them, but each year the formulae would change so they'd have to be modified. And the database had multiple scores that had to be calculated.

I wrote a function in code instead and just passed the percentage to it. Incredibly easy to maintain. No one had done it that way before because they didn't know VBA.

2009-05-11 Reply Admin

N Morrison:
Buddy:
For ridiculous Excel formulas, I'd try to convince them to do it in steps, one per column, then hide the intermediate results.
Convert them to your own functions written in VBA. Much easier to debug and maintain, and often far simpler.

THIS!

2009-05-11 Reply Admin

Kermos:
Holy shit that's one horrid formula.
The girl better have been drop dead gorgeous and at least performed sexual favours afterwards.

In all likelihood, he got nothing out of it except for a few nice words. But you can bet that she'll be calling him up again every time her computer has a hiccup.

Note: debugging an Excel formula, even if it's a mile long, will NOT cause a woman to wet her panties.

2009-05-11 Reply Admin

bla:
Kermos:
Holy shit that's one horrid formula.
The girl better have been drop dead gorgeous and at least performed sexual favours afterwards.

In all likelihood, he got nothing out of it except for a few nice words. But you can bet that she'll be calling him up again every time her computer has a hiccup.

Note: debugging an Excel formula, even if it's a mile long, will NOT cause a woman to wet her panties.

You bastard! You shattered all hopes I had of reproducing.

2009-05-12 Reply Admin

Can't believe I took the time to format and actually understand that abomination of a "formula". Sad but true: large formulas in Excel have no way but to get ugly and confusing because you have no way to keep them understandable and structured.

=DATE(
  YEAR(H$1),
  MONTH(H$1) + CHOOSE(
    MATCH(
      F$1, 
      {"5Y","Y","H/Y","5M","4M","Q","Bi-M","M","4W","F","W","D","365D","90D","30D","12W","13P","26W","T"}, 
      0
    ),
    61,13,7,6,5,4,3,2,0,0,0,0,0,0,0,0,0,0,
    IF(
      H$1<=FLOOR
      (
        DATE
        (
          YEAR(H$1),
          5,
          DAY(MINUTE(YEAR(H$1)/38)/2+56)
        ),
        7
      )-34,
      8,
      13
    ) + 
    IF(
      MONTH(H$1)<8,
      0,
      MONTH(FLOOR(DATE(YEAR(H$1)+1,5,DAY(MINUTE(((H$1-1)/365.25+1900)/38)/2+56)),7)-37)-1
    ) - 
    MONTH(H$1)
  ),
  CHOOSE(
    MATCH(
      F$1,
      {"5Y","Y","H/Y","5M","4M","Q","Bi-M","M","4W","F","W","D","365D","90D","30D","12W","13P","26W","T"},
      0
    ),
    0,0,0,0,0,0,0,0,
    DAY(H$1)+(6-MOD(H$1,7))+28,
    DAY(H$1)+(6-MOD(H$1,7))+14,
    DAY(H$1)+(6-MOD(H$1,7))+7,
    DAY(H$1)+1,
    DAY(H$1)+365,
    DAY(H$1)+90,
    DAY(H$1)+30,
    DAY(H$1)+(6-MOD(H$1,7))+84,
    DAY(H$1)+(6-MOD(H$1,7))+364,
    DAY(H$1)-(6-MOD(H$1,7))+182,
    IF(
      MONTH(H$1)<8,
      0,
      DAY(FLOOR(DATE(YEAR(H$1)+1,5,DAY(MINUTE(((H$1-1)/365.25+1900)/38)/2+56)),7)-37)
    )
  )
)

2009-05-12 Reply Admin

Konrad:
My argument that I could furnish the system with very simple configuration files that where easy to update fell on death ears.

"Death ears"??

2009-05-12 Reply Admin

JustinCasey:
Auction_God:
Bonus points if you can identify the industy...

My guess would be an amusement park. With shoulder height, overall height, min/max weight, and capacity, it reads like a formula for how many passengers you can get into a rollercoaster. But there's enough other stuff in there to make me think this is a long shot.

do you really need a formula?

number of passengers = number of seats

;)

captcha: saepius = ewww

2009-05-15 Reply Admin

Why not ;-(

Cell 24Z

Leave a comment on “Cell 24Z”