HP35s Program Logger (sort of)



#4

Well, this is not quite the program logger I wanted to write, but my programming days are long past. Instead, I created an Excel spreadsheet that automatically creates line numbering. Changing a LBL variable will change the line accordingly. You can also leave a space between programs for easier reading. The spreadsheet allows for 100 lines of program (I can make it longer if needed, or just use a new page for larger programs.) Enter program commands in the "Command" column beginning with the LBL command.

Not sure if anyone will find it useful, but it was a good self-test on creating Excel functions to do this.

If the formatting of the line number isn't the same as in the graphic, let me know, and I'll fix it (or tell you how). Here's what it will look like.

HP35s Logger Spreadsheet

CHUCK


#5

Hey Chuck, that's pretty clever! Good job.

#6

Chuck, thanks for your effort, I found it useful. Not being able to leave well enough alone, I considered what improvements might be desirable. In addition to auto-numbering, it would be nice to find a way to keep track of the jump start points and the targets. A column for comments would also be handy. With these concepts in mind, I took the liberty of modifying your workbook. Here is a screenshot of what I came up with:

The workbook looks for and sequentially numbers the GTO and XEQ commands, placing a sequence number in the “Start” column. It also changes the font color to green. You have to manually enter the sequence numbers in the “Target” column at the target line, and then the font color is changed to red. To insert a program step or steps, I have not found a better way than to copy everything in columns D, E, F, and G below the line where you want to insert down one or more lines. Then type the new instruction(s) in the newly created line(s). The jump starts and targets have to be manually reviewed and edited as required. Extra care must be taken if a new jump start is inserted between two existing ones as that will change the sequence numbers of all jump starts after the new jump instruction, so the sequence numbers of their targets will no longer match. (Automating the insertion and jump tracking and editing process would be very helpful, of course, but so far I haven’t tried to tackle that.)

Here is the workbook if you are interested....


Possibly Related Threads...
Thread Author Replies Views Last Post
  HP35s Program Four Slings Lift Calculation Jean-Marc Biram (Australia) 2 1,113 12-16-2013, 07:21 PM
Last Post: Jean-Marc Biram (Australia)
  HP35s Calculator Max Rope Tension Program Jean-Marc Biram (Australia) 10 2,232 12-12-2013, 12:03 AM
Last Post: Jean-Marc Biram (Australia)
  HP Prime: run a program in another program Davi Ribeiro de Oliveira 6 1,234 11-11-2013, 08:28 PM
Last Post: Davi Ribeiro de Oliveira
  Rearanging the "Fixed" sort order of Prime's Apps icons Joe Horn 3 830 10-02-2013, 10:24 AM
Last Post: Han
  Trouble entering a HP35s program line Arno 2 771 04-05-2013, 06:28 PM
Last Post: Arno
  HP35s scientific calculator GREG W THOMAS 4 920 03-22-2013, 06:49 AM
Last Post: Thomas Radtke
  HP35s "MEMORY CLEAR" flashes Mark Paris 1 620 08-31-2012, 07:35 PM
Last Post: Bart (UK)
  HP35S keyboard Nick R 8 1,352 08-01-2012, 01:27 PM
Last Post: Dave Shaffer (Arizona)
  Where should I post new HP35s bugs Andres Capdevila 33 3,799 03-13-2012, 01:00 PM
Last Post: Jeff O.
  HP35s Internal Investigations - new processor? stefan 5 1,040 03-08-2012, 04:48 AM
Last Post: Paul Dale

Forum Jump: