Problems registering at AoCZone?
You can try resending activation email. If that doesnt work you can send an email here. If you forgot your password click here.
 Main Menu

 ForumsSearch »

 SY Nations Cup 2017

 Escape Gaming

 EGC #1: Strike the Balance

 Gladiators of the Arena

 AoC Recorded Games

 AoE2HD Recorded Games

 AoFE Recorded Games

 Major Past Tournaments

 Auto downloadedFind »

 Users currently online
Members (34)
»  dg8
Guests (110)

 AoC Clans Add yours »

 Links

 Ads

Google Spreadsheet Support on AoCZone

Game tutorials, strategies, tips & tricks
Advertisement from Google 
 

Google Spreadsheet Support on AoCZone

Postby  Genette » Thu Dec 15, 2016 5:46 pm

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 _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: Select all
[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
User avatar
 Genette
 
Posts: 1248
Joined: Jul 28, 2012
 1602 (47%)
 
 

Re: Google Spreadsheet Support on AoCZone

Postby  willworkforicecream » Thu Dec 15, 2016 5:53 pm

Oh man, this is great. I use google forms and sheets for all sorts of stuff and it is always very handy!

Thanks.
User avatar
 willworkforicecream
 
Posts: 169
Joined: Dec 21, 2014
Location: USA USA USA!
 
 

Return to Articles and Guides

Who is online

Users browsing this forum: No registered users and 2 guests

Legend: Global moderators, News posters, Tournament moderators