I'm Using ChatGPT To Help Me Build A Very Complex Spreadsheet
Over the past two weeks, I got VERY into the VeeFriends Compete & Collect cards.
I have nearly 1,000 of the cards, most of which I owned before working at VeeFriends was even a thought.
We’re releasing a new game that I’m very excited about using these cards. At The National Card Show, I saw five year-olds play the game and understand it quickly. Later that same night, we hosted the inaugural Collector’s Cup tournament, where nearly 50 of the world’s most hardcore VeeFriends Compete & Collect collectors battled in a tournament with one winner coming out on top. The gameplay was so intense that it looked like The World Series of Poker.
I was blown away by seeing the diverse range of people that enjoyed playing. To me, the game feels promising, both as a holder of the cards and a member of the VeeFriends team.
Now that the rules have come out, I wanted to document the cards I owned and make a formula to create the most optimal deck to play in unofficial tournaments.
So, I made a spreadsheet that allows users to input all the cards they own. The sheet then auto-populates with the scores on the card and tallies how much of each of the 251 characters the person holds.
From there, the sheet enables users to select the 20 best cards in the category selected (Total Score, Aura, Skill, and Stamina).
The reason it selects 20 is because players battle using decks of 20 cards each.
The sheet still has a few bugs to sort out before it’s available for public use, but my progress so far is very satisfying.
I couldn’t have made it this far without the help of ChatGPT’s code interpreter. I asked ChatGPT to make a formula to help me.
The formula was imperfect, requiring about 9 rounds of feedback to get it to the place you see above. Even the formula above isn’t exactly what I’m looking for (hence why the sheet needs more work before I release it). My mid-level understanding of Google Docs formulas (and plenty of patience) allowed me to understand the data and give ChatGPT the feedback needed to get to the formula above.
Even without my understanding of Google Docs, it’s easy to ask chatGPT-specific questions like “Give me a very detailed explanation of what each part of the formula does so I can better understand any changes that need to be made.”
Asking ChatGPT to come to a better understanding of ANYTHING is my favorite way to use the tool. If you approach it with an open mind in asking, you’ll better understand what you’re interested in. The same goes for relationships in life, too.
Even though I’m not an expert in spreadsheets, making specific spreadsheets for solving an issue I have (such as how to tally all my VeeFriends cards to build the best deck possible) has opened doors in my personal and professional life.
For you, it doesn’t have to be spreadsheets.
I encourage you to sit back and think of a problem you have in your life. Solve it using your current skillset, and either give it away for free with your personal brand attached or sell it with your personal brand attached. The personal brand part is important because people should know who to talk to if they have questions or feedback, and that helps grow your network.
Solving your own problems and packaging them into a product is how most great business ventures start.
I’ll be working on this sheet over the next week or two and put it out for other VeeFriends Compete & Collect holders to enjoy :)
What a great way to combine your interests!