Thursday, June 9, 2022

More cleanup of the database, I deem it ready for use

MOST OF THE 80 DUPLICATES WERE NOT, BUT FOUND A FEW TYPOS

Where I had duplicates, i.e. the same pin assigned to two Netnames, in most cases these were the signal entry pages of the ALD, which just list the connector pin for the I/O cable and where the signal first goes inside the 1130. These are legitimate and I left them.

I did find a couple of typos. For example, there are two associated nets, +Bit Counter E and -Bit Counter E. In a couple of entries, I typed the wrong sign for the entry. After verifying with the real ALD pages what was the correct value, I adjusted things. 

We are still at a count of 6,900 pin entries since those were all false duplicates.

RESOLVED AMBIGUITIES AND FIXED TYPOS

A sort just by netname let me perform an eyeball scan for places where I entered netnames differently but these might be the same net. I again had to refer to the ALD images to make the decisions, but that did let me improve the quality of the data. 

As an example of the ambiguities I cleaned up, sometimes I referred to a clock state as +T 2 and other times as '+T2 but these were clearly the same net and should be electrically connected. In these cases I referred to the ALDs and made a choice for the form I believed would be canonical, then repaired the spreadsheet entries that differed.

2 comments:

  1. Congrats on going from zero to done in such a short time, given how the tone of your initial post on this topic seemed a bit pessimistic!

    ReplyDelete
    Replies
    1. It involved even more hours but I just sucked it up and typed

      Delete