647491 - Add a percent mode to the update stats script

Status: RESOLVED INCOMPLETE

(Camino Graveyard :: General, defect)

Description

[Stuart Morgan]

The percent table is problematic on account of all the formulas. Should I add a mode to the script where it calculates all the percents and dumps them just like the current mode dumps the numbers, so we don't need to fight the formula count limits?

Comment 1

[Smokey Ardisson (offline for a while; not following bugs - do not email)]

YES!

However, there's one other problem Google's introduced.  With "new charts", to even make a chart, the column for the X-axis is required (and, due to the limitations of charts, must be immediately adjacent to the first data series).  ("New charts" suck in other ways, too, but not being able to create charts is a real problem as we get close to 2.1.).

I think ultimately to be able to support charts, we're going to have to have a spreadsheet tab backing each chart.  Oh, or I guess we could output the date column at the beginning of each "section" of the Percents sheet that backs a chart.  Redundant, but better (for pasting) than 15 different sheets.

Comment 2

[Stuart Morgan]

Attachment: basic fix [landed]

Percent mode landed as http://hg.mozilla.org/camino/rev/bceb7f146896

I still need to add more date columns; I'll do that soon and start converting charts over. I may also go ahead and add 10.7 now.

Going forward though, percent stats should just be pasted in. Yay, full-data graphs again!

Comment 3

[Smokey Ardisson (offline for a while; not following bugs - do not email)]

(In reply to comment #2)
> Going forward though, percent stats should just be pasted in. Yay, full-data
> graphs again!

We probably want to do a conversion of the current percents sheet (perhaps even in chunks of rows, as I had to keep removing rows to be able to add rows and ideally we could add back the missing valid rows before we forget the old formulas, and convert those all to text, too) to text at some point so that we eliminate all that formula usage.

I guess we could do the same for the 10.3/4/5/6 columns in the Table sheet (pre-7-21-2010, when I first pasted data using my rewrite of Sam's script, they were formulæ), but that's only 4 x 583, which should be nothing compared Percents.

When I opened the stats doc tonight, I got a warning "This spreadsheet is about to reach the following limits: Number of Formulas. Learn more Dismiss" so we must be close again.  I don't think we'll be adding more, but removing the ones we don't need should be some bit of speed win, I'd hope.