Equipment List Worksheet Format.

[Phil B]

I am trying to set up an Equipment list worksheet of independant virtual parts.

Every time I export it I get rows not columns.

 

Anyone had any luck getting a list to export ?

 

[Scott C. Parker]

Regrettably, the present worksheet layout is all we have, as the independent virtual parts data signifies items absent in the drawing. Rest assured, transposing this information into an improved list format is on our radar.

[halfcoupler]

Indeed the problem is that virtual parts can not be treated like other objects in a worksheet.

A trusspin is a good example: It may exist as Symbol, but no one wants to add 450 trusspins to a drawing.

 

My workaround for this:

- a simple record format with a Count (integer) field and a Name (text)  field

- a separate Layer for additional parts or spare parts.

 

=> Draw any object or symbol, add the record format to this object, fill the Name-field with "trusspin" or whatever and add the amount to the count field.

As drawing object you can even use a textfield "450 trusspins" for this. These objects can be treated in any Database Worksheet like any other object and so it is possible to design any custom equipment list you want. The design layer then gives a great overview of anything additional to be packed in the warhouse. So, as a job handler, you can see what item you have already taken care of and what is still missing.

 

Maybe future versions of virtual parts could integrate this workflow ?

 

Edited October 31, 2023 by halfcoupler

[Scott C. Parker]

8 hours ago, halfcoupler said:

a simple record format with a Count (integer) field and a Name (text)  field

Have you discovered the new EntEquipUniversal record which is now getting attached to all Spotlight objects? You can attach it manually to any other symbol and it'll be pulled into your reports. You can also edit it and add new fields and it'll still get attached to lights, truss, etc. As long as it keeps the same name.

[halfcoupler]

Haven't tested it, - is the 'EntEquipUniversal record' a special record format that has some 'hard code' behind it, or is it just a normal record format ?

[Scott C. Parker]

On 11/5/2023 at 6:33 AM, halfcoupler said:

'hard code' behind it,

It's coded to attach to all Spotlight objects. The data manager is also coded to receive various bits of info from the device it's connected to, which are editable.