SPB Git

Repository Public

Support.swift 3.2 KB 80 lines swift

1import Foundation2import Testing3import SheetCore4import SheetUI5import AnalysisKit6import FunctionsNumeric7import FunctionsLookup8@testable import WhatIfTools910/// Profit model on sheet "M":  B1 price 50 · B2 units 1000 · B3 unit cost 30 · B4 fixed 1200011/// B5 profit = B1*B2-B3*B2-B4 (= 8000) · B6 = -(B2-200)*(B2-800) (roots 200 and 800) · B7 = 5 (constant formula) · B8 = PMT(...)12@MainActor func makeModel() -> WorkbookSession {13    NumericFunctions.register()14    FinancialFunctions.register()15    let session = WorkbookSession(workbook: Workbook(sheetNames: ["M", "Other"]), locale: Locale(identifier: "en_US"))16    let rows: [(String, String)] = [17        ("Price", "50"), ("Units", "1000"), ("Unit cost", "30"), ("Fixed", "12000"),18        ("Profit", "=B1*B2-B3*B2-B4"), ("Curve", "=-(B2-200)*(B2-800)"), ("Constant", "=2+3"), ("Payment", "=PMT(0.06/12,B2/10,-B4)"),19    ]20    session.perform("Fill") { e in21        for (r, row) in rows.enumerated() {22            e.set(sheet: 0, row: r, col: 0, .value(.text(row.0)))23            try? e.setInput(sheet: 0, row: r, col: 1, row.1, parser: session.parser)24        }25    }26    session.engine.clearUndoHistory()27    return session28}2930/// Every cell of every sheet (value bit pattern, formula text, style) plus attachments, to compare workbook states.31func snapshot(_ wb: Workbook) -> [String] {32    var out = [String]()33    for s in wb.sheets {34        var cells = [String]()35        s.cells.forEachAll { r, c, cell in36            let v: String = { if case .number(let n) = cell.computed { return String(n.bitPattern) } else { return "\(cell.computed)" } }()37            cells.append("\(r),\(c)=\(v)|\(cell.formula?.expr.formulaText() ?? "")|\(cell.style)")38        }39        out.append(s.name + ":" + cells.sorted().joined(separator: ";"))40    }41    out.append("attachments:" + wb.attachments.keys.sorted().joined(separator: ","))42    return out43}4445struct LiveState: Equatable {46    var cells: [String]47    var changeCount: Int48    var canUndo: Bool49    var canRedo: Bool50    var undoLabel: String?51    @MainActor init(_ s: WorkbookSession) {52        cells = snapshot(s.workbook); changeCount = s.engine.changeCount; canUndo = s.engine.canUndo; canRedo = s.engine.canRedo; undoLabel = s.engine.undoLabel53    }54}5556@MainActor func run(_ tool: ToolDescriptor, _ session: WorkbookSession, _ fill: (inout FormValues) -> Void,57                    isCancelled: @escaping @Sendable () -> Bool = { false }) throws -> ToolResult {58    var v = FormValues(defaults: tool.fields)59    fill(&v)60    return try tool.run(try ToolInputResolver.resolve(tool, values: v, session: session, isCancelled: isCancelled))61}6263func number(_ v: Value?) -> Double { v?.numberValue ?? .nan }6465extension ToolResult {66    func metric(_ label: String) -> Double {67        for b in blocks { if case .metrics(let m) = b, let hit = m.first(where: { $0.label == label }) { return hit.value.numberValue ?? .nan } }68        return .nan69    }70    var warnings: [String] {71        blocks.compactMap { if case .text(let t) = $0, t.kind == .warning { return t.lines.joined(separator: " ") } else { return nil } }72    }73}7475final class Counter: @unchecked Sendable {76    private var n = 077    private let lock = NSLock()78    func next() -> Int { lock.lock(); defer { lock.unlock() }; n += 1; return n }79}80
Files main
Menu

Theme