Spreadsheet: minor errors in 'Averages Based on Location' tab

[Johnboy]

Hi all maintainers of the spreadsheet. Thanks for the great work.
I noticed some errors in the data to generate the 'Averages Based on Location' tab.
https://docs.google.com/spreadsheets/d/16cfQUVB3j56QktacolbsAxpNlOrvk2uFGZzm_ZFCnfg/edit#gid=1475105933

There are actually more Vancouver users for October 2017 (68) than reported in the Averages tab(51).
This is due to a trailing <space> on Vancouver cells in column B.
It would be great if the following user rows could be updated to remove the trailing space, or
just do a global search and replace for 'Vancouver ' with 'Vancouver'

Sfulmc8
bilal007
absolute_zer0o
wargo
nazam80
hfinkel
thebassi35
Natinthehat
AOR_TA
WAMFEO
Nidos
sherych
Artem26
Marco
arian_arian
flower12
skookumbc​

Maybe there is a macro somewhere (I see one for MS excel) which could globally trim all the cells

Many thanks



Oh, and I also noticed that the following also have trailing spaces which make the averages slightly out of skew :-
Toronto, Scarborough, Saskatoon, Ottawa, Montreal, Mississauga, Hamilton, Edmonton, Calgary, Brampton

 

[Johnboy]

Bump!

 

[razerblade]

Hi all maintainers of the spreadsheet. Thanks for the great work.
I noticed some errors in the data to generate the 'Averages Based on Location' tab.
https://docs.google.com/spreadsheets/d/16cfQUVB3j56QktacolbsAxpNlOrvk2uFGZzm_ZFCnfg/edit#gid=1475105933

There are actually more Vancouver users for October 2017 (68) than reported in the Averages tab(51).
This is due to a trailing <space> on Vancouver cells in column B.
It would be great if the following user rows could be updated to remove the trailing space, or
just do a global search and replace for 'Vancouver ' with 'Vancouver'

Sfulmc8
bilal007
absolute_zer0o
wargo
nazam80
hfinkel
thebassi35
Natinthehat
AOR_TA
WAMFEO
Nidos
sherych
Artem26
Marco
arian_arian
flower12
skookumbc​

Maybe there is a macro somewhere (I see one for MS excel) which could globally trim all the cells

Many thanks



Oh, and I also noticed that the following also have trailing spaces which make the averages slightly out of skew :-
Toronto, Scarborough, Saskatoon, Ottawa, Montreal, Mississauga, Hamilton, Edmonton, Calgary, Brampton

Done. Let me know if I missed any. Thanks!