Repository Public
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