I wanted to finalize my 2010 version before converting it. I think I've finally perfected the 2010 version. There is nothing I want to add to it. Therefore, I should be able to sit down and work on a version for older excel soon.epark84 wrote:hey 3link, the spreadsheet looks great but i only have excel 2002 on my laptop. do you plan to release a version for older excel users?
... Forum
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
-
- Posts: 21
- Joined: Sun May 02, 2010 1:06 am
Re: 3link's Study Spreadsheet
yeah that'd be great. thanks for all the time and effort that you've put into this
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
NP. I enjoy making stuff like this. It's always a great learning experience. I honestly knew very little about excel before starting this project.Nightrunner wrote:On behalf of all of TLS, I heartily cosign this.epark84 wrote:thanks for all the time and effort that you've put into this
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
11/6/10
I spotted a huge error this evening. The RC results column on the Prep. Tests sheet was acting up. I’ve corrected the error and updated the link accordingly.
All you need to do to fix your spreadsheet is to enter the following formula in cell N6 of the Prep Tests sheet:
=IFERROR(IF(VLOOKUP(B6&"ALL",Schedule!H:I, 2, FALSE)>0, IF(VLOOKUP(B6&"ALL",Schedule!H:W,15, FALSE)="", VLOOKUP(B6&"ALL",Schedule!H:I, 2, FALSE), VLOOKUP(B6&"ALL",Schedule!H:W,15, FALSE)), ""),"")
And then scroll the formula all the way to row 69 (where the Prep. Test table ends). If you require more explicit instructions, PM me and I’ll put something together with pictures.
I spotted a huge error this evening. The RC results column on the Prep. Tests sheet was acting up. I’ve corrected the error and updated the link accordingly.
All you need to do to fix your spreadsheet is to enter the following formula in cell N6 of the Prep Tests sheet:
=IFERROR(IF(VLOOKUP(B6&"ALL",Schedule!H:I, 2, FALSE)>0, IF(VLOOKUP(B6&"ALL",Schedule!H:W,15, FALSE)="", VLOOKUP(B6&"ALL",Schedule!H:I, 2, FALSE), VLOOKUP(B6&"ALL",Schedule!H:W,15, FALSE)), ""),"")
And then scroll the formula all the way to row 69 (where the Prep. Test table ends). If you require more explicit instructions, PM me and I’ll put something together with pictures.
- JustE
- Posts: 1330
- Joined: Tue Sep 28, 2010 8:49 pm
Re: 3link's Study Spreadsheet
You are the man. This could not have come at a better time.3|ink wrote:11/6/10
I spotted a huge error this evening. The RC results column on the Prep. Tests sheet was acting up. I’ve corrected the error and updated the link accordingly.
All you need to do to fix your spreadsheet is to enter the following formula in cell N6 of the Prep Tests sheet:
=IFERROR(IF(VLOOKUP(B6&"ALL",Schedule!H:I, 2, FALSE)>0, IF(VLOOKUP(B6&"ALL",Schedule!H:W,15, FALSE)="", VLOOKUP(B6&"ALL",Schedule!H:I, 2, FALSE), VLOOKUP(B6&"ALL",Schedule!H:W,15, FALSE)), ""),"")
And then scroll the formula all the way to row 69 (where the Prep. Test table ends). If you require more explicit instructions, PM me and I’ll put something together with pictures.
Want to continue reading?
Register now to search topics and post comments!
Absolutely FREE!
Already a member? Login
-
- Posts: 16
- Joined: Mon Aug 16, 2010 6:27 pm
Re: 3link's Study Spreadsheet
Great spreadsheet....you should copyright this info!
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Thanks.rare_commodity wrote:Great spreadsheet....you should copyright this info!
I'm not sure one can copyright something based entirely off of another copyrighted item (excel).
Edit: Out of curiosity, what does a 'conflict resolution' major comprise of? Is that like 'pre-law'? I ask because I've seen it before and I'm dying to know.
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Exciting news! I just finsihed a version designed to work with older versions of excel. Most of the same functions are there, but it's slower and no where near as pretty.
I have posted the link on the OP. Enjoy
I have posted the link on the OP. Enjoy
-
- Posts: 16
- Joined: Mon Aug 16, 2010 6:27 pm
Re: 3link's Study Spreadsheet
Tehehehe good question. It's wear you trade in your money making hat for a helpers had.No but in all seriousness you just learns skills of how to be a better mediator or person to help people through their disputes...like a counselor but not strictly tied to crazy people. I thought it would help me be a better public interest lawyer. We will see....
3|ink wrote:Thanks.rare_commodity wrote:Great spreadsheet....you should copyright this info!
I'm not sure one can copyright something based entirely off of another copyrighted item (excel).
Edit: Out of curiosity, what does a 'conflict resolution' major comprise of? Is that like 'pre-law'? I ask because I've seen it before and I'm dying to know.
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Ohhhh...like ADR.rare_commodity wrote:Tehehehe good question. It's wear you trade in your money making hat for a helpers had.No but in all seriousness you just learns skills of how to be a better mediator or person to help people through their disputes...like a counselor but not strictly tied to crazy people. I thought it would help me be a better public interest lawyer. We will see....
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Made a minor cosmetic update today. You notice how every date in the tracking graph has a coma after it? It's been driving me crazy since 3.3 was released. Anyway, it's not an issue any more.
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Some people have informed me that this spreadsheet is too complicated and the instructions are convoluted. I was afraid of this. To resolve this, I am creating tutorial video to be posted on Youtube. The video should make things clearer. I expect to complete the video sometime this week. A link to the video will be posted on the OP once it is ready.
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Here's a preview of my upcoming video tutorial:
http://www.youtube.com/watch?v=AYzAaJ2yUDo
Thanks to those from the social lounge who provided valuable commentary.
http://www.youtube.com/watch?v=AYzAaJ2yUDo
Thanks to those from the social lounge who provided valuable commentary.
Register now!
Resources to assist law school applicants, students & graduates.
It's still FREE!
Already a member? Login
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Thanks. There weren't many good reviews. I'm going back to the drawing board. At this rate, it would have taken another 10 minutes of video to cover the features anyway. I'm just going to keep it short and simple.YCrevolution wrote:Lookin' good.3|ink wrote:Here's a preview of my upcoming video tutorial:
http://www.youtube.com/watch?v=AYzAaJ2yUDo
Thanks to those from the social lounge who provided valuable commentary.
-
- Posts: 3
- Joined: Wed Nov 24, 2010 2:39 pm
Re: 3link's Study Spreadsheet
I thought the spreadsheet was really nerdy and pathetic. Then I saw the video.
At least other threads in this forum seem like they can help me study!
GO BLUE!
At least other threads in this forum seem like they can help me study!
GO BLUE!
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Thanks for your inputgobluemich wrote:I thought the spreadsheet was really nerdy and pathetic. Then I saw the video.
At least other threads in this forum seem like they can help me study!
GO BLUE!
Anyway, I just released version 3.4 today. The difference? I upped the max from 4 months to 6 months of study. I also did some work on the graphs to make them easier to see and I changed the dropdown menus for the tracking feature so they don't always look like a bunch of blank spaces. I haven't perfected the latter feature yet, but I'll fix it evetually.
I'm done with this thing until after my applications are finished (unless someone shows me a significant glitch).
Happy Thanksgiving!
PS: I also updated the poll to remove the "more than 4 months of study" option since the spreadsheet now has that. This inadvertently cleared the results.
Get unlimited access to all forums and topics
Register now!
I'm pretty sure I told you it's FREE...
Already a member? Login
- chup
- Posts: 22942
- Joined: Sun Sep 23, 2007 10:48 pm
Re: 3link's Study Spreadsheet
This thing makes my eyes bleed.
Also, you're taking the LSAT, not launching a shuttle into orbit.
Also, you're taking the LSAT, not launching a shuttle into orbit.
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Sorry to hear that. Excel is the second most used software in the workplace. I don't know how you'll ever get a job if spreadsheets like this hurt your eyes.aschup wrote:This thing makes my eyes bleed.
I can understand why it may seem complicated to those who are not familiar with excel. That's why I provided instructions.aschup wrote:Also, you're taking the LSAT, not launching a shuttle into orbit.
Thanks for playing.
- chup
- Posts: 22942
- Joined: Sun Sep 23, 2007 10:48 pm
Re: 3link's Study Spreadsheet
OK, I'll explain myself more thoroughly since you seem intent on butthurt whenever someone criticizes you.
It's not a question of usefulness, and just because it's Excel doesn't make it zOMG totally worth my time. It makes my eyes bleed because of all the colors and clutter of information.3|ink wrote:Sorry to hear that. Excel is the second most used software in the workplace. I don't know how you'll ever get a job if spreadsheets like this hurt your eyes.aschup wrote:This thing makes my eyes bleed.
It's not a matter of being complicated, but of being more work than is worth it -- or (as is often the case with law students and pre-law students) -- creating unnecessary work with no point. For example, what's the added value of having a graph like this? What does this do that simply paying attention to and noting what kinds of questions you tend to be missing can't?3|ink wrote:I can understand why it may seem complicated to those who are not familiar with excel. That's why I provided instructions.aschup wrote:Also, you're taking the LSAT, not launching a shuttle into orbit.
Thanks for playing.
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
Actually, you're frequent trolling on the social lounge is what makes you a suspicious tool. Besides, I've taken criticism before. Yours lacks substance and is therefore thinly veiled trolling.aschup wrote:OK, I'll explain myself more thoroughly since you seem intent on butthurt whenever someone criticizes you.
How does my response pertain to usefulness? If spreadsheets make your eyes bleed, that's a serious disadvantage. I'm sorry to hear that. I never said this is totally worth your time because it's excel. That had nothing to do with my statement.aschup wrote: It's not a question of usefulness, and just because it's Excel doesn't make it zOMG totally worth my time.
This is the first real and credible critique you have offered. Thank you. Was that so hard?aschup wrote: It makes my eyes bleed because of all the colors and clutter of information.
There aren’t that many colors. If this is confusing, god help you.
Did you score your practice tests? Did you keep track of the question types you were missing? Is it really more work than is necessary to keep track of your missed questions? Perhaps some don’t need to do this. I’m glad you got away without doing this when you studied. However, I think many will tell you that this practice has its advantages.aschup wrote: It's not a matter of being complicated, but of being more work than is worth it-- or (as is often the case with law students and pre-law students) -- creating unnecessary work with no point.
First, can I ask whether or not this graph was part of your ‘cluttered’ argument? If you even bothered to open this thing, or if you read the instructions (which I’m sure you did before criticizing because you’re clearly not a troll), you’d know that you can adjust the fields to reflect only certain dates and certain question types. Here’s the page from the instructions that you missed:aschup wrote: For example, what's the added value of having a graph like this? What does this do that simply paying attention to and noting what kinds of questions you tend to be missing can't?
This is the same exact graph from the image you posted. The difference is that I manipulated the fields (by the simple push of a button) to display only the red trend line. One could also manipulate the dropdown menus above the graph to change the date criteria. You don’t have to view your results from day one. You could just view your results for a given week of your preference.
To answer your question more directly, I think most people will find it helpful to keep track of the question types they are missing. That’s how they know what question types they should spend the most time reviewing. I don’t know about you, but when I was studying for the LSAT, I went over every question I missed on my PTs. However, I would spend more time on some question types than others: specifically the question types I had been historically weak with. I spent less time on those that I miss a few of here and there. I didn’t have this graph to help me out. I personally remembered the question types that haunted me the most. I suspect most people can do the same on their own with some effort. This graph makes that a little easier.
That graph displays the top 10 question types you missed the most. Moreover, that graph also ranks those question types by series. In other words, the red series (that red line) will always be the question type you miss most often. The orange will always be your second most prevalently missed question type. This graph doesn’t ask that you memorize a bunch of color codes beyond the usual red (high priority) to while (low priority).
Lastly, the graph automatically updates this information for you when you enter your results for a given day. If you think entering your results for a given day is more labor than is necessary, you’re welcome to your opinion. I think you’ll find NR disagrees with you if you check the bottom of page one of this thread. I don’t take that as NR’s approval of this spreadsheet, but I take it as his acknowledgement of the importance of recording and monitoring this data.
I know you’ve had a hard on for me ever since I bad-mouthed your troll friends. Please try and keep it in the social lounge. If you want to criticize my spreadsheet further, you are welcome to. Please make sure you use it first so your next criticism has some credibility.
Last edited by 3|ink on Wed Nov 24, 2010 5:27 pm, edited 1 time in total.
Communicate now with those who not only know what a legal education is, but can offer you worthy advice and commentary as you complete the three most educational, yet challenging years of your law related post graduate life.
Register now, it's still FREE!
Already a member? Login
-
- Posts: 7445
- Joined: Tue Feb 24, 2009 5:47 am
Re: 3link's Study Spreadsheet
butthurt
In the interest of having more options on the market. I'm offering a counter spreadsheet
In the a column you can write question types, in B you can put the average number of times it appears per test, in C the average number of times you get in incorrect. In D maybe links to porn sites.
Adjust the colors how ever you like.
In the interest of having more options on the market. I'm offering a counter spreadsheet
In the a column you can write question types, in B you can put the average number of times it appears per test, in C the average number of times you get in incorrect. In D maybe links to porn sites.
Adjust the colors how ever you like.
Last edited by D. H2Oman on Wed Nov 24, 2010 5:28 pm, edited 1 time in total.
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
D. H2Oman wrote:butthurt
Translation:
D. H2Oman wrote:I'm a tool with nothing better to do with his life than troll internet forums.
- Holly Golightly
- Posts: 4602
- Joined: Wed Jan 13, 2010 10:30 am
Re: 3link's Study Spreadsheet
Marry me?D. H2Oman wrote:butthurt
In the interest of having more options on the market. I'm offering a counter spreadsheet
In the a column you can write question types, in B you can put the average number of times it appears per test, in C the average number of times you get in incorrect. In D maybe links to porn sites.
Adjust the colors how ever you like.
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: 3link's Study Spreadsheet
What a rebel. Someone should give you a sticker.D. H2Oman wrote:In the a column you can write question types, in B you can put the average number of times it appears per test, in C the average number of times you get in incorrect. In D maybe links to porn sites.
Adjust the colors how ever you like.
Seriously? What are you waiting for?
Now there's a charge.
Just kidding ... it's still FREE!
Already a member? Login