I've compiled the existing archinect list in excel from entries up to Oct 2008 (3558 total). It's an excel database with simple filters on them such as, age, location, gender, and type of workplace. Haven't been able to massage any of the data further due to lack of time this month, so the disclaimer is its going to be a very crude file in addition to all the methodological criticism of the data gathering as well as criticism related to data validity.
note: i've removed salaries based on hourly figures simply because of the work it would take to standardize the unit (annual vs hourly). Also, all currencies have been converted to US dollar based on exchange rates on Oct 22.
the file is about 8 megs. send me a msg on archinect with your email and ill send you the file. or if anyone knows how i can upload the file somewhere so it can be automatically downloaded that would be great too.
here's a screenshot example of what the file looks like.
in this case i've limited the search to those 35 years, at boutique type of workplace, any location.
if you want to cross reference the benefits each entry has a unique ID tag and when unfiltered a list of all the benefits and additional comments are viewable.
cheers... and hopefully archinect will soon revamp this section...
Wow - that's impressive! (I'm secretly a data geek)
If you organize by unique columns, sorting and pivot tables are much easier. For instance, you might want to consider a column for each piece of information - age, city, state, salary, etc.
What did you do - cut and paste each page of the salary poll? How long did it take you?
Archinect Salary - in excel
I've compiled the existing archinect list in excel from entries up to Oct 2008 (3558 total). It's an excel database with simple filters on them such as, age, location, gender, and type of workplace. Haven't been able to massage any of the data further due to lack of time this month, so the disclaimer is its going to be a very crude file in addition to all the methodological criticism of the data gathering as well as criticism related to data validity.
http://i393.photobucket.com/albums/pp15/jacques_pb/archinectexample.jpg >
note: i've removed salaries based on hourly figures simply because of the work it would take to standardize the unit (annual vs hourly). Also, all currencies have been converted to US dollar based on exchange rates on Oct 22.
the file is about 8 megs. send me a msg on archinect with your email and ill send you the file. or if anyone knows how i can upload the file somewhere so it can be automatically downloaded that would be great too.
here's a screenshot example of what the file looks like.
in this case i've limited the search to those 35 years, at boutique type of workplace, any location.
if you want to cross reference the benefits each entry has a unique ID tag and when unfiltered a list of all the benefits and additional comments are viewable.
cheers... and hopefully archinect will soon revamp this section...
link: http://i393.photobucket.com/albums/pp15/jacques_pb/archinectexample.jpg
link: http://i393.photobucket.com/albums/pp15/jacques_pb/archinectexample_b.jpg
Wow - that's impressive! (I'm secretly a data geek)
If you organize by unique columns, sorting and pivot tables are much easier. For instance, you might want to consider a column for each piece of information - age, city, state, salary, etc.
What did you do - cut and paste each page of the salary poll? How long did it take you?
Interesting! Keep us posted.
I went to the salary page then in the browser
View > Page Source
Save as .txt
opened it up in notepad
saved it as .prn
opened it in excel
After removing the extra stuff that might be better than cutting and pasting... or not.
For anyone interested I've put together a link to download the file directly.
It can be found here:
http://individual.utoronto.ca/cyu/
Fantastic - thank you jacques!
Wow! i love excel.... This is interesting.
Block this user
Are you sure you want to block this user and hide all related comments throughout the site?
Archinect
This is your first comment on Archinect. Your comment will be visible once approved.