Jump to content

How to create a worksheet to tabulate lengths of loops.


Recommended Posts

 Problem: See the attached images. I have 3 loops with couplings. I want to know the length of each loop (including the coupling) and need to create a table as shown below. 

 

I have spent hours trying (unsuccessfully) to create a worksheet in my drawing. I can get the worksheet to show up but I can't get anything to sum right and I am really frustrated. I looked at other posts on this website but haven't found any good examples yet.

 

I feel like what I am trying to do is very simple and I just need help finding a video or a more detailed post. If anyone can help me I would be so grateful. :( 

 

Thanks. 

1.png

2.png

Link to comment

@michaelk This version worked! Thank you so much. I am 95% there but I have another question. How did you get the polylines to be named Loop 1, Loop 2, and Loop 3? 

 

Below is a picture of my current progress. So I have each loop length but I want to label them 1 to 8 from left to right. How would I go about this? 

 

Thank you so much again!

3.png

Link to comment

I did it the lazy way.  I just named them in the bottom of the OIP for each loop and called the object name =NAME.

 

If I was doing it for real, I'd probably attach a record format so that I could edit the name in the worksheet.  Object names are read only and are not editable in worksheets.

 

 

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...