Don't use an Excel application as a data storage software to store company data. Use cloud-based data storage instead.
Client: Clientigent
Date: September 2021
Style: Hand-drawn
Share
Main ideas
Using Excel appliaction leads to several problems you can avoid using cloud-based data storage.
Granularity of access control list in Excelu in not detailed enough, it is difficult to track changes done by different users.
Data is not structured in Excel table/sheet, you can use rows and columns only.
Data can be hardly shared, you can experience exchanging XLSX files, everyone worsk with its own version, data is overwriten, the vesioning is difficult.
Solution based on Excel sheets is suitable for small data at maximum, the solution is not scalable.
Script
Not Secure/Safe
the man like Holmes looks for changes in sheet
some bad guy changed data and hide
Not Structured
you need a value from another table, complicated formula, more sheets…
the man thinking about formulas, steam comming out of his head
Not Shareable
two different users change data in their own versions, it is impossible to merge that versions
those users push its table, trying merge them (unsuccessfuly)
man tries to merge data from different files that other users are sending to him