The most prestigious law school admissions discussion board in the world.
|
 |
 
|
i would literally kill if i was forced to make spreadsheets all damn day
Poast new message in this thread
Date: November 18th, 2017 6:50 AM Author: flesh heaven (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715644) |
Date: November 18th, 2017 6:51 AM Author: Abnormal Piazza (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715645) |
|
Date: November 18th, 2017 7:29 AM Author: flesh heaven (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715780) |
|
Date: November 18th, 2017 7:31 AM Author: Garnet Old Irish Cottage eh playing around in excel can be fun and at least its mindless. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715790) |
|
Date: November 18th, 2017 7:45 AM Author: crystalline internet-worthy chapel The main thing to do is properly normalize your tables then use Access to run spiffy reports. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715851) |
 |
Date: November 18th, 2017 7:49 AM Author: Aphrodisiac library newt Link? (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715866) |
|
Date: November 18th, 2017 7:53 AM Author: crystalline internet-worthy chapel MS Access, part of MS Office but no one uses it. Or when they do they focus on how they want the final report to look and try to base the tables off of that, but that's ass-backwards. Gotta gitcho tables right.
Wikipedia has articles on database normalization, with examples of what it is.
Like if you're listing a bunch of different people's results on the same events that each occurred on the same days, then you need to put the events + dates in a separate table from the names + results and give each event a code that is referred to in both tables. Stuff like that. Normalize yo shit. Most n*ggaz ain't normalizin'. |
|
Date: November 18th, 2017 7:56 AM Author: Garnet Old Irish Cottage Access is 180 but i have no fucking idea how to use it. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715897) |
|
Date: November 18th, 2017 7:59 AM Author: crystalline internet-worthy chapel I read lots of posts on database forums and stackexchange questions. The key issue is people focus too much on formatting reports but you need to focus on your table setup and join queries etc. That's where you need to understand normalization. It takes time but then becomes an A ha thing. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715908) |
|
Date: November 18th, 2017 8:07 AM Author: sable cheese-eating plaza rigpig I'd assert it's very simple and except for syntax can be picked up in an afternoon, the problem is people are not used to thinking in clean categories, everything is all ajumble. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715929) |
|
Date: November 18th, 2017 8:09 AM Author: crystalline internet-worthy chapel Agree 100% (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715939) |
|
Date: November 18th, 2017 7:46 AM Author: sable cheese-eating plaza rigpig I much prefer fucking around with spreadsheets to writing, which is 90% of what I do. The dolts at my office don't even know vlookup let alone hlookup, index(match), or the ALMIGHTY SUMPRODUCT. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715854) |
|
Date: November 18th, 2017 7:51 AM Author: flesh heaven what you just wrote makes me want to punch a wall (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715871) |
|
Date: November 18th, 2017 8:14 AM Author: arousing lilac university depressive Excel is so fucking prole, clunky, and verbose.
Chill aesthetic math bros: a . b
Prole industry fags: SUMPRODUCT(A$1:A$23, B$1:B$23) |
|
Date: November 18th, 2017 8:15 AM Author: sable cheese-eating plaza rigpig Intuitionism is a lie and axiom of choice is bullshit. Keep chasing skydreams you hippie. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715958) |
|
Date: November 18th, 2017 8:00 AM Author: citrine point famous landscape painting I'm in Excel all day but my final work product is PowerPoint. I just use Excel to crunch the numbers and then make a deck about what the numbers tell us. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715913) |
|
Date: November 18th, 2017 8:02 AM Author: flesh heaven how is this even "work" (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715918) |
|
Date: November 18th, 2017 8:05 AM Author: citrine point famous landscape painting Oh, I also attend meetings. I'll make a big spreadsheet where the rows are all workstreams within a big project, and at the meeting I'll ask everyone for a status update on their part of the project and I'll update the spreadsheet with new info about how the project is going.
then I go make a PowerPoint deck summarizing what's new on the project, which I present to a C-suite exec |
|
Date: November 18th, 2017 8:06 AM Author: flesh heaven jfc (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715927) |
|
Date: November 18th, 2017 8:10 AM Author: citrine point famous landscape painting lol brother what would you rather do? be a lawyer who gets yelled at for minor punctuation errors in a written memo? (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715943) |
|
Date: November 18th, 2017 8:11 AM Author: flesh heaven sales (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715947) |
|
Date: November 18th, 2017 8:11 AM Author: sable cheese-eating plaza rigpig You need to automate your workflow hehe (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715945) |
|
Date: November 18th, 2017 8:19 AM Author: flesh heaven (((hehe))) (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715972) |