Thunderhead Engineering Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Forum moved to https://forum.thunderheadeng.com

Author Topic: Is there an easy way to plot HRR or other measures in excel?  (Read 86 times)

dulfen

  • New Member
  • *
  • Posts: 3
    • View Profile

Hey.

I want to plot the measured HRR and temperature with a line in excel. I have opened the filename_hrr.csv with excel, but all the numbers are copied in the same cell. Is there an easy way to extract only time and hrr from that cell, or do I have to manually copy what I want from each cell for different times?
Logged

Dave McGill

  • Member
  • ***
  • Posts: 161
    • View Profile
    • firemodel.ca
Re: Is there an easy way to plot HRR or other measures in excel?
« Reply #1 on: June 15, 2020, 04:07:27 am »

That shouldn't be happening. Excel has recognized .cvs files and automatically parsed them out for at least the last 10 years. When you look at the folder in Windows Explorer, you should see the Excel symbol beside all of the .cvs files.

If you don't, then change the file association.

right-click -> Properties -> General -> Opens with -> Change -> select Excel

After that, just double click the file to open it in Excel, with the columns properly parsed.
Logged
Dave McGill
firemodel.ca

Timo

  • New Member
  • *
  • Posts: 8
    • View Profile
Re: Is there an easy way to plot HRR or other measures in excel?
« Reply #2 on: June 15, 2020, 06:00:55 am »

I had the same problem and found the solution in changing the regional settings in Windows before opening the FDS-generated csv file (I'm based in Germany)
Make sure to set the format under regional settings to "English". Windows has also recognized the problem:

https://support.microsoft.com/en-us/office/change-the-windows-regional-settings-to-modify-the-appearance-of-some-data-types-edf41006-f6e2-4360-bc1b-30e9e8a54989
Logged