This site under reconstruction.
“No, they hand key that in”…. “No, that is manually input.” “No, that’s also keyed in.” I was going over the result of the testing with my boss and as I went through each section, she kept asking how the field folks pull in the data. Each time I had to say that it was…
“One, two, three, four, five, …, eleven, twelve. Twelve characters.” “So why does Excel len() function gives me 13?” “Maybe there’s a blank character at the front. Let’s try =left(cell, 1)…Hmmm, R.” “Maybe it’s at the end. Try =right(cell, 1)…An e, nope.” Normally, if you are working with a download from SAP, you will be dealing…
There’s a lot of bad actors in this world. They range from the infantile teenagers to the truly malicious. The latest set of news are about the massive breach at JPMorgan, which, being a financial firm, would have one of the strongest set of security plans in place and yet, they’ve been hacked. This means just about everybody is…
You know how programming logic can get gnarly? That happens when you need to make adjustments or additions to the program. Or you have a decision tree that is based upon time. I’ currently trying to write a program to save “beginning of the month” data to use for comparison purposes throughout the month without blowing…
And so the drumbeat of articles continue. There has been a couple of interesting articles but I’m going to focus on the one about the psychological research on people’s viewpoint on CEO pay. This article came from HBR.org, through Pulse/LinkedIn, titled “CEOs Get Paid Too Much, According to Pretty Much Everyone in the World”, dated…
Lately, I have been working on this report/dashboard for 2 audiences: the operations manager and the field guys. In developing this tool, I’ve had to incorporate my own tricks. One, I just recently learned how to make Excel automatically start running a macro when you open up the file. To write the macro, it requires…
You must be logged in to post a comment.