Merge multiple lists built on spreadsheets that have all been created from the same model.
Based on a model spreadsheet and organizational structure, this application allows business owners to manage a cluster of parent and child spreadsheets system.
Users access are defined automatically and are depending on the organizational unit users are belonging to.
This allows different organizational units to work separately on different spreadsheets fulfilling data confidentiality and data consistency with an automatic consolidation at different levels.
The consolidation is performed cell by cell depending on the aggregator specified on the model spreadsheet.
Interaction between the application and spreadsheets will be handled through Google add-ons and controlled by an App Engine application.