v0.12.0

Improvements:

• Add GM_CLEAN_TEXT
• Add GM_LARGEST_REMAINDER_ROUND
• Use Sheets API v4 instead of the now deprecated Data Feeds API (this prevents GM_ID and friends from failing 50-90% of the time)

Updates based on changed external data sources:

• Update link to where remote WDI datapoint csvs are located + add tests that verifies that the datapoints are accessible

Smaller fixes:

• Fixed bug in GM_INTERPOLATE which included the header row when interpolating, resulting in lost Georgia results if the column header was "geo"
• Default sort by aggregation property name and year for GM_PROP_AGGR and GM_DATA_AGGR
• Improved error handling, tests and docs

Other:

• Removed all deprecated *_SLOW functions for good

Install this version by following the instructions in the v0.12.0 Google Spreadsheet

v0.11.0

TL;DR:

• Include requested fixes that have been made available in the GM Functions development Gsheet between May this year and today

Improvements:

• Added support for "zerofill" interpolation
• Added support for "4ilevels" geo set
• Added pagination to GM_INTERPOLATE and GM_UNPIVOT, allowing them to be used on larger datasets
• Add ability to import specific versions of data dependencies
• Fixed bug in GM_INTERPOLATE which included the header row when interpolating, resulting in lost Georgia results if the column header was "geo"

Updates based on changed structures:

• Synced ID validation with DDF requirements, allowing underscores
• Updated expected headers for open-numbers catalog + made the check less strict
• Updated expected columns for the data geographies sheet (which is the lookup sheet for GM_PROP)

Smaller fixes:

• Default sort by aggregation property name instead of aggregation property value
• Fixed various bugs related to spreadsheet validation:
  • Sheets with the suffix "-column" not considered output sheets
  • Check that indicator units does not start or end with a space
• Improved tests and docs

Install this version by following the instructions in the v0.11.0 Google Spreadsheet

v0.10.0

TL;DR:

• Support datasets with multiple concepts/indicators

Breaking changes:

• Renamed GM_DATASET_CATALOG_STATUS to GM_DATAPOINT_CATALOG_STATUS since it checks the Datapoints catalog entry, not the Dataset catalog entry
• Data dependencies import only a single referenced concept data from datasets with multiple concepts/indicators at a time
• Clarified/renamed "Dataset reference" as/to "Concept ID and catalog reference" in data-dependencies and data-catalog (requires manual rename of those columns)

Smaller changes:

• Fixed various bugs related to spreadsheet validation:
  • Clarified the validation messages related to field length checks
  • Workaround gsheets peculiarity related to sheet-scoped named ranges (ABOUT!validation_table)
• Include time unit, geo set and dataset id for informational purposes in the imported data catalog sheet

Install this version by following the instructions in the v0.10.0 Google Spreadsheet

v0.9.2

• Fixed several reported bugs related to Dataset spreadsheet validation:
  • Clarified the "should cover the whole table" validation messages
  • Incorrectly displaying "BAD" for one of the passed validations
  • Only validating sheets starting with 'data-for-' and not ending with '-in-columns'
• Added support for world_4level geo set

Install this version by following the instructions in the v0.9.2 Google Spreadsheet

v0.9.1

• Fixed a bug related to refreshing the data catalog for the first time
• Refreshing the data catalog now also fills the "Catalog status" column in the data-dependencies sheet with the GM_DATASET_CATALOG_STATUS function

Install this version by following the instructions in the v0.9.1 Google Spreadsheet

v0.9.0

• Added GM_DATA_AGGR
• Added GM_WEIGHTED_AVERAGE

Install this version by following the instructions in the v0.9.0 Google Spreadsheet

v0.8.0

Enhancements:

• Support importing Open Numbers World Development Indicators via data dependencies (including added support for the world_6region geo set apparent in some of those indicators)
• Added menu item action "Gapminder Data -> Refresh data catalog"
• In the "data-dependencies" sheet's "Data reference" column, you are now able to select between the datasets listed in the Fasttrack catalog and the Open Numbers World Development Indicators
• GM_DATASET_CATALOG_STATUS checks that the concept does not start or end with a space, nor contains anything else other than alphanumeric characters (a-z, 0-9) and underscores

Breaking changes:

• Removed the ability to import fasttrack catalog concept data on-the-fly in GM_DATA, GM_IMPORT, GM_PER_CAP, GM_GROWTH (this ability has been moved to new functions called GM_DATA_SLOW, GM_IMPORT_SLOW, GM_PER_CAP_SLOW, GM_GROWTH_SLOW)
• Restored GM_PROP as a separate function (instead of baked into GM_DATA), which still imports and joins Gapminder property data on-the-fly
• Renamed GM_AGGR to GM_AGGR_PROP to clarify that it aggregates by property only

These breaking changes reflect the new knowledge that importing concept data on-the-fly is an anti-pattern which should not be the default behavior since it leads to the GM_-functions hanging on "Loading..." even for medium-sized datasets. Using the "data-dependencies" sheet is the performant way to get data from the fasttrack catalog and open numbers into the dataset worksheet for further refinement since it imports the data only when necessary instead of doing it on-the-fly in every use of any of the above functions.

Install this version by following the instructions in the v0.8.0 Google Spreadsheet

v0.7.0

• Added menu item "Gapminder Data -> Validate this dataset spreadsheet", which validates that the dataset spreadsheet conforms to the comments found in the template (about 30 validation rules implemented) and writes the validation results in the Validation table at the bottom of the About sheet
• Fix: GM_DATASET_CATALOG_STATUS only requires one data sheet to be published: the one that is being checked (previously the about sheet and data sheets for all geo sets had to be published)
• Accept additional geo set names (countries-etc, regions, world) for the geo_set arguments (previously only countries_etc, world_4region and global was accepted)

Install this version by following the instructions in the v0.7.0 Google Spreadsheet

v0.6.0

• Added GM_DATASET_CATALOG_STATUS
• Updated the expected worksheet names and positions based on the template spreadsheet
• Import/refresh data dependencies improvements:
  • Creates the data-dependencies spreadsheet if it doesn't exist
  • Verifies that the first headers of the data-dependencies spreadsheet are as expected
  • Does not attempt to import data with bad catalog status
  • Communicates import status as the import progresses
  • No longer incorrectly changes the existing references to imported data

Install this version by following the instructions in the v0.6.0 Google Spreadsheet

v0.5.0

• Added GM_GEO_LOOKUP_TABLE
• Added structured documentation and usage examples to the Google Spreadsheet

Install this version by following the instructions in the v0.5.0 Google Spreadsheet