SPB Git

Repository Public

SolveAndTableTests.swift 10.6 KB 187 lines swift

1import Foundation2import Testing3import SheetCore4import SheetUI5import AnalysisKit6@testable import WhatIfTools78@MainActor @Suite struct GoalSeekTests {9    @Test func findsTheAnalyticSolutionWithoutTouchingTheWorkbook() throws {10        let s = makeModel()11        // make a redo entry so that the redo stack is observable12        s.perform("Edit") { $0.set(sheet: 0, row: 0, col: 3, .value(.number(1))) }13        s.undo()14        let before = LiveState(s)15        #expect(before.canRedo && !before.canUndo)16        let r = try run(GoalSeekTool.descriptor, s) { v in v.set("set", text: "M!B5"); v.set("target", number: 0); v.set("changing", text: "B2") }17        #expect(abs(r.metric("Solution") - 600) < 1e-7)                       // F / (p − c) = 12000 / 2018        #expect(abs(r.metric("Achieved value")) < 1e-6)19        #expect(LiveState(s) == before)                                       // cells, changeCount, undo and redo untouched20        #expect(r.actions.map(\.id) == ["apply"] && r.actions[0].isPrimary)21        #expect(r.table(titled: "Convergence")?.rows.contains { $0.first == .text("Method") } == true)22    }2324    @Test func applyIsExactlyOneUndoableStep() throws {25        let s = makeModel()26        let r = try run(GoalSeekTool.descriptor, s) { v in v.set("set", text: "B5"); v.set("target", number: 4000); v.set("changing", text: "B2") }27        let count = s.engine.changeCount28        let message = try r.actions[0].perform(s)29        #expect(message?.contains("M!B2") == true)30        #expect(abs(number(s.workbook.sheets[0].value(1, 1)) - 800) < 1e-7)31        #expect(abs(number(s.workbook.sheets[0].value(4, 1)) - 4000) < 1e-6)  // recalculated32        #expect(s.engine.undoLabel == "Goal Seek" && s.engine.changeCount > count)33        s.undo()34        #expect(s.workbook.sheets[0].value(1, 1) == .number(1000) && s.workbook.sheets[0].value(4, 1) == .number(8000))35        #expect(!s.engine.canUndo)                                            // it was a single step36        s.redo()37        #expect(abs(number(s.workbook.sheets[0].value(1, 1)) - 800) < 1e-7)38    }3940    @Test func reportsWhenNoSolutionExists() throws {41        let s = makeModel()42        let before = LiveState(s)43        let r = try run(GoalSeekTool.descriptor, s) { v in v.set("set", text: "B7"); v.set("target", number: 10); v.set("changing", text: "B2") }44        #expect(r.actions.isEmpty)45        #expect(r.warnings.count == 1)46        #expect(r.table(titled: "Convergence")?.rows.contains { $0 == [.text("Status"), .text("No solution found")] } == true)47        #expect(LiveState(s) == before)48    }4950    @Test func rejectsInvalidCells() {51        let s = makeModel()52        #expect(throws: ToolError.self) {     // changing cell holds a formula53            try run(GoalSeekTool.descriptor, s) { v in v.set("set", text: "B5"); v.set("target", number: 0); v.set("changing", text: "B6") }54        }55        #expect(throws: ToolError.self) {     // set cell is a constant56            try run(GoalSeekTool.descriptor, s) { v in v.set("set", text: "B1"); v.set("target", number: 0); v.set("changing", text: "B2") }57        }58        #expect(throws: ToolError.self) {     // text in the changing cell59            try run(GoalSeekTool.descriptor, s) { v in v.set("set", text: "B5"); v.set("target", number: 0); v.set("changing", text: "A2") }60        }61        #expect(throws: ToolError.self) {     // missing reference62            try run(GoalSeekTool.descriptor, s) { v in v.set("set", text: ""); v.set("target", number: 0); v.set("changing", text: "B2") }63        }64    }65}6667@MainActor @Suite struct BreakEvenTests {68    @Test func singleSearchMatchesFixedCostsOverMargin() throws {69        let s = makeModel()70        let before = LiveState(s)71        let r = try run(BreakEvenTool.descriptor, s) { v in v.set("changing", text: "B2"); v.set("output", text: "B5"); v.set("target", number: 0) }72        let t = try #require(r.table(titled: "Break-even points"))73        #expect(t.rows.count == 2 && abs(number(t.rows[1][1]) - 600) < 1e-7)74        #expect(r.charts.count == 1)75        #expect(LiveState(s) == before)76    }7778    @Test func rangeScanFindsEveryCrossing() throws {79        let s = makeModel()80        let r = try run(BreakEvenTool.descriptor, s) { v in81            v.set("changing", text: "B2"); v.set("output", text: "B6"); v.set("target", number: 0)82            v.set("scan", bool: true); v.set("min", number: 0); v.set("max", number: 1000); v.set("steps", int: 37)83        }84        let t = try #require(r.table(titled: "Break-even points"))85        #expect(t.rows.count == 3)86        #expect(abs(number(t.rows[1][1]) - 200) < 1e-7 && abs(number(t.rows[2][1]) - 800) < 1e-7)87    }8889    @Test func targetCanBeAnotherCellAndNoCrossingIsReported() throws {90        let s = makeModel()91        // profit (B5) equals fixed costs (B4) when 20·u − 12000 = 12000 → u = 120092        let r = try run(BreakEvenTool.descriptor, s) { v in93            v.set("changing", text: "B2"); v.set("output", text: "B5"); v.set("targetKind", choice: "cell"); v.set("targetCell", text: "B4")94        }95        #expect(abs(number(r.table(titled: "Break-even points")?.rows[1][1]) - 1200) < 1e-6)96        let none = try run(BreakEvenTool.descriptor, s) { v in97            v.set("changing", text: "B2"); v.set("output", text: "B6"); v.set("target", number: 0)98            v.set("scan", bool: true); v.set("min", number: 300); v.set("max", number: 700); v.set("steps", int: 20)99        }100        #expect(none.table(titled: "Break-even points") == nil && none.warnings.count == 1)101        #expect(throws: ToolError.self) {102            try run(BreakEvenTool.descriptor, s) { v in103                v.set("changing", text: "B2"); v.set("output", text: "B6"); v.set("scan", bool: true); v.set("min", number: 5); v.set("max", number: 1)104            }105        }106    }107}108109@MainActor @Suite struct DataTableTests {110    @Test func oneVariableTableMatchesTheModelAlgebra() throws {111        let s = makeModel()112        let before = LiveState(s)113        let r = try run(DataTableTools.oneVariable, s) { v in v.set("input", text: "B2"); v.set("values", text: "500; 600; 1000"); v.set("outputs", text: "B5, B6") }114        let t = try #require(r.table(titled: "Data table"))115        #expect(t.rows[0] == [.text("Units"), .text("Profit"), .text("Curve")])116        #expect(t.rows[1] == [.number(500), .number(-2000), .number(90_000)])117        #expect(t.rows[2] == [.number(600), .number(0), .number(80_000)])118        #expect(t.rows[3] == [.number(1000), .number(8000), .number(-160_000)])119        // the note names the input cell and the output formulas120        let notes = r.blocks.compactMap { if case .text(let b) = $0 { b.lines } else { nil } }.flatMap { $0 }.joined(separator: "\n")121        #expect(notes.contains("M!B2") && notes.contains("=B1*B2-B3*B2-B4"))122        #expect(r.charts.count == 1)123        #expect(LiveState(s) == before)124    }125126    @Test func valuesCanComeFromARange() throws {127        let s = makeModel()128        s.perform("Values") { e in for (i, x) in [100.0, 200, 300].enumerated() { e.set(sheet: 0, row: i, col: 5, .value(.number(x))) } }129        let r = try run(DataTableTools.oneVariable, s) { v in v.set("input", text: "B2"); v.set("values", text: "F1:F3"); v.set("outputs", text: "B5") }130        #expect(r.table(titled: "Data table")?.rows.dropFirst().map { $0[1] } == [.number(-10_000), .number(-8000), .number(-6000)])131        #expect(throws: ToolError.self) { try run(DataTableTools.oneVariable, s) { v in v.set("input", text: "B2"); v.set("values", text: "abc"); v.set("outputs", text: "B5") } }132        #expect(throws: ToolError.self) { try run(DataTableTools.oneVariable, s) { v in v.set("input", text: "B5"); v.set("values", text: "1;2"); v.set("outputs", text: "B6") } }133    }134135    @Test func twoVariableTableMatchesTheModelAlgebra() throws {136        let s = makeModel()137        let before = LiveState(s)138        let r = try run(DataTableTools.twoVariable, s) { v in139            v.set("rowInput", text: "B1"); v.set("rowValues", text: "40; 50; 60")140            v.set("columnInput", text: "B2"); v.set("columnValues", text: "500; 1000")141            v.set("output", text: "B5")142        }143        let t = try #require(r.tables.first)144        #expect(Array(t.rows[0].dropFirst()) == [.number(40), .number(50), .number(60)])145        #expect(t.rows[1] == [.number(500), .number(-7000), .number(-2000), .number(3000)])      // (p − 30)·500 − 12000146        #expect(t.rows[2] == [.number(1000), .number(-2000), .number(8000), .number(18_000)])147        #expect(LiveState(s) == before)148        #expect(throws: ToolError.self) {149            try run(DataTableTools.twoVariable, s) { v in150                v.set("rowInput", text: "B1"); v.set("rowValues", text: "1"); v.set("columnInput", text: "B1"); v.set("columnValues", text: "2"); v.set("output", text: "B5")151            }152        }153    }154155    @Test func reportIsWrittenAsValuesInOneUndoStep() throws {156        let s = makeModel()157        let r = try run(DataTableTools.oneVariable, s) { v in v.set("input", text: "B2"); v.set("values", text: "500; 1000"); v.set("outputs", text: "B5") }158        let before = snapshot(s.workbook)159        let o = ReportWriter.write(r, to: .newSheet, includeCharts: false, session: s)160        let sh = s.workbook.sheets[o.sheet]161        var formulas = 0, found = false162        sh.cells.forEachAll { _, _, c in if c.formula != nil { formulas += 1 }; if c.value == .number(-2000) { found = true } }163        #expect(formulas == 0 && found)164        s.undo()165        #expect(snapshot(s.workbook) == before)166    }167}168169@MainActor @Suite struct TornadoTests {170    @Test func swingsMatchHandComputation() throws {171        let s = makeModel()172        let before = LiveState(s)173        let r = try run(TornadoTool.descriptor, s) { v in v.set("inputs", text: "B1:B4"); v.set("output", text: "B5"); v.set("percent", number: 0.10) }174        let t = try #require(r.table(titled: "Inputs ranked by swing"))175        // price ±5 × 1000 = 10000 · unit cost ±3 × 1000 = 6000 · units ±100 × 20 = 4000 · fixed ±1200 = 2400176        #expect(t.rows.dropFirst().map { $0[0] } == [.text("Price"), .text("Unit cost"), .text("Units"), .text("Fixed")])177        let swings = t.rows.dropFirst().map { number($0[6]) }178        for (a, b) in zip(swings, [10_000.0, 6000, 4000, 2400]) { #expect(abs(a - b) < 1e-9) }179        #expect(number(t.rows[1][4]) == 3000 && number(t.rows[1][5]) == 13_000)          // output at low / high price180        #expect(abs(number(t.rows[1][7]) - (10_000.0 / 8000) / 0.2) < 1e-12)             // arc elasticity181        #expect(r.metric("Base output") == 8000)182        #expect(r.charts.count == 1)183        #expect(LiveState(s) == before)184        #expect(throws: ToolError.self) { try run(TornadoTool.descriptor, s) { v in v.set("inputs", text: "B1:B5"); v.set("output", text: "B6") } }185    }186}187
Files main
Menu

Theme