Fulfilling critical COVID-19 demands via spreadsheets<\/h2>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]\n- High-demand PPE requests for staff in 30+ locations<\/li>\n
- Complex inventory with over 40,000 items<\/li>\n
- Hard to track multiple vendors and fluctuating prices<\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]
With the outbreak of the COVID-19 pandemic, HMG faced the challenge of acquiring and distributing personal protective equipment to care staff, as quickly as possible. Global demand made this task more complicated, as HMG had to buy these products from multiple vendors at fluctuating prices. At that time, they were using Excel spreadsheets and manually managing procurement and inventory, which was becoming an extremely time-consuming process.<\/p>\n
The new demands imposed by the pandemic made this system unsustainable, and HMG desperately needed an alternative solution.<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]“Covid-19 challenged us with immediate and significant demands. We were previously spending around 20 hours a week preparing and managing inventory data in spreadsheets.”<\/span>\n\nRick Cochran, VP, Business Intelligence, HMG Healthcare<\/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=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]HMG reached out to us because they needed a dynamic inventory list to manage the acquisition and distribution of over 40,000 items to 30 different locations, taking into account fluctuations in price for different vendors. \n\nThey wanted an automated process that would speed up the supply chain and get the PPE sent out to care staff as quickly and directly as possible.[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]Flexible and dynamic inventory control using Sheetgo<\/h2>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]\n- Custom-built inventory management solution<\/li>\n
- Two-way sync data transfer to speed up supply chain<\/li>\n
- Automatic updates for the latest inventory insights<\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]
With Sheetgo, HMG has created a custom, automated inventory workflow based on Google Sheets. Now their data is clearly divided into two spreadsheets; one containing order requests, and another containing the purchases.<\/p>\n
With a two-way sync from their ‘Main Inventory’ master sheet, Sheetgo automatically determines whether an order can be placed based on PPE availability. If so, the request is approved, and this order is sent directly to the ‘Purchases’ file. With this synchronisation, the team always have the latest updates, including PPE order confirmation and delivery status.<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cIt gives me, and the directors, the ability to control the flow of information and who\u2019s able to view what. The workflow is really helpful in ensuring we get autonomy and accountability from each department, but we also get accurate information in real-time.\u201d<\/span>\n\nRick Cochran, VP, Business Intelligence, HMG Healthcare<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]In the Main Inventory master sheet, HMG have an overall view of the operation, including key metrics such as items per facility, transactions per item, and deliveries pending. To ensure data consistency, a validation on the master sheet is distributed to Requests and Purchases, syncing data in all spreadsheets so everyone has accurate information at all times. \n\nNow, if an item is missing at a facility, staff can allocate supplies in one click. Additionally, items can now be sent directly from vendor to facility, which speeds up the supply chain.[\/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=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]Saving 20+ hours per week with a self-sufficient system<\/h2>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]\n- 1120 hours saved every year<\/li>\n
- 20+ hours saved every week<\/li>\n
- 100% up-to-date inventory metrics<\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]This dynamic inventory workflow has not only saved HMG around 3 working days per week, but they now have a self-sufficient system that can withstand any last minute emergencies or keep up with a sudden surge in demands. \n\nWhat’s more, Sheetgo has provided a fully scalable, flexible system that gives HMG full control over dynamic inventory data, with connections and validation that keeps their inventory accurate and up-to-date.[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cSheetgo’s automated inventory process is saving us some serious time.\u201d<\/span>\n\nRick Cochran, VP, Business Intelligence, HMG Healthcare<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]HMG now has a dynamic inventory system that allows them to track product needs by facility, cost of product, number in inventory, as well as the distribution of each product to the facility with the corresponding price. \n\nHMG now have a full customizable, scalable solution that will take them through the pandemic and into the future.[\/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=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/09\/Logo-HMG-Healthcare-LLC.webp” alt=”HMG Healthcare logo” title_text=”Logo HMG Healthcare LLC” align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”200px” max_width=”200px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]
Based in Texas, HMG Healthcare manages 30 specialist nursing and rehabilitation facilities across the US. The company uses a data-driven approach to understand predictors and seeks to improve quality of care using analytics to prescribe the right course of treatment.<\/span><\/p>[\/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=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]United States<\/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=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” width=”85%” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]https:\/\/www.hmghealthcare.com\/<\/span><\/a>[\/et_pb_text][et_pb_divider _builder_version=”4.16″ _module_preset=”default” custom_margin=”||20px||false|false” global_colors_info=”{}”][\/et_pb_divider][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]Industry<\/strong>\nHealthcare<\/span>[\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]Features used<\/strong><\/span>\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\/2021\/07\/scalable-sheets-google-drive.svg\")
Google Drive<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/03\/Logos_inventory-symbol-300x300.webp\")
Inventory solution<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/05\/icon-connection.svg\")
Connect<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/automatic-updates.webp\")
Automatic updates<\/div>[\/et_pb_text][\/et_pb_column][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"HMG Healthcare: An automated and flexible inventory solution to solve critical 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, HMG Healthcare now saves 1,120 hours every single year with a custom inventory solution to merge […]<\/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-26253","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/26253","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=26253"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/26253\/revisions"}],"predecessor-version":[{"id":260756,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/26253\/revisions\/260756"}],"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=26253"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/difl_page_category?post=26253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
With the outbreak of the COVID-19 pandemic, HMG faced the challenge of acquiring and distributing personal protective equipment to care staff, as quickly as possible. Global demand made this task more complicated, as HMG had to buy these products from multiple vendors at fluctuating prices. At that time, they were using Excel spreadsheets and manually managing procurement and inventory, which was becoming an extremely time-consuming process.<\/p>\n
The new demands imposed by the pandemic made this system unsustainable, and HMG desperately needed an alternative solution.<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]“Covid-19 challenged us with immediate and significant demands. We were previously spending around 20 hours a week preparing and managing inventory data in spreadsheets.”<\/span>\n\nRick Cochran, VP, Business Intelligence, HMG Healthcare<\/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=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]HMG reached out to us because they needed a dynamic inventory list to manage the acquisition and distribution of over 40,000 items to 30 different locations, taking into account fluctuations in price for different vendors. \n\nThey wanted an automated process that would speed up the supply chain and get the PPE sent out to care staff as quickly and directly as possible.[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”] With Sheetgo, HMG has created a custom, automated inventory workflow based on Google Sheets. Now their data is clearly divided into two spreadsheets; one containing order requests, and another containing the purchases.<\/p>\n With a two-way sync from their ‘Main Inventory’ master sheet, Sheetgo automatically determines whether an order can be placed based on PPE availability. If so, the request is approved, and this order is sent directly to the ‘Purchases’ file. With this synchronisation, the team always have the latest updates, including PPE order confirmation and delivery status.<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cIt gives me, and the directors, the ability to control the flow of information and who\u2019s able to view what. The workflow is really helpful in ensuring we get autonomy and accountability from each department, but we also get accurate information in real-time.\u201d<\/span>\n\nRick Cochran, VP, Business Intelligence, HMG Healthcare<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]In the Main Inventory master sheet, HMG have an overall view of the operation, including key metrics such as items per facility, transactions per item, and deliveries pending. To ensure data consistency, a validation on the master sheet is distributed to Requests and Purchases, syncing data in all spreadsheets so everyone has accurate information at all times. \n\nNow, if an item is missing at a facility, staff can allocate supplies in one click. Additionally, items can now be sent directly from vendor to facility, which speeds up the supply chain.[\/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=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”] Based in Texas, HMG Healthcare manages 30 specialist nursing and rehabilitation facilities across the US. The company uses a data-driven approach to understand predictors and seeks to improve quality of care using analytics to prescribe the right course of treatment.<\/span><\/p>[\/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=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]United States<\/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=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” width=”85%” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]https:\/\/www.hmghealthcare.com\/<\/span><\/a>[\/et_pb_text][et_pb_divider _builder_version=”4.16″ _module_preset=”default” custom_margin=”||20px||false|false” global_colors_info=”{}”][\/et_pb_divider][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]Industry<\/strong>\nHealthcare<\/span>[\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]Features used<\/strong><\/span>\n HMG Healthcare: An automated and flexible inventory solution to solve critical 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, HMG Healthcare now saves 1,120 hours every single year with a custom inventory solution to merge […]<\/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-26253","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/26253","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=26253"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/26253\/revisions"}],"predecessor-version":[{"id":260756,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/26253\/revisions\/260756"}],"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=26253"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/difl_page_category?post=26253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Flexible and dynamic inventory control using Sheetgo<\/h2>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]
\n
Saving 20+ hours per week with a self-sufficient system<\/h2>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]
\n
Google Sheets<\/div>\nGoogle Drive<\/div>\nInventory solution<\/div>\nConnect<\/div>\nAutomatic updates<\/div>[\/et_pb_text][\/et_pb_column][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"