Technical > Documents
Pre-reading for this is found at http://spreadsheets-for-all.weebly.com/ As the clever become smart, the smart will have to become clever to keep the dance in balance.
ALL of these documents are required reading/skimming for prospective DIY Software Template Users, Educators, Consultants and Developers. Think of these as resources you can always refer back to. With that understanding, you don't need to memorize or understand everything in them. You just need an expanded vocabulary and you need to know where to find the information when it is needed.
ALL of these documents are required reading/skimming for prospective DIY Software Template Users, Educators, Consultants and Developers. Think of these as resources you can always refer back to. With that understanding, you don't need to memorize or understand everything in them. You just need an expanded vocabulary and you need to know where to find the information when it is needed.
- DIY Software Club - Book 1 - Introduction to Relational Data
This document provides an easy introduction to Relational Data that is needed to use and/or design database style applications in spreadsheets. A key example exposes the conspiratorial reasons to shift to stand alone data options for key commercial needs whenever possible!! This is a short and pleasant read, given its educational, technical and rather revealing nature.
19 pages -- Last Updated: 11/9/2019 - DIY Software Club - Book 1a - Primary Key Creation Options for DIY Software
- DIY Software Club - Book 2 - General Digital Standards and Etiquette
This short document details well used Digital Standards for digital organization which can instantly help many with digital organization in big ways with little effort. Introduction to camelCase and underscores found here!! It also provides basic etiquette for digital communication .
18 pages -- Last Updated: 11/15/2019 - DIY Software Club - Book 3 - Google Sheets Handbook
This document provides a very detailed review of the Google Sheets interface. It identifies all typical spreadsheet functions available via the user interface (aka graphical user interface / gui) . It details functionality unique to Google Sheets, given it's a cloud based spreadsheet option. It identifies features and functions that do NOT behave as expected in this new spreadsheet option. It includes comments about frequency of use, or lack there of, as related to DIY Software Club templates. It details what functions should be used in a limited or very cautious manner to avoid data or software corruption, which you can recover from yourself or with the help of others. This is not a 'tutorial' per se, but it could become one if you use it to identify what you don't know, and follow that with a search for videos and tech resources to fill in your blanks.
24 pages -- Last Updated: 11/9/2019 - DIY Software Club - Book 4 - Google Sheets File Template Standards (DIY Software File Template Standards)
This document details file and worksheet level design features you will find in most, if not all of the DIY Software Club Templates. Saying that another way, this document provides detailed information about data and interface design concepts which turn a Google Sheet (or any spreadsheet) into a "database style software application". ADD MODULARITY BIT SOMEWHERE... (12/1/2019)
40 pages -- Last Updated: 11/13/2019 - DIY Software Club - Book 5 - Bound and Unbound Google Script Projects Explained / GSP GUI photos
This document provides clarity on bound and unbound Google Script Projects, both of which play important and connected roles behind the scenes of all DIY Software File Templates. This document provides details from a Google Script Project interface, connection and use perspective. It explains how to view and edit bound projects and it includes detailed instructions for creating unbound GScript Projects and connecting them to bound GScript Projects for use within the file templates. (includes screenshots of new Google Script Project Programming interface as well as the one that was obsoleted 9/2022)
38 pages -- Last Updated: 8/29/2022 - DIY Software Club - Book 6 - Google Script Project Standards
This document details the "style" DIY Software developers use to create and manage the java script/html/css in these script projects. This starts with suggested systems for "project" and "file" naming. It gets into function and variable naming and goes into greater relevant detail that was provided in Book 2. It's imperative that users and developers follow some general standards to make sure your work can be updated and supported by others down the road in an efficient and cost effective manner.
18 pages -- Last Updated: 11/13/2019