SPB Git

Repository Public

Support.swift 3.4 KB 78 lines swift

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
Files main
Menu

Theme