Less than 1 week –
Less than 10 hrs/week –
Research project seeks talented person for ongoing work. This job is a small job to try out candidates for ongoing work. Will provide access to spreadsheet and documentation.
1) Review existing Googlesheet db is <100 tables ("tabs") which are <300 rows <300 columns each, pretty small. Has 1000+ lines of googlescript queries and reports.
2) Create a UI allowing end-user to select a country from a static dropdown menu of 239 countries, found in in tab ISO 3166 of the spreadsheet. **No user authentication required**
ISO3166 List can be found here: https://docs.google.com/spreadsheets/d/1W5QRIpkiKYn0-AwCk_W8kEoL5tbn5Sg54Cbq9kCxL_8/pubhtml
3) Using Google Sheets API version 3.0, return simple query results. Read-only.
See: https://developers.google.com/google-apps/spreadsheets, "Working with list-based feeds," "Working with cell-based feeds." "Fetching specific rows or columns." "Sending a structured query for rows."
(from Google Sheets API version 3.0, https://developers.google.com/google-apps/spreadsheets)
listQuery.SpreadsheetQuery = "age > 25 and height < 175";
"Fetching specific rows ...</100>