The 2008 VTAC offers list

[BenBenMan]

I became a bit bored, so I took the VTAC offers list from the Herald Sun's site and merged it into one big file. It makes it a little easier to search, and you can easily find everyone in your postcode, or everyone that's doing your course.

Note that loading up either the HTML file or the Excel 2003 file might make your computer bog down: this is because it's a pretty big list. The Excel file is 24mb, the HTML file is 18mb. Both are in this 1.63mb RAR file.

[bturville]

Gee the RAR compression worked damn well, hey!

[maxleng]

awsome stuff man!

edit: that has to be the most annoying upload site haha

[gfb]

Thanks mate great stuff. I appreciate your effort!

[BenBenMan]

edit: that has to be the most annoying upload site haha

Yeah good point, I didn't notice how bad that upload site was until after I posted the file I've reuploaded it to my server and updated the link in the first post, so now there's a direct download with 100% less ads.

[Daniel15]

Nice work, Ben

I exported the data as a CSV file, then imported it into MySQL. Allows me to get some interesting statistics (anyone that knows me would know that raw data + me = random statistics )

Top 10 courses ("first round"):

mysql> SELECT first_round, COUNT(first_round) AS count FROM offers GROUP BY first_round ORDER BY count DESC LIMIT 10;
+-------------+-------+
| first_round | count |
+-------------+-------+
|       38001 |  1374 |
|       38271 |   782 |
|       38101 |   488 |
|       28451 |   408 |
|       38171 |   304 |
|       21711 |   297 |
|       28131 |   295 |
|       27231 |   283 |
|       14101 |   260 |
|       38891 |   258 |
+-------------+-------+


Top 10 courses ("second round"), 0 means someone no second round offer:

mysql> SELECT second_round, COUNT(second_round) AS count FROM offers GROUP BY second_round ORDER BY count DESC LIMIT 10;
+--------------+-------+
| second_round | count |
+--------------+-------+
|            0 | 33311 |
|        38102 |    62 |
|        28252 |    53 |
|        38002 |    52 |
|        28132 |    52 |
|        91702 |    50 |
|        91302 |    50 |
|        38242 |    44 |
|        92822 |    43 |
|        28342 |    38 |
+--------------+-------+
10 rows in set (0.06 sec)


Top 10 postcodes:

mysql> SELECT postcode, COUNT(postcode) AS count FROM offers GROUP BY postcode ORDER BY count DESC LIMIT 10;
+----------+-------+
| postcode | count |
+----------+-------+
|     3150 |   561 |
|     3029 |   391 |
|     3216 |   363 |
|     3152 |   361 |
|     3095 |   358 |
|     3199 |   344 |
|     3178 |   340 |
|     3350 |   335 |
|     3021 |   335 |
|     3030 |   332 |
+----------+-------+
10 rows in set (0.08 sec)


And now... Some kinda useless ones
Top 10 surnames

mysql> SELECT surname, COUNT(surname) AS count FROM offers GROUP BY surname ORDER BY count DESC LIMIT 10;
+----------+-------+
| surname  | count |
+----------+-------+
| Smith    |   250 |
| Nguyen   |   249 |
| Tran     |   141 |
| Jones    |   140 |
| Williams |   128 |
| Brown    |   127 |
| Wilson   |   121 |
| Taylor   |   120 |
| Lee      |   103 |
| Anderson |    90 |
+----------+-------+
10 rows in set (0.10 sec)


Top 10 initials

mysql> SELECT initials, COUNT(initials) AS count FROM offers GROUP BY initials ORDER BY count DESC LIMIT 10;
+----------+-------+
| initials | count |
+----------+-------+
| A        |   826 |
| S        |   752 |
| M        |   690 |
| J        |   596 |
| AJ       |   592 |
| MJ       |   539 |
| SJ       |   490 |
| JA       |   462 |
| JM       |   425 |
| D        |   410 |
+----------+-------+
10 rows in set (0.11 sec)

[aidansteele]

Seems I was beaten to the punch, but I put a similar tool on my website - which might be a bit easier for everyone to use: http://aidans.org/offers/

[Collin Li]

Hey good work dude. That thing has a nice clean interface.

[Daniel15]

aidansteele, nice work! .
I was thinking of doing something similar, but didn't have time to do it
Fix your HTML; it lacks a DOCTYPE (and you should probably use a <label> tag around the labels)

[maxleng]

Seems I was beaten to the punch, but I put a similar tool on my website - which might be a bit easier for everyone to use: http://aidans.org/offers/

this thing is awsome!!! so easy to use

and lists everyone in your course!! great work!

[Quppa]

Looks like everyone had the same idea as me.

My lists don't offer anything very exciting, but here they are anyway:

http://rapidshare.com/files/83950632/Offers__08.rar.html Updated
http://rapidshare.com/files/83729421/Offers__07.rar.html

I've included the raw data from 2007 and 2008 (thanks BenBenMan, you saved me a lot of work copying it over), along with files sorted by course (in a uni\campus directory structure) and by postcode. There is also a file in each package with the list of course codes.

[Daniel15]

Seems I was beaten to the punch, but I put a similar tool on my website - which might be a bit easier for everyone to use: http://aidans.org/offers/

A bug I noticed: The script is broken for people with spaces in their last name, and it's interpreting their post code as their course code. Enter 3056 (my post code) into the "Course Code" box, for instance.

[kido_1]

Very nice work.
Although i don't understand computer language. (:

[Ninox]

ROFL, the Nguyens always outnumber everyone. nice work Ben!! I was hoping someone would do this, it makes it easier to search for people than poring over the paper

[vce_2007]

just to say somthing that those aren't second round offers but full fee offers