I have a model as shown in the Picture below. The model is made up of SmartSolids. I have attached items to the solids as show in the picture.
I now want export to excel. In the excel sheet I want:
Block Division number and the Volume of the smartsolids.
How can I do this?
I know how to export the schedule and get the block division number and use quantify to get the volumes. But not how I can get them to the same export.
Hello Johan,
Reminder to include the version number you are using in your posts - I see in the DG explorer it looks SELECTseries 5. So I am using Ss5 for the reply.
This workflow helps if you (or someone in your organization) has some expertise in Excel. That being said, I do not have that much expertise in Excel, but with a little Google searching I was able to achieve the result.
Basically I am able to run a quantity report, and run a DataGroup (DG) schedule and in the DG schedule, set up Excel formulas to match the element IDs for the components and pull the quantity data from the quantity report into the DG schedule.
In the DG Explorer you can set up the schedules to utilize an Excel spreadsheet template. In the template I already set up formulas to pull the data from the Quantity Report.
I ran the Quantity report and saved it as "new solid report.xls"
So, in DG Explorer, I created a new schedule named Structural01, I right-click on the schedule and choose Properties:
I choose Edit Schedule Options and add the Properties, in the same order I set up in the Excel template, mine only has 6 properties: ID|Item ID, Element ID, Part Definition, Phasing, Structural Function, Structural Material (the important one is the Element Id).:
I click OK and choose Edit Excel Export Options, this is where I point this schedule to use my Excel template. I choose the "..." button and browse to the template, for me Blocks.xlsx. Finally I set the Insertion Start Cell to My_Blocks:A2 this is the name of the worksheet and the cell I want to start my insertion of my DG data:
My Excel template looks like this before I export:
I named the worksheet in Excel My_Blocks, so my insertion point is in that worksheet in cell A2.
IN EXCEL, I created formulas in Columns H and I. Column H matches and returns the Element ID (this is basically me wanting to visually check that they match) and column I matched the Element ID and returned the Quantity column. The formulas look like this:
Column H: =VLOOKUP(B2,'[new solid report.xls]Detail'!$H$2:$H$7,1,FALSE)
Column I: =IFERROR(VLOOKUP(B2,'[new solid report.xls]Detail'!$H$2:$O$7,8,0),"")
When I export my DG Schedule it look like this:
Even if I sort in DG Explorer by Item ID I get the matching Quantity :
My Quantity report look like this:
So, in my DG schedule I am looking for a row B matching Element ID in row H in the quantity report, I can see this in row H, then I pull the corresponding row in column O of the quantity report to fill in row I of the DG schedule.
Is there an easier way to use this volume in our schedule?