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 »

 King of the Desert

 Masters of Arena 5

 Escape Gaming

 Polaris Series

 AoC Recorded Games

 AoE2HD Recorded Games

 AoFE Recorded Games

 Major Past Tournaments

 Users currently online
Staff (1)
Members (69)
»  650r
»  _MbL_
»  Aerow
»  LB10
»  Manu
»  Poxo
»  rmcoo
»  theog
»  tresu
Guests (150)

 AoC Clans Add yours »

 Links

 Auto downloadedFind »

 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: 1227
Joined: Jul 28, 2012
 1624 (49%)
 
 

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: 174
Joined: Dec 21, 2014
Location: USA USA USA!
 
 

Return to Articles and Guides

Who is online

Users browsing this forum: No registered users and 1 guest

Legend: Global moderators, News posters, Tournament moderators