Thread

I’m not sure which system/process you mean by “planting detail lifecycle” (it could be from a specific app/module like farming, ERP, or CRM workflow).

Can you share one of these so I can answer precisely:
1) the product/module name (or screen name), or  
2) a screenshot / copy-paste of the lifecycle steps as shown in your UI, or  
3) the document/link where “planting detail lifecycle” is defined.

If you just mean the common end-to-end lifecycle, it’s usually along the lines of:
create → draft/edit → submit/approval → scheduled/confirmed → in-progress (work happening) → completed/closed → archived (optional).

I don’t know what you mean by “planting fomular” yet—spelling suggests “planting formula,” but there are many possible meanings.

Do you mean:
1) a mathematical formula used to calculate planting amount (e.g., seeds/seedlings per area, spacing → bed count),
2) a “fertilizer/soil planting” recipe (NPK rates, compost mix),
3) a specific product’s “Planting Formula” screen/model (CRM/ERP/agri system),
or 4) something else?

Tell me which one (and the country/crop/units if it’s a calculation), and I’ll write the exact formula.

Yes—I recognize these as the typical “geometry-based” seed/planting-layout formulas for different container shapes, where you compute how many rows fit across the width and how many seeds fit along each row, then divide total seeds needed by the seeds you can fit per container.

A couple notes based on what you shared:

1) “Square & Rectangular container”
- `rows per container = rounddown(container width / between-row spacing)`
- `seeds per row = round(container length / inrow spacing)`
- `Containers needed = Seeds needed / (seeds per row * rows per container)`
This makes sense if `between-row spacing` is the center-to-center spacing in the width direction, and `inrow spacing` is center-to-center spacing along the length.

2) “Round container”
Your formula structure matches the idea of estimating seeds in a circular area using a circle area term (involving `π * r^2`) divided by the “area per plant” (product of the spacings), with the `0.91` factor acting like an efficiency/packing factor (often used to account for wasted space at the circle corners/edges depending on packing method).
But I can’t fully confirm the exact correctness because the expression you pasted looks a bit inconsistent/duplicative:
- You have `Top diameter / 2` twice (that’s fine because that’s radius squared via `(d/2)*(d/2)`).
- The part that’s unclear is the use of `roundup` vs the exact multiplier and the `in row spacing * between-row spacing` unit interpretation.
- Also “between-row spacing” vs “in row spacing” in a circular layout usually needs careful mapping to the effective “area per plant”.

If you want, paste:
- what “0.91” is intended to represent (or where it came from),
- whether row spacing and in-row spacing are center-to-center,
- and confirm whether you’re packing on a grid or just uniformly distributing plants.

Then I can verify the round-container equation and correct any rounding/parentheses/unit issues.

“Planting nursery” usually means a place (or service/product module) where seedlings are raised before they’re transplanted to the field. In other words: grow young plants in controlled conditions, then move them later.

Typical nursery lifecycle:
seed/propagation → germination → seedling growth (watering/fertilizer/weed control) → hardening-off → grading/sizing → transplant to the main planting area.

If you’re asking in a specific system (like CRM/ERP), tell me the exact screen/module name or fields you see, and I’ll map what “planting nursery” means in that context.

In formulas like your round-container one, the `0.91` is almost always an empirical “packing efficiency / usable area factor”.

Meaning: if you plant on an imaginary rectangular grid (spacing in two directions), not all grid squares fit perfectly inside a circle. Even though the circle area is `πr²`, the actual number of plant positions you can use inside that circle is reduced because plants near the edge don’t fully fit.

So `0.91` is a multiplier that approximates the fraction of the circle area that effectively behaves like usable “grid area” for your chosen spacing/packing pattern.

Where it typically comes from (common sources):
- An assumed efficiency from practice/benchmarks (e.g., based on how many points fit in a circle when using row-and-column spacing).
- A simplification to account for edge losses without doing the full geometry/point-in-circle counting.
- It might be derived from a specific packing layout used in your spreadsheet (sometimes from an old reference or trial-and-error).

Important: different spacing definitions (center-to-center vs edge-to-edge) or different layouts (true grid vs radial planting) can change that factor, so `0.91` may be “right” only for the layout that produced it.

If you tell me what your app/spreadsheet uses for:
- `in row spacing` and `between-row spacing` (center-to-center?),
- whether plants are aligned in a grid or placed randomly within the circle,
I can tell you whether `0.91` is likely correct or whether it should be another value (like ~0.85–0.95).

I can’t directly “show the source” (the original reference) from what you pasted, because you haven’t told me where that spreadsheet/formula lives (app name / repo / file), and I don’t have access to your system’s code or document.

If you tell me one of these, I can locate the implementation and point to the exact lines:
1) the app/system name (and screen/report name) where you saw the formula, or
2) upload/paste the spreadsheet/SQL/script, or
3) if it’s in our codebase: the repo name and the file (or any keyword) to search.

Quickly, I can also interpret what you pasted to “find the source” in your document:
- Search for the string `0.91` or `pi` / `roundup` / `between-row spacing` in your spreadsheet/DB/code.
- The formula you pasted looks like it might be from Excel/Sheets formulas because of `rounddown`, `round`, `roundup`.

Where is it from—Excel/Google Sheets, or a specific web app/CRM/ERP report? If you share that (or paste the exact cell/formula text including the cell name), I’ll tell you where it’s implemented and what it’s doing line-by-line.