Okay, so today I tried to do something I thought would be simple – make a digital version of Rory McIlroy’s scorecard. Turns out, it was a little more tricky than I expected, but still fun!
First, I opened up a blank spreadsheet. I figured that would be the easiest way to organize all the holes and scores. You know, make it look like a real scorecard.
Getting the Basics Down
I started typing in the hole numbers, 1 through 18, in the first column. Then, across the top, I added columns for things like “Par,” “Yardage,” and “Score.” Pretty basic stuff, really.
- Column 1: Hole Number (1-18)
- Top Row: Par, Yardage, Score, maybe some extra notes
Next, I went online and found a website that showed the course information, the par for each hole, and how long each hole was. I just copied that information and pasted it into my spreadsheet. Felt like a bit of a cheat, but hey, it saved me some time!
Adding the Scores (The Tricky Part)
This is where it got a little interesting. I wanted to be able to just type in Rory’s score for each hole, and have the spreadsheet automatically calculate his total score, and maybe even show how much he was over or under par.
I messed around with some simple formulas. For the total score, I just used a “SUM” function to add up all the scores in the “Score” column. That was easy enough.
Figuring out the over/under par thing was a bit tougher. I ended up using an “IF” statement (I think that’s what it’s called). Basically, I told the spreadsheet: “If Rory’s score on this hole is less than the par, then subtract the par from his score. If it’s more than the par, then subtract the par from his score. If equal, then put a zero.” It works! Kinda proud of that one.
Making it Look Nice
After I got all the numbers working, I spent some time making it look presentable. I changed the font, added some colors, and made the column widths a bit wider so everything fit nicely. It’s not exactly professional-looking, but it’s definitely readable.
I added bold to Par, Yardage, Score, and hole numbers. It looks more clear!
Overall, it was a fun little project. It’s not perfect, but it does what I wanted it to do – keeps track of Rory’s (or anyone’s) golf scores in a simple, organized way. Maybe next time I’ll try adding some more fancy features, like graphs or charts. We’ll see!
