Create QR codes in Excel

#1

Post by ambanmba » Sat, Sep 22, 2018, 11:16 AM UTC

Re: Create QR codes in Excel

#2

Post by nayuki » Sat, Sep 22, 2018, 4:18 PM UTC

The way that the author uses pure Excel formulas (no VBA or macros) to compute a QR Code from scratch is similar to how I used pure Excel to compute ciphers:

* AES cipher internals in Excel: https://www.nayuki.io/page/aes-cipher-internals-in-excel

* DES cipher internals in Excel: https://www.nayuki.io/page/des-cipher-internals-in-excel

Re: Create QR codes in Excel

#3

Post by userbinator » Sat, Sep 22, 2018, 5:23 PM UTC

(Pure) Excel is a form of dataflow programming --- the sequencing is implicit, but the flow of values is explicit. For algorithms that don't have arbitrary input-dependent looping, it is relatively easy to implement.

Re: Create QR codes in Excel

#4

Post by kebman » Sat, Sep 22, 2018, 9:04 PM UTC

What's up with all the Excel hacks these days?

Re: Create QR codes in Excel

#5

Post by vegetablepotpie » Sat, Sep 22, 2018, 11:54 PM UTC

nayuki wrote: post #2

The way that the author uses pure Excel formulas (no VBA or macros) to compute a QR Code from scratch is similar to how I used pure Excel to compute ciphers: * AES cipher internals in Excel: https://www.nayuki.io/page/aes-cipher-internals-in-excel * DES cipher internals in Excel: https://www.nayuki.io/page/des-cipher-internals-in-excel

That's really cool. I've been wanting to delve into the inner workings of ciphers for some time and I think this will make it easier.

Re: Create QR codes in Excel

#6

Post by kerng » Sun, Sep 23, 2018, 12:47 AM UTC

Excel - the handy old school swiss army knife for data processing and visualization. Its pretty interesting what some folks can pull of with it.

Re: Create QR codes in Excel

#7

Post by nayuki » Sun, Sep 23, 2018, 3:51 AM UTC

vegetablepotpie wrote: post #5

nayuki wrote: post #2

The way that the author uses pure Excel formulas (no VBA or macros) to compute a QR Code from scratch is similar to how I used pure Excel to compute ciphers: * AES cipher internals in Excel: https://www.nayuki.io/page/aes-cipher-internals-in-excel * DES cipher internals in Excel: https://www.nayuki.io/page/des-cipher-internals-in-excel

That's really cool. I've been wanting to delve into the inner workings of ciphers for some time and I think this will make it easier.

Thanks! I have another piece of work that shows the internal computations. I implemented hashes and cipher in short Python code. You can insert debugging prints easily to show the intermediate values. https://www.nayuki.io/page/cryptographic-primitives-in-plain...

Re: Create QR codes in Excel

#8

Post by [deleted] » Sun, Sep 23, 2018, 4:08 AM UTC

nayuki wrote: post #2

The way that the author uses pure Excel formulas (no VBA or macros) to compute a QR Code from scratch is similar to how I used pure Excel to compute ciphers: * AES cipher internals in Excel: https://www.nayuki.io/page/aes-cipher-internals-in-excel * DES cipher internals in Excel: https://www.nayuki.io/page/des-cipher-internals-in-excel

[deleted]