Problem Solving At Work
Nov. 4th, 2009 01:17 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
aoinoueYou 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.
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.
