Spreadsheet for Tracking Your Applications
Posted: 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.
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.