Building Tic-Tac-Toe in a Google spreadsheet [video]

https://www.youtube.com/watch?v=Vbnm5dFr_A4

by rarescruceat • 9 years ago

80 26 9 years ago

trhaynes• 9 years ago

I love that he makes real mistakes and then shows how to debug them (using docs, debug output, etc).

I am glad you liked it! I also really enjoy watching people build things, and I am always more interested in the journey than the result.

minxomat• 9 years ago

This is almost impossible to listen to. If one must have background music in a video, use some god damn sidechain compression. Or even better, drop the music. /rant

Aside from that - awesome.

tantalor2• 9 years ago

What is sidechain compression?

tetraodonpuffer• 9 years ago

you put a compressor on the background music with the sidechain input set to the channel your microphone is on, so when you speak the music is automatically pushed to the background and you can actually hear the mic.

elbigbad• 9 years ago

In this case, it's basically where when the presenter is speaking, the music quiets at the exact moment, so you can hear more clearly but still have the music.

nogenerix• 9 years ago

Rather than having voice over and background music clashing at the same volume levels, the music level would decrease whenever the voice over signal is active.

jaak• 9 years ago

What the other poster is describing is more commonly called "ducking". https://en.wikipedia.org/wiki/Ducking

The secondary audio (background music) automatically lowers when the primary audio (narration) is active. It allows the narrator to talk over the background music without being muffled by the music.

An automated way to do this is in audio production is by using the sidechain input of a dynamic range compressor. https://en.wikipedia.org/wiki/Dynamic_range_compression#Side...

mrob• 9 years ago

And it you're adding the music after the speech is recorded, you can use look-ahead so the music can fade out gently before each piece of speech instead of having to abruptly cut off to avoid obscuring it.

chancancode5• 9 years ago

Thanks for the feedback! I fixed it in part 2, let me know if it's still an issue for you. Also, I did not know that's how it's implemented in real life (learned it from this thread). Perhaps I should try building that in Web Audio in another series!

pents90• 9 years ago

A few years ago I wrote a Minesweeper clone in Google Spreadsheets: https://docs.google.com/spreadsheets/d/1367o4BYYNynmMan_1I5x...

chancancode5• 9 years ago

That is very cool! I'll mention it at the end of the series. Might come back to doing something with Apps Script some day!

ash• 9 years ago

Note: redirect to auto-playing YouTube video. Please add "[video]" to the title.

dang2• 9 years ago

Sure.

iiv• 9 years ago

That was fun, easy to understand and informative. He shows how he debugs real errors and builds a decent product pretty quickly. The only complaint is that his voice was drowned in music in the intro.

chancancode5• 9 years ago

Thanks for the feedback! I fixed that in part 2.

dang2• 9 years ago

Url changed from http://chancancode.tv/tic-tac-toe-1, which redirects to this.

digi_owl2• 9 years ago

Makes one wonder about an IDE that use grids like that, but where one can grow multiple sheets/regions as needed without disrupting what exist already.

danbruc2• 9 years ago

Like insert cells, shift existing cells right or down in Excel?

digi_owl2• 9 years ago

yep. Thing is that this is likely to break existing formulas etc at the best of times.

Its funny how it seems only Apple has a spreadsheet the offers free floating "sheets", but there it seems to be treated more like a presentation/layout refinement (meaning that even the "humble" spreadsheet is basically a tool for desktop publishing).

I do believe Excel and others have the ability to reference cells from other sheets, but that still means having to flip between them to keep things in sync.

juhwon• 9 years ago

rly? #13?

bitmapbrother• 9 years ago

It seems to me that this would be a lot easier by just using Apps Script.

Building Tic-Tac-Toe in a Google spreadsheet [video]

Related Stories