I’ll send you some Excel sheets in the format I use. They are macro-enabled templates, which you should install in your Excel templates folder.
Do I read your spreadsheet correctly in that it appears some of the chests have been wired from both ends, so the pin assignments don’t run sequentially? If that’s the case it’s OK, but you should know because it takes more time to build the definition file in those cases. In those cases, the cost may be higher. Depending on how many ranks there are, if there are only a couple it probably won’t be much, but if all the manual chests are done that way, it can more than double the time it takes to configure each rank and that can really run things up, because I can’t use any of the shortcuts which would otherwise be available.
I didn’t notice any entries in the Stop Tab action sheet. There’s one important wiring point to consider here: keep each Stop Action Magnet (SAM) – or or pair of on and off magnets, if it’s an air console – together. There’s a good reason for that. Whether you’re dealing with SAMs or magnets, you will never fire more than 50% of the outputs at a time (you can’t have a stop turn on and off at the same time). Keeping the on-off pairs together on the same chip assures that you won’t run over the collective output current of which the chip is capable.
Also, when you’re assigning board addresses, follow this sequence for future supportability purposes:
Console Inputs: Boards AA – AP
Console Outputs: Boards BA – BP
Chamber 1 Outputs: Boards CA – CP
Chamber 2 Outputs: Boards DA – DP
Chamber 3 Outputs: Boards EA – EP
Unenclosed traps and the like can go on any of the chamber boards, just try to keep them all together if possible.
Here’s the worksheet I mentioned.
You’ll notice what might appear to be inconsistencies at first glance. On the chamber output sheets, we don’t bother with note names except on Offsets and ranks on manual chests where the lowest chest note is something other than C, such as a Diapason (the bottom 18 notes from 16’ C are on offsets, so the chest will begin at F#). Ranks where the offsets are single-octave (12 notes) are just numbered on the manual chest.
Wurlitzer percussions, most of which run G – G instead of C – C, are just numbered despite not starting on C.
You’ll also notice some entries called “Spare.” It’s a good idea to leave some spares in case a cable gets damaged, or you have a chip failure where only one pin goes out (rare, but it can happen). The spares will give you someplace to move the wire, so they aren’t typically wired in advance. Just be sure to leave a wire in the bundle, wrapped up at each end. (Hint: on a chest spare, put the spare at the far end of the cable. If you have to use it, you can pull it back through the bundle to the point at which you need it before you cut it to length, and everything will still look “factory new.”)
If you need more sheets than what are there (you almost certainly will) just use the “Move or Copy” function to make the additional sheets.