Category:Saturn Calc - Revision history

Mark at 15:26, 12 June 2026

2026-06-12T15:26:44Z

← Older revision		Revision as of 15:26, 12 June 2026
Line 108:		Line 108:

	There are two issues when using Saturn Calc.		There are two issues when using Saturn Calc.
⚫	Saturn software doesn't understand named directories so you should be in a UIC based directory when you use it. If you are in a named directory it will look for files in your protection UIC.

		⚫	Saturn software doesn't understand RSX11M+ named directories so you should be in a UIC based directory when you use it. If you are in a named directory it will look for files in your protection UIC. This does not matter in RSX11M as the SET /UIC=[g,m] sets both the default directory and protection together.
⚫	The second problem involves functions that can input a range of cells like SUM, AVG, STD, STDE, MIN or MAX. When cells contain numeric values input from the keyboard, these functions work fine e.g. SUM(C1:C10). However if C1:C10 values contained calculations like A1\B1, the C1 cell would show the correct value but a function using the range would see 0 in the cells. C1+C2+C3...+C10 would calculate a correct sum however. I came up with a work around that can be used if one really needs that functionality across ranges. See SUMFIX.DOC in the distribution for detailed info on this topic. Also, SUMFIX.CAL is a spreadsheet that illustrates the issue and the work around for it.dir dl1:vector.lst;\

		⚫	The second problem involves functions that can input a range of cells like SUM, AVG, STD, STDE, MIN or MAX. When cells contain numeric values input from the keyboard, these functions work fine e.g. SUM(C1:C10). However if C1:C10 values contained calculations like A1\*B1, the C1 cell would show the correct value but a function using the range would see 0 in the cells. C1+C2+C3...+C10 would calculate a correct sum however. I came up with a work around that can be used if one really needs that functionality across ranges. See SUMFIX.DOC in the distribution for detailed info on this topic. Also, SUMFIX.CAL is a spreadsheet that illustrates the issue and the work around for it.

Mark at 03:19, 10 June 2026

2026-06-10T03:19:15Z

← Older revision		Revision as of 03:19, 10 June 2026
Line 28:		Line 28:
	B BLANK M MOVE T TITLES		B BLANK M MOVE T TITLES
	C COPY N NAME V VALUES		C COPY N NAME V VALUES
	D DELETE O ORDER (SORT). W WINDOWS		D DELETE O ORDER (SORT) W WINDOWS
	E EDIT P PRINT X EXIT		E EDIT P PRINT X EXIT
	F FORMAT R REWRAP TEXT Z ZAP		F FORMAT R REWRAP TEXT Z ZAP

Mark at 03:18, 10 June 2026

2026-06-10T03:18:51Z

← Older revision		Revision as of 03:18, 10 June 2026
Line 24:		Line 24:

	Pressing <PF4> or <CTRL> and <nowiki><U> cancels a command before it is implemented.</nowiki>		Pressing <PF4> or <CTRL> and <nowiki><U> cancels a command before it is implemented.</nowiki>
			<tt><pre>

	A APPLY FORMULA I INSERT S STORAGE		A APPLY FORMULA I INSERT S STORAGE
		⚫	B BLANK M MOVE T TITLES

	B ~~BLANK~~ ~~M MOVE~~ T ~~TITLES~~		C COPY N NAME V VALUES
		⚫	D DELETE O ORDER (SORT). W WINDOWS

	C ~~COPY~~ ~~N NAME~~ V ~~VALUES~~		E EDIT P PRINT X EXIT
		⚫	F FORMAT R REWRAP TEXT Z ZAP

⚫	D DELETE O ORDER (SORT) W WINDOWS

⚫	E ~~EDIT~~ ~~P PRINT~~ ~~X EXIT~~

⚫	F FORMAT R REWRAP TEXT Z ZAP

	G GLOBAL		G GLOBAL
			</pre></tt>

	One difference from Lotus 1-2-3 is that the spreadsheet results are not calculated until you request it with ! or , These two characters are commands to recalculate the spreadsheet. This saves lots of CPU cycles for the PDP-11. Also, the calculations can run left to right row by row or left to right column by column. Sometimes a cell in for example column C use a value from column F that is not yet calculated. Hitting ! a second time is necessary in that case. Also, the number of recalculation cycles can be set by a global value as can the order of calculations.		One difference from Lotus 1-2-3 is that the spreadsheet results are not calculated until you request it with ! or , These two characters are commands to recalculate the spreadsheet. This saves lots of CPU cycles for the PDP-11. Also, the calculations can run left to right row by row or left to right column by column. Sometimes a cell in for example column C use a value from column F that is not yet calculated. Hitting ! a second time is necessary in that case. Also, the number of recalculation cycles can be set by a global value as can the order of calculations.

Mark: Added info from help

2026-06-10T02:43:52Z

Added info from help

@@ Line 3: / Line 3: @@
 [[File:Functions.jpg.jpg|thumb|Functions List from Calc Help]]
 <big> Overview of Saturn Calc </big>
@@ Line 8: / Line 9: @@
 Command (A,B,C,D,E,F,G,I,M,N,O,P,R,S,T,V,W,X,Z,?):
 One difference from Lotus 1-2-3 is that the spreadsheet results are not calculated until you request it with ! or , These two characters are commands to recalculate the spreadsheet. This saves lots of CPU cycles for the PDP-11. Also, the calculations can run left to right row by row or left to right column by column. Sometimes a cell in for example column C use a value from column F that is not yet calculated. Hitting ! a second time is necessary in that case. Also, the number of recalculation cycles can be set by a global value as can the order of calculations.
