Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database problem to be solved... Please help!
I'm trying to show that everyone is somehow connected at my school.
(Jimmy is friends with Timmy. Timmy is brother to Janie. Janie played soccer with Billy.) That kind of thing, except on a large scale. I have all the data, but it's all out of order so no one can make out the connections. My problem is that I want to have excel automatically match up all the connections. I am somewhat experienced with excel, but am new to databases. I don't even know if that's what I should be using. Does anyone know how I can solve this problem? Even automatically pairing names would be great. Any help or ideas would be appreciated! Thanks!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database problem to be solved... Please help!
On Sep 11, 1:18*pm, Nick M. <Nick
wrote: I'm trying to show that everyone is somehow connected at my school. (Jimmy is friends with Timmy. Timmy is brother to Janie. Janie played soccer with Billy.) That kind of thing, except on a large scale. I have all the data, but it's all out of order so no one can make out the connections. My problem is that I want to have excel automatically match up all the connections. I am somewhat experienced with excel, but am new to databases. I don't even know if that's what I should be using. Does anyone know how I can solve this problem? Even automatically pairing names would be great. Any help or ideas would be appreciated! Thanks!! Probably wouldn't use Excel for that. My idea would be to create distances between people. If I know you directly then that's a 1 If someone knows someone and you them at a distance of 2. and recursively fill it out. It'll help you see the connections better, and maybe search for a tree algorithm to see if everyone's connected? How would you define that anyways? If you can get from one person to any other within x amount of people? Good luck! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database problem to be solved... Please help!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
solved problem | Excel Worksheet Functions | |||
problem not solved... CONT.IF depending on the text color | Excel Discussion (Misc queries) | |||
Excel/MSIE problem with add-in, I can't get it solved | Setting up and Configuration of Excel | |||
Excel/MSIE problem with add-in, I can't get it solved | Excel Discussion (Misc queries) | |||
How can the Travelling Salesman Problem be solved using Solver Ad. | Excel Discussion (Misc queries) |