2013-2014 Admissions Spreadsheets Forum

[NYC-WVU]

In no way do I condone people messing with the spreadsheets - if they really want to play around with the numbers, they should copy everything into a new spreadsheet where they can do whatever they want. On the other hand, if people are consistently being obnoxious about this, why don't you lock the filled pages, add new input pages and periodically transfer the data from the new input pages into the locked filled page. I'm sure there are a few people that you could give access to who would help you out in the transferring.

[lawschool22]

In no way do I condone people messing with the spreadsheets - if they really want to play around with the numbers, they should copy everything into a new spreadsheet where they can do whatever they want. On the other hand, if people are consistently being obnoxious about this, why don't you lock the filled pages, add new input pages and periodically transfer the data from the new input pages into the locked filled page. I'm sure there are a few people that you could give access to who would help you out in the transferring.

The problem with that is when people need to add updates (interview date, acceptances, etc.) they wouldn't have access to the main data tab, so you would also have to monitor their updates and update the main data tab accordingly. I don't think it's feasible unfortunately.

[NYC-WVU]

In no way do I condone people messing with the spreadsheets - if they really want to play around with the numbers, they should copy everything into a new spreadsheet where they can do whatever they want. On the other hand, if people are consistently being obnoxious about this, why don't you lock the filled pages, add new input pages and periodically transfer the data from the new input pages into the locked filled page. I'm sure there are a few people that you could give access to who would help you out in the transferring.

The problem with that is when people need to add updates (interview date, acceptances, etc.) they wouldn't have access to the main data tab, so you would also have to monitor their updates and update the main data tab accordingly. I don't think it's feasible unfortunately.

Good point, I hadn't thought of that. My bad.

[Kimikho]

"your friendly neighborhood scoobers"

[lawschool22]

"your friendly neighborhood scoobers"

It seemed to fit . I it contrasted with your message well I thought

[McAvoy]

I'm confused -- why would people be offended by sorting for LSATs, acceptances, and complete dates? It actually makes the data useful...

[midwest17]

I'm confused -- why would people be offended by sorting for LSATs, acceptances, and complete dates? It actually makes the data useful...

Because people keep screwing it up.

[midwest17]

double post

[lawschool22]

I'm confused -- why would people be offended by sorting for LSATs, acceptances, and complete dates? It actually makes the data useful...

Some people do not know how to properly sort or filter the data. For example they only sort one column which then mis-aligns the data and makes it useless.

The data is primarily useful because of the first tab I created. As I mentioned in my initial post, if there is something people want to see or learn from the data that they can't already do from the analytics tab, I would be happy to write a new formula that displays the data in whatever format is needed

[McAvoy]

Ah, that seems reasonable, then. Dummies

[midwest17]

LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.

[lawschool22]

LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.

I'll look into it. Sorry for the delay.

[lawschool22]

LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.

I'll look into it. Sorry for the delay.

I didn't see that example...from what I can tell everything looks okay. But if there is still an issue let me know!

[midwest17]

LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.

I'll look into it. Sorry for the delay.

I didn't see that example...from what I can tell everything looks okay. But if there is still an issue let me know!

I think I may have just been flipping the LSAT and GPA percentile cells in my head....

[lawschool22]

LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.

I'll look into it. Sorry for the delay.

I didn't see that example...from what I can tell everything looks okay. But if there is still an issue let me know!

I think I may have just been flipping the LSAT and GPA percentile cells in my head....

Ha no worries - I'd rather it be that than some major thing I have to fix

[ZipWhenSheMoves]

Did the URM category disappear from the GULC spreadsheet?

[scoobysnax]

Does anyone know where we can find last year's data on how many offers schools made v. actual enrollment? I think I saw a link somewhere on this forum but I can't find it.

[TheMostDangerousLG]

Does anyone know where we can find last year's data on how many offers schools made v. actual enrollment? I think I saw a link somewhere on this forum but I can't find it.

Here are some very general statistics on how many people got into schools versus how many people enrolled: http://www.lsac.org/lsacresources/data/ ... me-summary

[Babum]

What about adding a small display stating how many of those accepted were ED and how many weren't?

Just as a suggestion to making these great tools handier.

[kris4842]

Also on another board this was extremely helpful, just google x school and standard 509 report and it tells you everything

[Trig]

LS22,

Thanks so much for all the spreadsheets. On the Harvard spreadsheet can you include the % of applicants with a JS1 who have been accepted so far?

Thanks!

[lawschool22]

LS22,

Thanks so much for all the spreadsheets. On the Harvard spreadsheet can you include the % of applicants with a JS1 who have been accepted so far?

Thanks!

Added! It's in the JS1 section. Good suggestion. Thanks!

[Nonconsecutive]

Added! It's in the JS1 section. Good suggestion. Thanks!

Thanks for doing that, glad to see you keeping on top of your spreadsheet army.

[Black_Swan]

THANK YOU

Nice picture! Do you work for lsac?

[Kimikho]

LS22 what did your lsat tracking spreadsheets look like?