Notifications
Clear all

spread sheet

11 Posts
7 Users
0 Reactions
3,789 Views
Posts: 686
Topic starter
(@traneman)
Prominent Member
Joined: 16 years ago
[#30978]

just wondering if anyone has a spread sheet they use to keep track of their elements,pixels,channels and to what controllers they are going to and what ip addresses.

I have a mixture of san devices e682's and renards and I want to use a wireless router and a e1.31 bridge to connect everything. With all the info you have
to put into Vixen and e1.31 it gets kinda hard to keep track of and confusing.

Just thought I would ask if anyone has this already so I don't reinvent the wheel.

Thanks

ps: If you don't have a spread sheet how do you keep track of everything.


10 Replies
Posts: 91
(@davrus)
Estimable Member
Joined: 13 years ago

Sorry, no spreadsheet here, I use a Lotus Notes database (oops - now I should say IBM Notes). I do agree with you, there is so much information that you do need to have something to keep track.


Reply
Electrified3
Posts: 716
(@electrified3)
Prominent Member
Joined: 13 years ago

I had a look through my files from last year and I did save an important one I had. Here is a very rough one I had from last year, not sure if it helps, but can see what I was working towards. Hopefully this year I will better tune things for sure.

In this one I was tracking 25 models all running off of an E682 pixel controller and 1 LOR controller. In mine I had 18 wire frame props on each the left and right sides mirrored to each other, a shared prop in the middle, a 12 channel LOR display in the middle and 2 single channel displays on LOR mirrored Left to Right. So in total 42 models off of a single E682 and a single 16ch LOR.

I totally understand what you are saying, spreadsheet is the only way to keep your sanity.

If you look in the tabs there are like 4 model maps, I never deleted anything, I started where I first thought things went and mapped, then correction 1 I made a copy and corrected, then again was wrong, copied, did over, then again for final copied, did again. I did this to learn from my mistakes, so don't get too confused, saved it to help me from making mistakes in the future, if it helps you great, if not just look at the final. I did some custom calcs to determine start / end channels, might take a bit to understand as well, but gives you an idea what I did and worked for me. If we can transform this into a sheet for all, awesome.

I also left my custom mapping profiles in the tabs at the bottom. This is where I created my custom profiles for models offline to copy and paste back in. In some you will see where I left the background image I used to map to even though not sized correctly anymore I think, might not show up since images are another set of files on my pc. I would create a grid size to map shapes, set the background image to a picture of my shape, layout where pixels should go. Then I would do my best to install them that way and copy my custom model map from there over to my software, if I need to tweak it I could just copy-paste back and forth and tweak things very quickly to what I designed and what was real. Another handy thing I learned, so why not share. Might take a bit to comprehend but was a very handy thing I found.

If you need help understanding anything just let me know. I am all in to create a generic sheet that others can use and learn from.

Hope it helps.

Bill


Reply
Posts: 376
(@gnarmstr)
Reputable Member
Joined: 13 years ago

Just working on mine now for 2014 for Vixen.

May not be for everyone to understand but I do and will make life easy.

There are 2 sheet tabs, Channels is the Hardware side of things and Light Structure is for Vixen configuration.


Reply
Posts: 686
Topic starter
(@traneman)
Prominent Member
Joined: 16 years ago

you are right I don't understand your layout but that doesn't matter, I get the idea of how to set up a spread sheet.

I will be working on mine the next coupe of days and will post it as well.

This will sure keep things more organized and less confusing.

Thanks for the ideas.


Reply
T.D.Sutton
Posts: 445
(@t-d-sutton)
Honorable Member
Joined: 17 years ago

Yes I use a spreadsheet for my lights, it is well over 1700 lines long!! I plan all my channel layouts on it and then hand transfer all the name information & Channel numbering into Vixen. It really makes life easy! This also allows me to compute the number of lights in use, number of channel groups and allocation of different voltage SSR's (12V, 24V, 35V, 230V) all AC!!

I also hold all my spare lights, SSR's and their voltages, powersupplies, electronics spares suppliers and current stocks, as well as my "wish list" of elements/changes for the coming year in it. Our display would be very difficult to manage without Mr "Excel" 🙂

I am afraid it wouldn't make much sense to anyone else, so no point in posting it here 🙁

Terry


Reply
Posts: 686
Topic starter
(@traneman)
Prominent Member
Joined: 16 years ago
Electrified3 wrote:I had a look through my files from last year and I did save an important one I had. Here is a very rough one I had from last year, not sure if it helps, but can see what I was working towards. Hopefully this year I will better tune things for sure.

In this one I was tracking 25 models all running off of an E682 pixel controller and 1 LOR controller. In mine I had 18 wire frame props on each the left and right sides mirrored to each other, a shared prop in the middle, a 12 channel LOR display in the middle and 2 single channel displays on LOR mirrored Left to Right. So in total 42 models off of a single E682 and a single 16ch LOR.

I totally understand what you are saying, spreadsheet is the only way to keep your sanity.

If you look in the tabs there are like 4 model maps, I never deleted anything, I started where I first thought things went and mapped, then correction 1 I made a copy and corrected, then again was wrong, copied, did over, then again for final copied, did again. I did this to learn from my mistakes, so don't get too confused, saved it to help me from making mistakes in the future, if it helps you great, if not just look at the final. I did some custom calcs to determine start / end channels, might take a bit to understand as well, but gives you an idea what I did and worked for me. If we can transform this into a sheet for all, awesome.

I also left my custom mapping profiles in the tabs at the bottom. This is where I created my custom profiles for models offline to copy and paste back in. In some you will see where I left the background image I used to map to even though not sized correctly anymore I think, might not show up since images are another set of files on my pc. I would create a grid size to map shapes, set the background image to a picture of my shape, layout where pixels should go. Then I would do my best to install them that way and copy my custom model map from there over to my software, if I need to tweak it I could just copy-paste back and forth and tweak things very quickly to what I designed and what was real. Another handy thing I learned, so why not share. Might take a bit to comprehend but was a very handy thing I found.

If you need help understanding anything just let me know. I am all in to create a generic sheet that others can use and learn from.

Hope it helps.

Bill

This would be great,but after reading some of the reply's I wonder if a generic spread sheet would work.
It seems we all have a completely differant spread sheet ( one that we understand).
But maybe with some help we could do it ( or you could do it LOL)
I will throw in a couple of basics and maybe others can add to it.

1-Display Item
2- Incan or pixel
3- Qty of strings or pixels
4- Number of channels
5- Voltage
6- Amperage
7-type of controller
Thats just a few off the top of my head,others please add and maybe we can get electrified3 to create it.

Thanks


Reply
Electrified3
Posts: 716
(@electrified3)
Prominent Member
Joined: 13 years ago

Sure, will help with what I can. Maybe come up with a concept that works for most.

I would think a start page with entire layout, then possibly breakdown tabs for pixels vs standard. Might be nice to add in voltage / current draw / distance / extension wire size to also figure out your loads and so forth all in one shot. Or could just build in a power calculator in as another tab?


Reply
DrNeutron
Posts: 2018
(@drneutron)
Noble Member
Joined: 14 years ago

I especially like the idea of a power calculator in another tab.
:thup2:


Reply
JCook
Posts: 1003
(@jcook)
Noble Member
Joined: 13 years ago

I created a little tool to export a list of channels to a text file.

just download and unzip. Nothing to install.

to use:
1. Select your SystemConfig.xml file
2. Click Run
3. Click Copy to File

http://cookfamilylights.com/vixen/vixenreport.zip

If you use it, please let me know how it works for you.


Reply
Page 1 / 2
Share: