Page 1 of 4

...

Posted: Wed Oct 13, 2010 4:40 pm
by 3|ink
...

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 4:47 pm
by LSAT Blog
Amazing! You've done Al Swearengen proud.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 4:48 pm
by CGI Fridays
...

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 4:49 pm
by 3|ink
LSAT Blog wrote:Amazing! You've done Al Swearengen proud.
Too bad he can't use this spreadsheet. It's hard as hell to type with a missing finger.

Thanks for the kudos.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 4:53 pm
by GoGetIt
Thank you very much 3ink. This spreadsheet will make my life way easier.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 5:04 pm
by 3|ink
GoGetIt wrote:Thank you very much 3ink. This spreadsheet will make my life way easier.
Thank you. Enjoy.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 5:11 pm
by Miracle
Love it!!!!!!!

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 5:31 pm
by epark84
hey 3link, do you have available a version that would work with Excel 2002? unfortunately i don't have the newer one. thanks!

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 5:31 pm
by op-ti
This is really awesome! :D

Thank you 3link! :mrgreen: :oops:

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 5:39 pm
by epark84
oh nevermind, i was able to open it. thanks!

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 5:53 pm
by 3|ink
epark84 wrote:oh nevermind, i was able to open it. thanks!
Many of the functions probably won't work. I'll have a version for older excel users soon.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 5:54 pm
by Ndkrto
Jesus....

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 6:38 pm
by 3|ink
Ndkrto wrote:Jesus....
Not sure if I should take that as good or bad, but I'll take it anyway.

Feel free to crack the spreadsheet open and see how it ticks if you're interested.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 6:42 pm
by Jack Smirks
Good work on making this a week after I took the LSAT. Well done.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 7:00 pm
by 3|ink
naterj wrote:Good work on making this a week after I took the LSAT. Well done.
Sorry dude. I actually made the bulk of it 2 months ago. However, it was exhausting. My scores suffered whenever I worked on this. I had to put it off until after the test.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 7:36 pm
by traehekat
naterj wrote:Good work on making this a week after I took the LSAT. Well done.

:roll: Man, how could he not stop and think about YOU, naterj.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 9:05 pm
by typ3
Just a suggestion, you should include an auto updating graph at the bottom of it. One graph for overall score, and perhaps bar charts for number of questions missed per section.

Re: 3link's Study Spreadsheet

Posted: Wed Oct 13, 2010 10:22 pm
by 3|ink
typ3 wrote:Just a suggestion, you should include an auto updating graph at the bottom of it. One graph for overall score, and perhaps bar charts for number of questions missed per section.
At the bottom of what? The 'Schedule' page? Then people would have to scroll all the way down to view it every time. It'd be easier to put a mini graph like that on the top where the panes are frozen. However, I feel that'd be redundant. That's what the 'Trends' page is for. I already have a graph that tracks this on there.

I'm curious about the bar charts. Should it be a different bar chart for each test? I think a line graph would be better at showing the trend.

Re: 3link's Study Spreadsheet

Posted: Thu Oct 14, 2010 1:40 pm
by CGI Fridays
3|ink wrote:I think a line graph would be better at showing the trend.
Agreed.

Stellar work.

Re: 3link's Study Spreadsheet

Posted: Thu Oct 14, 2010 2:31 pm
by typ3
Bump,

I have nothing to add other than the mods should sticky this thread.

Re: 3link's Study Spreadsheet

Posted: Thu Oct 14, 2010 4:35 pm
by 3|ink
typ3 wrote:Bump,

I have nothing to add other than the mods should sticky this thread.
Thanks, but they'd never do that :(
CGI Fridays wrote:Stellar work.
Thanks :)

Re: 3link's Study Spreadsheet

Posted: Thu Oct 14, 2010 4:37 pm
by op-ti
3|ink wrote:
typ3 wrote:Bump,

I have nothing to add other than the mods should sticky this thread.
Thanks, but they'd never do that :(
Why not? This ought to be a stick.

Re: 3link's Study Spreadsheet

Posted: Thu Oct 14, 2010 5:19 pm
by typ3
This is worthy of a stick.

Regardless of whether you use Pithy's method or not. This has every PT, every section trackable, plus graphs built in. It's easily one of the top 3 posts ever on TLS. Why not reward the work and effort the op put in?

Another possible graph / category you could add to the spread is to track time it takes to complete each section. Might not be too important, but late in the phase it's nice to know if you're averaging under 33 minutes per section so that test day anxiety / any curve ball won't throw you over 35.

Re: 3link's Study Spreadsheet

Posted: Thu Oct 14, 2010 5:36 pm
by typ3
One bug, I can't get the days left until the test to update according to the date. However, I don't know if this is because I converted the file to excel 2010. I can get it to count up, but not down according to the date.

Re: 3link's Study Spreadsheet

Posted: Thu Oct 14, 2010 5:43 pm
by typ3
Nightrunner wrote:Awesome spreadsheet, dude.

NOTE TO TEST PREPPERS: make sure you also track "types" of questions you get wrong, and look for patterns.

For example, I noticed I kept picking the second-best answer in "most weakens," so I practiced on those questions especially to improve.
I was thinking about this, it would be nice to have a way to insert what types of questions you missed her section, but I don't know how 3link could do this without making the data entry tedious for those using it.