import * as XLSX from 'xlsx';
export type UploadedImportFile = {
    fileName?: string;
    content?: string;
};
export type CostingDetailInput = {
    lineType: string;
    sequence: number;
    lineCode?: string | null;
    lineName: string;
    machineName?: string | null;
    quantity?: number | null;
    unitRate?: number | null;
    length?: number | null;
    width?: number | null;
    thickness?: number | null;
    weightGram?: number | null;
    cavityCount?: number | null;
    noOfSetsPerSheet?: number | null;
    noOfPcsPerStrip?: number | null;
    oneSheetWeight?: number | null;
    stdPrice?: number | null;
    oneSheetRate?: number | null;
    piecesPerKgOrMeter?: number | null;
    runningCostPerHour?: number | null;
    labourCostPerHour?: number | null;
    productionPerHour?: number | null;
    productionCostPerPiece?: number | null;
    oneStripCuttingCharge?: number | null;
    onePieceCuttingCharge?: number | null;
    galvanizingPerKg?: number | null;
    galvanizingPerPiece?: number | null;
    totalCost: number;
    sourceData: Record<string, unknown>;
};
export type CostingRecordInput = {
    itemCode: string;
    itemName: string;
    lookupKey: string;
    sfgType: 'HOLDER' | 'WHEEL';
    inch: string | null;
    finishVariant: string;
    sourceKind: 'HOLDER_SUMMARY' | 'WHEEL_SUMMARY';
    plateCodes: string[];
    materialCost: number;
    machineCost: number;
    coatingCost: number;
    totalCost: number;
    sourceFile: string;
    sourceData: Record<string, unknown>;
    details: CostingDetailInput[];
};
export declare function readWorkbookFromContent(file: UploadedImportFile): XLSX.WorkBook;
export declare function parseHolderSummary(file: UploadedImportFile): CostingRecordInput[];
export declare function parseWheelSummary(file: UploadedImportFile): CostingRecordInput[];
export declare function normalizeLookupKey(value: unknown): string;
export declare function detectFinishVariant(value: unknown, fallback?: string): string;
export declare function inferInch(value: unknown): string | null;
export declare function safeCode(value: unknown): string;
export declare function clean(value: unknown): string;
export declare function parseNumber(value: unknown, fallback: number): number;
export declare function round(value: number): number;