Excel acrobatics
Discussion
Not sure iof this is best in P&P or Computers but here goes;
Anybody know a load about Excel?
I have just had a data file sent to me with 3800 scores in (lets say they are exam scores; pretend I work for ETS).
What I need is the individual scores which are curently in single rows (with 4 'sub scores per test), into a single row with all the test scores for that person. There are about 70 tests for each person. The confounding bit is that those 70 tests are from a list of 80 tests so it isn't just a case of sorting by the test name and then transposing the data; everyone has some gaps.
As this is a one-off I can just get some poor student to do it manually but I think that is a week's or more's work by hand to sort 3800 x 4 scores and manualy re-input them in exactly the right place and I need it sooner if at all possible.
I think my software guy could write me a routine (if he wasn't in Antiga) but even that will take a few weeks to get sorted aroound his other work.
Anybody know a load about Excel?
I have just had a data file sent to me with 3800 scores in (lets say they are exam scores; pretend I work for ETS).
What I need is the individual scores which are curently in single rows (with 4 'sub scores per test), into a single row with all the test scores for that person. There are about 70 tests for each person. The confounding bit is that those 70 tests are from a list of 80 tests so it isn't just a case of sorting by the test name and then transposing the data; everyone has some gaps.
As this is a one-off I can just get some poor student to do it manually but I think that is a week's or more's work by hand to sort 3800 x 4 scores and manualy re-input them in exactly the right place and I need it sooner if at all possible.
I think my software guy could write me a routine (if he wasn't in Antiga) but even that will take a few weeks to get sorted aroound his other work.
Just let me know your requirements of how you want the data analyzed, what metrics you want etc. and I can do one off excercise for you.
If you want something in excel to do it on a permanent basis it might take a little longer.
I'm in a meeting for the next 3 hours so let me know if you want anything done and I can get back to you at lunchtime.
If you want something in excel to do it on a permanent basis it might take a little longer.
I'm in a meeting for the next 3 hours so let me know if you want anything done and I can get back to you at lunchtime.
Edited by merc_man on Friday 25th July 09:26
merc_man said:
Just let me know your requirements of how you want the data analyzed, what metrics you want etc. and I can do one off excercise for you.
If you want something in excel to do it on a permanent basis it might take a little longer.
I'm in a meeting for the next 3 hours so let me know if you want anything done and I can get back to you at lunchtime.
You know this is exactly why I really like Pistonheads! Really generous- Well done merc_man If you want something in excel to do it on a permanent basis it might take a little longer.
I'm in a meeting for the next 3 hours so let me know if you want anything done and I can get back to you at lunchtime.
Edited by merc_man on Friday 25th July 09:26

Brown and Boris said:
Not sure iof this is best in P&P or Computers but here goes;
Anybody know a load about Excel?
I have just had a data file sent to me with 3800 scores in (lets say they are exam scores; pretend I work for ETS).
What I need is the individual scores which are curently in single rows (with 4 'sub scores per test), into a single row with all the test scores for that person. There are about 70 tests for each person. The confounding bit is that those 70 tests are from a list of 80 tests so it isn't just a case of sorting by the test name and then transposing the data; everyone has some gaps.
As this is a one-off I can just get some poor student to do it manually but I think that is a week's or more's work by hand to sort 3800 x 4 scores and manualy re-input them in exactly the right place and I need it sooner if at all possible.
I think my software guy could write me a routine (if he wasn't in Antiga) but even that will take a few weeks to get sorted aroound his other work.
If merc_man doesn't / can't deliver - feel free to drop me an email via my profile, this doesn't sound like a big job TBHAnybody know a load about Excel?
I have just had a data file sent to me with 3800 scores in (lets say they are exam scores; pretend I work for ETS).
What I need is the individual scores which are curently in single rows (with 4 'sub scores per test), into a single row with all the test scores for that person. There are about 70 tests for each person. The confounding bit is that those 70 tests are from a list of 80 tests so it isn't just a case of sorting by the test name and then transposing the data; everyone has some gaps.
As this is a one-off I can just get some poor student to do it manually but I think that is a week's or more's work by hand to sort 3800 x 4 scores and manualy re-input them in exactly the right place and I need it sooner if at all possible.
I think my software guy could write me a routine (if he wasn't in Antiga) but even that will take a few weeks to get sorted aroound his other work.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff



