A Handy LED Circuit Spreadsheet

Thanks.  This will be a very useful reference for we novices.

Rod, the file opens in Read-Only mode. I can't change anything.

Rich;

I just opened up the uploaded version and it seems to work fine.

Only the yellow cells are unprotected and can be changed. The rest is locked.

What version of office are you using?

It is saved in office 2007 format.

Rod

Worked fine for me, I used OpenOffice.

Cheryl

Hey Rod,

Thanks a million for this spreadsheet. I know I'll use it a lot.  I had no problem opening it with Excel 2003. 

I'm using Open Office 3.2.1. I probably should update to 3.3.0. Cheryl, what version of OO are you using?

The moment I attempt to change data in any of the yellow cells I get an error message which says, "Document open in read-only mode." and I cannot change anything.

EDIT:

Upgraded to OO 3.3 (the current version) and it STILL opens in read-only mode. Strange... 

Rich;

I am totally baffled as to why this is happening.

The sheet protection would not cause that.

Do you have access to another computer that you could try?

Rod

At the top of the screen you should see that is says read only, click on that & you should be alright.

Ken M

Worked fine in Office Pro 2010.

Rich;

I sent you a copy by separate email in case that makes any difference.

Rod

I got it to work. When the file originally opened after the download it was in Read-Only mode. I saved the file and that action removed the Read-Only attribute.

First time for everything...

Cool!  Opened on a MAC with no trouble (Office-Pro something or other).

Mike

Rod,

Thanks a bunch for that.   It will get lots of use as I am converting most of the layout to LEDS.

Ed

NicE Work !

Rufus

Opens just fine in Numbers 09.  Thanks.  Looks good.  I don't wire mine in series, but it is a nice sheet anyway.

Another excellent use for a spreadsheet! Thank YOU!

I just tried it and found a glitch. Once I put an AC Value the sheet calculates a value for H17, the rectified value. After I remove the AC value H17 reverts to 0.0 and locks the formula. This is with Office 2007. 

Forest;

Only one glitch?

I have found a couple and I will upload an updated version in a few days after more feedback.

Regarding your question; if you enter only a space bar stroke in the AC cell, the rectified cell should return #VALUE!, but the balance of the sheet should work just fine.

The sheet is set up so if the Ac cell is empty, it uses the DC value. This means the AC cell should be completely empty, not filled with a "0".

Rod

Thank you Rod. Problem solved. Instead of using the space bar,  I was deleting the value using the backspace button. When done that way it assigns a value of 0.0 to the rectified value box. With 0.0 in this box the DC side will not function. 

Forest

Rod, than you. I download the file and it works very well.

The file works when you save it as an EXCEL Workbook. If you save it as a 1997 - 2003 Workbook, there may be some issues with the macros in the file.

Rod

Just downloaded the file a few hours ago and it works fine.  I use the Microsoft free FileConverter pack which I have on my PC to keep all my spreadsheets to the same level/format and that worked as well. 

Ralph

ire them in parallel -- that is use the normally closed contacts of the switches.
That is the ones that are open when the magnet is close to them
Set it up so that the switch is held open with the magnet when the door is closed. When the door opens the magnet will move away from the switch and turn on the lights. led strip lighting

Power in >>--------- Switch1 ------------ Switch2 
.............................. |......................... |
.............................. L ------------------------T-----------> LED -- Strip
Return power ----------------------------------------…


The yahoo editor is really screwed up so this might not show well
I do not know if you want to switch the + or - side of your led strip lighting outdoor.
Run the power in into one side of each switch take the power out of the other side of each switch
and run that into one side of your 12v led light bars then run the other side of the LED back to the return side of your battery.