Part insertion using ilogic and link excel file

[Anonymous]

I'll keep it short and sweet. I can do most of the basics in inventor and I'm now trying to use ilogic/link parameters. Heres the job. 

I have a concrete wall panel. 

Each panel is 6ft long.

There are 4 different types of panels - solid, window, retaining and door. 

The client fills in an excel form that has the following parameters. 

Total wall length. 

Window panels spacing (one every 2, 3 4 ... panels)

Door panel spacing (door panel every (5, 10, 15... panels) or specify door panel number.

Retaining panel every 4th panel, retaining panels are all different sizes so my calc determines the size.

Start and end panels to always be retaining based on calcs and they can be different lengths. 

Sometimes they will ask for zero window panels and one door. Sometimes they will as for all window and one door in the middle. 

Sometimes they want three doors in a row and no windows. 

Because the number of panels is based on length, I'm trying to get inventor to automatically keep inserting enough panels until the required length is met and the last panel is adjusted so meet the exact lengths. So standard panels are 6ft. The last panel is always a retaining but will sometimes be 3ft, 4ft, 5ft or 6ft depending on the length that remains. 

I'm trying to use ilogic and excel to drive an assembly. 

Someone inputs the above data into an excel file for me.

Then I open my inventor template and pow - it has all the parts inserted as per the excel file complete with drawing. 

Each time I quote a job I'm spending 2-4 hours drawing up a new set of drawings with the same parts over and over. 

I already have all four panels drawn up and they have a bolted interface that should line up.

I just need general guidance, or links to a similar problem. Where to start. How to get inventor to insert a retaining panel at the start and end, and then insert panels according to how many the client needs. 

Super big thanks in advance.

[kelly.young · Accepted solution]

Hello @Anonymous I see that you are visiting as a new member to the Inventor Forum.
Welcome to the Autodesk Community!

Sounds like you have the design intent created and a few models, now the fun part of putting it all together so it is working and useful.

You can check out some of these examples and inspect the iLogic code used.

collection of ilogic models for beginners

Take a look and see if anything catches your eye or makes sense to use for what you want.

Please select the Accept as Solution button if a post solves your issue or answers your question.