HP35s Program Logger (sort of)


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



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


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 2,208 12-16-2013, 07:21 PM
Last Post: Jean-Marc Biram (Australia)
  HP35s Calculator Max Rope Tension Program Jean-Marc Biram (Australia) 10 4,377 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 2,699 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 1,721 10-02-2013, 10:24 AM
Last Post: Han
  Trouble entering a HP35s program line Arno 2 1,536 04-05-2013, 06:28 PM
Last Post: Arno
  HP35s scientific calculator GREG W THOMAS 4 1,913 03-22-2013, 06:49 AM
Last Post: Thomas Radtke
  HP35s "MEMORY CLEAR" flashes Mark Paris 1 1,489 08-31-2012, 07:35 PM
Last Post: Bart (UK)
  HP35S keyboard Nick R 8 2,808 08-01-2012, 01:27 PM
Last Post: Dave Shaffer (Arizona)
  Where should I post new HP35s bugs Andres Capdevila 33 9,335 03-13-2012, 01:00 PM
Last Post: Jeff O.
  HP35s Internal Investigations - new processor? stefan 5 2,069 03-08-2012, 04:48 AM
Last Post: Paul Dale

Forum Jump: