Here are some FIFA World Cup 2014 gadgets from
Zoho Docs. The HTML code snippet is provided below for each of the gadgets. Feel free to embed these on your website / blog.
Here is how the spreadsheet works:
- Once the scores of each match are updated, the Group Standings is automatically updated using formulas and the table is sorted by a VBA Macro.
- The winner is highlighted in green and the loser in red by means of Conditional Formatting.
- Today's Matches and Latest Results in the first worksheet are automatically updated using Array Formulas referring to the Schedule table.
- The Schedule Table and Today's Matches will automatically display the matches according to the time zone you set on the first worksheet. This is achieved using formulas.
- 'Know Your Player' lets you select a player from a dropdown list by using Data Validation and fetches the statistics of the player by using Formulas.
The Group Standings cell range has been published using the Publish Range feature and the Top Scorers Chart has been published using the Publish Charts functionality in Zoho Sheet to help you embed these on your websites/blogs.
1. Interactive Spreadsheet Gadget of FIFA 2014 World Cup
Embed Code:- <iframe width="100%" height="540" style="border:1px solid #ccc" frameborder="0" scrolling="no" src="https://docs.zoho.com/sheet/published.do?rid=egrja6ab73a5c5fe6470fb5ed988938fb331e&mode=embed"> </iframe>
Gadget:
2. Today's Matches Gadget
Embed Code:
- <iframe src='https://docs.zoho.com/sheet/publishrange.do?id=f9676cbbb547ec2e4ebe722018acc8f1' frameborder='0' style='height:298px;width:227px' marginwidth='0' marginheight='0' scrolling='auto'> </iframe>
Gadget:
3. Group Standings Gadget
Embed Code:
- <iframe src='https://docs.zoho.com/sheet/publishrange.do?id=8efe2499273ef70f52c2853c5e22f375' frameborder='0' style='height:987px;width:457px' scrolling='auto' marginwidth='0' marginheight='0'> </iframe>
Gadget:
4. Top Goal Scorers Chart
Embed Code:
- <img title='FIFA 2014 - Top 10 Goal Scorers - https://docs.zoho.com' alt='FIFA 2014 - Top 10 Goal Scorers - https://docs.zoho.com' src='https://docs.zoho.com/sheet/publicgraphs/24330000001887293.png'>
Gadget:
Uploading ....
