 |
 |
Chauvet LED FOLLOWSPOT 75 great light for stage FREE DMX CABLE AND STROBE! |  |
 |
US $499.99 | 18d 4h 42m |
 |
12 PK - VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 10' | |
|
US $71.88 | 29d 6h 53m |
 |
18" BLACK SAFETY CABLE SOURCE 4 ETC ALTMAN STAGE LIGHT | |
|
US $2.50 | 12d 13h 34m |
 |
25 BLACK SAFETY CABLE 18" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $56.25 | 29d 9h 47m |
 |
BLACK SAFETY CABLE 30" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $2.50 | 29d 9h 33m |
 |
50 BLACK SAFETY CABLE 30" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $107.50 | 29d 9h 28m |
 |
100 BLACK SAFETY CABLE 18" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $185.00 | 29d 9h 42m |
 |
30 PK - VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 10' | |
|
US $179.70 | 6d 23h 58m |
 |
STAGE LIGHTING DMX LIGHTING CONTROL CABLE 100' (1) | |
|
US $39.00 | 2d 1h 37m |
 |
20 PK - VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 10' | |
|
US $119.80 | 14d 4h 19m |
 |
VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 10' (15-Pk) | |
|
US $89.85 | 14d 4h 19m |
 |
VRL 5 PIN DMX PRO STAGE LIGHTING CABLE 10' - (12 Pack) | |
|
US $95.88 | 16d 6h 21m |
 |
(8-Pk) VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 25' | |
|
US $79.92 | 10d 8h 30m |
 |
100 VELCRO CABLE TIE FOR PAR STAGE LIGHTING | |
|
US $14.75 | 20d 11h 22m |
 |
3 PIN DMX PRO STAGE LIGHTING CABLE 10' - (10 Pack) | |
|
US $59.90 | 1d 4h 39m |
 |
25 BLACK SAFETY CABLE 30" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $56.25 | 29d 9h 30m |
 |
200 BLACK SAFETY CABLE 30" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $330.00 | 29d 9h 10m |
 |
VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 5' (20-Pk) | |
|
US $99.80 | 1d 5h 9m |
 |
SILVER SAFETY CABLE 30" S4 ALTMAN ETC STAGE LIGHTING | |
|
US $2.50 | 13d 9h 52m |
 |
