News:

LATEST RELEASE:  FPP 6.3 - Download from here - https://github.com/FalconChristmas/fpp/releases/tag/6.3

+-+-

+-User

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+-Site Stats

Members
Total Members: 15648
Latest: zj023
New This Month: 53
New This Week: 12
New Today: 3
Stats
Total Posts: 128297
Total Topics: 15777
Most Online Today: 52
Most Online Ever: 7634
(January 21, 2020, 02:14:03 AM)
Users Online
Members: 2
Guests: 27
Total: 29

Custom Model using Excel

Started by Roger DeBolt, October 30, 2014, 11:17:46 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Roger DeBolt

Can someone point me in the direction of any video showing how to build a custom model using Excel? I have watched David's amazing video in how he made a whole house model, but I am not using 2811s, just 1804s. Does that matter?  :-[  I am trying to get my roof model made as fast as I can. Thanks for the help!


Roger

smeighan

rgb lights dont matter (3001,2811,2812,tm1804,tm1809,.etc.)

Notice our models do not ask you what type of light, just if it is a rgb light.

Build your models and then move them where you want them in the PREVIEW tab. Press build whole house model. Done.
Sean
Littleton, CO Latest releases http://nutcracker123.com/nutcracker/releases xLights/Nutcracker Forum http://nutcracker123.com/forum/index.php Facebook [url=https://www.facebook.com/groups

Roger DeBolt

Well that is kind of what I thought, but what is confusing me is in David's Excell sheet he has 9 blocks (Square) with the same channel number. So for example 1 block (node) in NC is 3 channels. In David's example it is only 1 channel, or is that just the way that he has his house nodes set up? I understand the NC way and how it works, I am getting lost in the spread sheet. Am I making any sense?


Thanks,
Roger

JonB256

#3
Quote from: rdebolt on October 30, 2014, 12:45:24 PM
Well that is kind of what I thought, but what is confusing me is in David's Excell sheet he has 9 blocks (Square) with the same channel number. So for example 1 block (node) in NC is 3 channels. In David's example it is only 1 channel, or is that just the way that he has his house nodes set up? I understand the NC way and how it works, I am getting lost in the spread sheet. Am I making any sense?


Thanks,
Roger

The reason Dave would repeat Pixel numbers was to "fool" the model into make things appear proportionate in length. Some things have a 2 inch pitch, some have a 4 inch, some are even farther apart. By repeating the numbers, you can make a 20 pixel object (at 2 inch pitch) appear as long as a 10 pixel object with a 4 inch pitch.

or - like Sean says below!
Long time Falcon, FPP and xLights user

smeighan

Example, ws2811, is 150 lights but only 50 channels. To preview it correctly u would enter it as 1,1,1,2,2,2,3,3,3 in the custom model
Sean
Littleton, CO Latest releases http://nutcracker123.com/nutcracker/releases xLights/Nutcracker Forum http://nutcracker123.com/forum/index.php Facebook [url=https://www.facebook.com/groups

neilric99

Sean, when adding your models in excel do you need to use channel numbers i.e 1,2,3 4,5,6 or rgb node channels i.e 1, 4, 7 etc

JonB256

#6
Sean can correct me, but don't think of Custom Models as channels. Think of them a Pixels.  First pixel, Second pixel. 

If you create a model with 12 pixels and number them 1, 2, 3, ... 10, 11, 12  the program knows how to address them because you tell it the "start channel"

You could just as easily always use a Start Channel of 1 but define your Model as   731, 732, 733, 734, 735  (you would have to do the math to get the correct pixel number). The formula is floating around here on on the Nutcracker site. I'll see if I can find and link to it.

http://nutcracker123.com/forum/index.php?topic=405.msg2128#msg2128
Long time Falcon, FPP and xLights user

Roger DeBolt

Maybe this will help someone else. This is the model that I built today. Jon is correct in that in Excel each number is a node. After you copy and paste NC automatically adjusts for channels.

[attachment deleted by admin]

smeighan

