This page (revision-47) was last changed on 03-Feb-2023 15:21 by Roland B. Wassenberg 

This page was created on 23-Apr-2014 11:57 by Roland B. Wassenberg

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
47 03-Feb-2023 15:21 14 KB Roland B. Wassenberg to previous
46 02-Sep-2017 23:26 14 KB Roland B. Wassenberg to previous | to last
45 02-Sep-2017 22:35 13 KB Roland B. Wassenberg to previous | to last
43 02-Sep-2017 22:34 13 KB Roland B. Wassenberg to previous | to last Synapse SynCalc ==> SynCalc
44 02-Sep-2017 22:34 13 KB Roland B. Wassenberg to previous | to last Synapse SynCalc ==> SynCalc
42 11-May-2017 15:23 13 KB Roland B. Wassenberg to previous | to last
41 11-May-2017 15:18 13 KB Roland B. Wassenberg to previous | to last

Page References

Incoming links Outgoing links
SynCalc
SynCalc

Version management

Difference between version and

At line 1 changed one line
!!!Synapse SynCalc
!!!SynCalc Copyright (C) 1983, 1985 Synapse Software Corp. and Mike Silva
At line 3 added 26 lines
[{TableOfContents }]\\
\\
SynCalc from Synapse and programmed by Mike Silva is the(!) spreadsheet for the Atari 8 bit. No program of that kind reaches the performance SynCalc does.\\
\\
In 2016 Mike Silva gave SynCalc into public domain including source code! Mr. Silva, the Atari community is forever in your debt! Thank you so much, we really appreciate your help. You are now in the hall of fame.\\
\\
[{Image src='Thank_you_Mike_Silva.jpg' width=512 height=112 }]
Thank you Mike Silva!!!\\
\\
Further credit goes to Brian Lee, the product manager, who was very involved in guiding the look-and-feel and the overall functionality of the program. Thanky you so much Mr. Lee, we really appreciate your help, then and now. :-)\\
\\
Because the source code listing as well as the disk files are lost, it would be cool, if someone out there is in the possession of that, if you can share it with the community. Many thanks in advance. :-)\\
\\
Officially, 2 version were sold, one from 1983 and the other from 1985. Of course, there are others out there in the web, mostly patched and cracked ones.\\
Versions:\\
* 1983 Version, works with all models and Axlon (up to 256k) compatiable RAM expansions, ATX available
* 1985 Version, works with all models and Axlon (up to 256k) and XE (up to 64k) compatible RAM expansions, ATX available
* 1993 Version, works only with XL/XE models and XE (up to 256k) compatiable RAM expansions ATR available
!!1983 Version
The 1983 version was the first one, it had some bugs, but was and still is marvelous. The only bug we know is as follows:\\
if you have a value in the 255th line and insert one line more, the Atari crashes and your work is lost. In my opinion a bug we can live with. __If you have a bug-list of the 1983 version, please let us know. Your help is very much appreciated in this case.__
\\
!!1985 Version
The 1985 version should be free of bugs, further, it was sold with a template disk, please see below. This version uses extended RAM, if available. For example, in an Atari 130XE there is more than 80 KB RAM available. But the user has to take care, because the limit for storing data on diskette is 90 KB. __The goal should be, to create an atr-image for all Ataris (Classic, XL, XE) free of bugs and just limited to the installed RAM. Further, to get rid of the 90 KB data storage limit.__
\\
!!1993 Version
At line 4 changed one line
Versions
Appears to be based on the 1983 version. All "STA $CFFF" bank select statements are replaced by "JSR $0101", pointing to a small subroutine that maps the Axlon bank number to and XE bank in PORTB.
At line 6 changed 3 lines
* 1983 Version, not available yet
* 1985 Version, works will all models and Axlon and XE compatibale RAM expansions, ATX available
* 1993 Version, works only with XL/XE models and XE compatiable RAM expansion ATR available
||Port B |FF |EF|EB|E7|E3|AF|AB|A7|A3|8F|8B|87|83|FF|FF
||Model | 800/XL |130 XE |130 XE | 130 XE | 130 XE | RAMBO | RAMBO | RAMBO | RAMBO | RAMBO | RAMBO | RAMBO | RAMBO | n/a | n/a
|| Total RAM (k) | 48/64 |128 |128 | 128 | 128 | 192 | 192 | 192 | 192 | 256 | 256 | 256 | 256 | n/a | n/a
At line 10 changed one line
!1985 Version
See also [http://atariage.com/forums/topic/208094-who-can-crack-this-one].
!!Manuals
* [SynCalc-1983 Version|Synapse_SynCalc_1983.pdf] ; size: 7,6 MB
* [SynCalc-1985 Version|Synapse_SynCalc_1985.pdf] ; size: 13,3 MB
* [SynCalc Template Disk|SynCalc_Template_Disk_Synapse.pdf] ; size: 8 MB
!!ATR images
* [SynCalc_(1983)(Synapse Software)(US).atx] ; atx-image of the 1983 version which runs properly, icluding the VisiCalc import program, which is missed on nearly all(!) versions
* [SynCalc_(1985)(Synapse Software)(US).atx] ; atx-image of the 1985 version which runs properly, icluding the VisiCalc import program, which is missed on nearly all(!) versions
* [SynCalc 128K atx-version|SynCalc_128K_(1985).atx] ; atx-image which runs on Altirra, but not with the Atari800MacX emulator (2016)
* [SynCalc 128K atr-version|SynCalc_128K_(1993).atr] ; atr-image which runs on all emulators, but not verified yet regarding reliable calculations
* [SynCalc Template Disk|Syncalc_Template_(original).atr] ; atr-image from the original diskette
* [SynCalc Data Disk.atr|SynCalc_Data_Disk.atr] ; atr-image with some examples and templates
At line 49 added 6 lines
* [SynCalc Classic for 400-800 Ataris|SynCalc_(Classic).atr] ; not yet tested, use on your own risk
* [SynCalc for XL-XE-Ataris|SynCalc_(XL-XE).atr] ; not yet tested, use on your own risk
* [SynCalc with OSS DOS XL 2.30 as file version|SynCalc_with_OSS_DOS_XL_2.30.atr] ; not yet tested, use on your own risk
!!RAW files from the Kryoflux
* [Kryoflux-raw-no-flippy.zip] ; size: 22.9 MB ; A very big thank you goes to Freddy Offenga for creating the raw files from our original SynCalc 128K diskette. Freddy, great work! Thank you so much! :-)
!!RAM configuration; findings from JAC! from AtariAge
At line 28 changed 17 lines
|| Hardware || Base RAM || Expansion || Free Memory in 1985 Version || Free Memory in 1993 Version
| Atari 800 | 48k | none | 21k | n/a
| Atari 800 | 52k | none | 25k | n/a
| Atari 800 | 48k | 64k Axlon | 69k | n/a
| Atari 800 | 48k | 128k Axlon | 133k | n/a
| Atari 800 | 48k | 256k Axlon | 245k | n/a
| Atari 800 | 48k | 512k Axlon | 245k | n/a
| Atari 800 | 48k | 1024k Axlon | 245k | n/a
| Atari 800 | 48k | 2048k Axlon | 245k | n/a
| Atari 800 | 48k | 4096k Axlon | 245k | n/a
| Atari 800 XL | 64k | none | 21k | 21k
| Atari 800 XL | 64k | 256k Rambo | 84k | 213k
| Atari 800 XL | 64k | 256k Compy | 84k | 149k
| Atari 800 XL | 64k | 512k Rambo | 84k | 213k
| Atari 800 XL | 64k | 512k Compy | 84k | 149k
| Atari 800 XL | 64k | 1024k Rambo | 84k | 213k
| Atari 130 XE | 64k | 64k Atari | 84k | 85k
|| Hardware || Base RAM || Expansion || Free Memory in 1983 Version || Free Memory in 1985 Version || Free Memory in 1993 Version
| Atari 800 | 48k | none | 21k | 21k | n/a
| Atari 800 | 52k | none | 25k | 25k | n/a
| Atari 800 | 48k | 64k Axlon | 69k | 69k | n/a
| Atari 800 | 48k | 128k Axlon | 133k | 133k | n/a
| Atari 800 | 48k | 256k Axlon | 245k | 245k | n/a
| Atari 800 | 48k | 512k Axlon | 245k | 245k | n/a
| Atari 800 | 48k | 1024k Axlon | 245k | 245k | n/a
| Atari 800 | 48k | 2048k Axlon | 245k | 245k | n/a
| Atari 800 | 48k | 4096k Axlon | 245k | 245k | n/a
| Atari 800 XL | 64k | none | 21k | 21k | 21k
| Atari 800 XL | 64k | 256k Rambo | 21k | 84k | 213k
| Atari 800 XL | 64k | 256k Compy | 21k | 84k | 149k
| Atari 800 XL | 64k | 512k Rambo | 21k | 84k | 213k
| Atari 800 XL | 64k | 512k Compy | 21k | 84k | 149k
| Atari 800 XL | 64k | 1024k Rambo | 21k | 84k | 213k
| Atari 130 XE | 64k | 64k Atari | 21k | 84k | 85k
At line 120 added 150 lines
!!Findings from Mike Silva:
Zero page\\
\\
$95 Current Spreadsheet Row (all rows and columns are zero-based)\\
$96 Current Spreadsheet Column\\
\\
$99 Current Screen Y\\
$9A Current Screen X\\
\\
$9F Current Cell Data Pointer (points to data of current cell)\\
\\
$A7 Last Spreadsheet Row\\
$A8 Last Spreadsheet Column\\
\\
$CA Last Added Cell Data Pointer (a stack pointer to next free memory to add new cell data) More below #1\\
\\
Non-zero page\\
\\
$1901 Array of column widths\\
\\
$19DB Last direction of cursor movement (1=left, 2=right, 3=up, 4=down)\\
\\
$1A00 Screen memory\\
\\
$2BF3 Array of 3-byte cell structures. Each structure consists of a 2-byte cell data address, followed by one additional byte (more below #2). Array order is A1, B1, C1,...n1, A2, B2, C2,...n2,...Am, Bm, Cm,...nm where n is last sheet column, m is last sheet row.\\
\\
#1 Cell data is form B1, B2, B3, cell data (variable number of cell data bytes).\\
B1: D7-D6 = number format code\\
D5 = comma flag\\
D4 = dollar flag\\
D3 = percent flag\\
D2 = ??? haven't figured this one out\\
D1-D0 = sign code\\
B2: D7-D6 = justify code\\
D5-D4 = ??? haven't figured this one out\\
D3 = protect value flag\\
D2-D0 = margin value 0-7\\
B3: D7 = protect entry flag\\
D6-D0 = length of cell data that follows\\
\\
Cell data is either text or ATARI numeric. In formula cells the value of the formula is first, followed by the actual formula.\\
\\
#2 Additional cell info byte\\
D7-D6 = cell type (01 = text, 10 = numeric, 00 = empty cell?)\\
D5-D2 = precision value\\
D1-D0 = ???\\
\\
The cell data stack grows downward from $7FFF on a 48k machine. By testing other hardware it will be possible to see where the stack begins in different memory circumstances, and also perhaps to ID some other addressing bits in the cell pointer array, bits that are just zero in the base 48k version.\\
!!Problems when importing VisiCalc files ; findings from luckybuck
SynCalc holds an import program, called: 'VC->SC' in order to read in files from the VisiCalc program. All versions(!) out there, except the original ones are not able to import properly VisiCalc files! The SynCalc program tries to load a convert program from the original program disk. If this fails, you get the following pictures:
[{Image src='1.jpg' width=330 height=200 }]
SynCalc VC->SC option selected\\
\\
[{Image src='2.jpg' width=332 height=202 }]
SynCalc asking for the program master disk\\
\\
[{Image src='3_.jpg' width=333 height=201 }]
SynCalc failed to load a program from the program master disk\\
\\
Further, if you have really hard VisiCalc spreadsheets and the 1985 version even in original form fails to import, try the 1983 version, which works like a charm in these very rare cases.
!!Private Notes from JAC! in German
Syncalc werde ich mir irgendwann nochmal im Detail anschauen, aber das braucht Zeit.\\
So wie ich das ganze sehe, was SyncCalc im Original eine XEX die von Synapse auf\\
einen DOS Disk mit einem entsprechenden DOS gepackt und dann verschlüsselt wurde.\\
Die Boot-Disk packt das DOS dann sozusagen wieder aus.\\
Nur so kann sie nach dem Booten Files von den Datendisk lesen.\\
!!Emulator Hints
In emulators it could be useful to turn the SIO patch off for using the ".ATX" disk images.\\[{Image src='SIO.jpg' width=387 height=146 }]
!!File types
The program disk itself has a hidden VTOC and is heavily copy protected. A really hard one, even in todays times. SynCalc saves produces three types of files (syntaxes):\\
a) SC for worksheets\\
b) DIF for data interchange files (or values)\\
c) TXT for reporting\\
Thank you Wade Ripdubski for finding out and sharing your knowledge with us. :-)))\\
[{Image src='files.png' width=300 height=235 }]
SynCalc file syntax\\
\\
[{Image src='rating.png' width=300 height=34 }]
SynCalc rating from Wade Ripdubski (InverseATASCII). AtariWiki fully admits that rating. Mike Silva has done a men's jpb. Shaft's score would be a 10 out of 10.\\
Please also take a look at Wade's site: [SynCalc at InverseATASCII|http://inverseatascii.info/2016/02/23/s2e08-synapse-software-syncalc/] ; highly recommended!\\
!!References
[Synapse Wiki|https://en.wikipedia.org/wiki/Synapse_Software]\\
[Br0derbund Wiki|https://en.wikipedia.org/wiki/Brøderbund]\\
[SynCalc at InverseATASCII|http://inverseatascii.info/2016/02/23/s2e08-synapse-software-syncalc/]\\
!!Video
* [Commercial video with Alan Alda about SynCalc from Atarimania|atari_8bit_synapse_software_alan_alda_commercial.flv] ; a big thank you to Atarimania ; funny to watch! :-)
!!Images
[{Image src='1Startscreen.gif' width=336 height=240 }]
SynCalc startscreen ; thanks to Atarimania\\
\\
[{Image src='2Start.gif' width=336 height=240 }]
SynCalc start of program ; thanks to Atarimania\\
\\
[{Image src='3popup.gif' width=336 height=240 }]
SynCalc pop up window ; thanks to Atarimania\\
\\
[{Image src='SynCalc_requires_48k_of_RAM.jpg' width=329 height=198 }]
SynCalc requires 48k of RAM and all cartridges removed\\
\\
[{Image src='max.jpg' width=361 height=226 }]
Maximum RAM in KB available for SynCalc regardless how many is installed\\
\\
[{Image src='Synapse_Syncalc_with_128K.jpg' width=911 height=173 }]
Synapse Syncalc with 128 KB RAM startscreen with 85 KB RAM free\\
\\
[{Image src='RAM-Vertelung_markiert.jpg' width=1104 height=663 }]
Synapse Syncalc with different machines and different free RAM\\
\\
[{Image src='1983-1.jpg' width=353 height=463 }]
SynCalc 1983 version-front of box ; thanks to Atarimania\\
\\
[{Image src='1983-2.jpg' width=353 height=458 }]
SynCalc 1983 version-back of box ; thanks to Atarimania\\
\\
[{Image src='1983-3.jpg' width=422 height=396 }]
SynCalc 1983 version-diskette ; thanks to Atarimania\\
\\
[{Image src='SynCalc_128K-1.jpg' width=711 height=828 }]
SynCalc 1985 version-front of box\\
\\
[{Image src='SynCalc_128K-2.jpg' width=738 height=821 }]
SynCalc 1985 version-back of box\\
\\
[{Image src='SynCalc_128K-3.jpg' width=938 height=459 }]
SynCalc 1985 version-side of box\\
\\
[{Image src='templates1.jpg' width=600 height=774 }]
SynCalc Template Diskette - image 1 ; thanks to Atarimania\\
\\
[{Image src='templates2.jpg' width=600 height=781 }]
SynCalc Template Diskette - image 2 ; thanks to Atarimania\\
\\
[{Image src='SynCalc_Templates_Disk_5.jpg' width=800 height=600 }]
SynCalc Template Diskette - image 3 ; thanks to RHOD\\
\\
[{Image src='SynCalc_Templates_Disk_4.jpg' width=317 height=657 }]
SynCalc Template Diskette - ad 1\\
\\
[{Image src='SynCalc_Templates_Disk_3.jpg' width=416 height=591 }]
SynCalc Template Diskette - ad 2\\
\\
[{Image src='syncalc_1985_ad.jpg' width=638 height=826 }]
SynCalc ad ; thanks to Atarimania\\
\\
[{Image src='ad.jpg' width=900 height=675 }]
SynCalc ad from eBay
This page (revision-47) was last changed on 03-Feb-2023 15:21 by Roland B. Wassenberg  Top