JohnO's Random Musings

...for that clenching of your lower body that occurs when you hit a speed bump at speed. Especially when you need to visit a restroom, SOON!


For those who don't know what a sniglet is...
http://en.wikipedia.org/wiki/Sniglet

Yesterday I was passed an issue to investigate and post my results by end of day.

My report was in the form of:

I did.
I saw.

I request Person1 do this.
I request Person2 do that.

Even without the results of Person1's and Person2's tasks,
I recommend we do config change1,
If that doesn't work, we need to also do config change2.

Person2 responds: "So what do you recommend?"

I need some help with Microsoft Excel.

I'm trying to get trend report generated.

I have a excel spreadsheet that has 17 months of *daily* data in a simple table:

2003-11-14 50000
2003-11-15 55230
2003-11-16 62000
...
2005-03-19 70000
2005-03-20 71855
2005-03-21 71200

I can chart it easily enough, but I get a very wiggly graph and I'm more interested in seeing the weekly or monthly totals.

Short of creating the weekly/monthly sub-totals, is there an easy way to create sums or charts, with data subtotaled based on date?