Excel Web Tools

Built during my volunteer tenure with the CNIB Phone-It-Forward program, I built this project with Python and Selenium to make shipping out phones faster.

the problem

After a phone was wiped by a volunteer, its information went on The Spreadsheet. When a phone was shipped out to a client, its information came from The Spreadsheet. Who has time to waste their day copy and pasting info from Excel and into the blasted shipping form?

the purpose

Each of the rows on the aformentioned Spreadsheet contained information about one phone. Depending on who donated it (corporation or just a regular person), we had up to 30 columns of for a single phone. But when shipping out a phone, you only need a couple pieces of information from those 30 columns, and having to side-scroll through the spreadsheet and search for it was quite time-consuming. Our team lead, who managed all the volunteers, was the person mainly responsible for this, and she is not the best with technology.

The company laptops are equipped with Excel, but because none of them have document sharing set up, the browser version of Excel is used instead.