Ryo Shimada and I brainstormed for months until coming up with the idea to use Google Sheets as a platform for Online Pegs & Jokers, as it provides seamless multi-user interaction, in-sheet programming through excel functions, and deep automation through the use of the Javascript API.

After many months of debugging, iterating, and user testing, working versions of the 4, 6 and 8 player variants of the game are functional and ready to play.

Challenges

Integrating excel functions with Javascript commands proved to be both a technical and communicative challenge as Ryo lead the excel efforts and I lead the Javascript efforts. In order to reduce latency, we decided to let google sheets do as many calculations as possible. 

This integration meant my automation code had to seamlessly interface with Ryo's outputs, the display interface, and the user input and output stream. In its current form, Pegs & Jokers runs reliably through 250+ turns at its peak of 8 players with minimal latency.

Preparing for a flight mission entails babysitting battery charging stations, examining flight hardware for flight-readiness, and performing repairs. Stuffing the tools required for these processes into one backpack either gets messy or expensive. This project solves these requirements with a low-cost backpack-shell and custom 3D Printed hardware.

Challenges

A durable, quick release phone mount  that attaches to bicycle handle bars with limited hardware.

The assembly consists of custom a TPU bracket with a Quad Lock insert profile and a custom PLA locking bracket to keep the phone securely attached.

Challenges