Forum Discussion
Eriq02
May 10, 2023Copper Contributor
importing PQ diagram into Excel
Hey everybody,
i am currently writing my study work which is about grid connection points of a photovoltaic system. Now i simulated the project in the PowerFactory software and exported the results as an .txt to Excel to recreate the same displayed diagram. But unfortunately i dont get the diagram running. in the end it should look like this.
Btw could somebody please explain how i can show you my excel table with the imported values? its my first time in this forum. The values could be helpful for better unterstanding
- Eriq02Copper ContributorThis is the link to all relevant datas. I hope its okay if the dokuments are in german. if you need some translation, just message me or leave a comment in the excel
https://1drv.ms/f/s!Alc_yFrIdXotgvRy29LPgo3_sGftEw?e=nnqebDIt's not clear to me which data from the workbook you want to display in the chart.
- Eriq02Copper Contributorthe .txt is the export of the PowerFactory diagram. it has the same name as the .png which is the diagram from PowerFactory.
i just took the .txt and made an import to excel. so yea, idk how i use the data to display the same chart as visible on the .png
- Eriq02Copper Contributoryes, but how can i do this? it seems like PowerFactory exported only values for P and not Q which are necessary.
But yea... thanks for trying i gonna try talking to digsilent the maker of powerfactory, maybe they can help me- Eriq02Copper ContributorI just wanted to inform you that my problem was solved. thx for help anyways
You probably cannot attach a workbook here yet, so upload a copy of your workbook (without sensitive information) to a cloud store such as Google Drive, Microsoft OneDrive or Dropbox.
Obtain a share link to the uploaded file and past that link into a reply here.