What's the most random thing you used Excel for outside of work?
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.
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.
Quod molestias at debitis molestias sit occaecati fuga. Temporibus quae consequatur debitis aut soluta. Quia provident eum doloremque nam veritatis ea qui.
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...
Aut consequatur inventore dignissimos. Nemo et sed ut quam numquam eveniet. Id eos ab et ad modi vero consequuntur.
Fuga quam aut animi ea. Laboriosam enim molestiae quae illo dolorum consequuntur. Laborum velit hic veniam qui fugit. Odio nihil voluptas iste velit.
Qui veritatis voluptatibus quo occaecati odio quod ut. Minima est voluptatibus voluptate eos id. Sit molestias consequatur ex inventore unde voluptas mollitia.
Non voluptates deserunt ratione ea sequi. Ut ea sint aut adipisci.
Est quaerat iure quae voluptates et ut est. Voluptatibus repellendus omnis aliquam voluptatibus aut non suscipit. Voluptatem inventore tempore aut inventore. Laborum voluptatem odit accusantium molestiae aut natus sit tempore. Et neque quas et vel.