Author Topic: Export TO spreadsheet Channel counts  (Read 1716 times)

Offline bigstott

  • Jr. Member
  • **
  • Posts: 76
    • View Profile
Export TO spreadsheet Channel counts
« on: May 26, 2015, 09:49:58 PM »
I thought this might be useful.

I would like to be able to select any model or all models and export to a spreadsheet the channel count for each model and possibly what universe it belongs to.  This would be useful to validate against the universe setup and to help keep track of used and unused universes and channels. Maybe just be able to export the channel layout in the test tab??

Offline harrison0550

  • Newbie
  • *
  • Posts: 36
    • View Profile
Re: Export TO spreadsheet Channel counts
« Reply #1 on: May 27, 2015, 01:51:53 AM »
You can kinda do that now, maybe not the most elegant way but it works. If you want them separated by models though you would need to go into the test tab and put checks by say singing trees in this example and then save it as singing trees. You could then just open up your xlights networks XML file in notepad plus and all your channels would be listed followed by the model channels you saved in the test tab.



Offline jnealand

  • Hero Member
  • *****
  • Posts: 1421
    • View Profile
Re: Export TO spreadsheet Channel counts
« Reply #2 on: May 27, 2015, 06:58:17 AM »
I would go to preview, then models and use the export to csv file.  I've also found that a useful way to find overlapping channels, by loading the file into excel and then sorting by start channel.
Jim Nealand
Kennesaw, GA

Offline flyinverted

  • Administrator
  • Hero Member
  • *****
  • Posts: 756
    • View Profile
Re: Export TO spreadsheet Channel counts
« Reply #3 on: May 27, 2015, 12:49:21 PM »
I just opened the my nutcracker_rgbeffects.xml with Excel.  The 7th column is the start channel.
Simple enough to add a column to determine the ending channel by multiplying the width x height x 3 + start channel.  Once you see this in Excel it should be obvious. 
Steve Giron
Maricopa County, AZ
xLights user with a boat-load of channels.

Do not ask to know all the answers, but ask to understand the question.