Make Me PPE Bay Area

“We had incredible difficulty organizing and personalizing views of our data until we found Sheetgo”

Make Me PPE Bay Area is a grassroots community of sewing enthusiasts in San Francisco producing Personal Protective Equipment (PPE) including masks, gowns, scrub caps, and face shields to help tackle the COVID-19 crisis. To date, the voluntary organization’s 500 members have donated over 35,000 units of equipment (including 27,000 masks) to more than 150 facilities across California. In recognition of their work, the team was invited to speak to members of Congress at the Capitol Hill Maker Faire.

30

Spreadsheets

780

Hours saved every year

Industry

Manufacturing

Country

United States

Challenge

From home hobbyists sewing pieces by hand to high-tech fabrication labs using 3D printing, the network includes groups producing PPE on vastly different scales. The challenge was to provide all parties with an organized, individualized view of PPE demand while maintaining a central database of past and present demand to track and analyze trends.

The unique circumstances of the pandemic also posed data privacy challenges. The Make Me PPE team needed to be able to sort data by product and team, control who could access sensitive information (such as delivery address and contact details), and provide multiple data views for the different groups of makers.

Sheetgo has saved us so much time and boosted our productivity. This program has literally helped us save lives!”

Solution

The team used Sheetgo to streamline data privacy, viewership, organization, and communication while continuing to work from a single collaborative set of data. Sheetgo connections provide a custom view of applicable data for each party while automating data updates on current PPE demand. “With the constant updates from the CDC, FDA, and local government regarding the safe use of PPE, our use of Sheetgo has proven to be a critical timesaver during a global pandemic. Sheetgo has helped us move with agility to protect as many folks in need as possible”, explains founder Ashley Chiu.

The separation of data by formatting has increased our productivity and ability to capture data greatly.”

How the PPE management system works

PPE requests flow into the master sheet from Google Forms. The master sheet sorts data into individual views for the makers. As a result, production teams can quickly see which equipment is needed.

Sheetgo’s filter by color feature helps sort data in the master sheet. Requests marked yellow are incomplete and therefore appear on the list of PPE currently required.

Using Sheetgo and Google Sheets functions, the team can track how many PPE items have been donated to closed requests, as well as currently open requests that have been only partially filled.