With this post, we’d like to showcase two completely distinct but interesting ways in which Zoho Sheet is being used.
The UK government had opened up its data for other people to re-use. This is only about non-personal, non-sensitive data – information like the list of schools, crime rates or the performance of your council.
is the first step in creating a network of re-useable government data. It is a key part of the UK Government’s work on Transparency which is being lead by the Transparency Board.
You will find over 5,400 public datasets about how governments spends money. Most of these are in the form of CSV and XLS files. This website uses Zoho Sheet’s
Online Viewer API
to allow viewing these public spreadsheet files on your browser. Here is an example. Click on the image to go to that website.
When you view these public spreadsheets using Zoho’s editor, you can optionally save the spreadsheet to your Zoho account and do further analysis on the data such as creating Pivot Tables, drawing Charts, using the 350+ formulas available with us, etc.
2. Darley & Nutwood Local Nature Reserve
Uses Zoho Sheet to create spreadsheets of wildlife registers and publish these spreadsheets online for everyone to see.
maintains wildlife registers on Zoho Sheet. This includes sighting of rare and uncommon species of birds, mammals, insects and plants. They are a small group of people from all walks of life having one thing in common: To study and protect wildlife.
Nutwood is a small area north of the city of Derby in central England and it has been designated as a Local Nature Reserve by Natural England. It is owned by Derby City Council who have commissioned the Wildlife Trust to produce a Management Plan recommending actions between 2007 and 2011. A Management Group has been formed several years ago to administer this plan and much has been achieved.
From their website:
If you are a Wildlife Enthusiast, if you are interested in birds, mammals, insects or plants, whether you are a beginner or know quite a lot about it, this may interest you. We have a very small group of dedicated enthusiasts constantly watching and monitoring aspects of the wildlife in our Nature Reserve. I hope you’ve been able to look at our wildlife registers on this site which will give you an idea of what we are trying to do.
We are looking towards expanding the group by getting dedicated local people involved, particularly dealing with insects and plant life on the Reserve. You would not be committed to a particular work program and we would encourage people to develop their own approach with advice and support from the Management Group. You could devote as much or as little time as you wish. Be a wildlife enthusiast!
Zoho Sheet is used to maintain the online wildlife registers. These spreadsheets are then published so that they are available on a public URL and accessible to everyone on the internet. Here is a screenshot of part of the spreadsheet. Click on the image to view the Birds Register spreadsheet on Zoho.