Out of Range Cell Reference

[OthelloPrime]

I'm using the latest WritingStats and DailyAlmanac codes from Beta v.2. I'm also using the latest writing tracker spreadsheet. I received the error below when I ran WritingStats manually. I got the same error (line 76) when I ran DailyAlmanac.

Cell reference out of range (line 53, file "Writing Stats")

48 function find(value, range) { 49 var data = range.getValues(); 50 for (var i = 0; i < data.length; i++) { 51 for (var j = 0; j < data[i].length; j++) { 52 if (data[i][j] == value) {
53 return range.getCell(i + 1, j + 2);

[jamietr1]

That's one I haven't seen! I likely won't be able to look into it until Thursday or Friday, but if I have time to do it sooner, I will.

---

Jamie Todd Rubin (@jamietr http://twitter.com/jamietr) http://www.jamietoddrubin.com http://www.jamietoddrubin.com/going-paperless/

On Sun, Aug 10, 2014 at 6:48 PM, OthelloPrime notifications@github.com wrote:

I'm using the latest WritingStats and DailyAlmanac codes from Beta v.2. I'm also using the latest writing tracker spreadsheet. I received the error below when I ran WritingStats manually. I got the same error (line 76) when I ran DailyAlmanac.

Cell reference out of range (line 53, file "Writing Stats")

48 function find(value, range) { 49 var data = range.getValues(); 50 for (var i = 0; i < data.length; i++) { 51 for (var j = 0; j < data[i].length; j++) { 52 if (data[i][j] == value) {

53 return range.getCell(i + 1, j + 2);

— Reply to this email directly or view it on GitHub https://github.com/jamietr1/google-docs-writing-tracker/issues/17.

[OthelloPrime]

I removed all of my old scripts and started with a fresh spreadsheet and new scripts. My error disappeared but now I get the same error as Dr. Whodini (Range not found (line 373, file "Code") #18).

Thank you for these amazing scripts.