STAGE LIGHTING 5 PIN DMX CABLES 50 ft (2) | |
|
US $39.00 | 2d 1h 34m |
| Powered by phpBay Pro |
|
No items matching your keywords were found.
Stage Lighting Cables
Excel formula help?
Trying to do a spreadsheet for cable needed for lighting a stage.
APS
APS2K
DMX
S400
APS
DMX
I need the formula to add all APS cable, all DMX cable and so on and still allow me to keep each type of cable in random order on the spreadsheet. Tried the =dvarp...not sure how to formulate this.
Thanks
Do you mean you have various cables of certain lengths, and you need to add up how many feet of APS, how many feet of DMX ... and still keep them in the same order on the sheet?
I'm assuming that you have them arranged geographically by which lights they go to and don't want to lose that information.
First, create a range that contains just the cells with lengths - let's call it "cable_length". Then create another range with the cells with the cable type: call it "cable_type"
Use the SUMIF function ...
Syntax: SUMIF(range; criteria; sum_range)
SUMIF(cable_type; "ABX"; cable_length") should get you how many feet o ABX you have. Repeat the formula for each type of cable. You can do this at the side of the data columns.
Range is the range to which the criteria are to be applied. (the cable type you are looking for)
Sum_range is the range from which values are summed.
*********
PS: One way to maintain an order is to add a column called "sort order" and fill it from 1 to whatever ... then you can sort on anything else and restore the original order by sorting on the "sort order" column.
|
|
Chauvet LED FOLLOWSPOT 75 great light for stage FREE DMX CABLE AND STROBE! | |
|
US $499.99 | 18d 4h 42m |
|
12 PK - VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 10' | |
|
US $71.88 | 29d 6h 53m |
|
18" BLACK SAFETY CABLE SOURCE 4 ETC ALTMAN STAGE LIGHT | |
|
US $2.50 | 12d 13h 34m |
|
25 BLACK SAFETY CABLE 18" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $56.25 | 29d 9h 47m |
|
BLACK SAFETY CABLE 30" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $2.50 | 29d 9h 33m |
|
50 BLACK SAFETY CABLE 30" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $107.50 | 29d 9h 28m |
|
100 BLACK SAFETY CABLE 18" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $185.00 | 29d 9h 42m |
|
30 PK - VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 10' | |
|
US $179.70 | 6d 23h 58m |
|
STAGE LIGHTING DMX LIGHTING CONTROL CABLE 100' (1) | |
|
US $39.00 | 2d 1h 37m |
|
20 PK - VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 10' | |
|
US $119.80 | 14d 4h 19m |
|
VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 10' (15-Pk) | |
|
US $89.85 | 14d 4h 19m |
|
VRL 5 PIN DMX PRO STAGE LIGHTING CABLE 10' - (12 Pack) | |
|
US $95.88 | 16d 6h 21m |
|
(8-Pk) VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 25' | |
|
US $79.92 | 10d 8h 30m |
|
100 VELCRO CABLE TIE FOR PAR STAGE LIGHTING | |
|
US $14.75 | 20d 11h 22m |
|
3 PIN DMX PRO STAGE LIGHTING CABLE 10' - (10 Pack) | |
|
US $59.90 | 1d 4h 39m |
|
25 BLACK SAFETY CABLE 30" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $56.25 | 29d 9h 30m |
|
200 BLACK SAFETY CABLE 30" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $330.00 | 29d 9h 10m |
|
VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 5' (20-Pk) | |
|
US $99.80 | 1d 5h 9m |
|
SILVER SAFETY CABLE 30" S4 ALTMAN ETC STAGE LIGHTING | |
|
US $2.50 | 13d 9h 52m |
|
STAGE LIGHTING 5 PIN DMX CABLES 50 ft (2) | |
|
US $39.00 | 2d 1h 34m |
 |
8 LED 36x3W Par 64 Lighting DJ stage Light + dmx cables | |
|
US $1,196.00 | 5d 12h 25m |
 |
100 BLACK SAFETY CABLE 30" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $185.00 | 29d 9h 18m |
 |
VRL 3 PIN DMX PRO STAGE LIGHTING CABLE 25' (4-Pk) | |
|
US $39.96 | 11d 2h 27m |
 |
75 BLACK SAFETY CABLE 18" ALTMAN ETC STAGE LIGHTING DJ | |
|
US $150.00 | 29d 9h 45m |
 |
NEW 30ft XLR DMX CABLES DJ LIGHTING stage lighting | |
|
US $14.95 | 21d 19h 40m |
| Powered by phpBay Pro |
|
No items matching your keywords were found.
| Account limit of 2098 requests per hour exceeded. |
Build a DMX Light Cable Part 2 with DJ Mikey Mike DO It From Scratch Direct Sound
What is the simplest way to draw power (50+ amps) from a house?
I already have a distributor (http://www.furmansound.com/products/pro/power_dstrbtn/powerdist1.php), but need to know how to hook it up. I do not have the funds to hire an electrician to work alongside my lighting and audio techs, and I'm at a point where I'm thinking of just taking career electrician classes just to learn how to be able to draw power from different sources to get to my tech booth and staging equipment if I can't get an answer on how this would be done.
At venues they usually have electricians to give me power, but some events (IE weddings) obviously don't since they're done in homes and I've been having to run 15amp cables all over the house and it's very unprofessional. I'd just like to figure out how to get one main line from the power source to my distro box and I can handle all the electrical loads and balancing from there.
You may want to consider purchasing a generator that can supply you with constant 100 amps (12000 constant watts) and running cord long enough to supply your rack mount distributor with the needed power. That way you will have the flexibility to set up anywhere that the client needs you to. Just remember to get cords that are rated for outdoor use and make sure that they are large enough for the load.
Thx Pheldwyn for posting these live clips. The new songs from Read Leader Dream sounds better in a live setting. Nina's voice really shines through. The stage lighting really compliments the theme and the mood of the songs. Btw, she's looking more and more like Natalie Portman. Can you post the setlist as well in your notes. Thx