Google Sheets Interactive Logic Gate Explorer

Anything modular synth related that is not format specific.

Moderators: Kent, luketeaford, Joe.

Post Reply
User avatar
Triscus
Common Wiggler
Posts: 90
Joined: Thu Sep 06, 2018 5:02 am
Location: Hamburg

Google Sheets Interactive Logic Gate Explorer

Post by Triscus » Tue Apr 28, 2020 2:23 pm

Hello fellow Wigglerrettes and Cableteers,

my initial idea was to control or to sequence with gates and logic, but I'm having a hard time to remember or to forsee the outcome.

So I made a Logic Gate Explorer in Google Sheets. It's based on the use of the A-160-2 (ClockDivider 2 in Gate mode with 'reversed' Gates, so its starting with 'LOW' Gates) and the A-166 Dual Logic Module.
  • You can explore Logic gates up to three inputs for 128 Steps
  • Select the gate division 1 to 3 and the cell color changes accordingly to the logic functions and selected divisions
  • To use only two inputs, select 'none' for division 3
  • The XOR-Row behaves like the XOR-Output on the Doepfer A-166 module. I found out it's different to the XOR Functions in Excel/gSheets
  • As for now the following divisions are supported: 1, 2, 3, 4, 5, 6, 7, 8, 11, 13, 16, 17, 32, 64
You can find the google sheet here:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Feel free to use it to your liking. If you find any errors, let me know.

Cheers Triscus

Edit: Added 11,13 and 17 divisions
Last edited by Triscus on Mon May 04, 2020 12:24 pm, edited 3 times in total.

User avatar
DeltaTucanae
Common Wiggler
Posts: 143
Joined: Sun Mar 12, 2017 4:38 pm

Re: Google Sheets Logic Gate Explorer

Post by DeltaTucanae » Wed Apr 29, 2020 12:20 am

Thanks for this, definitely useful!

User avatar
lohacker
Ultra Wiggler
Posts: 807
Joined: Sat Oct 01, 2011 6:48 am

Re: Google Sheets Logic Gate Explorer

Post by lohacker » Wed Apr 29, 2020 1:37 am

Great work many thanks!
I've thought about something like this in the past but my Excel skill were rather poor.

Post Reply

Return to “Modular Synth General Discussion”