aoinoue: (Rachel Maddow - WTF)
[personal profile] aoinoue
You are sent two spreadsheets. Spreadsheet #1 is a finished version of last month's report - it is basically just a bunch of columns with data items in it. Three columns are calculations of # of days, months, years since a date in one column. Two more columns are if/then statements based off of the calculations in the previous three columns.

Spreadsheet #2 is simply a copy of Spreadsheet #1 only with the calculations and if/then statements missing. All other data items are present.

You are now asked to make Spreadsheet #2 look like Spreadsheet #1.

What would you do?

If you answered, "Send both files over to one of the Business Analysts because I don't understand Excel and it scares me," congratulations, you did what my co-worker did.

Why "copy the formulas for the five columns in spreadsheet #1 that are currently blank in spreadsheet #2" did not occur to her, I do not know. Argh.

Date: 2009-11-04 08:13 pm (UTC)
From: [personal profile] anthogna
EEEEEEEEEEEEEEEEEEEEEEEEEEE!

EXCEL!

RUN FOR THE HILLS!

Date: 2009-11-05 12:44 am (UTC)
From: [identity profile] darthsnugglebun.livejournal.com
I sadly encounter stuff like that all the time - in teaching graduate-level statistics. Roll that one around in your head for a minute. "It's dark in here, and we may die."

Profile

aoinoue: (Default)
Aoi

February 2011

S M T W T F S
  12345
6789101112
13141516171819
2021222324 2526
2728     

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 19th, 2017 06:42 pm
Powered by Dreamwidth Studios