Google Spreadsheet Support on AoCZone

UnknownGenette

New Member
Jul 28, 2012
1,227
1
0
aoc.voobly.com
#1
Google Spreadsheet Support on AoCZone

Hey guys,

since we've seen that twitch videos and challonge brackets can be embedded pretty nicely on AoCZone, it got me thinking whether Google Spreadsheets could be embedded just as well. So, I sent a few PMs back and forth with norway _PkZ_ and thankfully he implemented this option for us.

Here's an example of how this could make the lives of tournament admins & creators of quality posts a lot easier. If you're curious, it's a draft for the upcoming Balance Patch tournament (nothing set in stone yet).

  1. create a Google Spreadsheet, example: https://docs.google.com/spreadsheets/d/ ... lKFWAS0XY/
  2. select "File" -> "Publish to the web..." -> "Embed" -> [entire document/select sheet] -> [copy html code]
  3. grab the unique ID of your spreadsheet, example: https://docs.google.com/spreadsheets/d/1fnRC0rOX09yji2qnJWlZC-yN4Fsz-VdHStlKFWAS0XY/ and use the following BBCode:

Code:
[gsheet]unique-spreadsheet-ID[/gsheet] ->
[gsheet]1fnRC0rOX09yji2qnJWlZC-yN4Fsz-VdHStlKFWAS0XY[/gsheet]
Formatting Tips:

  1. Since it's likely that you're about to start a new topic, the background colour on AoCZone will be #F0F2F8 - every 2nd post will use the background colour #F4F6F8
  2. If you don't have to present an entire tournament bracket and you like to avoid scroll bars, make sure that your columns (width/horizontal size) add up to 698px. You can right-click on column A for instance and select "Resize Column..." to adjust sizes. You can also select multiple columns/rows, hold down Alt and change the size of one in order to edit the others.
  3. In order to match the height (rows/vertical size) you can right-click on "1" for example and adjust the sizes until they add up to 663px
    (This was tested on Firefox v50.1.0 & Chrome v55.0.2883.87 m)

Final Result:

gl hf
 

Time

Your time
G M T
Your zone

Upcoming Events

Improvement Cup 3v3
Thursday 18:00 (GMT +01:00)
Group D: India vs Anvil
EscapeTV Launch Event - Day 1
Friday 22:00 (GMT +01:00)
TheViper, TaToH, MbL & Liereyy on LAN
Improvement Cup 3v3
Saturday 11:00 (GMT +01:00)
Group A: Gurkentruppe vs. A real estate agent, a tradie, a sales rep and a Mafiosi
Improvement Cup 4v4
Saturday 11:00 (GMT +01:00)
Group C: [ Australia/New Zealand ] vs How To Train Your dRoggan
Improvement Cup 4v4
Saturday 16:00 (GMT +01:00)
Group D: Schmetterlings vs [French Community]
EscapeTV Launch Event - Day 2
Saturday 17:00 (GMT +01:00)
TheViper, TaToH, MbL & Liereyy on LAN
Improvement Cup 4v4
Sunday 11:30 (GMT +01:00)
Group A: Team Straya/NZ vs new Chapter
Improvement Cup 4v4
Sunday 16:00 (GMT +01:00)
Group D: [USA] vs Team Schmetterling
EscapeTV Launch Event - Day 3
Sunday 17:00 (GMT +01:00)
TheViper, TaToH, MbL & Liereyy on LAN
KotD2 - Quarterfinals
January 26th 16:30 (GMT +01:00)
Quarterfinals Day#1
KotD2 Quarterfinals
January 27th 16:30 (GMT +01:00)
Quarterfinals Day#2

Age Of Empires On Twitch

There are in total 15 streamers online
Click here for details
Age of Empires II 139 viewers
Age of Empires II 124 viewers
Age of Empires II 26 viewers
Age of Empires II 8 viewers
Age of Empires II 8 viewers
Top