• 10 dec 2017: forum version update. In case of issues use this topic.
  • 30 nov 2017: pilight moved servers. In case of issues use this topic.
Hello There, Guest! Login Register


Graphing plight-debug output using MS-Excel
#1
Here you go a method to plot the output given by pilight-debug. Plotting the output can help determining the modulation.

1) Get the output from pilight-debug
2) Paste the output in MS-Excel
3) Make use of "Text to Columns" feature to get every measurement on one cell
4) Transpose the data from columns to rows
5) Now it is time to create start-end periods. In the attached picture cell C2=0, D2=A1 and then C3=D2+A3, D3=C3+A4. Copy and drag cells C3&D3 for all values on column A.
   
6) On cell F2 set formula 
Code:
=INDEX(C:D, (ROW()+3)/4+1, MOD(INT((ROW()+3)/2),2)+1)

7) On cell G2 set formula
Code:
=MOD(INT(ROW()/2), 2)
8) Columns F and G are the ones to be used to create a "XY (Scatter) / Straight Lines" chart
   
9) Then you should get something like this
   
 
Reply
#2
Nice! This will help users into protocol development.
 
Reply
  


Forum Jump:


Browsing: 1 Guest(s)