I hacked Excel

And it was incredibly easy. Some background: I received a Microsoft Excel spreadsheet (xlsx file) from someone at my company that was struggling with incorrect numbers. The spreadsheet was password-protected. I noticed one of the formulas wasn’t calculating correctly and giving a percentage of a score that they had a 0%, which was incorrect. This was something they had to complete quarterly, and each tab represented a different quarter. I noticed that on the tabs for the first two quarters, the formula for calculating the percentage was completely different than the last two quarters. I thought that if I updated the formulas to correctly calculate their score, then everything would work fine. Unfortunately, the formulas were password-protected.

Continue reading “I hacked Excel”

I wrote a letter to my 30-year-old self when I was 25

I don’t remember what sparked the idea, but I thought it would be interesting to write a letter to my future self in five years when I was 25 years old. It’s interesting to think about what my priorities were then, and how it’s shifted to now. I’m halfway on to my next mark five year mark, but I thought I’d share the questions with answers (as of 2015). The original copy is at the bottom.

Continue reading “I wrote a letter to my 30-year-old self when I was 25”

How I Wrote a C# Terrain Map Generator

Last week while I was taking the dog for a walk, an idea came to mind: What if I built a town simulation that told stories about people who lived there? Upon thinking this, I was curious if I could somehow build a random map that these people, or “sims” since I grew up in the golden years of SimCity and other sim games, would tell the user stories as they interacted with the world.

Continue reading “How I Wrote a C# Terrain Map Generator”

Let’s Talk: The Equifax Hack

I want to talk about the Equifax hack. It’s extremely important because if you’re an American, then there’s more than a 50% chance you’re affected and everything about you is at risk: Your full name, your date of birth, your social security number, your address, and more. This article will dive into more details about what it is, how it happened, and what you can do.

Continue reading “Let’s Talk: The Equifax Hack”

Blight

We all knew this was coming. Scientists had been warning us for decades, but many people were blaming the hippies, the democrats, or China. Others thought that perhaps it was natral phenomenon. Those who listened pretended to care, but never did anything about it. It required people to drastically change their lifestyles, but it was too inconvenient.
Continue reading “Blight”

AutoApply

Filling out job applications can be very time-consuming. Unfortunately, I was laid off about a month ago. Since I’m unemployed and I want to be more efficient, I started building a program that will automatically fill out a majority of the forms for me automatically. So far, I have a settings menu where you can fill in our job experience, cover letter, references, and your personal information (address, name, chosen password, username, etc.)

The video below displays an early prototype of what I’m building.

The technology used is C# and I imported Google Chrome, which is very useful for calling javascript commands. I’m not entirely sure what I’m going to do with it, but I’m still building out all the AI algorithms for different application websites. If you want further information, use the Contact section above.

Microsoft Office 2016 and Activation

I recently purchased a dozen desktops for the office and was tasked with setting them up and installing Microsoft Office 2016. I purchased the Dell Precision towers with Microsoft Office Home and Business 2016 pre-installed on each one. One thing that I did not account for was that Microsoft changed their activation method and now tie each product license to an e-mail address. No problem, right? Except that the activation did not work on each computer. Then another problem occurred: After four installations, there were four different licenses attached to one e-mail account and it was difficult to tell which installation key was tied to which computer. The obvious solution is to use Office 365 and then all of these problems will go away. However, my CEO refuses to buy it. Here’s how I resolved the issue:

Continue reading “Microsoft Office 2016 and Activation”

Creating SSL Certification

This guide will walk through setting up an SSL certification and installing it on your server. I used these steps in the past for Jira and Confluence, but there are many uses for this. SSL (Secure Sockets Layer) is the standard security technology for establishing an encrypted link between a web server and a browser. According to Digicert, “SSL allows sensitive information such as credit card numbers, social security numbers, and login credentials to be transmitted securely. Normally, data sent between browsers and web servers is sent in plain text—leaving you vulnerable to eavesdropping. If an attacker is able to intercept all data being sent between a browser and a web server they can see and use that information.”

Continue reading “Creating SSL Certification”

How to: Land a Job

I’ve been interviewing for a position at my company for a few weeks now and I can’t help but notice how frequently some (what I would assume) basic concepts of getting a job are completely ignored. I was recently browsing social media when I came across someone complaining about the difficulty of finding a job. Their gripe with the process was someone telling them to try harder. The person argued, “How do I try harder? Do I type my resume harder? Do I hit submit harder? etc.” It made me chuckle. This sparked a response where I decided to write a quick guide on landing a job. Let’s start with the resume:

Continue reading “How to: Land a Job”