Need some help from an EXCEL GURU!

[Smoke]

I am looking for a long term solution to the acquisition and manipulation of SETI data that is published by Seti At Home.

I really hate that I am operating programs over which I have no control. I do a lot of work with Excel and it seems I should be able to accomplish all I want to do within its vast capabilities.

It is an easy thing to IMPORT DATA from web pages. If our membership was static I could accomplish everything I want to do but our membership is not static ? thank goodness. 🙂

There is one ?crunch point? that I do not know how to handle. I am hoping that some of you Excel Gurus can help me. How can I compare today?s imported data with data that was imported previously? Each day, because we are dynamic, members move up or down in the team?s rankings. Yesterday MemberX might have been in 877th place but today he is in 876th place; how can Excel do a LOOKUP of MemberX?s data points yesterday and place them next to MemberX?s data points today?

I believe this is doable with the LOOKUP series of functions but I can?t figure out how.

I know some of you programmers could do this. Sqiz did it magnificently with SetiTEAM but without his further support, SetiTEAM is sitting on shaky ground and could be gone overnight. Therefore if I can figure out how to get past the above mentioned ?crunch point? using Excel I would be able to FIX any change that Seti At Home may make to the way they display their data in the future.

Your help would be most appreciated.

 

[Orange Kid]

This may or may not be what you are looking for 🙂

 

[bot2600]

If not, you could have the info dumped into a database and use excel to pull the data from the database. You could use access and have the quieries right in access and pull them to excel.

Bot

 

[Smoke]

bot2600, Now that is a good idea. I have never really worked with Access but that is exactly what it is for. Hmmm. I'll go check it out.

OrangeKid, I've looked at that program before and it cannot be used for large teams. I will inspect it again for some reverse engineering opportunities.

Anyone know how to use the LOOKUP Functions?

 

[cmarc]

Supposing you have 2 spreadsheets (one for each day) with :
1) User Name,
2) Rank,
3) Results received,
4) Total CPU time,
5) average CPU time,
You could add to either spreadsheet columns for comparisons by using the Vlookup function.
Vlookup(<Rank in current spreadsheet(ie A2)>, <Range of values to lookup (ie 'Yesterday'!$A:$E)>,<Column number (ie 2 for rank)>,0)
One problem with this approach is all the users with a blank name.
Hope this helps,
Marc

 

[Smoke]

cmarc,

I would like to send you an Excel Spreadsheet upon which you could construct the VLOOK function for me. I have tried and tried and I cannot figure out how to do it to get the correct "lookup".

You do not have PM enabled and I see you have just joined the AT Forums. You can enable the PM funtion by clicking on the PROFILE tab at the top of the page and answer YES to "Allow Private Messages?".

Thank you. 🙂

 

[SoulAssassin]

Smokeball-

I've done a few vlookups before. PM me if you need some help and we can discuss further.