Quote from: JonB256 on October 30, 2014, 02:21:03 PM
Sean can correct me, but don't think of Custom Models as channels. Think of them a Pixels.  First pixel, Second pixel. 

If you create a model with 12 pixels and number them 1, 2, 3, ... 10, 11, 12  the program knows how to address them because you tell it the "start channel"

You could just as easily always use a Start Channel of 1 but define your Model as   731, 732, 733, 734, 735  (you would have to do the math to get the correct pixel number). The formula is floating around here on on the Nutcracker site. I'll see if I can find and link to it.


http://nutcracker123.com/forum/index.php?topic=405.msg2128#msg2128

absolute node number = (channel+2)/3;

if you are building a custom model using rgb strings then the numbers are nodes
if you are building a model with single channel strings, then the numbers are channels.


"You could just as easily always use a Start Channel of 1 but define your Model as   731, 732, 733, 734, 735". i would not do that. What happens if you need to change it to start at 500? You need to go and edit every number in your model.

If instead you build the model as start channel of 731 and then enter nodes 1,2,3,4,5 you can easily move the model around later by just changing one number. either method will work

Sean
Littleton, CO Latest releases http://nutcracker123.com/nutcracker/releases xLights/Nutcracker Forum http://nutcracker123.com/forum/index.php Facebook [url=https://www.facebook.com/groups

Roger DeBolt

So what you are saying Sean is in NC start your model with node 731 (or any other absolute node number) as your start channel. Then copy your custom model from Excel into it? Or do the numbers in Excel have to match the numbers in NC? I will play around with this later.


Roger

smeighan

Start all your rgb custom models with 1,2 ,3 .etc. then set that model with a starting channel number. Note all models use. Starting channel number, not a node number. Enter nodes in model, set starting channel number
Sean
Littleton, CO Latest releases http://nutcracker123.com/nutcracker/releases xLights/Nutcracker Forum http://nutcracker123.com/forum/index.php Facebook [url=https://www.facebook.com/groups

David Pitts

The start channel you give the custom model should be one that the formula (startChannel +2)/3 is a whole number not a fraction. The numbers in the grid should always start with 1 and then increment. 1,2,3,4,5....
PixelController, LLC
PixelController.com

smeighan

what dave is saying, if you want to make a whole house model using the custom model method (I wont be doing this this year, i will use daves method instead)

But if you did, you should start all your models on an even multiple of 3

so models could start on 1,4,7,10,13,16 .etc.

So is 500 a good start channel
(500+2)/3 = 167.3333
answer No

Is 499 a good start channel
(499+2)/3 = 167.0
Answer Yes

Starting models on a multiple of 3 is ONLY needed if you plan on doing a whole house model using the spreadsheet/custom model method.

If you use Daves whole house method, you can start models on any channel.
Sean
Littleton, CO Latest releases http://nutcracker123.com/nutcracker/releases xLights/Nutcracker Forum http://nutcracker123.com/forum/index.php Facebook [url=https://www.facebook.com/groups

Support FPP

+- Recent Topics

help getting started, next step? by K-State Fan
Today at 04:42:36 AM

Bug in newest release by tbone321
January 26, 2023, 06:14:26 PM

Cannot Connect to F48V4-NS Through Rasberry Pi by Poporacer
January 26, 2023, 03:13:43 PM

new piCaps in the works? by Bwinter
January 26, 2023, 11:25:32 AM

DIY voucher request by CaptainMurdoch
January 26, 2023, 11:14:38 AM

Which volume to grow during setup? by RickR
January 26, 2023, 09:55:17 AM

F16v3 Won't boot or power on by chiefwarrant
January 26, 2023, 06:56:34 AM

Simple single Channel DMX Output trigger by info@trans-mission.tv
January 26, 2023, 05:33:54 AM

No network by JonD
January 25, 2023, 12:54:50 PM

F16v3 screen is dead by JonD
January 25, 2023, 12:49:31 PM

Powered by EzPortal
Powered by SMFPacks Menu Editor Mod