Table/Maker The Only Spreadsheet Using Only Arithmetic
But can the intended audience learn this approach and use it productively? I hope to make that experiment with some students.
Are you In a hurry? 
(some distance below) is a link to an introductory video.

References:       https://en.wikipedia.org/wiki/T/Maker       https://en.wikipedia.org/wiki/Peter Roizen 
Email: roizen@ix.netcom.com  First impressions appreciated. Nearing 80, I have to find the best chance for light at the end of this lengthy tunnel.
 Links:  The Download Page      My other outside-the-box idea:  WildWords Crossword Game   

Some say teach everyone algebra. Others say let many learn practical math. Meanwhile graduating seniors and the population at large are setting new lows for numeracy measures. And, how do you do this "practical math" easily when every spreadsheet is driven by the abstract notation you are trying to avoid? Another answer: come up with a new tool founded in arithmetic. Nobody forgets arithmetic. T/Maker relies on a hand calculator style syntax. It does have some non-esential capabilities that might be distracting. And it also requires an avoidable package from Oracle that hinders a wider distribution. But the user interface and syntax (the unique ideas here) can be tested on students and others using this version. With help from a Microsoft or Google, it could be slimmed down, polished up, and dispersed to millions with supporting tutorial videos.

So, why me? How did I get here? Why am I suggesting this thing that no one else ever even imagined? Answer below.

IHA Boxpr History:  While the world produced cell-based algebra spreadsheets (starting with VisiCalc), unusual choices resulted in a task on my desk that was fundamentally different. It involved typing instructions within a document to perform calculations. I did this with arithmetic symbols across the page and in the left margin. These could be removed automatically before printing. Thus the document was undisturbed on paper.

I published T/Maker in 1979 with that feature in what was a word processor plus many other utilities. Later in 1991, I extracted the math part and added cells in a version for
Windows. In 2020 a system update killed these tools. Jumping ship to a regular spreadsheet would have been a betrayal of worthy ideas, fond memories, and surprising success. So I resurrected and expanded this one-of-a-kind syntax targeting it for students and others with no knowledge of, or inclination to learn, algebraic notation, and consequently no existing spreadsheet to use.

Am I a madman on a mission? I am on a mission and might be the one person in the world who was destined to create this page, at this time, with this approach. The lead-up described is accurate and spans more than four decades. It's hard to say that is not some form of destiny!

Sketch from Programmers At Work, Microsoft Press, (c) 1983
Not the best title for the 1991 version!
 



The Math Interface And Syntax:  Please read with attention and study the example. It's the crux of this never-seen-before approach.

What is the process of calculating all about? Usually you have some numbers and hope to derive a new one based on them. Maybe your annual sales from monthly figures? Maybe the average number of eggs per day laid by your chickens? Who knows? Aside from the numbers to start with, you will need basic arithmetic symbols representing known operations with two numbers: + adds two numbers, / divides a first number by a second, etcetera.

So what should one look for in a software program intended to do calculations for those without algebraic abilities?
  • Easy ways to write and understand the math operators and the sequence in which they are executed.
  • A variety of ways to designate numbers used and created with minimal characters or even just a click to avoid overbearing column / row cell names.
  • If you could see the above side by side with the data used in an intuitive display, that would be amazing.
  • Allowing calculations to be placed in locations that clarify the intent instead of always the cell where the result is displayed.
  • Having a tool to walk through and display the results of each operation one by one to find mistakes and build your confidence.
All these charms are accomplished by T/Maker.

Let's imagine a giant calculator which can display tons of buttons sitting on top a screen of green and white boxes in two dimensions. Formulas are not written in T/Maker as in algebra. Rather, you compose things called Calculation Trails. These are specified in the green boxes. The white boxes hold the text and numbers you want to see or print when not fiddling with the math. Each trail is made up of steps which are numbered and executed in number order. One step is like a sequence of buttons pressed on a calculator. T/Maker does the step moving left to right. Unlike a formula, one trail can calculate many values. Also there is no need for parentheses or confusing rules of precedence.

You can see some Basic Operators in the middle of the toolbar. There are tool tips to learn most everything. The exclamation point ! operator enters a value into the calculator. But which value? In T/Maker there are choices to make. A key to understanding T/Maker is learning to read the operator symbol and see immediately what value is designated with it. That value is most often used in conjunction with the value already in the calculator. When the symbol requires such a value and none follows the operator, T/Maker takes the value from the adjacent white column. Step 1 sets the value in the calculator to 2.

Step 2 adds the value 3 to the calculator since the operator is followed by a constant. The presence of 55 in the white cell is not relevant.

