Repository Public
1import Foundation2import Testing3import SheetCore4import SheetUI5import Statistics6import AnalysisKit7@testable import StatsModels89/// Session with one sheet filled from rows of numbers / text (nil = blank cell).10@MainActor func session(_ header: [String], _ rows: [[Any?]]) -> WorkbookSession {11 let s = WorkbookSession(workbook: Workbook(sheetNames: ["Data"]), locale: Locale(identifier: "en_US"))12 s.perform("Fill") { e in13 for (c, h) in header.enumerated() { e.set(sheet: 0, row: 0, col: c, .value(.text(h))) }14 for (r, row) in rows.enumerated() { for (c, v) in row.enumerated() {15 switch v {16 case let d as Double: e.set(sheet: 0, row: r + 1, col: c, .value(.number(d)))17 case let i as Int: e.set(sheet: 0, row: r + 1, col: c, .value(.number(Double(i))))18 case let t as String: e.set(sheet: 0, row: r + 1, col: c, .value(.text(t)))19 default: break20 }21 } }22 }23 s.engine.clearUndoHistory()24 return s25}2627@MainActor func run(_ tool: ToolDescriptor, _ s: WorkbookSession, range: String, _ configure: (inout FormValues) -> Void,28 isCancelled: @escaping @Sendable () -> Bool = { false }) throws -> ToolResult {29 var v = FormValues(defaults: tool.fields)30 v.set("data", range: range)31 configure(&v)32 return try tool.run(try ToolInputResolver.resolve(tool, values: v, session: s, isCancelled: isCancelled))33}3435extension ToolResult {36 func table(containing title: String) -> ReportTable? { tables.first { ($0.title ?? "").contains(title) } }37 func metric(_ label: String) -> Double? {38 for b in blocks { if case .metrics(let ms) = b, let m = ms.first(where: { $0.label == label }), case .number(let x) = m.value { return x } }39 return nil40 }41}4243extension ReportTable {44 func number(_ row: Int, _ col: Int) -> Double { rows[row][col].numberValue ?? .nan }45 /// Value in column `col` of the row whose first cell is `label`.46 func value(_ label: String, _ col: Int = 1) -> Double {47 rows.first { $0.first?.textValue == label }?[col].numberValue ?? .nan48 }49 func text(_ label: String, _ col: Int = 1) -> String? { rows.first { $0.first?.textValue == label }?[col].textValue }50}5152func close(_ a: Double, _ b: Double, _ tol: Double = 1e-10) -> Bool { abs(a - b) <= tol * max(1, abs(b)) }5354/// Deterministic synthetic regression data.55struct Synth {56 var y = [Double](), x1 = [Double](), x2 = [Double](), g = [String](), w = [Double](), b = [Double]()57 init(n: Int = 60, seed: UInt64 = 3) {58 var rng = Xoshiro256StarStar(seed: seed)59 let levels = ["a", "b", "c"], effect = [0.0, 2.0, -1.5]60 for i in 0..<n {61 let a = 10 * rng.nextUniform(), c = 5 * rng.nextNormal(), k = i % 362 x1.append(a); x2.append(c); g.append(levels[k]); w.append(0.5 + rng.nextUniform())63 y.append(1 + 2 * a - 0.5 * c + effect[k] + rng.nextNormal())64 b.append(rng.nextUniform() < 1 / (1 + exp(-(a - 5) / 2)) ? 1 : 0)65 }66 }67 var rows: [[Any?]] { y.indices.map { [y[$0], x1[$0], x2[$0], g[$0], w[$0], b[$0]] } }68 static let header = ["y", "x1", "x2", "g", "w", "b"]69}7071func snapshot(_ wb: Workbook) -> [String] {72 wb.sheets.map { s in73 var cells = [String]()74 s.cells.forEachAll { r, c, cell in if cell.hasContent || cell.style != 0 { cells.append("\(r),\(c)=\(cell.computed)|\(cell.style)") } }75 return s.name + ":" + cells.sorted().joined(separator: ";")76 }77}78