...
- Stats are automatically generated every day and sent, via Email, to a list of recipients. (See Qing to be added to this list.)
- Save each Email as a text file.
- Open the Excel spreadsheet.
- Click "Import"
- Select the "Text file" radio button (on the bottom).
- Select the text file (import dialog will open).
- Select the "Delimited" radio button.
- In the "Start import at row:" field, enter the line number where you see "Domain: AP"
- Click "Next".
- Enter ":" (a colon) in the "Other:" field.
- Click "Next".
- Click the "Do not import column (Skip)" radio button. (You want to not import the left hand column.)
- Click "Finish"
- Select the radio button for "Existing sheet", and select the cell right under the appropriate date.
- Click "OK".
To create a quarterly graph:
...
- Redo all the formulas:
- Work on the left-most set of totals (at the very bottom of the sheet).
- Double click on "Users"; the formula will appear.
- Go to the formula bar at the top of excel.
- =SUM(B194+B184+B174+B164+B144+B134+B124+B114+B104+B94+B84+B74+B64+B54+B44+B34+B24+B14+B4)
- Notice that there is no "B154" in the formula.
- Type in the missing value.
- Click "Enter" on your keyboard.
- Repeat this process for each value in turn: Users, Libraries, Albums, Slideshows, Saved Searches, Images, Total, Total Size.
...