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

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

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

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

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

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

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

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

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

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

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

-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

Trouble calculating regular averages in Excel

In Excel, how do I calculate the average of every 300 data points in a large data set?
posted by Midnight Rambler on Oct 18, 2009 - 10 answers

How do I select the last number in a column in Open Office Calc?

How do I select the last number in a column in Open Office Calc?
posted by tomble on Jul 9, 2009 - 3 answers

Whither double asterisk-inserting custom Excel formula??

Excel n00b needs help with what ought to be a very simple custom formula. And yes, I have looked around on the interwebs for the answer.
posted by wowbobwow on May 6, 2009 - 6 answers

I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front =4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula?
posted by Akeem on Mar 12, 2009 - 3 answers

Merging worksheets in Excel.

Excel-Fu Filter: I need to merge latitude and longitude values (in two columns) corresponding to a specific site from one worksheet to the corresponding site in another worksheet.
posted by schyler523 on Mar 3, 2009 - 7 answers

Excel date arithmetic problem

MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today?