NEW FORMULA (Testers are appreciated, excel required)

[Pmal027]

Hi, i have done this formula for growdiaries to replace their current one as stats tend to break down when it comes to SOG grows or any type of grow where you have multiple plants in 1 tent, or have 2 diaries going with the same growdiary.

All i'm asking is for people to run their data thru the formula, its as easy as filling the red boxes, and check in the green boxes bellow if the data makes any sense.
Anyone with mathematical knowledge and willing to give some input is also deeply appreciated.

p.s. don't waste ur time downloading the excel file if you do not have office on your computer as it will not let you open/edit the file in order for the calculations to take place.

Cheers.

Download link:


Preview:

 

[Pmal027]

The file you download comes as a blank sheet for calculation, just input the data and ur set.(make sure to use a comma [,] instead of a dot [.] for decimal units)

Description:
Total tent area: 80cm x 80cm tent = 0,64 m2 area
Number of plants in diary: use number of plants of wich you wish to calculate the eficiency of
Total number of plants: use total number of plants under the grow light
Light wattage: number of watts your light has, phlizon 1000w has 250 true wats

If you have 3 plants 1 of strain A yielding a total of 79g and 2 of strain B yielding a total of 198g and wish to compare them for example, you have a 1m2 x 1m2 tent with a 500w light, you set it as:

A:
Total tent area- 1
Number of plants in diary- 1
Total number of plants in setup- 3
Light wattage- 500
Dried grams- 79

2:
Total tent area- 1
Number of plants in diary- 2
Total number of plants in setup- 3
Light wattage- 500
Dried grams- 198