I normally use it for budgeting and purchases, but lately I had some time and a while back for a class I had about 70 or so friends take the test / tell me their MBTI personality results. The results were pretty interesting, but not so much before I realized how sad this was. Anyways, most random thing you used excel for? I recall one of the main characters in The Big Short kept a spreadsheeet of all the sushi places in New York and his ratings of them.
Trending Content - Off Topic Forum
| +35 | EpsteinBooks Dispute: Child Molestation Optimization Process | 5 | 6h |
| +30 | Wall Street’s premier CoC clan | 7 | 2d |
| +25 | Favorite slop bowl for lunch? | 18 | 4d |
| +21 | ADHD & Living This Life | 5 | 1d |
| +10 | Ferda | 1 | 5d |
Career Resources
I have a giant movie spreadsheet with virtually every film I've ever seen and want to see, with various data points, filters, conditional formatting, the works. It's pretty nice.
Check out Foundd (no typo, free web/ios app). I had a similar excel file, but started using them lately. Essentially it does exactly the same in addition to movie suggestions based on your historical data.
Well, this is just unfair. You gotta hook it up, bro!
I have a spreadsheet with the 500 largest restaurant chains in the US, and track how many I've eaten at, because I am a consulting stereotype.
Random restaurant generator from a set list of restaurants
girls i sla.... er i mean bills/monthly payments etc
was considering starting one of these...
Defintely a spreadsheet of my tuition bill
I like to keep track of how much money I'll have to pay during the year as well as how much aid i'll be receiving.
Also i've helped some family friends out, get a preview of their car payments prior to purchasing, how much money must be contrubuted towards down payment in order to pay X amount a month at Y interest. Pretty basic stuff.
Paper football league playoff bracket.
i parsed a list of everyone's email at my business school(>1000).
Have a simple spreadsheet that keeps track of my poker wins and losses
so do my friends and I some of them who play significantly often even account for the amount of time played, location/venue, stakes, type of game,...etc. and just calculate hourly win/loss rate at a specific game/stake at a specific venue and analyze their habits and trends
some of them look more like accounting income statements at a glance from far away
I built a model to calculate peoples' chances of getting into an M7 MBA program. I plugged in all the analysts and gave it to my MD. I also calculated the chances of analysts leaving for the buyside in their first year. I also reported these results to my MD. Why? I get a rush from closing dinners.
-Personal monthly and annual budget with income statement, balance sheet, and cash flow statement -Model that forecasts growth of all investments I own and debt repayment schedule -Spreadsheet of all material things I want to own someday with prices for each item -List of all my professional contacts divided by industries that tracks all the activity with them -About a dozen models for potential ventures I am thinking to start someday
I have a spreadsheet to keep track of my golf handicap. It lets me select the course from a drop down and then a second drop down will provide the tee locations (forward, middle, back; red, white, blue, black) for the selected course.That was the part that took me the longest to figure out, but eventually I got it. This spreadsheet has saved me a few times when my official handicap record with GHIN was accidentally deleted.
Firms and positions I have and/or intend to apply to.
Not outside of work, but the guys (including VP) at my old firm made a spreadsheet using sophisticated formulae and statistics to determine how probable it would be to bang the women in our office. Variables included relationship status, attractiveness, friendliness, rumours etc. and it was sent around to all the men and each person made additions and tweaks. Turned out to be quite accurate.
I built a roulette game - top down view of roulette table, then used =rand( ) to spin wheel / provide outcome. The macro then calculated winnings, added it to "bank", then reset for next spin.
Make a spreadsheet to study vocabulary in spanish. Had the english word typed out, and a blank cell where I would type in the spanish word. Conditional formatting so if it matched the correct answer (which was in column AZ or something far to the right) it would turn green, otherwise red
A consulting friend of mine did a catalog of her wardrobe. Still haven't heard anything better than that. Personally, I DCF'd myself once. May have gotten aggressive with the assumptions.
lol
I have a model that I use to value players in my fantasy football league and create my draft order. Last year was my first year using it and I won the league (12-team) and this year i'm the #2 seed in the playoffs (12-team again).
Haha impressive
Had to create a spreadsheet to track my mother's bandwidth use. After being introduced to TV streaming sites she managed to blow through 75 gigs a month.
You seem like a nice guy so I won't say something dirty, but...
Don't put your hand on the holster without intending to pull the trigger. Write something creative/funny and related to WSO, not just "your mom watches midget porn".
Used to have a list of people to contact with follow up comments, etc. when I was looking for a job Had some outside-of-the-classroom fun in College with a BAC level spreadsheet that a professor provided Used to have my monthly budget in excel before I learned about mint.com (11235813 - Foundd seems like a very good find) Made a DCF/IRR on myself - if I go to b-school I will need some really aggressive assumptions to get my IRR to respectable levels. There are some amusing and interesting ready made banker/hedge funder DCFs that, I've found on WSO
Have a list/roulette of the best NYC restaurants and joints to eat at (including the 53d street guys back when they were good) Showed my dad what he's really getting into when buying an apartment w/ w.o. mortgage. I think it was the first time he cought a glimpse of a vague idea of what I do for living Use spreadsheets to figure out in which notes to invest on LendingClub faster Use a spreadsheet for the last European and World Cup brackets (won them both) Liked what this guy did: http://www.dailymail.co.uk/femail/article-2131808/David-Merkur-dating-s…
Finding out who unfriends me on Facebook.
Facebook doesn't allow us to see who unfriended us? Well screw you, because I got Excel magic ;)
If you unfriend me on Facebook, you WILL get a nasty message from me. >:]
There's an app called Unfriend Whatever that does that, dude.
I just realized why women refuse to sleep with us.
Their loss!
This thread only affirms just how amazing Microsoft Excel is. I won't be satisfied until every aspect of my life is on a spreadsheet.
I'm only half joking.
I also have the golf handicap tracker, but added a few features to mine. My sheet also tracked fairways hit, greens in regulations, number of putts per hole, up and downs, etc.
Golf sabermetrics? That's probably a good idea if you want to truly know where to focus your practice efforts. I may start doing this myself.
Yeah, I forgot to add that I added those columns as well. On the top of the sheet I have high/low/average for score and averages for putts, fairways, and GIRs. There is also a handicap calculator that gives you a course handicap when you input the course slope.
I use it to automate sending custom christmas greetings (with my own designed christmas cards) to my entire contact list every year. Is a talking point and I have rebuilt contacts through that means.
My diet Macros and Micros.
Umm can you guys share some of these spreadsheets, because they sounds fucking awesome
Right now I'm working on a spreadsheet that will put out a bunch of key statistics on each team in march madness then should ultimately decide who has the better chance of winning. I hope to finish it this weekend and then spend next week back testing/tweaking it.
Quia explicabo facere quia consequatur aut dignissimos et quia. Magni fugiat maxime ex. Commodi ut eius velit voluptates qui. Ut quia rerum cumque voluptates qui enim at. Consequuntur ullam nulla eos enim distinctio et veritatis voluptatum. Vero qui libero minima eos cupiditate. Ullam fuga incidunt ea quas.
Voluptatem itaque facere at aut sunt consequatur. Tempora est sapiente ut eos iste dolorem. Earum voluptatem sed maxime eligendi. Est qui aliquid sapiente et officia ex.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Ut non qui voluptas cum doloribus quia illum. Autem in accusantium pariatur voluptas voluptates. Sit exercitationem nam rem ipsam. Sed alias ipsum praesentium totam dicta labore voluptas quasi.
Qui ea reiciendis illo dolor neque esse. At qui qui perferendis qui ad quas sed aut.
Maxime ut magni veniam consequatur molestiae. Nesciunt repudiandae tempore nisi impedit molestiae nihil earum odit. Rerum tempore excepturi modi aut et occaecati voluptas. Necessitatibus consequatur dolor voluptas veritatis qui. Necessitatibus voluptas et doloribus ea consequatur ullam ullam.
Recusandae asperiores officiis assumenda quo. Voluptates voluptas qui animi ea sapiente rerum nostrum. Perferendis facilis cumque porro et dolorem consequuntur maiores. Est quidem velit rerum non dolorum est beatae.
Quae sed quibusdam iste rem et vel. Eos enim magni non voluptatum a modi quam. Nisi ea velit necessitatibus amet minus rerum. Animi officia earum reprehenderit rerum voluptatibus dolore qui.
Sed labore cum perspiciatis et. Dolore ratione non consequatur rerum itaque vero optio. Autem itaque ad ut eum architecto autem et. Nisi iste voluptate odit ut. Quasi cumque rerum perferendis. Rerum doloribus saepe sunt commodi occaecati qui.
Quasi aut et cupiditate exercitationem. Corrupti incidunt et delectus quam quis voluptas. Deserunt ducimus eius eaque molestias labore vel. Eligendi veritatis suscipit nobis aliquid nostrum earum. Et ut magnam et a sit quis non nihil. Eius aut inventore dolores natus repudiandae qui doloremque est. Dolores quisquam soluta temporibus.
Consequuntur ad qui saepe. Nobis dolorum cumque a vel praesentium. Quia dolorum soluta sit saepe nihil. Quia laudantium error odio et omnis. Aut autem velit nisi dolores id nam adipisci.