[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/09\/make-me-ppe-3.webp” alt=”Untitled Group event” title_text=”make-me-ppe-3″ _builder_version=”4.18.1″ _module_preset=”default” width=”100%” max_width=”600px” max_height=”360px” hover_enabled=”0″ border_radii=”on|12px|12px|12px|12px” box_shadow_style=”preset1″ box_shadow_horizontal=”6px” box_shadow_vertical=”0px” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][\/et_pb_image][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Using Sheetgo, Make Me PPE now save around 780 hours every single year with a custom-made PPE manufacturing workflow to manage national PPE demands and analyze key insights. As a result, they now save over a week per month which they can now focus on producing more PPE.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
Finding a way to fulfil and forecast California’s PPE demands<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” hover_enabled=”0″ border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
- \n
- \n
Complex, immediate and sensitive information\u00a0<\/span><\/p>\n<\/li>\n
- <\/span>Struggle to centralize all data on PPE demand <\/span><\/li>\n
- <\/span>Needed a way to forecast demands to analyze trends<\/span><\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]From home hobbyists sewing pieces by hand, to high-tech fabrication labs using 3D printing, the Make Me PPE network includes groups producing PPE on vastly different scales. The team was struggling to manually manage all of their PPE requests from multiple sources, then finding a way to divide the requests for each group. 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 created data privacy challenges for the voluntary organization.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” hover_enabled=”0″ border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]\u201cWe had incredible difficulty organizing and personalizing views of our data until we found Sheetgo\u201d
\n<\/span><\/p>\nMake Me PPE
\n<\/em>[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]The team needed an automated system that would allow them to sort PPE demand data from multiple sources 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. Make Me PPE turned to Sheetgo for this solution, thanks to the great control over private data, as well as the ability to track and record historical data for forecasting.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\nAutomated management for optimized insights and analysis<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” hover_enabled=”0″ border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
- \n
- \n
Merge all sources to collaborate on centralized data\u00a0<\/span><\/p>\n<\/li>\n
- <\/span>\n
Append historical data to forecast PPE demands<\/span><\/p>\n<\/li>\n
- <\/span>\n
Automations to receive real-time updates across California<\/span><\/p>\n<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Sheetgo built Make Me PPE a unique automated workflow that carries out two main objectives; receive demand updates from various sources so that they can prepare for PPE manufacturing, and analyze and forecast demand by keeping track of previous demand. Firstly, all PPE requests by sources such as the CDC, FDA and the government were delivered using Google Forms. Sheetgo then used the Merge feature to consolidate these requests into a single sheet that the entire team could access. Using Sheetgo filters, the demands were divided for each group, as well as status updates on the progress of each request.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” hover_enabled=”0″ border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]“The separation of data by formatting has increased our productivity and ability to capture data greatly.\u201d
\n<\/span><\/p>\nMake Me PPE
\n<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Meanwhile, in the same system, Sheetgo’s append setting is used to record and track the historical data of previous PPE demand requests. Make Me PPE could then use this data to analyze and forecast trends for future demands. Finally, the team set up a custom automated schedule that would allow them to receive updates on a very frequent basis, to respond to PPE requests as close to real-time as possible.[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\nSaving 7 days a month to focus on saving lives<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” hover_enabled=”0″ border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
- \n
- \n
780 hours saved every year<\/span><\/p>\n<\/li>\n
- <\/span>100% control over private and sensitive data<\/span><\/li>\n
- Centralized data for ultimate accessibility<\/span>
<\/span><\/li>\n<\/ul>\n[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Thanks to Sheetgo, the Make Me PPE team now have a fully tailored, automated solution that allows them to effortlessly manage manufacturing demands, whilst simultaneously forecasting future demands to get a head start on producing PPE. As a result of this custom project, the team save over 7 days per month on manually inputting and managing data, which they used to focus instead on saving lives through the COVID-19 pandemic.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” hover_enabled=”0″ border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]\u201cSheetgo has saved us so much time and boosted our productivity. This program has literally helped us save lives!\u201d <\/span><\/p>\n
Make Me PPE
\n<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Make Me PPE no longer have to worry about wasting precious time manually organizing and delegating important PPE demands amongst their groups. Now, they have a completely self-sufficient system that does that for them, whilst maintaining a source of truth with a centralized spreadsheet. What’s more, the team have 100% control over their data to ensure total privacy. Finally, they now have a way to effectively forecast demands so that they are as productive as possible when it comes to protecting people across California.[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/01\/PPE-logo.webp” alt=”Untitled Group logo” title_text=”PPE logo” align=”center” _builder_version=”4.18.1″ _module_preset=”default” width=”200px” max_width=”200px” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Make Me PPE Bay Area is a grassroots community of sewing enthusiasts in San Francisco producing Personal Protective Equipment (PPE) to help tackle the COVID-19 crisis. The organization\u2019s 500 members have donated over 35,000 units of equipment to more than 150 facilities across California.
\n<\/span>[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_icon][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” hover_enabled=”0″ custom_css_main_element=”display: inline-block;” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]USA<\/span>[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_icon][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” width=”85%” hover_enabled=”0″ custom_css_main_element=”display: inline-block;” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]https:\/\/sites.google.com\/view\/makemeppebayarea\/home<\/span><\/a>[\/et_pb_text][et_pb_divider _builder_version=”4.16″ _module_preset=”default” custom_margin=”||20px||false|false” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_divider][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Industry<\/strong>
\nManufacturing<\/span>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Features used<\/strong><\/span><\/p>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-google-sheets.svg\")
Google Sheets<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/01\/google-forms.webp\")
Google Forms<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/07\/scalable-sheets-google-drive.svg\")
Google Drive<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-merge.svg\")
Merge<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-filter.webp\")
Filter<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/append.webp\")
Append setting<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/automatic-updates.png)
Automatic updates<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Make Me PPE: Automated PPE manufacturing management for essential COVID-19 demandsSheetgo is the no-code spreadsheet automation platform that turns the data your team already keeps in Sheets, Excel, and CSVs into pipelines, dashboards, and AI-ready datasets.Using Sheetgo, Make Me PPE now save around 780 hours every single year with a custom-made PPE manufacturing workflow to […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":6600,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"difl_page_category":[],"class_list":["post-28284","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/28284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=28284"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/28284\/revisions"}],"predecessor-version":[{"id":260757,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/28284\/revisions\/260757"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/6600"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=28284"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/difl_page_category?post=28284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- <\/span>100% control over private and sensitive data<\/span><\/li>\n
- <\/span>\n
- <\/span>Struggle to centralize all data on PPE demand <\/span><\/li>\n