FRAM71 : Configuration Spreadsheet [2021-01-31]

[Sylvain Cote]

(01-31-2021 07:55 PM)Dave Frederickson Wrote:  Can anyone add to their spreadsheet a feature that would determine if a given configuration string is valid? That is, it doesn't cause a configuration warning.

(02-01-2021 12:25 AM)rprosperi Wrote:  Which is not a challenge (Sylvain), it's simply not reasonable to try to encapsulate all the possible rules for FRAM71B configuration into an Excel formula (or indeed, even if VBA is used).

(02-01-2021 12:54 AM)cruff Wrote:  Excel formulas are indeed a pain to use for very complex stuff, but VBA is a Turing complete programming language, so it should be possible. Seems like it should be straight forward to do so.

(02-01-2021 01:17 AM)Dave Frederickson Wrote:  Consider it a challenge. A final solution should take into account other installed modules and the 64k bug in the 1BBBB ROM.

Excel has VBA, so it is possible, BUT the problem is that VBA Windows English is different from VBA Windows French is different from VBA macOS is different from ... you get the idea.
Also, not all macOS versions has VBA.
Numbers does not have a built-in scripting engine. Apple has AppleScript but it has not been promoted since the creator has left Apple several years ago.

I have implemented in Numbers duplicate FRAM block check with a formula, see here: (not published yet)

Code:

Check Formula -> J3 = IF($B2,IF(COUNTIF($I$2:$I$33,CONCATENATE("=",$I3))=1,"","Dup.FB"),"")

(02-01-2021 01:17 AM)Dave Frederickson Wrote:  BONUS points if the app can determine the Port numbers.

That was planned and should come soon.

Sylvain