## Math For Spacing Out Three-Day Weekends, But Accounting for Holidays

I'm a big honkin' geek, and I would like to figure out an Excel formula I could reuse from year to year to space out my vacation day choices -- but including holidays, which would prevent even distribution. How can I still get as close as possible? More inside.
posted by WCityMike on Jan 13, 2017 - 10 answers

## How to transition from breastfeeding to formula.

My baby is breastfeeding 7 times a day, plus a bottle of formula. How do we transition to just 4 or 5 feeds of formula a day?

## Help with Excel formula to compare 1 column of numbers to other columns.

I have an excel sheet with 4 columns of numbers. The first column is a recent donation amount. The other three columns were the prompts of donation amounts, (the Reach, the Target, and the Anchor). Is there an excel formula that can compare these four columns?
posted by andoatnp on Jul 19, 2016 - 8 answers

## Help me figure out this number-of-combinations problem

Supposing you have a set of N number of questions to choose from for creating a test. Your test must have a minimum of 1 question but can have all N. How many unique tests could you create? Am I correct to assume the formula is 64! (factorial)? 64 x 63 x 62 x 61...
posted by postergeist on Feb 13, 2016 - 6 answers

## Excel filter: How do I add only data for a given month?

I have an Excel worksheet that logs hikes. The columns are date, location, miles, notes. The rows are hikes. I have a summary worksheet in the same workbook that I use to track progression. Things like cumulative miles for the year, average miles per month. I'd like to add month by month totals. I want to write a formula that will sum the distance only for a particular month (for example, January). I need a formula that will test if the hike occurred in that month, then add the miles to the sum. What would this formula look like?
posted by OrangeDisk on Jan 21, 2016 - 5 answers

## Combo feeding, las dos.

Expecting baby no. 2 any day now and this time we'd like to split the workload of feeding the baby. What do we need to know to make this work? What worked for you?
posted by meijusa on Jan 6, 2016 - 6 answers

## How many more months of formula are ahead with an 11-month-old?

Should I buy formula in bulk for an 11-month-old baby? I want to follow his lead on weaning, but I also don't want to waste money or formula. I'm looking for advice from parents who let their babies self-wean.
posted by aabbbiee on Jul 27, 2015 - 28 answers

## How do you organize bottle feeding on the go?

What is your setup for bottle-feeding your infant on the go? We are interested in things like - How do you keep the leftover formula from spoiling, what does your on-the-go kit look like, how do you keep things clean, how do you heat up the bottle (or do you?) when you are out for the day, or at the park, or wherever. We have a 3 week-old who needs to be partially bottle fed but we are struggling with how to get outside and not starve him out, and not end up throwing away most of a bottle of formula.
posted by andreapandrea on May 21, 2015 - 24 answers

## Excel 2013 - Using data from two columns to identify a row in a third

I have data on one sheet of an Excel document with three columns. I want to extract this for use on another sheet as follows: If a row in Column A contains X (text string) and a row in column B contains Y (also a text string) then what does the row in column C (always a value) which matches these two criteria contain? With the data I have, this will always return a single result.
posted by Len on Mar 5, 2015 - 13 answers

## How do I solve for a percentage of a total budget...

This will be easy for someone, but math is my second language so I'm at a loss. How do I solve for the percentage of a TOTAL budget, when one line item is unknown (and is part of the total budget)?
posted by coollibrarian on Dec 9, 2014 - 5 answers

## Excel formula: Letter to Number (and vice versa)

I'm working on a formula (not a macro) to convert a Letter (in this case, a column letter) to a Number, and vice versa. So: A = 1, B = 2, C = 3, Z = 26, AA = 27, AB = 28, AC = 29, ZZ = 702, AAA = 703, AAB = 704, AAC = 705, BAA = 1379, etc... Of my three part formula(s), I have the one-letter and two-letter columns working, but I run into issues with the three-letter columns (AAA and beyond).
posted by JimBJ9 on Dec 3, 2014 - 12 answers

## Is my baby eating too much? Am I doing something super wrong?

Well now I'm firmly in the camp of "anxious parent" but here goes. How much food should my kid be eating? He's 7 months old, is about 20 pounds, on formula and some solids. Details below.
posted by FritoKAL on Sep 3, 2014 - 41 answers

## How do I calculate combined percentages?

Mathfail: I'm considering supplementing my cat's food with plain meat. I'd like a rough idea of how much it would bump percentage of calories from protein and fat.
posted by moira on May 10, 2014 - 6 answers

## Excel formula that hides results

I am drowning in Google results! Looking for help making a formula that will only show a value once data is entered into another cell.
posted by ellieBOA on Mar 6, 2014 - 10 answers

