Projects

Results coming soon.. Check back in May!

I finished in the top 2% of Kaggle’s 2022 March Machine Learning Mania competition and here is how I did it using Excel’s Solver add-in.

This project was a school project to provide managers of a baseball team non-obvious valuable statistical insight. This project was completed using R, SQL, and Excel.

This project was a data visualization school project to create a tableau dashboard using the IPEDS 2013 dataset. The three criteria to focus on were story telling and insights, design, and overall appeal. This project was completed using Tableau and published to Tableau Public.

This project was a school project to model forecast quarterly aircraft deliveries using time series analysis. This project was completed using R.

This project was a BI report developed to visually display the daily goals and measure progress of each department and work center within manufacturing throughout the work day. This BI report quickly became the most accessed BI Report at Piper Aircraft each day. This project was developed using Cyberscience’s ECQ BI reporting software.

“Takt time is the rate at which you need to complete a product to meet customer demand.”

This project was a work project to develop and provide a list of repeating integers that when repeated would provide the number of days required between product deliveries to meet a production schedule within the available working days. This project was completed using VBA in Excel.

This is a VBA script that creates a custom excel function that converts a text string stored in hexadecimal into a human read-able string in Excel. Simply type: =HexToText(A2)

This project was a work project to simulate annual financial impacts to pay adjustments. Current employee data (name, pay, job title, labor grade) can be inputted into the simulator and management can interactively make pay adjustments and see how these changes would impact budgets annually. Adjustments could be made by department, job title, pay grade, etc. The tool also allowed for data cleanup of job title spelling and convention errors prior to use. This project was developed using VBA in Excel.

This project was a work project to convert a daily work-to-do list csv file from Infor’s LN 10.5 ERP system into multiple formatted csv files that can be imported to and read by Amada’s APS100 nesting software to improve the efficiency of programming flat pattern sheet metal nests for Amada Lasers. This project saved the programmers about an hour per day of setup so they can begin their day programming nests. This project was completed using VBA in Excel.

This project was a work project to summarize turnstile transactions for an employee and summarized first and last badge scan of each day using the data provided. It also calculated maximum on-site duration. This project was completed using VBA in Excel.