Author Topic: Rigol DP832A .ROF file conversion  (Read 239 times)

0 Members and 1 Guest are viewing this topic.

Offline drummerdimitri

  • Frequent Contributor
  • **
  • Posts: 384
  • Country: lb
Rigol DP832A .ROF file conversion
« on: August 11, 2019, 12:02:48 pm »
I would like to import the .ROF file into an excel sheet for analysis but the issue is that Rigol wrote an article in 2015 using an older version of the current excel so the instructions aren't clear after step #16 on page 11 since I get a different menu after I try importing the data from the file.

Can anyone assist me with the conversion?

Thanks!

 

Online JDubU

  • Regular Contributor
  • *
  • Posts: 234
Re: Rigol DP832A .ROF file conversion
« Reply #1 on: August 11, 2019, 12:36:30 pm »
If you post your .ROF file, I might be able to convert it for you.
 
The following users thanked this post: drummerdimitri

Offline tv84

  • Frequent Contributor
  • **
  • Posts: 797
  • Country: pt
Re: Rigol DP832A .ROF file conversion
« Reply #2 on: August 11, 2019, 02:50:36 pm »
That conversion manual is unbelievable!! It would never cross my mind that they publish a conversion method like that one!!!  :palm:  :palm:
 

Offline drummerdimitri

  • Frequent Contributor
  • **
  • Posts: 384
  • Country: lb
Re: Rigol DP832A .ROF file conversion
« Reply #3 on: August 11, 2019, 03:37:37 pm »
If you post your .ROF file, I might be able to convert it for you.

Thanks for offering but I would like to learn how to do it as I will be doing it quite often and don't want to bother others with it every time  :-+
 

Offline drummerdimitri

  • Frequent Contributor
  • **
  • Posts: 384
  • Country: lb
Re: Rigol DP832A .ROF file conversion
« Reply #4 on: August 11, 2019, 03:38:56 pm »
That conversion manual is unbelievable!! It would never cross my mind that they publish a conversion method like that one!!!  :palm:  :palm:

I know right. How ridiculous!

They should just save us the time and have the tool save as a CSV file instead in their next firmware update. What a joke this method is  :palm:
 

Offline tv84

  • Frequent Contributor
  • **
  • Posts: 797
  • Country: pt
Re: Rigol DP832A .ROF file conversion
« Reply #5 on: August 11, 2019, 04:36:38 pm »
If you look at the manual it's very simple to make a prog that does the conversion.

Starting at offset 0x1C, there are a number of little-endian 32bit words, in groups of 6 words (CH1 VOL+CH1 CUR, CH2 VOL+CH2 CUR, CH3 VOL+CH3 CUR).

BTW, their instructions should work on newer Excel versions.
 

Offline drummerdimitri

  • Frequent Contributor
  • **
  • Posts: 384
  • Country: lb
Re: Rigol DP832A .ROF file conversion
« Reply #6 on: August 11, 2019, 11:01:46 pm »
If you look at the manual it's very simple to make a prog that does the conversion.

Starting at offset 0x1C, there are a number of little-endian 32bit words, in groups of 6 words (CH1 VOL+CH1 CUR, CH2 VOL+CH2 CUR, CH3 VOL+CH3 CUR).

BTW, their instructions should work on newer Excel versions.

In the latest excel verison, I don't get the same screen so I cannot follow the same instructions. Need someone who can translate them to be applicable in the latest verison  :-//
 

Online JDubU

  • Regular Contributor
  • *
  • Posts: 234
Re: Rigol DP832A .ROF file conversion
« Reply #7 on: August 12, 2019, 12:13:34 am »
In the latest excel verison, I don't get the same screen so I cannot follow the same instructions. Need someone who can translate them to be applicable in the latest verison  :-//

On page 10 of the instructions it says:

15) Now, open the ReadDPROF.xlsx workbook and select the RawDataFile
Tab (at the bottom):


ReadDPROF.xlsx looks to be a supplied Excel template that has the calculations built into it.  Notice the tabs at the bottom labeled "Calculators" and "RawDataFile".  These calculations are described on page 14 of the instructions.  Apparently that Excel template was available for download when the instructions were written but I did not find it on the Rigol website or via a Google search.


« Last Edit: August 12, 2019, 12:49:57 am by JDubU »
 

Offline thn788

  • Contributor
  • Posts: 28
Re: Rigol DP832A .ROF file conversion
« Reply #8 on: August 12, 2019, 07:36:19 am »
Can't help with how to use Excel, but maybe a better documentation of the file-format might help?!
 


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf