2021-03-14 at

Oh, Sheets ...

Today is a happy day. All of the following remains contained in just ONE spreadsheet.

An initiative I've been pursuing at work is to get the daily DUTIES of our 100+ staff listed and tracked in a RELATIONAL database. We want to clearly bag duties and tag them under ROLES, with explicit SOLID LINE and DOTTED LINE reporting relationships to other roles, criss-crossing the organisation. Any STAFF can be tagged to one PRIMARY and multiple AUXILIARY roles.

Today we released v3 of this tool, and its reporting VIEW which instantly visualises all the relationships above for any staff. This greatly advances our shifting of cognitive stress from people to computers, allowing us to model and track operation with more agility and accuracy. Modern life is so complicated - I can't imagine why people would try to do it without assistance from machines.

The upcoming v4 will enhance the basic datastructure, where each role has prerequisite TESTS, and associated COMPENSATION data. Roles will also be tagged to performance management BENCHMARKS, with annual and project-wise CALENDARS, among other dimensions.

We're a small company: implementing this using an unconventional medium has been challenging, and it provides us with some hope that we can do enterprise quality work at minimal cost. 

No comments :

Post a Comment