solving a math problem in Excel or Access?

Question

i have to solve a math problem in which it gives the names of 15 people and of 7 different books and then gives 14 different conditions about who read what book and i have to find out who read what book. the conditions are very complicated and i need to know if there is any way to input the data into Excel or Access and then set the conditons for the data and have it solve the problem for me. HELP PLEASE!

Answer 1

i'm not sure i understand your question entirely, but I think (from what I understand) I can get you started in the general direction.



use access dbase - create tables - a table for each book with list of "unique" conditions (e.g. 7 tables), table listing all the readers;

design a query/form to question each person (make a unique form OR make a "radial" selection for each reader) with a multiple choice selection button detailing those "conditions"- should be able to select more than one condition since you said there are 14 of them.



Run a query per person from this form to find out who read what book.



Good luck!

Answer 2

since there are the same number of people who have read x number of books who have read y number, and so on, and fifteen total people, they must split into three groups of five, five groups of three, or one group of 15.



So 15 people read three books each could be one solution, unless there is a condition you didn't mention. For the rest of the possibilities, make column B=3*A . (Repeat with B=5*A). In B6, put the sum of column B. Then you can change the numbers in column A (the number of books read by that group) until you come up with a combo that equals 45. You can see that when you repeat for B=5*A ,you need to move the total up to B4.

Answer 3

I don't think there is a way to input that data to excel or word BUT

you can solve this problem using pen and paper and draw it they say there are 15 persons draw 15 squares that represent them and the books two as soon as you start you will have the possibility to know who didn't read what and then you reducing the options for him until you have only what book they did read.

Answer 4

They are just as good as guys. The girls suck at this while guys are better theory is acutally based on the macho principle. Which has existed since the begining of time. Many women buy into it and dont perform well. The fact is that woman and men as groups are equal in eveything mental. So dont believe that psudo science that shows SCANS of brains as proof. The only thing I can think of that girls do not match men on is physical. They just have a differnt composition. They were not made to grow as large as men. But then men cant do some things that women can do. Like give birth. In this case we are just different. That we may prefer not to give birth if given the choice is subjective. but that we cant do it is a fact. so we really are more equal than many men (and some women) may care to admit.

Answer 5

No. not likely. this is a logic question, a bit like a puzzle. You need read the statements carefully to get the solutions. One condition can give you a few hints.

Answer 6

You're asking this on a Friday night? I'm great with Excel but I'm a bit tipsy right now so I'm of no use to you. Maybe I'll edit my answer tomorrow.