AUDIT & CALCULATION ENGINESection 5 / Step 4

Formula Registry & Calculation Traceability

Decoupled calculation engine: Verified Excel formulas, cross-sheet references, and customer-pending definitions

Engine Status

14 Confirmed Formulas Verified

Confirmed Formulas

9 Active

Pending Confirmation

3 Formulas

Cross-Sheet Links

3 Automated

Excel Fidelity

100% Traceable

Status:

Showing 12 of 12 registry entries

Centralized Calculation Registry

Click 'View Trace' on any formula to audit live input values

Calc ID	Calculation Name	Category	Formula Expression	Output	Freq	Status
CALC-REC-001	Total Recovery % Cane Ref: Daily DMR SY 2025-26. (5).xlsx!01.12.2025:G13 (=G10+G11+G12)	PROCESS	Exp. Boiling House Recovery + Recovery in B-Heavy + Recovery in Syrup	%	DAILY	CALCULATED
CALC-BCH-001	B/C Heavy % on Cane Ref: Daily DMR SY 2025-26. (5).xlsx!01.12.2025:G30 (=+G31/G8*100)	PROCESS	(B-Heavy Molasses Production (MT) / Crushing for Sugar (MT)) * 100	%	DAILY	CALCULATED
CALC-CAP-001	Capacity Utilization % (24 Hrs) Ref: Daily DMR SY 2025-26. (5).xlsx!01.12.2025:G39 (=+G6/F6*100)	MILL	(Cane Crushed (MT) / Target Fixed (MT)) * 100	%	DAILY	CALCULATED
CALC-WCRUSH-001	Weekly Cane Crushed Ref: weekly 3rd feb to 9 th feb.xlsx!MILL:D7 (=D8*D6)	MILL	Day Average Crushing for Week (MT) * Number of Days	MT	WEEKLY	CALCULATED
CALC-CROSS-PROC-001	PROCESS Cane Crushed Link Ref: weekly 3rd feb to 9 th feb.xlsx!PROCESS:D7 (=MILL!D7)	PROCESS	MILL!Cane Crushed	MT	WEEKLY	CALCULATED
CALC-CROSS-COGEN-001	CO-GEN Cane Crushing Link Ref: weekly 3rd feb to 9 th feb.xlsx!CO-GEN:D6	CO-GEN	MILL!Cane Crushed	MT	WEEKLY	CALCULATED
CALC-CROSS-BHPWR-001	Boiling House Power Reference Ref: weekly 3rd feb to 9 th feb.xlsx!PROCESS:D31 (='CO-GEN'!E24)	PROCESS	'CO-GEN'!Boiling House Power per Ton	kWh/MT	WEEKLY	CALCULATED
CALC-BAG-SAV-001	Bagasse Saving % on Cane Ref: weekly 1st dec to 7th dec 2025.xlsx!CO-GEN:O17 (=O16/O6*100)	CO-GEN	(Bagasse Stock (MT) / Cane Crushing (MT)) * 100	%	WEEKLY	CALCULATED
CALC-PURITY-001	Juice Purity Calculation Ref: Daily DMR Row 90 & Lab Sampling Sheets	LAB	(Pol % / Brix %) * 100	%	2-HOURLY	CALCULATED
CALC-PEND-TURB-001	Clear Juice Turbidity Chemical Dosage Function Ref: Customer verbal requirement - exact dosing curve pending confirmation	PROCESS	Formula Pending Customer Confirmation	PPM	SHIFT	PENDING
CALC-PEND-HEAT-001	Dynamic Plant Heat Rate Recalculation Ref: weekly CO-GEN Row 66 - season scalar given, thermodynamic dynamic model pending	CO-GEN	Formula Pending Customer Confirmation	Kcal/kWh	WEEKLY	PENDING
CALC-PEND-COLOR-001	Composite Sugar Quality Color Decolorization Index Ref: Customer verbal requirement - weighting factors pending confirmation	LAB	Formula Pending Customer Confirmation	%	DAILY	PENDING

Customer Confirmation Required

PENDING

These business calculations exist in operational workflows but their exact mathematical formulas require customer confirmation

Strict Engineering Rule: Never Guess

Clear Juice Turbidity Dosing Curve

PENDING

Module: PROCESS • ID: CALC-PEND-TURB-001

Customer Confirmation Required: Exact transfer function connecting clear juice turbidity (NTU) & transmittance (%) to clarification flocculant dosage (PPM).

Reference: Customer verbal specification

Dynamic Plant Heat Rate

PENDING

Module: CO-GEN • ID: CALC-PEND-HEAT-001

Customer Confirmation Required: Thermodynamic enthalpy formula calculating plant heat rate from real-time boiler steam enthalpies and turbine electrical generation.

Reference: weekly CO-GEN Row 66

Sugar Quality Decolorization Index

PENDING

Module: LAB / QUALITY • ID: CALC-PEND-COLOR-001

Customer Confirmation Required: Weighted composite color reduction formula from Mixed Juice Colour (IU) through to final Sugar Crystal Grades (S1, S2, M).

Reference: Customer verbal specification