07-31-2021, 04:22 AM
This article is a follow up of the forum thread: FRAM71 : Configuration Spreadsheet [2021-01-31]
Preamble
Daniel Simpson is the original instigator of the FRAM71 configuration spreadsheet project. As he was thinking to drop his project, I took his idea and decided to give it a shot. The major difficulty when doing this kind of problem with a spreadsheet, is to have formulas that can validate the integrity at all levels (chip, module and FRAM71/B unit). I have done several implementation of the spreadsheet between January 2021 and July 2021, all of them had chip level integrity, but until this one, all completely or partially failed at module level and/or at FRAM71 unit.
FRAM71/B User's Manuals:
Slides used for the configuration spreadsheet presentation done at the HPCC 2021 mini-conference virtually held on October 23, 2021
Introduction
The goal of this spreadsheet is to create safe FRAM71/B module configuration string and to let the spreadsheet validate invalid or inconsistent options. The spreadsheet currently support FRAM71 and FRAM71B modules. For each FRAM71/B configuration that you do, I suggest that you duplicate the Template tab and do your configuration in the duplicated tab.
FRAM71/B Configuration Worksheet
FRAM71/B Configuration Information
FRAM71/B Configuration Test Suite Sheet #5 - Valid Double Chips Module - FRAM71
FRAM71/B Configuration Test Suite Sheet #7 - Invalid Double Chips Module - FRAM71
FRAM71/B Configuration Test Suite Sheet #9 - Invalid Values - FRAM71/B
Doing your first configuration
Configuration samples
I have reproduced the multiple configuration strings that was used in my old FRAM71 Configuration Example (Intermediate Level) article.
Configuration Steps:
I hope you like it!
Sylvain
Article update log
Preamble
Daniel Simpson is the original instigator of the FRAM71 configuration spreadsheet project. As he was thinking to drop his project, I took his idea and decided to give it a shot. The major difficulty when doing this kind of problem with a spreadsheet, is to have formulas that can validate the integrity at all levels (chip, module and FRAM71/B unit). I have done several implementation of the spreadsheet between January 2021 and July 2021, all of them had chip level integrity, but until this one, all completely or partially failed at module level and/or at FRAM71 unit.
FRAM71/B User's Manuals:
- FRAM71 (Hardware v1.4, Firmware v5.11, "Nashville 2015")
- FRAM71B (Hardware v1.5, Firmware v6.07, "Denver 2016")
- Latest Apple Numbers Release:
- Release Notes:
- Second Apple Numbers release
- Chip Type" : LCiM was not validated for HCROM and HCRAM (bug fix)
- Port : HCRAM test was inverted, ≠ was used instead of = (bug fix)
- Updated to match Excel UI version
- 20210808AN Reference Version
- 20210808AN Development Version (reference version with test cases)
- Release Notes:
- Latest Microsoft Excel Release:
- Release Notes:
- First Microsoft Excel release
- Due to a bug in Microsoft Excel 2016 for Mac, the Excel spreadsheet version does not have conditional colour formatting for highlighting warnings and errors.
- 20210808AE Reference Version
- 20210808AE Development Version (reference version with test cases)
- Release Notes:
- Previous Releases:
- 20210808AN ← Apple Numbers : First Release
- 20210808AN ← Apple Numbers : First Release
- Apple Numbers, 11.1 (7031.0.102)
- Microsoft Excel for Mac, 16.16.27 (201012)
- macOS Big Sur 11.5.1 running on a MacBook Pro 15" 2019, Intel 2.4 GHz 8-Core i9, 32GB RAM
Slides used for the configuration spreadsheet presentation done at the HPCC 2021 mini-conference virtually held on October 23, 2021
Introduction
The goal of this spreadsheet is to create safe FRAM71/B module configuration string and to let the spreadsheet validate invalid or inconsistent options. The spreadsheet currently support FRAM71 and FRAM71B modules. For each FRAM71/B configuration that you do, I suggest that you duplicate the Template tab and do your configuration in the duplicated tab.
FRAM71/B Configuration Worksheet
FRAM71/B Configuration Information
FRAM71/B Configuration Test Suite Sheet #5 - Valid Double Chips Module - FRAM71
FRAM71/B Configuration Test Suite Sheet #7 - Invalid Double Chips Module - FRAM71
FRAM71/B Configuration Test Suite Sheet #9 - Invalid Values - FRAM71/B
Doing your first configuration
- Open the spreadsheet
- Duplicate the template sheet and rename the sheet to MyConfig
- In MyConfig sheet, on the first DATA INPUT line, click on Enable checkbox.
This will include the line to the validator and configurator logic, at the same time and until you fill up all the input fields you will see errors everywhere.
The explanation of these errors can be found in the information sheet. - Fill up the missing input fields for the line with these values:
- Enable: checkbox already selected
- LCiM: select the checkbox
- Chip Type: from the PopupMenu, choose RAM
- Chip Size: from the PopupMenu, choose 32K
- Mem. Block: from the PopupMenu, choose 3
When the configuration is valid, you will see on the right side, good values for Chip number, Address, Configuration Value and Port.
You will also see at the bottom the configuration line that you have to type on your HP-71B.
Configuration samples
I have reproduced the multiple configuration strings that was used in my old FRAM71 Configuration Example (Intermediate Level) article.
Configuration Steps:
- Initial configuration (HC-T41/SC-T41/MATH/JPC/LEX/IRAM) & Install FRAM71 ToolKit
- Load HC-TRANS41 - Before Configuration
- Load HC-TRANS41 - Middle Configuration
- Load HC-TRANS41 - After Configuration / Load SC-TRANS41 - Before Configuration
- Load SC-TRANS41 - After Configuration / Load MATH ROM - Before Configuration
- Load MATH ROM - After Configuration / Load JPC ROM - Before Configuration
- Load JPC ROM - After Configuration / Create Backup 32KB IRAM - Before Configuration
- Create Backup 32KB IRAM - After Configuration / Adding 160KB Main Memory Configuration
I hope you like it!
Sylvain
Article update log
- 2021-10-23 : Added HPCC 2021 presentation.
- 2021-08-08 : Released Apple Numbers second spreadsheet version and Excel first spreadsheet version.
- 2021-07-31 : Initial post.