Ericsson update

Right now I'm working at Ericsson, and it's boring. With regards to some positives, it's a good place to work, I get my own office (aka meeting room), flexible hours (maybe cos I'm freelance), few people to deal with, but damn it's boring. Not to mention I'm working with radio engineers who seem to be more concerned with saving their asses and not much sense.

Question : Why is this macro so slow?
Answer : The file's hundreds of megabytes. VBA is not meant to process files that big. In fact VBA's not even meant for processing files at all. It's interpreted for goodness sakes! It's slower than VB.

The macro's already optimised, there's no screen output at all. They're running a macro that processes a file that can range from hundreds of megabytes to gigabytes. Run that in VBA and it's going to be ridiculously slow no matter what CPU you're using. They're talking about "optimising" the algorithm, when there's nothing to be optimised, and not that I know of. It's just that VBA is just S-L-O-W. Can you imagine writing a macro to process a file that big in VBA? Not to mention deal with other constraints like 65,000 line limits, constant changing of minds (this will be the LAST graph.. (next day)... can we add another graph? Can we change this graph?).. if it's anything I learnt it's that these people cannot make up their minds and have no planning whatsoever even though they are already behind schedule) I've had to rely on all kinds of tricks to deal with the line limits, splitting up data files into multiple sheets, storing the names of these sheets and then writing functions to generate graphs and statistics from these multiple sheets. It's enough to give anyone a headache.

What on Earth are the people at Ericsson doing?? Their plans are non existent, they don't know what they want (nor their clients I might add!!) and they don't even know the contents of their own data logs. It's shocking.

The plus side is this month in renumeration alone I'm getting the most I've made out of any other month ... ever. Which is common sense of course, multiple jobs = multiple sources of income. Therefore this makes it pretty good but working for other people truly suck. In fact I wonder if it's seriously worth the amount of money.

They still have yet to pay me, but I should get paid by the end of the week at least.