+ Reply to Thread
Results 1 to 6 of 6

How and Where do I make a super complex Table hierarchy?

  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    Skyrim
    MS-Off Ver
    Excel 2013
    Posts
    3

    How and Where do I make a super complex Table hierarchy?

    Hi! I actually created this account solely for making this post and asking you guys something, so I hope I have my queries solved.

    BACKGROUND
    Call me nuts, but I have decided to store all that I know of (academically) in a singular Table that is arranged in a hierarchy. I initially started out this plan on Microsoft Word, but it had too many limitations. For one, it had a paper size limit. And frankly speaking, Word really wasn't the ideal software for tables.
    Regardless, I created a preview of a smaller version of what this Table would look like in Word. In this, there is only the names of the disciplines and their subdisciplines. No actual content of every individual discipline yet.
    It is read from top to bottom.
    logictable.png
    If the hierarchy nature is unclear, here is a hierarchy mindmap to clear things up.
    LOGIC.jpg

    QUESTIONS
    1. What software do you think is capable for the job? Spreadsheet software like Excel, or Database software like Access?
    2. Do you think the software you stated is capable of storing ALL information?

    NOTE
    I am asking only for the technical information of software and such, I do not need opinions of what ought to be in the hierarchy (like if you think Maths doesn't belongs in Philosophy).

    Thanks in advance! :)

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How and Where do I make a super complex Table hierarchy?

    Recreating Wikipedia? No, because Wikipedia is flat.

    I'm not sure what the table format buys you, versus an equivalent indented list that could be as deep as necessary. In addition, I'm not sure what the result would encapsulate other than your view of ontology. The structure itself would be as much hindrance as help to anyone else trying to find something.

    In any case, I can't see what Excel could contribute.
    Last edited by shg; 09-18-2013 at 07:32 AM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-17-2013
    Location
    Skyrim
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: How and Where do I make a super complex Table hierarchy?

    1. Nah man, Wikipedia is a mess, with too many contributors as well as the information being stored at various pages instead of my idea of all being in one.
    2. Never mind what the result is. I just want to know how to get it done.
    3. It would not be a hindrance, one can simply Ctrl + F or if one knows the overall hierarchy, one can navigate his way through.
    4. What software, then, do you think can do the job?

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: How and Where do I make a super complex Table hierarchy?

    Personally I tend to agree with shg, however you could do this in a database - not Excel. The problem is that your dataset is hierarchical - Excel is flat and cannot easily store hierarchical data. Databases can model this with with varying degrees of success, in a SQL based system you'd have a table something like this:
    Please Login or Register  to view this content.
    You'd then recurse to build your hierarchical tree - in SQL server you'd use a common table expression for this. The fact that you'd need recursion in SQL rules out Access - you'd need something with a bit more oomphf MySQL, PosgreSQL and SQL Server amongst others would suffice.

    However, you'd probably fare better with a document based database rather than SQL, something like Mongo or CouchDB that allows dynamic tree based data structures (have a look here for a Mongo example - http://docs.mongodb.org/manual/core/data-modeling/).

    Honestly though, I'd bet my back teeth that there's already document management software out there that already allows you to do this.

  5. #5
    Registered User
    Join Date
    09-17-2013
    Location
    Skyrim
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: How and Where do I make a super complex Table hierarchy?

    Oh! So that's the meaning of "flat"! I was wondering what shg meant. Anyway, Kyle123, thanks a lot for the information! Could you recommend a book on SQL for complete beginners like me?

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How and Where do I make a super complex Table hierarchy?

    If you want software to do the job, look for Records Management Software. Here is a place to start: http://www.arma.org/ This is the international organization for Records Management. Excel isn't a very good tool to do this with though, with a small amount of records it could do the job.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Returning a value from a hierarchy table
    By criticalityevent in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-24-2013, 05:31 PM
  2. Excel 2007 : 07 Pivot Table Change to hierarchy?
    By mashley in forum Excel General
    Replies: 0
    Last Post: 11-07-2008, 01:25 PM
  3. how to make a super form
    By kevin_xsw in forum Excel General
    Replies: 2
    Last Post: 07-16-2008, 02:38 AM
  4. hierarchy filters in pivot table
    By yossiybi in forum Excel General
    Replies: 5
    Last Post: 07-13-2008, 09:55 AM
  5. hierarchy between filters in pivot table
    By yossiybi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2008, 06:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1