Whenever a team or a domain uses Sheetgo, they start to create a system that consists of connected and linked spreadsheets. In other words, linked spreadsheets inside a domain are intelligent because they form part of a bigger neuronal grid of data. At Sheetgo, we measure the “Linktelligence” of our domain users and clients. The goal of such a measure is to provide suggestions for them to improve their spreadsheet systems and their experience with Sheetgo.
How do we measure Linktelligence?
At Sheetgo we don’t collect any personal data but only metadata in reference to the connections (note: link and connections mean the same) created. Mainly we can know:
- The number of spreadsheets that are linked
- Number of links between spreadsheets
- The number of spreadsheets that receive data
- Number of spreadsheets that send data
- The number of spreadsheets that send and receive data
- Active Links: links that have been updated in the last 30 days.
With these numbers, we can get some good insights in order to sort domains spreadsheet systems by their “Linktelligence”. We consider the following indicators important to measure:
- Node-Link Rate = total linked spreadsheets / total links (this should be > 1)
- Link Rate = total links / maximum links as possible
- % of spreadsheets that receive, send or do both
We claim that spreadsheets that receive and send data are more intelligent. Why? Because we know that if a system has a high node-link rate, then from the link rate we know that this system is really linked and data between spreadsheets flows. In a practical sense, this means that in a given team people get data they need from others or send data to others who will require it. Moreover, if domain users have spreadsheets that receive and send data, probably these spreadsheets transform data and will eventually be sent to other co-workers for further analyses.
We have discovered that only a small portion of our users have an intelligent spreadsheet system:
- Intelligent Systems: 18% of clients and users have Node-Link Rate > 1, more than 5 links and at least one spreadsheet that receives and sends data
- Intermediate Systems: 35% of clients users have more than 5 links, Node-Link Rate <= 1 or at least one spreadsheet that receives and sends data
- Simple Systems: 25% of our domain clients have more than 5 links and no spreadsheet that receives and sends data
- Small Systems: 21% of systems have less than 5 links.
We have seen that only 18% of our domain users have linktelligent systems (we take into account free and paid users). In the upcoming months, we thus strive towards helping our users improve their rates and gain more use out of our main tool: Sheetgo.
Let’s look at a particular user of ours, Novadaq.com. Novadaq is an enterprise that manufactures medical equipment. As a company, they use Sheetgo in their management to link data among their employees. As a user of Sheetgo, Novadaq counts with more than 900 hundred links around their 450 linked spreadsheets, which makes them one of our heaviest users. This means there are approximately 2 links per spreadsheets. Moreover, the weight of spreadsheets that send and receive data reach 36%. This lets us conclude, that certainly, Novadaq makes heavy and good use of Sheetgo.