A Light Calculation Chart - The Planted Tank Forum
Reply
 
LinkBack Thread Tools Display Modes
post #1 of 42 (permalink) Old 01-28-2010, 01:10 AM Thread Starter
Wannabe Guru
 
essabee's Avatar
 
Join Date: Oct 2006
Location: Ranchi, Jharkhand, India
Posts: 1,002
A Light Calculation Chart

I have created simple “Light Calculation Chart” using simple formulas in MS Excel (I am no computer buff) which might be helpful to fledgling planted tank hobbyist. I wish to share the same with you all.

I have divided the light intensities into 5 categories taking the Lumen per Square Inch (LSI) at the middle depth of the tank. These categories are:-

1. Low Lit – The light will only be sufficient for slow growing low light plants like anubias, java fern, and moss.

2. Medium Lit – The light is sufficient for growing common undemanding aquatic plants.

3. Well Lit – The light is good for all except the difficult demanding aquatic plants. CO2 is not a must in this category but you will find good response if you use it.

4. Bright Lit – CO2 becomes a must and you are free to grow whatever you fancy.

5. Very High Lit – Sky is the limit here as long you don’t evaporate your tank. CO2, Fertilisers and frequent trimming of the plants will enslave you in this category.

I have done away with the ancient Watts per Gallon regime but only for the sake of old times will show it in the results.

Download this chart and save it before using it:

https://spreadsheets.google.com/ccc?...vVDI0ZFE&hl=en

In the tank Volume just type in the white spaces the Length, Height, and Width in inches of the tank you want to find out about. Make sure that the measurement of height is the mean height of water column above the substrate. (if you have the measurement in cm then you can find out the same in inches using the conversion table)

In the total lumen installed chart just type in the white spaces the total wattage used against the type of bulb on the left.

In the reflector chart just choose the type of reflector used by typing 1 in the white space on the right of the reflector type.

Now just scroll down and see the result against the Unknown tank.

You can use the chart to find out about your present tank or plan for your future tank.

If you have a choice, you have a problem, till you elect your choice. No choice, no problem, only consequences, learn to live with them.

Last edited by essabee; 01-29-2010 at 01:35 PM. Reason: CORRECTING LINK
essabee is offline  
Sponsored Links
Advertisement
 
post #2 of 42 (permalink) Old 01-28-2010, 05:39 AM
Planted Tank Guru
 
Hoppy's Avatar
 
Join Date: Dec 2005
Location: Sacramento, CA
Posts: 19,925
I can't get the link to work. Google says it isn't a valid spreadsheet URL. I have no idea how to fix that.

Hoppy
Hoppy is offline  
post #3 of 42 (permalink) Old 01-28-2010, 05:51 AM
Planted Tank Obsessed
 
StillLearning's Avatar
 
Join Date: Dec 2009
Location: Philadelphia, Pa
Posts: 303
Think this is the one suppose to be posted. I was reading the other post they were talking in earlier and it was there.


http://spreadsheets.google.com/ccc?k...0cHFHbWc&hl=en
StillLearning is offline  
post #4 of 42 (permalink) Old 01-28-2010, 07:21 AM Thread Starter
Wannabe Guru
 
essabee's Avatar
 
Join Date: Oct 2006
Location: Ranchi, Jharkhand, India
Posts: 1,002
Quote:
Originally Posted by StillLearning View Post
Think this is the one suppose to be posted. I was reading the other post they were talking in earlier and it was there.


http://spreadsheets.google.com/ccc?k...0cHFHbWc&hl=en

Yes that is the correct link. Thank you.

I have edited my post.

If you have a choice, you have a problem, till you elect your choice. No choice, no problem, only consequences, learn to live with them.
essabee is offline  
post #5 of 42 (permalink) Old 01-28-2010, 05:03 PM
Planted Tank Guru
 
wkndracer's Avatar
 
Join Date: Mar 2009
Location: Citrus County,Florida
Posts: 6,180
interesting, thanks for postig.

The Fraternity of Dirt
If at first you don't succeed,,, keep kicking it
RubberSideDownOnTheLanding,
2-75g planted, 5-55g planted, 5-20g planted, 110g w/30g sump, 8-10g, Refugium, doghouse/newbie
2012 update adding table top pleco pans & a 90g (Nutz)
wkndracer is offline  
post #6 of 42 (permalink) Old 01-28-2010, 06:53 PM
Newbie
 
JMH1998's Avatar
 
