I'm grappling with an Excel formula. Given a bunch of columns, I'd like to to (a) identify the right-most column that contains a value, then (b) fill a cell with that value and the value in the column heading. [more inside]
posted by obiwanwasabi
on Feb 25, 2014 -
Seeking ideas for plannning a multi-course, romantic, home-cooked meal for two that is also thoroughly, completely English. The more traditional the better. Looking for dishes in season, no seafood, ideally with a focus on lamb as a centerpiece and easy on the potato/bread. Other then that, assume a high level of cooking skill, endless time for fiddly bits, and acess to pretty much anything and a well stocked UK grocery importer store nearby. [more inside]
posted by The Whelk
on Feb 14, 2014 -
Afternoon WeddingFilter: We're trying to work out the timing for an afternoon wedding with a reception meal, and would love your advice and experience. [more inside]
posted by Miko
on Jan 24, 2014 -
We're getting hitched! Yay! I freak out about money, and I freak out that my fiancé doesn't freak out about money as much as I freak out. Is there a good step-by-step guide you'd recommend that we can go through together to make sure we're covering all of our bases for saving for retirement, saving for other stuff, and paying down debt?
posted by ashtabula to opelika
on Jan 16, 2014 -
Belated Happy New Year everyone!
I am a 32yr old single mother of a beautiful 1yr old, and this year I’ve decided to plan ahead to help me fulfill my parenthood responsibilities to the best. We are a US middle-class family of two. Originally not from this country, I need to research several important aspects of planning for a future here. I hope to get some useful suggestions from those of you who are savvy about these things :-) [more inside]
posted by Spice_and_Ice
on Jan 6, 2014 -
I've been offered to be hired where I have been a contractor. However, there is a health insurance issue that would cost me a lot of money for several months. But I would have a great retirement plan. I have nothing in savings and $100k I just consolidated in student loans, so this issue is just complicating things. [more inside]
posted by McSockerson The Great
on Dec 15, 2013 -
I'm making plans to move to Los Angeles and I very likely will have someone else accompanying me who is also feeling the desire to move to Los Angeles with me as well (he went with me on a week long vacation - please note the previous AskMeFi for better reference [more inside]
posted by antgly
on Dec 12, 2013 -
I would like to set up weekly meal planning/recipe/shopping list service. I follow a certain dietary plan -(NOT paleo )and think that that there i a gap in the market for a simple menu/shopping list which arrives in your inbox every week.
The problem is that I have no idea how to go about setting it up.I am a very decent cook and have done this for myself for about a year,so I already have a whole set of recipes and tricks that are diet compliant.
I need to know if there are any software options that I should be looking at and I have no problem investing the money for someone else to do it-but I'm not even sure who I should be approaching!I would like to be able to modify it and maybe offer add ons/customizations if it was successful.
So any help and advice would be gratefully received!
posted by hitchcockblonde
on Nov 23, 2013 -
I have an interview for an urban planning job (yay me!), but I feel a little worried about the interview. [more inside]
posted by Hypnotic Chick
on Nov 15, 2013 -
I am a 29 year old American expat, living and working abroad in BRICs for nearly 6 years now, who needs help in getting my financial act together. Due to limitations of my company- I have not been able to contribute to a 401(k) for at least five years now, and in the last few years my salary has exceeded $135k/year, so I can't even contribute to a Roth IRA. As far as I can understand, there isn't really anything more in the basic United States system for retirement that I can take advantage of… so now what? Am I really on my own now? Are there any websites with info geared towards this? Or should I get a financial/wealth planner? Or an "expat" tax accountant? Or both? How do I even start to find one? I have no idea what to look for! [more inside]
posted by anonymous
on Nov 5, 2013 -
I have a master's degree in urban planning but I've been out of the field for a few years and want to come back with really strong skills. I'm not very good at self-guided learning, since I need the discipline of having assignments and deadlines. I struggle with ADHD, so just staring at an iTunes video will not work. I'm also low on cash right now. Please tell me about the online courses and/or certificate programs out there that are easy on the wallet. [more inside]
posted by mirepoix
on Oct 24, 2013 -
I'm seeking as many opinions as I can get from people with knowledge of financial advising and/or trusts & estates and/or estate planning, about what my parents (in their 80s) ought to do with their $250,000 in liquid assets. I'm NOT looking for the kind of detailed plan we'd get from an advisor whom we hire; I'm looking for short, quite general, common sense answers (such as "These ONE OR TWO types of instruments are good/bad; all others are to be avoided/considered.") I'm also looking for as many answers as I can get. In order to get that assortment of answers, I want to disclose only a very few specific things about the folks: 1. they currently rent an apartment; they do not own a home. 2. they are in their 80s--relatively healthy and can drive, shop, take care of themselves, but I'm not sure how long that'll last. I'd like to see them in a retirement community within a couple years. 3. Their only income (which doesn't amount to much) is social security. 4. They lose about $2,100 in total expenses every month. That's just about equal to what they take in each month. 5. Their one and only significant asset is a liquid $250,000. Okay, at their age, and considering all the above, WHAT IS/ARE THE MOST PRACTICAL THING(s) THEY SHOULD DO WITH THAT LUMP OF LIQUID MONEY? THANK YOU from their worried adult child with a family of my own!
posted by losdavos
on Oct 24, 2013 -
My brother and I would like to give my parents a large chunk of cash this Christmas with the intent that they use it to travel. How do we do this most effectively? [more inside]
posted by anonymous
on Oct 16, 2013 -
I am helping my parents plan their retirement by looking into possible cities and/or communities for them to settle. My father has worked in NYC for the duration of his professional career and wants to retire somewhere in the Northeast. After much internet research but very little progress, he wants to spend Sun-Tues (Oct. 13-Oct. 15) driving around DE, MD, PA, and northern VA to scope out possible areas. I have been asked to accompany him on this trip but I want to create some structure around the trip to avoid simply driving around aimlessly. [more inside]
posted by allthingsconsidered
on Oct 11, 2013 -
We're going to move from the southern part of Alameda County to somewhere between Martinez and Oakley in eastern/northern Contra Costa County. We have a few complications (of course!) and not much moving experience. Can you tell us how to plan? [more inside]
posted by wintersweet
on Sep 28, 2013 -
I'm entering what I expect to be a very busy year: busy full-time job with frequent evening and weekend work, graduate classes one night a week (plus homework), and a large writing project due next year. I find that I can get really overwhelmed and stressed when my schedule gets locked in and deadlines line up. I'm trying to find ways to simplify and ease my daily life so that I don't add additional stressors. What are your best time- and stress-saving tips for getting through intensely busy times? [more inside]
posted by Miko
on Sep 12, 2013 -
I proposed a date to a guy I'm seeing casually, and he turned it down without offering another solution. I'm starting to feel that I'm putting in more effort than I should at this point. Should I ask him if he still wants to date in general? [more inside]
posted by thick woolen socks
on Sep 5, 2013 -
A for-profit business has set up a school for 'troubled' youths on our road without any planning permission for change of use. They are now retrospectively asking for planning permission for this and in addition, using two adjacent houses for the same purpose (change of use from residential to D1). In forming our objections, I have a few questions that I cannot find the answer to.. [more inside]
posted by oliverst
on Aug 1, 2013 -
My boyfriend and I are planning a (somewhat) last minute camping trip to Maine. So far these are the details we have finalized. The trip will be from August 3-14, we will be staying in Kennebunk for a night, and we will spend 3 nights in Camden Hill State Park. [more inside]
posted by allthingsconsidered
on Jul 21, 2013 -
I've got a notion to organize a movie screening of some sci-fi movie at a local theater, and sell tickets. It seems to me that the easiest legal way to do this is to buy the performance rights and rent a screen at a franchise theater. Assuming I know ahead of time what those costs are, Kickstarter could be the ticket sales mechanism. [actual question inside] [more inside]
posted by 4th number
on Jul 19, 2013 -
I'm a formerly broke person who is beginning to become unbroke, although not without stumbling from time to time. I have a few strong goals - buy a house, get my student debt in order (not paid off - just in order), save up enough for a couple of large ($5000) purchases, improve my credit score to mortgage-minimum. I need help getting there. [more inside]
posted by Nyx
on Jun 26, 2013 -
My city banned the construction of high-rise buildings in the eighties. Political winds have shifted (along with economic growth) and now city hall is set to make some permissible again in a new specific plan for the downtown.
My layman's intuition combined with some background reading tells me there is a big difference between a well-designed high-rise and one that's poorly designed. I want to be more conversant with the design issues involved so I can contribute intelligently to the civic discussion.
What key articles, reports, manifestos or monographs should I read? [more inside]
posted by bertran
on Jun 23, 2013 -
For the past year I've been trying to bike down every street in St Louis. In the beginning this was easy and wide-open and fun. The middle has been less so. Now, sitting at ≈65% completion [map: zoomable | 1.5mb png | GPX]
my current approach has become overwhelming and tedious
, and is no longer working; I need to get way smarter about this. How would a programmer, a mathematician, or a GIS/transit specialist approach this endgame, and what tools/software would he/she use? [more inside]
posted by jjjjjjjijjjjjjj
on Jun 13, 2013 -
I love cooking, I do! But I really only love cooking for others. Come the weekend, I'll happily slave over brining meats that end in elaborate 120-step preparations. I have made food from the French Laundry cookbook that basically tripled my grocery bill. I love it.
But Monday through Friday, when its me and my tummy, I could kind of care less. I live a few miles from the nearest grocery and so I'm car-less, which means if I don't buy for the week, I don't buy at all. I'm also stupidly busy which means that a lot of the time I'm either paying way too much for lousy chain food or eating gummi worms for lunch. [more inside]
posted by GilloD
on May 30, 2013 -
I hired a month-by-month financial adviser last year after my divorce to help me get things in order. The guy I worked with left the company last year on May 13. He called me yesterday, 366 days after he left from his new gig wanting me to be his client again. (non-compete plus 1)
That's when things got weird. [more inside]
posted by bricksNmortar
on May 15, 2013 -
I travel on a semi-regular basis and would like to become a better traveler, both in terms of trip planning and packing/unpacking/repacking. If you travel frequently, how do you do it? How can I up my game? [more inside]
posted by kat518
on Apr 22, 2013 -
My main squeeze is moving in! Our finances are starting to be a little more comingled and I'm looking for the best, healthiest way to start having a regular "money check-in" as part of our new life together. He is on board with this. How do we structure the conversation? Is there a sample agenda? Do we make it a date night? Help, please. [more inside]
posted by amoeba
on Mar 26, 2013 -
So, I'm trying to get some opinions here:
My fiance and I have been engaged for 4 months and are in our mid-20s. We are both in school (undergrad for him, grad for me), but due to my income, we wanted to wait one more year, so that it would be financially better for us (e.g., paying tuition, etc). We are both interested in having children, however, something has come up for me health-wise (ulcerative colitis) that would make it less safe (because of medications) to have a baby later on, compared with now. Here are my questions for you:
1) Would you have a baby before marriage? What would be the reasons?
2) Has anyone actively planned this before? How did it work out?
I know some would say suck it up and push up the wedding, but it would save us a good 20K or so.
posted by queenba
on Mar 16, 2013 -
Suppose that I have a website that has frequent traffic. This traffic is consistant and predictable. How do I begin monetizing it by selling ad space? Where would I get in touch with these mythical people who would pay to have their ads displayed on my website? Is it customary to get paid per click or per view? Are there different rates depending on the readership?
Educate me, Metafilter!
posted by wolfdreams01
on Mar 15, 2013 -
My husband is driving me up the wall. He has always shown a reluctance to make a plan for anything, but I love planning stuff (trips, etc) so it's never come to be a huge issue. Except for now. [more inside]
posted by checkitnice
on Mar 13, 2013 -
So I got accepted to my doctoral program (vet med - yay!). Before it begins in August, how can I best use my time between now and then? Looking mainly for non-obvious stuff (work, save money, sleep, etc). Any other general tips for surviving the program would be gladly accepted.
posted by Ufez Jones
on Mar 1, 2013 -
In New York, and many other cities, developers can build bigger buildings than would otherwise be allowed, as long as they provide amenities such as parks, schools, affordable housing, etc. I want to show students how this works by providing a photo or drawing of a real building, annotated to show how much of the height is due to these bonuses.
For example, a drawing of a 50 story building, where the first 30 floors are unannotated, but then 30-35 are labeled "plaza," 35-40 "affordable housing units," 40-45 "subway entrance" and so on. I want it to be from a real building, and clear enough to show via a projector. I'm surprised this doesn't already exist, but I've done plenty of searching and can't find it.
posted by lenore
on Feb 20, 2013 -
I'm desperately trying to become an adult (finally!), but I can't wrap my head around 'classic' budgeting software. Suggestions and tips to find what I really need? [more inside]
posted by hanov3r
on Feb 14, 2013 -
I would like to hear about the little things that really stood out and details you still remember to this day from conferences or conventions in any field. [more inside]
posted by nathaole
on Feb 12, 2013 -
My friends are all prepping for careers, and I'm wondering how I'll balance mine with the many things I want to do that are (probably) mutually exclusive. Looking for insight. [more inside]
posted by Urban Winter
on Jan 27, 2013 -
My office delivers projects - about thirty a year, about four months each, give or take a few weeks if they go well. They're always late, but when planning the next project, we use the same optimistic assumptions. I think reference class forecasting (RCF) could help. Any pointers for (or links to a crash course in) using RCF to turn a spreadsheet full of historical start / end dates and milestones into more accurate forecasts? Or is this something best left to a math geek?
posted by obiwanwasabi
on Jan 26, 2013 -
If you keep a diary or other secret papers, do you have a plan for what happens to it if something happens to you? [more inside]
posted by dawkins_7
on Jan 5, 2013 -
Looking for activity ideas for a singles night in a small restaurant. What doesn't make you cringe? [more inside]
posted by ceiba
on Dec 17, 2012 -
in my mind i envision a website where you put your departing airport and the site pulls together current last-minutes deals to all sorts of destinations [more inside]
posted by allthingsconsidered
on Dec 9, 2012 -
Help me add new dishes to the menu. Difficult level: kosher-style, pescaphobic, non-dairy, mushroom hater. [more inside]
posted by bq
on Nov 27, 2012 -
I was asked to consider teaching for a couple of days at a university here in the UK which is great. But I have zero experience in creating lessons plans. I have found some useful free-to-use lesson plans online that I am tailoring but I can't seem to get an indication of what I should provide to the university department leaders in advance. Should I only send the lesson plan and readings? Should I omit readings from what I send my future bosses? Help me make a proposal map so I can sort it all out for the future! It's a media studies department FWIW.
posted by parmanparman
on Nov 3, 2012 -
Help two budget wedding dorks make the most of appointments, touring venues, etc. What questions do we need to ask in person? How do we get it all done in a weekend? Can we get discounts on entry fees for looking at all these places? [more inside]
posted by nakedmolerats
on Oct 10, 2012 -
I am taking a trip to Salem (MA) this weekend with several friends. The general goal is to have lunch together and see some of the cheesy haunted house attractions. What else should we see while we are there? Are there any non-cheesy attractions that are simply too good to be missed? [more inside]
posted by wolfdreams01
on Oct 8, 2012 -
What's that movie? filter: I'm looking for the title of a classic movie where a couple plans a wedding and it makes everyone unhappy. [more inside]
posted by petiteviolette
on Oct 5, 2012 -