Software > !! Start Here !!
We offer Software in the form of free standing Google Sheet Templates. They present in a spreadsheet format but all have been created with a lot of "database design theory" in mind. They can and should be used for Business Education and Programming Education purposes, but they are also a great fit for replace existing commercial software solutions that generate Billions in annual revenue while providing lackluster functionality and breaching communal small business privacy in horrible ways.
Our Google Sheet Templates can be downloaded into any standard spreadsheet format, but some functionality may be lost. For those wishing to use them outside of Google Drive, you'll need to download them and play with them to see how they do on other platforms.
We call our templates "software" because we use the standard spreadsheet infrastructure as a database platform and we use database logic to build our applications. This type of use has been available since the 1980s and the advent of Spreadsheets. The advent of Cloud Spreadsheets opened a door that made it more logical to invest the time in building out these types of solutions. The fact high school and college students are not getting a year of database programming in spreadsheets to go along with things like a year of Statistics or a year of Economics is overly concerning.
About Our Google Sheet Templates...
Bound and Unbound Google Script Projects
DIY Software Club
Our Google Sheet Templates can be downloaded into any standard spreadsheet format, but some functionality may be lost. For those wishing to use them outside of Google Drive, you'll need to download them and play with them to see how they do on other platforms.
We call our templates "software" because we use the standard spreadsheet infrastructure as a database platform and we use database logic to build our applications. This type of use has been available since the 1980s and the advent of Spreadsheets. The advent of Cloud Spreadsheets opened a door that made it more logical to invest the time in building out these types of solutions. The fact high school and college students are not getting a year of database programming in spreadsheets to go along with things like a year of Statistics or a year of Economics is overly concerning.
About Our Google Sheet Templates...
- All our Templates are FREE.
- All our Templates are as private as one can hope for in a stand alone software solution or a stand alone cloud based spreadsheet template.
- No user accounts are required to view or gain copies of our Software or our Support Material
- Once you have a copy of our software, it is completely independent from us in every way. The are "just" google Sheet or spreadsheet file copies. There are no ties back to us at all. While that is good for privacy and customization, the draw back is there is no auto-updating functionality, because it's just a spreadsheet file. Future changes made to the master template will need to be manually implemented by you OR you will need to download the newer template and transfer your data and any file customization over to the new template.
- All our Templates can be copied onto your Google drive or downloaded as an xlsx or ods format with about 15 seconds of work.
- All core functionality for our templates are done in spreadsheet equations whenever possible (as compared to scripting modules that are more complex), so after the 15 second download process you have very robust "software" in most cases.
- All our templates come with some level of demo data in them so you can more quickly learn about their functionality.
- All our templates are fully open source as are the Google Scripts in the Bound and Unbound Google Script Projects.
- Some of our templates can be chained together for very robust Enterprise Level Modular Software Solutions by those with programming skills and a desire to grow
- Most of our Templates come with a robust level of educational information, documentation and/or videos which can typically be found in Subdomains specific for each template. Those links are found on the landing page for each template.
- Our Templates are all fully customizable with the only limits being those put on you by the spreadsheet platform you engage with and and your own imagination
Bound and Unbound Google Script Projects
- All of our templates have an Internal Google Script Project associated with them. This can be accessed via the "Extensions > Apps Script" menu item. This offers supplemental functionality. Prior to using scripts in the Project you will need to "authorize" the file. It's a scary looking process even though the entire setup is yours and secure. Read our material on this or watch our videos for a better understanding. We do NOT violate your privacy with the included script's, but that does NOT mean others won't. You'd need to look through every script in the module with an ability to discern what it is doing to know if the scripts maintain your privacy.
- For some of our templates, an additional Unbound Google Script Project can be downloaded and connected to the template for enhanced functionality. These offer full privacy for you as well. As with the Internal Google Script Project, there are no calls made outside your Google Drive when these are in use. If ever comes a time when a script is included by us to make a call outside of your own Google Drive, like with the credit card processing concept we have on the drawing board, those scripts will be clearly noted and documented in extreme detail.
- If you download the template in xls, ods, or some format other than gSheet for Google Drive, all the scripting functionality will be useless and non-viewable. You would need to use the raw scripts as viewed via the Google Sheet / Google Drive interface and rebuild that scripting functionality in the Spreadsheet Scripting Language compatible with the platform you are using.
DIY Software Club
- After building out a handful of Templates, we went back and standardized them.
- Then we created "a written set of standards" for creating templates in a similar manner.
- For those who wish to see those standards and attempt to build similar but different applications in a way that can build community, please see: https://diy-software-club.weebly.com/