Repository Public MIT
1// ORIX Calc2// File: Packages/ORIXFeatureWorkspace/Tests/ORIXFeatureWorkspaceTests/TemplateTests.swift3// Description: Every template computes without errors and matches values obtained by direct arithmetic.4//5// Author: Simon-Pierre Boucher6// Contact: contact@spboucher.ai7import Foundation8import Testing9import ORIXExpression10import ORIXUI11import ORIXWorkspace12@testable import ORIXFeatureWorkspace1314@MainActor func makeApp() -> AppModel {15 let suite = "orix.workspace.tests.\(UUID().uuidString)"16 return AppModel(settings: AppSettings(defaults: UserDefaults(suiteName: suite)!), inMemory: true)17}18@MainActor func value(_ sheet: SheetModel, _ name: String) -> Double? {19 sheet.cellDefining(name).flatMap { sheet.result($0.id)?.value?.doubleValue }20}21func close(_ a: Double?, _ b: Double, _ tol: Double = 1e-9) -> Bool {22 guard let a else { return false }23 return abs(a - b) <= tol * max(1, abs(b))24}2526@MainActor @Suite struct TemplateTests {27 @Test(arguments: WorkspaceTemplate.allCases) func computesWithoutErrors(_ template: WorkspaceTemplate) {28 let sheet = SheetModel(document: template.document(), app: makeApp())29 #expect(!sheet.cells.isEmpty)30 for cell in sheet.cells {31 let r = sheet.result(cell.id)32 #expect(r?.error == nil, "\(template.title): \(sheet.label(cell)) → \(r?.error?.description ?? "")")33 switch cell.kind {34 case .formula: #expect(r?.value != nil || r?.isFunction == true, "\(sheet.label(cell)) has no value")35 case .parameter: #expect(r?.value != nil)36 case .table:37 #expect(r?.table?.count == cell.table?.count)38 #expect(r?.table?.allSatisfy { $0.y != nil } == true, "\(template.title): table has undefined rows")39 case .graph, .text: break40 }41 }42 #expect(sheet.cells.contains { $0.kind == .parameter } && sheet.cells.contains { $0.kind == .table } && sheet.cells.contains { $0.kind == .graph })43 // identifiers are fresh for each document44 #expect(Set(template.document().cells.map(\.id)).isDisjoint(with: sheet.cells.map(\.id)))45 }4647 @Test func capitalBudgetingValues() throws {48 let sheet = SheetModel(document: WorkspaceTemplate.capitalBudgeting.document(), app: makeApp())49 let npv = -100000 + 25000 / 1.08 + 30000 / pow(1.08, 2) + 40000 / pow(1.08, 3)50 #expect(close(value(sheet, "NPV"), npv))51 #expect(value(sheet, "Decision") == 0)52 #expect(sheet.result(try #require(sheet.cellDefining("NPV")).id)?.isExact == true)53 let table = try #require(sheet.cells.first { $0.kind == .table })54 let rows = try #require(sheet.result(table.id)?.table)55 for (k, row) in rows.enumerated() {56 let r = 0.02 * Double(k)57 #expect(close(row.x, r, 1e-12))58 #expect(close(row.y, -100000 + 25000 / (1 + r) + 30000 / pow(1 + r, 2) + 40000 / pow(1 + r, 3), 1e-9))59 }60 }6162 @Test func loanComparisonValues() {63 let sheet = SheetModel(document: WorkspaceTemplate.loanComparison.document(), app: makeApp())64 func payment(_ rate: Double) -> Double { let i = rate / 12; return 350000 * i / (1 - pow(1 + i, -300)) }65 let a = payment(0.0549), b = payment(0.0499)66 #expect(close(value(sheet, "PaymentA"), a))67 #expect(close(value(sheet, "PaymentB"), b))68 #expect(close(value(sheet, "TotalB"), b * 300 + 2500))69 #expect(close(value(sheet, "InterestA"), a * 300 - 350000))70 #expect(close(value(sheet, "Savings"), a * 300 - (b * 300 + 2500)))71 }7273 @Test func projectileValues() {74 let sheet = SheetModel(document: WorkspaceTemplate.projectile.document(), app: makeApp())75 #expect(sheet.settings.angleMode == .degrees)76 let g = 9.80665, v = 30.0, a = 45.0 * Double.pi / 18077 #expect(close(value(sheet, "FlightTime"), 2 * v * sin(a) / g))78 #expect(close(value(sheet, "Distance"), v * v * sin(2 * a) / g))79 #expect(close(value(sheet, "MaxHeight"), pow(v * sin(a), 2) / (2 * g)))80 let table = sheet.cells.first { $0.kind == .table }!81 let rows = sheet.result(table.id)!.table!82 #expect(close(rows[3].y, 30 * tan(a) - g * 900 / (2 * pow(v * cos(a), 2))))83 }8485 @Test func unitEconomicsValues() {86 let sheet = SheetModel(document: WorkspaceTemplate.unitEconomics.document(), app: makeApp())87 #expect(value(sheet, "Margin") == 35)88 #expect(close(value(sheet, "LTV"), 35 / 0.04))89 #expect(close(value(sheet, "ValueToCost"), 35 / 0.04 / 220))90 #expect(close(value(sheet, "Payback"), 220.0 / 35))91 #expect(close(value(sheet, "BreakEvenCustomers"), 30000.0 / 35))92 #expect(value(sheet, "MonthlyProfit") == 12000)93 }94}95