Cellsheet program in Folder acel (arbitrary name) F1 Menu 1:Open Open saved sheets 2:Save Sheet As... Will save contents 3:New New sheet screen 4:Cut Puts frame around selected cells. Move cursor to another cell. Paste inserts values of selected cells and clears selected cells. Select cells <- clears cells and lower cells move up. 5:Copy selected cells 6:Paste to desired cells 7:Freeze Titles dimmed (Unknown use) 8:Clear Sheet All clear 9:Format Auto Calc Yes No Cursor Movmt 1:Down 2:Right 3:Off Show 1:Formula 2:Value A:About Program version B:Help Shortcuts Typical initial display x stands for name of this sheet x| A | B | C | -------------- 1| | | | -------------- 2| | | | -------------- 3| | | | -------------- It is useful to select Mode Split 1 APP CellSheet. 2nd APPS shows cell screen alternating with Home screen. Cell values like a1 are not variables in home screen. x| A | B | C | -------------- 1| 5 | 6 | a1+b1 Put 5 into a1. Put 6 into b1. Darken c1 -------------- At bottom put a1+b1 enter see 11 2| 8 | 9 | a2+b2 Put 8 into a2. Put 9 into b2. -------------- Put 7 into a3. Put 2 into b3. 3| 7 | 2 | a3+b3 Darken c1 to c3 with up arrow and down arrowhead. -------------- F3 3:Fill range. Initial Formula =a1+b1 Range c1:c3 Enter Enter x| A | B | C | Results -------------- 1| 5 | 6 | 11 | Darken c1 see =a1+b1 at bottom -------------- 2| 8 | 9 | 17 | Darken c2 see =a2+b2 at bottom -------------- 3| 7 | 2 | 9 | Darken c3 see =a3+b3 at bottom -------------- This command automatically gives proper cell reference Change a1 to 10 Enter a2 to 11 Enter a3 to 12 Enter x| A | B | C | Results after last Enter. All c cells are recomputed ---------------- 1| 10 | 5 | 16 | ---------------- 2| 11 | 9 | 20 | ---------------- 3| 12 | 2 | 14 | ---------------- ---------------------------------------- If an equation with cell number references but without an = sign is pasted into a cell, the cell will have the numerical value of the equation To clear cells, darken and hit CLEAR key. Upper and lower case letters are equivalent. If you want a number pasted into a column, darken a1 a2 a3 F3:3 Formula =.1 Range a1:a3 Enter Enter x| A | B | C | -------------- Results 1|.1 | | | -------------- 2|.1 | | | -------------- 3|.1 | | | -------------- If you want a sequence x| A | B | C | Put 0 into a1. Enter Darken a1 and a3. -------------- 1| 0 | | | F3:3 a1+.1 Enter Enter -------------- 2| .1 | | | Results -------------- Select a3 See A3: =A2+.1 at bottom 3| .2 | | | -------------- To recalculate a region, darken all cells, hit 2nd F6. columns can have any text heading x| A | B | C | -------------- 1| w | yy | zz | ---------------- 2| 10 | 5 | 16 | Menus F1 1:Open Opens a saved sheet from folder Type CELL Folder acel-> Enter Variable x-> 2:Save Sheet As... Saves sheet in folder Type CELL Folder acel-> Enter Variable x 3:New Creates new blank cell Type CELL Folder acel-> Enter Variable y 4:CUT unknown action 5:Copy Copies selected cell contents 6:PASTE Pastes copied values to selected cells 7:Freeze titles unknown action 8:Clear Sheet Clears all cell contents 9:Format Enter Autocalc 1:YES 2:NO Cursor Mvmt 1:DOWN 2:RIGHT Show 1:FORMULA 2: VALUE A:About Version B:Help Information on cells ---------------------------------------- Menu at top F2 1:Plot Setup 2:PlotsOff 3:FnOff F3 1:GoTo Cell [A1] A1 cell selected 2:Select Range Select cells by address Range [ a1:b3 ] Fill Range Formula [ =8 ] Range [ A1:B3 ] fill these 6 cells with 8 4:Sequence Expr x <- Var x <- Same variable names(arbitrary) Low 1 High 3 Step .1 1st cell a4 Down Direction 1:Down 2: Right x| A | B | C | -------------- 5| 1. | | | -------------- 6| 1.5 | | | -------------- 7| 2. | | | -------------- * * ------ Right -------------- 5| 1. | 1.5 | 2. | *** -------------- ---------------------------------------- Store number 6 in x in Home x is a variable now in Var-Link 5: Import Type 2:Expr 1:Data 2:Expr 3:List 4:Matrix 5:String Folder acel Variable x 1st Cell A2 See 6 in A2 ------------------- Number 3 is in a2 6:Export Type 2:Expr 1:Data 2:Expr 3:List 4:Matrix 5:String Variable y Range [ A2:A3 ] (When data/list/Matrix is selected in Type Cell [ A2 ] When expression selected ---------------------------------------- 7:Sort Put in this sequence of numbers x| A | B | C | -------------- 2| 1 | | | -------------- 3| 8 | | | -------------- 4| 6 | | | -------------- 5| 9 | | | -------------- 6| 3 | | | -------------- F3:7 Sort 1:Ascending 2:Descending 3:Asc By Key 4:Desc By Key x| A | B | C | -------------- 2| 1 | | | -------------- 3| 3 | | | -------------- 4| 6 | | | -------------- 5| 8 | | | -------------- 6| 9 | | | -------------- -------------------- Descending x| A | B | C | -------------- 2| x | | | -------------- 3| 8 | | | -------------- 4| 6 | | | -------------- 5| 9 | | | -------------- 6| 3 | | | -------------- ------- Order Asc By Key Key Column now available Put in b in key column (must be same column as selected cells) [ a ] Put in selected cells [ a3:a6 ] This key column and cell column must match. Enter Column is now sorted in ascending order and left selected. Key box can be left blank. The Descend by Key function works in a similar fashion. ----------------- 8:Column Format Column [ A ] typical Display Digits Float or Fix desired choice of number of digits Column Width 1 to 12 Justificatio 1:DEFAULT 22:LEFT 3:RIGHT 9:Show Pretty Print Select a cell. This shows contents with full accuracy. ----------------------------------- cell a1 contains 1. Select cell d1 Enter F5 button see $ type a1 see D1: $a1 Enter See 1 in cell d1 select cell d1 F4 Undo cell d1 is now blank Undo clears LAST cell contents, independent of what cell is selected. -------- f5 This is $ used fir defining a fixed(not relative) number F5 makes $ symbol A cell address of a1 is called relative. A cell address of $a$1 a$1 $1a is absolute where $ is used. ----------- F6 1:CellIf select a cell Enter TICSHEET,cellIf(1=1,x,y) statement 1=1 is true so x is in selected cell. If false,y is there. -------- x| A | B | C | -------------- 2| 6 | | | -------------- 3| 8 | | | -------------- 4| 6 | | | Select b2 cell At bottom put TICSHEET.count(a1:a4) see 4 in b2 4 items x| A | B | C | -------------- 2| 6 | | | -------------- 3| | | | -------------- 4| 6 | | | Select b2 cell At bottom put TICSHEET.count(a1:a4) see 3 in b2 means 3 items found in this region TICSHEET.count(a4:c4) counts this sequence in row. ------ mean(a2:a4) gives mean (a2+a3+a4)/3 --------------------------------------- ---------------- x| A | B | -------------- 1| 1. | 10. | -------------- 2| 2. | 22. | -------------- 3| 3. | 31. | -------------- 4| 4. | 44 | -------------- 5| 5. | 52 | -------------- 6| 6. | 99 | -------------- F6:4 rand(A1:b3) in c1 see rand({1,,2,.3.,10.,220.,31}) in edit region ----------- e6 5:sum( sum(a2:a4) gives a2+a3+a4 cell contents ------- f7:calculate Calculation Type 1: OneVar 2:TwoVar 3:CubicReg 4:ExpReg 5:LinReg 6:LnReg 7:MedMed 8:PowerReg 9:QuadReg A:SinReg B:SinReg C:Logistic Select 2:TwoVar x a1:a6 y b1:b6 No Enter ---- xbar = 3.5 mean of x ybar = 43. mean of y sigmax = 21. sum of x values sigmax^2 = 91. sum of x^2 values sigmay = 258. sum of y values sigmay^2 = 15906 sum of y^2 values sigmaxy = 1177 sum x*y values Sx=1.970829 x sample standard deviation Sy= 31.279386 y sample standard deviation nStat = 6 number of items minX = 1 minimum value of x minY =10 minimum value of y maxX = 6 maximum value of x maxY = 99 maximum value of y ------ Select a cell c1 F7:3 Variables > See list of variables select 1:xbar Enter Enter see 3.5 in c1 Note A:ox = 1.7071 population standard deviation of a column Note B:ox = 28.554 population standard deviation of b column --------- in a column Sample standard deviation = sqrt( (sum (x-xbar)^2 values)/n ) =Sy Population standard deviation = sqrt( (sum (x-xbar)^2 values)/(n-1) ) =oy o= lowercase signa Example mean of y= 43 b= (10-43)^2 + (22-43) + (31-43) + (44-43)^2+ (52-43)^2+ (99-43)^2= 4892 sqrt(b/6)= 28.55404 =oy sqrt(b/5)=31.279386 =Sy ------ F8 recalculate all selected cells ====== Plot example x| A | B | -------------- 1| 1. | 1. | -------------- 2| 2. | 4. | -------------- 3| 3. | 9. | -------------- 4| 4. | 16. | -------------- F2 1:Plot Setup 2:PlotsOff 3:FnOff In Plot Setup mode Menu F1:Define characteristics of plot F2:Copy characteristics to another plot number F3:Clear Clear plot characteristics F4 check to select and unselect a plot F5 ZoomData Plot with proper scale Select b1 a1^2 Enter Select b1 F3:3 Enter Initial formula =a1^2 Range b1:b4 Enter Enter See b column filled as above. Select b2 See =a^2 Select b3 See =a3^2 F2 Plot setup Enter See Plot menu F1 Plot Type 1:Scatter Mark Box xRange a1:a4 yRange b1:b4 No Enter Enter Back to Plot menu F5:ZoomData see plot