QOTD I am relatively happy with the list. I think it’s a solid mix. I would like it finalized and to be done. He’s cut 2 this week though so it’s 4 left to hammer through and call it good. And, while I wish there were more than one true financial safety, it is one we can both live with and be quite happy about so it will do for now. With a 100% EA list, there are options should he really not know what he wants. This is a kid who is pretty definite about a lot of things though so I am not overly concerned.
QOTD2 nope, we have not visited most! Only 2 out of the current 5 and the list may grow a bit more. I can’t justify the money unless a work trip for me turns into a happy coincidence. Which while not impossible, may be unlikely. Our biggest challenge even if money were not a concern is the timing. Schools are closed over winter break so that doesn’t work and given the distance, we would ideally see multiples. Which means spring break. And that is at the END of April for us. It could be nail biting just based on that! There is the outside chance I take him out of school prior to an NYC trip I have that overlaps with a NYC drama trip over presidents week and we visit schools before his school trip starts. I’ll need to see what the flight details look like on their end and chat with the teacher to see if that is even a remote possibility to pull off. While none of his schools are in NYC, we could springboard from there easily enough. Maybe. In the meantime I’m hoping I get called east in Oct or Nov, that would be so much better lol!
@MotherOfDragons ok, 8,000 might be a slight exaggeration. :)) 26 with 13 of them active, though really about 6 that I really use.
Of course we aren’t talking about total files and file storage structure as that’s an entirely different animal. Folders by school with NPC’s and other data, cheat sheets for S to help him cull the list, his new weekly checklists…
And nope. it is safe to say we have had no issues with my.mit. Never will either. LOL!
@STEM2017 and @dfbdfb you are my people
Active unhidden tabs are as follows
- App Status. This only has data for the 5 schools that have made it into the "will apply" category and is specific to status updates and the due dates for the application type we've chosen.
- Master List (inactive schools that made it deep enough are hidden but preserved). This one might um be considered info overkill although dfbdb has me beat at 123. There are 79 columns of data for the now 9 schools (there are 30 schools worth of data on it but not all were ever populated fully lol). This also has a "fit" ranking that is a numerical scale based on the data in the sheet and is "my" take on the fit for these schools for S. It remains to be seen how accurate it proves to be but it's a nice sorting feature.
- Costs over time. This shows the projected total COA for all 4 years accounting for inflation and shows best, and worst, case scenarios for each school and then categorizes them into financial buckets. Basically it breaks down how much skin S will need in the game, over time both during the year and summers, if any.
- Application info. This is different than app status, it delves into what is required for each application and it's relative importance. It also tracks the fees to apply, test scores sending fees etc to see total application cost and lists all application due dates offered as well as notification dates.
- Tuition Comparison. This is different than costs over time although the data from here populates the basis of costs over time. This shows all baseline assumptions using 16-17 costs, has a few different merit scenarios and then shows the delta between target amount and what the schools actually come in at, or have the potential to.
- GPA matrix. This has all of the GPA info. As our school does not weight and only shows all classes I've created a spreadsheet that shows all, all weighted, core, core weighted, the same but 10-11 only (when we were looking n CA) and then the UC/Cal EI info.
- Test scores, this has superscore info as well as all tests taken
- Our school acceptance and yield data for the last 3 years, all colleges
- 529 and other related info
- CSS Profile school list so I can see where I'll have to deal with NCP aivers
And then there are about 14 hidden tabs/worksheet that is mostly junk at this point but historical info I may want at some point.
I’d have so many spreadsheets if it wasn’t worksheet tabs and I’d lose my mind. I am a toggler. That said, I do have archival versions. I re-save every so often with the current date in teh file name as things get cleaned up and hidden from view. It has come in handy a few times when I’ve deleted a school (stopped doing that) and couldn’t recall why.
I may have a problem. At least I’m not alone.