View Single Post
Posts: 58 | Thanked: 2 times | Joined on Dec 2010 @ Auburn, WA
#678
Uh oh. I think we might have run into some sort of complexity limit with the spreadsheet. There was an update to Angry Birds Season Free today and I was trying to add rows to that section for the new levels and I kept getting this error:

The formulas on this sheet could not be calculated. Try removing some formulas or modifying complex formulas, like VLOOKUP and HLOOKUP, and recalculate. For more information on size and complexity limits in Google spreadsheets, visit the Google Docs Help Center..
It seems we are only allowed so many formulas per sheet. I was able to get around the error for now by deleting an unused set of columns and some ununsed rows, but I think that's all we're getting. If we want to add any more levels we will need to either: 1) rethink how the spreadsheet is organized, 2) maybe remove a bunch of people who no longer participate and the columns associated with them, or 3) come up with a way to use less formulas or less complex formulas (the formula for the average on each level is huge now).

One thing we could do is make one spreadsheet per game (AB, Seasons, Rio, Free, Seasons Free, and Rio Free). One bad thing with that idea though is that new users are not likely to consistently create columns for themselves in every tab and without that consistently I don't see how we could have a 'Totals' area that shows a sum total across all games. (maybe that's not important though). I don't think we can implement the previous idea of one sheet for data and one for formulas since we would still have the same problem with the number of formulas per sheet.