+1(514) 937-9445 or Toll-free (Canada & US) +1 (888) 947-9445
Client Portal

Improvements to Google Spreadsheet

ranac09

ranac09

Member
Oct 6, 2017
13
7
I just want to start this thread to collect some feedback to improve our awesome spreadsheet.
I have noticed, lot of people asking of stats and time based on the location.

I just added a new sheet called "Average Based on Location".

Link to the sheet

As a starting point to collect some feedback, I only included two months (Oct 2017, Jan 2017).

Here are some points I already have.
  1. Eventually I'd like move this averages table on every sheet. Currently I do not have that access and also am collecting feedback right now so I guess its ok for now
  2. I have notice some typos in the location names which is affecting the averages. e.g. sometimes Brampton is spelled with a space "Brampton ", while some other times there is a regular typo. We might need to clean this to get some proper times..

What are you thoughts? Do you think this will be useful or am just wasting time? Let me know you thoughts
 
Last edited:
  • Like
Reactions: Jaroddz, Johnboy, vasvas and 2 others
Presumably AOR speed is not based on location but on turnover of application receipt from Sydney, NS - is this correct?
 
ranac09 said:
I just want to start this thread to collect some feedback to improve our awesome spreadsheet.
I have noticed, lot of people asking of stats and time based on the location.

I just added a new sheet called "Average Based on Location".

Link to the sheet

As a starting point to collect some feedback, I only included two months (Oct 2017, Jan 2017).

Here are some points I already have.
  1. Eventually I'd like move this averages table on every sheet. Currently I do not have that access and also am collecting feedback right now so I guess its ok for now
  2. I have notice some typos in the location names which is affecting the averages. e.g. sometimes Brampton is spelled with a space "Brampton ", while some other times there is a regular typo. We might need to clean this to get some proper times..

What are you thoughts? Do you think this will be useful or am just wasting time? Let me know you thoughts
Click to expand...
Love it!
 
Thanks, the spreadsheet is a great tracking tool and any additional stats would be awesome.
I was wondering about some sort of bar graphs or bell curves for the length of time to achieve each stage, or stats on the corollary of number of apps not reaching a certain stage and how long they have been waiting... this might alleviate some concerns for those of a nervous disposition. But I'm not sure what is possible in google docs. :)
 
Bump.

Whoever has provided this great tracking spreadsheet deserves some feedback from everyone please :)
 
You must log in or register to reply here.