Sensorica's Google-based contribution accounting system
Sensorica's Google-based value accounting system is a functional prototype used by Sensorica members to experiment with value accounting. Sensorica is now using a web-beed NRP and VAS, see github project.
The core of this first prototype of value accounting system prototype is built using Google spreadsheets that are stitched together with Google Scripts. Visuals can be created and be deployed on a website.
This value accounting infrastructure is good enough for a simple value network. One example would be a network of translators of documents. The value produced is translated text. A simple metrics can be used to measure value produced by every member: number of words translated. This quantity can be modulated by the type of translation: scientific, legal, literature, ... If you are interested please contact Sensorica members for the templates and advice (free of any charge). The main architect of this prototype is Tibi.
External links
See Sensorica Infrastructure page.
List of spreadsheets
The name of all the spreadsheets that are part of the infrastructure start with "Sensorica Infrastructure"
Contributions
- Sensorica Infrastructure - time contributions
- Sensorica Infrastructure - material contributions
- Sensorica Infrastructure - financial contributions
Every one of these spreadsheets contains data about contributions, performs calculations on this data, and produces visuals.
The data sheet is open to the public for view. Only Sensorica affiliates can edit it. Only affiliates that are active in infrastructure development have access to modify the calculations sheets. The calculations are transparent. Any Sensorica affiliate can get access to edit these sheets if he asks for.
Members
Every new affiliate is logged in the Sensorica Infrastructure - Members list. This spreadsheet is closed to the public, because it contains the full name and email of all affiliates. All Sensorica affiliates have access to it.
A new member is subscribed using a form associated with this spreadsheet. A script propagates new members information to all the other spreadsheets.
Others
Sensorica Infrastructure - Back Office Catalog contains a list of all activities recorded by members, a list of all Sensorica ventures and a sheet that captures the relationships between ventures.
the Sensorica Infrastructure - Reputation is a prototype of reputation system, never been used by Sensorica affiliates.
The value equation
All the data is aggregated into one spreadsheet and crunched through the value equation. See an example for the Mosquito Venture
A Program was also made to perform calculations on the value equation for all ventures. See video on Youtube.
The system
This section describes how everything is stitched together using Google Scripts... more to come shortly