FTA Cutset report to excel export

medini_1047694194

Hi, I have used the FTA cutset report generation script (Test_FTA) to generate the cutsets, the script is running fine, but the cutsets are generated and saved in "fta" folder of the project, which are not accessible (i dont know how to open them). I want these to be exported to EXCEL file (independently for each cutset) using script, please help me on this topic.

medini_1024169437

Hi Manikantha,

before helping with the question: what do you mean by "not accessible"? Could you elaborate a bit what you tried?

In the "Test FTA.js" file the step calculate and save are two separate calls. YOu may simply not save the cutsets in the medini project but IMHO directly stream them into an Excel.

The modle is of type AnalysisModel which inherits from AbstractCutSetModel. You may manually create one of a smaple FTA to see how you cann acces sthe cutsets. In short: you just need to get model.cutSets and iterate over the list and create a row per cutset I think. There is an m2doc report out in this board as well which could help. Maybe you try to first create CSV and put that into clipboard before fiddling with a real Excel file?

Happy Scripting

Jan