An ecology unit calculation sheet can produce tidy totals from incompatible inputs. Airflow may be entered in different units, lamp wattage may be labelled as total system consumption, or a stage-resistance value may be mistaken for the complete assembly. For engineering-data teams, unit checks and measurement boundaries matter as much as the formulas.
Electrostatic precipitation, UV-C and activated carbon serve different functions in the treatment train. Each brings different specifications into the project data. The aim is to preserve those meanings as information moves from a product table to a calculation sheet, without implying that the equipment manufacturer supplies software or a universal sizing calculator.
Give every input a unit and an equipment boundary
Identify what each number describes. Store the model, source and unit beside the value, together with a description of the components it covers, so that another person can reconstruct the intended calculation without searching through a catalog or guessing from a column heading.
Polygee's explanation of a kitchen ecology unit distinguishes the assembled treatment train from its individual stages. Electrostatic precipitation, UV-C and activated carbon should therefore remain identifiable in the data rather than being merged into an undifferentiated equipment row.
Separate calculated values from copied specifications. An entered lamp rating, a derived lamp total and a supplier-confirmed assembly load are different fields, even if a particular sheet initially contains only one of them. Missing information should remain visible until the appropriate source supplies it.
Convert airflow once and retain the original value
The UV-module page gives the approximate conversion 1 m³/h ≈ 0.589 CFM, where CFM means cubic feet per minute. Both express volume flow, but the volume unit and time basis differ. Without a unit label, the next user cannot tell what a column's number represents.
Preserve the source airflow in its own field. Label the converted value and use a consistent conversion precision, noting that a rounded conversion factor can produce slightly different displayed results from independently rounded catalog examples. Do not repeatedly convert an already rounded result as the sheet moves between project participants.
Validate the direction of conversion. A formula should transform the source unit into the destination unit, not simply apply whichever factor appears nearby; checking the unit labels and expected relative magnitudes is more reliable than accepting a result because the spreadsheet displays no error.
Also preserve the operating basis. Converting the unit changes the expression of the airflow, not the duty being specified or the capacity of the equipment. It cannot resolve a mismatch between the selected collector and downstream modules.
Do not add serial-stage capacities as though they were output
Polygee publishes the LK-E0 family at 4,000–40,000 m³/h. That is an airflow range for an electrostatic stage, not an amount that can be added to a downstream module's capacity to create a larger serial treatment rating.
The CB30–CB150 activated carbon range covers 3,000–15,000 m³/h. The source table assigns nominal airflow to each model. A calculation sheet should preserve those model ratings and flag a proposed configuration that needs engineering review rather than assign the combined run the collector's maximum.
Check compatibility, not a misleading sum. Where the project requires a different arrangement, its flow distribution and module selection need a project-specific design; a generic spreadsheet formula cannot establish that a set of standard boxes will share the flow appropriately.
Calculate lamp load without relabelling it as total power
The published UV table defines lamp load as lamp count multiplied by 40 W per lamp. It lists UV120 with 10 lamps and 400 W of lamp load, while UV150 has 9 lamps and 360 W. The calculation covers lamp ratings and explicitly excludes ballast losses.
Name the result accordingly. A field labelled lamp load makes the calculation's scope visible; calling the same value total system power loses the exclusion and may also omit the collector, fan and other supplied components. A correct multiplication can still support an incorrect conclusion when its output is mislabelled.
Do not force the rows into a presumed trend. The larger nominal-airflow model in this example has fewer lamps, so model-specific values must be read from the source rather than generated by an assumption that lamp count always rises with airflow.
Preserve the distinction between electrical supply and load. Voltage and frequency identify supply characteristics; they do not, on their own, supply a missing wattage value or justify copying a load from another model.
Keep unreported electrical loads explicitly unresolved
The LK-E page specifies a standard 220 V/50 Hz supply, but its E1 and E0 brochure tables do not publish rated power. It leaves that load to the quotation. Leave an unreported power entry unconfirmed; a spreadsheet default of zero would misstate the source.
The activated carbon module needs no separate electrical connection for adsorption. That fact concerns the module itself. It does not remove the resistance the exhaust fan must overcome or the cost of replacing media, so it cannot justify labelling the whole carbon stage as having no effect on operating energy or expenditure.
Keep different quantities distinct. Instantaneous electrical power, energy consumed over operation and recurring maintenance cost answer different questions. A combined estimate needs the relevant inputs for each rather than a formula that treats absence of a power connection as absence of all operating consequences.
Sum pressure contributions only when their boundaries are compatible
The engineering-stage page lists resistance of 23 Pa for LK-E1, 31 Pa for LK-E0 and 34 Pa for LK-E2. It instructs the reader to include downstream UV-C and activated carbon modules, ductwork and any airflow distribution plate when selecting the fan.
Read the scope before summing. A complete-module figure may already contain a component that another entry represents separately, while a cell-only value may omit components present in the installed assembly. Adding every available pressure number without checking those boundaries can double-count or leave gaps.
The carbon table states that equipment resistance is supplied with the model quotation. Keep that requirement visible in the calculation. A total built while the carbon contribution is missing should not be presented as a confirmed complete-system value.
Retain the airflow basis with each contribution. The responsible ventilation designer needs compatible data for the proposed duty and arrangement; arithmetic alone does not establish that pressure inputs collected from different documents describe comparable operating conditions.
Store design ratings and safety evidence in separate fields
Polygee labels the LK-E efficiency figures as design ratings. Keep that description in the data rather than changing the field to measured efficiency. A separately supplied test report needs its own model, method and conditions before its result can be associated with the selected configuration.
UL Solutions describes UL 8782 as addressing safety aspects of pollution-control assemblies in commercial grease ducts, separately from grease-removal effectiveness. A certification field therefore cannot replace missing performance data or validate a capacity calculation.
Separate evidence types even when they appear together in a brochure. A model-specific listing, company management-system certificate, design rating and laboratory result do not describe the same property. Maintaining their source and scope prevents a later export or report from flattening them into a general claim that the whole system is verified.
Review the inputs before trusting the calculated output
Trace each result back to its inputs. The objective is not to create more fields for their own sake, but to ensure that the calculation preserves the meaning of the engineering data it uses.
- Retain original airflow units and label any converted value.
- Check that serial-stage capacities are assessed for compatibility.
- Keep lamp load separate from complete equipment consumption.
- Leave quotation-dependent power and pressure entries unresolved until supplied.
- Identify the boundaries behind every pressure contribution.
- Distinguish design ratings, test results and safety-document scope.
An ecology unit calculation becomes dependable when its inputs describe the proposed equipment consistently. Unit conversion and multiplication are the easy parts. Keeping the model, measurement boundary and evidence type attached to every result is what prevents a mathematically neat sheet from misrepresenting the treatment installation.
