{"id":10569,"date":"2024-09-04T08:09:08","date_gmt":"2024-09-04T08:09:08","guid":{"rendered":"https:\/\/www.dataerport.com\/?page_id=10569"},"modified":"2024-09-06T17:57:03","modified_gmt":"2024-09-06T17:57:03","slug":"excel-pokol-hogyan-egysegesitheti-tablazatait","status":"publish","type":"page","link":"https:\/\/www.dataerport.com\/en\/excel-pokol-hogyan-egysegesitheti-tablazatait\/","title":{"rendered":"Excel Pokol"},"content":{"rendered":"
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Spreadsheet Chaos<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\n
\n
<\/div> \n
Task<\/div><\/div>
<\/path><\/svg><\/div>
<\/div>
Weekly formula setup, verification, and standardization of 6 different Excel files. <\/div>
\"\"<\/div>

The files come from external clients in various formats and are used for placing their orders.<\/p>\n

Two Excel files are received as email attachments.<\/p>

Three Excel files are uploaded to a shared folder (FTP, Google Drive, etc.).<\/p>

One Excel file is received directly in Google Sheets\/Microsoft 365 Online.<\/p><\/div><\/div><\/div>

Current Workflow<\/div><\/div>
<\/path><\/svg><\/div>
<\/div>
Manual Processing<\/div>
\"\"<\/div>

Without Data ERPort, the employee performing the task must manually standardize these files using formulas and verification.<\/p><\/div><\/div><\/div>

New Workflow<\/div><\/div>
<\/path><\/svg><\/div>
<\/div>
Automatization<\/div>
\"\"<\/div>

With the implementation of Data ERPort, the task can be fully automated, and the incoming excel files are processed automatically by the system.<\/p><\/div><\/div><\/div><\/div>\n

<\/div>\n <\/div>