A Light Calculation Chart - The Planted Tank Forum
Old 01-28-2010, 12:10 AM Thread Starter
Wannabe Guru

Join Date: Oct 2006
Location: Ranchi, Jharkhand, India
Posts: 1,009
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.

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 12:35 PM. Reason: CORRECTING LINK
essabee is offline

Old 01-28-2010, 04:39 AM
Planted Tank Guru

Join Date: Dec 2005
Location: Sacramento, CA
Posts: 20,304
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
Old 01-28-2010, 04:51 AM
Planted Tank Obsessed

Join Date: Dec 2009
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.

StillLearning is offline
Old 01-28-2010, 06:21 AM Thread Starter
Wannabe Guru

Join Date: Oct 2006
Location: Ranchi, Jharkhand, India
Posts: 1,009
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.

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
Old 01-28-2010, 04:03 PM
Planted Tank Guru

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
Old 01-28-2010, 05:53 PM
Newbie

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
Old 01-28-2010, 06:22 PM
Planted Member

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
Old 01-28-2010, 07:43 PM
Planted Tank Guru

Join Date: Dec 2005
Location: Sacramento, CA
Posts: 20,304
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
Old 01-29-2010, 09: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
Old 01-29-2010, 11:15 AM
Planted Tank Obsessed

Join Date: Nov 2009
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
Old 01-29-2010, 12:31 PM
Planted Tank Obsessed

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
Old 01-29-2010, 12:41 PM Thread Starter
Wannabe Guru

Join Date: Oct 2006
Location: Ranchi, Jharkhand, India
Posts: 1,009
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
Old 01-29-2010, 02:42 PM
Planted Tank Obsessed

Join Date: Dec 2009
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
Old 01-29-2010, 05:13 PM
Planted Tank Guru

Join Date: Dec 2005
Location: Sacramento, CA
Posts: 20,304
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
Old 01-29-2010, 05: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

Message:
Options

## Register Now

In order to be able to post messages on the The Planted Tank Forum forums, you must first register.

User Name:
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.