Analysis report

[Ehsancad]

Hi all,

we have  a lot of request for Demos for FDS.Can anyone help us to know which relationship/equations used to generate  the analysis results.

We need to know the meaning of the output numbers in the Analysis report.

Thanks

[XuesongBai · Accepted solution]

The formulas in FDS optimization is atathced for your reference.

Thanks,

-Xuesong

[Ehsancad]

Thanks a lot.

Could you tell me where the Excel Template file "Factory.xlt" to Import data to AutoCAD Directly?

[XuesongBai]

Hi,

I think you want to reuse the analysis data. If so, you should use the Export data command to export the datas as .xml format. Now you can directly import the existing .xml data to the new document by Import data command. If you want to import .xls data, you should open your Excel applicationa and new document by selecting My Templates>-Factory.xlt and then import the xml file and save it as xsl file.

Hope that will be helpful to you.

Thanks,

-Xuesong

[Ehsancad]

Thanks,

could you please attach a sample template file?

[XuesongBai · Accepted solution]

Here you go. Please unzip the file due to the forum cannot allow to attach .xlt format file.

-Xuesong

[Ehsancad]

Thanks alot guys

[petestrycharske]

Xuesong,

Is there any type of file that you can send that describes what each item is in the spreadsheet?  For example, I want to know what the "Root" field means on the Routings tab.  I cannot seem to get the routings to import properly, but get the products and stations to import okay.  Any help would be greatly appreciated!

Also, is there a way to import Operation Defaults in Factory Tab of AutoCAD Options, instead of entering in one at a time?  Hope all is well and have a most blessed day!

Peace,

Pete

[XuesongBai]

Hello Pete,

I don't have such a document now. I create the sample Excel file for you reference.

Generally, the item in Excel corresponds to the option in material flow in ACAD.

Specailly, for "Root" item is only marked as True or False to check if it is Job. True means it is Job.

If you define the Operations in Excel, these will be imported into factory operations in ACAD, but the default vaule cannot be linked into ACAD.

Another way is that you can define the operations and default vaules in Factory template in ACAD.

Thanks,

-Xuesong

[petestrycharske]

Xuesong,

I like the idea of taking external data and bringing it into AutoCAD and this really helps clear things up for me.  Is there any plan, in the relatively near future, of putting together some documentation on how to specifically use this feature?  Thanks again for the help and have a most blessed day!

Peace,

Pete

[XuesongBai]

Hi Pete,

I will log the requirement into our backlog.

Could you share some user story with me? Why do you plan in Excel? What benifit will be from the workflow? What function need to be improved?

Thanks,

-Xuesong

[petestrycharske]

Xuesong,

Mostly I just wanted to understand the tool better.  However, I could also see a potential use for customers to have stations, products and routings stored in different spreadsheets, so they could quickly import new operations into an AutoCAD layout.  This might allow them to test out a particular configuration based on a few different product lines to see the layout's overall efficiency.  Trying to see how this could best be used by customers and am not saying this is the only way, but one potential use that could come from this tool.  This is kind of related to that question I asked a while back about storing default operations data to a profile, versus a template, so that a user could quickly import different operations into a layout drawing.  Does this help you understand better where I am coming from?

Sorry for the delayed response and if you have additional questions, please do not hesitate to contact me.  Hope all is well and have a most blessed day!

Peace,

Pete

[XuesongBai]

Hi Pete,

Thank you very much for sharing the background.

And yes, I have understood the situation. Hope more and more users can benifit from the function.

Thanks,

-Xuesong