## Conditional Excel formula to identify right-most column with a value?

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.
posted by obiwanwasabi on Feb 25, 2014 - 10 answers

## I want to Excel

I need some Excel assistance.
posted by pullayup on Dec 16, 2013 - 8 answers

## I need to be able to memorize several formulas for a test next week

I'm taking a numerical methods class and there are all these discretization schemes of partial differential equations named after pairs of dudes and they all are kinda the same, maybe a bit different in indexes.... I'm trying to organize it all in my head, like a frat house, with the dudes that worked on the same scheme being roommates, but it seems to be taking a long time to actually "find" a place for each scheme in their "rooms" and keeping it there in a sort of visual arrangement. Test is no books no notes, and everything kinda of just jumbles inside my head right now.
posted by spacefire on Dec 11, 2013 - 10 answers

## How many endings to stories are there?

Various writers and critics through the years have claimed that there are only X plots (with X being pretty variable) and at the end of the day, all stories boil down to one of those plots. But today I'm asking specifically about endings. How many different endings can there be, and what are the main ones?
posted by Naberius on Sep 25, 2013 - 11 answers

## The kid is alright, but what about the parent?

Can you help me make peace with giving my baby formula when he's at daycare?
posted by anonymous on May 16, 2013 - 53 answers

## Foolproof way to feed baby kittens?

I've got three new baby kittens with no mother, and I need to feed them. I don't have access to any good pet stores or veterinary clinics, but I do have lactose-free baby formula and a plastic syringe with the needle removed, which I've been using to feed them so far. But is there a foolproof method of holding them or something to get them to drink from it? I can usually get them to drink, but only about half of the amount recommended. More details inside.
posted by ferdinandcc on Apr 23, 2013 - 20 answers

## Need help with conditional lists in excel

I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump.
posted by FireStyle on Feb 23, 2013 - 9 answers

## If I Knew the Answer, I Could Probably Give the Question a Good Title

Is there a formula for determining (eg.) how many tracks would fit on a TT 79:57 CDR where the first track was one second, and subsequent tracks added 1 second each? (00:01, 00:02, 00:03, 00:04, &c)
posted by herbplarfegan on Dec 10, 2012 - 7 answers

## Turning user input into pie (charts)

WordPressFilter: I'm looking for a plugin/widget/codesnippet that will allow me to create a graph using input from the user.
posted by antonymous on Nov 27, 2012 - 5 answers

## Watch Formula 1 without cable?

Is it possible to watch Formula 1 in the U.S. (Mass.) without cable? I do have internet + Apple TV + Netflix + Hulu Plus.
posted by lovingkindness on Jul 25, 2012 - 9 answers

## Places to race go-karts in/near NYC

I thought it might be fun to race around like giddy kids with my wife for her birthday. she loves Formula one and has expressed an interest in racing go-karts. We both can drive but do not own a car as we live in brooklyn and have no need. Any ideas on where to race go-karts near nyc? (I found this place: gpny.com, and it seems to fit the bill..but are there other options?) Anyone else had any similar experiences trying to find place to race? Extravagant test-drive a real car on a track option? f1 model kit? (thank you as always) -birthday panic!!
posted by 5lbauthority on Jul 2, 2012 - 8 answers

## Using formulae when I should be using VBA

Excel 2007 Filter: Is it possible to nest 3 OR statements in an Index and Match formula?
posted by Ruthless Bunny on May 31, 2012 - 5 answers

## Synonym for satisfying?

Is there a single word for finding pleasure in well done formulaic stories not because they are doing something new or even being particularly clever, but because they hit the notes well, manage the tropes, and deliver what they promise?
posted by The Whelk on Jan 22, 2012 - 34 answers

## Mixing infant formula with hot water

Question about infant formula milk and hot water
posted by low_horrible_immoral on Sep 9, 2011 - 10 answers

Spreadsheet question: I want a column containing all the names in THAT column EXCEPT all the names in THOSE columns.
posted by Salvor Hardin on Aug 2, 2011 - 6 answers

## What does a bivariate cubic polynomial look like?

What does a bivariate cubic polynomial look like?
posted by tybeet on Jul 13, 2011 - 9 answers

## She's gonna chow down, regardless

I just opened a new bag of Puppy Chow to discover it's actually the large breed formula. She is not a large breed. Oops?
posted by The Winsome Parker Lewis on Jul 9, 2011 - 10 answers

## Excel help needed!

I have a formula for inputting into my expense sheet but it doesn't populate the field like it should. I stole the formula from my time sheet, and that does populat the column for the 4 weeks after I manually put in date 1. It is: =IF(\$B\$4=0,"",SUM(B4+1)) So...why does it work in one sheet but not the next?
posted by dash_slot- on Jul 1, 2011 - 7 answers

