Welcome to my programming journey, where I navigate the thrilling and occasionally treacherous world of code with equal parts determination and a healthy dose humility!
It all started innocently enough with my love affair with Microsoft Excel. Oh, the hours I spent marveling at spreadsheets and organizing data with the precision of a master conductor. Little did I know that my journey towards programming had already begun, right under my nose, while I blissfully calculated formulas and sorted columns.
As my Excel prowess grew, I couldn't help but feel a nagging curiosity. "What lies beyond the borders of these cells?" I wondered. And so, I bravely embarked on a quest to conquer the vast realm of web development. HTML became my passport to the digital kingdom, where I discovered the power of structuring content and unleashing my creativity on the canvas of the World Wide Web. I mean, who knew that I could make words dance with a few well-placed tags?
But my programming adventure didn't stop there. Oh no! It was time to kick things up a notch, and I found myself deep-diving into the mysterious world of Excel VBA. Suddenly, Excel transformed from a simple spreadsheet software to a magical realm of automation and efficiency. I felt like a wizard, conjuring macros and writing code to make Excel bend to my every whim. It was like having a personal assistant who spoke the language of spreadsheets, minus the coffee runs.
And then came R and Rstudio. Ah, R, the language of data enthusiasts and statistical wizards. It was like stepping into a secret society where the secrets of data analysis and visualization were whispered only to those deemed worthy. Armed with my ignorance of the step learning curve, I delved into the depths of datasets, extracting insights and weaving stories with numbers. It was like being a detective, but instead of a magnifying glass, I had a trusty keyboard and an energy drink (or something stronger depending on the time of day) to solve the mysteries of the data universe.
I felt I was on top of my coding game, but how is it that the more you get into a subject the more you discover you don't know? Now I need to learn a little Python for this, a little SQL for that, and not to mention the JAVA and CSS (don't get me started). My path forward looks treacherous but rewarding!
As I reflect upon the path I have traveled, I am grateful for the diverse set of programming languages and tools I have encountered thus far. Each step along the way has contributed to my growth as a programmer and opened doors to exciting opportunities...and several frustrating hours of lost sleep. But here I am, ready to share my tales of headaches, heart breaks, and occasional successes, as I continue to unravel the mysteries of programming languages.
Rshiny:
With the increased need to create products for users, I have expanded my Rshiny practices. I have mostly used R/Rstudio for automated data cleaning, advanced statistics, and some other one off big data tasks. However, with the increasing demand of tool creation for users/clients. I have found Rshiny to hit the spot since it allows for web apps or standalone apps. Check out one of my personal projects that I can share:
https://keith-b-painter.shinyapps.io/Timeline_generator/
I included a short video demo as well!
More projects to come!
Data compilation & storage:
This video is a demonstration of only one of the many custom Excel VBA projects I decided to undertake to improve the data collection protocols in the sport science lab.
To sum it up, we had .csv files for isometric mid-thigh pulls, static jumps, and countermovement jumps that had to be manually reviewed and compiled into a report that was then used to assess the data. I used the same basic template ("STATISTICS" tab) but automated the process to not only decrease data return time, but also compile a MASTER file to save all this work in one place!
NOTE: The video does not have sound.
Force-Time curve analysis:
This video depicts a program I wrote to analyze force-time curves of countermovement jumps from home using the previously collected raw voltage data. On top of the COVID limitations on working in the lab, the programs we used did not satisfy everything I was looking to analyze. This demo is a simplified version of what I ended with, but if you are familiar with jumps on force plates then you may be familiar with the variables I was looking to get. This program alone cut my data analysis time in half, if not more!
NOTE: The video does not have sound.