Spreadsheet for Tracking Your Applications Forum

benwyatt · Post by **benwyatt** » Mon Jul 27, 2015 4:50 pm

Hey folks,

I put a lot of effort into this spreadsheet and figured it might be of use or interest to more of you.

UPDATE 8/5: Added Application Live Dates for all the ones I could find

https://docs.google.com/spreadsheets/d/ ... sp=sharing

It has a number of conditional formatting rules for helping to visualize the data including:

If you have a fee waiver and are applying the row turns green
If you have a fee waiver and aren't applying it turns blue
If you are applying but don't have a fee waiver it turns blue
If you have completed and submitted your application the row turns gray
As you receive scholarship offers the financial aid cell will turn green (darker shades with greater amounts)

There are also formulas that will tell you your total # of fee waivers, schools you're applying to and what the total cost of your applications are.

Feel free to download it or copy it to your google account, I just wanted to give back to the TLS community. Let me know if you have any ideas for improving it!
All the data currently displayed is just for simulation purposes.

basedvulpes · Post by **basedvulpes** » Mon Jul 27, 2015 5:32 pm

Post removed.

benwyatt · Post by **benwyatt** » Mon Jul 27, 2015 5:34 pm

Post removed.

MajinBuu · Post by **MajinBuu** » Mon Jul 27, 2015 5:38 pm

Thanks! I made myself a copy

slippin_jimmy · Post by **slippin_jimmy** » Mon Jul 27, 2015 6:01 pm

Post removed.

benwyatt · Post by **benwyatt** » Tue Jul 28, 2015 11:13 am

Post removed.

Generally · Post by **Generally** » Tue Jul 28, 2015 1:23 pm

Post removed.

benwyatt · Post by **benwyatt** » Tue Jul 28, 2015 1:36 pm

Post removed.

benwyatt · Post by **benwyatt** » Wed Aug 05, 2015 12:37 pm

Post removed.

KMart · Post by **KMart** » Wed Aug 05, 2015 12:45 pm

I wish I had this last year

.

PrincessUnikitty · Post by **PrincessUnikitty** » Thu Aug 06, 2015 3:46 am

This is awesome! I'll be using it. Thanks so much!

gamerish · Post by **gamerish** » Thu Aug 06, 2015 1:37 pm

Post removed...

benwyatt · Post by **benwyatt** » Thu Aug 06, 2015 1:39 pm

Post removed.

Procyon · Post by **Procyon** » Thu Aug 06, 2015 9:31 pm

Thanks for making this spreadsheet.

If you try applying to Duke form your school list on LSAC, it says the JD application is available on August 18.

fisheatbananas · Post by **fisheatbananas** » Thu Aug 06, 2015 10:27 pm

nice. wish i had this when i was applying last cycle lol

benwyatt · Post by **benwyatt** » Fri Aug 07, 2015 12:07 pm

Post removed.

scandk · Post by **scandk** » Fri Aug 14, 2015 12:17 pm

Using this, thanks a lot!

lydia1121 · Post by **lydia1121** » Mon Aug 17, 2015 12:13 am

Great Job! Thanks for sharing

champv17 · Post by **champv17** » Tue Aug 18, 2015 2:48 pm

Thank you. I will be using this.

benwyatt · Post by **benwyatt** » Tue Aug 18, 2015 11:39 pm

Post removed.

BertYoo · Post by **BertYoo** » Thu Sep 17, 2015 9:23 am

+1 thanks for this!

scollop · Post by **scollop** » Tue Oct 27, 2015 6:03 pm

Thanks for creating this, bumping for anyone else who might find this useful

susanlata · Post by **susanlata** » Fri Oct 30, 2015 1:00 am

Thanks for sharing! Very helpful!

dawnk · Post by **dawnk** » Fri Oct 30, 2015 1:18 pm

This is awesome. Thanks!

beckett · Post by **beckett** » Fri Oct 30, 2015 1:53 pm

This is amazing. Thanks so much! A lot better than the spreadsheet I was using.