## Organic Moo or Regular Moo?

Organic milk: what is the benefit?
posted by bq on Jun 5, 2011 - 50 answers

## Help me make Montreal F1 Weekend better than a Max Mosley orgy.

Formula 1 weekend in Montreal: Travel questions!!
posted by Hurst on Jun 2, 2011 - 11 answers

## Does this tattoo equation mean to you what I mean it to?

Math and science geeks, does this fake equation make sense? 'delta' = c ... meaning "change is constant".
posted by attercoppe on May 15, 2011 - 33 answers

## Do YOU know any "formula recipes"?

I'm looking for simple recipes which follow a set procedure, but whose ingredients can be easily changed up.
posted by purplecrackers on Feb 18, 2011 - 33 answers

## Double a column/cell in Excel

Excel 2007 question: I have several cells/columns of numbers that I simply need to double. So 5 becomes 10, 9 becomes 18, etc. I'm an Excel n00b and can't figure this out for the life of me. Help!
posted by zardoz on Nov 4, 2010 - 12 answers

## Formula for figuring poker winnings

I need help untangling a formula for tracking poker winnings. All this math is making my head hurt! Totally legal details within.
posted by c:\awesome on Oct 7, 2010 - 8 answers

## YTD total based on sum of last number in another row that has a value?

YTD total based on sum of last number in another row that has a value? I need to sum up the values in one row based on the matching row below it. For example, if I have a target of \$1000 a month, and I only have actual revenue numbers through June, I would like to calculate the year to date for the target from Jan to June. Once July numbers are put in, I'd want the YTD for the target to update to Jan to Jul. I have tried a couple of variations on COUNT, INDEX and OFFSET. Example is here: http://malcommc.com/ytd.xls I am using Excel 2003
posted by malcommc on Jul 12, 2010 - 12 answers

## Any experience with Neocate or similar formula?

My 6-week-old daughter was recently switched to Neocate infant formula due to her digestive issues (specifically G.E.R.D.), after trying a bunch of others with no success. If you've been down this road, did you notice that your baby seemed to eat less, at least at first, and how the heck did you pay for it?
posted by um_maverick on Apr 15, 2010 - 9 answers

## CONCATENATE/ CATASTROPHISE

In-over-my-head-Excel-filter: I need to put little braces {like, brackets}around a whole column of values using the concetenate function.. column A has all the values I need braced- but how do I get those same values {braced} in column B?
posted by Philby on Mar 14, 2010 - 8 answers

## Calling all pairs

Excel filter: Is there a simple way to iterate through all pairs in a list, perform a calculation on each pair, and sum the result?
posted by albrecht on Mar 9, 2010 - 11 answers

## Using Excel Formulas to Rank Ordered Lists

Excel question: I have a list of values, sorted from lowest to highest. I want to rank them. But I have a specific issue with regard to ties, and I'd like to be able to craft an Excel formula which will deal with this automatically, if possible. Full explanation below the fold.
posted by Conrad Cornelius o'Donald o'Dell on Mar 6, 2010 - 8 answers

## Random static date generation?

I need to create a static random number based solely on the date in PHP...I *think* this is possible, but I'm not sure.
posted by omnipotentq on Mar 6, 2010 - 8 answers

## Getting Excel to reconcile two types of data

Excel Filter: Say I have a spreadsheet with two types of data. a) list of transactions with date/time + transaction, and b) days with traffic. How do I reconcile the two sets of data swiftly & easily?
posted by Muffy on Feb 12, 2010 - 8 answers

## Need a formula to lookup/match two values and return a third in Excel

Need a formula to look for two values in another sheet, and return a third corresponding value. Example provided (google spreadsheet.)
posted by malcommc on Dec 28, 2009 - 5 answers

## Blind Spot in my Excel Formula Abilities

Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets?
posted by itsonreserve on Dec 23, 2009 - 7 answers

## Reverse my percentage?

How do you find a number that minus a percentage of itself is a certain number?
posted by JulianDay on Dec 6, 2009 - 7 answers

## -6+6*6 = 25. No, that isn't right...

Any Excel whizzes out there? I'm having a problem that I just know is going to have a head-slappingly simple solution, but I still can't figure it out.
posted by andrewcilento on Nov 10, 2009 - 8 answers

## Excel: Incrementing Formula Row Copied Across Columns

Excel question: I need a row number to automatically increment as I copy a formula horizontally across columns. Sample spreadsheet downloadable here, or viewable as a Google Doc here. Further details inside.
posted by Conrad Cornelius o'Donald o'Dell on Nov 7, 2009 - 12 answers

Page: 1 2 3