
Dear Ed,
Your “View of Vu-Calc” in the October issue was helpful to my understanding of this (Timex) program, but as you may have discovered by know, there was a serious flaw in the example which led to an erroneous conclusioon. Your example called for formulae in boxes B5 through G5 which required data from box G4. Box G4 also contains a formula rather than data and since Vu-Calc computes by row from left to right starting from row A and then going down row by row, the numeric data required for the formulae in boxes B5 through F5 will not exist and an error report C/5110 results.
This didn’t happen with your example, possibly because box G4 contained old data as a result of the step by step way you built up the example, but it will happen when you start with only the raw data.
The Vu-Calc instructions tell you on page 6 to be sure that data required by the formula in a given box, be computed before reaching that box, i.e. in any row above the box on the left of the box in the same row.
This problem also led you to conclude that Vu-Calc didn’t compute the whole table at once because some of your data didn’t change when you thought it should. That was evidently because it was still working with the old values. In fact Vu-Calc does compute the whole table at once as I verified by scattering formulae all over the table and observing the results change as I changed the input data and then executed the calculate mode. I’m certainly glad it does, because as you pointed out, it would be very inconvenient if it didn’t.
Your example can be restructured to obey the Vu-Calc rules by simply interchanging the rows and columns. Then it works perfectly.
The program also has a simpler way to mix relative and absolute parts in a formula as discovered on page 5 of the instructions. You refix the parts that are to be absolute with a <$> when typing in the formula and then choose the relative option as usual to make the other parts relative. This saves having to type in all the formulae individually as you did in your example.
There is one part of the instructions, also on page 5, that I don’t understand. The statement is that “you may use up to 40 formulae ….”. That seemed to me to be a terrible limitatation and to test it, I put in about 50 formulae. They all worked perfectly – so I don’t know if this is a typo (400 allowed) or refers to something I don’t understand.
Do you have any information on this?
Sincerely,
Bob Keyser – Encinitas, CA
Read the letter from the following subscriber – Ed.
Dear Ed,
There is a “glaring weakness” in your review of Vu-Calc in the October issue. On page 17 under the heading “Changing Data”, paragraph 2 states the data in box 02 has not changed. That is because this column references box G04 which has not yet been calculated.
Page 6 of the instruction sheet provided with the tape, clearly warns against this error. Calculations start at the home square and proceed horizontally along row A, then down to row B, etc.
You missed what I consider the most glaring weakness of the program. The instructions state “You may use up to 40 formulae —“. This apparently means you can press the <F> key to enter a formula up to a maximum of 40 times. After that, you reach an unrecoverable error condition that will not allow you to enter any more formulae. Deleting formulae in the boxes will not allow you to recover from this condition. This happens without warning. If you are using formulae to load data into the boxes, this condition can be reached very quickly.
Other than this, I generally agree with your review (except that the dash between the box co-ordinates in the sample formula is a minus sign). I would like to see more reviews in Synchro-Sette.
Yours Truly,
D.V. Carville
Sperry Univac FSD
New York
Thank you both for your insight in proper use of Vu-Calc and especially for clearing up the data changing format mistake.
Mr. Carville says that after the 40th formula is entered, an unrecoverable error condition occurs where no more formula can be entered and deleting previously entered formula does not help.
Mr. Keyser says that he has entered 50 formulae and they all worked perfectly. Does the 40 maximum refer to individually entered formulae, replicated formulae or both. Who is right?
In regard to Mr. Carville’s comment regarding the dash being a minus sign in the Vu-Calc sample, this to me was one of the most “glaring weaknesses” in the Vu-Calc documentation. The dash looks more like a dot and there is no immediate reference that this dash (dot) is to be a logical operator to perform subtraction. Also, the logical operators for addition, subtraction, multiplication and division should have been shown and explained or at least commented on in the command summary on page 8 of the documentation.
Most people have no idea how many of the subscribers had purchased Vu-Calc and didn’t know what to do with it or how to use it until the October article appeared. The most common complaint was the in-ability to understand the documentation and particularly how to enter formulae. The second most common complaint was how to duplicate or replicate formulae.
For those of us who have had experience with Visa-Calc type programs on more expensive computers, Vu-Calc was pretty much second nature and even redundant. All I ask is that we don’t make the mistake of assuming the all the readers have the same knowledge we do and write things based on this assumption. I have made this mistake more than once in other areas and will probably make it again. I encourage any chastisement that I deserve from you readers (keep the letters clean, though) – Ed.
Dear Fred (I think he meant Ed)
I received the Sinclair and Mindware printers within a week of each other and I like both. My Sinclair printer also needs a prompt to get the paper to feed (annoying but liveable) and like you, I haven’t tried to adjust it yet.
I am now sending for some paper from:
E. Alvarez
PO BOX 1025
Oviedo, FL, 32765
which is supposed to have a whiter background for better contrast (graphics on Sinclair’s printer leave a lot to be desired).
Mindware’s printer is great. It’s just too bad it doesn’t use wider paper. The ribbon cartridge from Radio Shack is part # 26-3507. By using packing label tape in the MW-100 for mailing labels, you don’t even need to use glue – just lick the back and stick em on.
Your “FILE” OCT/82 program is about the best I’ve seen. By adding:
2375 IF Y$="C" THEN COPY
and using the MW-100, it’s hard to beat for mailing lists.
I picked up a Diskwasher Competition Joystick and with small wire and one cut inside, it works great on my ZX-81.
You mag is terrific – I just wish they came faster. Keep up the good work.
Jake Breil – Cypress, CA
Dear Jake,
Thanks for the kind words and information. The only problem I have with the print-outs of both printers is that they are extremely hard for the printer to make good proofs from. The grey backgound of the aluminized paper on the Sinclair printer and the blue ink on the cartridge of the MW-100 are awfully hard for printing proof cameras to pick up.
I find that I am not alone with the problem of having to pull the paper on the Sinclair printer – a few other people have written me with the same situation.
I purchased the Radio Shack cartridge which has black ink and it printed out very light. It might have been an old ribbon that was partially dried out.
Bob DeLisle of Hammond Indiana sent me some sample copies made with the CAI printer on a white background aluminized paper. The graphics are superb and all characters are easily read. The copy is however, also very light. Whether this is the same type of paper that Alvarez sells, I don’t know.
The MW-100 gives the most readable copy I have seen to date – Ed.
Dear Ed,
My main reason for writing is to ask you to put a LPRINT option in your future ‘menus’. Maybe there is an easy way to do it but I haven’t stumbled on it yet – some of us do have printers, don’t forget!
I, for one would like to see more business/home programs & fewer games. The business/home programs are much more fun for me.
D.A. Potts MD – Independence, MO
Dear D.A.,
When the programs that could use print-out were written, most people hadn’t even seen a printer yet. We intend to use the print-out capability in future programs.
In the meantime, you are left with 3 options to convert existing programs to print. The first is for listing programs which uses the LLIST command of which you are probably aware of already.
The second is to use the COPY command in a program line. Keep in mind that this command will copy whatever is on the screen – even blank spaces and lines. If you write a routine such as:
1000 INPUT A$
1010 CLS
1020 PRINT A$
1030 COPY
the data you input for A$ will appear at the top of the screen and the printer will copy it to paper along with all the blank lines below it.
The third procedure, which is probably the most useful, is to use the LPRINT command. This command allows formatting of the print-out to paper. A sample program to demonstrate this would be:
10 SCROLL
20 PRINT "ENTER NAME?"
30 INPUT N$
40 SCROLL
50 PRINT "ENTER TAB?"
60 INPUT T
70 SCROLL
80 LPRINT TAB T;N$
90 GOTO 10
Play around with this program and try to become familiar with how the print-out can be formatted anywhere on the paper. In almost all programs, it would only require the entry of lines using a format like line 80 uses in this program.
One odd thing I’ve noticed is that if the last data printed on the screen is at the bottom-most available line position, LPRINT won’t work. The computer treats it as a PRINT command and gives a screen full error even though nothing extra is added to the screen. Delete line 70 from the sample and you can observe this
As far as business/home vs. games programs, I’m sure if I changed the ratio, I would here complaints from the other end. We will continue to try to have some of each – Ed.
Dear Ed,
Will use of a mini-drive for the TS-1000 allow one to input data independently of the program? More importantly, do you foresee any possibility of being able to utilize one set of data in more than one program by being able to access that data from an independent source (another tape recorder or disk drive) or will one be forever destined to duplicate the data each time it is needed for additional programs.
Also, is there any way that you know of where two programs can be chained together so that a common set of data can be used assuming that it is not possible to introduce data independently of a program?
Let me just say that this beginner is ever and eternally grateful to you and all those involved in reaching out to us in such a friendly, scholarly, enthusiastic and helpful way. Although most of us will always be clamoring for “more, more, more!” — we will all be quite satisfied and grateful for whatever bounties we receive.
Beatrice Spencer
St. Thomas, Virgin Islands
Dear Bea,
I am sorry that I couldn’t print your whole letter with all of the questions but in regard to separating data from a program.
There is a utility program that allows data to be stored on tape separate from the program. It uses only 500 bytes of memory and can be used on a 2K machine. It sells for 17.00 (1.50 postage & handling – CA res. add 6% or 6.5% sales tax) and is available from:
Cosmonics
PO BOX 10358
San Jose, CA, 95157
Otherwise, separate disk drives or recorders won’t solve your problem.
As far as chaining programs are concerned, I’m sure it is possible and would require another utility program which I have seen for other computers but not for the Sinclair. Even if one did exist, I’m not sure that after the programs were merged, the variables would still be intact.
If any readers out there are aware of or have had any experience in this area, please let us know – Ed.
Does anyone have an old ZX-80 manual that they don’t need? Please let me know and how much you want for it (cash, trade for software, etc.) – Ed.