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