Casio fx-991CW: The Spreadsheet

Casio fx-991CW: The Spreadsheet

Welcome to the Casio fx-991CW segment, which is planned to be every last Saturday of the month for 2025!

Spreadsheet

Screenshots are used the classpad.net website which contains the fx-991CW emulator.

The Casio fx-991CW has a Spreadsheet mode. The spreadsheet is 45 rows and 5 columns. The spreadsheet has a memory capacity of 2,380 bytes. The spreadsheet has basic spreadsheet functions. Data is saved as long as the calculator is in the Spreadsheet mode. Individual results can be stored in the calculator’s memory registers A, B, C, D, E, F, x, y, and z.

The spreadsheet of the fx-991CW can only contain numerical data. There are no labels.

Auto Calc is assumed to be on.

Sum, Mean, and Count of a Range of Cells

The sum of a range: = Sum( α# : β# )

The arithmetic mean of all the numbers in a range: = Mean( α# : β# )

The count of all cells that have a value stored: = Sum( α# : β# ) ÷ Mean( α# : β# )

The count has to be constructed because there is no count function in the fx-991CW. Since Sum is Σx and Mean is Σx / n. Hence count, or n, is: Count = Sum / Mean = Σx / (Σx / n) = Σx * (n / Σx) = n.

The Sum, Count, and the colon character ( : ) are found in the Catalog.

Example:

	A	B
1	45	88
2	25	76
3	93	39

Min, Max, and Statistical Range of a Range of Cells

The minimum value of a range of cells: = Min( α# : β# )

The maximum value of a range of cells: = Max( α# : β# )

The statistical range of a range of cells: = Max( α# : β# ) - Min( α# : β# )

Example:

	A	B
1	45	88
2	25	76
3	93	39

Multiply a Range of Cells with a Constant Rate

We can apply a formula to a range of cells through the Tools menu. The Fill Formula dialogue:

Fill Formula

Fill = (start the formula with the cell you are currently at)

Range : α# : β#

> Confirm

To make a cell absolute, attack a dollar sign, to both the column letter and row number. The dollar sign ( $ ) is in the Catalog.

Example:

	A	B
1		0.85
2	59.95
3	42.75
4	73.95

Storing a Cell’s Value

Exiting the Spreadsheet mode or turning the calculator off will erase the contents of the Spreadsheet. A way to store values permanently is to store the cell’s contents in one of the variables (A – F, x, y, z). To store a value:

1. Go to the cell.

2. Press the [ VARIABLE ] button.

3. Select a variable and press [ EXE ].

4. Select Store.

The value is now stored in the variable, which can be used in other modes. Unlike the spreadsheet, values stored in values are kept until a reset.

I hope you find this helpful.

Until next time,

Eddie

All original content copyright, © 2011-2025. Edward Shore. Unauthorized use and/or unauthorized distribution for commercial purposes without express and written permission from the author is strictly prohibited. This blog entry may be distributed for noncommercial purposes, provided that full credit is given to the author.

TI-92 Plus and TI-Nspire CX II: List Filters

TI-92 Plus and TI-Nspire CX II:  List Filters

For this particular post, I also have a TI-Nspire CX II CAS document which can be downloaded here:  https://drive.google.com/file/d/1Rm5vIWdUMg5OEyXi4VecNfuIGdiGRtan/view?usp=sharing

The functions are public and are available in the catalog.  Examples and syntax are included.  

The Filters

filters(list, criteria): filters out a list 

sumfilt(list, criteria): sum of selected elements of a list

avgfilt(list, criteria): arithmetic average of elements of a list

prdlist(list, criteria): product of selected elements of a list

dimfilt(list, criteria): returns a count of list elements that fit a criteria

This is similar to Excel functions filter, sumifs, averagefits, and countifs; there is no productifs in Excel.  

The criteria is a string, using x as a variable.  Examples:

"x<10": select elements less than 10

"x≥20": select elements greater than or equal to 20

"10<x and x<20": select elements between 10 and 20, not including 10 or 20

"10≤x and x≤20": select elements between 10 and 20, including 10 or 20

TI-92 Plus Functions: Filters

Note:  I am using the symbol [| for comment; in the program editor, select F2, option 9.  

TI-92 Plus Function:  filters

filters(list1,cr) 

Func

[| list, criteria string with x

[| EWS 2021-08-13

[| filter function

Local list2,d,i,t,x

{}→list2

dim(list1)→d

For i,1,d

expr(cr)|x=list1[i]→t

If t Then

augment(list2,{list1[i]})→list2

EndIf

EndFor

Return list2

EndFunc

TI-92 Plus Function: sumfilt

sumfilt(list1,cr) 

Func

[| list, criteria string with x

[| EWS 2021-08-14

[| sum-if filter function

Local list2,d,i,t,x

{}→list2

dim(list1)→d

For i,1,d

expr(cr)|x=list1[i]→t

If t Then

augment(list2,{list1[i]})→list2

EndIf

EndFor

Return sum(list2)

EndFunc

TI-92 Plus Function: avgfilt

avgfilt(list1,cr) 

Func

[| list, criteria string with x

[| EWS 2021-08-14

[| average-if filter function

Local list2,d,i,t,x

{}→list2

dim(list1)→d

For i,1,d

expr(cr)|x=list1[i]→t

If t Then

augment(list2,{list1[i]})→list2

EndIf

EndFor

Return sum(list2)/(dim(list2))

EndFunc

TI-92 Plus Function:  prdfilt

prdfilt(list1,cr) 

Func

[| list, criteria string with x

[| EWS 2021-08-14

[| product-if filter function

Local list2,d,i,t,x

{}→list2

dim(list1)→d

For i,1,d

expr(cr)|x=list1[i]→t

If t Then

augment(list2,{list1[i]})→list2

EndIf

EndFor

Return product(list2)

EndFunc

TI-92 Plus Function:  dimfilt

dimflt(list1,cr) 

Func

[| list, criteria string with x

[| EWS 2021-08-13

[| count-if filter function

Local list2,d,i,t,x

{}→list2

dim(list1)→d

For i,1,d

expr(cr)|x=list1[i]→t

If t Then

augment(list2,{list1[i]})→list2

EndIf

EndFor

Return dim(list2)

EndFunc

Examples:

list0 = {2,4,5,6,9,10,11,13,14,15,18}

filters(list0,"x≤10"):  {2,4,5,6,9}

filters(list0,"5≤x and x≤15"):  {5,6,9,10,11,13,14,15}

sumfilt(list0,"x≤10"):  36

sumfilt(list0,"5≤x and x≤15"):  83

avgfilt(list0,"x≤10"):  6

avgfilt(list0,"5≤x and x≤15"):  83/8

prdfilt(list0,"x≤10"):  21600

prdfilt(list0,"5≤x and x≤15"):  2700

dimfilt(list0,"x≤10"):  6

dimfilt(list0,"5≤x and x≤15"):  8

All original content copyright, © 2011-2021.  Edward Shore.   Unauthorized use and/or unauthorized distribution for commercial purposes without express and written permission from the author is strictly prohibited.  This blog entry may be distributed for noncommercial purposes, provided that full credit is given to the author. 

Calculated Industries Calculators: Memory Registers and Tape

Calculated Industries Calculators:  Memory Registers and Tape

Introduction

This post covers five Calculated Industries calculators:

Tradesman Calc - 4400

Construction Master 5 - 4050

Machinist Calc Pro - 4087

Pipe Trades Pro - 4095

ElectricCalc Pro - 5070

Memory Storage and Store Arithmetic

The calculators do not have storage arithmetic other than the independent memory register (M).   

Tradesman Calc - 4400	Construction Pro 5 - 4050	Machinist Calc Pro - 4087	Pipe Trades Pro - 4095	ElectricCalc Pro - 5070
M, registers 1 - 9	M only	M, registers 1 - 9	M, registers 1 - 9	M, registers 1 - 9
M+, M-	M+, M-	M+, M-	M+, M-	M+

Tape Memory

All the calculators listed except the ElectricCalc Pro has a tape listing memory.  The tape memory records all the arithmetic (+, -, x, ÷), percent (%), and parenthesis keystrokes.  For the square (x²) and square root (√), the numeric results are recorded.  The tape memory does not record any work involving any of the solver keys.

Tape Memory Controls

Clear the Tape:  [ On/C ] [ On/C ] (or do a Clear All)

Enter Tape Mode: [ Conv ] [ = ]

Scroll in Tape Mode: [ + ], [ - ]

Exit Tape Mode:  [ = ]

The table lists the number of steps can be stored:

Tradesman Calc - 4400	Construction Pro 5 - 4050	Machinist Calc Pro - 4087	Pipe Trades Pro - 4095
20	20	30	30

Sample Problems and Tape Memory

Problem 1:  1.99 x 50 + 100 =    (Result: 199.5)

All calculators return the same tape (spaces added for clarity):

01  1.99

02 x 50

03 + 100

TTL = 199.5

Problem 2:  4 1/2 in + 3 3/8 in =  (Result:  7 7/8 in)

All calculators return the same tape:

01   4 1/2 INCH

02 + 3 3/8 INCH

TTL = 7 7/8 INCH

Tape with arithmetic functions will work with units.

Problem 3:  ( 1.99 x 20 + 25 ) = + 10% =   (Result: 71.28)

Tradesman Calc (4400) tape:

01  ( 1.99

02  x 20

03  + ) 25

SUB = 64.8

05 +% 10

SUB % 71.28

TTL = 71.28

Pipe Trades Pro (4095) tape:

01  1.99    (first parenthesis is messing)

02  x 20

03  + ) 25

SUB = 64.8

05 +% 10

SUB % 71.28

TTL = 71.28

Construction Master 5 (4050) tape and 

Machinist Calc Pro (4087) tape:

The parenthesis are left out since neither of these calculators have parenthesis.  I have left the calculations in that order to ensure proper order of operations:

01  1.99    (first parenthesis is messing)

02  x 20

03  + 25

SUB = 64.8

05 +% 10

SUB % 71.28

TTL = 71.28

Problem 4:  15 x^2 x π  (Result:  706.85835)

All calculators return the same tape:

01 225   (shows 15^2)

02 x 3.141593

TTL = 706.85835

Problem 5:  24 x 59 = √   (Final Result:  √1416 = 37.62978)

All calculators return the same tape:

01 24

02 x 59 

TTL = 1416

The square root is totally ignored!

Problem 6:  24 √ x 59 √ =    (Result: 37.62978)

All calculators return the same tape...

01 4.898979 

02 x 7.681146

TTL = 37.62978

except the Trademsan Calc (4400) - sometimes:

01 24

02 x 7.681146

TTL = 37.62978   (this doesn't make sense!)

However, most of the time, I get the proper tape above.  This just a thing to watch out for.  

Note that √(24 * 59) = √24 * √59

Curious that none of the Calculator Industries finance and real estate calculators have the tape feature.  

The Recall Memory Feature:  Additional Calculations

The Recall Memory (Rcl) of the independent memory register returns three calculations:

TTL:  total or sum

AVG: average of all entries by M+

CNT:  count of all entries by M+

[ Rcl ] [ M+ ]: To display the contents of the independent register (total).

Keep pressing [ M+ ] to cycle through average, count, total.  Press [ On/C ] to exit.  

The notable exception is the ElectriCalc Pro:

[ Rcl ] [ 0 ]:  To display the contents of the independent register (total).

Keep pressing [ 0 ] to cycle through average, count, and total.  Press [ On/C ] to exit.  

Sample Data:

410, 359, 367, 388, 384

Recall memory M until it's cleared.  You can store 0 into Memory M or press RCL twice.  Insert presses of [ Conv ] when needed.  

410 M+

359 M+

367 M+

388 M+

384 M+

Note:  On the ElectriCalc Pro, press [ Stor ] [ M+ ] to use M+.

RCL M: 

TTL 1908  (TOTAL on the Machinist Calc Pro)

(Press M again)

AVG  381.6

(Press M again)

CNT  5   (COUNT on the Machinist Calc Pro)

(Press M again to cycle.)

That is a tour of the memory features on some of the industrial calculators from Calculated Industries.  Hope you find this useful!

Eddie

All original content copyright, © 2011-2021.  Edward Shore.   Unauthorized use and/or unauthorized distribution for commercial purposes without express and written permission from the author is strictly prohibited.  This blog entry may be distributed for noncommercial purposes, provided that full credit is given to the author.