Yes, I saw the simbits, it wasn't helpful. I have 2 excel worksheet, one list 100 parts, another showing utilization of 50 vechicles for the next 120 months (life span of the vehicle). Each vehicle will have those 100 parts that requires some type of maintenance. Every so often maintenance must be performed based upon the frequency of those parts.
How do you traverse the vechicle page both vertially hand horizontally. Plus I need to count up how many parts will be required (with cost) for given year and life span of the vehicle. If i can't get Simio to work, I'll write code.
Attached is an example of the data file.
Parts vs 1.xlsx