[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-customer-youngcapital-main.webp” title_text=”bs-customer-youngcapital-main” _builder_version=”4.16″ _module_preset=”default” width=”100%” max_width=”600px” max_height=”360px” border_radii=”on|12px|12px|12px|12px” box_shadow_style=”preset1″ box_shadow_horizontal=”6px” box_shadow_vertical=”0px” global_colors_info=”{}”][\/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=”{}”][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.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Using Sheetgo, YoungCapital now combines data from 60 different location spreadsheets with other data sources, and centralizes this information in master sheets. This enables them to forecast results quickly and easily, freeing up more time for analysis.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Finding an automated alternative to IMPORTRANGE<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- 100’s of IMPORTRANGE internal errors\n<\/li>\n
- Incompatibility between Microsoft and Google tools<\/li>\n
- Struggle to create budget forecasts for 60+ locations<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
YoungCapital Business Control had the task of creating and managing the entire forecast budgeting across all YoungCapital locations globally. The department realised their budget forecasting processes were in trouble when they started to encounter multiple IMPORTRANGE errors in numerous spreadsheets. They reached a point where they believed the only way to stop this was by manually creating 60+ forecast sheets in Excel and sharing them across teams. However, this was a no-go for YoungCapital, as a large part of their middle management had started to work with Chromebooks, and no longer had Office licenses.<\/p>\n
[\/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=”{}”]“We were finding IMPORTRANGE errors in almost all of our budget forecast spreadsheets. We really thought we’d have to do the whole process manually instead.”<\/span><\/p>\n
Sophie Kuijpers, Head of IT Operations, YoungCapital<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Due to these main challenges of IMPORTRANGE errors, incompatibility between Microsoft and Google tools, and hours upon hours of manual work, YoungCapital reached out to us for a solution. They wanted a completely automated workflow that would create a budget forecast for each of their 60+ locations to better monitor the overall picture. Sheetgo would need to centralize hundreds of data sources and turn these into actionable insights that YoungCapital could use to optimize their budgeting.<\/p>\n
[\/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.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Effortless data centralization using Sheetgo<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- Merge to consolidate 611 spreadsheets<\/li>\n
- Flexibility to centralize and decentralize budget data<\/li>\n
- Automatic update schedule for up-to-date insights<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
With Sheetgo, YoungCapital has built a custom workflow that fully automates their budget forecasting system using Google Sheets. Applying the Merge feature, YoungCapital now creates forecasts for each location by consolidating multiple sheets, in order to estimate current vs planned budgets without any manual effort. Then, YoungCapital merges these 60+ location spreadsheets with other data sources and centralizes this information in a master sheet, for a quick overview of all budgeting forecasts.<\/p>\n
[\/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=”{}”]“A key advantage for us is the fact we can centralize decentralized data and decentralize centralized data!”<\/span><\/p>\n
Eric de Boer, Business Controller, YoungCapital<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
By connecting several data sources with Sheetgo, YoungCapital can centralize decentralized data, and decentralize centralized data whenver they want. What’s more, they can schedule automatic updates to receive the latest insights which are automatically updated across their connections. Finally, Google Sheets and Sheetgo allow the Business Control department to control access to information, so that they can provide stakeholders with insight into their results\u2014and to manage everything centrally.<\/p>\n
[\/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.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Saving 57 hours a year to focus more on analysis <\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- 57 hours saved every year<\/li>\n
- 1-2 days of work saved every month<\/li>\n
- 100% up-to-date budget forecasting results<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Thanks to this new centralized system, YoungCapital now save around 57 hours every single year which they can now dedicate to budgeting analysis. Replacing the previous manual input and transfer of data, 3 YoungCapital employees now save 1-2 days every month with this automated workflow.<\/p>\n
[\/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=”{}”]“Sheetgo enables our Business Control department to create a simple and efficient forecast process in Google Sheets, it saves us some serious time and money”<\/span><\/p>\n
Sophie Kuijpers | Head of IT Operations, YoungCapital<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
YoungCapital no longer have to struggle with IMPORTRANGE formulas, and the system is compatible for all team members thanks to it based solely on Google Sheets. YoungCapital now have their 60+ location forecasts at hand, with the opportunity to easily scale this as their company inevitably grows.<\/p>\n
[\/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\/04\/bs-customer-youngcapital-logo.svg” alt=”YoungCapital” title_text=”bs-customer-youngcapital-logo” align=”center” _builder_version=”4.16″ _module_preset=”default” width=”200px” max_width=”200px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]YoungCapital is one of the biggest recruitment agencies in The Netherlands with 60+ locations in nine different European countries. They help boost people\u2019s careers and provide them with the opportunity to work at companies where they can make a difference.<\/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=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.16″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]<\/p>\n
The Netherlands<\/span><\/p>\n
[\/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.16″ _module_preset=”default” width=”85%” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]https:\/\/youngcapitalinternational.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.16″ _module_preset=”default” global_colors_info=”{}”]Industry<\/strong>
\nRecruitment agency<\/span>[\/et_pb_text][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\nFeatures 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\/2022\/04\/bs-icon-bigquery.svg\")
BigQuery<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-folder.svg\")
Folder<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-merge.svg\")
Merge<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
YoungCapital: An automated forecast process centralizing data from 60 locations with SheetgoSheetgo 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, YoungCapital now combines data from 60 different location spreadsheets with other data sources, and centralizes this information […]<\/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-20452","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/20452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=20452"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/20452\/revisions"}],"predecessor-version":[{"id":260751,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/20452\/revisions\/260751"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/6600"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=20452"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/difl_page_category?post=20452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}