How To Be Poor - Advertise on this site
How To Be Poor Title Image

Contact me: [max] [at] [howtobepoor.com]

February 23, 2007

Evolution of a Corporate App

Filed under News — How To Be Poor @ 7:23 pm

In the beginning, there was a weekly email to 4-7 people (and one guy in BCC field) with some sales figures – Johnson sold this many of Product X, Williams sold this many of Product Y, and Stefanopulo sold none and perhaps got canned.

Then, somebody decided it would be cool to not copy and paste those lines into an email all the time, so that’s how Monthly Sales.xls was born.

001.jpg

Then – a breakthrough! Each day of sales can be tracked on a separate worksheet!

002.jpg

Wow! We can now fit like an entire month into this file! When a month is over, we’ll just make a new workbook! And to be completely awesome, we’re gonna NOT follow a naming nomenclature and keep random crap in the folder!

This is a sample Sales Tracking System:

003.jpg

On one bright sunny day at the end of a fiscal quarter, management decides they want to know who sold what, for how much, and so some charting. Manual copy-paste hell ensues. People are working till AT LEAST Saturday, conglomerating hundreds of malformed Excel files into one big master Excel file.

The efforts are gargantuan as there are no templates of ay kind, and data in each sheet looks slightly different. There’s Johhny, sipping on his Coke, methodically copying and pasting values from cells in a horizontal row into a vertical column. He will waste his company countless hours of labor because neither his superior nor Johnny are aware that a simple Copy – Paste Special – Tranpose would automatically convert anything horizontal into a vertical range, and vice versa.

There’s Jennifer – while biting her lower lip, she’s trying to set up permissions for the folder so that other people can access the file, but the concepts of a “Network Share” escape her.

When the master file is done, it will look tweaky, but presentable. “Whew“, everyone will say, and nervously laugh.

Some time after this little fire drill, Stefanopulo will decide that he’s more less an expert in “data”, so he will do the unthinkable.

He will design an Access database.

On some slow Thursday morning, he will “create a new database“, and doom his teammates to corporate hell. By designing a crooked, completely unvalidated BLUE form connected to a query created on a table with lookups, he will trick the co-workers into using this abomination for a week or two.

After that, it will be too late.

As the word gets around that the Sales and Quality department has an “app”, more and more people start using it. The *.ldb file is now always next to the *.mdb file, and those two evil creations are silently waiting for their next prey.
The MS Jet Engine 4.0 is creaking, but working. As user number 40 gets into the database, it squeeks, and dies. By that time, there are at least 50 queries on top of queries, 30 tables linked together on MEMO fields, 20 forms and subforms, and 40 reports in blue italic font.

Stefanopulo is now on duty to “compact and repair” every Saturday morning. While he’s waiting for the backend to finish “repairing”, he quickly writes a subroutine and a query to “validate” the dates users enter. The sadistic AUDIT TABLE is born. It corrects all user entries where CLOSE dates are BEFORE the OPEN dates … on the backend.

As users enter more and more invalid dates, the audit system grows more complex, though reports are still shady because Stefanopulo doesn’t know the culprits of a LEFT JOIN.

Finally, the Access app grows so large that users (now completely hooked) start complaining DAILY. A PROGRAMMER is commissioned. He will fix EVERYTHING! He will move everything to a SEQUEL SERVER! O-O-O-O-O-O!

Four months later…

The programmer is still tweaking the Access app. The data structure is now so inefficient and crazy, that he buidls another app just to migrate the data from the old app to the new backend … but he missed a few things, and the tool does not port properly.

Five months later…

A buggy See Sharp app is born. It pukes up the yellow stack every time you click a button.

But it’s fast …. er. That’s all that matters.

• • •
 

February 11, 2007

Splitting Meals

Filed under News — How To Be Poor @ 7:47 am

Eating out in restaurants is normally done infrequently and is treated like a “special occassion” by most people.  The bill + tip for two may start at $20 and depend on other factors, such as the fanciness of the place and manu items.  However, in my experience, it’s not uncommon to get out of a restaurant $40-50 lighter, after an appetizer, a couple of entrees, and some drinks.

At the same time, if are not having your meals prepared and served to you, then you must be doing the preparing and serving youself.  Since I believe that hitting all food groups is a must, I like all food.  I can eat fish, meat, poultry, vegetables, fruit, it really does not matter to me as long as it’s decently prepared.  Hell, in college I ate nothing but Ramen and multi-vitamins, and chased that with Old Crow.

I imagine, the grocery bills vary greatly for all people, and since we don’t buy a lot of pop, chips, or deep-fried foods, ours consists mostly of meat, veg, and booze (I’ve developed a taste for sake and riesling).  Thus, the grocery bill hovered around $100 a week for the two of us; probably $350-400 a month.

Then the time crunch at work came, and I had less and less time to do anything, let alone cook.  So we started going out more.  Waste of money, you say?

A big-assed steak wrap at Chipotle or Freebird’s is like eight bucks.  Get a couple waters, and call that a decently healthy meal for two.  You get your fat from steak, vitamins from vegetables, carbs from the tortilla and rice, and protein from beans, all in one meal.  Do that twice a day, and you’re out $16-20.  Eating during the work week now realistically costs you a hundred bucks.  Get a carton of eggs, some milk and bread ($8-10), and you’ll have breakfasts for the first, and most important, meal, probably for the entire week.  Your entire eating out experience still costs you around a hundred, give or take ten bucks.  If you once in a while buy a little groceries for the weekend, you can squeeze into the same $400-450 a month.

However, in our case there’s a few other associated benefits to eating out – a dozen good places to eat within a walking distance from home.  Every time we go out, we walk at least a mile, most of the time a couple, which can be counted as exercise.  Also, we don’t dirty as many dishes, which cuts on damned Brawny and soap.

In the long run, eating out is still more expensive, especially you’re a miser, there’s no arguing that.  However, in my experience, it’s not all that bad for your budget, either.  The key is sensibility.  We’re fortunate to live in a country where portion sizes keep growing, and it’s pretty much mandatory to walk out of a restaurant with a “doggie bag“.  \

If you take full advantage of huge portions, the financial side of eating out may surprise you.

• • •
 
real unique people checked out this site and agreed with every word I wrote. Powered by WordPress 3.3.1. Supported by CD Rates.