By Omnia on Saturday, 29 December 2018
Posted in Planting
Replies 10
Likes 0
Views 4.2K
Votes 1

Hello, is it possible to add a formula in the plant field? ..

For example i want to get the total density of a plant group ( by multiplying the quantity by the density for 1), 

So i made a field for the quantity and another for the density per plant, Is there any way to make a field for the total density so that i won't write it manually? 

Noting that i need this info. to be shown in the plant label ... thanks 

Omnia,

 

I see, I understand perfectly now.

The "Total Density" is just the Quantity that the label already can provide, so that one is taken care of.

We will need to add the ability for the label to have tags of "Density" and "Area", so that you can display all three in one label.

This is no problem, and will be done this week.

 

Regards,

 

--J

·
5 years ago
·
0 Likes
·
-1 Votes
·
0 Comments
·

Omnia,

 

I'm a little unclear on what the Density refers to.  Currently, the schedule and the plant label can include a groundcover Density, defined as the number of plants per square meter.  If you could clarify what exactly it is, that would help.

We don't have the ability to put a formula into a user field currently.  The entire system would need rather intensive changes, as currently the field values are simply chosen from a dropdown list.  Formulas would need to be ideally grouped together, and have a display value other than the equation.  And of course the tools to edit it from the Plant Sizes Preferences screen, and then to have the Manager, Edit Plant, Schedule, and Labeling tools all correctly respect it.  Just saying that in terms of implementing it, it is unfortunately a rather involved project.

So if I can understand more of what you are after, we might be able to come up with some sort of solution.

 

--J

·
5 years ago
·
0 Likes
·
-1 Votes
·
0 Comments
·

Hello Jeremiah,

sorry if i was unclear, yes i am talking about the density as the number of plants per square meter

You will find attached a customized plant label that i made, i want those data to be be shown in the plant label; The area, the plant abbreviation , the density per m2, and the total density.

i know that if i added the plant spacing and the actual size pf the plant , that the quantity here will represent the total density, but i want to show the area too in the label including the density/m2

so, Is there a way that i can do this label using landfx?

·
5 years ago
·
0 Likes
·
-1 Votes
·
0 Comments
·

Jeremiah, thanks a lot for your consideration , looking forward to adding this as it would be very useful.

I have another question related to this one, if i don't know the spacing of the plants but i know the density per m2.
Is there a way to calculate the total density automatically and show it on the plant label 

·
5 years ago
·
0 Likes
·
-1 Votes
·
0 Comments
·

Omnia,

 

I think the best way to do that would be to use a formula in Excel.

I came up with the following:

=ROUND(1000 * SQRT(1 / (A1 * 0.866 * 1.1111)), 0)

 

With that in an Excel sheet, I entered 3.2 as the Density into cell A1, and it reported the Spacing as 570mm.

 

Regards,

 

--J

·
5 years ago
·
0 Likes
·
-1 Votes
·
0 Comments
·

Thanks a lot Jeremiah, Ive tried the new update in the attributes of the AREA and the DENSITY, They worked.

Also the equation is perfect but can u tell me what does the 1.1111 refer to ?


regards,

Omnia

·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·

Omnia,

 

The 1.1111 multiplier is what we found is necessary for more accurate quantities.  Without it, the true triangular spacing equation is essentially counting half-plants at each edge.  You can read more on this here.

 

--J

·
5 years ago
·
0 Likes
·
1 Votes
·
0 Comments
·

Thank you Omnia for this qusetion..

and Jeremiah for the answer

i think i went through similar sitiuation that i placed shrubs as individuals and needed the area of these shrubs.. and needed to do calculations using the apace of each plant to get the area of each shrub..

and was wodering that in land f/x planting if we placed shrubs as areas we are able through the schedule to generate the quantities of the shrubs..

 

but the oppsite is not available

that if we placed the shrubs in quantities, i couldnt through the schedule to get the area of these shrubs..

·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·

Nibal,

 

There's actually a great trick to calculating the area of shrubs, by using our Plant Outlines feature.  This is shown at 1:15 in this Power Tip video.

 

--J

·
5 years ago
·
0 Likes
·
1 Votes
·
0 Comments
·

Thanks a lot Jeremiah..

i am honestly enjoying using land F/X..

it makes the life easy

 

 

Nibal

·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post