Columns in T/Maker are named from A to Z. When an operator is followed by a single letter, the value used will be the one in the column named. In step 3 the value in the calculator is multiplied by the value in column D which is 5. As with step 2, the number in the adjacent cell is of no consequence. With experience, you learn to choose among possibilities to achieve a clear and tidy presentation of what is going on.

There are things called "Functions" that typically take the value in the calculator and replace it with a value derived from it. "sqr" is one that replaces the calculator's value with its square root. An equal sign = is an Output operator and is followed by a designation of where to place the current calculator value. The same is true of the number symbol #. The difference is the = also clears the calculator to zero while the # leaves the value in the calculator unchanged for further manipulations.

T/Maker's calculator offers memory storage slots you can name yourself. A memory name must start with two letters optionally followed by more letters and numbers. They
must not be the same as a keyword in the toolbar. Choose them for their rememberability. They are immensely valuable for intermediate results. In Step 4, the square root value in the calculator is placed in a memory named SaveIt.

Step 5 enters 4 in the calculator, adds the value in the SaveIt memory and puts the result in cell C6 -- column C row 6.
Cell names are discouraged. They have no intuitive value and often lead to mistakes. Yet, they are the way algebraic spreadsheets specify most values.

Step 6 determines the area of a circle from its diameter using the built-in memory pi. Sometimes it's best to do a whole calculation in one green cell. In Excel, the formula to do this would be put in cell C8 as: =((b7/2)^2)*PI()
. That might as well be Chinese for millions.

For FYI Sake: "Special" functions require multiple input numbers as with a mortgage payment (amount, interest rate, length of loan). By convention the parameters are placed in fixed name memories. "Flow Control" allows impromptu exits from or restarts of various calculations. A "When" clause describes a conditional test so different situations can be handled by different calculations. T/Maker's calculator is completely programmable and useable to create simulations, perform binary searches, etcetera. Whiz kids will not be stifled.  Still, giving a completely ignored audience a way to do daily life bookkeeping and calculations sans algebra is the major breakthrough here.

Even though you have learned a lot,  
please watch this video demonstrating the above and some surprises in real time.  Size the new window as needed.

Teaching T/Maker: It is not hard to do the calculations for a vareity of topics. These topics can also be supported by practical applications. Templates as well could be provided. The differences between a template in T/Maker and one in Excel are substanial. Each trail in T/Maker can be given a name and explained with an associated comment. Trails mimic the operations of a hand calculator which is easier to grasp than nested parentheses and cell names. PLUS, the user can walk through any and all calculations operator by operator. Modifications are also simpler to undertake and verify.



The above table has one trail for each of the shapes described. You can see the first trail for rectangles in the image. The perimeter and area are calculated. A depth is added to determine the volume for a box. I would hazzard a guess that a substanial portion of the population would never need to know more geometry than what appears in this table. This is enough for basic DIY projects.

To the right is a table I actually needed to make. It calculates the bags of QuikCrete required to fill holes for 30 square fence poles placed in a hole which is 9 inches in diameter and 2 feet deep. All steps are shown in the Trail Steps box which is another convenient and informative way to review what is going on in a given trail.

T/Maker is a great opportunity to develop critical thinking skills by solving problems that require multiple intermediate results. Not everyone will be able to do everything. But they will find things they can do after an hour of learning.

As mentioned above, most any topic can be demonstrated by constucting tables that serve a practical purpose or in some cases, just for fun.
Teach simple charts: Which one makes your point best?
Teach keeping track of bills and budgeting.
Teach basic statistics: Why is the median often more informative than the mean? 
Teach simulating roulette with the optimal strategy for a certain risk, reward, and lucky number. Believe it or not!

















 



Forms: With four different line styles plus the possibility of no line, you can design some nice forms. Allow text to span multiple columns when setting formats (Alignment "+" Spans). Text can be specified in an invisible ink format effectively blanking it out. This is useful when elements in a table are needed for calculations but not desired in a final print-out. A respectably looking estimate or invoice template could cetainly be made for the self-employed.

Printing:  Print the table in one of four fonts. Choose font style and size. Set a row height to tighten or spread out the vertical dimension. Decide whether or not to print lines. Options are available for row names and column names. Switch between landscape and portrait as well as set margins with two system dialog boxes called up with a button.

The top of the page shows the length and width of your table in pages. In addition to marign adjustments, changing the size of the font and other items may affect these numbers. Use the Recalculate button to refigure the size when you have altered any items. I generally try for a minimum number of pages with the width of only a single page.



This is "IN PROGRESS" with more features described soon.
However, I think the basic arguments for this unique approach are mentioned above.
Other stuff includes importing and exporting data, sorting rows, specifying formats, inserting rows cloned from another, etcetera, etcetera.