647941 - Make stats output directly spreadsheet-pastable output

Status: RESOLVED FIXED

(Camino Graveyard :: General, defect)

Description

[Stuart Morgan]

Per discussion in bug 637091, the stats script should output data that can be pasted straight into spreadsheets (probably leaving human-readable as an optional output).

I'll take care of the column reordering discussed in bug 637091 comment 4 and 5 as part of this.

Comment 1

[Stuart Morgan]

Reordering landed as http://hg.mozilla.org/camino/rev/8a5faf7aaea9 and corresponding changes made to the spreadsheet (sadly, the Percents tab got completely screwed up, so I need to fix that)

Comment 2

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

(In reply to comment #1)
> Reordering landed as http://hg.mozilla.org/camino/rev/8a5faf7aaea9 and
> corresponding changes made to the spreadsheet (sadly, the Percents tab got
> completely screwed up, so I need to fix that)

Bug 647491 will probably require more munging of that table (and then all the charts), too :(

Comment 3

[Stuart Morgan]

Attachment: fix

This changes the 'counts' command to output lines that are directly paste-able into the spreadsheet. It even outputs the date and the weekday letter columns, so you won't have to manually fill those down.

Comment 4

[Stuart Morgan]

Oh, and for languages I decided to punt on finding new languages; I think the best way to handle that is to occasionally run the pretty-print mode that I'm about to make, which will do everything dynamically (since it won't need to line up with the spreadsheet)

Comment 5

[Stuart Morgan]

Landed as http://hg.mozilla.org/camino/rev/0aaaf0711258