It's not 100% necessary but for negotiations class we are having a pretty math heavy city budget exercise and i was just wondering if anyone would be so kind as to help

law students are notoriously bad at math and especially in the middle of a negotiation you don't want to have to bust out a calculator and double check the math for every variable

i have 14 total negotiable variables, 9 of which are negotiable in quantity (the other 5 are yes/no)
the quantities are already in the most basic form(?) meaning one formula would take care of all of them once i gave you the different initial values

would anybody be willing to make a spreadsheet out of the kindness of their heart that would do the math if enter either the quantity or yes/no of the options

3/12/2012 8:28:55 PM

Do you have any spreadsheet skill at all? From your description, this should be a simple sum.

For the yes/no questions, use 1 and 0 for yes and no. Multiply the cost by the 1 or 0 (yes or no) to determine the value of that particular variable.

If you want to get fancy, use Y and N with an if statement.

3/13/2012 2:04:38 AM

this what you mean?

https://docs.google.com/spreadsheet/ccc?key=0AgqOJHMO3_c6dG5FRUVnNTBoMVhPbkhjSElsM2ZZcEE

3/13/2012 2:32:51 AM

^ I added my interpretation to moron's spreadsheet

3/13/2012 2:49:57 AM

thank you guys, i added onto Tanzarian's sheet the information that I'm using. I could probably figure out the formulas from here but just in case anyone wants to finish it for me

3/13/2012 8:45:33 AM

I pity anyone who lacks this kind of basic technical skill in the modern world.

3/13/2012 12:15:47 PM

it's a time issue, not a skills issue. i could relearn how Excel works if i had the time, unfortunately in the 24 hours i have left i do not. there's plenty of reasons to pity a law student, not knowing excel is probably not near the top of that list.

3/13/2012 1:08:59 PM

got it all setup, thanks guys - i'm all set for my match tomorrow!

3/13/2012 11:23:28 PM

Quote :

"not knowing excel is probably not near the top of that list."

Well, now hopefully you see the value of being able to aggregate and interpret data even when you're a law student/potential lawyer.

However, I'm guessing that since you just convinced someone to do it for you, you learned a differnt lesson.

3/14/2012 10:01:18 AM

actually the first two posters set it up, did the yes/no formulas, and i did all the other easy formulas so i at least relearned some of the basic excel skills

3/14/2012 10:03:19 AM