[BC] Krone/punchblock Excel Sheet?

[Andy Linton]

Hi all,

Has anyone designed an Excel spreadsheet to annotate Krone (or other 
10-way punchblock) systems?

I have a simple one, but I'm having trouble getting the reverse 
jumpers to work.

i.e. if I enter that pair 101 is jumpered to pair 304 and used for 
AUD L, I want the spreadsheet to automatically put an entry further 
down the list to show that 304 is jumpered to 101 and used for AUD L.

I'm sure that Excel can do this, it can do most things (almost 
including making the tea) but I know not how!

Thanks and rgds!



-----------------------------------
       Andy Linton
   Waterford, Ireland