Earnings Exporter

Earnings Exporter automates the retrieval of your ChaCha question history into Excel. It also provides simple analytical tools to satisfy your curiosity.

Current Version:
Earnings Exporter v2_00h (180 KB)

Past Versions:
Earnings Exporter v2_00g (177 KB)
Earnings Exporter v1_02d (122 KB)
Earnings Exporter v1_01 (95 KB)
Earnings Exporter v1_00 (96 KB)
Earnings Exporter v0_01 (60 KB)

Screenshots:

Version History:

v2_00g
Category Analysis
Daily Analysis Charting

v1_02d
1004 error to be tested
Earnings now works with Category Pay charts
Msg box message on Main Grab
Deleted extra cells when already analyzed page
Analysis Page header text now fits
Buttons on Analysis Page moved
Added percentages on Charts on Analysis page

v1_02c
1004 error to be tested
Earnings Chart bug Fixed

v1_02b
1004 error still to be tested
Deletes charts when opening up a new one

v1_02
Attempt Fix at Refreshing on Failed ChaCha Pages
Test tto see if user/pass is inputed

v1_01
Fixed Transcriber Abort, Clarify Analysis. Was duplicated from Expeditor
Removed Top Guide Analysis on To Do list
Average Time Per Question
Average Earnings Per Search Time
Added Comments

v1_00
Change file name

v0_03 Removed Extra Cells due to Time Format Change
Analysis Button on datasheet moved
Fixed Failure to update due to pre-existance of sheets
"Already Analyzed" msg no longer comes with Chart Buttons

v0_02
The header of each page overwrote the data for the last line of the previous page. Fixed.
Added Version History page
Data no longer contains more than one header row
Added count for each type of question: GE/SP/EX/VT/network
Changed Count Analysis Method to SumIF
Changed Time Analysis Method to SumIF
Changed Earnings Analysis Method to SumIF
Pie Chart Capability for Analysis

v0_01
Completed Simple framework to Fetch Data
Created Simple Analysis Method

Compatibility
To the best of my knowledge, this is compatible with Excel 2003 and Excel 2007.
It is NOT compatible with Excel 2008 (Mac OS) or OpenOffice.

Found a Bug? Have suggestions?
I believe this should be bug-free in everything that it does. Please report bugs to me here. I'm also open to suggestions.

Usage:
You must enable your Macros to work with this spreadsheet. You can do this by lowering your security settings on Excel.

For Excel 2003:
Go to Tools > Macro > Security and make your changes. I have mine on Medium so I get prompted every time I open a worksheet requires macros.
For Excel 2007:
Click the Microsoft Office Button, and then click Excel Options. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category.

To Do List:
Analysis of Individual Referral Earnings
Start and End page
Wait time between questions
Pivot table reporting
Category Analysis