I’m currently working on developing network graphs for companines within the software space. I hope to derive insights across 1. what companies compete in the most (or least) impacted industries and 2. systematically “bucket” companies by function

I’ve recently completed populating my database of companies by function. Now, I need to clean my data and prepare to feed in to a clean csv file. Notes for myself below:

Order of Operations

• Clean data to preserve relationships between nodes
• build a reusable turk that transforms arrays in to a single column

Parse

• each row begins with a parent node
• each row ends with a count of the number of children nodes in a row
• a = parent (begin)
• b = number of children in row (end)
• a2 = b1 + 1
• results in unique value for each node in system (>400 children)
• next sheet harbors x…x+n
• [ next puzzle: toggle between rows ]
• run index match on b1 through bn (child counter column)
• matched value is equivalent to row number
• if match results in error, select last row letter
• drive indirect to call value
• [next puzzle: toggling columns]
• Next column:   Count up number of occurrences of each row number
• recycle count when last row is not equal to current row