Haha! As a temp girl from hell, we are not supposed to participate in meeting but just to sit their like a piece of dried timber. But I couldn’t resist. I had to mention that I’ve created MACROS in a spreadsheet template originally created by one of the `business planners`. So I spoke up and waved my one-paged `process` on how to make my MACROS work. The manager said he’d take a look to see if it is good for the team. I say it’s mine. I own that process. But I won’t stick my name into the auditors check off list if I get hired full time.
It involves three spreadsheets: one for the raw data, one for the holds and one for the working file. Without the first two files, the working file is VERY tedious. The raw data keeps pulling new orders with holds. And we are not supposed to schedule new orders with holds in them.
So in order to reduce the time of looking up each order and line items, I had to find a way to MERGE both the raw data and holds into the working file. Voila! This damn savior has done wonders in just this one week. All it took was patience, logical thinking, back engineering and cross training with the Microsoft Excel help online.
Ah! But besides the macros, I had to employ more Excel functions, such as VLOOKUP. That function is great. I still cannot get the logical tests the way I want it. I’ve seen my government-trained mentor from Taiwan type out strings of these formulas into her spreadsheet. So my knowledge base is my no means comparable to those people whom we three temps are supporting. Trust it: It’s not hard work. But it’s work that needs to get done. And that’s why I’m sitting near the back door.
Leave a Reply