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

Thanks for those who've provided Feedback!

Thanks to you users, this "program" will have the most relevant and accurate gadgets around. A firm handshake to those who've provided feedback, and a big holiday hug to those who have volunteered to become a tester. Your help is much appreciated.

With the holidays coming up, and a few personal things (a couple of tests, and jury duty), I don't know how much time I will have to spend on this in the upcoming weeks, but I'll try my best. Every minute I was out today, I couldn't wait to come back home and check to see how many people tried this!

My fingers were freezing, but after typing all the responses and this blog post, I think I'm ready to code again. I have a few minutes before bedtime!

Status Report: ChaCha Scraping Spreadsheet

Good progress on the spreadsheet, methinks. Here's the current checklist of what I've done and what I plan to do before releasing:

• The actual web scraping macro
• Password log-on given password in worksheet
• Data backup onto a specific sheet
• Simple analytics (total questions, average time, etc)
• Buttons to start the process

I'm happy with the progress. At this rate, I think I should be able to post the first beta version up by Saturday. I hope so!

And for you coders... I know there's going to be TONS of useless /repetitive coding in my project. I don't even know what half these functions do.... In the last few days, its just been searching for already-written code on the internet, and disecting it for this purpose.

I have a feeling that the spreadsheet isn't going to work for everyone, and that I'm going to have to apologize because I won't be able to troubleshoot/debug.

In the meantime, can anybody help me think of a name for this project? =)

A small teaser, import your ChaCha history!

Introducing.... an automated ChaCha history grabber:

Okay, I'm very excited about this project, and I hope that you are just as much as I am. However, I cannot give you a to-be-finished date, as I don't even know if my programming skills even allow me to finish it. I'm trying to automate the process of importing all your query data you have on your Earnings/Current tab into Excel using Macros.

How is this useful?

Well, being a data FREAK, I love seeing statistics of things. Here's a tiny tiny tiny example of what you can find with this data:

The possibilities are endless. Being able to visualize the statistics with graphs and charts, being able to track your history and performance on ChaCha.....

That being said, I have to put the following disclaimer: I've NEVER done VBA / macro programming before, and there is a high chance that this project will never be completed. I only have basic HTML / C++ knowledge, and was GLAD that this project got this far. If you are experienced with this stuff, and willing to volunteer your time to help, please send me an email at rnhung@gmail.com .

Thank you!