Whenever a team or a domain uses Sheetgo, they start to create a system that consists of connected and linked spreadsheets. Linked spreadsheets inside a domain become intelligent because they form part of a bigger neuronal grid of data. At Sheetgo, we measure the “Linktelligence” (LQ) of users. By knowing your LQ you can find ways to improve your spreadsheet systems (and therefore LQ), save time, increase the utility of your data, and improve your 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: we use the terms link and connections interchangibly) created. Key points that we consider:
- 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 both send and receive data
- Active Links: links that have been updated in the last 30 days.
With this basic data, we already have insights into the network our users are creating and we can caclulate 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
Our theory of LQ posits that spreadsheets that both receive and send data are more intelligent. Why? Because we know that if a system has a high node-link rate, then we know that this system is highly integrated. 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. Spreadsheets that receive and send data, are likely used to transform data from a source and send to other spreadsheets for visualization or further analyses.
LQ, like IQ has a maximum score of 160. As of August 2017 we have discovered that a small portion of our user base is approaching ‘genius’ levels of 130, while the majority, have created simpler systems with scores between 11-40.
Let’s look at a particular user of ours, Novadaq.com who has a current LQ of 119. 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 has more than 900 hundred links between 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.
By publishing this article and making users aware of their LQ scores, in the upcoming months, we thus strive towards helping our users improve their LQs by getting the most out of Sheetgo. If you need help to solve your spreadsheet challenges send an email directly to firstname.lastname@example.org with ‘Increase my LQ’ in the subject line.