@@ Line 29: / Line 48: @@
 Then use EDT to view the .CCL file and it is pretty easy to see how a spreadsheet could be created by BASIC or FORTRAN. The / S C filename.ccl will execute the comand file and build the spreadsheet.
 CCL files can also have loops, if statements, and other elements of a programming language. It is possible to have a spreadsheet model, then use a command file to drive input values through a range and record the results of the model with the various inputs.

Mark: Added three images

2026-06-10T02:31:03Z

Added three images

← Older revision		Revision as of 02:31, 10 June 2026
Line 1:		Line 1:
	[[File:Ballistic.jpg\|thumb\|Ballistic Trajectory spreadsheet in Saturn Calc]]		[[File:Ballistic.jpg\|thumb\|Ballistic Trajectory spreadsheet in Saturn Calc]]
	[[File:Bench.png\|thumb\|Various Benchmarks for PDP-11s and VAXes]]		[[File:Bench.png\|thumb\|Various Benchmarks for PDP-11s and VAXes]]
			[[File:Functions.jpg.jpg\|thumb\|Functions List from Calc Help]]
	<big> Overview of Saturn Calc </big>		<big> Overview of Saturn Calc </big>

Mark at 02:28, 10 June 2026

2026-06-10T02:28:52Z

← Older revision		Revision as of 02:28, 10 June 2026
Line 1:		Line 1:
	[[File:Ballistic.jpg\|thumb\|Ballistic Trajectory spreadsheet in Saturn Calc]]		[[File:Ballistic.jpg\|thumb\|Ballistic Trajectory spreadsheet in Saturn Calc]]
			[[File:Bench.png\|thumb\|Various Benchmarks for PDP-11s and VAXes]]
	<big> Overview of Saturn Calc </big>		<big> Overview of Saturn Calc </big>

Mark at 02:25, 10 June 2026

2026-06-10T02:25:41Z

← Older revision		Revision as of 02:25, 10 June 2026
Line 1:		Line 1:
	[[File:Ballistic.jpg\|thumb]]		[[File:Ballistic.jpg\|thumb\|Ballistic Trajectory spreadsheet in Saturn Calc]]
	<big> Overview of Saturn Calc </big>		<big> Overview of Saturn Calc </big>

Mark at 02:17, 10 June 2026

2026-06-10T02:17:50Z

← Older revision		Revision as of 02:17, 10 June 2026
Line 1:		Line 1:
			[[File:Ballistic.jpg\|thumb]]
	<big> Overview of Saturn Calc </big>		<big> Overview of Saturn Calc </big>

Mark at 23:11, 9 June 2026

2026-06-09T23:11:22Z

← Older revision		Revision as of 23:11, 9 June 2026
Line 93:		Line 93:

	The second problem involves functions that can input a range of cells like SUM, AVG, STD, STDE, MIN or MAX. When cells contain numeric values input from the keyboard, these functions work fine e.g. SUM(C1:C10). However if C1:C10 values contained calculations like A1\B1, the C1 cell would show the correct value but a function using the range would see 0 in the cells. C1+C2+C3...+C10 would calculate a correct sum however. I came up with a work around that can be used if one really needs that functionality across ranges. See SUMFIX.DOC in the distribution for detailed info on this topic. Also, SUMFIX.CAL is a spreadsheet that illustrates the issue and the work around for it.dir dl1:vector.lst;\		The second problem involves functions that can input a range of cells like SUM, AVG, STD, STDE, MIN or MAX. When cells contain numeric values input from the keyboard, these functions work fine e.g. SUM(C1:C10). However if C1:C10 values contained calculations like A1\B1, the C1 cell would show the correct value but a function using the range would see 0 in the cells. C1+C2+C3...+C10 would calculate a correct sum however. I came up with a work around that can be used if one really needs that functionality across ranges. See SUMFIX.DOC in the distribution for detailed info on this topic. Also, SUMFIX.CAL is a spreadsheet that illustrates the issue and the work around for it.dir dl1:vector.lst;\

Mark at 23:09, 9 June 2026

2026-06-09T23:09:39Z

← Older revision		Revision as of 23:09, 9 June 2026
Line 93:		Line 93:

	The second problem involves functions that can input a range of cells like SUM, AVG, STD, STDE, MIN or MAX. When cells contain numeric values input from the keyboard, these functions work fine e.g. SUM(C1:C10). However if C1:C10 values contained calculations like A1\B1, the C1 cell would show the correct value but a function using the range would see 0 in the cells. C1+C2+C3...+C10 would calculate a correct sum however. I came up with a work around that can be used if one really needs that functionality across ranges. See SUMFIX.DOC in the distribution for detailed info on this topic. Also, SUMFIX.CAL is a spreadsheet that illustrates the issue and the work around for it.dir dl1:vector.lst;\		The second problem involves functions that can input a range of cells like SUM, AVG, STD, STDE, MIN or MAX. When cells contain numeric values input from the keyboard, these functions work fine e.g. SUM(C1:C10). However if C1:C10 values contained calculations like A1\B1, the C1 cell would show the correct value but a function using the range would see 0 in the cells. C1+C2+C3...+C10 would calculate a correct sum however. I came up with a work around that can be used if one really needs that functionality across ranges. See SUMFIX.DOC in the distribution for detailed info on this topic. Also, SUMFIX.CAL is a spreadsheet that illustrates the issue and the work around for it.dir dl1:vector.lst;\



			[[Category:Saturn Software]]
			[[Category:Saturn Graph]]
			[[Category:Downloads]]
			[[Category:Documentation]]