I’ve been writing automated regression tests at work over the past month, using Jest and Selenium WebDriver, and have really been struggling to get my tests to pass consistently. I began to suspect that methods like
This one was a bit confusing. The wording of the problem is, “Work out the first ten digits of the sum of the following one-hundred 50-digit numbers.” I assumed that they wanted the ones place through the billionths place, but they wanted the first ten digits starting from the left side of the number. Continue reading
I just finished this one. My code is incredibly huge, over 100 lines. I’ve seen a few solutions that were far shorter than mine, but I found the answer. It took me a half hour to realize this, but for those who are trying to solve this and are stuck, don’t forget to check the correct diagonal directions. I was checking diagonally down from left to right, and then checking diagonally up from right to left, which is the exact same thing. That produced the exact same results, so I had to change one of those checks.
Here are a couple other hints, that most of you probably understood right away: Continue reading
Project Euler is great. The first problems are much easier to solve than any other programming-oriented problem-solving website I’ve yet to come across, but there are plenty of problems available (400+ as of this writing), and the difficulty does increase. Continue reading
I’m working with an old spreadsheet that has nearly 1500 rows of data. This spreadsheet has been in existence since late 2009 and has been maintained by several different people, with no one providing Excel-minded, future-proofing leadership to unify what they were maintaining and how they were maintaining it. As such, the data is incomplete and dirty. Here’s how I fixed over 300 empty cells with estimated expiration dates within a few minutes (it can be done much quicker if you know exactly what you’re doing). Continue reading