Recently I’ve been using Google drive spreadsheets to collect data on poverty in America. The ease of collaboration cannot be denied. Having the ability to collect data with a group of other people and make sense of it is a very powerful tool.
However, I found the UI a bit clunky and it was difficult to create customized charts to interpret the data. Especially when compared to more popular spreadsheet software like Microsoft Excel. I was able to quickly display a chart from gathered data in Excel showing the percent of poverty rates from specific data.
Whereas, applying the same data and format in the Google spreadsheet produced nonsensical results.