Dungeons · Other · Puzzles

Magick Firewall - A Simple Google Sheet Puzzle

This simple self-contained puzzle is a lock/gate built into a Google sheet. This "firewall" requires that the players input a magic square.

70 xp 1,380 views

This puzzle is similar to Norton Mini - A Simple Google Sheet Puzzle. It is a little google sheet page that separates the players from the digital asset they are after. If they can figure out how to hack past it, then they can proceed along a revealed hyperlink to the next thing.

In this time of shelter-in-place, I have found myself using digital tools for social interaction. The online Google products, namely Docs, Sheets, and Slides, turn out to be particularly useful for designing little puzzles that players can engage with collaboratively.

Copy the Google Sheet

The "Magick Firewall" presents itself as a single sheet with a prominent "ACCESS DENIED" cell. Players can see a bunch of red FALSE cells. 

The solution requires that the players input a magic square. That is, a 5x5 square of digits using every digit from 1:25 exactly once, with every row, column, and diagonal summing to the same value. 

Different red cells check for different conditions. They light up green when their condition is met.
Players can use this information to figure out what to do.

Once a correct magic square is written in, the bottom cell turns to "SUCCESS!", which can have a hyperlink on it to move to the next digital asset (another google sheet, doc, or slide deck? Some other URL? Who knows?!)

Introducing Magic Squares

Basically no-one can derive a magic square from scratch without help. That being said, if players are doing this online, they may be allowed to search for one. Other players may be programming savvy and could solve for one that way. Alternatively, a partially completed magic square could be hidden elsewhere in the play session, and the players could use that as a starting point.

Under The Hood

There really isn't much under the hood. Most of the logic is on the main sheet. 
There is a hidden sheet that gets referenced for the solution cell. If the magic square is correct, then the link below the mini points to the SUCCESS! cell (which has a hyperlink) instead of the original ACCESS DENIED cell. You can change the puzzle, change the text, change the hyperlink, etc.

Players can of course get too clever using Google sheet tricks to try to back out what is in this hidden sheet. As a DM it is up to you to what extent you want to lay down ground laws or let them "cheat".

Scrolls

0 scrolls

Twists, chapters, and details meant to stream with the submission — not general discussion.

No scrolls yet — leave one if you have a twist worth keeping.

Sign in to plant an idea scroll.

Award XP

Enjoyed this? Sign in to thank Mageek with blade clashes — 5 XP each, up to 25.

5 10 15 20 25

Sign in to award XP.

Rare mark

Hall of Honour

for Magick Firewall - A Simple Google Sheet Puzzle

The Hall of Honour is your mark on a submission you believe is frick’n awesome — so good you would jump in front of a dragon’s breath to protect the scroll it is written on.

Bestowing HoH also highlights it on the front of the Citadel for about a day, so others see the recognition it earned.

You may bestow HoH on the same submission up to your level (with a short wait between strikes). Five distinct HoH voters raise a work to Golden.

Your shelf

Favor

for Magick Firewall - A Simple Google Sheet Puzzle

Sign in to Grant your Favor on work worth keeping.

Your Realm

Claim

for Magick Firewall - A Simple Google Sheet Puzzle

Sign in and Crown a Realm to Claim this as a Holding for the table.

Discussion

1 comment

Reader talk, questions, and feedback — not scrolls.

  1. Strolen

    These are great little side challenges and the fact that you give us everything we need is fantastic. Great idea!!!

    5 xp Reply +XP

Sign in to join the discussion.

Continue the path

Three more steps through the hall.

  1. Norton Mini - A Simple Google Sheet Puzzle by Mageek Bound

Other takes

none yet

No other takes yet — the best compliment on the Citadel is a Retelling.

Bonds

1 bond

Curated bonds across the Citadel. Kindred Favors are another thread in the same weave.

Binds to 1

The graph

Bind a Bond

from Magick Firewall - A Simple Google Sheet Puzzle

Know a piece that belongs with this one? Bind them together so every reader who finds one can find the other. Choose how they are bound.

Sign in to bind Bonds.

Browse Dungeons Seek the Citadel