attention data nerds! As the head of my department, I need to keep track of what courses we are offering, to make sure that we are getting appropriate coverage in terms of course offerings at each grade and English ability level, to keep track of teacher workloads, to plan for curriculum renewal, and to make sure that the Academic Affairs department isn't screwing up our schedule. Right now, we have several different documents/files, in various formats and at varying stages of currency, for those different purposes, with a bunch of redundant info and several conflicts/errors that are a real pain to track down. So I want to create the One Database to Rule Them All, where I can make changes that are then reflected in documents formatted for those various purposes. I would like to use Google Sheets (because it's free and platform-independent and I can work on it from several different devices wherever I am) to input the data for every course that we offer, with columns something like this: Lastname, Firstname, Coursenumber, Coursetitle, Trimester, Hrs/wk, Level, Grade, Assessments, etc Then I want to be able to whip out different charts, such as how many hours per week each teacher is teaching in a given trimester or over the whole year how many intermediate-level high school courses are being offered each trimester how many offerings involve research paper writing, slide presentations, debate, etc. I found a google add-on called Autocrat that lets me pull, for example, all the data from a given row and plug it here and there into a PDF or Google Doc, but it can't total teaching hours for each teacher, for example, or give me output sorted by the values in cells (anyway, I think it can't...). So I want to know how I can crunch some numbers and manipulate this data to generate a variety of tables without SCRIPTING (or paying money). Also I want to be able to add/delete course rows over time or re-sort the whole SS (by teacher last name, for example) as offerings change without breaking the output, so output can't be keyed to any specific cells of the SS, only to specific columns and/or the contents (for example, I want to be able to call out courses that are offered in even or odd years). It wuold be nice if I could easily generate teacher-specific PDFs and such. I have started building the data with my own course offerings for the year, using drop-down menus to make input of subsequent courses easier, but it's still going to end up being a huge project (for me), even before I do any google-fu to the data. So does anybody know of google-friendly apps/add-ons that would let me use a google Sheets doc to run pretty basic database functions? I don't need a whole big walk-through (well probably I do, but I wouldn't ask for it), but just want to know if such a solution exists and where to start my explorations. Thanks in advance!