Repository Public
1import Foundation2import Testing3import SheetCore4import FunctionsLookup56/// Reference cases generated by the scripts in `Generators/`: Microsoft Excel results (via the7/// ExcelFinancialFunctions test data), LibreOffice recalculations and independent Python computations.8@Suite struct ReferenceFixtureTests {9 @Test func lookupLibreOffice() throws { try Fixtures.check("lookup_lo", minimum: 800) }10 @Test func dynamicArrays() throws { try Fixtures.check("arrays", minimum: 290) }11 @Test func financial() throws { try Fixtures.check("financial", minimum: 4500) }12 @Test func securities() throws { try Fixtures.check("securities", minimum: 13000) }1314 /// Values computed by Excel itself.15 @Test func excelReference() throws {16 let (count, failures) = try Fixtures.run("excel_reference")17 #expect(count >= 68000, "fixture has only \(count) cases")18 var byFunction = [String: [String]]()19 for f in failures {20 let name = String(f.dropFirst().prefix { $0 != "(" })21 byFunction[name, default: []].append(f)22 }23 let summary = byFunction.sorted { $0.key < $1.key }.map { "\($0.key): \($0.value.count)\n" + $0.value.prefix(4).joined(separator: "\n") }24 #expect(failures.isEmpty, "\(failures.count) of \(count) Excel reference cases failed:\n\(summary.joined(separator: "\n"))")25 }2627 /// Excel's YEARFRAC results against the public day-count API.28 @Test func excelYearFractions() throws {29 let doc = try Fixtures.load("excel_reference")30 let rows = try #require(doc["yearfrac"] as? [[NSNumber]])31 #expect(rows.count > 1000)32 var failures = [String]()33 for row in rows {34 let basis = try #require(DayCount.Basis(rawValue: row[2].intValue))35 let got = DayCount.yearFraction(fromSerial: row[0].doubleValue, toSerial: row[1].doubleValue, basis: basis)36 if !near(got, row[3].doubleValue, 1e-11) { failures.append("\(row[0]) → \(row[1]) basis \(row[2]): got \(got), Excel \(row[3])") }37 }38 #expect(failures.isEmpty, "\(failures.count) of \(rows.count) YEARFRAC cases failed:\n\(failures.prefix(20).joined(separator: "\n"))")39 }40}41