Join Date: May 2007
Location: Wolcott, VT
Posts: 4
So I calculated mine to be a 3 low lit, which I expected and it is only anubias that I really have (plan on getting Java Ferns soon) so I guess that is all fine. My question with this situation is will that be enough to get them to pearl? I have been looking everyday and nothing so far and not sure if they will in that condition.
JMH1998 is offline  
post #7 of 42 (permalink) Old 01-28-2010, 07:22 PM
Planted Member
 
tuonor's Avatar
 
Join Date: Nov 2009
Location: Santa Monica, CA
Posts: 285
Nice work.

Not sure if I'm downloading the right version but noticed that cells H22 and I22 seem to be hard coded (and seems like they should link to C6 and G17 respectively). Some of the lumen produced cells also have similar issues.

Easy enought to fix if you download it to excel, but this might be throwing results off in the version that was posted.
tuonor is offline  
post #8 of 42 (permalink) Old 01-28-2010, 08:43 PM
Planted Tank Guru
 
Hoppy's Avatar
 
Join Date: Dec 2005
Location: Sacramento, CA
Posts: 19,925
In case anyone else has the difficulty I had, you can download this as an Excel spreadsheet by clicking the "file" tab at the upper left and selecting that option. I haven't tried using this yet, but I will.

Hoppy
Hoppy is offline  
post #9 of 42 (permalink) Old 01-29-2010, 10:16 AM
Algae Grower
 
Join Date: Dec 2007
Location: Singapore
Posts: 121
The file seems to have been changed from yesterday. Alot of the formulas have been changed to static values, so it doesn't work for me anymore.

E.g. volume of tank was change from a formula to a static value, calculations for various lumens of light has been removed too
illumnae is offline  
post #10 of 42 (permalink) Old 01-29-2010, 12:15 PM
Planted Tank Obsessed
 
newday3000's Avatar
 
Join Date: Nov 2009
Location: Ottawa, Canada
Posts: 476
I justed downloaded and it works fine for me in Excel 2007. Nice tool. This should help many figure out lighting more easily. I vote for a sticky.

75 Gallon High Tech Planted Tank (Journal) 220 Gallon African Cichlid tank (Journal)
Ponds http://www.plantedtank.net/forums/ponds/140285-pond-project-jungle-vines.html pics, pics
newday3000 is offline  
post #11 of 42 (permalink) Old 01-29-2010, 01:31 PM
smp
Planted Tank Obsessed
 
smp's Avatar
 
Join Date: Dec 2009
Location: Evans, West Virginia
Posts: 336
I'm using Excel 2003. Doesn't work for me at all. Won't even calculate the tank capacity correctly. Most items are "static" values.

Steve

90 Gal, 4x65 CFL, 2 Eheim 2215, Pressurized C02
First attempt at planted
smp is offline  
post #12 of 42 (permalink) Old 01-29-2010, 01:41 PM Thread Starter
Wannabe Guru
 
essabee's Avatar
 
Join Date: Oct 2006
Location: Ranchi, Jharkhand, India
Posts: 1,002
I edited the link again. If you don't download and save the chart before use then it gets edited by you and errors creep in. I just do not know how to keep it saved and hope the administrators would help here.

If you have a choice, you have a problem, till you elect your choice. No choice, no problem, only consequences, learn to live with them.
essabee is offline  
post #13 of 42 (permalink) Old 01-29-2010, 03:42 PM
Planted Tank Obsessed
 
StillLearning's Avatar
 
Join Date: Dec 2009
Location: Philadelphia, Pa
Posts: 303
essabee im wondering if saving it from your end then attaching it in a zip file here so others may download this way nothing goes wrong would work better.
StillLearning is offline  
post #14 of 42 (permalink) Old 01-29-2010, 06:13 PM
Planted Tank Guru
 
Hoppy's Avatar
 
Join Date: Dec 2005
Location: Sacramento, CA
Posts: 19,925
Quote:
Originally Posted by StillLearning View Post
essabee im wondering if saving it from your end then attaching it in a zip file here so others may download this way nothing goes wrong would work better.
But, how do you do this? I looked around the site and I can't see where a document file can be saved on this site.

Hoppy
Hoppy is offline  
post #15 of 42 (permalink) Old 01-29-2010, 06:33 PM
Wannabe Guru
 
Join Date: Dec 2008
Location: Raleigh, NC
Posts: 1,241
Quote:
Originally Posted by essabee View Post
I edited the link again. If you don't download and save the chart before use then it gets edited by you and errors creep in. I just do not know how to keep it saved and hope the administrators would help here.
I tried to edit it online and I couldn't. I could only edit it by downloading and using excel.
kid creole is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the The Planted Tank Forum forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in









Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.



Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome