Welcome,
Guest
. Please
login
or
register
.
May 25, 2025, 05:25:09 AM
News:
Home
Donate
Wiki
Help
Search
Calendar
Login
Register
Sean Meighan
»
Software
»
Enhancement Requests
»
Export TO spreadsheet Channel counts
« previous
next »
Print
Pages: [
1
]
Go Down
Author
Topic: Export TO spreadsheet Channel counts (Read 1714 times)
bigstott
Jr. Member
Posts: 76
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??
Logged
harrison0550
Newbie
Posts: 36
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.
Logged
jnealand
Hero Member
Posts: 1421
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.
Logged
Jim Nealand
Kennesaw, GA
flyinverted
Administrator
Hero Member
Posts: 756
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.
Logged
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.
Print
Pages: [
1
]
Go Up
« previous
next »
Sean Meighan
»
Software
»
Enhancement Requests
»
Export TO spreadsheet Channel counts